當前位置: 首頁>>代碼示例>>PHP>>正文


PHP Vendor::getBaseDataColumn方法代碼示例

本文整理匯總了PHP中Vendor::getBaseDataColumn方法的典型用法代碼示例。如果您正苦於以下問題:PHP Vendor::getBaseDataColumn方法的具體用法?PHP Vendor::getBaseDataColumn怎麽用?PHP Vendor::getBaseDataColumn使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在Vendor的用法示例。


在下文中一共展示了Vendor::getBaseDataColumn方法的2個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。

示例1: importData

 public function importData(Vendor $vendor)
 {
     $this->currentVendor = $vendor;
     $baseActiveSheet = $vendor->getActiveSheet();
     while (!$vendor->endReached()) {
         $vendorItemData = $vendor->getNextLine();
         if (isset($vendorItemData['item']) && $vendorItemData['item'] != "") {
             $itemIds = $this->baseData->getItemIds($vendorItemData['item'], $vendor->getBaseDataColumn());
             if (!empty($itemIds)) {
                 foreach ($itemIds as $itemId) {
                     $itemData = $this->findItem($itemId);
                     if (!isset($itemData['row'])) {
                         $itemData['row'] = $this->counter;
                         $this->counter++;
                     } else {
                         $vendorItemData['price'] = $vendorItemData['price'] > $itemData['price'] ? $vendorItemData['price'] : $itemData['price'];
                         $vendorItemData['qty'] += $itemData['qty'];
                     }
                     $this->excel->setActiveSheetIndex($baseActiveSheet)->setCellValue('A' . $itemData['row'], $itemId);
                     $vendorConfig = $vendor->getConfig();
                     $this->excel->setActiveSheetIndex($baseActiveSheet)->setCellValue($vendorConfig['master-file-item-column'] . $itemData['row'], $vendorItemData['item']);
                     $this->excel->setActiveSheetIndex($baseActiveSheet)->setCellValue($vendorConfig['master-file-price-column'] . $itemData['row'], $vendorItemData['price']);
                     $this->excel->setActiveSheetIndex($baseActiveSheet)->setCellValue($vendorConfig['master-file-qty-column'] . $itemData['row'], $vendorItemData['qty']);
                 }
             }
         }
     }
 }
開發者ID:diedsmiling,項目名稱:busenika,代碼行數:28,代碼來源:ExcelMasterData.php

示例2: importData

 public function importData(Vendor $vendor)
 {
     $vendorConfig = $vendor->getConfig();
     while (!$vendor->endReached()) {
         $vendorItemData = $vendor->getNextLine();
         if (isset($vendorItemData['item']) && $vendorItemData['item'] != "") {
             $itemIds = $this->baseData->getItemIds($vendorItemData['item'], $vendor->getBaseDataColumn());
             if (!empty($itemIds)) {
                 foreach ($itemIds as $itemId) {
                     $query = "INSERT INTO " . $this->config['master-table'] . " (" . "item_id," . $vendorConfig['master-file-item-column-name'] . "," . $vendorConfig['master-file-price-column-name'] . "," . $vendorConfig['master-file-qty-column-name'] . ") VALUES (" . "'" . $itemId . "'," . "'" . $vendorItemData['item'] . "'," . $vendorItemData['price'] . "," . $vendorItemData['qty'] . ") ON DUPLICATE KEY UPDATE " . $vendorConfig['master-file-item-column-name'] . "='" . $vendorItemData['item'] . "'," . $vendorConfig['master-file-price-column-name'] . "= IF (" . $vendorConfig['master-file-price-column-name'] . "<" . $vendorItemData['price'] . "," . $vendorItemData['price'] . "," . $vendorConfig['master-file-price-column-name'] . ")," . $vendorConfig['master-file-qty-column-name'] . "=" . $vendorConfig['master-file-qty-column-name'] . "+" . $vendorItemData['qty'];
                     db_query($query);
                 }
             }
         }
     }
 }
開發者ID:diedsmiling,項目名稱:busenika,代碼行數:16,代碼來源:DBMasterData.php


注:本文中的Vendor::getBaseDataColumn方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台,相關代碼片段篩選自各路編程大神貢獻的開源項目,源碼版權歸原作者所有,傳播和使用請參考對應項目的License;未經允許,請勿轉載。