| Server IP : 103.233.192.212 / Your IP : 18.118.173.146 Web Server : Apache/2 System : Linux sv1.inde.co.th 3.10.0-1160.36.2.el7.x86_64 #1 SMP Wed Jul 21 11:57:15 UTC 2021 x86_64 User : sumpatuan ( 1058) PHP Version : 5.5.38 Disable Function : symlink,shell_exec,exec,proc_close,proc_open,popen,system,dl,putenv,passthru,escapeshellarg,escapeshellcmd,pcntl_exec,proc_get_status,proc_nice,proc_terminate,pclose,ini_alter,virtual,openlog,ini_restore MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/sumpatuan/domains/sumpatuan.go.th/public_html/main/ |
Upload File : |
<?php require_once('db_main.php'); ?>
<!doctype html>
<html lang="en">
<head>
<?php include_once ("head.html"); ?>
</head>
<body class="bg-all animated fadeIn faster ">
<?php include_once ("chatfacebook.php"); ?>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<div class="container-fluid p-0 " >
<div class="container bg-main fix-page mb-0 pb-0" >
<?php include_once ("menu.php"); ?>
</div>
<!------ data ------>
<div class="container bg-white fix-page mt-0 " id="data">
<div class="row">
<div class="col bg-cl-0 fcl-cl-1 bg-txt-head text-center">
การสำรวจแสดงความคิดเห็น
</div>
<div class="w-100"></div>
<div class="col p-5 pt-3 pb-5 fw-300">
<?php
$sql_data1 = "SELECT * FROM `data_poll` WHERE `stt_poll`='0' ORDER BY str_to_date(`lastupdate_poll`,'%d/%m/%Y') DESC ,`id_poll` DESC ";
$qr_data1 = mysqli_query($con_db_main,$sql_data1) or die( mysqli_error($con_db_main));
$c_row = 0;
while($rs_data1 = mysqli_fetch_array($qr_data1)){
$c_row++;
$id_poll = $rs_data1['id_poll'];
echo '<div class="border-bottom pt-3 pb-3">
<a href="#" role="button" class="link-dark fw-500 fs-26" data-bs-toggle="modal" data-bs-target="#'.$rs_data1['id_poll'].'Modal"><i class="fas fa-angle-right me-2"></i>'.$rs_data1['question_poll'].'</a>';
echo '<div class="ms-5 mt-2">
<a href="#" role="button" class="link-dark fw-300 fs-20 me-4" data-bs-toggle="modal" data-bs-target="#'.$rs_data1['id_poll'].'Modal"><i class="fas fa-list me-2"></i>แสดงความคิดเห็น</a>
<a href="#" role="button" class="link-dark fw-300 fs-20" data-bs-toggle="modal" data-bs-target="#'.$rs_data1['id_poll'].'resultModal"><i class="fas fa-chart-pie me-2"></i>ผลสรุปความคิดเห็น</a>
</div>';
echo '</div>';
//////////// Modal question /////////////////
echo '
<div class="modal fade" id="'.$rs_data1['id_poll'].'Modal" tabindex="-1" aria-labelledby="'.$rs_data1['id_poll'].'ModalLabel" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered">
<div class="modal-content">
<div class="modal-header">
<h1 class="modal-title fs-5" id="'.$rs_data1['id_poll'].'ModalLabel"><i class="fas fa-list me-2"></i>'.$rs_data1['question_poll'].'</h1>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<form action="action/save-subPoll" method="post" >
<input type="hidden" name="id_question" value="'.$rs_data1['id_poll'].'">
<div class="modal-body fs-20 ps-4">';
if($rs_data1['answer1_poll']!=''){
echo '<div class="form-check">
<input class="form-check-input" type="radio" name="answer" value="1" checked>
<label class="form-check-label">
'.$rs_data1['answer1_poll'].'
</label>
</div>'; }
if($rs_data1['answer2_poll']!=''){
echo '<div class="form-check">
<input class="form-check-input" type="radio" name="answer" value="2">
<label class="form-check-label">
'.$rs_data1['answer2_poll'].'
</label>
</div>'; }
if($rs_data1['answer3_poll']!=''){
echo '<div class="form-check">
<input class="form-check-input" type="radio" name="answer" value="3">
<label class="form-check-label">
'.$rs_data1['answer3_poll'].'
</label>
</div>'; }
if($rs_data1['answer4_poll']!=''){
echo '<div class="form-check">
<input class="form-check-input" type="radio" name="answer" value="4">
<label class="form-check-label">
'.$rs_data1['answer4_poll'].'
</label>
</div>'; }
if($rs_data1['answer5_poll']!=''){
echo '<div class="form-check">
<input class="form-check-input" type="radio" name="answer" value="5">
<label class="form-check-label">
'.$rs_data1['answer5_poll'].'
</label>
</div>'; }
echo '</div>
<div class="modal-footer">
<button type="submit" class="btn btn-dark"><i class="fas fa-paper-plane me-2"></i>ส่งความคิดเห็น</button>
<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">ปิดหน้าต่าง</button>
</div>
</form>
</div>
</div>
</div>
';
//////////// Modal Result /////////////////
?>
<script type="text/javascript">
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['คำตอบ', 'ผลโหวต'],
['<?php echo $rs_data1['answer1_poll']; ?>', <?php echo $rs_data1['score_aw1_poll']; ?>],
['<?php echo $rs_data1['answer2_poll']; ?>', <?php echo $rs_data1['score_aw2_poll']; ?>],
['<?php echo $rs_data1['answer3_poll']; ?>', <?php echo $rs_data1['score_aw3_poll']; ?>],
['<?php echo $rs_data1['answer4_poll']; ?>', <?php echo $rs_data1['score_aw4_poll']; ?>],
['<?php echo $rs_data1['answer5_poll']; ?>', <?php echo $rs_data1['score_aw5_poll']; ?>],
]);
var options = {
backgroundColor: 'transparent',
fontSize:16,
fontName:'Kanit',
is3D: true,
chartArea:{left:20,top:10,width:'90%',height:'90%'},
width: 900,
height: 500,
pieSliceTextStyle:{color: 'black',fontSize:30},
};
var chart = new google.visualization.PieChart(document.getElementById('piechart_rs<?php echo $rs_data1['id_poll']; ?>'));
chart.draw(data, options);
}
</script>
<?php
echo '
<div class="modal fade" id="'.$rs_data1['id_poll'].'resultModal" tabindex="-1" aria-labelledby="'.$rs_data1['id_poll'].'resultModalLabel" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered modal-lg">
<div class="modal-content">
<div class="modal-header">
<h1 class="modal-title fs-5" id="'.$rs_data1['id_poll'].'resultModalLabel"><i class="fas fa-chart-pie me-2"></i>ผลสรุปความคิดเห็น</h1>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body fs-20 ps-4">
<span class="fw-500">'.$rs_data1['question_poll'].'</span>';
if( $rs_data1['score_aw1_poll']==0 && $rs_data1['score_aw2_poll']==0 && $rs_data1['score_aw3_poll']==0 && $rs_data1['score_aw4_poll']==0 && $rs_data1['score_aw5_poll']==0 ){
echo '<div class="w-100 text-center mt-5 mb-5 text-secondary"><i class="fas fa-times-circle fs-70 mb-2"></i><br>ยังไม่มีการแสดงความคิดเห็น</div>';
}else{
echo '<div class="text-center mx-auto mt-2" id="piechart_rs'.$rs_data1['id_poll'].'" ></div>';
}
echo '</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">ปิดหน้าต่าง</button>
</div>
</div>
</div>
</div>
';
}
if($c_row == 0){
echo '<div class="w-100 text-center mt-5 mb-5 text-secondary opacity-25 fs-20 fw-500" ><i class="fas fa-eye-slash fs-70"></i><br>ไม่พบข้อมูล<br>การสำรวจแสดงความคิดเห็น</div>';
}
?>
</div>
<div class="w-100"></div>
<div class="col bg-cl-2 text-center fcl-cl-1 fs-1" style="height:10px;"></div>
</div>
</div>
<!------------------>
<?php include_once ("footer.php"); ?>
</div>
<?php include_once ("cookie.php"); ?>
</body>
</html>