/**
* Main DataGen Runner
* @return void
*/
public static function Run()
{
// Run "Fake Data" SQL Script
$strFakeDataSql = file_get_contents(__DOCROOT__ . '/../database/fake_data.sql');
foreach (explode("\n", $strFakeDataSql) as $strSql) {
$strSql = trim($strSql);
if (strlen($strSql) && substr($strSql, 0, 1) != '#') {
Person::GetDatabase()->NonQuery($strSql);
}
}
self::$SystemStartDate = new QDateTime('1990-01-01');
self::$LifeStartDate = new QDateTime('1930-01-01');
self::$OldestChildBirthDate = QDateTime::Now(false);
self::$OldestChildBirthDate->Year -= 18;
// Get Cached Data
self::$CommentCategoryArray = CommentCategory::LoadAll();
// Erase Directories
exec('rm -r -f ' . __DOCROOT__ . '/../file_assets/head_shots');
exec('rm -r -f ' . __DOCROOT__ . '/../file_assets/contribution_images');
// Generate Stuff
ChmsDataGen::GenerateMinistries();
ChmsDataGen::GenerateUsers();
ChmsDataGen::GenerateHouseholds();
ChmsDataGen::GenerateStewardship();
self::$MaxPersonId = Person::CountAll();
ChmsDataGen::GenerateCommunicationLists();
ChmsDataGen::GenerateGroups();
}
protected function btnSave_Click($strFormId, $strControlId, $strParameter)
{
$this->txtName->Text = trim($this->txtName->Text);
$this->mctCommentCategory->SaveCommentCategory();
CommentCategory::RefreshOrderNumber();
$this->ReturnToList();
}
public function MoveDown()
{
$blnFound = false;
foreach (CommentCategory::LoadAll(QQ::OrderBy(QQN::CommentCategory()->OrderNumber)) as $objObject) {
if ($blnFound) {
break;
}
if ($objObject->Id == $this->Id) {
$blnFound = true;
}
}
$this->OrderNumber++;
$this->Save();
if ($objObject) {
$objObject->OrderNumber--;
$objObject->Save();
}
self::RefreshOrderNumber();
}
public static function GetSoapArrayFromArray($objArray)
{
if (!$objArray) {
return null;
}
$objArrayToReturn = array();
foreach ($objArray as $objObject) {
array_push($objArrayToReturn, CommentCategory::GetSoapObjectFromObject($objObject, true));
}
return unserialize(serialize($objArrayToReturn));
}
public static function GetSoapObjectFromObject($objObject, $blnBindRelatedObjects)
{
if ($objObject->objPerson) {
$objObject->objPerson = Person::GetSoapObjectFromObject($objObject->objPerson, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intPersonId = null;
}
}
if ($objObject->objPostedByLogin) {
$objObject->objPostedByLogin = Login::GetSoapObjectFromObject($objObject->objPostedByLogin, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intPostedByLoginId = null;
}
}
if ($objObject->objCommentCategory) {
$objObject->objCommentCategory = CommentCategory::GetSoapObjectFromObject($objObject->objCommentCategory, false);
} else {
if (!$blnBindRelatedObjects) {
$objObject->intCommentCategoryId = null;
}
}
if ($objObject->dttDatePosted) {
$objObject->dttDatePosted = $objObject->dttDatePosted->__toString(QDateTime::FormatSoap);
}
if ($objObject->dttDateAction) {
$objObject->dttDateAction = $objObject->dttDateAction->__toString(QDateTime::FormatSoap);
}
return $objObject;
}
/**
* Refresh this MetaControl with Data from the local Comment object.
* @param boolean $blnReload reload Comment from the database
* @return void
*/
public function Refresh($blnReload = false)
{
if ($blnReload) {
$this->objComment->Reload();
}
if ($this->lblId) {
if ($this->blnEditMode) {
$this->lblId->Text = $this->objComment->Id;
}
}
if ($this->lstPerson) {
$this->lstPerson->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstPerson->AddItem(QApplication::Translate('- Select One -'), null);
}
$objPersonArray = Person::LoadAll();
if ($objPersonArray) {
foreach ($objPersonArray as $objPerson) {
$objListItem = new QListItem($objPerson->__toString(), $objPerson->Id);
if ($this->objComment->Person && $this->objComment->Person->Id == $objPerson->Id) {
$objListItem->Selected = true;
}
$this->lstPerson->AddItem($objListItem);
}
}
}
if ($this->lblPersonId) {
$this->lblPersonId->Text = $this->objComment->Person ? $this->objComment->Person->__toString() : null;
}
if ($this->lstPostedByLogin) {
$this->lstPostedByLogin->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstPostedByLogin->AddItem(QApplication::Translate('- Select One -'), null);
}
$objPostedByLoginArray = Login::LoadAll();
if ($objPostedByLoginArray) {
foreach ($objPostedByLoginArray as $objPostedByLogin) {
$objListItem = new QListItem($objPostedByLogin->__toString(), $objPostedByLogin->Id);
if ($this->objComment->PostedByLogin && $this->objComment->PostedByLogin->Id == $objPostedByLogin->Id) {
$objListItem->Selected = true;
}
$this->lstPostedByLogin->AddItem($objListItem);
}
}
}
if ($this->lblPostedByLoginId) {
$this->lblPostedByLoginId->Text = $this->objComment->PostedByLogin ? $this->objComment->PostedByLogin->__toString() : null;
}
if ($this->lstCommentPrivacyType) {
$this->lstCommentPrivacyType->SelectedValue = $this->objComment->CommentPrivacyTypeId;
}
if ($this->lblCommentPrivacyTypeId) {
$this->lblCommentPrivacyTypeId->Text = $this->objComment->CommentPrivacyTypeId ? CommentPrivacyType::$NameArray[$this->objComment->CommentPrivacyTypeId] : null;
}
if ($this->lstCommentCategory) {
$this->lstCommentCategory->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstCommentCategory->AddItem(QApplication::Translate('- Select One -'), null);
}
$objCommentCategoryArray = CommentCategory::LoadAll();
if ($objCommentCategoryArray) {
foreach ($objCommentCategoryArray as $objCommentCategory) {
$objListItem = new QListItem($objCommentCategory->__toString(), $objCommentCategory->Id);
if ($this->objComment->CommentCategory && $this->objComment->CommentCategory->Id == $objCommentCategory->Id) {
$objListItem->Selected = true;
}
$this->lstCommentCategory->AddItem($objListItem);
}
}
}
if ($this->lblCommentCategoryId) {
$this->lblCommentCategoryId->Text = $this->objComment->CommentCategory ? $this->objComment->CommentCategory->__toString() : null;
}
if ($this->txtComment) {
$this->txtComment->Text = $this->objComment->Comment;
}
if ($this->lblComment) {
$this->lblComment->Text = $this->objComment->Comment;
}
if ($this->calDatePosted) {
$this->calDatePosted->DateTime = $this->objComment->DatePosted;
}
if ($this->lblDatePosted) {
$this->lblDatePosted->Text = sprintf($this->objComment->DatePosted) ? $this->objComment->__toString($this->strDatePostedDateTimeFormat) : null;
}
if ($this->calDateAction) {
$this->calDateAction->DateTime = $this->objComment->DateAction;
}
if ($this->lblDateAction) {
$this->lblDateAction->Text = sprintf($this->objComment->DateAction) ? $this->objComment->__toString($this->strDateActionDateTimeFormat) : null;
}
}
/**
* 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 = CommentCategory::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 CommentCategory, given the clauses above
$this->DataSource = CommentCategory::QueryArray($objCondition, $objClauses);
}
/**
* Static Helper Method to Create using PK arguments
* You must pass in the PK arguments on an object to load, or leave it blank to create a new one.
* If you want to load via QueryString or PathInfo, use the CreateFromQueryString or CreateFromPathInfo
* static helper methods. Finally, specify a CreateType to define whether or not we are only allowed to
* edit, or if we are also allowed to create a new one, etc.
*
* @param mixed $objParentObject QForm or QPanel which will be using this CommentCategoryMetaControl
* @param integer $intId primary key value
* @param QMetaControlCreateType $intCreateType rules governing CommentCategory object creation - defaults to CreateOrEdit
* @return CommentCategoryMetaControl
*/
public static function Create($objParentObject, $intId = null, $intCreateType = QMetaControlCreateType::CreateOrEdit)
{
// Attempt to Load from PK Arguments
if (strlen($intId)) {
$objCommentCategory = CommentCategory::Load($intId);
// CommentCategory was found -- return it!
if ($objCommentCategory) {
return new CommentCategoryMetaControl($objParentObject, $objCommentCategory);
} else {
if ($intCreateType != QMetaControlCreateType::CreateOnRecordNotFound) {
throw new QCallerException('Could not find a CommentCategory object with PK arguments: ' . $intId);
}
}
// If EditOnly is specified, throw an exception
} else {
if ($intCreateType == QMetaControlCreateType::EditOnly) {
throw new QCallerException('No PK arguments specified');
}
}
// If we are here, then we need to create a new record
return new CommentCategoryMetaControl($objParentObject, new CommentCategory());
}
