function getEvent($action,$REQUEST,$group_id=0,$menu_id=0){ $grid = new grid(true); $grid->setTable("role_menu_event_group"); $grid->setJoin("INNER JOIN menu_event ON menu_event.id = role_menu_event_group.role_id"); $grid->setManualFilter(" AND role_menu_event_group.group_id = $group_id AND menu_event.menu_id = $menu_id "); $grid->addField( array( "field" =>"role_menu_event_group.role_menu_event_id", "name"=>"event_id", "primary"=>true ) ); $grid->addField( array( "field" =>"role_menu_event_group.is_active", "name"=>"is_active" ) ); $grid->addField( array( "field" =>"menu_event.event_name", "name"=>"event_name" ) ); switch ($action){ case 'doRead': return $grid->doRead($REQUEST); break; case 'doCreate': return $grid->doCreate($REQUEST['data']); break; case 'doUpdate': return $grid->doUpdate($REQUEST['data']); break; case 'doDestroy': return $grid->doDestroy($REQUEST['data']); break; } }
function sortMenu($REQUEST,$parent_id,$update=0){ $grid = new grid(true); $grid->setTable("menu"); $grid->setJoin("LEFT JOIN iconcls ON menu.iconcls = iconcls.clsname"); $grid->setManualFilter(" AND parent_id = '$parent_id'"); $grid->addField(Array('field'=>'menu.id','name'=>'id','primary'=>true)); $grid->addField(Array('field'=>'menu.title','name'=>'title')); $grid->addField(Array('field'=>'iconcls.icon','name'=>'iconcls')); $grid->addField(Array('field'=>'menu.sort_id','name'=>'sort_id')); if ($update) return $grid->doUpdate($REQUEST['data']); else return $grid->doRead($REQUEST); }
function doRead2($REQUEST) { $grid = new grid(true); $grid->setTable("pagu"); $grid->setJoin("INNER JOIN trans ON pagu.id = trans.idpagu"); }