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); }
/** * 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); }
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]; }
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; }