Session Data

Array
(
    [HubSpot] => Array
        (
            [hs_deal_id] => 53342799545
            [hs_company_id] => 0
            [salesorderno] => 
            [repid] => 0064
            [contact_id] => 187428692769
            [contact_email] => nickm@vibecanna.com
            [contact_phone] => 6189735111
            [contact_address] => St. Louis, Missouri, 63147, United States
            [company_name] => 
            [company_mas_customer_no] => 
            [mas_customer_no] => 
            [FirstName] => Nick
            [LastName] => McGinley
            [Zip] => 63147
            [Phone] => 6189735111
            [Email] => nickm@vibecanna.com
            [Address] => 
            [City] => St. Louis
            [State] => Missouri
            [Company] => 
        )

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

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

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

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

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

            [leadid] => 0
            [summary] => Array
                (
                    [SalesPersonNo] => 0064
                    [ProductLine] => CL
                    [forecasting_likelihood] => 
                    [forecasting_expected_close_date] => 
                    [generate_quote] => true
                    [not_in_mas] => true
                    [delivery_disclaimer] => true
                    [freight_estimate] => true
                    [freight_type] => call
                    [lead_time] => 1-2 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/CL2500-HE.pdf
                            [2] => /mnt/product_media/cleanleaf/pdf/CL2500-series-owners-manual.pdf
                            [3] => /mnt/product_media/cleanleaf/pdf/brochure.pdf
                            [4] => quote_bundle_separator
                        )

                    [act] => submit_quote
                )

        )

    [last_completed_step] => 5
    [gm_account_no] => 
    [mas_cust_no] => VIB631A
    [mas_cust_exists] => false
    [exportid] => 93561
    [masquotenum] => Q062622
    [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
    [freight_estimate] => true
    [freight_type] => call
    [lead_time] => 1-2 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/CL2500-HE.pdf
            [2] => /mnt/product_media/cleanleaf/pdf/CL2500-series-owners-manual.pdf
            [3] => /mnt/product_media/cleanleaf/pdf/brochure.pdf
            [4] => quote_bundle_separator
        )

    [act] => submit_quote
)

Debug Data

start: 4.0531158447266E-6 secs since start
after getting new exportid ... 93561: 0.097655057907104 secs since start
Session ID: 8nbpac0d3qob39kn0dbubdqvlp
just before engaging cartlink ...: 0.30885791778564 secs since start
after most cartlink items ...: 0.3100118637085 secs since start
after getting new so num ...: 0.46371507644653 secs since start
after remaining cartlink items ...: 0.46375203132629 secs since start
SO Number: Q062622
just prior to terms gathering ...: 0.46376705169678 secs since start
after getting customer terms ...: 0.55368208885193 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] => CL2500-HE
            [name] => CleanLeaf Model CL2500-HE, 2,500 CFM Self-Contained Media Filtration with HEPA Filter.

Airflow Reduced to 1,800 CFM w/ HEPA filter Installed.

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: (1) 20" x 20" x 12" - 99.97% @.3 Micron HEPA Filter
            [qty] => 7
            [price] => 3,896.00
            [cost] => 1,870.00
            [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] => CL2500-HE
            [name] => CleanLeaf Model CL2500-HE, 2,500 CFM Self-Contained Media Filtration with HEPA Filter.

Airflow Reduced to 1,800 CFM w/ HEPA filter Installed.

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: (1) 20" x 20" x 12" - 99.97% @.3 Micron HEPA Filter
            [qty] => 7
            [price] => 3,896.00
            [cost] => 1,870.00
            [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] => CL2500-HE
            [name] => CleanLeaf Model CL2500-HE, 2,500 CFM Self-Contained Media Filtration with HEPA Filter.

Airflow Reduced to 1,800 CFM w/ HEPA filter Installed.

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: (1) 20" x 20" x 12" - 99.97% @.3 Micron HEPA Filter
            [qty] => 3
            [price] => 3,896.00
            [cost] => 1,870.00
            [pdfFileURL] => 
        )

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

    [7] => 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] => 
        )

    [8] => 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] => 
        )

    [9] => 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] => 
        )

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

    [11] => Array
        (
            [sku] => CLP-MAG02
            [name] => Pressure Gauge Magnehelic Pressure Gage 0-2" W.C.



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

    [12] => Array
        (
            [sku] => CLP-2530SIL
            [name] => Silencer at Factory Reduces Noise by 6-8 Decibels (4 way Directional Louver)



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

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

    [14] => 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] => 
        )

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



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



