/** * Get tax statistics from the current range * @param $result * @return mixed */ public function getTaxStats($result) { $stats = []; $itemsMdl = new SaleItemsModel(); // check if params set, if not set defaults $stime = isset($this->data->stime) ? $this->data->stime : strtotime('-1 week') * 1000; $etime = isset($this->data->etime) ? $this->data->etime : time() * 1000; if (is_array($taxtotals = $itemsMdl->getTaxTotals($stime, $etime, true, $this->data->type))) { foreach ($taxtotals as $tax) { $stats[$tax['taxid']] = new stdClass(); $stats[$tax['taxid']]->refs = $tax['refs']; $stats[$tax['taxid']]->name = $tax['taxname']; $stats[$tax['taxid']]->qtyitems = $tax['qtyitems']; //$stats[$tax['taxid']]->salebalance = number_format($tax['saletotal']-$tax['refundtotal'], 2); $stats[$tax['taxid']]->saletotal = number_format($tax['saletotal'], 2); $stats[$tax['taxid']]->refundtotal = number_format($tax['refundtotal'], 2); if ($tax['taxid'] == 1) { $stats[$tax['taxid']]->saletax = number_format(0.0, 2); $stats[$tax['taxid']]->refundtax = number_format(0.0, 2); } else { $taxMdl = new TaxItemsModel(); $taxdata = $taxMdl->get($tax['taxid']); if ($taxdata === false) { $result['error'] = "Could not calculate tax"; return $result; } $taxdiv = $taxdata[0]['divisor']; $stats[$tax['taxid']]->saletax = round($tax['saletotal'] / $taxdiv, 2); $stats[$tax['taxid']]->refundtax = round($tax['refundtotal'] / $taxdiv, 2); } $stats[$tax['taxid']]->balance = number_format($stats[$tax['taxid']]->saletax - $stats[$tax['taxid']]->refundtax, 2); $stats[$tax['taxid']]->saletax = number_format($stats[$tax['taxid']]->saletax, 2); $stats[$tax['taxid']]->refundtax = number_format($stats[$tax['taxid']]->refundtax, 2); } // Get cash rounding total $roundtotals = $itemsMdl->getRoundingTotal($stime, $etime); if ($roundtotals !== false) { $stats[0] = new stdClass(); $stats[0]->refs = $roundtotals[0]['refs']; $stats[0]->name = "Cash Rounding"; $stats[0]->qty = $roundtotals[0]['num']; $stats[0]->total = $roundtotals[0]['total']; } else { $result['error'] = $itemsMdl->errorInfo; } } else { $result['error'] = $itemsMdl->errorInfo; } $result['data'] = $stats; return $result; }
/** * Get tax statistics from the current range * @param $result * @return mixed */ public function getTaxStats($result) { $stats = []; $itemsMdl = new SaleItemsModel(); // check if params set, if not set defaults $stime = isset($this->data->stime) ? $this->data->stime : strtotime('-1 week') * 1000; $etime = isset($this->data->etime) ? $this->data->etime : time() * 1000; if (is_array($saleitems = $itemsMdl->getTotalsRange($stime, $etime, true, $this->data->type))) { $taxMdl = new TaxItemsModel(); $taxdata = $taxMdl->get(); $taxes = []; foreach ($taxdata as $value) { $taxes[$value['id']] = (object) $value; } foreach ($saleitems as $saleitem) { $itemtax = json_decode($saleitem['tax']); if ($itemtax->total == 0) { if (!array_key_exists(-1, $stats)) { $stats[-1] = new stdClass(); $stats[-1]->refs = []; $stats[-1]->name = "Untaxed"; $stats[-1]->qtyitems = 0; $stats[-1]->saletotal = 0; $stats[-1]->refundtotal = 0; $stats[-1]->saletax = 0; $stats[-1]->refundtax = 0; } if (!in_array($saleitem['ref'], $stats[-1]->refs)) { $stats[-1]->refs[] = $saleitem['ref']; } $stats[-1]->qtyitems += $saleitem['qty']; $stats[-1]->saletotal += $saleitem['itemtotal']; $stats[-1]->refundtotal += $saleitem['refundtotal']; } else { // subtotal excludes tax, factors in discount $discountedtax = $saleitem['discount'] > 0 ? round($itemtax->total - $itemtax->total * ($saleitem['discount'] / 100), 2) : $itemtax->total; //echo($discountedtax); $itemsubtotal = $saleitem['itemtotal'] - $discountedtax; $refundsubtotal = $saleitem['refundtotal'] - round($discountedtax / $saleitem['qty'] * $saleitem['refundqty'], 2); foreach ($itemtax->values as $key => $value) { if (!array_key_exists($key, $stats)) { $stats[$key] = new stdClass(); $stats[$key]->refs = []; $stats[$key]->name = isset($taxes[$key]) ? $taxes[$key]->name : "Unknown"; $stats[$key]->qtyitems = 0; $stats[$key]->saletotal = 0; $stats[$key]->refundtotal = 0; //$stats[$key]->saletax = 0; //$stats[$key]->refundtax = 0; } if (!in_array($saleitem['ref'], $stats[$key]->refs)) { $stats[$key]->refs[] = $saleitem['ref']; } $stats[$key]->qtyitems += $saleitem['qty']; $stats[$key]->saletotal += $itemsubtotal; // subtotal excludes tax, factors in discount $stats[$key]->refundtotal += $refundsubtotal; //$stats[$key]->saletax += $saleitem['discount']>0 ? round($value - ($value*($saleitem['discount']/100)), 2) : $value; // $stats[$key]->refundtax += $saleitem['discount']>0 ? (round($value/($saleitem['discount']/100), 2)/$saleitem['qty'])*$saleitem['refundqty']: ($value/$saleitem['qty'])*$saleitem['refundqty']; } } } foreach ($stats as $key => $value) { $taxitems = WposAdminUtilities::getTaxTable()['items']; $stats[$key]->saletax = round($taxitems[$key]['multiplier'] * $stats[$key]->saletotal, 2); $stats[$key]->refundtax = round($taxitems[$key]['multiplier'] * $stats[$key]->refundtotal, 2); $stats[$key]->balance = number_format($stats[$key]->saletax - $stats[$key]->refundtax, 2); } // Get cash rounding total $roundtotals = $itemsMdl->getRoundingTotal($stime, $etime); if ($roundtotals !== false) { $stats[0] = new stdClass(); $stats[0]->refs = $roundtotals[0]['refs']; $stats[0]->name = "Cash Rounding"; $stats[0]->qty = $roundtotals[0]['num']; $stats[0]->total = $roundtotals[0]['total']; } else { $result['error'] = $itemsMdl->errorInfo; } } else { $result['error'] = $itemsMdl->errorInfo; } $result['data'] = $stats; return $result; }