if (!isset($rowData[$colPositions['part_number']]) || !$rowData[$colPositions['part_number']]) { $deployer->logMessage('ERROR: Part # not specified: ' . implode(',', $rowData)); continue; } if (false !== $deleteColIndex && normalizeYesNo($rowData[$deleteColIndex])) { // remove it! $brandCode = $rowData[$colPositions['supplier_code']]; if (!isset($deleteRecords[$brandCode])) { $deleteRecords[$brandCode] = array(); } $deleteRecords[$brandCode][] = addslashes($rowData[$colPositions['part_number']]); } else { $sqlData = array(); foreach ($colPositions as $colName => $colIndex) { if (in_array($colIndex, $yesNoColIndexes)) { $colValue = (int) normalizeYesNo($rowData[$colIndex]); } else { if (in_array($colIndex, $priceColIndexes)) { $colValue = round(str_replace(array(' ', ','), '', $rowData[$colIndex]), 2); } else { if (in_array($colIndex, $nonEmptyColIndexes)) { $colValue = $rowData[$colIndex] ? addslashes($rowData[$colIndex]) : '0'; } else { $colValue = addslashes($rowData[$colIndex]); } } } $sqlData[] = $colValue; } $dataString .= '(\'' . implode('\',\'', $sqlData) . '\'),'; }
$deployer->logMessage('ERROR: Part # not specified: ' . implode(',', $rowData)); continue; } if (false !== $deleteColIndex && normalizeYesNo($rowData[$deleteColIndex])) { // remove it! $brandCode = $rowData[$colPositions['supplier_code']]; if (!isset($deleteRecords[$brandCode])) { $deleteRecords[$brandCode] = array(); } $deleteRecords[$brandCode][] = addslashes($rowData[$colPositions['part_number']]); } else { $sqlData = array(); foreach ($colPositions as $colName => $colIndex) { $value = trim($rowData[$colIndex]); if (in_array($colIndex, $yesNoColIndexes)) { $colValue = (int) normalizeYesNo($value); } else { if (in_array($colIndex, $priceColIndexes)) { $colValue = round(str_replace(array(' ', ','), '', $value), 2); } else { if (in_array($colIndex, $nonEmptyColIndexes)) { $colValue = $rowData[$colIndex] ? addslashes($value) : '0'; } else { $colValue = addslashes($value); } } } $sqlData[] = $colValue; } $dataString .= '(\'' . implode('\',\'', $sqlData) . '\'),'; }