$response['status'] = "success"; $response['message'] = "Hapus data berhasil!"; } else { $response['status'] = "error"; $response['message'] = "Maaf, hapus data tidak berhasil!"; } $result["result"] = array($response['status'], $response['message']); echo json_encode($result); }); /* END TINGKATAN */ /* BEGIN PENGGUNA */ $app->get('/pengguna', function () use($app) { $response = array(); $db = new DbHandler(); $query = "select a.*,@rownum:=@rownum+1 as num from (select u.iduser,u.user,u.nama_lengkap,ul.userlevel from user u inner join userlevel ul on u.iduserlevel=ul.iduserlevel) a, (select @rownum:=0) r order by a.iduser"; $pengguna = $db->getRecords($query); $result["result"] = $pengguna; echo json_encode($result); }); $app->get('/pengguna/:iduser', function ($iduser) use($app) { $db = new DbHandler(); $query = "select * from user where iduser="******"result"] = array(); if ($pengguna) { $result["result"] = array($pengguna); } echo json_encode($result); }); $app->put('/pengguna/:iduser', function ($iduser) use($app) { $response = array();
$app->stop(); } $db = new DbHandler(); $db->updateOneRecord("update users set teamname = '{$tn}' where name='{$tl}'"); $response["status"] = "success"; $response["message"] = "Moved '{$tl}' to '{$tn}'"; echoResponse(200, $response); }); $app->post('/getteammates', function () use($app) { $response = array(); $r = json_decode($app->request->getBody()); $role = $r->role; $uid = $r->uid; $db = new DbHandler(); if ($role == "admin") { $result_teammates = $db->getRecords("select name,teamname from users where teamname != ''"); $result_free_teammates = $db->getRecords("select name from users where teamname = ''"); $result_tn = $db->getRecords("select teamname from users where teamname != ''"); $result_roles = $db->getRecords("SELECT user_roles.name,user_roles.role,user_roles.teamname FROM user_roles LEFT JOIN users ON user_roles.uid = users.uid WHERE users.role = 'team_member'"); $result_free_roles = $db->getRecords("SELECT users.name,users.teamname FROM users WHERE users.uid NOT IN (SELECT user_roles.uid FROM user_roles) AND users.role = 'team_member'"); $response["teammates"] = $result_teammates; $response["free_teammates"] = $result_free_teammates; $response["tn"] = $result_tn; $response["roles"] = $result_roles; $response["free_roles"] = $result_free_roles; $response["status"] = "success"; $response["message"] = "Users Found"; echoResponse(200, $response); } else { $result_tn = $db->getOneRecord("select teamname from users where uid='{$uid}'"); $teamname = $result_tn['teamname'];