list.php

通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(

	{
		$WHERE_STR .= " where j.CONTACT_CONTENT like '%".$CONTACT_CONTENT."%'";
	}
	else
	{
		$WHERE_STR .= " and j.CONTACT_CONTENT like '%".$CONTACT_CONTENT."%'";
	}
}
$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 a.CUSTOMER_ID in (".$CUSTOMERID_STR.")";
		}
		else
		{
			$WHERE_STR .= " and a.CUSTOMER_ID in (".$CUSTOMERID_STR.")";
		}
	}
}
$query = "SELECT FIELDNO from FIELDSETTING where TABLENAME='CONTACT'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$FIELDNO = "CONTACT".$ROW['FIELDNO'];
	if ( $$FIELDNO != "" )
	{
		$CONTACTID_STR = "";
		if ( $urlstr == "" )
		{
			$urlstr = $FIELDNO."=".$$FIELDNO;
		}
		else
		{
			$urlstr = $urlstr."&".$FIELDNO."=".$$FIELDNO;
		}
		$WHERE_STR1 = " where TABLENAME='CONTACT' 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 ) )
		{
			$CONTACTID_STR = $CONTACTID_STR.$ROW1['IDENTY_ID'].",";
		}
		$CONTACTID_STR = "'".str_replace( ",", "','", substr( $CONTACTID_STR, 0, -1 ) )."'";
		if ( $WHERE_STR == "" )
		{
			$WHERE_STR .= " where j.CONTACT_ID in (".$CONTACTID_STR.")";
		}
		else
		{
			$WHERE_STR .= " and j.CONTACT_ID in (".$CONTACTID_STR.")";
		}
	}
}
if ( $ORDERFIELD != "" )
{
	if ( $ORDERSIGN == "DOWN" )
	{
		$ORDERTYPE = "ASC";
	}
	if ( $ORDERSIGN == "UP" )
	{
		$ORDERTYPE = "DESC";
	}
	$OREDERBY = " ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
if ( $flagstr != "" )
{
	$query1 = "SELECT  ".$TYPENAME_ARRAY[1]." as SUMNAME, count(DISTINCT j.CONTACT_ID) AS CONTACTCOUNT,sum(j.TIME_COST) as TOTALTIME,sum(j.MONEY_COST) as TOTALMONEY,CONCAT_WS('/',".$flagstr.") as WHNAME,".$TYPENAME_ARRAY[0]." as KINDID\r\n        from CONTACT j LEFT OUTER JOIN CUSTOMER a ON a.CUSTOMER_ID = j.CUSTOMER_ID\r\n        LEFT OUTER JOIN SYS_CODE b\r\n        ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'\r\n        LEFT OUTER JOIN SYS_CODE c\r\n        ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'\r\n        LEFT OUTER JOIN SYS_CODE d\r\n        ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = 'AREA'\r\n        LEFT OUTER JOIN SYS_CODE e\r\n        ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = 'CRM_SOURCE'\r\n        LEFT OUTER JOIN SYS_CODE f\r\n        ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = 'CRM_ATTRIBUTE'\r\n        LEFT OUTER JOIN SYS_CODE g\r\n        ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = 'CRM_TYPE'\r\n        LEFT OUTER JOIN USER h ON j.SELLER = h.USER_ID\r\n        LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID\r\n        LEFT OUTER JOIN SYS_CODE k\r\n        ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = 'CONTACT_TYPE'\r\n        ".$WHERE_STR." GROUP BY ".$TYPENAME_ARRAY[0].$OREDERBY;
}
else
{
	$query1 = "SELECT  ".$TYPENAME_ARRAY[1]." as SUMNAME, count(DISTINCT j.CONTACT_ID) AS CONTACTCOUNT,sum(j.TIME_COST) as TOTALTIME,sum(j.MONEY_COST) as TOTALMONEY,".$TYPENAME_ARRAY[0]." as KINDID\r\n        from CONTACT j LEFT OUTER JOIN CUSTOMER a ON a.CUSTOMER_ID = j.CUSTOMER_ID\r\n        LEFT OUTER JOIN SYS_CODE b\r\n        ON a.SELLMODE = b.CODE_NO AND b.PARENT_NO = 'SELL_MODE'\r\n        LEFT OUTER JOIN SYS_CODE c\r\n        ON a.KIND = c.CODE_NO AND c.PARENT_NO = 'CRM_KIND'\r\n        LEFT OUTER JOIN SYS_CODE d\r\n        ON a.CUSTOMER_AREA = d.CODE_NO AND d.PARENT_NO = 'AREA'\r\n        LEFT OUTER JOIN SYS_CODE e\r\n        ON a.SOURCE = e.CODE_NO AND e.PARENT_NO = 'CRM_SOURCE'\r\n        LEFT OUTER JOIN SYS_CODE f\r\n        ON a.ATTRIBUTE = f.CODE_NO AND f.PARENT_NO = 'CRM_ATTRIBUTE'\r\n        LEFT OUTER JOIN SYS_CODE g\r\n        ON a.ENTERTYPE = g.CODE_NO AND g.PARENT_NO = 'CRM_TYPE'\r\n        LEFT OUTER JOIN USER h ON j.SELLER = h.USER_ID\r\n         LEFT OUTER JOIN DEPARTMENT i ON h.DEPT_ID = i.DEPT_ID\r\n        LEFT OUTER JOIN SYS_CODE k\r\n        ON j.CONTACT_TYPE = k.CODE_NO AND k.PARENT_NO = 'CONTACT_TYPE'\r\n        ".$WHERE_STR." GROUP BY ".$TYPENAME_ARRAY[0].$OREDERBY;
}
$cursor1 = exequery( $connection, $query1 );
echo "<br>\r\n<div align=\"center\">\r\n\r\n\r\n\r\n";
$CUSTOMER_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	++$CUSTOMER_COUNT;
	$SUMNAME = $ROW['SUMNAME'];
	$CONTACTCOUNT = $ROW['CONTACTCOUNT'];
	$TOTALMONEY = $ROW['TOTALMONEY'];
	$TOTALTIME = $ROW['TOTALTIME'];
	$WHNAME = $ROW['WHNAME'];
	$TOTAL_SUMSALE += $CONTACTCOUNT;
	$TOTAL_PRO_PRICE += $TOTALTIME;
	$TOTAL_SER_PRICE += $TOTALMONEY;
	if ( $WHNAME != "" )
	{
		$WHNAME = "(".$WHNAME.")";
	}
	if ( $SUMNAME == "" )
	{
		$SUMNAME = "其他";
	}
	$ARRAY_FIELD = $ARRAY_FIELD.$SUMNAME.",";
	$graphValuesa = $graphValuesa.$CONTACTCOUNT.",";
	$graphValuesc = $graphValuesc.$TOTALMONEY.",";
	$graphValuesb = $graphValuesb.$TOTALTIME.",";
	if ( $urlstr == "" )
	{
		$WHERE_STR1 = "strwhr1=".$TYPENAME_ARRAY[0]."&strvalue=".$ROW['KINDID']."&TYPENAME=".$SUMNAME."&TYPEIDNAME=".$TYPENAME_ARRAY[2];
	}
	else
	{
		$WHERE_STR1 = $urlstr."&strvalue=".$ROW['KINDID']."&strwhr1=".$TYPENAME_ARRAY[0]."&TYPENAME=".$SUMNAME."&TYPEIDNAME=".$TYPENAME_ARRAY[2];
	}
	if ( $CUSTOMER_COUNT == 1 )
	{
		echo "   <table width=\"70%\" class=\"TableBlock\">\r\n   <tr class=\"TableHeader\">\r\n      <td nowrap align=\"center\"><a href=\"list.php?SUMFIELD=";
		echo $SUMFIELD;
		echo "&";
		echo $urlstr;
		echo "&ORDERFIELD=SUMNAME&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 "\">";
		echo $TYPENAME_ARRAY[2];
		echo "&nbsp;";
		if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "SUMNAME" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "SUMNAME" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?SUMFIELD=";
		echo $SUMFIELD;
		echo "&";
		echo $urlstr;
		echo "&ORDERFIELD=CONTACTCOUNT&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 == "CONTACTCOUNT" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "CONTACTCOUNT" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?SUMFIELD=";
		echo $SUMFIELD;
		echo "&";
		echo $urlstr;
		echo "&ORDERFIELD=TOTALTIME&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 == "TOTALTIME" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "TOTALTIME" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"list.php?SUMFIELD=";
		echo $SUMFIELD;
		echo "&";
		echo $urlstr;
		echo "&ORDERFIELD=TOTALMONEY&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 == "TOTALMONEY" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "TOTALMONEY" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a></td>\r\n      <td nowrap align=\"center\">进一步统计</td>\r\n  </tr>\r\n";
	}
	if ( $CUSTOMER_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "    <tr class=\"";
	echo $TableLine;
	echo "\">\r\n      <td nowrap align=\"center\">";
	echo $SUMNAME;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $CONTACTCOUNT;
	echo "</td>\r\n       <td nowrap align=\"center\">";
	echo $TOTALTIME;
	echo "小时</td>\r\n        <td nowrap align=\"center\">";
	echo $TOTALMONEY;
	echo "</td>\r\n      <td nowrap align=\"left\"><input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "1' value=\"h.DEPT_ID,i.DEPT_NAME,销售部门\" onclick=\"return chk(this,'";
	echo $WHERE_STR1;
	echo "');\"><label for=\"SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "1\">销售部门</label> &nbsp;<input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "2' value=\"h.USER_ID,h.USER_NAME,销售人员\" onclick=\"return chk(this,'";
	echo $WHERE_STR1;
	echo "');\"><label for=\"SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "2\">销售人员</label>&nbsp;<input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "3' value=\"j.CONTACT_TYPE,k.CODE_NAME,客户服务类型\" onclick=\"return chk(this,'";
	echo $WHERE_STR1;
	echo "');\"><label for=\"SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "3\">客户服务类型</label>&nbsp;<input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "4' value=\"a.CUSTOMER_ID,a.CUSTOMER_NAME,客户\"  onclick=\"return chk(this,'";
	echo $WHERE_STR1;
	echo "');\"><label for=\"SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "4\">客户</label><br>\r\n      <input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "5' value=\"a.CUSTOMER_AREA,d.CODE_NAME,地区\" onclick=\"return chk(this,'";
	echo $WHERE_STR1;
	echo "');\"><label for=\"SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "5\">地区</label>&nbsp;<input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "6' value=\"a.SOURCE,e.CODE_NAME,客户来源\" onclick=\"return chk(this,'";
	echo $WHERE_STR1;
	echo "');\"><label for=\"SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "6\">客户来源</label> &nbsp;<input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "7' value=\"a.KIND,c.CODE_NAME,客户类别\" onclick=\"return chk(this,'";
	echo $WHERE_STR1;
	echo "');\"><label for=\"SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "7\">客户类别</label>&nbsp;<input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "8' value=\"a.SELLMODE,b.CODE_NAME,销售方式\" onclick=\"return chk(this,'";
	echo $WHERE_STR1;
	echo "');\"><label for=\"SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "8\">销售方式</label>\r\n      <input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "9' value=\"a.ATTRIBUTE,f.CODE_NAME,行业属性\" onclick=\"return chk(this,'";
	echo $WHERE_STR1;
	echo "');\"><label for=\"SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "9\">行业属性</label> &nbsp;<input type=\"radio\" name='SUMFIELD' id='SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "10' value=\"a.ENTERTYPE,g.CODE_NAME,企业性质\" onclick=\"return chk(this,'";
	echo $WHERE_STR1;
	echo "');\"><label for=\"SUMFIELD";
	echo $CUSTOMER_COUNT;
	echo "10\">企业性质</label>&nbsp;\r\n      </td>\r\n    </tr>\r\n\r\n";
}
if ( $CUSTOMER_COUNT == 0 )
{
	message( "", "无满足条件的客户服务记录" );
	button_back( );
	exit( );
}
echo " <tr class=\"TableHeader\">\r\n      <td nowrap align=\"center\">合计：</td>\r\n      <td nowrap align=\"center\">";
echo $TOTAL_SUMSALE;
echo "</td>\r\n      <td nowrap align=\"center\">";
echo $TOTAL_PRO_PRICE;
echo "小时</td>\r\n       <td nowrap align=\"center\">";
echo $TOTAL_SER_PRICE;
echo "</td>\r\n      <td nowrap align=\"center\"></td>\r\n </tr>\r\n<tr class=\"TableHeader\">\r\n      <td nowrap align=\"center\" colspan=4>统计图&nbsp;&nbsp;（<input type=\"radio\" name='FLAG' id='FLAG1' value=\"a\" checked><label for=\"FLAG1\">服务次数</label>&nbsp;&nbsp;<input type=\"radio\" name='FLAG' id='FLAG2' value=\"b\" ><label for=\"FLAG2\">服务总时间</label> &nbsp;&nbsp;<input type=\"radio\" name='FLAG' id='FLAG3' value=\"c\"><label for=\"FLAG3\">服务总成本</label>）</td>\r\n      <td nowrap align=\"center\" ><a href=\"javascript:LoadWindow1('";
echo $ARRAY_FIELD;
echo "','";
echo $graphValuesa;
echo "','";
echo $graphValuesb;
echo "','";
echo $graphValuesc;
echo "','1');\"><img src=\"/images/finance1.gif\" align=\"absmiddle\" border=0 WIDTH=\"22\" HEIGHT=\"22\" ></a>\r\n      \t&nbsp;&nbsp;&nbsp;<a href=\"javascript:LoadWindow1('";
echo $ARRAY_FIELD;
echo "','";
echo $graphValuesa;
echo "','";
echo $graphValuesb;
echo "','";
echo $graphValuesc;
echo "','2');\"><img src=\"/images/cake.gif\" align=\"absmiddle\" border=0  WIDTH=\"22\" HEIGHT=\"22\" ></a></td>\r\n</tr>\r\n\r\n</table>\r\n</div>\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\r\n</body>\r\n</html>\r\n";
?>