pgserver3.0/pgserver/application/admin/service/ChargeService.php

<?php

/**
 * 收费管理公用
 */

namespace app\admin\service;


class ChargeService
{

    /**
     * 列表页面选择搜索查询条件
     */
    public function searchCondition() {
        $map = [];
        // 非简易报告
        $map[] = ['is_simple', '=', 0];
        // 业务类型搜索条件
        $inquiry_type  = request()->param('inquiry_type');
        if (!empty($inquiry_type)) {
            $map[] = ['inquiry_type', '=', $inquiry_type];
        }
        // 结单状态搜索条件
        $charge_status = request()->param('charge_status');
        if (!empty($charge_status)) {
            $map[] = ['charge_status', '=', $charge_status];
        }
        // 银行（客户）搜索条件
        $bank_customer_mgr_id  = request()->param('bank_customer_mgr_id');
        if (!empty($bank_customer_mgr_id)) {
//            $map[] = ['bank_customer_mgr_id', '=', $bank_customer_mgr_id];
            $map[] = ['bank_id', '=', $bank_customer_mgr_id];
        }
        // 业务员姓名关键字搜索条件
        $salesman_name = request()->param('salesman_name');
        if (!empty($salesman_name)) {
            $map[] = ['salesman_name', 'like', '%'.$salesman_name.'%'];
        }
        // 结单开始时间搜索条件
        $check_time_start = request()->param('check_time_start');
        if (!empty($check_time_start)) {
            $map[] = ['check_time', '>', $check_time_start];
        }
        // 结单结束时间搜索条件
        $check_time_end = request()->param('check_time_end');
        if (!empty($check_time_end)) {
            $map[] = ['check_time', '<', $check_time_end];
        }
        // 城市搜索条件
        $city_id  = request()->param('city_id');
        if (!empty($city_id)) {
            $map[] = ['city_id', '=', $city_id];
        }
        // 地区搜索条件
        $region_id  = request()->param('region_id');
        if (!empty($region_id)) {
            $map[] = ['region_id', '=', $region_id];
        }
        // 物业名称关键字搜索条件
        $building_name  = request()->param('building_name');
        if (!empty($building_name)) {
            $map[] = ['building_name', 'like', '%'.$building_name.'%'];
        }
        // 出报告开始时间搜索条件
        $report_time_start = request()->param('report_time_start');
        if (!empty($report_time_start)) {
            $map[] = ['report_completion_time', '>', $report_time_start];
        }
        // 出报告结束时间搜索条件
        $report_time_end = request()->param('report_time_end');
        if (!empty($report_time_end)) {
            $map[] = ['report_completion_time', '<', $report_time_end];
        }
        return $map;
    }

