index.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 993 行 · 第 1/2 页
PHP
993 行
<?
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 check_one(el)
{
if(!el.checked)
document.all("allbox").checked=false;
}
function delete_customer(CONTRACT_ID,urlstr)
{
msg=\'确认要删除该合同？这也将删除相关的合同明细和合同付款记录。\';
if(window.confirm(msg))
{
URL="delete.php?CONTRACT_ID=" + CONTRACT_ID+"&"+urlstr+"&CUR_PAGE=';
echo $CUR_PAGE;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '";
window.location=URL;
}
}
function ad_query()
{
URL="ad_query";
window.location=URL;
}
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;dia';
echo 'logWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
function set_page(urlstr)
{
PAGE_START=PAGE_NUM.value;
location="index.php?CUR_PAGE="+PAGE_START+"&"+urlstr;
}
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
d';
echo 'ocument.all("email_select").item(i).checked=false;
}
if(i==0)
{
if(document.all("allbox").checked)
document.all("email_select").checked=true;
else
document.all("email_select").checked=false;
}
}
function delete_mail(urlstr)
{
delete_str="";
for(i=0;i<document.all("email_select").length;i++)
{
el=document.all("email_select").item(i);
if(el.';
echo 'checked)
{ val=el.value;
delete_str+=val + ",";
}
}
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="d';
echo 'elete.php?delete_str="+delete_str+"&"+urlstr+"&CUR_PAGE=';
echo $CUR_PAGE;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '";
window.location=URL;
}
}
</script>
</head>
<div align="left">
<fieldset style="width:95%;padding-bottom:5px;">
<legend class="small" align=left>
<b>快速查询</b>
</legend>
<table cellspacing="1" class="small" align="left" cellpadding="3">
<form action="index.php" method="post" name="form1">
<tr>
<td nowrap class="TableData"> 客户类别： </td>
<td nowrap ';
echo 'class="TableData" >
';
echo '<s';
echo 'elect name="KIND" class="SmallSelect">
';
getalldate ('CRM_KIND');
echo ' </select>
</td>
<td nowrap class="TableData">销售方式： </td>
<td nowrap class="TableData">
';
echo '<s';
echo 'elect name="SELLMODE" class="SmallSelect">
';
getalldate ('SELL_MODE');
echo ' </select>
</td>
<td nowrap class="TableData">客户名称： </td>
<td nowrap class="TableData">
<input type="text" name="CUSTOMER_NAME" class="SmallInput" size="15" maxlength="100" value="';
echo $CUSTOMER_NAME;
echo '">
</td>
<td nowrap class="TableData">签约人（买方）： </td>
<td nowrap class="TableData">
<input type="text" name="CONTRACT_LINKMAN1" class="SmallInput" size="10" maxlength="100" value="';
echo $CONTRACT_LINKMAN1;
echo '">
</td>
</tr>
<tr>
<td nowrap class="TableData"> 合同类型： </td>
<td nowrap class="TableData" >
';
echo '<s';
echo 'elect name="CONTRACT_TYPE" class="SmallSelect">
';
getalldate ('CONTRACT_TYPE');
echo ' </select>
</td>
<td nowrap class="TableData">合同编号： </td>
<td nowrap class="TableData">
<input type="text" name="CONTRACT_NO" class="SmallInput" size="15" maxlength="100" value="';
echo $CONTRACT_NO;
echo '">
</td>
<td nowrap class="TableData">合同名称： </td>
<td nowrap class="TableData">
<input type="text" name="CONTRACT_NAME" class="SmallInput" size="15" maxlength="100" value="';
echo $CONTRACT_NAME;
echo '">
</td>
<td nowrap class="TableData">签约人（卖方）： </td>
<td nowrap class="TableData">
<input type="text" name="CONTRACT_LINKMAN2" class="SmallInput" size="10" maxlength="100" value="';
echo $CONTRACT_LINKMAN2;
echo '">
</td>
</tr>
<tr>
<td nowrap class="TableData">
';
echo '<s';
echo 'elect name="DATE_TYPE" class="SmallSelect">
<option value="BEGIN">生效日期</option>
<option value="END">终止日期</option>
<option value="CREATE">创建日期</option>
</select>
</td>
<td nowrap class="TableData" colspan="7">
<input type="text" name="DATE1" size="15" maxlength="10" class="SmallStatic" readonly value="';
echo $BEGIN_DATE;
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 $BEGIN_DATE;
echo '">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.DATE2\');">
<input type="radio" name=\'SIGN\' id=\'SIGN1\' value="1"> <label for="SIGN1">款到合同</label><input type="radio" name=\'SIGN\' id=\'SIGN2\' value="0"> <label for="SIGN2">欠款合同</label>
</td>
</tr>
<tr>
<td nowrap class="TableData" colspan="3" >
&nb';
echo 'sp; <input value="快速查询" type="submit" class="SmallButton" title="快速查询" name="button">
<input value="高级查询" type="button" class="SmallButton" title="模糊查询" name="button1" onClick="ad_query();">
</td>
</tr>
</form>
</table>
</fieldset>
</div>
<br>
<br>
';
if (($CUSTOMER_NAME != ''))
{
if (($urlstr == ''))
{
$urlstr = ('CUSTOMER_NAME='.$CUSTOMER_NAME);
}
else
{
$urlstr = (($urlstr.'&CUSTOMER_NAME=').$CUSTOMER_NAME);
}
if (($WHERE_STR == ''))
{
($WHERE_STR .= ((' where d.CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
}
else
{
($WHERE_STR .= ((' and d.CUSTOMER_NAME like \'%'.$CUSTOMER_NAME).'%\''));
}
}
if (($KIND != ''))
{
if (($urlstr == ''))
{
$urlstr = ('KIND='.$KIND);
}
else
{
$urlstr = (($urlstr.'&KIND=').$KIND);
}
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((''.' where d.KIND =\'').$KIND).'\''));
}
else
{
($WHERE_STR .= (((''.' and d.KIND =\'').$KIND).'\''));
}
}
if (($SELLMODE != ''))
{
if (($urlstr == ''))
{
$urlstr = ('SELLMODE='.$SELLMODE);
}
else
{
$urlstr = (($urlstr.'&SELLMODE=').$SELLMODE);
}
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((''.' where d.SELLMODE =\'').$SELLMODE).'\''));
}
else
{
($WHERE_STR .= (((''.' and d.SELLMODE =\'').$SELLMODE).'\''));
}
}
if (($CONTRACT_TYPE != ''))
{
if (($urlstr == ''))
{
$urlstr = ('CONTRACT_TYPE='.$CONTRACT_TYPE);
}
else
{
$urlstr = (($urlstr.'&CONTRACT_TYPE=').$CONTRACT_TYPE);
}
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((''.' where a.CONTRACT_TYPE =\'').$CONTRACT_TYPE).'\''));
}
else
{
($WHERE_STR .= (((''.' and a.CONTRACT_TYPE =\'').$CONTRACT_TYPE).'\''));
}
}
if (($CONTRACT_NO != ''))
{
if (($urlstr == ''))
{
$urlstr = ('CONTRACT_NO='.$CONTRACT_NO);
}
else
{
$urlstr = (($urlstr.'&CONTRACT_NO=').$CONTRACT_NO);
}
if (($WHERE_STR == ''))
{
($WHERE_STR .= ((' where a.CONTRACT_NO like \'%'.$CONTRACT_NO).'%\''));
}
else
{
($WHERE_STR .= ((' and a.CONTRACT_NO like \'%'.$CONTRACT_NO).'%\''));
}
}
if (($CONTRACT_NAME != ''))
{
if (($urlstr == ''))
{
$urlstr = ('CONTRACT_NAME='.$CONTRACT_NAME);
}
else
{
$urlstr = (($urlstr.'&CONTRACT_NAME=').$CONTRACT_NAME);
}
if (($WHERE_STR == ''))
{
($WHERE_STR .= ((' where a.CONTRACT_NAME like \'%'.$CONTRACT_NAME).'%\''));
}
else
{
($WHERE_STR .= ((' and a.CONTRACT_NAME like \'%'.$CONTRACT_NAME).'%\''));
}
}
if (($CONTRACT_LINKMAN1 != ''))
{
if (($urlstr == ''))
{
$urlstr = ('CONTRACT_LINKMAN1='.$CONTRACT_LINKMAN1);
}
else
{
$urlstr = (($urlstr.'&CONTRACT_LINKMAN1=').$CONTRACT_LINKMAN1);
}
if (($WHERE_STR == ''))
{
($WHERE_STR .= ((' where a.CONTRACT_LINKMAN1 like \'%'.$CONTRACT_LINKMAN1).'%\''));
}
else
{
($WHERE_STR .= ((' and a.CONTRACT_LINKMAN1 like \'%'.$CONTRACT_LINKMAN1).'%\''));
}
}
if (($CONTRACT_LINKMAN2 != ''))
{
if (($urlstr == ''))
{
$urlstr = ('CONTRACT_LINKMAN2='.$CONTRACT_LINKMAN2);
}
else
{
$urlstr = (($urlstr.'&CONTRACT_LINKMAN2=').$CONTRACT_LINKMAN2);
}
if (($WHERE_STR == ''))
{
($WHERE_STR .= ((' where a.CONTRACT_LINKMAN2 like \'%'.$CONTRACT_LINKMAN2).'%\''));
}
else
{
($WHERE_STR .= ((' and a.CONTRACT_LINKMAN2 like \'%'.$CONTRACT_LINKMAN2).'%\''));
}
}
if (($DATE1 != ''))
{
if (($urlstr == ''))
{
$urlstr = ('DATE1='.$DATE1);
}
else
{
$urlstr = (($urlstr.'&DATE1=').$DATE1);
}
if (($WHERE_STR == ''))
{
($WHERE_STR .= ((' where a.'.$DATE_TYPE).(((''.'_DATE>=\'').$DATE1).'\'')));
}
else
{
($WHERE_STR .= ((' and a.'.$DATE_TYPE).(((''.'_DATE>=\'').$DATE1).'\'')));
}
}
if (($DATE2 != ''))
{
if (($urlstr == ''))
{
$urlstr = ('DATE2='.$DATE2);
}
else
{
$urlstr = (($urlstr.'&DATE2=').$DATE2);
}
if (($WHERE_STR == ''))
{
($WHERE_STR .= ((' where a.'.$DATE_TYPE).(((''.'_DATE<=\'').$DATE2).'\'')));
}
else
{
($WHERE_STR .= ((' and a.'.$DATE_TYPE).(((''.'_DATE<=\'').$DATE2).'\'')));
}
}
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((((''.' where (a.SELLER =\'').$LOGIN_USER_ID).'\' or a.CONTRACT_LINKMAN2=\'').$LOGIN_USER_ID).'\')'));
}
else
{
($WHERE_STR .= (((((''.' and (a.SELLER =\'').$LOGIN_USER_ID).'\' or a.CONTRACT_LINKMAN2=\'').$LOGIN_USER_ID).'\')'));
}
if (($SIGN == '0'))
{
if (($urlstr == ''))
{
$urlstr = ('SIGN='.$SIGN);
}
else
{
$urlstr = (($urlstr.'&SIGN=').$SIGN);
}
$HAVING = ' HAVING PAYMENT<TOTALPRICE';
}
if (($SIGN == '1'))
{
if (($urlstr == ''))
{
$urlstr = ('SIGN='.$SIGN);
}
else
{
$urlstr = (($urlstr.'&SIGN=').$SIGN);
}
$HAVING = ' HAVING PAYMENT>=TOTALPRICE';
}
if (($urlstr == ''))
{
$urlstr = ('DATE_TYPE='.$DATE_TYPE);
}
else
{
$urlstr = (($urlstr.'&DATE_TYPE=').$DATE_TYPE);
}
if (($ORDERFIELD != ''))
{
if (($ORDERSIGN == 'DOWN'))
{
$ORDERTYPE = 'ASC';
}
if (($ORDERSIGN == 'UP'))
{
$ORDERTYPE = 'DESC';
}
$OREDERBY = (((' ORDER BY '.$ORDERFIELD).' ').$ORDERTYPE);
}
$CUSTOMER_COUNT = 0;
$query = ((('SELECT a.CONTRACT_ID,sum(IFNULL(c.TOTAL_PRICE, 0)) as TOTALPRICE,sum(IFNULL(c.PAYMENT, 0)) as PAYMENT from CONTRACT a
LEFT OUTER JOIN SYS_CODE b ON a.CONTRACT_TYPE = b.CODE_NO AND b.PARENT_NO = \'CONTRACT_TYPE\'
LEFT OUTER JOIN CONTRACT_LINE c ON a.CONTRACT_ID = c.CONTRACT_ID
LEFT OUTER JOIN CUSTOMER d ON a.CUSTOMER_ID = d.CUSTOMER_ID
LEFT OUTER JOIN SYS_CODE e ON d.KIND= e.CODE_NO AND e.PARENT_NO = \'CRM_KIND\'
LEFT OUTER JOIN SYS_CODE f ON d.SELLMODE= f.CODE_NO AND f.PARENT_NO = \'SELL_MODE\'
LEFT OUTER JOIN USER g ON a.SELLER=g.USER_ID'.$WHERE_STR).' group by a.CONTRACT_ID').$HAVING);
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
++$CUSTOMER_COUNT;
}
$PER_PAGE = 5;
$PAGE_COUNT = ceil (($CUSTOMER_COUNT / $PER_PAGE));
if ((($CUR_PAGE <= 0) OR ($CUR_PAGE == '')))
{
$CUR_PAGE = 1;
}
if (($PAGE_COUNT < $CUR_PAGE))
{
$CUR_PAGE = $PAGE_COUNT;
}
$query1 = (((('SELECT a.CONTRACT_ID as CONTRACT_ID,a.CONTRACT_NAME as CONTRACT_NAME,a.CONTRACT_NO as CONTRACT_NO,
b.CODE_NAME as CONTRACT_TYPE,d.CUSTOMER_NAME as CUSTOMER_NAME,e.CODE_NAME as KIND,f.CODE_NAME as SELLMODE,
g.USER_NAME as SELLER,sum(IFNULL(c.TOTAL_PRICE, 0)) as TOTALPRICE,a.CREATE_DATE as CREATE_DATE,
a.BEGIN_DATE as BEGIN_DATE,a.END_DATE as END_DATE,sum(IFNULL(c.PAYMENT, 0)) as PAYMENT
from CONTRACT a
LEFT OUTER JOIN SYS_CODE b ON a.CONTRACT_TYPE = b.CODE_NO AND b.PARENT_NO = \'CONTRACT_TYPE\'
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?