Imitation Box Horse - Order Discount Settlement (60)

Technical Stack
Appgallery connect

Development Preparation In the previous section, we implemented coupon selection and successfully displayed the post-coupon price to users. We also informed users in a user-friendly way about coupons that cannot be used. In this section, we will take the next step with coupon functionality, integrating coupon content with order settlement.

Functional Analysis Since our previous order list separated order-related and product-related information, we will similarly separate coupon content, storing only the ID for subsequent querying of the coupon amount. First, we need to modify the order table. When selecting a coupon, we retrieve relevant coupon information and submit it along with the order, facilitating querying of the post-coupon price in order details.

Code Implementation First, modify the orderlist table content:

{ "CloudDBZoneName": "default", "objectTypeName": "order_list", "fields": [ {"fieldName": "id", "fieldType": "Integer", "notNull": true, "belongPrimaryKey": true}, {"fieldName": "user_id", "fieldType": "Integer", "notNull": true, "defaultValue": 0}, {"fieldName": "order_code", "fieldType": "String"}, {"fieldName": "order_status", "fieldType": "Integer"}, {"fieldName": "order_product_id", "fieldType": "String"}, {"fieldName": "coupon_id", "fieldType": "Integer"}, {"fieldName": "address", "fieldType": "String"}, {"fieldName": "nickname", "fieldType": "String"}, {"fieldName": "phone", "fieldType": "String"}, {"fieldName": "order_remark", "fieldType": "String"}, {"fieldName": "pay_type", "fieldType": "String"}, {"fieldName": "order_create_time", "fieldType": "String"}, {"fieldName": "order_pay_time", "fieldType": "String"}, {"fieldName": "order_delivery_time", "fieldType": "String"}, {"fieldName": "order_over_time", "fieldType": "String"} ], "indexes": [ {"indexName": "field1Index", "indexList": [{"fieldName":"id","sortType":"ASC"}]} ], "permissions": [ {"role": "World", "rights": ["Read", "Upsert", "Delete"]}, {"role": "Authenticated", "rights": ["Read", "Upsert", "Delete"]}, {"role": "Creator", "rights": ["Read", "Upsert", "Delete"]}, {"role": "Administrator", "rights": ["Read", "Upsert", "Delete"]} ] }

Then, retrieve the coupon ID when selecting a coupon, implemented via callback:

// Custom pop-up window page onItemSelected: (coupon_id:number) => void= () => { };

// Checkout page @State coupon_id:number=0

couponController: CustomDialogController| null = new CustomDialogController({ builder: CouponCheckDialog({ couponPrice:this.couponPrice, price:this.price(), onItemSelected:(coupon_id:number)=>{ this.coupon_id=coupon_id } }), alignment: DialogAlignment.Bottom, customStyle:true });

Merge and submit information when settling the order:

Text("Submit Order") .fontColor(Color.White) .padding(10) .borderRadius(10) .backgroundColor("#d81e06") .fontSize(14) .onClick(async ()=>{ if (this.addressInfo!=null) { let databaseZone = cloudDatabase.zone('default'); try { for (let i = 0; i < this.productList.length; i++) { let productPush = new order_product_list(); productPush.id\=this.codeId+i productPush.order_product_id=this.codeId productPush.img=this.productList[i].productImgAddress productPush.price=this.productList[i].productPrice productPush.name\=this.productList[i].productName productPush.originalPrice=this.productList[i].productOriginalPrice productPush.spec=this.productList[i].productSpecName productPush.buyAmount=this.productList[i].buyAmount let num = await databaseZone.upsert(productPush); hilog.info(0x0000, 'testTag', Succeeded in upserting data, result: ${num}); } } catch (e) { hilog.info(0x0000, 'testTag', Failed to upsert data, error: ${e}); }

let orderPush = new order_list(); orderPush.id\=Math.floor(Math.random() * 1000000) orderPush.user_id=this.user!.user_id orderPush.order_product_id=String(this.codeId) orderPush.order_code=this.generateOrderNo(10) orderPush.order_status=0 if (this.remark!='') { orderPush.order_remark=this.remark } orderPush.coupon_id=this.coupon_id orderPush.address=this.addressInfo.address orderPush.nickname=this.addressInfo.nikeName orderPush.phone\=this.addressInfo.phone orderPush.order_create_time=this.formatCurrentDate() orderPush.order_pay_time=this.formatCurrentDate() let num = await databaseZone.upsert(orderPush); hilog.info(0x0000, 'testTag', Succeeded in upserting order data, result: ${num}); if (num>0) { for (let i = 0; i < this.productList.length; i++) { if (this.productList[i].isNeedPay) { let item = new cart_product_list(); item.id\=this.productList[i].id let listData = await databaseZone.delete(item); hilog.info(0x0000, 'testTag', Succeeded in deleting cart item, result: ${listData}); } } let eventData: emitter.EventData = { data: {} }; let innerEvent: emitter.InnerEvent = { eventId: 1012, priority: emitter.EventPriority.HIGH }; emitter.emit(innerEvent, eventData); router.replaceUrl({url:'pages/view/OrderSuccessPage',params:orderPush}) } } else { showToast("Please select an address first") } })

This implements the association between order settlement and coupons.