Built motion from commit a61a4a20.|2.5.46
[motion2.git] / server / api / jscriptyAnswerReport / jscriptyAnswerReport.controller.js
index 046ca06..24b6100 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x975b=['ejs','fs-extra','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../config/license/hardware','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','undefined','count','offset','set','Content-Range','apply','reject','update','then','destroy','stack','name','send','index','map','JscriptyAnswerReport','rawAttributes','fieldName','type','key','model','query','filters','intersection','fields','attributes','hasOwnProperty','nolimit','limit','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','include','rows','show','params','length','find','create','body','catch','describe','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv'];(function(_0x188a57,_0x3f7985){var _0x4800c0=function(_0x2fb34a){while(--_0x2fb34a){_0x188a57['push'](_0x188a57['shift']());}};_0x4800c0(++_0x3f7985);}(_0x975b,0x1c9));var _0xb975=function(_0x45a6fe,_0xa15083){_0x45a6fe=_0x45a6fe-0x0;var _0x50ab33=_0x975b[_0x45a6fe];return _0x50ab33;};'use strict';var emlformat=require(_0xb975('0x0'));var rimraf=require(_0xb975('0x1'));var zipdir=require(_0xb975('0x2'));var jsonpatch=require(_0xb975('0x3'));var rp=require(_0xb975('0x4'));var moment=require(_0xb975('0x5'));var BPromise=require(_0xb975('0x6'));var Mustache=require('mustache');var util=require(_0xb975('0x7'));var path=require(_0xb975('0x8'));var sox=require(_0xb975('0x9'));var csv=require(_0xb975('0xa'));var ejs=require(_0xb975('0xb'));var fs=require('fs');var fs_extra=require(_0xb975('0xc'));var _=require(_0xb975('0xd'));var squel=require('squel');var crypto=require(_0xb975('0xe'));var jsforce=require(_0xb975('0xf'));var deskjs=require(_0xb975('0x10'));var toCsv=require('to-csv');var querystring=require(_0xb975('0x11'));var Papa=require(_0xb975('0x12'));var Redis=require(_0xb975('0x13'));var authService=require('../../components/auth/service');var qs=require(_0xb975('0x14'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xb975('0x15'));var logger=require('../../config/logger')(_0xb975('0x16'));var utils=require('../../config/utils');var config=require(_0xb975('0x17'));var licenseUtil=require(_0xb975('0x18'));var db=require(_0xb975('0x19'))['db'];function respondWithStatusCode(_0x1c4b77,_0x13ca28){_0x13ca28=_0x13ca28||0xcc;return function(_0x558727){if(_0x558727){return _0x1c4b77[_0xb975('0x1a')](_0x13ca28);}return _0x1c4b77[_0xb975('0x1b')](_0x13ca28)[_0xb975('0x1c')]();};}function respondWithResult(_0x24919e,_0x5cea50){_0x5cea50=_0x5cea50||0xc8;return function(_0x470ead){if(_0x470ead){return _0x24919e[_0xb975('0x1b')](_0x5cea50)[_0xb975('0x1d')](_0x470ead);}};}function respondWithFilteredResult(_0x4b1ede,_0x24f8ec){return function(_0x3da9e9){if(_0x3da9e9){var _0x36d959=typeof _0x24f8ec['offset']===_0xb975('0x1e')&&typeof _0x24f8ec['limit']===_0xb975('0x1e');var _0x34e062=_0x3da9e9[_0xb975('0x1f')];var _0x347a04=_0x36d959?0x0:_0x24f8ec[_0xb975('0x20')];var _0x327728=_0x36d959?_0x3da9e9[_0xb975('0x1f')]:_0x24f8ec['offset']+_0x24f8ec['limit'];var _0x2abb84;if(_0x327728>=_0x34e062){_0x327728=_0x34e062;_0x2abb84=0xc8;}else{_0x2abb84=0xce;}_0x4b1ede[_0xb975('0x1b')](_0x2abb84);return _0x4b1ede[_0xb975('0x21')](_0xb975('0x22'),_0x347a04+'-'+_0x327728+'/'+_0x34e062)['json'](_0x3da9e9);}return null;};}function patchUpdates(_0x39af85){return function(_0x49adfa){try{jsonpatch[_0xb975('0x23')](_0x49adfa,_0x39af85,!![]);}catch(_0x3f0876){return BPromise[_0xb975('0x24')](_0x3f0876);}return _0x49adfa['save']();};}function saveUpdates(_0xe7a5f0,_0x493c0b){return function(_0x5d1312){if(_0x5d1312){return _0x5d1312[_0xb975('0x25')](_0xe7a5f0)[_0xb975('0x26')](function(_0x226f21){return _0x226f21;});}return null;};}function removeEntity(_0xa4d4c,_0x35dcc6){return function(_0x5620fc){if(_0x5620fc){return _0x5620fc[_0xb975('0x27')]()['then'](function(){_0xa4d4c[_0xb975('0x1b')](0xcc)[_0xb975('0x1c')]();});}};}function handleEntityNotFound(_0xc0d861,_0x263f73){return function(_0x5309c6){if(!_0x5309c6){_0xc0d861[_0xb975('0x1a')](0x194);}return _0x5309c6;};}function handleError(_0x2824bf,_0x41905e){_0x41905e=_0x41905e||0x1f4;return function(_0xed596){logger['error'](_0xed596[_0xb975('0x28')]);if(_0xed596[_0xb975('0x29')]){delete _0xed596[_0xb975('0x29')];}_0x2824bf[_0xb975('0x1b')](_0x41905e)[_0xb975('0x2a')](_0xed596);};}exports[_0xb975('0x2b')]=function(_0x442bc6,_0x135cc9){var _0x2d730d={},_0x514451={},_0x2b1319={'count':0x0,'rows':[]};var _0x2b3ec2=_[_0xb975('0x2c')](db[_0xb975('0x2d')][_0xb975('0x2e')],function(_0x3bd5cb){return{'name':_0x3bd5cb[_0xb975('0x2f')],'type':_0x3bd5cb[_0xb975('0x30')][_0xb975('0x31')]};});_0x514451[_0xb975('0x32')]=_[_0xb975('0x2c')](_0x2b3ec2,'name');_0x514451[_0xb975('0x33')]=_['keys'](_0x442bc6['query']);_0x514451[_0xb975('0x34')]=_['intersection'](_0x514451[_0xb975('0x32')],_0x514451[_0xb975('0x33')]);_0x2d730d['attributes']=_[_0xb975('0x35')](_0x514451['model'],qs[_0xb975('0x36')](_0x442bc6[_0xb975('0x33')][_0xb975('0x36')]));_0x2d730d[_0xb975('0x37')]=_0x2d730d[_0xb975('0x37')]['length']?_0x2d730d[_0xb975('0x37')]:_0x514451['model'];if(!_0x442bc6['query'][_0xb975('0x38')](_0xb975('0x39'))){_0x2d730d[_0xb975('0x3a')]=qs[_0xb975('0x3a')](_0x442bc6[_0xb975('0x33')][_0xb975('0x3a')]);_0x2d730d[_0xb975('0x20')]=qs[_0xb975('0x20')](_0x442bc6['query'][_0xb975('0x20')]);}_0x2d730d[_0xb975('0x3b')]=qs['sort'](_0x442bc6[_0xb975('0x33')][_0xb975('0x3c')]);_0x2d730d[_0xb975('0x3d')]=qs[_0xb975('0x34')](_[_0xb975('0x3e')](_0x442bc6[_0xb975('0x33')],_0x514451[_0xb975('0x34')]),_0x2b3ec2);if(_0x442bc6['query'][_0xb975('0x3f')]){_0x2d730d['where']=_[_0xb975('0x40')](_0x2d730d[_0xb975('0x3d')],{'$or':_['map'](_0x2b3ec2,function(_0x2341e6){if(_0x2341e6['type']!==_0xb975('0x41')){var _0x378e54={};_0x378e54[_0x2341e6[_0xb975('0x29')]]={'$like':'%'+_0x442bc6[_0xb975('0x33')][_0xb975('0x3f')]+'%'};return _0x378e54;}})});}_0x2d730d=_[_0xb975('0x40')]({},_0x2d730d,_0x442bc6[_0xb975('0x42')]);var _0x2781ab={'where':_0x2d730d['where']};return db[_0xb975('0x2d')][_0xb975('0x1f')](_0x2781ab)[_0xb975('0x26')](function(_0x562e0d){_0x2b1319['count']=_0x562e0d;if(_0x442bc6[_0xb975('0x33')][_0xb975('0x43')]){_0x2d730d[_0xb975('0x44')]=[{'all':!![]}];}return db['JscriptyAnswerReport']['findAll'](_0x2d730d);})[_0xb975('0x26')](function(_0x335011){_0x2b1319[_0xb975('0x45')]=_0x335011;return _0x2b1319;})[_0xb975('0x26')](respondWithFilteredResult(_0x135cc9,_0x2d730d))['catch'](handleError(_0x135cc9,null));};exports[_0xb975('0x46')]=function(_0x17d594,_0xe5c7e7){var _0x160e58={'raw':!![],'where':{'id':_0x17d594[_0xb975('0x47')]['id']}},_0x55f550={};_0x55f550[_0xb975('0x32')]=_['keys'](db['JscriptyAnswerReport'][_0xb975('0x2e')]);_0x55f550['query']=_['keys'](_0x17d594[_0xb975('0x33')]);_0x55f550['filters']=_[_0xb975('0x35')](_0x55f550[_0xb975('0x32')],_0x55f550['query']);_0x160e58[_0xb975('0x37')]=_[_0xb975('0x35')](_0x55f550[_0xb975('0x32')],qs[_0xb975('0x36')](_0x17d594[_0xb975('0x33')]['fields']));_0x160e58[_0xb975('0x37')]=_0x160e58[_0xb975('0x37')][_0xb975('0x48')]?_0x160e58['attributes']:_0x55f550[_0xb975('0x32')];if(_0x17d594[_0xb975('0x33')][_0xb975('0x43')]){_0x160e58['include']=[{'all':!![]}];}_0x160e58=_[_0xb975('0x40')]({},_0x160e58,_0x17d594[_0xb975('0x42')]);return db[_0xb975('0x2d')][_0xb975('0x49')](_0x160e58)['then'](handleEntityNotFound(_0xe5c7e7,null))['then'](respondWithResult(_0xe5c7e7,null))['catch'](handleError(_0xe5c7e7,null));};exports[_0xb975('0x4a')]=function(_0x4483ba,_0x15bc77){return db[_0xb975('0x2d')][_0xb975('0x4a')](_0x4483ba[_0xb975('0x4b')],{})[_0xb975('0x26')](respondWithResult(_0x15bc77,0xc9))[_0xb975('0x4c')](handleError(_0x15bc77,null));};exports[_0xb975('0x25')]=function(_0x466251,_0x1a3268){if(_0x466251['body']['id']){delete _0x466251[_0xb975('0x4b')]['id'];}return db['JscriptyAnswerReport']['find']({'where':{'id':_0x466251['params']['id']}})[_0xb975('0x26')](handleEntityNotFound(_0x1a3268,null))[_0xb975('0x26')](saveUpdates(_0x466251['body'],null))[_0xb975('0x26')](respondWithResult(_0x1a3268,null))[_0xb975('0x4c')](handleError(_0x1a3268,null));};exports[_0xb975('0x27')]=function(_0x22743c,_0x1f9544){return db[_0xb975('0x2d')][_0xb975('0x49')]({'where':{'id':_0x22743c[_0xb975('0x47')]['id']}})[_0xb975('0x26')](handleEntityNotFound(_0x1f9544,null))['then'](removeEntity(_0x1f9544,null))['catch'](handleError(_0x1f9544,null));};exports['describe']=function(_0x3cedf9,_0x1a1f97){return db['JscriptyAnswerReport'][_0xb975('0x4d')]()[_0xb975('0x26')](respondWithResult(_0x1a1f97,null))[_0xb975('0x4c')](handleError(_0x1a1f97,null));};
\ No newline at end of file
+var _0x11e5=['lodash','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../mysqldb','sendStatus','status','json','offset','limit','undefined','set','Content-Range','apply','save','update','then','error','stack','name','index','rawAttributes','fieldName','type','key','map','query','keys','intersection','model','attributes','fields','length','hasOwnProperty','order','sort','where','filters','filter','merge','VIRTUAL','count','includeAll','include','JscriptyAnswerReport','findAll','rows','catch','show','params','options','find','create','body','destroy','describe','eml-format','zip-dir','fast-json-patch','moment','bluebird','mustache','path','ejs','fs-extra'];(function(_0x436981,_0x371571){var _0x2e4f86=function(_0x2da649){while(--_0x2da649){_0x436981['push'](_0x436981['shift']());}};_0x2e4f86(++_0x371571);}(_0x11e5,0x8b));var _0x511e=function(_0x2a50fc,_0x792726){_0x2a50fc=_0x2a50fc-0x0;var _0x5aa6a2=_0x11e5[_0x2a50fc];return _0x5aa6a2;};'use strict';var emlformat=require(_0x511e('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x511e('0x1'));var jsonpatch=require(_0x511e('0x2'));var rp=require('request-promise');var moment=require(_0x511e('0x3'));var BPromise=require(_0x511e('0x4'));var Mustache=require(_0x511e('0x5'));var util=require('util');var path=require(_0x511e('0x6'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x511e('0x7'));var fs=require('fs');var fs_extra=require(_0x511e('0x8'));var _=require(_0x511e('0x9'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x511e('0xa'));var deskjs=require(_0x511e('0xb'));var toCsv=require(_0x511e('0xc'));var querystring=require(_0x511e('0xd'));var Papa=require(_0x511e('0xe'));var Redis=require(_0x511e('0xf'));var authService=require(_0x511e('0x10'));var qs=require(_0x511e('0x11'));var as=require(_0x511e('0x12'));var hardwareService=require(_0x511e('0x13'));var logger=require(_0x511e('0x14'))('api');var utils=require(_0x511e('0x15'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0x511e('0x16'))['db'];function respondWithStatusCode(_0x327880,_0x42679e){_0x42679e=_0x42679e||0xcc;return function(_0x258e2f){if(_0x258e2f){return _0x327880[_0x511e('0x17')](_0x42679e);}return _0x327880[_0x511e('0x18')](_0x42679e)['end']();};}function respondWithResult(_0xdd0dcd,_0x33fd64){_0x33fd64=_0x33fd64||0xc8;return function(_0x4e6507){if(_0x4e6507){return _0xdd0dcd[_0x511e('0x18')](_0x33fd64)[_0x511e('0x19')](_0x4e6507);}};}function respondWithFilteredResult(_0x4f50b9,_0xed773e){return function(_0x162c91){if(_0x162c91){var _0x3b990b=typeof _0xed773e[_0x511e('0x1a')]==='undefined'&&typeof _0xed773e[_0x511e('0x1b')]===_0x511e('0x1c');var _0x2e66b6=_0x162c91['count'];var _0x26af67=_0x3b990b?0x0:_0xed773e['offset'];var _0x34e6cd=_0x3b990b?_0x162c91['count']:_0xed773e['offset']+_0xed773e[_0x511e('0x1b')];var _0x5c4fb9;if(_0x34e6cd>=_0x2e66b6){_0x34e6cd=_0x2e66b6;_0x5c4fb9=0xc8;}else{_0x5c4fb9=0xce;}_0x4f50b9[_0x511e('0x18')](_0x5c4fb9);return _0x4f50b9[_0x511e('0x1d')](_0x511e('0x1e'),_0x26af67+'-'+_0x34e6cd+'/'+_0x2e66b6)[_0x511e('0x19')](_0x162c91);}return null;};}function patchUpdates(_0xd4df6f){return function(_0x3d3f46){try{jsonpatch[_0x511e('0x1f')](_0x3d3f46,_0xd4df6f,!![]);}catch(_0x452f20){return BPromise['reject'](_0x452f20);}return _0x3d3f46[_0x511e('0x20')]();};}function saveUpdates(_0x39e0b4,_0x2ebf30){return function(_0x1a273b){if(_0x1a273b){return _0x1a273b[_0x511e('0x21')](_0x39e0b4)[_0x511e('0x22')](function(_0x886b6){return _0x886b6;});}return null;};}function removeEntity(_0x2f28fc,_0x211b90){return function(_0x26618d){if(_0x26618d){return _0x26618d['destroy']()['then'](function(){_0x2f28fc[_0x511e('0x18')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1ff5c4,_0x53017d){return function(_0x3fbd19){if(!_0x3fbd19){_0x1ff5c4[_0x511e('0x17')](0x194);}return _0x3fbd19;};}function handleError(_0x406dfb,_0x1f8040){_0x1f8040=_0x1f8040||0x1f4;return function(_0x1bb7f9){logger[_0x511e('0x23')](_0x1bb7f9[_0x511e('0x24')]);if(_0x1bb7f9[_0x511e('0x25')]){delete _0x1bb7f9[_0x511e('0x25')];}_0x406dfb[_0x511e('0x18')](_0x1f8040)['send'](_0x1bb7f9);};}exports[_0x511e('0x26')]=function(_0x1d754d,_0xb563f6){var _0x1aaac1={},_0x369be6={},_0x50305a={'count':0x0,'rows':[]};var _0x431b75=_['map'](db['JscriptyAnswerReport'][_0x511e('0x27')],function(_0xb1d444){return{'name':_0xb1d444[_0x511e('0x28')],'type':_0xb1d444[_0x511e('0x29')][_0x511e('0x2a')]};});_0x369be6['model']=_[_0x511e('0x2b')](_0x431b75,_0x511e('0x25'));_0x369be6[_0x511e('0x2c')]=_[_0x511e('0x2d')](_0x1d754d[_0x511e('0x2c')]);_0x369be6['filters']=_[_0x511e('0x2e')](_0x369be6[_0x511e('0x2f')],_0x369be6[_0x511e('0x2c')]);_0x1aaac1[_0x511e('0x30')]=_[_0x511e('0x2e')](_0x369be6[_0x511e('0x2f')],qs[_0x511e('0x31')](_0x1d754d[_0x511e('0x2c')]['fields']));_0x1aaac1[_0x511e('0x30')]=_0x1aaac1[_0x511e('0x30')][_0x511e('0x32')]?_0x1aaac1[_0x511e('0x30')]:_0x369be6['model'];if(!_0x1d754d['query'][_0x511e('0x33')]('nolimit')){_0x1aaac1['limit']=qs[_0x511e('0x1b')](_0x1d754d[_0x511e('0x2c')][_0x511e('0x1b')]);_0x1aaac1[_0x511e('0x1a')]=qs[_0x511e('0x1a')](_0x1d754d['query'][_0x511e('0x1a')]);}_0x1aaac1[_0x511e('0x34')]=qs[_0x511e('0x35')](_0x1d754d['query'][_0x511e('0x35')]);_0x1aaac1[_0x511e('0x36')]=qs[_0x511e('0x37')](_['pick'](_0x1d754d[_0x511e('0x2c')],_0x369be6[_0x511e('0x37')]),_0x431b75);if(_0x1d754d['query'][_0x511e('0x38')]){_0x1aaac1[_0x511e('0x36')]=_[_0x511e('0x39')](_0x1aaac1[_0x511e('0x36')],{'$or':_[_0x511e('0x2b')](_0x431b75,function(_0x1a989a){if(_0x1a989a[_0x511e('0x29')]!==_0x511e('0x3a')){var _0xde4b8={};_0xde4b8[_0x1a989a[_0x511e('0x25')]]={'$like':'%'+_0x1d754d[_0x511e('0x2c')]['filter']+'%'};return _0xde4b8;}})});}_0x1aaac1=_[_0x511e('0x39')]({},_0x1aaac1,_0x1d754d['options']);var _0x51716f={'where':_0x1aaac1[_0x511e('0x36')]};return db['JscriptyAnswerReport']['count'](_0x51716f)[_0x511e('0x22')](function(_0x200207){_0x50305a[_0x511e('0x3b')]=_0x200207;if(_0x1d754d[_0x511e('0x2c')][_0x511e('0x3c')]){_0x1aaac1[_0x511e('0x3d')]=[{'all':!![]}];}return db[_0x511e('0x3e')][_0x511e('0x3f')](_0x1aaac1);})[_0x511e('0x22')](function(_0x396542){_0x50305a[_0x511e('0x40')]=_0x396542;return _0x50305a;})[_0x511e('0x22')](respondWithFilteredResult(_0xb563f6,_0x1aaac1))[_0x511e('0x41')](handleError(_0xb563f6,null));};exports[_0x511e('0x42')]=function(_0x5086e0,_0x5a7a12){var _0x19ffde={'raw':!![],'where':{'id':_0x5086e0[_0x511e('0x43')]['id']}},_0x29dcc1={};_0x29dcc1[_0x511e('0x2f')]=_[_0x511e('0x2d')](db['JscriptyAnswerReport'][_0x511e('0x27')]);_0x29dcc1[_0x511e('0x2c')]=_[_0x511e('0x2d')](_0x5086e0['query']);_0x29dcc1['filters']=_['intersection'](_0x29dcc1[_0x511e('0x2f')],_0x29dcc1[_0x511e('0x2c')]);_0x19ffde[_0x511e('0x30')]=_['intersection'](_0x29dcc1['model'],qs['fields'](_0x5086e0[_0x511e('0x2c')][_0x511e('0x31')]));_0x19ffde[_0x511e('0x30')]=_0x19ffde[_0x511e('0x30')][_0x511e('0x32')]?_0x19ffde[_0x511e('0x30')]:_0x29dcc1[_0x511e('0x2f')];if(_0x5086e0[_0x511e('0x2c')][_0x511e('0x3c')]){_0x19ffde[_0x511e('0x3d')]=[{'all':!![]}];}_0x19ffde=_[_0x511e('0x39')]({},_0x19ffde,_0x5086e0[_0x511e('0x44')]);return db[_0x511e('0x3e')][_0x511e('0x45')](_0x19ffde)[_0x511e('0x22')](handleEntityNotFound(_0x5a7a12,null))[_0x511e('0x22')](respondWithResult(_0x5a7a12,null))[_0x511e('0x41')](handleError(_0x5a7a12,null));};exports[_0x511e('0x46')]=function(_0x3a8395,_0x2c2573){return db[_0x511e('0x3e')][_0x511e('0x46')](_0x3a8395[_0x511e('0x47')],{})[_0x511e('0x22')](respondWithResult(_0x2c2573,0xc9))[_0x511e('0x41')](handleError(_0x2c2573,null));};exports[_0x511e('0x21')]=function(_0x3d6f6e,_0x31e949){if(_0x3d6f6e[_0x511e('0x47')]['id']){delete _0x3d6f6e[_0x511e('0x47')]['id'];}return db[_0x511e('0x3e')]['find']({'where':{'id':_0x3d6f6e[_0x511e('0x43')]['id']}})['then'](handleEntityNotFound(_0x31e949,null))[_0x511e('0x22')](saveUpdates(_0x3d6f6e[_0x511e('0x47')],null))[_0x511e('0x22')](respondWithResult(_0x31e949,null))['catch'](handleError(_0x31e949,null));};exports[_0x511e('0x48')]=function(_0x1217df,_0x33d555){return db['JscriptyAnswerReport'][_0x511e('0x45')]({'where':{'id':_0x1217df[_0x511e('0x43')]['id']}})['then'](handleEntityNotFound(_0x33d555,null))[_0x511e('0x22')](removeEntity(_0x33d555,null))[_0x511e('0x41')](handleError(_0x33d555,null));};exports[_0x511e('0x49')]=function(_0x32df56,_0x523669){return db[_0x511e('0x3e')]['describe']()[_0x511e('0x22')](respondWithResult(_0x523669,null))[_0x511e('0x41')](handleError(_0x523669,null));};
\ No newline at end of file