mirror of
https://github.com/linuxserver/Clarkson.git
synced 2026-02-20 02:37:16 +08:00
28 lines
514 B
SQL
28 lines
514 B
SQL
DELIMITER $$
|
|
|
|
CREATE PROCEDURE `Dashboard_GetMonthlyFuelCosts`
|
|
(
|
|
in_id VARCHAR(36)
|
|
)
|
|
BEGIN
|
|
|
|
SELECT
|
|
V.`name` AS `vehicle`,
|
|
MONTH(F.`date`) AS `month`,
|
|
YEAR(F.`date`) AS `year`,
|
|
SUM(F.`totalCost`) AS `totalCost`
|
|
FROM
|
|
`Users` U
|
|
INNER JOIN
|
|
`Vehicles` V ON V.`user` = U.`id`
|
|
INNER JOIN
|
|
`Fuel` F ON F.`vehicle` = V.`id`
|
|
WHERE
|
|
U.`id` = in_id
|
|
GROUP BY
|
|
V.`name`,
|
|
MONTH(F.`date`),
|
|
YEAR(F.`date`);
|
|
|
|
END$$
|