function add2cart()
 {
     //        pr($_POST);
     $json['bool'] = 0;
     $ses = session_id();
     $cart = new CartPortal();
     $cart->session_id = $ses;
     if (MemberLogin::isLogged()) {
         $cart->customer_id = MemberLogin::getID();
     }
     $cart->variant_id = addslashes($_POST['variantID']);
     $cart->qty = addslashes($_POST['qty']);
     if ($cart->qty < 1) {
         echo json_encode(array("bool" => 0, "status_message" => "Wrong Qty"));
         die;
     }
     $cart->latitude = addslashes($_POST['cust_lat']);
     $cart->longitude = addslashes($_POST['cust_long']);
     $cart->date_created = leap_mysqldate();
     $cart->date_updated = leap_mysqldate();
     $cart->status = 1;
     $skip = 0;
     //cek apakah sudah ada di cart, kalau sudah tambahkan/ganti quantitynya
     $arr = self::myCart();
     foreach ($arr as $cc) {
         if ($cc->variant_id == $cart->variant_id) {
             $cc->qty = $cart->qty;
             $cc->date_updated = leap_mysqldate();
             $cc->load = 1;
             if ($cc->save()) {
                 setcookie("cartses", $ses, time() + 60 * 60 * 24 * 14, '/');
                 $json['bool'] = 1;
                 $json['status_message'] = "ok";
                 $json['totalcart'] = self::totalCart();
                 $skip = 1;
                 //log
                 $mprod = new MProdModel();
                 $mprod->getByID($cc->variant_id);
                 $mprod->updateCarted();
             }
         }
     }
     if (!$skip) {
         if ($cart->save()) {
             setcookie("cartses", $ses, time() + 60 * 60 * 24 * 14, '/');
             $json['bool'] = 1;
             $json['status_message'] = "ok";
             $json['totalcart'] = self::totalCart();
             //log
             $mprod = new MProdModel();
             $mprod->getByID($cart->variant_id);
             $mprod->updateCarted();
         } else {
             $json['bool'] = 0;
             $json['status_message'] = "save error";
         }
     }
     $json['crossSell'] = array();
     $json['crossSellHtml'] = "";
     if ($json['bool'] == 1) {
         //kalau ada cross sell atau up sell dicari disini ...
         $cross = new MCrossSell();
         $arrCross = $cross->getWhere("related_group LIKE '%{$cart->variant_id}%' AND related_active = 1 ORDER BY related_priority DESC");
         if (count($arrCross) > 0) {
             $activeCs = $arrCross[0];
             if ($activeCs->related_target_group != "") {
                 $exp = explode(",", $activeCs->related_target_group);
                 $numberOfCross = 4;
                 $keys = array_rand($exp, min($numberOfCross, count($exp)));
                 $pc = new ProductAtCategory();
                 $html = "<h4 class='cross_title'>You might also like</h4>";
                 foreach ($keys as $num => $ex) {
                     $prods = new MProdModel();
                     $prods->getByID($exp[$ex]);
                     $imgurl = $pc->imgURL . $prods->BaseArticleImageFile;
                     if ($prods->BaseArticleImageFile == "") {
                         $prods = $pc->noimage;
                     }
                     $href = '<a title="' . $prods->BaseArticleNameENG . '"
                                    href="' . _SPPATH . 'pr/p/' . $prods->VariantID . '/' . ProductAtCategory::bersihkanNama($prods->BaseArticleNameENG) . '">';
                     $html .= "<div class='cross_item col-md-3'>\n{$href}<img src='" . $imgurl . "' width='100%' ></a>\n <div class='cross_item_name'>" . $href . $prods->BaseArticleNameENG . "</a></div>\n\n</div>";
                     $json['crossSell'][] = $prods;
                     if ($num > $numberOfCross) {
                         break;
                     }
                 }
                 $html .= "<div class='clearfix'></div>";
                 $json['crossSellHtml'] = $html;
             }
         }
     }
     echo json_encode($json);
     die;
 }
    function products()
    {
        ?>
        <h1 style="margin-top: 0;">Behaviour Analytics</h1>
        <div class="row">
        <div class="col-md-4">
        <div class="penjualan_container">
        <div class="penjualan">
            <h2 class="penjualan_money_h2" style="margin-bottom: 20px;">Last Search Terms</h2>
            <?php 
        $sL = new MSearchLog();
        $arrSl = $sL->getOrderBy("slog_date DESC LIMIT 0,30");
        if (count($arrSl) > 0) {
            $slsudah = array();
            ?>
                <table class="table table-striped"><?php 
            foreach ($arrSl as $sll) {
                if (!in_array($sll->slog_keyword, $slsudah)) {
                    $slsudah[] = $sll->slog_keyword;
                    ?>
                        <tr>
                            <td>
                                <div class="searchkeyword"><?php 
                    echo $sll->slog_keyword;
                    ?>
</div>
                            </td>
                        </tr>

                    <?php 
                }
            }
            ?>
</table><?php 
        } else {
            ?>
                <p>We couldn't find any records.</p>
            <?php 
        }
        ?>
        </div>
        <hr>
        <div class="penjualan">
            <h2 class="penjualan_money_h2" style="margin-bottom: 20px;">Top Search Terms</h2>
            <?php 
        $sL = new MSearchLog();
        global $db;
        $q = "SELECT slog_keyword,COUNT(*) as count FROM {$sL->table_name} GROUP BY slog_keyword ORDER BY count DESC LIMIT 0,10";
        $arrSl = $db->query($q, 2);
        //                    pr($arrSl);
        //                    $arrSl = $sL->getOrderBy("slog_date DESC LIMIT 0,30");
        if (count($arrSl) > 0) {
            $slsudah = array();
            ?>
                <table class="table table-striped"><?php 
            foreach ($arrSl as $sll) {
                if (!in_array($sll->slog_keyword, $slsudah)) {
                    $slsudah[] = $sll->slog_keyword;
                    ?>
                        <tr>
                            <td>
                                <div class="searchkeyword"><?php 
                    echo $sll->slog_keyword;
                    ?>
</div>
                            </td>
                            <td>
                                <div class="searchkeyword"><?php 
                    echo $sll->count;
                    ?>
</div>
                            </td>
                        </tr>

                    <?php 
                }
            }
            ?>
</table><?php 
        } else {
            ?>
                <p>We couldn't find any records.</p>
            <?php 
        }
        ?>
        </div>
        </div>
            <div class="penjualan_container" style="margin-top: 20px;">
                <div class="penjualan">
                    <h2 class="penjualan_money_h2" style="margin-bottom: 20px;">Most Viewed Products</h2>

        <?php 
        $prod = new MProdModel();
        $mEff = $prod->getOrderBy("fg_viewed DESC LIMIT 0,6");
        $pc = new ProductAtCategory();
        ?>
                    <table class="table table-striped">
                        <?php 
        foreach ($mEff as $key => $obj) {
            $t = time() . rand(0, 100);
            $imgurl = $pc->imgURL . $obj->BaseArticleImageFile;
            if ($obj->BaseArticleImageFile == "") {
                $imgurl = $pc->noimage;
            }
            ?>
            <tr>
                <td>
                    <div class="view_prod">
                        <?php 
            echo $obj->BaseArticleNameENG;
            ?>
                    </div>
                </td>
                <td>
                    <?php 
            echo $obj->fg_viewed;
            ?>
                </td>
            </tr>

            <?php 
        }
        ?>
                    </table>
                </div>
                <hr>
                <div class="penjualan">
                    <h2 class="penjualan_money_h2" style="margin-bottom: 20px;">Most Added To Cart</h2>

                    <?php 
        $prod = new MProdModel();
        $mEff = $prod->getOrderBy("fg_carted DESC LIMIT 0,6");
        $pc = new ProductAtCategory();
        ?>
                    <table class="table table-striped">
                        <?php 
        foreach ($mEff as $key => $obj) {
            $t = time() . rand(0, 100);
            $imgurl = $pc->imgURL . $obj->BaseArticleImageFile;
            if ($obj->BaseArticleImageFile == "") {
                $imgurl = $pc->noimage;
            }
            ?>
                            <tr>
                                <td>
                                    <div class="view_prod">
                                        <?php 
            echo $obj->BaseArticleNameENG;
            ?>
                                    </div>
                                </td>
                                <td>
                                    <?php 
            echo $obj->fg_viewed;
            ?>
                                </td>
                            </tr>

                        <?php 
        }
        ?>
                    </table>
                </div>
            </div>


        </div>

        <div class="col-md-8">

            <div class="penjualan_container">
                <div class="penjualan">
                    <h2 class="penjualan_money_h2" style="margin-bottom: 20px;">Most Effective Products</h2>

                    <?php 
        $prod = new MProdModel();
        $mEff = $prod->getOrderBy("fg_cb DESC LIMIT 0,6");
        $pc = new ProductAtCategory();
        foreach ($mEff as $key => $obj) {
            $t = time() . rand(0, 100);
            $imgurl = $pc->imgURL . $obj->BaseArticleImageFile;
            if ($obj->BaseArticleImageFile == "") {
                $imgurl = $pc->noimage;
            }
            ?>
                    <div class="product_list_item col-md-4 noborder">
                        <div class="product_list_item_dalaman">

                            <div id="imgasli_<?php 
            echo $obj->VariantID;
            ?>
_<?php 
            echo $t;
            ?>
" class="product_list_item_img">

                                <a title="<?php 
            echo $obj->BaseArticleNameENG;
            ?>
"
                                   href="<?php 
            echo _SPPATH;
            ?>
pr/p/<?php 
            echo $obj->VariantID;
            ?>
/<?php 
            echo ProductAtCategory::bersihkanNama($obj->BaseArticleNameENG);
            ?>
">
                                    <img id="imgTarget_<?php 
            echo $obj->VariantID;
            ?>
" src="<?php 
            echo $imgurl;
            ?>
">
                                </a>
                            </div>

                            <div class="product_list_item_text">
                                <div class="name" style="text-align: center;">
                                    <a title="<?php 
            echo $obj->BaseArticleNameENG;
            ?>
"
                                       href="<?php 
            echo _SPPATH;
            ?>
pr/p/<?php 
            echo $obj->VariantID;
            ?>
/<?php 
            echo ProductAtCategory::bersihkanNama($obj->BaseArticleNameENG);
            ?>
">
                                        <?php 
            echo $obj->BaseArticleNameENG;
            ?>
                                    </a>
                                </div>
                                <div class="fg" style="text-align: center; font-size: 25px; font-weight: bold;">
                                    <?php 
            echo round($obj->fg_cb, 3) * 100;
            ?>
 %
                                </div>

                            </div>
                        </div>
                        </div>
                        <?php 
        }
        //                    pr($mEff);
        ?>
                    <div class="clearfix"></div>
                </div>
</div>
            <div class="penjualan_container" style="margin-top: 20px;">

                <div class="penjualan">
                    <h2 class="penjualan_money_h2" style="margin-bottom: 20px;">Least Effective Products</h2>

                    <?php 
        $prod = new MProdModel();
        $mEff = $prod->getWhere("fg_cb>0 ORDER BY fg_cb ASC LIMIT 0,6");
        $pc = new ProductAtCategory();
        foreach ($mEff as $key => $obj) {
            $t = time() . rand(0, 100);
            $imgurl = $pc->imgURL . $obj->BaseArticleImageFile;
            if ($obj->BaseArticleImageFile == "") {
                $imgurl = $pc->noimage;
            }
            ?>
                        <div class="product_list_item col-md-4 noborder">
                            <div class="product_list_item_dalaman">

                                <div id="imgasli_<?php 
            echo $obj->VariantID;
            ?>
_<?php 
            echo $t;
            ?>
" class="product_list_item_img">

                                    <a title="<?php 
            echo $obj->BaseArticleNameENG;
            ?>
"
                                       href="<?php 
            echo _SPPATH;
            ?>
pr/p/<?php 
            echo $obj->VariantID;
            ?>
/<?php 
            echo ProductAtCategory::bersihkanNama($obj->BaseArticleNameENG);
            ?>
">
                                        <img id="imgTarget_<?php 
            echo $obj->VariantID;
            ?>
" src="<?php 
            echo $imgurl;
            ?>
">
                                    </a>
                                </div>

                                <div class="product_list_item_text">
                                    <div class="name" style="text-align: center;">
                                        <a title="<?php 
            echo $obj->BaseArticleNameENG;
            ?>
"
                                           href="<?php 
            echo _SPPATH;
            ?>
pr/p/<?php 
            echo $obj->VariantID;
            ?>
/<?php 
            echo ProductAtCategory::bersihkanNama($obj->BaseArticleNameENG);
            ?>
">
                                            <?php 
            echo $obj->BaseArticleNameENG;
            ?>
                                        </a>
                                    </div>
                                    <div class="fg" style="text-align: center; font-size: 25px; font-weight: bold;">
                                        <?php 
            echo round($obj->fg_cb, 3) * 100;
            ?>
 %
                                    </div>

                                </div>
                            </div>
                        </div>
                    <?php 
        }
        //                    pr($mEff);
        ?>
                    <div class="clearfix"></div>
                </div>
            </div>
            </div>

        </div>

        <style>
            .penjualan_container{
                border: 1px solid #dedede;
                background-color: white;
                padding: 20px;
            }
            .penjualan_money_h2{
                padding: 0;
                margin: 0;
                font-size: 20px;
                margin-bottom: 20px;
                color: #666666;
            }
            .penjualan_money{
                font-size: 25px;
            }
            .penjualan{
                margin-bottom: 20px;
            }
        </style>
<?php 
    }
    public static function printer($id, $name)
    {
        if ($_GET['cardnr'] != '' && $_GET['dob'] != '') {
            //diloginkan langsung
            MemberLogin::loginkanLangsung();
        }
        $prod = new MProdModel();
        $prod->getByID($id);
        if ($prod->VariantID == "") {
            MemberLogin::handleNotFound();
        }
        $pc = new ProductAtCategory();
        $imgurl = $pc->imgURL . $prod->BaseArticleImageFile;
        if ($prod->BaseArticleImageFile == "") {
            $imgurl = $pc->noimage;
        }
        $prod->updateView();
        global $template;
        if ($prod->prod_seo_title != "") {
            $template->title = $prod->prod_seo_title;
        }
        if ($prod->prod_seo_meta_description != "") {
            $template->metades = $prod->prod_seo_meta_description;
        }
        if ($prod->prod_seo_meta_key != "") {
            $template->metakey = $prod->prod_seo_meta_key;
        }
        $addTextToHead = '';
        if ($prod->prod_seo_fbog_title != "") {
            $addTextToHead .= '<meta property="og:title" content=" ' . $prod->prod_seo_fbog_title . ' " />';
        }
        if ($prod->prod_seo_fbog_description != "") {
            $addTextToHead .= '<meta property="og:description" content="' . $prod->prod_seo_fbog_description . '" />';
        }
        if ($prod->prod_seo_fbog_image != "") {
            $addTextToHead .= '<meta property="og:image"  content="' . _BPATH . _PHOTOURL . $prod->prod_seo_fbog_image . '" />';
        }
        if ($addTextToHead != "") {
            $actual_link = "http://{$_SERVER['HTTP_HOST']}{$_SERVER['REQUEST_URI']}";
            $addTextToHead .= '<meta property="og:site_name" content="' . $template->title . '"/>';
            $addTextToHead .= '<meta property="og:url" content="' . $actual_link . '" />';
            $addTextToHead .= '<meta property="fb:app_id" content="510260392457364" />';
            $addTextToHead .= '<meta property="og:type" content="website" />';
        }
        $template->addTextToHead($addTextToHead);
        /*
         * Apply rule to variant
         *
         */
        $rules = MCPRule::getRules();
        $rules2variant = MCPRule::getRules2Variant();
        if (count($rules2variant[$id]) > 0) {
            $uu = $rules2variant[$prod->VariantID];
            //set icon
            $prod->rule_icon = _SPPATH . _PHOTOURL . $rules[$uu[0]]->rule_icon;
            //                            pr($uu);
            //diskon
            $diskon = 0;
            foreach ($uu as $ruleygkena) {
                $r = $rules[$ruleygkena];
                $diskon = max($r->rule_discount, $diskon);
            }
            $prod->rule_discount = $diskon;
        } else {
            $prod->rule_icon = "";
            //default rule icon
            $prod->rule_discount = 0;
        }
        $prod->final_price = (100 - $prod->rule_discount) / 100 * $prod->SellingPrice;
        //    pr($prod);
        ?>
        <div style="margin-top: 40px;" class="donly">&nbsp;</div>
        <div class="col-md-4 col-md-offset-1" >

            <img src="<?php 
        echo $imgurl;
        ?>
" style="width: 100%;">
        </div>
        <div class="col-md-6">
            <h1 style="font-size: 25px;"><?php 
        echo $prod->BaseArticleNameENG;
        ?>
</h1>

        <div style="float: left; line-height: 40px;">
            <img src="http://thebodyshop.ugc.bazaarvoice.com/6097-en_gb/4_7/5/rating.gif" class="BVImgOrSprite" alt="4.7 / 5" title="4.7 / 5">
            </div>
            <?php 
        if ($prod->rule_icon != "") {
            $uu = $rules2variant[$prod->VariantID];
            ?>
                <div style="float: right; opacity: 0.7;">
                    <?php 
            foreach ($uu as $ruleygkena) {
                $r = $rules[$ruleygkena];
                ?>
                        <a style="text-decoration: none;" href="#" data-toggle="tooltip" data-placement="bottom" title="<?php 
                echo $r->rule_description;
                ?>
">
                        <img  style="width: 30px; height: 30px; margin: 5px;" src="<?php 
                echo _SPPATH . _PHOTOURL . $r->rule_icon;
                ?>
">
                        </a>
                    <?php 
            }
            ?>
                </div>
                <script>
                    $(document).ready(function(){
                        $('[data-toggle="tooltip"]').tooltip();
                    });
                </script>
            <?php 
        }
        ?>
            <div class="clearfix"></div>

            <p style="margin-top: 20px; margin-bottom: 10px;"><?php 
        echo $prod->ArticleInfoENG;
        ?>
</p>

            <?php 
        $pricetext = "";
        if ($prod->rule_discount > 0) {
            $pricetext = "IDR " . idr($prod->SellingPrice);
        }
        ?>
            <div class="priceprod priceprod_small"><?php 
        echo $pricetext;
        ?>
</div>
            <div class="priceprod">IDR <?php 
        echo idr($prod->final_price);
        ?>
</div>
            <div class="traditional_add">
                <a class="add" data-toggle="modal" data-variant="<?php 
        echo $prod->VariantID;
        ?>
"
                   data-url="<?php 
        echo _SPPATH;
        ?>
pr/p/<?php 
        echo $prod->VariantID;
        ?>
/<?php 
        echo ProductAtCategory::bersihkanNama($prod->BaseArticleNameENG);
        ?>
"
                   data-imgUrl="<?php 
        echo $imgurl;
        ?>
"
                   data-articlename="<?php 
        echo $prod->BaseArticleNameENG;
        ?>
"
                   data-target="#myModal" style="cursor: pointer; font-size: 20px; padding: 10px;">ADD TO BAG</a>
            </div>
            <div class="pemesanan" style="display: none;">
                <div style="float: left;">
                <table class="qtyvar">
                    <tr>
                        <td>Quantity</td>
<!--                        <td>Varian</td>-->
                    </tr>
                    <tr>
                        <td>
                        <select class="form-control">
                            <?php 
        for ($x = 1; $x < 10; $x++) {
            ?>
                                <option value="<?php 
            echo $x;
            ?>
"><?php 
            echo $x;
            ?>
</option>
                            <?php 
        }
        ?>
                        </select>
                        </td>
                        <td>
<!--                            <select class="form-control">-->
<!--                                <option value="">Varian 1</option>-->
<!--                                <option value="">Varian 2</option>-->
<!--                            </select>-->
                        </td>
                    </tr>
                </table>
                </div>
                <div style="margin-left: 220px;">
                    <div class="addbut">

                    </div>
                </div>
                <div class="clearfix"></div>
            </div>

        </div>

        <div class="clearfix"></div>

        <style>
            table.qtyvar td{
                padding: 5px;
            }
            .pemesanan{
                border: 1px solid #cccccc;
                background-color: #efefef;
                padding: 10px;
            }
            .addbut{
                background-color: #e2007a;
                color: #FFFFFF;
                padding: 10px;
                font-size: 19px;
                font-weight: bold;
                text-align: center;
                margin-top: 15px;
                width: 190px;
            }

            .priceprod{
                color: #e2007a;
                font-size: 37px;
                font-weight: bold;
                /*margin-top: 20px;*/
                margin-bottom: 20px;
            }
            .priceprod_small{
                font-size: 15px;
                margin-top: 20px;
                text-decoration: line-through;
                margin-bottom: 0px;
            }
            .imgstamp{
                position: absolute;
                width: 60px;
                /*height: 50px;*/
                overflow: hidden;
                opacity: 0.6;
            }
            div.imgstamp img{
                /*min-width: 100% !important;*/
                /*min-height: 100% !important;*/
            }
        </style>
        <div class="col-md-10 col-md-offset-1" style="margin-top: 40px;" >
            <ul class="nav nav-tabs nav-justified">
                <li class="active"><a data-toggle="tab" href="#review">REVIEW</a></li>
                <li><a data-toggle="tab" href="#ingredients">INGREDIENTS</a></li>
                <li><a data-toggle="tab" href="#howtouse">HOW TO USE</a></li>
                <li><a data-toggle="tab" href="#whatsinside">WHATS INSIDE</a></li>
            </ul>
            <div class="tab-content isilain">
                <div id="review" class="tab-pane fade in active dalaman">
                    <div class="review_item">
                        <div class="col-md-3">
                        <div class="review_username">Jeanne Schroeder</div>
                        <div class="review_star"><img src="http://thebodyshop.ugc.bazaarvoice.com/6097-en_gb/4_0/5/rating.gif" class="BVImgOrSprite" alt="4 / 5" title="4 / 5"></div>
                        </div>
                        <div class="col-md-9">
                            <div class="review_date">20 January 2016</div>
                        <div class="review_text">
                            <div class="review_title">GOOD BUY</div>
                            I'm a natural sister. Recently did the big chop so my hair is completely natural no relaxed ends and its very coarse and doesn't exactly have a curl pattern. For other natural girls I'd say I'm a 4C (4D really lool) in regards of hair texture. Through my transition i noticed that my scalp is very dry, itchy and flaky even after washing it a day or 2 later it'll flake up. I've tried nizoral shampoo recommended by a friend which is also good for dry & itchy scalp however i felt it left my feeling hard afterwards plus its like £6 for a very small bottle. I'm a lover of all things body shop so when i saw this I'd thought I'd give it a go. It smells great it feels my hair feeling soft and scalp free from flaking. I had a lil flaking a few days after so i applied oil to my scalp as normal to defuse it. i've used this shampoo twice now and the second time round it definietly had a better affect so after 3 months or so i can only imagine my scalp would have improved
                        </div>
                        </div>
                        <div class="clearfix"></div>
                    </div>
                    <div class="review_item noborder" style="margin-top: 20px;">
                        <div class="col-md-3">
                            <div class="review_username">Michelle Stark</div>
                            <div class="review_star"><img src="http://thebodyshop.ugc.bazaarvoice.com/6097-en_gb/4_0/5/rating.gif" class="BVImgOrSprite" alt="4 / 5" title="4 / 5"></div>
                        </div>
                        <div class="col-md-9">
                            <div class="review_date">7 January 2016</div>
                            <div class="review_text">
                                <div class="review_title">LIFE CHANGER!</div>
                                My son (aged 11 and an early developer, I think this is why he started with his scalp problem) is over the moon as am I. We tried everything from Leading Anti-Dandruff Brands to home remedies. This worked after the first use and his scalp was clear after the second use. This is the only shampoo he can use as it helps to keep his sore flaking scalp under control. He uses it 3 times a week and has no flakes or red sores/itching. Highly recommend.
                                <br><br>Downside: There are chemicals like SLS in it which I know cause flakes/eczema etc, but seeing as it is the only shampoo that keeps his head clear we will continue to use it.

                            </div>
                        </div>
                        <div class="clearfix"></div>
                    </div>
                </div>
                <div id="ingredients" class="tab-pane fade dalaman">
                    <?php 
        echo $prod->IngredientENG;
        ?>
                </div>
                <div id="howtouse" class="tab-pane fade dalaman">
                    <?php 
        echo $prod->HowToUseENG;
        ?>
                </div>
                <div id="whatsinside" class="tab-pane fade dalaman">
                    <?php 
        echo $prod->WhatInsideENG;
        ?>
                </div>
            </div>
        </div>
        <style>
            .review_item{
                border-bottom: 1px dotted #cccccc;
                padding-bottom: 20px;
            }
            .review_username{
                font-weight: bold;
            }
            .review_title{
                font-weight: bold;
                margin-bottom: 20px;
                font-size: 15px;
            }
            .review_date{
                text-align: right;
                font-size: 11px;
                color: #888888;
                float: right;
            }
            .isilain{
                /*background-color: #efefef;*/
                border: 1px solid #dddddd;
                border-top: 0px;
            }
            .isilain h3{
                padding: 0;
                margin: 0;

            }
            .dalaman{
                padding: 20px;
            }
            .nav-tabs li{
                background-color: #efefef;
                border-right: 1px solid #FFFFFF;
            }
            .nav-tabs li a{
                color: #7FB719;
            }
            .nav-tabs li.active a{
                font-weight: bold;
                color: #999999;
            }
        </style>
        <div class="clearfix"></div>
        <?php 
        $at = new LL_ArticleTagging_wbase();
        $ats = $at->getWhereFromMultipleTable("BaseArticleID = '{$prod->BaseArticleID}' AND TaggingLevel3ID = cat_id", array("MProdCat"));
        //        pr($ats);
        if (count($ats) > 0) {
            ?>
            <div class="col-md-10 col-md-offset-1" style="margin-top: 20px;">
                Similar Categories : <?php 
            foreach ($ats as $cat) {
                ?>
                    <span class="category"><a class="discover"
                                              href="<?php 
                echo _SPPATH;
                ?>
pr/w3/<?php 
                echo $cat->cat_id;
                ?>
/<?php 
                echo $cat->cat_name;
                ?>
"><?php 
                echo $cat->cat_name;
                ?>
</a> </span> &nbsp;
                    <?php 
                $impcat[] = "TaggingLevel3ID = '{$cat->cat_id}'";
            }
            $queryImp = implode(" OR ", $impcat);
            $atprod = $at->getWhereFromMultipleTable("(" . $queryImp . ") AND ArticleType = 'Base' AND {$prod->table_name}.VariantID != '{$id}' AND {$at->table_name}.BaseArticleID = {$prod->table_name}.BaseArticleID LIMIT 0,12", array("MProdModel"));
            $atprod = array_reverse($atprod);
            //                            pr($atprod);
            $sudahCarousel = array();
            foreach ($atprod as $atss) {
                if (!in_array($atss->VariantID, $sudahCarousel)) {
                    $sudahCarousel[] = $atss->VariantID;
                    $masukan[] = $atss;
                }
            }
            $atprod = $masukan;
            if (count($atprod) > 0) {
                ?>


                <div class="recommended_items"
                     style="margin-top: 10px; border:1px dashed #cccccc; padding-right: 10px; padding-left: 10px; margin-bottom: 30px;">
                    <!--recommended_items-->

                    <div id="recommended-item-carousel" class="carousel slide" data-ride="carousel">
                        <div class="carousel-inner" style="padding: 20px;">
                            <?php 
                $cnt = count($atprod);
                $page = ceil($cnt / 4);
                for ($x = 1; $x <= $page; $x++) {
                    ?>
                                <div class="item <?php 
                    if ($x == 1) {
                        echo "active";
                    }
                    ?>
">
                                    <?php 
                    for ($y = 0; $y < 4; $y++) {
                        if (count($atprod) > 0) {
                            $atss = array_pop($atprod);
                            //durchlaufen disini ..thd rule
                            if (count($rules2variant[$atss->VariantID]) > 0) {
                                $uu = $rules2variant[$atss->VariantID];
                                //set icon
                                $atss->rule_icon = _SPPATH . _PHOTOURL . $rules[$uu[0]]->rule_icon;
                                //                            pr($uu);
                                //diskon
                                $diskon = 0;
                                foreach ($uu as $ruleygkena) {
                                    $r = $rules[$ruleygkena];
                                    $diskon = max($r->rule_discount, $diskon);
                                }
                                $atss->rule_discount = $diskon;
                            } else {
                                $atss->rule_icon = "";
                                //default rule icon
                                $atss->rule_discount = 0;
                            }
                            $atss->final_price = (100 - $atss->rule_discount) / 100 * $atss->SellingPrice;
                            $pc = new ProductAtCategory();
                            $imgurl = $pc->imgURL . $atss->BaseArticleImageFile;
                            if ($atss->BaseArticleImageFile == "") {
                                $atss = $pc->noimage;
                            }
                            ?>
                                            <div class="prod-item col-md-3 col-sm-6 col-xs-6">

                                                <a href="<?php 
                            echo _SPPATH;
                            ?>
pr/p/<?php 
                            echo $atss->VariantID;
                            ?>
/<?php 
                            echo ProductAtCategory::bersihkanNama($atss->BaseArticleNameINA);
                            ?>
">
                                                    <?php 
                            if ($atss->rule_icon != "") {
                                ?>
                                                        <div class="imgstamp_ole">
                                                            <img src="<?php 
                                echo $atss->rule_icon;
                                ?>
" width="60px">
                                                        </div>
                                                    <?php 
                            }
                            ?>
                                                    <div class="product_list_item_img2">
                                                    <img
                                                        src="<?php 
                            echo $imgurl;
                            ?>
"
                                                        >
                                                    </div>
                                                </a>
                                                <b class="elips"><a
                                                        href="<?php 
                            echo _SPPATH;
                            ?>
pr/p/<?php 
                            echo $atss->VariantID;
                            ?>
/<?php 
                            echo ProductAtCategory::bersihkanNama($atss->BaseArticleNameINA);
                            ?>
">
                                                        <?php 
                            echo $atss->BaseArticleNameINA;
                            ?>
</a></b>

                                                <!--                                <p class="elips">-->
                                                <?php 
                            //=$atss->ArticleInfoENG;
                            ?>
<!--</p>-->

                                                <!--                                <div class="rating">-->
                                                <!--                                    <div class="rating">-->
                                                <!--                                        <span>☆</span><span>☆</span><span>☆</span><span>☆</span><span>☆</span>-->
                                                <!--                                    </div>-->
                                                <!---->
                                                <!--                                </div>-->
                                                <?php 
                            //pr($obj);
                            if ($atss->rule_discount > 0) {
                                ?>
                                                    <div class="item_price item_price_small">
                                                        IDR <?php 
                                echo idr($atss->SellingPrice);
                                ?>
</div>
                                                    <div class="item_price">IDR <?php 
                                echo idr($atss->final_price);
                                ?>
</div>
                                                <?php 
                            } else {
                                ?>
                                                    <div class="item_price item_price_small"></div>
                                                    <div class="item_price">IDR <?php 
                                echo idr($atss->final_price);
                                ?>
</div>
                                                <?php 
                            }
                            ?>

                                                <a class="discover_more"
                                                   href="<?php 
                            echo _SPPATH;
                            ?>
pr/p/<?php 
                            echo $atss->VariantID;
                            ?>
/<?php 
                            echo ProductAtCategory::bersihkanNama($atss->BaseArticleNameINA);
                            ?>
">Discover
                                                    More</a>
                                            </div>
                                        <?php 
                        }
                        ?>
                                    <?php 
                    }
                    ?>

                                </div>
                            <?php 
                }
                ?>


                        </div>
                        <a class="left recommended-item-control" href="#recommended-item-carousel" data-slide="prev">
                            <i class="glyphicon glyphicon-chevron-left"></i>
                        </a>
                        <a class="right recommended-item-control" href="#recommended-item-carousel" data-slide="next">
                            <i class="glyphicon glyphicon-chevron-right"></i>
                        </a>
                    </div>
                </div>
                <?php 
            }
            ?>
                <div class="clearfix"></div>


            </div>
            <style>
                .elips {

                    /*font-weight: bold;*/
                    color: #777777;
                    height: 40px;
                    text-overflow: ellipsis;
                    margin-top: 10px;
                    overflow: hidden;
                    /*white-space:nowrap;*/
                    display: -webkit-box;
                    -webkit-line-clamp: 2;
                    -webkit-box-orient: vertical;
                    text-align: center;
                }
                .product_list_item_img2 {
                    width: 100%;
                    height: 147px;
                    overflow: hidden;
                    margin: auto;
                    text-align: center;
                }

                .product_list_item_img2 img {
                    max-width: 100%;
                    max-height: 100%;
                }
                .elips a {
                    color: #666666;
                }

                .recommended-item-control {
                    position: absolute;
                    top: 41%;
                }

                .left {
                    left: 0;
                }

                .right {
                    right: 0;
                }

                .discover {
                    color: #e2007a;
                }

                .imgstamp_ole {
                    position: absolute;
                    width: 60px;
                    height: 60px;
                    overflow: hidden;
                }

                div.imgstamp_ole img {
                    min-width: 60px;
                    min-height: 60px;
                }

                .item_price {
                    color: #e2007a;
                    font-size: 25px;
                }

                .item_price_small {
                    text-decoration: line-through;
                    font-size: 13px;
                    height: 18px;
                }

                .discover_more {
                    color: #666666;
                    text-decoration: underline;
                    font-size: 12px;
                }
            </style>
        <?php 
        }
        //        pr($prod);
    }
 function search()
 {
     $q = addslashes($_GET['qsearch']);
     //        echo $q;
     $n = new MProdModel();
     $m = new MArticleTagging();
     $z = new MProdCat();
     $tambahan = "({$n->table_name}.BaseArticleNameENG LIKE '%{$q}%' OR {$n->table_name}.VariantNameENG LIKE '%{$q}%'  OR {$n->table_name}.VariantID LIKE '%{$q}%')";
     $arrN = $n->getWhereFromMultipleTable("{$n->table_name}.BaseArticleID = ecommultiple__articletagging.BaseArticleID AND {$tambahan}", array("MArticleTagging"));
     //        pr($arrN);
     $obj = new Pr();
     $obj->results = $arrN;
     ProductAtCategory::printer($obj, "", "", "", "", 3);
     MSearchLog::saveSLog($q);
 }