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");
}
