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 _0xbec6=['../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','json','offset','limit','undefined','count','set','Content-Range','apply','reject','save','then','stack','name','send','index','key','model','map','query','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','where','pick','filter','merge','type','VIRTUAL','options','SquareReport','include','findAll','rows','catch','show','keys','includeAll','find','create','body','update','params','destroy','describe','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','util','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js'];(function(_0x422905,_0x3bce3a){var _0x33dc6c=function(_0x4852c9){while(--_0x4852c9){_0x422905['push'](_0x422905['shift']());}};_0x33dc6c(++_0x3bce3a);}(_0xbec6,0x1b2));var _0x6bec=function(_0x315b61,_0x4bb11e){_0x315b61=_0x315b61-0x0;var _0x3521e8=_0xbec6[_0x315b61];return _0x3521e8;};'use strict';var emlformat=require(_0x6bec('0x0'));var rimraf=require(_0x6bec('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x6bec('0x2'));var rp=require(_0x6bec('0x3'));var moment=require(_0x6bec('0x4'));var BPromise=require(_0x6bec('0x5'));var Mustache=require('mustache');var util=require(_0x6bec('0x6'));var path=require('path');var sox=require(_0x6bec('0x7'));var csv=require(_0x6bec('0x8'));var ejs=require(_0x6bec('0x9'));var fs=require('fs');var fs_extra=require(_0x6bec('0xa'));var _=require(_0x6bec('0xb'));var squel=require(_0x6bec('0xc'));var crypto=require(_0x6bec('0xd'));var jsforce=require(_0x6bec('0xe'));var deskjs=require(_0x6bec('0xf'));var toCsv=require(_0x6bec('0x8'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x6bec('0x10'));var qs=require(_0x6bec('0x11'));var as=require(_0x6bec('0x12'));var hardwareService=require(_0x6bec('0x13'));var logger=require(_0x6bec('0x14'))('api');var utils=require(_0x6bec('0x15'));var config=require(_0x6bec('0x16'));var licenseUtil=require(_0x6bec('0x17'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x4ef9dd,_0x475fe7){_0x475fe7=_0x475fe7||0xcc;return function(_0x26aa9f){if(_0x26aa9f){return _0x4ef9dd[_0x6bec('0x18')](_0x475fe7);}return _0x4ef9dd[_0x6bec('0x19')](_0x475fe7)[_0x6bec('0x1a')]();};}function respondWithResult(_0x399c4d,_0x597af1){_0x597af1=_0x597af1||0xc8;return function(_0x4ac2f8){if(_0x4ac2f8){return _0x399c4d[_0x6bec('0x19')](_0x597af1)[_0x6bec('0x1b')](_0x4ac2f8);}};}function respondWithFilteredResult(_0x5b2746,_0xa983cb){return function(_0x1e4a15){if(_0x1e4a15){var _0x2264f1=typeof _0xa983cb[_0x6bec('0x1c')]==='undefined'&&typeof _0xa983cb[_0x6bec('0x1d')]===_0x6bec('0x1e');var _0x399b04=_0x1e4a15[_0x6bec('0x1f')];var _0x117ecb=_0x2264f1?0x0:_0xa983cb['offset'];var _0x4c47a4=_0x2264f1?_0x1e4a15[_0x6bec('0x1f')]:_0xa983cb['offset']+_0xa983cb[_0x6bec('0x1d')];var _0x373d1f;if(_0x4c47a4>=_0x399b04){_0x4c47a4=_0x399b04;_0x373d1f=0xc8;}else{_0x373d1f=0xce;}_0x5b2746['status'](_0x373d1f);return _0x5b2746[_0x6bec('0x20')](_0x6bec('0x21'),_0x117ecb+'-'+_0x4c47a4+'/'+_0x399b04)[_0x6bec('0x1b')](_0x1e4a15);}return null;};}function patchUpdates(_0x1f17cd){return function(_0x55805b){try{jsonpatch[_0x6bec('0x22')](_0x55805b,_0x1f17cd,!![]);}catch(_0xc1d57d){return BPromise[_0x6bec('0x23')](_0xc1d57d);}return _0x55805b[_0x6bec('0x24')]();};}function saveUpdates(_0x26254d,_0x3c1aa3){return function(_0x5ac6eb){if(_0x5ac6eb){return _0x5ac6eb['update'](_0x26254d)['then'](function(_0x3482f7){return _0x3482f7;});}return null;};}function removeEntity(_0x467f15,_0x5bd519){return function(_0x384851){if(_0x384851){return _0x384851['destroy']()[_0x6bec('0x25')](function(){_0x467f15[_0x6bec('0x19')](0xcc)[_0x6bec('0x1a')]();});}};}function handleEntityNotFound(_0x3faaa6,_0x46e75c){return function(_0x109e43){if(!_0x109e43){_0x3faaa6[_0x6bec('0x18')](0x194);}return _0x109e43;};}function handleError(_0x19d307,_0x3bbcbf){_0x3bbcbf=_0x3bbcbf||0x1f4;return function(_0x1e730b){logger['error'](_0x1e730b[_0x6bec('0x26')]);if(_0x1e730b[_0x6bec('0x27')]){delete _0x1e730b[_0x6bec('0x27')];}_0x19d307[_0x6bec('0x19')](_0x3bbcbf)[_0x6bec('0x28')](_0x1e730b);};}exports[_0x6bec('0x29')]=function(_0x366645,_0x11102d){var _0x50abfb={},_0x36b591={},_0x201bfb={'count':0x0,'rows':[]};var _0x229569=_['map'](db['SquareReport']['rawAttributes'],function(_0xd36169){return{'name':_0xd36169['fieldName'],'type':_0xd36169['type'][_0x6bec('0x2a')]};});_0x36b591[_0x6bec('0x2b')]=_[_0x6bec('0x2c')](_0x229569,'name');_0x36b591['query']=_['keys'](_0x366645[_0x6bec('0x2d')]);_0x36b591[_0x6bec('0x2e')]=_['intersection'](_0x36b591['model'],_0x36b591[_0x6bec('0x2d')]);_0x50abfb[_0x6bec('0x2f')]=_[_0x6bec('0x30')](_0x36b591[_0x6bec('0x2b')],qs[_0x6bec('0x31')](_0x366645[_0x6bec('0x2d')][_0x6bec('0x31')]));_0x50abfb[_0x6bec('0x2f')]=_0x50abfb[_0x6bec('0x2f')][_0x6bec('0x32')]?_0x50abfb[_0x6bec('0x2f')]:_0x36b591['model'];if(!_0x366645['query'][_0x6bec('0x33')](_0x6bec('0x34'))){_0x50abfb['limit']=qs['limit'](_0x366645[_0x6bec('0x2d')][_0x6bec('0x1d')]);_0x50abfb[_0x6bec('0x1c')]=qs[_0x6bec('0x1c')](_0x366645[_0x6bec('0x2d')][_0x6bec('0x1c')]);}_0x50abfb['order']=qs['sort'](_0x366645['query']['sort']);_0x50abfb[_0x6bec('0x35')]=qs[_0x6bec('0x2e')](_[_0x6bec('0x36')](_0x366645[_0x6bec('0x2d')],_0x36b591[_0x6bec('0x2e')]),_0x229569);if(_0x366645[_0x6bec('0x2d')][_0x6bec('0x37')]){_0x50abfb['where']=_[_0x6bec('0x38')](_0x50abfb[_0x6bec('0x35')],{'$or':_[_0x6bec('0x2c')](_0x229569,function(_0x1f9e4e){if(_0x1f9e4e[_0x6bec('0x39')]!==_0x6bec('0x3a')){var _0x10eac9={};_0x10eac9[_0x1f9e4e[_0x6bec('0x27')]]={'$like':'%'+_0x366645['query']['filter']+'%'};return _0x10eac9;}})});}_0x50abfb=_[_0x6bec('0x38')]({},_0x50abfb,_0x366645[_0x6bec('0x3b')]);var _0x423b26={'where':_0x50abfb['where']};return db[_0x6bec('0x3c')][_0x6bec('0x1f')](_0x423b26)[_0x6bec('0x25')](function(_0x592ff4){_0x201bfb[_0x6bec('0x1f')]=_0x592ff4;if(_0x366645[_0x6bec('0x2d')]['includeAll']){_0x50abfb[_0x6bec('0x3d')]=[{'all':!![]}];}return db['SquareReport'][_0x6bec('0x3e')](_0x50abfb);})[_0x6bec('0x25')](function(_0x44a8f3){_0x201bfb[_0x6bec('0x3f')]=_0x44a8f3;return _0x201bfb;})[_0x6bec('0x25')](respondWithFilteredResult(_0x11102d,_0x50abfb))[_0x6bec('0x40')](handleError(_0x11102d,null));};exports[_0x6bec('0x41')]=function(_0x42a650,_0x2de327){var _0x52c80c={'raw':!![],'where':{'id':_0x42a650['params']['id']}},_0x31dfcf={};_0x31dfcf['model']=_[_0x6bec('0x42')](db[_0x6bec('0x3c')]['rawAttributes']);_0x31dfcf[_0x6bec('0x2d')]=_['keys'](_0x42a650[_0x6bec('0x2d')]);_0x31dfcf[_0x6bec('0x2e')]=_[_0x6bec('0x30')](_0x31dfcf[_0x6bec('0x2b')],_0x31dfcf[_0x6bec('0x2d')]);_0x52c80c[_0x6bec('0x2f')]=_['intersection'](_0x31dfcf['model'],qs[_0x6bec('0x31')](_0x42a650[_0x6bec('0x2d')][_0x6bec('0x31')]));_0x52c80c[_0x6bec('0x2f')]=_0x52c80c[_0x6bec('0x2f')][_0x6bec('0x32')]?_0x52c80c[_0x6bec('0x2f')]:_0x31dfcf[_0x6bec('0x2b')];if(_0x42a650[_0x6bec('0x2d')][_0x6bec('0x43')]){_0x52c80c['include']=[{'all':!![]}];}_0x52c80c=_[_0x6bec('0x38')]({},_0x52c80c,_0x42a650[_0x6bec('0x3b')]);return db[_0x6bec('0x3c')][_0x6bec('0x44')](_0x52c80c)[_0x6bec('0x25')](handleEntityNotFound(_0x2de327,null))[_0x6bec('0x25')](respondWithResult(_0x2de327,null))[_0x6bec('0x40')](handleError(_0x2de327,null));};exports[_0x6bec('0x45')]=function(_0x540576,_0x11744d){return db[_0x6bec('0x3c')]['create'](_0x540576[_0x6bec('0x46')],{})[_0x6bec('0x25')](respondWithResult(_0x11744d,0xc9))[_0x6bec('0x40')](handleError(_0x11744d,null));};exports[_0x6bec('0x47')]=function(_0x2475e8,_0x527c8f){if(_0x2475e8[_0x6bec('0x46')]['id']){delete _0x2475e8[_0x6bec('0x46')]['id'];}return db[_0x6bec('0x3c')][_0x6bec('0x44')]({'where':{'id':_0x2475e8[_0x6bec('0x48')]['id']}})[_0x6bec('0x25')](handleEntityNotFound(_0x527c8f,null))['then'](saveUpdates(_0x2475e8[_0x6bec('0x46')],null))['then'](respondWithResult(_0x527c8f,null))[_0x6bec('0x40')](handleError(_0x527c8f,null));};exports[_0x6bec('0x49')]=function(_0x349930,_0x2b5d6c){return db['SquareReport']['find']({'where':{'id':_0x349930[_0x6bec('0x48')]['id']}})[_0x6bec('0x25')](handleEntityNotFound(_0x2b5d6c,null))[_0x6bec('0x25')](removeEntity(_0x2b5d6c,null))[_0x6bec('0x40')](handleError(_0x2b5d6c,null));};exports[_0x6bec('0x4a')]=function(_0x5e38bd,_0x217aaf){return db[_0x6bec('0x3c')][_0x6bec('0x4a')]()[_0x6bec('0x25')](respondWithResult(_0x217aaf,null))['catch'](handleError(_0x217aaf,null));};