Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +++++++++++++++++++++++++++++++++++++++++++++++++++++
- DATEADDED DOCTYPE SUBJECT DETAILS
- 2018-03-03 9:54:54 DOCUMENT Letter Outgoing
- 2018-03-03 8:54:54 PARCEL Mail Incoming
- 2018-03-04 8:55:54 PARCEL Mail Incoming
- 2018-03-04 8:55:54 DOCUMENT Mail Outgoing
- +++++++++++++++++++++++++++++++++++++++++++++++++++++
- +++++++++++++++++++
- DATE: April 3, 2018
- DOCUMENT - 1
- PARCEL - 1
- TOTAL-----------2
- DATE: April 4, 2018
- DOCUMENT - 1
- PARCEL - 1
- TOTAL-----------2
- ++++++++++++++++++++
- <?php
- foreach($page->query('SELECT id,dateAdded,COUNT(*) FROM seclogs GROUP BY DATE(dateAdded) desc') as $row) { ?><tr>
- <td><?php echo date("Y-m-d", strtotime($row['dateAdded'])); ?></td>
- <td><?php
- $thisDate=date(strtotime($row['dateAdded']));
- foreach($page->query("SELECT id,dateAdded,docType,COUNT(*) FROM seclogs WHERE DATE(dateAdded) LIKE '$thisDate' GROUP BY docType desc") as $row2) {
- echo $row2['docType']."-".$row2['COUNT(*)']."<br/>"; } ?><br/><b><?php echo "Total: ".$row['COUNT(*)'].""; ?></b> </td>
- </tr><?php } ?>
- +++++++++++++++++++
- DATE: April 3, 2018
- TOTAL-----------2
- DATE: April 4, 2018
- TOTAL-----------2
- ++++++++++++++++++++
Add Comment
Please, Sign In to add comment