示例#1
0
						$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';
示例#2
0
            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';
示例#3
0
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;
}
示例#4
0
                #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,
示例#5
0
							<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'];
示例#7
0
            } 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,
示例#8
0
								// $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);
示例#9
0
                    $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;
示例#10
0
            } 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,
示例#11
0
            $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'));
示例#12
0
								}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) -----------------------------------------------------------------------------------------
示例#13
0
					$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']).'",
示例#14
0
 $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();
示例#15
0
				}
				#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';
示例#16
0
							$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 -- //
	// ---------------------- //
?>
示例#17
0
											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 . ',
示例#19
0
							<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);