service_report.php 645 B

1234567891011121314
  1. <?php
  2. $serviceSql = "SELECT *,
  3. servicehistory.CreatedAt AS ServiceHistoryCreatedAt,
  4. servicehistory.UpdatedAt AS ServiceHistoryUpdatedAt
  5. FROM servicehistory servicehistory
  6. WHERE servicehistory.IsActive='1' $serviceSqlfilter";
  7. $serviceRes = mysqli_query($conn, $serviceSql);
  8. if ($serviceRes->num_rows > 0) {
  9. $id = 0;
  10. foreach ($serviceRes as $servicerow) {
  11. $id++;
  12. $services = array_merge($services, array(array($id, $servicerow['ServiceHistoryID'], $servicerow['AssetID'], $servicerow['isServiced'], $servicerow['InWard'], $servicerow['outWard'], $servicerow['ServiceHistoryCreatedAt'], $servicerow['ServiceHistoryUpdatedAt'])));
  13. }
  14. }