/*  LG_011_ITEMS + LG_011_ITMUNITA ekleme — Tüm kolonlar + istisnalar uygulandi  */
CREATE PROCEDURE [dbo].[sp_AddNewItemAndUnit]
    @pCode      NVARCHAR(50),
    @pBarcode   NVARCHAR(50)
AS
BEGIN
    SET NOCOUNT ON;

    BEGIN TRY
        BEGIN TRAN;

        /* Ayni CODE varsa ekleme yapma */
        IF EXISTS (SELECT 1 FROM LG_011_ITEMS WITH (UPDLOCK, HOLDLOCK) WHERE CODE = @pCode)
        BEGIN
            RAISERROR (N'Bu ürün kodu (CODE) zaten mevcut, ekleme yapilmadi.', 16, 1);
            ROLLBACK TRAN;
            RETURN;
        END

        /* Sablon: 30802 degerlerini al */
        IF NOT EXISTS (SELECT 1 FROM LG_011_ITEMS WHERE LOGICALREF = 30802)
        BEGIN
            RAISERROR (N'LOGICALREF=30802 sablon kaydi bulunamadi.', 16, 1);
            ROLLBACK TRAN;
            RETURN;
        END

        DECLARE @Now DATETIME = GETDATE();
        DECLARE @h SMALLINT = DATEPART(HOUR,   @Now);
        DECLARE @m SMALLINT = DATEPART(MINUTE, @Now);
        DECLARE @s SMALLINT = DATEPART(SECOND, @Now);

        /* INSERT — tüm kolonlar */
        INSERT INTO LG_011_ITEMS
        (
            ACTIVE, CARDTYPE, CODE, NAME, STGRPCODE, PRODUCERCODE, SPECODE, CYPHCODE,
            CLASSTYPE, PURCHBRWS, SALESBRWS, MTRLBRWS, VAT, PAYMENTREF, TRACKTYPE, LOCTRACKING,
            TOOL, AUTOINCSL, DIVLOTSIZE, SHELFLIFE, SHELFDATE,
            DOMINANTREFS1, DOMINANTREFS2, DOMINANTREFS3, DOMINANTREFS4, DOMINANTREFS5, DOMINANTREFS6, DOMINANTREFS7, DOMINANTREFS8, DOMINANTREFS9, DOMINANTREFS10, DOMINANTREFS11, DOMINANTREFS12,
            IMAGEINC, TEXTINC, DEPRTYPE, DEPRRATE, DEPRDUR, SALVAGEVAL, REVALFLAG, REVDEPRFLAG, PARTDEP, DEPRTYPE2, DEPRRATE2, DEPRDUR2, REVALFLAG2, REVDEPRFLAG2, PARTDEP2,
            APPROVED, UNITSETREF, QCCSETREF, DISTAMOUNT,
            CAPIBLOCK_CREATEDBY, CAPIBLOCK_CREADEDDATE, CAPIBLOCK_CREATEDHOUR, CAPIBLOCK_CREATEDMIN, CAPIBLOCK_CREATEDSEC,
            CAPIBLOCK_MODIFIEDBY, CAPIBLOCK_MODIFIEDDATE, CAPIBLOCK_MODIFIEDHOUR, CAPIBLOCK_MODIFIEDMIN, CAPIBLOCK_MODIFIEDSEC,
            SITEID, RECSTATUS, ORGLOGICREF, UNIVID, DISTLOTUNITS, COMBLOTUNITS, WFSTATUS, DISTPOINT, CAMPPOINT, CANUSEINTRNS,
            ISONR, GROUPNR, PRODCOUNTRY, ADDTAXREF, QPRODAMNT, QPRODUOM, QPRODSRCINDEX, EXTACCESSFLAGS, PACKET, SALVAGEVAL2,
            SELLVAT, RETURNVAT, LOGOID, LIDCONFIRMED, GTIPCODE, EXPCTGNO, B2CCODE, MARKREF, IMAGE2INC, AVRWHDURATION, EXTCARDFLAGS, MINORDAMOUNT,
            FREIGHTPLACE, FREIGHTTYPCODE1, FREIGHTTYPCODE2, FREIGHTTYPCODE3, FREIGHTTYPCODE4, FREIGHTTYPCODE5, FREIGHTTYPCODE6, FREIGHTTYPCODE7, FREIGHTTYPCODE8, FREIGHTTYPCODE9, FREIGHTTYPCODE10,
            STATECODE, STATENAME, EXPCATEGORY, LOSTFACTOR, TEXTINCENG, EANBARCODE, DEPRCLASSTYPE, WFLOWCRDREF,
            SELLPRVAT, RETURNPRVAT,
            LOWLEVELCODES1, LOWLEVELCODES2, LOWLEVELCODES3, LOWLEVELCODES4, LOWLEVELCODES5, LOWLEVELCODES6, LOWLEVELCODES7, LOWLEVELCODES8, LOWLEVELCODES9, LOWLEVELCODES10,
            ORGLOGOID, QPRODDEPART, CANCONFIGURE, CHARSETREF, CANDEDUCT, CONSCODEREF,
            SPECODE2, SPECODE3, SPECODE4, SPECODE5,
            EXPENSE, ORIGIN, NAME2, COMPKDVUSE, USEDINPERIODS,
            EXIMTAX1, EXIMTAX2, EXIMTAX3, EXIMTAX4, EXIMTAX5,
            PRODUCTLEVEL, APPSPEVATMATRAH, NAME3, FACOSTKEYS, KKLINESDISABLE,
            APPROVE, APPROVEDATE, GLOBALID,
            SALEDEDUCTPART1, SALEDEDUCTPART2, PURCDEDUCTPART1, PURCDEDUCTPART2,
            CATEGORYID, CATEGORYNAME, KEYWORD1, KEYWORD2, KEYWORD3, KEYWORD4, KEYWORD5,
            GUID, DEMANDMEETSORTFLD4, DEMANDMEETSORTFLD5, DEMANDMEETSORTFLD3, DEMANDMEETSORTFLD1, DEMANDMEETSORTFLD2,
            PROJECTREF, DEDUCTCODE, QPRODSUBSRCINDEX, QPRODSUBDEPART, QPRODSUBUOM, NAME4, QPRODSUBAMNT, CPACODE, PUBLICCOUNTRYREF, MULTIADDTAX,
            PORDAMNTTOLERANCE, SORDAMNTTOLERANCE, UETDSUNCODE, UETDSTRANSPORTMODE, UETDSLOADUNIT, UETDSUNDEF, UETDSLOADTYPEDEF, NOTIFYCRDREF, LEVELCONTROL,
            UETDSLOADTYPE, UETDSTRANSPORTTYPE, TSENR, PAYERACTIVE, PAYERID, EXIMREGTYPREF, PURCHDEDUCTCODE, PAYERSALESPRICE, PAYERSUBTITLE, PAYERNAME,
            PAYERPURCHPRICE, PAYERBARCODE, MOLDMAINTNUMBER, MOLDFACTOR, MOLDMAINTLIFE, MOLDMAINTLIFETYPE, MOLDUSAGELIFE, FAUSEFULLIFECODE2, FAUSEFULLIFECODE,
            MOLDLIFETRACKTYPE, MOLD, MOLDLIFEASRATIO, FORECASTCODE, GAINTYPE, NODISCOUNT, SALESLIMITQUANTITY, OBTAINTYPE,
            MOLDMAINTBEGDATE, MOLDMAINTTYPE, MOLDMAINTPERUNIT, MOLDMAINTPERIOD
        )
        SELECT
            /* Sabit kalacak/override edilecek alanlar */
            0 /*ACTIVE*/,
            1 /*CARDTYPE*/,
            @pCode /*CODE*/,
            N'YENI KAYIT' /*NAME*/,
            '' /*STGRPCODE bos*/,
            '' /*PRODUCERCODE bos*/,
            '' /*SPECODE bos*/,
            '' /*CYPHCODE bos*/,
            T.CLASSTYPE,
            1 /*PURCHBRWS*/,
            1 /*SALESBRWS*/,
            1 /*MTRLBRWS*/,
            20 /*VAT*/,
            T.PAYMENTREF, T.TRACKTYPE, T.LOCTRACKING,
            T.TOOL, T.AUTOINCSL, T.DIVLOTSIZE, T.SHELFLIFE, T.SHELFDATE,
            T.DOMINANTREFS1, T.DOMINANTREFS2, T.DOMINANTREFS3, T.DOMINANTREFS4, T.DOMINANTREFS5, T.DOMINANTREFS6, T.DOMINANTREFS7, T.DOMINANTREFS8, T.DOMINANTREFS9, T.DOMINANTREFS10, T.DOMINANTREFS11, T.DOMINANTREFS12,
            T.IMAGEINC, T.TEXTINC, T.DEPRTYPE, T.DEPRRATE, T.DEPRDUR, T.SALVAGEVAL, T.REVALFLAG, T.REVDEPRFLAG, T.PARTDEP, T.DEPRTYPE2, T.DEPRRATE2, T.DEPRDUR2, T.REVALFLAG2, T.REVDEPRFLAG2, T.PARTDEP2,
            T.APPROVED,
            5 /*UNITSETREF*/,
            T.QCCSETREF, T.DISTAMOUNT,

            1 /*CAPIBLOCK_CREATEDBY*/,
            @Now /*CAPIBLOCK_CREADEDDATE*/,
            @h /*CAPIBLOCK_CREATEDHOUR*/,
            @m /*CAPIBLOCK_CREATEDMIN*/,
            @s /*CAPIBLOCK_CREATEDSEC*/,

            NULL /*CAPIBLOCK_MODIFIEDBY - bos sayisal*/,
            NULL /*CAPIBLOCK_MODIFIEDDATE - bos tarih*/,
            NULL /*CAPIBLOCK_MODIFIEDHOUR*/,
            NULL /*CAPIBLOCK_MODIFIEDMIN*/,
            NULL /*CAPIBLOCK_MODIFIEDSEC*/,

            T.SITEID,
            2 /*RECSTATUS*/,
            0 /*ORGLOGICREF - bos sayisal*/,
            T.UNIVID, T.DISTLOTUNITS, T.COMBLOTUNITS, T.WFSTATUS, T.DISTPOINT, T.CAMPPOINT, T.CANUSEINTRNS,
            T.ISONR, T.GROUPNR, T.PRODCOUNTRY, T.ADDTAXREF, T.QPRODAMNT, T.QPRODUOM, T.QPRODSRCINDEX, T.EXTACCESSFLAGS, T.PACKET, T.SALVAGEVAL2,

            20 /*SELLVAT*/,
            20 /*RETURNVAT*/,
            T.LOGOID, T.LIDCONFIRMED,
            '' /*GTIPCODE bos*/,
            '' /*EXPCTGNO bos (barkod ITMUNITA'ya yaziliyor)*/,
            T.B2CCODE, T.MARKREF, T.IMAGE2INC, T.AVRWHDURATION, T.EXTCARDFLAGS, T.MINORDAMOUNT,
            T.FREIGHTPLACE, T.FREIGHTTYPCODE1, T.FREIGHTTYPCODE2, T.FREIGHTTYPCODE3, T.FREIGHTTYPCODE4, T.FREIGHTTYPCODE5, T.FREIGHTTYPCODE6, T.FREIGHTTYPCODE7, T.FREIGHTTYPCODE8, T.FREIGHTTYPCODE9, T.FREIGHTTYPCODE10,
            T.STATECODE, T.STATENAME, T.EXPCATEGORY, T.LOSTFACTOR, T.TEXTINCENG, T.EANBARCODE, T.DEPRCLASSTYPE, T.WFLOWCRDREF,

            20 /*SELLPRVAT*/,
            20 /*RETURNPRVAT*/,

            0 /*LOWLEVELCODES1 - bos sayisal*/,
            T.LOWLEVELCODES2, T.LOWLEVELCODES3, T.LOWLEVELCODES4, T.LOWLEVELCODES5, T.LOWLEVELCODES6, T.LOWLEVELCODES7, T.LOWLEVELCODES8, T.LOWLEVELCODES9, T.LOWLEVELCODES10,
            T.ORGLOGOID, T.QPRODDEPART, T.CANCONFIGURE, T.CHARSETREF, T.CANDEDUCT, T.CONSCODEREF,

            '' /*SPECODE2 bos*/,
            '' /*SPECODE3 bos*/,
            '' /*SPECODE4 bos*/,
            '' /*SPECODE5 bos*/,

            T.EXPENSE, T.ORIGIN, T.NAME2, T.COMPKDVUSE, T.USEDINPERIODS,
            T.EXIMTAX1, T.EXIMTAX2, T.EXIMTAX3, T.EXIMTAX4, T.EXIMTAX5,
            T.PRODUCTLEVEL, T.APPSPEVATMATRAH, T.NAME3, T.FACOSTKEYS, T.KKLINESDISABLE,
            T.APPROVE,
            NULL /*APPROVEDATE - NULL*/,
            T.GLOBALID,

            T.SALEDEDUCTPART1, T.SALEDEDUCTPART2, T.PURCDEDUCTPART1, T.PURCDEDUCTPART2,
            T.CATEGORYID, T.CATEGORYNAME, T.KEYWORD1, T.KEYWORD2, T.KEYWORD3, T.KEYWORD4, T.KEYWORD5,

            '' /*GUID bos*/,
            T.DEMANDMEETSORTFLD4, T.DEMANDMEETSORTFLD5, T.DEMANDMEETSORTFLD3, T.DEMANDMEETSORTFLD1, T.DEMANDMEETSORTFLD2,
            T.PROJECTREF, T.DEDUCTCODE, T.QPRODSUBSRCINDEX, T.QPRODSUBDEPART, T.QPRODSUBUOM, T.NAME4, T.QPRODSUBAMNT, T.CPACODE, T.PUBLICCOUNTRYREF, T.MULTIADDTAX,
            T.PORDAMNTTOLERANCE, T.SORDAMNTTOLERANCE, T.UETDSUNCODE, T.UETDSTRANSPORTMODE, T.UETDSLOADUNIT, T.UETDSUNDEF, T.UETDSLOADTYPEDEF, T.NOTIFYCRDREF, T.LEVELCONTROL,
            T.UETDSLOADTYPE, T.UETDSTRANSPORTTYPE, T.TSENR, T.PAYERACTIVE, T.PAYERID, T.EXIMREGTYPREF, T.PURCHDEDUCTCODE, T.PAYERSALESPRICE, T.PAYERSUBTITLE, T.PAYERNAME,
            T.PAYERPURCHPRICE, T.PAYERBARCODE, T.MOLDMAINTNUMBER, T.MOLDFACTOR, T.MOLDMAINTLIFE, T.MOLDMAINTLIFETYPE, T.MOLDUSAGELIFE, T.FAUSEFULLIFECODE2, T.FAUSEFULLIFECODE,
            T.MOLDLIFETRACKTYPE, T.MOLD, T.MOLDLIFEASRATIO, T.FORECASTCODE, T.GAINTYPE, T.NODISCOUNT, T.SALESLIMITQUANTITY, T.OBTAINTYPE,
            NULL /*MOLDMAINTBEGDATE - NULL*/, T.MOLDMAINTTYPE, T.MOLDMAINTPERUNIT, T.MOLDMAINTPERIOD
        FROM LG_011_ITEMS AS T
        WHERE T.LOGICALREF = 30802;

        DECLARE @itemRef INT = SCOPE_IDENTITY();

        /* ITMUNITA — barkod ve temel siniflar */
        INSERT INTO LG_011_ITMUNITA
        ( ITEMREF, LINENR, UNITLINEREF, BARCODE, MTRLCLAS, PURCHCLAS, SALESCLAS, RECSTATUS )
        VALUES
        ( @itemRef, 1, 23, @pBarcode, 1, 1, 1, 2 );

        COMMIT TRAN;

        PRINT N'Kayit basariyla eklendi. ITEMREF = ' + CAST(@itemRef AS NVARCHAR(20));
    END TRY
    BEGIN CATCH
        IF @@TRANCOUNT > 0 ROLLBACK TRAN;

        DECLARE @ErrMsg NVARCHAR(4000) = ERROR_MESSAGE();
        RAISERROR (@ErrMsg, 16, 1);
    END CATCH
END