xinyi_admin/application/common/model/LogisticsModel.php

<?php
namespace app\common\model;
/**
 * 物流模板表
 * Class LogisticsModel
 * @package app\common\model
 */

class LogisticsModel extends BaseModel
{
    protected $table = 'logistics_model';

    public function getLogisticsModelPage($page,$pageSize,$condition=[],$is_count = false,$order=''){
//        $this->alias('a')
//            ->field('a.*,ca.name')
//            ->join('city_area ca','ca.id = a.province_id','LEFT');
        if(!empty($condition)){
            $this->where($condition);
        }
        if(!empty($order)){
            $this->order($order);
        }
        if($is_count){
            return $this->count();
        }
        return $this->page($page,$pageSize)->column('*');
    }

    /**
     * 获取物流费用
     * @param $province
     * @param $total_number
     * @return string
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function getOrderLogisticsMoney($province,$total_number)
    {
        $logistics_info = $this->where('province_name',$province)->where('status',1)->find();
        $logistics = 0;
        $continue_price = 0;
        if(!empty($logistics_info)){
            $number = $total_number-$logistics_info['full_number'];
            if($number>0){
                $continue_number = ceil(($number/$logistics_info['continue_number']));
                $continue_price = $continue_number*$logistics_info['continue_price'];
            }
            $logistics = $logistics_info['full_price']+$continue_price;
        }
        return [
            'money'=>$logistics,
            'id'=>$logistics_info['model_id'],
        ];
    }
}