| | |
| | | |
| | | int updateDicValueByTypeAndCode(@Param("type") String type, @Param("code") String code, @Param("value") String value); |
| | | |
| | | DataDictionaryCustom selectDicDataByTypeAndCodeAndDesc(@Param("type") String type, @Param("code") String code, @Param("description") String plan); |
| | | DataDictionaryCustom selectDicDataByTypeAndCodeAndDesc(@Param("type") String type, @Param("description") String plan); |
| | | } |
| | |
| | | //获取挂机方案 |
| | | DataDictionaryCustom dataDictionaryCustom = dataDictionaryCustomMapper.selectDicDataByTypeAndCodeAndDesc( |
| | | DataDictionaryEnum.PLAN_A.getType(), |
| | | DataDictionaryEnum.PLAN_A.getCode(), |
| | | Integer.toString(Integer.parseInt(plan)+1)); |
| | | String dataDictionaryCustomValue = dataDictionaryCustom.getValue(); |
| | | JSONObject levelMemberValueParse = JSONUtil.parseObj(dataDictionaryCustomValue); |
| | |
| | | <select id="selectDicDataByTypeAndCodeAndDesc" resultType="cc.mrbird.febs.dapp.entity.DataDictionaryCustom"> |
| | | select * from data_dictionary_custom a |
| | | where a.type=#{type} |
| | | and a.code=#{code} |
| | | and a.description=#{description} |
| | | </select> |
| | | </mapper> |
| | |
| | | <update id="updateAvaAmountById"> |
| | | update igt_on_hook_plan_order |
| | | set |
| | | ava_amount = ava_amount - #{amount}, |
| | | ava_amount = ava_amount - #{amount} |
| | | where |
| | | id = #{id} |
| | | and ava_amount - #{amount} <![CDATA[ >= ]]> 0 |
| | |
| | | <update id="addAvaAmountById"> |
| | | update igt_on_hook_plan_order |
| | | set |
| | | ava_amount = ava_amount + #{amount}, |
| | | ava_amount = ava_amount + #{amount} |
| | | where |
| | | id = #{id} |
| | | </update> |
| | |
| | | //获取挂机方案 |
| | | DataDictionaryCustom dataDictionaryCustom = dataDictionaryCustomMapper.selectDicDataByTypeAndCodeAndDesc( |
| | | DataDictionaryEnum.PLAN_A.getType(), |
| | | DataDictionaryEnum.PLAN_A.getCode(), |
| | | Integer.toString(Integer.parseInt(plan)+1)); |
| | | String dataDictionaryCustomValue = dataDictionaryCustom.getValue(); |
| | | JSONObject levelMemberValueParse = JSONUtil.parseObj(dataDictionaryCustomValue); |