Built motion from commit a679711e.|2.6.15
[motion2.git] / server / api / analyticTreeReport / analyticTreeReport.controller.js
index 0b4ae51..b530bb5 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x3cc4=['squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','status','end','json','count','offset','set','Content-Range','apply','save','then','sendStatus','error','stack','name','send','index','map','AnalyticTreeReport','rawAttributes','fieldName','type','model','query','attributes','intersection','fields','length','hasOwnProperty','limit','order','sort','where','filters','pick','filter','merge','VIRTUAL','options','includeAll','include','findAll','catch','show','params','keys','find','create','body','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','lodash'];(function(_0x53b830,_0x1b3f19){var _0x48178e=function(_0x30223e){while(--_0x30223e){_0x53b830['push'](_0x53b830['shift']());}};_0x48178e(++_0x1b3f19);}(_0x3cc4,0xd6));var _0x43cc=function(_0x1b10b0,_0x410bdd){_0x1b10b0=_0x1b10b0-0x0;var _0x5c1177=_0x3cc4[_0x1b10b0];return _0x5c1177;};'use strict';var pdf=require(_0x43cc('0x0'));var emlformat=require(_0x43cc('0x1'));var rimraf=require(_0x43cc('0x2'));var zipdir=require(_0x43cc('0x3'));var jsonpatch=require(_0x43cc('0x4'));var rp=require(_0x43cc('0x5'));var moment=require(_0x43cc('0x6'));var BPromise=require(_0x43cc('0x7'));var Mustache=require(_0x43cc('0x8'));var util=require(_0x43cc('0x9'));var path=require(_0x43cc('0xa'));var sox=require(_0x43cc('0xb'));var csv=require(_0x43cc('0xc'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x43cc('0xd'));var squel=require(_0x43cc('0xe'));var crypto=require('crypto');var jsforce=require(_0x43cc('0xf'));var deskjs=require(_0x43cc('0x10'));var toCsv=require(_0x43cc('0xc'));var querystring=require(_0x43cc('0x11'));var Papa=require(_0x43cc('0x12'));var Redis=require(_0x43cc('0x13'));var authService=require('../../components/auth/service');var qs=require(_0x43cc('0x14'));var as=require(_0x43cc('0x15'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x43cc('0x16'))(_0x43cc('0x17'));var utils=require(_0x43cc('0x18'));var config=require(_0x43cc('0x19'));var licenseUtil=require(_0x43cc('0x1a'));var db=require(_0x43cc('0x1b'))['db'];function respondWithStatusCode(_0x5c6908,_0x21c3a2){_0x21c3a2=_0x21c3a2||0xcc;return function(_0xd825fa){if(_0xd825fa){return _0x5c6908['sendStatus'](_0x21c3a2);}return _0x5c6908[_0x43cc('0x1c')](_0x21c3a2)[_0x43cc('0x1d')]();};}function respondWithResult(_0x23e0f2,_0x5221c8){_0x5221c8=_0x5221c8||0xc8;return function(_0xf25452){if(_0xf25452){return _0x23e0f2[_0x43cc('0x1c')](_0x5221c8)[_0x43cc('0x1e')](_0xf25452);}};}function respondWithFilteredResult(_0x2e39cf,_0x56936f){return function(_0x4687fa){if(_0x4687fa){var _0x3cf6bb=_0x4687fa[_0x43cc('0x1f')],_0x7869e4=_0x56936f[_0x43cc('0x20')],_0x20454c=_0x56936f[_0x43cc('0x20')]+_0x56936f['limit'],_0x544e08;if(_0x20454c>=_0x3cf6bb){_0x20454c=_0x3cf6bb;_0x544e08=0xc8;}else{_0x544e08=0xce;}_0x2e39cf['status'](_0x544e08);return _0x2e39cf[_0x43cc('0x21')](_0x43cc('0x22'),_0x7869e4+'-'+_0x20454c+'/'+_0x3cf6bb)[_0x43cc('0x1e')](_0x4687fa);}return null;};}function patchUpdates(_0xca2716){return function(_0x404c3a){try{jsonpatch[_0x43cc('0x23')](_0x404c3a,_0xca2716,!![]);}catch(_0x4cf0c1){return BPromise['reject'](_0x4cf0c1);}return _0x404c3a[_0x43cc('0x24')]();};}function saveUpdates(_0x364190,_0x275c20){return function(_0x5d6f16){if(_0x5d6f16){return _0x5d6f16['update'](_0x364190)[_0x43cc('0x25')](function(_0x1a1178){return _0x1a1178;});}return null;};}function removeEntity(_0x46ec47,_0x2e01ba){return function(_0x32c2d8){if(_0x32c2d8){return _0x32c2d8['destroy']()['then'](function(){_0x46ec47[_0x43cc('0x1c')](0xcc)[_0x43cc('0x1d')]();});}};}function handleEntityNotFound(_0x21d8bf,_0x1dd702){return function(_0x494d9b){if(!_0x494d9b){_0x21d8bf[_0x43cc('0x26')](0x194);}return _0x494d9b;};}function handleError(_0x21f275,_0x2836eb){_0x2836eb=_0x2836eb||0x1f4;return function(_0x24e3cd){logger[_0x43cc('0x27')](_0x24e3cd[_0x43cc('0x28')]);if(_0x24e3cd[_0x43cc('0x29')]){delete _0x24e3cd['name'];}_0x21f275[_0x43cc('0x1c')](_0x2836eb)[_0x43cc('0x2a')](_0x24e3cd);};}exports[_0x43cc('0x2b')]=function(_0x2602f0,_0x55bd18){var _0x1d1157={},_0x46dc12={},_0x4ba1e8={'count':0x0,'rows':[]};var _0x3299ad=_[_0x43cc('0x2c')](db[_0x43cc('0x2d')][_0x43cc('0x2e')],function(_0x3cf486){return{'name':_0x3cf486[_0x43cc('0x2f')],'type':_0x3cf486[_0x43cc('0x30')]['key']};});_0x46dc12[_0x43cc('0x31')]=_[_0x43cc('0x2c')](_0x3299ad,_0x43cc('0x29'));_0x46dc12[_0x43cc('0x32')]=_['keys'](_0x2602f0[_0x43cc('0x32')]);_0x46dc12['filters']=_['intersection'](_0x46dc12[_0x43cc('0x31')],_0x46dc12[_0x43cc('0x32')]);_0x1d1157[_0x43cc('0x33')]=_[_0x43cc('0x34')](_0x46dc12[_0x43cc('0x31')],qs[_0x43cc('0x35')](_0x2602f0[_0x43cc('0x32')]['fields']));_0x1d1157[_0x43cc('0x33')]=_0x1d1157[_0x43cc('0x33')][_0x43cc('0x36')]?_0x1d1157[_0x43cc('0x33')]:_0x46dc12[_0x43cc('0x31')];if(!_0x2602f0[_0x43cc('0x32')][_0x43cc('0x37')]('nolimit')){_0x1d1157['limit']=qs['limit'](_0x2602f0[_0x43cc('0x32')][_0x43cc('0x38')]);_0x1d1157[_0x43cc('0x20')]=qs[_0x43cc('0x20')](_0x2602f0[_0x43cc('0x32')]['offset']);}_0x1d1157[_0x43cc('0x39')]=qs[_0x43cc('0x3a')](_0x2602f0[_0x43cc('0x32')][_0x43cc('0x3a')]);_0x1d1157[_0x43cc('0x3b')]=qs[_0x43cc('0x3c')](_[_0x43cc('0x3d')](_0x2602f0[_0x43cc('0x32')],_0x46dc12[_0x43cc('0x3c')]),_0x3299ad);if(_0x2602f0[_0x43cc('0x32')][_0x43cc('0x3e')]){_0x1d1157[_0x43cc('0x3b')]=_[_0x43cc('0x3f')](_0x1d1157[_0x43cc('0x3b')],{'$or':_[_0x43cc('0x2c')](_0x3299ad,function(_0x54f89c){if(_0x54f89c[_0x43cc('0x30')]!==_0x43cc('0x40')){var _0x508ccc={};_0x508ccc[_0x54f89c[_0x43cc('0x29')]]={'$like':'%'+_0x2602f0[_0x43cc('0x32')]['filter']+'%'};return _0x508ccc;}})});}_0x1d1157=_['merge']({},_0x1d1157,_0x2602f0[_0x43cc('0x41')]);var _0x1dc52d={'where':_0x1d1157[_0x43cc('0x3b')]};return db['AnalyticTreeReport']['count'](_0x1dc52d)[_0x43cc('0x25')](function(_0x4274ef){_0x4ba1e8[_0x43cc('0x1f')]=_0x4274ef;if(_0x2602f0[_0x43cc('0x32')][_0x43cc('0x42')]){_0x1d1157[_0x43cc('0x43')]=[{'all':!![]}];}return db['AnalyticTreeReport'][_0x43cc('0x44')](_0x1d1157);})[_0x43cc('0x25')](function(_0x436d0c){_0x4ba1e8['rows']=_0x436d0c;return _0x4ba1e8;})[_0x43cc('0x25')](respondWithFilteredResult(_0x55bd18,_0x1d1157))[_0x43cc('0x45')](handleError(_0x55bd18,null));};exports[_0x43cc('0x46')]=function(_0x3e8c9e,_0x25f14d){var _0x125671={'raw':!![],'where':{'id':_0x3e8c9e[_0x43cc('0x47')]['id']}},_0x30a5a4={};_0x30a5a4[_0x43cc('0x31')]=_[_0x43cc('0x48')](db[_0x43cc('0x2d')][_0x43cc('0x2e')]);_0x30a5a4[_0x43cc('0x32')]=_[_0x43cc('0x48')](_0x3e8c9e['query']);_0x30a5a4[_0x43cc('0x3c')]=_['intersection'](_0x30a5a4[_0x43cc('0x31')],_0x30a5a4['query']);_0x125671[_0x43cc('0x33')]=_['intersection'](_0x30a5a4[_0x43cc('0x31')],qs[_0x43cc('0x35')](_0x3e8c9e['query'][_0x43cc('0x35')]));_0x125671[_0x43cc('0x33')]=_0x125671[_0x43cc('0x33')][_0x43cc('0x36')]?_0x125671['attributes']:_0x30a5a4[_0x43cc('0x31')];if(_0x3e8c9e[_0x43cc('0x32')][_0x43cc('0x42')]){_0x125671[_0x43cc('0x43')]=[{'all':!![]}];}_0x125671=_[_0x43cc('0x3f')]({},_0x125671,_0x3e8c9e['options']);return db['AnalyticTreeReport'][_0x43cc('0x49')](_0x125671)[_0x43cc('0x25')](handleEntityNotFound(_0x25f14d,null))['then'](respondWithResult(_0x25f14d,null))['catch'](handleError(_0x25f14d,null));};exports[_0x43cc('0x4a')]=function(_0x4210e3,_0x160ad6){return db['AnalyticTreeReport'][_0x43cc('0x4a')](_0x4210e3['body'],{})[_0x43cc('0x25')](respondWithResult(_0x160ad6,0xc9))[_0x43cc('0x45')](handleError(_0x160ad6,null));};exports['update']=function(_0x506cd6,_0x2ec86a){if(_0x506cd6[_0x43cc('0x4b')]['id']){delete _0x506cd6[_0x43cc('0x4b')]['id'];}return db[_0x43cc('0x2d')]['find']({'where':{'id':_0x506cd6[_0x43cc('0x47')]['id']}})[_0x43cc('0x25')](handleEntityNotFound(_0x2ec86a,null))[_0x43cc('0x25')](saveUpdates(_0x506cd6[_0x43cc('0x4b')],null))['then'](respondWithResult(_0x2ec86a,null))[_0x43cc('0x45')](handleError(_0x2ec86a,null));};exports['destroy']=function(_0x55e891,_0x4e6017){return db[_0x43cc('0x2d')][_0x43cc('0x49')]({'where':{'id':_0x55e891['params']['id']}})[_0x43cc('0x25')](handleEntityNotFound(_0x4e6017,null))[_0x43cc('0x25')](removeEntity(_0x4e6017,null))[_0x43cc('0x45')](handleError(_0x4e6017,null));};
\ No newline at end of file
+var _0x280f=['moment','bluebird','mustache','util','path','sox','to-csv','fs-extra','lodash','crypto','jsforce','desk.js','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','limit','count','offset','set','Content-Range','apply','save','update','then','destroy','end','stack','name','send','index','AnalyticTreeReport','rawAttributes','model','map','query','filters','intersection','fields','hasOwnProperty','nolimit','order','sort','where','filter','type','merge','options','includeAll','include','findAll','rows','catch','keys','attributes','length','find','create','body','params','eml-format','rimraf','zip-dir','fast-json-patch','request-promise'];(function(_0x1ba52b,_0xe8055a){var _0xf14517=function(_0x33bb2e){while(--_0x33bb2e){_0x1ba52b['push'](_0x1ba52b['shift']());}};_0xf14517(++_0xe8055a);}(_0x280f,0xdc));var _0xf280=function(_0x2718c7,_0x5a1636){_0x2718c7=_0x2718c7-0x0;var _0x59d89c=_0x280f[_0x2718c7];return _0x59d89c;};'use strict';var emlformat=require(_0xf280('0x0'));var rimraf=require(_0xf280('0x1'));var zipdir=require(_0xf280('0x2'));var jsonpatch=require(_0xf280('0x3'));var rp=require(_0xf280('0x4'));var moment=require(_0xf280('0x5'));var BPromise=require(_0xf280('0x6'));var Mustache=require(_0xf280('0x7'));var util=require(_0xf280('0x8'));var path=require(_0xf280('0x9'));var sox=require(_0xf280('0xa'));var csv=require(_0xf280('0xb'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xf280('0xc'));var _=require(_0xf280('0xd'));var squel=require('squel');var crypto=require(_0xf280('0xe'));var jsforce=require(_0xf280('0xf'));var deskjs=require(_0xf280('0x10'));var toCsv=require(_0xf280('0xb'));var querystring=require('querystring');var Papa=require(_0xf280('0x11'));var Redis=require(_0xf280('0x12'));var authService=require('../../components/auth/service');var qs=require(_0xf280('0x13'));var as=require(_0xf280('0x14'));var hardwareService=require(_0xf280('0x15'));var logger=require(_0xf280('0x16'))(_0xf280('0x17'));var utils=require(_0xf280('0x18'));var config=require(_0xf280('0x19'));var licenseUtil=require(_0xf280('0x1a'));var db=require(_0xf280('0x1b'))['db'];function respondWithStatusCode(_0x3006a6,_0x2247e5){_0x2247e5=_0x2247e5||0xcc;return function(_0x3652d4){if(_0x3652d4){return _0x3006a6[_0xf280('0x1c')](_0x2247e5);}return _0x3006a6['status'](_0x2247e5)['end']();};}function respondWithResult(_0x1b4b75,_0x23f85c){_0x23f85c=_0x23f85c||0xc8;return function(_0x299de3){if(_0x299de3){return _0x1b4b75[_0xf280('0x1d')](_0x23f85c)[_0xf280('0x1e')](_0x299de3);}};}function respondWithFilteredResult(_0x2c00e5,_0x363049){return function(_0x3eeecc){if(_0x3eeecc){var _0x4dd261=typeof _0x363049['offset']==='undefined'&&typeof _0x363049[_0xf280('0x1f')]==='undefined';var _0x5d7427=_0x3eeecc[_0xf280('0x20')];var _0x4d7745=_0x4dd261?0x0:_0x363049['offset'];var _0x71208=_0x4dd261?_0x3eeecc[_0xf280('0x20')]:_0x363049[_0xf280('0x21')]+_0x363049[_0xf280('0x1f')];var _0x6b9c21;if(_0x71208>=_0x5d7427){_0x71208=_0x5d7427;_0x6b9c21=0xc8;}else{_0x6b9c21=0xce;}_0x2c00e5[_0xf280('0x1d')](_0x6b9c21);return _0x2c00e5[_0xf280('0x22')](_0xf280('0x23'),_0x4d7745+'-'+_0x71208+'/'+_0x5d7427)['json'](_0x3eeecc);}return null;};}function patchUpdates(_0x377f76){return function(_0x46d975){try{jsonpatch[_0xf280('0x24')](_0x46d975,_0x377f76,!![]);}catch(_0x274dc8){return BPromise['reject'](_0x274dc8);}return _0x46d975[_0xf280('0x25')]();};}function saveUpdates(_0x42c42e,_0x5aeea1){return function(_0x414d92){if(_0x414d92){return _0x414d92[_0xf280('0x26')](_0x42c42e)[_0xf280('0x27')](function(_0x56bad9){return _0x56bad9;});}return null;};}function removeEntity(_0x249904,_0x171e73){return function(_0xf76d3b){if(_0xf76d3b){return _0xf76d3b[_0xf280('0x28')]()[_0xf280('0x27')](function(){_0x249904[_0xf280('0x1d')](0xcc)[_0xf280('0x29')]();});}};}function handleEntityNotFound(_0x5595ab,_0x38d9c7){return function(_0x416a3b){if(!_0x416a3b){_0x5595ab[_0xf280('0x1c')](0x194);}return _0x416a3b;};}function handleError(_0x66b8fc,_0x22c5a1){_0x22c5a1=_0x22c5a1||0x1f4;return function(_0x3b7232){logger['error'](_0x3b7232[_0xf280('0x2a')]);if(_0x3b7232[_0xf280('0x2b')]){delete _0x3b7232[_0xf280('0x2b')];}_0x66b8fc[_0xf280('0x1d')](_0x22c5a1)[_0xf280('0x2c')](_0x3b7232);};}exports[_0xf280('0x2d')]=function(_0x4d407b,_0x5125b8){var _0x128d0f={},_0x22ef11={},_0x27b6a3={'count':0x0,'rows':[]};var _0x1a2e92=_['map'](db[_0xf280('0x2e')][_0xf280('0x2f')],function(_0x375058){return{'name':_0x375058['fieldName'],'type':_0x375058['type']['key']};});_0x22ef11[_0xf280('0x30')]=_[_0xf280('0x31')](_0x1a2e92,_0xf280('0x2b'));_0x22ef11[_0xf280('0x32')]=_['keys'](_0x4d407b[_0xf280('0x32')]);_0x22ef11[_0xf280('0x33')]=_[_0xf280('0x34')](_0x22ef11[_0xf280('0x30')],_0x22ef11[_0xf280('0x32')]);_0x128d0f['attributes']=_[_0xf280('0x34')](_0x22ef11[_0xf280('0x30')],qs[_0xf280('0x35')](_0x4d407b[_0xf280('0x32')][_0xf280('0x35')]));_0x128d0f['attributes']=_0x128d0f['attributes']['length']?_0x128d0f['attributes']:_0x22ef11[_0xf280('0x30')];if(!_0x4d407b[_0xf280('0x32')][_0xf280('0x36')](_0xf280('0x37'))){_0x128d0f[_0xf280('0x1f')]=qs[_0xf280('0x1f')](_0x4d407b[_0xf280('0x32')]['limit']);_0x128d0f['offset']=qs[_0xf280('0x21')](_0x4d407b[_0xf280('0x32')]['offset']);}_0x128d0f[_0xf280('0x38')]=qs[_0xf280('0x39')](_0x4d407b['query'][_0xf280('0x39')]);_0x128d0f[_0xf280('0x3a')]=qs[_0xf280('0x33')](_['pick'](_0x4d407b[_0xf280('0x32')],_0x22ef11[_0xf280('0x33')]),_0x1a2e92);if(_0x4d407b[_0xf280('0x32')][_0xf280('0x3b')]){_0x128d0f[_0xf280('0x3a')]=_['merge'](_0x128d0f[_0xf280('0x3a')],{'$or':_[_0xf280('0x31')](_0x1a2e92,function(_0x1f90af){if(_0x1f90af[_0xf280('0x3c')]!=='VIRTUAL'){var _0x5a0bd9={};_0x5a0bd9[_0x1f90af['name']]={'$like':'%'+_0x4d407b['query'][_0xf280('0x3b')]+'%'};return _0x5a0bd9;}})});}_0x128d0f=_[_0xf280('0x3d')]({},_0x128d0f,_0x4d407b[_0xf280('0x3e')]);var _0x495ef4={'where':_0x128d0f[_0xf280('0x3a')]};return db[_0xf280('0x2e')][_0xf280('0x20')](_0x495ef4)['then'](function(_0x1c4612){_0x27b6a3[_0xf280('0x20')]=_0x1c4612;if(_0x4d407b[_0xf280('0x32')][_0xf280('0x3f')]){_0x128d0f[_0xf280('0x40')]=[{'all':!![]}];}return db['AnalyticTreeReport'][_0xf280('0x41')](_0x128d0f);})[_0xf280('0x27')](function(_0x425f7b){_0x27b6a3[_0xf280('0x42')]=_0x425f7b;return _0x27b6a3;})[_0xf280('0x27')](respondWithFilteredResult(_0x5125b8,_0x128d0f))[_0xf280('0x43')](handleError(_0x5125b8,null));};exports['show']=function(_0x3a4d31,_0x15e8a9){var _0x5a4c59={'raw':!![],'where':{'id':_0x3a4d31['params']['id']}},_0x371d3b={};_0x371d3b[_0xf280('0x30')]=_[_0xf280('0x44')](db[_0xf280('0x2e')][_0xf280('0x2f')]);_0x371d3b['query']=_['keys'](_0x3a4d31[_0xf280('0x32')]);_0x371d3b[_0xf280('0x33')]=_[_0xf280('0x34')](_0x371d3b['model'],_0x371d3b[_0xf280('0x32')]);_0x5a4c59[_0xf280('0x45')]=_['intersection'](_0x371d3b[_0xf280('0x30')],qs[_0xf280('0x35')](_0x3a4d31[_0xf280('0x32')]['fields']));_0x5a4c59['attributes']=_0x5a4c59['attributes'][_0xf280('0x46')]?_0x5a4c59[_0xf280('0x45')]:_0x371d3b[_0xf280('0x30')];if(_0x3a4d31[_0xf280('0x32')][_0xf280('0x3f')]){_0x5a4c59[_0xf280('0x40')]=[{'all':!![]}];}_0x5a4c59=_[_0xf280('0x3d')]({},_0x5a4c59,_0x3a4d31[_0xf280('0x3e')]);return db[_0xf280('0x2e')][_0xf280('0x47')](_0x5a4c59)[_0xf280('0x27')](handleEntityNotFound(_0x15e8a9,null))[_0xf280('0x27')](respondWithResult(_0x15e8a9,null))[_0xf280('0x43')](handleError(_0x15e8a9,null));};exports[_0xf280('0x48')]=function(_0x212c7f,_0x17df68){return db[_0xf280('0x2e')][_0xf280('0x48')](_0x212c7f['body'],{})[_0xf280('0x27')](respondWithResult(_0x17df68,0xc9))[_0xf280('0x43')](handleError(_0x17df68,null));};exports[_0xf280('0x26')]=function(_0x7706e9,_0x3ad9fd){if(_0x7706e9[_0xf280('0x49')]['id']){delete _0x7706e9[_0xf280('0x49')]['id'];}return db[_0xf280('0x2e')][_0xf280('0x47')]({'where':{'id':_0x7706e9[_0xf280('0x4a')]['id']}})[_0xf280('0x27')](handleEntityNotFound(_0x3ad9fd,null))[_0xf280('0x27')](saveUpdates(_0x7706e9['body'],null))[_0xf280('0x27')](respondWithResult(_0x3ad9fd,null))[_0xf280('0x43')](handleError(_0x3ad9fd,null));};exports[_0xf280('0x28')]=function(_0x4174da,_0xbf05){return db[_0xf280('0x2e')][_0xf280('0x47')]({'where':{'id':_0x4174da[_0xf280('0x4a')]['id']}})[_0xf280('0x27')](handleEntityNotFound(_0xbf05,null))[_0xf280('0x27')](removeEntity(_0xbf05,null))[_0xf280('0x43')](handleError(_0xbf05,null));};
\ No newline at end of file