<?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)); }