server/api/squareReport/squareReport.controller.js

   1 // *************************************************************************
   2 // *                                                                       *
   3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
   4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
   5 // *                                                                       *
   6 // *************************************************************************
   7 // *                                                                       *
   8 // * Email: info@xcally.com                                                *
   9 // * Website: https://www.xcally.com                                       *
  10 // *                                                                       *
  11 // *************************************************************************
  12 // *                                                                       *
  13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
  14 // * copyright treaties, as well as other intellectual property laws and   *
  15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
  16 // *                                                                       *
  17 // *************************************************************************
  18 var _0xc86f=['fieldName','type','query','keys','filters','intersection','model','attributes','fields','hasOwnProperty','nolimit','order','sort','where','pick','filter','VIRTUAL','merge','options','includeAll','include','findAll','rows','show','length','find','catch','create','body','params','describe','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','path','sox','to-csv','fs-extra','crypto','jsforce','desk.js','querystring','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','limit','undefined','count','offset','Content-Range','apply','save','update','then','destroy','error','stack','name','send','index','map','SquareReport'];(function(_0x12553d,_0x160725){var _0x166267=function(_0x49f7ae){while(--_0x49f7ae){_0x12553d['push'](_0x12553d['shift']());}};_0x166267(++_0x160725);}(_0xc86f,0x1db));var _0xfc86=function(_0x2cf437,_0x5b0508){_0x2cf437=_0x2cf437-0x0;var _0x2f1fd2=_0xc86f[_0x2cf437];return _0x2f1fd2;};'use strict';var emlformat=require(_0xfc86('0x0'));var rimraf=require(_0xfc86('0x1'));var zipdir=require(_0xfc86('0x2'));var jsonpatch=require(_0xfc86('0x3'));var rp=require(_0xfc86('0x4'));var moment=require(_0xfc86('0x5'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require('util');var path=require(_0xfc86('0x6'));var sox=require(_0xfc86('0x7'));var csv=require(_0xfc86('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xfc86('0x9'));var _=require('lodash');var squel=require('squel');var crypto=require(_0xfc86('0xa'));var jsforce=require(_0xfc86('0xb'));var deskjs=require(_0xfc86('0xc'));var toCsv=require(_0xfc86('0x8'));var querystring=require(_0xfc86('0xd'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0xfc86('0xe'));var qs=require(_0xfc86('0xf'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xfc86('0x10'));var logger=require('../../config/logger')(_0xfc86('0x11'));var utils=require(_0xfc86('0x12'));var config=require(_0xfc86('0x13'));var licenseUtil=require(_0xfc86('0x14'));var db=require(_0xfc86('0x15'))['db'];function respondWithStatusCode(_0x4561e2,_0x283b4e){_0x283b4e=_0x283b4e||0xcc;return function(_0x300aab){if(_0x300aab){return _0x4561e2[_0xfc86('0x16')](_0x283b4e);}return _0x4561e2[_0xfc86('0x17')](_0x283b4e)[_0xfc86('0x18')]();};}function respondWithResult(_0x2cecaa,_0x1efd64){_0x1efd64=_0x1efd64||0xc8;return function(_0x1b398c){if(_0x1b398c){return _0x2cecaa[_0xfc86('0x17')](_0x1efd64)[_0xfc86('0x19')](_0x1b398c);}};}function respondWithFilteredResult(_0x27b367,_0x4d9a29){return function(_0x4629ff){if(_0x4629ff){var _0x3b7240=typeof _0x4d9a29['offset']==='undefined'&&typeof _0x4d9a29[_0xfc86('0x1a')]===_0xfc86('0x1b');var _0x4eccfe=_0x4629ff[_0xfc86('0x1c')];var _0x2c3890=_0x3b7240?0x0:_0x4d9a29[_0xfc86('0x1d')];var _0x475e9f=_0x3b7240?_0x4629ff[_0xfc86('0x1c')]:_0x4d9a29[_0xfc86('0x1d')]+_0x4d9a29[_0xfc86('0x1a')];var _0x5e8884;if(_0x475e9f>=_0x4eccfe){_0x475e9f=_0x4eccfe;_0x5e8884=0xc8;}else{_0x5e8884=0xce;}_0x27b367[_0xfc86('0x17')](_0x5e8884);return _0x27b367['set'](_0xfc86('0x1e'),_0x2c3890+'-'+_0x475e9f+'/'+_0x4eccfe)[_0xfc86('0x19')](_0x4629ff);}return null;};}function patchUpdates(_0x18bb2a){return function(_0x52c700){try{jsonpatch[_0xfc86('0x1f')](_0x52c700,_0x18bb2a,!![]);}catch(_0x18227d){return BPromise['reject'](_0x18227d);}return _0x52c700[_0xfc86('0x20')]();};}function saveUpdates(_0x773c3e,_0x4466e5){return function(_0x25d98d){if(_0x25d98d){return _0x25d98d[_0xfc86('0x21')](_0x773c3e)[_0xfc86('0x22')](function(_0x55aa77){return _0x55aa77;});}return null;};}function removeEntity(_0x219d99,_0x1291f7){return function(_0x3803a7){if(_0x3803a7){return _0x3803a7[_0xfc86('0x23')]()[_0xfc86('0x22')](function(){_0x219d99[_0xfc86('0x17')](0xcc)[_0xfc86('0x18')]();});}};}function handleEntityNotFound(_0x30dcfb,_0x4a46a0){return function(_0x3b36bf){if(!_0x3b36bf){_0x30dcfb[_0xfc86('0x16')](0x194);}return _0x3b36bf;};}function handleError(_0x4a6a00,_0x592c61){_0x592c61=_0x592c61||0x1f4;return function(_0x36e70c){logger[_0xfc86('0x24')](_0x36e70c[_0xfc86('0x25')]);if(_0x36e70c[_0xfc86('0x26')]){delete _0x36e70c[_0xfc86('0x26')];}_0x4a6a00['status'](_0x592c61)[_0xfc86('0x27')](_0x36e70c);};}exports[_0xfc86('0x28')]=function(_0x5a90d7,_0x40740c){var _0x1bd541={},_0xe1422d={},_0x4cc93c={'count':0x0,'rows':[]};var _0x375990=_[_0xfc86('0x29')](db[_0xfc86('0x2a')]['rawAttributes'],function(_0x198eca){return{'name':_0x198eca[_0xfc86('0x2b')],'type':_0x198eca[_0xfc86('0x2c')]['key']};});_0xe1422d['model']=_[_0xfc86('0x29')](_0x375990,_0xfc86('0x26'));_0xe1422d[_0xfc86('0x2d')]=_[_0xfc86('0x2e')](_0x5a90d7['query']);_0xe1422d[_0xfc86('0x2f')]=_[_0xfc86('0x30')](_0xe1422d[_0xfc86('0x31')],_0xe1422d[_0xfc86('0x2d')]);_0x1bd541[_0xfc86('0x32')]=_[_0xfc86('0x30')](_0xe1422d[_0xfc86('0x31')],qs['fields'](_0x5a90d7[_0xfc86('0x2d')][_0xfc86('0x33')]));_0x1bd541[_0xfc86('0x32')]=_0x1bd541[_0xfc86('0x32')]['length']?_0x1bd541['attributes']:_0xe1422d[_0xfc86('0x31')];if(!_0x5a90d7[_0xfc86('0x2d')][_0xfc86('0x34')](_0xfc86('0x35'))){_0x1bd541[_0xfc86('0x1a')]=qs['limit'](_0x5a90d7[_0xfc86('0x2d')]['limit']);_0x1bd541[_0xfc86('0x1d')]=qs[_0xfc86('0x1d')](_0x5a90d7[_0xfc86('0x2d')][_0xfc86('0x1d')]);}_0x1bd541[_0xfc86('0x36')]=qs[_0xfc86('0x37')](_0x5a90d7['query'][_0xfc86('0x37')]);_0x1bd541[_0xfc86('0x38')]=qs[_0xfc86('0x2f')](_[_0xfc86('0x39')](_0x5a90d7['query'],_0xe1422d[_0xfc86('0x2f')]),_0x375990);if(_0x5a90d7['query'][_0xfc86('0x3a')]){_0x1bd541['where']=_['merge'](_0x1bd541[_0xfc86('0x38')],{'$or':_['map'](_0x375990,function(_0x23cdd3){if(_0x23cdd3[_0xfc86('0x2c')]!==_0xfc86('0x3b')){var _0x4b4237={};_0x4b4237[_0x23cdd3[_0xfc86('0x26')]]={'$like':'%'+_0x5a90d7[_0xfc86('0x2d')][_0xfc86('0x3a')]+'%'};return _0x4b4237;}})});}_0x1bd541=_[_0xfc86('0x3c')]({},_0x1bd541,_0x5a90d7[_0xfc86('0x3d')]);var _0x23f2c9={'where':_0x1bd541[_0xfc86('0x38')]};return db[_0xfc86('0x2a')]['count'](_0x23f2c9)['then'](function(_0xc3d0d){_0x4cc93c[_0xfc86('0x1c')]=_0xc3d0d;if(_0x5a90d7[_0xfc86('0x2d')][_0xfc86('0x3e')]){_0x1bd541[_0xfc86('0x3f')]=[{'all':!![]}];}return db[_0xfc86('0x2a')][_0xfc86('0x40')](_0x1bd541);})[_0xfc86('0x22')](function(_0x2312be){_0x4cc93c[_0xfc86('0x41')]=_0x2312be;return _0x4cc93c;})[_0xfc86('0x22')](respondWithFilteredResult(_0x40740c,_0x1bd541))['catch'](handleError(_0x40740c,null));};exports[_0xfc86('0x42')]=function(_0x27ffb9,_0x9c53){var _0x2a90d5={'raw':!![],'where':{'id':_0x27ffb9['params']['id']}},_0x16dabd={};_0x16dabd[_0xfc86('0x31')]=_[_0xfc86('0x2e')](db[_0xfc86('0x2a')]['rawAttributes']);_0x16dabd[_0xfc86('0x2d')]=_['keys'](_0x27ffb9['query']);_0x16dabd['filters']=_['intersection'](_0x16dabd[_0xfc86('0x31')],_0x16dabd['query']);_0x2a90d5[_0xfc86('0x32')]=_[_0xfc86('0x30')](_0x16dabd[_0xfc86('0x31')],qs[_0xfc86('0x33')](_0x27ffb9[_0xfc86('0x2d')][_0xfc86('0x33')]));_0x2a90d5[_0xfc86('0x32')]=_0x2a90d5[_0xfc86('0x32')][_0xfc86('0x43')]?_0x2a90d5[_0xfc86('0x32')]:_0x16dabd[_0xfc86('0x31')];if(_0x27ffb9[_0xfc86('0x2d')][_0xfc86('0x3e')]){_0x2a90d5['include']=[{'all':!![]}];}_0x2a90d5=_[_0xfc86('0x3c')]({},_0x2a90d5,_0x27ffb9['options']);return db[_0xfc86('0x2a')][_0xfc86('0x44')](_0x2a90d5)[_0xfc86('0x22')](handleEntityNotFound(_0x9c53,null))[_0xfc86('0x22')](respondWithResult(_0x9c53,null))[_0xfc86('0x45')](handleError(_0x9c53,null));};exports[_0xfc86('0x46')]=function(_0x2297e3,_0x4bb5f0){return db[_0xfc86('0x2a')]['create'](_0x2297e3['body'],{})[_0xfc86('0x22')](respondWithResult(_0x4bb5f0,0xc9))['catch'](handleError(_0x4bb5f0,null));};exports[_0xfc86('0x21')]=function(_0x28956a,_0xdc5380){if(_0x28956a['body']['id']){delete _0x28956a[_0xfc86('0x47')]['id'];}return db[_0xfc86('0x2a')][_0xfc86('0x44')]({'where':{'id':_0x28956a[_0xfc86('0x48')]['id']}})[_0xfc86('0x22')](handleEntityNotFound(_0xdc5380,null))[_0xfc86('0x22')](saveUpdates(_0x28956a[_0xfc86('0x47')],null))[_0xfc86('0x22')](respondWithResult(_0xdc5380,null))[_0xfc86('0x45')](handleError(_0xdc5380,null));};exports[_0xfc86('0x23')]=function(_0x58f0a5,_0x563da5){return db[_0xfc86('0x2a')][_0xfc86('0x44')]({'where':{'id':_0x58f0a5[_0xfc86('0x48')]['id']}})[_0xfc86('0x22')](handleEntityNotFound(_0x563da5,null))[_0xfc86('0x22')](removeEntity(_0x563da5,null))['catch'](handleError(_0x563da5,null));};exports[_0xfc86('0x49')]=function(_0x52d11b,_0x597c5c){return db['SquareReport'][_0xfc86('0x49')]()['then'](respondWithResult(_0x597c5c,null))[_0xfc86('0x45')](handleError(_0x597c5c,null));};