Built motion from commit 85328c08.|2.5.50
[motion2.git] / server / api / chatQueueReport / chatQueueReport.controller.js
index b37db98..2e8a55e 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x127f=['send','map','ChatQueueReport','rawAttributes','fieldName','type','key','query','keys','filters','attributes','intersection','model','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','merge','where','VIRTUAL','options','includeAll','include','catch','params','find','create','body','update','describe','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','ejs','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','count','offset','limit','Content-Range','apply','reject','then','destroy','stack','name'];(function(_0x1b04f9,_0x3ac9e8){var _0xa65144=function(_0x5ba690){while(--_0x5ba690){_0x1b04f9['push'](_0x1b04f9['shift']());}};_0xa65144(++_0x3ac9e8);}(_0x127f,0x6d));var _0xf127=function(_0x46100d,_0x4fec58){_0x46100d=_0x46100d-0x0;var _0x4b050a=_0x127f[_0x46100d];return _0x4b050a;};'use strict';var pdf=require(_0xf127('0x0'));var emlformat=require('eml-format');var rimraf=require(_0xf127('0x1'));var zipdir=require(_0xf127('0x2'));var jsonpatch=require(_0xf127('0x3'));var rp=require(_0xf127('0x4'));var moment=require('moment');var BPromise=require(_0xf127('0x5'));var Mustache=require(_0xf127('0x6'));var util=require(_0xf127('0x7'));var path=require(_0xf127('0x8'));var sox=require(_0xf127('0x9'));var csv=require('to-csv');var ejs=require(_0xf127('0xa'));var fs=require('fs');var _=require(_0xf127('0xb'));var squel=require(_0xf127('0xc'));var crypto=require(_0xf127('0xd'));var jsforce=require(_0xf127('0xe'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0xf127('0xf'));var Papa=require(_0xf127('0x10'));var Redis=require(_0xf127('0x11'));var authService=require(_0xf127('0x12'));var qs=require(_0xf127('0x13'));var as=require(_0xf127('0x14'));var hardwareService=require(_0xf127('0x15'));var logger=require(_0xf127('0x16'))(_0xf127('0x17'));var utils=require(_0xf127('0x18'));var config=require(_0xf127('0x19'));var licenseUtil=require('../../config/license/util');var db=require(_0xf127('0x1a'))['db'];function respondWithStatusCode(_0x2e3d66,_0x401fd3){_0x401fd3=_0x401fd3||0xcc;return function(_0x24a3f7){if(_0x24a3f7){return _0x2e3d66[_0xf127('0x1b')](_0x401fd3);}return _0x2e3d66[_0xf127('0x1c')](_0x401fd3)[_0xf127('0x1d')]();};}function respondWithResult(_0x2abc80,_0x4a0d28){_0x4a0d28=_0x4a0d28||0xc8;return function(_0x2e1718){if(_0x2e1718){return _0x2abc80[_0xf127('0x1c')](_0x4a0d28)[_0xf127('0x1e')](_0x2e1718);}};}function respondWithFilteredResult(_0x4fa392,_0x3dc8ef){return function(_0x1df11b){if(_0x1df11b){var _0x3a9951=_0x1df11b[_0xf127('0x1f')],_0x50bc10=_0x3dc8ef[_0xf127('0x20')],_0x32424f=_0x3dc8ef[_0xf127('0x20')]+_0x3dc8ef[_0xf127('0x21')],_0x3417c5;if(_0x32424f>=_0x3a9951){_0x32424f=_0x3a9951;_0x3417c5=0xc8;}else{_0x3417c5=0xce;}_0x4fa392['status'](_0x3417c5);return _0x4fa392['set'](_0xf127('0x22'),_0x50bc10+'-'+_0x32424f+'/'+_0x3a9951)[_0xf127('0x1e')](_0x1df11b);}return null;};}function patchUpdates(_0x35cdcf){return function(_0xa563be){try{jsonpatch[_0xf127('0x23')](_0xa563be,_0x35cdcf,!![]);}catch(_0x547469){return BPromise[_0xf127('0x24')](_0x547469);}return _0xa563be['save']();};}function saveUpdates(_0x31c4b2,_0x5238a7){return function(_0x2ffc5e){if(_0x2ffc5e){return _0x2ffc5e['update'](_0x31c4b2)[_0xf127('0x25')](function(_0x431903){return _0x431903;});}return null;};}function removeEntity(_0x566555,_0x58edb2){return function(_0x2abc5c){if(_0x2abc5c){return _0x2abc5c[_0xf127('0x26')]()['then'](function(){_0x566555[_0xf127('0x1c')](0xcc)[_0xf127('0x1d')]();});}};}function handleEntityNotFound(_0x4cbc1a,_0x18d654){return function(_0x350c84){if(!_0x350c84){_0x4cbc1a[_0xf127('0x1b')](0x194);}return _0x350c84;};}function handleError(_0x58d035,_0x1e18e4){_0x1e18e4=_0x1e18e4||0x1f4;return function(_0x256cbb){logger['error'](_0x256cbb[_0xf127('0x27')]);if(_0x256cbb[_0xf127('0x28')]){delete _0x256cbb[_0xf127('0x28')];}_0x58d035[_0xf127('0x1c')](_0x1e18e4)[_0xf127('0x29')](_0x256cbb);};}exports['index']=function(_0xd1306a,_0x4db394){var _0x11b056={},_0x300c7d={},_0x4db4ba={'count':0x0,'rows':[]};var _0x25604c=_[_0xf127('0x2a')](db[_0xf127('0x2b')][_0xf127('0x2c')],function(_0x2ed093){return{'name':_0x2ed093[_0xf127('0x2d')],'type':_0x2ed093[_0xf127('0x2e')][_0xf127('0x2f')]};});_0x300c7d['model']=_[_0xf127('0x2a')](_0x25604c,_0xf127('0x28'));_0x300c7d[_0xf127('0x30')]=_[_0xf127('0x31')](_0xd1306a['query']);_0x300c7d[_0xf127('0x32')]=_['intersection'](_0x300c7d['model'],_0x300c7d['query']);_0x11b056[_0xf127('0x33')]=_[_0xf127('0x34')](_0x300c7d[_0xf127('0x35')],qs['fields'](_0xd1306a[_0xf127('0x30')][_0xf127('0x36')]));_0x11b056[_0xf127('0x33')]=_0x11b056[_0xf127('0x33')][_0xf127('0x37')]?_0x11b056[_0xf127('0x33')]:_0x300c7d[_0xf127('0x35')];if(!_0xd1306a[_0xf127('0x30')][_0xf127('0x38')](_0xf127('0x39'))){_0x11b056[_0xf127('0x21')]=qs[_0xf127('0x21')](_0xd1306a[_0xf127('0x30')][_0xf127('0x21')]);_0x11b056[_0xf127('0x20')]=qs[_0xf127('0x20')](_0xd1306a[_0xf127('0x30')][_0xf127('0x20')]);}_0x11b056[_0xf127('0x3a')]=qs[_0xf127('0x3b')](_0xd1306a[_0xf127('0x30')]['sort']);_0x11b056['where']=qs[_0xf127('0x32')](_[_0xf127('0x3c')](_0xd1306a[_0xf127('0x30')],_0x300c7d[_0xf127('0x32')]),_0x25604c);if(_0xd1306a[_0xf127('0x30')][_0xf127('0x3d')]){_0x11b056['where']=_[_0xf127('0x3e')](_0x11b056[_0xf127('0x3f')],{'$or':_[_0xf127('0x2a')](_0x25604c,function(_0x5428d6){if(_0x5428d6[_0xf127('0x2e')]!==_0xf127('0x40')){var _0x511732={};_0x511732[_0x5428d6[_0xf127('0x28')]]={'$like':'%'+_0xd1306a[_0xf127('0x30')]['filter']+'%'};return _0x511732;}})});}_0x11b056=_['merge']({},_0x11b056,_0xd1306a[_0xf127('0x41')]);var _0x127f9b={'where':_0x11b056[_0xf127('0x3f')]};return db[_0xf127('0x2b')][_0xf127('0x1f')](_0x127f9b)[_0xf127('0x25')](function(_0x5e041d){_0x4db4ba['count']=_0x5e041d;if(_0xd1306a['query'][_0xf127('0x42')]){_0x11b056[_0xf127('0x43')]=[{'all':!![]}];}return db['ChatQueueReport']['findAll'](_0x11b056);})[_0xf127('0x25')](function(_0x5106b7){_0x4db4ba['rows']=_0x5106b7;return _0x4db4ba;})[_0xf127('0x25')](respondWithFilteredResult(_0x4db394,_0x11b056))[_0xf127('0x44')](handleError(_0x4db394,null));};exports['show']=function(_0xaf8086,_0x344b40){var _0x5a9260={'raw':!![],'where':{'id':_0xaf8086[_0xf127('0x45')]['id']}},_0x11bd1a={};_0x11bd1a[_0xf127('0x35')]=_['keys'](db[_0xf127('0x2b')][_0xf127('0x2c')]);_0x11bd1a[_0xf127('0x30')]=_['keys'](_0xaf8086[_0xf127('0x30')]);_0x11bd1a[_0xf127('0x32')]=_[_0xf127('0x34')](_0x11bd1a[_0xf127('0x35')],_0x11bd1a[_0xf127('0x30')]);_0x5a9260['attributes']=_['intersection'](_0x11bd1a[_0xf127('0x35')],qs[_0xf127('0x36')](_0xaf8086[_0xf127('0x30')][_0xf127('0x36')]));_0x5a9260['attributes']=_0x5a9260[_0xf127('0x33')][_0xf127('0x37')]?_0x5a9260[_0xf127('0x33')]:_0x11bd1a[_0xf127('0x35')];if(_0xaf8086[_0xf127('0x30')][_0xf127('0x42')]){_0x5a9260['include']=[{'all':!![]}];}_0x5a9260=_[_0xf127('0x3e')]({},_0x5a9260,_0xaf8086[_0xf127('0x41')]);return db[_0xf127('0x2b')][_0xf127('0x46')](_0x5a9260)[_0xf127('0x25')](handleEntityNotFound(_0x344b40,null))['then'](respondWithResult(_0x344b40,null))['catch'](handleError(_0x344b40,null));};exports[_0xf127('0x47')]=function(_0xf1d4d1,_0x783717){return db[_0xf127('0x2b')][_0xf127('0x47')](_0xf1d4d1[_0xf127('0x48')],{})[_0xf127('0x25')](respondWithResult(_0x783717,0xc9))[_0xf127('0x44')](handleError(_0x783717,null));};exports[_0xf127('0x49')]=function(_0xab8853,_0x4e1691){if(_0xab8853[_0xf127('0x48')]['id']){delete _0xab8853[_0xf127('0x48')]['id'];}return db[_0xf127('0x2b')]['find']({'where':{'id':_0xab8853['params']['id']}})[_0xf127('0x25')](handleEntityNotFound(_0x4e1691,null))[_0xf127('0x25')](saveUpdates(_0xab8853[_0xf127('0x48')],null))[_0xf127('0x25')](respondWithResult(_0x4e1691,null))[_0xf127('0x44')](handleError(_0x4e1691,null));};exports[_0xf127('0x26')]=function(_0x549f64,_0x36769f){return db[_0xf127('0x2b')][_0xf127('0x46')]({'where':{'id':_0x549f64[_0xf127('0x45')]['id']}})[_0xf127('0x25')](handleEntityNotFound(_0x36769f,null))[_0xf127('0x25')](removeEntity(_0x36769f,null))[_0xf127('0x44')](handleError(_0x36769f,null));};exports[_0xf127('0x4a')]=function(_0x4a5064,_0x1d7d23){return db[_0xf127('0x2b')][_0xf127('0x4a')]()[_0xf127('0x25')](respondWithResult(_0x1d7d23,null))[_0xf127('0x44')](handleError(_0x1d7d23,null));};
\ No newline at end of file
+var _0x084b=['papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','status','end','json','offset','undefined','limit','count','Content-Range','apply','reject','save','update','then','destroy','sendStatus','error','name','send','index','ChatQueueReport','rawAttributes','fieldName','type','model','map','query','filters','intersection','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','VIRTUAL','filter','merge','options','includeAll','findAll','catch','show','params','keys','fields','include','create','body','find','describe','eml-format','request-promise','moment','mustache','util','path','to-csv','fs-extra','lodash','squel','desk.js','querystring'];(function(_0x4b9c74,_0x1b66bb){var _0x229a46=function(_0x2edf37){while(--_0x2edf37){_0x4b9c74['push'](_0x4b9c74['shift']());}};_0x229a46(++_0x1b66bb);}(_0x084b,0xd5));var _0xb084=function(_0x1234e5,_0x599458){_0x1234e5=_0x1234e5-0x0;var _0x1a351e=_0x084b[_0x1234e5];return _0x1a351e;};'use strict';var emlformat=require(_0xb084('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0xb084('0x1'));var moment=require(_0xb084('0x2'));var BPromise=require('bluebird');var Mustache=require(_0xb084('0x3'));var util=require(_0xb084('0x4'));var path=require(_0xb084('0x5'));var sox=require('sox');var csv=require(_0xb084('0x6'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xb084('0x7'));var _=require(_0xb084('0x8'));var squel=require(_0xb084('0x9'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0xb084('0xa'));var toCsv=require(_0xb084('0x6'));var querystring=require(_0xb084('0xb'));var Papa=require(_0xb084('0xc'));var Redis=require(_0xb084('0xd'));var authService=require(_0xb084('0xe'));var qs=require(_0xb084('0xf'));var as=require(_0xb084('0x10'));var hardwareService=require(_0xb084('0x11'));var logger=require(_0xb084('0x12'))(_0xb084('0x13'));var utils=require(_0xb084('0x14'));var config=require(_0xb084('0x15'));var licenseUtil=require(_0xb084('0x16'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x51aee2,_0x3582a0){_0x3582a0=_0x3582a0||0xcc;return function(_0x514829){if(_0x514829){return _0x51aee2['sendStatus'](_0x3582a0);}return _0x51aee2[_0xb084('0x17')](_0x3582a0)[_0xb084('0x18')]();};}function respondWithResult(_0x5bae3a,_0x4da0fb){_0x4da0fb=_0x4da0fb||0xc8;return function(_0x44be03){if(_0x44be03){return _0x5bae3a[_0xb084('0x17')](_0x4da0fb)[_0xb084('0x19')](_0x44be03);}};}function respondWithFilteredResult(_0x28ad2d,_0xc6df71){return function(_0x5a5d11){if(_0x5a5d11){var _0x240838=typeof _0xc6df71[_0xb084('0x1a')]===_0xb084('0x1b')&&typeof _0xc6df71[_0xb084('0x1c')]===_0xb084('0x1b');var _0x2cce88=_0x5a5d11[_0xb084('0x1d')];var _0x42657a=_0x240838?0x0:_0xc6df71[_0xb084('0x1a')];var _0x19d426=_0x240838?_0x5a5d11['count']:_0xc6df71['offset']+_0xc6df71['limit'];var _0x5b076b;if(_0x19d426>=_0x2cce88){_0x19d426=_0x2cce88;_0x5b076b=0xc8;}else{_0x5b076b=0xce;}_0x28ad2d[_0xb084('0x17')](_0x5b076b);return _0x28ad2d['set'](_0xb084('0x1e'),_0x42657a+'-'+_0x19d426+'/'+_0x2cce88)[_0xb084('0x19')](_0x5a5d11);}return null;};}function patchUpdates(_0x228ef1){return function(_0x2e8789){try{jsonpatch[_0xb084('0x1f')](_0x2e8789,_0x228ef1,!![]);}catch(_0x434690){return BPromise[_0xb084('0x20')](_0x434690);}return _0x2e8789[_0xb084('0x21')]();};}function saveUpdates(_0x517dc0,_0x5dfc7f){return function(_0x171dd5){if(_0x171dd5){return _0x171dd5[_0xb084('0x22')](_0x517dc0)[_0xb084('0x23')](function(_0x28d074){return _0x28d074;});}return null;};}function removeEntity(_0x5dced1,_0x4795d9){return function(_0x3ef50e){if(_0x3ef50e){return _0x3ef50e[_0xb084('0x24')]()['then'](function(){_0x5dced1[_0xb084('0x17')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1f4983,_0x22059f){return function(_0x5d9314){if(!_0x5d9314){_0x1f4983[_0xb084('0x25')](0x194);}return _0x5d9314;};}function handleError(_0x3d467e,_0x1ecb58){_0x1ecb58=_0x1ecb58||0x1f4;return function(_0x4ce54c){logger[_0xb084('0x26')](_0x4ce54c['stack']);if(_0x4ce54c[_0xb084('0x27')]){delete _0x4ce54c[_0xb084('0x27')];}_0x3d467e['status'](_0x1ecb58)[_0xb084('0x28')](_0x4ce54c);};}exports[_0xb084('0x29')]=function(_0x49cbd6,_0x4587e7){var _0x1a7726={},_0x57406f={},_0x1ad27b={'count':0x0,'rows':[]};var _0x2795cf=_['map'](db[_0xb084('0x2a')][_0xb084('0x2b')],function(_0x330a35){return{'name':_0x330a35[_0xb084('0x2c')],'type':_0x330a35[_0xb084('0x2d')]['key']};});_0x57406f[_0xb084('0x2e')]=_[_0xb084('0x2f')](_0x2795cf,_0xb084('0x27'));_0x57406f[_0xb084('0x30')]=_['keys'](_0x49cbd6[_0xb084('0x30')]);_0x57406f[_0xb084('0x31')]=_[_0xb084('0x32')](_0x57406f[_0xb084('0x2e')],_0x57406f[_0xb084('0x30')]);_0x1a7726['attributes']=_['intersection'](_0x57406f[_0xb084('0x2e')],qs['fields'](_0x49cbd6[_0xb084('0x30')]['fields']));_0x1a7726[_0xb084('0x33')]=_0x1a7726[_0xb084('0x33')][_0xb084('0x34')]?_0x1a7726[_0xb084('0x33')]:_0x57406f['model'];if(!_0x49cbd6[_0xb084('0x30')][_0xb084('0x35')](_0xb084('0x36'))){_0x1a7726[_0xb084('0x1c')]=qs[_0xb084('0x1c')](_0x49cbd6['query'][_0xb084('0x1c')]);_0x1a7726[_0xb084('0x1a')]=qs['offset'](_0x49cbd6['query'][_0xb084('0x1a')]);}_0x1a7726[_0xb084('0x37')]=qs[_0xb084('0x38')](_0x49cbd6[_0xb084('0x30')][_0xb084('0x38')]);_0x1a7726[_0xb084('0x39')]=qs[_0xb084('0x31')](_[_0xb084('0x3a')](_0x49cbd6['query'],_0x57406f[_0xb084('0x31')]),_0x2795cf);if(_0x49cbd6[_0xb084('0x30')]['filter']){_0x1a7726[_0xb084('0x39')]=_['merge'](_0x1a7726[_0xb084('0x39')],{'$or':_[_0xb084('0x2f')](_0x2795cf,function(_0xad9187){if(_0xad9187[_0xb084('0x2d')]!==_0xb084('0x3b')){var _0x2254a3={};_0x2254a3[_0xad9187[_0xb084('0x27')]]={'$like':'%'+_0x49cbd6[_0xb084('0x30')][_0xb084('0x3c')]+'%'};return _0x2254a3;}})});}_0x1a7726=_[_0xb084('0x3d')]({},_0x1a7726,_0x49cbd6[_0xb084('0x3e')]);var _0x77b2cc={'where':_0x1a7726[_0xb084('0x39')]};return db[_0xb084('0x2a')][_0xb084('0x1d')](_0x77b2cc)[_0xb084('0x23')](function(_0x584b34){_0x1ad27b['count']=_0x584b34;if(_0x49cbd6[_0xb084('0x30')][_0xb084('0x3f')]){_0x1a7726['include']=[{'all':!![]}];}return db['ChatQueueReport'][_0xb084('0x40')](_0x1a7726);})[_0xb084('0x23')](function(_0x1de365){_0x1ad27b['rows']=_0x1de365;return _0x1ad27b;})[_0xb084('0x23')](respondWithFilteredResult(_0x4587e7,_0x1a7726))[_0xb084('0x41')](handleError(_0x4587e7,null));};exports[_0xb084('0x42')]=function(_0x526c47,_0xc63ca9){var _0x13b059={'raw':!![],'where':{'id':_0x526c47[_0xb084('0x43')]['id']}},_0x3f38f9={};_0x3f38f9['model']=_[_0xb084('0x44')](db[_0xb084('0x2a')][_0xb084('0x2b')]);_0x3f38f9[_0xb084('0x30')]=_['keys'](_0x526c47[_0xb084('0x30')]);_0x3f38f9[_0xb084('0x31')]=_[_0xb084('0x32')](_0x3f38f9[_0xb084('0x2e')],_0x3f38f9[_0xb084('0x30')]);_0x13b059[_0xb084('0x33')]=_[_0xb084('0x32')](_0x3f38f9[_0xb084('0x2e')],qs[_0xb084('0x45')](_0x526c47[_0xb084('0x30')][_0xb084('0x45')]));_0x13b059[_0xb084('0x33')]=_0x13b059[_0xb084('0x33')][_0xb084('0x34')]?_0x13b059[_0xb084('0x33')]:_0x3f38f9['model'];if(_0x526c47[_0xb084('0x30')][_0xb084('0x3f')]){_0x13b059[_0xb084('0x46')]=[{'all':!![]}];}_0x13b059=_[_0xb084('0x3d')]({},_0x13b059,_0x526c47[_0xb084('0x3e')]);return db[_0xb084('0x2a')]['find'](_0x13b059)[_0xb084('0x23')](handleEntityNotFound(_0xc63ca9,null))[_0xb084('0x23')](respondWithResult(_0xc63ca9,null))[_0xb084('0x41')](handleError(_0xc63ca9,null));};exports[_0xb084('0x47')]=function(_0x1a95e4,_0x305f4a){return db[_0xb084('0x2a')]['create'](_0x1a95e4[_0xb084('0x48')],{})[_0xb084('0x23')](respondWithResult(_0x305f4a,0xc9))[_0xb084('0x41')](handleError(_0x305f4a,null));};exports[_0xb084('0x22')]=function(_0x32014e,_0xb1fdeb){if(_0x32014e[_0xb084('0x48')]['id']){delete _0x32014e[_0xb084('0x48')]['id'];}return db['ChatQueueReport'][_0xb084('0x49')]({'where':{'id':_0x32014e[_0xb084('0x43')]['id']}})['then'](handleEntityNotFound(_0xb1fdeb,null))[_0xb084('0x23')](saveUpdates(_0x32014e[_0xb084('0x48')],null))[_0xb084('0x23')](respondWithResult(_0xb1fdeb,null))[_0xb084('0x41')](handleError(_0xb1fdeb,null));};exports[_0xb084('0x24')]=function(_0x4bad1b,_0x2d5ebd){return db['ChatQueueReport'][_0xb084('0x49')]({'where':{'id':_0x4bad1b[_0xb084('0x43')]['id']}})[_0xb084('0x23')](handleEntityNotFound(_0x2d5ebd,null))[_0xb084('0x23')](removeEntity(_0x2d5ebd,null))[_0xb084('0x41')](handleError(_0x2d5ebd,null));};exports[_0xb084('0x4a')]=function(_0x2d9239,_0x557649){return db['ChatQueueReport']['describe']()[_0xb084('0x23')](respondWithResult(_0x557649,null))[_0xb084('0x41')](handleError(_0x557649,null));};
\ No newline at end of file