Need Mariah DB expert to fix tables in DB
Budget: $10 – $50 USD
So were having issues with our DB not reflecting prices and other data from our web site admin.
We need a DB expert to fix this quickly.
Here is the issue we get from Db query.
according to the application if I run a query to the database. There are only 325 out of 491 products that actually have networks attached to them.
I have no idea where the backend is getting it's values from as the Iphon 12 mini have no networks/storage attached to it
--------------
Product::with('networks')->whereModel('iPhone 12 Mini')->first();
=> App\Models\Admin\Product {#4706
id: 451,
brand_id: 1,
model: "iPhone 12 Mini",
sku: null,
excellent_offer: null,
good_offer: null,
fair_offer: null,
poor_offer: null,
amount: null,
storage: null,
description: "<p>Sell us your Apple iPhone 12 mini. Select the condition of your phone and storage size. Note: We reserve the right to reduce / change your cash offer for all Google & Apple Locked / Financed devices.<br></p>",
color: "0",
height: "0",
width: "0",
weight: "0",
length: "0",
device_type: "Both",
network: null,
network_id: 0,
offer_type: 0,
status: "Active",
user_create: 0,
user_update: 1,
created_at: "2021-07-18 00:36:00",
updated_at: "2021-08-18 20:46:11",
priority: 0,
networks: Illuminate\Database\Eloquent\Collection {#4694
all: [],
},
+dimension: "",
+hashedid: "pLmd7k413YayMWX8lWGQPexzV6X9Og",
+display_created_at: "Jul 18 2021",
+display_updated_at: "Aug 18 2021",
}
----------------
if I run the same query for Galaxy s20+
Product::with('networks')->whereModel('Galaxy S20+ 5G')->first();
=> App\Models\Admin\Product {#4702
id: 29,
brand_id: 2,
model: "Galaxy S20+ 5G",
sku: null,
excellent_offer: null,
good_offer: null,
fair_offer: null,
poor_offer: null,
amount: null,
storage: null,
description: "<p>Sell your Samsung Galaxy S20+ 5G for cash. Select the condition of the phone above. Then select your storage size. Note: We reserve the right to reduce / modify your cash offer for all Google & Apple Locked / Financed devices.<br></p>",
color: null,
height: "0",
width: "0",
weight: "0",
length: "0",
device_type: "Both",
network: null,
network_id: 0,
offer_type: 0,
status: "Active",
user_create: 0,
user_update: 1,
created_at: "2021-05-12 19:48:22",
updated_at: "2021-08-18 20:46:11",
priority: 3,
networks: Illuminate\Database\Eloquent\Collection {#4722
all: [
App\Models\Admin\ProductNetwork {#4728
id: 106,
product_id: 29,
network_id: 1,
created_at: "2021-05-12 19:48:23",
updated_at: "2021-05-12 19:48:23",
+hashedid: "XvgVY3j9ePOdJb05kWB6EN1Rl2anwo",
},
App\Models\Admin\ProductNetwork {#4729
id: 107,
product_id: 29,
network_id: 3,
created_at: "2021-05-12 19:48:23",
updated_at: "2021-05-12 19:48:23",
+hashedid: "pLmd7k413YayMWX3KbGQPexzV6X9Og",
},
App\Models\Admin\ProductNetwork {#4730
id: 108,
product_id: 29,
network_id: 4,
created_at: "2021-05-12 19:48:23",
updated_at: "2021-05-12 19:48:23",
+hashedid: "vn9B1gOxEj52krPg0WR7VpJK8wlmL4",
},
App\Models\Admin\ProductNetwork {#4731
id: 109,
product_id: 29,
network_id: 5,
created_at: "2021-05-12 19:48:23",
updated_at: "2021-05-12 19:48:23",
+hashedid: "yemAwMQ67vO3nqd92b2Z80lJjo1E4R",
},
],
},
+dimension: "",
+hashedid: "3XgK1kdpmwjzJr3jWeQ0oBnRa49GNY",
+display_created_at: "May 12 2021",
+display_updated_at: "Aug 18 2021",
}
We need a DB expert to fix this quickly.
Here is the issue we get from Db query.
according to the application if I run a query to the database. There are only 325 out of 491 products that actually have networks attached to them.
I have no idea where the backend is getting it's values from as the Iphon 12 mini have no networks/storage attached to it
--------------
Product::with('networks')->whereModel('iPhone 12 Mini')->first();
=> App\Models\Admin\Product {#4706
id: 451,
brand_id: 1,
model: "iPhone 12 Mini",
sku: null,
excellent_offer: null,
good_offer: null,
fair_offer: null,
poor_offer: null,
amount: null,
storage: null,
description: "<p>Sell us your Apple iPhone 12 mini. Select the condition of your phone and storage size. Note: We reserve the right to reduce / change your cash offer for all Google & Apple Locked / Financed devices.<br></p>",
color: "0",
height: "0",
width: "0",
weight: "0",
length: "0",
device_type: "Both",
network: null,
network_id: 0,
offer_type: 0,
status: "Active",
user_create: 0,
user_update: 1,
created_at: "2021-07-18 00:36:00",
updated_at: "2021-08-18 20:46:11",
priority: 0,
networks: Illuminate\Database\Eloquent\Collection {#4694
all: [],
},
+dimension: "",
+hashedid: "pLmd7k413YayMWX8lWGQPexzV6X9Og",
+display_created_at: "Jul 18 2021",
+display_updated_at: "Aug 18 2021",
}
----------------
if I run the same query for Galaxy s20+
Product::with('networks')->whereModel('Galaxy S20+ 5G')->first();
=> App\Models\Admin\Product {#4702
id: 29,
brand_id: 2,
model: "Galaxy S20+ 5G",
sku: null,
excellent_offer: null,
good_offer: null,
fair_offer: null,
poor_offer: null,
amount: null,
storage: null,
description: "<p>Sell your Samsung Galaxy S20+ 5G for cash. Select the condition of the phone above. Then select your storage size. Note: We reserve the right to reduce / modify your cash offer for all Google & Apple Locked / Financed devices.<br></p>",
color: null,
height: "0",
width: "0",
weight: "0",
length: "0",
device_type: "Both",
network: null,
network_id: 0,
offer_type: 0,
status: "Active",
user_create: 0,
user_update: 1,
created_at: "2021-05-12 19:48:22",
updated_at: "2021-08-18 20:46:11",
priority: 3,
networks: Illuminate\Database\Eloquent\Collection {#4722
all: [
App\Models\Admin\ProductNetwork {#4728
id: 106,
product_id: 29,
network_id: 1,
created_at: "2021-05-12 19:48:23",
updated_at: "2021-05-12 19:48:23",
+hashedid: "XvgVY3j9ePOdJb05kWB6EN1Rl2anwo",
},
App\Models\Admin\ProductNetwork {#4729
id: 107,
product_id: 29,
network_id: 3,
created_at: "2021-05-12 19:48:23",
updated_at: "2021-05-12 19:48:23",
+hashedid: "pLmd7k413YayMWX3KbGQPexzV6X9Og",
},
App\Models\Admin\ProductNetwork {#4730
id: 108,
product_id: 29,
network_id: 4,
created_at: "2021-05-12 19:48:23",
updated_at: "2021-05-12 19:48:23",
+hashedid: "vn9B1gOxEj52krPg0WR7VpJK8wlmL4",
},
App\Models\Admin\ProductNetwork {#4731
id: 109,
product_id: 29,
network_id: 5,
created_at: "2021-05-12 19:48:23",
updated_at: "2021-05-12 19:48:23",
+hashedid: "yemAwMQ67vO3nqd92b2Z80lJjo1E4R",
},
],
},
+dimension: "",
+hashedid: "3XgK1kdpmwjzJr3jWeQ0oBnRa49GNY",
+display_created_at: "May 12 2021",
+display_updated_at: "Aug 18 2021",
}