public static function getNamaKPPN()
{
$model = new Model();
$kppn = $model->select('SELECT satker FROM kantor');
foreach ($kppn as $data) {
$kppn = $data['satker'];
}
$kppn = (string) $kppn;
$len = strlen($kppn);
if ($len == 1) {
$kppn = '00' . $kppn;
} elseif ($len == 2) {
$kppn = '0' . $kppn;
}
$config = array('host' => DB_HOST, 'db_name' => DB_NAME_KPPN, 'pass' => DB_PASS, 'port' => DB_PORT_KPPN, 'user' => DB_USER);
$con = new Koneksi();
$sql = "SELECT nmkppn FROM t_kppn WHERE kdkppn=:kdkppn";
$pdo = $con->getConnection($config);
$stmt = $pdo->prepare($sql);
$stmt->bindValue(':kdkppn', $kppn);
$stmt->execute();
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
$nmkppn = 'KANTOR PELAYANAN PERBENDAHARAAN NEGARA ';
foreach ($data as $val) {
$nmkppn .= strtoupper($val['nmkppn']);
}
unset($con);
unset($model);
return $nmkppn;
}
function getKodeSatker($data = null)
{
$config = array('host' => DB_HOST, 'db_name' => DB_NAME_KPPN, 'pass' => DB_PASS, 'port' => DB_PORT_KPPN, 'user' => DB_USER);
$con = new Koneksi();
$pdo = $con->getConnection($config);
$sql = "SELECT kdsatker,nmsatker FROM t_satker LIMIT 0,30";
$stmt = $pdo->prepare($sql);
$stmt->execute();
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
unset($con);
return $data;
}
public function ubahAlamat($kd, $satker = null)
{
if (!Auth::isAllow(5, Session::get('role'), 1, Session::get('bagian'))) {
header('location:' . URL . 'home');
}
if (isset($_POST['submit'])) {
if ($this->updateRekamAlamat()) {
$this->view->success = "Ubah data berhasil";
} else {
$this->view->error = "Ubah alamat gagal! alamat satker ini telah ada.";
}
}
$alamat = $this->model->getAlamat($kd);
foreach ($alamat as $value) {
$this->view->id = $value['id_alamat'];
$tmp = explode('.', $value['kode_satker']);
$this->view->tipe = $tmp[0];
$this->view->kode_satker = $tmp[1];
$this->view->nama_satker = $value['nama_satker'];
$this->view->jabatan = $value['jabatan'];
$this->view->alamat = $value['alamat'];
$this->view->telepon = $value['telepon'];
$this->view->email = $value['email'];
}
//var_dump($this->view->id);
if (!is_null($satker)) {
$this->view->satker = $satker;
$config = array('host' => DB_HOST, 'db_name' => DB_NAME_KPPN, 'pass' => DB_PASS, 'port' => DB_PORT_KPPN, 'user' => DB_USER);
$con = new Koneksi();
$sql = 'SELECT nmsatker FROM t_satker WHERE kdsatker=' . $satker;
$pdo = $con->getConnection($config);
$stmt = $pdo->prepare($sql);
$stmt->execute();
$nm = $stmt->fetchAll(PDO::FETCH_ASSOC);
// $nm = $this->model->select('SELECT nmsatker FROM t_satker WHERE kdsatker=' . $satker);
foreach ($nm as $value) {
$this->view->nm_satker = $value['nmsatker'];
}
unset($con);
}
$this->view->data = $this->model->getAlamat();
$this->view->render('admin/alamat/ubahAlamat');
}
function lookupkab()
{
//konek db kppn
$filter = $_POST['queryString'];
$config = array('host' => DB_HOST, 'db_name' => DB_NAME_KPPN, 'pass' => DB_PASS, 'port' => DB_PORT_KPPN, 'user' => DB_USER);
$con = new Koneksi();
$pdo = $con->getConnection($config);
$stmt = $pdo->prepare("SELECT kdkabkota,nmkabkota FROM t_kabkota WHERE kdlokasi=:kdlok");
$stmt->bindValue(':kdlok', $filter);
$stmt->execute();
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
// $sql="SELECT kdkabkota,nmkabkota FROM t_kabkota WHERE kdlokasi=".$filter;
// $data = $this->model->select($sql);
$no = 1;
foreach ($data as $value) {
echo "<option value={$value['kdkabkota']}>{$value['nmkabkota']}</option>";
$no++;
}
}
