示例#1
0
 /**
  * Public function that creates a single instance
  */
 public static function getInstance()
 {
     if (!isset(self::$_instance)) {
         self::$_instance = new self();
     }
     return self::$_instance;
 }
示例#2
0
 /**
  * Import items from uploaded file.
  */
 private function import_from_file()
 {
     global $db, $site_path;
     $gallery = gallery::getInstance();
     $gallery_manager = GalleryManager::getInstance();
     $languages = Language::getLanguages(false);
     $item_manager = ShopItemManager::getInstance();
     $category_manager = ShopCategoryManager::getInstance();
     $property_manager = \Modules\Shop\Property\Manager::getInstance();
     $membership_manager = \ShopItemMembershipManager::getInstance();
     // load categories
     $categories = array();
     $raw_categories = $category_manager->getItems($category_manager->getFieldNames(), array());
     if (count($raw_categories) > 0) {
         foreach ($raw_categories as $category) {
             $categories[$category->id] = $category->title[self::DEFAULT_LANGUAGE];
         }
     }
     // load existing items
     $existing_items = array();
     $items = $item_manager->getItems(array('id', 'uid'), array());
     foreach ($items as $item) {
         $existing_items[$item->uid] = $item->id;
     }
     // load existing images
     $existing_images = array();
     $images = $gallery_manager->getItems(array('group', 'text_id', 'id'), array());
     if (count($images) > 0) {
         foreach ($images as $image) {
             // make sure we have storage array
             if (!array_key_exists($image->group, $existing_images)) {
                 $existing_images[$image->group] = array();
             }
             // add image to the list
             $existing_images[$image->group][$image->id] = $image->text_id;
         }
     }
     $image_list = scandir(_BASEPATH . '/' . $site_path . 'import/');
     // load csv file
     $csv_data = $this->load_csv_file($_FILES['import']['tmp_name']);
     array_shift($csv_data);
     // remove header
     $number_to_import = isset($_REQUEST['number_to_import']) && !empty($_REQUEST['number_to_import']) ? fix_id($_REQUEST['number_to_import']) : count($csv_data);
     $counter = 0;
     foreach ($csv_data as $row) {
         // make sure we are within our limits
         if (++$counter > $number_to_import) {
             break;
         }
         // get item name and description
         $item_name = array_fill(0, count($languages), '');
         $item_name = array_combine($languages, $item_name);
         $item_description = $item_name;
         $item_name['he'] = $db->escape_string($row[self::COL_NAME_HE]);
         $item_name['ru'] = $db->escape_string($row[self::COL_NAME_RU]);
         $item_description['he'] = $db->escape_string($row[self::COL_DESCRIPTION_HE]);
         $item_description['ru'] = $db->escape_string($row[self::COL_DESCRIPTION_RU]);
         // unpack price values
         $prices = explode(',', $row[self::COL_PRICE]);
         $price_names = explode(',', $row[self::COL_SIZE_LABELS]);
         // generate uid and check if item exists in database
         $uid = hash('sha256', 'item_' . $row[self::COL_ID]);
         if (array_key_exists($uid, $existing_items)) {
             $data = array('name' => $item_name, 'description' => $item_description, 'price' => count($prices) > 0 ? floatval($prices[0]) : 0);
             $item_id = $existing_items[$uid];
             $item_manager->updateData($data, array('id' => $item_id));
             $gallery_id = $item_manager->getItemValue('gallery', array('id' => $item_id));
         } else {
             // prepare data
             $data = array('name' => $item_name, 'description' => $item_description, 'price' => count($prices) > 0 ? floatval($prices[0]) : 0, 'colors' => '', 'tax' => 0, 'weight' => 0, 'manufacturer' => 0, 'uid' => $uid);
             // store author of the uploaded item
             $data['author'] = $_SESSION['uid'];
             // create item gallery
             $gallery_id = $gallery->createGallery($item_name);
             $data['gallery'] = $gallery_id;
             // add item to the database
             $item_manager->insertData($data);
             $item_id = $item_manager->getInsertedID();
         }
         // remove existing prices
         $property_manager->deleteData(array('item' => $item_id, 'text_id' => array('operator' => 'LIKE', 'value' => 'price_%')));
         // create price properties
         if (count($prices) > 1) {
             // generate default name
             $price_name = array_fill(0, count($languages), '');
             $price_name = array_combine($languages, $price_name);
             for ($i = 1; $i < count($prices); $i++) {
                 // set and reset specified name
                 if (isset($price_names[$i])) {
                     $price_name[self::DEFAULT_LANGUAGE] = $price_names[$i];
                 } else {
                     $price_name[self::DEFAULT_LANGUAGE] = '';
                 }
                 // prepare data for insertion
                 $price_data = array('item' => $item_id, 'name' => $price_name, 'text_id' => 'price_' . $this->size_names[$i - 1], 'type' => 'decimal', 'value' => serialize(floatval($prices[$i])));
                 // insert new price property
                 $property_manager->insertData($price_data);
             }
         }
         // remove existing category membership
         $membership_manager->deleteData(array('item' => $item_id));
         // assign category membership
         for ($i = self::COL_FIRST_CATEGORY; $i < count($row); $i++) {
             $category_name = $row[$i];
             $category_id = $this->get_category_for_name($categories, $category_name, self::DEFAULT_THRESHOLD);
             if (!is_null($category_id)) {
                 $membership_manager->insertData(array('category' => $category_id, 'item' => $item_id));
             }
         }
         // upload images
         $image_file = mb_strtolower($row[self::COL_IMAGE]);
         $matched_file = $this->match_image_file($image_list, $image_file, 6);
         // we require a valid match
         if (!is_null($matched_file)) {
             $matched_hash = hash('md5', $matched_file);
             $source_path = _BASEPATH . '/' . $site_path . 'import/' . $matched_file;
             $destination_file = hash('md5', $matched_file . strval(time())) . '.' . pathinfo(strtolower($matched_file), PATHINFO_EXTENSION);
             $destination_path = _BASEPATH . '/' . $site_path . 'gallery/images/' . $destination_file;
             $image_already_uploaded = array_key_exists($gallery_id, $existing_images) && !in_array($matched_hash, $existing_images[$gallery_id]);
             $file_size = filesize($source_path);
             // only upload image if it wasn't uploaded already
             if (!$image_already_uploaded && copy($source_path, $destination_path)) {
                 $gallery_manager->insertData(array('group' => $gallery_id, 'title' => $item_name, 'text_id' => $matched_hash, 'size' => $file_size, 'filename' => $destination_file, 'visible' => 1, 'slideshow' => 0, 'protected' => 0));
             }
         }
     }
     // show result message
     $template = new TemplateHandler('message.xml', $this->path . 'templates/');
     $template->setMappedModule($this->name);
     $params = array('message' => $this->getLanguageConstant('message_import_complete'), 'button' => $this->getLanguageConstant('close'), 'action' => window_Close('shop_import_items'));
     $template->restoreXML();
     $template->setLocalParams($params);
     $template->parse();
 }
