public function testSort()
{
$idPart = Part::select('parts.id')->join('types', 'types.id', '=', 'parts.part_type_id')->where('types.entity_key', 'part')->where('types.name', 'sensor')->first()['id'];
factory(\App\Entities\TireSensor::class)->create(['part_id' => $idPart]);
$url = '/part/' . $idPart . '/edit?id=&temperature=&pressure=&battery=&latitude=&longitude=&number=';
$this->visit($url . '&sort=temperature-asc')->see('mdl-cell--1-col mdl-data-table__cell--non-numeric">');
$this->visit($url . '&sort=id-asc')->see('mdl-cell--1-col mdl-data-table__cell--non-numeric">');
$this->visit($url . '&sort=vehicle-desc')->see('mdl-cell--1-col mdl-data-table__cell--non-numeric">');
$this->visit($url . '&sort=vehicle-asc')->see('mdl-cell--1-col mdl-data-table__cell--non-numeric">');
$this->visit($url . '&sort=part-type-desc')->see('mdl-cell--1-col mdl-data-table__cell--non-numeric">');
$this->visit($url . '&sort=part-type-asc')->see('mdl-cell--1-col mdl-data-table__cell--non-numeric">');
$this->visit($url . '&sort=cost-desc')->see('mdl-cell--1-col mdl-data-table__cell--non-numeric">');
$this->visit($url . '&sort=cost-asc')->see('mdl-cell--1-col mdl-data-table__cell--non-numeric">');
}
private function getFleetTireAndSensorParts(&$partsData, $vehicleId = null, $partsIds = null)
{
$partsQuery = Part::select('parts.id', 'parts.position', 'parts.vehicle_id')->join('types', 'parts.part_type_id', '=', 'types.id')->whereNotNull('parts.vehicle_id')->where('parts.company_id', Auth::user()['company_id'])->where('types.name', 'sensor');
if (!empty($vehicleId)) {
$partsQuery = $partsQuery->where('parts.vehicle_id', $vehicleId);
}
if (!empty($partsIds)) {
$partsQuery = $partsQuery->whereIn('parts.id', $partsIds);
}
$partsResult = $partsQuery->get();
$parts = [];
$partsData = [];
if (count($partsResult) > 0) {
foreach ($partsResult as $part) {
$parts[] = $part->id;
$partsData[$part->id]['position'] = $part->position;
$partsData[$part->id]['vehicle_id'] = $part->vehicle_id;
}
}
return $parts;
}
public function getTiresTypeId()
{
$result = Part::select('types.id')->join('models', 'parts.part_model_id', '=', 'models.id')->join('types', 'parts.part_type_id', '=', 'types.id')->where('parts.company_id', Auth::user()['company_id'])->where('types.name', 'tire')->first();
if (!empty($result->id)) {
return $result->id;
} else {
return null;
}
}
