"; //if (!isset($_SESSION['ss_edit'])) { //변수등록 없으면인데도 변수 전달안됨. if (strpos($_SESSION['ss_section'],"성광이엔지") > -1 ) //2017-03-26 추가 $_SESSION['ss_edit'] = "W2Y"; else if (strpos($_SESSION['ss_section'],"도봉구") > -1 ) $_SESSION['ss_edit'] = "W0A"; //} $area = $_SESSION['ss_area']; $keyword = $_REQUEST['keyword']; $actyn = $_REQUEST['actyn']; $sql = "select a.*,e.logov,e.complex,e.addr,case when substring(a.tid,9,4) = '00-0' then '' else e.location end as location,s.name from bm_as a left outer join bm_equip e on substring(a.tid,1,7) = substring(e.tid,1,7)"; $sql .= ",bm_staff s where a.sid=s.sid and (a.tid like '%" . $keyword . "%' or e.logov like '%" . $keyword . "%' or e.complex like '%" . $keyword . "%')"; if ($_SESSION['ss_edit'] == "" && strpos($area," ")>0) { //if ($_SESSION["ss_name"] == "김형준") // $sql .= " and (a.assign like '%" . substr($area,0,strpos($area," ")) . "%' or a.assign = '오산' or a.assign = '군산')"; //else $sql .= " and a.assign like '%" . substr($area,0,strpos($area," ")) . "%'"; } else { if ( $_SESSION['ss_edit'] == "" || $_SESSION['ss_edit'] == "W2Y" ) $sql .= " and a.assign like '%" . $area . "%'"; //성광이엔지는 자기접수분만 else $sql .= " and substring(a.tid,1,3) = '{$_SESSION['ss_edit']}'"; //지자체 } if ( $actyn == "" ) $sql .= " and (a.acttime = '' or a.acttime is null) and a.codecause <> '98'"; else if ( $actyn == "y" ) $sql .= " and a.acttime is not null"; else $sql .= " and a.codecause = '98'"; $sql .= " group by a.idx order by a.regtime desc"; //echo $sql . "
"; $rs =mysql_query($sql); $rcnt = mysql_num_rows ($rs); $pagesize = 10 ; $pagecount = ceil($rcnt/$pagesize); $file_name = "asfind.php?page="; $page = $page + 1; $no = $rcnt - ($pagesize * ($page-1) ); ?>

   미처리",$file_name,$page-1,$keyword) ; if ( $actyn == "y" ) printf ("   완료"); else printf ("   완료",$file_name,$page-1,$keyword) ; if ( $actyn == "s" ) printf ("   중단"); else printf ("   중단",$file_name,$page-1,$keyword) ; if ($_SESSION['ss_id'] != "") { printf ("   AS접수"); printf ("   통신지연"); printf ("   대상종량기"); printf ("   자재요청"); } else { printf ("   AS접수"); printf ("   통신지연"); printf ("   대상종량기"); printf ("   자재요청"); } ?> 1) printf ("이전페이지",$file_name,$page-2,$keyword,$actyn) ; if($pagecount > $page ) printf ("     다음Page",$file_name,$page,$keyword,$actyn) ; ?>
0 ) @mysql_data_seek ($rs, $pagesize *($page-1)) ; for($i = 0; $i < $pagesize ; $i++) { if( @!($row = mysql_fetch_object ($rs)) ) continue; $bgc = "#FFFFFF" ; ?> codecause . "'"; $rs1 = mysql_query ( $sql ); $row1 = mysql_fetch_object ($rs1); ?> codeaction . "'"; $rs1 = mysql_query ( $sql ); $row1 = mysql_fetch_object ($rs1); ?> aid . "'"; $rs1 = mysql_query ( $sql ); if (mysql_num_rows ($rs1) > 0) { $row1 = mysql_fetch_object ($rs1); printf("",$bgc,$row1->actname); } else printf("",$bgc); mysql_free_result ($rs1); ?>
No. 접수시각 TID 지자체 지역명 주 소 설치위치 접수자 접수전화 배정 원인코드 대분류 조치코드 처리자 처리시각 Del
align=center> align=center>regtime,5,11); ?> tid; ?> align=center>logov; ?> >complex; ?> >addr; ?> align=center>location; ?> align=center>name; ?> align=center>phone; ?> align=center>assign; ?> align=center>ccause; ?> align=center> classify == '1') echo "부품교체"; else if ( $row->classify == '2') echo "점검"; else if ( $row->classify == '3') echo "지원"; else if ( $row->classify == '4') echo "원격처리"; ?> align=center>caction; ?> %s align=center>acttime; ?> align=center>idx; ?>&page=&keyword=&actyn=>Del

$pagecount ) break ; if ($page > $pagesize && $k==1 ) printf ("이전목록   ",$file_name,$pageno-2,$keyword,$actyn) ; if ($page <> $pageno ) printf (" [%d]",$file_name,$pageno-1,$keyword,$actyn,$pageno) ; if ($page == $pageno ) printf (" [%d]",$pageno) ; } } $i = $j ; } if (@($pageno < $pagecount)) printf("   다음목록",$file_name,$pageno,$keyword,$actyn) ; ?>

검색

지자체,지역,TID(ggg-ccc-nn-0) 일부로 검색

종료

로그아웃