public function insert($prefix, $title, $filename, $articletype, $content, $notificationtype, $tags, $catalogueid, $sectionid, $numview, $numcomment, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted, $status)
{
//$intID = global_common::getMaxID(self::TBL_SL_ARTICLE);
$date = global_common::getDateTime();
$intID = global_common::buildIDByMonth(global_common::getMaxID(Model_Article::TBL_SL_ARTICLE), $date, Model_Article::TABLE_BY_MONTHS_ARTICLE);
$strTableName = global_common::builtTableName(Model_Article::TBL_SL_ARTICLE, global_common::getTableSuffixByMonth($intID));
$strSQL = global_common::prepareQuery(self::SQL_INSERT_SL_ARTICLE, array($strTableName, $intID, global_common::escape_mysql_string($prefix), global_common::escape_mysql_string($title), global_common::escape_mysql_string($filename), global_common::escape_mysql_string($articletype), global_common::escape_mysql_string($content), global_common::escape_mysql_string($notificationtype), global_common::escape_mysql_string($tags), global_common::escape_mysql_string($catalogueid), global_common::escape_mysql_string($sectionid), global_common::escape_mysql_string($numview), global_common::escape_mysql_string($numcomment), 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)));
if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_ARTICLE, $this->_objConnection, $strTableName)) {
//echo $strSQL;
global_common::writeLog('Error add sl_article:' . $strSQL, 1);
return false;
} else {
$arrResult = global_common::updateContents($this->_objConnection, $articletype, $intID, global_common::ARTICLE_TYPE);
if (!$arrResult) {
global_common::writeLog('sp_update_content_summary: ' . $strSQL, 1);
}
}
return $intID;
}
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;
}