Priv8 Uploader By InMyMine7
Linux server.abcbiz.in 3.10.0-1160.45.1.el7.x86_64 #1 SMP Wed Oct 13 17:20:51 UTC 2021 x86_64
Server listening on port:5050
Loading Home page body: { userId: 100 }
Loading Home page query: {
latitude: '28.6909791',
longitude: '77.17652389999999',
city: 'Delhi'
}
Loading Home page body: { userId: 100 }
Loading Home page query: {
latitude: '28.6909791',
longitude: '77.17652389999999',
city: 'Delhi'
}
Loading Home page body: { userId: 100 }
Loading Home page query: {
latitude: '28.6909791',
longitude: '77.17652389999999',
city: 'Delhi'
}
Loading Home page body: { userId: 100 }
Loading Home page query: {
latitude: '28.6909791',
longitude: '77.17652389999999',
city: 'Delhi'
}
Server listening on port:5050
i am herer 6
i am in else
wherecondition1wherecondition1 {}
whereconditionStockwhereconditionStock { status: 1, isdeleted: 0 } { vendor_id: 6 }
Executing (default): SELECT `product_categories`.*, `product->vendor_product_stocks`.`id` AS `product.vendor_product_stocks.id`, `product->vendor_product_stocks`.`product_id` AS `product.vendor_product_stocks.product_id`, `product->vendor_product_stocks`.`vendor_id` AS `product.vendor_product_stocks.vendor_id`, `product->vendor_product_stocks`.`qty` AS `product.vendor_product_stocks.qty` FROM (SELECT `product_categories`.`product_id`, `product_categories`.`id` AS `id`, `product`.`id` AS `product.id`, `product`.`name` AS `product.name`, `product`.`price` AS `product.price`, `product`.`spcl_price` AS `product.spcl_price`, `product`.`delivery_days` AS `product.delivery_days`, `product`.`no_of_pcs` AS `product.no_of_pcs`, `product`.`qty` AS `product.qty`, `product`.`weight` AS `product.weight`, `product`.`grosswt` AS `product.grosswt`, `product`.`short_description` AS `product.short_description`, `product`.`default_image` AS `product.default_image`, `product`.`created_at` AS `product.created_at` FROM `product_categories` AS `product_categories` INNER JOIN `products` AS `product` ON `product_categories`.`product_id` = `product`.`id` AND `product`.`status` = 1 AND `product`.`isdeleted` = 0 WHERE ( SELECT `product`.`id` FROM `products` AS `product` INNER JOIN `vendor_product_stocks` AS `vendor_product_stocks` ON `product`.`id` = `vendor_product_stocks`.`product_id` AND `vendor_product_stocks`.`vendor_id` = 6 WHERE ((`product`.`status` = 1 AND `product`.`isdeleted` = 0) AND `product`.`id` = `product_categories`.`product_id`) LIMIT 1 ) IS NOT NULL GROUP BY `product_id` ORDER BY `product_categories`.`id` ASC LIMIT 0, 8) AS `product_categories` INNER JOIN `vendor_product_stocks` AS `product->vendor_product_stocks` ON `product.id` = `product->vendor_product_stocks`.`product_id` AND `product->vendor_product_stocks`.`vendor_id` = 6 ORDER BY `product_categories`.`id` ASC;
user_orderuser_orderuser_orderuser_order 8
user_orderuser_orderuser_order [
{
product_id: 43,
id: 70,
product: {
id: 43,
name: 'Chicken Spring 800GM',
price: 295,
spcl_price: 295,
delivery_days: null,
no_of_pcs: '12',
qty: null,
weight: '750',
grosswt: null,
short_description: '<p>Small and tender chicken,perfect for your curries,bar be que.</p>',
default_image: '1661858902-502.jpg',
created_at: 2022-08-30T16:58:22.000Z,
vendor_product_stocks: [Object]
}
},
{
product_id: 45,
id: 72,
product: {
id: 45,
name: 'CHICKEN KEEMA',
price: 220,
spcl_price: 220,
delivery_days: null,
no_of_pcs: null,
qty: null,
weight: '500',
grosswt: null,
short_description: 'Raw chicken meat is minced to perfection.Chicken keema is perfect for making cutlets,kebabs and curries.',
default_image: '1661859536-20.jpg',
created_at: 2022-08-30T17:08:56.000Z,
vendor_product_stocks: [Object]
}
},
{
product_id: 44,
id: 73,
product: {
id: 44,
name: 'Chicken 1KG',
price: 300,
spcl_price: 300,
delivery_days: null,
no_of_pcs: null,
qty: null,
weight: '1000',
grosswt: null,
short_description: '<p>BUG FLESHY AND JUICY CHICKEN FOR YOUR CURRIES </p>',
default_image: '1661859029-12.jpg',
created_at: 2022-08-30T17:00:29.000Z,
vendor_product_stocks: [Object]
}
},
{
product_id: 46,
id: 77,
product: {
id: 46,
name: 'CHICKEN WINGS',
price: 210,
spcl_price: 210,
delivery_days: null,
no_of_pcs: '8 to 10',
qty: null,
weight: '500',
grosswt: null,
short_description: 'Chicken wings are one of the favourite pieces of most people.They make excellent soup and stock.Perfect for making chicken lolypop.',
default_image: '1661859916-23.jpg',
created_at: 2022-08-30T17:15:16.000Z,
vendor_product_stocks: [Object]
}
},
{
product_id: 49,
id: 80,
product: {
id: 49,
name: 'CHICKEN DRUMSTICKS',
price: 210,
spcl_price: 210,
delivery_days: null,
no_of_pcs: '4 to 6',
qty: null,
weight: '500',
grosswt: null,
short_description: 'Chicken drumsticks is the dark meat that forms the lower part of leg and the most desired meat.Perfect for curries and gril.',
default_image: '1661861325-137.jpg',
created_at: 2022-08-30T17:38:45.000Z,
vendor_product_stocks: [Object]
}
},
{
product_id: 50,
id: 81,
product: {
id: 50,
name: 'CHICKEN FULL LEG',
price: 235,
spcl_price: 235,
delivery_days: null,
no_of_pcs: null,
qty: null,
weight: '500',
grosswt: null,
short_description: 'Chicken full leg is comprised of both the drumsticks and the thigh.Can be used for making dry lemon chicken,biryani,tandoori and curries',
default_image: '1661861661-526.jpg',
created_at: 2022-08-30T17:44:22.000Z,
vendor_product_stocks: [Object]
}
},
{
product_id: 52,
id: 84,
product: {
id: 52,
name: 'GURDE KAPOORE',
price: 215,
spcl_price: 215,
delivery_days: null,
no_of_pcs: '8 to 10',
qty: null,
weight: '250',
grosswt: null,
short_description: '<p>The gurde kapoore are top notch super foods.The organ meat has a deep flavour and unique texture when cooked.</p>',
default_image: '1661863998-768.jpg',
created_at: 2022-08-30T18:23:18.000Z,
vendor_product_stocks: [Object]
}
},
{
product_id: 53,
id: 85,
product: {
id: 53,
name: 'KHARODE',
price: 200,
spcl_price: 200,
delivery_days: null,
no_of_pcs: '2',
qty: null,
weight: null,
grosswt: null,
short_description: 'Kharode can be best used for making soup and curries.It is good for rapid recovery of bone fractures and very helpful to improve from illness and weakness.',
default_image: '1661864382-486.jpg',
created_at: 2022-08-30T18:29:43.000Z,
vendor_product_stocks: [Object]
}
}
]
==========================> {
product_id: 43,
id: 70,
product: {
id: 43,
name: 'Chicken Spring 800GM',
price: 295,
spcl_price: 295,
delivery_days: null,
no_of_pcs: '12',
qty: null,
weight: '750',
grosswt: null,
short_description: '<p>Small and tender chicken,perfect for your curries,bar be que.</p>',
default_image: '1661858902-502.jpg',
created_at: 2022-08-30T16:58:22.000Z,
vendor_product_stocks: { id: 347, product_id: 43, vendor_id: 6, qty: 1 }
}
}
req.body.userId------- 6
obj.product.id00000000000000000000 43
==========================> {
product_id: 45,
id: 72,
product: {
id: 45,
name: 'CHICKEN KEEMA',
price: 220,
spcl_price: 220,
delivery_days: null,
no_of_pcs: null,
qty: null,
weight: '500',
grosswt: null,
short_description: 'Raw chicken meat is minced to perfection.Chicken keema is perfect for making cutlets,kebabs and curries.',
default_image: '1661859536-20.jpg',
created_at: 2022-08-30T17:08:56.000Z,
vendor_product_stocks: { id: 349, product_id: 45, vendor_id: 6, qty: 1 }
}
}
req.body.userId------- 6
obj.product.id00000000000000000000 45
==========================> {
product_id: 44,
id: 73,
product: {
id: 44,
name: 'Chicken 1KG',
price: 300,
spcl_price: 300,
delivery_days: null,
no_of_pcs: null,
qty: null,
weight: '1000',
grosswt: null,
short_description: '<p>BUG FLESHY AND JUICY CHICKEN FOR YOUR CURRIES </p>',
default_image: '1661859029-12.jpg',
created_at: 2022-08-30T17:00:29.000Z,
vendor_product_stocks: { id: 348, product_id: 44, vendor_id: 6, qty: 1 }
}
}
req.body.userId------- 6
obj.product.id00000000000000000000 44
==========================> {
product_id: 46,
id: 77,
product: {
id: 46,
name: 'CHICKEN WINGS',
price: 210,
spcl_price: 210,
delivery_days: null,
no_of_pcs: '8 to 10',
qty: null,
weight: '500',
grosswt: null,
short_description: 'Chicken wings are one of the favourite pieces of most people.They make excellent soup and stock.Perfect for making chicken lolypop.',
default_image: '1661859916-23.jpg',
created_at: 2022-08-30T17:15:16.000Z,
vendor_product_stocks: { id: 350, product_id: 46, vendor_id: 6, qty: 1 }
}
}
req.body.userId------- 6
obj.product.id00000000000000000000 46
==========================> {
product_id: 49,
id: 80,
product: {
id: 49,
name: 'CHICKEN DRUMSTICKS',
price: 210,
spcl_price: 210,
delivery_days: null,
no_of_pcs: '4 to 6',
qty: null,
weight: '500',
grosswt: null,
short_description: 'Chicken drumsticks is the dark meat that forms the lower part of leg and the most desired meat.Perfect for curries and gril.',
default_image: '1661861325-137.jpg',
created_at: 2022-08-30T17:38:45.000Z,
vendor_product_stocks: { id: 353, product_id: 49, vendor_id: 6, qty: 1 }
}
}
req.body.userId------- 6
obj.product.id00000000000000000000 49
==========================> {
product_id: 50,
id: 81,
product: {
id: 50,
name: 'CHICKEN FULL LEG',
price: 235,
spcl_price: 235,
delivery_days: null,
no_of_pcs: null,
qty: null,
weight: '500',
grosswt: null,
short_description: 'Chicken full leg is comprised of both the drumsticks and the thigh.Can be used for making dry lemon chicken,biryani,tandoori and curries',
default_image: '1661861661-526.jpg',
created_at: 2022-08-30T17:44:22.000Z,
vendor_product_stocks: { id: 354, product_id: 50, vendor_id: 6, qty: 1 }
}
}
req.body.userId------- 6
obj.product.id00000000000000000000 50
==========================> {
product_id: 52,
id: 84,
product: {
id: 52,
name: 'GURDE KAPOORE',
price: 215,
spcl_price: 215,
delivery_days: null,
no_of_pcs: '8 to 10',
qty: null,
weight: '250',
grosswt: null,
short_description: '<p>The gurde kapoore are top notch super foods.The organ meat has a deep flavour and unique texture when cooked.</p>',
default_image: '1661863998-768.jpg',
created_at: 2022-08-30T18:23:18.000Z,
vendor_product_stocks: { id: 355, product_id: 52, vendor_id: 6, qty: 1 }
}
}
req.body.userId------- 6
obj.product.id00000000000000000000 52
==========================> {
product_id: 53,
id: 85,
product: {
id: 53,
name: 'KHARODE',
price: 200,
spcl_price: 200,
delivery_days: null,
no_of_pcs: '2',
qty: null,
weight: null,
grosswt: null,
short_description: 'Kharode can be best used for making soup and curries.It is good for rapid recovery of bone fractures and very helpful to improve from illness and weakness.',
default_image: '1661864382-486.jpg',
created_at: 2022-08-30T18:29:43.000Z,
vendor_product_stocks: { id: 356, product_id: 53, vendor_id: 6, qty: 1 }
}
}
req.body.userId------- 6
obj.product.id00000000000000000000 53
Total Orders : 8