ai_classes_overloaded.php

<?php

add_action('wp_ajax_nopriv_get_decision_paragraph_tags', 'informea_get_decision_paragraph_tags');
add_action('wp_ajax_get_decision_paragraph_tags', 'informea_get_decision_paragraph_tags');

add_action('wp_ajax_nopriv_get_decision_paragraph_tags_html', 'informea_get_decision_paragraph_tags_html');
add_action('wp_ajax_get_decision_paragraph_tags_html', 'informea_get_decision_paragraph_tags_html');

add_action('wp_ajax_nopriv_countries_autocomplete', 'ajax_countries_autocomplete');
add_action('wp_ajax_countries_autocomplete', 'ajax_countries_autocomplete');

add_action('wp_ajax_nopriv_nfp_autocomplete', 'ajax_nfp_autocomplete');
add_action('wp_ajax_nfp_autocomplete', 'ajax_nfp_autocomplete');

add_action('wp_ajax_nopriv_country_mea_membership', 'ajax_country_mea_membership');
add_action('wp_ajax_country_mea_membership', 'ajax_country_mea_membership');

add_action('wp_ajax_nopriv_country_nfp', 'ajax_country_nfp');
add_action('wp_ajax_country_nfp', 'ajax_country_nfp');

add_action('wp_ajax_nopriv_country_sites_markers', 'ajax_country_sites_markers');
add_action('wp_ajax_country_sites_markers', 'ajax_country_sites_markers');

add_action('wp_ajax_nopriv_get_event_list', array('informea_meetings', 'ajax_get_event_list'));
add_action('wp_ajax_get_event_list', array('informea_meetings', 'ajax_get_event_list'));
add_action('wp_ajax_nopriv_get_event_list_html', array('informea_meetings', 'ajax_get_event_list_html'));
add_action('wp_ajax_get_event_list_html', array('informea_meetings', 'ajax_get_event_list_html'));


/* Ajax endpoints */

function ajax_countries_autocomplete() {
    $page_data = new imea_countries_page(NULL);
    $key = get_request_value('key');
    $countries = $page_data->search_countries_by_name($key);
    $arr = array();
    foreach ($countries as $country) {
        $arr[] = array('id' => $country->id, 'name' => $country->name);
    }
    header('Content-Type:application/json');
    echo json_encode($arr);
    die();
}

function ajax_nfp_autocomplete() {
    $page_data = new imea_countries_page(NULL);
    $key = get_request_value('key');
    $objects = $page_data->search_nfp_by_name($key);
    $arr = array();
    foreach ($objects as $ob) {
        $label = $ob->first_name . ' ' . $ob->last_name . ' (' . $ob->country_name . ')';
        $arr[] = array('id_contact' => $ob->id, 'id_country' => $ob->id_country, 'label' => $label, 'id_treaty' => $ob->id_treaty);
    }
    header('Content-Type:application/json');
    echo json_encode($arr);
    die();
}

function ajax_country_sites_markers() {
    $id_country = get_request_int('id');
    header('Content-Type:application/json');

    $icon_whc = sprintf('%s/wp-content/uploads/whc_marker.png', get_bloginfo('url'));
    $icon_ramsar = sprintf('%s/wp-content/uploads/ramsar_marker.png', get_bloginfo('url'));

    $whc_markers = array();
    $ramsar_markers = array();

    foreach(informea_countries::get_whc_sites($id_country) as $site) {
        $ob = new stdClass();
        $ob->the_id = $site->original_id;
        $ob->clickable = TRUE;
        $ob->icon = $icon_whc;
        $ob->latitude = $site->latitude;
        $ob->longitude = $site->longitude;
        $ob->title = $site->name;
        $ob->url = $site->url;
        $whc_markers[] = $ob;
    }

    foreach(informea_countries::get_ramsar_sites($id_country) as $site) {
        $ob = new stdClass();
        $ob->id = str_replace('ramsar-', '', $site->original_id);
        $ob->the_id = $site->original_id;
        $ob->clickable = TRUE;
        $ob->icon = $icon_ramsar;
        $ob->latitude = $site->latitude;
        $ob->longitude = $site->longitude;
        $ob->title = $site->name;
        $ob->url = $site->url;
        $ramsar_markers[] = $ob;
    }


    echo json_encode(
        array(
            'whc' => $whc_markers,
            'ramsar' => $ramsar_markers
        )
    );
    die();
}

function ajax_country_mea_membership() {
    $id_country = get_request_int('id');
    $membership = informea_countries::get_treaty_membership($id_country);
    header('Content-Type:text/html');
?>
    <table>
        <?php foreach($membership as $row): ?>
        <tr>
            <td class="text-center">
                <i class="thumbnail <?php echo $row->odata_name; ?>">&nbsp;</i>
            </td>
            <td><a href="<?php echo get_bloginfo('url') . '/treaties/' . $row->odata_name;?>"><?php echo $row->short_title; ?></a></td>
            <td class="text-center"><?php echo mysql2date('Y', $row->date); ?></td>
        </tr>
        <?php endforeach; ?>
    </table>
<?php
    die();
}

