public function execute() { $type_id = $this->getType(); if (!$type_id) { return; } $hash = waRequest::post('hash', '', waRequest::TYPE_STRING_TRIM); if (!$hash) { $product_ids = waRequest::post('product_id', array(), waRequest::TYPE_ARRAY_INT); $product_ids = $this->product_model->filterAllowedProductIds($product_ids); if (!$product_ids) { return; } $this->product_model->updateType($product_ids, $type_id); $this->response['types'] = $this->type_model->getTypes(); } else { if (substr($hash, 0, 5) != 'type/') { $collection = new shopProductsCollection($hash); $offset = 0; $count = 100; $total_count = $collection->count(); while ($offset < $total_count) { $ids = array_keys($collection->getProducts('*', $offset, $count)); $filtered = $this->product_model->filterAllowedProductIds($ids); $this->product_model->updateType($filtered, $type_id); $offset += count($ids); } $this->response['types'] = $this->type_model->getTypes(); } else { $this->product_model->changeType(substr($hash, 5), $type_id); $this->response['types'] = $this->type_model->getTypes(); } } }
protected function init() { try { $this->data['timestamp'] = time(); $this->data['direction'] = waRequest::post('direction', 'import'); $type_model = new shopTypeModel(); $this->data['types'] = array_map('intval', array_keys($type_model->getTypes())); switch ($this->data['direction']) { case 'export': $this->initExport(); break; case 'import': default: $this->data['direction'] = 'import'; $this->initImport(); break; } $stages = array_keys($this->data['count']); $this->data['current'] = array_fill_keys($stages, 0); $value = $this->data['direction'] == 'import' ? $this->emulate(null) ? array('add' => 0, 'found' => 0, 'skip' => 0, 'rights' => 0, 'currency' => 0) : array('new' => 0, 'update' => 0, 'skip' => 0, 'error' => 0, 'rights' => 0, 'currency' => 0) : 0; $this->data['processed_count'] = array_fill_keys($stages, $value); $this->data['map'] = array(); $this->data['memory'] = memory_get_peak_usage(); $this->data['memory_avg'] = memory_get_usage(); $this->data['timestamp'] = time(); } catch (waException $ex) { $this->error($ex->getMessage()); echo $this->json(array('error' => $ex->getMessage())); exit; } }
public function execute() { $type_model = new shopTypeModel(); $types = $type_model->getTypes(); $this->response = array_values($types); $this->response['_element'] = 'type'; }
public function execute() { $hide = waRequest::get('hide'); if (strlen($hide)) { wa()->getUser()->setSettings('shop', 'collapse_types', intval($hide)); exit; } else { $type_model = new shopTypeModel(); wa()->getUser()->setSettings('shop', 'collapse_types', 0); $this->view->assign('types', $type_model->getTypes()); } }
public function execute() { if (!$this->getUser()->isAdmin('shop') && !wa()->getUser()->getRights('shop', 'type.%')) { throw new waRightsException('Access denied'); } $this->setLayout(new shopBackendLayout()); $this->getResponse()->setTitle(_w('Products')); $this->view->assign('categories', new shopCategories()); $tag_model = new shopTagModel(); $this->view->assign('cloud', $tag_model->getCloud()); $set_model = new shopSetModel(); $this->view->assign('sets', $set_model->getAll()); $collapse_types = wa()->getUser()->getSettings('shop', 'collapse_types'); if (empty($collapse_types)) { $type_model = new shopTypeModel(); $this->view->assign('types', $type_model->getTypes()); } else { $this->view->assign('types', false); } $product_model = new shopProductModel(); $this->view->assign('count_all', $product_model->countAll()); $review_model = new shopProductReviewsModel(); $this->view->assign('count_reviews', array('all' => $review_model->count(null, false), 'new' => $review_model->countNew(true))); $product_services = new shopServiceModel(); $this->view->assign('count_services', $product_services->countAll()); $config = $this->getConfig(); $this->view->assign('default_view', $config->getOption('products_default_view')); /* * @event backend_products * @return array[string]array $return[%plugin_id%] array of html output * @return array[string][string]string $return[%plugin_id%]['sidebar_top_li'] html output * @return array[string][string]string $return[%plugin_id%]['sidebar_section'] html output */ $this->view->assign('backend_products', wa()->event('backend_products')); $this->view->assign('sidebar_width', $config->getSidebarWidth()); $this->view->assign('lang', substr(wa()->getLocale(), 0, 2)); }
public function execute() { $model = new shopTypeModel(); $this->view->assign('types', $model->getTypes()); }
/** * Get product ids and leave only allowed by rights * * @param array $product_ids * @return array */ public function filterAllowedProductIds(array $product_ids) { if (wa('shop')->getUser()->getRights('shop', 'type.all')) { return $product_ids; } $type_model = new shopTypeModel(); $types = $type_model->getTypes(); $type_ids = array_keys($types); if (empty($product_ids) || empty($types)) { return array(); } $product_ids = array_keys($this->query("\n SELECT id FROM `{$this->table}`\n WHERE id IN(" . implode(',', $product_ids) . ")\n AND type_id IN (" . implode(',', $type_ids) . ")")->fetchAll('id')); return $product_ids; }
public function execute() { $direction = waRequest::request('direction', 'import') == 'export' ? 'export' : 'import'; $profile_helper = new shopImportexportHelper('csv:product:' . $direction); $this->view->assign('profiles', $profile_helper->getList()); $profile = $profile_helper->getConfig(); if ($direction == 'export') { //export section TODO $profile['config'] += array('encoding' => 'UTF-8', 'images' => true, 'features' => true, 'domain' => null, 'delimiter' => ';', 'hash' => ''); $info = array(); if (!empty($profile['id'])) { $path = wa()->getTempPath('csv/download/' . $profile['id']); $files = waFiles::listdir($path); foreach ($files as $file) { $file_path = $path . '/' . $file; $info[] = array('name' => $file, 'mtime' => filemtime($file_path), 'size' => filesize($file_path)); } usort($info, create_function('$a, $b', 'return (max(-1, min(1, $a["mtime"] - $b["mtime"])));')); } $this->view->assign('info', array_slice($info, -5, 5, true)); $set_model = new shopSetModel(); $this->view->assign('sets', $set_model->getAll()); $routing = wa()->getRouting(); $settlements = array(); $current_domain = null; $domain_routes = $routing->getByApp('shop'); foreach ($domain_routes as $domain => $routes) { foreach ($routes as $route) { $settlement = $domain . '/' . $route['url']; if ($current_domain === null) { $current_domain = $settlement; } elseif ($settlement == $profile['config']['domain']) { $current_domain = $settlement; } $settlements[] = $settlement; } } $this->view->assign('current_domain', $current_domain); $this->view->assign('settlements', $settlements); } else { $profile['config'] += array('encoding' => 'UTF-8', 'delimiter' => ';', 'map' => array()); $base_path = wa()->getConfig()->getPath('root'); $app_path = array('shop' => wa()->getDataPath(null, false, 'shop'), 'site' => wa()->getDataPath(null, true, 'site')); foreach ($app_path as &$path) { $path = preg_replace('@^([\\\\/])@', '', str_replace($base_path, '', $path . '/')); } unset($path); $this->view->assign('upload_path', waSystem::getSetting('csv.upload_path', 'path/to/folder/with/source/images/')); $this->view->assign('upload_app', waSystem::getSetting('csv.upload_app', 'shop')); $this->view->assign('app_path', $app_path); } $this->view->assign('profile', $profile); $type_model = new shopTypeModel(); $this->view->assign('types', $type_model->getTypes()); $encoding = array_diff(mb_list_encodings(), array('pass', 'wchar', 'byte2be', 'byte2le', 'byte4be', 'byte4le', 'BASE64', 'UUENCODE', 'HTML-ENTITIES', 'Quoted-Printable', '7bit', '8bit', 'auto')); $popular = array_intersect(array('UTF-8', 'Windows-1251', 'ISO-8859-1'), $encoding); asort($encoding); $encoding = array_unique(array_merge($popular, $encoding)); $this->view->assign('encoding', $encoding); $plugins = wa()->getConfig()->getPlugins(); $this->view->assign('direction', $direction); $this->view->assign('plugin', ifempty($plugins['csvproducts'], array())); }
public function execute() { $product = new shopProduct(waRequest::get('id', 0, waRequest::TYPE_INT)); if (!$product->id) { if (waRequest::get('id') == 'new') { $product->name = ''; $product->id = 'new'; $product->status = 1; } else { throw new waException("Product not found", 404); } } $counters = array('reviews' => 0, 'images' => 0, 'pages' => 0, 'services' => 0); $sidebar_counters = array(); $config = $this->getConfig(); /** * @var shopConfig $config */ #load product types $type_model = new shopTypeModel(); $product_types = $type_model->getTypes(true); $product_types_count = count($product_types); if (intval($product->id)) { # 1 fill extra product data # 1.1 fill product reviews $product_reviews_model = new shopProductReviewsModel(); $product['reviews'] = $product_reviews_model->getReviews($product->id, 0, $config->getOption('reviews_per_page_product'), 'datetime DESC', array('is_new' => true)); $counters['reviews'] = $product_reviews_model->count($product->id); $sidebar_counters['reviews'] = array('new' => $product_reviews_model->countNew()); $counters['images'] = count($product['images']); $product_pages_model = new shopProductPagesModel(); $counters['pages'] = $product_pages_model->count($product->id); $product_services_model = new shopProductServicesModel(); $counters['services'] = $product_services_model->countServices($product->id); $product_stocks_log_model = new shopProductStocksLogModel(); $counters['stocks_log'] = $product_stocks_log_model->countByField('product_id', $product->id); $this->view->assign('edit_rights', $product->checkRights()); } else { $counters += array_fill_keys(array('images', 'services', 'pages', 'reviews'), 0); $product['images'] = array(); reset($product_types); $product->type_id = 0; if ($product_types_count) { if (!$product_types) { throw new waRightsException(_w("Access denied")); } else { reset($product_types); $product->type_id = key($product_types); } } elseif (!$product->checkRights()) { throw new waRightsException(_w("Access denied")); } $this->view->assign('edit_rights', true); $product['skus'] = array('-1' => array('id' => -1, 'sku' => '', 'available' => 1, 'name' => '', 'price' => 0.0, 'purchase_price' => 0.0, 'count' => null, 'stock' => array(), 'virtual' => 0)); $product->currency = $config->getCurrency(); } $this->assignReportsData($product); $stock_model = new shopStockModel(); $taxes_mode = new shopTaxModel(); $this->view->assign('stocks', $stock_model->getAll('id')); $this->view->assign(array('use_product_currency' => wa()->getSetting('use_product_currency'), 'currencies' => $this->getCurrencies(), 'primary_currency' => $config->getCurrency(), 'taxes' => $taxes_mode->getAll())); $category_model = new shopCategoryModel(); $categories = $category_model->getFullTree('id, name, depth, url, full_url, parent_id', true); $frontend_urls = array(); if (intval($product->id)) { $routing = wa()->getRouting(); $domain_routes = $routing->getByApp($this->getAppId()); foreach ($domain_routes as $domain => $routes) { foreach ($routes as $r) { if (!empty($r['private'])) { continue; } if (empty($r['type_id']) || in_array($product->type_id, (array) $r['type_id'])) { $routing->setRoute($r, $domain); $params = array('product_url' => $product->url); if ($product->category_id && isset($categories[$product->category_id])) { if (!empty($r['url_type']) && $r['url_type'] == 1) { $params['category_url'] = $categories[$product->category_id]['url']; } else { $params['category_url'] = $categories[$product->category_id]['full_url']; } } $frontend_url = $routing->getUrl('/frontend/product', $params, true); $frontend_urls[] = array('url' => $frontend_url); } } } } else { $frontend_urls[] = array('url' => wa()->getRouteUrl('/frontend/product', array('product_url' => '%product_url%'), true)); } $stuff = intval($product->id) ? $product->url : '%product_url%'; foreach ($frontend_urls as &$frontend_url) { $pos = strrpos($frontend_url['url'], $stuff); $frontend_url['base'] = $pos !== false ? rtrim(substr($frontend_url['url'], 0, $pos), '/') . '/' : $frontend_url['url']; } unset($frontend_url); $product_model = new shopProductModel(); $this->view->assign('storefront_map', $product_model->getStorefrontMap($product->id)); /** * Backend product profile page * UI hook allow extends product profile page * @event backend_product * @param shopProduct $entry * @return array[string][string]string $return[%plugin_id%]['title_suffix'] html output * @return array[string][string]string $return[%plugin_id%]['action_button'] html output * @return array[string][string]string $return[%plugin_id%]['toolbar_section'] html output * @return array[string][string]string $return[%plugin_id%]['image_li'] html output */ $this->view->assign('backend_product', wa()->event('backend_product', $product)); /** * @event backend_product_edit */ $this->view->assign('backend_product_edit', wa()->event('backend_product_edit', $product)); $this->view->assign('categories', $categories); $this->view->assign('counters', $counters); $this->view->assign('product', $product); $this->view->assign('current_author', shopProductReviewsModel::getAuthorInfo(wa()->getUser()->getId())); $this->view->assign('reply_allowed', true); $this->view->assign('review_allowed', true); $this->view->assign('sidebar_counters', $sidebar_counters); $this->view->assign('lang', substr(wa()->getLocale(), 0, 2)); $this->view->assign('frontend_urls', $frontend_urls); $tag_model = new shopTagModel(); $this->view->assign('popular_tags', $tag_model->popularTags()); $counts = array(); // Selectable features $features_selectable = $product->features_selectable; if (is_array($features_selectable)) { foreach ($features_selectable as $f) { if ($f['selected']) { $counts[] = $f['selected']; } } } $feature_model = new shopTypeFeaturesModel(); $features_selectable_types = $feature_model->getSkuTypeSelectableTypes(); foreach ($product_types as $type_id => &$type) { $type['sku_type'] = empty($features_selectable_types[$type_id]) ? shopProductModel::SKU_TYPE_FLAT : shopProductModel::SKU_TYPE_SELECTABLE; } $this->view->assign('features', $features_selectable); $this->view->assign('duble', '???'); $this->view->assign('features_counts', $counts); #load product types $this->view->assign('product_types', $product_types); $this->view->assign('sidebar_width', $config->getSidebarWidth()); }
public function getAvailableImages($offset = 0, $limit = null) { if (!$limit) { $limit = (int) $offset; $offset = 0; } else { $offset = (int) $offset; $limit = (int) $limit; } if (wa()->getUser()->getRights('shop', 'type.all')) { $sql = "SELECT * FROM `{$this->table}` ORDER BY product_id, id LIMIT {$offset}, {$limit}"; } else { $type_model = new shopTypeModel(); $types = $type_model->getTypes(); if (!$types) { return array(); } $sql = "SELECT i.* FROM `{$this->table}` i\n JOIN `shop_products` p ON p.id = i.product_id\n WHERE p.type_id IN (" . array_keys($types) . ")\n ORDER BY i.product_id, i.id\n LIMIT {$offset}, {$limit}"; } return $this->query($sql)->fetchAll('id'); }