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);
}
