📄 list.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含通达OA2008增強版接近完美破解补丁20081216集及最新通达OA2008ADV(
💻 PHP
📖 第 1 页 / 共 2 页
字号:
上一页 12
		$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\r\n        LEFT OUTER JOIN SYS_CODE b ON a.CONTRACT_TYPE = b.CODE_NO AND b.PARENT_NO = 'CONTRACT_TYPE'\r\n        LEFT OUTER JOIN CONTRACT_LINE c ON a.CONTRACT_ID = c.CONTRACT_ID\r\n        LEFT OUTER JOIN CUSTOMER d ON a.CUSTOMER_ID = d.CUSTOMER_ID\r\n        LEFT OUTER JOIN SYS_CODE e ON d.KIND= e.CODE_NO AND e.PARENT_NO = 'CRM_KIND'\r\n        LEFT OUTER JOIN SYS_CODE f ON d.SELLMODE= f.CODE_NO AND f.PARENT_NO = 'SELL_MODE'\r\n        LEFT OUTER JOIN USER g ON a.SELLER=g.USER_ID\r\n        LEFT OUTER JOIN USER h ON a.CONTRACT_LINKMAN2=h.USER_ID\r\n        ".$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 ( $PAGE_COUNT < $CUR_PAGE )
{
	$CUR_PAGE = $PAGE_COUNT;
}
$query1 = "SELECT a.CONTRACT_ID as CONTRACT_ID,a.CONTRACT_NAME as CONTRACT_NAME,a.CONTRACT_NO as CONTRACT_NO,\r\n         b.CODE_NAME as CONTRACT_TYPE,d.CUSTOMER_NAME as CUSTOMER_NAME,e.CODE_NAME as KIND,f.CODE_NAME as SELLMODE,\r\n         g.USER_NAME as SELLER,sum(IFNULL(c.TOTAL_PRICE, 0)) as TOTALPRICE,a.CREATE_DATE as CREATE_DATE,\r\n         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\r\n         from CONTRACT a\r\n         LEFT OUTER JOIN SYS_CODE b ON a.CONTRACT_TYPE = b.CODE_NO AND b.PARENT_NO = 'CONTRACT_TYPE'\r\n         LEFT OUTER JOIN CONTRACT_LINE c ON a.CONTRACT_ID = c.CONTRACT_ID\r\n         LEFT OUTER JOIN CUSTOMER d ON a.CUSTOMER_ID = d.CUSTOMER_ID\r\n         LEFT OUTER JOIN SYS_CODE e ON d.KIND= e.CODE_NO AND e.PARENT_NO = 'CRM_KIND'\r\n         LEFT OUTER JOIN SYS_CODE f ON d.SELLMODE= f.CODE_NO AND f.PARENT_NO = 'SELL_MODE'\r\n         LEFT OUTER JOIN USER g ON a.SELLER=g.USER_ID\r\n         LEFT OUTER JOIN USER h ON a.CONTRACT_LINKMAN2=h.USER_ID\r\n         ".$WHERE_STR." group by a.CONTRACT_ID".$HAVING.$OREDERBY;
$offest = ( $CUR_PAGE - 1 ) * 10;
if ( $offest < 0 )
{
	$offest = 0;
}
$query1 = $query1." LIMIT ".$offest." ,".$PER_PAGE;
$cursor1 = exequery( $connection, $query1 );
if ( $CUSTOMER_COUNT == 0 )
{
	message( "<br>提示", "没有符合条件的合同记录" );
	button_back( );
	exit( );
}
echo "\r\n<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\"  cellpadding=\"3\">\r\n  <tr>\r\n    <td align=\"left\">\r\n        <a href=\"list.php?";
echo $urlstr;
echo "&CUR_PAGE=1&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>\r\n        <a href=\"list.php?";
echo $urlstr;
echo "&CUR_PAGE=";
echo $CUR_PAGE - 1;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/first01.gif' width='24' border='0' height='15' alt='上一页'></a>\r\n        <a href=\"list.php?";
echo $urlstr;
echo "&CUR_PAGE=";
echo $CUR_PAGE + 1;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style=\"cursor:hand\"></a>\r\n        <a href=\"list.php?";
echo $urlstr;
echo "&CUR_PAGE=";
echo $PAGE_COUNT;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/last02.gif'  width='24' border='0' height='15' alt='末页' style=\"cursor:hand\"></a>\r\n\r\n      到\r\n      <input type=\"text\" name=\"PAGE_NUM\" size=\"3\" maxlength=\"4\"  class=\"SmallInput\">\r\n      页\r\n      <img id=\"btnGotoPage\" src=\"/images/menu/book.gif\" onClick=\"set_page('";
echo $urlstr;
echo "')\" border=\"0\" WIDTH=\"19\" HEIGHT=\"17\" style=\"cursor:hand\" alt=\"转到相应页面\">\r\n    </td>\r\n    <td align=\"right\">\r\n      ";
echo $CUR_PAGE;
echo "/";
echo $PAGE_COUNT;
echo "页&nbsp;共&nbsp;";
echo $CUSTOMER_COUNT;
echo "&nbsp;条\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n<table class=\"TableList\" width=\"95%\">\r\n  <tr class=\"TableHeader\">\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=CONTRACT_NO&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">合同编号&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "CONTRACT_NO" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "CONTRACT_NO" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=CONTRACT_NAME&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">合同名称&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "CONTRACT_NAME" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "CONTRACT_NAME" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=CUSTOMER_NAME&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">客户名称&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "CUSTOMER_NAME" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "CUSTOMER_NAME" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=TOTALPRICE&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">合同总价&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "TOTALPRICE" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "TOTALPRICE" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=PAYMENT&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">已付款数&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "PAYMENT" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "PAYMENT" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=BEGIN_DATE&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">生效日期&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "BEGIN_DATE" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "BEGIN_DATE" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=END_DATE&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">终止日期&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "END_DATE" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "END_DATE" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=CREATE_DATE&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">创建日期&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "CREATE_DATE" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "CREATE_DATE" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=CONTRACT_LINKMAN2&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">签约人(卖方)&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "CONTRACT_LINKMAN2" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "CONTRACT_LINKMAN2" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?";
echo $urlstr;
echo "&ORDERFIELD=SELLER&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">创建人&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "SELLER" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "SELLER" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n  </tr>\r\n\r\n";
$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";
	}
	echo "    <tr class=\"";
	echo $TableLine;
	echo "\">\r\n      <td nowrap align=\"center\">";
	echo $CONTRACT_NO1;
	echo "</td>\r\n       <td nowrap align=\"center\"><a href=\"javascript:show_detail2(";
	echo $CONTRACT_ID1;
	echo ");\">";
	echo $CONTRACT_NAME1;
	echo "</a></td>\r\n      <td nowrap align=\"center\">";
	echo $CUSTOMER_NAME1;
	echo "</td>\r\n      <td nowrap align=\"center\"><a href=\"javascript:show_detail(";
	echo $CONTRACT_ID1;
	echo ");\">";
	echo $TOTALPRICE1;
	echo "</a></td>\r\n       <td nowrap align=\"center\"><a href=\"javascript:show_detail1(";
	echo $CONTRACT_ID1;
	echo ");\">";
	echo $PAYMENT;
	echo "</a></td>\r\n      <td nowrap align=\"center\">";
	echo $BEGIN_DATE1;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $END_DATE1;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $CREATE_DATE1;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $CONTRACT_LINKMAN2;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $SELLER1;
	echo "</td>\r\n    </tr>\r\n\r\n";
}
echo "</table>\r\n<br>\r\n<div align=\"center\">\r\n<input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='index.php'\">\r\n</div>\r\n</body>\r\n</html>\r\n";
?>
上一页 12
💿 文件大小 17584 K
👤 上传用户 Rosa_
📂 所属分类 OA系统
🏷️ 相关标签

#2008 #Anywhere #20081216 #Office
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -