getOneDAO("count(*)",$table_name, $_whereis, 1); if($cnt>=5) { AlertBack("부 관리자는 5명 까지 등록 가능합니다."); die(); } if (is_uploaded_file($_FILES['nm_file']['tmp_name'])) { if($_FILES['nm_file']['size'] > 0 ){ $upload_file_name = upload($_FILES['nm_file'],$upload_path."nm_file/", 800, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_name==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } $_fields = Array( "cd_dealerid" => $cd_dealerid , "cd_dealer_p" => $s_cd_dealer , "nm_pass" => $nm_pass , "ds_type" => $ds_type , "ds_usertype" => $ds_usertype , "ds_level" => $ds_level , "nm_company" => $nm_company , "nm_name" => $nm_name , "nm_birth" => $nm_birth , "nm_tel_01" => $nm_tel_01 , "nm_tel_02" => $nm_tel_02 , "nm_tel_03" => $nm_tel_03 , "nm_hp_01" => $nm_hp_01 , "nm_hp_02" => $nm_hp_02 , "nm_hp_03" => $nm_hp_03 , "nm_fax_01" => $nm_fax_01 , "nm_fax_02" => $nm_fax_02 , "nm_fax_03" => $nm_fax_03 , "nm_email" => $nm_email , "nm_zip" => $nm_zip , "nm_addr" => $nm_addr , "nm_addr_sub" => $nm_addr_sub , "nm_etc_01" => $nm_etc_01 , "nm_etc_02" => $nm_etc_02 , "nm_etc_03" => $nm_etc_03 , "ds_status" => $ds_status , "nm_company_biz" => $nm_company_biz , "nm_name_biz" => $nm_name_biz , "nm_no_biz" => $nm_no_biz , "nm_date_biz" => $nm_date_biz , "nm_type_biz" => $nm_type_biz , "nm_condition_biz" => $nm_condition_biz , "nm_tel_biz_01" => $nm_tel_biz_01 , "nm_tel_biz_02" => $nm_tel_biz_02 , "nm_tel_biz_03" => $nm_tel_biz_03 , "nm_hp_biz_01" => $nm_hp_biz_01 , "nm_hp_biz_02" => $nm_hp_biz_02 , "nm_hp_biz_03" => $nm_hp_biz_03 , "nm_fax_biz_01" => $nm_fax_biz_01 , "nm_fax_biz_02" => $nm_fax_biz_02 , "nm_fax_biz_03" => $nm_fax_biz_03 , "nm_email_biz" => $nm_email_biz , "nm_zip_biz" => $nm_zip_biz , "nm_addr_biz" => $nm_addr_biz , "nm_addr_sub_biz" => $nm_addr_sub_biz , "ds_company_bp1" => $ds_company_bp1 , "ds_branch1" => $ds_branch1 , "ds_company_bp2" => $ds_company_bp2 , "ds_branch2" => $ds_branch2 , "ds_company_bp3" => $ds_company_bp3 , "ds_branch3" => $ds_branch3 , "nm_area" => $nm_area , "nm_title" => $nm_title , "nm_file" => $upload_file_name , "nm_etc" => $nm_etc , "dt_insert" => now() , "nm_insert" => $nm_insert , "dt_update" => now() , "nm_update" => $nm_update , "ds_delind" => "N" ); $result = $dbCon->insertDAO($_fields,$table_name); //echo $result; //echo "
"; $cd_dealer = mysql_insert_id(); $sqlPwd="UPDATE dealer_master set nm_pass = password('".$nm_pass."'), cd_dealer_p = '".$s_cd_dealer."' where cd_dealer = '".$cd_dealer."'"; $result = $dbCon->query($sqlPwd); //echo $result; //echo "
"; //exit; if ($result) { AlertRedirect("등록에 성공 하였습니다.","dealer_manager.php"); }else{ AlertBack("등록 실패 하였습니다."); } break; //수정하기 case "Update": if (is_uploaded_file($_FILES['nm_file']['tmp_name'])) { if($_FILES['nm_file']['size'] > 0 ){ $upload_file_name = upload($_FILES['nm_file'],$upload_path."nm_file/", 800, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_name==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } if ($upload_file_name == ""){ $_fields = Array( "nm_company" => $nm_company , "nm_name" => $nm_name , "nm_birth" => $nm_birth , "nm_tel_01" => $nm_tel_01 , "nm_tel_02" => $nm_tel_02 , "nm_tel_03" => $nm_tel_03 , "nm_hp_01" => $nm_hp_01 , "nm_hp_02" => $nm_hp_02 , "nm_hp_03" => $nm_hp_03 , "nm_fax_01" => $nm_fax_01 , "nm_fax_02" => $nm_fax_02 , "nm_fax_03" => $nm_fax_03 , "nm_email" => $nm_email , "nm_zip" => $nm_zip , "nm_addr" => $nm_addr , "nm_addr_sub" => $nm_addr_sub , "nm_etc_01" => $nm_etc_01 , "nm_etc_02" => $nm_etc_02 , "nm_etc_03" => $nm_etc_03 , "ds_status" => $ds_status , "nm_company_biz" => $nm_company_biz , "nm_name_biz" => $nm_name_biz , "nm_no_biz" => $nm_no_biz , "nm_date_biz" => $nm_date_biz , "nm_type_biz" => $nm_type_biz , "nm_condition_biz" => $nm_condition_biz , "nm_tel_biz_01" => $nm_tel_biz_01 , "nm_tel_biz_02" => $nm_tel_biz_02 , "nm_tel_biz_03" => $nm_tel_biz_03 , "nm_hp_biz_01" => $nm_hp_biz_01 , "nm_hp_biz_02" => $nm_hp_biz_02 , "nm_hp_biz_03" => $nm_hp_biz_03 , "nm_fax_biz_01" => $nm_fax_biz_01 , "nm_fax_biz_02" => $nm_fax_biz_02 , "nm_fax_biz_03" => $nm_fax_biz_03 , "nm_email_biz" => $nm_email_biz , "nm_zip_biz" => $nm_zip_biz , "nm_addr_biz" => $nm_addr_biz , "nm_addr_sub_biz" => $nm_addr_sub_biz // , "ds_company_bp1" => $ds_company_bp1 // , "ds_branch1" => $ds_branch1 // , "ds_company_bp2" => $ds_company_bp2 // , "ds_branch2" => $ds_branch2 // , "ds_company_bp3" => $ds_company_bp3 // , "ds_branch3" => $ds_branch3 , "nm_area" => $nm_area , "nm_title" => $nm_title , // "dt_insert" => now(), // "nm_insert" => $cd_procid, "dt_update" => now(), "nm_update" => $cd_procid, ); }else{ $_fields = Array( "nm_company" => $nm_company , "nm_name" => $nm_name , "nm_birth" => $nm_birth , "nm_tel_01" => $nm_tel_01 , "nm_tel_02" => $nm_tel_02 , "nm_tel_03" => $nm_tel_03 , "nm_hp_01" => $nm_hp_01 , "nm_hp_02" => $nm_hp_02 , "nm_hp_03" => $nm_hp_03 , "nm_fax_01" => $nm_fax_01 , "nm_fax_02" => $nm_fax_02 , "nm_fax_03" => $nm_fax_03 , "nm_email" => $nm_email , "nm_zip" => $nm_zip , "nm_addr" => $nm_addr , "nm_addr_sub" => $nm_addr_sub , "nm_etc_01" => $nm_etc_01 , "nm_etc_02" => $nm_etc_02 , "nm_etc_03" => $nm_etc_03 , "ds_status" => $ds_status , "nm_company_biz" => $nm_company_biz , "nm_name_biz" => $nm_name_biz , "nm_no_biz" => $nm_no_biz , "nm_date_biz" => $nm_date_biz , "nm_type_biz" => $nm_type_biz , "nm_condition_biz" => $nm_condition_biz , "nm_tel_biz_01" => $nm_tel_biz_01 , "nm_tel_biz_02" => $nm_tel_biz_02 , "nm_tel_biz_03" => $nm_tel_biz_03 , "nm_hp_biz_01" => $nm_hp_biz_01 , "nm_hp_biz_02" => $nm_hp_biz_02 , "nm_hp_biz_03" => $nm_hp_biz_03 , "nm_fax_biz_01" => $nm_fax_biz_01 , "nm_fax_biz_02" => $nm_fax_biz_02 , "nm_fax_biz_03" => $nm_fax_biz_03 , "nm_email_biz" => $nm_email_biz , "nm_zip_biz" => $nm_zip_biz , "nm_addr_biz" => $nm_addr_biz , "nm_addr_sub_biz" => $nm_addr_sub_biz // , "ds_company_bp1" => $ds_company_bp1 // , "ds_branch1" => $ds_branch1 // , "ds_company_bp2" => $ds_company_bp2 // , "ds_branch2" => $ds_branch2 // , "ds_company_bp3" => $ds_company_bp3 // , "ds_branch3" => $ds_branch3 , "nm_area" => $nm_area , "nm_title" => $nm_title , "nm_file" => $upload_file_name , // "dt_insert" => now(), // "nm_insert" => $cd_procid, "dt_update" => now(), "nm_update" => $cd_procid, ); } $result = $dbCon->updateDAO($_fields,$table_name,"cd_dealer='".$cd_dealer."'"); if($_POST["nm_pass"]){ $sqlPwd="UPDATE dealer_master set nm_pass = password('".$nm_pass."') where cd_dealer = '".$cd_dealer."'"; $result = $dbCon->query($sqlPwd); } if ($result) { AlertRedirect("수정 성공 하였습니다.","dealer_manager.php"); }else{ AlertBack("수정 실패 하였습니다."); } break; //수정하기 case "UpdateDealer": if (is_uploaded_file($_FILES['nm_file']['tmp_name'])) { if($_FILES['nm_file']['size'] > 0 ){ $upload_file_name = upload($_FILES['nm_file'],$upload_path."nm_file/", 800, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_name==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } if ($upload_file_name == ""){ $_fields = Array( "nm_company" => $nm_company , "nm_name" => $nm_name , "nm_birth" => $nm_birth , "nm_tel_01" => $nm_tel_01 , "nm_tel_02" => $nm_tel_02 , "nm_tel_03" => $nm_tel_03 , "nm_hp_01" => $nm_hp_01 , "nm_hp_02" => $nm_hp_02 , "nm_hp_03" => $nm_hp_03 , "nm_fax_01" => $nm_fax_01 , "nm_fax_02" => $nm_fax_02 , "nm_fax_03" => $nm_fax_03 , "nm_email" => $nm_email , "nm_zip" => $nm_zip , "nm_addr" => $nm_addr , "nm_addr_sub" => $nm_addr_sub , "nm_etc_01" => $nm_etc_01 , "nm_etc_02" => $nm_etc_02 , "nm_etc_03" => $nm_etc_03 // , "ds_status" => $ds_status , "nm_company_biz" => $nm_company_biz , "nm_name_biz" => $nm_name_biz , "nm_no_biz" => $nm_no_biz , "nm_date_biz" => $nm_date_biz , "nm_type_biz" => $nm_type_biz , "nm_condition_biz" => $nm_condition_biz , "nm_tel_biz_01" => $nm_tel_biz_01 , "nm_tel_biz_02" => $nm_tel_biz_02 , "nm_tel_biz_03" => $nm_tel_biz_03 , "nm_hp_biz_01" => $nm_hp_biz_01 , "nm_hp_biz_02" => $nm_hp_biz_02 , "nm_hp_biz_03" => $nm_hp_biz_03 , "nm_fax_biz_01" => $nm_fax_biz_01 , "nm_fax_biz_02" => $nm_fax_biz_02 , "nm_fax_biz_03" => $nm_fax_biz_03 , "nm_email_biz" => $nm_email_biz , "nm_zip_biz" => $nm_zip_biz , "nm_addr_biz" => $nm_addr_biz , "nm_addr_sub_biz" => $nm_addr_sub_biz // , "ds_company_bp1" => $ds_company_bp1 // , "ds_branch1" => $ds_branch1 // , "ds_company_bp2" => $ds_company_bp2 // , "ds_branch2" => $ds_branch2 // , "ds_company_bp3" => $ds_company_bp3 // , "ds_branch3" => $ds_branch3 , "nm_area" => $nm_area , "nm_title" => $nm_title , // "dt_insert" => now(), // "nm_insert" => $cd_procid, "dt_update" => now(), "nm_update" => $cd_procid, ); }else{ $_fields = Array( "nm_company" => $nm_company , "nm_name" => $nm_name , "nm_birth" => $nm_birth , "nm_tel_01" => $nm_tel_01 , "nm_tel_02" => $nm_tel_02 , "nm_tel_03" => $nm_tel_03 , "nm_hp_01" => $nm_hp_01 , "nm_hp_02" => $nm_hp_02 , "nm_hp_03" => $nm_hp_03 , "nm_fax_01" => $nm_fax_01 , "nm_fax_02" => $nm_fax_02 , "nm_fax_03" => $nm_fax_03 , "nm_email" => $nm_email , "nm_zip" => $nm_zip , "nm_addr" => $nm_addr , "nm_addr_sub" => $nm_addr_sub , "nm_etc_01" => $nm_etc_01 , "nm_etc_02" => $nm_etc_02 , "nm_etc_03" => $nm_etc_03 // , "ds_status" => $ds_status , "nm_company_biz" => $nm_company_biz , "nm_name_biz" => $nm_name_biz , "nm_no_biz" => $nm_no_biz , "nm_date_biz" => $nm_date_biz , "nm_type_biz" => $nm_type_biz , "nm_condition_biz" => $nm_condition_biz , "nm_tel_biz_01" => $nm_tel_biz_01 , "nm_tel_biz_02" => $nm_tel_biz_02 , "nm_tel_biz_03" => $nm_tel_biz_03 , "nm_hp_biz_01" => $nm_hp_biz_01 , "nm_hp_biz_02" => $nm_hp_biz_02 , "nm_hp_biz_03" => $nm_hp_biz_03 , "nm_fax_biz_01" => $nm_fax_biz_01 , "nm_fax_biz_02" => $nm_fax_biz_02 , "nm_fax_biz_03" => $nm_fax_biz_03 , "nm_email_biz" => $nm_email_biz , "nm_zip_biz" => $nm_zip_biz , "nm_addr_biz" => $nm_addr_biz , "nm_addr_sub_biz" => $nm_addr_sub_biz // , "ds_company_bp1" => $ds_company_bp1 // , "ds_branch1" => $ds_branch1 // , "ds_company_bp2" => $ds_company_bp2 // , "ds_branch2" => $ds_branch2 // , "ds_company_bp3" => $ds_company_bp3 // , "ds_branch3" => $ds_branch3 , "nm_area" => $nm_area , "nm_title" => $nm_title , "nm_file" => $upload_file_name , // "dt_insert" => now(), // "nm_insert" => $cd_procid, "dt_update" => now(), "nm_update" => $cd_procid, ); } $result = $dbCon->updateDAO($_fields,$table_name,"cd_dealer='".$cd_dealer."'"); if($_POST["nm_pass"]){ $sqlPwd="UPDATE dealer_master set nm_pass = password('".$nm_pass."') where cd_dealer = '".$cd_dealer."'"; $result = $dbCon->query($sqlPwd); } if ($result) { AlertRedirect("수정 성공 하였습니다.","dealer_modify.php"); }else{ AlertBack("수정 실패 하였습니다."); } break; //입찰하기 case "Tender" : $s_cd_dealerid = $_SESSION['s_cd_dealerid']; $s_nm_email = $_SESSION['s_nm_email']; $s_nm_name = $_SESSION['s_nm_name']; $s_nm_hp = $_SESSION['s_nm_hp']; $s_ds_type = $_SESSION['s_ds_type']; $s_cd_dealer = $_SESSION['s_cd_dealer']; $s_cd_dealer_p = $_SESSION['s_cd_dealer_p']; $s_nm_area = $_SESSION['s_nm_area']; $sql = "insert into tender_master(cd_sale, cd_user, cd_dealer, cd_dealer_p, ds_type, ds_usertype, nm_name, nm_tel, nm_hp, nm_email, nm_price, nm_cont, ds_status, dt_insert, nm_insert, dt_update, nm_update, ds_delind) SELECT cd_sale, cd_user, $s_cd_dealer cd_dealer, $s_cd_dealer_p cd_dealer_p, ds_type, '$s_ds_type' ds_usertype, '$s_nm_name' nm_name, '' nm_tel, '$s_nm_hp' nm_hp, '$s_nm_email' nm_email, $nm_price nm_price, '' nm_cont, 'A0' ds_status, now() dt_insert, $s_cd_dealer nm_insert, now() dt_update, $s_cd_dealer nm_update, 'N' ds_delind FROM sale_master where cd_sale = '".$cd_sale."'"; $result = $dbCon->query($sql); if ($result) { AlertRedirect("입찰 되었습니다.","dealer_tender_view.php?cd_sale=$cd_sale&ds_status_sale=E0&ds_status=E0"); }else{ AlertRedirect("입찰 실패하였습니다.","dealer_tender_view.php?cd_sale=$cd_sale&ds_status_sale=E0&ds_status=E0"); } break; //낙찰하기 case "TenderSuccess" : $cd_sale = trim(avoid_crack($_POST["cd_sale"])); $cd_tender = trim(avoid_crack($_POST["cd_tender"])); $nm_price = trim(avoid_crack($_POST["nm_price"])); $sql="update tender_master set ds_status = 'Z0' , dt_update = now() , nm_update = '$cd_userid' WHERE cd_tender = $cd_tender"; $result = mysql_query($sql,$connect); $sql="update sale_master set ds_status = 'Z0' , nm_price = '$nm_price' , dt_update = now() , nm_update = '$cd_userid' WHERE cd_sale = $cd_sale"; $result = mysql_query($sql,$connect); if ($result) { AlertRedirect("낙찰하기 성공하였습니다.","sell_view.php?cd_sale=$cd_sale&ds_status_sale=Z0&ds_status=Z0"); }else{ AlertRedirect("낙찰하기 실패하였습니다.","sell_view.php?cd_sale=$cd_sale&ds_status_sale=Z0&ds_status=Z0"); } break; //낙찰하기 Nomember case "TenderSuccessNomember" : $cd_sale = trim(avoid_crack($_POST["cd_sale"])); $cd_tender = trim(avoid_crack($_POST["cd_tender"])); $nm_price = trim(avoid_crack($_POST["nm_price"])); $nm_name = trim(avoid_crack($_POST["nm_name"])); $nm_hp = trim(avoid_crack($_POST["nm_hp"])); $nm_number = trim(avoid_crack($_POST["nm_number"])); $sql="update tender_master set ds_status = 'Z0' , dt_update = now() , nm_update = '$cd_userid' WHERE cd_tender = $cd_tender"; $result = mysql_query($sql,$connect); $sql="update sale_master set ds_status = 'Z0' , nm_price = '$nm_price' , dt_update = now() , nm_update = '$cd_userid' WHERE cd_sale = $cd_sale"; $result = mysql_query($sql,$connect); if ($result) { AlertRedirect("낙찰하기 성공하였습니다.","/sell/sell_view_nomember.php?nm_name=$nm_name&nm_hp=$nm_hp&nm_number=$nm_number&ds_status_sale=Z0&ds_status=Z0"); }else{ AlertRedirect("낙찰하기 실패하였습니다.","/sell/sell_view_nomember.php?nm_name=$nm_name&nm_hp=$nm_hp&nm_number=$nm_number&ds_status_sale=Z0&ds_status=Z0"); } break; //Contract Step 1 case "ContractStep1" : $cd_sale = trim(avoid_crack($_POST["cd_sale"])); // $cd_tender = trim(avoid_crack($_POST["cd_tender"])); $ds_status_contract_step1 = trim(avoid_crack($_POST["ds_status_contract_step1"])); $sql="update sale_master set ds_status_contract_step1 = '$ds_status_contract_step1' , dt_update = now() , nm_update = '$cd_userid' WHERE cd_sale = $cd_sale"; $result = $dbCon->query($sql); if ($result) { AlertRedirect("등록 되었습니다.","dealer_tender_view2.php?cd_sale=$cd_sale"); }else{ AlertRedirect("등록 실패하였습니다.","dealer_tender_view2.php?cd_sale=$cd_sale"); } break; //Contract Step 2 case "ContractStep2" : $cd_sale = trim(avoid_crack($_POST["cd_sale"])); // $cd_tender = trim(avoid_crack($_POST["cd_tender"])); $nm_contract_date = trim(avoid_crack($_POST["nm_contract_date"])); $ds_status_contract_step2 = "Y"; $sql="update sale_master set ds_status_contract_step2 = '$ds_status_contract_step2' , nm_contract_date = '$nm_contract_date' , dt_update = now() , nm_update = '$cd_userid' WHERE cd_sale = $cd_sale"; $result = $dbCon->query($sql); if ($result) { AlertRedirect("등록 되었습니다.","dealer_tender_view2.php?cd_sale=$cd_sale"); }else{ AlertRedirect("등록 실패하였습니다.","dealer_tender_view2.php?cd_sale=$cd_sale"); } break; //Contract Step 3 case "ContractStep3" : $cd_sale = trim(avoid_crack($_POST["cd_sale"])); // $cd_tender = trim(avoid_crack($_POST["cd_tender"])); $ds_status_contract = trim(avoid_crack($_POST["ds_status_contract"])); $nm_price_final = trim(avoid_crack($_POST["nm_price_final"])); $nm_contract_cont_final = trim(avoid_crack($_POST["nm_contract_cont_final"])); $nm_contract_fail_reason = trim(avoid_crack($_POST["nm_contract_fail_reason"])); $ds_status_contract_step3 = "Y"; if (is_uploaded_file($_FILES['nm_file_chk1']['tmp_name'])) { if($_FILES['nm_file_chk1']['size'] > 0 ){ $upload_file_name_chk1 = upload($_FILES['nm_file_chk1'],$upload_path."contract_step/".$cd_sale."_detail", 800, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_name_chk1==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } if (is_uploaded_file($_FILES['nm_file_chk2']['tmp_name'])) { if($_FILES['nm_file_chk2']['size'] > 0 ){ $upload_file_name_chk2 = upload($_FILES['nm_file_chk2'],$upload_path."contract_step/".$cd_sale."_detail", 800, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_name_chk2==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } if (is_uploaded_file($_FILES['nm_file_chk3']['tmp_name'])) { if($_FILES['nm_file_chk3']['size'] > 0 ){ $upload_file_name_chk3 = upload($_FILES['nm_file_chk3'],$upload_path."contract_step/".$cd_sale."_detail", 800, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_name_chk3==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } if (is_uploaded_file($_FILES['nm_file_chk4']['tmp_name'])) { if($_FILES['nm_file_chk4']['size'] > 0 ){ $upload_file_name_chk4 = upload($_FILES['nm_file_chk4'],$upload_path."contract_step/".$cd_sale."_detail", 800, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_name_chk4==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } if (is_uploaded_file($_FILES['nm_file_chk5']['tmp_name'])) { if($_FILES['nm_file_chk5']['size'] > 0 ){ $upload_file_name_chk5 = upload($_FILES['nm_file_chk5'],$upload_path."contract_step/".$cd_sale."_detail", 800, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_name_chk5==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } $sql="update sale_master set ds_status_contract_step3 = '$ds_status_contract_step3' , ds_status_contract = '$ds_status_contract' , nm_price_final = '$nm_price_final' , nm_contract_cont_final = '$nm_contract_cont_final' , nm_contract_fail_reason = '$nm_contract_fail_reason' , nm_file_chk1 = case when '$upload_file_name_chk1' = '' then nm_file_chk1 else '$upload_file_name_chk1' end , nm_file_chk2 = case when '$upload_file_name_chk2' = '' then nm_file_chk2 else '$upload_file_name_chk2' end , nm_file_chk3 = case when '$upload_file_name_chk3' = '' then nm_file_chk3 else '$upload_file_name_chk3' end , nm_file_chk4 = case when '$upload_file_name_chk4' = '' then nm_file_chk4 else '$upload_file_name_chk4' end , nm_file_chk5 = case when '$upload_file_name_chk5' = '' then nm_file_chk5 else '$upload_file_name_chk5' end , dt_update = now() , nm_update = '$cd_userid' WHERE cd_sale = $cd_sale"; //echo $sql; //exit; $result = $dbCon->query($sql); if ($result) { AlertRedirect("등록 되었습니다.","dealer_tender_view2.php?cd_sale=$cd_sale"); }else{ AlertRedirect("등록 실패하였습니다.","dealer_tender_view2.php?cd_sale=$cd_sale"); } break; //Contract Step 4 case "ContractStep4" : $cd_sale = trim(avoid_crack($_POST["cd_sale"])); // $cd_tender = trim(avoid_crack($_POST["cd_tender"])); $ds_status_contract_step4 = "Y"; if (is_uploaded_file($_FILES['nm_file_trading']['tmp_name'])) { if($_FILES['nm_file_trading']['size'] > 0 ){ $upload_file_name_trading = upload($_FILES['nm_file_trading'],$upload_path."contract_step/".$cd_sale."_detail", 800, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_name_trading==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } if (is_uploaded_file($_FILES['nm_file_performance']['tmp_name'])) { if($_FILES['nm_file_performance']['size'] > 0 ){ $upload_file_name_performance = upload($_FILES['nm_file_performance'],$upload_path."contract_step/".$cd_sale."_detail", 800, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_name_performance==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } if (is_uploaded_file($_FILES['nm_file_postscript']['tmp_name'])) { if($_FILES['nm_file_postscript']['size'] > 0 ){ $upload_file_name_postscript = upload($_FILES['nm_file_postscript'],$upload_path."contract_step/".$cd_sale."_detail", 800, array('gif', 'jpeg', 'jpg','png','bmp' ,'ttif')); if($upload_file_name_postscript==false){ AlertBack("첨부파일 업로드 실패 하였습니다."); die(); } } } $sql="update sale_master set ds_status_contract_step4 = '$ds_status_contract_step4' , nm_file_trading = case when '$upload_file_name_trading' = '' then nm_file_trading else '$upload_file_name_trading' end , nm_file_performance = case when '$upload_file_name_performance' = '' then nm_file_performance else '$upload_file_name_performance' end , nm_file_postscript = case when '$upload_file_name_postscript' = '' then nm_file_postscript else '$upload_file_name_postscript' end , ds_status = case when ds_status_contract = 'Z0' and ds_status_contract_step1 = 'Y' and ds_status_contract_step2 = 'Y' and ds_status_contract_step3 = 'Y' and ds_status_contract_step4 = 'Y' then 'ZS' else ds_status end , dt_update = now() , nm_update = '$cd_userid' WHERE cd_sale = $cd_sale"; $result = $dbCon->query($sql); if ($result) { AlertRedirect("등록 되었습니다.","dealer_tender_view2.php?cd_sale=$cd_sale"); }else{ AlertRedirect("등록 실패하였습니다.","dealer_tender_view2.php?cd_sale=$cd_sale"); } break; //후기쓰기 case "WritePostscript" : $cd_sale = trim(avoid_crack($_POST["cd_sale"])); $nm_score_postscript = trim(avoid_crack($_POST["nm_score_postscript"])); $nm_cont_postscript = trim(avoid_crack($_POST["nm_cont_postscript"])); $sql="update sale_master set nm_score_postscript = '$nm_score_postscript' , nm_cont_postscript = '$nm_cont_postscript' , dt_update = now() , nm_update = '$cd_userid' WHERE cd_sale = $cd_sale"; $result = $dbCon->query($sql); if ($result) { AlertRedirect("등록 되었습니다.","sell_view2.php?cd_sale=$cd_sale"); }else{ AlertRedirect("등록 실패하였습니다.","sell_view2.php?cd_sale=$cd_sale"); } break; //후기쓰기 Nomember case "WritePostscriptNomember" : $cd_sale = trim(avoid_crack($_POST["cd_sale"])); $nm_score_postscript = trim(avoid_crack($_POST["nm_score_postscript"])); $nm_cont_postscript = trim(avoid_crack($_POST["nm_cont_postscript"])); $nm_name = trim(avoid_crack($_POST["nm_name"])); $nm_hp = trim(avoid_crack($_POST["nm_hp"])); $nm_number = trim(avoid_crack($_POST["nm_number"])); $sql="update sale_master set nm_score_postscript = '$nm_score_postscript' , nm_cont_postscript = '$nm_cont_postscript' , dt_update = now() , nm_update = '$cd_userid' WHERE cd_sale = $cd_sale"; $result = $dbCon->query($sql); if ($result) { AlertRedirect("등록 성공하였습니다.","/sell/sell_view_nomember.php?nm_name=$nm_name&nm_hp=$nm_hp&nm_number=$nm_number&ds_status_sale=Z0&ds_status=Z0"); }else{ AlertRedirect("등록 실패하였습니다.","/sell/sell_view_nomember.php?nm_name=$nm_name&nm_hp=$nm_hp&nm_number=$nm_number&ds_status_sale=Z0&ds_status=Z0"); } break; //Contract Step Error case "ContractStepError" : $cd_sale = trim(avoid_crack($_POST["cd_sale"])); // $cd_tender = trim(avoid_crack($_POST["cd_tender"])); $nm_cont_tender_error = trim(avoid_crack($_POST["nm_cont_tender_error"])); $ds_status_contract_step1 = "N"; $sql="update sale_master set ds_status = 'ZE' , ds_status_contract_step1 = '$ds_status_contract_step1' , nm_cont_tender_error = '$nm_cont_tender_error' , dt_update = now() , nm_update = '$cd_userid' WHERE cd_sale = $cd_sale"; $result = $dbCon->query($sql); if ($result) { AlertRedirect("등록 되었습니다.","dealer_tender_view2.php?cd_sale=$cd_sale"); }else{ AlertRedirect("등록 실패하였습니다.","dealer_tender_view2.php?cd_sale=$cd_sale"); } break; //삭제하기 case "Delete" : $_fields = Array( "ds_delind"=>"Y", "dt_update" => now(), "nm_update" => $cd_procid ); $result = $dbCon->updateDAO($_fields,$table_name,"cd_dealer='".$cd_dealer."'"); if ($result) { AlertRedirect("삭제 되었습니다.","list.php?PageNo=$PageNo"); }else{ AlertRedirect("삭제 실패하였습니다.","list.php?PageNo=$PageNo"); } break; case "IdChk": $_whereis = " cd_dealerid = '". $cd_dealerid . "'"; $cnt = $dbCon->getOneDAO("count(*)",$table_name, $_whereis, 1); if($cnt==0) { echo("Y"); exit; } else { echo("N"); exit; } break; case "IdSearch": $_whereis = " ds_delind='N' And nm_name = '". $nm_name . "' AND nm_email = '". $nm_email . "'"; $userid = $dbCon->getOneDAO("cd_dealerid",$table_name, $_whereis, 1); if($userid) { echo($userid); exit; } else { echo(""); exit; } break; case "PwSearch": $_whereis = " ds_delind='N' And cd_dealerid = '".$cd_dealerid."' And nm_name = '". $nm_name . "' AND nm_email = '". $nm_email . "'"; $userid = $dbCon->getOneDAO("cd_dealer",$table_name, $_whereis, 1); if($userid) { $new_passwd = generatePassword(8); $sqlPwd="UPDATE dealer_master set nm_pass = password('".$new_passwd."') where cd_dealer = '".$userid."'"; $result = $dbCon->query($sqlPwd); echo($new_passwd); exit; } else { echo(""); exit; } break; default : AlertBack("지정되지않은 요청입니다"); break; } mysql_close($connect); ?>