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

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

-- [initFile]
select 0;

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

-- [addWorkProcess]
insert into $table$ (
id, processName, specialFlag, workProcessIds,
plateFlag, platePDFIndex,
selectFlag, queueFlag, feedBackFlag,
isFeedBack, feedBackContent, voidFlag,
remark,materialTypeIds,sortNum, baseMoney, price,
createBy, createTime,createTimeLong,
updateBy, updateTime,updateTimeLong )
values (
#{id},#{processname},#{specialflag},#{workprocessids},
#{plateflag},#{platepdfindex},
#{selectflag},#{queueflag},#{feedbackflag},
#{isfeedback}, #{feedbackcontent},#{voidflag},
#{remark},#{materialtypeids},#{sortnum}, #{basemoney}, #{price},
#{createby},#{createtime},#{createtimelong},
#{updateby},#{updatetime}, #{updatetimelong} );

-- [updateWorkProcess]
update $table$ set processName = #{processname},specialFlag = #{specialflag},
plateFlag = #{plateflag},workProcessIds = #{workprocessids},
platePDFIndex = #{platepdfindex},selectFlag = #{selectflag},
queueFlag = #{queueflag},feedBackFlag = #{feedbackflag},
isFeedBack = #{isfeedback},feedBackContent = #{feedbackcontent},
voidFlag = #{voidflag},remark = #{remark},sortNum = #{sortnum},
materialTypeIds = #{materialtypeids},updateBy = #{updateby},
updateTime = #{updatetime},updateTimeLong = #{updatetimelong},
baseMoney = #{basemoney}, price = #{price}
where id = #{id};

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

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

-- [addProductType]
insert into $table$ (id, productTypeName, parentId, voidFlag,
createBy, createTime, createTimeLong,
updateBy, updateTime, updateTimeLong ) values ( #{id}, #{producttypename}, #{parentid}, #{voidflag},
#{createby}, #{createtime}, #{createtimelong},
#{updateby}, #{updatetime}, #{updatetimelong} );

-- [updateProductType]
update $table$ set productTypeName = #{producttypename},parentId = #{parentid},voidFlag = #{voidflag},
updateBy = #{updateby},updateTime = #{updatetime},
updateTimeLong = #{updatetimelong} where id = #{id};

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

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


-- [addProductParameter]
insert into $table$
(id, parameterName, parameterFieldPart,
parameterFieldOrder, fieldType, selectKind,
idDictType, parameterUnit, defaultValue,
voidFlag, createBy, createTime,
updateBy, updateTime)
values (
#{id}, #{parametername}, #{parameterfieldpart},
#{parameterfieldorder}, #{fieldtype}, #{selectkind},
#{iddicttype}, #{parameterunit}, #{defaultvalue},
#{voidflag}, #{createby}, #{createtime},
#{updateby}, #{updatetime}
);

-- [updateProductParameter]
update $table$ set
parameterName = #{parametername},
parameterFieldPart = #{parameterfieldpart},
parameterFieldOrder = #{parameterfieldorder},
fieldType = #{fieldtype},
selectKind = #{selectkind},
idDictType = #{iddicttype},
parameterUnit = #{parameterunit},
defaultValue = #{defaultvalue},
updateBy = #{updateby},
updateTime = #{updatetime}
where id = #{id};

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

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

--[deleteProductParameterByIds]
delete from $table$ where id in (/* in ids */)

-- [selectProductInfo]
select * from $table$ where id = #{id};

-- [addProductInfo]
insert into $table$ (
id, idType,  productName,
productUnit, makeUpType, billPrefix, billCodeTimeKind,
orderPrefix, isSelfHelp,compageVisibleFlag,
productImage, photoFixFlag,
voidFlag, saleFlag, idPartner,
idProductPriceInfo,minDeliveryDay,systemType,
createBy, createTime, createTimeLong,
updateBy, updateTime, updateTimeLong) values (
#{id}, #{idtype},  #{productname},
#{productunit}, #{makeuptype}, #{billprefix}, #{billcodetimekind},
#{orderprefix},  #{isselfhelp},#{compagevisibleflag},
#{productimage}, #{photofixflag},
#{voidflag}, #{saleflag},#{idpartner},
#{idproductpriceinfo},#{mindeliveryday},#{systemtype},
#{createby}, #{createtime}, #{createtimelong},
#{updateby}, #{updatetime}, #{updatetimelong});

-- [updateProductInfo]
update $table$ set
idType = #{idtype},
productName = #{productname},
productUnit = #{productunit},
compageVisibleFlag = #{compagevisibleflag},
makeUpType = #{makeuptype},
billPrefix = #{billprefix},
billCodeTimeKind = #{billcodetimekind},
orderPrefix = #{orderprefix},
productImage = #{productimage},
isSelfHelp = #{isselfhelp},
photoFixFlag = #{photofixflag},
idProductPriceInfo = #{idproductpriceinfo},
saleFlag = #{saleflag},
idPartner = #{idpartner},
updateBy = #{updateby},
updateTime = #{updatetime},
updateTimeLong = #{updatetimelong},
minDeliveryDay = #{mindeliveryday},
systemType = #{systemtype}
where id = #{id};

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

-- [saveSaleFlag]
update $table$ set
saleFlag =  #{saleflag},
updateBy =  #{updateby},
updateTime =  #{updatetime}
where id = #{id};

-- [insertProductImage]
insert into $table$ (id, idProduct, idUser, userName,
srcFileName, fileDescription, viewImageUrl,
sortNum, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong ) values ( #{id}, #{idproduct}, #{iduser}, #{username},
#{srcfilename}, #{filedescription}, #{viewimageurl},
#{sortnum}, #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

-- [selectProductImageList]
select * from $table$
order by idProduct, sortNum;

-- [deleteProductImage]
delete from $table$
where idProduct = #{idproduct};

-- [selectPartInfo]
select *
from $table$
where idProduct = #{idproduct};

-- [addPartInfo]
insert into $table$ (id, idProduct, partName, partBlood,
sortNum, voidFlag, saleUnit,idPaperType,transformCoefficient,defaultBasePaper,
printUnit, partFace, createBy,
createTime, createTimeLong, updateBy,
updateTime, updateTimeLong,mainFlag,partDesc) values ( #{id}, #{idproduct}, #{partname}, #{partblood},
#{sortnum}, #{voidflag}, #{saleunit},#{idpapertype},#{transformcoefficient},#{defaultbasepaper},
#{printunit}, #{partface}, #{createby},
#{createtime}, #{createtimelong}, #{updateby},
#{updatetime}, #{updatetimelong},#{mainflag},#{partdesc});

-- [updatePartInfo]
update $table$ set idProduct = #{idproduct},partName = #{partname},partBlood = #{partblood},sortNum = #{sortnum},
voidFlag = #{voidflag},saleUnit = #{saleunit},printUnit = #{printunit},partFace = #{partface},
idPaperType = #{idpapertype},transformCoefficient = #{transformcoefficient},
updateBy = #{updateby},updateTime = #{updatetime},mainFlag=#{mainflag},
partDesc = #{partdesc},defaultBasePaper = #{defaultbasepaper},
updateTimeLong = #{updatetimelong} where id = #{id};

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

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

-- [selectPartParameter]
select *
from $table$
where idPartInfo = #{idpartinfo}
order by sortNum;

-- [addPartParameter]
insert into $table$ (
id, idParameter, parameterName, idProduct,
productName, idPartInfo, partName,
defaultValue, sortNum,
parameterHint,selectKind,
cssType, placeHolder,
createBy, createTime, createTimeLong,
updateBy, updateTime, updateTimeLong )
values (
#{id}, #{idparameter}, #{parametername}, #{idproduct},
#{productname}, #{idpartinfo}, #{partname},
#{defaultvalue}, #{sortnum},
#{parameterhint},#{selectkind},
#{csstype}, #{placeholder},
#{createby}, #{createtime},#{createtimelong},
#{updateby}, #{updatetime},#{updatetimelong} );

-- [updatePartParameter]
update $table$ set
idParameter = #{idparameter},
parameterName = #{parametername},
idProduct = #{idproduct},
productName = #{productname},
idPartInfo = #{idpartinfo},
partName = #{partname},
defaultValue = #{defaultvalue},
sortNum = #{sortnum},
parameterHint = #{parameterhint},
selectKind = #{selectkind},
cssType = #{csstype},
placeHolder = #{placeholder},
updateBy = #{updateby},
updateTime = #{updatetime},
updateTimeLong = #{updatetimelong}
where id = #{id};

-- [savePartParameter]
update $table$ set defaultValue = #{defaultvalue},
isDefaultValue = #{isdefaultvalue},
updateBy = #{updateby},updateTime = #{updatetime},updateTimeLong = #{updatetimelong} where id = #{id};

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

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

-- [deletePartParameterByParentId]
delete from $table$
where parentId = #{parentid};

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

-- [deletePartParameterItemByProductParameter]
delete from $table$
where idParameter = #{idparameter} and idPartInfo = #{idpartinfo};

-- [addPartParameterItem]
insert into $table$
(id, idProduct, idPartInfo, idParameter,
itemName, itemValue, itemControl,
sortNum,
createBy, createTime,createTimeLong,
updateBy, updateTime,updateTimeLong )
values ( #{id}, #{idproduct}, #{idpartinfo}, #{idparameter},
#{itemname}, #{itemvalue}, #{itemcontrol},
#{sortnum},
#{createby}, #{createtime}, #{createtimelong},
#{updateby}, #{updatetime}, #{updatetimelong} );

-- [updatePartParameterItem]
update $table$ set
itemName = #{itemname},
itemValue = #{itemvalue},
sortNum = #{sortnum},
updateBy = #{updateby},updateTime = #{updatetime},
updateTimeLong = #{updatetimelong}
 where id = #{id};

 -- [configPartParameterItemControl]
 update $table$ set
 itemControl = #{itemcontrol},
 updateBy = #{updateby},updateTime = #{updatetime},
 updateTimeLong = #{updatetimelong}
  where id = #{id};

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

-- [selectPartWorkProcess]
select *
from $table$
where idPartInfo = #{idpartinfo}
order by sortNum;

-- [addPartWorkProcess]
insert into $table$ (id, idProduct, productName, idPartInfo,
partInfoName, idWorkProcess, sortNum,isDefault,
workProcessName, isRequired, cssType,
createBy, createTime, createTimeLong,
updateBy, updateTime, updateTimeLong ) values ( #{id}, #{idproduct}, #{productname}, #{idpartinfo},
#{partinfoname}, #{idworkprocess}, #{sortnum},#{isdefault},
#{workprocessname}, #{isrequired}, #{csstype},
#{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

-- [updatePartWorkProcess]
update $table$ set idProduct = #{idproduct},productName = #{productname},idPartInfo = #{idpartinfo},partInfoName = #{partinfoname},
idWorkProcess = #{idworkprocess},sortNum = #{sortnum},workProcessName = #{workprocessname},isRequired = #{isrequired},isDefault = #{isdefault},
cssType = #{csstype},createBy = #{createby},createTime = #{createtime},
createTimeLong = #{createtimelong},updateBy = #{updateby},updateTime = #{updatetime},updateTimeLong = #{updatetimelong}
 where id = #{id};

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

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

-- [queryAllSkuProductCategory]
select *
from $table$
order by parentId, sortNum;

-- [selectSkuProductCategoryInfo]
select * from $table$ where id = #{id};

-- [addSkuProductCategory]
insert into $table$ (id, parentId,  categoryName,
sortNum, voidFlag, createBy,
createTime, createTimeLong, updateBy,
updateTime, updateTimeLong ) values ( #{id}, #{parentid},  #{categoryname},
#{sortnum}, #{voidflag},
#{createby}, #{createtime}, #{createtimelong},
#{updateby}, #{updatetime}, #{updatetimelong} );

-- [updateSkuProductCategory]
update $table$ set parentId = #{parentid},categoryName = #{categoryname},sortNum = #{sortnum},
voidFlag = #{voidflag},createBy = #{createby},createTime = #{createtime},
createTimeLong = #{createtimelong},updateBy = #{updateby},updateTime = #{updatetime},updateTimeLong = #{updatetimelong}
 where id = #{id};

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

-- [selectSkuCategorySpec]
select *
from $table$
where categoryId = #{categoryid}
order by sortNum;

-- [addSkuCategorySpec]
insert into $table$ (id, categoryId, categoryName, specName,
saleFlag, sortNum, voidFlag,
createBy, createTime, createTimeLong,
updateBy, updateTime, updateTimeLong ) values ( #{id}, #{categoryid}, #{categoryname}, #{specname},
#{saleflag}, #{sortnum}, #{voidflag},
 #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

-- [updateSkuCategorySpec]
update $table$ set categoryId = #{categoryid},categoryName = #{categoryname},specName = #{specname},saleFlag = #{saleflag},
sortNum = #{sortnum},voidFlag = #{voidflag},createBy = #{createby},
createTime = #{createtime},createTimeLong = #{createtimelong},updateBy = #{updateby},updateTime = #{updatetime},
updateTimeLong = #{updatetimelong} where id = #{id};

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

-- [selectSkuCategorySpecValue]
select *
from $table$
where specId = #{specid}
order by sortNum;

-- [addSkuCategorySpecValue]
insert into $table$ (id, specId, categoryId, infoName,
sortNum, voidFlag, createBy,
createTime, createTimeLong, updateBy,
updateTime, updateTimeLong ) values ( #{id}, #{specid}, #{categoryid}, #{infoname},
#{sortnum}, #{voidflag}, #{createby},
#{createtime}, #{createtimelong}, #{updateby},
#{updatetime}, #{updatetimelong} );

-- [updateSkuCategorySpecValue]
update $table$ set specId = #{specid},categoryId = #{categoryid},infoName = #{infoname},sortNum = #{sortnum},
voidFlag = #{voidflag},createBy = #{createby},createTime = #{createtime},createTimeLong = #{createtimelong},
updateBy = #{updateby},updateTime = #{updatetime},updateTimeLong = #{updatetimelong} where id = #{id};

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

-- [selectProductSkuPrice]
select * from $table$
where idProduct = #{idProduct}
order by sortNum;

-- [insertProductSkuPrice]
insert into $table$ (id, idProduct, skuCode, skuName,
skuPrice, skuPriceValue, skuQuantity,
skuImageUrl, sortNum, createBy,
createTime, createTimeLong, updateBy,
updateTime, updateTimeLong ) values ( #{id}, #{idproduct}, #{skucode}, #{skuname},
#{skuprice}, #{skupricevalue}, #{skuquantity},
#{skuimageurl}, #{sortnum}, #{createby},
#{createtime}, #{createtimelong},#{updateby},
#{updatetime}, #{updatetimelong} );

-- [deleteProductSkuPrice]
delete from $table$
where idProduct = #{idproduct};

-- [selectProductSkuPriceValue]
select * from $table$
where idProduct = #{idproduct}
and skuCode = #{skucode};

-- [insertProductSkuPriceValue]
insert into $table$ (id, idProduct, skuCode, specId,
valueId, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong ) values ( #{id}, #{idproduct}, #{skucode}, #{specid},
#{valueid}, #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

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

-- [selectProductSkuSpec]
select * from $table$
where idProduct = #{idProduct}
order by sortNum;

-- [insertProductSkuSpec]
insert into $table$ (id, idProduct, specId, specName,
sortNum, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong ) values ( #{id}, #{idproduct}, #{specid}, #{specname},
#{sortnum}, #{createby},
#{createtime}, #{createtimelong}, #{updateby},
#{updatetime}, #{updatetimelong} );

-- [deleteProductSkuSpec]
delete from $table$
where idProduct = #{idProduct};

-- [selectProductSkuValue]
select * from $table$
where idProduct = #{idproduct}
and specId = #{specid}
order by sortNum;

-- [insertProductSkuValue]
insert into $table$ (id, idProduct, categoryId, specId,
specName, valueId, valueName,
sortNum, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong ) values ( #{id}, #{idproduct}, #{categoryid}, #{specid},
#{specname}, #{valueid}, #{valuename},
#{sortnum}, #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

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

-- [selectPartParameterItem]
select * from $table$ where idPartInfo = #{idPartInfo} and idParameter = #{idParameter};


--[queryAllMachineGroups]
select * from $table$

--[addMachineGroup]
insert into $table$ (id, machineGroupCode, machineGroupName, capacity,
machineDetail, voidFlag, createBy,
createTime, createTimeLong, updateBy,
updateTime, updateTimeLong ) values ( #{id}, #{machinegroupcode}, #{machinegroupname}, #{capacity},
#{machinedetail}, #{voidflag}, #{createby},
#{createtime}, #{createtimelong}, #{updateby},
#{updatetime}, #{updatetimelong} );

-- [updateMachineGroup]
update $table$ set machineGroupCode = #{machinegroupcode},machineGroupName = #{machinegroupname},capacity = #{capacity},machineDetail = #{machinedetail},
voidFlag = #{voidflag},createBy = #{createby},createTime = #{createtime},createTimeLong = #{createtimelong},
updateBy = #{updateby},updateTime = #{updatetime},updateTimeLong = #{updatetimelong} where id = #{id};

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

-- [insertProductPagePrice]
insert into $table$ (
id, priceName, price, voidFlag,
createBy, createTime, createTimeLong,
updateBy, updateTime, updateTimeLong )
values (
#{id}, #{pricename}, #{price}, #{voidflag},
#{createby}, #{createtime}, #{createtimelong},
#{updateby}, #{updatetime}, #{updatetimelong}
);

-- [updateProductPagePrice]
update $table$ set
priceName = #{pricename},
price = #{price},
updateBy = #{updateby},
updateTime = #{updatetime},
updateTimeLong = #{updatetimelong}
where id = #{id};

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

-- [selectPartInfosByProduct]
select * from $table$ where voidFlag = 0 and idProduct in (/* in idProducts */);

-- [insertProductRoom]
insert into $table$ (id, roomName, sortIndex, maxVolume,
volumeRatio, memos, voidFlag,
createBy, createTime, createTimeLong,
updateBy, updateTime, updateTimeLong ) values ( #{id}, #{roomname}, #{sortindex}, #{maxvolume},
#{volumeratio}, #{memos}, #{voidflag},
#{createby}, #{createtime}, #{createtimelong},
#{updateby}, #{updatetime}, #{updatetimelong});

-- [updateProductRoom]
update $table$ set roomName = #{roomname},sortIndex = #{sortindex},maxVolume = #{maxvolume},volumeRatio = #{volumeratio},
memos = #{memos},voidFlag = #{voidflag},createBy = #{createby},createTime = #{createtime},
createTimeLong = #{createtimelong},updateBy = #{updateby},updateTime = #{updatetime},updateTimeLong = #{updatetimelong}
 where id = #{id};

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

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