Esempio n. 1
0
		mysql_close($con);
	}

    require_once('RGrid.php');
   
    $params['hostname'] = 'localhost';
    $params['username'] = '******';
    $params['password'] = '******';
    $params['database'] = 'npcc';

    $sql = "SELECT gentype_id,
                   gentype_desc
              FROM gentype
    	      ORDER BY gentype_id ASC";

    $grid = RGrid::Create($params, $sql);

    /**    Sorting Flag True/False   */
	$grid->allowSorting = false;
        
    /**    Turn the column headers True/False  */
   $grid->showHeaders = true;
    
    /**    * GRID Header    */
//    $grid->SetHeaderHTML('<div style="text-align: center">[This the (static) header HTML]</div>');

    /**		Sets nice(r) display names instead of the raw column names    */
	$grid->SetDisplayNames(array('gentype_id' => '   ID   ',
                                 'gentype_desc' => '       Generation Type       '));

    /**    This hides a column from the result set. It would of course be easier and
Esempio n. 2
0
 /**
  * Sort an array based datagrid
  */
 private function _sortArray($a, $b)
 {
     if (empty(RGrid::$orderby)) {
         RGrid::$orderby = key($a);
         RGrid::$orderdir = 1;
         // Ascending
     }
     // Ascending
     if (RGrid::$orderby['direction']) {
         if ($a[RGrid::$orderby['column']] > $b[RGrid::$orderby['column']]) {
             return 1;
         } elseif ($a[RGrid::$orderby['column']] < $b[RGrid::$orderby['column']]) {
             return -1;
         } else {
             return 0;
         }
         // Descending
     } else {
         if ($a[RGrid::$orderby['column']] > $b[RGrid::$orderby['column']]) {
             return -1;
         } elseif ($a[RGrid::$orderby['column']] < $b[RGrid::$orderby['column']]) {
             return 1;
         } else {
             return 0;
         }
     }
 }