Guest User

Untitled

a guest
May 22nd, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.26 KB | None | 0 0
  1. +++++++++++++++++++++++++++++++++++++++++++++++++++++
  2. DATEADDED DOCTYPE SUBJECT DETAILS
  3. 2018-03-03 9:54:54 DOCUMENT Letter Outgoing
  4. 2018-03-03 8:54:54 PARCEL Mail Incoming
  5. 2018-03-04 8:55:54 PARCEL Mail Incoming
  6. 2018-03-04 8:55:54 DOCUMENT Mail Outgoing
  7. +++++++++++++++++++++++++++++++++++++++++++++++++++++
  8.  
  9. +++++++++++++++++++
  10. DATE: April 3, 2018
  11. DOCUMENT - 1
  12. PARCEL - 1
  13. TOTAL-----------2
  14.  
  15. DATE: April 4, 2018
  16. DOCUMENT - 1
  17. PARCEL - 1
  18. TOTAL-----------2
  19. ++++++++++++++++++++
  20.  
  21. <?php
  22. foreach($page->query('SELECT id,dateAdded,COUNT(*) FROM seclogs GROUP BY DATE(dateAdded) desc') as $row) { ?><tr>
  23. <td><?php echo date("Y-m-d", strtotime($row['dateAdded'])); ?></td>
  24. <td><?php
  25.  
  26. $thisDate=date(strtotime($row['dateAdded']));
  27. foreach($page->query("SELECT id,dateAdded,docType,COUNT(*) FROM seclogs WHERE DATE(dateAdded) LIKE '$thisDate' GROUP BY docType desc") as $row2) {
  28.  
  29. echo $row2['docType']."-".$row2['COUNT(*)']."<br/>"; } ?><br/><b><?php echo "Total: ".$row['COUNT(*)'].""; ?></b> </td>
  30. </tr><?php } ?>
  31.  
  32. +++++++++++++++++++
  33. DATE: April 3, 2018
  34.  
  35.  
  36. TOTAL-----------2
  37.  
  38. DATE: April 4, 2018
  39.  
  40.  
  41. TOTAL-----------2
  42. ++++++++++++++++++++
Add Comment
Please, Sign In to add comment