Example #1
0
                         <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;
         $out .= '<table width="100%">
                           <tr>
                               <td align="right"> Saldo Akhir : ' . setuang($saldoAkhir) . '</td>
                           </tr>
                         </table>';
         $out .= '<hr>';
     }
 } else {
     #kosong
     $out .= '<tr align="center">
           <td  colspan=9 ><span style="color:red;text-align:center;">
           ... data tidak ditemukan...</span></td></tr>';
 }
 echo $out;
 #generate html -> PDF ------------
 $out2 = ob_get_contents();
 ob_end_clean();
 $mpdf = new mPDF('c', 'A4', '');
Example #2
0
              //9.600 - 2.800
              $cc='';
              foreach ($r7 as $i => $v) {
                $biayaAwal         = $v['nominal'];
                $diskRegArr        = getFieldArr3('detaildiskon','psb_siswadiskon','','siswabiaya',$v['replid']);
                $biayaAfterdiskReg = getBiayaDiskReg($v['detailbiaya'],$diskRegArr);
                $diskReg           = $biayaAwal - $biayaAfterdiskReg;
                $diskKhusus        = $v['diskonkhusus'];
                $biayaNett         = $biayaAwal - ($diskReg+$diskKhusus);
                $cc.=$diskReg.'<br />';
                $out.='<tr>
                  <td style="background-color:grey;color:white;">'.(empty($v['biaya'])?'-':$v['biaya']).'</td>
                  <td align="right">'.(empty($biayaAwal)?'Rp. 0':setuang($biayaAwal)).'</td>
                  <td align="right">'.(empty($diskReg)?'Rp. 0':setuang($diskReg)).'</td>
                  <td align="right">'.(empty($diskKhusus)?'Rp. 0':setuang($diskKhusus)).'</td>
                  <td align="right">'.(empty($biayaNett)?'Rp. 0':setuang($biayaNett)).'</td>
                  <td align="center">'.(empty($v['angsuran'])?'-':$v['angsuran'].' x').'</td>
                </tr>';
              }
              // pr($cc);
            $out.='</table>
          </td>
        </tr>
        <tr><td colspan="3">&nbsp;</td></tr>';


        // bioadata siswa
        $r=getField('*',$tb,'replid',$replid);
        $photosiswa = $imageDir.$r['photosiswa'];
        $out.='
            <tr class="head">
