AdminController.php 15 KB

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