Session Data

Array
(
    [HubSpot] => Array
        (
            [hs_deal_id] => 53342799545
            [hs_company_id] => 48566923600
            [salesorderno] => 
            [repid] => 0064
            [contact_id] => 187428692769
            [contact_email] => nickm@vibecanna.com
            [contact_phone] => 6189735111
            [contact_address] => St. Louis, Missouri, 63147, United States
            [company_name] => Vibecanna
            [company_mas_customer_no] => VIB631A
            [mas_customer_no] => VIB631A
        )

    [form_inputs] => Array
        (
            [initial] => Array
                (
                    [Company] => Vibecanna
                    [Contact_First] => Nick
                    [Contact_Last] => McGinley
                    [Contact_Email] => 
                    [Contact_Phone] => 
                    [contactid] => 
                    [Zip] => 63147
                    [Email] => 
                    [Phone] => 
                    [place_id] => 
                    [customerid] => 217413
                    [mascustnum] => VIB631A
                )

            [gm_search] => Array
                (
                    [gm_account_no] => 217413
                    [mas_cust_no] => VIB631A
                )

            [mas_search] => Array
                (
                    [mas_cust_no] => VIB631A
                    [mas_cust_exists] => true
                )

            [billing] => Array
                (
                    [Company] => Vibecanna
                    [Contact_First] => Nick
                    [Contact_Last] => McGinley
                    [Address1] => 
                    [Address2] => 
                    [Address3] => 
                    [City] => 
                    [State] => 
                    [Zip] => 63147
                    [Country] => USA
                    [Email] => nickm@vibecanna.com
                    [Phone] => (618) 973-5111
                )

            [shipping] => Array
                (
                    [ShipToName] => Vibecanna
                    [Address1] => 
                    [Address2] => 
                    [Address3] => 
                    [Address4] => 
                    [Address5] => 
                    [City] => 
                    [State] => 
                    [Zip] => 63147
                    [Country] => USA
                    [Email] => nickm@vibecanna.com
                    [Phone] => (618) 973-5111
                )

            [leadid] => 
            [summary] => Array
                (
                    [SalesPersonNo] => 0064
                    [ProductLine] => CL
                    [forecasting_likelihood] => 
                    [forecasting_expected_close_date] => 
                    [generate_quote] => true
                    [not_in_mas] => true
                    [delivery_disclaimer] => true
                    [tax_free] => true
                    [freight_estimate] => true
                    [freight_type] => call
                    [lead_time] => 2-3  Weeks, depending on stock and availability.
                    [email_quote_to] => nickm@vibecanna.com
                    [template_id] => 489
                    [email_quote_subject] => Your CleanLeaf CL3000-CF Air Filtration Quote - Flowering Room
                    [files] => 
                    [email_product_literature] => true
                    [includedPDFs] => Array
                        (
                            [0] => {QUOTE}
                            [1] => /mnt/product_media/cleanleaf/pdf/CL2500D-HE Specs 11-13-22.pdf
                            [2] => /mnt/product_media/cleanleaf/pdf/CleanLeafCL2500D-Ducting-Drawing-Top-View.pdf
                            [3] => /mnt/product_media/cleanleaf/pdf/CL2500D-CCPHE Drawing.pdf
                            [4] => /mnt/product_media/cleanleaf/pdf/CL_TDS Disposable Panel Filters_Nov-2022.pdf
                            [5] => /mnt/product_media/cleanleaf/pdf/CL_TDS HVH-H13 Filter-NOv-2022.pdf
                            [6] => /mnt/product_media/cleanleaf/pdf/CL_TDS Bag filters MERV15-Nov-2022.pdf
                            [7] => /mnt/product_media/cleanleaf/pdf/CL_TDS MPH13 HHC Filters_Nov-2022.pdf
                            [8] => /mnt/product_media/cleanleaf/pdf/CL2500D-series-owners-manual2.pdf
                            [9] => /mnt/product_media/cleanleaf/pdf/cleanleaf-warranty-card.pdf
                            [10] => quote_bundle_separator
                        )

                    [act] => submit_quote
                )

        )

    [last_completed_step] => 5
    [gm_account_no] => 217413
    [mas_cust_no] => VIB631A
    [mas_cust_exists] => true
    [exportid] => 93562
    [masquotenum] => Q062623
    [not_in_mas] => 1
)

