plugins/openpsa/export-expenses.php

   1 <?php
   2 require('CouchDb/Couch.php');
   3 $couch = new Couch(array('host' => 'localhost', 'port' => 5984));
   4 if (!$couch->running())
   5 {
   6     die("Cannot connect to CouchDB in {$couch->host()}:{$coudh->port()}\n");
   7 }
   8
   9 $couchdb = $couch->database('ajatus_db_content', $couch);
  10 if(!$couchdb->exists())
  11 {
  12     die("CouchDB database {$couchdb->name()} does not exist\n");
  13 }
  14
  15 $expenses = array();
  16 $total_expenses = array();
  17
  18 // Construct the view
  19 $view = $couchdb->newView();
  20 $view->function = "function(doc) { if (doc.value._type == 'expense') { map(null, doc); }}";
  21 $results = $view->documents();
  22
  23 foreach ($results as $result)
  24 {
  25     $document = $result->value;
  26     $creator = $document->value->metadata->creator->val;
  27     if (!isset($expenses[$creator]))
  28     {
  29         $expenses[$creator] = array();
  30     }
  31
  32     /*if ($document->value->date->val < '2008-06-16T00:00:00')
  33     {
  34         continue;
  35     }*/
  36
  37     $month = substr($document->value->date->val, 0, 7);
  38     if (!isset($expenses[$creator][$month]))
  39     {
  40         $expenses[$creator][$month] = array();
  41     }
  42     if (!isset($total_expenses[$month]))
  43     {
  44         $total_expenses[$month] = array();
  45         $total_expenses[$month]['all'] = 0;
  46     }
  47     if (!isset($total_expenses[$month][$creator]))
  48     {
  49         $total_expenses[$month][$creator] = 0;
  50     }
  51
  52     $expenses[$creator][$month][] = array
  53     (
  54         'date' => $document->value->date->val,
  55         'amount' => $document->value->amount->val,
  56         'vat' => $document->value->vat->val,
  57         'description' => $document->value->description->val,
  58     );
  59
  60     $total_expenses[$month]['all'] += $document->value->amount->val;
  61     $total_expenses[$month][$creator] += $document->value->amount->val;
  62 }
  63 ksort($total_expenses);
  64
  65 foreach ($total_expenses as $month => $type)
  66 {
  67     echo "{$month}\n-------\n";
  68     foreach ($type as $reporter => $expenses_sum)
  69     {
  70         echo "{$reporter}: {$expenses_sum} EUR\n";
  71     }
  72     echo "\n";
  73 }
  74 ?>