market_mypasar.pehape

<?php
if(count($_POST)) {
        $mysqlhost = "localhost";
        $mysqluser = "mysqluser";
        $mysqlpass = "mysqlpass";
        $mydb = "skripsi";
        $mysqlId = mysqli_connect($mysqlhost,$mysqluser,$mysqlpass,$mydb);
        mysqli_query($mysqlId,"SET time_zone = '+7:00'");

        date_default_timezone_set('Asia/Jakarta');
        // dataString = 'tmulai='+tmulai+'&id_pasar='+id_pasar;
        $tmulai   = $_POST['tmulai'];
        $id_p = $_POST['id_pasar'];
        $tsampai = $tmulai+(5*86400);

        $tglm = date("Y-m-d",$tmulai);
        $tgls = date("Y-m-d",$tsampai);

        $query = "select pasar from `pasar` where id_pasar='$id_p'";
        $result = mysqli_query($mysqlId,$query);
        list($pasar) = mysqli_fetch_row($result);
        mysqli_free_result($result);

        echo "<table cellspacing=2 cellpadding=0 align=center border=0>\n";
        echo "<tr><th height=24 colspan=9><font size=3>$pasar</font></th></tr>\n";

        $query = "select tanggal from transaksi where id_pasar='$id_p' and tanggal between '$tglm' and '$tgls'";
        $result = mysqli_query($mysqlId,$query);
        if(!mysqli_num_rows($result)) {
                echo "<tr bgcolor=#ffdddd><td align=center class=xonlinl colspan=9 width=400><b><font size=2>....data tidak ada....</font></b></td></tr></table>\n";
        } else {
                mysqli_free_result($result);
                $arrhr = array("","Senin","Selasa","Rabu","Kamis","Jumat","Sabtu");
                $atg = array();
                echo "<tr><th rowspan=2>&nbsp;Bahan Pokok & Jenis&nbsp;</th><th rowspan=2>&nbsp;Satuan&nbsp;</th>
                        <th colspan=6 height=22>Hari Tanggal (Harga Rp)</th><th rowspan=2>&nbsp;Rata<br>&nbsp;Rata(Rp)&nbsp;</th></tr>
                        <tr>";
                for($i=0;$i<6;$i++) {
                        $t = $tmulai + ($i*86400);
                        $w = date("w",$t);
                        $hari = $arrhr[$w];
                        $tgl = date("d-m-y",$t);
                        $atg[] = date("Y-m-d",$t);
                        echo "<th>$hari<br>&nbsp;$tgl&nbsp;</th>\n";
                }
                echo "</tr>";
                $query = "select t.id_jenis,j.jenis,s.satuan_pendek,b.id_bahan_pokok,b.bahan_pokok from transaksi t
                        left join jenis j on j.id_jenis=t.id_jenis
                        left join bahan_pokok b on b.id_bahan_pokok=j.id_bahan_pokok
                        left join satuan s on s.id_satuan=j.id_satuan
                        where id_pasar='$id_p' and tanggal between '$tglm' and '$tgls'
                        group by j.jenis order by b.id_bahan_pokok,j.jenis";

                $result = mysqli_query($mysqlId,$query);
                $j = 0;
                $oldbahan = 0;
                while(list($idjenis,$jenis,$satuan,$idbahan,$bahan) = mysqli_fetch_row($result) ) {
                        $j++;
                        $bg = $j%2 ? "bgcolor=#ddffdd" : "bgcolor=#fefefe";
                        if($idbahan != $oldbahan) {
                                $oldbahan = $idbahan;
                                echo "<tr height=20 $bg><td class=xonlinel colspan=9>&nbsp;&#149; <b>$bahan</b></td></tr>\n";
                        }

                        echo "<tr height=20 $bg><td class=xonlinel>&nbsp;- $jenis&nbsp;</td><td class=xonline>&nbsp;$satuan&nbsp;</td>\n";
                        $query = "select j.id_jenis,
(select t0.harga from transaksi t0 where t0.id_pasar='$id_p' and t0.id_jenis=j.id_jenis and t0.tanggal='".$atg[0]."') '".$atg[0]."',
(select t1.harga from transaksi t1 where t1.id_pasar='$id_p' and t1.id_jenis=j.id_jenis and t1.tanggal='".$atg[1]."') '".$atg[1]."',
(select t2.harga from transaksi t2 where t2.id_pasar='$id_p' and t2.id_jenis=j.id_jenis and t2.tanggal='".$atg[2]."') '".$atg[2]."',
(select t3.harga from transaksi t3 where t3.id_pasar='$id_p' and t3.id_jenis=j.id_jenis and t3.tanggal='".$atg[3]."') '".$atg[3]."',
(select t4.harga from transaksi t4 where t4.id_pasar='$id_p' and t4.id_jenis=j.id_jenis and t4.tanggal='".$atg[4]."') '".$atg[4]."',
(select t5.harga from transaksi t5 where t5.id_pasar='$id_p' and t5.id_jenis=j.id_jenis and t5.tanggal='".$atg[5]."') '".$atg[5]."' from jenis j where j.id_jenis='$idjenis'";

                        $res = mysqli_query($mysqlId,$query);
                        list($id,$p1,$p2,$p3,$p4,$p5,$p6) = mysqli_fetch_row($res);
                        mysqli_free_result($res);
                        $ttl = $p1 + $p2 + $p3 + $p4 + $p5 + $p6;
                        $pembagi = 0;
                        $cp1 = "-";
                        if($p1) { $cp1 = number_format($p1,0,',','.'); $pembagi++; }
                        $cp2 = "-";
                        if($p2) { $cp2 = number_format($p2,0,',','.'); $pembagi++; }
                        $cp3 = "-";
                        if($p3) { $cp3 = number_format($p3,0,',','.'); $pembagi++; }
                        $cp4 = "-";
                        if($p4) { $cp4 = number_format($p4,0,',','.'); $pembagi++; }
                        $cp5 = "-";
                        if($p5) { $cp5 = number_format($p5,0,',','.'); $pembagi++; }
                        $cp6 = "-";
                        if($p6) { $cp6 = number_format($p6,0,',','.'); $pembagi++; }
                        $avg = $pembagi ? $ttl/$pembagi:$ttl;
                        $cav = number_format($avg,0,',','.');
                        echo "<td class=xonline align=right>&nbsp;$cp1&nbsp;</td><td class=xonline align=right>&nbsp;$cp2&nbsp;</td>
                        <td class=xonline align=right>&nbsp;$cp3&nbsp;</td><td class=xonline align=right>&nbsp;$cp4&nbsp;</td>
                        <td class=xonline align=right>&nbsp;$cp5&nbsp;</td><td class=xonline align=right>&nbsp;$cp6&nbsp;</td>
                        <td class=xonline align=right>&nbsp;<b>$cav</b>&nbsp;</td></tr>\n";

                }
                mysqli_free_result($result);
                echo "</table>
                <br><br><br><br>
                <br><br><br><br>\n";
        }
}
?>