Example #3
0
							<td>'.$nox.'. '.$r1['golongan'].'<br> <sup class="fg-orange">('.$r1['keterangan'].')</sup></td>';
						$s2 = 'SELECT
									db.replid,
									db.nominal,
									b.biaya
								FROM
									'.$tb.' db JOIN psb_biaya b on b.replid = db.biaya
								WHERE
									db.golongan = '.$r1['replid'].'
									AND db.subtingkat = '.$subtingkat.'
									AND db.detailgelombang = '.$detailgelombang.'
								ORDER BY
									b.biaya asc';
						$e2= mysql_query($s2);
						while ($r2=mysql_fetch_assoc($e2)) {
							$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;
               <td align="center">NISN</td>
               <td align="center">NIS</td>
               <td align="center">Nama</td>
               <td align="center">Tagihan</td>
               <td align="center">Terbayar</td>
               <td align="center">Status</td>
             </tr>';
 while ($r = mysql_fetch_assoc($e)) {
     $color = $r['statusBayar'] == 'lunas' ? 'green' : ($r['statusBayar'] == 'belum' ? 'red' : 'orange');
     $out .= '<tr>
         <td align="center">' . getNoPendaftaran2($r['idsiswa']) . '</td>
         <td>' . $r['nisn'] . '</td>
         <td>' . $r['nis'] . '</td>
         <td>' . $r['namasiswa'] . '</td>
         <td align="right">' . setuang($biayaNett) . '</td>
         <td align="right">' . setuang($terbayarTotal) . '</td>
         <td style="background-color:' . $color . ';color:white;" align="center">' . $r['statusBayar'] . '</td>
       </tr>';
 }
 $out .= '</table>';
 $out .= '</body>';
 echo $out;
 #generate html -> PDF ------------
 $out2 = ob_get_contents();
 ob_end_clean();
 $mpdf = new mPDF('c', 'A4', '');
 $mpdf->SetDisplayMode('fullpage');
 $stylesheet = file_get_contents('../../lib/mpdf/r_cetak.css');
 $mpdf->WriteHTML($stylesheet, 1);
 $mpdf->WriteHTML($out);
 $mpdf->Output();
Example #5
0
   <td colspan="2">: '.(empty($r3['faxrumahibu'])?'-':$r3['faxrumahibu']).'</td>
 </tr><tr>
   <td >Pendidikan</td>
   <td colspan="2">: '.(empty($r3['pendidikanibu'])?'-':$r3['pendidikanibu']).'</td>
 </tr><tr>
   <td >Bidang Pekerjaan</td>
   <td colspan="2">: '.(empty($r3['bidangpekerjaanibu'])?'-':$r3['bidangpekerjaanibu']).'</td>
 </tr><tr>
   <td >Pekerjaan</td>
   <td colspan="2">: '.(empty($r3['pekerjaanibu'])?'-':$r3['pekerjaanibu']).'</td>
 </tr><tr>
   <td >Posisi</td>
   <td colspan="2">: '.(empty($r3['posisiibu'])?'-':$r3['posisiibu']).'</td>
 </tr><tr>
   <td >Penghasilan</td>
   <td colspan="2">: '.(empty($r3['penghasilanibu'])?'-':setuang($r3['penghasilanibu'])).'</td>
 </tr><tr>
   <td >Telpon Kantor</td>
   <td colspan="2">: '.(empty($r3['telponkantoribuibu'])?'-':$r3['telponkantoribuibu']).'</td>
 </tr><tr>
   <td >Fax Kantor</td>
   <td colspan="2">: '.(empty($r3['faxkantoribu'])?'-':$r3['faxkantoribu']).'</td>
 </tr><tr>
   <td >Alamat Kantor</td>
   <td colspan="2">: '.(empty($r3['alamatkantoribu'])?'-':$r3['alamatkantoribu']).'</td>
 </tr><tr>
   <td >Kode Pos </td>
   <td colspan="2">: '.(empty($r3['kodeposibu'])?'-':$r3['kodeposibu']).'</td>
 </tr><tr>
   <td colspan="3">&nbsp;</td>
 </tr>';
Example #6
0
             $out .= '<tr >
             <td width="10%">' . tgl_indo5($r2['tanggal']) . '</td>
             <td  width="20%">' . getNoKwitansi($r2['replid']) . '</td>
             <td  width="30%">' . $r2['uraian'] . '</td>
             <td  align="right" width="20%">' . $debit . '</td>
             <td  align="right" width="20%">' . $kredit . '</td>
           </tr>';
         }
         $selisihDebit = $debitTot - $kreditTot >= 0 ? setuang($debitTot - $kreditTot) : '';
         $selisihKredit = $debitTot - $kreditTot < 0 ? setuang(abs($debitTot - $kreditTot)) : '';
         $out .= '</tbody>
               <tfoot>
                 <tr class="head">
                   <th colspan="3" align="right">Total</th>
                   <th align="right">' . ($debitTot != 0 ? setuang($debitTot) : '') . '</th>
                   <th align="right">' . ($kreditTot != 0 ? setuang($kreditTot) : '') . '</th>
                 </tr>
                 <tr class="head">
                   <th colspan="3" align="right">Grand Total</th>
                   <th align="right">' . $selisihDebit . '</th>
                   <th align="right">' . $selisihKredit . '</th>
                 </tr>
               </tfoot>
             </table><br />';
     }
     // $out.='</ul>';
 }
 echo $out;
 #generate html -> PDF ------------
 $out2 = ob_get_contents();
 ob_end_clean();
Example #7
0
						$biayaArr=array();
						//end of : biaya ---------------

						if($n==0) $stat='kosong';
						else{
							$stat='sukses';
							while ($r=mysql_fetch_assoc($e)) {
								// diskon reguler -----------
								$biayaArr[]=array(
									'replid'          =>$r['replid'],
									'kode'            =>$r['kode'],
									'biaya'           =>$r['biaya'],
									'ditagih'           =>$r['ditagih'],
									'idsiswabiaya'    =>(isset($_POST['siswa']) && $_POST['siswa']!=''?$r['idsiswabiaya']:''),
									'angsuran'        =>(isset($_POST['siswa']) && $_POST['siswa']!=''?$r['angsuran']:''),
									'diskonkhusus'    =>(isset($_POST['siswa']) && $_POST['siswa']!=''?setuang($r['diskonkhusus']):''),
									'ketdiskonkhusus' =>(isset($_POST['siswa']) && $_POST['siswa']!=''?$r['ketdiskonkhusus']:''),
									'isAngsur'        =>$r['isAngsur'],
									'isAngsur2'       =>(isset($r['isAngsur2'])?$r['isAngsur2']:''),
									'viabayar'        =>(isset($r['viabayar'])?$r['viabayar']:''),
									'isDiskon'        =>$r['isDiskon'],
								);
							}
						}$out=json_encode(array('status'=>$stat,'levelurutan'=>$_SESSION['levelurutanS'],'biayaArr'=>$biayaArr));
						break;
					}
			break; 
			// view -----------------------------------------------------------------

			case 'getBiaya':
				if(!isset($_POST['detailgelombang']) || !isset($_POST['subtingkat']) || !isset($_POST['golongan']))