(Priced Each / Sold in Cartons of 4)



Used in OX2500-CFP/ -HE, CL2500-CFP/ -HE, OX2500D-CC/ -HE, CL2500D-CC, OX3000-HE, CL3000-HE
            [qty] => 0
            [price] => 95.00
            [cost] => 56.54
            [pdfFileURL] => 
        )

    [16] => Array
        (
            [sku] => BOF-001297-H
            [name] => 20" X 20" X 12" HEPA FIlter 99.97% - 1000 Series



PB Box Exact Magna Std Cap Gasket exit



(Priced Each / Sold in Cartons of 1)



Equivalent to CLF-001297-H
            [qty] => 0
            [price] => 297.00
            [cost] => 178.06
            [pdfFileURL] => 
        )

)

not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q062622','CL2500-HE','CleanLeaf Model CL2500-HE, 2,500 CFM Self-Contained Media Filtration with HEPA Filter. Airflow Reduced to 1,800 CFM w/ HEPA filter Installed. 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: (1) 20" x 20" x 12" - 99.97% @.3 Micron HEPA Filter','Y','1870.00','7','7','3896.00','27272.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q062622','CL2500-HE','CleanLeaf Model CL2500-HE, 2,500 CFM Self-Contained Media Filtration with HEPA Filter. Airflow Reduced to 1,800 CFM w/ HEPA filter Installed. 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: (1) 20" x 20" x 12" - 99.97% @.3 Micron HEPA Filter','Y','1870.00','7','7','3896.00','27272.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q062622','CL2500-HE','CleanLeaf Model CL2500-HE, 2,500 CFM Self-Contained Media Filtration with HEPA Filter. Airflow Reduced to 1,800 CFM w/ HEPA filter Installed. 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: (1) 20" x 20" x 12" - 99.97% @.3 Micron HEPA Filter','Y','1870.00','3','3','3896.00','11688.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q062622','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 ('Q062622','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 ('Q062622','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 ('Q062622','CLP-MAG02','Pressure Gauge Magnehelic Pressure Gage 0-2" W.C. Used In CL2500 / CL2500D / CL3000 / CL3500C','Y','95.00','0','0','147.00','0.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q062622','CLP-2530SIL','Silencer at Factory Reduces Noise by 6-8 Decibels (4 way Directional Louver) Used In CL2500 / CL2500D / CL3000 / CL3500C','Y','175.00','0','0','270.00','0.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q062622','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 ('Q062622','BOF-4415912','Fiberglass Bag, 24" X 24" X 15" MERV 15 (95%) 12.0 Pockets, Gasket None, Loops None, Std Header, Nom Size (Priced Each / Sold in Cartons of 4) Used in OX2500-CFP/ -HE, CL2500-CFP/ -HE, OX2500D-CC/ -HE, CL2500D-CC, OX3000-HE, CL3000-HE','Y','56.54','0','0','95.00','0.00','1')
not in mas
INSERT INTO `SO_SALESORDERHISTORYDETAIL` (`SALESORDERNO`,`ITEMCODE`,`ITEMCODEDESC`,`DROPSHIP`,`UNITCOST`,`QuantityOrderedRevised`,`QuantityOrderedOriginal`,`LastUnitPrice`,`LastExtensionAmt`,`ItemType`) VALUES ('Q062622','BOF-001297-H','20" X 20" X 12" HEPA FIlter 99.97% - 1000 Series PB Box Exact Magna Std Cap Gasket exit (Priced Each / Sold in Cartons of 1) Equivalent to CLF-001297-H','Y','178.06','0','0','297.00','0.00','1')
save the exported shopping cart ...
Cart should now be empty/saved ...
after saving export to acsopa web db: 0.58720993995667 secs since start
generating quote pdf ...

ATTACHMENTS
arrPDFs:

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

arrIndividualPDFs:

Array
(
)

temp_url:/tmp/merged-pdf_1767717109_5716.pdf

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

{"exportid":"93561","import_result":null,"import_error":"","fileurl":"GMImport_93561_1767717112_30917.acsopa","email_result":"email not sent","goldmine_import":null,"mas_import":"","generate_quote":"true","goldmine_company":" Vibecanna","goldmine_email":"nickm@vibecanna.com","goldmine_phone":"6189735111","mas_quote_number":"Q062622","mas_customer_number":"VIB631A"}

end: 68.855632066727 secs since start