PHP Manufacturer::LoadAll方法代码示例

 protected function lstManufacturer_Create()
 {
     $this->lstManufacturer = new QListBox($this);
     $this->lstManufacturer->Name = 'Manufacturer';
     $this->lstManufacturer->AddItem('- ALL -', null);
     foreach (Manufacturer::LoadAll(QQ::Clause(QQ::OrderBy(QQN::Manufacturer()->ShortDescription))) as $objManufacturer) {
         $this->lstManufacturer->AddItem($objManufacturer->ShortDescription, $objManufacturer->ManufacturerId);
     }
 }

 protected function lstManufacturer_Create()
 {
     $this->lstManufacturer = new QListBox($this);
     $this->lstManufacturer->Name = QApplication::Translate('Manufacturer');
     $this->lstManufacturer->AddItem(QApplication::Translate('- Select One -'), null);
     $objManufacturerArray = Manufacturer::LoadAll(QQ::Clause(QQ::OrderBy(QQN::Manufacturer()->ShortDescription)));
     if ($objManufacturerArray) {
         foreach ($objManufacturerArray as $objManufacturer) {
             $objListItem = new QListItem($objManufacturer->__toString(), $objManufacturer->ManufacturerId);
             if ($this->objAssetModel->Manufacturer && $this->objAssetModel->Manufacturer->ManufacturerId == $objManufacturer->ManufacturerId) {
                 $objListItem->Selected = true;
             }
             $this->lstManufacturer->AddItem($objListItem);
         }
     }
     $this->lstManufacturer->Enabled = false;
 }

