public function saveImportAction()
{
$request = $this->getRequest();
$importConfig = new Varien_Object();
$path = '';
$delimiter = $request->getParam('delimiter', false);
$enclosure = $request->getParam('enclosure', false);
$importConfig->setFilePath($path)->setDelimiter($delimiter)->setEnclosure($enclosure);
try {
$file = $_FILES['file']['name'];
$path = Mage::getBaseDir('var') . DS . 'import' . DS;
$uploader = new Varien_File_Uploader('file');
$uploader->setAllowRenameFiles(false);
$uploader->setFilesDispersion(false);
$uploader->save($path, $file);
$io = new Varien_Io_File();
$io->open(array('path' => $path));
$io->streamOpen($path . $file, 'r');
$io->streamLock(true);
$map = $io->streamReadCsv($delimiter, $enclosure);
$prodModel = Mage::getSingleton('catalog/product');
$db = Mage::getSingleton('core/resource')->getConnection('core_write');
$db->query('set foreign_key_checks = 0');
while ($data = $io->streamReadCsv($delimiter, $enclosure)) {
$prod = $prodModel->loadByAttribute('sku', $data[2]);
if (!$prod || !$prod->getId()) {
continue;
}
$prices = Mage::getModel('customerprices/prices');
$prices->loadByCustomer($prod->getId(), $data[0], $data[3]);
$prices->setProductId($prod->getId());
$prices->setCustomerId($data[0]);
$prices->setCustomerEmail($data[1]);
$prices->setQty($data[3]);
$prices->setPrice($data[4]);
$prices->setSpecialPrice($data[5]);
$prices->save();
}
Mage::getSingleton('adminhtml/session')->addSuccess(Mage::helper('customerprices')->__('Prices where succesfully imported '));
} catch (Mage_Core_Exception $e) {
Mage::getSingleton('adminhtml/session')->addError($e->getMessage());
} catch (Exception $e) {
//Mage::getSingleton('adminhtml/session')->addError(Mage::helper('customergroupsprice')->__($e->getMessage().'An error occurred while importing prices.'));
Mage::getSingleton('adminhtml/session')->addError($e->getMessage());
}
$this->getResponse()->setRedirect($this->getUrl("*/*/import"));
}
protected function _prepareForm()
{
$form = new Varien_Data_Form();
$fieldset = $form->addFieldset('base_fieldset', array('legend' => Mage::helper('giftcards')->__('Create Gift Cards')));
$fieldset->addField('file_path', 'text', array('name' => 'file_path', 'label' => Mage::helper('giftcards')->__('Path to export Cards Code'), 'title' => Mage::helper('giftcards')->__('Path to export Cards Code'), 'required' => true));
$fieldset->addField('count', 'text', array('name' => 'count', 'label' => Mage::helper('giftcards')->__('Count of Gift Cards'), 'title' => Mage::helper('giftcards')->__('Count of Gift Cards'), 'required' => true));
$fieldset->addField('amount', 'text', array('name' => 'amount', 'label' => Mage::helper('giftcards')->__('Gift Cards Amount'), 'title' => Mage::helper('giftcards')->__('Gift Cards Amount'), 'required' => true));
$createConfig = new Varien_Object();
$createConfig->setFilePath('/var/backups/cardslist' . date('d-m-Y-His') . '.csv');
$createConfig->setCount(1);
$createConfig->setAmount(100);
$form->setValues($createConfig->getData());
$form->setAction($this->getUrl('*/adminhtml_cardscreate/save'));
$form->setMethod('post');
$form->setUseContainer(true);
$form->setId('edit_form');
$this->setForm($form);
return parent::_prepareForm();
}
