protected function SetupAuditScan() { // Lookup Object PK information from Query String (if applicable) // Set mode to Edit or New depending on what's found $intAuditScanId = QApplication::QueryString('intAuditScanId'); if ($intAuditScanId) { $this->objAuditScan = AuditScan::Load($intAuditScanId); if (!$this->objAuditScan) { throw new Exception('Could not find a AuditScan object with PK arguments: ' . $intAuditScanId); } $this->strTitleVerb = QApplication::Translate('Edit'); $this->blnEditMode = true; } else { $this->objAuditScan = new AuditScan(); $this->strTitleVerb = QApplication::Translate('Create'); $this->blnEditMode = false; } }
protected function dtgAudit_Bind() { if ($this->rblDiscrepancy->SelectedValue == 'discrepancies') { $objConditions = QQ::AndCondition(QQ::Equal(QQN::AuditScan()->AuditId, $_GET['intAuditId']), QQ::NotEqual(QQN::AuditScan()->Count, QQN::AuditScan()->SystemCount)); } else { $objConditions = QQ::Equal(QQN::AuditScan()->AuditId, $_GET['intAuditId']); } $objAuditScanArray = AuditScan::QueryArray($objConditions, QQ::Clause(QQ::Expand(QQN::AuditScan()->Location), $this->dtgAudit->OrderByClause)); if ($objAuditScanArray) { foreach ($objAuditScanArray as $objAuditScan) { $objAuditScan->InventoryModel = InventoryModel::QuerySingle(QQ::Equal(QQN::InventoryModel()->InventoryModelId, $objAuditScan->EntityId), QQ::Clause(QQ::Expand(QQN::InventoryModel()->InventoryModelCode))); } } if (count($objAuditScanArray) == 0) { $this->dtgAudit->ShowHeader = false; } else { $this->dtgAudit->ShowHeader = true; } $this->dtgAudit->DataSource = $objAuditScanArray; }
/** * 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 AuditScanMetaControl * @param integer $intAuditScanId primary key value * @param QMetaControlCreateType $intCreateType rules governing AuditScan object creation - defaults to CreateOrEdit * @return AuditScanMetaControl */ public static function Create($objParentObject, $intAuditScanId = null, $intCreateType = QMetaControlCreateType::CreateOrEdit) { // Attempt to Load from PK Arguments if (strlen($intAuditScanId)) { $objAuditScan = AuditScan::Load($intAuditScanId); // AuditScan was found -- return it! if ($objAuditScan) { return new AuditScanMetaControl($objParentObject, $objAuditScan); } else { if ($intCreateType != QMetaControlCreateType::CreateOnRecordNotFound) { throw new QCallerException('Could not find a AuditScan object with PK arguments: ' . $intAuditScanId); } } // 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 AuditScanMetaControl($objParentObject, new AuditScan()); }
/** * 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 = AuditScan::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 AuditScan, given the clauses above $this->DataSource = AuditScan::QueryArray($objCondition, $objClauses); }
} } } if (!$blnError) { // This should not be possible because the list is populated with existing InventoryLocations if (!$objNewInventoryModel instanceof InventoryModel) { $strWarning .= $strInventoryModelCode . " - That Inventory location does not exist.<br />"; $blnError = true; } elseif (!ctype_digit($intQuantity) || $intQuantity <= 0) { $strWarning .= $strInventoryModelCode . " - That is not a valid quantity.<br />"; $blnError = true; } } if (!$blnError && $objNewInventoryModel instanceof InventoryModel) { $intInventoryIdArray[] = $objNewInventoryModel->InventoryModelId; $objAuditScan = new AuditScan(); $objAuditScan->LocationId = $objDestinationLocation->LocationId; $objAuditScan->EntityId = $objNewInventoryModel->InventoryModelId; $objAuditScan->Count = $intQuantity; if (!$blnSourceLocationError && $objNewInventoryLocation instanceof InventoryLocation) { $objAuditScan->SystemCount = $objNewInventoryLocation->Quantity; } else { $objAuditScan->SystemCount = 0; } $objAuditScanArray[] = $objAuditScan; } } } } } // Submit
public function dtgAuditScan_Bind() { // Get Total Count b/c of Pagination $this->dtgAuditScan->TotalItemCount = AuditScan::CountAll(); $objClauses = array(); if ($objClause = $this->dtgAuditScan->OrderByClause) { array_push($objClauses, $objClause); } if ($objClause = $this->dtgAuditScan->LimitClause) { array_push($objClauses, $objClause); } $this->dtgAuditScan->DataSource = AuditScan::LoadAll($objClauses); }
/** * Deletes all associated AuditScans * @return void */ public function DeleteAllAuditScans() { if (is_null($this->intLocationId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociateAuditScan on this unsaved Location.'); } // Get the Database Object for this Class $objDatabase = Location::GetDatabase(); // Journaling if ($objDatabase->JournalingDatabase) { foreach (AuditScan::LoadArrayByLocationId($this->intLocationId) as $objAuditScan) { $objAuditScan->Journal('DELETE'); } } // Perform the SQL Query $objDatabase->NonQuery(' DELETE FROM `audit_scan` WHERE `location_id` = ' . $objDatabase->SqlVariable($this->intLocationId) . ' '); }
/** * Counts all associated AuditScans * @return int */ public function CountAuditScans() { if (is_null($this->intAuditId)) { return 0; } return AuditScan::CountByAuditId($this->intAuditId); }
public static function GetSoapArrayFromArray($objArray) { if (!$objArray) { return null; } $objArrayToReturn = array(); foreach ($objArray as $objObject) { array_push($objArrayToReturn, AuditScan::GetSoapObjectFromObject($objObject, true)); } return unserialize(serialize($objArrayToReturn)); }
protected function dtgAuditScan_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->dtgAuditScan->TotalItemCount = AuditScan::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->dtgAuditScan->OrderByClause) { array_push($objClauses, $objClause); } // Add the LimitClause information, as well if ($objClause = $this->dtgAuditScan->LimitClause) { array_push($objClauses, $objClause); } // Set the DataSource to be the array of all AuditScan objects, given the clauses above $this->dtgAuditScan->DataSource = AuditScan::LoadAll($objClauses); }