| 1234567891011121314 |
- <?php
- $serviceSql = "SELECT *,
- servicehistory.CreatedAt AS ServiceHistoryCreatedAt,
- servicehistory.UpdatedAt AS ServiceHistoryUpdatedAt
- FROM servicehistory servicehistory
- WHERE servicehistory.IsActive='1' $serviceSqlfilter";
- $serviceRes = mysqli_query($conn, $serviceSql);
- if ($serviceRes->num_rows > 0) {
- $id = 0;
- foreach ($serviceRes as $servicerow) {
- $id++;
- $services = array_merge($services, array(array($id, $servicerow['ServiceHistoryID'], $servicerow['AssetID'], $servicerow['isServiced'], $servicerow['InWard'], $servicerow['outWard'], $servicerow['ServiceHistoryCreatedAt'], $servicerow['ServiceHistoryUpdatedAt'])));
- }
- }
|