@@ -2,12 +2,12 @@ discard block |
||
| 2 | 2 | |
| 3 | 3 | $this_page = 'hansard_bugs'; |
| 4 | 4 | include_once '../../includes/easyparliament/init.php'; |
| 5 | -$DATA->set_page_metadata($this_page, 'heading','Official Hansard problems'); |
|
| 5 | +$DATA->set_page_metadata($this_page, 'heading', 'Official Hansard problems'); |
|
| 6 | 6 | |
| 7 | 7 | $PAGE->page_start(); |
| 8 | 8 | $PAGE->stripe_start(); |
| 9 | 9 | |
| 10 | -$PAGE->block_start(array ('title'=>'Things currently noticeable to the user')); |
|
| 10 | +$PAGE->block_start(array('title'=>'Things currently noticeable to the user')); |
|
| 11 | 11 | ?> |
| 12 | 12 | |
| 13 | 13 | <style type="text/css"> |
@@ -110,7 +110,7 @@ discard block |
||
| 110 | 110 | |
| 111 | 111 | <?php |
| 112 | 112 | $PAGE->block_end(); |
| 113 | -$PAGE->block_start(array ('title'=>'Things not noticeable to the user')); |
|
| 113 | +$PAGE->block_start(array('title'=>'Things not noticeable to the user')); |
|
| 114 | 114 | ?> |
| 115 | 115 | |
| 116 | 116 | <ul> |
@@ -33,8 +33,9 @@ |
||
| 33 | 33 | if (isset($arr[3])) { |
| 34 | 34 | print '<a href="'.$link.'/questions">Written Questions</a>'; |
| 35 | 35 | } |
| 36 | - if (count($arr)==2) |
|
| 37 | - print ' | '; |
|
| 36 | + if (count($arr)==2) { |
|
| 37 | + print ' | '; |
|
| 38 | + } |
|
| 38 | 39 | if (isset($arr[4])) { |
| 39 | 40 | print '<a href="'.$link.'/statements">Written Ministerial Statements</a>'; |
| 40 | 41 | } |
@@ -16,7 +16,7 @@ discard block |
||
| 16 | 16 | group by body, major |
| 17 | 17 | order by body'); |
| 18 | 18 | $data = array(); |
| 19 | -for ($i=0; $i<$q->rows(); $i++) { |
|
| 19 | +for ($i = 0; $i < $q->rows(); $i++) { |
|
| 20 | 20 | $body = $q->field($i, 'body'); |
| 21 | 21 | $major = $q->field($i, 'major'); |
| 22 | 22 | $data[$body][$major] = true; |
@@ -26,17 +26,17 @@ discard block |
||
| 26 | 26 | |
| 27 | 27 | print '<ul>'; |
| 28 | 28 | foreach ($data as $body => $arr) { |
| 29 | - $link = strtolower(str_replace(' ','_',$body)); |
|
| 29 | + $link = strtolower(str_replace(' ', '_', $body)); |
|
| 30 | 30 | print '<li>'; |
| 31 | 31 | print $body; |
| 32 | 32 | print ' — '; |
| 33 | 33 | if (isset($arr[3])) { |
| 34 | - print '<a href="'.$link.'/questions">Written Questions</a>'; |
|
| 34 | + print '<a href="' . $link . '/questions">Written Questions</a>'; |
|
| 35 | 35 | } |
| 36 | - if (count($arr)==2) |
|
| 36 | + if (count($arr) == 2) |
|
| 37 | 37 | print ' | '; |
| 38 | 38 | if (isset($arr[4])) { |
| 39 | - print '<a href="'.$link.'/statements">Written Ministerial Statements</a>'; |
|
| 39 | + print '<a href="' . $link . '/statements">Written Ministerial Statements</a>'; |
|
| 40 | 40 | } |
| 41 | 41 | print '</li>'; |
| 42 | 42 | } |
@@ -17,7 +17,9 @@ discard block |
||
| 17 | 17 | $adate = $q->field(0, 'adate'); |
| 18 | 18 | $atime = $q->field(0, 'atime'); |
| 19 | 19 | $video = \MySociety\TheyWorkForYou\Utility\Video::fromTimestamp($videodb, $adate, $atime); |
| 20 | -if (!$video) exit; |
|
| 20 | +if (!$video) { |
|
| 21 | + exit; |
|
| 22 | +} |
|
| 21 | 23 | |
| 22 | 24 | $start = date('H:i:s', strtotime($video['broadcast_start']. ' GMT')); |
| 23 | 25 | $end = date('H:i:s', strtotime($video['broadcast_end'] . ' GMT')); |
@@ -35,7 +37,9 @@ discard block |
||
| 35 | 37 | print '<stamps>'; |
| 36 | 38 | for ($i=0; $i<$q->rows(); $i++) { |
| 37 | 39 | $gid = str_replace('uk.org.publicwhip/', '', $q->field($i, 'gid')); |
| 38 | - if (isset($gids[$gid])) continue; |
|
| 40 | + if (isset($gids[$gid])) { |
|
| 41 | + continue; |
|
| 42 | + } |
|
| 39 | 43 | $timetoend = $q->field($i, 'timetoend') - $file_offset; |
| 40 | 44 | if ($timetoend>0) { |
| 41 | 45 | $video = \MySociety\TheyWorkForYou\Utility\Video::fromTimestamp($videodb, $q->field($i, 'adate'), $q->field($i, 'atime')); |
@@ -45,8 +49,9 @@ discard block |
||
| 45 | 49 | $end = date('H:i:s', strtotime($video['broadcast_end'] . ' GMT')); |
| 46 | 50 | } |
| 47 | 51 | $timediff = $q->field($i, 'timediff') - $file_offset; |
| 48 | - if ($timediff>=0) |
|
| 49 | - print "<stamp><gid>$gid</gid><file>$video[id]</file><time>$timediff</time></stamp>\n"; |
|
| 52 | + if ($timediff>=0) { |
|
| 53 | + print "<stamp><gid>$gid</gid><file>$video[id]</file><time>$timediff</time></stamp>\n"; |
|
| 54 | + } |
|
| 50 | 55 | $gids[$gid] = true; |
| 51 | 56 | } |
| 52 | 57 | print '</stamps>'; |
@@ -19,7 +19,7 @@ discard block |
||
| 19 | 19 | $video = \MySociety\TheyWorkForYou\Utility\Video::fromTimestamp($videodb, $adate, $atime); |
| 20 | 20 | if (!$video) exit; |
| 21 | 21 | |
| 22 | -$start = date('H:i:s', strtotime($video['broadcast_start']. ' GMT')); |
|
| 22 | +$start = date('H:i:s', strtotime($video['broadcast_start'] . ' GMT')); |
|
| 23 | 23 | $end = date('H:i:s', strtotime($video['broadcast_end'] . ' GMT')); |
| 24 | 24 | |
| 25 | 25 | $q = $db->query("select video_timestamps.gid, adate, atime, time_to_sec(timediff(atime, '$start')) as timediff, |
@@ -33,26 +33,26 @@ discard block |
||
| 33 | 33 | $gids = array(); |
| 34 | 34 | $file_offset = 0; |
| 35 | 35 | print '<stamps>'; |
| 36 | -for ($i=0; $i<$q->rows(); $i++) { |
|
| 36 | +for ($i = 0; $i < $q->rows(); $i++) { |
|
| 37 | 37 | $gid = str_replace('uk.org.publicwhip/', '', $q->field($i, 'gid')); |
| 38 | 38 | if (isset($gids[$gid])) continue; |
| 39 | 39 | $timetoend = $q->field($i, 'timetoend') - $file_offset; |
| 40 | - if ($timetoend>0) { |
|
| 40 | + if ($timetoend > 0) { |
|
| 41 | 41 | $video = \MySociety\TheyWorkForYou\Utility\Video::fromTimestamp($videodb, $q->field($i, 'adate'), $q->field($i, 'atime')); |
| 42 | - $new_start = date('H:i:s', strtotime($video['broadcast_start']. ' GMT')); |
|
| 42 | + $new_start = date('H:i:s', strtotime($video['broadcast_start'] . ' GMT')); |
|
| 43 | 43 | $file_offset += timediff($new_start, $start); |
| 44 | 44 | $start = $new_start; |
| 45 | 45 | $end = date('H:i:s', strtotime($video['broadcast_end'] . ' GMT')); |
| 46 | 46 | } |
| 47 | 47 | $timediff = $q->field($i, 'timediff') - $file_offset; |
| 48 | - if ($timediff>=0) |
|
| 48 | + if ($timediff >= 0) |
|
| 49 | 49 | print "<stamp><gid>$gid</gid><file>$video[id]</file><time>$timediff</time></stamp>\n"; |
| 50 | 50 | $gids[$gid] = true; |
| 51 | 51 | } |
| 52 | 52 | print '</stamps>'; |
| 53 | 53 | |
| 54 | 54 | function timediff($a, $b) { |
| 55 | - return substr($a, 0, 2)*3600 + substr($a, 3, 2)*60 + substr($a, 6, 2) |
|
| 56 | - - substr($b, 0, 2)*3600 - substr($b, 3, 2)*60 - substr($b, 6, 2); |
|
| 55 | + return substr($a, 0, 2) * 3600 + substr($a, 3, 2) * 60 + substr($a, 6, 2) |
|
| 56 | + - substr($b, 0, 2) * 3600 - substr($b, 3, 2) * 60 - substr($b, 6, 2); |
|
| 57 | 57 | |
| 58 | 58 | } |
@@ -5,7 +5,9 @@ discard block |
||
| 5 | 5 | $gid = get_http_var('gid'); |
| 6 | 6 | $oops = get_http_var('oops'); |
| 7 | 7 | |
| 8 | -if (!$oops || !$gid) exit; |
|
| 8 | +if (!$oops || !$gid) { |
|
| 9 | + exit; |
|
| 10 | +} |
|
| 9 | 11 | |
| 10 | 12 | $gid = "uk.org.publicwhip/$gid"; |
| 11 | 13 | |
@@ -16,7 +18,8 @@ discard block |
||
| 16 | 18 | |
| 17 | 19 | $db = new ParlDB; |
| 18 | 20 | $q = $db->query("update video_timestamps set deleted=1 where id = :oops and gid = :gid and current_timestamp<whenstamped+interval 30 second", $params); |
| 19 | -if ($q->affected_rows()) |
|
| 21 | +if ($q->affected_rows()) { |
|
| 20 | 22 | $db->query("update hansard set video_status = video_status & 11 where gid = :gid", $params); |
| 23 | +} |
|
| 21 | 24 | |
| 22 | 25 | print "<status>OK</status>"; |
@@ -18,11 +18,16 @@ |
||
| 18 | 18 | $htime = $q->field(0, 'htime'); |
| 19 | 19 | $atime = $q->field(0, 'atime'); |
| 20 | 20 | $adate = $q->field(0, 'adate'); |
| 21 | -if ($atime) $htime = $atime; |
|
| 22 | -if ($adate) $hdate = $adate; |
|
| 21 | +if ($atime) { |
|
| 22 | + $htime = $atime; |
|
| 23 | +} |
|
| 24 | +if ($adate) { |
|
| 25 | + $hdate = $adate; |
|
| 26 | +} |
|
| 23 | 27 | |
| 24 | -if (!$hdate || !$htime || !$time) |
|
| 28 | +if (!$hdate || !$htime || !$time) { |
|
| 25 | 29 | exit; |
| 30 | +} |
|
| 26 | 31 | |
| 27 | 32 | $videodb = \MySociety\TheyWorkForYou\Utility\Video::dbConnect(); |
| 28 | 33 | if (!$file) { |
@@ -5,7 +5,9 @@ |
||
| 5 | 5 | $action = get_http_var('action'); |
| 6 | 6 | $pid = intval(get_http_var('pid')); |
| 7 | 7 | $major = intval(get_http_var('major')); |
| 8 | -if (!$major) $major = 1; |
|
| 8 | +if (!$major) { |
|
| 9 | + $major = 1; |
|
| 10 | +} |
|
| 9 | 11 | |
| 10 | 12 | if ($action == 'next' || $action=='nextneeded') { |
| 11 | 13 | $gid = get_http_var('gid'); |
@@ -7,7 +7,7 @@ discard block |
||
| 7 | 7 | $major = intval(get_http_var('major')); |
| 8 | 8 | if (!$major) $major = 1; |
| 9 | 9 | |
| 10 | -if ($action == 'next' || $action=='nextneeded') { |
|
| 10 | +if ($action == 'next' || $action == 'nextneeded') { |
|
| 11 | 11 | $gid = get_http_var('gid'); |
| 12 | 12 | $file = intval(get_http_var('file')); |
| 13 | 13 | $time = intval(get_http_var('time')); |
@@ -27,7 +27,7 @@ discard block |
||
| 27 | 27 | $q = $db->query("select gid, hpos from hansard |
| 28 | 28 | where hpos>$hpos and hdate='$hdate' and major=$major |
| 29 | 29 | and (htype=12 or htype=13) " |
| 30 | - . ($action=='nextneeded'?'and video_status in (1,3)':'') . " |
|
| 30 | + . ($action == 'nextneeded' ? 'and video_status in (1,3)' : '') . " |
|
| 31 | 31 | ORDER BY hpos LIMIT 1"); |
| 32 | 32 | if (!$q->rows()) { |
| 33 | 33 | $PAGE->page_start(); |
@@ -41,7 +41,7 @@ discard block |
||
| 41 | 41 | } else { |
| 42 | 42 | $new_gid = $q->field(0, 'gid'); |
| 43 | 43 | $new_hpos = $q->field(0, 'hpos'); |
| 44 | - if ($action=='nextneeded') { |
|
| 44 | + if ($action == 'nextneeded') { |
|
| 45 | 45 | $q = $db->query("select adate, atime from hansard, video_timestamps |
| 46 | 46 | where hansard.gid = video_timestamps.gid and deleted=0 |
| 47 | 47 | and hpos<$new_hpos and hdate='$hdate' and major=$major |
@@ -14,7 +14,7 @@ |
||
| 14 | 14 | // So we can send the user back to where they came from. |
| 15 | 15 | $URL->insert(array("ret"=>get_http_var("ret"))); |
| 16 | 16 | } |
| 17 | -$THEUSER->logout( $URL->generate() ); |
|
| 17 | +$THEUSER->logout($URL->generate()); |
|
| 18 | 18 | |
| 19 | 19 | $message['title'] = 'You are now logged out'; |
| 20 | 20 | |
@@ -11,34 +11,34 @@ discard block |
||
| 11 | 11 | |
| 12 | 12 | $slug = get_http_var('id'); |
| 13 | 13 | if ($slug) { |
| 14 | - $topic = $topics->getTopic($slug); |
|
| 14 | + $topic = $topics->getTopic($slug); |
|
| 15 | 15 | } else { |
| 16 | - $topic = new \MySociety\TheyWorkForYou\Topic(); |
|
| 16 | + $topic = new \MySociety\TheyWorkForYou\Topic(); |
|
| 17 | 17 | } |
| 18 | 18 | |
| 19 | 19 | $action = get_http_var('action'); |
| 20 | 20 | switch ($action) { |
| 21 | 21 | case 'add': |
| 22 | 22 | $success = add_topic($topic); |
| 23 | - break; |
|
| 23 | + break; |
|
| 24 | 24 | case 'update': |
| 25 | 25 | $success = update_topic($topic); |
| 26 | - break; |
|
| 26 | + break; |
|
| 27 | 27 | case 'setimage': |
| 28 | 28 | $success = add_image($topic); |
| 29 | - break; |
|
| 29 | + break; |
|
| 30 | 30 | case 'addcontent': |
| 31 | 31 | $success = add_content($topic); |
| 32 | - break; |
|
| 32 | + break; |
|
| 33 | 33 | case 'deletecontent': |
| 34 | 34 | $success = delete_content($topic); |
| 35 | - break; |
|
| 35 | + break; |
|
| 36 | 36 | case 'addpolicysets': |
| 37 | 37 | $success = add_policy_sets($topic); |
| 38 | - break; |
|
| 38 | + break; |
|
| 39 | 39 | case 'addpolicies': |
| 40 | 40 | $success = add_policies($topic); |
| 41 | - break; |
|
| 41 | + break; |
|
| 42 | 42 | default: |
| 43 | 43 | $success = NULL; |
| 44 | 44 | } |
@@ -125,10 +125,10 @@ discard block |
||
| 125 | 125 | <select name="sets[]" multiple> |
| 126 | 126 | <option value="">None</option> |
| 127 | 127 | <?php |
| 128 | - $policies = new \MySociety\TheyWorkForYou\Policies; |
|
| 129 | - $set_descriptions = $policies->getSetDescriptions(); |
|
| 130 | - $related_sets = $topic->getPolicySets(); |
|
| 131 | - foreach ($set_descriptions as $set => $description) { ?> |
|
| 128 | + $policies = new \MySociety\TheyWorkForYou\Policies; |
|
| 129 | + $set_descriptions = $policies->getSetDescriptions(); |
|
| 130 | + $related_sets = $topic->getPolicySets(); |
|
| 131 | + foreach ($set_descriptions as $set => $description) { ?> |
|
| 132 | 132 | <option value="<?= $set ?>" <?= in_array($set, $related_sets) ? 'selected' : '' ?>><?= $description ?></option> |
| 133 | 133 | <?php } ?> |
| 134 | 134 | <input type="submit" value="Update"> |
@@ -143,10 +143,10 @@ discard block |
||
| 143 | 143 | <select name="policies[]" multiple> |
| 144 | 144 | <option value="">None</option> |
| 145 | 145 | <?php |
| 146 | - $policies = new \MySociety\TheyWorkForYou\Policies; |
|
| 147 | - $all_policies = $policies->getPolicies(); |
|
| 148 | - $related_policies = $topic->getPolicies(); |
|
| 149 | - foreach ($all_policies as $number => $description) { ?> |
|
| 146 | + $policies = new \MySociety\TheyWorkForYou\Policies; |
|
| 147 | + $all_policies = $policies->getPolicies(); |
|
| 148 | + $related_policies = $topic->getPolicies(); |
|
| 149 | + foreach ($all_policies as $number => $description) { ?> |
|
| 150 | 150 | <option value="<?= $number ?>" <?= in_array($number, $related_policies) ? 'selected' : '' ?>><?= $description ?></option> |
| 151 | 151 | <?php } ?> |
| 152 | 152 | |
@@ -214,9 +214,9 @@ discard block |
||
| 214 | 214 | $file_info['tmp_name'], |
| 215 | 215 | $topic->image_path() |
| 216 | 216 | ); |
| 217 | - } catch (ErrorException $e) { |
|
| 217 | + } catch (ErrorException $e) { |
|
| 218 | 218 | return false; |
| 219 | - } |
|
| 219 | + } |
|
| 220 | 220 | |
| 221 | 221 | if ($image_saved) { |
| 222 | 222 | return $topic->save(); |
@@ -40,7 +40,7 @@ |
||
| 40 | 40 | $success = add_policies($topic); |
| 41 | 41 | break; |
| 42 | 42 | default: |
| 43 | - $success = NULL; |
|
| 43 | + $success = null; |
|
| 44 | 44 | } |
| 45 | 45 | |
| 46 | 46 | if (!is_null($success)) { |
@@ -7,7 +7,7 @@ discard block |
||
| 7 | 7 | |
| 8 | 8 | $PAGE->page_start(); |
| 9 | 9 | $PAGE->stripe_start(); |
| 10 | -$PAGE->block_start(array ('id'=>'alerts', 'title'=>'Alert Statistics')); |
|
| 10 | +$PAGE->block_start(array('id'=>'alerts', 'title'=>'Alert Statistics')); |
|
| 11 | 11 | $db = new ParlDB; |
| 12 | 12 | |
| 13 | 13 | $q_confirmed = $db->query('select count(*) as c from alerts where confirmed and not deleted'); |
@@ -18,13 +18,13 @@ discard block |
||
| 18 | 18 | |
| 19 | 19 | print '<h3>Headline stats</h3> <table>'; |
| 20 | 20 | $data = array( |
| 21 | - 'header' => array( 'Alert Type', 'Count' ), |
|
| 21 | + 'header' => array('Alert Type', 'Count'), |
|
| 22 | 22 | 'rows' => array( |
| 23 | - array( 'Confirmed', $q_confirmed->field('0', 'c') ), |
|
| 24 | - array( 'Not Confirmed', $q_not_confirmed->field('0', 'c') ), |
|
| 25 | - array( 'Deleted', $q_deleted->field('0', 'c') ), |
|
| 26 | - array( 'For a Speaker<sup>*</sup>', $q_speaker->field('0', 'c') ), |
|
| 27 | - array( 'For a Keyword', $q_keyword->field('0', 'c') ), |
|
| 23 | + array('Confirmed', $q_confirmed->field('0', 'c')), |
|
| 24 | + array('Not Confirmed', $q_not_confirmed->field('0', 'c')), |
|
| 25 | + array('Deleted', $q_deleted->field('0', 'c')), |
|
| 26 | + array('For a Speaker<sup>*</sup>', $q_speaker->field('0', 'c')), |
|
| 27 | + array('For a Keyword', $q_keyword->field('0', 'c')), |
|
| 28 | 28 | ) |
| 29 | 29 | ); |
| 30 | 30 | |
@@ -35,17 +35,17 @@ discard block |
||
| 35 | 35 | $q = $db->query('select alert_id, criteria from alerts where criteria not like "%speaker:%" and criteria like "%,%" and confirmed and not deleted'); |
| 36 | 36 | print '<h3>People who probably wanted separate signups</h3>'; |
| 37 | 37 | $rows = array(); |
| 38 | -for ($i=0; $i<$q->rows(); $i++) { |
|
| 38 | +for ($i = 0; $i < $q->rows(); $i++) { |
|
| 39 | 39 | $id = $q->field($i, 'alert_id'); |
| 40 | 40 | $criteria = $q->field($i, 'criteria'); |
| 41 | 41 | $rows[] = array($id, $critera); |
| 42 | 42 | } |
| 43 | -$data = array( 'rows' => $rows ); |
|
| 43 | +$data = array('rows' => $rows); |
|
| 44 | 44 | $PAGE->display_table($data); |
| 45 | 45 | |
| 46 | 46 | $q = $db->query('select count(*) as c, criteria from alerts where criteria like "speaker:%" and confirmed and not deleted group by criteria order by c desc'); |
| 47 | 47 | $tots = array(); $name = array(); |
| 48 | -for ($i=0; $i<$q->rows(); $i++) { |
|
| 48 | +for ($i = 0; $i < $q->rows(); $i++) { |
|
| 49 | 49 | $c = $q->field($i, 'c'); |
| 50 | 50 | $criteria = $q->field($i, 'criteria'); |
| 51 | 51 | if (!preg_match('#^speaker:(\d+)#', $criteria, $m)) continue; |
@@ -59,7 +59,7 @@ discard block |
||
| 59 | 59 | } |
| 60 | 60 | $q = $db->query('select count(*) as c, criteria from alerts where criteria like "speaker:%" and not confirmed group by criteria order by c desc'); |
| 61 | 61 | $unconfirmed = array(); |
| 62 | -for ($i=0; $i<$q->rows(); $i++) { |
|
| 62 | +for ($i = 0; $i < $q->rows(); $i++) { |
|
| 63 | 63 | $c = $q->field($i, 'c'); |
| 64 | 64 | $criteria = $q->field($i, 'criteria'); |
| 65 | 65 | if (!preg_match('#^speaker:(\d+)#', $criteria, $m)) continue; |
@@ -70,15 +70,15 @@ discard block |
||
| 70 | 70 | } |
| 71 | 71 | } |
| 72 | 72 | |
| 73 | -$people_header = array( 'Name', 'Confirmed', 'Unconfirmed'); |
|
| 73 | +$people_header = array('Name', 'Confirmed', 'Unconfirmed'); |
|
| 74 | 74 | print '<h3>Alert signups by MP/Peer</h3>'; |
| 75 | 75 | $rows = array(); |
| 76 | 76 | foreach ($tots as $person_id => $c) { |
| 77 | 77 | $u = isset($unconfirmed[$person_id]) ? $unconfirmed[$person_id] : 0; |
| 78 | - $rows[] = array( $name[$person_id], $c, $u ); |
|
| 78 | + $rows[] = array($name[$person_id], $c, $u); |
|
| 79 | 79 | } |
| 80 | 80 | $data = array( |
| 81 | - 'header' => array( 'Name', 'Confirmed', 'Unconfirmed'), |
|
| 81 | + 'header' => array('Name', 'Confirmed', 'Unconfirmed'), |
|
| 82 | 82 | 'rows' => $rows |
| 83 | 83 | ); |
| 84 | 84 | $PAGE->display_table($data); |
@@ -87,14 +87,14 @@ discard block |
||
| 87 | 87 | $confirmed = array(); |
| 88 | 88 | $total = array(); |
| 89 | 89 | $q = $db->query("select count(*) as c, criteria from alerts where criteria not like '%speaker:%' and confirmed and not deleted group by criteria having c>1 order by c desc"); |
| 90 | -for ($i=0; $i<$q->rows(); $i++) { |
|
| 90 | +for ($i = 0; $i < $q->rows(); $i++) { |
|
| 91 | 91 | $c = $q->field($i, 'c'); |
| 92 | 92 | $criteria = $q->field($i, 'criteria'); |
| 93 | 93 | $confirmed[$criteria] = $c; |
| 94 | 94 | $total[$criteria] = 1; |
| 95 | 95 | } |
| 96 | 96 | $q = $db->query("select count(*) as c, criteria from alerts where criteria not like '%speaker:%' and not confirmed group by criteria having c>1 order by c desc"); |
| 97 | -for ($i=0; $i<$q->rows(); $i++) { |
|
| 97 | +for ($i = 0; $i < $q->rows(); $i++) { |
|
| 98 | 98 | $c = $q->field($i, 'c'); |
| 99 | 99 | $criteria = $q->field($i, 'criteria'); |
| 100 | 100 | $unconfirmed[$criteria] = $c; |
@@ -105,10 +105,10 @@ discard block |
||
| 105 | 105 | foreach ($total as $criteria => $tot) { |
| 106 | 106 | $c = isset($confirmed[$criteria]) ? $confirmed[$criteria] : 0; |
| 107 | 107 | $u = isset($unconfirmed[$criteria]) ? $unconfirmed[$criteria] : 0; |
| 108 | - $rows[] = array( $criteria, $c, $u ); |
|
| 108 | + $rows[] = array($criteria, $c, $u); |
|
| 109 | 109 | } |
| 110 | 110 | $data = array( |
| 111 | - 'header' => array( 'Criteria', 'Confirmed', 'Unconfirmed'), |
|
| 111 | + 'header' => array('Criteria', 'Confirmed', 'Unconfirmed'), |
|
| 112 | 112 | 'rows' => $rows |
| 113 | 113 | ); |
| 114 | 114 | $PAGE->display_table($data); |
@@ -48,11 +48,15 @@ discard block |
||
| 48 | 48 | for ($i=0; $i<$q->rows(); $i++) { |
| 49 | 49 | $c = $q->field($i, 'c'); |
| 50 | 50 | $criteria = $q->field($i, 'criteria'); |
| 51 | - if (!preg_match('#^speaker:(\d+)#', $criteria, $m)) continue; |
|
| 51 | + if (!preg_match('#^speaker:(\d+)#', $criteria, $m)) { |
|
| 52 | + continue; |
|
| 53 | + } |
|
| 52 | 54 | $person_id = $m[1]; |
| 53 | 55 | $MEMBER = new MEMBER(array('person_id'=>$person_id)); |
| 54 | 56 | if ($MEMBER->valid) { |
| 55 | - if (!array_key_exists($person_id, $tots)) $tots[$person_id] = 0; |
|
| 57 | + if (!array_key_exists($person_id, $tots)) { |
|
| 58 | + $tots[$person_id] = 0; |
|
| 59 | + } |
|
| 56 | 60 | $tots[$person_id] += $c; |
| 57 | 61 | $name[$person_id] = $MEMBER->full_name(); |
| 58 | 62 | } |
@@ -62,10 +66,14 @@ discard block |
||
| 62 | 66 | for ($i=0; $i<$q->rows(); $i++) { |
| 63 | 67 | $c = $q->field($i, 'c'); |
| 64 | 68 | $criteria = $q->field($i, 'criteria'); |
| 65 | - if (!preg_match('#^speaker:(\d+)#', $criteria, $m)) continue; |
|
| 69 | + if (!preg_match('#^speaker:(\d+)#', $criteria, $m)) { |
|
| 70 | + continue; |
|
| 71 | + } |
|
| 66 | 72 | $person_id = $m[1]; |
| 67 | 73 | if (isset($name[$person_id])) { |
| 68 | - if (!array_key_exists($person_id, $unconfirmed)) $unconfirmed[$person_id] = 0; |
|
| 74 | + if (!array_key_exists($person_id, $unconfirmed)) { |
|
| 75 | + $unconfirmed[$person_id] = 0; |
|
| 76 | + } |
|
| 69 | 77 | $unconfirmed[$person_id] += $c; |
| 70 | 78 | } |
| 71 | 79 | } |