$id_exists = $db->getOneRecord("select teamleadid from teamleadid where teamleadid='{$teamleadid}'"); $isUserExists = $db->getOneRecord("select 1 from users where email='{$email}'"); if (!$isUserExists && ($id_exists || $role == 'team_member') && $role != 'admin') { $r->customer->password = passwordHash::hash($password); $tabble_name = "users"; $column_names = array('work_phone', 'mobile_phone', 'name', 'email', 'password', 'address', 'DOB', 'role', 'teamleadid', 'teamname', 'companyname', 'active'); $result = $db->insertIntoTable($r->customer, $column_names, $tabble_name); if ($result != NULL) { $db = new DbHandler(); $key = $name . $email; $key = md5($key); $confirm_tabble_name = "confirm"; $confirm_column_names = array('id', 'validation_key', 'email'); $content = array('id' => 'NULL', 'validation_key' => $key, 'email' => $email); $object = json_decode(json_encode($content), FALSE); $plz = $db->insertIntoTable($object, $confirm_column_names, $confirm_tabble_name); $response["status"] = "success"; $response["message"] = "User account created successfully. Check email for validation."; $response["uid"] = $result; if (!isset($_SESSION)) { session_start(); } $_SESSION['uid'] = $response["uid"]; $_SESSION['phone'] = $work_phone; $_SESSION['name'] = $name; $_SESSION['email'] = $email; $_SESSION['email'] = $role; echoResponse(200, $response); $mails = new emailConfirmation(); $mails->sendEmail($email, $name, $key); } else {
$lista = array(); $idrol = $r->idrol; $lista = $r->opciones; $response = array(); // // // Ejemplo de uso de un insert: // // select fn_ins_seg_opcion('Ingresa opciones', 'ingreso de opciones', 'Opciones' , 0, 1, 1) // $db = new DbHandler(); $column_names = array('idrol', 'idopcion'); foreach ($lista as $opcion) { $permiso->idrol = $idrol; $permiso->idopcion = $opcion->id; $result = $db->insertIntoTable($permiso, $column_names, 'seg_rol_opcion'); } //$id = $db->get1Record("call sp_ins_seg_opcion_idRol( '$idrol', '$idopcion' )"); if (is_null($result)) { $response['status'] = "info"; $response['message'] = 'No fue posible agregar los datos'; } else { $response['status'] = "success"; $response['message'] = 'Se agrego correctamente'; $response['data'] = $result; } echoResponse(200, $response); }); // OpciĆ³n para eliminar un registro de la tabla seg_rol_opcion $app->get('/perD/:idopcion/:idrol', 'sessionAlive', function ($idopcion, $idrol) use($app) { // Recupera los datos de la forma
$response = array(); $r = json_decode($app->request->getBody()); verifyRequiredParams(array('email', 'name', 'password'), $r->user); require_once 'passwordHash.php'; $db = new DbHandler(); $phone = $r->user->phone; $name = $r->user->name; $email = $r->user->email; $address = $r->user->address; $password = $r->user->password; $isUserExists = $db->getOneRecord("select 1 from users where phone='{$phone}' or email='{$email}'"); if (!$isUserExists) { $r->user->password = passwordHash::hash($password); $tabble_name = "users"; $column_names = array('phone', 'name', 'email', 'password', 'city', 'address'); $result = $db->insertIntoTable($r->user, $column_names, $tabble_name); if ($result != NULL) { $response["status"] = "success"; $response["message"] = "User account created successfully"; $response["uid"] = $result; if (!isset($_SESSION)) { session_start(); } $_SESSION['uid'] = $response["uid"]; $_SESSION['phone'] = $phone; $_SESSION['name'] = $name; $_SESSION['email'] = $email; echoResponse(200, $response); } else { $response["status"] = "error"; $response["message"] = "Failed to create user. Please try again";
$response['message'] = "Update data berhasil!"; } else { $response['status'] = "error"; $response['message'] = "Maaf, update data tidak berhasil!"; } $result["result"] = array($response['status'], $response['message']); echo json_encode($result); }); $app->post('/tingkatan/0', function () use($app) { $response = array(); $db = new DbHandler(); $r = json_decode($app->request->getBody()); $userlevel = $r->userlevel; $table_name = "userlevel"; $column_names = array('userlevel'); $tingkatan = $db->insertIntoTable($r, $column_names, $table_name); if ($tingkatan != NULL) { $response["status"] = "success"; $response["message"] = "Tambah data berhasil"; } else { $response['status'] = "error"; $response['message'] = "Maaf, tambah data tidak berhasil!"; } $result["result"] = array($response['status'], $response['message']); echo json_encode($result); }); $app->delete('/tingkatan/:iduserlevel', function ($iduserlevel) use($app) { $response = array(); $db = new DbHandler(); $query = "delete from userlevel where iduserlevel=" . $iduserlevel; $tingkatan = $db->deleteRecord($query);