plugins/openpsa/hours-to-nabaztag.php

   1 <?php
   2 require('Services/Nabaztag.php');
   3 require('CouchDb/Couch.php');
   4
   5 // Argument checks
   6 if (count($argv) != 4)
   7 {
   8     die("Usage: php hours-to-nabaztag.php dbname serialno apitoken\n");
   9 }
  10 $nabaztag = new Services_Nabaztag($argv[2], $argv[3]);
  11
  12 $couch = new Couch(array('host' => 'localhost', 'port' => 5984));
  13 if (!$couch->running())
  14 {
  15     die("Cannot connect to CouchDB in {$couch->host()}:{$coudh->port()}\n");
  16 }
  17
  18 $couchdb = $couch->database($argv[1], $couch);
  19 if(!$couchdb->exists())
  20 {
  21     die("CouchDB database {$couchdb->name()} does not exist\n");
  22 }
  23
  24 $total_hours = array();
  25
  26 // Construct the view
  27 //$view = $couchdb->newView();
  28 //$view->function = "function(doc) { return doc; }";
  29 //$hour_reports = $view->documents();
  30
  31 $everything = $couchdb->view('_all_docs')->documents();
  32 foreach ($everything as $object)
  33 {
  34     $document = $couchdb->get($object->id);
  35     if ($document->value->_type != 'hour_report')
  36     {
  37         continue;
  38     }
  39
  40     $month = substr($document->value->date->val, 0, 7);
  41     $day = substr($document->value->date->val, 0, 10);
  42     if (!isset($total_hours[$month]))
  43     {
  44         $total_hours[$month] = array();
  45         $total_hours[$month]['all'] = 0;
  46     }
  47     if (!isset($total_hours[$month][$day]))
  48     {
  49         $total_hours[$month][$day] = 0;
  50     }
  51
  52     $total_hours[$month]['all'] += $document->value->hours->val;
  53     $total_hours[$month][$day] += $document->value->hours->val;
  54 }
  55 ksort($total_hours);
  56
  57 $this_month = date('Y-m');
  58 $this_day = date('Y-m-d');
  59
  60 try
  61 {
  62     $stat = $nabaztag->say("In Ajatus we have " . round($total_hours[$this_month][$this_day]) . " hours reported today, and " . round($total_hours[$this_month][all]) . " reported this month.");
  63 }
  64 catch (Services_Nabaztag_Exception $e)
  65 {
  66     //echo $e;
  67 }
  68 ?>