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);
}
