📄 search_result.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?php

include_once( "inc/auth.php" );
include_once( "inc/function_page_01.php" );
session_start( );
if ( $_REQUEST['cur_page'] == "" )
{
	$cur_page = 1;
}
else
{
	$cur_page = $_REQUEST['cur_page'];
}
echo "\r\n<html>\r\n<head>\r\n<title>入库单管理</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n";
echo "<s";
echo "cript>\r\nfunction exports(sort,appellation,spec,join_amount,price,money,user_name,date,bill,provider_name,choose){\r\n\tlocation = \"export.php?sort=\"+sort+\"&appellation=\"+appellation+\"&spec=\"+spec+\"&join_amount=\"+join_amount+\"&price=\"+price+\"&money=\"+money+\"&user_name=\"+user_name+\"&date=\"+date+\"&bill=\"+bill+\"&provider_name=\"+provider_name+\"&choose=\"+choose;\r\n}\r\n\r\nfunction del(storeroom_id){\r\n\tvar msg\t";
echo "= \"你确定要删除此条记录？\";\r\n\tif(window.confirm(msg)){\r\n\t\turl\t= \"update.php?handle=delete&storeroom_id=\"+storeroom_id;\r\n\t\tlocation = url;\r\n\t}\r\n}\r\n\r\nfunction check_all(){\r\n\tfor(i=0; i<document.all(\"box\").length; i++){\r\n\t\tif(document.all(\"allbox\").checked)\r\n\t\t\tdocument.all(\"box\").item(i).checked = true;\r\n\t\telse\r\n\t\t\tdocument.all(\"box\").item(i).checked\t= false;\r\n\t}\r\n\r\n\tif(i == 0){\r\n\t\tif(document.all(\"a";
echo "llbox\").checked)\r\n\t\t\tdocument.all(\"box\").checked\t= true;\r\n\t\telse\r\n\t\t\tdocument.all(\"box\").checked\t= false;\r\n\t}\r\n}\r\n\r\nfunction batch_export(){\r\n\tselect_str\t= \"\";\r\n\tfor(i=0; i<document.all(\"box\").length; i++){\r\n\t\tel\t= document.all(\"box\").item(i);\r\n\t\tif(el.checked){\r\n\t\t\tval\t= el.value;\r\n\t\t\tselect_str\t+= val + \",\";\r\n\t\t}\r\n\t}\r\n\r\n\tif(i == 0){\r\n\t\tel = document.all(\"box\");\r\n\t\tif(el.checked){\r\n\t\t\tval\t= el.val";
echo "ue;\r\n\t\t\tselect_str\t+= val + \",\";\r\n\t\t}\r\n\t}\r\n\r\n\tif(select_str == \"\"){\r\n\t\talert(\"请至少选择其中一条记录！\");\r\n\t\treturn;\r\n\t}\r\n\r\n\turl\t= \"select_export.php?id_str=\"+ select_str;\r\n\tlocation = url;\r\n}\r\n\r\nfunction select_stay(){\r\n\tstay\t= \"\";\r\n\tfor(i=0; i<document.all(\"box\").length; i++){\r\n\t\tel\t= document.all(\"box\").item(i);\r\n\t\tif(el.checked){\r\n\t\t\tval = el.value;\r\n\t\t\tstay\t+= val;\r\n\t\t}\r\n\t}\r\n\r\n\tif(i == 0){\r\n\t\t";
echo "el = document.all(\"box\");\r\n\t\tif(el.checked){\r\n\t\t\tval\t= el.value;\r\n\t\t\tstay\t+= val;\r\n\t\t}\r\n\t}\r\n\tdocument.form1.stay.value\t= stay;\r\n}\r\nfunction bill_detail(storeroom_id)\r\n{\r\n\tvar url\t= \"detail.php?storeroom_id=\"+storeroom_id;\r\n\twindow.open(url, '', 'height=600,width=800,top=50, left=100,toolbar=no,menubar=no,scrollbars=no, resizable=yes,location=no, status=yes');\r\n}\r\n\r\n</script>\r\n</head>\r\n\r\n<body class=\"";
echo "bodycolor\" topmargin=\"5\">\r\n";
$connection = openconnection( );
$query = " \r\n\t\t\tSELECT oj.*, oa.* ,op.*  FROM officeitem_joinstoreroom as oj, officeitem_appellation as oa , provider as op \r\n\t\t\tWHERE 1 AND (oj.PROVIDER_ID = op.PROVIDER_ID AND oj.APPELLATION_ID = oa.APPELLATION_ID)  ";
$where_str = "";
if ( $_REQUEST['appellation'] != NULL )
{
	$where_str .= " AND oa.APPELLATION = '".$_REQUEST['appellation']."' ";
}
if ( $_REQUEST['price'] != NULL )
{
	$where_str .= "and oj.PRICE >= '".$_REQUEST['price']."' ";
}
if ( $_REQUEST['price2'] != NULL )
{
	$where_str .= "and oj.PRICE <= '".$_REQUEST['price2']."' ";
}
if ( $_REQUEST['join_date_start'] != NULL )
{
	$where_str .= "and to_days(date_format(oj.JOIN_DATE,'%Y-%m-%d')) >= to_days('".$_REQUEST['join_date_start']."') ";
}
if ( $_REQUEST['join_date_end'] != NULL )
{
	$where_str .= "and to_days(date_format(oj.JOIN_DATE,'%Y-%m-%d')) <= to_days('".$_REQUEST['join_date_end']."') ";
}
if ( $_REQUEST['bill'] != NULL )
{
	$where_str .= "and oj.BILL LIKE '%".$_REQUEST['bill']."%' ";
}
if ( $_REQUEST['provider_name'] != NULL )
{
	$where_str .= "and op.PROVIDER_NAME  ='".$_REQUEST['provider_name']."'";
}
$query .= $where_str;
$cursor5 = exequery( $connection, $query );
while ( $row5 = mysql_fetch_array( $cursor5 ) )
{
	$join_amount5 = $row5['JOIN_AMOUNT'];
	$money5 = $row5['MONEY'];
	$sum_join_amount += $join_amount5;
	$sum_money += $money5;
}
switch ( $_REQUEST['order'] )
{
case "appellation_id" :
	$query .= " order by oj.APPELLATION_ID";
	break;
case "join_amount" :
	$query .= " order by oj.JOIN_AMOUNT";
	break;
case "price" :
	$query .= " order by oj.PRICE";
	break;
case "operator" :
	$query .= " order by oj.OPERATOR";
	break;
case "join_date" :
	$query .= " order by oj.JOIN_DATE";
	break;
case "bill" :
	$query .= " order by oj.BILL";
	break;
case "money" :
	$query .= " order by oj.MONEY";
	break;
case "provider_name" :
	$query .= " order by op.PROVIDER_NAME";
	break;
default :
	$query .= " order by oj.STOREROOM_ID";
	break;
}
$query .= $_REQUEST['sens'] ? " DESC" : " ASC";
$query = page( $query, 15 );
$cursor = exequery( $connection, $query );
$count = 0;
echo "<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\">\r\n\t<tr class=\"tablehead1\">\r\n\t\t<td><img src=\"/images/manage/news.gif\" align=\"absmiddle\">入库单管理</td>\r\n\t</tr>\r\n\t<tr class=\"tablehead2\">\r\n\t\t<td><BUTTON class=btn onClick=\"javascript:location='add.php';\"><table><tr valign=top ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">新增入库单</span></td></tr></table></BUTTON> <BUTTON class=btn onClick=\"javscript:location='search.php';\"><table><tr valign=top ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">入库单查询</span></td></tr></table></BUTTON> ";
echo "<s";
echo "pan id='validate' name='validate'></span> <BUTTON class=btn onClick=\"javscript:history.back();\"><table><tr valign=top ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">返回</span></td></tr></table></BUTTON></td>\r\n\t</tr>\r\n</table>\r\n<br>\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"5\" class=\"small\">\r\n";
while ( $row = mysql_fetch_array( $cursor ) )
{
	++$count;
	$storeroom_id = $row['STOREROOM_ID'];
	$join_date = $row['JOIN_DATE'];
	$provider_id = $row['PROVIDER_ID'];
	$bill = $row['BILL'];
	$appellation_id = $row['APPELLATION_ID'];
	$price = $row['PRICE'];
	$join_amount = $row['JOIN_AMOUNT'];
	$money = $row['MONEY'];
	$storeroom_stockpile = $row['STOREROOM_STOCKPILE'];
	$operator = $row['OPERATOR'];
	$join_appellation = $row['JOIN_APPELLATION'];
	$join_appellation_sort = $row['JOIN_APPELLATION_SORT'];
	$provider_name = $row['PROVIDER_NAME'];
	$date = explode( " ", $join_date );
	$query2 = "\r\n\t\tSELECT oa.APPELLATION, os.SORT, oa.SPEC \r\n\t\tFROM officeitem_appellation as oa, officeitem_sort as os \r\n\t\tWHERE oa.APPELLATION_ID=".$appellation_id." && os.SORT_ID=oa.SORT_ID \r\n\t\t";
	$cursor2 = exequery( $connection, $query2 );
	if ( $row2 = mysql_fetch_row( $cursor2 ) )
	{
		$appellation = $row2[0];
		$sort = $row2[1];
		$spec = $row2[2];
	}
	$query3 = "SELECT USER_NAME FROM user WHERE USER_ID='".$operator."'";
	$cursor3 = exequery( $connection, $query3 );
	if ( $row3 = mysql_fetch_row( $cursor3 ) )
	{
		$user_name = $row3[0];
	}
	if ( $count % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "\t<tr class=\"";
	echo $TableLine;
	echo "\">\r\n\t\t<td><input type=\"checkbox\" onclick=\"select_stay()\" name=\"box\" id=\"box\" value=\"";
	echo $sort;
	echo ",";
	echo $appellation;
	echo ",";
	echo $spec;
	echo ",";
	echo $join_amount;
	echo ",";
	echo $price;
	echo ",";
	echo $money;
	echo ",";
	echo $user_name;
	echo ",";
	echo $date[0];
	echo ",";
	echo $bill;
	echo ",";
	echo $provider_name;
	echo "\"></td>\r\n\t\t<td>";
	echo $sort;
	echo "</td>\r\n\t\t<td>";
	echo $appellation;
	echo "</td>\r\n\t\t<td>";
	echo $spec;
	echo "</td>\r\n\t\t<td>";
	echo $join_amount;
	echo "</td>\r\n\t\t<td>";
	echo $price;
	echo "</td>\r\n\t\t<td>";
	echo $money;
	echo "</td>\r\n\t\t<td>";
	echo $user_name;
	echo "</td>\r\n\t\t<td>";
	echo $date[0];
	echo "</td>\r\n\t\t<td>";
	echo $bill;
	echo "</td>\r\n\t\t<td>";
	echo $provider_name;
	echo "</td>\r\n\r\n\t\t<td><a href=\"#\" onclick=\"bill_detail(";
	echo $storeroom_id;
	echo ");\">详情</a> <a href=\"#\" onClick=\"javascript:exports('";
	echo $sort;
	echo "','";
	echo $appellation;
	echo "','";
	echo $spec;
	echo "','";
	echo $join_amount;
	echo "','";
	echo $price;
	echo "','";
	echo $money;
	echo "','";
	echo $user_name;
	echo "','";
12 下一页
⌨️ 快捷键说明

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