경매리스트에도 남음 시간 표현하기...

초미님을 위해......^^

아래의 소스는 auction.php의 내용입니다....그대로 복사해서 소스 교체 하신 후
업로드 해서 확인하신 다음 원하시는데로 바꾸시길 바랍니다....
꼭 원본은 백업을 하시길 바라고.....

★★★★★★★★★ 소스 나갑니다... auction.php 입니다....★★★★★★★★★

<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가

define("_DOCTYPE_", "DESIGN");

include "./$cfg[shop_dir]/shop.lib.php";

$html_title = "경매";

echo navigation($html_title);

$base_qstr = "doc=$doc";

if ($is_admin == 'default') {
echo "[<a href='./?doc=$cfg[shop_dir]/admin/auctionlist.php'>관리</a>]";
}
?>

<table width=100% border=0 cellpadding=3 cellspacing=1 class=tablebg>
<colgroup width=40>
<colgroup width=''>
<colgroup width=160>
<colgroup width=70>
<colgroup width=70>
<colgroup width=50>
<tr class='subject subjectbg' height=30 align=center>
<td><?=subject_sort_link('au_id', $base_qstr)?>번호</a></td>
<td><?=subject_sort_link('au_subject', $base_qstr)?>제목</a></td>
<td><?=subject_sort_link('au_fr_datetime', $base_qstr)?>시작일</a> / <?=subject_sort_link('au_to_datetime', $base_qstr)?>마감일</a></td>
<td>현재가</td>
<td><?=subject_sort_link('cnt', $base_qstr)?>입찰수</a></td>
<td>상태</td>
</tr>

<?
if (!$ssort) {
$ssort = "au_id";
$sorder = "desc";
}

$from = " $cfg[table_auction] a
left join $cfg[table_tbidder] b on (a.au_id = b.au_id) ";

$query = new listQuery();
$query->select(" a.au_id, a.au_subject, a.au_fr_datetime, a.au_to_datetime, a.au_sijakga, a.au_juksiga, a.au_qty ");
$query->from($from);
$query->where($sselect, $stext, $condition);
$query->order($ssort, $sorder);
$query->group(" count(b.bi_id) as cnt, max(b.bi_ipchalga) as hyunjaega, sum(b.bi_qty) as sum_qty ");
$query->limit($cfg[list_rows], $page);
$sql = $query->result();
$result = sql_query($sql);
for ($i=0; $row=mysql_fetch_array($result); $i++) {

$status = get_auction_status($row);

$au_subject = conv_subject($row[au_subject], 100, "…");

// 낙찰 수량을 얻는다
$sum_nakchal_qty = get_nakchal_qty($row[au_id]);

// 입찰이 없다면 시작가가 현재가
if ($row[hyunjaega]) {
$hyunjaega = $row[hyunjaega];
} else {
$hyunjaega = $row[au_sijakga];
}

// 모두 낙찰되었다면 종료
if ($row[au_juksiga] && $sum_nakchal_qty == $row[au_qty]) {
$is_end = true;
} else if ($now > $row[au_to_datetime]) {
$is_end = true;
}

$comment_cnt = "";
$sql2 = " select count(*) from $cfg[table_tcomment]
where au_id = '$row[au_id]' ";
$row2 = sql_fetch($sql2);
if ($row2[0]) {
$comment_cnt = " <span style='font-size:8pt;'>($row2[0])</span>";
}

$list = ($i%2);
echo "<tr class='list$list ht lh' align=center>";
echo "<td>$row[au_id]</td>";
echo "<td align=left>&nbsp;<a href='./?doc=$cfg[shop_dir]/auctiondetail.php&au_id=$row[au_id]'>$au_subject</a>{$comment_cnt}</td>";
echo "<td>$row[au_fr_datetime] (".get_yoil($row[au_fr_datetime]).")<br>";
echo "$row[au_to_datetime] (".get_yoil($row[au_to_datetime]).")</td>";
echo "<td align=right>".nf($hyunjaega)." 원&nbsp;</td>";
echo "<td>".nf($row[cnt])."&nbsp;</td>";
?>
<script language="JavaScript">
<?
$tgap = strtotime($row[au_to_datetime]) - time();
$tday = (int)($tgap / 86400);
$thour = (int)(($tgap - ($tday * 86400)) / 3600);
$tmin = (int)(($tgap - ($tday * 86400 + $thour * 3600)) / 60);
$tsec = (int)($tgap - ($tday * 86400 + $thour * 3600 + $tmin * 60));
?>

var tday = <?=$tday?>;
var thour = <?=$thour?>;
var tmin = <?=$tmin?>;
var tsec = <?=$tsec?>;

function runtimer()
{
var s = "";

if (tday > 0)
s += tday + "일";

if (thour > 0 || s != "") {
if (s != "") s += " ";
s += thour + "시간";
}

if (tmin > 0 || s != "") {
if (s != "") s += " ";
s += tmin + "분";
}

if (tsec > 0 || s != "") {
if (s != "") s += " ";
s += tsec + "초";
}

if (s == "") {
document.fdetail.timer.value = "경매가 마감 되었습니다";
return;
}

document.fdetail.timer.value = s;

tsec--;
if (tsec < 0) {
tsec = 59;
tmin--;
}

if (tmin < 0) {
tmin = 59;
thour--;
}

if (thour < 0) {
thour = 23;
tday--;
}

window.setTimeout('runtimer()',1000);
}
</script>
<form name=fdetail>
<td>
<? if ($is_end) { ?>
<font color=crimson><b>경매 마감</b></font>
<? } else { ?>
<input type="text" name="timer" style='background-color: #ffffff ; border-style:none 0px; color:crimson; font-weight:bold;height:16; font-size:12; border-width: 0px;' readonly>
<script> runtimer(); </script>
<? } ?>
</td>
</form>
<?
echo "</tr>";
}

if ($i == 0) {
echo "<tr><td colspan=9 align=center height=100 class='content contentbg'>자료가 없습니다.</td></tr>";
}

echo "</table>";

$pagelist = get_paging($default[de_write_pages], $query->page, $query->total_page, $rows, "./?$base_qstr&$shop_qstr&page=");
if ($pagelist) {
echo "<table width=100% cellpadding=3 cellspacing=1><tr><td align=right>$pagelist</td></tr></table>\n";
}

if ($stext) {
echo "<script>document.fsearch.sselect.value = '$sselect';</script>";
}
?>

<table width=100% cellpadding=3 cellspacing=1>
<form name=fsearch method=get action='./'>
<input type=hidden name=doc value='<?=$doc?>'>
<tr>
<td align=center>
<select name=sselect>
<option value='au_subject'>제목</option>
<option value='au_id'>번호</option>
</select>
<input type=text name=stext class=input required itemname='검색어' value='<?=$stext?>'>
<input type=submit value='검색'></td>
</tr>
</form>
</table>

<?
include "./$cfg[shop_dir]/admin/tail.php";
?>

[이 게시물은 관리자님에 의해 2003-11-25 11:46:04 그샵팁텍(으)로 부터 이동됨]