本文整理匯總了PHP中Vendor::getNextLine方法的典型用法代碼示例。如果您正苦於以下問題:PHP Vendor::getNextLine方法的具體用法?PHP Vendor::getNextLine怎麽用?PHP Vendor::getNextLine使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Vendor
的用法示例。
在下文中一共展示了Vendor::getNextLine方法的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']);
}
}
}
}
}
示例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);
}
}
}
}
}