function einsatz_callback(data)
{
info('Neuer Arbeitsbericht gespeichert');
+ window.location.reload();
}
function einsatz_submit()
"VALUES (%d,%d,%s,%.2f,'%s',now())",
$einsatz,
$_POST['geraet'.$app],
- $_POST['anbaugeraet'.$app],
- empty($_POST['stunden'.$app]) ? 'NULL' : intval($_POST['stunden'.$app]),
+ empty($_POST['anbaugeraet'.$app]) ? 'NULL' : intval($_POST['anbaugeraet'.$app]),
+ $_POST['stunden'.$app],
pg_escape_string($_SESSION['sys']['login']));
$sth = pg_query($sql);
'sql' => 'SELECT id,arbeitsart AS text FROM arbeitsarten ORDER BY text',
),
'kostenstellen' => array(
- 'sql' => 'SELECT id,kostenstelle AS text FROM kostenstellen WHERE gebiet = {gebiet}',
+ 'sql' => 'SELECT id,kostenstelle AS text FROM kostenstellen WHERE gebiet = {gebiet} ORDER BY text',
),
'anbaugeraete' => array(
- 'sql' => 'SELECT anbaugeraete.id,anbaugeraet as TEXT FROM anbaugeraete ' .
+ 'sql' => 'SELECT anbaugeraete.id,anbaugeraet as text FROM anbaugeraete ' .
'JOIN gerate ON anbaugeraete.geraetetyp = gerate.geraetetyp ' .
- 'WHERE gerate.id = {geraet}',
+ 'WHERE gerate.id = {geraet} ORDER BY text',
),
),
);