📄 index.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
$PAGE_SIZE=10;
$query = "select * from SALE_MANAGER where MANAGER_ID=1";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$MANAGER_ID=$ROW["MANAGER_ID"];
$MANAGERS=$ROW["MANAGERS"];
}
?>
<html>
<head>
<title>销售计划搜索 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function delete_chance0(PLAN_ID)
{
msg='确认要删除该销售计划么？';
if(window.confirm(msg))
{
URL="delete.php?PLAN_TITLE0=<?=$PLAN_TITLE0?>&BEGIN_DATE0=<?=$BEGIN_DATE0?>&BEGIN_DATE1=<?=$BEGIN_DATE1?>&END_DATE0=<?=$END_DATE0?>&END_DATE1=<?=$END_DATE1?>&DESC0=<?=$DESC0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&PLAN_ID=" + PLAN_ID;
window.location=URL;
}
}
function check_one(el)
{
if(!el.checked)
document.all("allbox").checked=false;
}
function set_page()
{
PAGE_START=PAGE_NUM.value;
location="index.php?PLAN_TITLE0=<?=$PLAN_TITLE0?>&BEGIN_DATE0=<?=$BEGIN_DATE0?>&BEGIN_DATE1=<?=$BEGIN_DATE1?>&END_DATE0=<?=$END_DATE0?>&END_DATE1=<?=$END_DATE1?>&DESC0=<?=$DESC0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE="+PAGE_START;
}
function show_detail(PLAN_ID)
{
URL="showdetail.php?PLAN_ID="+PLAN_ID;
myleft=(screen.availWidth-650)/2;
window.open(URL,"formul_edit","height=200,width=550,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function show_item(PLAN_ID)
{
URL="item.php?PLAN_ID="+PLAN_ID;
myleft=(screen.availWidth-650)/2;
window.open(URL,"formul_edit","height=200,width=550,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function check_all()
{
for (i=0;i<document.all("chance_select").length;i++)
{
if(document.all("allbox").checked)
document.all("chance_select").item(i).checked=true;
else
document.all("chance_select").item(i).checked=false;
}
if(i==0)
{
if(document.all("allbox").checked)
document.all("chance_select").checked=true;
else
document.all("chance_select").checked=false;
}
}
function delete_chance()
{
delete_str="";
for(i=0;i<document.all("chance_select").length;i++)
{
el=document.all("chance_select").item(i);
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(i==0)
{
el=document.all("chance_select");
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(delete_str=="")
{
alert("请至少选择其中一个销售计划。");
return;
}
msg='确认要删除所选销售计划？';
if(window.confirm(msg))
{
URL="delete.php?PLAN_TITLE0=<?=$PLAN_TITLE0?>&BEGIN_DATE0=<?=$BEGIN_DATE0?>&BEGIN_DATE1=<?=$BEGIN_DATE1?>&END_DATE0=<?=$END_DATE0?>&END_DATE1=<?=$END_DATE1?>&DESC0=<?=$DESC0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&delete_str="+delete_str;
window.location=URL;
}
}
function td_calendar(fieldname)
{
myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
</script>
</head>
<div align="left">
<fieldset style="width:95%;padding-bottom:5px;">
<legend class="small" align=left>
<b>快速查询</b>
</legend>
<table cellspacing="1" class="small" align="left" cellpadding="3">
<form action="index.php" method="post" name="form1">
<tr>
<td nowrap class="TableData" width=10%> 计划主题： </td>
<td nowrap class="TableData">
<input type="text" name="PLAN_TITLE0" class="SmallInput" size="35" maxlength="100" value="<?=$PLAN_TITLE0?>">
</td>
<td nowrap class="TableData">描述： </td>
<td nowrap class="TableData">
<input type="text" name="DESC0" class="SmallInput" size="35" maxlength="100" value="<?=$DESC0?>">
</td>
</tr>
<tr>
<td nowrap class="TableData"> 开始时间： </td>
<td nowrap class="TableData">
<input type="text" name="BEGIN_DATE0" class="SmallInput" size="15" maxlength="50" value="<?=$BEGIN_DATE0?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.BEGIN_DATE0');">
-
<input type="text" name="BEGIN_DATE1" class="SmallInput" size="15" maxlength="50" value="<?=$BEGIN_DATE1?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.BEGIN_DATE1');">
</td>
<td nowrap class="TableData">结束时间： </td>
<td nowrap class="TableData">
<input type="text" name="END_DATE0" class="SmallInput" size="15" maxlength="50" value="<?=$END_DATE0?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.END_DATE0');">
-
<input type="text" name="END_DATE1" class="SmallInput" size="15" maxlength="50" value="<?=$END_DATE1?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.END_DATE1');">
</td>
</tr>
<tr>
<td nowrap class="TableData"> 登记时间： </td>
<td nowrap class="TableData">
<input type="text" name="ADD_TIME0" class="SmallInput" size="15" maxlength="50" value="<?=$ADD_TIME0?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.ADD_TIME0');">
-
<input type="text" name="ADD_TIME1" class="SmallInput" size="15" maxlength="50" value="<?=$ADD_TIME1?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.ADD_TIME1');">
</td>
</tr>
<tr>
<td nowrap class="TableData" colspan="3" >
<input value="查询" type="submit" class="SmallButton" title="快速查询" name="button">
</td>
</tr>
</form>
</table>
</fieldset>
</div>
<br>
<br>
<?
//-----------先组织SQL语句-----------
$WHERE_STR=" where 1=1";
if($PLAN_TITLE0!="")
$WHERE_STR.=" and PLAN_TITLE like '%".$PLAN_TITLE0."%'";
if($DESC0!="")
$WHERE_STR.=" and `DESC` like '%$DESC%'";
if($BEGIN_DATE0!="")
$WHERE_STR.=" and BEGIN_DATE>= '$BEGIN_DATE0'";
if($BEGIN_DATE1!="")
$WHERE_STR.=" and BEGIN_DATE<= '$BEGIN_DATE1'";
if($END_DATE0!="")
$WHERE_STR.=" and END_DATE>= '$END_DATE0'";
if($END_DATE1!="")
$WHERE_STR.=" and END_DATE<= '$END_DATE1'";
if($ADD_TIME0!="")
$WHERE_STR.=" and ADD_TIME>= '$ADD_TIME0 00:00:00'";
if($ADD_TIME1!="")
$WHERE_STR.=" and ADD_TIME<= '$ADD_TIME1 23:59:59'";
if($ORDERFIELD!="")
{
if($ORDERSIGN=="DOWN")
{
$ORDERTYPE="ASC";
}
if($ORDERSIGN=="UP")
{
$ORDERTYPE="DESC";
}
$OREDERBY=" ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
$PLAN_COUNT=0;
$query="SELECT count(*) from SALE_PLAN ".$WHERE_STR;
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$PLAN_COUNT=$ROW[0];
$PER_PAGE=10;
$PAGE_COUNT=ceil($PLAN_COUNT/$PER_PAGE);
if($CUR_PAGE<=0 || $CUR_PAGE=="")
$CUR_PAGE=1;
if($CUR_PAGE>$PAGE_COUNT)
$CUR_PAGE=$PAGE_COUNT;
$query1="SELECT * from SALE_PLAN ".$WHERE_STR.$OREDERBY;
$offest=($CUR_PAGE-1)*10;
$query1=$query1." LIMIT ". $offest." ,".$PER_PAGE;
$cursor1 = exequery($connection, $query1);
if($PLAN_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&PLAN_TITLE0=<?=$PLAN_TITLE0?>&BEGIN_DATE0=<?=$BEGIN_DATE0?>&BEGIN_DATE1=<?=$BEGIN_DATE1?>&END_DATE0=<?=$END_DATE0?>&END_DATE1=<?=$END_DATE1?>&DESC0=<?=$DESC0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&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?>&PLAN_TITLE0=<?=$PLAN_TITLE0?>&BEGIN_DATE0=<?=$BEGIN_DATE0?>&BEGIN_DATE1=<?=$BEGIN_DATE1?>&END_DATE0=<?=$END_DATE0?>&END_DATE1=<?=$END_DATE1?>&DESC0=<?=$DESC0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&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?>&PLAN_TITLE0=<?=$PLAN_TITLE0?>&BEGIN_DATE0=<?=$BEGIN_DATE0?>&BEGIN_DATE1=<?=$BEGIN_DATE1?>&END_DATE0=<?=$END_DATE0?>&END_DATE1=<?=$END_DATE1?>&DESC0=<?=$DESC0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&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?>&PLAN_TITLE0=<?=$PLAN_TITLE0?>&BEGIN_DATE0=<?=$BEGIN_DATE0?>&BEGIN_DATE1=<?=$BEGIN_DATE1?>&END_DATE0=<?=$END_DATE0?>&END_DATE1=<?=$END_DATE1?>&DESC0=<?=$DESC0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&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()" border="0" WIDTH="19" HEIGHT="17" style="cursor:hand" alt="转到相应页面">
</td>
<td align="right">
<?=$CUR_PAGE?>/<?=$PAGE_COUNT?>页 共 <?=$PLAN_COUNT?> 条
</td>
</tr>
</table>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center"><a href="index.php?PLAN_TITLE0=<?=$PLAN_TITLE0?>&BEGIN_DATE0=<?=$BEGIN_DATE0?>&BEGIN_DATE1=<?=$BEGIN_DATE1?>&END_DATE0=<?=$END_DATE0?>&END_DATE1=<?=$END_DATE1?>&DESC0=<?=$DESC0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&ORDERFIELD=PLAN_TITLE&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=="PLAN_TITLE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="PLAN_TITLE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?PLAN_TITLE0=<?=$PLAN_TITLE0?>&BEGIN_DATE0=<?=$BEGIN_DATE0?>&BEGIN_DATE1=<?=$BEGIN_DATE1?>&END_DATE0=<?=$END_DATE0?>&END_DATE1=<?=$END_DATE1?>&DESC0=<?=$DESC0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&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?PLAN_TITLE0=<?=$PLAN_TITLE0?>&BEGIN_DATE0=<?=$BEGIN_DATE0?>&BEGIN_DATE1=<?=$BEGIN_DATE1?>&END_DATE0=<?=$END_DATE0?>&END_DATE1=<?=$END_DATE1?>&DESC0=<?=$DESC0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&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">描述</td>
<td nowrap align="center">登记时间</td>
<td nowrap align="center">操作</td>
</tr>
<?
$PLAN_COUNT=0;
while($ROW=mysql_fetch_array($cursor1))
{
$PLAN_COUNT++;
$PLAN_ID=$ROW["PLAN_ID"];
$PLAN_TITLE=$ROW["PLAN_TITLE"];
$BEGIN_DATE=$ROW["BEGIN_DATE"];
$END_DATE=$ROW["END_DATE"];
$DESC=$ROW["DESC"];
$ADD_TIME=$ROW["ADD_TIME"];
if($PLAN_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><a href="javascript:show_detail(<?=$PLAN_ID?>);"> <?=$PLAN_TITLE?></a></td>
<td nowrap align="center"><?=$BEGIN_DATE?></td>
<td nowrap align="center"><?=$END_DATE?></td>
<td nowrap align="center"><?=$DESC?></td>
<td nowrap align="center"><?=$ADD_TIME?></td>
<td nowrap align="center">
<a href="javascript:show_item(<?=$PLAN_ID?>);">明细</a>
</td>
</tr>
<?
}
}
?>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -