// die_mod(''); $conn = conn($sess_db); die_conn($conn); $conn->begintrans(); $error = false; if ($act == 'Apply') { ex_empty($kode_pola_bayar, 'Pola Bayar harus diisi.'); $query = "DELETE FROM RENCANA WHERE KODE_BLOK = '{$id}'"; ex_false($conn->execute($query), $query); $query = "SELECT KODE_POLA, NAMA_POLA_BAYAR FROM POLA_BAYAR WHERE KODE_POLA_BAYAR = '{$kode_pola_bayar}'"; $obj = $conn->execute($query); $pola_bayar = $obj->fields['KODE_POLA']; $nama_pola = $obj->fields['NAMA_POLA_BAYAR']; //proses pengambilan harga sk yang dipilih sesuai pola bayar $query = "SELECT count(KODE_BLOK) as TOTAL FROM HARGA_SK WHERE KODE_SK=(SELECT KODE_SK FROM STOK WHERE KODE_BLOK = '{$id}') AND KODE_BLOK='{$id}'"; ex_not_found($conn->Execute($query)->fields['TOTAL'], "Pola Bayar Tidak Tersedia"); $query = "SELECT ({$pola_bayar}) as HARGA FROM HARGA_SK WHERE KODE_SK = (SELECT KODE_SK FROM STOK WHERE KODE_BLOK = '{$id}') AND KODE_BLOK = '{$id}'"; $obj = $conn->execute($query); $harga_pemesanan = $obj->fields['HARGA']; $harga_total = $harga_pemesanan - $tanda_jadi; //update harga total yang dipalkai pada tabel spp $query = "UPDATE SPP SET \n\t\t\t\t\t\t\tHARGA_TOTAL\t= {$harga_total},\n\t\t\t\t\t\t\tPOLA_BAYAR\t= '{$nama_pola}'\n\t\t\t\t\t\t WHERE KODE_BLOK\t\t= '{$id}'\n\t\t\t\t\t\t "; ex_false($conn->execute($query), 'Update Pola bayar terlebih dahulu'); // ex_false($conn->execute($query), $query); //proses penghitungan rencana (angsuran) /*$b = date("d-m-Y"); $pecah_tgl_skrg = explode("-",$b); $tgl_skrg = $pecah_tgl_skrg[0]; $bln_skrg = $pecah_tgl_skrg[1]; $thn_skrg = $pecah_tgl_skrg[2];
<script type="text/javascript"> <?php require_once '../../../../config/config.php'; $id = isset($_REQUEST['id']) ? clean($_REQUEST['id']) : ''; $msg = ''; $error = FALSE; $conn = conn($sess_db); ex_conn($conn); try { $obj = $conn->Execute("\tSELECT count(*) as TOTAL FROM STOK WHERE KODE_BLOK = '{$id}'"); ex_not_found($obj->fields['TOTAL'], 'Kode Blok Tidak Terdaftar'); } catch (Exception $e) { $msg = $e->getmessage(); $error = TRUE; if ($conn) { $conn->rollbacktrans(); } } $query = "SELECT * FROM DETAIL_POLA_BAYAR WHERE KODE_BLOK = '{$id}'"; $harga = $conn->Execute($query); ?> jQuery(function($) { <?php if ($error) { echo "alert('Data Kode Blok tidak tersedia');"; echo "jQuery('.harga').val('');"; echo "jQuery('#kode_blok').val('');"; } while (!$harga->EOF) {