} $conn->committrans(); } catch (Exception $e) { $msg = $e->getmessage(); $error = TRUE; if ($conn) { $conn->rollbacktrans(); } } close($conn); $json = array('act' => $act, 'error' => $error, 'msg' => $msg); echo json_encode($json); exit; } die_login(); die_app('M'); die_mod('M15'); $conn = conn($sess_db); die_conn($conn); if ($act == 'Ubah') { $obj = $conn->Execute("\n\t\tSELECT \n\t\ts.NO_VA,\n\t\ts.KODE_BLOK,\n\t\ts.LUAS_BANGUNAN,\n\t\ts.STATUS_STOK,\n\t\ts.TERJUAL,\n\t\ts.KODE_PENJUALAN,\n\t\tt.TIPE_BANGUNAN,\n\t\ths.KODE_SK,\n\t\ths.HARGA_CASH_KERAS,\n\t\ths.CB36X,\n\t\ths.CB48X,\n\t\ths.KPA24X,\n\t\ths.KPA36X,\n\t\th.*,\n\t\tju.*,\n\t\tt.*,\n\t\tp.*\n\t\tFROM \n\t\tSTOK s\n\t\tLEFT JOIN TIPE t ON s.KODE_TIPE = t.KODE_TIPE\n\t\tLEFT JOIN HARGA_SK hs ON s.KODE_SK = hs.KODE_SK AND s.KODE_BLOK = hs.KODE_BLOK\n\t\tLEFT JOIN LOKASI h ON s.KODE_LOKASI = h.KODE_LOKASI\n\t\tLEFT JOIN JENIS_UNIT ju ON s.KODE_UNIT = ju.KODE_UNIT\n\t\tLEFT JOIN JENIS_PENJUALAN p ON s.KODE_PENJUALAN = p.KODE_JENIS\n\t\tWHERE\t\t\n\t\ts.KODE_BLOK = '{$id}'"); $no_va = $obj->fields['NO_VA']; $kode_blok = $obj->fields['KODE_BLOK']; $kode_lokasi = $obj->fields['KODE_LOKASI']; $kode_unit = $obj->fields['KODE_UNIT']; $kode_tipe = $obj->fields['KODE_TIPE']; $kode_penjualan = $obj->fields['KODE_PENJUALAN']; $kode_sk = $obj->fields['KODE_SK']; $lokasi = $obj->fields['LOKASI']; $jenis_unit = $obj->fields['JENIS_UNIT']; $tipe_bangunan = $obj->fields['TIPE_BANGUNAN'];
<?php require_once '../../../../config/config.php'; die_login(); die_app('A01'); die_mod('PT02'); $conn = conn($sess_db); die_conn($conn); $per_page = isset($_REQUEST['per_page']) ? max(1, $_REQUEST['per_page']) : 20; $page_num = isset($_REQUEST['page_num']) ? max(1, $_REQUEST['page_num']) : 1; $s_opf1 = isset($_REQUEST['s_opf1']) ? clean($_REQUEST['s_opf1']) : ''; $s_opv1 = isset($_REQUEST['s_opv1']) ? clean($_REQUEST['s_opv1']) : ''; $query_search = ''; if ($s_opv1 != '') { $query_search .= "WHERE {$s_opf1} LIKE '%{$s_opv1}%' "; } # Pagination $query = "\nSELECT \n\tCOUNT(KODE_BLOK) AS TOTAL\nFROM \n\tRESERVE\n{$query_search}\n"; $total_data = $conn->Execute($query)->fields['TOTAL']; $total_page = ceil($total_data / $per_page); $page_num = $page_num > $total_page ? $total_page : $page_num; $page_start = ($page_num - 1) * $per_page; # End Pagination ?> <table id="pagging-1" class="t-control"> <tr> <td class="text-right"> <input type="button" id="prev_page" value=" < "> Hal : <input type="text" name="page_num" size="5" class="page_num apply text-center" value="<?php echo $page_num;
ex_empty($cb_data, 'Pilih data yang akan diverifikasi.'); foreach ($cb_data as $id_del) { $query = "UPDATE KWITANSI SET \n\t\t\t\t\tVER_KEUANGAN = 1,\n\t\t\t\t\tVER_KEUANGAN_TANGGAL = CONVERT(DATETIME,'{$tgl}',105),\n\t\t\t\t\tVER_KEUANGAN_OFFICER = '{$officer}'\n\t\t\t\t\tWHERE NOMOR_KWITANSI = '{$id_del}'"; if ($conn->Execute($query)) { $act[] = $id_del; } else { $error = TRUE; } } $msg = $error ? 'Sebagian data kwitansi gagal diverifikasi.' : 'Data kwitansi berhasil diverifikasi.'; } } } $conn->committrans(); } catch (Exception $e) { $msg = $e->getmessage(); $error = TRUE; if ($conn) { $conn->rollbacktrans(); } } close($conn); $json = array('act' => $act, 'error' => $error, 'msg' => $msg); echo json_encode($json); exit; } die_login(); die_app(''); die_mod(''); $conn = conn($sess_db); die_conn($conn);
<?php require_once '../../../../config/config.php'; die_login(); die_app('C01'); die_mod('COL03'); $conn = conn($sess_db); die_conn($conn); $msg = ''; $error = FALSE; if ($_SERVER['REQUEST_METHOD'] == 'POST') { try { $conn->begintrans(); $no_surat_akhir = isset($_REQUEST['no_surat_akhir']) ? clean($_REQUEST['no_surat_akhir']) : ''; $registrasi = isset($_REQUEST['registrasi']) ? clean($_REQUEST['registrasi']) : ''; $conn->Execute("DELETE FROM REGISTRASI_SURAT"); $query = "\n\t\tINSERT INTO REGISTRASI_SURAT (\n\t\tNO_SURAT_AKHIR, REGISTRASI\n\t\t)\n\t\tVALUES (\n\t\t'{$no_surat_akhir}', '{$registrasi}'\n\t\t)\n\t\t"; ex_false($conn->Execute($query), $query); $conn->committrans(); $msg = 'Parameter berhasil diubah.'; } catch (Exception $e) { $msg = $e->getmessage(); $error = TRUE; $conn->rollbacktrans(); } close($conn); $json = array('msg' => $msg, 'error' => $error); echo json_encode($json); exit; }
include 'marketing/menu.php'; break; case 'C01': die_app($sess_app_id); include 'collection_tunai/menu.php'; break; case 'C02': die_app($sess_app_id); include 'collection_kpr/menu.php'; break; case 'C03': die_app($sess_app_id); include 'ppjb/menu.php'; break; case 'C04': die_app($sess_app_id); include 'kredit/menu.php'; break; } ?> </ul> <div id="profil"> <a href="index.php"><?php echo $_SESSION['FULL_NAME']; ?> </a> | <a href="authentic.php?act=logout">Logout</a> </div> <div class="clear"></div> </div>