⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 list.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
$PAGE_SIZE=10;
?>

<html>
<head>
<title>客户统计结果 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">

function chk(input,strwher)
  {
    URL="list1.php?"+strwher+"&SUMFIELD="+input.value;
    myleft=(screen.availWidth-650)/2;
    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");
  }

function LoadWindow1(ARRAY_FIELD,graphValues,type)
  {
    URL="statics?ARRAY_FIELD="+ARRAY_FIELD+"&graphValues="+graphValues+"&type="+type;
    myleft=(screen.availWidth-650)/2;
    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");
  }
</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/notify_open.gif" WIDTH="22" HEIGHT="22" align="absmiddle"><span class="big3">&nbsp;&nbsp;客户统计结果</span><br>
    </td>
  </tr>
</table>
<?

$TYPENAME_ARRAY=explode(",",$SUMFIELD);

//-----------先组织SQL语句-----------


if($COPY_TO_ID!="")
   {
   	 if($urlstr=="")$urlstr="COPY_TO_ID=".$COPY_TO_ID;
     else $urlstr=$urlstr."&COPY_TO_ID=".$COPY_TO_ID;
   	$COPY_TO_ID="'".str_replace(",","','",substr($COPY_TO_ID,0,-1))."'";
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.SELLER in ($COPY_TO_ID)";
     else
         $WHERE_STR.=" and a.SELLER in ($COPY_TO_ID)";
   }
if($TO_ID!="")
   {
   	 if($urlstr=="")$urlstr="TO_ID=".$TO_ID;
     else $urlstr=$urlstr."&TO_ID=".$TO_ID;

   	 $TO_ID="'".str_replace(",","','",substr($TO_ID,0,-1))."'";
     if($WHERE_STR=="")
         $WHERE_STR.=" where h.DEPT_ID in ($TO_ID)";
     else
         $WHERE_STR.=" and h.DEPT_ID in ($TO_ID)";
   }

if($SELL_MANAGEID!="")
   {
   	$COPY_TO_ID="'".str_replace(",","','",substr($COPY_TO_ID,0,-1))."'";
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.SELLER in ($COPY_TO_ID)";
     else
         $WHERE_STR.=" and a.SELLER in ($COPY_TO_ID)";
   }

if($CUSTOMER_NAME!="")
   {
      if($urlstr=="")$urlstr="CUSTOMER_NAME=".$CUSTOMER_NAME;
     else $urlstr=$urlstr."&CUSTOMER_NAME=".$CUSTOMER_NAME;
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
     else
         $WHERE_STR.=" and a.CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
   }

if($CUSTOMER_CODE!="")
   {
   	 if($urlstr=="")$urlstr="CUSTOMER_CODE=".$CUSTOMER_CODE;
     else $urlstr=$urlstr."&CUSTOMER_CODE=".$CUSTOMER_CODE;
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
     else
         $WHERE_STR.=" and a.CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
   }

if($CUSTOMER_SHORT!="")
   {
   	if($urlstr=="")$urlstr="CUSTOMER_SHORT=".$CUSTOMER_SHORT;
     else $urlstr=$urlstr."&CUSTOMER_SHORT=".$CUSTOMER_SHORT;
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
     else
         $WHERE_STR.=" and a.CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
   }

if($CUSTOMER_AREA!="")
   {
   	 	if($urlstr=="")$urlstr="CUSTOMER_AREA=".$CUSTOMER_AREA;
     else $urlstr=$urlstr."&CUSTOMER_AREA=".$CUSTOMER_AREA;
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.CUSTOMER_AREA='$CUSTOMER_AREA'";
     else
         $WHERE_STR.=" and a.CUSTOMER_AREA='$CUSTOMER_AREA'";
   }

if($CUSTOMER_ADD!="")
   {
   		if($urlstr=="")$urlstr="CUSTOMER_ADD=".$CUSTOMER_ADD;
     else $urlstr=$urlstr."&CUSTOMER_ADD=".$CUSTOMER_ADD;
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.CUSTOMER_ADD like '%".$CUSTOMER_ADD."%'";
     else
         $WHERE_STR.=" and a.CUSTOMER_ADD like '%".$CUSTOMER_ADD."%'";
   }

if($SOURCE!="")
   {
     if($flagstr=="")$flagstr="e.CODE_NAME";
     else $flagstr=$flagstr.",e.CODE_NAME";
     	if($urlstr=="")$urlstr="SOURCE=".$SOURCE;
      else $urlstr=$urlstr."&SOURCE=".$SOURCE;
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.SOURCE ='$SOURCE'";
     else
         $WHERE_STR.=" and a.SOURCE ='$SOURCE'";
   }
if($KIND!="")
   {
     if($flagstr=="")$flagstr="c.CODE_NAME";
     else $flagstr=$flagstr.",c.CODE_NAME";
     if($urlstr=="")$urlstr="KIND=".$KIND;
     else $urlstr=$urlstr."&KIND=".$KIND;

     if($WHERE_STR=="")
         $WHERE_STR.=" where a.KIND ='$KIND'";
     else
         $WHERE_STR.=" and a.KIND ='$KIND'";
   }
if($SELLMODE!="")
   {
   	 if($flagstr=="")$flagstr="b.CODE_NAME";
     else $flagstr=$flagstr.",b.CODE_NAME";

      if($urlstr=="")$urlstr="SELLMODE=".$SELLMODE;
     else $urlstr=$urlstr."&SELLMODE=".$SELLMODE;

     if($WHERE_STR=="")
         $WHERE_STR.=" where a.SELLMODE ='$SELLMODE'";
     else
         $WHERE_STR.=" and a.SELLMODE ='$SELLMODE'";
   }
if($ATTRIBUTE!="")
   {
   	    if($urlstr=="")$urlstr="ATTRIBUTE=".$ATTRIBUTE;
     else $urlstr=$urlstr."&ATTRIBUTE=".$ATTRIBUTE;
   	 if($flagstr=="")$flagstr="f.CODE_NAME";
     else $flagstr=$flagstr.",f.CODE_NAME";
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.ATTRIBUTE ='$ATTRIBUTE'";
     else
         $WHERE_STR.=" and a.ATTRIBUTE ='$ATTRIBUTE'";
   }
if($ENTERTYPE!="")
   {
   	   if($urlstr=="")$urlstr="ENTERTYPE=".$ENTERTYPE;
     else $urlstr=$urlstr."&ENTERTYPE=".$ENTERTYPE;
   	 if($flagstr=="")$flagstr="g.CODE_NAME";
     else $flagstr=$flagstr.",g.CODE_NAME";
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.ENTERTYPE ='$ENTERTYPE'";
     else
         $WHERE_STR.=" and a.ENTERTYPE ='$ENTERTYPE'";
   }
if($ENTERMEMO!="")
   {
   	  if($urlstr=="")$urlstr="ENTERMEMO=".$ENTERMEMO;
12

⌨️ 快捷键说明

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