public function actionIndex()
{
$data = array();
if (!empty($_GET['dest'])) {
$redirect = base64_decode($_GET['dest']);
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if (!isset($_GET['dest'])) {
$redirect = $this->createUrl('index/index');
}
$email = formPostParams('email', VARIABLE_STRING);
$password = formPostParams('password', VARIABLE_STRING);
$condition = array(':email' => $email, ':password' => md5($password));
$query = "SELECT * FROM {{" . $this->_table . "}} WHERE email = :email AND password = :password";
$user = $this->db->createCommand($query)->bindValues($condition)->queryRow();
if (!empty($user)) {
Yii::app()->session['user'] = $user;
$this->redirect($redirect);
} else {
createMessage('Email hoặc mật khẩu không đúng', 'danger');
}
} else {
$user = Yii::app()->session['user'];
if (!empty($user)) {
$this->redirect($redirect);
}
}
$this->renderPartial('index', array('data' => $data));
}
public function actionEdit()
{
$data = array();
$id = urlGETParams('id', VARIABLE_NUMBER);
$query = "SELECT * FROM tbl_category WHERE id = " . $id;
$row = $this->db->createCommand($query)->queryRow();
if (empty($row)) {
$this->redirect($this->createUrl('index'));
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
//`parent_id`, `name`, `alias`, `meta_keywords`, `meta_description`, `meta_title`, `status`
$params = array('parent_id' => formPostParams('parent_id', VARIABLE_NUMBER), 'name' => formPostParams('name'), 'alias' => change_url_seo(formPostParams('name')), 'meta_keywords' => formPostParams('meta_keywords'), 'meta_description' => formPostParams('meta_description'), 'meta_title' => formPostParams('meta_title'), 'status' => formPostParams('status', VARIABLE_NUMBER), 'is_feature' => formPostParams('is_feature', VARIABLE_NUMBER), 'weight' => formPostParams('weight', VARIABLE_NUMBER), 'cnet_url' => formPostParams('cnet_url'), 'techcrunch_url' => formPostParams('techcrunch_url'), 'wpcentral_url' => formPostParams('wpcentral_url'), 'android_center_url' => formPostParams('android_center_url'));
yii_update_row($this->_table, $params, 'id = ' . $id);
createMessage('Sửa danh mục thành công');
$this->redirect($this->createUrl('index'));
}
$query = "SELECT id, name FROM tbl_category WHERE parent_id = 0";
$result = $this->db->createCommand($query)->queryAll();
foreach ($result as $item) {
$data['category'][$item['id']] = $item['name'];
}
$data['row'] = $row;
$this->render('add', array('data' => $data));
}
public function actionEdit()
{
$uid = urlGETParams('id', VARIABLE_NUMBER);
$record = $this->getRow($uid);
if (empty($record)) {
createMessage('Hệ thống không tìm thấy nội dung bạn yêu cầu', 'danger');
$this->redirect($this->createUrl('index'));
}
$data = array();
$data['user'] = $record;
$form = new UserForm();
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$form->attributes = $_POST['UserForm'];
if ($form->validate()) {
$values = array();
foreach ($form->attributes as $key => $vl) {
if ($key == 're_password') {
continue;
}
if ($key == 'password') {
if (empty($vl)) {
continue;
}
$vl = md5(trim($vl));
}
$values[$key] = trim($vl);
}
yii_update_row($this->_table, $values, 'id = ' . $uid);
//user rule
//xoa rule hien tai
$query = "DELETE FROM {{user_rule}} WHERE uid = " . $uid;
$this->db->createCommand($query)->execute();
$user_rule = formPostParams('rule', VARIABLE_ARRAY);
if (!empty($user_rule)) {
$params = array();
foreach ($user_rule as $rule_id) {
$params[] = array('uid' => $uid, 'rule_id' => $rule_id);
}
yii_insert_multiple('user_rule', $params);
}
createMessage('Sửa thông tin người dùng thành công');
$this->redirect($this->createUrl('index'));
}
} else {
$form->attributes = $record;
$form->password = '';
}
$data['rule'] = $this->getListRule();
//lay danh sach quyen
$query = "SELECT rule_id FROM {{user_rule}} WHERE uid = " . $uid;
$data['listRole'] = $this->db->createCommand($query)->queryColumn();
$data['form'] = $form;
$this->render('add', array('data' => $data));
}
private function editTagAction()
{
$id = urlGETParams('id', VARIABLE_NUMBER);
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$name = formPostParams('name');
$query = "UPDATE tbl_tags_youtube SET name = :name WHERE id = " . $id;
$this->db->createCommand($query)->bindValues(array(':name' => $name))->execute();
createMessage('Sửa tag: ' . $name . ' thành công');
$this->redirect($this->createUrl('tag'));
}
$query = "SELECT * FROM tbl_tags_youtube WHERE id = " . $id;
$data['row'] = $this->db->createCommand($query)->queryRow();
$this->render('edit_tag', array('data' => $data));
}
private function loginProcess()
{
if (!isset($_GET['dest'])) {
$redirect = $this->createUrl('index/index');
}
$email = formPostParams('email', VARIABLE_STRING);
$password = formPostParams('password', VARIABLE_STRING);
$condition = array(':email' => $email, ':password' => md5($password));
$query = "SELECT * FROM {{" . $this->_table . "}} WHERE email = :email AND password = :password AND is_advertiser = 1";
$user = $this->db->createCommand($query)->bindValues($condition)->queryRow();
if (!empty($user)) {
Yii::app()->session['advertiser'] = $user;
$this->redirect($redirect);
} else {
createMessage('Email hoặc mật khẩu không đúng', 'danger');
}
}
