AdminController.php 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: leo
  5. * Date: 2018/2/24
  6. * Time: 下午12:48
  7. */
  8. namespace backendApi\modules\v1\controllers;
  9. use backendApi\modules\v1\models\Admin;
  10. use backendApi\modules\v1\models\AdminCountry;
  11. use backendApi\modules\v1\models\AdminForm;
  12. use backendApi\modules\v1\models\AdminRoleForm;
  13. use common\helpers\Cache;
  14. use common\helpers\Date;
  15. use common\helpers\Form;
  16. use common\helpers\Log;
  17. use common\helpers\Tool;
  18. use common\models\Countries;
  19. use Yii;
  20. use backendApi\modules\v1\models\AdminRole;
  21. use backendApi\modules\v1\models\User;
  22. use yii\helpers\Json;
  23. class AdminController extends BaseController
  24. {
  25. public $modelClass = User::class;
  26. public function behaviors() {
  27. $behaviors = parent::behaviors();
  28. //$behaviors['contentNegotiator']['formats']['text/html'] = Response::FORMAT_JSON;
  29. return $behaviors;
  30. }
  31. /**
  32. * 管理员列表
  33. * @return mixed
  34. * @throws \yii\web\HttpException
  35. */
  36. public function actionIndex(){
  37. $filter = $this->filterCondition([
  38. 'ADMIN_NAME' => 'A.ADMIN_NAME',
  39. 'REAL_NAME' => 'A.REAL_NAME',
  40. 'REMARK' => 'A.REMARK',
  41. 'ROLE_NAME' => 'AR.ROLE_NAME',
  42. 'IS_ENABLE' => 'A.IS_ENABLE',
  43. 'LOGIN_NUMS' => 'A.LOGIN_NUMS',
  44. 'LAST_LOGIN_IP' => 'A.LAST_LOGIN_IP',
  45. 'LAST_LOGIN_AT' => 'A.LAST_LOGIN_AT',
  46. 'BIND_IP' => 'A.BIND_IP',
  47. 'CREATED_AT' => 'A.CREATED_AT',
  48. 'UPDATED_AT' => 'A.UPDATED_AT',
  49. 'CREATE_ADMIN_NAME' => 'ADMC.ADMIN_NAME',
  50. 'UPDATE_ADMIN_NAME' => 'ADMU.ADMIN_NAME',
  51. ]);
  52. $condition = $filter['condition'];
  53. $condition .= ' AND A.IS_DEL=0';
  54. $params = $filter['params'];
  55. $data = Admin::lists($condition, $params, [
  56. 'select' => 'A.*,AR.ROLE_NAME,ADMC.ADMIN_NAME CREATE_ADMIN_NAME,ADMU.ADMIN_NAME UPDATE_ADMIN_NAME',
  57. 'from' => Admin::tableName().' AS A',
  58. 'join' => [
  59. ['LEFT JOIN', AdminRole::tableName().' AS AR', 'A.ROLE_ID=AR.ID'],
  60. ['LEFT JOIN', Admin::tableName() . ' AS ADMC', 'ADMC.ID=A.CREATE_ADMIN'],
  61. ['LEFT JOIN', Admin::tableName() . ' AS ADMU', 'ADMU.ID=A.UPDATE_ADMIN'],
  62. ],
  63. 'orderBy' => 'A.CREATED_AT ASC',
  64. ]);
  65. return static::notice($data);
  66. }
  67. /**
  68. * 添加管理员
  69. * @return mixed
  70. * @throws \yii\base\Exception
  71. * @throws \yii\web\HttpException
  72. */
  73. public function actionAdd(){
  74. if(Yii::$app->request->isPost) {
  75. return parent::edit(AdminForm::class, Yii::t('ctx', 'AdminAddedSuccessfully'), null, null, null, function($formModel, $result){
  76. // 添加操作日志
  77. // Log::adminHandle('添加管理员:'.$result->ADMIN_NAME);
  78. });
  79. }
  80. // 获取全部管理员角色
  81. $adminRoles = Cache::getAdminRole();
  82. $admin = Admin::findOne(Yii::$app->user->id);
  83. $roleId = $admin->ROLE_ID;
  84. if ($roleId == \Yii::$app->params['superAdminRoleId']) {
  85. $countries = Countries::find()->asArray()->all();
  86. } else {
  87. // 关联国家
  88. $countries = Countries::find()
  89. ->select('COU.ID, COU.CODE, COU.NAME')
  90. ->from(['COU' => Countries::tableName()])
  91. ->join('INNER JOIN', AdminCountry::tableName() . ' AS ADL', 'countries.COUNTRY_ID = ADL.ID')
  92. ->where(['ADL.ADMIN_ID' => $admin->ID])
  93. ->asArray()
  94. ->all();
  95. }
  96. return static::notice(['adminRoles'=>$adminRoles, 'countries'=>$countries]);
  97. }
  98. /**
  99. * 添加管理员
  100. * @return mixed
  101. * @throws \yii\base\Exception
  102. * @throws \yii\web\HttpException
  103. */
  104. public function actionEdit(){
  105. $id = Yii::$app->request->get('id');
  106. if(Yii::$app->request->isPost){
  107. return parent::edit(AdminForm::class, Yii::t('ctx', 'AdminEditedSuccessfully'), null, null, null, function($formModel, $result){
  108. // 添加操作日志
  109. // Log::adminHandle('编辑管理员:'.$result->ADMIN_NAME);
  110. });
  111. }
  112. $oneData = Admin::findOneAsArray(['ID'=>$id]);
  113. // 获取全部管理员角色
  114. $adminRoles = Cache::getAdminRole();
  115. return static::notice(['oneData'=>['adminName'=>$oneData['ADMIN_NAME'],'realName'=>$oneData['REAL_NAME'],'remark'=>$oneData['REMARK'],'isEnable'=>$oneData['IS_ENABLE']?true:false,'isModifyPassword'=>$oneData['IS_MODIFY_PASSWORD']?true:false,'bindIp'=>$oneData['BIND_IP'],'roleId'=>$oneData['ROLE_ID']], 'adminRoles'=>$adminRoles]);
  116. }
  117. /**
  118. * 重置密码
  119. * @return mixed
  120. * @throws \yii\base\Exception
  121. * @throws \yii\web\HttpException
  122. */
  123. public function actionChangePassword(){
  124. $form = new AdminForm();
  125. $form->scenario = 'changePassword';
  126. if(Yii::$app->request->isPost && $form->load(Yii::$app->request->post(), '') && $result = $form->edit()){
  127. // Log::adminHandle('管理员'.$result->ADMIN_NAME.'重置密码');
  128. return static::notice(Yii::t('ctx', 'passwordChangeSucceeded')); // 重置密码成功
  129. } else {
  130. return static::notice(Form::formatErrorsForApi($form->getErrors()), 400);
  131. }
  132. }
  133. /**
  134. * 删除管理员
  135. * @return mixed
  136. * @throws \yii\db\Exception
  137. * @throws \yii\web\HttpException
  138. */
  139. public function actionAdminDelete(){
  140. $adminForm = new AdminForm();
  141. $result = static::delete(Admin::class, function ($selected) use ($adminForm) {
  142. $adminForm->beforeDelete($selected);
  143. // Log::adminHandle('删除审核修改会员状态信息');
  144. }, function ($selected) use ($adminForm) {
  145. $adminForm->delete($selected);
  146. // Log::adminHandle('删除审核修改会员状态信息');
  147. }, false);
  148. return $result;
  149. }
  150. /**
  151. * 获取获取全部管理员角色
  152. * @return mixed
  153. * @throws \yii\web\HttpException
  154. */
  155. public function actionRole(){
  156. $filter = $this->filterCondition([
  157. 'ROLE_NAME' => 'AR.ROLE_NAME',
  158. 'REMARK' => 'AR.REMARK',
  159. 'CREATED_AT' => 'AR.CREATED_AT',
  160. 'UPDATED_AT' => 'AR.UPDATED_AT',
  161. 'CREATE_ADMIN_NAME' => 'ADMC.ADMIN_NAME',
  162. 'UPDATE_ADMIN_NAME' => 'ADMU.ADMIN_NAME',
  163. ]);
  164. $condition = $filter['condition'];
  165. $params = $filter['params'];
  166. $data = AdminRole::lists($condition, $params, [
  167. 'select' => 'AR.ID,AR.ROLE_NAME,AR.REMARK,AR.CREATED_AT,AR.UPDATED_AT,AR.DONT_DEL,ADMC.ADMIN_NAME CREATE_ADMIN_NAME,ADMU.ADMIN_NAME UPDATE_ADMIN_NAME',
  168. 'from' => AdminRole::tableName().' AS AR',
  169. 'join' => [
  170. ['LEFT JOIN', Admin::tableName() . ' AS ADMC', 'ADMC.ID=AR.CREATE_ADMIN'],
  171. ['LEFT JOIN', Admin::tableName() . ' AS ADMU', 'ADMU.ID=AR.UPDATE_ADMIN'],
  172. ],
  173. 'orderBy' => 'AR.CREATED_AT ASC',
  174. ]);
  175. return static::notice($data);
  176. }
  177. /**
  178. * 添加管理组
  179. * @return mixed
  180. * @throws \yii\web\HttpException
  181. */
  182. public function actionRoleAdd(){
  183. if (Yii::$app->request->post()) {
  184. $formModel = new AdminRoleForm();
  185. $formModel->scenario = 'add';
  186. if ($formModel->load(Yii::$app->request->post(), '') && $formModel->add()) {
  187. return static::notice(Yii::t('ctx', 'successAddAdminRole'));
  188. } else {
  189. return static::notice(Form::formatErrorsForApi($formModel->getErrors()), 400);
  190. }
  191. }
  192. }
  193. /**
  194. * 编辑管理组
  195. * @return mixed
  196. * @throws \yii\web\HttpException
  197. */
  198. public function actionRoleEdit(){
  199. $id = Yii::$app->request->get('id');
  200. if (Yii::$app->request->isPost) {
  201. return parent::edit(AdminRoleForm::class, Yii::t('ctx', 'editAdminRoleSuccess'), 'edit', ['edit'], null, function ($form, $result) {
  202. Cache::updateAdminRole();
  203. });
  204. }
  205. // 获得当前会员的用户名等信息
  206. if (!$role = AdminRole::findOneAsArray('ID=:ID', [':ID' => $id], 'ROLE_NAME,REMARK')) {
  207. return static::notice(Yii::t('ctx', 'roleDoesNotExist'), 404);
  208. }
  209. return static::notice($role);
  210. }
  211. /**
  212. * 删除管理员角色
  213. * @return mixed
  214. * @throws \yii\db\Exception
  215. * @throws \yii\web\HttpException
  216. */
  217. public function actionRoleDelete() {
  218. $adminRoleForm = new AdminRoleForm();
  219. $result = static::delete(AdminRole::class, function ($selected) use ($adminRoleForm) {
  220. $adminRoleForm->beforeDelete($selected);
  221. // Log::adminHandle('删除审核修改会员状态信息');
  222. }, function ($selected) use ($adminRoleForm) {
  223. $adminRoleForm->delete($selected);
  224. // Log::adminHandle('删除审核修改会员状态信息');
  225. }, true);
  226. // 更新缓存
  227. Cache::updateAdminRole();
  228. return $result;
  229. }
  230. /**
  231. * 权限设置
  232. * @return mixed
  233. * @throws \yii\web\HttpException
  234. */
  235. public function actionRolePermission(){
  236. $id = Yii::$app->request->get('id');
  237. $oneAdminRole = AdminRole::findOne($id);
  238. if (Yii::$app->request->isPost) {
  239. return parent::edit(AdminRoleForm::class, Yii::t('ctx', 'successSetAdminRolePermissions'), 'permission', ['permission'], null, function ($form, $result) {
  240. Cache::updateAdminRole();
  241. });
  242. }
  243. // 获取全部权限(通过菜单)
  244. $menuArray = require Yii::getAlias('@backendApi/config/menu.php');
  245. $permissionArray = [];
  246. foreach($menuArray as $key=>$value){
  247. $tempPermission = [];
  248. if(isset($value['controller']) && $value['controller']){
  249. $tempPermission['mainPermission'] = [
  250. 'name' => $value['name'],
  251. 'path' => $value['controller'].'/*',
  252. ];
  253. if($value['action']){
  254. $isChecked = false;
  255. // 暂时先从文件中取内容
  256. $fPath = \Yii::getAlias('@common/runtime/permission/').$oneAdminRole['ID'];
  257. if(!file_exists($fPath)){
  258. $fPermission = '';
  259. } else {
  260. $fPermission = file_get_contents($fPath);
  261. }
  262. if($fPermission){
  263. if(in_array($value['controller'].'/'.$value['action'], Json::decode($fPermission))){
  264. $isChecked = true;
  265. }
  266. }
  267. $tempPermission['childPermission'][] = [
  268. 'name' => $value['name'],
  269. 'path' => $value['controller'].'/'.$value['action'],
  270. 'isChecked' => $isChecked,
  271. ];
  272. }
  273. if($value['child']){
  274. foreach($value['child'] as $child){
  275. if($child['action']){
  276. $isChildChecked = false;
  277. // 暂时先从文件中取内容
  278. $cPath = \Yii::getAlias('@common/runtime/permission/').$oneAdminRole['ID'];
  279. if(!file_exists($cPath)){
  280. $cPermission = '';
  281. } else {
  282. $cPermission = file_get_contents($cPath);
  283. }
  284. if($cPermission){
  285. //是否已选状态
  286. if(in_array($child['controller'].'/'.$child['action'], Json::decode($cPermission))){
  287. $isChildChecked = true;
  288. }
  289. }
  290. $tempPermission['childPermission'][] = [
  291. 'name' => $child['name'],
  292. 'path' => $child['controller'].'/'.$child['action'],
  293. 'isChecked' => $isChildChecked,
  294. ];
  295. }
  296. }
  297. }
  298. }
  299. $tempPermission['id'] = $key;
  300. $permissionArray[] = $tempPermission;
  301. }
  302. return static::notice($permissionArray);
  303. }
  304. /**
  305. * 列表字段权限设置
  306. */
  307. public function actionRoleColumn(){
  308. $id = Yii::$app->request->get('id');
  309. if (Yii::$app->request->isPost) {
  310. return parent::edit(AdminRoleForm::class, Yii::t('ctx', 'successSetAdminRoleListFieldPermissions'), 'columnPermission', ['columnPermission'], null, function ($form, $result) {
  311. Cache::updateAdminRole();
  312. });
  313. }
  314. $oneAdminRole = AdminRole::findOneAsArray('ID=:ID', [':ID'=>$id]);
  315. $columnPermission = isset($oneAdminRole['COLUMN_PERMISSION']) && is_resource($oneAdminRole['COLUMN_PERMISSION']) ? stream_get_contents($oneAdminRole['COLUMN_PERMISSION']) : null;
  316. $oneRoleColumns = $columnPermission ? Json::decode(base64_decode($columnPermission)) : null;
  317. // 获取全部可供选择的列表字段
  318. $allRoleColumns = AdminRole::getAllRoleColumn();
  319. foreach($allRoleColumns as $key => $roleColumns){
  320. if($oneRoleColumns && isset($oneRoleColumns[$roleColumns['listClass']])){
  321. foreach($roleColumns['columns'] as $k => $roleColumn){
  322. $allRoleColumns[$key]['columns'][$k]['isChecked'] = in_array($roleColumn['index'], $oneRoleColumns[$roleColumns['listClass']]);
  323. }
  324. } else {
  325. foreach($roleColumns['columns'] as $k => $roleColumn){
  326. $allRoleColumns[$key]['columns'][$k]['isChecked'] = false;
  327. }
  328. }
  329. }
  330. return $allRoleColumns;
  331. }
  332. /**
  333. * @return mixed
  334. * @throws \yii\base\Exception
  335. * @throws \yii\web\HttpException
  336. */
  337. public function actionChangeLanguage() {
  338. $form = new AdminForm();
  339. $form->scenario = 'changeLanguage';
  340. $data = Yii::$app->request->post();
  341. $adminName = $data['adminName'] ?? '';
  342. if ($adminName && Yii::$app->request->isPost && $form->load($data, '') && $form->edit()){
  343. return static::notice(Yii::t('ctx', 'successfully'));
  344. } else {
  345. return static::notice(Form::formatErrorsForApi($form->getErrors()), 400);
  346. }
  347. }
  348. }