📄 index.php

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

function getaffiretypestr( $n )
{
	switch ( $n )
	{
	case 2 :
		$str = "每日";
		break;
	case 3 :
		$str = "每周";
		break;
	case 4 :
		$str = "每月";
		break;
	case 5 :
		$str = "每年";
		break;
	default :
		$str = "每天";
	}
	return $str;
}

function getdatestr( $type, $n )
{
	if ( $type == 3 )
	{
		switch ( $n )
		{
		case 0 :
			$str = "每日";
			break;
		case 1 :
			$str = "周一";
			break;
		case 2 :
			$str = "周二";
			break;
		case 3 :
			$str = "周三";
			break;
		case 4 :
			$str = "周四";
			break;
		case 5 :
			$str = "周五";
			break;
		case 6 :
			$str = "周六";
			break;
		default :
			$str = "周日";
		}
	}
	if ( $type == 4 )
	{
		$str = $n."号";
	}
	if ( $type == 5 )
	{
		$str = date( "n月j号", strtotime( "2006-".$n ) );
	}
	return $str;
}

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/function_page_01.php" );
if ( !isset( $_REQUEST['desc'] ) )
{
	$desc = 0;
}
if ( !isset( $_REQUEST['tablecode'] ) )
{
	$tablecode = "begindate";
}
$connection = openconnection( );
$array_table_code['0'] = "begindate";
$array_table_code['1'] = "type";
$array_table_code['2'] = "reminddate";
$array_table_code['3'] = "remindtime";
$array_table_code['4'] = "content";
$array_table_code['5'] = "option";
echo "<s";
echo "cript>\r\n//定义排序的字段\r\narrayTableName = new Array();\r\narrayTableName[0] = '起始时间';\r\narrayTableName[1] = '提醒类型';\r\narrayTableName[2] = '提醒日期';\r\narrayTableName[3] = '提醒时间';\r\narrayTableName[4] = '内容';\r\narrayTableName[5] = '操作';\r\n\r\narrayTableCode = new Array();\r\narrayTableCode[0]= 'begindate';\r\narrayTableCode[1]= 'type';\r\narrayTableCode[2]= 'reminddate';\r\narrayTableCode[3]= 'remin";
echo "dtime';\r\narrayTableCode[4]= 'content';\r\narrayTableCode[5]= 'option';\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  window.showModalDialog(\"/inc/calendar.php?FIELDNAME=\"+fieldname,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:205px;d";
echo "ialogTop:\"+mytop+\"px;dialogLeft:\"+myleft+\"px\");\r\n}\r\n\r\nfunction CheckDate(pFMT,pDate,pShowMsg) \r\n{ \r\n\tvar ResultOK = null \r\n\t\r\n\t\r\n\tvar RegDateDot = /\\d{4}\\.{1}\\d{1,2}\\.{1}\\d{1,2}/ \r\n\tvar RegDateLine = /\\d{4}-{1}\\d{1,2}-{1}\\d{1,2}/ \r\n\t\r\n\tswitch (pFMT) \r\n\t{ \r\n\t\tcase 1: //. \r\n\t\t\tResultOK = RegDateDot.test(pDate) \r\n\t\t\tbreak \r\n\t\tcase 2: //- \r\n\t\t\tResultOK = RegDateLine.test(pDate) \r\n\t\t\tbreak \r\n\t\tdefault:";
echo " //. \r\n\t\t\tResultOK = RegDateDot.test(pDate) \r\n\t\t\tbreak \r\n\t}\r\n\tif(!ResultOK) \r\n\t{ \r\n\t   if(pShowMsg) alert(\"无效日期：日期格式错误！\") \r\n\t   return false \r\n\t}\r\n\t\r\n\tvar mYear = 0,mMonth = 0,mDay = 0 \r\n\tvar iPos1 = 0,iPos2 = 0 \r\n\tvar sDate = pDate.toString() \r\n\tvar mSepChar = ((pFMT == 1) ? \".\":\"-\") \r\n\t\r\n\t\r\n\tvar MonthDays = new Array(31,31,28,31,30,31,30,31,31,30,31,30,31) \r\n\t\r\n\t\r\n\tiPos1 = sDate.inde";
echo "xOf(mSepChar)\r\n\tiPos2 = sDate.indexOf(mSepChar,iPos1+1) \r\n\tmYear = sDate.substring(0,iPos1) \r\n\tmMonth = sDate.substring(iPos1+1,iPos2) \r\n\tmDay = sDate.substr(iPos2+1) \r\n\t\r\n\tif(mYear <= 0 || mYear > 9999) \r\n\t{ \r\n\t\tif(pShowMsg) alert(\"无效日期：年份过小或者过大，超出限制 (1-9999)！\") \r\n\t\treturn false \r\n\t}\r\n\t//mMonth = parseInt(mMonth);\r\n\tif(mMonth <= '0' || mMonth > '12') \r\n\t{ \r\n\t\tif(pShowMsg) alert(\"";
echo "无效日期：没有这个月份！\") \r\n\t\treturn false \r\n\t} \r\n\t\r\n\t\r\n\tvar RightDay = 0 \r\n\tif(mMonth == 2) \r\n\t\tRightDay = (((mYear%4 == 0) && (mYear%100 != 0) || (mYear%400 == 0))? 29: 28) \r\n\telse {\r\n\t\tRightDay = MonthDays[mMonth];\r\n\t}\r\n\t\r\n\tif(mDay <= 0 || mDay > RightDay) \r\n\t{ \r\n\t\tif(pShowMsg) alert(\"无效日期：该月没有这天！\") \r\n\t\treturn false \r\n\t} \r\n\t\r\n\t\r\n\treturn true \r\n} \r\n\r\n\r\nfunction CheckForm(){\r\n\tvar aff";
echo "time = document.getElementById('aff_time').value;\r\n\tif(afftime!=''){\r\n\tvar aff_h = afftime.substr(0,2);\r\n\tvar aff_i = afftime.substr(3,2);\r\n\tdocument.getElementById('s_aff_time_h').value = aff_h;\r\n\tdocument.getElementById('s_aff_time_i').value = aff_i;\r\n\t}\r\n\ts_date = document.formsearch.s_start_date.value;\r\n    if (s_date != ''){\r\n\t\tif (!CheckDate(2,s_date,true) ){\r\n\t\t\talert('起始日期不正确!');\r\n\t";
echo "\t\treturn false;\r\n\t\t}\r\n\t}\r\n\t\r\n\treturn true;\t\r\n}\r\n\r\n\r\n</script>\r\n\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 language=javascript src=\"/inc/calendar/calendar.js\"></SCRIPT>\r\n";
echo "<S";
echo "CRIPT language=javascript src=\"/inc/calendar/time.js\"></SCRIPT>\r\n";
echo "<S";
echo "CRIPT language=javascript src=\"/inc/common.js\"></SCRIPT>\r\n";
echo "<s";
echo "cript>\r\nfunction delete_affair(AFF_ID)\r\n{\r\n msg='确认要删除该事务么？';\r\n if(window.confirm(msg))\r\n {\r\n  URL=\"delete.php?AFF_ID=\" + AFF_ID;\r\n  window.location=URL;\r\n }\r\n}\r\n\r\nfunction my_note(AFF_ID)\r\n{\r\n  my_left=document.body.scrollLeft+event.clientX-event.offsetX-50;\r\n  my_top=document.body.scrollTop+event.clientY-event.offsetY+150;\r\n\r\n  window.open(\"note.php?AFF_ID=\"+AFF_ID,\"note_win\"+AFF_ID,\"h";
echo "eight=170,width=250,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=\"+ my_top +\",left=\"+ my_left +\",resizable=no\");\r\n}\r\n\r\n</script>\r\n";
echo "<s";
echo "cript>\r\nvar menu_id=0;\r\n\r\nfunction setPointer(theRow, thePointerColor,menu_id_over)\r\n{\r\n  if(menu_id!=menu_id_over)\r\n     theRow.bgColor = thePointerColor;\r\n}\r\n\r\nfunction view_menu1()\r\n{\r\n  \r\n   location=\"../arrange\";\r\n   menu_id=1;\r\n   \r\n}\r\n\r\nfunction view_menu2()\r\n{\r\n   location=\"../affair\";\r\n   menu_id=2;\r\n   \r\n}\r\nfunction submitForm(){\r\n  if (CheckForm()){\r\n\t  formsearch.submit();\r\n  }\r\n}\r\n</sc";
echo "ript>\r\n";
echo "<s";
echo "tyle type=\"text/css\">\r\n<!--\r\nA.deschead:link{text-decoration:none;color:#000000; font-size:12px;font-weight:fold;}\r\nA.deschead:visited{text-decoration:none;color:#000000; font-size:12px;font-weight:fold;color:0000FF;}\r\nA.deschead:active{text-decoration:none; color:#000000; font-size:12px;font-weight:fold;}\r\nA.deschead:hover{text-decoration:none;color:#FF0000;font-size:12px;font-weight:fold;}\r\n-->\r\n";
echo "</style>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\"  cellpadding=\"0\">\r\n   <tr class=\"tablehead1\">\r\n    <td ><img src=\"/images/menu/calendar.gif\" align=\"absmiddle\"> 日常事务    </td>\r\n  </tr>\r\n  <tr class=\"tablehead2\">\r\n    <td>\r\n <img src=\"/images/button/search_1.gif\" border=\"0\" title=\"日常事务\" onClick=\"submitForm()\" style=\"cursor:hand\">  <a href=\"new\"><img";
echo " src=\"/images/button/setaffair.gif\" border=\"0\" title=\"新建日常事务\"></a>\r\n  <a href=\"#\" onClick=\"view_menu1()\"></a>\r\n  <a href=\"#\" onClick=\"view_menu2()\"></a>\r\n  </td>\r\n  </tr>\r\n</table>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"5\" >\r\n  <form name=\"formsearch\" action=\"";
echo $_SERVER['PHP_SELF'];
echo "\" method=\"get\" onSubmit=\"return CheckForm();\">\r\n    <tr class=\"Tableline2\">\r\n      <td width=\"8%\">开始日期</td>\r\n      <td width=\"16%\">\r\n\t  <input class='Wdate' type=\"text\" name=\"s_start_date\" id=\"s_start_date\" value=\"";
echo $_REQUEST[s_start_date];
echo "\" size=\"12\" maxlength=\"10\" onclick=\"popUpCalendar(document.formsearch,document.formsearch.s_start_date,'yyyy-mm-dd')\"/>\r\n\t  </td>\r\n      <td width=\"8%\">提醒时间</td>\r\n      <td>\r\n\t   <input class=\"Wtime\" type=\"text\" name=\"aff_time\" id=\"aff_time\" value='' size=\"12\" \r\n\t\tonclick=\"new CallTime(null,null,0,0,null,null).show(this)\"/>\r\n\r\n\t   <input type='hidden' value='' id='s_aff_time_h' name='s_aff_time_h'>\r";
echo "\n\t   <input type='hidden' value='' id='s_aff_time_i' name='s_aff_time_i'>\r\n\t  </td>\r\n    </tr>\r\n    <tr class=\"Tableline2\">\r\n      <td>提醒类型</td>\r\n      <td>";
echo "<s";
echo "elect name=\"s_aff_type\">\r\n        <option value=\"\" ";
if ( $_REQUEST[s_aff_type] == "" )
{
	echo "selected";
}
echo ">所有类型</option>\r\n        <option value=\"2\" ";
if ( $_REQUEST[s_aff_type] == 2 )
{
	echo "selected";
}
echo ">按日</option>\r\n        <option value=\"3\" ";
if ( $_REQUEST[s_aff_type] == 3 )
{
	echo "selected";
}
echo ">按周</option>\r\n        <option value=\"4\" ";
if ( $_REQUEST[s_aff_type] == 4 )
{
	echo "selected";
}
echo ">按月</option>\r\n        <option value=\"5\" ";
if ( $_REQUEST[s_aff_type] == 5 )
{
	echo "selected";
}
echo ">按年</option>\r\n      </select></td>\r\n      <td>事务内容</td>\r\n      <td colspan=\"2\"><input name=\"keyword\" type=\"text\" id=\"keyword\" size=\"15\" value=\"";
echo $_REQUEST[keyword];
echo "\"></td>\r\n    </tr>\r\n  </form>\r\n</table>\r\n<br>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"5\" id=\"idTable\">\r\n  <tr class=\"tablehead1\">\r\n    <td width=\"20%\">起始时间</td>\r\n    <td width=\"10%\">提醒类型</td>\r\n    <td width=\"10%\">提醒日期</td>\r\n    <td width=\"10%\">提醒时间</td>\r\n    <td>内容</td>\r\n    <td width=\"10%\">操作</td>\r\n  </tr>\r\n  ";
$sql = "\r\n\t           SELECT * FROM affair \r\n\t\t\t       WHERE USER_ID='".$_SESSION['LOGIN_USER_ID']."' \r\n\t\t\t   ";
if ( $s_start_date != "" )
{
	$sql .= " AND TO_DAYS(BEGIN_TIME)>=TO_DAYS('".$s_start_date."')";
}
if ( $s_aff_type != "" )
{
	$sql .= " AND TYPE='".$s_aff_type."'";
}
if ( $s_aff_time_h != "" )
{
	if ( $s_aff_time_h < 10 )
	{
		$s_aff_time_h = "0".$s_aff_time_h;
	}
	else
	{
		$s_aff_time_h = $s_aff_time_h;
	}
	$sql .= " AND DATE_FORMAT(REMIND_TIME,'%H') like '%".$s_aff_time_h."%'";
}
if ( $s_aff_time_i != "" )
{
	if ( $s_aff_time_i < 10 )
	{
		$s_aff_time_i = "0".$s_aff_time_i;
	}
	else
	{
		$s_aff_time_i = $s_aff_time_i;
	}
	$sql .= " AND DATE_FORMAT(REMIND_TIME,'%i') like '%".$s_aff_time_i."%'";
}
if ( $keyword != "" )
{
	$sql .= " AND CONTENT LIKE '%".$keyword."%'";
}
$sql .= " ORDER BY ";
switch ( $tablecode )
{
case "begindate" :
	$sql .= " DATE_FORMAT(BEGIN_TIME,'%Y-%m-%d') ";
	break;
case "type" :
	$sql .= " TYPE ";
	break;
case "reminddate" :
	$sql .= " REMIND_DATE ";
	break;
case "remindtime" :
	$sql .= " REMIND_TIME ";
	break;
case "content" :
	$sql .= " CONTENT ";
	break;
default :
	$sql .= " DATE_FORMAT(BEGIN_TIME,'%Y-%m-%d') ";
}
$sql .= $desc ? " ASC" : " DESC";
$sql = page( $sql, 15 );
$rs = exequery( $connection, $sql );
$c_count = 0;
while ( $row = mysql_fetch_array( $rs ) )
{
	++$c_count;
	$aff_id = $row['AFF_ID'];
	$begin_time = $row['BEGIN_TIME'];
	$type = $row['TYPE'];
	$remind_date = $row['REMIND_DATE'];
	$remind_date_str = getdatestr( $type, $remind_date );
	$remind_time = $row['REMIND_TIME'];
	$type_str = getaffiretypestr( $type );
	$content = substrgb( $row['CONTENT'], 40, "..." );
	if ( $c_count % 2 == 1 )
	{
		$trclass = "tableline2";
	}
	else
	{
		$trclass = "tableline1";
	}
	echo "  <tr class=\"";
	echo $trclass;
	echo "\">\r\n    <td>";
	echo $begin_time;
	echo "</td>\r\n    <td>";
	echo $type_str;
	echo "</td>\r\n    <td>";
	echo $remind_date_str;
	echo "</td>\r\n    <td>";
	echo $remind_time;
	echo "</td>\r\n    <td><a href=\"#\" onClick=\"my_note(";
	echo $aff_id;
	echo ");\">\r\n      ";
	echo $content;
	echo "    </a></td>\r\n    <td><a href=\"modify.php?AFF_ID=";
	echo $aff_id;
	echo "\">修改</a>   <a href=\"javascript:delete_affair(";
	echo $aff_id;
	echo ");\">删除</a></td>\r\n  </tr>\r\n  ";
}
echo "</table>\r\n<table width=\"100%\"  border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n  <tr class=\"TableLine2\">\r\n    <td width=\"90%\" align=\"right\">";
disp( "keyword=".$_REQUEST['keyword']."&orderbyname=".$_REQUEST['orderbyname']."&orderbydesc=".$_REQUEST['orderbydesc'] );
echo "</td>\r\n    <td align=\"right\">&nbsp;</td>\r\n  </tr>\r\n</table>\r\n</body>\r\n</html>\r\n";
echo "<s";
echo "cript>\r\n//imgtext.innerHTML = \"<img scr='/images/arrow_down.gif'>\";\r\nvar tableDesc,imgSRC,arrayTabelName;\r\ntableID = \"idTable\";\r\n\r\ntableDesc = ";
echo $desc;
echo ";\r\nif (tableDesc == 1){\r\n   imgSRC = \"/images/arrow_up.gif\";\r\n}\r\nelse{\r\n   imgSRC = \"/images/arrow_down.gif\";\r\n}\r\n\r\n";
$key = array_search( $tablecode, $array_table_code );
echo "\r\ncellsKey = ";
echo $key;
echo ";\r\n\r\nfor (var i=0;i";
echo "<";
echo count( $array_table_code );
echo ";i++){\r\n   var str = \"\";\r\n   var tableName = \"\";\r\n   var tableCode = \"\";\r\n   var linkHref = '';\r\n   var imgstr = \"\";\r\n   \r\n   tableName = arrayTableName[i];\r\n   tableCode = arrayTableCode[i];\r\n   if (cellsKey == i){\r\n       imgstr = \"<img src='\"+imgSRC+\"'>\";\r\n\t   strdesc = ";
echo $_REQUEST['desc'] ? 0 : 1;
echo "   }\r\n   else{\r\n       strdesc = 1;\r\n   }  \r\n   \r\n   linkHref = \"<a class='deschead' href='";
echo $_SERVER['PHP_SELF'];
echo "?desc=\"+strdesc+\"&tablecode=\"+tableCode+\"&s_start_date=";
echo $s_start_date;
echo "&s_aff_type=";
echo $s_aff_type;
echo "&s_aff_time_h=";
echo $s_aff_time_h;
echo "&s_aff_time_i=";
echo $s_aff_time_i;
echo "&keyword=";
echo $keyword;
echo "' >\"+tableName+\"</a>\"; \r\n   \r\n   str = linkHref+imgstr;\r\n   \r\n   if (i < 5){\r\n\t  document.getElementById(tableID).rows[0].cells[i].innerHTML = str;\r\n   }\r\n}\r\n</script>";
?>
⌨️ 快捷键说明

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