[关闭]
@lijiahong 2018-08-08T08:13:06.000000Z 字数 9551 阅读 492

山东商业职业技术学院JS

未分类

添加按钮、复选框

添加复选框

  1. function main(spreadsheetReport, isAjaxRefreshCallback) {
  2.     var useralias = imports("bof.usermanager.UserService").getInstance().getCurrentUser().alias;
  3.     var r = spreadsheetReport.getRowCount(); //获取电子表格总行数
  4.     for (var i = 2; i < r; i++) {
  5.         var td = spreadsheetReport.getCell(i, 10); //根据行列号获取单元格
  6.         var img = document.createElement("input");
  7.         img.type = "checkbox";
  8.         img.value = spreadsheetReport.getCell(i, 4).innerText;
  9.         //img.val2 = spreadsheetReport.getCell(i, 1).innerText;
  10.         img.val2 = useralias;
  11.         img.name = "deleteCheckbox";
  12.         $(td).html(img);
  13.     }
  14.     var td = spreadsheetReport.getCell(1, 10); //根据行列号获取单元格
  15.     var chx = document.createElement("input");
  16.     chx.type = "checkbox";
  17.     chx.name = "AllCheckbox";
  18.     chx.onclick = function() {
  19.         var objal = getByName("AllCheckbox");
  20.         if (objal[0].checked) {
  21.             var obj = getByName("deleteCheckbox");
  22.             for (k in obj) {
  23.                 obj[k].checked = true;
  24.             }
  25.         } else {
  26.             var obj = getByName("deleteCheckbox");
  27.             for (k in obj) {
  28.                 obj[k].checked = false;
  29.             }
  31.         }
  32.     }
  33.     td.appendChild(chx);
  34. }
  35. //兼容IE获取NAME
  36. function getByName(Name) {
  37.     var i=spreadsheetReport.elemSheetFrame.contentWindow.document.getElementsByTagName(Name);
  38.     if (i > 0) {
  39.         return i;
  40.     } else {
  41.         var aEle=spreadsheetReport.elemSheetFrame.contentWindow.document.getElementsByTagName('*');
  42.         var arr = [];
  43.         for (var i = 0; i < aEle.length; i++) {
  44.             if (aEle[i].getAttribute("name") == Name) {
  45.                 arr.push(aEle[i])
  46.             }
  47.         }
  48.         return arr;
  49.     }
  50. }

