package cn.huge.module.griddata.dao.mapper;

import cn.huge.module.griddata.domain.CaseAgent;
import cn.huge.module.griddata.domain.CaseInfo;
import cn.huge.module.griddata.domain.CaseInfoUnfold;
import cn.huge.module.griddata.domain.CasePerson;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

import java.util.List;

public interface CaseInfoMapper extends BaseMapper<CaseInfo> {
    @Select("select * from dyh_case_info order by create_time desc limit 1")
    CaseInfo getLastCaseInfo();

    @Select("select count(*) from dyh_case_info where id = #{caseId}")
    int countCaseInfo(@Param("caseId") String caseId);

    @Insert("<script>" +
            "INSERT INTO dyh_case_info (id, case_title, case_ref, case_level, visit_time, visit_people_num, medi_type, medi_type_name, case_type_first, case_type_first_name, case_type, case_type_name, occur_time, addr, lng, lat, wg_addr, wg_lng, wg_lat, que_prov, que_prov_name, que_city, que_city_name, que_area, que_area_name, que_road, que_road_name, que_village, que_village_name, people_num, amount, crowd, crowd_name, canal, canal_name, visit_way, visit_way_name, zxsl_status, case_des, case_claim, major_status, source, source_name, case_no, mediate_no, mediate_book_no, civil_no, plaintiffs, pagents, defendants, dagents, input_unit_id, input_unit_name, input_user_id, input_user_name, input_way, status, status_name, process, process_name, info_process, info_process_name, party_show, want_unit_id, want_unit_name, want_user_id, want_user_name, delete_status, cust_id, create_time, update_time, sync_status, old_case_type, old_case_type_name) \n" +
            "VALUES " +
            "<foreach item ='caseInfo' index='index' collection='list' separator=','>" +
            " (#{caseInfo.id}, #{caseInfo.caseTitle}, #{caseInfo.caseRef}, #{caseInfo.caseLevel}, #{caseInfo.visitTime}, #{caseInfo.visitPeopleNum}, #{caseInfo.mediType}, #{caseInfo.mediTypeName}, #{caseInfo.caseTypeFirst}, #{caseInfo.caseTypeFirstName}, #{caseInfo.caseType}, #{caseInfo.caseTypeName}, #{caseInfo.occurTime}, #{caseInfo.addr}, #{caseInfo.lng}, #{caseInfo.lat}, #{caseInfo.wgAddr}, #{caseInfo.wgLng}, #{caseInfo.wgLat}, #{caseInfo.queProv}, #{caseInfo.queProvName}, #{caseInfo.queCity}, #{caseInfo.queCityName}, #{caseInfo.queArea}, #{caseInfo.queAreaName}, #{caseInfo.queRoad}, #{caseInfo.queRoadName}, #{caseInfo.queVillage}, #{caseInfo.queVillageName}, #{caseInfo.peopleNum}, #{caseInfo.amount}, #{caseInfo.crowd}, #{caseInfo.crowdName}, #{caseInfo.canal}, #{caseInfo.canalName}, #{caseInfo.visitWay}, #{caseInfo.visitWayName}, #{caseInfo.zxslStatus}, #{caseInfo.caseDes}, #{caseInfo.caseClaim}, #{caseInfo.majorStatus}, #{caseInfo.source}, #{caseInfo.sourceName}, #{caseInfo.caseNo}, #{caseInfo.mediateNo}, #{caseInfo.mediateBookNo}, #{caseInfo.civilNo}, #{caseInfo.plaintiffs}, #{caseInfo.pagents}, #{caseInfo.defendants}, #{caseInfo.dagents}, #{caseInfo.inputUnitId}, #{caseInfo.inputUnitName}, #{caseInfo.inputUserId}, #{caseInfo.inputUserName}, #{caseInfo.inputWay}, #{caseInfo.status}, #{caseInfo.statusName}, #{caseInfo.process}, #{caseInfo.processName}, #{caseInfo.infoProcess}, #{caseInfo.infoProcessName}, #{caseInfo.partyShow}, #{caseInfo.wantUnitId}, #{caseInfo.wantUnitName}, #{caseInfo.wantUserId}, #{caseInfo.wantUserName}, #{caseInfo.deleteStatus}, #{caseInfo.custId}, #{caseInfo.createTime}, #{caseInfo.updateTime}, #{caseInfo.syncStatus}, #{caseInfo.oldCaseType}, #{caseInfo.oldCaseTypeName})" +
            "</foreach>" +
            "</script>")
    int insertBatchCaseInfo(@Param("list") List<CaseInfo> list);

    @Insert("<script>" +
            "INSERT INTO dyh_case_info_unfold (id, accept_time, belong_unit_id, belong_unit_name, mediate_unit_id, mediate_unit_name, mediate_dept_id, mediate_dept_name, mediator_id, mediator, mediator_mobile, assist_unit_id, assist_unit_name, medi_start_time, medi_end_time, medi_result, medi_result_name, agree_type, agree_type_name, agree_content, windup_content, medi_false, medi_false_name, civil_status, court_id, court_name, close_time, judic_apply, judic_result, judic_result_name, file_status, file_user_id, file_user_name, file_time, file_year, file_book_name, file_book_no, file_no, file_limit_year, file_addr, file_content, fulfil_situ, fulfil_situ_name, visit_up_status, visit_up_content, party_joy, cust_id, create_time, update_time) " +
            "VALUES " +
            "<foreach item ='caseInfoUnfold' index='index' collection='list' separator=','>" +
            "(#{caseInfoUnfold.id}, #{caseInfoUnfold.acceptTime}, #{caseInfoUnfold.belongUnitId}, #{caseInfoUnfold.belongUnitName}, #{caseInfoUnfold.mediateUnitId}, #{caseInfoUnfold.mediateUnitName}, #{caseInfoUnfold.mediateDeptId}, #{caseInfoUnfold.mediateDeptName}, #{caseInfoUnfold.mediatorId}, #{caseInfoUnfold.mediator}, #{caseInfoUnfold.mediatorMobile}, #{caseInfoUnfold.assistUnitId}, #{caseInfoUnfold.assistUnitName}, #{caseInfoUnfold.mediStartTime}, #{caseInfoUnfold.mediEndTime}, #{caseInfoUnfold.mediResult}, #{caseInfoUnfold.mediResultName}, #{caseInfoUnfold.agreeType}, #{caseInfoUnfold.agreeTypeName}, #{caseInfoUnfold.agreeContent}, #{caseInfoUnfold.windupContent}, #{caseInfoUnfold.mediFalse}, #{caseInfoUnfold.mediFalseName}, #{caseInfoUnfold.civilStatus}, #{caseInfoUnfold.courtId}, #{caseInfoUnfold.courtName}, #{caseInfoUnfold.closeTime}, #{caseInfoUnfold.judicApply}, #{caseInfoUnfold.judicResult}, #{caseInfoUnfold.judicResultName}, #{caseInfoUnfold.fileStatus}, #{caseInfoUnfold.fileUserId}, #{caseInfoUnfold.fileUserName}, #{caseInfoUnfold.fileTime}, #{caseInfoUnfold.fileYear}, #{caseInfoUnfold.fileBookName}, #{caseInfoUnfold.fileBookNo}, #{caseInfoUnfold.fileNo}, #{caseInfoUnfold.fileLimitYear}, #{caseInfoUnfold.fileAddr}, #{caseInfoUnfold.fileContent}, #{caseInfoUnfold.fulfilSitu}, #{caseInfoUnfold.fulfilSituName}, #{caseInfoUnfold.visitUpStatus}, #{caseInfoUnfold.visitUpContent}, #{caseInfoUnfold.partyJoy}, #{caseInfoUnfold.custId}, #{caseInfoUnfold.createTime}, #{caseInfoUnfold.updateTime})" +
            "</foreach>" +
            "</script>")
    int insertBatchCaseInfoUnfold(@Param("list") List<CaseInfoUnfold> list);

