{"id":1846,"date":"2021-11-21T22:20:42","date_gmt":"2021-11-21T19:20:42","guid":{"rendered":"https:\/\/burakcaliskan.org\/blog\/?p=1846"},"modified":"2021-11-25T22:07:32","modified_gmt":"2021-11-25T19:07:32","slug":"logo-yazilim-tum-urunlerlerin-fiyat-ve-stok-bilgisi","status":"publish","type":"post","link":"https:\/\/burakcaliskan.org\/blog\/logo-yazilim-tum-urunlerlerin-fiyat-ve-stok-bilgisi\/","title":{"rendered":"Logo Yaz\u0131l\u0131m T\u00fcm \u00fcr\u00fcnlerlerin Fiyat ve Stok Bilgisi"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>SELECT\r\nI.CODE AS 'URUN_KODU' ,\r\nI.NAME AS 'URUN_ADI',\r\nI.STGRPCODE AS 'GRUP KODU',\r\nI.SPECODE AS '\u00d6ZEL KODU',\r\nI.LOGICALREF ,\r\nISNULL(PR.PRICE,0)AS FIYAT,\r\nISNULL(PR.CURRENCY,0) AS DOVIZ,\r\nSUM ((CASE S.TRCODE WHEN 1 THEN S.AMOUNT*UINFO2 ELSE 0 END )+ (CASE S.TRCODE WHEN 13 THEN S.AMOUNT*UINFO2 ELSE 0 END)+\r\n(CASE F.TRCODE WHEN 3 THEN S.AMOUNT*UINFO2 ELSE 0 END )+(CASE S.TRCODE WHEN 14 THEN S.AMOUNT*UINFO2 ELSE 0 END)+\r\n(CASE S.TRCODE WHEN 50 THEN S.AMOUNT*UINFO2 ELSE 0 END)) +\r\nSUM((CASE F.TRCODE WHEN 8 THEN S.AMOUNT*UINFO2 ELSE 0 END)+(CASE S.TRCODE WHEN 6 THEN S.AMOUNT*UINFO2 ELSE 0 END)+\r\n(CASE S.TRCODE WHEN 12 THEN S.AMOUNT*UINFO2 ELSE 0 END)+(CASE S.TRCODE WHEN 11 THEN S.AMOUNT*UINFO2 ELSE 0 END)+\r\n(CASE S.TRCODE WHEN 51 THEN S.AMOUNT*UINFO2 ELSE 0 END)+(CASE S.TRCODE WHEN 20 THEN S.AMOUNT*UINFO2 ELSE 0 END)) AS 'STOK'\r\nfrom LG_021_ITEMS AS I LEFT JOIN\r\nLG_021_01_STLINE AS S ON I.LOGICALREF=S.STOCKREF AND I.ACTIVE='0' and S.CANCELLED='0' LEFT JOIN\r\nLG_021_01_INVOICE AS F ON S.INVOICEREF=F.LOGICALREF LEFT JOIN\r\nLG_021_PRCLIST AS PR ON I.LOGICALREF=PR.CARDREF and PR.PTYPE=2 LEFT JOIN\r\nLG_021_01_STINVTOT AS ST ON I.LOGICALREF=ST.STOCKREF\r\nGROUP BY I.CODE,I.NAME,I.STGRPCODE,I.SPECODE,PR.PRICE,PR.CURRENCY,PR.PRIORITY,I.LOGICALREF,PR.PRICE\r\nORDER BY URUN_KODU ASC<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":1842,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[75],"tags":[],"_links":{"self":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1846"}],"collection":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/comments?post=1846"}],"version-history":[{"count":3,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1846\/revisions"}],"predecessor-version":[{"id":1859,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1846\/revisions\/1859"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/media\/1842"}],"wp:attachment":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/media?parent=1846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/categories?post=1846"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/tags?post=1846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}