구매확정 리스트
| 상호 |
=$nm_company?> |
핸드폰 |
=$nm_hp_01."-".$nm_hp_02."-".$nm_hp_03?> |
| 대표 |
=$nm_name?> |
연락처 |
=$nm_tel_01."-".$nm_tel_02."-".$nm_tel_03?> |
| 팩스번호 |
=$nm_fax_01."-".$nm_fax_02."-".$nm_fax_03?> |
승인 상태 |
=($ds_status == "Z0") ? "승인":"미승인" ?> |
| 주소 |
=$nm_addr." ".$nm_addr_sub?> |
▶ 낙찰정보
$list_url = "purchase_view.php";
$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 s.ds_delind='N'";
$searchtype = $_REQUEST['searchtype'];
$searchword = $_REQUEST['searchword'];
$ds_usertype = $_REQUEST['ds_usertype'];
$ds_status = $_REQUEST['ds_status'];
$dt_start = $_REQUEST['dt_start'];
$dt_end = $_REQUEST['dt_end'];
$cd_dealer = $_REQUEST['cd_dealer'];
$ds_type = "A0"; //A0 : 매입
$sql = $sql. " and s.ds_type = '$ds_type' ";
$sql = $sql. " and t.cd_dealer_p = '$cd_dealer' ";
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($dt_start != "" && $dt_end != ""){
$sql = $sql. " and s.dt_insert between '$dt_start' and '$dt_end' ";
}
if($ds_usertype != ""){
$sql = $sql. " and s.ds_usertype = '$ds_usertype'";
}
$sql = $sql. " and s.ds_status in ('ZS') ";
$totalrows = @mysql_result(mysql_query("select count(*) from sale_master s inner join tender_master t on (s.cd_sale = t.cd_sale and t.ds_status = 'Z0') inner join car_master a on ( s.cd_car = a.cd_car ) $sql"),0,0);
?>
총 낙찰 건수 : =$totalrows?>건
| 번호 |
판매자 |
차종 |
차량번호 |
지역 |
낙찰금액 |
낙찰자 |
등록일 |
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_recommend nm_recommend_sale
, s.ds_status ds_status_sale
, s.ds_status_contract ds_status_contract_sale
, s.nm_price_final nm_price_final_sale
, t.nm_name nm_name_tender
, t.nm_price nm_price_tender
FROM sale_master s
inner join tender_master t
on (s.cd_sale = t.cd_sale and t.ds_status = 'Z0')
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 $pagestartpoint,$PageSize");
$i=1;
while($col = mysql_fetch_array($r)){
$tmpNum =$totalrows-($PageSize*($PageNo-1));
$no = ($tmpNum - $i)+1;
?>
| =$no?> |
=$col['nm_name_sale']?> |
=$col['nm_brand']." ".$col['nm_model']?> |
=$col['nm_number']?> |
=$col['nm_area']?> |
=$col['nm_price_tender']?>만원 |
=$col['nm_name_tender']?> |
=$col['dt_insert']?> |
$i++;
}
}else{
?>
| 등록된 정보가 없습니다. |
}
?>
$url = "./$list_url?searchtype=$searchtype&searchword=$searchword&cd_dealer=$cd_dealer";
ListPg1($url ,$PageNo,$PageSize,10,$totalrows,$leftboard[1],$rootpath);
?>
include("../inc/inc_footer.php") ?>
include("../inc/inc_bottom.php") ?>
mysql_close($connect);
?>