mo0647
/
echajoa


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358
							<?php
	include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
	include $_SERVER['DOCUMENT_ROOT'].'/common/user_chk.php';

?>
<!DOCTYPE html>
<HTML lang="ko">
<head>
<meta charset="utf-8">
<title>UPRO</title>
<meta name="viewport" content="user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0, width=device-width">
<meta name="format-detection" content="telephone=no">
<link rel="stylesheet" type="text/css" href="/m/css/common.css">
<link rel="stylesheet" type="text/css" href="/m/css/sub.css">
<script type="text/javascript" charset="utf-8" src="/m/js/jquery-1.11.2.min.js"></script>
<script type="text/javascript" charset="utf-8" src="/m/js/ui.js"></script>
<script type="text/javascript" src="<?=JS_PATH?>"></script>
</head>

<body>
<!-- s : header -->
<? include("../inc/inc_header.php"); ?>
<!-- // e : header -->

<!-- s : container -->
<section id="container">
	<section id="visual" class="visual_mypage">
		<h2>마이페이지</h2>
		<p>쉽고 간편한 내차팔기, 견적산출,<br>최종 매각까지 어떤 수수료도 요구하지 않습니다.</p>
	</section>

	<section id="content">
		<div class="tit_wrap">
			<h3>회원정보</h3>
			<a href="modify.php" class="button">정보수정</a>
		</div>
        
<?
	$cd_user = $_SESSION['s_cd_user'];

	$sql ="SELECT 
				* 
				FROM member_master 
				WHERE cd_user='$cd_user' AND ds_delind='N'";
	
	$mode = "Add";

	$col=mysql_fetch_array(mysql_query($sql));
	if (!empty($col[cd_user])){ 
		$cd_user = $col[cd_user];
		$cd_userid = $col[cd_userid];
		$nm_email = $col[nm_email];
		$nm_pass = $col[nm_pass];
		$nm_join = $col[nm_join];
		$ds_type = $col[ds_type];
		$ds_level = $col[ds_level];
		$nm_birth = $col[nm_birth];
		$nm_name = $col[nm_name];
		$nm_company = $col[nm_company];
		$nm_hp = $col[nm_hp];
		$nm_hp_01 = $col[nm_hp_01];
		$nm_hp_02 = $col[nm_hp_02];
		$nm_hp_03 = $col[nm_hp_03];
		$nm_tel = $col[nm_tel];
		$nm_tel_01 = $col[nm_tel_01];
		$nm_tel_02 = $col[nm_tel_02];
		$nm_tel_03 = $col[nm_tel_03];
		$nm_fax = $col[nm_fax];
		$nm_fax_01 = $col[nm_fax_01];
		$nm_fax_02 = $col[nm_fax_02];
		$nm_fax_03 = $col[nm_fax_03];
		$nm_zip = $col[nm_zip];
		$nm_addr = $col[nm_addr];
		$nm_addr_sub = $col[nm_addr_sub];
		$ds_area = $col[ds_area];
		$ds_area_sub = $col[ds_area_sub];
		$nm_etc_01 = $col[nm_etc_01];
		$nm_etc_02 = $col[nm_etc_02];
		$nm_etc_03 = $col[nm_etc_03];
		$nm_etc_04 = $col[nm_etc_04];
		$nm_etc_05 = $col[nm_etc_05];
		$ds_agree1 = $col[ds_agree1];
		$ds_agree2 = $col[ds_agree2];
		$ds_agree3 = $col[ds_agree3];
		$ds_agree4 = $col[ds_agree4];
		$ds_agree5 = $col[ds_agree5];
		$ds_status = $col[ds_status];
		$ds_status_agree = $col[ds_status_agree];
		$dt_insert = $col[dt_insert];
		$nm_insert = $col[nm_insert];
		$dt_update = $col[dt_update];
		$nm_update = $col[nm_update];
		$dt_delind = $col[dt_delind];
		$nm_delind = $col[nm_delind];
		$ds_delind = $col[ds_delind];
/*
		$arr_nm_info1 = explode("-",$nm_info1);
		if(count($arr_nm_info1) == 3){
			$nm_info11 = $arr_nm_info1[0];
			$nm_info12 = $arr_nm_info1[1];
			$nm_info13 = $arr_nm_info1[2];
		}else{
			$nm_info11 = "";
			$nm_info12 = "";
			$nm_info13 = "";
		}

		$arr_nm_info3 = explode("@",$nm_info3);
		if(count($arr_nm_info3) == 2){
			$nm_info31 = $arr_nm_info3[0];
			$nm_info32 = $arr_nm_info3[1];
		}else{
			$nm_info31 = "";
			$nm_info32 = "";
		}
		$nm_info3 = $col[nm_info3];
*/
		$mode = "Update";
	}else{
		$ds_level = "1";
	}

