+global\MEMBER::load_extra_info()

Complexity

Conditions	25
Paths	10754

Size

Total Lines	115
Code Lines	74

Duplication

Lines	13
Ratio	11.3 %

Code Coverage

Tests	56
CRAP Score	56.8639

Importance

Changes

0

<?php
    public function load_extra_info($display = false, $force = false) {
        $memcache = new MySociety\TheyWorkForYou\Memcache;
        $memcache_key = 'extra_info:' . $this->person_id . ($display ? '' : ':plain');
        $this->extra_info = $memcache->get($memcache_key);
        if (!DEVSITE && !$force && $this->extra_info) {

The constant DEVSITE was not found. Maybe you did not declare it correctly or list all dependencies?

            return;
        }
        $this->extra_info = array();

        $q = $this->db->query('SELECT * FROM moffice WHERE person=:person_id ORDER BY from_date DESC, moffice_id',
                              array(':person_id' => $this->person_id));
        for ($row=0; $row<$q->rows(); $row++) {
            $this->extra_info['office'][] = $q->row($row);
        }

        // Info specific to member id (e.g. attendance during that period of office)
        $q = $this->db->query("SELECT data_key, data_value
                        FROM 	memberinfo
                        WHERE	member_id = :member_id",
            array(':member_id' => $this->member_id));
        for ($row = 0; $row < $q->rows(); $row++) {
            $this->extra_info[$q->field($row, 'data_key')] = $q->field($row, 'data_value');
            #		if ($q->field($row, 'joint') > 1)

62% of this comment could be valid code. Did you maybe forget this after debugging?

            #			$this->extra_info[$q->field($row, 'data_key').'_joint'] = true;

64% of this comment could be valid code. Did you maybe forget this after debugging?

        }

        // Info specific to person id (e.g. their permanent page on the Guardian website)
        $q = $this->db->query("SELECT data_key, data_value
                        FROM 	personinfo
                        WHERE	person_id = :person_id",
            array(':person_id' => $this->person_id));
        for ($row = 0; $row < $q->rows(); $row++) {
            $this->extra_info[$q->field($row, 'data_key')] = $q->field($row, 'data_value');
        #	    if ($q->field($row, 'count') > 1)

62% of this comment could be valid code. Did you maybe forget this after debugging?

        #	    	$this->extra_info[$q->field($row, 'data_key').'_joint'] = true;

64% of this comment could be valid code. Did you maybe forget this after debugging?

        }

        // Info specific to constituency (e.g. election results page on Guardian website)
        if ($this->house(HOUSE_TYPE_COMMONS)) {

            $q = $this->db->query("SELECT data_key, data_value FROM consinfo
            WHERE constituency = :constituency",
                array(':constituency' => $this->constituency));
            for ($row = 0; $row < $q->rows(); $row++) {
                $this->extra_info[$q->field($row, 'data_key')] = $q->field($row, 'data_value');
            }
        }

        if (array_key_exists('public_whip_rebellions', $this->extra_info)) {
            $rebellions = $this->extra_info['public_whip_rebellions'];
            $rebel_desc = "<unknown>";
            if ($rebellions == 0)
                $rebel_desc = "never";
            elseif ($rebellions <= 1)
                $rebel_desc = "hardly ever";
            elseif ($rebellions <= 3)
                $rebel_desc = "occasionally";
            elseif ($rebellions <= 5)
                $rebel_desc = "sometimes";
            elseif ($rebellions > 5)
                $rebel_desc = "quite often";
            $this->extra_info['public_whip_rebel_description'] = $rebel_desc;
        }

        if (isset($this->extra_info['public_whip_attendrank'])) {
            $prefix = ($this->house(HOUSE_TYPE_LORDS) ? 'L' : '');
            $this->extra_info[$prefix.'public_whip_division_attendance_rank'] = $this->extra_info['public_whip_attendrank'];
            $this->extra_info[$prefix.'public_whip_division_attendance_rank_outof'] = $this->extra_info['public_whip_attendrank_outof'];
            $this->extra_info[$prefix.'public_whip_division_attendance_quintile'] = floor($this->extra_info['public_whip_attendrank'] / ($this->extra_info['public_whip_attendrank_outof']+1) * 5);
        }
        if ($this->house(HOUSE_TYPE_LORDS) && isset($this->extra_info['public_whip_division_attendance'])) {
            $this->extra_info['Lpublic_whip_division_attendance'] = $this->extra_info['public_whip_division_attendance'];
            unset($this->extra_info['public_whip_division_attendance']);
        }

        if ($display && array_key_exists('register_member_interests_html', $this->extra_info) && ($this->extra_info['register_member_interests_html'] != '')) {
            $args = array (
                "sort" => "regexp_replace"
            );
            $GLOSSARY = new GLOSSARY($args);
            $this->extra_info['register_member_interests_html'] =
        $GLOSSARY->glossarise($this->extra_info['register_member_interests_html']);
        }

        $q = $this->db->query('select count(*) as c from alerts where criteria like "%speaker:'.$this->person_id.'%" and confirmed and not deleted');
        $this->extra_info['number_of_alerts'] = $q->field(0, 'c');

        if (isset($this->extra_info['reading_ease'])) {
            $this->extra_info['reading_ease'] = round($this->extra_info['reading_ease'], 2);
            $this->extra_info['reading_year'] = round($this->extra_info['reading_year'], 0);
            $this->extra_info['reading_age'] = $this->extra_info['reading_year'] + 4;
            $this->extra_info['reading_age'] .= '&ndash;' . ($this->extra_info['reading_year'] + 5);
        }

        # Public Bill Committees
        $q = $this->db->query('select bill_id,session,title,sum(attending) as a,sum(chairman) as c
            from pbc_members, bills
            where bill_id = bills.id and person_id = ' . $this->person_id()
             . ' group by bill_id order by session desc');
        $this->extra_info['pbc'] = array();
        for ($i=0; $i<$q->rows(); $i++) {
            $bill_id = $q->field($i, 'bill_id');
            $c = $this->db->query('select count(*) as c from hansard where major=6 and minor='.$bill_id.' and htype=10');
            $c = $c->field(0, 'c');
            $title = $q->field($i, 'title');
            $attending = $q->field($i, 'a');
            $chairman = $q->field($i, 'c');
            $this->extra_info['pbc'][$bill_id] = array(
                'title' => $title, 'session' => $q->field($i, 'session'),
                'attending'=>$attending, 'chairman'=>($chairman>0), 'outof' => $c
            );
        }

        $memcache->set($memcache_key, $this->extra_info);
    }