/libraries/Poll.php

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

/**
 * SubPoll poll library
 *
 * Codeigniter poll library with KendoUI chart widget
 *
 * @author 	Barna Szalai <sz.b@subdesign.hu>
 * @copyright 	Copyright (c) 2011, Barna Szalai
 * @version 	0.0.1
 *
 */
 
class Poll
{
	public function __construct()
	{
		$this->CI =& get_instance();	
	}
	
	/**
	 *	Gets the active poll's vote datas
	 *	@return array	
	 *
	 */
	public function get_poll()
	{
		$query = $this->CI->db->select('id, question, answers')
		                      ->where('status', 'active')
					          ->get('polls');
		if($query->num_rows() > 0)
		{
			$row = $query->row();
			$answers = array();
			$answers = unserialize($row->answers);
			$poll_form = form_open('subpoll/poll_item');

			foreach($answers as $answer)
			{
				$poll_form .= form_radio('answer', $answer);
				$poll_form .= form_label($answer, $answer).'<br/>';
			}
			
			$poll_form .= form_submit('submit', 'Vote');
			$data['poll_form'] = $poll_form;
			$data['question'] = $row->question;
			return $data;
		}	
	}
	
	/**
	 *	Sets the active poll's vote datas
	 *	@param string $vote
	 */
	public function set_poll($vote)
	{
		$query = $this->CI->db->select('answers, votes')
		                      ->where('status', 'active')
							  ->get('polls');
		if($query->num_rows() > 0)
		{
			$row = $query->row();
			
			$answers = unserialize($row->answers);
			$key = array_search($vote, $answers);
			$votes = unserialize($row->votes);
			$actual_vote = $votes[$key];
			$actual_vote = $actual_vote + 1;
			$votes[$key] = $actual_vote;
			$votes = serialize($votes);
			
			$this->CI->db->update('polls', array('votes' => $votes), array('status' => 'active'));
			
			$this->CI->session->set_userdata('voted', 'true');
		}
	}
	
	/**
	 *  Get the active poll and builds the javascript chart
	 *  @return array
	 *
	 */
	public function get_result()
	{
		$query = $this->CI->db->select('question, answers, votes')
		                      ->where('status', 'active')
							  ->get('polls');
		if($query->num_rows() > 0)
		{
			$row = $query->row();
			
			$answers = unserialize($row->answers);
			$votes = unserialize($row->votes);
			(is_array($votes)) ? ksort($votes) : '';
			$question = $row->question;
<<<<<<< HEAD
			
=======
							
>>>>>>> 626076d000ba60ad2c7cab1cd7d9da31472d4674
			$vote_ = '';
			$answer_ = '';
			
			if($votes != FALSE)
			{
				for($i = 1; $i <= count($answers); $i++)
				{	
					if(array_key_exists($i, $votes))
					{
					    $vote_ .= ($i < count($answers)) ? $votes[$i].', ' : $votes[$i];
					    $answer_ .= ($i < count($answers)) ? '"'.$answers[$i].' ('.$votes[$i].')", ' : '"'.$answers[$i].' ('.$votes[$i].')"';	  	
					}
					else
					{
					    $vote_ .= ($i < count($answers)) ? 0 .', ' : 0;	
					    $answer_ .= ($i < count($answers)) ? '"'.$answers[$i].' (0)", ' : '"'.$answers[$i].' (0)"';	  						
					}
				}
			}
			else
			{
				for($k = 1; $k <= count($answers); $k++)
				{
				    $vote_ .= ($k < count($answers)) ? 0 .', ' : 0;
				    $answer_ .= ($k < count($answers)) ? '"'.$answers[$k].' (0)", ' : '"'.$answers[$k].' (0)"';	
				}
			}
						
			$embed = '';
			$embed .= '<link href="http://cdn.kendostatic.com/2011.2.804/styles/examples.min.css" rel="stylesheet"/>'.
					  '<link href="http://cdn.kendostatic.com/2011.2.804/styles/kendo.common.min.css" rel="stylesheet"/>'.
					  '<link href="http://cdn.kendostatic.com/2011.2.804/styles/kendo.kendo.min.css" rel="stylesheet"/>'.
					  '<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script>'.
					  '<script src="http://cdn.kendostatic.com/2011.2.804/js/kendo.all.min.js"></script>';
			
			$js = "";
			$js = "<script type=\"text/javascript\">
			   function createChart() {
				   $(\"#chart\").kendoChart({
					   theme: \"kendo\",
					   title: {
						   font: \"13px Verdana, sans-serif\",
						   text: \"'".$question."'\"
					   },
					   legend: {
							visible: false
					   },
                       seriesDefaults: {
                            type: \"column\"
                        },
					   series: [
						   {
							   type: \"bar\", 
							   data: [".$vote_."]
						   }
					   ],
					   categoryAxis: {
						   labels: {
							   rotation: 0  
						   },
						   categories: [".$answer_."]									 
					   },
					   valueAxis: {
						   labels: {
								visible: false   
						   },
						   majorGridLines: false,
						   majosUnit: 1,
						   majorTickType: \"none\",
						   minorGridLines: false
					   },
					   tooltip: {
						   visible: true   
					   }
				   });
			   }
				   
			   $(document).ready(function() {
			   createChart();
			   
			   $(document).bind(\"kendo:skinChange\", function(e) {
				   createChart();
			   });

		   });
			</script>";
						
			$data['embed'] = $embed;
			$data['js'] = $js;
		
			return $data;
		}
	}	
	
	/**
	 *  Get all polls (Admin)
	 *  @return string
	 *
	 */
	public function get_all_polls()
	{
		$query = $this->CI->db->select('id, question, status')
						      ->get('polls');
							  
		if($query->num_rows() > 0) 
		{
			$html  = '<table id="polls">';
			$html .= '<thead>';
			$html .= '<th>Id</th>';
			$html .= '<th>Question</th>';
			$html .= '<th>Status</th>';	
			$html .= '<th>Values</th>';		
			$html .= '</thead>';			
			foreach($query->result() as $row)
			{
				$html .= '<tr>';
				$html .= '<td>'.$row->id.'</td><td>'.$row->question.'</td><td>'.anchor('subpoll/set_poll_status/'.$row->id, $row->status).'</td><td>'.anchor('subpoll/reset_poll/'.$row->id, 'Reset').'</td>';
				$html .= '</tr>';
			}
			$html .= '</table>';
			
			return $html;			
		}
	}
	
	/**
	 *  Set poll status (Admin)
	 *  @params integer $id
	 */
	public function set_poll_status($id)
	{
		$this->CI->db->update('polls', array('status' => 'inactive'));
		$this->CI->db->update('polls', array('status' => 'active'), array('id' => $id));
	}
	
	/**
	 *  Save new poll (Admin)
	 *  @params array $datas
	 *
	 */
	public function save_new_poll($datas)
	{
		$data = array(
			'question' => $datas['question'],
			'answers' => serialize($datas['answers']),
			'status' => 'inactive'
		);
		$this->CI->db->insert('polls', $data);
	}	
	
        /**
	 *  Reset poll values (Admin)
	 *  @params integer $id
	 *
	 */
	public function reset_poll($id)
	{
		$this->CI->db->update('polls', array('votes' => ''), array('id' => $id));
	}
}