1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

list(2020.08.10-1).php

<? include "comm/top.php"; ?>
<? include "comm/func.php"; ?>
<? include "comm/login_check.php"; ?>

<SCRIPT type="text/javascript">
function goSearchAction(){
	var f = document.SearchForm;
	f.submit();
}
</SCRIPT>

<TABLE width="1000" align="center" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
	<TR bgcolor="#FFFFFF">
		<TD align="left">
			<IMG src="top_logo2.jpg" align="absmiddle" onclick="location.href='list.php'">
		</TD>
		<TD align="right" valign="bottom" width="100"><a href="<?= $BBS_PATH ?>logout.php">[]</a></TD>
	</TR>
</TABLE>

<TD width="60"  align="center" bgcolor="#4D4D4D"><font color="#FFFFFF"></font></TD>
		<TD align="left" bgcolor="#FFFFFF">
			<INPUT type="checkbox" name="nwsts1" value="Y" onclick="JavaScript:goSearchAction()" <? if($nwsts1 == "Y"){ ?>checked<? } ?>>
			<INPUT type="checkbox" name="nwsts2" value="Y" onclick="JavaScript:goSearchAction()" <? if($nwsts2 == "Y"){ ?>checked<? } ?>>
			<INPUT type="checkbox" name="nwsts3" value="Y" onclick="JavaScript:goSearchAction()" <? if($nwsts3 == "Y"){ ?>checked<? } ?>>
			<INPUT type="checkbox" name="nwsts4" value="Y" onclick="JavaScript:goSearchAction()" <? if($nwsts4 == "Y"){ ?>checked<? } ?>>
		</TD>
		<TD width="70"  align="center" bgcolor="#4D4D4D" rowspan="3"><button class="button" onclick="JavaScript:goSearchAction()" style="height:70px;"></button></TD>
	</TR>
	<TR height="25">
		<TD width="60"  align="center" bgcolor="#4D4D4D"><font color="#FFFFFF"></font></TD>
		<TD width="80"  align="left" bgcolor="#FFFFFF"><? getComboList("RTP", "A", $reqchk, "reqchk", "A") ?></TD>
		<TD width="60"  align="center" bgcolor="#4D4D4D"><font color="#FFFFFF"></font></TD>
		<TD width="80"  align="left" bgcolor="#FFFFFF"><? getComboList("MNG", "A", $mngchk, "mngchk", "A") ?></TD>
		<TD width="60"  align="center" bgcolor="#4D4D4D"><font color="#FFFFFF"></font></TD>
		<TD width="80"  align="left" bgcolor="#FFFFFF"><? getComboList("STP", "",  $stpchk, "stpchk", "") ?></TD>
		<TD width="60"  align="center" bgcolor="#4D4D4D"><font color="#FFFFFF"></font></TD>
		<TD align="left" bgcolor="#FFFFFF"><INPUT type="text" name="keyword" style="width:98%;" value="<?= $keyword; ?>"></TD>
	</TR>
	<TR height="25">
		<TD width="60"  align="center" bgcolor="#4D4D4D"><font color="#FFFFFF"></font></TD>
		<TD align="left" bgcolor="#FFFFFF" colspan="7">			
			&nbsp;<INPUT type="radio" name="sortcd" value="OR2" onclick="JavaScript:goSearchAction()" <? if($sortcd == "OR2"){ ?>checked<? } ?>>  
			&nbsp;<INPUT type="radio" name="sortcd" value="SE2" onclick="JavaScript:goSearchAction()" <? if($sortcd == "SE2"){ ?>checked<? } ?>>  					
			&nbsp;<INPUT type="radio" name="sortcd" value="ORD" onclick="JavaScript:goSearchAction()" <? if($sortcd == "ORD"){ ?>checked<? } ?>> 			
			&nbsp;<INPUT type="radio" name="sortcd" value="SEQ" onclick="JavaScript:goSearchAction()" <? if($sortcd == "SEQ"){ ?>checked<? } ?>> 
		</TD>
	</TR>
</TABLE>
</FORM>

