mohon informasinya saya merasa kesulitan cara menjumlahkan transaksi pertanggal.
berikut ini kode yang udah ada :
<?php
$bulan = $_GET['bulan'];
echo date('F Y', strtotime($bulan));?></h5></b></center>
<?php echo"</div>
<div style='height:5px;'></div>";
//$sql = mysql_query("SELECT * FROM tb_detail_penjualan group by timestmp LIKE '%$_GET[bulan]%'") or die(mysql_error());
$sql = mysql_query("SELECT * FROM tb_penjualan where tgl_transaksi LIKE '%$_GET[bulan]%'") or die(mysql_error());
$no = 0;
while($p = mysql_fetch_assoc($sql))
{
$no++;
//$sqla = mysql_fetch_array(mysql_query("SELECT SUM(qty) as qty FROM tb_penjualan group by tgl_traksasi AND timestmp LIKE '%$_GET[bulan]%'"));
$sqla = mysql_fetch_array(mysql_query("SELECT SUM(qty) as qty FROM tb_detail_penjualan WHERE no_transaksi='$p[no_transaksi]' AND timestmp LIKE '%$_GET[bulan]%'"));
//$tglnya = mysql_fetch_array(mysql_query("SELECT COUNT(tgl_transaksi) as count FROM tb_penjualan WHERE timestmp LIKE '%$_GET[bulan]%'"));
}
$transaksi = mysql_fetch_array(mysql_query("SELECT COUNT(no_transaksi) as count FROM tb_penjualan WHERE timestmp LIKE '%$_GET[bulan]%'"));
$qty = mysql_fetch_array(mysql_query("SELECT SUM(qty) as qty FROM tb_detail_penjualan WHERE timestmp LIKE '%$_GET[bulan]%'"));
$total = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE metode='cash' AND timestmp LIKE '%$_GET[bulan]%'"));
$transfer = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE metode='transfer' AND timestmp LIKE '%$_GET[bulan]%'"));
$credit = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE metode='credit card' AND timestmp LIKE '%$_GET[bulan]%'"));
$bca = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='bca' AND timestmp LIKE '%$_GET[bulan]%'"));
$mandiri = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='mandiri' AND timestmp LIKE '%$_GET[bulan]%'"));
$maybank = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='maybank' AND timestmp LIKE '%$_GET[bulan]%'"));
$citibank = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='citibank' AND timestmp LIKE '%$_GET[bulan]%'"));
$bni = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='bni' AND timestmp LIKE '%$_GET[bulan]%'"));
$mega = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='mega' AND timestmp LIKE '%$_GET[bulan]%'"));
$bri = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='bri' AND timestmp LIKE '%$_GET[bulan]%'"));
$cimbniaga = mysql_fetch_array(mysql_query("SELECT SUM(total_harga) as total FROM tb_penjualan WHERE kartu='cimb niaga' AND timestmp LIKE '%$_GET[bulan]%'"));
echo"<table class='w3-table w3-tiny w3-hoverable w3-bordered tbl' cellpadding='0'>
<thead>
<tr class='w3-dark-grey'>
<th><center>Total Golf Cart</center></th>
<th><center>Total Transaksi - Cash</center></th>
<th><center>Total Transaksi - Transfer</center></th>
<th><center>Total Transaksi - Credit Card</center></th>
<th><center>Credit Card - BCA</center></th>
<th><center>Credit Card - Mandiri</center></th>
<th><center>Credit Card - MayBank</center></th>
<th><center>Credit Card - BRI</center></th>
<th><center>Grand Total Transaksi</center></th>
</tr>
</thead>";
echo"<tr>
<td><center><b>".$qty['qty']."</b></center></td>
<td><center><b>".number_format($total['total'])."</b></center></td>
<td><center><b>".number_format($transfer['total'])."</center></b></td>
<td><center><b>".number_format($credit['total'])."</b></center></td>
<td><center><b>".number_format($bca['total'])."</b></center></td>
<td><center><b>".number_format($mandiri['total'])."</b></center></td>
<td><center><b>".number_format($maybank['total'])."</b></center></td>
<td><center><b>".number_format($bri['total'])."</b></center></td>
<td><center><b>".number_format($total['total']+$credit['total']+$transfer['total'])."</b></center></td>
</tr>";
?>
<?php
0 jempol
Belum ada tanggapan