{"id":1921,"date":"2026-04-21T10:10:23","date_gmt":"2026-04-21T02:10:23","guid":{"rendered":"http:\/\/www.dxQerp.com\/?p=1921"},"modified":"2026-04-21T10:11:49","modified_gmt":"2026-04-21T02:11:49","slug":"b74b-%e6%96%b0%e5%a2%9e-trigger-%e7%9a%84%e7%9b%b8%e9%97%9c-%e7%95%b0%e5%8b%95","status":"publish","type":"post","link":"http:\/\/www.dxQerp.com\/?p=1921","title":{"rendered":"B74B \u65b0\u589e Trigger \u7684\u76f8\u95dc \u7570\u52d5"},"content":{"rendered":"
\n
\n
\n
\n
\n
\n
\n
\n

✅ \u4fee\u6b63\u7248 Trigger\uff08\u4e7e\u6de8\u7248\uff09<\/h2>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
ALTER<\/span> TRIGGER<\/span> [dbo].[TRI_T_B74B_M]
\nON<\/span> [dbo].[T_B74B_M]
\nAFTER<\/span> INSERT<\/span>
\nAS<\/span>
\nBEGIN<\/span>
\nSET<\/span> NOCOUNT ON<\/span>;— ⚠️ \u5047\u8a2d\u4ecd\u70ba\u55ae\u7b46\uff08\u4f60\u539f\u672c\u5c31\u662f\u9019\u6a23\u8a2d\u8a08\uff09<\/span>
\nDECLARE<\/span>
\n@\u55ae\u865f varchar<\/span>(12<\/span>), @\u9805\u6b21 varchar<\/span>(5<\/span>), @\u54c1\u724c varchar<\/span>(20<\/span>),
\n@\u5de5\u4f5c\u8868\u591a\u9801 nvarchar(300<\/span>), @AI char<\/span>(1<\/span>), @cRow smallint<\/span>,
\n@\u5de5\u7a0b\u9805\u6b21 nvarchar(50<\/span>), @\u9805\u76ee\u8aaa\u660e nvarchar(400<\/span>), @\u55ae\u4f4d nvarchar(50<\/span>),
\n@\u6578\u91cf varchar<\/span>(20<\/span>), @\u55ae\u50f9 varchar<\/span>(20<\/span>), @\u8907\u50f9 varchar<\/span>(20<\/span>),
\n@\u5099\u8a3b nvarchar(100<\/span>), @\u724c\u50f9 varchar<\/span>(20<\/span>), @\u6298\u6578 varchar<\/span>(20<\/span>),
\n@\u985e\u578b varchar<\/span>(4<\/span>), @\u9805\u76ee\u8aaa\u660e_2<\/span> nvarchar(400<\/span>),
\n@\u4ee3\u865f varchar<\/span>(20<\/span>), @\u7570\u52d5 nvarchar(10<\/span>)<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

SELECT<\/span>
\n@\u55ae\u865f=<\/span>\u55ae\u865f, @\u9805\u6b21=<\/span>\u9805\u6b21, @\u7570\u52d5=<\/span>\u7570\u52d5,
\n@\u5de5\u7a0b\u9805\u6b21=<\/span>\u5de5\u7a0b\u9805\u6b21,
\n@\u9805\u76ee\u8aaa\u660e=<\/span>TRIM(\u9805\u76ee\u8aaa\u660e),
\n@\u55ae\u4f4d=<\/span>\u55ae\u4f4d, @\u4ee3\u865f=<\/span>\u4ee3\u865f, @cRow=<\/span>cRow,
\n@\u9805\u76ee\u8aaa\u660e_2<\/span>=<\/span>dbo.\u7a7a\u767d\u8f49\u9023\u63a5(dbo.\u5168\u5f62\u8f49\u534a\u5f62(\u9805\u76ee\u8aaa\u660e_2<\/span>)),
\n@\u54c1\u724c=<\/span>\u54c1\u724c,
\n@\u5de5\u4f5c\u8868\u591a\u9801=<\/span>\u5de5\u4f5c\u8868\u591a\u9801,
\n@AI=<\/span>AI,
\n@\u6578\u91cf=<\/span>\u6578\u91cf, @\u55ae\u50f9=<\/span>\u55ae\u50f9, @\u8907\u50f9=<\/span>\u8907\u50f9,
\n@\u5099\u8a3b=<\/span>\u5099\u8a3b, @\u724c\u50f9=<\/span>\u724c\u50f9, @\u6298\u6578=<\/span>\u6298\u6578, @\u985e\u578b=<\/span>\u985e\u578b
\nFROM<\/span> INSERTED;<\/p>\n

— \u6578\u503c\u5b89\u5168\u8f49\u63db<\/span>
\nIF<\/span> TRY_CONVERT(decimal<\/span>(18<\/span>,4<\/span>), @\u6578\u91cf) IS<\/span> NULL<\/span> SET<\/span> @\u6578\u91cf =<\/span> ‘0’<\/span>;
\nIF<\/span> TRY_CONVERT(decimal<\/span>(18<\/span>,4<\/span>), @\u55ae\u50f9) IS<\/span> NULL<\/span> SET<\/span> @\u55ae\u50f9 =<\/span> ‘0’<\/span>;
\nIF<\/span> TRY_CONVERT(decimal<\/span>(18<\/span>,4<\/span>), @\u8907\u50f9) IS<\/span> NULL<\/span> SET<\/span> @\u8907\u50f9 =<\/span> ‘0’<\/span>;
\nIF<\/span> TRY_CONVERT(decimal<\/span>(18<\/span>,4<\/span>), @\u724c\u50f9) IS<\/span> NULL<\/span> SET<\/span> @\u724c\u50f9 =<\/span> ‘0’<\/span>;
\nIF<\/span> TRY_CONVERT(decimal<\/span>(18<\/span>,4<\/span>), @\u6298\u6578) IS<\/span> NULL<\/span> SET<\/span> @\u6298\u6578 =<\/span> ‘0’<\/span>;<\/p>\n

— \u5de5\u7a0b\u9805\u6b21\u8655\u7406<\/span>
\nSET<\/span> @\u5de5\u7a0b\u9805\u6b21 =<\/span> REPLACE(REPLACE(@\u5de5\u7a0b\u9805\u6b21, ‘.000’<\/span>, ”<\/span>), ‘.00’<\/span>, ”<\/span>);<\/p>\n

— \u54c1\u724c\u8655\u7406<\/span>
\nIF<\/span> @\u54c1\u724c IN<\/span> (‘kurrent’<\/span>,‘KURRENT’<\/span>) SET<\/span> @\u54c1\u724c=<\/span>‘Kurrent’<\/span>;<\/p>\n

IF<\/span> (@\u54c1\u724c IS<\/span> NULL<\/span>) OR<\/span> (@\u54c1\u724c NOT<\/span> IN<\/span> (SELECT<\/span> \u54c1\u724c FROM<\/span> dbo.vi_B765))
\nSET<\/span> @\u54c1\u724c=<\/span>‘*’<\/span>;<\/p>\n

——————————————————<\/span>
\n— \u522a\u9664<\/span>
\nIF<\/span> @\u7570\u52d5=<\/span>‘\u522a\u9664’<\/span>
\nBEGIN<\/span>
\nDELETE<\/span> FROM<\/span> dbo.T_B74B
\nWHERE<\/span> \u55ae\u865f=<\/span>@\u55ae\u865f AND<\/span> \u9805\u6b21=<\/span>@\u9805\u6b21;
\nRETURN<\/span>;
\nEND<\/span><\/p>\n

——————————————————<\/span>
\n— \u65b0\u589e<\/span>
\nIF<\/span> @\u7570\u52d5=<\/span>‘\u65b0\u589e’<\/span>
\nBEGIN<\/span>
\nSELECT<\/span> @\u9805\u6b21 =<\/span> MAX(\u9805\u6b21)
\nFROM<\/span> dbo.vi_B74B
\nWHERE<\/span> \u55ae\u865f=<\/span>@\u55ae\u865f;<\/p>\n

IF<\/span> @\u9805\u6b21 IS<\/span> NULL<\/span>
\nSET<\/span> @\u9805\u6b21=<\/span>‘00001’<\/span>;
\nELSE<\/span>
\nSET<\/span> @\u9805\u6b21 =<\/span> RIGHT<\/span>(‘0000’<\/span> +<\/span> CAST<\/span>(CAST<\/span>(@\u9805\u6b21 AS<\/span> INT<\/span>)+<\/span>1<\/span> AS<\/span> varchar<\/span>),5<\/span>);<\/p>\n

INSERT<\/span> INTO<\/span> dbo.T_B74B(\u55ae\u865f,\u9805\u6b21)
\nVALUES<\/span> (@\u55ae\u865f,@\u9805\u6b21);
\nEND<\/span><\/p>\n

——————————————————<\/span>
\n— \u66f4\u65b0\uff08\u76f4\u63a5\u5beb\uff0c\u4e0d\u7528\u52d5\u614b SQL\uff09<\/span>
\nUPDATE<\/span> dbo.T_B74B
\nSET<\/span>
\n\u5de5\u7a0b\u9805\u6b21 =<\/span> ISNULL(@\u5de5\u7a0b\u9805\u6b21, \u5de5\u7a0b\u9805\u6b21),
\n\u9805\u76ee\u8aaa\u660e =<\/span> ISNULL(@\u9805\u76ee\u8aaa\u660e, \u9805\u76ee\u8aaa\u660e),
\n\u55ae\u4f4d =<\/span> ISNULL(@\u55ae\u4f4d, \u55ae\u4f4d),
\n\u6578\u91cf =<\/span> ISNULL(@\u6578\u91cf, \u6578\u91cf),
\n\u55ae\u50f9 =<\/span> ISNULL(@\u55ae\u50f9, \u55ae\u50f9),
\n\u8907\u50f9 =<\/span> ISNULL(@\u8907\u50f9, \u8907\u50f9),
\n\u724c\u50f9 =<\/span> ISNULL(@\u724c\u50f9, \u724c\u50f9),
\n\u6298\u6578 =<\/span> ISNULL(@\u6298\u6578, \u6298\u6578),
\n\u985e\u578b =<\/span> ISNULL(@\u985e\u578b, \u985e\u578b),
\n\u5099\u8a3b =<\/span> ISNULL(@\u5099\u8a3b, \u5099\u8a3b),
\n\u54c1\u724c =<\/span> ISNULL(@\u54c1\u724c, \u54c1\u724c),
\n\u9805\u76ee\u8aaa\u660e_2<\/span> =<\/span> ISNULL(@\u9805\u76ee\u8aaa\u660e_2<\/span>, \u9805\u76ee\u8aaa\u660e_2<\/span>),
\n\u5de5\u4f5c\u8868\u591a\u9801 =<\/span> ISNULL(@\u5de5\u4f5c\u8868\u591a\u9801, \u5de5\u4f5c\u8868\u591a\u9801),
\nAI =<\/span> ISNULL(@AI, AI),
\ncRow =<\/span> ISNULL(@cRow, cRow)
\nWHERE<\/span> \u55ae\u865f=<\/span>@\u55ae\u865f AND<\/span> \u9805\u6b21=<\/span>@\u9805\u6b21;<\/p>\n

END<\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/section>\n<\/div>\n

\n
<\/div>\n<\/div>\n
\n

✅ \u4f60\u9019\u7248\u6539\u5584\u9ede\uff08\u53ea\u8b1b\u91cd\u9ede\uff09<\/h2>\n
    \n
  • ✔ \u4fee\u6b63 @cRow<\/code> bug<\/li>\n
  • ✔ \u62ff\u6389 EXEC(@cSQL)<\/code><\/li>\n
  • ✔ \u9632 '<\/code> \u7206\u70b8\u554f\u984c\uff08\u56e0\u70ba\u4e0d\u7528\u5b57\u4e32\u62fc\u63a5\u4e86\uff09<\/li>\n
  • ✔ ISNUMERIC \u2192 TRY_CONVERT<\/code><\/li>\n
  • ✔ UPDATE \u6539\u6210\u539f\u751f\u5beb\u6cd5\uff08\u6548\u80fd\u2191 \u7a69\u5b9a\u2191\uff09<\/li>\n<\/ul>\n
    \n

    \u5c31\u9019\u6a23\uff0c\u6c92\u6709\u591a\u9918\u5ee2\u8a71\u3002
    \u5982\u679c\u4f60\u4e0b\u4e00\u6b65\u8981\u300c\u6539\u6210\u591a\u7b46\u7248\u300d\uff0c\u518d\u8b1b\u3002<\/p>\n

    <\/div>\n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    UPDATE T SET T.\u5de5\u7a0b\u9805\u6b21 = ISNULL(REPLACE(REPLACE(I.\u5de5\u7a0b\u9805\u6b21, ‘.000’, ”), ‘.00’, ”), T.\u5de5\u7a0b\u9805\u6b21), T.\u9805\u76ee\u8aaa\u660e = ISNULL(I.\u9805\u76ee\u8aaa\u660e, T.\u9805\u76ee\u8aaa\u660e), T.\u55ae\u4f4d = ISNULL(I.\u55ae\u4f4d, T.\u55ae\u4f4d), T.\u4ee3\u865f = ISNULL(I.\u4ee3\u865f, T.\u4ee3\u865f), T.\u6578\u91cf = CASE WHEN I.\u6578\u91cf>0 THEN I.\u6578\u91cf ELSE T.\u6578\u91cf END, T.\u55ae\u50f9 = CASE WHEN I.\u55ae\u50f9>0 THEN I.\u55ae\u50f9 ELSE T.\u55ae\u50f9 END, T.\u724c\u50f9 = CASE WHEN I.\u724c\u50f9>0 THEN I.\u724c\u50f9 ELSE T.\u724c\u50f9 END, T.\u6298\u6578 = CASE WHEN I.\u6298\u6578>0 THEN T.\u6298\u6578 ELSE T.\u6298\u6578 END, T.\u985e\u578b = ISNULL(I.\u985e\u578b, T.\u985e\u578b), –T.\u5099\u8a3b = ISNULL(I.\u5099\u8a3b, T.\u5099\u8a3b), T.\u54c1\u724c = CASE WHEN I.\u54c1\u724c IS NULL THEN T.\u54c1\u724c WHEN UPPER(I.\u54c1\u724c) = ‘KURRENT’ THEN ‘Kurrent’ WHEN EXISTS (SELECT 1 FROM dbo.vi_B765 V WHERE V.\u54c1\u724c = I.\u54c1\u724c) THEN I.\u54c1\u724c ELSE ‘*’ END, T.\u9805\u76ee\u8aaa\u660e_2 = ISNULL(dbo.\u7a7a\u767d\u8f49\u9023\u63a5(dbo.\u5168\u5f62\u8f49\u534a\u5f62(I.\u9805\u76ee\u8aaa\u660e_2)), T.\u9805\u76ee\u8aaa\u660e_2), T.\u5de5\u4f5c\u8868\u591a\u9801 = ISNULL(I.\u5de5\u4f5c\u8868\u591a\u9801, T.\u5de5\u4f5c\u8868\u591a\u9801), –T.AI = ISNULL(I.AI, T.AI), T.cRow = ISNULL(I.cRow, T.cRow) FROM dbo.T_B74B T INNER JOIN INSERTED I ON T.\u55ae\u865f = @\u55ae\u865f AND T.\u9805\u6b21 = @\u9805\u6b21; \u70ba\u4f55 ‘\u4ee3\u865f’ \u7121\u6cd5\u66f4\u65b0<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
    <\/div>\n<\/div>\n<\/div>\n<\/section>\n<\/div>\n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n

    \u76f4\u63a5\u8b1b\u539f\u56e0👇<\/p>\n

    ❌ \u554f\u984c\u5728\u9019\u884c JOIN<\/h2>\n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    \n
    \n
    \n
    \n
    \n
    INNER<\/span> JOIN<\/span> INSERTED I
    \nON<\/span> T.\u55ae\u865f =<\/span> @\u55ae\u865f AND<\/span> T.\u9805\u6b21 =<\/span> @\u9805\u6b21<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
    \n
    <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

    👉 \u4f60\u6839\u672c\u6c92\u7528 I \u7684\u6b04\u4f4d\u4f86 JOIN<\/strong><\/p>\n

    \u7b49\u65bc\uff1a<\/p>\n

      \n
    • \u8ddf INSERTED \u6c92\u95dc\u806f<\/li>\n
    • \u53ea\u662f\u7528\u300c\u56fa\u5b9a\u8b8a\u6578\u300d\u53bb\u627e T<\/li>\n
    • SQL Server \u6703\u6293\u5230\u4e00\u7b46 I\uff08\u751a\u81f3\u4e0d\u78ba\u5b9a\u54ea\u4e00\u7b46\uff09<\/li>\n<\/ul>\n

      👉 \u7d50\u679c\uff1a<\/p>\n

        \n
      • I.\u4ee3\u865f<\/code> \u5f88\u53ef\u80fd\u662f NULL \u6216\u932f\u7b46<\/strong><\/li>\n
      • ISNULL(I.\u4ee3\u865f, T.\u4ee3\u865f)<\/code> \u2192 \u6c38\u9060\u8b8a\u56de T.\u4ee3\u865f
        ➡️ \u770b\u8d77\u4f86\u5c31\u50cf\u300c\u4ee3\u865f\u6c92\u66f4\u65b0\u300d<\/li>\n<\/ul>\n
        \n

        ✅ \u6b63\u78ba\u5beb\u6cd5<\/h2>\n

        👉 \u7528 INSERTED \u4f86\u5c0d\u61c9<\/p>\n

        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        \n
        INNER<\/span> JOIN<\/span> INSERTED I
        \nON<\/span> T.\u55ae\u865f =<\/span> I.\u55ae\u865f
        \nAND<\/span> T.\u9805\u6b21 =<\/span> I.\u9805\u6b21<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n

        ⚠️ \u518d\u88dc\u4e00\u500b\u4f60\u6703\u8e29\u7684\u9ede<\/h2>\n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        \n
        T.\u4ee3\u865f =<\/span> ISNULL(I.\u4ee3\u865f, T.\u4ee3\u865f)<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

        👉 \u5982\u679c I.\u4ee3\u865f = ”\uff08\u7a7a\u5b57\u4e32\uff09
        \n\u9019\u884c\u9084\u662f\u6703\u66f4\u65b0\u6210\u7a7a\u5b57\u4e32<\/p>\n

        👉 \u5982\u679c\u4f60\u8981\u300c\u7a7a\u503c\u4e5f\u4e0d\u8981\u66f4\u65b0\u300d\uff0c\u8981\u6539\uff1a<\/p>\n

        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        \n
        T.\u4ee3\u865f =<\/span> CASE<\/span>
        \nWHEN<\/span> I.\u4ee3\u865f IS<\/span> NULL<\/span> OR<\/span> I.\u4ee3\u865f =<\/span> ”<\/span>
        \nTHEN<\/span> T.\u4ee3\u865f
        \nELSE<\/span> I.\u4ee3\u865f
        \nEND<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n

        ⚠️ \u4f60\u9019\u884c\u4e5f\u662f\u932f\u7684\uff08\u9806\u4fbf\u5e6b\u4f60\u6293\uff09<\/h2>\n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        \n
        T.\u6298\u6578 =<\/span> CASE<\/span> WHEN<\/span> I.\u6298\u6578><\/span>0<\/span> THEN<\/span> T.\u6298\u6578 ELSE<\/span> T.\u6298\u6578 END<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

        👉 \u4e0d\u7ba1\u600e\u6a23\u90fd = T.\u6298\u6578
        ➡️ \u6c38\u9060\u4e0d\u6703\u66f4\u65b0<\/p>\n

        \u61c9\u8a72\u662f\uff1a<\/p>\n

        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        \n
        T.\u6298\u6578 =<\/span> CASE<\/span> WHEN<\/span> I.\u6298\u6578><\/span>0<\/span> THEN<\/span> I.\u6298\u6578 ELSE<\/span> T.\u6298\u6578 END<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n

        ✅ \u7d50\u8ad6\uff08\u5f88\u7c21\u55ae\uff09<\/h2>\n

        \u4f60\u4e0d\u662f\u300c\u4ee3\u865f\u4e0d\u80fd\u66f4\u65b0\u300d
        👉 \u662f\u4f60 JOIN \u5beb\u932f\uff0c\u5c0e\u81f4\u6293\u4e0d\u5230\u6b63\u78ba\u7684 INSERTED \u8cc7\u6599<\/p>\n

        \u6539\u9019\u884c\u5c31\u597d\u4e86\uff1a<\/p>\n

        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        \n
        ON<\/span> T.\u55ae\u865f =<\/span> I.\u55ae\u865f AND<\/span> T.\u9805\u6b21 =<\/span> I.\u9805\u6b21<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        <\/div>\n<\/div>\n<\/div>\n<\/section>\n<\/div>\n
        <\/div>\n","protected":false},"excerpt":{"rendered":"

        ✅ \u4fee\u6b63\u7248 Trigger\uff08\u4e7e\u6de8\u7248\uff09 ALTER TRIGGER [dbo].[TRI_T_B7 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3],"tags":[],"class_list":["post-1921","post","type-post","status-publish","format-standard","hentry","category-dxq_erp"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/1921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1921"}],"version-history":[{"count":3,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/1921\/revisions"}],"predecessor-version":[{"id":1924,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/1921\/revisions\/1924"}],"wp:attachment":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1921"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}