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,
incomePlatformId, incomePlatformName, incomePlatformOrderCode,
incomePlatformOrderTime, incomePlatformOrderTimeLong, suggestDeliverTime,
suggestDeliverTimeLong, orderSequence, idStore, storeName,
deliverFee, deliverDistance, deliverAddressAll,
outGoingPlatformId, outGoingPlatformName, voidFlag,
createBy, createTime, createTimeLong,
updateBy, updateTime, updateTimeLong ) values ( #{id}, #{ordername}, #{ordercode}, #{orderstatus},
#{incomeplatformid}, #{incomeplatformname}, #{incomeplatformordercode},
#{incomeplatformordertime}, #{incomeplatformordertimelong}, #{suggestdelivertime},
#{suggestdelivertimelong}, #{ordersequence}, #{idstore}, #{storename},
#{deliverfee}, #{deliverdistance}, #{deliveraddressall},
#{outgoingplatformid}, #{outgoingplatformname}, #{voidflag},
#{createby}, #{createtime}, #{createtimelong},
#{updateby}, #{updatetime}, #{updatetimelong} );

-- [addOrderFinances]
insert into $table$ (id, idOrder, orderMoney, deliverFee,
orderPlatformSubsidy, storeDiscount, customerPaid,
platformServiceFee, storeRealCollection, createBy,
createTime, createTimeLong, updateBy,
updateTime, updateTimeLong ) values ( #{id}, #{idorder}, #{ordermoney}, #{deliverfee},
#{orderplatformsubsidy}, #{storediscount}, #{customerpaid},
#{platformservicefee}, #{storerealcollection}, #{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, createBy,
createTime, createTimeLong, updateBy,
updateTime, updateTimeLong ) values ( #{id}, #{idorder}, #{itemname}, #{itemprice},
#{itemcount}, #{itemmoney}, #{createby},
#{createtime}, #{createtimelong}, #{updateby},
#{updatetime}, #{updatetimelong} );

-- [addOrderStep]
insert into $table$ (idOrder, idWorkMan, workMan, workTime,
workMemo, workExplain, createBy,
createTime, createTimeLong, updateBy,
updateTime, updateTimeLong ) values ( #{idorder}, #{idworkman}, #{workman}, #{worktime},
#{workmemo}, #{workexplain}, #{createby},
#{createtime}, #{createtimelong}, #{updateby},
#{updatetime}, #{updatetimelong} );