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>";