function ajax_country_nfp() {
    $id_country = get_request_int('id');
    $nfps = informea_countries::get_focal_points_by_treaty($id_country);
    header('Content-Type:text/html');
    ?>
    <table>
        <?php foreach($nfps as $row): ?>
            <tr>
                <td>
                    <div class="thumbnail <?php echo $row->odata_name; ?>"></div>
                </td>
                <td>
                    <a href="<?php echo get_bloginfo('url') . '/treaties/' . $row->odata_name;?>"><?php echo $row->short_title; ?></a>
                </td>
                <td class="text-top">
                    <ul>
                    <?php foreach($row->focal_points as $p): ?>
                        <li>
                            <?php echo sprintf('%s %s %s', $p->prefix, $p->first_name, $p->last_name); ?>
                            <p class="note">
                                <?php echo informea_countries::get_focal_point_position($p); ?>
                            </p>
                            [ <a target="_blank" href="<?php echo sprintf('%s/nfp/%d', get_bloginfo('url'), $p->id);?>">contact</a> ]
                        </li>
                    <?php endforeach ?>
                    </ul>
                </td>
            </tr>
        <?php endforeach; ?>
    </table>
    <?php
    die();
}

/**
 * Generate JSON object with paragraph tags based on paragraph id
 * @param @id_paragraph paragraph id from query string
 * @return string JSON string
 */
function informea_get_decision_paragraph_tags() {
    $id_paragraph = get_request_int('id_paragraph', 0);
    if ($id_paragraph > 0) {
        $arr = array();
        $ob = new informea_decisions();
        $tags = $ob->get_paragraph_tags($id_paragraph);
        foreach ($tags as $tag) {
            $arr[] = array('id' => $tag->id, 'term' => $tag->term);
        }
        header('Content-Type:application/json');
        echo json_encode($arr);
    }
    die();
}


/**
 * Generate HTML with paragraph tags based on paragraph id
 * @param @id_paragraph paragraph id from query string
 * @return string HTML data
 */
function informea_get_decision_paragraph_tags_html() {
    $id_paragraph = get_request_int('id_paragraph', 0);
    $ret = '';
    if ($id_paragraph > 0) {
        $ob = new informea_decisions();
        $tags = $ob->get_paragraph_tags($id_paragraph);
        if(count($tags)) {
            foreach($tags as $tag) {
                $ret .= sprintf('<a href="%s/terms/%s" target="_blank">%s</a><br />', get_bloginfo('url'), $tag->id, $tag->term);
            }
        } else {
            $ret = 'This article has not been tagged';
        }
    }
    header('Content-Type:text/html');
    echo $ret;
    die();
}


class informea_treaties extends imea_treaties_page {

    public $expand;

    function __construct($id_treaty = NULL, $arr_parameters = array()) {
        parent::__construct($id_treaty, $arr_parameters);
    }

    static function get_treaty_from_request() {
        $id = get_request_variable('id');
        $treaty = self::get_treaty_by_odata_name($id);
        if(empty($treaty)) { // Compatibility
            $treaty = self::get_treaty_by_id($id);
        }
        return $treaty;
    }

    function handle_view() {
        global $expand, $id_treay;
        // Global
        $this->expand = get_request_variable('expand', 'str', 'treaty');
        $this->id_treaty = get_request_variable('id_treaty', 0);

        if ($this->is_index()) {
            get_template_part('imea_pages/treaties/page');
            exit(0);
        }

        // Administrative
        if (current_user_can('manage_options')) {
            if ($this->get_action() == 'delete_paragraph') {
                $id_paragraph = get_request_int('id_paragraph');
                $this->delete_paragraph($id_paragraph);
            }
            if ($this->get_action() == 'delete_article') {
                $id_article = get_request_int('id_article');
                $this->delete_article($id_article);
            }
        }
        // Print treaty page
        if ($this->expand == 'print') {
            get_template_part('imea_pages/treaties/page', 'treaty-print');
            exit(0);
        }
    }


    /**
     * Retrieve the list of decisions for this treaty
     * @param $id_treaty integer Treaty Identified
     * @return integer Number of decisions for this treaty
     */
    static function get_decisions_count($id_treaty) {
        global $wpdb;
        $sql = $wpdb->prepare(
            "SELECT COUNT(*) AS cnt
                FROM ai_decision
                WHERE id_treaty = %d AND status <> 'retired'
                ORDER BY published DESC",
            $id_treaty
        );
        return $wpdb->get_var($sql);
    }


    /**
     * Retrieve decisions grouped by meeting
     * @param $id_treaty integer Treaty identified
     * @return array
     */
    static function group_decisions_by_meeting($id_treaty) {
        if($id_treaty != 5) {
            return parent::group_decisions_by_meeting($id_treaty);
        } else {
            global $wpdb;
            $ret = array();
            // Hack! Stockholm do not have id_meeting, darn it!
            $meetings = $wpdb->get_results(
                'SELECT DISTINCT meeting_title AS title
                    FROM ai_decision
                    WHERE id_treaty=5
                    ORDER BY meeting_title DESC'
            );
            foreach($meetings as &$row) {
                $row->decisions = $wpdb->get_results($wpdb->prepare(
                    'SELECT * FROM ai_decision WHERE id_treaty=5 AND meeting_title=%s', $row->title
                ));
                $ret[] = $row;
            }
            return $ret;
        }
    }


