Supply_chain_finance/web/target/classes/sql/jlw/examinationFinancials.md

examinationFinancialByQuery

• 根据条件获取ExaminationFinancial数据 用于学生创建实训/练习实例 个人业务处理方法 SELECT * FROM examination_financials WHERE init_balance = #balance# AND balance=#balance# AND product_assets=0

getExaminationsAndUserExaminations

• 获取资产概况所需要的UserExaminations SELECT * FROM user_examinations ue LEFT JOIN examinations es ON ue.examination_id = es.id WHERE ue.user_id = #id# AND es.type = #type# @if(type==1){ AND es.status >= 1 @} ORDER BY ue.id DESC LIMIT 0,1

getLastExaminationFinancials

• 获取资产概况所需要的UserExaminations SELECT t1.* FROM examination_financials t1 JOIN user_examinations ue on t1.id = ue.financial_id JOIN examinations es ON ue.examination_id = es.id WHERE ue.user_id = #userId# AND es.type = #type# @if(type==1){ AND es.status >= 1 @} ORDER BY ue.id DESC LIMIT 0,1

getFinancialByExaminationId

• 根据考核ID查询相关资产信息

  SELECT t1.* FROM examination_financials t1 JOIN user_examinations t2 on t2.financial_id = t1.id JOIN examinations t3 ON t2.examination_id = t3.id WHERE t3.id = #examinationId# ORDER BY t3.id DESC LIMIT 0,1

getBalanceProductAssets

• 根据考核ID和角色ID查询资产信息

  select t1.* from examination_financials t1 JOIN user_examinations t2 on t2.financial_id = t1.id WHERE t2.examination_id = #examinationId# and t2.instance_id = #instanceId# and JSON_CONTAINS(t2.data->'$.roles', #roleId#)

updateBalanceProductAssets

• 根据考核ID和角色ID修改资产信息

  update examination_financials t JOIN user_examinations t2 on t2.financial_id = t.id SET @trim(){ @if(!isEmpty(balance)){ t.balance =#balance#, @} @if(!isEmpty(productAssets)){ t.product_assets =#productAssets#, @} @} WHERE t2.examination_id = #examinationId# and JSON_CONTAINS(t2.data->'$.roles', #roleId#)

incrementBalance

• 根据考核ID增加资产信息

  update examination_financials t1 JOIN user_examinations t2 on t2.financial_id = t1.id SET t1.balance = t1.balance + (#amount#) WHERE t2.examination_id = #examinationId# and t2.instance_id = #instanceId# and JSON_CONTAINS(t2.data->'$.roles', #roleId#)

decrementBalance

• 根据考核ID减少资产信息

  update examination_financials t1 JOIN user_examinations t2 on t2.financial_id = t1.id SET t1.balance = t1.balance - (#amount#) WHERE t2.examination_id = #examinationId# and t2.instance_id = #instanceId# and JSON_CONTAINS(t2.data->'$.roles', #roleId#)

incrementProductAssets

• 根据考核ID增加资产信息

  update examination_financials t1 JOIN user_examinations t2 on t2.financial_id = t1.id SET t1.product_assets = t1.product_assets + (#amount#) WHERE t2.examination_id = #examinationId# and t2.instance_id = #instanceId# and JSON_CONTAINS(t2.data->'$.roles', #roleId#)

decrementProductAssets

• 根据考核ID减少资产信息

  update examination_financials t1 JOIN user_examinations t2 on t2.financial_id = t1.id SET t1.product_assets = t1.product_assets - (#amount#) WHERE t2.examination_id = #examinationId# and t2.instance_id = #instanceId# and JSON_CONTAINS(t2.data->'$.roles', #roleId#)

queryByCondition

• 根据不为空的参数进行分页查询

  select @pageTag(){ t.* @} from examination_financials t where 1=1
  @//数据权限，该sql语句功能点,如果不考虑数据权限，可以删除此行
  and #function("examinationFinancials.query")# @if(!isEmpty(id)){ and t.id =#id# @} @if(!isEmpty(createdAt)){ and t.created_at =#createdAt# @} @if(!isEmpty(updatedAt)){ and t.updated_at =#updatedAt# @} @if(!isEmpty(data)){ and t.data =#data# @} @if(!isEmpty(initBalance)){ and t.init_balance =#initBalance# @} @if(!isEmpty(balance)){ and t.balance =#balance# @} @if(!isEmpty(productAssets)){ and t.product_assets =#productAssets# @} @if(!isEmpty(raiseRate)){ and t.raise_rate =#raiseRate# @} @if(!isEmpty(raiseOrders)){ and t.raise_orders =#raiseOrders# @}

deleteExaminationFinancialsByIds

• 批量删除

  delete from examination_financials where find_in_set(id,#ids#)

getExaminationFinancialsValues

• 根据不为空的参数进行查询

  select t.* from examination_financials t where 1=1
  @if(!isEmpty(id)){ and t.id =#id# @} @if(!isEmpty(createdAt)){ and t.created_at =#createdAt# @} @if(!isEmpty(updatedAt)){ and t.updated_at =#updatedAt# @} @if(!isEmpty(data)){ and t.data =#data# @} @if(!isEmpty(initBalance)){ and t.init_balance =#initBalance# @} @if(!isEmpty(balance)){ and t.balance =#balance# @} @if(!isEmpty(productAssets)){ and t.product_assets =#productAssets# @} @if(!isEmpty(raiseRate)){ and t.raise_rate =#raiseRate# @} @if(!isEmpty(raiseOrders)){ and t.raise_orders =#raiseOrders# @}

getValuesByQuery

• 根据不为空的参数进行查询

  select t.* from examination_financials t where 1=1
  @if(!isEmpty(id)){ and t.id =#id# @} @if(!isEmpty(createdAt)){ and t.created_at =#createdAt# @} @if(!isEmpty(updatedAt)){ and t.updated_at =#updatedAt# @} @if(!isEmpty(data)){ and t.data =#data# @} @if(!isEmpty(initBalance)){ and t.init_balance =#initBalance# @} @if(!isEmpty(balance)){ and t.balance =#balance# @} @if(!isEmpty(productAssets)){ and t.product_assets =#productAssets# @} @if(!isEmpty(raiseRate)){ and t.raise_rate =#raiseRate# @} @if(!isEmpty(raiseOrders)){ and t.raise_orders =#raiseOrders# @}