public function load($staff_id) { $data = $this->wpdb->get_results(' SELECT c.name AS category_name, s.* FROM ' . AB_Category::getTableName() . ' c INNER JOIN ' . AB_Service::getTableName() . ' s ON c.id = s.category_id ', ARRAY_A); if (!$data) { $data = array(); } $this->uncategorized_services = AB_Service::query('s')->where('s.category_id', null)->fetchArray(); $staff_services = AB_StaffService::query('ss')->select('ss.service_id, ss.price, ss.capacity')->where('ss.staff_id', $staff_id)->fetchArray(); if ($staff_services) { foreach ($staff_services as $staff_service) { $this->selected[$staff_service['service_id']] = array('price' => $staff_service['price'], 'capacity' => $staff_service['capacity']); } } foreach ($data as $row) { if (!isset($this->collection[$row['category_id']])) { $abCategory = new AB_Category(); $abCategory->set('id', $row['category_id']); $abCategory->set('name', $row['category_name']); $this->collection[$row['category_id']] = $abCategory; } unset($row['category_name']); $abService = new AB_Service($row); $this->category_services[$row['category_id']][] = $abService->get('id'); $this->collection[$row['category_id']]->addService($abService); } }
public function load($staff_id) { $data = $this->wpdb->get_results(' SELECT c.name AS category_name, s.* FROM ab_category c INNER JOIN ab_service s ON c.id = s.category_id ', ARRAY_A); if (!$data) { $data = array(); } $uncategorized_services = $this->wpdb->get_results('SELECT * FROM ab_service WHERE category_id IS NULL'); foreach ($uncategorized_services as $uncategorized_service) { $abService = new AB_Service(); $abService->setData($uncategorized_service); $this->uncategorized_services[] = $abService; } $rows = $this->wpdb->get_results($this->wpdb->prepare(' SELECT s.service_id, s.price, s.capacity FROM ab_staff_service s WHERE s.staff_id = %d ', $staff_id)); if ($rows) { foreach ($rows as $row) { $this->selected[$row->service_id] = array('price' => $row->price, 'capacity' => $row->capacity); } } foreach ($data as $row) { if (!isset($this->collection[$row['category_id']])) { $abCategory = new AB_Category(); $abCategory->set('id', $row['category_id']); $abCategory->set('name', $row['category_name']); $this->collection[$row['category_id']] = $abCategory; } unset($row['category_name']); $abService = new AB_Service(); $abService->setData($row); $this->category_services[$row['category_id']][] = $abService->get('id'); $this->collection[$row['category_id']]->addService($abService); } }
/** * Delete category. */ public function executeDeleteCategory() { $category = new AB_Category(); $category->set('id', $this->getParameter('id', 0)); $category->delete(); }