| 번호 |
관계사 |
지점 |
판매자 |
차종 |
모델 |
등급 |
차량번호 |
주행거리 |
지역 |
차량등록일 |
입찰업체 |
입찰금액 |
입찰담당자 |
입찰일 |
낙찰업체 |
낙찰금액 |
입찰담당자 |
낙찰일 |
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
, getCode('member_master','ds_company_bp',ds_company_bp) as nm_company_bp
, getCode('member_master','ds_branch',ds_branch) as nm_branch
, s.cd_sale
, s.dt_success
, s.nm_name nm_name_sale
, s.nm_price nm_price_sale
, s.nm_price_final nm_price_final_sale
, s.nm_recommend nm_recommend_sale
, s.ds_status ds_status_sale
, s.ds_status_contract ds_status_contract_sale
, s.ds_status_contract_step1 ds_status_contract_step1_sale
, f.ds_complete_depth ds_complete_depth
, f.cd_tender cd_tender
, f.ds_lock_status ds_lock_status
, s.dt_update dt_update_sale
, (select count(*) from tender_master it where it.cd_sale = s.cd_sale) as tender_cnt
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)
left outer join tender_master f on (s.cd_sale = f.cd_sale and f.ds_status = 'Z0' and f.ds_delind = 'N')
$sql $orderby");
$i=1;
while($col = mysql_fetch_array($r)) {
// inner join tender_master t on (s.cd_sale = t.cd_sale)
$tender_sql = "select t.*
, (select nm_company from dealer_master dm where dm.cd_dealer = t.cd_dealer_p) as nm_company
from tender_master t
where cd_sale = '$col[cd_sale]'
ORDER BY cast(t.nm_price as decimal) desc";
// echo $tender_sql;
$tender_res = mysql_query($tender_sql);
$tender_num = 0;
while($tender = mysql_fetch_array($tender_res)) {
$tender_company = "";
$tender_price = "";
$tender_manager = "";
$tender_dt = "";
//낙찰업체
if($tender[ds_status] == "Z0") {
$tender_company = $tender['nm_company'];
$tender_price = number_format($tender['nm_price']).'만원';
$tender_manager = $tender['nm_name'];
$tender_dt = $col['dt_success'];
}
if($tender_num == 0) {
?>
|
|
|
|
|
|
|
|
km |
|
|
|
만원 |
|
|
|
|
|
|
|
만원 |
|
|
|
|
|
|
| 등록된 정보가 없습니다. |