File size: 4.45Kb
<?
if ($pdo->query(("SELECT COUNT(*) FROM `notes_votes` WHERE `id_notes` = '".intval($notes['id'])."'"), 0)->fetchColumn() > 0){
$votes = $pdo->query(("SELECT * FROM `notes_votes` WHERE `id_notes` = '".intval($notes['id'])."'"))->fetch(PDO::FETCH_ASSOC);
echo '<br /><div style="border: 1px #A7CCDD solid; padding: 3px;">';
echo'<font color=#71B7D8><i class="fa fa-bullhorn"></i></font> <b><font color=gray>';
echo text($votes['msg']);
echo'</font></b>';
if($user['id'] == $notes['id_user'] || access('adm_mysql')){
echo ' <a href="oprosedit.php?id='.$notes['id'].'&votes='.$votes['id'].'&name"><i class="fa fa-pencil fa-fw"></i> Ред.</a>';
}
echo '<br /><br />';
if (($user['rating'] < 19))
{
echo '<div class="err">В опросе могут голосовать пользователи с аккаунтами не менее 2 уровня. У Вас 3 уровень, для того чтобы перейти во второй, необходимо набрать более 20 единиц рейтинга.</div>';
}else{
$opros=$pdo->query("SELECT * FROM `notes_votes_variant` WHERE `id_votes` = '".intval($votes['id'])."' AND `edit` = '1' ORDER BY num ASC");
if($pdo->query(("SELECT COUNT(*) FROM `notes_votes_user` WHERE `id_votes` = '".intval($votes['id'])."' AND `id_user` = '".intval($user['id'])."'"), 0)->fetchColumn()==0 && isset($user) && $avtor['id']!=$user['id']){
if(isset($_GET['act']) && $_GET['act']=='golos' && isset($_POST['variant']) && isset($_POST['votessave'])){
$idvariant = intval($_POST['variant']);
$pdo->query("INSERT INTO `notes_votes_user` (`id_user`, `id_variant`, `id_votes`) values('".intval($user['id'])."', '$idvariant', '".intval($votes['id'])."')");
$_SESSION['message'] = 'Вы успешно проголосовали!';
header("Location: ?id=$notes[id]");
exit;
}
echo "<form method=\"post\" name='golos' action=\"?id=$notes[id]&act=golos\">";
while ($post = $opros->fetch(PDO::FETCH_ASSOC))
{
$i = intval($post['num']);
$id = intval($post['id']);
echo "<label class='c-input c-checkbox'><input name='variant'".($i==1?" checked='checked'":null)." type='checkbox' value='$id' /><span class='c-indicator'></span> ";
echo output_text($post['otvet']);
echo '</label><br />';
}
echo "<br /><input type='submit' class='btn btn-primary btn-sm' name='votessave' value='Голосовать' />\n";
echo "</form>\n";
}else{
while ($post = $opros->fetch(PDO::FETCH_ASSOC))
{
$i = intval($post['num']);
$id = intval($post['id']);
$allcount = $pdo->query(("SELECT COUNT(*) FROM `notes_votes_user` WHERE `id_votes` = '".intval($votes['id'])."'"), 0)->fetchColumn();
$count = $pdo->query(("SELECT COUNT(*) FROM `notes_votes_user` WHERE `id_votes` = '".intval($votes['id'])."' AND `id_variant` = '$id'"), 0)->fetchColumn();
if($count != 0){
$ret = round(($count/$allcount)*100, 2);
}else{
$ret = 0;
}
echo'<span style="padding: 3px;">';
echo output_text($post['otvet']); echo' <span style="padding: 1px; border: 1px #C0CFD6 solid; border-radius: 16%; font-size: 12px; color: gray;">'.$count.' чел.</span>';
if($user['id'] == $notes['id_user'] || access('adm_mysql')){
echo ' <a href="oprosedit.php?id='.$notes['id'].'&votes='.$votes['id'].'&variant='.$post['id'].'"><i class="fa fa-pencil fa-fw"></i> Ред.</a>';
echo ' <a href="oprosedit.php?id='.$notes['id'].'&votes='.$votes['id'].'&del_variant='.$post['id'].'"><font color=red><i class="fa fa-trash fa-fw"></i> Удл.</font></a>';
}
echo'</span><br/><div style="display: inline-block; height: 18px; width: 99%; border: 1px solid #78AFC9; position: relative; background-color: White;">
<div style="height: 18px; width: 329%; background: #EAF5FA; position: absolute; max-width: 100%;"></div>
<div style="height: 18px; width: '.$ret.'%; background: #78AFC9; position: absolute; max-width: 100%;"></div>
<span style="position: absolute; text-align: center; width: 100%; display: block; font-size: 11px;">'.$ret.'%</span>
</div>';
}
}
}
if($user['id'] == $notes['id_user'] || access('adm_mysql')){
echo "<br><br><a class='btn btn-primary btn-sm' href='oprosedit.php?id=$notes[id]&votes=$votes[id]&plus'>[+] Ещё вариант</a>";
echo " <a class='btn btn-secondary btn-sm' href='oprosedit.php?id=$notes[id]&votes=$votes[id]&minus'><i class='fa fa-trash'></i> Удалить опрос</a>";
}
echo '</div><br />';
}
?>