PHP Subjects::where方法代码示例

 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);
     }
 }