    /**
     * @param string $odata_name
     * @return stdClass
     */
    static function get_treaty_by_odata_name($odata_name) {
        global $wpdb;
        return $wpdb->get_row("SELECT * FROM ai_treaty WHERE odata_name = '$odata_name' AND use_informea=1");
    }


    /**
     * Return number of treaties from a region
     * @param $region to check
     * @return number of treaties
     */
    function region_has_treaties($region) {
        global $wpdb;
        return $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM ai_treaty WHERE region = %s AND use_informea=1", $region));
    }


    /**
     * Retrieve active treaties all or by title
     * @param $title Treaty title
     * @return WP SQL result object
     */
    static function get_treaties($title = null) {
        global $wpdb;
        if ($title) {
            return $wpdb->get_results("SELECT * FROM ai_treaty WHERE enabled = 1 AND use_informea=1 AND (short_title LIKE '%$title%' OR long_title LIKE '%$title%') ORDER BY short_title");
        } else {
            return $wpdb->get_results("SELECT * FROM ai_treaty WHERE enabled = 1 AND use_informea=1 ORDER BY short_title");
        }
    }


    static function get_treaties_keyed_by_id() {
        $ret = array();
        $rows = self::get_treaties();
        foreach($rows as $row) {
            $ret[$row->id] = $row;
        }
        return $rows;
    }


    static function generate_vcard($id_contact) {
        $contact = self::get_contact_for_id($id_contact);
        if(!empty($contact)) {
            header("Content-type: text/x-vcard; charset=utf-8");
            header("Content-Disposition: filename=\"" . $contact->first_name . " " . $contact->last_name . ".vcf\"");
            echo "BEGIN:VCARD\n";
            echo "VERSION:2.1\n";
            echo "N:" . $contact->last_name . ";" . $contact->first_name . ";;" . $contact->prefix . "\n";
            echo "FN:" . $contact->first_name . " " . $contact->last_name . "\n";
            echo "ORG:" . $contact->institution . ";" . $contact->department . "\n";
            echo "TITLE:" . $contact->position . "\n";
            echo "TEL;WORK;VOICE:" . $contact->telephone . "\n";
            echo "TEL;WORK;FAX:" . $contact->fax . "\n";
            echo "EMAIL;PREF;INTERNET:" . $contact->email . "\n";
            echo "ADR;WORK:;;" . str_replace("\r\n", " ", $contact->address) . ";;;;" . $contact->country_name . "\n";
            echo "END:VCARD\n";
        } else {
            die('No such entity');
        }
    }


    static function send_message_to_nfp_validate() {
        $errors = array();
        $cname = get_request_value('cname');
        if(empty($cname)) {
            $errors[] = 'Your name is required';
        }
        $email = get_request_value('email');
        if(empty($email)) {
            $errors[] = 'Your e-mail address is required';
        } else {
            if(!is_email($email)) {
                $errors[] = 'Invalid e-mail address';
            }
        }
        $message = get_request_value('message');
        if(empty($message)) {
            $errors[] = 'Message cannot be empty';
        }
        $id = get_request_variable('id_nfp');
        $contact = self::get_contact_for_id($id);
        if(empty($contact)) {
            $errors[] = 'Invalid contact. Contact is not in our database';
        }

        $options = get_option('informea_options');
        $private_key = $options['recaptcha_private'];
        $resp = recaptcha_check_answer($private_key, $_SERVER['REMOTE_ADDR'],
            get_request_value('recaptcha_challenge_field'),
            get_request_value('recaptcha_response_field')
        );
        if (!$resp->is_valid) {
            $errors[] = 'Invalid security. Please enter the correct captcha keywords';
        }
        return $errors;
    }


    static function send_message_to_nfp() {
        $errors = array();
        $id = get_request_variable('id_nfp');
        $contact = self::get_contact_for_id($id);
        $copy = get_request_boolean('copy');
        $to = $contact->email;
        $subject = __('Contact request sent from InforMEA portal', 'informea');
        $body = get_request_value('message');
        $cname = get_request_value('cname');
        $email = get_request_value('email');

        $fullbody = $body;
        $fullbody .= "\n\n\n";
        $fullbody .= sprintf(
            __('This email was automatically send by the InforMEA portal (http://www.informea.org) because a person (%s <%s>) requested to contact you via our portal', 'informea'),
            $cname, $email
        );
        $header = sprintf('From: %s <%s>', $cname, $email);
        if (mail($to, $subject, $fullbody, $header)) {
            if($copy) {
                $contact_prefix = $contact->prefix;
                $contact_first_name = $contact->first_name;
                $contact_last_name = $contact->last_name;

                $subject = __("Copy of contact request sent from InforMEA portal", 'informea');
                $fullbody = "This email was automatically sent by the InforMEA portal (http://www.informea.org) because you requested to contact $contact_prefix $contact_first_name $contact_last_name via our portal. \n\n Your message was: $body";
                if (!mail($email, $subject, $fullbody, $header)) {
                    $errors[] = __("Cannot send you the copy of the email.", 'informea');
                }
            }
        } else {
            $errors[] = 'Cannot send e-mail. Please contact informea.org administrators through feedback form and raise this issues';
        }
        return $errors;
    }


