public function logout() { Session::createSession(); Session::destroySession(); Session::unsetAll(); $this->view->load('admin/login'); }
public function logout() { //$this->model->logout(); //Session::unsetAll(); Session::createSession(); $log = new Log(); $log->addLog(Session::get('user'), 'LOGOUT', ''); unset($log); Session::destroySession(); //session_destroy(); header('location:' . URL . 'login'); exit; }
/** * Builds the user session by getting and generating data from the database * and sets the values to the session * @param unknown_type $user_id */ public function buildUserSession($user_id) { $Response = new stdClass(); $Response->success = false; $dDao = new DefaultDao(); $User = $dDao->retrieveUserLoginDetailsByUserId($user_id); if ($User != null) { Session::createSession('User', $User->User); $obj_merged = (object) array_merge((array) $User->UserDetails, (array) $User->UserParentDetails); Session::createSession('UserDetails', $obj_merged); Session::createSession('ModuleRights', $this->moduleRights($User->Rights)); $Response->success = true; } return $Response; }
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; }
*/ require '../startOrongo.php'; startOrongo(); if (isset($_POST['username']) && isset($_POST['password']) && !isset($_SESSION['orongo-id']) && !isset($_SESSION['orongo-session-id'])) { $username = Security::escape($_POST['username']); $password = Security::hash($_POST['password']); if (User::usernameExists($username)) { $userID = User::getUserID($username); $goodLogin = User::isGoodPassword($userID, $password); if ($goodLogin) { if (!User::userIsActivated($userID)) { header("Location: ../orongo-login.php?msg=7"); exit; } else { $_SESSION['orongo-id'] = $userID; $_SESSION['orongo-session-id'] = Session::createSession($userID); header("Location: ../orongo-admin/"); exit; } } else { header("Location: ../orongo-login.php?msg=0"); exit; } } else { header("Location: ../orongo-login.php?msg=0"); exit; } } else { if (isset($_SESSION['orongo-id']) || isset($_SESSION['orongo-session-id'])) { session_destroy(); }
} } closedir($dh); } $statusModified = true; $status['reference'] = $ref; } $app = new \Slim\Slim(); $app->config('debug', false); $app->view(new \JsonApiView()); $app->add(new \JsonApiMiddleware()); $app->group('/results', function () use($app) { $app->post('/', function () use($app) { global $status, $statusModified; // Create a new session $session = Session::createSession($status['results']); $status['results']++; $statusModified = true; $sessionInfo = $session->getInfo(); $sessionInfo['href'] = $app->urlFor('results', array('id' => $session->id)); Notify(ADMIN_TOPIC, array('action' => 'create', 'session' => $sessionInfo)); $app->render(200, array('session' => $sessionInfo)); }); $app->get('/', function () use($app) { $sessions = array(); if ($dh = opendir(SESSION_DIR)) { while (($file = readdir($dh)) !== false) { if (Session::isValidSession($file)) { $session = new Session($file); $sessionInfo = $session->getInfo(); $sessionInfo['href'] = $app->urlFor('results', array('id' => $file));
private function cek_session() { @Session::createSession(); if (isset($_SESSION) && Session::get('loggedin') == TRUE && Session::get('user') != '' && Session::get('role') != '') { return true; } return false; }
public function uploadFileSurat() { $upload = new Upload('upload'); $upload->setDirTo('arsip/'); $tipe = 'M'; $satker = $_POST['satker']; $nomor = $_POST['nomor']; //nama baru akan terdiri dari tipe naskah_nomor surat_asal(asal/tetapi asal terlaku kepanjangan) $ubahNama = array($tipe, $nomor, $satker); $upload->setUbahNama($ubahNama); $upload->changeFileName($upload->getFileName(), $ubahNama); $namafile = $upload->getFileTo(); $where = ' id_suratmasuk=' . $_POST['id']; $data = array('file' => $namafile); if ($upload->uploadFile()) { $this->model->uploadFile($data, $where); $datastat = array('stat' => '14'); @Session::createSession(); $user = Session::get('user'); $log = new Log(); $log->addLog($user, 'UPLOAD', 'user ' . $user . ' upload file surat no agenda ' . $this->model->getNomorAgenda($_POST['id']) . ' file:' . $namafile); unset($log); $this->model->update('suratmasuk', $datastat, $where); //update status -> pelaksana echo "<div id=success>Upload file berhasil</div>"; } else { echo "<div id=error>Upload file berhasil</div>"; } // return true; //header('location:'.URL.'suratmasuk'); }
/** * @author FreelaPHP schuindt * @version 1.0 * @todo metodo que realiza o login do usuario no sistema * * * */ public function login() { try { $this->User->validate = $this->User->validate_login; $_POST = Utils::sanitazeArray($_POST); $this->User->data = $_POST[$this->User->name]; $_SESSION = NULL; if ($this->User->validates()) { $this->User->data['senha'] = Authentication::password($this->User->data['senha']); /** * toda a minha validação de status da conta, usuario ou empresa está na procedure. * referencia MODEL/USUARIOS.PHP * metodo LOGAR */ $usuario[$this->User->name] = $this->User->logar($this->User->data['email'], $this->User->data['senha']); /** * recuperar a empresa do funcionario */ Session::initAuth(); Session::createSession($usuario); /** * Usuario operador logar com a empresa já na session */ if (in_array($usuario[$this->User->name]['roles_id'], array(2, 6, 7))) { $modelFuncionario = new Funcionario(); $modelEmpresa = new Empresa(); $funcionario = $modelFuncionario->find('first', array('pessoas_id' => $usuario[$this->User->name]['pessoas_id'])); /** * */ if (count($funcionario) > 0) { $_SESSION[$modelFuncionario->name] = $funcionario[0][$modelFuncionario->name]; } $empresa = $modelEmpresa->findEmpresa($funcionario[0][$modelFuncionario->name]['empresas_id']); if (count($empresa) > 0) { /** * recuperando a conta empresa e guardando na sessao */ $contatos = $modelEmpresa->contatosEmpresa($funcionario[0][$modelFuncionario->name]['empresas_id']); $contaEmpresa = $modelEmpresa->contaEmpresa(md5($funcionario[0][$modelFuncionario->name]['empresas_id'])); $_SESSION[$modelEmpresa->name] = $empresa[0]; $_SESSION['ContaEmpresa'] = $contaEmpresa[0]; $_SESSION['Contato'] = $contatos; } } else { if (in_array($usuario[$this->User->name]['roles_id'], array(3, 4))) { /** * VERIFICO SE EXISTE APENAS UMA EMPRESA VINCULADA */ $modelEmpresa = new Empresa(); $empresas = $modelEmpresa->empresasRelacionadas(md5($usuario[$this->User->name]['pessoas_id']), $usuario[$this->User->name]['roles_id']); if (count($empresas) == 1) { $_SESSION[$modelEmpresa->name] = $empresas[0]; /** * recuperando a conta empresa e guardando na sessao */ $contaEmpresa = $modelEmpresa->contaEmpresa(md5($_SESSION[$modelEmpresa->name]['empresas_id'])); $_SESSION['ContaEmpresa'] = $contaEmpresa[0]; } } } $url = Router::url(array('Usuarios', 'painel')); echo json_encode(array('funcao' => "sucessoForm( 'login efetuado com sucesso!', '#UsuarioLoginForm' ); redirect('{$url}');")); } else { echo json_encode(array('erros' => $this->User->validateErros, 'form' => 'UsuarioLoginForm')); } } catch (Exception $ex) { $msg = $ex->getMessage(); echo json_encode(array('funcao' => "infoErro('{$msg}', '#UsuarioLoginForm');")); } }
function restoreDatabaseZip($sourceDB) { if (file_exists($sourceDB)) { include "libs/pclzip.lib.php"; @set_time_limit(0); $archive = new PclZip($sourceDB); if ($archive->extract(PCLZIP_OPT_PATH, 'public/temp/') == 0) { die("Error : " . $archive->errorInfo(true)); } $f = fopen('public/temp/' . $this->getRealFileName($sourceDB) . '.sql', "r+"); $sqlFile = fread($f, filesize('public/temp/' . $this->getRealFileName($sourceDB) . '.sql')); $sqlFile = str_replace("\r", "%BR%", $sqlFile); $sqlFile = str_replace("\n", "%BR%", $sqlFile); $sqlFile = str_replace("%BR%%BR%", "%BR%", $sqlFile); $sqlArray = explode('%BR%', $sqlFile); $sqlArrayToExecute; foreach ($sqlArray as $stmt) { $stmt = $this->isComment($stmt); if ($stmt != '') { $sqlArrayToExecute[] = $stmt; } } $sqlFile = implode("%BR%", $sqlArrayToExecute); unset($sqlArrayToExecute); $sqlArray = explode(';%BR%', $sqlFile); unset($sqlFile); foreach ($sqlArray as $stmt) { $stmt = str_replace("%BR%", " ", $stmt); $stmt = str_replace(" ", " ", $stmt); $stmt = str_replace("�", "\\'", $stmt); $stmt = str_replace("</p><p>", "</p> <p>", $stmt); $stmt = str_replace("<p><br />", "<p>", $stmt); $stmt = trim($stmt); $result = $this->query($stmt); Session::createSession(); $_SESSION['ttlQuery'] = count($sqlArray); $_SESSION['timeQuery'] = time(); if (!$result) { return false; } } $this->xcopy('public/temp/arsip', 'arsip'); //memindahkan isi file backup ke dir arsip $this->remove($sourceDB); $this->remove('public/temp/arsip'); return 'restore data telah berhasil dilakukan, ' . $_SESSION['ttlQuery'] . ' query dieksekusi pada ' . date('Y-m-d H:i:s', $_SESSION['timeQuery']); //not work till restore completed // $this->remove('temp/'.$this->getRealFileName($sourceDB).'.sql'); } else { return 'ZIP File not found'; } }
public function uploadrev() { $return = true; $notif = new Notifikasi(); $id = $_POST['id']; $catatan = $_POST['catatan']; $user = $_POST['user']; // var_dump($catatan); $time = date('Y-m-d H:i:s'); $filename = ''; $datas = $this->model->getSuratById($id, 'detil'); // foreach ($datas as $val){ $filename = $datas->getFile(); // } //--------------------------------- $fln = array(); if (file_exists('arsip/temp/' . $filename)) { //jika file telah ada di folder temp/ $temp = explode('.', $filename); // var_dump($temp); $sql = "SELECT file FROM revisisurat WHERE file LIKE '{$temp['0']}%'"; $file = $this->model->select($sql); // var_dump($file); if (count($file > 0)) { if (count($file) == 1) { $pisah = explode('.', $filename); $nama = $pisah[0]; $ext = $pisah[1]; var_dump($ext); $filename = $nama . '_1.' . $ext; // var_dump($filename); // break; } else { foreach ($file as $val) { $temp = explode('.', $val['file']); $pisah = explode('_', $temp[0]); if (count($pisah) <= 3) { $fln[] = 0; } else { $fln[] = $pisah[3]; } // $fln[] = explode('_', $temp[0]); // var_dump($fln); // $len = count($temp); // $fln[] = (int) ($len-1); //mengambil array terakhir $num = max($fln); // var_dump($num); $filename = $pisah[0] . '_' . $pisah[1] . '_' . $pisah[2] . '_' . ($num + 1) . '.' . $temp[1]; // var_dump($filename); } } } } //----------------------------------- $data = array('id_surat' => $id, 'catatan' => $catatan, 'user' => $user, 'file' => $filename, 'time' => $time); $ext = explode(".", $filename); if ($ext[count($ext) - 1] == 'pdf') { //jika telah diupload tipe file pdf if (file_exists('arsip/' . $filename)) { copy('arsip/' . $filename, 'arsip/temp/' . $filename); } //copykan ke folder temp/ } else { $upload = new Upload('upload'); //jika tidak, upload file tersebut $upload->setDirTo('arsip/temp/'); $upload->setFileTo($filename); $upload->uploadFile(); } //upload file revisi // $upl = $upload->uploadFile(); //upload dengan nama beda jika sudah terdapat file di arsip // if(!$upl){ // $return = "Gagal upload! cek file dan ekstensi, ekstensi harus pdf, doc atau docx"; // } $role = Session::get('role'); /* * alurnya klo revisi kasi->pelaksana * revisi kk -> kasi dan pelaksana :siiip * otak atik dari awak lagi, ternyata butuh field user/creator surat keluar yg berisi pelaksananya siapa */ //var_dump($id); $notif->set('id_surat', $id); //cek lagi $notif->set('jenis_surat', 'SK'); $notif->set('stat_notif', 1); $user = $this->model->getUser($id); //var_dump($user); $notif->set('bagian', $user[2]); if ($role == 1) { $dataks = $this->model->select("SELECT id_user FROM user WHERE role=2 AND bagian =" . $user[2] . " AND active='Y'"); foreach ($dataks as $val) { $notif->set('id_user', $val['id_user']); } $notif->set('role', 2); //tambah notifikasi untuk kasi $notif->addNotifikasi(); } $notif->set('id_user', $user[0]); $notif->set('role', $user[1]); //tambah notifikasi untuk pelaksana $notif->addNotifikasi(); //tambah revisi if ($this->model->addRevisi($data)) { // $this->showAll(); @Session::createSession(); $user = Session::get('user'); $log = new Log(); $log->addLog($user, 'REKAM REVISI', 'user ' . $user . ' rekam revisi surat keluar id ' . $id . ' nama file ' . $filename); unset($log); echo "<div id=success>Rekam revisi berhasil</div>"; } else { echo "<div id=error>Rekam revisi gagal</div>"; } // return $return; }
private function cek_session() { @Session::createSession(); if (isset($_SESSION) && Session::get('loggedin') == TRUE && Session::get('user') != '' && Session::get('role') != '') { $now = date('Y-m-d H:i:s'); $upd = Session::get('updated'); $diff = strtotime($now) - strtotime($upd); //echo $diff; if ($diff < MAX_SESSION) { return true; } //return true; } return false; }
public function postSamples($callName, $input, $params = array()) { set_time_limit(0); $sql = array(); for ($i = 1; $i <= $params['amount']; $i++) { $rr = md5($i); $obj = Session::createSession($i, $rr); $sql[] = "insert ignore into Session SET " . $obj->getInsertData() . ";"; if ($i % 1000 == 0) { $this->_component->callSql('out2', implode('', $sql), 201, 'Model::isCreated', array(), 'Model::isProblem', array(new File())); $sql = array(); } } $this->_component->callSql('out2', implode('', $sql), 201, 'Model::isCreated', array(), 'Model::isProblem', array(new File())); return Model::isCreated(); }