1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
|
<?php
class Links_Action extends Typecho_Widget implements Widget_Interface_Do
{
private $db;
private $options;
private $prefix;
public function insertLink()
{
if (Links_Plugin::form('insert')->validate()) {
$this->response->goBack();
}
/** 取出数据 */
$link = $this->request->from('name', 'url', 'sort', 'image', 'description', 'user');
$link['order'] = $this->db->fetchObject($this->db->select(array('MAX(order)' => 'maxOrder'))->from($this->prefix.'links'))->maxOrder + 1;
/** 插入数据 */
$link['lid'] = $this->db->query($this->db->insert($this->prefix.'links')->rows($link));
/** 设置高亮 */
$this->widget('Widget_Notice')->highlight('link-'.$link['lid']);
/** 提示信息 */
$this->widget('Widget_Notice')->set(_t('链接 <a href="%s">%s</a> 已经被增加',
$link['url'], $link['name']), NULL, 'success');
/** 转向原页 */
$this->response->redirect(Typecho_Common::url('extending.php?panel=Links%2Fmanage-links.php', $this->options->adminUrl));
}
public function addHannysBlog()
{
/** 取出数据 */
$link = array(
'name' => "Hanny's Blog",
'url' => "http://www.imhan.com",
'description' => "寒泥 - Typecho插件开发者",
);
$link['order'] = $this->db->fetchObject($this->db->select(array('MAX(order)' => 'maxOrder'))->from($this->prefix.'links'))->maxOrder + 1;
/** 插入数据 */
$link['lid'] = $this->db->query($this->db->insert($this->prefix.'links')->rows($link));
/** 设置高亮 */
$this->widget('Widget_Notice')->highlight('link-'.$link['lid']);
/** 提示信息 */
$this->widget('Widget_Notice')->set(_t('链接 <a href="%s">%s</a> 已经被增加',
$link['url'], $link['name']), NULL, 'success');
/** 转向原页 */
$this->response->redirect(Typecho_Common::url('extending.php?panel=Links%2Fmanage-links.php', $this->options->adminUrl));
}
public function updateLink()
{
if (Links_Plugin::form('update')->validate()) {
$this->response->goBack();
}
/** 取出数据 */
$link = $this->request->from('lid', 'name', 'sort', 'image', 'url', 'description', 'user');
/** 更新数据 */
$this->db->query($this->db->update($this->prefix.'links')->rows($link)->where('lid = ?', $link['lid']));
/** 设置高亮 */
$this->widget('Widget_Notice')->highlight('link-'.$link['lid']);
/** 提示信息 */
$this->widget('Widget_Notice')->set(_t('链接 <a href="%s">%s</a> 已经被更新',
$link['url'], $link['name']), NULL, 'success');
/** 转向原页 */
$this->response->redirect(Typecho_Common::url('extending.php?panel=Links%2Fmanage-links.php', $this->options->adminUrl));
}
public function deleteLink()
{
$lids = $this->request->filter('int')->getArray('lid');
$deleteCount = 0;
if ($lids && is_array($lids)) {
foreach ($lids as $lid) {
if ($this->db->query($this->db->delete($this->prefix.'links')->where('lid = ?', $lid))) {
$deleteCount ++;
}
}
}
/** 提示信息 */
$this->widget('Widget_Notice')->set($deleteCount > 0 ? _t('链接已经删除') : _t('没有链接被删除'), NULL,
$deleteCount > 0 ? 'success' : 'notice');
/** 转向原页 */
$this->response->redirect(Typecho_Common::url('extending.php?panel=Links%2Fmanage-links.php', $this->options->adminUrl));
}
public function sortLink()
{
$links = $this->request->filter('int')->getArray('lid');
if ($links && is_array($links)) {
foreach ($links as $sort => $lid) {
$this->db->query($this->db->update($this->prefix.'links')->rows(array('order' => $sort + 1))->where('lid = ?', $lid));
}
}
}
public function action()
{
$this->db = Typecho_Db::get();
$this->prefix = $this->db->getPrefix();
$this->options = Typecho_Widget::widget('Widget_Options');
$this->on($this->request->is('do=insert'))->insertLink();
$this->on($this->request->is('do=addhanny'))->addHannysBlog();
$this->on($this->request->is('do=update'))->updateLink();
$this->on($this->request->is('do=delete'))->deleteLink();
$this->on($this->request->is('do=sort'))->sortLink();
$this->response->redirect($this->options->adminUrl);
}
}
|
