本文整理汇总了PHP中global_common::getTableSuffixByMonth方法的典型用法代码示例。如果您正苦于以下问题:PHP global_common::getTableSuffixByMonth方法的具体用法?PHP global_common::getTableSuffixByMonth怎么用?PHP global_common::getTableSuffixByMonth使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类global_common
的用法示例。
在下文中一共展示了global_common::getTableSuffixByMonth方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: updateContents
public function updateContents($objConnection, $contentID, $subContentID, $type)
{
$strSQL = 'CALL sp_update_content_summary(\'' . $contentID . '\',\'' . $subContentID . '\',\'' . global_common::getTableSuffixByMonth($subContentID) . '\',\'' . $type . '\');';
//echo $strSQL;
return $objConnection->selectMultiCommand($strSQL);
}
示例2: writeLogRequest
/**
* Ghi full request vao file
*
* @return int 1: thanh cong; 0: that bai
*
*/
public function writeLogRequest($type = 1)
{
// Duoc goi tu crontab nen khong co tham so can thiet va khong can ghi lai
if (empty($_SERVER['REQUEST_URI'])) {
return;
}
// Get all value of POST (neu dang thuc thi bang POST)
$postValues = '';
if ($_SERVER['REQUEST_METHOD'] != 'GET') {
foreach ($_POST as $var => $value) {
$postValues .= "&{$var}={$value}";
}
if (!empty($postValues)) {
$postValues = "({$postValues})";
}
}
// Tao noi dung de ghi file
$strContent = "[" . global_common::getDateTime() . "]\t";
$strContent .= global_common::getClientIP() . "\t";
$strContent .= session_id() . "\t";
// "CUSER_INFO" va "SES_AUTHENTICATED" ko duoc goi tu trong global_common va admin_global_common
$strContent .= ($type == 1 ? $_SESSION['CUSER_INFO']['user_id'] : $_SESSION['SES_AUTHENTICATED']['user_id']) . "\t";
$strContent .= $_SERVER['REQUEST_METHOD'] . "\t";
$strContent .= $_SERVER['REQUEST_URI'] . "{$postValues}\n";
// File name
$suffix = global_common::getTableSuffixByMonth(global_common::buildIDByMonth(1, global_common::getDateTime()));
if ($type == 1) {
$fileName = global_common::FOLDER_LOG . 'request_front_end' . $suffix . '.log';
} else {
$fileName = global_common::FOLDER_LOG . 'request_back_end' . $suffix . '.log';
}
// Ghi va tra ve ket qua
return self::writeFileAppend($fileName, $strContent);
}
示例3: updateComments
public function updateComments($articleID, $commentID)
{
$strTableName = global_common::builtTableName(Model_Article::TBL_SL_ARTICLE, global_common::getTableSuffixByMonth($intID));
$strSQL = 'call sp_update_user_comment(1,\'' . $strTableName . '\',\'' . global_mapping::ArticleID . '\',\'' . $articleID . '\',\'' . $commentID . '\')';
$arrResult = $this->_objConnection->selectMultiCommand($strSQL);
//global_common::writeLog("updateComments: ".$strSQL,0);
if (!$arrResult) {
global_common::writeLog("updateComments: " . $strSQL, 1);
return false;
}
return $arrResult[0];
}
示例4: insert
public function insert($commenttype, $articleid, $content)
{
$date = global_common::getDateTime();
$intID = global_common::buildIDByMonth(global_common::getMaxID(self::TBL_SL_COMMENT), $date, Model_Comment::TABLE_BY_MONTHS_COMMENT);
//echo 'Comment id:'.$intID;
//$intID = global_common::getMaxID(self::TBL_SL_COMMENT);
// lấy tên table c_comment_detail_ để lưu thông tin comment
$strTableName = global_common::builtTableName(Model_Comment::TBL_SL_COMMENT, global_common::getTableSuffixByMonth($intID));
//$strTableName = self::TBL_SL_COMMENT;
$strSQL = global_common::prepareQuery(Model_Comment::SQL_INSERT_SL_COMMENT, array($strTableName, $intID, 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::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)));
//echo $strSQL;
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, Model_Comment::SQL_CREATE_TABLE_SL_COMMENT, $this->_objConnection, $strTableName)) {
global_common::writeLog('Error add sl_comment:' . $strSQL, 1);
return false;
} else {
$arrResult = global_common::updateContents($this->_objConnection, $articleid, $intID, global_common::COMMENT_TYPE);
if (!$arrResult) {
global_common::writeLog('sp_update_content_summary: ' . $strSQL, 1);
}
}
return $intID;
}