function listing() { $date = date('Y-m-d'); $this->_fields = "so.id,so.customer_id,so.order_status,so.created_date,so.total_amount,so.total_items,so.payment_type,u.name"; $this->db->from('sales_order so'); $this->db->join('users u', 'so.customer_id=u.id'); foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { case 'id': $this->db->like('so.id', $value); break; case 'name': $this->db->like('u.name', $value); break; case 'order_status': $this->db->like('so.order_status', $value); break; case 'payment_type': $this->db->like('so.payment_type', $value); break; } } return parent::listing(); }
function listing() { $user_id = $this->session->userdata('admin_data')['id']; $role = $this->session->userdata('admin_data')['role']; if ($role == '2') { $user_id = $this->session->userdata('admin_data')['id']; } else { $user_id = '8'; } $id = $this->session->userdata('id'); $this->_fields = "*,id as id, IF(is_display='1','Active','Inactive') as is_display"; if ($role == '2') { $this->db->where('created_user', $user_id); } else { $this->db->where('updated_user', $user_id); } foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { case 'title': $this->db->like($key, $value); break; } } return parent::listing(); }
function listing() { $this->_fields = "*"; //from $this->db->from($this->_table); //joins //where foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { case 'product_name': $this->db->like("jwb_views.product_name", $value); break; case 'description': $this->db->like("jwb_views.description", $value); break; case 'price': $this->db->like("jwb_views.price", $value); break; } } return parent::listing(); }
function listing() { $user_id = $this->session->userdata('admin_data')['id']; $this->_fields = "sf.*,u.name"; $this->db->from('submitted_forms sf'); $this->db->join('users u', 'u.id=sf.client_id'); if ($user_id != 8) { $this->db->where('client_id', $user_id); } foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { case 'sf.title': $this->db->like('sf.title', $value); break; case 'u.name': $this->db->like('u.name', $value); break; case 'sf.created_date': $this->db->like('sf.created_date', $value); break; } } return parent::listing(); }
function listing() { $this->_fields = "*,id as id, IF(is_active='1','Active','Inactive') as is_active"; foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { case 'lang': $this->db->like($key, $value); break; } } return parent::listing(); }
function listing() { $date = date('Y-m-d'); $this->_fields = "*,id as id"; foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { case 'cat_name': $this->db->like($key, $value); break; } } return parent::listing(); }
function listing() { $id = $this->session->userdata('admin_client_id'); $this->_fields = "*,id as id, IF(is_active='1','Active','Inactive') as is_active"; $this->db->where(array('role' => '3', "created_id" => $id)); foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { case 'name': $this->db->like($key, $value); break; } } return parent::listing(); }
function listing() { $id = $this->session->userdata('id'); $this->_fields = "*,id as id, IF(is_active='1','Active','Inactive') as is_active"; $this->db->where('poster_id', $id); foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { case 'language': $this->db->like($key, $value); break; } } return parent::listing(); }
function listing() { $date = date('Y-m-d'); $user_id = $this->session->userdata('admin_data')['id']; $role = $this->session->userdata('admin_data')['role']; if ($role == '2') { $user_id = $this->session->userdata('admin_data')['id']; } else { $user_id = '8'; } //$this->_fields = "*,id as id, IF(is_active='1','Active','Inactive') as is_active"; $this->_fields = "l.*,l.id as id,a.language,la.id as laid,la.lang, IF(l.is_active='1','Active','Inactive') as is_active"; $this->db->from('lession l'); $this->db->join('lession_attachment a', 'a.lession_id=l.id', 'left'); $this->db->join('language la', 'la.id=a.language', 'left'); $this->db->group_by('l.id'); if ($role == '2') { $this->db->where('l.created_user', $user_id); $this->db->where('l.from <=', $date); $this->db->where('l.to_date >=', $date); } else { $this->db->where('l.updated_user', $user_id); $this->db->where('l.to_date >=', $date); } foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { /*case 'title': $this->db->like($key, $value); break; */ case 'l.title': $this->db->like('l.title', $value); break; case 'la.lang': $this->db->like('la.lang', $value); break; } } return parent::listing(); }
function listing() { $user_id = $this->session->userdata('admin_data')['id']; $role = $this->session->userdata('admin_data')['role']; if ($role == '2') { $user_id = $this->session->userdata('admin_data')['id']; } else { $user_id = '8'; } $id = $this->session->userdata('id'); // $this->_fields = "*,id as id, IF(is_active='1','Active','Inactive') as is_active"; $this->_fields = "ld.*,l.name,ld.id as id,IF(ld.is_active='1','Active','Inactive') as is_active"; $this->db->from('employee ld'); $this->db->join('users l', 'l.id=ld.created_user'); $this->db->group_by('ld.id'); if ($role == '2') { $this->db->where('ld.created_user', $user_id); } else { $this->db->where('ld.created_user', $this->session->userdata("clientid")); } foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { case 'employee_name': $this->db->like('ld.employee_name', $value); break; case 'employee_email': $this->db->like('ld.employee_email', $value); break; case 'emp_id': $this->db->like('ld.emp_id', $value); break; case 'name': $this->db->like('l.name', $value); break; } } return parent::listing(); }
function listing() { $date = date('Y-m-d'); $this->_fields = "a.attr_name,b.id,b.attr_id,b.attr_val,IF(b.is_active='1','Active','Inactive') as is_active"; $this->db->from('attribute a'); $this->db->join('attribute_value b', 'a.id=b.attr_id'); foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { case 'attr_name': $this->db->like($key, $value); break; case 'attr_val': $this->db->like($key, $value); break; } } return parent::listing(); }
function listing() { $this->_fields = "*,id as id, IF(is_active='1','Active','Inactive') as is_active"; $id = $this->session->userdata('admin_data')['id']; $role = $this->session->userdata('admin_data')['role']; if ($role == 1) { $this->db->where('role', 2); } else { $this->db->where(array('role' => 2, 'id' => $id)); } foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { case 'name': $this->db->like($key, $value); break; } } return parent::listing(); }
function listing() { $id = $this->session->userdata('id'); $this->_fields = "a.id as id,l.id as lid,a.language,l.lang, IF(a.is_active='1','Active','Inactive') as is_active"; $this->db->from('language l'); $this->db->join('lession_attachment a', 'a.language=l.id', 'right'); $this->db->group_by('a.id'); $this->db->where('a.lession_id', $id); foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { /* case 'lang': $this->db->like($key, $value); break; */ case 'l.lang': $this->db->like('l.lang', $value); break; } } return parent::listing(); }
function listing() { $user_id = $this->session->userdata('admin_data')['id']; $this->_fields = "ld.*,u.name,le.title"; $this->db->from('sign_off ld'); $this->db->join('employee l', 'l.id=ld.employee_id'); $this->db->join('users u', 'u.id=ld.client_id'); $this->db->join('lession le', 'le.id=ld.lesson_id'); if ($user_id != 8) { $this->db->where('client_id', $user_id); } $this->session->set_userdata('search_field', $this->criteria['search_type']); $this->session->set_userdata('search_value', $this->criteria['search_text']); foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { case 'l.employee_name': $this->db->like('l.employee_name', $value); break; case 'le.title': $this->db->like('le.title', $value); break; case 'ld.created_date': $this->db->like('ld.created_date', $value); break; case 'u.name': $this->db->like('u.name', $value); break; case 'ld.emp_id': $this->db->like('ld.emp_id', $value); break; } } return parent::listing(); }
function listing() { $date = date('Y-m-d'); $this->_fields = "a.id,a.attr_id,a.cat,a.name,a.desc,a.sku,b.cat_name, IF(a.is_active='1','Active','Inactive') as is_active"; $this->db->from('products a'); $this->db->join('category b', 'a.cat=b.id'); foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { case 'cat_name': $this->db->like($key, $value); break; case 'name': $this->db->like($key, $value); break; case 'sku': $this->db->like($key, $value); break; } } return parent::listing(); }
function listing() { $user_id = $this->session->userdata('admin_data')['id']; $this->_fields = "u.id,f.id as form_id,u.name,f.type,f.filename,f.client_id,f.created_date"; $this->db->from('users u'); $this->db->join('forms f', 'f.client_id=u.id'); $this->db->order_by("f.created_date", "desc"); if ($user_id != 8) { $this->db->where('u.id', $user_id); } $this->session->set_userdata('search_field', $this->criteria['search_type']); $this->session->set_userdata('search_value', $this->criteria['search_text']); foreach ($this->criteria as $key => $value) { if (!is_array($value) && strcmp($value, '') === 0) { continue; } switch ($key) { case 'u.name': $this->db->like('u.name', $value); break; case 'f.created_date': $this->db->like('f.created_date', $value); break; case 'f.type': $this->db->like('f.type', $value); break; } } return parent::listing(); }