function getTotalTransactions($id = NULL, $useCode = false, $withCurrency = true)
{
if ($id) {
$key = 'id';
if ($useCode) {
$key = "code";
}
$orderPayment = OrderPayment::where($key, $id)->select(['unique', 'box', 'item', 'space_credit_used']);
} else {
$orderPayment = OrderPayment::select([DB::raw("SUM(box) box"), DB::raw("SUM(item) item"), DB::raw("SUM(space_credit_used) space_credit_used")]);
}
$orderPayment = $orderPayment->first();
$box = $orderPayment->box * Config::get('thankspace.box.price');
$item = $orderPayment->item * Config::get('thankspace.item.price');
$space_credit_used = $orderPayment->space_credit_used;
$total = $box + $item - $space_credit_used;
if ($id) {
if ($total != 0) {
$total += $orderPayment->unique;
}
}
if ($withCurrency) {
return number_format($total, 0, '', '.');
}
return $total;
}
