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; }