{"id":437,"date":"2022-06-21T11:53:27","date_gmt":"2022-06-21T09:53:27","guid":{"rendered":"https:\/\/www.eldin.net\/wordpress\/?page_id=437"},"modified":"2022-06-21T11:57:42","modified_gmt":"2022-06-21T09:57:42","slug":"expoactes-afficher-ne-nombre-dactes-par-communes-dans-la-liste-de-geolocalisation","status":"publish","type":"page","link":"https:\/\/www.eldin.net\/wordpress\/index.php\/expoactes-afficher-ne-nombre-dactes-par-communes-dans-la-liste-de-geolocalisation\/","title":{"rendered":"ExpoActes : afficher le nombre d&rsquo;actes par communes dans la liste de g\u00e9olocalisation"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">actes\/admin\/listgeolocs.php    <\/h2>\n\n\n\n<p>Modif pour afficher le nb d&rsquo;actes par communes <\/p>\n\n\n\n<p>ligne 95   modif des conditions  on affiche les communes via act_geoloc et act_sums<br>\n        $condit = \u00a0\u00bb where b.commune=a.commune and b.depart=a.depart \u00ab\u00a0;<\/p>\n\n\n\n<p>ligne 97        idem<br>\n          $condit = \u00a0\u00bb where a.COMMUNE like &lsquo;\u00a0\u00bb.$init.\u00a0\u00bb%&rsquo; and b.commune=a.commune and b.depart=a.depart \u00ab\u00a0;<\/p>\n\n\n\n<p>ligne 100       on ajoute la table act_sums et le nb total des actes pour une commune<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>    $request = \"select ID,a.COMMUNE,a.DEPART,LON,LAT,STATUT,sum(NB_TOT) as nbtot\"\n                            .\" from \".EA_DB.\"_geoloc a,\".EA_DB.\"_sums b \"\n                            .$condit\n                            .\" group by b.commune order by \".$order;<\/code><\/pre>\n\n\n\n<p>ligne 135 ajout le titre de colonnes actes<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>      echo '&lt;th>Actes&lt;\/th>';<\/code><\/pre>\n\n\n\n<p>ligne 149       affiche le nb d&rsquo;actes pour une commune<br>                     echo &lsquo;&lt;td align=center>&rsquo;.$ligne[&lsquo;nbtot&rsquo;].'&lt;\/td>&rsquo;;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>actes\/admin\/listgeolocs.php Modif pour afficher le nb d&rsquo;actes par communes ligne 95 modif des conditions on affiche les communes via act_geoloc et act_sums $condit = \u00a0\u00bb where b.commune=a.commune and b.depart=a.depart \u00ab\u00a0; ligne 97 idem $condit = \u00a0\u00bb where a.COMMUNE like &lsquo;\u00a0\u00bb.$init.\u00a0\u00bb%&rsquo; and b.commune=a.commune and b.depart=a.depart \u00ab\u00a0; ligne 100 on ajoute la table act_sums et le nb &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.eldin.net\/wordpress\/index.php\/expoactes-afficher-ne-nombre-dactes-par-communes-dans-la-liste-de-geolocalisation\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;ExpoActes : afficher le nombre d&rsquo;actes par communes dans la liste de g\u00e9olocalisation&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-437","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/437"}],"collection":[{"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=437"}],"version-history":[{"count":3,"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/437\/revisions"}],"predecessor-version":[{"id":441,"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/437\/revisions\/441"}],"wp:attachment":[{"href":"https:\/\/www.eldin.net\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}