dyDeliver/conf/sqlroot/com/dderp/business/dao/PlatformDao.dql

-- [queryPlatformInfoList]
select *
from $table$
-- trim prefix=WHERE prefixOverrides=AND|OR
  -- isNotEmpty voidFlag
      -- if voidFlag >= 0
        voidFlag = #{voidFlag}
      -- end
  -- end
  -- isNotEmpty platformType
      -- if platformType >= 0
        and platformType = #{platformType}
      -- end
  -- end
  -- isNotEmpty keyWord
    and (platformName LIKE #{Like:keyWord})
  -- end
-- end
-- isEmpty orderBy
order by createTime desc
-- else
order by #{orderBy}
-- end
;

-- [addPlatformInfo]
insert into $table$ (
id, platformCode, platformName, platformType,
voidFlag, needAccessToken, refreshTokenSeconds, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong )
values (
#{id}, #{platformcode}, #{platformname}, #{platformtype},
#{voidflag},  #{needaccesstoken}, #{refreshtokenseconds}, #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

-- [updatePlatformInfo]
update $table$ set
platformName = #{platformname},
platformType = #{platformtype},
platformCode = #{platformcode},
updateBy = #{updateby},
updateTime = #{updatetime},
updateTimeLong = #{updatetimelong}
where id = #{id};

-- [voidPlatformInfo]
update $table$ set
voidFlag = #{voidflag},
updateBy = #{updateby},
updateTime = #{updatetime},
updateTimeLong = #{updatetimelong}
where id = #{id};


-- [queryPlatformRequireList]
select *
from $table$
-- trim prefix=WHERE prefixOverrides=AND|OR
  -- isNotEmpty idPlatform
      -- if idPlatform >= 0
        idPlatform = #{idPlatform}
      -- end
  -- end
  -- isNotEmpty voidFlag
      -- if voidFlag >= 0
        and voidFlag = #{voidFlag}
      -- end
  -- end
  -- isNotEmpty keyWord
    and (requireName LIKE #{Like:keyWord})
  -- end
-- end
-- isEmpty orderBy
order by createTime desc
-- else
order by #{orderBy}
-- end
;

-- [addPlatformRequire]
insert into $table$
(id, idPlatform, requireName, requireCode, valueType,
voidFlag, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong )
values
( #{id}, #{idplatform}, #{requirename}, #{requirecode}, #{valuetype},
#{voidflag}, #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

-- [updatePlatformRequire]
update $table$ set
requireCode = #{requirecode},
requireName = #{requirename},
updateBy = #{updateby},
updateTime = #{updatetime},
updateTimeLong = #{updatetimelong}
where id = #{id};

-- [voidPlatformRequire]
update $table$ set
voidFlag = #{voidflag},
updateBy = #{updateby},
updateTime = #{updatetime},
updateTimeLong = #{updatetimelong}
where id = #{id};