{"id":140,"date":"2010-02-18T05:00:15","date_gmt":"2010-02-18T10:00:15","guid":{"rendered":"http:\/\/blog.espol.edu.ec\/daws\/?p=140"},"modified":"2010-02-18T05:00:15","modified_gmt":"2010-02-18T10:00:15","slug":"consulta-de-varias-tablas","status":"publish","type":"post","link":"https:\/\/blog.espol.edu.ec\/daws\/2010\/02\/18\/consulta-de-varias-tablas\/","title":{"rendered":"Consulta de Varias Tablas"},"content":{"rendered":"<p>Este es un ejemplo de mas o menos como seria la consulta de los gastos ahi tendramos q implentar la parte de los graficos<\/p>\n<p>public List getGastoCategoria(String fechaini, String fechafin, int idUser){<br \/>\nList lista = null;<br \/>\ntry{<br \/>\nsession.beginTransaction();<br \/>\nQuery q=session.createQuery(\"select e.total, c.nombre from tbegreso e, tbitemegreso ie, tbcategoria c where e.idegreso = ie.iditemegreso and ie.iditemegreso = c.idcategoria and c.idcategoria = 1\");<br \/>\nlista = q.list();<br \/>\n}<br \/>\ncatch(Exception e){<br \/>\ne.printStackTrace();<br \/>\n}<br \/>\nreturn lista;<br \/>\n}<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Este es un ejemplo de mas o menos como seria la consulta de los gastos ahi tendramos q implentar la parte de los graficos public List getGastoCategoria(String fechaini, String fechafin, int idUser){ List lista = null; try{ session.beginTransaction(); Query q=session.createQuery(\"select e.total, c.nombre from tbegreso e, tbitemegreso ie, tbcategoria c where e.idegreso = ie.iditemegreso and ie.iditemegreso [&hellip;]<\/p>\n","protected":false},"author":187,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-140","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/blog.espol.edu.ec\/daws\/wp-json\/wp\/v2\/posts\/140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.espol.edu.ec\/daws\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.espol.edu.ec\/daws\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.espol.edu.ec\/daws\/wp-json\/wp\/v2\/users\/187"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.espol.edu.ec\/daws\/wp-json\/wp\/v2\/comments?post=140"}],"version-history":[{"count":2,"href":"https:\/\/blog.espol.edu.ec\/daws\/wp-json\/wp\/v2\/posts\/140\/revisions"}],"predecessor-version":[{"id":142,"href":"https:\/\/blog.espol.edu.ec\/daws\/wp-json\/wp\/v2\/posts\/140\/revisions\/142"}],"wp:attachment":[{"href":"https:\/\/blog.espol.edu.ec\/daws\/wp-json\/wp\/v2\/media?parent=140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.espol.edu.ec\/daws\/wp-json\/wp\/v2\/categories?post=140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.espol.edu.ec\/daws\/wp-json\/wp\/v2\/tags?post=140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}