📄 index.php
字号:
if($CONTRACT_NAME!="")
{
if($urlstr=="")$urlstr="CONTRACT_NAME=".$CONTRACT_NAME;
else $urlstr=$urlstr."&CONTRACT_NAME=".$CONTRACT_NAME;
if($WHERE_STR=="")
$WHERE_STR.=" where a.CONTRACT_NAME like '%".$CONTRACT_NAME."%'";
else
$WHERE_STR.=" and a.CONTRACT_NAME like '%".$CONTRACT_NAME."%'";
}
if($CONTRACT_LINKMAN1!="")
{
if($urlstr=="")$urlstr="CONTRACT_LINKMAN1=".$CONTRACT_LINKMAN1;
else $urlstr=$urlstr."&CONTRACT_LINKMAN1=".$CONTRACT_LINKMAN1;
if($WHERE_STR=="")
$WHERE_STR.=" where a.CONTRACT_LINKMAN1 like '%".$CONTRACT_LINKMAN1."%'";
else
$WHERE_STR.=" and a.CONTRACT_LINKMAN1 like '%".$CONTRACT_LINKMAN1."%'";
}
if($CONTRACT_LINKMAN2!="")
{
if($urlstr=="")$urlstr="CONTRACT_LINKMAN2=".$CONTRACT_LINKMAN2;
else $urlstr=$urlstr."&CONTRACT_LINKMAN2=".$CONTRACT_LINKMAN2;
if($WHERE_STR=="")
$WHERE_STR.=" where a.CONTRACT_LINKMAN2 like '%".$CONTRACT_LINKMAN2."%'";
else
$WHERE_STR.=" and a.CONTRACT_LINKMAN2 like '%".$CONTRACT_LINKMAN2."%'";
}
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($WHERE_STR=="")
$WHERE_STR.=" where (a.SELLER ='$LOGIN_USER_ID' or a.CONTRACT_LINKMAN2='$LOGIN_USER_ID')";
else
$WHERE_STR.=" and (a.SELLER ='$LOGIN_USER_ID' or a.CONTRACT_LINKMAN2='$LOGIN_USER_ID')";
if($SIGN=="0")
{
if($urlstr=="")$urlstr="SIGN=".$SIGN;
else $urlstr=$urlstr."&SIGN=".$SIGN;
$HAVING=" HAVING PAYMENT<TOTALPRICE";
}
if($SIGN=="1")
{
if($urlstr=="")$urlstr="SIGN=".$SIGN;
else $urlstr=$urlstr."&SIGN=".$SIGN;
$HAVING=" HAVING PAYMENT>=TOTALPRICE";
}
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 a.CONTRACT_ID,sum(IFNULL(c.TOTAL_PRICE, 0)) as TOTALPRICE,sum(IFNULL(c.PAYMENT, 0)) as PAYMENT from CONTRACT a
LEFT OUTER JOIN SYS_CODE b ON a.CONTRACT_TYPE = b.CODE_NO AND b.PARENT_NO = 'CONTRACT_TYPE'
LEFT OUTER JOIN CONTRACT_LINE c ON a.CONTRACT_ID = c.CONTRACT_ID
LEFT OUTER JOIN CUSTOMER d ON a.CUSTOMER_ID = d.CUSTOMER_ID
LEFT OUTER JOIN SYS_CODE e ON d.KIND= e.CODE_NO AND e.PARENT_NO = 'CRM_KIND'
LEFT OUTER JOIN SYS_CODE f ON d.SELLMODE= f.CODE_NO AND f.PARENT_NO = 'SELL_MODE'
LEFT OUTER JOIN USER g ON a.SELLER=g.USER_ID".$WHERE_STR." group by a.CONTRACT_ID".$HAVING;
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))$CUSTOMER_COUNT++;
//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.CONTRACT_ID as CONTRACT_ID,a.CONTRACT_NAME as CONTRACT_NAME,a.CONTRACT_NO as CONTRACT_NO,
b.CODE_NAME as CONTRACT_TYPE,d.CUSTOMER_NAME as CUSTOMER_NAME,e.CODE_NAME as KIND,f.CODE_NAME as SELLMODE,
g.USER_NAME as SELLER,sum(IFNULL(c.TOTAL_PRICE, 0)) as TOTALPRICE,a.CREATE_DATE as CREATE_DATE,
a.BEGIN_DATE as BEGIN_DATE,a.END_DATE as END_DATE,sum(IFNULL(c.PAYMENT, 0)) as PAYMENT
from CONTRACT a
LEFT OUTER JOIN SYS_CODE b ON a.CONTRACT_TYPE = b.CODE_NO AND b.PARENT_NO = 'CONTRACT_TYPE'
LEFT OUTER JOIN CONTRACT_LINE c ON a.CONTRACT_ID = c.CONTRACT_ID
LEFT OUTER JOIN CUSTOMER d ON a.CUSTOMER_ID = d.CUSTOMER_ID
LEFT OUTER JOIN SYS_CODE e ON d.KIND= e.CODE_NO AND e.PARENT_NO = 'CRM_KIND'
LEFT OUTER JOIN SYS_CODE f ON d.SELLMODE= f.CODE_NO AND f.PARENT_NO = 'SELL_MODE'
LEFT OUTER JOIN USER g ON a.SELLER=g.USER_ID
".$WHERE_STR." group by a.CONTRACT_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">
<td nowrap align="center">选择</td>
<td nowrap align="center"><a href="index.php?<?=$urlstr?>&ORDERFIELD=CONTRACT_NO&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=="CONTRACT_NO"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CONTRACT_NO"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?<?=$urlstr?>&ORDERFIELD=CONTRACT_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=="CONTRACT_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CONTRACT_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?<?=$urlstr?>&ORDERFIELD=CUSTOMER_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=="CUSTOMER_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CUSTOMER_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?<?=$urlstr?>&ORDERFIELD=TOTALPRICE&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=="TOTALPRICE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="TOTALPRICE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?<?=$urlstr?>&ORDERFIELD=PAYMENT&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=="PAYMENT"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="PAYMENT"){?><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=CREATE_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=="CREATE_DATE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CREATE_DATE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center">创建人</td>
<td nowrap align="center">操作</td>
</tr>
<?
$CUSTOMER_COUNT=0;
while($ROW=mysql_fetch_array($cursor1))
{
$CUSTOMER_COUNT++;
$CONTRACT_ID1=$ROW["CONTRACT_ID"];
$CONTRACT_NO1=$ROW["CONTRACT_NO"];
$CONTRACT_NAME1=$ROW["CONTRACT_NAME"];
$CONTRACT_TYPE1=$ROW["CONTRACT_TYPE"];
$CUSTOMER_NAME1=$ROW["CUSTOMER_NAME"];
$TOTALPRICE1=$ROW["TOTALPRICE"];
$PAYMENT=$ROW["PAYMENT"];
$BEGIN_DATE1=$ROW["BEGIN_DATE"];
$END_DATE1=$ROW["END_DATE"];
$CREATE_DATE1=$ROW["CREATE_DATE"];
$SELLER1=$ROW["SELLER"];
if($CUSTOMER_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td> <input type="checkbox" name="email_select" value="<?=$CONTRACT_ID1?>" <? if($SIGN=="1") echo "disabled"; ?> onClick="check_one(self);"></td>
<td nowrap align="center"><?=$CONTRACT_NO1?></td>
<td nowrap align="center"><?=$CONTRACT_NAME1?></td>
<td nowrap align="center"><?=$CUSTOMER_NAME1?></td>
<td nowrap align="center"><?=$TOTALPRICE1?></td>
<td nowrap align="center"><?=$PAYMENT?></td>
<td nowrap align="center"><?=$BEGIN_DATE1?></td>
<td nowrap align="center"><?=$END_DATE1?></td>
<td nowrap align="center"><?=$CREATE_DATE1?></td>
<td nowrap align="center"><?=$SELLER1?></td>
<td nowrap align="center">
<a href="edit.php?CONTRACT_ID=<?=$CONTRACT_ID1?>&<?=$urlstr?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>">编辑</a>
<a href="javascript:delete_customer('<?=$CONTRACT_ID1?>','<?=$urlstr?>');">删除</a><br>
<a href="contract_line?CONTRACT_ID=<?=$CONTRACT_ID1?>&<?=$urlstr?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>">合同明细</a><br>
<a href="contract_history?CONTRACT_ID=<?=$CONTRACT_ID1?>&<?=$urlstr?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>">付款记录</a>
</td>
</tr>
<?
}
}
?>
<tr class="TableControl">
<td colspan="11">
<input type="checkbox" name="allbox" id="allbox_for" <? if($SIGN=="1") echo "disabled"; ?> onClick="check_all();">
<label for="allbox_for">全选</label>
<input type="button" value="批量删除" class="SmallButton" onClick="delete_mail('<?=$urlstr?>');" title="删除所选客户">
</td>
</tr>
</table>
</body>
</html>
<?
function GETALLDATE($CODE)
{
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"];
echo "<option value=".$CODE_NO.">".$CODE_NAME."</option>";
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -