if ($search) {
$search .= ' and (`' . global_mapping::ProductName . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\' or `' . global_mapping::Description . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\')';
} else {
$search .= '(`' . global_mapping::ProductName . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\' or `' . global_mapping::Description . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\')';
}
}
if ($manu) {
if ($search) {
$search .= ' and (`' . global_mapping::ManufactoryID . '` = ' . global_common::escape_mysql_string($manu) . ')';
} else {
$search .= '(`' . global_mapping::ManufactoryID . '` = ' . global_common::escape_mysql_string($manu) . ')';
}
}
$products = $objProduct->getAllProduct(0, '*', $search, null);
$productIDs = global_common::getArrayColumn($products, global_mapping::ProductID);
$allManuFactories = $objManufactory->getAllManufactory(0);
//print_r($productIDs);
//if($expired)
//{
// $condidtion = ' And '.global_mapping::EndDate.' < \''.global_common::nowDateSQL().'\'';
//}
//else
//{
// $condidtion = ' And '.global_mapping::StartDate.' <= \''.global_common::nowDateSQL().'\''.' And '.global_mapping::EndDate.' >= \''.global_common::nowDateSQL().'\'';
//}
$inactive = $_pgR["inactive"];
$status = $inactive ? 0 : 1;
$type = $_pgR["type"];
$city = $_pgR['ct'];
$allRetailers = $objRetailer->getRetailerByProducts($page, $productIDs, $type, $city, $status, $total);
//print_r($allRetailers);
$arrHeader = global_common::getMessageHeaderArr($banCode);
//$banCode
echo global_common::convertToXML($arrHeader, array("rs", "inf"), array(1, ($status ? 'Xóa' : 'Deactivate') . ' thành công'), array(0, 1));
return;
} else {
echo global_common::convertToXML($arrHeader, array("rs", "inf"), array(0, ($isActivate ? 'Xóa' : 'Deactivate') . ' unsuccessfully'), array(0, 1));
return;
}
}
$catID = $_pgR["cid"];
//$page = $_pgR["p"];
if ($catID) {
$searchGroup = global_mapping::CategoryID . '= \'' . $catID . '\'';
}
//show all Manu, not paging
$allManus = $objManufactory->getAllManufactory(0, '', $searchGroup, '');
$_SESSION[global_common::SES_C_CUR_PAGE] = "admin/admin_manufactory.php";
include_once 'include/_admin_header.inc';
?>
<script type="text/javascript" src="<?php
echo $_objSystem->locateJs('user_manufactory.js');
?>
"></script>
<div id="admin-manufactory" class="admin-page">
<div class="row-fluid">
<div class="span12">
<!-- BEGIN PAGE TITLE & BREADCRUMB-->
<h3 class="page-title">
Manage Manufactory
</h3>
</div>
include_once 'include/_permission.inc';
include_once 'include/_header.inc';
include_once 'class/model_articletype.php';
include_once 'class/model_user.php';
include_once 'class/model_product.php';
include_once 'class/model_manufactory.php';
$objArticleType = new Model_ArticleType($objConnection);
$objManufactory = new Model_Manufactory($objConnection);
$objProduct = new Model_Product($objConnection);
$intMode = 0;
//add mode
$parentTypes = $objArticleType->getAllArticleType(0, null, 'ParentID=0', 'Level');
$allTypes = $objArticleType->getAllArticleType(0, null, 'ParentID!=0', 'Level');
//set default selected section
$currentParentType = $parentTypes[0][global_mapping::ArticleTypeID];
$allManuFactories = $objManufactory->getAllManufactory(0, '*', '', global_mapping::ManufactoryName);
$cmArea = $_pgR["cmArea"];
$cmCategory = $_pgR["cmCategory"];
$cmManufactory = $_pgR["cmManufactory"];
$txtKeyword = $_pgR["txtKeyword"];
$lastPage = '';
$condition = '(' . global_mapping::IsDeleted . ' IS NULL or ' . global_mapping::IsDeleted . ' = \'0\') ';
if ($_pgR["pid"]) {
$preferProduct = $objProduct->getProductByID($_pgR["pid"]);
$preferedCat = $objArticleType->getArticleTypeByID($preferProduct[global_mapping::CatalogueID]);
$cmArea = $preferedCat[global_mapping::ParentID];
$cmCategory = $preferedCat[global_mapping::ArticleTypeID];
$cmManufactory = $preferProduct[global_mapping::ManufactoryID];
$txtKeyword = $preferProduct[global_mapping::ProductName];
}
if ($cmArea) {
public function getAllProduct($intPage = 0, $selectField = '*', $whereClause = '', $orderBy = '', &$total)
{
if ($whereClause) {
$whereClause = ' WHERE ' . $whereClause;
}
if ($orderBy) {
$orderBy = ' ORDER BY ' . $orderBy;
}
if ($intPage > 0) {
$strSQL = global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_Product::TBL_SL_PRODUCT, $whereClause . $orderBy . ' limit ' . ($intPage - 1) * self::NUM_PER_PAGE . ',' . self::NUM_PER_PAGE));
$strSQLCount = global_common::prepareQuery(global_common::SQL_SELECT_FREE, array('count(*)', Model_Product::TBL_SL_PRODUCT, $whereClause . $orderBy));
} else {
$strSQL = global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_Product::TBL_SL_PRODUCT, $whereClause . $orderBy));
}
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get All sl_product:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
//echo '<br>$strSQLCount:'.$strSQLCount;
if ($strSQLCount) {
$arrTotal = $this->_objConnection->selectCommand($strSQLCount);
$total = $arrTotal[0][0];
}
$objManu = new Model_Manufactory($this->_objConnection);
$objArticleType = new Model_ArticleType($this->_objConnection);
$allManus = $objManu->getAllManufactory();
$allCats = $objArticleType->getAllArticleType();
$manus = array();
foreach ($allManus as $key => $info) {
$manus[$info[global_mapping::ManufactoryID]] = $info;
unset($allManus[$key]);
}
$cats = array();
foreach ($allCats as $key => $info) {
$cats[$info[global_mapping::ArticleTypeID]] = $info;
unset($allCats[$key]);
}
$count = count($arrResult);
for ($index = 0; $index < $count; $index++) {
if ($manus[$arrResult[$index][global_mapping::ManufactoryID]]) {
$arrResult[$index][global_mapping::ManufactoryName] = $manus[$arrResult[$index][global_mapping::ManufactoryID]][global_mapping::ManufactoryName];
}
if ($cats[$arrResult[$index][global_mapping::CatalogueID]]) {
$arrResult[$index][global_mapping::ArticleTypeName] = $cats[$arrResult[$index][global_mapping::CatalogueID]][global_mapping::ArticleTypeName];
}
}
$arrResult = global_common::mergeUserInfo($arrResult, $this->_objConnection);
//print_r($arrResult);
return $arrResult;
}
