Built motion from commit 85328c08.|2.5.50
[motion2.git] / server / api / analyticTreeReport / analyticTreeReport.controller.js
index 6c3cf3f..75eab4b 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x5752=['type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','order','sort','where','pick','filter','merge','VIRTUAL','includeAll','include','AnalyticTreeReport','findAll','rows','show','params','find','create','catch','body','destroy','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','util','path','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','limit','undefined','count','set','Content-Range','apply','reject','save','update','then','error','stack','name','map','rawAttributes','fieldName'];(function(_0xb598fd,_0x57515c){var _0x17bbb8=function(_0x4739c7){while(--_0x4739c7){_0xb598fd['push'](_0xb598fd['shift']());}};_0x17bbb8(++_0x57515c);}(_0x5752,0x1ec));var _0x2575=function(_0x68c979,_0x431cff){_0x68c979=_0x68c979-0x0;var _0x4f0001=_0x5752[_0x68c979];return _0x4f0001;};'use strict';var emlformat=require(_0x2575('0x0'));var rimraf=require(_0x2575('0x1'));var zipdir=require(_0x2575('0x2'));var jsonpatch=require(_0x2575('0x3'));var rp=require(_0x2575('0x4'));var moment=require(_0x2575('0x5'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x2575('0x6'));var path=require(_0x2575('0x7'));var sox=require(_0x2575('0x8'));var csv=require(_0x2575('0x9'));var ejs=require(_0x2575('0xa'));var fs=require('fs');var fs_extra=require(_0x2575('0xb'));var _=require('lodash');var squel=require(_0x2575('0xc'));var crypto=require(_0x2575('0xd'));var jsforce=require(_0x2575('0xe'));var deskjs=require(_0x2575('0xf'));var toCsv=require(_0x2575('0x9'));var querystring=require('querystring');var Papa=require(_0x2575('0x10'));var Redis=require(_0x2575('0x11'));var authService=require(_0x2575('0x12'));var qs=require(_0x2575('0x13'));var as=require(_0x2575('0x14'));var hardwareService=require(_0x2575('0x15'));var logger=require('../../config/logger')(_0x2575('0x16'));var utils=require(_0x2575('0x17'));var config=require('../../config/environment');var licenseUtil=require(_0x2575('0x18'));var db=require(_0x2575('0x19'))['db'];function respondWithStatusCode(_0x520c19,_0x1081df){_0x1081df=_0x1081df||0xcc;return function(_0x257846){if(_0x257846){return _0x520c19[_0x2575('0x1a')](_0x1081df);}return _0x520c19[_0x2575('0x1b')](_0x1081df)[_0x2575('0x1c')]();};}function respondWithResult(_0x29b895,_0x383a53){_0x383a53=_0x383a53||0xc8;return function(_0x24f732){if(_0x24f732){return _0x29b895[_0x2575('0x1b')](_0x383a53)[_0x2575('0x1d')](_0x24f732);}};}function respondWithFilteredResult(_0x5e0034,_0x578811){return function(_0x38356a){if(_0x38356a){var _0x47cb3d=typeof _0x578811[_0x2575('0x1e')]==='undefined'&&typeof _0x578811[_0x2575('0x1f')]===_0x2575('0x20');var _0x5c1616=_0x38356a[_0x2575('0x21')];var _0x5a2db7=_0x47cb3d?0x0:_0x578811['offset'];var _0x3c6efe=_0x47cb3d?_0x38356a[_0x2575('0x21')]:_0x578811['offset']+_0x578811['limit'];var _0x42d5df;if(_0x3c6efe>=_0x5c1616){_0x3c6efe=_0x5c1616;_0x42d5df=0xc8;}else{_0x42d5df=0xce;}_0x5e0034[_0x2575('0x1b')](_0x42d5df);return _0x5e0034[_0x2575('0x22')](_0x2575('0x23'),_0x5a2db7+'-'+_0x3c6efe+'/'+_0x5c1616)[_0x2575('0x1d')](_0x38356a);}return null;};}function patchUpdates(_0xa0e275){return function(_0x5e0009){try{jsonpatch[_0x2575('0x24')](_0x5e0009,_0xa0e275,!![]);}catch(_0x406520){return BPromise[_0x2575('0x25')](_0x406520);}return _0x5e0009[_0x2575('0x26')]();};}function saveUpdates(_0x4f4fa9,_0xaaae59){return function(_0x2e0b2e){if(_0x2e0b2e){return _0x2e0b2e[_0x2575('0x27')](_0x4f4fa9)[_0x2575('0x28')](function(_0x365cc2){return _0x365cc2;});}return null;};}function removeEntity(_0x406907,_0x34df12){return function(_0x355b7d){if(_0x355b7d){return _0x355b7d['destroy']()[_0x2575('0x28')](function(){_0x406907[_0x2575('0x1b')](0xcc)[_0x2575('0x1c')]();});}};}function handleEntityNotFound(_0x433fd1,_0x331821){return function(_0x517bf3){if(!_0x517bf3){_0x433fd1[_0x2575('0x1a')](0x194);}return _0x517bf3;};}function handleError(_0x7b7411,_0xc96e49){_0xc96e49=_0xc96e49||0x1f4;return function(_0x41c610){logger[_0x2575('0x29')](_0x41c610[_0x2575('0x2a')]);if(_0x41c610[_0x2575('0x2b')]){delete _0x41c610['name'];}_0x7b7411['status'](_0xc96e49)['send'](_0x41c610);};}exports['index']=function(_0x5626de,_0x30a144){var _0x425d49={},_0x2e2ac8={},_0x55d28e={'count':0x0,'rows':[]};var _0x4ec9af=_[_0x2575('0x2c')](db['AnalyticTreeReport'][_0x2575('0x2d')],function(_0x49f7be){return{'name':_0x49f7be[_0x2575('0x2e')],'type':_0x49f7be[_0x2575('0x2f')][_0x2575('0x30')]};});_0x2e2ac8[_0x2575('0x31')]=_['map'](_0x4ec9af,'name');_0x2e2ac8[_0x2575('0x32')]=_[_0x2575('0x33')](_0x5626de['query']);_0x2e2ac8[_0x2575('0x34')]=_[_0x2575('0x35')](_0x2e2ac8[_0x2575('0x31')],_0x2e2ac8['query']);_0x425d49[_0x2575('0x36')]=_[_0x2575('0x35')](_0x2e2ac8[_0x2575('0x31')],qs['fields'](_0x5626de['query'][_0x2575('0x37')]));_0x425d49['attributes']=_0x425d49[_0x2575('0x36')][_0x2575('0x38')]?_0x425d49['attributes']:_0x2e2ac8[_0x2575('0x31')];if(!_0x5626de[_0x2575('0x32')][_0x2575('0x39')]('nolimit')){_0x425d49[_0x2575('0x1f')]=qs['limit'](_0x5626de[_0x2575('0x32')][_0x2575('0x1f')]);_0x425d49[_0x2575('0x1e')]=qs[_0x2575('0x1e')](_0x5626de[_0x2575('0x32')][_0x2575('0x1e')]);}_0x425d49[_0x2575('0x3a')]=qs[_0x2575('0x3b')](_0x5626de[_0x2575('0x32')][_0x2575('0x3b')]);_0x425d49[_0x2575('0x3c')]=qs[_0x2575('0x34')](_[_0x2575('0x3d')](_0x5626de[_0x2575('0x32')],_0x2e2ac8[_0x2575('0x34')]),_0x4ec9af);if(_0x5626de['query'][_0x2575('0x3e')]){_0x425d49[_0x2575('0x3c')]=_[_0x2575('0x3f')](_0x425d49[_0x2575('0x3c')],{'$or':_[_0x2575('0x2c')](_0x4ec9af,function(_0x59b370){if(_0x59b370[_0x2575('0x2f')]!==_0x2575('0x40')){var _0x593e92={};_0x593e92[_0x59b370['name']]={'$like':'%'+_0x5626de['query']['filter']+'%'};return _0x593e92;}})});}_0x425d49=_[_0x2575('0x3f')]({},_0x425d49,_0x5626de['options']);var _0x1e5b50={'where':_0x425d49[_0x2575('0x3c')]};return db['AnalyticTreeReport'][_0x2575('0x21')](_0x1e5b50)[_0x2575('0x28')](function(_0x4fe22f){_0x55d28e[_0x2575('0x21')]=_0x4fe22f;if(_0x5626de[_0x2575('0x32')][_0x2575('0x41')]){_0x425d49[_0x2575('0x42')]=[{'all':!![]}];}return db[_0x2575('0x43')][_0x2575('0x44')](_0x425d49);})[_0x2575('0x28')](function(_0x1b8c5d){_0x55d28e[_0x2575('0x45')]=_0x1b8c5d;return _0x55d28e;})[_0x2575('0x28')](respondWithFilteredResult(_0x30a144,_0x425d49))['catch'](handleError(_0x30a144,null));};exports[_0x2575('0x46')]=function(_0x52e4ad,_0x380875){var _0x462f37={'raw':!![],'where':{'id':_0x52e4ad[_0x2575('0x47')]['id']}},_0xd612bd={};_0xd612bd[_0x2575('0x31')]=_['keys'](db[_0x2575('0x43')][_0x2575('0x2d')]);_0xd612bd['query']=_['keys'](_0x52e4ad[_0x2575('0x32')]);_0xd612bd['filters']=_[_0x2575('0x35')](_0xd612bd[_0x2575('0x31')],_0xd612bd[_0x2575('0x32')]);_0x462f37[_0x2575('0x36')]=_[_0x2575('0x35')](_0xd612bd[_0x2575('0x31')],qs[_0x2575('0x37')](_0x52e4ad[_0x2575('0x32')][_0x2575('0x37')]));_0x462f37[_0x2575('0x36')]=_0x462f37[_0x2575('0x36')]['length']?_0x462f37[_0x2575('0x36')]:_0xd612bd['model'];if(_0x52e4ad[_0x2575('0x32')][_0x2575('0x41')]){_0x462f37[_0x2575('0x42')]=[{'all':!![]}];}_0x462f37=_[_0x2575('0x3f')]({},_0x462f37,_0x52e4ad['options']);return db[_0x2575('0x43')][_0x2575('0x48')](_0x462f37)[_0x2575('0x28')](handleEntityNotFound(_0x380875,null))[_0x2575('0x28')](respondWithResult(_0x380875,null))['catch'](handleError(_0x380875,null));};exports[_0x2575('0x49')]=function(_0x5bd767,_0x862e8){return db[_0x2575('0x43')]['create'](_0x5bd767['body'],{})[_0x2575('0x28')](respondWithResult(_0x862e8,0xc9))[_0x2575('0x4a')](handleError(_0x862e8,null));};exports['update']=function(_0x4dea13,_0x456af6){if(_0x4dea13[_0x2575('0x4b')]['id']){delete _0x4dea13['body']['id'];}return db[_0x2575('0x43')][_0x2575('0x48')]({'where':{'id':_0x4dea13[_0x2575('0x47')]['id']}})['then'](handleEntityNotFound(_0x456af6,null))[_0x2575('0x28')](saveUpdates(_0x4dea13[_0x2575('0x4b')],null))[_0x2575('0x28')](respondWithResult(_0x456af6,null))['catch'](handleError(_0x456af6,null));};exports[_0x2575('0x4c')]=function(_0x41abfc,_0x44b822){return db['AnalyticTreeReport'][_0x2575('0x48')]({'where':{'id':_0x41abfc[_0x2575('0x47')]['id']}})['then'](handleEntityNotFound(_0x44b822,null))['then'](removeEntity(_0x44b822,null))['catch'](handleError(_0x44b822,null));};
\ No newline at end of file
+var _0xf31a=['json','offset','limit','count','Content-Range','apply','reject','update','then','destroy','error','stack','name','index','AnalyticTreeReport','fieldName','type','key','map','query','keys','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filter','merge','options','include','findAll','rows','show','params','includeAll','catch','create','body','find','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end'];(function(_0x19e35c,_0x29cd1e){var _0x3e1fe8=function(_0x17258b){while(--_0x17258b){_0x19e35c['push'](_0x19e35c['shift']());}};_0x3e1fe8(++_0x29cd1e);}(_0xf31a,0x159));var _0xaf31=function(_0x1beef3,_0x57c4b8){_0x1beef3=_0x1beef3-0x0;var _0x5af964=_0xf31a[_0x1beef3];return _0x5af964;};'use strict';var emlformat=require(_0xaf31('0x0'));var rimraf=require(_0xaf31('0x1'));var zipdir=require(_0xaf31('0x2'));var jsonpatch=require(_0xaf31('0x3'));var rp=require(_0xaf31('0x4'));var moment=require(_0xaf31('0x5'));var BPromise=require(_0xaf31('0x6'));var Mustache=require(_0xaf31('0x7'));var util=require(_0xaf31('0x8'));var path=require(_0xaf31('0x9'));var sox=require(_0xaf31('0xa'));var csv=require(_0xaf31('0xb'));var ejs=require(_0xaf31('0xc'));var fs=require('fs');var fs_extra=require(_0xaf31('0xd'));var _=require('lodash');var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xaf31('0xe'));var deskjs=require(_0xaf31('0xf'));var toCsv=require(_0xaf31('0xb'));var querystring=require(_0xaf31('0x10'));var Papa=require(_0xaf31('0x11'));var Redis=require(_0xaf31('0x12'));var authService=require(_0xaf31('0x13'));var qs=require(_0xaf31('0x14'));var as=require(_0xaf31('0x15'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xaf31('0x16'))(_0xaf31('0x17'));var utils=require(_0xaf31('0x18'));var config=require('../../config/environment');var licenseUtil=require(_0xaf31('0x19'));var db=require(_0xaf31('0x1a'))['db'];function respondWithStatusCode(_0xbca3e0,_0x2e3629){_0x2e3629=_0x2e3629||0xcc;return function(_0x1d8c65){if(_0x1d8c65){return _0xbca3e0[_0xaf31('0x1b')](_0x2e3629);}return _0xbca3e0[_0xaf31('0x1c')](_0x2e3629)[_0xaf31('0x1d')]();};}function respondWithResult(_0x25bd07,_0x58c279){_0x58c279=_0x58c279||0xc8;return function(_0xc04939){if(_0xc04939){return _0x25bd07[_0xaf31('0x1c')](_0x58c279)[_0xaf31('0x1e')](_0xc04939);}};}function respondWithFilteredResult(_0xd02d7,_0x2ca935){return function(_0x204153){if(_0x204153){var _0x59e97c=typeof _0x2ca935[_0xaf31('0x1f')]==='undefined'&&typeof _0x2ca935[_0xaf31('0x20')]==='undefined';var _0x4ac26f=_0x204153[_0xaf31('0x21')];var _0x542b8e=_0x59e97c?0x0:_0x2ca935[_0xaf31('0x1f')];var _0x470cc0=_0x59e97c?_0x204153['count']:_0x2ca935[_0xaf31('0x1f')]+_0x2ca935['limit'];var _0x5de237;if(_0x470cc0>=_0x4ac26f){_0x470cc0=_0x4ac26f;_0x5de237=0xc8;}else{_0x5de237=0xce;}_0xd02d7[_0xaf31('0x1c')](_0x5de237);return _0xd02d7['set'](_0xaf31('0x22'),_0x542b8e+'-'+_0x470cc0+'/'+_0x4ac26f)[_0xaf31('0x1e')](_0x204153);}return null;};}function patchUpdates(_0x10206e){return function(_0x23711f){try{jsonpatch[_0xaf31('0x23')](_0x23711f,_0x10206e,!![]);}catch(_0x3518a9){return BPromise[_0xaf31('0x24')](_0x3518a9);}return _0x23711f['save']();};}function saveUpdates(_0x5c1d99,_0x588e5e){return function(_0x479fc7){if(_0x479fc7){return _0x479fc7[_0xaf31('0x25')](_0x5c1d99)[_0xaf31('0x26')](function(_0x1de4ad){return _0x1de4ad;});}return null;};}function removeEntity(_0x1689be,_0xe307e7){return function(_0x1ded77){if(_0x1ded77){return _0x1ded77[_0xaf31('0x27')]()[_0xaf31('0x26')](function(){_0x1689be['status'](0xcc)[_0xaf31('0x1d')]();});}};}function handleEntityNotFound(_0x3ad1d6,_0xf5c7c3){return function(_0x5ca024){if(!_0x5ca024){_0x3ad1d6[_0xaf31('0x1b')](0x194);}return _0x5ca024;};}function handleError(_0x5d80bf,_0x34430d){_0x34430d=_0x34430d||0x1f4;return function(_0x4a3a9a){logger[_0xaf31('0x28')](_0x4a3a9a[_0xaf31('0x29')]);if(_0x4a3a9a[_0xaf31('0x2a')]){delete _0x4a3a9a[_0xaf31('0x2a')];}_0x5d80bf['status'](_0x34430d)['send'](_0x4a3a9a);};}exports[_0xaf31('0x2b')]=function(_0x3ce3a6,_0x596474){var _0x8526fb={},_0x42b8b3={},_0x5e6cd2={'count':0x0,'rows':[]};var _0x5e93b0=_['map'](db[_0xaf31('0x2c')]['rawAttributes'],function(_0x2a7276){return{'name':_0x2a7276[_0xaf31('0x2d')],'type':_0x2a7276[_0xaf31('0x2e')][_0xaf31('0x2f')]};});_0x42b8b3['model']=_[_0xaf31('0x30')](_0x5e93b0,'name');_0x42b8b3[_0xaf31('0x31')]=_[_0xaf31('0x32')](_0x3ce3a6[_0xaf31('0x31')]);_0x42b8b3[_0xaf31('0x33')]=_[_0xaf31('0x34')](_0x42b8b3[_0xaf31('0x35')],_0x42b8b3[_0xaf31('0x31')]);_0x8526fb[_0xaf31('0x36')]=_[_0xaf31('0x34')](_0x42b8b3['model'],qs[_0xaf31('0x37')](_0x3ce3a6[_0xaf31('0x31')][_0xaf31('0x37')]));_0x8526fb[_0xaf31('0x36')]=_0x8526fb[_0xaf31('0x36')][_0xaf31('0x38')]?_0x8526fb['attributes']:_0x42b8b3[_0xaf31('0x35')];if(!_0x3ce3a6['query'][_0xaf31('0x39')](_0xaf31('0x3a'))){_0x8526fb[_0xaf31('0x20')]=qs[_0xaf31('0x20')](_0x3ce3a6[_0xaf31('0x31')]['limit']);_0x8526fb[_0xaf31('0x1f')]=qs[_0xaf31('0x1f')](_0x3ce3a6[_0xaf31('0x31')][_0xaf31('0x1f')]);}_0x8526fb[_0xaf31('0x3b')]=qs[_0xaf31('0x3c')](_0x3ce3a6['query']['sort']);_0x8526fb[_0xaf31('0x3d')]=qs[_0xaf31('0x33')](_['pick'](_0x3ce3a6[_0xaf31('0x31')],_0x42b8b3[_0xaf31('0x33')]),_0x5e93b0);if(_0x3ce3a6[_0xaf31('0x31')][_0xaf31('0x3e')]){_0x8526fb[_0xaf31('0x3d')]=_[_0xaf31('0x3f')](_0x8526fb[_0xaf31('0x3d')],{'$or':_[_0xaf31('0x30')](_0x5e93b0,function(_0x561f0d){if(_0x561f0d[_0xaf31('0x2e')]!=='VIRTUAL'){var _0x287acf={};_0x287acf[_0x561f0d[_0xaf31('0x2a')]]={'$like':'%'+_0x3ce3a6[_0xaf31('0x31')][_0xaf31('0x3e')]+'%'};return _0x287acf;}})});}_0x8526fb=_[_0xaf31('0x3f')]({},_0x8526fb,_0x3ce3a6[_0xaf31('0x40')]);var _0x4bad7f={'where':_0x8526fb[_0xaf31('0x3d')]};return db[_0xaf31('0x2c')][_0xaf31('0x21')](_0x4bad7f)[_0xaf31('0x26')](function(_0x479b62){_0x5e6cd2[_0xaf31('0x21')]=_0x479b62;if(_0x3ce3a6[_0xaf31('0x31')]['includeAll']){_0x8526fb[_0xaf31('0x41')]=[{'all':!![]}];}return db[_0xaf31('0x2c')][_0xaf31('0x42')](_0x8526fb);})['then'](function(_0x279f2f){_0x5e6cd2[_0xaf31('0x43')]=_0x279f2f;return _0x5e6cd2;})[_0xaf31('0x26')](respondWithFilteredResult(_0x596474,_0x8526fb))['catch'](handleError(_0x596474,null));};exports[_0xaf31('0x44')]=function(_0x5cf301,_0x19ed61){var _0x22139f={'raw':!![],'where':{'id':_0x5cf301[_0xaf31('0x45')]['id']}},_0x5e3ada={};_0x5e3ada[_0xaf31('0x35')]=_[_0xaf31('0x32')](db[_0xaf31('0x2c')]['rawAttributes']);_0x5e3ada[_0xaf31('0x31')]=_[_0xaf31('0x32')](_0x5cf301[_0xaf31('0x31')]);_0x5e3ada['filters']=_['intersection'](_0x5e3ada['model'],_0x5e3ada['query']);_0x22139f[_0xaf31('0x36')]=_[_0xaf31('0x34')](_0x5e3ada[_0xaf31('0x35')],qs['fields'](_0x5cf301[_0xaf31('0x31')][_0xaf31('0x37')]));_0x22139f[_0xaf31('0x36')]=_0x22139f[_0xaf31('0x36')]['length']?_0x22139f[_0xaf31('0x36')]:_0x5e3ada[_0xaf31('0x35')];if(_0x5cf301[_0xaf31('0x31')][_0xaf31('0x46')]){_0x22139f[_0xaf31('0x41')]=[{'all':!![]}];}_0x22139f=_[_0xaf31('0x3f')]({},_0x22139f,_0x5cf301[_0xaf31('0x40')]);return db[_0xaf31('0x2c')]['find'](_0x22139f)[_0xaf31('0x26')](handleEntityNotFound(_0x19ed61,null))[_0xaf31('0x26')](respondWithResult(_0x19ed61,null))[_0xaf31('0x47')](handleError(_0x19ed61,null));};exports[_0xaf31('0x48')]=function(_0x4fe3fd,_0x5a3d8c){return db[_0xaf31('0x2c')][_0xaf31('0x48')](_0x4fe3fd['body'],{})[_0xaf31('0x26')](respondWithResult(_0x5a3d8c,0xc9))[_0xaf31('0x47')](handleError(_0x5a3d8c,null));};exports[_0xaf31('0x25')]=function(_0x517c85,_0x573a85){if(_0x517c85[_0xaf31('0x49')]['id']){delete _0x517c85['body']['id'];}return db['AnalyticTreeReport']['find']({'where':{'id':_0x517c85[_0xaf31('0x45')]['id']}})[_0xaf31('0x26')](handleEntityNotFound(_0x573a85,null))[_0xaf31('0x26')](saveUpdates(_0x517c85[_0xaf31('0x49')],null))[_0xaf31('0x26')](respondWithResult(_0x573a85,null))[_0xaf31('0x47')](handleError(_0x573a85,null));};exports['destroy']=function(_0x26e9e7,_0x3b7dba){return db[_0xaf31('0x2c')][_0xaf31('0x4a')]({'where':{'id':_0x26e9e7[_0xaf31('0x45')]['id']}})[_0xaf31('0x26')](handleEntityNotFound(_0x3b7dba,null))['then'](removeEntity(_0x3b7dba,null))['catch'](handleError(_0x3b7dba,null));};
\ No newline at end of file