Session Data

Array
(
    [HubSpot] => Array
        (
            [hs_deal_id] => 49530941583
            [hs_company_id] => 33527080740
            [salesorderno] => 
            [repid] => 0076
            [contact_id] => 176698756713
            [contact_email] => codyw@peninsula-gardens.com
            [contact_phone] => 3134753873
            [contact_address] => 48359
            [company_name] => Peninsula Gardens
            [company_mas_customer_no] => 
            [mas_customer_no] => 
            [FirstName] => Cody
            [LastName] => Wellington
            [Zip] => 48359
            [Phone] => 3134753873
            [Email] => codyw@peninsula-gardens.com
            [Address] => 
            [City] => 
            [State] => 
            [Company] => 
        )

    [form_inputs] => Array
        (
            [initial] => Array
                (
                    [Company] => Peninsula Agricuklture
                    [Contact_First] => Cody
                    [Contact_Last] => Wellington
                    [Contact_Email] => 
                    [Contact_Phone] => 
                    [contactid] => 
                    [Zip] => 48359
                    [Email] => 
                    [Phone] => 
                    [place_id] => 
                    [mascustnum] => PEN4835
                )

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

            [billing] => Array
                (
                    [Company] => Peninsula Agriculture
                    [Contact_First] => Cody
                    [Contact_Last] => Wellington
                    [Address1] => 
                    [Address2] => 
                    [Address3] => 
                    [City] => 
                    [State] => FL
                    [Zip] => 48359
                    [Country] => USA
                    [Email] => codyw@peninsula-gardens.com
                    [Phone] => 3134753873
                )

            [shipping] => Array
                (
                    [ShipToName] => Peninsula Agriculture
                    [Address1] => 
                    [Address2] => 
                    [Address3] => 
                    [Address4] => 
                    [Address5] => 
                    [City] => 
                    [State] => FL
                    [Zip] => 48359
                    [Country] => USA
                    [Email] => codyw@peninsula-gardens.com
                    [Phone] => 3134753873
                )

            [leadid] => 0
            [summary] => Array
                (
                    [SalesPersonNo] => 0076
                    [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] => api_freight
                    [freight_estimate_value] => 1622.40
                    [lead_time] => 2-3 Weeks, depending on stock and availability.
                    [email_quote_to] => codyw@peninsula-gardens.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/CL1100-CC.pdf
                            [2] => /mnt/product_media/cleanleaf/pdf/CL1100-series-owners-manual.pdf
                            [3] => /mnt/product_media/cleanleaf/pdf/CleanLeaf_Mounting_Guide.pdf
                            [4] => quote_bundle_separator
                        )

                    [act] => submit_quote
                )

        )

    [last_completed_step] => 5
    [mas_cust_no] => PEN4835
    [mas_cust_exists] => true
    [exportid] => 92032
    [masquotenum] => Q061296
    [not_in_mas] => 1
)

POST Data

Array
(
    [SalesPersonNo] => 0076
    [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] => api_freight
    [freight_estimate_value] => 1622.40
    [lead_time] => 2-3 Weeks, depending on stock and availability.
    [email_quote_to] => codyw@peninsula-gardens.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/CL1100-CC.pdf
            [2] => /mnt/product_media/cleanleaf/pdf/CL1100-series-owners-manual.pdf
            [3] => /mnt/product_media/cleanleaf/pdf/CleanLeaf_Mounting_Guide.pdf
            [4] => quote_bundle_separator
        )

    [act] => submit_quote
)

Debug Data

