📄 list.php
字号:
if($WHERE_STR=="")
$WHERE_STR.=" where a.CONTRACT_CONTENT like '%".$CONTRACT_CONTENT."%'";
else
$WHERE_STR.=" and a.CONTRACT_CONTENT like '%".$CONTRACT_CONTENT."%'";
}
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($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";
}
//------------自定义字段查找---------------
$query = "SELECT FIELDNO from FIELDSETTING where TABLENAME='CUSTOMER'";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$FIELDNO="CUSTOMER".$ROW["FIELDNO"];
if($$FIELDNO!="")
{
$CUSTOMERID_STR="";
if($urlstr=="")$urlstr=$FIELDNO."=".$$FIELDNO;
else $urlstr=$urlstr."&".$FIELDNO."=".$$FIELDNO;
$WHERE_STR1=" where TABLENAME='CUSTOMER' and (FIELDNO='".$ROW["FIELDNO"]."' and ITEM_DATE like '%".$$FIELDNO."%')";
$query1="SELECT IDENTY_ID FROM `FIELD_DATE`".$WHERE_STR1;
$cursor1= exequery($connection,$query1);
while($ROW1=mysql_fetch_array($cursor1))
{
$CUSTOMERID_STR=$CUSTOMERID_STR.$ROW1["IDENTY_ID"].",";
}
$CUSTOMERID_STR="'".str_replace(",","','",substr($CUSTOMERID_STR,0,-1))."'";
if($WHERE_STR=="")
$WHERE_STR.=" where d.CUSTOMER_ID in ($CUSTOMERID_STR)";
else
$WHERE_STR.=" and d.CUSTOMER_ID in ($CUSTOMERID_STR)";
}
}
$query = "SELECT FIELDNO from FIELDSETTING where TABLENAME='CONTRACT'";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$FIELDNO="CONTRACT".$ROW["FIELDNO"];
if($$FIELDNO!="")
{
$CONTRACTID_STR="";
if($urlstr=="")$urlstr=$FIELDNO."=".$$FIELDNO;
else $urlstr=$urlstr."&".$FIELDNO."=".$$FIELDNO;
$WHERE_STR1=" where TABLENAME='CONTRACT' and (FIELDNO='".$ROW["FIELDNO"]."' and ITEM_DATE like '%".$$FIELDNO."%')";
$query1="SELECT IDENTY_ID FROM `FIELD_DATE`".$WHERE_STR1;
$cursor1= exequery($connection,$query1);
while($ROW1=mysql_fetch_array($cursor1))
{
$CONTRACTID_STR=$CONTRACTID_STR.$ROW1["IDENTY_ID"].",";
}
$CONTRACTID_STR="'".str_replace(",","','",substr($CONTRACTID_STR,0,-1))."'";
if($WHERE_STR=="")
$WHERE_STR.=" where a.CONTRACT_ID in ($CONTRACTID_STR)";
else
$WHERE_STR.=" and a.CONTRACT_ID in ($CONTRACTID_STR)";
}
}
//----------------------------------------
if($urlstr=="")$urlstr="SELLER_TYPE=".$SELLER_TYPE;
else $urlstr=$urlstr."&SELLER_TYPE=".$SELLER_TYPE;
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
LEFT OUTER JOIN USER h ON a.CONTRACT_LINKMAN2=h.USER_ID
".$WHERE_STR." group by a.CONTRACT_ID".$HAVING;
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))$CUSTOMER_COUNT++;
$PER_PAGE=10;
$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,h.USER_NAME as CONTRACT_LINKMAN2
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
LEFT OUTER JOIN USER h ON a.CONTRACT_LINKMAN2=h.USER_ID
".$WHERE_STR." group by a.CONTRACT_ID".$HAVING.$OREDERBY;
$offest=($CUR_PAGE-1)*10;
$query1=$query1." LIMIT ". $offest." ,".$PER_PAGE;
$cursor1 = exequery($connection, $query1);
if($CUSTOMER_COUNT==0)
{
Message("<br>提示","没有符合条件的合同记录");
Button_Back();
exit;
}
else
{
?>
<table border="0" cellspacing="1" width="95%" class="small" cellpadding="3">
<tr>
<td align="left">
<a href="list.php?<?=$urlstr?>&CUR_PAGE=1&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>
<a href="list.php?<?=$urlstr?>&CUR_PAGE=<?=$CUR_PAGE-1?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/first01.gif' width='24' border='0' height='15' alt='上一页'></a>
<a href="list.php?<?=$urlstr?>&CUR_PAGE=<?=$CUR_PAGE+1?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style="cursor:hand"></a>
<a href="list.php?<?=$urlstr?>&CUR_PAGE=<?=$PAGE_COUNT?>&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"><a href="list.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="list.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="list.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="list.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="list.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="list.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="list.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="list.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"><a href="list.php?<?=$urlstr?>&ORDERFIELD=CONTRACT_LINKMAN2&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_LINKMAN2"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CONTRACT_LINKMAN2"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=SELLER&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=="SELLER"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SELLER"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></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"];
$CONTRACT_LINKMAN2=$ROW["CONTRACT_LINKMAN2"];
if($CUSTOMER_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$CONTRACT_NO1?></td>
<td nowrap align="center"><a href="javascript:show_detail2(<?=$CONTRACT_ID1?>);"><?=$CONTRACT_NAME1?></a></td>
<td nowrap align="center"><?=$CUSTOMER_NAME1?></td>
<td nowrap align="center"><a href="javascript:show_detail(<?=$CONTRACT_ID1?>);"><?=$TOTALPRICE1?></a></td>
<td nowrap align="center"><a href="javascript:show_detail1(<?=$CONTRACT_ID1?>);"><?=$PAYMENT?></a></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"><?=$CONTRACT_LINKMAN2?></td>
<td nowrap align="center"><?=$SELLER1?></td>
</tr>
<?
}
}
?>
</table>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onclick="location='index.php'">
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -