TableAjax.php.TableAjax.js 143 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095309630973098309931003101310231033104310531063107310831093110311131123113311431153116311731183119312031213122312331243125312631273128312931303131313231333134313531363137313831393140314131423143314431453146314731483149315031513152315331543155315631573158315931603161316231633164316531663167316831693170317131723173317431753176317731783179318031813182318331843185318631873188318931903191319231933194319531963197319831993200320132023203320432053206320732083209321032113212321332143215321632173218321932203221322232233224322532263227322832293230323132323233323432353236323732383239324032413242324332443245324632473248324932503251325232533254325532563257325832593260326132623263326432653266326732683269327032713272327332743275327632773278327932803281328232833284328532863287328832893290329132923293329432953296329732983299330033013302330333043305330633073308330933103311331233133314331533163317331833193320332133223323332433253326332733283329333033313332333333343335333633373338333933403341334233433344334533463347334833493350335133523353335433553356335733583359336033613362336333643365336633673368336933703371337233733374337533763377337833793380338133823383338433853386338733883389339033913392339333943395339633973398339934003401340234033404340534063407340834093410341134123413341434153416341734183419342034213422342334243425342634273428342934303431343234333434343534363437343834393440344134423443344434453446344734483449345034513452345334543455345634573458345934603461346234633464346534663467346834693470347134723473347434753476347734783479348034813482348334843485348634873488348934903491349234933494349534963497349834993500350135023503350435053506350735083509351035113512351335143515351635173518351935203521352235233524352535263527352835293530353135323533353435353536353735383539354035413542354335443545354635473548354935503551355235533554355535563557355835593560356135623563356435653566356735683569357035713572357335743575357635773578357935803581358235833584358535863587358835893590359135923593359435953596359735983599360036013602360336043605360636073608360936103611361236133614361536163617361836193620362136223623362436253626362736283629363036313632363336343635363636373638363936403641364236433644364536463647364836493650365136523653365436553656365736583659366036613662366336643665366636673668366936703671367236733674367536763677367836793680368136823683368436853686368736883689369036913692369336943695369636973698369937003701370237033704370537063707370837093710371137123713371437153716371737183719372037213722372337243725372637273728372937303731373237333734373537363737373837393740374137423743374437453746374737483749
  1. if (!URI_BASE) throw "Missing URI_BASE"; // => Request::getPathUri()
  2. if (!URI_WPS) throw "Missing URI_WPS";
  3. if (!global.jQuery) throw "Missing jQuery"
  4. var $ = global.jQuery
  5. var RENDER_AS_REACT = Boolean(RENDER_AS_REACT) || false
  6. var SKIP_TOTAL = Boolean(SKIP_TOTAL) || false
  7. var DBG = DBG || false;
  8. var DBG1 = true;
  9. if (!global.p5VendorJs) throw "Missing p5 Vendor js libs";
  10. if (!global.p5VendorJs.Redux) throw "Missing p5 Vendor js lib: Redux";
  11. if (!global.createTableFiltersStateObject) throw "Missing createTableFiltersStateObject";
  12. if (!global.createTableSelectedStateObject) throw "Missing createTableSelectedStateObject";
  13. if (!global.createTableDataStateObject) throw "Missing createTableDataStateObject";
  14. var createReactClass = global.p5VendorJs.createReactClass;
  15. var h = global.p5VendorJs.React.createElement;
  16. var ReactDOM = global.p5VendorJs.ReactDOM;
  17. var Redux = global.p5VendorJs.Redux;
  18. var ReduxThunk = global.p5VendorJs.ReduxThunk;
  19. var createStoreWithThunkMiddleware = Redux.applyMiddleware(ReduxThunk)(Redux.createStore); // TODO: to vendor.js
  20. var p5UI__FieldCheckboxSearch = global.p5VendorJs['p5UI__FieldCheckboxSearch'];
  21. var p5UI__FieldCheckboxLoading = global.p5VendorJs['p5UI__FieldCheckboxLoading'];
  22. var p5UI__TableAjaxWidget = global.p5VendorJs['p5UI__TableAjax'];
  23. var P5UI__TableAjaxSortableLabel = global.p5VendorJs['P5UI__TableAjaxSortableLabel'];
  24. var P5UI__TableAjaxRowCheckbox = global.p5VendorJs['P5UI__TableAjaxRowCheckbox'];
  25. var P5UI__TableAjaxSelectedInfo = global.p5VendorJs['P5UI__TableAjaxSelectedInfo'];
  26. if (!String.prototype.startsWith) { // TODO: to global js utils
  27. String.prototype.startsWith = function(search, pos) {
  28. return this.substr(!pos || pos < 0 ? 0 : +pos, search.length) === search;
  29. };
  30. }
  31. p5WfsRefFilter = (function () { // convert GET param key ogc filter for ref
  32. return {
  33. parse: function (filterKey) {
  34. if (filterKey.startsWith('Ref_From_')) return { type: 'From', idInstance: filterKey.substr('Ref_From_'.length) };
  35. if (filterKey.startsWith('Ref_To_')) return { type: 'To', idInstance: filterKey.substr('Ref_To_'.length) };
  36. return null;
  37. }
  38. };
  39. })();
  40. function p5Utils__mapToQuery(map, callback) {
  41. var mapCallback = ('function' === typeof callback) ? callback : function (key) {
  42. return '' + key + '=' + encodeURIComponent(map.get(key));
  43. };
  44. return Array.from(map.keys()).sort()
  45. .map(mapCallback)
  46. .join('&')
  47. }
  48. function p5Utils__mapToQueryWithKeyPrefix(map, keyPrefix, callback) {
  49. var mapCallback = ('function' === typeof callback) ? callback : function (key) {
  50. return '' + (keyPrefix || '') + key + '=' + encodeURIComponent(map.get(key));
  51. };
  52. return p5Utils__mapToQuery(map, mapCallback)
  53. }
  54. function p5Utils__objectToQueryWithKeyPrefix(obj, prefix, callback) {
  55. if (!obj) return '';
  56. var mapCallback = ('function' === typeof callback) ? callback : function (key) {
  57. return '' + key + '=' + encodeURIComponent(obj[key]);
  58. };
  59. return Object.keys(obj).sort()
  60. .map(mapCallback)
  61. .join('&')
  62. }
  63. function p5Utils__multiReplaceValues(input, row) {
  64. return Object.keys(row).reduce(function (ret, fieldName) {
  65. return ret.replace(new RegExp('\{' + fieldName + '\}', 'g'), row[fieldName])
  66. }, input)
  67. }
  68. global['P5UI__TableAjaxSpecialFilter'] = createReactClass({
  69. // props.store: Redux store with state: { isLoading bool, selected array of strings }
  70. // props.actions: Redux store actions
  71. // props.name: PropTypes.string.isRequired
  72. // props.values: PropTypes.array.isRequired
  73. // props.icon: PropTypes.string.isRequired
  74. // props.label: PropTypes.string
  75. getStateFromStore: function () {
  76. var state = this.props.store.getState();
  77. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilter::getStateFromStore (name:'+this.props.name+')', { store: state, name: this.props.name, selected: state.specialFilter.get(this.props.name) });
  78. return {
  79. selected: state.specialFilter.get(this.props.name),
  80. };
  81. },
  82. getInitialState: function () {
  83. return this.getStateFromStore();
  84. },
  85. componentDidMount: function () {
  86. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilter::componentDidMount (name:'+this.props.name+')');
  87. this.unsubscribe = this.props.store.subscribe(this.storeUpdated)
  88. },
  89. componentWillUnmount: function () {
  90. this.unsubscribe()
  91. },
  92. storeUpdated: function () {
  93. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilter::storeUpdated (name:'+this.props.name+')');
  94. this.setState(this.getStateFromStore())
  95. },
  96. shouldComponentUpdate: function (nextProps, nextState) {
  97. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilter::shouldComponentUpdate (name:'+this.props.name+')', { state: this.state, nextState});
  98. return (
  99. this.state.selected !== nextState.selected
  100. );
  101. },
  102. handleRemoveFilter: function (event) {
  103. this.props.store.dispatch( this.props.actions.setSpecialFilter(this.props.name, '') );
  104. },
  105. handleSetFilter: function (value) {
  106. this.props.store.dispatch( this.props.actions.setSpecialFilter(this.props.name, value) );
  107. },
  108. renderButton: function (buttonKey) {
  109. var option = buttonKey;
  110. var props = this.props.values[option];
  111. var value = props.value || '';
  112. var state = this.props.store.getState();
  113. DBG && console.warn('DBG:renderButton state', { state, props, value });
  114. var active = (value === this.state.selected);
  115. return h('button', {
  116. className: "btn btn-xs btn-default" + ( active ? " active" : "" ),
  117. onClick: function (event) {
  118. DBG && console.warn('DBG:renderButton click', { value });
  119. this.handleSetFilter(value);
  120. }.bind(this),
  121. }, option);
  122. },
  123. render: function () {
  124. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilter::render (name:'+this.props.name+')', { state: this.state, props: this.props });
  125. var label = this.props.label || this.props.name;
  126. return h('div', { className: "btn-group", style: { margin: '0 4px 0 0' } },
  127. [
  128. h('button', {
  129. className: "btn btn-xs btn-default",
  130. title: label,
  131. }, [
  132. h('i', { className: this.props.icon })
  133. ])
  134. ].concat(
  135. Object.keys(this.props.values).map(this.renderButton)
  136. ).concat(
  137. [
  138. h('button', {
  139. className: "btn btn-xs btn-default",
  140. title: "Kasuj filtr",
  141. disabled: !this.state.selected,
  142. onClick: this.handleRemoveFilter,
  143. style: { color: !this.state.selected ? '#bbb' : '#f00' }
  144. }, [
  145. h('i', { className: "glyphicon glyphicon-remove" })
  146. ])
  147. ]
  148. )
  149. );
  150. }
  151. });
  152. global['P5UI__TableAjaxSpecialFilterRelations'] = createReactClass({
  153. // props.store: Redux store with state: { isLoading bool, selected array of strings }
  154. // props.actions: Redux store actions
  155. // props.name: PropTypes.string.isRequired
  156. // props.values: PropTypes.array.isRequired
  157. // props.icon: PropTypes.string.isRequired
  158. // props.label: PropTypes.string
  159. // props.availableBackRefs: PropTypes.array.isRequired // array of objects { id, namespace, label }
  160. // props.availableChildRefs: PropTypes.array.isRequired // array of objects { id, namespace, label }
  161. getStateFromStore: function () {
  162. var state = this.props.store.getState();
  163. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilterRelations::getStateFromStore (name:'+this.props.name+')', { store: state, name: this.props.name, selected: state.specialFilter.get(this.props.name) });
  164. var selected = []; // Array of { idInstance, primaryKey }
  165. state.specialFilter.forEach(function (value, key) {
  166. var refInfo = p5WfsRefFilter.parse(key); // null | { type: 'From' | 'To', idInstance: int }
  167. if (refInfo) {
  168. selected.push(Object.assign(refInfo, { primaryKey: value, filterKey: key }))
  169. }
  170. })
  171. DBG && console.log('TODO: DBG::P5UI__TableAjaxSpecialFilterRelations::getStateFromStore (name:'+this.props.name+')', { store: state, name: this.props.name, selected });
  172. return {
  173. selected: selected,
  174. };
  175. },
  176. getInitialState: function () {
  177. return this.getStateFromStore();
  178. },
  179. componentDidMount: function () {
  180. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilterRelations::componentDidMount (name:'+this.props.name+')');
  181. this.unsubscribe = this.props.store.subscribe(this.storeUpdated)
  182. },
  183. componentWillUnmount: function () {
  184. this.unsubscribe()
  185. },
  186. storeUpdated: function () {
  187. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilterRelations::storeUpdated (name:'+this.props.name+')');
  188. this.setState(this.getStateFromStore())
  189. },
  190. shouldComponentUpdate: function (nextProps, nextState) {
  191. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilterRelations::shouldComponentUpdate (name:'+this.props.name+')', { state: this.state, nextState});
  192. return (
  193. this.state.selected !== nextState.selected
  194. );
  195. },
  196. handleRemoveFilter: function (event) {
  197. this.props.store.dispatch( this.props.actions.setSpecialFilter(this.props.name, '') );
  198. },
  199. handleSetFilter: function (value) {
  200. this.props.store.dispatch( this.props.actions.setSpecialFilter(this.props.name, value) );
  201. },
  202. handleCreate: function () {
  203. // TODO: save swal reference to variable to avoid open twice?
  204. var inputOptions = {};
  205. if (this.props.availableBackRefs) this.props.availableBackRefs.forEach(function (instanceInfo) {
  206. inputOptions[ 'From_' + instanceInfo.id ] = "z " + instanceInfo.label || instanceInfo.namespace;
  207. });
  208. if (this.props.availableChildRefs) this.props.availableChildRefs.forEach(function (instanceInfo) {
  209. inputOptions[ 'To_' + instanceInfo.id ] = "do " + instanceInfo.label || instanceInfo.namespace;
  210. });
  211. swal({
  212. title: "Wybierz rodzaj relacji",
  213. input: 'select',
  214. inputOptions: inputOptions,
  215. inputPlaceholder: "Wybierz",
  216. showCancelButton: true,
  217. cancelButtonText: "Anuluj",
  218. animation: false,
  219. inputValidator: function (value) {
  220. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilterRelations::inputValidator', value);
  221. return new Promise(function (resolve) {
  222. if (!value) {
  223. resolve('Nie wybrano obiektu');
  224. } else {
  225. resolve();
  226. }
  227. });
  228. },
  229. }).then(this.handleInstanceCreate) // args: { value: ... }
  230. },
  231. handleInstanceCreate: function (result) {
  232. if (!result.value) return; // cancel when result = { dismiss: "cancel" }
  233. var idInstance = '';
  234. var type = '';
  235. var instanceLabel = '';
  236. if ('From_' === result.value.substr(0, 'From_'.length)) {
  237. type = 'From';
  238. idInstance = result.value.substr('From_'.length);
  239. if (this.props.availableBackRefs) this.props.availableBackRefs.forEach(function (instanceInfo) {
  240. if (idInstance == instanceInfo.id) instanceLabel = instanceInfo.label || instanceInfo.namespace;
  241. });
  242. }
  243. else if ('To_' === result.value.substr(0, 'To_'.length)) {
  244. type = 'To';
  245. idInstance = result.value.substr('To_'.length);
  246. if (this.props.availableChildRefs) this.props.availableChildRefs.forEach(function (instanceInfo) {
  247. if (idInstance == instanceInfo.id) instanceLabel = instanceInfo.label || instanceInfo.namespace;
  248. });
  249. }
  250. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilterRelations::handleInstanceCreate (name:'+this.props.name+') selected instance('+idInstance+')', { result: result, state: this.state, props: this.props, availableBackRefs: this.props.availableBackRefs });
  251. swal({
  252. title: "Wybierz obiekt",
  253. html: (instanceLabel) ? "typu: " + instanceLabel : "",
  254. input: 'text',
  255. inputPlaceholder: "Wybierz obiekt",
  256. showCancelButton: true,
  257. cancelButtonText: "Anuluj",
  258. animation: false,
  259. inputValidator: function (value) {
  260. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilterRelations::inputValidator', value);
  261. return new Promise(function (resolve) {
  262. if (!value) {
  263. resolve('Nie podano obiektu');
  264. } else {
  265. resolve();
  266. }
  267. });
  268. },
  269. preConfirm: function (value) {
  270. return {
  271. type: type,
  272. idInstance: idInstance,
  273. primaryKey: value,
  274. }
  275. }
  276. }).then(this.handleInstancePrimaryKeySelected) // args: { value: { idInstance, primaryKey } }
  277. },
  278. handleInstancePrimaryKeySelected: function (result) {
  279. if (!result.value) return; // cancel when result = { dismiss: "cancel" }
  280. var type = result.value.type;
  281. var idInstance = result.value.idInstance;
  282. var primaryKey = result.value.primaryKey;
  283. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilterRelations::handleInstancePrimaryKeySelected (name:'+this.props.name+') selected featureID('+idInstance+'.'+primaryKey+')', { result: result, state: this.state, props: this.props, availableBackRefs: this.props.availableBackRefs });
  284. this.props.store.dispatch( this.props.actions.setSpecialFilter('Ref_' + type + '_' + idInstance, primaryKey) );
  285. },
  286. renderButton: function (buttonKey) {
  287. var option = buttonKey;
  288. var props = this.props.values[option];
  289. var value = props.value || '';
  290. var state = this.props.store.getState();
  291. DBG && console.warn('DBG:renderButton state', { state, props, value });
  292. var active = (value === this.state.selected);
  293. return h('button', {
  294. className: "btn btn-xs btn-default" + ( active ? " active" : "" ),
  295. onClick: function (event) {
  296. DBG && console.warn('DBG:renderButton click', { value });
  297. this.handleSetFilter(value);
  298. }.bind(this),
  299. }, option);
  300. },
  301. renderLabel: function () {
  302. var label = this.props.label || this.props.name;
  303. return h('button', {
  304. className: "btn btn-xs btn-default",
  305. title: label,
  306. style: {
  307. color: '#31708f',
  308. backgroundColor: '#d9edf7',
  309. }
  310. }, [
  311. h('i', { className: this.props.icon }),
  312. " Filtr relacji: ",
  313. ]);
  314. },
  315. renderListSelected: function () { // @return array of react nodes
  316. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilterRelations::this.props.availableBackRefs (name:'+this.props.name+')', { state: this.state, props: this.props, availableBackRefs: this.props.availableBackRefs });
  317. return this.state.selected.map(this.renderSelected);
  318. },
  319. renderSelected: function (selected) { // @selected: { type: 'From' | 'To', filterKey, idInstance, primaryKey }, @return react node
  320. var filterKey = selected.filterKey;
  321. var type = selected.type; // From | To - backRef | childRef
  322. var idInstance = selected.idInstance;
  323. var primaryKey = selected.primaryKey;
  324. var namespace = idInstance;
  325. var label = "" + idInstance + "." + primaryKey + "";
  326. if ('From' === type) {
  327. var foundInstanceInfo = this.props.availableBackRefs.filter(function (instanceInfo) {
  328. return ( parseInt(idInstance) === parseInt(instanceInfo.id) );
  329. });
  330. if (foundInstanceInfo.length > 0) label = 'z ' + foundInstanceInfo[0].label + "." + primaryKey;
  331. if (foundInstanceInfo.length > 0) namespace = foundInstanceInfo[0].namespace;
  332. } else if ('To' === type) {
  333. var foundInstanceInfo = this.props.availableChildRefs.filter(function (instanceInfo) {
  334. return ( parseInt(idInstance) === parseInt(instanceInfo.id) );
  335. });
  336. if (foundInstanceInfo.length > 0) label = 'do ' + foundInstanceInfo[0].label + "." + primaryKey;
  337. if (foundInstanceInfo.length > 0) namespace = foundInstanceInfo[0].namespace;
  338. }
  339. return h(P5UI__TableAjaxSpecialFilterRelationFrom, {
  340. filterKey: filterKey,
  341. label: label,
  342. namespace: namespace,
  343. primaryKey: primaryKey,
  344. store: this.props.store,
  345. actions: this.props.actions,
  346. });
  347. },
  348. renderBackRef: function () { // @return react node - button with dropdown to select primaryKey from parent instance + remove button if selected
  349. return null;
  350. },
  351. renderCreateButton: function () {
  352. return h('button', {
  353. className: "btn btn-xs btn-default",
  354. title: "Dodaj nowy filtr relacji",
  355. onClick: this.handleCreate,
  356. }, [
  357. h('i', { className: 'glyphicon glyphicon-plus' })
  358. ]);
  359. },
  360. render: function () {
  361. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilterRelations::render (name:'+this.props.name+')', { state: this.state, props: this.props });
  362. return h('div', { className: "btn-group", style: { margin: '0 4px 0 0' } },
  363. [
  364. this.renderLabel(),
  365. ].concat(
  366. this.renderListSelected()
  367. ).concat([
  368. this.renderCreateButton()
  369. ])
  370. // Object.keys(this.props.values).map(this.renderButton)
  371. // ).concat(
  372. // [
  373. // h('button', {
  374. // className: "btn btn-xs btn-default",
  375. // title: "Kasuj filtr",
  376. // disabled: !this.state.selected,
  377. // onClick: this.handleRemoveFilter,
  378. // style: { color: !this.state.selected ? '#bbb' : '#f00' }
  379. // }, [
  380. // h('i', { className: "glyphicon glyphicon-remove" })
  381. // ])
  382. // ]
  383. );
  384. }
  385. });
  386. global['P5UI__TableAjaxSpecialFilterRelationFrom'] = createReactClass({
  387. handleRemoveFilter: function (event) {
  388. this.props.store.dispatch( this.props.actions.setSpecialFilter(this.props.filterKey, '') );
  389. },
  390. render: function () {
  391. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilterRelationFrom::render (filterKey:'+this.props.filterKey+')', { state: this.state, props: this.props });
  392. var refInfo = p5WfsRefFilter.parse(this.props.filterKey); // null | { type: 'From' | 'To', idInstance: int }
  393. return h('button', {
  394. className: "btn btn-xs btn-default active",
  395. title: "Powiązane" + ( 'From' === refInfo.type ? " z " : " do " ) + this.props.namespace + " " + this.props.primaryKey,
  396. // onClick: this.handleUpdate, // TODO: paste param
  397. }, [
  398. this.props.label,
  399. h('i', {
  400. className: 'glyphicon glyphicon-remove',
  401. style: {
  402. color: '#f00',
  403. opacity: 0.5,
  404. marginLeft: "3px",
  405. },
  406. onClick: this.handleRemoveFilter,
  407. })
  408. ]);
  409. }
  410. });
  411. global['P5UI__TableAjaxSpecialFilters'] = createReactClass({
  412. // props.store: Redux store with state: { isLoading bool, selected array of strings }
  413. // props.actions: Redux store actions
  414. // props.namespace: PropTypes.string.isRequired
  415. // props.specialFilters: PropTypes.object.isRequired
  416. // props.specialFilters:
  417. // [Msgs] => stdClass Object
  418. // [icon] => glyphicon glyphicon-envelope
  419. // [label] => Wiadomości
  420. // [btns] => Array:
  421. // [WIADOMOSCI] => stdClass Object
  422. // [value] => HAS_MSGS
  423. // [NOWE] => stdClass Object
  424. // [value] => NEW_MSGS
  425. // [BRAK_WIAD.] => stdClass Object
  426. // [value] => NO_MSGS
  427. // [Status] => stdClass Object
  428. // [icon] => glyphicon glyphicon-question-sign
  429. // [btns] => Array:
  430. // [OCZEKUJACY] => stdClass Object
  431. // [value] => WAITING
  432. // [AKTYWNI] => stdClass Object
  433. // [value] => AKTYWNI
  434. // handleClick: function (event) {
  435. // DBG && console.log('DBG::P5UI__TableAjaxSpecialFilters::handleChange (ns:'+this.props.namespace+')', { checked: checked });
  436. // this.props.store.dispatch( this.props.actions.unselectAll( this.props.namespace ) )
  437. // },
  438. renderSpecialFilter: function (key) {
  439. var props = this.props.specialFilters[key];
  440. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilters::renderSpecialFilter (ns:'+this.props.namespace+')', { key: key, props, state: this.state });
  441. if ('RELATIONS' === props.type) {
  442. DBG && console.warn('DBG::P5UI__TableAjaxSpecialFilters::renderSpecialFilter TODO render RELATIONS filter (ns:'+this.props.namespace+')', { props, state: this.state });
  443. return h(P5UI__TableAjaxSpecialFilterRelations, {
  444. store: this.props.store,
  445. actions: this.props.actions,
  446. name: key,
  447. icon: props.icon,
  448. label: props.label,
  449. availableBackRefs: props.availableBackRefs,
  450. availableChildRefs: props.availableChildRefs,
  451. });
  452. }
  453. return h(P5UI__TableAjaxSpecialFilter, {
  454. store: this.props.store,
  455. actions: this.props.actions,
  456. name: key,
  457. icon: props.icon,
  458. label: props.label,
  459. values: props.btns,
  460. });
  461. },
  462. render: function () {
  463. DBG && console.log('DBG::P5UI__TableAjaxSpecialFilters::render (ns:'+this.props.namespace+')', { props: this.props, state: this.state });
  464. return h('div', {}, Object.keys(this.props.specialFilters).map(this.renderSpecialFilter))
  465. }
  466. });
  467. global['P5UI__TableAjaxFieldCheckboxSearch'] = createReactClass({
  468. // props.namespace: PropTypes.string.isRequired
  469. // props.fieldName: PropTypes.string.isRequired
  470. // props.store: Redux store with state: { isLoading bool, selected array of strings }
  471. // props.actions: Redux store actions
  472. getStateFromStore: function () {
  473. var state = this.props.store.getState();
  474. // selected = || 2 // 0 - unchecked, 1 - checked, 2 - indeterminate
  475. var selected = '';
  476. if (state.filter.has(this.props.fieldName)) {
  477. selected = state.filter.get(this.props.fieldName)
  478. }
  479. return {
  480. disabled: this.props.disabled ? true : false,
  481. selected: selected,
  482. active: ('YES' === selected || 'NO' === selected),
  483. // isLoading: (-1 !== state.loading.indexOf(this.props.fieldName)),
  484. // checked: (-1 !== state.selected.indexOf(this.props.fieldName))
  485. };
  486. },
  487. getInitialState: function() {
  488. return this.getStateFromStore();
  489. },
  490. componentDidMount: function () {
  491. DBG && console.log('DBG::P5UI__TableAjaxFieldCheckboxSearch::componentDidMount (f:'+this.props.fieldName+')');
  492. this.unsubscribe = this.props.store.subscribe(this.storeUpdated)
  493. },
  494. componentWillUnmount: function () {
  495. this.unsubscribe()
  496. },
  497. storeUpdated: function () {
  498. DBG && console.log('DBG::P5UI__TableAjaxFieldCheckboxSearch::storeUpdated (f:'+this.props.fieldName+')', this.getStateFromStore());
  499. this.setState(this.getStateFromStore())
  500. },
  501. shouldComponentUpdate: function (nextProps, nextState) {
  502. DBG && console.log('DBG::P5UI__TableAjaxFieldCheckboxSearch::shouldComponentUpdate (f:'+this.props.fieldName+')', { state: this.state, nextState});
  503. return (
  504. this.state.disabled !== nextState.disabled
  505. || this.state.selected !== nextState.selected
  506. );
  507. },
  508. handleChange: function (selected) { // selected: 0 - not checked, 1 - checked, 2 - indeterminate
  509. DBG && console.log('DBG::P5UI__TableAjaxFieldCheckboxSearch::handleChange (f:'+this.props.fieldName+')', { selected: selected, state: this.state });
  510. if (0 === selected) {
  511. this.props.store.dispatch( this.props.actions.setFilter(this.props.fieldName, 'NO') );
  512. } else if (1 === selected) {
  513. this.props.store.dispatch( this.props.actions.setFilter(this.props.fieldName, 'YES') );
  514. } else if (2 === selected) {
  515. this.props.store.dispatch( this.props.actions.setFilter(this.props.fieldName, '') );
  516. }
  517. },
  518. mapSelectedToValue: function (selected) {
  519. switch (selected) {
  520. case 'YES': return 1;
  521. case 'NO': return 0;
  522. default: return 2;
  523. }
  524. },
  525. render: function () {
  526. DBG && console.log('DBG::P5UI__TableAjaxFieldCheckboxSearch::render (f:'+this.props.fieldName+')', { props: this.props, state: this.state, state_sel: this.state.selected, sel: this.mapSelectedToValue(this.state.selected) });
  527. return h('div',
  528. {
  529. style: {
  530. boxSizing: 'border-box', width: '100%', height: '21px', padding: '0 5px', borderTop: 0,
  531. borderBottom: '2px solid ' + ( this.state.active ? '#00ACCC' : 'transparent' ),
  532. },
  533. }, [
  534. h(p5UI__FieldCheckboxSearch, {
  535. size: 19,
  536. color: '#888',
  537. staticLabel: ["Pokaż:", "wszystkie,", "wybrane,", "niewybrane"].join("\n"),
  538. fieldName: this.props.fieldName,
  539. selected: this.mapSelectedToValue(this.state.selected),
  540. onChange: this.handleChange
  541. // checked: this.state.checked,
  542. // disabled: this.state.disabled,
  543. // isLoading: this.state.isLoading,
  544. }),
  545. ]
  546. );
  547. }
  548. });
  549. global['p5UI__FieldInputFilterSearch'] = createReactClass({
  550. // props.fieldName: PropTypes.string.isRequired
  551. // props.type: PropTypes.string.isRequired
  552. // props.store: Redux store with state: { }
  553. // props.actions: Redux store actions
  554. // props.disabled: PropTypes.bool
  555. // props.lagacyProps: PropTypes.object
  556. getStateFromStore: function () {
  557. var storeState = this.props.store.getState();
  558. return {
  559. value: storeState.filter.get(this.props.fieldName) || '',
  560. active: storeState.filter.has(this.props.fieldName)
  561. };
  562. },
  563. getInitialState: function() {
  564. return this.getStateFromStore();
  565. },
  566. componentDidMount: function () {
  567. DBG && console.log('DBG::p5UI__FieldInputFilterSearch::componentDidMount (f:'+this.props.fieldName+')');
  568. this.unsubscribe = this.props.store.subscribe(this.storeUpdated)
  569. },
  570. componentWillUnmount: function () {
  571. this.unsubscribe()
  572. },
  573. storeUpdated: function () {
  574. DBG && console.log('DBG::p5UI__FieldInputFilterSearch::storeUpdated (f:'+this.props.fieldName+')', this.getStateFromStore());
  575. this.setState(this.getStateFromStore())
  576. },
  577. shouldComponentUpdate: function (nextProps, nextState) {
  578. DBG && console.log('DBG::p5UI__FieldInputFilterSearch::shouldComponentUpdate (f:'+this.props.fieldName+')', { state: this.state, nextState});
  579. return (
  580. this.state.value !== nextState.value
  581. || this.state.active !== nextState.active
  582. );
  583. },
  584. handleChange: function (event) { // handleChange: function (event) {
  585. var value = event.target.value;
  586. DBG && console.log('DBG::p5UI__FieldInputFilterSearch::handleChange (f:'+this.props.fieldName+')', { value });
  587. this.setState({ value: value });
  588. this.props.onChange(this.props.fieldName, value);
  589. // this.props.store.dispatch( this.props.actions.toggle( this.props.namespace, this.props.primaryKey, checked ) )
  590. },
  591. render: function () {
  592. DBG && console.log('DBG::p5UI__FieldInputFilterSearch::render (f:'+this.props.fieldName+',v:'+this.state.value+')', { props: this.props, state: this.state });
  593. switch (this.props.type) {
  594. case "number":
  595. case "date":
  596. case "bool":
  597. case "p5:price":
  598. case "p5:www_link":
  599. case "p5:string":
  600. case "string": return this.renderInput();
  601. case "special": return this.renderEmpty();
  602. case "simpleLink": return this.renderEmpty();
  603. case "geom": return this.renderInput();
  604. case "none": return this.renderEmpty();
  605. case "ref": return this.renderEmpty();
  606. default: return this.renderEmpty();
  607. }
  608. },
  609. renderEmpty: function () {
  610. return h('div', {}, " ");
  611. },
  612. renderInput: function () {
  613. return h('input', {
  614. className: "filter", // + ( this.state.active ? " filter-active" : "" ),
  615. placeholder: !this.props.disabled ? "%" : "",
  616. type: "text",
  617. disabled: this.props.disabled || false,
  618. style: {
  619. boxSizing: 'border-box', width: '100%', height: '21px', borderTop: 0,
  620. borderBottom: '2px solid ' + ( this.state.active ? '#00ACCC' : 'transparent' ),
  621. },
  622. value: this.state.value,
  623. onChange: this.handleChange
  624. });
  625. }
  626. });
  627. global['p5UI__TableAjaxClearAllFilters'] = createReactClass({
  628. // props.store: Redux store with state: { }
  629. // props.actions: Redux store actions
  630. getStateFromStore: function () {
  631. var storeState = this.props.store.getState();
  632. return {
  633. isFiltersEmpty: ( 0 === storeState.filter.size && 0 === storeState.specialFilter.size )
  634. };
  635. },
  636. getInitialState: function() {
  637. return this.getStateFromStore();
  638. },
  639. componentDidMount: function () {
  640. DBG && console.log('DBG::p5UI__TableAjaxClearAllFilters::componentDidMount (f:'+this.props.fieldName+')');
  641. this.unsubscribe = this.props.store.subscribe(this.storeUpdated)
  642. },
  643. componentWillUnmount: function () {
  644. this.unsubscribe()
  645. },
  646. storeUpdated: function () {
  647. DBG && console.log('DBG::p5UI__TableAjaxClearAllFilters::storeUpdated (f:'+this.props.fieldName+')', this.getStateFromStore());
  648. this.setState(this.getStateFromStore())
  649. },
  650. // shouldComponentUpdate: function (nextProps, nextState) {
  651. // DBG && console.log('DBG::p5UI__TableAjaxClearAllFilters::shouldComponentUpdate (f:'+this.props.fieldName+')', { state: this.state, nextState});
  652. // return (
  653. // this.state.value !== nextState.value
  654. // || this.state.active !== nextState.active
  655. // );
  656. // },
  657. handleClick: function (event) {
  658. DBG && console.log('DBG::p5UI__TableAjaxClearAllFilters::handleClick (clearAllFilters)');
  659. this.props.store.dispatch( this.props.actions.clearAllFilters() )
  660. },
  661. render: function () {
  662. DBG && console.log('DBG::p5UI__TableAjaxClearAllFilters::render (clearAllFilters)', { props: this.props, state: this.state });
  663. return h('i', {
  664. title: this.props.title || "Kasuj wszystkie filtry",
  665. className: "glyphicon glyphicon-remove",
  666. style: Object.assign(
  667. {
  668. opacity: '0.5',
  669. lineHeight: '20px',
  670. padding: '0 3px',
  671. cursor: 'pointer',
  672. },
  673. this.state.isFiltersEmpty ? { color: '#777' } : { color: '#f00' }
  674. ),
  675. onClick: this.handleClick
  676. });
  677. }
  678. });
  679. var TableAjax = function() {
  680. var priv = {}; //private api
  681. var publ = {}; //public api
  682. priv.options = {};
  683. var defaults = {
  684. namespace: '',
  685. url: '', //webservice url
  686. urlPost: false, //use POST instead of GET
  687. selectAllByFilterUrl: '',
  688. getCsvTheGeomAjaxUrl: '',
  689. removeTheGeomAjaxUrl: '',
  690. moreFunctionsCellAjaxUrl: '',
  691. editInlineSaveUrl: '',
  692. theGeomSaveUrl: '',
  693. pageSizeSave: '',
  694. hiddenColsSaveUrl: '',
  695. editInlineUrl: '',
  696. addUserTableFilterAjaxUrl: '',
  697. rmUserTableFilterAjaxUrl: '',
  698. hasAdditionalLayers: 0,
  699. labelHtml: '',
  700. debug: false, //prints debug info to console
  701. filter: false, //show filter row
  702. filterInit: false,// init filters data
  703. forceFilterInit: false,
  704. columnPicker: false, //show columnpicker
  705. checkboxes: false, //show body checkboxes
  706. actions: '', //holds action links
  707. pageSize: 10, //current pagesize
  708. pageSizes: [10, 20, 30, 40, 50, 'All'], //available pagesizes
  709. hidePagerOnEmpty: false, //removes pager if no rows
  710. types: { //type specific options
  711. string: {},
  712. number: {},
  713. bool: {},
  714. date: {}
  715. },
  716. rowFunctions: false,
  717. tblFunctions: false,
  718. specialFilterFunctions: false,
  719. selectedFunctions: false,
  720. filtersClean: false,
  721. router: false,
  722. longDesc: false,
  723. exportFields: [],
  724. mapEditor: false, // mapEditor visible or not
  725. mapEditorContainer: 'window' // 'window' or 'dock'
  726. };
  727. var _reactUITableNode; // TODO: react table node
  728. var _uiNodeCont; // container holding table
  729. var _uiNodeSelectedInfo;
  730. var _uiNodeSpecialFilters;
  731. var _uiNodeFooterInfo;
  732. var _uiNode$Table; // the table node
  733. var _head; // table header
  734. var _headSort; // table header sorting row
  735. var _headFilter; // table header columns filter row
  736. var _headSpecialFilter; // table header special filter row
  737. var _bodyNode; // table body
  738. var _body; // TODO: table body need render?
  739. var _foot; // table footer
  740. var _inlineEditBox; // inline edit box with form
  741. var _popoverCell; // inline popover cell
  742. var _popoverCellCurrent; // inline popover cell
  743. var _popoverCellAjaxXhr;
  744. var _mapEditor; // map editor node
  745. var _mapEditorWrap; // map editor wrapper node
  746. var _mapEditorDialog; // map editor jquery ui dialog node
  747. var _state = {};// state - to replace variables below (date, ...)
  748. var _data; //columns and rows
  749. var _currDpOp; // clicked datetimepicker operator
  750. var _filterTimeout; // timer for delayed filtering
  751. var _checkToggleChecked = false; // check-all toggle state
  752. var _exportFieldsSelect = {};
  753. var _tableWidth;
  754. var _fieldWidgets = {};
  755. /*
  756. initialize the plugin.
  757. */
  758. priv.init = function() {
  759. _uiNodeCont = priv.options.id; // <div id="{_htmlID}" style="..."><table class="AjaxTable...
  760. _state = {};// init state
  761. _state.page = 1;
  762. _state.specialFilters = {};
  763. { // init events
  764. jQuery(_uiNodeCont).on('TableAjax:render', priv.onRender);
  765. jQuery(window).on('resize', priv.onWindowResize)
  766. }
  767. priv.initialRender();// set up _uiNode$...
  768. priv.options.types.string = ((priv.options.types || {}).string || {});
  769. priv.options.types.number = ((priv.options.types || {}).number || {});
  770. priv.options.types.bool = ((priv.options.types || {}).bool || {});
  771. priv.options.types.date = ((priv.options.types || {}).date || {});
  772. if (priv.options.mapEditorContainer != 'dock'
  773. && priv.options.mapEditorContainer != 'window') {
  774. priv.options.mapEditorContainer = 'window';
  775. }
  776. if (priv.options.exportFields) {
  777. $.each(priv.options.exportFields, function(ind, col) {
  778. _exportFieldsSelect[col] = true;
  779. });
  780. }
  781. _state._forceFilterQuery = p5Utils__objectToQueryWithKeyPrefix(priv.options.forceFilterInit, 'f_')
  782. var fetchDataPromise = (function (props) {
  783. var props = props || {};
  784. return function (namespace, filterParams) {
  785. var urlAdd = '';
  786. DBG && console.log('DBG: fetchDataPromise', props.url)
  787. return window.fetch(props.url + urlAdd, {
  788. method: 'GET', // priv.options.urlPost ? 'POST' : 'GET',
  789. credentials: 'same-origin',// add cookies
  790. }).then(function (response) {
  791. // TODO: handle parse json error
  792. return response.json()
  793. }).then(function (responseJson) {
  794. // if (priv.options.debug || DBG) console.log('loadDataAjax:fetch:loadPage: request finished, data:', data);
  795. // // props.notify(data);
  796. if ('success' !== responseJson.type) throw responseJson.msg || "Wystąpił problem podczas pobierania danych";
  797. // state = {data: {}};
  798. // state.data.cols = data.cols || {};
  799. // state.data.rows = data.rows || [];
  800. // state.data.total = data.total || 0;
  801. // state.data.primaryKey = data.primaryKey || 'ID';
  802. // state.page = data.page || 0;
  803. // state.pageSize = data.pageSize || priv.options.pageSize;
  804. // state.filters = data.filters || {};
  805. // DBG && console.log('DBG::loadPage... - FETCH_DATA END priv.setState(state);', { state });
  806. // priv.setState(state);
  807. // _uiNode$Table.parent().parent().removeClass('AjaxTable-loading');
  808. // } else {
  809. // props.notify(data);
  810. // props.showFailFetchDataMsg();
  811. // }
  812. return responseJson;
  813. }).then(function (responseData) {
  814. DBG && console.log('DBG: fetchDataPromise responseData', { responseData })
  815. var colsOrder = []; // responseData.cols.index
  816. return {
  817. rawReponse: responseData,
  818. colsOrder: colsOrder,
  819. rows: responseData.rows,
  820. }
  821. }).catch(function (err) {
  822. props.notify({ type: 'error', msg: ''+err });
  823. props.showFailFetchDataMsg();
  824. });
  825. };
  826. })({
  827. url: priv.options.url,
  828. showFailFetchDataMsg: priv.showFailFetchDataMsg.bind(priv),
  829. notify: p5UI__notifyAjaxCallback,
  830. });
  831. var stateObjectTableData = createTableDataStateObject({}, fetchDataPromise);
  832. DBG && console.log('DBG: stateObjectTableData', stateObjectTableData);
  833. priv.options.tableDataStore = stateObjectTableData.store;
  834. priv.options.tableDataActions = stateObjectTableData.actions;
  835. var stateObjectFilter = createTableFiltersStateObject(priv.options.filterInit || {});
  836. priv.options.filterStore = stateObjectFilter.store;
  837. priv.options.filterActions = stateObjectFilter.actions;
  838. priv.filter_mapStoreToState = function (curFilterState) {
  839. // var curFilterState = store.getState()
  840. return {
  841. _filterQuery: p5Utils__mapToQueryWithKeyPrefix(curFilterState.filter, 'f_'),
  842. _specialFilterQuery: p5Utils__mapToQueryWithKeyPrefix(curFilterState.specialFilter, 'sf_'),
  843. _currSortCol: curFilterState.currSortCol,
  844. _currSortFlip: curFilterState.currSortFlip
  845. };
  846. };
  847. priv.filter_getFilterQuery = function () {
  848. return [
  849. _state._filterQuery,
  850. _state._specialFilterQuery,
  851. _state._forceFilterQuery
  852. ].filter(Boolean).join('&');
  853. };
  854. priv.filter_getFullFilterQuery = function () {
  855. return [
  856. 'currSortCol=' + ( _state._currSortCol || ''),
  857. 'currSortFlip=' + ( _state._currSortFlip ? "desc" : "asc" ),
  858. _state._filterQuery,
  859. _state._specialFilterQuery,
  860. _state._forceFilterQuery
  861. ].filter(Boolean).join('&');
  862. };
  863. _state = Object.assign(_state, priv.filter_mapStoreToState(priv.options.filterStore.getState()));
  864. DBG && console.log('TODO:INIT: ', { _state });
  865. priv.options.filterStore.subscribe(function () {
  866. var curState = priv.filter_mapStoreToState(priv.options.filterStore.getState());
  867. var needFetchData = (
  868. curState._filterQuery !== _state._filterQuery
  869. || curState._specialFilterQuery !== _state._specialFilterQuery
  870. || curState._currSortCol !== _state._currSortCol
  871. || curState._currSortFlip !== _state._currSortFlip
  872. );
  873. DBG && console.log('TODO:filtersUpdated - FETCH_DATA: ', { _state, curState });
  874. _state._filterQuery = curState._filterQuery;
  875. _state._specialFilterQuery = curState._specialFilterQuery;
  876. _state._currSortCol = curState._currSortCol;
  877. _state._currSortFlip = curState._currSortFlip;
  878. if (needFetchData) {
  879. DBG && console.log('TODO:filtersUpdated - FETCH_DATA: ', { curState });
  880. priv.loadPage(0)
  881. }
  882. })
  883. if (priv.options.checkboxes) {
  884. var stateObjectSelected = createTableSelectedStateObject(priv.options.checkboxIdContext);
  885. priv.options.selectedStore = stateObjectSelected.store;
  886. priv.options.selectedActions = stateObjectSelected.actions;
  887. if (_uiNodeSelectedInfo) { // must run after priv.initialRender(); - _uiNodeSelectedInfo must exists
  888. ReactDOM.render(
  889. h(P5UI__TableAjaxSelectedInfo, {
  890. namespace: priv.options.namespace,
  891. store: priv.options.selectedStore,
  892. actions: priv.options.selectedActions,
  893. tools: priv.options.selectedFunctions,
  894. onSelectAllMatching: function () {
  895. // TODO: priv.filter_mapStoreToState(priv.options.filterStore.getState())
  896. var filterQuery = priv.filter_getFilterQuery();
  897. // var filterQuery = '';
  898. // filterQuery += (_state._filterQuery) ? "&" + _state._filterQuery : "";
  899. // filterQuery += (_state._specialFilterQuery) ? "&" + _state._specialFilterQuery : "";
  900. // filterQuery += (_state._forceFilterQuery) ? "&" + _state._forceFilterQuery : "";
  901. priv.options.selectedStore.dispatch( priv.options.selectedActions.selectAllMatchingFilter(priv.options.namespace, filterQuery) );
  902. }
  903. }),
  904. _uiNodeSelectedInfo
  905. );
  906. }
  907. }
  908. priv.initialReactRender(RENDER_AS_REACT); // set up _reactUITableNode, require stores created
  909. // TODO: priv.options.router.init();
  910. // priv.options.router.getLinkOnclickFunction(task, args);
  911. if (typeof priv.options.router == "function") {
  912. if (location.hash) {
  913. priv.options.router()
  914. } else {
  915. priv.update(priv.options.router)
  916. }
  917. $(window).bind('hashchange', function() {
  918. priv.options.router();
  919. });
  920. } else {
  921. priv.update()
  922. }
  923. };
  924. priv.onRender = function(e) {
  925. var renderUIParts = [];
  926. if (arguments.length > 1) {
  927. for (var i=1; i<arguments.length; i++) {
  928. renderUIParts.push( arguments[i] );
  929. }
  930. }
  931. if (priv.options.debug || DBG) console.log('onRender.arguments:', arguments.length, arguments, 'e:', e);
  932. DBG && console.log('DBG::onRender: ', { renderUIParts });
  933. // console.log("priv.onRender arguments:", arguments);
  934. // console.trace();
  935. renderUIParts.forEach(function (uiPart) {
  936. switch (uiPart) {
  937. case 'head': _head = undefined; break;
  938. case 'body': _body = undefined; break;
  939. case 'foot': _foot = undefined; break;
  940. case 'foot_pagination': {
  941. priv.renderFooterInfo();
  942. priv.renderFooterPagination();
  943. priv.renderFooterPageSizes();
  944. }
  945. break;
  946. case 'footer__toolbar__info': priv.renderFooterInfo(); break;
  947. case 'footer__toolbar__pagination': priv.renderFooterPagination(); break;
  948. case 'footer__toolbar__pagesizes': priv.renderFooterPageSizes(); break;
  949. case 'foot__columnPicker': priv.renderFooterColumnPicker(); break;
  950. case 'head__specialFilters': priv.renderHeadSpecialFilters(); break;
  951. }
  952. })
  953. priv.renderTable();
  954. priv.onWindowResize();
  955. {// activate saveBtn if some columns hidden
  956. var selectedFilter = priv.modelColFilter_getSelected();
  957. if (null === selectedFilter) {
  958. priv.modelColFilter_getSaveBtn().prop("disabled", false)
  959. } else {
  960. priv.modelColFilter_getSaveBtn().prop("disabled", true)
  961. }
  962. }
  963. };
  964. priv.onWindowResize = function() {
  965. var stickyCol1Width = priv.getStickyCol1Width();
  966. var stickyCol2Width = priv.getStickyCol2Width();
  967. var stickyCol3Width = priv.getStickyCol3Width();
  968. var contW = jQuery(_uiNodeCont).parent().width();
  969. var colsW = stickyCol1Width + stickyCol2Width + stickyCol3Width;
  970. jQuery(_uiNodeCont).css({width:'' + (contW - colsW) + 'px'})//, marginLeft:'' + colsW + 'px', overflowX:'scroll', overflowY:'visible', paddingBottom:'1px'});
  971. var wh = jQuery(window).height(); // returns height of browser viewport
  972. var dh = jQuery(document).height(); // returns height of HTML document (same as pageHeight in screenshot)
  973. if (dh > wh) {
  974. jQuery(_uiNodeCont).doubleScroll()
  975. jQuery(_uiNodeCont).prev('.doubleScroll-scroll-wrapper').css({float: 'right', display:'block'})
  976. } else {
  977. jQuery(_uiNodeCont).prev('.doubleScroll-scroll-wrapper').css({display:'none'})
  978. }
  979. }
  980. priv.uiFixStickyCols = function () {
  981. var stickyCol1Width = priv.getStickyCol1Width();
  982. var stickyCol2Width = priv.getStickyCol2Width();
  983. var stickyCol3Width = priv.getStickyCol3Width();
  984. if (undefined === _tableWidth) {
  985. _tableWidth = true;
  986. var contW = jQuery(_uiNodeCont).width();
  987. var th1 = _uiNode$Table.find('.stickyCol1:first');
  988. var th2 = th1.next();
  989. var th1W = th1.innerWidth();
  990. var th2W = 50 + 2 * 5;//th2.innerWidth();
  991. // var colsW = stickyCol1Width + stickyCol2Width + stickyCol3Width;
  992. var colsW = priv.getStickyColsSumWidth();
  993. jQuery(_uiNodeCont).css({
  994. width: '' + (contW - colsW) + 'px',
  995. marginLeft: '' + colsW + 'px',
  996. minHeight: '360px',
  997. overflowX: 'scroll',
  998. overflowY: 'visible',
  999. paddingBottom: '1px',
  1000. clear: 'both',
  1001. });
  1002. }
  1003. _uiNode$Table.find('.stickyCol1').css({
  1004. position: 'absolute',
  1005. left: '0',
  1006. top: 'auto',
  1007. width: '' + (stickyCol1Width) + 'px',
  1008. });
  1009. //_uiNode$Table.find('.filter').find('.stickyCol1').css({height:'34px'});
  1010. var sortStickyColHeight = _uiNode$Table.find('.sort').find('th:last').outerHeight();
  1011. _uiNode$Table.find('.sort').find('.stickyCol').css({height: sortStickyColHeight + 'px'});
  1012. var filterStickyColHeight = _uiNode$Table.find('.filter').find('th:last').outerHeight() + 1;
  1013. _uiNode$Table.find('.filter').find('.stickyCol').css({height: filterStickyColHeight + 'px'});
  1014. if (priv.options.checkboxes) _uiNode$Table.find('.stickyCol2').css({
  1015. position: 'absolute',
  1016. left: '' + (stickyCol1Width) + 'px',
  1017. top: 'auto',
  1018. width: '' + (stickyCol2Width) + 'px',
  1019. borderRight: '1px solid silver',
  1020. overflow: 'hidden'
  1021. });
  1022. _uiNode$Table.find('.stickyCol3').css({
  1023. position: 'absolute',
  1024. left: '' + (stickyCol1Width + stickyCol2Width) + 'px',
  1025. top: 'auto',
  1026. width: '' + (stickyCol3Width) + 'px',
  1027. borderRight: '1px solid silver',
  1028. overflow: 'hidden'
  1029. });
  1030. _uiNode$Table.find('tbody').find('.stickyCol').css({
  1031. height: '' + (29 + 1) + 'px',
  1032. });
  1033. };
  1034. priv.getStickyCol1Width = function () { return (12 + 3) * 4 + 2 * 5 + 1; }
  1035. priv.getStickyCol2Width = function () { return (priv.options.checkboxes) ? 20 + 2 * 5 + 1 : 0; }
  1036. priv.getStickyCol3Width = function () { return 50 + 2 * 5 + 1; }
  1037. priv.getStickyColsSumWidth = function () { return priv.getStickyCol1Width() + priv.getStickyCol2Width() + priv.getStickyCol3Width(); }
  1038. priv.initialReactRender = function (isVisible) { // TODO: render table as React node
  1039. if (!isVisible) return; // TODO: double request fetchData BUG `_task=loadDataAjax` - second request send without filter/sort
  1040. _reactUITableNode = document.createElement('div')
  1041. if (!isVisible) _reactUITableNode.style.display = 'none';
  1042. _reactUITableNode.setAttribute('class', "TableAjax-reactUITableNode");
  1043. _uiNodeCont.parentNode.appendChild(_reactUITableNode);
  1044. ReactDOM.render(
  1045. h(p5UI__TableAjaxWidget, {
  1046. namespace: priv.options.namespace,
  1047. dataStore: priv.options.tableDataStore,
  1048. dataActions: priv.options.tableDataActions,
  1049. filterStore: priv.options.filterStore,
  1050. filterActions: priv.options.filterActions,
  1051. selectedStore: priv.options.selectedStore,
  1052. selectedActions: priv.options.selectedActions,
  1053. }),
  1054. _reactUITableNode
  1055. );
  1056. };
  1057. priv.initialRender = function() {
  1058. _uiNode$Table = $('<table class="AjaxTable table table-striped table-hover table-bordered table-condensed"></table>').appendTo(_uiNodeCont);
  1059. _head = $('<thead></thead>').prependTo(_uiNode$Table);
  1060. _headSort = $('<tr class="sort tblAjax__head__sort"></tr>').prependTo(_head);
  1061. _headFilter = $('<tr class="filter tblAjax__head__filter"></tr>').appendTo(_head);
  1062. _bodyNode = $('<tbody></tbody>').insertAfter(_head);
  1063. $('<tfoot></tfoot>').insertAfter(_bodyNode);
  1064. _foot = $('<div class="foot tblAjax__footer" style="margin:0; padding:12px; border-top:1px solid #ddd; border-bottom:1px solid #ddd"></div>').insertAfter(_uiNodeCont);
  1065. var footToolbar = $('<div class="btn-toolbar tblAjax__footer__toolbar" style="margin:0"></div>').appendTo(_foot);
  1066. _uiNodeFooterInfo = document.createElement('div') // .tblAjax__head__specialFilter
  1067. _uiNodeFooterInfo.setAttribute('class', "tblAjax__footer__toolbar__info foot-info");
  1068. _uiNodeFooterInfo.style.float = "left";
  1069. _uiNodeFooterInfo.style.padding = "0 20px 0 0";
  1070. $(_uiNodeFooterInfo).appendTo(footToolbar);
  1071. $('<span class="tblAjax__footer__toolbar__pagination"></span>').appendTo(footToolbar);
  1072. $('<span class="tblAjax__footer__toolbar__pagesizes"></span>').appendTo(footToolbar);
  1073. $('<span class="tblAjax__footer__toolbar__columnPicker"></span>').appendTo(footToolbar);
  1074. $('<span class="tblAjax__footer__toolbar__functions"></span>').appendTo(footToolbar);
  1075. $('<span class="tblAjax__footer__toolbar__export"></span>').appendTo(footToolbar);
  1076. _mapEditorWrap = $('<div class="mapEditor" style="display:none"></div>').insertAfter(_foot);
  1077. _mapEditor = $('<div class="mapEditor-map"></div>').appendTo(_mapEditorWrap);
  1078. _popoverCell = $('<div class="popoverCell" style="display:none"></div>').insertAfter(_foot);
  1079. $('<div class="tblAjax__inlineEditBox"></div>').insertAfter(_foot);
  1080. _uiNodeSelectedInfo = document.createElement('div')
  1081. _uiNodeSpecialFilters = document.createElement('div') // .tblAjax__head__specialFilter
  1082. var topWrap = document.createElement('div')
  1083. var topLeftWrap = document.createElement('div')
  1084. var topRightWrap = document.createElement('div')
  1085. topWrap.appendChild(topLeftWrap)
  1086. topWrap.appendChild(topRightWrap)
  1087. topWrap.style.padding = '12px 0'
  1088. topWrap.style.borderTop = '1px solid #ddd'
  1089. topLeftWrap.style.width = '' + priv.getStickyColsSumWidth() + 'px'
  1090. topLeftWrap.style.float = 'left'
  1091. topLeftWrap.style.fontSize = '12px'
  1092. topLeftWrap.style.lineHeight = '22px'
  1093. topRightWrap.style.float = 'left'
  1094. topLeftWrap.appendChild(_uiNodeSelectedInfo)
  1095. topRightWrap.appendChild(_uiNodeSpecialFilters)
  1096. _uiNodeCont.parentNode.insertBefore(topWrap, _uiNodeCont)
  1097. var afterTopWrap = document.createElement('div')
  1098. afterTopWrap.style.paddingTop = '12px'
  1099. afterTopWrap.style.borderBottom = '1px solid #ddd'
  1100. afterTopWrap.style.clear = 'both'
  1101. _uiNodeCont.parentNode.insertBefore(afterTopWrap, _uiNodeCont)
  1102. priv.renderInlineEditBox();// .tblAjax__inlineEditBox
  1103. _foot = undefined;
  1104. _head = undefined;
  1105. _body = undefined;
  1106. _headSort = undefined;
  1107. _headFilter = undefined;// TODO: refactor
  1108. };
  1109. priv.renderTable = function() {
  1110. if (!_state.colsSorted) return;
  1111. DBG && console.warn('DBG:renderTable: ', { _head, _headSort, _headFilter, _headSpecialFilter });
  1112. if (!_head) {
  1113. _headSort = undefined;
  1114. _headFilter = undefined;
  1115. _headSpecialFilter = undefined;
  1116. _head = _uiNode$Table.find('thead');
  1117. }
  1118. if (!_headSort) {
  1119. priv.renderTableTheadSort();
  1120. _headSort = true;
  1121. }
  1122. if (!_headFilter && priv.options.filter) {
  1123. priv.renderTableTheadFilter();
  1124. _headFilter = true;
  1125. }
  1126. if (!_headSpecialFilter && priv.options.specialFilterFunctions) {
  1127. priv.renderHeadSpecialFilters();
  1128. _headSpecialFilter = true;
  1129. }
  1130. if (!_body) {
  1131. DBG && console.log('DBG:renderTable !_body', { _bodyNode })
  1132. // _uiNode$Table.find('tbody').remove();
  1133. // _bodyNode = $('<tbody></tbody>').insertAfter(_head);
  1134. // _uiNode$Table.find('tbody > tr').remove();
  1135. _bodyNode.find('tr').remove();
  1136. var rowsAdded = Math.min(_data.rows.length, priv.options.pageSize);
  1137. _data.rows.slice(0, rowsAdded).forEach(function (props) {
  1138. var rowNode = priv.renderRow(props);
  1139. if (rowNode) rowNode.appendTo(_bodyNode);
  1140. })
  1141. for (var i = rowsAdded; i < priv.options.pageSize; i++) {
  1142. priv.renderRowEmptyNode().appendTo(_bodyNode);
  1143. }
  1144. }
  1145. if (!_foot) {
  1146. priv.renderTableTfoot();
  1147. priv.renderFooter();
  1148. }
  1149. _foot = $(_uiNodeCont).next('.foot');
  1150. priv.uiFixStickyCols();
  1151. if (_data.total == 0 && priv.options.hidePagerOnEmpty) {
  1152. $('.btn-toolbar', _foot).remove();
  1153. }
  1154. if (priv.options.debug || DBG) console.log('table created');
  1155. if (typeof priv.options.tableCreated == 'function') {
  1156. priv.options.tableCreated.call(_uiNode$Table.get(0), {table: _uiNode$Table.get(0)});
  1157. }
  1158. };
  1159. // TODO: priv.renderFieldWidget_InlineEdit = function(fldName, value) {}
  1160. // TODO: priv.renderFieldWidget_FormField = function(fldName, value) {}
  1161. // @usage: priv.renderFieldWidget_TableCell(fldName, val, rowPK, row)
  1162. priv.renderFieldWidget_TableCell = function(fldName, value, rowPK, row) {
  1163. var renderFieldAsTableCell = priv.getFieldWidget_TableCell(fldName);
  1164. if (!renderFieldAsTableCell) return null;
  1165. return renderFieldAsTableCell(value, rowPK, row);
  1166. };
  1167. priv.registerFieldWidget = function(type, fldName, fieldProps) {
  1168. var fieldWidget = null;
  1169. switch (type) {
  1170. case "date":// @return Element - TODO: not used yet
  1171. fieldWidget = (function(fldName, fieldProps) {
  1172. var _fieldName = fldName,
  1173. _fieldProps = fieldProps;
  1174. // console.log('FieldWidget: generate function to render field('+_fieldName+') ', fieldProps);
  1175. return function(val, fieldPK, row) {
  1176. // console.log('FieldWidget: pk('+fieldPK+') run function to render field('+_fieldName+') with value('+val+') ', fieldProps);
  1177. return val;
  1178. }
  1179. }(fldName, fieldProps));
  1180. break;
  1181. case "bool":// @return Element - TODO: not used yet
  1182. fieldWidget = (function(fldName, fieldProps) {
  1183. var _fieldName = fldName,
  1184. _fieldProps = fieldProps;
  1185. // console.log('FieldWidget: generate function to render field('+_fieldName+') ', fieldProps);
  1186. return function(val, fieldPK, row) {
  1187. // console.log('FieldWidget: pk('+fieldPK+') run function to render field('+_fieldName+') with value('+val+') ', fieldProps);
  1188. fldNode = document.createElement('input');
  1189. fldNode.setAttribute('type', 'checkbox');
  1190. if (val) fldNode.setAttribute('checked', 'checked');
  1191. fldNode.setAttribute('disabled', 'disabled');
  1192. fldNode.appendChild(document.createTextNode(val));
  1193. return fldNode;
  1194. }
  1195. }(fldName, fieldProps));
  1196. break;
  1197. case "number":// @return String - TODO: not used yet
  1198. fieldWidget = (function(fldName, fieldProps) {
  1199. var _fieldName = fldName,
  1200. _fieldProps = fieldProps,
  1201. _fractionDigits = _.get(_fieldProps, 'fractionDigits', 2);
  1202. // console.log('FieldWidget: generate function to render field('+_fieldName+') _fractionDigits('+_fractionDigits+')', fieldProps);
  1203. return function(val, fieldPK, row) {
  1204. // console.log('FieldWidget: pk('+fieldPK+') run function to render field('+_fieldName+') with value('+val+') ', fieldProps);
  1205. if ('' === val) return ''; // is nullable
  1206. if ('*****' === val) return val;
  1207. // enumeration
  1208. // fractionDigits
  1209. // maxExclusive
  1210. // maxInclusive
  1211. // minExclusive
  1212. // minInclusive
  1213. // pattern
  1214. // totalDigits
  1215. // whiteSpace
  1216. val = Number(val);
  1217. return ((val || 0) % 1 === 0)? val : val.toFixed(_fractionDigits);
  1218. }
  1219. }(fldName, fieldProps));
  1220. break;
  1221. case "string":// @return String
  1222. fieldWidget = (function(fldName, fieldProps) {
  1223. var _fieldName = fldName,
  1224. _fieldProps = fieldProps,
  1225. _format = _.get(_fieldProps, 'format', '{0}');
  1226. // console.log('FieldWidget: generate function to render field('+_fieldName+') ', fieldProps);
  1227. return function(val, fieldPK, row) {
  1228. // console.log('FieldWidget: pk('+fieldPK+') run function to render field('+_fieldName+') with value('+val+') ', fieldProps);
  1229. return p5Utils__format(_format, [val]);
  1230. }
  1231. }(fldName, fieldProps));
  1232. break;
  1233. case "p5:price":// @return String
  1234. fieldWidget = (function(fldName, fieldProps) {
  1235. var _fieldName = fldName,
  1236. _fieldProps = fieldProps,
  1237. _format = _.get(_fieldProps, 'format', '<span style="text-align:right">{0}</span>');
  1238. // console.log('FieldWidget: generate function to render field('+_fieldName+') ', fieldProps);
  1239. return function(val, fieldPK, row) {
  1240. // console.log('FieldWidget: pk('+fieldPK+') run function to render field('+_fieldName+') with value('+val+') ', fieldProps);
  1241. return p5Utils__format(_format, [val]);
  1242. }
  1243. }(fldName, fieldProps));
  1244. break;
  1245. case "p5:string":// @return String
  1246. fieldWidget = (function(fldName, fieldProps) {
  1247. var _fieldName = fldName;
  1248. var _fieldProps = fieldProps;
  1249. var _formatDefault = _.get(_fieldProps, 'format', null);
  1250. var _formatByValue = _.get(_fieldProps, 'formatByValue', null);
  1251. var _formatEmpty = _.get(_fieldProps, 'formatEmpty', null);
  1252. var _aliasMap = _.get(_fieldProps, 'aliasMap', null);
  1253. return function(val, fieldPK, row) {
  1254. var outValue = '';
  1255. if (_formatByValue && val in _formatByValue) {
  1256. outValue = p5Utils__format(_formatByValue[val], [val])
  1257. }
  1258. else if (val && _formatDefault) {
  1259. outValue = p5Utils__format(_formatDefault, [val])
  1260. }
  1261. else if (!val && _formatEmpty) {
  1262. outValue = p5Utils__format(_formatEmpty, [])
  1263. }
  1264. // console.log('p5:string value', val, '_aliasMap', _aliasMap)
  1265. if (_aliasMap) {
  1266. Object.keys(_aliasMap).map(function (mapKey) {
  1267. var mapField = _aliasMap[mapKey]
  1268. if (undefined !== row[mapField]) {
  1269. outValue = outValue.replace(new RegExp('\{' + mapKey + '\}', 'g'), row[mapField]);
  1270. }
  1271. })
  1272. }
  1273. return outValue;
  1274. }
  1275. }(fldName, fieldProps));
  1276. break;
  1277. case "p5:www_link":// @return Element
  1278. fieldWidget = (function(fldName, fieldProps) {
  1279. var _fieldName = fldName;
  1280. var _fieldProps = fieldProps;
  1281. // console.log('FieldWidget: generate function to render field('+_fieldName+') ', fieldProps);
  1282. return function(val, fieldPK, row) {
  1283. // console.log('FieldWidget: pk('+fieldPK+') run function to render field('+_fieldName+') with value('+val+') ', fieldProps);
  1284. var link = '',
  1285. a = null,
  1286. dbg = false;
  1287. if (!val.length) return '';
  1288. if ('index.php' == val.substr(0, 9) || 'procesy5.php' == val.substr(0, 12)) {
  1289. link = window.location.protocol + '//' + window.location.hostname
  1290. link += window.location.pathname.split('/').slice(0, -1).join('/')
  1291. link += '/' + val
  1292. } else {
  1293. if ('http' == val.substr(0, 4)) link = val
  1294. //else if ('ftp' == val.substr(0, 3))
  1295. else link = 'http://' + val
  1296. }
  1297. var linkErrors = validate({www_link: link}, {www_link: {url: true}});
  1298. if (linkErrors) {
  1299. // if(dbg)console.log('linkErrors for (' + link +')', linkErrors);
  1300. return val;
  1301. }
  1302. fldNode = document.createElement('a');
  1303. fldNode.setAttribute('href', link);
  1304. fldNode.setAttribute('target', '_blank');
  1305. fldNode.appendChild(document.createTextNode(val));
  1306. return fldNode;
  1307. }
  1308. }(fldName, fieldProps));
  1309. break;
  1310. case "p5:link":// @return Element
  1311. fieldWidget = (function(fldName, fieldProps) {
  1312. var _fieldName = fldName;
  1313. var _fieldProps = fieldProps;
  1314. DBG && console.log('FieldWidget: generate function to render field('+_fieldName+') ', fieldProps);
  1315. return function(val, fieldPK, row) {
  1316. DBG && console.log('FieldWidget: pk('+fieldPK+') run function to render field('+_fieldName+') with value('+val+') ', fieldProps);
  1317. // fieldProps._appInfo.simpleLink: {
  1318. // @href: "index.php?MENU_INIT=POKAZ_OFERTY_AKTUALNE_FUNC&task=activate_deal&id_deal={ID}"
  1319. // @label: "Aktywuj umowę {ID}"
  1320. // @target: "_blank"
  1321. if (!_fieldProps._appInfo.simpleLink) return 'BUG: missing _appInfo.simpleLink!';
  1322. if (!_fieldProps._appInfo.simpleLink['@label']) return 'BUG: missing _appInfo.simpleLink[@label]!';
  1323. var label = p5Utils__multiReplaceValues(_fieldProps._appInfo.simpleLink['@label'], row);
  1324. var relativeLink = p5Utils__multiReplaceValues(_fieldProps._appInfo.simpleLink['@href'], row);
  1325. if ('index.php' == relativeLink.substr(0, 9) || 'procesy5.php' == relativeLink.substr(0, 12)) {
  1326. link = window.location.protocol + '//' + window.location.hostname
  1327. link += window.location.pathname.split('/').slice(0, -1).join('/')
  1328. link += '/' + relativeLink
  1329. } else if ('http' == relativeLink.substr(0, 4)) {
  1330. link = relativeLink
  1331. // else if ('ftp' == val.substr(0, 3))
  1332. } else {
  1333. link = 'http://' + relativeLink
  1334. }
  1335. var linkErrors = validate({www_link: link}, {www_link: {url: true}});
  1336. if (linkErrors) {
  1337. DBG && console.log('DBG:linkErrors (' + _fieldName + ': ' + link + ')', linkErrors);
  1338. return label;
  1339. }
  1340. fldNode = document.createElement('a');
  1341. fldNode.setAttribute('href', link);
  1342. if (_fieldProps._appInfo.simpleLink['@target']) fldNode.setAttribute('target', _fieldProps._appInfo.simpleLink['@target']);
  1343. fldNode.appendChild(document.createTextNode(label));
  1344. return fldNode;
  1345. }
  1346. }(fldName, fieldProps));
  1347. break;
  1348. case "special":
  1349. fieldWidget = (function(fldName, fieldProps) {
  1350. var _fieldName = fldName;
  1351. var _fieldProps = fieldProps;
  1352. var _format = _.get(_fieldProps, 'format', '{0}');
  1353. var _aliasMap = _.get(_fieldProps, 'aliasMap', null);
  1354. // console.log('FieldWidget: generate function to render field('+_fieldName+') ', fieldProps);
  1355. return function(val, fieldPK, row) {
  1356. // console.log('FieldWidget: pk('+fieldPK+') run function to render field('+_fieldName+') with value('+val+') ', fieldProps, 'row', row);
  1357. var format = _format;
  1358. if (_aliasMap) {
  1359. Object.keys(_aliasMap).map(function (mapKey) {
  1360. var mapField = _aliasMap[mapKey]
  1361. if (undefined !== row[mapField]) {
  1362. format = format.replace(new RegExp('\{' + mapKey + '\}', 'g'), row[mapField]);
  1363. }
  1364. // console.log('FieldWidget: pk('+fieldPK+') run function to render field('+_fieldName+') with value('+val+') _aliasMap:', _aliasMap, 'row['+mapField+']', row[mapField], 'converted val:', val);
  1365. })
  1366. }
  1367. return p5Utils__format(format, [val]);
  1368. }
  1369. }(fldName, fieldProps));
  1370. break;
  1371. case "simpleLink":
  1372. fieldWidget = (function(fldName, fieldProps) {
  1373. var _fieldName = fldName,
  1374. _fieldProps = fieldProps,
  1375. _format = _.get(_fieldProps, 'format', '{0}');
  1376. // console.log('FieldWidget: generate function to render field('+_fieldName+') ', fieldProps);
  1377. return function(val, fieldPK, row) {
  1378. // console.log('FieldWidget: pk('+fieldPK+') run function to render field('+_fieldName+') with value('+val+') ', fieldProps);
  1379. var valLink = String(val);
  1380. if (undefined !== _fieldProps._tsRetId
  1381. && (0 === _fieldProps._tsRetId || '0' === _fieldProps._tsRetId || null === _fieldProps._tsRetId)
  1382. && undefined !== _fieldProps._tsSimpleLink) {
  1383. valLink = _fieldProps._tsSimpleLink.format;
  1384. $.each(_fieldProps._tsSimpleLink.aliasMap, function(i, v) {
  1385. // console.log('simpleLink aliasMap fldName:', fldName, 'i:', i, 'v:', v, 'row['+v+']', row[v], 'val', val, 'typeof val', typeof val);
  1386. if (undefined !== row[v]) {
  1387. var _itemValue = row[v];
  1388. if (fldName == 'LINK_PROBLEMS' && row[v]) _itemValue = _itemValue.replace(/"/g, '%22').replace(/&/g, '%26');
  1389. valLink = valLink.replace(new RegExp('\{' + i + '\}', 'g'), _itemValue);
  1390. }
  1391. });
  1392. }
  1393. return p5Utils__format(_format, [valLink]);
  1394. }
  1395. }(fldName, fieldProps));
  1396. break;
  1397. case "gml:PolygonPropertyType":
  1398. case "gml:LineStringPropertyType":
  1399. case "gml:PointPropertyType":
  1400. case "p5Type:polygon":
  1401. case "p5Type:lineString":
  1402. case "p5Type:point":
  1403. case "geom":
  1404. fieldWidget = (function(fldName, fieldProps) {
  1405. var _fieldName = fldName,
  1406. _fieldProps = fieldProps,
  1407. _format = _.get(_fieldProps, 'format', '{0}');
  1408. // console.log('FieldWidget: generate function to render field('+_fieldName+') ', fieldProps);
  1409. return function(val, fieldPK, row) {
  1410. // console.log('FieldWidget: run function to render field('+_fieldName+') with value('+val+') ', fieldProps);
  1411. // console.log('FieldWidget: test priv', priv);
  1412. var node = jQuery('<span></span>');
  1413. node.TableAjaxGeomField({
  1414. recordID: fieldPK,
  1415. fieldValue: val,
  1416. hasValueClassName: 'cell-mapfld-hasValue',
  1417. linkClassNamePrefix: 'cell-mapfld',
  1418. linkSelectClassName: 'select',
  1419. linkSelectAddClassNames: 'glyphicon glyphicon-map-marker',
  1420. getCsvUrl: priv.options.getCsvTheGeomAjaxUrl,
  1421. linkGetCsvAddClassNames: 'glyphicon glyphicon-download',
  1422. linkRemoveClassName: 'remove',
  1423. linkRemoveAddClassNames: 'glyphicon glyphicon-remove',
  1424. onSelect: function(recordID, geomShape) {
  1425. if (priv.options.debug || DBG) console.log('recordID:', recordID, 'geomShape:', geomShape);
  1426. priv.mapEditorShow();
  1427. _mapEditor.TableAjaxMapSelectRecord(recordID, geomShape);
  1428. },
  1429. onRemove: function(geomField, recordID, geomShape) {
  1430. if (confirm('Czy usunąć obiekt z mapy dla rekordu ' + recordID + '?')) {
  1431. if (!recordID) return;
  1432. var selectedRecordId = recordID;
  1433. superagent
  1434. .post(priv.options.removeTheGeomAjaxUrl)
  1435. .type('json') // header ĺapplication/x-www-form-urlencoded' requires type('form');
  1436. .send({
  1437. ID: recordID,
  1438. namespace: priv.options.namespace
  1439. })
  1440. .set('Accept', 'application/json')
  1441. .end(function(err, res) {
  1442. if(priv.options.debug)console.log('DBG: res:', res, 'res.body:', res.body);
  1443. var payload;
  1444. if (err || !res.ok || 'application/json' !== res.type) {
  1445. payload = {type: 'warning', msg: res.body.msg || 'Wystąpiły błędy', body: res.body};
  1446. } else {
  1447. payload = {type: 'success', msg: res.body.msg || '', body: res.body};
  1448. }
  1449. p5UI__notifyAjaxCallback(payload);
  1450. var data = res.body;
  1451. if (data && data.record && data.record.the_geom) {
  1452. if (priv.options.debug || DBG) console.log('data.record.the_geom:2:', data.record.the_geom);
  1453. geomField.setValue(data.record.the_geom);
  1454. }
  1455. else if (data && data.record) {
  1456. if (priv.options.debug || DBG) console.log('data.record.the_geom:2:', data.record.the_geom);
  1457. geomField.setValue(data.record.the_geom);
  1458. }
  1459. _mapEditor.TableAjaxMapRefresh();
  1460. });
  1461. }
  1462. }
  1463. });
  1464. return node;
  1465. }
  1466. }(fldName, fieldProps));
  1467. break;
  1468. case "ref":
  1469. fieldWidget = (function(fldName, fieldProps) {
  1470. var _fieldName = fldName,
  1471. _fieldProps = fieldProps;
  1472. // console.log('FieldWidget: generate function to render field('+_fieldName+') fieldProps: ', fieldProps);
  1473. return function(val, fieldPK, row) {
  1474. // console.log('FieldWidget: pk('+fieldPK+') run function to render field('+_fieldName+') with value: ', val, ', fieldProps: ', fieldProps);
  1475. // if (val.length > 5) return '('+val.length+')' + printFirst5 + '...' => open more info
  1476. return _.map(val, function(v) {
  1477. if (!v || !v.xlink) return '';
  1478. var idRemote = v.xlink.split('.').pop()
  1479. var nsRemote = v.xlink.split(':').pop().split('.').shift()
  1480. var seLink = URI_BASE + 'index.php?_route=ViewTableAjax&namespace=' + fieldProps.xsdRefNsPrefix.replace(/__x3A__/g, '/') + '/' + nsRemote + '#EDIT/' + idRemote;
  1481. var wfsLink = fieldProps.xsdRefUri + '#' + fieldProps.xsdRefType + '.' + idRemote;
  1482. return '<a class="btn btn-xs btn-default" href="' + seLink + '" title="' + wfsLink + '">' + idRemote + '</a>';
  1483. }).join(' ');
  1484. }
  1485. }(fldName, fieldProps));
  1486. break;
  1487. }
  1488. _fieldWidgets[fldName] = fieldWidget;
  1489. };
  1490. priv.getFieldWidget_TableCell = function(fieldName) {
  1491. var props = _data.cols[fieldName],
  1492. type = null,
  1493. renderFieldAsTableCell = null;
  1494. if (!props) return null;
  1495. type = _.get(props, 'type');
  1496. if (!type) type = 'string';// TODO: throw Exception? / default string
  1497. renderFieldAsTableCell = _.get(_fieldWidgets, fieldName);
  1498. if (renderFieldAsTableCell) return renderFieldAsTableCell;
  1499. priv.registerFieldWidget(type, fieldName, props);
  1500. renderFieldAsTableCell = _.get(_fieldWidgets, fieldName);
  1501. if (!renderFieldAsTableCell) throw "Field type '" + type + "' not implemented";
  1502. return renderFieldAsTableCell;
  1503. };
  1504. priv.renderRow = function(props) {
  1505. var rowNode = $('<tr></tr>');
  1506. var rowPK = (_state.primaryKey in props) ? props[_state.primaryKey] : null;
  1507. var cellNode;
  1508. var columnName, columnProps, val, cellCnt, format, showTooltip, fldWidgetNode;
  1509. var dbg = (priv.options.debug || DBG);
  1510. // ondrop="drop_handler(event);" ondragover="dragover_handler(event);" ondragend="dragend_handler(event);"
  1511. rowNode.attr('ondrop', "p5TA_onDrop(event, '"+rowPK+"', '"+priv.options.namespace+"')")
  1512. rowNode.attr('ondragover', "p5TA_onDragOver(event, this, '"+rowPK+"', '"+priv.options.namespace+"')")
  1513. rowNode.attr('ondragend', "p5TA_onDragEnd(event, this, '"+rowPK+"', '"+priv.options.namespace+"')")
  1514. if (priv.options.rowFunctions || priv.options.filtersClean) {
  1515. cellNode = priv.renderCellRowFunctions(priv.options.rowFunctions, rowPK, props);
  1516. cellNode.addClass('text-right stickyCol stickyCol1');
  1517. cellNode.appendTo(rowNode);
  1518. }
  1519. //create checkbox
  1520. if (_state.primaryKey && priv.options.checkboxes) { // row checkbox cell
  1521. var checkable = props['checkable'] === false ? 'disabled' : '';
  1522. cellNode = $('<td class="stickyCol stickyCol2" style="padding:3px 5px"></td>').appendTo(rowNode);
  1523. ReactDOM.render(
  1524. h(P5UI__TableAjaxRowCheckbox, {
  1525. namespace: priv.options.namespace,
  1526. primaryKey: rowPK,
  1527. store: priv.options.selectedStore,
  1528. actions: priv.options.selectedActions
  1529. }),
  1530. cellNode.get(0)
  1531. );
  1532. }
  1533. if (_state.primaryKey) rowNode.data('unique', rowPK);
  1534. //create cells
  1535. for (var i = 0; i < _state.colsSorted.length; i++) {
  1536. columnName = _state.colsSorted[i];
  1537. columnProps = _data.cols[columnName];
  1538. val = '';
  1539. if (!columnProps) continue;
  1540. if (columnProps.hidden) continue;// TODO: "unique" is hidden
  1541. showTooltip = true;
  1542. val = props[columnName];
  1543. cellNode = $('<td></td>').appendTo(rowNode);
  1544. if (i === 1) cellNode.addClass('stickyCol stickyCol3');// primaryKey(ID)
  1545. if (i !== 1) cellNode.on('dblclick', {id:rowPK, col:columnName}, priv.rowDblClicked);
  1546. cellCnt = (i === 1)? '<div></div>' : '<span></span>';
  1547. cellCnt = $(cellCnt).appendTo(cellNode);// fix dblclick for copy
  1548. cellNode.data('column', columnName);
  1549. if (val === undefined) continue;
  1550. format = _.get(columnProps, 'format', '{0}');
  1551. // test use field widgets
  1552. fldWidgetNode = priv.renderFieldWidget_TableCell(columnName, val, rowPK, props);
  1553. if (fldWidgetNode || fldWidgetNode === 0) {
  1554. cellCnt.empty();
  1555. cellCnt.append(fldWidgetNode);
  1556. } else if (fldWidgetNode === '') {
  1557. cellCnt.empty();
  1558. } else {
  1559. console.log('TODO: !FieldWidget for row.pk('+rowPK+') col('+columnName+') typeof fldWidgetNode(' + (typeof fldWidgetNode) + ') columnProps', columnProps, 'fldWidgetNode', fldWidgetNode, 'value', props[columnName]);
  1560. }// test fld widgets
  1561. if (columnProps._tsRetId) {
  1562. showTooltip = false;
  1563. if (columnProps._tsRetId > 0) {
  1564. cellCnt.on('click', {id:rowPK, col:columnName, friendly:columnProps.friendly, value:p5Utils__format(format, [val])}, priv.popoverCellTypeSpecial);
  1565. }
  1566. }
  1567. if ('ref' === columnProps.type) showTooltip = false;
  1568. if ('ref' === columnProps.type) cellNode.css('padding', "3px")
  1569. if ('ref' === columnProps.type && (priv.options.debug || DBG)) console.log('renderRow rowPK('+rowPK+') columnProps', columnProps)
  1570. // if ('ref' === columnProps.type) cellNode.html('<a href="index.php?_route=ViewTableAjax' +
  1571. // '&namespace=' + columnProps.xsdRefNsPrefix.replace('__x3A__', '/') + '/' + columnProps.xsdRefType +
  1572. // '&backRefNS=' + priv.options.namespace +
  1573. // '&backRefPK=' + rowPK +
  1574. // '&backRefField=' + columnProps.column +
  1575. // '">przeglądaj</a>')
  1576. if ('ref' === columnProps.type) {
  1577. cellNode.html('<a onClick="return p5UI__tableAjaxOpenRefCell(' +
  1578. '\'' + columnProps.xsdRefNsPrefix.replace('__x3A__', '/') + '/' + columnProps.xsdRefType + '\', ' + // namespace
  1579. '\'' + priv.options.namespace + '\', ' + // backRefNS
  1580. '\'' + rowPK + '\', ' + // backRefPK
  1581. '\'' + columnProps.column + '\')' + // backRefField
  1582. '" ' +
  1583. 'href="index.php?_route=ViewTableAjax' +
  1584. '&namespace=' + columnProps.xsdRefNsPrefix.replace('__x3A__', '/') + '/' + columnProps.xsdRefType +
  1585. '&backRefNS=' + priv.options.namespace +
  1586. '&backRefPK=' + rowPK +
  1587. '&backRefField=' + columnProps.column +
  1588. '">przeglądaj</a>')
  1589. }
  1590. if (columnProps.xsdType && 'xsd:base64Binary' === columnProps.xsdType) {
  1591. cellCnt.empty();
  1592. if (val) {
  1593. cellCnt.append('<a target="_blank" href="wfs-data.php?SERVICE=WFS&VERSION=1.0.0&REQUEST=GetBlob&namespace='+priv.options.namespace+'&primaryKey='+rowPK+'&fieldName='+columnName+'">'+"otwórz"+'</a>');
  1594. } else {
  1595. cellCnt.append('<span style="color:silver" title="Brak danych">N/S;</span>');
  1596. }
  1597. }
  1598. if (i > 1 && priv.options.longDesc) {// TODO: use better check for columns: functions and pk
  1599. cellNode.addClass('tbl-short-txt');
  1600. if (showTooltip) {
  1601. cellCnt.tooltip({title: cellCnt.text(), placement: 'left'});
  1602. }
  1603. }
  1604. }
  1605. return rowNode;
  1606. };
  1607. priv.renderCellRowFunctions = function(rowFunctions, rowPK, rowProps) {
  1608. var cellNode = $('<td></td>');
  1609. var keys = Object.keys(rowFunctions);
  1610. var total = keys.length;
  1611. var moreFuncBtnNode;
  1612. var moreFunctions = [];
  1613. var idx;
  1614. if (priv.options.debug || DBG) console.log('TableAjax::renderCellRowFunctions: rowFunctions', rowFunctions);
  1615. idx = keys.indexOf('hist');
  1616. if (idx !== -1) {
  1617. histFunc = keys.splice(idx, 1);
  1618. keys.push('hist');
  1619. }
  1620. moreFunctions = keys.splice(3);
  1621. keys.forEach(function(key) {
  1622. // TODO: support for ui-function in rowFunctions
  1623. // var funObj = rowFunctions[key];
  1624. // var funcNode = p5UI_TableAjax_generateFunctionNode(funObj, rowPK, {ico: true, label: false});
  1625. // DBG && console.log('TableAjax::renderCellRowFunctions: rowFunction[' + key + ']', { funObj: funObj, uiFunc: funObj['ui-function'], uiFuncExists: global[funObj['ui-function']] });
  1626. // if (funObj['ui-function'] && global[funObj['ui-function']]) {
  1627. // funcNode.on('click', function (event) { event.preventDefault(); global[funObj['ui-function']](rowPK); });
  1628. // }
  1629. var funObj = rowFunctions[key];
  1630. var funcNode = p5UI_TableAjax_generateFunctionNode(funObj, rowPK, {ico: true, label: false});
  1631. funcNode.appendTo(cellNode);
  1632. });
  1633. moreFuncBtnNode = $('<a href="#" style="margin:0 2px;text-decoration:none" title="Więcej funkcji dla rekordu nr '+rowPK+'" class="glyphicon glyphicon-menu-hamburger"> </a>');
  1634. moreFuncBtnNode.on('click', {rowPK: rowPK, rowFunctions: rowFunctions, more: moreFunctions}, priv.popoverCellMoreFunctions);
  1635. moreFuncBtnNode.appendTo(cellNode);
  1636. return cellNode;
  1637. };
  1638. priv.popoverCellMoreFunctions = function(e) {
  1639. e.preventDefault();
  1640. e.stopPropagation();
  1641. if (!e.data || !e.data.rowPK) {
  1642. if (priv.options.debug || DBG) console.log('NO data');
  1643. return false;
  1644. }
  1645. if (priv.options.debug || DBG) console.log('TableAjax::popoverCellMoreFunctions: rowPK', e.data.rowPK, 'moreFunctions', e.data.more, 'rowFunctions', e.data.rowFunctions);
  1646. var lastId = _popoverCell.data('rowid');
  1647. var lastCol = _popoverCell.data('col');
  1648. var rowPK = e.data.rowPK;
  1649. var moreFunctions = e.data.more;
  1650. var rowFunctions = e.data.rowFunctions;
  1651. var funcListNode;
  1652. if (lastId == e.data.rowPK && lastCol == 'moreFunctions') {
  1653. //_popoverCellCurrent.popover('toggle');
  1654. return;
  1655. }
  1656. if (_popoverCellCurrent) {
  1657. _popoverCellCurrent.popover('destroy');
  1658. }
  1659. _popoverCell.data('rowid', rowPK);
  1660. _popoverCell.data('col', 'rowFunctions');
  1661. _popoverCell.empty();
  1662. funcListNode = $('<ul class="list-unstyled popoverRowFunctions"></ul>').appendTo(_popoverCell);
  1663. moreFunctions.forEach(function(funcName) {
  1664. var funcItemNode = $('<li></li>').appendTo(funcListNode),
  1665. funObj = rowFunctions[funcName],
  1666. funcNode = p5UI_TableAjax_generateFunctionNode(funObj, rowPK, {ico: true, label: true})
  1667. ;
  1668. funcNode.addClass('func_name-' + funcName);
  1669. funcItemNode.append(funcNode);
  1670. });
  1671. _popoverCell.append('<div class="popoverCellContent" style="white-space:normal"></div>');
  1672. _popoverCellCurrent = jQuery(e.currentTarget);
  1673. // title : '<span class="text-info"><strong>title</strong></span> <button type="button" id="close" class="close">&times;</button>'
  1674. var opts = {
  1675. container: 'body',
  1676. placement: 'right',
  1677. trigger: 'click',
  1678. template: '',
  1679. html: true,
  1680. content: _popoverCell.html()
  1681. }
  1682. opts.template += '<div class="popover" role="tooltip" style="max-width:600px;width:440px;">';
  1683. {
  1684. opts.template += '<div class="arrow"></div>';
  1685. //opts.template += '<h3 class="popover-title"></h3>';
  1686. opts.template += '<div style="display:block;position:relative;">';
  1687. {
  1688. opts.template += '<div class="popover-title">';
  1689. opts.template += '</div>';
  1690. opts.template += '<button type="button" class="close" onclick="return hidePopover();" style="position:absolute;right:8px;top:6px;">&times;</button>';
  1691. }
  1692. opts.template += '</div>';
  1693. opts.template += '<div class="popover-content"></div>';
  1694. }
  1695. opts.template += '</div>';
  1696. _popoverCellCurrent.popover(opts);
  1697. _popoverCellCurrent.on('shown.bs.popover', function(e) {
  1698. if (!_popoverCellCurrent) return;
  1699. var popoverNodeId = _popoverCellCurrent.attr('aria-describedby');
  1700. if (!popoverNodeId) return;
  1701. var popover$Node = jQuery('#' + popoverNodeId);
  1702. if (!popover$Node.length) return;
  1703. var arrow$Node = popover$Node.children('.arrow');
  1704. if (arrow$Node.length) {
  1705. var posTop = parseFloat(arrow$Node.css('top'));
  1706. arrow$Node.css('top', '' + posTop + 'px')
  1707. }
  1708. popover$Node.find('.popoverCellContent').html('<p class="text-muted">Pobieranie funkcji...<p>');
  1709. priv.ajaxLoadMoreFunctionsCell(rowPK);
  1710. });
  1711. _popoverCellCurrent.popover('show');
  1712. return;
  1713. };
  1714. priv.ajaxLoadMoreFunctionsCell = function(rowPK) {
  1715. var dbg = (priv.options.debug || DBG);
  1716. if (_popoverCellAjaxXhr) {
  1717. _popoverCellAjaxXhr.abort();
  1718. }
  1719. _popoverCellAjaxXhr = $.ajax({
  1720. type: 'GET',
  1721. url: priv.options.moreFunctionsCellAjaxUrl + '&ID=' + rowPK,
  1722. dataType: 'json',
  1723. contentType: "application/json; charset=utf-8",
  1724. data: ''
  1725. })
  1726. .done(function(data, textStatus, jqXHR){
  1727. if (data && 'success' === data.type) {
  1728. var popoverCellContent,
  1729. rowFunctions = [],
  1730. funcNodesToUpdate = []
  1731. ;
  1732. if (data.rowFunctions && data.rowFunctions.length > 0) {
  1733. rowFunctions = data.rowFunctions;
  1734. }
  1735. if (!rowFunctions.length) {
  1736. popoverCellContent = '<p class="text-muted">Brak dodatkowych funkcji</p>';
  1737. } else if (3 === priv.options.namespace.split('/').length) { // if namesapce is AntAcl [ and has ref fields or back ref ]
  1738. var popoverCellContent = $('<ul class="list-unstyled"></ul>');
  1739. var rowFunctionsByType = rowFunctions.reduce(function (ret, funObj) {
  1740. if (
  1741. 'Powiązania od ' === funObj.label.substr(0, 'Powiązania od '.length)
  1742. || 'Powiązania do ' === funObj.label.substr(0, 'Powiązania do '.length)
  1743. ) {
  1744. if (funObj.total > 0) {
  1745. ret.refConnections.push(funObj);
  1746. } else {
  1747. ret.refEmptyConnections.push(funObj);
  1748. }
  1749. } else {
  1750. ret.others.push(funObj);
  1751. }
  1752. return ret;
  1753. // href: "https://biuro.biall-net.pl/dev-pl/se-master/index.php?_route=ViewTableAjax&namespace=default_db/BI_audit_KRS/BI_audit_KRS&childRefNS=default_db/BI_audit_KRS/BI_audit_KRS&childRefPK=2068689"
  1754. // ico: "glyphicon glyphicon-random"
  1755. // label: "Powiązania od 'KRS' <span class="badge">0</span>"
  1756. // title: "Powiązania od 'Audyt / KRS' (0)"
  1757. }, { refConnections: [], refEmptyConnections: [], others: [] });
  1758. rowFunctionsByType.others.forEach(function(funObj) {
  1759. var funcNode = p5UI_TableAjax_generateFunctionNode(funObj, rowPK, {ico: true, label: true});
  1760. if (funObj.id) {
  1761. funcNodesToUpdate.push({id: funObj.id, node: funcNode});
  1762. } else {
  1763. var funcItemNode = $('<li></li>').appendTo(popoverCellContent);
  1764. funcItemNode.append(funcNode);
  1765. }
  1766. });
  1767. if (!rowFunctionsByType.refConnections.length) {
  1768. $('<li>Brak powiązań</li>').appendTo(popoverCellContent);
  1769. } else {
  1770. var refConnItemNode = $('<li style="margin-top:10px"><i class="glyphicon glyphicon-random"></i> <b>Powiązania</b></li>').appendTo(popoverCellContent);
  1771. {
  1772. var funObj = {
  1773. // ico: 'glyphicon glyphicon-random',
  1774. label: 'przeglądaj',
  1775. title: "Przeglądaj powiązania",
  1776. href: 'index.php?_route=RefGraph&namespace=' + priv.options.namespace + '&primaryKey=' + rowPK,
  1777. // onclick: function (e) { // TODO: open in
  1778. // console.log('TODO: przeglądaj powiązania')
  1779. // }
  1780. }
  1781. var funcNode = p5UI_TableAjax_generateFunctionNode(funObj, rowPK, { ico: true, label: true })
  1782. refConnItemNode.append(" - ");
  1783. refConnItemNode.append(funcNode);
  1784. }
  1785. var refConnFuncList = $('<ul class="list-unstyled" style="margin-left:20px"></ul>').appendTo(refConnItemNode);
  1786. rowFunctionsByType.refConnections.forEach(function(funObj) {
  1787. var refFunObj = Object.assign({}, funObj, {
  1788. // ico: null,
  1789. label: funObj.label.substr('Powiązania '.length),
  1790. });
  1791. var funcNode = p5UI_TableAjax_generateFunctionNode(refFunObj, rowPK, {ico: true, label: true});
  1792. var funcItemNode = $('<li></li>').appendTo(refConnFuncList);
  1793. funcItemNode.append(funcNode);
  1794. })
  1795. }
  1796. if (rowFunctionsByType.refEmptyConnections.length) {
  1797. var refConnItemNode = $('<li style="margin-top:10px; opacity:0.7"></li>').appendTo(popoverCellContent);
  1798. var emptyRefsDetailsNode = $('<details></details>').appendTo(refConnItemNode);
  1799. // $('<summary><i class="glyphicon glyphicon-random"></i> Pozostałe powiązania</summary>').appendTo(emptyRefsDetailsNode);
  1800. $('<summary style="cursor:pointer">Pozostałe powiązania ...</summary>').appendTo(emptyRefsDetailsNode);
  1801. var refConnFuncList = $('<ul class="list-unstyled" style="margin-left:20px"></ul>').appendTo(emptyRefsDetailsNode);
  1802. rowFunctionsByType.refEmptyConnections.forEach(function (funObj) {
  1803. var refFunObj = Object.assign({}, funObj, {
  1804. // ico: null,
  1805. label: funObj.label.substr('Powiązania '.length),
  1806. });
  1807. var funcNode = p5UI_TableAjax_generateFunctionNode(refFunObj, rowPK, { ico: true, label: true });
  1808. var funcItemNode = $('<li></li>').appendTo(refConnFuncList);
  1809. funcItemNode.append(funcNode);
  1810. })
  1811. }
  1812. } else {
  1813. var popoverCellContent = $('<ul class="list-unstyled"></ul>');
  1814. rowFunctions.forEach(function(funObj) {
  1815. var funcNode = p5UI_TableAjax_generateFunctionNode(funObj, rowPK, {ico: true, label: true});
  1816. if (funObj.id) {
  1817. funcNodesToUpdate.push({id: funObj.id, node: funcNode});
  1818. } else {
  1819. var funcItemNode = $('<li></li>').appendTo(popoverCellContent);
  1820. funcItemNode.append(funcNode);
  1821. }
  1822. });
  1823. }
  1824. //_popoverCell.append(popoverCellContent);// cache
  1825. if (_popoverCellCurrent) {
  1826. var popoverNodeId = _popoverCellCurrent.attr('aria-describedby');
  1827. if (popoverNodeId) {
  1828. var popoverNode = jQuery('#' + popoverNodeId),
  1829. popoverCntNode = popoverNode.find('.popoverCellContent'),
  1830. popoverRowFuncNode = popoverNode.find('.popoverRowFunctions');
  1831. ;
  1832. {// fix generated row Functions by loaded from ajax call
  1833. if(dbg) console.log('popoverRowFunctions. popoverRowFuncNode', popoverRowFuncNode);
  1834. if(dbg) console.log('popoverRowFunctions. funcNodesToUpdate', funcNodesToUpdate);
  1835. funcNodesToUpdate.forEach(function(funcNodeInfo) {
  1836. var className = 'func_name-' + funcNodeInfo.id,
  1837. foundRowFuncNode = null
  1838. ;
  1839. if(dbg) console.log('popoverRowFunctions. funcNodesToUpdate loop:', funcNodeInfo);
  1840. popoverRowFuncNode.find('li > a').each(function(ind, n) {
  1841. var n$ = $(n);
  1842. if(dbg) console.log('popoverRowFunctions loop(',ind,'):', n, 'data(func_name)', n$.data('func_name'), 'data', n$.data());
  1843. if (n$.hasClass(className)) {
  1844. foundRowFuncNode = n$;
  1845. }
  1846. });
  1847. if (foundRowFuncNode) {
  1848. foundRowFuncNode.replaceWith(funcNodeInfo.node);
  1849. } else {
  1850. var funcItemNode = $('<li></li>').appendTo(popoverCellContent);
  1851. funcItemNode.append(foundRowFuncNode);
  1852. }
  1853. });
  1854. }
  1855. popoverCntNode.empty().append(popoverCellContent);
  1856. if (rowFunctions.length <= 0) {
  1857. popoverCntNode.find('p.text-muted').delay(600).hide(300);
  1858. }
  1859. }
  1860. }
  1861. }
  1862. });
  1863. };
  1864. priv.renderRowEmptyNode = function() {
  1865. var rowNode = $('<tr></tr>');
  1866. if (priv.options.rowFunctions || priv.options.filtersClean) {
  1867. $('<td class="text-right stickyCol stickyCol1">&nbsp;</td>').appendTo(rowNode);
  1868. }
  1869. if (_state.primaryKey && priv.options.checkboxes) {
  1870. var cellNode = $('<td class="stickyCol stickyCol2" style="padding:3px 5px"></td>').appendTo(rowNode);
  1871. }
  1872. for (var i = 0; i < _state.colsSorted.length; i++) {
  1873. var columnName = _state.colsSorted[i],
  1874. columnProps = _data.cols[columnName]
  1875. ;
  1876. if (!columnProps) return;
  1877. if (columnProps.hidden) continue;// "unique" is hidden - TODO: rm "unique" from _state.colsSorted ?
  1878. if (i == 1) {// TODO: 1 is pk - use better check
  1879. $('<td class="stickyCol3">&nbsp;</td>').appendTo(rowNode);
  1880. } else {
  1881. $('<td>&nbsp;</td>').appendTo(rowNode);
  1882. }
  1883. }
  1884. return rowNode;
  1885. };
  1886. priv.renderTableTheadSort = function() {
  1887. DBG && console.log('DBG:renderTableTheadSort', { '_state._currSortCol': _state._currSortCol, '_state._currSortFlip': _state._currSortFlip });
  1888. var nodeClass = 'tblAjax__' + 'head__sort'
  1889. var currentNode = _uiNode$Table.find('thead').find('.' + nodeClass)
  1890. var node = $('<tr class="sort ' + nodeClass + '"></tr>')
  1891. if (priv.options.tblFunctions || priv.options.filtersClean) {
  1892. var headCell = $('<th class="text-right head-info stickyCol stickyCol1"></th>').appendTo(node)
  1893. $.map(priv.options.tblFunctions, function (funObj, funName) {
  1894. var funHtml = $('<a></a>')
  1895. funHtml.attr('href', funObj.href || '#')
  1896. if (funObj.title) funHtml.attr('title', funObj.title)
  1897. if (funObj.icon) funHtml.html('<span class="glyphicon glyphicon-' + funObj.icon + '"></span> ')
  1898. if (funObj.method && priv[funObj.method] && typeof priv[funObj.method] == 'function') {
  1899. funHtml.on('click', priv[funObj.method])
  1900. }
  1901. funHtml.appendTo(headCell)
  1902. })
  1903. }
  1904. if (_state.primaryKey && priv.options.checkboxes) {
  1905. var headCell = $('<th class="stickyCol stickyCol2" style="padding:3px 5px"></th>').appendTo(node);
  1906. ReactDOM.render(
  1907. h(P5UI__TableAjaxRowCheckbox, {
  1908. namespace: priv.options.namespace,
  1909. primaryKey: 'select-all',
  1910. store: priv.options.selectedStore,
  1911. actions: priv.options.selectedActions
  1912. }),
  1913. headCell.get(0)
  1914. );
  1915. }
  1916. for (var i = 0; i < _state.colsSorted.length; i++) {
  1917. var column = _state.colsSorted[i]
  1918. var props = _data.cols[column]
  1919. DBG && console.log('DBG:renderTableTheadSort loop', { column, props });
  1920. if (props.hidden) continue;
  1921. var headCell = $('<th class="ta-ordering"></th>').appendTo(node)
  1922. if (_state.primaryKey === column) headCell.addClass('stickyCol stickyCol3')
  1923. ReactDOM.render(
  1924. h(P5UI__TableAjaxSortableLabel, {
  1925. namespace: priv.options.namespace,
  1926. isSortable: (props.sortable !== false && props.type != 'special' && props.type != 'geom' && props.type != "simpleLink" && props.type != "ref"), // TODO: props.sortable
  1927. fieldName: column,
  1928. fieldProps: props,
  1929. store: priv.options.filterStore,
  1930. actions: priv.options.filterActions
  1931. }),
  1932. headCell.get(0)
  1933. );
  1934. if (column !== _state.primaryKey) {
  1935. var hideColBtn = $('<i class="glyphicon glyphicon-remove remove-cell"></i>')
  1936. hideColBtn.on('click', {column: column}, priv.columnHideClicked)
  1937. hideColBtn.appendTo(headCell)
  1938. }
  1939. }
  1940. currentNode.replaceWith(node)
  1941. };
  1942. priv.renderHeadSpecialFilters = function() {
  1943. DBG && console.warn('DBG:priv.renderHeadSpecialFilters...', { 'priv.options.specialFilterFunctions': priv.options.specialFilterFunctions });
  1944. if (!priv.options.specialFilterFunctions) {
  1945. return;
  1946. }
  1947. ReactDOM.render(
  1948. h(P5UI__TableAjaxSpecialFilters, {
  1949. store: priv.options.filterStore,
  1950. actions: priv.options.filterActions,
  1951. specialFilters: priv.options.specialFilterFunctions,
  1952. namespace: priv.options.namespace,
  1953. }),
  1954. _uiNodeSpecialFilters
  1955. );
  1956. };
  1957. priv.renderTableTheadFilter = function() {
  1958. DBG && console.log('DBG::renderTableTheadFilter...');
  1959. var nodeClass = 'tblAjax__' + 'head__filter',
  1960. currentNode = _uiNode$Table.find('thead').find('.' + nodeClass),
  1961. node;
  1962. // currentNode.find('i').tooltip('hide');
  1963. node = $('<tr class="filter ' + nodeClass + '"></tr>');
  1964. //_head.find(".filter").remove();
  1965. //_headFilter = $('<tr class="filter"></tr>').appendTo(_head);
  1966. var headCell;
  1967. var elem;
  1968. var placeHolder = '';
  1969. var tooltip = '';
  1970. //create the functions column
  1971. if (priv.options.rowFunctions || priv.options.filtersClean) {
  1972. var headCell = $('<th class="text-right stickyCol stickyCol1"></th>').appendTo(node);
  1973. headCell.css({padding: '0'});
  1974. if (priv.options.filtersClean) {
  1975. ReactDOM.render(
  1976. h(p5UI__TableAjaxClearAllFilters, {
  1977. store: priv.options.filterStore,
  1978. actions: priv.options.filterActions
  1979. }),
  1980. headCell.get(0)
  1981. );
  1982. }
  1983. }
  1984. //create the filter checkbox
  1985. if (_state.primaryKey && priv.options.checkboxes) {
  1986. // tooltip = priv.options.types.bool.filterTooltip || 'Pokaż tylko:<br/>nieokreślony,<br/>zaznaczony,<br/>niezaznaczony';
  1987. headCell = $('<th class="stickyCol stickyCol2" style="padding:0"></th>').appendTo(node);
  1988. ReactDOM.render(
  1989. h(P5UI__TableAjaxFieldCheckboxSearch, {
  1990. namespace: priv.options.namespace,
  1991. fieldName: ( priv.options.checkboxIdContext ? '@sel_' + priv.options.checkboxIdContext : '@selected' ),
  1992. store: priv.options.filterStore,
  1993. actions: priv.options.filterActions
  1994. }),
  1995. headCell.get(0)
  1996. );
  1997. }
  1998. //create the column filters
  1999. for (var i = 0; i < _state.colsSorted.length; i++) {
  2000. var column = _state.colsSorted[i];
  2001. var props = _data.cols[column];
  2002. tooltip = props.filterTooltip === true ? undefined : props.filterTooltip === false ? '' : props.filterTooltip;
  2003. placeHolder = props.placeHolder === true ? undefined : props.placeHolder === false ? '' : props.placeHolder;
  2004. if (props.hidden) continue;
  2005. headCell = $('<th></th>').appendTo(node);
  2006. headCell.css({padding: '0'});
  2007. if (i == 1) headCell.addClass('stickyCol stickyCol3');
  2008. if (props.filterable === false) continue;
  2009. ReactDOM.render(
  2010. h(p5UI__FieldInputFilterSearch, {
  2011. disabled: (priv.options.forceFilterInit && undefined !== priv.options.forceFilterInit[column]),
  2012. fieldName: column,
  2013. type: props.type,
  2014. lagacyProps: props, // TODO: use ony required like xsdType
  2015. // xsdType: props.xsdType,
  2016. store: priv.options.filterStore,
  2017. onChange: function (fieldName, value) {
  2018. priv.options.filterStore.dispatch( priv.options.filterActions.delayFilter(fieldName, value) );
  2019. }
  2020. }),
  2021. headCell.get(0)
  2022. );
  2023. }
  2024. currentNode.replaceWith(node);
  2025. };
  2026. priv.renderTableTfoot = function() {
  2027. _uiNode$Table.find('tfoot').remove();
  2028. _foot = $('<tfoot></tfoot>').insertAfter(_bodyNode);
  2029. //$(_uiNodeCont).next('.foot').replaceWith(_foot);
  2030. };
  2031. priv.renderFooter = function() {
  2032. priv.renderFooterInfo();
  2033. priv.renderFooterPagination();
  2034. priv.renderFooterPageSizes();
  2035. priv.renderFooterColumnPicker();
  2036. priv.renderFooterFunctions();
  2037. priv.renderFooterExport();
  2038. };
  2039. priv.renderFooterInfo = function() {
  2040. DBG && console.log('DBG:TableAjax::renderFooterInfo', { _uiNodeFooterInfo: _uiNodeFooterInfo });
  2041. var fromRow = Math.max(_state.page - 1, 0) * _state.pageSize;
  2042. var total = _data.total;
  2043. var renderedRowsCount = Math.min(_data.rows.length, _state.pageSize);
  2044. var toRow = fromRow + renderedRowsCount;
  2045. var outTotal = (_state.isLoadingTotal) ? '...' : total;
  2046. DBG && console.log('DBG:TableAjax::renderFooterInfo', { total: total,
  2047. asyncFetchTotal__lastSentReqId: _state.asyncFetchTotal__lastSentReqId,
  2048. asyncFetchTotal__lastReceivedId: _state.asyncFetchTotal__lastReceivedId,
  2049. isLoadingTotal: _state.isLoadingTotal
  2050. });
  2051. if (_state.isLoadingTotal) {
  2052. outTotal = '...';
  2053. _uiNodeFooterInfo.innerHTML = '<div style="font-size:12px; line-height:1.4em;">' +
  2054. '<strong>Łącznie wyników:</strong> <span class="hide-on-loading">' + outTotal + '</span>' +
  2055. '<br>' +
  2056. ( (toRow > 0)
  2057. ? '<small class="hide-on-loading" style="color:#999; font-size:10px">' + p5Utils__format('Wyświetlane wiersze: od {0} do {1}', [fromRow + 1, toRow]) + '</small>'
  2058. : ''
  2059. ) +
  2060. '</div>';
  2061. } else if (total > 0) {
  2062. outTotal = total;
  2063. _uiNodeFooterInfo.innerHTML = '<div style="font-size:12px; line-height:1.4em;">' +
  2064. '<strong>Łącznie wyników:</strong> <span class="hide-on-loading">' + outTotal + '</span>' +
  2065. '<br>' +
  2066. '<small class="hide-on-loading" style="color:#999; font-size:10px">' + p5Utils__format('Wyświetlane wiersze: od {0} do {1}', [fromRow + 1, toRow]) + '</small>' +
  2067. '</div>';
  2068. } else {
  2069. _uiNodeFooterInfo.innerHTML = '<p><strong>Brak wierszy pasujących do kryteriów wyszukiwania<strong></p>';
  2070. }
  2071. };
  2072. priv.renderFooterPagination = function() {
  2073. var nodeClass = 'tblAjax__' + 'footer__toolbar__pagination',
  2074. currentNode = $(_uiNodeCont).next('.foot').find('.' + nodeClass),
  2075. node;
  2076. var currPage = _state.page;
  2077. if (priv.options.debug || DBG) console.log('Render: ', nodeClass, '_data.total', _data.total, 'currPage', currPage);
  2078. if (_state.isLoadingTotal || _data.total > 0) {
  2079. var fromRow = Math.max(_state.page - 1, 0) * _state.pageSize;
  2080. var renderedRowsCount = Math.min(_data.rows.length, _state.pageSize);
  2081. var toRow = fromRow + renderedRowsCount;
  2082. var total = (_data.total > 0) ? _data.total : toRow;
  2083. node = $('<div class="btn-group ' + nodeClass + '"></div>');
  2084. var totalPages = Math.ceil(total / _state.pageSize);
  2085. var lowerPage = currPage - 2;
  2086. var upperPage = currPage + 2;
  2087. if (upperPage > totalPages) {
  2088. var diff = upperPage - totalPages;
  2089. upperPage = totalPages;
  2090. lowerPage -= diff;
  2091. }
  2092. if (lowerPage < 1) lowerPage = 1;
  2093. if (upperPage < 5) upperPage = 5;
  2094. var enableNextPageLink = (
  2095. (_state.isLoadingTotal && renderedRowsCount === _state.pageSize)
  2096. || (!(_state.isLoadingTotal) && currPage < totalPages)
  2097. );
  2098. var enableLastPageLink = ( !(_state.isLoadingTotal) && (currPage < totalPages) );
  2099. //$(p5Utils__format('<li class="{0}"><a href="#">&lt;&lt;</a></li>', [currPage == 1 ? 'disabled' : '']))
  2100. $(p5Utils__format('<button type="button" class="btn btn-default{0}">&lt;&lt;</button>', [currPage == 1 ? ' disabled' : '']))
  2101. .on('click', {pageIndex: 1}, priv.pageChanged)
  2102. .appendTo(node);
  2103. //$(p5Utils__format('<li class="{0}"><a href="#">&lt;</a></li>', [currPage == 1 ? 'disabled' : '']))
  2104. $(p5Utils__format('<button type="button" class="btn btn-default{0}">&lt;</button>', [currPage == 1 ? ' disabled' : '']))
  2105. .on('click', {pageIndex: currPage - 1}, priv.pageChanged)
  2106. .appendTo(node);
  2107. for (var i = lowerPage; i <= upperPage; i++) {
  2108. var link;
  2109. //if (i != currPage) link = $(p5Utils__format('<li class="{1}"><a href="#">{0}</a></li>', [i, i > totalPages ? 'disabled' : '']));
  2110. if (i != currPage) link = $(p5Utils__format('<button type="button" class="btn btn-default{1}">{0}</button>', [i, i > totalPages ? ' disabled' : '']));
  2111. //if (i == currPage) link = $(p5Utils__format('<li class="active"><a href="#">{0}</a></li>', [i]));
  2112. if (i == currPage) link = $(p5Utils__format('<button type="button" class="btn btn-default active">{0}</button>', [i]));
  2113. if (link) {
  2114. link.on('click', {pageIndex: i}, priv.pageChanged);
  2115. link.appendTo(node);
  2116. }
  2117. }
  2118. //$(p5Utils__format('<li class="{0}"><a href="#">&gt;</a></li>', [currPage == totalPages ? 'disabled' : '']))
  2119. $(p5Utils__format('<button type="button" class="btn btn-default{0}">&gt;</button>', [enableNextPageLink ? '' : ' disabled']))
  2120. .on('click', {pageIndex: currPage + 1}, priv.pageChanged)
  2121. .appendTo(node);
  2122. //$(p5Utils__format('<li class="{0}"><a href="#">&gt;&gt;</a></li>', [currPage == totalPages ? 'disabled' : '']))
  2123. $(p5Utils__format('<button type="button" class="btn btn-default{0}">&gt;&gt;</button>', [enableLastPageLink ? '' : ' disabled']))
  2124. .on('click', {pageIndex: totalPages}, priv.pageChanged)
  2125. .appendTo(node);
  2126. } else {
  2127. node = $('<span class="' + nodeClass + '"></span>');
  2128. }
  2129. currentNode.replaceWith(node);
  2130. };
  2131. priv.renderFooterPageSizes = function() {
  2132. var nodeClass = 'tblAjax__' + 'footer__toolbar__pagesizes',
  2133. currentNode = $(_uiNodeCont).next('.foot').find('.' + nodeClass),
  2134. node;
  2135. if (priv.options.debug || DBG) console.log('Render: ', nodeClass);
  2136. if (priv.options.pageSizes.length > 0) {
  2137. node = $('<div class="btn-group dropup pagesize ' + nodeClass + '"></div>');
  2138. var btn = $('<button class="btn btn-sm btn-default dropdown-toggle" data-toggle="dropdown" href="#">Liczba wierszy&nbsp;</button>').appendTo(node);
  2139. var span = $('<span class="caret"></span>').appendTo(btn);
  2140. var ul = $('<ul class="dropdown-menu" style="max-height:250px;overflow:auto;">').appendTo(node);
  2141. $.each(priv.options.pageSizes, function(index, val) {
  2142. var li = $('<li></li>').appendTo(ul);
  2143. if (val == priv.options.pageSize) {
  2144. $(p5Utils__format('<a style="color:#337AB7;">{0}</a>', [val])).appendTo(li);
  2145. } else {
  2146. $(p5Utils__format('<a href="#">{0}</a>', [val])).appendTo(li);
  2147. }
  2148. });
  2149. node.on('click', 'a', priv.pageSizeChanged);
  2150. } else {
  2151. node = $('<span class="' + nodeClass + '"></span>');
  2152. }
  2153. currentNode.replaceWith(node);
  2154. };
  2155. priv.renderFooterColumnPicker = function() {
  2156. var nodeClass = 'tblAjax__' + 'footer__toolbar__columnPicker',
  2157. currentNode = $(_uiNodeCont).next('.foot').find('.' + nodeClass),
  2158. node;
  2159. if (priv.options.debug || DBG) console.log('Render: ', nodeClass);
  2160. if (priv.options.columnPicker) {
  2161. node = $('<div class="btn-group dropup columnpicker ' + nodeClass + '"></div>');
  2162. var btn = $('<button class="btn btn-sm btn-default dropdown-toggle" data-toggle="dropdown" href="#">Kolumny&nbsp;</button>').appendTo(node);
  2163. var span = $('<span class="caret"></span>').appendTo(btn);
  2164. var ul = $('<ul class="dropdown-menu" style="max-height:250px;overflow:auto;">').appendTo(node);
  2165. var selectedFilter = priv.modelColFilter_getSelected();
  2166. priv.modelColFilter_getFilters().map(function(colFltr) {
  2167. var li = $('<li></li>').appendTo(ul),
  2168. selected = (selectedFilter && selectedFilter == colFltr.name)? 'checked="checked"' : '',
  2169. input = '<input ' + selected + ' type="radio" style="margin:0"/>',
  2170. a = $('<a href="#" data-col_filter="' + colFltr.name + '" style="padding:0px 20px;">' + input + ' ' + colFltr.label + '</a>').appendTo(li);
  2171. if ('all' != colFltr.name && 'most_used' != colFltr.name) {
  2172. arm = $('<button data-col_filter="' + colFltr.name + '" class="pull-right btn btn-xs btn-link" style="margin:0;padding:0;border:0;color:red">' + '&times;' + '</a>').appendTo(a);
  2173. arm.on('click', priv.modelColFilter_onClickRemoveFilter)
  2174. }
  2175. });
  2176. {// if (!selectedFilter) {// save current filter
  2177. var li = $('<li style="text-align:center; clear:both"></li>').appendTo(ul)
  2178. priv.modelColFilter_getSaveBtn().appendTo(li);
  2179. }
  2180. $('<li class="divider"></li>').appendTo(ul);
  2181. $.each(_data.cols, function(col, props) {
  2182. if (props.type != "unique" && col != _state.primaryKey) {
  2183. var li = $('<li></li>').appendTo(ul),
  2184. label = (props.friendly || col).replace(/<br\/?>/g, ' '),
  2185. input = p5Utils__format('<input {0} type="checkbox" title="{1}" value="{1}" style="margin:0"/>&nbsp;{2}', [(props.hidden) ? '' : 'checked', col, label]),
  2186. a = $('<a href="#" style="padding:0px 20px;">' + input + '</a>').appendTo(li);
  2187. }
  2188. });
  2189. node.on('click', 'input[type="checkbox"]', priv.columnPickerClicked);
  2190. node.on('click', 'a', priv.columnPickerLinkClicked);
  2191. } else {
  2192. node = $('<span class="' + nodeClass + '"></span>');
  2193. }
  2194. currentNode.replaceWith(node);
  2195. };
  2196. priv.renderFooterFunctions = function() {
  2197. var nodeClass = 'tblAjax__' + 'footer__toolbar__functions',
  2198. currentNode = $(_uiNodeCont).next('.foot').find('.' + nodeClass),
  2199. node;
  2200. if (priv.options.debug || DBG) console.log('Render: ', nodeClass);
  2201. if (priv.options.tblFunctions) {
  2202. node = $('<div class="btn-group ' + nodeClass + '"></div>');
  2203. $.map(priv.options.tblFunctions, function(funObj, funName){
  2204. var funHtml = $('<button class="btn btn-sm btn-default"></button>');
  2205. if (funObj.title) funHtml.attr('title', funObj.title);
  2206. if (funObj.method) funHtml.on('click', priv[funObj.method]);
  2207. else if (funObj.href) funHtml.on('click', {hash:funObj.href}, priv.routeChanged);
  2208. var funIconHtml = $('<i></i>');
  2209. if (funObj.icon) funIconHtml.attr('class', 'glyphicon glyphicon-' + funObj.icon);
  2210. funIconHtml.prependTo(funHtml);
  2211. funHtml.addClass('btn');
  2212. funHtml.appendTo(node);
  2213. });
  2214. } else {
  2215. node = $('<span class="' + nodeClass + '"></span>');
  2216. }
  2217. currentNode.replaceWith(node);
  2218. };
  2219. priv.renderFooterExport = function() {
  2220. var nodeClass = 'tblAjax__' + 'footer__toolbar__export',
  2221. currentNode = $(_uiNodeCont).next('.foot').find('.' + nodeClass),
  2222. node;
  2223. if (priv.options.debug || DBG) console.log('Render: ', nodeClass);
  2224. if (priv.options.exportFields && priv.options.exportFields.length) {
  2225. node = $('<div class="btn-group dropup pagesize ' + nodeClass + '"></div>');
  2226. var btn = $('<button class="btn btn-sm btn-default dropdown-toggle" data-toggle="dropdown" href="#">Export&nbsp;</button>').appendTo(node);
  2227. var span = $('<span class="caret"></span>').appendTo(btn);
  2228. var ul = $('<ul class="dropdown-menu" style="max-height:250px;padding:5px 20px 5px 8px;overflow:auto;">').appendTo(node);
  2229. $.each(_data.cols, function(col, props) {
  2230. if (-1 !== priv.options.exportFields.indexOf(col)) {
  2231. var li = $('<li></li>').appendTo(ul);
  2232. $(p5Utils__format('<input {0} type="checkbox" title="{1}" value="{1}" >&nbsp;{2}</input>', [(_exportFieldsSelect[col])? 'checked' : '', col, props.friendly || col])).appendTo(li);
  2233. li.on('click', 'input', priv.exportFieldChanged);
  2234. }
  2235. });
  2236. var li;
  2237. li = $('<li></li>').appendTo(ul);
  2238. $('<a href="index.php" target="_blank" class=""><i class="glyphicon glyphicon-share"></i>Podgląd <em style="font-size:85%">(HTML)</em></a>').appendTo(li);
  2239. li.on('click', 'a', priv.exportToHTML);
  2240. li = $('<li></li>').appendTo(ul);
  2241. $('<a href="index.php" target="_blank" class=""><i class="glyphicon glyphicon-share"></i>Export do CSV</a>').appendTo(li);
  2242. li.on('click', 'a', priv.exportToCSV);
  2243. li = $('<li></li>').appendTo(ul);
  2244. $('<a href="index.php" target="_blank" class=""><i class="glyphicon glyphicon-share" title="Export do pliku CSV w kodowaniu Windows-1250"></i>Export do CSV (Windows-1250)</a>').appendTo(li);
  2245. li.on('click', 'a', priv.exportToCSVWinCP1250);
  2246. li = $('<li></li>').appendTo(ul);
  2247. $('<a href="index.php" target="_blank" class=""><i class="glyphicon glyphicon-share" title="Export XLS"></i>Export do XLS</a>').appendTo(li);
  2248. li.on('click', 'a', priv.exportToXLS);
  2249. li = $('<li></li>').appendTo(ul);
  2250. $('<a href="index.php" target="_blank" class=""><i class="glyphicon glyphicon-share" title="Export XLSX"></i>Export do XLSX</a>').appendTo(li);
  2251. li.on('click', 'a', priv.exportToXLSX);
  2252. } else {
  2253. node = $('<span class="' + nodeClass + '"></span>');
  2254. }
  2255. currentNode.replaceWith(node);
  2256. };
  2257. priv.renderInlineEditBox = function() {
  2258. var nodeClass = 'tblAjax__' + 'inlineEditBox',
  2259. currentNode = $(_uiNodeCont).parent().children('.' + nodeClass),
  2260. node;
  2261. var node = $('<div class="' + nodeClass + ' modal fade" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"></div>');
  2262. var modalWrap = $('<div class="modal-dialog"></div>').appendTo(node);
  2263. var modalWrap = $('<div class="modal-content"></div>').appendTo(modalWrap);
  2264. var frmInlineEdit = $('<form style="margin:0;padding:0;"></form>').appendTo(modalWrap);
  2265. var iebHead = $('<div class="modal-header" style="cursor:pointer">').appendTo(frmInlineEdit);
  2266. $('<button type="button" class="close" data-dismiss="modal" aria-hidden="true"><i class="glyphicon glyphicon-remove" style="color:red"></i></button>').appendTo(iebHead);
  2267. $('<h4 id="myModalLabel">Edytuj</h4>').appendTo(iebHead);
  2268. var iebBodyWrap = $('<div class="modal-body" style="padding:0"></div>').appendTo(frmInlineEdit);
  2269. var iebBody = $('<div style="padding:15px"></div>').appendTo(iebBodyWrap);
  2270. $('<input type="hidden" name="ID" value="">').appendTo(iebBody);
  2271. $('<input type="hidden" name="col" value="">').appendTo(iebBody);
  2272. $('<div class="inlineEditBox-cnt"></div>').appendTo(iebBody);
  2273. var iebFoot = $('<div class="modal-footer"></div>').appendTo(frmInlineEdit);
  2274. $('<button class="btn btn-close" data-dismiss="modal" aria-hidden="true">Zamknij</button>').appendTo(iebFoot);
  2275. var iebBtnSave = $('<input type="submit" value="Zapisz" class="btn btn-primary btn-save">').appendTo(iebFoot);
  2276. frmInlineEdit.on('submit', function() {
  2277. var inlineEditBox$Node = $(_uiNodeCont).parent().children('.tblAjax__inlineEditBox');
  2278. var data = inlineEditBox$Node.find('form').serialize();
  2279. inlineEditBox$Node.find('.inlineEditBox-cnt').html('<span class="loading-info"> loading ...</span>');
  2280. function notifyAjaxCallback(data) {
  2281. var notify = {};
  2282. notify.type = (data && data.type)? data.type : '';
  2283. notify.msg = (data && data.msg)? data.msg : '';
  2284. switch (notify.type) {
  2285. case 'success':
  2286. if (!notify.msg) notify.msg = 'Dane poprawnie zaktualizowane';
  2287. break;
  2288. case 'info':
  2289. if (!notify.msg) notify.msg = 'Nie wprowadzono żadnych zmian';
  2290. break;
  2291. case 'error':
  2292. if (!notify.msg) notify.msg = 'Wystąpiły błędy';
  2293. break;
  2294. case 'warning':
  2295. notify.type = 'warn';
  2296. if (!notify.msg) notify.msg = 'Wystąpiły błędy';
  2297. break;
  2298. default:
  2299. notify.msg = 'Nieznany błąd';
  2300. if (data && data.errorCode) notify.msg += ' ' + data.errorCode;
  2301. notify.type = '';
  2302. }
  2303. jQuery.notify(notify.msg, notify.type);
  2304. }
  2305. $.ajax({
  2306. data: data,
  2307. dataType: 'json',
  2308. type: "POST",
  2309. url: priv.options.editInlineSaveUrl
  2310. })
  2311. .done(function(data, textStatus, jqXHR){
  2312. notifyAjaxCallback(data);
  2313. publ.refresh();
  2314. inlineEditBox$Node.modal('hide');
  2315. })
  2316. .fail(function(jqXHR){// jqXHR.fail(function( jqXHR, textStatus, errorThrown ) {});
  2317. if (jqXHR.responseJSON) {
  2318. notifyAjaxCallback(jqXHR.responseJSON);
  2319. }
  2320. else {
  2321. var txt = jqXHR.responseText || 'Wystąpiły błędy';
  2322. if (jqXHR.status == 404) {
  2323. jQuery.notify(jqXHR.responseText, 'error');
  2324. } else {
  2325. jQuery.notify(jqXHR.responseText, 'warn');
  2326. }
  2327. }
  2328. inlineEditBox$Node.modal('hide');
  2329. });
  2330. return false;
  2331. });
  2332. currentNode.replaceWith(node);
  2333. };
  2334. priv.exportFieldChanged = function(e) {
  2335. e.stopPropagation();
  2336. var column = $(this).val();
  2337. _exportFieldsSelect[column] = !_exportFieldsSelect[column];
  2338. };
  2339. priv.exportToHTML = function(e) {
  2340. priv.exportData('html', $(this), e);
  2341. };
  2342. priv.exportToCSV = function(e) {
  2343. priv.exportData('csv', $(this), e);
  2344. };
  2345. priv.exportToCSVWinCP1250 = function(e) {
  2346. priv.exportData('csv_cp1250', $(this), e);
  2347. };
  2348. priv.exportToXLS = function(e) {
  2349. priv.exportData('xls', $(this), e);
  2350. };
  2351. priv.exportToXLSX = function(e) {
  2352. priv.exportData('xlsx', $(this), e);
  2353. };
  2354. priv.exportData = function(format, node, e) {
  2355. var exportFields = [];
  2356. $.each(_exportFieldsSelect, function(col, selected) {
  2357. if (selected) {
  2358. exportFields.push(col);
  2359. }
  2360. });
  2361. if (!exportFields.length) {
  2362. alert('Nie wybrano żadnych pól do eksportu.');
  2363. e.preventDefault();
  2364. return false;
  2365. }
  2366. var limit = 10000;
  2367. if (!_data.total || _data.total <= 0) {
  2368. alert('Brak rekordów do eksportu.');
  2369. e.preventDefault();
  2370. return false;
  2371. }
  2372. if (_data.total > limit) {
  2373. if (!confirm('Za dużo rekordów. Wyeksportowane zostaną tylko pierwsze ' + limit + ' z ' + _data.total + ' rekordów.')) {
  2374. e.preventDefault();
  2375. return false;
  2376. }
  2377. }
  2378. e.preventDefault();
  2379. var frm = document.createElement('form');
  2380. frm.style.display = "none";
  2381. frm.setAttribute('target', "_blank");
  2382. frm.method = "POST";
  2383. frm.action = "index.php?_route=ExportTableAjax&" + priv.filter_getFilterQuery();
  2384. function craeteHtmlInputElement(name, value) {
  2385. var input = document.createElement("input");
  2386. input.value = value;
  2387. input.name = name;
  2388. return input;
  2389. }
  2390. frm.appendChild(craeteHtmlInputElement('namespace', priv.options.namespace));
  2391. frm.appendChild(craeteHtmlInputElement('format', format));
  2392. frm.appendChild(craeteHtmlInputElement('flds', exportFields.join(',')));
  2393. frm.appendChild(craeteHtmlInputElement('sortCol', (_state._currSortCol || '')));
  2394. frm.appendChild(craeteHtmlInputElement('sortDir', (_state._currSortFlip ? "desc" : "asc")));
  2395. var url = new URL(window.location.href);
  2396. if (url.searchParams.get('childRefNS')) {
  2397. frm.appendChild(craeteHtmlInputElement('childRefNS', url.searchParams.get('childRefNS')));
  2398. frm.appendChild(craeteHtmlInputElement('childRefPK', url.searchParams.get('childRefPK')));
  2399. }
  2400. if (url.searchParams.get('backRefNS')) {
  2401. frm.appendChild(craeteHtmlInputElement('backRefNS', url.searchParams.get('backRefNS')));
  2402. frm.appendChild(craeteHtmlInputElement('backRefPK', url.searchParams.get('backRefPK')));
  2403. frm.appendChild(craeteHtmlInputElement('backRefField', url.searchParams.get('backRefField')));
  2404. }
  2405. document.body.appendChild(frm);
  2406. frm.submit();
  2407. document.body.removeChild(frm);
  2408. };
  2409. priv.showFailFetchDataMsg = function () {
  2410. var clearAllFiltersBtn = jQuery('<button class="btn btn-xs btn-link" style="color:red">usunąć wszystkie filtry</button>')
  2411. clearAllFiltersBtn.on('click', function () {
  2412. priv.options.filterStore.dispatch( priv.options.filterActions.clearAllFilters() )
  2413. jQuery(this).parent().remove();
  2414. })
  2415. var msgNode = jQuery('<div class="alert alert-danger" style="clear:both; max-width:600px; margin: 10px auto">' +
  2416. 'Wystąpił błąd podczas pobierania danych ' +
  2417. '<a href="javascript:window.location.reload()" class="btn btn-xs btn-link">spróbuj ponownie</a>.' + '<br>' +
  2418. 'Jeśli problem się powtarza, spróbuj ' +
  2419. '</div>')
  2420. msgNode.append(clearAllFiltersBtn);
  2421. jQuery(_uiNodeCont).prepend(msgNode);
  2422. }
  2423. /*
  2424. calls the webservice(if defined).
  2425. used only inside priv.init
  2426. */
  2427. priv.update = function(callback) {
  2428. var skipCols, resetChecked;// undefined
  2429. if (!priv.options.url) {
  2430. if (priv.options.debug || DBG) console.log('no url found');
  2431. return;
  2432. }
  2433. if (priv.options.debug || DBG) console.log(p5Utils__format('requesting data from url:{0}', [priv.options.url]));
  2434. var initUrlAdd = '&' + priv.filter_getFullFilterQuery();
  2435. if (SKIP_TOTAL) initUrlAdd += '&' + 'SKIP_TOTAL=1';
  2436. DBG && console.warn('DBG:update... - FETCH_DATA', { initUrlAdd, '_state._filterQuery': _state._filterQuery, '_state._specialFilterQuery': _state._specialFilterQuery, _state });
  2437. // p5UI__notifyAjaxCallback({type: 'info', msg: 'pobieranie danych (init) ...'});
  2438. window.fetch(priv.options.url + initUrlAdd, {
  2439. method: priv.options.urlPost ? 'POST' : 'GET',
  2440. credentials: 'same-origin',// add cookies
  2441. }).then(function (response) {
  2442. return response.json()
  2443. }).then(function (data) {
  2444. if (priv.options.debug || DBG) console.log('loadDataAjax:fetch:update: request finished response data:', data);
  2445. if ('success' == data.type) {
  2446. return data;
  2447. } else {
  2448. p5UI__notifyAjaxCallback(data);
  2449. priv.showFailFetchDataMsg();
  2450. }
  2451. return null;
  2452. }).then(function (data) {
  2453. if (priv.options.debug || DBG) console.log('loadDataAjax:fetch:update: request finished data:', data);
  2454. if (!data) return;
  2455. if (data && data.cols) {
  2456. priv.setStateCols(data.cols, data.primaryKey);
  2457. }
  2458. // assign the new state (data)
  2459. state = {data: {}};
  2460. if (!skipCols) state.data.cols = data.cols || {};
  2461. state.data.rows = data.rows || [];
  2462. state.data.total = data.total || 0;
  2463. state.data.primaryKey = data.primaryKey || 'ID';
  2464. state.page = data.page || 0;
  2465. state.pageSize = data.pageSize || priv.options.pageSize;
  2466. state.filters = data.filters || {};
  2467. DBG && console.warn('DBG:update... - FETCH_DATA END priv.setState(state);', { state });
  2468. if (SKIP_TOTAL) _state.isLoadingTotal = true;
  2469. priv.setState(state);
  2470. if (SKIP_TOTAL) priv.asyncFetchTotal((priv.options.url + initUrlAdd).replace('SKIP_TOTAL=1', 'ONLY_TOTAL=1'))
  2471. if (typeof callback == "function") {
  2472. callback.call(this);
  2473. }
  2474. }).catch(function (e) {
  2475. console.log('loadDataAjax:fetch: ERR:', e);
  2476. });
  2477. };
  2478. /*
  2479. assigns the new data.
  2480. */
  2481. priv.setState = function(state) {
  2482. var oldState = _state; // TODO: use to check what really changed (use extend!)
  2483. var renderParts = {};
  2484. if (state.data) {
  2485. if (state.data.cols && Object.keys(state.data.cols).length > 0) {
  2486. priv.setStateCols(state.data.cols, state.data.primaryKey);
  2487. priv.setStateData(state.data);
  2488. } else {
  2489. priv.setStateData(state.data);
  2490. }
  2491. renderParts['body'] = true;
  2492. renderParts['foot_pagination'] = true;
  2493. }
  2494. if (state.hasOwnProperty('specialFilters')) {
  2495. _state.specialFilters = state.specialFilters;
  2496. renderParts['head__specialFilters'] = true;
  2497. }
  2498. if (state.hasOwnProperty('page')) {
  2499. if (state.page != _state.page) {
  2500. _state.page = state.page;
  2501. renderParts['foot_pagination'] = true;
  2502. }
  2503. }
  2504. if (state.hasOwnProperty('pageSize')) {
  2505. if (state.pageSize != _state.pageSize) {
  2506. _state.pageSize = state.pageSize;
  2507. renderParts['foot_pagination'] = true;
  2508. }
  2509. }
  2510. if (state.hasOwnProperty('filters')) {
  2511. renderParts['head__specialFilters'] = true;
  2512. renderParts['foot_pagination'] = true;
  2513. }
  2514. renderParts = Object.keys(renderParts);
  2515. if (renderParts.length > 0) {
  2516. DBG && console.log('DBG::trigger(TableAjax:render): ', renderParts);
  2517. jQuery(_uiNodeCont).trigger('TableAjax:render', renderParts);
  2518. }
  2519. };
  2520. priv.setStateCols = function(cols, primaryKey) {
  2521. if (priv.options.debug || DBG) console.log('priv.setStateCols: ', {primaryKey: primaryKey, cols: cols});
  2522. // console.log("priv.setStateCols");
  2523. // console.trace();
  2524. _state.cols = cols;
  2525. _state.primaryKey = primaryKey || _state.primaryKey;
  2526. // fix col name - props.column
  2527. $.each(_state.cols, function(col, props) {
  2528. props.column = col;
  2529. });
  2530. // fix col types - default 'string'
  2531. $.each(_state.cols, function(col, props) {
  2532. if (!props.type) cols[col].type = "string";
  2533. });
  2534. // fix props.filter - set true if not set - TODO: allow filter this col?
  2535. $.each(_state.cols, function(col, props) {
  2536. if (props.filter == undefined) props.filter = true;
  2537. });
  2538. if (_state.primaryKey) {
  2539. //create a unique column definition
  2540. _state.cols["unique"] = {
  2541. column: "unique",
  2542. type: "unique",
  2543. index: -1,
  2544. hidden: true
  2545. };
  2546. }
  2547. _state.colsSorted = Object.keys(_state.cols).sort(function(a, b) {
  2548. return _state.cols[a].index - _state.cols[b].index;
  2549. });
  2550. };
  2551. priv.setStateData = function(pData) {
  2552. var listPrimaryKeys = (pData && pData.rows && pData.rows.length)
  2553. ? pData.rows.map(function (item) {
  2554. return item['@primaryKey'];
  2555. })
  2556. : []
  2557. ;
  2558. jQuery(_uiNodeCont).trigger('TableAjax:updateRows', { primaryKeys: listPrimaryKeys });
  2559. if (priv.options.checkboxes) {
  2560. priv.options.selectedStore.dispatch( priv.options.selectedActions.setPrimaryKeys(priv.options.namespace, listPrimaryKeys) );
  2561. }
  2562. var data = $.extend(true, {}, pData);
  2563. data.cols = _state.cols;// always use old cols - change cols mved to priv.setStateCols
  2564. _data = data;
  2565. _data.rowsOrg = _data.rows;
  2566. };
  2567. /*
  2568. helper that returns the underlying data by the unique value
  2569. */
  2570. priv.getRow = function(uniqueValue) {
  2571. var row;
  2572. $.each(_data.rowsOrg, function(i, r) {
  2573. if (r[_state.primaryKey] == uniqueValue) {
  2574. row = r;
  2575. return false;
  2576. }
  2577. });
  2578. return row;
  2579. };
  2580. priv.longTextChanged = function(e) {
  2581. priv.options.longDesc = !priv.options.longDesc;
  2582. _bodyNode.find('td').each(function(ind, el){
  2583. var $el = jQuery(el);
  2584. if (!$el.attr('class') || $el.attr('class') == 'tbl-short-txt') {
  2585. if (el.firstChild && el.firstChild.nodeName == 'SPAN') {
  2586. if (priv.options.longDesc) {
  2587. $el.addClass('tbl-short-txt');
  2588. var $elSpan = jQuery(el.firstChild);
  2589. $elSpan.tooltip({title: $elSpan.text(), placement: 'left'});
  2590. } else {
  2591. $el.removeClass('tbl-short-txt');
  2592. }
  2593. }
  2594. }
  2595. });
  2596. return false;
  2597. };
  2598. priv.mapEditorHide = function() {
  2599. priv.options.mapEditor = false;
  2600. if ('window' == priv.options.mapEditorContainer) {
  2601. //_mapEditorDialog.dialog("close");
  2602. _mapEditorDialog.dialog("destroy");
  2603. }
  2604. _mapEditorWrap.hide();
  2605. _mapEditor.hide();
  2606. };
  2607. priv.mapEditorShow = function() {
  2608. //console.log('TODO:mapEditorShow():', priv.options.mapEditorContainer, 'visible:', priv.options.mapEditor);
  2609. priv.options.mapEditor = true;
  2610. _mapEditor.show();
  2611. _mapEditorWrap.show();
  2612. _mapEditor.TableAjaxMap({
  2613. //debug: true,
  2614. wpsUrl: 'http://biuro.biall-net.pl/wps',
  2615. wfsUrl: 'http://biuro.biall-net.pl/wps',
  2616. showAddLayerWidget: (priv.options.hasAdditionalLayers) ? true : false,
  2617. zoomStrategyActivate: 14,
  2618. layerName: priv.options.labelHtml,
  2619. addBtn: {
  2620. title: 'Przenieś mapę do okna',
  2621. displayClass: 'mapEditor-btnBackToWindow',
  2622. trigger: function() {
  2623. priv.mapEditorHide();
  2624. priv.options.mapEditorContainer = 'window';
  2625. priv.mapEditorShow();
  2626. priv.resizableMapDockNode('destroy');
  2627. }
  2628. },
  2629. onSaveFeature: function(selectedRecordId, selectedFeatureExtent) {
  2630. if (priv.options.debug || DBG) console.log('onSaveFeature (',selectedRecordId,'/',selectedFeatureExtent,') ', this);
  2631. if (!selectedRecordId) {
  2632. alert('Brak zaznaczonego rekordu - wybierz rekord z tabeli');
  2633. return;
  2634. }
  2635. function notifyAjaxCallback(data) {
  2636. var notify = {};
  2637. notify.type = (data && data.type)? data.type : '';
  2638. notify.msg = (data && data.msg)? data.msg : '';
  2639. switch (notify.type) {
  2640. case 'success':
  2641. if (!notify.msg) notify.msg = 'Aktualizacja danych dla rekordu ' + selectedRecordId;
  2642. break;
  2643. case 'info':
  2644. if (!notify.msg) notify.msg = 'Nie wprowadzono żadnych zmian';
  2645. break;
  2646. case 'error':
  2647. if (!notify.msg) notify.msg = 'Wystąpiły błędy';
  2648. break;
  2649. case 'warning':
  2650. notify.type = 'warn';
  2651. if (!notify.msg) notify.msg = 'Wystąpiły błędy';
  2652. break;
  2653. default:
  2654. notify.msg = 'Nieznany błąd';
  2655. if (data && data.errorCode) notify.msg += ' ' + data.errorCode;
  2656. notify.type = '';
  2657. }
  2658. jQuery.notify(notify.msg, notify.type);
  2659. }
  2660. $.ajax({
  2661. data: {polygon: selectedFeatureExtent},
  2662. dataType: 'json',
  2663. type: "POST",
  2664. url: priv.options.theGeomSaveUrl + '&ID=' + selectedRecordId
  2665. })
  2666. .done(function(data, textStatus, jqXHR){
  2667. notifyAjaxCallback(data);
  2668. //jQuery.notify('Aktualizacja danych dla rekordu ' + selectedRecordId, 'success');
  2669. publ.loadPage(0);// TODO: reload table data
  2670. })
  2671. .fail(function(jqXHR){// jqXHR.fail(function( jqXHR, textStatus, errorThrown ) {});
  2672. if (jqXHR.responseJSON) {
  2673. notifyAjaxCallback(jqXHR.responseJSON);
  2674. }
  2675. else {
  2676. var txt = jqXHR.responseText || 'Wystąpiły błędy';
  2677. if (jqXHR.status == 404) {
  2678. jQuery.notify(jqXHR.responseText, 'error');
  2679. } else {
  2680. jQuery.notify(jqXHR.responseText, 'warn');
  2681. }
  2682. }
  2683. });
  2684. },
  2685. onSelectBox: function(bounds) {
  2686. if (undefined !== OpenLayers.Bounds && bounds instanceof OpenLayers.Bounds) {
  2687. var column = 'the_geom';
  2688. var filter = 'BBOX:' + bounds.top + ',' + bounds.right + ',' + bounds.bottom + ',' + bounds.left;
  2689. priv.options.filterStore.dispatch( priv.options.filterActions.setFilter(column, filter) )
  2690. }
  2691. }
  2692. });
  2693. priv.mapEditorShowElement();
  2694. };
  2695. priv.mapEditorShowElement = function() {
  2696. if ('window' == priv.options.mapEditorContainer) {
  2697. var mapEditor = _mapEditorWrap.children('.mapEditor-map');
  2698. if (!mapEditor || !mapEditor.length) {
  2699. var tblCont = jQuery(_uiNodeCont).parent('.AjaxTableCont');
  2700. var mapEditor = tblCont.children('.AjaxTableCont-mapEditorContainer').children('.mapEditor-map');
  2701. if (!mapEditor || !mapEditor.length) {
  2702. // TODO: create new map
  2703. }
  2704. _mapEditorWrap.append(mapEditor);
  2705. }
  2706. _mapEditorWrap.css({padding:'5px'});
  2707. _mapEditorDialog = _mapEditorWrap.dialog({
  2708. width: 540,
  2709. minWidth: 400,
  2710. minHeight: 400,
  2711. open: function(e, ui) {
  2712. var n = jQuery(this),
  2713. mapWrap = n.children(":first"),
  2714. map = mapWrap.children(":first");
  2715. map.css({width: n.width() - 5, height: n.height() - 5});
  2716. _mapEditor.TableAjaxMapUpdateSize();
  2717. },
  2718. resizeStart: function(e, ui) {
  2719. jQuery(this).children(":first").children(":first").css({display:'none'});
  2720. },
  2721. resizeStop: function(e, ui){
  2722. var n = jQuery(this),
  2723. map = n.children(":first").children(":first");
  2724. n.css({width: n.parent().width()});
  2725. map.css({display: 'block', height: n.height(), width: n.width()});
  2726. _mapEditor.TableAjaxMapUpdateSize();
  2727. },
  2728. dragStop: function(e, ui){
  2729. _mapEditor.TableAjaxMapUpdateSize();// to prevent drag-zoom error
  2730. }
  2731. });
  2732. _mapEditorWrap.bind('dialogclose', function(e) {
  2733. priv.options.mapEditor = false;
  2734. });
  2735. var dialogTitleBar = _mapEditorDialog.parent().parent().find('.ui-dialog-titlebar');
  2736. var dialogTitleBarCloseBtn = dialogTitleBar.find('.ui-dialog-titlebar-close');
  2737. if (dialogTitleBarCloseBtn) {
  2738. var btnToggle = jQuery('<span style="width:18px;height:18px;position:absolute;top:50%;right:25px;margin-top:-9px;" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-icon-only"><i style="margin-top:3px;" class="glyphicon glyphicon-fullscreen"></i></span>');
  2739. btnToggle.on('click', function(e) {
  2740. priv.options.mapEditorContainer = 'dock';
  2741. _mapEditorWrap.dialog('close');
  2742. priv.mapEditorShowElement();
  2743. });
  2744. btnToggle.insertBefore(dialogTitleBarCloseBtn);
  2745. }
  2746. }
  2747. else if ('dock' == priv.options.mapEditorContainer) {
  2748. priv.resizableMapDockNode('prepare');
  2749. _mapEditor.TableAjaxMapUpdateSize();
  2750. }
  2751. };
  2752. priv.resizableMapDockNode = function(task) {
  2753. if ('prepare' == task) {
  2754. var mapEditor = _mapEditorWrap.children('.mapEditor-map');
  2755. if (mapEditor && mapEditor.length) {// map is inside _mapEditorWrap (window)
  2756. var mapDockNode = jQuery('<div class="AjaxTableCont-mapEditorContainer"></div>');
  2757. var tblCont = jQuery(_uiNodeCont).parent('.AjaxTableCont');
  2758. tblCont.children('.AjaxTableCont-mapEditorContainer').remove();
  2759. var breadcrumb = tblCont.children('.breadcrumb');
  2760. if (!breadcrumb || !breadcrumb.length) {
  2761. tblCont.prepend(mapDockNode);
  2762. } else {
  2763. mapDockNode.insertAfter(breadcrumb);
  2764. }
  2765. mapDockNode.append(mapEditor);
  2766. }
  2767. var mapDockResizable = mapEditor.parent();
  2768. mapDockResizable.resizable({handles: 's', minHeight: 300, minWidth: 300});
  2769. var resizeLineHeigth = 6;
  2770. mapDockResizable.children(":first").css({height: 'auto'});
  2771. mapDockResizable.css({marginBottom: resizeLineHeigth+'px'});
  2772. mapEditor.css({marginBottom: resizeLineHeigth+'px'});
  2773. mapEditor.children(":first").css({width: mapEditor.width()});
  2774. mapDockResizable.find('.ui-resizable-s').css({height:resizeLineHeigth+'px', bottom: '-'+resizeLineHeigth+'px'});
  2775. mapDockResizable.on('resizestart', function(event, ui) {
  2776. ui.element.children(":first").children(":first").css({display:'none'})
  2777. });
  2778. mapDockResizable.on('resizestop', function(event, ui) {
  2779. ui.element.children(":first").children(":first").css({display:'block', height: ui.element.height()});
  2780. });
  2781. } else if ('destroy' == task) {
  2782. var mapDockResizable = jQuery(_uiNodeCont).parent('.AjaxTableCont').children('.AjaxTableCont-mapEditorContainer');
  2783. mapDockResizable.resizable('destroy');
  2784. mapDockResizable.remove();
  2785. }
  2786. };
  2787. priv.mapEditorChanged = function(e) {
  2788. if (priv.options.debug || DBG) console.log('mapEditorChanged option(',priv.options.mapEditor,')');
  2789. priv.options.mapEditor = !priv.options.mapEditor;
  2790. if (priv.options.mapEditor) {
  2791. priv.mapEditorShow();
  2792. }
  2793. else {
  2794. priv.mapEditorHide();
  2795. }
  2796. return false;
  2797. };
  2798. /*
  2799. when: changing page in pager
  2800. what: triggers table to be created with new page
  2801. */
  2802. priv.pageChanged = function(e) {
  2803. e.preventDefault();
  2804. var totalPages = Math.ceil(_data.total / _state.pageSize);
  2805. if (_state.isLoadingTotal) {
  2806. var fromRow = Math.max(_state.page - 1, 0) * _state.pageSize;
  2807. var renderedRowsCount = Math.min(_data.rows.length, _state.pageSize);
  2808. var toRow = fromRow + renderedRowsCount;
  2809. var total = toRow;
  2810. if (_state.isLoadingTotal && renderedRowsCount === _state.pageSize) {
  2811. totalPages = Math.ceil(total / _state.pageSize) + 1; // allow load next page
  2812. }
  2813. }
  2814. DBG && console.warn('DBG:priv.pageChanged:?', { loadPage: e.data.pageIndex, totalPages });
  2815. if (e.data.pageIndex < 1 || e.data.pageIndex > totalPages) return;
  2816. //set the new page
  2817. _state.page = e.data.pageIndex;
  2818. DBG && console.warn('DBG:priv.pageChanged:', { loadPage: e.data.pageIndex });
  2819. publ.loadPage(_state.page);
  2820. };
  2821. /*
  2822. when: changing pagesize in pagesize dropdown
  2823. what: triggers table to be created with new pagesize
  2824. */
  2825. priv.pageSizeChanged = function(e) {
  2826. e.preventDefault();
  2827. var val = $(this).text();
  2828. if (priv.options.debug || DBG) console.log(p5Utils__format('pagesize changed to:{0}', [val]));
  2829. if (parseInt(val) == priv.options.pageSize) {
  2830. return false;
  2831. }
  2832. priv.options.pageSize = parseInt(val);
  2833. publ.loadPage(1, priv.options.pageSize);
  2834. jQuery(_uiNodeCont).trigger('TableAjax:render', ['body', 'foot_pagination']);
  2835. priv.saveProfilePageSize(priv.options.pageSize);
  2836. };
  2837. /*
  2838. when: clicking a column
  2839. what: triggers table to be sorted by the column
  2840. */
  2841. priv.columnClicked = function(e) {
  2842. e.preventDefault();
  2843. if (priv.options.debug || DBG) console.log(p5Utils__format('col:{0} clicked', [e.data.column]));
  2844. priv.options.filterStore.dispatch( priv.options.filterActions.toggleSort(e.data.column) )
  2845. };
  2846. priv.saveProfilePageSize = function(pageSize) {
  2847. var reqData = {};
  2848. reqData.pageSize = pageSize;
  2849. $.ajax({
  2850. data: reqData,
  2851. type: "POST",
  2852. dataType: 'json',
  2853. // async: true,
  2854. url: priv.options.pageSizeSave
  2855. })
  2856. .done(function(data, textStatus, jqXHR){
  2857. if (data && data.type && data.type == 'info') {
  2858. jQuery.notify('Nie wprowadzono żadnych zmian', 'info');
  2859. } else {
  2860. jQuery.notify('Zapisano ustawienia', 'success');
  2861. }
  2862. })
  2863. .fail(function(){
  2864. jQuery.notify('Wystąpił błąd podczas zapisywania ustawień', 'error');
  2865. });
  2866. };
  2867. priv.saveHiddenCols = function() {
  2868. var reqData = {};
  2869. $.each(_data.cols, function(col, props) {
  2870. if (props.type != "unique" && col != 'unique' && col != _state.primaryKey) {
  2871. reqData[col] = (props.hidden)? 'HIDE' : 'SHOW';
  2872. }
  2873. });
  2874. $.ajax({
  2875. data: reqData,
  2876. type: "POST",
  2877. dataType: 'json',
  2878. // async: true,
  2879. url: priv.options.hiddenColsSaveUrl
  2880. })
  2881. .done(function(data, textStatus, jqXHR){
  2882. if (data && data.type && data.type == 'info') {
  2883. jQuery.notify('Nie wprowadzono żadnych zmian', 'info');
  2884. } else {
  2885. jQuery.notify('Zapisano ustawienia', 'success');
  2886. }
  2887. })
  2888. .fail(function(){
  2889. jQuery.notify('Wystąpił błąd podczas zapisywania ustawień', 'error');
  2890. });
  2891. };
  2892. /*
  2893. when: clicking a column in columnpicker
  2894. what: triggers table to show/hide the column
  2895. */
  2896. priv.columnPickerClicked = function(e) {
  2897. e.stopPropagation();
  2898. var column = $(this).val();
  2899. //toggle column visibility
  2900. priv.modelColFilter_toggleColumn(column);
  2901. priv.saveHiddenCols();
  2902. //_data.cols[column].index = new priv.ext.XDate();
  2903. jQuery(_uiNodeCont).trigger('TableAjax:render', ['head', 'body']);
  2904. };
  2905. priv.modelColFilter_init = function() {// run only once, set _state._modelColFilter {selected, filters: [ {name, label, visibleCols} ]}
  2906. var isAllSelected = true;
  2907. if (undefined === _state._modelColFilter) {
  2908. var columnFilters = [];
  2909. {
  2910. var fltrAll = {'name': 'all', 'label': 'Wszystkie', visibleCols: []};
  2911. $.each(_data.cols, function(col, props) {
  2912. if ("unique" == props.type) return;
  2913. fltrAll.visibleCols.push(col);
  2914. if (_data.cols[col].hidden) isAllSelected = false;
  2915. });
  2916. columnFilters.push(fltrAll);
  2917. }
  2918. // {
  2919. // var fltrMostUsed = {'name': 'most_used', 'label': 'Najczęściej używane', visibleCols: []};
  2920. // var fltrMostUsedLimit = 10;
  2921. // $.each(_data.cols, function(col, props) {
  2922. // if ("unique" == props.type) return;
  2923. // if (fltrMostUsedLimit-- > 0) {
  2924. // fltrMostUsed.visibleCols.push(col);
  2925. // }
  2926. // });
  2927. // columnFilters.push(fltrMostUsed);
  2928. // }
  2929. _state._modelColFilter = {
  2930. selected: (isAllSelected)? 'all' : null,
  2931. filters: columnFilters,
  2932. saveBtn: $('<button class="btn btn-xs btn-primary" disabled="disabled">Zapisz widoczne kolumny</button>')
  2933. };
  2934. _state._modelColFilter.saveBtn.on('click', priv.modelColFilter_saveBtnClicked)
  2935. if (priv.options.userTableFilterUrl) {
  2936. window.fetch(priv.options.userTableFilterUrl, {
  2937. method: 'POST',
  2938. headers: {
  2939. 'Content-Type': 'application/json'
  2940. },
  2941. credentials: 'same-origin',// add cookies
  2942. body: JSON.stringify({
  2943. namespace: priv.options.namespace,
  2944. })
  2945. }).then(function (response) {
  2946. return response.json()
  2947. }).then(function (result) {
  2948. if ('success' == result.type) {
  2949. // p5UI__notifyAjaxCallback(result)
  2950. _state._modelColFilter.filters = _state._modelColFilter.filters.filter(function (filter) {
  2951. return ('all' === filter.name || 'most_used' == filter.name)
  2952. }).concat(Object.keys(result.data).map(function (fltr) {
  2953. return {
  2954. name: fltr,
  2955. label: fltr,
  2956. visibleCols: result.data[fltr].split(',')
  2957. }
  2958. }))
  2959. jQuery(_uiNodeCont).trigger('TableAjax:render', ['foot__columnPicker']);
  2960. } else {
  2961. p5UI__notifyAjaxCallback(result)
  2962. }
  2963. }).catch(function (e) {
  2964. // TODO: show error ("ajax response error: " + e)
  2965. });
  2966. }
  2967. }
  2968. };
  2969. priv.modelColFilter_onClickRemoveFilter = function (e) {
  2970. e.preventDefault()
  2971. e.stopPropagation()
  2972. var filtrName = $(this).data('col_filter')
  2973. if (!filtrName) return
  2974. window.fetch(priv.options.rmUserTableFilterAjaxUrl, {
  2975. method: 'POST',
  2976. headers: {
  2977. 'Content-Type': 'application/json'
  2978. },
  2979. credentials: 'same-origin',// add cookies
  2980. body: JSON.stringify({
  2981. namespace: priv.options.namespace,
  2982. filtrName: filtrName,
  2983. })
  2984. }).then(function (response) {
  2985. return response.json()
  2986. }).then(function (result) {
  2987. if ('success' == result.type) {
  2988. p5UI__notifyAjaxCallback(result)
  2989. var userTableFilters = result.data;// resolve(result.data)
  2990. _state._modelColFilter.filters = _state._modelColFilter.filters.filter(function (filter) {
  2991. return ('all' === filter.name || 'most_used' == filter.name)
  2992. }).concat(Object.keys(userTableFilters).map(function (fltr) {
  2993. return {
  2994. name: fltr,
  2995. label: fltr,
  2996. visibleCols: userTableFilters[fltr].split(',')
  2997. }
  2998. }))
  2999. jQuery(_uiNodeCont).trigger('TableAjax:render', ['foot__columnPicker']);
  3000. } else {
  3001. p5UI__notifyAjaxCallback(result)
  3002. }
  3003. }).catch(function (e) {
  3004. p5UI__notifyAjaxCallback({ type: 'error', msg: new String(e) })
  3005. });
  3006. };
  3007. priv.modelColFilter_saveBtnClicked = function (e) {
  3008. swal({
  3009. title: 'Zapisz widoczne kolumny',
  3010. html: '',
  3011. animation: true,
  3012. input: 'text',
  3013. inputPlaceholder: 'nazwa filtra',
  3014. // inputValue: null,
  3015. // inputAttributes: {'step': '0.01'},
  3016. showCancelButton: true,
  3017. confirmButtonText: 'Zapisz',
  3018. showLoaderOnConfirm: true,
  3019. showCloseButton: true,
  3020. preConfirm: function(filtrName) {
  3021. return new Promise(function(resolve, reject) {
  3022. if (!filtrName) reject('Proszę podać nazwę filtra')
  3023. if (filtrName.length > 255) reject('Nazwa za długa')
  3024. window.fetch(priv.options.addUserTableFilterAjaxUrl, {
  3025. method: 'POST',
  3026. headers: {
  3027. 'Content-Type': 'application/json'
  3028. },
  3029. credentials: 'same-origin',// add cookies
  3030. body: JSON.stringify({
  3031. namespace: priv.options.namespace,
  3032. filtrName: filtrName,
  3033. visibleCols: Object.keys(_data.cols).filter(function(col) {
  3034. return !_data.cols[col].hidden
  3035. }).join(','),
  3036. })
  3037. }).then(function (response) {
  3038. return response.text()
  3039. }).then(function (responseText) {
  3040. try {
  3041. // json = response.json() // BUG: error trafia do catch promisów, zamiast aktualnego bloku
  3042. // -- obiekt response pewnie jest powiązany z Promisem z fetch
  3043. // -- response.json() zwraca Promise tak samo jak response.text()
  3044. return JSON.parse(responseText)
  3045. } catch (e) {
  3046. throw responseText
  3047. }
  3048. }).then(function (result) {
  3049. if ('success' == result.type) {
  3050. p5UI__notifyAjaxCallback(result)
  3051. resolve(result.data)
  3052. } else {
  3053. p5UI__notifyAjaxCallback(result)
  3054. reject(result.msg || "Wystąpił błąd!")
  3055. }
  3056. }).catch(function (e) {
  3057. reject("ajax response error: " + e)
  3058. });
  3059. })
  3060. },
  3061. allowOutsideClick: false
  3062. }).then(function(userTableFilters) {
  3063. _state._modelColFilter.filters = _state._modelColFilter.filters.filter(function (filter) {
  3064. return ('all' === filter.name || 'most_used' == filter.name)
  3065. }).concat(Object.keys(userTableFilters).map(function (fltr) {
  3066. return {
  3067. name: fltr,
  3068. label: fltr,
  3069. visibleCols: userTableFilters[fltr].split(',')
  3070. }
  3071. }))
  3072. jQuery(_uiNodeCont).trigger('TableAjax:render', ['head', 'body', 'foot__columnPicker']);
  3073. }).catch(function(e) {
  3074. // eg. hit Cancel
  3075. })
  3076. }
  3077. priv.modelColFilter_getSaveBtn = function () {
  3078. priv.modelColFilter_init();
  3079. return _state._modelColFilter.saveBtn
  3080. }
  3081. priv.modelColFilter_getFilters = function() {
  3082. priv.modelColFilter_init();
  3083. return _state._modelColFilter.filters;
  3084. };
  3085. priv.modelColFilter_getSelected = function() {
  3086. priv.modelColFilter_init();
  3087. return _state._modelColFilter.selected;
  3088. };
  3089. priv.modelColFilter_setFilter = function(filterKey) {
  3090. priv.modelColFilter_init();
  3091. _state._modelColFilter.selected = filterKey;
  3092. priv.modelColFilter_uiUncheckAllColFilters();
  3093. priv.modelColFilter_uiCheckColFilter(filterKey);
  3094. };
  3095. priv.modelColFilter_toggleColumn = function(column, value) {
  3096. priv.modelColFilter_init();
  3097. _state._modelColFilter.selected = null;
  3098. if (!_data.cols[column] || !_data.cols[column]) return;
  3099. _data.cols[column].hidden = (undefined !== value)? value : !_data.cols[column].hidden;
  3100. priv.modelColFilter_uiUncheckAllColFilters();
  3101. {
  3102. var isAllSelected = true;
  3103. $.each(_data.cols, function(col, props) {
  3104. if ("unique" == props.type) return;
  3105. if (_data.cols[col].hidden) isAllSelected = false;
  3106. });
  3107. if (isAllSelected) {
  3108. _state._modelColFilter.selected = 'all';
  3109. priv.modelColFilter_uiCheckColFilter('all');
  3110. }
  3111. }
  3112. };
  3113. priv.modelColFilter_uiUncheckAllColFilters = function() {
  3114. var nodeClass = 'tblAjax__' + 'footer__toolbar__columnPicker',
  3115. currentNode = $(_uiNodeCont).next('.foot').find('.' + nodeClass)
  3116. ;
  3117. currentNode.find('input[type="radio"]').prop("checked", false);
  3118. };
  3119. priv.modelColFilter_uiCheckColFilter = function(filterKey) {
  3120. var nodeClass = 'tblAjax__' + 'footer__toolbar__columnPicker',
  3121. currentNode = $(_uiNodeCont).next('.foot').find('.' + nodeClass)
  3122. ;
  3123. currentNode.find('input[type="radio"]').each(function(idx, input) {
  3124. var input$ = jQuery(input);
  3125. if (filterKey == jQuery(input$).parent().data('col_filter')) {
  3126. input$.prop("checked", true);
  3127. } else {
  3128. input$.prop("checked", false);
  3129. }
  3130. });
  3131. };
  3132. priv.columnPickerLinkClicked = function(e) {
  3133. e.stopPropagation();
  3134. var input$ = $(this).find('input'),
  3135. col_filter = $(this).data('col_filter'),
  3136. columnFilters = priv.modelColFilter_getFilters()
  3137. ;
  3138. if (col_filter) {
  3139. var filter = null;
  3140. $.each(columnFilters, function(idx, colFltr) {
  3141. if (col_filter == colFltr.name) {
  3142. filter = colFltr;
  3143. }
  3144. });
  3145. if (!filter) return;
  3146. $.each(_data.cols, function(col, props) {
  3147. var isHidden = (-1 === filter.visibleCols.indexOf(col));
  3148. priv.modelColFilter_toggleColumn(col, isHidden);
  3149. });
  3150. priv.modelColFilter_setFilter(col_filter);
  3151. priv.saveHiddenCols();
  3152. jQuery(_uiNodeCont).trigger('TableAjax:render', ['head', 'body', 'foot__columnPicker']);
  3153. } else {
  3154. e.preventDefault();
  3155. if (input$.length != 1) return;
  3156. var column = input$.val();
  3157. if (!column) return;
  3158. //toggle column visibility
  3159. priv.modelColFilter_toggleColumn(column);
  3160. input$.prop("checked", !input$.is(':checked'));// update view
  3161. priv.saveHiddenCols();
  3162. //_data.cols[column].index = new priv.ext.XDate();
  3163. jQuery(_uiNodeCont).trigger('TableAjax:render', ['head', 'body']);
  3164. }
  3165. };
  3166. priv.columnHideClicked = function(e) {
  3167. e.stopPropagation();
  3168. var column;
  3169. if (e.data && e.data.column) {
  3170. column = e.data.column;
  3171. } else {
  3172. return;
  3173. }
  3174. //toggle column visibility
  3175. priv.modelColFilter_toggleColumn(column);
  3176. priv.saveHiddenCols();
  3177. //_data.cols[column].index = new priv.ext.XDate();
  3178. jQuery(_uiNodeCont).trigger('TableAjax:render', ['head', 'body', 'foot__columnPicker']);
  3179. };
  3180. /*
  3181. when: clicking anywhere on a row
  3182. what: row data and other info is returned to caller
  3183. */
  3184. // priv.rowClicked = function(e) {// TODO: not used
  3185. // if (!_state.primaryKey) {
  3186. // if (priv.options.debug || DBG) console.log('no unique column specified');
  3187. // return;
  3188. // }
  3189. //
  3190. // //gather callback data
  3191. // var elem = $(this);
  3192. // var column = _data.cols[elem.data('column')];
  3193. // var unique = elem.closest('tr').data('unique');
  3194. // var row = priv.getRow(unique);
  3195. // var isChecked = elem.closest('tr').find('.unique').is(':checked');
  3196. //
  3197. // //trigger callback
  3198. // if (typeof priv.options.rowClicked == 'function') {
  3199. // priv.options.rowClicked.call(e.target, {
  3200. // event: e,
  3201. // row: row,
  3202. // column: column,
  3203. // checked: isChecked
  3204. // });
  3205. // }
  3206. // };
  3207. /**
  3208. * Inline edit.
  3209. */
  3210. priv.rowDblClicked = function(e) {
  3211. var inlineEditBox$Node = $(_uiNodeCont).parent().children('.tblAjax__inlineEditBox');
  3212. // hide popover for typespecial fld on click
  3213. if (_popoverCellCurrent) {
  3214. _popoverCellCurrent.popover('hide');
  3215. }
  3216. // e.clientX: 1002; e.clientY: 245
  3217. if ('id' in e.data && 'col' in e.data && e.data.id > 0) {
  3218. inlineEditBox$Node.modal();
  3219. inlineEditBox$Node.show();
  3220. inlineEditBox$Node.on('shown.bs.modal', function(e) {
  3221. var dialogBox = jQuery(this).find('.modal-dialog'),
  3222. modalBody = dialogBox.find('.modal-body'),
  3223. boudingRect = dialogBox.get(0).getBoundingClientRect();
  3224. dialogBox.css({position: 'absolute', margin:0, top: boudingRect.top, left: boudingRect.left});
  3225. modalBody.css({overflow: 'scroll'});
  3226. dialogBox.resizable({minHeight: 300, minWidth: 300, alsoResize: modalBody});
  3227. dialogBox.draggable({handle: '.modal-header'});
  3228. });
  3229. inlineEditBox$Node.on('hidden.bs.modal', function(e) {
  3230. var dialogBox = jQuery(this).find('.modal-dialog'),
  3231. modalBody = dialogBox.find('.modal-body');
  3232. dialogBox.removeAttr('style');
  3233. modalBody.removeAttr('style');
  3234. modalBody.css({padding: '0'});
  3235. dialogBox.resizable();
  3236. dialogBox.draggable();
  3237. dialogBox.resizable('destroy');
  3238. dialogBox.draggable('destroy');
  3239. });
  3240. inlineEditBox$Node.find('input[name=ID]').val(e.data.id);
  3241. inlineEditBox$Node.find('input[name=col]').val(e.data.col);
  3242. inlineEditBox$Node.find('.inlineEditBox-cnt').html('<span class="loading-info"> loading ...</span>');
  3243. $.ajax({
  3244. url: priv.options.editInlineUrl + '&ID=' + e.data.id + '&col=' + e.data.col,
  3245. type: 'GET',
  3246. dataType: 'json',
  3247. success: function(data) {
  3248. if ('p5:www_link' == _.get(data, 'simpleType')) {
  3249. inlineEditBox$Node.find('.inlineEditBox-cnt').empty();
  3250. var label = jQuery('<label>');// for="' + data.htmlFieldName + '">');// "<label for="f22579" class="AjaxTableEdit-label"> ... </label>
  3251. label.attr('for', data.htmlFieldName);
  3252. label.attr('class', 'AjaxTableEdit-label');
  3253. inlineEditBox$Node.find('.inlineEditBox-cnt').append(label);
  3254. var inLabel = jQuery('<strong title="[' + data.idZasob + '] ' + data.fieldLabel + '">' + data.fieldLabel + '</strong>');
  3255. label.append(inLabel);
  3256. var frmItem = jQuery('<input>');
  3257. frmItem.attr('type', 'text');
  3258. frmItem.attr('name', data.htmlFieldName);
  3259. frmItem.attr('value', data.formItem.value);
  3260. frmItem.attr('maxlength', _.get(data, 'restrictions.maxLength', 255));
  3261. frmItem.attr('style', 'width:98%');
  3262. frmItem.attr('class', 'form-control');
  3263. frmItem.insertAfter(label);
  3264. } else {
  3265. var content = _.get(data, 'legacy_html', "Nieznany błąd");
  3266. inlineEditBox$Node.find('.inlineEditBox-cnt').html(content);
  3267. }
  3268. inlineEditBox$Node.find('.btn-save').show();
  3269. initDateTimePicker(inlineEditBox$Node);
  3270. inlineEditBox$Node.find('textarea').autosize();
  3271. var fld = inlineEditBox$Node.find('input[name^="f"]');
  3272. if (fld.length > 0 && !fld.hasClass('se_type-date')) {
  3273. fld.keydown(function(event) {
  3274. if (event.which == 13) {
  3275. event.preventDefault();
  3276. inlineEditBox$Node.find('form').submit();
  3277. }
  3278. });
  3279. }
  3280. (function setFocusAtFirstInlineEditFormFld(modal$node){
  3281. var fld, dbg = false;
  3282. if(dbg)console.log('focus...');
  3283. fld = modal$node.find('input[name^="f"]:first');
  3284. if (fld.length > 0 && !fld.hasClass('se_type-date')) {
  3285. if(dbg)console.log('set focus to first input element');
  3286. fld.focus(); return;
  3287. }
  3288. fld = modal$node.find('select[name^="f"]:first');
  3289. if (fld.length) {
  3290. if (fld.get(0).selectize) {
  3291. if(dbg)console.log('set focus to first typepecial element');
  3292. } else {
  3293. if(dbg)console.log('set focus to first select element');
  3294. fld.focus(); return;
  3295. }
  3296. }
  3297. if(dbg)console.log('set focus to close btn');
  3298. modal$node.find('.btn-close').focus();
  3299. })(inlineEditBox$Node);
  3300. },
  3301. error: function(err) {
  3302. if (priv.options.debug || DBG) console.log('err');
  3303. }
  3304. });
  3305. } else {
  3306. if (priv.options.debug || DBG) console.log('NO data');
  3307. return false;
  3308. }
  3309. };
  3310. priv.ajaxLoadTypeSpeciallCell = function(id, col) {
  3311. if (_popoverCellAjaxXhr) {
  3312. _popoverCellAjaxXhr.abort();
  3313. }
  3314. _popoverCellAjaxXhr = $.ajax({
  3315. type: 'GET',
  3316. url: 'index.php?_route=ViewTableAjax&_task=typeSpecialCell&namespace=' + priv.options.namespace + '&ID=' + id + '&col=' + col,
  3317. dataType: 'json',
  3318. contentType: "application/json; charset=utf-8",
  3319. data: '',
  3320. success: function(req){
  3321. if (_.get(req, 'data.tbl_id') > 0) {
  3322. var addHtml = '';
  3323. for (var i in req.data.items) {
  3324. var url = 'index.php?_route=ViewTableAjax';
  3325. url += '&namespace=' + req.namespace;
  3326. url += '&f_' + req.data.fld_name + '=' + req.data.items[i].id;
  3327. url += '&_hash=' + Math.random().toString(36).substring(2);
  3328. addHtml += '<a href="' + url + '">Wyszukaj ' + req.data.items[i].id + '</a>: ' + req.data.items[i].label;
  3329. addHtml += '<br>';
  3330. }
  3331. //_popoverCell.append(addHtml);// cache
  3332. if (_popoverCellCurrent) {
  3333. var popoverNodeId = _popoverCellCurrent.attr('aria-describedby');
  3334. if (popoverNodeId) {
  3335. jQuery('#' + popoverNodeId).find('.popoverCellContent').append(addHtml);
  3336. }
  3337. }
  3338. }
  3339. }
  3340. });
  3341. };
  3342. priv.popoverCellTypeSpecial = function(e) {
  3343. e.preventDefault();
  3344. e.stopPropagation();
  3345. if ('id' in e.data && 'col' in e.data && e.data.id > 0) {
  3346. var lastId = _popoverCell.data('rowid'),
  3347. lastCol = _popoverCell.data('col'),
  3348. rowPK = e.data.id,
  3349. colName = e.data.col
  3350. ;
  3351. if (lastId == rowPK && lastCol == colName) {
  3352. //_popoverCellCurrent.popover('toggle');
  3353. }
  3354. else {
  3355. if (_popoverCellCurrent) {
  3356. _popoverCellCurrent.popover('destroy');
  3357. }
  3358. _popoverCell.data('rowid', rowPK);
  3359. _popoverCell.data('col', colName);
  3360. _popoverCell.html(e.data.value + '<div class="popoverCellContent loading" style="white-space:normal"></div>');
  3361. _popoverCellCurrent = jQuery(e.currentTarget);
  3362. // title : '<span class="text-info"><strong>title</strong></span> <button type="button" id="close" class="close">&times;</button>'
  3363. var opts = {
  3364. placement: 'left'
  3365. , trigger: 'click'
  3366. // , title: e.data.col + '<a href="#" class="glyphicon glyphicon-remove pull-right" onclick="return hidePopover();"></a>'
  3367. , title: '<div style="display:block;position:relative;padding:0 20px 0 0;">' + (e.data.friendly || colName) + ' <button type="button" class="close" onclick="return hidePopover();" style="position:absolute;right:0;top:0;">&times;</button>' + '</div>'
  3368. , html: true
  3369. , content: _popoverCell.html()
  3370. }
  3371. _popoverCellCurrent.popover(opts);
  3372. if (_data.cols[colName]) {
  3373. if (_data.cols[colName]._tsRetId > 0) {
  3374. _popoverCellCurrent.on('shown.bs.popover', function() {
  3375. priv.ajaxLoadTypeSpeciallCell(rowPK, colName);
  3376. });
  3377. }
  3378. }
  3379. _popoverCellCurrent.popover('show');
  3380. }
  3381. } else {
  3382. if (priv.options.debug || DBG) console.log('NO data');
  3383. return false;
  3384. }
  3385. return;
  3386. };
  3387. priv.routeChanged = function(e) {
  3388. hash = e.data.hash || '';
  3389. if (hash.length == 0) {
  3390. return;
  3391. }
  3392. if (hash.substring(0, 1) != '#') {
  3393. hash = '#' + hash;
  3394. }
  3395. location.hash = hash;
  3396. };
  3397. priv.refresh = function(e) {
  3398. e.preventDefault();
  3399. publ.loadPage(_state.page);
  3400. };
  3401. publ.init = function(options) {
  3402. if (priv.options.debug || DBG) console.log('TableAjax initialization...');
  3403. //merge supplied options with defaults
  3404. $.extend(priv.options, defaults, options);
  3405. priv.init();
  3406. return publ;
  3407. };
  3408. publ.refresh = function() {
  3409. publ.loadPage(_state.page);
  3410. };
  3411. publ.loadPage = function(page, pageSize) {
  3412. priv.loadPage(page, pageSize);
  3413. }
  3414. priv.asyncFetchTotal = function(url) {
  3415. var this__asyncFetchTotal__reqId = (_state.asyncFetchTotal__lastSentReqId || 0) + 1;
  3416. { // prevent to fetch more then 2 requests at the same time
  3417. var lastReceivedId = _state.asyncFetchTotal__lastReceivedId || 0;
  3418. DBG && console.log('DBG:priv.asyncFetchTotal skip', { skip: (this__asyncFetchTotal__reqId > lastReceivedId + 2), lastSentReqId: this__asyncFetchTotal__reqId, lastReceivedId: lastReceivedId })
  3419. if (this__asyncFetchTotal__reqId > lastReceivedId + 2) return;
  3420. }
  3421. _state.asyncFetchTotal__lastSentReqId = this__asyncFetchTotal__reqId;
  3422. window.fetch(url, {
  3423. method: priv.options.urlPost ? 'POST' : 'GET',
  3424. credentials: 'same-origin',
  3425. }).then(function(response) {
  3426. return response.json()
  3427. }).then(function (data) {
  3428. if ('success' == data.type) {
  3429. _data.total = data.total || -1;
  3430. DBG && console.log('DBG:priv.asyncFetchTotal fetch success', { reqId: this__asyncFetchTotal__reqId, data: data })
  3431. if (SKIP_TOTAL) _state.asyncFetchTotal__lastReceivedId = this__asyncFetchTotal__reqId;
  3432. if (SKIP_TOTAL) _state.isLoadingTotal = (_state.asyncFetchTotal__lastReceivedId < _state.asyncFetchTotal__lastSentReqId);
  3433. jQuery(_uiNodeCont).trigger('TableAjax:render', [ 'foot_pagination' ]);
  3434. } else {
  3435. p5UI__notifyAjaxCallback(data);
  3436. // priv.showFailFetchDataMsg();
  3437. }
  3438. }).catch(function (e) {
  3439. console.log('asyncFetchTotal:fetch: ERR:', e);
  3440. })
  3441. }
  3442. priv.loadPage = function(page, pageSize) {
  3443. var resetChecked = false;
  3444. var reqData = {
  3445. page: page,
  3446. pageSize: (pageSize || priv.options.pageSize),
  3447. currSortCol: (_state._currSortCol || ''),
  3448. currSortFlip: _state._currSortFlip ? "desc" : "asc"
  3449. };
  3450. var urlAdd = '';
  3451. urlAdd += '&' + 'page=' + page;
  3452. urlAdd += '&' + 'pageSize=' + (pageSize || priv.options.pageSize);
  3453. DBG && console.log('DBG::loadPage... FETCH_DATA', { '_state._filterQuery': _state._filterQuery, '_state._specialFilterQuery': _state._specialFilterQuery, _state });
  3454. urlAdd += '&' + priv.filter_getFullFilterQuery();
  3455. if (SKIP_TOTAL) urlAdd += '&' + 'SKIP_TOTAL=1';
  3456. _uiNode$Table.parent().parent().addClass('AjaxTable-loading');
  3457. // p5UI__notifyAjaxCallback({type: 'info', msg: 'pobieranie danych...'});
  3458. window.fetch(priv.options.url + urlAdd, {
  3459. method: priv.options.urlPost ? 'POST' : 'GET',
  3460. credentials: 'same-origin',// add cookies
  3461. }).then(function (response) {
  3462. return response.json()
  3463. }).then(function (data) {
  3464. if (priv.options.debug || DBG) console.log('loadDataAjax:fetch:loadPage: request finished, data:', data);
  3465. // p5UI__notifyAjaxCallback(data);
  3466. if ('success' == data.type) {
  3467. state = {data: {}};
  3468. state.data.cols = data.cols || {};
  3469. state.data.rows = data.rows || [];
  3470. state.data.total = data.total || 0;
  3471. state.data.primaryKey = data.primaryKey || 'ID';
  3472. state.page = data.page || 0;
  3473. state.pageSize = data.pageSize || priv.options.pageSize;
  3474. state.filters = data.filters || {};
  3475. DBG && console.log('DBG::loadPage... - FETCH_DATA END priv.setState(state);', { state });
  3476. if (SKIP_TOTAL) _state.isLoadingTotal = true;
  3477. priv.setState(state);
  3478. _uiNode$Table.parent().parent().removeClass('AjaxTable-loading');
  3479. if (SKIP_TOTAL) priv.asyncFetchTotal((priv.options.url + urlAdd).replace('SKIP_TOTAL=1', 'ONLY_TOTAL=1'))
  3480. } else {
  3481. p5UI__notifyAjaxCallback(data);
  3482. priv.showFailFetchDataMsg();
  3483. }
  3484. }).catch(function (e) {
  3485. console.log('loadDataAjax:fetch: ERR:', e);
  3486. });
  3487. };
  3488. publ.getCurrentPage = function() {
  3489. return _state.page;
  3490. };
  3491. publ.popoverCellRemove = function() {
  3492. if (_popoverCellCurrent) {
  3493. _popoverCellCurrent.popover('destroy');
  3494. }
  3495. _popoverCell.data('rowid', -1);
  3496. _popoverCell.data('col', -1);
  3497. _popoverCell.html('');
  3498. };
  3499. return publ;
  3500. }
  3501. $.fn.TableAjax = function(options) {
  3502. options = options || {};
  3503. return this.each(function() {
  3504. options.id = this;
  3505. $(this).data('TableAjax', new TableAjax().init(options));
  3506. });
  3507. };
  3508. $.fn.TableAjaxLoadPage = function(page, pageSize) {
  3509. return this.each(function() {
  3510. var tblAjax = jQuery(this).data('TableAjax');
  3511. var curPage = page || tblAjax.getCurrentPage();
  3512. if (tblAjax) tblAjax.loadPage(curPage, pageSize);
  3513. });
  3514. };
  3515. $.fn.TableAjaxRefresh = function(page, pageSize) {
  3516. return this.each(function() {
  3517. var tblAjax = jQuery(this).data('TableAjax');
  3518. if (tblAjax) tblAjax.refresh();
  3519. });
  3520. };