当前位置: 首页>>代码示例>>PHP>>正文


PHP global_common::nowSQL方法代码示例

本文整理汇总了PHP中global_common::nowSQL方法的典型用法代码示例。如果您正苦于以下问题:PHP global_common::nowSQL方法的具体用法?PHP global_common::nowSQL怎么用?PHP global_common::nowSQL使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在global_common的用法示例。


在下文中一共展示了global_common::nowSQL方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: insert

 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;
 }
开发者ID:vietlethanh,项目名称:KooKooBackEnd,代码行数:12,代码来源:model_tracker.php

示例2: array

        $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) {
开发者ID:vietlethanh,项目名称:KooKooBackEnd,代码行数:31,代码来源:admin_advertising.php

示例3: insert

 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;
 }
开发者ID:vietlethanh,项目名称:KooKooBackEnd,代码行数:13,代码来源:model_comment.php

示例4: activateBadComment

 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]);
 }
开发者ID:vietlethanh,项目名称:timkm20130929,代码行数:12,代码来源:model_commentbad.php

示例5: html_entity_decode

         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 {
开发者ID:vietlethanh,项目名称:oceo,代码行数:31,代码来源:bg_user.php

示例6: update

 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;
 }
开发者ID:vietlethanh,项目名称:KooKooBackEnd,代码行数:11,代码来源:model_partner.php

示例7: refreshArticle

 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;
 }
开发者ID:vietlethanh,项目名称:timkm20130929,代码行数:43,代码来源:model_article.php

示例8: insert

 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;
 }
开发者ID:roni5,项目名称:sela,代码行数:21,代码来源:model_article.php

示例9: update

 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;
 }
开发者ID:vietlethanh,项目名称:oceo,代码行数:12,代码来源:model_propertygroup.php

示例10: checkResetPasswordByID

    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];
    }
开发者ID:vietlethanh,项目名称:KooKooBackEnd,代码行数:13,代码来源:model_resetpassword.php

示例11: insert

 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);
 }
开发者ID:vietlethanh,项目名称:oceo,代码行数:14,代码来源:model_user.php

示例12: update

 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;
 }
开发者ID:vietlethanh,项目名称:oceo,代码行数:11,代码来源:model_manufactory.php

示例13: update

 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;
 }
开发者ID:vietlethanh,项目名称:oceo,代码行数:11,代码来源:model_retailer.php

示例14: cloneProduct

 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;
 }
开发者ID:vietlethanh,项目名称:oceo,代码行数:14,代码来源:model_product.php

示例15: array

         //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));
 //}
开发者ID:vietlethanh,项目名称:timkm20130929,代码行数:31,代码来源:bg_comment.php


注:本文中的global_common::nowSQL方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。