You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

926 lines
22 KiB

<!DOCTYPE html>
<html>
<head>
<title>My Page</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="http://code.jquery.com/mobile/1.1.0/jquery.mobile-1.1.0.min.css" />
<script src="http://code.jquery.com/jquery-1.7.1.min.js" type="text/javascript"></script>
<script src="http://code.jquery.com/mobile/1.1.0/jquery.mobile-1.1.0.min.js" type="text/javascript"></script>
<script src="jquery.timers-1.2.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function(){
/*
// 获取市下的行政区划列表
var hyper001 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "",
"query_conditions": [
200051
],
"query_format": "json",
"query_id": "hyper001",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取市下的单位列表
var hyper002 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "",
"query_conditions": [
200051, 2
],
"query_format": "json",
"query_id": "hyper002",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取区下的单位列表
var hyper003 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "",
"query_conditions": [
310041, 2
],
"query_format": "json",
"query_id": "hyper003",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取单位下的组织机构(部门)树
var hyper004 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "",
"query_conditions": [
200125116
],
"query_format": "json",
"query_id": "hyper004",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取组织机构(部门)下的教师列表
var hyper005 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "",
"query_conditions": [
3
],
"query_format": "json",
"query_id": "hyper005",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取学校的学段列表
var hyper006 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "",
"query_conditions": [
3
],
"query_format": "json",
"query_id": "hyper006",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取学校的入学年份列表
var hyper007 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "",
"query_conditions": [
3
],
"query_format": "json",
"query_id": "hyper007",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取学校的班级列表
var hyper008 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "",
"query_conditions": [
3, 4, 2018
],
"query_format": "json",
"query_id": "hyper008",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取班级下的学生列表
var hyper009 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "",
"query_conditions": [
126440
],
"query_format": "json",
"query_id": "hyper009",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取班级下的家长列表
var hyper010 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "",
"query_conditions": [
126440
],
"query_format": "json",
"query_id": "hyper010",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取单位信息
var hyper011 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"data_id": "3",
"query_cols": [
],
"query_format": "json",
"query_id": "hyper011"
}
// 获取班级信息
var hyper012 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"data_id": "126440",
"query_cols": [
],
"query_format": "json",
"query_id": "hyper012"
}
// 获取教师信息
var hyper013 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"data_id": "69033",
"query_cols": [
],
"query_format": "json",
"query_id": "hyper013"
}
// 获取学生信息
var hyper014 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"data_id": "86202337",
"query_cols": [
],
"query_format": "json",
"query_id": "hyper014"
}
// 获取人员的所有角色列表
var hyper015 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "",
"query_conditions": [
69033, 7
],
"query_format": "json",
"query_id": "hyper015",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取人员某个业务系统的角色列表
var hyper016 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "",
"query_conditions": [
"COMMON"
],
"query_format": "json",
"query_id": "hyper016",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取人员某个业务系统的功能菜单
var hyper017 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "",
"query_conditions": [
"COMMON", 10
],
"query_format": "json",
"query_id": "hyper017",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取学段信息
var hyper018 = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "",
"query_conditions": [
],
"query_format": "json",
"query_id": "hyper018",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
*/
// 获取行政区
var ypt_hyper_xzq = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
"XZQ_CODE", "XZQ_ID", "XZQ_NAME"
],
"query_combinations": "XZQ_ID='200001'",
"query_conditions": [
],
"query_format": "json",
"query_id": "hyper_xzq",
"query_order": [
"XZQ_ID DESC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取行政区
var xpt_hyper_xzq = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
"XZQ_CODE", "XZQ_ID", "XZQ_NAME"
],
"query_combinations": "XZQ_ID='ffb460f249414c988b1869eba6ca679e'",
"query_conditions": [
],
"query_format": "json",
"query_id": "hyper_xzq",
"query_order": [
"XZQ_ID DESC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取机构(单位)
var ypt_hyper_jg = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
'DW_ID', 'DW_LB', 'DW_LBM', 'DW_MC', 'XZQ_ID', 'XZQ_Qu_ID', 'XZQ_Sheng_ID'
],
"query_combinations": "DW_LB='教育局' AND XZQ_Qu_ID=0",
"query_conditions": [
],
"query_format": "json",
"query_id": "hyper_jg",
"query_order": [
"DW_LBM ASC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取机构(单位)
var xpt_hyper_jg = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
'DW_ID', 'DW_LB', 'DW_LBM', 'DW_MC', 'XZQ_ID', 'XZQ_Qu_ID', 'XZQ_Sheng_ID'
],
"query_combinations": "DW_LB='学校' AND XZQ_Qu_ID='30592439ad9d4f669d9fcbb1dc1ec453'",
"query_conditions": [
],
"query_format": "json",
"query_id": "hyper_jg",
"query_order": [
"DW_LBM ASC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取学校
var ypt_hyper_school = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "XX_BXLX='小学'",
"query_conditions": [
2
],
"query_format": "json",
"query_id": "hyper_school",
"query_order": [
"XZQ_Qu_ID ASC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取学校
var xpt_hyper_school = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "XX_BXLX='幼儿园'",
"query_conditions": [
2
],
"query_format": "json",
"query_id": "hyper_school",
"query_order": [
"XZQ_Qu_ID ASC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取部门
var ypt_hyper_bm = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "BM_ID>400002",
"query_conditions": [
3, 400001
],
"query_format": "json",
"query_id": "hyper_bm",
"query_order": [
"BM_ID ASC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取部门
var xpt_hyper_bm = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "BM_MC!=''",
"query_conditions": [
3, 'f98cfdd5de99440d855aafb24ba47b52'
],
"query_format": "json",
"query_id": "hyper_bm",
"query_order": [
"BM_ID ASC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取年级
var ypt_hyper_nj = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "NJ_XD='小学'",
"query_conditions": [
400001
],
"query_format": "json",
"query_id": "hyper_nj",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取年级
var xpt_hyper_nj = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "NJ_XD='学前教育'",
"query_conditions": [
'097D57445AA54AAC958B8649A44ECEA9'
],
"query_format": "json",
"query_id": "hyper_nj",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取班级
var ypt_hyper_bj = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "BJ_MC LIKE '2017年%班'",
"query_conditions": [
400001, 2017
],
"query_format": "json",
"query_id": "hyper_bj",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取班级
var xpt_hyper_bj = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "BJ_MC LIKE '19%'",
"query_conditions": [
'097D57445AA54AAC958B8649A44ECEA9'
],
"query_format": "json",
"query_id": "hyper_bj",
"query_order": [
],
"query_page": 1,
"query_perpage": 20
}
// 获取教师(教职工)
var ypt_hyper_js = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "JS_XB='男'",
"query_conditions": [
400001, 5
],
"query_format": "json",
"query_id": "hyper_js",
"query_order": [
"BM_ID DESC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取教师(教职工)
var xpt_hyper_js = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "JS_XB='男'",
"query_conditions": [
5, '097D57445AA54AAC958B8649A44ECEA9'
],
"query_format": "json",
"query_id": "hyper_js",
"query_order": [
"BM_ID DESC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取学生
var ypt_hyper_xs = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "XS_XB='男'",
"query_conditions": [
400001
],
"query_format": "json",
"query_id": "hyper_xs",
"query_order": [
"XS_XM DESC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取学生
var xpt_hyper_xs = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "XS_XB='男'",
"query_conditions": [
6, '097D57445AA54AAC958B8649A44ECEA9'
],
"query_format": "json",
"query_id": "hyper_xs",
"query_order": [
"XS_XM DESC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取家长
var ypt_hyper_jz = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "JZ_XM LIKE '%家长'",
"query_conditions": [
400001
],
"query_format": "json",
"query_id": "hyper_jz",
"query_order": [
"JZ_ID DESC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取家长
var xpt_hyper_jz = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "JZ_XM LIKE '%家长'",
"query_conditions": [
7, '097D57445AA54AAC958B8649A44ECEA9'
],
"query_format": "json",
"query_id": "hyper_jz",
"query_order": [
"JZ_ID DESC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取用户角色
var ypt_hyper_yhjs = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "YHJS_SFDM>1",
"query_conditions": [
1, 1
],
"query_format": "json",
"query_id": "hyper_yhjs",
"query_order": [
"YHJS_ID ASC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取系统角色
var ypt_hyper_xtjs = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "YHJS_SFDM>1",
"query_conditions": [
'YPT'
],
"query_format": "json",
"query_id": "hyper_xtjs",
"query_order": [
"YHJS_ID ASC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取用户角色
var xpt_hyper_yhjs = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "YHJS_SFDM>1",
"query_conditions": [
'd704280d17d3480e8e609da36415ce8e'
],
"query_format": "json",
"query_id": "hyper_yhjs",
"query_order": [
"YHJS_ID ASC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取系统角色
var xpt_hyper_xtjs = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "YHJS_SFDM>1",
"query_conditions": [
],
"query_format": "json",
"query_id": "hyper_xtjs",
"query_order": [
"YHJS_ID ASC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取权限
var ypt_hyper_qx = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "QX_PID=350",
"query_conditions": [
'JY', '167, 197'
],
"query_format": "json",
"query_id": "hyper_qx",
"query_order": [
"QX_PID ASC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取权限
var xpt_hyper_qx = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "QX_PID='282b2da18eea462ba199f38bf950529f'",
"query_conditions": [
"64056dd8421c89e3d0bb8511526a7ace"
],
"query_format": "json",
"query_id": "hyper_qx",
"query_order": [
"QX_PID ASC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取数据字典
var ypt_hyper_sjzd = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "ZD_FLDM='xxlbm'",
"query_conditions": [
],
"query_format": "json",
"query_id": "hyper_sjzd",
"query_order": [
"ZD_DM DESC"
],
"query_page": 1,
"query_perpage": 20
}
// 获取数据字典
var xpt_hyper_sjzd = {
"access_token": "system_01##20200102030405##a6ce11eab94df48a6ce11eab",
"query_cols": [
],
"query_combinations": "ZD_FLDM='FAMILY_RELATIONSHIP'",
"query_conditions": [
],
"query_format": "json",
"query_id": "hyper_sjzd",
"query_order": [
"ZD_DM DESC"
],
"query_page": 1,
"query_perpage": 20
}
$(".button").click(function () {
var queryIds = $('.query_ids').val()
var queryArr = queryIds.split(",")
var selectedOption = $(".query_ids").find("option:selected");
var func = selectedOption.attr("func")
var requestUrl
//var platform = $("input[type='radio']:checked").val()
var platform
var queryId
$("#show_zone").html("")
for (const elem of queryArr) {
var elems = elem.split(":")
platform = elems[0]
queryId = elems[1]
requestUrl = "http://127.0.0.1:9009/dataex/hyper_" + platform + "/" + func
var jsonStr = JSON.stringify(eval(queryId), null, "\t")
//console.log(platform);
$.ajax({
type : "post",
url: requestUrl,
contentType:"application/json",
dataType: "json",
async: false,
data : JSON.stringify(eval(queryId)),
beforeSend : function(result) {
$("#show_zone").append("<p><strong> 平台 - " + platform + "</strong></p>")
$("#show_zone").append("<p>请求URL: </p>" + requestUrl)
$("#show_zone").append("<p>提交参数: </p>" + jsonStr)
},
//请求成功
success : function(result) {
console.log(result);
$("#show_zone").append("<p>执行结果: </p>" + JSON.stringify(result))
},
//请求失败,包含具体的错误信息
error : function(e){
console.log(e.status);
console.log(e.responseText);
},
complete : function (XMLHttpRequest, textStatus) {
// Do something
}
}).done(function() {
$(".print_box").html("ok!")
});
}
// if (queryId == "hyper011" || queryId == "hyper012" || queryId == "hyper013" || queryId == "hyper014") {
// requestUrl = "http://127.0.0.1:9009/dataex/hyper_" + platform + "/QueryByID"
// } else {
// requestUrl = "http://127.0.0.1:9009/dataex/hyper_" + platform + "/Query"
// }
/*
$.ajax({
type : "post",
url: requestUrl,
contentType:"application/json",
dataType: "json",
data : JSON.stringify(eval(queryId)),
beforeSend : function(result) {
$("#tip_zone").html("<p>提交参数: </p>" + jsonStr)
},
//请求成功
success : function(result) {
console.log(result);
$("#show_zone").html("<p>执行结果: </p>" + JSON.stringify(result), null, "\t")
},
//请求失败,包含具体的错误信息
error : function(e){
console.log(e.status);
console.log(e.responseText);
}
}).done(function() {
$(".print_box").html("ok!")
});
*/
})
});
</script>
</head>
<body>
<div data-role="page">
<div data-role="header">
<h1>基础数据超融合</h1>
</div><!-- /header -->
<div data-role="content">
<div id="container">
<div id="control_zone">
<p class="print_box">Hello world</p>
<select name="query_ids" class="query_ids">
<!--
<option value="ypt:hyper001" func="Query">获取市下的行政区划列表</option>
<option value="ypt:hyper002" func="Query">获取市下的单位列表</option>
<option value="ypt:hyper003" func="Query">获取区下的单位列表</option>
<option value="ypt:hyper004" func="Query">获取单位下的组织机构(部门)树</option>
<option value="ypt:hyper005" func="Query">获取组织机构(部门)下的教师列表</option>
<option value="ypt:hyper006" func="Query">获取学校的学段列表</option>
<option value="ypt:hyper007" func="Query">获取学校的入学年份列表</option>
<option value="ypt:hyper008" func="Query">获取学校的班级列表</option>
<option value="ypt:hyper009" func="Query">获取班级下的学生列表</option>
<option value="ypt:hyper010" func="Query">获取班级下的家长列表</option>
<option value="ypt:hyper011" func="QueryByID">获取单位信息</option>
<option value="ypt:hyper012" func="QueryByID">获取班级信息</option>
<option value="ypt:hyper013" func="QueryByID">获取教师信息</option>
<option value="ypt:hyper014" func="QueryByID">获取学生信息</option>
<option value="ypt:hyper015" func="Query">获取人员的所有角色列表</option>
<option value="ypt:hyper016" func="Query">获取人员某个业务系统的角色列表</option>
<option value="ypt:hyper017" func="Query">获取人员某个业务系统的功能菜单</option>
<option value="ypt:hyper018" func="Query">获取学段信息</option>
-->
<option value="ypt:ypt_hyper_xzq,xpt:xpt_hyper_xzq" func="Query">001 - 获取行政区</option>
<option value="ypt:ypt_hyper_jg,xpt:xpt_hyper_jg" func="Query">002 - 获取机构(单位)</option>
<option value="ypt:ypt_hyper_school,xpt:xpt_hyper_school" func="Query">003 - 获取学校</option>
<option value="ypt:ypt_hyper_bm,xpt:xpt_hyper_bm" func="Query">004 - 获取部门</option>
<option value="ypt:ypt_hyper_nj,xpt:xpt_hyper_nj" func="Query">005 - 获取年级</option>
<option value="ypt:ypt_hyper_bj,xpt:xpt_hyper_bj" func="Query">006 - 获取班级</option>
<option value="ypt:ypt_hyper_js,xpt:xpt_hyper_js" func="Query">007 - 获取教师(教职工)</option>
<option value="ypt:ypt_hyper_xs,xpt:xpt_hyper_xs" func="Query">008 - 获取学生</option>
<option value="ypt:ypt_hyper_jz,xpt:xpt_hyper_jz" func="Query">009 - 获取家长</option>
<option value="ypt:ypt_hyper_yhjs,xpt:xpt_hyper_yhjs" func="Query">010 - 获取用户角色</option>
<option value="ypt:ypt_hyper_xtjs,xpt:xpt_hyper_xtjs" func="Query">011 - 获取系统角色</option>
<option value="ypt:ypt_hyper_qx,xpt:xpt_hyper_qx" func="Query">012 - 获取权限</option>
<option value="ypt:ypt_hyper_sjzd,xpt:xpt_hyper_sjzd" func="Query">013 - 获取数据字典</option>
</select>
<button class="button" type='button'>GET IT !</button>
</div>
<!--<div id="tip_zone"></div>-->
<div id="show_zone"></div>
</div>
</div><!-- /content -->
</div><!-- /page -->
</body>
</html>