query("delete from jcoregi where idx=$idx"); $lib->move_url("/job/job_all_l.html?page=$page&searchv=$searchv&scode1=scode1&scode2=scode2&sj_type=sj_type&sj_pay=sj_pay&sj_career=sj_career&ret_prog=$ret_prog"); exit; } $table="jcoregi"; $code_table="codes"; $query = "select a.idx as idx, a.user_id as user_id,a.co_name, a.j_name as regi_name, a.j_email as email"; $query = $query. " ,a.j_phone as phone,a.j_area, a.j_accept, a.j_type, a.j_sex, a.j_age, a.j_pay, a.j_schol "; $query = $query. ", a.j_career, a.j_edate, a.j_contin, a.j_kyword, a.j_title, a.j_content,a.r_date "; $query = $query. " ,a.img1, a.img2, a.img3, a.j_code1, a.j_code2 "; $query = $query. " ,code1.code_name as jcode1name, code2.code_name as jcode2name "; $query = $query. " from $table a "; $query = $query. " inner join $code_table code1 on a.j_code1 = code1.code_idx"; $query = $query. " inner join $code_table code2 on a.j_code2 = code2.code_idx"; $query = $query. " and a.idx = $idx "; $dbconn->query($query); $dbconn->next_record(); $idx = $dbconn->f("idx"); $user_id = $dbconn->f("user_id"); $r_name = $dbconn->f("regi_name"); $r_email = $dbconn->f("email"); $r_co_name = $dbconn->f("co_name"); $r_phone = $dbconn->f("phone"); $r_area = $dbconn->f("j_area"); if($r_area){ $tmparea = split(":",$r_area); $i=0; $areaval=""; while($tmparea[$i]){ if($tmparea[$i+1]){ $areaval = $areaval. $tmparea[$i]."   ,   "; }else{ $areaval = $areaval. $tmparea[$i]; } $i++; } } $r_accept = $dbconn->f("j_accept"); $acceptarr = split(":",$r_accept); $i=0; $raccept=""; while($acceptarr[$i]){ $raccept= $raccept.$acceptarr[$i]."   ,   "; $i++; } $raccept=substr(trim($raccept),0,-19); $r_type = $dbconn->f("j_type"); $r_sex = $dbconn->f("j_sex"); $r_age = $dbconn->f("j_age"); $r_age= (!$r_age) ? "나이무관" : $r_age." 년 이후출생"; $r_pay = $dbconn->f("j_pay"); $r_schol = $dbconn->f("j_schol"); $r_career = $dbconn->f("j_career"); $jcode1name = $dbconn->f("jcode1name"); $jcode2name = $dbconn->f("jcode2name"); $jcareer = $dbconn->f("j_career"); $r_title = $dbconn->f("j_title"); $r_content = stripslashes(nl2br($dbconn->f("j_content"))); $email = $dbconn->f("email"); $tmpedate = $dbconn->f("j_edate"); $r_edate= ($tmpedate=="0") ? "상시채용" : date("m-d-Y",$tmpedate); $jcontin = $dbconn->f("j_contin"); if($jcontin) $r_edate="상시"; $r_date=date("m-d-Y",$dbconn->f("r_date")); $img1 = $dbconn->f("img1"); $img2 = $dbconn->f("img2"); $img3 = $dbconn->f("img3"); //************************************************************************************// $photo = $dbconn->f("img1"); $img_h=90; $img_w=100; if($photo){ $photo="carimg/".$photo; $imgsize=GetImageSize($photo); $imgh = $imgsize[1]; $imgw = $imgsize[0]; if($imgsize[1] > $imgsize[0]){ //********************************* 세로큼 if($imgsize[1] > $img_h){ $ratio=$img_h/$imgsize[1]; $imgsize[1] = $img_h; $imgsize[0] = $imgsize[0]*$ratio; } }else{ if($imgsize[0] > $img_w){ $ratio=$img_w/$imgsize[0]; $imgsize[0] = $img_w; $imgsize[1] = $imgsize[1]*$ratio; } } } $photo2 = $dbconn->f("img2"); if($photo2){ $photo2="carimg/".$photo2; $imgsize2=GetImageSize($photo2); $imgh2 = $imgsize2[1]; $imgw2 = $imgsize2[0]; if($imgsize2[1] > $imgsize2[0]){ //********************************* 세로큼 if($imgsize2[1] > $img_h){ $ratio2=$img_h/$imgsize2[1]; $imgsize2[1] = $img_h; $imgsize2[0] = $imgsize2[0]*$ratio2; } }else{ if($imgsize2[0] > $img_w){ $ratio2=$img_w/$imgsize2[0]; $imgsize2[0] = $img_w; $imgsize2[1] = $imgsize2[1]*$ratio2; } } } $photo3 = $dbconn->f("img3"); if($photo3){ $photo3="carimg/".$photo3; $imgsize3=GetImageSize($photo3); $imgh3 = $imgsize3[1]; $imgw3 = $imgsize3[0]; if($imgsize3[1] > $imgsize3[0]){ //********************************* 세로큼 if($imgsize3[1] > $img_h){ $ratio3=$img_h/$imgsize[1]; $imgsize3[1] = $img_h; $imgsize3[0] = $imgsize3[0]*$ratio; } }else{ if($imgsize3[0] > $img_w){ $ratio3=$img_w/$imgsize3[0]; $imgsize3[0] = $img_w; $imgsize3[1] = $imgsize3[1]*$ratio3; } } } //************************************************************************ // 이전글, 다음글 구하기 $dbconn6 = new cjDB; $nextno = 0; $prevno = 0; $temp = 0; $query6 = "SELECT a.idx, a.r_date "; $query6 = $query6. " FROM jcoregi a "; $query6 = $query6. " inner join $code_table code1 on a.j_code1 = code1.code_idx"; $query6 = $query6. " inner join $code_table code2 on a.j_code2 = code2.code_idx"; if($ret_prog=="bookmark"){ $query6 = $query6. " inner join lo_myhome b on b.co_idx = a.idx "; $query6 = $query6. " and b.user_id='$login_id' and b.type='job_co' "; } if($ret_prog=="company"){ $query6 = $query6. " and a.user_id = '$login_id' "; } if($ret_prog=="teach"){ $query6 = $query6. " and a.j_code1 = 1929 "; } if($ret_prog=="alba" || $ret_prog=="mainalba"){ $query6 = $query6. " and a.j_code1 = 1937 "; } if($ret_prog=="main"){ $query6 = $query6. " and a.j_code1 != 1937 "; } if($searchv){ /********************검색쿼리시작**********************************/ if($scode1){ $query = $query. " and a.j_code1 = $scode1 "; } if($scode2){ $query = $query. " and a.j_code2 = $scode2 "; } if($sj_type){ $query = $query. " and a.j_type = $sj_type "; } if($sj_pay){ $query = $query. " and a.j_pay = '$sj_pay' "; } if($sj_career){ $query = $query. " and a.j_career = '$sj_career' "; } /********************검색쿼리 끝**********************************/ } $query6 = $query6." order by a.r_date desc"; $dbconn6->query($query6); $dbconn6->next_record(); while($dbconn6->f("idx")){ if($idx == $dbconn6->f("idx")){ $nextno = $temp; $dbconn6->next_record(); if($dbconn6->f("idx")){ $prevno = $dbconn6->f("idx"); }else{ $dbconn6->pre_record(); } break; }else{ $temp = $dbconn6->f("idx"); } $dbconn6->next_record(); } $dbconn6->disconnect(); // 이전글 구하기 끝 //***************************************************************** ?> "findchicago.com" 에 오신 것을 환영합니다.
Home > 구인정보 > 상세정보
수정 "; } echo $modilink."  "; if($login_grade=="A" || ( $login_id && ($user_id == $login_id))){?> 삭제    



disconnect(); ?> toggleMenu('menu1'); "); } if($ret_prog=="company"){ echo (" "); } if($ret_prog=="teach"){ echo (" "); } if($ret_prog=="alba"){ echo (" "); } ?>