public function execute()
{
$search = new shopIndexSearch();
if (waRequest::param(0)) {
$search->indexProduct(waRequest::param(0));
} else {
$product_model = new shopProductModel();
$n = $product_model->countAll();
$limit = 100;
$i = 0;
$product_model->exec("TRUNCATE TABLE shop_search_index");
while ($i < $n) {
echo $i . "/" . $n . "\n";
$sql = "SELECT p.*, t.name type_name FROM " . $product_model->getTableName() . " p\n LEFT JOIN shop_type t ON p.type_id = t.id\n LIMIT " . $i . ", " . $limit;
$products = $product_model->query($sql)->fetchAll('id');
$product_ids = array_keys($products);
// get skus
$sql = "SELECT * FROM shop_product_skus WHERE product_id IN (i:id)";
$data = $product_model->query($sql, array('id' => $product_ids));
foreach ($data as $row) {
$products[$row['product_id']]['skus'][] = $row;
}
// get tags
$sql = "SELECT pt.product_id, t.name FROM shop_product_tags pt\n JOIN shop_tag t ON pt.tag_id = t.id WHERE pt.product_id IN (i:id)";
$data = $product_model->query($sql, array('id' => $product_ids));
foreach ($data as $row) {
$products[$row['product_id']]['tags'][] = $row['name'];
}
// get features
$sql = "SELECT pf.product_id, fv.value FROM shop_product_features pf\n JOIN shop_feature f ON pf.feature_id = f.id AND f.type = 'varchar'\n JOIN shop_feature_values_varchar fv ON pf.feature_value_id = fv.id WHERE pf.product_id IN (i:id)";
$data = $product_model->query($sql, array('id' => $product_ids));
foreach ($data as $row) {
$products[$row['product_id']]['features'][] = $row['value'];
}
$sql = "SELECT pf.product_id, fv.value FROM shop_product_features pf\n JOIN shop_feature f ON pf.feature_id = f.id AND f.type = 'double'\n JOIN shop_feature_values_double fv ON pf.feature_value_id = fv.id WHERE pf.product_id IN (i:id)";
$data = $product_model->query($sql, array('id' => $product_ids));
foreach ($data as $row) {
$products[$row['product_id']]['features'][] = $row['value'];
}
$sql = "SELECT pf.product_id, fv.value FROM shop_product_features pf\n JOIN shop_feature f ON pf.feature_id = f.id AND f.type = 'text'\n JOIN shop_feature_values_text fv ON pf.feature_value_id = fv.id WHERE pf.product_id IN (i:id)";
$data = $product_model->query($sql, array('id' => $product_ids));
foreach ($data as $row) {
$products[$row['product_id']]['features'][] = $row['value'];
}
// get skus
$sql = "SELECT * FROM shop_product_skus WHERE product_id IN (i:id)";
$data = $product_model->query($sql, array('id' => $product_ids));
foreach ($data as $row) {
$products[$row['product_id']]['skus'][] = $row;
}
foreach ($products as $p) {
$search->indexProduct($p, false);
}
$i += $limit;
}
}
}
public function execute($n = 1)
{
$routes = $this->getRoutes();
$this->app_id = wa()->getApp();
$category_model = new shopCategoryModel();
$product_model = new shopProductModel();
$page_model = new shopPageModel();
$count = 0;
foreach ($routes as $route) {
$this->routing->setRoute($route);
$domain = $this->routing->getDomain(null, true);
$route_url = $domain . '/' . $this->routing->getRoute('url');
if ($n == 1) {
// categories
$sql = "SELECT c.id,c.parent_id,c.left_key,c.url,c.full_url,c.create_datetime,c.edit_datetime\n FROM shop_category c\n LEFT JOIN shop_category_routes cr ON c.id = cr.category_id\n WHERE c.status = 1 AND (cr.route IS NULL OR cr.route = '" . $category_model->escape($route_url) . "')\n ORDER BY c.left_key";
$categories = $category_model->query($sql)->fetchAll('id');
$category_url = $this->routing->getUrl($this->app_id . '/frontend/category', array('category_url' => '%CATEGORY_URL%'), true);
foreach ($categories as $c_id => $c) {
if ($c['parent_id'] && !isset($categories[$c['parent_id']])) {
unset($categories[$c_id]);
continue;
}
if (isset($route['url_type']) && $route['url_type'] == 1) {
$url = $c['url'];
} else {
$url = $c['full_url'];
}
$this->addUrl(str_replace('%CATEGORY_URL%', $url, $category_url), $c['edit_datetime'] ? $c['edit_datetime'] : $c['create_datetime'], self::CHANGE_WEEKLY, 0.6);
}
$main_url = $this->getUrl('');
// pages
$sql = "SELECT full_url, url, create_datetime, update_datetime FROM " . $page_model->getTableName() . '
WHERE status = 1 AND domain = s:domain AND route = s:route';
$pages = $page_model->query($sql, array('domain' => $domain, 'route' => $route['url']))->fetchAll();
foreach ($pages as $p) {
$this->addUrl($main_url . $p['full_url'], $p['update_datetime'] ? $p['update_datetime'] : $p['create_datetime'], self::CHANGE_MONTHLY, 0.6);
}
/**
* @event sitemap
* @param array $route
* @return array $urls
*/
$plugin_urls = wa()->event(array($this->app_id, 'sitemap'), $route);
if ($plugin_urls) {
foreach ($plugin_urls as $urls) {
foreach ($urls as $url) {
$this->addUrl($url['loc'], ifset($url['lastmod'], time()), ifset($url['changefreq']), ifset($url['priority']));
}
}
}
// main page
$this->addUrl($main_url, time(), self::CHANGE_DAILY, 1);
}
// products
$c = $this->countProductsByRoute($route);
if ($count + $c <= ($n - 1) * $this->limit) {
$count += $c;
continue;
} else {
if ($count >= ($n - 1) * $this->limit) {
$offset = 0;
} else {
$offset = ($n - 1) * $this->limit - $count;
}
$count += $offset;
$limit = min($this->limit, $n * $this->limit - $count);
}
$sql = "SELECT p.url, p.create_datetime, p.edit_datetime";
if (isset($route['url_type']) && $route['url_type'] == 2) {
$sql .= ', c.full_url category_url';
}
$sql .= " FROM " . $product_model->getTableName() . ' p';
if (isset($route['url_type']) && $route['url_type'] == 2) {
$sql .= " LEFT JOIN " . $category_model->getTableName() . " c ON p.category_id = c.id";
}
$sql .= ' WHERE p.status = 1';
if (!empty($route['type_id'])) {
$sql .= ' AND p.type_id IN (i:type_id)';
}
$sql .= ' LIMIT ' . $offset . ',' . $limit;
$products = $product_model->query($sql, $route);
$count += $products->count();
$product_url = $this->routing->getUrl($this->app_id . '/frontend/product', array('product_url' => '%PRODUCT_URL%', 'category_url' => '%CATEGORY_URL%'), true);
foreach ($products as $p) {
if (!empty($p['category_url'])) {
$url = str_replace(array('%PRODUCT_URL%', '%CATEGORY_URL%'), array($p['url'], $p['category_url']), $product_url);
} else {
$url = str_replace(array('%PRODUCT_URL%', '/%CATEGORY_URL%'), array($p['url'], ''), $product_url);
}
$this->addUrl($url, $p['edit_datetime'] ? $p['edit_datetime'] : $p['create_datetime'], self::CHANGE_MONTHLY, 0.8);
}
if ($count >= $n * $this->limit) {
break;
}
}
}
public function crossSelling($product_id, $limit = 5, $available_only = false, $key = false)
{
if (!is_numeric($limit)) {
$key = $available_only;
$available_only = $limit;
$limit = 5;
}
if (is_string($available_only)) {
$key = $available_only;
$available_only = false;
}
if (!$product_id) {
return array();
}
if (is_array($product_id)) {
if ($key) {
foreach ($product_id as &$r) {
$r = $r[$key];
}
unset($r);
}
$product_model = new shopProductModel();
$sql = "SELECT p.* FROM shop_product p JOIN shop_type t ON p.type_id = t.id\n WHERE (p.id IN (i:id)) AND (t.cross_selling != '' OR p.cross_selling = 2)\n ORDER BY RAND() LIMIT 1";
$p = $product_model->query($sql, array('id' => $product_id))->fetchAssoc();
$p = new shopProduct($p);
$result = $p->crossSelling($limit, $available_only);
foreach ($result as $p_id => $pr) {
if (in_array($p_id, $product_id)) {
unset($result[$p_id]);
}
}
return $result;
} else {
$p = new shopProduct($product_id);
return $p->crossSelling($limit, $available_only);
}
}