示例#3
0
 /**
  * Handle drawing item list
  *
  * @param array $tag_params
  * @param array $chilren
  */
 public function tag_ItemList($tag_params, $children)
 {
     global $language;
     $manager = ShopItemManager::getInstance();
     $conditions = array();
     $page_switch = null;
     $order_by = array('id');
     $order_asc = true;
     $limit = null;
     // create conditions
     if (isset($tag_params['category'])) {
         if (is_numeric($tag_params['category'])) {
             $category_id = fix_id($tag_params['category']);
         } else {
             // specified id is actually text_id, get real one
             $category_manager = ShopCategoryManager::getInstance();
             $category = $category_manager->getSingleItem(array('id'), array('text_id' => fix_chars($tag_params['category'])));
             if (!is_object($category)) {
                 return;
             }
             $category_id = $category->id;
         }
         $membership_manager = ShopItemMembershipManager::getInstance();
         $membership_items = $membership_manager->getItems(array('item'), array('category' => $category_id));
         $item_ids = array();
         if (count($membership_items) > 0) {
             foreach ($membership_items as $membership) {
                 $item_ids[] = $membership->item;
             }
         }
         if (count($item_ids) > 0) {
             $conditions['id'] = $item_ids;
         } else {
             $conditions['id'] = -1;
         }
         // make sure nothing is returned if category is empty
     }
     if (isset($tag_params['related'])) {
         $relation_manager = ShopRelatedItemsManager::getInstance();
         $item_id = fix_id($tag_params['related']);
         $related_items = $relation_manager->getItems(array('related'), array('item' => $item_id));
         $related_item_ids = array();
         if (count($related_items) > 0) {
             foreach ($related_items as $relationship) {
                 $related_item_ids[] = $relationship->related;
             }
         }
         if (count($related_item_ids) > 0) {
             $conditions['id'] = $related_item_ids;
         } else {
             $conditions['id'] = -1;
         }
     }
     if (!(isset($tag_params['show_deleted']) && $tag_params['show_deleted'] == 1)) {
         // force hiding deleted items
         $conditions['deleted'] = 0;
     }
     if (isset($tag_params['filter']) && !empty($tag_params['filter'])) {
         // filter items with name matching
         $conditions['name_' . $language] = array('operator' => 'LIKE', 'value' => '%' . fix_chars($tag_params['filter']) . '%');
     }
     if (isset($tag_params['paginate'])) {
         $per_page = is_numeric($tag_params['paginate']) ? $tag_params['paginate'] : 10;
         $param = isset($tag_params['page_param']) ? fix_chars($tag_params['page_param']) : null;
         $item_count = $manager->getItemValue('COUNT(id)', $conditions);
         $page_switch = new PageSwitch($param);
         $page_switch->setCurrentAsBaseURL();
         $page_switch->setItemsPerPage($per_page);
         $page_switch->setTotalItems($item_count);
         // get filter params
         $limit = $page_switch->getFilterParams();
     }
     if (isset($tag_params['order_by'])) {
         $order_by = array(fix_chars($tag_params['order_by']));
     }
     // get items
     $items = $manager->getItems($manager->getFieldNames(), $conditions, $order_by, $order_asc, $limit);
     // create template
     $template = $this->_parent->loadTemplate($tag_params, 'item_list_item.xml');
     $template->registerTagHandler('_color_list', $this, 'tag_ColorList');
     if (count($items) > 0) {
         $gallery = null;
         if (class_exists('gallery')) {
             $gallery = gallery::getInstance();
         }
         $manufacturer_manager = ShopManufacturerManager::getInstance();
         foreach ($items as $item) {
             if (!is_null($gallery)) {
                 // get manufacturer logo
                 $manufacturer_logo_url = '';
                 if ($item->manufacturer != 0) {
                     $manufacturer = $manufacturer_manager->getSingleItem($manufacturer_manager->getFieldNames(), array('id' => $item->manufacturer));
                     if (is_object($manufacturer)) {
                         $manufacturer_logo_url = $gallery->getImageURL($manufacturer->logo);
                     }
                 }
                 // get urls for image and thumbnail
                 $image_url = $gallery->getGroupThumbnailURL($item->gallery, true);
                 $thumbnail_url = $gallery->getGroupThumbnailURL($item->gallery);
             } else {
                 // default values if gallery is not enabled
                 $image_url = '';
                 $thumbnail_url = '';
                 $manufacturer_logo_url = '';
             }
             $rating = 0;
             $params = array('id' => $item->id, 'uid' => $item->uid, 'name' => $item->name, 'description' => $item->description, 'gallery' => $item->gallery, 'size_definition' => $item->size_definition, 'colors' => $item->colors, 'image' => $image_url, 'thumbnail' => $thumbnail_url, 'manufacturer_logo_url' => $manufacturer_logo_url, 'author' => $item->author, 'views' => $item->views, 'price' => $item->price, 'tax' => $item->tax, 'currency' => $this->_parent->settings['default_currency'], 'weight' => $item->weight, 'votes_up' => $item->votes_up, 'votes_down' => $item->votes_down, 'rating' => $rating, 'priority' => $item->priority, 'timestamp' => $item->timestamp, 'visible' => $item->visible, 'deleted' => $item->deleted, 'item_change' => url_MakeHyperlink($this->_parent->getLanguageConstant('change'), window_Open('shop_item_change', 505, $this->_parent->getLanguageConstant('title_item_change'), true, true, url_Make('transfer_control', 'backend_module', array('module', $this->name), array('backend_action', 'items'), array('sub_action', 'change'), array('id', $item->id)))), 'item_delete' => url_MakeHyperlink($this->_parent->getLanguageConstant('delete'), window_Open('shop_item_delete', 400, $this->_parent->getLanguageConstant('title_item_delete'), false, false, url_Make('transfer_control', 'backend_module', array('module', $this->name), array('backend_action', 'items'), array('sub_action', 'delete'), array('id', $item->id)))));
             $template->restoreXML();
             $template->setLocalParams($params);
             $template->parse();
         }
     }
     // draw page switch if needed
     if (!is_null($page_switch)) {
         $params = array();
         $children = array();
         // pick up parameters from original array
         foreach ($tag_params as $key => $value) {
             if (substr($key, 0, 12) == 'page_switch_') {
                 $params[substr($key, 12)] = $value;
             }
         }
         $page_switch->tag_PageSwitch($params, $children);
     }
 }
