Example #1
0
 protected function dtgAudit_Create()
 {
     $this->dtgAudit = new QDataGrid($this);
     $this->dtgAudit->Name = 'asset_audit_list';
     $this->dtgAudit->CellPadding = 5;
     $this->dtgAudit->CellSpacing = 0;
     $this->dtgAudit->CssClass = "datagrid";
     // Enable Pagination, and set to 1000 items per page
     $objPaginator = new QPaginator($this->dtgAudit);
     $this->dtgAudit->Paginator = $objPaginator;
     $this->dtgAudit->ItemsPerPage = 1000;
     $this->dtgAudit->UseAjax = true;
     // Allow for column toggling
     $this->dtgAudit->ShowColumnToggle = true;
     // Allow for CSV Export
     $this->dtgAudit->ShowExportCsv = true;
     $this->dtgAudit->AddColumn(new QDataGridColumnExt('Location', '<?= $_ITEM->Location->ShortDescription ?>', array('OrderByClause' => QQ::OrderBy(QQN::AuditScan()->LocationId), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AuditScan()->LocationId, false), 'CssClass' => 'dtg_column')));
     $this->dtgAudit->AddColumn(new QDataGridColumnExt('Asset Code', '<?= $_ITEM->Asset->AssetCode ?>', array('OrderByClause' => QQ::OrderBy(AuditScan::AuditScanExt()->Asset->AssetCode), 'ReverseOrderByClause' => QQ::OrderBy(AuditScan::AuditScanExt()->Asset->AssetCode, false), 'CssClass' => 'dtg_column')));
     $this->dtgAudit->AddColumn(new QDataGridColumnExt('Asset Model', '<?= $_ITEM->Asset->AssetModel->ShortDescription ?>', array('OrderByClause' => QQ::OrderBy(AuditScan::AuditScanExt()->Asset->AssetModel->ShortDescription), 'ReverseOrderByClause' => QQ::OrderBy(AuditScan::AuditScanExt()->Asset->AssetModel->ShortDescription, false), 'CssClass' => 'dtg_column')));
     $this->dtgAudit->AddColumn(new QDataGridColumnExt('PDT Count', '<?= $_ITEM->Count ?>', array('OrderByClause' => QQ::OrderBy(QQN::AuditScan()->Count), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AuditScan()->Count, false), 'CssClass' => 'dtg_column')));
     $this->dtgAudit->AddColumn(new QDataGridColumnExt('System Count', '<?= $_ITEM->SystemCount ?>', array('OrderByClause' => QQ::OrderBy(QQN::AuditScan()->SystemCount), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AuditScan()->SystemCount, false), 'CssClass' => 'dtg_column')));
     $objStyle = $this->dtgAudit->RowStyle;
     $objStyle->ForeColor = '#000000';
     $objStyle->BackColor = '#FFFFFF';
     $objStyle->FontSize = 12;
     $objStyle = $this->dtgAudit->AlternateRowStyle;
     $objStyle->BackColor = '#EFEFEF';
     $objStyle = $this->dtgAudit->HeaderRowStyle;
     $objStyle->ForeColor = '#000000';
     $objStyle->BackColor = '#EFEFEF';
     $objStyle->CssClass = 'dtg_header';
     $this->dtgAudit->SetDataBinder('dtgAudit_Bind');
 }
Example #2
0
 protected function dtgAudit_Create()
 {
     $this->dtgAudit = new QDataGrid($this);
     $this->dtgAudit->Name = 'inventory_audit_list';
     $this->dtgAudit->CellPadding = 5;
     $this->dtgAudit->CellSpacing = 0;
     $this->dtgAudit->CssClass = "datagrid";
     // Enable Pagination, and set to 1000 items per page
     $objPaginator = new QPaginator($this->dtgAudit);
     $this->dtgAudit->Paginator = $objPaginator;
     $this->dtgAudit->ItemsPerPage = 1000;
     $this->dtgAudit->UseAjax = true;
     // Allow for column toggling
     $this->dtgAudit->ShowColumnToggle = true;
     // Allow for CSV Export
     $this->dtgAudit->ShowExportCsv = true;
     $this->dtgAudit->AddColumn(new QDataGridColumnExt('Location', '<?= $_ITEM->Location->ShortDescription ?>', array('OrderByClause' => QQ::OrderBy(QQN::AuditScan()->LocationId), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AuditScan()->LocationId, false))));
     $this->dtgAudit->AddColumn(new QDataGridColumnExt('Inventory Code', '<?= $_ITEM->InventoryModel->InventoryModelCode ?>', array('OrderByClause' => QQ::OrderBy(AuditScan::AuditScanExt()->InventoryModel->InventoryModelCode), 'ReverseOrderByClause' => QQ::OrderBy(AuditScan::AuditScanExt()->InventoryModel->InventoryModelCode, false))));
     $this->dtgAudit->AddColumn(new QDataGridColumnExt('Inventory Model', '<?= $_ITEM->InventoryModel->ShortDescription ?>', array('OrderByClause' => QQ::OrderBy(AuditScan::AuditScanExt()->InventoryModel->ShortDescription), 'ReverseOrderByClause' => QQ::OrderBy(AuditScan::AuditScanExt()->InventoryModel->ShortDescription, false))));
     $this->dtgAudit->AddColumn(new QDataGridColumnExt('PDT Count', '<?= $_ITEM->Count ?>', array('OrderByClause' => QQ::OrderBy(QQN::AuditScan()->Count), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AuditScan()->Count, false))));
     $this->dtgAudit->AddColumn(new QDataGridColumnExt('System Count', '<?= $_ITEM->SystemCount ?>', array('OrderByClause' => QQ::OrderBy(QQN::AuditScan()->SystemCount), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AuditScan()->SystemCount, false))));
     $this->dtgAudit->SetDataBinder('dtgAudit_Bind');
 }