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 _0xe398=['set','Content-Range','apply','reject','save','then','destroy','error','stack','name','send','index','map','SquareReport','fieldName','type','key','model','query','keys','filters','attributes','fields','hasOwnProperty','nolimit','order','sort','where','filter','merge','options','findAll','rows','catch','params','intersection','length','includeAll','include','find','create','body','update','describe','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','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','../../mysqldb','sendStatus','json','offset','undefined','limit','count','status'];(function(_0x4af6a0,_0x522121){var _0x4c2b23=function(_0x2f5955){while(--_0x2f5955){_0x4af6a0['push'](_0x4af6a0['shift']());}};_0x4c2b23(++_0x522121);}(_0xe398,0x7e));var _0x8e39=function(_0x2acd51,_0x115bf9){_0x2acd51=_0x2acd51-0x0;var _0x7a3983=_0xe398[_0x2acd51];return _0x7a3983;};'use strict';var emlformat=require(_0x8e39('0x0'));var rimraf=require(_0x8e39('0x1'));var zipdir=require(_0x8e39('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x8e39('0x3'));var moment=require(_0x8e39('0x4'));var BPromise=require(_0x8e39('0x5'));var Mustache=require(_0x8e39('0x6'));var util=require(_0x8e39('0x7'));var path=require(_0x8e39('0x8'));var sox=require(_0x8e39('0x9'));var csv=require('to-csv');var ejs=require(_0x8e39('0xa'));var fs=require('fs');var fs_extra=require(_0x8e39('0xb'));var _=require(_0x8e39('0xc'));var squel=require(_0x8e39('0xd'));var crypto=require(_0x8e39('0xe'));var jsforce=require(_0x8e39('0xf'));var deskjs=require(_0x8e39('0x10'));var toCsv=require(_0x8e39('0x11'));var querystring=require(_0x8e39('0x12'));var Papa=require(_0x8e39('0x13'));var Redis=require(_0x8e39('0x14'));var authService=require(_0x8e39('0x15'));var qs=require(_0x8e39('0x16'));var as=require(_0x8e39('0x17'));var hardwareService=require(_0x8e39('0x18'));var logger=require(_0x8e39('0x19'))(_0x8e39('0x1a'));var utils=require(_0x8e39('0x1b'));var config=require(_0x8e39('0x1c'));var licenseUtil=require(_0x8e39('0x1d'));var db=require(_0x8e39('0x1e'))['db'];function respondWithStatusCode(_0x33c4f3,_0x2b19df){_0x2b19df=_0x2b19df||0xcc;return function(_0x39e107){if(_0x39e107){return _0x33c4f3[_0x8e39('0x1f')](_0x2b19df);}return _0x33c4f3['status'](_0x2b19df)['end']();};}function respondWithResult(_0x5cf5bc,_0x5796b5){_0x5796b5=_0x5796b5||0xc8;return function(_0x5a7a02){if(_0x5a7a02){return _0x5cf5bc['status'](_0x5796b5)[_0x8e39('0x20')](_0x5a7a02);}};}function respondWithFilteredResult(_0x56d92e,_0x147711){return function(_0x48bc7a){if(_0x48bc7a){var _0x61d295=typeof _0x147711[_0x8e39('0x21')]===_0x8e39('0x22')&&typeof _0x147711[_0x8e39('0x23')]==='undefined';var _0x101afc=_0x48bc7a[_0x8e39('0x24')];var _0x1d43b8=_0x61d295?0x0:_0x147711['offset'];var _0x14c9a6=_0x61d295?_0x48bc7a[_0x8e39('0x24')]:_0x147711['offset']+_0x147711[_0x8e39('0x23')];var _0xb2488b;if(_0x14c9a6>=_0x101afc){_0x14c9a6=_0x101afc;_0xb2488b=0xc8;}else{_0xb2488b=0xce;}_0x56d92e[_0x8e39('0x25')](_0xb2488b);return _0x56d92e[_0x8e39('0x26')](_0x8e39('0x27'),_0x1d43b8+'-'+_0x14c9a6+'/'+_0x101afc)['json'](_0x48bc7a);}return null;};}function patchUpdates(_0x4ff19f){return function(_0x1497fc){try{jsonpatch[_0x8e39('0x28')](_0x1497fc,_0x4ff19f,!![]);}catch(_0x4cca41){return BPromise[_0x8e39('0x29')](_0x4cca41);}return _0x1497fc[_0x8e39('0x2a')]();};}function saveUpdates(_0x19045a,_0x5a60c5){return function(_0x4f9a51){if(_0x4f9a51){return _0x4f9a51['update'](_0x19045a)[_0x8e39('0x2b')](function(_0x399b69){return _0x399b69;});}return null;};}function removeEntity(_0x25cf45,_0x2b078d){return function(_0x135603){if(_0x135603){return _0x135603[_0x8e39('0x2c')]()[_0x8e39('0x2b')](function(){_0x25cf45['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x3c2123,_0x530465){return function(_0x3ddb19){if(!_0x3ddb19){_0x3c2123[_0x8e39('0x1f')](0x194);}return _0x3ddb19;};}function handleError(_0x67b8d9,_0x2d1ff1){_0x2d1ff1=_0x2d1ff1||0x1f4;return function(_0x19971a){logger[_0x8e39('0x2d')](_0x19971a[_0x8e39('0x2e')]);if(_0x19971a[_0x8e39('0x2f')]){delete _0x19971a['name'];}_0x67b8d9[_0x8e39('0x25')](_0x2d1ff1)[_0x8e39('0x30')](_0x19971a);};}exports[_0x8e39('0x31')]=function(_0x9ab884,_0x52edb4){var _0xeb6f22={},_0x3c3d37={},_0x307c02={'count':0x0,'rows':[]};var _0x25b2e4=_[_0x8e39('0x32')](db[_0x8e39('0x33')]['rawAttributes'],function(_0x5cf701){return{'name':_0x5cf701[_0x8e39('0x34')],'type':_0x5cf701[_0x8e39('0x35')][_0x8e39('0x36')]};});_0x3c3d37[_0x8e39('0x37')]=_[_0x8e39('0x32')](_0x25b2e4,_0x8e39('0x2f'));_0x3c3d37[_0x8e39('0x38')]=_[_0x8e39('0x39')](_0x9ab884['query']);_0x3c3d37[_0x8e39('0x3a')]=_['intersection'](_0x3c3d37[_0x8e39('0x37')],_0x3c3d37[_0x8e39('0x38')]);_0xeb6f22[_0x8e39('0x3b')]=_['intersection'](_0x3c3d37[_0x8e39('0x37')],qs[_0x8e39('0x3c')](_0x9ab884[_0x8e39('0x38')]['fields']));_0xeb6f22[_0x8e39('0x3b')]=_0xeb6f22[_0x8e39('0x3b')]['length']?_0xeb6f22[_0x8e39('0x3b')]:_0x3c3d37[_0x8e39('0x37')];if(!_0x9ab884[_0x8e39('0x38')][_0x8e39('0x3d')](_0x8e39('0x3e'))){_0xeb6f22['limit']=qs[_0x8e39('0x23')](_0x9ab884[_0x8e39('0x38')]['limit']);_0xeb6f22[_0x8e39('0x21')]=qs[_0x8e39('0x21')](_0x9ab884['query'][_0x8e39('0x21')]);}_0xeb6f22[_0x8e39('0x3f')]=qs[_0x8e39('0x40')](_0x9ab884[_0x8e39('0x38')][_0x8e39('0x40')]);_0xeb6f22[_0x8e39('0x41')]=qs[_0x8e39('0x3a')](_['pick'](_0x9ab884['query'],_0x3c3d37[_0x8e39('0x3a')]),_0x25b2e4);if(_0x9ab884[_0x8e39('0x38')][_0x8e39('0x42')]){_0xeb6f22['where']=_[_0x8e39('0x43')](_0xeb6f22[_0x8e39('0x41')],{'$or':_[_0x8e39('0x32')](_0x25b2e4,function(_0x5eea4a){if(_0x5eea4a[_0x8e39('0x35')]!=='VIRTUAL'){var _0x31c177={};_0x31c177[_0x5eea4a[_0x8e39('0x2f')]]={'$like':'%'+_0x9ab884['query'][_0x8e39('0x42')]+'%'};return _0x31c177;}})});}_0xeb6f22=_[_0x8e39('0x43')]({},_0xeb6f22,_0x9ab884[_0x8e39('0x44')]);var _0x35df0b={'where':_0xeb6f22[_0x8e39('0x41')]};return db['SquareReport'][_0x8e39('0x24')](_0x35df0b)[_0x8e39('0x2b')](function(_0x4e86e9){_0x307c02['count']=_0x4e86e9;if(_0x9ab884[_0x8e39('0x38')]['includeAll']){_0xeb6f22['include']=[{'all':!![]}];}return db[_0x8e39('0x33')][_0x8e39('0x45')](_0xeb6f22);})[_0x8e39('0x2b')](function(_0x313772){_0x307c02[_0x8e39('0x46')]=_0x313772;return _0x307c02;})[_0x8e39('0x2b')](respondWithFilteredResult(_0x52edb4,_0xeb6f22))[_0x8e39('0x47')](handleError(_0x52edb4,null));};exports['show']=function(_0x1094e3,_0x19031f){var _0x437dce={'raw':!![],'where':{'id':_0x1094e3[_0x8e39('0x48')]['id']}},_0xff691={};_0xff691[_0x8e39('0x37')]=_[_0x8e39('0x39')](db[_0x8e39('0x33')]['rawAttributes']);_0xff691[_0x8e39('0x38')]=_[_0x8e39('0x39')](_0x1094e3[_0x8e39('0x38')]);_0xff691[_0x8e39('0x3a')]=_[_0x8e39('0x49')](_0xff691[_0x8e39('0x37')],_0xff691[_0x8e39('0x38')]);_0x437dce[_0x8e39('0x3b')]=_[_0x8e39('0x49')](_0xff691[_0x8e39('0x37')],qs[_0x8e39('0x3c')](_0x1094e3[_0x8e39('0x38')][_0x8e39('0x3c')]));_0x437dce['attributes']=_0x437dce[_0x8e39('0x3b')][_0x8e39('0x4a')]?_0x437dce['attributes']:_0xff691['model'];if(_0x1094e3[_0x8e39('0x38')][_0x8e39('0x4b')]){_0x437dce[_0x8e39('0x4c')]=[{'all':!![]}];}_0x437dce=_[_0x8e39('0x43')]({},_0x437dce,_0x1094e3[_0x8e39('0x44')]);return db[_0x8e39('0x33')][_0x8e39('0x4d')](_0x437dce)[_0x8e39('0x2b')](handleEntityNotFound(_0x19031f,null))['then'](respondWithResult(_0x19031f,null))[_0x8e39('0x47')](handleError(_0x19031f,null));};exports[_0x8e39('0x4e')]=function(_0x4eeecd,_0x4aa1f0){return db[_0x8e39('0x33')][_0x8e39('0x4e')](_0x4eeecd[_0x8e39('0x4f')],{})['then'](respondWithResult(_0x4aa1f0,0xc9))['catch'](handleError(_0x4aa1f0,null));};exports[_0x8e39('0x50')]=function(_0x2b58b5,_0xeaf5c3){if(_0x2b58b5['body']['id']){delete _0x2b58b5[_0x8e39('0x4f')]['id'];}return db[_0x8e39('0x33')][_0x8e39('0x4d')]({'where':{'id':_0x2b58b5[_0x8e39('0x48')]['id']}})[_0x8e39('0x2b')](handleEntityNotFound(_0xeaf5c3,null))['then'](saveUpdates(_0x2b58b5['body'],null))[_0x8e39('0x2b')](respondWithResult(_0xeaf5c3,null))[_0x8e39('0x47')](handleError(_0xeaf5c3,null));};exports[_0x8e39('0x2c')]=function(_0x5b5f71,_0x278814){return db[_0x8e39('0x33')][_0x8e39('0x4d')]({'where':{'id':_0x5b5f71[_0x8e39('0x48')]['id']}})[_0x8e39('0x2b')](handleEntityNotFound(_0x278814,null))[_0x8e39('0x2b')](removeEntity(_0x278814,null))[_0x8e39('0x47')](handleError(_0x278814,null));};exports[_0x8e39('0x51')]=function(_0x3a37c0,_0x3efdd4){return db[_0x8e39('0x33')][_0x8e39('0x51')]()[_0x8e39('0x2b')](respondWithResult(_0x3efdd4,null))[_0x8e39('0x47')](handleError(_0x3efdd4,null));};