public function dtgWikiItems_Bind()
{
$objCondition = QQ::All();
if (trim($this->txtTitle->Text)) {
$objCondition = QQ::AndCondition($objCondition, QQ::Like(QQN::WikiItem()->CurrentName, '%' . trim($this->txtTitle->Text) . '%'));
}
if ($strPath = trim($this->txtPath->Text)) {
$strPath = WikiItem::SanitizeForPath($strPath, $intWikiItemTypeId);
$objCondition = QQ::AndCondition($objCondition, QQ::Like(QQN::WikiItem()->Path, $strPath . '%'));
}
if ($intValue = $this->lstWikiItemType->SelectedValue) {
$objCondition = QQ::AndCondition($objCondition, QQ::Equal(QQN::WikiItem()->WikiItemTypeId, $intValue));
}
if (trim($this->txtPostedBy->Text)) {
$objCondition = QQ::AndCondition($objCondition, QQ::Like(QQN::WikiItem()->CurrentPostedByPerson->DisplayName, trim($this->txtPostedBy->Text) . '%'));
}
$this->dtgWikiItems->TotalItemCount = WikiItem::QueryCount($objCondition);
$objClauses = array();
if ($objClause = $this->dtgWikiItems->LimitClause) {
$objClauses[] = $objClause;
}
if ($objClause = $this->dtgWikiItems->OrderByClause) {
$objClauses[] = $objClause;
}
$this->dtgWikiItems->DataSource = WikiItem::QueryArray($objCondition, $objClauses);
}
/**
* Load an array of WikiItem objects,
* by CurrentPostedByPersonId Index(es)
* @param integer $intCurrentPostedByPersonId
* @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
* @return WikiItem[]
*/
public static function LoadArrayByCurrentPostedByPersonId($intCurrentPostedByPersonId, $objOptionalClauses = null)
{
// Call WikiItem::QueryArray to perform the LoadArrayByCurrentPostedByPersonId query
try {
return WikiItem::QueryArray(QQ::Equal(QQN::WikiItem()->CurrentPostedByPersonId, $intCurrentPostedByPersonId), $objOptionalClauses);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
}
$strPath = '/old_downloads/qform_controls';
break;
case 3:
$strType = 'Other';
$strPath = '/old_downloads/other';
break;
case 4:
$strType = 'Langauge Files';
$strPath = '/old_downloads/language_files';
break;
}
$strName = sprintf('Downloads from Old Qcodo.com Website in "%s"', $strType);
$strContent = sprintf('These are user-contributed downloads from the old *Qcodo.com* website in "%s", placed here for historical/archive purposes. ', $strType);
$strContent .= 'For new user-submitted contributions, be sure to check out the "User Contributions":http://www.qcodo.com/qpm/ section of the website. "View All Old Downloads":wiki:/old_downloads';
$strContent .= "\r\n\r\n";
$objWikiItemArray = WikiItem::QueryArray(QQ::In(QQN::WikiItem()->Id, array_keys($arrDownloads[$intIndex])), QQ::OrderBy(QQN::WikiItem()->CurrentName));
foreach ($objWikiItemArray as $objWikiItem) {
$strContent .= sprintf('file. %s', $objWikiItem->Path);
$strContent .= "\r\n\r\n";
}
$objWikiItem = WikiItem::CreateNewItem($strPath, WikiItemType::Page);
$objWikiPage = new WikiPage();
$objWikiPage->Content = trim($strContent);
$objWikiPage->CompileHtml();
$objWikiItem->CreateNewVersion($strName, $objWikiPage, 'Save', array(), Person::Load(1), null);
}
$objWikiItem = WikiItem::CreateNewItem('/old_downloads', WikiItemType::Page);
$strContent = 'These are user-contributed downloads from the old *Qcodo.com* website, placed here for historical/archive purposes. ';
$strContent .= 'For new user-submitted contributions, be sure to check out the "User Contributions":http://www.qcodo.com/qpm/ section of the website.';
$strContent .= "\r\n\r\n";
$strContent .= 'h2. "QForm Controls":wiki:/old_downloads/qform_controls';
/**
* Main utility method to aid with data binding. It is used by the default BindAllRows() databinder but
* could and should be used by any custom databind methods that would be used for instances of this
* MetaDataGrid, by simply passing in a custom QQCondition and/or QQClause.
*
* If a paginator is set on this DataBinder, it will use it. If not, then no pagination will be used.
* It will also perform any sorting (if applicable).
*
* @param QQCondition $objConditions override the default condition of QQ::All() to the query, itself
* @param QQClause[] $objOptionalClauses additional optional QQClause object or array of QQClause objects for the query
* @return void
*/
public function MetaDataBinder(QQCondition $objCondition = null, $objOptionalClauses = null)
{
// Setup input parameters to default values if none passed in
if (!$objCondition) {
$objCondition = QQ::All();
}
$objClauses = $objOptionalClauses ? $objOptionalClauses : array();
// We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below
if ($this->Paginator) {
$this->TotalItemCount = WikiItem::QueryCount($objCondition, $objClauses);
}
// 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 WikiItem, given the clauses above
$this->DataSource = WikiItem::QueryArray($objCondition, $objClauses);
}