fetch_all("SELECT company, name, status FROM {$tables['estimate']} WHERE status IN ('상담대기중', '상담중', '견적발송완료') ORDER BY rdate DESC LIMIT 16"); foreach($reqs as $data) { $data['n_status'] = ($data['status'] == '상담중') ? "견적 상담중" : $data['status']; //$data['name'] = mb_substr($data['name'], 0, 1, 'utf-8') . str_repeat("*", mb_strlen($data['name'], 'utf-8') - 2) . mb_substr($data['name'], -1, 1, 'utf-8'); //$data['name'] = mb_substr($data['name'], 0, 1, 'utf-8') . '*' . mb_substr($data['name'], -1, 1, 'utf-8'); $data['name'] = mb_substr($data['name'], 0, 1, 'utf-8') . '**'; $html_code['estimate'] .= "

{$data['name']}님의 {$data['n_status']} new

"; } unset($data); // 포트폴리오 $lists = $claSQL->fetch_all("SELECT pid, cid, name, url, psdate, pedate, pthumb FROM {$tables['portfolio']} WHERE show_yn = 'Y' ORDER BY psort ASC LIMIT 6"); foreach($lists as $key => $list) { //$data = array(); $data = $claSQL->get_record($tables['service_files'], "type = 'P' AND tbid = '{$list['pid']}' AND is_image = 'Y' ORDER BY fid ASC LIMIT 1", "path, save_filename"); $data_thumb = $claSQL->get_record($tables['service_files'], "type = 'P' AND fid = '{$list['pthumb']}' AND is_image = 'Y' ORDER BY fid ASC LIMIT 1", "path, save_filename"); //print_r($data_thumb); if($data['save_filename']) { $img = getThumbs(array( 'src' => UPLOAD_DIR . $data['path'] . $data['save_filename'], 'upload_dir' => UPLOAD_DIR, 'upload_url' => UPLOAD_URL, 'sub_path' => $data['path'] ), array( 'width' => 304, 'height' => 250 )); $big_image = UPLOAD_URL . $data['path'] . $data['save_filename']; } if($data_thumb['save_filename']) { $img = getThumbs(array( 'src' => UPLOAD_DIR . $data_thumb['path'] . $data_thumb['save_filename'], 'upload_dir' => UPLOAD_DIR, 'upload_url' => UPLOAD_URL, 'sub_path' => $data_thumb['path'] ), array( 'width' => 304, 'height' => 250 )); } if($img && $data) { $thumb = "

"; } else { $thumb = ''; } $mobile = ($list['cid'] == 18) ? " 모바일버전

" : ""; $mgn = ($key != 0 && $k%3==0) ? 'margin_right_0' : ''; $is_hangul = 0; $url_tmp = str_replace("http://", "", $list['url']); if(preg_match("/[\xA1-\xFE][\xA1-\xFE]/", $url_tmp)) { $list['url'] = $url_tmp; $is_hangul = 1; } if(($key % 3) == 0) $html_code['portfolio'] .= "

"; $html_code['portfolio'] .= "

{$thumb}

{$list['name']}

"; if($list['psdate']) $project_sdate = " 프로젝트 기간 : {$list['psdate']} ~ "; if($list['pedate']) $project_edate = " {$list['pedate']} "; if($list['psdate']) $project_range = $project_sdate . $project_edate; else $project_range = '진행중'; if($list['psdate'] == '0000-00-00' || $list['pedate'] == '0000-00-00' )$project_range = '진행중'; //$project_range = ($list['psdate'] && $list['pedate']) ? "프로젝트 기간 : {$list['psdate']} ~ {$list['pedate']}" : ''; $project_range = ''; $html_code['portfolio'] .= "

$project_range

{$mobile}

"; } //{$data['thumb']} //

unset($lists, $list, $data); /*======================================================== ▣ HTML 헤더 출력 부분 ========================================================*/ include_once($g_path['home'] . '/skin/inc_header2.php'); ?>