dySdDesigner/conf/sqlroot/com/sdtool/business/dao/DesignDao.dql

-- [selectDesignFonts]
select * from $table$;

-- [addDesignFont]
insert into $table$ (id, fontName, fontThumbUrl, voidFlag,
fontFilePath, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong ) values ( #{id}, #{fontname}, #{fontthumburl}, #{voidflag},
#{fontfilepath}, #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

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

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

-- [selectDesignTemplateItems]
select * from $table$ where idTemplate = #{idTemplate};

-- [addDesignTemplate]
insert into $table$ (id, templateName, backgroundPath, viewThumbPath,
canvasHeight, canvasWidth, breedHeight,
breedWidth, idProduct, voidFlag,
jsonContent, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong ) values ( #{id}, #{templatename}, #{backgroundpath}, #{viewthumbpath},
#{canvasheight}, #{canvaswidth}, #{breedheight},
#{breedwidth}, #{idproduct}, #{voidflag},
#{jsoncontent}, #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

-- [updateDesignTemplate]
update $table$ set templateName = #{templatename}, jsonContent = #{jsoncontent},
updateBy = #{updateby},
updateTime = #{updatetime}
where id = #{id};

-- [updateDesignTemplateThumb]
update $table$ set templateName = #{templatename}, viewThumbPath = #{viewthumbpath},
updateBy = #{updateby},
updateTime = #{updatetime}
where id = #{id};

-- [addDesignTemplateItem]
insert into $table$ (id, idTemplate, itemType, locationX,
locationY, sizeWidth, sizeHeight,
rotation, zIndex, jsonContent,
createBy, createTime, createTimeLong,
updateBy, updateTime, updateTimeLong ) values ( #{id}, #{idtemplate}, #{itemtype}, #{locationx},
#{locationy}, #{sizewidth}, #{sizeheight},
#{rotation}, #{zindex}, #{jsoncontent},
#{createby}, #{createtime}, #{createtimelong},
#{updateby}, #{updatetime}, #{updatetimelong} );

-- [deleteDesignTemplateItem]
delete from $table$ where idTemplate = #{id};

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