//.........这里部分代码省略.........
                 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 && $blnAssetCode && $blnAssetModelCode && $blnAssetModelShortDescription && $blnLocation && $blnCategory && $blnManufacturer) {
             $this->btnNext->Warning = "";
             // Setup keys for main required fields
             foreach ($this->arrTracmorField as $key => $value) {
                 if ($value == 'location') {
                     $this->intLocationKey = $key;
                 } elseif ($value == 'category') {
                     $this->intCategoryKey = $key;
                 } elseif ($value == 'manufacturer') {
                     $this->intManufacturerKey = $key;
                 } elseif ($value == 'created by') {
                     $this->intCreatedByKey = $key;
                 } elseif ($value == 'created date') {
                     $this->intCreatedDateKey = $key;
                 } elseif ($value == 'modified by') {
                     $this->intModifiedByKey = $key;
                 } elseif ($value == 'modified date') {
                     $this->intModifiedDateKey = $key;
                 }
             }
             $strLocationArray = array();
             $strNewLocationArray = array();
             // Load all locations
             foreach (Location::LoadAll() as $objLocation) {
                 $strLocationArray[] = stripslashes($objLocation->ShortDescription);
             }
             $txtDefaultValue = trim($this->txtMapDefaultValueArray[$this->intLocationKey]->Text);
             // Add default value in database if it is not exist
             if ($txtDefaultValue && !$this->in_array_nocase($txtDefaultValue, $strLocationArray)) {
                 $strLocationArray[] = $txtDefaultValue;
                 $objNewLocation = new Location();
                 $objNewLocation->ShortDescription = addslashes($txtDefaultValue);
                 $objNewLocation->EnabledFlag = 1;
                 $objNewLocation->Save();
                 $this->objNewLocationArray[$objNewLocation->LocationId] = $objNewLocation->ShortDescription;
             }
             $this->objNewLocationArray = array();
             $this->objNewCategoryArray = array();
             $this->objNewManufacturerArray = array();
             $this->objNewAssetModelArray = array();
             $this->strModelValuesArray = array();
             $this->blnImportEnd = false;
             $j = 1;
             $strLocationValuesArray = array();
             // Add all unique locations in database
             foreach ($this->strFilePathArray as $strFilePath) {
                 $this->FileCsvData->load($strFilePath);
                 if ($j != 1) {
                     //$this->FileCsvData->appendRow($this->FileCsvData->getHeaders());
                 }
                 // Location Import
                 for ($i = 0; $i < $this->FileCsvData->countRows(); $i++) {
                     $strRowArray = $this->FileCsvData->getRow($i);
                     if (trim($strRowArray[$this->intLocationKey]) && !$this->in_array_nocase(trim($strRowArray[$this->intLocationKey]), $strLocationArray)) {
                         $strLocationArray[] = trim($strRowArray[$this->intLocationKey]);
                         /*$objNewLocation = new Location();

 protected function lstManufacturer_Create()
 {
     $this->lstManufacturer = new QListBox($this);
     $this->lstManufacturer->Name = QApplication::Translate('Manufacturer');
     $this->lstManufacturer->AddItem(QApplication::Translate('- Select One -'), null);
     $objManufacturerArray = Manufacturer::LoadAll();
     if ($objManufacturerArray) {
         foreach ($objManufacturerArray as $objManufacturer) {
             $objListItem = new QListItem($objManufacturer->__toString(), $objManufacturer->ManufacturerId);
             if ($this->objAssetModel->Manufacturer && $this->objAssetModel->Manufacturer->ManufacturerId == $objManufacturer->ManufacturerId) {
                 $objListItem->Selected = true;
             }
             $this->lstManufacturer->AddItem($objListItem);
         }
     }
 }

 protected function lstManufacturer_Create()
 {
     $this->lstManufacturer = new QListBox($this);
     $this->lstManufacturer->Name = 'Manufacturer';
     $this->lstManufacturer->AddItem(new QListItem('- ALL -', null));
     // foreach (Manufacturer::LoadAll('short_description') as $objManufacturer) {
     foreach (Manufacturer::LoadAll(QQ::Clause(QQ::OrderBy(QQN::Manufacturer()->ShortDescription))) as $objManufacturer) {
         $this->lstManufacturer->AddItem(new QListItem($objManufacturer->ShortDescription, $objManufacturer->ManufacturerId));
     }
     $this->lstManufacturer->AddAction(new QEnterKeyEvent(), new QServerAction('btnSearch_Click'));
     $this->lstManufacturer->AddAction(new QEnterKeyEvent(), new QTerminateAction());
 }

 public function dtgManufacturer_Bind()
 {
     // Get Total Count b/c of Pagination
     $this->dtgManufacturer->TotalItemCount = Manufacturer::CountAll();
     $objClauses = array();
     if ($objClause = $this->dtgManufacturer->OrderByClause) {
         array_push($objClauses, $objClause);
     }
     if ($objClause = $this->dtgManufacturer->LimitClause) {
         array_push($objClauses, $objClause);
     }
     $this->dtgManufacturer->DataSource = Manufacturer::LoadAll($objClauses);
 }

 /**
  * Refresh this MetaControl with Data from the local InventoryModel object.
  * @param boolean $blnReload reload InventoryModel from the database
  * @return void
  */
 public function Refresh($blnReload = false)
 {
     if ($blnReload) {
         $this->objInventoryModel->Reload();
     }
     if ($this->lblInventoryModelId) {
         if ($this->blnEditMode) {
             $this->lblInventoryModelId->Text = $this->objInventoryModel->InventoryModelId;
         }
     }
     if ($this->lstCategory) {
         $this->lstCategory->RemoveAllItems();
         $this->lstCategory->AddItem(QApplication::Translate('- Select One -'), null);
         $objCategoryArray = Category::LoadAll();
         if ($objCategoryArray) {
             foreach ($objCategoryArray as $objCategory) {
                 $objListItem = new QListItem($objCategory->__toString(), $objCategory->CategoryId);
                 if ($this->objInventoryModel->Category && $this->objInventoryModel->Category->CategoryId == $objCategory->CategoryId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstCategory->AddItem($objListItem);
             }
         }
     }
     if ($this->lblCategoryId) {
         $this->lblCategoryId->Text = $this->objInventoryModel->Category ? $this->objInventoryModel->Category->__toString() : null;
     }
     if ($this->lstManufacturer) {
         $this->lstManufacturer->RemoveAllItems();
         $this->lstManufacturer->AddItem(QApplication::Translate('- Select One -'), null);
         $objManufacturerArray = Manufacturer::LoadAll();
         if ($objManufacturerArray) {
             foreach ($objManufacturerArray as $objManufacturer) {
                 $objListItem = new QListItem($objManufacturer->__toString(), $objManufacturer->ManufacturerId);
                 if ($this->objInventoryModel->Manufacturer && $this->objInventoryModel->Manufacturer->ManufacturerId == $objManufacturer->ManufacturerId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstManufacturer->AddItem($objListItem);
             }
         }
     }
     if ($this->lblManufacturerId) {
         $this->lblManufacturerId->Text = $this->objInventoryModel->Manufacturer ? $this->objInventoryModel->Manufacturer->__toString() : null;
     }
     if ($this->txtInventoryModelCode) {
         $this->txtInventoryModelCode->Text = $this->objInventoryModel->InventoryModelCode;
     }
     if ($this->lblInventoryModelCode) {
         $this->lblInventoryModelCode->Text = $this->objInventoryModel->InventoryModelCode;
     }
     if ($this->txtShortDescription) {
         $this->txtShortDescription->Text = $this->objInventoryModel->ShortDescription;
     }
     if ($this->lblShortDescription) {
         $this->lblShortDescription->Text = $this->objInventoryModel->ShortDescription;
     }
     if ($this->txtLongDescription) {
         $this->txtLongDescription->Text = $this->objInventoryModel->LongDescription;
     }
     if ($this->lblLongDescription) {
         $this->lblLongDescription->Text = $this->objInventoryModel->LongDescription;
     }
     if ($this->txtImagePath) {
         $this->txtImagePath->Text = $this->objInventoryModel->ImagePath;
     }
     if ($this->lblImagePath) {
         $this->lblImagePath->Text = $this->objInventoryModel->ImagePath;
     }
     if ($this->txtPrice) {
         $this->txtPrice->Text = $this->objInventoryModel->Price;
     }
     if ($this->lblPrice) {
         $this->lblPrice->Text = $this->objInventoryModel->Price;
     }
     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->objInventoryModel->CreatedByObject && $this->objInventoryModel->CreatedByObject->UserAccountId == $objCreatedByObject->UserAccountId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstCreatedByObject->AddItem($objListItem);
             }
         }
     }
     if ($this->lblCreatedBy) {
         $this->lblCreatedBy->Text = $this->objInventoryModel->CreatedByObject ? $this->objInventoryModel->CreatedByObject->__toString() : null;
     }
     if ($this->calCreationDate) {
         $this->calCreationDate->DateTime = $this->objInventoryModel->CreationDate;
     }
     if ($this->lblCreationDate) {
//.........这里部分代码省略.........

 protected function lstManufacturer_Create()
 {
     $this->lstManufacturer = new QListBox($this);
     $this->lstManufacturer->Name = QApplication::Translate('Manufacturer');
     $this->lstManufacturer->Required = true;
     if (!$this->blnEditMode) {
         $this->lstManufacturer->AddItem('- Select One -', null);
     }
     // $objManufacturerArray = Manufacturer::LoadAll('short_description ASC');
     $objManufacturerArray = Manufacturer::LoadAll(QQ::Clause(QQ::OrderBy(QQN::Manufacturer()->ShortDescription)));
     if ($objManufacturerArray) {
         foreach ($objManufacturerArray as $objManufacturer) {
             $objListItem = new QListItem($objManufacturer->__toString(), $objManufacturer->ManufacturerId);
             if ($this->objAssetModel->Manufacturer && $this->objAssetModel->Manufacturer->ManufacturerId == $objManufacturer->ManufacturerId) {
                 $objListItem->Selected = true;
             }
             $this->lstManufacturer->AddItem($objListItem);
         }
     }
     $this->lstManufacturer->TabIndex = 3;
     $this->intNextTabIndex++;
 }

//.........这里部分代码省略.........
             $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 Manufacturers";
             $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_manufacturer_skipped.csv', __TRACMOR_TMP__, $_SESSION['intUserAccountId']), "a");
         if (!$this->blnImportEnd) {
             if ($this->intImportStep == 2) {
                 $strManufacturerArray = array();
                 $this->objNewManufacturerArray = array();
                 // Load all manufacturers
                 foreach (Manufacturer::LoadAll() as $objManufacturer) {
                     $strManufacturerArray[] = stripslashes($objManufacturer->ShortDescription);
                 }
                 $txtDefaultValue = trim($this->txtMapDefaultValueArray[$this->intManufacturerKey]->Text);
                 // Add Default Value
                 if ($txtDefaultValue && !$this->in_array_nocase($txtDefaultValue, $strManufacturerArray)) {
                     $strManufacturerArray[] = $txtDefaultValue;
                     $objNewManufacturer = new Manufacturer();
                     $objNewManufacturer->ShortDescription = addslashes($txtDefaultValue);
                     $objNewManufacturer->Save();
                     $this->objNewManufacturerArray[$objNewManufacturer->ManufacturerId] = $objNewManufacturer->ShortDescription;
                 }
                 $this->btnNext->Warning = "Manufacturers 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());
                 }
                 // Manufacturer Import
                 if ($this->intImportStep == 2) {
                     $arrItemCustomField = array();
                     foreach ($this->arrTracmorField as $key => $value) {
                         if (substr($value, 0, 13) == 'manufacturer_') {
                             $intItemCustomFieldKeyArray[substr($value, 13)] = $key;
                             if (array_key_exists(substr($value, 13), $this->arrItemCustomField)) {
                                 $arrItemCustomField[substr($value, 13)] = $this->arrItemCustomField[substr($value, 13)];
                             }
                         }
                     }
                     $strManufacturerValuesArray = array();
                     $strUpdatedManufacturerValuesArray = array();
                     $strItemCFVArray = array();

 protected function dtgManufacturer_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->dtgManufacturer->TotalItemCount = Manufacturer::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->dtgManufacturer->OrderByClause) {
         array_push($objClauses, $objClause);
     }
     // Add the LimitClause information, as well
     if ($objClause = $this->dtgManufacturer->LimitClause) {
         array_push($objClauses, $objClause);
     }
     // Set the DataSource to be the array of all Manufacturer objects, given the clauses above
     $this->dtgManufacturer->DataSource = Manufacturer::LoadAll($objClauses);
 }

 protected function lstManufacturer_Create()
 {
     $this->lstManufacturer = new QListBox($this);
     $this->lstManufacturer->AddItem('- ALL -', null);
     $arrManufacturer = Manufacturer::LoadAll();
     foreach ($arrManufacturer as $objManufacturer) {
         $this->lstManufacturer->AddItem($objManufacturer->ShortDescription, $objManufacturer->ManufacturerId);
     }
 }

//.........这里部分代码省略.........
             $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->btnReturnToAssets = new QButton($this);
             $this->btnReturnToAssets->Text = "Return to Models";
             $this->btnReturnToAssets->Display = false;
             $this->btnReturnToAssets->AddAction(new QClickEvent(), new QServerAction('btnReturnToAssets_Click'));
             $this->btnReturnToAssets->AddAction(new QEnterKeyEvent(), new QServerAction('btnReturnToAssets_Click'));
             $this->btnReturnToAssets->AddAction(new QEnterKeyEvent(), new QTerminateAction());
         } else {
             $this->btnNext->Warning = "You must select all required fields (Model Number, Model Short Description, Category and Manufacturer).";
             $blnError = true;
         }
     } else {
         // Step 3 complete
         set_time_limit(0);
         $file_skipped = fopen($strFilePath = sprintf('%s/%s_skipped.csv', __TRACMOR_TMP__, $_SESSION['intUserAccountId']), "a");
         if (!$this->blnImportEnd) {
             // Asset Model
             if ($this->intImportStep == 2) {
                 $intCategoryArray = array();
                 // Load all categories with key=category_id
                 foreach (Category::LoadAllWithFlags(true, false) as $objCategory) {
                     $intCategoryArray[$objCategory->CategoryId] = strtolower($objCategory->ShortDescription);
                 }
                 $intManufacturerArray = array();
                 // Load all manufacturers with key=manufacturer_id
                 foreach (Manufacturer::LoadAll() as $objManufacturer) {
                     $intManufacturerArray[$objManufacturer->ManufacturerId] = strtolower($objManufacturer->ShortDescription);
                 }
                 if (QApplication::$TracmorSettings->DepreciationFlag == '1') {
                     $intDepreciationClassArray = array();
                     foreach (DepreciationClass::LoadAll() as $objDepreciationClass) {
                         $intDepreciationClassArray[$objDepreciationClass->DepreciationClassId] = strtolower($objDepreciationClass->ShortDescription);
                     }
                 }
                 $intModelCustomFieldKeyArray = array();
                 $arrModelCustomField = array();
                 // Setup keys
                 foreach ($this->arrTracmorField as $key => $value) {
                     if ($value == 'short description') {
                         $intModelShortDescriptionKey = $key;
                     } elseif ($value == 'long description') {
                         $intModelLongDescriptionKey = $key;
                     } elseif ($value == 'model number') {
                         $intModelCodeKey = $key;
                     } elseif (substr($value, 0, 6) == 'model_') {
                         $intModelCustomFieldKeyArray[substr($value, 6)] = $key;
                         if (array_key_exists(substr($value, 6), $this->arrModelCustomField)) {
                             $arrModelCustomField[substr($value, 6)] = $this->arrModelCustomField[substr($value, 6)];
                         }
                     }
                 }
                 $strAssetModelArray = array();
                 $strItemCFVArray = array();

 /**
  * Refresh this MetaControl with Data from the local ManufacturerCustomFieldHelper object.
  * @param boolean $blnReload reload ManufacturerCustomFieldHelper from the database
  * @return void
  */
 public function Refresh($blnReload = false)
 {
     if ($blnReload) {
         $this->objManufacturerCustomFieldHelper->Reload();
     }
     if ($this->lstManufacturer) {
         $this->lstManufacturer->RemoveAllItems();
         if (!$this->blnEditMode) {
             $this->lstManufacturer->AddItem(QApplication::Translate('- Select One -'), null);
         }
         $objManufacturerArray = Manufacturer::LoadAll();
         if ($objManufacturerArray) {
             foreach ($objManufacturerArray as $objManufacturer) {
                 $objListItem = new QListItem($objManufacturer->__toString(), $objManufacturer->ManufacturerId);
                 if ($this->objManufacturerCustomFieldHelper->Manufacturer && $this->objManufacturerCustomFieldHelper->Manufacturer->ManufacturerId == $objManufacturer->ManufacturerId) {
                     $objListItem->Selected = true;
                 }
                 $this->lstManufacturer->AddItem($objListItem);
             }
         }
     }
     if ($this->lblManufacturerId) {
         $this->lblManufacturerId->Text = $this->objManufacturerCustomFieldHelper->Manufacturer ? $this->objManufacturerCustomFieldHelper->Manufacturer->__toString() : null;
     }
 }