 | Summary Report
";
$db = getDB();
$sql = "select * from tblMstWarehouse where WHSID='".$WHSID."'";
$stmt0 = $db->prepare($sql);
$stmt0->execute();
while ($row0 = $stmt0->fetch())
{
$mail->Body .= "".$row0[1]." |
|
";
}
$db = null;
$mail->Body .= "Cashier :
";
$db = getDB();
$sql = "select CreatedBy from vwPenjualanHdr where TransDate = '".date_format($dates, 'Y-m-d')."' and WHSID='".$WHSID."' Group by CreatedBy";
$stmt = $db->prepare($sql);
$stmt->execute();
while ($row = $stmt->fetch())
{
$mail->Body .= $row[0] . "
";
}
$db = null;
$mail->Body .= "Date :". date_format($dates, 'd-m-Y') ."
From ";
$db = getDB();
$sql1 = "select top 1 CreatedDate from tblTransaksiSaldoHdr WHERE Tanggal='".date_format($dates, 'Y-m-d')."' and OutletId='".$WHSID."' ORDER BY CreatedBy asc ";
$stmt1 = $db->prepare($sql1);
$stmt1->execute();
while ($row1 = $stmt1->fetch())
{
$jam1 = date_create($row1[0]);
$mail->Body .= date_format($jam1, 'h:i:sa') . " to " .date("h:i:sa");
}
$db = null;
$db = getDB();
$mail->Body .= " |
|
";
$mail->Body .= "| Item | Quantity | Price | Disc. | Total |
";
$db = getDB();
$sql7 = "select CategoryNamePOS,SUM(Qnty) as Total, SUM(UnitPrice*Qnty) as SubTotalDrink from vwPenjualan where TransDate ='".date_format($dates, 'Y-m-d')."' AND WHSID='".$WHSID."' AND Status = 1 Group By CategoryNamePOS";
$stmt7 = $db->prepare($sql7);
$stmt7->execute();
while ($row7 = $stmt7->fetch()){
$mail->Body .= "| ".$row7[0]." |
";
$sql4 = "select ItemName, SUM(Qnty) as Total, ROUND(UnitPrice, 0) As UnitPrice, SUM(UnitPrice*Qnty) as SubTotal, CategoryNamePOS from vwPenjualan where TransDate ='".date_format($dates, 'Y-m-d')."' AND WHSID='".$WHSID."' AND Status = 1 GROUP By ItemName, CategoryNamePOS, UnitPrice, Discount1";
$stmt4 = $db->prepare($sql4);
$stmt4->execute();
while ($row4 = $stmt4->fetch()){
if($row7[0] === $row4[4]) {
$TotalItemSales += $row4[3];
$mail->Body .= " | ". $row4[0] . " | ". number_format($row4[1]) . " | ". number_format($row4[2]) . " | 0 | ". number_format($row4[3]) . " |
";
}
}
$mail->Body .= "| Total ".$row7[0]." | ".number_format($row7[1])." | ".number_format($row7[2])." |
";
$mail->Body .= "| |
";
}
$db = null;
$mail->Body .= "| TOTAL ITEM SALES | ". number_format($TotalItemSales) ." |
";
$mail->Body .= "| |
";
$mail->Body .= "| Promo Bundling |
";
$db = getDB();
$sql9 = "select COUNT(Discount1) as JumlahDiskon, Promo_Name, SUM(Discount1) as TotalDiskon from vwPenjualan where TransDate ='".date_format($dates, 'Y-m-d')."' AND WHSID='".$WHSID."' and Status = 1 and Promo_Name IS NOT NULL GROUP By Promo_Name order by Promo_Name";
$stmt9 = $db->prepare($sql9);
$stmt9->execute();
while ($row9 = $stmt9->fetch()){
$TotalDiskon += $row9[2];
$mail->Body .= " | ". $row9[0] . "x ". $row9[1] . " | ". number_format($row9[2]) . " |
";
}
$mail->Body .= "| Total Promo Bundling | ". number_format($TotalDiskon) ." |
";
$mail->Body .= "| |
";
$mail->Body .= "| Discount Member |
";
$db = getDB();
$sql8 = "SELECT COUNT(PromoCode) as TotalPromo, PromoName, SUM(Discount) as GrandTotal FROM vwPenjualanHdr where TransDate ='".date_format($dates, 'Y-m-d')."' AND WHSID='".$WHSID."' and PromoName IS NOT NULL GROUP By PromoName";
$stmt8 = $db->prepare($sql8);
$stmt8->execute();
$TotalBundling = 0;
while ($row8 = $stmt8->fetch()){
$TotalBundling += ceil($row8[2]);
$mail->Body .= "| ". $row8[0] . "x ". $row8[1] . " | ". number_format(ceil($row8[2])) . " |
";
}
if ($TotalBundling === 0){
$mail->Body .= "| No Discount member sales |
";
}
$db = null;
$mail->Body .= "| Total Discount Member | ". number_format($TotalBundling) ." |
";
$mail->Body .= "| |
";
$db = getDB();
$sql3 = "select SUM(Discount) as TotalDiscount from vwPenjualanHdr where TransDate ='".date_format($dates, 'Y-m-d')."' AND WHSID='".$WHSID."' AND Status=1";
$stmt3 = $db->prepare($sql3);
$stmt3->execute();
$row3 = $stmt3->fetch();
// $GrandTotal = $TotalItemSales-ceil($row3[0]);
$mail->Body .= "| REVENUE | Total |
";
$mail->Body .= " | Total Item Sales | ". number_format($TotalItemSales) . " |
";
$mail->Body .= " | Total Promo | (". number_format($TotalDiskon) . ") |
";
$mail->Body .= " | TOTAL REVENUE | ". number_format($TotalItemSales-$TotalDiskon-$TotalBundling) . " |
";
$db = null;
$mail->Body .= "| |
";
$mail->Body .= "| PAYMENT |
";
$db = getDB();
$sql6 = "select COUNT(Payment), Payment, ISNULL(PaymentProvider,''), SUM(GrandTotal) as Total from tblTrnPOSPayment where TransDate ='".date_format($dates, 'Y-m-d')."' AND WHSID='".$WHSID."' and Status=1 GROUP By Payment, ISNULL(PaymentProvider,'') ";
$stmt6 = $db->prepare($sql6);
$stmt6->execute();
while ($row6 = $stmt6->fetch()){
$selisih += ceil($row6[3]);
$mail->Body .= "| ". $row6[0] . "x ". $row6[2] . " ". $row6[1] . " | ". number_format(ceil($row6[3])) . " |
";
}
$db = null;
$mail->Body .= "| TOTAL PAYMENT | ". number_format($selisih) ." |
";
$mail->Body .= "| |
";
$mail->Body .= "
