DELIMITER //
DROP PROCEDURE BackDateInventory//
CREATE PROCEDURE BackdateInventory(IN invbarcode varchar(20), IN invdate date)
BEGIN

UPDATE  items
SET datelastseen = invdate
WHERE   barcode = invbarcode
AND     datelastseen < invdate;

INSERT INTO old_issues
SELECT * FROM issues
WHERE itemnumber = (SELECT itemnumber FROM items WHERE barcode = invbarcode)
AND issuedate < invdate;

DELETE FROM issues
WHERE itemnumber = (SELECT itemnumber FROM items WHERE barcode = invbarcode)
AND issuedate < invdate;


UPDATE  old_issues
SET returndate=invdate
WHERE itemnumber = (SELECT itemnumber FROM items WHERE barcode = invbarcode)
AND returndate IS NULL
AND issuedate < invdate;

END //
DELIMITER ;