Session Data

Array
(
    [HubSpot] => Array
        (
            [hs_deal_id] => 51075870552
            [hs_company_id] => 0
            [salesorderno] => 
            [repid] => 0064
            [contact_id] => 181878815570
            [contact_email] => sursandhu@yahoo.com
            [contact_phone] => 17185511499
            [contact_address] => 11746
            [company_name] => 
            [company_mas_customer_no] => 
            [mas_customer_no] => 
            [FirstName] => Surinder
            [LastName] => Sandhu
            [Zip] => 11746
            [Phone] => 17185511499
            [Email] => sursandhu@yahoo.com
            [Address] => 
            [City] => 
            [State] => 
            [Company] => 
        )

    [form_inputs] => Array
        (
            [initial] => Array
                (
                    [Company] => 
                    [Contact_First] => Surinder
                    [Contact_Last] => Sandhu
                    [Contact_Email] => 
                    [Contact_Phone] => 
                    [contactid] => 
                    [Zip] => 11746
                    [Email] => 
                    [Phone] => 
                    [place_id] => 
                )

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

            [mas_search] => Array
                (
                    [mas_cust_no] => SAN1174
                    [mas_cust_exists] => false
                )

            [billing] => Array
                (
                    [Company] => 
                    [Contact_First] => Surinder
                    [Contact_Last] => Sandhu
                    [Address1] => 
                    [Address2] => 
                    [Address3] => 
                    [City] => 
                    [State] => 
                    [Zip] => 11746
                    [Country] => USA
                    [Email] => sursandhu@yahoo.com
                    [Phone] => 17185511499
                )

            [shipping] => Array
                (
                    [ShipToName] => Surinder Sandhu
                    [Address1] => 
                    [Address2] => 
                    [Address3] => 
                    [Address4] => 
                    [Address5] => 
                    [City] => 
                    [State] => 
                    [Zip] => 11746
                    [Country] => USA
                    [Email] => sursandhu@yahoo.com
                    [Phone] => 17185511499
                )

            [leadid] => 0
            [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] => sursandhu@yahoo.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/CL2500-CFP.pdf
                            [2] => /mnt/product_media/cleanleaf/pdf/CL2500-series-owners-manual.pdf
                            [3] => quote_bundle_separator
                        )

                    [act] => submit_quote
                )

        )

    [last_completed_step] => 5
    [gm_account_no] => 
    [mas_cust_no] => SAN1174
    [mas_cust_exists] => false
    [exportid] => 92526
    [masquotenum] => Q061726
    [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] => sursandhu@yahoo.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/CL2500-CFP.pdf
            [2] => /mnt/product_media/cleanleaf/pdf/CL2500-series-owners-manual.pdf
            [3] => quote_bundle_separator
        )

    [act] => submit_quote
)

Debug Data

start: 4.0531158447266E-6 secs since start
after getting new exportid ... 92526: 0.09998893737793 secs since start
Session ID: dln683u3imnfo4oli6gr9kr7vl
just before engaging cartlink ...: 0.30548810958862 secs since start
after most cartlink items ...: 0.3070330619812 secs since start
after getting new so num ...: 0.45881104469299 secs since start
after remaining cartlink items ...: 0.4588451385498 secs since start
SO Number: Q061726
just prior to terms gathering ...: 0.45886301994324 secs since start
after getting customer terms ...: 0.54674410820007 secs since start
Cart Items:

