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'); } }