0 ){ $upload_file_report_back_name = upload($_FILES['nm_file_report_back'],$upload_path, 500, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_report_back_name==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } if (is_uploaded_file($_FILES['nm_file_report']['tmp_name'])) { if($_FILES['nm_file_report']['size'] > 0 ){ $upload_file_report_name = upload($_FILES['nm_file_report'],$upload_path, 500, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_report_name==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } }*/ if (is_uploaded_file($_FILES['nm_file_chk']['tmp_name'])) { if($_FILES['nm_file_chk']['size'] > 0 ){ $upload_file_chk_name = upload($_FILES['nm_file_chk'],$upload_path."nm_file_chk/", 800, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_chk_name==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } if (is_uploaded_file($_FILES['nm_file_act']['tmp_name'])) { if($_FILES['nm_file_act']['size'] > 0 ){ $upload_file_act_name = upload($_FILES['nm_file_act'],$upload_path."nm_file_act/", 800, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_act_name==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } $sql="insert into car_master (cd_model, cd_grade, ds_type, ds_year, nm_mileage , nm_price, nm_name , ds_driving_system, ds_oil, nm_gearbox , nm_color, nm_incolor, ds_accident , nm_cont_accident , ds_transmission , nm_regdate, ds_sales , nm_btitle, nm_stitle, nm_cont , nm_file_report , nm_file_report_back , nm_file_main, nm_file_list, ds_logo, cd_brand, cd_category , ds_open, ds_status, dt_insert, nm_insert, dt_update, nm_update, ds_delind , nm_number, nm_cc, ds_trade, nm_regdate_yyyy, nm_regdate_mm, nm_regdate_dd, nm_guide, ds_main , nm_ltitle , ds_cate , nm_chk_178_q1 , nm_chk_178_q2 , nm_chk_178_q3 , nm_chk_178_q4 , nm_chk_178_q5 , nm_chk_178_q6 , nm_chk_178_q7 , nm_chk_178_q8 , nm_chk_178_q9 , nm_chk_178_q10 , nm_chk_178_q11 , nm_chk_178_q12 , nm_chk_178_q13 , nm_chk_carno , nm_chk_cnt , nm_chk_s1 , nm_chk_s2 , nm_chk_s3, nm_chk_s4, nm_chk_advisor, nm_chk_date, nm_chk_p1, nm_chk_p2 , nm_chk_p3, nm_file_chk , nm_act_chgno , nm_act_chgnm , nm_act_s1 , nm_act_s2, nm_act_s3, nm_act_s4, nm_act_my, nm_act_my_amt, nm_act_other, nm_act_other_amt , nm_act_searchdt , nm_act_cnt, nm_file_act ) values ('$cd_model', '$cd_grade' , '$ds_type', '$ds_year', '$nm_mileage' , '$nm_price', '$nm_name' , '$ds_driving_system', '$ds_oil', '$nm_gearbox', '$nm_color' , '$nm_incolor', '$ds_accident' , '$nm_cont_accident' , '$ds_transmission' , '$nm_regdate','$ds_sales','$nm_btitle','$nm_stitle','$nm_cont','$upload_file_report_name','$upload_file_report_back_name' , '$upload_file_main_name','$upload_file_list_name', '$ds_logo', '$cd_brand', '$cd_category' , '$ds_open','$ds_status',now(),'$cd_userid', now(), '$cd_userid','N' , '$nm_number','$nm_cc','$ds_trade','$nm_regdate_yyyy','$nm_regdate_mm','$nm_regdate_dd','$nm_guide','$ds_main','$nm_ltitle' ,'$ds_cate' , '$nm_chk_178_q1' , '$nm_chk_178_q2' , '$nm_chk_178_q3' , '$nm_chk_178_q4' , '$nm_chk_178_q5' , '$nm_chk_178_q6' , '$nm_chk_178_q7' , '$nm_chk_178_q8' , '$nm_chk_178_q9' , '$nm_chk_178_q10' , '$nm_chk_178_q11' , '$nm_chk_178_q12' , '$nm_chk_178_q13' , '$nm_chk_carno' , '$nm_chk_cnt' , '$nm_chk_s1' , '$nm_chk_s2' , '$nm_chk_s3', '$nm_chk_s4', '$nm_chk_advisor', '$nm_chk_date', '$nm_chk_p1', '$nm_chk_p2' , '$nm_chk_p3', '$upload_file_chk_name' , '$nm_act_chgno' , '$nm_act_chgnm' , '$nm_act_s1' , '$nm_act_s2' , '$nm_act_s3' , '$nm_act_s4' , '$nm_act_my' , '$nm_act_my_amt', '$nm_act_other', '$nm_act_other_amt' , '$nm_act_searchdt' , '$nm_act_cnt', '$upload_file_act_name')"; $result = mysql_query($sql,$connect); $cd_car = mysql_insert_id(); if($cd_car>0){ //차량옵션정보 등록 fnSetCarDtlInfo($cd_car,$connect); fnSetCarImgCreate($cd_car,$connect); } if ($result) { echo "200"; //AlertRedirect("입력 완료되었습니다.","./list.php?ds_cate=".$ds_cate); }else{ echo "600"; //AlertRedirect("입력 실패 하였습니다.","./list.php?ds_cate=".$ds_cate); } break; // update 모드시 파일 업로드 case "AddFileAjax" : $result = fnSetCarImgCreateAjax($cd_car,$connect); echo $result; /*if ($result) { echo "Y"; }else{ echo "N"; }*/ break; //글수정 case "Update": //print_r($_REQUEST); /* if (is_uploaded_file($_FILES['nm_file_report']['tmp_name'])) { if($_FILES['nm_file_report']['size'] > 0 ){ $upload_file_report_name = upload($_FILES['nm_file_report'],$upload_path, 500, array('gif', 'jpeg', 'jpg','png','bmp','hwp','doc','ppt','docx','pptx' ,'pdf' ,'ttif')); if($upload_file_report_name==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } if (is_uploaded_file($_FILES['nm_file_report_back']['tmp_name'])) { if($_FILES['nm_file_report_back']['size'] > 0 ){ $upload_file_report_back_name = upload($_FILES['nm_file_report_back'],$upload_path, 50, array('gif', 'jpeg', 'jpg','png','bmp' )); if($upload_file_report_back_name==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } */ if (is_uploaded_file($_FILES['nm_file_report']['tmp_name'])) { if($_FILES['nm_file_report']['size'] > 0 ){ $upload_file_report_name = upload($_FILES['nm_file_report'],$upload_path, 500, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_report_name==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } if (is_uploaded_file($_FILES['nm_file_report_back']['tmp_name'])) { if($_FILES['nm_file_report_back']['size'] > 0 ){ $upload_file_report_back_name = upload($_FILES['nm_file_report_back'],$upload_path, 500, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_report_back_name==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } if (is_uploaded_file($_FILES['nm_file_chk']['tmp_name'])) { if($_FILES['nm_file_chk']['size'] > 0 ){ $upload_file_chk_name = upload($_FILES['nm_file_chk'],$upload_path."nm_file_chk/", 500, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_chk_name==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } if (is_uploaded_file($_FILES['nm_file_act']['tmp_name'])) { if($_FILES['nm_file_act']['size'] > 0 ){ $upload_file_act_name = upload($_FILES['nm_file_act'],$upload_path."nm_file_act/", 500, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_act_name==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } $sql="update car_master set cd_model = '$cd_model' ,cd_grade = '$cd_grade' ,cd_category = '$cd_category' ,cd_brand = '$cd_brand' ,ds_type = '$ds_type' ,ds_year = '$ds_year' ,nm_name = '$nm_name' ,nm_mileage = '$nm_mileage' ,ds_driving_system = '$ds_driving_system' ,ds_transmission = '$ds_transmission' ,ds_oil = '$ds_oil' ,nm_price = '$nm_price' ,nm_gearbox = '$nm_gearbox' ,nm_color = '$nm_color' ,nm_incolor = '$nm_incolor' ,ds_accident = '$ds_accident' ,nm_cont_accident = '$nm_cont_accident' ,nm_regdate = '$nm_regdate' ,ds_sales = '$ds_sales' ,nm_btitle = '$nm_btitle' ,nm_stitle = '$nm_stitle' ,nm_cont = '$nm_cont' ,ds_open = '$ds_open' ,ds_logo = '$ds_logo' ,ds_status = '$ds_status' ,nm_file_report = '$upload_file_report_name' ,nm_file_report_back = '$upload_file_report_back_name' ,nm_file_main = '$upload_file_main_name' ,nm_file_list = '$upload_file_list_name' ,dt_update = now() ,nm_update = '$cd_userid' ,nm_number = '$nm_number' ,nm_cc = '$nm_cc' ,nm_ltitle = '$nm_ltitle' ,ds_trade = '$ds_trade' ,ds_cate = '$ds_cate' ,ds_main= '$ds_main' ,nm_regdate_yyyy = '$nm_regdate_yyyy' ,nm_regdate_mm = '$nm_regdate_mm' ,nm_regdate_dd = '$nm_regdate_dd' ,nm_guide = '$nm_guide' , nm_chk_178_q1 = '$nm_chk_178_q1' , nm_chk_178_q2 = '$nm_chk_178_q2' , nm_chk_178_q3 = '$nm_chk_178_q3' , nm_chk_178_q4 = '$nm_chk_178_q4' , nm_chk_178_q5 = '$nm_chk_178_q5' , nm_chk_178_q6 = '$nm_chk_178_q6' , nm_chk_178_q7 = '$nm_chk_178_q7' , nm_chk_178_q8 = '$nm_chk_178_q8' , nm_chk_178_q9 = '$nm_chk_178_q9' , nm_chk_178_q10 = '$nm_chk_178_q10' , nm_chk_178_q11 = '$nm_chk_178_q11' , nm_chk_178_q12 = '$nm_chk_178_q12' , nm_chk_178_q13 = '$nm_chk_178_q13' , nm_chk_carno = '$nm_chk_carno' , nm_chk_cnt = '$nm_chk_cnt' , nm_chk_s1 = '$nm_chk_s1' , nm_chk_s2 = '$nm_chk_s2' , nm_chk_s3 = '$nm_chk_s3' , nm_chk_s4 = '$nm_chk_s4' , nm_chk_advisor = '$nm_chk_advisor' , nm_chk_date = '$nm_chk_date' , nm_chk_p1 = '$nm_chk_p1' , nm_chk_p2 = '$nm_chk_p2' , nm_chk_p3 = '$nm_chk_p3' , nm_file_chk = case when '$upload_file_chk_name' = '' then nm_file_chk else '$upload_file_chk_name' end , nm_act_chgno = '$nm_act_chgno' , nm_act_chgnm = '$nm_act_chgnm' , nm_act_s1 = '$nm_act_s1' , nm_act_s2 = '$nm_act_s2' , nm_act_s3 = '$nm_act_s3' , nm_act_s4 = '$nm_act_s4' , nm_act_my = '$nm_act_my' , nm_act_my_amt = '$nm_act_my_amt' , nm_act_other = '$nm_act_other' , nm_act_other_amt = '$nm_act_other_amt' , nm_act_searchdt = '$nm_act_searchdt' , nm_act_cnt = '$nm_act_cnt' , nm_file_act = case when '$upload_file_act_name' = '' then nm_file_act else '$upload_file_act_name' end WHERE cd_car =$cd_car"; $result = mysql_query($sql,$connect); fnSetCarDtlInfo($cd_car,$connect); //fnSetCarImgCreate($cd_car,$connect); if ($result) { echo "200"; //Redirect("./form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); }else{ echo "600"; //AlertRedirect("수정 실패 하였습니다.","./list.php&PageNo=$PageNo&ds_cate=".$ds_cate); } break; //sale -> updateCar 내차팔기->차량정보 수정 승인 정보 셋팅(내차팔기 시 화면 사용을 위한 세션값) case "updateCar": $_SESSION['s_cd_car'] = $cd_car; $_SESSION['s_car_update_ing_cd_sale'] = trim(avoid_crack($_POST["cd_sale"])); $_SESSION['s_car_update_ing'] = "Y"; $sql = "select ds_area from car_master c inner join sale_master s on (c.cd_car = s.cd_car and s.ds_delind = 'N' and s.cd_sale = '".trim(avoid_crack($_POST["cd_sale"]))."' ) limit 1"; $col=mysql_fetch_array(mysql_query($sql)); if (!empty($col[ds_area_user])){ $_SESSION['s_ds_area_user'] = $col['ds_area_user']; } echo "Y"; // echo $cd_car."-".$_SESSION['s_cd_car']."-".$_SESSION['s_car_update_ing']; break; //사용자가 유찰사유를 선택해서 저장 case "updateFail": $ds_fail = trim(avoid_crack($_POST["ds_fail"])); $sql="update sale_master set dt_update = now() , nm_update = '$cd_userid' , ds_fail = '$ds_fail' WHERE cd_sale = $cd_sale and cd_user = '$s_cd_user' "; $result = mysql_query($sql,$connect); if($result) { echo "Y"; }else { echo "N"; } break; //sale -> sellNoMember case "sellNoMember": exit; $RES = array('CODE'=>'9999', 'MSG'=>''); try { $where = array(); $where['nm_number'] = $nm_number; $is_sale = fnIsSale($where); unset($where); if($is_sale == true) { throw new Exception("현재 등록되어 진행 중인 차량입니다.", "9900"); } if($s_cd_car !="" || $s_cd_car != null){ $sql="update car_master set dt_update = now() , nm_update = '$cd_userid' , nm_number = '$nm_number' WHERE cd_car = $s_cd_car"; $result = mysql_query($sql,$connect); } else{ $sql="insert into car_master (nm_number, dt_insert, nm_insert, dt_update, nm_update, ds_delind ) values ('$nm_number', now(), '$cd_userid', now(), '$cd_userid','N' )"; echo $sql; exit; $result = mysql_query($sql,$connect); if (!$result) { throw new Exception("차량 저장에 실패했습니다.", "9900"); } $cd_car = mysql_insert_id(); // echo $sql;; // echo '
'.$cd_car; // exit; $_SESSION['s_cd_car'] = $cd_car; } $_SESSION['s_nomem_hp'] = $nm_hp; $_SESSION['s_nm_hp'] = $nm_hp; $_SESSION['s_nm_name'] = $nm_name; $_SESSION['s_ds_area'] = $ds_area; $_SESSION['s_ds_type'] = "C0"; //$ds_type -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자 $_SESSION['s_ds_usertype'] = "C0"; //$ds_usertypeds_type 상세 사용 가능) -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자 예)(($row[ds_type] == "A0")?"D0":"D1"); $RES['CODE'] = "0000"; $RES['MSG'] = "정상."; }catch(Exception $e){ $RES['CODE'] = $e->getCode(); $RES['MSG'] = $e->getMessage(); } @mysql_close($connect); echo json_encode($RES); exit; break; //sale -> sellNoMember case "sellNoMemberSearch": //nm_name,nm_hp,nm_number if($s_cd_car !="" || $s_cd_car != null){ $sql="update car_master set dt_update = now() , nm_update = '$cd_userid' , nm_number = '$nm_number' WHERE cd_car = $s_cd_car"; $result = mysql_query($sql,$connect); }else{ $sql="insert into car_master (nm_number, dt_insert, nm_insert, dt_update, nm_update, ds_delind ) values ('$nm_number', now(), '$cd_userid', now(), '$cd_userid','N' )"; $result = mysql_query($sql,$connect); $cd_car = mysql_insert_id(); $_SESSION['s_cd_car'] = $cd_car; $_SESSION['s_nomem_hp'] = $nm_hp; $_SESSION['s_nm_hp'] = $nm_hp; $_SESSION['s_nm_name']= $nm_name; $_SESSION['s_ds_area']= $ds_area; $_SESSION['s_ds_type']= "C0"; //$ds_type -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자 $_SESSION['s_ds_usertype']= "C0"; //$ds_usertypeds_type 상세 사용 가능) -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자 예)(($row[ds_type] == "A0")?"D0":"D1"); } if ($result) { Redirect("sell_step1.php?mode=Step1"); // AlertRedirect("저장 되었습니다.","sell_step2.php?mode=Step2"); }else{ AlertBack("등록 실패 하였습니다."); } break; case 'PreStep': $RES = array('CODE'=>'9999', 'MSG'=>''); try { $where = array(); $where['nm_number'] = $nm_number; $is_sale = fnIsSale($where); unset($where); if($is_sale == true) { throw new Exception("현재 등록되어 진행 중인 차량입니다.", "9900"); } $sql="insert into car_master SET cd_model = '$cd_model' , cd_grade = '0' , cd_model_sub = '0' , cd_category = '$cd_category' , cd_brand = '$cd_brand' , cd_car_history = '$cd_car_history' , ds_type = '$ds_type' , ds_year = '$ds_year' , nm_mileage = '$nm_mileage' , ds_transmission = '$ds_transmission' , ds_oil = '$ds_oil' , nm_color = '$nm_color' , ds_accident = '$ds_accident' , nm_cont_accident = '$nm_cont_accident' , nm_cont_pac = '$nm_cont_pac' , ds_business_num = '$ds_business_num' , nm_name = '$nm_name' , nm_number = '$nm_number' , nm_cc = '$nm_cc' , nm_regdate_yyyy = '$nm_regdate_yyyy' , nm_regdate_mm = '$nm_regdate_mm' , nm_regdate_dd = '$nm_regdate_dd' , ds_status = '$ds_status' , dt_insert = now() , nm_insert = '$cd_userid' , dt_update = now() , nm_update = '$cd_userid' , ds_delind = 'N' , nm_price = '0' , nm_gearbox = '' , nm_incolor = '' , nm_regdate = '' , ds_sales = '' , nm_btitle = '' , nm_stitle = '' , nm_ltitle = '' "; // echo $sql; // exit; //사고 유무는 1-1단계에서 처리 해달라함 // , ds_accident, nm_cont_accident //, '$ds_accident', '$nm_cont_accident' $result = mysql_query($sql,$connect); if(!$result) { throw new Exception("차량등록에 실패했습니다.", "9900"); } $cd_car = mysql_insert_id(); $_SESSION['s_cd_car']= $cd_car; $_SESSION['s_ds_type'] = "C0"; //$ds_type -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자 $_SESSION['s_ds_usertype'] = "C0"; //$ds_usertypeds_type 상세 사용 가능) -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자 예)(($row[ds_type] == "A0")?"D0":"D1"); $RES['CODE'] = "0000"; $RES['MSG'] = "정상."; }catch(Exception $e){ $RES['CODE'] = $e->getCode(); $RES['MSG'] = $e->getMessage(); } @mysql_close($connect); echo json_encode($RES); break; //sale -> Step1 case "Step1": include $_SERVER['DOCUMENT_ROOT'].'/common/auth_chk.php'; $RES = array('CODE'=>'9999', 'MSG'=>''); try { //sale_mater 에 등록될 변수들은 세션에 담는다 $nm_hp = $_POST['nm_hp1'].'-'.$_POST['nm_hp2'].'-'.$_POST['nm_hp3']; $sql="UPDATE car_master SET ds_transmission = '$ds_transmission' , nm_cc = '$nm_cc' , ds_oil = '$ds_oil' , nm_color = '$nm_color' , nm_mileage = '$nm_mileage' , ds_accident = '$ds_accident' , ds_business_num = '$ds_business_num' , nm_cont_pac = '$nm_cont_pac' , ds_accident_check = '$ds_accident_check' , ds_damage_check = '$ds_damage_check' , dt_update = now() , nm_update = '$cd_userid' , nm_name = '$nm_name' WHERE cd_car = $s_cd_car"; //, ds_sale_period = '$ds_sale_period' // echo $sql; // exit; $result = mysql_query($sql,$connect); if(!$result) { throw new Exception("저장에 실패 하였습니다.", "9990"); } $sale_master = array( "sell_nomem_hp" => $nm_hp, //차량 희망가 "sell_nm_hp" => $nm_hp, //연락 가능시간 "sell_nm_name" => $nm_name, //중고 시세가 "sell_ds_area" => $ds_area, //중고 시세가 "sell_ds_sale_period" => $ds_sale_period, //중고 시세가 "s_cd_aap_dealer" => $cd_aap_dealer, //중고 시세가 "s_ds_type" => 'C0', //$ds_type -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자 "s_ds_usertype" => 'C0', //$ds_usertypeds_type 상세 사용 가능) -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자 예)(($row[ds_type] == "A0")?"D0":"D1"); ); $_SESSION['s_sale_master']= json_encode($sale_master); $DATAS = array(); $DATAS['URL'] = "sell_step2.php"; $RES['CODE'] = "0000"; $RES['MSG'] = "저장 되었습니다."; $RES['DATAS'] = $DATAS; // $_SESSION['s_ds_area_user']= $ds_area_user; }catch(Exception $e){ $RES['CODE'] = $e->getCode(); $RES['MSG'] = $e->getMessage(); } @mysql_close($connect); echo json_encode($RES); exit; break; case "Step1-1": exit; //nm_cont //사고 유무 추가 // $sql="update car_master // set // ds_accident = '$ds_accident' // ,nm_cont_accident = '$nm_cont_accident' // ,dt_update = now() // ,nm_update = '$cd_userid' // WHERE cd_car = $cd_car"; // $result = mysql_query($sql,$connect); // // if ($result) { // Redirect("sell_step2.php?mode=Step2"); // // AlertRedirect("저장 되었습니다.","sell_step3.php?mode=Step3"); // }else{ // AlertRedirect("저장 실패하였습니다.","sell_step1_1.php?mode=Step1-1"); // } // Redirect("sell_step2.php?mode=Step2"); // break; //sale -> Step2 case "Step2": //nm_cont include $_SERVER['DOCUMENT_ROOT'].'/common/auth_chk.php'; $RES = array('CODE'=>'9999', 'MSG'=>''); try { if(is_array($nm_cont_detail)) { $nm_cont_detail_value = implode(",",$nm_cont_detail); }else { $nm_cont_detail_value = ""; } $sql = "UPDATE car_master SET nm_cont = '$nm_cont' , nm_cont_detail = '".$nm_cont_detail_value."' , dt_update = now() , nm_update = '$cd_userid' WHERE cd_car = $s_cd_car"; // echo $sql; // exit; $result = mysql_query($sql, $connect); if(!$result) { throw new Exception("저장에 실패 하였습니다.", "9990"); } $DATAS = array(); $DATAS['URL'] = "sell_step3.php"; $RES['CODE'] = "0000"; $RES['MSG'] = "저장 되었습니다."; $RES['DATAS'] = $DATAS; }catch(Exception $e){ $RES['CODE'] = $e->getCode(); $RES['MSG'] = $e->getMessage(); } @mysql_close($connect); echo json_encode($RES); exit; break; //sale -> Step3 case "Step3": include $_SERVER['DOCUMENT_ROOT'].'/common/auth_chk.php'; $RES = array('CODE'=>'9999', 'MSG'=>''); try { $file_sql = ""; $upload_path = $upload_path.$s_cd_car."_main/"; $upload_path_ratio = $upload_path."ratio/"; //차량전면 이미지 첨부파일 업로드 $upload_image_info = _upload_car_image($upload_path, $upload_path_ratio, 'nm_file_front', 500, true); if($upload_image_info['result'] == false) { throw new Exception("첨부파일 업로드 실패 하였습니다.", "9979"); } //차량전면 이미지 if(!empty($upload_image_info['filename'])) { $file_sql.= " , nm_file_front = '".$upload_image_info['filename']."' "; } //운전석 측면 첨부파일 업로드 $upload_image_info = _upload_car_image($upload_path, $upload_path_ratio, 'nm_file_side1', 500, true); if($upload_image_info['result'] == false) { throw new Exception("첨부파일 업로드 실패 하였습니다.", "9979"); } //운전석 측면 이미지 if(!empty($upload_image_info['filename'])) { $file_sql.= " , nm_file_side1 = '".$upload_image_info['filename']."' "; } //조수석 측면 첨부파일 업로드 $upload_image_info = _upload_car_image($upload_path, $upload_path_ratio, 'nm_file_side2', 500, true); if($upload_image_info['result'] == false) { throw new Exception("첨부파일 업로드 실패 하였습니다.", "9979"); } //조수석 측면 이미지 if(!empty($upload_image_info['filename'])) { $file_sql.= " , nm_file_side2 = '".$upload_image_info['filename']."' "; } //차량 후면 첨부파일 업로드 $upload_image_info = _upload_car_image($upload_path, $upload_path_ratio, 'nm_file_back', 500, true); if($upload_image_info['result'] == false) { throw new Exception("첨부파일 업로드 실패 하였습니다.", "9979"); } //차량 후면 이미지 if(!empty($upload_image_info['filename'])) { $file_sql.= " , nm_file_back = '".$upload_image_info['filename']."' "; } //계기판 첨부파일 업로드 $upload_image_info = _upload_car_image($upload_path, $upload_path_ratio, 'nm_file_dashboard', 500, true); if($upload_image_info['result'] == false) { throw new Exception("첨부파일 업로드 실패 하였습니다.", "9979"); } //계기판 이미지 if(!empty($upload_image_info['filename'])) { $file_sql.= " , nm_file_dashboard = '".$upload_image_info['filename']."' "; } $sql="UPDATE car_master SET ds_status = 'B0' , dt_update = now() , nm_update = '$cd_userid' $file_sql WHERE cd_car = $s_cd_car"; //, nm_file_engine = case when '$upload_file_engine_name' = '' then nm_file_engine else '$upload_file_engine_name' end // , nm_file_registration = case when '$upload_file_registration_name' = '' then nm_file_registration else '$upload_file_registration_name' end // echo $sql; // exit; $result = mysql_query($sql,$connect); //AJAX 용 if (!$result) { throw new Exception("차량 이미지 업로드에 실패하였습니다. 다시 시도해 주세요.", "9900"); } $DATAS = array(); $DATAS['URL'] = "sell_step3.php"; $RES['CODE'] = "0000"; $RES['MSG'] = "저장 되었습니다."; $RES['DATAS'] = $DATAS; }catch(Exception $e){ $RES['CODE'] = $e->getCode(); $RES['MSG'] = $e->getMessage(); } @mysql_close($connect); echo json_encode($RES); exit; break; case "Step4": include $_SERVER['DOCUMENT_ROOT'].'/common/auth_chk.php'; $RES = array('CODE'=>'9999', 'MSG'=>''); try { // if($s_staff_car_update_ing != "Y"){ //차량 수정 중에는 진행중 차량 체크 안함 // // 차량 별 진행중 차량 체크 // //현재 진행중인 차량 체크(회원/비회원) // // $regist_car = fnGetCarInfoByCdCar($s_staff_cd_car); // // $where = array(); // $where['nm_number'] = $regist_car['nm_number']; // // $is_sale = fnIsSale($where); // unset($where); // // if($is_sale == true) { // throw new Exception("현재 등록되어 진행 중인 차량입니다.", "9900"); // // AlertBack("현재 등록되어 진행 중인 차량입니다."); // } // } if(isset($_FILES['upload_file']) && count($_FILES['upload_file']) > 0) { $upload_files = array(); for($i=0; $i < 10; $i++) { $file_name = ""; $file_type = ""; $file_tmp_name = ""; $file_error = ""; $file_size = ""; //등록된 파일만 if(isset($_FILES['upload_file']['name'][$i])) { $file_name = $_FILES['upload_file']['name'][$i]; $file_type = $_FILES['upload_file']['type'][$i]; $file_tmp_name = $_FILES['upload_file']['tmp_name'][$i]; $file_error = $_FILES['upload_file']['error'][$i]; $file_size = $_FILES['upload_file']['size'][$i]; } $upload_files['name'][] = $file_name; $upload_files['type'][] = $file_type; $upload_files['tmp_name'][] = $file_tmp_name; $upload_files['error'][] = $file_error; $upload_files['size'][] = $file_size; } $_FILES['file'] = $upload_files; } //추가 이미지 등록 if(count($_FILES) > 0) { $file_result = fnSetCarImgCreate($s_cd_car, $connect); if(!$file_result) { throw new Exception("파일 업로드에 실패 하였습니다.", "9991"); } } $DATAS = array(); $DATAS['URL'] = "sell_step5.php";//&uniqid=".$uniqid; $RES['CODE'] = "0000"; $RES['MSG'] = "저장 되었습니다."; $RES['DATAS'] = $DATAS; }catch(Exception $e){ $RES['CODE'] = $e->getCode(); $RES['MSG'] = $e->getMessage(); } @mysql_close($connect); echo json_encode($RES); exit; break; case "Step5": include $_SERVER['DOCUMENT_ROOT'].'/common/auth_chk.php'; $RES = array('CODE'=>'9999', 'MSG'=>''); try { // if($s_car_update_ing != "Y"){ //차량 수정 중에는 진행중 차량 체크 안함 // // 차량 별 진행중 차량 체크 // //현재 진행중인 차량 체크(회원/비회원) // // $regist_car = fnGetCarInfoByCdCar($s_cd_car); // // $where = array(); // $where['nm_number'] = $regist_car['nm_number']; // // $is_sale = fnIsSale($where); // unset($where); // // if($is_sale == true) { // throw new Exception("현재 등록되어 진행 중인 차량입니다.", "9900"); // // AlertBack("현재 등록되어 진행 중인 차량입니다."); // } // } // $table_name = " sa_master a "; // $_whereis = " a.cd_userid = '".$cd_userid."' "; // $staff = $dbCon->selectDAO(" a.device_uuid, a.device_os", $table_name, $_whereis); //세션에서 sale_master 에 등록될 데이터를 가져온다 $sale_master = json_decode($_SESSION['s_sale_master'], true); // print_r($sale_master); // exit; // print_r($_SESSION['s_sale_master']); // $sale_master = array( // "sell_nomem_hp" => $nm_hp, //차량 희망가 // "sell_nm_hp" => $nm_hp, //연락 가능시간 // "sell_nm_name" => $sell_nm_name, //중고 시세가 // "sell_ds_area" => $ds_area, //중고 시세가 // "sell_ds_sale_period" => $ds_sale_period, //중고 시세가 // "s_cd_aap_dealer" => $cd_aap_dealer, //중고 시세가 // "s_ds_type" => 'C0', //$ds_type -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자 // "s_ds_usertype" => 'C0', //$ds_usertypeds_type 상세 사용 가능) -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자 예)(($row[ds_type] == "A0")?"D0":"D1"); // ); $car_sql = "SELECT c.* , b.nm_model , d.nm_brand FROM car_master c LEFT OUTER JOIN car_model b on (c.cd_model = b.cd_model) LEFT OUTER JOIN car_brand d on (c.cd_brand = d.cd_brand) WHERE cd_car = '$s_cd_car' LIMIT 1"; // echo $sale_sql; // exit; $car_res = mysql_query($car_sql); $car_col = mysql_fetch_array($car_res); //ds_status : 'A0' = 입력중, 'B0' = '입력완료', ... $sql="UPDATE car_master SET nm_desc = '$nm_desc' , dt_update = now() , nm_update = '$cd_userid' WHERE cd_car = '$s_cd_car' "; // echo $sql; // exit; $result = mysql_query($sql, $connect); if(!$result) { throw new Exception("저장에 실패 하였습니다.", "9991"); } //$ds_usertype -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자 $ds_usertype = "A0"; if(empty($sale_master['s_cd_aap_dealer'])) { $sale_master['s_cd_aap_dealer'] = 0; } $sql="INSERT INTO sale_master SET cd_car = '$s_cd_car' , cd_user = '$s_cd_user' , nm_email = '' , nm_name = '{$sale_master['sell_nm_name']}' , nm_hp = '{$sale_master['sell_nm_hp']}' , nm_tel = '' , nm_price_exp = '0' , nm_price = '0' , ds_status_contract = '' , ds_status_contract_step1 = '' , ds_status_contract_step2 = '' , ds_status_contract_step3 = '' , ds_status_contract_step4 = '' , ds_status_contract_step5 = '' , ds_company_bp = '$s_ds_company_bp' , ds_branch = '$s_ds_branch' , ds_area = '{$sale_master['sell_ds_area']}' , ds_area_sub = '$ds_area_sub' , ds_usertype = '$ds_usertype' , ds_status = 'B0' , ds_sale_period = '{$sale_master['sell_ds_sale_period']}' , dt_insert = now() , nm_insert = '$cd_userid' , dt_update = now() , nm_update = '$cd_userid' , ds_delind = 'N' , is_staff = 'N' , ds_auction_time = '72' , cd_aap_dealer = '{$sale_master['s_cd_aap_dealer']}' "; // echo $sql; // exit; $result = mysql_query($sql,$connect); if(!$result) { throw new Exception("정보 등록에 실패 하였습니다.", "9991"); } $cd_sale = mysql_insert_id(); $_SESSION['s_sale_master'] = NULL; $_SESSION['sell_nm_name'] = ''; $_SESSION['sell_ds_area'] = ''; $_SESSION['s_cd_car'] = ''; # SMS 발송 # 1. 사용자에게 $aligo = new Aligo(); $aligo->getToken(); $ALIGO_DATA = array(); $ALIGO_DATA['seller'] = $sale_master['sell_nm_name']; $ALIGO_DATA['car_brand'] = $car_col['nm_brand']; $ALIGO_DATA['car_model'] = $car_col['nm_model']; $ALIGO_DATA['car_number'] = $car_col['nm_number']; $ALIGO_DATA['recv_phone'] = $sale_master['sell_nm_hp']; $response = $aligo->send_user_sell_standby_to_user($ALIGO_DATA); unset($ALIGO_DATA); if($response['code'] != "0") { // echo $response['message']; } # 2. 관리자에게 foreach($admin_phone as $phone) { if(!empty($phone)) { $ALIGO_DATA = array(); $ALIGO_DATA['seller'] = $sale_master['sell_nm_name']; $ALIGO_DATA['car_brand'] = $car_col['nm_brand']; $ALIGO_DATA['car_model'] = $car_col['nm_model']; $ALIGO_DATA['car_number'] = $car_col['nm_number']; $ALIGO_DATA['recv_phone'] = $phone; // print_r($ALIGO_DATA); $response = $aligo->send_user_sell_standby_to_admin($ALIGO_DATA); // print_r($response); unset($ALIGO_DATA); } } // print_r($response); // exit; if($response['code'] != "0") { // echo $response['message']; } $DATAS = array(); $DATAS['URL'] = "sell_step5.php"; $RES['CODE'] = "0000"; $RES['MSG'] = "저장 되었습니다."; $RES['DATAS'] = $DATAS; }catch(Exception $e){ $RES['CODE'] = $e->getCode(); $RES['MSG'] = $e->getMessage(); } @mysql_close($connect); echo json_encode($RES); exit; break; // 담당자코멘트 저장 case "Guide": exit; if($cd_car !="" || $cd_car != null){ $sql="update car_master set nm_guide = '$nm_guide' , dt_update = now() , nm_update = '$cd_userid' WHERE cd_car = $cd_car"; $result = mysql_query($sql,$connect); } if ($result) { echo "200"; }else{ echo "600"; } break; //보험처리 이력정보 등록 -> AddActIns case "AddActIns": exit; //nm_number,cd_brand,cd_model,cd_grade,nm_regdate_yyyy,nm_regdate_mm,ds_year,nm_cc,ds_transmission,ds_oil,nm_color,nm_mileage,ds_accident if($cd_car !="" || $cd_car != null){ $sql="update car_master set nm_act_chgno = '$nm_act_chgno' , nm_act_chgnm = '$nm_act_chgnm' , nm_act_s1 = '$nm_act_s1' , nm_act_s2 = '$nm_act_s2' , nm_act_s3 = '$nm_act_s3' , nm_act_s4 = '$nm_act_s4' , nm_act_my = '$nm_act_my' , nm_act_my_amt = '$nm_act_my_amt' , nm_act_other = '$nm_act_other' , nm_act_other_amt = '$nm_act_other_amt' , nm_act_searchdt = '$nm_act_searchdt' , nm_act_cnt = '$nm_act_cnt' , nm_act_general_spec = '$nm_act_general_spec' , nm_act_use_record = '$nm_act_use_record' , nm_act_use_record_lend = '$nm_act_use_record_lend' , nm_act_use_record_biz = '$nm_act_use_record_biz' , nm_act_use_record_official = '$nm_act_use_record_official' , nm_act_ins_loss = '$nm_act_ins_loss' , nm_act_ins_wet = '$nm_act_ins_wet' , nm_act_ins_robbery = '$nm_act_ins_robbery' , nm_file_act = '$nm_file_act' , nm_act_yn = 'Y' , dt_act_insert = now() , dt_update = now() , nm_update = '$cd_userid' WHERE cd_car = $cd_car"; $result = mysql_query($sql,$connect); fnSetCarDtlInfo($cd_car,$connect); } if ($result) { echo "200"; }else{ echo "600"; } break; //내차 팔기 반려 -> Return case "Return": //관리자 단으로 이동함 exit; if($cd_sale !="" || $cd_sale != null){ $sql="update sale_master set nm_cont_return = '$nm_cont_return' , ds_status = 'D0' , dt_update = now() , nm_update = '$cd_userid' WHERE cd_sale = $cd_sale"; $result = mysql_query($sql,$connect); } if ($result) { echo "200"; }else{ echo "600"; } break; //내차 팔기 승인 -> Confirm case "Confirm": //관리자 단으로 이동함 exit; if($cd_sale !="" || $cd_sale != null){ $sql="update sale_master set ds_status = 'E0' , dt_approve = now() , dt_update = now() , nm_update = '$cd_userid' WHERE cd_sale = $cd_sale"; $result = mysql_query($sql,$connect); } $table_name = " car_master a inner join sale_master f on (a.cd_car = f.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)"; $_whereis = " f.cd_sale = '".$cd_sale."' "; $col = $dbCon->selectDAO(" a.cd_brand, a.cd_model, a.cd_grade, b.nm_model, c.nm_grade, d.nm_brand, e.nm_model_sub, f.nm_hp, f.nm_name, a.nm_mileage, f.ds_area, f.ds_area_user, a.nm_regdate_yyyy , a.nm_regdate_mm, a.ds_year", $table_name, $_whereis); //해당 딜러 매칭은 ds_area_user : 사용자가 지정한 판매 희망지역으로 설정 $nm_regdate_full = substr($col['ds_year'], 2, 2).'MY'; $contents = $col['nm_brand'].' '.$col['nm_model'].' '.$col['nm_grade'].' '.$col['nm_mileage'].'km'; $contents = $col['nm_model'].' '.$nm_regdate_full; $sql = "INSERT INTO sale_master_standby ( cd_brand, ds_area, cd_model, cd_grade, nm_mileage, contents) SELECT '$col[cd_brand]', '$col[ds_area]', '$col[cd_model]', '$col[cd_grade]', '$nm_regdate_full', '$contents' FROM dual WHERE not EXISTS ( SELECT cd_brand, ds_area, cd_model, cd_grade, nm_mileage FROM sale_master_standby WHERE cd_brand = '$col[cd_brand]' and ds_area = '$col[ds_area]' and cd_model = '$col[cd_model]' and cd_grade = '$col[cd_grade]' and nm_mileage = '$nm_regdate_full' ) "; mysql_query($sql); if ($result) { echo "200"; }else{ echo "600"; } break; //sale -> Step2 //글삭제 처리 case "Delete" : $sql = "update car_master set ds_delind='Y' , nm_update = '$cd_userid' , dt_update = now() where cd_car='$cd_car'"; $result = mysql_query($sql,$connect); if ($result) { AlertRedirect("삭제 되었습니다.","list.php?PageNo=$PageNo&cd_category=".$cd_category); }else{ AlertRedirect("삭제 실패하였습니다.","list.php?PageNo=$PageNo&cd_category=".$cd_category); } break; //리스트 Number 수정 처리 case "CarImgCreate" : $result = fnSetCarImgCreate($cd_car,$connect); if ($result) { Redirect("sell_step3.php?mode=Step3"); // Redirect("form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); }else{ AlertBack("처리 실패 하였습니다."); // AlertRedirect("파일등록을 실패하였습니다.","form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); } break; case "CarImgDelete" : $sql = "update car_file set ds_delind='Y' , nm_update = '$cd_userid' , dt_update = now() where cd_file = '$cd_file' AND cd_car='$cd_car'"; $result = mysql_query($sql,$connect); if ($result) { Redirect("sell_step3.php?mode=Step3"); // Redirect("form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); }else{ AlertBack("처리 실패 하였습니다."); // AlertRedirect("처리 실패 하였습니다.","form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); } break; case "AllCarImgDelete" : $sql = "update car_file set ds_delind='Y' , nm_update = '$cd_userid' , dt_update = now() where cd_car='$cd_car'"; $result = mysql_query($sql,$connect); if ($result) { Redirect("sell_step3.php?mode=Step3"); // Redirect("form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); }else{ AlertBack("처리 실패 하였습니다."); // AlertRedirect("처리 실패 하였습니다.","form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); } break; case "UpdateSortFile" : $sql = "update car_file set no_sort='$no_sort' , nm_update = '$cd_userid' , dt_update = now() where cd_file = '$cd_file' AND cd_car='$cd_car'"; $result = mysql_query($sql,$connect); if ($result) { Redirect("sell_step3.php?mode=Step3"); // Redirect("form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); }else{ AlertBack("처리 실패 하였습니다."); // AlertRedirect("처리 실패 하였습니다.","form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); } break; case "UpdateSortFileAjax" : $cngsorts = explode ( "," , $cngsort); $result = true; for($k = 0; $k 0 ){ $fileObj = array(); $fileObj["tmp_name"] = $_FILES["file"]["tmp_name"][$k]; $fileObj["name"] = $_FILES["file"]["name"][$k]; $fileObj["error"] = $_FILES["file"]["error"][$k]; $fileObj["size"] = $_FILES["file"]["size"][$k]; $fileObj["type"] = $_FILES["file"]["type"][$k]; $upload_path = $_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR.$cd_car."_detail/"; $upload_file_name = upload($fileObj,$upload_path, 500, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if(file_exists($upload_path.$upload_file_name) && is_file($upload_path.$upload_file_name)) { // create_watermark($upload_path.$upload_file_name); } $thumb1 = array( 'o_path' => $upload_path.$upload_file_name, 'n_path' => $upload_path.'ratio_'.$upload_file_name, 'mode' => 'ratio', 'width' => CAR_THUM_WIDTH, 'height' => CAR_THUM_HEIGHT, 'preview_yn' => 'N','o_name' =>'ratio_'.$upload_file_name ); $thumb1 = getThumb($thumb1); if(empty($thumb1['fileName'])) $thumb1['fileName'] = ''; // $upload_file_name = $thumb1['fileName']; $nm_size = $_FILES['file']['size'][$k]; $nm_mime = $_FILES['file']['type'][$k]; if($upload_file_name=="" || $nm_mime==""){ $blnResult = false; }else{ if($k == 0 ){ $upload_path2 = $_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR.$cd_car."_detail/"; $upload_file_list_name = upload($fileObj,$upload_path2, 500, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); $thumb2 = array( 'o_path' => $upload_path2.$upload_file_list_name, 'n_path' => $upload_path2.'ratio_'.$upload_file_list_name, 'mode' => 'ratio', 'width' => CAR_THUM2_WIDTH, 'height' => CAR_THUM2_HEIGHT, 'preview_yn' => 'N','o_name' =>'ratio_'.$upload_file_list_name ); $thumb2 = getThumb($thumb2); if(empty($thumb2['fileName'])) $thumb2['fileName'] = ''; $upload_file_list_name = $thumb2['fileName']; $sqlThum = "UPDATE car_master SET nm_file_main='$upload_file_list_name', nm_file_list = '$upload_file_list_name', nm_update = '$cd_userid', dt_update = now() WHERE cd_car='$cd_car'"; $mainResult = mysql_query($sqlThum, $connect); } if($nm_mime!=="" && $blnResult){ //기존에 있을지 모르니 지우기 $sql = "delete from car_file where cd_car='$cd_car' and no_sort = '$k'"; $result = mysql_query($sql, $connect); $sql = "INSERT INTO car_file SET cd_car = '$cd_car', ds_type = '', nm_file = '$upload_file_name', nm_size = '$nm_size', nm_mime = '$nm_mime', no_sort = '$k', dt_insert = now(), nm_insert = '$cd_userid', dt_update = now(), nm_update = '$cd_userid', ds_delind = 'N' "; // echo $sql; $blnResult = mysql_query($sql, $connect); $maxVal++; } } $upload_file_name = ""; } } } return $blnResult; } // 이미지 update ajax function fnSetCarImgCreateAjax($cd_car,$connect){ $upload_path = $_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR.$cd_car."_detail/"; $blnResult = true; $cd_userid = $_SESSION[admin_cd_userid]; $maxVal = @mysql_result(mysql_query("select ifnull(max(no_sort),0)+1 from car_file Where ds_delind='N' and cd_car = '$cd_car'"),0,0); if($maxVal==""){$maxVal=1;} $fileSrc = ""; for($k = 0; $k 0 ){ $fileObj = array(); $fileObj["tmp_name"] = $_FILES["file"]["tmp_name"][$k]; $fileObj["name"] = $_FILES["file"]["name"][$k]; $fileObj["error"] = $_FILES["file"]["error"][$k]; $fileObj["size"] = $_FILES["file"]["size"][$k]; $fileObj["type"] = $_FILES["file"]["type"][$k]; $upload_path = $_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR.$cd_car."_detail/"; $upload_file_name = upload($fileObj,$upload_path, 500, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); $thumb1 = array( 'o_path' => $upload_path.$upload_file_name, 'n_path' => $upload_path.'ratio_'.$upload_file_name, 'mode' => 'ratio', 'width' => CAR_THUM_WIDTH, 'height' => CAR_THUM_HEIGHT, 'preview_yn' => 'N','o_name' =>'ratio_'.$upload_file_name ); $thumb1 = getThumb($thumb1); if(empty($thumb1['fileName'])) $thumb1['fileName'] = ''; $upload_file_name = $thumb1['fileName']; $nm_size = $_FILES['file']['size'][$k]; $nm_mime = $_FILES['file']['type'][$k]; $cd_file_var = ""; if($upload_file_name=="" || $nm_mime==""){ $blnResult = false; }else{ if($nm_mime!=="" && $blnResult){ $sql = "insert into car_file( cd_car, nm_file, nm_size, nm_mime, no_sort, dt_insert, nm_insert, dt_update, nm_update, ds_delind) VALUES ('$cd_car','$upload_file_name','$nm_size','$nm_mime', '$maxVal' , now(),'$cd_userid',now(),'$cd_userid','N')"; $blnResult = mysql_query($sql,$connect); if($blnResult){ $cd_file_var = @mysql_result(mysql_query("select concat(concat(nm_file,'||'),cd_file) test from car_file Where no_sort='$maxVal' and cd_car = '$cd_car' and ds_delind = 'N'"),0,0); } $maxVal++; } } $upload_file_name = ""; $fileSrc = UPLOAD_PATH_CAR.$cd_car."_detail/".$cd_file_var; } } } return $fileSrc; } //차량 내외부 옵션 저장 function fnSetCarDtlInfo($cd_car,$connect){ //외관/내장 $ds_g1_01= trim(avoid_crack($_POST["ds_g1_01"])); $ds_g1_02= trim(avoid_crack($_POST["ds_g1_02"])); $ds_g1_03= trim(avoid_crack($_POST["ds_g1_03"])); $ds_g1_04= trim(avoid_crack($_POST["ds_g1_04"])); $ds_g1_05= trim(avoid_crack($_POST["ds_g1_05"])); $ds_g1_06= trim(avoid_crack($_POST["ds_g1_06"])); $ds_g1_07= trim(avoid_crack($_POST["ds_g1_07"])); $ds_g1_08= trim(avoid_crack($_POST["ds_g1_08"])); $ds_g1_09= trim(avoid_crack($_POST["ds_g1_09"])); $ds_g1_10= trim(avoid_crack($_POST["ds_g1_10"])); $ds_g1_11= trim(avoid_crack($_POST["ds_g1_11"])); $ds_g1_12= trim(avoid_crack($_POST["ds_g1_12"])); $ds_g1_13= trim(avoid_crack($_POST["ds_g1_13"])); $ds_g1_14= trim(avoid_crack($_POST["ds_g1_14"])); $ds_g1_15= trim(avoid_crack($_POST["ds_g1_15"])); //안전 $ds_g2_01= trim(avoid_crack($_POST["ds_g2_01"])); $ds_g2_02= trim(avoid_crack($_POST["ds_g2_02"])); $ds_g2_03= trim(avoid_crack($_POST["ds_g2_03"])); $ds_g2_04= trim(avoid_crack($_POST["ds_g2_04"])); $ds_g2_05= trim(avoid_crack($_POST["ds_g2_05"])); $ds_g2_06= trim(avoid_crack($_POST["ds_g2_06"])); $ds_g2_07= trim(avoid_crack($_POST["ds_g2_07"])); $ds_g2_08= trim(avoid_crack($_POST["ds_g2_08"])); $ds_g2_09= trim(avoid_crack($_POST["ds_g2_09"])); $ds_g2_10= trim(avoid_crack($_POST["ds_g2_10"])); $ds_g2_11= trim(avoid_crack($_POST["ds_g2_11"])); $ds_g2_12= trim(avoid_crack($_POST["ds_g2_12"])); $ds_g2_13= trim(avoid_crack($_POST["ds_g2_13"])); $ds_g2_14= trim(avoid_crack($_POST["ds_g2_14"])); $ds_g2_15= trim(avoid_crack($_POST["ds_g2_15"])); //편의멀티미디어 $ds_g3_01= trim(avoid_crack($_POST["ds_g3_01"])); $ds_g3_02= trim(avoid_crack($_POST["ds_g3_02"])); $ds_g3_03= trim(avoid_crack($_POST["ds_g3_03"])); $ds_g3_04= trim(avoid_crack($_POST["ds_g3_04"])); $ds_g3_05= trim(avoid_crack($_POST["ds_g3_05"])); $ds_g3_06= trim(avoid_crack($_POST["ds_g3_06"])); $ds_g3_07= trim(avoid_crack($_POST["ds_g3_07"])); $ds_g3_08= trim(avoid_crack($_POST["ds_g3_08"])); $ds_g3_09= trim(avoid_crack($_POST["ds_g3_09"])); $ds_g3_10= trim(avoid_crack($_POST["ds_g3_10"])); $ds_g3_11= trim(avoid_crack($_POST["ds_g3_11"])); $ds_g3_12= trim(avoid_crack($_POST["ds_g3_12"])); $ds_g3_13= trim(avoid_crack($_POST["ds_g3_13"])); $ds_g3_14= trim(avoid_crack($_POST["ds_g3_14"])); $ds_g3_15= trim(avoid_crack($_POST["ds_g3_15"])); //시트 $ds_g4_01= trim(avoid_crack($_POST["ds_g4_01"])); $ds_g4_02= trim(avoid_crack($_POST["ds_g4_02"])); $ds_g4_03= trim(avoid_crack($_POST["ds_g4_03"])); $ds_g4_04= trim(avoid_crack($_POST["ds_g4_04"])); $ds_g4_05= trim(avoid_crack($_POST["ds_g4_05"])); $ds_g4_06= trim(avoid_crack($_POST["ds_g4_06"])); $ds_g4_07= trim(avoid_crack($_POST["ds_g4_07"])); $ds_g4_08= trim(avoid_crack($_POST["ds_g4_08"])); $ds_g4_09= trim(avoid_crack($_POST["ds_g4_09"])); $ds_g4_10= trim(avoid_crack($_POST["ds_g4_10"])); $ds_g4_11= trim(avoid_crack($_POST["ds_g4_11"])); $ds_g4_12= trim(avoid_crack($_POST["ds_g4_12"])); $ds_g4_13= trim(avoid_crack($_POST["ds_g4_13"])); $ds_g4_14= trim(avoid_crack($_POST["ds_g4_14"])); $ds_g4_15= trim(avoid_crack($_POST["ds_g4_15"])); $sql="update car_master set ds_g1_01 = '$ds_g1_01' ,ds_g1_02 = '$ds_g1_02' ,ds_g1_03 = '$ds_g1_03' ,ds_g1_04 = '$ds_g1_04' ,ds_g1_05 = '$ds_g1_05' ,ds_g1_06 = '$ds_g1_06' ,ds_g1_07 = '$ds_g1_07' ,ds_g1_08 = '$ds_g1_08' ,ds_g1_09 = '$ds_g1_09' ,ds_g1_10 = '$ds_g1_10' ,ds_g1_11 = '$ds_g1_11' ,ds_g1_12 = '$ds_g1_12' ,ds_g1_13 = '$ds_g1_13' ,ds_g1_14 = '$ds_g1_14' ,ds_g1_15 = '$ds_g1_15' ,ds_g2_01 = '$ds_g2_01' ,ds_g2_02 = '$ds_g2_02' ,ds_g2_03 = '$ds_g2_03' ,ds_g2_04 = '$ds_g2_04' ,ds_g2_05 = '$ds_g2_05' ,ds_g2_06 = '$ds_g2_06' ,ds_g2_07 = '$ds_g2_07' ,ds_g2_08 = '$ds_g2_08' ,ds_g2_09 = '$ds_g2_09' ,ds_g2_10 = '$ds_g2_10' ,ds_g2_11 = '$ds_g2_11' ,ds_g2_12 = '$ds_g2_12' ,ds_g2_13 = '$ds_g2_13' ,ds_g2_14 = '$ds_g2_14' ,ds_g2_15 = '$ds_g2_15' ,ds_g3_01 = '$ds_g3_01' ,ds_g3_02 = '$ds_g3_02' ,ds_g3_03 = '$ds_g3_03' ,ds_g3_04 = '$ds_g3_04' ,ds_g3_05 = '$ds_g3_05' ,ds_g3_06 = '$ds_g3_06' ,ds_g3_07 = '$ds_g3_07' ,ds_g3_08 = '$ds_g3_08' ,ds_g3_09 = '$ds_g3_09' ,ds_g3_10 = '$ds_g3_10' ,ds_g3_11 = '$ds_g3_11' ,ds_g3_12 = '$ds_g3_12' ,ds_g3_13 = '$ds_g3_13' ,ds_g3_14 = '$ds_g3_14' ,ds_g3_15 = '$ds_g3_15' ,ds_g4_01 = '$ds_g4_01' ,ds_g4_02 = '$ds_g4_02' ,ds_g4_03 = '$ds_g4_03' ,ds_g4_04 = '$ds_g4_04' ,ds_g4_05 = '$ds_g4_05' ,ds_g4_06 = '$ds_g4_06' ,ds_g4_07 = '$ds_g4_07' ,ds_g4_08 = '$ds_g4_08' ,ds_g4_09 = '$ds_g4_09' ,ds_g4_10 = '$ds_g4_10' ,ds_g4_11 = '$ds_g4_11' ,ds_g4_12 = '$ds_g4_12' ,ds_g4_13 = '$ds_g4_13' ,ds_g4_14 = '$ds_g4_14' ,ds_g4_15 = '$ds_g4_15' WHERE cd_car =$cd_car"; $result = mysql_query($sql,$connect); return $result; } //진행중인 차량이 있는지 체크 function fnIsSale($where) { global $connect; $ret = false; $add_query = ""; foreach($where as $key => $val) { $add_query.= " AND c.".$key." = '$val' "; } $sql = "SELECT count(*) FROM car_master c INNER JOIN sale_master s ON ( c.cd_car = s.cd_car and s.ds_delind = 'N' and s.ds_status in ('B0','C0','D0','E0','F0','Z0') and (s.dt_approve is null or s.dt_approve >= DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_SELL."' HOUR) ) ) WHERE 1 $add_query "; //c.nm_number = '".$nm_number."' // if($_SERVER['REMOTE_ADDR'] == '106.243.211.195') { // // echo $sql; // print_r($where); // exit; // } // and c.cd_car = '".$cd_car."' $res = mysql_query($sql,$connect); $cnt = mysql_result($res,0,0); if($cnt>0) { $ret = true; } return $ret; } mysql_close($connect); ?>