 | Summary Report
All Outlet |
|
";
$mail->Body .= "Cashier :
";
$db = getDB();
$sql = "select name from vwDOTunaiHdr where TransDate = '".date_format($dates, 'Y-m-d')."' Group by name";
$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 created_date from pos_tbl_transaksi_saldo WHERE tanggal='".date_format($dates, 'Y-m-d')."' ORDER BY created_date asc ";
$stmt1 = $db->prepare($sql1);
$stmt1->execute();
while ($row1 = $stmt1->fetch())
{
$jam1 = date_create($row1[0]);
$mail->Body .= date_format($jam1, 'H:i:s') . " to ";
}
$db = null;
$db = getDB();
$sql2 = "select top 1 created_date, updated_date from pos_tbl_transaksi_saldo WHERE tanggal='".date_format($dates, 'Y-m-d')."' ORDER BY created_date desc ";
$stmt2 = $db->prepare($sql2);
$stmt2->execute();
while ($row2 = $stmt2->fetch()){
$jam2 = date_create($row2[0]);
$mail->Body .= date_format($jam2, 'H:i:s');
}
$db = null;
$mail->Body .= " |
|
| EDC / Payment | Total |
";
$db = getDB();
$sql3 = "EXEC spSalesSamurry '".date_format($dates, 'Y-m-d')."','".date_format($dates, 'Y-m-d')."'";
$stmt3 = $db->prepare($sql3);
$stmt3->execute();
$row3 = $stmt3->fetch();
$mail->Body .= " | CASH | ". number_format($row3[1]) . " |
";
$mail->Body .= " | BNI | ". number_format($row3[2]) . " |
";
$mail->Body .= " | BCA | ". number_format($row3[3]) . " |
";
$mail->Body .= " | OVO | ". number_format($row3[4]) . " |
";
$db = null;
$mail->Body .= "| Item | Quantity |
";
$db = getDB();
$sql4 = "select ItemID, ItemName, SUM(Qnty), UOMName from vwDOTunai where TransDate = '".date_format($dates, 'Y-m-d')."' and Status = 1 Group By ItemID, ItemName, UOMName";
$stmt4 = $db->prepare($sql4);
$stmt4->execute();
while ($row4 = $stmt4->fetch()){
$ItemName = strtolower($row4[1]);
$mail->Body .= " | ". ucfirst($ItemName) . " | ". number_format($row4[2]) . " ". strtolower($row4[3]) . " |
";
}
$db = null;
$mail->Body .= "
Download aplikasi Point Of Sale Kara Island
 |
";
$mail->Body .= "