Session Data

Array
(
    [HubSpot] => Array
        (
            [hs_deal_id] => 43274238531
            [hs_company_id] => 0
            [mas_customer_no] => 
            [company_mas_customer_no] => 
            [FirstName] => Mohammad
            [LastName] => Gharbieh
            [Zip] => 75238
            [Phone] => 4698316315
            [Email] => mg@q1es.com
            [Address] => 
            [City] => 
            [State] => 
            [Company] => 
        )

    [form_inputs] => Array
        (
            [initial] => Array
                (
                    [Company] => Quality 1 Energy Systems
                    [Contact_First] => Mohammad
                    [Contact_Last] => Gharbieh
                    [Contact_Email] => 
                    [Contact_Phone] => 
                    [contactid] => 
                    [Zip] => 75238
                    [Email] => 
                    [Phone] => 
                    [place_id] => 
                )

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

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

            [billing] => Array
                (
                    [Company] => Quality 1 Energy Systems
                    [Contact_First] => Mohammad
                    [Contact_Last] => Gharbieh
                    [Address1] => 10874 Plano Rd Suite D
                    [Address2] => 
                    [Address3] => 
                    [City] => Dallas
                    [State] => TX
                    [Zip] => 75238
                    [Country] => USA
                    [Email] => mg@q1es.com
                    [Phone] => 4698316315
                )

            [shipping] => Array
                (
                    [ShipToName] => Quality 1 Energy Systems
                    [Address1] => 10874 Plano Rd Suite D
                    [Address2] => 
                    [Address3] => 
                    [Address4] => 
                    [Address5] => 
                    [City] => Dallas
                    [State] => TX
                    [Zip] => 75238
                    [Country] => USA
                    [Email] => mg@q1es.com
                    [Phone] => 4698316315
                )

            [leadid] => 348722
            [summary] => Array
                (
                    [SalesPersonNo] => 0076
                    [ProductLine] => BOX
                    [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] => mg@q1es.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/blueox/pdf/OX1100-CF.pdf
                            [2] => /mnt/product_media/blueox/pdf/OX1100_Owners_Manual.pdf
                            [3] => /mnt/product_media/blueox/pdf/OX1100_Series.pdf
                            [4] => /mnt/product_media/blueox/pdf/Blue_OX_Mounting_Guide.pdf
                            [5] => /mnt/product_media/blueox/pdf/BOF-5002-CF Media Data.pdf
                            [6] => quote_bundle_separator
                        )

                    [act] => submit_quote
                )

        )

    [last_completed_step] => 5
    [gm_account_no] => 
    [mas_cust_no] => QUA7523
    [mas_cust_exists] => false
    [exportid] => 89163
    [masquotenum] => Q058748
    [not_in_mas] => 1
)

POST Data

Array
(
    [SalesPersonNo] => 0076
    [ProductLine] => BOX
    [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] => mg@q1es.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/blueox/pdf/OX1100-CF.pdf
            [2] => /mnt/product_media/blueox/pdf/OX1100_Owners_Manual.pdf
            [3] => /mnt/product_media/blueox/pdf/OX1100_Series.pdf
            [4] => /mnt/product_media/blueox/pdf/Blue_OX_Mounting_Guide.pdf
            [5] => /mnt/product_media/blueox/pdf/BOF-5002-CF Media Data.pdf
            [6] => quote_bundle_separator
        )

    [act] => submit_quote
)

Debug Data

