Advertisement
Guest User

Untitled

a guest
Feb 12th, 2013
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.85 KB | None | 0 0
  1. $topSql ='(SELECT i.id,i.id_group_0,i.id_group_1,i.img_w_h,i.svoistva,i.id_item,i.url,i.name,
  2.        i.col_29,pr.price as `fprice`,i.price,
  3.        ip.`ext_small_picture`,ip.`ext_picture`
  4.                 FROM `items` as i
  5.                     LEFT JOIN `items_props` as ip ON ip.id_external = i.id_item
  6.                     LEFT JOIN `items_prices` as pr on pr.idItem = i.id_item AND pr.idFilial = ' . $_SESSION['idFilial'] . '
  7.                     INNER JOIN `items_store`as s on s.idItem = i.id_item AND s.idFilial = ' . $_SESSION['idFilial'].'
  8.                      WHERE i.col_29 = 1 AND i.`id_item`!= \'\' AND i.`id_item` IS NOT NULL  AND i.`on_off` = 1
  9.                      ) UNION';
  10.         $bestSql = '(SELECT i.id,i.id_group_0,i.id_group_1,i.img_w_h,i.svoistva,i.id_item,i.url,i.name,
  11.        i.col_29,pr.price as `fprice`,i.price,
  12.        ip.`ext_small_picture`,ip.`ext_picture`
  13.                 FROM `items` as i
  14.                     LEFT JOIN `items_props` as ip ON ip.id_external = i.id_item
  15.                     LEFT JOIN `items_prices` as pr on pr.idItem = i.id_item AND pr.idFilial = ' . $_SESSION['idFilial'] . '
  16.                     INNER JOIN `items_store`as s on s.idItem = i.id_item AND s.idFilial = ' . $_SESSION['idFilial'].'
  17.                      WHERE `id_item`!="" AND `id_item` IS NOT NULL AND (ip.`ext_small_picture` != "" OR ip.ext_picture != "")
  18.                  AND `id_group_0` NOT IN("' . implode('","', $ids) . '")) UNION';
  19.         foreach ($this->store as $store) {
  20.             if($store == !$_SESSION['idFilial']){
  21.                 $topSql .=' (SELECT i.id,i.id_group_0,i.id_group_1,i.img_w_h,i.svoistva,i.id_item,i.url,i.name,
  22.        i.col_29,pr.price as `fprice`,i.price,
  23.        ip.`ext_small_picture`,ip.`ext_picture`
  24.                 FROM `items` as i
  25.                     LEFT JOIN `items_props` as ip ON ip.id_external = i.id_item
  26.                     LEFT JOIN `items_prices` as pr on pr.idItem = i.id_item AND pr.idFilial = ' . $_SESSION['idFilial'] . '
  27.                     INNER JOIN `items_store`as s on s.idItem = i.id_item AND s.idFilial = ' . $store.'
  28.                     WHERE i.col_29 = 1 AND i.`id_item`!= \'\' AND i.`id_item` IS NOT NULL  AND i.`on_off` = 1
  29.                     ) UNION';
  30.                 $bestSql .= '(SELECT i.id,i.id_group_0,i.id_group_1,i.img_w_h,i.svoistva,i.id_item,i.url,i.name,
  31.        i.col_29,pr.price as `fprice`,i.price,
  32.        ip.`ext_small_picture`,ip.`ext_picture`
  33.                 FROM `items` as i
  34.                     LEFT JOIN `items_props` as ip ON ip.id_external = i.id_item
  35.                     LEFT JOIN `items_prices` as pr on pr.idItem = i.id_item AND pr.idFilial = ' . $_SESSION['idFilial'] . '
  36.                     INNER JOIN `items_store`as s on s.idItem = i.id_item AND s.idFilial = ' . $_SESSION['idFilial'].'
  37.                      WHERE `id_item`!="" AND `id_item` IS NOT NULL AND (ip.`ext_small_picture` != "" OR ip.ext_picture != "")
  38.                  AND `id_group_0` NOT IN("' . implode('","', $ids) . '")) UNION';
  39.             }
  40.         }
  41.         $topSql = rtrim($topSql,'UNION');
  42.         $newSql = rtrim($bestSql,'UNION').' ORDER BY `id` DESC LIMIT 100';
  43.         $bestSql = rtrim($bestSql,'UNION').' ORDER BY `rating` DESC LIMIT 100';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement