db->fetchObjectList($sql) as $row) {
$out .= sprintf('
%s ', $row->name);
$out .= '';
$out .= '';
}
return array('status' => true, 'list' => $out);;
}
public function ajax_savemachine()
{
if (empty($_POST['id'])) {
$sql = sprintf("INSERT INTO sprit_machine (name,active,sys_user,sys_edit) " .
"VALUES (%s,1,%s,now())",
$this->db->quote(utf8_decode($_POST['name'])),
$this->db->quote($_SERVER['REMOTE_USER']));
} else {
$sql = sprintf("UPDATE sprit_machine SET name=%s,sys_edit=now(),sys_user=%s WHERE id = %d",
$this->db->quote(utf8_decode($_POST['name'])),
$this->db->quote($_SERVER['REMOTE_USER']),
$_POST['id']);
}
return array('status' => $this->db->execute($sql));
}
public function ajax_savelog()
{
$data = array('machine' => intval($_POST['machine']),
'date' => assert_iso_date($_POST['date']),
'city' => $_POST['city'],
'tankstelle' => $_POST['tankstelle'],
'price_liter' => str_replace(',','.',$_POST['price_liter']),
'liter' => str_replace(',','.',$_POST['liter']),
'price' => str_replace(',','.',$_POST['price']),
'km' => intval($_POST['km']),
'km_total' => intval($_POST['km_total']),
'sys_edit' => 'now()',
'sys_user' => $_SERVER['REMOTE_USER']);
foreach ($data as $k => $v)
if (empty($v))
json_error(sprintf('Field %s must not be empty', $k));
if (empty($_POST['id'])) {
$ok = $this->db->insertInto('sprit_log', $data);
} else {
$ok = $this->db->update('sprit_log', $data, 'id = ' . intval($_POST['id']));
}
$d = explode('-', $data['date']);
return array('status' => $ok, 'year' => $d[0]);
}
public function ajax_loadyear()
{
$log = new SpritLog();
return array('status' => true,
'list' => $log->formatYear($_POST['year']),
'year' => $_POST['year']);
}
}