nextjs-cleo-minimarket/old-source/LaporanBeli/lapbeliperkat.php~

<?php
	include "../func_lib.php";
	
	session_start();
	if($_SESSION['validAssko'] !== TRUE && $_SESSION['validAdmin'] !== TRUE && $_SESSION['validPemko'] !== TRUE)
	{
		header("location: ../index.php");
		exit();
	}
	
		echo "<style type='text/css'>";
		echo "div#divprint{width:850px; border:1px solid #000; padding:20px 0; margin-bottom:25px;}";
		echo "table.tbl {width:700px;border-width:0 0 1px 1px;border-spacing:0;border-collapse:collapse;font-size:9pt;text-align:center;}";
		echo "table.tbl,table.tbl td {border-color:#000;border-style:solid;}";
		echo "table.tbl td {margin:0;padding:2px;border-width:1px 1px 0 0;}";
		echo "body {font-size:9pt;}"; 
		echo "div.luar{text-align:left;margin-left:150px;}";
		echo ".header{font-weight:bold;text-align:center;}";
		echo ".isi{text-align:left;}";
		echo ".master{text-align:left;}";
		echo "</style>";
		
	$startDate = decTgl($_POST['startDate']);
	$endDate = decTgl($_POST['endDate']);
	
	
	if(bukaKoneksi()){
		global $conn;

// 		$query = "SELECT s.kel_jns, substr( d.kode_barang, 1, 2 ) lini, sum( d.jumlah ) jum ,
//                         		sum(d.jumlah*REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(d.harga_pokok,'B','1'),'R','2'),'A','3'),'W','4'),'N','5'),'F','6'),'O','7'),'X','8'),'E','9'),'S','0')) hp
//                         		FROM d_pembelian d
//                         		INNER JOIN strip s ON ( s.kd_strip = substr( d.kode_barang, 1, 2 ) )
//                         		INNER JOIN m_pembelian m ON ( m.no_faktur = d.no_faktur )
//                         		WHERE m.no_faktur
//                         		IN (
//                         			SELECT no_faktur
//                         			FROM m_pembelian
//                         			WHERE tgl_masuk
//                         			BETWEEN '$startDate' AND '$endDate'
//                         		)AND m.validasi = '1'
//                         		GROUP BY s.kel_jns, substr( d.kode_barang, 1, 2 )";
    $query = "SELECT s.kel_jns,substr( d.kode_barang, 1, 2 ) lini,sum( d.jum_fisik ) jum,
              sum(d.jum_fisik*REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(d.harga_pokok,'B','1'),'R','2'),'A','3'),'W','4'),'N','5'),'F','6'),'O','7'),'X','8'),'E','9'),'S','0')) hp
              FROM d_pembelian d, m_pembelian m,strip s
              WHERE d.no_faktur = m.no_faktur
              AND s.kd_strip = substr( d.kode_barang, 1, 2 )
              AND m.tgl_masuk BETWEEN '$startDate' AND '$endDate' AND m.validasi = '1'
              GROUP BY s.kel_jns,substr( d.kode_barang, 1, 2 )";
