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

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

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

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

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

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


-- [addBusinessOrder]
insert into $table$ (id, orderName, orderCode, orderStatus,
orderSequence, incomePlatformId, incomePlatformName,
incomePlatformOrderCode, incomePlatformOrderTime, incomePlatformOrderTimeLong,
suggestDeliverTime, suggestDeliverTimeLong, idStore,
storeName, deliverFee, deliverDistance,
deliverAddressAll, outGoingPlatformId, outGoingPlatformName,
voidFlagIn, voidFlagOut, createBy,
createTime, createTimeLong, updateBy,
updateTime, updateTimeLong ) values ( #{id}, #{ordername}, #{ordercode}, #{orderstatus},
#{ordersequence}, #{incomeplatformid}, #{incomeplatformname},
#{incomeplatformordercode}, #{incomeplatformordertime}, #{incomeplatformordertimelong},
#{suggestdelivertime}, #{suggestdelivertimelong}, #{idstore},
#{storename}, #{deliverfee}, #{deliverdistance},
#{deliveraddressall}, #{outgoingplatformid}, #{outgoingplatformname},
#{voidflagin}, #{voidflagout}, #{createby},
#{createtime}, #{createtimelong}, #{updateby},
#{updatetime}, #{updatetimelong} );

-- [addOrderFinances]
insert into $table$ (id, idOrder, orderMoney, deliverFee,
orderPlatformSubsidy, storeDiscount, customerPaid,
customerRefunded, platformServiceFee, storeRealCollection,
omeServiceFee, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong ) values ( #{id}, #{idorder}, #{ordermoney}, #{deliverfee},
#{orderplatformsubsidy}, #{storediscount}, #{customerpaid},
#{customerrefunded}, #{platformservicefee}, #{storerealcollection},
#{omeservicefee}, #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

-- [addOrderDeliveryInfo]
insert into $table$ (id, idOrder, deliverProvince, deliverCity,
deliverDistract, deliverAddress, geoLocationSerial,
receiveMan, contractPhone, deliverTimeliness,
bookingDeliverTime, bookingDeliverTimeLong, customerInvoiceInfo,
customerMemo, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong ) values ( #{id}, #{idorder}, #{deliverprovince}, #{delivercity},
#{deliverdistract}, #{deliveraddress}, #{geolocationserial},
#{receiveman}, #{contractphone}, #{delivertimeliness},
#{bookingdelivertime}, #{bookingdelivertimelong}, #{customerinvoiceinfo},
#{customermemo}, #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

-- [addOrderDetailItem]
insert into $table$ (id, idOrder, itemName, itemPrice,
itemCount, itemMoney, itemDetail, createBy,
createTime, createTimeLong, updateBy,
updateTime, updateTimeLong ) values ( #{id}, #{idorder}, #{itemname}, #{itemprice},
#{itemcount}, #{itemmoney}, #{itemdetail}, #{createby},
#{createtime}, #{createtimelong}, #{updateby},
#{updatetime}, #{updatetimelong} );

-- [addOrderStep]
insert into $table$ (idOrder, idWorkMan, workMan, workTime,
workMemo, workExplain) values ( #{idorder}, #{idworkman}, #{workman}, #{worktime},
#{workmemo}, #{workexplain});

-- [acceptBusinessOrder]
update $table$ set orderStatus = #{orderstatus}, updateBy = #{updateby},updateTime = #{updatetime},updateTimeLong = #{updatetimelong}
where id = #{id};

-- [voidBusinessOrderIn]
update $table$ set voidFlagIn = #{voidflagin}, updateBy = #{updateby}, updateTime = #{updatetime}, updateTimeLong = #{updatetimelong}
where id = #{id};

-- [addOrderAfterSaleBill]
insert into $table$ (id, idOrder, idStore, outPlatformStoreId,
idStorePlatform, platformCode, platformType,
platformName, outAfterSaleId, idRefundRequest,
refundReasonCodes, refundReasonMsgs, applySource,
billCode, userRefundAmount, totalUserRefundAmount,
prodCountAfterRefund, productsRemainDetail, productsRefundDetail,
createBy, createTime, createTimeLong,
updateBy, updateTime, updateTimeLong ) values ( #{id}, #{idorder}, #{idstore}, #{outplatformstoreid},
#{idstoreplatform}, #{platformcode}, #{platformtype},
#{platformname}, #{outaftersaleid}, #{idrefundrequest},
#{refundreasoncodes}, #{refundreasonmsgs}, #{applysource},
#{billcode}, #{userrefundamount}, #{totaluserrefundamount},
#{prodcountafterrefund}, #{productsremaindetail}, #{productsrefunddetail},
#{createby}, #{createtime}, #{createtimelong},
#{updateby}, #{updatetime}, #{updatetimelong} );

-- [addOrderRefundRequest]
insert into $table$ (id, idOrder, idStore, outPlatformStoreId,
idStorePlatform, platformCode, platformType,
platformName, outAfterSaleId, requestStatus,
refundReasonCodes, userRefundMemo, refundType,
refuseToRefundReasonCodes, refuseToRefundMemo, deliveryFee,
refundFee, refundProdCount, refundProductsDetail,
orderName, orderCode, createBy,
createTime, createTimeLong, updateBy,
updateTime, updateTimeLong ) values ( #{id}, #{idorder}, #{idstore}, #{outplatformstoreid},
#{idstoreplatform}, #{platformcode}, #{platformtype},
#{platformname}, #{outaftersaleid}, #{requeststatus},
#{refundreasoncodes}, #{userrefundmemo}, #{refundtype},
#{refusetorefundreasoncodes}, #{refusetorefundmemo}, #{deliveryfee},
#{refundfee}, #{refundprodcount}, #{refundproductsdetail},
#{ordername}, #{ordercode}, #{createby},
#{createtime}, #{createtimelong}, #{updateby},
#{updatetime}, #{updatetimelong} );

-- [updateOrderRefundRequest]
update $table$ set requestStatus = #{requeststatus}, updateBy = #{updateby},updateTime = #{updatetime},updateTimeLong = #{updatetimelong}
where id = #{id};

-- [updateOrderFinances]
update $table$ set orderMoney = #{ordermoney},deliverFee = #{deliverfee},orderPlatformSubsidy = #{orderplatformsubsidy},
storeDiscount = #{storediscount},customerRefunded = #{customerrefunded},platformServiceFee = #{platformservicefee},
storeRealCollection = #{storerealcollection},omeServiceFee = #{omeservicefee},updateBy = #{updateby},updateTime = #{updatetime},updateTimeLong = #{updatetimelong}
 where id = #{id};

 -- [updateBusinessOrder]
 update $table$ set deliverFee = #{deliverfee}, deliverAddressAll = #{deliveraddressall} ,
 updateBy = #{updateby},updateTime = #{updatetime},updateTimeLong = #{updatetimelong}
 where id = #{id};

 -- [updateOrderDeliveryInfo]
 update $table$ set deliverProvince = #{deliverprovince},deliverCity = #{delivercity},deliverDistract = #{deliverdistract},
 deliverAddress = #{deliveraddress},geoLocationSerial = #{geolocationserial},receiveMan = #{receiveman},contractPhone = #{contractphone},
 deliverTimeliness = #{delivertimeliness},bookingDeliverTime = #{bookingdelivertime},bookingDeliverTimeLong = #{bookingdelivertimelong},customerInvoiceInfo = #{customerinvoiceinfo},
 updateBy = #{updateby},updateTime = #{updatetime},updateTimeLong = #{updatetimelong} where id = #{id};