    /**
     * Retrieve treaties list by theme based on region
     * @param $region string Region to get treaties from
     * @return array with WP SQL result objects grouped by theme
     */
    function get_treaties_by_region_by_theme($region = '') {
        global $wpdb;
        if (strtolower($region) == 'global') {
            $region = '';
        }
        $data = $wpdb->get_results($wpdb->prepare("SELECT a.*, b.depository AS depository
            FROM ai_treaty a
            INNER JOIN ai_organization b ON a.id_organization = b.id
            WHERE a.enabled = 1 AND a.use_informea=1 AND a.region = %s ORDER BY a.`theme`, a.`order`", $region));
        $ret = array();
        foreach ($data as &$row) {
            if (!isset($ret[$row->theme])) {
                $ret[$row->theme] = array();
            }
            $ret[$row->theme][] = $row;
        }
        return $ret;
    }


    static function get_cloud_terms_for_treaty_page($id, $limit = 20) {
        $ret = array();
        if (!empty($id)) {
            $ret = self::get_popular_terms($id, $limit);
        }
        return $ret;
    }


    function tab_decisions_meeting_title($meeting) {
        return !empty($meeting->abbreviation) ? $meeting->abbreviation : $meeting->title;
    }

    function decisions_with_index_page() {
        global $wpdb;
        return $wpdb->get_col(
            "SELECT DISTINCT(a.id) FROM ai_decision a
                INNER JOIN ai_decision_paragraph b ON a.id = b.id_decision
            UNION
                SELECT id FROM ai_decision
                WHERE (summary IS NOT NULL AND TRIM(summary) <> '') OR (body IS NOT NULL AND TRIM(body) <> '')");
    }

    function page_decisions_overview_decision_link($decision, $treaty) {
        static $ids = NULL;
        if($ids === NULL) {
            $ids = $this->decisions_with_index_page();
        }
        $text = ucwords(strtolower(self::get_title($decision)));
        if(!in_array($decision->id, $ids)) {
            return $text;
        } else {
            $no = $decision->number;
            $url = sprintf('%s/treaties/%s/decisions/%d', get_bloginfo('url'), $treaty->odata_name, $decision->id);
            return sprintf('<a class="title" name="decision-%d" href="%s">%s</a>', $no, $url, $text);
        }
    }

    /**
     * Retrieve featured item "of the day".
     *
     * @param int $interval (Optional) Interval in seconds to preserve featured item. Default 24h (86400 seconds)
     * @param bool $reset (Optional) Force reset the featured item. Default FALSE
     * @return Featured object
     */
    static function get_featured_treaty($interval = 86400,$reset = FALSE) {
        $option = get_option('informea_options');
        $treaty = NULL;
        if (isset($option['featured_treaty'])) {
            $d = $option['featured_treaty_timestamp'];
            if (time() - $d < $interval) {
                $treaty = $option['featured_treaty'];
            }
        }
        if (empty($treaty) || $reset) {
            $treaty = self::get_random_treaty_having_data();
            $option['featured_treaty'] = $treaty;
            $option['featured_treaty_timestamp'] = time();
            update_option('informea_options', $option);
        }
        return $treaty;
    }


    static function get_random_treaty() {
        $ob = new self();
        $treaties = $ob->get_treaties();
        return $treaties[array_rand($treaties)];
    }


    static function get_random_treaty_having_data() {
        global $wpdb;
        return $wpdb->get_row('
            SELECT z.* FROM ai_decision x
                INNER JOIN ai_people_treaty y ON x.id_treaty = y.id_treaty
                INNER JOIN ai_treaty z ON x.id_treaty = z.id
                GROUP BY z.id
                ORDER BY RAND() LIMIT 1'
        );
    }


    static function ui_secondary_theme($treaty) {
        if (!empty($treaty->theme_secondary)) {
            echo sprintf('<div class="clear"></div><span class="theme">(%s)</span>', $treaty->theme_secondary);
        }
    }


    function admin_delete_article() {
        if ($this->get_action() == 'delete_article' && current_user_can('manage_options')) {
            if(!check_admin_referer('treaty_delete_article')) {
                die('Security check');
            }
            $id_article = get_request_int('id_article');
            $this->delete_article($id_article);
            return __('Article has been successfully deleted', 'informea');
        }
        return FALSE;
    }


    function admin_delete_article_paragraph() {
        if ($this->get_action() == 'delete_article_paragraph' && current_user_can('manage_options')) {
            if(!check_admin_referer('treaty_delete_paragraph')) {
                die('Security check');
            }

            $id_paragraph = get_request_int('id_paragraph');
            $this->delete_paragraph($id_paragraph);
            return __('Paragraph has been successfully deleted', 'informea');
        }
        return FALSE;
    }


    static function admin_article_edit_url($article) {
        echo sprintf(
            '%sadmin.php?page=informea_treaties&act=treaty_edit_article&id_treaty=%s&id_treaty_article=%s',
            admin_url(), $article->id_treaty, $article->id);
    }


    static function article_url($treaty, $article) {
        echo sprintf(
            '%s/treaties/%s?id_treaty_article=%s#article_%s',
            get_bloginfo('url'), $treaty->odata_name, $article->id, $article->id);
    }


    static function paragraph_url($treaty, $article, $paragraph) {
        echo sprintf(
            '%s/treaties/%s?id_treaty_article=7#article_7_paragraph_2305',
            get_bloginfo('url'), $treaty->odata_name, $article->id, $article->id, $paragraph->id);
    }


    static function admin_article_add_paragraph_url($article) {
        echo sprintf(
            '%sadmin.php?page=informea_treaties&act=treaty_add_article_paragraph&id_treaty=%s&id_treaty_article=%s',
            admin_url(), $article->id_treaty, $article->id);
    }


    static function admin_paragraph_edit_url($article, $paragraph) {
        echo sprintf(
            '%sadmin.php?page=informea_treaties&act=treaty_edit_article_paragraph&id_treaty=%s&id_treaty_article=%s&id_treaty_article_paragraph=%s',
            admin_url(), $article->id_treaty, $article->id, $paragraph->id);
    }


    static function admin_paragraph_insert_below_url($article, $paragraph) {
        echo sprintf(
            '%sadmin.php?page=informea_treaties&act=treaty_add_article_paragraph&id_treaty=%s&id_treaty_article=%s&order=%s',
            admin_url(), $article->id_treaty, $article->id, ($paragraph->order + 1));
    }


    static function decision_url($treaty, $decision) {
        echo sprintf(
            '%s/treaties/%s/decisions?showall=1#decision-%s',
            get_bloginfo('url'), $treaty->odata_name, $decision->id);
    }

    static function decision_paragraph_url($treaty, $decision, $paragraph) {
        echo self::get_decision_paragraph_url($treaty, $decision, $paragraph);;
    }

    static function get_decision_paragraph_url($treaty, $decision, $paragraph) {
        return sprintf(
            '%s/treaties/%s/decisions/%s#paragraph-%s',
            get_bloginfo('url'), $treaty->odata_name, $decision->id, $paragraph->id);
    }

    static function nfp_vcard_url($nfp) {
        echo sprintf('%s/download?entity=vcard&id=%s', get_bloginfo('url'), $nfp->id);
    }

    static function nfp_contact_url($nfp) {
        echo sprintf('%s/nfp/%s', get_bloginfo('url'), $nfp->id);
    }

}


class informea_decisions extends imea_decisions_page {

    function __construct($arr_parameters = array()) {
        parent::__construct($arr_parameters);
    }


    /**
     * Retrieve the list of treaties
     */
    function get_treaties_list() {
        global $wpdb;
        $ret = array();
        // Get the themes
        $sql = "SELECT DISTINCT a.theme FROM ai_treaty a INNER JOIN ai_decision b ON b.id_treaty = a.id WHERE a.enabled = 1 AND a.use_informea=1 ORDER BY a.theme";
        $rows = $wpdb->get_results($sql);
        foreach ($rows as $row) {
            $ret[$row->theme] = array();
        }

        $sql = "SELECT a.*, a.logo_medium, a.theme FROM ai_treaty a INNER JOIN ai_decision c ON c.id_treaty = a.id WHERE enabled = 1 AND use_informea=1 GROUP BY a.id ORDER BY a.order";
        $rows = $wpdb->get_results($sql);
        foreach ($rows as $row) {
            $ret[$row->theme][] = $row;
        }
        return $ret;
    }

    function get_paragraph_tags($id_paragraph) {
        global $wpdb;
        return $wpdb->get_results($wpdb->prepare('SELECT b.* FROM ai_decision_paragraph_vocabulary a INNER JOIN voc_concept b ON a.id_concept = b.id WHERE a.id_decision_paragraph=%d', $id_paragraph));
    }


    static function tag_decision_paragraphs_url($treaty, $decision) {
        echo sprintf('%s/admin.php?page=informea_decisions&act=decision_edit_decision&id_treaty=%s&id_decision=%s',
            admin_url(), $treaty->id, $decision->id);
    }

    static function edit_decision_url($treaty, $decision) {
        echo sprintf('%s/admin.php?page=informea_decisions&act=decision_edit&id_treaty=%s&id_decision=%s',
            admin_url(), $treaty->id, $decision->id);
    }


    static function page_decision_index_decision_content($decision) {
        $paragraphs = self::get_paragraphs($decision->id);
        if(count($paragraphs)):
?>
            <ul class="paragraphs">
                <?php foreach ($paragraphs as $paragraph) :
                    $tags = self::get_decision_paragraph_tags($paragraph->id);
                    ?>
                    <li data-id="<?php echo $paragraph->id; ?>"<?php echo count($tags) ? ' class="smallipop"': ''; ?>>
                        <a name="paragraph-<?php echo $paragraph->id; ?>"></a>
                        <span class="gray">[&hellip;]</span> <?php echo $paragraph->content; ?> <span class="gray">[&hellip;]</span>

	                    <?php if(count($tags)): ?>
                        <span class="smallipop-hint">
	                        <?php foreach($tags as $tag): ?>
	                            <a href="<?php echo sprintf('%s/terms/%s', get_bloginfo('url'), $tag->id); ?>"><?php echo $tag->term;?></a>
		                        <br />
			                <?php endforeach; ?>
                        </span>
	                    <?php endif; ?>
                    </li>
                <?php endforeach; ?>
            </ul>
<?php
        elseif(!empty($decision->body)):
                echo $decision->body;
            elseif (!empty($decision->summary)):
                echo '<strong>Summary</strong>:<br />' . $decision->summary;
            endif;
    }
}


class informea_countries extends imea_countries_page {

    function __construct($id_country = NULL, $arr_parameters = array()) {
        parent::__construct($id_country, $arr_parameters);
    }


    static function get_id_from_request() {
        $id = get_request_variable('id');
        if(!is_numeric($id)) {
            $country = self::get_country_by_iso($id);
            $id = $country->id;
        }
        return $id;
    }


    static function get_treaties_with_membership() {
        global $wpdb;
        return $wpdb->get_results('SELECT b.* FROM ai_treaty_country a
				INNER JOIN ai_treaty b ON b.`id` = a.`id_treaty` WHERE b.use_informea=1
				GROUP BY b.`id` ORDER BY b.`short_title`');
    }


    /**
     * Access ai_country
     * @return Rows from the table
     */
    function _get_country() {
        global $wpdb;
        $sql = $wpdb->prepare("SELECT * FROM ai_country WHERE id = '%s'", $this->id_country);
        $this->country = $wpdb->get_row($sql);
        if ($this->country) {

            $sql = $wpdb->prepare('SELECT a.*, b.year FROM ai_treaty a
									JOIN ai_treaty_country b ON b.id_treaty = a.id
									WHERE a.enabled = TRUE AND b.id_country = %d AND a.use_informea=1 ORDER BY a.short_title', $this->id_country);
            $this->mea_membership = $wpdb->get_results($sql);
        }
    }


    /**
     * Retrieve the list of national focal points grouped by treaty
     * @param integer $id_country Country ID. If NULL, internal ID is used
     * @return array Array of treaty objects having set property focal_points as array of National Focal Points.
     * @global $wpdb WordPress database
     */
    static function get_focal_points_by_treaty($id_country = NULL) {
        global $wpdb;
        $treaties = $wpdb->get_results(
            $wpdb->prepare(
                'SELECT * FROM ai_treaty WHERE use_informea=1 AND id IN (SELECT DISTINCT(id_treaty) FROM view_people_treaty WHERE id_country=%d GROUP BY id_treaty)', $id_country
            ), OBJECT_K
        );
        $rows = $wpdb->get_results(
            $wpdb->prepare('SELECT * FROM view_people_treaty WHERE id_country=%d ORDER BY country_name, first_name, last_name', $id_country)
        );
        foreach ($rows as $row) {
            $treaty = $treaties[$row->id_treaty];
            if (!isset($treaty->focal_points)) {
                $treaty->focal_points = array();
            }
            $treaty->focal_points[] = $row;
        }
        return $treaties;
    }

    static function get_focal_point_position($nfp, $prefix = '(', $suffix = ')') {
        if(!empty($nfp->position)) {
            return sprintf('%s%s%s', $prefix, $nfp->position, $suffix);
        } else if(!empty($nfp->institution)) {
            return sprintf('%s%s%s', $prefix, $nfp->institution, $suffix);
        } else  if(!empty($nfp->department)) {
            return sprintf('%s%s%s', $prefix, $nfp->department, $suffix);
        }
        return FALSE;
    }

    static function get_focal_point_name($nfp) {
        $ret = '';
        if(!empty($nfp->prefix)) {
            $ret .= $nfp->prefix . ' ';
        }
        if(!empty($nfp->first_name)) {
            $ret .= $nfp->first_name . ' ';
        }
        if(!empty($nfp->last_name)) {
            $ret .= $nfp->last_name;
        }

        return $ret;
    }


    static function get_focal_point_treaties($nfp) {
        global $wpdb;
        return $wpdb->get_results(
            $wpdb->prepare(
                'SELECT a.* FROM ai_treaty a INNER JOIN ai_people_treaty b ON a.id = b.id_treaty WHERE b.id_people=%s',
                $nfp->id
            )
        );
    }

    /**
     * Retrieve national reports for a country, group by treaty
     *
     * @param integer $id_country Country ID
     * @return array Array of treaties having property national_reports array with ai_country_report objects
     */
    static function get_national_reports($id_country = NULL) {
        global $wpdb;
        $treaties = $wpdb->get_results(
            $wpdb->prepare("SELECT b.* FROM ai_country_report a INNER JOIN ai_treaty b ON a.id_treaty = b.id WHERE b.enabled = TRUE AND b.use_informea=1 AND a.id_country=%d GROUP BY b.id", $id_country)
            , OBJECT_K
        );
        $rows = $wpdb->get_results(
            $wpdb->prepare("SELECT a.*, b.title AS meeting_title FROM ai_country_report a LEFT JOIN ai_event b ON a.id_event = b.id WHERE a.id_country=%d ORDER BY a.submission DESC", $id_country)
        );
        foreach ($rows as $row) {
            $treaty = $treaties[$row->id_treaty];
            if (!isset($treaty->national_reports)) {
                $treaty->national_reports = array();
            }
            $treaty->national_reports[] = $row;
        }
        return $treaties;
    }


    /**
     * Retrieve national plans for a country, group by treaty
     *
     * @param integer $id_country Country ID
     * @return array Array of treaties having property national_plans array with ai_country_plan objects
     */
    static function get_national_plans($id_country = NULL) {
        global $wpdb;
        $treaties = $wpdb->get_results(
            $wpdb->prepare("SELECT b.* FROM ai_country_plan a INNER JOIN ai_treaty b ON a.id_treaty = b.id WHERE b.enabled = TRUE AND b.use_informea=1 AND a.id_country=%d GROUP BY b.id", $id_country)
            , OBJECT_K
        );

        $rows = $wpdb->get_results(
            $wpdb->prepare("SELECT a.*, b.title AS meeting_title FROM ai_country_plan a LEFT JOIN ai_event b ON a.id_event = b.id WHERE a.id_country=%d ORDER BY a.submission DESC", $id_country)
        );
        foreach ($rows as $row) {
            $treaty = $treaties[$row->id_treaty];
            if (!isset($treaty->national_plans)) {
                $treaty->national_plans = array();
            }
            $treaty->national_plans[] = $row;
        }
        return $treaties;
    }


    static function generate_parties_download_csv() {
        $language = get_request_value('lang', 'en');
        $split = ('en' == $language) ? ',' : ';';
        $newline = "\r\n";
        $page_data = new imea_countries_page(null);
        $data = $page_data->index_grid();
        $columns = $data['column'];
        $countries = $data['countries'];
        $signatures = $data['signatures'];
        $line = 'Country';
        foreach ($columns as $column) {
            $line .= $split . $column->short_title;
        }
        $line .= $newline;
        echo ($line);
        foreach ($countries as $country) {
            $line = $country->name;
            foreach ($columns as $column) {
                $id_treaty = $column->id;
                $id_country = $country->id;
                $coldata = '';
                if (isset($signatures[$id_treaty])) {
                    $tmparr = $signatures[$id_treaty];
                    if (isset($tmparr[$id_country])) {
                        $coldata = $tmparr[$id_country];
                    }
                }
                $line .= $split . $coldata;
            }
            $line .= $newline;
            echo ($line);
        }
    }
}


class informea_meetings extends imea_meetings_page {

    public static function get_event_types() {
        return array(
            '' => '-- All --',
            'cop' => 'COP/MOP',
            'conference' => 'Conference',
            'working' => 'Working',
            'workshop' => 'Workshop',
            'symposia' => 'Symposia',
            'expert' => 'Expert',
            'subsidiary' => 'Subsidiary'
        );
    }

    public static function ajax_get_event_list() {
        $rows = self::get_event_list();
        header('Content-Type:application/json');
        echo json_encode($rows);
        die();
    }


    public static function ajax_get_event_list_html() {
        $rows = self::get_event_list();
        $ret = '';
        header('Content-Type:text/html');
        foreach($rows as $row) {
            $ret .= self::event_to_html($row) . "\n";
        }
        echo $ret;
        die();
    }


    public static function event_to_html($e, $fe_type = NULL) {
        $cop_class = (($e->type == 'cop' || $e->type == 'mop') && $fe_type != 'cop') ? ' cop' : '';
    ?>
            <li>
                <div class="date">
                    <div class="month"><?php echo format_mysql_date($e->start, 'M'); ?></div>
                    <div class="day"><?php echo format_mysql_date($e->start, 'j'); ?></div>
                    <div class="year"><?php echo format_mysql_date($e->start, 'Y'); ?></div>
                </div>
                <div class="description<?php echo $cop_class; ?>">
                    <h3><?php echo $e->title; ?></h3>
                    <div class="clear"></div>
                    <ul class="info">
                        <li>
                            <a href="<?php echo self::url_treaty_filter($e->id_treaty); ?>" title="See all <?php echo $e->treaty; ?> meetings for this year"><?php echo $e->treaty; ?></a>
                        </li>
                        <?php if(!empty($e->event_url)) : ?>
                        <li>
                            <div class="info"><a target="_blank" href="<?php echo $e->event_url;?>">View info</a></div>
                        </li>
                        <?php endif; ?>

                        <?php if(!empty($e->type)) : ?>
                        <li>
                            <div class="info"><span class="type"><?php echo ucfirst($e->type); ?></div>
                        </li>
                        <?php endif; ?>
                        <?php if(!empty($e->kind)) : ?>
                        <li>
                            <div class="info"><?php imea_meetings_page::decode_kind($e); ?></div>
                        </li>
                        <?php endif; ?>
                    </ul>
                </div>
                <div class="clear"></div>
            </li>
    <?php
    }

    public static function url_treaty_filter($id_treaty) {
        $page_size = get_request_int('fe_page_size', 50);
        $fe_type = get_request_value('fe_type');
        $year = get_request_int('fe_year');
        $id_country = get_request_int('fe_country');
        $page = get_request_variable('fe_page', 0, 0);
        $show_past = get_request_int('fe_show_past');

        return sprintf(
            '%s/meetings?fe_treaty=%s&fe_type=%s&fe_year=%s&fe_country=%s&fe_page_size=%s&fe_show_past=%s&page=%s',
            get_bloginfo('url'), $id_treaty, $fe_type, $year, $id_country, $page_size, $show_past, ($page+1)
        );
    }


    /**
     * Count total number of meetings
     * @return integer Number of meetings matching filter criteria
     */
    public static function count_event_list() {
        global $wpdb;
        return $wpdb->get_var('SELECT COUNT(*) ' . self::get_sql_where_event_list());
    }


    /**
     * Meetings page filtering
     * @param $default_page_size integer (Optional) page size. Default 10.
     * @return array List of meetings
     */
    public static function get_event_list($default_page_size = 10) {
        global $wpdb;
        $page = get_request_variable('fe_page', 0, 0);
        $page_size = get_request_int('fe_page_size', $default_page_size);

        $sql = '
            SELECT a.id, a.event_url, a.title, a.abbreviation, a.description, a.start, a.location, a.city, a.type, a.id_treaty,
                b.short_title AS treaty ';
        $sql .= self::get_sql_where_event_list();

        $start = $page + ($page * $page_size);
        $end =  $page_size;
        $sql .= sprintf(' ORDER BY a.start DESC LIMIT %s, %s', $start, $end);
        return $wpdb->get_results($sql);
    }


    private static function get_sql_where_event_list() {
        global $wpdb;

        $id_treaty = get_request_int('fe_treaty');
        $type = get_request_value('fe_type');
        $fe_year = get_request_int('fe_year');
        if($fe_year == 0) {
            $fe_year = strftime('%Y');
        } // Show only current year
        $show_past = get_request_int('fe_show_past');

        $sql = ' FROM ai_event a
                     INNER JOIN ai_treaty b ON a.id_treaty = b.id
                WHERE a.use_informea = 1 ';
        if(!empty($id_treaty)) {
            $sql .= $wpdb->prepare(' AND b.id = %d', $id_treaty);
        }
        if(!empty($type)) {
            $sql .= $wpdb->prepare(' AND a.type = %s', $type);
        }
        if($fe_year > 0) {
            $sql .= $wpdb->prepare(' AND YEAR(a.start) = %d', $fe_year);
        }
        if(!$show_past) {
            $sql .= $wpdb->prepare(' AND a.start > NOW()');
        }
        return $sql;
    }


    /**
     * Retrieve the list of conventions that have meetings
     * @return array of ai_treaty
     */
    public static function get_treaties() {
        global $wpdb;
        $sql = "SELECT a.* FROM ai_treaty a
            INNER JOIN ai_event b ON b.id_treaty = a.id
            WHERE (a.enabled=1 AND a.use_informea=1) OR odata_name='unep' GROUP BY a.id ORDER BY a.short_title
        ";
        $rows = $wpdb->get_results($sql);
        $ret = array();
        foreach ($rows as $row) {
            $ret[$row->id] = $row;
        }
        return $ret;
    }

    static function get_meetings_current_week() {
        global $wpdb;
        return $wpdb->get_results("SELECT b.*, a.logo_medium, a.odata_name FROM ai_treaty a INNER JOIN ai_event b ON a.id = b.id_treaty WHERE a.enabled = 1 AND a.use_informea = 1 AND b.start > NOW() LIMIT 5");
    }


    static function get_meetings_all() {
        global $wpdb;
        return $wpdb->get_results('SELECT * FROM ai_event ORDER BY `start` DESC');
    }


    /**
     * Retreive the meetings to generate the RSS feed
     * @return array stdClass ai_event rows
     */
    static function get_meetings_rss() {
        global $wpdb;
        return $wpdb->get_results('SELECT * FROM ai_event WHERE `start` >= DATE_SUB(NOW(), INTERVAL 1 YEAR) ORDER BY `start` DESC');
    }
}



class imea_index_page extends imea_page_base_page {

    /**
     * @deprecated in theme informea2
     */
    static function get_slider_news() {
        global $wpdb;
        global $post;
        $ret = array();

        $pictures = $wpdb->get_results('SELECT * FROM imea_pictures WHERE is_slider = 1 ORDER BY rand() ');
        $c = count($pictures);

        $wpq = new WP_Query(array('post_date' => 'DATE(NOW())', 'post_type' => 'post', 'orderby' => 'post_date',
            'posts_per_page' => $c, 'order' => 'DESC'));
        $posts = array();
        while ($wpq->have_posts()) {
            $wpq->the_post();
            $posts[] = $post;
        }

        for ($i = 0; $i < $c; $i++) {
            $pic = $pictures[$i];
            $ob = new StdClass();
            $ob->image_url = get_bloginfo('url') . '/wp-content/uploads/pictures/slide_images/' . $pic->filename;
            $ob->image_copyright = $pic->copyright;
            $ob->image_title = $pic->title;
            $ob->has_content = FALSE;
            if (isset($posts[$i])) {
                $ob->has_content = TRUE;
                $post = $posts[$i];
                $ob->title = subwords($post->post_title, 15);
                $ob->date = mysql2date('j F, Y', $post->post_date);
                $ob->url = get_permalink($post->ID);
            }
            $ret[] = $ob;
        }
        return $ret;
    }


    static function get_latest_changelog_entry() {
        $cat = get_category_by_slug('changelog');
        $posts = query_posts("showposts=1&orderby=date&order=DESC&cat={$cat->cat_ID}");
        if(count($posts) > 0) {

            return $posts[0];
        }
        return FALSE;
    }
}