protected function dtgContributions_Bind() { $objCondition = QQ::Equal(QQN::PackageContribution()->PackageId, $this->objPackage->Id); $this->dtgContributions->TotalItemCount = PackageContribution::QueryCount($objCondition); $objClauses = array(); if ($objClause = $this->dtgContributions->LimitClause) { $objClauses[] = $objClause; } if ($objClause = $this->dtgContributions->OrderByClause) { $objClauses[] = $objClause; } $this->dtgContributions->DataSource = PackageContribution::QueryArray($objCondition, $objClauses); }
/** * Deletes all associated PackageContributions * @return void */ public function DeleteAllPackageContributions() { if (is_null($this->intId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociatePackageContribution on this unsaved Package.'); } // Get the Database Object for this Class $objDatabase = Package::GetDatabase(); // Journaling if ($objDatabase->JournalingDatabase) { foreach (PackageContribution::LoadArrayByPackageId($this->intId) as $objPackageContribution) { $objPackageContribution->Journal('DELETE'); } } // Perform the SQL Query $objDatabase->NonQuery(' DELETE FROM `package_contribution` WHERE `package_id` = ' . $objDatabase->SqlVariable($this->intId) . ' '); }
public static function GetSoapObjectFromObject($objObject, $blnBindRelatedObjects) { if ($objObject->objPackageContribution) { $objObject->objPackageContribution = PackageContribution::GetSoapObjectFromObject($objObject->objPackageContribution, false); } else { if (!$blnBindRelatedObjects) { $objObject->intPackageContributionId = null; } } if ($objObject->dttPostDate) { $objObject->dttPostDate = $objObject->dttPostDate->__toString(QDateTime::FormatSoap); } return $objObject; }
/** * Gets the most recently updated or uploaded contribution * @return PackageContribution */ public function GetMostRecentContribution() { return PackageContribution::QuerySingle(QQ::Equal(QQN::PackageContribution()->PackageId, $this->intId), QQ::Clause(QQ::OrderBy(QQN::PackageContribution()->CurrentPostDate, false), QQ::LimitInfo(1))); }
public static function GetSoapArrayFromArray($objArray) { if (!$objArray) { return null; } $objArrayToReturn = array(); foreach ($objArray as $objObject) { array_push($objArrayToReturn, PackageContribution::GetSoapObjectFromObject($objObject, true)); } return unserialize(serialize($objArrayToReturn)); }
/** * 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 = PackageContribution::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 PackageContribution, given the clauses above $this->DataSource = PackageContribution::QueryArray($objCondition, $objClauses); }
/** * @param string $strPackageName * @param string $strUsername * @param boolean $blnGzCompress * @return string */ public function DownloadPackage($strPackageName, $strUsername, $blnGzCompress) { $objPerson = Person::LoadByUsername($strUsername); $objPackage = Package::Load($this->GetPackageId($strPackageName)); if (!$objPerson) { return null; } if (!$objPackage) { return null; } $objPackageContribution = PackageContribution::LoadByPackageIdPersonId($objPackage->Id, $objPerson->Id); if (!$objPackageContribution) { return null; } if (!$objPackageContribution->CurrentPackageVersion) { return null; } $objPackageContribution->CurrentPackageVersion->DownloadCount++; $objPackageContribution->CurrentPackageVersion->Save(); $objPackageContribution->RefreshStats(); if ($blnGzCompress) { $strPath = $objPackageContribution->CurrentPackageVersion->GetFilePathCompressed(); } else { $strPath = $objPackageContribution->CurrentPackageVersion->GetFilePath(); } header('Content-Length: ' . filesize($strPath)); return file_get_contents($strPath); }
/** * Refresh this MetaControl with Data from the local PackageVersion object. * @param boolean $blnReload reload PackageVersion from the database * @return void */ public function Refresh($blnReload = false) { if ($blnReload) { $this->objPackageVersion->Reload(); } if ($this->lblId) { if ($this->blnEditMode) { $this->lblId->Text = $this->objPackageVersion->Id; } } if ($this->lstPackageContribution) { $this->lstPackageContribution->RemoveAllItems(); if (!$this->blnEditMode) { $this->lstPackageContribution->AddItem(QApplication::Translate('- Select One -'), null); } $objPackageContributionArray = PackageContribution::LoadAll(); if ($objPackageContributionArray) { foreach ($objPackageContributionArray as $objPackageContribution) { $objListItem = new QListItem($objPackageContribution->__toString(), $objPackageContribution->Id); if ($this->objPackageVersion->PackageContribution && $this->objPackageVersion->PackageContribution->Id == $objPackageContribution->Id) { $objListItem->Selected = true; } $this->lstPackageContribution->AddItem($objListItem); } } } if ($this->lblPackageContributionId) { $this->lblPackageContributionId->Text = $this->objPackageVersion->PackageContribution ? $this->objPackageVersion->PackageContribution->__toString() : null; } if ($this->txtVersionNumber) { $this->txtVersionNumber->Text = $this->objPackageVersion->VersionNumber; } if ($this->lblVersionNumber) { $this->lblVersionNumber->Text = $this->objPackageVersion->VersionNumber; } if ($this->txtNotes) { $this->txtNotes->Text = $this->objPackageVersion->Notes; } if ($this->lblNotes) { $this->lblNotes->Text = $this->objPackageVersion->Notes; } if ($this->txtQcodoVersion) { $this->txtQcodoVersion->Text = $this->objPackageVersion->QcodoVersion; } if ($this->lblQcodoVersion) { $this->lblQcodoVersion->Text = $this->objPackageVersion->QcodoVersion; } if ($this->txtNewFileCount) { $this->txtNewFileCount->Text = $this->objPackageVersion->NewFileCount; } if ($this->lblNewFileCount) { $this->lblNewFileCount->Text = $this->objPackageVersion->NewFileCount; } if ($this->txtChangedFileCount) { $this->txtChangedFileCount->Text = $this->objPackageVersion->ChangedFileCount; } if ($this->lblChangedFileCount) { $this->lblChangedFileCount->Text = $this->objPackageVersion->ChangedFileCount; } if ($this->calPostDate) { $this->calPostDate->DateTime = $this->objPackageVersion->PostDate; } if ($this->lblPostDate) { $this->lblPostDate->Text = sprintf($this->objPackageVersion->PostDate) ? $this->objPackageVersion->__toString($this->strPostDateDateTimeFormat) : null; } if ($this->txtDownloadCount) { $this->txtDownloadCount->Text = $this->objPackageVersion->DownloadCount; } if ($this->lblDownloadCount) { $this->lblDownloadCount->Text = $this->objPackageVersion->DownloadCount; } }
/** * Default / simple DataBinder for this Meta DataGrid. This can easily be overridden * by calling SetDataBinder() on this DataGrid with another DataBinder of your choice. * * 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). */ public function MetaDataBinder() { // Remember! We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below if ($this->Paginator) { $this->TotalItemCount = PackageContribution::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->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 PackageContribution, given the clauses above $this->DataSource = PackageContribution::LoadAll($objClauses); }
/** * Counts all associated PackageContributions * @return int */ public function CountPackageContributions() { if (is_null($this->intId)) { return 0; } return PackageContribution::CountByPersonId($this->intId); }
/** * 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 PackageContributionMetaControl * @param integer $intId primary key value * @param QMetaControlCreateType $intCreateType rules governing PackageContribution object creation - defaults to CreateOrEdit * @return PackageContributionMetaControl */ public static function Create($objParentObject, $intId = null, $intCreateType = QMetaControlCreateType::CreateOrEdit) { // Attempt to Load from PK Arguments if (strlen($intId)) { $objPackageContribution = PackageContribution::Load($intId); // PackageContribution was found -- return it! if ($objPackageContribution) { return new PackageContributionMetaControl($objParentObject, $objPackageContribution); } else { if ($intCreateType != QMetaControlCreateType::CreateOnRecordNotFound) { throw new QCallerException('Could not find a PackageContribution 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 PackageContributionMetaControl($objParentObject, new PackageContribution()); }
$objPackageCategories = PackageCategory::QueryArray(QQ::NotEqual(QQN::PackageCategory()->Token, 'issues')); while (QDataGen::DisplayWhileTask('Generating QPM Packages...', GENERATE_QPM)) { $objPackage = new Package(); $objPackage->PackageCategory = QDataGen::GenerateFromArray($objPackageCategories); $objPackage->Name = QDataGen::GenerateTitle(1, 3); $objPackage->Token = Package::SanitizeForToken($objPackage->Name); while (Package::LoadByToken($objPackage->Token)) { $objPackage->Name = QDataGen::GenerateTitle(1, 3); $objPackage->Token = Package::SanitizeForToken($objPackage->Name); } $objPackage->Description = QDataGen::GenerateContent(rand(1, 3), 20, 80); $objPackage->Save(); $objPackage->CreateTopicAndTopicLink(Person::Load(rand(1, $intMaxPersonId))); $intContributionCount = rand(1, 10); for ($intContribution = 0; $intContribution < $intContributionCount; $intContribution++) { while (PackageContribution::LoadByPackageIdPersonId($objPackage->Id, $objPerson->Id)) { $objPerson = Person::Load(rand(1, $intMaxPersonId)); } $intVersionCount = rand(1, 4); $dttEndRange = QDataGen::GenerateDateTime($dttStartDate, QDateTime::Now()); $dttEndRange = QDataGen::GenerateDateTime($dttStartDate, $dttEndRange); $dttEndRange = QDataGen::GenerateDateTime($dttStartDate, $dttEndRange); $dttPostDate = QDataGen::GenerateDateTime($dttStartDate, $dttEndRange); for ($intVersion = 0; $intVersion < $intVersionCount; $intVersion++) { // Randomize a Qcodo Version $strQcodoVersion = rand(0, 99) . '.' . rand(0, 99) . '.' . rand(0, 99); $strQcodoVersionType = rand(0, 1) ? 'Development' : 'Stable'; // Randomize a New and Changed file count $intNewFileCount = rand(0, 10); $intChangedFileCount = rand(0, 10); // Randomize Notes