ddsc/application/purchase/controller/OfflineOrderRefund.php

<?php
namespace app\purchase\controller;
use app\common\model\OfflineOrderItem;
use app\common\model\SystemUser;
use app\common\service\PurchaseLogic;
use library\tools\Data;
use think\Db;
use function AlibabaCloud\Client\value;

/**
 * 线下订单管理
 * Class OfflineOrderRefund
 * @package app\purchase\controller
 */
class OfflineOrderRefund extends PurBase
{

    /**
     * 绑定数据表
     * @var string
     */
    protected $table = 'OfflineOrderRefund';

    /**
     * 线下订单列表
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function index()
    {
        $this->title = '线下订单列表';
        $this->supplier = Db::name('Supplier')->where('is_deleted',0)->column('name','id');
        $this->admin_arr =SystemUser::column('username','id');
        $this->admin_arr[0] = 'admin';
        $where = [];
        $where[] = ['r.is_deleted','=',0];
        $query = $this->_query($this->table)
            ->field('r.*,o.employee_user')
            ->alias('r')
            ->leftJoin('OfflineOrder o','o.id = r.order_id')
            ->where($where);
        $query->like('r.order_num');
        $query->order('r.id desc')->page();
    }

    /**
     * 数据列表处理
     * @auth true
     * @menu true
     * @param array $data
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    protected function _index_page_filter(&$data)
    {
        foreach ($data as &$v) {
            $v['list'] = OfflineOrderItem::where('order_id',$v['order_id'])->select()->toArray();
        }
    }

    /**
     * 审核
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function audit()
    {
        $this->title = '审核线下订单';
        $this->_form($this->table, 'audit');
    }


    /**
     * 删除
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function del()
    {
        $this->_save($this->table, ['is_deleted' => 1]);
    }


    /**
     * 表单数据处理
     * @auth true
     * @menu true
     * @param array $data
     */
    protected function _form_filter(&$data)
    {
        if($this->request->isGet()){
            $this->supplier = Db::name('Supplier')->where('is_deleted',0)->column('name','id');
            $this->item_list = [];
        }
        if($this->request->isPost()) {
            // 审核人id
            if($this->request->action() == 'audit') {
                $order_sh = \app\common\model\OfflineOrderRefund::where('id',$data['id'])->value('sh_status');
                if($order_sh == 1) $this->error('已审核通过，不能修改');
                $data['audit_user'] = $this->admin_user['id'];
            }
        }
        $data['create_at'] = date('Y-m-d H:i:s');
    }



    protected function _form_result($id)
    {
        // 采购订单审核通过后创建线下管理订单
        if($this->request->isPost() && $this->request->action() == 'audit') {
            $sh_status = input('sh_status');
            $res = PurchaseLogic::auditOfflineRefund($id,$sh_status,$this->request->post('remark'));
            $res['code'] == 200 ? $this->success($res['msg']):$this->error($res['msg']);
        }
    }

}