PHP ex_found函数代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中ex_found函数的典型用法代码示例。如果您正苦于以下问题：PHP ex_found函数的具体用法？PHP ex_found怎么用？PHP ex_found使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了ex_found函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: ex_false

         $msg = "Proses upload \"{$file_name}\" berhasil";
     } else {
         $err = $_FILES['data_upload']['error'];
         $msg = "Proses upload eror";
     }
     $query = "\n\t\t\tUPDATE CS_JENIS_PAIJB \n\t\t\tSET \n\t\t\tKODE_JENIS = '{$kode_jenis}',\n\t\t\tNAMA_JENIS = '{$nama_jenis}',\n\t\t\tNAMA_FILE  = '{$nama_file}'\n\t\t\tWHERE\n\t\t\tKODE_JENIS = '{$id}'\n\t\t\t";
     ex_false($conn->execute($query), $query);
     $msg = 'Data Jenis PAIJB berhasil diubah.';
 } elseif ($act == 'Hapus') {
     ex_ha('JB04', 'D');
     $act = array();
     $cb_data = $_REQUEST['cb_data'];
     ex_empty($cb_data, 'Pilih data yang akan dihapus.');
     foreach ($cb_data as $id_del) {
         $query = "SELECT JENIS FROM CS_PPJB WHERE JENIS = '{$id_del}'";
         ex_found($conn->Execute($query)->recordcount(), "Kode \"{$id_del}\" telah terdaftar. Tidak bisa dihapus");
         $select = "SELECT * FROM CS_JENIS_PAIJB WHERE KODE_JENIS = '{$id_del}'";
         $obj = $conn->execute($select);
         $kode_jenis = $obj->fields['KODE_JENIS'];
         $nama_jenis = $obj->fields['NAMA_JENIS'];
         $nama_file = $obj->fields['NAMA_FILE'];
         //delete file
         $path = $folder . $nama_file;
         if (@unlink($path)) {
             $msg = "Deleted file ";
         } else {
             $msg = "File can't be deleted";
         }
         $query = "DELETE FROM CS_JENIS_PAIJB WHERE KODE_JENIS = {$id_del}";
         if ($conn->Execute($query)) {
             $act[] = $id_del;

开发者ID:rizafr，项目名称:market_ancol，代码行数:31，代码来源:jappjb_proses.php

示例2: ex_false

     ex_false($conn->Execute($query), $query);
     $msg = 'Data persediaan awal berhasil ditambah.';
 } elseif ($act == 'Ubah') {
     ex_ha('M28', 'U');
     ex_empty($no_va, 'Nomor VA harus diisi.');
     ex_empty($kode_blok, 'Kode Blok harus diisi.');
     ex_empty($kode_lokasi, 'Tower harus diisi.');
     ex_empty($kode_unit, 'Jenis unit harus diisi.');
     ex_empty($kode_tipe, 'Tipe harus diisi.');
     ex_empty($kode_penjualan, 'Jenis penjualan harus diisi.');
     if ($kode_blok != $id) {
         $query = "SELECT COUNT(KODE_BLOK) AS TOTAL FROM STOK WHERE KODE_BLOK = '{$kode_blok}'";
         ex_found($conn->Execute($query)->fields['TOTAL'], "Kode blok \"{$kode_blok}\" telah terdaftar.");
     }
     $query = "SELECT * FROM STOK WHERE KODE_BLOK = '{$kode_blok}' AND KODE_UNIT = '{$kode_unit}' AND KODE_DESA = '{$kode_desa}' AND KODE_LOKASI = '{$kode_lokasi}' AND \n\t\t\tKODE_SK_TANAH = '{$kode_sk_tanah}' AND KODE_FAKTOR = '{$kode_faktor}' AND KODE_TIPE = '{$kode_tipe}' AND \n\t\t\tKODE_SK = '{$kode_sk}' AND KODE_PENJUALAN = '{$kode_penjualan}' AND LUAS_TANAH = '{$luas_tanah}' AND \n\t\t\tLUAS_BANGUNAN = '{$luas_bangunan}' AND PPN_TANAH = '{$ppn_tanah}' AND PPN_BANGUNAN = '{$ppn_bangunan}' AND \n\t\t\tDISC_TANAH = '{$disc_tanah}' AND DISC_BANGUNAN = '{$disc_bangunan}' AND CLASS = '{$class}' AND PROGRAM = '{$program}' AND \n\t\t\tSTATUS_GAMBAR_SITEPLAN = '{$status_gambar_siteplan}' AND STATUS_GAMBAR_LAPANGAN = '{$status_gambar_lapangan}' AND \n\t\t\tSTATUS_GAMBAR_GS = '{$status_gambar_gs}'AND NO_VA = '{$no_va}'";
     ex_found($conn->Execute($query)->recordcount(), "Tidak ada data yang berubah.");
     $query = "\n\t\t\tUPDATE STOK \n\t\t\tSET NO_VA = '{$no_va}',\n\t\t\tKODE_BLOK = '{$kode_blok}', \n\t\t\tKODE_UNIT = '{$kode_unit}', \n\t\t\tKODE_LOKASI = '{$kode_lokasi}', \n\t\t\tKODE_TIPE = '{$kode_tipe}', \n\t\t\tKODE_SK = '{$kode_sk}', \n\t\t\tKODE_PENJUALAN = '{$kode_penjualan}', \t\t\t\t\n\t\t\tLUAS_BANGUNAN = '{$luas_bangunan}'\n\t\t\tWHERE\t\t\t\n\t\t\tKODE_BLOK = '{$id}'\n\t\t\t";
     ex_false($conn->Execute($query), $query);
     $query = "\n\t\t\tUPDATE HARGA_SK \n\t\t\tSET \n\t\t\t\tHARGA_CASH_KERAS = '{$harga_cash_keras}',\n\t\t\t\tCB36X = '{$CB36X}',\n\t\t\t\tCB48X = '{$CB48X}',\n\t\t\t\tKPA24X = '{$KPA24X}',\n\t\t\t\tKPA36X = '{$KPA36X}'\n\t\t\tWHERE\n\t\t\t\tKODE_SK = '{$kode_sk}' \n\t\t\t\tAND KODE_BLOK = '{$id}'\n\t\t\t";
     ex_false($conn->Execute($query), $query);
     $msg = 'Data persediaan awal  berhasil diubah.';
 } elseif ($act == 'Hapus') {
     ex_ha('M28', 'D');
     $act = array();
     $cb_data = $_REQUEST['cb_data'];
     ex_empty($cb_data, 'Pilih data yang akan dihapus.');
     foreach ($cb_data as $id_del) {
         if ($conn->Execute("DELETE FROM STOK WHERE KODE_BLOK = '{$id_del}'")) {
             $act[] = $id_del;
         } else {
             $error = TRUE;

开发者ID:rizafr，项目名称:market_ancol，代码行数:31，代码来源:persediaan_awal_proses.php

示例3: ex_mod

 ex_mod('M18');
 $conn = conn($sess_db);
 ex_conn($conn);
 $conn->begintrans();
 if ($act == 'Spp') {
     ex_ha('M18', 'I');
     ex_empty($nama, 'Nama pembeli harus diisi.');
     ex_empty($alamat_rumah, 'Alamat rumah harus diisi.');
     ex_empty($identitas, 'Identitas harus diisi.');
     ex_empty($no_identitas, 'No identitas harus diisi.');
     ex_empty($tgl_spp, 'Tanggal SPP harus diisi.');
     ex_empty($koordinator, 'Koordinator harus diisi.');
     ex_empty($jumlah_kpr, 'Jumlah KPR harus diisi.');
     ex_empty($tanda_jadi, 'Tanda jadi harus diisi.');
     $query = "SELECT COUNT(KODE_BLOK) AS TOTAL FROM SPP WHERE KODE_BLOK = '{$kode_blok}'";
     ex_found($conn->Execute($query)->fields['TOTAL'], "Kode blok \"{$kode_blok}\" telah terdaftar.");
     $query = "\n\t\t\tINSERT INTO SPP \n\t\t\t(\t\t\t\t NOMOR_SPP,\n\t\t\t\t\t\t\t KODE_BLOK,\n\t\t\t\t\t\t\t NAMA_PEMBELI,\n\t\t\t\t\t\t\t ALAMAT_RUMAH,\n\t\t\t\t\t\t\t ALAMAT_SURAT,\n\t\t\t\t\t\t\t ALAMAT_NPWP,\n\t\t\t\t\t\t\t ALAMAT_EMAIL,\n\t\t\t\t\t\t\t IDENTITAS,\n\t\t\t\t\t\t\t NO_IDENTITAS,\n\t\t\t\t\t\t\t NPWP,\n\t\t\t\t\t\t\t JENIS_NPWP,\n\t\t\t\t\t\t\t TELP_RUMAH,\n\t\t\t\t\t\t\t TELP_KANTOR,\n\t\t\t\t\t\t\t TELP_LAIN,\n\t\t\t\t\t\t\t KODE_BANK,\n\t\t\t\t\t\t\t TANGGAL_SPP,\n\t\t\t\t\t\t\t KODE_AGEN,\n\t\t\t\t\t\t\t KODE_KOORDINATOR,\n\t\t\t\t\t\t\t JUMLAH_KPR,\n\t\t\t\t\t\t\t STATUS_KOMPENSASI,\n\t\t\t\t\t\t\t TANGGAL_AKAD,\n\t\t\t\t\t\t\t TANDA_JADI,\n\t\t\t\t\t\t\t TANGGAL_TANDA_JADI,\n\t\t\t\t\t\t\t STATUS_SPP,\n\t\t\t\t\t\t\t TANGGAL_PROSES,\n\t\t\t\t\t\t\t SPP_REDISTRIBUSI,\n\t\t\t\t\t\t\t SPP_REDISTRIBUSI_TANGGAL\n\t\t\t\t\t\t\t KETERANGAN,\n\t\t\t\t\t\t\t OTORISASI,\n\t\t\t\t\t\t\t TANGGAL_OTORISASI\n\t\t\t)\n\t\t\tVALUES\n\t\t\t(\n\t\t\t\t\t\t\t '{$no_spp}',\n\t\t\t\t\t\t\t '{$nama}',\n\t\t\t\t\t\t\t '{$alamat_rumah}',\n\t\t\t\t\t\t\t '{$alamat_surat}',\n\t\t\t\t\t\t\t '{$alamat_npwp}',\n\t\t\t\t\t\t\t '{$alamat_email}',\n\t\t\t\t\t\t\t '{$identitas}',\n\t\t\t\t\t\t\t '{$no_identitas}',\n\t\t\t\t\t\t\t '{$npwp}',\n\t\t\t\t\t\t\t '{$jenis_npwp}',\n\t\t\t\t\t\t\t '{$tlp_rumah}',\n\t\t\t\t\t\t\t '{$tlp_kantor}',\n\t\t\t\t\t\t\t '{$tlp_lain}',\n\t\t\t\t\t\t\t '{$bank}',\n\t\t\t\t\t\t\t CONVERT(DATETIME,{$tgl_spp},105),\n\t\t\t\t\t\t\t {$jumlah_kpr},\n\t\t\t\t\t\t\t '{$agen}',\n\t\t\t\t\t\t\t '{$koordinator}',\n\t\t\t\t\t\t\t CONVERT(DATETIME,'{$tgl_akad}',105),\n\t\t\t\t\t\t\t '{$status_kompensasi}',\n\t\t\t\t\t\t\t {$tanda_jadi},\n\t\t\t\t\t\t\t CONVERT(DATETIME,'{$tgl_tanda_jadi}',105),\n\t\t\t\t\t\t\t '{$status_spp}',\n\t\t\t\t\t\t\t CONVERT(DATETIME,'{$tgl_proses}',105),\n\t\t\t\t\t\t\t '{$redistribusi}',\n\t\t\t\t\t\t\t CONVERT(DATETIME,'{$tgl_redistribusi}',105),\n\t\t\t\t\t\t\t '{$keterangan}'\n\t\t\t)\t\t\t\t \t\t\t \n\t\t\t";
     ex_false($conn->execute($query), $query);
     //$query = "
     //UPDATE CS_REGISTER_CUSTOMER_SERVICE SET NOMOR_SPP = '$no_spp'";
     //ex_false($conn->execute($query), $query);
     $msg = "Data SPP berhasil ditambahkan.";
 } elseif ($act == 'Ubah') {
     ex_ha('M18', 'U');
     $query = "\n\t\t\tUPDATE SPP\n\t\t\tSET \n\t\t\t\tNAMA_PEMBELI \t\t= '{$nama}',\n\t\t\t\tTANGGAL_SPP\t\t\t= CONVERT(DATETIME,'{$tgl_spp}',105),\n\t\t\t\tALAMAT_RUMAH \t\t= '{$alamat_rumah}',\n\t\t\t\tALAMAT_SURAT \t\t= '{$alamat_surat}',\n\t\t\t\tALAMAT_NPWP  \t\t= '{$alamat_npwp}',\n\t\t\t\tALAMAT_EMAIL\t \t= '{$email}', \n\t\t\t\tTELP_RUMAH\t\t\t= '{$tlp_rumah}',\n\t\t\t\tTELP_KANTOR\t\t\t= '{$tlp_kantor}',\n\t\t\t\tTELP_LAIN\t\t\t= '{$tlp_lain}',\n\t\t\t\tIDENTITAS\t\t\t= '{$identitas}',\n\t\t\t\tNO_IDENTITAS\t\t= '{$no_identitas}',\n\t\t\t\tNPWP\t\t\t\t= '{$npwp}',\n\t\t\t\tJENIS_NPWP\t\t\t= '{$jenis_npwp}',\n\t\t\t\tKODE_BANK\t\t\t= '{$bank}',\n\t\t\t\tJUMLAH_KPR\t\t\t= '{$jumlah_kpr}',\n\t\t\t\tKODE_AGEN\t\t\t= '{$agen}',\n\t\t\t\tKODE_KOORDINATOR\t= '{$koordinator}',\n\t\t\t\tTANGGAL_AKAD\t\t= CONVERT(DATETIME,'{$tgl_akad}',105),\n\t\t\t\tSTATUS_KOMPENSASI\t= '{$status_kompensasi}',\n\t\t\t\tTANDA_JADI\t\t\t= '{$tanda_jadi}',\n\t\t\t\tTANGGAL_TANDA_JADI\t= CONVERT(DATETIME,'{$tgl_tanda_jadi}',105),\n\t\t\t\tSTATUS_SPP\t\t\t= '{$status_spp}',\n\t\t\t\tTANGGAL_PROSES\t\t= CONVERT(DATETIME,'{$tgl_proses}',105),\n\t\t\t\tSPP_REDISTRIBUSI\t= '{$redistribusi}',\n\t\t\t\tSPP_REDISTRIBUSI_TANGGAL = CONVERT(DATETIME,'{$tgl_redistribusi}',105),\n\t\t\t\tKETERANGAN\t\t\t= '{$keterangan}'\n\t\t\t\t\n\t\t\tWHERE\n\t\t\t\tKODE_BLOK = '{$id}'\n\t\t\t";
     ex_false($conn->execute($query), $query);
     $msg = 'Data SPP berhasil diubah.';
 } elseif ($act == 'Hapus') {
     ex_ha('M18', 'D');
     $act = array();
     $cb_data = $_REQUEST['cb_data'];

开发者ID:rizafr，项目名称:market_ancol，代码行数:31，代码来源:spp_proses.php

示例4: ex_found

     ex_found($conn->Execute($query1)->recordcount(), "Tanggal \"{$tanggal_awal}\" telah terdaftar.");
     if ($tanggal_awal <= $tanggal_akhir) {
         $query = "INSERT INTO CS_HARI_LIBUR (TANGGAL_AWAL, TANGGAL_AKHIR, KETERANGAN)\n\t\t\tVALUES(\n\t\t\t\tCONVERT(DATETIME,'{$tanggal_awal}',105),\n\t\t\t\tCONVERT(DATETIME,'{$tanggal_akhir}',105),\n\t\t\t\t'{$keterangan}'\n\t\t\t)";
         ex_false($conn->execute($query), $query);
         $msg = "Data hari libur berhasil disimpan.";
     } else {
         $msg = "Tanggal awal harus lebih besar dari tanggal akhir.";
     }
 } elseif ($act == 'Ubah') {
     ex_ha('C02', 'U');
     ex_empty($tanggal_awal, 'Tanggal harus diisi.');
     ex_empty($tanggal_akhir, 'Tanggal harus diisi.');
     ex_empty($keterangan, 'Keterangan harus diisi.');
     if ($tanggal_awal != $id) {
         $query = "SELECT TANGGAL_AWAL FROM CS_HARI_LIBUR WHERE TANGGAL_AWAL = CONVERT(DATETIME,'{$tanggal_awal}',105)";
         ex_found($conn->Execute($query)->recordcount(), "Kode \"{$tanggal_awal}\" telah terdaftar.");
     }
     $query = "\n\t\t\tUPDATE CS_HARI_LIBUR \n\t\t\tSET \n\t\t\t\tTANGGAL_AWAL = CONVERT(DATETIME,'{$tanggal_awal}',105),\n\t\t\t\tTANGGAL_AKHIR = CONVERT(DATETIME,'{$tanggal_akhir}',105),\n\t\t\t\tKETERANGAN = '{$keterangan}'\n\t\t\tWHERE\n\t\t\t\tTANGGAL_AWAL = CONVERT(DATETIME,'{$id}',105)\n\t\t\t";
     ex_false($conn->execute($query), $query);
     $msg = 'Data hari libur berhasil diubah.';
 } elseif ($act == 'Hapus') {
     ex_ha('C02', 'D');
     $act = array();
     $cb_data = $_REQUEST['cb_data'];
     ex_empty($cb_data, 'Pilih data yang akan dihapus.');
     foreach ($cb_data as $id_del) {
         $query = "DELETE FROM CS_HARI_LIBUR WHERE TANGGAL_AWAL = CONVERT(DATETIME,'{$id_del}',105)";
         if ($conn->Execute($query)) {
             $act[] = $id_del;
         } else {
             $error = TRUE;

开发者ID:rizafr，项目名称:market_ancol，代码行数:31，代码来源:cs_hari_libur_proses.php

示例5: ex_empty

     ex_empty($no_va, 'nomor_va harus diisi.');
     ex_empty($tanggal, 'tanggal harus diisi.');
     ex_empty($nilai, 'nilai harus diisi.');
     $query = "SELECT NOMOR_VA FROM PEMBAYARAN WHERE NOMOR_VA = '{$no_va}'";
     ex_found($conn->Execute($query)->recordcount(), "Nomor_VA \"{$no_va}\" telah terdaftar.");
     $query = "INSERT INTO PEMBAYARAN (NOMOR_VA, TANGGAL, NILAI, STATUS)\n\t\t\tVALUES(\n\t\t\t\t'{$no_va}',\n\t\t\t\tCONVERT(DATETIME,'{$tanggal}',105),\n\t\t\t\t'{$nilai}','0'\n\t\t\t)";
     ex_false($conn->execute($query), $query);
     $msg = "Data virtual account berhasil disimpan.";
 } elseif ($act == 'Ubah') {
     //ex_ha('COF02', 'U');
     ex_empty($no_va, 'nomor_va harus diisi.');
     ex_empty($tanggal, 'tanggal harus diisi.');
     ex_empty($nilai, 'nilai harus diisi.');
     if ($no_va != $id) {
         $query = "SELECT NOMOR_VA FROM PEMBAYARAN WHERE NOMOR_VA = '{$no_va}'";
         ex_found($conn->Execute($query)->recordcount(), "nomor va \"{$no_va}\" telah terdaftar.");
     }
     $query = "\n\t\t\tUPDATE PEMBAYARAN\n\t\t\tSET \n\t\t\t\tNOMOR_VA = '{$no_va}',\n\t\t\t\tTANGGAL = CONVERT(DATETIME,'{$tanggal}',105),\n\t\t\t\tNILAI = '{$nilai}'\n\t\t\tWHERE\n\t\t\t\tNOMOR_VA = {$no_va}\n\t\t\t";
     ex_false($conn->execute($query), $query);
     $msg = 'Data virtual account berhasil diubah.';
 } elseif ($act == 'Hapus') {
     //ex_ha('COF02', 'D');
     $act = array();
     $cb_data = $_REQUEST['cb_data'];
     ex_empty($cb_data, 'Pilih data yang akan dihapus.');
     foreach ($cb_data as $id_del) {
         $query = "DELETE FROM PEMBAYARAN WHERE NOMOR_VA = '{$id_del}'";
         if ($conn->Execute($query)) {
             $act[] = $id_del;
         } else {
             $error = TRUE;

开发者ID:rizafr，项目名称:market_ancol，代码行数:31，代码来源:virtual_account_proses.php

示例6: ex_found

             ex_found($conn->Execute($query)->fields['TOTAL'], "Nomor ID \"{$id}\" telah terdaftar.");
         }
         if ($nama != $nm) {
             $query = "SELECT COUNT(NAMA) AS TOTAL FROM CLUB_PERSONAL WHERE NAMA = '{$nama}' AND NOMOR_ID != '{$nomor_id}'";
             ex_found($conn->Execute($query)->fields['TOTAL'], "Nama \"{$nama}\" telah terdaftar.");
         }
         $query = "\n\t\t\tUPDATE CLUB_PERSONAL\n\t\t\tSET NOMOR_ID \t\t\t= '{$nomor_id}',\n\t\t\t\tNAMA\t \t\t\t= '{$nama}',\n\t\t\t\tNOMOR_TELEPON\t \t= '{$no_telp}',\n\t\t\t\tEMAIL\t \t\t\t= '{$email}',\n\t\t\t\tNPWP\t \t\t\t= '{$npwp}',\n\t\t\t\tNOMOR_KARTU_IDENTITAS\t \t= '{$nomor_kartu_identitas}',\n\t\t\t\tALAMAT\t\t\t\t= '{$alamat}',\t\n\t\t\t\tJABATAN_KLUB\t\t= '{$jabatan}'\n\t\t\tWHERE\n\t\t\t\tNOMOR_ID = '{$id}'\n\t\t\t";
         ex_false($conn->Execute($query), $query);
         $msg = 'Data Club personal berhasil diubah.';
     } elseif ($act == 'Hapus') {
         $act = array();
         $cb_data = $_REQUEST['cb_data'];
         ex_empty($cb_data, 'Pilih data yang akan dihapus.');
         foreach ($cb_data as $id_del) {
             $querySrc = "SELECT COUNT(KODE_AGEN) AS TOTAL FROM SPP WHERE KODE_AGEN ='{$id_del}'";
             ex_found($conn->Execute($querySrc)->fields['TOTAL'], "Kode Agen \\'{$id_del}\\' telah terdaftar.");
             echo "querySrc";
             $query = "DELETE FROM CLUB_PERSONAL WHERE NOMOR_ID = {$id_del}";
             if ($conn->Execute($query)) {
                 $act[] = $id_del;
             } else {
                 $error = TRUE;
             }
         }
         $msg = $error ? 'Sebagian data gagal dihapus.' : 'Data agen berhasil dihapus.';
     }
     $conn->committrans();
 } catch (Exception $e) {
     $msg = $e->getmessage();
     $error = TRUE;
     if ($conn) {

开发者ID:rizafr，项目名称:market_ancol，代码行数:31，代码来源:agen_proses.php

示例7: ex_login

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    try {
        ex_login();
        ex_app('A01');
        ex_mod('PU05');
        $conn = conn($sess_db);
        ex_conn($conn);
        $conn->begintrans();
        if ($act == 'Edit') {
            ex_ha('PU05', 'U');
            ex_empty($app_id, 'Pilih app.');
            ex_empty($modul_name, 'Modul harus diisi.');
            $ols_modul_name = $conn->Execute("SELECT MODUL_NAME FROM APPLICATION_MODULS WHERE MODUL_ID = '{$id}'")->fields['MODUL_NAME'];
            if ($modul_name != $ols_modul_name) {
                $query = "SELECT COUNT(MODUL_NAME) AS TOTAL FROM APPLICATION_MODULS WHERE MODUL_NAME = '{$modul_name}'";
                ex_found($conn->Execute($query)->fields['TOTAL'], "login id \"{$modul_name}\" telah terdaftar.");
            }
            $query = "\n\t\t\tUPDATE APPLICATION_MODULS \n\t\t\tSET APP_ID = '{$app_id}',\n\t\t\t\tMODUL_NAME = '{$modul_name}'\n\t\t\tWHERE\n\t\t\t\tMODUL_ID = '{$id}'\n\t\t\t";
            ex_false($conn->Execute($query), $query);
            $msg = 'Data modul berhasil diubah.';
        }
        $conn->committrans();
    } catch (Exception $e) {
        $msg = $e->getmessage();
        $error = TRUE;
        if ($conn) {
            $conn->rollbacktrans();
        }
    }
    close($conn);
    $json = array('act' => $act, 'error' => $error, 'msg' => $msg);

开发者ID:rizafr，项目名称:market_ancol，代码行数:31，代码来源:modules_proses.php

示例8: trim

 $no_va_ph = trim($no_va_kiri . $nomor_va_kanan);
 ex_empty($tanggal, 'Tanggal harus diisi.');
 ex_empty($harga_hak, 'Harga harus diisi.');
 ex_empty($biaya, 'Biaya harus diisi.');
 ex_empty($masa_bangun, 'Masa bangun harus diisi.');
 ex_empty($pihak_kedua, 'Nama Pembeli Pihak Kedua harus diisi.');
 ex_empty($no_id_hak, 'No. Identitas Pihak Kedua harus diisi.');
 ex_empty($alamat_hak, 'Alamat Pihak Kedua harus diisi.');
 ex_empty($tlp1_hak, 'No. Telp. Pihak Kedua harus diisi.');
 ex_empty($tlp3_hak, 'No. HP Pihak Kedua harus diisi.');
 ex_empty($email_hak, 'Email Pihak Kedua harus diisi.');
 ex_empty($suami_istri_hak, 'Nama Suami/Istri Pihak Kedua harus diisi.');
 ex_empty($no_fax_hak, 'No. Fax Pihak Kedua harus diisi.');
 //cek no ppjb sudah ada atau tidak
 $query = "SELECT * FROM CS_PENGALIHAN_HAK WHERE NO_PPJB_PH = '{$no_ppjb_hak}'";
 ex_found($conn->Execute($query)->recordcount(), "No. PPJB Pengalihan Hak tidak boleh sama.");
 //masukan data ke tabel cs pengalihan hak
 $query = "\n\t\t\t\tINSERT INTO CS_PENGALIHAN_HAK (KODE_BLOK, NO_VA_PH, NO_PPJB_PH, TANGGAL, \n\t\t\t\tPIHAK_PERTAMA, ALAMAT_PIHAK_PERTAMA, NO_ID_PIHAK_PERTAMA, NO_TELP_PIHAK_PERTAMA, NO_HP_PIHAK_PERTAMA, NO_FAX_PIHAK_PERTAMA, EMAIL_PIHAK_PERTAMA, SUAMI_ISTRI,\n\t\t\t\tPIHAK_KEDUA,NPWP, ALAMAT_PIHAK_KEDUA, NO_ID_PIHAK_KEDUA, NO_TELP_PIHAK_KEDUA, NO_HP_PIHAK_KEDUA, NO_FAX_PIHAK_KEDUA, EMAIL_PIHAK_KEDUA, NAMA_SUAMI_ISTRI, \n\t\t\t\tHARGA_AWAL, NO_PPJB_AWAL, TANGGAL_PPJB_AWAL, TANGGAL_PERMOHONAN, TANGGAL_PERSETUJUAN, BIAYA_PENGALIHAN_HAK, MASA_BANGUN, HARGA_PENGALIHAN_HAK, KETERANGAN)\n\t\t\t\tVALUES ('{$kode}','{$no_va_ph}', 'XXX', CONVERT(DATETIME,'{$tanggal}',105), \n\t\t\t\t'{$pihak_pertama}', '{$alamat}', '{$no_id}', '{$tlp1}', '{$tlp3}', '{$no_fax}', '{$email}', '{$suami_istri}',\n\t\t\t\t'{$pihak_kedua}','{$npwp}', '{$alamat_hak}', '{$no_id_hak}', '{$tlp1_hak}', '{$tlp3_hak}', '{$no_fax_hak}', '{$email_hak}', '{$suami_istri_hak}', \n\t\t\t\t{$harga_awal}, '{$no_ppjb_awal}', CONVERT(DATETIME,'{$tanggal_awal}',105), CONVERT(DATETIME,'{$tanggal_permohonan}',105), CONVERT(DATETIME,'{$tanggal_persetujuan}',105), {$biaya}, '{$masa_bangun}', {$harga_hak}, '{$keterangan}')\n\t\t\t\t";
 ex_false($conn->execute($query), $query);
 //ambil no ppjb berdasarkan kode
 $query = "SELECT NO_PPJB_PH FROM CS_PENGALIHAN_HAK WHERE KODE_BLOK = '{$kode}'";
 $obj = $conn->execute($query);
 $no_ppjb_hak = $obj->fields['NO_PPJB_PH'];
 // simpan ke dalam tabel histori
 $query = "\n\t\t\t\tINSERT INTO CS_HISTORY_PENGALIHAN_HAK\n\t\t\t\t([KODE_BLOK]\n\t\t\t\t,[NO_VA_PH]\n\t\t\t\t,[NO_PPJB_PH]\n\t\t\t\t,[TANGGAL]\n\t\t\t\t,[PIHAK_PERTAMA]\n\t\t\t\t,[ALAMAT_PIHAK_PERTAMA]\n\t\t\t\t,[NO_ID_PIHAK_PERTAMA]\n\t\t\t\t,[NO_TELP_PIHAK_PERTAMA]\n\t\t\t\t,[NO_HP_PIHAK_PERTAMA]\n\t\t\t\t,[NO_FAX_PIHAK_PERTAMA]\n\t\t\t\t,[EMAIL_PIHAK_PERTAMA]\n\t\t\t\t,[SUAMI_ISTRI])\n\t\t\t\tVALUES ('{$kode}','{$no_va_ph}', '{$no_ppjb_hak}', CONVERT(DATETIME,'{$tanggal_sekarang}',105), \n\t\t\t\t'{$pihak_pertama}', '{$alamat}', '{$no_id}', '{$tlp1}', '{$tlp3}', '{$no_fax}', '{$email}', '{$suami_istri}')\n\t\t\t\t";
 ex_false($conn->execute($query), $query);
 //update spp dengan data yang baru
 $query = "\n\t\t\t\tUPDATE SPP SET \n\t\t\t\tNOMOR_CUSTOMER = '{$no_va_ph}',\n\t\t\t\tNAMA_PEMBELI = '{$pihak_kedua}',\n\t\t\t\tALAMAT_RUMAH = '{$alamat_hak}',\n\t\t\t\tALAMAT_SURAT = '{$alamat_hak}',\n\t\t\t\tNO_IDENTITAS = '{$no_id_hak}',\n\t\t\t\tNPWP = '{$npwp}',\n\t\t\t\tTELP_RUMAH = '{$tlp1_hak}',\n\t\t\t\tTELP_KANTOR = '',\n\t\t\t\tTELP_LAIN = '{$tlp3_hak}',\n\t\t\t\tALAMAT_EMAIL = '{$email_hak}',\n\t\t\t\tNAMA_SUAMI_ISTRI = '{$suami_istri_hak}',\n\t\t\t\tNO_FAX = '{$no_fax_hak}'\n\t\t\t\tWHERE KODE_BLOK = '{$kode}'\n\t\t\t\t";
 ex_false($conn->execute($query), $query);
 //update STOK dengan data yang baru
 $query = "\n\t\t\t\tUPDATE STOK SET \n\t\t\t\tNO_VA = '{$no_va_ph}'\n\t\t\t\tWHERE KODE_BLOK = '{$kode}'\n\t\t\t\t";

开发者ID:rizafr，项目名称:market_ancol，代码行数:31，代码来源:pengalihan_hak_histori_proses.php

示例9: isset

         $harga_bangunan = isset($_REQUEST['harga_bangunan_' . $pola_bayar]) ? to_number($_REQUEST['harga_bangunan_' . $pola_bayar]) : 0;
         if ($harga_bangunan == 0 && $harga_tanah == 0) {
             $data->movenext();
             continue;
         }
         $query = "INSERT INTO DETAIL_POLA_BAYAR(KODE_BLOK, KODE_POLA_BAYAR, HARGA_TANAH, HARGA_BANGUNAN) VALUES \n\t\t\t\t(\n\t\t\t\t\t'{$kode_blok}',\n\t\t\t\t\t'{$pola_bayar}',\n\t\t\t\t\t'{$harga_tanah}',\n\t\t\t\t\t'{$harga_bangunan}'\n\t\t\t\t)";
         ex_false($conn->Execute($query), $query);
         $data->movenext();
     }
     $msg = "Detail Pola Bayar berhasil ditambahkan.";
 } elseif ($act == 'Ubah') {
     ex_ha('M09', 'U');
     ex_empty($kode_blok, 'Kode Blok harus diisi');
     if ($sebelumnya != $pola_bayar) {
         $query = "SELECT COUNT(KODE_BLOK) AS TOTAL FROM DETAIL_POLA_BAYAR WHERE KODE_BLOK = '{$kode_blok}' AND KODE_POLA_BAYAR = '{$pola_bayar}'";
         ex_found($conn->Execute($query)->fields['TOTAL'], "Detail Pola Bayar Sudah Terdaftar");
     }
     $query = "UPDATE DETAIL_POLA_BAYAR SET HARGA_TANAH = '{$harga_tanah}', \n\t\t\t\t\t\t\t\tHARGA_BANGUNAN = '{$harga_bangunan}' ,\n\t\t\t\t\t\t\t\tKODE_POLA_BAYAR = '{$pola_bayar}'\n\t\t\t\t\t\t\t\tWHERE KODE_BLOK = '{$kode_blok}' AND KODE_POLA_BAYAR = '{$sebelumnya}'";
     ex_false($conn->Execute($query), $query);
     $msg = 'Detail Pola Bayar berhasil diupdate.';
 } elseif ($act == 'Hapus') {
     $act = array();
     $cb_data = $_REQUEST['cb_data'];
     ex_empty($cb_data, 'Pilih data yang akan dihapus.');
     foreach ($cb_data as $id_del) {
         $id_del = explode(':', $id_del);
         $query = "DELETE FROM DETAIL_POLA_BAYAR WHERE KODE_BLOK = '{$id_del['0']}' AND KODE_POLA_BAYAR ='{$id_del['1']}'  ";
         if ($conn->Execute($query)) {
             $act[] = $id_del;
         } else {
             $error = TRUE;

开发者ID:rizafr，项目名称:market_ancol，代码行数:31，代码来源:detail_pola_pembayaran_proses_.php

示例10: ex_mod

     ex_mod('M29');
     $conn = conn($sess_db);
     ex_conn($conn);
     $conn->begintrans();
     if ($act == 'Reserve') {
         ex_ha('M29', 'I');
         ex_empty($nama_calon_pembeli, 'Nama calon pembeli harus diisi.');
         //ex_empty($tanggal_reserve, 'Tanggal reserve harus diisi.');
         //ex_empty($berlaku_sampai, 'Tanggal berlaku sampai harus diisi.');
         ex_empty($alamat, 'Alamat harus diisi.');
         ex_empty($telepon, 'No Telepon harus diisi.');
         //ex_empty($agen, 'Agen harus diisi.');
         ex_empty($no_ktp, 'Identitas KTP harus diisi.');
         ex_empty($koordinator, 'Koordinator harus diisi.');
         $query = "SELECT COUNT(KODE_BLOK) AS TOTAL FROM RESERVE WHERE KODE_BLOK = '{$id}'";
         ex_found($conn->Execute($query)->fields['TOTAL'], "Kode blok \\'{$id}\\' telah terdaftar.");
         $query = "\n\t\t\tINSERT INTO RESERVE\n\t\t\t(\n\t\t\t\tKODE_BLOK, NAMA_CALON_PEMBELI, TANGGAL_RESERVE, BERLAKU_SAMPAI, \n\t\t\t\tALAMAT, TELEPON, AGEN, KOORDINATOR, NO_IDENTITAS, NPWP\n\t\t\t)\n\t\t\tVALUES\n\t\t\t(\n\t\t\t\t'{$id}', '{$nama_calon_pembeli}', CONVERT(DATETIME,'{$tanggal_reserve}',105), \n\t\t\t\tCONVERT(DATETIME,'{$berlaku_sampai}',105), '{$alamat}', '{$telepon}', '{$agen}', '{$koordinator}', '{$no_ktp}', '{$no_npwp}'\n\t\t\t)\n\t\t\t";
         ex_false($conn->Execute($query), $query);
         $query = "\n\t\t\tUPDATE STOK SET\n\t\t\t\tTERJUAL = '1' \n\t\t\tWHERE \n\t\t\t\tKODE_BLOK = '{$id}'\n\t\t\t";
         ex_false($conn->Execute($query), $query);
         $msg = "Blok \\'{$id}\\' berhasil direserve.";
     }
     $conn->committrans();
 } catch (Exception $e) {
     $msg = $e->getmessage();
     $error = TRUE;
     if ($conn) {
         $conn->rollbacktrans();
     }
 }
 close($conn);

开发者ID:rizafr，项目名称:market_ancol，代码行数:31，代码来源:informasi_persediaan_proses.php

示例11: intval

                 $jumlah = intval($tanda_jadi);
             }
             $keterangan = 'Pembayaran TANDA JADI atas pembelian ' . $bangunan . ' di ' . $lokasi . ' Blok ' . $kode_blok . '(TYPE ' . $tipe . ')' . ' nilai : Rp. ' . to_money($jumlah) . ',-' . ' PPN : Rp. ' . to_money($ppn) . ',-';
             $query = "SELECT COUNT(KODE_BLOK) AS TOTAL FROM KWITANSI_TANDA_TERIMA WHERE KODE_BLOK = '{$kode_blok}' AND STATUS_KWT = '1'";
             $total = $conn->Execute($query)->fields['TOTAL'];
             ex_found($total, "Kwitansi Sudah Ada");
             $query2 = "\n\t\t\t\t\tINSERT INTO KWITANSI (\n\t\t\t\t\t\tKODE_BLOK, NOMOR_KWITANSI, NAMA_PEMBAYAR, TANGGAL, KODE_BAYAR, NILAI, KETERANGAN, NILAI_DIPOSTING, TANGGAL_BAYAR, BAYAR_VIA, CATATAN, PPN, NILAI_NETT, VER_COLLECTION, VER_KEUANGAN, STATUS_KWT, VER_COLLECTION_OFFICER, VER_COLLECTION_TANGGAL, NOMOR_TANDA_TERIMA\n\t\t\t\t\t)\n\t\t\t\t\tVALUES(\n\t\t\t\t\t\t'{$kode_blok}', 'XXX', '{$nama_pembayar}', CONVERT(DATETIME,'{$tanggal}',105), '{$pembayaran}', {$jumlah}, '{$keterangan}', {$jumlah}, CONVERT(DATETIME,'{$tanggal}',105), '{$bank}', '{$catatan}', {$ppn}, {$subtotal}, '1', '0', '0','{$user}', CONVERT(DATETIME,GETDATE(),105), '{$id}'\n\t\t\t\t\t)\n\t\t\t\t";
             ex_false($conn->execute($query2), $query2);
             $query2 = "\n\t\t\t\t\tINSERT INTO FAKTUR_PAJAK (\n\t\t\t\t\t\tKODE_BLOK, NO_KWITANSI, NAMA, ALAMAT_1, NPWP, JENIS, TGL_FAKTUR, KETERANGAN, NILAI, NILAI_DASAR_PENGENAAN, NILAI_PPN\n\t\t\t\t\t)\n\t\t\t\t\tVALUES(\n\t\t\t\t\t\t'{$kode_blok}', 'XXX', '{$nama_pembayar}', '{$alamat_1}', '{$npwp}', '{$jenis}', CONVERT(DATETIME,'{$tanggal}',105), '{$keterangan}', {$jumlah}, {$subtotal}, {$ppn}\n\t\t\t\t\t)\n\t\t\t\t";
             ex_false($conn->execute($query2), $query2);
             $query2 = "\n\t\t\t\t\tUPDATE KWITANSI_TANDA_TERIMA SET STATUS_KWT = '1' WHERE NOMOR_KWITANSI = '{$id}';\n\t\t\t\t";
             ex_false($conn->execute($query2), $query2);
         } else {
             if ($grup == '2') {
                 $total = $conn->Execute("SELECT COUNT(KODE_BLOK) AS TOTAL FROM KWITANSI_LAIN_LAIN WHERE NOMOR_KWITANSI = '{$id}' ")->fields['TOTAL'];
                 ex_found($total, "Kwitansi Sudah Ada");
                 $keterangan = 'Pembayaran ' . $pembayaran . ' atas pembelian ' . $bangunan . ' di ' . $lokasi . ' Blok ' . $kode_blok . ' (TYPE ' . $tipe . ')';
                 $query2 = "\n\t\t\t\tINSERT INTO KWITANSI_LAIN_LAIN (\n\t\t\t\t\tKODE_BLOK, NOMOR_KWITANSI, NAMA_PEMBAYAR, TANGGAL, NILAI, KETERANGAN, KODE_PEMBAYARAN, NILAI_DIPOSTING, TANGGAL_BAYAR, BAYAR_VIA, CATATAN, VER_COLLECTION, VER_KEUANGAN, STATUS_KWT, VER_COLLECTION_OFFICER, VER_COLLECTION_TANGGAL, NOMOR_TANDA_TERIMA\n\t\t\t\t)\n\t\t\t\tVALUES(\n\t\t\t\t\t'{$kode_blok}', 'XXX', '{$nama_pembayar}', CONVERT(DATETIME,'{$tanggal}',105), {$jumlah}, '{$keterangan}', '{$bayar_secara}', {$jumlah}, CONVERT(DATETIME,'{$tanggal}',105), '', '{$catatan}', '1', '0', '0','{$user}', CONVERT(DATETIME,GETDATE(),105), '{$id}'\n\t\t\t\t)\n\t\t\t\t";
                 ex_false($conn->execute($query2), $query2);
                 $query2 = "\n\t\t\t\t\tUPDATE KWITANSI_TANDA_TERIMA SET STATUS_KWT = '1' WHERE NOMOR_KWITANSI = '{$id}';\n\t\t\t\t";
                 ex_false($conn->execute($query2), $query2);
                 $obj->movenext();
             }
         }
         $msg = 'Kwitansi Berhasil dibuat.' . $kata;
     }
     $conn->committrans();
 } catch (Exception $e) {
     $msg = $e->getmessage();
     $error = TRUE;
     if ($conn) {

开发者ID:rizafr，项目名称:market_ancol，代码行数:31，代码来源:tanda_terima_proses_kwitansi.php

示例12: COUNT

         if ($faktor_strategis != $nm) {
             $query = "SELECT COUNT(FAKTOR_STRATEGIS) AS TOTAL FROM FAKTOR WHERE FAKTOR_STRATEGIS = '{$faktor_strategis}'";
             ex_found($conn->Execute($query)->fields['TOTAL'], "Nama faktor strategis \"{$faktor_strategis}\" telah terdaftar.");
         }
         $query = "SELECT * FROM FAKTOR WHERE KODE_FAKTOR = '{$kode_faktor}' AND FAKTOR_STRATEGIS = '{$faktor_strategis}' AND\n\t\t\tNILAI_TAMBAH = '{$nilai_tambah}' AND NILAI_KURANG = '{$nilai_kurang}' AND STATUS = '{$status}'";
         ex_found($conn->Execute($query)->recordcount(), "Tidak ada data yang berubah.");
         $query = "\n\t\t\tUPDATE FAKTOR \n\t\t\tSET KODE_FAKTOR = '{$kode_faktor}',\n\t\t\t\tFAKTOR_STRATEGIS = '{$faktor_strategis}',\n\t\t\t\tNILAI_TAMBAH = '{$nilai_tambah}',\n\t\t\t\tNILAI_KURANG = '{$nilai_kurang}',\n\t\t\t\tSTATUS = '{$status}'\n\t\t\tWHERE\n\t\t\t\tKODE_FAKTOR = '{$id}'\n\t\t\t";
         ex_false($conn->Execute($query), $query);
         $msg = 'Data faktor strategis berhasil diubah.';
     } elseif ($act == 'Hapus') {
         $act = array();
         $cb_data = $_REQUEST['cb_data'];
         ex_empty($cb_data, 'Pilih data yang akan dihapus.');
         foreach ($cb_data as $id_del) {
             $querySrc = "SELECT COUNT(KODE_FAKTOR) AS TOTAL FROM stok WHERE KODE_FAKTOR ='{$id_del}'";
             ex_found($conn->Execute($querySrc)->fields['TOTAL'], "Kode Faktor Strategis \\'{$id_del}\\' telah terdaftar.");
             echo "querySrc";
             $query = "DELETE FROM FAKTOR WHERE KODE_FAKTOR = {$id_del}";
             if ($conn->Execute($query)) {
                 $act[] = $id_del;
             } else {
                 $error = TRUE;
             }
         }
         $msg = $error ? 'Sebagian data gagal dihapus.' : 'Data Faktor Strategis berhasil dihapus.';
     }
     $conn->committrans();
 } catch (Exception $e) {
     $msg = $e->getmessage();
     $error = TRUE;
     if ($conn) {

开发者ID:rizafr，项目名称:market_ancol，代码行数:31，代码来源:faktor_strategis_proses.php

示例13: ex_ha

 if ($act == 'Tambah') {
     ex_ha('JB01', 'I');
     ex_empty($kode_kelurahan, 'Kode harus diisi.');
     ex_empty($nama_kelurahan, 'Nama harus diisi.');
     $query = "SELECT KODE_KELURAHAN FROM KELURAHAN WHERE KODE_KELURAHAN = '{$kode_kelurahan}'";
     ex_found($conn->Execute($query)->recordcount(), "Kode \"{$kode_kelurahan}\" telah terdaftar.");
     $query = "INSERT INTO KELURAHAN (KODE_KELURAHAN, NAMA_KELURAHAN)\n\t\t\tVALUES(\n\t\t\t\t'{$kode_kelurahan}',\n\t\t\t\t'{$nama_kelurahan}'\n\t\t\t)";
     ex_false($conn->execute($query), $query);
     $msg = "Data Kelurahan \"{$nama_kelurahan}\" berhasil disimpan.";
 } elseif ($act == 'Ubah') {
     ex_ha('JB01', 'U');
     ex_empty($kode_kelurahan, 'Kode harus diisi.');
     ex_empty($nama_kelurahan, 'Nama harus diisi.');
     if ($kode_kelurahan != $id) {
         $query = "SELECT KODE_KELURAHAN FROM KELURAHAN WHERE KODE_KELURAHAN = '{$kode_kelurahan}'";
         ex_found($conn->Execute($query)->recordcount(), "Kode \"{$kode_kelurahan}\" telah terdaftar.");
     }
     $query = "\n\t\t\tUPDATE KELURAHAN \n\t\t\tSET \n\t\t\t\tKODE_KELURAHAN = '{$kode_kelurahan}',\n\t\t\t\tNAMA_KELURAHAN = '{$nama_kelurahan}'\n\t\t\tWHERE\n\t\t\t\tKODE_KELURAHAN = '{$id}'\n\t\t\t";
     ex_false($conn->execute($query), $query);
     $msg = 'Data Kelurahan berhasil diubah.';
 } elseif ($act == 'Hapus') {
     ex_ha('JB01', 'D');
     $act = array();
     $cb_data = $_REQUEST['cb_data'];
     ex_empty($cb_data, 'Pilih data yang akan dihapus.');
     foreach ($cb_data as $id_del) {
         $query = "DELETE FROM KELURAHAN WHERE KODE_KELURAHAN = {$id_del}";
         if ($conn->Execute($query)) {
             $act[] = $id_del;
         } else {
             $error = TRUE;

开发者ID:rizafr，项目名称:market_ancol，代码行数:31，代码来源:kelurahan_proses.php

示例14: COUNT

             $query = "SELECT COUNT(KODE_SK) AS TOTAL FROM HARGA_TANAH WHERE KODE_SK = '{$kode_sk}'";
             ex_found($conn->Execute($query)->fields['TOTAL'], "Kode sk \"{$kode_sk}\" telah terdaftar.");
         }
         //
         $query = "SELECT * FROM HARGA_TANAH WHERE KODE_SK = '{$kode_sk}' AND KODE_LOKASI = '{$kode_lokasi}' AND HARGA_TANAH = '{$harga_tanah}' AND TANGGAL = CONVERT(DATETIME,'{$tanggal}',105) AND STATUS = '{$status}'";
         ex_found($conn->Execute($query)->recordcount(), "Tidak ada data yang berubah.");
         $query = "\n\t\t\tUPDATE HARGA_TANAH \n\t\t\tSET KODE_SK = '{$kode_sk}',\n\t\t\t\tKODE_LOKASI = '{$kode_lokasi}',\n\t\t\t\tHARGA_TANAH = '{$harga_tanah}',\n\t\t\t\tTANGGAL = CONVERT(DATETIME,'{$tanggal}',105),\n\t\t\t\tSTATUS = '{$status}'\n\t\t\tWHERE\n\t\t\t\tKODE_SK = '{$id}'\n\t\t\t";
         ex_false($conn->Execute($query), $query);
         $msg = 'Data harga tanah berhasil diubah.';
     } elseif ($act == 'Hapus') {
         $act = array();
         $cb_data = $_REQUEST['cb_data'];
         ex_empty($cb_data, 'Pilih data yang akan dihapus.');
         foreach ($cb_data as $id_del) {
             $querySrc = "SELECT COUNT(KODE_SK_TANAH) AS TOTAL FROM stok WHERE KODE_SK_TANAH ='{$id_del}'";
             ex_found($conn->Execute($querySrc)->fields['TOTAL'], "Harga Tanah \\'{$id_del}\\' telah terdaftar.");
             echo "querySrc";
             $query = "DELETE FROM HARGA_TANAH WHERE KODE_SK = {$id_del}";
             if ($conn->Execute($query)) {
                 $act[] = $id_del;
             } else {
                 $error = TRUE;
             }
         }
         $msg = $error ? 'Sebagian data gagal dihapus.' : 'Data Harga Tanah berhasil dihapus.';
     }
     $conn->committrans();
 } catch (Exception $e) {
     $msg = $e->getmessage();
     $error = TRUE;
     if ($conn) {

开发者ID:rizafr，项目名称:market_ancol，代码行数:31，代码来源:harga_tanah_proses.php

示例15: CONVERT

         }
         $query = "SELECT * FROM HARGA_SK WHERE KODE_SK = '{$kode_sk}' AND kode_blok = '{$kode_blok}' AND HARGA_CASH_KERAS = '{$cash_keras}' AND CB48X = '{$cb48x}' AND CB36X = '{$cb36x}' AND KPA36X = '{$kpa36x}' AND KPA24X = '{$kpa24x}' AND TANGGAL = CONVERT(DATETIME,'{$tanggal}',105) AND STATUS = '{$status}'";
         ex_found($conn->Execute($query)->recordcount(), "Tidak ada data yang berubah.");
         $query = "\n\t\t\tUPDATE HARGA_SK \n\t\t\tSET \n\t\t\t\tHARGA_CASH_KERAS = '{$cash_keras}',\n\t\t\t\tCB12X = '{$cb12x}',\n\t\t\t\tCB24X = '{$cb24x}',\n\t\t\t\tCB36X = '{$cb36x}',\n\t\t\t\tCB48X = '{$cb48x}',\n\t\t\t\tKPA24X = '{$kpa24x}',\n\t\t\t\tKPA36X = '{$kpa36x}',\n\t\t\t\tTANGGAL = CONVERT(DATETIME,'{$tanggal}',105),\n\t\t\t\tSTATUS = '{$status}'\n\t\t\tWHERE\n\t\t\t\tKODE_SK = '{$id}' \n\t\t\t\tAND KODE_BLOK = '{$kode_blok}'\n\t\t\t";
         ex_false($conn->Execute($query), $query);
         $msg = 'Data harga sk berhasil diubah.';
     } elseif ($act == 'Hapus') {
         $act = array();
         // $cb_data = $_REQUEST['cb_data'];
         // ex_empty($cb_data, 'Pilih data yang akan dihapus.');
         foreach ($cb_data as $id_del) {
             list($x, $y) = explode("X", $id_del);
             $kode_sk = $x;
             $kode_blok = $y;
             $querySrc = "SELECT COUNT(KODE_SK) AS TOTAL FROM stok WHERE KODE_SK ='{$kode_sk}' AND KODE_BLOK='{$kode_blok}'";
             ex_found($conn->Execute($querySrc)->fields['TOTAL'], "Kode SK \\'{$kode_sk}\\' dengan blok \\'{$kode_blok}\\' telah terdaftar di stok.");
             echo "querySrc";
             $query = "DELETE FROM HARGA_SK WHERE KODE_SK = '{$kode_sk}' AND KODE_BLOK='{$kode_blok}'";
             if ($conn->Execute($query)) {
                 $act[] = $kode_sk;
             } else {
                 $error = TRUE;
             }
         }
         $msg = $error ? 'Sebagian data gagal dihapus.' : 'Data harga sk berhasil dihapus.';
     }
     $conn->committrans();
 } catch (Exception $e) {
     $msg = $e->getmessage();
     $error = TRUE;
     if ($conn) {

开发者ID:rizafr，项目名称:market_ancol，代码行数:31，代码来源:harga_bangunan_proses.php

注：本文中的ex_found函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP ex_ha函数代码示例发布时间：2022-05-15

PHP ex_false函数代码示例发布时间：2022-05-15

CVE-2015-3207

1 C#Matlab混合编程类初始化问题解决方法

************** 异常文本 **************System.TypeInitializationException:“myP

阅读：554|2022-07-18

2 bradtraversy/iweather: Ionic 3 mobile we

bradtraversy/iweather: Ionic 3 mobile weather app

阅读：1648|2022-08-30

3 joaomh/curso-de-matlab

joaomh/curso-de-matlab

阅读：1208|2022-08-17

4 断牙刷新位置时间（断牙属性及刷新位置介绍

魔兽世界怀旧服已经开启两个多月了，但作为一个猎人玩家，抓到“断牙”，已经成为了一

阅读：1064|2022-11-06

5 rugk/mastodon-simplified-federation: Sim

rugk/mastodon-simplified-federation: Simplifies following and interacting with r

阅读：1131|2022-08-17

6 delphiParallel之TTask初试

unitUnit1;interfaceusesWinapi.Windows,Winapi.Messages,System.SysUtils,System.Var

阅读：575|2022-07-18

7 Tangshitao/Dense-Scene-Matching: Learnin

Tangshitao/Dense-Scene-Matching: Learning Camera Localization via Dense Scene Ma

阅读：818|2022-08-16

8 肉的笔顺,议论肉的笔画,解说肉的部首

肉的笔顺怎么写?肉字笔顺笔画顺序是什么?中国练字网了解到好多人在学习中会遇到肉的笔

阅读：1502|2022-07-30

9 ProtonVPN/linux-cli: Official ProtonVPN

ProtonVPN/linux-cli: Official ProtonVPN Linux app (CLI)

阅读：994|2022-08-15

10 Respring是什么意思?没有越狱设备如何 Resp

相信不少果粉在对自己的设备进行某些操作时，都会碰到Respring，但这个 Respring 到底

阅读：388|2022-11-06

客服电话

电子邮件

PHP ex_found函数代码示例

示例1: ex_false

示例2: ex_false

示例3: ex_mod

示例4: ex_found

示例5: ex_empty

示例6: ex_found

示例7: ex_login

示例8: trim

示例9: isset

示例10: ex_mod

示例11: intval

示例12: COUNT

示例13: ex_ha

示例14: COUNT

示例15: CONVERT

请发表评论

全部评论

上一篇：

下一篇：

CVE-2022-33173

bradtraversy/iweather: Ionic 3 mobile we

Ramotion/android-ui-animation-components

一个小时快速搭建微信小程序教程

joaomh/curso-de-matlab

CVE-2015-3207

librespeed/speedtest: Self-hosted Speedt

AndroidDeveloperLB/MaterialPreferenceLib

avehtari/BDA_m_demos: Bayesian Data Anal

四维彩超怎么看性别？四维看男孩女孩诀窍

medfreeman/markdown-it-toc-and-anchor: m

关于我们

产品与服务

解决方案

139-2527-9053