//     $query2 ="SELECT s.kel_jns, substr( r.kd_barang, 1, 2 ) lini, sum( r.jumlah ) jum, sum( r.jumlah*r.harga_satuan ) hp
//                         		FROM d_retur_beli r
//                         		INNER JOIN strip s ON ( s.kd_strip = substr( r.kd_barang, 1, 2 ) )
//                         		INNER JOIN m_retur_beli m ON ( m.id_retur = r.id_retur )
//                         		WHERE m.tgl_retur
//                         		BETWEEN '$startDate' AND '$endDate' AND m.validasi = '1'
//                         		GROUP BY s.kel_jns, substr( r.kd_barang, 1, 2 )";
    $query2 = "SELECT s.kel_jns, substr( r.kd_barang, 1, 2 ) lini, sum( r.jumlah ) jum,
              sum( r.jumlah*r.harga_satuan ) hp
              FROM d_retur_beli r,strip s,m_retur_beli m
              WHERE m.tgl_retur BETWEEN '$startDate' AND '$endDate' AND m.validasi = '1'
              AND s.kd_strip = substr( r.kd_barang, 1, 2 )
              AND m.id_retur = r.id_retur
              GROUP BY s.kel_jns, substr( r.kd_barang, 1, 2 )";                  		
                    
    
    if($stmt2 = mysqli_prepare($conn,$query2)){
				mysqli_stmt_execute($stmt2);
				mysqli_stmt_store_result($stmt2);
				$cekR = mysqli_stmt_num_rows($stmt2);
				if($cekR >= 0){//jika ada retur 	
					mysqli_stmt_bind_result($stmt2,$kel,$str,$jmlRetur,$rpRetur);
					
					$priaR = 0;
					$wanitaR = 0;
					$anakR = 0;
					$sepatuR = 0;
					$strRet = array();
					$jmlR = array();
					$rpR = array();
					
					$ttJmlRetur = array();
					$ttJmlRetur['pria']['jml'] = 0;
					$ttJmlRetur['pria']['rp'] = 0;
					$ttJmlRetur['wanita']['jml'] = 0;
					$ttJmlRetur['wanita']['rp'] = 0;
					$ttJmlRetur['anak']['jml'] = 0;
					$ttJmlRetur['anak']['rp'] = 0;
					$ttJmlRetur['sepatu']['jml'] = 0;
					$ttJmlRetur['sepatu']['rp'] = 0;
					
					
					while(mysqli_stmt_fetch($stmt2)){
						if($kel == 'P'){
							$strRet[$priaR]['pria'] = $str;
							$jmlR[$priaR]['pria'] = $jmlRetur;
							$rpR[$priaR]['pria'] = $rpRetur;
							$ttJmlRetur['pria']['jml'] += $jmlRetur;
							$ttJmlRetur['pria']['rp'] += $rpRetur;
							$priaR++;
						}elseif($kel == 'W'){
							$strRet[$wanitaR]['wanita'] = $str;
							$jmlR[$wanitaR]['wanita'] = $jmlRetur;
							$rpR[$wanitaR]['wanita'] = $rpRetur;
							$ttJmlRetur['wanita']['jml'] += $jmlRetur;
							$ttJmlRetur['wanita']['rp'] += $rpRetur;
							$wanitaR++;						
						}elseif($kel == 'A'){
							$strRet[$anakR]['anak'] = $str;
							$jmlR[$anakR]['anak'] = $jmlRetur;
							$rpR[$anakR]['anak'] = $rpRetur;
							$ttJmlRetur['anak']['jml'] += $jmlRetur;
							$ttJmlRetur['anak']['rp'] += $rpRetur;
							$anakR++;						
						}else{
							$strRet[$sepatuR]['sepatu'] = $str;
							$jmlR[$sepatuR]['sepatu'] = $jmlRetur;
							$rpR[$sepatuR]['sepatu'] = $rpRetur;
							$ttJmlRetur['sepatu']['jml'] += $jmlRetur;
							$ttJmlRetur['sepatu']['rp'] += $rpRetur;
							$sepatuR++;						
						}
					}
					mysqli_stmt_free_result($stmt2);
					mysqli_stmt_close($stmt2);
				}		
			}
		if($stmt = mysqli_prepare($conn,$query)){
    	mysqli_stmt_execute($stmt);
			mysqli_stmt_store_result($stmt);
			$cek = mysqli_stmt_num_rows($stmt);
			if($cek >= 0){
				mysqli_stmt_bind_result($stmt,$kelJns,$strip,$jmlBeli,$hrgPokok);
				$ttJmlBeli = array();
				$ttJmlBeli['pria']['jml'] = 0;
				$ttJmlBeli['pria']['hp'] = 0;
				$ttJmlBeli['wanita']['jml'] = 0;
				$ttJmlBeli['wanita']['hp'] = 0;
				$ttJmlBeli['anak']['jml'] = 0;
				$ttJmlBeli['anak']['hp'] = 0;
				$ttJmlBeli['sepatu']['jml'] = 0;
        $ttJmlBeli['sepatu']['hp'] = 0;
				
				print("<center><div id=\"divprint\" >");
				print("<h2>Laporan Pembelian Per Kelompok Kategori</h2><br/><br/>");
				print("<div class=\"luar\">TOKO ".$_SESSION['namatoko']."<br/>");
				print("PADA TANGGAL : ".encTgl($startDate) ." s/d ".encTgl($endDate)."<br/>");
				print("DICETAK TANGGAL : ".date('d-m-Y')."</div><br/><br/>");
				$pria = 0;
				$wanita = 0;
				$anak = 0;
				$sepatu = 0;
				$str = array();				
				$jmlB = array();
				$rpB = array();
        $HP = array();
				
				while(mysqli_stmt_fetch($stmt)){
						if($jmlRetur == ''){
							$jmlRetur = 0;						
						}
						if($rpRetur == ''){
							$rpRetur = 0;						
						}
						if($kelJns == "P"){
							$kelJns = "Pria";
							$ttJmlBeli['pria']['jml'] += $jmlBeli;
              $ttJmlBeli['pria']['hp'] += $hrgPokok;					
							$str[$pria]['pria'] = $strip;
							$jmlB[$pria]['pria'] = $jmlBeli;
							$rpB[$pria]['pria'] = $rpBeli;
							$HP[$pria]['pria'] = $hrgPokok;
							$pria++;
						}elseif($kelJns == "W"){
							$kelJns = "Wanita";
							$ttJmlBeli['wanita']['jml'] += $jmlBeli;
              $ttJmlBeli['wanita']['hp'] += $hrgPokok;	
							$str[$wanita]['wanita'] = $strip;
							$jmlB[$wanita]['wanita'] = $jmlBeli;
							$rpB[$wanita]['wanita'] = $rpBeli;
							$HP[$wanita]['wanita'] = $hrgPokok;
							$wanita++;					
						}elseif($kelJns == "A"){
							$kelJns = "Anak";
							$ttJmlBeli['anak']['jml'] += $jmlBeli;
							$ttJmlBeli['anak']['hp'] += $hrgPokok;
							$str[$anak]['anak'] = $strip;
							$jmlB[$anak]['anak'] = $jmlBeli;
							$rpB[$anak]['anak'] = $rpBeli;
							$HP[$anak]['anak'] = $hrgPokok;
							$anak++;
						}else{
							$kelJns = "Sepatu";
							$ttJmlBeli['sepatu']['jml'] += $jmlBeli;
							$ttJmlBeli['sepatu']['hp'] += $hrgPokok;
							$str[$sepatu]['sepatu'] = $strip;
							$jmlB[$sepatu]['sepatu'] = $jmlBeli;
							$rpB[$sepatu]['sepatu'] = $rpBeli;
							$HP[$sepatu]['sepatu'] = $hrgPokok;
							$sepatu++;						
						}
						
				}
				print("<table border=\"1\" class=\"tbl\">");
				print("<tr class=\"header\"><td>Kategori</td><td>Lini Produk</td><td>Jumlah Beli</td><td>Total HP</td></tr>");
				print("<div class=\"luar\">");

/* PRIA -------------------------------------------------------------------------*/
				$jmlkatpria = $ttJmlBeli['pria']['jml']-$ttJmlRetur['pria']['jml'];
				$hpkatpria = $ttJmlBeli['pria']['hp']-$ttJmlRetur['pria']['rp'];
				
        if($ttJmlBeli['pria']['jml']!=0){					
					print("<tr class=\"master\"><td colspan=\"4\"><b>Pria</b></td></tr>");					
					for($i=0;$i<$pria;$i++){
								print("<tr class=\"isi\"><td>~</td><td>".$str[$i]['pria']."</td><td align=\"right\">".number_format($jmlB[$i]['pria'], 0, ",", ".")."</td><td align=\"right\">".number_format($HP[$i]['pria'], 0, ",", ".")."</td></tr>");
					}
		      print("<tr class=\"isi\"><tr class=\"isi\"><td colspan=\"2\"></td><td align=\"right\">".number_format($ttJmlBeli['pria']['jml'], 0, ",", ".")."</td><td align=\"right\">".number_format($ttJmlBeli['pria']['hp'], 0, ",", ".")."</td></tr>");
        }

        if($ttJmlRetur['pria']['jml']!= 0){
					print("<tr class=\"master\"><td colspan=\"4\"><b>Retur Pria</b></td></tr>");					
					for($x=0;$x<$priaR;$x++){
								print("<tr class=\"isi\"><td>~</td><td>".$strRet[$x]['pria']."</td><td align=\"right\">".number_format($jmlR[$x]['pria'], 0, ",", ".")."</td><td align=\"right\">".number_format($rpR[$x]['pria'], 0, ",", ".")."</td></tr>");
					}
		      print("<tr class=\"isi\"><tr class=\"isi\"><td colspan=\"2\"></td><td align=\"right\">".number_format($ttJmlRetur['pria']['jml'], 0, ",", ".")."</td><td align=\"right\">".number_format($ttJmlRetur['pria']['rp'], 0, ",", ".")."</td></tr>");
        }
        
        print("<tr class=\"isi\"><tr class=\"isi\"><td colspan=\"2\" align=\"center\">TOTAL PRIA</td><td align=\"right\">".number_format($jmlkatpria, 0, ",", ".")."</td><td align=\"right\">".number_format($hpkatpria, 0, ",", ".")."</td></tr>");
/* WANITA -------------------------------------------------------------------------*/
				$jmlkatwanita = $ttJmlBeli['wanita']['jml']-$ttJmlRetur['wanita']['jml'];
				$hpkatwanita = $ttJmlBeli['wanita']['hp']-$ttJmlRetur['wanita']['rp'];
				
        if($ttJmlBeli['wanita']['jml']!=0){					
					print("<tr class=\"master\"><td colspan=\"4\"><b>Wanita</b></td></tr>");					
					for($i=0;$i<$wanita;$i++){
								print("<tr class=\"isi\"><td>~</td><td>".$str[$i]['wanita']."</td><td align=\"right\">".number_format($jmlB[$i]['wanita'], 0, ",", ".")."</td><td align=\"right\">".number_format($HP[$i]['wanita'], 0, ",", ".")."</td></tr>");
					}
		      print("<tr class=\"isi\"><tr class=\"isi\"><td colspan=\"2\"></td><td align=\"right\">".number_format($ttJmlBeli['wanita']['jml'], 0, ",", ".")."</td><td align=\"right\">".number_format($ttJmlBeli['wanita']['hp'], 0, ",", ".")."</td></tr>");
        }

        if($ttJmlRetur['wanita']['jml']!= 0){
					print("<tr class=\"master\"><td colspan=\"4\"><b>Retur Wanita</b></td></tr>");					
					for($x=0;$x<$wanitaR;$x++){
								print("<tr class=\"isi\"><td>~</td><td>".$strRet[$x]['wanita']."</td><td align=\"right\">".number_format($jmlR[$x]['wanita'], 0, ",", ".")."</td><td align=\"right\">".number_format($rpR[$x]['wanita'], 0, ",", ".")."</td></tr>");
					}
		      print("<tr class=\"isi\"><tr class=\"isi\"><td colspan=\"2\"></td><td align=\"right\">".number_format($ttJmlRetur['wanita']['jml'], 0, ",", ".")."</td><td align=\"right\">".number_format($ttJmlRetur['wanita']['rp'], 0, ",", ".")."</td></tr>");
        }
        
        print("<tr class=\"isi\"><tr class=\"isi\"><td colspan=\"2\" align=\"center\">TOTAL wanita</td><td align=\"right\">".number_format($jmlkatwanita, 0, ",", ".")."</td><td align=\"right\">".number_format($hpkatwanita, 0, ",", ".")."</td></tr>");
/* ANAK -------------------------------------------------------------------------*/
				$jmlkatanak = $ttJmlBeli['anak']['jml']-$ttJmlRetur['anak']['jml'];
				$hpkatanak = $ttJmlBeli['anak']['hp']-$ttJmlRetur['anak']['rp'];
				
        if($ttJmlBeli['anak']['jml']!=0){					
					print("<tr class=\"master\"><td colspan=\"4\"><b>Anak</b></td></tr>");					
					for($i=0;$i<$anak;$i++){
								print("<tr class=\"isi\"><td>~</td><td>".$str[$i]['anak']."</td><td align=\"right\">".number_format($jmlB[$i]['anak'], 0, ",", ".")."</td><td align=\"right\">".number_format($HP[$i]['anak'], 0, ",", ".")."</td></tr>");
					}
		      print("<tr class=\"isi\"><tr class=\"isi\"><td colspan=\"2\"></td><td align=\"right\">".number_format($ttJmlBeli['anak']['jml'], 0, ",", ".")."</td><td align=\"right\">".number_format($ttJmlBeli['anak']['hp'], 0, ",", ".")."</td></tr>");
        }

        if($ttJmlRetur['anak']['jml']!= 0){
					print("<tr class=\"master\"><td colspan=\"4\"><b>Retur Anak</b></td></tr>");					
					for($x=0;$x<$anakR;$x++){
								print("<tr class=\"isi\"><td>~</td><td>".$strRet[$x]['anak']."</td><td align=\"right\">".number_format($jmlR[$x]['anak'], 0, ",", ".")."</td><td align=\"right\">".number_format($rpR[$x]['anak'], 0, ",", ".")."</td></tr>");
					}
		      print("<tr class=\"isi\"><tr class=\"isi\"><td colspan=\"2\"></td><td align=\"right\">".number_format($ttJmlRetur['anak']['jml'], 0, ",", ".")."</td><td align=\"right\">".number_format($ttJmlRetur['anak']['rp'], 0, ",", ".")."</td></tr>");
        }
        
        print("<tr class=\"isi\"><tr class=\"isi\"><td colspan=\"2\" align=\"center\">TOTAL Anak</td><td align=\"right\">".number_format($jmlkatanak, 0, ",", ".")."</td><td align=\"right\">".number_format($hpkatanak, 0, ",", ".")."</td></tr>");
/* SEPATU -------------------------------------------------------------------------*/
				$jmlkatsepatu = $ttJmlBeli['sepatu']['jml']-$ttJmlRetur['sepatu']['jml'];
				$hpkatsepatu = $ttJmlBeli['sepatu']['hp']-$ttJmlRetur['sepatu']['rp'];
				
        if($ttJmlBeli['sepatu']['jml']!=0){					
					print("<tr class=\"master\"><td colspan=\"4\"><b>Sepatu</b></td></tr>");					
					for($i=0;$i<$sepatu;$i++){
								print("<tr class=\"isi\"><td>~</td><td>".$str[$i]['sepatu']."</td><td align=\"right\">".number_format($jmlB[$i]['sepatu'], 0, ",", ".")."</td><td align=\"right\">".number_format($HP[$i]['sepatu'], 0, ",", ".")."</td></tr>");
					}
		      print("<tr class=\"isi\"><tr class=\"isi\"><td colspan=\"2\"></td><td align=\"right\">".number_format($ttJmlBeli['sepatu']['jml'], 0, ",", ".")."</td><td align=\"right\">".number_format($ttJmlBeli['sepatu']['hp'], 0, ",", ".")."</td></tr>");
        }

        if($ttJmlRetur['sepatu']['jml']!= 0){
					print("<tr class=\"master\"><td colspan=\"4\"><b>Retur Sepatu</b></td></tr>");					
					for($x=0;$x<$sepatuR;$x++){
								print("<tr class=\"isi\"><td>~</td><td>".$strRet[$x]['sepatu']."</td><td align=\"right\">".number_format($jmlR[$x]['sepatu'], 0, ",", ".")."</td><td align=\"right\">".number_format($rpR[$x]['sepatu'], 0, ",", ".")."</td></tr>");
					}
		      print("<tr class=\"isi\"><tr class=\"isi\"><td colspan=\"2\"></td><td align=\"right\">".number_format($ttJmlRetur['sepatu']['jml'], 0, ",", ".")."</td><td align=\"right\">".number_format($ttJmlRetur['sepatu']['rp'], 0, ",", ".")."</td></tr>");
        }
        
        print("<tr class=\"isi\"><tr class=\"isi\"><td colspan=\"2\" align=\"center\">TOTAL Sepatu</td><td align=\"right\">".number_format($jmlkatsepatu, 0, ",", ".")."</td><td align=\"right\">".number_format($hpkatsepatu, 0, ",", ".")."</td></tr>");

        $ttjml = $jmlkatpria + $jmlkatwanita + $jmlkatanak + $jmlkatsepatu;
        $ttrp = $rpkatpria + $rpkatwanita + $rpkatanak + $rpkatsepatu;
        $tthp = $hpkatpria + $hpkatwanita + $hpkatanak + $hpkatsepatu;
        
	      print("<tr class=\"isi\"><td colspan=\"2\" align=\"center\">T O T A L  : </td>
        <td align=\"right\">".number_format($ttjml, 0, ",", ".")."</td>
        <td align=\"right\">".number_format($tthp, 0, ",", ".")."</td></tr>");

				print("</table><br/>");
			}else{
				echo "Belum ada data pembelian untuk tanggal tersebut!";			
			}		
		}	
	}
?>