plugins/ajatus/examples/export_expenses.php

   1 <?php
   2 require_once(realpath(dirname(__FILE__) . '/') . '/../ajatus.php');
   3
   4 $db = 'ajatus_dev_db';
   5 $content_db = "{$db}_content";
   6
   7 try
   8 {
   9     $ajatus = new ajatus(array(
  10         'host' => 'couchdb_server',
  11         'db' => $db
  12     ));
  13 }
  14 catch (ajatus_exception $e)
  15 {
  16     die( "Error initializing Ajatus! Reason:\n{$e}\n" );
  17 }
  18
  19 $expense_reports = $ajatus->types->expense->all(array
  20     (
  21         'additional_map_values' => array
  22         (
  23             'description' => 'doc.value.description'
  24         )
  25     )
  26 )->rows;
  27
  28 $report_count = count($expense_reports);
  29
  30 $status_for_everyone = array();
  31 $totals_for_users = array();
  32
  33 foreach ($expense_reports as $expense)
  34 {
  35     $reporter = $expense->value->creator->val;
  36     $amount = $expense->value->amount->val;
  37
  38     $description = $report->value->description->val;
  39
  40     $date_ts = ajatus_helpers_date::jsdatetime_to_unixtime($expense->value->date->val);
  41
  42     $identifier = (string) date("Y-m", $date_ts);
  43
  44     if (! isset($status_for_everyone[$identifier]))
  45     {
  46         $status_for_everyone[$identifier] = 0;
  47     }
  48
  49     if (! isset($status_for_users[$identifier]))
  50     {
  51         $status_for_users[$identifier] = array();
  52     }
  53
  54     if (! isset($status_for_users[$identifier][$reporter]))
  55     {
  56         $status_for_users[$identifier][$reporter] = 0;
  57     }
  58
  59     $status_for_everyone[$identifier] += $amount;
  60     $status_for_users[$identifier][$reporter] += $amount;
  61 }
  62 ksort($status_for_everyone);
  63
  64 foreach ($status_for_everyone as $identifier => $month_total)
  65 {
  66     echo "{$identifier}\n------------\n";
  67
  68     foreach ($status_for_users[$identifier] as $reporter => $total)
  69     {
  70         echo "  {$reporter} => {$total}\n";
  71     }
  72
  73     echo "Total: {$month_total}\n\n";
  74 }
  75
  76 ?>