start: 5.9604644775391E-6 secs since start
after getting new exportid ... 92032: 0.1067419052124 secs since start
Session ID: 574rdn1ekh6knkud6f78etu0cg
just before engaging cartlink ...: 0.31434488296509 secs since start
after most cartlink items ...: 0.31563282012939 secs since start
after getting new so num ...: 0.47346496582031 secs since start
after remaining cartlink items ...: 0.47351479530334 secs since start
SO Number: Q061296
just prior to terms gathering ...: 0.473552942276 secs since start
after getting customer terms ...: 0.5694580078125 secs since start
Cart Items: 
Array
(
    [0] => Array
        (
            [sku] => 
            [name] => Load Calc:

1800 sq. ft x15' ceiling= 27000 Cubic Feet of Air

27000 x10= 270000 Total Volume  of Air in need of hourly filtration

270000/60 minutes= 4500 cfm needed

4-5 units needed for this space
            [qty] => 0
            [price] => 0.00
            [cost] => 0.00
            [pdfFileURL] => 
        )

    [1] => Array
        (
            [sku] => CL1100-CC
            [name] => CleanLeaf Model CL1100-CC, 1,100 CFM Media Air Cleaning System w/ Charcoal Module.

Airflow Reduced to 950 CFM w/ Charcoal bank Installed.

Cabinet: 20"W x 15"T x 44" Long  - 16GA CRS

Power: 115V 60Hz Single Phase   3.5 Amps

Filter Stage 1: 20x15x 1" Washable Foam Prefilter

Filter Stage 2: 20x15x12"L 95% (ASHRE) 6 Pocket Bag Filter (15 sqft)

Filter Stage 3: 18lb Charcoal Module ("A" frame cannister)
            [qty] => 4
            [price] => 3,151.00
            [cost] => 1,512.35
            [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] => 4
            [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] => 
            [name] => First set of filters included with Units- costs below for replacements.
            [qty] => 0
            [price] => 0.00
            [cost] => 0.00
            [pdfFileURL] => 
        )

    [6] => Array
        (
            [sku] => BOF-5001-FM
            [name] => 15 x 20 x 1" Foam Prefilter - Washable



USED IN OX1100/OX1100-CF/OX100-CC/OX1100-HE
            [qty] => 0
            [price] => 41.67
            [cost] => 25.00
            [pdfFileURL] => 
        )

    [7] => Array
        (
            [sku] => BOF-051296
            [name] => Fiberglass Bag, 20" X 15" X 12" MERV 15 (95%) 



6.0 Pockets, Gasket None, Loops None, Std Header, Nom Size, with Velcro



(Priced Each / Sold in Cartons of 4)



Used in OX1100-CC/ -HE and CL1100-CC/ -HE
            [qty] => 0
            [price] => 77.00
            [cost] => 45.97
            [pdfFileURL] => 
        )

    [8] => Array
        (
            [sku] => BOF-BLKCH-30LBS
            [name] => Charcoal 30lb box for refill
            [qty] => 0
            [price] => 178.50
            [cost] => 71.40
            [pdfFileURL] => 
        )

)
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q061296','CL1100-CC','CleanLeaf Model CL1100-CC, 1,100 CFM Media Air Cleaning System w/ Charcoal Module. Airflow Reduced to 950 CFM w/ Charcoal bank Installed. Cabinet: 20"W x 15"T x 44" Long - 16GA CRS Power: 115V 60Hz Single Phase 3.5 Amps Filter Stage 1: 20x15x 1" Washable Foam Prefilter Filter Stage 2: 20x15x12"L 95% (ASHRE) 6 Pocket Bag Filter (15 sqft) Filter Stage 3: 18lb Charcoal Module ("A" frame cannister)','Y','1512.35','4','4','3151.00','12604.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q061296','CLP-MTGKIT','Mounting Kit Chain, Q-Links, & eyebolts (4ea. 5' Lengths of chain) Used In CL2500 / CL2500D / CL3000 / CL3500C','Y','120.00','4','4','185.00','740.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q061296','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 ('Q061296','BOF-5001-FM','15 x 20 x 1" Foam Prefilter - Washable USED IN OX1100/OX1100-CF/OX100-CC/OX1100-HE','Y','25.00','0','0','41.67','0.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q061296','BOF-051296','Fiberglass Bag, 20" X 15" X 12" MERV 15 (95%) 6.0 Pockets, Gasket None, Loops None, Std Header, Nom Size, with Velcro (Priced Each / Sold in Cartons of 4) Used in OX1100-CC/ -HE and CL1100-CC/ -HE','Y','45.97','0','0','77.00','0.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q061296','BOF-BLKCH-30LBS','Charcoal 30lb box for refill','Y','71.40','0','0','178.50','0.00','1')
save the exported shopping cart ...
Cart should now be empty/saved ...
after saving export to acsopa web db: 0.60358500480652 secs since start
generating quote pdf ...


ATTACHMENTS
arrPDFs:
Array
(
    [1] => /mnt/product_media/cleanleaf/pdf/CL1100-CC.pdf
    [2] => /mnt/product_media/cleanleaf/pdf/CL1100-series-owners-manual.pdf
    [3] => /mnt/product_media/cleanleaf/pdf/CleanLeaf_Mounting_Guide.pdf
)
arrIndividualPDFs:
Array
(
)
temp_url:/tmp/merged-pdf_1763567857_3663.pdf
after merging and generating email/quote PDFs ...: 63.528972864151 secs since start
File: files[Quote.pdf] => @
File DNE! Skipping ... :
File: files[Product_Literature.pdf] => @/tmp/merged-pdf_1763567857_3663.pdf
Rep opted not to send an email ...
after inserting/updating customer in v2 ...: 63.759349822998 secs since start
empty the shopping cart ...
Cart should now be empty ...
after running remote mas queries ...: 64.033305883408 secs since start
Connected to ACSOPA DBafter reconnecting to the acsopa db ...: 66.060314893723 secs since start
strJSON: 
{"exportid":"92032","import_result":null,"import_error":"","fileurl":"GMImport_92032_1763567860_53231.acsopa","email_result":"email not sent","goldmine_import":null,"mas_import":"","generate_quote":"true","goldmine_company":"Peninsula Agriculture","goldmine_email":"codyw@peninsula-gardens.com","goldmine_phone":"3134753873","mas_quote_number":"Q061296","mas_customer_number":"PEN4835"}
end: 68.238322973251 secs since start