Built motion from commit 97153652.|2.6.26
[motion2.git] / server / api / intDynamics365Field / intDynamics365Field.controller.js
index 4c87129..ffd9d56 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x220e=['../../config/license/hardware','../../config/logger','../../config/environment','status','offset','limit','count','set','json','reject','save','update','then','destroy','end','sendStatus','error','stack','name','send','index','fieldName','key','model','map','keys','query','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge','type','VIRTUAL','options','Dynamics365Field','includeAll','include','findAll','rows','catch','show','params','find','create','body','zip-dir','fast-json-patch','moment','bluebird','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch'];(function(_0x1ec7df,_0x48710d){var _0x800bc3=function(_0x3faf00){while(--_0x3faf00){_0x1ec7df['push'](_0x1ec7df['shift']());}};_0x800bc3(++_0x48710d);}(_0x220e,0x1a3));var _0xe220=function(_0x17fea7,_0x102927){_0x17fea7=_0x17fea7-0x0;var _0x3150c3=_0x220e[_0x17fea7];return _0x3150c3;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0xe220('0x0'));var jsonpatch=require(_0xe220('0x1'));var rp=require('request-promise');var moment=require(_0xe220('0x2'));var BPromise=require(_0xe220('0x3'));var Mustache=require('mustache');var util=require(_0xe220('0x4'));var path=require(_0xe220('0x5'));var sox=require(_0xe220('0x6'));var csv=require(_0xe220('0x7'));var ejs=require(_0xe220('0x8'));var fs=require('fs');var fs_extra=require(_0xe220('0x9'));var _=require(_0xe220('0xa'));var squel=require(_0xe220('0xb'));var crypto=require('crypto');var jsforce=require(_0xe220('0xc'));var deskjs=require(_0xe220('0xd'));var toCsv=require('to-csv');var querystring=require(_0xe220('0xe'));var Papa=require(_0xe220('0xf'));var Redis=require(_0xe220('0x10'));var authService=require('../../components/auth/service');var qs=require(_0xe220('0x11'));var as=require(_0xe220('0x12'));var hardwareService=require(_0xe220('0x13'));var logger=require(_0xe220('0x14'))('api');var utils=require('../../config/utils');var config=require(_0xe220('0x15'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x3ea0d6,_0x23596f){_0x23596f=_0x23596f||0xcc;return function(_0x3bae18){if(_0x3bae18){return _0x3ea0d6['sendStatus'](_0x23596f);}return _0x3ea0d6['status'](_0x23596f)['end']();};}function respondWithResult(_0x40cb6d,_0x298028){_0x298028=_0x298028||0xc8;return function(_0x51dece){if(_0x51dece){return _0x40cb6d[_0xe220('0x16')](_0x298028)['json'](_0x51dece);}};}function respondWithFilteredResult(_0x268058,_0x14e6f8){return function(_0x5c5d64){if(_0x5c5d64){var _0x566fba=typeof _0x14e6f8[_0xe220('0x17')]==='undefined'&&typeof _0x14e6f8[_0xe220('0x18')]==='undefined';var _0x5f033d=_0x5c5d64[_0xe220('0x19')];var _0x5e21ba=_0x566fba?0x0:_0x14e6f8[_0xe220('0x17')];var _0x343d12=_0x566fba?_0x5c5d64[_0xe220('0x19')]:_0x14e6f8[_0xe220('0x17')]+_0x14e6f8[_0xe220('0x18')];var _0x1dd904;if(_0x343d12>=_0x5f033d){_0x343d12=_0x5f033d;_0x1dd904=0xc8;}else{_0x1dd904=0xce;}_0x268058[_0xe220('0x16')](_0x1dd904);return _0x268058[_0xe220('0x1a')]('Content-Range',_0x5e21ba+'-'+_0x343d12+'/'+_0x5f033d)[_0xe220('0x1b')](_0x5c5d64);}return null;};}function patchUpdates(_0x3720c0){return function(_0x30becc){try{jsonpatch['apply'](_0x30becc,_0x3720c0,!![]);}catch(_0x5e06a1){return BPromise[_0xe220('0x1c')](_0x5e06a1);}return _0x30becc[_0xe220('0x1d')]();};}function saveUpdates(_0xdad07b,_0x2621ea){return function(_0xae0531){if(_0xae0531){return _0xae0531[_0xe220('0x1e')](_0xdad07b)[_0xe220('0x1f')](function(_0x4264a7){return _0x4264a7;});}return null;};}function removeEntity(_0x4c3080,_0x231ee0){return function(_0x2de74a){if(_0x2de74a){return _0x2de74a[_0xe220('0x20')]()[_0xe220('0x1f')](function(){_0x4c3080[_0xe220('0x16')](0xcc)[_0xe220('0x21')]();});}};}function handleEntityNotFound(_0x54537d,_0x1f20d7){return function(_0x52be2c){if(!_0x52be2c){_0x54537d[_0xe220('0x22')](0x194);}return _0x52be2c;};}function handleError(_0x5c26e4,_0x5caef6){_0x5caef6=_0x5caef6||0x1f4;return function(_0x1d87a0){logger[_0xe220('0x23')](_0x1d87a0[_0xe220('0x24')]);if(_0x1d87a0[_0xe220('0x25')]){delete _0x1d87a0['name'];}_0x5c26e4['status'](_0x5caef6)[_0xe220('0x26')](_0x1d87a0);};}exports[_0xe220('0x27')]=function(_0x652043,_0x469641){var _0x5b04b8={},_0x49fefa={},_0x3d71f4={'count':0x0,'rows':[]};var _0x2b9692=_['map'](db['Dynamics365Field']['rawAttributes'],function(_0x9c121e){return{'name':_0x9c121e[_0xe220('0x28')],'type':_0x9c121e['type'][_0xe220('0x29')]};});_0x49fefa[_0xe220('0x2a')]=_[_0xe220('0x2b')](_0x2b9692,_0xe220('0x25'));_0x49fefa['query']=_[_0xe220('0x2c')](_0x652043[_0xe220('0x2d')]);_0x49fefa['filters']=_[_0xe220('0x2e')](_0x49fefa[_0xe220('0x2a')],_0x49fefa['query']);_0x5b04b8[_0xe220('0x2f')]=_['intersection'](_0x49fefa['model'],qs[_0xe220('0x30')](_0x652043[_0xe220('0x2d')]['fields']));_0x5b04b8['attributes']=_0x5b04b8[_0xe220('0x2f')][_0xe220('0x31')]?_0x5b04b8[_0xe220('0x2f')]:_0x49fefa[_0xe220('0x2a')];if(!_0x652043[_0xe220('0x2d')][_0xe220('0x32')](_0xe220('0x33'))){_0x5b04b8[_0xe220('0x18')]=qs['limit'](_0x652043[_0xe220('0x2d')]['limit']);_0x5b04b8[_0xe220('0x17')]=qs[_0xe220('0x17')](_0x652043[_0xe220('0x2d')]['offset']);}_0x5b04b8[_0xe220('0x34')]=qs[_0xe220('0x35')](_0x652043['query']['sort']);_0x5b04b8[_0xe220('0x36')]=qs[_0xe220('0x37')](_[_0xe220('0x38')](_0x652043[_0xe220('0x2d')],_0x49fefa[_0xe220('0x37')]),_0x2b9692);if(_0x652043[_0xe220('0x2d')][_0xe220('0x39')]){_0x5b04b8['where']=_[_0xe220('0x3a')](_0x5b04b8[_0xe220('0x36')],{'$or':_[_0xe220('0x2b')](_0x2b9692,function(_0x294408){if(_0x294408[_0xe220('0x3b')]!==_0xe220('0x3c')){var _0x5a42b3={};_0x5a42b3[_0x294408['name']]={'$like':'%'+_0x652043['query'][_0xe220('0x39')]+'%'};return _0x5a42b3;}})});}_0x5b04b8=_['merge']({},_0x5b04b8,_0x652043[_0xe220('0x3d')]);var _0x3e2c19={'where':_0x5b04b8[_0xe220('0x36')]};return db[_0xe220('0x3e')]['count'](_0x3e2c19)[_0xe220('0x1f')](function(_0x57b5ab){_0x3d71f4['count']=_0x57b5ab;if(_0x652043[_0xe220('0x2d')][_0xe220('0x3f')]){_0x5b04b8[_0xe220('0x40')]=[{'all':!![]}];}return db['Dynamics365Field'][_0xe220('0x41')](_0x5b04b8);})[_0xe220('0x1f')](function(_0x5027db){_0x3d71f4[_0xe220('0x42')]=_0x5027db;return _0x3d71f4;})['then'](respondWithFilteredResult(_0x469641,_0x5b04b8))[_0xe220('0x43')](handleError(_0x469641,null));};exports[_0xe220('0x44')]=function(_0x5c5059,_0x421ca2){var _0x5b7836={'raw':!![],'where':{'id':_0x5c5059[_0xe220('0x45')]['id']}},_0x2777c3={};_0x2777c3['model']=_[_0xe220('0x2c')](db[_0xe220('0x3e')]['rawAttributes']);_0x2777c3[_0xe220('0x2d')]=_[_0xe220('0x2c')](_0x5c5059['query']);_0x2777c3[_0xe220('0x37')]=_[_0xe220('0x2e')](_0x2777c3['model'],_0x2777c3[_0xe220('0x2d')]);_0x5b7836[_0xe220('0x2f')]=_[_0xe220('0x2e')](_0x2777c3[_0xe220('0x2a')],qs[_0xe220('0x30')](_0x5c5059[_0xe220('0x2d')][_0xe220('0x30')]));_0x5b7836[_0xe220('0x2f')]=_0x5b7836[_0xe220('0x2f')][_0xe220('0x31')]?_0x5b7836[_0xe220('0x2f')]:_0x2777c3[_0xe220('0x2a')];if(_0x5c5059[_0xe220('0x2d')]['includeAll']){_0x5b7836[_0xe220('0x40')]=[{'all':!![]}];}_0x5b7836=_['merge']({},_0x5b7836,_0x5c5059['options']);return db[_0xe220('0x3e')][_0xe220('0x46')](_0x5b7836)['then'](handleEntityNotFound(_0x421ca2,null))[_0xe220('0x1f')](respondWithResult(_0x421ca2,null))[_0xe220('0x43')](handleError(_0x421ca2,null));};exports['create']=function(_0x51ff10,_0x379d34){return db[_0xe220('0x3e')][_0xe220('0x47')](_0x51ff10[_0xe220('0x48')],{})[_0xe220('0x1f')](respondWithResult(_0x379d34,0xc9))['catch'](handleError(_0x379d34,null));};exports[_0xe220('0x1e')]=function(_0x4b1d1c,_0x28c9b1){if(_0x4b1d1c[_0xe220('0x48')]['id']){delete _0x4b1d1c[_0xe220('0x48')]['id'];}return db[_0xe220('0x3e')]['find']({'where':{'id':_0x4b1d1c[_0xe220('0x45')]['id']}})[_0xe220('0x1f')](handleEntityNotFound(_0x28c9b1,null))[_0xe220('0x1f')](saveUpdates(_0x4b1d1c['body'],null))['then'](respondWithResult(_0x28c9b1,null))[_0xe220('0x43')](handleError(_0x28c9b1,null));};exports[_0xe220('0x20')]=function(_0x51a7a2,_0x3d63ed){return db[_0xe220('0x3e')][_0xe220('0x46')]({'where':{'id':_0x51a7a2['params']['id']}})[_0xe220('0x1f')](handleEntityNotFound(_0x3d63ed,null))[_0xe220('0x1f')](removeEntity(_0x3d63ed,null))['catch'](handleError(_0x3d63ed,null));};
\ No newline at end of file
+var _0x9d91=['save','update','then','destroy','error','stack','name','send','index','map','rawAttributes','fieldName','type','key','query','keys','intersection','model','fields','attributes','length','hasOwnProperty','nolimit','limit','order','sort','where','filters','pick','VIRTUAL','filter','merge','options','Dynamics365Field','include','findAll','rows','catch','show','params','includeAll','find','create','body','eml-format','zip-dir','fast-json-patch','request-promise','moment','mustache','path','to-csv','ejs','squel','crypto','papaparse','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','status','json','offset','undefined','count','apply'];(function(_0x3ed26c,_0xab6b81){var _0x20074a=function(_0xd2a4d5){while(--_0xd2a4d5){_0x3ed26c['push'](_0x3ed26c['shift']());}};_0x20074a(++_0xab6b81);}(_0x9d91,0x75));var _0x19d9=function(_0x1e1610,_0x27f299){_0x1e1610=_0x1e1610-0x0;var _0x4b92de=_0x9d91[_0x1e1610];return _0x4b92de;};'use strict';var emlformat=require(_0x19d9('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x19d9('0x1'));var jsonpatch=require(_0x19d9('0x2'));var rp=require(_0x19d9('0x3'));var moment=require(_0x19d9('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x19d9('0x5'));var util=require('util');var path=require(_0x19d9('0x6'));var sox=require('sox');var csv=require(_0x19d9('0x7'));var ejs=require(_0x19d9('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require(_0x19d9('0x9'));var crypto=require(_0x19d9('0xa'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x19d9('0x7'));var querystring=require('querystring');var Papa=require(_0x19d9('0xb'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x19d9('0xc'));var as=require(_0x19d9('0xd'));var hardwareService=require(_0x19d9('0xe'));var logger=require(_0x19d9('0xf'))(_0x19d9('0x10'));var utils=require(_0x19d9('0x11'));var config=require(_0x19d9('0x12'));var licenseUtil=require(_0x19d9('0x13'));var db=require(_0x19d9('0x14'))['db'];function respondWithStatusCode(_0x16cdac,_0x5cb1f4){_0x5cb1f4=_0x5cb1f4||0xcc;return function(_0x394ac8){if(_0x394ac8){return _0x16cdac[_0x19d9('0x15')](_0x5cb1f4);}return _0x16cdac['status'](_0x5cb1f4)[_0x19d9('0x16')]();};}function respondWithResult(_0x280155,_0x5dd5b4){_0x5dd5b4=_0x5dd5b4||0xc8;return function(_0x29ed1c){if(_0x29ed1c){return _0x280155[_0x19d9('0x17')](_0x5dd5b4)[_0x19d9('0x18')](_0x29ed1c);}};}function respondWithFilteredResult(_0x496e7d,_0x4ee4fc){return function(_0x5ebd54){if(_0x5ebd54){var _0x3ff231=typeof _0x4ee4fc[_0x19d9('0x19')]===_0x19d9('0x1a')&&typeof _0x4ee4fc['limit']==='undefined';var _0x409350=_0x5ebd54[_0x19d9('0x1b')];var _0x18be9b=_0x3ff231?0x0:_0x4ee4fc[_0x19d9('0x19')];var _0x15ad9=_0x3ff231?_0x5ebd54[_0x19d9('0x1b')]:_0x4ee4fc[_0x19d9('0x19')]+_0x4ee4fc['limit'];var _0x1edc44;if(_0x15ad9>=_0x409350){_0x15ad9=_0x409350;_0x1edc44=0xc8;}else{_0x1edc44=0xce;}_0x496e7d['status'](_0x1edc44);return _0x496e7d['set']('Content-Range',_0x18be9b+'-'+_0x15ad9+'/'+_0x409350)[_0x19d9('0x18')](_0x5ebd54);}return null;};}function patchUpdates(_0x25b09c){return function(_0x3f5b42){try{jsonpatch[_0x19d9('0x1c')](_0x3f5b42,_0x25b09c,!![]);}catch(_0x1e5d98){return BPromise['reject'](_0x1e5d98);}return _0x3f5b42[_0x19d9('0x1d')]();};}function saveUpdates(_0x3f1e71,_0x23536c){return function(_0x2d2f37){if(_0x2d2f37){return _0x2d2f37[_0x19d9('0x1e')](_0x3f1e71)[_0x19d9('0x1f')](function(_0x573276){return _0x573276;});}return null;};}function removeEntity(_0x9e9d0a,_0xd4f8b5){return function(_0x562b6c){if(_0x562b6c){return _0x562b6c[_0x19d9('0x20')]()[_0x19d9('0x1f')](function(){_0x9e9d0a[_0x19d9('0x17')](0xcc)['end']();});}};}function handleEntityNotFound(_0x4c565f,_0x4fe9bd){return function(_0x254c64){if(!_0x254c64){_0x4c565f['sendStatus'](0x194);}return _0x254c64;};}function handleError(_0x214765,_0x26eb55){_0x26eb55=_0x26eb55||0x1f4;return function(_0x4259c6){logger[_0x19d9('0x21')](_0x4259c6[_0x19d9('0x22')]);if(_0x4259c6[_0x19d9('0x23')]){delete _0x4259c6[_0x19d9('0x23')];}_0x214765[_0x19d9('0x17')](_0x26eb55)[_0x19d9('0x24')](_0x4259c6);};}exports[_0x19d9('0x25')]=function(_0x2258d1,_0x234211){var _0x4c0b53={},_0x43c144={},_0x265adf={'count':0x0,'rows':[]};var _0x455df8=_[_0x19d9('0x26')](db['Dynamics365Field'][_0x19d9('0x27')],function(_0x2546f4){return{'name':_0x2546f4[_0x19d9('0x28')],'type':_0x2546f4[_0x19d9('0x29')][_0x19d9('0x2a')]};});_0x43c144['model']=_[_0x19d9('0x26')](_0x455df8,'name');_0x43c144[_0x19d9('0x2b')]=_[_0x19d9('0x2c')](_0x2258d1[_0x19d9('0x2b')]);_0x43c144['filters']=_[_0x19d9('0x2d')](_0x43c144[_0x19d9('0x2e')],_0x43c144[_0x19d9('0x2b')]);_0x4c0b53['attributes']=_[_0x19d9('0x2d')](_0x43c144[_0x19d9('0x2e')],qs['fields'](_0x2258d1[_0x19d9('0x2b')][_0x19d9('0x2f')]));_0x4c0b53[_0x19d9('0x30')]=_0x4c0b53[_0x19d9('0x30')][_0x19d9('0x31')]?_0x4c0b53[_0x19d9('0x30')]:_0x43c144[_0x19d9('0x2e')];if(!_0x2258d1['query'][_0x19d9('0x32')](_0x19d9('0x33'))){_0x4c0b53[_0x19d9('0x34')]=qs[_0x19d9('0x34')](_0x2258d1[_0x19d9('0x2b')][_0x19d9('0x34')]);_0x4c0b53[_0x19d9('0x19')]=qs[_0x19d9('0x19')](_0x2258d1['query'][_0x19d9('0x19')]);}_0x4c0b53[_0x19d9('0x35')]=qs[_0x19d9('0x36')](_0x2258d1[_0x19d9('0x2b')][_0x19d9('0x36')]);_0x4c0b53[_0x19d9('0x37')]=qs[_0x19d9('0x38')](_[_0x19d9('0x39')](_0x2258d1[_0x19d9('0x2b')],_0x43c144[_0x19d9('0x38')]),_0x455df8);if(_0x2258d1[_0x19d9('0x2b')]['filter']){_0x4c0b53[_0x19d9('0x37')]=_['merge'](_0x4c0b53[_0x19d9('0x37')],{'$or':_[_0x19d9('0x26')](_0x455df8,function(_0x338d67){if(_0x338d67[_0x19d9('0x29')]!==_0x19d9('0x3a')){var _0x1dbb86={};_0x1dbb86[_0x338d67['name']]={'$like':'%'+_0x2258d1[_0x19d9('0x2b')][_0x19d9('0x3b')]+'%'};return _0x1dbb86;}})});}_0x4c0b53=_[_0x19d9('0x3c')]({},_0x4c0b53,_0x2258d1[_0x19d9('0x3d')]);var _0x438724={'where':_0x4c0b53[_0x19d9('0x37')]};return db[_0x19d9('0x3e')][_0x19d9('0x1b')](_0x438724)[_0x19d9('0x1f')](function(_0x1b3320){_0x265adf[_0x19d9('0x1b')]=_0x1b3320;if(_0x2258d1[_0x19d9('0x2b')]['includeAll']){_0x4c0b53[_0x19d9('0x3f')]=[{'all':!![]}];}return db['Dynamics365Field'][_0x19d9('0x40')](_0x4c0b53);})[_0x19d9('0x1f')](function(_0xb76123){_0x265adf[_0x19d9('0x41')]=_0xb76123;return _0x265adf;})[_0x19d9('0x1f')](respondWithFilteredResult(_0x234211,_0x4c0b53))[_0x19d9('0x42')](handleError(_0x234211,null));};exports[_0x19d9('0x43')]=function(_0x5c10bf,_0x404dc6){var _0x255d94={'raw':!![],'where':{'id':_0x5c10bf[_0x19d9('0x44')]['id']}},_0x2e81d7={};_0x2e81d7[_0x19d9('0x2e')]=_[_0x19d9('0x2c')](db['Dynamics365Field']['rawAttributes']);_0x2e81d7[_0x19d9('0x2b')]=_[_0x19d9('0x2c')](_0x5c10bf['query']);_0x2e81d7[_0x19d9('0x38')]=_[_0x19d9('0x2d')](_0x2e81d7[_0x19d9('0x2e')],_0x2e81d7[_0x19d9('0x2b')]);_0x255d94[_0x19d9('0x30')]=_[_0x19d9('0x2d')](_0x2e81d7[_0x19d9('0x2e')],qs[_0x19d9('0x2f')](_0x5c10bf[_0x19d9('0x2b')][_0x19d9('0x2f')]));_0x255d94[_0x19d9('0x30')]=_0x255d94[_0x19d9('0x30')][_0x19d9('0x31')]?_0x255d94[_0x19d9('0x30')]:_0x2e81d7[_0x19d9('0x2e')];if(_0x5c10bf[_0x19d9('0x2b')][_0x19d9('0x45')]){_0x255d94['include']=[{'all':!![]}];}_0x255d94=_[_0x19d9('0x3c')]({},_0x255d94,_0x5c10bf[_0x19d9('0x3d')]);return db[_0x19d9('0x3e')][_0x19d9('0x46')](_0x255d94)['then'](handleEntityNotFound(_0x404dc6,null))[_0x19d9('0x1f')](respondWithResult(_0x404dc6,null))[_0x19d9('0x42')](handleError(_0x404dc6,null));};exports[_0x19d9('0x47')]=function(_0x304c23,_0x5100c3){return db['Dynamics365Field'][_0x19d9('0x47')](_0x304c23[_0x19d9('0x48')],{})[_0x19d9('0x1f')](respondWithResult(_0x5100c3,0xc9))[_0x19d9('0x42')](handleError(_0x5100c3,null));};exports['update']=function(_0x3b6781,_0x271a98){if(_0x3b6781[_0x19d9('0x48')]['id']){delete _0x3b6781[_0x19d9('0x48')]['id'];}return db[_0x19d9('0x3e')][_0x19d9('0x46')]({'where':{'id':_0x3b6781[_0x19d9('0x44')]['id']}})['then'](handleEntityNotFound(_0x271a98,null))[_0x19d9('0x1f')](saveUpdates(_0x3b6781[_0x19d9('0x48')],null))[_0x19d9('0x1f')](respondWithResult(_0x271a98,null))['catch'](handleError(_0x271a98,null));};exports[_0x19d9('0x20')]=function(_0x55065d,_0x14e58b){return db[_0x19d9('0x3e')][_0x19d9('0x46')]({'where':{'id':_0x55065d[_0x19d9('0x44')]['id']}})[_0x19d9('0x1f')](handleEntityNotFound(_0x14e58b,null))[_0x19d9('0x1f')](removeEntity(_0x14e58b,null))[_0x19d9('0x42')](handleError(_0x14e58b,null));};
\ No newline at end of file