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