?>

		<table class="tbl_h">
			<colgroup>
				<col width="23%">
				<col width="*">
			</colgroup>
			
			<tr>
				<th>이름</th>
				<td><?=$nm_name?></td>
			</tr>
			<tr>
				<th>아이디</th>
				<td><?=$nm_email?></td>
			</tr>
			<tr>
				<th>연락처</th>
				<td><?=$nm_hp?></td>
			</tr>
			<tr>
				<th>회원가입일</th>
				<td><?=$dt_insert?></td>
			</tr>
		
		</table>

		<div class="tit_wrap">
			<h3>입찰내역</h3>
			<a href="/m/mypage/sell_list.php" class="button">+더보기</a>
		</div>
		<ul class="tender_list">
<?

	$cd_user = $_SESSION['s_cd_user'];

	$PageNo = $_REQUEST['pageno'];
	$PageSize = $_REQUEST['PageSize'];
	if (empty($PageNo)) {$PageNo=1;}else{$PageNo=$PageNo;}
	if (empty($PageSize)) {
		$PageSize=8; //목록개수설정
	}else{$PageSize=$PageSize;}
	
	$pagestartpoint=($PageNo-1)*$PageSize;
	$sql = "where s.ds_delind='N'";

	$sql = $sql. "	and s.cd_user='$cd_user' ";

	$searchtype = $_REQUEST['searchtype'];
	$searchword = $_REQUEST['searchword'];
	$ds_usertype = $_REQUEST['ds_usertype'];
	$ds_status = 'Z0';

	$ds_type = "A0";	//A0 : 매입
	$sql = $sql. "	and s.ds_type = '$ds_type' ";

	if($searchword != ""){
		if($searchtype=="" || $searchtype==null){
			$sql = $sql. "	and (s.nm_name like '$searchword%' or a.nm_number like '$searchword%') ";
		}else{
			$sql = $sql. "	and $searchtype like '$searchword%'";
		}
	}

	if($ds_usertype != ""){
		$sql = $sql. "	and s.ds_usertype = '$ds_usertype'";
	}

	$sql = $sql. "	and s.ds_status in ('B0','C0','D0','E0','F0','G0','Z0')";

//	$sql = $sql. "	and s.dt_approve >=  DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_SELL."' HOUR) ";

	$totalrows = @mysql_result(mysql_query("select count(*) from sale_master s inner join car_master a on (	s.cd_car = a.cd_car ) $sql"),0,0);

$orderby = "order by s.dt_insert desc";

