$ss2 = 'DELETE FROM '.$tb3.' WHERE replid IN ('.$_POST['idDelTR'].')'; $ee2 = mysql_query($ss2); $stat22 = !$ee2?false:true; // var_dump($ee2);exit(); } // 2.b simpan detail aktivitas (wajib) $stat2 =$stat2 = true; $nomDebit = $nomKredit = 0; $totNominal=0; if(!$stat22) $stat='gagal_delete_detail_aktivitas'; // ada hapus detail aktivitas AND gagal else{ // tidak ada hapus detail aktivitas OR sukses hapus $xx=''; foreach ($itemArr as $i => $v) { $biaya = isset($_POST['biaya_'.$v.'TB'])?'biaya='.getuang($_POST['biaya_'.$v.'TB']).',':''; $jumlah = isset($_POST['jumlah_'.$v.'TB'])?'jumlah='.getuang($_POST['jumlah_'.$v.'TB']).',':''; $item = isset($_POST['item_'.$v.'TB'])?'item="'.getuang($_POST['item_'.$v.'TB']).'"':''; $s = $tb3.' SET aktivitas='.$id.', '.$biaya.' '.$jumlah.' '.$item.' '; if($_POST['mode'.$v.'H']=='edit') $s2 = 'UPDATE '.$s.' WHERE replid='.$_POST['iditem_'.$v.'H']; //edit else $s2 ='INSERT INTO '.$s; // add $xx.=$s2; $e2 = mysql_query($s2); $stat2 =!$e2?false:true; } if(!$stat2) $stat = 'gagal_simpan_detail_aktivitas'; else $stat = 'sukses';
break; // view ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- // view ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- case 'simpan': $s = $tb . ' set katmodulpembayaran = "' . $_POST['katmodulpembayaranTB'] . '", angkatan = "' . $_POST['angkatanH'] . '", nama = "' . filter($_POST['namaTB']) . '", rek1 = "' . filter($_POST['rek1H']) . '", rek2 = "' . filter($_POST['rek2H']) . '", rek3 = "' . filter($_POST['rek3H']) . '", nominal = "' . getuang($_POST['nominalTB']) . '", cicilan = "' . getuang($_POST['cicilanTB']) . '", diskon = "' . getuang($_POST['diskonTB']) . '", biayaadmin = "' . getuang($_POST['biayaadminTB']) . '", keterangan = "' . filter($_POST['keteranganTB']) . '"'; $s2 = isset($_POST['replid']) ? 'UPDATE ' . $s . ' WHERE replid=' . $_POST['replid'] : 'INSERT INTO ' . $s; $e = mysql_query($s2); $stat = $e ? 'sukses' : 'gagal_' . print_r($s2); $out = json_encode(array('status' => $stat)); break; // add / edit ----------------------------------------------------------------- // delete ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- // delete ----------------------------------------------------------------- case 'hapus': $d = mysql_fetch_assoc(mysql_query('SELECT * from ' . $tb . ' where replid=' . $_POST['replid'])); $s = 'DELETE from ' . $tb . ' WHERE replid=' . $_POST['replid']; $e = mysql_query($s); $stat = $e ? 'sukses' : 'gagal';
function getDiscAngsuran($regNum, $disc) { $regNum = getuang($regNum); $discPerc = intval(getField('diskon', 'psb_angsuran', 'replid', $disc)); $discNum = $regNum * $discPerc / 100; // var_dump($discNum);exit(); return $discNum; }
#kosong $out .= '<tr align="center"> <td colspan=9><span style="color:red;text-align:center;"> ... data tidak ditemukan...</span></td></tr>'; } #link paging $out .= '<tr class="info"><td colspan="9">' . $obj->anchors . '</td></tr>'; $out .= '<tr class="info"><td colspan="9">' . $obj->total . '</td></tr>'; break; // view ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- // view ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- case 'simpan': $s = $tb . ' set nominal = "' . getuang(filter($_POST['nominalTB'])) . '", nominal2 = "' . getuang(filter($_POST['nominalTB'])) . '"'; $s2 = isset($_POST['replid']) ? 'UPDATE ' . $s . ' WHERE replid=' . $_POST['replid'] : 'INSERT INTO ' . $s; // print_r($s2);exit(); $e = mysql_query($s2); $stat = $e ? 'sukses' : 'gagal'; $out = json_encode(array('status' => $stat)); break; // add / edit ----------------------------------------------------------------- // ambiledit ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- // ambiledit ----------------------------------------------------------------- case 'ambiledit': $s = 'SELECT tb.nama tahunbuku, kr.nama kategorirekening, r.kode,
<td colspan=9 ><span style="color:red;text-align:center;"> ... data tidak ditemukan...</span></td></tr>'; } #link paging $out .= '<tr class="info"><td colspan=9>' . $obj->anchors . '</td></tr>'; $out .= '<tr class="info"><td colspan=9>' . $obj->total . '</td></tr>'; break; // tampil --------------------------------------------------------------------- // add / edit ----------------------------------------------------------------- // tampil --------------------------------------------------------------------- // add / edit ----------------------------------------------------------------- case 'simpan': // $ditagih = getField('ditagih','vw_siswa_biaya','idsiswabiaya',$_POST['idsiswabiayaTB']); $idkww = intval(getField('max(idkwitansi)', $tb, '', '')); $idkw = $idkww == '' ? 1 : $idkww + 1; $nominal = getuang($_POST['akanBayarJenisTB'] == '1' ? $_POST['akanBayarNominalTB1'] : $_POST['akanBayarNominalTB2']); // semester = '.($ditagih=='12'||$ditagih=='2'?$_POST['semesterH']:'').', // bulan = '.($ditagih=='12'||$ditagih=='2'?$_POST['bulanH']:'').', $s = 'INSERT INTO ' . $tb . ' set siswabiaya = ' . $_POST['idsiswabiayaTB'] . ', nominal = ' . $nominal . ', viabayar2 = ' . $_POST['viaBayarTB'] . ', tanggal = "' . tgl_indo6($_POST['tanggalTB']) . '", idkwitansi = ' . $idkw; // pr($s); $e = mysql_query($s); $idPenerimaanSiswa = mysql_insert_id(); if (!$e) { $stat = 'gagal_insert_pembayaran'; } else { // 2. simpan transaksi
... data tidak ditemukan...</span></td></tr>'; } #link paging $out .= '<tr class="info"><td colspan=9>' . $obj->anchors . '</td></tr>'; $out .= '<tr class="info"><td colspan=9>' . $obj->total . '</td></tr>'; break; // view ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- // view ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- case 'simpan': $stat2 = true; foreach ($_POST['golongan'] as $i => $v) { $s = 'UPDATE ' . $tb . ' set tuition = ' . filter(getuang($_POST['tuitionTB_' . $v])) . ', material = ' . filter(getuang($_POST['materialTB_' . $v])) . ', registration = ' . filter(getuang($_POST['registrationTB_' . $v])) . ' WHERE replid = ' . $v; // print_r($s);exit(); $e = mysql_query($s); $stat2 = $e ? true : false; } $stat = $stat2 ? 'sukses' : 'gagal'; $out = json_encode(array('status' => $stat)); break; // add / edit ----------------------------------------------------------------- // delete ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- // delete ----------------------------------------------------------------- case 'hapus': $d = mysql_fetch_assoc(mysql_query('SELECT * from ' . $tb . ' where replid=' . $_POST['replid'])); $s = 'DELETE from ' . $tb . ' WHERE replid=' . $_POST['replid'];
} else { #kosong $out .= '<tr align="center"> <td colspan=9><span style="color:red;text-align:center;"> ... data tidak ditemukan...</span></td></tr>'; } #link paging $out .= '<tr class="info"><td colspan="9">' . $obj->anchors . '</td></tr>'; $out .= '<tr class="info"><td colspan="9">' . $obj->total . '</td></tr>'; break; // view ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- // view ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- case 'simpan': $s = ' UPDATE ' . $tb . ' set nominal = ' . getuang(filter($_POST['nominalTB'])) . ' WHERE replid =' . $_POST['replid']; // pr($s); $e = mysql_query($s); $stat = $e ? 'sukses' : 'gagal'; $out = json_encode(array('status' => $stat)); break; // ambiledit ----------------------------------------------------------------- // ambiledit ----------------------------------------------------------------- case 'ambiledit': $s = 'SELECT t.tahunajaran, kr.nama kategorirekening, r.kode, r.nama, kr.jenis,
// $s2 = 'keu_jurnal set transaksi = '.$id.', // rek = '.$_POST['ju_rekTB'].', // debet = '.$_POST['ju_debetTB'].', // kredit = '.$_POST['ju_kreditTB']; // $s2 = isset($_POST['replid'])?'UPDATE '.$s.' WHERE replid='.$_POST['replid']:'INSERT INTO '.$s; } // } // $stat = ($e)?'sukses':'gagal'; // $out = json_encode(array('status'=>$stat)); break; case 'barang': $s = $tb4.' set katalog = "'.$_POST['b_katalogH2'].'", tempat = "'.$_POST['b_tempatTB'].'", sumber = "'.$_POST['b_sumberTB'].'", harga = "'.getuang($_POST['b_hargaTB']).'", kondisi = "'.$_POST['b_kondisiTB'].'", keterangan = "'.filter($_POST['b_keteranganTB']).'"'; $stat = true; if(!isset($_POST['replid'])){ //add if(isset($_POST['b_jumbarangTB']) and $_POST['b_jumbarangTB']>1){ // lebih dr 1 unit barang for($i=0; $i<($_POST['b_jumbarangTB']); $i++) { // iterasi sbnyak jum barang $s2 ='INSERT INTO '.$s.', urut='.($_POST['b_urutH']+$i); // var_dump($s2);exit(); $e = mysql_query($s2); if(!$e)$stat=false; } }else{ // 1 unit barang $s2='INSERT INTO '.$s.', urut='.$_POST['b_urutH']; // var_dump($s2);exit(); $e=mysql_query($s2);
$ss2 = 'DELETE FROM ' . $tb2 . ' WHERE replid IN (' . $_POST['idDelTR'] . ')'; $ee2 = mysql_query($ss2); $stat22 = !$ee2 ? false : true; } // 2.b simpan detail aktivitas (wajib) $stat2 = $stat2 = true; $nomDebit = $nomKredit = 0; if (!$stat22) { $stat = 'gagal_delete_detail_aktivitas'; } else { // tidak ada hapus detail aktivitas OR sukses hapus $xx = ''; foreach ($itemArr as $i => $v) { $item = getuang($_POST['item_' . $v . 'TB']); $jumlah = $_POST['jumlah_' . $v . 'TB']; $biaya = isset($_POST['biaya_' . $v . 'TB']) ? 'biaya=' . getuang($_POST['biaya_' . $v . 'TB']) . ',' : ''; $tglbayar = isset($_POST['tglbayar_' . $v . 'TB']) ? tgl_indo6($_POST['tglbayar_' . $v . 'TB']) : '0000-00-00'; $tgllunas = isset($_POST['tgllunas_' . $v . 'TB']) ? tgl_indo6($_POST['tgllunas_' . $v . 'TB']) : '0000-00-00'; $s = $tb3 . ' SET aktivitas=' . $id . ', ' . $biaya . ' jumlah =' . $jumlah . ', tglbayar ="' . $tglbayar . '", tgllunas ="' . $tgllunas . '"'; if ($_POST['mode' . $v . 'H'] == 'edit') { //edit $s2 = 'UPDATE ' . $s . ' WHERE replid=' . $_POST['iditem_' . $v . 'H']; } else { // add $s2 = 'INSERT INTO ' . $s; } $xx .= $s2;
} else { #kosong $out .= '<tr align="center"> <td colspan=9><span style="color:red;text-align:center;"> ... data tidak ditemukan...</span></td></tr>'; } #link paging $out .= '<tr class="info"><td colspan="9">' . $obj->anchors . '</td></tr>'; $out .= '<tr class="info"><td colspan="9">' . $obj->total . '</td></tr>'; break; // view ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- // view ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- case 'simpan': $s = $tb . ' set nominal = "' . getuang(filter($_POST['nominalTB'])) . '"'; $s2 = isset($_POST['replid']) ? 'UPDATE ' . $s . ' WHERE replid=' . $_POST['replid'] : 'INSERT INTO ' . $s; $e = mysql_query($s2); $stat = $e ? 'sukses' : 'gagal'; $out = json_encode(array('status' => $stat)); break; // add / edit ----------------------------------------------------------------- // ambiledit ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- // ambiledit ----------------------------------------------------------------- case 'ambiledit': $s = 'SELECT da.nama, CONCAT(dr.kode," - ",dr.nama) rekening, `at`.nominal, tb.nama tahunbuku,
$out .= '<tr class="info"><td colspan=9>' . $obj->anchors . '</td></tr>'; $out .= '<tr class="info"><td colspan=9>' . $obj->total . '</td></tr>'; break; // tampil --------------------------------------------------------------------- // tampil --------------------------------------------------------------------- case 'headerInfo': $s = 'SELECT getAnggaranPerKategori(' . $_POST['kategorianggaran'] . ',' . $_POST['tahunajaran'] . ') anggaranKuotaPerKategori'; $e = mysql_query($s); $r = mysql_fetch_assoc($e); $out = json_encode(array('status' => !$e ? 'gagal' : 'sukses', 'anggaranKuotaPerKategori' => setuang($r['anggaranKuotaPerKategori']))); break; // add / edit ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- case 'simpan': // simpan anggaran tahunan ----- $s = ' UPDATE ' . $tb . ' set hargasatuan = ' . getuang($_POST['hargasatuanTB']) . ' WHERE replid=' . $_POST['replid']; $e = mysql_query($s); // nominal anggaran ---- if ($e && isset($_POST['idnominalH'])) { $stat2 = true; foreach ($_POST['idnominalH'] as $i => $v) { $s2 = 'UPDATE keu_nominalanggaran SET jml =' . $_POST['jml' . $v . 'TB'] . ', bulan =' . $v . ' WHERE anggarantahunan =' . $_POST['replid'] . ' AND bulan =' . $v; $e2 = mysql_query($s2); $stat2 = !$e2 ? false : true; } $stat = !$stat2 ? 'gagal_nominal' : 'sukses'; } $out = json_encode(array('status' => !$e || !$stat2 ? 'gagal' : 'sukses'));
}else{ // siswa - ibu ----------------------------------------------------------------------------------------- $siswaibuF = array( 'siswa'=>isset($siswaSV['id'])?$siswaSV['id']:null, 'namaibu', 'tempatlahiribu', 'tanggallahiribu'=>($_POST['tanggallahiribuTB']!=''?tgl_indo6($_POST['tanggallahiribuTB']):'0000-00-00'), 'agamaibu', 'warganegaraibu', 'kodeposibu', 'kotaibu', 'pendidikanibu', 'bidangpekerjaanibu', 'pekerjaanibu', 'posisiibu', 'penghasilanibu'=>getuang($_POST['penghasilanibuTB']), 'telponibu', 'pinbbibu', 'emailibu', 'alamatibu', 'hpibu', 'faxrumahibu', 'alamatkantoribu', 'telponkantoribu', 'faxkantoribu', 'gerejaibu', );$siswaibuSV=(isset($_POST['idformTB']) && !empty($_POST['idformTB']))?editRecord($siswaibuF,$tb3,'siswa',$_POST['idformTB']):addRecord($siswaibuF,$tb3); if(!$siswaibuSV['isSukses']){ $stat='gagal_insert_siswa_ibu'; }else{ // siswa - walimurid (optional) -----------------------------------------------------------------------------------------
$disc = getDiscAngsuran($_POST['regNum'],$_POST['discAngsuran']); $o = array( 'status' =>(($disc!=null || $disc!='')?'sukses':'gagal'), 'discNum' =>$disc ); }$out = json_encode($o); break; // add / edit ----------------------------------------------------------------- case 'simpan': $siswa = $tb.' set kriteria = "'.filter($_POST['kriteriaTB']).'", proses = "'.filter($_POST['prosesTB']).'", golongan = "'.filter($_POST['golonganTB']).'", kelompok = "'.filter($_POST['kelompokTB']).'", discsubsidi = "'.getuang(filter($_POST['discsubsidiTB'])).'", discsaudara = "'.getuang(filter($_POST['discsaudaraTB'])).'", disctunai = "'.filter($_POST['disctunaiTB']).'", setbiaya = "'.filter($_POST['setbiayaTB']).'", angsuran = "'.filter($_POST['angsuranTB']).'", nopendaftaran = "'.filter($_POST['nopendaftaranH']).'", nama = "'.filter($_POST['namaTB']).'", kelamin = "'.filter($_POST['jkTB']).'", tmplahir = "'.filter($_POST['tempatlahirTB']).'", '.(($_POST['tgllahiranakTB']=='' || $_POST['tgllahiranakTB']=='00 0000')?'':'tgllahir ="'.tgl_indo6(filter($_POST['tgllahiranakTB'])).'",').' agama = "'.filter($_POST['agamaTB']).'", alamat = "'.filter($_POST['alamatsiswaTB']).'", telpon = "'.filter($_POST['telpsiswaTB']).'", sekolahasal = "'.filter($_POST['asalsekolahTB']).'", darah = "'.($_POST['goldarahTB']==''?filter($_POST['goldarahTB']):'-').'", kesehatan = "'.filter($_POST['penyakitTB']).'",
$stat2 = true; $nomDebit = $nomKredit = 0; foreach ($_POST[$sub . '_rekH'] as $i => $v) { if ($_POST[$sub . '_jenis' . $v . 'TB'] == 'debit') { // kredit $nom = intval(getuang($_POST[$sub . '_nominal' . $v . 'TB'])); if ($nom != '0') { $nominal += $nom; } $nom = intval(getuang($_POST[$sub . '_nominal' . $v . 'TB'])); $nomDebit += $nom; $s2 = 'INSERT INTO keu_jurnal SET transaksi =' . $id . ', rek =' . $_POST[$sub . '_rek' . $v . 'H'] . ', debet =' . $nom; $e2 = mysql_query($s2); } else { // kredit $nom = intval(getuang($_POST[$sub . '_nominal' . $v . 'TB'])); $nomKredit += $nom; $s2 = 'INSERT INTO keu_jurnal SET transaksi =' . $id . ', rek =' . $_POST[$sub . '_rek' . $v . 'H'] . ', kredit =' . $nom; $e2 = mysql_query($s2); } } if (!$stat2) { $stat = 'gagal_insert_jurnal'; } else { // 3. update saldo rekening if ($sub != 'ju') { // selain jurnal umum if ($nominal != '0') { $s5 = 'UPDATE keu_saldorekening SET nominal2 =nominal2 ' . getOperator($_POST['rekkasH']) . ' ' . $nominal . ' WHERE rekening =' . $_POST['rekkasH'] . ' AND tahunbuku=' . getTahunBuku('replid'); $s6 = 'UPDATE keu_saldorekening SET nominal2 =nominal2 ' . getOperator($_POST['rekitemH']) . ' ' . $nominal . ' WHERE rekening =' . $_POST['rekitemH'] . ' AND tahunbuku=' . getTahunBuku('replid'); // var_dump($s6);exit();
} #link paging $out.= '<tr class="info"><td colspan=9>'.$obj->anchors.'</td></tr>'; $out.='<tr class="info"><td colspan=9>'.$obj->total.'</td></tr>'; break; // view ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- case 'simpan': // print_r($_POST['biaya']);exit(); $stat2= true; foreach ($_POST['golongan'] as $i => $v) { $s = 'UPDATE '.$tb.' set daftar = '.filter(getuang($_POST['daftarTB_'.$i])).', spp = '.filter(getuang($_POST['sppTB_'.$i])).', joiningf = '.filter(getuang($_POST['joiningfTB_'.$i])).', nilai = '.filter(getuang($_POST['dppTB_'.$i])).' WHERE replid = '.$v; // print_r($s);exit(); $e = mysql_query($s); $stat2 = $e?true:false; }$stat = $stat2?'sukses':'gagal'; $out = json_encode(array('status'=>$stat)); break; // add / edit ----------------------------------------------------------------- // delete ----------------------------------------------------------------- case 'hapus': $d = mysql_fetch_assoc(mysql_query('SELECT * from '.$tb.' where replid='.$_POST['replid'])); $s = 'DELETE from '.$tb.' WHERE replid='.$_POST['replid']; $e = mysql_query($s); $stat = ($e)?'sukses':'gagal';
$out.='<td align="right">'.(!isAksi('detailbiaya','u')?setuang($r2['nominal']):'<div class="input-control text" ><input data-hint="'.$r2['biaya'].'" class="text-right" value="Rp. '.number_format($r2['nominal']).'" onclick="inputuang(this);" onfocus="inputuang(this);" type="text" name="nominalTB['.$r2['replid'].']"></div>').'</td>'; } $out.='</tr>'; $nox++; } } // vd($sss); break; // view ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- case 'simpan': $stat2= true; foreach ($_POST['nominalTB'] as $i => $v) { $s = 'UPDATE '.$tb.' set nominal = '.filter(getuang($v)).' WHERE replid ='.$i; $e = mysql_query($s); $stat2 = $e?true:false; }$stat = $stat2?'sukses':'gagal'; $out = json_encode(array('status'=>$stat)); break; // add / edit ----------------------------------------------------------------- } }echo $out; // ---------------------- // // -- created by epiii -- // // ---------------------- // ?>
detjenistransaksi =' . $_POST['detjenistransaksiTB'] . ', anggarantahunan =' . $_POST[$sub . '_detilanggaran' . $v . 'H'] . ', departemen =' . $_POST[$sub . '_departemen' . $v . 'TB'] . ', tingkat =' . $_POST[$sub . '_tingkat' . $v . 'TB'] . ', type ="' . ($_POST['nobuktiCB'] == '1' ? 'sar' : '') . '", nobukti ="' . $_POST['nobuktiTB'] . '"'; // pr($s); $e = mysql_query($s); $idTransaksi = mysql_insert_id(); $transArr[] = $idTransaksi; // 2. simpan jurnal umum if (!$e) { $stat1 = false; } else { // jurnal debit & kredit $nom = getuang($_POST[$sub . '_nominal' . $v . 'TB']); $sjd = ' INSERT INTO keu_jurnal SET detilrekening =' . $_POST['rekkasH'] . ', nominal =' . $nom . ', jenisrekening ="k", transaksi =' . $idTransaksi; $sjk = 'INSERT INTO keu_jurnal SET detilrekening =' . $_POST[$sub . '_rek' . $v . 'H'] . ', nominal =' . $nom . ', jenisrekening ="d", transaksi =' . $idTransaksi; $ejd = mysql_query($sjk); $ejk = mysql_query($sjd); $stat2 = (!$ejd and !$ejk) ? false : true; } }
break; } break; // head info ------------------------------------------------------------------ // add / edit ----------------------------------------------------------------- // head info ------------------------------------------------------------------ // add / edit ----------------------------------------------------------------- case 'simpan': // 1. simpan pembayaran if ($_POST['subaksi'] == 'dpp') { // dpp $nominal = $_POST['akanbayarTB'] * getAngsurNom($_POST['subaksi'], $_POST['idsiswaH']); $detjenistrans = 'in_siswa'; } elseif ($_POST['subaksi'] == 'joiningf') { //joining fee $nominal = getuang($_POST['akanbayar2TB']); $detjenistrans = 'in_calonsiswa'; } else { // spp , formulir $nominal = getBiaya($_POST['subaksi'], $_POST['idsiswaH']); // pendaftaran & spp if ($_POST['subaksi'] == 'spp') { // spp $detjenistrans = 'in_siswa'; } else { // formulir $detjenistrans = 'in_calonsiswa'; } } $s = 'INSERT INTO ' . $tb . ' set modul = ' . $_POST['idmodulH'] . ', cicilan = ' . $nominal . ',
<td colspan=9 ><span style="color:red;text-align:center;"> ... data tidak ditemukan...</span></td></tr>'; } #link paging $out .= '<tr class="info"><td colspan=9>' . $obj->anchors . '</td></tr>'; $out .= '<tr class="info"><td colspan=9>' . $obj->total . '</td></tr>'; break; // view ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- // view ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- case 'simpan': $itemArr = $_POST['idTR']; $stat2 = true; foreach ($itemArr as $i => $v) { $s = 'UPDATE ' . $tb3 . ' SET biaya2=' . getuang($_POST['biaya2_' . $v . 'TB']) . ' WHERE replid=' . $_POST['iditem_' . $v . 'H']; $e = mysql_query($s); $stat2 = !$e ? false : true; } // var_dump($xx);exit(); $stat = !$stat2 ? 'gagal_simpan_detail_aktivitas' : 'sukses'; $out = json_encode(array('status' => $stat)); break; // add / edit ----------------------------------------------------------------- // delete ----------------------------------------------------------------- // add / edit ----------------------------------------------------------------- // delete ----------------------------------------------------------------- case 'hapus': $d = mysql_fetch_assoc(mysql_query('SELECT * from ' . $tb . ' where replid=' . $_POST['replid'])); $s = 'DELETE from ' . $tb . ' WHERE replid=' . $_POST['replid']; $e = mysql_query($s);