public.restock_order
Documentation | Dell DVD Store |
Schema | public |
Name | restock_order |
Reorder productc (DVD films) when qauainity in stock is low. (< 3 )
Input/Output
Mode | Name | Data type | Description | |
---|---|---|---|---|
1 | OUT | Returns | trigger |
Script
CREATE OR REPLACE FUNCTION public.restock_order() RETURNS trigger LANGUAGE plpgsql AS $function$ BEGIN IF ( NEW.QUAN_IN_STOCK < 3) THEN INSERT INTO REORDER ( PROD_ID, DATE_LOW, QUAN_LOW) VALUES ( NEW.PROD_ID, current_timestamp , NEW.QUAN_IN_STOCK); NEW.QUAN_IN_STOCK = OLD.QUAN_IN_STOCK; -- UPDATE INVENTORY SET QUAN_IN_STOCK = OLD.QUAN_IN_STOCK WHERE PROD_ID = NEW.PROD_ID; END IF; RETURN NEW; END; $function$ |
Exported: 2018-11-09 16:14, Last imported: 2018-08-06 09:39