2026-01-30 16:39:26 192.168.8.202 47.75.192.130 candao -> input:{"accessKey":"e8bb3146fa718bd7","storeId":"7757","actionName":"candao.order.updateOrderStatus","data":{"driveDistance":0,"orderNo":"260130163432343815","cancelNote":"【系統】測試單\n","orderId":"1201807650385104896","thirdSn":"6314","pickUpTime":"2026-01-30 16:43:51","updateTime":"2026-01-30 16:39:33","storeId":"7757","extOrderId":"lhq9-2605-agn5","fromType":"foodpanda","brandId":319,"sn":"1","subStoreId":"03","cancelReason":204,"cancelReasonName":"客人原因-客人下错单","status":-1},"timestamp":1769762373791,"sign":"2ad173bc9f9eb8e15bfa788aef828646","ticket":"b3bea229-84a7-4c8d-bfe7-46acb5e051ac","serviceType":"pos","vendor":"standard"}
2026-01-30 16:39:26 192.168.8.202 47.75.192.130 candao-Foodpanda-1201807650385104896 -> 訂單未訂購(1201807650385104896)
2026-01-30 16:42:13 192.168.8.202 47.75.192.130 candao -> input:{"accessKey":"e8bb3146fa718bd7","storeId":"7757","actionName":"candao.order.addOrder","data":{"subStoreId":"03","orderId":"1201809617316532224","extOrderId":"lhq9-2605-acnh","orderNo":"260130164221299772","thirdSn":"6315","sn":"2","storeId":"7757","storeName":"城中泰（天水圍）","brandId":319,"brandName":"亞萊泰","menuId":"5751","counts":1,"longitude":"0","latitude":"0","name":"Kin Cheung","phone":"+85268743288","address":"No address","takeNo":"6315","orderType":2,"sendTime":"2026-01-30 16:51:50","fromType":"foodpanda","orderStatus":10,"orderTime":"2026-01-30 16:42:21","userNote":"【FOODORA】- **不需要餐具或飲管, 除非顧客在餐牌已點選 (Please provide cutlery or straws upon customer's requests)；","payType":2,"isPayed":true,"currency":"2","isInvoice":false,"invoiceType":0,"peopleNum":0,"isThirdDistribute":true,"price":68.1,"realTimeProductPrice":109.0,"productPrice":109.0,"deliveryFee":0.0,"mealFee":0.0,"discountPrice":-43.6,"merchantPrice":109.0,"merchantBearPrice":0.0,"thirdPlatformBearPrice":43.6,"fulfillServiceFee":0.0,"userChannel":"","commission":0.0,"allowanceServiceFee":0.0,"additionServiceFee":0.0,"baseLogisticsServiceFee":0.0,"userId":0,"isStoreFirstOrder":false,"isBrandFirstOrder":false,"discounts":[{"pid":"0","type":1,"childType":0,"title":"40% off $80","content":"40% off $8040% off $80","price":43.6,"thirdSubsidy":43.6,"merchantSubsidy":0.0,"agentSubsidy":0.0,"num":0,"totalAmount":0.0,"disProducts":[],"billPrice":0.0}],"products":[{"pid":"137034","subPid":"641037","isDiscount":false,"name":"T4 輕量馬沙文咖喱飯 (牛腩/雞扒/豬扒/原條吉列魚柳)","enName":"T4 Mini Massaman Curry Rice (Beef Brisket/ Chicken/ Whole Fish Cutlet)","price":72.0,"totalPrice":109.0,"realTimePrice":72.0,"realTimeTotalPrice":109.0,"num":1.0,"boxNum":1.0,"boxTotalNum":1,"boxTotalPrice":0.0,"boxPrice":0.0,"productTagUid":0,"taxRate":"","taxCategoryCode":"","weight":0.0,"itemDisc":0.0,"combos":[{"pid":"136480","subPid":"642081","isDiscount":false,"name":"雞扒","enName":"Chicked Breast","price":0.0,"addPrice":0.0,"totalPrice":0.0,"realTimePrice":0.0,"realTimeTotalPrice":0.0,"num":1.0,"boxNum":0.0,"boxPrice":0.0,"productTagUid":0,"weight":0.0,"itemDisc":0.0,"isTableware":false,"tablewareType":0},{"pid":"136510","subPid":"643022","isDiscount":false,"name":"青檸梳打","enName":"Lime Soda","price":12.0,"addPrice":12.0,"totalPrice":0.0,"realTimePrice":0.0,"realTimeTotalPrice":0.0,"num":1.0,"boxNum":0.0,"boxPrice":0.0,"productTagUid":0,"weight":0.0,"itemDisc":0.0,"isTableware":false,"tablewareType":0},{"pid":"136536","subPid":"643002","isDiscount":false,"name":"A1 椰汁千層糕 (2pcs)","enName":"A1 Coconut Milk Layered Cake (2pcs)","price":25.0,"addPrice":25.0,"totalPrice":0.0,"realTimePrice":0.0,"realTimeTotalPrice":0.0,"num":1.0,"boxNum":0.0,"boxPrice":0.0,"productTagUid":0,"weight":0.0,"itemDisc":0.0,"isTableware":false,"tablewareType":0}],"extTag":"","posName":"","posEnName":"","aliasName":"","isTableware":false,"tablewareType":0}],"driverStatus":0,"orderDate":"2026-01-30","originPrice":111.7,"deliveryOrderNo":"","finishTime":"","virtualMerchantPrice":"0.0","virtualCommission":"0","book":1,"orderChildType":0,"agentBearPrice":0.0,"weight":0.0,"distanceIncreaseFee":0.0,"timeIntervalMarkUpFee":0.0,"pricePremiums":0.0,"cpcAmount":0.0,"surCharge":2.7,"downgraded":0,"isFavorites":false,"isStorePlatformFirstOrder":false,"tax":0.0,"taxDetail":[{"type":"vat","tax":0.0,"taxCollector":0}]},"timestamp":1769762541476,"sign":"0b33633caeb51ce9a0a80e4df84b70d3","ticket":"24aeeb1d-bf4e-469b-94fa-5f9decc782dd","serviceType":"pos","vendor":"standard"}
error: 2026-01-30 16:42:13 192.168.8.202 47.75.192.130 candao-Foodpanda-1201809617316532224 -> [2] odbc_exec():  Error on line 2 in C:\fdb\webserver\www\candao\transaction.php
error: 2026-01-30 16:42:13 192.168.8.202 47.75.192.130 candao-Foodpanda-1201809617316532224 -> [2] odbc_exec():  Error on line 2 in C:\fdb\webserver\www\candao\transaction.php
error: 2026-01-30 16:42:13 192.168.8.202 47.75.192.130 candao-Foodpanda-1201809617316532224 -> [2] odbc_exec():  Error on line 2 in C:\fdb\webserver\www\candao\transaction.php
error: 2026-01-30 16:42:14 192.168.8.202 47.75.192.130 candao-Foodpanda-1201809617316532224 -> itemcode not found(641037):{"pid":"137034","subPid":"641037","isDiscount":false,"name":"T4 輕量馬沙文咖喱飯 (牛腩\/雞扒\/豬扒\/原條吉列魚柳)","enName":"T4 Mini Massaman Curry Rice (Beef Brisket\/ Chicken\/ Whole Fish Cutlet)","price":72,"totalPrice":109,"realTimePrice":72,"realTimeTotalPrice":109,"num":1,"boxNum":1,"boxTotalNum":1,"boxTotalPrice":0,"boxPrice":0,"productTagUid":0,"taxRate":"","taxCategoryCode":"","weight":0,"itemDisc":0,"combos":[{"pid":"136480","subPid":"642081","isDiscount":false,"name":"雞扒","enName":"Chicked Breast","price":0,"addPrice":0,"totalPrice":0,"realTimePrice":0,"realTimeTotalPrice":0,"num":1,"boxNum":0,"boxPrice":0,"productTagUid":0,"weight":0,"itemDisc":0,"isTableware":false,"tablewareType":0},{"pid":"136510","subPid":"643022","isDiscount":false,"name":"青檸梳打","enName":"Lime Soda","price":12,"addPrice":12,"totalPrice":0,"realTimePrice":0,"realTimeTotalPrice":0,"num":1,"boxNum":0,"boxPrice":0,"productTagUid":0,"weight":0,"itemDisc":0,"isTableware":false,"tablewareType":0},{"pid":"136536","subPid":"643002","isDiscount":false,"name":"A1 椰汁千層糕 (2pcs)","enName":"A1 Coconut Milk Layered Cake (2pcs)","price":25,"addPrice":25,"totalPrice":0,"realTimePrice":0,"realTimeTotalPrice":0,"num":1,"boxNum":0,"boxPrice":0,"productTagUid":0,"weight":0,"itemDisc":0,"isTableware":false,"tablewareType":0}],"extTag":"","posName":"","posEnName":"","aliasName":"","isTableware":false,"tablewareType":0}
2026-01-30 16:42:14 192.168.8.202 47.75.192.130 candao-Foodpanda-1201809617316532224 -> item not found(106)
2026-01-30 16:42:14 192.168.8.202 47.75.192.130 candao-Foodpanda-1201809617316532224 -> cancel order:{"accessKey": "e8bb3146fa718bd7","actionName": "candao.order.updateOrderStatus","timestamp": 1769762534000,"ticket": "9DC0AFC6-1F40-4B9A-97B0-029049E8D5A4","sign": "8bf0b21a6a68a48f07cb290343655aa5","serviceType": "pos","storeId":"7757","data": {"orderId":"1201809617316532224","extOrderId":"lhq9-2605-acnh","orderNo":"260130164221299772","storeId":"7757","status":-1,"cancelReason":403}}
2026-01-30 16:42:14 192.168.8.202 47.75.192.130 candao-Foodpanda-1201809617316532224 -> cancel order response:{"status":1,"msg":"操作成功","logId":"8fc54469-8efe-123c-e3bd-904b-8213a1b6","serverTime":1769762541709,"ticket":"9DC0AFC6-1F40-4B9A-97B0-029049E8D5A4"}
2026-01-30 16:42:14 192.168.8.202 47.75.192.130 candao-Foodpanda-1201809617316532224 -> cancel order:success
2026-01-30 16:42:14 192.168.8.202 47.75.192.130 candao -> input:{"accessKey":"e8bb3146fa718bd7","actionName":"candao.callback.postId","data":{"id":"9DC0AFC6-1F40-4B9A-97B0-029049E8D5A4","status":1,"message":"操作成功","type":"11","info":{"extOrderId":"lhq9-2605-acnh","subOrderId":"1201809617316532224","status":-1}},"timestamp":1769762541982,"sign":"7b60044b5b8fbd3ffa3b81624a0d2e24","ticket":"9DC0AFC6-1F40-4B9A-97B0-029049E8D5A4","serviceType":"pos","vendor":"standard"}
2026-01-30 16:42:14 192.168.8.202 47.75.192.130 candao -> actionName others(candao.callback.postId)
2026-01-30 16:42:24 192.168.8.202 47.75.192.130 candao -> input:{"accessKey":"e8bb3146fa718bd7","storeId":"7757","actionName":"candao.order.updateOrderStatus","data":{"driveDistance":0,"orderNo":"260130164221299772","cancelNote":"其它原因-其他原因","orderId":"1201809617316532224","thirdSn":"6315","pickUpTime":"2026-01-30 16:51:50","updateTime":"2026-01-30 16:42:21","storeId":"7757","extOrderId":"lhq9-2605-acnh","fromType":"foodpanda","brandId":319,"sn":"2","subStoreId":"03","cancelReason":501,"cancelReasonName":"其它原因-其他原因","status":-1},"timestamp":1769762551761,"sign":"4c39b55e9475274f70ad6f1598532b5c","ticket":"6b9d432a-830d-4903-a23e-69db42287ca2","serviceType":"pos","vendor":"standard"}
2026-01-30 16:42:24 192.168.8.202 47.75.192.130 candao-Foodpanda-1201809617316532224 -> 訂單未訂購(1201809617316532224)
2026-01-30 17:13:38 192.168.8.202 47.75.192.130 candao -> input:{"accessKey":"e8bb3146fa718bd7","storeId":"7757","actionName":"candao.order.addOrder","data":{"subStoreId":"03","orderId":"1201817520635183104","extOrderId":"lhq9-2605-5lg8","orderNo":"260130171345596515","thirdSn":"6316","sn":"3","storeId":"7757","storeName":"城中泰（天水圍）","brandId":319,"brandName":"亞萊泰","menuId":"5751","counts":2,"longitude":"0","latitude":"0","name":"********** **********","phone":"**********","address":"No address","takeNo":"6316","orderType":1,"sendTime":"2026-01-30 17:36:11","fromType":"foodpanda","orderStatus":10,"orderTime":"2026-01-30 17:13:45","userNote":"【FOODORA】- **不需要餐具或飲管, 除非顧客在餐牌已點選 (Please provide cutlery or straws upon customer's requests)；","payType":1,"isPayed":false,"currency":"2","paymentDetails":[{"type":1,"money":159.9,"typeName":"现金","payType":0,"num":0}],"isInvoice":false,"invoiceType":0,"peopleNum":0,"isThirdDistribute":true,"price":159.9,"realTimeProductPrice":156.0,"productPrice":156.0,"deliveryFee":0.0,"mealFee":0.0,"discountPrice":0.0,"merchantPrice":156.0,"merchantBearPrice":0.0,"thirdPlatformBearPrice":0.0,"fulfillServiceFee":0.0,"userChannel":"","commission":0.0,"allowanceServiceFee":0.0,"additionServiceFee":0.0,"baseLogisticsServiceFee":0.0,"userId":0,"isStoreFirstOrder":false,"isBrandFirstOrder":false,"discounts":[],"products":[{"pid":"137030","subPid":"641034","isDiscount":false,"name":"T1 Thai \"Hainan Chicken\" Rice","enName":"T1 Thai \"Hainan Chicken\" Rice","price":84.0,"totalPrice":84.0,"realTimePrice":84.0,"realTimeTotalPrice":84.0,"num":1.0,"boxNum":1.0,"boxTotalNum":1,"boxTotalPrice":0.0,"boxPrice":0.0,"productTagUid":0,"taxRate":"","taxCategoryCode":"","weight":0.0,"itemDisc":0.0,"combos":[{"pid":"136504","subPid":"643071","isDiscount":false,"name":"熱檸檬水","enName":"Hot Lemon Water","price":0.0,"addPrice":0.0,"totalPrice":0.0,"realTimePrice":0.0,"realTimeTotalPrice":0.0,"num":1.0,"boxNum":0.0,"boxPrice":0.0,"productTagUid":0,"weight":0.0,"itemDisc":0.0,"isTableware":false,"tablewareType":0}],"extTag":"","posName":"","posEnName":"","aliasName":"","isTableware":false,"tablewareType":0},{"pid":"137034","subPid":"641037","isDiscount":false,"name":"T4 輕量馬沙文咖喱飯 (牛腩/雞扒/豬扒/原條吉列魚柳)","enName":"T4 Mini Massaman Curry Rice (Beef Brisket/ Chicken/ Whole Fish Cutlet)","price":72.0,"totalPrice":72.0,"realTimePrice":72.0,"realTimeTotalPrice":72.0,"num":1.0,"boxNum":1.0,"boxTotalNum":1,"boxTotalPrice":0.0,"boxPrice":0.0,"productTagUid":0,"taxRate":"","taxCategoryCode":"","weight":0.0,"itemDisc":0.0,"combos":[{"pid":"136582","subPid":"642037","isDiscount":false,"name":"香茅豬扒","enName":"Lemongrass Pork Chop","price":0.0,"addPrice":0.0,"totalPrice":0.0,"realTimePrice":0.0,"realTimeTotalPrice":0.0,"num":1.0,"boxNum":0.0,"boxPrice":0.0,"productTagUid":0,"weight":0.0,"itemDisc":0.0,"isTableware":false,"tablewareType":0},{"pid":"136501","subPid":"643067","isDiscount":false,"name":"熱奶茶","enName":"Hot Milk Tea","price":0.0,"addPrice":0.0,"totalPrice":0.0,"realTimePrice":0.0,"realTimeTotalPrice":0.0,"num":1.0,"boxNum":0.0,"boxPrice":0.0,"productTagUid":0,"weight":0.0,"itemDisc":0.0,"isTableware":false,"tablewareType":0}],"extTag":"","posName":"","posEnName":"","aliasName":"","isTableware":false,"tablewareType":0}],"driverStatus":0,"orderDate":"2026-01-30","originPrice":159.9,"deliveryOrderNo":"","finishTime":"","virtualMerchantPrice":"0.0","virtualCommission":"0","book":1,"orderChildType":0,"agentBearPrice":0.0,"weight":0.0,"distanceIncreaseFee":0.0,"timeIntervalMarkUpFee":0.0,"pricePremiums":0.0,"cpcAmount":0.0,"surCharge":3.9,"downgraded":0,"isFavorites":false,"isStorePlatformFirstOrder":false,"tax":0.0,"taxDetail":[{"type":"vat","tax":0.0,"taxCollector":0}]},"timestamp":1769764425777,"sign":"e4cd46acf9d61271515f0c607c68614f","ticket":"fa2703ab-4a50-493a-9761-f4b9ff7d82de","serviceType":"pos","vendor":"standard"}
error: 2026-01-30 17:13:38 192.168.8.202 47.75.192.130 candao-Foodpanda-1201817520635183104 -> [2] odbc_exec():  Error on line 2 in C:\fdb\webserver\www\candao\transaction.php
error: 2026-01-30 17:13:38 192.168.8.202 47.75.192.130 candao-Foodpanda-1201817520635183104 -> [2] odbc_exec():  Error on line 2 in C:\fdb\webserver\www\candao\transaction.php
error: 2026-01-30 17:13:38 192.168.8.202 47.75.192.130 candao-Foodpanda-1201817520635183104 -> [2] odbc_exec():  Error on line 2 in C:\fdb\webserver\www\candao\transaction.php
error: 2026-01-30 17:13:38 192.168.8.202 47.75.192.130 candao-Foodpanda-1201817520635183104 -> itemcode not found(641034):{"pid":"137030","subPid":"641034","isDiscount":false,"name":"T1 Thai \"Hainan Chicken\" Rice","enName":"T1 Thai \"Hainan Chicken\" Rice","price":84,"totalPrice":84,"realTimePrice":84,"realTimeTotalPrice":84,"num":1,"boxNum":1,"boxTotalNum":1,"boxTotalPrice":0,"boxPrice":0,"productTagUid":0,"taxRate":"","taxCategoryCode":"","weight":0,"itemDisc":0,"combos":[{"pid":"136504","subPid":"643071","isDiscount":false,"name":"熱檸檬水","enName":"Hot Lemon Water","price":0,"addPrice":0,"totalPrice":0,"realTimePrice":0,"realTimeTotalPrice":0,"num":1,"boxNum":0,"boxPrice":0,"productTagUid":0,"weight":0,"itemDisc":0,"isTableware":false,"tablewareType":0}],"extTag":"","posName":"","posEnName":"","aliasName":"","isTableware":false,"tablewareType":0}
2026-01-30 17:13:38 192.168.8.202 47.75.192.130 candao-Foodpanda-1201817520635183104 -> item not found(106)
2026-01-30 17:13:38 192.168.8.202 47.75.192.130 candao-Foodpanda-1201817520635183104 -> cancel order:{"accessKey": "e8bb3146fa718bd7","actionName": "candao.order.updateOrderStatus","timestamp": 1769764418000,"ticket": "4F1DB222-3B67-4BC7-8D57-F10F12988211","sign": "218a0eb466f6dd0bfab3a273467c8ed9","serviceType": "pos","storeId":"7757","data": {"orderId":"1201817520635183104","extOrderId":"lhq9-2605-5lg8","orderNo":"260130171345596515","storeId":"7757","status":-1,"cancelReason":403}}
2026-01-30 17:13:38 192.168.8.202 47.75.192.130 candao-Foodpanda-1201817520635183104 -> cancel order response:{"status":1,"msg":"操作成功","logId":"087469bc-4e3a-8631-16fa-09bc-4c1b0675","serverTime":1769764426033,"ticket":"4F1DB222-3B67-4BC7-8D57-F10F12988211"}
2026-01-30 17:13:38 192.168.8.202 47.75.192.130 candao-Foodpanda-1201817520635183104 -> cancel order:success
2026-01-30 17:13:38 192.168.8.202 47.75.192.130 candao -> input:{"accessKey":"e8bb3146fa718bd7","actionName":"candao.callback.postId","data":{"id":"4F1DB222-3B67-4BC7-8D57-F10F12988211","status":1,"message":"操作成功","type":"11","info":{"extOrderId":"lhq9-2605-5lg8","subOrderId":"1201817520635183104","status":-1}},"timestamp":1769764426103,"sign":"53e9d7e75a2fee149d4c114876ae03a2","ticket":"4F1DB222-3B67-4BC7-8D57-F10F12988211","serviceType":"pos","vendor":"standard"}
2026-01-30 17:13:38 192.168.8.202 47.75.192.130 candao -> actionName others(candao.callback.postId)
2026-01-30 17:13:47 192.168.8.202 47.75.192.130 candao -> input:{"accessKey":"e8bb3146fa718bd7","storeId":"7757","actionName":"candao.order.updateOrderStatus","data":{"driveDistance":0,"orderNo":"260130171345596515","cancelNote":"其它原因-其他原因","orderId":"1201817520635183104","thirdSn":"6316","pickUpTime":"2026-01-30 17:36:11","updateTime":"2026-01-30 17:13:46","storeId":"7757","extOrderId":"lhq9-2605-5lg8","fromType":"foodpanda","brandId":319,"sn":"3","subStoreId":"03","cancelReason":501,"cancelReasonName":"其它原因-其他原因","status":-1},"timestamp":1769764435091,"sign":"4f59d69cb17b5008ab21958621b1af64","ticket":"6cc93e7b-cce9-4244-a790-fe18e2b3cb36","serviceType":"pos","vendor":"standard"}
2026-01-30 17:13:47 192.168.8.202 47.75.192.130 candao-Foodpanda-1201817520635183104 -> 訂單未訂購(1201817520635183104)
2026-01-30 17:27:49 192.168.8.202 47.75.192.130 candao -> input:{"accessKey":"e8bb3146fa718bd7","actionName":"candao.callback.postId","data":{"id":"DA0AB8D6-6976-49BF-87D7-15321094D244","status":1,"message":"操作成功","type":"11","info":{"extOrderId":"lhq9-2605-5lg8","subOrderId":"1201817520635183104","status":-1}},"timestamp":1769765279719,"sign":"410460710fb780f32210ae033a3d662a","ticket":"DA0AB8D6-6976-49BF-87D7-15321094D244","serviceType":"pos","vendor":"standard"}
2026-01-30 17:27:49 192.168.8.202 47.75.192.130 candao -> actionName others(candao.callback.postId)