ZZCS/coding/application/financeManager/reparations.class.php

<?php

/**
 * Created by PhpStorm.
 * User: admin
 * Date: 2017/5/23
 * Time: 11:21
 */
class reparations extends base
{
    //获取价格列表
    public function getList($post)
    {
        /**==========接收参数============**/
        $param = array(
            'date_type' => empty($post['date_type']) ? '1' : $post['date_type'],//时间类型 1、创建时间 2、赔款时间
            'start_date' => empty($post['start_date']) ? '' : $post['start_date'],//开始时间
            'end_date' => empty($post['end_date']) ? '' : $post['end_date'],//接收时间
            'org_id' => empty($post['org_id']) ? '' : $post['org_id'],//渠道商ID
            'more_search' => empty($post['more_search ']) ? '' : $post['more_search '],//更多查询条件
            'current_page' => empty($post['current_page']) ? '1' : $post['current_page'],//当前页
            'page_size' => empty($post['page_size']) ? '10' : $post['page_size'],//每页展示条数
        );

        $where = array();
        $dateCol = $param['date_type'] == 1 ? 'a.create_time' : 'a.date';
        if (!empty($param['start_date'])) {
            $where[] = " {$dateCol} >=  {$param['start_date']} ";
        }
        if (!empty($param['end_date'])) {
            $where[] = " {$dateCol} < date_add('{$param['end_date']}', INTERVAL 1 day) ";
        }
        if (!empty($param['org_id'])) {
            $where[] = " b.OUTSIDE_SALE_ORG_ID = {$param['org_id']} ";
        }
        if (!empty($param['more_search'])) {
            $where[] = " (a.order_id like '%{$param['more_search']}%' or b.PARENT_PROD_NAME like '%{$param['more_search']}%') ";
        }
        $whereStr = ' ';
        if (count($where)) {
            $whereStr .= 'where ' . implode(' and ', $where);
        }
        if ($param['current_page'] == 1) {
            $sql = "SELECT count(1) cnt
            FROM order_finance_reparations a
            JOIN order_main b ON a.order_id = b.ORDER_ID
            JOIN base_supplier c ON b.OUTSIDE_SALE_ORG_ID = c.ID
            {$whereStr}";
            $getTotal = $this->query($sql);
            $data['page']['total_count'] = $getTotal[0]['cnt'];
            $data['page']['total_page'] = (string)ceil($getTotal[0]['cnt'] / $param['page_size']);
        }
        $sql2 = "SELECT a.date,a.order_id,c.SUPPLIER_NAME ,a.reparations,a.memo,a.create_time,a.memo_title,
        ifnull((SELECT CONCAT(b.PARENT_PROD_NAME, '<br />',PROD_START_STATION_RES_NAME,' - ',PROD_END_STATION_RES_NAME) from order_main WHERE PARENT_ORDER_ID = b.ORDER_ID LIMIT 1),b.PARENT_PROD_NAME )'PARENT_PROD_NAME'
        FROM order_finance_reparations a
        JOIN order_main b ON a.order_id = b.ORDER_ID
        JOIN base_supplier c ON b.OUTSIDE_SALE_ORG_ID = c.ID
        {$whereStr}
        ORDER BY  a.create_time DESC 
        ";
        $list = $this->query($sql2);
        $json['code'] = '0';
        $json['info'] = '获取列表成功';
        $data['order_list'] = $list;
        $data['page']['page_size'] = $param['page_size'];
        $data['page']['current_page'] = $param['current_page'];
        $json['data'] = $data;
        return $json;
    }

    //获取订单信息
    public function getOrderInfo($post)
    {
        $order_id = empty($post['order_id']) ? '' : $post['order_id'];
        if (!preg_match('/^[1-9][0-9]{0,10}$/', $order_id)) {
            $json['code'] = '1';
            $json['info'] = 'params error';
            return $json;
        }
        $sql = "SELECT IFNULL(b.reparations,0) 'reparations',memo_id,
        IFNULL(b.date,'') 'date',IFNULL(b.memo,'') 'memo',ifnull(b.memo_title, '') 'memo_title',
        ifnull((SELECT CONCAT(a.PARENT_PROD_NAME, '<br />',PROD_START_STATION_RES_NAME,' - ',PROD_END_STATION_RES_NAME) from order_main WHERE PARENT_ORDER_ID = b.ORDER_ID LIMIT 1),a.PARENT_PROD_NAME )'PARENT_PROD_NAME'
        from order_main a
        LEFT JOIN order_finance_reparations b on a.order_id = b.order_id
        where a.ORDER_ID=  {$order_id}";
        $info = $this->query($sql);
        if (empty($info[0])) {
            $json['code'] = '1';
            $json['info'] = '订单不存在！请核对订单号！';
            return $json;
        }
        $json['code'] = '0';
        $json['info'] = '获取信息成功';
        $json['data'] = $info[0];
        return $json;
    }