Example #8
0
        if ($page > $total_pages) {
            $page = $total_pages;
        }
        $start = $limit * $page - $limit;
        // do not put $limit*($page - 1)
        $ss .= ' GROUP BY dr.replid';
        if ($total_pages != 0) {
            $ss .= ' ORDER BY ' . $sidx . ' ' . $sord . ' LIMIT ' . $start . ',' . $limit;
        } else {
            $ss .= ' ORDER BY ' . $sidx . ' ' . $sord;
        }
        // print_r($ss);exit();
        $result = mysql_query($ss) or die("Couldn t execute query." . mysql_error());
        $rows = array();
        while ($row = mysql_fetch_assoc($result)) {
            $rows[] = array('replid' => $row['replid'], 'kode' => $row['kode'], 'detilRekening' => $row['detilRekening'], 'kategoriRekening' => $row['kategoriRekening'], 'saldoRekening' => setuang($row['saldoRekening']));
        }
        $response = array('page' => $page, 'total' => $total_pages, 'records' => $count, 'rows' => $rows);
        $out = json_encode($response);
    } else {
        $out = json_encode(array('status' => 'invalid_no_post'));
    }
} else {
    switch ($_POST['aksi']) {
        // -----------------------------------------------------------------
        case 'tampil':
            $departemen = isset($_POST['departemenS']) ? $_POST['departemenS'] : '';
            $tahunajaran = isset($_POST['tahunajaranS']) ? $_POST['tahunajaranS'] : '';
            $biaya = isset($_POST['biayaS']) ? $_POST['biayaS'] : '';
            $detilrekening = isset($_POST['detilrekeningS']) ? $_POST['detilrekeningS'] : '';
            $sql = 'SELECT 
Example #9
0
				$out    = json_encode(array(
							'status'          =>$stat,
						// pembayaran
							'setbiaya'        =>$r['setbiaya'],
							'dpp'    		  =>$regNum,
							'angsuran'        =>$r['angsuran'],
							'discangsuran'    =>$discangsuran,
							'discsubsidi'     =>setuang($r['discsubsidi']),
							'discsaudara'     =>setuang($r['discsaudara']),
							'iddisctunai'     =>$r['disctunai'],
							'disctunai'       =>$disctunai,
							'disctotal'       =>setuang(getDiscTotal($_POST['replid'])),
							'dppnet' 		  =>$regNumNet,
							'joiningf'        =>setuang($r['joiningf']),
							'spp'         	  =>setuang($r['spp']),
							'daftar'         =>setuang($r['daftar']),
						// data siswa
							
							'nopendaftaranH'  =>$r['nopendaftaran'],
							'nopendaftaran'  =>$nopendaftaran,
							'namaSiswa'      =>$r['namaSiswa'],
							'proses'         =>$proses,
							'kelompok'       =>$r['kelompok'],
							'kriteria'       =>$r['kriteria'],
							'golongan'       =>$r['golongan'],
							'kelamin'        =>$r['kelamin'],
							'tmplahir'       =>$r['tmplahir'],
							'tgllahir'       =>tgl_indo5($r['tgllahir']),
							'agama'          =>$r['agama'],
							'alamat'         =>$r['alamat'],
							'telpon'    	 =>$r['telpon'],
                    // 				<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>';
            break;
Example #11
0
            $biayaNett = getBiayaNett2($_POST['replid'], $_POST['biaya']);
            $angsuranNominal = getAngsuranNominal($_POST['replid'], $_POST['biaya']);
            // terbayar
            $terbayarAngsurankeReal = getTerbayarAngsuranke($_POST['replid'], $_POST['biaya']);
            $terbayarBaru = getTerbayarBaru($_POST['replid'], $_POST['biaya']);
            $terbayarTotal = getTerbayarTotal($_POST['replid'], $_POST['biaya']);
            $terbayarAngsurankeRule = ceil($terbayarTotal / $angsuranNominal);
            // akan bayar
            $akanBayarke = $terbayarTotal % $angsuranNominal == 0 ? $terbayarAngsurankeRule + 1 : $terbayarAngsurankeRule;
            $lunasPerAngsuran = $terbayarTotal % $angsuranNominal == 0 ? true : false;
            $lunasTotalAngsuran = $terbayarTotal == $biayaNett ? true : false;
            $kuranganAngsuran = $terbayarAngsurankeRule == $akanBayarke ? $angsuranNominal - $terbayarBaru : 0;
            //belum bayar
            $belumBayarAngsuranke = intval($r['angsuran']) - intval($akanBayarke);
            $semester = getField('semester', 'aka_semester', 'replid', $r['idsemester']);
            $out = json_encode(array('status' => $stat, 'datax' => array('idsiswabiaya' => $r['idsiswabiaya'], 'ditagih' => $r['ditagih'], 'idsemester' => $r['idsemester'], 'idsemester' => $r['idsemester'], 'semester' => $semester == '1' ? 'Ganjil' : 'Genap', 'namasiswa' => $r['namasiswa'], 'kelas' => $r['kelas'], 'biaya' => $r['biaya'], 'nis' => $r['nis'], 'biayaAwal' => setuang($r['biayaAwal']), 'biayaNett' => setuang($biayaNett), 'totalDiskon' => setuang($r['biayaAwal'] - $biayaNett), 'kuranganAngsuran' => $kuranganAngsuran, 'viabayar' => $r['viabayar'], 'isAngsur2' => $r['isAngsur2'], 'angsuran' => $r['angsuran'], 'angsuranNominal' => setuang($angsuranNominal), 'lunasPerAngsuran' => $lunasPerAngsuran, 'lunasTotalAngsuran' => $lunasTotalAngsuran, 'terbayarAngsurankeReal' => $terbayarAngsurankeReal, 'terbayarAngsurankeRule' => $terbayarAngsurankeRule, 'terbayarBaru' => setuang($terbayarBaru), 'terbayarTotal' => setuang($terbayarTotal), 'akanBayarke' => $akanBayarke, 'belumBayarAngsuranke' => $belumBayarAngsuranke)));
            break;
        case 'kodegenerate':
            $s = 'SELECT
						tb1.lokasi,
						tb1.grup,
						tb1.tempat,
						tb1.katalog,
						tb2.barang,
						LPAD(tb2.barang,5,0)barkode	
					FROM (
						SELECT
							l.kode lokasi,
							g.kode grup,
							t.kode tempat,
							k.kode katalog
Example #12
0
							'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'],
							'alamatkantoribu'        =>$r['alamatkantoribu'],
							'telponkantoribu'        =>$r['telponkantoribu'],
							'faxkantoribu'           =>$r['faxkantoribu'],
							'gerejaibu'              =>$r['gerejaibu'],
							// biodata wali
							'idsiswawali'            =>$r['idsiswawali'],
							'namawali'               =>$r['namawali'],
							'jkelaminwali'           =>$r['jkelaminwali'],
							'alamatwali'             =>$r['alamatwali'],
Example #13
0
									db.replid,
									db.nominal,
									b.biaya
								FROM
									' . $tb . ' db JOIN psb_biaya b on b.replid = db.biaya
								WHERE
									db.golongan = ' . $r1['replid'] . '
									AND db.subtingkat = ' . $subtingkat . '
									AND db.detailgelombang = ' . $detailgelombang . '
								ORDER BY
									b.biaya asc';
                    // pr($s2);
                    $e2 = mysql_query($s2);
                    while ($r2 = mysql_fetch_assoc($e2)) {
                        if (!isAksi('detailbiaya', 'u')) {
                            $field = setuang($r2['nominal']);
                        } else {
                            $field = '<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>';
                            // <a onclick="viewFR('.$r2['replid'].');" class="button fg-white bg-blue" href="#" data-hint="rekening">
                            // 	<i class=" icon-cc-nc"></i>
                            // </a>
                        }
                        $out .= '<td align="right">' . $field . '</td>';
                    }
                    $out .= '</tr>';
                    $nox++;
                }
            }
Example #14
0
function getDetAnggaranFull($id)
{
    $s = 'SELECT  
				da.detilanggaran,
				ka.kategorianggaran,
				getAnggaranPerItem(' . $id . ')kuota 
			FROM keu_anggarantahunan ath
				JOIN keu_detilanggaran da on da.replid = ath.detilanggaran
				JOIN keu_kategorianggaran ka on ka.replid = da.kategorianggaran
			WHERE ath.replid=' . $id;
    // pr($s);
    $e = mysql_query($s);
    $r = mysql_fetch_assoc($e);
    return $r['detilanggaran'] . ' (' . $r['kategorianggaran'] . ') | kuota : ' . setuang($r['kuota']);
}
Example #15
0
            if (!$e) {
                $stat = 'gagal_ambiledit_anggaran_tahunan';
            } else {
                $s2 = 'SELECT replid, jml, bulan FROM keu_nominalanggaran WHERE anggarantahunan =' . $_POST['replid'];
                $e2 = mysql_query($s2);
                $stat = !$e2 ? 'gagal_nominalanggaran' : 'sukses';
                $nominalArr = array();
                $totJml = $totJmlHrg = 0;
                while ($r2 = mysql_fetch_assoc($e2)) {
                    $jmlHrg = intval($r2['jml']) * intval($r['hargasatuan']);
                    $totJml += $r2['jml'];
                    $totJmlHrg += $jmlHrg;
                    $nominalArr[] = array('replid' => $r2['replid'], 'jml' => $r2['jml'], 'bulan' => $r2['bulan'], 'jmlHrg' => setuang($jmlHrg));
                }
            }
            $out = json_encode(array('status' => $stat, 'departemen' => $r['departemen'], 'tahunajaran' => $r['tahunajaran'], 'tingkat' => $r['tingkat'], 'kategorianggaran' => $r['kategorianggaran'], 'detilanggaran' => $r['detilanggaran'], 'hargasatuan' => setuang($r['hargasatuan']), 'keterangan' => $r['keterangan'], 'nominalArr' => $nominalArr, 'totJml' => $totJml, 'totJmlHrg' => setuang($totJmlHrg)));
            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	
					FROM (
						SELECT
             $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>
               <td >* Tagihan ' . ($r['isAngsur2'] == 1 ? ' Angsuran ke-' . ($angsuranKe == 0 ? 1 : $angsuranKe + 1) : '') . '</td>
               <td ' . ($r['isAngsur2'] != 1 ? 'style="background-color:pink;"' : '') . '>: ' . ($r['isAngsur2'] != 1 ? setuang($r['biayaNett']) : '') . '</td>
               <td  ' . ($r['isAngsur2'] == 1 ? 'align="right" style="background-color:pink;"' : '') . ' >' . ($r['isAngsur2'] == 1 ? setuang($r['angsurNom']) : '') . '</td>
             </tr><tr>
               <td>* Terbilang</td>
               <td colspan="2">: ' . Terbilang($r['isAngsur2'] == 1 ? $r['angsurNom'] : $r['biayaNett']) . ' Rupiah</td>
             </tr>
           </table>';
 // pr(intval($r['biayaNett']));
 $out .= '</body>';
 echo $out;
 #generate html -> PDF ------------
 $out2 = ob_get_contents();
 ob_end_clean();
 $mpdf = new mPDF('c', 'A4', '');
 $mpdf->SetDisplayMode('fullpage');
 $stylesheet = file_get_contents('../../lib/mpdf/r_cetak.css');
 $mpdf->WriteHTML($stylesheet, 1);
Example #17
0
                    break;
                case 'ju':
                    $s = 'SELECT * FROM ' . $tb . '  WHERE replid=' . $_POST['replid'];
                    // var_dump($s);exit();
                    $e = mysql_query($s);
                    $r = mysql_fetch_assoc($e);
                    $stat = $e ? 'sukses' : 'gagal';
                    if (!$e) {
                        $stat = 'gagal';
                    } else {
                        //sukses
                        $s2 = 'SELECT * FROM keu_jurnal WHERE transaksi =' . $_POST['replid'] . ' ORDER BY jenis ASC';
                        $e2 = mysql_query($s2);
                        $jurnalArr = array();
                        while ($r2 = mysql_fetch_assoc($e2)) {
                            $jurnalArr[] = array('idjurnal' => $r2['replid'], 'idrek' => $r2['rek'], 'rek' => getRekBy('nama', $r2['rek']), 'nominal' => setuang($r2['nominal']), 'jenis' => $r2['jenis']);
                        }
                        $transaksiArr = array('nomer' => $r['nomer'], 'nobukti' => $r['nobukti'], 'tanggal' => tgl_indo7($r['tanggal']), 'uraian' => $r['uraian'], 'jurnalArr' => $jurnalArr);
                        $stat = 'sukses';
                    }
                    $out = json_encode(array('status' => $stat, 'transaksiArr' => $transaksiArr));
                    break;
            }
            break;
            // ambiledit ------------------------------------------------------------------
            // generate barcode -----------------------------------------------------------
        // ambiledit ------------------------------------------------------------------
        // generate barcode -----------------------------------------------------------
        case 'kodegenerate':
            $s = 'SELECT
						tb1.lokasi,
Example #18
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;
?>
Example #19
0
                    if ($res['idkategorirekening'] != $curKat) {
                        // kategori rek
                        $ss = 'SELECT replid,nama,RPAD(kode,6,0)kode from keu_kategorirekening where replid=' . $res['idkategorirekening'];
                        $ee = mysql_query($ss);
                        $rr = mysql_fetch_assoc($ee);
                        $out .= '<tr class="bg-lightTeal">
											<td align="right"><b>' . $rr['kode'] . '</b></td>
											<td colspan="6"><b>' . $rr['nama'] . '</b></td>
										</tr>';
                    }
                    $btn = '<td align="center">
										<button data-hint="ubah"  class="button" onclick="viewFR(' . $res['replid'] . ');">
											<i class="icon-pencil on-left"></i>
										</button>
								 </td>';
                    $saldoAwal = setuang($res['saldo']);
                    $out .= '<tr>
										<td class="text-right">' . $res['kode'] . '</td>
										<td>' . $res['nama'] . '</td>
										<td class="text-right">' . ($res['jenis'] == 'd' ? 'debit' : 'kredit') . '</td>
										<td class="text-right">' . $saldoAwal . ',-</td>
										' . $btn . '
									</tr>';
                    $curKat = $res['idkategorirekening'];
                    $nox++;
                }
            } else {
                #kosong
                $out .= '<tr align="center">
							<td  colspan=9><span style="color:red;text-align:center;">
							... data tidak ditemukan...</span></td></tr>';
Example #20
0
                   <td align="right" class="fg-white bg-red">: ' . setuang($subtotal) . '</td>
                 </tr><tr>
                   <td colspan="3">&nbsp;</td>
                 </tr>';
 }
 // laba tahun berjalan
 $out .= '<tr>
                 <td>Laba Tahun berjalan </td>
                 <td align="right">Rp. 500.000</td>
                 <td></td>
               </tr>';
 $out .= '
                 <tr><td colspan="3">&nbsp;</td></tr>
                 <tr>
                   <td align="right" colspan="2">Grand Total</td>
                   <td class="bg-red fg-white" align="right">' . setuang($grandtotalr) . '</td>
                 </tr>
               </table>
                             </td>
                         </tr>
                     </tbody>';
 $out .= '<tbody>';
 $grandTot = 0;
 $out .= '</table>
     </body>';
 echo $out;
 #generate html -> PDF ------------
 $out2 = ob_get_contents();
 ob_end_clean();
 $mpdf = new mPDF('c', 'A4', '');
 $mpdf->SetDisplayMode('fullpage');
