Weekly Sales Report
= CURDATE()"); while($row = mysql_fetch_array($result1)){ $total= $row['SUM(received)']; echo "today Sale".$row['SUM(received)']."
"; } $result1 = mysql_query("SELECT received, SUM(received) FROM sales WHERE sale_time >= DATE_SUB(CURDATE(), INTERVAL 1 DAY) AND sale_time < CURDATE()"); while($row = mysql_fetch_array($result1)){ $total= $row['SUM(received)']; echo "Yesterday Sale".$row['SUM(received)']."
"; } $result1 = mysql_query("SELECT received, SUM(received) FROM sales WHERE sale_time >= DATE_SUB(CURDATE(), INTERVAL DAYOFMONTH(CURDATE())-1 DAY)"); while($row = mysql_fetch_array($result1)){ $total= $row['SUM(received)']; echo "This Month Sale".$row['SUM(received)']."
"; } */ $result1 = mysql_query("SELECT received, SUM(received) FROM sales WHERE sale_time >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND sale_time <= CURDATE()"); while($row = mysql_fetch_array($result1)){ $total= $row['SUM(received)']; //echo "Seven Day Sale".$row['SUM(received)']."
"; } $result = mysql_query("SELECT * FROM sales WHERE sale_time >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND sale_time <= CURDATE()"); echo "
| Date | Invoice No | Customer | Amount | Paid | Balance | Comments | Actions | "; echo "
|---|---|---|---|---|---|---|---|
| ".$row['sale_time']." | ".$row['invoice']. " | " .$row['customer_name']. " | " .$row['payment']. " | ".$row['received']. " | ".$row['balance']. " | ".$row['comments']. " | Detail"; echo " |
| Totat Sale Rs.".$total." | |||||||