📄 index.php

📁 通达OA2007SE源代码非常好的
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?
  include_once 'inc/auth.php';
  echo '<html>
<head>
<title>供应商联系人管理 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
  function set_page()
{
 PAGE_START=PAGE_NUM.value;
 location="index.php?PROVIDER_NAME=';
  echo $PROVIDER_NAME;
  echo '&MAIN_LINKMAN=';
  echo $MAIN_LINKMAN;
  echo '&PROVIDER_CODE=';
  echo $PROVIDER_CODE;
  echo '&PROVIDER_SHORT=';
  echo $PROVIDER_SHORT;
  echo '&LINKMAN_NAME=';
  echo $LINKMAN_NAME;
  echo '&ADD_HOME=';
  echo $ADD_HOME;
  echo '&SEX=';
  echo $SEX;
  echo '&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '&CUR_PAGE="+PAGE_START;
}
  function delete_linkman(LINKMAN_ID)
{
 msg=\'确认要删除该联系人？\';
 if(window.confirm(msg))
 {
  URL="delete.php?PROVIDER_NAME=';
  echo $PROVIDER_NAME;
  echo '&MAIN_LINKMAN=';
  echo $MAIN_LINKMAN;
  echo '&PROVIDER_CODE=';
  echo $PROVIDER_CODE;
  echo '&PROVIDER_SHORT=';
  echo $PROVIDER_SHORT;
  echo '&LINKMAN_NAME=';
  echo $LINKMAN_NAME;
  echo '&ADD_HOME=';
  echo $ADD_HOME;
  echo '&SEX=';
  echo $SEX;
  echo '&CUR_PAGE=';
  echo $CUR_PAGE;
  echo '&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '&LINKMAN_ID=" + LINKMAN_ID;
  window.location=URL;
 }
}
function check_one(el)
{
   if(!el.checked)
      document.all("allbox").checked=false;
}
function check_all()
{
 for (i=0;i<document.all("email_select").length;i++)
 {
   if(document.all("allbox").checked)
      document.all("email_select").item(i).checked=true;
   else
      document.all("email_select").item(i).checked=false;';
  echo '
 }
 if(i==0)
 {
   if(document.all("allbox").checked)
      document.all("email_select").checked=true;
   else
      document.all("email_select").checked=false;
 }
}
function delete_mail()
{
  delete_str="";
  for(i=0;i<document.all("email_select").length;i++)
  {
      el=document.all("email_select").item(i);
      if(el.checked)
      {  val=el.value;
         delete_str+=v';
  echo 'al + ",";
      }
  }
  if(i==0)
  {
      el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }
  if(delete_str=="")
  {
     alert("请至少选择其中一个联系人");
     return;
  }
  msg=\'确认要删除所选联系人？\';
  if(window.confirm(msg))
  {
    URL="delete.php?PROVIDER_NAME=';
  echo $PROVIDER_NAME;
  echo '&MAIN_LINKMAN=';
  echo $MAIN_LINKMAN;
  echo '&PROVIDER_CODE =';
  echo $PROVIDER_CODE;
  echo '&PROVIDER_SHORT=';
  echo $PROVIDER_SHORT;
  echo '&LINKMAN_NAME=';
  echo $LINKMAN_NAME;
  echo '&ADD_HOME=';
  echo $ADD_HOME;
  echo '&SEX=';
  echo $SEX;
  echo '&CUR_PAGE=';
  echo $CUR_PAGE;
  echo '&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '&delete_str=" + delete_str;
    window.location=URL;
  }
}
function mobile_sms(MOBIL_NO_STR)
  {
    URL="/general/mobile_sms/new/?TO_ID1="+MOBIL_NO_STR;
    myleft=(screen.availWidth-650)/2;
    window.open(URL,"mobile_sms","height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
  }
 function show_detail(LINKMAN_ID)
 ';
  echo ' {
    URL="showdetail.php?LINKMAN_ID="+LINKMAN_ID;
    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>
<div align="left">
<fieldset style="width:95%;padding-bottom:5px;">
	 <legend class="small" align=left>
      <b> 查 询 </';
  echo 'b>
  </legend>
<table cellspacing="1" class="small" align="left" cellpadding="3">
   <form action="index.php"  method="post" name="form1">
  <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;供应商名称： </td>
    <td nowrap class="TableData">
        <input type="text" name="PROVIDER_NAME" class="SmallInput" size="15" maxlength="100">
    </td>
   <td nowrap class="TableData">供应商编码： </td>
  ';
  echo '  <td nowrap class="TableData">
        <input type="text" name="PROVIDER_CODE" class="SmallInput" size="15" maxlength="100">
    </td>
     <td nowrap class="TableData">供应商简称： </td>
    <td nowrap class="TableData">
        <input type="text" name="PROVIDER_SHORT" class="SmallInput" size="15" maxlength="100">&nbsp;
    </td>
   </tr>
    <tr>
    <td nowrap class="TableData">&nbsp;&nbsp';
  echo ';联系人姓名： </td>
    <td nowrap class="TableData">
        <input type="text" name="LINKMAN_NAME" class="SmallInput" size="15" maxlength="100">
    </td>
    <td nowrap class="TableData">地址： </td>
    <td nowrap class="TableData">
        <input type="text" name="ADD_HOME" class="SmallInput" size="15" maxlength="100" >
    </td>
    <td nowrap class="TableData">性别： </td>
    <td nowrap class';
  echo '="TableData">
        ';
  echo '<s';
  echo 'elect name="SEX" class="SmallSelect">
        	<option value="" ></option>
          <option value="0" ';
  if (($SEX == '0'))
  {
    echo 'selected';
  }
  echo '>男</option>
          <option value="1" ';
  if (($SEX == '1'))
  {
    echo 'selected';
  }
  echo '>女</option>
        </select>&nbsp;&nbsp;&nbsp;&nbsp;
        <input type="checkbox" name="MAIN_LINKMAN" id="MAIN_LINKMAN" value="1"><label for="MAIN_LINKMAN">主联系人</label>
        &nbsp;&nbsp;&nbsp;&nbsp;<input value="查询" type="submit" class="SmallButton" title="模糊查询" name="button">
    </td>
   </tr>
 </form>
</table>
</fieldset>
</div>
<br>
';
  if (($PROVIDER_NAME != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where PROVIDER_NAME like \'%'.$PROVIDER_NAME).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and PROVIDER_NAME like \'%'.$PROVIDER_NAME).'%\''));
    }
  }
  if (($PROVIDER_NAME != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where b.PROVIDER_NAME like \'%'.$PROVIDER_NAME).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and b.PROVIDER_NAME like \'%'.$PROVIDER_NAME).'%\''));
    }
  }
  if (($PROVIDER_CODE != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where b.PROVIDER_CODE like \'%'.$PROVIDER_CODE).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and b.PROVIDER_CODE like \'%'.$PROVIDER_CODE).'%\''));
    }
  }
  if (($PROVIDER_SHORT != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where b.PROVIDER_SHORT like \'%'.$PROVIDER_SHORT).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and b.PROVIDER_SHORT like \'%'.$PROVIDER_SHORT).'%\''));
    }
  }
  if (($LINKMAN_NAME != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.LINKMAN_NAME like \'%'.$LINKMAN_NAME).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.LINKMAN_NAME like \'%'.$LINKMAN_NAME).'%\''));
    }
  }
  if (($ADD_HOME != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.ADD_HOME like \'%'.$ADD_HOME).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.ADD_HOME like \'%'.$ADD_HOME).'%\''));
    }
  }
  if (($SEX != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.SEX=\''.$SEX).'\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.SEX=\''.$SEX).'\''));
    }
  }
  if (($MAIN_LINKMAN != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where a.MAIN_LINKMAN=\''.$MAIN_LINKMAN).'\''));
    }
    else
    {
      ($WHERE_STR .= ((' and a.MAIN_LINKMAN=\''.$MAIN_LINKMAN).'\''));
    }
  }
  if (($ORDERFIELD != ''))
  {
    if (($ORDERSIGN == 'DOWN'))
    {
      $ORDERTYPE = 'ASC';
    }
    if (($ORDERSIGN == 'UP'))
    {
      $ORDERTYPE = 'DESC';
    }
    $OREDERBY = (((' ORDER BY '.$ORDERFIELD).' ').$ORDERTYPE);
  }
  $query = 'SELECT count(*) FROM `PROVIDER_LINKMAN` a LEFT OUTER JOIN PROVIDER b ON a.`PROVIDER_ID` = b.`PROVIDER_ID` ';
  ($query .= $WHERE_STR);
  $cursor = exequery ($connection, $query);
  $LINKMAN_COUNT = 0;
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $LINKMAN_COUNT = $ROW[0];
  }
  $query = (('SELECT a.MOBILE  FROM `PROVIDER_LINKMAN` a LEFT OUTER JOIN PROVIDER b ON a.`PROVIDER_ID` = b.`PROVIDER_ID` '.$WHERE_STR).$OREDERBY);
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $MOBILE1 = $ROW['MOBILE'];
    if (($MOBILE1 != ''))
    {
      ($MOBIL_NO_STR .= ($MOBILE1.','));
      continue;
    }
  }
  $PER_PAGE = 10;
  $PAGE_COUNT = ceil (($LINKMAN_COUNT / $PER_PAGE));
  if ((($CUR_PAGE <= 0) OR ($CUR_PAGE == '')))
  {
    $CUR_PAGE = 1;
  }
  if (($PAGE_COUNT < $CUR_PAGE))
  {
    $CUR_PAGE = $PAGE_COUNT;
  }
  $query1 = (('SELECT MAIN_LINKMAN,a.LINKMAN_ID,b.PROVIDER_ID,LINKMAN_NAME,SEX,a.TEL_NO_WORK,a.MOBILE,a.EMAIL as EMAIL,a.OICQ,a.ICQ,b.PROVIDER_NAME  FROM `PROVIDER_LINKMAN` a LEFT OUTER JOIN PROVIDER b ON a.`PROVIDER_ID` = b.`PROVIDER_ID`  '.$WHERE_STR).$OREDERBY);
  $offest = (($CUR_PAGE - 1) * 10);
  $query1 = (((($query1.' LIMIT ').$offest).' ,').$PER_PAGE);
  $cursor1 = exequery ($connection, $query1);
  if (($LINKMAN_COUNT == 0))
  {
    message ('<br>提示', '没有符合条件的联系人');
    echo '<br>
';
    exit ();
  }
  else
  {
    echo '
<table border="0" cellspacing="1" width="95%" class="small"  cellpadding="3">
  <tr>
    <td align="left">
        <a href="index.php?CUR_PAGE=1&PROVIDER_NAME=';
    echo $PROVIDER_NAME;
    echo '&MAIN_LINKMAN=';
    echo $MAIN_LINKMAN;
    echo '&PROVIDER_CODE=';
    echo $PROVIDER_CODE;
    echo '&PROVIDER_SHORT=';
    echo $PROVIDER_SHORT;
    echo '&LINKMAN_NAME=';
    echo $LINKMAN_NAME;
    echo '&ADD_HOME=';
    echo $ADD_HOME;
    echo '&SEX=';
    echo $SEX;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '"><img src=\'/images/first02.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'首页\'></a>
        <a href="index.php?CUR_PAGE=';
    echo ($CUR_PAGE - 1);
    echo '&PROVIDER_NAME=';
    echo $PROVIDER_NAME;
    echo '&MAIN_LINKMAN=';
12 下一页
⌨️ 快捷键说明

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