/**
* Method de gui mail
*
* @param string $to Email cua nguoi nhan
* @param string $toname Ten cua nguoi nhan
* @param string $subject Chu de cua mail
* @param string $content Noi dung cua mail
* @param string $attactment Attachment - hien tai ko co dung
* @param string $sender Email dung de login SMTP
* @param string $senderPass Pass cua email dung de login SMTP
* @param string $senderName Ten nguoi gui
* @param string $useGoogleSMTP Cho biet co dung SMTP cua google de gui hay khong. Chi co gui mail truc tiep moi dung
* @return bool true->thanh cong, false->that bai
*
*/
public function send($to, $toname, $subject, $content, $attactment, $sender, $senderPass, $senderName, $useGoogleSMTP = 1)
{
try {
//error_reporting(E_ALL);
$mail = new PHPMailer();
//$mail->AddReplyTo($replyto,$fullname);
$mail->From = $sender;
$mail->FromName = $senderName;
$mail->Subject = $subject;
$mail->Body = $content;
$mail->AltBody = "To view the message, please use an HTML compatible email viewer!";
// optional, comment out and test
$mail->WordWrap = 50;
// set word wrap
$mail->MsgHTML($content);
$arrAddress = explode(";", $to);
foreach ($arrAddress as $address) {
$mail->AddAddress($address, $toname);
}
$mail->IsHTML(true);
// send as HTML
$mail->IsSMTP();
$mail->SMTPAuth = true;
$mail->SMTPSecure = "ssl";
$mail->Host = "smtp.gmail.com";
// sets GMAIL as the SMTP server
$mail->Port = '465';
// set the SMTP port for the GMAIL server
$mail->Username = $sender;
$mail->Password = $senderPass;
$mail->CharSet = 'utf-8';
//echo $sender;
//echo $senderPass;
if (!$mail->Send()) {
global_common::writeLog("Mailer Error: " . $mail->ErrorInfo, 0, "sendmail.php");
return false;
} else {
return true;
}
} catch (Exception $e) {
global_common::writeLog("Mailer Error: " . $e->getMessage(), 0, "sendmail.php");
return false;
}
}
public function activeAdvertising($adID, $isActivate)
{
$strTableName = self::TBL_SL_ADVERTISING;
$strSQL = global_common::prepareQuery(self::SQL_ACTIVE_SL_ADVERTISING, array($strTableName, global_common::escape_mysql_string($adID), $isActivate));
//echo $strSQL;
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_ADVERTISING, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add sl_article:' . $strSQL, 1);
return false;
}
return $adID;
}
/**
* Get Article with input is sql script
*
* @param mixed $strSQL This is a description
* @return mixed This is the return value description
*
*/
private function getArticlesFromDB($strSQL)
{
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get sl_article from DB:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
$count = count($arrResult);
for ($i = 0; $i < $count; $i++) {
//print_r($arrResult[$i]);
$arrResult[$i][global_mapping::Content] = stripslashes($arrResult[$i][global_mapping::Content]);
}
return global_common::mergeUserInfo($arrResult);
}
public function getTrackerUser($userID, $storeID)
{
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array('*', self::TBL_SL_TRACKER, 'WHERE UserID = \'' . $userID . '\' And Value = \'' . $storeID . '\' '));
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get SL_TRACKER User:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
//print_r($arrResult);
return $arrResult[0];
}
public function getAllAdvertising($intPage = 0, $selectField = '*', $whereClause = '', $orderBy = '', &$total)
{
if (!$selectField) {
$selectField = '*';
}
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_Advertising::TBL_SL_ADVERTISING, $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_Advertising::TBL_SL_ADVERTISING, $whereClause . $orderBy));
} else {
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_Advertising::TBL_SL_ADVERTISING, $whereClause . $orderBy));
}
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get All sl_advertising:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
if ($strSQLCount) {
//echo '<br>$strSQLCount:'.$strSQLCount;
$arrTotal = $this->_objConnection->selectCommand($strSQLCount);
$total = $arrTotal[0][0];
}
$objAdType = new Model_AdType($this->_objConnection);
$allAdType = $objAdType->getAllAdType(0, null, null, null);
$adTypes = array();
foreach ($allAdType as $key => $info) {
$adTypes[$info[global_mapping::AdTypeID]] = $info;
unset($allAdType[$key]);
}
$count = count($arrResult);
for ($index = 0; $index < $count; $index++) {
$arrResult[$index][global_mapping::AdTypeName] = $adTypes[$arrResult[$index][global_mapping::AdTypeID]][global_mapping::AdTypeName];
}
//print_r($arrResult);
return $arrResult;
}
/**
* thực hiện lấy media link từ một url
*
* @param string $urlMedia địa chỉ của một page media
* @return string chuỗi media link
* @author TinhDoan added [20101027]
*
*/
public function getMediaLinkFromURL($urlMedia)
{
// lấy nội dung của page
$content = self::getContentWebPage($urlMedia);
global_common::writeLog("1.getMediaLinkFromURL: http_code: " . $content["http_code"], 1, "global_editor.php");
global_common::writeLog("1.getMediaLinkFromURL: location: " . $content["location"], 1, "global_editor.php");
global_common::writeLog("1.getMediaLinkFromURL: content: " . $content["content"], 1, "global_editor.php");
if ($content['http_code'] == 200) {
if (strncasecmp("application/x-shockwave-flash", $content["content_type"], 29) == 0) {
global_common::writeLog("1.getMediaLinkFromURL: location: " . $content["location"], 1, "global_editor.php");
if (!array_key_exists('location', $content)) {
$content["location"] = $urlMedia;
}
return "width:'420',height:'320',movie:'" . $content["location"] . "'";
}
// thực hiện lấy url media new từ nội dung vừa đọc được
$newURLMedia = self::getMediaLinkFromContent($content["content"]);
// nếu không lấy được new media link từ nội dung của page media
if ($newURLMedia == "") {
// thực hiện lấy new media link từ url media trước đó
$newURLMedia = self::trygetMediaLinkFromURL($urlMedia);
}
// nếu lấy được new media link
if ($newURLMedia) {
// thực hiện lấy media link lại từ địa chỉ new media link
return self::getMediaLinkFromURL($newURLMedia);
}
}
return "";
}
$userUpdate[global_mapping::Avatar] = $fileName;
//echo $fileName;
//echo $userUpdate[global_mapping::IsActive];
$result = $objUser->update($userUpdate[global_mapping::UserID], $userUpdate[global_mapping::UserName], $userUpdate[global_mapping::Password], $userUpdate[global_mapping::FullName], $userUpdate[global_mapping::BirthDate], $userUpdate[global_mapping::Address], $userUpdate[global_mapping::Phone], $userUpdate[global_mapping::Email], $userUpdate[global_mapping::Sex], $userUpdate[global_mapping::Identity], $userUpdate[global_mapping::RoleID], $userUpdate[global_mapping::UserRankID], $userUpdate[global_mapping::Avatar], $userUpdate[global_mapping::AccountID], $userUpdate[global_mapping::IsActive]);
//echo $result;
$_SESSION[global_common::SES_C_USERINFO] = $currentUser = $userUpdate;
move_uploaded_file($_FILES["file"]["tmp_name"], $fileName);
//}
//else
//{
// move_uploaded_file($_FILES["file"]["tmp_name"],
// global_common::FOLDER_AVATAR . $currentUser[global_mapping::UserID].$_FILES["file"]["name"]);
//}
}
} else {
global_common::writeLog("Invalid file");
//echo "Invalid file";
}
//return;
}
?>
<?php
include_once 'include/_header.inc';
include_once 'include/_menu.inc';
//print_r($currentUser);
?>
<div id="profile-page" class="page-content">
<div class="row-fluid">
<div class="span12">
public function getAllCommentBad($intPage = 0, $selectField = '*', $whereClause = '', $orderBy = '')
{
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_CommentBad::TBL_SL_COMMENT_BAD, $whereClause . $orderBy . ' limit ' . ($intPage - 1) * self::NUM_PER_PAGE . ',' . self::NUM_PER_PAGE));
} else {
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_CommentBad::TBL_SL_COMMENT_BAD, $whereClause . $orderBy));
}
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get All sl_comment_bad:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
//echo 'Merge bad comment info';
//print_r($arrResult);
$arrResult = global_common::mergeUserInfo($arrResult);
//echo 'End Merge bad comment info';
//print_r($arrResult);
return $arrResult;
}
private function getCacheInfoBykey($arrInfo, $type, $keyInfo)
{
// TODO: DoNguyen - Đặt tên biến sai quy định: $KeyInfo -> $keyInfo (viết thường ký tự đầu của chữ đầu)
switch ($type) {
case 'xml':
$key = 'cxiID';
break;
case 'sql':
$key = 'csiID';
break;
case 'business':
$key = 'cbiID';
break;
}
// tim keyInfo trong $arrInfo
foreach ($arrInfo as $item) {
$attr = $item['attribute'];
if ($attr) {
if ($attr[$key] == 'default') {
$keyDefault = $attr;
}
if ($attr[$key] == $keyInfo) {
$cacheInfo = $attr;
break;
}
}
}
// Neu keyInfo khong co trong list item
if (!$cacheInfo) {
global_common::writeLog('Không tìm thấy keyInfo, sử dụng default key', 0);
$cacheInfo = $keyDefault;
}
return $cacheInfo;
}
return;
} else {
echo global_common::convertToXML($strMessageHeader, array('rs'), array(0), array(0));
return;
}
} elseif ($_pgR["act"] == model_User::ACT_REGISTER) {
//get user info
//$c_userInfo = $_SESSION[consts::SES_C_USERINFO];
//if ($objMenu->getMenuByName($_pgR['name'])) {
// echo global_common::convertToXML($arrHeader, array("rs",'info'), array(0,global_common::STRING_NAME_EXIST), array(0,1));
// return;
//}
$userName = $_pgR['UserName'];
global_common::writeLog($userName);
$userName = global_editor::rteSafe(html_entity_decode($userName, ENT_COMPAT, 'UTF-8'));
global_common::writeLog($userName);
$password = $_pgR['Password'];
$password = global_editor::rteSafe(html_entity_decode($password, ENT_COMPAT, 'UTF-8'));
$fullname = $_pgR['Fullname'];
$fullname = global_editor::rteSafe(html_entity_decode($fullname, ENT_COMPAT, 'UTF-8'));
$birthDate = $_pgR['BirthDate'];
$birthDate = global_editor::rteSafe(html_entity_decode($birthDate, ENT_COMPAT, 'UTF-8'));
$address = $_pgR['Address'];
$address = global_editor::rteSafe(html_entity_decode($address, ENT_COMPAT, 'UTF-8'));
$phone = $_pgR['Phone'];
$phone = global_editor::rteSafe(html_entity_decode($phone, ENT_COMPAT, 'UTF-8'));
$email = $_pgR['Email'];
$email = global_editor::rteSafe(html_entity_decode($email, ENT_COMPAT, 'UTF-8'));
$sex = $_pgR['Sex'];
$sex = global_editor::rteSafe(html_entity_decode($sex, ENT_COMPAT, 'UTF-8'));
$identity = $_pgR['Identity'];
public function getAllProperty($intPage = 0, $selectField = '*', $whereClause = '', $orderBy = '')
{
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_Property::TBL_SL_PROPERTY, $whereClause . $orderBy . ' limit ' . ($intPage - 1) * self::NUM_PER_PAGE . ',' . self::NUM_PER_PAGE));
} else {
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_Property::TBL_SL_PROPERTY, $whereClause . $orderBy));
}
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get All sl_property:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
$objDataType = new Model_Datatype($this->_objConnection);
$allDataType = $objDataType->getAllDatatype();
$dataTypes = array();
foreach ($allDataType as $key => $info) {
$dataTypes[$info[global_mapping::DataTypeID]] = $info;
unset($dataTypes[$key]);
}
$count = count($arrResult);
for ($index = 0; $index < $count; $index++) {
$arrResult[$index][global_mapping::DataTypeID] = $dataTypes[$arrResult[$index][global_mapping::DataTypeID]];
}
//print_r($arrResult);
return $arrResult;
}
public function getLatestRetailer($intPage = 0, $whereClause = '', $type, &$total)
{
if ($whereClause) {
$whereClause = ' WHERE ' . $whereClause;
}
$orderBy = ' ORDER BY ' . global_mapping::ModifiedDate . ' DESC';
$strSQL = global_common::prepareQuery(global_common::SQL_SELECT_FREE, array(global_mapping::ProductID, Model_Product::TBL_SL_PRODUCT, $whereClause));
//echo '<br>SQL:'.$strSQL;
$products = $this->_objConnection->selectCommand($strSQL);
if (!$products) {
global_common::writeLog('get All sl_product:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
$productIDs = global_common::getArrayColumn($products, global_mapping::ProductID);
$productIDs = array_unique($productIDs);
//print_r($productIDs);
$strQueryIN = global_common::convertToQueryIN($productIDs);
$whereClause = 'Where ' . global_mapping::ProductID . ' IN (' . $strQueryIN . ')';
if ($type) {
$whereClause .= ' And ' . global_mapping::ProductStatusID . '=' . $type;
}
$strSQL = global_common::prepareQuery(global_common::SQL_SELECT_FREE, array('*', Model_Retailer::TBL_SL_RETAILER, $whereClause . $orderBy . ' limit ' . ($intPage - 1) * self::NUM_PER_PAGE . ',' . self::NUM_PER_PAGE));
$arrResult = $this->_objConnection->selectCommand($strSQL);
//echo $strSQL;
if (!$arrResult) {
global_common::writeLog('get All Retailers:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
$strSQLCount = global_common::prepareQuery(global_common::SQL_SELECT_FREE, array('count(*)', Model_Retailer::TBL_SL_RETAILER, $whereClause));
//Get details of product to display
$productIDs = global_common::getArrayColumn($arrResult, global_mapping::ProductID);
$productIDs = array_unique($productIDs);
//print_r($productIDs);
$strQueryIN = global_common::convertToQueryIN($productIDs);
$productDetails = $this->getProductByIDs($productIDs);
$convertedProducts = array();
foreach ($productDetails as $key => $info) {
$convertedProducts[$info[global_mapping::ProductID]] = $info;
unset($productDetails[$key]);
}
$objStatus = new Model_Status($this->_objConnection);
$productStatus = $objStatus->getAllStatus();
$convertedStatus = array();
foreach ($productStatus as $key => $info) {
$convertedStatus[$info[global_mapping::StatusID]] = $info;
unset($productStatus[$key]);
}
//echo '<br>$strSQLCount:'.$strSQLCount;
//Get total results
if ($strSQLCount) {
$arrTotal = $this->_objConnection->selectCommand($strSQLCount);
$total = $arrTotal[0][0];
}
//Assign product details to retailers by ProductID
$count = count($arrResult);
for ($index = 0; $index < $count; $index++) {
$arrResult[$index]["Product"] = $convertedProducts[$arrResult[$index][global_mapping::ProductID]];
$arrResult[$index][global_mapping::StatusName] = $convertedStatus[$arrResult[$index][global_mapping::ProductStatusID]][global_mapping::StatusName];
}
//echo 'Before merge comment info';
$arrResult = global_common::mergeUserInfo($arrResult, $this->_objConnection);
return $arrResult;
}
public function getArticleTypeByFilter($whereClause, $selectField = '*')
{
if ($whereClause) {
$whereClause = ' WHERE ' . $whereClause;
}
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, self::TBL_SL_ARTICLE_TYPE, $whereClause));
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get All sl_article_type:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
//print_r($arrResult);
return $arrResult;
}
$userRetailer = $objUser->getUserByID($retailer[global_mapping::CreatedBy]);
$fullNameRetailer = $userRetailer[global_mapping::FullName];
$emailRetailer = $userRetailer[global_mapping::Email];
$fullName = $c_userInfo[global_mapping::FullName];
$linkArticle = global_common::getHostName() . '/retailer_detail.php?rid=' . $retailerID;
$commentDate = global_common::formatDateTimeVN($comment[global_mapping::CreatedDate]);
$commentContent = $comment[global_mapping::Content];
$linkPolicy = global_common::getHostName() . '/' . global_common::PAGE_TERM_KM;
$arrMailContent = global_common::formatMailContent(global_common::TEMPLATE_NEW_COMMENT, null, array(global_common::formatOutputText($fullName), global_common::formatOutputText($fullNameRetailer), $product[global_mapping::ProductName], global_common::formatOutputText($content), $linkArticle));
$emailSubject = $arrMailContent[0];
$emailContent = $arrMailContent[1];
//echo $emailContent;
global_mail::send($emailRetailer, $fullNameRetailer, $emailSubject, $emailContent, null, global_common::SUPPORT_MAIL_USERNAME, global_common::SUPPORT_MAIL_PASSWORD, global_common::SUPPORT_MAIL_DISPLAY_NAME);
}
} catch (Exception $e) {
global_common::writeLog($e);
}
return;
} else {
echo global_common::convertToXML($arrHeader, array("rs", "info"), array(0, "Input data is invalid"), array(0, 1));
return;
}
}
//else
//{
// echo global_common::convertToXML($arrHeader, array("rs",'info'), array(0,global_common::STRING_REQUIRE_LOGIN), array(0,1));
//}
return;
} elseif ($_pgR['act'] == Model_Comment::ACT_CHANGE_PAGE) {
$intPage = $_pgR['p'];
$retailerID = $_pgR[global_mapping::RetailerID];
public function getAllUser($intPage = 0, $selectField = '*', $whereClause = '', $orderBy = '', &$total)
{
if ($whereClause) {
$whereClause = ' WHERE ' . $whereClause;
}
if (!$selectField) {
$selectField = '*';
}
if ($orderBy) {
$orderBy = ' ORDER BY ' . $orderBy;
}
if ($intPage > 0) {
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_User::TBL_SL_USER, $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_User::TBL_SL_USER, $whereClause . $orderBy));
} else {
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_User::TBL_SL_USER, $whereClause . $orderBy));
}
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get All sl_user:'******'<br>$strSQLCount:'.$strSQLCount;
$arrTotal = $this->_objConnection->selectCommand($strSQLCount);
$total = $arrTotal[0][0];
}
//print_r($arrResult);
return $arrResult;
}
public function getAllManufactory($selectField = '*')
{
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, self::TBL_SL_MANUFACTORY, ''));
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get All sl_manufactory:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
//print_r($arrResult);
return $arrResult;
}
private function getArticlesFromDB($strSQL)
{
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get sl_article from DB:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
return global_common::mergeUserInfo($arrResult);
}
public function getAllStatus($intPage = 0, $selectField = '*', $whereClause = '', $orderBy = '')
{
if ($whereClause) {
$whereClause = ' WHERE ' . $whereClause . ' and (' . global_mapping::IsDeleted . '=0 or ' . global_mapping::IsDeleted . ' IS NULL)';
} else {
$whereClause = ' WHERE (' . global_mapping::IsDeleted . '=0 or ' . global_mapping::IsDeleted . ' IS NULL)';
}
if ($orderBy) {
$orderBy = ' ORDER BY ' . $orderBy;
}
if ($intPage > 0) {
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_Status::TBL_SL_STATUS, $whereClause . $orderBy . ' limit ' . ($intPage - 1) * self::NUM_PER_PAGE . ',' . self::NUM_PER_PAGE));
} else {
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_Status::TBL_SL_STATUS, $whereClause . $orderBy));
}
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get All sl_status:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
//print_r($arrResult);
return $arrResult;
}
public function getAllPropertyGroup($intPage = 0, $selectField = '*', $whereClause = '', $orderBy = '', &$total)
{
if (!$selectField) {
$selectField = '*';
}
if ($whereClause) {
$whereClause = ' WHERE ' . $whereClause;
}
if ($orderBy) {
$orderBy = ' ORDER BY ' . $orderBy . ' ,`Order`';
} else {
$orderBy = ' ORDER BY `Order`';
}
if ($intPage > 0) {
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_PropertyGroup::TBL_SL_PROPERTY_GROUP, $whereClause . $orderBy . ' limit ' . ($intPage - 1) * self::NUM_PER_PAGE . ',' . self::NUM_PER_PAGE));
} else {
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_PropertyGroup::TBL_SL_PROPERTY_GROUP, $whereClause . $orderBy));
}
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get All sl_property_group:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
$total = count($arrResult);
$objCat = new Model_ArticleType($this->_objConnection);
$allCats = $objCat->getAllArticleType(0);
$convertedCats = array();
foreach ($allCats as $key => $info) {
$convertedCats[$info[global_mapping::ArticleTypeID]] = $info;
unset($allCats[$key]);
}
$count = count($arrResult);
for ($index = 0; $index < $count; $index++) {
$arrResult[$index][global_mapping::ArticleTypeName] = $convertedCats[$arrResult[$index][global_mapping::ArticleTypeID]][global_mapping::ArticleTypeName];
}
//print_r($arrResult);
return $arrResult;
}
public function getAllArticleType($intPage = 0, $selectField = '*', $whereClause = '', $orderBy = '')
{
$selectField = $selectField ? $selectField : '*';
if ($whereClause) {
$whereClause = ' WHERE ' . $whereClause . ' and (' . global_mapping::IsDeleted . ' is null or ' . global_mapping::IsDeleted . '=0)';
} else {
$whereClause = ' WHERE (' . global_mapping::IsDeleted . ' is null or ' . global_mapping::IsDeleted . ' !=1)';
}
if ($orderBy && trim($orderBy) != 'Level') {
$orderBy = ' ORDER BY Level,' . $orderBy . '';
} else {
$orderBy = ' ORDER BY Level';
}
if ($intPage > 0) {
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_ArticleType::TBL_SL_ARTICLE_TYPE, $whereClause . $orderBy . ' limit ' . ($intPage - 1) * self::NUM_PER_PAGE . ',' . self::NUM_PER_PAGE));
} else {
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_ArticleType::TBL_SL_ARTICLE_TYPE, $whereClause . $orderBy));
}
//echo $strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get All sl_article_type:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
//print_r($arrResult);
return $arrResult;
}
public function getMaxValueofField($objConnection, $fieldName, $strTableName)
{
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_MAX_ID, array($fieldName, $strTableName));
//echo '<br>SQL:'.$strSQL;
$arrResult = $objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get getMaxValueofField:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
//print_r($arrResult);
return $arrResult[0]['maxid'];
}
public function getAllNumberaire($intPage = 0, $selectField = '*', $whereClause = '', $orderBy = '')
{
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_Numberaire::TBL_SL_NUMBERAIRE, $whereClause . $orderBy . ' limit ' . ($intPage - 1) * self::NUM_PER_PAGE . ',' . self::NUM_PER_PAGE));
} else {
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, Model_Numberaire::TBL_SL_NUMBERAIRE, $whereClause . $orderBy));
}
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get All sl_numberaire:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
//print_r($arrResult);
return $arrResult;
}
function getPriceFromURL($url, $pathCode)
{
try {
$html = file_get_html($url);
//echo $url;
if ($html) {
foreach ($html->find($pathCode) as $e) {
$myContent = $e->innertext;
}
$myContent = preg_replace('/\\D/', '', $myContent);
return $myContent;
} else {
global_common::writeLog("Can't get price from url:" . $url);
}
} catch (exception $ex) {
global_common::writeLog("Can't get price from url" . $url);
}
return -1;
}
public function getAllNotificationType($selectField = '*')
{
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, self::TBL_SL_NOTIFICATION_TYPE, ''));
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get All sl_notification_type:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
//print_r($arrResult);
return $arrResult;
}
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;
}
