Sealcate.php 3.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111
  1. <?php
  2. /**
  3. +-----------------------------------------------------------------------------------------------
  4. * GouGuOPEN [ 左手研发,右手开源,未来可期!]
  5. +-----------------------------------------------------------------------------------------------
  6. * @Copyright (c) 2021~2024 http://www.gouguoa.com All rights reserved.
  7. +-----------------------------------------------------------------------------------------------
  8. * @Licensed 勾股OA,开源且可免费使用,但并不是自由软件,未经授权许可不能去除勾股OA的相关版权信息
  9. +-----------------------------------------------------------------------------------------------
  10. * @Author 勾股工作室 <hdm58@qq.com>
  11. +-----------------------------------------------------------------------------------------------
  12. */
  13. declare (strict_types = 1);
  14. namespace app\adm\controller;
  15. use app\base\BaseController;
  16. use app\adm\validate\SealCateCheck;
  17. use think\exception\ValidateException;
  18. use think\facade\Db;
  19. use think\facade\View;
  20. class Sealcate extends BaseController
  21. {
  22. //印章类别
  23. public function datalist()
  24. {
  25. if (request()->isAjax()) {
  26. $cate = Db::name('SealCate')
  27. ->field('a.*,u.name,d.title as department')
  28. ->alias('a')
  29. ->join('Admin u', 'u.id = a.keep_uid')
  30. ->join('Department d', 'd.id = u.did')
  31. ->order('create_time asc')->select()->toArray();
  32. foreach ($cate as $key => &$value) {
  33. if(!empty($value['dids'])){
  34. $value['departments']=get_department_name($value['dids']);
  35. }
  36. else{
  37. $value['departments']='全部';
  38. }
  39. }
  40. return to_assign(0, '', $cate);
  41. } else {
  42. return view();
  43. }
  44. }
  45. //添加
  46. public function add()
  47. {
  48. $param = get_params();
  49. if (request()->isAjax()) {
  50. if (!empty($param['id']) && $param['id'] > 0) {
  51. try {
  52. validate(SealCateCheck::class)->scene('edit')->check($param);
  53. } catch (ValidateException $e) {
  54. // 验证失败 输出错误信息
  55. return to_assign(1, $e->getError());
  56. }
  57. $param['update_time'] = time();
  58. $res = Db::name('SealCate')->strict(false)->field(true)->update($param);
  59. if ($res) {
  60. add_log('edit', $param['id'], $param);
  61. }
  62. return to_assign();
  63. } else {
  64. try {
  65. validate(SealCateCheck::class)->scene('add')->check($param);
  66. } catch (ValidateException $e) {
  67. // 验证失败 输出错误信息
  68. return to_assign(1, $e->getError());
  69. }
  70. $param['create_time'] = time();
  71. $insertId = Db::name('SealCate')->strict(false)->field(true)->insertGetId($param);
  72. if ($insertId) {
  73. add_log('add', $insertId, $param);
  74. }
  75. return to_assign();
  76. }
  77. }else {
  78. $id = isset($param['id']) ? $param['id'] : 0;
  79. if ($id > 0) {
  80. $detail = Db::name('SealCate')->where(['id' => $id])->find();
  81. $detail['keep_name'] = Db::name('Admin')->where(['id' => $detail['keep_uid']])->value('name');
  82. View::assign('detail', $detail);
  83. }
  84. View::assign('id', $id);
  85. return view();
  86. }
  87. }
  88. //设置
  89. public function check()
  90. {
  91. $param = get_params();
  92. $res = Db::name('SealCate')->strict(false)->field('id,status')->update($param);
  93. if ($res) {
  94. if($param['status'] == 0){
  95. add_log('disable', $param['id'], $param);
  96. }
  97. else if($param['status'] == 1){
  98. add_log('recovery', $param['id'], $param);
  99. }
  100. return to_assign();
  101. }
  102. else{
  103. return to_assign(0, '操作失败');
  104. }
  105. }
  106. }