public static function getEmployees($id, $employees) { $offeredServices = OfferedServices::findByService($id); $employeeList = array(); foreach ($employees as $employee) { foreach ($offeredServices as $serv) { if ($employee == $serv) { $employeeList[] = $employee; } } } return $employeeList; }
public function save() { $query = DB::connection()->prepare('INSERT INTO Offered_services (employeeid, serviceid) VALUES (:employeeid, :serviceid)'); $employees = OfferedServices::findByService($this->serviceid); if (empty($employees)) { $query->execute(array('employeeid' => $this->employeeid, 'serviceid' => $this->serviceid)); } else { $duplicates = array(); foreach ($employees as $employee) { if ($employee->id == $this->employeeid) { $duplicates = $employee; break; } } if (empty($duplicates)) { $query->execute(array('employeeid' => $this->employeeid, 'serviceid' => $this->serviceid)); } } // // $row = $query->fetch(); // $this->id = $row['id']; }
public static function show($id) { $service = Service::find($id); $offeredServices = OfferedServices::findByService($id); View::make('service/show.html', array('service' => $service, 'offeredServices' => $offeredServices)); }