public static function GetClientTransactions($cid, $category, $dates, $all) { if ($category == 1) { //Statement if ($all == 'true') { $sql = 'SELECT * FROM general_ledger_entries WHERE account_no = ' . intval($cid) . ' ORDER BY id DESC'; } else { if ($dates != '') { $split = explode(' - ', $dates); $d1 = explode('/', $split[0]); $d2 = explode('/', $split[1]); $lower = $d1[2] . $d1[0] . $d1[1] . '000000' + 0; $upper = $d2[2] . $d2[0] . $d2[1] . '999999' + 0; $sql = 'SELECT * FROM general_ledger_entries WHERE account_no = ' . intval($cid) . ' AND stamp BETWEEN ' . $lower . ' AND ' . $upper . ' ORDER BY id DESC'; } } try { $res = DatabaseHandler::GetAll($sql); $vouchers = []; foreach ($res as $tx) { if ($tx['effect'] == 'cr') { $voucher = ReceiptVoucher::GetVoucher(intval($tx['transaction_id'])); if ($voucher) { $vouchers[] = $voucher; } } else { $voucher = InvoiceVoucher::GetVoucher(intval($tx['transaction_id'])); if ($voucher) { $vouchers[] = $voucher; } } } return $vouchers; } catch (Exception $e) { } } else { //Quotations if ($all == 'true') { $sql = 'SELECT * FROM quotations WHERE client_id = ' . intval($cid) . ' ORDER BY id DESC'; } else { $split = explode(' - ', $dates); $d1 = explode('/', $split[0]); $d2 = explode('/', $split[1]); $lower = $d1[2] . $d1[0] . $d1[1] . '000000' + 0; $upper = $d2[2] . $d2[0] . $d2[1] . '999999' + 0; $sql = 'SELECT * FROM quotations WHERE client_id = ' . intval($cid) . ' AND stamp BETWEEN ' . $lower . ' AND ' . $upper . ' ORDER BY id DESC'; } try { $res = DatabaseHandler::GetAll($sql); $vouchers = []; foreach ($res as $quote) { $vouchers[] = QuotationVoucher::initialize($quote); } return $vouchers; } catch (Exception $e) { } } }
public static function GetClientTransactions($cid, $category, $dates, $all) { if ($category == 1) { //Statement if ($all == 'true') { $sql = 'SELECT * FROM general_ledger_entries WHERE account_no = ' . intval($cid) . ' AND ledger_name = "Debtors" ORDER BY id DESC'; } else { if ($dates != '') { $split = explode(' - ', $dates); $d1 = explode('/', $split[0]); $d2 = explode('/', $split[1]); $lower = $d1[2] . $d1[0] . $d1[1] . '000000' + 0; $upper = $d2[2] . $d2[0] . $d2[1] . '999999' + 0; $sql = 'SELECT * FROM general_ledger_entries WHERE account_no = ' . intval($cid) . ' AND ledger_name = "Debtors" AND stamp BETWEEN ' . $lower . ' AND ' . $upper . ' ORDER BY id DESC'; } } try { $res = DatabaseHandler::GetAll($sql); $vouchers = []; foreach ($res as $tx) { if ($tx['status'] == 1) { if ($tx['effect'] == 'cr') { if (stripos($tx['description'], 'Credit Note') !== false) { $voucher = CreditVoucher::GetVoucher(intval($tx['transaction_id'])); } else { $voucher = ReceiptVoucher::GetVoucher(intval($tx['transaction_id'])); } if ($voucher) { $vouchers[] = $voucher; } } else { $voucher = SalesVoucher::GetVoucher(intval($tx['transaction_id'])); if ($voucher) { $vouchers[] = $voucher; } } } elseif ($tx['status'] == 3) { $entry = new stdClass(); $entry->transactionId = $tx['transaction_id']; $entry->date = $tx['when_charged']; $entry->amount = $tx['amount']; $entry->description = $tx['description']; $sql2 = 'SELECT * FROM transactions WHERE id = ' . intval($tx['transaction_id']); $res2 = DatabaseHandler::GetRow($sql2); $entry->user = $res2['user']; $entry->type = $res2['type']; $vouchers[] = $entry; } } return $vouchers; } catch (Exception $e) { } } else { //Quotations if ($all == 'true') { $sql = 'SELECT * FROM quotations WHERE client_id = ' . intval($cid) . ' ORDER BY id DESC'; } else { $split = explode(' - ', $dates); $d1 = explode('/', $split[0]); $d2 = explode('/', $split[1]); $lower = $d1[2] . $d1[0] . $d1[1] . '000000' + 0; $upper = $d2[2] . $d2[0] . $d2[1] . '999999' + 0; $sql = 'SELECT * FROM quotations WHERE client_id = ' . intval($cid) . ' AND stamp BETWEEN ' . $lower . ' AND ' . $upper . ' ORDER BY id DESC'; } try { $res = DatabaseHandler::GetAll($sql); $vouchers = []; foreach ($res as $quote) { $vouchers[] = QuotationVoucher::initialize($quote); } return $vouchers; } catch (Exception $e) { } } }