$companyAddress = html_entity_decode($_pgR[global_mapping::CompanyAddress], ENT_COMPAT, 'UTF-8');
$companyWebsite = html_entity_decode($_pgR[global_mapping::CompanyWebsite], ENT_COMPAT, 'UTF-8');
$companyPhone = html_entity_decode($_pgR[global_mapping::CompanyPhone], ENT_COMPAT, 'UTF-8');
$adType = html_entity_decode($_pgR[global_mapping::AdType], ENT_COMPAT, 'UTF-8');
$startDate = html_entity_decode($_pgR[global_mapping::StartDate], ENT_COMPAT, 'UTF-8');
$endDate = html_entity_decode($_pgR[global_mapping::EndDate], ENT_COMPAT, 'UTF-8');
$happyDays = html_entity_decode($_pgR[global_mapping::HappyDays], ENT_COMPAT, 'UTF-8');
$startHappyHour = html_entity_decode($_pgR[global_mapping::StartHappyHour], ENT_COMPAT, 'UTF-8');
$endHappyHour = html_entity_decode($_pgR[global_mapping::EndHappyHour], ENT_COMPAT, 'UTF-8');
$addresses = html_entity_decode($_pgR[global_mapping::Addresses], ENT_COMPAT, 'UTF-8');
$dictricts = html_entity_decode($_pgR[global_mapping::Dictricts], ENT_COMPAT, 'UTF-8');
$cities = html_entity_decode($_pgR[global_mapping::Cities], ENT_COMPAT, 'UTF-8');
$fileName = html_entity_decode($_pgR[global_mapping::FileName], ENT_COMPAT, 'UTF-8');
$status = 1;
$createdBy = $c_userInfo[global_mapping::UserID];
$arrCat = global_common::splitString($catalogueID);
$stores = $objStore->getStoreByFBID($pageID);
$arrStoreID = global_common::getArrayColumn($stores, global_mapping::StoreID);
$resultID = $objArticle->insert($title, $fileName, $content, null, $tags, $arrCat, $createdBy, $renewedNum, $companyName, $companyAddress, $companyWebsite, $companyPhone, $adType, $startDate, $endDate, $happyDays, $startHappyHour, $endHappyHour, $addresses, $dictricts, $cities, $status, $arrStoreID, $postID);
if ($resultID) {
$arrHeader = global_common::getMessageHeaderArr($banCode);
//$banCode
echo global_common::convertToXML($arrHeader, array("rs", "inf"), array(1, 'Đăng bài viết thành công'), array(0, 1));
return;
} else {
echo global_common::convertToXML($arrHeader, array("rs", "inf"), array(0, "Input data is invalid"), array(0, 1));
return;
}
}
//else
//{
/**
* Get Aticles By Type (Categories)
*
* @param mixed $articleTypeIDs This is a description
* @return mixed This is the return value description
*
*/
private function getArticleIDsByTypes($articleTypeIDs)
{
$arrTypeID = global_common::splitString($articleTypeIDs);
$strQueryIN = global_common::convertToQueryIN($arrTypeID);
$whereClause = 'WHERE ' . global_mapping::ArticleTypeID . ' IN (' . $strQueryIN . ')';
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array('*', self::TBL_SL_ARTICLE_TYPE_ID, $whereClause));
//echo $strSQL;
$articleTypes = $this->_objConnection->selectCommand($strSQL);
return global_common::getArrayColumn($articleTypes, global_mapping::ArticleID);
}
if ($createBy != $currentUserID) {
global_common::redirectByScript("index.php");
return;
}
//print_r($article[global_mapping::ArticleID]);
$currentTypes = $objArticle->getArticleTypesByID($article[global_mapping::ArticleID]);
//print_r($currentTypes);
$type = $objArticleType->getArticleTypeByID($currentTypes[0]);
$currentParentType = $type[global_mapping::ParentID];
//print_r($currentParentType);
$parentTypes = $objArticleType->getAllArticleType(0, null, 'ParentID=0', 'Level');
$allTypes = $objArticleType->getAllArticleType(0, null, 'ParentID=' . $currentParentType, 'Level');
//print_r($allTypes);
$addresses = global_common::splitString($article[global_mapping::Addresses], ';');
$districts = global_common::splitString($article[global_mapping::Dictricts], ';');
$cities = global_common::splitString($article[global_mapping::Cities], ';');
//print_r($parentTypes);
//$intPage = 1;
//$total = 0;
//$comments = $objComment->getCommentByArticle($intPage,$total,$articleID,'*','',' CreatedDate DESC');
//print_r($article);
}
?>
<script type="text/javascript" src="<?php
echo $_objSystem->locateJPlugin('ckeditor/ckeditor.js');
?>
"></script>
<script type="text/javascript" src="<?php
echo $_objSystem->locateJPlugin('ckeditor/adapters/jquery.js');
?>
public function getPropertyGroupByIDs($arrIDs)
{
$arrIDs = global_common::splitString($arrIDs);
$strQueryIN = global_common::convertToQueryIN($arrIDs);
$whereClause = 'WHERE ' . global_mapping::PropertyGroupID . ' IN (' . $strQueryIN . ')';
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array('*', self::TBL_SL_PROPERTY_GROUP, $whereClause));
//echo $strSQL;
$propertyGroups = $this->_objConnection->selectCommand($strSQL);
if (!$propertyGroups) {
global_common::writeLog('get getPropertyGroupByIDs:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
//print_r($arrResult);
return $propertyGroups;
}
/**
* lấy thông tin detail của một vài c_user,c_user_detail
*
* @param string $userList danh sách các id c_user
* @param object $objConnection connect to db
* @param string $selectField các cột sẽ lấy dữ liệu về
* @return array thông tin các user
* GiaTran
*/
private function getUserDetailByMultiTable($userList, $objConnection, $selectField = '*')
{
// build group table - optimize select query
$userList = global_common::splitString($userList);
//print_r($userList);
$arrDocInTable = array();
foreach ($userList as $key) {
$suffix = global_common::getTableSuffixByAlphabet($key);
$arrDocInTable[$suffix] .= '\'' . $key . '\',';
}
foreach ($arrDocInTable as $iDoc) {
$key = global_common::getTableSuffixByAlphabet(substr($iDoc, 1, 2));
$arrDocInTable[$key] = global_common::cutLast($iDoc, 1);
$tbName = global_common::builtTableName(Model_User::TBL_SL_USER, $key);
$selectField = '*';
$strSQL .= "(" . global_common::prepareQuery(global_common::SQL_SELECT_BY_CONDITION1, array($selectField, $tbName, '`UserID` IN (' . $arrDocInTable[$key] . ')')) . ') UNION ALL ';
}
if ($strSQL != '') {
$strSQL = substr($strSQL, 0, strlen($strSQL) - strlen(' UNION ALL '));
}
if ($selectField == '') {
$strSQL = '(select * from (' . $strSQL . ') as tbl_user)';
} else {
$strSQL = '(select ' . $selectField . ' from (' . $strSQL . ') as tbl_user)';
}
//echo $strSQL;
return $objConnection->selectCommand($strSQL);
}
/**
* This is method getTopArticleByType. For show article type list page
*
* @param mixed $listTypeID This is a description
* @param mixed $limitRow This is a description
* @param mixed $selectField This is a description
* @return mixed This is the return value description
*
*/
public function getTopArticleByType($listTypeID, $limitRow, $selectField = '*', $whereClause = '', $orderBy = '')
{
$arrTypeID = global_common::splitString($listTypeID);
$strQueryIN = global_common::convertToQueryIN($arrTypeID);
$arrSummary = global_common::getContentInfoByIDs($this->_objConnection, $strQueryIN, global_common::ARTICLE_TYPE);
//print_r($arrSummary);
if ($arrSummary == null) {
global_common::writeLog('Can not get content from table summary');
return null;
}
$strSQL = Model_Article::getSQLSelectByTableName($arrSummary, -1, $limitRow, $selectField, $whereClause, $orderBy);
$arrResult = self::getArticlesFromDB($strSQL);
//print_r($arrResult);
return $arrResult;
}
public function getRetailerByProducts($intPage, $productIds, $type, $city, $status, &$total)
{
if (!$selectField) {
$selectField = '*';
}
$arrIDs = global_common::splitString($productIds);
$strQueryIN = global_common::convertToQueryIN($arrIDs);
if ($strQueryIN) {
$strQueryIN = global_mapping::ProductID . ' IN( ' . $strQueryIN . ') and';
} else {
$strQueryIN = '1 != and';
}
if ($city) {
$city = ' and `' . global_mapping::CityID . '` = ' . $city . ' ';
} else {
$city = ' and 1=1 ';
}
if ($type) {
$type = ' and `' . global_mapping::ProductStatusID . '` = ' . $type . ' ';
} else {
$type = ' and 1=1 ';
}
if ($status) {
$status = ' (`' . global_mapping::StatusID . '` = ' . global_common::STATUS_ACTIVE . ' or `' . global_mapping::StatusID . '` is null)';
} else {
$status = ' `' . global_mapping::StatusID . '` = ' . global_common::STATUS_INACTIVE;
}
if ($intPage > 0) {
$strSQLCount = global_common::prepareQuery(global_common::SQL_SELECT_FREE, array("count(*)", self::TBL_SL_RETAILER, 'WHERE ' . $strQueryIN . $status . $type . $city));
$strSQL = global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, self::TBL_SL_RETAILER, 'WHERE ' . $strQueryIN . $status . $type . $city . $orderBy . ' limit ' . ($intPage - 1) * self::NUM_PER_PAGE . ',' . self::NUM_PER_PAGE));
} else {
$strSQL = global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, self::TBL_SL_RETAILER, 'WHERE ' . $strQueryIN . $status . $type . $city));
}
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get sl_retailer ByID:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
if ($strSQLCount) {
//echo $strSQLCount;
$arrTotal = $this->_objConnection->selectCommand($strSQLCount);
$total = $arrTotal[0][0];
}
//echo $total;
$productIDs = global_common::getArrayColumn($arrResult, global_mapping::ProductID);
//print_r($productIDs);
$productIDs = array_unique($productIDs);
$objProduct = new Model_Product($this->_objConnection);
$products = $objProduct->getProductByIDs($productIDs);
$temp = array();
foreach ($products as $key => $info) {
$temp[$info[global_mapping::ProductID]] = $info;
unset($products[$key]);
}
$products = $temp;
//print_r($products);
$objStatus = new Model_Status($this->_objConnection);
$allStatus = $objStatus->getAllStatus();
$statuses = array();
foreach ($allStatus as $key => $info) {
$statuses[$info[global_mapping::StatusID]] = $info;
unset($allStatus[$key]);
}
$count = count($arrResult);
for ($i = 0; $i < $count; $i++) {
$arrResult[$i][global_mapping::ProductStatus] = $statuses[$arrResult[$i][global_mapping::ProductStatusID]][global_mapping::StatusName];
$arrResult[$i][global_mapping::ProductName] = $products[$arrResult[$i][global_mapping::ProductID]][global_mapping::ProductName];
}
$arrResult = global_common::mergeUserInfo($arrResult, $this->_objConnection);
//print_r($arrResult);
return $arrResult;
}
public function getProductByIDs($arrIDs)
{
$arrIDs = global_common::splitString($arrIDs);
$strQueryIN = global_common::convertToQueryIN($arrIDs);
if ($strQueryIN) {
$strQueryIN = global_mapping::ProductID . ' IN (' . $strQueryIN . ')';
} else {
$strQueryIN = '1=1';
}
$whereClause = 'WHERE ' . $strQueryIN;
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array('*', self::TBL_SL_PRODUCT, $whereClause . ' '));
//echo $strSQL;
$products = $this->_objConnection->selectCommand($strSQL);
if (!$products) {
global_common::writeLog('get getProductByIDs:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
//print_r($products);
return $products;
}
public function getCommentByArticle(&$intPage, &$total, $articleID, $selectField = '*', $whereClause = '', $orderBy = '')
{
$arrSummary = global_common::getContentIDs($this->_objConnection, $intPage, $articleID, global_common::COMMENT_TYPE);
if ($arrSummary) {
if ($orderBy) {
$orderBy = ' ORDER BY ' . $orderBy;
}
$listCommentID = '';
foreach ($arrSummary as $item) {
$listCommentID = $item[global_mapping::SubContents] . $listCommentID;
}
$IDList = global_common::splitString($listCommentID);
$total = count($IDList);
$arrDocInTable = global_common::getListTableName($listCommentID, $intPage, Model_Comment::NUM_PER_PAGE, global_common::SEPARATE_BY_MONTH);
$strSQL = '';
$condition = '';
foreach ($arrDocInTable as $key => $iDoc) {
//check endWith ',' and then remove it
if (global_common::endsWith($iDoc, ',')) {
$strDocInTable = global_common::cutLast($iDoc, 1);
}
$strTableName = Model_Comment::TBL_SL_COMMENT . '_' . $key;
if ($whereClause) {
$condition = 'WHERE (' . global_mapping::IsDeleted . ' IS NULL or ' . global_mapping::IsDeleted . ' = \'0\') and `' . global_mapping::CommentID . '` IN (' . $strDocInTable . ') and ' . $whereClause;
} else {
$condition = 'WHERE (' . global_mapping::IsDeleted . ' IS NULL or ' . global_mapping::IsDeleted . ' = \'0\') and `' . global_mapping::CommentID . '` IN (' . $strDocInTable . ')';
}
$strSQL .= "(" . global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, $strTableName, $condition . $orderBy)) . " ) UNION ALL ";
}
//xóa bỏ đoạn text UNION ALL cuối chuỗi $strSQL
$strSQL = global_common::cutLast($strSQL, strlen('UNION ALL '));
$arrResult = $this->_objConnection->selectCommand($strSQL);
$arrResult = global_common::mergeUserInfo($arrResult);
//print_r($arrResult);
return $arrResult;
}
return null;
}
public function getStoreByIDs($arrIDs)
{
$arrIDs = global_common::splitString($arrIDs);
$strQueryIN = global_common::convertToQueryIN($arrIDs);
if ($strQueryIN) {
$strQueryIN = global_mapping::StoreID . ' IN (' . $strQueryIN . ')';
} else {
$strQueryIN = '1=1';
}
$whereClause = 'WHERE ' . $strQueryIN;
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array('*', self::TBL_SL_STORE, $whereClause . ' ' . ' limit 0,' . self::NUM_PER_PAGE));
//echo $strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get getProductByIDs:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
$objCity = new Model_City($this->_objConnection);
$objDistrict = new Model_District($this->_objConnection);
$tempVarCities = $objCity->getAllCity();
$allCities = null;
foreach ($tempVarCities as $key => $info) {
$allCities[$info[global_mapping::CityID]] = $info;
unset($tempVarCities[$key]);
}
$tempDistricts = $objDistrict->getAllDistrict();
$allDistricts = null;
foreach ($tempDistricts as $key => $info) {
$allDistricts[$info[global_mapping::DistrictID]] = $info;
unset($tempDistricts[$key]);
}
// print_r($allDistricts);
// return;
$count = count($arrResult);
$objArticle = new Model_Article($this->_objConnection);
for ($i = 0; $i < $count; $i++) {
//echo $arrResult;
//print_r( $allCities);
//$arrResult[$i][global_mapping::CityID] = $allCities[$arrResult[$i][global_mapping::CityID]];
$arrResult[$i][global_mapping::CityName] = $allCities[$arrResult[$i][global_mapping::CityID]][global_mapping::CityName];
// print_r($arrResult[$i]);
//return;
// print_r($allCities[$arrResult[$i][global_mapping::CityID]]);
//break;
$arrResult[$i][global_mapping::DistrictName] = $allDistricts[$arrResult[$i][global_mapping::DistrictID]][global_mapping::DistrictName];
$arrResult[$i][global_mapping::Latitude] = global_common::convertToDecimal($arrResult[$i][global_mapping::Latitude]);
$arrResult[$i][global_mapping::Longitude] = global_common::convertToDecimal($arrResult[$i][global_mapping::Longitude]);
$arrArticle = $objArticle->getArticleByStoreID($arrResult[$i][global_mapping::StoreID]);
$shortDescription = global_common::formatPlanText($arrArticle[0][global_mapping::Content]);
$arrResult[$i][global_mapping::Content] = global_common::cutString2($shortDescription, 0, 16);
// print_r($arrResult[$i]);
//echo $arrResult[$i][global_mapping::DistrictID];
//echo $allDistricts[$arrResult[$i][global_mapping::DistrictID]][global_mapping::DistrictName];
//print_r($allDistricts);
//return ;
}
//print_r($stores);
return $arrResult;
}
