public function insert($userID, $trackType, $value, $description, $trackDate)
{
$strTableName = self::TBL_SL_TRACKER;
$intID = global_common::getMaxValueofField($this->_objConnection, global_mapping::TrackID, $strTableName) + 1;
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_TRACKER, array(self::TBL_SL_TRACKER, $intID, global_common::escape_mysql_string($userID), global_common::escape_mysql_string($trackType), global_common::escape_mysql_string($value), global_common::escape_mysql_string($description), global_common::nowSQL()));
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_TRACKER, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add SL_TRACKER:' . $strSQL, 1);
return false;
}
return $intID;
}
$createdBy = $c_userInfo[global_mapping::UserID];
$resultID = $objAdvertising->insert($advertisingName, $partnerID, $startDate, $endDate, $adTypeID, $articleTypeID, $content, $imageLink, $preferLink, $order, $createdBy, $status);
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 {
$modifiedBy = $c_userInfo[global_mapping::UserID];
$advertisingID = html_entity_decode($_pgR[global_mapping::AdvertisingID], ENT_COMPAT, 'UTF-8');
$currentAd = $objAdvertising->getAdvertisingByID($advertisingID);
$resultID = $objAdvertising->update($advertisingID, $advertisingName, $partnerID, $startDate, $endDate, $adTypeID, $articleTypeID, $content, $imageLink, $preferLink, $order, $modifiedBy, global_common::nowSQL(), $currentAd[global_mapping::DeletedBy], $currentAd[global_mapping::DeletedDate], $currentAd[global_mapping::IsDeleted], $currentAd[global_mapping::Status]);
if ($resultID) {
$arrHeader = global_common::getMessageHeaderArr($banCode);
//$banCode
echo global_common::convertToXML($arrHeader, array("rs", "inf"), array(1, 'Cập nhậ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;
}
}
return;
} elseif ($_pgR['act'] == Model_Advertising::ACT_SHOW_EDIT) {
$advertisingID = $_pgR['id'];
$advertising = $objAdvertising->getAdvertisingByID($advertisingID);
if ($advertising) {
public function insert($articleid, $content, $createdby, $status)
{
$strTableName = self::TBL_SL_COMMENT;
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_COMMENT, array(self::TBL_SL_COMMENT, 0, global_common::escape_mysql_string($commenttype), global_common::escape_mysql_string($articleid), global_common::escape_mysql_string($content), global_common::escape_mysql_string($createdby), global_common::nowSQL(), global_common::escape_mysql_string($modifiedby), global_common::nowSQL(), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status)));
//return $strSQL;
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_COMMENT, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add sl_comment:' . $strSQL, 1);
return false;
}
$newID = global_common::getMaxValueofField(global_mapping::CommentID, self::TBL_SL_COMMENT);
return $newID;
}
public function activateBadComment($commentID, $description, $updatedBy, $isBad)
{
$currentComment = $this->getCommentBadByID($commentID);
$currentComment[global_mapping::Description] = $description;
$currentComment[global_mapping::ModifiedBy] = $updatedBy;
$currentComment[global_mapping::Status] = $isBad;
//echo 'bad:'.$isBad;
//print_r($currentComment);
//echo 'status'.$currentComment[global_mapping::Status];
//echo "Active".$currentComment[global_mapping::CommentID];
return $this->update($currentComment[global_mapping::CommentID], $currentComment[global_mapping::Description], $currentComment[global_mapping::ReportedBy], $currentComment[global_mapping::ReportedDate], $currentComment[global_mapping::ModifiedBy], global_common::nowSQL(), $currentComment[global_mapping::DeletedBy], $currentComment[global_mapping::DeletedDate], $currentComment[global_mapping::IsDeleted], $currentComment[global_mapping::Status]);
}
return;
}
} else {
if ($_pgR["act"] == Model_User::ACT_UPDATE_RESET_PASS) {
$password = $_pgR['password'];
$password = html_entity_decode($password, ENT_COMPAT, 'UTF-8');
$confirmpass = $_pgR['confirmpass'];
$confirmpass = html_entity_decode($confirmpass, ENT_COMPAT, 'UTF-8');
$resetid = $_pgR['resetid'];
$resetid = html_entity_decode($resetid, ENT_COMPAT, 'UTF-8');
if ($password == $confirmpass) {
$resetPw = $objReset->getResetPasswordByID($resetid);
$result = $objUser->changeResetPassword($resetPw[global_mapping::UserID], $password);
//echo $result;
if ($result > 0) {
$resetPw[global_mapping::ResetDate] = global_common::nowSQL();
$resetPw[global_mapping::IsDeleted] = 1;
$objReset->update($resetid, $resetPw[global_mapping::UserID], $resetPw[global_mapping::CreatedDate], $resetPw[global_mapping::ExpireDate], $resetPw[global_mapping::ResetDate], $resetPw[global_mapping::IsDeleted]);
$arrHeader = global_common::getMessageHeaderArr($banCode);
//$banCode
echo global_common::convertToXML($arrHeader, array('rs', 'inf'), array(1, 'Cập nhật thành công'), array(0, 1));
return;
} else {
echo global_common::convertToXML($arrHeader, array('rs', 'inf'), array(0, 'Cập nhật thất bại. Xin vui lòng thử lại sau!'), array(0, 1));
return;
}
} else {
echo global_common::convertToXML($arrHeader, array('rs', 'inf'), array(2, 'Mật khẩu mới không trùng nhau'), array(0, 1));
return;
}
} else {
public function update($PartnerID, $userid, $partnername, $company, $address1, $email1, $phone1, $website1, $modifiedby)
{
$strTableName = self::TBL_SL_PARTNER;
$strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_PARTNER, array($strTableName, global_common::escape_mysql_string($PartnerID), global_common::escape_mysql_string($userid), global_common::escape_mysql_string($partnername), global_common::escape_mysql_string($company), global_common::escape_mysql_string($address1), global_common::escape_mysql_string($addressname1), global_common::escape_mysql_string($address2), global_common::escape_mysql_string($addressname2), global_common::escape_mysql_string($address3), global_common::escape_mysql_string($addressname3), global_common::escape_mysql_string($address4), global_common::escape_mysql_string($addressname4), global_common::escape_mysql_string($address5), global_common::escape_mysql_string($addressname5), global_common::escape_mysql_string($email1), global_common::escape_mysql_string($emailname1), global_common::escape_mysql_string($email2), global_common::escape_mysql_string($emailname2), global_common::escape_mysql_string($email3), global_common::escape_mysql_string($emailname3), global_common::escape_mysql_string($email4), global_common::escape_mysql_string($emailname4), global_common::escape_mysql_string($email5), global_common::escape_mysql_string($emailname5), global_common::escape_mysql_string($phone1), global_common::escape_mysql_string($phonename1), global_common::escape_mysql_string($phone2), global_common::escape_mysql_string($phonename2), global_common::escape_mysql_string($phone3), global_common::escape_mysql_string($phonename3), global_common::escape_mysql_string($phone4), global_common::escape_mysql_string($phonename4), global_common::escape_mysql_string($phone5), global_common::escape_mysql_string($phonename5), global_common::escape_mysql_string($fax1), global_common::escape_mysql_string($faxname1), global_common::escape_mysql_string($fax2), global_common::escape_mysql_string($faxname2), global_common::escape_mysql_string($fax3), global_common::escape_mysql_string($faxname3), global_common::escape_mysql_string($fax4), global_common::escape_mysql_string($faxname4), global_common::escape_mysql_string($fax5), global_common::escape_mysql_string($faxname5), global_common::escape_mysql_string($website1), global_common::escape_mysql_string($websitename1), global_common::escape_mysql_string($website2), global_common::escape_mysql_string($websitename2), global_common::escape_mysql_string($website3), global_common::escape_mysql_string($websitename3), global_common::escape_mysql_string($website4), global_common::escape_mysql_string($websitename4), global_common::escape_mysql_string($website5), global_common::escape_mysql_string($websitename5), global_common::escape_mysql_string($taxnumber), global_common::escape_mysql_string($accountnumber), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::nowSQL(), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($status), global_common::escape_mysql_string($isdeleted)));
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PARTNER, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add sl_partner:' . $strSQL, 1);
return false;
}
return $intNewID;
}
public function refreshArticle($articleID, $currentUser)
{
$currentArticle = $this->getArticleByID($articleID);
$renewNum = $currentArticle[global_mapping::RenewedNum];
$renewedDate = $currentArticle[global_mapping::RenewedDate];
$diffDay = global_common::datediff(global_common::getDate(), date('d-m-Y', strtotime($renewedDate)), d);
if ($diffDay > 0) {
$renewNum = 0;
}
if ($renewNum < self::NUM_REFRESH) {
$renewNum += 1;
$title = $currentArticle[global_mapping::Title];
$fileName = $currentArticle[global_mapping::FileName];
$catalogueID = $currentArticle[global_mapping::CatalogueID];
$content = $currentArticle[global_mapping::Content];
$tags = $currentArticle[global_mapping::Tags];
$createdBy = $currentArticle[global_mapping::CreatedBy];
$createdDate = global_common::formatDateTimeVN($currentArticle[global_mapping::CreatedDate]);
$modifiedBy = $currentUser[global_mapping::UserID];
$renewedDate = global_common::nowSQL();
$companyName = $currentArticle[global_mapping::CompanyName];
$companyAddress = $currentArticle[global_mapping::CompanyAddress];
$companyWebsite = $currentArticle[global_mapping::CompanyWebsite];
$companyPhone = $currentArticle[global_mapping::CompanyPhone];
$adType = $currentArticle[global_mapping::AdType];
$startDate = global_common::formatDateTimeVN($currentArticle[global_mapping::StartDate]);
$endDate = global_common::formatDateTimeVN($currentArticle[global_mapping::EndDate]);
$happyDays = $currentArticle[global_mapping::HappyDays];
$startHappyHour = $currentArticle[global_mapping::StartHappyHour];
$endHappyHour = $currentArticle[global_mapping::EndHappyHour];
$addresses = $currentArticle[global_mapping::Addresses];
$dictricts = $currentArticle[global_mapping::Dictricts];
$cities = $currentArticle[global_mapping::Cities];
$resultID = $this->update($articleID, null, $title, $fileName, $catalogueID, $content, null, $tags, $numView, $numComment, $createdBy, $createdDate, $modifiedBy, global_common::nowSQL(), null, null, 0, null, null, $renewedDate, $renewNum, $companyName, $companyAddress, $companyWebsite, $companyPhone, $adType, $startDate, $endDate, $happyDays, $startHappyHour, $endHappyHour, $addresses, $dictricts, $cities);
if (!$resultID) {
//echo $strSQL;
global_common::writeLog('Error refreshArticle sl_article:' . $articleID, 1);
return -1;
}
return self::NUM_REFRESH - $renewNum;
}
return -1;
}
public function insert($title, $filename, $content, $notificationtype, $tags, $articletype, $createdby, $renewednum, $companyname, $companyAddress, $companyWebsite, $companyPhone, $adType, $startDate, $endDate, $happyDays, $startHappyHour, $endHappyHour, $addresses, $dictricts, $cities, $status)
{
$strTableName = self::TBL_SL_ARTICLE;
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_ARTICLE, array(self::TBL_SL_ARTICLE, null, global_common::escape_mysql_string($prefix), global_common::escape_mysql_string($title), global_common::escape_mysql_string($filename), global_common::escape_mysql_string($content), global_common::escape_mysql_string($notificationtype), global_common::escape_mysql_string($tags), global_common::escape_mysql_string($numview), global_common::escape_mysql_string($numcomment), global_common::escape_mysql_string($createdby), global_common::nowSQL(), global_common::escape_mysql_string($modifiedby), global_common::nowSQL(), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status), global_common::escape_mysql_string($comments), global_common::escape_mysql_string($reneweddate), global_common::escape_mysql_string($renewednum), global_common::escape_mysql_string($companyname), global_common::escape_mysql_string($companyAddress), global_common::escape_mysql_string($companyWebsite), global_common::escape_mysql_string($companyPhone), global_common::escape_mysql_string($adType), global_common::formatDateTimeSQL($startDate), global_common::formatDateTimeSQL($endDate), global_common::escape_mysql_string($happyDays), $startHappyHour ? '\'' . $startHappyHour . '\'' : 'null', $endHappyHour ? '\'' . $endHappyHour . '\'' : 'null', global_common::escape_mysql_string($addresses), global_common::escape_mysql_string($dictricts), global_common::escape_mysql_string($cities)));
//global_common::writeLog('Error add sl_article:'.$strSQL,1);
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_ARTICLE, $this->_objConnection, $strTableName)) {
global_common::writeLog('Error add sl_article:' . $strSQL, 1);
return false;
}
$articleID = global_common::getMaxValueofField(global_mapping::ArticleID, self::TBL_SL_ARTICLE);
$strSQLValueType = '';
foreach ($articletype as $item) {
$strSQLValueType .= '(\'' . $item . '\', \'' . $articleID . '\'),';
}
$strSQLValueType = global_common::cutLast($strSQLValueType);
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_ARTICLE_TYPE_ID, array(self::TBL_SL_ARTICLE_TYPE_ID, $strSQLValueType));
if (!global_common::ExecuteMultiqueryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_ARTICLE_TYPE_ID, $this->_objConnection, self::TBL_SL_ARTICLE_TYPE_ID)) {
}
global_common::writeLog('Error add sl_article_type_id:' . $strSQL, 1);
return $articleID;
}
public function update($propertygroupid, $propertygroupname, $propertygroupdisplay, $articletypeid, $order, $modifiedby, $status)
{
$strTableName = self::TBL_SL_PROPERTY_GROUP;
$strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_PROPERTY_GROUP, array($strTableName, global_common::escape_mysql_string($propertygroupid), global_common::escape_mysql_string($propertygroupname), global_common::escape_mysql_string($propertygroupdisplay), global_common::escape_mysql_string($articletypeid), global_common::escape_mysql_string($order), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::nowSQL(), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status)));
//echo $strSQL;
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PROPERTY_GROUP, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add sl_property_group:' . $strSQL, 1);
return false;
}
return $propertygroupid;
}
public function checkResetPasswordByID($objID, $selectField = '*')
{
$strSQL .= global_common::prepareQuery(global_common::SQL_SELECT_FREE, array($selectField, self::TBL_SL_RESET_PASSWORD, 'WHERE ID = \'' . $objID . '\' and `' . global_mapping::ExpireDate . '` > \'' . global_common::nowSQL() . '\'
and ' . global_mapping::IsDeleted . '=0'));
//echo '<br>SQL:'.$strSQL;
$arrResult = $this->_objConnection->selectCommand($strSQL);
if (!$arrResult) {
global_common::writeLog('get sl_reset_password ByID:' . $strSQL, 1, $_mainFrame->pPage);
return null;
}
//print_r($arrResult);
return $arrResult[0];
}
public function insert($username, $password, $fullname, $birthdate, $address, $phone, $email, $sex, $identity, $roleid, $userrankid, $avatar, $accountid, $isactived)
{
$strTableName = self::TBL_SL_USER;
$intID = global_common::getMaxValueofField($this->_objConnection, global_mapping::UserID, $strTableName) + 1;
//echo $intID;
$password = md5($intID . md5($password));
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_USER, array(self::TBL_SL_USER, $intID, global_common::escape_mysql_string($username), global_common::escape_mysql_string($password), global_common::escape_mysql_string($fullname), global_common::formatDateTimeSQL($birthdate), global_common::escape_mysql_string($address), global_common::escape_mysql_string($phone), global_common::escape_mysql_string($email), global_common::escape_mysql_string($sex), global_common::escape_mysql_string($identity), global_common::escape_mysql_string($roleid), global_common::escape_mysql_string($userrankid), global_common::escape_mysql_string($avatar), global_common::escape_mysql_string($accountid), global_common::escape_mysql_string($isactived), global_common::nowSQL()));
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_USER, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add sl_user:' . $strSQL, 1);
return false;
}
return $this->getUserByName($username);
}
public function update($manufactoryid, $manufactoryname, $categoryid, $order, $modifiedby, $isdeleted)
{
$strTableName = self::TBL_SL_MANUFACTORY;
$strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_MANUFACTORY, array($strTableName, global_common::escape_mysql_string($manufactoryid), global_common::escape_mysql_string($manufactoryname), global_common::escape_mysql_string($categoryid), global_common::escape_mysql_string($order), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::nowSQL(), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), $isdeleted));
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_MANUFACTORY, $this->_objConnection, $strTableName)) {
echo $strSQL;
global_common::writeLog('Error add sl_manufactory:' . $strSQL, 1);
return false;
}
return $manufactoryid;
}
public function update($retailerid, $productid, $productstatusid, $statusDetail, $price, $imagelink, $cityid, $shippingdesc, $boxinfo, $shortdesc, $description, $modifiedby, $status)
{
$strTableName = self::TBL_SL_RETAILER;
$strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_RETAILER, array($strTableName, global_common::escape_mysql_string($retailerid), global_common::escape_mysql_string($productid), global_common::escape_mysql_string($productstatusid), global_common::escape_mysql_string($statusDetail), global_common::escape_mysql_string($price), global_common::escape_mysql_string($amount), global_common::escape_mysql_string($remaining), global_common::escape_mysql_string($imagelink), global_common::escape_mysql_string($cityid), global_common::escape_mysql_string($districtid), global_common::escape_mysql_string($shiptypeid), global_common::escape_mysql_string($shipingcost), global_common::escape_mysql_string($shippingday), global_common::escape_mysql_string($shippingdesc), global_common::escape_mysql_string($paymentmodeid), global_common::escape_mysql_string($boxinfo), global_common::escape_mysql_string($warranty), global_common::escape_mysql_string($promotion), global_common::escape_mysql_string($shortdesc), global_common::escape_mysql_string($description), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::nowSQL(), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($statusid), global_common::escape_mysql_string($status)));
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_RETAILER, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error update sl_retailer:' . $strSQL, 1);
return false;
}
return $retailerid;
}
public function cloneProduct($productid, $createdBy)
{
$strTableName = self::TBL_SL_PRODUCT;
$intID = global_common::getMaxValueofField($this->_objConnection, global_mapping::ProductID, $strTableName) + 1;
$strSQL = global_common::prepareQuery(self::SQL_CLONE_SL_PRODUCT, array($strTableName, $productid, $intID, global_common::escape_mysql_string($createdBy), global_common::nowSQL()));
//echo $strSQL;
//return;
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PRODUCT, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add sl_product:' . $strSQL, 1);
return false;
}
return $intID;
}
//return;
if ($resultID) {
$commentHTML = $objComment->getCommentHTMLByArticle($articleid);
$arrHeader = global_common::getMessageHeaderArr($banCode);
//$banCode
echo global_common::convertToXML($arrHeader, array("rs", "inf", "form"), array(1, 'Gửi bình luận thành công', $commentHTML), array(0, 1, 1));
return;
} else {
echo global_common::convertToXML($arrHeader, array("rs", "info"), array(0, "Input data is invalid"), array(0, 1));
return;
}
} else {
$modifiedBy = $c_userInfo[global_mapping::UserID];
$articleID = html_entity_decode($_pgR[global_mapping::ArticleID], ENT_COMPAT, 'UTF-8');
$currentArticle = $objArticle->getArticleByID($articleID);
$resultID = $objArticle->update($articleID, null, $title, $fileName, $catalogueID, $content, null, $tags, null, null, $currentArticle[global_mapping::CreatedBy], $currentArticle[global_mapping::CreatedDate], $modifiedBy, global_common::nowSQL(), null, null, 1, null, null, null, null, $companyName, $companyAddress, $companyWebsite, $companyPhone, $adType, $startDate, $endDate, $happyDays, $startHappyHour, $endHappyHour, $addresses, $dictricts, $cities);
if ($resultID) {
$arrHeader = global_common::getMessageHeaderArr($banCode);
//$banCode
echo global_common::convertToXML($arrHeader, array("rs", "inf"), array(1, 'Cập nhật thành công'), array(0, 1));
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));
//}
if ($city) {
$cityID = $city[global_mapping::CityID];
} else {
$cityID = $objCity->insert($cityName);
}
$districtName = $substore['District'];
$district = $objDistrict->getDistrictByName($districtName);
//print_r($district);
if ($district) {
$districtID = $district[global_mapping::DistrictID];
} else {
$districtID = $objDistrict->insert($districtName, $cityID);
}
echo 'DistrictID:' . $districtID . '<br>';
echo 'Adding...' . $storeName . '<br>';
$result = $objStore->insert($storeName, $substore['Address'], $districtID, $cityID, '', '', $substore['Latitude'], $substore['Longitude'], '', $substore['MainCategoryId'], $substore['PicturePath'], $substore['PicturePath'], '', $createdBy, global_common::nowSQL(), $updatedBy, global_common::nowSQL(), null, null, $subStoreRefID);
if ($result) {
$categoryID = 0;
foreach ($allCats as $cat) {
if ($cat[global_mapping::Status] == $substore['MainCategoryId']) {
$categoryID = $cat[global_mapping::ArticleTypeID];
break;
}
}
$objStoreCategory->insert($result, $categoryID);
echo 'Added ' . $storeName . ' successfull';
echo '<br>';
//return;
} else {
echo 'Add ' . $storeName . ' failed';
echo '<br>';
public function insert($advertisingname, $partnerid, $startdate, $enddate, $adtypeid, $catID, $content, $imagelink, $preferlink, $order, $createdby, $status)
{
$strTableName = self::TBL_SL_ADVERTISING;
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_ADVERTISING, array(self::TBL_SL_ADVERTISING, 0, global_common::escape_mysql_string($advertisingname), global_common::escape_mysql_string($partnerid), global_common::formatDateTimeSQL($startdate), global_common::formatDateTimeSQL($endDate), global_common::escape_mysql_string($adtypeid), $catID, global_common::escape_mysql_string($content), global_common::escape_mysql_string($imagelink), global_common::escape_mysql_string($preferlink), global_common::escape_mysql_string($order), global_common::escape_mysql_string($createdby), global_common::nowSQL(), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status)));
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_ADVERTISING, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add sl_advertising:' . $strSQL, 1);
return false;
}
$intID = global_common::getMaxValueofField($this->_objConnection, global_mapping::AdvertisingID, self::TBL_SL_ADVERTISING);
return $intID;
}
public function addCheckIn($storeID, $userID, $message, $rate)
{
$strTableName = self::TBL_SL_CHECKIN;
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_CHECKIN, array(self::TBL_SL_CHECKIN, $storeID, global_common::escape_mysql_string($userID), global_common::escape_mysql_string($message), global_common::escape_mysql_string($rate), global_common::nowSQL()));
//echo $strSQL;
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_CHECKIN, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add addCheckIn:' . $strSQL, 1);
return false;
}
return $intID;
}
