<?php
// Expenses visualisation //
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 'addNew':
$dat = [];
if ($id = $EXP->parseInsert($_POST['date'] . ' ' . $_POST['str'])) {
//$dat['post']=$_POST;
$dat['id'] = $id * 1;
exit(json_encode($dat));
}
exit(json_encode($_POST));
case 'save':
//exit(json_encode($_POST));
$dat = [];
$updated = $EXP->update($_POST['ed_id'], $_POST);
if ($updated) {
$dat['msg'] = 'updated';
} else {
$dat['error'] = 'NOT updated';
}
exit(json_encode($dat));
case 'expenseByDay':
// on the same day
}
switch ($_POST['do']) {
case 'today':
$today = date("Y-m-d");
$sql = "SELECT * FROM expenses_data WHERE ed_uid=" . $EXP->user_id() . " AND ed_date LIKE '{$today}%' ORDER BY ed_date;";
$q = $EXP->db()->query($sql) or die;
//echo $sql;exit;
$dat = [];
while ($r = $q->fetch(PDO::FETCH_ASSOC)) {
$r['date'] = explode(" ", $r['ed_date'])[0];
$r['time'] = explode(" ", $r['ed_date'])[1];
$r['time'] = substr($r['time'], 0, 5);
$dat[] = $r;
}
exit(json_encode($dat));
case 'savenew':
//print_r($_POST);exit;
$dat = [];
if ($id = $EXP->parseInsert($_POST['str'])) {
$dat['inserted'] = $id;
}
exit(json_encode($dat));
case 'delete':
if ($EXP->delete($_POST['id'])) {
$dat['delete'] = 'ok';
exit(json_encode($dat));
}
exit(json_encode($_POST));
default:
exit(json_encode($_POST));
}
