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) { } }