include "../lib/link";
$qp = mysqlQuery(" select * from n_pollCategory where code = $codeCategory ");
$cp = mysqlFetch($qp);
$qp1 = mysqlQuery(" select * from n_pollList where status != '´ë±â' and codeCategory = '$codeCategory' order by status desc, code desc ");
$tp1 = mysqlAffected($qp1);
?>
¼³¹®Á¶»ç
// Çì´õ ÆÄÀÏ
$urlHeader = "./inc/".$codeCategory."/header.html";
if(file_exists($urlHeader)) { include $urlHeader; }
// Çì´õ ³»¿ë
echo("$cp[header]");
?>
/////////////// ÆäÀÌ¡ ////////////////////////////////////////////////////////////////////////////////////
if($cp[num_list] == 0) $loop_interval = 5; else $loop_interval = $cp[num_list]; // ÆäÀÌÁö´ç Ç¥½ÃµÉ ÀÚ·á¼ö
if($cp[num_page] == 0) $loop_page = 10; else $loop_page = $cp[num_page]; // À̵¿¸µÅ© Ç¥½Ã¼ö
$row_total = $tp1; // ÃÑ °¹¼ö¸¦ ÇÒ´ç
$row_pointer = $row_start-1;
if(!$row_start) {$row_start = 0;}
if($row_total - $row_start > $loop_interval) { $page_loop = $loop_interval;} elseif($row_total - $row_start <= $loop_interval) {$page_loop = $row_total - $row_start;}
for($i=0;$i<$page_loop;$i++) {
$row_pointer++;
$cp1 = mysqlFetch($qp1,$row_pointer);
$tmpDate = dateFormat($cp1[regDate]);
$startDate = "$tmpDate[0]/$tmpDate[1]/$tmpDate[2]";
$tmpDate = dateFormat($cp1[endDate]);
$endDate = "$tmpDate[0]/$tmpDate[1]/$tmpDate[2]";
if($cp1[status] == 'ÁøÇà')
{
$statusWord = "ÁøÇàÁß";
$endDate = "ÁøÇàÁß";
}
else if($cp1[status] == 'Á¾·á')
{
$statusWord = "Á¾·á";
}
echo("
Q : |
$cp1[subject] |
$statusWord |
|
");
$no = 0;
$qp2 = mysqlQuery(" select * from n_pollItem where codeList = '$cp1[code]' order by code ");
$tp2 = mysqlAffected($qp2);
if($cp1[etc] == 'yes')
{
$qp3 = mysqlQuery(" select * from n_pollEtc where codeList = '$cp1[code]' ");
$tp3 = mysqlAffected($qp3);
}
$qp4 = mysqlQuery(" select sum(counter), max(counter) from n_pollItem where codeList = '$cp1[code]' ");
$cp4 = mysqlFetch($qp4);
$totalCounter = $cp4[0] + $tp3;
$totalCounter_ = number_format($totalCounter);
if($cp4[1] < $tp3)
$maxCounter = $tp3;
else
$maxCounter = $cp4[1];
for($j=0;$j<$tp2;$j++)
{
$cp2 = mysqlFetch($qp2,$j);
++$no;
$imgWord = "bar".($no % 10);
if($totalCounter < 1)
{
$perc = 0;
$width = 0;
$itemCounter = 0;
}
else
{
$perc = round($cp2[counter] / $totalCounter * 100);
$width = round($cp2[counter] / $maxCounter * 100) - 20 ;
$itemCounter = number_format($cp2[counter]);
}
echo("
$no. $cp2[subject] |
$itemCounterǥ |
$perc%
|
");
}
if($cp1[etc] == 'yes')
{
++$no;
$imgWord = "bar".($no % 10);
if($totalCounter < 1)
{
$perc = 0;
$width = 0;
$itemCounter = 0;
}
else
{
$perc = round($tp3 / $totalCounter * 100);
$width = round($tp3 / $maxCounter * 100) - 20 ;
$itemCounter = number_format($tp3);
}
echo("
$no. ±âŸ |
$itemCounterǥ
|
$perc%
|
");
}
echo("
ÃÑÅõÇ¥¼ö: $totalCounter_ Ç¥
|
|
|
");
if($cp1[etc] == 'yes')
{
echo(" [±âŸÀǰߺ¸±â] ");
}
echo(" |
$startDate ~ $endDate |
|
");
}
?>
|
//$row_total = 1000;
/////////////// ÆäÀÌ¡ ////////////////////////////////////////////////////////////////////////////////////
$var_add = "codeCategory=$codeCategory";
$jump_page_pre_word = "[ÀÌÀü]";
$jump_page_next_word = "[´ÙÀ½]";
$floor_page = floor($row_start/($loop_interval*$loop_page));
if($row_start >= $loop_interval*$loop_page) {
$jump_page_pre = $floor_page * $loop_interval * $loop_page - $loop_interval;
echo("$jump_page_pre_word ");
}
for($i=0;$i<$loop_page;$i++) {
if($row_start1+$loop_interval<$row_total) {
$row_start1 = ($i * $loop_interval) + ($floor_page * $loop_interval * $loop_page);
$next_page = ($i + 1) + ($floor_page * $loop_page);
if($row_start == $row_start1) {
echo("[$next_page] ");
} else {
echo("$next_page ");
}
}
}
if($row_total > $loop_interval*$loop_page) {
if($row_total - $row_start1 > $loop_interval) {
$jump_page_next = ($floor_page+1)*$loop_interval*$loop_page;
echo("$jump_page_next_word");
}
}
?>
|
|
// ǪÅÍ ³»¿ë
echo("$cp[footer]");
// ǪÅÍ ÆÄÀÏ
$urlFooter = "./inc/".$codeCategory."/footer.html";
if(file_exists($urlFooter)) { include $urlFooter; }
?>
/*----------------------------------------------------------------
ÆÄ ÀÏ ¸í : list.html
------------------------------------------------------------------
»ç ¿ë ¿ä ¾à : [ÀϹÝ] ¼³¹®Á¶»ç ¸ñ·ÏÆäÀÌÁö
------------------------------------------------------------------
°³ ¹ß ÀÚ : ±è¿ìÇö
------------------------------------------------------------------
µð ÀÚ ÀÎ : ±è¿ìÇö
------------------------------------------------------------------
Á¦ÀÛ ½ÃÀÛÀÏ : 2003/09/22
------------------------------------------------------------------
¼ö Á¤ ³» ¿ë : ¼öÁ¤ÀÏ :
¼öÁ¤ÀÚ :
³» ¿ë :
------------------------------------------------------------------*/
?>