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

examinationFinancialByQuery

• 根据条件获取ExaminationInstances数据 用于学生创建实训/练习实例 个人业务处理方法 SELECT * FROM examination_instances WHERE team_id=#teamId# AND examination_id=#examinationId# AND flow_id=#flowId#

queryByCondition

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

  select @pageTag(){ t.* @} from examination_instances t where 1=1
  @//数据权限，该sql语句功能点,如果不考虑数据权限，可以删除此行
  and #function("examinationInstances.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(examinationId)){ and t.examination_id =#examinationId# @} @if(!isEmpty(flowId)){ and t.flow_id =#flowId# @} @if(!isEmpty(finishStep)){ and t.finish_step =#finishStep# @} @if(!isEmpty(status)){ and t.status =#status# @} @if(!isEmpty(teamId)){ and t.team_id =#teamId# @}

deleteExaminationInstancesByIds

• 批量删除

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

getExaminationInstancesValues

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

  select t.* from examination_instances 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(examinationId)){ and t.examination_id =#examinationId# @} @if(!isEmpty(flowId)){ and t.flow_id =#flowId# @} @if(!isEmpty(finishStep)){ and t.finish_step =#finishStep# @} @if(!isEmpty(status)){ and t.status =#status# @} @if(!isEmpty(teamId)){ and t.team_id =#teamId# @}

getValuesByQuery

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

  select t.* from examination_instances 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(examinationId)){ and t.examination_id =#examinationId# @} @if(!isEmpty(flowId)){ and t.flow_id =#flowId# @} @if(!isEmpty(finishStep)){ and t.finish_step =#finishStep# @} @if(!isEmpty(status)){ and t.status =#status# @} @if(!isEmpty(teamId)){ and t.team_id =#teamId# @}

finishStep

• 完成当前步骤

  update examination_instances
  set finish_step = #step# where id = #id# and finish_step < #step#