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 _0x1883=['length','hasOwnProperty','order','sort','where','pick','filter','merge','type','options','count','includeAll','include','rows','catch','show','find','create','body','params','describe','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','desk.js','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../mysqldb','sendStatus','status','offset','limit','set','Content-Range','json','apply','update','destroy','then','end','error','stack','name','send','map','SquareReport','rawAttributes','fieldName','key','query','keys','filters','intersection','model','attributes','fields'];(function(_0x36ee91,_0x255724){var _0x44f22d=function(_0xe3a2c8){while(--_0xe3a2c8){_0x36ee91['push'](_0x36ee91['shift']());}};_0x44f22d(++_0x255724);}(_0x1883,0xab));var _0x3188=function(_0xbb9b40,_0x51b63a){_0xbb9b40=_0xbb9b40-0x0;var _0x4cd1b3=_0x1883[_0xbb9b40];return _0x4cd1b3;};'use strict';var pdf=require(_0x3188('0x0'));var emlformat=require(_0x3188('0x1'));var rimraf=require(_0x3188('0x2'));var zipdir=require(_0x3188('0x3'));var jsonpatch=require(_0x3188('0x4'));var rp=require(_0x3188('0x5'));var moment=require(_0x3188('0x6'));var BPromise=require(_0x3188('0x7'));var Mustache=require(_0x3188('0x8'));var util=require(_0x3188('0x9'));var path=require(_0x3188('0xa'));var sox=require(_0x3188('0xb'));var csv=require(_0x3188('0xc'));var ejs=require(_0x3188('0xd'));var fs=require('fs');var _=require(_0x3188('0xe'));var squel=require(_0x3188('0xf'));var crypto=require(_0x3188('0x10'));var jsforce=require('jsforce');var deskjs=require(_0x3188('0x11'));var toCsv=require(_0x3188('0xc'));var querystring=require('querystring');var Papa=require(_0x3188('0x12'));var Redis=require('ioredis');var authService=require(_0x3188('0x13'));var qs=require(_0x3188('0x14'));var as=require(_0x3188('0x15'));var hardwareService=require(_0x3188('0x16'));var logger=require('../../config/logger')(_0x3188('0x17'));var utils=require(_0x3188('0x18'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0x3188('0x19'))['db'];function respondWithStatusCode(_0x45e94e,_0x20fef6){_0x20fef6=_0x20fef6||0xcc;return function(_0x3ae228){if(_0x3ae228){return _0x45e94e[_0x3188('0x1a')](_0x20fef6);}return _0x45e94e[_0x3188('0x1b')](_0x20fef6)['end']();};}function respondWithResult(_0x276d69,_0x5e0044){_0x5e0044=_0x5e0044||0xc8;return function(_0x4a2f36){if(_0x4a2f36){return _0x276d69[_0x3188('0x1b')](_0x5e0044)['json'](_0x4a2f36);}};}function respondWithFilteredResult(_0x54a87f,_0x32c239){return function(_0x1beead){if(_0x1beead){var _0xa2269=_0x1beead['count'],_0x195d8e=_0x32c239[_0x3188('0x1c')],_0x145293=_0x32c239[_0x3188('0x1c')]+_0x32c239[_0x3188('0x1d')],_0x259321;if(_0x145293>=_0xa2269){_0x145293=_0xa2269;_0x259321=0xc8;}else{_0x259321=0xce;}_0x54a87f[_0x3188('0x1b')](_0x259321);return _0x54a87f[_0x3188('0x1e')](_0x3188('0x1f'),_0x195d8e+'-'+_0x145293+'/'+_0xa2269)[_0x3188('0x20')](_0x1beead);}return null;};}function patchUpdates(_0x4602c6){return function(_0x5bcbba){try{jsonpatch[_0x3188('0x21')](_0x5bcbba,_0x4602c6,!![]);}catch(_0x36050a){return BPromise['reject'](_0x36050a);}return _0x5bcbba['save']();};}function saveUpdates(_0x5d8d62,_0x46a318){return function(_0x8b207){if(_0x8b207){return _0x8b207[_0x3188('0x22')](_0x5d8d62)['then'](function(_0x48673c){return _0x48673c;});}return null;};}function removeEntity(_0x266260,_0x461286){return function(_0x375077){if(_0x375077){return _0x375077[_0x3188('0x23')]()[_0x3188('0x24')](function(){_0x266260['status'](0xcc)[_0x3188('0x25')]();});}};}function handleEntityNotFound(_0x33f882,_0x5a2e67){return function(_0xcbaec9){if(!_0xcbaec9){_0x33f882['sendStatus'](0x194);}return _0xcbaec9;};}function handleError(_0x5c69be,_0x45ae2f){_0x45ae2f=_0x45ae2f||0x1f4;return function(_0x129bd7){logger[_0x3188('0x26')](_0x129bd7[_0x3188('0x27')]);if(_0x129bd7[_0x3188('0x28')]){delete _0x129bd7[_0x3188('0x28')];}_0x5c69be[_0x3188('0x1b')](_0x45ae2f)[_0x3188('0x29')](_0x129bd7);};}exports['index']=function(_0x2cc5d9,_0x2d000a){var _0x52bb13={},_0xd3ee40={},_0x14299b={'count':0x0,'rows':[]};var _0x43399d=_[_0x3188('0x2a')](db[_0x3188('0x2b')][_0x3188('0x2c')],function(_0x8f810f){return{'name':_0x8f810f[_0x3188('0x2d')],'type':_0x8f810f['type'][_0x3188('0x2e')]};});_0xd3ee40['model']=_[_0x3188('0x2a')](_0x43399d,'name');_0xd3ee40[_0x3188('0x2f')]=_[_0x3188('0x30')](_0x2cc5d9[_0x3188('0x2f')]);_0xd3ee40[_0x3188('0x31')]=_[_0x3188('0x32')](_0xd3ee40[_0x3188('0x33')],_0xd3ee40[_0x3188('0x2f')]);_0x52bb13[_0x3188('0x34')]=_[_0x3188('0x32')](_0xd3ee40[_0x3188('0x33')],qs[_0x3188('0x35')](_0x2cc5d9[_0x3188('0x2f')][_0x3188('0x35')]));_0x52bb13[_0x3188('0x34')]=_0x52bb13[_0x3188('0x34')][_0x3188('0x36')]?_0x52bb13[_0x3188('0x34')]:_0xd3ee40[_0x3188('0x33')];if(!_0x2cc5d9['query'][_0x3188('0x37')]('nolimit')){_0x52bb13[_0x3188('0x1d')]=qs[_0x3188('0x1d')](_0x2cc5d9['query'][_0x3188('0x1d')]);_0x52bb13[_0x3188('0x1c')]=qs[_0x3188('0x1c')](_0x2cc5d9[_0x3188('0x2f')][_0x3188('0x1c')]);}_0x52bb13[_0x3188('0x38')]=qs[_0x3188('0x39')](_0x2cc5d9['query']['sort']);_0x52bb13[_0x3188('0x3a')]=qs[_0x3188('0x31')](_[_0x3188('0x3b')](_0x2cc5d9[_0x3188('0x2f')],_0xd3ee40['filters']),_0x43399d);if(_0x2cc5d9[_0x3188('0x2f')][_0x3188('0x3c')]){_0x52bb13[_0x3188('0x3a')]=_[_0x3188('0x3d')](_0x52bb13['where'],{'$or':_[_0x3188('0x2a')](_0x43399d,function(_0x4a290f){if(_0x4a290f[_0x3188('0x3e')]!=='VIRTUAL'){var _0x2bd31e={};_0x2bd31e[_0x4a290f[_0x3188('0x28')]]={'$like':'%'+_0x2cc5d9[_0x3188('0x2f')][_0x3188('0x3c')]+'%'};return _0x2bd31e;}})});}_0x52bb13=_[_0x3188('0x3d')]({},_0x52bb13,_0x2cc5d9[_0x3188('0x3f')]);var _0x4666b2={'where':_0x52bb13[_0x3188('0x3a')]};return db[_0x3188('0x2b')][_0x3188('0x40')](_0x4666b2)['then'](function(_0x42f2aa){_0x14299b[_0x3188('0x40')]=_0x42f2aa;if(_0x2cc5d9[_0x3188('0x2f')][_0x3188('0x41')]){_0x52bb13[_0x3188('0x42')]=[{'all':!![]}];}return db[_0x3188('0x2b')]['findAll'](_0x52bb13);})[_0x3188('0x24')](function(_0x4aca31){_0x14299b[_0x3188('0x43')]=_0x4aca31;return _0x14299b;})[_0x3188('0x24')](respondWithFilteredResult(_0x2d000a,_0x52bb13))[_0x3188('0x44')](handleError(_0x2d000a,null));};exports[_0x3188('0x45')]=function(_0x42c47b,_0x549ab2){var _0x484eeb={'raw':!![],'where':{'id':_0x42c47b['params']['id']}},_0x59069f={};_0x59069f['model']=_[_0x3188('0x30')](db[_0x3188('0x2b')][_0x3188('0x2c')]);_0x59069f[_0x3188('0x2f')]=_[_0x3188('0x30')](_0x42c47b['query']);_0x59069f[_0x3188('0x31')]=_['intersection'](_0x59069f[_0x3188('0x33')],_0x59069f[_0x3188('0x2f')]);_0x484eeb[_0x3188('0x34')]=_[_0x3188('0x32')](_0x59069f['model'],qs[_0x3188('0x35')](_0x42c47b[_0x3188('0x2f')][_0x3188('0x35')]));_0x484eeb[_0x3188('0x34')]=_0x484eeb[_0x3188('0x34')]['length']?_0x484eeb['attributes']:_0x59069f[_0x3188('0x33')];if(_0x42c47b[_0x3188('0x2f')]['includeAll']){_0x484eeb[_0x3188('0x42')]=[{'all':!![]}];}_0x484eeb=_[_0x3188('0x3d')]({},_0x484eeb,_0x42c47b['options']);return db[_0x3188('0x2b')][_0x3188('0x46')](_0x484eeb)[_0x3188('0x24')](handleEntityNotFound(_0x549ab2,null))[_0x3188('0x24')](respondWithResult(_0x549ab2,null))[_0x3188('0x44')](handleError(_0x549ab2,null));};exports['create']=function(_0x467ead,_0x4aba01){return db[_0x3188('0x2b')][_0x3188('0x47')](_0x467ead[_0x3188('0x48')],{})[_0x3188('0x24')](respondWithResult(_0x4aba01,0xc9))[_0x3188('0x44')](handleError(_0x4aba01,null));};exports[_0x3188('0x22')]=function(_0x2aa232,_0x413a0b){if(_0x2aa232[_0x3188('0x48')]['id']){delete _0x2aa232[_0x3188('0x48')]['id'];}return db[_0x3188('0x2b')]['find']({'where':{'id':_0x2aa232['params']['id']}})[_0x3188('0x24')](handleEntityNotFound(_0x413a0b,null))['then'](saveUpdates(_0x2aa232[_0x3188('0x48')],null))[_0x3188('0x24')](respondWithResult(_0x413a0b,null))['catch'](handleError(_0x413a0b,null));};exports[_0x3188('0x23')]=function(_0x16417a,_0x9526a8){return db[_0x3188('0x2b')][_0x3188('0x46')]({'where':{'id':_0x16417a[_0x3188('0x49')]['id']}})[_0x3188('0x24')](handleEntityNotFound(_0x9526a8,null))[_0x3188('0x24')](removeEntity(_0x9526a8,null))['catch'](handleError(_0x9526a8,null));};exports[_0x3188('0x4a')]=function(_0x3051ce,_0x556264){return db[_0x3188('0x2b')]['describe']()[_0x3188('0x24')](respondWithResult(_0x556264,null))[_0x3188('0x44')](handleError(_0x556264,null));};