示例#4
0
 /**
  * Tag handler for category list
  *
  * @param array $tag_params
  * @param array $children
  */
 public function tag_CategoryList($tag_params, $children)
 {
     global $language;
     $manager = ShopCategoryManager::getInstance();
     $conditions = array();
     $order_by = array();
     $order_asc = true;
     $item_category_ids = array();
     $item_id = isset($tag_params['item_id']) ? fix_id($tag_params['item_id']) : null;
     // create conditions
     if (isset($tag_params['parent_id'])) {
         // set parent from tag parameter
         $conditions['parent'] = fix_id($tag_params['parent_id']);
     } else {
         if (isset($tag_params['parent'])) {
             // get parent id from specified text id
             $text_id = fix_chars($tag_params['parent']);
             $parent = $manager->getSingleItem(array('id'), array('text_id' => $text_id));
             if (is_object($parent)) {
                 $conditions['parent'] = $parent->id;
             } else {
                 $conditions['parent'] = -1;
             }
         } else {
             if (!isset($tag_params['show_all'])) {
                 $conditions['parent'] = 0;
             }
         }
     }
     if (isset($tag_params['level'])) {
         $level = fix_id($tag_params['level']);
     } else {
         $level = 0;
     }
     if (isset($tag_params['exclude'])) {
         $list = fix_id(explode(',', $tag_params['exclude']));
         $conditions['id'] = array('operator' => 'NOT IN', 'value' => $list);
     }
     if (!is_null($item_id)) {
         $membership_manager = ShopItemMembershipManager::getInstance();
         $membership_items = $membership_manager->getItems(array('category'), array('item' => $item_id));
         if (count($membership_items) > 0) {
             foreach ($membership_items as $membership) {
                 $item_category_ids[] = $membership->category;
             }
         }
     }
     // get order list
     if (isset($tag_params['order_by'])) {
         $order_by = fix_chars(split(',', $tag_params['order_by']));
     } else {
         $order_by = array('title_' . $language);
     }
     if (isset($tag_params['order_ascending'])) {
         $order_asc = $tag_params['order_asc'] == '1' or $tag_params['order_asc'] == 'yes';
     } else {
         // get items from database
         $items = $manager->getItems($manager->getFieldNames(), $conditions, $order_by, $order_asc);
     }
     // create template handler
     $template = $this->_parent->loadTemplate($tag_params, 'category_list_item.xml');
     $template->registerTagHandler('_children', $this, 'tag_CategoryList');
     // initialize index
     $index = 0;
     // parse template
     if (count($items) > 0) {
         foreach ($items as $item) {
             $image_url = '';
             $thumbnail_url = '';
             if (class_exists('gallery')) {
                 $gallery = gallery::getInstance();
                 $gallery_manager = GalleryManager::getInstance();
                 $image = $gallery_manager->getSingleItem(array('filename'), array('id' => $item->image));
                 if (!is_null($image)) {
                     $image_url = $gallery->getImageURL($image);
                     $thumbnail_url = $gallery->getThumbnailURL($image);
                 }
             }
             $params = array('id' => $item->id, 'index' => $index++, 'item_id' => $item_id, 'parent' => $item->parent, 'image_id' => $item->image, 'image' => $image_url, 'thumbnail' => $thumbnail_url, 'text_id' => $item->text_id, 'title' => $item->title, 'description' => $item->description, 'level' => $level, 'in_category' => in_array($item->id, $item_category_ids) ? 1 : 0, 'selected' => isset($tag_params['selected']) ? fix_id($tag_params['selected']) : 0, 'item_change' => url_MakeHyperlink($this->_parent->getLanguageConstant('change'), window_Open('shop_category_change', 400, $this->_parent->getLanguageConstant('title_category_change'), false, false, url_Make('transfer_control', 'backend_module', array('module', $this->name), array('backend_action', 'categories'), array('sub_action', 'change'), array('id', $item->id)))), 'item_delete' => url_MakeHyperlink($this->_parent->getLanguageConstant('delete'), window_Open('shop_category_delete', 270, $this->_parent->getLanguageConstant('title_category_delete'), false, false, url_Make('transfer_control', 'backend_module', array('module', $this->name), array('backend_action', 'categories'), array('sub_action', 'delete'), array('id', $item->id)))), 'item_add' => url_MakeHyperlink($this->_parent->getLanguageConstant('add'), window_Open('shop_category_add', 400, $this->_parent->getLanguageConstant('title_category_add'), false, false, url_Make('transfer_control', 'backend_module', array('module', $this->name), array('backend_action', 'categories'), array('sub_action', 'add'), array('parent', $item->id)))));
             $template->restoreXML();
             $template->setLocalParams($params);
             $template->parse();
         }
     }
 }
