alertTour("회원만 조회가능합니다. 로긴후 이용해 주세요.","/login/login.php?m_idx=member"); } if ($searchString) { if ($find==byAgent_name) $cWhere .= " msrlno='$_COOKIE[$CookieSrlno]' and agent_name like '%$searchString%' and " ; if ($find==byProduct_name) $cWhere .= " msrlno='$_COOKIE[$CookieSrlno]' and product_name like '%$searchString%' and " ; $cWhere = " where " . substr($cWhere,0,strlen($cWhere)-4) ; }else{ $cWhere = " where msrlno='$_COOKIE[$CookieSrlno]'"; } //echo $cWhere; exit; //if ($cWhere) $selectsql = "select * from $Table[AsReport] ${cWhere} order by srlno desc "; //else $selectsql = "select * from $Table[AsReport] order by srlno desc "; //$result = $dalib->selectSQLAll($selectsql); $selectsql2 = "select a.*, b.* from $Table[AsReport] a INNER JOIN $Table[Member] b ON (a.msrlno=b.srlno) $cWhere"; //echo $selectsql2; exit; //$selectsql2 = "select * from $Table[Member] where memid='$_COOKIE[$CookieIDName]'"; $result = $dalib->selectSQLAll($selectsql2); $pagingList = $paging->pagingList("searchString=$searchString&find=$find§ion=$section$srchlink&m_idx=as_call",$result[rnum],15,10); $startRecord = $paging->startRecord; $endRecord = $paging->endRecord; $page = $paging->page; ?>
HOME > AS신청 > AS진행확인
selectSQLField("select * from $Table[AsReportEntering] where asreport_srlno = '$r[srlno]'"); // 세팅 상태별 색깔표시 switch($r['status']) { case "A": // 제품입고 $tr_bg = "FCB6B6"; $status = "제품입고"; break; case "B": // 수리진행중 $tr_bg = "F7FAC0"; $status = "수리진행중"; break; case "C": // 수리완료 $tr_bg = "B6F2FA"; $status = "수리완료"; break; case "D": // 배송완료 $tr_bg = "E7E7E7"; $status = "배송완료"; break; case "E": // AS신청 $tr_bg = "E05EFC"; $status = "AS신청(입고전)"; break; case "F": // AS신청 $tr_bg = "FF980E"; $status = "부품주문중"; break; } $regdate = explode(" ", $r['regdatetime']); if($regdate[0]==$today) $NEW_IMG = ""; else $NEW_IMG = ""; ?>
순번 입고일자 거래처명 상품명 완료예정일 진행사항
";?>