Built motion from commit 9e1399f3.|2.5.37
[motion2.git] / server / api / analyticTreeReport / analyticTreeReport.controller.js
index 2401685..fa53e40 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x3bc9=['desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','sendStatus','offset','undefined','count','limit','status','set','Content-Range','json','apply','reject','update','end','error','stack','name','index','map','AnalyticTreeReport','rawAttributes','fieldName','key','query','keys','filters','intersection','model','attributes','fields','length','nolimit','order','pick','filter','VIRTUAL','merge','where','then','includeAll','include','findAll','rows','catch','show','params','options','find','create','body','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce'];(function(_0x52ee7c,_0x14fb87){var _0x1b0208=function(_0x38e261){while(--_0x38e261){_0x52ee7c['push'](_0x52ee7c['shift']());}};_0x1b0208(++_0x14fb87);}(_0x3bc9,0x1b1));var _0x93bc=function(_0x3a5dbe,_0x1633de){_0x3a5dbe=_0x3a5dbe-0x0;var _0x2f1823=_0x3bc9[_0x3a5dbe];return _0x2f1823;};'use strict';var emlformat=require(_0x93bc('0x0'));var rimraf=require(_0x93bc('0x1'));var zipdir=require(_0x93bc('0x2'));var jsonpatch=require(_0x93bc('0x3'));var rp=require(_0x93bc('0x4'));var moment=require(_0x93bc('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x93bc('0x6'));var util=require(_0x93bc('0x7'));var path=require(_0x93bc('0x8'));var sox=require(_0x93bc('0x9'));var csv=require(_0x93bc('0xa'));var ejs=require(_0x93bc('0xb'));var fs=require('fs');var fs_extra=require(_0x93bc('0xc'));var _=require(_0x93bc('0xd'));var squel=require(_0x93bc('0xe'));var crypto=require(_0x93bc('0xf'));var jsforce=require(_0x93bc('0x10'));var deskjs=require(_0x93bc('0x11'));var toCsv=require(_0x93bc('0xa'));var querystring=require(_0x93bc('0x12'));var Papa=require(_0x93bc('0x13'));var Redis=require(_0x93bc('0x14'));var authService=require(_0x93bc('0x15'));var qs=require('../../components/parsers/qs');var as=require(_0x93bc('0x16'));var hardwareService=require(_0x93bc('0x17'));var logger=require(_0x93bc('0x18'))(_0x93bc('0x19'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x45ccad,_0x158e82){_0x158e82=_0x158e82||0xcc;return function(_0x52df3e){if(_0x52df3e){return _0x45ccad[_0x93bc('0x1a')](_0x158e82);}return _0x45ccad['status'](_0x158e82)['end']();};}function respondWithResult(_0x442967,_0x1acdcd){_0x1acdcd=_0x1acdcd||0xc8;return function(_0x3452ad){if(_0x3452ad){return _0x442967['status'](_0x1acdcd)['json'](_0x3452ad);}};}function respondWithFilteredResult(_0x12c80f,_0x7a09d0){return function(_0x46ebd9){if(_0x46ebd9){var _0x516627=typeof _0x7a09d0[_0x93bc('0x1b')]===_0x93bc('0x1c')&&typeof _0x7a09d0['limit']==='undefined';var _0x1ce611=_0x46ebd9['count'];var _0x429497=_0x516627?0x0:_0x7a09d0['offset'];var _0x4c39d9=_0x516627?_0x46ebd9[_0x93bc('0x1d')]:_0x7a09d0['offset']+_0x7a09d0[_0x93bc('0x1e')];var _0x15f63d;if(_0x4c39d9>=_0x1ce611){_0x4c39d9=_0x1ce611;_0x15f63d=0xc8;}else{_0x15f63d=0xce;}_0x12c80f[_0x93bc('0x1f')](_0x15f63d);return _0x12c80f[_0x93bc('0x20')](_0x93bc('0x21'),_0x429497+'-'+_0x4c39d9+'/'+_0x1ce611)[_0x93bc('0x22')](_0x46ebd9);}return null;};}function patchUpdates(_0x3c112f){return function(_0x4df767){try{jsonpatch[_0x93bc('0x23')](_0x4df767,_0x3c112f,!![]);}catch(_0x2d2142){return BPromise[_0x93bc('0x24')](_0x2d2142);}return _0x4df767['save']();};}function saveUpdates(_0x436f43,_0x3ec55b){return function(_0x19fa69){if(_0x19fa69){return _0x19fa69[_0x93bc('0x25')](_0x436f43)['then'](function(_0x5d17ee){return _0x5d17ee;});}return null;};}function removeEntity(_0x4afac1,_0x165540){return function(_0x11098a){if(_0x11098a){return _0x11098a['destroy']()['then'](function(){_0x4afac1[_0x93bc('0x1f')](0xcc)[_0x93bc('0x26')]();});}};}function handleEntityNotFound(_0x45cc4b,_0x547ded){return function(_0x3bafb6){if(!_0x3bafb6){_0x45cc4b['sendStatus'](0x194);}return _0x3bafb6;};}function handleError(_0x48b378,_0x5d28a8){_0x5d28a8=_0x5d28a8||0x1f4;return function(_0x501827){logger[_0x93bc('0x27')](_0x501827[_0x93bc('0x28')]);if(_0x501827['name']){delete _0x501827[_0x93bc('0x29')];}_0x48b378[_0x93bc('0x1f')](_0x5d28a8)['send'](_0x501827);};}exports[_0x93bc('0x2a')]=function(_0x1fc515,_0x244dde){var _0x5ac41b={},_0x39efef={},_0x245a15={'count':0x0,'rows':[]};var _0x227222=_[_0x93bc('0x2b')](db[_0x93bc('0x2c')][_0x93bc('0x2d')],function(_0x6c8209){return{'name':_0x6c8209[_0x93bc('0x2e')],'type':_0x6c8209['type'][_0x93bc('0x2f')]};});_0x39efef['model']=_[_0x93bc('0x2b')](_0x227222,_0x93bc('0x29'));_0x39efef[_0x93bc('0x30')]=_[_0x93bc('0x31')](_0x1fc515[_0x93bc('0x30')]);_0x39efef[_0x93bc('0x32')]=_[_0x93bc('0x33')](_0x39efef[_0x93bc('0x34')],_0x39efef['query']);_0x5ac41b[_0x93bc('0x35')]=_[_0x93bc('0x33')](_0x39efef['model'],qs[_0x93bc('0x36')](_0x1fc515[_0x93bc('0x30')][_0x93bc('0x36')]));_0x5ac41b[_0x93bc('0x35')]=_0x5ac41b['attributes'][_0x93bc('0x37')]?_0x5ac41b[_0x93bc('0x35')]:_0x39efef[_0x93bc('0x34')];if(!_0x1fc515['query']['hasOwnProperty'](_0x93bc('0x38'))){_0x5ac41b[_0x93bc('0x1e')]=qs[_0x93bc('0x1e')](_0x1fc515['query']['limit']);_0x5ac41b[_0x93bc('0x1b')]=qs[_0x93bc('0x1b')](_0x1fc515['query'][_0x93bc('0x1b')]);}_0x5ac41b[_0x93bc('0x39')]=qs['sort'](_0x1fc515[_0x93bc('0x30')]['sort']);_0x5ac41b['where']=qs['filters'](_[_0x93bc('0x3a')](_0x1fc515[_0x93bc('0x30')],_0x39efef[_0x93bc('0x32')]),_0x227222);if(_0x1fc515['query'][_0x93bc('0x3b')]){_0x5ac41b['where']=_['merge'](_0x5ac41b['where'],{'$or':_['map'](_0x227222,function(_0x3d0a91){if(_0x3d0a91['type']!==_0x93bc('0x3c')){var _0x142dfd={};_0x142dfd[_0x3d0a91[_0x93bc('0x29')]]={'$like':'%'+_0x1fc515['query'][_0x93bc('0x3b')]+'%'};return _0x142dfd;}})});}_0x5ac41b=_[_0x93bc('0x3d')]({},_0x5ac41b,_0x1fc515['options']);var _0x4ac3e1={'where':_0x5ac41b[_0x93bc('0x3e')]};return db[_0x93bc('0x2c')][_0x93bc('0x1d')](_0x4ac3e1)[_0x93bc('0x3f')](function(_0x2f1a2a){_0x245a15[_0x93bc('0x1d')]=_0x2f1a2a;if(_0x1fc515[_0x93bc('0x30')][_0x93bc('0x40')]){_0x5ac41b[_0x93bc('0x41')]=[{'all':!![]}];}return db[_0x93bc('0x2c')][_0x93bc('0x42')](_0x5ac41b);})[_0x93bc('0x3f')](function(_0x1f93b2){_0x245a15[_0x93bc('0x43')]=_0x1f93b2;return _0x245a15;})['then'](respondWithFilteredResult(_0x244dde,_0x5ac41b))[_0x93bc('0x44')](handleError(_0x244dde,null));};exports[_0x93bc('0x45')]=function(_0x3e3ce9,_0x1bdf8a){var _0x2a51ea={'raw':!![],'where':{'id':_0x3e3ce9[_0x93bc('0x46')]['id']}},_0x302ddd={};_0x302ddd['model']=_['keys'](db['AnalyticTreeReport'][_0x93bc('0x2d')]);_0x302ddd[_0x93bc('0x30')]=_['keys'](_0x3e3ce9['query']);_0x302ddd[_0x93bc('0x32')]=_[_0x93bc('0x33')](_0x302ddd['model'],_0x302ddd[_0x93bc('0x30')]);_0x2a51ea[_0x93bc('0x35')]=_['intersection'](_0x302ddd['model'],qs[_0x93bc('0x36')](_0x3e3ce9[_0x93bc('0x30')]['fields']));_0x2a51ea[_0x93bc('0x35')]=_0x2a51ea[_0x93bc('0x35')][_0x93bc('0x37')]?_0x2a51ea[_0x93bc('0x35')]:_0x302ddd[_0x93bc('0x34')];if(_0x3e3ce9['query'][_0x93bc('0x40')]){_0x2a51ea[_0x93bc('0x41')]=[{'all':!![]}];}_0x2a51ea=_[_0x93bc('0x3d')]({},_0x2a51ea,_0x3e3ce9[_0x93bc('0x47')]);return db[_0x93bc('0x2c')][_0x93bc('0x48')](_0x2a51ea)['then'](handleEntityNotFound(_0x1bdf8a,null))[_0x93bc('0x3f')](respondWithResult(_0x1bdf8a,null))[_0x93bc('0x44')](handleError(_0x1bdf8a,null));};exports[_0x93bc('0x49')]=function(_0xc9fe5b,_0x40d3ff){return db[_0x93bc('0x2c')][_0x93bc('0x49')](_0xc9fe5b['body'],{})['then'](respondWithResult(_0x40d3ff,0xc9))['catch'](handleError(_0x40d3ff,null));};exports[_0x93bc('0x25')]=function(_0xe4ce3c,_0x2289c4){if(_0xe4ce3c['body']['id']){delete _0xe4ce3c[_0x93bc('0x4a')]['id'];}return db[_0x93bc('0x2c')][_0x93bc('0x48')]({'where':{'id':_0xe4ce3c[_0x93bc('0x46')]['id']}})[_0x93bc('0x3f')](handleEntityNotFound(_0x2289c4,null))[_0x93bc('0x3f')](saveUpdates(_0xe4ce3c[_0x93bc('0x4a')],null))[_0x93bc('0x3f')](respondWithResult(_0x2289c4,null))[_0x93bc('0x44')](handleError(_0x2289c4,null));};exports['destroy']=function(_0x237b04,_0x28c806){return db[_0x93bc('0x2c')][_0x93bc('0x48')]({'where':{'id':_0x237b04[_0x93bc('0x46')]['id']}})[_0x93bc('0x3f')](handleEntityNotFound(_0x28c806,null))[_0x93bc('0x3f')](removeEntity(_0x28c806,null))[_0x93bc('0x44')](handleError(_0x28c806,null));};
\ No newline at end of file
+var _0x3ff1=['squel','crypto','desk.js','querystring','ioredis','../../components/auth/service','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','status','offset','undefined','limit','count','set','Content-Range','json','apply','reject','save','update','then','end','sendStatus','error','stack','name','send','map','AnalyticTreeReport','rawAttributes','fieldName','type','model','query','keys','intersection','fields','attributes','length','nolimit','order','sort','filters','pick','filter','where','merge','options','includeAll','include','findAll','rows','catch','show','params','find','body','destroy','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','lodash'];(function(_0x2a5651,_0x4b9dfa){var _0xcf4e0b=function(_0x1f9c18){while(--_0x1f9c18){_0x2a5651['push'](_0x2a5651['shift']());}};_0xcf4e0b(++_0x4b9dfa);}(_0x3ff1,0xd0));var _0x13ff=function(_0x5efb91,_0x39b378){_0x5efb91=_0x5efb91-0x0;var _0x57ff36=_0x3ff1[_0x5efb91];return _0x57ff36;};'use strict';var emlformat=require(_0x13ff('0x0'));var rimraf=require(_0x13ff('0x1'));var zipdir=require(_0x13ff('0x2'));var jsonpatch=require(_0x13ff('0x3'));var rp=require(_0x13ff('0x4'));var moment=require(_0x13ff('0x5'));var BPromise=require(_0x13ff('0x6'));var Mustache=require(_0x13ff('0x7'));var util=require(_0x13ff('0x8'));var path=require('path');var sox=require(_0x13ff('0x9'));var csv=require(_0x13ff('0xa'));var ejs=require(_0x13ff('0xb'));var fs=require('fs');var fs_extra=require(_0x13ff('0xc'));var _=require(_0x13ff('0xd'));var squel=require(_0x13ff('0xe'));var crypto=require(_0x13ff('0xf'));var jsforce=require('jsforce');var deskjs=require(_0x13ff('0x10'));var toCsv=require(_0x13ff('0xa'));var querystring=require(_0x13ff('0x11'));var Papa=require('papaparse');var Redis=require(_0x13ff('0x12'));var authService=require(_0x13ff('0x13'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x13ff('0x14'));var logger=require(_0x13ff('0x15'))('api');var utils=require(_0x13ff('0x16'));var config=require(_0x13ff('0x17'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x2352a7,_0x39e8a5){_0x39e8a5=_0x39e8a5||0xcc;return function(_0x21adfa){if(_0x21adfa){return _0x2352a7['sendStatus'](_0x39e8a5);}return _0x2352a7['status'](_0x39e8a5)['end']();};}function respondWithResult(_0x2a93fb,_0x257af3){_0x257af3=_0x257af3||0xc8;return function(_0xe80015){if(_0xe80015){return _0x2a93fb[_0x13ff('0x18')](_0x257af3)['json'](_0xe80015);}};}function respondWithFilteredResult(_0x379d58,_0x2740a8){return function(_0x5f2bdf){if(_0x5f2bdf){var _0x3b529d=typeof _0x2740a8[_0x13ff('0x19')]===_0x13ff('0x1a')&&typeof _0x2740a8[_0x13ff('0x1b')]==='undefined';var _0x240f05=_0x5f2bdf[_0x13ff('0x1c')];var _0x2440e9=_0x3b529d?0x0:_0x2740a8['offset'];var _0x262056=_0x3b529d?_0x5f2bdf[_0x13ff('0x1c')]:_0x2740a8[_0x13ff('0x19')]+_0x2740a8[_0x13ff('0x1b')];var _0x399a58;if(_0x262056>=_0x240f05){_0x262056=_0x240f05;_0x399a58=0xc8;}else{_0x399a58=0xce;}_0x379d58[_0x13ff('0x18')](_0x399a58);return _0x379d58[_0x13ff('0x1d')](_0x13ff('0x1e'),_0x2440e9+'-'+_0x262056+'/'+_0x240f05)[_0x13ff('0x1f')](_0x5f2bdf);}return null;};}function patchUpdates(_0x58e0ea){return function(_0xc27205){try{jsonpatch[_0x13ff('0x20')](_0xc27205,_0x58e0ea,!![]);}catch(_0xd89295){return BPromise[_0x13ff('0x21')](_0xd89295);}return _0xc27205[_0x13ff('0x22')]();};}function saveUpdates(_0xa7ab1a,_0x27876e){return function(_0x46f3e5){if(_0x46f3e5){return _0x46f3e5[_0x13ff('0x23')](_0xa7ab1a)[_0x13ff('0x24')](function(_0x686019){return _0x686019;});}return null;};}function removeEntity(_0x5b5d91,_0x268ccc){return function(_0x2f1b0d){if(_0x2f1b0d){return _0x2f1b0d['destroy']()[_0x13ff('0x24')](function(){_0x5b5d91['status'](0xcc)[_0x13ff('0x25')]();});}};}function handleEntityNotFound(_0x178baa,_0x3ace5a){return function(_0x367bc9){if(!_0x367bc9){_0x178baa[_0x13ff('0x26')](0x194);}return _0x367bc9;};}function handleError(_0x386e4c,_0x32cf49){_0x32cf49=_0x32cf49||0x1f4;return function(_0xdbc369){logger[_0x13ff('0x27')](_0xdbc369[_0x13ff('0x28')]);if(_0xdbc369[_0x13ff('0x29')]){delete _0xdbc369[_0x13ff('0x29')];}_0x386e4c[_0x13ff('0x18')](_0x32cf49)[_0x13ff('0x2a')](_0xdbc369);};}exports['index']=function(_0x21a766,_0x3eae4f){var _0x514578={},_0x234960={},_0xa1c997={'count':0x0,'rows':[]};var _0x1bc2b1=_[_0x13ff('0x2b')](db[_0x13ff('0x2c')][_0x13ff('0x2d')],function(_0x3f9e94){return{'name':_0x3f9e94[_0x13ff('0x2e')],'type':_0x3f9e94[_0x13ff('0x2f')]['key']};});_0x234960[_0x13ff('0x30')]=_[_0x13ff('0x2b')](_0x1bc2b1,_0x13ff('0x29'));_0x234960[_0x13ff('0x31')]=_[_0x13ff('0x32')](_0x21a766['query']);_0x234960['filters']=_[_0x13ff('0x33')](_0x234960[_0x13ff('0x30')],_0x234960[_0x13ff('0x31')]);_0x514578['attributes']=_['intersection'](_0x234960['model'],qs[_0x13ff('0x34')](_0x21a766[_0x13ff('0x31')][_0x13ff('0x34')]));_0x514578[_0x13ff('0x35')]=_0x514578[_0x13ff('0x35')][_0x13ff('0x36')]?_0x514578[_0x13ff('0x35')]:_0x234960[_0x13ff('0x30')];if(!_0x21a766[_0x13ff('0x31')]['hasOwnProperty'](_0x13ff('0x37'))){_0x514578[_0x13ff('0x1b')]=qs[_0x13ff('0x1b')](_0x21a766['query'][_0x13ff('0x1b')]);_0x514578[_0x13ff('0x19')]=qs['offset'](_0x21a766[_0x13ff('0x31')][_0x13ff('0x19')]);}_0x514578[_0x13ff('0x38')]=qs[_0x13ff('0x39')](_0x21a766[_0x13ff('0x31')]['sort']);_0x514578['where']=qs[_0x13ff('0x3a')](_[_0x13ff('0x3b')](_0x21a766[_0x13ff('0x31')],_0x234960['filters']),_0x1bc2b1);if(_0x21a766['query'][_0x13ff('0x3c')]){_0x514578[_0x13ff('0x3d')]=_[_0x13ff('0x3e')](_0x514578[_0x13ff('0x3d')],{'$or':_['map'](_0x1bc2b1,function(_0x6b14c5){if(_0x6b14c5['type']!=='VIRTUAL'){var _0x3b9aad={};_0x3b9aad[_0x6b14c5[_0x13ff('0x29')]]={'$like':'%'+_0x21a766['query'][_0x13ff('0x3c')]+'%'};return _0x3b9aad;}})});}_0x514578=_[_0x13ff('0x3e')]({},_0x514578,_0x21a766[_0x13ff('0x3f')]);var _0x549d72={'where':_0x514578[_0x13ff('0x3d')]};return db[_0x13ff('0x2c')][_0x13ff('0x1c')](_0x549d72)['then'](function(_0x30bff7){_0xa1c997[_0x13ff('0x1c')]=_0x30bff7;if(_0x21a766['query'][_0x13ff('0x40')]){_0x514578[_0x13ff('0x41')]=[{'all':!![]}];}return db[_0x13ff('0x2c')][_0x13ff('0x42')](_0x514578);})[_0x13ff('0x24')](function(_0x2eef82){_0xa1c997[_0x13ff('0x43')]=_0x2eef82;return _0xa1c997;})['then'](respondWithFilteredResult(_0x3eae4f,_0x514578))[_0x13ff('0x44')](handleError(_0x3eae4f,null));};exports[_0x13ff('0x45')]=function(_0x91196e,_0x594a8e){var _0x552d7d={'raw':!![],'where':{'id':_0x91196e[_0x13ff('0x46')]['id']}},_0x2a98bf={};_0x2a98bf['model']=_[_0x13ff('0x32')](db[_0x13ff('0x2c')]['rawAttributes']);_0x2a98bf[_0x13ff('0x31')]=_[_0x13ff('0x32')](_0x91196e[_0x13ff('0x31')]);_0x2a98bf[_0x13ff('0x3a')]=_[_0x13ff('0x33')](_0x2a98bf['model'],_0x2a98bf['query']);_0x552d7d[_0x13ff('0x35')]=_[_0x13ff('0x33')](_0x2a98bf[_0x13ff('0x30')],qs[_0x13ff('0x34')](_0x91196e[_0x13ff('0x31')][_0x13ff('0x34')]));_0x552d7d[_0x13ff('0x35')]=_0x552d7d['attributes'][_0x13ff('0x36')]?_0x552d7d['attributes']:_0x2a98bf[_0x13ff('0x30')];if(_0x91196e[_0x13ff('0x31')][_0x13ff('0x40')]){_0x552d7d[_0x13ff('0x41')]=[{'all':!![]}];}_0x552d7d=_[_0x13ff('0x3e')]({},_0x552d7d,_0x91196e['options']);return db[_0x13ff('0x2c')][_0x13ff('0x47')](_0x552d7d)[_0x13ff('0x24')](handleEntityNotFound(_0x594a8e,null))['then'](respondWithResult(_0x594a8e,null))[_0x13ff('0x44')](handleError(_0x594a8e,null));};exports['create']=function(_0x4d60f6,_0x306363){return db[_0x13ff('0x2c')]['create'](_0x4d60f6[_0x13ff('0x48')],{})[_0x13ff('0x24')](respondWithResult(_0x306363,0xc9))['catch'](handleError(_0x306363,null));};exports['update']=function(_0x4ce620,_0x25453e){if(_0x4ce620[_0x13ff('0x48')]['id']){delete _0x4ce620[_0x13ff('0x48')]['id'];}return db[_0x13ff('0x2c')][_0x13ff('0x47')]({'where':{'id':_0x4ce620[_0x13ff('0x46')]['id']}})[_0x13ff('0x24')](handleEntityNotFound(_0x25453e,null))[_0x13ff('0x24')](saveUpdates(_0x4ce620[_0x13ff('0x48')],null))[_0x13ff('0x24')](respondWithResult(_0x25453e,null))[_0x13ff('0x44')](handleError(_0x25453e,null));};exports[_0x13ff('0x49')]=function(_0x217ca5,_0x1d6b33){return db[_0x13ff('0x2c')][_0x13ff('0x47')]({'where':{'id':_0x217ca5[_0x13ff('0x46')]['id']}})['then'](handleEntityNotFound(_0x1d6b33,null))[_0x13ff('0x24')](removeEntity(_0x1d6b33,null))[_0x13ff('0x44')](handleError(_0x1d6b33,null));};
\ No newline at end of file