pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
+ if ($_POST['func'] == 'save') {
+ $sql = sprintf("UPDATE stempel SET task = '%s' WHERE oid = %d",
+ pg_escape_string(utf8_decode($_POST['task'])),
+ $_POST['oid']);
+ pg_exec($sql);
+
+ header('Content-type: application/json; charset="UTF-8"');
+ echo json_encode(true);
+ exit;
+ }
+
if (isset($_GET['month']))
$month = $_GET['month'];
else
$month = date('Y-m');
?>
+<future>
<page func=InfoCon title="Stempeluhr">
+<script type="text/javascript" src="<root_prefix>jquery.editable.js"></script>
<?
+ $name = load_customers();
+
$table_head = '<h3 class="bar">Kunde: %s</h3>
<table class="smallfont border" width="100%%" cellpadding=0 cellspacing=1>
<tr class="head">
<th width=80%%>Arbeitsbeschreibung</th>
</tr>';
$table_foot = '</table>';
- $table_row = '<tr class="t%d"><td>%s</td><td align="center">%s</td><td align="center">%s</td><td><a href="edit.php?id=%d">%s</a></td></tr>';
+ if (strpos($_SERVER['HTTP_USER_AGENT'], 'Mozilla/') === false)
+ $table_row = '<tr class="t%d"><td>%s</td><td align="center">%s</td><td align="center">%s</td><td><a href="edit.php?id=%d">%s</a></td></tr>';
+ else
+ $table_row = '<tr class="t%d"><td>%s</td><td align="center">%s</td><td align="center">%s</td><td><span route="Stempel/EditTask" item_id="%d">%s</span></td></tr>';
$table_sum = '<tr class="t%d"><td> </td><td align="center"><strong>%s</strong></td><td> </td><td><strong>Summe</strong></td></tr>';
- $query = "SELECT stempel.oid,start,customer,time,task,kurz FROM stempel JOIN stempel_status ON (stempel.status = stempel_status.id) WHERE time IS NOT NULL ";
+ $query = <<<EOS
+SELECT stempel.oid,stempel.id,start,stempel_customer.name AS customer,time,task,kurz
+FROM stempel
+JOIN stempel_customer ON (stempel.customer = stempel_customer.short)
+JOIN stempel_status ON (stempel.status = stempel_status.id)
+WHERE time IS NOT NULL
+EOS;
if (isset($month) && $month !== 'all')
- $query .= "AND cast(start AS TEXT) LIKE '".$month."-%' ";
- $query .= "ORDER BY customer,start";
+ $query .= " AND cast(start AS TEXT) LIKE '".$month."-%'";
+ $query .= " ORDER BY customer,start";
$sth = pg_exec ($dbh, $query);
printf($table_sum, $color, min2hour($sum));
echo($table_foot);
}
- printf($table_head, $row['customer']);
+ $cname = $name[$row['customer']];
+ if (!strlen($cname)) $cname = $row['customer'];
+ printf($table_head, $cname);
$customer = $row['customer'];
$sum = 0;
$color = 0;
$sum += $row['time'];
$d = explode(' ', $row['start']);
- printf($table_row, $color, $d[0], min2hour($row['time']), $row['kurz'], $row['oid'], htmlspecialchars($row['task']));
+ printf($table_row, $color, $d[0], min2hour($row['time']), $row['kurz'],
+ strpos($_SERVER['HTTP_USER_AGENT'], 'Mozilla/') === false ? $row['oid'] : $row['id'],
+ htmlspecialchars($row['task'], ENT_COMPAT | ENT_HTML401, 'ISO-8859-1'));
$color = !$color;
}
printf($table_sum, $color, min2hour($sum));
</form>
<div style="padding-top: 0.5em"></div>
+<protect><script type="text/javascript">
+$(function(){
+ make_editable('table.smallfont tr span');
+});
+</script></protect>
</page>
# Local variables: