public function actionEdit()
{
$id = $_GET['id'];
$query = new Query();
$query->select(['type_name', 'level', 'p_id'])->from('type')->where(['_id' => $id]);
$data['rows'] = $query->one();
$query->select(['type_name', 'level', 'p_id'])->from('type')->where(['p_id' => '0']);
$data['arr'] = $query->all();
return $this->renderPartial("edit", $data);
}
public function actionIndex()
{
$query = new Query();
$query->select(["username", "password"])->from("admin_user");
$re = $query->all();
//print_r($re);die;
return $this->renderPartial('index', ["data" => $re]);
}
static function GetForms()
{
$query = new Query();
// compose the query
$query->select([])->from('forms');
// execute the query
$rows = $query->all();
return $rows;
}
/**
* @inheritdoc
*/
protected function findTemplate($name)
{
$query = new Query();
$template = $query->select($this->templateDataFields)->from($this->templateCollection)->where([$this->templateNameField => $name])->one();
if ($template === false) {
return null;
}
return $template;
}
public function actionCheck_login()
{
$username = $_POST['username'];
$pwd = $_POST['pwd'];
$query = new Query();
$query->select(['name', 'status', 'password'])->from('admin')->where(['name' => $username]);
$arr = $query->one();
if ($arr) {
if ($arr['password'] == md5($pwd)) {
$_SESSION['user_id'] = $arr['_id'];
$_SESSION['user_name'] = $arr['name'];
if ($arr['name'] != "admin") {
$userid = $arr['_id'];
//根据用户id查找用户的角色ID
$query->select(['role_id'])->from('user_role')->where(['user_id' => "{$userid}"]);
$res = $query->one();
$role_id = $res['role_id'];
//根据角色ID查询所有权限ID,将其ID存入字符串中
$q = new Query();
$q->select(['node_id'])->from('role_node')->where(['role_id' => $role_id]);
$ar = $q->all();
$que = new Query();
foreach ($ar as $key => $v) {
// $node[$key] = $v['node_id'];
$idd = $v['node_id'];
$que->select(['n_name', 'nickname', 'n_level', 'p_id'])->from('node')->where(['_id' => "{$idd}"])->andwhere(['n_level' => "1"]);
$quan[$key] = $que->all();
}
$yi_quan = array_filter($quan);
$_SESSION['yi_quan'] = $yi_quan;
$quee = new Query();
foreach ($ar as $kk => $vv) {
// $node[$key] = $v['node_id'];
$iddd = $vv['node_id'];
$quee->select(['n_name', 'nickname', 'n_level', 'p_id'])->from('node')->where(['_id' => "{$iddd}"])->andwhere(['n_level' => "2"]);
$quanx[$kk] = $quee->all();
}
$er_quan = array_filter($quanx);
$_SESSION['er_quan'] = $er_quan;
} else {
$que = new Query();
$que->select(['n_name', 'nickname', 'n_level', 'p_id'])->from('node')->where(['n_level' => "1"]);
$yi_quan = $que->all();
$_SESSION['yi_q'] = $yi_quan;
$quee = new Query();
$quee->select(['n_name', 'nickname', 'n_level', 'p_id'])->from('node')->where(['n_level' => "2"]);
$er_quan = $quee->all();
$_SESSION['er_q'] = $er_quan;
}
echo "<script>location.href='index.php?r=site/index'</script>";
} else {
echo "<script>alert('密码错误');location.href='index.php?r=public/login'</script>";
}
} else {
echo "<script>alert('用户名或密码错误');location.href='index.php?r=public/login'</script>";
}
}
/**
* @inheritdoc
*/
public function getHistory($chatId, $limit = 10)
{
$query = new Query();
$query->select(['user_id', 'username', 'message', 'timestamp', 'avatar_16', 'avatar_32'])->from(self::collectionName())->where(['chat_id' => $chatId]);
$query->orderBy(['timestamp' => SORT_DESC]);
if ($limit) {
$query->limit($limit);
}
return $query->all();
}
/**
* Retrieves a value from cache with a specified key.
* This method should be implemented by child classes to retrieve the data
* from specific cache storage.
* @param string $key a unique key identifying the cached value
* @return string|boolean the value stored in cache, false if the value is not in the cache or expired.
*/
protected function getValue($key)
{
$query = new Query();
$row = $query->select(['data'])->from($this->cacheCollection)->where(['id' => $key, '$or' => [['expire' => 0], ['expire' => ['$gt' => time()]]]])->one($this->db);
if (empty($row)) {
return false;
} else {
return $row['data'];
}
}
public function testSelect()
{
// default
$query = new Query();
$select = [];
$query->select($select);
$this->assertEquals($select, $query->select);
$query = new Query();
$select = ['name', 'something'];
$query->select($select);
$this->assertEquals($select, $query->select);
}
public static function findAll(array $attributes = [])
{
$query = new Query();
$class_name = get_called_class();
$instance = new $class_name();
$table_name = $instance->getTableName();
$results = $query->select($instance->getAttributesArray())->from($table_name)->where($attributes)->all();
$objs = [];
foreach ($results as $key => $result) {
$objs[$key] = new $class_name();
$objs[$key]->setAttributes($result);
}
return $objs;
}
public function actionCheck_login()
{
//print_r($_POST);
$username = $_POST['username'];
$arr = array('username' => $username);
$query = new Query();
$query->select(['username', 'password'])->from('admin_user')->where($arr);
$rows = $query->all();
//echo $rows[0]['password'];die;
if ($rows) {
if ($rows[0]['password'] == md5($_POST['password'])) {
$_SESSION['user_info'] = $username;
echo $this->success("登陆成功", "index.php?r=index/index", '1');
} else {
echo $this->error("密码错误，登陆失败", "index.php?r=public/login", '1');
}
} else {
echo $this->error("账号错误，登陆失败", "index.php?r=public/login", '1');
}
}
/**
* Displays homepage.
*
* @return mixed
*/
public function actionIndex()
{
$dsn = "mongodb://192.168.1.164";
$connection = new \yii\mongodb\Connection(['dsn' => $dsn]);
$connection->open();
//var_dump($connection);die;
$database = $connection->getDatabase('niuke');
/*
$collection = $database->getCollection('user');
//var_dump($collection);die;
*/
$query = new Query();
// compose the query
$query->select(['niukename', 'password'])->from('user')->limit(10);
// execute the query
$rows = $query->all();
var_dump($rows);
/*
//return $this->render('index');*/
}
/**
* Ensures migration history contains at least base migration entry.
*/
protected function ensureBaseMigrationHistory()
{
if (!$this->baseMigrationEnsured) {
$query = new Query();
$row = $query->select(['version'])->from($this->migrationCollection)->andWhere(['version' => self::BASE_MIGRATION])->limit(1)->one($this->db);
if (empty($row)) {
$this->addMigrationHistory(self::BASE_MIGRATION);
}
$this->baseMigrationEnsured = true;
}
}
public function actionAddrole_node()
{
$role_id = $_POST['role_id'];
$quan_id = $_POST['quanxian'];
$query = new Query();
$query->select(['_id'])->from('role_node')->where(['node_id' => $quan_id]);
$ar = $query->one();
$collection = Yii::$app->mongodb->getCollection('role_node');
if (empty($ar)) {
$res = $collection->insert(['role_id' => $role_id, 'node_id' => $quan_id, 'pid' => 0, 'level' => 1]);
}
@($s_id = $_POST['s_id']);
if (empty($s_id)) {
if ($res) {
echo "<script>alert('权限分配成功');location.href='index.php?r=role/role_list';</script>";
} else {
echo "<script>alert('权限分配失败~~');location.href='index.php?r=role/add';</script>";
}
} else {
$que = new Query();
$que->select(['_id'])->from('role_node')->where(['node_id' => $s_id]);
$arr = $que->one();
if ($arr) {
echo "<script>alert('二级权限已存在，请从新添加~~');location.href='index.php?r=role/role_list';</script>";
} else {
$data = $collection->insert(['role_id' => $role_id, 'node_id' => $s_id, 'pid' => $quan_id, 'level' => 2]);
if ($data) {
echo "<script>alert('权限分配成功');location.href='index.php?r=role/role_list';</script>";
} else {
echo "<script>alert('权限分配失败~~');location.href='index.php?r=role/add';</script>";
}
}
}
}
/**
* @param $queryParam
* @return array
*/
public static function itemsList($queryParam)
{
if (is_numeric($queryParam)) {
$query = new Query();
$query->select(['_id' => false, 'number' => 'text'])->from(Number::collectionName())->where(['like', 'number', $queryParam]);
} else {
$query = new \yii\db\Query();
$query->select(["CONCAT_WS(' ',last_name, first_name, middle_name) AS number"])->from(Employee::tableName())->where(['like', 'last_name', $queryParam]);
}
$items['results'] = array_map(function ($item) {
$item['id'] = $item['number'];
return $item;
}, $query->limit(10)->all());
return $items;
}
public function actionFen_role()
{
$user = $_GET['id'];
$query = new Query();
$query->select(['r_name'])->from('role')->where(['r_status' => 1, 'r_status' => '1']);
$rows = $query->all();
return $this->renderPartial('fen_role', ['user' => $user, 'rows' => $rows]);
}
public function actionSec_save()
{
$id = $_GET['id'];
$query = new Query();
$query->select(['z_name', 'z_introduce', 'parent_id', 'z_content', 'practice_type'])->from('chapter_class')->where(["_id" => $id]);
$rows = $query->one();
$que = new Query();
$que->select(['cha_name', 'lecturer'])->from('goods_class');
$data = $que->all();
return $this->renderPartial("sec_save", ['rows' => $rows, 'data' => $data]);
}
public function actionJob_save()
{
$request = Yii::$app->request;
$id = $request->get('id');
$query = new Query();
$query->select(['j_name', 'add_time'])->from('work_direction')->where(['_id' => $id]);
$arr = $query->one();
//print_r($res);die;
return $this->renderPartial('job_save', compact('arr'));
}
public function actionHuan()
{
$id = $_GET['id'];
if ($id == 1) {
return 0;
exit;
//不查数据
}
$dd = $id - 1;
$query = new Query();
$query->select(['nickname'])->from('node')->where(['n_level' => "{$dd}"]);
$rows = $query->all();
//var_dump($rows);
echo json_encode($rows);
}
