echajoa/manage/buy/inc_ViewTender0515_.php

<?
	$cd_sale = $_REQUEST["cd_sale"];

	$PageNo = $_REQUEST['pageno'];
	$PageSize = $_REQUEST['PageSize'];
	if (empty($PageNo)) {$PageNo=1;}else{$PageNo=$PageNo;}
	if (empty($PageSize)) {
		$PageSize=10; //목록개수설정
	}else{$PageSize=$PageSize;}
	
	$pagestartpoint=($PageNo-1)*$PageSize;

	$OrderBy = $_REQUEST['OrderBy'];
	if( $OrderBy != "" ){
		$sOrderBy = "ORDER BY ".$OrderBy;
	}else{
		$sOrderBy = "ORDER BY t.dt_insert desc";
	}

	//$sql = "where ds_delind='N'";
	$sql = "";

	$totalrows = @mysql_result(mysql_query("select count(*) FROM dealer_master d inner join tender_master t on (d.cd_dealer = t.cd_dealer_p and t.cd_sale = $cd_sale and t.ds_delind='N' $sql) "),0,0);

?>
	<div class="area_title">
		<h3><em>▶</em> 입찰업체 리스트</h3>
		<span class="select">
			<select onchange="location.href='./buy_view.php?list_url=<?=$list_url?>&cd_sale=<?=$cd_sale?>&ds_status_sale=<?=$ds_status_sale?>&ListPageNo=<?=$ListPageNo?>&OrderBy='+this.value;">
				<option value="t.dt_insert"<? if($OrderBy=="t.dt_insert"){ ?> selected<? } ?>>최근순</option>
				<option value="t.nm_price desc"<? if($OrderBy=="t.nm_price desc"){ ?> selected<? } ?>>입찰가격 높은순</option>
				<option value="t.nm_price"<? if($OrderBy=="t.nm_price"){ ?> selected<? } ?>>입찰가격 낮은순</option>
			</select>
		</span>
	</div>
	<div class="tbl_wrap">
		<table class="tbl_list ty2">
			<colgroup>
				<col width="7%">
				<col width="*">
				<col width="12%">
				<col width="10%">
				<col width="14%">
				<col width="10%">
			</colgroup>
			<thead>
			<tr>
				<th>번호</th>
				<th>입찰업체</th>
				<th>입찰금액</th>
				<th>담당자</th>
				<th>연락처</th>
				<th>입찰일</th>
			</tr>
			</thead>
<?
		if($totalrows>0) {

			$r = mysql_query("SELECT t.*, d.nm_name nm_company FROM dealer_master d inner join tender_master t on (d.cd_dealer = t.cd_dealer_p and t.cd_sale = $cd_sale and t.ds_delind='N' $sql) $sOrderBy LIMIT $pagestartpoint,$PageSize");

			$i=1;
			while($col = mysql_fetch_array($r)) { 
?>
			<tr<? if($col[ds_status] == "Z0"){ ?> bgcolor="fffaa7"<? } ?>>
				<td><?=$i?></td>
				<td><?=$col[nm_company]?></td>
				<td><?=$col[nm_price]?>만원</td>
				<td><?=$col[nm_name]?></td>
				<td><?=$col[nm_hp]?></td>
				<td><?=$col[dt_insert]?></td>
			</tr>
<?
				$i++;
			}
		}else{
?>
			<tr>
				<td colspan="6">데이터가 존재 하지 않습니다.</td>
			</tr>
<?
		}
?>
		</table>
	</div>

	<div class="paging">
		<?
				$url = "./buy_view.php?list_url=$list_url&cd_sale=$cd_sale&ds_status_sale=$ds_status_sale&ListPageNo=$ListPageNo&PageNo=$PageNo";
				ListPg1($url ,$PageNo,$PageSize,10,$totalrows,$leftboard[1],$rootpath);
		?>
	</div>