{"id":1844,"date":"2021-11-21T22:16:34","date_gmt":"2021-11-21T19:16:34","guid":{"rendered":"https:\/\/burakcaliskan.org\/blog\/?p=1844"},"modified":"2021-11-25T22:12:21","modified_gmt":"2021-11-25T19:12:21","slug":"logo-yazilim-hangi-urun-kac-adet-kac-tl-ye-satilmis","status":"publish","type":"post","link":"https:\/\/burakcaliskan.org\/blog\/logo-yazilim-hangi-urun-kac-adet-kac-tl-ye-satilmis\/","title":{"rendered":"Logo Yaz\u0131l\u0131m Hangi \u00fcr\u00fcn ka\u00e7 adet ka\u00e7 TL ye sat\u0131lm\u0131\u015f"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>SELECT * FROM (SELECT\r\nI.CARDTYPE \"Malzeme T\u00fcr\u00fc\",\r\nI.CODE \"Malzeme Kodu\",\r\nI.NAME \"Malzeme Ad\u0131\",\r\nI.SPECODE \"Malzeme \u00d6zel Kodu\",\r\nI.CYPHCODE \"Malzeme Yetki Kodu\",\r\nU.CODE \"Birim Seti \",\r\nT.CODE \"Birim Kodu\",\r\nSUM(SIGN(L.IOCODE-1)L.AMOUNT) \"Sat\u0131\u015f Miktar\u0131\", SUM(SIGN(4-L.IOCODE)L.AMOUNT) \"\u0130ade Miktar\u0131\",\r\nSUM(SIGN(L.IOCODE-1)*L.TOTAL) \"Sat\u0131\u015f Tutar\u0131\"\r\nFROM\r\nLG_021_01_STLINE L\r\nLEFT OUTER JOIN LG_021_01_STFICHE F ON L.STFICHEREF=F.LOGICALREF\r\nLEFT OUTER JOIN LG_021_ITEMS I ON L.STOCKREF=I.LOGICALREF AND L.LINETYPE NOT IN (1,2,3,4)\r\nLEFT OUTER JOIN LG_021_UNITSETF U ON I.UNITSETREF=U.LOGICALREF\r\nLEFT OUTER JOIN LG_021_UNITSETL T ON U.LOGICALREF=T.UNITSETREF\r\nWHERE\r\nI.LOGICALREF IS NOT NULL\r\nAND F.GRPCODE=2\r\nAND T.LINENR=1\r\nGROUP BY\r\nI.CARDTYPE,\r\nI.CODE,\r\nI.NAME,\r\nU.CODE,\r\nT.CODE,\r\nI.SPECODE,\r\nI.CYPHCODE\r\n) AS DYNMQRY\r\nORDER BY DYNMQRY.&#91;Malzeme Kodu] ASC, DYNMQRY.&#91;Malzeme Ad\u0131] 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":[1096],"tags":[],"_links":{"self":[{"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1844"}],"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=1844"}],"version-history":[{"count":2,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1844\/revisions"}],"predecessor-version":[{"id":1860,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1844\/revisions\/1860"}],"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=1844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/categories?post=1844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/tags?post=1844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}