{"id":338,"date":"2022-11-08T10:02:56","date_gmt":"2022-11-08T09:02:56","guid":{"rendered":"http:\/\/blog.c-hase.de\/?p=338"},"modified":"2024-12-17T13:41:20","modified_gmt":"2024-12-17T12:41:20","slug":"konvertieren-vom-dpc-controlcenter-zu-json-datei","status":"publish","type":"post","link":"https:\/\/blog.c-hase.de\/?p=338","title":{"rendered":"Konvertieren vom dpc-Controlcenter zu JSON-Datei"},"content":{"rendered":"<pre>select s7013ottarif.agab,s7013ottarif.tarif,s7013ottarif.des,s7013ottarif.desxl as betreuungszeit,s8300ot.des as Schule,s7013ottarif.value as preis\n\nfrom s7013ottarif JOIN s8300ot ON (s8300ot.ortsteil = s7013ottarif.ortsteil)\nwhere s7013ottarif.ortsteil in (SELECT ortsteil FROM s8300ot )\nand s7013ottarif.agab in (40,50)\nand s7013ottarif.tariffield = 'gegart'\nand s7013ottarif.tarif in ('A1','B1','3','5')\nand (s7013ottarif.verdatt is null or s7013ottarif.verdatt = '31.12.2099')\nand s7013ottarif.tarifdatt ='31.12.2099'\nORDER BY s7013ottarif.ortsteil<\/pre>\n<ol>\n<li>sql im Center ausf\u00fchren<\/li>\n<li>als excel exportieren<\/li>\n<li>mit openspread \u00f6ffnen<\/li>\n<li>als ods apspeichern<\/li>\n<li>in Mysql einlesen und mit GROUP_CONCAT und JSON_OBJECT abfragen.<\/li>\n<\/ol>\n<pre>SELECT CONCAT('[', \nGROUP_CONCAT(json_object('agab',agab,\n'tarif',tarif,\n'des',des,\n'betreuungszeit',betreuungszeit,\n'ortsteil',ortsteil,\n'Schule',Schule,\n'Gebuehr',Gebuehr\n)\n)\n,']' \n) FROM schule;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>select s7013ottarif.agab,s7013ottarif.tarif,s7013ottarif.des,s7013ottarif.desxl as betreuungszeit,s8300ot.des as Schule,s7013ottarif.value as preis from s7013ottarif JOIN s8300ot ON (s8300ot.ortsteil = s7013ottarif.ortsteil) where s7013ottarif.ortsteil in (SELECT ortsteil FROM s8300ot ) and s7013ottarif.agab in (40,50) and s7013ottarif.tariffield = &#8218;gegart&#8216; and s7013ottarif.tarif in (&#8218;A1&#8242;,&#8217;B1&#8242;,&#8217;3&#8242;,&#8217;5&#8216;) and (s7013ottarif.verdatt is null &hellip; <a href=\"https:\/\/blog.c-hase.de\/?p=338\">Weiterlesen <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,1],"tags":[],"class_list":["post-338","post","type-post","status-publish","format-standard","hentry","category-json-file","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/posts\/338","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=338"}],"version-history":[{"count":4,"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/posts\/338\/revisions"}],"predecessor-version":[{"id":1272,"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=\/wp\/v2\/posts\/338\/revisions\/1272"}],"wp:attachment":[{"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.c-hase.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}