public function parseFile($fileName)
{
if (!file_exists($fileName)) {
Vikont_Pulliver_Helper_Data::throwException(sprintf('no such data file: %s', $fileName));
return false;
}
if (false === ($handle = fopen($fileName, "rb"))) {
Vikont_Pulliver_Helper_Data::throwException(sprintf('Cannot open file: %s', $fileName));
return false;
}
Vikont_Pulliver_Helper_Data::type("Parsing {$fileName}...");
if (false !== ($rowData = fgetcsv($handle, 1024, '|'))) {
$skuColumn = array_search('ITEM_NUM', $rowData);
$columns = array();
foreach (self::$columns as $key => $value) {
$columns[] = array_search($key, $rowData);
}
} else {
return array();
}
$result = array();
while (false !== ($rowData = fgetcsv($handle, 1024, '|'))) {
$data = array($rowData[$skuColumn]);
foreach ($columns as $columnPos) {
$data[] = '+' == $rowData[$columnPos] ? 10 : (int) $rowData[$columnPos];
}
$result[] = $data;
}
return $result;
}
public function parseFile($fileName)
{
if (!file_exists($fileName)) {
Vikont_Pulliver_Helper_Data::throwException(sprintf('no such data file: %s', $fileName));
return false;
}
$result = array();
Vikont_Pulliver_Helper_Data::type("Parsing {$fileName}...");
$fileHandle = fopen($fileName, 'r');
$firstLine = true;
while (false !== ($values = fgetcsv($fileHandle))) {
if ($firstLine) {
$this->_detectColumnPositions($values);
$firstLine = false;
}
$items = array();
foreach (self::$_columnPositions as $colIndex => $colPosition) {
if (!$colIndex) {
$items[] = $values[$colPosition];
// SKU
} else {
$items[] = '+' == $values[$colPosition] ? 10 : (int) $values[$colPosition];
}
}
$result[] = $items;
}
fclose($fileHandle);
return $result;
}
public function parseFile($fileName, $inventoryType)
{
if (!file_exists($fileName)) {
Vikont_Pulliver_Helper_Data::throwException(sprintf('no such data file: %s', $fileName));
return false;
}
$result = array();
$data = file($fileName, FILE_IGNORE_NEW_LINES + FILE_SKIP_EMPTY_LINES);
$pattern = $inventoryType == 'master' ? self::$_itemMasterColumns : self::$_invlistColumns;
Vikont_Pulliver_Helper_Data::type("Parsing {$fileName}...");
foreach ($data as $line) {
$result[] = self::parseLineByPattern($pattern, $line);
}
return $result;
}
public function parseFile($fileName)
{
if (!file_exists($fileName)) {
Vikont_Pulliver_Helper_Data::throwException(sprintf('no such data file: %s', $fileName));
return false;
}
Vikont_Pulliver_Helper_Data::type("Parsing {$fileName}...");
$result = array();
$data = file($fileName, FILE_IGNORE_NEW_LINES + FILE_SKIP_EMPTY_LINES);
foreach ($data as $line) {
$values = explode("\t", $line);
if (count($values) < 2 || '' === $values[2]) {
continue;
}
$result[$values[0]] = (int) $values[2];
}
return $result;
}
public function parseFile($fileName)
{
if (!file_exists($fileName)) {
Vikont_Pulliver_Helper_Data::throwException(sprintf('no such data file: %s', $fileName));
return false;
}
Vikont_Pulliver_Helper_Data::type("Parsing {$fileName}...");
$result = array();
$fileHandle = fopen($fileName, 'r');
while (false !== ($values = fgetcsv($fileHandle))) {
if (count($values) < 2) {
continue;
}
// $result[$values[0]] = array($values[4], $values[5]);
$result[$values[0]] = $values[1];
}
fclose($fileHandle);
return $result;
}
public function parseFile($fileName)
{
if (!file_exists($fileName)) {
Vikont_Pulliver_Helper_Data::throwException(sprintf('no such data file: %s', $fileName));
return false;
}
Vikont_Pulliver_Helper_Data::type("Parsing {$fileName}...");
$result = array();
$fileHandle = fopen($fileName, 'r');
while (false !== ($values = fgetcsv($fileHandle, 0, '|'))) {
if ($firstLine) {
$this->_detectColumnPositions($values);
$firstLine = false;
continue;
}
$result[$values[self::$_columnPositions[0]]] = (int) $values[self::$_columnPositions[1]];
}
fclose($fileHandle);
return $result;
}
public function parseFile($fileName)
{
if (!file_exists($fileName)) {
Vikont_Pulliver_Helper_Data::throwException(sprintf('no such data file: %s', $fileName));
return false;
}
Vikont_Pulliver_Helper_Data::type("Parsing {$fileName}...");
$result = array();
$fileHandle = fopen($fileName, 'r');
while (false !== ($values = fgetcsv($fileHandle))) {
// $itemNumber = self::formatItemNumber($values[0], $values[1]);
// unset($values[0]);
// $result[$itemNumber] = $values;
// self::convertItemNumberToSKU($itemNumber)
$result[self::formatItemNumber($values[0], $values[1])] = $values;
}
fclose($fileHandle);
unset($result['Part Number']);
return $result;
}
umask(0);
require_once $mageRoot . '/Vic.php';
// = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Vikont_Pulliver_Model_Log::setLogFileName('pulliver.log');
Vikont_Pulliver_Helper_Data::setSilentExceptions(false);
Vikont_Pulliver_Helper_Data::type("\nKawasaki Converter started...\n");
$commonHelper = Mage::helper('pulliver');
$moduleHelper = Mage::helper('pulliver/Kawasaki');
$skuHelper = Mage::helper('pulliver/Sku');
try {
$params = isset($argv) ? Vikont_Pulliver_Helper_Data::getCommandLineParams($argv) : new Varien_Object($_GET);
if ($downloadedFileName = $params->getData('file')) {
Vikont_Pulliver_Helper_Data::type(sprintf('Using local file %s', $downloadedFileName));
} else {
// $downloadedFileName = $moduleHelper->downloadFile();
Vikont_Pulliver_Helper_Data::type('No file to convert');
die;
}
$update = $moduleHelper->parseFile($downloadedFileName);
$outputFileName = $moduleHelper->getLocalFileName($downloadedFileName);
$fileHandle = $commonHelper->openFile($outputFileName);
$lineCounter = 0;
foreach ($update as $item) {
if ($sku = $skuHelper->getSkuByItemNumber('KA', $itemNumber)) {
fputcsv($fileHandle, array($sku, $item));
$lineCounter++;
}
}
fclose($fileHandle);
Vikont_Pulliver_Helper_Data::inform(sprintf('Successfully created file %s, %d lines processed, %d lines added', $outputFileName, count($update), $lineCounter));
} catch (Exception $e) {
Mage::app('admin')->setUseSessionInUrl(false);
umask(0);
require_once $mageRoot . '/Vic.php';
// = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Vikont_Pulliver_Model_Log::setLogFileName('pulliver.log');
Vikont_Pulliver_Helper_Data::setSilentExceptions(false);
Vikont_Pulliver_Helper_Data::type("\nKawasaki Converter started...\n");
$commonHelper = Mage::helper('pulliver');
$moduleHelper = Mage::helper('pulliver/Kawasaki');
try {
$params = isset($argv) ? Vikont_Pulliver_Helper_Data::getCommandLineParams($argv) : new Varien_Object($_GET);
$sourceFileName = $params->getData('file');
if ($sourceFileName) {
$sourceFileName = $commonHelper->getImportStorageLocation() . 'kawasaki/source/' . basename($sourceFileName);
Vikont_Pulliver_Helper_Data::type(sprintf('Using local file %s', $sourceFileName));
} else {
Vikont_Pulliver_Helper_Data::type('Please specify a file to convert like ?file={path-to-file}');
die;
}
$update = $moduleHelper->parseFile($sourceFileName);
$outputFileName = $moduleHelper->getLocalFileName($sourceFileName);
$fileHandle = $commonHelper->openFile($outputFileName);
foreach ($update as $items) {
fputcsv($fileHandle, $items);
}
fclose($fileHandle);
Vikont_Pulliver_Helper_Data::inform(sprintf('Successfully created file %s having %d lines', $outputFileName, count($update)));
} catch (Exception $e) {
Mage::logException($e);
Vikont_Pulliver_Helper_Data::inform($e->getMessage());
}
$commonHelper = Mage::helper('pulliver');
$moduleHelper = Mage::helper('pulliver/TroyLee');
$skuHelper = Mage::helper('pulliver/Sku');
try {
$params = isset($argv) ? Vikont_Pulliver_Helper_Data::getCommandLineParams($argv) : new Varien_Object($_GET);
if ($downloadedFileName = $params->getData('file')) {
Vikont_Pulliver_Helper_Data::inform(sprintf('Skipped downloading, using local file %s', $downloadedFileName));
} else {
$downloadedFileName = $moduleHelper->downloadFile();
}
$update = $moduleHelper->parseFile($downloadedFileName);
$outputFileName = $moduleHelper->getLocalFileName('inventory.csv');
$fileHandle = $commonHelper->openFile($outputFileName);
$lineCounter = 0;
$outputMissingItems = $params->getData('missing_items');
foreach ($update as $itemNumber => $item) {
if ($sku = $skuHelper->getSkuByItemNumber('YL', $itemNumber)) {
fputcsv($fileHandle, array($sku, $item));
$lineCounter++;
} else {
if ($outputMissingItems) {
Vikont_Pulliver_Helper_Data::type($itemNumber . ' ' . $item);
}
}
}
fclose($fileHandle);
Vikont_Pulliver_Helper_Data::inform(sprintf('Successfully created file %s, %d lines processed, %d lines added', $outputFileName, count($update), $lineCounter));
} catch (Exception $e) {
Mage::logException($e);
Vikont_Pulliver_Helper_Data::inform($e->getMessage());
}
