<?php if ($_SERVER["REQUEST_METHOD"] == "POST"){ $tgl_agenda = htmlspecialchars($purifier->purify(trim($_POST['tgl_agenda'])), ENT_QUOTES); //$tgl_agenda = htmlspecialchars($purifier->purify(trim(date('m-d-Y'))), ENT_QUOTES); if($tgl_agenda == ""){ die("<script>alert('Anda tidak bisa input surat di hari sabtu, minggu maupun hari libur, Silahkan Coba Kembali besok..!!');window.history.go(-1);</script>"); exit(); die(); } $tgl_agenda = explode("-",$tgl_agenda); $tgl_agendadb = $tgl_agenda[2]."-".$tgl_agenda[1]."-".$tgl_agenda[0]; $kode_masalah__ = htmlspecialchars($purifier->purify(trim($_POST['kode_masalah__'])), ENT_QUOTES); $kode_masalah = htmlspecialchars($purifier->purify(trim($_POST['kode_masalah'])), ENT_QUOTES); $no_sm = htmlspecialchars($purifier->purify(trim($_POST['no_sm'])), ENT_QUOTES); $tgl_sm = htmlspecialchars($purifier->purify(trim($_POST['tgl_sm'])), ENT_QUOTES); $tgl_sm = explode("-",$tgl_sm); $tgl_sm = $tgl_sm[2]."-".$tgl_sm[1]."-".$tgl_sm[0]; $tgl_terima = htmlspecialchars($purifier->purify(trim($_POST['tgl_terima'])), ENT_QUOTES); $tgl_terima = explode("-",$tgl_terima); $tgl_terima = $tgl_terima[2]."-".$tgl_terima[1]."-".$tgl_terima[0]; $tgl_duedate = htmlspecialchars($purifier->purify(trim($_POST['tgl_duedate'])), ENT_QUOTES); $tgl_duedate = explode("-",$tgl_duedate); $tgl_duedate = $tgl_duedate[2]."-".$tgl_duedate[1]."-".$tgl_duedate[0]; $kerahasiaan = htmlspecialchars($purifier->purify(trim($_POST['kerahasiaan'])), ENT_QUOTES); $asal_sm = htmlspecialchars($purifier->purify(trim($_POST['asal_sm'])), ENT_QUOTES); $perihal = htmlspecialchars($purifier->purify(trim($_POST['perihal'])), ENT_QUOTES); $keterangan = htmlspecialchars($purifier->purify(trim($_POST['keterangan'])), ENT_QUOTES); $tujuan_surat = json_encode($_POST['m_tujuan']); $tembusan_surat = json_encode($_POST['m_tembusan']); $UKer = $this->model->selectprepare("unit_kerja", $field=null, $params=null, $where=null, "WHERE unit_kerja.id = ".$_SESSION['unitkerjaid']." "); $dataUKer = $UKer->fetch(PDO::FETCH_OBJ); $unitkerja = $dataUKer->kode1; $unitkerjaid = $_SESSION['unitkerjaid']; $fileName = htmlspecialchars($_FILES['filesm']['name'], ENT_QUOTES); $tipefile = strtolower(pathinfo($fileName,PATHINFO_EXTENSION)); $extensionList = array("pdf","jpg","jpeg","png","doc","docx","xls","xlsx"); $namaDir = 'berkas/'; // ganti file name requesr mbak tania 08/01/2018 //$filesm = $namaDir."SM"."_".$tgl_terima[0]."-".$tgl_terima[1]."-".$tgl_terima[2]."_". slugify($perihal)."_". date("d-m-Y_H-i-s", time()) .".".$tipefile; $filesm = $namaDir.$_FILES['filesm']['name']."_". date("d-m-Y_H-i-s", time()) .".".$tipefile; if(empty($fileName)){ $filedb = ""; }else{ // ganti file name requesr mbak tania 08/01/2018 //$filedb = "SM"."_".$tgl_terima[0]."-".$tgl_terima[1]."-".$tgl_terima[2]."_". slugify($perihal)."_". date("d-m-Y_H-i-s", time()) .".".$tipefile; $filedb = $_FILES['filesm']['name']."_". date("d-m-Y_H-i-s", time()) .".".$tipefile; } $tgl_upload = date("Y-m-d H:i:s", time()); if(isset($_GET['smid'])){ $smid = htmlspecialchars($purifier->purify(trim($_GET['smid'])), ENT_QUOTES); $params = array(':id_sm' => $smid); $lihat_sm = $this->model->selectprepare("surat_masuk", $field=null, $params, "id_sm=:id_sm"); if($lihat_sm->rowCount() >= 1){ $data_lihat_sm = $lihat_sm->fetch(PDO::FETCH_OBJ); $idsm = $data_lihat_sm->id_sm; if(empty($fileName)){ //echo "No Update File"; $field = array( 'no_sm' => $no_sm, 'tgl_sm' => $tgl_sm, 'tgl_terima' => $tgl_terima, 'tgl_duedate' => $tgl_duedate, 'kerahasiaan' => $kerahasiaan, 'asal_sm' => $asal_sm, 'perihal' => $perihal, 'tujuan_surat' => $tujuan_surat, 'keterangan' => $keterangan ); }else{ if(in_array($tipefile, $extensionList)){ @unlink($namaDir.$data_lihat_sm->file); $field = array( 'no_sm' => $no_sm, 'tgl_sm' => $tgl_sm, 'tgl_terima' => $tgl_terima, 'tgl_duedate' => $tgl_duedate, 'kerahasiaan' => $kerahasiaan, 'asal_sm' => $asal_sm, 'perihal' => $perihal, 'tujuan_surat' => $tujuan_surat, 'keterangan' => $keterangan, 'file' => $filedb ); move_uploaded_file($_FILES['filesm']['tmp_name'], $filesm); }else{ echo "<script type=\"text/javascript\">alert('File gagal di Upload, Format file tidak di dukung!!!');window.location.href=\"./index.php?op=add_sm&smid=$idsm\";</script>"; } } $params = array(':id_sm' => $idsm); $update = $this->model->updateprepare("surat_masuk", $field, $params, "id_sm=:id_sm"); if($_POST['tombol'] == 'publish'){ $params = array(':id_sm' => $idsm); $update = $this->model->updateprepare("surat_masuk", array('status_draft' => 1), $params, "id_sm=:id_sm"); ////////////////////// kirim sms agung $no_agenda = $this->model->noref_sm($idsm); foreach($_POST['m_tujuan'] as $key => $val){ //$link_bp = "http://$_SERVER[HTTP_HOST]/SIAS/index.php?op=baypass&kode=smid".$val.$idsm; $link_bp = "http://$_SERVER[HTTP_HOST]/SIAS/index.php?op=baypass&kode="; $field_bp = array( 'kode' => 'smid'.$val.$idsm, 'id_surat' => 'smid='.$idsm, 'nik' => $val, 'status' => '0', 'createdate'=> date('Y-m-d') ); $params_bp = array( ':kode' => 'smid'.$val.$idsm, ':id_surat' => 'smid='.$idsm, ':nik' => $val, ':status' => '0', ':createdate'=> date('Y-m-d') ); //$insert_link = $this->model->insertprepare("tbl_link_bp", $field_bp, $params_bp); $insert_link = $this->model->insertidprepare("tbl_link_bp", $field_bp, $params_bp); $params = array(':nip' => $val); $user_tjuan = $this->model->selectprepare("tag", $field=null, $params, "nip=:nip", $other=null); $data_user_tjuan= $user_tjuan->fetch(PDO::FETCH_OBJ); if($data_user_tjuan->telp_user != ''){ //$sms = "WIKA SURAT "; //$sms .= "HAL : ".substr($perihal,0,20)."..., "; //$sms .= "URL : ".$link_bp." , "; //$sms .= "URL : ".$link_bp.$insert_link." , "; //$sms .= "Klik url untuk view surat."; // kirim sms dimatikan permintaan ame 11/19/2019 // $sms = "SURAT MASUK EKSTERNAL ".$no_agenda.", "; // $sms .= "URL : ".$link_bp.$insert_link." , "; // $sms .= "Klik url untuk view surat."; // file_get_contents("http://10.4.0.72/index.php/plugin/rest_api/send_sms?phoneNumber=".urlencode($data_user_tjuan->telp_user)."&message=".urlencode($sms)); $sms = "SURAT MASUK EKSTERNAL ".$no_agenda.", "; $sms .= "Pengirim : ".$asal_sm.", "; $sms .= "URL : ".$link_bp.$insert_link." , "; $sms .= "Klik url untuk view surat."; $text=rawurlencode($sms); $handphone = $data_user_tjuan->telp_user; $handphone= preg_replace('/\D/', '', $handphone); $subs=substr($handphone,1); $depan=substr($handphone,0,1); if($depan=="0") $handphone="62".$subs; $url = "http://wa-api.wika.co.id:89/text&phone_no=$handphone&text=$text"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $output = curl_exec($ch); curl_close($ch); sleep(1); } } if($tembusan_surat != ''){ foreach($_POST['m_tembusan'] as $key => $val){ //$link_bp = "http://$_SERVER[HTTP_HOST]/SIAS/index.php?op=baypass&kode=skid".$val.$idsk; $link_bp = "http://$_SERVER[HTTP_HOST]/SIAS/index.php?op=baypass&kode="; $field_bp = array( 'kode' => 'smid'.$val.$idsm, 'id_surat' => 'smid='.$idsm, 'nik' => $val, 'status' => '0', 'createdate'=> date('Y-m-d') ); $params_bp = array( ':kode' => 'smid'.$val.$idsm, ':id_surat' => 'smid='.$idsm, ':nik' => $val, ':status' => '0', ':createdate'=> date('Y-m-d') ); //$insert_link = $this->model->insertprepare("tbl_link_bp", $field_bp, $params_bp); $insert_link = $this->model->insertidprepare("tbl_link_bp", $field_bp, $params_bp); $params = array(':nip' => $val); $user_tjuan = $this->model->selectprepare("tag", $field=null, $params, "nip=:nip", $other=null); $data_user_tjuan= $user_tjuan->fetch(PDO::FETCH_OBJ); if($data_user_tjuan->telp_user != ''){ //$sms = "WIKA SURAT MASUK INTERNAL , "; //$sms = "WIKA SURAT , "; //$sms .= "HAL : ".$perihal." , "; //$sms .= "HAL : ".substr($perihal,0,20)."..., "; //$sms .= "URL : ".$link_bp.$insert_link." , "; //$sms .= "Klik url untuk view surat."; // kirim sms dimatikan permintaan ame 11/19/2019 // $sms = "SURAT MASUK EKSTERNAL ".$no_agenda.", "; // $sms .= "URL : ".$link_bp.$insert_link." , "; // $sms .= "Klik url untuk view surat."; // file_get_contents("http://10.4.0.72/index.php/plugin/rest_api/send_sms?phoneNumber=".urlencode($data_user_tjuan->telp_user)."&message=".urlencode($sms)); //$kirim = $this->model->sendSMSMasking($data_user_tjuan->telp_user, urlencode($sms), ""); $sms = "SURAT MASUK EKSTERNAL ".$no_agenda.", "; $sms .= "Pengirim : ".$asal_sm.", "; $sms .= "URL : ".$link_bp.$insert_link." , "; $sms .= "Klik url untuk view surat."; $text=rawurlencode($sms); $handphone = $data_user_tjuan->telp_user; $handphone= preg_replace('/\D/', '', $handphone); $subs=substr($handphone,1); $depan=substr($handphone,0,1); if($depan=="0") $handphone="62".$subs; $url = "http://wa-api.wika.co.id:89/text&phone_no=$handphone&text=$text"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $output = curl_exec($ch); curl_close($ch); sleep(1); } } } ////////////////////// kirim sms agung //## Kirim Email ##// $EmailAccount = $this->model->selectprepare("pengaturan", $field=null, $params=null, $where=null, "WHERE status='1' AND email !='' AND pass_email !=''"); $AktifEmail = $this->model->selectprepare("email_setting", $field=null, $params=null, $where=null, "WHERE id_kop='2' AND status='Y'"); if($EmailAccount->rowCount() >= 1 AND $AktifEmail->rowCount() >= 1){ $dataEmailAccount = $EmailAccount->fetch(PDO::FETCH_OBJ); $dataAktifEmail = $AktifEmail->fetch(PDO::FETCH_OBJ); $TujuanSurat = ""; $dataTujuan = array(); if($tujuan_surat != ''){ $dataTujuan = json_decode($data_lihat_sm->tujuan_surat, true); $ListUser = $this->model->selectprepare("user a join user_jabatan b on a.jabatan=b.id_jab", $field=null, $params=null, $where=null, "ORDER BY a.nama ASC"); while($dataListUser = $ListUser->fetch(PDO::FETCH_OBJ)){ if(false !== array_search($dataListUser->id_user, json_decode($tujuan_surat, true))){ $TujuanSurat .= '- '.$dataListUser->nama .' ('.$dataListUser->nama_jabatan .')<br/>'; } } } $isi = $dataAktifEmail->layout; $Rlayout = $isi; $no_agenda = $this->model->noref_sm($data_lihat_sm->id_sm); $arr = array( "=NoAgenda=" => $no_agenda, "=NoSurat=" => $data_lihat_sm->no_sm, "=Perihal=" => $data_lihat_sm->perihal, "=TujuanSurat=" => $TujuanSurat, "=TglSurat=" => tgl_indo($data_lihat_sm->tgl_sm), "=TglTerima=" => tgl_indo($data_lihat_sm->tgl_terima), "=AsalSurat=" => $data_lihat_sm->asal_sm, "=Penerima=" => $_SESSION['nama'] ); foreach($arr as $nama => $value){ if(strpos($isi, $nama) !== false) { $Rlayout = str_replace($nama, $value, $isi); $isi = $Rlayout; } } if($tujuan_surat != '' OR $tujuan_surat != 'null'){ ## Kirim SMS ke tujuan ## foreach($dataTujuan as $id_tujuan1){ $params = array(':id_user' => $id_tujuan1); $user_tjuan = $this->model->selectprepare("user", $field=null, $params, "id_user=:id_user", $other=null); $data_user_tjuan= $user_tjuan->fetch(PDO::FETCH_OBJ); if($data_user_tjuan->no_hp != ''){ $sms = "SMS Surat Masuk \r"; $sms .= "HAL : ". $data_lihat_sm->perihal. "\r"; $sms .= "Cek Aplikasi Surat WIKA"; file_get_contents("http://10.4.0.72/index.php/plugin/rest_api/send_sms?phoneNumber=".urlencode($data_user_tjuan->no_hp)."&message=".urlencode($sms)); } } $mail = new PHPMailer; $mail->SMTPDebug = 0; $mail->isSMTP(); $mail->Host = "smtp.gmail.com"; $mail->SMTPAuth = true; $mail->Username = $dataEmailAccount->email; $mail->Password = $dataEmailAccount->pass_email; //If SMTP requires TLS encryption then set it //$mail->SMTPSecure = "tls"; $mail->Port = 587; $mail->From = $dataEmailAccount->email; //$mail->FromName = $_SESSION['nama']; $mail->FromName = "ADMIN SURAT"; $mail->smtpConnect( array( "ssl" => array( "verify_peer" => false, "verify_peer_name" => false, "allow_self_signed" => true ) ) ); foreach($dataTujuan as $id_tujuan){ $params = array(':id_user' => $id_tujuan); $user_tujuan = $this->model->selectprepare("user", $field=null, $params, "id_user=:id_user", $other=null); $data_user_tujuan= $user_tujuan->fetch(PDO::FETCH_OBJ); if($data_user_tujuan->email != ''){ $mail->AddAddress($data_user_tujuan->email, $data_user_tujuan->nama); } } $mail->isHTML(true); $topik = "Surat Masuk: ".$perihal; $mail->Subject = $topik; $mail->Body = $isi; $mail->AltBody = $perihal; if($data_lihat_sm->file != ""){ $lokasi = "berkas/".$data_lihat_sm->file; $mail->addAttachment($lokasi); } if(!$mail->send()) { //echo "Mailer Error: " . $mail->ErrorInfo; echo "<script type=\"text/javascript\">alert('Surat TELAH BERHASIL dikirim ke Whatsapp penerima');window.location.href=\"./index.php?op=sm\";</script>"; }else{ echo "<script type=\"text/javascript\">alert('Surat TELAH BERHASIL dikirim ke Whatsapp penerima');window.location.href=\"./index.php?op=sm\";</script>"; } }else{ echo "<script type=\"text/javascript\">alert('Data Berhasil diSimpan!');window.location.href=\"./index.php?op=sm\";</script>"; } } //## Akhir Kirim Email ##// } if($update){ echo "<script type=\"text/javascript\">alert('Data Berhasil diperbaharui...!!');window.location.href=\"./index.php?op=sm&smid=$idsm\";</script>"; } } }else{ ## MENDAPATKAN NOMOR SURAT BESERTA NOMOR BACKDATE ## $tgl_now = date("Y-m-d"); $cek_data = $this->model->selectprepare("surat_masuk", $field=null, $params=null, "", "WHERE kodemasalah ='".$kode_masalah__."' AND unitkerjaid ='".$unitkerjaid."' AND DATE_FORMAT(tgl_agenda, '%Y-%m-%d') ='".$tgl_now."'"); $cek_sm = $this->model->selectprepare("surat_masuk", array('IFNULL(MAX(no_agenda),0) as no_max, MAX(tgl_agenda) as tgl_agenda'), $params=null, $where=null, "WHERE kodemasalah ='".$kode_masalah__."' AND unitkerjaid ='".$unitkerjaid."' AND DATE_FORMAT(tgl_agenda, '%Y') ='".$tgl_agenda[2]."'"); $hasil_noagenda = $cek_sm->fetch(PDO::FETCH_OBJ); $cek_noagenda = $hasil_noagenda->no_max; $cek_tglagenda = $hasil_noagenda->tgl_agenda; //## Cek Data di Pengaturan ## $params = array(':status' => 1); $pengaturan = $this->model->selectprepare("pengaturan", $field=null, $params, "status=:status", $other=null); $data_pengaturan = $pengaturan->fetch(PDO::FETCH_OBJ); $hari_backdate = $data_pengaturan->hari_backdate; $tahun_atur = $data_pengaturan->tahun; //## Cek Data di Hari libur ## $data_harilibur = $this->model->selectprepare("hari_libur", $field=null, $params=null, "", "WHERE DATE_FORMAT(tgl, '%Y') = '".$tahun_atur."' "); while($harilibur = $data_harilibur->fetch(PDO::FETCH_OBJ)){ $dump_harilibur[] = $harilibur->tgl; } if($cek_data->rowCount() > 0){ if($cek_noagenda > 0) { $noagenda = $cek_noagenda + 1; } else { $noagenda = 1; if($pengaturan->rowCount() >= 1){ $noagenda = $data_pengaturan->no_agenda_sm_start; } } } else { $difference = abs(strtotime($tgl_now) - strtotime($cek_tglagenda)); $diffdate = round(((($difference / 60) / 60) / 24), 0); $jum = 0; $tgl1 = date("Y-m-d", strtotime($cek_tglagenda)); for ($i=1; $i < $diffdate+1; $i++) { $tgl2 = strtotime($tgl1 . '+' . $i . ' day'); if(date('w', $tgl2) == '0' || date('w', $tgl2) == '6' || array_search(date("Y-m-d", $tgl2), $dump_harilibur)){ $jum++; } } $noagenda2 = (($diffdate - $jum) * $hari_backdate) + 1; if($cek_noagenda > 0) { $noagenda = $cek_noagenda + $noagenda2; } else { $noagenda = 1; if($pengaturan->rowCount() >= 1){ $noagenda = $data_pengaturan->no_agenda_sm_start; } } } ## AKHIR MENDAPATKAN NOMOR SURAT BESERTA NOMOR BACKDATE ## $field = array( 'id_user' => $_SESSION['id_user'], 'no_agenda' => $noagenda, 'tgl_agenda' => $tgl_agendadb, 'kodemasalah' => $kode_masalah__, 'kodemasalahid' => $kode_masalah, 'no_sm' => $no_sm, 'tgl_sm' => $tgl_sm, 'tgl_terima' => $tgl_terima, 'tgl_duedate' => $tgl_duedate, 'kerahasiaan' => $kerahasiaan, 'asal_sm' => $asal_sm, 'perihal' => $perihal, 'tujuan_surat' => $tujuan_surat, 'unitkerja' => $unitkerja, 'unitkerjaid' => $unitkerjaid, 'file' => $filedb, 'keterangan' => $keterangan, 'created' => $tgl_upload ); $params = array( ':id_user' => $_SESSION['id_user'], ':no_agenda' => $noagenda, ':tgl_agenda' => $tgl_agendadb, ':kodemasalah' => $kode_masalah__, ':kodemasalahid' => $kode_masalah, ':no_sm' => $no_sm, ':tgl_sm' => $tgl_sm, ':tgl_terima' => $tgl_terima, ':tgl_duedate' => $tgl_duedate, ':kerahasiaan' => $kerahasiaan, ':asal_sm' => $asal_sm, ':perihal' => $perihal, ':tujuan_surat' => $tujuan_surat, ':unitkerja' => $unitkerja, ':unitkerjaid' => $unitkerjaid, ':file' => $filedb, ':keterangan' => $keterangan, ':created' => $tgl_upload ); if(empty($fileName)){ $insert = $this->model->insertidprepare("surat_masuk", $field, $params); // tambah tembusan surat $field_sm = array( 'id_sm' => $insert, 'tembusan' => $tembusan_surat, 'keterangan' => '' ); $params_sm = array( ':id_sm' => $insert, ':tembusan' => $tembusan_surat, ':keterangan' => '' ); $insert_sm = $this->model->insertidprepare("tbl_tembusan_sm", $field_sm, $params_sm); // tambah tembusan surat $cekData = $this->model->selectprepare("surat_masuk", $field=null, $params=null, $where=null, "WHERE id_sm='".$insert."' "); $cekShow = $cekData->fetch(PDO::FETCH_OBJ); if($insert != 0){ /* ///////////////////// kirim sms agung foreach($_POST['m_tujuan'] as $key => $val){ $link_bp = "http://$_SERVER[HTTP_HOST]/index.php?op=baypass&kode=smid".$val.$insert; $field_bp = array( 'kode' => 'smid'.$val.$insert, 'id_surat' => 'smid='.$insert, 'nik' => $val, 'status' => '0', 'createdate'=> date('Y-m-d') ); $params_bp = array( ':kode' => 'smid'.$val.$insert, ':id_surat' => 'smid='.$insert, ':nik' => $val, ':status' => '0', ':createdate'=> date('Y-m-d') ); $insert_link = $this->model->insertprepare("tbl_link_bp", $field_bp, $params_bp); $params = array(':nip' => $val); $user_tjuan = $this->model->selectprepare("tag", $field=null, $params, "nip=:nip", $other=null); $data_user_tjuan= $user_tjuan->fetch(PDO::FETCH_OBJ); if($data_user_tjuan->telp_user != ''){ $sms = "WIKA SURAT MASUK EXTERNAL \r"; $sms .= "HAL : ".$perihal." \r"; $sms .= "URL : ".$link_bp." \r"; $sms .= "Klik url untuk view surat."; file_get_contents("http://10.4.0.72/index.php/plugin/rest_api/send_sms?phoneNumber=".urlencode($data_user_tjuan->telp_user)."&message=".urlencode($sms)); } } ////////////////////// kirim sms agung */ //Kirim Email $EmailAccount = $this->model->selectprepare("pengaturan", $field=null, $params=null, $where=null, "WHERE status='1' AND email !='' AND pass_email !=''"); $AktifEmail = $this->model->selectprepare("email_setting", $field=null, $params=null, $where=null, "WHERE id_kop='2' AND status='Y'"); echo "<script type=\"text/javascript\">alert('Data Berhasil diSimpan!');window.location.href=\"./index.php?op=sm\";</script>"; }else{ die("<script>alert('Data Gagal di simpan ke Database, Silahkan Coba Kembali..!!');window.history.go(-1);</script>"); } }else{ if(in_array($tipefile, $extensionList)){ if(move_uploaded_file($_FILES['filesm']['tmp_name'], $filesm)){ $insert = $this->model->insertidprepare("surat_masuk", $field, $params); // tambah tembusan surat $field_sm = array( 'id_sm' => $insert, 'tembusan' => $tembusan_surat, 'keterangan' => '' ); $params_sm = array( ':id_sm' => $insert, ':tembusan' => $tembusan_surat, ':keterangan' => '' ); $insert_sm = $this->model->insertidprepare("tbl_tembusan_sm", $field_sm, $params_sm); // tambah tembusan surat $cekData = $this->model->selectprepare("surat_masuk", $field=null, $params=null, $where=null, "WHERE id_sm='".$insert."' "); $cekShow = $cekData->fetch(PDO::FETCH_OBJ); if($insert != 0){ $idsm = $insert; $params = array(':id_sm' => $idsm); $update = $this->model->updateprepare("surat_masuk", array('status_draft' => 1), $params, "id_sm=:id_sm"); ////////////////////// kirim sms agung $no_agenda = $this->model->noref_sm($idsm); foreach($_POST['m_tujuan'] as $key => $val){ //$link_bp = "http://$_SERVER[HTTP_HOST]/SIAS/index.php?op=baypass&kode=smid".$val.$idsm; $link_bp = "http://$_SERVER[HTTP_HOST]/SIAS/index.php?op=baypass&kode="; $field_bp = array( 'kode' => 'smid'.$val.$idsm, 'id_surat' => 'smid='.$idsm, 'nik' => $val, 'status' => '0', 'createdate'=> date('Y-m-d') ); $params_bp = array( ':kode' => 'smid'.$val.$idsm, ':id_surat' => 'smid='.$idsm, ':nik' => $val, ':status' => '0', ':createdate'=> date('Y-m-d') ); //$insert_link = $this->model->insertprepare("tbl_link_bp", $field_bp, $params_bp); $insert_link = $this->model->insertidprepare("tbl_link_bp", $field_bp, $params_bp); $params = array(':nip' => $val); $user_tjuan = $this->model->selectprepare("tag", $field=null, $params, "nip=:nip", $other=null); $data_user_tjuan= $user_tjuan->fetch(PDO::FETCH_OBJ); if($data_user_tjuan->telp_user != ''){ //$sms = "WIKA SURAT "; //$sms .= "HAL : ".substr($perihal,0,20)."..., "; //$sms .= "URL : ".$link_bp." , "; //$sms .= "URL : ".$link_bp.$insert_link." , "; //$sms .= "Klik url untuk view surat."; // kirim sms dimatikan permintaan ame 11/19/2019 // $sms = "SURAT MASUK EKSTERNAL ".$no_agenda.", "; // $sms .= "URL : ".$link_bp.$insert_link." , "; // $sms .= "Klik url untuk view surat."; // file_get_contents("http://10.4.0.72/index.php/plugin/rest_api/send_sms?phoneNumber=".urlencode($data_user_tjuan->telp_user)."&message=".urlencode($sms)); $sms = "SURAT MASUK EKSTERNAL ".$no_agenda.", "; $sms .= "Pengirim : ".$asal_sm.", "; $sms .= "URL : ".$link_bp.$insert_link." , "; $sms .= "Klik url untuk view surat."; $text=rawurlencode($sms); $handphone = $data_user_tjuan->telp_user; $handphone= preg_replace('/\D/', '', $handphone); $subs=substr($handphone,1); $depan=substr($handphone,0,1); if($depan=="0") $handphone="62".$subs; $url = "http://wa-api.wika.co.id:89/text&phone_no=$handphone&text=$text"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $output = curl_exec($ch); curl_close($ch); sleep(1); } } if($tembusan_surat != ''){ foreach($_POST['m_tembusan'] as $key => $val){ //$link_bp = "http://$_SERVER[HTTP_HOST]/SIAS/index.php?op=baypass&kode=skid".$val.$idsk; $link_bp = "http://$_SERVER[HTTP_HOST]/SIAS/index.php?op=baypass&kode="; $field_bp = array( 'kode' => 'smid'.$val.$idsm, 'id_surat' => 'smid='.$idsm, 'nik' => $val, 'status' => '0', 'createdate'=> date('Y-m-d') ); $params_bp = array( ':kode' => 'smid'.$val.$idsm, ':id_surat' => 'smid='.$idsm, ':nik' => $val, ':status' => '0', ':createdate'=> date('Y-m-d') ); //$insert_link = $this->model->insertprepare("tbl_link_bp", $field_bp, $params_bp); $insert_link = $this->model->insertidprepare("tbl_link_bp", $field_bp, $params_bp); $params = array(':nip' => $val); $user_tjuan = $this->model->selectprepare("tag", $field=null, $params, "nip=:nip", $other=null); $data_user_tjuan= $user_tjuan->fetch(PDO::FETCH_OBJ); if($data_user_tjuan->telp_user != ''){ //$sms = "WIKA SURAT MASUK INTERNAL , "; //$sms = "WIKA SURAT , "; //$sms .= "HAL : ".$perihal." , "; //$sms .= "HAL : ".substr($perihal,0,20)."..., "; //$sms .= "URL : ".$link_bp.$insert_link." , "; //$sms .= "Klik url untuk view surat."; // kirim sms dimatikan permintaan ame 11/19/2019 // $sms = "SURAT MASUK EKSTERNAL ".$no_agenda.", "; // $sms .= "URL : ".$link_bp.$insert_link." , "; // $sms .= "Klik url untuk view surat."; // file_get_contents("http://10.4.0.72/index.php/plugin/rest_api/send_sms?phoneNumber=".urlencode($data_user_tjuan->telp_user)."&message=".urlencode($sms)); //$kirim = $this->model->sendSMSMasking($data_user_tjuan->telp_user, urlencode($sms), ""); $sms = "SURAT MASUK EKSTERNAL ".$no_agenda.", "; $sms .= "Pengirim : ".$asal_sm.", "; $sms .= "URL : ".$link_bp.$insert_link." , "; $sms .= "Klik url untuk view surat."; $text=rawurlencode($sms); $handphone = $data_user_tjuan->telp_user; $handphone= preg_replace('/\D/', '', $handphone); $subs=substr($handphone,1); $depan=substr($handphone,0,1); if($depan=="0") $handphone="62".$subs; $url = "http://wa-api.wika.co.id:89/text&phone_no=$handphone&text=$text"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $output = curl_exec($ch); curl_close($ch); sleep(1); } } } ////////////////////// kirim sms agung //## Kirim Email ##// $EmailAccount = $this->model->selectprepare("pengaturan", $field=null, $params=null, $where=null, "WHERE status='1' AND email !='' AND pass_email !=''"); $AktifEmail = $this->model->selectprepare("email_setting", $field=null, $params=null, $where=null, "WHERE id_kop='2' AND status='Y'"); if($EmailAccount->rowCount() >= 1 AND $AktifEmail->rowCount() >= 1){ $dataEmailAccount = $EmailAccount->fetch(PDO::FETCH_OBJ); $dataAktifEmail = $AktifEmail->fetch(PDO::FETCH_OBJ); $TujuanSurat = ""; $dataTujuan = array(); if($tujuan_surat != ''){ $dataTujuan = json_decode($data_lihat_sm->tujuan_surat, true); $ListUser = $this->model->selectprepare("user a join user_jabatan b on a.jabatan=b.id_jab", $field=null, $params=null, $where=null, "ORDER BY a.nama ASC"); while($dataListUser = $ListUser->fetch(PDO::FETCH_OBJ)){ if(false !== array_search($dataListUser->id_user, json_decode($tujuan_surat, true))){ $TujuanSurat .= '- '.$dataListUser->nama .' ('.$dataListUser->nama_jabatan .')<br/>'; } } } $isi = $dataAktifEmail->layout; $Rlayout = $isi; $no_agenda = $this->model->noref_sm($data_lihat_sm->id_sm); $arr = array( "=NoAgenda=" => $no_agenda, "=NoSurat=" => $data_lihat_sm->no_sm, "=Perihal=" => $data_lihat_sm->perihal, "=TujuanSurat=" => $TujuanSurat, "=TglSurat=" => tgl_indo($data_lihat_sm->tgl_sm), "=TglTerima=" => tgl_indo($data_lihat_sm->tgl_terima), "=AsalSurat=" => $data_lihat_sm->asal_sm, "=Penerima=" => $_SESSION['nama'] ); foreach($arr as $nama => $value){ if(strpos($isi, $nama) !== false) { $Rlayout = str_replace($nama, $value, $isi); $isi = $Rlayout; } } if($tujuan_surat != '' OR $tujuan_surat != 'null'){ ## Kirim SMS ke tujuan ## foreach($dataTujuan as $id_tujuan1){ $params = array(':id_user' => $id_tujuan1); $user_tjuan = $this->model->selectprepare("user", $field=null, $params, "id_user=:id_user", $other=null); $data_user_tjuan= $user_tjuan->fetch(PDO::FETCH_OBJ); if($data_user_tjuan->no_hp != ''){ $sms = "SMS Surat Masuk \r"; $sms .= "HAL : ". $data_lihat_sm->perihal. "\r"; $sms .= "Cek Aplikasi Surat WIKA"; file_get_contents("http://10.4.0.72/index.php/plugin/rest_api/send_sms?phoneNumber=".urlencode($data_user_tjuan->no_hp)."&message=".urlencode($sms)); } } $mail = new PHPMailer; $mail->SMTPDebug = 0; $mail->isSMTP(); $mail->Host = "smtp.gmail.com"; $mail->SMTPAuth = true; $mail->Username = $dataEmailAccount->email; $mail->Password = $dataEmailAccount->pass_email; //If SMTP requires TLS encryption then set it //$mail->SMTPSecure = "tls"; $mail->Port = 587; $mail->From = $dataEmailAccount->email; //$mail->FromName = $_SESSION['nama']; $mail->FromName = "ADMIN SURAT"; $mail->smtpConnect( array( "ssl" => array( "verify_peer" => false, "verify_peer_name" => false, "allow_self_signed" => true ) ) ); foreach($dataTujuan as $id_tujuan){ $params = array(':id_user' => $id_tujuan); $user_tujuan = $this->model->selectprepare("user", $field=null, $params, "id_user=:id_user", $other=null); $data_user_tujuan= $user_tujuan->fetch(PDO::FETCH_OBJ); if($data_user_tujuan->email != ''){ $mail->AddAddress($data_user_tujuan->email, $data_user_tujuan->nama); } } $mail->isHTML(true); $topik = "Surat Masuk: ".$perihal; $mail->Subject = $topik; $mail->Body = $isi; $mail->AltBody = $perihal; if($data_lihat_sm->file != ""){ $lokasi = "berkas/".$data_lihat_sm->file; $mail->addAttachment($lokasi); } if(!$mail->send()) { //echo "Mailer Error: " . $mail->ErrorInfo; echo "<script type=\"text/javascript\">alert('Surat TELAH BERHASIL dikirim ke Whatsapp penerima');window.location.href=\"./index.php?op=sm\";</script>"; }else{ echo "<script type=\"text/javascript\">alert('Surat TELAH BERHASIL dikirim ke Whatsapp penerima');window.location.href=\"./index.php?op=sm\";</script>"; } }else{ echo "<script type=\"text/javascript\">alert('Data Berhasil diSimpan!');window.location.href=\"./index.php?op=sm\";</script>"; } } //## Akhir Kirim Email ##// /* ///////////////////// kirim sms agung foreach($_POST['m_tujuan'] as $key => $val){ $link_bp = "http://$_SERVER[HTTP_HOST]/index.php?op=baypass&kode=smid".$val.$insert; $field_bp = array( 'kode' => 'smid'.$val.$insert, 'id_surat' => 'smid='.$insert, 'nik' => $val, 'status' => '0', 'createdate'=> date('Y-m-d') ); $params_bp = array( ':kode' => 'smid'.$val.$insert, ':id_surat' => 'smid='.$insert, ':nik' => $val, ':status' => '0', ':createdate'=> date('Y-m-d') ); $insert_link = $this->model->insertprepare("tbl_link_bp", $field_bp, $params_bp); $params = array(':nip' => $val); $user_tjuan = $this->model->selectprepare("tag", $field=null, $params, "nip=:nip", $other=null); $data_user_tjuan= $user_tjuan->fetch(PDO::FETCH_OBJ); if($data_user_tjuan->telp_user != ''){ $sms = "WIKA SURAT MASUK EXTERNAL : "; $sms .= "HAL : ".$perihal." "; $sms .= "URL : ".$link_bp." \r"; $sms .= "Klik url untuk view surat."; file_get_contents("http://10.4.0.72/index.php/plugin/rest_api/send_sms?phoneNumber=".urlencode($data_user_tjuan->telp_user)."&message=".urlencode($sms)); } } ////////////////////// kirim sms agung */ //Kirim Email $EmailAccount = $this->model->selectprepare("pengaturan", $field=null, $params=null, $where=null, "WHERE status='1' AND email !='' AND pass_email !=''"); $AktifEmail = $this->model->selectprepare("email_setting", $field=null, $params=null, $where=null, "WHERE id_kop='2' AND status='Y'"); echo "<script type=\"text/javascript\">alert('Data Berhasil diSimpan!');window.location.href=\"./index.php?op=sm\";</script>"; }else{ die("<script>alert('Data Gagal di simpan ke Database, Silahkan Coba Kembali..!!');window.history.go(-1);</script>"); } }else{ echo "<script type=\"text/javascript\">alert('File gagal di Upload ke Folder, Silahkan ulangi!!!');window.history.go(-1);</script>"; } }else{ echo "<script type=\"text/javascript\">alert('File gagal di Upload, Format file tidak di dukung!!!');window.history.go(-1);</script>"; } } } }else{ if(isset($_GET['smid'])){ $smid = htmlspecialchars($purifier->purify(trim($_GET['smid'])), ENT_QUOTES); $params = array(':id_sm' => $smid); $cek_sm = $this->model->selectprepare("surat_masuk", $field=null, $params, "id_sm=:id_sm"); $file_surat = ''; if($cek_sm->rowCount() >= 1){ $data_sm = $cek_sm->fetch(PDO::FETCH_OBJ); $title = "Edit Data Surat Masuk"; $ketfile = "File Surat "; $noagenda = $this->model->noref_sm($data_sm->id_sm); $no_sm = 'value="'.$data_sm->no_sm .'"'; $tgl_sm = explode_tanggal($data_sm->tgl_sm); $tgl_agenda = explode_tanggal($data_sm->tgl_agenda); $tgl_terima = explode_tanggal($data_sm->tgl_terima); $tgl_duedate = explode_tanggal($data_sm->tgl_duedate); $asal_sm = $data_sm->asal_sm; $kode_masalah = $data_sm->kodemasalah; $kodemasalahid = $data_sm->kodemasalahid; $kerahasiaan = $data_sm->kerahasiaan; $perihal = $data_sm->perihal; $keterangan = $data_sm->keterangan; $status_draft = $data_sm->status_draft; $file_surat = $data_sm->file; $validasifile = "required"; if(isset($data_sm->tujuan_surat) == '' OR $data_sm->tujuan_surat == "null"){ $dummy_arr = '[""]'; $cekDiteruskan = json_decode($dummy_arr, true); }else{ $cekDiteruskan = json_decode($data_sm->tujuan_surat, true); } //$noAgenda = sprintf("%04d", $data_sm->no_agenda); }else{ $title = "Entri Surat Masuk"; $ketfile = "File Surat "; $validasifile = "required"; $dummy_arr = '[""]'; $cekDiteruskan = json_decode($dummy_arr, true); $noagenda = "Otomatis"; } $datepicker = "date-picker"; $datepicker_simple = "date-picker-simple"; $disabled = "disabled='disabled'"; $readonly = "readonly='readonly'"; }else{ $title = "Entri Surat Masuk"; $validasifile = "required"; $ketfile = "File Surat *"; $dummy_arr = '[""]'; $cekDiteruskan = json_decode($dummy_arr, true); $noagenda = "Otomatis"; $datepicker = "date-picker"; $datepicker_simple = "date-picker-simple"; $disabled = "required"; $readonly = "required"; $status_draft = "99"; }?> <div class="widget-box"> <div class="widget-header"> <h4 class="widget-title"><?php echo $title;?></h4> <div class="widget-toolbar"> <a href="#" data-action="collapse"> <i class="ace-icon fa fa-chevron-up"></i> </a> <a href="#" data-action="close"> <i class="ace-icon fa fa-times"></i> </a> </div> </div> <div class="widget-body"> <div class="widget-main"> <form class="form-horizontal" role="form" enctype="multipart/form-data" method="POST" name="formku" action="<?php echo $_SESSION['url'];?>"> <div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-1"> No. Agenda *</label> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Di isi sesuai dengan nomor agenda surat masuk." title="Nomor Agenda">?</span> <div class="col-sm-4"> <input class="form-control" placeholder="Nomor Agenda Surat" type="text" name="noagenda" value="<?php echo $noagenda ?>" id="form-field-mask-1" disabled /> </div> </div> <div class="space-4"></div> <div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1"> Tanggal Agenda *</label> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Di isi sesuai dengan tanggal pada surat keluar. ex. 01-12-2015" title="Tanggal Agenda">?</span> <div class="col-sm-3"> <input class="form-control id="tgl_agenda" data-date-format="dd-mm-yyyy" placeholder="Tanggal Agenda" type="text" name="tgl_agenda" readonly="readonly" value="<?php if(isset($tgl_agenda)){ echo $tgl_agenda; } else { if(date('w') == '0' || date('w') == '6' || array_search(date("Y-m-d"), $this->model->hari_libur("input"))){ echo ""; } else { echo date("d-m-Y"); } }?>" <?php echo $readonly ?>/> </div> </div> <div class="space-4"></div> <div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1"> Tanggal diterima *</label> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Di isi sesuai dengan tanggal pada surat keluar. ex. 01-12-2015" title="Tanggal diterima">?</span> <div class="col-sm-3"> <input class="form-control <?php echo $datepicker_simple ?>" id="id-date-picker-1" data-date-format="dd-mm-yyyy" placeholder="Tanggal surat masuk" type="text" name="tgl_terima" value="<?php if(isset($tgl_terima)){ echo $tgl_terima; } else { echo date("d-m-Y");}?>" id="form-field-mask-1" required/> </div> </div> <div class="space-4"></div> <div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1"> Asal Surat *</label> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Di isi sesuai Asal Surat Masuk." title="Perihal">?</span> <div class="col-sm-9"> <textarea class="form-control limited" placeholder="Asal surat masuk" name="asal_sm" id="form-field-9" maxlength="150" required><?php if(isset($asal_sm)){ echo $asal_sm; }?></textarea> </div> </div> <div class="space-4"></div> <div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1"> Nomor Surat *</label> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Di isi sesuai dengan nomor surat masuk yang diterima." title="Nomor Surat Masuk">?</span> <div class="col-sm-4"> <input class="form-control" placeholder="Nomor surat masuk" type="text" name="no_sm" <?php if(isset($no_sm)){ echo $no_sm; }?> id="form-field-mask-1" required/> </div> </div> <div class="space-4"></div> <div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1"> Tanggal Surat Eksternal *</label> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Di isi sesuai dengan tanggal pada surat keluar. ex. 01-12-2015" title="Tanggal Surat Eksternal">?</span> <div class="col-sm-3"> <input class="form-control <?php echo $datepicker_simple ?>" id="id-date-picker-1" data-date-format="dd-mm-yyyy" placeholder="Tanggal surat Eksternal" type="text" name="tgl_sm" value="<?php if(isset($tgl_sm)){ echo $tgl_sm; } else { echo date("d-m-Y");}?>" id="form-field-mask-1" required/> </div> </div> <div class="space-4"></div> <div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1"> Due Date *</label> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Di isi sesuai dengan tanggal pada surat keluar. ex. 01-12-2015" title="Tanggal Surat">?</span> <div class="col-sm-3"> <input class="form-control <?php echo $datepicker ?>" id="id-date-picker-1" data-date-format="dd-mm-yyyy" placeholder="Tanggal surat keluar" type="text" name="tgl_duedate" value="<?php if(isset($tgl_duedate)){ echo $tgl_duedate; } else { echo date("d-m-Y");}?>" id="form-field-mask-1" required/> </div> </div> <div class="space-4"></div> <div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1">Kode Masalah *</label> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Pilih Kode Masalah." title="Kode Masalah">?</span> <div class="col-sm-4"> <select class="form-control" id="kode_masalah__" name="kode_masalah__" data-placeholder="Pilih Kode..." <?php echo $disabled ?>> <?php $params = ''; $getdata= $this->model->selectprepare("tb_jenis_masalah", $field=null, $params, 'kode_masalah=:kode_masalah', $order=null); if($getdata->rowCount() >= 1){ echo "<option value=''>= Pilih =</option>"; while($datashow = $getdata->fetch(PDO::FETCH_OBJ)){ $kode = "(".$datashow->kode_masalah.") ".$datashow->nama_masalah; $selected = $kode_masalah == $datashow->kode_masalah ? "selected='selected'" : ''; echo "<option value='".$datashow->kode_masalah."' ".$selected.">".$kode."</option>"; } } ?> </select> </div> <div class="col-sm-4"> <select class="form-control" id="kode__" name="kode_masalah" data-placeholder="Pilih Kode..." <?php echo $disabled ?>> <?php if(isset($_GET['smid'])){ $params = array(':kode_masalah' => $kode_masalah); $getdata= $this->model->selectprepare("kode_masalah", $field=null, $params, 'kode_masalah=:kode_masalah', $order=null); if($getdata->rowCount() >= 1){ while($datashow = $getdata->fetch(PDO::FETCH_OBJ)){ $kode = $datashow->kode_masalah.".".$datashow->primer.".".$datashow->sekunder." (".$datashow->keterangan.")"; $selected = $kodemasalahid == $datashow->id ? "selected='selected'" : ''; echo "<option value='".$datashow->id."' ".$selected.">".$kode."</option>"; } } } ?> </select> </div> <div class="col-sm-1 ajax_loader"> <img src="assets/images/loader.gif"/> </div> </div> <div class="space-4"></div> <div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1"> Perihal *</label> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Di isi sesuai perihal atau subjek surat masuk." title="Perihal">?</span> <div class="col-sm-9"> <textarea class="form-control limited" placeholder="Perihal/subjek surat" name="perihal" id="form-field-9" maxlength="150" required><?php if(isset($perihal)){ echo $perihal; }?></textarea> </div> </div> <div class="space-4"></div> <div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1"> Kerahasiaan *</label> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Di isi sesuai Data kerahasiaan." title="Kerahasiaan">?</span> <div class="col-sm-9"> <select class="form-control" id="kerahasiaan" name="kerahasiaan" data-placeholder="Pilih Kerahasiaan..." required> <?php $arr_kerahasiaan = array( '' => '= Pilih =', '1' => 'Biasa', '2' => 'Rahasia' ); foreach ($arr_kerahasiaan as $key => $val) { $selected = $kerahasiaan == $key ? "selected='selected'" : ''; echo "<option value='".$key."' ".$selected.">".$val."</option>"; } ?> </select> </div> </div> <div class="space-4"></div> <!--div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1"> Kepada *</label> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Pilih tujuan Surat dieruskan (support multiple choise)." title="Diteruskan ke *">?</span> <div class="col-sm-8"> <div class="space-2"></div> <select multiple="" class="chosen-select form-control" name="tujuan_surat[]" id="form-field-select-3" data-placeholder="Pilih Pegawai..." required><?php $Diteruskan = $this->model->selectprepare("user a join user_jabatan b on a.jabatan=b.id_jab", $field=null, $params=null, $where=null, "ORDER BY a.nama ASC"); if($Diteruskan->rowCount() >= 1){ while($dataDiteruskan = $Diteruskan->fetch(PDO::FETCH_OBJ)){ $DiteruskanSurat = $dataDiteruskan->nama ." (".$dataDiteruskan->nama_jabatan .")"; if(false !== array_search($dataDiteruskan->id_user, $cekDiteruskan)){?> <option value="<?php echo $dataDiteruskan->id_user;?>" selected><?php echo $DiteruskanSurat;?></option><?php }else{?> <option value="<?php echo $dataDiteruskan->id_user;?>"><?php echo $DiteruskanSurat;?></option><?php } } }else{?> <option value="">Not Found</option><?php }?> </select> </div> </div--> <div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1"> Kepada *</label> <a href="#my-modal" role="button" class="blue" data-toggle="modal"><span class="ace-icon fa fa-search-plus bigger-130" data-placement="left"></span></a> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Di isi sesuai dengan tujuan surat (nama lembaga atau perorangan)." title="Kepada">?</span> <label class="col-sm-3 control-label no-padding-left" for="form-field-mask-1"> <a href="#selected-modal" data-toggle="modal"><b class="m_selected">0 Selected </b></a></label> </div> <div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1"> Tembusan Surat *</label> <a href="#my-modal2" role="button" class="blue" data-toggle="modal"><span class="ace-icon fa fa-search-plus bigger-130" data-placement="left"></span></a> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Di isi sesuai dengan tembusan surat (nama lembaga atau perorangan)." title="Kepada">?</span> <label class="col-sm-3 control-label no-padding-left" for="form-field-mask-1"> <a href="#selected-modal2" data-toggle="modal"><b class="m_selected2">0 Selected </b></a></label> </div> <!--div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1"> Kepada *</label> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Di isi sesuai dengan tujuan surat (nama lembaga atau perorangan)." title="Kepada">?</span> <div class="col-sm-6"> <select multiple="" class="chosen-select form-control" id="m_tujuan" name="m_tujuan[]" data-placeholder="Pilih Tujuan Surat" required> <?php $UKerUser= $this->model->selectprepare("tag", $field=null, $params=null, $where=null, "Order by nama_pendek"); if($UKerUser->rowCount() >= 1){ ?> <?php while($dataUKerUser= $UKerUser->fetch(PDO::FETCH_OBJ)){ $nip = $dataUKerUser->nip; $ukt= $this->model->selectprepare("surat_masuk", $field=null, $params=null, $where=null, "WHERE FIND_IN_SET('{$nip}',UNQOUTE_LIST(tujuan_surat)) and id_sm={$smid}"); $selected = ($ukt->rowCount() > 0 ) ? "selected" : 'xxx'; ?> <option value="<?php echo $dataUKerUser->nip;?>" <?php echo $selected; ?>><?php echo $dataUKerUser->nama_user." (".$dataUKerUser->nip.")";?></option> <?php } }?> </select> </div> </div--> <div class="space-4"></div> <div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1"> <?php echo $ketfile;?></label> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Pilih File surat masuk yang ingin di upload. Caranya klik menu Pilih File. Tipe file : .pdf, .jpg, .png" title="File surat masuk">?</span> <div class="col-sm-4"> <?php if($file_surat != ""){?> <span> <a href="./berkas/<?php echo $file_surat;?>" target="_blank"><?php echo $file_surat;?></a> </span> <?php } ?> <input type="file" class="form-control" name="filesm" id="id-input-file-1" required <?php if(isset($_GET['smid']) and $file_surat == ""){ echo $validasifile; }?> /> </div> </div> <div class="space-4"></div> <div class="form-group"> <label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1"> Keterangan </label> <span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Di isi sesuai keterangan file surat masuk." title="Keterangan">?</span> <div class="col-sm-9"> <textarea class="form-control limited" placeholder="Keterangan file surat" name="keterangan" id="keterangan" maxlength="150"><?php if(isset($keterangan)){ echo $keterangan; }?></textarea> </div> </div> <div class="clearfix form-actions"> <?php if(isset($_GET['smid'])){}else{ ?> <div class="col-md-offset-3 col-md-3"> <div class="col-sm-2"> <button type="submit" value="submit" id="tombol" name="tombol" class="btn btn-info" type="button" disabled> <i class="ace-icon fa fa-check bigger-110"></i> Publish </button> </div> </div> <?php } ?> <?php if(isset($_GET['smid']) AND $status_draft == 0){ ?> <div class="col-md-offset-3 col-md-3"> <div class="col-sm-2"> <button type="submit" value="publish" name="tombol" class="btn btn-success" type="button"> <i class="ace-icon fa fa-check bigger-110"></i> Publish </button> </div> </div> <?php } ?> </div> <div id="selected-modal" class="modal fade" tabindex="-1"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h3 class="smaller lighter blue no-margin">SELECTED TUJUAN PEGAWAI</h3> </div> <div class="modal-body munculkan"> <!-- Disini muncul data dari Jquery --> </div> <div class="modal-footer"> <button class="btn btn-sm btn-danger pull-right" data-dismiss="modal"> <i class="ace-icon fa fa-times"></i> Close </button> </div> </div><!-- /.modal-content --> </div><!-- /.modal-dialog --> </div> <div id="selected-modal2" class="modal fade" tabindex="-1"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h3 class="smaller lighter blue no-margin">SELECTED TEMBUSAN PEGAWAI</h3> </div> <div class="modal-body munculkan2"> <!-- Disini muncul data dari Jquery --> </div> <div class="modal-footer"> <button class="btn btn-sm btn-danger pull-right" data-dismiss="modal"> <i class="ace-icon fa fa-times"></i> Close </button> </div> </div><!-- /.modal-content --> </div><!-- /.modal-dialog --> </div> </form> </div> </div> </div> <div id="my-modal" class="modal fade" tabindex="-1"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h3 class="smaller lighter blue no-margin">SELURUH PEGAWAI</h3> </div> <div class="modal-body"> <div class="form-group"> <!-- <div class="col-sm-6" style="margin-bottom: 5px;"> Dept : <select class="form-control1" id="m_displayx" style="width:80%;" onchange="group_dept('100', this.value);"> <?php $field = array('departemen' => 'distinct departemen'); $Lsdept = $this->model->selectprepare("tag", $field, $params=null, $where=null, "ORDER BY departemen ASC"); while($dtlsdept = $Lsdept->fetch(PDO::FETCH_OBJ)){ echo '<option value="'.$dtlsdept->departemen.'">'.$dtlsdept->departemen.'</option>'; } /* $field = array('departemen' => 'distinct departemen'); $Lsdept = $this->model->selectprepare("tag", $field, $params=null, $where=null, "ORDER BY departemen ASC"); while($dataListUser = $ListUser->fetch(PDO::FETCH_OBJ)){ if(false !== array_search($dataListUser->id_user, json_decode($tujuan_surat, true))){ $TujuanSurat .= '- '.$dataListUser->nama .' ('.$dataListUser->nama_jabatan .')<br/>'; } } */ ?> </select> </div> --> <label class="col-sm-2 control-label no-padding-left" for="form-field-1"> Display</label> <div class="col-sm-2"> <select class="form-control1" id="m_display"> <option value="10">10</option> <option value="25">25</option> <option value="50">50</option> <option value="100">100</option> </select> </div> <label class="col-sm-2 control-label no-padding-left" for="form-field-1"> dari <span class="jumlahdata"></span> Data</label> <div class="col-sm-6"> <div class="nav-search" id="nav-search"> <form class="form-search" action="javascript:" method="post"> <span class="input-icon"> <input placeholder="Search ..." class="nav-search-input" id="m_cari" autocomplete="off" type="text"> <i class="ace-icon fa fa-search nav-search-icon"></i> </span> <!--<button type="submit" class="simpanbtl" hidden="hidden">P</button>--> <button type="submit" class="btn btn-info btn-xs simpanbtl" style="margin-top:-4px;" ><span class="glyphicon glyphicon-search"></span></button> </form> </div> </div> </div> <span class="loaderdata"></span> <table id="simple-table" class="table table-bordered table-hover"> <thead> <tr> <th class="center"> <label class="pos-rel"> <input type="checkbox" class="ace" /> <span class="lbl"></span> </label> </th> <th>NIK</th> <th>Nama</th> <th>Jabatan</th> <th>Departemen</th> </tr> </thead> <tbody class="tampilkandata"> </tbody> </table> </div> <div class="modal-footer"> <button class="btn btn-sm btn-info pull-left pilih_chk" data-dismiss="modal"> Pilih </button> <button class="btn btn-sm btn-danger pull-right" data-dismiss="modal"> <i class="ace-icon fa fa-times"></i> Close </button> </div> </div><!-- /.modal-content --> </div><!-- /.modal-dialog --> </div> <div id="my-modal2" class="modal fade" tabindex="-1"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h3 class="smaller lighter blue no-margin">SELURUH PEGAWAI</h3> </div> <div class="modal-body"> <div class="form-group"> <!-- <div class="col-sm-6" style="margin-bottom: 5px;"> Dept : <select class="form-control1" id="m_display2x" style="width:80%;" onchange="group_dept('100', this.value);"> <?php $field = array('departemen' => 'distinct departemen'); $Lsdept = $this->model->selectprepare("tag", $field, $params=null, $where=null, "ORDER BY departemen ASC"); while($dtlsdept = $Lsdept->fetch(PDO::FETCH_OBJ)){ echo '<option value="'.$dtlsdept->departemen.'">'.$dtlsdept->departemen.'</option>'; } /* $field = array('departemen' => 'distinct departemen'); $Lsdept = $this->model->selectprepare("tag", $field, $params=null, $where=null, "ORDER BY departemen ASC"); while($dataListUser = $ListUser->fetch(PDO::FETCH_OBJ)){ if(false !== array_search($dataListUser->id_user, json_decode($tujuan_surat, true))){ $TujuanSurat .= '- '.$dataListUser->nama .' ('.$dataListUser->nama_jabatan .')<br/>'; } } */ ?> </select> </div> --> <label class="col-sm-2 control-label no-padding-left" for="form-field-1"> Display</label> <div class="col-sm-2"> <select class="form-control1" id="m_display2"> <option value="10">10</option> <option value="25">25</option> <option value="50">50</option> <option value="100">100</option> </select> </div> <label class="col-sm-2 control-label no-padding-left" for="form-field-1"> dari <span class="jumlahdata"></span> Data</label> <div class="col-sm-6"> <div class="nav-search" id="nav-search"> <form class="form-search" action="javascript:" method="post"> <span class="input-icon"> <input placeholder="Search ..." class="nav-search-input" id="m_cari2" autocomplete="off" type="text"> <i class="ace-icon fa fa-search nav-search-icon"></i> </span> <!--<button type="submit" class="simpanbtl2" hidden="hidden">P</button>--> <button type="submit" class="btn btn-info btn-xs simpanbtl2" style="margin-top:-4px;" ><span class="glyphicon glyphicon-search"></span></button> </form> </div> </div> </div> <span class="loaderdata"></span> <table id="simple-table2" class="table table-bordered table-hover"> <thead> <tr> <th class="center"> <label class="pos-rel"> <input type="checkbox" class="ace" /> <span class="lbl"></span> </label> </th> <th>NIK</th> <th>Nama</th> <th>Jabatan</th> <th>Departemen</th> </tr> </thead> <tbody class="tampilkandata2"> </tbody> </table> </div> <div class="modal-footer"> <button class="btn btn-sm btn-info pull-left pilih_chk2" data-dismiss="modal"> Pilih </button> <button class="btn btn-sm btn-danger pull-right" data-dismiss="modal"> <i class="ace-icon fa fa-times"></i> Close </button> </div> </div><!-- /.modal-content --> </div><!-- /.modal-dialog --> </div> <script> function IsEmpty() { if (document.forms['formku'].tembusan.value === "") { alert("Harap diisi Tembusan Surat"); return false; } return true; } </script> <input type="hidden" value="<?php if(isset($_GET['smid'])){ echo $_GET['smid']; }?>" id="smidhelp"/> <script src="assets/js/jquery-2.1.4.min.js"></script> <script type="text/javascript"> $(document).ready(function () { if($("#smidhelp").val() != ""){ $.ajax({ url: "./index.php?op=get_users", global : true, type : "POST", async : true, dataType : "json", data : { table : "surat_masuk", id : $("#smidhelp").val() }, success: function (response) { $(".m_selected").html(response.countTujuan+" Selected"); // $(".tag_selected").html(response.countTujuan); $(".munculkan").html(response.dataq); $(".m_selected2").html(response.countTembusan+" Selected"); $(".munculkan2").html(response.datav); } }); } $(".ajax_loader").hide(); $("#kode_masalah__").on("change", function(){ var key = $(this).val(); $.ajax({ url: "./index.php?op=get_kodemasalah", global : true, type : "POST", async : true, dataType : "json", data : { kode_masalah : key }, success: function (response) { //console.log(response); $("#kode__").html(response.kodemasalah); $(".ajax_loader").hide(); }, beforeSend: function() { $(".ajax_loader").show(); }, error:function (xhr, ajaxOptions, thrownError) { alert(xhr.statusText); alert(thrownError); } }); }); var active_class = 'active'; $('#simple-table > thead > tr > th input[type=checkbox]').eq(0).on('click', function(){ var th_checked = this.checked;//checkbox inside "TH" table header $(this).closest('table').find('tbody > tr').each(function(){ var row = this; if(th_checked) $(row).addClass(active_class).find('input[type=checkbox]').eq(0).prop('checked', true); else $(row).removeClass(active_class).find('input[type=checkbox]').eq(0).prop('checked', false); }); }); //select/deselect a row when the checkbox is checked/unchecked $('#simple-table').on('click', 'td input[type=checkbox]' , function(){ var $row = $(this).closest('tr'); if($row.is('.detail-row ')) return; if(this.checked) $row.addClass(active_class); else $row.removeClass(active_class); }); $('#simple-table2 > thead > tr > th input[type=checkbox]').eq(0).on('click', function(){ var th_checked = this.checked;//checkbox inside "TH" table header $(this).closest('table').find('tbody > tr').each(function(){ var row = this; if(th_checked) $(row).addClass(active_class).find('input[type=checkbox]').eq(0).prop('checked', true); else $(row).removeClass(active_class).find('input[type=checkbox]').eq(0).prop('checked', false); }); }); //select/deselect a row when the checkbox is checked/unchecked $('#simple-table2').on('click', 'td input[type=checkbox]' , function(){ var $row = $(this).closest('tr'); if($row.is('.detail-row ')) return; if(this.checked) $row.addClass(active_class); else $row.removeClass(active_class); }); }); var m_display = $("#m_display").val(); panggil_pegawais(m_display); $(".simpanbtl").click(function(){ var key_cari = $("#m_cari").val(); var m_display2 = $("#m_display").val(); //panggil_pegawais(m_display, key_cari); var key_dept = $("#m_displayx").val(); panggil_pegawais2(m_display2, key_cari, key_dept); }); var m_display2 = $("#m_display2").val(); panggil_pegawais(m_display2); $(".simpanbtl2").click(function(){ var key_cari2 = $("#m_cari2").val(); var m_display2 = $("#m_display2").val(); var key_dept2 = $("#m_display2x").val(); panggil_pegawais2(m_display2, key_cari2, key_dept2); }); $("#m_display").change(function(){ var key = $(this).val(); panggil_pegawais(key); }); $("#m_display2").change(function(){ var key = $(this).val(); panggil_pegawais2(key); }); $(".pilih_chk").click(function() { var jumlahid = 0; $(".ace_pilih").each(function(i){ if($(this).is(":checked")){ var keys = $(this).val(); if($(".m_tujuan_"+keys).val() == undefined){ $(".munculkan").append('<p class="m_hapus_'+ keys +'"><a href="javascript:" onclick="m_hapus(\''+keys+'\')" class="m_hapus_'+ keys +'">X </a> '+$(this).attr('attrnama')+'</p><input type="hidden" name="m_tujuan[]" id="m_tujuan[]" class="m_tujuan m_tujuan_'+ keys +' m_hapus_'+ keys +'" value="'+keys+'">'); } jumlahid++; } }); var dataTujuan = $(".m_tujuan").length; var dataPegawai = $(".m_tujuan").val(); // alert(dataPegawai); $(".m_selected").html(dataTujuan+" Selected"); // $(".tag_selected").html(dataPegawai); }); $(".pilih_chk2").click(function() { $("#tombol").prop('disabled', false); var jumlahid = 0; $(".ace_pilih2").each(function(i){ if($(this).is(":checked")){ var keys = $(this).val(); if($(".m_tembusan_"+keys).val() == undefined){ $(".munculkan2").append('<p class="v_hapus_'+ keys +'"><a href="javascript:" onclick="v_hapus(\''+keys+'\')" class="v_hapus_'+ keys +'">X </a> '+$(this).attr('attrnama')+'</p><input type="hidden" name="m_tembusan[]" id="m_tembusan[]" class="m_tembusan m_tembusan_'+ keys +' v_hapus_'+ keys +'" value="'+keys+'">'); } jumlahid++; } }); var dataTembusan = $(".m_tembusan").length; $(".m_selected2").html(dataTembusan+" Selected"); }); function panggil_pegawais(m_display = "", m_cari = ""){ $.ajax({ url: "./index.php?op=get_pegawais", global : true, type : "POST", async : true, dataType : "json", data : { m_display : m_display, m_cari : m_cari }, beforeSend: function() { $(".loaderdata").show('<center><img src="assets/images/loader.gif"/></center>'); }, success: function (response) { $(".loaderdata").hide(); $(".tampilkandata").html(response.html); $(".tampilkandata2").html(response.html2); $(".jumlahdata").html("<b>"+response.jumlahdata+"</b>"); } }); } function m_hapus(id = ""){ $(".m_hapus_"+id).remove(); var dataTujuan = $(".m_tujuan").length; $(".m_selected").html(dataTujuan+" Selected"); } function v_hapus(id = ""){ $(".v_hapus_"+id).remove(); var dataTembusan = $(".m_tembusan").length; $(".m_selected2").html(dataTembusan+" Selected"); } function group_dept(m_display = "", m_cari = ""){ $.ajax({ url: "./index.php?op=group_dept", global : true, type : "POST", async : true, dataType : "json", data : { m_display : m_display, m_cari : m_cari }, beforeSend: function() { $(".loaderdata").show('<center><img src="assets/images/loader.gif"/></center>'); }, success: function (response) { $(".loaderdata").hide(); $(".tampilkandata").html(response.html); $(".tampilkandata2").html(response.html2); $(".jumlahdata").html("<b>"+response.jumlahdata+"</b>"); } }); } function panggil_pegawais2(m_display = "", m_cari = "", m_dept = ""){ $.ajax({ url: "./index.php?op=get_pegawais2", global : true, type : "POST", async : true, dataType : "json", data : { m_display : m_display, m_cari : m_cari, m_dept : m_dept }, beforeSend: function() { $(".loaderdata").show('<center><img src="assets/images/loader.gif"/></center>'); }, success: function (response) { $(".loaderdata").hide(); $(".tampilkandata").html(response.html); $(".tampilkandata2").html(response.html2); $(".jumlahdata").html("<b>"+response.jumlahdata+"</b>"); } }); } </script> <?php } ?>