how to perform a sum with laravel in an eloquent relationship
0
I have a detail table where there is a relationship with the product table, in the detail table I have a product_id field.
I try to multiply the quantity that appears in the detail table and the price that appears in the product table, used DB ::raw but I get a column error not found.
QueryScope in Detalle Model
$query->with(['product' => function ($query)
$query->select('id', 'name', 'price');
])
->select('*', DB::raw('SUM(count*products.price) as fullcount'))
->groupBy('product_id');
php mysql laravel laravel-5
asked Nov 12 '18 at 19:16
DarkFenix
319315
add a comment |
0
I have a detail table where there is a relationship with the product table, in the detail table I have a product_id field.
I try to multiply the quantity that appears in the detail table and the price that appears in the product table, used DB ::raw but I get a column error not found.
QueryScope in Detalle Model
$query->with(['product' => function ($query)
$query->select('id', 'name', 'price');
])
->select('*', DB::raw('SUM(count*products.price) as fullcount'))
->groupBy('product_id');
php mysql laravel laravel-5
asked Nov 12 '18 at 19:16
DarkFenix
319315
what table/aliascountcolumn belongs to?
– Alex
Nov 12 '18 at 19:46
@Alex count in table details
– DarkFenix
Nov 13 '18 at 18:28
I don't see anydetailstable involved.
– Alex
Nov 13 '18 at 19:17
@Alex That queryScope is inside the model Details
– DarkFenix
Nov 13 '18 at 20:13
add a comment |
0
0
0
I have a detail table where there is a relationship with the product table, in the detail table I have a product_id field.
I try to multiply the quantity that appears in the detail table and the price that appears in the product table, used DB ::raw but I get a column error not found.
QueryScope in Detalle Model
$query->with(['product' => function ($query)
$query->select('id', 'name', 'price');
])
->select('*', DB::raw('SUM(count*products.price) as fullcount'))
->groupBy('product_id');
php mysql laravel laravel-5
asked Nov 12 '18 at 19:16
DarkFenix
319315
I have a detail table where there is a relationship with the product table, in the detail table I have a product_id field.
I try to multiply the quantity that appears in the detail table and the price that appears in the product table, used DB ::raw but I get a column error not found.
QueryScope in Detalle Model
$query->with(['product' => function ($query)
$query->select('id', 'name', 'price');
])
->select('*', DB::raw('SUM(count*products.price) as fullcount'))
->groupBy('product_id');
php mysql laravel laravel-5
php mysql laravel laravel-5
asked Nov 12 '18 at 19:16
DarkFenix
319315
asked Nov 12 '18 at 19:16
DarkFenix
319315
asked Nov 12 '18 at 19:16
DarkFenix
319315
asked Nov 12 '18 at 19:16
DarkFenix
319315
asked Nov 12 '18 at 19:16
DarkFenix
319315
319315
what table/aliascountcolumn belongs to?
– Alex
Nov 12 '18 at 19:46
@Alex count in table details
– DarkFenix
Nov 13 '18 at 18:28
I don't see anydetailstable involved.
– Alex
Nov 13 '18 at 19:17
@Alex That queryScope is inside the model Details
– DarkFenix
Nov 13 '18 at 20:13
add a comment |
what table/aliascountcolumn belongs to?
– Alex
Nov 12 '18 at 19:46
@Alex count in table details
– DarkFenix
Nov 13 '18 at 18:28
I don't see anydetailstable involved.
– Alex
Nov 13 '18 at 19:17
@Alex That queryScope is inside the model Details
– DarkFenix
Nov 13 '18 at 20:13
what table/alias
count column belongs to?– Alex
Nov 12 '18 at 19:46
what table/alias
count column belongs to?– Alex
Nov 12 '18 at 19:46
@Alex count in table details
– DarkFenix
Nov 13 '18 at 18:28
@Alex count in table details
– DarkFenix
Nov 13 '18 at 18:28
I don't see any
details table involved.– Alex
Nov 13 '18 at 19:17
I don't see any
details table involved.– Alex
Nov 13 '18 at 19:17
@Alex That queryScope is inside the model Details
– DarkFenix
Nov 13 '18 at 20:13
@Alex That queryScope is inside the model Details
– DarkFenix
Nov 13 '18 at 20:13
add a comment |
1 Answer
1
active
oldest
votes
1
Use a JOIN:
$query->select('product_id', DB::raw('SUM(count*products.price) as fullcount'))
->join('products', 'details.product_id', '=', 'products.id')
->groupBy('product_id');
answered Nov 12 '18 at 20:58
Jonas Staudenmeir
12.1k2933
An additional query, what I want is that you group them if a field of the detail table has a certain value, otherwise you leave them separated Is it possible?
– DarkFenix
Nov 13 '18 at 18:27
I don't think so.
– Jonas Staudenmeir
Nov 13 '18 at 18:39
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53268676%2fhow-to-perform-a-sum-with-laravel-in-an-eloquent-relationship%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
Use a JOIN:
$query->select('product_id', DB::raw('SUM(count*products.price) as fullcount'))
->join('products', 'details.product_id', '=', 'products.id')
->groupBy('product_id');
answered Nov 12 '18 at 20:58
Jonas Staudenmeir
12.1k2933
An additional query, what I want is that you group them if a field of the detail table has a certain value, otherwise you leave them separated Is it possible?
– DarkFenix
Nov 13 '18 at 18:27
I don't think so.
– Jonas Staudenmeir
Nov 13 '18 at 18:39
add a comment |
1
Use a JOIN:
$query->select('product_id', DB::raw('SUM(count*products.price) as fullcount'))
->join('products', 'details.product_id', '=', 'products.id')
->groupBy('product_id');
answered Nov 12 '18 at 20:58
Jonas Staudenmeir
12.1k2933
An additional query, what I want is that you group them if a field of the detail table has a certain value, otherwise you leave them separated Is it possible?
– DarkFenix
Nov 13 '18 at 18:27
I don't think so.
– Jonas Staudenmeir
Nov 13 '18 at 18:39
add a comment |
1
1
1
Use a JOIN:
$query->select('product_id', DB::raw('SUM(count*products.price) as fullcount'))
->join('products', 'details.product_id', '=', 'products.id')
->groupBy('product_id');
answered Nov 12 '18 at 20:58
Jonas Staudenmeir
12.1k2933
Use a JOIN:
$query->select('product_id', DB::raw('SUM(count*products.price) as fullcount'))
->join('products', 'details.product_id', '=', 'products.id')
->groupBy('product_id');
answered Nov 12 '18 at 20:58
Jonas Staudenmeir
12.1k2933
answered Nov 12 '18 at 20:58
Jonas Staudenmeir
12.1k2933
answered Nov 12 '18 at 20:58
Jonas Staudenmeir
12.1k2933
answered Nov 12 '18 at 20:58
Jonas Staudenmeir
12.1k2933
12.1k2933
An additional query, what I want is that you group them if a field of the detail table has a certain value, otherwise you leave them separated Is it possible?
– DarkFenix
Nov 13 '18 at 18:27
I don't think so.
– Jonas Staudenmeir
Nov 13 '18 at 18:39
add a comment |
An additional query, what I want is that you group them if a field of the detail table has a certain value, otherwise you leave them separated Is it possible?
– DarkFenix
Nov 13 '18 at 18:27
I don't think so.
– Jonas Staudenmeir
Nov 13 '18 at 18:39
An additional query, what I want is that you group them if a field of the detail table has a certain value, otherwise you leave them separated Is it possible?
– DarkFenix
Nov 13 '18 at 18:27
An additional query, what I want is that you group them if a field of the detail table has a certain value, otherwise you leave them separated Is it possible?
– DarkFenix
Nov 13 '18 at 18:27
I don't think so.
– Jonas Staudenmeir
Nov 13 '18 at 18:39
I don't think so.
– Jonas Staudenmeir
Nov 13 '18 at 18:39
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53268676%2fhow-to-perform-a-sum-with-laravel-in-an-eloquent-relationship%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
what table/alias
countcolumn belongs to?– Alex
Nov 12 '18 at 19:46
@Alex count in table details
– DarkFenix
Nov 13 '18 at 18:28
I don't see any
detailstable involved.– Alex
Nov 13 '18 at 19:17
@Alex That queryScope is inside the model Details
– DarkFenix
Nov 13 '18 at 20:13