ServiceApply.php 750 B

123456789101112131415161718192021222324252627
  1. <?php
  2. namespace app\api\model\supplier;
  3. use app\common\model\supplier\ServiceApply as ServiceApplyModel;
  4. /**
  5. * 供应商服务保障申请模型
  6. */
  7. class ServiceApply extends ServiceApplyModel
  8. {
  9. /**
  10. * 获取列表数据
  11. */
  12. public function getList($shop_supplier_id)
  13. {
  14. $model = $this;
  15. // 查询列表数据
  16. $list = $model->alias('a')
  17. ->where('a.status','=',1)
  18. ->where('shop_supplier_id','=',$shop_supplier_id)
  19. ->join('supplier_service_security s','s.service_security_id=a.service_security_id')
  20. ->field('name,describe')
  21. ->order(['a.create_time' => 'asc'])
  22. ->select();
  23. return $list;
  24. }
  25. }