include $DOCUMENT_ROOT."/include/form_begin.php";
if ($searchString) {
if ($find==byAgent_name) $cWhere .= " agent_name like '%$searchString%' and " ;
if ($find==byProduct_name) $cWhere .= " product_name like '%$searchString%' and " ;
$cWhere = " where " . substr($cWhere,0,strlen($cWhere)-4) ;
}
if ($cWhere) $selectsql = "select * from $Table[AsReport] ${cWhere} and memid='$_COOKIE[$CookieIDName]' order by srlno desc ";
else $selectsql = "select * from $Table[AsReport] where memid='$_COOKIE[$CookieIDName]' order by srlno desc ";
$result = $dalib->selectSQLAll($selectsql);
$selectsql2 = "select * from $Table[Member] where memid='$_COOKIE[$CookieIDName]'";
$result2 = $dalib->selectSQLField($selectsql2);
$pagingList = $paging4->pagingList("searchString=$searchString&find=$find§ion=$section$srchlink",$result[rnum],15,10);
$startRecord = $paging4->startRecord;
$endRecord = $paging4->endRecord;
$page = $paging4->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 "D": // ½ÅûÁ¢¼ö
$tr_bg = "E7E7E7";
$status = "½ÅûÁ¢¼ö";
break;
}
$regdate = explode(" ", $r['regdatetime']);
?>
=$NO?> |
=$regdate[0]?> |
=$r['agent_name']?>
|
=$r['product_name']?> |
=$status?> |
|
$NO--;
}
?>
|
|
=$pagingList?>
|
|
|
|
|
|