kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/BusinessRecordsMapper.xml
@@ -12,60 +12,61 @@ <where> <!--查询条件自行添加--> p.is_del=0 <if test="p.id != null and p.id !=''"> and id = #{p.id} <if test="p.id != null and p.id !=''"> and id = #{p.id} </if> <if test="p.recordTitle != null and p.recordTitle !=''"> and record_title = #{p.recordTitle} <if test="p.recordTitle != null and p.recordTitle !=''"> and record_title = #{p.recordTitle} </if> <if test="p.userId != null and p.userId !=''"> and user_id = #{p.userId} <if test="p.userId != null and p.userId !=''"> and user_id = #{p.userId} </if> <if test="p.userName != null and p.userName !=''"> and user_name = #{p.userName} <if test="p.userName != null and p.userName !=''"> and user_name = #{p.userName} </if> <if test="p.appId != null and p.appId !=''"> and app_id = #{p.appId} <if test="p.appId != null and p.appId !=''"> and app_id = #{p.appId} </if> <if test="p.appName != null and p.appName !=''"> and app_name = #{p.appName} <if test="p.appName != null and p.appName !=''"> and app_name = #{p.appName} </if> <if test="p.recordIp != null and p.recordIp !=''"> and record_ip = #{p.recordIp} <if test="p.recordIp != null and p.recordIp !=''"> and record_ip = #{p.recordIp} </if> <if test="p.recordDetail != null and p.recordDetail !=''"> and record_detail = #{p.recordDetail} <if test="p.recordDetail != null and p.recordDetail !=''"> and record_detail = #{p.recordDetail} </if> <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> </where> </where> </sql> <!--定义根据-BusinessRecords当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.BusinessRecords"> select <include refid="Column_List"/> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.BusinessRecords"> select <include refid="Column_List"/> from business_records <include refid="where"/> order by id desc @@ -73,8 +74,10 @@ <!--定义根据-BusinessRecords当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.BusinessRecords"> select <include refid="Column_List"/> select <include refid="Column_List"/> from business_records <include refid="where"/> order by id desc </select> </mapper> kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/BusinessServerMapper.xml
@@ -12,54 +12,55 @@ <where> <!--查询条件自行添加--> p.is_del=0 <if test="p.departmentId != null and p.departmentId !=''"> and department_id = #{p.departmentId} <if test="p.departmentId != null and p.departmentId !=''"> and department_id = #{p.departmentId} </if> <if test="p.doctorCount != null and p.doctorCount !=''"> and doctor_count = #{p.doctorCount} <if test="p.doctorCount != null and p.doctorCount !=''"> and doctor_count = #{p.doctorCount} </if> <if test="p.serverEndDate != null and p.serverEndDate !=''"> and server_end_date = #{p.serverEndDate} <if test="p.serverEndDate != null and p.serverEndDate !=''"> and server_end_date = #{p.serverEndDate} </if> <if test="p.totalRayCount != null and p.totalRayCount !=''"> and total_ray_count = #{p.totalRayCount} <if test="p.totalRayCount != null and p.totalRayCount !=''"> and total_ray_count = #{p.totalRayCount} </if> <if test="p.totalRecordCount != null and p.totalRecordCount !=''"> and total_record_count = #{p.totalRecordCount} <if test="p.totalRecordCount != null and p.totalRecordCount !=''"> and total_record_count = #{p.totalRecordCount} </if> <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="p.tenantId != null and p.tenantId !=''"> and tenant_id = #{p.tenantId} <if test="p.tenantId != null and p.tenantId !=''"> and tenant_id = #{p.tenantId} </if> <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> </where> </where> </sql> <!--定义根据-BusinessServer当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.BusinessServer"> select <include refid="Column_List"/> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.BusinessServer"> select <include refid="Column_List"/> from business_server <include refid="where"/> order by id desc @@ -67,8 +68,10 @@ <!--定义根据-BusinessServer当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.BusinessServer"> select <include refid="Column_List"/> select <include refid="Column_List"/> from business_server <include refid="where"/> order by id desc </select> </mapper> kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/DoctorAnswerMapper.xml
@@ -12,36 +12,37 @@ <where> <!--查询条件自行添加--> p.is_del=0 <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> </where> </where> </sql> <!--定义根据-DoctorAnswer当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.DoctorAnswer"> select <include refid="Column_List"/> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.DoctorAnswer"> select <include refid="Column_List"/> from doctor_answer <include refid="where"/> order by id desc @@ -49,8 +50,10 @@ <!--定义根据-DoctorAnswer当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.DoctorAnswer"> select <include refid="Column_List"/> select <include refid="Column_List"/> from doctor_answer <include refid="where"/> order by id desc </select> </mapper> kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/DoctorServerMapper.xml
@@ -12,45 +12,46 @@ <where> <!--查询条件自行添加--> p.is_del=0 <if test="p.isAnswer != null and p.isAnswer !=''"> and is_answer = #{p.isAnswer} <if test="p.isAnswer != null and p.isAnswer !=''"> and is_answer = #{p.isAnswer} </if> <if test="p.isSigning != null and p.isSigning !=''"> and is_signing = #{p.isSigning} <if test="p.isSigning != null and p.isSigning !=''"> and is_signing = #{p.isSigning} </if> <if test="p.doctorState != null and p.doctorState !=''"> and doctor_state = #{p.doctorState} <if test="p.doctorState != null and p.doctorState !=''"> and doctor_state = #{p.doctorState} </if> <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> </where> </where> </sql> <!--定义根据-DoctorServer当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.DoctorServer"> select <include refid="Column_List"/> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.DoctorServer"> select <include refid="Column_List"/> from doctor_server <include refid="where"/> order by id desc @@ -58,8 +59,10 @@ <!--定义根据-DoctorServer当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.DoctorServer"> select <include refid="Column_List"/> select <include refid="Column_List"/> from doctor_server <include refid="where"/> order by id desc </select> </mapper> kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/DoctorSigningMapper.xml
@@ -12,36 +12,37 @@ <where> <!--查询条件自行添加--> p.is_del=0 <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> </where> </where> </sql> <!--定义根据-DoctorSigning当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.DoctorSigning"> select <include refid="Column_List"/> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.DoctorSigning"> select <include refid="Column_List"/> from doctor_signing <include refid="where"/> order by id desc @@ -49,8 +50,10 @@ <!--定义根据-DoctorSigning当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.DoctorSigning"> select <include refid="Column_List"/> select <include refid="Column_List"/> from doctor_signing <include refid="where"/> order by id desc </select> </mapper> kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/DoctorTempleteMapper.xml
@@ -12,69 +12,70 @@ <where> <!--查询条件自行添加--> p.is_del=0 <if test="p.id != null and p.id !=''"> and id = #{p.id} <if test="p.id != null and p.id !=''"> and id = #{p.id} </if> <if test="p.hospitalId != null and p.hospitalId !=''"> and hospital_id = #{p.hospitalId} <if test="p.hospitalId != null and p.hospitalId !=''"> and hospital_id = #{p.hospitalId} </if> <if test="p.hospitalName != null and p.hospitalName !=''"> and hospital_name = #{p.hospitalName} <if test="p.hospitalName != null and p.hospitalName !=''"> and hospital_name = #{p.hospitalName} </if> <if test="p.departmentId != null and p.departmentId !=''"> and department_id = #{p.departmentId} <if test="p.departmentId != null and p.departmentId !=''"> and department_id = #{p.departmentId} </if> <if test="p.departmentName != null and p.departmentName !=''"> and department_name = #{p.departmentName} <if test="p.departmentName != null and p.departmentName !=''"> and department_name = #{p.departmentName} </if> <if test="p.doctorId != null and p.doctorId !=''"> and doctor_id = #{p.doctorId} <if test="p.doctorId != null and p.doctorId !=''"> and doctor_id = #{p.doctorId} </if> <if test="p.doctorName != null and p.doctorName !=''"> and doctor_name = #{p.doctorName} <if test="p.doctorName != null and p.doctorName !=''"> and doctor_name = #{p.doctorName} </if> <if test="p.publicType != null and p.publicType !=''"> and public_type = #{p.publicType} <if test="p.publicType != null and p.publicType !=''"> and public_type = #{p.publicType} </if> <if test="p.templeteType != null and p.templeteType !=''"> and templete_type = #{p.templeteType} <if test="p.templeteType != null and p.templeteType !=''"> and templete_type = #{p.templeteType} </if> <if test="p.templeteTitle != null and p.templeteTitle !=''"> and templete_title = #{p.templeteTitle} <if test="p.templeteTitle != null and p.templeteTitle !=''"> and templete_title = #{p.templeteTitle} </if> <if test="p.templeteNote != null and p.templeteNote !=''"> and templete_note = #{p.templeteNote} <if test="p.templeteNote != null and p.templeteNote !=''"> and templete_note = #{p.templeteNote} </if> <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> </where> </where> </sql> <!--定义根据-DoctorTemplete当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.DoctorTemplete"> select <include refid="Column_List"/> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.DoctorTemplete"> select <include refid="Column_List"/> from doctor_templete <include refid="where"/> order by id desc @@ -82,8 +83,10 @@ <!--定义根据-DoctorTemplete当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.DoctorTemplete"> select <include refid="Column_List"/> select <include refid="Column_List"/> from doctor_templete <include refid="where"/> order by id desc </select> </mapper> kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/HospitalScreeningMapper.xml
@@ -12,51 +12,52 @@ <where> <!--查询条件自行添加--> p.is_del=0 <if test="p.hospitalId != null and p.hospitalId !=''"> and hospital_id = #{p.hospitalId} <if test="p.hospitalId != null and p.hospitalId !=''"> and hospital_id = #{p.hospitalId} </if> <if test="p.hospitalName != null and p.hospitalName !=''"> and hospital_name = #{p.hospitalName} <if test="p.hospitalName != null and p.hospitalName !=''"> and hospital_name = #{p.hospitalName} </if> <if test="p.hospitalLogo != null and p.hospitalLogo !=''"> and hospital_logo = #{p.hospitalLogo} <if test="p.hospitalLogo != null and p.hospitalLogo !=''"> and hospital_logo = #{p.hospitalLogo} </if> <if test="p.hospitalQrImage != null and p.hospitalQrImage !=''"> and hospital_qr_image = #{p.hospitalQrImage} <if test="p.hospitalQrImage != null and p.hospitalQrImage !=''"> and hospital_qr_image = #{p.hospitalQrImage} </if> <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="p.tenantId != null and p.tenantId !=''"> and tenant_id = #{p.tenantId} <if test="p.tenantId != null and p.tenantId !=''"> and tenant_id = #{p.tenantId} </if> <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> </where> </where> </sql> <!--定义根据-HospitalScreening当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.HospitalScreening"> select <include refid="Column_List"/> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.HospitalScreening"> select <include refid="Column_List"/> from hospital_screening <include refid="where"/> order by id desc @@ -64,8 +65,10 @@ <!--定义根据-HospitalScreening当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.HospitalScreening"> select <include refid="Column_List"/> select <include refid="Column_List"/> from hospital_screening <include refid="where"/> order by id desc </select> </mapper> kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/ProductOrderDetailMapper.xml
@@ -12,63 +12,64 @@ <where> <!--查询条件自行添加--> p.is_del=0 <if test="p.id != null and p.id !=''"> and id = #{p.id} <if test="p.id != null and p.id !=''"> and id = #{p.id} </if> <if test="p.orderId != null and p.orderId !=''"> and order_id = #{p.orderId} <if test="p.orderId != null and p.orderId !=''"> and order_id = #{p.orderId} </if> <if test="p.proId != null and p.proId !=''"> and pro_id = #{p.proId} <if test="p.proId != null and p.proId !=''"> and pro_id = #{p.proId} </if> <if test="p.proName != null and p.proName !=''"> and pro_name = #{p.proName} <if test="p.proName != null and p.proName !=''"> and pro_name = #{p.proName} </if> <if test="p.isShare != null and p.isShare !=''"> and is_share = #{p.isShare} <if test="p.isShare != null and p.isShare !=''"> and is_share = #{p.isShare} </if> <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="p.ailightCount != null and p.ailightCount !=''"> and ailight_count = #{p.ailightCount} <if test="p.ailightCount != null and p.ailightCount !=''"> and ailight_count = #{p.ailightCount} </if> <if test="p.recordCount != null and p.recordCount !=''"> and record_count = #{p.recordCount} <if test="p.recordCount != null and p.recordCount !=''"> and record_count = #{p.recordCount} </if> <if test="p.proBegintime != null and p.proBegintime !=''"> and pro_begintime = #{p.proBegintime} <if test="p.proBegintime != null and p.proBegintime !=''"> and pro_begintime = #{p.proBegintime} </if> <if test="p.proEndtime != null and p.proEndtime !=''"> and pro_endtime = #{p.proEndtime} <if test="p.proEndtime != null and p.proEndtime !=''"> and pro_endtime = #{p.proEndtime} </if> <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> </where> </where> </sql> <!--定义根据-ProductOrderDetail当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.ProductOrderDetail"> select <include refid="Column_List"/> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.ProductOrderDetail"> select <include refid="Column_List"/> from product_order_detail <include refid="where"/> order by id desc @@ -76,8 +77,10 @@ <!--定义根据-ProductOrderDetail当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.ProductOrderDetail"> select <include refid="Column_List"/> select <include refid="Column_List"/> from product_order_detail <include refid="where"/> order by id desc </select> </mapper> kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/ProductOrderMapper.xml
@@ -12,66 +12,67 @@ <where> <!--查询条件自行添加--> p.is_del=0 <if test="p.id != null and p.id !=''"> and id = #{p.id} <if test="p.id != null and p.id !=''"> and id = #{p.id} </if> <if test="p.hospitalId != null and p.hospitalId !=''"> and hospital_id = #{p.hospitalId} <if test="p.hospitalId != null and p.hospitalId !=''"> and hospital_id = #{p.hospitalId} </if> <if test="p.hospitalName != null and p.hospitalName !=''"> and hospital_name = #{p.hospitalName} <if test="p.hospitalName != null and p.hospitalName !=''"> and hospital_name = #{p.hospitalName} </if> <if test="p.departmentId != null and p.departmentId !=''"> and department_id = #{p.departmentId} <if test="p.departmentId != null and p.departmentId !=''"> and department_id = #{p.departmentId} </if> <if test="p.departmentName != null and p.departmentName !=''"> and department_name = #{p.departmentName} <if test="p.departmentName != null and p.departmentName !=''"> and department_name = #{p.departmentName} </if> <if test="p.contractNo != null and p.contractNo !=''"> and contract_no = #{p.contractNo} <if test="p.contractNo != null and p.contractNo !=''"> and contract_no = #{p.contractNo} </if> <if test="p.contractTitle != null and p.contractTitle !=''"> and contract_title = #{p.contractTitle} <if test="p.contractTitle != null and p.contractTitle !=''"> and contract_title = #{p.contractTitle} </if> <if test="p.contractBeginTime != null and p.contractBeginTime !=''"> and contract_begin_time = #{p.contractBeginTime} <if test="p.contractBeginTime != null and p.contractBeginTime !=''"> and contract_begin_time = #{p.contractBeginTime} </if> <if test="p.contractEndTime != null and p.contractEndTime !=''"> and contract_end_time = #{p.contractEndTime} <if test="p.contractEndTime != null and p.contractEndTime !=''"> and contract_end_time = #{p.contractEndTime} </if> <if test="p.contractTime != null and p.contractTime !=''"> and contract_time = #{p.contractTime} <if test="p.contractTime != null and p.contractTime !=''"> and contract_time = #{p.contractTime} </if> <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> </where> </where> </sql> <!--定义根据-ProductOrder当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.ProductOrder"> select <include refid="Column_List"/> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.ProductOrder"> select <include refid="Column_List"/> from product_order <include refid="where"/> order by id desc @@ -79,8 +80,10 @@ <!--定义根据-ProductOrder当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.ProductOrder"> select <include refid="Column_List"/> select <include refid="Column_List"/> from product_order <include refid="where"/> order by id desc </select> </mapper> kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/SysFeedbackMapper.xml
@@ -12,63 +12,64 @@ <where> <!--查询条件自行添加--> p.is_del=0 <if test="p.id != null and p.id !=''"> and id = #{p.id} <if test="p.id != null and p.id !=''"> and id = #{p.id} </if> <if test="p.doctorId != null and p.doctorId !=''"> and doctor_id = #{p.doctorId} <if test="p.doctorId != null and p.doctorId !=''"> and doctor_id = #{p.doctorId} </if> <if test="p.doctorName != null and p.doctorName !=''"> and doctor_name = #{p.doctorName} <if test="p.doctorName != null and p.doctorName !=''"> and doctor_name = #{p.doctorName} </if> <if test="p.doctorTel != null and p.doctorTel !=''"> and doctor_tel = #{p.doctorTel} <if test="p.doctorTel != null and p.doctorTel !=''"> and doctor_tel = #{p.doctorTel} </if> <if test="p.departmentId != null and p.departmentId !=''"> and department_id = #{p.departmentId} <if test="p.departmentId != null and p.departmentId !=''"> and department_id = #{p.departmentId} </if> <if test="p.departmentName != null and p.departmentName !=''"> and department_name = #{p.departmentName} <if test="p.departmentName != null and p.departmentName !=''"> and department_name = #{p.departmentName} </if> <if test="p.hospitalId != null and p.hospitalId !=''"> and hospital_id = #{p.hospitalId} <if test="p.hospitalId != null and p.hospitalId !=''"> and hospital_id = #{p.hospitalId} </if> <if test="p.hospitalName != null and p.hospitalName !=''"> and hospital_name = #{p.hospitalName} <if test="p.hospitalName != null and p.hospitalName !=''"> and hospital_name = #{p.hospitalName} </if> <if test="p.feedbackNote != null and p.feedbackNote !=''"> and feedback_note = #{p.feedbackNote} <if test="p.feedbackNote != null and p.feedbackNote !=''"> and feedback_note = #{p.feedbackNote} </if> <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> </where> </where> </sql> <!--定义根据-SysFeedback当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.SysFeedback"> select <include refid="Column_List"/> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.SysFeedback"> select <include refid="Column_List"/> from sys_feedback <include refid="where"/> order by id desc @@ -76,8 +77,10 @@ <!--定义根据-SysFeedback当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.SysFeedback"> select <include refid="Column_List"/> select <include refid="Column_List"/> from sys_feedback <include refid="where"/> order by id desc </select> </mapper> kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/SysLoggerMapper.xml
@@ -12,36 +12,37 @@ <where> <!--查询条件自行添加--> p.is_del=0 <if test="p.applicationName != null and p.applicationName !=''"> and application_name = #{p.applicationName} <if test="p.applicationName != null and p.applicationName !=''"> and application_name = #{p.applicationName} </if> <if test="p.className != null and p.className !=''"> and class_name = #{p.className} <if test="p.className != null and p.className !=''"> and class_name = #{p.className} </if> <if test="p.methodName != null and p.methodName !=''"> and method_name = #{p.methodName} <if test="p.methodName != null and p.methodName !=''"> and method_name = #{p.methodName} </if> <if test="p.userId != null and p.userId !=''"> and user_id = #{p.userId} <if test="p.userId != null and p.userId !=''"> and user_id = #{p.userId} </if> <if test="p.userName != null and p.userName !=''"> and user_name = #{p.userName} <if test="p.userName != null and p.userName !=''"> and user_name = #{p.userName} </if> <if test="p.clientId != null and p.clientId !=''"> and client_id = #{p.clientId} <if test="p.clientId != null and p.clientId !=''"> and client_id = #{p.clientId} </if> <if test="p.operation != null and p.operation !=''"> and operation = #{p.operation} <if test="p.operation != null and p.operation !=''"> and operation = #{p.operation} </if> <if test="p.timestamp != null and p.timestamp !=''"> and timestamp = #{p.timestamp} <if test="p.timestamp != null and p.timestamp !=''"> and timestamp = #{p.timestamp} </if> </where> </where> </sql> <!--定义根据-SysLogger当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.SysLogger"> select <include refid="Column_List"/> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.SysLogger"> select <include refid="Column_List"/> from sys_logger <include refid="where"/> order by id desc @@ -49,8 +50,10 @@ <!--定义根据-SysLogger当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.SysLogger"> select <include refid="Column_List"/> select <include refid="Column_List"/> from sys_logger <include refid="where"/> order by id desc </select> </mapper> kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/SysProductMapper.xml
@@ -12,57 +12,58 @@ <where> <!--查询条件自行添加--> p.is_del=0 <if test="p.id != null and p.id !=''"> and id = #{p.id} <if test="p.id != null and p.id !=''"> and id = #{p.id} </if> <if test="p.proName != null and p.proName !=''"> and pro_name = #{p.proName} <if test="p.proName != null and p.proName !=''"> and pro_name = #{p.proName} </if> <if test="p.proTime != null and p.proTime !=''"> and pro_time = #{p.proTime} <if test="p.proTime != null and p.proTime !=''"> and pro_time = #{p.proTime} </if> <if test="p.proType != null and p.proType !=''"> and pro_type = #{p.proType} <if test="p.proType != null and p.proType !=''"> and pro_type = #{p.proType} </if> <if test="p.proPrice != null and p.proPrice !=''"> and pro_price = #{p.proPrice} <if test="p.proPrice != null and p.proPrice !=''"> and pro_price = #{p.proPrice} </if> <if test="p.recordCount != null and p.recordCount !=''"> and record_count = #{p.recordCount} <if test="p.recordCount != null and p.recordCount !=''"> and record_count = #{p.recordCount} </if> <if test="p.ailightCount != null and p.ailightCount !=''"> and ailight_count = #{p.ailightCount} <if test="p.ailightCount != null and p.ailightCount !=''"> and ailight_count = #{p.ailightCount} </if> <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} <if test="p.isDel != null and p.isDel !=''"> and is_del = #{p.isDel} </if> <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} <if test="p.enabled != null and p.enabled !=''"> and enabled = #{p.enabled} </if> <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} <if test="p.createUserId != null and p.createUserId !=''"> and create_user_id = #{p.createUserId} </if> <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} <if test="p.createUserName != null and p.createUserName !=''"> and create_user_name = #{p.createUserName} </if> <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} <if test="p.updateUserId != null and p.updateUserId !=''"> and update_user_id = #{p.updateUserId} </if> <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} <if test="p.updateUserName != null and p.updateUserName !=''"> and update_user_name = #{p.updateUserName} </if> <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} <if test="p.createTime != null and p.createTime !=''"> and create_time = #{p.createTime} </if> <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} <if test="p.updateTime != null and p.updateTime !=''"> and update_time = #{p.updateTime} </if> </where> </where> </sql> <!--定义根据-SysProduct当作查询条件返回对象--> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.SysProduct"> select <include refid="Column_List"/> <select id="findByObject" resultType="com.kidgrow.oprationcenter.model.SysProduct"> select <include refid="Column_List"/> from sys_product <include refid="where"/> order by id desc @@ -70,8 +71,10 @@ <!--定义根据-SysProduct当作查询条件返回对象集合--> <select id="findList" resultType="com.kidgrow.oprationcenter.model.SysProduct"> select <include refid="Column_List"/> select <include refid="Column_List"/> from sys_product <include refid="where"/> order by id desc </select> </mapper>