index.php

来自「通达OA2007SE源代码非常好的」· PHP 代码 · 共 603 行 · 第 1/2 页
PHP
603 行
<?
  function getalldate ($CODE)
  {
    global $connection;
    $query = (((''.'SELECT * from SYS_CODE where PARENT_NO=\'').$CODE).'\'');
    $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>');
    }
  }
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  $PAGE_SIZE = 10;
  echo '<html>
<head>
<title>销售统计</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript Language="JavaScript">
	function LoadWindow()
{
  URL="/module/dept_select";
  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
  window.showModalDialog(URL,self,"edge:raised;scroll:1;status:0;help:0;resizable:1;dialogWidth:400px;dialogHeight:330px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
functio';
  echo 'n chk(input,KC,KT,count)
  {
     var lstr="";
  	 if(count==1)
  	 {
  	 	if(document.all(KC).checked)
  	 	{
  	 		document.all(KT).value=document.all(KC).value;
  	 	}
  	  else
  	  {
  	  	document.all(KT).value="";
  	  }
  	 }
  	else
  	{
  	  for(i=0;i<document.all(KC).length;i++)
     {
        el=document.all(KC).item(i);
        if(el.checked)
        {
        	 ';
  echo 'val=el.value;
           lstr+=val+",";
        }
     }
  	document.all(KT).value=lstr;
    }
  }
function clear_user2()
{
  document.form1.COPY_TO_NAME.value="";
  document.form1.COPY_TO_ID.value="";
}
function clear_dept()
{
  document.form1.TO_NAME.value="";
  document.form1.TO_ID.value="";
}
function LoadWindow2()
{
  URL="/module/user_select?ID=2";
  loc_x=document.body';
  echo '.scrollLeft+event.clientX-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
  //window.open(URL,"read_notify","height=400,width=550,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=150,resizable=yes");
  window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:400px;dialogHeight:350px;dialogTop:"+loc_y+';
  echo '"px;dialogLeft:"+loc_x+"px");
}
function td_calendar(fieldname)
{
  myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
  mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
  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:"+my';
  echo 'left+"px");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/finance1.gif" WIDTH="22" HEIGHT="22" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3">&nbsp;&nbsp;销售统计</span><br>
    </td>
  </tr>
</table>
<br>
<table border="0" width="70%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
 <form action="list.php"  method="post" name="form1">    <tr>
      <td nowrap class="TableHeader" colspan="2">
         <img src="/images/green_arrow.gif"> &nbsp;&nbsp;统计方式
      </td>
    </tr>
    <tr heig';
  echo 'ht="20">
      <td nowrap class="TableData">时间：&nbsp;&nbsp;</td>
      <td class="TableData" align="left">&nbsp;
        <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '1\' value="YEAR(j.DATE),YEAR(j.DATE),年" checked><label for="SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '1">年</label> &nbsp;<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '2\' value="MONTH,MONTH,月"><label for="SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '2">月</label>&nbsp;
      </td>
    </tr>
    <tr height="20">
      <td nowrap class="TableData">销售部门、人员：&nbsp;&nbsp;</td>
      <td class="TableData" align="left">&nbsp;
        <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '3\' value="h.DEPT_ID,i.DEPT_NAME,销售部门"><label for="SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '3">销售部门</label> &nbsp;<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '4\' value="h.USER_ID,h.USER_NAME,销售人员"><label for="SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '4">销售人员</label>&nbsp;
      </td>
    </tr>
    <tr height="20">
      <td nowrap class="TableData">产品：&nbsp;&nbsp;</td>
      <td class="TableData" align="left">&nbsp;
        <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '5\' value="j.PRODUCT_ID,k.PRODUCT_NAME,产品名称"><label for="SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '5">产品名称</label> &nbsp;<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '6\' value="k.PRODUCT_MODE,m.CODE_NAME,产品类别"><label for="SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '6">产品类别</label>&nbsp;
      </td>
    </tr>
    <tr height="20">
      <td nowrap class="TableData">服务：&nbsp;&nbsp;</td>
      <td class="TableData" align="left">&nbsp;
        <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '7\' value="j.SERVICE_ID,l.SERVICE_NAME,服务名称"><label for="SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '7">服务名称</label>
      </td>
    </tr>
    <tr height="20">
      <td nowrap class="TableData" width="100">客户类型：</td>
      <td class="TableData" align="left">&nbsp;
        <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '8\' value="a.SOURCE,e.CODE_NAME,客户来源"><label for="SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '8">客户来源</label> &nbsp;<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '9\' value="a.KIND,c.CODE_NAME,客户类别"><label for="SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '9">客户类别</label>&nbsp;<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '10\' value="a.SELLMODE,b.CODE_NAME,销售方式"><label for="SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '10">销售方式</label> &nbsp;<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '11\' value="a.CUSTOMER_AREA,d.CODE_NAME,地区"><label for="SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '11">地区</label>&nbsp;<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '12\' value="j.CUSTOMER_ID,a.CUSTOMER_NAME,客户"><label for="SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '12">客户</label>
      </td>
    </tr>
    <tr height="20">
      <td nowrap class="TableData" width="100">客户企业概况：</td>
      <td class="TableData" align="left">&nbsp;
        <input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '13\' value="a.ATTRIBUTE,f.CODE_NAME,行业属性"><label for="SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '13">行业属性</label> &nbsp;<input type="radio" name=\'SUMFIELD\' id=\'SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '14\' value="a.ENTERTYPE,g.CODE_NAME,企业性质"><label for="SUMFIELD';
  echo $CUSTOMER_COUNT;
  echo '14">企业性质</label>&nbsp;
      </td>
    </tr>
</table>
<br>
<table border="0" width="100%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
    <tr>
      <td nowrap class="TableHeader">
         <img src="/images/green_arrow.gif"> &nbsp;&nbsp;统计范围
      </td>
    </tr>
 <tr>
  <td nowrap class="TableData">
  <div align="center">
  <fieldset style="width:95%;pa';
  echo 'dding-bottom:5px;">
	 <legend class="small" align=left>
      <b>销售部门、人员、主管</b>
  </legend>
<table cellspacing="1" class="small" align="left" cellpadding="3" border="0">
  <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;销售部门： </td>
    <td nowrap class="TableData">
        <input type="hidden" name="TO_ID">
        <textarea cols=21 name=TO_NAME rows=2 class="BigStatic" wrap="yes"';
  echo ' readonly>';
  echo $TO_NAME;
  echo '</textarea>
        <input value="选择" type="button" class="SmallButton" title="选择销售部门" name="button" onClick="LoadWindow()">
        &nbsp;<input type="button" value="清空" class="SmallButton" onClick="clear_dept()" title="清空部门" name="button">
    </td>
    <td nowrap class="TableData">&nbsp;&nbsp;销售人员： </td>
    <td nowrap class="TableData">
        <input type="hidden" name="COPY_';
  echo 'TO_ID" value="">
        <textarea cols=21 name="COPY_TO_NAME" rows=2 class="BigStatic" wrap="yes" readonly></textarea>
        <input value="选择" type="button" onClick="LoadWindow2()" class="SmallButton" title="选择销售人员" name="button">
        &nbsp;<input type="button" value="清空" class="SmallButton" onClick="clear_user2()" title="清空人员" name="button">
    </td>
  </tr>
  <tr>
  	<td now';
  echo 'rap class="TableData"  colspan="6" align="right">
    (*所有条件可以组合查询)&nbsp;&nbsp;<input value="确定" type="submit" class="SmallButton"  name="button">
    </td>
  </tr>
</table>
</fieldset>
</div>
<br>
<div align="center">
<fieldset style="width:95%;padding-bottom:5px;">
	 <legend class="small" align="left">
      <b>销售信息</b>
  </legend>
<table cellspacing="1" class="small" align="left"';
  echo ' cellpadding="3">
 <tr>
 	<td nowrap class="TableData">&nbsp;&nbsp;产品类别：</td>
    <td nowrap class="TableData">
      ';
  echo '<s';
  echo 'elect name="PRODUCT_MODE" class="SmallSelect">
';
  getalldate ('PRODUCT_MODE', $PRODUCT_MODE);
  echo '      </select>
    </td>
    <td nowrap class="TableData">产品名称： </td>
    <td nowrap class="TableData">
        <input type="text" name="PRODUCT_NAME" class="SmallInput" size="15" maxlength="100">
    </td>
   <td nowrap class="TableData">产品型号： </td>
    <td nowrap class="TableData" >
        <input type="text" name="PRODUCT_TYPE" class="SmallInput" size="15" maxlength="100">
    </td>
  ';
  echo ' </tr>
 </tr>
 <tr>
 	   <td nowrap class="TableData">&nbsp;&nbsp;服务名称： </td>
     <td nowrap class="TableData">
        <input type="text" name="SERVICE_NAME" class="SmallInput" size="15" maxlength="100">
     </td>
     <td nowrap class="TableData">服务描述： </td>
    <td nowrap class="TableData" colspan="5">
       <textarea cols=37 rows=1 name="SERVICE_DESC" class="SmallInput" wrap="yes">';
  echo $MEMO;
  echo '</textarea>
    </td>
 </tr>
 <tr>
 	<td nowrap class="TableData">&nbsp;&nbsp;销售日期： </td>
 	<td nowrap class="TableData" colspan="5">
      <input type="text" name="DATE1" size="15" maxlength="10" class="SmallStatic" readonly value="';
  echo $DATE1;
  echo '">
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.DATE1\');">
       至<input type="text" name="DATE2" size="15" maxlength="10" class="SmallStatic" readonly value="';
  echo $DATE2;
  echo '">
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.DATE2\');">
 </tr>
 <tr>
 		<td nowrap class="TableData"  align="right" width="650" colspan="6">
      <input value="确定" type="submit" class="SmallButton" title="确定" name="button">
    </td>
index.php - 源码说明

本页面展示了「通达OA2007SE源代码非常好的」中的 index.php 源码文件，采用 PHP 编程语言编写，共 603 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。
虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。
⌨️ 快捷键说明

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