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) . '\'),';
}
