PHP global_common::getMaxValueofField方法代码示例

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