Array
(
    [0] => Array
        (
            [sku] => 
            [name] => 1500 X 16 (Max Install Height) = 24,000 Cubic Feet 

24,000 X 10 (Air Changes Per Hour) = 240,000 Total Cubic Feet Of Air In Need Of Filtration Per Hour 

240,000/ 60 = 4000 CFM Needed 

2 Units Needed 
            [qty] => 0
            [price] => 0.00
            [cost] => 0.00
            [pdfFileURL] => 
        )

    [1] => Array
        (
            [sku] => CL2500-CFP
            [name] => CleanLeaf Model CL2500-CFP, 2,500 CFM Media Filtration System w/ (3) Charcoal After Filters.

Cabinet: 24"W x 24"T x 59" Long - 16GA CRS

Power: 115V 60Hz Single Phase 10.2 Amps

Filter Stage 1: (1) 24" x 24" x 4" 35% Pleated Pre-Filter.

Filter Stage 2: (1) 24" x 24" x 15" 95% (12-Pocket) Bag Filter

Filter Stage 3: (3) 24" x 24" x 2" Charcoal After Filters w/ 9 lbs of Charcoal Each.  27 lbs. total
            [qty] => 2
            [price] => 3,653.00
            [cost] => 1,753.25
            [pdfFileURL] => 
        )

    [2] => Array
        (
            [sku] => 
            [name] => 
            [qty] => 0
            [price] => 0.00
            [cost] => 0.00
            [pdfFileURL] => 
        )

    [3] => Array
        (
            [sku] => CLP-MTGKIT
            [name] => Mounting Kit Chain, Q-Links, & eyebolts



(4ea. 5' Lengths of chain)



Used In CL2500 / CL2500D / CL3000 / CL3500C
            [qty] => 0
            [price] => 185.00
            [cost] => 120.00
            [pdfFileURL] => 
        )

    [4] => Array
        (
            [sku] => CLP-LBRKTS
            [name] => L Brackets M-11 "L" Mounting Brackets (set of 2)



Used In CL1100
            [qty] => 0
            [price] => 193.00
            [cost] => 125.00
            [pdfFileURL] => 
        )

    [5] => Array
        (
            [sku] => CLP-EYEBLTS
            [name] => Eyebolts 4 Eyebolts (Installed on unit at the Factory)



Used In CL2500 / CL2500D / CL3000 / CL3500C
            [qty] => 0
            [price] => 70.00
            [cost] => 45.00
            [pdfFileURL] => 
        )

    [6] => Array
        (
            [sku] => 
            [name] => 
            [qty] => 0
            [price] => 0.00
            [cost] => 0.00
            [pdfFileURL] => 
        )

    [7] => Array
        (
            [sku] => CLP-2530SIL-WG
            [name] => Silencer w/Grill Reduces Noise by 10-12 Decibels (Non-Directional Grill)



Used In CL2500 / CL2500D / CL3000 / CL3500C
            [qty] => 0
            [price] => 254.00
            [cost] => 165.00
            [pdfFileURL] => 
        )

    [8] => Array
        (
            [sku] => 
            [name] => FIRST SET OF FILTERS PROVIDED WITH UNITS. COSTS BELOW ARE FOR REPLACEMENTS. 
            [qty] => 0
            [price] => 0.00
            [cost] => 0.00
            [pdfFileURL] => 
        )

    [9] => Array
        (
            [sku] => BOF-4404
            [name] => 24 x 24 x 4 Pleated Prefilter, MERV 10



(Priced Each / Sold in Cartons of 6)



Used in many OX2500D, OX2500, OX3000, OX3000, OX3500C, CL2500D, CL2500, CL3000, FX Robor Hoods, and OX Filter Walls
            [qty] => 0
            [price] => 13.00
            [cost] => 7.77
            [pdfFileURL] => 
        )

    [10] => Array
        (
            [sku] => BOF-443698
            [name] => Fiberglass Bag, 24" X 24" X 36" MERV 15 (95%) 



8.0 Pockets, Gasket None, Loops None, Std Header, Nom Size 



(Priced Each / Sold in Cartons of 2)



Used in OX2500-CF, CL2500-CF, OX2500D-WAL/ -WAR/ -CFP and CL2500D-CFP
            [qty] => 0
            [price] => 107.00
            [cost] => 63.94
            [pdfFileURL] => 
        )

    [11] => Array
        (
            [sku] => BOF-4402-CF
            [name] => 24 x 24 x 2 Carbon Afterfilter, 75% Fill, 10lbs. of carbon.



Actual Size 23.5 x 23.5 x 2



Used in OX2500-CF/ -CFP, OX2500D-CF, OX3000-CF, OX300C-CF, CL2500-CF, -CFP, CL2500D-CF
            [qty] => 0
            [price] => 108.24
            [cost] => 43.30
            [pdfFileURL] => 
        )

)

not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q061726','CL2500-CFP','CleanLeaf Model CL2500-CFP, 2,500 CFM Media Filtration System w/ (3) Charcoal After Filters. Cabinet: 24"W x 24"T x 59" Long - 16GA CRS Power: 115V 60Hz Single Phase 10.2 Amps Filter Stage 1: (1) 24" x 24" x 4" 35% Pleated Pre-Filter. Filter Stage 2: (1) 24" x 24" x 15" 95% (12-Pocket) Bag Filter Filter Stage 3: (3) 24" x 24" x 2" Charcoal After Filters w/ 9 lbs of Charcoal Each. 27 lbs. total','Y','1753.25','2','2','3653.00','7306.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q061726','CLP-MTGKIT','Mounting Kit Chain, Q-Links, & eyebolts (4ea. 5' Lengths of chain) Used In CL2500 / CL2500D / CL3000 / CL3500C','Y','120.00','0','0','185.00','0.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q061726','CLP-LBRKTS','L Brackets M-11 "L" Mounting Brackets (set of 2) Used In CL1100','Y','125.00','0','0','193.00','0.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q061726','CLP-EYEBLTS','Eyebolts 4 Eyebolts (Installed on unit at the Factory) Used In CL2500 / CL2500D / CL3000 / CL3500C','Y','45.00','0','0','70.00','0.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q061726','CLP-2530SIL-WG','Silencer w/Grill Reduces Noise by 10-12 Decibels (Non-Directional Grill) Used In CL2500 / CL2500D / CL3000 / CL3500C','Y','165.00','0','0','254.00','0.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q061726','BOF-4404','24 x 24 x 4 Pleated Prefilter, MERV 10 (Priced Each / Sold in Cartons of 6) Used in many OX2500D, OX2500, OX3000, OX3000, OX3500C, CL2500D, CL2500, CL3000, FX Robor Hoods, and OX Filter Walls','Y','7.77','0','0','13.00','0.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q061726','BOF-443698','Fiberglass Bag, 24" X 24" X 36" MERV 15 (95%) 8.0 Pockets, Gasket None, Loops None, Std Header, Nom Size (Priced Each / Sold in Cartons of 2) Used in OX2500-CF, CL2500-CF, OX2500D-WAL/ -WAR/ -CFP and CL2500D-CFP','Y','63.94','0','0','107.00','0.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q061726','BOF-4402-CF','24 x 24 x 2 Carbon Afterfilter, 75% Fill, 10lbs. of carbon. Actual Size 23.5 x 23.5 x 2 Used in OX2500-CF/ -CFP, OX2500D-CF, OX3000-CF, OX300C-CF, CL2500-CF, -CFP, CL2500D-CF','Y','43.30','0','0','108.24','0.00','1')
save the exported shopping cart ...
Cart should now be empty/saved ...
after saving export to acsopa web db: 0.57595705986023 secs since start
generating quote pdf ...

ATTACHMENTS
arrPDFs:

Array
(
    [1] => /mnt/product_media/cleanleaf/pdf/CL2500-CFP.pdf
    [2] => /mnt/product_media/cleanleaf/pdf/CL2500-series-owners-manual.pdf
)

arrIndividualPDFs:

Array
(
)

temp_url:/tmp/merged-pdf_1764793320_2499.pdf

after merging and generating email/quote PDFs ...: 63.650329113007 secs since start
File: files[Quote.pdf] => @
File DNE! Skipping ... :
File: files[Product_Literature.pdf] => @/tmp/merged-pdf_1764793320_2499.pdf
Rep opted not to send an email ...
after inserting/updating customer in v2 ...: 63.861202955246 secs since start
empty the shopping cart ...
Cart should now be empty ...
after running remote mas queries ...: 64.178694963455 secs since start
Connected to ACSOPA DBafter reconnecting to the acsopa db ...: 66.206009149551 secs since start
strJSON:

{"exportid":"92526","import_result":null,"import_error":"","fileurl":"GMImport_92526_1764793323_94402.acsopa","email_result":"email not sent","goldmine_import":null,"mas_import":"","generate_quote":"true","goldmine_company":"","goldmine_email":"sursandhu@yahoo.com","goldmine_phone":"17185511499","mas_quote_number":"Q061726","mas_customer_number":"SAN1174"}

end: 69.197247982025 secs since start