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 _0x235b=['Content-Range','apply','destroy','then','end','error','stack','name','send','map','SquareReport','fieldName','key','model','query','keys','filters','intersection','attributes','fields','length','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','show','rawAttributes','find','catch','create','body','update','params','describe','eml-format','zip-dir','moment','bluebird','mustache','util','path','sox','ejs','fs-extra','lodash','squel','crypto','jsforce','to-csv','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','limit','undefined','count','set'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0x235b,0x1a7));var _0xb235=function(_0xf1f9d1,_0x42caf7){_0xf1f9d1=_0xf1f9d1-0x0;var _0xd555d=_0x235b[_0xf1f9d1];return _0xd555d;};'use strict';var emlformat=require(_0xb235('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xb235('0x1'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0xb235('0x2'));var BPromise=require(_0xb235('0x3'));var Mustache=require(_0xb235('0x4'));var util=require(_0xb235('0x5'));var path=require(_0xb235('0x6'));var sox=require(_0xb235('0x7'));var csv=require('to-csv');var ejs=require(_0xb235('0x8'));var fs=require('fs');var fs_extra=require(_0xb235('0x9'));var _=require(_0xb235('0xa'));var squel=require(_0xb235('0xb'));var crypto=require(_0xb235('0xc'));var jsforce=require(_0xb235('0xd'));var deskjs=require('desk.js');var toCsv=require(_0xb235('0xe'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0xb235('0xf'));var authService=require(_0xb235('0x10'));var qs=require(_0xb235('0x11'));var as=require(_0xb235('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xb235('0x13'))(_0xb235('0x14'));var utils=require(_0xb235('0x15'));var config=require(_0xb235('0x16'));var licenseUtil=require(_0xb235('0x17'));var db=require(_0xb235('0x18'))['db'];function respondWithStatusCode(_0xf9adff,_0x4e20eb){_0x4e20eb=_0x4e20eb||0xcc;return function(_0x3f597f){if(_0x3f597f){return _0xf9adff[_0xb235('0x19')](_0x4e20eb);}return _0xf9adff[_0xb235('0x1a')](_0x4e20eb)['end']();};}function respondWithResult(_0x1f5e9c,_0x3c994b){_0x3c994b=_0x3c994b||0xc8;return function(_0x175c5b){if(_0x175c5b){return _0x1f5e9c[_0xb235('0x1a')](_0x3c994b)[_0xb235('0x1b')](_0x175c5b);}};}function respondWithFilteredResult(_0x509bc0,_0x19deee){return function(_0x20d7b4){if(_0x20d7b4){var _0x493f0a=typeof _0x19deee[_0xb235('0x1c')]==='undefined'&&typeof _0x19deee[_0xb235('0x1d')]===_0xb235('0x1e');var _0x54c5f1=_0x20d7b4[_0xb235('0x1f')];var _0x18c456=_0x493f0a?0x0:_0x19deee[_0xb235('0x1c')];var _0x2f74a7=_0x493f0a?_0x20d7b4[_0xb235('0x1f')]:_0x19deee[_0xb235('0x1c')]+_0x19deee[_0xb235('0x1d')];var _0x4c5e99;if(_0x2f74a7>=_0x54c5f1){_0x2f74a7=_0x54c5f1;_0x4c5e99=0xc8;}else{_0x4c5e99=0xce;}_0x509bc0[_0xb235('0x1a')](_0x4c5e99);return _0x509bc0[_0xb235('0x20')](_0xb235('0x21'),_0x18c456+'-'+_0x2f74a7+'/'+_0x54c5f1)[_0xb235('0x1b')](_0x20d7b4);}return null;};}function patchUpdates(_0xce337f){return function(_0x520e99){try{jsonpatch[_0xb235('0x22')](_0x520e99,_0xce337f,!![]);}catch(_0x21e4d6){return BPromise['reject'](_0x21e4d6);}return _0x520e99['save']();};}function saveUpdates(_0x5e48eb,_0x44c958){return function(_0x247998){if(_0x247998){return _0x247998['update'](_0x5e48eb)['then'](function(_0x4429b3){return _0x4429b3;});}return null;};}function removeEntity(_0x4c19e3,_0x1b8fdc){return function(_0x5ebbdb){if(_0x5ebbdb){return _0x5ebbdb[_0xb235('0x23')]()[_0xb235('0x24')](function(){_0x4c19e3[_0xb235('0x1a')](0xcc)[_0xb235('0x25')]();});}};}function handleEntityNotFound(_0x23222d,_0x1c5369){return function(_0x39c9b2){if(!_0x39c9b2){_0x23222d[_0xb235('0x19')](0x194);}return _0x39c9b2;};}function handleError(_0x363ec8,_0x42742f){_0x42742f=_0x42742f||0x1f4;return function(_0x1ed32d){logger[_0xb235('0x26')](_0x1ed32d[_0xb235('0x27')]);if(_0x1ed32d[_0xb235('0x28')]){delete _0x1ed32d[_0xb235('0x28')];}_0x363ec8[_0xb235('0x1a')](_0x42742f)[_0xb235('0x29')](_0x1ed32d);};}exports['index']=function(_0x59dba2,_0x557512){var _0x123f45={},_0x1d25fd={},_0x1658da={'count':0x0,'rows':[]};var _0x41f14d=_[_0xb235('0x2a')](db[_0xb235('0x2b')]['rawAttributes'],function(_0x503927){return{'name':_0x503927[_0xb235('0x2c')],'type':_0x503927['type'][_0xb235('0x2d')]};});_0x1d25fd[_0xb235('0x2e')]=_[_0xb235('0x2a')](_0x41f14d,'name');_0x1d25fd[_0xb235('0x2f')]=_[_0xb235('0x30')](_0x59dba2[_0xb235('0x2f')]);_0x1d25fd[_0xb235('0x31')]=_[_0xb235('0x32')](_0x1d25fd[_0xb235('0x2e')],_0x1d25fd[_0xb235('0x2f')]);_0x123f45[_0xb235('0x33')]=_['intersection'](_0x1d25fd[_0xb235('0x2e')],qs[_0xb235('0x34')](_0x59dba2['query'][_0xb235('0x34')]));_0x123f45[_0xb235('0x33')]=_0x123f45['attributes'][_0xb235('0x35')]?_0x123f45['attributes']:_0x1d25fd[_0xb235('0x2e')];if(!_0x59dba2[_0xb235('0x2f')]['hasOwnProperty'](_0xb235('0x36'))){_0x123f45[_0xb235('0x1d')]=qs[_0xb235('0x1d')](_0x59dba2[_0xb235('0x2f')][_0xb235('0x1d')]);_0x123f45['offset']=qs['offset'](_0x59dba2[_0xb235('0x2f')][_0xb235('0x1c')]);}_0x123f45[_0xb235('0x37')]=qs['sort'](_0x59dba2[_0xb235('0x2f')][_0xb235('0x38')]);_0x123f45[_0xb235('0x39')]=qs['filters'](_[_0xb235('0x3a')](_0x59dba2['query'],_0x1d25fd[_0xb235('0x31')]),_0x41f14d);if(_0x59dba2[_0xb235('0x2f')][_0xb235('0x3b')]){_0x123f45[_0xb235('0x39')]=_[_0xb235('0x3c')](_0x123f45[_0xb235('0x39')],{'$or':_[_0xb235('0x2a')](_0x41f14d,function(_0x52ac1){if(_0x52ac1['type']!==_0xb235('0x3d')){var _0x39dd3e={};_0x39dd3e[_0x52ac1['name']]={'$like':'%'+_0x59dba2[_0xb235('0x2f')][_0xb235('0x3b')]+'%'};return _0x39dd3e;}})});}_0x123f45=_[_0xb235('0x3c')]({},_0x123f45,_0x59dba2[_0xb235('0x3e')]);var _0x2172e5={'where':_0x123f45[_0xb235('0x39')]};return db[_0xb235('0x2b')][_0xb235('0x1f')](_0x2172e5)['then'](function(_0x2d9942){_0x1658da['count']=_0x2d9942;if(_0x59dba2[_0xb235('0x2f')][_0xb235('0x3f')]){_0x123f45[_0xb235('0x40')]=[{'all':!![]}];}return db[_0xb235('0x2b')][_0xb235('0x41')](_0x123f45);})[_0xb235('0x24')](function(_0x542703){_0x1658da[_0xb235('0x42')]=_0x542703;return _0x1658da;})[_0xb235('0x24')](respondWithFilteredResult(_0x557512,_0x123f45))['catch'](handleError(_0x557512,null));};exports[_0xb235('0x43')]=function(_0x14dff9,_0x163f08){var _0x57ba0c={'raw':!![],'where':{'id':_0x14dff9['params']['id']}},_0x522478={};_0x522478[_0xb235('0x2e')]=_[_0xb235('0x30')](db['SquareReport'][_0xb235('0x44')]);_0x522478[_0xb235('0x2f')]=_[_0xb235('0x30')](_0x14dff9[_0xb235('0x2f')]);_0x522478[_0xb235('0x31')]=_['intersection'](_0x522478['model'],_0x522478[_0xb235('0x2f')]);_0x57ba0c[_0xb235('0x33')]=_[_0xb235('0x32')](_0x522478[_0xb235('0x2e')],qs['fields'](_0x14dff9[_0xb235('0x2f')][_0xb235('0x34')]));_0x57ba0c[_0xb235('0x33')]=_0x57ba0c[_0xb235('0x33')][_0xb235('0x35')]?_0x57ba0c[_0xb235('0x33')]:_0x522478[_0xb235('0x2e')];if(_0x14dff9[_0xb235('0x2f')]['includeAll']){_0x57ba0c[_0xb235('0x40')]=[{'all':!![]}];}_0x57ba0c=_[_0xb235('0x3c')]({},_0x57ba0c,_0x14dff9[_0xb235('0x3e')]);return db[_0xb235('0x2b')][_0xb235('0x45')](_0x57ba0c)[_0xb235('0x24')](handleEntityNotFound(_0x163f08,null))[_0xb235('0x24')](respondWithResult(_0x163f08,null))[_0xb235('0x46')](handleError(_0x163f08,null));};exports[_0xb235('0x47')]=function(_0x3ce573,_0x2f66c0){return db[_0xb235('0x2b')][_0xb235('0x47')](_0x3ce573[_0xb235('0x48')],{})[_0xb235('0x24')](respondWithResult(_0x2f66c0,0xc9))['catch'](handleError(_0x2f66c0,null));};exports[_0xb235('0x49')]=function(_0x35fc62,_0x671e7d){if(_0x35fc62[_0xb235('0x48')]['id']){delete _0x35fc62[_0xb235('0x48')]['id'];}return db['SquareReport'][_0xb235('0x45')]({'where':{'id':_0x35fc62['params']['id']}})[_0xb235('0x24')](handleEntityNotFound(_0x671e7d,null))[_0xb235('0x24')](saveUpdates(_0x35fc62['body'],null))['then'](respondWithResult(_0x671e7d,null))[_0xb235('0x46')](handleError(_0x671e7d,null));};exports[_0xb235('0x23')]=function(_0x1b4031,_0x5805ff){return db[_0xb235('0x2b')][_0xb235('0x45')]({'where':{'id':_0x1b4031[_0xb235('0x4a')]['id']}})['then'](handleEntityNotFound(_0x5805ff,null))[_0xb235('0x24')](removeEntity(_0x5805ff,null))[_0xb235('0x46')](handleError(_0x5805ff,null));};exports[_0xb235('0x4b')]=function(_0xfcde1b,_0x498e87){return db['SquareReport'][_0xb235('0x4b')]()[_0xb235('0x24')](respondWithResult(_0x498e87,null))['catch'](handleError(_0x498e87,null));};