{"orders":[{"0":"24","id":"23","1":"987654321","username":"987654321","2":" Mehbub","name":"Jannnn","3":"jabb@gmail.com","email":"jabb@gmail.com","4":"456 Barpeta Barpeta sp office  987654321","address":"","5":"","c_address":"","6":"","city":"","7":"","state":"","8":"0","pincode":"0","9":"","house":"","10":"","landmark":"","11":"COD","payment_method":"COD","12":"987654321","phone":"987654321","13":"120","amount":"120","14":"120","total_without_coupon":"120","15":"","gift_wrap":"","16":"","gift_wrap_charges":"","17":"","coupon_discount":"","18":"","coupon_code":"","19":"0","shipping_charges":"0","20":"kA5lrJmRHlyHCJpfmAOuRUbvOgZJCRfGH2dWf9Kg","uniqueId":"kA5lrJmRHlyHCJpfmAOuRUbvOgZJCRfGH2dWf9Kg","21":"Cash On Delivery","payment_status":"Cash On Delivery","22":"Confirmed","order_status":"Confirmed","23":"kA5lrJmRHlyHCJpfmAOuRUbvOgZJCRfGH2dWf9Kg","txnid":"kA5lrJmRHlyHCJpfmAOuRUbvOgZJCRfGH2dWf9Kg","24":"App","type":"App","25":"Shopping","order_type":"Shopping","26":"0","reward":"0","27":"2023-03-21 12:06:08","order_date":"2023-03-21 12:06:08","28":"0","delivery_charge":"0","29":"0","cashback":"0","30":"","customer_id":"","31":"ELALZORDS90900572","order_id":"ELALZORDS90900572","32":"","commission":"","33":"","delivery_date":"","34":"","delivery_time":"","35":"","delivery_person":"","36":"Home Delivery","delivery":"Home Delivery","37":"","delete_status":"","38":"","re_1":"","39":"djitu7709@gmail.com","vendor_id":"djitu7709@gmail.com","40":"","wallet_type":"","41":"456 Barpeta Barpeta sp office  987654321","addrs":"456 Barpeta Barpeta sp office  987654321","42":"24","tid":"24","43":"23","44":"Jannnn","45":"jabb@gmail.com","46":"987654321","47":"0000-00-00","dob":"0000-00-00","48":"","49":"","50":"","profile_pic":"","51":"987654321","52":"jabbar","password":"jabbar","53":"1","email_verified":"1","54":"1","phone_verified":"1","55":"A","status":"A","56":"2023-02-09","user_since":"2023-02-09","57":"12345","otp":"12345","58":"","referal_code":"","59":"","regtype":"","60":"","sbid":"","od":[{"0":"37","id":"37","1":"Chicken biriyani ","name":"Chicken biriyani ","2":"5769","product_code":"5769","3":"120","price":"120","4":"1","quantity":"1","5":"","combo_product":"","6":"","color":"","7":"Full","size":"Full","8":"","option1_name":"","9":"","option1_value":"","10":"kA5lrJmRHlyHCJpfmAOuRUbvOgZJCRfGH2dWf9Kg","uniqueId":"kA5lrJmRHlyHCJpfmAOuRUbvOgZJCRfGH2dWf9Kg","11":"kA5lrJmRHlyHCJpfmAOuRUbvOgZJCRfGH2dWf9Kg","transactionId":"kA5lrJmRHlyHCJpfmAOuRUbvOgZJCRfGH2dWf9Kg","12":"987654321","phone":"987654321","13":"2023-03-21","order_date":"2023-03-21","14":"djitu7709@gmail.com","vendor_id":"djitu7709@gmail.com"}],"top":"120","vadd":"Joti Gaon,Near FAAMCH, Barpeta"},{"0":"25","id":"23","1":"987654321","username":"987654321","2":" Mehbub","name":"Jannnn","3":"jabb@gmail.com","email":"jabb@gmail.com","4":"456 Barpeta Barpeta sp office  987654321","address":"","5":"","c_address":"","6":"","city":"","7":"","state":"","8":"0","pincode":"0","9":"","house":"","10":"","landmark":"","11":"COD","payment_method":"COD","12":"987654321","phone":"987654321","13":"120","amount":"120","14":"120","total_without_coupon":"120","15":"","gift_wrap":"","16":"","gift_wrap_charges":"","17":"","coupon_discount":"","18":"","coupon_code":"","19":"0","shipping_charges":"0","20":"TNv2676QHN4x0vo7pdMtWlKRgdBEBWv2arimMYyF","uniqueId":"TNv2676QHN4x0vo7pdMtWlKRgdBEBWv2arimMYyF","21":"Cash On Delivery","payment_status":"Cash On Delivery","22":"Not Started","order_status":"Not Started","23":"TNv2676QHN4x0vo7pdMtWlKRgdBEBWv2arimMYyF","txnid":"TNv2676QHN4x0vo7pdMtWlKRgdBEBWv2arimMYyF","24":"App","type":"App","25":"Shopping","order_type":"Shopping","26":"0","reward":"0","27":"2023-03-21 12:08:03","order_date":"2023-03-21 12:08:03","28":"0","delivery_charge":"0","29":"0","cashback":"0","30":"","customer_id":"","31":"ELALZORDS95903546","order_id":"ELALZORDS95903546","32":"","commission":"","33":"","delivery_date":"","34":"","delivery_time":"","35":"","delivery_person":"","36":"Home Delivery","delivery":"Home Delivery","37":"","delete_status":"","38":"","re_1":"","39":"djitu7709@gmail.com","vendor_id":"djitu7709@gmail.com","40":"","wallet_type":"","41":"456 Barpeta Barpeta sp office  987654321","addrs":"456 Barpeta Barpeta sp office  987654321","42":"25","tid":"25","43":"23","44":"Jannnn","45":"jabb@gmail.com","46":"987654321","47":"0000-00-00","dob":"0000-00-00","48":"","49":"","50":"","profile_pic":"","51":"987654321","52":"jabbar","password":"jabbar","53":"1","email_verified":"1","54":"1","phone_verified":"1","55":"A","status":"A","56":"2023-02-09","user_since":"2023-02-09","57":"12345","otp":"12345","58":"","referal_code":"","59":"","regtype":"","60":"","sbid":"","od":[{"0":"38","id":"38","1":"Chicken biriyani ","name":"Chicken biriyani ","2":"5769","product_code":"5769","3":"120","price":"120","4":"1","quantity":"1","5":"","combo_product":"","6":"","color":"","7":"Full","size":"Full","8":"","option1_name":"","9":"","option1_value":"","10":"TNv2676QHN4x0vo7pdMtWlKRgdBEBWv2arimMYyF","uniqueId":"TNv2676QHN4x0vo7pdMtWlKRgdBEBWv2arimMYyF","11":"TNv2676QHN4x0vo7pdMtWlKRgdBEBWv2arimMYyF","transactionId":"TNv2676QHN4x0vo7pdMtWlKRgdBEBWv2arimMYyF","12":"987654321","phone":"987654321","13":"2023-03-21","order_date":"2023-03-21","14":"djitu7709@gmail.com","vendor_id":"djitu7709@gmail.com"}],"top":"120","vadd":"Joti Gaon,Near FAAMCH, Barpeta"},{"0":"17","id":"25","1":"98591014852","username":"98591014852","2":" Abdul Al amin ali","name":"Jabbar ali","3":"aaaaworld444@gmail.com","email":"aaaaworld444@gmail.com","4":"Barpeta  Bhawanipur ancholik college  Apd bazar  8472080280","address":"","5":"","c_address":"","6":"","city":"","7":"","state":"","8":"0","pincode":"0","9":"","house":"","10":"","landmark":"","11":"COD","payment_method":"COD","12":"98591014852","phone":"98591014852","13":"60","amount":"60","14":"60","total_without_coupon":"60","15":"","gift_wrap":"","16":"","gift_wrap_charges":"","17":"","coupon_discount":"","18":"","coupon_code":"","19":"0","shipping_charges":"0","20":"Fzux8y62ocTrZ6OUIGpCMHrGfKydKMg6o39v1ZPl","uniqueId":"Fzux8y62ocTrZ6OUIGpCMHrGfKydKMg6o39v1ZPl","21":"Cash On Delivery","payment_status":"Cash On Delivery","22":"cancelled","order_status":"cancelled","23":"Fzux8y62ocTrZ6OUIGpCMHrGfKydKMg6o39v1ZPl","txnid":"Fzux8y62ocTrZ6OUIGpCMHrGfKydKMg6o39v1ZPl","24":"App","type":"App","25":"Shopping","order_type":"Shopping","26":"0","reward":"0","27":"2023-02-19 18:03:04","order_date":"2023-02-19 18:03:04","28":"0","delivery_charge":"0","29":"0","cashback":"0","30":"","customer_id":"","31":"ELALZORDS47731911","order_id":"ELALZORDS47731911","32":"","commission":"","33":"","delivery_date":"","34":"","delivery_time":"","35":"","delivery_person":"","36":"Home Delivery","delivery":"Home Delivery","37":"","delete_status":"","38":"","re_1":"","39":"djitu7709@gmail.com","vendor_id":"djitu7709@gmail.com","40":"","wallet_type":"","41":"Barpeta  Bhawanipur ancholik college  Apd bazar  8472080280","addrs":"Barpeta  Bhawanipur ancholik college  Apd bazar  8472080280","42":"17","tid":"17","43":"25","44":"Jabbar ali","45":"aaaaworld444@gmail.com","46":"98591014852","47":"0000-00-00","dob":"0000-00-00","48":"","49":"","50":"","profile_pic":"","51":"98591014852","52":"jabbar121","password":"jabbar121","53":"1","email_verified":"1","54":"1","phone_verified":"1","55":"A","status":"A","56":"2023-02-16","user_since":"2023-02-16","57":"12345","otp":"12345","58":"","referal_code":"","59":"","regtype":"","60":"","sbid":"","od":[{"0":"27","id":"27","1":"Chicken Roll","name":"Chicken Roll","2":"5761","product_code":"5761","3":"60","price":"60","4":"1","quantity":"1","5":"","combo_product":"","6":"","color":"","7":"S","size":"S","8":"","option1_name":"","9":"","option1_value":"","10":"Fzux8y62ocTrZ6OUIGpCMHrGfKydKMg6o39v1ZPl","uniqueId":"Fzux8y62ocTrZ6OUIGpCMHrGfKydKMg6o39v1ZPl","11":"Fzux8y62ocTrZ6OUIGpCMHrGfKydKMg6o39v1ZPl","transactionId":"Fzux8y62ocTrZ6OUIGpCMHrGfKydKMg6o39v1ZPl","12":"98591014852","phone":"98591014852","13":"2023-02-19","order_date":"2023-02-19","14":"djitu7709@gmail.com","vendor_id":"djitu7709@gmail.com"}],"top":"60","vadd":"Joti Gaon,Near FAAMCH, Barpeta"}],"status":1,"od":"SELECT * FROM order_details where uniqueId='Fzux8y62ocTrZ6OUIGpCMHrGfKydKMg6o39v1ZPl' and vendor_id='djitu7709@gmail.com' SELECT * FROM vendors where  email='djitu7709@gmail.com' SELECT sum(price*quantity) as top FROM order_details where uniqueId='Fzux8y62ocTrZ6OUIGpCMHrGfKydKMg6o39v1ZPl' and vendor_id='djitu7709@gmail.com' ","message":"Here's your current orders"}