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->dtgCompany_EditLinkColumn_Render($_ITEM) ?>'); $this->colEditLinkColumn->HtmlEntities = false; $this->colCompanyId = new QDataGridColumn(QApplication::Translate('Company Id'), '<?= $_ITEM->CompanyId; ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->CompanyId), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->CompanyId, false))); $this->colAddressId = new QDataGridColumn(QApplication::Translate('Address Id'), '<?= $_CONTROL->ParentControl->dtgCompany_Address_Render($_ITEM); ?>'); $this->colShortDescription = new QDataGridColumn(QApplication::Translate('Short Description'), '<?= QString::Truncate($_ITEM->ShortDescription, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->ShortDescription), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->ShortDescription, false))); $this->colWebsite = new QDataGridColumn(QApplication::Translate('Website'), '<?= QString::Truncate($_ITEM->Website, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->Website), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->Website, false))); $this->colTelephone = new QDataGridColumn(QApplication::Translate('Telephone'), '<?= QString::Truncate($_ITEM->Telephone, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->Telephone), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->Telephone, false))); $this->colFax = new QDataGridColumn(QApplication::Translate('Fax'), '<?= QString::Truncate($_ITEM->Fax, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->Fax), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->Fax, false))); $this->colEmail = new QDataGridColumn(QApplication::Translate('Email'), '<?= QString::Truncate($_ITEM->Email, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->Email), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->Email, false))); $this->colLongDescription = new QDataGridColumn(QApplication::Translate('Long Description'), '<?= QString::Truncate($_ITEM->LongDescription, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->LongDescription), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->LongDescription, false))); $this->colCreatedBy = new QDataGridColumn(QApplication::Translate('Created By'), '<?= $_CONTROL->ParentControl->dtgCompany_CreatedByObject_Render($_ITEM); ?>'); $this->colCreationDate = new QDataGridColumn(QApplication::Translate('Creation Date'), '<?= $_CONTROL->ParentControl->dtgCompany_CreationDate_Render($_ITEM); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->CreationDate), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->CreationDate, false))); $this->colModifiedBy = new QDataGridColumn(QApplication::Translate('Modified By'), '<?= $_CONTROL->ParentControl->dtgCompany_ModifiedByObject_Render($_ITEM); ?>'); $this->colModifiedDate = new QDataGridColumn(QApplication::Translate('Modified Date'), '<?= QString::Truncate($_ITEM->ModifiedDate, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->ModifiedDate), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->ModifiedDate, false))); // Setup DataGrid $this->dtgCompany = new QDataGrid($this); $this->dtgCompany->CellSpacing = 0; $this->dtgCompany->CellPadding = 4; $this->dtgCompany->BorderStyle = QBorderStyle::Solid; $this->dtgCompany->BorderWidth = 1; $this->dtgCompany->GridLines = QGridLines::Both; // Datagrid Paginator $this->dtgCompany->Paginator = new QPaginator($this->dtgCompany); $this->dtgCompany->ItemsPerPage = 10; // Specify Whether or Not to Refresh using Ajax $this->dtgCompany->UseAjax = true; // Specify the local databind method this datagrid will use $this->dtgCompany->SetDataBinder('dtgCompany_Bind', $this); $this->dtgCompany->AddColumn($this->colEditLinkColumn); $this->dtgCompany->AddColumn($this->colCompanyId); $this->dtgCompany->AddColumn($this->colAddressId); $this->dtgCompany->AddColumn($this->colShortDescription); $this->dtgCompany->AddColumn($this->colWebsite); $this->dtgCompany->AddColumn($this->colTelephone); $this->dtgCompany->AddColumn($this->colFax); $this->dtgCompany->AddColumn($this->colEmail); $this->dtgCompany->AddColumn($this->colLongDescription); $this->dtgCompany->AddColumn($this->colCreatedBy); $this->dtgCompany->AddColumn($this->colCreationDate); $this->dtgCompany->AddColumn($this->colModifiedBy); $this->dtgCompany->AddColumn($this->colModifiedDate); // Setup the Create New button $this->btnCreateNew = new QButton($this); $this->btnCreateNew->Text = QApplication::Translate('Create a New') . ' ' . QApplication::Translate('Company'); $this->btnCreateNew->AddAction(new QClickEvent(), new QAjaxControlAction($this, 'btnCreateNew_Click')); }
public function __construct($objParentObject, $strClosePanelMethod, $arrayShipmentId) { try { parent::__construct($objParentObject); } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } $this->objCompanyArray = Company::LoadAll(QQ::Clause(QQ::OrderBy(QQN::Company()->ShortDescription))); $this->arrShipmentToEdit = $arrayShipmentId; $this->chkShipDate_Create(); $this->chkCourier_Create(); $this->chkToCompany_Create(); $this->chkFromCompany_Create(); $this->chkNote_Create(); $this->calShipDate_Create(); $this->lstCourier_Create(); $this->lstToCompany_Create(); $this->lstToContact_Create(); $this->lstToAddress_Create(); $this->lstFromCompany_Create(); $this->lstFromContact_Create(); $this->lstFromAddress_Create(); $this->txtNote_Create(); $this->lblWarning_Create(); $this->btnApply_Create(); $this->btnCancel_Create(); // Disable inputs $this->calShipDate->Enabled = false; $this->lstToCompany->Enabled = false; $this->lstToContact->Enabled = false; $this->lstToAddress->Enabled = false; $this->lstFromCompany->Enabled = false; $this->lstFromAddress->Enabled = false; $this->lstFromContact->Enabled = false; $this->lstCourier->Enabled = false; $this->txtNote->Enabled = false; // Load Custom Fields $this->objCustomFieldArray = CustomField::LoadObjCustomFieldArray(EntityQtype::Shipment, false); if ($this->objCustomFieldArray) { $this->arrCustomFields = CustomField::CustomFieldControlsCreate($this->objCustomFieldArray, false, $this, true, true, false); foreach ($this->arrCustomFields as $field) { $field['input']->Enabled = false; $this->arrCheckboxes[$field['input']->strControlId] = new QCheckBox($this, 'chk' . $field['input']->strControlId); $this->arrCheckboxes[$field['input']->strControlId]->Checked = false; $this->arrCheckboxes[$field['input']->strControlId]->AddAction(new QClickEvent(), new QJavaScriptAction("enableInput(this)")); } } }
protected function Form_Create() { // Setup DataGrid Columns $this->colEditLinkColumn = new QDataGridColumn(QApplication::Translate('Edit'), '<?= $_FORM->dtgCompany_EditLinkColumn_Render($_ITEM) ?>'); $this->colEditLinkColumn->HtmlEntities = false; $this->colCompanyId = new QDataGridColumn(QApplication::Translate('Company Id'), '<?= $_ITEM->CompanyId; ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->CompanyId), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->CompanyId, false))); $this->colAddressId = new QDataGridColumn(QApplication::Translate('Address Id'), '<?= $_FORM->dtgCompany_Address_Render($_ITEM); ?>'); $this->colShortDescription = new QDataGridColumn(QApplication::Translate('Short Description'), '<?= QString::Truncate($_ITEM->ShortDescription, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->ShortDescription), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->ShortDescription, false))); $this->colWebsite = new QDataGridColumn(QApplication::Translate('Website'), '<?= QString::Truncate($_ITEM->Website, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->Website), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->Website, false))); $this->colTelephone = new QDataGridColumn(QApplication::Translate('Telephone'), '<?= QString::Truncate($_ITEM->Telephone, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->Telephone), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->Telephone, false))); $this->colFax = new QDataGridColumn(QApplication::Translate('Fax'), '<?= QString::Truncate($_ITEM->Fax, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->Fax), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->Fax, false))); $this->colEmail = new QDataGridColumn(QApplication::Translate('Email'), '<?= QString::Truncate($_ITEM->Email, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->Email), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->Email, false))); $this->colLongDescription = new QDataGridColumn(QApplication::Translate('Long Description'), '<?= QString::Truncate($_ITEM->LongDescription, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->LongDescription), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->LongDescription, false))); $this->colCreatedBy = new QDataGridColumn(QApplication::Translate('Created By'), '<?= $_FORM->dtgCompany_CreatedByObject_Render($_ITEM); ?>'); $this->colCreationDate = new QDataGridColumn(QApplication::Translate('Creation Date'), '<?= $_FORM->dtgCompany_CreationDate_Render($_ITEM); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->CreationDate), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->CreationDate, false))); $this->colModifiedBy = new QDataGridColumn(QApplication::Translate('Modified By'), '<?= $_FORM->dtgCompany_ModifiedByObject_Render($_ITEM); ?>'); $this->colModifiedDate = new QDataGridColumn(QApplication::Translate('Modified Date'), '<?= QString::Truncate($_ITEM->ModifiedDate, 200); ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->ModifiedDate), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->ModifiedDate, false))); $this->colCompanyCustomFieldHelper = new QDataGridColumn(QApplication::Translate('Company Custom Field Helper'), '<?= $_FORM->dtgCompany_CompanyCustomFieldHelper_Render($_ITEM); ?>'); // Setup DataGrid $this->dtgCompany = new QDataGrid($this); $this->dtgCompany->CellSpacing = 0; $this->dtgCompany->CellPadding = 4; $this->dtgCompany->BorderStyle = QBorderStyle::Solid; $this->dtgCompany->BorderWidth = 1; $this->dtgCompany->GridLines = QGridLines::Both; // Datagrid Paginator $this->dtgCompany->Paginator = new QPaginator($this->dtgCompany); $this->dtgCompany->ItemsPerPage = 10; // Specify Whether or Not to Refresh using Ajax $this->dtgCompany->UseAjax = false; // Specify the local databind method this datagrid will use $this->dtgCompany->SetDataBinder('dtgCompany_Bind'); $this->dtgCompany->AddColumn($this->colEditLinkColumn); $this->dtgCompany->AddColumn($this->colCompanyId); $this->dtgCompany->AddColumn($this->colAddressId); $this->dtgCompany->AddColumn($this->colShortDescription); $this->dtgCompany->AddColumn($this->colWebsite); $this->dtgCompany->AddColumn($this->colTelephone); $this->dtgCompany->AddColumn($this->colFax); $this->dtgCompany->AddColumn($this->colEmail); $this->dtgCompany->AddColumn($this->colLongDescription); $this->dtgCompany->AddColumn($this->colCreatedBy); $this->dtgCompany->AddColumn($this->colCreationDate); $this->dtgCompany->AddColumn($this->colModifiedBy); $this->dtgCompany->AddColumn($this->colModifiedDate); $this->dtgCompany->AddColumn($this->colCompanyCustomFieldHelper); }
protected function lstCompany_Create() { $this->lstCompany = new QListBox($this); $this->lstCompany->Name = QApplication::Translate('Company'); $this->lstCompany->Required = true; if (!$this->blnEditMode) { $this->lstCompany->AddItem(QApplication::Translate('- Select One -'), null); } $objCompanyArray = Company::LoadAll(QQ::Clause(QQ::OrderBy(QQN::Company()->ShortDescription))); if ($objCompanyArray) { foreach ($objCompanyArray as $objCompany) { $objListItem = new QListItem($objCompany->__toString(), $objCompany->CompanyId); if ($objCompany->CompanyId == $this->intCompanyId) { $objListItem->Selected = true; } $this->lstCompany->AddItem($objListItem); } } }
protected function lstFromCompany_Create() { $this->lstFromCompany = new QListBox($this); $this->lstFromCompany->Name = QApplication::Translate('From Company'); $this->lstFromCompany->Required = true; if (!$this->blnEditMode) { $this->lstFromCompany->AddItem('- Select One -', null); } $objFromCompanyArray = Company::LoadAll(QQ::Clause(QQ::OrderBy(QQN::Company()->ShortDescription))); if ($objFromCompanyArray) { foreach ($objFromCompanyArray as $objFromCompany) { $objListItem = new QListItem($objFromCompany->__toString(), $objFromCompany->CompanyId); if ($this->objReceipt->FromCompany && $this->objReceipt->FromCompany->CompanyId == $objFromCompany->CompanyId) { $objListItem->Selected = true; } $this->lstFromCompany->AddItem($objListItem); } } $this->lstFromCompany->AddAction(new QChangeEvent(), new QAjaxAction('lstFromCompany_Select')); $this->lstFromCompany->TabIndex = 1; $this->intNextTabIndex++; $this->lstFromCompany->Focus(); }
protected function dtgCompany_Create() { $this->dtgCompany = new QDataGrid($this); $this->dtgCompany->Name = 'company_list'; $this->dtgCompany->CellPadding = 5; $this->dtgCompany->CellSpacing = 0; $this->dtgCompany->CssClass = "datagrid"; // Disable AJAX for the datagrid $this->dtgCompany->UseAjax = false; // Allow for column toggling $this->dtgCompany->ShowColumnToggle = true; // Allow for CSV Export $this->dtgCompany->ShowExportCsv = true; // Enable Pagination $objPaginator = new QPaginator($this->dtgCompany); $this->dtgCompany->Paginator = $objPaginator; $this->dtgCompany->ItemsPerPage = QApplication::$TracmorSettings->SearchResultsPerPage; // Add Checkbox Column /*$this->dtgCompany->AddColumn(new QDataGridColumnExt('<?= $_CONTROL->chkSelectAll_Render() ?>', '<?=$_CONTROL->chkSelected_Render($_ITEM->CompanyId) ?>', 'CssClass="dtg_column"', 'HtmlEntities=false'));*/ $this->dtgCompany->AddColumn(new QDataGridColumnExt('ID', '<?= $_ITEM->CompanyId ?>', array('OrderByClause' => QQ::OrderBy(QQN::Company()->CompanyId), 'ReverseOrderByClause' => QQ::OrderBy(QQN::Company()->CompanyId, false), 'CssClass' => "dtg_column", 'HtmlEntities' => false))); $this->dtgCompany->AddColumn(new QDataGridColumnExt('<img src=../images/icons/attachment_gray.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->dtgCompany->AddColumn(new QDataGridColumnExt('Company Name', '<?= $_ITEM->__toStringWithLink("bluelink") ?>', 'SortByCommand="short_description ASC"', 'ReverseSortByCommand="short_description DESC"', 'CssClass="dtg_column"', 'HtmlEntities=false')); $this->dtgCompany->AddColumn(new QDataGridColumnExt('City', '<?= $_ITEM->__toStringCity() ?>', 'Width=200', 'SortByCommand="company__address_id__city ASC"', 'ReverseSortByCommand="company__address_id__city DESC"', 'CssClass="dtg_column"')); $this->dtgCompany->AddColumn(new QDataGridColumnExt('State/Province', '<?= $_ITEM->__toStringStateProvince() ?>', 'SortByCommand="company__address_id__state_province_id__short_description ASC"', 'ReverseSortByCommand="company__address_id__state_province_id__short_description DESC"', 'CssClass="dtg_column"')); $this->dtgCompany->AddColumn(new QDataGridColumnExt('Country', '<?= $_ITEM->__toStringCountry() ?>', 'SortByCommand="company__address_id__country_id__short_description ASC"', 'ReverseSortByCommand="company__address_id__country_id__short_description 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(7, 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->dtgCompany->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->dtgCompany->SortColumnIndex = 2; $this->dtgCompany->SortDirection = 0; $objStyle = $this->dtgCompany->RowStyle; $objStyle->ForeColor = '#000000'; $objStyle->BackColor = '#FFFFFF'; $objStyle->FontSize = 12; $objStyle = $this->dtgCompany->AlternateRowStyle; $objStyle->BackColor = '#EFEFEF'; $objStyle = $this->dtgCompany->HeaderRowStyle; $objStyle->ForeColor = '#000000'; $objStyle->BackColor = '#EFEFEF'; $objStyle->CssClass = 'dtg_header'; $this->dtgCompany->SetDataBinder('dtgCompany_Bind'); }
protected function Form_Create() { // check rigths for the Inventory to Ship $this->blnShowInventory = true; $objRoleModule = RoleModule::LoadByRoleIdModuleId(QApplication::$objUserAccount->RoleId, 3); if ($objRoleModule->AccessFlag) { $objRoleModuleAuthorization = RoleModuleAuthorization::LoadByRoleModuleIdAuthorizationId($objRoleModule->RoleModuleId, 2); if ($objRoleModuleAuthorization->AuthorizationLevelId == 3) { $this->blnShowInventory = false; } } else { $this->blnShowInventory = false; } // Call SetupShipment to either Load/Edit Existing or Create New $this->SetupShipment(); $this->objCompanyArray = Company::LoadAll(QQ::Clause(QQ::OrderBy(QQN::Company()->ShortDescription))); // Create the Header Menu $this->ctlHeaderMenu_Create(); // Create the Shortcut Menu $this->ctlShortcutMenu_Create(); // Packing List Link $this->lblPackingListLink_Create(); // Shipping Labels $this->lblShipmentNumber_Create(); $this->lblHeaderShipment_Create(); $this->lblShipDate_Create(); $this->lblFromCompany_Create(); $this->lblFromContact_Create(); $this->lblFromAddress_Create(); $this->lstToCompany_Create(); $this->lblNewToCompany_Create(); $this->lstToContact_Create(); $this->lblNewToContact_Create(); $this->lstToAddress_Create(); $this->lblNewToAddress_Create(); $this->lblFromAddressFull_Create(); $this->lblToCompany_Create(); $this->lblToContact_Create(); $this->lblToAddress_Create(); $this->lblToAddressFull_Create(); $this->lblCourier_Create(); $this->pnlNote_Create(); $this->lblTrackingNumber_Create(); // Shipping Inputs $this->dlgExchange_Create(); $this->dlgDueDate_Create(); $this->calShipDate_Create(); $this->lstFromCompany_Create(); $this->lblNewFromCompany_Create(); $this->lstFromContact_Create(); $this->lblNewFromContact_Create(); $this->lstFromAddress_Create(); $this->lblNewFromAddress_Create(); if (QApplication::$TracmorSettings->CustomShipmentNumbers) { $this->txtShipmentNumber_Create(); } $this->lstCourier_Create(); $this->txtNote_Create(); $this->txtNewAssetCode_Create(); if ($this->blnShowInventory) { $this->txtNewInventoryModelCode_Create(); $this->btnLookup_Create(); $this->ctlInventorySearchTool_Create(); $this->lstSourceLocation_Create(); $this->txtQuantity_Create(); $this->btnAddInventory_Create(); } $this->txtTrackingNumber_Create(); //$this->lblAdvanced_Create(); $this->txtReceiptAssetCode_Create(); $this->chkAutoGenerateAssetCode_Create(); $this->dtpScheduleReceiptDueDate_Create(); $this->rblAssetType_Create(); $this->chkScheduleReceipt_Create(); $this->btnAddAsset_Create(); $this->ctlAssetSearchTool_Create(); $this->btnSaveExchange_Create(); $this->btnCancelExchange_Create(); $this->btnSaveDueDate_Create(); $this->btnCancelDueDate_Create(); $this->pnlAttachments_Create(); // Create all custom asset fields $this->customFields_Create(); //Set display logic of Built-In Fields $this->UpdateBuiltInFields(); $this->UpdateAddressAccess(); $this->UpdateCompanyAccess(); $this->UpdateContactAccess(); // New entities Dialog $this->dlgNew_Create(); if (!$this->objShipment->ShippedFlag) { // Shipping Buttons $this->btnDelete_Create(); } $this->btnSave_Create(); $this->btnCancel_Create(); $this->btnEdit_Create(); $this->atcAttach_Create(); // Complete Shipment Buttons $this->btnCompleteShipment_Create(); $this->btnCancelShipment_Create(); $this->btnCancelCompleteShipment_Create(); // Shipping Datagrids $this->dtgAssetTransact_Create(); $this->dtgInventoryTransact_Create(); // Load the objAssetTransactionArray and objInventoryTransactionArray for the first time if ($this->blnEditMode) { $objClauses = array(); if ($objClause = $this->dtgAssetTransact->OrderByClause) { array_push($objClauses, $objClause); } /*if ($objClause = $this->dtgAssetTransact->LimitClause) array_push($objClauses, $objClause);*/ if ($objClause = QQ::Expand(QQN::AssetTransaction()->Asset->AssetModel)) { array_push($objClauses, $objClause); } if ($objClause = QQ::Expand(QQN::AssetTransaction()->SourceLocation)) { } array_push($objClauses, $objClause); $this->objAssetTransactionArray = AssetTransaction::LoadArrayByTransactionId($this->objShipment->TransactionId, $objClauses); $objClauses = null; $objClauses = array(); if ($objClause = $this->dtgInventoryTransact->OrderByClause) { array_push($objClauses, $objClause); } /*if ($objClause = $this->dtgInventoryTransact->LimitClause) array_push($objClauses, $objClause);*/ if ($objClause = QQ::Expand(QQN::InventoryTransaction()->InventoryLocation->InventoryModel)) { } array_push($objClauses, $objClause); $this->objInventoryTransactionArray = InventoryTransaction::LoadArrayByTransactionId($this->objShipment->TransactionId, $objClauses); // If shipped, display labels. Otherwise, we don't need to call DisplayLabels because only labels are on the QPanel. $this->DisplayLabels(); } elseif (!$this->blnEditMode) { $this->DisplayInputs(); } // Check if there is an Asset or InventoryModel ID in the query string to automatically add them - they would be coming from AssetEdit or InventoryEdit if (!$this->blnEditMode) { $intAssetId = QApplication::QueryString('intAssetId'); // If an Asset was passed in the query string, load the txt in the Asset Tag text box and click the add button if ($intAssetId) { $objAsset = Asset::Load($intAssetId); if ($objAsset) { $this->txtNewAssetCode->Text = $objAsset->AssetCode; $this->btnAddAsset_Click($this, null, null); } } $intInventoryModelId = QApplication::QueryString('intInventoryModelId'); // If an InventoryModel was passed in the query string, load the text in the InventoryModel text box and set the focus to the quantity box if ($intInventoryModelId) { $objInventoryModel = InventoryModel::Load($intInventoryModelId); if ($objInventoryModel) { $this->txtNewInventoryModelCode->Text = $objInventoryModel->InventoryModelCode; $this->btnLookup_Click($this, null, null); QApplication::ExecuteJavaScript(sprintf("document.getElementById('%s').focus()", $this->lstSourceLocation->ControlId)); } } } }
/** * Count Companies * by ModifiedBy Index(es) * @param integer $intModifiedBy * @return int */ public static function CountByModifiedBy($intModifiedBy, $objOptionalClauses = null) { // Call Company::QueryCount to perform the CountByModifiedBy query return Company::QueryCount(QQ::Equal(QQN::Company()->ModifiedBy, $intModifiedBy), $objOptionalClauses); }
protected function lstCompany_Create() { $this->lstCompany = new QListBox($this); $this->lstCompany->Name = QApplication::Translate('Company'); $this->lstCompany->Required = true; if (!$this->blnEditMode) { $this->lstCompany->AddItem('- Select One -', null); //$this->lstCompany->AddItem('New Company', -1, false); } $objCompanyArray = Company::LoadAll(QQ::Clause(QQ::OrderBy(QQN::Company()->ShortDescription))); if ($objCompanyArray) { foreach ($objCompanyArray as $objCompany) { $objListItem = new QListItem($objCompany->__toString(), $objCompany->CompanyId); if ($this->objContact->Company && $this->objContact->Company->CompanyId == $objCompany->CompanyId) { $objListItem->Selected = true; } $this->lstCompany->AddItem($objListItem); } } $this->lstCompany->AddAction(new QChangeEvent(), new QAjaxAction('lstCompany_Select')); QApplication::ExecuteJavaScript(sprintf("document.getElementById('%s').focus()", $this->lstCompany->ControlId)); $this->lstCompany->TabIndex = $this->intTabIndex++; }
/** * Used internally by the Meta-based Add Column tools. * * Given a QQNode or a Text String, this will return a Company-based QQNode. * It will also verify that it is a proper Company-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 == 'company') { 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 "company".'); } } else { if (is_string($mixContent)) { switch ($mixContent) { case 'CompanyId': return QQN::Company()->CompanyId; case 'AddressId': return QQN::Company()->AddressId; case 'Address': return QQN::Company()->Address; case 'ShortDescription': return QQN::Company()->ShortDescription; case 'Website': return QQN::Company()->Website; case 'Telephone': return QQN::Company()->Telephone; case 'Fax': return QQN::Company()->Fax; case 'Email': return QQN::Company()->Email; case 'LongDescription': return QQN::Company()->LongDescription; case 'CreatedBy': return QQN::Company()->CreatedBy; case 'CreatedByObject': return QQN::Company()->CreatedByObject; case 'CreationDate': return QQN::Company()->CreationDate; case 'ModifiedBy': return QQN::Company()->ModifiedBy; case 'ModifiedByObject': return QQN::Company()->ModifiedByObject; case 'ModifiedDate': return QQN::Company()->ModifiedDate; case 'CompanyCustomFieldHelper': return QQN::Company()->CompanyCustomFieldHelper; default: throw new QCallerException('Simple Property not found in CompanyDataGrid 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'); } } } }
protected function lstCompany_Create() { $this->lstCompany = new QListBox($this); $this->lstCompany->Name = QApplication::Translate('Default Shipping & Receiving Company:'); $this->lstCompany->Required = false; $this->lstCompany->AddItem('- Select One -', null); $objCompanyArray = Company::LoadAll(QQ::Clause(QQ::OrderBy(QQN::Company()->ShortDescription))); if ($objCompanyArray) { foreach ($objCompanyArray as $objCompany) { $objListItem = new QListItem($objCompany->__toString(), $objCompany->CompanyId); if (QApplication::$TracmorSettings->CompanyId && QApplication::$TracmorSettings->CompanyId == $objCompany->CompanyId) { $objListItem->Selected = true; } $this->lstCompany->AddItem($objListItem); } } $this->lstCompany->AddAction(new QChangeEvent(), new QAjaxAction('lstCompany_Change')); $this->lstCompany->AddAction(new QEnterKeyEvent(), new QAjaxAction('btnSave_Click')); $this->lstCompany->AddAction(new QEnterKeyEvent(), new QTerminateAction()); }
/** * Count Companies * by ModifiedBy Index(es) * @param integer $intModifiedBy * @return int */ public static function CountByModifiedBy($intModifiedBy) { // Call Company::QueryCount to perform the CountByModifiedBy query return Company::QueryCount(QQ::Equal(QQN::Company()->ModifiedBy, $intModifiedBy)); }
protected function btnSave_Click($strFormId, $strControlId, $strParameter) { try { $blnError = false; if (trim($this->txtShortDescription->Text) == "") { $this->txtShortDescription->Warning = 'Short description is required'; $blnError = true; } if (!$this->blnEditMode) { if ($this->txtAddressShortDescription->Text) { if (!$this->txtAddress1->Text) { $this->txtAddress1->Warning = 'Address is a required field.'; $blnError = true; } if (!$this->txtCity->Text) { $this->txtCity->Warning = 'City is a required field.'; $blnError = true; } if (!$this->txtPostalCode->Text) { $this->txtPostalCode->Warning = 'Postal Code is a required field.'; $blnError = true; } if (!$this->lstCountry->SelectedValue) { $this->lstCountry->Warning = 'Country is a required field.'; $blnError = true; } } elseif ($this->txtAddress1->Text || $this->txtAddress2->Text || $this->txtCity->Text || $this->lstStateProvince->SelectedValue || $this->txtPostalCode->Text || $this->lstCountry->SelectedValue) { $this->txtAddressShortDescription->Warning = 'Address Name is a required field.'; return; } } if ($blnError) { return; } // Do not allow duplicate Company names if ($this->blnEditMode) { $objCompanyDuplicate = Company::QuerySingle(QQ::AndCondition(QQ::Equal(QQN::Company()->ShortDescription, $this->txtShortDescription->Text), QQ::NotEqual(QQN::Company()->CompanyId, $this->objCompany->CompanyId))); } else { $objCompanyDuplicate = Company::QuerySingle(QQ::Equal(QQN::Company()->ShortDescription, $this->txtShortDescription->Text)); } if ($objCompanyDuplicate) { $blnError = true; $this->txtShortDescription->Warning = 'A company with that name already exists. Please try another'; return; } $this->UpdateCompanyFields(); $this->objCompany->Save(); // Assign input values to custom fields if ($this->arrCustomFields) { // Save the values from all of the custom field controls to save the asset CustomField::SaveControls($this->objCompany->objCustomFieldArray, $this->blnEditMode, $this->arrCustomFields, $this->objCompany->CompanyId, 7); } $this->SaveNewAddress(); if ($this->blnEditMode) { //$this->SetupCompany(); $this->UpdateCompanyLabels(); $this->DisplayLabels(); } elseif (!$this->blnEditMode) { QApplication::Redirect('company_edit.php?intCompanyId=' . $this->objCompany->CompanyId); } } catch (QExtendedOptimisticLockingException $objExc) { $this->btnCancel->Warning = sprintf('This company has been updated by another user. You must <a href="company_edit.php?intCompanyId=%s">Refresh</a> to edit this company.', $this->objCompany->CompanyId); } }
protected function Form_Create() { // Call SetupShipment to either Load/Edit Existing or Create New $this->SetupShipment(); // If the courier is FedEx, load the FedexShipment object if ($this->blnEditMode) { if ($this->objShipment->CourierId === 1) { $this->objFedexShipment = FedexShipment::LoadByShipmentId($this->objShipment->ShipmentId); } } $this->objCompanyArray = Company::LoadAll(QQ::Clause(QQ::OrderBy(QQN::Company()->ShortDescription))); // Create the Header Menu $this->ctlHeaderMenu_Create(); // Create the Shortcut Menu $this->ctlShortcutMenu_Create(); // FedEx Shipment Panel $this->pnlFedExShipment_Create(); // Packing List Link $this->lblPackingListLink_Create(); $this->lblFedexShippingLabelLink_Create(); // Shipping Labels $this->lblShipmentNumber_Create(); $this->lblHeaderShipment_Create(); // $this->lblHeaderCompleteShipment_Create(); $this->lblShipDate_Create(); $this->lblFromCompany_Create(); $this->lblFromContact_Create(); $this->lblFromAddress_Create(); $this->lblFromAddressFull_Create(); $this->lblToCompany_Create(); $this->lblToContact_Create(); $this->lblToAddress_Create(); $this->lblToAddressFull_Create(); $this->lblCourier_Create(); $this->lblToPhone_Create(); $this->lblBillTransportationTo_Create(); $this->lblReference_Create(); $this->lblFedexNotifySenderEmail_Create(); $this->lblFedexNotifyRecipientEmail_Create(); $this->lblFedexNotifyOtherEmail_Create(); $this->lblHoldAtLocationAddress_Create(); $this->lblHoldAtLocationCity_Create(); $this->lblHoldAtLocationState_Create(); $this->lblHoldAtLocationPostalCode_Create(); $this->pnlNote_Create(); $this->lblTrackingNumber_Create(); $this->lblSenderLabel_Create(); $this->lblPayerAccount_Create(); $this->lblFxServiceType_Create(); $this->lblPackageType_Create(); $this->lblPackageWeight_Create(); $this->lblPackageLength_Create(); $this->lblPackageWidth_Create(); $this->lblPackageHeight_Create(); $this->lblValue_Create(); $this->lblWeightUnit_Create(); $this->lblLengthUnit_Create(); $this->lblCurrencyUnit_Create(); // Shipping Inputs $this->dlgExchange_Create(); $this->dlgDueDate_Create(); $this->calShipDate_Create(); $this->lstFromCompany_Create(); $this->lblNewFromCompany_Create(); $this->lstFromContact_Create(); $this->lblNewFromContact_Create(); $this->lstFromAddress_Create(); $this->lblNewFromAddress_Create(); $this->lstToCompany_Create(); $this->lblNewToCompany_Create(); $this->lstToContact_Create(); $this->lblNewToContact_Create(); $this->txtToPhone_Create(); $this->lstBillTransportationTo_Create(); $this->lstShippingAccount_Create(); $this->txtReference_Create(); $this->txtFedexNotifySenderEmail_Create(); $this->txtFedexNotifyRecipientEmail_Create(); $this->txtFedexNotifyOtherEmail_Create(); $this->chkFedexNotifySenderShipFlag_Create(); $this->chkFedexNotifySenderExceptionFlag_Create(); $this->chkFedexNotifySenderDeliveryFlag_Create(); $this->chkFedexNotifyRecipientShipFlag_Create(); $this->chkFedexNotifyRecipientExceptionFlag_Create(); $this->chkFedexNotifyRecipientDeliveryFlag_Create(); $this->chkFedexNotifyOtherShipFlag_Create(); $this->chkFedexNotifyOtherExceptionFlag_Create(); $this->chkFedexNotifyOtherDeliveryFlag_Create(); $this->lstFxServiceType_Create(); $this->txtRecipientThirdPartyAccount_Create(); $this->lstPackageType_Create(); $this->txtPackageWeight_Create(); $this->lstWeightUnit_Create(); $this->txtPackageLength_Create(); $this->txtPackageWidth_Create(); $this->txtPackageHeight_Create(); $this->lstLengthUnit_Create(); $this->txtValue_Create(); $this->lstCurrencyUnit_Create(); $this->chkSaturdayDeliveryFlag_Create(); $this->chkHoldAtLocationFlag_Create(); $this->txtHoldAtLocationAddress_Create(); $this->txtHoldAtLocationCity_Create(); $this->lstHoldAtLocationState_Create(); $this->txtHoldAtLocationPostalCode_Create(); $this->lstToAddress_Create(); $this->lblNewToAddress_Create(); if (QApplication::$TracmorSettings->CustomShipmentNumbers) { $this->txtShipmentNumber_Create(); } $this->lstCourier_Create(); $this->txtNote_Create(); $this->txtNewAssetCode_Create(); $this->txtNewInventoryModelCode_Create(); $this->lstSourceLocation_Create(); $this->txtQuantity_Create(); $this->txtTrackingNumber_Create(); //$this->lblAdvanced_Create(); $this->txtReceiptAssetCode_Create(); $this->chkAutoGenerateAssetCode_Create(); $this->dtpScheduleReceiptDueDate_Create(); $this->rblAssetType_Create(); $this->chkScheduleReceipt_Create(); $this->btnAddAsset_Create(); $this->btnLookup_Create(); $this->btnAddInventory_Create(); $this->btnSaveExchange_Create(); $this->btnCancelExchange_Create(); $this->btnSaveDueDate_Create(); $this->btnCancelDueDate_Create(); $this->pnlAttachments_Create(); // Create all custom asset fields $this->customFields_Create(); //Set display logic of Built-In Fields $this->UpdateBuiltInFields(); $this->UpdateAddressAccess(); $this->UpdateCompanyAccess(); $this->UpdateContactAccess(); // New entities Dialog $this->dlgNew_Create(); if (!$this->objShipment->ShippedFlag) { // Shipping Buttons $this->btnSave_Create(); $this->btnCancel_Create(); $this->btnEdit_Create(); $this->btnDelete_Create(); } $this->atcAttach_Create(); // Complete Shipment Buttons $this->btnCompleteShipment_Create(); $this->btnCancelShipment_Create(); $this->btnCancelCompleteShipment_Create(); // Shipping Datagrids $this->dtgAssetTransact_Create(); $this->dtgInventoryTransact_Create(); // Load the objAssetTransactionArray and objInventoryTransactionArray for the first time if ($this->blnEditMode) { $objClauses = array(); if ($objClause = $this->dtgAssetTransact->OrderByClause) { array_push($objClauses, $objClause); } if ($objClause = $this->dtgAssetTransact->LimitClause) { array_push($objClauses, $objClause); } if ($objClause = QQ::Expand(QQN::AssetTransaction()->Asset->AssetModel)) { array_push($objClauses, $objClause); } if ($objClause = QQ::Expand(QQN::AssetTransaction()->SourceLocation)) { } array_push($objClauses, $objClause); $this->objAssetTransactionArray = AssetTransaction::LoadArrayByTransactionId($this->objShipment->TransactionId, $objClauses); $objClauses = null; $objClauses = array(); if ($objClause = $this->dtgInventoryTransact->OrderByClause) { array_push($objClauses, $objClause); } if ($objClause = $this->dtgInventoryTransact->LimitClause) { array_push($objClauses, $objClause); } if ($objClause = QQ::Expand(QQN::InventoryTransaction()->InventoryLocation->InventoryModel)) { } array_push($objClauses, $objClause); $this->objInventoryTransactionArray = InventoryTransaction::LoadArrayByTransactionId($this->objShipment->TransactionId, $objClauses); // If shipped, display labels. Otherwise, we don't need to call DisplayLabels because only labels are on the QPanel. $this->DisplayLabels(); } elseif (!$this->blnEditMode) { $this->DisplayInputs(); } // Check if there is an Asset or InventoryModel ID in the query string to automatically add them - they would be coming from AssetEdit or InventoryEdit if (!$this->blnEditMode) { $intAssetId = QApplication::QueryString('intAssetId'); // If an Asset was passed in the query string, load the txt in the Asset Code text box and click the add button if ($intAssetId) { $objAsset = Asset::Load($intAssetId); if ($objAsset) { $this->txtNewAssetCode->Text = $objAsset->AssetCode; $this->btnAddAsset_Click($this, null, null); } } $intInventoryModelId = QApplication::QueryString('intInventoryModelId'); // If an InventoryModel was passed in the query string, load the text in the InventoryModel text box and set the focus to the quantity box if ($intInventoryModelId) { $objInventoryModel = InventoryModel::Load($intInventoryModelId); if ($objInventoryModel) { $this->txtNewInventoryModelCode->Text = $objInventoryModel->InventoryModelCode; $this->btnLookup_Click($this, null, null); QApplication::ExecuteJavaScript(sprintf("document.getElementById('%s').focus()", $this->lstSourceLocation->ControlId)); } } } }