/**
*
*/
public function register_user_informationAction()
{
$dataRequest = $this->request->getJsonPost();
$fields = array("key", "name", "last_name", "email", "image", "phone", "uuid", "platform");
if ($this->_checkFields($dataRequest, $fields)) {
if ($this->_validKey()) {
$user = new User();
$user->setName($dataRequest->name);
$user->setLastName($dataRequest->last_name);
$user->setEmail($dataRequest->email);
$user->setImage($dataRequest->image);
$user->setPhone($dataRequest->phone);
$user->setUuid($dataRequest->uuid);
$user->setPlatform($dataRequest->platform);
$user->setSession(true);
$user->setFirstConnection($this->_dateTime->format("Y-m-d H:m:s"));
$user->setLastConnection($this->_dateTime->format("Y-m-d H:m:s"));
$user->setStatus(1);
if ($user->save()) {
$this->setJsonResponse(ControllerBase::SUCCESS, ControllerBase::FAILED_MESSAGE, array("status" => $this->strings->getString("http", "success"), "message" => $this->strings->getString("user", "insert_success"), "data" => array("user_id" => $user->getIdUser())));
} else {
$this->setJsonResponse(ControllerBase::SUCCESS, ControllerBase::FAILED_MESSAGE, array("status" => $this->strings->getString("http", "error"), "message" => $this->_checkError($user), "data" => $return));
}
}
}
}
public function showAll($limit = null, $batas = null)
{
@Session::createSession();
$role = Session::get('role');
$bagian = Session::get('bagian');
$user = Session::get('user');
if (Auth::isRole($role, 2) and !Auth::isBagian($bagian, 1)) {
$sql = "SELECT a.id_suratkeluar as id_suratkeluar,\r\n a.rujukan as rujukan,\r\n a.no_surat as no_surat,\r\n a.tgl_surat as tgl_surat,\r\n b.nama_satker as tujuan,\r\n a.perihal as perihal,\r\n c.sifat_surat as sifat,\r\n d.klasifikasi as jenis,\r\n a.lampiran as lampiran,\r\n a.file as file,\r\n e.status as status,\r\n h.namaPegawai as user,\r\n f.tipe_naskah as tipe,\r\n a.start as start\r\n FROM suratkeluar a LEFT JOIN alamat b ON a.tujuan = b.kode_satker\r\n LEFT JOIN sifat_surat c ON a.sifat = c.kode_sifat\r\n LEFT JOIN klasifikasi_surat d ON a.jenis = d.kode_klassurat\r\n LEFT JOIN status e ON a.status = e.id_status\r\n LEFT JOIN tipe_naskah f ON a.tipe = f.id_tipe \r\n LEFT JOIN notifikasi g ON a.id_suratkeluar = g.id_surat\r\n LEFT JOIN user h ON a.user = h.username\r\n WHERE g.jenis_surat='SK' AND g.id_user="******"\r\n GROUP BY a.id_suratkeluar ORDER BY a.id_suratkeluar DESC";
} elseif (Auth::isRole($role, 3)) {
$sql = "SELECT a.id_suratkeluar as id_suratkeluar,\r\n a.rujukan as rujukan,\r\n a.no_surat as no_surat,\r\n a.tgl_surat as tgl_surat,\r\n b.nama_satker as tujuan,\r\n a.perihal as perihal,\r\n c.sifat_surat as sifat,\r\n d.klasifikasi as jenis,\r\n a.lampiran as lampiran,\r\n a.file as file,\r\n e.status as status,\r\n h.namaPegawai as user,\r\n f.tipe_naskah as tipe,\r\n a.start as start\r\n FROM suratkeluar a LEFT JOIN alamat b ON a.tujuan = b.kode_satker\r\n LEFT JOIN sifat_surat c ON a.sifat = c.kode_sifat\r\n LEFT JOIN klasifikasi_surat d ON a.jenis = d.kode_klassurat\r\n LEFT JOIN status e ON a.status = e.id_status\r\n LEFT JOIN tipe_naskah f ON a.tipe = f.id_tipe\r\n LEFT JOIN user h ON a.user = h.username\r\n WHERE a.user='******'\r\n GROUP BY a.id_suratkeluar ORDER BY a.id_suratkeluar DESC";
} else {
$sql = "SELECT a.id_suratkeluar as id_suratkeluar,\r\n a.rujukan as rujukan,\r\n a.no_surat as no_surat,\r\n a.tgl_surat as tgl_surat,\r\n b.nama_satker as tujuan,\r\n a.perihal as perihal,\r\n c.sifat_surat as sifat,\r\n d.klasifikasi as jenis,\r\n a.lampiran as lampiran,\r\n a.file as file,\r\n e.status as status,\r\n h.namaPegawai as user,\r\n f.tipe_naskah as tipe,\r\n a.start as start\r\n FROM suratkeluar a JOIN alamat b ON a.tujuan = b.kode_satker\r\n JOIN sifat_surat c ON a.sifat = c.kode_sifat\r\n JOIN klasifikasi_surat d ON a.jenis = d.kode_klassurat\r\n JOIN status e ON a.status = e.id_status\r\n LEFT JOIN user h ON a.user = h.username\r\n JOIN tipe_naskah f ON a.tipe = f.id_tipe ORDER BY a.id_suratkeluar DESC";
}
// var_dump($sql);
if (!is_null($limit) and !is_null($batas)) {
$sql .= " LIMIT {$limit},{$batas}";
}
$data = $this->select($sql);
$surat = array();
foreach ($data as $value) {
$obj = new $this();
$obj->setId($value['id_suratkeluar']);
$obj->setRujukan($value['rujukan']);
$obj->setNomor($value['no_surat']);
$obj->setTglSurat($value['tgl_surat']);
$obj->setAlamat($value['tujuan']);
$obj->setPerihal($value['perihal']);
$obj->setSifat($value['sifat']);
$obj->setJenis($value['jenis']);
$obj->setJmlLampiran($value['lampiran']);
$obj->setFile($value['file']);
$obj->setStatus($value['status']);
$obj->setTipeSurat($value['tipe']);
$obj->setStart($value['start']);
$obj->setUserCreate($value['user']);
$surat[] = $obj;
}
return $surat;
}
public function showAll($limit = null, $batas = null)
{
@Session::createSession();
$role = Session::get('role');
$bagian = Session::get('bagian');
$user = Session::get('user');
if (Auth::isRole($role, 2) and !Auth::isBagian($bagian, 1) or Auth::isRole($role, 3)) {
$sql = "SELECT a.id_suratmasuk as id_suratmasuk,\r\n a.no_agenda as no_agenda,\r\n a.no_surat as no_surat,\r\n a.tgl_terima as tgl_terima,\r\n a.tgl_surat as tgl_surat,\r\n b.nama_satker as asal_surat,\r\n a.perihal as perihal,\r\n a.status as status,\r\n a.sifat as sifat,\r\n a.jenis as jenis,\r\n a.lampiran as lampiran,\r\n a.start as start,\r\n a.end as end\r\n FROM suratmasuk a LEFT JOIN alamat b \r\n ON a.asal_surat = b.kode_satker\r\n LEFT JOIN notifikasi c ON a.id_suratmasuk = c.id_surat\r\n WHERE c.jenis_surat='SM' AND id_user="******"\r\n ORDER BY a.id_suratmasuk DESC";
} else {
$sql = "SELECT a.id_suratmasuk as id_suratmasuk,\r\n a.no_agenda as no_agenda,\r\n a.no_surat as no_surat,\r\n a.tgl_terima as tgl_terima,\r\n a.tgl_surat as tgl_surat,\r\n b.nama_satker as asal_surat,\r\n a.perihal as perihal,\r\n a.status as status,\r\n a.sifat as sifat,\r\n a.jenis as jenis,\r\n a.lampiran as lampiran,\r\n a.start as start,\r\n a.end as end\r\n FROM suratmasuk a LEFT JOIN alamat b \r\n ON a.asal_surat = b.kode_satker\r\n ORDER BY a.id_suratmasuk DESC";
}
//$sql = "SELECT * FROM suratmasuk";
if (!is_null($limit) and !is_null($batas)) {
$sql .= " LIMIT {$limit},{$batas}";
}
// print_r($sql);
$data = $this->select($sql);
//ntar dihapus
$surat = array();
foreach ($data as $value) {
$obj = new $this();
$obj->setAlamat($value['asal_surat']);
$obj->setId($value['id_suratmasuk']);
$obj->setJenis($value['jenis']);
$obj->setJmlLampiran($value['lampiran']);
$obj->setNomor($value['no_surat']);
$obj->setPerihal($value['perihal']);
$obj->setSifat($value['sifat']);
$obj->setTglSurat($value['tgl_surat']);
$obj->setTglTerima($value['tgl_terima']);
$obj->setAgenda($value['no_agenda']);
$obj->setStart($value['start']);
$surat[] = $obj;
}
// var_dump($surat);
return $surat;
}
}
?>
<?php
}
?>
</select>
</td>
<td colspan="6"></td>
</tr>
<tr>
<td class="privilege" colspan="8"><input type="checkbox" id="selectPermissions" /><label for="selectPermissions">Seleccionar todos los permisos</label></td>
</tr>
<?php
$p = new Permission();
$up = new UserPermission();
$userPermissions = $up->getByIdUser($u->getIdUser());
$sections = Section::findAll();
foreach ($sections as $item) {
if ($item->getIdSection() == 11 && !fAuthorization::checkAuthLevel('super')) {
continue;
}
?>
<tr>
<td class="privilege" colspan="8"><?php
echo $item->prepareName();
?>
</td>
</tr>
<?php
$i = 0;
$permissions = $p->getByIdSection($item->getIdSection());
<?php
session_start();
//classes
include_once '..\\Clases/User.php';
//Objects
$user = new User();
$user_check = $_SESSION['login_user'];
$user->getUserDatabyEmail($user_check);
//variables
$idUser = $user->getIdUser();
$name = $user->getName();
if (!isset($name)) {
header("Location: ..\\login/login.php");
}
/**
* bool insert(User $user)
*
* Inserts a new application user access into the database.
*
* @param User $user application user data
* @return boolean returns false, if error occurs
* @access public
*/
function insert($user)
{
$sql = "INSERT INTO " . $this->_table;
$sql .= " (id_user, login, access_date, id_profile) VALUES (";
$sql .= $user->getIdUser() . ", ";
$sql .= "'" . urlencode($user->getLogin()) . "', ";
$sql .= "NOW(), ";
$sql .= $user->getIdProfile() . ");";
return $this->exec($sql);
}
<?php
fSession::open();
$idUser = fSession::get(SESSION_ID_USER);
//if(empty($idUser) || !fAuthorization::checkACL('user', 'delete')) {
if (empty($idUser)) {
header('Location: ' . SITE);
exit("No se ha podido acceder a esta secci&oacite;n");
}
$id = fRequest::encode('id', 'integer');
if (empty($id)) {
exit;
}
try {
$u = new User($id);
$up = new UserPermission();
$userPermissions = $up->getByIdUser($u->getIdUser());
foreach ($userPermissions as $item) {
if (!empty($item) && $item != 'null') {
$up = new UserPermission(array('id_user' => $u->getIdUser(), 'id_permission' => $item->getIdPermission()));
$up->delete();
}
}
$u->delete();
} catch (Exception $e) {
die($e->getMessage());
}
die('1');
$u->setPhone(fRequest::encode('phone', 'string'));
$u->setCellphone(fRequest::encode('cellphone', 'string'));
$u->setNextel(fRequest::encode('nextel', 'string'));
$u->setNextel(fRequest::encode('fax', 'string'));
$u->setNextel(fRequest::encode('address', 'string'));
$u->store();
} catch (Exception $e) {
die('El correo electrónico ya está asociado con una cuenta' . $e->getMessage());
}
$regions = array_unique(fRequest::encode('region', 'array'));
$permissions = array_unique(fRequest::encode('permission', 'array'));
try {
foreach ($regions as $item) {
if (!empty($item) && $item != 'null') {
$ur = new UserRegion();
$ur->setIdUser($u->getIdUser());
$ur->setIdRegion($item);
$ur->store();
}
}
foreach ($permissions as $item) {
if (!empty($item) && $item != 'null') {
$up = new UserPermission();
$up->setIdUser($u->getIdUser());
$up->setIdPermission($item);
$up->store();
}
}
} catch (Exception $e) {
die($e->getMessage());
}
/**
* bool resetPwd(User $user)
*
* Resets an user password in the users table.
*
* @param User $user user to update
* @return boolean returns false, if error occurs
* @access public
*/
function resetPwd($user)
{
if (!$user instanceof User) {
$this->_error = "Argument is an inappropriate object.";
return false;
}
$sql = "UPDATE " . $this->_table . " SET";
$sql .= " pwd='" . urlencode($user->getPwd()) . "'";
// md5 from form
$sql .= " WHERE id_user="******";";
return $this->exec($sql);
}