示例#5
0
文件: shop.php 项目: tareqy/Caracal
 /**
  * Get search results when asked by search module
  * 
  * @param array $query
  * @param integer $threshold
  * @return array
  */
 public function getSearchResults($query, $threshold)
 {
     global $language;
     $manager = ShopItemManager::getInstance();
     $result = array();
     $conditions = array('visible' => 1, 'deleted' => 0);
     $query = mb_strtolower($query);
     $query_words = mb_split("\\s", $query);
     // include pre-configured options
     if (isset($this->search_params['category'])) {
         $membership_manager = ShopItemMembershipManager::getInstance();
         $category = $this->search_params['category'];
         $item_ids = array();
         if (!is_numeric($category)) {
             $category_manager = ShopCategoryManager::getInstance();
             $raw_category = $category_manager->getSingleItem(array('id'), array('text_id' => $category));
             if (is_object($raw_category)) {
                 $category = $raw_category->id;
             } else {
                 $category = -1;
             }
         }
         // get list of item ids
         $membership_list = $membership_manager->getItems(array('item'), array('category' => $category));
         if (count($membership_list) > 0) {
             foreach ($membership_list as $membership) {
                 $item_ids[] = $membership->item;
             }
             $conditions['id'] = $item_ids;
         }
     }
     // get all items and process them
     $items = $manager->getItems(array('id', 'name'), $conditions);
     // search through items
     if (count($items) > 0) {
         foreach ($items as $item) {
             $title = mb_strtolower($item->name[$language]);
             $score = 0;
             foreach ($query_words as $query_word) {
                 if (is_numeric(mb_strpos($title, $query_word))) {
                     $score += 10;
                 }
             }
             // add item to result list
             if ($score >= $threshold) {
                 $result[] = array('score' => $score, 'title' => $title, 'description' => limit_words($item->description[$language], 200), 'id' => $item->id, 'type' => 'item', 'module' => $this->name);
             }
         }
     }
     return $result;
 }