表单：
<div id="complex" class="mini-complex" style="background: rgb(255, 255, 255); padding: 2px 20px 10px; box-shadow: rgb(144, 144, 144) 0px 0px 5px; margin: 10px auto 12px; font-size: 14px; position: relative; height: 1000px; width: 660px;"> <p style="text-align: center;"> <strong><span style="font-size: 24px;"><br/></span></strong> </p> <p style="text-align: center;"> <strong><span style="font-size: 24px;">学生集体外出实习备案</span></strong><br/> </p> <p style="margin-bottom: 25px;"> <strong><span style="font-size: 24px;"></span></strong> </p> <table style="table-layout: fixed;border-collapse:collapse;border:2px solid black;" data-sort="sortDisabled" align="center"> <tbody> <tr class="firstRow"> <td valign="middle" align="center" colspan="1" rowspan="1" height="27" style="border-color: rgb(38, 38, 38); word-break: break-all;" width="93.33333333333333"> 申请人姓名 </td> <td valign="middle" align="center" colspan="1" rowspan="1" height="27" style="border-color: rgb(38, 38, 38); word-break: break-all;" width="140.33333333333334"> <input class="mini-textbox" choosevalue="CURRENTUSER" required="true" fieldtype="ordinary" allowinput="true" isshowonlist="1" datasourcetype="url" fldorder="0" enfield="SQRXM" cnfield="申请人姓名" adaptive="true" multiselect="false" showclearbutton="false" allowlimitvalue="false" maxlength="200" style="width: 100%;" type="mini-textbox" ziti="MicrosoftYaHei" zihao="fourteen" emptytext="" data-options="{"emptytext":""}"/><br/> </td> <td valign="middle" align="center" colspan="1" rowspan="1" height="27" style="border-color: rgb(38, 38, 38); word-break: break-all;" width="102.33333333333333"> 申请人工号 </td> <td valign="middle" align="center" colspan="1" rowspan="1" height="27" style="border-color: rgb(38, 38, 38);" width="135.33333333333334"> <input class="mini-textbox" choosevalue="CURRENTUSERID" required="true" fieldtype="ordinary" allowinput="true" isshowonlist="1" datasourcetype="url" fldorder="1" enfield="SQRGH" cnfield="申请人工号" adaptive="true" multiselect="false" showclearbutton="false" allowlimitvalue="false" maxlength="200" style="width: 100%;" type="mini-textbox" ziti="MicrosoftYaHei" zihao="fourteen" emptytext="" data-options="{"emptytext":""}"/><br/> </td> </tr> <tr> <td style="border-color: rgb(38, 38, 38); word-break: break-all;" width="125.33333333333333" valign="middle" align="center"> 带队教师姓名 </td> <td style="border-color: rgb(38, 38, 38); word-break: break-all;" width="140.33333333333334" valign="middle" align="center"> <input class="mini-textbox" choosevalue="CURRENTUSER" required="true" fieldtype="ordinary" allowinput="true" isshowonlist="1" datasourcetype="url" fldorder="1" enfield="DDJSXM" cnfield="带队教师姓名" adaptive="true" multiselect="false" showclearbutton="false" allowlimitvalue="false" maxlength="200" style="width: 100%;" emptytext="" data-options="{"emptytext":"","id":"DDJSXM"}"/><br/> </td> <td style="border-color: rgb(38, 38, 38); word-break: break-all;" width="95.33333333333333" valign="middle" align="center"> 带队教师工号 </td> <td style="border-color: rgb(38, 38, 38); word-break: break-all;" width="137.33333333333334" valign="middle" align="center"> <input class="mini-textbox" choosevalue="CURRENTUSERID" required="true" fieldtype="ordinary" allowinput="true" isshowonlist="1" datasourcetype="url" fldorder="2" enfield="DDJSGH" cnfield="带队教师工号" adaptive="true" multiselect="false" style="width: 100%;" showclearbutton="false" allowlimitvalue="false" maxlength="200" data-options="{"emptytext":""}" type="mini-textbox" ziti="MicrosoftYaHei" zihao="fourteen" emptytext="" linkageurl="/queryservice/query.htm?snumber=CXZDJSXX&ZDJSGH=INPUTVALUE" datasourceurl="" relatefield_1="cnfield=指导教师姓名;enfield=JSXM;datatype=value;icon=;key=ZDJSXM;" relatefield_2="cnfield=联系电话;enfield=LXDH;datatype=value;icon=;key=LXDH;" relatefield_3="cnfield=专业负责人;enfield=ZYFZR;datatype=data;icon=;key=;"/><br/> </td> </tr> <tr> <td style="border-color: rgb(38, 38, 38); word-break: break-all;" width="125.33333333333333" valign="middle" align="center"> 所在单位 </td> <td style="border-color: rgb(38, 38, 38);" width="140.33333333333334" valign="middle" align="center"> <input class="mini-textbox" choosevalue="other" required="true" fieldtype="ordinary" allowinput="true" isshowonlist="1" datasourcetype="url" fldorder="4" enfield="SZDW" cnfield="所在单位" adaptive="true" multiselect="false" style="width: 100%;" showclearbutton="false" allowlimitvalue="false" maxlength="200" data-options="{"emptytext":""}" type="mini-textbox" ziti="MicrosoftYaHei" zihao="fourteen" emptytext="" datasourceurl="/queryservice/query.htm?snumber=CXBMMC&HUMANCODE=STARTID" urlkey="DWMC"/><br/> </td> <td style="border-color: rgb(38, 38, 38); word-break: break-all;" width="102.33333333333333" valign="middle" align="center"> 联系电话 </td> <td style="border-color: rgb(38, 38, 38);" width="137.33333333333334" valign="middle" align="center"> <input class="mini-textbox" choosevalue="CURRENTUSERMOBILETEL" required="true" fieldtype="ordinary" allowinput="true" isshowonlist="1" datasourcetype="url" fldorder="5" enfield="LXDH" cnfield="联系电话" adaptive="true" multiselect="false" style="width: 100%;" showclearbutton="false" allowlimitvalue="false" maxlength="200" data-options="{"emptytext":""}" type="mini-textbox" ziti="MicrosoftYaHei" zihao="fourteen" emptytext=""/><br/> </td> </tr> <tr> <td style="border-color: rgb(38, 38, 38); word-break: break-all;" width="125.33333333333333" valign="middle" align="center"> 参加人数 </td> <td style="border-color: rgb(38, 38, 38); word-break: break-all;" valign="middle" align="center" rowspan="1" colspan="3"> <input class="mini-textbox" choosevalue="other" required="true" fieldtype="ordinary" allowinput="true" isshowonlist="1" datasourcetype="url" fldorder="6" enfield="RS" cnfield="参加人数" adaptive="false" multiselect="false" showclearbutton="false" allowlimitvalue="false" maxlength="200" style="width:60%;" type="mini-textbox" ziti="MicrosoftYaHei" zihao="fourteen" data-options="{"vtype":"int","textAlign":"center"}" vtype="int" inputstyle="text-align:center;"/>人<br/> </td> </tr> <tr> <td style="border-color: rgb(38, 38, 38); word-break: break-all;" rowspan="1" colspan="4" valign="middle" height="27" align="center" width="98.00000000000004"> <strong>实习学生信息</strong><br/> </td> </tr> <tr> <td style="border-color: rgb(38, 38, 38); word-break: break-all;" rowspan="1" colspan="4" valign="middle" height="27" align="center" width="98.00000000000004"> <img src="../../resources/images/flow/datagrid.png" datagrid_style="width: 100%; height: 200px;" datagrid_class="mini-datagrid" datagrid_idfield="id" datagrid_showpager="false" datagrid_fldorder="7" datagrid_cnfield="实习学生名单" datagrid_enfield="SXXSMD" showaddbtn="true" showdelbtn="true" showinbtn="true" showupbtn="true" showdownbtn="true" maxgridrows="500" loadcontext="true" shownumber="false" adaptive="true" datagridfield_1="class=mini-textbox;field=XH;name=负责人学号;required=true;align=left;allowinput=true;allowsort=true;maxLength=200;emptytext=;stylewidth=80;stylewidthtype=%;linkageurl=%2Fqueryservice%2Fquery.htm%3Fsnumber%3DCXXMZYBJ%26user_id%3DINPUTVALUE;reactionData=%5B%7B%22datatype%22%3A%22value%22%2C%22_id%22%3A1%2C%22_uid%22%3A1%2C%22_state%22%3A%22added%22%2C%22enfield%22%3A%22XM%22%2C%22cnfield%22%3A%22%E8%B4%9F%E8%B4%A3%E4%BA%BA%E5%A7%93%E5%90%8D%22%2C%22key%22%3A%22XM%22%7D%2C%7B%22datatype%22%3A%22value%22%2C%22_id%22%3A2%2C%22_uid%22%3A2%2C%22_state%22%3A%22added%22%2C%22enfield%22%3A%22BJ%22%2C%22cnfield%22%3A%22%E5%AE%9E%E4%B9%A0%E7%8F%AD%E7%BA%A7%22%2C%22key%22%3A%22BJMC%22%7D%2C%7B%22datatype%22%3A%22value%22%2C%22_id%22%3A3%2C%22_uid%22%3A3%2C%22_state%22%3A%22added%22%2C%22enfield%22%3A%22HTDE4690%22%2C%22cnfield%22%3A%22%E8%B4%9F%E8%B4%A3%E4%BA%BA%E7%94%B5%E8%AF%9D%22%2C%22key%22%3A%22SJH%22%7D%5D;vtype=undefined;choosevalue=other;" stylewidth="80" stylewidthtype="%" fieldname_1="负责人学号" datagridfield_2="class=mini-textbox;field=XM;name=负责人姓名;required=false;align=left;allowinput=true;allowsort=true;maxLength=200;emptytext=;stylewidth=80;stylewidthtype=%;linkageurl=;reactionData=%5B%5D;vtype=undefined;choosevalue=other;" fieldname_2="负责人姓名" required="true" fieldname_3="专业" datagridfield_4="class=mini-textbox;field=BJ;name=实习班级;required=false;align=left;allowinput=true;allowsort=true;maxLength=200;emptytext=;stylewidth=80;stylewidthtype=%;linkageurl=;reactionData=%5B%5D;vtype=undefined;choosevalue=other;" fieldname_4="实习班级" name="未定义列" field="HT44EB6B" data="[{"id":"是","text":"是","_id":1,"_uid":1,"_state":"modified"},{"id":"否","text":"否","_id":2,"_uid":2,"_state":"modified"}]" fieldname_5="负责人电话" fieldname_6="是否离校" fieldname_7="实习单位名称" fieldname_8="实习单位地址（省市县区）" fieldname_9="实习开始时间" fieldname_10="实习结束时间" fieldname_11="备注" data-options="{"shownumber":"false","mingridrows":1,"showinbtn":"true","showupbtn":"true","showdownbtn":"true"}" mingridrows="1" type="mini-datagrid" datagridfield_5="class=mini-textbox;field=HTDE4690;name=负责人电话;required=true;align=left;allowinput=true;allowsort=true;maxLength=200;emptytext=;stylewidth=80;stylewidthtype=%;linkageurl=;reactionData=%5B%5D;vtype=undefined;choosevalue=other;" relatefield_1="cnfield=负责人姓名;enfield=XM;datatype=value;icon=;key=XM;" relatefield_2="cnfield=实习班级;enfield=BJ;datatype=value;icon=;key=BJMC;" relatefield_3="cnfield=负责人电话;enfield=HTDE4690;datatype=value;icon=;key=SJH;"/><br/> </td> </tr> <tr> <td valign="middle" align="center" colspan="1" rowspan="1" height="27" style="border-color: rgb(38, 38, 38); word-break: break-all;"> 实习课程号 </td> <td valign="middle" align="center" colspan="1" rowspan="1" height="27" style="border-color: rgb(38, 38, 38);"></td> <td valign="middle" align="center" colspan="1" rowspan="1" height="27" style="border-color: rgb(38, 38, 38); word-break: break-all;"> 实习课程名 </td> <td valign="middle" align="center" colspan="1" rowspan="1" height="27" style="border-color: rgb(38, 38, 38);"></td> </tr> <tr> <td valign="middle" align="center" colspan="1" rowspan="1" height="27" style="border-color: rgb(38, 38, 38); word-break: break-all;"> 离校时间 </td> <td valign="middle" align="center" colspan="1" rowspan="1" height="27" style="border-color: rgb(38, 38, 38);"> <input class="mini-datepicker" choosevalue="other" required="true" fieldtype="ordinary" allowinput="true" isshowonlist="1" datasourcetype="url" fldorder="8" enfield="LXSJ" cnfield="离校时间" adaptive="true" multiselect="false" showclearbutton="false" allowlimitvalue="false" style="width: 100%;" showtime="false" tagtype="mini-datepicker" datetimetype="mini-datepicker" mindate="" maxdate="" data-options="{"minDate":"","maxDate":"","showStyle":"rung","dateScope":"false","manyDateScope":"false","nowDateAfter":"false","dateFixedScope":"false","workDate":"false"}" showsignaturedateformat="rung" type="mini-datepicker" ziti="MicrosoftYaHei" zihao="fourteen"/><br/> </td> <td valign="middle" align="center" colspan="1" rowspan="1" height="27" style="border-color: rgb(38, 38, 38); word-break: break-all;"> 返校时间 </td> <td valign="middle" align="center" colspan="1" rowspan="1" height="27" style="border-color: rgb(38, 38, 38);"> <input class="mini-datepicker" choosevalue="other" required="true" fieldtype="ordinary" allowinput="true" isshowonlist="1" datasourcetype="url" fldorder="9" enfield="FXSJ" cnfield="返校时间" adaptive="true" multiselect="false" showclearbutton="false" allowlimitvalue="false" style="width: 100%;" showtime="false" tagtype="mini-datepicker" datetimetype="mini-datepicker" mindate="" maxdate="" data-options="{"minDate":"","maxDate":"","showStyle":"rung","dateScope":"false","manyDateScope":"false","nowDateAfter":"false","dateFixedScope":"false","workDate":"false"}" showsignaturedateformat="rung" datescope="false" type="mini-datepicker" ziti="MicrosoftYaHei" zihao="fourteen"/><br/> </td> </tr> <tr> <td valign="middle" align="center" colspan="1" rowspan="1" height="27" style="border-color: rgb(38, 38, 38); word-break: break-all;"> 实习地点 </td> <td valign="middle" align="center" colspan="3" rowspan="1" height="27" style="border-color: rgb(38, 38, 38);"> <input class="mini-textarea" choosevalue="other" required="true" fieldtype="ordinary" allowinput="true" isshowonlist="1" datasourcetype="url" fldorder="10" enfield="DD" cnfield="实习地点" adaptive="true" multiselect="false" showclearbutton="false" allowlimitvalue="false" style="width: 100%; height: 100%;" maxlength="200" type="mini-textarea" ziti="MicrosoftYaHei" zihao="fourteen"/><br/> </td> </tr> <tr> <td valign="middle" align="center" colspan="1" rowspan="1" height="27" style="border-color: rgb(38, 38, 38); word-break: break-all;"> 外出管理措施 </td> <td valign="middle" align="center" colspan="3" rowspan="1" height="27" style="border-color: rgb(38, 38, 38); word-break: break-all;"> <input class="mini-textarea" choosevalue="other" required="true" fieldtype="ordinary" allowinput="true" isshowonlist="1" datasourcetype="url" fldorder="11" enfield="WCGLCS" cnfield="外出管理措施" adaptive="true" multiselect="false" showclearbutton="false" allowlimitvalue="false" style="width: 100%; height: 100%;" maxlength="200" type="mini-textarea" ziti="MicrosoftYaHei" zihao="fourteen"/><br/> </td> </tr> <tr> <td style="border-color: rgb(38, 38, 38); word-break: break-all;" width="125.33333333333333" valign="middle" height="27" align="center"> 辅导员 </td> <td style="border-color: rgb(38, 38, 38); word-break: break-all;" valign="middle" height="27" align="center" rowspan="1" colspan="3" width="445.3333333333333"> <input class="mini-textbox" choosevalue="other" required="true" fieldtype="ordinary" allowinput="true" isshowonlist="1" datasourcetype="url" fldorder="12" enfield="FDYXM" cnfield="辅导员" adaptive="true" multiselect="false" style="width: 100%;" showclearbutton="false" allowlimitvalue="false" maxlength="200" data-options="{"id":"FDYXM","type":"COUNTDAY"}" type="mini-textbox" ziti="MicrosoftYaHei" zihao="fourteen"/><br/> </td> </tr> </tbody> </table> <input class="mini-textbox" choosevalue="other" required="true" fieldtype="ordinary" allowinput="true" isshowonlist="0" datasourcetype="url" fldorder="13" enfield="FDYGH" cnfield="辅导员审批" adaptive="false" multiselect="false" showclearbutton="false" allowlimitvalue="false" maxlength="200" data-options="{"id":"FDYGH","type":"COUNTDAY"}" style="width:40%;" type="mini-textbox" ziti="MicrosoftYaHei" zihao="fourteen"/> <p style="margin-bottom: 25px; text-align: left;"> <img class="flow-javascript" src="../../style/flow/img/javascript.png" choosevalue="other" enfield="HTA261E6" cnfield="脚本控件" style="width: 18px; height: 18px; display: block;" method="var datagrid = mini.get('SXXSMD'); //多行表单英文名称 SXXSMD datagrid.on('cellendedit',function(e){ if(e.field == 'XH'){ //多行表单学号 if(e.row.XH){ var row = e.row; $.ajax({ //通用查询地址+根据哪个控件值 url:'${basePath}queryservice/query.htm?snumber=CXXMZYBJ&user_id='+row.XH, dataType:'json', async:false, success:function(text){ if (Array.isArray(text)) { row.XM = text[0].XM; //row.ZY = text[0].XYMC; row.BJ = text[0].BJMC; datagrid.commitEditRow ( row ); var bj = row.BJ; setFdy(bj) } }, }); } } }); datagrid.on('preload',function(e){ debugger; console.log(e.sender.data); var data = e.sender.data; for(var i=0;i<data.length;i++){ var row = data[i]; var row = e.row; $.ajax({ //通用查询地址+根据哪个控件值 url:'${basePath}queryservice/query.htm?snumber=CXXMZYBJ&user_id='+row.XH, dataType:'json', async:false, success:function(text){ if (Array.isArray(text)) { row.XM = text[0].XM; //row.ZY = text[0].XYMC; row.BJ = text[0].BJMC; datagrid.commitEditRow(row); var bj = row.BJ; setFdy(bj); } }, }); } }); function setFdy(bj){ var fdy_ids = mini.get("FDYGH").getValue(); var fdy_names = mini.get("FDYXM").getValue(); var fdy_id_arr = fdy_ids.split(","); var fdy_name_arr = fdy_names.split(","); if(bj){ $.ajax({ methods: 'GET', dataType:'json', async:false, url: "${basePath}queryservice/query.htm?snumber=CXFDY&orgname=" + bj, success: function (res) { if(res){ for(var i=0;i<res.length;i++){ var fdy_obj = res[i]; var fdy_id = fdy_obj.HUMANCODE; var fdy_name = fdy_obj.HUMANNAME; fdy_id_arr.push(fdy_id); fdy_name_arr.push(fdy_name); } let fyd_id_set = [...new Set(fdy_id_arr)]; fdy_ids = [...fyd_id_set].join(','); let fyd_name_set = [...new Set(fdy_name_arr)]; fdy_names = [...fyd_name_set].join(','); } if(fdy_names.indexOf(",")==0 ){ fdy_names = fdy_names.substring(1, fdy_names.length); } if(fdy_ids.indexOf(",")==0 ){ fdy_ids = fdy_ids.substring(1, fdy_ids.length); } mini.get("FDYGH").setValue(fdy_ids); mini.get("FDYXM").setValue(fdy_names); }, error: function (err) { reject(err) } }) } } $('#delbar_SXXSMD').click(function () { debugger; var data = datagrid.getData(); if(data.length >0){ mini.get("FDYGH").setValue(""); mini.get("FDYXM").setValue(""); for(var i=0;i<data.length;i++){ var row = data[i]; var bj = row.BJ; setFdy(bj); } }else{ mini.get("FDYGH").setValue(""); mini.get("FDYXM").setValue(""); } });"/> </p> </div>
JS:
var datagrid = mini.get('SXXSMD'); //多行表单英文名称 SXXSMD datagrid.on('cellendedit',function(e){ if(e.field == 'XH'){ //多行表单学号 if(e.row.XH){ var row = e.row; $.ajax({ //通用查询地址+根据哪个控件值 url:'${basePath}queryservice/query.htm?snumber=CXXMZYBJ&user_id='+row.XH, dataType:'json', async:false, success:function(text){ if (Array.isArray(text)) { row.XM = text[0].XM; //row.ZY = text[0].XYMC; row.BJ = text[0].BJMC; datagrid.commitEditRow ( row ); var bj = row.BJ; setFdy(bj) } }, }); } } }); datagrid.on('preload',function(e){ debugger; console.log(e.sender.data); var data = e.sender.data; for(var i=0;i<data.length;i++){ var row = data[i]; var row = e.row; $.ajax({ //通用查询地址+根据哪个控件值 url:'${basePath}queryservice/query.htm?snumber=CXXMZYBJ&user_id='+row.XH, dataType:'json', async:false, success:function(text){ if (Array.isArray(text)) { row.XM = text[0].XM; //row.ZY = text[0].XYMC; row.BJ = text[0].BJMC; datagrid.commitEditRow(row); var bj = row.BJ; setFdy(bj); } }, }); } }); function setFdy(bj){ var fdy_ids = mini.get("FDYGH").getValue(); var fdy_names = mini.get("FDYXM").getValue(); var fdy_id_arr = fdy_ids.split(","); var fdy_name_arr = fdy_names.split(","); if(bj){ $.ajax({ methods: 'GET', dataType:'json', async:false, url: "${basePath}queryservice/query.htm?snumber=CXFDY&orgname=" + bj, success: function (res) { if(res){ for(var i=0;i<res.length;i++){ var fdy_obj = res[i]; var fdy_id = fdy_obj.HUMANCODE; var fdy_name = fdy_obj.HUMANNAME; fdy_id_arr.push(fdy_id); fdy_name_arr.push(fdy_name); } let fyd_id_set = [...new Set(fdy_id_arr)]; fdy_ids = [...fyd_id_set].join(','); let fyd_name_set = [...new Set(fdy_name_arr)]; fdy_names = [...fyd_name_set].join(','); } if(fdy_names.indexOf(",")==0 ){ fdy_names = fdy_names.substring(1, fdy_names.length); } if(fdy_ids.indexOf(",")==0 ){ fdy_ids = fdy_ids.substring(1, fdy_ids.length); } mini.get("FDYGH").setValue(fdy_ids); mini.get("FDYXM").setValue(fdy_names); }, error: function (err) { reject(err) } }) } } $('#delbar_SXXSMD').click(function () { debugger; var data = datagrid.getData(); if(data.length >0){ mini.get("FDYGH").setValue(""); mini.get("FDYXM").setValue(""); for(var i=0;i<data.length;i++){ var row = data[i]; var bj = row.BJ; setFdy(bj); } }else{ mini.get("FDYGH").setValue(""); mini.get("FDYXM").setValue(""); } });
通用查询：
CXXMZYBJ：
select a.humanname as XM,e.xh, e.xymc,e.zymc,e.bjmc,a.telmobile1 as SJH from ht_sys_user a,( select a.orgname as XYMC ,c.ZYMC AS ZYMC,c.BJMC AS BJMC ,c.user_id as XH from HT_SYS_ORGANIZATION a,( select a.orgname as ZYMC,b.orgname as BJMC ,a.parent ,b.user_id from HT_SYS_ORGANIZATION a , (select a.orgname,a.parent,b.user_id from HT_SYS_ORGANIZATION a,HT_SYS_ORGANIZATION_USER b where a.id =b.organization_id and b.user_id='${user_id}') b where a.id = b.parent) c where a.id =c.parent) e where a.id =e.xh
截图：