start: 3.0994415283203E-6 secs since start
after getting new exportid ... 89163: 0.097570180892944 secs since start
Session ID: o5is5en9svdlvmecdi3o9nq1ri
just before engaging cartlink ...: 0.09766697883606 secs since start
after most cartlink items ...: 0.098607063293457 secs since start
after getting new so num ...: 0.25111103057861 secs since start
after remaining cartlink items ...: 0.25114703178406 secs since start
SO Number: Q058748
just prior to terms gathering ...: 0.25116419792175 secs since start
after getting customer terms ...: 0.34034609794617 secs since start
Cart Items: 
Array
(
    [0] => Array
        (
            [sku] => 
            [name] => Load Calc:

3000 sq. ft hookah area( 6000 total) x 105. ' ceiling height = 31500

31500x 10 air changes per hour= 315000 Total volume of air in need of filtration Hourly

315000/60= 5250 CFM needed

Each unit 1100 CFM

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

    [1] => Array
        (
            [sku] => OX1100-CF
            [name] => Blue Ox Model OX1100-CF,  1,000 CFM Media Filtration System w/ Charcoal After Filter.

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: 20x15x24"L 95% (ASHRAE) 6 Pocket Bag Filter (15 sqft)

Filter Stage 3: 7lb Carbon Filter
            [qty] => 5
            [price] => 2,527.00
            [cost] => 1,212.54
            [pdfFileURL] => 
        )

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

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

(4ea. 5' Lengths of chain)

Used In OX1100 / OX2500 / OX3000
            [qty] => 5
            [price] => 185.00
            [cost] => 120.00
            [pdfFileURL] => 
        )

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

Used In OX1100 / OX2500 / OX3000
            [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-052496
            [name] => Fiberglass Bag, 20" X 15" X 24" MERV 15 (95%) 



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



(Priced Each / Sold in Cartons of 4)



Used in OX1100/ -CF and CL1100/ -CF
            [qty] => 0
            [price] => 95.90
            [cost] => 57.54
            [pdfFileURL] => 
        )

    [8] => Array
        (
            [sku] => BOF-5002-CF
            [name] => 15 x 20 x 2" Charcoal Afterfilter - 75% Fill



Actual Size 14.875 x 19.75 x 2



Equivalent to CLF-5002-CF
            [qty] => 0
            [price] => 79.22
            [cost] => 31.69
            [pdfFileURL] => 
        )

)
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q058748','OX1100-CF','Blue Ox Model OX1100-CF, 1,000 CFM Media Filtration System w/ Charcoal After Filter. 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: 20x15x24"L 95% (ASHRAE) 6 Pocket Bag Filter (15 sqft) Filter Stage 3: 7lb Carbon Filter','Y','1212.54','5','5','2527.00','12635.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q058748','BOP-MTGKIT','Mounting Kit Chain, Q-Links, & installed eyebolts (4ea. 5' Lengths of chain) Used In OX1100 / OX2500 / OX3000','Y','120.00','5','5','185.00','925.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q058748','BOP-LBRKTS','"L" Mounting Brackets (set of 2) Used In OX1100 / OX2500 / OX3000','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 ('Q058748','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 ('Q058748','BOF-052496','Fiberglass Bag, 20" X 15" X 24" MERV 15 (95%) 6.0 Pockets, Gasket None, Loops None, Std Header, Nom Size, wtih Velcro (Priced Each / Sold in Cartons of 4) Used in OX1100/ -CF and CL1100/ -CF','Y','57.54','0','0','95.90','0.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q058748','BOF-5002-CF','15 x 20 x 2" Charcoal Afterfilter - 75% Fill Actual Size 14.875 x 19.75 x 2 Equivalent to CLF-5002-CF','Y','31.69','0','0','79.22','0.00','1')
save the exported shopping cart ...
Cart should now be empty/saved ...
after saving export to acsopa web db: 0.37650418281555 secs since start
generating quote pdf ...


ATTACHMENTS
arrPDFs:
Array
(
    [1] => /mnt/product_media/blueox/pdf/OX1100-CF.pdf
    [2] => /mnt/product_media/blueox/pdf/OX1100_Owners_Manual.pdf
    [3] => /mnt/product_media/blueox/pdf/OX1100_Series.pdf
    [4] => /mnt/product_media/blueox/pdf/Blue_OX_Mounting_Guide.pdf
    [5] => /mnt/product_media/blueox/pdf/BOF-5002-CF Media Data.pdf
)
arrIndividualPDFs:
Array
(
)
temp_url:/tmp/merged-pdf_1756823582_5719.pdf
after merging and generating email/quote PDFs ...: 9.2242619991302 secs since start
File: files[Quote.pdf] => @/tmp/tmp_quote_20250902093254_47954.pdf
File: files[Product_Literature.pdf] => @/tmp/merged-pdf_1756823582_5719.pdf
Rep opted not to send an email ...
after inserting/updating customer in v2 ...: 9.4694931507111 secs since start
empty the shopping cart ...
Cart should now be empty ...
after running remote mas queries ...: 9.7394771575928 secs since start
Connected to ACSOPA DBafter reconnecting to the acsopa db ...: 11.787528991699 secs since start
strJSON: 
{"exportid":"89163","import_result":null,"import_error":"","fileurl":"GMImport_89163_1756823585_15324.acsopa","email_result":"email not sent","goldmine_import":null,"mas_import":"","generate_quote":"true","goldmine_company":"Quality 1 Energy Systems","goldmine_email":"mg@q1es.com","goldmine_phone":"4698316315","mas_quote_number":"Q058748","mas_customer_number":"QUA7523"}
end: 11.808330059052 secs since start