function 判断招生数据是否完成()
{
global $db;
return '';
exit;
if ($_GET['action'] == '' || $_GET['action'] == 'init_default') {
$sql = "select COUNT(*) AS NUM from edu_newstudent where 是否转移学籍 ='1'";
$rs = $db->Execute($sql);
if ($rs->fields['NUM'] > 0) {
page_css("在新生系统存在新生数据");
print_infor("在新生系统存在新生数据,请先处理完新生录取以及报到工作,转完成学籍,结束完新生工作以后,再来操作此模块");
exit;
}
}
}
ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
// display warnings and errors
error_reporting(E_WARNING | E_ERROR);
//######################教育组件-权限较验部分##########################
require_once("lib.inc.php");
//######################教育组件-权限较验部分##########################
$当前学期 = returntablefield("edu_xueqiexec","当前学期",'1',"学期名称");
page_css("课表上传导入");
if($_GET['action']=="") {
print "
<script language = \"JavaScript\">
function FormCheck()
{
if (document.form1.Exam_Content.value == \"\") {
alert(\"请你选择你要输入的课表文件!\");
return false;}
}</script>
";
<?php
require_once "lib.inc.php";
$GLOBAL_SESSION = returnsession();
require_once "systemprivateinc.php";
CheckSystemPrivate("后勤管理-固定资产-操作明细");
if ($_GET['action'] == "add_default_data") {
page_css('归还');
$资产编号 = $_POST['资产编号'];
$资产名称 = $_POST['资产名称'];
$借领人 = $_POST['借领人'];
if ($_POST['批准人'] != "") {
$_POST['单价'] = returntablefield("fixedasset", "资产编号", $资产编号, "单价");
$_POST['数量'] = returntablefield("fixedasset", "资产编号", $资产编号, "数量");
$_POST['金额'] = returntablefield("fixedasset", "资产编号", $资产编号, "金额");
$sql = "update fixedasset set 使用人员='',所属状态='资产已归还' where 资产编号='{$资产编号}'";
$db->Execute($sql);
} else {
$SYSTEM_SECOND = 1;
print_infor("批准人为空,您的操作没有执行成功!", $infor = '该参数新版本没有被使用', $return = "location='fixedasset_newai.php'", $indexto = 'fixedasset_newai.php');
exit;
}
}
$filetablename = 'fixedassettui';
require_once 'include.inc.php';
<?php
ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
error_reporting(E_WARNING | E_ERROR);
require_once 'lib.inc.php';
$GLOBAL_SESSION = returnsession();
addShortCutByDate("申请日期");
$SYSTEM_ADD_SQL = " and 录单员='" . $_SESSION['LOGIN_USER_ID'] . "'";
//$SYSTEM_PRINT_SQL = 1;
if ($_GET['action'] == "edit_default_data") {
page_css("佣金申请");
$单号 = $_POST['单号'];
$sql = "select * from crm_yongjin_sq where 单号='{$单号}'";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
if ($rs_a[0]['是否审核'] == 1 && 0) {
print "\n\t\t\t<div align=\"center\" title=\"审核记录管理\">\n\t\t\t<table class=\"MessageBox\" align=\"center\" width=\"650\"><tr><td class=\"msg info\">\n\t\t\t<div class=\"content\" style=\"font-size:12pt\"> 此项记录已经通过审核，系统禁止编辑操作.</div>\n\t\t\t</td></tr></table>\n\t\t\t<br>\n\t\t\t<div align=center>\n\t\t\t";
print "<input type=button value=\"返回\" class=\"SmallButton\" onClick=\"history.go(-2);\">\n\t\t\t</div>\n\t\t\t";
exit;
}
if ($rs_a[0]['是否作废'] == 1) {
print "\n\t\t\t<div align=\"center\" title=\"作废记录管理\">\n\t\t\t<table class=\"MessageBox\" align=\"center\" width=\"650\"><tr><td class=\"msg info\">\n\t\t\t<div class=\"content\" style=\"font-size:12pt\"> 此项记录已经作废，系统禁止操作.</div>\n\t\t\t</td></tr></table>\n\t\t\t<br>\n\t\t\t<div align=center>\n\t\t\t";
print "<input type=button value=\"返回\" class=\"SmallButton\" onClick=\"history.go(-2);\">\n\t\t\t</div>\n\t\t\t";
exit;
}
}
//数据表模型文件,对应Model目录下面的crm_yongjin_sq_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'crm_yongjin_sq';
$parse_filename = 'crm_yongjin_sq';
}
}
}
$sql = "SELECT " . $date_format . " as name,sum(b.lirun) as sum FROM sellplanmain a LEFT JOIN sellplanmain_detail b on b.mainrowid=a.billid WHERE a.user_flag>0 and a.createtime>='" . $start_time . "' and a.createtime<='" . $end_time . "' GROUP BY name";
//exit($sql);
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
foreach ($rs_a as $row) {
$list[$row['name']] = $row['sum'];
}
//print_r($list);exit;
?>
<html>
<head>
<?php
page_css("月度利润走势图");
?>
<SCRIPT src="../../Enginee/WdatePicker/WdatePicker.js"></SCRIPT>
</head>
<body class=bodycolor topMargin=5>
<table class=TableBlock align=center width=100%>
<thead>
<tr>
<td colspan="13">
<form action='' method="get">
<table width="100%" class="Small" border="0">
<thead>
<tr>
<td class='nowrap'>时间段： <input class="SmallInput" size="19" name="start_time" value="<?php
ClassroomTablePreview();
break;
case 'showTeacherTableInfor':
page_css2($IE_TITLE,"教师课表查询");
//条件判断
if($TeacherName=="") { print_infor("请选择教师!"); exit ;}
TeacherTablePreview();
break;
case 'showFreeTimeWeekTableInfor':
page_css($IE_TITLE,"空闲教室查询");
//条件判断
//if($TeacherName=="") { print_infor("请选择教师!"); exit ;}
FreeTimeWeekTablePreview();
break;
case 'showXueYuanInfor':
page_css($IE_TITLE,"学院课表查询");
//条件判断
//if($TeacherName=="") { print_infor("请选择教师!"); exit ;}
XueYuanPreview();
break;
case 'showXiInfor':
page_css2($IE_TITLE,$_SESSION['SUNSHINE_REGISTER_XI']."总课表查询");
//条件判断
//if($TeacherName=="") { print_infor("请选择教师!"); exit ;}
XiPreview();
break;
case 'showZhuanYeInfor':
page_css2($IE_TITLE,"专业总课表查询");
//条件判断
//if($TeacherName=="") { print_infor("请选择教师!"); exit ;}
ZhuanYePreview();
<?php
require_once "lib.inc.php";
$GLOBAL_SESSION = returnsession();
require_once "systemprivateinc.php";
CheckSystemPrivate("后勤管理-办公用品-操作明细");
if ($_GET['action'] == "add_default_data") {
page_css('办公用品');
$办公用品编号 = $_POST['办公用品编号'];
$办公用品名称 = $_POST['办公用品名称'];
$现在所属部门 = $_POST['现在所属部门'];
if ($_POST['批准人'] != "") {
$_POST['单价'] = returntablefield("officeproduct", "办公用品编号", $办公用品编号, "单价");
$_POST['数量'] = $_POST['退库数量'];
$_POST['金额'] = $_POST['单价'] * $_POST['数量'];
$sql = "update officeproduct set 库存管理=库存管理+" . $_POST['数量'] . " where 办公用品编号='{$办公用品编号}'";
$db->Execute($sql);
//print $sql."<BR>";exit;
} else {
$SYSTEM_SECOND = 1;
print_infor("批准人为空或现在所属部门为空,您的操作没有执行成功!", $infor = '该参数新版本没有被使用', $return = "location='officeproduct_newai.php'", $indexto = 'officeproduct_newai.php');
exit;
}
}
$filetablename = 'officeproducttui';
require_once 'include.inc.php';
<?php
ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
error_reporting(E_WARNING | E_ERROR);
require_once 'lib.inc.php';
$GLOBAL_SESSION = returnsession();
addShortCutByDate("申请日期");
if ($_GET['action'] == "edit_default_data") {
page_css("延迟付款");
if ($_POST['是否审核'] == 2 || $_POST['是否审核'] == 3) {
$_POST['审核日期'] = date("Y-m-d");
$_POST['审核人'] = $_SESSION['LOGIN_USER_ID'];
$备注 = $_POST['备注'];
//拆分字符串
$bz = substr($备注, 0, 7);
if ($bz != "<审核人") {
//$_POST['备注'] = "<审核人:".$审核人.">".$_POST['备注'];
}
}
if ($_POST['是否作废'] == '1') {
$_POST['作废日期'] = date("Y-m-d H:i:s");
$作废人 = $_SESSION['LOGIN_USER_ID'];
$_POST['备注'] = "<作废人：" . $作废人 . ">" . $_POST['备注'];
}
$单号 = $_POST['单号'];
$sql = "select 是否作废 from crm_yanchifukuan_sq where 单号='{$单号}'";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
if ($rs_a[0]['是否作废'] == 1) {
print "\n\t\t\t<div align=\"center\" title=\"作废记录管理\">\n\t\t\t<table class=\"MessageBox\" align=\"center\" width=\"650\"><tr><td class=\"msg info\">\n\t\t\t<div class=\"content\" style=\"font-size:12pt\"> 此项记录已经作废，系统禁止操作.</div>\n\t\t\t</td></tr></table>\n\t\t\t<br>\n\t\t\t<div align=center>\n\t\t\t";
<?php
require_once "lib.inc.php";
$GLOBAL_SESSION = returnsession();
page_css("报修信息统计");
$当前学期 = returntablefield('edu_xueqiexec', '当前学期', 1, '学期名称');
$sql = "select 学期名称 from edu_xueqiexec";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
if ($_GET['学期名称'] == "") {
$_GET['学期名称'] = $当前学期;
}
print "<table class=TableBlock align=center width=720>";
print "<tr class=TableContent>";
print "<td>学期名称：</td>";
print "<td><select name=term onChange=\"var jmpURL='?flag=1&学期名称=' + this.options[this.selectedIndex].value; if(jmpURL!='') {window.location=jmpURL;} else {this.selectedIndex=0;}\">";
for ($i = 0; $i < sizeof($rs_a); $i++) {
$学期名称 = $rs_a[$i]['学期名称'];
if ($学期名称 == $_GET['学期名称']) {
$selected = 'selected';
} else {
$selected = '';
}
print "<option value=" . $学期名称 . " {$selected}>" . $学期名称 . "</option>";
}
print "</select></td>";
$sql = "select 名称 from wygl_biaoxiuxiangmu";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
print "<td>报修项目：</td>";
print "<td><select name=报修项目 onChange=\"var jmpURL='?flag=1&学期名称=" . $_GET['学期名称'] . "&名称=' +this.options[this.selectedIndex].value; if(jmpURL!=''){window.location=jmpURL;} else this.selectedIndex=0;\">";
$supplyid = returntablefield("accessprepay", "id", $val['id'], "supplyid");
$rs_a[$i]['supplyname'] = returntablefield("supply", "rowid", $supplyid, "supplyname");
}
}
$i++;
}
}
if ($_GET['out_excel'] == 'true') {
export_XLS($head, $rs_a, $title, $sumcol);
exit;
}
?>
<html>
<head>
<?php
page_css('销售日报 ' . $data[0][rs_a][0][USER_NAME] . ' ' . $data[0][title] . $start_time . '至' . $end_time);
?>
<script language="javascript" src="../LODOP60/LodopFuncs.js"></script>
<SCRIPT src="../../Enginee/WdatePicker/WdatePicker.js"></SCRIPT>
<object id="LODOP" classid="clsid:2105C259-1E0C-4534-8141-A753534CB4CA"
width=0 height=0> <embed id="LODOP_EM" type="application/x-print-lodop"
width=0 height=0></embed> </object>
</head>
<body class=bodycolor topMargin=5>
<div id='con'>
<table class=TableBlock align=center width=100%>
<tr class=TableHeader><td colspan="8"><?php
echo $title . " " . $start_time . "-" . $end_time;
?>
</td></tr>
<?php
ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
error_reporting(E_WARNING | E_ERROR);
require_once 'lib.inc.php';
$GLOBAL_SESSION = returnsession();
page_css("费用申请");
if ($_GET['action'] == "edit_default_data") {
$单号 = $_POST['单号'];
$sql = "select 是否作废 from crm_qingjia_sq where 单号='{$单号}'";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
if ($rs_a[0]['是否作废'] == 1) {
print "\n\t\t\t<div align=\"center\" title=\"作废记录管理\">\n\t\t\t<table class=\"MessageBox\" align=\"center\" width=\"650\"><tr><td class=\"msg info\">\n\t\t\t<div class=\"content\" style=\"font-size:12pt\"> 此项记录已经作废，系统禁止操作.</div>\n\t\t\t</td></tr></table>\n\t\t\t<br>\n\t\t\t<div align=center>\n\t\t\t";
print "<input type=button value=\"返回\" class=\"SmallButton\" onClick=\"history.go(-2);\">\n\t\t\t</div>\n\t\t\t";
exit;
}
}
$filetablename = 'crm_qingjia_sq';
$parse_filename = 'crm_qingjia_sq';
require_once 'include.inc.php';
if ($_GET['action'] == '' || $_GET['action'] == 'init_default' || $_GET['action'] == 'init_customer') {
$PrintText .= "<BR><table class=TableBlock align=center width=100%>";
$PrintText .= "<TR class=TableContent><td ><font color=green >\n\t\t\t说明：<BR>\n\t\t\t</font></td></table>";
print $PrintText;
}
if ($ColumnName == "编号") {
$ColumnValue = $i + 1;
} else {
$ColumnValue = $rs_a[$i][$ColumnName];
}
print "<td nowrap>" . $ColumnValue . "</td>";
}
print "</tr>";
}
print "</table>";
exit;
}
//统计项
if ($_GET['action'] == "init_default" || $_GET['action'] == "") {
$html_etc = returnsystemlang('edu_xingzheng_kaoqinmingxi');
page_css("行政人员卡机考勤按月份查询");
//此段代码以前为周次统计之前,月份统计之下,后需要用到学期名称,所以提前至此
if ($_GET['学期名称'] != "") {
$学期名称 = $_GET['学期名称'];
} else {
$学期名称 = returntablefield("edu_xueqiexec", "当前学期", '1', "学期名称");
}
$学期初始值 = $学期名称;
$sql = "select 开始时间,学期名称 from edu_xueqiexec where 当前学期='1' order by 流水号 desc limit 1";
$rs = $db->CacheExecute(150, $sql);
$rs_a = $rs->GetArray();
$开始时间 = $rs_a[0]['开始时间'];
//$学期名称 = $rs_a[0]['学期名称'];
$开始时间Array = explode('-', $开始时间);
print "\n\t\t<table border=0 class=TableBlock width=100% >\n\t\t<tr class=TableHeader><td valign=bottom align=left>行政人员卡机考勤管理 " . $html_etc['edu_xingzheng_kaoqinmingxi']['学期'] . ":";
//$学期名称
<?php
require_once 'lib.inc.php';
//
$GLOBAL_SESSION = returnsession();
$SYSTEM_PRIV_STOP = 1;
require_once "systemprivateinc.php";
//CheckSystemPrivate("人力资源-行政考勤-我的考勤");
page_css('调班申请');
$当前学期 = returntablefield("edu_xueqiexec", "当前学期", '1', "学期名称");
if ($_GET['学期'] == "") {
$_GET['学期'] = $当前学期;
}
$学期名称 = $当前学期;
$_GET['人员'] = $_SESSION['LOGIN_USER_NAME'];
$_GET['人员用户名'] = $_SESSION['LOGIN_USER_ID'];
//$_GET['部门'] = returntablefield("department","DEPT_ID",$_SESSION['LOGIN_DEPT_ID'],"DEPT_NAME");
if ($_GET['action'] == 'TiaoBanDelete') {
$人员 = $_GET['人员'];
$班次 = $_GET['班次'];
$人员 = $_SESSION['LOGIN_USER_NAME'];
//如果数据存在则进行数据编辑操作
$query = "delete from edu_xingzheng_tiaoban where 编号='{$编号}' and 原班次='{$班次}' and 学期='{$学期名称}' and 审核状态='0'";
//print_R($_POST);
//print $query;
print "<BR><BR><div align=center><font color=green>你的操作已经处理!</font></div>";
$db->Execute($query);
//exequery($connection,$query);
print "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=?action=add_default&RUN_ID={$RUN_ID}'>\n";
exit;
}
else {
$_GET['级别'] = $_SESSION['级别'];
$_GET['专业代码'] = $_SESSION['专业代码'];
$_GET['专业名称'] = $_SESSION['专业名称'];
}
}
if($_GET['action']=="add_default_data"||$_GET['action']=="edit_default_data") {
//print_R($_POST);exit;
$_POST['课程代码'] = $_POST['课程名称_ID'];
//在此处理重复数据的情况
$sql = "select COUNT(*) AS NUM from edu_plan_source where 级别='".$_POST['级别']."' and 课程代码='".$_POST['课程代码']."' and 专业代码='".$_POST['专业代码']."'";
$rs = $db->Execute($sql);
$NUM = $rs->fields['NUM'];
if($NUM>0) {
page_css("信息重复");
print_infor("专业名称:".$_POST['专业名称']." 课程名称:".$_POST['课程名称']." 级别:".$_POST['级别']." 第几学期:".$_POST['第几学期']." 发生信息重复,请返回!",'',"location='?'");
exit;
}
}
//数据表模型文件,对应Model目录下面的edu_plan_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'edu_plan';
$parse_filename = 'edu_plan';
require_once('include.inc.php');
?>
//print_R($_POST);exit;
}
//批量通过审核操作
if ($_GET['action'] == "operation_piliangtongguo" && $_GET['selectid'] != "") {
//print_R($_GET);exit;
//print_R($_SESSION);
$审核人 = $_SESSION['LOGIN_USER_NAME'];
$审核时间 = date('Y-m-d H:i:s');
$Array = explode(',', $_GET['selectid']);
//PRINT_r($Array);EXIT;
for ($i = 0; $i < sizeof($Array); $i++) {
$Element = $Array[$i];
if ($Element != "") {
$审核状态 = returntablefield("edu_xingzheng_qingjia", "编号", ${$Element}, "审核状态");
if ($审核状态 != 1) {
$sql = "update edu_xingzheng_qingjia set 审核状态='1',审核人='{$审核人}',审核时间='{$审核时间}' where 编号='{$Element}' and 审核状态='0'";
$rs = $db->Execute($sql);
$sql . "<BR>";
}
}
}
$pageid = $_GET['pageid'];
page_css("相互调课审批");
print_nouploadfile("你的数据操作已经成功!");
echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=?pageid={$pageid}'>\n";
exit;
}
$filetablename = 'edu_xingzheng_qingjia';
require_once 'include.inc.php';
//功能性说明注释
require_once "../Help/module_xingzhengworkflow.php";
$SYSTEM_ADD_SQL .= " and (教研组审批意见!='') ";
}
if ($_GET['action'] == 'edit_default')
{
$_GET['教务科签字'] = $_SESSION['LOGIN_USER_NAME'];
//$_GET['教务科审批时间'] = date("Y-m-d", time());
}
if ($_GET['action'] == 'tongguo_add'&&$_GET['selectid']!="")
{
$Array = explode(',',$_GET['selectid']);
for($i=0;$i<sizeof($Array);$i++) {
$Element = $Array[$i];
if($Element!="") {
$sql = "update edu_shoukejihua_shixun set 教务科审批意见='同意',教务科签字='$_SESSION[LOGIN_USER_NAME]',教务科审批时间='".date("Y-m-d H:i:s")."' where 编号='$Element'";
$rs = $db->Execute($sql);
//print $sql."<BR>";
}
}
$pageid = $_GET['pageid'];
page_css("教务科审核");
print_nouploadfile("你的数据操作已经成功!");
echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=?pageid=$pageid'>\n";
exit;
}
//数据表模型文件,对应Model目录下面的edu_shoukejihua_lilun_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'edu_shoukejihua_shixun';
$parse_filename = 'edu_shoukejihua_shixun_jiaowuke1';
require_once('include.inc.php');
?>
$rs_a[$i]['shoupiaostate'] = kaipiaostate_value($row['shoupiaostate'], '', '');
$i++;
}
$head = array("supplyname" => "供应商", "billid" => "单号", "zhuti" => "主题", "caigoudate" => "采购日期", "daohuodate" => "预计到货日期", "USER_NAME" => "创建人", "totalmoney" => "总金额", "oddment" => "去零金额", "paymoney" => "已付金额", "rukumoney" => "已入库金额", "shoupiaomoney" => "已收票金额", "user_flag" => "单据状态", "ifpay" => "付款状态", "state" => "收货状态", "shoupiaostate" => "收票状态");
$headtype = array("supplyname" => "string", "billid" => "char", "zhuti" => "string", "caigoudate" => "string", "daohuodate" => "string", "USER_NAME" => "char", "totalmoney" => "float", "oddment" => "float", "paymoney" => "float", "rukumoney" => "float", "shoupiaomoney" => "float", "user_flag" => "char", "ifpay" => "char", "state" => "char", "shoupiaostate" => "char");
$title = "供应商供货明细";
$sumcol = array("totalmoney" => "", "oddment" => "", "paymoney" => "", "rukumoney" => "", "shoupiaomoney" => "");
if ($_GET['out_excel'] == 'true') {
export_XLS($head, $rs_a, $title, $sumcol);
exit;
}
?>
<html>
<head>
<?php
page_css($title);
?>
<script language="javascript" src="../LODOP60/LodopFuncs.js"></script>
<SCRIPT src="../../Enginee/WdatePicker/WdatePicker.js"></SCRIPT>
<object id="LODOP" classid="clsid:2105C259-1E0C-4534-8141-A753534CB4CA"
width=0 height=0> <embed id="LODOP_EM" type="application/x-print-lodop"
width=0 height=0></embed> </object>
</head>
<body class=bodycolor topMargin=5>
<div id='con'>
<table class=TableBlock align=center width=100%>
<head class="TableHeader">
<tr>
<?php
require_once 'lib.inc.php';
//
$GLOBAL_SESSION = returnsession();
$SYSTEM_PRIV_STOP = 1;
$当前学期 = returntablefield("edu_xueqiexec", "当前学期", '1', "学期名称");
if ($_GET['学期'] == "") {
$_GET['学期'] = $当前学期;
}
$学期名称 = $当前学期;
page_css('考勤补登');
$_GET['人员'] = $_SESSION['LOGIN_USER_NAME'];
$_GET['人员用户名'] = $_SESSION['LOGIN_USER_ID'];
$人员用户名 = $_SESSION['LOGIN_USER_ID'];
//$_GET['部门'] = returntablefield("department","DEPT_ID",$_SESSION['LOGIN_DEPT_ID'],"DEPT_NAME");
if ($_GET['action'] == 'KaoQinBudeng') {
//print_R($_POST);exit;
// [CHECK_2_0_VALUE] => on [0_VALUE] => 1 [0_ID] => 14 [0_BANJI] => 信息中心 [0_KECHENG] => 会议 [0_OLDDATE] => 2011-02-21 [0_OLDJIECI] => 会议 [0_OLDTEACHER] => 系统管理员 [CHECK_2_1_VALUE] => on
$考勤补登明细 = $_POST;
$条 = $_POST['COUNT'];
$日记补登 = array();
for ($i = 0; $i < $条; $i++) {
$教室key = $i . "_JIAOSHI";
$部门key = $i . "_BANJI";
$班次key = $i . "_KECHENG";
$上班时间key = $i . "_OLDDATE";
$人员key = $i . "_OLDTEACHER";
$上班补登状态key = "CHECK_1_" . $i . "_VALUE";
$下班补登状态key = "CHECK_2_" . $i . "_VALUE";
$部门 = $考勤补登明细[$部门key];
exit;
} else {
if ($_GET['action'] == "delete_array") {
$selectid = $_GET['selectid'];
$selectid = explode(",", $selectid);
//开启事务
global $db;
//$db->debug=1;
$db->StartTrans();
for ($i = 0; $i < sizeof($selectid); $i++) {
if ($selectid[$i] != "") {
$CaiWu = new CaiWu($db);
$CaiWu->deleteKaiPiao($selectid[$i]);
}
}
//是否事务出现错误
if ($db->HasFailedTrans()) {
print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
} else {
page_css("开票记录");
$return = FormPageAction("action", "init_default");
print_infor("开票记录已成功删除", 'trip', "location='?{$return}'", "?{$return}", 0);
}
$db->CompleteTrans();
exit;
}
}
addShortCutByDate("createtime", "录入时间");
$filetablename = 'kaipiaorecord';
$parse_filename = 'kaipiaorecord';
require_once 'include.inc.php';
$db->Execute($sql);
// 删除出库单
$sql = "select * from stockoutmain a where a.outtype='积分兑换出库' and a.dingdanbillid=" . $exchang_row[0][ROWID];
$rs = $db->Execute($sql);
$stockout_row = $rs->GetArray();
if (sizeof($stockout_row) > 0) {
$sql = "DELETE a FROM stockoutmain_detail a WHERE a.mainrowid=" . $stockout_row[0]['billid'];
$db->Execute($sql);
$sql = "DELETE a FROM stockoutmain a WHERE a.billid=" . $stockout_row[0]['billid'];
$db->Execute($sql);
}
}
}
if ($db->HasFailedTrans()) {
print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
exit;
}
$db->CompleteTrans();
page_css("删除成功");
$return = FormPageAction("action", "init_default");
print_infor("删除成功！", 'trip', "location='?{$return}'", "?{$return}", 1);
exit;
}
//数据表模型文件,对应Model目录下面的exchange_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
addShortCutByDate("createtime", "兑换时间");
$SYSTEM_ADD_SQL = getCustomerRoleByCustID($SYSTEM_ADD_SQL, "customid");
$limitEditDelCust = 'customid';
$filetablename = 'exchange';
$parse_filename = 'exchange';
require_once 'include.inc.php';
include '../adodb/adodb-session.php';
adodb_sess_open(false, false, false);
session_start();
$key = returnSessKey();
$sndg_community = $HTTP_SESSION_VARS[sndg_community];
$sess_val = adodb_sess_read($key);
if (!session_is_registered("sndg_community")) {
echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=error/notlogin.php'>";
}
require_once '../config.inc.php';
require_once './driver_database.php';
require_once '../database/user.php';
require_once '../lang/framework_html.php';
$choose_lang = getuser_lang($sndg_community);
global $framework_html;
page_css("ϵͳµ¯³ö´°¿Ú");
?>
<script language=javascript>
var parent_window = window.dialogArguments;
function check_form()
{
var date_time=parent_window.form1.END_DATE.value;
var cur_time=form1.hour.value+":"+form1.minite.value+":"+form1.second.value;
parent_window.form1.END_DATE.value+=" "+cur_time;
window.close();
}
</script>
<body class="bodycolor" topmargin="5">
if ($_GET['action'] == "delete_array") {
$selectid = $_GET['selectid'];
$selectid = explode(",", $selectid);
$db->StartTrans();
require_once "../Framework/uploadFile.php";
for ($i = 0; $i < sizeof($selectid); $i++) {
if ($selectid[$i] != "") {
deleteFile("workplanmain_detail", "id", $selectid[$i], "fujian");
$mainrowid = returntablefield("workplanmain_detail", "id", $selectid[$i], "mainrowid");
$sql = "delete from workplanmain_detail where id=" . $selectid[$i];
$db->Execute($sql);
updateWorkplanmain($mainrowid);
}
}
//是否事务出现错误
if ($db->HasFailedTrans()) {
print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
} else {
page_css("任务执行记录");
$return = FormPageAction("action", "init_default");
print_infor("任务执行记录已删除", 'trip', "location='?{$return}'", "?{$return}", 0);
}
$db->CompleteTrans();
exit;
}
addShortCutByDate("begintime", "开始时间");
$SYSTEM_ADD_SQL = getRoleByUser($SYSTEM_ADD_SQL, "createman");
//$SYSTEM_PRINT_SQL=1;
$filetablename = 'workplanmain_detail';
$parse_filename = 'workplanmain_detail';
require_once 'include.inc.php';
}
$return = FormPageAction("action", "init_default");
print_infor("<b>审核通过</b>", 'trip', "location='?{$return}'", "?" . $return, 1);
exit;
}
if ($_POST['action'] == "FouJue") {
page_css();
$billid = $_GET['id'];
$sql = "update crm_shenqingbaobei set state='3',shenheman='" . $_SESSION['LOGIN_USER_ID'] . "',shenhetime=now(),piyu='" . $_POST['piyu'] . "' where id='{$billid}'";
$rs = $db->Execute($sql);
$return = FormPageAction("action", "init_default");
print_infor("<b>审核否决</b>", 'trip', "location='?{$return}'", "?" . $return, 1);
exit;
}
if ($_GET['action'] == "edit_FouJue") {
page_css();
$billid = $_GET['id'];
$sql = "update crm_shenqingbaobei set state='1',shenheman='',shenhetime=null,piyu='' where id='{$billid}'";
$rs = $db->Execute($sql);
deleteMessage("项目报备", $billid);
$return = FormPageAction("action", "init_default");
print_infor("<b>撤销审核</b>", 'trip', "location='?{$return}'", "?" . $return, 1);
exit;
}
addShortCutByDate("createtime", "申请时间");
$SYSTEM_ADD_SQL = getCustomerRoleByCustID($SYSTEM_ADD_SQL, "customerid");
//数据表模型文件,对应Model目录下面的crm_shenqingbaobei_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'crm_shenqingbaobei';
$parse_filename = 'crm_shenqingbaobei';
require_once 'include.inc.php';
<?php
ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
// display warnings and errors
error_reporting(E_WARNING | E_ERROR);
require_once "lib.inc.php";
$GLOBAL_SESSION = returnsession();
page_css("物业管理_网上报修");
?>
<script>
function chkmsg()
{
if(document.getElementById('address').value=="")
{
alert('请填写具体的楼房房间地址');
return false;
}
else if(document.getElementById('content').value=="")
{
alert('请填写报修内容');
return false;
}
else return true;
}
</script>
<?php
//*****************获取教师信息*****************//
$教师ID = $_SESSION['LOGIN_USER_ID'];
$教师姓名 = $_SESSION['LOGIN_USER_NAME'];
//*****************当前学期信息*****************//
$sum_money += $row[money];
}
$sql = "SELECT * FROM crm_jieduan order by `编号` asc";
//exit($count_sql);
$rs = $db->Execute($sql);
$jieduan = $rs->GetArray();
$rs_a = array();
foreach ($jieduan as $row) {
$rs_a[$row['阶段']] = $data[$row['阶段']];
}
//print_r($rs_a);exit;
?>
<html>
<head>
<?php
page_css("销售漏斗");
?>
<script language="javascript" src="../LODOP60/LodopFuncs.js"></script>
<SCRIPT src="../../Enginee/WdatePicker/WdatePicker.js"></SCRIPT>
<object id="LODOP" classid="clsid:2105C259-1E0C-4534-8141-A753534CB4CA"
width=0 height=0> <embed id="LODOP_EM" type="application/x-print-lodop"
width=0 height=0></embed> </object>
</head>
<body class=bodycolor topMargin=5>
<div id='con'>
<table class=TableBlock align=left width=50%>
<thead>
<tr>
<td colspan="13">
<form action='' method="get">
<table width="100%" class="Small" border="0">
//print_R($_POST);exit;
}
//批量通过审核操作
if ($_GET['action'] == "operation_piliangtongguo" && $_GET['selectid'] != "") {
//print_R($_GET);exit;
//print_R($_SESSION);
$审核人 = $_SESSION['LOGIN_USER_NAME'];
$审核时间 = date('Y-m-d H:i:s');
$Array = explode(',', $_GET['selectid']);
//PRINT_r($Array);EXIT;
for ($i = 0; $i < sizeof($Array); $i++) {
$Element = $Array[$i];
if ($Element != "") {
$审核状态 = returntablefield("edu_xingzheng_tiaobanxianghu", "编号", ${$Element}, "审核状态");
if ($审核状态 != 1) {
$sql = "update edu_xingzheng_tiaobanxianghu set 审核状态='1',审核人='{$审核人}',审核时间='{$审核时间}' where 编号='{$Element}' and 审核状态='0'";
$rs = $db->Execute($sql);
$sql . "<BR>";
}
}
}
$pageid = $_GET['pageid'];
page_css("相互调班审批");
print_nouploadfile("你的数据操作已经成功!");
echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=?pageid={$pageid}'>\n";
exit;
}
$filetablename = 'edu_xingzheng_tiaobanxianghu';
require_once 'include.inc.php';
//功能性说明注释
require_once "../Help/module_xingzhengworkflow.php";
//$SYSTEM_ADD_SQL .= " and 教务校长签字='$_SESSION[LOGIN_USER_ID]' ";
}
if ($_GET['action'] == 'edit_default')
{
$_GET['教务校长签字'] = $_SESSION['LOGIN_USER_NAME'];
//$_GET['教务校长审批时间'] = date("Y-m-d", time());
}
if ($_GET['action'] == 'tongguo_add'&&$_GET['selectid']!="")
{
$Array = explode(',',$_GET['selectid']);
for($i=0;$i<sizeof($Array);$i++) {
$Element = $Array[$i];
if($Element!="") {
$sql = "update edu_shoukejihua_lilun set 教务校长审批意见='同意',教务校长签字='$_SESSION[LOGIN_USER_NAME]',教务校长审批时间='".date("Y-m-d H:i:s")."' where 编号='$Element'";
$rs = $db->Execute($sql);
//print $sql."<BR>";
}
}
$pageid = $_GET['pageid'];
page_css("教务校长审核");
print_nouploadfile("你的数据操作已经成功!");
echo "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=?pageid=$pageid'>\n";
exit;
}
//数据表模型文件,对应Model目录下面的edu_shoukejihua_lilun_newai.ini文件
//如果是需要复制此模块,则需要修改$parse_filename参数的值,然后对应到Model目录 新文件名_newai.ini文件
$filetablename = 'edu_shoukejihua_lilun';
$parse_filename = 'edu_shoukejihua_lilun_jiaowuxiaozhang1';
require_once('include.inc.php');
?>
<?php
require_once 'lib.inc.php';
page_css("SYSTEM", "INIT");
print "初始化:入库表\n<BR>";
$sql = "delete from stockinmain";
$db->Execute($sql);
$sql = "delete from stockindetail";
$db->Execute($sql);
print "初始化:出库表\n<BR>";
$sql = "delete from stockoutmain";
$db->Execute($sql);
$sql = "delete from stockoutdetail";
$db->Execute($sql);
print "初始化:库存表\n<BR>";
$sql = "delete from storedetail";
$db->Execute($sql);
$sql = "delete from stockindetail";
$db->Execute($sql);
print "初始化:采购订单\n<BR>";
$sql = "delete from buyplanmain";
$db->Execute($sql);
$sql = "delete from buyplandetail";
$db->Execute($sql);
print "初始化:销售订单\n<BR>";
$sql = "delete from sellplanmain";
$db->Execute($sql);
$sql = "delete from sellplandetail";
$db->Execute($sql);
print "初始化:销售合同\n<BR>";
$sql = "delete from sellcontract";
<?php
ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
error_reporting(E_WARNING | E_ERROR);
require_once 'lib.inc.php';
$GLOBAL_SESSION = returnsession();
page_css("MYSQL 性能监控");
//自动清除七天以前的历史记录
$sql = "delete from system_logall where datediff(now(),当前时间)>=7";
$db->Execute($sql);
$sql = "select DATE_FORMAT(当前时间,'%Y-%m-%d') AS 当前时间\n\t\tfrom system_logall\n\t\tgroup by DATE_FORMAT(当前时间,'%Y-%m-%d')\n\t\torder by 当前时间 desc\n\t\t";
$rs = $db->CacheExecute(5, $sql);
$rs_a = $rs->GetArray();
for ($i = 0; $i < sizeof($rs_a); $i++) {
$当前时间TEXT .= "<a href='?" . base64_encode("XX=XX&&当前时间=" . $rs_a[$i]['当前时间'] . "&&XX=XX") . "'>" . $rs_a[$i]['当前时间'] . "</a> ";
}
if ($_GET['当前时间'] != '') {
$统计时间 = $_GET['当前时间'];
} else {
$统计时间 = $rs_a[0]['当前时间'];
}
table_begin("100%");
print "<tr class=TableData ><td>MYSQL 运行情况监控 时间:" . $统计时间 . " {$当前时间TEXT}\n\t<input type=\"button\" class=\"SmallButton\" value=\"返回\" onclick=\"location='database_setting.php'\">\n\t<input type=\"button\" class=\"SmallButton\" value=\"明细\" onclick=\"location='system_logall_newai.php'\">\n\t</td></tr>";
table_end();
print "<BR>";
table_begin("780");
print_title("MYSQL 线程运行情况监控[以小时为单位统计] <a href=\"system_logall_mysqlthreads.php?" . base64_encode("XX=XX&&统计时间=" . $统计时间 . "&统计单位=秒&XX=XX") . "\" target=_blank>查看以秒为单位的统计图</a>");
print "<tr class=TableData ><td><img src='system_logall_mysqlthreads.php?" . base64_encode("XX=XX&&统计时间=" . $统计时间 . "&&XX=XX") . "' width=100% border=0></td></tr>";
print_title("MYSQL 查询缓存运行情况监控[以小时为单位统计] <a href=\"system_logall_querycache.php?" . base64_encode("XX=XX&&统计时间=" . $统计时间 . "&统计单位=秒&XX=XX") . "\" target=_blank>查看以秒为单位的统计图</a>");
print "<tr class=TableData ><td><img src='system_logall_querycache.php?" . base64_encode("XX=XX&&统计时间=" . $统计时间 . "&&XX=XX") . "' width=100% border=0></td></tr>";
$isBase64 = isBase64();
//½øÐÐ_GET±äÁ¿×ª»»
$isBase64 == 1 ? CheckBase64() : '';
$SERVER_NAME = $_SERVER['SERVER_NAME'];
require_once '../adodb/adodb.inc.php';
require_once '../config.inc.php';
require_once '../setting.inc.php';
require_once '../Enginee/lib/function_system.php';
###############################################################################
//½ÏÑéÓû§ÐÅÏ¢ÊÇ·ñÌîдÍê³É
###############################################################################
$sql = "select * from unit limit 1";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
if ($rs_a[0]['UNIT_NAME'] == "") {
page_css("ÇëÄúÏÈÍêÉƺÃÄãµÄÐÅÏ¢");
$text = "ÔÚ½øÐÐϵͳÉý¼¶²Ù×÷֮ǰ,ÇëÄúÏȵ½µ¥Î»¹ÜÀíÖÐÍêÉƵ¥Î»ÐÅÏ¢";
print "\n<table width='550' border='0' align='center' cellpadding='0' cellspacing='0' class='small' style='border:1px solid #006699;'>\n<tr>\n<td height='30' align='middle' colspan=2 bgcolor='#E0F2FC'>\n<font color=red >ÔÚ½øÐÐϵͳÉý¼¶²Ù×÷֮ǰ,ÇëÄúÏÈÍêÉƺÃÄãµÄÐÅÏ¢</font>\n</td>\n</tr>\n<tr>\n<td align='center' colspan=2 bgcolor='#E0F2FC'>\n{$text}<BR>\n<BR><input type=button class=SmallButton maxsize=200 onClick=\"location='../../system/unit/'\" value='µã»÷½øÈ뵥λÐÅÏ¢¹ÜÀíÒ³Ãæ'>\n<BR>\n<BR>\n</td>\n</tr>\n<tr></table><BR>\n";
print "";
exit;
}
###############################################################################
//½ÏÑéÓû§ÐÅÏ¢ÊÇ·ñÌîдÍê³É
###############################################################################
if ($_GET['RemoteHostName'] == "") {
$_GET['RemoteHostName'] = $_SERVER['SERVER_NAME'];
}
$_GET['RemoteHostName'] = "updatetdedu.dandian.net";
$RemoteHostName = $_GET['RemoteHostName'];
if ($_GET['action'] == "") {
print "<link rel=stylesheet href=\"<?php echo ROOT_DIR?>theme/3/style.css\"><body class=bodycolor><title>ͨ´ïOA½ÌÓý¹ÜÀí×é¼þ-¸üгÌÐò</title>";