if($totalrows>0) {

$r = mysql_query("SELECT 
						a.* 
						, b.nm_model 
						, c.nm_grade 
						, d.nm_brand 
						, e.nm_model_sub 
						, getCode('car_master','ds_type',a.ds_type) as nm_type 
						, getCode('car_master','ds_open',a.ds_open) as nm_open 
						, getCode('car_master','ds_sales',a.ds_sales) as nm_sales 
						, getCode('car_master','ds_transmission',a.ds_transmission) as nm_transmission 
						, getCode('member_master','ds_area',s.ds_area) as nm_area 
						, getCode('sale_master','ds_status',s.ds_status) as nm_status 
						, s.cd_sale 
						, s.nm_name nm_name_sale 
						, s.nm_price nm_price_sale 
						, s.ds_status ds_status_sale 
						, case when s.ds_status in ('B0','C0') then '미승인' when s.ds_status in ('D0') then '반려' when s.ds_status in ('E0','F0') then '입찰중' when s.ds_status in ('G0') then '입찰마감' when s.ds_status in ('Z0') then '낙찰' when s.ds_status in ('ZS') then '구매확정' else '' end as nm_status_sale 
						, case when a.nm_act_yn in ('Y') then '유'  else '무' end as nm_act_yn_name 
						, getRemainTime(".LIMIT_TIME_SELL.", s.dt_approve, now()) as time_limit_sell  
						FROM sale_master s 
							inner join car_master a 
							on (s.cd_car = a.cd_car) 
							left outer join car_model b 
							on (a.cd_model = b.cd_model)
							left outer join car_grade c 
							on (a.cd_grade = c.cd_grade) 
							left outer join car_brand d 
							on (a.cd_brand = d.cd_brand)
							left outer join car_model_sub e 
							on (a.cd_model_sub = e.cd_model_sub)
							$sql $orderby LIMIT 0,2");

$i=1;
while($col = mysql_fetch_array($r)) { 

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

?>
			<li onclick="location.href='./sell_view.php?list_url=<?=$list_url?>&cd_sale=<?=$col[cd_sale]?>&ds_status_sale=<?=$col[ds_status_sale]?>&ListPageNo=<?=$PageNo?>';" style="cursor:pointer;">
				<p><span>차종</span> <?=$col[nm_brand]." ".$col[nm_model]?></p>
				<p><span>년식</span> <?=$col[ds_year]?>년</p>
				<p><span>지역</span> <?=$col[nm_area]?></p>
				<p><span>판매일</span> 2018.01.23</p>
				<p><span>처리상태</span> <strong class="txt_black"><? if($col[time_limit_sell]=="0분" && ($col[ds_status_sale] == "E0" || $col[ds_status_sale] == "F0")){ ?>거래마감<? }else{ ?><?=$col[nm_status_sale]?><? } ?></strong></p>
			</li>
<?
	$i++;
}
}else{
?>
			<li>
				<p>등록된 정보가 없습니다.</p>
			</li>
<?
}
?>
		</ul>

		<div class="tit_wrap">
			<h3>문의내역</h3>
			<a href="/m/mypage/qna_list.php?cd_board=02&ds_kind=A" class="button">+더보기</a>
		</div>
       	<ul class="board_list">
        
        
        
         <?
	$cd_board = "02";
	$ds_kind = "A";
	$s_cd_user = $_SESSION['s_cd_user'];
	$s_cd_dealer = $_SESSION['s_cd_dealer'];

	if($ds_kind == "D"){
		$cd_user = $s_cd_dealer;
	}else{
		$cd_user = $s_cd_user;
	}

	if (empty($PageNo)) {$PageNo=1;}else{$PageNo=$PageNo;}
	$PageSize=2; //목록개수설정
	$pagestartpoint=($PageNo-1)*$PageSize;
	$sql = "where cd_board='$cd_board' and ds_delind='N'";
	$sql = $sql." and ds_kind='$ds_kind' ";
	$sql = $sql." and cd_user='$cd_user' ";
	
	if($searchword != ""){
		if($searchtype=="" || $searchtype==null){
			$sql = $sql. "	and (nm_title like '$searchword%' or nm_content like '$searchword%' or cd_userid like '$searchword%')";
		}else{
			$sql = $sql. "	and $searchtype like '$searchword%'";
		}
	}

	$totalrows = @mysql_result(mysql_query("select count(*) from board_master $sql"),0,0);

		if($totalrows>0) {
			$r = mysql_query("SELECT * FROM board_master  $sql ORDER BY ds_top desc, no_famally ASC, no_order ASC  LIMIT 0,2");
			$i=1;
			while($col = mysql_fetch_array($r)) { 
				$date = strtotime ($col[dt_insert]);
				$view_date = strtotime ("-1 day",time());
				if($date >= $view_date) {
					$newicon = " <img src='".ADMIN_PATH."img/i_new.gif' style='margin-top:1px;' /> ";
				} else { 
					$newicon = "";
				}

				if($col[no_step]>0){
					$padding = $col[no_step] * 8;
					$step = "<span style=\"padding-left:".$padding."px\"/>";
				}

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

?>
	
       
			<li onclick="location.href='./qna_view.php?cd_board=<?=$cd_board?>&ds_kind=<?=$ds_kind?>&cd_seq=<?=$col[cd_seq]?>&PageNo=1';" style="cursor: pointer; cursor: hand;">
            <? if($cd_board=="99"){?> <?}?>
				<a href="#"><?=text_cut($col[nm_title],50)?></a>
				<span class="date"><?=$col[dt_insert]?></span>
			<? if($cd_board=="02"){?>
            <span class="reply finish"><?=($col[nm_reply] == "") ? "미답변" : "답변완료" ?></span>
                
           	<?}?>
			</li>
<?
	$i++;
}
}else{
?>
	        <li>
				등록된 정보가 없습니다.
			</li>
<?
}
?>
	
		
		
		</ul>

		
	</section>
</section>
<!-- e : container -->

<!-- s : footer -->
<? include("../inc/inc_footer.php"); ?>
<!-- // e : footer -->

</body>
</html>
<?
mysql_close($connect);
?>