<?
session_start();

$document = array();
$script = "";
$init = "";

require "../lib/getnpost.php";
require "../lib/config.php";
require "../lib/dbconnect.php";
require "../lib/auth.php";
require "../lib/common.php";

require "helpdesk_common.php";
require "hdboard_common.php";

function mkPageList(
	$hdcat, $page, $pagestart, $pageend, $pagelast, $sn, $ss, $sc, $st
) {
	$ste = urlencode($st);

	if ($page > 1) {
		$prevpage = $page - 1;

		$prevpagestring = <<<EOS
<a href="{$_SERVER['PHP_SELF']}?hdcat=$hdcat&page=$prevpage&sn=$sn&ss=$ss&sc=$sc&st=$ste"><img src="/images/pre01.gif" width="15" height="15" border="0"></a>
EOS;

		$firstpagestring = <<<EOS
<a href="{$_SERVER['PHP_SELF']}?hdcat=$hdcat&page=1&sn=$sn&ss=$ss&sc=$sc&st=$ste"><img src="/images/pre02.gif" width="22" height="15" border="0"></a>
EOS;
	} else {
		$prevpagestring = <<<EOS
<img src="/images/pre01.gif" width="15" height="15" border="0">
EOS;

		$firstpagestring = <<<EOS
<img src="/images/pre02.gif" width="22" height="15" border="0">
EOS;
	}

	$pagelist = <<<EOS
<table width="250" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="29">$firstpagestring</td>
<td width="28">$prevpagestring</td>
<td width="136" align="center">

EOS;

	if ($pagestart > 1) {
		$pagelist .= "<a href=\"{$_SERVER['PHP_SELF']}?hdcat=$hdcat&page=1&sn=$sn&ss=$ss&sc=$sc&st=$ste\">1</a>.. ";
	}

	for ($i = $pagestart; $i <= $pageend; $i++) {
		if ($i == $page) {
			$pagelist .= "<b><font color=\"258EC3\" size=\"2\">$i</font></b> " ;
		} else {
			$pagelist .= "<a href=\"{$_SERVER['PHP_SELF']}?hdcat=$hdcat&page=$i&sn=$sn&ss=$ss&sc=$sc&st=$ste\">$i</a> ";
		}
	}

	if ($pageend < $pagelast) {
		$pagelist .= "..<a href=\"{$_SERVER['PHP_SELF']}?hdcat=$hdcat&page=$pagelast&sn=$sn&ss=$ss&sc=$sc&st=$ste\">$pagelast</a>";
	}

	if ($page < $pagelast) {
		$nextpage = $page + 1;

		$nextpagestring = <<<EOS
<a href="{$_SERVER['PHP_SELF']}?hdcat=$hdcat&page=$nextpage&sn=$sn&ss=$ss&sc=$sc&st=$ste"><img src="/images/next01.gif" width="15" height="15" border="0"></a>
EOS;

		$lastpagestring = <<<EOS
<a href="{$_SERVER['PHP_SELF']}?hdcat=$hdcat&page=$pagelast&sn=$sn&ss=$ss&sc=$sc&st=$ste"><img src="/images/next02.gif" width="22" height="15" border="0"></a>
EOS;
	} else {
		$nextpagestring = <<<EOS
<img src="/images/next01.gif" width="15" height="15" border="0">
EOS;

		$lastpagestring = <<<EOS
<img src="/images/next02.gif" width="22" height="15" border="0">
EOS;
	}

	$pagelist .= <<<EOS
</td>
<td width="28" align="right">$nextpagestring</td>
<td width="29" align="right">$lastpagestring</td>
</tr>
</table>
EOS;

	return $pagelist;
}

