{ location.href=\"/admin.php/audience/\"; self.focus(); } "; } // ============= // === Edit ==== // ============= if ((isset($_POST["send"])) && ($_POST["send"] == "edit")) { $sql = sprintf("UPDATE zlo_users_audience SET title=%s, date_start=%s, date_end=%s, `text`=%s, `show`=%s WHERE id='".$_POST['id']."' ", GetSQLValueString($_POST['form']['title'], "text"), GetSQLValueString($_POST['form']['date_start'], "text"), GetSQLValueString($_POST['form']['date_end'], "text"), GetSQLValueString($_POST['form']['text'], "text"), GetSQLValueString($_POST['form']['show'], "text")); $result = mysql_query($sql) or die(mysql_error()); echo ""; } // ============= // === Del ==== // ============= if ((isset($_GET["action"])) && ($_GET["action"] == "del")) { $sql = "DELETE FROM zlo_users_audience WHERE id='".$_GET['id']."'"; $result = mysql_query($sql) or die(mysql_error()); $sql = "DELETE FROM zlo_users_audience_option WHERE audience_id='".$_GET['id']."'"; $result = mysql_query($sql) or die(mysql_error()); echo ""; } // ============= // === set ==== // ============= if ((isset($_GET["action"])) && ($_GET["action"] == "set")) { $sql = sprintf("UPDATE zlo_users_audience SET `show`=%s WHERE id='".$_GET['audience_id']."' ", GetSQLValueString($_GET['show'], "text")); $result = mysql_query($sql) or die(mysql_error()); echo ""; } // ================= // ==== option ===== // ================= // ============= // ==== add ==== // ============= if ((isset($_POST["send"])) && ($_POST["send"] == "optionAdd")) { $sql = sprintf("INSERT INTO zlo_users_audience_option (title, audience_id) VALUES (%s,%s)", GetSQLValueString($_POST['form']['title'], "text"), GetSQLValueString($_POST['audience'], "text")); $result = mysql_query($sql) or die(mysql_error()); GoBack(1); } // ============= // === Edit ==== // ============= if ((isset($_POST["send"])) && ($_POST["send"] == "optionEdit")) { $sql = sprintf("UPDATE zlo_users_audience_option SET title=%s WHERE id='".$_POST['option']."' ", GetSQLValueString($_POST['form']['title'], "text")); $result = mysql_query($sql) or die(mysql_error()); GoBack(1); } // ============= // === Del ==== // ============= if ((isset($_GET["action"])) && ($_GET["action"] == "optionDel")) { $sql = "DELETE FROM zlo_users_audience_option WHERE id='".$_GET['option']."'"; $result = mysql_query($sql) or die(mysql_error()); GoBack(1); } // ============================== // ========== Âûâîä ============= // ============================== // ================= // === audience ==== // ================= // ============= // ==== All ==== // ============= if (!isset($_GET['action'])) { // ***** Àäìèí ðåæèì ***** if(isset($_SESSION['admin']['edit'])) { echo"Äîáàâèòü"; } // *********************** $sql = "SELECT * FROM zlo_users_audience ORDER BY `date_start` DESC"; $pager['sql']= $sql; $pager=pagerGetRun($pager,10,15); $result = mysql_query($pager['sql']) or die(mysql_error()); if (mysql_affected_rows()!=0) { echo""; while ($audience=mysql_fetch_assoc($result)){ echo""; echo""; echo""; } echo"
id Íàçâàíèå Äàòà íà÷àëà Äàòà îêîí÷àíèÿ
".$audience['id']." ".$audience['title']." ".$audience['date_start']." ".$audience['date_end']."
"; // Àêòèâíî/íå àêòèâíî if($audience['show']==1) { echo""; } else { echo""; } echo""; // ***** Àäìèí ðåæèì ***** if (isset($_SESSION['admin']['edit'])) { echo""; echo""; } if (isset($_SESSION['admin']['del'])) { echo"
";} // ************************ echo"
"; // === Pager echo"
".pagerGetShow($pager)."
"; } } // ============= // ==== add ==== // ============= if (isset($_GET['action']) && $_GET['action']=='add') { echo"
Íàçâàíèå
Íà÷àëî
Îêîí÷àíèå
Îïèñàíèå
Àêòèâíî
"; echo''; echo''; } // ============= // === Edit ==== // ============= if (isset($_GET['action']) && $_GET['action']=='edit') { $sql = "SELECT * FROM zlo_users_audience WHERE id='".$_GET['id']."'"; $result = mysql_query($sql) or die(mysql_error()); $audience=mysql_fetch_assoc($result); if (mysql_affected_rows()!=0) { echo"
Íàçâàíèå
Íà÷àëî
Îêîí÷àíèå
Îïèñàíèå
Àêòèâíî
"; } echo''; echo''; } // ================= // ==== option ===== // ================= // ============= // ==== All ==== // ============= if (isset($_GET['action']) && $_GET['action']=='optionShow') { $sql = "SELECT * FROM zlo_users_audience_option WHERE audience_id='".$_GET['audience']."' "; $result = mysql_query($sql) or die(mysql_error()); if (mysql_affected_rows()!=0) { echo""; while ($option=mysql_fetch_assoc($result)){ echo""; // ***** Àäìèí ðåæèì ***** echo""; // ************************ echo""; } echo"
id Íàçâàíèå
".$option['id']." ".$option['title']."
"; if (isset($_SESSION['admin']['edit'])) {echo"";} if (isset($_SESSION['admin']['del'])) { echo"
";} echo"
"; } echo"Äîáàâèòü"; } // ============= // ==== add ==== // ============= if (isset($_GET['action']) && $_GET['action']=='optionAdd') { echo"
Íàçâàíèå
"; } // ============= // === Edit ==== // ============= if (isset($_GET['action']) && $_GET['action']=='optionEdit') { $sql = "SELECT * FROM zlo_users_audience_option WHERE id='".$_GET['option']."'"; $result = mysql_query($sql) or die(mysql_error()); $option=mysql_fetch_assoc($result); if (mysql_affected_rows()!=0) { echo"
Íàçâàíèå
"; } } // ============== // === Report === // ============== if (isset($_GET['action']) && $_GET['action']=='report') { echo"
"; // Èíôî î ãîëîñîâàíèè $sql = "SELECT * FROM zlo_users_audience WHERE id='".$_GET['id']."'"; $result = mysql_query($sql) or die(mysql_error()); if (mysql_affected_rows()!=0) { $audience=mysql_fetch_assoc($result); echo"
".$audience['title']."
".$audience['text']."
Îïðîñ çà ïåðèîä ".$audience['date_start']." - ".$audience['date_end']."
"; // Âàðèàíò³ îòâåòîâ + ïîäñ÷åò ãîëîñîâ // Îòâåòè $sql3 = "SELECT * FROM zlo_users_audience_answers WHERE audience_id='".$_GET['id']."' "; $result3 = mysql_query($sql3) or die(mysql_error()); if (mysql_affected_rows()!=0) { while($mass=mysql_fetch_assoc($result3)){ $vote[]=$mass; } // Âàðèàíò³ îòâåòîâ $sql2 = "SELECT * FROM zlo_users_audience_option WHERE audience_id='".$_GET['id']."' "; $result2 = mysql_query($sql2) or die(mysql_error()); if (mysql_affected_rows()!=0) { $j=-1; $totalVotes=0; while ($option=mysql_fetch_assoc($result2)){ $j++; $res=0; foreach($vote as $i=>$choice) { $voteMass=explode(":",$choice['value']); if (in_array($option['id'], $voteMass)) { $ok=1;$res++; } } if ($ok==1) { $MassResult[$j]=$res; $totalVotes+=$res; } else { $MassResult[$j]=0; } $MassTitle[$j]=$option['title']; } // Âèâîäèì ðåçóëüòàòè echo""; for($k=0; $k<=$j; $k++) { if ($MassResult[$k]!=0) { $percent=(int)$MassResult[$k]/$totalVotes*100; } else { $percent=0;} // $MassResult[$k] ÷èñëî ãîëîñîâ // Ïîäñ÷åò â ïðîöåíòíîì ñîîòíîøåíèè $percent=round($percent,2); // Äëÿ äèáèëîèäí³õ ñåðâàêîâ $percent=str_replace(",",".",$percent); echo""; } echo"
".$MassTitle[$k]." - ".$percent."% "; if ($MassResult[$k]!=0) { echo"
(".$MassResult[$k].")
"; } echo"
"; } echo"
"; echo"
Âñåãî ïðîãîëîñîâàëî: $totalVotes ÷åë.
"; } echo"
"; // Ðåçóëüòàòû â ðàçðåçå ïîëüçîâàòåëåé $sql = "SELECT * FROM zlo_users_audience AS a LEFT JOIN zlo_users_audience_option AS o ON o.audience_id = a.id LEFT JOIN zlo_users_audience_answers AS w ON w.value = o.id LEFT JOIN zlo_users AS u ON w.user_id = u.id WHERE a.id='".$_GET['id']."' AND w.value = o.id AND w.audience_id=a.id ORDER by o.title"; $result = mysql_query($sql) or die(mysql_error()); if (mysql_affected_rows()!=0) { $option=''; echo" "; while($results=mysql_fetch_assoc($result)){ // Äëÿ çàãîëîâêîâ if($results['title']!=$option) { echo""; $option=$results['title']; } // âûâîäèì ãîëîñîâàâøèõ if($results['username']!='') { echo""; } } echo"
ÔÈÎ Ãîðîä Òåë. Åmail
".$results['title']."
".$results['username']." ".$results['city']." ".$results['tel']." ".$results['email']."
"; } } } ?>