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,
platformServiceFee, storeRealCollection, omeServiceFee, createBy,
createTime, createTimeLong, updateBy,
updateTime, updateTimeLong ) values ( #{id}, #{idorder}, #{ordermoney}, #{deliverfee},
#{orderplatformsubsidy}, #{storediscount}, #{customerpaid},
#{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, 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}, #{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};