Example #1
0
 public function updateMenu(DtoMenu $m)
 {
     $subof = null;
     if ($m->getSubof() != '') {
         $subof = $m->getSubof();
     }
     $data = array('title' => $m->getTitle(), 'linkto' => $m->getLinkto(), 'ordering' => $m->getOrdering(), 'subof' => $subof);
     $this->db->where('menuid', $m->getMenuid());
     return $this->db->update('MENUS', $data);
 }
Example #2
0
 public function updateMenu(DtoMenu $menus)
 {
     $this->db->trans_begin();
     $menuid = $menus->getMenuid();
     // UPDATE MENU
     $menu = array("ordering" => $menus->getOrdering(), "linkto" => $menus->getLinkto(), "level" => $menus->getLevel() == "" ? '0' : $menus->getLevel(), "subof" => $menus->getSubof() == "" ? null : $menus->getSubof());
     $this->db->where('menuid', $menuid);
     $this->db->update('MENUS', $menu);
     // UDPDATE MAIN MENU
     foreach ($menus->getMenuDetails() as $menuDetails) {
         $this->db->where('menuid', $menuid);
         $this->db->where('languageid', $menuDetails['languageid']);
         $this->db->update('MENUDETAIL', $menuDetails);
     }
     if ($this->db->trans_status() === FALSE) {
         $this->db->trans_rollback();
         return FALSE;
     } else {
         $this->db->trans_commit();
         return TRUE;
     }
 }