    //设置订单的赔款
    public function setReparations($post)
    {
        $param = array(
            'order_id' => empty($post['order_id']) ? '' : $post['order_id'],//订单ID
            'reparations' => empty($post['reparations']) ? 0 : $post['reparations'],//金额
            'date' => empty($post['date']) ? '' : $post['date'],//赔款日期
            'memo_id' => empty($post['memo_id'])?'':$post['memo_id'],//原因ID
            'memo' => empty($post['memo']) ? '' : $post['memo'],//赔款备注 原因
            'memo_title' => empty($post['memo_title']) ? '' : $post['memo_title'],//赔款备注 标题
        );
        if (!preg_match('/^[1-9][0-9]{0,10}$/', $param['order_id'])) {
            $json['code'] = '1';
            $json['info'] = '参数错误，请联系开发人员！001';
            return $json;
        }
        if (empty($param['date']) || empty($param['reparations'])) {
            $json['code'] = '1';
            $json['info'] = '请选择赔款日期或填写赔款金额！';
            return $json;
        }
        $sql = "REPLACE INTO `order_finance_reparations` ( `order_id`,`reparations`,`user_id`, `memo`,`date`,`create_time`,memo_title,memo_id)
        VALUES
        ('{$param['order_id']}','{$param['reparations']}','{$_SESSION['user_id']}','{$param['memo']}'
        ,'{$param['date']}',now(),'{$param['memo_title']}','{$param['memo_id']}');";
        $this->insert($sql);
        $json['code'] = '0';
        $json['info'] = '设置订单赔款金额成功！';
        return $json;
    }

    //删除定的赔款记录
    public function del($post)
    {
        $param = array(
            'order_id' => empty($post['order_id']) ? '' : $post['order_id'],//订单ID
        );
        if (!preg_match('/^[1-9][0-9]{0,10}$/', $param['order_id'])) {
            $json['code'] = '1';
            $json['info'] = '参数错误，请联系开发人员！001';
            return $json;
        }
        $sql = "DELETE from order_finance_reparations WHERE order_id = {$param['order_id']}";
        $flag = $this->edit($sql);
        if ($flag) {
            $json['code'] = '0';
            $json['info'] = '删除成功！';
            return $json;
        } else {
            $json['code'] = '0';
            $json['info'] = '删除失败！';
            return $json;
        }
    }

    /**
     * 获取原因列表
     */
    public function getMemoArr()
    {
        $return = array();
        $return[] = array('memo_id'=>1,'memo_title'=>'漏单','memo'=>'漏单:目前的紧急处理方案是退客人现场购票的金额。');
        $return[] = array('memo_id'=>2,'memo_title'=>'产品问题','memo'=>'产品问题:赔付方案需要与运营沟通。');
        $return[] = array('memo_id'=>3,'memo_title'=>'客人问题','memo'=>'客人问题:包括未收到短信，未找到车，未接到司机电话等。');
        $return[] = array('memo_id'=>4,'memo_title'=>'下错单','memo'=>'下错单:上下站点问题，时间问题。');
        $return[] = array('memo_id'=>5,'memo_title'=>'汽车晚点','memo'=>'汽车晚点:');
        $return[] = array('memo_id'=>6,'memo_title'=>'交通管制','memo'=>'交通管制:');
        $return[] = array('memo_id'=>7,'memo_title'=>'并班原因','memo'=>'并班原因:');
        $return[] = array('memo_id'=>8,'memo_title'=>'车队原因','memo'=>'车队原因:');
        $return[] = array('memo_id'=>9,'memo_title'=>'司机原因','memo'=>'司机原因:');
        $return[] = array('memo_id'=>10000,'memo_title'=>'其他','memo'=>'其他。');
        $json['code'] = '0';
        $json['info'] = '获取列表成功';
        $json['list'] = $return;
        return $json;
    }

}