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;
}
public function insert($price, $offereddate, $deleteddate, $isdelete, $status)
{
$strTableName = self::TBL_SL_OFFER;
$intID = global_common::getMaxValueofField($this->_objConnection, global_mapping::UserID, $strTableName) + 1;
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_OFFER, array(self::TBL_SL_OFFER, $intID, global_common::escape_mysql_string($price), global_common::escape_mysql_string($offereddate), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdelete), global_common::escape_mysql_string($status)));
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_OFFER, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add sl_offer:' . $strSQL, 1);
return false;
}
return $intID;
}
public function insert($productid, $retailer, $productlink, $typeid, $order, $statusid, $status)
{
$intID = global_common::getMaxValueofField($this->_objConnection, global_mapping::ProductPriceID, self::TBL_SL_PRODUCT_PRICE);
$intID = $intID + 1;
$strTableName = self::TBL_SL_PRODUCT_PRICE;
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_PRODUCT_PRICE, array(self::TBL_SL_PRODUCT_PRICE, $intID, global_common::escape_mysql_string($productid), global_common::escape_mysql_string($retailer), global_common::escape_mysql_string($productlink), global_common::escape_mysql_string($typeid), global_common::escape_mysql_string($order), global_common::escape_mysql_string($statusid), global_common::escape_mysql_string($status)));
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PRODUCT_PRICE, $this->_objConnection, $strTableName)) {
echo $strSQL;
global_common::writeLog('Error add sl_product_price:' . $strSQL, 1);
return false;
}
return $intID;
}
$productName = html_entity_decode($productName, ENT_COMPAT, 'UTF-8');
$catalogueID = $_pgR['CatalogueID'];
$catalogueID = html_entity_decode($catalogueID, ENT_COMPAT, 'UTF-8');
$imageLink = $_pgR['ImageLink'];
$imageLink = html_entity_decode($imageLink, ENT_COMPAT, 'UTF-8');
$manufactoryID = $_pgR['ManufactoryID'];
$manufactoryID = html_entity_decode($manufactoryID, ENT_COMPAT, 'UTF-8');
$description = $_pgR['Description'];
$description = global_editor::rteSafe(html_entity_decode($description, ENT_COMPAT, 'UTF-8'));
$status = 1;
if ($_pgR["act"] == Model_Product::ACT_ADD) {
$createdBy = $c_userInfo[global_mapping::UserID];
$resultID = $objProduct->insert($productName, $catalogueID, $imageLink, $manufactoryID, $description, $createdBy, $status);
if ($resultID) {
$orderProductProperty = 0;
$orderGroup = global_common::getMaxValueofField($objConnection, global_mapping::PropertyGroupID, Model_PropertyGroup::TBL_SL_PROPERTY_GROUP) + 1;
foreach ($properties as $item) {
$group = $item[global_mapping::PropertyGroupID];
$groupID = global_common::convertToInt($group);
//is new group
if ($groupID <= 0) {
$searchGroup = $objPropertyGroup->getPropertyGroupByNameAndCat($group, $catalogueID);
if ($searchGroup) {
$groupID = $searchGroup[global_mapping::PropertyGroupID];
} else {
$groupID = $objPropertyGroup->insert($group, $group, $catalogueID, $orderGroup, $createdBy, null);
$orderGroup++;
}
}
$propertyName = $item[global_mapping::PropertyID];
$propertyID = global_common::convertToInt($propertyName);
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 insert($username, $password, $fullname, $birthdate, $address, $phone, $email, $sex, $identity, $roleid, $userrankid, $avatar, $accountid, $isactived)
{
$strTableName = self::TBL_SL_USER;
$intID = global_common::getMaxValueofField(global_mapping::UserID, $strTableName) + 1;
$password = md5($intID . md5($password));
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_USER, array(self::TBL_SL_USER, null, 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)));
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 insert($userid, $partnername, $company, $address1, $addressname1, $address2, $addressname2, $address3, $addressname3, $address4, $addressname4, $address5, $addressname5, $email1, $emailname1, $email2, $emailname2, $email3, $emailname3, $email4, $emailname4, $email5, $emailname5, $phone1, $phonename1, $phone2, $phonename2, $phone3, $phonename3, $phone4, $phonename4, $phone5, $phonename5, $fax1, $faxname1, $fax2, $faxname2, $fax3, $faxname3, $fax4, $faxname4, $fax5, $faxname5, $website1, $websitename1, $website2, $websitename2, $website3, $websitename3, $website4, $websitename4, $website5, $websitename5, $taxnumber, $accountnumber, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $status, $isdeleted)
{
$strTableName = self::TBL_SL_PARTNER;
$intID = global_common::getMaxValueofField($this->_objConnection, global_mapping::UserID, $strTableName) + 1;
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_PARTNER, array(self::TBL_SL_PARTNER, $intID, 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::escape_mysql_string($modifieddate), 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 $intID;
}
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)
{
//echo $endDate?'\''.global_common::formatDateTimeSQL($endDate).'\'':'null';
$status = 1;
$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($createdby), 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::nowSQL(), 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::formatDateTimeSQL($endDate) . '\'' : 'null', 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 insert($manufactoryname, $categoryid, $order, $createdby, $isdeleted)
{
$strTableName = self::TBL_SL_MANUFACTORY;
$intID = global_common::getMaxValueofField($this->_objConnection, global_mapping::ManufactoryID, $strTableName) + 1;
$strTableName = self::TBL_SL_MANUFACTORY;
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_MANUFACTORY, array(self::TBL_SL_MANUFACTORY, $intID, 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::nowSQL(), global_common::escape_mysql_string($createdby), global_common::nowSQL(), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted)));
//echo $strSQL;
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 $intID;
}
public function insert($articletypename, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted, $status, $level, $parentid)
{
$strTableName = self::TBL_SL_ARTICLE_TYPE;
$intID = global_common::getMaxValueofField($this->_objConnection, global_mapping::ArticleTypeID, $strTableName) + 1;
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_ARTICLE_TYPE, array(self::TBL_SL_ARTICLE_TYPE, $intID, global_common::escape_mysql_string($articletypename), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), 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), global_common::escape_mysql_string($level), global_common::escape_mysql_string($parentid), null, null));
//echo $strSQL;
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_ARTICLE_TYPE, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add sl_article_type:' . $strSQL, 1);
return false;
}
return $intID;
}
public function insert($propertyGroupID, $propertyname, $propertyvalue, $datatypeid, $order, $createdby, $status)
{
$strTableName = self::TBL_SL_PROPERTY;
$intID = global_common::getMaxValueofField($this->_objConnection, global_mapping::PropertyID, $strTableName) + 1;
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_PROPERTY, array(self::TBL_SL_PROPERTY, $intID, global_common::escape_mysql_string($propertyGroupID), global_common::escape_mysql_string($propertyname), global_common::escape_mysql_string($propertyvalue), global_common::escape_mysql_string($datatypeid), 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)));
//echo $strSQL;
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PROPERTY, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add sl_property:' . $strSQL, 1);
return false;
}
return $intID;
}
public function insert($productid, $productstatusid, $statusDetail, $price, $imagelink, $cityid, $shippingdesc, $boxinfo, $shortdesc, $description, $createdby, $status)
{
$strTableName = self::TBL_SL_RETAILER;
$intID = global_common::getMaxValueofField($this->_objConnection, global_mapping::RetailerID, $strTableName) + 1;
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_RETAILER, array(self::TBL_SL_RETAILER, $intID, 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), $createdby, global_common::nowSQL(), $createdby, global_common::nowSQL(), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::STATUS_ACTIVE, global_common::escape_mysql_string($status)));
//echo $strSQL;
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_RETAILER, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add sl_retailer:' . $strSQL, 1);
return false;
}
return $intID;
}
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;
}
public function insert($paymentmodename, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted)
{
$strTableName = self::TBL_SL_PAYMENT_MODE;
$intID = global_common::getMaxValueofField($this->_objConnection, global_mapping::UserID, $strTableName) + 1;
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_PAYMENT_MODE, array(self::TBL_SL_PAYMENT_MODE, $intID, global_common::escape_mysql_string($paymentmodename), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), 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)));
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PAYMENT_MODE, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add sl_payment_mode:' . $strSQL, 1);
return false;
}
return $intID;
}
public function getMaxPropertyGroupID()
{
$strTableName = self::TBL_SL_PROPERTY_GROUP;
return global_common::getMaxValueofField($this->_objConnection, global_mapping::PropertyGroupID, $strTableName);
}
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 insert($name, $address, $distictid, $cityid, $phone, $specialdesc, $latitude, $longitude, $workingday, $maincategoryid, $storeicon, $storeimage, $status, $createdby, $createdate, $updatedby, $updateddate, $deletedby, $deleteddate, $refId)
{
$strTableName = self::TBL_SL_STORE;
$intID = global_common::getMaxValueofField($this->_objConnection, global_mapping::StoreID, $strTableName) + 1;
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_STORE, array(self::TBL_SL_STORE, $intID, global_common::escape_mysql_string($name), global_common::escape_mysql_string($address), global_common::escape_mysql_string($distictid), global_common::escape_mysql_string($cityid), global_common::escape_mysql_string($phone), global_common::escape_mysql_string($specialdesc), global_common::escape_mysql_string($latitude), global_common::escape_mysql_string($longitude), global_common::escape_mysql_string($workingday), global_common::escape_mysql_string($maincategoryid), global_common::escape_mysql_string($storeicon), global_common::escape_mysql_string($storeimage), global_common::escape_mysql_string($status), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createdate), global_common::escape_mysql_string($updatedby), global_common::escape_mysql_string($updateddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), $refId));
//echo $strSQL;
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_STORE, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add sl_store:' . $strSQL, 1);
return false;
}
return $intID;
}
