protected function Form_Create() { // Create the Header Menu $this->ctlHeaderMenu_Create(); $this->ctlShortcutMenu_Create(); if ($_GET && $_GET['method'] == 'delete') { $objAudit = Audit::Load($_GET['intAuditId']); if ($objAudit) { $objAudit->Delete(); QApplication::Redirect("./inventory_audit_list.php"); } } // Load an array of Audit objects using join on UserAccount. $this->objAuditArray = Audit::LoadAll(QQ::Clause(QQ::Expand(QQN::Audit()->CreatedByObject))); }
protected function Form_Create() { // Create the Header Menu $this->ctlHeaderMenu_Create(); $this->ctlShortcutMenu_Create(); //QApplication::$Database[1]->EnableProfiling(); if ($_GET && $_GET['method'] == 'delete') { $objAudit = Audit::Load($_GET['intAuditId']); if ($objAudit) { // Set the relationship to ON DELETE CASCADE so that the AuditScans will be automatically deleted when deleting the Audit Object $objAudit->Delete(); QApplication::Redirect("./asset_audit_list.php"); } } // Load an array of Audit objects using join on UserAccount. $this->objAuditArray = Audit::LoadAll(QQ::Clause(QQ::Expand(QQN::Audit()->CreatedByObject))); }
/** * Refresh this MetaControl with Data from the local AuditScan object. * @param boolean $blnReload reload AuditScan from the database * @return void */ public function Refresh($blnReload = false) { if ($blnReload) { $this->objAuditScan->Reload(); } if ($this->lblAuditScanId) { if ($this->blnEditMode) { $this->lblAuditScanId->Text = $this->objAuditScan->AuditScanId; } } if ($this->lstAudit) { $this->lstAudit->RemoveAllItems(); if (!$this->blnEditMode) { $this->lstAudit->AddItem(QApplication::Translate('- Select One -'), null); } $objAuditArray = Audit::LoadAll(); if ($objAuditArray) { foreach ($objAuditArray as $objAudit) { $objListItem = new QListItem($objAudit->__toString(), $objAudit->AuditId); if ($this->objAuditScan->Audit && $this->objAuditScan->Audit->AuditId == $objAudit->AuditId) { $objListItem->Selected = true; } $this->lstAudit->AddItem($objListItem); } } } if ($this->lblAuditId) { $this->lblAuditId->Text = $this->objAuditScan->Audit ? $this->objAuditScan->Audit->__toString() : null; } if ($this->lstLocation) { $this->lstLocation->RemoveAllItems(); if (!$this->blnEditMode) { $this->lstLocation->AddItem(QApplication::Translate('- Select One -'), null); } $objLocationArray = Location::LoadAll(); if ($objLocationArray) { foreach ($objLocationArray as $objLocation) { $objListItem = new QListItem($objLocation->__toString(), $objLocation->LocationId); if ($this->objAuditScan->Location && $this->objAuditScan->Location->LocationId == $objLocation->LocationId) { $objListItem->Selected = true; } $this->lstLocation->AddItem($objListItem); } } } if ($this->lblLocationId) { $this->lblLocationId->Text = $this->objAuditScan->Location ? $this->objAuditScan->Location->__toString() : null; } if ($this->txtEntityId) { $this->txtEntityId->Text = $this->objAuditScan->EntityId; } if ($this->lblEntityId) { $this->lblEntityId->Text = $this->objAuditScan->EntityId; } if ($this->txtCount) { $this->txtCount->Text = $this->objAuditScan->Count; } if ($this->lblCount) { $this->lblCount->Text = $this->objAuditScan->Count; } if ($this->txtSystemCount) { $this->txtSystemCount->Text = $this->objAuditScan->SystemCount; } if ($this->lblSystemCount) { $this->lblSystemCount->Text = $this->objAuditScan->SystemCount; } }
protected function dtgAudit_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->dtgAudit->TotalItemCount = Audit::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->dtgAudit->OrderByClause) { array_push($objClauses, $objClause); } // Add the LimitClause information, as well if ($objClause = $this->dtgAudit->LimitClause) { array_push($objClauses, $objClause); } // Set the DataSource to be the array of all Audit objects, given the clauses above $this->dtgAudit->DataSource = Audit::LoadAll($objClauses); }
protected function lstAudit_Create() { $this->lstAudit = new QListBox($this); $this->lstAudit->Name = QApplication::Translate('Audit'); $this->lstAudit->Required = true; if (!$this->blnEditMode) { $this->lstAudit->AddItem(QApplication::Translate('- Select One -'), null); } $objAuditArray = Audit::LoadAll(); if ($objAuditArray) { foreach ($objAuditArray as $objAudit) { $objListItem = new QListItem($objAudit->__toString(), $objAudit->AuditId); if ($this->objAuditScan->Audit && $this->objAuditScan->Audit->AuditId == $objAudit->AuditId) { $objListItem->Selected = true; } $this->lstAudit->AddItem($objListItem); } } }
public function dtgAudit_Bind() { // Get Total Count b/c of Pagination $this->dtgAudit->TotalItemCount = Audit::CountAll(); $objClauses = array(); if ($objClause = $this->dtgAudit->OrderByClause) { array_push($objClauses, $objClause); } if ($objClause = $this->dtgAudit->LimitClause) { array_push($objClauses, $objClause); } $this->dtgAudit->DataSource = Audit::LoadAll($objClauses); }