public function reset(Request\Reset $request)
{
$result = new Response\Reset();
$dateFrom = $request->getDateFrom();
/* TODO: quote $dateFrom to prevent SQL injects */
$where = Balance::ATTR_DATE . '>=' . $dateFrom;
$rows = $this->_repoBalance->delete($where);
if ($rows !== false) {
$result->setRowsDeleted($rows);
$result->markSucceed();
}
return $result;
}
private function _checkBalancesHistory()
{
/* check first account balance*/
$data = $this->_repoBalance->getById([Balance::ATTR_ACCOUNT_ID => $this->acc1[Account::ATTR_ID], Balance::ATTR_DATE => self::DATA_DATE_BALANCE_CHECK]);
$this->assertEquals(0, $data->getBalanceOpen());
$this->assertEquals(30, $data->getTotalDebit());
$this->assertEquals(0, $data->getTotalCredit());
$this->assertEquals(-30, $data->getBalanceClose());
/* check second account balance*/
$data = $this->_repoBalance->getById([Balance::ATTR_ACCOUNT_ID => $this->acc2[Account::ATTR_ID], Balance::ATTR_DATE => self::DATA_DATE_BALANCE_CHECK]);
$this->assertEquals(0, $data->getBalanceOpen());
$this->assertEquals(0, $data->getTotalDebit());
$this->assertEquals(30, $data->getTotalCredit());
$this->assertEquals(30, $data->getBalanceClose());
$this->_logger->debug("Balance history (in 'balance' table) is checked.");
}
