接口按service_donatebaseinfo表ReportTime 字段倒序
| | |
| | | <if test="startDeathtime != null and endDeathtime != null ">and sdi.DeathTime BETWEEN #{startDeathtime} and #{endDeathtime}</if> |
| | | </where> |
| | | |
| | | order by sd.InpatientNo desc |
| | | order by sd.ReportTime desc |
| | | <if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if> |
| | | </select> |
| | | |
| | |
| | | <if test="gcsScore != null ">and gcs_score = #{gcsScore}</if> |
| | | </where> |
| | | |
| | | order by ReportTime desc |
| | | order by service_donatebaseinfo.ReportTime desc |
| | | <if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if> |
| | | </select> |
| | | |
| | |
| | | <if test="id != null ">and sdt.id = #{id}</if> |
| | | <if test="state != null and state != ''">and sdm.state = #{state}</if> |
| | | </where> |
| | | order by sd.InpatientNo desc |
| | | order by sd.ReportTime desc |
| | | <if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if> |
| | | |
| | | </select> |
| | |
| | | </if> |
| | | <if test="startTime != null and endTime != null ">and sdb.allocation_time BETWEEN #{startTime} and #{endTime}</if> |
| | | </where> |
| | | order by sd.InpatientNo desc |
| | | order by sd.ReportTime desc |
| | | <if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if> |
| | | </select> |
| | | |
| | |
| | | <if test="infoid != null">and sd.ID = #{infoid}</if> |
| | | <if test="witnessState != null">and st.witness_state = #{witnessState}</if> |
| | | </where> |
| | | order by sd.InpatientNo desc |
| | | order by sd.ReportTime desc |
| | | <if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if> |
| | | </select> |
| | | |
| | |
| | | <if test="status != null ">and se.status = #{status}</if> |
| | | <if test="startTime != null and endTime != null ">and se.start_time BETWEEN #{startTime} and #{endTime}</if> |
| | | </where> |
| | | order by sd.InpatientNo desc |
| | | order by sd.ReportTime desc |
| | | <if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if> |
| | | </select> |
| | | |
| | |
| | | #{treatmenthospitalname} |
| | | </if> |
| | | </where> |
| | | order by sb.InpatientNo desc |
| | | order by sb.ReportTime desc |
| | | |
| | | <if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if> |
| | | |
| | |
| | | and sr.SignDate <= #{endSigndate} |
| | | </if> |
| | | </where> |
| | | order by sd.InpatientNo desc |
| | | order by sd.ReportTime desc |
| | | <if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if> |
| | | </select> |
| | | |