Example #21
0
           <td align="center">Nominal</td>
           <td align="center">Nama Akun</td>
         </tr>';
 $tot = 0;
 while ($rc = mysql_fetch_assoc($ec)) {
     $out .= '<tr>
           <td align="center">' . $rc['rekKode'] . '</td>
           <td align="right">' . $rc['subtotal'] . '</td>
           <td>' . $rc['rekNama'] . '</td>
         </tr>';
     // <td align="right">'.setuang($rc['subtotal']).'</td>
     $tot += $rc['subtotal'];
 }
 $out .= '<tr class="head">
         <td  align="right">Total : </td>
         <td align="right">' . setuang($tot) . '</td>
         <td></td>
       </tr>';
 $out .= '</table><br />';
 $out .= '<jpgraph 
   title="Grafik ' . $mnu . '" 
   table="grafikTBL" 
   type="pie3d" 
   percent="1"
   data-col-begin="2" 
   data-row-begin="2"
   data-col-end="2"
   data-row-end="-1"
   show-values="1" 
   width="700" 
   height="300" 
Example #22
0
             <td width="20%">Golongan</td>
             <td>: ' . $golongan . '</td>
           </tr>';
 // Pembayaran
 $out .= '
           <tr class="head">
             <td colspan="3">Pembayaran</td>
           </tr><tr>
             <td width="20%">Registration Fee</td>
             <td>: ' . setuang(getBiayaNet('registration', $r['replid'])) . ' (' . ($r['angsuran'] == 1 ? 'cash' : $r['angsuran'] . 'x angsuran') . ')</td>
           </tr><tr>
             <td width="20%">Material Fee</td>
             <td>: ' . setuang(getBiaya('material', $r['replid'])) . '</td>
           </tr><tr>
             <td width="20%">Tuition Fee</td>
             <td>: ' . setuang(getBiaya('tuition', $r['replid'])) . '</td>
           </tr>';
 // bio data calon siswa
 $out .= '
           <tr class="head">
             <td colspan="3">Biodata Siswa</td>
           </tr><tr>
             <td width="20%">No. Pendaftaran</td>
             <td>: ' . getNoPendaftaran($replid, $r['kelompok'])['akhir'] . '</td>
             <td align="right" rowspan="5"><img height="120" src="../img/upload/' . $r['photo'] . '" alt="" /></td>
           </tr><tr>
             <td width="20%">Nama Lengkap</td>
             <td>: ' . $r['nama'] . '</td>
           </tr><tr>
             <td width="20%">Jenis Kelamin</td>
             <td>: ' . $r['kelamin'] . '</td>
