public function checkAction($attribute, $params)
{
$menu = TbMenu::findOne(['fdAction' => $this->{$attribute}]);
if ($menu) {
$this->addError($attribute, '菜单ActionID已经存在');
}
}
public function search()
{
$search = TbMenu::find();
if ($this->name > '') {
$search->andWhere("fdName like :name", [":name" => "%" . $this->name . "%"]);
}
if ($this->disabled > '') {
$search->andWhere("fdDisabled = :disabled", [":disabled" => $this->disabled]);
}
$pages = new Pagination(['totalCount' => $search->count(), 'pageSize' => 10]);
$datas = $search->offset($pages->offset)->limit($pages->limit)->all();
return ['datas' => $datas, 'pages' => $pages];
}
public static function getMenu()
{
$menus = TbMenu::find()->where('fdDisabled = :disabled', [':disabled' => 0])->orderBy('fdOrder desc')->all();
$menu_arr = [['label' => '首页', 'url' => ['login/index']], 'basic' => ['label' => '基础产品', 'submenuTemplate' => '<ul style="display:none;">{items}</ul>', 'items' => []], 'friend' => ['label' => '社交模块', 'submenuTemplate' => '<ul style="display:none;">{items}</ul>', 'items' => []], 'job' => ['label' => '招聘模块', 'submenuTemplate' => '<ul style="display:none;">{items}</ul>', 'items' => []], 'spread' => ['label' => '推广模块', 'submenuTemplate' => '<ul style="display:none;">{items}</ul>', 'items' => []], 'member' => ['label' => '会员模块', 'submenuTemplate' => '<ul style="display:none;">{items}</ul>', 'items' => []], 'community' => ['label' => '社区模块', 'submenuTemplate' => '<ul style="display:none;">{items}</ul>', 'items' => []], 'yuanyuan' => ['label' => '园园模块', 'submenuTemplate' => '<ul style="display:none;">{items}</ul>', 'items' => []], 'background' => ['label' => '后台模块', 'submenuTemplate' => '<ul style="display:none;">{items}</ul>', 'items' => []]];
foreach ($menus as $menu) {
$item = [];
$item['label'] = $menu->fdName;
$item['url'] = ['stats/' . $menu->fdAction];
if ($menu->fdPrivilege > '') {
$item['visible'] = Yii::$app->user->hasPrivilege($menu->fdPrivilege);
}
$menu_arr[$menu->fdClass]['items'][] = $item;
}
return ['data' => ['label' => '数据管理', 'inner_items' => $menu_arr, 'visible' => true, 'url' => ['login/index']], 'system' => ['label' => '系统配置', 'items' => [['label' => '表格管理', 'url' => ['table/list'], 'visible' => Yii::$app->user->hasPrivilege('统计后台表格列表'), 'active' => Yii::$app->controller->id == 'table' ? true : false], ['label' => '菜单管理', 'url' => ['menu/list'], 'visible' => Yii::$app->user->hasPrivilege('统计后台菜单列表'), 'active' => Yii::$app->controller->id == 'menu' ? true : false], ['label' => '选择框管理', 'url' => ['select/list'], 'visible' => Yii::$app->user->hasPrivilege('统计后台选择框管理'), 'active' => Yii::$app->controller->id == 'select' ? true : false], ['label' => '数据导出', 'url' => ['query/list'], 'visible' => Yii::$app->user->hasPrivilege('统计后台数据导出'), 'active' => Yii::$app->controller->id == 'query' ? true : false]], 'visible' => Yii::$app->user->hasPrivilege('统计后台表格列表')], 'info' => ['label' => '个人资料', 'linkOptions' => ['data-toggle' => 'modal', 'data-target' => '#userInfoModal']]];
}
public function run()
{
//异步访问支持
if (\Yii::$app->request->isAjax) {
$table = TbTable::findOne(\Yii::$app->request->post('table_id'));
$model = new StatsForm($table);
if (\Yii::$app->request->get('page') > 0) {
$data = $model->search('table');
} else {
$data = $model->search();
}
//根据是还是翻页来生成全部页面还是部分页面
$table_content = \Yii::$app->controller->renderPartial('_stats_table', ['table' => $table, 'data' => $data]);
if ($data['sum_datas'] != null) {
$sum_content = \Yii::$app->controller->renderPartial('_stats_sum', ['table' => $table, 'data' => $data]);
} else {
$sum_content = '';
}
if (\Yii::$app->request->get('page') > 0) {
echo $table_content;
} else {
echo \Yii::$app->controller->renderPartial('_stats', ['table' => $table, 'data' => $data, 'sum_content' => $sum_content, 'table_content' => $table_content]);
}
\Yii::$app->end();
}
$action = \Yii::$app->controller->action->id;
$menu = TbMenu::find()->where('fdAction = :action', [':action' => $action])->one();
$content = [];
foreach ($menu->tables as $table) {
$model = new StatsForm($table);
$data = $model->search();
if ($data['sum_datas'] != null) {
$sum_content = \Yii::$app->controller->renderPartial('_stats_sum', ['table' => $table, 'data' => $data]);
} else {
$sum_content = '';
}
$table_content = \Yii::$app->controller->renderPartial('_stats_table', ['table' => $table, 'data' => $data]);
$content[$table->id] = \Yii::$app->controller->renderPartial('_stats', ['table' => $table, 'data' => $data, 'sum_content' => $sum_content, 'table_content' => $table_content]);
}
return \Yii::$app->controller->render('stats', ['menu' => $menu, 'content' => $content]);
}
public function enable($id)
{
$operator = TbMenu::updateAll(['fdDisabled' => 0], "id = :id", [":id" => $id]);
echo json_encode(['code' => 0, 'msg' => '请求操作成功'], JSON_UNESCAPED_UNICODE);
}
