Built motion from commit 953226e6.|2.6.32
[motion2.git] / server / api / memberReport / memberReport.controller.js
index fc25676..4b30bc1 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x531b=['where','filters','pick','filter','merge','VIRTUAL','options','count','includeAll','include','findAll','rows','catch','show','params','create','body','find','describe','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','path','sox','to-csv','ejs','squel','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','status','json','offset','limit','set','Content-Range','apply','save','then','destroy','end','sendStatus','error','send','index','map','MemberReport','rawAttributes','fieldName','type','key','keys','query','intersection','model','fields','attributes','length','hasOwnProperty','nolimit','order','sort'];(function(_0x2b4f44,_0x1b3ec8){var _0x416641=function(_0x2c1d6c){while(--_0x2c1d6c){_0x2b4f44['push'](_0x2b4f44['shift']());}};_0x416641(++_0x1b3ec8);}(_0x531b,0xf7));var _0xb531=function(_0x11babf,_0x2a02bb){_0x11babf=_0x11babf-0x0;var _0x3bcc27=_0x531b[_0x11babf];return _0x3bcc27;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xb531('0x0'));var rimraf=require(_0xb531('0x1'));var zipdir=require(_0xb531('0x2'));var jsonpatch=require(_0xb531('0x3'));var rp=require(_0xb531('0x4'));var moment=require('moment');var BPromise=require(_0xb531('0x5'));var Mustache=require(_0xb531('0x6'));var util=require('util');var path=require(_0xb531('0x7'));var sox=require(_0xb531('0x8'));var csv=require(_0xb531('0x9'));var ejs=require(_0xb531('0xa'));var fs=require('fs');var _=require('lodash');var squel=require(_0xb531('0xb'));var crypto=require(_0xb531('0xc'));var jsforce=require('jsforce');var deskjs=require(_0xb531('0xd'));var toCsv=require('to-csv');var querystring=require(_0xb531('0xe'));var Papa=require(_0xb531('0xf'));var Redis=require(_0xb531('0x10'));var authService=require(_0xb531('0x11'));var qs=require('../../components/parsers/qs');var as=require(_0xb531('0x12'));var hardwareService=require(_0xb531('0x13'));var logger=require(_0xb531('0x14'))(_0xb531('0x15'));var utils=require(_0xb531('0x16'));var config=require(_0xb531('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0xb531('0x18'))['db'];function respondWithStatusCode(_0x46989a,_0x27fd89){_0x27fd89=_0x27fd89||0xcc;return function(_0x102781){if(_0x102781){return _0x46989a['sendStatus'](_0x27fd89);}return _0x46989a[_0xb531('0x19')](_0x27fd89)['end']();};}function respondWithResult(_0x294524,_0x4d83a6){_0x4d83a6=_0x4d83a6||0xc8;return function(_0x296f81){if(_0x296f81){return _0x294524[_0xb531('0x19')](_0x4d83a6)[_0xb531('0x1a')](_0x296f81);}};}function respondWithFilteredResult(_0x6c73e2,_0x453eba){return function(_0x3f2525){if(_0x3f2525){var _0x5b3341=_0x3f2525['count'],_0x1809d1=_0x453eba[_0xb531('0x1b')],_0x106833=_0x453eba[_0xb531('0x1b')]+_0x453eba[_0xb531('0x1c')],_0x2d5f41;if(_0x106833>=_0x5b3341){_0x106833=_0x5b3341;_0x2d5f41=0xc8;}else{_0x2d5f41=0xce;}_0x6c73e2[_0xb531('0x19')](_0x2d5f41);return _0x6c73e2[_0xb531('0x1d')](_0xb531('0x1e'),_0x1809d1+'-'+_0x106833+'/'+_0x5b3341)[_0xb531('0x1a')](_0x3f2525);}return null;};}function patchUpdates(_0x607ea1){return function(_0x34394e){try{jsonpatch[_0xb531('0x1f')](_0x34394e,_0x607ea1,!![]);}catch(_0x2ad59b){return BPromise['reject'](_0x2ad59b);}return _0x34394e[_0xb531('0x20')]();};}function saveUpdates(_0x289a3d,_0x557409){return function(_0x21ee0f){if(_0x21ee0f){return _0x21ee0f['update'](_0x289a3d)[_0xb531('0x21')](function(_0x327cdd){return _0x327cdd;});}return null;};}function removeEntity(_0x288926,_0xce19c9){return function(_0x2d658d){if(_0x2d658d){return _0x2d658d[_0xb531('0x22')]()['then'](function(){_0x288926[_0xb531('0x19')](0xcc)[_0xb531('0x23')]();});}};}function handleEntityNotFound(_0x33672e,_0x1bceb6){return function(_0x4c0b92){if(!_0x4c0b92){_0x33672e[_0xb531('0x24')](0x194);}return _0x4c0b92;};}function handleError(_0x3ac65f,_0x3144c3){_0x3144c3=_0x3144c3||0x1f4;return function(_0x573c7d){logger[_0xb531('0x25')](_0x573c7d['stack']);if(_0x573c7d['name']){delete _0x573c7d['name'];}_0x3ac65f[_0xb531('0x19')](_0x3144c3)[_0xb531('0x26')](_0x573c7d);};}exports[_0xb531('0x27')]=function(_0x4747a8,_0x13361c){var _0x1728b7={},_0x1f9f01={},_0x323677={'count':0x0,'rows':[]};var _0x4ff16d=_[_0xb531('0x28')](db[_0xb531('0x29')][_0xb531('0x2a')],function(_0x338d22){return{'name':_0x338d22[_0xb531('0x2b')],'type':_0x338d22[_0xb531('0x2c')][_0xb531('0x2d')]};});_0x1f9f01['model']=_[_0xb531('0x28')](_0x4ff16d,'name');_0x1f9f01['query']=_[_0xb531('0x2e')](_0x4747a8[_0xb531('0x2f')]);_0x1f9f01['filters']=_[_0xb531('0x30')](_0x1f9f01[_0xb531('0x31')],_0x1f9f01[_0xb531('0x2f')]);_0x1728b7['attributes']=_['intersection'](_0x1f9f01['model'],qs['fields'](_0x4747a8[_0xb531('0x2f')][_0xb531('0x32')]));_0x1728b7[_0xb531('0x33')]=_0x1728b7[_0xb531('0x33')][_0xb531('0x34')]?_0x1728b7['attributes']:_0x1f9f01[_0xb531('0x31')];if(!_0x4747a8['query'][_0xb531('0x35')](_0xb531('0x36'))){_0x1728b7[_0xb531('0x1c')]=qs['limit'](_0x4747a8['query'][_0xb531('0x1c')]);_0x1728b7[_0xb531('0x1b')]=qs[_0xb531('0x1b')](_0x4747a8[_0xb531('0x2f')][_0xb531('0x1b')]);}_0x1728b7[_0xb531('0x37')]=qs[_0xb531('0x38')](_0x4747a8[_0xb531('0x2f')][_0xb531('0x38')]);_0x1728b7[_0xb531('0x39')]=qs[_0xb531('0x3a')](_[_0xb531('0x3b')](_0x4747a8[_0xb531('0x2f')],_0x1f9f01[_0xb531('0x3a')]),_0x4ff16d);if(_0x4747a8[_0xb531('0x2f')][_0xb531('0x3c')]){_0x1728b7[_0xb531('0x39')]=_[_0xb531('0x3d')](_0x1728b7['where'],{'$or':_['map'](_0x4ff16d,function(_0x2dafdc){if(_0x2dafdc[_0xb531('0x2c')]!==_0xb531('0x3e')){var _0x33ba90={};_0x33ba90[_0x2dafdc['name']]={'$like':'%'+_0x4747a8[_0xb531('0x2f')][_0xb531('0x3c')]+'%'};return _0x33ba90;}})});}_0x1728b7=_[_0xb531('0x3d')]({},_0x1728b7,_0x4747a8[_0xb531('0x3f')]);var _0x40176e={'where':_0x1728b7[_0xb531('0x39')]};return db['MemberReport']['count'](_0x40176e)[_0xb531('0x21')](function(_0x20fbf9){_0x323677[_0xb531('0x40')]=_0x20fbf9;if(_0x4747a8[_0xb531('0x2f')][_0xb531('0x41')]){_0x1728b7[_0xb531('0x42')]=[{'all':!![]}];}return db[_0xb531('0x29')][_0xb531('0x43')](_0x1728b7);})[_0xb531('0x21')](function(_0x1f362d){_0x323677[_0xb531('0x44')]=_0x1f362d;return _0x323677;})['then'](respondWithFilteredResult(_0x13361c,_0x1728b7))[_0xb531('0x45')](handleError(_0x13361c,null));};exports[_0xb531('0x46')]=function(_0x2838e6,_0xe719f){var _0x1c31f8={'raw':!![],'where':{'id':_0x2838e6[_0xb531('0x47')]['id']}},_0x50945d={};_0x50945d['model']=_[_0xb531('0x2e')](db[_0xb531('0x29')]['rawAttributes']);_0x50945d[_0xb531('0x2f')]=_[_0xb531('0x2e')](_0x2838e6[_0xb531('0x2f')]);_0x50945d[_0xb531('0x3a')]=_[_0xb531('0x30')](_0x50945d[_0xb531('0x31')],_0x50945d[_0xb531('0x2f')]);_0x1c31f8['attributes']=_['intersection'](_0x50945d[_0xb531('0x31')],qs['fields'](_0x2838e6[_0xb531('0x2f')][_0xb531('0x32')]));_0x1c31f8[_0xb531('0x33')]=_0x1c31f8[_0xb531('0x33')][_0xb531('0x34')]?_0x1c31f8[_0xb531('0x33')]:_0x50945d[_0xb531('0x31')];if(_0x2838e6[_0xb531('0x2f')]['includeAll']){_0x1c31f8['include']=[{'all':!![]}];}_0x1c31f8=_[_0xb531('0x3d')]({},_0x1c31f8,_0x2838e6[_0xb531('0x3f')]);return db[_0xb531('0x29')]['find'](_0x1c31f8)['then'](handleEntityNotFound(_0xe719f,null))[_0xb531('0x21')](respondWithResult(_0xe719f,null))[_0xb531('0x45')](handleError(_0xe719f,null));};exports['create']=function(_0x4811ca,_0x4103e4){return db[_0xb531('0x29')][_0xb531('0x48')](_0x4811ca['body'],{})['then'](respondWithResult(_0x4103e4,0xc9))[_0xb531('0x45')](handleError(_0x4103e4,null));};exports['update']=function(_0xf383d5,_0x9b3f22){if(_0xf383d5[_0xb531('0x49')]['id']){delete _0xf383d5['body']['id'];}return db[_0xb531('0x29')]['find']({'where':{'id':_0xf383d5[_0xb531('0x47')]['id']}})[_0xb531('0x21')](handleEntityNotFound(_0x9b3f22,null))[_0xb531('0x21')](saveUpdates(_0xf383d5['body'],null))['then'](respondWithResult(_0x9b3f22,null))[_0xb531('0x45')](handleError(_0x9b3f22,null));};exports[_0xb531('0x22')]=function(_0x4e0b17,_0x1ab356){return db['MemberReport'][_0xb531('0x4a')]({'where':{'id':_0x4e0b17[_0xb531('0x47')]['id']}})['then'](handleEntityNotFound(_0x1ab356,null))[_0xb531('0x21')](removeEntity(_0x1ab356,null))[_0xb531('0x45')](handleError(_0x1ab356,null));};exports['describe']=function(_0x145c31,_0x2f0a6c){return db['MemberReport'][_0xb531('0x4b')]()[_0xb531('0x21')](respondWithResult(_0x2f0a6c,null))[_0xb531('0x45')](handleError(_0x2f0a6c,null));};
\ No newline at end of file
+var _0x34e8=['path','sox','to-csv','fs-extra','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','undefined','limit','count','offset','set','Content-Range','json','apply','reject','save','update','then','destroy','error','stack','name','map','MemberReport','rawAttributes','fieldName','type','key','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','sort','where','pick','filter','merge','options','includeAll','catch','show','params','keys','include','find','create','body','describe','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util'];(function(_0x3e112d,_0x2bb132){var _0x531c31=function(_0x1954bc){while(--_0x1954bc){_0x3e112d['push'](_0x3e112d['shift']());}};_0x531c31(++_0x2bb132);}(_0x34e8,0x12c));var _0x834e=function(_0x255b89,_0x4b326d){_0x255b89=_0x255b89-0x0;var _0x565a70=_0x34e8[_0x255b89];return _0x565a70;};'use strict';var emlformat=require(_0x834e('0x0'));var rimraf=require(_0x834e('0x1'));var zipdir=require(_0x834e('0x2'));var jsonpatch=require(_0x834e('0x3'));var rp=require('request-promise');var moment=require(_0x834e('0x4'));var BPromise=require(_0x834e('0x5'));var Mustache=require(_0x834e('0x6'));var util=require(_0x834e('0x7'));var path=require(_0x834e('0x8'));var sox=require(_0x834e('0x9'));var csv=require(_0x834e('0xa'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x834e('0xb'));var _=require('lodash');var squel=require(_0x834e('0xc'));var crypto=require(_0x834e('0xd'));var jsforce=require(_0x834e('0xe'));var deskjs=require(_0x834e('0xf'));var toCsv=require(_0x834e('0xa'));var querystring=require(_0x834e('0x10'));var Papa=require(_0x834e('0x11'));var Redis=require(_0x834e('0x12'));var authService=require(_0x834e('0x13'));var qs=require(_0x834e('0x14'));var as=require(_0x834e('0x15'));var hardwareService=require(_0x834e('0x16'));var logger=require(_0x834e('0x17'))(_0x834e('0x18'));var utils=require(_0x834e('0x19'));var config=require(_0x834e('0x1a'));var licenseUtil=require(_0x834e('0x1b'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x5e5b6d,_0x6cd9b9){_0x6cd9b9=_0x6cd9b9||0xcc;return function(_0x58a27e){if(_0x58a27e){return _0x5e5b6d[_0x834e('0x1c')](_0x6cd9b9);}return _0x5e5b6d[_0x834e('0x1d')](_0x6cd9b9)[_0x834e('0x1e')]();};}function respondWithResult(_0x21cc0a,_0x50e860){_0x50e860=_0x50e860||0xc8;return function(_0x43156c){if(_0x43156c){return _0x21cc0a[_0x834e('0x1d')](_0x50e860)['json'](_0x43156c);}};}function respondWithFilteredResult(_0x316205,_0x4a9cdc){return function(_0x38a8cd){if(_0x38a8cd){var _0x36d443=typeof _0x4a9cdc['offset']===_0x834e('0x1f')&&typeof _0x4a9cdc[_0x834e('0x20')]===_0x834e('0x1f');var _0x50b3f6=_0x38a8cd[_0x834e('0x21')];var _0x211e9a=_0x36d443?0x0:_0x4a9cdc[_0x834e('0x22')];var _0xb993a1=_0x36d443?_0x38a8cd[_0x834e('0x21')]:_0x4a9cdc[_0x834e('0x22')]+_0x4a9cdc[_0x834e('0x20')];var _0x595515;if(_0xb993a1>=_0x50b3f6){_0xb993a1=_0x50b3f6;_0x595515=0xc8;}else{_0x595515=0xce;}_0x316205[_0x834e('0x1d')](_0x595515);return _0x316205[_0x834e('0x23')](_0x834e('0x24'),_0x211e9a+'-'+_0xb993a1+'/'+_0x50b3f6)[_0x834e('0x25')](_0x38a8cd);}return null;};}function patchUpdates(_0x4ab05d){return function(_0x45a630){try{jsonpatch[_0x834e('0x26')](_0x45a630,_0x4ab05d,!![]);}catch(_0x5a05c0){return BPromise[_0x834e('0x27')](_0x5a05c0);}return _0x45a630[_0x834e('0x28')]();};}function saveUpdates(_0x8d406e,_0x5c55ca){return function(_0x4e3f48){if(_0x4e3f48){return _0x4e3f48[_0x834e('0x29')](_0x8d406e)[_0x834e('0x2a')](function(_0x589dde){return _0x589dde;});}return null;};}function removeEntity(_0x25ee1d,_0x1dc1e0){return function(_0x58f4fd){if(_0x58f4fd){return _0x58f4fd[_0x834e('0x2b')]()[_0x834e('0x2a')](function(){_0x25ee1d[_0x834e('0x1d')](0xcc)['end']();});}};}function handleEntityNotFound(_0x24fcf7,_0x3e310f){return function(_0x5e1cc5){if(!_0x5e1cc5){_0x24fcf7['sendStatus'](0x194);}return _0x5e1cc5;};}function handleError(_0x1e713a,_0x508a1d){_0x508a1d=_0x508a1d||0x1f4;return function(_0x2826ec){logger[_0x834e('0x2c')](_0x2826ec[_0x834e('0x2d')]);if(_0x2826ec[_0x834e('0x2e')]){delete _0x2826ec[_0x834e('0x2e')];}_0x1e713a[_0x834e('0x1d')](_0x508a1d)['send'](_0x2826ec);};}exports['index']=function(_0x4dc64a,_0x58c1d7){var _0x2c7a8d={},_0x567cea={},_0x106d6a={'count':0x0,'rows':[]};var _0x5dacc1=_[_0x834e('0x2f')](db[_0x834e('0x30')][_0x834e('0x31')],function(_0x1e026a){return{'name':_0x1e026a[_0x834e('0x32')],'type':_0x1e026a[_0x834e('0x33')][_0x834e('0x34')]};});_0x567cea[_0x834e('0x35')]=_[_0x834e('0x2f')](_0x5dacc1,'name');_0x567cea[_0x834e('0x36')]=_['keys'](_0x4dc64a[_0x834e('0x36')]);_0x567cea[_0x834e('0x37')]=_[_0x834e('0x38')](_0x567cea[_0x834e('0x35')],_0x567cea[_0x834e('0x36')]);_0x2c7a8d[_0x834e('0x39')]=_[_0x834e('0x38')](_0x567cea[_0x834e('0x35')],qs[_0x834e('0x3a')](_0x4dc64a[_0x834e('0x36')]['fields']));_0x2c7a8d[_0x834e('0x39')]=_0x2c7a8d[_0x834e('0x39')][_0x834e('0x3b')]?_0x2c7a8d[_0x834e('0x39')]:_0x567cea['model'];if(!_0x4dc64a[_0x834e('0x36')][_0x834e('0x3c')]('nolimit')){_0x2c7a8d['limit']=qs['limit'](_0x4dc64a[_0x834e('0x36')][_0x834e('0x20')]);_0x2c7a8d[_0x834e('0x22')]=qs[_0x834e('0x22')](_0x4dc64a[_0x834e('0x36')][_0x834e('0x22')]);}_0x2c7a8d['order']=qs[_0x834e('0x3d')](_0x4dc64a['query'][_0x834e('0x3d')]);_0x2c7a8d[_0x834e('0x3e')]=qs['filters'](_[_0x834e('0x3f')](_0x4dc64a[_0x834e('0x36')],_0x567cea['filters']),_0x5dacc1);if(_0x4dc64a['query'][_0x834e('0x40')]){_0x2c7a8d[_0x834e('0x3e')]=_[_0x834e('0x41')](_0x2c7a8d[_0x834e('0x3e')],{'$or':_[_0x834e('0x2f')](_0x5dacc1,function(_0x4ca43c){if(_0x4ca43c[_0x834e('0x33')]!=='VIRTUAL'){var _0x50c243={};_0x50c243[_0x4ca43c[_0x834e('0x2e')]]={'$like':'%'+_0x4dc64a['query'][_0x834e('0x40')]+'%'};return _0x50c243;}})});}_0x2c7a8d=_[_0x834e('0x41')]({},_0x2c7a8d,_0x4dc64a[_0x834e('0x42')]);var _0x3c59af={'where':_0x2c7a8d[_0x834e('0x3e')]};return db['MemberReport'][_0x834e('0x21')](_0x3c59af)[_0x834e('0x2a')](function(_0x38f266){_0x106d6a['count']=_0x38f266;if(_0x4dc64a[_0x834e('0x36')][_0x834e('0x43')]){_0x2c7a8d['include']=[{'all':!![]}];}return db[_0x834e('0x30')]['findAll'](_0x2c7a8d);})[_0x834e('0x2a')](function(_0x585335){_0x106d6a['rows']=_0x585335;return _0x106d6a;})['then'](respondWithFilteredResult(_0x58c1d7,_0x2c7a8d))[_0x834e('0x44')](handleError(_0x58c1d7,null));};exports[_0x834e('0x45')]=function(_0x3bcbf4,_0xbc1571){var _0x8ad264={'raw':!![],'where':{'id':_0x3bcbf4[_0x834e('0x46')]['id']}},_0x23feea={};_0x23feea['model']=_[_0x834e('0x47')](db['MemberReport'][_0x834e('0x31')]);_0x23feea['query']=_[_0x834e('0x47')](_0x3bcbf4['query']);_0x23feea[_0x834e('0x37')]=_[_0x834e('0x38')](_0x23feea['model'],_0x23feea[_0x834e('0x36')]);_0x8ad264[_0x834e('0x39')]=_[_0x834e('0x38')](_0x23feea[_0x834e('0x35')],qs[_0x834e('0x3a')](_0x3bcbf4[_0x834e('0x36')][_0x834e('0x3a')]));_0x8ad264[_0x834e('0x39')]=_0x8ad264[_0x834e('0x39')][_0x834e('0x3b')]?_0x8ad264['attributes']:_0x23feea[_0x834e('0x35')];if(_0x3bcbf4[_0x834e('0x36')]['includeAll']){_0x8ad264[_0x834e('0x48')]=[{'all':!![]}];}_0x8ad264=_[_0x834e('0x41')]({},_0x8ad264,_0x3bcbf4[_0x834e('0x42')]);return db[_0x834e('0x30')][_0x834e('0x49')](_0x8ad264)[_0x834e('0x2a')](handleEntityNotFound(_0xbc1571,null))['then'](respondWithResult(_0xbc1571,null))['catch'](handleError(_0xbc1571,null));};exports[_0x834e('0x4a')]=function(_0x1a5444,_0x30568e){return db[_0x834e('0x30')][_0x834e('0x4a')](_0x1a5444[_0x834e('0x4b')],{})[_0x834e('0x2a')](respondWithResult(_0x30568e,0xc9))[_0x834e('0x44')](handleError(_0x30568e,null));};exports[_0x834e('0x29')]=function(_0x390c45,_0xf02f0d){if(_0x390c45[_0x834e('0x4b')]['id']){delete _0x390c45[_0x834e('0x4b')]['id'];}return db[_0x834e('0x30')][_0x834e('0x49')]({'where':{'id':_0x390c45[_0x834e('0x46')]['id']}})[_0x834e('0x2a')](handleEntityNotFound(_0xf02f0d,null))[_0x834e('0x2a')](saveUpdates(_0x390c45[_0x834e('0x4b')],null))[_0x834e('0x2a')](respondWithResult(_0xf02f0d,null))['catch'](handleError(_0xf02f0d,null));};exports[_0x834e('0x2b')]=function(_0x1f08b9,_0x4e73e0){return db[_0x834e('0x30')][_0x834e('0x49')]({'where':{'id':_0x1f08b9['params']['id']}})[_0x834e('0x2a')](handleEntityNotFound(_0x4e73e0,null))[_0x834e('0x2a')](removeEntity(_0x4e73e0,null))[_0x834e('0x44')](handleError(_0x4e73e0,null));};exports[_0x834e('0x4c')]=function(_0x4288e4,_0xb77aab){return db[_0x834e('0x30')]['describe']()[_0x834e('0x2a')](respondWithResult(_0xb77aab,null))[_0x834e('0x44')](handleError(_0xb77aab,null));};
\ No newline at end of file