$sem[$ss->VariantID]->TaggingLevel3ID .= " " . $ss->TaggingLevel3ID; } } \Leap\View\InputConditionTBS::printer($sem); } if ($action == "2") { $n = new \MProdModel(); $m = new MArticleTagging(); $z = new MProdCat(); $mode = "all"; if ($mode == "all") { $n->default_read_coloms = "*"; $arrN = $n->getAll(); } else { if ($mode == "filter1") { $arrN = $n->getWhereFromMultipleTable("{$n->table_name}.BaseArticleID = ecommultiple__articletagging.BaseArticleID", array("MArticleTagging")); } else { $arrN = $n->getWhereFromMultipleTable("{$n->table_name}.BaseArticleID = ecommultiple__articletagging.BaseArticleID AND ecommultiple__articletagging.TaggingLevel3ID = ecommultiple__product_category.cat_id", array("MArticleTagging", "MProdCat")); } } $sudah = array(); $num = 0; $bisa = 0; foreach ($arrN as $ss) { if (!in_array($ss->VariantID, $sudah)) { $sudah[] = $ss->VariantID; // $arr = $z->getWhere("cat_id = '".$ss->TaggingLevel3ID."'"); // $ss->tagging = $arr; if ($mode == "all") { $arr = $m->getWhere("BaseArticleID = '" . $ss->BaseArticleID . "'"); // pr($arr);
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); }