POST Data

Array
(
    [SalesPersonNo] => 0064
    [ProductLine] => CL
    [forecasting_likelihood] => 
    [forecasting_expected_close_date] => 
    [generate_quote] => true
    [not_in_mas] => true
    [delivery_disclaimer] => true
    [tax_free] => true
    [freight_estimate] => true
    [freight_type] => call
    [lead_time] => 2-3  Weeks, depending on stock and availability.
    [email_quote_to] => nickm@vibecanna.com
    [template_id] => 489
    [email_quote_subject] => Your CleanLeaf CL3000-CF Air Filtration Quote - Flowering Room
    [email_quote_body] => 

Hello <<&dear>>,

It was great speaking with you.

Attached is your quote and product literature.

Filter Change Schedule

Pre-filter:  2 Flower cycles
Bag:      6 Flower cycles
Carbon:    6 Flower cycles

If you have any questions, don't hesitate to contact me. 

Sincerely,


<<&RepName>>

CleanLeaf
11088 Gravois Industrial Ct.
Saint Louis, MO 63128
866 999-9008 Ext. <<&RepPhoneExt>>
866 422-4099 Fax
<<&RepEmail>>
http://www.cleanleaf.com/



[files] => [email_product_literature] => true [includedPDFs] => Array ( [0] => {QUOTE} [1] => /mnt/product_media/cleanleaf/pdf/CL2500D-HE Specs 11-13-22.pdf [2] => /mnt/product_media/cleanleaf/pdf/CleanLeafCL2500D-Ducting-Drawing-Top-View.pdf [3] => /mnt/product_media/cleanleaf/pdf/CL2500D-CCPHE Drawing.pdf [4] => /mnt/product_media/cleanleaf/pdf/CL_TDS Disposable Panel Filters_Nov-2022.pdf [5] => /mnt/product_media/cleanleaf/pdf/CL_TDS HVH-H13 Filter-NOv-2022.pdf [6] => /mnt/product_media/cleanleaf/pdf/CL_TDS Bag filters MERV15-Nov-2022.pdf [7] => /mnt/product_media/cleanleaf/pdf/CL_TDS MPH13 HHC Filters_Nov-2022.pdf [8] => /mnt/product_media/cleanleaf/pdf/CL2500D-series-owners-manual2.pdf [9] => /mnt/product_media/cleanleaf/pdf/cleanleaf-warranty-card.pdf [10] => quote_bundle_separator ) [act] => submit_quote )

Debug Data

