| | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * @Company: 西安路泰科技有限公司 |
| | |
| | | JSONObject entries = JSONUtil.parseObj(json); |
| | | String card = entries.getStr("card"); |
| | | // TjCustomer customer = tjCustomerMapper.getCusInfo(card); |
| | | List<TjCustomer> customer = tjCustomerMapper.getCusInfoList(card); |
| | | List<Map<String ,Object>> customer = tjCustomerMapper.getCusInfoList(card); |
| | | return AjaxResult.success(customer); |
| | | } |
| | | |
| | |
| | | .antMatchers(HttpMethod.GET, "/", "/*.html", "/**/*.html", "/**/*.css", "/**/*.js", "/profile/**").permitAll() |
| | | .antMatchers("/swagger-ui.html", "/swagger-resources/**", "/webjars/**", "/*/api-docs", "/druid/**").permitAll() |
| | | // 三方可调用接口 |
| | | .antMatchers("/api/viewReport","/api/reportData").permitAll() |
| | | .antMatchers("/api/viewReport","/api/reportData","/api/getInfo").permitAll() |
| | | .antMatchers("/jmreport/**","/lis/**","/pacs/**","/callBack/**","/hosp/order/signOrderInfo").anonymous() |
| | | // 除上面外的所有请求全部需要鉴权认证 |
| | | .anyRequest().authenticated() |
| | |
| | | "/lis/**","/api/His/**","/pacs/**", |
| | | "/callBack/**", |
| | | "/api/viewReport", |
| | | "/api/reportData" |
| | | "/api/reportData", |
| | | "/api/getInfo" |
| | | }); |
| | | |
| | | registry.addInterceptor(dbChangeInterceptor) |
| | |
| | | |
| | | TjCustomer getCusInfo(@Param("card") String card); |
| | | |
| | | List<TjCustomer> getCusInfoList(String card); |
| | | List<Map<String ,Object >> getCusInfoList(String card); |
| | | } |
| | |
| | | o.create_time DESC |
| | | LIMIT 1 |
| | | </select> |
| | | <select id="getCusInfoList" resultType="com.ltkj.hosp.domain.TjCustomer"> |
| | | <select id="getCusInfoList" resultType="java.util.Map"> |
| | | SELECT |
| | | c.cus_name as name, |
| | | c.cus_idcard as card, |
| | |
| | | c.cus_brithday as csrq, |
| | | o.tj_number as tjNum, |
| | | c.cus_phone as phone, |
| | | o.create_time as time, |
| | | DATE_FORMAT(o.create_time, '%Y-%m-%d %H:%i:%s') as time, |
| | | TIMESTAMPDIFF(YEAR, c.cus_brithday, CURDATE()) - |
| | | CASE |
| | | WHEN MONTH(c.cus_brithday) > MONTH(CURDATE()) |
| | | OR (MONTH(c.cus_brithday) = MONTH(CURDATE()) AND DAY(c.cus_brithday) > DAY(CURDATE())) |
| | | THEN 1 |
| | | ELSE 0 |
| | | END AS age |
| | | END AS age, |
| | | CASE WHEN r.re_id IS NOT NULL THEN 1 ELSE 0 END AS type |
| | | FROM |
| | | tj_order o |
| | | JOIN tj_customer c ON o.user_id = c.cus_id |
| | | LEFT JOIN tj_report r ON o.tj_number = r.tj_number |
| | | WHERE |
| | | c.cus_idcard = #{card} |
| | | ORDER BY |