Could someone convert sql query to Eloquent one?

|
vikaskumar_99 2020-04-20 15:19:55
Which query?
vikaskumar_99 2020-04-20 15:20:32
I have call create function and pass the $data variable.
Z_Yamin 2020-04-20 15:21:25
the query that you selected dry_friut.CustomerAddresss
Z_Yamin 2020-04-20 15:21:31
the error is from here
vikaskumar_99 2020-04-20 15:23:49
I don’t know. How’s come this error? Do you have any idea how to resolve it? Pls let me know.
Z_Yamin 2020-04-20 15:24:20
check the route
Leskhantos 2020-04-20 15:26:18
could someone convert sql query to Eloquent one?
vikaskumar_99 2020-04-20 15:27:47
laravel_discuss-33963.jpg
Route
vikaskumar_99 2020-04-20 15:29:12
@Ziayamin pls see
Dev 2020-04-20 15:31:06
Z_Yamin 2020-04-20 15:18:21
where is the query?

He uses Eloquent.

Dev 2020-04-20 15:31:34
vikaskumar_99 2020-04-20 15:16:03

Is your table name customer_address?

vikaskumar_99 2020-04-20 15:32:08
Yes in plural
Dev 2020-04-20 15:34:01
If your table name is different from what Laravel assumes, change it in your model manually like:

protected $table = “your_table_name_goes_here”;

vikaskumar_99 2020-04-20 15:34:55
I have already applied but nothing happened?
Dev 2020-04-20 15:35:19
vikaskumar_99 2020-04-20 15:34:55
I have already applied but nothing happened?

Show your model attributes.

vikaskumar_99 2020-04-20 15:36:04
laravel_discuss-33972.jpg

vikaskumar_99 2020-04-20 15:36:13
@manlycoder pls check
vikaskumar_99 2020-04-20 15:40:08
@Ziayamin @manlycoder ? Pls help
Leskhantos 2020-04-20 15:42:38
Dev 2020-04-20 15:31:06
He uses Eloquent.

SELECT
e.id,
e.model_id,
ev.title AS vendor,
em.title AS model,
et.title AS type,
e.place,
COUNT(free.id) AS free,
COUNT(ship.id) AS ship,
COUNT(model_id) AS total_count
FROM
storage_equipments AS e
LEFT JOIN
storage_equipments_vendors AS ev ON e.vendor_id = ev.id
LEFT JOIN
storage_equipments_models AS em ON e.model_id = em.id
LEFT JOIN
storage_equipments_types AS et ON e.type_id = et.id
LEFT JOIN
(SELECT
eh.*
FROM
storage_equipments_history AS eh
INNER JOIN (SELECT
*, MAX(eh.created_at) AS created_at2
FROM
storage_equipments_history AS eh
GROUP BY eh.equipment_id) AS ehselect ON eh.equipment_id = ehselect.equipment_id
AND eh.created_at = ehselect.created_at2
HAVING eh.status_id = 433) AS free ON e.id = free.equipment_id
LEFT JOIN
(SELECT
eh.*
FROM
storage_equipments_history AS eh
INNER JOIN (SELECT
*, MAX(eh.created_at) AS created_at2
FROM
storage_equipments_history AS eh
GROUP BY eh.equipment_id) AS ehselect ON eh.equipment_id = ehselect.equipment_id
AND eh.created_at = ehselect.created_at2
HAVING eh.status_id = 429) AS ship ON e.id = ship.equipment_id
GROUP BY model_id;

SM_NHosseini 2020-04-20 18:19:38
hi guys,

I have a strange problem with laravel sessions,

no matter which configuration i choose for session driver they do not peresist and always return null.

for example below code return null:

SM_NHosseini 2020-04-20 18:19:41
laravel_discuss-33981.jpg

SM_NHosseini 2020-04-20 18:19:45
any idea?
Siberfx 2020-04-20 18:29:43
you should show the rest of the code
DesolatorMagno 2020-04-20 18:29:55
Read the documentation, that code look wrong.
DesolatorMagno 2020-04-20 18:30:33
For logic a key value couple should go in a array.
SM_NHosseini 2020-04-20 18:30:45
Siberfx 2020-04-20 18:29:43
you should show the rest of the code

r u with me?

Siberfx 2020-04-20 18:30:59
well I dont speak to myself :))
SM_NHosseini 2020-04-20 18:31:22
Siberfx 2020-04-20 18:30:59
well I dont speak to myself :))

:)), which part do u need?

Siberfx 2020-04-20 18:31:42
the top of the route was needed, but its not a fact.
Siberfx 2020-04-20 18:31:54
what do you really want to do with sessions
SM_NHosseini 2020-04-20 18:32:28
Siberfx 2020-04-20 18:31:42
the top of the route was needed, but its not a fact.

the above code is at the top of all of my routes

SM_NHosseini 2020-04-20 18:32:38
Siberfx 2020-04-20 18:31:54
what do you really want to do with sessions

auth

Siberfx 2020-04-20 18:33:14
sayed, pm me, lets discuss about it that way
SM_NHosseini 2020-04-20 18:33:20
SM_NHosseini 2020-04-20 18:32:38
auth

it’s not working so i dig deep enough which made me found out that sessions are not working

SM_NHosseini 2020-04-20 18:33:29
Siberfx 2020-04-20 18:33:14
sayed, pm me, lets discuss about it that way

allright

Jooo 2020-04-20 19:26:43
$ npm run dev
bash: npm: command not found
Jooo 2020-04-20 19:27:17
$ npm install
bash: npm: command not found
Jooo 2020-04-20 19:30:29
nod.js installed but message see like this bash: npm: command not found
Patricklab 2020-04-20 19:34:46
looking our for 2 very good team players very good with core php and laravel php to help speed up development on an active project need those interested in joining a small of developers to get done with work anyone interested inbox must have worked with vue nodejs and socket.io
Asish K Antony 2020-04-20 19:37:49
Jooo 2020-04-20 19:26:43
$ npm run dev
bash: npm: command not found

run npm -v

Asish K Antony 2020-04-20 19:38:16
then run node -v
Jooo 2020-04-20 19:39:38
C:UsersIrene>npm -v
6.14.4

C:UsersIrene>node -v
v12.16.2

C:UsersIrene>

Asish K Antony 2020-04-20 19:39:54
ok
Asish K Antony 2020-04-20 19:40:03
so both are installed
Asish K Antony 2020-04-20 19:40:19
check package.json
Jooo 2020-04-20 19:42:03
laravel_discuss-34010.jpg

Asish K Antony 2020-04-20 19:46:51
ok show me the terminal when you click npm install
abysnia 2020-04-20 19:54:16
how do i enable logging in laravel?
abysnia 2020-04-20 19:54:35
its already enabled in the env file
abysnia 2020-04-20 19:54:42
but i cant see logs
|