mo0647
/
echajoa


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133
							<?php
	$file_name = "딜러리스트_".date("Y-m-d").".xls";
	Header("Content-type: charset=utf-8");
	Header("Content-type: application/octet-stream");
	header( "Content-type: application/vnd.ms-excel;charset=utf-8" );
	Header("Content-Disposition: attachment; filename=$file_name");
	Header("Pragma: no-cache");
	Header("Expires: 0");
	header( "Content-Description: PHP5 Generated Data" );

	include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
	include $_SERVER['DOCUMENT_ROOT'].ADMIN_PATH.'common/auth_chk.php';

	$mp = "21";	//set top nav

	$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;
	$sql = "where ds_delind='N'";

	$searchtype = $_REQUEST['searchtype'];
	$searchword = $_REQUEST['searchword'];
	$ds_status = $_REQUEST['ds_status'];
	$dt_start = $_REQUEST['dt_start'];
	$dt_end = $_REQUEST['dt_end'];

	$ds_type = "D0";
	$sql = $sql. "	and ds_type = '$ds_type' ";

	if($searchword != ""){
		if($searchtype=="" || $searchtype==null){
			$sql = $sql. "	and (nm_name like '$searchword%' or cd_dealerid like '$searchword%') ";
		}else{
			$sql = $sql. "	and $searchtype like '$searchword%'";
		}
	}
	if($ds_status != ""){
		if($ds_status == "Z0"){
			$sql = $sql. "	and ds_status = 'Z0' ";
		}else{
			$sql = $sql. "	and (ds_status is null or ds_status != 'Z0') ";
		}
	}
	if($dt_start != "" && $dt_end != ""){
		$sql = $sql. "	and dt_insert between '$dt_start' and '$dt_end' ";
	}
	$totalrows = @mysql_result(mysql_query("select count(*) from dealer_master $sql"),0,0);

?>
<!DOCTYPE html>
<HTML lang="ko">
<head>
<meta charset="UTF-8" />
</head>
<body>
<table border="1">
<tr>
	<th>번호</th>
	<th>아이디</th>
	<th>상호명</th>
	<th>대표자</th>
	<th>관리자</th>
	<th>관리자 연락처</th>
	<th>부관리자</th>
	<th>부관리자 연락처</th>
	<th>최근입찰시간</th>
</tr>
<?
	if($totalrows>0) {

		$r = mysql_query("SELECT * FROM dealer_master $sql ORDER BY cd_dealer desc");
		$i=1;
		while($col = mysql_fetch_array($r)) {

			$tmpNum =$totalrows-($PageSize*($PageNo-1));

			$sub_dealer_q = "SELECT *
								, (SELECT dt_insert FROM tender_master WHERE cd_dealer = d.cd_dealer ORDER BY cd_tender DESC LIMIT 1) as recent_date
								FROM dealer_master d
									WHERE cd_dealer_p = '$col[cd_dealer]'
								ORDER BY cd_dealer desc";
			$sub_dealer_r = mysql_query($sub_dealer_q);
			$sub_dealer_rows = mysql_num_rows($sub_dealer_r);

			$tender_num = 0;
			while($sub_dealer_col = mysql_fetch_array($sub_dealer_r)) {
				if($tender_num == 0) {
?>
		<tr>
			<td rowspan="<?=$sub_dealer_rows?>"><?=$i?></td>
			<td rowspan="<?=$sub_dealer_rows?>"><?=$col[cd_dealerid]?></td>
			<td rowspan="<?=$sub_dealer_rows?>"><?=$col[nm_company]?></td>
			<td rowspan="<?=$sub_dealer_rows?>"><?=$col[nm_name_biz]?></td>
			<td rowspan="<?=$sub_dealer_rows?>"><?=$col[nm_name]?></td>
			<td rowspan="<?=$sub_dealer_rows?>"><?=$col[nm_hp_01]."-".$col[nm_hp_02]."-".$col[nm_hp_03]?></td>
			<td><?=$sub_dealer_col[nm_name]?></td>
			<td><?=$sub_dealer_col[nm_hp_01]."-".$sub_dealer_col[nm_hp_02]."-".$sub_dealer_col[nm_hp_03]?></td>
			<td><?=$sub_dealer_col[recent_date]?></td>
		</tr>
<?
				}else {
?>
		<tr>
			<td><?=$sub_dealer_col[nm_name]?></td>
			<td><?=$sub_dealer_col[nm_hp_01]."-".$sub_dealer_col[nm_hp_02]."-".$sub_dealer_col[nm_hp_03]?></td>
			<td><?=$sub_dealer_col[recent_date]?></td>
		</tr>
<?
				}

				$tender_num++;
			}
			$i++;
		}
	}else{
?>
<tr>
	<td colspan="9">데이터가 존재 하지 않습니다.</td>
</tr>
<?
	}
?>
</table>
</body>
</html>
<?
mysql_close($connect);
?>