protected function lstToContact_Create()
{
$this->lstToContact = new QListBox($this);
$this->lstToContact->Name = QApplication::Translate('To Contact');
$this->lstToContact->Required = true;
if (!$this->blnEditMode) {
$this->lstToContact->AddItem(QApplication::Translate('- Select One -'), null);
}
$objToContactArray = Contact::LoadAll();
if ($objToContactArray) {
foreach ($objToContactArray as $objToContact) {
$objListItem = new QListItem($objToContact->__toString(), $objToContact->ContactId);
if ($this->objShipment->ToContact && $this->objShipment->ToContact->ContactId == $objToContact->ContactId) {
$objListItem->Selected = true;
}
$this->lstToContact->AddItem($objListItem);
}
}
}
/**
* Refresh this MetaControl with Data from the local Shipment object.
* @param boolean $blnReload reload Shipment from the database
* @return void
*/
public function Refresh($blnReload = false)
{
if ($blnReload) {
$this->objShipment->Reload();
}
if ($this->lblShipmentId) {
if ($this->blnEditMode) {
$this->lblShipmentId->Text = $this->objShipment->ShipmentId;
}
}
if ($this->txtShipmentNumber) {
$this->txtShipmentNumber->Text = $this->objShipment->ShipmentNumber;
}
if ($this->lblShipmentNumber) {
$this->lblShipmentNumber->Text = $this->objShipment->ShipmentNumber;
}
if ($this->lstTransaction) {
$this->lstTransaction->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstTransaction->AddItem(QApplication::Translate('- Select One -'), null);
}
$objTransactionArray = Transaction::LoadAll();
if ($objTransactionArray) {
foreach ($objTransactionArray as $objTransaction) {
$objListItem = new QListItem($objTransaction->__toString(), $objTransaction->TransactionId);
if ($this->objShipment->Transaction && $this->objShipment->Transaction->TransactionId == $objTransaction->TransactionId) {
$objListItem->Selected = true;
}
$this->lstTransaction->AddItem($objListItem);
}
}
}
if ($this->lblTransactionId) {
$this->lblTransactionId->Text = $this->objShipment->Transaction ? $this->objShipment->Transaction->__toString() : null;
}
if ($this->lstFromCompany) {
$this->lstFromCompany->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstFromCompany->AddItem(QApplication::Translate('- Select One -'), null);
}
$objFromCompanyArray = Company::LoadAll();
if ($objFromCompanyArray) {
foreach ($objFromCompanyArray as $objFromCompany) {
$objListItem = new QListItem($objFromCompany->__toString(), $objFromCompany->CompanyId);
if ($this->objShipment->FromCompany && $this->objShipment->FromCompany->CompanyId == $objFromCompany->CompanyId) {
$objListItem->Selected = true;
}
$this->lstFromCompany->AddItem($objListItem);
}
}
}
if ($this->lblFromCompanyId) {
$this->lblFromCompanyId->Text = $this->objShipment->FromCompany ? $this->objShipment->FromCompany->__toString() : null;
}
if ($this->lstFromContact) {
$this->lstFromContact->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstFromContact->AddItem(QApplication::Translate('- Select One -'), null);
}
$objFromContactArray = Contact::LoadAll();
if ($objFromContactArray) {
foreach ($objFromContactArray as $objFromContact) {
$objListItem = new QListItem($objFromContact->__toString(), $objFromContact->ContactId);
if ($this->objShipment->FromContact && $this->objShipment->FromContact->ContactId == $objFromContact->ContactId) {
$objListItem->Selected = true;
}
$this->lstFromContact->AddItem($objListItem);
}
}
}
if ($this->lblFromContactId) {
$this->lblFromContactId->Text = $this->objShipment->FromContact ? $this->objShipment->FromContact->__toString() : null;
}
if ($this->lstFromAddress) {
$this->lstFromAddress->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstFromAddress->AddItem(QApplication::Translate('- Select One -'), null);
}
$objFromAddressArray = Address::LoadAll();
if ($objFromAddressArray) {
foreach ($objFromAddressArray as $objFromAddress) {
$objListItem = new QListItem($objFromAddress->__toString(), $objFromAddress->AddressId);
if ($this->objShipment->FromAddress && $this->objShipment->FromAddress->AddressId == $objFromAddress->AddressId) {
$objListItem->Selected = true;
}
$this->lstFromAddress->AddItem($objListItem);
}
}
}
if ($this->lblFromAddressId) {
$this->lblFromAddressId->Text = $this->objShipment->FromAddress ? $this->objShipment->FromAddress->__toString() : null;
}
if ($this->lstToCompany) {
$this->lstToCompany->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstToCompany->AddItem(QApplication::Translate('- Select One -'), null);
}
$objToCompanyArray = Company::LoadAll();
if ($objToCompanyArray) {
foreach ($objToCompanyArray as $objToCompany) {
$objListItem = new QListItem($objToCompany->__toString(), $objToCompany->CompanyId);
if ($this->objShipment->ToCompany && $this->objShipment->ToCompany->CompanyId == $objToCompany->CompanyId) {
$objListItem->Selected = true;
}
$this->lstToCompany->AddItem($objListItem);
}
}
}
if ($this->lblToCompanyId) {
$this->lblToCompanyId->Text = $this->objShipment->ToCompany ? $this->objShipment->ToCompany->__toString() : null;
}
if ($this->lstToContact) {
$this->lstToContact->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstToContact->AddItem(QApplication::Translate('- Select One -'), null);
}
$objToContactArray = Contact::LoadAll();
if ($objToContactArray) {
foreach ($objToContactArray as $objToContact) {
$objListItem = new QListItem($objToContact->__toString(), $objToContact->ContactId);
if ($this->objShipment->ToContact && $this->objShipment->ToContact->ContactId == $objToContact->ContactId) {
$objListItem->Selected = true;
}
$this->lstToContact->AddItem($objListItem);
}
}
}
if ($this->lblToContactId) {
$this->lblToContactId->Text = $this->objShipment->ToContact ? $this->objShipment->ToContact->__toString() : null;
}
if ($this->lstToAddress) {
$this->lstToAddress->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstToAddress->AddItem(QApplication::Translate('- Select One -'), null);
}
$objToAddressArray = Address::LoadAll();
if ($objToAddressArray) {
foreach ($objToAddressArray as $objToAddress) {
$objListItem = new QListItem($objToAddress->__toString(), $objToAddress->AddressId);
if ($this->objShipment->ToAddress && $this->objShipment->ToAddress->AddressId == $objToAddress->AddressId) {
$objListItem->Selected = true;
}
$this->lstToAddress->AddItem($objListItem);
}
}
}
if ($this->lblToAddressId) {
$this->lblToAddressId->Text = $this->objShipment->ToAddress ? $this->objShipment->ToAddress->__toString() : null;
}
if ($this->lstCourier) {
$this->lstCourier->RemoveAllItems();
$this->lstCourier->AddItem(QApplication::Translate('- Select One -'), null);
$objCourierArray = Courier::LoadAll();
if ($objCourierArray) {
foreach ($objCourierArray as $objCourier) {
$objListItem = new QListItem($objCourier->__toString(), $objCourier->CourierId);
if ($this->objShipment->Courier && $this->objShipment->Courier->CourierId == $objCourier->CourierId) {
$objListItem->Selected = true;
}
$this->lstCourier->AddItem($objListItem);
}
}
}
if ($this->lblCourierId) {
$this->lblCourierId->Text = $this->objShipment->Courier ? $this->objShipment->Courier->__toString() : null;
}
if ($this->txtTrackingNumber) {
$this->txtTrackingNumber->Text = $this->objShipment->TrackingNumber;
}
if ($this->lblTrackingNumber) {
$this->lblTrackingNumber->Text = $this->objShipment->TrackingNumber;
}
if ($this->calShipDate) {
$this->calShipDate->DateTime = $this->objShipment->ShipDate;
}
if ($this->lblShipDate) {
$this->lblShipDate->Text = sprintf($this->objShipment->ShipDate) ? $this->objShipment->__toString($this->strShipDateDateTimeFormat) : null;
}
if ($this->chkShippedFlag) {
$this->chkShippedFlag->Checked = $this->objShipment->ShippedFlag;
}
if ($this->lblShippedFlag) {
$this->lblShippedFlag->Text = $this->objShipment->ShippedFlag ? QApplication::Translate('Yes') : QApplication::Translate('No');
}
if ($this->lstCreatedByObject) {
$this->lstCreatedByObject->RemoveAllItems();
$this->lstCreatedByObject->AddItem(QApplication::Translate('- Select One -'), null);
$objCreatedByObjectArray = UserAccount::LoadAll();
if ($objCreatedByObjectArray) {
foreach ($objCreatedByObjectArray as $objCreatedByObject) {
$objListItem = new QListItem($objCreatedByObject->__toString(), $objCreatedByObject->UserAccountId);
if ($this->objShipment->CreatedByObject && $this->objShipment->CreatedByObject->UserAccountId == $objCreatedByObject->UserAccountId) {
$objListItem->Selected = true;
}
$this->lstCreatedByObject->AddItem($objListItem);
}
}
}
if ($this->lblCreatedBy) {
$this->lblCreatedBy->Text = $this->objShipment->CreatedByObject ? $this->objShipment->CreatedByObject->__toString() : null;
}
if ($this->calCreationDate) {
$this->calCreationDate->DateTime = $this->objShipment->CreationDate;
}
if ($this->lblCreationDate) {
$this->lblCreationDate->Text = sprintf($this->objShipment->CreationDate) ? $this->objShipment->__toString($this->strCreationDateDateTimeFormat) : null;
}
if ($this->lstModifiedByObject) {
$this->lstModifiedByObject->RemoveAllItems();
$this->lstModifiedByObject->AddItem(QApplication::Translate('- Select One -'), null);
$objModifiedByObjectArray = UserAccount::LoadAll();
if ($objModifiedByObjectArray) {
foreach ($objModifiedByObjectArray as $objModifiedByObject) {
$objListItem = new QListItem($objModifiedByObject->__toString(), $objModifiedByObject->UserAccountId);
if ($this->objShipment->ModifiedByObject && $this->objShipment->ModifiedByObject->UserAccountId == $objModifiedByObject->UserAccountId) {
$objListItem->Selected = true;
}
$this->lstModifiedByObject->AddItem($objListItem);
}
}
}
if ($this->lblModifiedBy) {
$this->lblModifiedBy->Text = $this->objShipment->ModifiedByObject ? $this->objShipment->ModifiedByObject->__toString() : null;
}
if ($this->lblModifiedDate) {
if ($this->blnEditMode) {
$this->lblModifiedDate->Text = $this->objShipment->ModifiedDate;
}
}
if ($this->lstShipmentCustomFieldHelper) {
$this->lstShipmentCustomFieldHelper->RemoveAllItems();
$this->lstShipmentCustomFieldHelper->AddItem(QApplication::Translate('- Select One -'), null);
$objShipmentCustomFieldHelperArray = ShipmentCustomFieldHelper::LoadAll();
if ($objShipmentCustomFieldHelperArray) {
foreach ($objShipmentCustomFieldHelperArray as $objShipmentCustomFieldHelper) {
$objListItem = new QListItem($objShipmentCustomFieldHelper->__toString(), $objShipmentCustomFieldHelper->ShipmentId);
if ($objShipmentCustomFieldHelper->ShipmentId == $this->objShipment->ShipmentId) {
$objListItem->Selected = true;
}
$this->lstShipmentCustomFieldHelper->AddItem($objListItem);
}
}
// Because ShipmentCustomFieldHelper's ShipmentCustomFieldHelper is not null, if a value is already selected, it cannot be changed.
if ($this->lstShipmentCustomFieldHelper->SelectedValue) {
$this->lstShipmentCustomFieldHelper->Enabled = false;
} else {
$this->lstShipmentCustomFieldHelper->Enabled = true;
}
}
if ($this->lblShipmentCustomFieldHelper) {
$this->lblShipmentCustomFieldHelper->Text = $this->objShipment->ShipmentCustomFieldHelper ? $this->objShipment->ShipmentCustomFieldHelper->__toString() : null;
}
}
protected function btnNext_Click()
{
$blnError = false;
if ($this->intStep == 1) {
if ($this->chkHeaderRow->Checked) {
$this->blnHeaderRow = true;
} else {
$this->blnHeaderRow = false;
}
// Check errors
if ($this->lstFieldSeparator->SelectedValue == 'other' && !$this->txtFieldSeparator->Text) {
$this->flcFileCsv->Warning = "Please enter the field separator.";
$blnError = true;
} elseif ($this->lstTextDelimiter->SelectedValue == 'other' && !$this->txtTextDelimiter->Text) {
$this->flcFileCsv->Warning = "Please enter the text delimiter.";
$blnError = true;
} else {
// Step 1 complete
// File Not Uploaded
if (!file_exists($this->flcFileCsv->File) || !$this->flcFileCsv->Size) {
//throw new QCallerException('FileAssetType must be a valid QFileAssetType constant value');
$this->flcFileCsv->Warning = 'The file could not be uploaded. Please provide a valid file.';
$blnError = true;
// File Has Incorrect MIME Type (only if an acceptiblemimearray is setup)
} elseif (is_array($this->strAcceptibleMimeArray) && !array_key_exists($this->flcFileCsv->Type, $this->strAcceptibleMimeArray)) {
$this->flcFileCsv->Warning = "Extension must be 'csv' or 'txt'";
$blnError = true;
// File Successfully Uploaded
} else {
$this->flcFileCsv->Warning = "";
// Setup Filename, Base Filename and Extension
$strFilename = $this->flcFileCsv->FileName;
$intPosition = strrpos($strFilename, '.');
}
if (!$blnError) {
$this->FileCsvData = new File_CSV_DataSource();
// Setup the settings which have got on step 1
$this->FileCsvData->settings($this->GetCsvSettings());
$file = fopen($this->flcFileCsv->File, "r");
// Counter of files
$i = 1;
// Counter of rows
$j = 1;
$this->strFilePathArray = array();
// The uploaded file splits up in order to avoid out of memory
while ($row = fgets($file, 1000)) {
if ($j == 1) {
$strFilePath = sprintf('%s/%s_con_%s.csv', __TRACMOR_TMP__, $_SESSION['intUserAccountId'], $i);
$this->strFilePathArray[] = $strFilePath;
$file_part = fopen($strFilePath, "w+");
if ($i == 1) {
if ($this->blnHeaderRow) {
$strHeaderRow = $row;
} else {
// Add empty row which would be as header row
$strHeaderRow = "\n";
fwrite($file_part, $strHeaderRow);
}
} else {
fwrite($file_part, $strHeaderRow);
}
}
fwrite($file_part, $row);
$j++;
if ($j > 200) {
$j = 1;
$i++;
fclose($file_part);
}
}
$this->intTotalCount = ($i - 1) * 200 + $j - 1;
if (true && QApplication::$TracmorSettings->AssetLimit != null && QApplication::$TracmorSettings->AssetLimit < $this->intTotalCount + Asset::CountAll()) {
$blnError = true;
$this->btnNext->Warning = $i . " " . $j . "Sorry that is too many assets. Your asset limit is = " . QApplication::$TracmorSettings->AssetLimit . ", this import has " . $this->intTotalCount . " assets, and you already have " . Asset::CountAll() . " assets in the database.";
} else {
$this->arrMapFields = array();
$this->arrTracmorField = array();
// Load first file
$this->FileCsvData->load($this->strFilePathArray[0]);
$file_skipped = fopen($this->strFilePath = sprintf('%s/%s_contact_skipped.csv', __TRACMOR_TMP__, $_SESSION['intUserAccountId']), "w+");
// Get Headers
if ($this->blnHeaderRow) {
$this->arrCsvHeader = $this->FileCsvData->getHeaders();
// Create the header row in the skipped error file
$this->PutSkippedRecordInFile($file_skipped, $this->arrCsvHeader);
}
/*else {
// If it is not first file
$this->FileCsvData->appendRow($this->FileCsvData->getHeaders());
}*/
$strFirstRowArray = $this->FileCsvData->getRow(0);
for ($i = 0; $i < count($strFirstRowArray); $i++) {
$this->arrMapFields[$i] = array();
if ($this->blnHeaderRow && array_key_exists($i, $this->arrCsvHeader)) {
if ($this->arrCsvHeader[$i] == '') {
$this->arrCsvHeader[$i] = ' ';
}
$this->lstMapHeader_Create($this, $i, $this->arrCsvHeader[$i]);
$this->arrMapFields[$i]['header'] = $this->arrCsvHeader[$i];
} else {
$this->lstMapHeader_Create($this, $i);
}
// Create Default Value TextBox, ListBox and DateTimePicker
if ($this->blnHeaderRow && array_key_exists($i, $this->arrCsvHeader) && $this->arrCsvHeader[$i] || !$this->blnHeaderRow) {
$txtDefaultValue = new QTextBox($this);
$txtDefaultValue->Width = 200;
$this->txtMapDefaultValueArray[] = $txtDefaultValue;
$lstDefaultValue = new QListBox($this);
$lstDefaultValue->Width = 200;
$lstDefaultValue->Display = false;
$this->lstMapDefaultValueArray[] = $lstDefaultValue;
$dtpDate = new QDateTimePicker($this);
$dtpDate->DateTimePickerType = QDateTimePickerType::Date;
$dtpDate->DateTimePickerFormat = QDateTimePickerFormat::MonthDayYear;
$dtpDate->Display = false;
$this->dtpDateArray[] = $dtpDate;
if (array_key_exists($i, $this->lstMapHeaderArray)) {
$this->lstTramorField_Change(null, $this->lstMapHeaderArray[$i]->ControlId, null);
}
}
$this->arrMapFields[$i]['row1'] = $strFirstRowArray[$i];
}
$this->btnNext->Text = "Import Now";
fclose($file_skipped);
// Create Add Field button
$btnAddField = new QButton($this);
$btnAddField->Text = "Add Field";
$btnAddField->AddAction(new QClickEvent(), new QServerAction('btnAddField_Click'));
$btnAddField->AddAction(new QEnterKeyEvent(), new QServerAction('btnAddField_Click'));
$btnAddField->AddAction(new QEnterKeyEvent(), new QTerminateAction());
$this->lstMapHeaderArray[] = $btnAddField;
}
}
}
} elseif ($this->intStep == 2) {
// Step 2 complete
$blnError = false;
$blnCompany = false;
$blnLastName = false;
$blnContactId = false;
$this->intCompanyArray = array();
foreach (Company::LoadAll() as $objCompany) {
$this->intCompanyArray[strtolower($objCompany->ShortDescription)] = $objCompany->CompanyId;
}
for ($i = 0; $i < count($this->lstMapHeaderArray) - 1; $i++) {
$lstMapHeader = $this->lstMapHeaderArray[$i];
$strSelectedValue = strtolower($lstMapHeader->SelectedValue);
if ($strSelectedValue == "company") {
$blnCompany = true;
}
if ($strSelectedValue == "last name") {
$blnLastName = true;
} elseif ($strSelectedValue == "id") {
$blnContactId = true;
}
}
if ($this->lstMapDefaultValueArray) {
// Checking errors for required Default Value text fields
foreach ($this->lstMapDefaultValueArray as $lstDefault) {
if ($lstDefault->Display && $lstDefault->Required && !$lstDefault->SelectedValue) {
$lstDefault->Warning = "You must select one default value.";
$blnError = true;
break;
} else {
$blnError = false;
$lstDefault->Warning = "";
}
}
}
if ($this->txtMapDefaultValueArray) {
// Checking errors for required Default Value lst fields
foreach ($this->txtMapDefaultValueArray as $txtDefault) {
if ($txtDefault->Display && $txtDefault->Required && !$txtDefault->Text) {
$txtDefault->Warning = "You must enter default value.";
break;
} else {
$blnError = false;
$txtDefault->Warning = "";
}
}
}
// If all required fields have no errors
if (!$blnError && $blnCompany && $blnLastName && ($this->lstImportAction->SelectedValue != 2 || $blnContactId)) {
$this->btnNext->Warning = "";
// Setup keys for main required fields
foreach ($this->arrTracmorField as $key => $value) {
if ($value == 'company') {
$this->intCompanyKey = $key;
} elseif ($value == 'description') {
$this->intDescriptionKey = $key;
} elseif ($value == 'last name') {
$this->intLastNameKey = $key;
} elseif ($value == 'first name') {
$this->intFirstNameKey = $key;
} elseif ($value == 'title') {
$this->intTitleKey = $key;
} elseif ($value == 'email') {
$this->intEmailKey = $key;
} elseif ($value == 'office phone') {
$this->intOfficePhoneKey = $key;
} elseif ($value == 'home phone') {
$this->intHomePhoneKey = $key;
} elseif ($value == 'mobile phone') {
$this->intMobilePhoneKey = $key;
} elseif ($value == 'fax') {
$this->intFaxKey = $key;
} elseif ($this->lstImportAction->SelectedValue == 2 && $value == 'id') {
$this->intItemIdKey = $key;
}
}
$this->objNewContactArray = array();
$this->blnImportEnd = false;
$j = 1;
$this->btnNext->RemoveAllActions('onclick');
// Add new ajax actions for button
$this->btnNext->AddAction(new QClickEvent(), new QAjaxAction('btnNext_Click'));
$this->btnNext->AddAction(new QClickEvent(), new QToggleEnableAction($this->btnNext));
$this->btnNext->AddAction(new QEnterKeyEvent(), new QAjaxAction('btnNext_Click'));
$this->btnNext->AddAction(new QEnterKeyEvent(), new QToggleEnableAction($this->btnNext));
$this->btnNext->AddAction(new QEnterKeyEvent(), new QTerminateAction());
$this->btnNext->Warning = "Please wait...";
$this->intImportStep = 2;
$this->intCurrentFile = 0;
$this->strSelectedValueArray = array();
// New categories
$this->dtgContact = new QDataGrid($this);
$this->dtgContact->Name = 'contact_list';
$this->dtgContact->CellPadding = 5;
$this->dtgContact->CellSpacing = 0;
$this->dtgContact->CssClass = "datagrid";
$this->dtgContact->UseAjax = true;
$this->dtgContact->ShowColumnToggle = false;
$this->dtgContact->ShowExportCsv = false;
$this->dtgContact->ShowHeader = false;
$this->dtgContact->AddColumn(new QDataGridColumnExt('Contact', '<?= $_ITEM ?>', 'CssClass="dtg_column"', 'HtmlEntities="false"'));
// Updated categories
$this->dtgUpdatedItems = new QDataGrid($this);
$this->dtgUpdatedItems->Name = 'updated_contact_list';
$this->dtgUpdatedItems->CellPadding = 5;
$this->dtgUpdatedItems->CellSpacing = 0;
$this->dtgUpdatedItems->CssClass = "datagrid";
$this->dtgUpdatedItems->UseAjax = true;
$this->dtgUpdatedItems->ShowColumnToggle = false;
$this->dtgUpdatedItems->ShowExportCsv = false;
$this->dtgUpdatedItems->ShowHeader = false;
$this->dtgUpdatedItems->AddColumn(new QDataGridColumnExt('Contact Name', '<?= $_ITEM ?>', 'CssClass="dtg_column"', 'HtmlEntities="false"'));
// Create the label for successful import
$this->lblImportSuccess = new QLabel($this);
$this->lblImportSuccess->HtmlEntities = false;
$this->lblImportSuccess->Display = false;
// Undo Last Import button
$this->btnUndoLastImport = new QButton($this);
$this->btnUndoLastImport->Text = "Undo Last Import";
$this->btnUndoLastImport->Display = false;
$this->btnUndoLastImport->AddAction(new QClickEvent(), new QServerAction('btnCancel_Click'));
$this->btnUndoLastImport->AddAction(new QEnterKeyEvent(), new QServerAction('btnCancel_Click'));
$this->btnUndoLastImport->AddAction(new QEnterKeyEvent(), new QTerminateAction());
// Import More button
$this->btnImportMore = new QButton($this);
$this->btnImportMore->Text = "Import More";
$this->btnImportMore->Display = false;
$this->btnImportMore->AddAction(new QClickEvent(), new QServerAction('btnImportMore_Click'));
$this->btnImportMore->AddAction(new QEnterKeyEvent(), new QServerAction('btnImportMore_Click'));
$this->btnImportMore->AddAction(new QEnterKeyEvent(), new QTerminateAction());
// Return to Assets button
$this->btnReturnTo = new QButton($this);
$this->btnReturnTo->Text = "Return to Contacts";
$this->btnReturnTo->Display = false;
$this->btnReturnTo->AddAction(new QClickEvent(), new QServerAction('btnReturnTo_Click'));
$this->btnReturnTo->AddAction(new QEnterKeyEvent(), new QServerAction('btnReturnTo_Click'));
$this->btnReturnTo->AddAction(new QEnterKeyEvent(), new QTerminateAction());
} else {
$this->btnNext->Warning = "You must select all required fields.";
$blnError = true;
}
} else {
// Step 3 complete
set_time_limit(0);
$file_skipped = fopen($strFilePath = sprintf('%s/%s_contact_skipped.csv', __TRACMOR_TMP__, $_SESSION['intUserAccountId']), "a");
if (!$this->blnImportEnd) {
// Category
if ($this->intImportStep == 2) {
$strContactArray = array();
$this->objNewContactArray = array();
// Load all categories
foreach (Contact::LoadAll() as $objContact) {
$strContactArray[] = stripslashes(sprintf("%s %s", $objContact->LastName, $objContact->LastName));
}
// Add Default value
$txtDefaultValue = trim($this->txtMapDefaultValueArray[$this->intCompanyKey]->Text);
/*if ($txtDefaultValue && !$this->in_array_nocase($txtDefaultValue, $strContactArray)) {
$strContactArray[] = $txtDefaultValue;
$objNewContact = new Contact();
$objNewContact->ShortDescription = addslashes($txtDefaultValue);
$objNewContact->Save();
$this->objNewContactArray[$objNewContact->ContactId] = $objNewContact->ShortDescription;
}*/
$this->btnNext->Warning = "Contacts have been imported. Please wait...";
}
for ($j = $this->intCurrentFile; $j < count($this->strFilePathArray); $j++) {
$this->FileCsvData->load($this->strFilePathArray[$j]);
if (!$j) {
//$this->FileCsvData->appendRow($this->FileCsvData->getHeaders());
}
// Category Import
if ($this->intImportStep == 2) {
$arrItemCustomField = array();
foreach ($this->arrTracmorField as $key => $value) {
if (substr($value, 0, 8) == 'contact_') {
$intItemCustomFieldKeyArray[substr($value, 8)] = $key;
if (array_key_exists(substr($value, 8), $this->arrItemCustomField)) {
$arrItemCustomField[substr($value, 8)] = $this->arrItemCustomField[substr($value, 8)];
}
}
}
$strContactValuesArray = array();
$strUpdatedContactValuesArray = array();
$strItemCFVArray = array();
$strUpdatedItemCFVArray = array();
$strNewContactArray = array();
$this->arrOldItemArray = array();
$this->objUpdatedItemArray = array();
$objContactArray = array();
$objExpansionMap[Contact::ExpandCompany] = true;
$objExpansionMap[Contact::ExpandAddress] = true;
foreach (Contact::LoadArrayBySearchHelper(null, null, null, null, null, null, null, null, null, null, $objExpansionMap) as $objContact) {
$objContactArray[$objContact->ContactId] = $objContact;
}
for ($i = 0; $i < $this->FileCsvData->countRows(); $i++) {
$strRowArray = $this->FileCsvData->getRow($i);
$objContact = null;
if ($this->lstImportAction->SelectedValue == 2) {
$intItemId = intval(trim($strRowArray[$this->intItemIdKey]));
foreach ($objContactArray as $objItem) {
if ($objItem->ContactId == $intItemId) {
$objContact = $objItem;
break;
}
}
} else {
$intItemId = 0;
}
$strCompany = strtolower(trim($strRowArray[$this->intCompanyKey]));
if ($strCompany && array_key_exists($strCompany, $this->intCompanyArray)) {
$intCompanyId = $this->intCompanyArray[substr($strCompany, 0)];
} else {
$intCompanyId = null;
}
// Create action
if ($intCompanyId && trim($strRowArray[$this->intLastNameKey]) && (!$intItemId || !$objContact)) {
$strContactArray[] = trim($strRowArray[$this->intLastNameKey]);
$strDescription = "";
if (isset($this->intDescriptionKey)) {
if (trim($strRowArray[$this->intDescriptionKey])) {
$strDescription = trim($strRowArray[$this->intDescriptionKey]);
} else {
$strDescription = isset($this->txtMapDefaultValueArray[$this->intDescriptionKey]) ? trim($this->txtMapDefaultValueArray[$this->intDescriptionKey]->Text) : '';
}
}
$strLastName = "";
if (isset($this->intLastNameKey)) {
if (trim($strRowArray[$this->intLastNameKey])) {
$strLastName = trim($strRowArray[$this->intLastNameKey]);
} else {
$strLastName = isset($this->txtMapDefaultValueArray[$this->intLastNameKey]) ? trim($this->txtMapDefaultValueArray[$this->intLastNameKey]->Text) : '';
}
}
$strFirstName = "";
if (isset($this->intFirstNameKey)) {
if (trim($strRowArray[$this->intFirstNameKey])) {
$strFirstName = trim($strRowArray[$this->intFirstNameKey]);
} else {
$strFirstName = isset($this->txtMapDefaultValueArray[$this->intFirstNameKey]) ? trim($this->txtMapDefaultValueArray[$this->intFirstNameKey]->Text) : '';
}
}
$strEmail = "";
if (isset($this->intEmailKey)) {
if (trim($strRowArray[$this->intEmailKey])) {
$strEmail = trim($strRowArray[$this->intEmailKey]);
} else {
$strEmail = isset($this->txtMapDefaultValueArray[$this->intEmailKey]) ? trim($this->txtMapDefaultValueArray[$this->intEmailKey]->Text) : '';
}
}
$strOfficePhone = "";
if (isset($this->intOfficePhoneKey)) {
if (trim($strRowArray[$this->intOfficePhoneKey])) {
$strOfficePhone = trim($strRowArray[$this->intOfficePhoneKey]);
} else {
$strOfficePhone = isset($this->txtMapDefaultValueArray[$this->intOfficePhoneKey]) ? trim($this->txtMapDefaultValueArray[$this->intOfficePhoneKey]->Text) : '';
}
}
$strHomePhone = "";
if (isset($this->intHomePhoneKey)) {
if (trim($strRowArray[$this->intHomePhoneKey])) {
$strHomePhone = trim($strRowArray[$this->intHomePhoneKey]);
} else {
$strHomePhone = isset($this->txtMapDefaultValueArray[$this->intHomePhoneKey]) ? trim($this->txtMapDefaultValueArray[$this->intHomePhoneKey]->Text) : '';
}
}
$strMobilePhone = "";
if (isset($this->intMobilePhoneKey)) {
if (trim($strRowArray[$this->intMobilePhoneKey])) {
$strMobilePhone = trim($strRowArray[$this->intMobilePhoneKey]);
} else {
$strMobilePhone = isset($this->txtMapDefaultValueArray[$this->intMobilePhoneKey]) ? trim($this->txtMapDefaultValueArray[$this->intMobilePhoneKey]->Text) : '';
}
}
$strFax = "";
if (isset($this->intFaxKey)) {
if (trim($strRowArray[$this->intFaxKey])) {
$strFax = trim($strRowArray[$this->intFaxKey]);
} else {
$strFax = isset($this->txtMapDefaultValueArray[$this->intFaxKey]) ? trim($this->txtMapDefaultValueArray[$this->intFaxKey]->Text) : '';
}
}
$strTitle = "";
if (isset($this->intTitleKey)) {
if (trim($strRowArray[$this->intTitleKey])) {
$strTitle = trim($strRowArray[$this->intTitleKey]);
} else {
$strTitle = isset($this->txtMapDefaultValueArray[$this->intTitleKey]) ? trim($this->txtMapDefaultValueArray[$this->intTitleKey]->Text) : '';
}
}
$strCFVArray = array();
$blnCheckCFVError = false;
// Custom Field import
foreach ($arrItemCustomField as $objCustomField) {
if ($objCustomField->CustomFieldQtypeId != 2) {
$strShortDescription = trim($strRowArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]]) ? addslashes(trim($strRowArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]])) : addslashes($this->txtMapDefaultValueArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]]->Text);
$strCFVArray[$objCustomField->CustomFieldId] = $strShortDescription ? sprintf("'%s'", $strShortDescription) : "NULL";
} else {
$objDatabase = CustomField::GetDatabase();
$strShortDescription = addslashes(trim($strRowArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]]));
$blnInList = false;
foreach (CustomFieldValue::LoadArrayByCustomFieldId($objCustomField->CustomFieldId) as $objCustomFieldValue) {
if (strtolower($objCustomFieldValue->ShortDescription) == strtolower($strShortDescription)) {
$blnInList = true;
break;
}
}
// Add the CustomFieldValue
/*if (!$blnInList && !in_array($strShortDescription, $strAddedCFVArray)) {
$strQuery = sprintf("INSERT INTO custom_field_value (custom_field_id, short_description, created_by, creation_date) VALUES (%s, '%s', %s, NOW());", $objCustomField->CustomFieldId, $strShortDescription, $_SESSION['intUserAccountId']);
$objDatabase->NonQuery($strQuery);
$strAddedCFVArray[] = $strShortDescription;
}
else*/
if (!$blnInList && $this->lstMapDefaultValueArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]]->SelectedValue != null) {
$strShortDescription = $this->lstMapDefaultValueArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]]->SelectedName;
} elseif (!$blnInList) {
$blnCheckCFVError = true;
break;
}
if (!$blnCheckCFVError) {
if ($strShortDescription) {
$strCFVArray[$objCustomField->CustomFieldId] = sprintf("'%s'", $strShortDescription);
} else {
$strCFVArray[$objCustomField->CustomFieldId] = "NULL";
}
}
}
}
if (!$blnCheckCFVError) {
if (isset($strCFVArray) && count($strCFVArray)) {
$strItemCFVArray[] = implode(', ', $strCFVArray);
} else {
$strItemCFVArray[] = "";
}
$strContactValuesArray[] = sprintf("('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', NOW())", $intCompanyId, addslashes($strFirstName), addslashes($strLastName), addslashes($strTitle), addslashes($strEmail), addslashes($strDescription), addslashes($strOfficePhone), addslashes($strHomePhone), addslashes($strMobilePhone), addslashes($strFax), $_SESSION['intUserAccountId']);
$strNewContactArray[] = addslashes(sprintf("%s %s", isset($this->intFirstNameKey) ? trim($strRowArray[$this->intFirstNameKey]) : "", trim($strRowArray[$this->intLastNameKey])));
} else {
$this->intSkippedRecordCount++;
$this->PutSkippedRecordInFile($file_skipped, $strRowArray);
}
} elseif ($intCompanyId && trim($strRowArray[$this->intLastNameKey]) && $this->lstImportAction->SelectedValue == 2 && $objContact) {
if (!$blnError) {
$strUpdateFieldArray = array();
//$objContact = $objContactArray[strtolower(trim($strRowArray[$this->intCompanyKey]))];
$strUpdateFieldArray[] = sprintf("`company_id`='%s'", addslashes($intCompanyId));
$strDescription = "";
if (isset($this->intDescriptionKey)) {
if (trim($strRowArray[$this->intDescriptionKey])) {
$strDescription = trim($strRowArray[$this->intDescriptionKey]);
} else {
$strDescription = isset($this->txtMapDefaultValueArray[$this->intDescriptionKey]) ? trim($this->txtMapDefaultValueArray[$this->intDescriptionKey]->Text) : '';
}
$strUpdateFieldArray[] = sprintf("`description`='%s'", addslashes($strDescription));
}
$strLastName = "";
if (isset($this->intLastNameKey)) {
if (trim($strRowArray[$this->intLastNameKey])) {
$strLastName = trim($strRowArray[$this->intLastNameKey]);
} else {
$strLastName = isset($this->txtMapDefaultValueArray[$this->intLastNameKey]) ? trim($this->txtMapDefaultValueArray[$this->intLastNameKey]->Text) : '';
}
$strUpdateFieldArray[] = sprintf("`last_name`='%s'", addslashes($strLastName));
}
$strFirstName = "";
if (isset($this->intFirstNameKey)) {
if (trim($strRowArray[$this->intFirstNameKey])) {
$strFirstName = trim($strRowArray[$this->intFirstNameKey]);
} else {
$strFirstName = isset($this->txtMapDefaultValueArray[$this->intFirstNameKey]) ? trim($this->txtMapDefaultValueArray[$this->intFirstNameKey]->Text) : '';
}
$strUpdateFieldArray[] = sprintf("`first_name`='%s'", addslashes($strFirstName));
}
$strEmail = "";
if (isset($this->intEmailKey)) {
if (trim($strRowArray[$this->intEmailKey])) {
$strEmail = trim($strRowArray[$this->intEmailKey]);
} else {
$strEmail = isset($this->txtMapDefaultValueArray[$this->intEmailKey]) ? trim($this->txtMapDefaultValueArray[$this->intEmailKey]->Text) : '';
}
$strUpdateFieldArray[] = sprintf("`email`='%s'", addslashes($strEmail));
}
$strOfficePhone = "";
if (isset($this->intOfficePhoneKey)) {
if (trim($strRowArray[$this->intOfficePhoneKey])) {
$strOfficePhone = trim($strRowArray[$this->intOfficePhoneKey]);
} else {
$strOfficePhone = isset($this->txtMapDefaultValueArray[$this->intOfficePhoneKey]) ? trim($this->txtMapDefaultValueArray[$this->intOfficePhoneKey]->Text) : '';
}
$strUpdateFieldArray[] = sprintf("`phone_office`='%s'", addslashes($strOfficePhone));
}
$strHomePhone = "";
if (isset($this->intHomePhoneKey)) {
if (trim($strRowArray[$this->intHomePhoneKey])) {
$strHomePhone = trim($strRowArray[$this->intHomePhoneKey]);
} else {
$strHomePhone = isset($this->txtMapDefaultValueArray[$this->intHomePhoneKey]) ? trim($this->txtMapDefaultValueArray[$this->intHomePhoneKey]->Text) : '';
}
$strUpdateFieldArray[] = sprintf("`phone_home`='%s'", addslashes($strHomePhone));
}
$strMobilePhone = "";
if (isset($this->intMobilePhoneKey)) {
if (trim($strRowArray[$this->intMobilePhoneKey])) {
$strMobilePhone = trim($strRowArray[$this->intMobilePhoneKey]);
} else {
$strMobilePhone = isset($this->txtMapDefaultValueArray[$this->intMobilePhoneKey]) ? trim($this->txtMapDefaultValueArray[$this->intMobilePhoneKey]->Text) : '';
}
$strUpdateFieldArray[] = sprintf("`phone_mobile`='%s'", addslashes($strMobilePhone));
}
$strFax = "";
if (isset($this->intFaxKey)) {
if (trim($strRowArray[$this->intFaxKey])) {
$strFax = trim($strRowArray[$this->intFaxKey]);
} else {
$strFax = isset($this->txtMapDefaultValueArray[$this->intFaxKey]) ? trim($this->txtMapDefaultValueArray[$this->intFaxKey]->Text) : '';
}
$strUpdateFieldArray[] = sprintf("`fax`='%s'", addslashes($strFax));
}
$strTitle = "";
if (isset($this->intTitleKey)) {
if (trim($strRowArray[$this->intTitleKey])) {
$strTitle = trim($strRowArray[$this->intTitleKey]);
} else {
$strTitle = isset($this->txtMapDefaultValueArray[$this->intTitleKey]) ? trim($this->txtMapDefaultValueArray[$this->intTitleKey]->Text) : '';
}
$strUpdateFieldArray[] = sprintf("`title`='%s'", addslashes($strTitle));
}
$strUpdateFieldArray[] = sprintf("modified_by='%s'", $_SESSION['intUserAccountId']);
$this->arrOldItemArray[$objContact->ContactId] = $objContact;
$blnCheckCFVError = false;
foreach ($arrItemCustomField as $objCustomField) {
//$objItem = $objContactArray[strtolower($objUpdatedItem)];
if ($objCustomField->CustomFieldQtypeId != 2) {
$strShortDescription = trim($strRowArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]]) ? addslashes(trim($strRowArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]])) : addslashes($this->txtMapDefaultValueArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]]->Text);
$strCFVArray[$objCustomField->CustomFieldId] = $strShortDescription ? sprintf("'%s'", $strShortDescription) : "NULL";
} else {
$objDatabase = CustomField::GetDatabase();
$strShortDescription = addslashes(trim($strRowArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]]));
$strCFVArray[$objCustomField->CustomFieldId] = $strShortDescription ? sprintf("'%s'", $strShortDescription) : "NULL";
$blnInList = false;
foreach (CustomFieldValue::LoadArrayByCustomFieldId($objCustomField->CustomFieldId) as $objCustomFieldValue) {
if (strtolower($objCustomFieldValue->ShortDescription) == strtolower($strShortDescription)) {
//$intItemKeyntCustomFieldValueId = $objCustomFieldValue->CustomFieldValueId;
$blnInList = true;
break;
}
}
// Add the CustomFieldValue
/*if (!$blnInList && !in_array($strShortDescription, $strAddedCFVArray)) {
$strQuery = sprintf("INSERT INTO custom_field_value (custom_field_id, short_description, created_by, creation_date) VALUES (%s, '%s', %s, NOW());", $objCustomField->CustomFieldId, $strShortDescription, $_SESSION['intUserAccountId']);
$objDatabase->NonQuery($strQuery);
$strAddedCFVArray[] = $strShortDescription;
}
else*/
if (!$blnInList && $this->lstMapDefaultValueArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]]->SelectedValue != null) {
$strShortDescription = $this->lstMapDefaultValueArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]]->SelectedName;
} elseif (!$blnInList) {
$blnCheckCFVError = true;
break;
}
if (!$blnCheckCFVError) {
if ($strShortDescription) {
$strCFVArray[$objCustomField->CustomFieldId] = sprintf("'%s'", $strShortDescription);
} else {
$strCFVArray[$objCustomField->CustomFieldId] = "NULL";
}
}
}
}
if (!$blnCheckCFVError) {
if (isset($strCFVArray) && count($strCFVArray)) {
$strUpdatedItemCFVArray[$objContact->ContactId] = $strCFVArray;
} else {
$strUpdatedItemCFVArray[$objContact->ContactId] = "";
}
$strUpdatedContactValuesArray[] = sprintf("UPDATE `contact` SET %s WHERE `contact_id`='%s'", implode(", ", $strUpdateFieldArray), $objContact->ContactId);
$this->objUpdatedItemArray[$objContact->ContactId] = sprintf("%s %s", $objContact->FirstName, $objContact->LastName);
} else {
$this->intSkippedRecordCount++;
$this->PutSkippedRecordInFile($file_skipped, $strRowArray);
}
} else {
$this->intSkippedRecordCount++;
$this->PutSkippedRecordInFile($file_skipped, $strRowArray);
}
} else {
$this->intSkippedRecordCount++;
$this->PutSkippedRecordInFile($file_skipped, $strRowArray);
}
}
if (count($strContactValuesArray)) {
$objDatabase = Contact::GetDatabase();
$objDatabase->NonQuery(sprintf("INSERT INTO `contact` (`company_id`, `first_name`, `last_name`, `title`, `email`, `description`, `phone_office`, `phone_home`, `phone_mobile`, `fax`, `created_by`, `creation_date`) VALUES %s;", implode(", ", $strContactValuesArray)));
$intStartId = $objDatabase->InsertId();
$strItemIdArray = array();
for ($i = 0; $i < count($strNewContactArray); $i++) {
$this->objNewContactArray[$intStartId + $i] = $strNewContactArray[$i];
$objDatabase = CustomField::GetDatabase();
$strItemCFVArray[$i] = sprintf("('%s', %s)", $intStartId + $i, $strItemCFVArray[$i]);
$strItemIdArray[$i] = sprintf("(%s)", $intStartId + $i);
}
$strCFVNameArray = array();
foreach ($arrItemCustomField as $objCustomField) {
$strCFVNameArray[] = sprintf("`cfv_%s`", $objCustomField->CustomFieldId);
}
if (count($strItemCFVArray) > 0 && count($strCFVNameArray) > 0) {
$strQuery = sprintf("INSERT INTO `contact_custom_field_helper` (`contact_id`, %s) VALUES %s", implode(", ", $strCFVNameArray), implode(", ", $strItemCFVArray));
} else {
$strQuery = sprintf("INSERT INTO `contact_custom_field_helper` (`contact_id`) VALUES %s", implode(", ", $strItemIdArray));
}
$objDatabase->NonQuery($strQuery);
}
if (count($strUpdatedContactValuesArray)) {
$objDatabase = Category::GetDatabase();
foreach ($strUpdatedContactValuesArray as $query) {
$objDatabase->NonQuery($query);
}
foreach ($this->objUpdatedItemArray as $intItemKey => $objUpdatedItem) {
if (isset($strUpdatedItemCFVArray[$intItemKey]) && count($strUpdatedItemCFVArray[$intItemKey])) {
$strCFVArray = array();
foreach ($arrItemCustomField as $objCustomField) {
$strCFVArray[] = sprintf("`cfv_%s`=%s", $objCustomField->CustomFieldId, $strUpdatedItemCFVArray[$intItemKey][$objCustomField->CustomFieldId]);
}
if (isset($strCFVArray) && count($strCFVArray)) {
$strQuery = sprintf("UPDATE `contact_custom_field_helper` SET %s WHERE `contact_id`='%s'", implode(", ", $strCFVArray), $intItemKey);
$objDatabase->NonQuery($strQuery);
}
}
}
}
}
}
if ($this->intImportStep == 3) {
$this->blnImportEnd = true;
$this->btnNext->Warning = "";
$this->lblImportResults->Display = true;
if (count($this->objUpdatedItemArray)) {
$this->lblImportUpdatedItems->Display = true;
$this->dtgUpdatedItems->Paginator = new QPaginator($this->dtgUpdatedItems);
$this->dtgUpdatedItems->ItemsPerPage = 20;
}
if (count($this->objNewContactArray)) {
$this->lblImportContacts->Display = true;
$this->dtgContact->Paginator = new QPaginator($this->dtgContact);
$this->dtgContact->ItemsPerPage = 20;
}
$this->btnNext->Display = false;
$this->btnCancel->Display = false;
$this->btnUndoLastImport->Display = true;
$this->btnImportMore->Display = true;
$this->btnReturnTo->Display = true;
$this->lblImportSuccess->Display = true;
$this->lblImportSuccess->Text = sprintf("Success:<br/>" . "<b>%s</b> Records imported successfully<br/>" . "<b>%s</b> Records skipped due to error<br/>", count($this->objNewContactArray) + count($this->objUpdatedItemArray), $this->intSkippedRecordCount);
if ($this->intSkippedRecordCount) {
$this->lblImportSuccess->Text .= sprintf("<a href='./contact_import.php?intDownloadCsv=1'>Click here to download records that could not be imported</a>");
}
$this->lblImportSuccess->Text .= "<br/><br/>";
$this->intImportStep = -1;
}
// Enable Next button
$this->btnNext->Enabled = true;
if (!$this->blnImportEnd && !$this->intCurrentFile) {
$this->intImportStep++;
}
}
fclose($file_skipped);
}
if (!$blnError) {
if (($this->blnImportEnd || $this->intImportStep == 2) && $this->intImportStep != -1) {
$this->intStep++;
$this->DisplayStepForm($this->intStep);
}
if (!$this->blnImportEnd) {
QApplication::ExecuteJavaScript("document.getElementById('" . $this->btnNext->ControlId . "').click();");
}
if (!($this->intCurrentFile < count($this->strFilePathArray))) {
$this->intCurrentFile = 0;
$this->intImportStep++;
}
}
}
protected function lstToContact_Create()
{
$this->lstToContact = new QListBox($this);
$this->lstToContact->Name = QApplication::Translate('To Contact');
$this->lstToContact->Required = true;
if (!$this->blnEditMode) {
$this->lstToContact->AddItem('- Select One -', null);
} elseif ($this->blnEditMode && $this->lstToCompany->SelectedValue) {
$this->lstToContact->Enabled = true;
$this->lstToCompany_Select();
} else {
$this->lstToContact->AddItem('- Select One -', null);
$objToContactArray = Contact::LoadAll(QQ::Clause(QQ::OrderBy(QQN::Contact()->LastName), QQ::OrderBy(QQN::Contact()->FirstName)));
if ($objToContactArray) {
foreach ($objToContactArray as $objToContact) {
$objListItem = new QListItem($objToContact->__toString(), $objToContact->ContactId);
if ($this->objShipment->ToContactId && $this->objShipment->ToContactId == $objToContact->ContactId) {
$objListItem->Selected = true;
}
$this->lstToContact->AddItem($objListItem);
}
}
}
// $this->lstToContact->AddAction(new QChangeEvent(), new QAjaxAction('lstToContact_Select'));
$this->lstToContact->TabIndex = 5;
}
/**
* Refresh this MetaControl with Data from the local AssetTransactionCheckout object.
* @param boolean $blnReload reload AssetTransactionCheckout from the database
* @return void
*/
public function Refresh($blnReload = false)
{
if ($blnReload) {
$this->objAssetTransactionCheckout->Reload();
}
if ($this->lblAssetTransactionCheckoutId) {
if ($this->blnEditMode) {
$this->lblAssetTransactionCheckoutId->Text = $this->objAssetTransactionCheckout->AssetTransactionCheckoutId;
}
}
if ($this->lstAssetTransaction) {
$this->lstAssetTransaction->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstAssetTransaction->AddItem(QApplication::Translate('- Select One -'), null);
}
$objAssetTransactionArray = AssetTransaction::LoadAll();
if ($objAssetTransactionArray) {
foreach ($objAssetTransactionArray as $objAssetTransaction) {
$objListItem = new QListItem($objAssetTransaction->__toString(), $objAssetTransaction->AssetTransactionId);
if ($this->objAssetTransactionCheckout->AssetTransaction && $this->objAssetTransactionCheckout->AssetTransaction->AssetTransactionId == $objAssetTransaction->AssetTransactionId) {
$objListItem->Selected = true;
}
$this->lstAssetTransaction->AddItem($objListItem);
}
}
}
if ($this->lblAssetTransactionId) {
$this->lblAssetTransactionId->Text = $this->objAssetTransactionCheckout->AssetTransaction ? $this->objAssetTransactionCheckout->AssetTransaction->__toString() : null;
}
if ($this->lstToContact) {
$this->lstToContact->RemoveAllItems();
$this->lstToContact->AddItem(QApplication::Translate('- Select One -'), null);
$objToContactArray = Contact::LoadAll();
if ($objToContactArray) {
foreach ($objToContactArray as $objToContact) {
$objListItem = new QListItem($objToContact->__toString(), $objToContact->ContactId);
if ($this->objAssetTransactionCheckout->ToContact && $this->objAssetTransactionCheckout->ToContact->ContactId == $objToContact->ContactId) {
$objListItem->Selected = true;
}
$this->lstToContact->AddItem($objListItem);
}
}
}
if ($this->lblToContactId) {
$this->lblToContactId->Text = $this->objAssetTransactionCheckout->ToContact ? $this->objAssetTransactionCheckout->ToContact->__toString() : null;
}
if ($this->lstToUser) {
$this->lstToUser->RemoveAllItems();
$this->lstToUser->AddItem(QApplication::Translate('- Select One -'), null);
$objToUserArray = UserAccount::LoadAll();
if ($objToUserArray) {
foreach ($objToUserArray as $objToUser) {
$objListItem = new QListItem($objToUser->__toString(), $objToUser->UserAccountId);
if ($this->objAssetTransactionCheckout->ToUser && $this->objAssetTransactionCheckout->ToUser->UserAccountId == $objToUser->UserAccountId) {
$objListItem->Selected = true;
}
$this->lstToUser->AddItem($objListItem);
}
}
}
if ($this->lblToUserId) {
$this->lblToUserId->Text = $this->objAssetTransactionCheckout->ToUser ? $this->objAssetTransactionCheckout->ToUser->__toString() : null;
}
if ($this->calDueDate) {
$this->calDueDate->DateTime = $this->objAssetTransactionCheckout->DueDate;
}
if ($this->lblDueDate) {
$this->lblDueDate->Text = sprintf($this->objAssetTransactionCheckout->DueDate) ? $this->objAssetTransactionCheckout->__toString($this->strDueDateDateTimeFormat) : null;
}
if ($this->lstCreatedByObject) {
$this->lstCreatedByObject->RemoveAllItems();
$this->lstCreatedByObject->AddItem(QApplication::Translate('- Select One -'), null);
$objCreatedByObjectArray = UserAccount::LoadAll();
if ($objCreatedByObjectArray) {
foreach ($objCreatedByObjectArray as $objCreatedByObject) {
$objListItem = new QListItem($objCreatedByObject->__toString(), $objCreatedByObject->UserAccountId);
if ($this->objAssetTransactionCheckout->CreatedByObject && $this->objAssetTransactionCheckout->CreatedByObject->UserAccountId == $objCreatedByObject->UserAccountId) {
$objListItem->Selected = true;
}
$this->lstCreatedByObject->AddItem($objListItem);
}
}
}
if ($this->lblCreatedBy) {
$this->lblCreatedBy->Text = $this->objAssetTransactionCheckout->CreatedByObject ? $this->objAssetTransactionCheckout->CreatedByObject->__toString() : null;
}
if ($this->calCreationDate) {
$this->calCreationDate->DateTime = $this->objAssetTransactionCheckout->CreationDate;
}
if ($this->lblCreationDate) {
$this->lblCreationDate->Text = sprintf($this->objAssetTransactionCheckout->CreationDate) ? $this->objAssetTransactionCheckout->__toString($this->strCreationDateDateTimeFormat) : null;
}
if ($this->lstModifiedByObject) {
$this->lstModifiedByObject->RemoveAllItems();
$this->lstModifiedByObject->AddItem(QApplication::Translate('- Select One -'), null);
$objModifiedByObjectArray = UserAccount::LoadAll();
if ($objModifiedByObjectArray) {
foreach ($objModifiedByObjectArray as $objModifiedByObject) {
$objListItem = new QListItem($objModifiedByObject->__toString(), $objModifiedByObject->UserAccountId);
if ($this->objAssetTransactionCheckout->ModifiedByObject && $this->objAssetTransactionCheckout->ModifiedByObject->UserAccountId == $objModifiedByObject->UserAccountId) {
$objListItem->Selected = true;
}
$this->lstModifiedByObject->AddItem($objListItem);
}
}
}
if ($this->lblModifiedBy) {
$this->lblModifiedBy->Text = $this->objAssetTransactionCheckout->ModifiedByObject ? $this->objAssetTransactionCheckout->ModifiedByObject->__toString() : null;
}
if ($this->lblModifiedDate) {
if ($this->blnEditMode) {
$this->lblModifiedDate->Text = $this->objAssetTransactionCheckout->ModifiedDate;
}
}
}
public function dtgContact_Bind()
{
// Get Total Count b/c of Pagination
$this->dtgContact->TotalItemCount = Contact::CountAll();
$objClauses = array();
if ($objClause = $this->dtgContact->OrderByClause) {
array_push($objClauses, $objClause);
}
if ($objClause = $this->dtgContact->LimitClause) {
array_push($objClauses, $objClause);
}
$this->dtgContact->DataSource = Contact::LoadAll($objClauses);
}
/**
* Refresh this MetaControl with Data from the local ContactCustomFieldHelper object.
* @param boolean $blnReload reload ContactCustomFieldHelper from the database
* @return void
*/
public function Refresh($blnReload = false)
{
if ($blnReload) {
$this->objContactCustomFieldHelper->Reload();
}
if ($this->lstContact) {
$this->lstContact->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstContact->AddItem(QApplication::Translate('- Select One -'), null);
}
$objContactArray = Contact::LoadAll();
if ($objContactArray) {
foreach ($objContactArray as $objContact) {
$objListItem = new QListItem($objContact->__toString(), $objContact->ContactId);
if ($this->objContactCustomFieldHelper->Contact && $this->objContactCustomFieldHelper->Contact->ContactId == $objContact->ContactId) {
$objListItem->Selected = true;
}
$this->lstContact->AddItem($objListItem);
}
}
}
if ($this->lblContactId) {
$this->lblContactId->Text = $this->objContactCustomFieldHelper->Contact ? $this->objContactCustomFieldHelper->Contact->__toString() : null;
}
}
protected function dtgContact_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->dtgContact->TotalItemCount = Contact::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->dtgContact->OrderByClause) {
array_push($objClauses, $objClause);
}
// Add the LimitClause information, as well
if ($objClause = $this->dtgContact->LimitClause) {
array_push($objClauses, $objClause);
}
// Set the DataSource to be the array of all Contact objects, given the clauses above
$this->dtgContact->DataSource = Contact::LoadAll($objClauses);
}
