function getChart($REQUEST)
{
$grid = new grid(true);
$grid->setTable("grafik");
$grid->setGroupBy("tahun");
$grid->addField(array("field" => "tahun", "name" => "tahun"));
$grid->addField(array("field" => "SUM(page_view)", "name" => "page_view"));
$grid->addField(array("field" => "SUM(page_visit)", "name" => "page_visit"));
return $grid->doRead($REQUEST);
}
function doRead($REQUEST, $report = 0)
{
$grid = new grid(true);
$grid->setTable("sppk");
//set tablenya
//$grid->setGroupBy($REQUEST['groupBy']);
$grid->addField(array("field" => "id", "name" => "id", "primary" => true));
$grid->addField(array("field" => "jenis", "name" => "jenis"));
$grid->addField(array("field" => "tanggal", "name" => "tanggal"));
$grid->addField(array("field" => "perihal", "name" => "perihal"));
$grid->addField(array("field" => "kode", "name" => "kode"));
$grid->addField(array("field" => "tahun", "name" => "tahun"));
if ($report) {
return $grid->doSql($REQUEST);
} else {
return $grid->doRead($REQUEST);
}
}
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);
}
array(
"field"=>"id",
"name"=>"id"
));
$grid->addField(
array(
"field"=>"title",
"name"=>"title"
));
$grid->addField(
array(
"field"=>"clsname",
"name"=>"clsname"
));
$grid->addField(
array(
"field"=>"icon",
"name"=>"icon"
));
$result = $grid->doRead($_REQUEST);
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . 'GMT');
header('Cache-Control: no-cache, must-revalidate');
header('Pragma: no-cache');
header('Content-Type: application/json');
echo $result;
break;
}
?>
function getUser($action,$REQUEST){
$grid = new grid(true);
$grid->setTable("users");
$grid->setManualFilter(" and user_id <> 1");
$grid->addField(
array(
"field"=>"user_id",
"name"=>"user_id",
"primary"=>true
));
$grid->addField(
array(
"field"=>"user_name",
"name"=>"user_name"
));
$grid->addField(
array(
"field"=>"real_name",
"name"=>"real_name"
));
$grid->addField(
array(
"field"=>"user_password",
"name"=>"user_password"
)
);
$grid->addField(
array(
"field"=>"group_id",
"name"=>"group_id"
)
);
$grid->addField(
array(
"field"=>"date_created",
"name"=>"date_created"
)
);
$grid->addField(
array(
"field"=>"last_login",
"name"=>"last_login"
)
);
$grid->addField(
array(
"field"=>"is_active",
"name"=>"is_active"
)
);
switch ($action){
case 'doRead':
return $this->decodePassword($grid->doRead($REQUEST));
break;
case 'doCreate':
return $this->decodePassword($grid->doCreate($this->encodePassword($REQUEST['data'])));
break;
case 'doUpdate':
return $this->decodePassword($grid->doUpdate($this->encodePassword($REQUEST['data'])));
break;
case 'doDestroy':
return $grid->doDestroy($REQUEST['data']);
break;
}
}
