Example #1
0
              <td >Kode Pos </td>
              <td colspan="2">: '.(empty($r2['kodeposayah'])?'-':$r2['kodeposayah']).'</td>
            </tr><tr>
              <td colspan="3">&nbsp;</td>
            </tr>';

            // bioadata ibu
            $r3=getField('*',$tb3,'siswa',$replid);
            $out.='<tr class="head">
              <td colspan="3">Biodata Ibu</td>
            </tr><tr>
              <td >Nama</td>
              <td colspan="2">: '.(empty($r3['namaibu'])?'-':$r3['namaibu']).'</td>
            </tr><tr>
              <td>Tempat / Tanggal Lahir</td>
              <td colspan="2">: '.(empty($r3['tempatlahiribu'])?'-':$r3['tempatlahiribu']).' / '.tgl_indo5((empty($r3['tempatlahiribu'])?'-':$r3['tempatlahiribu'])).'</td>
            </tr><tr>
              <td >Warga Negara</td>
              <td colspan="2">: '.(empty($r3['warganegaraibu'])?'-':$r3['warganegaraibu']).'</td>
            </tr><tr>
              <td >Agama</td>
              <td colspan="2">: '.(empty($r3['agamaibu'])?'-':getField('agama','psb_agama','replid',$r3['agamaibu'])).'</td>
            </tr><tr>
              <td >Gereja</td>
              <td colspan="2">: '.(empty($r3['gerejaibu'])?'-':$r3['gerejaibu']).'</td>
            </tr><tr>
              <td >HP </td>
              <td colspan="2">: '.(empty($r3['hpibu'])?'-':$r3['hpibu']).'</td>
            </tr><tr>
              <td >Telpon</td>
              <td colspan="2">: '.(empty($r3['telponibu'])?'-':$r3['telponibu']).'</td>
Example #2
0
					$e2  = mysql_query($s2);
					while($r2 = mysql_fetch_assoc($e2)){
						$itemArr[]=array(
							'iditem'    =>$r2['replid'],
							'item'      =>$r2['item'],
							'jumlah'    =>$r2['jumlah'],
							'biayaSat'  =>intval($r2['biaya']),
							'biayaTot'  =>(intval($r2['biaya']) * intval($r2['jumlah'])),
						);
						$biayaSatSum+=intval($r2['biaya']);
						$biayaTotSum+=(intval($r2['biaya']) * intval($r2['jumlah']));
					}
				 	$stat = ($e2)?'sukses':'gagal_ambil_detail_aktivitas';
				}$out  = json_encode(array(
							'status'          =>$stat,
							'lokasi'          =>$r['lokasi'],
							'tanggal1'        =>tgl_indo5($r['tanggal1']),
							'tanggal2'        =>tgl_indo5($r['tanggal2']),
							'tgltagihan'      =>tgl_indo5($r['tgltagihan']),
							'aktivitas'       =>$r['aktivitas'],
							'keterangan'      =>$r['keterangan'],
							'iddetilanggaran' =>$r['iddetilanggaran'],
							'detilanggaran'   =>$r['detilanggaran'].' [sisa : '.setuang($r['anggaranSisa']).', kuota : '.setuang($r['anggaranKuota']).']',
							'sisaNum'         =>setuang($r['anggaranSisa']),
							'itemArr'         =>$itemArr
						));
			break;
			// ambiledit -----------------------------------------------------------------
		}
	}echo $out;
?>
								dg.departemen,
								dg.tglmulai,
								dg.tglselesai
							from '.$tb.' dg 
								JOIN psb_gelombang g on g.replid = dg.gelombang
							WHERE dg.replid='.$_POST['replid'];
				$e 		= mysql_query($s);
				$r 		= mysql_fetch_assoc($e);
				$stat 	= ($e)?'sukses':'gagal';
				$out 	= json_encode(array(
							'status'      =>$stat,
							'gelombang'   =>$r['gelombang'],
							'departemen'  =>$r['departemen'],
							'tahunajaran' =>$r['tahunajaran'],
							'tglmulai'    =>($r['tglmulai']=='0000-00-00'?'-':tgl_indo5($r['tglmulai'])),
							'tglselesai'  =>($r['tglselesai']=='0000-00-00'?'-':tgl_indo5($r['tglselesai'])),
						));
			break;
			// ambiledit -----------------------------------------------------------------

			// cmbdetailgelombang -----------------------------------------------------------------
			case 'cmb'.$mnu:
				$w='';
				if(isset($_POST['replid'])){
					$w='where replid ='.$_POST['replid'];
				}else{
					if(isset($_POST['tahunajaran']) && isset($_POST['departemen'])){
						$w='where 	tahunajaran ='.$_POST['tahunajaran'].' AND
									departemen  ='.$_POST['departemen'];
					}
				}
