<?php
// DO NOT EDIT THIS FILE.
// This file was generated by searchgen.
// If you need to customize this file, please edit the corresponding
// yaml file in the gencfg directory, and then re-generate this file
// by running searchgen, passing in the table name.
if (isset($command) && $command == 'loadIncomeexpense') {
header('Content-Type: application/json');
$db = ConnectionFactory::getConnection();
$incomeexpenseDAO = new IncomeexpenseDAO($db);
$id = isset($params['id']) ? (int) trim($params['id']) : 0;
if ($id <= 0) {
$rows = array(Incomeexpense::createDefault());
} else {
$sql = <<<EOF
select * from incomeexpense pri where pri.id = ?
EOF;
$ps = new PreparedStatement($sql, 0, 1);
$ps->setInt($id);
$rows = $incomeexpenseDAO->findWithPreparedStatement($ps);
}
echo json_encode($rows);
$db->close();
exit;
}
public static function createDefault()
{
$v = new Incomeexpense();
$v->defaultAllFields();
return $v;
}
$db->commitTransaction();
$committed = true;
$result->successMsg .= sprintf(_t('crud.idUpdated'), _t('crud.incomeexpense.tableDescription', 'Incomeexpense'), $row->id) . "\n";
}
}
if (!$success) {
if ($result->errorMsg == '' && empty($result->fieldErrors)) {
$result->errorMsg .= sprintf(_t('crud.rowCouldNotBeUpdated'), _t('crud.incomeexpense.tableDescription', 'Incomeexpense')) . "\n";
}
}
}
}
} else {
// if ($row->id > 0)
// Convert the value object into the actual entity.
$newRow = new Incomeexpense();
$newRow->loadFromArray((array) $row);
if (function_exists('preInsertHook')) {
preInsertHook();
}
try {
$success = $incomeexpenseDAO->insert($newRow);
} catch (Exception $ex) {
$success = false;
}
if ($success) {
$row->id = $newRow->id;
$justInsertedRowId = $newRow->id;
if (function_exists('postInsertHook')) {
postInsertHook();
}
public function findWithPreparedStatement($ps)
{
$cacheKey = null;
if ($this->cache !== null) {
$cacheKey = serialize($ps);
if (($rows = $this->cache->get($cacheKey)) !== false) {
return $rows;
}
}
$rows = array();
$rs = $this->connection->executeQuery($ps);
while ($arr = $this->connection->fetchArray($rs)) {
$row = new Incomeexpense();
$row->loadFromArray($arr);
$rows[] = $row;
}
$this->connection->freeResult($rs);
if ($this->cache !== null) {
$this->cache->set($cacheKey, $rows);
}
return $rows;
}