public function getItems()
{
// $ids = addslashes($_GET['ids']);
// if($ids==""){
// $json['status_code'] = 0;
// $json['status_message'] = "ID Not Found";
// echo json_encode($json);
// die();
// }
// $exp = explode(",",$ids);
// foreach($exp as $sss){
// $str[] = "ll__articletagging_with_base.TaggingLevel3ID = '$sss'";
// }
// $imp = implode(" OR ",$str);
$basetext = "";
if ($_GET['type'] == "base") {
$basetext = "AND ll__article_with_image.ArticleType = 'Base'";
}
$ll = new LL_ArticleTagging_wbase();
// $whereClause = "ll__articletagging_with_base.BaseArticleID = ll__article_with_image.BaseArticleID $basetext AND ( $imp )";
//echo $whereClause;
$whereClause = "ll__articletagging_with_base.BaseArticleID = ll__article_with_image.BaseArticleID {$basetext} ";
$arr = $ll->getWhereFromMultipleTable($whereClause, array("LL_Article_WImage"), "*");
//pr($arr);
//$arr2 = $ll->getWhere("ll__articletagging.TaggingLevel3ID = '$id'");
//pr($arr2);
$obj2 = new LL_Article_WImage();
$exp2 = explode(",", $obj2->crud_webservice_allowed);
$obj = $ll;
$obj->default_read_coloms = $obj->crud_webservice_allowed;
$main_id = $obj->main_id;
$exp = explode(",", $obj->crud_webservice_allowed);
$json = array();
$json['status_code'] = 1;
//filter
foreach ($arr as $o) {
$sem = array();
foreach ($exp as $attr) {
$sem[$attr] = $o->{$attr};
foreach ($exp2 as $attr2) {
$sem[$attr2] = $o->{$attr2};
}
}
$json["results"][] = $sem;
}
if ($_GET['type'] == "base" && $_GET['getvar'] == 1) {
$arrsem = array();
foreach ($json['results'] as $base) {
$baseID = $base['BaseArticleID'];
$arr5 = $obj2->getWhere("BaseArticleID = '{$baseID}'");
foreach ($arr5 as $o) {
$sem = array();
foreach ($exp2 as $attr2) {
$sem[$attr2] = $o->{$attr2};
}
$base['variants'][] = $sem;
}
$arrsem[] = $base;
}
$json['results'] = $arrsem;
}
if (count($arr) < 1) {
$json['status_code'] = 0;
$json['status_message'] = "No Elements Found";
}
echo json_encode($json);
die;
}
function articletaggingWBase()
{
$LL = new LL_ArticleTagging_wbase();
//$LL->printColumlistAsAttributes();
if ($_GET['truncate']) {
$LL->truncate();
}
// $url = "http://192.168.0.86:8180/goldwebapi/ecommerce/articletagging";
// $url = "http://192.168.0.86:8880/goldwebapi/ecommerce/articletagging";
$url = $this->ip_address . "GOLDEcomm/ArticleTagging";
$data = file_get_contents($url);
$data = json_decode($data, true);
// Turns it into an array, change the last argument to false to make it an ob
//pr($data);
$counter = 0;
$yangdisave = 0;
foreach ($data as $ro) {
$ll = new LL_ArticleTagging_wbase();
$ll->fill($ro);
$ll->rel_id = $ro['BaseArticleID'] . "_" . $ro['TaggingLevel3ID'];
if ($ll->save()) {
echo $ll->rel_id . "<br>";
$yangdisave++;
}
$counter++;
//pr($ll);
}
echo "Jumlah yang di crawl : " . $counter . "<br>";
echo "Jumlah yang di save : " . $yangdisave . "<br>";
}
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"> </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>
<?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);
}