Example #4
0
								l.nama as lokasi
							from ' . $tb . ' a, sar_lokasi l 
							WHERE 
								a.lokasi= l.replid and
								a.replid=' . $_POST['replid'];
            // var_dump($s);exit();
            $e = mysql_query($s);
            $r = mysql_fetch_assoc($e);
            $itemArr = array();
            $biayaSatSum = $biayaTotSum = $biayaTotSum2 = 0;
            if (!$e) {
                $stat = $e ? 'sukses' : 'gagal_ambil_data_aktivitas';
            } else {
                $s2 = 'SELECT * FROM ' . $tb3 . ' WHERE aktivitas =' . $_POST['replid'];
                $e2 = mysql_query($s2);
                while ($r2 = mysql_fetch_assoc($e2)) {
                    $itemArr[] = array('iditem' => $r2['replid'], 'item' => $r2['item'], 'jumlah' => $r2['jumlah'], 'biayaSat' => intval($r2['biaya']), 'biayaTot' => intval($r2['biaya']) * intval($r2['jumlah']));
                    $biayaSatSum += intval($r2['biaya']);
                    $biayaTotSum += intval($r2['biaya']) * intval($r2['jumlah']);
                }
                $stat = $e2 ? 'sukses' : 'gagal_ambil_detail_aktivitas';
            }
            $out = json_encode(array('status' => $stat, 'lokasi' => $r['lokasi'], 'tanggal1' => tgl_indo5($r['tanggal1']), 'tanggal2' => tgl_indo5($r['tanggal2']), 'tgltagihan' => tgl_indo5($r['tgltagihan']), 'aktivitas' => $r['aktivitas'], 'keterangan' => $r['keterangan'], 'itemArr' => $itemArr));
            break;
            // ambiledit -----------------------------------------------------------------
    }
}
echo $out;
// ---------------------- //
// -- created by rovi  -- //
// ---------------------- //
Example #5
0
function getTglTrans($siswa, $typ)
{
    $s = 'SELECT
				t.replid,
				max(t.tanggal)tgl
			FROM
				keu_transaksi t
				LEFT JOIN keu_pembayaran p ON p.replid = t.pembayaran
				LEFT JOIN keu_modulpembayaran m ON m.replid = p.modul
				LEFT JOIN keu_katmodulpembayaran k ON k.replid = m.katmodulpembayaran
			WHERE
				p.siswa = ' . $siswa . ' and (
				k.nama = "' . $typ . '"
			)';
    $e = mysql_query($s);
    $r = mysql_fetch_assoc($e);
    $tgl = $r['tgl'] != NULL ? tgl_indo5($r['tgl']) : '-';
    return $tgl;
}
Example #6
0
         $kredit = 0;
     } else {
         if ($jenis == 'out') {
             // outcome
             $debit = $r2['rekkas'] == $r2['rek'] ? 0 : $r2['nominal'];
             $kredit = $r2['rekitem'] == $r2['rek'] ? 0 : $r2['nominal'];
         } else {
             // income
             $debit = $r2['rekkas'] == $r2['rek'] ? $r2['nominal'] : 0;
             $kredit = $r2['rekitem'] == $r2['rek'] ? $r2['nominal'] : 0;
         }
     }
     $debitTot += $debit;
     $kreditTot += $kredit;
     $out .= '<tr >
     <td>' . tgl_indo5($r2['tanggal']) . '</td>
     <td>' . $r2['nomer'] . '</td>
     <td>' . $r2['uraian'] . '</td>
     <td align="right">Rp. ' . number_format($debit) . '</td>
     <td align="right">Rp. ' . number_format($kredit) . '</td>
   </tr>';
 }
 $out .= '</tbody>
         <tfoot>
           <tr class="head">
             <th align="right" colspan="3">Jumlah</th>
             <th align="right">Rp. ' . number_format($debitTot) . '</th>
             <th align="right">Rp. ' . number_format($kreditTot) . '</th>
           </tr>
           <tr class="head">
             <th align="right" colspan="3">Selisih</th>
