protected function dtgDatagrid_Bind() { // Because we want to enable pagination AND sorting, we need to setup the $objClauses array to send to LoadAll() // Remember! We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below $this->dtgDatagrid->TotalItemCount = Datagrid::CountAll(); // Setup the $objClauses Array $objClauses = array(); // If a column is selected to be sorted, and if that column has a OrderByClause set on it, then let's add // the OrderByClause to the $objClauses array if ($objClause = $this->dtgDatagrid->OrderByClause) { array_push($objClauses, $objClause); } // Add the LimitClause information, as well if ($objClause = $this->dtgDatagrid->LimitClause) { array_push($objClauses, $objClause); } // Set the DataSource to be the array of all Datagrid objects, given the clauses above $this->dtgDatagrid->DataSource = Datagrid::LoadAll($objClauses); }
public function dtgDatagrid_Bind() { // Get Total Count b/c of Pagination $this->dtgDatagrid->TotalItemCount = Datagrid::CountAll(); $objClauses = array(); if ($objClause = $this->dtgDatagrid->OrderByClause) { array_push($objClauses, $objClause); } if ($objClause = $this->dtgDatagrid->LimitClause) { array_push($objClauses, $objClause); } $this->dtgDatagrid->DataSource = Datagrid::LoadAll($objClauses); }