TagGood.php 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\BaseController;
  4. use think\App;
  5. use think\facade\Db;
  6. class TagGood extends BaseController{
  7. public function __construct(App $app) {parent::__construct($app);}
  8. //新建标签
  9. public function create(){
  10. $post = $this->post;
  11. $type = isset($post['type'])&& $post['type']!="" ? intval($post['type']) :"";
  12. if($type==''){
  13. return error_show(1004,"参数 type 不能未空");
  14. }
  15. if($post['relaComNo']!=""){
  16. $companyNo = isset($post['relaComNo'])&& $post['relaComNo']!="" ? trim($post['relaComNo']) :"";
  17. }else{
  18. $companyNo = isset($post['companyNo'])&& $post['companyNo']!="" ? trim($post['companyNo']) :"";
  19. }
  20. if($companyNo==''){
  21. return error_show(1004,"参数 companyNo 不能未空");
  22. }
  23. $tagName =isset($post['tag_name'])&&$post['tag_name']!='' ? trim($post['tag_name']):"";
  24. if($tagName==''){
  25. return error_show(1004,"参数 tag_name 不能未空");
  26. }
  27. $isT =Db::name("order_tag")->where(["type"=>$type,"companyNo"=>$companyNo,"tag_name"=>$tagName,"is_del"=>0])
  28. ->findOrEmpty();
  29. if(!empty($isT)){
  30. return error_show(1004,"标签名称已存在");
  31. }
  32. $tagData=[
  33. "type"=>$type,
  34. "tag_name"=>$tagName,
  35. "status"=>1,
  36. "companyNo"=>$companyNo,
  37. "apply_id"=>$this->uid,
  38. "apply_name"=>$this->uname,
  39. "addtime"=>date("Y-m-d H:i:s"),
  40. "updatetime"=>date("Y-m-d H:i:s")
  41. ];
  42. $ins=Db::name("order_tag")->insert($tagData);
  43. return $ins?app_show(0,"标签新建成功"): error_show(1004,"标签新建失败");
  44. }
  45. //标签列表翻页
  46. public function list(){
  47. $page = isset($this->post['page'])&&$this->post['page']!=''?intval($this->post['page']):1;
  48. $size = isset($this->post['size'])&&$this->post['size']!=''?intval($this->post['size']):15;
  49. $type = isset($this->post['type'])&&$this->post['type']!=''?intval($this->post['type']):'';
  50. $status = isset($this->post['status'])&&$this->post['status']!==''?intval($this->post['status']):'';
  51. if($this->post['relaComNo']!=""){
  52. $companyNo = isset($this->post['relaComNo'])&& $this->post['relaComNo']!="" ? trim($this->post['relaComNo']) :"";
  53. }else{
  54. $companyNo = isset($this->post['companyNo'])&& $this->post['companyNo']!="" ? trim($this->post['companyNo']) :"";
  55. }
  56. $condition =[["is_del","=",0]];
  57. if($type!=''){
  58. $condition[]=["type","=",$type];
  59. }
  60. if($status!==''){
  61. $condition[]=["status","=",$status];
  62. }
  63. $tagName =isset($this->post['tag_name'])&&$this->post['tag_name']!='' ? trim($this->post['tag_name']):"";
  64. if($tagName!=''){
  65. $condition[]=["tag_name","like","%$tagName%"];
  66. }
  67. if($companyNo!=''){
  68. $condition[]=["companyNo","=",$companyNo];
  69. }
  70. $count =Db::name("order_tag")->where($condition)->count();
  71. $total=ceil($count/$size);
  72. $page = $page>=$total ? intval($total):$page;
  73. $list =Db::name("order_tag")->where($condition)->page($page,$size)->order("addtime desc")->select()->toArray();
  74. return app_show(0,"获取成功",["list"=>$list,"count"=>$count]);
  75. }
  76. //根据条件筛选合适的标签数据
  77. public function query(){
  78. $type = isset($this->post['type'])&&$this->post['type']!=''?intval($this->post['type']):'';
  79. $condition =[["is_del","=",0]];
  80. if($type!=''){
  81. $condition[]=["type","=",$type];
  82. }
  83. if($this->post['relaComNo']!=""){
  84. $companyNo = isset($this->post['relaComNo'])&& $this->post['relaComNo']!="" ? trim($this->post['relaComNo']) :"";
  85. }else{
  86. $companyNo = isset($this->post['companyNo'])&& $this->post['companyNo']!="" ? trim($this->post['companyNo']) :"";
  87. }
  88. if($companyNo!=''){
  89. $condition[]=["companyNo","=",$companyNo];
  90. }
  91. $tagName =isset($this->post['tag_name'])&&$this->post['tag_name']!='' ? trim($this->post['tag_name']):"";
  92. if($tagName!=''){
  93. $condition[]=["tag_name","like","%$tagName%"];
  94. }
  95. $status = isset($this->post['status'])&&$this->post['status']!==''?intval($this->post['status']):'';
  96. if($status!==''){
  97. $condition[]=["status","=",$status];
  98. }
  99. $list =Db::name("order_tag")->where($condition)->order("addtime desc")->select()->toArray();
  100. return app_show(0,"获取成功",$list);
  101. }
  102. //启禁用状态
  103. public function status(){
  104. $id =isset($this->post['id'])&&$this->post['id']!=''?intval($this->post['id']):'';
  105. if($id==''){
  106. return error_show(1004,"参数 id 不能为空");
  107. }
  108. $taginfo =Db::name("order_tag")->find(["id"=>$id]);
  109. if($taginfo==false){
  110. return error_show(1004,"标签数据不存在");
  111. }
  112. $status=isset($this->post['status'])&&$this->post['status']!==''?intval($this->post['status']):'';
  113. if($status===''){
  114. return error_show(1004,"参数 status 不能为空");
  115. }
  116. $update =["status"=>$status,"updatetime"=>date("Y-m-d H:i:s")];
  117. $up =Db::name("order_tag")->where($taginfo)->update($update);
  118. return $up?app_show(0,"标签更新成功"): error_show(1004,"标签更新失败");
  119. }
  120. //编辑标签名称类型数据
  121. public function save(){
  122. $id =isset($this->post['id'])&&$this->post['id']!=''?intval($this->post['id']):'';
  123. if($id==''){
  124. return error_show(1004,"参数 id 不能为空");
  125. }
  126. $taginfo =Db::name("order_tag")->where(["id"=>$id,"is_del"=>0])->find();
  127. if($taginfo==false){
  128. return error_show(1004,"标签数据不存在");
  129. }
  130. $tagName=isset($this->post['tag_name'])&&$this->post['tag_name']!=''?trim($this->post['tag_name']):'';
  131. if($tagName===''){
  132. return error_show(1004,"参数 tag_name 不能为空");
  133. }
  134. $type=isset($this->post['type'])&&$this->post['type']!=''?intval($this->post['type']):'';
  135. if($type==''){
  136. return error_show(1004,"参数 type 不能为空");
  137. }
  138. // if($this->post['relaComNo']!=""){
  139. // $companyNo = isset($this->post['relaComNo'])&& $this->post['relaComNo']!="" ? trim($this->post['relaComNo']) :"";
  140. // }else{
  141. // $companyNo = isset($this->post['companyNo'])&& $this->post['companyNo']!="" ? trim($this->post['companyNo']) :"";
  142. // }
  143. // if($companyNo==''){
  144. // return error_show(1004,"参数 companyNo 不能为空");
  145. // }
  146. $tag =Db::name("order_tag")->where([['tag_name',"=",$tagName],['companyNo',"=",$taginfo['companyNo']],
  147. ['type',"=",$type], ["id","<>",$id],["is_del","=",0]])->find();
  148. if($tag!=false){
  149. return error_show(1004,"标签名称已存在");
  150. }
  151. $update =["type"=>$type,"tag_name"=>$tagName,"updatetime"=>date("Y-m-d H:i:s")];
  152. $up =Db::name("order_tag")->where($taginfo)->update($update);
  153. return $up?app_show(0,"标签更新成功"): error_show(1004,"标签更新失败");
  154. }
  155. //删除标签
  156. public function delete(){
  157. $id =isset($this->post['id'])&&$this->post['id']!=''?intval($this->post['id']):'';
  158. if($id==''){
  159. return error_show(1004,"参数 id 不能为空");
  160. }
  161. $taginfo =Db::name("order_tag")->find(["id"=>$id]);
  162. if($taginfo==false){
  163. return error_show(1004,"标签数据不存在");
  164. }
  165. $update=["is_del"=>1,"updatetime"=>date("Y-m-d H:i:s")];
  166. $up =Db::name("order_tag")->where($taginfo)->update($update);
  167. return $up?app_show(0,"标签删除成功"): error_show(1004,"标签删除失败");
  168. }
  169. //单号添加标签
  170. public function AddTag(){
  171. $tagid =isset($this->post["tag_id"]) && $this->post["tag_id"]!=""?intval($this->post["tag_id"]) :"";
  172. if($tagid==""){
  173. return error_show(1004,"参数 tag_id 不能为空");
  174. }
  175. $taginfo =Db::name("order_tag")->where(["id"=>$tagid,"is_del"=>0])->find();
  176. if($taginfo==false){
  177. return error_show(1005,"标签数据不存在");
  178. }
  179. if($taginfo['status']==0){
  180. return error_show(1005,"标签已禁用");
  181. }
  182. $code =isset($this->post['code']) &&$this->post["code"]!="" ? trim($this->post["code"]):"";
  183. if($code==''){
  184. return error_show(1004,"参数 code 不能为空");
  185. }
  186. $taglog =Db::name("tag_log")->where(["tag_id"=>$tagid,"code"=>$code,"status"=>1])->findOrEmpty();
  187. $total_fee =isset($this->post['total_fee']) &&$this->post["total_fee"]!=="" ? floatval($this->post["total_fee"]):"";
  188. if($total_fee==''){
  189. return error_show(1004,"参数 total_fee 不能为空");
  190. }
  191. $tagimg=isset($this->post["tag_img"]) && $this->post["tag_img"]!=""?$this->post["tag_img"]:"";
  192. $tag_remark=isset($this->post["tag_remark"]) && $this->post["tag_remark"]!=""?$this->post["tag_remark"]:"";
  193. Db::startTrans();
  194. try{
  195. if(!empty($taglog)){
  196. $up = Db::name("tag_log")->where($taglog)->update(["status"=>0,"updatetime"=>date("Y-m-d H:i:s")]);
  197. if($up==false){
  198. Db::rollback();
  199. return error_show(1004,"标签日志新建失败");
  200. }
  201. }
  202. if($taginfo['type']==1 || $taginfo['type']==2){
  203. $result= $this->payTag($taginfo['type'],$code,$total_fee);
  204. }
  205. if($taginfo['type']==3|| $taginfo['type']==4){
  206. $result= $this->qrdTag($taginfo['type'],$code,$total_fee);
  207. }
  208. $tagdata=[
  209. "code"=>$code,
  210. "tag_id"=>$tagid,
  211. "creater"=>$this->uname,
  212. "createrid"=>$this->uid,
  213. "tag_fee"=>$total_fee,
  214. "tag_img"=>$tagimg,
  215. "tag_remark"=>$tag_remark,
  216. "status"=>1,
  217. "addtime"=>date("Y-m-d H:i:s"),
  218. "updatetime"=>date("Y-m-d H:i:s")
  219. ];
  220. $in =Db::name("tag_log")->insert($tagdata);
  221. if($in==false){
  222. Db::rollback();
  223. return error_show(1004,"标签日志新建失败");
  224. }
  225. $data =$result->getData();
  226. if($data['code']==0){
  227. Db::commit();
  228. return app_show(0,"标签添加成功");
  229. }
  230. Db::rollback();
  231. return error_show($data['code'],$data['message']);
  232. }catch (\Exception $e){
  233. Db::rollback();
  234. return error_show(1004,$e->getMessage());
  235. }
  236. }
  237. /**
  238. * @param $tagId 标签类型 1 付款2回票
  239. * @param $code 对账单编号
  240. * @param $total_fee 标签金额
  241. * @return \think\response\Json|void
  242. * @throws \think\db\exception\DbException
  243. */
  244. private function payTag($tagId,$code,$total_fee){
  245. $pay=Db::name("pay")->where(["payNo"=>$code,"is_del"=>0])->findOrEmpty();
  246. if(empty($pay)){
  247. return error_show(1004,"未找到对账单数据");
  248. }
  249. $update=["updatetime"=>date("Y-m-d H:i:s")];
  250. if($tagId==1){
  251. if($pay['wpay_fee']+$pay['pay_tag_fee']<$total_fee){
  252. return error_show(1004,"对账单未付金额不足");
  253. }
  254. $update['wpay_fee']=$pay['wpay_fee']+$pay['pay_tag_fee']-$total_fee;
  255. $status = $update['wpay_fee']==0 &&$pay['pay_fee']==0 ? 3:($pay['apay_fee']==0?1:2);
  256. $update['pay_tag_fee'] = $total_fee;
  257. $update['pay_status'] = $status;
  258. $update['pay_tag'] = 1;
  259. }
  260. if($tagId==2){
  261. if($pay['winv_fee']+$pay['inv_tag_fee']<$total_fee){
  262. return error_show(1004,"对账单未付金额不足");
  263. }
  264. $update['winv_fee']=$pay['winv_fee']+$pay['inv_tag_fee']-$total_fee;
  265. $status = $update['winv_fee']==0 &&$pay['inv_fee']==0 ? 3:($pay['ainv_fee']==0?1:2);
  266. $update['inv_tag_fee'] = $total_fee;
  267. $update['inv_status'] = $status;
  268. $update['inv_tag'] = 1;
  269. }
  270. $resulr= Db::name("pay")->where($pay)->update($update);
  271. return $resulr? app_show(0,"标签添加成功"):error_show(1004,"标签添加失败");
  272. }
  273. /**
  274. * @param $tagId 标签类型 3 回款4开票
  275. * @param $code 销售单编号
  276. * @param $total_fee 标签金额
  277. * @return \think\response\Json|void
  278. * @throws \think\db\exception\DbException
  279. */
  280. private function qrdTag($tagId,$code,$total_fee){
  281. $qrd=Db::name("qrd_info")->where(["sequenceNo"=>$code,"is_del"=>0])->findOrEmpty();
  282. if(empty($qrd)){
  283. return error_show(1004,"未找到销售单数据");
  284. }
  285. $update=["updatetime"=>date("Y-m-d H:i:s")];
  286. if($tagId==3){
  287. if($qrd['wpay_fee']+$qrd['pay_tag_fee']<$total_fee){
  288. return error_show(1004,"对账单未付金额不足");
  289. }
  290. $update['wpay_fee']=$qrd['wpay_fee']+$qrd['pay_tag_fee']-$total_fee;
  291. $status = $update['wpay_fee']==0 &&$qrd['pay_fee']==0 ? 3:($qrd['apay_fee']==0?1:2);
  292. $update['pay_tag_fee'] = $total_fee;
  293. $update['pay_status'] = $status;
  294. $update['pay_tag'] = 1;
  295. }
  296. if($tagId==4){
  297. if($qrd['winv_fee']+$qrd['inv_tag_fee']<$total_fee){
  298. return error_show(1004,"对账单未付金额不足");
  299. }
  300. $update['winv_fee']=$qrd['winv_fee']+$qrd['inv_tag_fee']-$total_fee;
  301. $status = $update['winv_fee']==0 &&$qrd['inv_fee']==0 ? 3:($qrd['ainv_fee']==0?1:2);
  302. $update['inv_tag_fee'] = $total_fee;
  303. $update['inv_status'] = $status;
  304. $update['inv_tag'] = 1;
  305. }
  306. $resulr= Db::name("qrd_info")->where($qrd)->update($update);
  307. return $resulr? app_show(0,"标签添加成功"):error_show(1004,"标签添加失败");
  308. }
  309. }