📄 print.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_html.php" );
include_once( "../prcs_role.php" );
if ( !run_role( $RUN_ID, 0 ) )
{
exit( );
}
echo "\r\n<html>\r\n<head>\r\n\r\n";
$connection = openconnection( );
$query = "SELECT * from FLOW_TYPE WHERE FLOW_ID={$FLOW_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FLOW_NAME = $ROW['FLOW_NAME'];
$FLOW_TYPE = $ROW['FLOW_TYPE'];
$FORM_ID = $ROW['FORM_ID'];
$FORM_TYPE = $ROW['FORM_TYPE'];
}
$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'];
}
$query = "SELECT * from FLOW_RUN_DATA WHERE RUN_ID={$RUN_ID} ORDER BY ITEM_ID";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$ITEM_ID = $ROW['ITEM_ID'];
$ITEM_DATA = $ROW['ITEM_DATA'];
$STR = "DATA_".$ITEM_ID;
$$STR = $ITEM_DATA;
}
$query = "SELECT * from FLOW_RUN WHERE RUN_ID={$RUN_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$RUN_NAME = $ROW['RUN_NAME'];
}
$query = "SELECT * from FLOW_RUN_PRCS where RUN_ID={$RUN_ID} and PRCS_ID=1";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_ID = $ROW['USER_ID'];
$PRCS_TIME1 = $ROW['PRCS_TIME'];
$PRCS_TIME1 = format_date( $PRCS_TIME1 );
}
echo "\r\n<title>";
echo $FORM_NAME;
echo " - 打印</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n";
echo "<s";
echo "tyle type=\"text/css\">\r\n<!--\r\n.title { font-family: \"宋体\"; font-size: 18pt; font-weight: bold}\r\n-->\r\n</style>\r\n\r\n";
echo "<s";
echo "cript>\r\nfunction myprint()\r\n{\r\n document.execCommand('Print');\r\n}\r\n</script>\r\n</head>\r\n\r\n<body>\r\n\r\n";
$PRINT_MODEL = str_replace( "#[表单]", "<b>{$FORM_NAME}</b>", $PRINT_MODEL );
$PRINT_MODEL = str_replace( "#[文号]", $RUN_NAME, $PRINT_MODEL );
$PRINT_MODEL = str_replace( "#[时间]", "日期：{$PRCS_TIME1}", $PRINT_MODEL );
$ELEMENT_ARRAY = html_element( $PRINT_MODEL );
$ITEM_ID_MAX = sizeof( $ELEMENT_ARRAY );
$ITEM_ID = 0;
$POS = 0;
$I = 0;
for ( ; $I < $ITEM_ID_MAX; ++$I )
{
$ELEMENT = $ELEMENT_ARRAY[$I];
$ENAME = get_attr( $ELEMENT, "NAME" );
$EVALUE = get_attr( $ELEMENT, "VALUE" );
$ECLASS = get_attr( $ELEMENT, "CLASS" );
if ( $ECLASS != "DATE" )
{
++$ITEM_ID;
}
$STR = "DATA_".$ITEM_ID;
$ITEM_VALUE = $$STR;
if ( $ECLASS == "DATE" )
{
$ITEM_VALUE = "";
}
else
{
if ( $ECLASS == "AUTO" && $ENAME == "SELECT" && $ITEM_VALUE != "" )
{
$EDATAFLD = get_attr( $ELEMENT, "DATAFLD" );
switch ( $EDATAFLD )
{
case "SYS_LIST_DEPT" :
$query_auto = "SELECT * from DEPARTMENT where DEPT_ID={$ITEM_VALUE}";
$cursor_auto = exequery( $connection, $query_auto );
if ( !( $ROW = mysql_fetch_array( $cursor_auto ) ) )
{
break;
}
$ITEM_VALUE = $ROW['DEPT_NAME'];
break;
case "SYS_LIST_PRIV" :
$query_auto = "SELECT * from USER_PRIV where USER_PRIV={$ITEM_VALUE}";
$cursor_auto = exequery( $connection, $query_auto );
if ( !( $ROW = mysql_fetch_array( $cursor_auto ) ) )
{
break;
}
$ITEM_VALUE = $ROW['PRIV_NAME'];
break;
case "SYS_LIST_USER" :
case "SYS_LIST_PRCSUSER1" :
case "SYS_LIST_PRCSUSER2" :
$query_auto = "SELECT * from USER where USER_ID='{$ITEM_VALUE}'";
$cursor_auto = exequery( $connection, $query_auto );
if ( !( $ROW = mysql_fetch_array( $cursor_auto ) ) )
{
break;
}
$ITEM_VALUE = $ROW['USER_NAME'];
break;
case "SYS_LIST_SQL" :
}
}
else
{
if ( $ECLASS == "AUTO" && $ITEM_VALUE == "{宏控件}" )
{
$ITEM_VALUE = "";
}
$ITEM_VALUE = str_replace( "<", "<", $ITEM_VALUE );
$ITEM_VALUE = str_replace( ">", ">", $ITEM_VALUE );
$ITEM_VALUE = stripslashes( $ITEM_VALUE );
$ITEM_VALUE = str_replace( chr( 10 ), "<br>", $ITEM_VALUE );
if ( $ENAME == "INPUT" && strstr( $ELEMENT, "type=checkbox" ) )
{
if ( $ITEM_VALUE == "on" )
{
$ITEM_VALUE = "<input type=checkbox checked onclick='this.checked=1;'>";
}
else
{
$ITEM_VALUE = "<input type=checkbox onclick='this.checked=0;'>";
}
}
}
}
$POS = strpos( $PRINT_MODEL, $ELEMENT, $POS );
$PRINT_MODEL = substr( $PRINT_MODEL, 0, $POS ).$ITEM_VALUE.substr( $PRINT_MODEL, $POS + strlen( $ELEMENT ) );
}
if ( strstr( $FLOW_VIEW, "1" ) )
{
echo $PRINT_MODEL;
}
$PRINT_FLAG = 1;
if ( strstr( $FLOW_VIEW, "2" ) )
{
echo "<br>";
include_once( "../personal_sign.php" );
}
if ( strstr( $FLOW_VIEW, "3" ) )
{
echo "<br>";
include_once( "../flow_view.php" );
}
echo "\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -