jquery-bootstable.js 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993
  1. /**
  2. * bootstable 表格插件
  3. * caratename:雨中磐石(rainrock)
  4. * caratetime:2014-04-06 21:40:00
  5. * email:admin@rockoa.com
  6. * homepage:www.rockoa.com
  7. */
  8. (function ($) {
  9. function bootstable(element, options){
  10. var obj = element;
  11. var can = options;
  12. var rand = js.getrand();
  13. var me = this;
  14. this.data = can.data;
  15. this.count = 0;
  16. this.page = 1;
  17. this.changedata = {};
  18. this.changeid = 0;
  19. this.bool = false;
  20. this.where = can.where;
  21. this.highorderstr = '';
  22. this.otherparams = {};
  23. this.loadci = 0;
  24. this.options= can;
  25. this.init = function(){
  26. this.tablename=can.tablename;
  27. can.tablename=jm.encrypt(can.tablename);
  28. this._init();
  29. this._create();
  30. if(can.autoLoad){
  31. this._loaddata(1);
  32. }
  33. if(can.fanye)this._fanye();
  34. };
  35. this.getData= function(fid){
  36. var a = this.data;
  37. if(fid)a= this.json[fid];
  38. if(!isNaN(fid))a= this.data[fid];
  39. return a;
  40. };
  41. this.getCount= function(){
  42. return this.count;
  43. };
  44. this.getJson= function(){
  45. return this.json;
  46. };
  47. this._init = function(){
  48. var sas = can.modedir;
  49. if(!sas)sas='index:';
  50. sas = sas.split(':');
  51. if(can.url=='')can.url = js.getajaxurl('publicstore', sas[0], sas[1]);
  52. if(can.cellurl=='')can.cellurl = js.getajaxurl('publicsavevalue', sas[0], sas[1]);
  53. this.setColumns(can.columns);
  54. s='<div style="position:relative;'+can.bodyStyle+'" id="tablebody_'+rand+'"></div><div id="tablefanye_'+rand+'"></div>';
  55. obj.html(s);
  56. $('#tablebody_'+rand+'').scroll(function(){
  57. me._scrollTopla($(this));
  58. });
  59. if(can.tree)window['stabletree'+rand+'']=function(j,o1){me.stabletree(j,o1)}
  60. };
  61. this.setColumns=function(cols){
  62. can.columns=cols;var a,i;
  63. for(i=0; i<can.columns.length; i++){
  64. a = can.columns[i];
  65. if(typeof(a.align)=='undefined')can.columns[i].align='center';
  66. if(a.dataIndex=='caozuo')can.columns[i] = this._caozuochengs(a,i);
  67. }
  68. };
  69. this.getcolumns = function(){
  70. return can.columns;
  71. };
  72. this.setCans = function(cas){
  73. for(var i in cas)can[i]=cas[i];
  74. };
  75. this._create = function(){
  76. var a = can.columns;
  77. var s = '',i,len=a.length,val,s1,s2='',cols,s3='',s4='',s5='',le,st,ov,j,j1,na,attr,sty='',hs='',dis,dlen=this.data.length,mcol;
  78. s+='<table id="tablemain_'+rand+'" class="rock-table table table-striped table-bordered table-hover" style="margin:0px">';
  79. if(!can.hideHeaders){
  80. mcol = window['maincolor'];
  81. if(!mcol)mcol='#3399FF';
  82. s+='<thead><tr><th width="40" thxu="-1" class="rock-table-th"></th>';
  83. if(can.checked)s+='<th width="40" class="rock-table-th"><div align="center"><input id="seltablecheck_'+rand+'" type="checkbox"></div></th>';
  84. var nstr = js.getoption(this.tablekeymd5()),nda={};
  85. if(nstr)nda = JSON.parse(nstr);
  86. for(i=0;i<len;i++){
  87. hs = '';
  88. attr = '';
  89. cols = a[i].colspan;
  90. na = a[i].dataIndex;
  91. if(nda[na])for(j in nda[na])a[i][j]=nda[na][j];
  92. if(can.sort == na)hs='color:'+mcol+';';
  93. if(a[i].width)attr+=' width="'+a[i].width+'"';
  94. if(a[i].tooltip)attr+=' title="'+a[i].tooltip+'"';
  95. if(cols && cols>1)attr+=' colspan="'+cols+'"';
  96. s+='<th nowrap '+attr+' thxu="'+i+'" class="rock-table-th"><div style="'+hs+'" align="'+a[i].align+'" lfields="'+na+'">';
  97. if(can.celleditor&&a[i].editor)s+='<i class="icon-pencil"></i>&nbsp;';
  98. s+=a[i].text;
  99. if(a[i].sortable){
  100. s+='&nbsp;';
  101. if(can.sort == na){
  102. s+='<i tempsort="'+i+'" lx="'+((can.dir=='desc')?'asc':'desc')+'" class="icon-sort-'+((can.dir=='desc')?'down':'up')+' cursor"></i>';
  103. }else{
  104. s+='<i tempsort="'+i+'" lx="desc" class="icon-sort cursor"></i>';
  105. }
  106. }
  107. s+='</div></th>';
  108. if(cols>1)i=i+cols-1;
  109. }
  110. s+='</tr></thead>';
  111. }
  112. s+='<tbody id="tbody_'+rand+'">';
  113. s+='</tbody></table>';
  114. $('#tablebody_'+rand+'').html(s);
  115. for(j=0;j<dlen;j++){
  116. s=this.createrows(j);
  117. $('#tbody_'+rand+'').append(s);
  118. }
  119. s='';
  120. this.trobj = obj.find('tr[dataid]');
  121. this.trobj.click(function(event){
  122. me._itemclick(this, event);
  123. });
  124. this.trobj.dblclick(function(event){
  125. me._itemdblclick(this, event);
  126. });
  127. if(typeof(can.celldblclick)=='function'){
  128. obj.find('td[cell]').dblclick(function(event){
  129. me._celldblclick(this, event);
  130. });
  131. }
  132. if(can.celleditor){
  133. var o = obj.find('td[fields]');
  134. o[can.celledittype](function(){
  135. me._celleditla(this);
  136. });
  137. }
  138. obj.find("a[temp='caozuomenu_"+rand+"']").click(function(){
  139. me._caozuochengss(this);
  140. return false;
  141. });
  142. $('#seltablecheck_'+rand+'').click(function(){
  143. js.selall(this, 'tablecheck_'+rand+'');
  144. });
  145. obj.find('i[tempsort]').click(function(){
  146. me._clickorder(this);
  147. });
  148. obj.find('th[thxu]').dblclick(function(){
  149. me._dblclickth(this);
  150. });
  151. };
  152. this.insert=function(d, funs,inid){
  153. d = js.apply({id:'auto'}, d);
  154. this.data.push(d);
  155. var j = this.data.length-1;
  156. var s=this.createrows(j);
  157. this.count++;
  158. if(!inid){
  159. $('#tbody_'+rand+'').append(s);
  160. }else{
  161. obj.find('tr[dataid="'+inid+'"]').after(s);
  162. }
  163. if(typeof(funs)=='function'){
  164. funs(this,j);
  165. }
  166. };
  167. this.createrows=function(j){
  168. var a = can.columns;
  169. var s = '',i,len=a.length,val,s1,s2='',s3='',s4='',s5='',le,st,ov,j,j1,na,attr,sty='',hs='',dis,trsty='',xu;
  170. ov = this.data[j];
  171. s3 = can.rendertr(ov, this, j);
  172. s4 = can.rowsbody(ov, this, j);
  173. if(s4)s5='rowspan="2"';
  174. if(!s3 && ((can.statuschange && ov.status==0) || (ov.ishui==1) || (ov.status==5))){
  175. trsty='color:#aaaaaa;';
  176. }
  177. if(ov.trbgcolor)trsty+='background:'+ov.trbgcolor+';';
  178. if(ov.trstyle)trsty+=''+ov.trstyle+';';
  179. if(trsty)trsty='style="'+trsty+'"';
  180. s='<tr class="rock-table-tr" clickbo="false" oi="'+j+'" dataid="'+ov.id+'" '+s3+' '+trsty+'>';
  181. xu = ov.trxu;if(!xu)xu=j+1+can.pageSize*(this.page-1);
  182. s+='<td '+s5+' align="right" width="40" class="rock-table-td">'+xu+'</td>';
  183. if(can.checked){
  184. dis = '';
  185. if(ov.checkdisabled)dis='disabled';
  186. s+='<td align="center" class="rock-table-td" width="40"><input oi="'+j+'" name="tablecheck_'+rand+'" '+dis+' value="'+ov.id+'" type="checkbox"></td>';
  187. }
  188. for(i=0;i<len;i++){
  189. na = a[i].dataIndex;
  190. val = ov[na];
  191. attr= '';
  192. sty = '';
  193. if(isempt(val)){
  194. val = '';
  195. this.data[j][na]=val;
  196. }
  197. if(a[i].type == 'checkbox'){
  198. s1 = '<img height="20" width="20" src="images/checkbox'+val+'.png">';
  199. }else{
  200. s1 = val;
  201. if(ov[na+'_textcn'])s1 = ov[na+'_textcn'];
  202. }
  203. if(typeof(a[i].renderer)=='function'){
  204. s3 = a[i].renderer(val, ov, j);
  205. if(!isempt(s3))s1=s3;
  206. }
  207. s2 = '';
  208. if(i == 0 && can.tree){
  209. st = ov.stotal;
  210. le = ov.level;
  211. for(j1=1;j1<le;j1++)s2+='<img src="images/white.gif" class="icons">&nbsp; ';
  212. s2 += '<i onclick="stabletree'+rand+'('+j+',this)" class="icon-'+((st>0)?'folder-close-alt':'file-alt')+'"></i>&nbsp;';
  213. }
  214. if(can.celleditor &&a[i].editor)attr+=' fields="'+na+'"';
  215. if(a[i].width)attr+=' width="'+a[i].width+'"';
  216. if(typeof(a[i].renderstyle)=='function'){
  217. s3 = a[i].renderstyle(val, ov, j);
  218. if(!isempt(s3))sty+=''+s3+';';
  219. }
  220. if(typeof(a[i].renderattr)=='function'){
  221. s3 = a[i].renderattr(val, ov, j);
  222. if(!isempt(s3))attr+=' '+s3+'';
  223. }
  224. if(ov[''+na+'_color'])sty+='color:'+ov[''+na+'_color']+';';
  225. if(ov[''+na+'_style'])sty+=''+ov[''+na+'_style']+';';
  226. if(ov[''+na+'_title'])attr+=' title="'+ov[''+na+'_title']+'"';
  227. s+='<td class="rock-table-td" align="'+a[i].align+'" '+attr+' style="'+sty+'" row="'+j+'" cell="'+i+'">'+s2+''+s1+'</td>';
  228. }
  229. s+='</tr>';
  230. if(s4)s+='<tr class="rock-table-tr"><td class="rock-table-td" colspan="'+(len+1)+'">'+s4+'</td></tr>';
  231. return s;
  232. };
  233. this._tredat={};
  234. this.stabletree=function(j,o1){
  235. if(!can.loadtree)return;
  236. var ov = this.data[j];
  237. if(!ov.stotal || ov.stotal<1 || this._tredat[j])return;
  238. var das = this._loaddata(1, true);
  239. das.pvalue = ov.id;
  240. das.level = ov.level+1;
  241. this.bool = true;
  242. this._tredat[j]=true;
  243. o1.className='icon-spinner';
  244. $.ajax({
  245. url:can.url,type:can.method,data:das,dataType:'json',
  246. success:function(ret){
  247. o1.className='icon-folder-open-alt';
  248. me.showtreeda(ret.rows,das.pvalue);
  249. me.bool = false;
  250. },
  251. error: function(e){
  252. o1.className='icon-folder-close-alt';
  253. js.msg('msg',e.responseText);
  254. me.bool = false;
  255. }
  256. });
  257. };
  258. this.showtreeda=function(da,pj){
  259. if(!da)return;var len = da.length,o1,i;if(len==0)return;
  260. for(i=len-1;i>=0;i--){
  261. this.insert(da[i],false,pj);
  262. if(can.celleditor){
  263. o1 = obj.find('tr[dataid="'+da[i].id+'"]').find('td[fields]');
  264. o1[can.celledittype](function(){
  265. me._celleditla(this);
  266. });
  267. }
  268. }
  269. this.trobj = obj.find('tr[dataid]');
  270. this.trobj.unbind();
  271. this.trobj.click(function(event){
  272. me._itemclick(this, event);
  273. });
  274. this.trobj.dblclick(function(event){
  275. me._itemdblclick(this, event);
  276. });
  277. obj.find("a[temp='caozuomenu_"+rand+"']").unbind().click(function(){
  278. me._caozuochengss(this);
  279. return false;
  280. });
  281. };
  282. this._celldblclick = function(o1,e){
  283. var o = $(o1);
  284. var cell = parseFloat(o.attr('cell')), row = parseFloat(o.attr('row'));
  285. var farr = can.columns[cell],
  286. d = this.data[row];
  287. can.celldblclick(farr, d, o1, cell, row, e);
  288. };
  289. this._scrollTopla= function(o){
  290. if(can.hideHeaders)return;
  291. var top = o.scrollTop();
  292. if(top<40){
  293. var o1 = $('#headerla_'+rand+'');
  294. o1.hide();
  295. o1.html('');
  296. }else{
  297. var off = obj.offset();
  298. var a = can.columns,s='',i,len=a.length,w1,o2;
  299. if(!get('headerla_'+rand+'')){
  300. s = '<div style="position:fixed;left:'+(off.left)+'px;top:'+(off.top)+'px;width:100%;overflow:hidden; background:rgba(255,255,255,0.5);border-bottom:0px #dddddd solid;z-index:2" id="headerla_'+rand+'"></div>';
  301. obj.append(s);
  302. }
  303. var o1 = $('#headerla_'+rand+'');
  304. o1.show();
  305. o1.css({left:''+(off.left)+'px',top:''+(off.top)+'px',width:''+($('#tablemain_'+rand+'').width())+'px'});
  306. if(o1.html()==''){
  307. s = '';
  308. s+='<table class="rock-table table table-striped table-bordered" style="margin:0px" width="100%">';
  309. s+='<tr><th width="40" class="rock-table-th"></th>';
  310. if(can.checked)s+='<th width="40" class="rock-table-th"></th>';
  311. for(i=0;i<len;i++){
  312. o2 = obj.find("div[lfields='"+a[i].dataIndex+"']");
  313. w1 = o2[0].clientWidth-1;
  314. w1 = 'width:'+w1+'px';
  315. s+='<th class="rock-table-th"><div style="'+w1+'" align="'+a[i].align+'">'+o2.html()+'</div></th>';
  316. }
  317. s+='</tr>';
  318. s+='</table>';
  319. o1.html(s);
  320. }
  321. }
  322. };
  323. this._celleditla = function(o1){
  324. if(this.bool)return;
  325. var o = $(o1),
  326. fields = o.attr('fields'),
  327. row = parseFloat(o.attr('row')),
  328. cell = parseFloat(o.attr('cell'));
  329. var a = this.data[row],i,len,sel,d,
  330. b = can.columns[cell],
  331. l = o.offset(),
  332. w = o1.clientWidth,
  333. h = o1.clientHeight,
  334. at = '',
  335. v = a[fields];
  336. $('#edittable_'+rand+'').remove();
  337. if(b.editorbefore && !b.editorbefore(a))return;
  338. if(!b.textmsg)b.textmsg='';
  339. var s = '<div id="edittable_'+rand+'" style="position:absolute;z-index:2;left:'+(l.left)+'px;top:'+(l.top+h)+'px; background:white;border-radius:15px">';
  340. s+='<div style="border:var(--border);background:var(--main-bgcolor);padding:10px;box-shadow:0px 0px 10px rgba(0,0,0,0.3);border-radius:10px">';
  341. s+=' <div>&nbsp;<b>'+b.text+'</b>:&nbsp;<span id="msgteita_'+rand+'">'+b.textmsg+'</span></div>';
  342. s+=' <div class="blank10"></div>';
  343. var wss = 200;
  344. if(b.editorwidth)wss=b.editorwidth;
  345. var flx = b.type,attr=b.editorattr;
  346. if(!flx)flx='text';
  347. if(!attr)attr='';
  348. if(b.repEmpty)attr+=' onblur="this.value=strreplace(this.value)" ';
  349. if(flx=='checkbox'){
  350. if(v=='1')at='checked';
  351. s+='<div><label><input type="checkbox" id="inputedit_'+rand+'" '+at+' value="1"> '+b.text+'</label></div>';
  352. }else if(flx=='textarea'){
  353. s+='<div><textarea type="text" style="width:'+wss+'px;height:100px" '+attr+' id="inputedit_'+rand+'" class="input">'+v+'</textarea></div>';
  354. }else if(flx=='select' && b.store){
  355. d=b.store;
  356. s+='<div><select style="width:'+wss+'px" id="inputedit_'+rand+'" '+attr+' class="input">';
  357. len=b.store.length;for(i=0;i<len;i++){
  358. sel='';if(d[i][0]==v||d[i][1]==v)sel='selected';
  359. s+='<option value="'+d[i][0]+'" '+sel+'>'+d[i][1]+'</option>';
  360. }
  361. s+='</select></div>';
  362. }else if(flx=='date'){
  363. s+='<div><input type="text" style="width:'+wss+'px" id="inputedit_'+rand+'" '+attr+' class="input datesss" onclick="js.datechange(this)" readonly value="'+v+'"></div>';
  364. }else{
  365. s+='<div><input type="'+flx+'" style="width:'+wss+'px" id="inputedit_'+rand+'" '+attr+' class="input" value="'+v+'"></div>';
  366. }
  367. s+=' <div class="blank10"></div>';
  368. if(!can.cellautosave || b.noautosave)s+=' <div><a id="inputeditsave_'+rand+'" href="javascript:"><i class="icon-ok"></i> 确定</a >&nbsp; &nbsp; <a href="javascript:" class="hui" onclick="$(\'#edittable_'+rand+'\').remove()"><i class="icon-remove"></i> 取消</a></div>';
  369. s+='</div>';
  370. s+='<div align="center"><div class="arrow-down"></div></div>';
  371. s+='</div>';
  372. $('body').append(s);
  373. var o2 = get('edittable_'+rand+'');
  374. var jg = (w-o2.clientWidth)*0.5;
  375. $(o2).css({left:''+(l.left+jg)+'px',top:''+(l.top-o2.clientHeight)+'px'});
  376. var o3 = get('inputedit_'+rand+'');
  377. o3.focus();
  378. $(o3).keyup(function(e){
  379. if(e.keyCode==13)this.blur();
  380. });
  381. var arr = {oldvalue:v,fields:fields,type:b.type,id:a.id,obj:o,row:row}
  382. if(!can.cellautosave || b.noautosave){
  383. $('#inputeditsave_'+rand+'').click(function(){
  384. me._editforcuschen(this, arr, b);
  385. });
  386. }else{
  387. $(o3).blur(function(){
  388. me._editforcuschen(this, arr, b);
  389. });
  390. }
  391. };
  392. this._dblclickth=function(o1){
  393. var o = $(o1),xu = parseFloat(o.attr('thxu'));
  394. if(xu==-1){
  395. var kes = this.tablekeymd5();
  396. if(js.getoption(kes)){
  397. js.confirm('是否清空设置列的属性',function(jg){
  398. if(jg=='yes'){js.setoption(kes,'');js.msg('success','已清空可F5刷新查看');}
  399. });
  400. }
  401. return;
  402. }
  403. var d = can.columns[xu],dws=d.width,dw1='',dw2='';
  404. if(d.dataIndex=='caozuo')return;
  405. if(!dws)dws='';
  406. var st2 = ''+dws+'';
  407. if(st2.indexOf('%')>0)dw2='%';
  408. dw1 = st2.replace('px','').replace('%','');
  409. var str = '<div style="padding:10px">';
  410. str+='<div>列宽宽度:<input type="number" placeholder="当前'+o.width()+'px" min="0" autocomplete="off" style="width:110px" id="lie_width" class="input" value="'+dw1+'"><select style="width:90px" id="lie_widths" class="input"><option value="px">像素px</option><option value="%" '+((dw2=='%')?'selected':'')+'>百分比%</option></select></div>';
  411. str+='<div style="margin-top:10px">对齐方式:<select style="width:200px" id="lie_align" class="input"><option value="center">居中</option><option value="left" '+((d.align=='left')?'selected':'')+'>居左←</option><option value="right" '+((d.align=='right')?'selected':'')+'>居右→</option></select></div>';
  412. str+='</div>';
  413. js.tanbody('bootsthcog','设置列['+d.text+']的属性', 300,200,{
  414. html:str,
  415. btn:[{text:'确定'}]
  416. });
  417. $('#bootsthcog_btn0').click(function(){
  418. me._dblclickthclick(xu);
  419. });
  420. };
  421. this._dblclickthclick=function(xu){
  422. var d = can.columns[xu],w1=get('lie_width').value,d1={};
  423. d1.align = get('lie_align').value;
  424. d.align = d1.align;
  425. if(w1 && w1>0){
  426. d1.width = w1+get('lie_widths').value;
  427. d.width = d1.width;
  428. }
  429. js.tanclose('bootsthcog');
  430. this.reload();
  431. var sbd = true;
  432. if(can.modenum && can.listcreate && window['admintype']=='1'){
  433. var da = {modenum:can.modenum,align:d1.align,width:'',fields:d.dataIndex};
  434. if(d1.width)da.width = d1.width;
  435. js.ajax('index.php?d=flow&m=flowopt&a=savecolums',da,function(ret){
  436. if(ret.code==202)me._dblclickthsave(d,d1);
  437. },'get,json');
  438. sbd=false;
  439. }
  440. if(sbd)this._dblclickthsave(d,d1);
  441. };
  442. this._dblclickthsave=function(d,d1){
  443. var key = this.tablekeymd5(),str,da={};
  444. str = js.getoption(key);
  445. if(str)da = JSON.parse(str);
  446. da[d.dataIndex] = d1;
  447. js.setoption(key,JSON.stringify(da));
  448. };
  449. this.tablekeymd5=function(){
  450. var url = can.url;
  451. if(url.indexOf('rnd')>0)url = url.substr(0,url.indexOf('rnd')-1);
  452. var str = url+this.tablename+can.storeafteraction+can.storebeforeaction+can.defaultorder+can.onlytablekey;
  453. if(can.modenum)str+=can.modenum;
  454. return 'table'+md5(str);
  455. };
  456. this.signature= function(da, url){
  457. var time = parseInt(js.now('time')*0.001);
  458. var siaa = ''+NOWURL+''+url+''+da.tablename+''+time+'_'+adminid+'';
  459. var sign = md5(siaa);
  460. da.sys_signature= sign;
  461. da.sys_timeature= time;
  462. return da;
  463. };
  464. this._editforcuschen = function(o1, a, farr){
  465. var o1= get('inputedit_'+rand+'');
  466. var v = o1.value,ov = a.oldvalue;
  467. if(a.type=='checkbox')if(!o1.checked)v='0';
  468. var selv= v+'';
  469. if(a.type=='select')selv=o1.options[o1.selectedIndex].text;
  470. if(v==ov || selv==ov){
  471. $('#edittable_'+rand+'').remove();
  472. return;
  473. }
  474. var vid = 'msgteita_'+rand+'';
  475. js.setmsg('处理中...','#ff6600',vid);
  476. o1.disabled = true;
  477. this.bool = true;
  478. var data = {tablename:can.tablename,id:a.id,fieldname:a.fields,value:v,fieldsafteraction:can.fieldsafteraction};
  479. $.ajax({
  480. data:this.signature(data, can.cellurl),type:'post',url:can.cellurl,
  481. success:function(bstr){
  482. me.bool = false;
  483. $('#edittable_'+rand+'').remove();
  484. if(bstr!='success'){
  485. js.msg('msg', bstr);
  486. return;
  487. }
  488. js.setmsg('处理完成','green',vid);
  489. var ohtml = a.obj.html();
  490. ohtml = ohtml.replace(ov, v);
  491. if(a.type=='checkbox')ohtml='<img height="20" width="20" src="images/checkbox'+v+'.png">';
  492. if(a.type=='select')ohtml=selv;
  493. a.obj.html(ohtml);
  494. me.data[a.row][a.fields] = v;
  495. if(farr.editorafter)farr.editorafter();//保存后处理
  496. },
  497. error:function(e){
  498. js.msg('msg',e.responseText);
  499. me.bool = false;
  500. }
  501. });
  502. };
  503. this._itemclick= function(o1, e){
  504. var o = $(o1);
  505. if(can.selectColor){
  506. this.trobj.css('background','');
  507. o.css('background', can.selectColor);
  508. }else{
  509. this.trobj.removeClass(can.selectcls);
  510. o.addClass(can.selectcls);
  511. }
  512. var oi = parseFloat(o.attr('oi'));
  513. var a = this.data[oi];
  514. this.changedata = a;
  515. this.changeid = a.id;
  516. can.itemclick(a, oi, e);
  517. };
  518. this._itemdblclick= function(o1, e){
  519. var o = $(o1),oi,lxs,o1,cell,farr,o2;
  520. oi = parseFloat(o.attr('oi'));
  521. o2 = e.target;
  522. lxs = o2.nodeName.toLowerCase();
  523. if(lxs!='td'){
  524. o2 = e.target.parentNode;
  525. lxs = o2.nodeName.toLowerCase();
  526. }
  527. if(lxs=='td'){
  528. o1 = $(o2);
  529. cell= parseFloat(o1.attr('cell'));
  530. farr= can.columns[cell];
  531. if(farr.editor)return;//单元格是编辑就退出
  532. }
  533. can.itemdblclick(this.changedata, oi, e);
  534. };
  535. this._loaddata = function(p, donbo){
  536. if(this.bool)return;
  537. this.changeid= 0;
  538. this.loadci++;
  539. this.changedata = {};
  540. var url = can.url;
  541. var das = {tablename_abc:can.tablename,defaultorder:can.defaultorder,keywhere:can.keywhere,where:this.where,sort:can.sort,dir:can.dir,loadci:this.loadci,storebeforeaction:can.storebeforeaction,storeafteraction:can.storeafteraction,modenum:can.modenum},
  542. s='',of=obj.offset();
  543. das.keywhere=jm.encrypt(das.keywhere.replace(/\'/g, '[F]'));
  544. das.where = jm.encrypt(das.where.replace(/\'/g, '[F]'));
  545. das.start = can.pageSize*(p-1);
  546. das.page = p;
  547. das.limit = can.pageSize;
  548. if(!can.fanye)das.limit = can.limit;
  549. das = js.apply(das, can.params);
  550. das = js.apply(das, this.otherparams);
  551. if(donbo)return das;
  552. this.page = p;
  553. var o1 = $('#tablebody_'+rand+'');
  554. var h= o1.height()-2,w= o1.width()-2;
  555. s='<div id="modeshow_'+rand+'" style="height:'+h+'px;width:'+w+'px;overflow:hidden;z-index:3;position:absolute;left:1px;line-height:'+h+'px;top:1px;background:rgba(0,0,0,0.2);color:white" align="center">'+js.ling(20)+'&nbsp;加载中...</div>';
  556. o1.append(s);
  557. can.beforeload();
  558. this.bool = true;
  559. $.ajax({
  560. url:url,type:can.method,data:das,
  561. success:function(da){
  562. if(!get('tablebody_'+rand+''))return;
  563. var a = js.decode(da);
  564. if(!a.rows){
  565. if(a.msg)da=a.msg;
  566. js.msg('msg',da);
  567. }else{
  568. me._loaddataback(a);
  569. }
  570. $('#modeshow_'+rand+'').remove();
  571. me.bool = false;
  572. },
  573. error: function(e){
  574. $('#modeshow_'+rand+'').remove();
  575. js.msg('msg',e.responseText);
  576. me.bool = false;
  577. }
  578. });
  579. };
  580. this.exceldown = function(bt, lxs,ocsn){
  581. if(this.bool)return;
  582. var excelfields='',excelheader='',i,a=can.columns;
  583. var np = (lxs==2) ? this.page : 1;
  584. var das = this._loaddata(np, true);
  585. das.limit = 10000;
  586. das.execldown = 'true';
  587. if(!bt)bt=nowtabs.name;
  588. das.exceltitle = bt;
  589. for(i=0;i<a.length;i++){
  590. if(!a[i].notexcel){
  591. excelfields+=','+a[i].dataIndex+'';
  592. excelheader+=','+a[i].text+'';
  593. }
  594. }
  595. das.excelfields = excelfields.substr(1);
  596. das.excelheader = excelheader.substr(1);
  597. if(lxs==1)return das;
  598. if(lxs==2){
  599. das.limit = can.pageSize;
  600. }
  601. if(ocsn)for(i in ocsn)das[i]=ocsn[i];
  602. das.exceltitle = jm.encrypt(das.exceltitle);
  603. das.excelfields = jm.encrypt(das.excelfields);
  604. das.excelheader = jm.encrypt(das.excelheader);
  605. this.bool = true;
  606. js.msg('wait', '导出处理中...');
  607. $.ajax({
  608. url:can.url,type:'POST',data:das,dataType:'json',
  609. success:function(a1){
  610. var lex = (nwjsgui)?'_self':'_blank';
  611. if(!a1.downCount)a1.downCount = a1.totalCount;
  612. js.msg('success', '处理成功,共有记录'+a1.totalCount+'条/导出'+a1.downCount+'条,点我直接<a class="a" href="'+a1.url+'" target="'+lex+'">[下载]</a>', 60);
  613. me.bool=false;
  614. },
  615. error:function(e){
  616. js.msg('msg','err:'+e.responseText);
  617. me.bool = false;
  618. }
  619. });
  620. };
  621. this.exceldownnow = function(bt){
  622. this.exceldown(bt,2);
  623. };
  624. this.setparams = function(cans, relo){
  625. if(!cans)cans={};
  626. this.otherparams = js.apply(this.otherparams,cans);
  627. this.page = 1;
  628. if(relo)this.reload();
  629. };
  630. this._loaddataback=function(a){
  631. this._tredat={};
  632. this.json = a;
  633. this.data = a.rows;
  634. this.count = a.totalCount;
  635. can.loadbefore(a, this);
  636. this._create();
  637. this._initfany();
  638. can.load(a, this, this.loadci);
  639. };
  640. this.loadData = function(d){
  641. this._loaddataback(d);
  642. };
  643. this._clickorder = function(o1){
  644. if(this.loadci==0)return;
  645. var o,oi,a,dir,sort;
  646. o = $(o1);
  647. oi = parseFloat(o.attr('tempsort'));
  648. a = can.columns[oi];
  649. sort = a.dataIndex;
  650. dir = o.attr('lx');
  651. this.order(sort, dir);
  652. };
  653. this.remove = function(ids){
  654. var sid = ids.split(','),id,i;
  655. for(i=0;i<sid.length;i++){
  656. id = sid[i];
  657. obj.find("tr[dataid='"+id+"']").remove();
  658. if(id == this.changeid){
  659. this.changeid= 0;
  660. this.changedata = {};
  661. }
  662. }
  663. };
  664. this.hiderows=function(ids){
  665. var sid = ids.split(','),id,i;
  666. for(i=0;i<sid.length;i++){
  667. id = sid[i];
  668. obj.find("tr[dataid='"+id+"']").hide();
  669. if(id == this.changeid){
  670. this.changeid= 0;
  671. this.changedata = {};
  672. }
  673. }
  674. };
  675. this.showrows=function(id){
  676. var sid = ids.split(','),id,i;
  677. for(i=0;i<sid.length;i++){
  678. id = sid[i];
  679. obj.find("tr[dataid='"+id+"']").show();
  680. }
  681. };
  682. this.showallrows=function(){
  683. obj.find("tr[dataid']").show();
  684. }
  685. this.order = function(a, b){
  686. if(!a)return;
  687. if(!b)b='asc';
  688. can.sort = a;
  689. can.dir = b;
  690. this.reload();
  691. };
  692. this.highorder = function(str){
  693. if(!str)str='';
  694. this.highorderstr = str;
  695. this.reload();
  696. };
  697. this.search = function(w, jg, slx){
  698. if(!w)w='';
  699. if(jg)w = this.where+' '+w;
  700. var s = can.outsearch(this);
  701. if(s)w+=' '+s+'';
  702. this.where = w;
  703. this._loaddata(1);
  704. return w;
  705. };
  706. this.reload = function(){
  707. this._loaddata(this.page);
  708. };
  709. this.del = function(csa){
  710. if(this.bool)return;
  711. var a = js.apply({msg:'确定要删除选中的{s}条记录吗?',success:function(){},checked:false,check:function(){}},csa);
  712. var s = ''+this.changeid+'',xz;
  713. if(a.checked)s=this.getchecked();
  714. if(s=='0'||s==''){
  715. js.msg('msg','没有选中记录');
  716. return;
  717. }
  718. xz = s.split(',').length;
  719. a.msg = a.msg.replace('{s}', ''+xz+'');
  720. js.confirm(a.msg,function(lx){
  721. a.check(lx);
  722. if(lx=='yes'){
  723. me._delok(s, a);
  724. }
  725. });
  726. };
  727. this.getchecked = function(){
  728. return js.getchecked('tablecheck_'+rand+'');
  729. };
  730. this.getcheckobj = function(){
  731. return $("input[name='tablecheck_"+rand+"']");
  732. };
  733. this.getcheckdata= function(){
  734. var o = this.getcheckobj(),len=o.length,i,o1,d=[];
  735. for(i=0;i<len;i++){
  736. o1=o[i];
  737. if(o1.checked){
  738. oi=parseFloat($(o1).attr('oi'));
  739. d.push(this.data[oi]);
  740. }
  741. }
  742. return d;
  743. };
  744. this._delok = function(sid, ds){
  745. js.msg('wait','删除'+sid+'中...');
  746. this.bool=true;
  747. var url = ds.url;if(!url)url=js.getajaxurl('publicdel','index');
  748. var ss = js.apply({modenum:can.modenum,table:can.tablename,id:sid},ds.params);
  749. $.ajax({
  750. url:url,type:'POST',data:ss,dataType:'json',
  751. success:function(a1){
  752. me.bool=false;
  753. if(a1.code==200){
  754. js.msg('success','删除成功');
  755. ds.success();
  756. me.reload();
  757. }else{
  758. js.msg('msg',a1.msg);
  759. }
  760. },
  761. error:function(e){
  762. js.msg('msg','err:'+e.responseText);
  763. me.bool = false;
  764. }
  765. });
  766. };
  767. this.settishi=function(nr){
  768. $('#bottomtishi_'+rand+'').html(nr);
  769. };
  770. this._fanye = function(){
  771. var s = '';
  772. s='<div style="margin-top:10px;display:flex;align-items:center;">'+
  773. '<div class="btn-group">'+
  774. '<button id="shouye_'+rand+'" type="button" data-toggle="tooltip" data-placement="top" title="首页" class="btn btn-default">&laquo;</button>'+
  775. '<button id="shang_'+rand+'" data-toggle="tooltip" data-placement="top" title="上一页" type="button" disabled class="btn btn-default">&lt;</button>'+
  776. '<button id="nowye_'+rand+'" type="button" disabled class="btn btn-default"> 第<span id="pages_'+rand+'">1</span>页/共<span id="maxpage_'+rand+'">0</span>页 <span class="caret"></span></button>'+
  777. '<button id="next_'+rand+'" type="button" data-toggle="tooltip" data-placement="top" title="下一页" disabled class="btn btn-default">&gt;</button>'+
  778. '<button id="lastye_'+rand+'" type="button" data-toggle="tooltip" data-placement="top" title="尾页" disabled class="btn btn-default">&raquo;</button>'+
  779. '</div> '+
  780. '<div style="margin-left:10px">'+
  781. ' <button id="refresh_'+rand+'" type="button" data-toggle="tooltip" data-placement="top" title="刷新" class="btn btn-default"><i class="icon-refresh"></i></button>'+
  782. '</div> '+
  783. '<div style="flex:1;margin:0px 10px" id="bottomtishi_'+rand+'"></div>'+
  784. '<div style="">'+
  785. '<span>共记录<span id="zjilu_'+rand+'">0</span>条</span> &nbsp;'+
  786. '每页<input maxlength="3" onblur="js.number(this)" onfocus="js.focusval=this.value" id="pagesize_'+rand+'" type="number" value="'+can.pageSize+'" style="width:40px;text-align:center;height:24px;border:var(--border);margin:0px 2px;font-size:12px;border-radius:5px;background:var(--main-bgcolor)">条&nbsp;'+
  787. '</div>'+
  788. '</div>';
  789. $('#tablefanye_'+rand+'').html(s);
  790. $('#shouye_'+rand+'').click(function(){me.firstPage();});
  791. $('#shang_'+rand+'').click(function(){me.backPage();});
  792. $('#next_'+rand+'').click(function(){me.nextPage();});
  793. $('#lastye_'+rand+'').click(function(){me.lastPage();});
  794. $('#refresh_'+rand+'').click(function(){me.reload();});
  795. $('#nowye_'+rand+'').rockmenu({
  796. top:33,width:150,
  797. data:[{name:'第1页',p:1}],
  798. beforeshow:function(o){
  799. o.setData(me._getpaged());
  800. o.setValue('第'+me.page+'页');
  801. },
  802. itemsclick:function(a){
  803. me.gotoPage(a.p);
  804. }
  805. });
  806. var o1 = $('#pagesize_'+rand+'');
  807. o1.blur(function(){me.setpageSize(this.value);});
  808. o1.keyup(function(e){if(e.keyCode==13)this.blur()});
  809. };
  810. this._getpaged = function(){
  811. var a = [],i=1,j=1,b,bg;
  812. i = this.page-5;
  813. j = this.page+5;
  814. if(i<1)i=1;
  815. if(j>this.maxPage)j=this.maxPage;
  816. for(b=i;b<=j;b++){
  817. a.push({name:'第'+b+'页',p:b});
  818. }
  819. return a;
  820. };
  821. this._initfany = function(){
  822. if(!can.fanye)return;
  823. $('#zjilu_'+rand+'').html(''+this.count+'');
  824. $('#pages_'+rand+'').html(''+this.page+'');
  825. this.maxPage = Math.ceil(this.count/can.pageSize);
  826. $('#maxpage_'+rand+'').html(''+this.maxPage+'');
  827. var bo1=false,bo2=false;
  828. if(this.maxPage <=1 || this.page<=1){
  829. bo1 = true;
  830. }
  831. get('shouye_'+rand+'').disabled=bo1;
  832. get('shang_'+rand+'').disabled=bo1;
  833. if(this.maxPage <=1){
  834. get('nowye_'+rand+'').disabled=true;
  835. }else{
  836. get('nowye_'+rand+'').disabled=false;
  837. }
  838. if(this.maxPage <=1 || this.page>=this.maxPage){
  839. bo2 = true;
  840. }
  841. get('next_'+rand+'').disabled=bo2;
  842. get('lastye_'+rand+'').disabled=bo2;
  843. };
  844. this._next = function(oi){
  845. var p = this.page+oi;
  846. if(p<=0)p=1;
  847. if(p>=this.maxPage)p=this.maxPage;
  848. this._loaddata(p);
  849. };
  850. this.firstPage = function(){
  851. this._loaddata(1);
  852. };
  853. this.backPage = function(){
  854. this._next(-1);
  855. };
  856. this.nextPage = function(){
  857. this._next(1);
  858. };
  859. this.gotoPage = function(p){
  860. this._loaddata(p);
  861. };
  862. this.lastPage = function(){
  863. this._loaddata(this.maxPage);
  864. };
  865. this.setpageSize = function(p){
  866. p = parseFloat(p);
  867. if(p<=0)p=can.pageSize;
  868. $('#pagesize_'+rand+'').val(''+p+'');
  869. if(can.pageSize == p)return;
  870. can.pageSize = p;
  871. this.page = 1;
  872. this.reload();
  873. };
  874. this._caozuochengs=function(a,oj){
  875. a.renderer=function(v,d,oi){
  876. var s='<a oi="'+oi+'" oj="'+oj+'" style="TEXT-DECORATION:none" temp="caozuomenu_'+rand+'">';
  877. if(this.opttype){
  878. s+=this.opttype;
  879. }else{
  880. s+='操作<i class="icon-angle-down"></i>';
  881. }
  882. s+='</a>';
  883. if(!d.id)s='&nbsp;';
  884. return s;
  885. };
  886. a.renderattr=function(){return 'nowrap'}
  887. a.notexcel=true;
  888. return a;
  889. };
  890. this._caozuochengss=function(o1){
  891. var oi,d,num,mid,modename,o2;
  892. o2= $(o1);
  893. oi= parseFloat(o2.attr('oi'));
  894. oj= parseFloat(o2.attr('oj'));
  895. d = this.getData(oi);
  896. num=can.modenum;if(num=='')num=this.tablename;
  897. mid = d.id;if(d.modenum)num=d.modenum;
  898. modename=can.modename;if(d.modename)modename=d.modename;
  899. new optmenuclass(o1,num,mid,this,modename,oi,can.columns[oj]);
  900. };
  901. this.geturlparams=function(bt,ocans){
  902. var cshu = this.exceldown(bt, 1),i;
  903. cshu.tablename_abc = jm.uncrypt(cshu.tablename_abc);
  904. cshu = js.apply(cshu,ocans);
  905. return [can.url, cshu];
  906. }
  907. };
  908. /**
  909. 表格中常用方法
  910. 1、reload(); //刷新数据源
  911. 2、getchecked();//获取复选框对应记录ID聚
  912. 3、getcheckdata();//获取复选框选中的数据数组[]
  913. 4、insert({name:''});//表格中插入一行
  914. 5、setparams({key:''},true);//设置参数并搜索
  915. 6、geturlparams();获取当前Url地址参数,订阅时用到的
  916. */
  917. if(typeof(bootsSelectColor)!='string')bootsSelectColor= 'rgba(0,0,0,0.1)';
  918. $.fn.bootstable = function(options){
  919. var defaultVal = {
  920. columns:[], //表头
  921. selectColor:bootsSelectColor, //选中时行颜色
  922. pageSize:15, //默认分页数
  923. limit:0, //没有分页时展示条数
  924. bodyStyle:'',
  925. height:0, //高度
  926. url:'', //请求地址
  927. celleditor:false, //是否可编辑单元格
  928. cellautosave:true, //编辑单元格是否自动保存
  929. celledittype:'dblclick', //编辑单元格用双击
  930. cellurl:'', //编辑单元格保存地址
  931. fieldsafteraction:'', //编辑单元格时保存后触发
  932. data:[], //初始数据
  933. autoLoad:true, //是否初始化后就加载
  934. tree:false, //是否树形显示
  935. itemdblclick:function(){}, //双击行调用
  936. searchwidth:500, //没用
  937. defaultorder:'', //默认排序
  938. where:'', //条件
  939. hideHeaders:false, //是否隐藏头部表头
  940. modename:'', //对应模块名称
  941. modenum:'', //对应模块编号
  942. statuschange:true, //当行的status=0时自动变成灰色
  943. checked:false, //是否多选
  944. fanye:false, //是否可翻页
  945. sort:'', //排序字段
  946. dir:'', //排序类型desc和asc
  947. storeafteraction:'', //数据源请求后先处理函数
  948. storebeforeaction:'',//数据源请求时先处理函数,可返回条件字段等
  949. loadtree:false,
  950. modedir:'', //当前文件路径,一般都是写:'{mode}:{dir}'
  951. keywhere:'', //条件
  952. params:{}, //其他参数
  953. tablename:'', //请求数据表格名,如有指定modenum,会加载对应模块上设置的表
  954. selectcls:'success', //选中样式
  955. itemclick:function(da, index, e){}, //单击行触发
  956. beforeload:function(){}, //数据加载前触发
  957. load:function(){}, //数据加载完成后触发
  958. loadbefore:function(){}, //数据加载完成后但还没有渲染出来时触发
  959. outsearch:function(){return ''}, //外搜索条件
  960. searchview:'', //没用
  961. method:'POST', //post请求
  962. rendertr:function(){return ''}, //少用
  963. rowsbody:function(){return ''}, //少用
  964. onlytablekey:'', //唯一的编号
  965. celldblclick:false //没用
  966. };
  967. if(typeof(bootstableobj)=='undefined')bootstableobj={};
  968. var can = $.extend({}, defaultVal, options);
  969. var clsa = new bootstable($(this), can);
  970. clsa.init();
  971. if(can.modenum!='')bootstableobj[can.modenum]=clsa;
  972. return clsa;
  973. };
  974. })(jQuery);
粤ICP备19079148号