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

-- [queryStoreBrandList]
select *
from $table$
-- trim prefix=WHERE prefixOverrides=AND|OR
  -- if voidFlag >= 0
    voidFlag = #{voidFlag}
  -- end
-- end
-- isEmpty orderBy
order by createTime desc
-- else
order by #{orderBy}
-- end
;

-- [addStoreBrand]
insert into $table$ (id, brandName, brandLogoUrl, startingPrice,
packagingFee, brandMemo, voidFlag,
createBy, createTime, createTimeLong,
updateBy, updateTime, updateTimeLong ) values ( #{id}, #{brandname}, #{brandlogourl}, #{startingprice},
#{packagingfee}, #{brandmemo}, #{voidflag},
#{createby}, #{createtime}, #{createtimelong},
#{updateby}, #{updatetime}, #{updatetimelong} );

-- [updateStoreBrand]
update $table$ set brandName = #{brandname},brandLogoUrl = #{brandlogourl},startingPrice = #{startingprice},packagingFee = #{packagingfee},
brandMemo = #{brandmemo},updateBy = #{updateby},updateTime = #{updatetime},updateTimeLong = #{updatetimelong}
 where id = #{id};

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

 -- [updateBrandLogoUrl]
  update $table$ set brandLogoUrl = #{brandlogourl} where id = #{id};

 -- [queryStoreInfoList]
 select *
 from $table$
 -- trim prefix=WHERE prefixOverrides=AND|OR
   -- if voidFlag >= 0
     voidFlag = #{voidFlag}
   -- end
 -- end
 -- isEmpty orderBy
 order by createTime desc
 -- else
 order by #{orderBy}
 -- end
 ;

 -- [addStoreInfo]
 insert into $table$ (id, storeName, idBrand, brandName,
 idStoreType, deliverSettleKind, storeCodeInput,
 storeProvince, storeCity, storeDistrict,
 storeAddress, locationStr, contractPhone, storeBossId,
 companyLicenseNo, companyLicensePicUrl, legalPersonIdNo,
 legalPersonName, voidFlag, enableInvoice,
 createBy, createTime, createTimeLong,
 updateBy, updateTime, updateTimeLong ) values ( #{id}, #{storename}, #{idbrand}, #{brandname},
 #{idstoretype}, #{deliversettlekind}, #{storecodeinput},
 #{storeprovince}, #{storecity}, #{storedistrict},
 #{storeaddress}, #{locationstr}, #{contractphone}, #{storebossid},
 #{companylicenseno}, #{companylicensepicurl}, #{legalpersonidno},
 #{legalpersonname}, #{voidflag}, #{enableinvoice},
 #{createby}, #{createtime}, #{createtimelong},
 #{updateby}, #{updatetime}, #{updatetimelong} );

 -- [updateStoreInfo]
 update $table$ set storeName = #{storename},idBrand = #{idbrand}, brandName = #{brandname},
 idStoreType = #{idstoretype}, deliverSettleKind = #{deliversettlekind},storeCodeInput = #{storecodeinput},
 storeProvince = #{storeprovince},storeCity = #{storecity}, storeDistrict = #{storedistrict},
 storeAddress = #{storeaddress},locationStr = #{locationstr},contractPhone = #{contractphone},
 storeBossId = #{storebossid}, companyLicenseNo = #{companylicenseno},companyLicensePicUrl = #{companylicensepicurl},
 legalPersonIdNo = #{legalpersonidno},legalPersonName = #{legalpersonname},enableInvoice = #{enableinvoice},
 updateBy = #{updateby},updateTime = #{updatetime},updateTimeLong = #{updatetimelong}
 where id = #{id};

 -- [updateStoreEnableInvoice]
  update $table$ set enableInvoice = #{enableinvoice},updateBy = #{updateby},
  updateTime = #{updatetime},updateTimeLong = #{updatetimelong} where id = #{id};

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

-- [queryStoreInvoiceList]
select *
 from $table$
 -- trim prefix=WHERE prefixOverrides=AND|OR
   -- if voidFlag >= 0
     voidFlag = #{voidFlag}
   -- end
 -- end
 -- isEmpty orderBy
 order by createTime desc
 -- else
 order by #{orderBy}
 -- end
 ;

-- [addStoreInvoiceInfo]
insert into $table$ (id, idStore, taxIdNo, companyName,
defaultTaxItemName, defaultTaxItemCode, taxRate,
createBy, createTime, createTimeLong,
updateBy, updateTime, updateTimeLong ) values ( #{id}, #{idstore}, #{taxidno}, #{companyname},
#{defaulttaxitemname}, #{defaulttaxitemcode}, #{taxrate},
#{createby}, #{createtime}, #{createtimelong},
#{updateby}, #{updatetime}, #{updatetimelong} );

-- [updateStoreInvoiceInfo]
update $table$ set idStore = #{idstore},taxIdNo = #{taxidno},companyName = #{companyname},defaultTaxItemName = #{defaulttaxitemname},
defaultTaxItemCode = #{defaulttaxitemcode},taxRate = #{taxrate},updateBy = #{updateby},updateTime = #{updatetime},updateTimeLong = #{updatetimelong}
 where id = #{id};

-- [queryStorePlatformList]
select *
 from $table$
 -- trim prefix=WHERE prefixOverrides=AND|OR
   -- if voidFlag >= 0
     voidFlag = #{voidFlag}
   -- end
 -- end
 -- isEmpty orderBy
 order by createTime desc
 -- else
 order by #{orderBy}
 -- end
;

-- [queryStorePlatformRequireList]
select *
 from $table$
 -- trim prefix=WHERE prefixOverrides=AND|OR
   -- if voidFlag >= 0
     voidFlag = #{voidFlag}
   -- end
 -- end
 -- isEmpty orderBy
 order by createTime desc
 -- else
 order by #{orderBy}
 -- end
;

-- [addStorePlatform]
insert into $table$ (id, idStore, platformStoreId, idPlatformInfo, platformName, platformCode,
platformType, enableStatue, createBy,
createTime, createTimeLong, updateBy,
updateTime, updateTimeLong ) values ( #{id}, #{idstore}, #{platformstoreid}, #{idplatforminfo}, #{platformname}, #{platformcode},
#{platformtype}, #{enablestatue}, #{createby},
#{createtime}, #{createtimelong}, #{updateby},
#{updatetime}, #{updatetimelong} );

-- [addStorePlatformRequire]
insert into $table$ (id, idStore, idStorePlatform, idPlatformRequire,
platformRequireCode, platformRequireName, itemValue,
createBy, createTime, createTimeLong,
updateBy, updateTime, updateTimeLong ) values ( #{id}, #{idstore}, #{idstoreplatform}, #{idplatformrequire},
#{platformrequirecode}, #{platformrequirename}, #{itemvalue},
#{createby}, #{createtime}, #{createtimelong},
#{updateby}, #{updatetime}, #{updatetimelong} );

-- [updateStorePlatform]
update $table$ set enableStatue = #{enablestatue},
updateBy = #{updateby},updateTime = #{updatetime},updateTimeLong = #{updatetimelong} where id = #{id};

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

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