function newai_list_one()
{
global $db, $common_html, $tablename_one, $tablename_two, $link;
global $html_etc_one, $html_etc_two, $columns_one, $columns_two;
global $tablename, $SYTEM_CONFIG_TABLE;
global $SUNSHINE_USER_NAME_VAR, $SUNSHINE_USER_ID_VAR, $_SESSION;
$USER_NAME = $_SESSION[$SUNSHINE_USER_NAME_VAR];
print "<SCRIPT language=JavaScript>\n\tfunction clickMenu(url){\n\tparent.main_body.location=url;\n\t}\n\t</SCRIPT>\n\t";
$one_array = explode(':', $tablename_one);
//print_R($one_array);
$link_array = explode(':', $link);
//print_R($link_array);
$columns = returntablecolumn($tablename);
$columns_one = returntablecolumn($one_array[0]);
$html_etc_one = returnsystemlang($one_array[0], $SYTEM_CONFIG_TABLE);
switch ($db->databaseType) {
case 'mysql':
switch ($one_array[3]) {
case 'name':
$sql_one = "select " . $columns_one[(string) $one_array[1]] . "," . $columns_one[(string) $one_array[2]] . " from " . $one_array[0] . " where " . $columns_one[(string) $one_array[4]] . "='" . $USER_NAME . "'";
break;
case 'id':
$sql_one = "select " . $columns_one[(string) $one_array[1]] . "," . $columns_one[(string) $one_array[2]] . " from " . $one_array[0] . "";
break;
default:
$sql_one = "select " . $columns_one[(string) $one_array[1]] . "," . $columns_one[(string) $one_array[2]] . " from " . $one_array[0] . "";
break;
}
break;
case 'mssql':
switch ($one_array[3]) {
case 'name':
$sql_one = "select [" . $columns_one[(string) $one_array[1]] . "],[" . $columns_one[(string) $one_array[2]] . "] from [" . $one_array[0] . "] where [" . $columns_one[(string) $one_array[4]] . "]='" . $USER_NAME . "'";
break;
case 'id':
$sql_one = "select [" . $columns_one[(string) $one_array[1]] . "],[" . $columns_one[(string) $one_array[2]] . "] from [" . $one_array[0] . "]";
break;
default:
$sql_one = "select [" . $columns_one[(string) $one_array[1]] . "],[" . $columns_one[(string) $one_array[2]] . "] from [" . $one_array[0] . "]";
break;
}
break;
}
//print $sql_one;
$rs_one = $db->CacheExecute(150, $sql_one);
if ($rs_one->RecordCount() == 0) {
print_infor($common_html['common_html']['norecord'], 'trip');
exit;
}
while (!$rs_one->EOF) {
if (StrLen($link_array[3]) > 2) {
$LinkIndexName = (string) $link_array[3];
} else {
$LinkIndexName = $columns[(string) $link_array[3]];
}
$url = $link_array[0] . "?" . $link_array[1] . "=" . $link_array[2] . "&" . $LinkIndexName . "=" . $rs_one->fields[(string) $columns_one[(string) $one_array[1]]];
print "\n\t<TABLE class=small cellSpacing=1 cellPadding=0 width='100%' align=center bgColor=#000000 border=0>\n\t<TBODY>\n\t<TR class=TableContent title='' style='CURSOR: hand'\t onclick=clickMenu('{$url}')>\n\t<TD noWrap align=middle><table class=small cellPadding=3 align=center width=100% border=0 onmouseover=bgColor='#ffffff' onmouseout=bgColor='#d3e5fa'>\n\t<Tr><td align=middle><B>" . $rs_one->fields[(string) $columns_one[(string) $one_array[2]]] . "</B></TD></TR>\n\t</table></TD></TR>\n\t</TBODY></TABLE>\n";
$rs_one->MoveNext();
}
}
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;
}
}
}
function newai_list_two()
{
global $db, $common_html, $tablename_one, $tablename_two, $link;
global $html_etc_one, $html_etc_two, $columns_one, $columns_two;
global $tablename, $SYTEM_CONFIG_TABLE;
print "<SCRIPT language=JavaScript>\n\tfunction clickMenu(ID){ \n\t targetelement=document.all(ID);\n\tif (targetelement.style.display=='none')\n\t\t\ttargetelement.style.display='';\n\telse\n\t targetelement.style.display='none';\n\t }\n\t</SCRIPT>\n\t";
$one_array = explode(':', $tablename_one);
$two_array = explode(':', $tablename_two);
$link_array = explode(':', $link);
$columns = returntablecolumn($tablename);
$columns_one = returntablecolumn($one_array[0]);
$html_etc_one = returnsystemlang($one_array[0], $SYTEM_CONFIG_TABLE);
$columns_two = returntablecolumn($two_array[0]);
$html_etc_two = returnsystemlang($two_array[0], $SYTEM_CONFIG_TABLE);
$sql_one = "select " . $columns_one[(string) $one_array[1]] . "," . $columns_one[(string) $one_array[2]] . " from " . $one_array[0] . "";
$rs_one = $db->Execute($sql_one);
$Number = $rs_one->RecordCount();
if ($Number == 0) {
print_infor($common_html['common_html']['norecord'], 'trip');
exit;
}
while (!$rs_one->EOF) {
print "\n\t<TABLE class=small cellSpacing=1 cellPadding=0 width='100%' align=center bgColor=#000000 border=0>\n\t<TBODY>\n\t<TR bgColor='#d3e5fa' title='' style='CURSOR: hand'\t onclick=clickMenu('" . $rs_one->fields[(string) $columns_one[(string) $one_array[1]]] . "')>\n\t<TD noWrap align=middle><table class=small cellPadding=3 align=center width=100% border=0 onmouseover=bgColor='#ffffff' onmouseout=bgColor='#d3e5fa'>\n\t<Tr><td align=middle><B>" . $rs_one->fields[(string) $columns_one[(string) $one_array[2]]] . "</B></TD></TR>\n\t</table></TD></TR>\n\t</TBODY></TABLE>\n";
$one_id = $rs_one->fields[(string) $columns_one[(string) $one_array[1]]];
$sql_two = "select " . $columns_two[(string) $two_array[1]] . "," . $columns_two[(string) $two_array[2]] . " from " . $two_array[0] . " where " . $columns_two[(string) $two_array[3]] . "='{$one_id}'";
$rs_two = $db->Execute($sql_two);
//print $sql_two;//exit;
print "\n\t<TABLE class=small id={$one_id} style='DISPLAY: none'\n\tcellSpacing=1 cellPadding=0 width='100%' bgColor=#000000 border=0>\n\t<TBODY>\n";
while (!$rs_two->EOF) {
$two_id = $rs_two->fields[(string) $columns_two[(string) $two_array[1]]];
$two_name = $rs_two->fields[(string) $columns_two[(string) $two_array[2]]];
print "<TR class=TableData align=middle height=20>\n\t<TD noWrap><A href='" . $link_array[0] . "?" . $link_array[1] . "=" . $link_array[2] . "&" . $columns[(string) $link_array[3]] . "={$two_id}&" . $columns_one[(string) $one_array[1]] . "={$one_id}' target=\"main_body\">" . $two_name . "</A>\n\t</TD></TR>\n";
$rs_two->MoveNext();
}
print "</TBODY></TABLE>\n";
$rs_one->MoveNext();
}
}
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();
validateMenuPriv("报销单审核");
if ($_GET['action'] == "shenhedan") {
$CaiWu = new CaiWu($db);
$db->StartTrans();
$billid = $_GET['单号'];
$feiyonginfo = returntablefield("v_feiyong_sq", "单号", $billid, "金额,费用类型");
$jine = $feiyonginfo['金额'];
$fytype = $feiyonginfo['费用类型'];
$sql = "update crm_feiyong_sq set 是否审核='4',出纳员='" . $_SESSION['LOGIN_USER_ID'] . "',支付时间=now() where 单号='{$billid}'";
$rs = $db->Execute($sql);
$CaiWu->insertFeiYongAccount($fytype, $jine, 1, $_SESSION['LOGIN_USER_ID'], -1);
//是否事务出现错误
if ($db->HasFailedTrans()) {
print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
} else {
page_css("报销单审核");
$return = $return . "?" . FormPageAction("action", "init_default");
print_infor("已报销", 'trip', "location='?{$return}'", "{$return}", 0);
}
$db->CompleteTrans();
exit;
}
addShortCutByDate("创建时间", "申请时间");
$filetablename = 'v_feiyong_sq';
$parse_filename = 'v_feiyong_sq';
require_once 'include.inc.php';
//print_R($rs_a);
$mainrowid = $rs_a[0]['mainrowid'];
if ($mainrowid != "") {
$update = "update sellplanmain set dataState ='2' where ROWID='{$MAINROWID}'";
$db->Execute($update);
//print $udpate."<HR>";
}
}
}
//如果采购订单明细部分数据流转完成，更新dataState为2。部分流转显示未全部执行，更新为1
$udpate = "update sellplandetail set dataState ='2' where stockinfactnum>=plannum";
$db->Execute($udpate);
//print $udpate."<HR>";
//处理返回的数据状态显示
print "<link rel=\"stylesheet\" type=\"text/css\" href=\"" . ROOT_DIR . "theme/3/style.css\">";
print_infor("出库单己经生成！", $infor = 'trip', $return = '');
print "<br>\n";
print "<div align=center>\n";
print " <input type=button accesskey='r' value=\"" . $common_html['common_html']['close'] . "\" class=\"SmallButton\" onclick=\"javasrcipt:window.opener =null;window.close();\">\n";
print "</div>\n";
//print "<script>window.opener =null;window.close();</script>";
//echo "<META HTTP-EQUIV=REFRESH CONTENT='2;URL=notchecked.php'>\n";
exit;
}
?>
<link rel="stylesheet" type="text/css" href="<?php
echo ROOT_DIR;
}
$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';
print_submit($common_html['common_html']['submit'], 2, 'all', '#');
table_end();
form_end();
}
if ($_GET['action'] == "updatedata") {
if (is_file($goalfile)) {
unlink($goalfile);
}
$goalfile = $goalfile;
$_POST['status_bar'] = str_replace("(", "（", $_POST['status_bar']);
$_POST['status_bar'] = str_replace(")", "）", $_POST['status_bar']);
$_POST['CompanyName'] = str_replace("(", "（", $_POST['CompanyName']);
$_POST['CompanyName'] = str_replace(")", "）", $_POST['CompanyName']);
$_POST['IETitle'] = str_replace("(", "（", $_POST['IETitle']);
$_POST['IETitle'] = str_replace(")", "）", $_POST['IETitle']);
$_POST['LoginTitle'] = str_replace("(", "（", $_POST['LoginTitle']);
$_POST['LoginTitle'] = str_replace(")", "）", $_POST['LoginTitle']);
$string = "[section]\nstatus_bar={$_POST['status_bar']}\n";
$string .= "CompanyName={$_POST['CompanyName']}\n";
$string .= "IETitle={$_POST['IETitle']}\n";
$string .= "LoginTitle={$_POST['LoginTitle']}\n";
$string .= "provinces={$_POST['provinces']}\n";
!($handle = @fopen($goalfile, "w"));
if (!fwrite($handle, $string)) {
exit;
}
fclose($handle);
page_css("Configure");
$showtext = "配置完成!";
print_infor($showtext, "trip", "?", "system_interface.php", 1);
}
function message($message, $message2)
{
print_infor($message2, $message, "location='?'");
exit;
}
<?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';
$人员 = $考勤补登明细[$人员key];
$上班补登状态 = $考勤补登明细[$上班补登状态key];
$下班补登状态 = $考勤补登明细[$下班补登状态key];
//exit;
// 编号 学期 部门 人员 时间 星期 班次 补登项目 审核状态 工作流ID号 审核人 审核时间 人员用户名
if ($上班补登状态 == 'on') {
$sql = "INSERT INTO edu_xingzheng_kaoqinbudeng ( `编号` , `学期` , `部门` , `人员` , `时间` , `星期` , `班次` , `补登项目` , `审核状态`, `工作流ID号` , `审核人`, `审核时间` , `人员用户名` )VALUES ( '', '{$学期名称}', '{$部门}', '{$人员}', '{$上班时间}', '{$星期}', '{$班次}', '上班考勤补登', '0', '', '', '', '{$人员用户名}')";
$rs = $db->Execute($sql);
//print $sql;exit;
}
if ($下班补登状态 == 'on') {
$sql = "INSERT INTO edu_xingzheng_kaoqinbudeng ( `编号` , `学期` , `部门` , `人员` , `时间` , `星期` , `班次` , `补登项目` , `审核状态`, `工作流ID号` , `审核人`, `审核时间` , `人员用户名` )VALUES ( '', '{$学期名称}', '{$部门}', '{$人员}', '{$上班时间}', '{$星期}', '{$班次}', '下班考勤补登', '0', '', '', '', '{$人员用户名}')";
$rs = $db->Execute($sql);
}
}
print_infor("提交成功,请返回...");
print "<meta http-equiv=\"REFRESH\" content=\"0 URL=?\">";
exit;
}
if ($_GET['action'] == 'DataDeal') {
$query = "delete from edu_xingzheng_kaoqinbudeng where 编号='{$编号}' and 审核状态=0 ";
//print_R($_POST);
//print $query;exit;
print "<BR><BR><div align=center><font color=green>你的操作已经处理!</font></div>";
$db->Execute($query);
//dandian_sql_log($connection,$query);
print "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=?'>\n";
exit;
}
if ($_GET['action2'] == 'DataDeal') {
$query = "delete from edu_xingzheng_kaoqinbudeng where 编号='{$编号}' and 审核状态=0 ";
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';
$ROLE_NAME = $_POST['PRIV_NAME'];
$FileNameSELF = $_POST['FileNameSELF'];
//print_R($_POST);exit;
$sql = "select MODULE from systemprivateinc where `FILE`='{$FILE}' and `MODULE`='{$MODULE}'";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
//print_R($cursor1);exit;
$MODULE2 = TRIM($rs_a[0]['MODULE']);
//print $MODULE2;
if ($MODULE2 != "") {
$sql = "update systemprivateinc set `DEPT_ID`='{$DEPT_ID}',`USER_ID`='{$USER_ID}',`ROLE_ID`='{$ROLE_ID}',`DEPT_NAME`='{$DEPT_NAME}',`USER_NAME`='{$USER_NAME}',`ROLE_NAME`='{$ROLE_NAME}' where `FILE`='{$FILE}' and `MODULE`='{$MODULE}'";
} else {
$sql = "insert into systemprivateinc values('','{$FILE}','{$MODULE}','{$DEPT_ID}','{$DEPT_NAME}','{$ROLE_ID}','{$ROLE_NAME}','{$USER_ID}','{$USER_NAME}')";
}
$db->Execute($sql);
print_infor("您的配置已经完成", '', "location='?'", "?");
exit;
}
table_begin("100%");
print "<tr class=TableHeader><td colspan=5> " . $TextHeader . "</td></tr>";
print "<tr class=TableHeader><td> 所属部门</td><td> 编辑权限</td><td> 管理人员</td></tr>";
for ($i = 0; $i < sizeof($rsX_a); $i++) {
$部门名称 = $rsX_a[$i]['所属部门'];
$sql = "select * from systemprivateinc where MODULE='" . $部门名称 . "' and FILE='{$PHP_SELF}'";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
if ($部门名称 != "") {
print "<tr class=TableData><td> " . $部门名称 . "</td><td><a href=\"?" . base64_encode("FileNameSELF=" . $PHP_SELF_SELF . "&FileName=" . $PHP_SELF . "&ModuleName=" . $部门名称 . "") . "\"> 编辑权限</a></td>\n\t\t\t<td> " . $rs_a[0]['USER_NAME'] . "</td>\n\t\t\t</tr>";
}
}
table_end();
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');
?>
$课题考试学时 = trim($_POST['课题考试学时']);
$机动学时 = trim($_POST['机动学时']);
$其它 = trim($_POST['其它']);
$班级人数 = trim($_POST['班级人数']);
$尚需授课学时数 = trim($_POST['尚需授课学时数']);
$大纲要求及变动说明 = trim($_POST['大纲要求及变动说明']);
$教学大纲 = trim($_POST['教学大纲']);
$基本教材 = trim($_POST['基本教材']);
$主要参考书 = trim($_POST['主要参考书']);
$sql = "update edu_shoukejihua_shixun set 总学时数='$总学时数', 已讲授学时数='$已讲授学时数', 周学时数='$周学时数',授课周数='$授课周数',授课时数='$授课时数',讲课学时='$讲课学时',示范学时='$示范学时',实作学时='$实作学时',课题考试学时='$课题考试学时',机动学时='$机动学时',其它='$其它',班级人数='$班级人数',尚需授课学时数='$尚需授课学时数',大纲要求及变动说明='$大纲要求及变动说明',教学大纲='$教学大纲',基本教材='$基本教材',主要参考书='$主要参考书' where 编号='$编号' ";
$db->Execute($sql);
page_css("数字化校园-教师授课计划");
print_infor("你的授课计划已经填写成功,系统返回中...",'',"location='edu_shoukejihua_view_shixun.php'");
print "<META HTTP-EQUIV=REFRESH CONTENT='0;URL=edu_shoukejihua_view_shixun.php'>\n";
exit;
}
?>
<HTML>
<HEAD>
<TITLE>数字化校园-教师授课计划</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK href="<?=$_SESSION['SUNSHINE_THEME_PRE']?>/theme/<?=$LOGIN_THEME?>/style.css" type=text/css rel=stylesheet>
<script type="text/javascript" language="javascript" src="../../Enginee/lib/common.js"></script>
<style type="text/css">
table{
//判断是否在智能排课的时间范围之内
$goalfile = "../EDU/config_schedule_autoform_inc.ini";
$file = file($goalfile);
$Text = join('',$file);
$DataText = unserialize($Text);
//print_r($DataText);
$开始时间 = $DataText['开始时间'];
$开始时间Array = explode('-',$开始时间);
$结束时间 = $DataText['结束时间'];
$结束时间Array = explode('-',$结束时间);
$开始时间 = date("Y-m-d",mktime(1,1,1,$开始时间Array[1],$开始时间Array[2],$开始时间Array[0]));
$结束时间 = date("Y-m-d",mktime(1,1,1,$结束时间Array[1],$结束时间Array[2],$结束时间Array[0]));
$当前时间 = date("Y-m-d");
if($当前时间>=$开始时间&&$当前时间<=$结束时间) {
print_infor(" 现在是教务处排课时间.<BR> 不能同步教师考勤信息.",'','?');
exit;
}
else {
}
//得到教学日记最大填写时间
$goalfile = "../EDU/config_teachercardtimeisactive_inc.ini";
$file = file($goalfile);
$Text = join('',$file);
$教学日记最大填写时间数组 = unserialize($Text);
//print_R($教学日记最大填写时间数组);
$教学日记最大填写时间 = $教学日记最大填写时间数组['JiaoXueRiJiQiXian'];
if($教学日记最大填写时间=="") {
$sql = "insert into store (id,prodid,num,price,storeid,memo) values({$maxid},'" . $rs_detail[$i]['prodid'] . "',{$num},{$price},{$storeid},'{$memo}')";
$db->Execute($sql);
}
}
$sql = "delete from store_init where storeid=" . $storeid . " and flag=0 and num=0";
$db->Execute($sql);
//更新初始化状态
$sql = "update store_init set flag=1 where storeid=" . $storeid . " and flag=0";
$db->Execute($sql);
//是否事务出现错误
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;
} catch (Exception $e) {
print "<script language=javascript>alert('错误：" . $e->getMessage() . "');window.history.back(-1);</script>";
exit;
}
}
if ($_GET['action'] == 'edit_default3') {
$storeid = $_GET['ROWID'];
require_once "stockinit_clear.php";
exit;
}
$SYSTEM_ADD_SQL = getKucunByUserid($SYSTEM_ADD_SQL, $_SESSION['LOGIN_USER_ID'], "ROWID");
$filetablename = "stock";
}
if ($_POST['password'] != "") {
$USER_ID = $_POST["USER_ID"];
$oldpassword = $_POST["oldpassword"];
$sql = "select * from user where user_id='" . $USER_ID . "' and password='******'";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
if (sizeof($rs_a) == 0) {
print_infor("旧的用户名密码不匹配", "trip", "close");
exit;
}
$password = $_POST["password"];
$newpassword = crypt($password);
$sql = "update user set PASSWORD='******' WHERE USER_ID = '" . $USER_ID . "'";
$db->Execute($sql);
print_infor("您的密码修改成功!", 'trip', "close");
exit;
}
?>
<html>
<head>
<script language="JavaScript" src="../Enginee/jquery/jquery-1.4.4.min.js"></script>
<link type="text/css" rel="stylesheet" href="../Enginee/jquery/validator.css"></link>
<script language="javascript" type="text/javascript" src="../Enginee/jquery/formvalidator.js" charset="UTF-8"></script>
<script language="javascript" type="text/javascript" src="../Enginee/jquery/formvalidatorregex.js" charset="UTF-8"></script>
<script type="text/javascript">
$(document).ready(function() {
//$.formValidator.initConfig({autotip:true,formid:"form1",onerror:function(msg){}});
$.formValidator.initConfig({formid:"form1",debug:false,submitonce:true,
onerror:function(msg,obj,errorlist){
$创建时间 = date("Y-m-d H:i:s");
$排班人员数据 = array();
$排班人员Array = explode(',', $排班人员);
for ($iX = 0; $iX < sizeof($排班人员Array); $iX++) {
$排班人员X = $排班人员Array[$iX];
$排班人员数据[$排班人员X] = $排班人员X;
}
$排班人员数据K = @array_keys($排班人员数据);
$排班人员 = join(',', $排班人员数据K) . ",";
//if($NUM==0) {
$sql = "insert into edu_xingzheng_paiban values('','{$当前学期}','{$当前周次}','{$星期}','{$考勤日期}','{$班次名称}','{$排班人员}','{$备注}','{$创建人}','{$创建时间}')";
$db->Execute($sql);
//print $sql."<BR>";
//}
}
print_infor("你的数据已经初始化完成.", '', "location='?当前周次=" . $当前周次 . "'");
print "<meta http-equiv='refresh' content=0;url='?当前周次=" . $当前周次 . "'>";
exit;
}
//exit;
//print_R($rs_a);
//本周有数据,或上周无数据,都会停止导入动作
if (sizeof($rs_a) == 0 || sizeof($rs_a本周) > 0) {
//没有记录,不能获取数据
$disabled_前周 = "disabled readonly title='本周已经有排班数据或上周无排班数据,不能从上周获取信息'";
}
?>
<table width="100%" class="TableBlock" align="center">
<tr class="TableHeader">
<td colspan=8>设置排班情况 当前周次:<?php
echo $当前周次;
$custName = returntablefield("customer", "rowid", $_POST[customerid], "supplyname");
$url = '../JXC/crm_contact_newai.php?' . base64_encode('action=view_default&id=' . $id);
newMessage($_POST[createman], '联系客户 ' . $custName, '客户联系提醒', $url, $id, $_POST[nextcontacttime]);
$EndTime = strtotime("{$_POST['nextcontacttime']} +1 hour");
$EndTime = date("Y-m-d H:i:s", $EndTime);
$url = '../' . $url;
newCalendar($_POST[createman], $_POST[nextcontacttime], $EndTime, '联系客户', '1', $custName . ":" . $_POST[nextissue], $url, $id);
}
$db->CompleteTrans();
if ($db->HasFailedTrans()) {
print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
exit;
}
updateLastTrace($_POST[customerid]);
$return = FormPageAction("action", "init_default");
print_infor("修改成功", 'trip', "location='?{$return}'", "?{$return}", 1);
exit;
}
if ($_GET['action'] == "delete_array") {
$selectid = $_GET['selectid'];
$selectid = explode(",", $selectid);
for ($i = 0; $i < sizeof($selectid); $i++) {
if ($selectid[$i] != "") {
deleteMessage('客户联系提醒', $selectid[$i]);
deleteCalendar('联系客户 ', $selectid[$i]);
}
}
}
function updateLastTrace($customerid)
{
global $db;
$primarykey_index = $columns[$primarykey];
$html_etc = returnsystemlang($tablename, $SYTEM_CONFIG_TABLE);
page_css($IE_TITLE);
require_once 'systemsetting.php';
if (sizeof($action_array) >= 3 && $action_array[2] != 'config') {
$formnewvar = formnewvar($file_ini[$action], $_GET['FLD_STR']);
updatesystemsetting($formnewvar);
$return = returnpageaction($mode = 'edit_init', array('index_name' => 'action', 'index_id' => $returnmodel));
print_infor($common_html['common_html']['setsuccess'], 'trip', "location='?{$return}'", "?{$return}");
exit;
} else {
if (sizeof($action_array) >= 3 && $action_array[2] == 'config') {
usesystemsetting();
$return = FormPageAction("action", $returnmodel);
//$return=returnpageaction($mode='edit_init',array('index_name'=>'action','index_id'=>$returnmodel));
print_infor($common_html['common_html']['systemconfigsuccess'], 'trip', "location='?{$return}'", "?{$return}");
exit;
}
}
$showlistfieldlist_array = explode(',', $showlistfieldlist);
for ($i = 0; $i < sizeof($showlistfieldlist_array); $i++) {
$value['record'][$i]['name'] = $html_etc[$tablename][(string) $columns['' . $showlistfieldlist_array[$i] . '']];
$value['record'][$i]['value'] = $showlistfieldlist_array[$i];
}
//$showlistfieldlist=returnsystemsetting($tablename,$action,'FIELD_LIST',$showlistfieldlist);
//$showlistfieldlist_array=explode(',',$showlistfieldlist);
$value['table_name'] = $tablename;
$value['table_action'] = $_GET['table_action'];
$value['titleleft'] = $common_html['common_html']['yoursetinfor'];
$value['titleright'] = $common_html['common_html']['originalinfor'];
systemsetting_view($value);
$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';
讲课学时='$讲课学时',
上机学时='$上机学时',
实验学时='$实验学时',
体育学时='$体育学时'
where 课程代码='$课程代码'";
$db->Execute($sql);
//print $sql."<BR>";
$COUNTER1++;
}
else {
$COUNTER2++;
}
}
//exit;
page_css('您的操作已经完成');
print_infor("您的操作已经完成,处理数据".(int)$COUNTER1."条,由于课程库里面类别类别总学时学分字段为空原因所造成的没有更新数据".(int)$COUNTER2."条 ",'',"location='?'");
exit;
}
if($_GET['action']=="add_default_data") {
global $db;
$不排课节次 = $_POST['时间设置'];
//dump($不排课节次);
if(sizeof($不排课节次)!=0){
//将数组序列化
$_POST['不排课节次序列化'] = serialize($不排课节次);
}
//生成教师排课时间直观信息
if(sizeof($不排课节次)!=0){
$报修时间 = Date("Y-m-d");
//********报修时间********//
$创建时间 = Date("Y-m-d H:i:s");
//**POST传递URL的参数信息*//
$楼房属性_post = $_POST['楼房属性'];
$楼房名称_post = $_POST['楼房名称'];
$楼房地址_post = $_POST['楼房地址'];
$报修项目_post = $_POST['报修项目'];
$报修内容_post = $_POST['报修内容'];
$报修人联系方式 = $_POST['报修人联系方式'];
//********执行插入********//
$sql = "insert into wygl_baoxiuxinxi(当前学期,楼房属性,楼房名称,楼房地址,报修项目,报修内容,报修人,\n\t\t\t 报修时间,是否受理,维修状态,是否评价,备注,创建人,创建时间,报修人联系方式) values('" . $当前学期 . "','" . $楼房属性_post . "','" . $楼房名称_post . "','" . $楼房地址_post . "','" . $报修项目_post . "','" . $报修内容_post . "','" . $报修人 . "',\n\t\t\t\t'" . $报修时间 . "','否','否','否','','" . $创建人 . "','" . $创建时间 . "','{$报修人联系方式}')";
$db->Execute($sql);
$_GET = array();
$_POST = array();
print_infor("发布维修信息成功");
print "<meta http-equiv=\"REFRESH\" content=\"0 URL=?\">";
} else {
if ($_GET['action'] == "") {
//********楼房属性********//
$楼房属性 = array();
$楼房属性[0]['楼房属性'] = "宿舍";
$楼房属性[1]['楼房属性'] = "教学办公";
$楼房属性_sel = "<Select name='楼房属性' class=SmallSelect style='width:50%;' onChange=\"var jmpURL='?flag=jump&楼房属性=' + this.options[this.selectedIndex].value; if(jmpURL!='') {window.location=jmpURL;} else {this.selectedIndex=0;}\">";
for ($i = 0; $i < sizeof($楼房属性); $i++) {
if ($楼房属性_get == $楼房属性[$i]['楼房属性']) {
$Selected = "selected";
} else {
$Selected = "";
}
$楼房属性_sel .= "<Option " . $Selected . " value='" . $楼房属性[$i]['楼房属性'] . "'>" . $楼房属性[$i]['楼房属性'] . "</Option>";
TRUNCATE TABLE `edu_teacherkaoqin` ;
*/
//得到现有MYSQL里面最近一次考勤记录ID的值
$sql = "select max(考勤机ID值) AS 编号 from edu_teacherkaoqin";
$rs = $db->Execute($sql);
$最近一次考勤记录ID的值 = $rs->fields['编号'];
if ($最近一次考勤记录ID的值 > 0) {
$AddSqlKaoQinJiText = "where {$考勤表_主EKY}>'{$最近一次考勤记录ID的值}'";
} else {
$AddSqlKaoQinJiText = "";
}
//#######################################################################################
//使用MSSQL数据连接部分代码-开始
//#######################################################################################
if ($SYSTEM_VERSION_CONTENT == "TONGDA") {
page_css("自动检测是否安装MSSQL数据库信息");
print_infor("您的服务器没有检测到考勤机SQL SERVER数据库信息,请确认装有指定型号的考勤机类型和数据库后再进行读取考勤信息操作,VERSION INFOR IS ERROR", 'stop', "location='?'");
exit;
}
if ($SYSTEM_VERSION_CONTENT == "JMQX") {
include "../EDU/KAOQINJI_JMQX.php";
exit;
}
if ($SYSTEM_VERSION_CONTENT == "HCVT") {
include "../EDU/KAOQINJI_HCVT.php";
exit;
}
if ($SYSTEM_VERSION_CONTENT == "FJHG") {
include "../EDU/KAOQINJI_FJHG.php";
exit;
}
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';
$CurXueQi = returntablefield("edu_xueqiexec", "当前学期", '1', "学期名称");
if ($_GET['开课教师'] != "") {
$SHOWTEXT = "1";
} else {
$SHOWTEXT = "0";
}
$goalfile = "../../Framework/system_config.ini";
if ($_GET['action'] == "") {
$parse_ini_file = parse_ini_file($goalfile);
page_css("预设省份区域");
print "<SCRIPT>\n\tfunction FormCheck()\n\t{\n\t\t//if (document.form1.开课教师.value == \"\") {\n\t\t//alert(\"教师信息没有填写\");\n\t\t//return false;}\n\t}\n\tfunction td_calendar(fieldname) {\n\t\tmyleft=document.body.scrollLeft+event.clientX-event.offsetX-80;\n\t\tmytop=document.body.scrollTop+event.clientY-event.offsetY+140;\n\t\twindow.showModalDialog(fieldname,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:200px;dialogTop:\"+mytop+\"px;dialogLeft:\"+myleft+\"px\");\n\t\t}\n\t</SCRIPT>";
print "<FORM name=form1 onsubmit=\"return FormCheck();\" action=\"?action=DataDeal&pageid=1\" method=post encType=multipart/form-data>";
table_begin("80%");
print "<tr class=TableHeader><td colspan=2> 预设省份区域[在某些使用到省份地市区县三级联动时,进行默认的值]</td></tr>";
print_select_countryCode($parse_ini_file['provinces'], $fields);
print_submit("提交");
table_end();
form_end();
exit;
}
if ($_GET['action'] == "DataDeal") {
page_css("预设省份区域");
//$file = file($goalfile);
$DataText = "[section]\nprovinces=" . $_POST['areaCode'];
@(!($handle = fopen($goalfile, 'w')));
fwrite($handle, $DataText);
fclose($handle);
//print_R($_POST);
print_infor("你的数据操作已经成功,请返回", "location='?'", "location='?'", "?");
exit;
}
//得到固定教室名称
$fixedClassroom = returntablefield("edu_banji","班级名称",$ClassCode,"固定教室");
//得到班主任名称
$班主任 = returntablefield("edu_banji","班级名称",$ClassCode,"班主任");
ClassTablePreview();
break;
case 'showClassroomTableInfor':
page_css2($IE_TITLE,"教室课表查询");
//条件判断
if($ClassroomCode=="") {print_infor("请选择教室!");exit;}
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':
function exist_group_user()
{
global $db, $group_user;
global $_GET, $_POST, $common_html;
global $fields;
global $SUNSHINE_USER_NAME_VAR, $SUNSHINE_USER_ID_VAR, $_SESSION;
DoReferer();
$group_user_array = explode(':', $group_user);
$parent_group = return_parent_group();
//print_R($parent_group);
$tablename = $group_user_array[0];
switch ($parent_group['sql_text']['type']) {
case 'group':
$temp_user_value = $_GET[(string) $parent_group['sql_text']['user']];
break;
default:
$temp_user_value = $_SESSION[$SUNSHINE_USER_NAME_VAR];
break;
}
$sql = "select count(" . $parent_group['sql_text'][parent] . ") as num from {$tablename} where " . $parent_group['sql_text'][parent] . "='" . $_GET[(string) $parent_group['sql_text'][parent]] . "' and " . $parent_group['sql_text'][user] . "='" . $temp_user_value . "'";
$rs = $db->Execute($sql);
//print $sql;exit;
if ($rs->fields[num] >= 1) {
print_infor($common_html['common_html']['notnullinfolder'], 'trip', "history.back();");
exit;
} else {
delete_array_newai($_GET[(string) $parent_group[parent]], $fields);
}
}
<?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();
$tablename = $_GET['tablename'];
$id = $_GET['id'];
if ($tablename == 'buyplanmain_detail_color') {
$sql = "select * from buyplanmain_detail where id={$id}";
$rs = $db->Execute($sql);
$rs_a = $rs->GetArray();
if (sizeof($rs_a) != 1) {
print_infor("不存在此记录", "forbidden", "close");
exit;
}
$sql = "select * from productcolor";
$rs = $db->Execute($sql);
$rs_b = $rs->GetArray();
?>
<form name="form2">
<table align=center class=TableBlock width=100% border=0 id="table1">
<tr >
<td align=center class=TableHeader>原厂码</td>
<td align=center class=TableHeader>当前库存</td>
<td align=center class=TableHeader></td>
<?php
for ($i = 0; $i < sizeof($rs_b); $i++) {
print "<td align=center class=TableHeader>" . $rs_b[$i]["name"] . "</td>";
}
