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 data_asisten($kd_asisten)
{
$koneksi = new Koneksi();
$koneksi->pilihkonekdb();
$sql = "\r\n\t\t\tSelect\r\n\t\t\tkd_asisten,\r\n\t\t\tnm_asisten,\r\n\t\t\thapeasisten,\r\n\t\t\talamat_asisten,\t\r\n\t\t\tkota_asisten,\t\t\r\n\t\t\ttmpt_lahirasisten,\r\n\t\t\ttgl_lahirasisten,\r\n\t\t\tno_idasisten,\r\n\t\t\tcopy_asisten\r\n\t\t\tFrom\r\n\t\t\tasisten\r\n\t\t\tWhere\r\n\t\t\tkd_asisten = '" . $kd_asisten . "'\r\n\t\t\t";
$list_cari = false;
$res = mysql_query($sql);
if ($res) {
while ($row = mysql_fetch_assoc($res)) {
$cari = new birojasa();
$cari->kd_asisten = $row['kd_asisten'];
$cari->nm_asisten = $row['nm_asisten'];
$cari->hapeasisten = $row['hapeasisten'];
$cari->alamat_asisten = $row['alamat_asisten'];
$cari->kota_asisten = $row['kota_asisten'];
$cari->tmpt_lahirasisten = $row['tmpt_lahirasisten'];
$cari->tgl_lahirasisten = $row['tgl_lahirasisten'];
$cari->no_idasisten = $row['no_idasisten'];
$cari->copy_asisten = $row['copy_asisten'];
$list_cari[] = $cari;
}
}
$koneksi->tutupdb();
return $list_cari;
}
function addPlan($Nama, $Email, $Telp, $Tgl_Pernikahan, $Tgl_Temu_WP, $Tempat_Temu)
{
$konek = new Koneksi();
$konek->con();
$query = mysql_query("INSERT INTO `planner` (`Plan_ID`, `Nama`, `Telp`, `Email`, `Tgl_Pernikahan`, `Tgl_Temu_WP`, `Tempat_Temu`) \r\n\t\tVALUES ('', '{$Nama}', '{$Telp}', '{$Email}', '{$Tgl_Pernikahan}', '{$Tgl_Temu_WP}', '{$Tempat_Temu}');");
$plan = $this->viewPlan();
return $plan;
}
function addTesti($nama, $email, $isi_testi)
{
$konek = new Koneksi();
$konek->con();
$query = mysql_query("INSERT INTO `testimoni` (`testi_id`, `nama`, `email`, `isi_testi`) \r\n\t\tVALUES ('', '{$nama}', '{$email}', '{$isi_testi}');");
$testimoni = $this->viewTesti();
return $testimoni;
}
function hitungTestimoni()
{
$koneksi = new Koneksi();
$koneksi->pilihkonekdb();
$sql = "\r\n\t\t\tSELECT \r\n\t\t\tcount(*) as total \r\n\t\t\tFROM \r\n\t\t\ttestimoni\r\n\t\t";
$itung = mysql_query($sql);
$jumlah = mysql_fetch_array($itung);
return $jumlah['total'];
}
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;
}
function gantiPassword($id_users, $password, $password1, $password2)
{
$koneksi = new Koneksi();
$koneksi->pilihkonekdb();
$sql = "\r\n\t\t\tselect\r\n\t\t\tpassword\r\n\t\t\tfrom \r\n\t\t\tusers\r\n\t\t\twhere\r\n\t\t\tkd_users='" . $id_user . "';\r\n\t\t";
$hasil = mysql_query($sql);
if ($password != $hasil) {
echo "Password lama salah";
}
if ($password1 != $password2) {
echo "Password baru tidak cocok";
}
if ($hasil == $password and $password1 == $password2) {
$sql = "\r\n\t\t\tupdate\r\n\t\t\tusers\r\n\t\t\tset\r\n\t\t\tpassword='******'\r\n\t\t\twhere\r\n\t\t\tkd_users='" . $id_users . "' \r\n\t\t\t";
mysql_query($sql);
}
$koneksi->tutupdb();
}
function tampilTransaksi()
{
$sql = "SELECT * FROM t_transaksi";
return Koneksi::getconn()->query($sql);
}
function setBayar($id_cucian)
{
include "include/db_connect.php";
$sql = "update t_pembayaran set statusPembayaran = 'Lunas' where id_cucian = {$id_cucian}";
return Koneksi::getconn()->query($sql);
}
function lamar($kd_lowongan, $kd_asisten)
{
$koneksi = new Koneksi();
$koneksi->pilihkonekdb();
echo $kd_asisten;
echo $kd_lowongan;
$sql = "\r\n\t\tINSERT INTO \r\n\t\t`detail_lowongan`\r\n\t\t(`KD_LOWONGAN`, `KD_MEMBER`, `KD_ASISTEN`) \r\n\t\tSELECT \r\n\t\tb.kd_lowongan, a.kd_member, a.kd_asisten \r\n\t\tFROM asisten a \r\n\t\tJOIN lowongan b \r\n\t\tWHERE b.kd_lowongan = '" . $kd_lowongan . "'\r\n\t\tAND\r\n\t\ta.kd_asisten = '" . $kd_asisten . "'\r\n\t\t";
$berhasil = mysql_query($sql) or die(mysql_error());
if ($berhasil) {
echo "berhasil";
} else {
echo "ngga berhasil :(";
}
$koneksi->tutupdb();
}
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++;
}
}
function editdatalaundy($id_cucian)
{
include "include/db_connect.php";
$sql = "UPDATE t_cucian SET jenis_cucian ='{$this->jenisCucian}',berat_cucian ='{$this->beratCucian}' WHERE id_cucian = {$id_cucian}";
$result = Koneksi::getconn()->query($sql);
}
<!--<div class="pagination pagination-right">
<ul>
<li><a href="#">Prev</a></li>
<li><a href="#">1</a></li>
<li><a href="#">2</a></li>
<li><a href="#">3</a></li>
<li><a href="#">Next</a></li>
</ul> </div>-->
<!--daftar testimoni-->
<?php
//include_once('header.php');
echo "<div class='span8'>";
// connect to the database
include '../model/koneksi.php';
$konek = new Koneksi();
$konek->con();
// number of results to show per page
$per_page = 3;
/* get results from database
$result = mysql_query("SELECT * FROM testimoni")
or die(mysql_error());*/
// figure out the total pages in the database
$result = mysql_query("SELECT * FROM testimoni ORDER BY testi_id DESC");
$total_results = mysql_num_rows($result);
$total_pages = ceil($total_results / $per_page);
// check if the 'page' variable is set in the URL (ex: view-paginated.php?page=1)
if (isset($_GET['page']) && is_numeric($_GET['page'])) {
$show_page = $_GET['page'];
// make sure the $show_page value is valid
if ($show_page > 0 && $show_page <= $total_pages) {
function tentukanPembantu($kd_lowongan, $kd_asisten, $status)
{
$koneksi = new Koneksi();
$koneksi->pilihkonekdb();
$sql1 = "\r\n\t\t\tUPDATE\r\n\t\t\tlowongan\r\n\t\t\tSET\r\n\t\t\tkd_asisten={$kd_asisten},kd_status=2\r\n\t\t\twhere\r\n\t\t\tkd_lowongan={$kd_lowongan}\r\n\t\t";
$hasil1 = mysql_query($sql1);
$sql2 = "\r\n\t\t\tUPDATE\r\n\t\t\tdetail_lowongan\r\n\t\t\tSET\r\n\t\t\tkd_status={$status}\r\n\t\t\twhere\r\n\t\t\tkd_lowongan={$kd_lowongan}\r\n\t\t\tAND\r\n\t\t\tkd_asisten={$kd_asisten}\r\n\t\t";
print_r($sql2);
$hasil2 = mysql_query($sql2);
$sql3 = "\r\n\t\t\tUPDATE\r\n\t\t\tdetail_lowongan\r\n\t\t\tSET\r\n\t\t\tkd_status=3\r\n\t\t\twhere\r\n\t\t\tkd_lowongan={$kd_lowongan}\r\n\t\t\tAND\r\n\t\t\tkd_asisten!={$kd_asisten}\r\n\t\t";
//print_r($sql3);
$hasil3 = mysql_query($sql3);
$koneksi->tutupdb();
return true;
}
function __construct()
{
$konek = new Koneksi();
$konek->con();
//return $this->link;
}
function editdatapelanggan($id_pelanggan)
{
$sql = "UPDATE t_pelanggan SET nama_pelanggan ='{$this->namaPelanggan}',alamat_pelanggan ='{$this->alamatPelanggan}',telepon ='{$this->telepon}' WHERE id_pelanggan = {$id_pelanggan}";
$result = Koneksi::getconn()->query($sql);
}
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');
}
