Code Coverage
 
Lines
Functions and Methods
Classes and Traits
Total
0.00%
0 / 130
0.00%
0 / 2
 CRAP
0.00%
0 / 1
Ingest
0.00%
0 / 130
0.00%
0 / 2
 20
0.00%
0 / 1
 __construct
0.00%
0 / 1
0.00%
0 / 1
 2
 ingestData
0.00%
0 / 129
0.00%
0 / 1
 12
1<?php
2
3namespace BuyerKiosk\QuickBooks;
4
5class Ingest extends Base {
6
7    public function __construct(\Store $store = null)
8    {
9        parent::__construct($store);
10    }
11
12    public function ingestData($data) {
13        try {
14            $stmt = $this->storeDB->prepare("INSERT INTO drsDailySFileData (closingDate, grossSalesCost, grossSalesRetail,
15            grossSalesNumber, grossSalesGM, returnsCost, returnsRetail,
16            returnsNumber, returnsGM, netSalesContinuiingForFee,
17            continuingFeePercentage, continuingFee, netSalesCost,
18            netSalesRetail, netSalesGM, salesCount, buysCost, buysRetail,
19            buysNumber, buysGM, buysCount, averageRetail, cashCount,
20            cashExpected, cashActual, cashVariance, mastercardCount,
21            mastercardExpected, mastercardActual, mastercardVariance,
22            visaCount, visaExpected, visaActual, visaVariance, amexCount,
23            amexExpected, amexActual, amexVariance, discoverCount,
24            discoverExpected, discoverActual, discoverVariance,
25            debitcardCount, debitcardExpected, debitcardActual,
26            debitcardVariance, giftcardCount, giftcardExpected,
27            giftcardActual, giftcardVariance, storeCreditCount,
28            storeCreditExpected, storeCreditActual, storeCreditVariance,
29            couponsCount, couponsExpected, couponsActual, couponsVariance,
30            openingCash, checksIssued, cashTendered, storeCreditsIssued,
31            cashPaidIn, cashPaidOut, freightCollected, cashOverShort,
32            buyPaidCash, buyPaidCheck, buyPaidStoreCredit, nextDayOpen,
33            buyPaidOffsite, buyPaidTradeIns, checkDeposit, buyPaidTotal,
34            giftCardsIssued, newARCharges, depositsReceived, depositsUsed,
35            checksCount, checksExpected, checksActual, checksVariance,
36            otherCardsCount, otherCardsExpected, otherCardsActual, otherCardsVariance,
37            houseAcctCount, houseAcctExpected, houseAcctActual,
38            houseAcctVariance, payPalCount, payPalExpected, payPalActual,
39            payPalVariance, internetCount, internetExpected, internetActual,
40            internetVariance, newSales, newReturns, newNetSales, newCost,
41            usedSales, usedReturns, usedNetSales, usedCost, totalTenderExpected,
42            totalTenderActual, totalTenderVariance, tradeCount, tradeAmount,
43            storeCreditsOutstandingCount, storeCreditsOutstandingAmount, taxCollected,
44            newWTD, usedWTD, newMTD, usedMTD, newYTD, usedYTD
45        ) VALUES (:closingDate, :grossSalesCost, :grossSalesRetail,
46        :grossSalesNumber, :grossSalesGM, :returnsCost, :returnsRetail,
47        :returnsNumber, :returnsGM, :netSalesContinuiingForFee,
48        :continuingFeePercentage, :continuingFee, :netSalesCost,
49        :netSalesRetail, :netSalesGM, :salesCount, :buysCost, :buysRetail,
50        :buysNumber, :buysGM, :buysCount, :averageRetail, :cashCount,
51        :cashExpected, :cashActual, :cashVariance, :mastercardCount,
52        :mastercardExpected, :mastercardActual, :mastercardVariance,
53        :visaCount, :visaExpected, :visaActual, :visaVariance, :amexCount,
54        :amexExpected, :amexActual, :amexVariance, :discoverCount,
55        :discoverExpected, :discoverActual, :discoverVariance,
56        :debitcardCount, :debitcardExpected, :debitcardActual,
57        :debitcardVariance, :giftcardCount, :giftcardExpected,
58        :giftcardActual, :giftcardVariance, :storeCreditCount,
59        :storeCreditExpected, :storeCreditActual, :storeCreditVariance,
60        :couponsCount, :couponsExpected, :couponsActual, :couponsVariance,
61        :openingCash, :checksIssued, :cashTendered, :storeCreditsIssued,
62        :cashPaidIn, :cashPaidOut, :freightCollected, :cashOverShort,
63        :buyPaidCash, :buyPaidCheck, :buyPaidStoreCredit, :nextDayOpen,
64        :buyPaidOffsite, :buyPaidTradeIns, :checkDeposit, :buyPaidTotal,
65        :giftCardsIssued, :newARCharges, :depositsReceived, :depositsUsed,
66        :checksCount, :checksExpected, :checksActual, :checksVariance,
67        :otherCardsCount, :otherCardsExpected, :otherCardsActual, :otherCardsVariance,
68        :houseAcctCount, :houseAcctExpected, :houseAcctActual,
69        :houseAcctVariance, :payPalCount, :payPalExpected, :payPalActual,
70        :payPalVariance, :internetCount, :internetExpected, :internetActual,
71        :internetVariance, :newSales, :newReturns, :newNetSales, :newCost,
72        :usedSales, :usedReturns, :usedNetSales, :usedCost, :totalTenderExpected,
73        :totalTenderActual, :totalTenderVariance, :tradeCount, :tradeAmount,
74        :storeCreditsOutstandingCount, :storeCreditsOutstandingAmount, :taxCollected,
75        :newWTD, :usedWTD, :newMTD, :usedMTD, :newYTD, :usedYTD
76        )");
77            $stmt->bindParam(':closingDate', $data['closingDate']);
78            $stmt->bindParam(':grossSalesCost', $data['grossSalesCost']);
79            $stmt->bindParam(':grossSalesRetail', $data['grossSalesRetail']);
80            $stmt->bindParam(':grossSalesNumber', $data['grossSalesNumber']);
81            $stmt->bindParam(':grossSalesGM', $data['grossSalesGM']);
82            $stmt->bindParam(':returnsCost', $data['returnsCost']);
83            $stmt->bindParam(':returnsRetail', $data['returnsRetail']);
84            $stmt->bindParam(':returnsNumber', $data['returnsNumber']);
85            $stmt->bindParam(':returnsGM', $data['returnsGM']);
86            $stmt->bindParam(':netSalesContinuiingForFee', $data['netSalesContinuiingForFee']);
87            $stmt->bindParam(':continuingFeePercentage', $data['continuingFeePercentage']);
88            $stmt->bindParam(':continuingFee', $data['continuingFee']);
89            $stmt->bindParam(':netSalesCost', $data['netSalesCost']);
90            $stmt->bindParam(':netSalesRetail', $data['netSalesRetail']);
91            $stmt->bindParam(':netSalesGM', $data['netSalesGM']);
92            $stmt->bindParam(':salesCount', $data['salesCount']);
93            $stmt->bindParam(':buysCost', $data['buysCost']);
94            $stmt->bindParam(':buysRetail', $data['buysRetail']);
95            $stmt->bindParam(':buysNumber', $data['buysNumber']);
96            $stmt->bindParam(':buysGM', $data['buysGM']);
97            $stmt->bindParam(':buysCount', $data['buysCount']);
98            $stmt->bindParam(':averageRetail', $data['averageRetail']);
99            $stmt->bindParam(':cashCount', $data['cashCount']);
100            $stmt->bindParam(':cashExpected', $data['cashExpected']);
101            $stmt->bindParam(':cashActual', $data['cashActual']);
102            $stmt->bindParam(':cashVariance', $data['cashVariance']);
103            $stmt->bindParam(':mastercardCount', $data['mastercardCount']);
104            $stmt->bindParam(':mastercardExpected', $data['mastercardExpected']);
105            $stmt->bindParam(':mastercardActual', $data['mastercardActual']);
106            $stmt->bindParam(':mastercardVariance', $data['mastercardVariance']);
107            $stmt->bindParam(':visaCount', $data['visaCount']);
108            $stmt->bindParam(':visaExpected', $data['visaExpected']);
109            $stmt->bindParam(':visaActual', $data['visaActual']);
110            $stmt->bindParam(':visaVariance', $data['visaVariance']);
111            $stmt->bindParam(':amexCount', $data['amexCount']);
112            $stmt->bindParam(':amexExpected', $data['amexExpected']);
113            $stmt->bindParam(':amexActual', $data['amexActual']);
114            $stmt->bindParam(':amexVariance', $data['amexVariance']);
115            $stmt->bindParam(':discoverCount', $data['discoverCount']);
116            $stmt->bindParam(':discoverExpected', $data['discoverExpected']);
117            $stmt->bindParam(':discoverActual', $data['discoverActual']);
118            $stmt->bindParam(':discoverVariance', $data['discoverVariance']);
119            $stmt->bindParam(':debitcardCount', $data['debitcardCount']);
120            $stmt->bindParam(':debitcardExpected', $data['debitcardExpected']);
121            $stmt->bindParam(':debitcardActual', $data['debitcardActual']);
122            $stmt->bindParam(':debitcardVariance', $data['debitcardVariance']);
123            $stmt->bindParam(':giftcardCount', $data['giftcardCount']);
124            $stmt->bindParam(':giftcardExpected', $data['giftcardExpected']);
125            $stmt->bindParam(':giftcardActual', $data['giftcardActual']);
126            $stmt->bindParam(':giftcardVariance', $data['giftcardVariance']);
127            $stmt->bindParam(':storeCreditCount', $data['storeCreditCount']);
128            $stmt->bindParam(':storeCreditExpected', $data['storeCreditExpected']);
129            $stmt->bindParam(':storeCreditActual', $data['storeCreditActual']);
130            $stmt->bindParam(':storeCreditVariance', $data['storeCreditVariance']);
131            $stmt->bindParam(':couponsCount', $data['couponsCount']);
132            $stmt->bindParam(':couponsExpected', $data['couponsExpected']);
133            $stmt->bindParam(':couponsActual', $data['couponsActual']);
134            $stmt->bindParam(':couponsVariance', $data['couponsVariance']);
135            $stmt->bindParam(':openingCash', $data['openingCash']);
136            $stmt->bindParam(':checksIssued', $data['checksIssued']);
137            $stmt->bindParam(':cashTendered', $data['cashTendered']);
138            $stmt->bindParam(':storeCreditsIssued', $data['storeCreditsIssued']);
139            $stmt->bindParam(':cashPaidIn', $data['cashPaidIn']);
140            $stmt->bindParam(':cashPaidOut', $data['cashPaidOut']);
141            $stmt->bindParam(':freightCollected', $data['freightCollected']);
142            $stmt->bindParam(':cashOverShort', $data['cashOverShort']);
143            $stmt->bindParam(':buyPaidCash', $data['buyPaidCash']);
144            $stmt->bindParam(':buyPaidCheck', $data['buyPaidCheck']);
145            $stmt->bindParam(':buyPaidStoreCredit', $data['buyPaidStoreCredit']);
146            $stmt->bindParam(':nextDayOpen', $data['nextDayOpen']);
147            $stmt->bindParam(':buyPaidOffsite', $data['buyPaidOffsite']);
148            $stmt->bindParam(':buyPaidTradeIns', $data['buyPaidTradeIns']);
149            $stmt->bindParam(':checkDeposit', $data['checkDeposit']);
150            $stmt->bindParam(':buyPaidTotal', $data['buyPaidTotal']);
151            $stmt->bindParam(':giftCardsIssued', $data['giftCardsIssued']);
152            $stmt->bindParam(':newARCharges', $data['newARCharges']);
153            $stmt->bindParam(':depositsReceived', $data['depositsReceived']);
154            $stmt->bindParam(':depositsUsed', $data['depositsUsed']);
155            $stmt->bindParam(':checksCount', $data['checksCount']);
156            $stmt->bindParam(':checksExpected', $data['checksExpected']);
157            $stmt->bindParam(':checksActual', $data['checksActual']);
158            $stmt->bindParam(':checksVariance', $data['checksVariance']);
159            $stmt->bindParam(':otherCardsCount', $data['otherCardsCount']);
160            $stmt->bindParam(':otherCardsExpected', $data['otherCardsExpected']);
161            $stmt->bindParam(':otherCardsActual', $data['otherCardsActual']);
162            $stmt->bindParam(':otherCardsVariance', $data['otherCardsVariance']);
163            $stmt->bindParam(':houseAcctCount', $data['houseAcctCount']);
164            $stmt->bindParam(':houseAcctExpected', $data['houseAcctExpected']);
165            $stmt->bindParam(':houseAcctActual', $data['houseAcctActual']);
166            $stmt->bindParam(':houseAcctVariance', $data['houseAcctVariance']);
167            $stmt->bindParam(':payPalCount', $data['payPalCount']);
168            $stmt->bindParam(':payPalExpected', $data['payPalExpected']);
169            $stmt->bindParam(':payPalActual', $data['payPalActual']);
170            $stmt->bindParam(':payPalVariance', $data['payPalVariance']);
171            $stmt->bindParam(':internetCount', $data['internetCount']);
172            $stmt->bindParam(':internetExpected', $data['internetExpected']);
173            $stmt->bindParam(':internetActual', $data['internetActual']);
174            $stmt->bindParam(':internetVariance', $data['internetVariance']);
175            $stmt->bindParam(':newSales', $data['newSales']);
176            $stmt->bindParam(':newReturns', $data['newReturns']);
177            $stmt->bindParam(':newNetSales', $data['newNetSales']);
178            $stmt->bindParam(':newCost', $data['newCost']);
179            $stmt->bindParam(':usedSales', $data['usedSales']);
180            $stmt->bindParam(':usedReturns', $data['usedReturns']);
181            $stmt->bindParam(':usedNetSales', $data['usedNetSales']);
182            $stmt->bindParam(':usedCost', $data['usedCost']);
183            $stmt->bindParam(':totalTenderExpected', $data['totalTenderExpected']);
184            $stmt->bindParam(':totalTenderActual', $data['totalTenderActual']);
185            $stmt->bindParam(':totalTenderVariance', $data['totalTenderVariance']);
186            $stmt->bindParam(':tradeCount', $data['tradeCount']);
187            $stmt->bindParam(':tradeAmount', $data['tradeAmount']);
188            $stmt->bindParam(':storeCreditsOutstandingCount', $data['storeCreditsOutstandingCount']);
189            $stmt->bindParam(':storeCreditsOutstandingAmount', $data['storeCreditsOutstandingAmount']);
190            $stmt->bindParam(':taxCollected', $data['taxCollected']);
191            $stmt->bindParam(':newWTD', $data['newWTD']);
192            $stmt->bindParam(':usedWTD', $data['usedWTD']);
193            $stmt->bindParam(':newMTD', $data['newMTD']);
194            $stmt->bindParam(':usedMTD', $data['usedMTD']);
195            $stmt->bindParam(':newYTD', $data['newYTD']);
196            $stmt->bindParam(':usedYTD', $data['usedYTD']);
197            if ($stmt->execute()) {
198                return true;
199            } else {
200                error_log("Error ingesting data on execute: ".$stmt->errorInfo());
201                return false;
202            }
203
204        } catch (\Exception $e) {
205            error_log("Error ingesting data: ".$e->getMessage());
206            return false;
207        }
208    }
209}