protected function Form_Create()
{
$this->ctlHeaderMenu_Create();
$this->ctlShortcutMenu_Create();
$this->dtgAssetModel = new QDataGrid($this);
$this->dtgAssetModel->Name = 'asset_model_list';
$this->dtgAssetModel->CellPadding = 5;
$this->dtgAssetModel->CellSpacing = 0;
$this->dtgAssetModel->CssClass = "datagrid";
// Disable AJAX for the datagrid
$this->dtgAssetModel->UseAjax = false;
// Allow for column toggling
$this->dtgAssetModel->ShowColumnToggle = true;
// Allow for CSV Export
$this->dtgAssetModel->ShowExportCsv = true;
// Enable Pagination
$objPaginator = new QPaginator($this->dtgAssetModel);
$this->dtgAssetModel->Paginator = $objPaginator;
$this->dtgAssetModel->ItemsPerPage = QApplication::$TracmorSettings->SearchResultsPerPage;
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('ID', '<?= $_ITEM->AssetModelId ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->AssetModelId), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->AssetModelId, false), 'CssClass' => "dtg_column", 'HtmlEntities' => false)));
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('<img src=../images/icons/attachment.gif border=0 title=Attachments alt=Attachments>', '<?= Attachment::toStringIcon($_ITEM->GetVirtualAttribute(\'attachment_count\')); ?>', 'SortByCommand="__attachment_count ASC"', 'ReverseSortByCommand="__attachment_count DESC"', 'CssClass="dtg_column"', 'HtmlEntities="false"'));
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('Assets', '<?= $_ITEM->__toStringWithAssetCountLink($_ITEM,"bluelink"); ?>', 'SortByCommand="asset_count ASC"', 'ReverseSortByCommand="asset_count DESC"', 'CssClass="dtg_column"', 'HtmlEntities=false'));
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('Name', '<?= $_ITEM->__toStringWithLink($_ITEM,"bluelink"); ?>', 'SortByCommand="short_description ASC"', 'ReverseSortByCommand="short_description DESC"', 'CssClass="dtg_column"', 'HtmlEntities="false"'));
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('Category', '<?= $_FORM->dtgAssetModel_Category_Render($_ITEM); ?>', 'SortByCommand="asset_model__category_id__short_description ASC"', 'ReverseSortByCommand="asset_model__category_id__short_description DESC"', 'CssClass="dtg_column"'));
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('Manufacturer', '<?= $_FORM->dtgAssetModel_Manufacturer_Render($_ITEM); ?>', 'SortByCommand="asset_model__manufacturer_id__short_description ASC"', 'ReverseSortByCommand="asset_model__manufacturer_id__short_description DESC"', 'CssClass="dtg_column"'));
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('Asset Model Code', '<?= htmlentities(QString::Truncate($_ITEM->AssetModelCode, 200)); ?>', 'FontBold=true', 'SortByCommand="asset_model_code ASC"', 'ReverseSortByCommand="asset_model_code DESC"', 'CssClass="dtg_column"'));
// Add the custom field columns with Display set to false. These can be shown by using the column toggle menu.
$objCustomFieldArray = CustomField::LoadObjCustomFieldArray(EntityQtype::AssetModel, false);
if ($objCustomFieldArray) {
foreach ($objCustomFieldArray as $objCustomField) {
//Only add the custom field column if the role has authorization to view it.
if ($objCustomField->objRoleAuthView && $objCustomField->objRoleAuthView->AuthorizedFlag) {
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt($objCustomField->ShortDescription, '<?= $_ITEM->GetVirtualAttribute(\'' . $objCustomField->CustomFieldId . '\') ?>', 'SortByCommand="__' . $objCustomField->CustomFieldId . ' ASC"', 'ReverseSortByCommand="__' . $objCustomField->CustomFieldId . ' DESC"', 'HtmlEntities="false"', 'CssClass="dtg_column"', 'Display="false"'));
}
}
}
$this->dtgAssetModel->SortColumnIndex = 2;
$this->dtgAssetModel->SortDirection = 0;
$objStyle = $this->dtgAssetModel->RowStyle;
$objStyle->ForeColor = '#000000';
$objStyle->BackColor = '#FFFFFF';
$objStyle->FontSize = 12;
$objStyle = $this->dtgAssetModel->AlternateRowStyle;
$objStyle->BackColor = '#EFEFEF';
$objStyle = $this->dtgAssetModel->HeaderRowStyle;
$objStyle->ForeColor = '#000000';
$objStyle->BackColor = '#EFEFEF';
$objStyle->CssClass = 'dtg_header';
$this->dtgAssetModel->SetDataBinder('dtgAssetModel_Bind');
$this->lstCategory_Create();
$this->lstManufacturer_Create();
$this->txtDescription_Create();
$this->txtAssetModelCode_Create();
$this->btnSearch_Create();
$this->btnClear_Create();
$this->ctlAdvanced_Create();
$this->lblAdvanced_Create();
}
public function __construct($objParentObject, $strSetEditPanelMethod, $strCloseEditPanelMethod, $strControlId = null)
{
// Call the Parent
try {
parent::__construct($objParentObject, $strControlId);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
// Record Method Callbacks
$this->strSetEditPanelMethod = $strSetEditPanelMethod;
$this->strCloseEditPanelMethod = $strCloseEditPanelMethod;
// Setup DataGrid Columns
$this->colEditLinkColumn = new QDataGridColumn(QApplication::Translate('Edit'), '<?= $_CONTROL->ParentControl->dtgAssetModel_EditLinkColumn_Render($_ITEM) ?>');
$this->colEditLinkColumn->HtmlEntities = false;
$this->colAssetModelId = new QDataGridColumn(QApplication::Translate('Asset Model Id'), '<?= $_ITEM->AssetModelId; ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->AssetModelId), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->AssetModelId, false)));
$this->colCategoryId = new QDataGridColumn(QApplication::Translate('Category Id'), '<?= $_CONTROL->ParentControl->dtgAssetModel_Category_Render($_ITEM); ?>');
$this->colManufacturerId = new QDataGridColumn(QApplication::Translate('Manufacturer Id'), '<?= $_CONTROL->ParentControl->dtgAssetModel_Manufacturer_Render($_ITEM); ?>');
$this->colAssetModelCode = new QDataGridColumn(QApplication::Translate('Asset Model Code'), '<?= QString::Truncate($_ITEM->AssetModelCode, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->AssetModelCode), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->AssetModelCode, false)));
$this->colShortDescription = new QDataGridColumn(QApplication::Translate('Short Description'), '<?= QString::Truncate($_ITEM->ShortDescription, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->ShortDescription), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->ShortDescription, false)));
$this->colLongDescription = new QDataGridColumn(QApplication::Translate('Long Description'), '<?= QString::Truncate($_ITEM->LongDescription, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->LongDescription), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->LongDescription, false)));
$this->colImagePath = new QDataGridColumn(QApplication::Translate('Image Path'), '<?= QString::Truncate($_ITEM->ImagePath, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->ImagePath), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->ImagePath, false)));
$this->colCreatedBy = new QDataGridColumn(QApplication::Translate('Created By'), '<?= $_CONTROL->ParentControl->dtgAssetModel_CreatedByObject_Render($_ITEM); ?>');
$this->colCreationDate = new QDataGridColumn(QApplication::Translate('Creation Date'), '<?= $_CONTROL->ParentControl->dtgAssetModel_CreationDate_Render($_ITEM); ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->CreationDate), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->CreationDate, false)));
$this->colModifiedBy = new QDataGridColumn(QApplication::Translate('Modified By'), '<?= $_CONTROL->ParentControl->dtgAssetModel_ModifiedByObject_Render($_ITEM); ?>');
$this->colModifiedDate = new QDataGridColumn(QApplication::Translate('Modified Date'), '<?= QString::Truncate($_ITEM->ModifiedDate, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->ModifiedDate), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->ModifiedDate, false)));
// Setup DataGrid
$this->dtgAssetModel = new QDataGrid($this);
$this->dtgAssetModel->CellSpacing = 0;
$this->dtgAssetModel->CellPadding = 4;
$this->dtgAssetModel->BorderStyle = QBorderStyle::Solid;
$this->dtgAssetModel->BorderWidth = 1;
$this->dtgAssetModel->GridLines = QGridLines::Both;
// Datagrid Paginator
$this->dtgAssetModel->Paginator = new QPaginator($this->dtgAssetModel);
$this->dtgAssetModel->ItemsPerPage = 10;
// Specify Whether or Not to Refresh using Ajax
$this->dtgAssetModel->UseAjax = true;
// Specify the local databind method this datagrid will use
$this->dtgAssetModel->SetDataBinder('dtgAssetModel_Bind', $this);
$this->dtgAssetModel->AddColumn($this->colEditLinkColumn);
$this->dtgAssetModel->AddColumn($this->colAssetModelId);
$this->dtgAssetModel->AddColumn($this->colCategoryId);
$this->dtgAssetModel->AddColumn($this->colManufacturerId);
$this->dtgAssetModel->AddColumn($this->colAssetModelCode);
$this->dtgAssetModel->AddColumn($this->colShortDescription);
$this->dtgAssetModel->AddColumn($this->colLongDescription);
$this->dtgAssetModel->AddColumn($this->colImagePath);
$this->dtgAssetModel->AddColumn($this->colCreatedBy);
$this->dtgAssetModel->AddColumn($this->colCreationDate);
$this->dtgAssetModel->AddColumn($this->colModifiedBy);
$this->dtgAssetModel->AddColumn($this->colModifiedDate);
// Setup the Create New button
$this->btnCreateNew = new QButton($this);
$this->btnCreateNew->Text = QApplication::Translate('Create a New') . ' ' . QApplication::Translate('AssetModel');
$this->btnCreateNew->AddAction(new QClickEvent(), new QAjaxControlAction($this, 'btnCreateNew_Click'));
}
protected function Form_Create()
{
// Setup DataGrid Columns
$this->colEditLinkColumn = new QDataGridColumn(QApplication::Translate('Edit'), '<?= $_FORM->dtgAssetModel_EditLinkColumn_Render($_ITEM) ?>');
$this->colEditLinkColumn->HtmlEntities = false;
$this->colAssetModelId = new QDataGridColumn(QApplication::Translate('Asset Model Id'), '<?= $_ITEM->AssetModelId; ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->AssetModelId), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->AssetModelId, false)));
$this->colCategoryId = new QDataGridColumn(QApplication::Translate('Category Id'), '<?= $_FORM->dtgAssetModel_Category_Render($_ITEM); ?>');
$this->colManufacturerId = new QDataGridColumn(QApplication::Translate('Manufacturer Id'), '<?= $_FORM->dtgAssetModel_Manufacturer_Render($_ITEM); ?>');
$this->colAssetModelCode = new QDataGridColumn(QApplication::Translate('Model Number'), '<?= QString::Truncate($_ITEM->AssetModelCode, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->AssetModelCode), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->AssetModelCode, false)));
$this->colShortDescription = new QDataGridColumn(QApplication::Translate('Short Description'), '<?= QString::Truncate($_ITEM->ShortDescription, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->ShortDescription), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->ShortDescription, false)));
$this->colLongDescription = new QDataGridColumn(QApplication::Translate('Long Description'), '<?= QString::Truncate($_ITEM->LongDescription, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->LongDescription), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->LongDescription, false)));
$this->colImagePath = new QDataGridColumn(QApplication::Translate('Image Path'), '<?= QString::Truncate($_ITEM->ImagePath, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->ImagePath), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->ImagePath, false)));
$this->colCreatedBy = new QDataGridColumn(QApplication::Translate('Created By'), '<?= $_FORM->dtgAssetModel_CreatedByObject_Render($_ITEM); ?>');
$this->colCreationDate = new QDataGridColumn(QApplication::Translate('Creation Date'), '<?= $_FORM->dtgAssetModel_CreationDate_Render($_ITEM); ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->CreationDate), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->CreationDate, false)));
$this->colModifiedBy = new QDataGridColumn(QApplication::Translate('Modified By'), '<?= $_FORM->dtgAssetModel_ModifiedByObject_Render($_ITEM); ?>');
$this->colModifiedDate = new QDataGridColumn(QApplication::Translate('Modified Date'), '<?= QString::Truncate($_ITEM->ModifiedDate, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->ModifiedDate), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->ModifiedDate, false)));
$this->colAssetModelCustomFieldHelper = new QDataGridColumn(QApplication::Translate('Asset Model Custom Field Helper'), '<?= $_FORM->dtgAssetModel_AssetModelCustomFieldHelper_Render($_ITEM); ?>');
// Setup DataGrid
$this->dtgAssetModel = new QDataGrid($this);
$this->dtgAssetModel->CellSpacing = 0;
$this->dtgAssetModel->CellPadding = 4;
$this->dtgAssetModel->BorderStyle = QBorderStyle::Solid;
$this->dtgAssetModel->BorderWidth = 1;
$this->dtgAssetModel->GridLines = QGridLines::Both;
// Datagrid Paginator
$this->dtgAssetModel->Paginator = new QPaginator($this->dtgAssetModel);
$this->dtgAssetModel->ItemsPerPage = 10;
// Specify Whether or Not to Refresh using Ajax
$this->dtgAssetModel->UseAjax = false;
// Specify the local databind method this datagrid will use
$this->dtgAssetModel->SetDataBinder('dtgAssetModel_Bind');
$this->dtgAssetModel->AddColumn($this->colEditLinkColumn);
$this->dtgAssetModel->AddColumn($this->colAssetModelId);
$this->dtgAssetModel->AddColumn($this->colCategoryId);
$this->dtgAssetModel->AddColumn($this->colManufacturerId);
$this->dtgAssetModel->AddColumn($this->colAssetModelCode);
$this->dtgAssetModel->AddColumn($this->colShortDescription);
$this->dtgAssetModel->AddColumn($this->colLongDescription);
$this->dtgAssetModel->AddColumn($this->colImagePath);
$this->dtgAssetModel->AddColumn($this->colCreatedBy);
$this->dtgAssetModel->AddColumn($this->colCreationDate);
$this->dtgAssetModel->AddColumn($this->colModifiedBy);
$this->dtgAssetModel->AddColumn($this->colModifiedDate);
$this->dtgAssetModel->AddColumn($this->colAssetModelCustomFieldHelper);
}
protected function rblAssetType_Change($strFormId, $strControlId, $strParameter)
{
$this->txtNewAssetCode->Text = '';
// If adding an existing asset to the receipt
if ($this->rblAssetType->SelectedValue == 'existing') {
$this->lstAssetModel->Display = false;
$this->chkAutoGenerateAssetCode->Checked = false;
$this->chkAutoGenerateAssetCode->Display = false;
$this->txtNewAssetCode->Enabled = true;
$this->lblAddAsset->Display = true;
} elseif ($this->rblAssetType->SelectedValue == 'new') {
$objAssetModelArray = AssetModel::LoadAll(QQ::Clause(QQ::OrderBy(QQN::AssetModel()->ShortDescription)));
if ($objAssetModelArray) {
foreach ($objAssetModelArray as $objAssetModel) {
$objListItem = new QListItem($objAssetModel->__toString(), $objAssetModel->AssetModelId);
$this->lstAssetModel->AddItem($objListItem);
}
}
// Display the list of possible asset models
$this->lstAssetModel->Display = true;
// Display the Auto Generate Asset Code checkbox if a minimum value exists
if (QApplication::$TracmorSettings->MinAssetCode) {
$this->chkAutoGenerateAssetCode->Display = true;
}
$this->lblAddAsset->Display = false;
}
}
/**
* Used internally by the Meta-based Add Column tools.
*
* Given a QQNode or a Text String, this will return a AssetModel-based QQNode.
* It will also verify that it is a proper AssetModel-based QQNode, and will throw an exception otherwise.
*
* @param mixed $mixContent
* @return QQNode
*/
protected function ResolveContentItem($mixContent)
{
if ($mixContent instanceof QQNode) {
if (!$mixContent->_ParentNode) {
throw new QCallerException('Content QQNode cannot be a Top Level Node');
}
if ($mixContent->_RootTableName == 'asset_model') {
if ($mixContent instanceof QQReverseReferenceNode && !$mixContent->_PropertyName) {
throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
}
$objCurrentNode = $mixContent;
while ($objCurrentNode = $objCurrentNode->_ParentNode) {
if (!$objCurrentNode instanceof QQNode) {
throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
}
if ($objCurrentNode instanceof QQReverseReferenceNode && !$objCurrentNode->_PropertyName) {
throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
}
}
return $mixContent;
} else {
throw new QCallerException('Content QQNode has a root table of "' . $mixContent->_RootTableName . '". Must be a root of "asset_model".');
}
} else {
if (is_string($mixContent)) {
switch ($mixContent) {
case 'AssetModelId':
return QQN::AssetModel()->AssetModelId;
case 'CategoryId':
return QQN::AssetModel()->CategoryId;
case 'Category':
return QQN::AssetModel()->Category;
case 'ManufacturerId':
return QQN::AssetModel()->ManufacturerId;
case 'Manufacturer':
return QQN::AssetModel()->Manufacturer;
case 'AssetModelCode':
return QQN::AssetModel()->AssetModelCode;
case 'ShortDescription':
return QQN::AssetModel()->ShortDescription;
case 'LongDescription':
return QQN::AssetModel()->LongDescription;
case 'ImagePath':
return QQN::AssetModel()->ImagePath;
case 'CreatedBy':
return QQN::AssetModel()->CreatedBy;
case 'CreatedByObject':
return QQN::AssetModel()->CreatedByObject;
case 'CreationDate':
return QQN::AssetModel()->CreationDate;
case 'ModifiedBy':
return QQN::AssetModel()->ModifiedBy;
case 'ModifiedByObject':
return QQN::AssetModel()->ModifiedByObject;
case 'ModifiedDate':
return QQN::AssetModel()->ModifiedDate;
case 'DepreciationClassId':
return QQN::AssetModel()->DepreciationClassId;
case 'DepreciationClass':
return QQN::AssetModel()->DepreciationClass;
case 'AssetModelCustomFieldHelper':
return QQN::AssetModel()->AssetModelCustomFieldHelper;
default:
throw new QCallerException('Simple Property not found in AssetModelDataGrid content: ' . $mixContent);
}
} else {
if ($mixContent instanceof QQAssociationNode) {
throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
} else {
throw new QCallerException('Invalid Content type');
}
}
}
}
public function btnAssetModelSearchToolAdd_Click()
{
$this->ctlAssetModelSearchTool->lblWarning->Text = "";
$intSelectedAssetModelId = $this->ctlAssetModelSearchTool->ctlAssetModelSearch->dtgAssetModel->GetSelected("AssetModelId");
if (count($intSelectedAssetModelId) < 1) {
$this->ctlAssetModelSearchTool->lblWarning->Text = "No selected models.";
} else {
$lblNewWarning = "";
foreach (AssetModel::QueryArray(QQ::In(QQN::AssetModel()->AssetModelId, $intSelectedAssetModelId)) as $objNewAssetModel) {
$blnExists = false;
foreach ($this->arrAssetModels as $objAssetModel) {
if ($objAssetModel->AssetModelId == $objNewAssetModel->AssetModelId) {
$blnExists = true;
}
}
if ($blnExists) {
$lblNewWarning .= sprintf("<br />%s - already in list", $objNewAssetModel->AssetModelCode);
} else {
$objAssetModelToAdd = new AssetCustomFieldAssetModel();
$objAssetModelToAdd->AssetModelId = $objNewAssetModel->AssetModelId;
$objAssetModelToAdd->CustomFieldId = $this->objCustomField->CustomFieldId;
array_push($this->arrAssetModels, $objAssetModelToAdd);
}
}
$this->lstAddAssetModel->Warning = $lblNewWarning;
$this->ctlAssetModelSearchTool->dlgAssetModelSearchTool->HideDialogBox();
}
// Uncheck all items but SelectAll checkbox
$this->UncheckAllItems();
$this->dtgAssetModels->Refresh();
}
public function __construct($objParentObject, $strControlId = null, $blnShowCheckboxes = false, $blnUseAjax = false, $blnRemoveAllLinks = false)
{
// First, call the parent to do most of the basic setup
try {
parent::__construct($objParentObject, $strControlId);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
$this->objParentObject = $objParentObject;
$this->blnUseAjax = $blnUseAjax;
$this->blnRemoveAllLinks = $blnRemoveAllLinks;
$this->dtgAssetModel = new QDataGrid($this);
$this->dtgAssetModel->Name = 'asset_model_list';
$this->dtgAssetModel->CellPadding = 5;
$this->dtgAssetModel->CellSpacing = 0;
$this->dtgAssetModel->CssClass = "datagrid";
// Enable/Disable AJAX for the datagrid
$this->dtgAssetModel->UseAjax = $this->blnUseAjax;
$this->dtgAssetModel->ShowColumnToggle = true;
$this->dtgAssetModel->ShowExportCsv = true;
// Add a 'Select All' checkbox
$this->dtgAssetModel->ShowCheckboxes = false;
// Enable Pagination
$objPaginator = new QPaginator($this->dtgAssetModel);
$this->dtgAssetModel->Paginator = $objPaginator;
$this->dtgAssetModel->ItemsPerPage = QApplication::$TracmorSettings->SearchResultsPerPage;
// If the user wants the checkboxes column
if ($blnShowCheckboxes) {
// This will render all of the necessary controls and actions. chkSelected_Render expects a unique ID for each row of the database.
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('<?= $_CONTROL->chkSelectAll_Render() ?>', '<?=$_CONTROL->chkSelected_Render($_ITEM->AssetModelId) ?>', 'CssClass="dtg_column"', 'HtmlEntities=false'));
}
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('ID', '<?= $_ITEM->AssetModelId ?>', array('OrderByClause' => QQ::OrderBy(QQN::AssetModel()->AssetModelId), 'ReverseOrderByClause' => QQ::OrderBy(QQN::AssetModel()->AssetModelId, false), 'CssClass' => "dtg_column", 'HtmlEntities' => false)));
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('<img src=../images/icons/attachment.gif border=0 title=Attachments alt=Attachments>', '<?= Attachment::toStringIcon($_ITEM->GetVirtualAttribute(\'attachment_count\')); ?>', 'SortByCommand="__attachment_count ASC"', 'ReverseSortByCommand="__attachment_count DESC"', 'CssClass="dtg_column"', 'HtmlEntities="false"'));
// Removing any links in the column data
if ($this->blnRemoveAllLinks) {
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('Assets', '<?= $_ITEM->__toStringAssetCount(); ?>', 'SortByCommand="asset_count ASC"', 'ReverseSortByCommand="asset_count DESC"', 'CssClass="dtg_column"', 'HtmlEntities=false'));
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('NAME', '<?= $_ITEM->ShortDescription ?>', 'SortByCommand="short_description ASC"', 'ReverseSortByCommand="short_description DESC"', 'CssClass="dtg_column"', 'HtmlEntities="false"'));
} else {
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('Assets', '<?= $_ITEM->__toStringWithAssetCountLink($_ITEM,"bluelink"); ?>', 'SortByCommand="asset_count ASC"', 'ReverseSortByCommand="asset_count DESC"', 'CssClass="dtg_column"', 'HtmlEntities=false'));
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('NAME', '<?= $_ITEM->__toStringWithLink($_ITEM,"bluelink"); ?>', 'SortByCommand="short_description ASC"', 'ReverseSortByCommand="short_description DESC"', 'CssClass="dtg_column"', 'HtmlEntities="false"'));
}
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('Category', '<?= $_ITEM->Category->__toString(); ?>', 'SortByCommand="asset_model__category_id__short_description ASC"', 'ReverseSortByCommand="asset_model__category_id__short_description DESC"', 'CssClass="dtg_column"'));
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('Manufacturer', '<?= $_ITEM->Manufacturer->__toString(); ?>', 'SortByCommand="asset_model__manufacturer_id__short_description ASC"', 'ReverseSortByCommand="asset_model__manufacturer_id__short_description DESC"', 'CssClass="dtg_column"'));
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt('Model Number', '<?= htmlentities(QString::Truncate($_ITEM->AssetModelCode, 200)); ?>', 'FontBold=true', 'SortByCommand="asset_model_code ASC"', 'ReverseSortByCommand="asset_model_code DESC"', 'CssClass="dtg_column"'));
// Add the custom field columns with Display set to false. These can be shown by using the column toggle menu.
$objCustomFieldArray = CustomField::LoadObjCustomFieldArray(EntityQtype::AssetModel, false);
if ($objCustomFieldArray) {
foreach ($objCustomFieldArray as $objCustomField) {
//Only add the custom field column if the role has authorization to view it.
if ($objCustomField->objRoleAuthView && $objCustomField->objRoleAuthView->AuthorizedFlag) {
$this->dtgAssetModel->AddColumn(new QDataGridColumnExt($objCustomField->ShortDescription, '<?= $_ITEM->GetVirtualAttribute(\'' . $objCustomField->CustomFieldId . '\') ?>', 'SortByCommand="__' . $objCustomField->CustomFieldId . ' ASC"', 'ReverseSortByCommand="__' . $objCustomField->CustomFieldId . ' DESC"', 'HtmlEntities="false"', 'CssClass="dtg_column"', 'Display="false"'));
}
}
}
$this->dtgAssetModel->SortColumnIndex = 2;
$this->dtgAssetModel->SortDirection = 0;
$objStyle = $this->dtgAssetModel->RowStyle;
$objStyle->ForeColor = '#000000';
$objStyle->BackColor = '#FFFFFF';
$objStyle->FontSize = 12;
$objStyle = $this->dtgAssetModel->AlternateRowStyle;
$objStyle->BackColor = '#EFEFEF';
$objStyle = $this->dtgAssetModel->HeaderRowStyle;
$objStyle->ForeColor = '#000000';
$objStyle->BackColor = '#EFEFEF';
$objStyle->CssClass = 'dtg_header';
$this->dtgAssetModel->SetDataBinder('dtgAssetModel_Bind', $this);
$this->lstCategory_Create();
$this->lstManufacturer_Create();
$this->txtDescription_Create();
$this->txtAssetModelCode_Create();
$this->btnSearch_Create();
$this->btnClear_Create();
$this->ctlAdvanced_Create();
$this->lblAdvanced_Create();
}
/**
* Count AssetModels
* by ModifiedBy Index(es)
* @param integer $intModifiedBy
* @return int
*/
public static function CountByModifiedBy($intModifiedBy)
{
// Call AssetModel::QueryCount to perform the CountByModifiedBy query
return AssetModel::QueryCount(QQ::Equal(QQN::AssetModel()->ModifiedBy, $intModifiedBy));
}
/**
* Count AssetModels
* by DepreciationClassId Index(es)
* @param integer $intDepreciationClassId
* @return int
*/
public static function CountByDepreciationClassId($intDepreciationClassId, $objOptionalClauses = null)
{
// Call AssetModel::QueryCount to perform the CountByDepreciationClassId query
return AssetModel::QueryCount(QQ::Equal(QQN::AssetModel()->DepreciationClassId, $intDepreciationClassId), $objOptionalClauses);
}
