.
*/
require_once(FILESYSTEMROOTPATH."include/classes/IDao.php");
require_once(FILESYSTEMROOTPATH."jc/include/model/PollOptions.php");
require_once(FILESYSTEMROOTPATH."jc/images/Image_link.php");
class PollOptionsDao implements IDao {
/** MySQL object */
private $mysql;
/**
* Default constructor
*/
public function __construct(MySQL $mysql) {
$this->mysql = $mysql;
}
/**
* Load Agorae by id
*
* @param id
* @return
*/
public function load($id) {
$query = "SELECT * FROM `pollOptions` WHERE `id`='".$id."'";
if( $this->mysql->query($query) ) {
return new PollOptions($this->mysql->fetchArray());
}else {
return array();
}
}
public function loadByPoll($poll_id) {
$poll = $GLOBALS['ClassFactory']->getPollsService()->load($poll_id);
$query = 'SELECT * FROM `pollOptions` WHERE `poll_id`="'.$poll_id.'"';
if( $this->mysql->query($query) ) {
$ret = array();
while( $row = $this->mysql->fetchArray() ) {
if (date("Y-m-d H:i:s") > $poll->getOpen())
{
$row['edit'] = '-';
$row['delete'] = '-';
}
else
{
//$row['edit'] = 'Edit';
//$row['delete'] = 'Delete';
$row['edit'] = img_edit('poll_options2.php?id='.$row['id'].'&pid='.$row['poll_id']);
$row['delete'] = img_del('poll_options3.php?id='.$row['id']);
}
$ret[$row['id']] = $row;
}
return $ret;
}else {
return array();
}
}
public function delete(PollOptions $pollOption){
$query = 'DELETE FROM `pollOptions` WHERE `id`='.$pollOption->getId();
return $this->mysql->query($query);
}
/**
* Save or update PollOptions:
* @param object with the data
* @return boolean true in case of success, false otherwise
*/
public function saveOrUpdate(IModel $pollOption) {
$query="";
$recordID=$pollOption->getId();
if($recordID==NULL)
{
$query.="INSERT INTO `pollOptions` SET ";
}
else
{
$query.="UPDATE `pollOptions` SET ";
}
$query .="`pollOption` = '".$this->mysql->escape($pollOption->getPollOption())."', ";
$query .="`poll_id` = '".$this->mysql->escape($pollOption->getPoll_id())."', ";
$query .="`description` = '".$this->mysql->escape($pollOption->getDescription())."', ";
$query .="`votes` = '".$this->mysql->escape($pollOption->getVotes())."'";
if($recordID!=NULL)
{
$query.=" where `id` = ".$recordID;
}
//echo $query;
return $this->mysql->query($query);
}
}
?>