BlackListController.php
7.69 KB
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
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
<?php
include Yii::app()->basePath.'/extensions/checkUserID/checkUserIDParam.class.php';
class BlackListController extends Controller
{
/**
* @var string the default layout for the views. Defaults to '//layouts/column2', meaning
* using two-column layout. See 'protected/views/layouts/column2.php'.
*/
public $layout = '//layouts/column1';
/**
* @var CActiveRecord the currently loaded data model instance.
*/
private $_model;
/**
* @return array action filters
*/
public function filters()
{
return array(
'accessControl', // perform access control for CRUD operations
);
}
/**
* Specifies the access control rules.
* This method is used by the 'accessControl' filter.
* @return array access control rules
*/
public function accessRules()
{
return array();
}
/**
* 查看用户黑名单
*/
public function actionView()
{
$this->render('view', array('model' => $this->_loadModel()));
}
/**
* 添加用户黑名单
*/
public function actionCreate()
{
$model = new BlackList;
$this->performAjaxValidation($model);
if (isset($_POST['BlackList']))
{
$model->attributes = $_POST['BlackList'];
$connection = Yii::app()->db;
$transaction=$connection->beginTransaction();
try
{
// 将好友移动到黑名单列表, 移除成功返回1, 失败返回0
$sqlStatement = "CALL p_i_friend_move_userFB(:userID, :friendID)";
$command = $connection->createCommand($sqlStatement);
$command->bindValue(':userID', $model->user_id);
$command->bindValue(':friendID', $model->friend_id);
$success = $command->queryScalar();
if ($success != 1)
{
throw new CHttpException(400, '添加好友到黑名单失败!可能原因是好友已在黑名单。');
}
if ($model->save())
{
$this->redirect(array('view', 'id' => array('user_id' => $model->user_id, 'friend_id' => $model->friend_id)));
}
else
{
//print_r($model->getErrors());
}
$transaction->commit();
}
catch (Exception $e)
{
$transaction->rollback();
}
}
$this->render('create', array('model' => $model));
}
public function actionUpdate()
{
$model = $this->_loadModel();
$user_id = intval($model->user_id);
$friend_id = intval($model->friend_id);
if(isset($_POST['BlackList']))
{
//不允许修改两个ID
if( $user_id == intval($_POST['BlackList']['user_id']) and $friend_id == intval($_POST['BlackList']['friend_id']))
{
$model->attributes = $_POST['BlackList'];
if($model->save())
{
$this->redirect(array(
'view',
'id' => array(
'user_id' => $model->user_id,
'friend_id' => $model->friend_id
)));
}
}
}
$this->render('update', array('model' => $model));
}
/**
* 删除黑名单关系
*/
public function actionDelete()
{
if(Yii::app()->request->isPostRequest)
{
// we only allow deletion via POST request
$model = $this->_loadModel();
$model->delete();
// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
if(!isset($_GET['ajax']))
$this->redirect(array('admin'));
}
else
{
throw new CHttpException(400, '重要参数传递错误,请重新操作!');
}
}
/**
* 恢复好友关系
*
* 第1步:替主动方单方面添加被东方为好友(如发消息被动方显示在未分组联系人中);
* 第2步:两方所有的好友关系全部删除后.
*/
public function actionRestore()
{
if(isset($_POST) && is_array($_POST))
{
// we only allow deletion via POST request
$model = $this->_loadModel();
if ($model->delete())
{
$newFriendRelation = new HiboxUserFriends;
$newFriendRelation->user_id = $model->user_id;
$newFriendRelation->friend_id = $model->friend_id;
if(isset($model->user_id))
{
$sqlStatement="select id from i_group where user_id = ".$model->user_id." and groupName = '未分组联系人'";
$groupID = Yii::app()->db->createCommand($sqlStatement)->queryScalar();
}
if(!empty($groupID))
{
$newFriendRelation->group_id = $groupID;
$newFriendRelation->save();
}
}
// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
if(!isset($_GET['ajax']))
$this->redirect(array('admin'));
}
else
{
throw new CHttpException(400, '重要参数传递错误,请重新操作!');
}
}
/**
* 用户黑名单管理
*/
public function actionAdmin()
{
$model = new BlackList('search');
$model->unsetAttributes(); // clear any default values
if(isset($_GET['BlackList']))
$model->attributes = $_GET['BlackList'];
$this->render('admin', array('model' => $model));
}
/**
* Ajax方式获取双方是什么关系
*/
public function actionAjaxCheckUserFrinedRelation()
{
if (Yii::app()->request->isPostRequest)
{
// 从POST请求中获取用户ID, 当前选择的分组ID
$userID = Yii::app()->request->getPost("userID", null);
$friendID = Yii::app()->request->getPost("friendID", null);
if (isset($userID, $friendID))
{
//include (Yii::app()->basePath.'/extensions/checkUserID/checkUserIDParam.class.php');
echo CheckUserFrinedRelation($userID, $friendID);
}
}
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
*/
private function _loadModel()
{
if($this->_model === null)
{
if (isset($_GET['id']) && is_array($_GET['id']))
$this->_model = BlackList::model()->findbyPk($_GET['id']);
if ($this->_model === null)
throw new CHttpException(404, 'The requested page does not exist.');
}
return $this->_model;
}
/**
* Performs the AJAX validation.
* @param CModel the model to be validated
*/
protected function performAjaxValidation($model)
{
if(isset($_POST['ajax']) && $_POST['ajax'] === 'hibox-user-blacklist-form')
{
echo CActiveForm::validate($model);
Yii::app()->end();
}
}
}
?>