    /**
     * 汇总列表页面选择搜索查询条件（联表）
     */
    public function summarySearchCondition() {
        $map = [];
        // 非简易报告
        $map[] = ['a.is_simple', '=', 0];
        // 实收状态搜索条件
        $is_confirm = request()->param('is_confirm');
        if (!empty($is_confirm)) {
            $map[] = ['a.is_confirm', '=', $is_confirm];
        }
        // 收款状态搜索条件
        $collection_status = request()->param('collection_status');
        if (!empty($collection_status)) {
            $map[] = ['a.collection_status', '=', $collection_status];
        }
        // 结单状态搜索条件
        $charge_status = request()->param('charge_status');
        if (!empty($charge_status)) {
            $map[] = ['a.charge_status', '=', $charge_status];
        }
        // 业务员姓名关键字搜索条件
        $salesman_name = request()->param('salesman_name');
        if (!empty($salesman_name)) {
            $map[] = ['a.salesman_name', 'like', '%'.$salesman_name.'%'];
        }
        // 物业名称关键字搜索条件
        $building_name  = request()->param('building_name');
        if (!empty($building_name)) {
            $map[] = ['a.building_name', 'like', '%'.$building_name.'%'];
        }
        // 银行（客户）搜索条件
        $bank_customer_mgr_id  = request()->param('bank_customer_mgr_id');
        if (!empty($bank_customer_mgr_id)) {
//            $map[] = ['a.bank_customer_mgr_id', '=', $bank_customer_mgr_id];
            $map[] = ['a.bank_id', '=', $bank_customer_mgr_id];
        }
        // 城市搜索条件
        $city_id  = request()->param('city_id');
        if (!empty($city_id)) {
            $map[] = ['a.city_id', '=', $city_id];
        }
        // 地区搜索条件
        $region_id  = request()->param('region_id');
        if (!empty($region_id)) {
            $map[] = ['a.region_id', '=', $region_id];
        }
        // 出报告开始时间搜索条件
        $report_time_start = request()->param('report_time_start');
        if (!empty($report_time_start)) {
            $map[] = ['a.report_completion_time', '>', $report_time_start];
        }
        // 出报告结束时间搜索条件
        $report_time_end = request()->param('report_time_end');
        if (!empty($report_time_end)) {
            $map[] = ['a.report_completion_time', '<', $report_time_end];
        }
        // 结单开始时间搜索条件
        $check_time_start = request()->param('check_time_start');
        if (!empty($check_time_start)) {
            $map[] = ['a.check_time', '>', $check_time_start];
        }
        // 结单结束时间搜索条件
        $check_time_end = request()->param('check_time_end');
        if (!empty($check_time_end)) {
            $map[] = ['a.check_time', '<', $check_time_end];
        }
        // 所属部门搜索条件
        $department_name = request()->param('department_name');
        if (!empty($department_name)) {
            $map[] = ['a.department_name', 'like', '%'.$department_name.'%'];
        }
        // 业务来源搜索条件
        $order_src = request()->param('order_src');
        if (!empty($order_src)) {
            $map[] = ['a.order_src', '=', $order_src];
        }
        // 是否公积金搜索条件
        $is_housing_fund = request()->param('is_housing_fund');
        if (!empty($is_housing_fund)) {
            $map[] = ['a.is_housing_fund', '=', $is_housing_fund];
        }
        // 收费方式搜索条件
        $pay_type = request()->param('pay_type');
        if (!empty($pay_type)) {
            $map[] = ['a.pay_type', '=', $pay_type];
        }
        // 评估目的搜索条件
        $assessment_purpose = request()->param('assessment_purpose');
        if (!empty($assessment_purpose)) {
            $map[] = ['a.assessment_purpose', '=', $assessment_purpose];
        }
        return $map;
    }

    /**
     * 简易报告列表页面选择搜索查询条件
     */
    public function simpleReportListSearchCondition() {
        $map = [];
        // 简易报告
        $map[] = ['is_simple', '=', 1];
        // 物业名称关键字搜索条件
        $building_name  = request()->param('building_name');
        if (!empty($building_name)) {
            $map[] = ['building_name', 'like', '%'.$building_name.'%'];
        }
        // 业务员姓名关键字搜索条件
        $salesman_name = request()->param('salesman_name');
        if (!empty($salesman_name)) {
            $map[] = ['salesman_name', 'like', '%'.$salesman_name.'%'];
        }
        // 收款状态搜索条件
        $simple_collection_status = request()->param('simple_collection_status');
        if (!empty($simple_collection_status)) {
            $map[] = ['simple_collection_status', '=', $simple_collection_status];
        }
        // 出报告开始时间搜索条件
        $report_time_start = request()->param('report_time_start');
        if (!empty($report_time_start)) {
            $map[] = ['report_completion_time', '>', $report_time_start];
        }
        // 出报告结束时间搜索条件
        $report_time_end = request()->param('report_time_end');
        if (!empty($report_time_end)) {
            $map[] = ['report_completion_time', '<', $report_time_end];
        }
        return $map;
    }

}