取得委托单号

BEGIN DECLARE YYMMDD VARCHAR(6); DECLARE NWE_ID VARCHAR(14); SET YYMMDD = DATE_FORMAT(SYSDATE(),'%y%m%d'); SET NWE_ID=NULL; SELECT CONSIGN_CODE INTO NWE_ID FROM CONSIGN WHERE CONSIGN_CODE LIKE CONCAT(RIGHT(CUSTOMER_ID,2),YYMMDD,'%') ORDER BY CONSIGN_CODE DESC LIMIT 1 ; IF NWE_ID IS NULL THEN SET NWE_ID = CONCAT(RIGHT(CUSTOMER_ID,2),YYMMDD,'01'); ELSE SET NWE_ID = CONCAT(RIGHT(CUSTOMER_ID,2),YYMMDD,LPAD((RIGHT(NWE_ID,2)+1),2,'0')); END IF; RETURN NWE_ID; END