php - Laravel chaining scope queries -

-

i have 2 scope queries db.

the data query looks this:

   {        year: "2015",        term: "summer",        subject_code: "digm",        course_no: "350",        instr_type: "lab",        instr_method: "face face",        section: "003",        crn: "42953",        course_title: "digital storytelling",        credits: "3.0",        day: "r",        time: "06:30 pm - 09:20 pm",        instructor: "teacher name",        campus: "university building",        max_enroll: "18",        enroll: "18",        building: "place",        room: null,        description: "by surfing internet , playing computer games, lectures, assigned readings, class screening, , research projects, class explores impact of digital media on art, design , daily living. writing intensive course. ",        pre_reqs: "",        co_reqs: ""    }

search looks items based on user input, name of course, or instructors

/**  * search course title or subject name  * @param $query  * @param $searchterm course title or subject name i.e. "ecec 355" or  *                    "digital logic"  * @return mixed  */ public function scopesearch($query, $searchterm) {     return $query         ->where('course_title', 'like', '%' . $searchterm . '%')         ->orwhere(db::raw("subject_code || ' ' ||  course_no"),             'like',             '%' . $searchterm . '%'         )         ->orwhere('instructor', 'like', '%' . $searchterm . '%')         ; }

the following scope queries returns lectures. tried query this: $class->lectures()->get() , works - pulls lectures.

public function scopelectures($query) {     return $query         ->where('instr_type', 'like', lecture) // lecture constant         ; }

however, if chain scope queries together:

$class::search('digm 350')->lecture()->get();

i results of search instead of search->lab.

not quite sure why.

the reason ors in search. when apply both scopes query generated is:

where `course_title` ? or subject_code || ' ' ||  course_no ? or `instructor` ? , `instr_type` ?

while need is

where (`course_title` ? or subject_code || ' ' ||  course_no ? or `instructor` ? , `instr_type` ?)

notice constraints first scope have been put in parentheses.

you need change way apply constraints in search scope:

public function scopesearch($query, $searchterm) {   return $query->where(function($query) use ($searchterm) {     $query       ->where('course_title', 'like', '%' . $searchterm . '%')       ->orwhere(db::raw("subject_code || ' ' ||  course_no"), 'like', '%' . $searchterm . '%')       ->orwhere('instructor', 'like', '%' . $searchterm . '%');  });

}


Comments

Post a Comment

Popular posts from this blog

python - argument must be rect style object - Pygame -

-
disclaimer: know other people on site have had error it's been in different contexts , fixes don't seem work here. hey stackoverflow, i've been making sideways space invaders game, ship follows mouse's y position stays on left, , clicking shoots bullet. enemies spawn randomly right , fly left, , objects removed once each side of screen. works fine, when tried implement collision detection see when shot hits enemy, error: typeerror: argument must rect style object. it points line "return hitbox.colliderect(target.rect)". try , work out causing made 'print' lines below see 'target.rect' (and whether proper rect object), , seemed same style shot's own rect, i'm lost why colliderect doesn't accept it. i've annotated pretty everything, sorry if it's insult intelligence should make things easier. class causes problems: class gameobject: def __init__(self, image, height, speed): self.speed = speed self.image...
Read more

c++ - Qt setGeometry: Unable to set geometry -

-
why? setgeometry: unable set geometry 22x22+320+145 on qwidgetwindow/'widgetclasswindow'. resulting geometry: 116x22+320+145 (frame: 8, 30, 8, 8, custom margin: 0, 0, 0, 0, minimum size: 22x22, maximum size: 16777215x16777215). the project is: project.pro qt += core gui greaterthan(qt_major_version, 4): qt += widgets target = untitled5 template = app sources += main.cpp\ widget.cpp headers += widget.h widget.h #ifndef widget_h #define widget_h #include <qwidget> class widget : public qwidget { q_object public: explicit widget(qwidget *parent = 0); ~widget(); private: }; #endif // widget_h widget.cpp #include "widget.h" #include <qvboxlayout> widget::widget(qwidget *parent) : qwidget(parent) { qvboxlayout *vlayout = new qvboxlayout(this); } widget::~widget() { } main.cpp #include "widget.h" #include <qapplication> int main(int argc, char *argv[]) { qapplication a...
Read more

How to resolve Delphi error: Incompatible types: 'PWideChar' and 'Pointer' -

-
i have piece of code delphi 7: var lprgndata: prgndata; pc: pchar; pr: prect; ... pc := @(lprgndata^.buffer[0]); in delphi xe4 gives following compile error: incompatible types: 'pwidechar' , 'pointer' how should code updated work correctly in xe4? thanks whether or not compiles depends upon setting of type-checked pointers option . have enabled option excellent decision. doing results in stricter type checking. with type-checked pointers disabled, code compile. type-checked pointers enabled, code not compile, want because code not valid. now, on types in question. defined in windows unit this: type prgndata = ^trgndata; {$externalsym _rgndata} _rgndata = record rdh: trgndataheader; buffer: array[0..0] of byte; reserved: array[0..2] of byte; end; trgndata = _rgndata; {$externalsym rgndata} rgndata = _rgndata; the benefit of using type-checked pointers compiler can tell doing not valid. knows lprgndat...
Read more