Business.php 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269
  1. <?php
  2. namespace app\admin\controller;
  3. use app\BaseController;
  4. use think\App;
  5. use think\facade\Db;
  6. class Business 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 create(){
  15. $company = isset($this->post['company']) && $this->post['company'] !==""? trim($this->post['company']):"";
  16. if($company==""){
  17. return error_show(1002,"参数company不能为空");
  18. }
  19. $company_type = isset($this->post['company_type']) && $this->post['company_type'] !==""? trim($this->post['company_type']):"";
  20. if($company_type==""){
  21. return error_show(1002,"参数company_type不能为空");
  22. }
  23. $inv_code = isset($this->post['inv_code']) && $this->post['inv_code'] !==""? trim($this->post['inv_code']):"";
  24. if($inv_code==""){
  25. return error_show(1002,"参数inv_code不能为空");
  26. }
  27. $inv_legaler = isset($this->post['inv_legaler']) && $this->post['inv_legaler'] !==""? trim($this->post['inv_legaler']):"";
  28. if($inv_legaler==""){
  29. return error_show(1002,"参数inv_legaler不能为空");
  30. }
  31. $inv_time = isset($this->post['inv_time'])&&$this->post['inv_time']!== "" ? $this->post['inv_time']:date("Y-m-d H:i:s");
  32. if($inv_time==""){
  33. return error_show(1005,'参数inv_time不能为空');
  34. }
  35. $inv_addr = isset($this->post['inv_addr']) && $this->post['inv_addr'] !==""? trim($this->post['inv_addr']):"";
  36. if($inv_addr==""){
  37. return error_show(1002,"参数inv_addr不能为空");
  38. }
  39. $inv_bank = isset($this->post['inv_bank']) && $this->post['inv_bank'] !==""? trim($this->post['inv_bank']):"";
  40. if($inv_bank==""){
  41. return error_show(1002,"参数inv_bank不能为空");
  42. }
  43. $inv_bankNo = isset($this->post['inv_bankNo']) && $this->post['inv_bankNo'] !==""? trim($this->post['inv_bankNo']):"";
  44. if($inv_bankNo==""){
  45. return error_show(1002,"参数inv_bankNo不能为空");
  46. }
  47. $contactor = isset($this->post['contactor']) && $this->post['contactor'] !==""? trim($this->post['contactor']):"";
  48. if($contactor==""){
  49. return error_show(1002,"参数contactor不能为空");
  50. }
  51. $mobile = isset($this->post['mobile']) && $this->post['mobile'] !==""? trim($this->post['mobile']):"";
  52. if($mobile==""){
  53. return error_show(1002,"参数mobile不能为空");
  54. }
  55. $addr = isset($this->post['addr']) && $this->post['addr'] !==""? trim($this->post['addr']):"";
  56. if($addr==""){
  57. return error_show(1002,"参数addr不能为空");
  58. }
  59. $inv_scope = isset($this->post['inv_scope']) && $this->post['inv_scope'] !==""? trim($this->post['inv_scope']):"";
  60. if($inv_scope==""){
  61. return error_show(1002,"参数inv_scope不能为空");
  62. }
  63. $license_img = isset($this->post['license_img']) && $this->post['license_img'] !==""? trim($this->post['license_img']):"";
  64. if($license_img==""){
  65. return error_show(1002,"参数license_img不能为空");
  66. }
  67. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  68. if($token==''){
  69. return error_show(1005,"参数token不能为空");
  70. }
  71. $user =GetUserInfo($token);
  72. if(empty($user)||$user['code']!=0){
  73. return error_show(1002,"创建人数据不存在");
  74. }
  75. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  76. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  77. $status = isset($this->post['status']) && $this->post['status'] !==""? intval($this->post['status']):"0";
  78. $data =[
  79. "company"=>$company,
  80. "inv_code"=>$inv_code,
  81. "company_type"=>$company_type,
  82. "inv_legaler"=>$inv_legaler,
  83. "inv_time"=>date("Y-m-d H:i:s"),
  84. "inv_addr"=>$inv_addr,
  85. "inv_bank"=>$inv_bank,
  86. "inv_bankNo"=>$inv_bankNo,
  87. "contactor"=>$contactor,
  88. "mobile"=>$mobile,
  89. "addr"=>$addr,
  90. "creater"=>$creater,
  91. "createrid"=>$createrid,
  92. "inv_scope"=>$inv_scope,
  93. "license_img"=>$license_img,
  94. "status"=>$status,
  95. "is_del"=>0,
  96. "addtime"=>date("Y-m-d H:i:s"),
  97. "updatetime"=>date("Y-m-d H:i:s")
  98. ];
  99. $datainfo = Db::name('business')->insert($data);
  100. return $datainfo? error_show(0,"新建成功"):error_show(1004,"新建失败");
  101. }
  102. public function list(){
  103. $page = isset($this->post['page']) && $this->post['page'] !==""? intval($this->post['page']):"1";
  104. $size = isset($this->post['size']) && $this->post['size'] !==""? intval($this->post['size']):"10";
  105. $where = [["is_del","=",0]];
  106. $company = isset($this->post['company']) && $this->post['company'] !=="" ? trim($this->post['company']):"";
  107. if($company!=""){
  108. $where[]=['company',"like","%$company%"];
  109. }
  110. $status = isset($this->post['status']) && $this->post['status'] !=="" ? intval($this->post['status']):"";
  111. if($status!=""){
  112. $where[]=['status',"=",$status];
  113. }
  114. $creater = isset($this->post['creater']) && $this->post['creater'] !=="" ? intval($this->post['creater']):"";
  115. if($creater!=""){
  116. $where[]=['creater',"like","%$creater%"];
  117. }
  118. $start = isset($this->post['start']) && $this->post['start']!=="" ? $this->post['start']:"";
  119. if($start!==""){
  120. $where[]=['addtime',">=",date('Y-m-d H:i:s',strtotime($start))];
  121. }
  122. $end = isset($this->post['end']) && $this->post['end']!=="" ? $this->post['end']:"";
  123. if($end!==""){
  124. $where[]=['addtime',"<",date('Y-m-d H:i:s',strtotime($end)+24*3600)];
  125. }
  126. $count = Db::name('business') ->where($where)->count();
  127. $total = ceil($count / $size);
  128. $page = $page >= $total ? $total : $page;
  129. $list = Db::name('business')->where($where)->page($page,$size)->field("company,status,creater,addtime")->order("addtime desc")->select();
  130. return app_show(0,"获取成功",['list'=>$list,'count'=>$count]);
  131. }
  132. public function edit(){
  133. $id = isset($this->post['id']) && $this->post['id'] !=="" ? intval($this->post['id']) :"";
  134. if($id==""){
  135. return error_show(1002,"参数id不能为空");
  136. }
  137. $idinfo = Db::name('business')->where(['id'=>$id,'is_del'=>0])->find();
  138. if($idinfo==""){
  139. return error_show(1003,"未找到数据");
  140. }
  141. $company = isset($this->post['company']) && $this->post['company'] !==""? trim($this->post['company']):"";
  142. if($company==""){
  143. return error_show(1002,"参数company不能为空");
  144. }
  145. $company_type = isset($this->post['company_type']) && $this->post['company_type'] !==""? trim($this->post['company_type']):"";
  146. if($company_type==""){
  147. return error_show(1002,"参数company_type不能为空");
  148. }
  149. $inv_code = isset($this->post['inv_code']) && $this->post['inv_code'] !==""? trim($this->post['inv_code']):"";
  150. if($inv_code==""){
  151. return error_show(1002,"参数inv_code不能为空");
  152. }
  153. $inv_legaler = isset($this->post['inv_legaler']) && $this->post['inv_legaler'] !==""? trim($this->post['inv_legaler']):"";
  154. if($inv_legaler==""){
  155. return error_show(1002,"参数inv_legaler不能为空");
  156. }
  157. $inv_time = isset($this->post['inv_time'])&&$this->post['inv_time']!== "" ? $this->post['inv_time']:date("Y-m-d H:i:s");
  158. if($inv_time==""){
  159. return error_show(1005,'参数inv_time不能为空');
  160. }
  161. $inv_addr = isset($this->post['inv_addr']) && $this->post['inv_addr'] !==""? trim($this->post['inv_addr']):"";
  162. if($inv_addr==""){
  163. return error_show(1002,"参数inv_addr不能为空");
  164. }
  165. $inv_bank = isset($this->post['inv_bank']) && $this->post['inv_bank'] !==""? trim($this->post['inv_bank']):"";
  166. if($inv_bank==""){
  167. return error_show(1002,"参数inv_bank不能为空");
  168. }
  169. $inv_bankNo = isset($this->post['inv_bankNo']) && $this->post['inv_bankNo'] !==""? trim($this->post['inv_bankNo']):"";
  170. if($inv_bankNo==""){
  171. return error_show(1002,"参数inv_bankNo不能为空");
  172. }
  173. $contactor = isset($this->post['contactor']) && $this->post['contactor'] !==""? trim($this->post['contactor']):"";
  174. if($contactor==""){
  175. return error_show(1002,"参数contactor不能为空");
  176. }
  177. $mobile = isset($this->post['mobile']) && $this->post['mobile'] !==""? trim($this->post['mobile']):"";
  178. if($mobile==""){
  179. return error_show(1002,"参数mobile不能为空");
  180. }
  181. $addr = isset($this->post['addr']) && $this->post['addr'] !==""? trim($this->post['addr']):"";
  182. if($addr==""){
  183. return error_show(1002,"参数addr不能为空");
  184. }
  185. $inv_scope = isset($this->post['inv_scope']) && $this->post['inv_scope'] !==""? trim($this->post['inv_scope']):"";
  186. if($inv_scope==""){
  187. return error_show(1002,"参数inv_scope不能为空");
  188. }
  189. $license_img = isset($this->post['license_img']) && $this->post['license_img'] !==""? trim($this->post['license_img']):"";
  190. if($license_img==""){
  191. return error_show(1002,"参数license_img不能为空");
  192. }
  193. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  194. if($token==''){
  195. return error_show(1005,"参数token不能为空");
  196. }
  197. $user =GetUserInfo($token);
  198. if(empty($user)||$user['code']!=0){
  199. return error_show(1002,"创建人数据不存在");
  200. }
  201. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  202. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  203. $status = isset($this->post['status']) && $this->post['status'] !==""? intval($this->post['status']):"0";
  204. $data = [
  205. "id"=>$id,
  206. "company"=>$company,
  207. "inv_code"=>$inv_code,
  208. "company_type"=>$company_type,
  209. "creater"=>$creater,
  210. "createrid"=>$createrid,
  211. "inv_legaler"=>$inv_legaler,
  212. "inv_time"=>date("Y-m-d H:i:s"),
  213. "inv_addr"=>$inv_addr,
  214. "inv_bank"=>$inv_bank,
  215. "inv_bankNo"=>$inv_bankNo,
  216. "contactor"=>$contactor,
  217. "mobile"=>$mobile,
  218. "addr"=>$addr,
  219. "inv_scope"=>$inv_scope,
  220. "license_img"=>$license_img,
  221. "status"=>$status,
  222. "is_del"=>0,
  223. "addtime"=>date("Y-m-d H:i:s"),
  224. "updatetime"=>date("Y-m-d H:i:s")
  225. ];
  226. $info = Db::name('business')->save($data);
  227. return $info ? error_show(0,"更新成功") : error_show(1002,"更新失败");
  228. }
  229. public function del(){
  230. $id = $this->post['id'] && $this->post['id'] !=="" ? intval($this->post['id']) :"";
  231. if($id===""){
  232. return error_show(1004,"参数id不能为空");
  233. }
  234. $str= Db::name('business')->where(['id'=>$id,'is_del'=>0])->find();
  235. if(empty($str)){
  236. return error_show(1002,"未找到数据");
  237. }
  238. $end = Db::name('business')->update(['id'=>$id,'is_del'=>1]);
  239. if($end){
  240. return error_show(0,"删除成功");
  241. }else{
  242. return error_show(1002,"删除失败");
  243. }
  244. }
  245. public function status(){
  246. $id = isset($this->post['id']) && $this->post['id'] !==""? intval($this->post['id']):"";
  247. if($id==""){
  248. return error_show(1002,"参数id不能为空");
  249. }
  250. $info = Db::name("business")->where([["id","=",$id],["is_del","=",0]])->find();
  251. if(!$info){
  252. return error_show(1002,"未找到对应数据");
  253. }
  254. $status = isset($this->post['status']) && $this->post['status']!==""? intval($this->post['status']):"";
  255. if($status===""){
  256. return error_show(1002,"参数status不能为空");
  257. }
  258. if(!in_array($status,[0,1])){
  259. return error_show(1002,"参数status无效");
  260. }
  261. $info['status']=$status;
  262. $msg = $status==0?"启用":"禁用";
  263. $update = Db::name("business")->save($info);
  264. return $update? error_show(0,"{$msg}成功"):error_show(1004,"{$msg}失败");
  265. }
  266. }