| | |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>æé®è®¾ç½®</button> |
| | |
| | | var sWhere = ""; |
| | | var HModName = "Xs_CusBalanceReport"; |
| | | //ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | var titleData = ["客æ·å
ç ","å¸å«å
ç ","ç»ç»å
ç "]; |
| | | var titleData = ["客æ·å
ç ", "å¸å«å
ç ", "ç»ç»å
ç "]; |
| | | |
| | | var ins; //ç¨äºå¯¼åºexcel |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢å³å è½½ |
| | |
| | | switch (obj.event) { |
| | | //å·æ° |
| | | case 'get_Refresh': get_Refresh(); |
| | | break; |
| | | //导åºexcel |
| | | case 'get_export': |
| | | get_Export(); |
| | | break; |
| | | //éåºæé® |
| | | case 'get_Exit': Pub_Close(2); |
| | |
| | | } |
| | | }); |
| | | }) |
| | | //#endregion |
| | | |
| | | //#region å廿¥çå ç¨é¢åº¦æç» |
| | | table.on('rowDouble(mainTable)', function (obj) { |
| | | //éä¸é«äº® åå»è¡ |
| | | obj.tr.find(':checkbox').prop('checked', true); |
| | | obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //设置å¤éæ¡é䏿 ·å¼ |
| | | $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//æ¹åå½åtrèæ¯é¢è²ååä½é¢è² |
| | | //mainTable ä¸ºè¡¨æ ¼ID æ³¨ææ¤å¤å¦æID䏿£ç¡®å°å¯¼è´ä½ å¨çå¬å¤éæ¡æ¶è·åä¸å°ä½ éæ©çæ°æ®ï¼åé¢çåªæ¯æ·»å æå é¤é䏿ªé䏿 ·å¼ä»¥åè®¾ç½®èæ¯è²ï¼åä½é¢è² |
| | | layui.each(table.cache.mainTable, function (i, l) { |
| | | if (obj.tr.index() == l.LAY_TABLE_INDEX) { |
| | | l.LAY_CHECKED = true; |
| | | } |
| | | }); |
| | | |
| | | var HCusID = obj.data["客æ·å
ç "]; |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['100%', '100%'] |
| | | , title: '客æ·ä½é¢æ¥è¯¢æ¥è¡¨-å ç¨é¢åº¦æç»' |
| | | , closeBtn: 1 |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: true //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: '../../åºæ¶ç®¡ç/æ¥è¡¨åæ/Xs_CusBalanceReport_HIsUsingBalanceEntry.html?HCusID=' + HCusID |
| | | , resize: false, |
| | | end: function () { |
| | | //å·æ°é¡µé¢, |
| | | $("#btnSearch").trigger('click'); |
| | | } |
| | | , cancel: function () { |
| | | |
| | | } |
| | | }) |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region éç½®æé® |
| | |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå |
| | | } |
| | | else if ($.inArray(data[i].name, totalArray) > -1) { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 }); |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120,templet: "<div>{{d." + data[i].name + " ==null ?'':fixed(d." + data[i].name + ")}}</div>" }); |
| | | } |
| | | else { |
| | | switch (data[i].Type) { |
| | |
| | | |
| | | option.cols = [col]; |
| | | option.data = data1.data; |
| | | table.render(option); |
| | | ins = table.render(option); |
| | | |
| | | //å·æ°æé®æ¾ç¤º |
| | | var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡ |
| | |
| | | //#region å·æ° |
| | | function get_Refresh() { |
| | | $("#btnSearch").trigger('click'); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region 导åºExecel |
| | | function get_Export() { |
| | | var ModRightNameCheck = "Xs_CusBalanceReport_ExportExcel"; |
| | | |
| | | //é»è¾å®¡æ ¸æ¹æ³ |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | table.exportFile(ins.config.id, option.data, "xls"); |
| | | } else { |
| | | layer.alert("å½åæ¨¡åæ²¡æå¯¼åºæé!", { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | |
| | | }); |
| | | |
| | | res = res.replace("HCusID", "客æ·å
ç "); |
| | | res = res.replaceAll("'", "''"); |
| | | |
| | | return res; |
| | | } |
| | |
| | | |
| | | //#endregion |
| | | |
| | | //#region å°æ°æ®å¢å ååä½ |
| | | function fixed(str) { |
| | | if (str !== '' && str != null) { |
| | | if (str === 0) { //å½ä¸º0æ¶ï¼ä¸ç¨å¤ç |
| | | return 0; |
| | | } else { |
| | | var str1 = str + ""; |
| | | var real = str1.split('.')[0]; //æ´æ°é¨å |
| | | var realQty = real.length; |
| | | var dotQty = str1.length - realQty - 1; |
| | | |
| | | if (dotQty > 0) { |
| | | return str.toFixed(dotQty).replace(/(\d)(?=(\d{3})+\.)/g, '$1,'); |
| | | } else { |
| | | var temp = str.toFixed(1).replace(/(\d)(?=(\d{3})+\.)/g, '$1,') + ""; |
| | | temp = temp.split('.')[0]; |
| | | return temp; |
| | | } |
| | | } |
| | | } else { |
| | | return ''; |
| | | } |
| | | return str; |
| | | } |
| | | //#endregion |
| | | |
| | | //以䏿¯layui模å |
| | | </script> |
| | | |