| | |
| | | </if> |
| | | <if test="message!=null and message!=''"> |
| | | and code like concat('%',#{message},'%') |
| | | or name like concat('%',#{message},'%') |
| | | or device.name like concat('%',#{message},'%') |
| | | </if> |
| | | </select> |
| | | <!--根据设备分组查询设备--> |
| | |
| | | <result property="name" column="father"/> |
| | | </resultMap> |
| | | <select id="selectAllTechTem" resultMap="selectAllTechTemMap"> |
| | | select e.name elname, |
| | | select e.name elname, |
| | | father |
| | | from mom_ocean.technology_template t, |
| | | mom_ocean.element e, |
| | |
| | | where e.id = et.element_id |
| | | and t.id = tech_tem_id |
| | | and t.state = 1 |
| | | and et.state=1 |
| | | and type=#{type} |
| | | <if test="message!=null and message!=''"> |
| | | and father like concat('%',#{message},'%') |
| | |
| | | @PostMapping("/compile") |
| | | public Result compile(Integer id) { |
| | | ordersService.compile(id); |
| | | return Result.success("编制产品"+id+"完成!"); |
| | | return Result.success("编制产品完成!"); |
| | | } |
| | | |
| | | } |
| | |
| | | |
| | | <!--右侧数据展示 工艺路线--> |
| | | <resultMap id="selectAllTecMap" type="map"> |
| | | <id property="name" column="father"/> |
| | | <id property="father" column="father"/> |
| | | <collection property="children" resultMap="selectAllTecMaps" javaType="List"/> |
| | | </resultMap> |
| | | <resultMap id="selectAllTecMaps" type="map"> |
| | |
| | | datasource: |
| | | type: com.alibaba.druid.pool.DruidDataSource |
| | | driverClassName: com.mysql.cj.jdbc.Driver |
| | | url: jdbc:mysql://192.168.218.113:3306/mom_ocean?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8 |
| | | url: jdbc:mysql://192.168.0.22:3306/mom_ocean?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8 |
| | | username: user |
| | | password: 123456 |
| | | druid: |
| | |
| | | # redis数据库索引(默认为0),我们使用索引为3的数据库,避免和其他数据库冲突 |
| | | database: 0 |
| | | # redis服务器地址(默认为localhost) |
| | | host: 192.168.218.113 |
| | | host: 192.168.0.22 |
| | | # redis端口(默认为6379) |
| | | port: 6379 |
| | | # redis访问密码(默认为空) |