public function renderCategory($category_id) { $this->render(); $this->subjects->where('ad_category', $category_id); $this->strict = false; $this->type = 'category'; }
public function handleLikedSubjects() { $this->tab = 'likedSubjects'; $res = $this->context->database->table('subject_rating')->select('subject_id, SUM(thumb_up) AS thumb_up, SUM(thumb_down) AS thumb_down')->order('thumb_up DESC, thumb_down')->group('subject_id'); foreach ($res as $key => $row) { $ids[] = $row['subject_id']; } if (isset($ids)) { $this->subjects->where('id', $ids); $this->subjects->order('FIND_IN_SET(subject.id,"' . implode(",", $ids) . '")'); } else { $this->subjects->where('id', '-2'); } $this->refresh(); }
public function renderSubjects($args = NULL) { dump($args); if (key_exists('shire', $args)) { $this->subjects->where('ad_shire', $args['shire']); } if (key_exists('locality', $args)) { $this->subjects->where('ad_locality', $args['locality']); } if (key_exists('category', $args)) { $this->subjects->where('ad_category', $args['category']); } $this->subjects->fetchAd($this->strict); $this->template->setFile(dirname(__FILE__) . '/subjects.latte'); $this->render(); }
public function renderDefault() { $this->template->subjects = $this->places->order('name')->where('subject.id != 1')->group('subject.id')->having('COUNT(:event.id) > 0'); $this->template->approvedPlacesCount = $this->approvedPlacesCount; $this->template->subject_id = $this->subject_id; if ($this->subject_id != 'all') { $this->events->where('subject_id', $this->subject_id)->group('event.id')->having('COUNT(:event_time.id) = 0'); } // vyhledavani if ($this->q) { $this->events->where("event.name LIKE ? OR subject.name LIKE ? OR user.email LIKE ?", "%" . $this->q . "%", "%" . $this->q . "%", "%" . $this->q . "%"); $this->places->where("subject.name LIKE ?", "%" . $this->q . "%"); $this['search']['q']->setDefaultValue($this->q); $this->template->search = TRUE; } else { $this->template->search = FALSE; } if ($this->order == '' && $this->user->isInRole('administrator')) { $this->order = 'updated DESC'; } switch ($this->what) { case self::ANONYMOUS: $this->events->where('subject_id', '1'); $this->template->what = self::ANONYMOUS; break; case self::NOTERM: $this->events->group('event.id')->having('COUNT(:event_time.id) = 0'); $this->template->what = self::NOTERM; break; case self::UPDATED: $this->events->group('event.id')->having('DATEDIFF(NOW(), event.changed) < ' . self::TIME_UPDATED); $this->template->what = self::UPDATED; break; case self::RECENT: $this->events->group('event.id')->having('DATEDIFF(NOW(), event.created) < ' . self::TIME_RECENT); $this->template->what = self::UPDATED; break; case self::TOREVIEW: $this->events->group('event.id')->having('event.reviewed = 0'); $this->template->what = self::TOREVIEW; break; case self::NOTAPPROVED: $this->events->group('event.id')->having('event.approved = 0'); $this->template->what = self::NOTAPPROVED; break; case self::PREFERED: $this->events->group('event.id')->having('event.prefered = 1'); $this->template->what = self::PREFERED; break; default: $this->template->what = self::ALL; } if ($this->orderBy == '' && $this->user->isInRole('administrator')) { $this->orderBy = self::MODIFICATION; } switch ($this->orderBy) { case self::MODIFICATION: $this->events->order('changed DESC, created DESC'); $this->template->orderBy = self::MODIFICATION; break; case self::ALPHABET: default: $this->events->order('name'); $this->template->orderBy = self::ALPHABET; break; } $this->pagerEvents->itemCount = $this->events->count(); $this->template->events = $this->events->limit($this->pagerEvents->getLimit(), $this->pagerEvents->getOffset()); if ($this->user->isInRole('administrator')) { $this->template->nonaproved = $this->context->createServiceEvents()->where('approved', '0'); } }
public function postDeleteSubjects() { $class_id = Input::get('class_id'); $section_id = Input::get('section_id'); $subject_id = Input::get('subject_id'); $subject_name = Input::get('subject_name'); $subject_code = Input::get('subject_code'); if ($subject_id) { $subjects = Subjects::find($subject_id); } else { $subjects = Subjects::where('subject_name', '=', $subject_name)->where('subject_code', '=', $subject_code)->where('class_id', '=', $class_id)->where('section_id', '=', $section_id); } if ($subjects->delete()) { $response = array('status' => 'success', 'msg' => 'Subject deleted successfully', 'result' => array('subjects' => $subjects)); return Response::json($response); } else { $response = array('status' => 'failed', 'msg' => 'Subject is Not deleted', 'result' => array('subjects' => $subjects)); return Response::json($response); } }