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