<?php

require_once '../settings.inc.php';
require_once '../model.inc.php';

function updateVoteStats() {
  require_once '../db.inc.php';
  $query =<<<EOQ
SELECT vote.id 
FROM vote 
LEFT JOIN vote_stats ON vote.id=vote_stats.vote_id 
WHERE vote_stats.vote_id IS NULL
EOQ;
  $result = mysql_query($query);
  if ($result) {
    $ids = array();
    while ($row = mysql_fetch_row($result)) {
      $ids[] = $row[0];
    }
    foreach ($ids as $id) {
      $query =<<<EOQ
SELECT count(*) AS count, vote_rep.vote, rep.party 
FROM vote_rep 
JOIN rep ON vote_rep.rep_id=rep.id 
WHERE vote_rep.vote_id={$id} 
GROUP BY vote_rep.vote, rep.party
ORDER BY count DESC
EOQ;
      $result = mysql_query($query);
      if ($result) {
	$majority = array();
	$majority['D'] = null;
	$majority['R'] = null;
	while ($row = mysql_fetch_row($result)) {
	  if (($row[2] == 'D') || ($row[2] == 'R')) {
	    if ($majority[$row[2]] == null) {
	      $majority[$row[2]] = $row[1];
	    }
	  }
	}
	$stats = new VoteStats();
	$stats->vote_id = $id;
	$stats->dmajority = $majority['D'];
	$stats->rmajority = $majority['R'];
	$stats->save();
	echo "Vote: {$id} {$stats->dmajority} {$stats->rmajority}\n";
      }
    }
  } else {
    error_log(mysql_error() .":\n{$query}");
  }
}

updateVoteStats();

?>