$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);
