public function getLedgers()
{
if ($this->validateAdmin()) {
echo json_encode(Ledger::GetLedgers());
} else {
echo 0;
}
}
public static function ResetTransactionBalances()
{
$ledgers = Ledger::GetLedgers();
foreach ($ledgers as &$ledger) {
$ledger->amount = 0;
}
$errors = [];
try {
$sql = 'SELECT * FROM transactions ORDER BY id ASC';
//$sql = 'SELECT transaction_id, amount FROM general_ledger_entries ORDER BY transaction_id';
$res = DatabaseHandler::GetAll($sql);
$steps = 0;
foreach ($res as $tx) {
try {
$sql2 = 'SELECT * FROM general_ledger_entries WHERE transaction_id = ' . $tx['id'];
$ress = DatabaseHandler::GetAll($sql2);
$defic = 0.0;
$tx['entr'] = count($ress);
foreach ($ress as $entry) {
if ($entry['effect'] == 'cr') {
self::UpdateTransaction($entry['id'], $entry['ledger_id'], $ledgers, 'cr', $entry['amount']);
} else {
self::UpdateTransaction($entry['id'], $entry['ledger_id'], $ledgers, 'dr', $entry['amount']);
}
$steps++;
}
} catch (Exception $e) {
}
}
foreach ($ledgers as $ledger) {
$sql = 'UPDATE ledgers SET balance = ' . $ledger->amount . ' WHERE id = ' . $ledger->id;
DatabaseHandler::Execute($sql);
}
return $ledgers;
} catch (Exception $e) {
}
}