Example #23
0
                      <td></td>
                    </tr>';
                $subtot += $r2['nominal'];
                $grandTot = $r1['posisi'] == 'r' ? $grandTot - $r2['nominal'] : $grandTot + $r2['nominal'];
            }
            $out .= '<tr>
                  <td colspan="2"></td>
                  <td style="background-color:lightGrey;" align="right">' . setuang($subtot) . '</td>
                </tr>';
            $out .= '</tr>';
        }
        $out .= '</tbody>
                          <tfoot>
                            <tr>
                              <th colspan="2" align="right" >' . ($grandTot < 0 ? ' Rugi' : 'Laba') . '</th>
                              <th align="right">' . setuang($grandTot) . '</th>
                            </tr>
                          </tfoot>';
        $out .= '</table>';
        echo $out;
        #generate html -> PDF ------------
        $out2 = ob_get_contents();
        ob_end_clean();
        $mpdf = new mPDF('c', 'A4', '');
        $mpdf->SetDisplayMode('fullpage');
        $stylesheet = file_get_contents('../../lib/mpdf/r_cetak.css');
        $mpdf->WriteHTML($stylesheet, 1);
        $mpdf->WriteHTML($out);
        $mpdf->Output();
    }
}
Example #24
0
              </tr>';
        } else {
            while ($r = mysql_fetch_assoc($e)) {
                $debitTot += $r['saldoRekening'] < 0 ? 0 : $r['saldoRekening'];
                $kreditTot += $r['saldoRekening'] > 0 ? 0 : abs($r['saldoRekening']);
                $out .= '<tr>
                      <td align="center">' . $r['kode'] . '</td>
                      <td>' . $r['nama'] . '</td>
                      <td align="right">' . ($r['saldoRekening'] < 0 ? '' : setuang($r['saldoRekening'])) . '</td>
                      <td align="right">' . ($r['saldoRekening'] > 0 ? '' : setuang(abs($r['saldoRekening']))) . '</td>
                    </tr>';
            }
        }
        $out .= '<tr class="head"><td colspan="2" align="right">Jumlah :</td>
              <td align="right"><b>' . setuang($debitTot) . '</b></td>
              <td align="right"><b>' . setuang($kreditTot) . '</b></td>
            </tr>';
        $out .= '</table>';
        echo $out;
        #generate html -> PDF ------------
        $out2 = ob_get_contents();
        ob_end_clean();
        $mpdf = new mPDF('c', 'A4', '');
        $mpdf->SetDisplayMode('fullpage');
        $stylesheet = file_get_contents('../../lib/mpdf/r_cetak.css');
        $mpdf->WriteHTML($stylesheet, 1);
        $mpdf->WriteHTML($out);
        $mpdf->Output();
    }
}
// ---------------------- //
Example #25
0
										j.jenisrekening,
										dr.replid iddetilrekening,
										concat(dr.nama," - ",dr.nama)detilrekening,
										j.nominal,
										sr.nominal saldorekening
									FROM keu_jurnal j
										JOIN keu_detilrekening dr on dr.replid = j.detilrekening
										JOIN keu_saldorekening sr on sr.detilrekening = dr.replid
									WHERE j.transaksi =' . $_POST['replid'] . ' 
									GROUP BY dr.replid 
									ORDER BY j.jenisrekening ASC';
                        // pr($s2);
                        $e2 = mysql_query($s2);
                        $jurnalArr = array();
                        while ($r2 = mysql_fetch_assoc($e2)) {
                            $jurnalArr[] = array('idjurnal' => $r2['replid'], 'jenisrekening' => $r2['jenisrekening'], 'iddetilrekening' => $r2['iddetilrekening'], 'detilrekening' => $r2['detilrekening'], 'nominal' => setuang($r2['nominal']), 'saldorekening' => setuang($r2['saldorekening']));
                        }
                        $transaksiArr = array('idkwitansi' => $r['idkwitansi'], 'detjenistransaksi' => $r['detjenistransaksi'], 'nobukti' => $r['nobukti'], 'tanggal' => tgl_indo7($r['tanggal']), 'uraian' => $r['uraian'], 'jurnalArr' => $jurnalArr);
                        $stat = 'sukses';
                    }
                    $out = json_encode(array('status' => $stat, 'transaksiArr' => $transaksiArr));
                    break;
            }
            break;
            // ambiledit ------------------------------------------------------------------
            // generate barcode -----------------------------------------------------------
        // ambiledit ------------------------------------------------------------------
        // generate barcode -----------------------------------------------------------
        case 'kodegenerate':
            $s = 'SELECT
						tb1.lokasi,
