{"id":488,"date":"2017-01-04T17:13:47","date_gmt":"2017-01-04T09:13:47","guid":{"rendered":"http:\/\/loveuhouse.cn\/wordpress\/?p=488"},"modified":"2017-02-20T13:58:52","modified_gmt":"2017-02-20T05:58:52","slug":"jtable-bate","status":"publish","type":"post","link":"https:\/\/loveuhouse.cn\/wordpress\/?p=488","title":{"rendered":"jtable  bate"},"content":{"rendered":"<h3>\u4e00\u4e9b\u60f3\u6cd5<\/h3>\n<p>1.\u9700\u8981\u4fdd\u5b58\u83b7\u53d6\u6570\u636e\u63a5\u53e3\u548c\u641c\u7d22\u63a5\u53e3<br \/>\n2.\u5355\u5143\u683c\u533a\u5206 \u5c55\u793a\u503c\u548c\u5b9e\u9645\u6570\u503c<\/p>\n<h3>\u5982\u4f55\u8c03\u7528<\/h3>\n<pre class=\"lang:js decode:true\">\n    ftable=new jtable();\n    var f_post={\n        \"Json\":{\n            \"alipay_name\":$(\"#list_alipay_name :selected\").text(),\n            \"alipay_name_id\":$(\"#list_alipay_name :selected\").attr(\"index_row\"),\n        }\n    }\n    ftable.post(u.file.list,f_post,function(ret){\n\n        ftable.create({\n            \"ret\":ret,\n            \"frame\":{\n                trans:[\n                    [\"t_id\",\"ID\",\"text\"],\n                ],\n        }\n    });\n\n\n    })\n<\/pre>\n<h3>css\u90e8\u5206<\/h3>\n<pre class=\"lang:css decode:true\">\n\/*sql_window*\/\n.sql_window_bg{\n  position: absolute;\n  width: 100%;\n  height:100%;\n  top:0;\n  left: 0;\n  z-index: 11;\n}\n.sql_window_con{\n  position: absolute;\n  width: 200px;\n  height:300px;\n  z-index: 12;\n  background: #fff;\n  border: 1px solid #ddd;\n  border-width: 0 1px 4px 1px;\n  padding:10px;\n}\n\n\/*table\u8865\u5168*\/\n.table td{\n  padding: 0 2px !important;\n}\n.table-bordered th,\n .table-bordered td {\n   border: 1px solid #ddd !important;\n }\n .table-bordered th,\n .table-bordered td {\n   border: 1px solid #ddd !important;\n }\n\n.table-page-con{\n  text-align: center !important;\n  height:75px;\n}\n.table-page-con a{\n  cursor:pointer;\n}\n.table-mubu{\n  top:0;\n  left:0;\n  position: absolute;\n  z-index: 99;\n  width: 100%;\n  height: 100%;\n  background: rgba(255,255,255,.6);\n\n}\n.table td .input-group{\n  max-width: 220px !important;\n  min-width: 120px !important;\n}\n.table th {\n  white-space: nowrap;\n  padding:4px 3px !important;\n}\n<\/pre>\n<h3>\u63d2\u4ef6\u5b9a\u4e49\u90e8\u5206<\/h3>\n<pre class=\"lang:js decode:true\">\n\n\n\n*\/\n\/\/\u521b\u5efatable\nfunction jtable(){\n    var that = this;\n    this.url;\/\/\u8bf7\u6c42\u5730\u5740\n    var post_data;\/\/\u629b\u51fa\u6570\u636e\n    this.trs=[];\/\/\u5168\u90e8tr\n    this.th=[];\/\/\u8868\u5934\u6570\u636e\n    this.table=document.createElement(\"table\");\/\/\u8868\u683c\n    this.css=\"table\";\n    this.table.className=this.css;\n    this.sqlkey={};\n    var callback;\n    var ret;\n    this.target=$(\".maintable\");\/\/\u6ce8\u5165\u76ee\u6807\n    this.post=function(){\n        this.loading();\n        this.url=arguments[0];\n        post_data=arguments[1];\n        callback=(typeof(arguments[2])==\"undefined\")?callback:arguments[2];\n        ajax(this.url,post_data,callback);\n    }\n\n    var frame={\n        \"trans\":undefined,\n        \"hide\":undefined,\n        \"fixed\":undefined,\n        \"post_page_num\":undefined,\n        \"search\":undefined,\n    }\n    this.create=function(){\n        this.loadend();\n        this.target.empty();\n        this.trs=[];\/\/\u5168\u90e8tr\n        this.th=[];\/\/\u8868\u5934\u6570\u636e\n        this.table.innerHTML=\"\";\n        ret=arguments[0].ret;\n        frame=(typeof(arguments[0].frame)==\"undefined\")?frame:arguments[0].frame;\n        if(typeof(ret.data[0])==\"undefined\"){console.log(\"\u6570\u636e\u4e3a\u7a7a\");return;}\n        if(!(ret.data instanceof Array)){console.log(\"\u4f20\u5165\u975e\u6570\u7ec4\");return;}\n        \/\/\u5b58\u5728 \u9875\u7801\u5b57\u6bb5\n        if(!!ret.countnum&&!!ret.pagemax&&ret.pagemax>1){\n            this.createpage(ret);\n        }\n        \/\/\u4e0d\u5b58\u5728 sql_key\u3000\u5b57\u6bb5\n        if(!post_data.Json.sql_key){\n            that.sqlkey={};\n        }\n        for(var i =0 , len = ret.data.length; i<len ; i++){\n            var datatr=ret.data[i];\n            var datarow=i;\n            var deal=[];\n\n            if(typeof(frame.trans)==\"undefined\"){\n                for(var data_key in datatr){\n                    var data_arr=[data_key,data_key,\"text\"];\n                    deal.push(data_arr);\n                }\n            }else{\n                deal=frame.trans;\n            }\n\n            \/\/\u8868\u5934\u5904\u7406\n            if(datarow==0){\n                    \/\/\u6309\u7ffb\u8bd1\u5e8f\u5217\u6392\u961f\n                    for(var k =0 , th_deal_len = deal.length; k<th_deal_len ; k++){\n                        var element=deal[k];\n                        var index=k;\n                        var fields=element[0];\n                        var zh=element[1];\n                        var type=element[2];\n                        var select_data=(typeof(element[3])==\"undefined\")?\"\":element[3];\n                        \/\/\u5b9e\u4f8b\u5316th\n                        var th = new jt_child();\n                        th.create(\"th\",fields);\n                        th.obj.innerHTML=zh;\n                        \/\/\u68c0\u67e5\u662f\u5426\u9690\u85cf\n                        if(typeof(frame.hide)!=\"undefined\"&&in_array(fields,frame.hide)){\n                            th.obj.style.display=\"none\";\n                        }\n\n                        \/\/\u68c0\u67e5\u662f\u5426\u5728\u641c\u7d22\u5217\u540d\u5355\u4e2d\n                        if(in_array(fields,frame.search)){\n                            \/\/\u5efa\u7acb\u6309\u94ae\n                            var search_btn = document.createElement(\"button\");\n                            search_btn.className=\"btn btn-xs btn-default\";\n                            \/\/\u5224\u65ad\u662f\u5426\u6709\u641c\u7d22\u6761\u4ef6\n                            if(!!post_data.Json.sql_key&&!!this.sqlkey[fields]&&this.sqlkey[fields]!=\"\"){\n                                search_btn.className=\"btn btn-xs btn-primary\";\n                            }\n\n                            search_btn.setAttribute(\"sql_field\",fields)\n                            \/\/\u56fe\u6807\n                            var search_icon = document.createElement(\"span\");\n                            search_icon.className=\"glyphicon glyphicon-filter\";\n\n                            search_btn.addEventListener(\"click\",that.sql_call)\n                            search_btn.appendChild(search_icon);\n                            th.obj.appendChild(search_btn);\n                        }\n                        \/\/\u63d2\u5165th\u6570\u636e\n                        this.th.push(th.obj);\n                }\n\n            }\n\n            \/\/\u8868\u683c\u5185\u5bb9\n            var tr=new jt_child();\n            tr.create(\"tr\",\"file_list_row\",datarow);\n            for(var j = 0 , len_deal= deal.length; j<len_deal;j++){\n                var element=deal[j];\n                var index=j;\n                var fields=element[0];\n                var zh=element[1];\n                var type=element[2];\n                var select_data=(typeof(element[3])==\"undefined\")?\"\":element[3];\n                \/\/\u5b9e\u4f8b\u5316td\n                var td= new jt_child();\n                td.create(\"td\",fields,datarow);\n\n                var datavalue=(post_filter(datatr[fields]))?datatr[fields]:\"\";\/\/\u6570\u636e \u5b9e\u9645\u503c\n                \/\/\u5185\u5bb9\u7c7b\u578b\u5224\u65ad\n                switch (type) {\n                    \/\/\u8f93\u51fa\u6587\u672c\n                    case \"text\":\n                        var text = document.createElement(\"span\");\n                        text.innerHTML=datavalue;\n                        td.obj.appendChild(text);\n                        break;\n                    \/\/\u8f93\u51fainput\n                    case \"input\":\n                        var form_group=document.createElement(\"div\");\n                        form_group.className=\"input-group input-group-sm\";\n\n                        var input = document.createElement(\"input\");\n                        input.value=datavalue;\n                        input.setAttribute(\"type\",\"text\");\n                        input.className=\"form-control input-sm\";\n                        form_group.appendChild(input);\n\n                        \/\/\u68c0\u67e5\u662f\u5426\u6709\u989d\u5916\u5185\u5bb9\n                        if(!!select_data&&select_data!=\"\"){\n                            var span =document.createElement(\"span\");\n                            span.className=\"input-group-btn \";\n                            span.appendChild(select_data.cloneNode(true));\n                            form_group.appendChild(span);\n                        }\n\n                        td.obj.appendChild(form_group);\n                        break;\n                    \/\/\u8f93\u51fa\u72b6\u6001\u503c\n                    case \"status\":\n                        \/\/ var span = document.createElement(\"span\");\n                        \/\/ span.innerHTML=select_data[datavalue];\n\n                        datavalue.toString().split(\",\").map(function(arrele,arrind){\n                            if(arrele==\"\"){return;}\n                            if(typeof(select_data[arrele])==\"undefined\"){\n                                console.log(arrele)\n                                console.log(select_data)\n                                return;\n                            }\n                            td.obj.appendChild(select_data[arrele].cloneNode(true));\n                        })\n\n                        break;\n                    \/\/\u8f93\u51fa\u81ea\u5b9a\u4e49\u5185\u5bb9\n                    case \"custom\":\n                        var value_custom = select_data;\n\n                        switch (typeof(value_custom)) {\n                            case \"object\":\n                                td.obj.appendChild(value_custom.cloneNode(true));\n                                break;\n                            case \"string\":\n                                td.obj.innerHTML=(value_custom);\n                                break;\n                        }\n                        break;\n                    \/\/\u8f93\u51fa\u5e8f\u53f7\n                    case \"seqnum\":\n                        var value = parseInt(datarow)+1;\n                        var text = document.createElement(\"span\");\n                        text.innerHTML=value;\n                        td.obj.appendChild(text);\n                        break;\n                    default:\n\n                }\n                \/\/ td.obj.innerHTML=datavalue;\n\n                \/\/\u68c0\u67e5\u662f\u5426\u9690\u85cf\n                if(typeof(frame.hide)!=\"undefined\"&&in_array(fields,frame.hide)){\n                    td.obj.style.display=\"none\";\n                }\n\n                \/\/\u5c06td\u63d2\u5165tr\n                tr.obj.appendChild(td.obj);\n            }\n            \/\/\u91c7\u53d6custom\u65b9\u5f0f\u8f93\u51fa\uff0c\u4e0d\u518d\u5355\u72ec\u8f93\u51fa\u64cd\u4f5c\u6309\u94ae \/\/\u68c0\u67e5\u662f\u5426\u6709\u64cd\u4f5c\u6309\u94ae\n            \/\/ if(typeof(frame.operation)!=\"undefined\"){\n            \/\/  var opbtns=frame.operation;\n            \/\/  var opbtn_td = new jt_child();\n            \/\/  opbtn_td.create(\"td\",\"operation\",datarow);\n            \/\/  for(var i_btns = 0 ,len_btns=opbtns.length; i_btns<len_btns;i_btns++ ){\n            \/\/      opbtn_td.obj.appendChild(opbtns[i_btns]);\n            \/\/  }\n            \/\/  tr.obj.appendChild(opbtn_td.obj);\n            \/\/ }\n\n            this.trs.push(tr.obj);\n        }\n        \/\/\u8f93\u51fa\u6761\u6570\n        if(!!frame.post_page_num&&!!ret[frame.post_page_num.count]){\n            var p = document.createElement(\"p\");\n            p.innerHTML=\"\u603b\u5171 \"+ret[frame.post_page_num.count]+\" \u6761\u6570\u636e\";\n            this.target.append(p);\n        }\n\n\n        \/\/\u6574\u7406\n        var table_body=this.table;\n        var table_th=new jt_child();\n        table_th.create(\"tr\",\"table-head\");\n        this.th.map(function (ele_th,ind_th){\n            table_th.obj.appendChild(ele_th);\n        })\n        table_body.appendChild(table_th.obj);\n\n        this.trs.map(function(ele_tr,ind_tr){\n            table_body.appendChild(ele_tr);\n        })\n        \/\/ this.table.appendChild(this.th.obj);\n        \/\/ console.log(arguments);return;\n        \/\/ console.log(this);\n\n        this.target.append(this.table);\n\n\n    }\n    this.createpage=function(ret){\n        var now_pagenum=ret[frame.post_page_num.pagenum];\n        var now_pagemax=ret[frame.post_page_num.maxpage];\n        var now_countnum=ret[frame.post_page_num.count];\n        var now_pagecount=ret[frame.post_page_num.pagecount];\n\n\n        var table_page_con=document.createElement(\"div\");\n        table_page_con.className=\"table-page-con\";\n            var table_btn_con=document.createElement(\"ul\");\n            table_btn_con.className=\"pagination pagination-sm\";\n\n        \/\/\u5e8f\u53f7\u6570\u7ec4\n        var btn_num_arr=[];\n        var btn_max=8;\n        for(var i = 1 ; i<=btn_max ; i++){\n            var testnum=now_pagenum-Math.ceil(btn_max\/2)+i;\n            while(testnum<1||in_array(testnum,btn_num_arr)){\n                testnum++;\n            }\n            if(testnum<=now_pagemax){\n                btn_num_arr.push(testnum);\n            }\n        }\n\n        \/\/\u6309\u94ae\u6570\u7ec4\n        \/\/ var btn_arr=[];\n        \/\/\u751f\u6210\u4e0a\u4e00\u9875\u6309\u94ae\n        var pageone_con = document.createElement(\"li\");\n        var pageone_btn = document.createElement(\"a\");\n        pageone_btn.innerHTML=\"&lt;\";\n        pageone_con.appendChild(pageone_btn);\n        table_btn_con.appendChild(pageone_con);\/\/\u6ce8\u5165\n        for(var i = 0 ,len = btn_num_arr.length;i<len;i++){\n            var value = btn_num_arr[i];\n            if (i==0&&value!=1){\n\n                \/\/\u9875\u78011 \u6309\u94ae\u751f\u6210\n                var pageone_con = document.createElement(\"li\");\n                pageone_con.className=(now_pagenum==1)?\"active\":\"\";\n                var pageone_btn = document.createElement(\"a\");\n                pageone_btn.innerHTML=1;\n                pageone_con.appendChild(pageone_btn);\n                table_btn_con.appendChild(pageone_con);\/\/\u6ce8\u5165\n                \/\/\u5206\u9694\u7b26...\u751f\u6210\n                var span = document.createElement(\"span\");\n                span.innerHTML=\"...\";\n                var li = document.createElement(\"li\");\n                li.appendChild(span)\n                table_btn_con.appendChild(li);\/\/\u6ce8\u5165\n            }\n            var pageone_con = document.createElement(\"li\");\n            pageone_con.className=(now_pagenum==value)?\"active\":\"\";\n            var pageone_btn = document.createElement(\"a\");\n            pageone_btn.innerHTML=value;\n            pageone_con.appendChild(pageone_btn);\n            table_btn_con.appendChild(pageone_con);\n            if(i==(len-1)&&value!=now_pagemax){\n                var pageone_con = document.createElement(\"li\");\n                pageone_con.className=(now_pagenum==now_pagemax)?\"active\":\"\";\n                var span = document.createElement(\"span\");\n                span.innerHTML=\"...\";\n                var li = document.createElement(\"li\");\n                li.appendChild(span)\n                table_btn_con.appendChild(li);\n\n                var pageone_btn = document.createElement(\"a\");\n                pageone_btn.innerHTML=now_pagemax;\n                pageone_con.appendChild(pageone_btn);\n                table_btn_con.appendChild(pageone_con);\n            }\n        }\n        \/\/\u751f\u6210\u4e0b\u4e00\u9875\u6309\u94ae\n        var pageone_con = document.createElement(\"li\");\n        var pageone_btn = document.createElement(\"a\");\n        pageone_btn.innerHTML=\"&gt;\";\n        pageone_con.appendChild(pageone_btn);\n        table_btn_con.appendChild(pageone_con);\/\/\u6ce8\u5165\n\n        table_page_con.appendChild(table_btn_con);\n        this.target.append(table_page_con);\/\/\u5199\u5165\u5230\u76ee\u6807\n\n        for(var i = 0 ,len=table_btn_con.childElementCount;i<len;i++){\n            var element=table_btn_con.children[i].children[0];\n            \/\/ console.log(this);\n            element.addEventListener(\"click\",this.changePage);\n        }\n    }\n    this.changePage=function(){\n        \/\/ console.log(this);return;\n        var page_action = this.innerHTML;\n\n        var max_page=ret[frame.post_page_num.maxpage];\n        var pagenum_field=frame.post_page_num.pagenum;\n        var now_page=ret[pagenum_field];\n        var _post=post_data;\n        switch (true) {\n            case (page_action==\"&lt;\"):\n                if(now_page!=1){\n                    _post.Json[pagenum_field]=--now_page;\n                }\n                break;\n            case (page_action==\"&gt;\"):\n                if(now_page!=max_page){\n                    _post.Json[pagenum_field]=++now_page;\n                }\n                break;\n            case (page_action==\"...\"):\n                return;\n                break;\n            default:\n                _post.Json[pagenum_field]=page_action;\n        }\n        that.post(that.url,_post,callback);\n        \/\/ changeCreate();\n    }\n\n    this.loading=function(){\n        var mubu=document.createElement(\"div\");\n        mubu.className=\"table-mubu\";\n        this.target.append(mubu);\n    }\n    this.loadend=function(){\n        $(\".table-mubu\").remove();\n    }\n\n    this.sql_call=function(){\n        \/\/\u5168\u90e8  this.sqlkey\u7684\u8be5\u5b57\u6bb5\u4e3a\u7a7a\n        \/\/\u8bfb\u53d6 this.sqlkey \u5b57\u6bb5\n        var sqlkey_field=$(this).attr(\"sql_field\");\n        \/\/ var\n        \/\/ console.dir(this);\n        var sql_w= new sql_window();\n        sql_w.left=this.offsetLeft;\n        sql_w.top=this.offsetTop;\n        sql_w.father=this.parentElement;\n        sql_w.ret=(!!that.sqlkey)?that.sqlkey[sqlkey_field]:undefined;\n        sql_w.finish=function(){\n            var type=arguments[0];\n            var keyvalue=trim($(\".keyvalue\").val());\n\n            switch (type) {\n                case \"all\":\n\n                    that.sqlkey[sqlkey_field]=undefined;\n                    break;\n                case \"like\":\n                    that.sqlkey[sqlkey_field]={\n                        \"value\":keyvalue,\n                        \"sqltext\":sqlkey_field+\" like '%\"+keyvalue+\"%'\",\n                        sqlkey_field:type,\n                    }\n                    break;\n                case \"accuracy\":\n                    that.sqlkey[sqlkey_field]={\n                        \"value\":keyvalue,\n                        \"sqltext\":sqlkey_field+\" = '\"+keyvalue+\"'\",\n                        sqlkey_field:type,\n                    }\n                    break;\n                case \"more\":\n                    that.sqlkey[sqlkey_field]={\n                        \"value\":keyvalue,\n                        \"sqltext\":sqlkey_field+\" >= '\"+keyvalue+\"'\",\n                        sqlkey_field:type,\n                    }\n                    break;\n                case \"less\":\n                    that.sqlkey[sqlkey_field]={\n                        \"value\":keyvalue,\n                        \"sqltext\":sqlkey_field+\" <= '\"+keyvalue+\"'\",\n                        sqlkey_field:type,\n                    }\n                    break;\n            }\n            var post_sql=[];\n\n            \/\/ for(var sql_i in that.sqlkey){\n            \/\/  post_sql.push(that.sqlkey[sql_i].sqltext)\n            \/\/ }\n            post_data.Json.sql_key=that.sqlkey;\n            console.table(that.sqlkey);\n            console.log(post_data.Json.sql_key);\n\n            \/\/ post_data.Json.sql_key\n            that.post(that.url,post_data,callback)\n            sql_w.close()\n            }\n        sql_w.init();\n\n\n    }\n}\nfunction sql_window(){\n    this.top=0;\n    this.left=0;\n    this.width=250;\n    this.height=\"auto\";\n    this.father;\n    this.result;\n    this.ret;\n    var that=this;\n    this.init=function(){\n        that.father.style.position=\"relative\";\n        var sql_bg=document.createElement(\"div\");\n        sql_bg.className=\"sql_window_bg\";\n        sql_bg.addEventListener(\"click\",that.close);\n        document.body.appendChild(sql_bg);\n\n        var sql_w=document.createElement(\"div\");\n        sql_w.className=\"sql_window_con\";\n        sql_w.style.top=that.top +22+\"px\";\n        var fatherLeft=that.father.offsetLeft;\n        var winWidth=window.innerWidth;\n\n        sql_w.style.left=that.left-((fatherLeft>(winWidth\/2))?that.width:0)+\"px\";\n        sql_w.style.width=this.width+\"px\";\n        sql_w.style.height=this.height;\n        this.father.appendChild(sql_w)\n        \/\/top\n        var sql_w_top=document.createElement(\"div\");\n        sql_w_top.className=\" sql_window_top\";\n        sql_w.appendChild(sql_w_top);\n        \/\/-close\u6309\u94ae\n        var sql_close_btn=document.createElement(\"span\");\n        sql_close_btn.className=\"glyphicon glyphicon-remove pull-right\";\n        sql_close_btn.addEventListener(\"click\",that.close);\n        sql_w_top.appendChild(sql_close_btn);\n        \/\/-\u5168\u9009\u6309\u94ae\n        var sql_allselect_btn = document.createElement(\"input\");\n        sql_allselect_btn.setAttribute(\"type\",\"checkbox\");\n        sql_allselect_btn.checked=(!!this.ret&&this.ret.value!=\"\")?false:true;\n        sql_allselect_btn.addEventListener(\"click\",that.selectAll)\n        sql_w_top.appendChild(sql_allselect_btn);\n        var sql_allselect_zh=document.createElement(\"span\");\n        sql_allselect_zh.innerHTML=\"\u5168\u9009\";\n        sql_w_top.appendChild(sql_allselect_zh);\n\n        \/\/\u9009\u9879\u7a97\u53e3\n        this.sql_w_mid=document.createElement(\"div\");\n        this.sql_w_mid.className=\"sql_window_mid\";\n        sql_w.appendChild(this.sql_w_mid)\n        \/\/-\u8f93\u5165\u6846\n        var sql_input = document.createElement(\"input\");\n        sql_input.className=\"form-control keyvalue\";\n        sql_input.setAttribute(\"placeholder\",\"\u641c\u7d22\u5173\u952e\u5b57\");\n        sql_input.value=(!!that.ret&&that.ret.value!=\"\")?that.ret.value:\"\";\n        this.sql_w_mid.appendChild(sql_input);\n        \/\/-\u6309\u94ae\n        var sql_btn = document.createElement(\"button\");\n        sql_btn.className=\"btn-xs btn-primary\";\n\n        \/\/-\u6a21\u7cca\u641c\u7d22\n        var mohu_btn=sql_btn.cloneNode(true);\n        mohu_btn.innerHTML=\"\u6a21\u7cca\u641c\u7d22\";\n        mohu_btn.addEventListener(\"click\",function(){that.finish(\"like\")})\n        this.sql_w_mid.appendChild(mohu_btn)\n        \/\/-\u7cbe\u786e\u641c\u7d22\n        var acc_btn=sql_btn.cloneNode(true);\n        acc_btn.innerHTML=\"\u7cbe\u786e\u641c\u7d22\";\n        acc_btn.addEventListener(\"click\",function(){that.finish(\"accuracy\")})\n        this.sql_w_mid.appendChild(acc_btn)\n        \/\/-\u5927\u4e8e\u641c\u7d22\n        var more_btn=sql_btn.cloneNode(true);\n        more_btn.innerHTML=\"\u5927\u4e8e\u6b64\u503c\";\n        more_btn.addEventListener(\"click\",function(){that.finish(\"more\")})\n        this.sql_w_mid.appendChild(more_btn)\n        \/\/-\u5c0f\u4e8e\u641c\u7d22\n        var less_btn=sql_btn.cloneNode(true);\n        less_btn.innerHTML=\"\u5c0f\u4e8e\u6b64\u503c\";\n        less_btn.addEventListener(\"click\",function(){that.finish(\"less\")})\n        this.sql_w_mid.appendChild(less_btn)\n    }\n    this.selectAll=function(){\n        \/\/ console.dir(this);\n        if(this.checked){\n            that.finish(\"all\");\n        }\n\n    }\n    this.finish;\n    this.close=function(){\n        \/\/ alert(1);\n        $(\".sql_window_bg\").remove();\n        $(\".sql_window_con\").remove();\n\n        \/\/ $(that.father).find(\"\")\n    }\n\n}\nfunction jt_child(){\n    this.type=\"td\";\n    this.css;\n    this.row=undefined;\n    this.obj;\n    this.create=function(){\n        this.type=arguments[0];\n        this.css=arguments[1];\n        this.row=arguments[2];\n        this.obj=document.createElement(this.type);\n        this.obj.className=this.css;\n        if(typeof(this.row)!=\"undefined\"){\n            this.obj.setAttribute(\"row\",this.row)\n        }\n\n    }\n}\n\/\/\u4e0a\u4f20\u8fc7\u6ee4\nfunction post_filter(arr){\n    var post_arr_type = typeof(arr);\n    switch (post_arr_type) {\n        case \"string\":\n            if(arr == \"\"){\n                return false;\n            }\n            break;\n        case \"undefined\":\n            console.log(\"\u8f93\u5165\u7684\u8d44\u6599\u672a\u5b9a\u4e49\")\n            return false;\n            break;\n        case \"object\":\n            for(var key in arr){\n                var value = post_filter(arr[key]);\n                if(!value){\n                    return false;\n                }\n            }\n    }\n    return arr;\n}\n\/\/\u547c\u53eb\u63d0\u9192\nfunction arm (str){\n    str=(!str)?\"\u6570\u636e\u4e3a\u7a7a\":str;\n    if(!debug){alert(str)};\n    console.log(str)\n}\n\/\/\u53bb\u9664\u7a7a\u683c---\u51fd\u6570\u6cd5\n\/\/\u5220\u9664\u5de6\u53f3\u4e24\u7aef\u7684\u7a7a\u683c\nfunction trim(str){\n\u3000\u3000     return str.replace(\/(^\\s*)|(\\s*$)\/g, \"\");\n\u3000\u3000 }\n\/\/\u5220\u9664\u5de6\u8fb9\u7684\u7a7a\u683c\nfunction ltrim(str){\n    return str.replace(\/(^\\s*)\/g,\"\");\n}\n\/\/\u5220\u9664\u53f3\u8fb9\u7684\u7a7a\u683c\nfunction rtrim(str){\n    return str.replace(\/(\\s*$)\/g,\"\");\n}\n\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u4e9b\u60f3\u6cd5 1.\u9700\u8981\u4fdd\u5b58\u83b7\u53d6\u6570\u636e\u63a5\u53e3\u548c\u641c\u7d22\u63a5\u53e3 2.\u5355\u5143\u683c\u533a\u5206 \u5c55\u793a\u503c\u548c\u5b9e\u9645\u6570\u503c \u5982\u4f55\u8c03\u7528 ftable=new &hellip; <a href=\"https:\/\/loveuhouse.cn\/wordpress\/?p=488\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">jtable  bate<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[14],"tags":[],"_links":{"self":[{"href":"https:\/\/loveuhouse.cn\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/488"}],"collection":[{"href":"https:\/\/loveuhouse.cn\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/loveuhouse.cn\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/loveuhouse.cn\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/loveuhouse.cn\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=488"}],"version-history":[{"count":3,"href":"https:\/\/loveuhouse.cn\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/488\/revisions"}],"predecessor-version":[{"id":528,"href":"https:\/\/loveuhouse.cn\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/488\/revisions\/528"}],"wp:attachment":[{"href":"https:\/\/loveuhouse.cn\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=488"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/loveuhouse.cn\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=488"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/loveuhouse.cn\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}