.
*/
require_once(FILESYSTEMROOTPATH."include/classes/IDao.php");
require_once(FILESYSTEMROOTPATH."jc/include/model/RankedVoteOptions.php");
require_once(FILESYSTEMROOTPATH."jc/images/Image_link.php");
class RankedVoteOptionsDao 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 `rankedVoteOptions` WHERE `id`='".$id."'";
if( $this->mysql->query($query) ) {
return new RankedVoteOptions($this->mysql->fetchArray());
}else {
return array();
}
}
public function loadByRankedVote($rankedVote_id) {
$rankedVote = $GLOBALS['ClassFactory']->getRankedVoteService()->load($rankedVote_id);
$query = 'SELECT * FROM `rankedVoteOptions` WHERE `rankedVote_id`="'.$rankedVote_id.'" ORDER BY `id`';
if( $this->mysql->query($query) ) {
$ret = array();
while( $row = $this->mysql->fetchArray() ) {
if (date("Y-m-d H:i:s") > $rankedVote->getOpen())
{
$row['edit'] = '-';
$row['delete'] = '-';
}
else
{
//$row['edit'] = 'Edit';
//$row['delete'] = 'Delete';
$row['edit'] = img_edit('ranked_options2.php?id='.$row['id'].'&pid='.$row['rankedVote_id']);
$row['delete'] = img_del('ranked_options3.php?id='.$row['id']);
}
$ret[$row['id']] = $row;
}
return $ret;
}else {
return array();
}
}
public function delete(RankedVoteOptions $rankedVoteOption){
$query = 'DELETE FROM `rankedVoteOptions` WHERE `id`='.$rankedVoteOption->getId();
return $this->mysql->query($query);
}
/**
* Save or update RankVoteOptions:
* @param object with the data
* @return boolean true in case of success, false otherwise
*/
public function saveOrUpdate(IModel $rankedVoteOption) {
$query="";
$recordID=$rankedVoteOption->getId();
if($recordID==NULL)
{
$query.="INSERT INTO `rankedVoteOptions` SET ";
}
else
{
$query.="UPDATE `rankedVoteOptions` SET ";
}
$query .="`rankedVoteOption` = '".$this->mysql->escape($rankedVoteOption->getRankedVoteOption())."', ";
$query .="`rankedVote_id` = '".$this->mysql->escape($rankedVoteOption->getRankedVote_id())."', ";
$query .="`description` = '".$this->mysql->escape($rankedVoteOption->getDescription())."', ";
$query .="`ranking` = '".$this->mysql->escape($rankedVoteOption->getRanking())."'";
if($recordID!=NULL)
{
$query.=" where `id` = ".$recordID;
}
//echo $query;
return $this->mysql->query($query);
}
}
?>