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(); }