Welcome Guest, Not a member yet? Register   Sign In
Use when() in model query
#1

(This post was last modified: 03-03-2024, 08:49 AM by pippuccio76.)

Hi , i have a fullcalendar with data getting from several user , admin can see every events , admin events all , users events only if they aren't not private ( field privata set in db as 0) , this is my query :
Code:
            // on page load this ajax code block will be run
            $data = $event_model->select(
                '
                 
                    events.id,
                    events.start,
                    events.end,
                    events.titolo as title,
                    events.descrizione,
                    events.privata,
                    events.id_users,
                    colori_html.nome as backgroundColor,

                '
            )
            ->where([
                'start >=' => $this->request->getVar('start'),
                'end <='=> $this->request->getVar('end')
            ])
            ->join('users','users.id=events.id_users')
            ->join('colori_html','users.id_colori_html=colori_html.id')
            ->when('events.id_users',!auth()->user()->id) { //where event isn't of user logged
                ->where('events.privata',0)
            }
            ->findAll();

 

but i have error on    ->where('events.privata',0) . How  can i write correctly in model ?
Reply
#2

Read https://codeigniter.com/user_guide/datab....html#when
Reply
#3

(03-03-2024, 07:07 PM)kenjis Wrote: Read https://codeigniter.com/user_guide/datab....html#when

This is not model
Reply
#4

Yes, there is no `when()` method in CodeIgniter's Model class.
Reply




Theme © iAndrew 2016 - Forum software by © MyBB