function mkHDList(
	&$document, &$script, &$init, $hdcat, $page, $sn, $ss, $sc, $st
) {
	global $HELPDESK_MAXLINE, $HELPDESK_MAXPAGE, $HELPDESK_BDIDS;
	global $PSYCHEID, $PsycheAdmin, $BDPRIVW;

	if (!$page) $page = 1;

	$ste = urlencode($st);

	$result = mysql_query("select count(*) from messages
where bdid = '{$HELPDESK_BDIDS[$hdcat]}'");

	list($totalrowcount) = mysql_fetch_row($result);

	$pagelast = ceil($totalrowcount / $HELPDESK_MAXLINE);

	$pagestart = max(1, $page - floor(($HELPDESK_MAXPAGE + 1) / 2));
	// HELPDESK_MAXPAGE  9: .. 3 4 5 6 [7] 8 9 10 11 ..
	// HELPDESK_MAXPAGE 10: .. 3 4 5 6 [7] 8 9 10 11 12 ..

	$pageend = min($pagestart + $HELPDESK_MAXPAGE - 1, $pagelast);

	$pagelist = mkPageList(
		$hdcat, $page, $pagestart, $pageend, $pagelast,
		$sn, $ss, $sc, $st
	);

	$limitoffset = ($page - 1) * $HELPDESK_MAXLINE;
	$limitrowcount = $HELPDESK_MAXLINE;

	$document['main'] .= <<<EOS
            <table width="670" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td height="5" bgcolor="3EA5DA"></td>
              </tr>
              <tr> 
                <td height="2"></td>
              </tr>
            </table>
            <table width="670" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td width="15"><img src="/community/images/boxleft.gif" width="15" height="35"></td>
                <td width="640" background="/community/images/boxpat.gif"><table width="640" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td width="70" align="center"><img src="/helpdesk/images/t_number.gif" width="23" height="11"></td>
                      <td width="1"><img src="/helpdesk/images/boxtitlebar.gif" width="1" height="15"></td>
                      <td width="356" align="center"><img src="/helpdesk/images/t_subject.gif" width="22" height="11"></td>
                      <td width="1"><img src="/helpdesk/images/boxtitlebar.gif" width="1" height="15"></td>
                      <td width="80" align="center"><img src="/helpdesk/images/t_name.gif" width="33" height="11"></td>
                      <td width="1"><img src="/helpdesk/images/boxtitlebar.gif" width="1" height="15"></td>
                      <td width="80" align="center"><img src="/helpdesk/images/t_date.gif" width="33" height="11"></td>
                      <td width="1"><img src="/helpdesk/images/boxtitlebar.gif" width="1" height="15"></td>
                      <td width="50" align="center"><img src="/helpdesk/images/t_hit.gif" width="33" height="11"></td>
                    </tr>
                  </table></td>
                <td width="15"><img src="/community/images/boxright.gif" width="15" height="35"></td>
              </tr>
            </table>
            <table width="670" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td height="10">&nbsp;</td>
              </tr>
            </table>
            <table width="670" border="0" cellspacing="0" cellpadding="0">

EOS;

	$wherestring = "ms.bdid = '{$HELPDESK_BDIDS[$hdcat]}'";

	if ($st) {
		$searchstring = "";

		if ($sn) {
			$searchstring = "us.usname like '%$st%'";
			$snChecked = "checked=\"checked\"";
		}

		if ($ss) {
			if ($searchstring) $searchstring .= " or ";

			$searchstring .= "ms.mssubject like '%$st%'";
			$ssChecked = "checked=\"checked\"";
		}

		if ($sc) {
			if ($searchstring) $searchstring .= " or ";

			$searchstring .= "ms.mscontent like '%$st%'";
			$scChecked = "checked=\"checked\"";
		}

		$wherestring .= " and ($searchstring)";
	} else {
		$ss = $sc = 1;

		$snChecked = "";
		$ssChecked = "checked=\"checked\"";
		$scChecked = "checked=\"checked\"";
	}

	$result = mysql_query("select
ms.msid, us.usname, unix_timestamp(ms.mstime),
ms.mssubject, ms.msread, ms.mscomments, ms.msattaches, ms.msseq, ms.msdepth
from messages as ms
left join users as us on ms.usid = us.usid
where $wherestring
order by ms.msseq desc
limit $limitoffset, $limitrowcount");

	$MessageDepthUnit = 12;

	if (mysql_num_rows($result)) {
		$line = 0;

		while (
			list(
				$msi, $usn, $msts,
				$mssbj, $msr, $msc, $msats, $mssq, $msdp
			) = mysql_fetch_row($result)
		) {
			$msd = date("Y/m/d", $msts);

			if ($msc) {
				$mscstring = "&nbsp;<span style=\"color: #258EC3; font-weight: bold;\">[$msc]</span>";
			} else {
				$mscstring = "";
			}

			if ($line++ % 2) {
				$bgcolor = "";
			} else {
				$bgcolor = "F3F3F3";
			}

			if ($msdp) {
				$msdplength = ($msdp - 1) * $MessageDepthUnit;

				$repicon = <<<EOS
<img src="/images/reply.gif" width="12" height="11" style="margin-left: {$msdplength}px;">
EOS;
			} else {
				$repicon = "";
			}

			$document['main'] .= <<<EOS
              <tr> 
                <td width="85" height="25" align="center" bgcolor="$bgcolor">$msi</td>
                <td width="358" bgcolor="$bgcolor">$repicon<a href="hdread.php?hdcat=$hdcat&page=$page&msid=$msi&sn=$sn&ss=$ss&sc=$sc&st=$ste">$mssbj</a> $mscstring</td>
                <td width="81" align="center" bgcolor="$bgcolor">$usn</td>
                <td width="82" align="center" bgcolor="$bgcolor">$msd</td>
                <td width="64" align="center" bgcolor="$bgcolor">$msr</td>
              </tr>

EOS;
		}
	} else {
		if ($st) {
			$document['main'] .= <<<EOS
              <tr> 
                <td colspan="5" align="center">°Ë»öµÈ ±ÛÀÌ ¾ø½À´Ï´Ù.</td>
              </tr>

EOS;
		} else {
			$document['main'] .= <<<EOS
              <tr> 
                <td colspan="5" align="center">°Ô½ÃµÈ ±ÛÀÌ ¾ø½À´Ï´Ù.</td>
              </tr>

EOS;
		}
	}

	if ($PSYCHEID && ($BDPRIVW == "C" || $PsycheAdmin)) {
		$writestring = <<<EOS
<a href="hdwrite.php?hdcat=$hdcat&page=$page&sn=$sn&ss=$ss&sc=$sc&st=$ste"><img src="/images/b_write.gif" width="52" height="20" border="0"></a>

EOS;
	}

	$document['main'] .= <<<EOS
            </table>

            <table width="670" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td height="1" bgcolor="3EA5DA"></td>
              </tr>
              <tr> 
                <td height="25" align="center" bgcolor="F7F6F6">
$pagelist
                </td>
              </tr>
            </table>

            <table width="670" border="0" cellspacing="0" cellpadding="5">
              <tr>
                <td width="421"> 
<form id="searchform" action="{$_SERVER['PHP_SELF']}" method="get"
 onsubmit="return checkSearch();" />
<input type="checkbox" id="sn" name="sn" value="1"
 class="smallcheckbox" $snChecked />ÀÌ¸§
<input type="checkbox" id="ss" name="ss" value="1"
 class="smallcheckbox" $ssChecked />Á¦¸ñ
<input type="checkbox" id="sc" name="sc" value="1"
 class="smallcheckbox" $scChecked />³»¿ë

<input type="text" id="st" name="st" value="$st" class="box01" />
<input type="image" src="/images/b_search.gif" width="51" height="20" align="absmiddle">
<input type="hidden" id="hdcat" name="hdcat" value="$hdcat" />
<input type="hidden" id="page" name="page" value="$page" />
</form>
</td>
                <td width="249" align="right">
<a href="{$_SERVER['PHP_SELF']}?hdcat=$hdcat&page=$page"><img src="/images/b_list.gif" width="52" height="20" border="0"></a>
$writestring
                </td>
              </tr>
            </table>

EOS;

	$script .= <<<EOS
function checkSearch() {
	f = document.getElementById("searchform");

	if (
		!f.sn.checked &&
		!f.ss.checked &&
		!f.sc.checked
	) {
		alert("°Ë»ö Ç×¸ñÀ» ¼±ÅÃÇØ ÁÖ¼¼¿ä.");

		return false;
	}

	if (!f.st.value) {
		alert("°Ë»ö¾î¸¦ ÀÔ·ÂÇØ ÁÖ¼¼¿ä.");
		f.st.focus();

		return false;
	}

	return true;
}

EOS;
}

## Start

if (!$hdcat) $hdcat = "A";	// HD

mkHDBoardCommon($document, $HELPDESK_BDIDS[$hdcat]);

mkHDList($document, $script, $init, $hdcat, $page, $sn, $ss, $sc, $st);

require "helpdesk_template.php";
?>
