<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2018/12/27
 * Time: 17:33
 */

namespace app\index\model;


use think\Model;

class SubjoinInsuranceModel extends Model
{
    public function subjoinSum($where){
        $where['c.delete_time'] = ['eq',0];
        $where['s.delete_time'] = ['eq',0];
//        $where['c.expire_time'] = ['>',time()];//判断保单是否还在缴费期限内
        $data = $this
            ->alias('s')
            ->join('collocation c','s.collocation_id = c.id')
            ->where($where)
            ->sum('s.subjoin_pay_method_price');
        return $data;
    }
    public function selectData($where,$whereor=null){
        $where['s_i.delete_time'] = ['eq',0];
        $where['c.delete_time'] = ['eq',0];
        //$where['o.status'] = ['eq',3];
        $data = $this
            ->alias('s_i')
            ->field('s_i.*,c.insurer,o.order_expire_time,o.status,o.order_about_time,o.order_expire_time2')
            ->join('cmf_collocation c','c.id = s_i.collocation_id')
            ->join('cmf_order_info o_i','c.id = o_i.collocation_id')
            ->join('cmf_order o','o_i.order_id = o.id')
            ->where($where)
            ->whereOr($whereor)
            ->order('c.create_time','desc')
//            ->fetchSql()
            ->select()->toArray();
        $new_data = [];
        foreach($data as $k1=>$v1 ){
            $new_data[$v1['subjoin_product_name']][] = $v1;
        }
        return $new_data;
    }
    public function selectData2($where){
        $where['delete_time'] = ['eq',0];
        $data = $this->where($where)->select()->toArray();
        return $data;
    }
    public function findData($where){
        $where['delete_time'] = ['eq',0];
        $data = $this->where($where)->find();
        return $data;
    }
    public function deleteData($where){
        $result = $this->where($where)->delete();
        return $result;
    }
}