GoodOfflineLog.php 4.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\DataGroup as DataGroupModel;
  4. use think\facade\Db;
  5. use think\facade\Validate;
  6. class GoodOfflineLog extends Base
  7. {
  8. //列表
  9. public function getList()
  10. {
  11. $param = $this->request->only(['start_date' => '','companyNo' => '','supplierNo' => '', "spuCode"=>'',"good_name"=>'','end_date' => '', 'creater' => '', 'page' => 1,'size' => 15], 'post', 'trim');
  12. $where = [];
  13. if ($param['start_date'] != '' && $param['end_date'] != '') $where[] = ['a.addtime', 'between', [$param['start_date'], $param['end_date']]];
  14. if ($param['creater'] != '') $where[] = ['a.creater', 'like', '%' . $param['creater'] . '%'];
  15. if ($param['spuCode'] != '') $where[] = ['a.spuCode', 'like', '%' . $param['spuCode'] . '%'];
  16. if ($param['good_name'] != '') $where[] = ['a.good_name', 'like', '%' . $param['good_name'] . '%'];
  17. if ($param['companyNo'] != '') $where[] = ['b.companyNo', 'like', '%' . $param['companyNo'] . '%'];
  18. if ($param['supplierNo'] != '') $where[] = ['b.supplierNo', 'like', '%' . $param['supplierNo'] . '%'];
  19. if ($param['relaComNo'] != '') $where[] = ['b.companyNo|b.supplierNo', 'like', '%' . $param['relaComNo'] . '%'];
  20. // $role = $this->checkDataShare();
  21. // if (!empty($role[DataGroupModel::$type_全部])) $where[] = ["createrid", "in", $role[DataGroupModel::$type_全部]];
  22. //只有level2的账号过滤数据权限
  23. if ($this->level == 2) {
  24. $role = $this->checkDataShare();
  25. $hand = resign_hand_user($this->uid, 0);
  26. if (!empty($role[DataGroupModel::$type_全部])) {
  27. $arr = array_unique(array_merge($hand, $role[DataGroupModel::$type_全部]));
  28. $where[] = ['createrid', 'in', $arr];
  29. }
  30. }
  31. $count = Db::name('good_offline_log')->alias("a")->leftJoin("good_basic b","a.spuCode=b.spuCode")->where($where)->count('id');
  32. $list = Db::name('good_offline_log')->alias("a")
  33. ->field('a.id,a.spuCode,a.good_name,a.creater,a.addtime,a.createrid,b.companyNo,b.supplierNo')
  34. ->leftJoin("good_basic b","a.spuCode=b.spuCode")
  35. ->where($where)
  36. ->order('addtime', 'desc')
  37. ->page($param['page'], $param['size'])
  38. // ->append(['is_allow_update'])
  39. // ->withAttr('is_allow_update', function ($val, $data) use ($role) {
  40. // if ($this->level == 2) return (in_array($this->roleid, [1, 33]) || in_array($data['createrid'], $role[DataGroupModel::$type_可编辑])) ? 1 : 0; //是否具有编辑权限
  41. //
  42. // })
  43. ->select()
  44. ->toArray();
  45. $userCommon=new \app\admin\common\User();
  46. $supplierInfo = $userCommon->handle('getCodeAndName',['code'=>array_merge(array_column($list,'companyNo'),array_column($list,'supplierNo'))]);
  47. foreach ($list as &$value){
  48. $value['companyName'] = $supplierInfo["data"][$value['companyNo']]??"";
  49. $value['supplierName'] = $supplierInfo["data"][$value['supplierNo']]??"";
  50. }
  51. return app_show(0, "获取成功", ['list' => $list, 'count' => $count]);
  52. }
  53. //详情
  54. public function getDetail()
  55. {
  56. $id = $this->request->post('id', null, 'trim');
  57. $val = Validate::rule(['id' => 'require|number|gt:0']);
  58. if (!$val->check(['id' => $id])) return error_show(1004, $val->getError());
  59. else {
  60. $res = Db::name('good_offline_log')
  61. ->alias('gol')
  62. ->field('gol.*,ri.result')
  63. ->where('gol.id', $id)
  64. ->leftJoin('result_info ri', 'ri.result_code=gol.offline_reason')
  65. ->find();
  66. $res['children_list'] = Db::name('good_platform')
  67. ->alias('gp')
  68. ->field('gp.id,gp.skuCode,p.platform_name,g.creater purchease,gp.creater')
  69. ->where(['gp.spuCode' => $res['spuCode']])
  70. ->whereIn('gp.skuCode', $res['skuCodes'])
  71. ->leftJoin('platform p', 'p.id=gp.platform_code')
  72. ->leftJoin('good g', 'g.spuCode=gp.spuCode')
  73. ->select()
  74. ->toArray();
  75. return app_show(0, "获取成功", $res);
  76. }
  77. }
  78. }