start: 4.0531158447266E-6 secs since start
after getting new exportid ... 93562: 0.098464965820312 secs since start
Session ID: 8nbpac0d3qob39kn0dbubdqvlp
just before engaging cartlink ...: 0.30557513237 secs since start
after most cartlink items ...: 0.30703902244568 secs since start
after getting new so num ...: 0.46334314346313 secs since start
after remaining cartlink items ...: 0.46337914466858 secs since start
SO Number: Q062623
just prior to terms gathering ...: 0.46339511871338 secs since start
after getting customer terms ...: 0.56572508811951 secs since start
Cart Items:
Array
(
    [0] => Array
        (
            [sku] => 
            [name] => Mother Room
4500 X 16 (Max Install Height) = 72,000 Cubic Feet
72,000 X 10 (Air Changes Per Hour) = 720,000 Total Cubic Feet Of Air In Need Of Filtration Per Hour
720,000/ 60 = 12,000 CFM
12,000/1800 = 6.7
7 Units Needed For Mother Room [qty] => 0 [price] => 0.00 [cost] => 0.00 [pdfFileURL] => ) [1] => Array ( [sku] => CL2500D-HE [name] => CleanLeaf Model CL2500D-HE, 2,000 CFM Self-Contained Filtration System, Color: White
Side Access Filter Housing with a year supply of filters, which includes:

4x CLF-6604 (26x26x4 Pleated Pre-filter; changed quarterly)
2x CLF-661698 (26x26x16" 95% 8 Pocket Bag Filter; changed semi-annually)
1x CLF-661699-HHC (26x26x16" 99.99% DOP V-Bank Medical Grade HEPA Filter; changed every 2 years)

*Ambient/Ductable [qty] => 7 [price] => 3,784.00 [cost] => 1,369.19 [pdfFileURL] => ) [2] => Array ( [sku] => [name] => 4500 X 16 (Max Install Height) = 72,000 Cubic Feet
72,000 X 10 (Air Changes Per Hour) = 720,000 Total Cubic Feet Of Air In Need Of Filtration Per Hour
720,000/ 60 = 12,000 CFM
12,000/1800 = 6.7
7 Units Needed For Mother Room [qty] => 0 [price] => 0.00 [cost] => 0.00 [pdfFileURL] => ) [3] => Array ( [sku] => CL2500D-HE [name] => CleanLeaf Model CL2500D-HE, 2,000 CFM Self-Contained Filtration System, Color: White
Side Access Filter Housing with a year supply of filters, which includes:

4x CLF-6604 (26x26x4 Pleated Pre-filter; changed quarterly)
2x CLF-661698 (26x26x16" 95% 8 Pocket Bag Filter; changed semi-annually)
1x CLF-661699-HHC (26x26x16" 99.99% DOP V-Bank Medical Grade HEPA Filter; changed every 2 years)

*Ambient/Ductable [qty] => 7 [price] => 3,784.00 [cost] => 1,369.19 [pdfFileURL] => ) [4] => Array ( [sku] => [name] => 2000 X 16 (Max Install Height) = 32,000 Cubic Feet
32,000 X 10 (Air Changes Per Hour) = 320,000 Total Cubic Feet Of Air In Need Of Filtration Per Hour
320,000/ 60 = 5333 CFM Needed
5333/1800= 2.96
3 Units Needed [qty] => 0 [price] => 0.00 [cost] => 0.00 [pdfFileURL] => ) [5] => Array ( [sku] => CL2500D-HE [name] => CleanLeaf Model CL2500D-HE, 2,000 CFM Self-Contained Filtration System, Color: White
Side Access Filter Housing with a year supply of filters, which includes:

4x CLF-6604 (26x26x4 Pleated Pre-filter; changed quarterly)
2x CLF-661698 (26x26x16" 95% 8 Pocket Bag Filter; changed semi-annually)
1x CLF-661699-HHC (26x26x16" 99.99% DOP V-Bank Medical Grade HEPA Filter; changed every 2 years)

*Ambient/Ductable [qty] => 3 [price] => 3,784.00 [cost] => 1,369.19 [pdfFileURL] => ) [6] => Array ( [sku] => [name] => FIRST SET OF FILTERS PROVIDED WITH UNITS. COSTS BELOW ARE FOR REPLACEMENTS. [qty] => 0 [price] => 0.00 [cost] => 0.00 [pdfFileURL] => ) [7] => Array ( [sku] => CLF-2500DHE-1YRPCK [name] => 1 year pack of filters for CL2500D-HE
Includes:
4x CLF-6604 (26x26x4 Pleated Prefilter; changed quarterly)
2x CLF-661698 (26x26x16" 95% 8 Pocket Bag Filter; changed semi-annually)
*Filter configurations and change-out times are based on standard recommendations. Yours may vary, if unsure, please contact your salesperson. [qty] => 0 [price] => 271.96 [cost] => 115.98 [pdfFileURL] => ) [8] => Array ( [sku] => CLF-661699-HHC [name] => 26x26x16" 99.99% DOP V-Bank Medical Grade HEPA Filter [qty] => 0 [price] => 259.00 [cost] => 103.31 [pdfFileURL] => ) )

not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q062623','CL2500D-HE','CleanLeaf Model CL2500D-HE, 2,000 CFM Self-Contained Filtration System, Color: White Side Access Filter Housing with a year supply of filters, which includes: 4x CLF-6604 (26x26x4 Pleated Pre-filter; changed quarterly) 2x CLF-661698 (26x26x16" 95% 8 Pocket Bag Filter; changed semi-annually) 1x CLF-661699-HHC (26x26x16" 99.99% DOP V-Bank Medical Grade HEPA Filter; changed every 2 years) *Ambient/Ductable','Y','1369.19','7','7','3784.00','26488.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q062623','CL2500D-HE','CleanLeaf Model CL2500D-HE, 2,000 CFM Self-Contained Filtration System, Color: White Side Access Filter Housing with a year supply of filters, which includes: 4x CLF-6604 (26x26x4 Pleated Pre-filter; changed quarterly) 2x CLF-661698 (26x26x16" 95% 8 Pocket Bag Filter; changed semi-annually) 1x CLF-661699-HHC (26x26x16" 99.99% DOP V-Bank Medical Grade HEPA Filter; changed every 2 years) *Ambient/Ductable','Y','1369.19','7','7','3784.00','26488.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q062623','CL2500D-HE','CleanLeaf Model CL2500D-HE, 2,000 CFM Self-Contained Filtration System, Color: White Side Access Filter Housing with a year supply of filters, which includes: 4x CLF-6604 (26x26x4 Pleated Pre-filter; changed quarterly) 2x CLF-661698 (26x26x16" 95% 8 Pocket Bag Filter; changed semi-annually) 1x CLF-661699-HHC (26x26x16" 99.99% DOP V-Bank Medical Grade HEPA Filter; changed every 2 years) *Ambient/Ductable','Y','1369.19','3','3','3784.00','11352.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q062623','CLF-2500DHE-1YRPCK','1 year pack of filters for CL2500D-HE Includes: 4x CLF-6604 (26x26x4 Pleated Prefilter; changed quarterly) 2x CLF-661698 (26x26x16" 95% 8 Pocket Bag Filter; changed semi-annually) *Filter configurations and change-out times are based on standard recommendations. Yours may vary, if unsure, please contact your salesperson.','Y','115.98','0','0','271.96','0.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q062623','CLF-661699-HHC','26x26x16" 99.99% DOP V-Bank Medical Grade HEPA Filter','Y','103.31','0','0','259.00','0.00','1')
save the exported shopping cart ...
Cart should now be empty/saved ...
after saving export to acsopa web db: 0.59327507019043 secs since start
generating quote pdf ...


ATTACHMENTS
arrPDFs:
Array
(
    [1] => /mnt/product_media/cleanleaf/pdf/CL2500D-HE Specs 11-13-22.pdf
    [2] => /mnt/product_media/cleanleaf/pdf/CleanLeafCL2500D-Ducting-Drawing-Top-View.pdf
    [3] => /mnt/product_media/cleanleaf/pdf/CL2500D-CCPHE Drawing.pdf
    [4] => /mnt/product_media/cleanleaf/pdf/CL_TDS Disposable Panel Filters_Nov-2022.pdf
    [5] => /mnt/product_media/cleanleaf/pdf/CL_TDS HVH-H13 Filter-NOv-2022.pdf
    [6] => /mnt/product_media/cleanleaf/pdf/CL_TDS Bag filters MERV15-Nov-2022.pdf
    [7] => /mnt/product_media/cleanleaf/pdf/CL_TDS MPH13 HHC Filters_Nov-2022.pdf
    [8] => /mnt/product_media/cleanleaf/pdf/CL2500D-series-owners-manual2.pdf
    [9] => /mnt/product_media/cleanleaf/pdf/cleanleaf-warranty-card.pdf
)
arrIndividualPDFs:
Array
(
)
temp_url:/tmp/merged-pdf_1767717488_2972.pdf
after merging and generating email/quote PDFs ...: 63.151039123535 secs since start
File: files[Quote.pdf] => @
File DNE! Skipping ... :
File: files[Product_Literature.pdf] => @/tmp/merged-pdf_1767717488_2972.pdf
Rep opted not to send an email ...
after inserting/updating customer in v2 ...: 63.235726118088 secs since start
empty the shopping cart ...
Cart should now be empty ...
after running remote mas queries ...: 63.492295026779 secs since start
Connected to ACSOPA DBafter reconnecting to the acsopa db ...: 65.519287109375 secs since start
strJSON:
{"exportid":"93562","import_result":null,"import_error":"","fileurl":"GMImport_93562_1767717491_17481.acsopa","email_result":"email not sent","goldmine_import":null,"mas_import":"","generate_quote":"true","goldmine_company":"Vibecanna","goldmine_email":"nickm@vibecanna.com","goldmine_phone":"(618) 973-5111","mas_quote_number":"Q062623","mas_customer_number":"VIB631A"}
end: 66.841972112656 secs since start