38 lines
1020 B
PL/PgSQL
38 lines
1020 B
PL/PgSQL
-- Could not auto-generate a down migration.
|
|
-- Please write an appropriate down migration for the SQL below:
|
|
-- CREATE OR REPLACE FUNCTION public.search_inventory (search text)
|
|
-- RETURNS SETOF inventory
|
|
-- LANGUAGE plpgsql
|
|
-- STABLE
|
|
-- AS $function$
|
|
-- BEGIN
|
|
-- IF search = '' THEN
|
|
-- RETURN query
|
|
-- SELECT
|
|
-- *
|
|
-- FROM
|
|
-- inventory;
|
|
-- ELSE
|
|
-- RETURN query
|
|
-- SELECT
|
|
-- *
|
|
-- FROM
|
|
-- inventory inner JOIN billlines ON inventory.billlineid = billlines.id
|
|
-- inner JOIN bills ON billlines.billid = bills.id
|
|
-- inner JOIN vendors ON bills.vendorid = vendors.id
|
|
--
|
|
-- WHERE
|
|
-- inventory.line_desc ILIKE '%' || search || '%'
|
|
-- OR bills.invoice_number ILIKE '%' || search || '%'
|
|
-- OR vendors.name ILIKE '%' || search || '%'
|
|
-- ORDER BY
|
|
-- inventory.line_desc ILIKE '%' || search || '%'
|
|
-- OR NULL,
|
|
-- bills.invoice_number ILIKE '%' || search || '%'
|
|
-- OR NULL,
|
|
-- vendors.name ILIKE '%' || search || '%'
|
|
-- OR NULL;
|
|
-- END IF;
|
|
-- END
|
|
-- $function$;
|