$db = new NotORM($pdo);
$app->get('/', function () {
echo 'ICONMERCE - RESTful Services';
});
$app->get('/users', function () use($app, $db) {
$users = array();
foreach ($db->users() as $user) {
$users[] = array('user_id' => $user['user_id'], 'username' => $user['username'], 'password' => $user['password'], 'email' => $user['email']);
}
$app->response()->header("Content-Type", "application/json");
echo json_encode($users, JSON_FORCE_OBJECT);
});
$app->get("/transactions", function () use($app, $db) {
$app->response()->header("Content-Type", "application/json");
$transactions = array();
$trans = $db->transactions()->order("date");
foreach ($trans as $trans) {
$transactions[] = array('transactionId' => $trans['transactionId'], 'userId' => $trans['userId'], 'isDeposit' => $trans['isDeposit'], 'amount' => $trans['amount'], 'date' => $trans['date'], 'category' => $trans['category']);
}
echo json_encode($transactions, JSON_FORCE_OBJECT);
});
$app->get("/transMonth/:month/:year", function ($month, $year) use($app, $db) {
$app->response()->header("Content-Type", "application/json");
$trans = $db->transactions()->where(array("month(date)" => $month, "year(date)" => $year));
$transactions = array();
foreach ($trans as $data) {
$transactions[] = array('transactionId' => $data['transactionId'], 'userId' => $data['userId'], 'isDeposit' => $data['isDeposit'], 'amount' => $data['amount'], 'date' => $data['date'], 'category' => $data['category']);
}
echo json_encode($transactions, JSON_FORCE_OBJECT);
});
$app->get('/users/:id', function ($id) use($app, $db) {
