📄 index.php
字号:
if($ACTIVITY_TYPE!="")
{
if($urlstr=="")$urlstr="ACTIVITY_TYPE=".$ACTIVITY_TYPE;
else $urlstr=$urlstr."&ACTIVITY_TYPE=".$ACTIVITY_TYPE;
if($WHERE_STR=="")
$WHERE_STR.=" where a.ACTIVITY_TYPE ='$ACTIVITY_TYPE'";
else
$WHERE_STR.=" and a.ACTIVITY_TYPE ='$ACTIVITY_TYPE'";
}
if($TO_ID!="")
{
if($urlstr=="")$urlstr="TO_ID=".$TO_ID;
else $urlstr=$urlstr."&TO_ID=".$TO_ID;
if($WHERE_STR=="")
$WHERE_STR.=" where a.MANAGER ='$TO_ID'";
else
$WHERE_STR.=" and a.MANAGER ='$TO_ID'";
}
if($ACTIVITY_STATUS!="")
{
if($urlstr=="")$urlstr="ACTIVITY_STATUS=".$ACTIVITY_STATUS;
else $urlstr=$urlstr."&ACTIVITY_STATUS=".$ACTIVITY_STATUS;
if($WHERE_STR=="")
$WHERE_STR.=" where a.ACTIVITY_STATUS ='$ACTIVITY_STATUS'";
else
$WHERE_STR.=" and a.ACTIVITY_STATUS ='$ACTIVITY_STATUS'";
}
if($DATE1!="")
{
if($urlstr=="")$urlstr="DATE1=".$DATE1;
else $urlstr=$urlstr."&DATE1=".$DATE1;
if($WHERE_STR=="")
{
$WHERE_STR.=" where a.".$DATE_TYPE."_DATE>='$DATE1'";
}
else
$WHERE_STR.=" and a.".$DATE_TYPE."_DATE>='$DATE1'";
}
if($DATE2!="")
{
if($urlstr=="")$urlstr="DATE2=".$DATE2;
else $urlstr=$urlstr."&DATE2=".$DATE2;
if($WHERE_STR=="")
$WHERE_STR.=" where a.".$DATE_TYPE."_DATE<='$DATE2'";
else
$WHERE_STR.=" and a.".$DATE_TYPE."_DATE<='$DATE2'";
}
if($urlstr=="")$urlstr="DATE_TYPE=".$DATE_TYPE;
else $urlstr=$urlstr."&DATE_TYPE=".$DATE_TYPE;
if($ORDERFIELD!="")
{
if($ORDERSIGN=="DOWN")
{
$ORDERTYPE="ASC";
}
if($ORDERSIGN=="UP")
{
$ORDERTYPE="DESC";
}
$OREDERBY=" ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
$CUSTOMER_COUNT=0;
$query="SELECT count(a.ACTIVITY_ID) from ACTIVITY a
LEFT OUTER JOIN SYS_CODE b ON a.ACTIVITY_TYPE = b.CODE_NO AND b.PARENT_NO = 'ACTIVITY_TYPE'
LEFT OUTER JOIN SYS_CODE e ON a.ACTIVITY_STATUS= e.CODE_NO AND e.PARENT_NO = 'ACTIVITY_STATUS'
LEFT OUTER JOIN USER g ON a.MANAGER=g.USER_ID".$WHERE_STR." group by a.ACTIVITY_ID".$HAVING;
$cursor= exequery($connection,$query);
$ROW=mysql_fetch_array($cursor);
$CUSTOMER_COUNT=$ROW["0"];
//echo $query;
$PER_PAGE=5;
$PAGE_COUNT=ceil($CUSTOMER_COUNT/$PER_PAGE);
if($CUR_PAGE<=0 || $CUR_PAGE=="")
$CUR_PAGE=1;
if($CUR_PAGE>$PAGE_COUNT)
$CUR_PAGE=$PAGE_COUNT;
$query1="SELECT a.ACTIVITY_ID as ACTIVITY_ID,a.ACTIVITY_NAME as ACTIVITY_NAME,b.CODE_NAME ACTIVITY_TYPE,e.CODE_NAME ACTIVITY_STATUS,g.USER_NAME MANAGER,BEGIN_DATE,END_DATE,SEND_TIME from ACTIVITY a
LEFT OUTER JOIN SYS_CODE b ON a.ACTIVITY_TYPE = b.CODE_NO AND b.PARENT_NO = 'ACTIVITY_TYPE'
LEFT OUTER JOIN SYS_CODE e ON a.ACTIVITY_STATUS= e.CODE_NO AND e.PARENT_NO = 'ACTIVITY_STATUS'
LEFT OUTER JOIN USER g ON a.MANAGER=g.USER_ID
".$WHERE_STR." group by a.ACTIVITY_ID".$HAVING.$OREDERBY;
$offest=($CUR_PAGE-1)*$PER_PAGE;
$query1=$query1." LIMIT ". $offest." ,".$PER_PAGE;
$cursor1 = exequery($connection, $query1);
if($CUSTOMER_COUNT==0)
{
Message("<br>提示","没有符合条件的活动");
exit;
}
else
{
?>
<table border="0" cellspacing="1" width="95%" class="small" cellpadding="3">
<tr>
<td align="left">
<a href="index.php?CUR_PAGE=1&<?=$urlstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>
<a href="index.php?CUR_PAGE=<?=$CUR_PAGE-1?>&<?=$urlstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/first01.gif' width='24' border='0' height='15' alt='上一页'></a>
<a href="index.php?CUR_PAGE=<?=$CUR_PAGE+1?>&<?=$urlstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style="cursor:hand"></a>
<a href="index.php?CUR_PAGE=<?=$PAGE_COUNT?>&<?=$urlstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/last02.gif' width='24' border='0' height='15' alt='末页' style="cursor:hand"></a>
到
<input type="text" name="PAGE_NUM" size="3" maxlength="4" class="SmallInput">
页
<img id="btnGotoPage" src="/images/menu/book.gif" onclick="set_page('<?=$urlstr?>')" border="0" WIDTH="19" HEIGHT="17" style="cursor:hand" alt="转到相应页面">
</td>
<td align="right">
<?=$CUR_PAGE?>/<?=$PAGE_COUNT?>页 共 <?=$CUSTOMER_COUNT?> 条
</td>
</tr>
</table>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<?
if($DELETE_FLAG==0 || find_id($MANAGERS,$LOGIN_USER_ID))
{
?>
<td nowrap align="center">选择</td>
<?
}
?>
<td nowrap align="center"><a href="index.php?<?=$urlstr?>&ORDERFIELD=ACTIVITY_NAME&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">活动名称 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="ACTIVITY_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="ACTIVITY_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?<?=$urlstr?>&ORDERFIELD=ACTIVITY_TYPE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">活动类型 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="ACTIVITY_TYPE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="ACTIVITY_TYPE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?<?=$urlstr?>&ORDERFIELD=MANAGER&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">负责人 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="MANAGER"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="MANAGER"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?<?=$urlstr?>&ORDERFIELD=ACTIVITY_STATUS&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">进行状态 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="ACTIVITY_STATUS"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="ACTIVITY_STATUS"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?<?=$urlstr?>&ORDERFIELD=BEGIN_DATE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">生效日期 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="BEGIN_DATE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="BEGIN_DATE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?<?=$urlstr?>&ORDERFIELD=END_DATE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">终止日期 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="END_DATE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="END_DATE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?<?=$urlstr?>&ORDERFIELD=SEND_TIME&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">创建日期 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="SEND_TIME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SEND_TIME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center">操作</td>
</tr>
<?
$CUSTOMER_COUNT=0;
while($ROW=mysql_fetch_array($cursor1))
{
$CUSTOMER_COUNT++;
$ACTIVITY_ID1=$ROW["ACTIVITY_ID"];
$ACTIVITY_NAME1=$ROW["ACTIVITY_NAME"];
$ACTIVITY_TYPE1=$ROW["ACTIVITY_TYPE"];
$MANAGER1=$ROW["MANAGER"];
$ACTIVITY_STATUS1=$ROW["ACTIVITY_STATUS"];
$BEGIN_DATE1=$ROW["BEGIN_DATE"];
$END_DATE1=$ROW["END_DATE"];
$SEND_TIME1=$ROW["SEND_TIME"];
if($CUSTOMER_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<?
if($DELETE_FLAG==0 || find_id($MANAGERS,$LOGIN_USER_ID))
{
?>
<td> <input type="checkbox" name="email_select" value="<?=$ACTIVITY_ID1?>" <? if($SIGN=="1") echo "disabled"; ?> onClick="check_one(self);"></td>
<?
}
?>
<td nowrap align="center"><?=$ACTIVITY_NAME1?></td>
<td nowrap align="center"><?=$ACTIVITY_TYPE1?></td>
<td nowrap align="center"><?=$MANAGER1?></td>
<td nowrap align="center"><?=$ACTIVITY_STATUS1?></td>
<td nowrap align="center"><?=$BEGIN_DATE1?></td>
<td nowrap align="center"><?=$END_DATE1?></td>
<td nowrap align="center"><?=$SEND_TIME1?></td>
<td nowrap align="center">
<a href="javascript:detail('<?=$ACTIVITY_ID1?>');">详细信息</a>
<a href="javascript:detail_list('<?=$ACTIVITY_ID1?>');">相关客户</a><br>
</td>
</tr>
<?
}
}
?>
</table>
</body>
</html>
<?
function GETALLDATE($CODE,$SELECTED)
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='$CODE'";
$connection=OpenConnection();
$cursor= exequery($connection,$query);
echo "<option value= ".">".""."</option>";
while($ROW=mysql_fetch_array($cursor))
{
$CODE_NO=$ROW["CODE_NO"];
$CODE_NAME=$ROW["CODE_NAME"];
if($CODE_NO==$SELECTED)
echo "<option value=".$CODE_NO." selected>".$CODE_NAME."</option>";
else
echo "<option value=".$CODE_NO.">".$CODE_NAME."</option>";
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -