public function getLedgerType($type)
{
if ($this->validateAdmin()) {
echo json_encode(Ledger::GetLedgerType($type));
} else {
echo 0;
}
}
public static function ExpenseDescrStatement($descr, $dates, $all)
{
$ledgers = Ledger::GetLedgerType('"Expense"');
$query = '';
$count = 1;
foreach ($ledgers as $ledger) {
if ($count == 1) {
$query .= 'ledger_id = ' . $ledger->id . ' ';
} else {
$query .= 'OR ledger_id = ' . $ledger->id . ' ';
}
$count++;
}
if ($all == 'true') {
if ($descr != '') {
$sql = 'SELECT * FROM general_ledger_entries WHERE description LIKE "%' . $descr . '%" AND (' . $query . ') AND effect = "dr" AND status = 1 ORDER BY id DESC';
} else {
$sql = 'SELECT * FROM general_ledger_entries WHERE (' . $query . ') AND effect = "dr" AND status = 1 ORDER BY id DESC';
}
} else {
if ($dates != '') {
$split = explode(' - ', $dates);
$d1 = explode('/', $split[0]);
$d2 = explode('/', $split[1]);
$lower = $d1[2] . $d1[1] . $d1[0] . '000000' + 0;
$upper = $d2[2] . $d2[1] . $d2[0] . '999999' + 0;
if ($descr != '') {
$sql = 'SELECT * FROM general_ledger_entries WHERE description LIKE "%' . $descr . '%" AND (' . $query . ') AND effect = "dr" AND status = 1 AND stamp BETWEEN ' . $lower . ' AND ' . $upper . ' ORDER BY id DESC';
} else {
$sql = 'SELECT * FROM general_ledger_entries WHERE (' . $query . ') AND effect = "dr" AND status = 1 AND stamp BETWEEN ' . $lower . ' AND ' . $upper . ' ORDER BY id DESC';
}
}
}
try {
$result = DatabaseHandler::GetAll($sql);
/*foreach ($result as &$tx) {
$sql2 = 'SELECT type FROM transactions WHERE id = '.intval($tx['transaction_id']);
$res = DatabaseHandler::GetOne($sql2);
$tx['type'] = $res;
}*/
return $result;
} catch (Exception $e) {
}
}