数据处理

  1. function main(spreadsheetReport, isAjaxRefreshCallback) {
  2. //将工具栏隐藏
  3.     if (spreadsheetReport.elem_trToolbar) {
  4.         spreadsheetReport.elem_trToolbar.style.display = "none";
  5.     }
  6.     //添加按钮的单元格（支持合并单元格）
  7.     var bjtd = spreadsheetReport.getCell(0, 9); //通过坐标获取单元格
  8.     //编辑按钮属性设置start
  9.     bjtd.style.cursor = "pointer"; //鼠标变手
  10.     var bjbt = document.createElement("input");
  11.     bjbt.type = "button";
  12.     bjbt.value = "编辑";//按钮名称
  13.     bjbt.name = "edit";//按钮name，建议唯一性
  14.     //编辑按钮相应事件start
  15.     bjbt.onclick = function() {
  16.         var y = 0;
  17.         var obj = getByName("deleteCheckbox");
  18.         for (var k in obj) {
  19.             if (obj[k].checked) {
  20.                 y = y + 1;//累加选择数
  21.             }
  22.         }
  23.         if (y === 0) {
  24.             alert("未选择任何数据");
  25.         }
  26.         if (y > 1) {
  27.             alert("选择数据太多了，只能选择一个");
  28.         }
  29.         if (y == 1) {
  30.             for (var k in obj) {
  31.                 if (obj[k].checked) {
  32.                     console.log(obj[k].value);//控制台输出数据（可选）
  33.                     console.log(obj[k].val2);//控制台输出数据（可选）
  34.                     var bmmc = seccode(b32sec(obj[k].val2));//获取部门名称
  35.                     var rwbh = seccode(b32sec(obj[k].value));//获取任务编号
  36.                     var res = "I53c0f01901649173917317960164fd9549cc6d9b";//定义跳转资源ID
  37.                     //定义URL
  38.                     var openUrls = "http://211.64.112.153/jxzg/vision/openresource.jsp?resid=I53c0f01901649173917317960164fdfbe9be7399" + "&bmmc=" + bmmc + "&rwbh=" + rwbh + "&res=" + res + "&showtoolbar=false&refresh=true";//定义打开的URL
  39.                     //弹出窗口
  40.                     var iWidth = 800; //弹出窗口的宽度;
  41.                     var iHeight = 700; //弹出窗口的高度;   
  42.                     var windowObj = "newwindow";
  43.                     var isChrome = window.navigator.userAgent.indexOf("Chrome") !== -1;
  44.                     var iTop = (window.screen.availHeight - 30 - iHeight) / 2; //获得窗口的垂直位置;
  45.                     var iLeft = (window.screen.availWidth - 10 - iWidth) / 2; //获得窗口的水平位置;
  46.                     if (isChrome) {
  47.                         curPopupWindow = window.open(openUrls, windowObj, 'height=' + iHeight + ',width=' + iWidth + ',top=' + iTop + ',left=' + iLeft + ',edge=raised, center=yes, help=no,toolbar=no,menubar=no,scrollbars=no, resizable=no,location=no,status=no');
  48.                     } else {
  49.                         curPopupWindow = window.showModelessDialog(openUrls, windowObj, "status:false;dialogWidth:" + iWidth + "px;dialogHeight:" + iHeight + "px;dialogLeft:" + iLeft + "px;dialogTop:" + iTop + "px;edge:Raised; center: Yes; help: No; resizable: No; status: No;scroll:no;");
  50.                     }
  51.                     //弹出窗口
  52.                 }
  53.             }
  56.         }
  58.     };
  59.     //编辑按钮响应事件end
  60.     //编辑按钮属性设置end
  62.     //导入按钮属性设置start
  63.     var drbt = document.createElement("input");
  64.     drbt.type = "button";
  65.     drbt.value = "导入";
  66.     drbt.name = "import";
  67.     //导入按钮响应事件start
  68.     drbt.onclick = function() {
  69.     //注释掉的这一段为自定义iframe打开方式，但是官方提供了较为方便的导入页面，但是灵活性差，故保留原来的。
  70.         //         var dialogFactory = jsloader.resolve("freequery.dialog.dialogFactory");
  71.         //         var dialogConfig = {
  72.         //             title: "任务数据导入",
  73.         //             size: dialogFactory.size.LARGE,
  74.         //             dialogType: "modeless",
  75.         //             fullName: "freequery.dialog.BaseDialogEx",
  76.         //             closeBeforeCallback: true
  77.         //         };
  78.         //         var data = {};
  79.         //         dialogFactory.showDialog(dialogConfig, data, doOnCloseDlg, this);
  80.         //         setTimeout(function() {
  81.         //          var url = 'http://211.64.112.153/jxzg/vision/openimportconfig.jsp?resid=I53c0f0190163ca3cca3cf95e0163dd3983be4b51';
  82.         //                 openReport(url)//openReport方法在最后
  83.         //             },
  84.         //             500);
  85.         if (!dialogFactory) {
  86.             var dialogFactory = jsloader.resolve("freequery.dialog.dialogFactory");
  87.         }
  88.         var dialogConfig = {};
  89.         dialogConfig.title = "Excel导入";//定义iframe标题
  90.         dialogConfig.size = dialogFactory.size.LARGE;
  91.         dialogConfig.fullName = "smartbi.spreadsheetreport.OpenImportConfigDialog";
  92.         var configs = new Array();
  93.         var importConfig = new Object();
  94.         importConfig.id = "I53c0f0190163ca3cca3cf95e0163dd3983be4b51";//定义导入资源ID //需要打开excel数据导入模板的ID
  95.         configs.push(importConfig);
  96.         dialogFactory.showDialog(dialogConfig, [configs], doOnCloseDlg, this);//doOnCloseDlg为iframe窗口销毁后执行的方法
  97.     };
  98.     //导入按钮响应事件end
  99.     //导入按钮属性设置start
  102.     //删除按钮属性设置start
  103.     var scbt = document.createElement("input");
  104.     scbt.type = "button";
  105.     scbt.value = "删除";
  106.     scbt.name = "deleteCheckbox";
  107.     //删除按钮响应事件start
  108.     scbt.onclick = function() {
  109.     var y = 0;
  110.         var flag = confirm("确认删除选中数据吗？");//弹出提示框
  111.         if (flag) {
  112.         //点击确认之后执行
  113.             var obj = getByName("deleteCheckbox");
  114.             var z = 0;
  115.             var x = 0;
  116.             for (k in obj) {
  117.                 if (obj[k].checked) {
  118.                     x = x + 1;//统计选择个数
  119.                     y = 1;
  120.                     console.log(obj[k].value);//控制台输出数据（可选）
  121.                     console.log(obj[k].val2);//控制台输出数据（可选）
  122.                     var bmmc = obj[k].val2;
  123.                     var rwbh = obj[k].value;
  124.                     var modalWindow = jsloader.resolve("freequery.common.modalWindow");
  125.                     var util = jsloader.resolve("freequery.common.util");
  126.                     var ret = util.remoteInvoke("DataSourceService", "executeUpdate", ["DS.HXK", "DELETE FROM HXK.RWGLCGRWYLB WHERE CGBMMC='" + bmmc + "' AND CGRWBH='" + rwbh + "'"]); //执行删除数据的sql
  127.                     if (!ret.succeeded) {
  128.                         z = z + 1;//统计删除成功数
  129.                     }
  130.                 }
  131.             }
  132.             if (y == 0) {
  133.                 alert("未选择任何数据");
  135.             } else {
  136.                 if (z == 0) {
  137.                     alert("成功删除" + x + "条记录");
  138.                     spreadsheetReport.doRefresh();//报表刷新
  139.                 } else {
  140.                     alert("共选择" + z + "条记录," + "删除失败" + z + "条记录");
  141.                     spreadsheetReport.doRefresh();
  142.                 }
  143.             }
  144.         }
  145.     }
  146.     //删除按钮响应事件end
  147.     //删除按钮属性设置end
  149.     //导出按钮属性设置start
  150.     var dcbt = document.createElement("input");
  151.     dcbt.type = "button";
  152.     dcbt.value = "导出";
  153.     dcbt.name = "outputbutton";
  154.     //导出按钮响应事件start
  155.     dcbt.onclick = function() {
  156.         spreadsheetReport.doExportMenuCloseUp("EXCEL");//直接导出为excel
  157.     }
  158.    //导出按钮响应事件end
  159.     //导出按钮属性设置end
  161.     //添加按钮属性设置start
  162.     var tjbt = document.createElement("input");
  163.     tjbt.type = "button";
  164.     tjbt.value = "添加";
  165.     tjbt.name = "insertbutton";
  166.      //添加按钮相应事件start
  167.     tjbt.onclick = function() {
  168.         var useralias = imports("bof.usermanager.UserService").getInstance().getCurrentUser().alias;
  169.         var bmmc = seccode(b32sec(useralias));
  170.         var rwbh = seccode(b32sec("请输入任务编号"));
  171.         var res = "I53c0f019016491739173179601651352535c7744";
  172.         //定义URL
  173.         var openUrls = "http://211.64.112.153/jxzg/vision/openresource.jsp?resid=I53c0f01901649173917317960164fdfbe9be7399" + "&bmmc=" + bmmc + "&rwbh=" + rwbh + "&res=" + res + "&showtoolbar=false&refresh=true";
  174.         //弹出窗口
  175.         var iWidth = 800; //弹出窗口的宽度;
  176.         var iHeight = 700; //弹出窗口的高度;   
  177.         var windowObj = "newwindow";
  178.         var isChrome = window.navigator.userAgent.indexOf("Chrome") !== -1;
  179.         var iTop = (window.screen.availHeight - 30 - iHeight) / 2; //获得窗口的垂直位置;
  180.         var iLeft = (window.screen.availWidth - 10 - iWidth) / 2; //获得窗口的水平位置;
  181.         if (isChrome) {
  182.             curPopupWindow = window.open(openUrls, windowObj, 'height=' + iHeight + ',width=' + iWidth + ',top=' + iTop + ',left=' + iLeft + ',edge=raised, center=yes, help=no,toolbar=no,menubar=no,scrollbars=no, resizable=no,location=no,status=no');
  183.         } else {
  184.             curPopupWindow = window.showModelessDialog(openUrls, windowObj, "status:false;dialogWidth:" + iWidth + "px;dialogHeight:" + iHeight + "px;dialogLeft:" + iLeft + "px;dialogTop:" + iTop + "px;edge:Raised; center: Yes; help: No; resizable: No; status: No;scroll:no;");
  185.         }
  186.     }
  187.     //添加按钮相应事件end
  188.     //添加按钮属性设置end
  190.     //刷新按钮属性设置start
  191.     var sxbt = document.createElement("input");
  192.     sxbt.type = "button";
  193.     sxbt.value = "刷新";
  194.     sxbt.name = "Refreshbutton";
  195.     sxbt.onclick = function() {
  196.         spreadsheetReport.doRefresh();
  197.     }
  198.     //刷新按钮属性设置end
  200.     //单元格中添加按钮事件，按照顺序分别为刷新，添加，编辑，删除，导入，导出
  201.     bjtd.appendChild(sxbt);
  202.     bjtd.appendChild(tjbt);
  203.     bjtd.appendChild(bjbt);
  204.     bjtd.appendChild(scbt);
  205.     bjtd.appendChild(drbt);
  206.     bjtd.appendChild(dcbt);
  207. }
  208. //转换方法start
  209. function seccode(s) {
  210.     var len = s.length;
  211.     var rs = "";
  212.     for (var i = 0; i < len; i++) {
  213.         var k = s.substring(i, i + 1);
  214.         rs += (i == 0 ? "" : ",") + s.charCodeAt(i);
  215.     }
  216.     return rs;
  217. }
  219. function b32sec(str) {
  220.     return btoa(encodeURIComponent(str).replace(/%([0-9A-F]{2})/g, function(match, p1) {
  221.         return String.fromCharCode('0x' + p1);
  222.     }));
  223. }
  224. //转换方法end
  226. //兼容IE获取复选框name
  227. function getByName(Name) {
  228.     var i=spreadsheetReport.elemSheetFrame.contentWindow.document.getElementsByTagName(Name);
  229.     if (i > 0) {
  230.         return i;
  231.     } else {
  232.         var aEle=spreadsheetReport.elemSheetFrame.contentWindow.document.getElementsByTagName('*');
  233.         var arr = [];
  234.         for (var i = 0; i < aEle.length; i++) {
  235.             if (aEle[i].getAttribute("name") == Name) {
  236.                 arr.push(aEle[i])
  237.             }
  238.         }
  239.         return arr;
  240.     }
  241. }
  242. //iframe关闭相应事件方法
  243. function doOnCloseDlg() {
  244.     spreadsheetReport.doRefresh();
  245. }
  246. //自定义iframe打开链接方法
  247. // function openReport(url) {
  248. //     // 替换成你的目标资源的url
  249. //     //var url = 'http://211.64.112.153/jxzg/vision/openimportconfig.jsp?resid=I53c0f0190163ca3cca3cf95e0163dd3983be4b51';
  250. //     var domutils = jsloader.resolve('freequery.lang.domutils');
  251. //     var elem = window.dialog.dialogBody;
  252. //     var btnOK = window.dialog.btnOK;
  253. //     var btnCancel = window.dialog.btnCancel;
  254. //     btnOK.style.display = 'none'
  255. //     btnCancel.value = '关闭(C)';
  256. //     elem.innerHTML = '<iframe src="' + url + '" width="100%" height="100%" border="0" frameSpacing="0" frameBorder="0"></iframe>'
  257. // }

