<?php
// Expenses visualisation //
// new expense
header('Content-Type: application/json');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$EXP = new Expenses\Expenses();
if (!$EXP->user_id()) {
exit(json_encode(['error' => 'please login']));
}
switch ($_POST['do']) {
case 'save':
//print_r($_POST);
$dat = [];
if ($id = $EXP->newExpense($_POST)) {
$dat['id'] = $id;
exit(json_encode($dat));
}
$dat['error'] = "nope";
exit(json_encode($dat));
break;
case 'getExpenses':
//print_r($_POST);
$dat = $EXP->expenseByDay($_POST['day']);
foreach ($dat as $k => $v) {
$dat[$k]['time'] = substr($v['time'], 0, 5);
}
exit(json_encode($dat));
break;
case 'delete':
for ($c = 0; $c < $num; $c++) {
$rows[$row][] = $data[$c];
}
$row++;
}
fclose($handle);
$cols = array_shift($rows);
//print_r($cols);exit;
//echo "<pre>";print_r($rows);echo "</pre>";
// Start importing //
foreach ($rows as $row) {
//print_r($row);exit;
$dat = [];
$dat['date'] = $row[0];
$dat['name'] = $row[1];
$dat['value'] = $row[2] * 1;
$dat['currency'] = 'EUR';
if ($EXP->newExpense($dat)) {
$imported++;
}
}
}
case 'xls':
echo "<pre>_FILES=";
print_r($_FILES);
echo "</pre>";
break;
default:
exit("Unknow Ext: {$ext}");
}
exit("{$imported} expense(s) imported");
