mirror of
https://github.com/linuxserver/Clarkson.git
synced 2026-01-20 20:04:47 +08:00
22 lines
317 B
SQL
22 lines
317 B
SQL
DELIMITER $$
|
|
|
|
CREATE PROCEDURE `Cost_GetByVehicle`
|
|
(
|
|
in_vehicle VARCHAR(36)
|
|
)
|
|
BEGIN
|
|
|
|
SELECT
|
|
`id`,
|
|
DATE_FORMAT(`date`, '%Y-%m-%d %H:%i:%s') AS `date`,
|
|
`costType`,
|
|
`totalCost`,
|
|
`invoice`,
|
|
`notes`
|
|
FROM
|
|
`Costs`
|
|
WHERE
|
|
`vehicle` = in_vehicle;
|
|
|
|
END$$
|