AKI-REPRINT-5

USE SPEX_DB;

IF EXISTS (
SELECT *
    FROM INFORMATION_SCHEMA.ROUTINES
WHERE SPECIFIC_SCHEMA = N'spex'
    AND SPECIFIC_NAME = N'SP_AMANAH_RE_PRINT_5_PRINT'
    AND ROUTINE_TYPE = N'PROCEDURE'
)
DROP PROCEDURE spex.SP_AMANAH_RE_PRINT_5_PRINT
GO

CREATE PROCEDURE spex.SP_AMANAH_RE_PRINT_5_PRINT
    @PRINT_TYPE INT = 1,
    @PHNO VARCHAR(MAX) = '',
    @PLNO VARCHAR(MAX) = '',
    @TYPE INT = 1,
    @PRINTER_NAME VARCHAR(MAX) = '',
    @USERNAME VARCHAR(MAX) = ''
AS
BEGIN

    DECLARE @MSG_TEXT VARCHAR(MAX) = ''
    ,@PARAM1 VARCHAR(MAX) = ''
    ,@PARAM2 VARCHAR(MAX) = ''
    ,@PARAM3 VARCHAR(MAX) = ''
    ,@N_ERR INT = 0
    ,@IS_ERR CHAR(1) = 'N'
    ,@DATEPARAM VARCHAR(MAX)

    SET @DATEPARAM = CONVERT(VARCHAR, GETDATE(), 112)

    CREATE TABLE #TB_T_DATA (
        RESULT VARCHAR(MAX),
        Message VARCHAR(MAX)
    )

    BEGIN TRY
        EXECUTE spex.SP_SPEX3_PRINT_PICKING_DATA @PRINT_TYPE, @PHNO, '', @TYPE, @PRINTER_NAME

        UPDATE [SPEX_DB].[spex].[TB_R_DAILY_ORDER_MANIFEST]
        SET [PRINT_FLAG] = 1, [CHANGED_BY] = @USERNAME, [CHANGED_DT] = GETDATE()
        WHERE [MANIFEST_NO] = @PHNO;

        INSERT INTO #TB_T_DATA VALUES ('Success' ,@MSG_TEXT)
    END TRY
    BEGIN CATCH
        SET @MSG_TEXT = ERROR_MESSAGE()

        INSERT INTO #TB_T_DATA
        VALUES ('Failed', @MSG_TEXT)
    END CATCH

    SELECT RESULT, Message
    FROM #TB_T_DATA

END
GO
EXECUTE spex.SP_AMANAH_RE_PRINT_5_PRINT 1, 'PH20B05M01002', '', 0, 'Microsoft Print to PDF', 'AMANAH.Yusup'