ifg-table-map.php

<?php
/**
 * @package ifgtablemap
 * @version 1.1
 */
/*
Plugin Name: ifgtablemap
Description: ifgtablemap in yaml for https://informationsfreiheit.org/ubersicht/
Author: Klaus Mueller
Version: 1.1
Author URI: http://klml.de
*/

function ifgtablemapScript(){
    if( is_page( 'ubersicht' ) ) {
        wp_register_script( 'jquerytoolsleaflettablesorter', 'https://cdn.jsdelivr.net/combine/npm/leaflet@1.9.3,npm/jquery@3.6.3,npm/tablesorter@2.31.3' , false, null, true);
        wp_register_script( 'ifgtablemapscript', plugin_dir_url( __FILE__ ) . 'js/ubersicht.js' , false, null, true);
        wp_enqueue_script('jquerytoolsleaflettablesorter');
        wp_enqueue_script('ifgtablemapscript');
    }
}
function ifgtablemapStyles() {
    if( is_page( 'ubersicht' ) ) {
        wp_register_style( 'leafletcss', 'https://cdn.jsdelivr.net/npm/leaflet@1.7.1/dist/leaflet.css' );
        wp_register_style( 'ifgtablemapstyles', plugin_dir_url( __FILE__ )  . 'ubersicht.css' ) ;
        wp_enqueue_style( 'leafletcss' );
        wp_enqueue_style( 'ifgtablemapstyles' );
    }
}
add_action( 'wp_enqueue_scripts', 'ifgtablemapStyles' );
add_action( 'wp_enqueue_scripts', 'ifgtablemapScript' );



function ifgtablemap( $atts ) {

    $bayern_yaml = plugin_dir_path( __FILE__ ) .  'bayern.yaml';

    if( isset( $_REQUEST['load_ifg_table_map'] )) {

        $ch = curl_init();

        curl_setopt($ch, CURLOPT_URL, "https://raw.githubusercontent.com/informationsfreiheit/kommunen/master/bayern.yaml");
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_HEADER, 0);

        $out = curl_exec($ch);

        curl_close($ch);

        $fp = fopen( $bayern_yaml , 'w');
        fwrite($fp, $out);
        fclose($fp);
    }

    $citys = yaml_parse_file($bayern_yaml);

    $citycounter = 0;
    $bayernAllResident = 13176989 ; // TODO get from api

    $bayernIfsResident = 0;
    
    $html = file_get_contents( plugin_dir_path( __FILE__ ) . 'table.html' )  ;


    foreach ($citys as $city) {
        // is city countable 
        $citycount = '' ;
        if ( $city['art'] != 'Ausarbeitung' && $city['art'] != 'ausserkraft') {
            $citycounter = $citycounter + 1;
            $citycount = $citycounter . '.' ;
            $bayernIfsResident = $bayernIfsResident + $city['resident'];  // TODO floating
        }
        ( $city['resident'] != 0 ) ? $cityresident = number_format( $city['resident'] , 0, '','.') : $cityresident = ' ' ;
        $cityname =  strtolower( str_replace(' ', '_', $city['name']) );         
        $html .= "
<tr id='$cityname' data-pos='$city[pos]' data-gemart='$city[art]' >
<td><a href='#$cityname'>$citycount</a></td>
<td class='name'><a href='$city[href]'><strong>$city[name]</strong> ($city[bez]) </a></td>
<td>$city[init]</td>
<td>$city[start]</td>
<td>$city[bemerkung]</td>
<td class='resident'>$cityresident</td>
<td>";
        if ( $city['satzlink'] != '' ) {
        $html .= "<a title='Direkt zur Satzung' href='$city[satzlink]'>Satzung</a>";
        }
        $html .= "</td>
<td><a title='Anfrage über fragdenstaat.de' href='$city[fragdenstaat_url]'>Anfrage</a></td>
</tr>";
    }
    $html .= "</tbody></table>
<p>Derzeit haben " . number_format($bayernIfsResident, 0, '','.') . " (" .  round( $bayernIfsResident / $bayernAllResident * 100 , 0 )  . " %) Einwohner in Bayern Akteneinsichtsrecht gemäß kommunaler Informationsfreiheit im Bereich des eigenen Wirkungskreis der Gemeinden.</p>" ;

    return $html ;
}

remove_filter( 'the_content', 'wpautop' );
add_filter( 'the_content', 'wpautop' , 99);
add_filter( 'the_content', 'shortcode_unautop',100 );
add_shortcode( 'ifgtablemap', 'ifgtablemap' );