bottom = ['Version_Plugin', 'js'];
Typecho_Plugin::factory('admin/write-page.php')->bottom = ['Version_Plugin', 'js'];
// 监听事件
Typecho_Plugin::factory('Widget_Contents_Post_Edit')->finishPublish = ['Version_Plugin', 'onPostPublish'];
Typecho_Plugin::factory('Widget_Contents_Post_Edit')->finishSave = ['Version_Plugin', 'onPostSave'];
Typecho_Plugin::factory('Widget_Contents_Page_Edit')->finishPublish = ['Version_Plugin', 'onPagePublish'];
Typecho_Plugin::factory('Widget_Contents_Page_Edit')->finishSave = ['Version_Plugin', 'onPageSave'];
Typecho_Plugin::factory('Widget_Contents_Post_Edit')->delete = ['Version_Plugin', 'onPostDelete'];
Typecho_Plugin::factory('Widget_Contents_Page_Edit')->delete = ['Version_Plugin', 'onPageDelete'];
// 注册路由
Helper::addRoute("Version_Plugin_Revert", "/version-plugin/revert", "Version_Action", 'revert');
Helper::addRoute("Version_Plugin_Delete", "/version-plugin/delete", "Version_Action", 'delete');
Helper::addRoute("Version_Plugin_Preview", "/version-plugin/preview", "Version_Action", 'preview');
Helper::addRoute("Version_Plugin_Comment", "/version-plugin/comment", "Version_Action", 'comment');
return $result;
}
public static function deactivate()
{
$config = Typecho_Widget::widget('Widget_Options')->plugin('Version');
if ($config->clean == 'yes')
{
$db = Typecho_Db::get();
$script = self::getSQL('Clean');
foreach ($script as $statement)
$db->query($statement, Typecho_Db::WRITE);
}
Helper::removeRoute("Version_Plugin_Revert");
Helper::removeRoute("Version_Plugin_Delete");
Helper::removeRoute("Version_Plugin_Preview");
Helper::removeRoute("Version_Plugin_Comment");
}
public static function render()
{
}
public static function personalConfig(Typecho_Widget_Helper_Form $form)
{
}
public static function config(Typecho_Widget_Helper_Form $form)
{
$clean = new Typecho_Widget_Helper_Form_Element_Radio(
'clean', array(
'yes' => '删除',
'no' => '不删除',
), 'no', '删除数据表:', '是否在禁用插件时，删除所有文章的修改记录？');
$form->addInput($clean);
$clean = new Typecho_Widget_Helper_Form_Element_Radio(
'noAutoSaveVersion', array(
'yes' => '不保留',
'no' => '保留',
), 'yes', '不保留自动保存的版本:', '是否在手动保存时(保存草稿、发布文章)，删除插件自动保存的版本？');
$form->addInput($clean);
}
public static function js($pageOrPost)
{
$options = Typecho_Widget::widget('Widget_Options');
echo '' . PHP_EOL;
echo '' . PHP_EOL;
echo '' . PHP_EOL;
$db = Typecho_Db::get();
$table = $db->getPrefix() . 'verion_plugin';
$rows = $db->fetchAll($db->select()->from($table)->where("cid = ? ", $pageOrPost->cid)->order('time', Typecho_Db::SORT_DESC));
ob_start();
include 'vp-menu.php';
$content = ob_get_clean();
ob_start();
include 'vp-preview.php';
$content2 = ob_get_clean();
echo "". PHP_EOL;
}
public static function onPostDelete($postCid, $that)
{
self::onPageDelete($postCid, $that);
}
public static function onPageDelete($pageCid, $that)
{
$db = Typecho_Db::get();
$table = $db->getPrefix() . 'verion_plugin';
$db->query($db->delete($table)->where('cid = ? ', $pageCid));
}
public static function onPostPublish($contents, $that)
{
self::record($contents, $that);
}
public static function onPostSave($contents, $that)
{
self::record($contents, $that);
}
public static function onPagePublish($contents, $that)
{
self::record($contents, $that);
}
public static function onPageSave($contents, $that)
{
self::record($contents, $that);
}
public static function record($contents, $that)
{
$user = Typecho_Widget::widget('Widget_User');
$user->hasLogin(); // 调用一下hasLoging()可以让$user进行初始化
$db = Typecho_Db::get();
$table = $db->getPrefix() . 'verion_plugin';
$time = Helper::options()->gmtTime + (Helper::options()->timezone - Helper::options()->serverTimezone);
$uid = $user->uid;
if($that->request->t == 'auto') // 如果是自动保存
{
$row = $db->fetchRow($db->select()->from($table)->where("auto = 'auto' AND cid = ? ", $that->cid));
// 如果没有之前保存过的自动保存版本，就新创建一个
if(empty($row))
{
$row = [
"cid" => $that->cid,
'text' => $contents['text'],
'auto' => 'auto',
'time' => $time,
'modifierid' => $uid
];
$db->query($db->insert($table)->rows($row));
}else{ // 有就直接覆盖
$row['time'] = $time;
$row['modifierid'] = $uid;
$row['text'] = $contents['text'];
$db->query($db->update($table)->rows($row)->where("vid = ? ", $row['vid']));
}
}else{
// 自动保存的内容不包括在内
$raw = $db->fetchRow($db->select()->from($table)->where("cid = ? AND auto IS NULL", $that->cid)->order('time', Typecho_Db::SORT_DESC));
// 如果内容没有变更就更新一下时间什么的，就不需要新建一个记录了
if(!empty($raw) && $contents['text']==$raw['text'])
{
$raw['time'] = $time;
$raw['modifierid'] = $uid;
$db->query($db->update($table)->rows($raw)->where("vid = ? ", $raw['vid']));
}else{
$row = [
"cid" => $that->cid,
'text' => $contents['text'],
'auto' => NULL,
'time' => $time,
'modifierid' => $uid
];
$db->query($db->insert($table)->rows($row));
}
$config = Typecho_Widget::widget('Widget_Options')->plugin('Version');
if ($config->noAutoSaveVersion == 'yes')
{
// 删掉自动保存的内容
$db->query($db->delete($table)->where("auto = 'auto' AND cid = ? ", $that->cid));
}
}
}
public static function getSQL($file)
{
$db = Typecho_Db::get();
$prefix = $db->getPrefix();
$config = Typecho_Widget::widget('Widget_Options');
$script = file_get_contents($config->pluginUrl . '/Version/sql/' . $file . '.sql');
$script = str_replace('%prefix%', $prefix, $script);
$script = str_replace('%charset%', 'utf8', $script);
$script = explode(';', $script);
$statements = [];
foreach ($script as $statement)
{
$statement = trim($statement);
if ($statement)
array_push($statements, $statement);
}
return $statements;
}
public static function install()
{
$db = Typecho_Db::get();
$dbType = array_pop(explode('_', $db->getAdapterName()));
$prefix = $db->getPrefix();
try {
$script = self::getSQL($dbType);
foreach ($script as $statement)
$db->query($statement, Typecho_Db::WRITE);
return '插件启用成功';
} catch (Typecho_Db_Exception $e) {
$code = $e->getCode();
if(($dbType == 'Mysql' && $code == 1050) || ($dbType == 'SQLite' && ($code =='HY000' || $code == 1)))
{
try {
$script = self::getSQL("Check");
foreach ($script as $statement)
$db->query($statement, Typecho_Db::READ);
return '插件启用成功';
} catch (Typecho_Db_Exception $e) {
$code = $e->getCode();
throw new Typecho_Plugin_Exception('无法建立数据表 ErrorCode：'.$code);
}
} else {
throw new Typecho_Plugin_Exception('无法建立数据表 ErrorCode：'.$code);
}
}
}
}