LogOrderModel.php 1.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. <?php
  2. namespace app\common\model;
  3. /**
  4. * 用户表
  5. * Class UserModel
  6. * @package app\common\model
  7. */
  8. class LogOrderModel extends BaseModel
  9. {
  10. protected $table = 'log_order';
  11. public function saveLogInfo($type,$order_no,$infoLog,$admin_id){
  12. // 日志类型 1卖家备注,2修改物流费用,3单个发货,4批量导入发货,5审核售后,6退款订单'
  13. $data['type']=$type;
  14. $data['order_no']=$order_no;
  15. $data['admin_id']=$admin_id;
  16. $data['log_info']=json_encode($infoLog,true);
  17. $data['add_ts']=time();
  18. return $this->insertGetId($data);
  19. }
  20. public function getLogOrderPage($page,$pageSize,$condition=[],$is_count = false,$order=''){
  21. $join=[
  22. ['admin admin','admin.admin_id=orderLog.admin_id','LEFT'],
  23. ['order order','order.order_no=orderLog.order_no','LEFT'],
  24. ];
  25. $this->alias('orderLog')
  26. ->field('orderLog.*,admin.admin_name')
  27. ->join($join);
  28. if(!empty($condition)){
  29. $this->where($condition);
  30. }
  31. if(!empty($order)){
  32. $this->order($order);
  33. }
  34. if($is_count){
  35. return $this->count();
  36. }
  37. return $this->page($page,$pageSize)->select();
  38. }
  39. }