Newfill.php 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239
  1. <?php
  2. namespace app\admin\controller;
  3. use app\BaseController;
  4. use think\App;
  5. use think\facade\Db;
  6. class Newfill extends BaseController
  7. {
  8. public $post = "";
  9. public function __construct(App $app)
  10. {
  11. parent::__construct($app);
  12. $this->post = $this->request->post();
  13. }
  14. public function list()
  15. {
  16. $page = isset($this->post['page']) && $this->post['page'] != "" ? intval($this->post['page']) : 1;
  17. $size = isset($this->post['size']) && $this->post['size'] != "" ? intval($this->post['size']) : 10;
  18. $condition=[];
  19. $condition[] = ['is_del',"=",0];
  20. isset($this->post['pid']) &&$this->post['pid']!=="" ? $condition[]=["pid","=",$this->post['pid']]: $condition[]=['pid',"=",0];
  21. isset($this->post['name'])&&$this->post['name']!=="" ? $condition[]=["name","like","%{$this->post['name']}%"]:"";
  22. $nickname = isset($this->post['nickname']) && $this->post['nickname'] !==""? trim($this->post['nickname']) :"";
  23. if($nickname!=""){
  24. $is= Db::name("depart_user")->where([['nickname','like',"%{$nickname}%"]])->column('itemid');
  25. // var_dump($this->post[$nickname]);
  26. if(empty($is)){
  27. return error_show(1004,"未找到数据");
  28. }
  29. }
  30. $count = Db::name("company_item")->where($condition)->count();
  31. $page >= ceil($count / $size) ? $page = ceil($count / $size) : "";
  32. $list = Db::name("company_item")->where($condition)->page($page, $size)->select();
  33. // var_dump(Db::name("company_item")->getLastSql());
  34. // $this->carray($this->treelist);
  35. // var_dump($this->carray($this->treelist));
  36. $data=[];
  37. $act=[];
  38. foreach ($list as $value){
  39. // crea($value);
  40. //var_dump($value);
  41. $data[]= crea($value);;
  42. }
  43. // array_walk($data,function (&$value){
  44. //$value['child']= array_values($value['child']);
  45. // });
  46. return app_show(0,"获取成功",["list"=>$data,"count"=>$count]);
  47. }
  48. /*状态*/
  49. public function stat(){
  50. $id = isset($this->post['id'])?intval($this->post['id']):"";
  51. if($id==""){
  52. return error_show(1004,"参数id 不能为空");
  53. }
  54. $s = Db::name('company_item')->where(["id"=>$id])->find();
  55. if(empty($s)){
  56. return error_show(1005,"未找到部门");
  57. }
  58. $di = $s['status']==0? "1":"0";
  59. $s['status']=$di;
  60. $s['updatetime'] = date("Y-m-d H:i:s");
  61. // var_dump($s);
  62. $ti = Db::name('company_item')->save($s);
  63. return app_show(0,"更新成功");
  64. }
  65. public function userp(){
  66. $id = isset($this->post['id'])?intval($this->post['id']):"";
  67. if($id==""){
  68. return error_show(1004,"参数id 不能为空");
  69. }
  70. $t = Db::name('depart_user')->where(["id"=>$id,"is_del"=>0])->find();
  71. if(empty($t)){
  72. return error_show(1005,"未找到用户");
  73. }
  74. $position = isset($this->post['position'])?intval($this->post['position']):"";
  75. if($position!=""){
  76. return error_show(1004,"职位 不能为空");
  77. }
  78. if($position==2){
  79. $f = Db::name('depart_user')->where(['itemid'=>$t['itemid'],"is_del"=>0,"position"=>2])->find();
  80. if(!empty($f)&& $f['id']!=$id){
  81. return error_show(1004,"部门负责任已存在");
  82. }
  83. }
  84. $t['position']=$position;
  85. $t['updatetime'] = date("Y-m-d H:i:s");
  86. $ti = Db::name('company_item')->save($t);
  87. return app_show(0,"修改成功");
  88. }
  89. public function add(){
  90. $token = isset($this->post['token']) ? trim($this->post['token']) : "";
  91. if($token==""){
  92. return error_show(101,'token不能为空');
  93. }
  94. $effetc = VerifyTokens($token);
  95. if(!empty($effetc) && $effetc['code']!=0){
  96. return error_show($effetc['code'],$effetc['message']);
  97. }
  98. $item_name=isset($this->post['name']) && $this->post['name'] !==""? trim($this->post['name']) :"";
  99. if($item_name==""){
  100. return error_show(0,"部门名称不能为空");
  101. }
  102. $repeat_name = Db::name("company_item")->where(["is_del"=>0,"name"=>$item_name])->find();
  103. if(!empty($repeat_name)){
  104. return error_show(1004,"部门名称已存在");
  105. }
  106. $pid = isset($this->post['pid']) && $this->post['pid'] !==""? trim($this->post['pid']):"";
  107. if($pid===""){
  108. return error_show(1002,"父级id不能为空");
  109. }
  110. $spid = Db::name('company_item')->where(['pid'=>0,'is_del'=>0])->find();
  111. $level = isset($this->post['level']) && $this->post['level'] !==""? trim($this->post['level']):"1";
  112. $weight = isset($this->post['weight']) && $this->post['weight'] !==""? trim($this->post['weight']):"1";
  113. Db::startTrans();
  114. try{
  115. $data =[
  116. "name"=>$item_name, "pid"=>$pid, "level"=>$level, "weight"=>$weight,
  117. "is_del"=>0,
  118. "addtime"=>date("Y-m-d H:i:s"),
  119. "updatetime"=>date("Y-m-d H:i:s"),
  120. ];
  121. $t= Db::name("company_item")->insert($data,true);
  122. if($t>0){
  123. $depart_link=$spid['depart_link']."{$t}-";
  124. $level =explode('-',$depart_link);
  125. $level = array_filter($level);
  126. $level= count($level);
  127. $i=['depart_link'=>$depart_link,'level'=>$level];
  128. $o=Db::name('company_item')->where(['id'=>$t])->update($i);
  129. if($o){
  130. Db::commit();
  131. return error_show(0,"添加成功");
  132. }
  133. }
  134. Db::rollback();
  135. }catch (\Exception $e){
  136. Db::rollback();
  137. return error_show(1003,$e->getMessage());
  138. }
  139. }
  140. public function refresh(){
  141. $token = isset($this->post['token']) ? trim($this->post['token']) : "";
  142. if($token==""){
  143. return error_show(101,'token不能为空');
  144. }
  145. $effetc = VerifyTokens($token);
  146. if(!empty($effetc) && $effetc['code']!=0){
  147. return error_show($effetc['code'],$effetc['message']);
  148. }
  149. $id = isset($this->post['id'])?intval($this->post['id']):"";
  150. $items = Db::name("company_item")->where("id","=",$id)->find();
  151. if($items==false){
  152. return error_show(1003,"部门信息不存在");
  153. }
  154. $pid = isset($this->post['pid']) && $this->post['pid'] !==""? trim($this->post['pid']):"";
  155. if($pid==""){
  156. return error_show(1002,"父级id不能为空");
  157. }
  158. $spid = Db::name('company_item')->where(['pid'=>0,'is_del'=>0])->find();
  159. if(empty($spid)){
  160. return error_show(1004,"父级id不能为空");
  161. }
  162. $weight = isset($this->post['weight']) && $this->post['weight'] !==""? trim($this->post['weight']):"1";
  163. $itemname=isset($this->post['name'])? trim($this->post['name']):"";
  164. if($itemname==""){
  165. return error_show(1002,"部门名称不能为空");
  166. }
  167. $repeat_name = Db::name("company_item")->where(["is_del"=>0,"name"=>$itemname])->where('id','<>',$id)->find();
  168. //echo Db::name("company_item")->getLastSql();
  169. if(!empty($repeat_name)){
  170. return error_show(1004,"部门名称已存在");
  171. }
  172. $depart_link=$spid['depart_link']."{$id}-";
  173. $itemlevel =explode('-',$depart_link);
  174. $itemlevel = array_filter($itemlevel);
  175. $itemlevel= count($itemlevel);
  176. $item=[
  177. "id"=>$id,
  178. "name"=>$itemname,
  179. "updatetime"=>date("Y-m-d H:i:s"),
  180. "weight"=>$weight,"pid"=>$pid,
  181. 'depart_link'=>$depart_link,
  182. 'level'=>$itemlevel
  183. ];
  184. $re = Db::name("company_item")->save($item);
  185. return $re ? app_show(0,"信息更新成功"): error_show(1003,"信息更新失败");
  186. }
  187. public function query(){
  188. $token = isset($this->post['token']) ? trim($this->post['token']) : "";
  189. if($token==""){
  190. return error_show(101,'token不能为空');
  191. }
  192. $effetc = VerifyTokens($token);
  193. if(!empty($effetc) && $effetc['code']!=0){
  194. return error_show($effetc['code'],$effetc['message']);
  195. }
  196. $dati = Db::name("company_item")->where(['pid'=>0,'is_del'=>0])->order("weight desc")->select();
  197. $k=[];
  198. foreach ($dati as $key=>$value){
  199. $temp=[];
  200. $temp= Db::name("company_item")->where(['pid'=>$value['id'],'is_del'=>0])->order("weight desc")->select();
  201. $value['child'] =$temp;
  202. $k[]=$value;
  203. }
  204. return app_show(0,"获取成功",$k);
  205. }
  206. public function itemdel(){
  207. $token = isset($this->post['token']) ? trim($this->post['token']) : "";
  208. if($token==""){
  209. return error_show(101,'token不能为空');
  210. }
  211. $effetc = VerifyTokens($token);
  212. if(!empty($effetc) && $effetc['code']!=0){
  213. return error_show($effetc['code'],$effetc['message']);
  214. }
  215. $id = isset($this->post['id']) ? intval($this->post['id']):"";
  216. $items = Db::name("company_item")->where(['is_del'=>0,'id'=>$id])->find();
  217. if($items==false){
  218. return error_show(1003,"部门信息不存在");
  219. }
  220. $items['is_del']=1;
  221. $items['updatetime']=date("Y-m-d H:i:s");
  222. $result = Db::name("company_item")->save($items);
  223. return $result ? app_show(0,"删除成功"): error_show(1003,"删除失败");
  224. }
  225. }