detail.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 362 行
PHP
362 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>明细结果查看</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
$CUR_DATE = date ('Y-m-d', time ());
echo '
<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">';
echo '<s';
echo 'pan class="big3"> 办公用品管理明细</span>
</td>
</tr>
</table>
<div align="center">
';
$CUR_DATE = date ('Y-m-d', time ());
$TRANS_FLAG = trim ($TRANS_FLAG);
if (($TRANS_FLAG != -1))
{
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((''.' where a.TRANS_FLAG=\'').$TRANS_FLAG).'\''));
}
else
{
($WHERE_STR .= (((''.' and a.TRANS_FLAG=\'').$TRANS_FLAG).'\''));
}
}
if ((($PRO_ID != ' ') AND ($PRO_ID != '')))
{
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((''.' where a.PRO_ID=\'').$PRO_ID).'\''));
}
else
{
($WHERE_STR .= (((''.' and a.PRO_ID=\'').$PRO_ID).' \''));
}
}
if ((($OFFICE_PROTYPE != ' ') AND ($OFFICE_PROTYPE != '')))
{
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((''.' where b.OFFICE_PROTYPE=\'').$OFFICE_PROTYPE).'\''));
}
else
{
($WHERE_STR .= (((''.' and b.OFFICE_PROTYPE=\'').$OFFICE_PROTYPE).' \''));
}
}
if ((($PRO_NAME != ' ') AND ($PRO_NAME != '')))
{
if (($WHERE_STR == ''))
{
($WHERE_STR .= ((' where b.PRO_NAME like \'%'.$PRO_NAME).'%\''));
}
else
{
($WHERE_STR .= ((' and b.PRO_NAME like \'%'.$PRO_NAME).'%\''));
}
}
if ((($FROM_DATE != ' ') AND ($FROM_DATE != '')))
{
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((''.' where a.TRANS_DATE>=\'').$FROM_DATE).'\''));
}
else
{
($WHERE_STR .= (((''.' and a.TRANS_DATE>=\'').$FROM_DATE).'\''));
}
}
if ((($TO_DATE != ' ') AND ($TO_DATE != '')))
{
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((''.' where a.TRANS_DATE<=\'').$TO_DATE).'\''));
}
else
{
($WHERE_STR .= (((''.' and a.TRANS_DATE<=\'').$TO_DATE).'\''));
}
}
if ((($BORROWER != ' ') AND ($BORROWER != '')))
{
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((''.' where a.BORROWER=\'').$BORROWER).'\''));
}
else
{
($WHERE_STR .= (((''.' and a.BORROWER=\'').$BORROWER).'\''));
}
}
$query1 = 'select DEPT_ID from DEPARTMENT';
$cursor1 = exequery ($connection, $query1);
while ($ROW = mysql_fetch_array ($cursor1))
{
$DEPT_ID = $ROW['DEPT_ID'];
if ((is_dept_priv ($DEPT_ID) == 1))
{
$TO_ID = (($TO_ID.$DEPT_ID).',');
continue;
}
}
$TO_ID = (('\''.str_replace (',', '\',\'', substr ($TO_ID, 0, -1))).'\'');
if (($WHERE_STR == ''))
{
($WHERE_STR .= (((''.' where c.DEPT_ID in (').$TO_ID).')'));
}
else
{
($WHERE_STR .= (((''.' and c.DEPT_ID in (').$TO_ID).')'));
}
$CUR_DATE = date ('Y-m-d', time ());
$query = (('SELECT b.PRO_PRICE as PRO_PRICE, a.TRANS_ID,a.PRO_ID, b.PRO_NAME,a.TRANS_FLAG ,a.TRANS_QTY,a.BORROWER,b.PRO_UNIT,a.PRICE,a.TRANS_DATE,a.OPERATOR,a.REMARK from OFFICE_TRANSHISTORY a
LEFT OUTER JOIN OFFICE_PRODUCTS b ON a.PRO_ID = b.PRO_ID
LEFT OUTER JOIN USER c ON a.OPERATOR = c.USER_ID
'.$WHERE_STR).' order by a.TRANS_FLAG,a.TRANS_DATE DESC');
$cursor = exequery ($connection, $query);
$VOTE_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$VOTE_COUNT;
$SIGN = '';
$PROID = $ROW['PRO_ID'];
$TRANS_ID = $ROW['TRANS_ID'];
$PRONAME = $ROW['PRO_NAME'];
$PRO_UNIT = $ROW['PRO_UNIT'];
$BORROWER1 = $ROW['BORROWER'];
$TRANSFLAG = $ROW['TRANS_FLAG'];
$REMARK = $ROW['REMARK'];
$TRANS_QTY = $ROW['TRANS_QTY'];
$PRICE = $ROW['PRICE'];
$TRANS_DATE = $ROW['TRANS_DATE'];
$OPERATOR = $ROW['OPERATOR'];
$PRO_PRICE = $ROW['PRO_PRICE'];
if (($OPERATOR != $LOGIN_USER_ID))
{
$SIGN = '1';
}
$query1 = (((''.'select USER_NAME from USER where USER_ID=\'').$OPERATOR).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$OPERATOR_NAME = $ROW['USER_NAME'];
}
if (($TRANSFLAG == '0'))
{
$TRANS_NAME = '采购入库';
$BORROWER_NAME = '';
}
if (($TRANSFLAG == '1'))
{
$PRICE = $PRO_PRICE;
$TRANS_NAME = '领用';
$TRANS_QTY = ($TRANS_QTY * -1);
$TOK = strtok ($BORROWER1, ',');
$query1 = (((''.'select USER_NAME from USER where USER_ID=\'').$TOK).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$BORROWER_NAME = $ROW['USER_NAME'];
}
}
if (($TRANSFLAG == '2'))
{
$PRICE = $PRO_PRICE;
$TRANS_NAME = '借用';
$TRANS_QTY = ($TRANS_QTY * -1);
$TOK = strtok ($BORROWER1, ',');
$query1 = (((''.'select USER_NAME from USER where USER_ID=\'').$TOK).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$BORROWER_NAME = $ROW['USER_NAME'];
}
}
if (($TRANSFLAG == '3'))
{
$PRICE = $PRO_PRICE;
$TRANS_NAME = '归还';
$TOK = strtok ($BORROWER1, ',');
$query1 = (((''.'select USER_NAME from USER where USER_ID=\'').$TOK).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$BORROWER_NAME = $ROW['USER_NAME'];
}
}
if (($TRANSFLAG == '4'))
{
$PRICE = $PRO_PRICE;
$TRANS_NAME = '报废';
$BORROWER_NAME = '';
$TRANS_QTY = ($TRANS_QTY * -1);
}
if (($VOTE_COUNT == 1))
{
echo ' <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
';
}
if ((($VOTE_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td nowrap align="center">';
echo $PRONAME;
echo '</td>
<td align="center">';
echo $TRANS_NAME;
echo '</td>
<td align="center">';
echo $BORROWER_NAME;
echo '</td>
<td nowrap align="center">';
echo $TRANS_QTY;
echo $PRO_UNIT;
echo '</td>
<td nowrap align="center">';
echo $PRICE;
echo '</td>
<td nowrap align="center">';
echo $TRANS_DATE;
echo '</td>
<td nowrap align="center">';
echo $OPERATOR_NAME;
echo '</td>
<td nowrap align="center">';
echo $REMARK;
echo '</td>
<td nowrap align="center">
';
if ((($SIGN != '1') OR ($LOGIN_USER_ID == 'admin')))
{
echo '
<a href="record.php?TRANS_ID=';
echo $TRANS_ID;
echo '&TRANS_FLAG=';
echo $TRANS_FLAG;
echo '&PRO_ID=';
echo $PRO_ID;
echo '&PRO_NAME=';
echo $PRO_NAME;
echo '&FROM_DATE=';
echo $FROM_DATE;
echo '&TO_DATE=';
echo $TO_DATE;
echo '&BORROWER=';
echo $BORROWER;
echo '">修改</a>
<a href="javascript:delete_detail(\'';
echo $TRANS_ID;
echo '\');">删除</a>
';
}
else
{
echo '无';
}
echo '
</td>
</tr>
';
}
if ((0 < $VOTE_COUNT))
{
echo ' <tr align="center" class="TableControl">
<td colspan="9" nowrap>
<input type="button" value="删除以上明细" class="BigButton" onClick="delete_all(\'';
echo $TRANS_FLAG;
echo '\',\'';
echo $PRO_ID;
echo '\',\'';
echo $PRO_NAME;
echo '\',\'';
echo $FROM_DATE;
echo '\',\'';
echo $TO_DATE;
echo '\',\'';
echo $BORROWER;
echo '\')">
<input type="button" value="返回" class="BigButton" onclick="location=\'index.php\'">
</td>
</tr>
<thead class="TableHeader">
<td nowrap align="center">办公用品名称</td>
<td nowrap align="center">登记类型</td>
<td nowrap align="center">领用/借用/归还人</td>
<td nowrap align="center">数量</td>
<td nowrap align="center">单价</td>
';
echo ' <td nowrap align="center">操作日期</td>
<td nowrap align="center">操作员</td>
<td nowrap align="center">备注</td>
<td nowrap align="center">操作</td>
</thead>
</table>
';
}
else
{
message ('', '无操作记录！！');
button_back ();
}
echo '
</div>
';
echo '<s';
echo 'cript>
function delete_all(TRANS_FLAG,PRO_ID,PRO_NAME,FROM_DATE,TO_DATE,BORROWER)
{
msg=\'确认删除明细？\';
if(window.confirm(msg))
{
URL="delete.php?TRANS_FLAG="+TRANS_FLAG+"&PRO_ID="+PRO_ID+"&PRO_NAME="+PRO_NAME+"&FROM_DATE"+FROM_DATE+"&TO_DATE="+TO_DATE+"&BORROWER="+BORROWER;
window.location=URL;
}
}
function delete_detail(TRANSID)
{
msg=\'确认该明细？\';
if(window.confir';
echo 'm(msg))
{
URL="delete.php?TRANS_FLAG=';
echo $TRANS_FLAG;
echo '&PRO_ID=';
echo $PRO_ID;
echo '&PRO_NAME=';
echo $PRO_NAME;
echo '&FROM_DATE=';
echo $FROM_DATE;
echo '&TO_DATE=';
echo $TO_DATE;
echo '&BORROWER=';
echo $BORROWER;
echo '"+"&TRANSID="+TRANSID;
window.location=URL;
}
}
</script>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?