검색정보입력
검색
= '".str_replace(".","",$SDATE)."' ";
//if($EDATE)$plusQuery .= " and apvPermYmd <= '".str_replace(".","",$EDATE)."' ";
if($SDATE)$plusQuery .= " and writeDate >= STR_TO_DATE('".str_replace(".","-",$SDATE)." 00:00:00' ,'%Y-%m-%d %H:%i:%s') ";
if($EDATE)$plusQuery .= " and writeDate <= STR_TO_DATE('".str_replace(".","-",$EDATE)." 23:59:59' ,'%Y-%m-%d %H:%i:%s') ";
if($SIDO){
$ARR_ADDR = " '$SIDO' ";
$q_sido =" SELECT Code FROM {$DBTABLE['CODE']} where CodeType='sigunguCode' and Comment='$SIDO' ";
$rs_sido=mysqli_query($dbCon,$q_sido) or die("db error");
while($sido = mysqli_fetch_array($rs_sido)){
$ARR_ADDR .= " , '".$sido["Code"]."' ";
}
$plusQuery .= " and opnSfTeamCode in (".$ARR_ADDR.") ";
}
if($SIGUNGU){
$plusQuery .= " and opnSfTeamCode in ('".$SIGUNGU."') ";
}
if($KEYWORD)$plusQuery .= " and bplcNm like '%".$KEYWORD."%' ";
// 로그 저장
if($plusQuery && $memVerInfo['UIDX']){
$q_log =" insert into {$DBTABLE['search_log']} set ";
$q_log.=" UIDX = ".$memVerInfo['UIDX']." ";
$q_log.=" ,SECTORS1 = '".$SECTORS1."' ";
$q_log.=" ,SECTORS2 = '".$SECTORS2."' ";
$q_log.=" ,SECTORS3 = '".$SECTORS3."' ";
$q_log.=" ,SDATE = '".$SDATE."' ";
$q_log.=" ,EDATE = '".$EDATE."' ";
$q_log.=" ,BIZTYPE = '".$BIZTYPE."' ";
$q_log.=" ,SIDO = '".$SIDO."' ";
$q_log.=" ,SIGUNGU = '".$SIGUNGU."' ";
$q_log.=" ,KEYWORD = '".$KEYWORD."' ";
$res_log=mysqli_query($dbCon,$q_log) or die("db error1 ".mysqli_error($dbCon));
}
$query =" select count(*) as cnt from {$DBTABLE['ALL_LODA']} where 1 $plusQuery ";
//echo $query ;
$result=mysqli_query($dbCon,$query) or die("db error ". mysqli_error($dbCon));
$row_cnt = mysqli_fetch_array($result);
$total = $row_cnt["cnt"];
if(!$license["SIDX"])if($p>5)$p=5;
if(!$linesu)$linesu=10;
$psu=10;
if(!$p) $p=1;
$start=($p-1)*$linesu;
$end=$start+$linesu;
$totp=ceil($total/$linesu);
$query =" select A.* ";
$query.=" from {$DBTABLE['ALL_LODA']} A where 1 $plusQuery ";
//$query.=" order by writeDate desc ";
$query.=" limit $start, $linesu";
//echo $query;
$result=mysqli_query($dbCon,$query) or die("db error ".mysqli_error($dbCon));
$n = mysqli_num_rows($result);
?>
상호명, 업종(대), 업종(중), 업종(소), 우편번호, 주소, 전화번호, 사업자신고일, 영업상태, 데이터갱신일로 구성
| 상호명 |
업종(대) |
업종(중) |
업종(소) |
우편번호 |
주소 |
전화번호 |
사업자신고일 |
영업상태 |
데이터갱신일 |
fetch_array(MYSQLI_ASSOC)){
if($MODE <= 2)$onClick1 = "onClick=\"location.href='inquire_view.html?MODE=$MODE&BIDX={$row['BIDX']}'\"";
$onClick2 = "onClick=\"boardEdit({$row['BIDX']})\"";
if($row["RECNT"] > 0)$recnt ="답변완료"; else $recnt="답변대기";
if($row["DIFFDAY"] < 7)$newimg ="
"; else $newimg="";
$row["WDATE"] = substr($row["WDATE"],0,16);
if(substr($row["siteTel"],0,1)=="-")$row["siteTel"] = substr($row["siteTel"],1);
if(!$license["SIDX"]){
$row["rdnWhlAddr"] = substr($row["rdnWhlAddr"],0,strpos($row["rdnWhlAddr"]," "))." ****** ****";
$row["siteTel"] = substr($row["siteTel"],0,strpos($row["siteTel"],"-"))." *******";
}
echo"
| ".$row["bplcNm"]." |
".$ARR_LODA_CATE[substr($row["opnSvcId"],0,2)]." |
".$ARR_LODA_GROUP[substr($row["opnSvcId"],3,2)]." |
".$ARR_LODA_CODE[$row["opnSvcId"]]." |
".$row["rdnPosNo"]." |
".$row["rdnWhlAddr"]." |
".add_hyphen($row["siteTel"])." |
".date("Y-m-d", strtotime($row["apvPermYmd"]))." |
".$row["dtlStateNm"]." |
".substr($row["updateDt"],0,10)." |
";
$j--;
}
}
?>
|
|
|
|
|
|
|
|
|
|
CSV 다운로드
