CSV generator for hamster timetracker

rich1.0phorkiehttps://p.cweiske.de/CSV generator for hamster timetrackerChristian Weiske86400900900 <link rel="stylesheet" href="https://p.cweiske.de/css/embed.css"/> <div class="phork" id="294"> <div class="phork-file"> <div class="phork-content"> <style type="text/css">/** * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann * (http://qbnz.com/highlighter/ and http://geshi.org/) */ .php .de1, .php .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;} .php {font-family:monospace;} .php .imp {font-weight: bold; color: red;} .php li, .php .li1 {color: #DDD;} .php .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;} .php .kw1 {color: #b1b100;} .php .kw2 {color: #000000; font-weight: bold;} .php .kw3 {color: #990000;} .php .kw4 {color: #009900; font-weight: bold;} .php .co1 {color: #666666; font-style: italic;} .php .co2 {color: #666666; font-style: italic;} .php .co3 {color: #0000cc; font-style: italic;} .php .co4 {color: #009933; font-style: italic;} .php .coMULTI {color: #666666; font-style: italic;} .php .es0 {color: #000099; font-weight: bold;} .php .es1 {color: #000099; font-weight: bold;} .php .es2 {color: #660099; font-weight: bold;} .php .es3 {color: #660099; font-weight: bold;} .php .es4 {color: #006699; font-weight: bold;} .php .es5 {color: #006699; font-weight: bold; font-style: italic;} .php .es6 {color: #009933; font-weight: bold;} .php .es_h {color: #000099; font-weight: bold;} .php .br0 {color: #009900;} .php .sy0 {color: #339933;} .php .sy1 {color: #000000; font-weight: bold;} .php .st0 {color: #0000ff;} .php .st_h {color: #0000ff;} .php .nu0 {color: #cc66cc;} .php .nu8 {color: #208080;} .php .nu12 {color: #208080;} .php .nu19 {color:#800080;} .php .me1 {color: #004000;} .php .me2 {color: #004000;} .php .re0 {color: #000088;} .php span.xtra { display:block; } </style><div class="code"><table class="php"><tbody><tr class="li1"><td class="ln"><pre class="de1">1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 </pre></td><td class="de1"><pre class="de1">#!/usr/bin/env php <?php /**  * Generate a CSV file from the hamster timetracker database.  * Output is only two columns: date and hours worked that day.  *  * Works with hamster 2.91.3  */ $dbfile = <a href="http://www.php.net/getenv">getenv</a>('HOME') . '/.local/share/hamster-applet/hamster.db'; if (!<a href="http://www.php.net/is_readable">is_readable</a>($dbfile)) {     echo "Database file does not exist\n";     echo $dbfile . "\n";     <a href="http://www.php.net/exit">exit</a>(1); }   $db = new PDO('sqlite:' . $dbfile); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);   $stmt = $db->query(     'SELECT start_time, end_time'     . ' FROM facts'     //. ' JOIN activities ON facts.activity_id = activities.id'     //. ' JOIN categories ON activities.category_id = categories.id'     . ' ORDER BY facts.start_time'     //. ' LIMIT 10' );   echo "date;sum\n";   $lastDate = null; $lastSum  = 0; while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {     $date = <a href="http://www.php.net/substr">substr</a>($row['start_time'], 0, 10);     if ($date != $lastDate && $lastDate !== null) {         echo $lastDate . ';' . <a href="http://www.php.net/gmdate">gmdate</a>('H:i:s', $lastSum) . "\n";         $lastSum = 0;     }     $lastSum += <a href="http://www.php.net/strtotime">strtotime</a>($row['end_time']) - <a href="http://www.php.net/strtotime">strtotime</a>($row['start_time']);     $lastDate = $date; } if ($lastDate !== null) {     echo $lastDate . ';' . <a href="http://www.php.net/gmdate">gmdate</a>('H:i:s', $lastSum) . "\n"; } ?>  </pre></td></tr></tbody></table></div> </div> <div class="phork-meta"> <a href="https://p.cweiske.de/294/rev-raw/5686c8ae1c1160d74686990e9e97efab269aa640/hamstercsv.php" style="float: right">view raw source</a> <a href="https://p.cweiske.de/294#hamstercsv.php">hamstercsv.php</a> </div> </div> </div>