{"id":1851,"date":"2021-11-25T21:54:31","date_gmt":"2021-11-25T18:54:31","guid":{"rendered":"https:\/\/burakcaliskan.org\/blog\/?p=1851"},"modified":"2021-11-25T21:56:40","modified_gmt":"2021-11-25T18:56:40","slug":"logo-yazilim-satis-faturalari-sql","status":"publish","type":"post","link":"https:\/\/burakcaliskan.org\/blog\/logo-yazilim-satis-faturalari-sql\/","title":{"rendered":"Logo Yaz\u0131l\u0131m Sat\u0131\u015f Faturalar\u0131 SQL"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>SELECT\n\nISNULL(CASE WHEN INV.FROMKASA = 1 AND INV.CANCELLED = 1 THEN '\u0130' WHEN INV.FROMKASA = 1 THEN 'K' END,''),\nCONVERT(NVARCHAR,INV.DATE_,103) 'TAR\u0130H',\nINV.FICHENO 'F\u0130\u015e NO.',\nINV.DOCODE 'BELGE NO',\nCASE INV.TRCODE WHEN 8 THEN 'TOPTAN SATI\u015e FATURASI' WHEN 3 THEN 'TOPTAN SATI\u015e \u0130ADE FATURASI' END 'T\u00dcR\u00dc' ,\nINV.NETTOTAL 'TUTAR',\nCASE INV.TRCURR\nWHEN 0 THEN CAST(INV.TRNET AS NVARCHAR) + ' TL'\nWHEN 1 THEN CAST(INV.TRNET AS NVARCHAR) + ' $'\nWHEN 20 THEN CAST(INV.TRNET AS NVARCHAR) + ' \u20ac'\nEND 'D\u00d6V\u0130ZL\u0130 TUTAR',\nCPD.NR '\u0130\u015eYER\u0130',\nCPW.NR 'AMBAR'\n\nFROM LG_021_01_INVOICE INV\nLEFT JOIN LG_021_CLCARD CLC ON CLC.LOGICALREF = INV.CLIENTREF\nLEFT JOIN L_CAPIDEPT CPD ON CPD.NR = INV.BRANCH AND CPD.FIRMNR = 5\nLEFT JOIN L_CAPIWHOUSE CPW ON CPW.NR = INV.SOURCEINDEX AND CPW.FIRMNR = 5\n\nWHERE GRPCODE = 2\n\nORDER BY INV.DATE_ 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\/1851"}],"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=1851"}],"version-history":[{"count":4,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1851\/revisions"}],"predecessor-version":[{"id":1856,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/posts\/1851\/revisions\/1856"}],"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=1851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/categories?post=1851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/burakcaliskan.org\/blog\/wp-json\/wp\/v2\/tags?post=1851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}