Example #26
0
     $s2 = ' SELECT *
               FROM keu_jurnal 
               WHERE transaksi =' . $r['replid'] . '
               ORDER BY jenisrekening ASC ';
     $e2 = mysql_query($s2);
     $tb2 = '';
     if (mysql_num_rows($e2) != 0) {
         $tb2 .= '<table class="isi" width="100%">
                   <tr class="head">
                     <td width="60%">Rekening</td>
                     <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>';
 }
         $biayaTerbayar += $v['biayaTerbayar'];
         $biayaKurang += $v['biayaKurang'];
         $biayaTotal += $v['biayaTerbayar'] + $v['biayaKurang'];
         $out .= '<tr>
             <td>' . $no . '. ' . $v['tingkat'] . '</td>
             <td align="right">' . setuang($v['biayaTerbayar']) . '</td>
             <td align="right">' . setuang($v['biayaKurang']) . '</td>
             <td align="right">' . setuang($v['biayaKurang'] + $v['biayaTerbayar']) . '</td>
           </tr>';
         $no++;
     }
     $out .= '<tr class="head">
           <td align="right">biayaTotal:</td>
           <td  align="right">' . setuang($biayaTerbayar) . '</td>
           <td  align="right">' . setuang($biayaKurang) . '</td>
           <td  align="right">' . setuang($biayaTotal) . '</td>
         </tr>';
 }
 // pr($cc);
 $out .= '</table>
   </td>
 </tr>
 <tr><td colspan="3">&nbsp;</td></tr>';
 $out .= '</table>';
 $out .= '</body>';
 echo $out;
 #generate html -> PDF ------------
 $out2 = ob_get_contents();
 ob_end_clean();
 $mpdf = new mPDF('c', 'A4', '');
 $mpdf->SetDisplayMode('fullpage');
                      <td>Sebanyak </td>
                      <td>: ' . Terbilang($r['nominal']) . ' Rupiah </td>
                    </tr>
                    <tr>
                      <td>Untuk  </td>
                      <td>: Pembayaran ' . $r['biaya'] . ' </td>
                    </tr>
                    <tr>
                      <td colspan="2" align="right">Surabaya, ' . tgl_indo8($r['tanggal']) . '  </td>
                    </tr>
                    <tr>
                      <td colspan="2" align="right">ttd  </td>
                    </tr>
                    <tr>
                      <td>Terbilang </td>
                      <td>: ' . setuang($r['nominal']) . ' </td>
                    </tr>
                  </table>';
        $out .= '</body>';
        echo $out;
        #generate html -> PDF ------------
        $out2 = ob_get_contents();
        ob_end_clean();
        $mpdf = new mPDF('c', 'A4', '');
        $mpdf->SetDisplayMode('fullpage');
        $stylesheet = file_get_contents('../../lib/mpdf/r_cetak.css');
        $mpdf->WriteHTML($stylesheet, 1);
        $mpdf->WriteHTML($out);
        $mpdf->Output();
    }
}
Example #29
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,