| | |
| | | <mapper namespace="com.kidgrow.oprationcenter.mapper.ProductOrderDetailMapper"> |
| | | <!--定义查询列--> |
| | | <sql id="Column_List"> |
| | | * |
| | | DISTINCT * |
| | | </sql> |
| | | |
| | | <!--sql查询片段--> |
| | |
| | | <mapper namespace="com.kidgrow.oprationcenter.mapper.ProductOrderMapper"> |
| | | <!--定义查询列--> |
| | | <sql id="Column_List"> |
| | | * |
| | | DISTINCT * |
| | | </sql> |
| | | |
| | | <!--sql查询片段--> |
| | |
| | | <mapper namespace="com.kidgrow.oprationcenter.mapper.ProductOrderRecordMapper"> |
| | | <!--定义查询列--> |
| | | <sql id="Column_List"> |
| | | * |
| | | DISTINCT * |
| | | </sql> |
| | | |
| | | <!--sql查询片段--> |
| | |
| | | <mapper namespace="com.kidgrow.oprationcenter.mapper.SysProductMapper"> |
| | | <!--定义查询列--> |
| | | <sql id="Column_List"> |
| | | * |
| | | DISTINCT * |
| | | </sql> |
| | | <!--定义数据权限的查询--> |
| | | <sql id="Role_Organization"> |
| | |
| | | <mapper namespace="com.kidgrow.usercenter.mapper.SysCompanyMapper"> |
| | | <!--定义查询列--> |
| | | <sql id="Column_List"> |
| | | * |
| | | DISTINCT * |
| | | </sql> |
| | | |
| | | <!--sql查询片段--> |
| | |
| | | <mapper namespace="com.kidgrow.usercenter.mapper.SysDoctorMapper"> |
| | | <!--定义查询列--> |
| | | <sql id="Column_List"> |
| | | * |
| | | DISTINCT * |
| | | </sql> |
| | | |
| | | <!--sql查询片段--> |
| | |
| | | <choose> |
| | | <when test="inx == 1"> |
| | | <if test="itemto.flag"> |
| | | and 1=1 |
| | | </if> |
| | | <if test="!itemto.flag"> |
| | | or (1=1 and HOS.is_del = 0 and HOS.enabled=1) |
| | | or ( HOS.is_del = 0 and HOS.enabled=1) |
| | | </if> |
| | | </when> |
| | | <when test="inx==2"> |
| | |
| | | </sql> |
| | | <select id="findHospitalList" resultType="com.kidgrow.usercenter.vo.HospitalListVo"> |
| | | SELECT |
| | | DISTINCT |
| | | DEP.department_name, |
| | | DEP.id department_id, |
| | | DEP.server_user_name, |
| | |
| | | <choose> |
| | | <when test="inx == 1"> |
| | | <if test="itemto.flag"> |
| | | and 1=1 |
| | | |
| | | </if> |
| | | <if test="!itemto.flag"> |
| | | or (1=1 and is_del = 0 and enabled=1) |
| | | or ( is_del = 0 and enabled=1) |
| | | </if> |
| | | </when> |
| | | <when test="inx==2"> |
| | |
| | | } else { |
| | | sysOrganization.setOrgName(sysHospital.getHospitalName()); |
| | | } |
| | | boolean org = organizationService.saveOrUpdate(sysOrganization); |
| | | boolean org = organizationService.saveOrUpdateSer(sysOrganization); |
| | | sysHospital.setOrgId(sysOrganization.getId()); |
| | | List<SysOrganization> organizations = sysUser.getOrganizations(); |
| | | if (organizations.size() > 0) { |