private function getFleetGpsData($updateDatetime = null, $vehicleId = null) { $gpsQuery = Gps::where('company_id', Auth::user()['company_id']); if (!empty($updateDatetime)) { $gpsQuery = $gpsQuery->where('created_at', '>', $updateDatetime); } if (!empty($vehicleId)) { $gpsQuery = $gpsQuery->where('vehicle_id', $vehicleId); } $gpsQuery = $gpsQuery->orderBy('created_at', 'asc')->get(); $gpsData = []; if (!empty($gpsQuery)) { foreach ($gpsQuery as $gps) { $objGps = new \stdClass(); $objGps->latitude = HelperRepository::manageEmptyValue($gps->latitude); $objGps->longitude = HelperRepository::manageEmptyValue($gps->longitude); $gpsData[$gps->vehicle_id] = $objGps; } } return $gpsData; }
public function getTireAndSensorData($inputs) { $tire = Part::join('types', 'parts.part_type_id', '=', 'types.id')->where('parts.position', $inputs['position'])->where('parts.vehicle_id', $inputs['vehicle_id'])->where('parts.company_id', Auth::user()['company_id'])->where('types.name', 'tire')->first(); $objTire = new \stdClass(); if (!empty($tire)) { $sensor = TireSensor::join('parts', 'tire_sensor.part_id', '=', 'parts.id')->join('types', 'parts.part_type_id', '=', 'types.id')->where('parts.part_id', $tire->id)->where('parts.position', $inputs['position'])->where('parts.vehicle_id', $inputs['vehicle_id'])->where('parts.company_id', Auth::user()['company_id'])->where('types.name', 'sensor')->orderBy('parts.id', 'desc')->first(); $objTire->position = HelperRepository::manageEmptyValue($tire->position); $objTire->number = HelperRepository::manageEmptyValue($tire->number); $objTire->model = HelperRepository::manageEmptyValue($tire->partModel->name); $objTire->lifecycle = HelperRepository::manageEmptyValue($tire->lifecycle); $objTire->miliage = HelperRepository::manageEmptyValue($tire->miliage); } else { $objTire->position = ""; $objTire->number = ""; $objTire->model = ""; $objTire->lifecycle = ""; $objTire->miliage = ""; } if (!empty($sensor)) { $objTire->temperature = HelperRepository::manageEmptyValue($sensor->temperature); $objTire->pressure = HelperRepository::manageEmptyValue($sensor->pressure); $objTire->battery = HelperRepository::manageEmptyValue($sensor->battery); $objTire->sensorNumber = HelperRepository::manageEmptyValue($sensor->number); } else { $objTire->temperature = ""; $objTire->pressure = ""; $objTire->battery = ""; $objTire->sensorNumber = ""; } return $objTire; }