Built motion from commit da24aabd.|2.6.20
[motion2.git] / server / api / analyticTreeReport / analyticTreeReport.controller.js
index 0f0f30b..bdc39a7 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x0a11=['api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','offset','limit','undefined','count','Content-Range','save','update','then','destroy','error','stack','name','send','map','AnalyticTreeReport','rawAttributes','fieldName','type','key','query','keys','model','fields','attributes','length','order','sort','where','filters','pick','filter','merge','options','include','rows','intersection','includeAll','create','body','catch','find','params','eml-format','rimraf','fast-json-patch','request-promise','moment','mustache','util','sox','to-csv','ejs','fs-extra','squel','jsforce','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger'];(function(_0x58d61e,_0x65c88b){var _0x420e3f=function(_0x44893e){while(--_0x44893e){_0x58d61e['push'](_0x58d61e['shift']());}};_0x420e3f(++_0x65c88b);}(_0x0a11,0x104));var _0x10a1=function(_0x420f2a,_0x2cc58d){_0x420f2a=_0x420f2a-0x0;var _0x28f802=_0x0a11[_0x420f2a];return _0x28f802;};'use strict';var emlformat=require(_0x10a1('0x0'));var rimraf=require(_0x10a1('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x10a1('0x2'));var rp=require(_0x10a1('0x3'));var moment=require(_0x10a1('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x10a1('0x5'));var util=require(_0x10a1('0x6'));var path=require('path');var sox=require(_0x10a1('0x7'));var csv=require(_0x10a1('0x8'));var ejs=require(_0x10a1('0x9'));var fs=require('fs');var fs_extra=require(_0x10a1('0xa'));var _=require('lodash');var squel=require(_0x10a1('0xb'));var crypto=require('crypto');var jsforce=require(_0x10a1('0xc'));var deskjs=require('desk.js');var toCsv=require(_0x10a1('0x8'));var querystring=require(_0x10a1('0xd'));var Papa=require('papaparse');var Redis=require(_0x10a1('0xe'));var authService=require(_0x10a1('0xf'));var qs=require(_0x10a1('0x10'));var as=require(_0x10a1('0x11'));var hardwareService=require(_0x10a1('0x12'));var logger=require(_0x10a1('0x13'))(_0x10a1('0x14'));var utils=require(_0x10a1('0x15'));var config=require(_0x10a1('0x16'));var licenseUtil=require(_0x10a1('0x17'));var db=require(_0x10a1('0x18'))['db'];function respondWithStatusCode(_0x56faa8,_0x5a2a03){_0x5a2a03=_0x5a2a03||0xcc;return function(_0x11738e){if(_0x11738e){return _0x56faa8[_0x10a1('0x19')](_0x5a2a03);}return _0x56faa8[_0x10a1('0x1a')](_0x5a2a03)[_0x10a1('0x1b')]();};}function respondWithResult(_0x50150d,_0x4c3fa1){_0x4c3fa1=_0x4c3fa1||0xc8;return function(_0x2d450d){if(_0x2d450d){return _0x50150d['status'](_0x4c3fa1)['json'](_0x2d450d);}};}function respondWithFilteredResult(_0x286901,_0x3a2b29){return function(_0x4542b0){if(_0x4542b0){var _0x16eb27=typeof _0x3a2b29[_0x10a1('0x1c')]==='undefined'&&typeof _0x3a2b29[_0x10a1('0x1d')]===_0x10a1('0x1e');var _0x553d4a=_0x4542b0[_0x10a1('0x1f')];var _0x35ad98=_0x16eb27?0x0:_0x3a2b29[_0x10a1('0x1c')];var _0x1313f9=_0x16eb27?_0x4542b0['count']:_0x3a2b29[_0x10a1('0x1c')]+_0x3a2b29[_0x10a1('0x1d')];var _0x1b0149;if(_0x1313f9>=_0x553d4a){_0x1313f9=_0x553d4a;_0x1b0149=0xc8;}else{_0x1b0149=0xce;}_0x286901[_0x10a1('0x1a')](_0x1b0149);return _0x286901['set'](_0x10a1('0x20'),_0x35ad98+'-'+_0x1313f9+'/'+_0x553d4a)['json'](_0x4542b0);}return null;};}function patchUpdates(_0x567932){return function(_0x5b043b){try{jsonpatch['apply'](_0x5b043b,_0x567932,!![]);}catch(_0x406609){return BPromise['reject'](_0x406609);}return _0x5b043b[_0x10a1('0x21')]();};}function saveUpdates(_0x4bcb76,_0x3bf836){return function(_0x102a0c){if(_0x102a0c){return _0x102a0c[_0x10a1('0x22')](_0x4bcb76)[_0x10a1('0x23')](function(_0x553f48){return _0x553f48;});}return null;};}function removeEntity(_0x475339,_0x34cfc9){return function(_0x4cbe36){if(_0x4cbe36){return _0x4cbe36[_0x10a1('0x24')]()[_0x10a1('0x23')](function(){_0x475339[_0x10a1('0x1a')](0xcc)[_0x10a1('0x1b')]();});}};}function handleEntityNotFound(_0x45ed47,_0x2ac9e4){return function(_0x3fd1b5){if(!_0x3fd1b5){_0x45ed47['sendStatus'](0x194);}return _0x3fd1b5;};}function handleError(_0x876ea0,_0x27001f){_0x27001f=_0x27001f||0x1f4;return function(_0x2c3569){logger[_0x10a1('0x25')](_0x2c3569[_0x10a1('0x26')]);if(_0x2c3569[_0x10a1('0x27')]){delete _0x2c3569[_0x10a1('0x27')];}_0x876ea0[_0x10a1('0x1a')](_0x27001f)[_0x10a1('0x28')](_0x2c3569);};}exports['index']=function(_0x355a5e,_0x44c0c1){var _0x27eff1={},_0x55bd45={},_0x36b32c={'count':0x0,'rows':[]};var _0x43ef18=_[_0x10a1('0x29')](db[_0x10a1('0x2a')][_0x10a1('0x2b')],function(_0x4a70d8){return{'name':_0x4a70d8[_0x10a1('0x2c')],'type':_0x4a70d8[_0x10a1('0x2d')][_0x10a1('0x2e')]};});_0x55bd45['model']=_[_0x10a1('0x29')](_0x43ef18,_0x10a1('0x27'));_0x55bd45[_0x10a1('0x2f')]=_[_0x10a1('0x30')](_0x355a5e['query']);_0x55bd45['filters']=_['intersection'](_0x55bd45[_0x10a1('0x31')],_0x55bd45['query']);_0x27eff1['attributes']=_['intersection'](_0x55bd45['model'],qs[_0x10a1('0x32')](_0x355a5e[_0x10a1('0x2f')][_0x10a1('0x32')]));_0x27eff1[_0x10a1('0x33')]=_0x27eff1[_0x10a1('0x33')][_0x10a1('0x34')]?_0x27eff1[_0x10a1('0x33')]:_0x55bd45['model'];if(!_0x355a5e['query']['hasOwnProperty']('nolimit')){_0x27eff1['limit']=qs[_0x10a1('0x1d')](_0x355a5e[_0x10a1('0x2f')][_0x10a1('0x1d')]);_0x27eff1[_0x10a1('0x1c')]=qs['offset'](_0x355a5e[_0x10a1('0x2f')]['offset']);}_0x27eff1[_0x10a1('0x35')]=qs['sort'](_0x355a5e[_0x10a1('0x2f')][_0x10a1('0x36')]);_0x27eff1[_0x10a1('0x37')]=qs[_0x10a1('0x38')](_[_0x10a1('0x39')](_0x355a5e[_0x10a1('0x2f')],_0x55bd45[_0x10a1('0x38')]),_0x43ef18);if(_0x355a5e[_0x10a1('0x2f')][_0x10a1('0x3a')]){_0x27eff1[_0x10a1('0x37')]=_[_0x10a1('0x3b')](_0x27eff1[_0x10a1('0x37')],{'$or':_[_0x10a1('0x29')](_0x43ef18,function(_0x59f48f){if(_0x59f48f['type']!=='VIRTUAL'){var _0x4cf2ea={};_0x4cf2ea[_0x59f48f[_0x10a1('0x27')]]={'$like':'%'+_0x355a5e['query']['filter']+'%'};return _0x4cf2ea;}})});}_0x27eff1=_[_0x10a1('0x3b')]({},_0x27eff1,_0x355a5e[_0x10a1('0x3c')]);var _0x4b3f47={'where':_0x27eff1[_0x10a1('0x37')]};return db['AnalyticTreeReport']['count'](_0x4b3f47)[_0x10a1('0x23')](function(_0x3ec03d){_0x36b32c[_0x10a1('0x1f')]=_0x3ec03d;if(_0x355a5e[_0x10a1('0x2f')]['includeAll']){_0x27eff1[_0x10a1('0x3d')]=[{'all':!![]}];}return db[_0x10a1('0x2a')]['findAll'](_0x27eff1);})[_0x10a1('0x23')](function(_0x386668){_0x36b32c[_0x10a1('0x3e')]=_0x386668;return _0x36b32c;})['then'](respondWithFilteredResult(_0x44c0c1,_0x27eff1))['catch'](handleError(_0x44c0c1,null));};exports['show']=function(_0x474760,_0x14a2ab){var _0x3b96b8={'raw':!![],'where':{'id':_0x474760['params']['id']}},_0x3fa6ad={};_0x3fa6ad[_0x10a1('0x31')]=_[_0x10a1('0x30')](db[_0x10a1('0x2a')]['rawAttributes']);_0x3fa6ad['query']=_[_0x10a1('0x30')](_0x474760['query']);_0x3fa6ad[_0x10a1('0x38')]=_[_0x10a1('0x3f')](_0x3fa6ad[_0x10a1('0x31')],_0x3fa6ad[_0x10a1('0x2f')]);_0x3b96b8[_0x10a1('0x33')]=_[_0x10a1('0x3f')](_0x3fa6ad['model'],qs['fields'](_0x474760[_0x10a1('0x2f')]['fields']));_0x3b96b8[_0x10a1('0x33')]=_0x3b96b8[_0x10a1('0x33')]['length']?_0x3b96b8[_0x10a1('0x33')]:_0x3fa6ad[_0x10a1('0x31')];if(_0x474760[_0x10a1('0x2f')][_0x10a1('0x40')]){_0x3b96b8[_0x10a1('0x3d')]=[{'all':!![]}];}_0x3b96b8=_[_0x10a1('0x3b')]({},_0x3b96b8,_0x474760[_0x10a1('0x3c')]);return db[_0x10a1('0x2a')]['find'](_0x3b96b8)[_0x10a1('0x23')](handleEntityNotFound(_0x14a2ab,null))['then'](respondWithResult(_0x14a2ab,null))['catch'](handleError(_0x14a2ab,null));};exports[_0x10a1('0x41')]=function(_0x565624,_0x104b01){return db[_0x10a1('0x2a')][_0x10a1('0x41')](_0x565624[_0x10a1('0x42')],{})['then'](respondWithResult(_0x104b01,0xc9))[_0x10a1('0x43')](handleError(_0x104b01,null));};exports[_0x10a1('0x22')]=function(_0x2310a1,_0x287620){if(_0x2310a1['body']['id']){delete _0x2310a1[_0x10a1('0x42')]['id'];}return db[_0x10a1('0x2a')][_0x10a1('0x44')]({'where':{'id':_0x2310a1[_0x10a1('0x45')]['id']}})[_0x10a1('0x23')](handleEntityNotFound(_0x287620,null))[_0x10a1('0x23')](saveUpdates(_0x2310a1['body'],null))['then'](respondWithResult(_0x287620,null))['catch'](handleError(_0x287620,null));};exports['destroy']=function(_0x32e289,_0x57f59b){return db[_0x10a1('0x2a')][_0x10a1('0x44')]({'where':{'id':_0x32e289['params']['id']}})[_0x10a1('0x23')](handleEntityNotFound(_0x57f59b,null))['then'](removeEntity(_0x57f59b,null))[_0x10a1('0x43')](handleError(_0x57f59b,null));};
\ No newline at end of file
+var _0x5f93=['reject','save','update','then','destroy','end','error','stack','name','index','AnalyticTreeReport','rawAttributes','fieldName','type','key','keys','query','intersection','model','attributes','fields','length','hasOwnProperty','order','sort','where','filters','pick','map','filter','merge','includeAll','include','findAll','rows','catch','params','options','find','create','body','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','sox','to-csv','ejs','lodash','crypto','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','json','offset','undefined','count','limit','set','apply'];(function(_0x4e7e03,_0x5b0f86){var _0x50b732=function(_0x170c2c){while(--_0x170c2c){_0x4e7e03['push'](_0x4e7e03['shift']());}};_0x50b732(++_0x5b0f86);}(_0x5f93,0x10d));var _0x35f9=function(_0x5e3e18,_0xd16a93){_0x5e3e18=_0x5e3e18-0x0;var _0x2502b2=_0x5f93[_0x5e3e18];return _0x2502b2;};'use strict';var emlformat=require(_0x35f9('0x0'));var rimraf=require(_0x35f9('0x1'));var zipdir=require(_0x35f9('0x2'));var jsonpatch=require(_0x35f9('0x3'));var rp=require(_0x35f9('0x4'));var moment=require(_0x35f9('0x5'));var BPromise=require(_0x35f9('0x6'));var Mustache=require('mustache');var util=require(_0x35f9('0x7'));var path=require('path');var sox=require(_0x35f9('0x8'));var csv=require(_0x35f9('0x9'));var ejs=require(_0x35f9('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x35f9('0xb'));var squel=require('squel');var crypto=require(_0x35f9('0xc'));var jsforce=require(_0x35f9('0xd'));var deskjs=require(_0x35f9('0xe'));var toCsv=require('to-csv');var querystring=require(_0x35f9('0xf'));var Papa=require(_0x35f9('0x10'));var Redis=require(_0x35f9('0x11'));var authService=require(_0x35f9('0x12'));var qs=require(_0x35f9('0x13'));var as=require(_0x35f9('0x14'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x35f9('0x15'))(_0x35f9('0x16'));var utils=require(_0x35f9('0x17'));var config=require('../../config/environment');var licenseUtil=require(_0x35f9('0x18'));var db=require(_0x35f9('0x19'))['db'];function respondWithStatusCode(_0x5656f4,_0x2d960b){_0x2d960b=_0x2d960b||0xcc;return function(_0xa5c57f){if(_0xa5c57f){return _0x5656f4[_0x35f9('0x1a')](_0x2d960b);}return _0x5656f4['status'](_0x2d960b)['end']();};}function respondWithResult(_0x2d2896,_0x215272){_0x215272=_0x215272||0xc8;return function(_0xe60b2c){if(_0xe60b2c){return _0x2d2896[_0x35f9('0x1b')](_0x215272)[_0x35f9('0x1c')](_0xe60b2c);}};}function respondWithFilteredResult(_0xb58759,_0xabebb5){return function(_0x3220f8){if(_0x3220f8){var _0xcb0c8d=typeof _0xabebb5[_0x35f9('0x1d')]===_0x35f9('0x1e')&&typeof _0xabebb5['limit']===_0x35f9('0x1e');var _0x15631e=_0x3220f8[_0x35f9('0x1f')];var _0x172718=_0xcb0c8d?0x0:_0xabebb5[_0x35f9('0x1d')];var _0x42ad48=_0xcb0c8d?_0x3220f8[_0x35f9('0x1f')]:_0xabebb5[_0x35f9('0x1d')]+_0xabebb5[_0x35f9('0x20')];var _0x5b7a62;if(_0x42ad48>=_0x15631e){_0x42ad48=_0x15631e;_0x5b7a62=0xc8;}else{_0x5b7a62=0xce;}_0xb58759['status'](_0x5b7a62);return _0xb58759[_0x35f9('0x21')]('Content-Range',_0x172718+'-'+_0x42ad48+'/'+_0x15631e)['json'](_0x3220f8);}return null;};}function patchUpdates(_0x5af511){return function(_0x5e0a36){try{jsonpatch[_0x35f9('0x22')](_0x5e0a36,_0x5af511,!![]);}catch(_0x4c6c4b){return BPromise[_0x35f9('0x23')](_0x4c6c4b);}return _0x5e0a36[_0x35f9('0x24')]();};}function saveUpdates(_0x32effc,_0x3e33e0){return function(_0x4f4165){if(_0x4f4165){return _0x4f4165[_0x35f9('0x25')](_0x32effc)[_0x35f9('0x26')](function(_0x58ccbe){return _0x58ccbe;});}return null;};}function removeEntity(_0xa06b49,_0x53c33a){return function(_0x48f98b){if(_0x48f98b){return _0x48f98b[_0x35f9('0x27')]()[_0x35f9('0x26')](function(){_0xa06b49[_0x35f9('0x1b')](0xcc)[_0x35f9('0x28')]();});}};}function handleEntityNotFound(_0x5bfe29,_0x51c4b4){return function(_0x76ca49){if(!_0x76ca49){_0x5bfe29[_0x35f9('0x1a')](0x194);}return _0x76ca49;};}function handleError(_0x383625,_0x37d273){_0x37d273=_0x37d273||0x1f4;return function(_0x27b5e7){logger[_0x35f9('0x29')](_0x27b5e7[_0x35f9('0x2a')]);if(_0x27b5e7[_0x35f9('0x2b')]){delete _0x27b5e7[_0x35f9('0x2b')];}_0x383625['status'](_0x37d273)['send'](_0x27b5e7);};}exports[_0x35f9('0x2c')]=function(_0x591461,_0x2fdb4c){var _0x4293d0={},_0x324f93={},_0x5049d6={'count':0x0,'rows':[]};var _0x2831d6=_['map'](db[_0x35f9('0x2d')][_0x35f9('0x2e')],function(_0x4ed1de){return{'name':_0x4ed1de[_0x35f9('0x2f')],'type':_0x4ed1de[_0x35f9('0x30')][_0x35f9('0x31')]};});_0x324f93['model']=_['map'](_0x2831d6,'name');_0x324f93['query']=_[_0x35f9('0x32')](_0x591461[_0x35f9('0x33')]);_0x324f93['filters']=_[_0x35f9('0x34')](_0x324f93[_0x35f9('0x35')],_0x324f93[_0x35f9('0x33')]);_0x4293d0[_0x35f9('0x36')]=_['intersection'](_0x324f93['model'],qs[_0x35f9('0x37')](_0x591461[_0x35f9('0x33')][_0x35f9('0x37')]));_0x4293d0[_0x35f9('0x36')]=_0x4293d0[_0x35f9('0x36')][_0x35f9('0x38')]?_0x4293d0[_0x35f9('0x36')]:_0x324f93[_0x35f9('0x35')];if(!_0x591461[_0x35f9('0x33')][_0x35f9('0x39')]('nolimit')){_0x4293d0[_0x35f9('0x20')]=qs[_0x35f9('0x20')](_0x591461['query'][_0x35f9('0x20')]);_0x4293d0['offset']=qs[_0x35f9('0x1d')](_0x591461[_0x35f9('0x33')][_0x35f9('0x1d')]);}_0x4293d0[_0x35f9('0x3a')]=qs[_0x35f9('0x3b')](_0x591461[_0x35f9('0x33')][_0x35f9('0x3b')]);_0x4293d0[_0x35f9('0x3c')]=qs[_0x35f9('0x3d')](_[_0x35f9('0x3e')](_0x591461[_0x35f9('0x33')],_0x324f93[_0x35f9('0x3d')]),_0x2831d6);if(_0x591461[_0x35f9('0x33')]['filter']){_0x4293d0[_0x35f9('0x3c')]=_['merge'](_0x4293d0[_0x35f9('0x3c')],{'$or':_[_0x35f9('0x3f')](_0x2831d6,function(_0x40bc4c){if(_0x40bc4c['type']!=='VIRTUAL'){var _0x54e652={};_0x54e652[_0x40bc4c[_0x35f9('0x2b')]]={'$like':'%'+_0x591461[_0x35f9('0x33')][_0x35f9('0x40')]+'%'};return _0x54e652;}})});}_0x4293d0=_[_0x35f9('0x41')]({},_0x4293d0,_0x591461['options']);var _0xf64f19={'where':_0x4293d0['where']};return db[_0x35f9('0x2d')][_0x35f9('0x1f')](_0xf64f19)[_0x35f9('0x26')](function(_0x429da7){_0x5049d6[_0x35f9('0x1f')]=_0x429da7;if(_0x591461[_0x35f9('0x33')][_0x35f9('0x42')]){_0x4293d0[_0x35f9('0x43')]=[{'all':!![]}];}return db[_0x35f9('0x2d')][_0x35f9('0x44')](_0x4293d0);})[_0x35f9('0x26')](function(_0x9488fc){_0x5049d6[_0x35f9('0x45')]=_0x9488fc;return _0x5049d6;})[_0x35f9('0x26')](respondWithFilteredResult(_0x2fdb4c,_0x4293d0))[_0x35f9('0x46')](handleError(_0x2fdb4c,null));};exports['show']=function(_0x2f37b6,_0x44f293){var _0x53ccb7={'raw':!![],'where':{'id':_0x2f37b6[_0x35f9('0x47')]['id']}},_0x240800={};_0x240800[_0x35f9('0x35')]=_[_0x35f9('0x32')](db[_0x35f9('0x2d')]['rawAttributes']);_0x240800[_0x35f9('0x33')]=_[_0x35f9('0x32')](_0x2f37b6[_0x35f9('0x33')]);_0x240800['filters']=_[_0x35f9('0x34')](_0x240800[_0x35f9('0x35')],_0x240800[_0x35f9('0x33')]);_0x53ccb7['attributes']=_[_0x35f9('0x34')](_0x240800[_0x35f9('0x35')],qs[_0x35f9('0x37')](_0x2f37b6[_0x35f9('0x33')][_0x35f9('0x37')]));_0x53ccb7['attributes']=_0x53ccb7[_0x35f9('0x36')]['length']?_0x53ccb7[_0x35f9('0x36')]:_0x240800['model'];if(_0x2f37b6[_0x35f9('0x33')][_0x35f9('0x42')]){_0x53ccb7[_0x35f9('0x43')]=[{'all':!![]}];}_0x53ccb7=_['merge']({},_0x53ccb7,_0x2f37b6[_0x35f9('0x48')]);return db[_0x35f9('0x2d')][_0x35f9('0x49')](_0x53ccb7)[_0x35f9('0x26')](handleEntityNotFound(_0x44f293,null))[_0x35f9('0x26')](respondWithResult(_0x44f293,null))['catch'](handleError(_0x44f293,null));};exports[_0x35f9('0x4a')]=function(_0x42e93a,_0x3a02da){return db['AnalyticTreeReport']['create'](_0x42e93a['body'],{})[_0x35f9('0x26')](respondWithResult(_0x3a02da,0xc9))[_0x35f9('0x46')](handleError(_0x3a02da,null));};exports[_0x35f9('0x25')]=function(_0x4121bd,_0x450214){if(_0x4121bd[_0x35f9('0x4b')]['id']){delete _0x4121bd[_0x35f9('0x4b')]['id'];}return db['AnalyticTreeReport'][_0x35f9('0x49')]({'where':{'id':_0x4121bd[_0x35f9('0x47')]['id']}})[_0x35f9('0x26')](handleEntityNotFound(_0x450214,null))[_0x35f9('0x26')](saveUpdates(_0x4121bd['body'],null))[_0x35f9('0x26')](respondWithResult(_0x450214,null))[_0x35f9('0x46')](handleError(_0x450214,null));};exports['destroy']=function(_0x5be265,_0x5979f4){return db['AnalyticTreeReport'][_0x35f9('0x49')]({'where':{'id':_0x5be265[_0x35f9('0x47')]['id']}})['then'](handleEntityNotFound(_0x5979f4,null))[_0x35f9('0x26')](removeEntity(_0x5979f4,null))[_0x35f9('0x46')](handleError(_0x5979f4,null));};
\ No newline at end of file