Latest ads

Electronics
Vehicles
Property
Search

☣☣ මඤ්ඤං උයන ☣☣ 2 වෙනි ගමන

Status
Not open for further replies.
chamali2009

chamali2009

Member
Nov 5, 2009
13,496
373
0
37
අගහරු වල
labu gediya said:


pyar_rohit_s_avatar.gif_480_480_0_64000_0_1_0.gif

Click to expand...

මේකේ පොඩි ගතියක් තියනවා එත් එක්කම මහා වල් පාටක් පේනවනේ මට...:sorry::sorry::sorry:
 
KPZ

KPZ

Well-known member
  • Apr 15, 2011
    17,331
    1,622
    113
    where I wanna be
    chamali2009 said:
    ඔඕ..ඩේටා බේස්......DBMS ද මේ දවස් වල ඉගන ගන්නේ:D:D
    Click to expand...

    igena ganne?? :(:(

    PHP: 
    public static function getProductIdByDate($id_shop, $id_currency, $id_country, $id_group, $beginning, $ending, $id_customer = 0, $with_combination_id = false)
    {
        if (!SpecificPrice::isFeatureActive())
            return array();

        $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
            SELECT `id_product`, `id_product_attribute`
            FROM `'._DB_PREFIX_.'specific_price`
            WHERE    `id_shop` IN(0, '.(int)$id_shop.') AND
                    `id_currency` IN(0, '.(int)$id_currency.') AND
                    `id_country` IN(0, '.(int)$id_country.') AND
                    `id_group` IN(0, '.(int)$id_group.') AND
                    `id_customer` IN(0, '.(int)$id_customer.') AND
                    `from_quantity` > 1 AND
                    (
                        (`from` = \'0000-00-00 00:00:00\' OR \''.pSQL($beginning).'\' >= `from`)
                        AND
                        (`to` = \'0000-00-00 00:00:00\' OR \''.pSQL($ending).'\' <= `to`)
                    )
                    AND
                    `reduction` > 0
        ', false);

        print_r($result);
        exit();
        $ids_product = array();
        while ($row = Db::getInstance()->nextRow($result))
            $ids_product[] = $with_combination_id ? array('id_product' => (int)$row['id_product'], 'id_product_attribute' => (int)$row['id_product_attribute']) : (int)$row['id_product'];
        return $ids_product;
    }
     
    hector@troy

    hector@troy

    Well-known member
  • Apr 29, 2013
    6,726
    532
    113
    තුසර පුරය
    labu gediya said:
    මෙන්න මේ අවතාරේ දාපන්කෝ බං ලස්සනද බලන්න බොට... තනුජකයා මට දුන්න ලස්සන එකක්.. මේක මට වැඩි... දාල පෙන්නපන්කෝ...

    pyar_rohit_s_avatar.gif_480_480_0_64000_0_1_0.gif

    Click to expand...

    උබට මගේ අවතාරේ මාරු කරන්නම ඕනේද...?:confused:
    ඉදපන්කෝ එහෙනම් පොඩ්ඩක්..;)
     
    labu gediya

    labu gediya

    Well-known member
  • Dec 14, 2012
    8,594
    1,562
    113
    45
    Weligama, Sri Lanka
    KPZ said:
    onna apith awa aluth munakin :yes:
    Click to expand...

    හෙක්ටරයටත් ඔයි මොනවා හරි අවතාරයක් දීල මොඩ් කරලා ගනින්කෝ.... හැමදාම යුද්ද කරන සූට් එකම අඳින්නත් බැහැනේ.... මලකඩ කාලා ඇති.... අපේ කළු අයිය දැක්ක නම් පරණ යකඩ වලට විකුනන්න ගෙනියවී.....
     
    KPZ

    KPZ

    Well-known member
  • Apr 15, 2011
    17,331
    1,622
    113
    where I wanna be
    labu gediya said:
    හෙක්ටරයටත් ඔයි මොනවා හරි අවතාරයක් දීල මොඩ් කරලා ගනින්කෝ.... හැමදාම යුද්ද කරන සූට් එකම අඳින්නත් බැහැනේ.... මලකඩ කාලා ඇති.... අපේ කළු අයිය දැක්ක නම් පරණ යකඩ වලට විකුනන්න ගෙනියවී.....
    Click to expand...
    :lol:
     
    chamali2009

    chamali2009

    Member
    Nov 5, 2009
    13,496
    373
    0
    37
    අගහරු වල
    KPZ said:
    igena ganne?? :(:(

    PHP: 
    public static function getProductIdByDate($id_shop, $id_currency, $id_country, $id_group, $beginning, $ending, $id_customer = 0, $with_combination_id = false)
    {
        if (!SpecificPrice::isFeatureActive())
            return array();

        $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
            SELECT `id_product`, `id_product_attribute`
            FROM `'._DB_PREFIX_.'specific_price`
            WHERE    `id_shop` IN(0, '.(int)$id_shop.') AND
                    `id_currency` IN(0, '.(int)$id_currency.') AND
                    `id_country` IN(0, '.(int)$id_country.') AND
                    `id_group` IN(0, '.(int)$id_group.') AND
                    `id_customer` IN(0, '.(int)$id_customer.') AND
                    `from_quantity` > 1 AND
                    (
                        (`from` = \'0000-00-00 00:00:00\' OR \''.pSQL($beginning).'\' >= `from`)
                        AND
                        (`to` = \'0000-00-00 00:00:00\' OR \''.pSQL($ending).'\' <= `to`)
                    )
                    AND
                    `reduction` > 0
        ', false);

        print_r($result);
        exit();
        $ids_product = array();
        while ($row = Db::getInstance()->nextRow($result))
            $ids_product[] = $with_combination_id ? array('id_product' => (int)$row['id_product'], 'id_product_attribute' => (int)$row['id_product_attribute']) : (int)$row['id_product'];
        return $ids_product;
    }
    Click to expand...


    php නෙහ්.....එල කිරි..........:D:D:D
     
    KPZ

    KPZ

    Well-known member
  • Apr 15, 2011
    17,331
    1,622
    113
    where I wanna be
    monahari prashna thiyenam ahanna :nerd::nerd:

    PHP: 
    /**
    * Get prices drop
    *
    * @param integer $id_lang Language id
    * @param integer $pageNumber Start from (optional)
    * @param integer $nbProducts Number of products to return (optional)
    * @param boolean $count Only in order to get total number (optional)
    * @return array Prices drop
    */
    public static function getPricesDrop($id_lang, $page_number = 0, $nb_products = 10, $count = false,
        $order_by = null, $order_way = null, $beginning = false, $ending = false, Context $context = null)
    {
        if (!Validate::isBool($count))
            die(Tools::displayError());

        if (!$context) $context = Context::getContext();
        if ($page_number < 0) $page_number = 0;
        if ($nb_products < 1) $nb_products = 10;
        if (empty($order_by) || $order_by == 'position') $order_by = 'price';
        if (empty($order_way)) $order_way = 'DESC';
        if ($order_by == 'id_product' || $order_by == 'price' || $order_by == 'date_add'  || $order_by == 'date_upd')
            $order_by_prefix = 'p';
        else if ($order_by == 'name')
            $order_by_prefix = 'pl';
        if (!Validate::isOrderBy($order_by) || !Validate::isOrderWay($order_way))
            die (Tools::displayError());
        $current_date = date('Y-m-d H:i:s');
        $ids_product = Product::_getProductIdByDate((!$beginning ? $current_date : $beginning), (!$ending ? $current_date : $ending), $context);

        $tab_id_product = array();
        foreach ($ids_product as $product)
            if (is_array($product))
                $tab_id_product[] = (int)$product['id_product'];
            else
                $tab_id_product[] = (int)$product;

        $front = true;
        if (!in_array($context->controller->controller_type, array('front', 'modulefront')))
            $front = false;

        $sql_groups = '';
        if (Group::isFeatureActive())
        {
            $groups = FrontController::getCurrentCustomerGroups();
            $sql_groups = 'AND p.`id_product` IN (
                SELECT cp.`id_product`
                FROM `'._DB_PREFIX_.'category_group` cg
                LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
                WHERE cg.`id_group` '.(count($groups) ? 'IN ('.implode(',', $groups).')' : '= 1').'
            )';
        }

        if ($count)
        {
            return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue('
            SELECT COUNT(DISTINCT p.`id_product`)
            FROM `'._DB_PREFIX_.'product` p
            '.Shop::addSqlAssociation('product', 'p').'
            WHERE product_shop.`active` = 1
            AND product_shop.`show_price` = 1
            '.($front ? ' AND product_shop.`visibility` IN ("both", "catalog")' : '').'
            '.((!$beginning && !$ending) ? 'AND p.`id_product` IN('.((is_array($tab_id_product) && count($tab_id_product)) ? implode(', ', $tab_id_product) : 0).')' : '').'
            '.$sql_groups);
        }
        
        if (strpos($order_by, '.') > 0)
        {
            $order_by = explode('.', $order_by);
            $order_by = pSQL($order_by[0]).'.`'.pSQL($order_by[1]).'`';
        }

        $sql = '
        SELECT
             p.*, sp.*, product_shop.*, stock.out_of_stock,  IFNULL(stock.quantity, 0) as quantity, pl.`description`,  pl.`description_short`,
            MAX(product_attribute_shop.id_product_attribute) id_product_attribute,
            pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`,
            pl.`name`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name,
            DATEDIFF(
                p.`date_add`,
                DATE_SUB(
                    NOW(),
                    INTERVAL '.(Validate::isUnsignedInt(Configuration::get('PS_NB_DAYS_NEW_PRODUCT')) ? Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY
                )
            ) > 0 AS new
        FROM `'._DB_PREFIX_.'product` p
        '.Shop::addSqlAssociation('product', 'p').'
        LEFT JOIN '._DB_PREFIX_.'product_attribute pa ON (pa.id_product = p.id_product)
        '.Shop::addSqlAssociation('product_attribute', 'pa', false, 'product_attribute_shop.default_on=1').'
        '.Product::sqlStock('p', 0, false, $context->shop).'
        LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (
            p.`id_product` = pl.`id_product`
            AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl').'
        )
        LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product`)'.'
        LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (sp.`id_product` = p.`id_product`)'.
        Shop::addSqlAssociation('image', 'i', false, 'image_shop.cover=1').'
        LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = '.(int)$id_lang.')
        LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
        WHERE product_shop.`active` = 1
        AND product_shop.`show_price` = 1 AND sp.from_quantity>1
        '.($front ? ' AND p.`visibility` IN ("both", "catalog")' : '').'
         '.((!$beginning && !$ending) ? ' AND p.`id_product` IN  ('.((is_array($tab_id_product) && count($tab_id_product)) ?  implode(', ', $tab_id_product) : 0).')' : '').'
        '.$sql_groups.'
        GROUP BY product_shop.id_product
        ORDER BY '.(isset($order_by_prefix) ? pSQL($order_by_prefix).'.' : '').pSQL($order_by).' '.pSQL($order_way).'
        LIMIT '.(int)($page_number * $nb_products).', '.(int)$nb_products;

        $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);

        if (!$result)
            return false;

        if ($order_by == 'price')
            Tools::orderbyPrice($result, $order_way);

        return Product::getProductsProperties($id_lang, $result);
    }
     
    KPZ

    KPZ

    Well-known member
  • Apr 15, 2011
    17,331
    1,622
    113
    where I wanna be
    thanujaka said:
    රීසයිස් කරගනිං ඔකේ..

    15.jpg



    74.jpg



    56.jpg



    16.jpg



    ඔන්න තියෙනවා... කැමති එකක් දාගනින්... මට නං ගති එක සහ හතර ඔතනින්...
    Click to expand...
    anthima eka elas wage neeeeeeeeee
     
    chamali2009

    chamali2009

    Member
    Nov 5, 2009
    13,496
    373
    0
    37
    අගහරු වල
    labu gediya said:
    කෙල්ලෙක් නිසා ඔයාට නම් හරි යනවා මේක...
    Click to expand...

    අෆෝ වල් ඒවා දාන්න බැහැ.....චක්....:sorry::sorry::no::no:

    KPZ said:
    monahari prashna thiyenam ahanna :nerd::nerd:

    PHP: 
    /**
    * Get prices drop
    *
    * @param integer $id_lang Language id
    * @param integer $pageNumber Start from (optional)
    * @param integer $nbProducts Number of products to return (optional)
    * @param boolean $count Only in order to get total number (optional)
    * @return array Prices drop
    */
    public static function getPricesDrop($id_lang, $page_number = 0, $nb_products = 10, $count = false,
        $order_by = null, $order_way = null, $beginning = false, $ending = false, Context $context = null)
    {
        if (!Validate::isBool($count))
            die(Tools::displayError());

        if (!$context) $context = Context::getContext();
        if ($page_number < 0) $page_number = 0;
        if ($nb_products < 1) $nb_products = 10;
        if (empty($order_by) || $order_by == 'position') $order_by = 'price';
        if (empty($order_way)) $order_way = 'DESC';
        if ($order_by == 'id_product' || $order_by == 'price' || $order_by == 'date_add'  || $order_by == 'date_upd')
            $order_by_prefix = 'p';
        else if ($order_by == 'name')
            $order_by_prefix = 'pl';
        if (!Validate::isOrderBy($order_by) || !Validate::isOrderWay($order_way))
            die (Tools::displayError());
        $current_date = date('Y-m-d H:i:s');
        $ids_product = Product::_getProductIdByDate((!$beginning ? $current_date : $beginning), (!$ending ? $current_date : $ending), $context);

        $tab_id_product = array();
        foreach ($ids_product as $product)
            if (is_array($product))
                $tab_id_product[] = (int)$product['id_product'];
            else
                $tab_id_product[] = (int)$product;

        $front = true;
        if (!in_array($context->controller->controller_type, array('front', 'modulefront')))
            $front = false;

        $sql_groups = '';
        if (Group::isFeatureActive())
        {
            $groups = FrontController::getCurrentCustomerGroups();
            $sql_groups = 'AND p.`id_product` IN (
                SELECT cp.`id_product`
                FROM `'._DB_PREFIX_.'category_group` cg
                LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
                WHERE cg.`id_group` '.(count($groups) ? 'IN ('.implode(',', $groups).')' : '= 1').'
            )';
        }

        if ($count)
        {
            return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue('
            SELECT COUNT(DISTINCT p.`id_product`)
            FROM `'._DB_PREFIX_.'product` p
            '.Shop::addSqlAssociation('product', 'p').'
            WHERE product_shop.`active` = 1
            AND product_shop.`show_price` = 1
            '.($front ? ' AND product_shop.`visibility` IN ("both", "catalog")' : '').'
            '.((!$beginning && !$ending) ? 'AND p.`id_product` IN('.((is_array($tab_id_product) && count($tab_id_product)) ? implode(', ', $tab_id_product) : 0).')' : '').'
            '.$sql_groups);
        }
        
        if (strpos($order_by, '.') > 0)
        {
            $order_by = explode('.', $order_by);
            $order_by = pSQL($order_by[0]).'.`'.pSQL($order_by[1]).'`';
        }

        $sql = '
        SELECT
             p.*, sp.*, product_shop.*, stock.out_of_stock,  IFNULL(stock.quantity, 0) as quantity, pl.`description`,  pl.`description_short`,
            MAX(product_attribute_shop.id_product_attribute) id_product_attribute,
            pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`,
            pl.`name`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name,
            DATEDIFF(
                p.`date_add`,
                DATE_SUB(
                    NOW(),
                    INTERVAL '.(Validate::isUnsignedInt(Configuration::get('PS_NB_DAYS_NEW_PRODUCT')) ? Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY
                )
            ) > 0 AS new
        FROM `'._DB_PREFIX_.'product` p
        '.Shop::addSqlAssociation('product', 'p').'
        LEFT JOIN '._DB_PREFIX_.'product_attribute pa ON (pa.id_product = p.id_product)
        '.Shop::addSqlAssociation('product_attribute', 'pa', false, 'product_attribute_shop.default_on=1').'
        '.Product::sqlStock('p', 0, false, $context->shop).'
        LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (
            p.`id_product` = pl.`id_product`
            AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl').'
        )
        LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product`)'.'
        LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (sp.`id_product` = p.`id_product`)'.
        Shop::addSqlAssociation('image', 'i', false, 'image_shop.cover=1').'
        LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = '.(int)$id_lang.')
        LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
        WHERE product_shop.`active` = 1
        AND product_shop.`show_price` = 1 AND sp.from_quantity>1
        '.($front ? ' AND p.`visibility` IN ("both", "catalog")' : '').'
         '.((!$beginning && !$ending) ? ' AND p.`id_product` IN  ('.((is_array($tab_id_product) && count($tab_id_product)) ?  implode(', ', $tab_id_product) : 0).')' : '').'
        '.$sql_groups.'
        GROUP BY product_shop.id_product
        ORDER BY '.(isset($order_by_prefix) ? pSQL($order_by_prefix).'.' : '').pSQL($order_by).' '.pSQL($order_way).'
        LIMIT '.(int)($page_number * $nb_products).', '.(int)$nb_products;

        $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);

        if (!$result)
            return false;

        if ($order_by == 'price')
            Tools::orderbyPrice($result, $order_way);

        return Product::getProductsProperties($id_lang, $result);
    }
    Click to expand...

    මල්ලි foreach එකකින් වෙන්නේ මොකක්ද???:):)
     
    labu gediya

    labu gediya

    Well-known member
  • Dec 14, 2012
    8,594
    1,562
    113
    45
    Weligama, Sri Lanka
    KPZ said:
    monahari prashna thiyenam ahanna :nerd::nerd:

    PHP: 
    /**
    * Get prices drop
    *
    * @param integer $id_lang Language id
    * @param integer $pageNumber Start from (optional)
    * @param integer $nbProducts Number of products to return (optional)
    * @param boolean $count Only in order to get total number (optional)
    * @return array Prices drop
    */
    public static function getPricesDrop($id_lang, $page_number = 0, $nb_products = 10, $count = false,
        $order_by = null, $order_way = null, $beginning = false, $ending = false, Context $context = null)
    {
        if (!Validate::isBool($count))
            die(Tools::displayError());

        if (!$context) $context = Context::getContext();
        if ($page_number < 0) $page_number = 0;
        if ($nb_products < 1) $nb_products = 10;
        if (empty($order_by) || $order_by == 'position') $order_by = 'price';
        if (empty($order_way)) $order_way = 'DESC';
        if ($order_by == 'id_product' || $order_by == 'price' || $order_by == 'date_add'  || $order_by == 'date_upd')
            $order_by_prefix = 'p';
        else if ($order_by == 'name')
            $order_by_prefix = 'pl';
        if (!Validate::isOrderBy($order_by) || !Validate::isOrderWay($order_way))
            die (Tools::displayError());
        $current_date = date('Y-m-d H:i:s');
        $ids_product = Product::_getProductIdByDate((!$beginning ? $current_date : $beginning), (!$ending ? $current_date : $ending), $context);

        $tab_id_product = array();
        foreach ($ids_product as $product)
            if (is_array($product))
                $tab_id_product[] = (int)$product['id_product'];
            else
                $tab_id_product[] = (int)$product;

        $front = true;
        if (!in_array($context->controller->controller_type, array('front', 'modulefront')))
            $front = false;

        $sql_groups = '';
        if (Group::isFeatureActive())
        {
            $groups = FrontController::getCurrentCustomerGroups();
            $sql_groups = 'AND p.`id_product` IN (
                SELECT cp.`id_product`
                FROM `'._DB_PREFIX_.'category_group` cg
                LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
                WHERE cg.`id_group` '.(count($groups) ? 'IN ('.implode(',', $groups).')' : '= 1').'
            )';
        }

        if ($count)
        {
            return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue('
            SELECT COUNT(DISTINCT p.`id_product`)
            FROM `'._DB_PREFIX_.'product` p
            '.Shop::addSqlAssociation('product', 'p').'
            WHERE product_shop.`active` = 1
            AND product_shop.`show_price` = 1
            '.($front ? ' AND product_shop.`visibility` IN ("both", "catalog")' : '').'
            '.((!$beginning && !$ending) ? 'AND p.`id_product` IN('.((is_array($tab_id_product) && count($tab_id_product)) ? implode(', ', $tab_id_product) : 0).')' : '').'
            '.$sql_groups);
        }
        
        if (strpos($order_by, '.') > 0)
        {
            $order_by = explode('.', $order_by);
            $order_by = pSQL($order_by[0]).'.`'.pSQL($order_by[1]).'`';
        }

        $sql = '
        SELECT
             p.*, sp.*, product_shop.*, stock.out_of_stock,  IFNULL(stock.quantity, 0) as quantity, pl.`description`,  pl.`description_short`,
            MAX(product_attribute_shop.id_product_attribute) id_product_attribute,
            pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`,
            pl.`name`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name,
            DATEDIFF(
                p.`date_add`,
                DATE_SUB(
                    NOW(),
                    INTERVAL '.(Validate::isUnsignedInt(Configuration::get('PS_NB_DAYS_NEW_PRODUCT')) ? Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY
                )
            ) > 0 AS new
        FROM `'._DB_PREFIX_.'product` p
        '.Shop::addSqlAssociation('product', 'p').'
        LEFT JOIN '._DB_PREFIX_.'product_attribute pa ON (pa.id_product = p.id_product)
        '.Shop::addSqlAssociation('product_attribute', 'pa', false, 'product_attribute_shop.default_on=1').'
        '.Product::sqlStock('p', 0, false, $context->shop).'
        LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (
            p.`id_product` = pl.`id_product`
            AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl').'
        )
        LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product`)'.'
        LEFT JOIN `'._DB_PREFIX_.'specific_price` sp ON (sp.`id_product` = p.`id_product`)'.
        Shop::addSqlAssociation('image', 'i', false, 'image_shop.cover=1').'
        LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = '.(int)$id_lang.')
        LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
        WHERE product_shop.`active` = 1
        AND product_shop.`show_price` = 1 AND sp.from_quantity>1
        '.($front ? ' AND p.`visibility` IN ("both", "catalog")' : '').'
         '.((!$beginning && !$ending) ? ' AND p.`id_product` IN  ('.((is_array($tab_id_product) && count($tab_id_product)) ?  implode(', ', $tab_id_product) : 0).')' : '').'
        '.$sql_groups.'
        GROUP BY product_shop.id_product
        ORDER BY '.(isset($order_by_prefix) ? pSQL($order_by_prefix).'.' : '').pSQL($order_by).' '.pSQL($order_way).'
        LIMIT '.(int)($page_number * $nb_products).', '.(int)$nb_products;

        $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);

        if (!$result)
            return false;

        if ($order_by == 'price')
            Tools::orderbyPrice($result, $order_way);

        return Product::getProductsProperties($id_lang, $result);
    }
    Click to expand...

    මොකක්ද බං මේ මකබාව.... මෙලෝ දෙයක් හිතාගන්න බැහැ.... තොට මඤ්ඤං ද.....
     
    Status
    Not open for further replies.

    Similar threads

    Mr.Tom
    ☣☣ මඤ්ඤං උයන ☣☣ 7
    Replies
    3K
    Views
    111K
    King_cobra
    King_cobra
    Mr.Tom
    ☣☣ මඤ්ඤං උයන ☣☣ 6
    Replies
    9K
    Views
    278K
    KPZ
    KPZ
    Mr.Tom
    • Locked
    ☣☣ මඤ්ඤං උයන ☣☣ 5
    Replies
    10K
    Views
    316K
    Mal Baba
    Mal Baba
    Mr.Tom
    • Locked
    ☣☣ මඤ්ඤං උයන ☣☣ 4
    Replies
    16K
    Views
    458K
    Kumara456
    Kumara456
    Mr.Tom
    ☣☣ මඤ්ඤං උයන ☣☣ 3 වෙනි ගමන
    Replies
    8K
    Views
    298K
    Pessimist
    Pessimist
    Top Bottom