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

📄 flow_report_detail_search.php

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

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_html.php" );
$sql = "SELECT * FROM flow_type WHERE FLOW_ID=".$_REQUEST['FLOW_ID'];
$rs = exequery( $connection, $sql );
$row = mysql_fetch_array( $rs );
$flow_name = $row['FLOW_NAME'];
echo "<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 src=\"/inc/prototype.js\"></script>\r\n";
echo "<s";
echo "cript src=\"/inc/common.js\"></script>\r\n";
echo "<s";
echo "cript src=\"/inc/follow.js\"></script>\r\n\r\n";
echo "<s";
echo "tyle>\r\nbody{\r\n\tmargin-left: 0px;\r\n\tmargin-top: 0px;\r\n\tmargin-right: 0px;\r\n\tmargin-bottom: 0px;\r\n\tpadding-left:10px\r\n}\r\n\r\n.container{\r\n\tborder:1px solid #E0E0E0;\r\n\twidth:80px;\r\n\theight:20px;\r\n\tvertical-align:middle;\r\n\twhite-space:nowrap;\r\n\tdisplay:inline;\r\n\ttext-align:center;\r\n\tpadding:4px;\r\n\tcolor:#666666;\r\n\tfont-weight:bold;\r\n}\r\n#tmpdivid{\r\n\twidth:5px;\r\n\twhite-space:nowrap;\r\n\tdisplay:inline;\r\n}\r\n";
echo "</style>\r\n\r\n";
echo "<s";
echo "cript>\r\n\r\nfunction loadingDay(){\r\n\r\n\turl = 'option_day.php';\r\n\tvar objDivID = document.getElementById('daystr');\r\n\tvar TIME_YEAR = document.getElementById('TIME_YEAR').value;\r\n\tvar TIME_MONTH = document.getElementById('TIME_MONTH').value;\r\n\tpar = \"TIME_YEAR=\"+TIME_YEAR+\"&TIME_MONTH=\"+TIME_MONTH;\r\n\r\n\tvar objOtext = document.getElementById('otext');\r\n\tobjOtext.innerHTML = \"日加载中...\";\r\n\r\n\tvar save";
echo "Gimg = {\r\n\t\tonCreate: function(){\r\n\t\t\tElement.show('divsave');\r\n\t\t},\r\n\t\tonComplete: function() {\r\n\t\t\tif(Ajax.activeRequestCount == 0){\r\n\t\t\t\tElement.hide('divsave');\r\n\t\t\t}\r\n\t\t}\r\n\t};\r\n\tAjax.Responders.register(saveGimg);\t\r\n\t\r\n\tqueryString = par;\r\n\tnew Ajax.Request\r\n\t(\r\n\t\turl,\r\n\t\t{\r\n\t\t\tmethod: \"post\",\t\r\n\t\t\tonSuccess : function(resp)\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\tobjDivID.innerHTML = resp.responseText;\r\n\t\t\t\t\t\t\t\r\n\t";
echo "\t\t\t\t\t},\r\n\t\t\tonFailure : function()\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\talert(url);\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t},\r\n\t\t\tparameters : queryString\r\n\t\t}\r\n\t);\r\n\r\n}\r\n\r\nfunction loadingImg(divid,url,par){\r\n\tvar TIME_YEAR = document.getElementById('TIME_YEAR').value;\r\n\tvar TIME_MONTH = document.getElementById('TIME_MONTH').value;\r\n\tvar TIME_DAY = document.getElementById('TIME_DAY').value;\r\n\tpar = 'REPORT_ID=";
echo $_REQUEST['REPORT_ID'];
echo "&REPORT_TYPE=day&TIME_YEAR='+TIME_YEAR+\"&TIME_MONTH=\"+TIME_MONTH+\"&TIME_DAY=\"+TIME_DAY+'&FLOW_ID=";
echo $_REQUEST['FLOW_ID'];
echo "';\r\n\tvar objDivID = document.getElementById(divid);\r\n\r\n\tobjDivID.src = url+'?'+par;\r\n\r\n\tvar objOtext = document.getElementById('otext');\r\n\tobjOtext.innerHTML = \"图形加载中...\";\r\n\r\n\tvar saveGimg = {\r\n\t\tonCreate: function(){\r\n\t\t\tElement.show('divsave');\r\n\t\t},\r\n\t\tonComplete: function() {\r\n\t\t\tif(Ajax.activeRequestCount == 0){\r\n\t\t\t\tElement.hide('divsave');\r\n\t\t\t}\r\n\t\t}\r\n\t};\r\n\tAjax.Responders.register(sav";
echo "eGimg);\t\r\n\t\r\n\r\n\r\n\tqueryString = par;\r\n\tnew Ajax.Request\r\n\t(\r\n\t\turl,\r\n\t\t{\r\n\t\t\tmethod: \"post\",\t\r\n\t\t\tonSuccess : function(resp)\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\t//alert(objDivID.src);\r\n\t\t\t\t\t\t\t//alert(objDivID.src);\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t},\r\n\t\t\tonFailure : function()\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\talert(url);\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t},\r\n\t\t\tparameters : queryString\r\n\t\t}\r\n\t);\r\n\r\n}\r\n\r\nfunction refImgReport(){\r\n\tvar TIME_YEAR = document.getElementB";
echo "yId('TIME_YEAR').value;\r\n\tvar TIME_MONTH = document.getElementById('TIME_MONTH').value;\r\n\tvar TIME_DAY = document.getElementById('TIME_DAY').value;\r\n\tloadingImg('imgimgyear','/general/report/workflow/img_line_year.php','REPORT_ID=";
echo $_REQUEST['REPORT_ID'];
echo "&REPORT_TYPE=day&TIME_YEAR='+TIME_YEAR+\"&TIME_MONTH=\"+TIME_MONTH+\"&TIME_DAY=\"+TIME_DAY+'&FLOW_ID=";
echo $_REQUEST['FLOW_ID'];
echo "');\r\n\tloadingImg('imgimgbaryear','/general/report/workflow/img_bar_year.php','REPORT_ID=";
echo $_REQUEST['REPORT_ID'];
echo "&REPORT_TYPE=day&TIME_YEAR='+TIME_YEAR+\"&TIME_MONTH=\"+TIME_MONTH+\"&TIME_DAY=\"+TIME_DAY+'&FLOW_ID=";
echo $_REQUEST['FLOW_ID'];
echo "');\r\n\tloadingImg('imgimgpieyear','/general/report/workflow/img_pie_year.php','REPORT_ID=";
echo $_REQUEST['REPORT_ID'];
echo "&REPORT_TYPE=day&TIME_YEAR='+TIME_YEAR+\"&TIME_MONTH=\"+TIME_MONTH+\"&TIME_DAY=\"+TIME_DAY+'&FLOW_ID=";
echo $_REQUEST['FLOW_ID'];
echo "');\r\n\r\n}\r\n\r\nfunction openWin(imgurl,par){\r\n\tvar TIME_YEAR = document.getElementById('TIME_YEAR').value;\r\n\tvar TIME_MONTH = document.getElementById('TIME_MONTH').value;\r\n\tvar TIME_DAY = document.getElementById('TIME_DAY').value;\r\n\tpar = 'REPORT_ID=";
echo $_REQUEST['REPORT_ID'];
echo "&REPORT_TYPE=day&TIME_YEAR='+TIME_YEAR+\"&TIME_MONTH=\"+TIME_MONTH+\"&TIME_DAY=\"+TIME_DAY+'&FLOW_ID=";
echo $_REQUEST['FLOW_ID'];
echo "';\r\n\r\n\tURL=\"img_resize.php?imgurl=\"+imgurl+\"&\"+par;\r\n\tmyleft=(screen.availWidth-500)/2;\r\n\twindow.open(URL,\"\",\"height=500,width=850,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n}\r\n\r\nfunction downloadReport(){\r\n\tvar TIME_YEAR = document.getElementById('TIME_YEAR').value;\r\n\tvar TIME_MONTH = document.getElementById('TIME_MONTH').value;\r\n\tvar TIME_";
echo "DAY = document.getElementById('TIME_DAY').value;\r\n\tTYPE_FILE = document.getElementById('TYPE_FILE').value;\r\n\tvar\tpar = 'REPORT_ID=";
echo $_REQUEST['REPORT_ID'];
echo "&REPORT_TYPE=day&TIME_YEAR='+TIME_YEAR+\"&TIME_MONTH=\"+TIME_MONTH+\"&TIME_DAY=\"+TIME_DAY+'&FLOW_ID=";
echo $_REQUEST['FLOW_ID'];
echo "';\r\n\t\r\n\tmyleft=(screen.availWidth-500)/2;\r\n\tif(TYPE_FILE == 'xls'){\r\n\t\tURL = \"excel.php?\"+par;\r\n\t\t\r\n\t}\r\n\tif(TYPE_FILE == \"html\"){\r\n\t\tURL = \"html.php?\"+par;\r\n\t\r\n\t}\r\n\tif(TYPE_FILE == \"csv\"){\r\n\t\tURL = \"csv.php?\"+par;\r\n\t\r\n\t}\r\n\twindow.open(URL,\"\",\"height=500,width=850,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n\t\r\n}\r\n\r\nfunction downloadReportDetai";
echo "l(){\r\n\tvar TIME_YEAR = document.getElementById('TIME_YEAR').value;\r\n\tvar TIME_MONTH = document.getElementById('TIME_MONTH').value;\r\n\tvar TIME_DAY = document.getElementById('TIME_DAY').value;\r\n\tvar\tpar = 'REPORT_ID=";
echo $_REQUEST['REPORT_ID'];
echo "&REPORT_TYPE=day&TIME_YEAR='+TIME_YEAR+\"&TIME_MONTH=\"+TIME_MONTH+\"&TIME_DAY=\"+TIME_DAY+'&FLOW_ID=";
echo $_REQUEST['FLOW_ID'];
echo "';\r\n\t\r\n\tmyleft=(screen.availWidth-500)/2;\r\n\tURL = \"report_download.php?\"+par;\r\n\twindow.open(URL,\"\",\"height=500,width=850,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n\t\r\n}\r\n\r\nfunction td_calendar(fieldname)\r\n{\r\n  myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;\r\n  mytop=document.body.scrollTop+event.clientY-event.offsetY+140;\r\n\r\n";
echo "  window.showModalDialog(\"/inc/calendar.php?FIELDNAME=\"+fieldname,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:205px;dialogTop:\"+mytop+\"px;dialogLeft:\"+myleft+\"px\");\r\n}\r\n\r\n\r\n</script>\r\n</head>\r\n<body >\r\n\r\n";
$requ = "REPORT_ID=".$_REQUEST['REPORT_ID']."&FLOW_ID=".$_REQUEST['FLOW_ID'];
echo "<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\">\r\n  <tr class=\"tablehead1\">\r\n    <td><img src=\"/images/workflow.gif\"  align=\"absmiddle\"> 流程报表 - ";
echo $flow_name;
echo "</td>\r\n  </tr>\r\n  <tr class=\"tablehead2\">\r\n    <td>\r\n\t<BUTTON class=btn onclick=\"location='flow_report_detail.php?";
echo $requ;
echo "'\"><table><tr valign=middle ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">年报表</span></td></tr></table></BUTTON> \r\n\t<BUTTON class=btn onclick=\"location='flow_report_detail_month.php?";
echo $requ;
echo "'\"><table><tr valign=middle ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">月报表</span></td></tr></table></BUTTON> \r\n\t<BUTTON class=btn onclick=\"location='flow_report_detail_week.php?";
echo $requ;
echo "'\"><table><tr valign=middle ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">周报表</span></td></tr></table></BUTTON> \r\n\t<BUTTON class=btn onclick=\"location='flow_report_detail_day.php?";
echo $requ;
echo "'\"><table><tr valign=middle ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">日报表</span></td></tr></table></BUTTON> \r\n\t<BUTTON class=btn onclick=\"location='flow_report_detail_search.php?";
echo $requ;
echo "'\"><table><tr valign=middle ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">查询报表</span></td></tr></table></BUTTON> \r\n\t<BUTTON class=btn onclick=\"location='report_list.php?FLOW_ID=";
echo $FLOW_ID;
echo "'\"><table><tr valign=middle ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">返回</span></td></tr></table></BUTTON> \r\n  </td>\r\n  </tr>\r\n</table>\r\n\r\n<hr width=\"95%\" height=\"1\" align=\"left\" color=\"#ffffff\">\r\n\r\n<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<form action=\"search_query.php\" method=\"get\" name=\"formsearch\">\r\n  <tr>\r\n    <td><table border=\"0\" width=\"100%\" cellpadding=\"5\" cellspacing=\"1\" align=\"center\" class=\"small\">\r\n    <tr>\r\n      <td nowrap";
echo " class=\"TableHead2\" colspan=\"3\" height=\"28\">流程基本信息</td>\r\n    </tr>      \r\n\t  \r\n\t  <tr>\r\n        <td nowrap class=\"TableLine2\" width=\"20%\">流程状态：</td>\r\n        <td class=\"TableLine1\">";
echo "<s";
echo "elect name=\"FLOW_STATUS\" class=\"SmallSelect\">\r\n            <option value=\"ALL\">所有</option>\r\n            <option value=\"1\">已完成</option>\r\n            <option value=\"0\">执行中</option>\r\n          </select>\r\n          <input type=\"hidden\" name=\"REPORT_ID\" value=\"";
echo $_REQUEST['REPORT_ID'];
echo "\">\r\n          <input type=\"hidden\" name=\"FLOW_ID\" value=\"";
echo $_REQUEST['FLOW_ID'];
echo "\"></td>\r\n      </tr>\r\n      <tr>\r\n        <td nowrap class=\"TableLine2\">创建人：</td>\r\n        <td nowrap class=\"TableLine1\">";
echo "<s";
echo "elect name=\"CREATE_USER\" class=\"SmallSelect\">\r\n            <option value=\"\">所有</option>\r\n\t\t\t";
$sql = "SELECT * FROM USER ORDER BY USER_NAME DESC";
$rs = exequery( $connection, $sql );
while ( $row = mysql_fetch_array( $rs ) )
{
	echo "\t\t\t<option value=\"";
	echo $row['USER_ID'];
	echo "\">";
	echo $row['USER_NAME'];
	echo "</option>\r\n\t\t\t";
}
echo "          </select>\r\n        </td>\r\n      </tr>\r\n      <tr>\r\n        <td nowrap class=\"TableLine2\">流程说明：</td>\r\n        <td nowrap class=\"TableLine1\"><input name=\"RUN_NAME\" type=\"text\" class=\"SmallInput\" id=\"RUN_NAME\" size=\"30\" maxlength=\"100\">\r\n        </td>\r\n      </tr>\r\n      <tr>\r\n        <td nowrap class=\"TableLine2\">流程文号：</td>\r\n        <td nowrap class=\"TableLine1\"><input name=\"RUN_SEQ\" type=\"text";
echo "\" class=\"SmallInput\" id=\"RUN_SEQ\" size=\"30\" maxlength=\"100\">\r\n        </td>\r\n      </tr>\r\n      <tr>\r\n        <td nowrap class=\"TableLine2\">日期范围：</td>\r\n        <td class=\"TableLine1\"><input name=\"PRCS_DATE1\" type=\"text\" class=\"SmallInput\" id=\"PRCS_DATE1\" size=\"10\">\r\n            <img src=\"/images/menu/calendar1.gif\" align=absmiddle border=\"0\" style=\"cursor:hand\" onClick=\"td_calendar('formsearch.PRCS_D";
echo "ATE1');\"> －\r\n          <input name=\"PRCS_DATE2\" type=\"text\" class=\"SmallInput\" id=\"PRCS_DATE2\" size=\"10\">\r\n            <img src=\"/images/menu/calendar1.gif\" align=absmiddle border=\"0\" style=\"cursor:hand\" onClick=\"td_calendar('formsearch.PRCS_DATE2');\"> 可只填一项 </td>\r\n      </tr>\r\n      <tr>\r\n        <td height=\"26\" nowrap class=\"TableLine2\">公共附件名称：</td>\r\n        <td nowrap class=\"TableLine1\"><in";
echo "put name=\"ATTACHMENT_NAME\" type=\"text\" class=\"SmallInput\" id=\"ATTACHMENT_NAME\" size=\"30\">\r\n        </td>\r\n      </tr>\r\n    </table>\r\n\r\n      ";
if ( $_REQUEST['FLOW_ID'] != "" )
{
	$sqlff = "SELECT * FROM flow_type WHERE FLOW_ID=".$_REQUEST['FLOW_ID'];
	$rsff = exequery( $connection, $sqlff );
	$rowff = mysql_fetch_array( $rsff );
	$FORM_ID = $rowff['FORM_ID'];
	$query = "SELECT * from FLOW_FORM_TYPE WHERE FORM_ID={$FORM_ID}";
	$cursor1 = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$FORM_NAME = $ROW['FORM_NAME'];
		$PRINT_MODEL = $ROW['PRINT_MODEL'];
	}
	echo "      <table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"5\" cellspacing=\"1\">\r\n\t\t<tr>\r\n\t\t  <td nowrap class=\"TableHead2\" colspan=\"3\" height=\"28\"> 表单数据信息（表单名称：";
	echo $FORM_NAME;
	echo "）\r\n\t\t  </td>\r\n\t\t</tr>\r\n        ";
12

⌨️ 快捷键说明

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