public function getAll() { $columns = array('address' => 'Property Address', 'last_name' => 'Last Name', 'first_name' => 'First Name', 'renter_id' => 'Renter ID', 'term_start' => 'Start Date', 'term_end' => 'End Date', 'rent' => 'Rent'); $contracts = Contract::join('renters', 'contracts.renter_id', '=', 'renters.id')->join('properties', 'contracts.property_id', '=', 'properties.id')->select('properties.address', 'renters.first_name', 'renters.last_name', 'contracts.*')->get(); return view('contracts.index', compact('contracts', 'columns')); }
public function filterContractsByCarOrDriver($search) { $reg_no = substr($search, 0, strpos($search, 'or')); $driver_name = substr($search, strpos($search, 'or') + 2); if (strpos($driver_name, '-') > 0) { //swap $temp = $driver_name; $driver_name = $reg_no; $reg_no = $temp; } //dd(['1'=>$reg_no,'2'=>$driver_name]); $collection = Contract::join('cars', 'contracts.car_id', '=', 'cars.id')->join('drivers', 'contracts.driver_id', '=', 'drivers.id')->where('cars.reg_no', 'LIKE', $reg_no)->orWhere('drivers.name', 'LIKE', $driver_name)->select('contracts.*')->get(); return $collection; }