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++; } }