コード例 #1
0
ファイル: items.php プロジェクト: ForAEdesWeb/AEW4
 public function import()
 {
     if (!JSession::checkToken('post') && !JSession::checkToken('get')) {
         jexit('COM_DJCATALOG2_INVALID_TOKEN');
     }
     require_once JPATH_COMPONENT_ADMINISTRATOR . DS . 'helpers' . DS . 'import.php';
     $app = JFactory::getApplication();
     $model = $this->getModel('item');
     $files = $app->input->files;
     $db = JFactory::getDbo();
     $user = JFactory::getUser();
     $date = JFactory::getDate();
     $file = $files->get('csvfile');
     $enclosure = $app->input->get('enclosure', 0) == 0 ? "\"" : "'";
     $separator = $app->input->get('separator', 0) == 0 ? "," : ";";
     $defaults = array();
     $defaults['cat_id'] = $app->input->get('cat_id', 0);
     $defaults['producer_id'] = $app->input->get('producer_id', 0);
     $defaults['group_id'] = $app->input->get('group_id', 0);
     $defaults['price'] = $app->input->get('price', 0.0);
     $defaults['special_price'] = $app->input->get('special_price', 0.0);
     $defaults['published'] = $app->input->get('published', 0);
     $defaults['created_by'] = $app->input->get('created_by', $user->id);
     $defaults['created'] = $app->input->get('created', $date->toSql());
     if ($defaults['cat_id'] > 0) {
         $db->setQuery('select count(*) from #__djc2_categories where id =' . $defaults['cat_id']);
         $result = (bool) $db->loadResult();
         if ($result == false) {
             $defaults['cat_id'] = 0;
         }
     }
     if ($defaults['producer_id'] > 0) {
         $db->setQuery('select count(*) from #__djc2_producers where id =' . $defaults['producer_id']);
         $result = (bool) $db->loadResult();
         if ($result == false) {
             $defaults['producer_id'] = 0;
         }
     }
     if ($defaults['group_id'] > 0) {
         $db->setQuery('select count(*) from #__djc2_items_extra_fields_groups where id =' . $defaults['group_id']);
         $result = (bool) $db->loadResult();
         if ($result == false) {
             $defaults['group_id'] = 0;
         }
     }
     $messages = array();
     if (!empty($file)) {
         if (!$file['error']) {
             $tempname = $file['tmp_name'];
             if (mb_check_encoding(file_get_contents($file['tmp_name']), 'UTF-8') == false) {
                 $this->setRedirect(JRoute::_('index.php?option=com_djcatalog2&view=import', false), JText::_('COM_DJCATALOG2_ERROR_INVALID_ENCODING'), 'error');
                 return false;
             }
             $rows = Djcatalog2ImportHelper::parseCSV(realpath($tempname), $separator, $enclosure);
             if (!empty($rows)) {
                 $messages = Djcatalog2ImportHelper::storeRecords($rows, $model, 'item', $defaults);
             }
         }
     }
     foreach ($messages as $type => $arr) {
         if (!empty($arr)) {
             foreach ($arr as $message) {
                 $app->enqueueMessage($message, $type);
             }
         }
     }
     $this->setRedirect(JRoute::_('index.php?option=com_djcatalog2&view=import', false));
     return true;
 }
コード例 #2
0
ファイル: import.php プロジェクト: jputz12/OneNow-Vshop
 public static function getStateByName($name, $country_id = 0)
 {
     if (empty($name)) {
         return false;
     }
     $name = JString::strtolower(JString::trim($name));
     $where = (int) $country_id > 0 ? ' country_id=' . (int) $country_id . ' ' : ' 1 ';
     if (empty(self::$states)) {
         $db = JFactory::getDbo();
         $db->setQuery('select lower(name) as name, id from #__djc2_countries_states WHERE ' . $where . ' order by name asc');
         self::$states = $db->loadObjectList('name');
     }
     if (isset(self::$states[$name])) {
         return self::$states[$name]->id;
     }
     $db->setQuery('select country_name, id from #__djc2_countries where ' . $where . ' AND lower(country_name) like' . $db->quote('%' . $db->escape($name) . '%') . ' LIMIT 1');
     $result = $db->loadObject();
     if (!empty($result)) {
         self::$countries[$name] = $result;
         return self::$countries[$name]->id;
     }
     return false;
 }