function eliminar()
{
$userID = $this->getParam('id');
$admin = new Admin_Model();
$toView = $admin->eliminar($userID);
print "1";
//$this->view->assign('toView',$toView);
//$content_view = $this->view->fetch($toView["view"], array('msgerror'=>' '));
//$this->view->assign('content',$content_view);
//$this->view->display(LAYOUT);
}
private function _map_posted_data()
{
$admin_model = new Admin_Model();
$admin_model->set_username($_POST['username']);
$admin_model->set_first_name($_POST['first_name']);
$admin_model->set_last_name($_POST['last_name']);
$admin_model->set_email($_POST['email']);
$filename = $_FILES['image']['name'];
$path = ROOT_PATH . "admin/images/";
move_uploaded_file($_FILES['image']['tmp_name'], $path . $filename);
$savepath = BASE_URL . "admin/images/";
$admin_model->set_image($savepath . $filename);
if (isset($_POST['password'])) {
$admin_model->set_password($_POST['password']);
}
return $admin_model;
}
function getAlamat()
{
$admin = new Admin_Model();
return $admin->getAlamat();
}
public function rekam($id, $tipesurat = null)
{
if (!Auth::isAllow(3, Session::get('role'))) {
header('location:' . URL . 'home');
}
if (isset($_POST['submit'])) {
if ($this->rekamArsip()) {
$this->view->success = "Rekam arsip berhasil";
} else {
$this->view->error = "Rekam arsip gagal!";
}
}
if (!is_null($tipesurat)) {
$this->view->tipe = $tipesurat;
if ($tipesurat == 'SM') {
$data = $this->model->getSurat($id, 'SM');
$this->view->data[0] = $data->getId();
$this->view->data[1] = $data->getNomor();
$admin = new Admin_Model();
$alamat = $admin->getAlamat($data->getAlamat());
foreach ($alamat as $val) {
$alamat = $val['nama_satker'];
}
$this->view->data[2] = $alamat;
$this->view->data[3] = $data->getPerihal();
$this->view->isAllow = $this->model->isAllowWrite($data->getId(), 'SM');
} elseif ($tipesurat == 'SK') {
$data = $this->model->getSurat($id, 'SK');
$this->view->data[0] = $data->getId();
$this->view->data[1] = $data->getNomor();
$admin = new Admin_Model();
$alamat = $admin->getAlamat($data->getAlamat());
foreach ($alamat as $val) {
$alamat = $val['nama_satker'];
}
$this->view->data[2] = $alamat;
$this->view->data[3] = $data->getPerihal();
$this->view->isAllow = $this->model->isAllowWrite($data->getId(), 'SK');
}
}
$dataa = $this->model->getArsip($id, $tipesurat);
if ($dataa->id_arsip > 0) {
$this->view->ar['rak'] = $dataa->lokasi[1];
$this->view->ar['baris'] = $dataa->lokasi[2];
$this->view->ar['box'] = $dataa->lokasi[3];
$this->view->ar['klas'] = $dataa->klas;
$this->view->ar['id_arsip'] = $dataa->id_arsip;
$this->view->rak = $this->model->getRak(true);
$this->view->baris = $this->model->getBaris($this->view->ar['rak'], true);
$this->view->box = $this->model->getBox($this->view->ar['baris'], true);
$this->view->klas = $this->model->getKlas();
} else {
if ($this->model->emptyNomor($this->view->data[1])) {
$this->view->warning = 'surat belum mendapat nomor surat, tidak dapat diarsipkan';
}
$this->view->rak = $this->model->getRak();
$this->view->baris = $this->model->getBaris();
$this->view->box = $this->model->getBox();
$this->view->klas = $this->model->getKlas();
}
$this->view->render('arsip/rekam');
}
<label>LAMPIRAN</label><input id="lampiran" type="" size="5" name="lampiran" value="<?php
echo $this->data->getJmlLampiran();
?>
" title="isikan jumlah lampiran(*)" onkeyup="cekemptyfield(7,this.value)"></br>
<label></label><input type="button" class="btn cancel" onclick="location.href='<?php
echo URL;
?>
suratmasuk'" value="BATAL"><input type="button" class="btn save" name="submit" value="SIMPAN" onclick="return selesai();">
</form></div>
<?php
// }
?>
<?php
$mlibur = new Admin_Model();
$libur = $mlibur->getLibur();
// var_dump($libur);
$count = count($libur);
$i = 0;
// $datal = array();
echo "<script type=text/javascript>\n";
// echo "$(function){\n";
echo "var holiday=[";
foreach ($libur as $data) {
$temp = $data['tgl'];
$tgl = substr($temp, -2);
$bln = (int) substr($temp, 5, 2) - 1;
$thn = substr($temp, 0, 4);
if ($i < $count) {
echo "new Date({$thn},{$bln},{$tgl}).getTime(),";
private function createAgendaSuratKeluar($tipeSurat, $bagian)
{
$agenda = 0;
$admin = new Admin_Model();
$nomor = $admin->getNomor($bagian);
$kd_tipe = "SELECT kode_naskah FROM tipe_naskah WHERE id_tipe=" . $tipeSurat;
$datat = $this->select($kd_tipe);
foreach ($datat as $val) {
$kd_tipe = $val['kode_naskah'];
}
$sql = "SELECT no_surat FROM suratkeluar WHERE tipe=" . $tipeSurat . " AND no_surat<>''";
$datan = $this->select($sql);
$arr_no = array();
foreach ($datan as $val) {
$temp = explode("-", $val['no_surat']);
$temp = $temp[1];
$no = explode("/", $temp);
$no = $no[0];
$arr_no[] = (int) $no;
}
//var_dump($arr_no);
// $agenda = max($arr_no);
//var_dump($agenda);
// $lastid = $this->select('SELECT MAX(id_suratkeluar) as id FROM suratkeluar WHERE tipe='.$tipeSurat);
// $count = count($lastid);
$count = count($arr_no);
if ($count > 0) {
$agenda = max($arr_no);
// foreach ($lastid as $id){
// $lastid = $id['id']; //cek apakah hasilnya null, jika null maka agenda=1
// }
// $data = $this->select('SELECT no_surat FROM suratkeluar
// WHERE id_suratkeluar = '.$lastid);
// $count = count($data);
// if($count>0){
// foreach ($data as $val){
// $data = $val['no_surat']; //cek apakah hasilnya null, jika null maka nilai agenda=1;
// }
// $temp = explode("-", $data);
// $temp = explode("/", $temp[1]);
//var_dump($temp);
// $agenda = $temp[0];
// $agenda = (int) $agenda;
// }
}
//var_dump($lastid);
//$data = $this->select('SELECT no_agenda FROM suratmasuk WHERE id_suratmasuk='.$lastid);
//var_dump($data);
$length = 4 - strlen($agenda);
//echo $length;
$agenda = $agenda + 1;
for ($i = 0; $i < $length; $i++) {
$agenda = '0' . $agenda;
}
$nosrt = $kd_tipe . "-" . $agenda . $nomor;
return $nosrt;
}
public function rekam($s = null)
{
if (!Auth::isAllow(5, Session::get('role'), 1, Session::get('bagian'))) {
header('location:' . URL . 'home');
}
if (!is_null($s)) {
$this->view->alamat = $s;
$almt = new Admin_Model();
$alamat = $almt->getAlamat($s);
//$this->view->alamat
foreach ($alamat as $value) {
$this->view->alamat .= ' ' . $value['nama_satker'];
}
}
$this->view->sifat = $this->model->get('sifat_surat');
$this->view->jenis = $this->model->get('klasifikasi_surat');
$this->view->agenda = $this->nomor->generateNumber('SM');
$this->view->render('suratmasuk/rekam');
}
public static function getJabatanUser($jabatan, $bagian = null)
{
$model = new Admin_Model();
$return = '';
if ($jabatan == 6) {
$sql = "SELECT bagian FROM r_bagian WHERE id_bagian=" . $bagian;
$data = $model->select($sql);
foreach ($data as $val) {
$return = 'Pelaksana ' . $val['bagian'];
}
} else {
$sql = "SELECT nama_jabatan FROM jabatan WHERE id_jabatan=" . $jabatan;
$data = $model->select($sql);
foreach ($data as $val) {
$return = $val['nama_jabatan'];
}
}
return $return;
}
<div class="row">
<form method="post" action='<?php
echo TMVC_BASEURL;
?>
/admin/volver_menu'>
<button id="return" class="btn-primary btn-fire returnbutton" name="Return">Return to main menu</button>
</form>
</div>
<div class="row">
<div class="col-md-12">
<div id="tabla">
<table>
<tr> <td>ID</td> <td>Username</td> <td>Enable/Disable</td> <td> Delete </td> </tr>
<?php
if (!isset($toView['users'])) {
$admin = new Admin_Model();
$toView = $admin->adminMenu();
}
foreach ($toView['users'] as $user) {
if (intval($user['enabled']) == 0) {
$enabledText = "Enable";
} else {
$enabledText = "Disable";
}
$button = '<button id="b' . $user['id'] . '" class="' . $enabledText . '">' . $enabledText . '</button>';
$delButton = '<button id="bd' . $user['id'] . '" class="Delete">Delete</button>';
echo '<tr id="r' . $user['id'] . '">';
echo '<td>' . $user['id'] . '</td><td>' . htmlspecialchars($user['user'], ENT_QUOTES, 'UTF-8') . '</td><td>' . $button . '</td> <td>' . $delButton . '</td>';
echo '</tr>';
}
?>
<tr><td width="30%"></td><td></td></tr>
<tr><td>NAMA PEGAWAI</td><td><?php
echo $this->data[3];
?>
</td></tr>
<tr><td>NIP</td><td><?php
echo $this->data[4];
?>
</td></tr>
<tr><td>NAMA USER</td><td><?php
echo $this->data[1];
?>
</td></tr>
<tr><td>JABATAN</td><td>
<?php
echo Admin_Model::getJabatanUser($this->data[5], $this->data[6]);
?>
</td></tr>
<form id="form-rekam">
<input id="id" type="hidden" name="id" value="<?php
echo $this->data[0];
?>
">
<tr><td colspan="2" halign="center">UBAH PASSWORD</td></tr>
<tr><td>PASSWORD LAMA</td><td><input id="pwlama" type="password" ></td></tr>
<tr><td>PASSWORD BARU</td><td><input id="pwbaru1" type="password"></td></tr>
<tr><td>ULANGI PASSWORD BARU</td><td><input id="pwbaru2" type="password"></td></tr>
<tr><td>STATUS AKTIF</td><td><a ><input class="btn" type="button" value="<?php
echo $this->data[8];
?>
" onclick="return setaktifuser('<?php
public function edit($id_sk = null, $ids = null)
{
if (isset($_POST['submit'])) {
if ($this->editSurat()) {
$this->view->success = "Ubah data surat keluar berhasil";
} else {
$this->view->error = "Ubah data surat keluar gagal!";
}
}
if (!is_null($id_sk)) {
//cek id_sm jika panjang=5 maka kode satker
$length = strlen($id_sk);
//echo $length . " " . $id_sm;
if ($length == 8) {
$this->view->alamat = $id_sk;
$almt = new Admin_Model();
$alamat = $almt->getAlamat($id_sk);
//$this->view->alamat
foreach ($alamat as $value) {
$this->view->alamat .= ' ' . $value['nama_satker'];
}
// echo $this->view->alamat;
if (!is_null($ids)) {
$this->view->data = $this->model->getSuratById($ids, 'ubah');
$this->view->sifat = $this->model->get('sifat_surat');
$this->view->jenis = $this->model->get('klasifikasi_surat');
$this->view->tipe = $this->model->select('SELECT * FROM tipe_naskah');
//var_dump($this->view->jenis);
}
} else {
$this->view->data = $this->model->getSuratById($id_sk, 'ubah');
$this->view->sifat = $this->model->get('sifat_surat');
$this->view->jenis = $this->model->get('klasifikasi_surat');
$this->view->tipe = $this->model->select('SELECT * FROM tipe_naskah');
//var_dump($this->view->jenis);
}
}
$this->view->id = $this->view->data->getId();
$this->view->tipe1 = $this->view->data->getTipeSurat();
$this->view->no_surat = $this->view->data->getNomor();
$this->view->tgl_surat = Tanggal::ubahFormatToDatePicker($this->view->data->getTglSurat());
$this->view->tujuan = $this->view->data->getAlamat();
$this->view->perihal = $this->view->data->getPerihal();
$this->view->sifat1 = $this->view->data->getSifat();
$this->view->jenis1 = $this->view->data->getJenis();
$this->view->lampiran = $this->view->data->getJmlLampiran();
// var_dump($this->view->no_surat);
$this->view->render('suratkeluar/ubah');
}
public function ubah($id)
{
if (!Auth::isAllow(3, Session::get('role'))) {
header('location:' . URL . 'home');
}
if (isset($_POST['submit'])) {
if ($this->ubahLampiran()) {
$this->view->success = "Ubah lampiran berhasil";
} else {
$this->view->error = "Ubah lampiran surat gagal!";
}
}
$lamp = new Lampiran_Model();
$data = $this->model->getLampiran($id);
foreach ($data as $val) {
$lamp->set('id_lamp', $val['id_lamp']);
$lamp->set('jns_surat', $val['jns_surat']);
$lamp->set('id_surat', $val['id_surat']);
$lamp->set('tipe', $val['tipe']);
$lamp->set('nomor', $val['nomor']);
$lamp->set('tanggal', $val['tanggal']);
$lamp->set('asal', $val['asal']);
$lamp->set('hal', $val['hal']);
$lamp->set('keterangan', $val['keterangan']);
$lamp->set('file', $val['file']);
}
if ($lamp->get('jns_surat') == 'SM') {
$sm = new Suratmasuk_Model();
$datas = $sm->getSuratById($lamp->get('id_surat'));
// foreach ($datas as $value){
$this->view->data[0] = $datas->getId();
$this->view->data[1] = $datas->getNomor();
$admin = new Admin_Model();
$alamat = $admin->getAlamat($datas->getAlamat());
foreach ($alamat as $val) {
$alamat = $val['nama_satker'];
}
$this->view->data[2] = $alamat;
$this->view->data[3] = $datas->getPerihal();
$this->view->data[4] = 'SK';
// }
} else {
$sk = new Suratkeluar_Model();
$datas = $sk->getSuratById($lamp->get('id_surat'), 'ubah');
// foreach ($data as $value){
$this->view->data[0] = $datas->getId();
$this->view->data[1] = $datas->getNomor();
$admin = new Admin_Model();
$alamat = $admin->getAlamat($datas->getAlamat());
foreach ($alamat as $val) {
$alamat = $val['nama_satker'];
}
$this->view->data[2] = $alamat;
$this->view->data[3] = $datas->getPerihal();
$this->view->data[4] = 'SK';
// }
}
// $datas = $this->model->select($sql);
//var_dump($this->view->data);
$this->view->lamp = $lamp;
$this->view->tipe = $this->model->getTypeLampiran();
$this->view->render('lampiran/ubah');
}
public function get_by_username($username)
{
$user = null;
//DATABASE CONNECTION
$this->db->connect();
//SELECT BY ID
$sql = "SELECT * FROM admins WHERE username=?";
//PREPARE
$stmt = $this->db->initialize($sql);
//BIND
$stmt->bind_param("s", $username);
//EXECUTE
$stmt->execute();
//BIND RESULT
$stmt->bind_result($id, $username, $password, $first_name, $last_name, $email, $image);
while ($stmt->fetch()) {
//instantiate object
$admin_model = new Admin_Model();
$admin_model->set_id($id);
$admin_model->set_username($username);
$admin_model->set_password($password);
$admin_model->set_first_name($first_name);
$admin_model->set_last_name($last_name);
$admin_model->set_email($email);
$admin_model->set_image($image);
}
$this->db->close();
return $admin_model;
}
