📄 index.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?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'];
	$DELETE_FLAG = $ROW['DELETE_FLAG'];
}
echo "\r\n<html>\r\n<head>\r\n<title>销售机会搜索 </title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script Language=\"JavaScript\">\r\nfunction delete_chance0(CHANCE_ID)\r\n{\r\n msg='确认要删除该销售机会么？';\r\n if(window.confirm(msg))\r\n {\r\n   URL=\"delete.php?CHANCE_NAME0=";
echo $CHANCE_NAME0;
echo "&CUSTOMER_NAME0=";
echo $CUSTOMER_NAME0;
echo "&SELLER_NAME0=";
echo $SELLER_NAME0;
echo "&CHANCE_RANK0=";
echo $CHANCE_RANK0;
echo "&BARGAIN_MONEY0=";
echo $BARGAIN_MONEY0;
echo "&BARGAIN_MONEY1=";
echo $BARGAIN_MONEY1;
echo "&CHANCE_STATUS0=";
echo $CHANCE_STATUS0;
echo "&BARGAIN_DATE0=";
echo $BARGAIN_DATE0;
echo "&BARGAIN_DATE1=";
echo $BARGAIN_DATE1;
echo "&DESC0=";
echo $DESC0;
echo "&REMARK0=";
echo $REMARK0;
echo "&ADD_TIME0=";
echo $ADD_TIME0;
echo "&ADD_TIME1=";
echo $ADD_TIME1;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CHANCE_ID=\" + CHANCE_ID;\r\n   window.location=URL;\r\n }\r\n}\r\n\r\nfunction check_one(el)\r\n{\r\n   if(!el.checked)\r\n      document.all(\"allbox\").checked=false;\r\n}\r\n\r\nfunction set_page()\r\n{\r\n PAGE_START=PAGE_NUM.value;\r\n location=\"index.php?CHANCE_NAME0=";
echo $CHANCE_NAME0;
echo "&CUSTOMER_NAME0=";
echo $CUSTOMER_NAME0;
echo "&SELLER_NAME0=";
echo $SELLER_NAME0;
echo "&CHANCE_RANK0=";
echo $CHANCE_RANK0;
echo "&BARGAIN_MONEY0=";
echo $BARGAIN_MONEY0;
echo "&BARGAIN_MONEY1=";
echo $BARGAIN_MONEY1;
echo "&CHANCE_STATUS0=";
echo $CHANCE_STATUS0;
echo "&BARGAIN_DATE0=";
echo $BARGAIN_DATE0;
echo "&BARGAIN_DATE1=";
echo $BARGAIN_DATE1;
echo "&DESC0=";
echo $DESC0;
echo "&REMARK0=";
echo $REMARK0;
echo "&ADD_TIME0=";
echo $ADD_TIME0;
echo "&ADD_TIME1=";
echo $ADD_TIME1;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=\"+PAGE_START;\r\n}\r\n\r\nfunction show_detail(CHANCE_ID)\r\n  {\r\n    URL=\"showdetail.php?CHANCE_ID=\"+CHANCE_ID;\r\n    myleft=(screen.availWidth-650)/2;\r\n    window.open(URL,\"formul_edit\",\"height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n  }\r\nfunction check_all()\r\n{\r\n for (i=0;i<document.all(\"chance_select\").length;i++)\r\n {\r\n   if(document.all(\"allbox\").checked)\r\n      document.all(\"chance_select\").item(i).checked=true;\r\n   else\r\n      document.all(\"chance_select\").item(i).checked=false;\r\n }\r\n\r\n if(i==0)\r\n {\r\n   if(document.all(\"allbox\").checked)\r\n      document.all(\"chance_select\").checked=true;\r\n   else\r\n      document.all(\"chance_select\").checked=false;\r\n }\r\n}\r\n\r\nfunction delete_chance()\r\n{\r\n  delete_str=\"\";\r\n  for(i=0;i<document.all(\"chance_select\").length;i++)\r\n  {\r\n\r\n      el=document.all(\"chance_select\").item(i);\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         delete_str+=val + \",\";\r\n      }\r\n  }\r\n\r\n  if(i==0)\r\n  {\r\n      el=document.all(\"chance_select\");\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         delete_str+=val + \",\";\r\n      }\r\n  }\r\n\r\n  if(delete_str==\"\")\r\n  {\r\n     alert(\"请至少选择其中一个销售机会。\");\r\n     return;\r\n  }\r\n  msg='确认要删除所选销售机会？';\r\n  if(window.confirm(msg))\r\n  {\r\n    URL=\"delete.php?CHANCE_NAME0=";
echo $CHANCE_NAME0;
echo "&CUSTOMER_NAME0=";
echo $CUSTOMER_NAME0;
echo "&SELLER_NAME0=";
echo $SELLER_NAME0;
echo "&CHANCE_RANK0=";
echo $CHANCE_RANK0;
echo "&BARGAIN_MONEY0=";
echo $BARGAIN_MONEY0;
echo "&BARGAIN_MONEY1=";
echo $BARGAIN_MONEY1;
echo "&CHANCE_STATUS0=";
echo $CHANCE_STATUS0;
echo "&BARGAIN_DATE0=";
echo $BARGAIN_DATE0;
echo "&BARGAIN_DATE1=";
echo $BARGAIN_DATE1;
echo "&DESC0=";
echo $DESC0;
echo "&REMARK0=";
echo $REMARK0;
echo "&ADD_TIME0=";
echo $ADD_TIME0;
echo "&ADD_TIME1=";
echo $ADD_TIME1;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&delete_str=\"+delete_str;\r\n    window.location=URL;\r\n  }\r\n}\r\nfunction td_calendar(fieldname)\r\n{\r\n  myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;\r\n  mytop=document.body.scrollTop+event.clientY-event.offsetY+140;\r\n\r\n  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\");\r\n}\r\n\r\n</script>\r\n</head>\r\n<body topmargin=\"5\" class=\"bodycolor\">\r\n<div align=\"left\">\r\n<fieldset style=\"width:95%;padding-bottom:5px;\">\r\n\t <legend class=\"small\" align=left>\r\n      <b>快速查询</b>\r\n  </legend>\r\n<table class=\"TableList\" align=\"left\" width=\"100%\">\r\n  <form action=\"index.php\"  method=\"post\" name=\"form1\">\r\n  <tr>\r\n    <td nowrap class=\"TableData\">&nbsp;&nbsp;机会主题： </td>\r\n    <td nowrap class=\"TableData\">\r\n        <input type=\"text\" name=\"CHANCE_NAME0\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $CHANCE_NAME0;
echo "\">\r\n    </td>\r\n\r\n     <td nowrap class=\"TableData\">客户单位： </td>\r\n    <td nowrap class=\"TableData\">\r\n        <input type=\"text\" name=\"CUSTOMER_NAME0\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $CUSTOMER_NAME0;
echo "\">\r\n        </select>\r\n    </td>\r\n    <td nowrap class=\"TableData\">业务员： </td>\r\n    <td nowrap class=\"TableData\">\r\n        <input type=\"text\" name=\"SELLER_NAME0\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $SELLER_NAME0;
echo "\">\r\n    </td>\r\n   </tr>\r\n  <tr>\r\n    <td nowrap class=\"TableData\">&nbsp;&nbsp;机会等级： </td>\r\n    <td nowrap class=\"TableData\">\r\n        <select name=\"CHANCE_RANK0\" class=\"SmallSelect\">\r\n\t\t<option value=''></option>\r\n    ";
echo code_list( "CHANCE_RANK", $CHANCE_RANK0 );
echo "        </select>\r\n    </td>\r\n    <td nowrap class=\"TableData\">机会状态： </td>\r\n    <td nowrap class=\"TableData\">\r\n        <select name=\"CHANCE_STATUS0\" class=\"SmallSelect\">\r\n\t\t<option value=''></option>\r\n    ";
echo code_list( "CHANCE_STATUS", $CHANCE_STATUS0 );
echo "        </select>\r\n    </td>\r\n    <td nowrap class=\"TableData\">预计成交日期： </td>\r\n    <td nowrap class=\"TableData\" >\r\n        <input type=\"text\" name=\"BARGAIN_DATE0\" class=\"SmallInput\" size=\"15\" maxlength=\"50\" value=\"";
echo $BARGAIN_DATE0;
echo "\">\r\n        <img src=\"/images/menu/calendar.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.BARGAIN_DATE0');\">\r\n\t\t-\r\n\t\t<input type=\"text\" name=\"BARGAIN_DATE1\" class=\"SmallInput\" size=\"15\" maxlength=\"50\" value=\"";
echo $BARGAIN_DATE1;
echo "\">\r\n        <img src=\"/images/menu/calendar.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.BARGAIN_DATE1');\">\r\n    </td>\r\n  </tr>\r\n <tr>\r\n    <td nowrap class=\"TableData\">&nbsp;&nbsp;机会描述： </td>\r\n    <td nowrap class=\"TableData\">\r\n        <input type=\"text\" name=\"DESC0\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $DESC0;
echo "\">\r\n    </td>\r\n    <td nowrap class=\"TableData\">备注： </td>\r\n    <td nowrap class=\"TableData\">\r\n        <input type=\"text\" name=\"REMARK0\" class=\"SmallInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $REMARK0;
echo "\">\r\n    </td>\r\n \t<td nowrap class=\"TableData\">登记时间： </td>\r\n    <td nowrap class=\"TableData\">\r\n        <input type=\"text\" name=\"ADD_TIME0\" class=\"SmallInput\" size=\"15\" maxlength=\"50\" value=\"";
echo $ADD_TIME0;
echo "\">\r\n        <img src=\"/images/menu/calendar.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.ADD_TIME0');\">\r\n        -\r\n\t\t<input type=\"text\" name=\"ADD_TIME1\" class=\"SmallInput\" size=\"15\" maxlength=\"50\" value=\"";
echo $ADD_TIME1;
echo "\">\r\n        <img src=\"/images/menu/calendar.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.ADD_TIME1');\">\r\n    </td>\r\n </tr>\r\n <tr>\r\n \t<td nowrap class=\"TableData\"  colspan=\"6\" >\r\n \t&nbsp;&nbsp;<input value=\"查询\" type=\"submit\" class=\"SmallButton\" title=\"快速查询\" name=\"button\">\r\n  </td>\r\n </tr>\r\n</form>\r\n</table>\r\n</fieldset>\r\n</div>\r\n<br>\r\n<br>\r\n";
$WHERE_STR = " where 1=1";
if ( $CHANCE_NAME0 != "" )
{
	$WHERE_STR .= " and CHANCE_NAME like '%".$CHANCE_NAME0."%'";
}
if ( $CUSTOMER_NAME0 != "" )
{
	$WHERE_STR .= " and d.CUSTOMER_NAME like '%".$CUSTOMER_NAME0."%'";
}
if ( $SELLER_NAME0 != "" )
{
	$WHERE_STR .= " and e.USER_NAME like '%".$SELLER_NAME0."%'";
}
if ( $CHANCE_RANK0 != "" )
{
	$WHERE_STR .= " and CHANCE_RANK= '".$CHANCE_RANK0."'";
}
if ( $CHANCE_STATUS0 != "" )
{
	$WHERE_STR .= " and CHANCE_STATUS= '".$CHANCE_STATUS0."'";
}
if ( $BARGAIN_DATE0 != "" )
{
	$WHERE_STR .= " and BARGAIN_DATE>= '".$BARGAIN_DATE0."'";
}
if ( $BARGAIN_DATE1 != "" )
{
	$WHERE_STR .= " and BARGAIN_DATE<= '".$BARGAIN_DATE1."'";
}
if ( $BARGAIN_MONEY0 != "" )
{
	$WHERE_STR .= " and BARGAIN_MONEY>= '".$BARGAIN_MONEY0."'";
}
if ( $BARGAIN_MONEY1 != "" )
{
	$WHERE_STR .= " and BARGAIN_MONEY<= '".$BARGAIN_MONEY1."'";
}
if ( $DESC0 != "" )
{
	$WHERE_STR .= " and `DESC` like '%".$DESC0."%'";
}
if ( $REMARK0 != "" )
{
	$WHERE_STR .= " and REMARK like '%".$REMARK0."%'";
}
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;
}
$CHANCE_COUNT = 0;
$query = "SELECT count(*) from SALE_CHANCE a LEFT OUTER JOIN SYS_CODE b ON a.CHANCE_RANK = b.CODE_NO AND b.PARENT_NO = 'CHANCE_RANK' LEFT OUTER JOIN SYS_CODE c ON a.CHANCE_STATUS = c.CODE_NO AND c.PARENT_NO = 'CHANCE_STATUS' LEFT OUTER JOIN CUSTOMER d ON a.CUSTOMER_ID = d.CUSTOMER_ID LEFT OUTER JOIN USER e ON a.SELLER = e.USER_ID ".$WHERE_STR;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$CHANCE_COUNT = $ROW[0];
}
$PER_PAGE = 10;
$PAGE_COUNT = ceil( $CHANCE_COUNT / $PER_PAGE );
if ( $CUR_PAGE <= 0 || $CUR_PAGE == "" )
{
	$CUR_PAGE = 1;
}
if ( $PAGE_COUNT < $CUR_PAGE )
{
	$CUR_PAGE = $PAGE_COUNT;
}
$query1 = "SELECT a.*,b.CODE_NAME CHANCE_RANK,c.CODE_NAME CHANCE_STATUS,d.CUSTOMER_NAME,e.USER_NAME SELLER_NAME from SALE_CHANCE a LEFT OUTER JOIN SYS_CODE b ON a.CHANCE_RANK = b.CODE_NO AND b.PARENT_NO = 'CHANCE_RANK' LEFT OUTER JOIN SYS_CODE c ON a.CHANCE_STATUS = c.CODE_NO AND c.PARENT_NO = 'CHANCE_STATUS' LEFT OUTER JOIN CUSTOMER d ON a.CUSTOMER_ID = d.CUSTOMER_ID LEFT OUTER JOIN USER e ON a.SELLER = e.USER_ID ".$WHERE_STR.$OREDERBY;
$offest = ( $CUR_PAGE - 1 ) * 10;
$query1 = $query1." LIMIT ".$offest." ,".$PER_PAGE;
$cursor1 = exequery( $connection, $query1 );
if ( $CHANCE_COUNT == 0 )
{
	message( "<br>提示", "没有符合条件的销售机会" );
	exit( );
}
echo "<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\"  cellpadding=\"3\">\r\n  <tr>\r\n    <td align=\"left\">\r\n        <a href=\"index.php?CUR_PAGE=1&CHANCE_NAME0=";
echo $CHANCE_NAME0;
echo "&CUSTOMER_NAME0=";
echo $CUSTOMER_NAME0;
echo "&SELLER_NAME0=";
echo $SELLER_NAME0;
echo "&CHANCE_RANK0=";
echo $CHANCE_RANK0;
echo "&BARGAIN_MONEY0=";
echo $BARGAIN_MONEY0;
echo "&BARGAIN_MONEY1=";
echo $BARGAIN_MONEY1;
echo "&CHANCE_STATUS0=";
echo $CHANCE_STATUS0;
echo "&BARGAIN_DATE0=";
echo $BARGAIN_DATE0;
echo "&BARGAIN_DATE1=";
echo $BARGAIN_DATE1;
echo "&DESC0=";
echo $DESC0;
echo "&REMARK0=";
echo $REMARK0;
echo "&ADD_TIME0=";
echo $ADD_TIME0;
echo "&ADD_TIME1=";
echo $ADD_TIME1;
echo "&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=\"index.php?CUR_PAGE=";
echo $CUR_PAGE - 1;
echo "&CHANCE_NAME0=";
echo $CHANCE_NAME0;
echo "&CUSTOMER_NAME0=";
echo $CUSTOMER_NAME0;
echo "&SELLER_NAME0=";
echo $SELLER_NAME0;
echo "&CHANCE_RANK0=";
echo $CHANCE_RANK0;
echo "&BARGAIN_MONEY0=";
echo $BARGAIN_MONEY0;
echo "&BARGAIN_MONEY1=";
echo $BARGAIN_MONEY1;
echo "&CHANCE_STATUS0=";
echo $CHANCE_STATUS0;
echo "&BARGAIN_DATE0=";
echo $BARGAIN_DATE0;
echo "&BARGAIN_DATE1=";
echo $BARGAIN_DATE1;
echo "&DESC0=";
echo $DESC0;
echo "&REMARK0=";
echo $REMARK0;
echo "&ADD_TIME0=";
echo $ADD_TIME0;
echo "&ADD_TIME1=";
echo $ADD_TIME1;
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=\"index.php?CUR_PAGE=";
echo $CUR_PAGE + 1;
echo "&CHANCE_NAME0=";
echo $CHANCE_NAME0;
echo "&CUSTOMER_NAME0=";
echo $CUSTOMER_NAME0;
echo "&SELLER_NAME0=";
echo $SELLER_NAME0;
echo "&CHANCE_RANK0=";
echo $CHANCE_RANK0;
echo "&BARGAIN_MONEY0=";
echo $BARGAIN_MONEY0;
echo "&BARGAIN_MONEY1=";
echo $BARGAIN_MONEY1;
echo "&CHANCE_STATUS0=";
echo $CHANCE_STATUS0;
echo "&BARGAIN_DATE0=";
echo $BARGAIN_DATE0;
echo "&BARGAIN_DATE1=";
echo $BARGAIN_DATE1;
echo "&DESC0=";
echo $DESC0;
echo "&REMARK0=";
echo $REMARK0;
echo "&ADD_TIME0=";
echo $ADD_TIME0;
echo "&ADD_TIME1=";
echo $ADD_TIME1;
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=\"index.php?CUR_PAGE=";
echo $PAGE_COUNT;
echo "&CHANCE_NAME0=";
echo $CHANCE_NAME0;
echo "&CUSTOMER_NAME0=";
echo $CUSTOMER_NAME0;
echo "&SELLER_NAME0=";
12 下一页
⌨️ 快捷键说明

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