Example #7
0
               AND j.jenisrekening ="k" 
               AND t.tanggal BETWEEN "' . tgl_indo6($_GET['tgl1']) . '"
               AND "' . tgl_indo6($_GET['tgl2']) . '"
             ORDER BY
               t.tanggal ASC';
 $e3 = mysql_query($s3);
 $keluarTot = 0;
 if (mysql_num_rows($e3) <= 0) {
     $out .= '<tr>
               <td colspan="4" align="center">data kosong</td>
             </tr>';
 } else {
     while ($r3 = mysql_fetch_assoc($e3)) {
         $keluarTot += $r3['nominal'];
         $out .= '<tr>
                 <td width="10%">' . tgl_indo5($r3['tanggal']) . '</td>
                 <td  width="20%">' . getNoKwitansi($r3['idTransaksi']) . '</td>
                 <td  width="30%">' . $r3['uraian'] . '</td>
                 <td align="right" width="20%">' . setuang($r3['nominal']) . '</td>
               </tr>';
     }
 }
 $out .= '</tbody>
                       <tfoot>
                         <tr class="info fg-white">
                           <th colspan="3" align="right">Jumlah : </th>
                           <th align="right">' . setuang($keluarTot) . '</th>
                         </tr>
                       </tfoot>
                   </table>';
 $saldoAkhir = $r['nominal'] + $masukTot - $keluarTot;
Example #8
0
				$recpage = 10;//jumlah data per halaman
				$aksi    ='tampil';
				$subaksi ='';
				$obj     = new pagination_class($sql,$starting,$recpage,$aksi, $subaksi);
				$result  =$obj->result;

				#ada data
				$jum	= mysql_num_rows($result);
				$out ='';
				if($jum!=0){	
					while($res = mysql_fetch_assoc($result)){	
						$tingNama  = getKriteriaSiswa('tingkat',$res['idsiswa']);
						$stingNama = getKriteriaSiswa('subtingkat',$res['idsiswa']);
						$out.= '<tr>
									<td align="center">'.tgl_indo5($res['tanggallahiribu']).'</td>
									<td align="center">'.$res['namaibu'].'</td>
									<td align="center">'.$res['namasiswa'].'</td>
									<td align="center">'.$tingNama.'-'.$stingNama.' </td>
									<td align="center">'.$res['alamatibu'].'</td>
									<td align="center">'.$res['emailibu'].'</td>
								</tr>';
					}
				}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>';
Example #9
0
            if ($jum != 0) {
                $nox = $starting + 1;
                while ($res = mysql_fetch_assoc($result)) {
                    // <button data-hint="detail"  class="button" onclick="viewFR('.$res['replid'].');">
                    // 	<i class="icon-zoom-in"></i>
                    // </button>
                    $btn = '<td>
									<button data-hint="ubah"  class="button" onclick="viewFR(' . $res['replid'] . ');">
										<i class="icon-pencil on-left"></i>
									</button>
									<button data-hint="hapus"  class="button" onclick="del(' . $res['replid'] . ');">
										<i class="icon-remove on-left"></i>
									</button>
								 </td>';
                    $out .= '<tr>
									<td class="text-center">' . tgl_indo5($res['tanggal1']) . ' - ' . tgl_indo5($res['tanggal2']) . '</td>
									<td>' . $res['aktivitas'] . '</td>
									<td>' . $res['aktivitas'] . '</td>
									<td>' . $res['aktivitas'] . '</td>
									<td><pre>' . $res['keterangan'] . '</pre></td>
									' . $btn . '
								</tr>';
                    $nox++;
                }
            } else {
                #kosong
                $out .= '<tr align="center">
							<td  colspan=9 ><span style="color:red;text-align:center;">
							... data tidak ditemukan...</span></td></tr>';
            }
            #link paging
                    // 			<button '.(isAksi($mnu,'u')?'onclick="viewFR('.$res['replid'].');"':'disabled').' data-hint="ubah"  >
                    // 				<i class="icon-pencil"></i>
                    // 			</button>
                    $btn = '
						<td align="center">
									<button ' . (isAksi($mnu, 'd') ? 'onclick="del(' . $res['replid'] . ');"' : 'disabled') . ' data-hint="hapus" >
										<i class="icon-remove"></i>
									</button>
								 </td>';
                    $out .= '<tr>
									<td>' . tgl_indo5($res['tgl']) . '</td>
									<td>' . $res['nis'] . '</td>
									<td>' . $res['namasiswa'] . '</td>
									<td>-</td>
									<td>' . $res['nomom'] . '</td>
									<td>' . tgl_indo5($res['tglmom']) . '</td>
									<td align="right">' . setuang($res['biayaKurangTot']) . '</td>
									' . $btn . '
								</tr>';
                    // <td>'.getTotalPemutihan($res['replid']).'</td>
                    $nox++;
                }
            } 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>';
Example #11
0
							'posisiayah'             =>$r['posisiayah'],
							'penghasilanayah'        =>$r['penghasilanayah'],
							'telponayah'             =>$r['telponayah'],
							'emailayah'              =>$r['emailayah'],
							'pinbbayah'              =>$r['pinbbayah'],
							'alamatayah'             =>$r['alamatayah'],
							'hpayah'                 =>$r['hpayah'],
							'faxrumahayah'           =>$r['faxrumahayah'],
							'alamatkantorayah'       =>$r['alamatkantorayah'],
							'telponkantorayah'       =>$r['telponkantorayah'],
							'faxkantorayah'          =>$r['faxkantorayah'],
							'gerejaayah'             =>$r['gerejaayah'],
							/*siswa ibu*/
							'namaibu'                =>$r['namaibu'],
							'tempatlahiribu'         =>$r['tempatlahiribu'],
							'tanggallahiribu'        =>tgl_indo5($r['tanggallahiribu']),
							'agamaibu'               =>$r['agamaibu'],
							'warganegaraibu'         =>$r['warganegaraibu'],
							'kodeposibu'             =>$r['kodeposibu'],
							'kotaibu'                =>$r['kotaibu'],
							'pendidikanibu'          =>$r['pendidikanibu'],
							'bidangpekerjaanibu'     =>$r['bidangpekerjaanibu'],
							'pekerjaanibu'           =>$r['pekerjaanibu'],
							'posisiibu'              =>$r['posisiibu'],
							'penghasilanibu'         =>$r['penghasilanibu'],
							'telponibu'              =>$r['telponibu'],
							'emailibu'               =>$r['emailibu'],
							'pinbbibu'               =>$r['pinbbibu'],
							'alamatibu'              =>$r['alamatibu'],
							'hpibu'                  =>$r['hpibu'],
							'faxrumahibu'            =>$r['faxrumahibu'],
Example #12
0
							'kesehatan'      =>$r['kesehatan'],
							'ketkesehatan'   =>$r['ketkesehatan'],
						// ayah 
							'namaAyah'       =>$r['namaAyah'],
							'kebangsaanAyah' =>$r['kebangsaanAyah'],
							'tmplahirAyah'   =>$r['tmplahirAyah'],
							'tgllahirAyah'   =>tgl_indo5($r['tgllahirAyah']),
							'pekerjaanAyah'  =>$r['pekerjaanAyah'],
							'telponAyah'     =>$r['telponAyah'],
							'pinbbAyah'      =>$r['pinbbAyah'],
							'emailAyah'      =>$r['emailAyah'],
						// ibu
							'namaIbu'        =>$r['namaIbu'],
							'kebangsaanIbu'  =>$r['kebangsaanIbu'],
							'tmplahirIbu'    =>$r['tmplahirIbu'],
							'tgllahirIbu'    =>tgl_indo5($r['tgllahirIbu']),
							'pekerjaanIbu'   =>$r['pekerjaanIbu'],
							'telponIbu'      =>$r['telponIbu'],
							'pinbbIbu'       =>$r['pinbbIbu'],
							'emailIbu'       =>$r['emailIbu'],
						/*kakek nenek*/
							'namaKakek'      =>$r['namaKakek'],
							'namaNenek'      =>$r['namaNenek'],
						/*darurat*/
							'namaDarurat'    =>$r['namaDarurat'],
							'hubungan'       =>$r['hubungan'],
							'telponDarurat'  =>$r['telponDarurat'],
						));
			break;
			// ambiledit -----------------------------------------------------------------
			
Example #13
0
        $out = json_encode(array('status' => 'invalid_no_post'));
    }
} else {
    switch ($_POST['aksi']) {
        // history bayar
        case 'histBayar':
            $s = 'SELECT p.replid, p.tanggal,p.nominal,p.idkwitansi
					 FROM ' . $tb . ' p 
					 WHERE p.siswabiaya = ' . $_POST['siswabiaya'] . '
					 ORDER BY p.tanggal ASC,p.replid ASC';
            $e = mysql_query($s);
            $arr = array();
            $totNominal = 0;
            $angsuranKe = 1;
            while ($r = mysql_fetch_assoc($e)) {
                $arr[] = array('replid' => $r['replid'], 'angsuranKe' => $angsuranKe, 'nominal' => setuang($r['nominal']), 'tanggal' => tgl_indo5($r['tanggal']), 'idkwitansi' => $r['idkwitansi']);
                $totNominal += $r['nominal'];
                $angsuranKe++;
            }
            $out = json_encode(array('status' => $e ? 'sukses' : 'gagal', 'datax' => $arr, 'totNominal' => setuang($totNominal)));
            break;
            // tampil ---------------------------------------------------------------------
        // tampil ---------------------------------------------------------------------
        case 'tampil':
            $departemen = isset($_POST['departemenS']) ? filter($_POST['departemenS']) : '';
            $tahunajaran = isset($_POST['tahunajaranS']) ? filter($_POST['tahunajaranS']) : '';
            $subtingkat = isset($_POST['subtingkatS']) ? filter($_POST['subtingkatS']) : '';
            $biaya = isset($_POST['biayaS']) ? filter($_POST['biayaS']) : '';
            // opsional
            $semester = isset($_POST['semesterS']) && $_POST['semesterS'] != '' && $_POST['semesterS'] != 'null' ? ' AND idsemester =' . filter($_POST['semesterS']) : '';
            $bulan = isset($_POST['bulanS']) && $_POST['bulanS'] != '' && $_POST['bulanS'] != 'null' ? ' AND idsemester =' . filter($_POST['bulanS']) : '';
Example #14
0
							'posisiayah'             =>$r['posisiayah'],
							'penghasilanayah'        =>setuang($r['penghasilanayah']),
							'telponayah'             =>$r['telponayah'],
							'emailayah'              =>$r['emailayah'],
							'pinbbayah'              =>$r['pinbbayah'],
							'alamatayah'             =>$r['alamatayah'],
							'hpayah'                 =>$r['hpayah'],
							'faxrumahayah'           =>$r['faxrumahayah'],
							'alamatkantorayah'       =>$r['alamatkantorayah'],
							'telponkantorayah'       =>$r['telponkantorayah'],
							'faxkantorayah'          =>$r['faxkantorayah'],
							'gerejaayah'             =>$r['gerejaayah'],
							//ibu
							'namaibu'                =>$r['namaibu'],
							'tempatlahiribu'         =>$r['tempatlahiribu'],
							'tanggallahiribu'      =>$r['tanggallahiribu']=='0000-00-00'?'':tgl_indo5($r['tanggallahiribu']),
							'agamaibu'               =>$r['agamaibu'],
							'warganegaraibu'         =>$r['warganegaraibu'],
							'kodeposibu'             =>$r['kodeposibu'],
							'kotaibu'                =>$r['kotaibu'],
							'pendidikanibu'          =>$r['pendidikanibu'],
							'bidangpekerjaanibu'     =>$r['bidangpekerjaanibu'],
							'pekerjaanibu'           =>$r['pekerjaanibu'],
							'posisiibu'              =>$r['posisiibu'],
							'penghasilanibu'         =>setuang($r['penghasilanibu']),
							'telponibu'              =>$r['telponibu'],
							'emailibu'               =>$r['emailibu'],
							'pinbbibu'               =>$r['pinbbibu'],
							'alamatibu'              =>$r['alamatibu'],
							'hpibu'                  =>$r['hpibu'],
							'faxrumahibu'            =>$r['faxrumahibu'],
Example #15
0
        case 'ambiledit':
            $s = ' SELECT 
								t.tahunajaran,
								t.tglmulai,
								t.tglakhir,
								t.keterangan,
								d.replid as id_departemen,
								d.nama as departemen
							from ' . $tb . ' t, departemen d 
							WHERE 
								t.departemen= d.replid and
								t.replid=' . $_POST['replid'];
            $e = mysql_query($s);
            $r = mysql_fetch_assoc($e);
            $stat = $e ? 'sukses' : 'gagal';
            $out = json_encode(array('status' => $stat, 'tahunajaran' => $r['tahunajaran'], 'tglmulai' => tgl_indo5($r['tglmulai']), 'tglakhir' => tgl_indo5($r['tglakhir']), 'keterangan' => $r['keterangan'], 'id_departemen' => $r['id_departemen'], 'departemen' => $r['departemen']));
            break;
            // ambiledit -----------------------------------------------------------------
            // aktifkan -----------------------------------------------------------------
        // ambiledit -----------------------------------------------------------------
        // aktifkan -----------------------------------------------------------------
        case 'aktifkan':
            $e1 = mysql_query('UPDATE  ' . $tb . ' set aktif="0" where departemen = ' . $_POST['departemen']);
            if (!$e1) {
                $stat = 'gagal menonaktifkan';
            } else {
                $s2 = 'UPDATE  ' . $tb . ' set aktif="1" where replid = ' . $_POST['replid'];
                $e2 = mysql_query($s2);
                if (!$e2) {
                    $stat = 'gagal mengaktifkan';
                } else {
Example #16
0
                    </td>
                  </tr>
                </table><br />';
          // start of header
          $out.='<table width="100%">
                    <tr>
                      <td width="20%" >Kode Transaksi </td>
                      <td>: '.$r1['nomer'].'</td>
                    </tr>
                    <tr>
                      <td>No. Bukti</td>
                      <td>: '.$r1['nobukti'].'</td>
                    </tr>
                    <tr>
                      <td>Tanggal</td>
                      <td>: '.tgl_indo5($r1['tanggal']).'</td>
                    </tr>
                    <tr>
                      <td>Uraian</td>
                      <td>: '.$r1['uraian'].'</td>
                    </tr>';
            if($jenisTrans=='pengeluaran'){
              $out.='<tr>
                      <td>Anggaran</td>
                      <td>: '.getAnggaran($r1['detilanggaran']).'</td>
                    </tr>';
            }$out.='</table>';
            // end of header

            // start of detail table
            $out.='<table class="isi" width="100%">
Example #17
0
        case 'ambiledit':
            $s = ' SELECT
						s.replid,
						s.semester,
						s.tglMulai,
						s.tglSelesai,
						concat(t.tahunajaran," - ",(t.tahunajaran+1))tahunajaran
					FROM
						aka_semester s
						LEFT JOIN aka_tahunajaran t ON t.replid = s.tahunajaran
					WHERE s.replid=' . $_POST['replid'];
            // var_dump($s);exit();
            $e = mysql_query($s);
            $r = mysql_fetch_assoc($e);
            $stat = $e ? 'sukses' : 'gagal';
            $out = json_encode(array('status' => $stat, 'tahunajaran' => $r['tahunajaran'], 'semester' => $r['semester'], 'tglMulai' => $r['tglMulai'] == '0000-00-00' ? '' : tgl_indo5($r['tglMulai']), 'tglSelesai' => $r['tglSelesai'] == '0000-00-00' ? '' : tgl_indo5($r['tglSelesai'])));
            break;
            // ambiledit -----------------------------------------------------------------
            // cmbsemester -----------------------------------------------------------------
        // ambiledit -----------------------------------------------------------------
        // cmbsemester -----------------------------------------------------------------
        case 'cmbsemester':
            if (isset($_POST['replid'])) {
                $w = 'where replid =' . $_POST['replid'];
            } else {
                if (isset($_POST[$mnu])) {
                    $w = 'where ' . $mnu . '=' . $_POST[$mnu];
                } elseif (isset($_POST['tahunajaran'])) {
                    $w = 'where tahunajaran =' . $_POST['tahunajaran'];
                } else {
                    $w = '';
                FROM keu_penerimaansiswa p 
                WHERE p.siswabiaya = ' . $idsiswabiaya . '
                ORDER BY p.tanggal ASC, p.replid ASC';
     $e2 = mysql_query($s2);
     $n2 = mysql_num_rows($e2);
     $arr = array();
     $totNominal = 0;
     $angsuranKe = 0;
     if ($n2 == 0) {
         $out .= '<tr><td align="center" colspan="3">Kosong</td></tr>';
     } else {
         while ($r2 = mysql_fetch_assoc($e2)) {
             $angsuranKe++;
             $out .= '<tr style="background-color:lightGrey;">
                   <td align="center">' . $angsuranKe . ' </td>
                   <td align="center">' . tgl_indo5($r2['tanggal']) . ' </td>
                   <td align="right">' . setuang($r2['nominal']) . ' </td>
                 </tr>';
             $totNominal += $r2['nominal'];
         }
     }
     $out .= '<tr class="head">
               <td colspan="2" align="center">Total Terbayar </td>
               <td style="background-color:lightBlue;" align="right">' . setuang($totNominal) . '</td>
             </tr><tr>
               <td>* Total Kurangan </td>
               <td>: </td>
               <td style="background-color:lightBlue;" align="right">' . setuang(intval($r['biayaNett']) - $totNominal) . '</td>
             </tr>';
 }
 $out .= '<tr>
Example #19
0
                         <td width="20%">Debit</td>
                         <td width="20%">Kredit</td>
                       </tr>';
             while ($r2 = mysql_fetch_assoc($e2)) {
                 $debit = $r2['jenisrekening'] == 'd' ? setuang($r2['nominal']) : '-';
                 $kredit = $r2['jenisrekening'] == 'k' ? setuang($r2['nominal']) : '-';
                 $tb2 .= '<tr>
                         <td width="60%">' . getRekening($r2['detilrekening']) . '</td>
                         <td width="20%" align="right">' . $debit . '</td>
                         <td width="20%" align="right">' . $kredit . '</td>
                       </tr>';
             }
             $tb2 .= '</table>';
         }
         $out .= '<tr>
                 <td width="12%" valign="top">' . tgl_indo5($r['tanggal']) . '</td>
                 <td  width="18%" valign="top" style="font-weight:bold;">' . getNoKwitansi($r['replid']) . '<br>' . $r['nobukti'] . '</td>
                 <td  width="15%" valign="top">' . $r['uraian'] . '</td>
                 <td width="55%">' . $tb2 . '</td>
               </tr>';
     }
 } else {
     #kosong
     $out .= '<tr align="center">
             <td  colspan=9 ><span style="color:red;text-align:center;">
             ... data tidak ditemukan...</span></td></tr>';
 }
 $out .= '</table>
       </body>';
 echo $out;
 #generate html -> PDF ------------
Example #20
0
            $stat = $e ? 'sukses' : 'gagal';
            $out = json_encode(array('status' => $stat, 'terhapus' => $d[$mnu]));
            break;
            // delete -----------------------------------------------------------------
            // ambiledit -----------------------------------------------------------------
        // delete -----------------------------------------------------------------
        // ambiledit -----------------------------------------------------------------
        case 'ambiledit':
            $s = ' SELECT *
							from ' . $tb . '
							WHERE 
								replid=' . $_POST['replid'];
            $e = mysql_query($s);
            $r = mysql_fetch_assoc($e);
            $stat = $e ? 'sukses' : 'gagal';
            $out = json_encode(array('status' => $stat, 'tahunajaran' => $r['tahunajaran'], 'departemen' => $r['departemen'], 'kelompok' => $r['kelompok'], 'tglmulai' => tgl_indo5($r['tglmulai']), 'tglselesai' => tgl_indo5($r['tglselesai']), 'keterangan' => $r['keterangan']));
            break;
            // ambiledit -----------------------------------------------------------------
            // aktifkan -----------------------------------------------------------------
        // ambiledit -----------------------------------------------------------------
        // aktifkan -----------------------------------------------------------------
        case 'aktifkan':
            $e1 = mysql_query('UPDATE  ' . $tb . ' set aktif="0" where departemen = ' . $_POST['departemen']);
            if (!$e1) {
                $stat = 'gagal menonaktifkan';
            } else {
                $s2 = 'UPDATE  ' . $tb . ' set aktif="1" where replid = ' . $_POST['replid'];
                $e2 = mysql_query($s2);
                if (!$e2) {
                    $stat = 'gagal mengaktifkan';
                } else {
									m.rek3,	
									m.nama modul,
									m.replid idmodul
								FROM
									keu_modulpembayaran m
									LEFT JOIN keu_katmodulpembayaran k ON k.replid = m.katmodulpembayaran
									LEFT JOIN keu_pembayaran p ON p.modul = m.replid
								WHERE
									m.angkatan = ' . $ang . ' AND 
									k.nama = "spp"';
                    // var_dump($s2);exit();
                    $e2 = mysql_query($s2);
                    // var_dump($s2);exit();
                    $r2 = mysql_fetch_assoc($e2);
                    $stat = $e2 ? 'sukses' : 'gagal';
                    $out = json_encode(array('status' => $stat, 'datax' => array('nis' => getSiswaBy('nis', $sis), 'idsiswa' => $sis, 'siswa' => getSiswaBy('nama', $sis), 'nomer' => getNoTrans($_POST['subaksi']), 'tanggal' => tgl_indo5(date('Y-m-d')), 'rekkas' => $r2['rek1'], 'rekitem' => $r2['rek2'], 'rek1' => getRekening($r2['rek1']), 'rek2' => getRekening($r2['rek2']), 'rek3' => getRekening($r2['rek3']), 'modul' => $r2['modul'], 'idmodul' => $r2['idmodul'], 'status' => getStatusBayar('spp', $_POST['replid']), 'nominal' => 'Rp. ' . number_format(getBiaya('spp', $sis)))));
                    break;
            }
            break;
            // ambiledit ------------------------------------------------------------------
            // generate barcode -----------------------------------------------------------
        // ambiledit ------------------------------------------------------------------
        // generate barcode -----------------------------------------------------------
        case 'kodegenerate':
            $s = 'SELECT
						tb1.lokasi,
						tb1.grup,
						tb1.tempat,
						tb1.katalog,
						tb2.barang,
						LPAD(tb2.barang,5,0)barkode	
Example #22
0
							-- LEFT JOIN aka_tingkat t ON t.replid = c.tingkat
					 WHERE 
						c.replid=' . $_POST['replid'];
            $e = mysql_query($s) or die(mysql_error());
            $r = mysql_fetch_assoc($e);
            // print_r($r);exit();
            $stat = $e ? 'sukses' : 'gagal';
            $regNum = setuang(getBiaya('registration', $_POST['replid']));
            $regNumNet = setuang(getBiayaNet('registration', $_POST['replid']));
            $nopendaftaran = getNoPendaftaran($_POST['replid'], $r['kelompok'])['akhir'];
            // $tingkat   	   = getField('tingkat','psb_calonsiswa','replid',$r['tingkat']);
            $tahunajaran = getField('tahunajaran', 'psb_kelompok', 'replid', $r['kelompok']);
            $discangsuran = setuang(getDiscAngsuran($regNum, $r['angsuran']));
            $disctunai = setuang(getDisc('disctunai', $_POST['replid']));
            // var_dump($tingkat);exit();
            $out = json_encode(array('status' => $stat, 'setbiaya' => $r['setbiaya'], 'registration' => $regNum, 'angsuran' => $r['angsuran'], 'discangsuran' => $discangsuran, 'discsubsidi' => setuang($r['discsubsidi']), 'discsaudara' => setuang($r['discsaudara']), 'iddisctunai' => $r['disctunai'], 'disctunai' => $disctunai, 'disctotal' => setuang(getDiscTotal($_POST['replid'])), 'registrationnet' => $regNumNet, 'material' => setuang($r['material']), 'tuition' => setuang($r['tuition']), 'nopendaftaranH' => $r['nopendaftaran'], 'nopendaftaran' => $nopendaftaran, 'namaSiswa' => $r['namaSiswa'], 'tahunajaran' => $tahunajaran, 'kelompok' => $r['kelompok'], 'tingkat' => $r['tingkat'], 'golongan' => $r['golongan'], 'kelamin' => $r['kelamin'], 'tmplahir' => $r['tmplahir'], 'tgllahir' => tgl_indo5($r['tgllahir']), 'agama' => $r['agama'], 'alamat' => $r['alamat'], 'telpon' => $r['telpon'], 'sekolahasal' => $r['sekolahasal'], 'photo' => $r['photo'], 'darah' => $r['darah'], 'kesehatan' => $r['kesehatan'], 'ketkesehatan' => $r['ketkesehatan'], 'namaAyah' => $r['namaAyah'], 'kebangsaanAyah' => $r['kebangsaanAyah'], 'tmplahirAyah' => $r['tmplahirAyah'], 'tgllahirAyah' => tgl_indo5($r['tgllahirAyah']), 'pekerjaanAyah' => $r['pekerjaanAyah'], 'telponAyah' => $r['telponAyah'], 'pinbbAyah' => $r['pinbbAyah'], 'emailAyah' => $r['emailAyah'], 'namaIbu' => $r['namaIbu'], 'kebangsaanIbu' => $r['kebangsaanIbu'], 'tmplahirIbu' => $r['tmplahirIbu'], 'tgllahirIbu' => tgl_indo5($r['tgllahirIbu']), 'pekerjaanIbu' => $r['pekerjaanIbu'], 'telponIbu' => $r['telponIbu'], 'pinbbIbu' => $r['pinbbIbu'], 'emailIbu' => $r['emailIbu'], 'namaKakek' => $r['namaKakek'], 'namaNenek' => $r['namaNenek'], 'namaDarurat' => $r['namaDarurat'], 'hubungan' => $r['hubungan'], 'telponDarurat' => $r['telponDarurat']));
            break;
            // ambiledit -----------------------------------------------------------------
            //detail siswa
        // ambiledit -----------------------------------------------------------------
        //detail siswa
        case 'detail':
            $s = ' SELECT 
								t.replid,
								d.nama departemen,
								akt.tahunajaran tahunajaran,
								k.kelompok kelompok,
								t.nopendaftaran nopendaftaran,
								t.status statusx,
								t.nama as nama_siswa,
								if(t.kelamin="L","Laki-Laki","Perempuan") jk,