public function inputProduct()
{
$myapp_id = AppAccount::getAppID();
if ($myapp_id == "" || $myapp_id < 1) {
die("Not valid App ID");
}
$cam = new MCampaignModel();
$arrCam = $cam->getWhere("camp_app_id = '{$myapp_id}' ");
$prod = new MProdModel();
$arrProd = $prod->getWhere("prod_app_id = '{$myapp_id}' ");
$_SESSION['arrProd'] = $arrProd;
?>
<div class="input-group">
<span class="input-group-addon" id="basic-addon1">Select Campaign :</span>
<select class="form-control" onchange="getMatrix();" id="camp_select">
<option value=""></option>
<?php
foreach ($arrCam as $c) {
?>
<option value="<?php
echo $c->camp_id;
?>
"><?php
echo $c->camp_name;
?>
</option>
<?php
}
?>
</select>
</div><!-- /input-group -->
<div id="camp_matrix" style="padding-top: 20px;">
</div>
<script>
function getMatrix(){
var slc = $("#camp_select").val();
if(slc!="")
$("#camp_matrix").load("<?php
echo _SPPATH;
?>
MCampApp/getMatrix?cid="+slc);
}
</script>
<style>
.productcamp{
background-color: #dedede;
margin: 5px;
padding: 5px;
}
</style>
<?php
//pr($arrProd);
}
public function p()
{
$t = time() . rand(1, 100);
$id = $this->id . "attrib_" . $t;
// echo $id;
$exp = explode(",", $this->value);
$llimit = count($exp);
if ($llimit < 1) {
$llimit = 0;
}
?>
<input type="text" name="<?php
echo $this->name;
?>
" id="<?php
echo $this->id;
?>
_<?php
echo $t;
?>
" class="<?php
echo $this->id;
?>
" value="<?php
echo $this->value;
?>
">
<div class="attribute_adder">
<div id="submitter_<?php
echo $id;
?>
" style="padding: 10px; text-align: right; float: right;">
<!-- <button id="butsave_--><?php
//=$id;
?>
<!--" type="button" class="btn btn-default">Save Attributes</button>-->
<button id="but_<?php
echo $id;
?>
" type="button" class="btn btn-default">Add Attribute </button>
</div>
<div id="attbox_<?php
echo $id;
?>
">
</div>
</div>
<div id="allprod" style="display: none; background-color: #FFFFFF; padding: 10px;">
<div style="float: right; width: 10px; height: 10px;" onclick="$('#allprod').hide();">x</div>
<?php
$n = new \MProdModel();
$arrN = $n->getOrderBy("VariantID ASC");
self::printer($arrN);
?>
</div>
<script>
var featSudah = [];
var opt_<?php
echo $id;
?>
= [
'<option value="all">all</option>',
// '<option value="price">Price</option>',
'<option value="variantID">VariantID</option>',
'<option value="baseID">BaseID</option>',
'<option value="category">Category</option>'
];
var optcommand_<?php
echo $id;
?>
= [
'variantID',
'baseID',
'category'
];
var opt2a_<?php
echo $id;
?>
= [
'<option value=""></option>',
'<option value="=">=</option>',
'<option value=">">></option>',
'<option value=">=<">>=</option>',
'<option value="=<">=<</option>',
'<option value="<"><</option>'
];
var opt2b_<?php
echo $id;
?>
= [
'<option value=""></option>',
'<option value="is">is one of</option>',
'<option value="is_not">is not one of</option>'
];
var opt3a_<?php
echo $id;
?>
= '<input type="number" id="span3">';
var attr_<?php
echo $id;
?>
= [];
var attrnr_<?php
echo $id;
?>
= <?php
echo $llimit;
?>
;
<?php
if ($llimit > 0) {
?>
//create attributes
<?php
foreach ($exp as $num => $ee) {
$exp2 = explode(";", $ee);
$option1 = $exp2[0];
$option2 = $exp2[1];
$option3 = $exp2[1];
?>
createAttr<?php
echo $id;
?>
('<?php
echo $num;
?>
','<?php
echo $option1;
?>
','<?php
echo $option2;
?>
','<?php
echo $option3;
?>
');
<?php
}
//foreach
?>
function createAttr<?php
echo $id;
?>
(lokalid,option1,option2,option3){
var selecttext = '';
for(var x=0;x<opt_<?php
echo $id;
?>
.length;x++){
selecttext += opt_<?php
echo $id;
?>
[x];
}
var text2 = "<div class='condition form-inline'><select class='form-control' id='select1_"+lokalid+"' onchange='updateSpan2(\""+lokalid+"\");'>"+selecttext+"</select><span id='span2_"+lokalid+"'></span><span id='span3_"+lokalid+"'></span></div>";
$("#attbox_<?php
echo $id;
?>
").append(text2);
$("#submitter_<?php
echo $id;
?>
").show();
}
<?php
}
?>
function updateSpan2(lokalid){
var slc = $('#select1_'+lokalid).val();
activeLokalID = lokalid;
var selecttext = '';
if(slc == "all"){
$('#span2_'+lokalid).html('');
$('#span3_'+lokalid).html('');
return "";
}
else if(slc == "price"){
for(var x=0;x<opt2a_<?php
echo $id;
?>
.length;x++){
selecttext += opt2a_<?php
echo $id;
?>
[x];
}
featSudah.push(slc);
}else{
for(var x=0;x<opt2b_<?php
echo $id;
?>
.length;x++){
selecttext += opt2b_<?php
echo $id;
?>
[x];
}
featSudah.push(slc);
}
$('#span3_'+lokalid).html('');
$('#span2_'+lokalid).html("<select class='form-control' id='select2_"+lokalid+"' onchange='updateSpan3(\""+lokalid+"\");'>"+selecttext+"</select>");
}
var activeLokalID = 0;
function updateSpan3(lokalid){
var slc2 = $('#select1_'+lokalid).val();
var slc = $('#select2_'+lokalid).val();
activeLokalID = lokalid;
// $('#span3_'+lokalid).html(slc);
var selecttext = '';
if(slc2 == "price"){
$('#span3_'+lokalid).html('<input onchange="updateHiddenCondition();" class="form-control" type="number" id="isi_span3_'+lokalid+'">');
}else{
/// load from database....
if(slc2 == "variantID"){
//uncheck all checkbox
$('.variant_check').prop("checked",false);
checkedVariant = [];
$('#allprod').show();
html = "<input type='text' class='form-control' id='isi_span3_"+lokalid+"'>";
}
if(slc2 == "baseID"){
<?php
$n = new \MProdModel();
$arrN = $n->getWhere("ArticleType = 'Base' ORDER BY BaseArticleID ASC");
$cc = '';
foreach ($arrN as $num => $nn) {
$cc .= "<input type='checkbox'>" . $num . ". " . $nn->BaseArticleID . " " . $nn->BaseArticleNameENG . "<br>";
}
?>
var html = "<?php
echo $cc;
?>
";
}
if(slc2 == "category"){
<?php
$n = new \MProdCat();
$arrN = $n->getWhere("cat_parent_id != '-1' ORDER BY cat_name ASC");
$cc = '';
foreach ($arrN as $num => $nn) {
$cc .= "<input type='checkbox'>" . $num . ". " . $nn->cat_id . " " . $nn->cat_name . "<br>";
}
?>
var html = "<?php
echo $cc;
?>
";
}
$('#span3_'+lokalid).html(html);
}
}
$("#but_<?php
echo $id;
?>
").click(function(){
var lokalid = attrnr_<?php
echo $id;
?>
;
// var text = "<div class='attr_box'>Attr Name : <input id='attrtext_<?php
//=$id;
?>
//_"+lokalid+"' type='text'> Stok : <input id='attrstok_<?php
//=$id;
?>
//_"+lokalid+"' type='number'></div>";
var selecttext = '';
for(var x=0;x<opt_<?php
echo $id;
?>
.length;x++){
if(jQuery.inArray( optcommand_<?php
echo $id;
?>
[x], featSudah ) !== -1){
continue;
}
selecttext += opt_<?php
echo $id;
?>
[x];
}
var text2 = "<div class='condition form-inline'><select class='form-control' id='select1_"+lokalid+"' onchange='updateSpan2(\""+lokalid+"\");'>"+selecttext+"</select><span id='span2_"+lokalid+"'></span><span id='span3_"+lokalid+"'></span></div>";
$("#attbox_<?php
echo $id;
?>
").append(text2);
$("#submitter_<?php
echo $id;
?>
").show();
attrnr_<?php
echo $id;
?>
++;
});
// $("#butsave_<?php
//=$id;
?>
//").click(function(){
//
// updateHiddenCondition();
//// alert(energy);
//
//// $("#<?php
////=$this->totalstock_id;
?>
////").val(totalstok);
// });
function updateHiddenCondition(){
var gab = [];
var totalstok = 0;
// alert(attrnr_<?php
//=$id;
?>
//);
//parsing all the inputs
for(var x = 0;x<attrnr_<?php
echo $id;
?>
;x++){
// alert(x);
var isi3 = $("#isi_span3_"+x).val();
var isi2 = $("#select2_"+x).val();
var isi1 = $("#select1_"+x).val();
if(isi1=="" || isi2 =="" || isi3 == ""){
//error1
alert("Missing Attributes ");
}
else {
gab.push(isi1+";"+isi2+";"+isi3);
}
}
var energy = gab.join("|");
$("#<?php
echo $this->id;
?>
_<?php
echo $t;
?>
").val(energy);
}
</script>
<style>
.condition{
padding: 5px;
}
</style>
<?php
}
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
}
