include("../inc/inc_top.php") ?>
include("../inc/inc_header.php") ?>
$cd_dealer = $_REQUEST["cd_dealer"];
$sql ="SELECT
*
FROM aap_master
WHERE cd_dealer='$cd_dealer' AND ds_delind='N'";
$mode = "Add";
$col=mysql_fetch_array(mysql_query($sql));
if (!empty($col['cd_dealer'])){
$cd_dealer = $col['cd_dealer'];
$cd_dealerid = $col['cd_dealerid'];
$cd_dealer_p = $col['cd_dealer_p'];
$nm_pass = $col['nm_pass'];
$ds_type = $col['ds_type'];
$ds_level = $col['ds_level'];
$nm_company = $col['nm_company'];
$nm_name = $col['nm_name'];
$nm_birth = $col['nm_birth'];
$nm_tel_01 = $col['nm_tel_01'];
$nm_tel_02 = $col['nm_tel_02'];
$nm_tel_03 = $col['nm_tel_03'];
$nm_hp_01 = $col['nm_hp_01'];
$nm_hp_02 = $col['nm_hp_02'];
$nm_hp_03 = $col['nm_hp_03'];
$nm_fax_01 = $col['nm_fax_01'];
$nm_fax_02 = $col['nm_fax_02'];
$nm_fax_03 = $col['nm_fax_03'];
$nm_email = $col['nm_email'];
$nm_zip = $col['nm_zip'];
$nm_addr = $col['nm_addr'];
$nm_addr_sub = $col['nm_addr_sub'];
$nm_etc_01 = $col['nm_etc_01'];
$nm_etc_02 = $col['nm_etc_02'];
$nm_etc_03 = $col['nm_etc_03'];
$ds_status = $col['ds_status'];
$nm_company_biz = $col['nm_company_biz'];
$nm_name_biz = $col['nm_name_biz'];
$nm_no_biz = $col['nm_no_biz'];
$nm_date_biz = $col['nm_date_biz'];
$nm_type_biz = $col['nm_type_biz'];
$nm_condition_biz = $col['nm_condition_biz'];
$nm_tel_biz_01 = $col['nm_tel_biz_01'];
$nm_tel_biz_02 = $col['nm_tel_biz_02'];
$nm_tel_biz_03 = $col['nm_tel_biz_03'];
$nm_hp_biz_01 = $col['nm_hp_biz_01'];
$nm_hp_biz_02 = $col['nm_hp_biz_02'];
$nm_hp_biz_03 = $col['nm_hp_biz_03'];
$nm_fax_biz_01 = $col['nm_fax_biz_01'];
$nm_fax_biz_02 = $col['nm_fax_biz_02'];
$nm_fax_biz_03 = $col['nm_fax_biz_03'];
$nm_email_biz = $col['nm_email_biz'];
$nm_zip_biz = $col['nm_zip_biz'];
$nm_addr_biz = $col['nm_addr_biz'];
$nm_addr_sub_biz = $col['nm_addr_sub_biz'];
$dt_insert = $col['dt_insert'];
$nm_insert = $col['nm_insert'];
$dt_update = $col['dt_update'];
$nm_update = $col['nm_update'];
$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";
}
?>
구매확정 리스트
| 상호 |
=$nm_name?> |
핸드폰 |
=$nm_hp_01."-".$nm_hp_02."-".$nm_hp_03?> |
| 승인 상태 |
=($ds_status == "Z0") ? "승인":"미승인" ?> |
|
|
▶ 낙찰정보
$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;
$add_sql = "where s.ds_delind='N'";
$searchtype = $_REQUEST['searchtype'];
$searchword = $_REQUEST['searchword'];
$ds_usertype = $_REQUEST['ds_usertype'];
$ds_status = $_REQUEST['ds_status'];
$dt_end_start = $_REQUEST['dt_end_start'];
$dt_end_end = $_REQUEST['dt_end_end'];
$cd_dealer = $_REQUEST['cd_dealer'];
$ds_type = "A0"; //A0 : 매입
$add_sql.= " and s.ds_type = '$ds_type' ";
$add_sql.= " and t.cd_dealer_p = '$cd_dealer' ";
if($searchword != ""){
if($searchtype=="" || $searchtype==null){
$add_sql.= " and (s.nm_name like '$searchword%' or a.nm_number like '$searchword%') ";
}else{
$add_sql.= " and $searchtype like '$searchword%'";
}
}
if($dt_end_start != "" && $dt_end_end != ""){
$add_sql.= " and s.dt_end between '$dt_end_start' and '$dt_end_end' ";
}
if($ds_usertype != ""){
$add_sql.= " and s.ds_usertype = '$ds_usertype'";
}
$add_sql.= " and s.ds_status in ('ZS') ";
$sql = "select count(*)
from sale_master s
inner join tender_master t on (s.cd_sale = t.cd_sale and t.ds_status = 'Z0' AND t.ds_delind = 'N')
inner join car_master a on ( s.cd_car = a.cd_car ) $add_sql";
$totalrows = @mysql_result(mysql_query($sql),0,0);
?>
총 낙찰 건수 : =$totalrows?>건
| 번호 |
판매자 |
차종 |
차량번호 |
판매지역 |
판매금액 |
낙찰자 |
판매완료일 |
if($totalrows>0) {
$r = mysql_query("SELECT
a.*
, b.nm_model
, d.nm_brand
, 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
, s.dt_end dt_end_sale
FROM sale_master s
inner join tender_master t on (s.cd_sale = t.cd_sale and t.ds_status = 'Z0' AND t.ds_delind = 'N')
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_brand d on (a.cd_brand = d.cd_brand)
$add_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_final_sale']?>만원 |
=$col['nm_name_tender']?> |
=$col['dt_end_sale']?> |
$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);
?>