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; }