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