    @Insert("<script>" +
            "INSERT INTO dyh_case_person (id, case_id, party_user_id, company_id, per_type, per_type_name, per_class, per_class_name, true_name, mobile, orga_code, deputy, orga_type, orga_type_name, certi_type, certi_type_name, certi_no, prov, prov_name, city, city_name, area, area_name, road, road_name, village, village_name, addr, place_prov, place_prov_name, place_city, place_city_name, place_area, place_area_name, place_road, place_road_name, place_village, place_village_name, place_addr, work_unit_id, work_unit, nation, nation_name, sex, sex_name, extreme, avatar, job, job_name, birthday, age, agent_status, cust_id, delete_status, create_time, update_time) " +
            "VALUES " +
            "<foreach item ='casePerson' index='index' collection='list' separator=','>" +
            "(#{casePerson.id}, #{casePerson.caseId}, #{casePerson.partyUserId}, #{casePerson.companyId}, #{casePerson.perType}, #{casePerson.perTypeName}, #{casePerson.perClass}, #{casePerson.perClassName}, #{casePerson.trueName}, #{casePerson.mobile}, #{casePerson.orgaCode}, #{casePerson.deputy}, #{casePerson.orgaType}, #{casePerson.orgaTypeName}, #{casePerson.certiType}, #{casePerson.certiTypeName}, #{casePerson.certiNo}, #{casePerson.prov}, #{casePerson.provName}, #{casePerson.city}, #{casePerson.cityName}, #{casePerson.area}, #{casePerson.areaName}, #{casePerson.road}, #{casePerson.roadName}, #{casePerson.village}, #{casePerson.villageName}, #{casePerson.addr}, #{casePerson.placeProv}, #{casePerson.placeProvName}, #{casePerson.placeCity}, #{casePerson.placeCityName}, #{casePerson.placeArea}, #{casePerson.placeAreaName}, #{casePerson.placeRoad}, #{casePerson.placeRoadName}, #{casePerson.placeVillage}, #{casePerson.placeVillageName}, #{casePerson.placeAddr}, #{casePerson.workUnitId}, #{casePerson.workUnit}, #{casePerson.nation}, #{casePerson.nationName}, #{casePerson.sex}, #{casePerson.sexName}, #{casePerson.extreme}, #{casePerson.avatar}, #{casePerson.job}, #{casePerson.jobName}, #{casePerson.birthday}, #{casePerson.age}, #{casePerson.agentStatus}, #{casePerson.custId}, #{casePerson.deleteStatus}, #{casePerson.createTime}, #{casePerson.updateTime})" +
            "</foreach>" +
            "</script>")
    int insertBatchCasePerson(@Param("list") List<CasePerson> list);

    @Insert("<script>" +
            "INSERT INTO dyh_case_agent (id, case_id, party_user_id, per_type, per_type_name, per_class, per_class_name, true_name, mobile, certi_type, certi_type_name, certi_no, prov, prov_name, city, city_name, area, area_name, road, road_name, village, village_name, addr, place_prov, place_prov_name, place_city, place_city_name, place_area, place_area_name, place_road, place_road_name, place_village, place_village_name, place_addr, work_unit, nation, nation_name, sex, sex_name, extreme, agent_relate, agent_relate_name, agent_type, agent_type_name, person_id, avatar, job, job_name, birthday, age, agent_status, cust_id, delete_status, create_time, update_time) " +
            "VALUES " +
            "<foreach item ='caseAgent' index='index' collection='list' separator=','>" +
            "(#{caseAgent.id}, #{caseAgent.caseId}, #{caseAgent.partyUserId}, #{caseAgent.perType}, #{caseAgent.perTypeName}, #{caseAgent.perClass}, #{caseAgent.perClassName}, #{caseAgent.trueName}, #{caseAgent.mobile}, #{caseAgent.certiType}, #{caseAgent.certiTypeName}, #{caseAgent.certiNo}, #{caseAgent.prov}, #{caseAgent.provName}, #{caseAgent.city}, #{caseAgent.cityName}, #{caseAgent.area}, #{caseAgent.areaName}, #{caseAgent.road}, #{caseAgent.roadName}, #{caseAgent.village}, #{caseAgent.villageName}, #{caseAgent.addr}, #{caseAgent.placeProv}, #{caseAgent.placeProvName}, #{caseAgent.placeCity}, #{caseAgent.placeCityName}, #{caseAgent.placeArea}, #{caseAgent.placeAreaName}, #{caseAgent.placeRoad}, #{caseAgent.placeRoadName}, #{caseAgent.placeVillage}, #{caseAgent.placeVillageName}, #{caseAgent.placeAddr}, #{caseAgent.workUnit}, #{caseAgent.nation}, #{caseAgent.nationName}, #{caseAgent.sex}, #{caseAgent.sexName}, #{caseAgent.extreme}, #{caseAgent.agentRelate}, #{caseAgent.agentRelateName}, #{caseAgent.agentType}, #{caseAgent.agentTypeName}, #{caseAgent.personId}, #{caseAgent.avatar}, #{caseAgent.job}, #{caseAgent.jobName}, #{caseAgent.birthday}, #{caseAgent.age}, #{caseAgent.agentStatus}, #{caseAgent.custId}, #{caseAgent.deleteStatus}, #{caseAgent.createTime}, #{caseAgent.updateTime})" +
            "</foreach>" +
            "</script>")
    int inertBatchCaseAgent(@Param("list") List<CaseAgent> list);


}