MySociety\TheyWorkForYou\Utility\Constituencies

Complexity

Total Complexity

3

Size/Duplication

Total Lines	35
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Test Coverage

Coverage

61.53%

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	normaliseConstituencyName()	0	21	3

<?php

namespace MySociety\TheyWorkForYou\Utility;

/**
 * Constituency Utilities
 *
 * Utility functions for dealing with constituency names
 */

class Constituencies
{

    /**
     * Normalise Constituency Name
     *
     * Turn variations on a constituency name into the canonical version.
     *
     * @param $names string A constituency name to normalise.
     *
     * @return string|bool The normalised constituency name, or false if no match.
     */
    public static function normaliseConstituencyName($name) {

        $db = new \ParlDB;

        // In case we still have an &amp; lying around
        $name = str_replace("&amp;", "&", $name);

        $query = "select cons_id from constituency where name like :name and from_date <= date(now()) and date(now()) <= to_date";
        $q1 = $db->query($query, array(
            ':name' => $name
            ));
        if ($q1->rows <= 0)
            return false;

        $query = "select name from constituency where main_name and cons_id = '".$q1->field(0,'cons_id')."'";
        $q2 = $db->query($query);
        if ($q2->rows <= 0)
            return false;

        return $q2->field(0, "name");
    }

}