protected function Form_PreRender()
{
$objExpansionMap[UserAccount::ExpandCreatedByObject] = true;
$objExpansionMap[UserAccount::ExpandRole] = true;
// Get Total Count b/c of Pagination
$this->dtgUserAccount->TotalItemCount = UserAccount::CountAll();
if ($this->dtgUserAccount->TotalItemCount == 0) {
$this->dtgUserAccount->ShowHeader = false;
} else {
$objClauses = array();
if ($objClause = $this->dtgUserAccount->OrderByClause) {
array_push($objClauses, $objClause);
}
if ($objClause = $this->dtgUserAccount->LimitClause) {
array_push($objClauses, $objClause);
}
if ($objClause = QQ::Expand(QQN::UserAccount()->CreatedByObject)) {
array_push($objClauses, $objClause);
}
if ($objClause = QQ::Expand(QQN::UserAccount()->Role)) {
$this->dtgUserAccount->DataSource = UserAccount::LoadAll($objClauses);
}
$this->dtgUserAccount->ShowHeader = true;
}
}
public function dtgUserAccount_Bind()
{
// Get Total Count b/c of Pagination
$this->dtgUserAccount->TotalItemCount = UserAccount::CountAll();
$objClauses = array();
if ($objClause = $this->dtgUserAccount->OrderByClause) {
array_push($objClauses, $objClause);
}
if ($objClause = $this->dtgUserAccount->LimitClause) {
array_push($objClauses, $objClause);
}
$this->dtgUserAccount->DataSource = UserAccount::LoadAll($objClauses);
}
public function dtgUserAccount_Bind()
{
$objClauses = array();
if ($objClause = $this->dtgUserAccount->OrderByClause) {
array_push($objClauses, $objClause);
}
$objClause = QQ::Expand(QQN::UserAccount()->CreatedByObject);
array_push($objClauses, $objClause);
$objClause = QQ::Expand(QQN::UserAccount()->Role);
array_push($objClauses, $objClause);
$this->strUsername = $this->txtUsername->Text;
if ($this->strUsername) {
$this->dtgUserAccount->TotalItemCount = UserAccount::QueryCount(QQ::Like(QQN::UserAccount()->Username, '%' . $this->strUsername . '%'), $objClauses);
if ($this->dtgUserAccount->TotalItemCount > 0) {
$this->dtgUserAccount->ShowHeader = true;
// Add the LimitClause information, as well
if ($objClause = $this->dtgUserAccount->LimitClause) {
array_push($objClauses, $objClause);
}
$this->dtgUserAccount->DataSource = UserAccount::QueryArray(QQ::Like(QQN::UserAccount()->Username, '%' . $this->strUsername . '%'), $objClauses);
} else {
$this->dtgUserAccount->ShowHeader = false;
}
} else {
// Get Total Count b/c of Pagination
$this->dtgUserAccount->TotalItemCount = UserAccount::CountAll();
if ($this->dtgUserAccount->TotalItemCount == 0) {
$this->dtgUserAccount->ShowHeader = false;
} else {
if ($objClause = $this->dtgUserAccount->LimitClause) {
array_push($objClauses, $objClause);
}
$this->dtgUserAccount->DataSource = UserAccount::LoadAll($objClauses);
$this->dtgUserAccount->ShowHeader = true;
}
}
}
protected function dtgUserAccount_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->dtgUserAccount->TotalItemCount = UserAccount::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->dtgUserAccount->OrderByClause) {
array_push($objClauses, $objClause);
}
// Add the LimitClause information, as well
if ($objClause = $this->dtgUserAccount->LimitClause) {
array_push($objClauses, $objClause);
}
// Set the DataSource to be the array of all UserAccount objects, given the clauses above
$this->dtgUserAccount->DataSource = UserAccount::LoadAll($objClauses);
}
