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 _0x2d7e=['../../components/auth/service','../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','status','json','offset','undefined','count','limit','set','apply','reject','save','update','then','end','sendStatus','stack','name','index','map','SquareReport','rawAttributes','fieldName','type','model','query','keys','intersection','fields','attributes','nolimit','order','sort','where','filters','pick','merge','VIRTUAL','options','includeAll','include','findAll','catch','show','params','length','find','create','body','destroy','describe','eml-format','zip-dir','fast-json-patch','moment','bluebird','util','path','sox','to-csv','fs-extra','crypto','jsforce','desk.js','querystring','papaparse','ioredis'];(function(_0x3ab51d,_0x2fa01d){var _0x29a04e=function(_0x7807b0){while(--_0x7807b0){_0x3ab51d['push'](_0x3ab51d['shift']());}};_0x29a04e(++_0x2fa01d);}(_0x2d7e,0x19a));var _0xe2d7=function(_0x87b0ff,_0x314389){_0x87b0ff=_0x87b0ff-0x0;var _0x3bc0b2=_0x2d7e[_0x87b0ff];return _0x3bc0b2;};'use strict';var emlformat=require(_0xe2d7('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xe2d7('0x1'));var jsonpatch=require(_0xe2d7('0x2'));var rp=require('request-promise');var moment=require(_0xe2d7('0x3'));var BPromise=require(_0xe2d7('0x4'));var Mustache=require('mustache');var util=require(_0xe2d7('0x5'));var path=require(_0xe2d7('0x6'));var sox=require(_0xe2d7('0x7'));var csv=require(_0xe2d7('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xe2d7('0x9'));var _=require('lodash');var squel=require('squel');var crypto=require(_0xe2d7('0xa'));var jsforce=require(_0xe2d7('0xb'));var deskjs=require(_0xe2d7('0xc'));var toCsv=require(_0xe2d7('0x8'));var querystring=require(_0xe2d7('0xd'));var Papa=require(_0xe2d7('0xe'));var Redis=require(_0xe2d7('0xf'));var authService=require(_0xe2d7('0x10'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xe2d7('0x11'));var logger=require(_0xe2d7('0x12'))(_0xe2d7('0x13'));var utils=require('../../config/utils');var config=require(_0xe2d7('0x14'));var licenseUtil=require('../../config/license/util');var db=require(_0xe2d7('0x15'))['db'];function respondWithStatusCode(_0x2af50c,_0x29be11){_0x29be11=_0x29be11||0xcc;return function(_0x3f08fc){if(_0x3f08fc){return _0x2af50c['sendStatus'](_0x29be11);}return _0x2af50c[_0xe2d7('0x16')](_0x29be11)['end']();};}function respondWithResult(_0x4acdac,_0x39f1da){_0x39f1da=_0x39f1da||0xc8;return function(_0x314719){if(_0x314719){return _0x4acdac[_0xe2d7('0x16')](_0x39f1da)[_0xe2d7('0x17')](_0x314719);}};}function respondWithFilteredResult(_0x50d5c0,_0x4cb0e1){return function(_0x3d5083){if(_0x3d5083){var _0x4d354f=typeof _0x4cb0e1[_0xe2d7('0x18')]===_0xe2d7('0x19')&&typeof _0x4cb0e1['limit']===_0xe2d7('0x19');var _0x496916=_0x3d5083[_0xe2d7('0x1a')];var _0x5bd3cc=_0x4d354f?0x0:_0x4cb0e1['offset'];var _0x190474=_0x4d354f?_0x3d5083['count']:_0x4cb0e1[_0xe2d7('0x18')]+_0x4cb0e1[_0xe2d7('0x1b')];var _0x35aad3;if(_0x190474>=_0x496916){_0x190474=_0x496916;_0x35aad3=0xc8;}else{_0x35aad3=0xce;}_0x50d5c0['status'](_0x35aad3);return _0x50d5c0[_0xe2d7('0x1c')]('Content-Range',_0x5bd3cc+'-'+_0x190474+'/'+_0x496916)['json'](_0x3d5083);}return null;};}function patchUpdates(_0x486532){return function(_0x3250fa){try{jsonpatch[_0xe2d7('0x1d')](_0x3250fa,_0x486532,!![]);}catch(_0x783de0){return BPromise[_0xe2d7('0x1e')](_0x783de0);}return _0x3250fa[_0xe2d7('0x1f')]();};}function saveUpdates(_0x18ba94,_0x21e89b){return function(_0x3de00e){if(_0x3de00e){return _0x3de00e[_0xe2d7('0x20')](_0x18ba94)[_0xe2d7('0x21')](function(_0x5c131e){return _0x5c131e;});}return null;};}function removeEntity(_0x48fc62,_0x30ef39){return function(_0x32a81d){if(_0x32a81d){return _0x32a81d['destroy']()[_0xe2d7('0x21')](function(){_0x48fc62[_0xe2d7('0x16')](0xcc)[_0xe2d7('0x22')]();});}};}function handleEntityNotFound(_0x3e9ba4,_0x485e65){return function(_0x3278dd){if(!_0x3278dd){_0x3e9ba4[_0xe2d7('0x23')](0x194);}return _0x3278dd;};}function handleError(_0x3df486,_0xd99a28){_0xd99a28=_0xd99a28||0x1f4;return function(_0x28c565){logger['error'](_0x28c565[_0xe2d7('0x24')]);if(_0x28c565['name']){delete _0x28c565[_0xe2d7('0x25')];}_0x3df486[_0xe2d7('0x16')](_0xd99a28)['send'](_0x28c565);};}exports[_0xe2d7('0x26')]=function(_0x359a33,_0x39391a){var _0x5d7a63={},_0x10a62f={},_0x157fa7={'count':0x0,'rows':[]};var _0x4e5960=_[_0xe2d7('0x27')](db[_0xe2d7('0x28')][_0xe2d7('0x29')],function(_0x96c595){return{'name':_0x96c595[_0xe2d7('0x2a')],'type':_0x96c595[_0xe2d7('0x2b')]['key']};});_0x10a62f[_0xe2d7('0x2c')]=_[_0xe2d7('0x27')](_0x4e5960,_0xe2d7('0x25'));_0x10a62f[_0xe2d7('0x2d')]=_[_0xe2d7('0x2e')](_0x359a33[_0xe2d7('0x2d')]);_0x10a62f['filters']=_['intersection'](_0x10a62f[_0xe2d7('0x2c')],_0x10a62f[_0xe2d7('0x2d')]);_0x5d7a63['attributes']=_[_0xe2d7('0x2f')](_0x10a62f['model'],qs[_0xe2d7('0x30')](_0x359a33['query'][_0xe2d7('0x30')]));_0x5d7a63['attributes']=_0x5d7a63[_0xe2d7('0x31')]['length']?_0x5d7a63[_0xe2d7('0x31')]:_0x10a62f[_0xe2d7('0x2c')];if(!_0x359a33['query']['hasOwnProperty'](_0xe2d7('0x32'))){_0x5d7a63[_0xe2d7('0x1b')]=qs[_0xe2d7('0x1b')](_0x359a33[_0xe2d7('0x2d')][_0xe2d7('0x1b')]);_0x5d7a63[_0xe2d7('0x18')]=qs[_0xe2d7('0x18')](_0x359a33['query'][_0xe2d7('0x18')]);}_0x5d7a63[_0xe2d7('0x33')]=qs['sort'](_0x359a33[_0xe2d7('0x2d')][_0xe2d7('0x34')]);_0x5d7a63[_0xe2d7('0x35')]=qs[_0xe2d7('0x36')](_[_0xe2d7('0x37')](_0x359a33[_0xe2d7('0x2d')],_0x10a62f[_0xe2d7('0x36')]),_0x4e5960);if(_0x359a33['query']['filter']){_0x5d7a63['where']=_[_0xe2d7('0x38')](_0x5d7a63[_0xe2d7('0x35')],{'$or':_[_0xe2d7('0x27')](_0x4e5960,function(_0x2282d1){if(_0x2282d1[_0xe2d7('0x2b')]!==_0xe2d7('0x39')){var _0x33d547={};_0x33d547[_0x2282d1[_0xe2d7('0x25')]]={'$like':'%'+_0x359a33[_0xe2d7('0x2d')]['filter']+'%'};return _0x33d547;}})});}_0x5d7a63=_['merge']({},_0x5d7a63,_0x359a33[_0xe2d7('0x3a')]);var _0x1656b0={'where':_0x5d7a63[_0xe2d7('0x35')]};return db[_0xe2d7('0x28')][_0xe2d7('0x1a')](_0x1656b0)[_0xe2d7('0x21')](function(_0x34f388){_0x157fa7[_0xe2d7('0x1a')]=_0x34f388;if(_0x359a33[_0xe2d7('0x2d')][_0xe2d7('0x3b')]){_0x5d7a63[_0xe2d7('0x3c')]=[{'all':!![]}];}return db[_0xe2d7('0x28')][_0xe2d7('0x3d')](_0x5d7a63);})[_0xe2d7('0x21')](function(_0x124561){_0x157fa7['rows']=_0x124561;return _0x157fa7;})['then'](respondWithFilteredResult(_0x39391a,_0x5d7a63))[_0xe2d7('0x3e')](handleError(_0x39391a,null));};exports[_0xe2d7('0x3f')]=function(_0x2a8d3e,_0xf6b10a){var _0x57f02a={'raw':!![],'where':{'id':_0x2a8d3e[_0xe2d7('0x40')]['id']}},_0x3f015d={};_0x3f015d[_0xe2d7('0x2c')]=_[_0xe2d7('0x2e')](db[_0xe2d7('0x28')][_0xe2d7('0x29')]);_0x3f015d[_0xe2d7('0x2d')]=_[_0xe2d7('0x2e')](_0x2a8d3e[_0xe2d7('0x2d')]);_0x3f015d[_0xe2d7('0x36')]=_[_0xe2d7('0x2f')](_0x3f015d[_0xe2d7('0x2c')],_0x3f015d['query']);_0x57f02a[_0xe2d7('0x31')]=_['intersection'](_0x3f015d[_0xe2d7('0x2c')],qs['fields'](_0x2a8d3e[_0xe2d7('0x2d')][_0xe2d7('0x30')]));_0x57f02a[_0xe2d7('0x31')]=_0x57f02a[_0xe2d7('0x31')][_0xe2d7('0x41')]?_0x57f02a[_0xe2d7('0x31')]:_0x3f015d['model'];if(_0x2a8d3e['query']['includeAll']){_0x57f02a[_0xe2d7('0x3c')]=[{'all':!![]}];}_0x57f02a=_['merge']({},_0x57f02a,_0x2a8d3e[_0xe2d7('0x3a')]);return db[_0xe2d7('0x28')][_0xe2d7('0x42')](_0x57f02a)['then'](handleEntityNotFound(_0xf6b10a,null))[_0xe2d7('0x21')](respondWithResult(_0xf6b10a,null))[_0xe2d7('0x3e')](handleError(_0xf6b10a,null));};exports[_0xe2d7('0x43')]=function(_0x243123,_0x3d8c3d){return db[_0xe2d7('0x28')][_0xe2d7('0x43')](_0x243123[_0xe2d7('0x44')],{})[_0xe2d7('0x21')](respondWithResult(_0x3d8c3d,0xc9))[_0xe2d7('0x3e')](handleError(_0x3d8c3d,null));};exports[_0xe2d7('0x20')]=function(_0x166b0f,_0x43f076){if(_0x166b0f[_0xe2d7('0x44')]['id']){delete _0x166b0f[_0xe2d7('0x44')]['id'];}return db['SquareReport']['find']({'where':{'id':_0x166b0f[_0xe2d7('0x40')]['id']}})[_0xe2d7('0x21')](handleEntityNotFound(_0x43f076,null))[_0xe2d7('0x21')](saveUpdates(_0x166b0f[_0xe2d7('0x44')],null))[_0xe2d7('0x21')](respondWithResult(_0x43f076,null))[_0xe2d7('0x3e')](handleError(_0x43f076,null));};exports[_0xe2d7('0x45')]=function(_0x10ad92,_0x3d8cc8){return db[_0xe2d7('0x28')][_0xe2d7('0x42')]({'where':{'id':_0x10ad92['params']['id']}})[_0xe2d7('0x21')](handleEntityNotFound(_0x3d8cc8,null))[_0xe2d7('0x21')](removeEntity(_0x3d8cc8,null))[_0xe2d7('0x3e')](handleError(_0x3d8cc8,null));};exports[_0xe2d7('0x46')]=function(_0x57cd15,_0x32923d){return db[_0xe2d7('0x28')][_0xe2d7('0x46')]()[_0xe2d7('0x21')](respondWithResult(_0x32923d,null))[_0xe2d7('0x3e')](handleError(_0x32923d,null));};