</TR>
<?
$query = "";
$query = $query."SELECT A.CATECD CATECD                   ";
$query = $query."     , E.CATENM CATENM                   ";
$query = $query."     , A.NOWSEQ NOWSEQ                   ";
$query = $query."     , A.SEQNUM SEQNUM                   ";
$query = $query."     , A.ORDDAT ORDDAT                   ";
$query = $query."     , A.ENTDAT ENTDAT                   ";
$query = $query."     , A.MENUGB MENUGB                   ";
$query = $query."     , B.DTLNME MENUNM                   ";
$query = $query."     , A.TITLE  TITLE                    ";
$query = $query."     , A.USERID USERID                   ";
$query = $query."     , A.USERNM USERNM                   ";
$query = $query."     , A.GBNCHK GBNCHK                   ";
$query = $query."     , A.NOWCHK NOWCHK                   ";
$query = $query."     , C.DTLNME CHKNME                   ";
$query = $query."     , A.ADNAME ADNAME                   ";
$query = $query."     , A.COMCHK COMCHK                   ";
$query = $query."     , A.REQTYP REQTYP                   ";
$query = $query."     , A.ENDDT1 ENDDT1                   ";
$query = $query."     , A.ENDDT2 ENDDT2                   ";
$query = $query."     , D.DTLNME REQNME                   ";
$query = $query."     , A.REQTXT REQTXT                   ";
$query = $query."  FROM REQBBSMT A                        ";
$query = $query."     , REQCODMT B                        ";
$query = $query."     , REQCODMT C                        ";
$query = $query."     , REQCODMT D                        ";
$query = $query."     , CATMNG   E                        ";
$query = $query." WHERE A.DELCHK <> 'Y'                   ";
$query = $query."   AND B.GRPCOD  = 'MNG'                 ";
$query = $query."   AND B.DTLCOD  = A.MENUGB              ";
$query = $query."   AND C.GRPCOD  = 'NST'                 ";
$query = $query."   AND C.DTLCOD  = A.NOWCHK              ";
$query = $query."   AND D.GRPCOD  = 'RTP'                 ";
$query = $query."   AND D.DTLCOD  = A.REQTYP              ";
$query = $query."   AND A.CATECD  = E.CATECD              ";
$query = $query."   AND A.NOWCHK IN (".$nowsts.")         ";
if($catecd <> ""){
	$query = $query."   AND A.CATECD  = '$catecd'           ";
}
if($reqchk <> ""){
	$query = $query."   AND A.REQTYP  = '".$reqchk."'         ";
}
if($mngchk <> ""){
	$query = $query."   AND A.MENUGB  = '".$mngchk."'         ";
}
if($stpchk == "S01"){
	$query = $query."   AND A.TITLE  LIKE '%".$keyword."%'    ";
}
else if($stpchk == "S02"){
	$query = $query."   AND A.USERNM LIKE '%".$keyword."%'    ";
}
//=====  
if($sortcd == "OR2"){
	$query = $query." ORDER BY ORDDAT DESC, case when A.REQTXT<>'' then '1' else '0' end, E.CATENM ";
}
else if($sortcd == "SE2"){
	$query = $query." ORDER BY NOWSEQ DESC, E.CATENM          ";

}
else if($sortcd == "ORD"){
	$query = $query." ORDER BY ORDDAT, E.CATENM               ";

}
else if($sortcd == "SEQ"){
	$query = $query." ORDER BY NOWSEQ, E.CATENM               ";

}
if($catecd == ""){
	$query = $query.", CATECD ASC             ";
}
else{
	$query = $query.", SEQNUM ASC             ";
}

$result = mysql_query($query);
$num_results = mysql_num_rows($result);
if($num_results == 0)
{
?>
	<TR height="25" bgcolor="#FFFFFF">
		<TD colspan="10" align="center">   .</TD>
	</TR>
<?
}
else {
	for($i = 0; $i < $num_results; $i++)
	{
		$row = mysql_fetch_array($result);
		$req_catecd = $row["CATECD"];
		$req_catenm = $row["CATENM"];

$title  = $row["TITLE"];
		$nowseq = $row["NOWSEQ"];
		$seqnum = $row["SEQNUM"];
		$usernm = $row["USERNM"];
		$orddat = $row["ORDDAT"];
		$gbnchk = $row["GBNCHK"];
		$nowchk = $row["NOWCHK"];
		$chknme = $row["CHKNME"];
		$comchk = $row["COMCHK"];
		$menugb = $row["MENUGB"];
		$menunm = $row["MENUNM"];
		$reqtyp = $row["REQTYP"];
		$enddt1 = $row["ENDDT1"];
		$enddt2 = $row["ENDDT2"];
		$reqnme = $row["REQNME"];

$adname = $row["ADNAME"];
    
		$reqtxt = $row["REQTXT"];
		$reqtxt = trim($reqtxt);

if(strlen($orddat) >= 8){
			$orddat = substr($orddat,0,4)."-".substr($orddat,4,2)."-".substr($orddat,6,2);
		}
?>
	<TR height="25" bgcolor="#FFFFFF">		
		<TD align="center"><?= $i + 1 ?></TD>
		<TD align="left"  ><?= $req_catenm ?></TD>
		<TD align="center"><?= $orddat ?></TD>
		<TD align="center"><?= $menunm ?></TD>
		<TD align="left"  >&nbsp;<a href="<?= $BBS_PATH ?>view.php?catecd=<?= $req_catecd ?>&seqnum=<?= $seqnum ?>"><?= $title ?></a></TD>
		<TD align="center"><a href="<?= $BBS_PATH ?>view.php?catecd=<?= $req_catecd ?>&seqnum=<?= $seqnum ?>"><?= $usernm ?></a></TD>		
		<TD align="center"><?= $reqnme ?></TD>
		
		<TD align="center" style="background-color:yellow;"><?= id_converter_name($adname) ?></TD>
		
		<TD align="center"><?= $chknme ?></TD>
		<TD align="center"><?= $enddt1 ?></TD>
		<TD align="center"><? if($comchk == "Y"){ ?>Y<? } ?></TD>
		<TD align="center"><? if($reqtxt <> "" ){ ?>Y<? } ?></TD>
	</TR>
<?
		}
}
?>
</TABLE>
<? include "comm/footer.php"; ?>

docroot: C:\xampp\hwsoft

curdir: C:\xampp\hwsoft\manager

	.	16384
	..	12288
	comm	4096
	images	4096
X	list(2020.08.10-1).php	9950
	reqfile	4096
X	statistics_26.04.08.php	33294
X	statistics_��.php	8617
X	view(2023.05.17).php	13221
X	view(2024.10.10).php	15193