{"id":390,"date":"2015-07-23T11:25:58","date_gmt":"2015-07-23T09:25:58","guid":{"rendered":"http:\/\/dokumentacja.edokumenty.eu\/?page_id=390"},"modified":"2016-01-22T09:42:40","modified_gmt":"2016-01-22T08:42:40","slug":"sqldatasource","status":"publish","type":"page","link":"http:\/\/developer.edokumenty.eu\/index.php\/dokumentacja-online-systemu-edokumenty\/dostep-i-przetwarzanie-danych\/sqldatasource\/","title":{"rendered":"SQLDataSource"},"content":{"rendered":"<p>Obiekt SQLDataSource jest rozszerzeniem klasy DataSource, kt\u00f3ry mo\u017cemy wykorzysta\u0107 m.in do wprowadzania danych do tabel (SimpleTable2). Obiektu tego u\u017cywamy kiedy potrzebujemy danych z bazy danych.<\/p>\n<p>Poni\u017cszy fragment kodu tworzy\u00a0obiekt SQLDataSource.<\/p>\n<div class=\"code-highlight code-highlight-with-label\" data-label=\"PHP\"><span class=\"js-copy-to-clipboard copy-code\">copy<\/span>\n\t<pre><code class=\"language-php js-code\">\nrequire_once(LIB_PATH.'data\/SQLDataSource.inc');\r\n$dataSource=\u00a0new\u00a0SQLDataSource('data');\r\n$query\u00a0=\u00a0'\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SELECT\u00a0round(extract(epoch\u00a0from\u00a0l.adddat)::numeric,\u00a03)::text\u00a0||\u00a0\\':\\'\u00a0||\u00a0lt.emp_id\u00a0as\u00a0grpval,\u00a0l.chloid,\u00a0l.chacat,\u00a0l.adddat,\u00a0l.commnt,\u00a0l.f_path,\u00a0l.fdtype,\u00a0l.from__,\u00a0l.subjct,\u00a0l.date__,\u00a0l.hmesid,\u00a0lt.lgtrid,\u00a0lt.emp_id,\u00a0lt.emptxt\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0FROM\u00a0email_accounts_log\u00a0l\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0JOIN\u00a0log_trace\u00a0lt\u00a0ON\u00a0lt.lgtrid\u00a0=\u00a0l.lgtrid\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHERE\u00a0l.acntid\u00a0=\u00a0'.$this-&gt;acntid.'\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0';\r\n$dataSource-&gt;setupQuery('('.$query.')\u00a0ea',\u00a0'WHERE\u00a0true');\r\n$dataSource-&gt;columns\u00a0=\u00a0'grpval,\u00a0commnt,\u00a0adddat,\u00a0emp_id,\u00a0emptxt';\r\n$dataSource-&gt;attach($this-&gt;searchFilter);\r\n$dataSource-&gt;defaultOrder\u00a0=\u00a0'adddat,\u00a0chloid';\r\n$dataSource-&gt;setDescending(false);\n<\/code><\/pre><\/div>\n<pre class=\"lang:php decode:true \"><\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Obiekt SQLDataSource jest rozszerzeniem klasy DataSource, kt\u00f3ry mo\u017cemy wykorzysta\u0107 m.in do wprowadzania danych do tabel (SimpleTable2). Obiektu tego u\u017cywamy kiedy potrzebujemy danych z bazy danych. Poni\u017cszy fragment kodu tworzy\u00a0obiekt SQLDataSource. &nbsp;<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":502,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"tags":[93,92,94],"_links":{"self":[{"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/pages\/390"}],"collection":[{"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/comments?post=390"}],"version-history":[{"count":2,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/pages\/390\/revisions"}],"predecessor-version":[{"id":618,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/pages\/390\/revisions\/618"}],"up":[{"embeddable":true,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/pages\/502"}],"wp:attachment":[{"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/media?parent=390"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/developer.edokumenty.eu\/index.php\/wp-json\/wp\/v2\/tags?post=390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}