选中行高亮

  1. function main(spreadsheetReport, isAjaxRefreshCallback) {
  2.     spreadsheetReport.initTableGrid();
  3.     var B3List = spreadsheetReport.getExpandedPositions("C3"); //表格扩展字段起始位置
  4.     var B3_Start = spreadsheetReport.parseCellIndex(B3List[0])[0]; //解析出行号
  5.     var B3_End = spreadsheetReport.parseCellIndex(B3List[B3List.length - 1])[0];
  6.     spreadsheetReport.addListener(spreadsheetReport.elemSheetFrame.contentWindow.document.body, "click",
  7.         function(e) {
  8.             var t = e.target;
  9.             while (t && t.tagName != "TR") {
  10.                 t = t.parentNode;
  11.             }
  12.             if (!t) return;
  13.             var _focusTR = this._focusTR;
  14.             var startCol;
  15.             var endCol;
  16.             if (t.rowIndex >= B3_Start && t.rowIndex <= B3_End) {
  17.                 this._focusTR = t;
  18.                 startCol = 1; //表格起始列，从0开始计算
  19.                 endCol = 10; //表格终止列，从0开始计算
  20.             }
  22.             if (_focusTR) {
  23.                 var rowTd = this.tableGrid[_focusTR.rowIndex];
  24.                 for (var i = this._focusStartCol; i <= this._focusEndCol; i++) {
  25.                     rowTd[i].style.backgroundColor = rowTd[i]._originalBackgroundColor
  26.                 }
  27.             }
  28.             this._focusStartCol = startCol;
  29.             this._focusEndCol = endCol;
  30.             var rowTd = this.tableGrid[t.rowIndex];
  31.             for (var i = startCol; i <= endCol; i++) {
  32.                 if (typeof rowTd[i]._originalBackgroundColor == "undefined") {
  33.                     rowTd[i]._originalBackgroundColor = rowTd[i].style.backgroundColor;
  34.                 }
  35.                 rowTd[i].style.backgroundColor = "#AEEEEE";//颜色
  36.             }
  37.         },
  38.         spreadsheetReport, "sheetFrameBody");
  39. }
添加新批注
在作者公开此批注前，只有你和作者可见。
回复批注