$lastdate && $lastdate = $d;
$total++;
}
$Datas = array();
foreach ($Count as $key => $val){
$value = join("\t", array(
"name=$key",
"cnt=".$Count[$key],
"date=".$obj[$key]['Date']
));
$Datas[] = $value;
}
$text .= "
$name
";
$i = 0;
foreach ($Totalizations as $line) {
$class = "ui-state-default";
$i == $_REQUEST['id'] && $class = "ui-state-hover";
if (preg_match("/survey/", $_SERVER['SCRIPT_NAME'])) {
$action = "javascript:getAjaxText('". $_SERVER['SCRIPT_NAME'].
"?ajax=summary_table&group=". $_REQUEST['group'].
"&pw=". $_REQUEST['pw']. "&id=$i', 'systemDialog');";
} else {
$action = "javascript:location.href='". $_SERVER['SCRIPT_NAME'].
"?pw=". $_REQUEST['pw']. "&group=". $_REQUEST['group'] . "&id=$i'";
}
$text .= "
| $line | ";
$i++;
}
$text .= "
$question
| Value | ";
$denomi_view && $text .= "
Cnt | ";
$text .= "
Point | ";
$lastdateview && $text .= "
Date | ";
$text .= "
";
if ($sampling[$totalizate]) {
if ($denomi_view == 2 && $_REQUEST['pw'] && preg_match("/integra/", $_SERVER['SCRIPT_NAME'])) {
$limit_edit = 1;
}
$sampling[$totalizate] = preg_replace("/[\r\n\t]/", "", $sampling[$totalizate]);
$Samplings = split(",", $sampling[$totalizate]);
$m_total = 0;
foreach ($Samplings as $smp) {
list($que, $m) = split(":", $smp);
$m_total += $m;
$name = $que; $cnt = "0"; $class = ""; $v = " "; $date = ""; $match = 0;
foreach ($Datas as $line) {
$data = dbfields($line);
if ($data['name'] == $que) {
$w = "0px;"; $class = "graph";
$cnt = $data['cnt'];
$date = $data['date'];
if ($m) {
$bar = $cnt / $m * 100;
$bar > 100 && ($class = "graph_over");
$w = 1000 - $cnt / $m * 240 - 4;
$denomi_point && $v = "". sprintf("%3.2f", $bar). "%";
$denomi_view == 2 && $cnt .= "/$m";
} elseif ($total) {
$w = 1000 - $cnt / $total * 240 - 4;
$v = "". sprintf("%3.2f", $cnt / $total * 100). "%";
}
$w .= "px";
if (preg_match("/^\d+$/", $name)) {
$name = $Legend[$name];
}
$match = 1;
break;
}
}
if (!$match && $denomi_view == 2) $cnt .= "/$m";
$limit_edit && $name = "$name";
$text .= "
| $name | ";
$denomi_view && $text .= "
$cnt | ";
$text .= "
$v | ";
$lastdateview && $text .= "
$date | ";
$text .= "
";
}
} else {
foreach ($Datas as $line) {
$data = dbfields($line);
$w = "0px;"; $class = "graph";
$w = 1000 - $data['cnt'] / $total * 240 - 4;
$v = "". sprintf("%3.2f", $data['cnt'] / $total * 100). "%";
$w .= "px";
$name = $data['name'];
if (preg_match("/^\d+$/", $name)) {
$name = $Legend[$name];
}
$text .= "
| $name | ";
$denomi_view && $text .= "
". $data['cnt']. " | ";
$text .= "
$v | ";
$lastdateview && $text .= "
". $data['date']. " | ";
$text .= "
";
}
}
$w = "0px;"; $v = " "; $class = "";
if ($m_total) {
$denomi_view == 2 && $total .= "/$m_total";
$class = "graph";
$bar = $total / $m_total * 100;
$bar > 100 && ($class = "graph_over");
$w = 1000 - $total / $m_total * 240 - 4;
$denomi_point && $v = "". sprintf("%3.2f", $bar). "%";
$w .= "px";
}
$text .= "
| Total | ";
$denomi_view && $text .= "
$total | ";
$text .= "
$v | ";
$lastdateview && $text .= "
$d | ";
$text .= "
";
if ($limit_edit &&
($_REQUEST['pw'] == $root || $_REQUEST['pw'] == $admin)) {
$text .=<<<_
_;
}
} else {
$Data = mysql_fetch_assoc(mysql_query(
"SELECT COUNT(*) as 'Cnt' FROM `$tablename`;"
));
$total = $Data['Cnt'];
$text .= "
| Group | ";
$denomi_view && $text .= "
Cnt | ";
$text .= "
Point |
Date |
|---|
";
$denomitotal = 0;
foreach ($Samples as $line) {
list($name, $group, $denomi) = split(",", $line);
$Data = mysql_fetch_assoc(mysql_query(
"SELECT COUNT(*) as 'Cnt', DATE_FORMAT(MAX(`Date`), '%Y/%m/%d') as 'Lastdate' FROM `$tablename` WHERE `Group`='$group';"
));
$cnt = $Data['Cnt'];
$w = "0px;"; $v = " "; $class = "graph";
if ($denomi) {
$denomi_view == 2 && $cnt .= "/$denomi";
$denomitotal += $denomi;
if ($Data['Cnt']) {
$bar = $Data['Cnt'] / $denomi * 100;
$bar > 100 && ($class = "graph_over");
$w = 1000 - $Data['Cnt'] / $denomi * 240 - 4;
$denomi_point && $v = "". sprintf("%3.2f", $bar). "%";
$w .= "px";
} else {
$class = "";
}
} elseif ($total) {
if ($Data['Cnt']) {
$w = 1000 - $Data['Cnt'] / $total * 240 - 4;
$v = "". sprintf("%3.2f", $Data['Cnt'] / $total * 100). "%";
$w .= "px";
} else {
$class = "";
}
}
$text .= "
| $name | ";
$denomi_view && $text .= "
$cnt | ";
$text .= "
$v | ";
$lastdateview && $text .= "
". $Data['Lastdate']. " | ";
$text .= "
";
}
$denomi_view == 2 && $total .= "/$denomitotal";
if ($total && $denomitotal) {
$class = "graph";
$bar = $total / $denomitotal * 100;
$bar > 100 && ($class = "graph_over");
$w = 1000 - $total / $m_total * 240 - 4;
$denomi_point && $v = "". sprintf("%3.2f", $bar). "%";
$w .= "px";
}
$text .= "
| Total | ";
$denomi_view && $text .= "
$total | ";
$text .= "
$v | ";
$lastdateview && $text .= "
| ";
$text .= "
";
}
?>