public function MetaDataBinder() { $condition = QQ::Equal(QQN::Peopledetails()->Owner, $_SESSION['User']); // Remember! We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below if ($this->Paginator) { $this->TotalItemCount = Peopledetails::QueryCount($condition); } // 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->OrderByClause) { array_push($objClauses, $objClause); } // Add the LimitClause information, as well if ($objClause = $this->LimitClause) { array_push($objClauses, $objClause); } // Set the DataSource to be a Query result from Peopledetails, given the clauses above //$condition = QQ::Equal(QQN::Peopledetails()->Owner,$_SESSION['User']); $this->DataSource = Peopledetails::QueryArray($condition, $objClauses); //$this->DataSource = Peopledetails::LoadAll($objClauses); }
protected function GetPeopleData() { $objClauses = array(); array_push($objClauses, QQ::OrderBy(QQN::Peopledetails()->FullName)); if ($objClause = $this->dtrPeople->LimitClause) { array_push($objClauses, $this->dtrPeople->LimitClause); } if ($this->txtSearchPeople->Text != '') { $condition = QQ::OrCondition(QQ::Like(QQN::Peopledetails()->FullName, '%' . $this->txtSearchPeople->Text . '%'), QQ::Like(QQN::Peopledetails()->Email, '%' . $this->txtSearchPeople->Text . '%'), QQ::Like(QQN::Peopledetails()->Phone, '%' . $this->txtSearchPeople->Text . '%')); $result = Peopledetails::QueryArray($condition, $objClause); $this->dtrPeople->DataSource = $result; $this->dtrPeople->TotalItemCount = Peopledetails::QueryCount($condition); } else { $result = Peopledetails::QueryArray(QQ::All(), $objClause); $this->dtrPeople->DataSource = $result; $this->dtrPeople->TotalItemCount = Peopledetails::QueryCount(QQ::All()); } }
/** * Load all Peopledetailses * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query * @return Peopledetails[] */ public static function LoadAll($objOptionalClauses = null) { if (func_num_args() > 1) { throw new QCallerException("LoadAll must be called with an array of optional clauses as a single argument"); } // Call Peopledetails::QueryArray to perform the LoadAll query try { return Peopledetails::QueryArray(QQ::All(), $objOptionalClauses); } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } }
public static function GetContacts($strKeyword = null) { if (!is_null($strKeyword)) { $condition = QQ::AndCondition(QQ::OrCondition(QQ::Like(QQN::Peopledetails()->FullName, '%' . $strKeyword . '%'), QQ::Like(QQN::Peopledetails()->Email, '%' . $strKeyword . '%'), QQ::Like(QQN::Peopledetails()->Address, '%' . $strKeyword . '%'), QQ::Like(QQN::Peopledetails()->Phone, '%' . $strKeyword . '%')), QQ::Equal(QQN::Peopledetails()->Owner, $_SESSION['User'])); $objPeopleArray = Peopledetails::QueryArray($condition); return $objPeopleArray; } else { $condition = QQ::Equal(QQN::Peopledetails()->Owner, $_SESSION['User']); $objPeopleArray = Peopledetails::QueryArray($condition); return $objPeopleArray; } }