include $DOCUMENT_ROOT."/include/form_begin.php";
if($_COOKIE[$CookieIDName]==""){
$fulib->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ÁøÇàÈ®ÀÎ |
|
¼ø¹ø |
ÀÔ°íÀÏÀÚ |
°Å·¡Ã³¸í |
»óÇ°¸í |
¿Ï·á¿¹Á¤ÀÏ |
ÁøÇà»çÇ× |
$today = date("Y-m-d");
$NO = $result[rnum] - $startRecord;
for($nLoop=$startRecord;$nLoop<=$endRecord-1;$nLoop++) {
mysql_data_seek($result[result],$nLoop);
$r = mysql_fetch_array($result[result]);
$agent_name = stripslashes($r[agent_name]);
$product_name = stripslashes($r[product_name]);
$res = $dalib->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 = "";
?>
=$NO?> |
=$regdate[0]?> |
="*".substr($r['agent_name'], 2);?> ´Ô=$NEW_IMG?>
|
=$r['product_name']?>";?> |
if($r['expec_date']=="") echo "¹Ì Á¤";
else echo $r['expec_date'];
?>
|
=$status?> |
|
$NO--;
}
?>
|
|
=$pagingList?>
|
|
|