static function saveSLog($word) { $sl = new MSearchLog(); $sl->slog_keyword = $word; $sl->slog_date = leap_mysqldate(); $sl->save(); }
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 }
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); }