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};

 -- [addOrderDiscount]
 insert into $table$ (id, idOrder, discountName, discountType,
 discountAmount, merchantDiscountAmount, platformDiscountAmount,
 createBy, createTime, createTimeLong,
 updateBy, updateTime, updateTimeLong ) values ( #{id}, #{idorder}, #{discountname}, #{discounttype},
 #{discountamount}, #{merchantdiscountamount}, #{platformdiscountamount},
 #{createby}, #{createtime}, #{createtimelong},
 #{updateby}, #{updatetime}, #{updatetimelong} );


-- [expressCreateOrder]
update $table$ set
outGoingPlatformId = #{outgoingplatformid},
outGoingPlatformName = #{outgoingplatformname},
outGoingPlatformOrderCode = #{outgoingplatformordercode},
outGoingPlatformBillCode = #{outgoingplatformbillcode},
orderStatus = #{orderStatus},
updateBy = #{updateby},
updateTime = #{updatetime},
updateTimeLong = #{updatetimelong}
where id = #{id};

-- [expressCreateOrderFinance]
update $table$ set
expressTotalPrice = #{expresstotalprice},
expressFreeSendServiceFee = #{expressfreesendservicefee},
expressTotalPayMoney = #{expresstotalpaymoney},
expressRealPayMoney = #{expressrealpaymoney},
expressCouponsTotalFee = #{expresscouponstotalfee},
updateBy = #{updateby},
updateTime = #{updatetime},
updateTimeLong = #{updatetimelong}
where id = #{id};

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

-- [addOrderRiderItem]
insert into $table$ (
id, idOrder, riderStatus, statusDesc,
idPlatform, platformCode, platformName,
platformOrderId, operatorName, operatorPhone,
riderLng, riderLat, itemContent,
createBy, createTime, createTimeLong, updateBy,
updateTime, updateTimeLong )
values (
#{id}, #{idorder}, #{riderstatus}, #{statusdesc},
#{idplatform}, #{platformcode}, #{platformname},
#{platformorderid}, #{operatorname}, #{operatorphone},
#{riderlng}, #{riderlat}, #{itemcontent},
#{createby}, #{createtime}, #{createtimelong}, #{updateby},
#{updatetime}, #{updatetimelong} );