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 _0xc0a5=['includeAll','include','findAll','catch','show','params','keys','options','find','create','body','update','describe','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','fs-extra','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','then','destroy','end','error','stack','name','send','index','map','rawAttributes','fieldName','type','key','model','query','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','SquareReport'];(function(_0x2c8dc5,_0x4432b8){var _0x50d8f0=function(_0x338caa){while(--_0x338caa){_0x2c8dc5['push'](_0x2c8dc5['shift']());}};_0x50d8f0(++_0x4432b8);}(_0xc0a5,0xf4));var _0x5c0a=function(_0x12fc8d,_0x19ee33){_0x12fc8d=_0x12fc8d-0x0;var _0x3f9d04=_0xc0a5[_0x12fc8d];return _0x3f9d04;};'use strict';var emlformat=require(_0x5c0a('0x0'));var rimraf=require(_0x5c0a('0x1'));var zipdir=require(_0x5c0a('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x5c0a('0x3'));var moment=require(_0x5c0a('0x4'));var BPromise=require(_0x5c0a('0x5'));var Mustache=require(_0x5c0a('0x6'));var util=require(_0x5c0a('0x7'));var path=require(_0x5c0a('0x8'));var sox=require('sox');var csv=require(_0x5c0a('0x9'));var ejs=require(_0x5c0a('0xa'));var fs=require('fs');var fs_extra=require(_0x5c0a('0xb'));var _=require('lodash');var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x5c0a('0xc'));var deskjs=require(_0x5c0a('0xd'));var toCsv=require(_0x5c0a('0x9'));var querystring=require(_0x5c0a('0xe'));var Papa=require(_0x5c0a('0xf'));var Redis=require(_0x5c0a('0x10'));var authService=require(_0x5c0a('0x11'));var qs=require('../../components/parsers/qs');var as=require(_0x5c0a('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x5c0a('0x13'));var utils=require('../../config/utils');var config=require(_0x5c0a('0x14'));var licenseUtil=require(_0x5c0a('0x15'));var db=require(_0x5c0a('0x16'))['db'];function respondWithStatusCode(_0x300f71,_0x481edf){_0x481edf=_0x481edf||0xcc;return function(_0x2c29c1){if(_0x2c29c1){return _0x300f71[_0x5c0a('0x17')](_0x481edf);}return _0x300f71[_0x5c0a('0x18')](_0x481edf)['end']();};}function respondWithResult(_0x35202e,_0x5d8bcd){_0x5d8bcd=_0x5d8bcd||0xc8;return function(_0x27c9d9){if(_0x27c9d9){return _0x35202e[_0x5c0a('0x18')](_0x5d8bcd)[_0x5c0a('0x19')](_0x27c9d9);}};}function respondWithFilteredResult(_0x46b8ae,_0x1332e2){return function(_0x4b20a7){if(_0x4b20a7){var _0x52b247=typeof _0x1332e2[_0x5c0a('0x1a')]===_0x5c0a('0x1b')&&typeof _0x1332e2[_0x5c0a('0x1c')]===_0x5c0a('0x1b');var _0x5cb130=_0x4b20a7[_0x5c0a('0x1d')];var _0x3b7be0=_0x52b247?0x0:_0x1332e2['offset'];var _0x4c15df=_0x52b247?_0x4b20a7[_0x5c0a('0x1d')]:_0x1332e2[_0x5c0a('0x1a')]+_0x1332e2[_0x5c0a('0x1c')];var _0x2793bd;if(_0x4c15df>=_0x5cb130){_0x4c15df=_0x5cb130;_0x2793bd=0xc8;}else{_0x2793bd=0xce;}_0x46b8ae[_0x5c0a('0x18')](_0x2793bd);return _0x46b8ae[_0x5c0a('0x1e')](_0x5c0a('0x1f'),_0x3b7be0+'-'+_0x4c15df+'/'+_0x5cb130)[_0x5c0a('0x19')](_0x4b20a7);}return null;};}function patchUpdates(_0x25e397){return function(_0x29a29e){try{jsonpatch[_0x5c0a('0x20')](_0x29a29e,_0x25e397,!![]);}catch(_0x424fdd){return BPromise[_0x5c0a('0x21')](_0x424fdd);}return _0x29a29e[_0x5c0a('0x22')]();};}function saveUpdates(_0x9d9466,_0x13cc00){return function(_0x50ee31){if(_0x50ee31){return _0x50ee31['update'](_0x9d9466)[_0x5c0a('0x23')](function(_0x25e479){return _0x25e479;});}return null;};}function removeEntity(_0x29006f,_0x48f790){return function(_0x365e05){if(_0x365e05){return _0x365e05[_0x5c0a('0x24')]()['then'](function(){_0x29006f[_0x5c0a('0x18')](0xcc)[_0x5c0a('0x25')]();});}};}function handleEntityNotFound(_0x33304a,_0x560c6c){return function(_0x519396){if(!_0x519396){_0x33304a[_0x5c0a('0x17')](0x194);}return _0x519396;};}function handleError(_0x52f18,_0x42070a){_0x42070a=_0x42070a||0x1f4;return function(_0x300fb7){logger[_0x5c0a('0x26')](_0x300fb7[_0x5c0a('0x27')]);if(_0x300fb7[_0x5c0a('0x28')]){delete _0x300fb7[_0x5c0a('0x28')];}_0x52f18[_0x5c0a('0x18')](_0x42070a)[_0x5c0a('0x29')](_0x300fb7);};}exports[_0x5c0a('0x2a')]=function(_0x5165fe,_0x65c992){var _0x2dc446={},_0x1557d9={},_0x390d7d={'count':0x0,'rows':[]};var _0x92573a=_[_0x5c0a('0x2b')](db['SquareReport'][_0x5c0a('0x2c')],function(_0x536adf){return{'name':_0x536adf[_0x5c0a('0x2d')],'type':_0x536adf[_0x5c0a('0x2e')][_0x5c0a('0x2f')]};});_0x1557d9[_0x5c0a('0x30')]=_[_0x5c0a('0x2b')](_0x92573a,_0x5c0a('0x28'));_0x1557d9['query']=_['keys'](_0x5165fe[_0x5c0a('0x31')]);_0x1557d9[_0x5c0a('0x32')]=_['intersection'](_0x1557d9[_0x5c0a('0x30')],_0x1557d9[_0x5c0a('0x31')]);_0x2dc446[_0x5c0a('0x33')]=_[_0x5c0a('0x34')](_0x1557d9[_0x5c0a('0x30')],qs[_0x5c0a('0x35')](_0x5165fe['query']['fields']));_0x2dc446['attributes']=_0x2dc446['attributes'][_0x5c0a('0x36')]?_0x2dc446[_0x5c0a('0x33')]:_0x1557d9[_0x5c0a('0x30')];if(!_0x5165fe['query'][_0x5c0a('0x37')](_0x5c0a('0x38'))){_0x2dc446[_0x5c0a('0x1c')]=qs[_0x5c0a('0x1c')](_0x5165fe['query'][_0x5c0a('0x1c')]);_0x2dc446[_0x5c0a('0x1a')]=qs['offset'](_0x5165fe['query'][_0x5c0a('0x1a')]);}_0x2dc446[_0x5c0a('0x39')]=qs[_0x5c0a('0x3a')](_0x5165fe['query']['sort']);_0x2dc446[_0x5c0a('0x3b')]=qs[_0x5c0a('0x32')](_[_0x5c0a('0x3c')](_0x5165fe['query'],_0x1557d9[_0x5c0a('0x32')]),_0x92573a);if(_0x5165fe[_0x5c0a('0x31')][_0x5c0a('0x3d')]){_0x2dc446['where']=_[_0x5c0a('0x3e')](_0x2dc446[_0x5c0a('0x3b')],{'$or':_[_0x5c0a('0x2b')](_0x92573a,function(_0x56d72c){if(_0x56d72c[_0x5c0a('0x2e')]!=='VIRTUAL'){var _0x349a3a={};_0x349a3a[_0x56d72c[_0x5c0a('0x28')]]={'$like':'%'+_0x5165fe[_0x5c0a('0x31')][_0x5c0a('0x3d')]+'%'};return _0x349a3a;}})});}_0x2dc446=_[_0x5c0a('0x3e')]({},_0x2dc446,_0x5165fe['options']);var _0x5322b={'where':_0x2dc446[_0x5c0a('0x3b')]};return db[_0x5c0a('0x3f')]['count'](_0x5322b)[_0x5c0a('0x23')](function(_0x1d6039){_0x390d7d[_0x5c0a('0x1d')]=_0x1d6039;if(_0x5165fe['query'][_0x5c0a('0x40')]){_0x2dc446[_0x5c0a('0x41')]=[{'all':!![]}];}return db[_0x5c0a('0x3f')][_0x5c0a('0x42')](_0x2dc446);})['then'](function(_0x104f5e){_0x390d7d['rows']=_0x104f5e;return _0x390d7d;})[_0x5c0a('0x23')](respondWithFilteredResult(_0x65c992,_0x2dc446))[_0x5c0a('0x43')](handleError(_0x65c992,null));};exports[_0x5c0a('0x44')]=function(_0x4ee03a,_0x5d1e6b){var _0x1b638b={'raw':!![],'where':{'id':_0x4ee03a[_0x5c0a('0x45')]['id']}},_0x1c4861={};_0x1c4861[_0x5c0a('0x30')]=_[_0x5c0a('0x46')](db[_0x5c0a('0x3f')][_0x5c0a('0x2c')]);_0x1c4861[_0x5c0a('0x31')]=_[_0x5c0a('0x46')](_0x4ee03a[_0x5c0a('0x31')]);_0x1c4861[_0x5c0a('0x32')]=_['intersection'](_0x1c4861[_0x5c0a('0x30')],_0x1c4861[_0x5c0a('0x31')]);_0x1b638b[_0x5c0a('0x33')]=_[_0x5c0a('0x34')](_0x1c4861[_0x5c0a('0x30')],qs[_0x5c0a('0x35')](_0x4ee03a[_0x5c0a('0x31')][_0x5c0a('0x35')]));_0x1b638b[_0x5c0a('0x33')]=_0x1b638b[_0x5c0a('0x33')][_0x5c0a('0x36')]?_0x1b638b[_0x5c0a('0x33')]:_0x1c4861[_0x5c0a('0x30')];if(_0x4ee03a[_0x5c0a('0x31')][_0x5c0a('0x40')]){_0x1b638b[_0x5c0a('0x41')]=[{'all':!![]}];}_0x1b638b=_['merge']({},_0x1b638b,_0x4ee03a[_0x5c0a('0x47')]);return db[_0x5c0a('0x3f')][_0x5c0a('0x48')](_0x1b638b)['then'](handleEntityNotFound(_0x5d1e6b,null))[_0x5c0a('0x23')](respondWithResult(_0x5d1e6b,null))['catch'](handleError(_0x5d1e6b,null));};exports['create']=function(_0x344ff0,_0x102e6a){return db[_0x5c0a('0x3f')][_0x5c0a('0x49')](_0x344ff0[_0x5c0a('0x4a')],{})['then'](respondWithResult(_0x102e6a,0xc9))[_0x5c0a('0x43')](handleError(_0x102e6a,null));};exports[_0x5c0a('0x4b')]=function(_0x27bc4a,_0x2d1c8a){if(_0x27bc4a['body']['id']){delete _0x27bc4a['body']['id'];}return db[_0x5c0a('0x3f')][_0x5c0a('0x48')]({'where':{'id':_0x27bc4a[_0x5c0a('0x45')]['id']}})['then'](handleEntityNotFound(_0x2d1c8a,null))[_0x5c0a('0x23')](saveUpdates(_0x27bc4a[_0x5c0a('0x4a')],null))[_0x5c0a('0x23')](respondWithResult(_0x2d1c8a,null))[_0x5c0a('0x43')](handleError(_0x2d1c8a,null));};exports[_0x5c0a('0x24')]=function(_0x519f81,_0x4e44be){return db[_0x5c0a('0x3f')][_0x5c0a('0x48')]({'where':{'id':_0x519f81['params']['id']}})['then'](handleEntityNotFound(_0x4e44be,null))[_0x5c0a('0x23')](removeEntity(_0x4e44be,null))[_0x5c0a('0x43')](handleError(_0x4e44be,null));};exports[_0x5c0a('0x4c')]=function(_0x1fb322,_0xa83abb){return db[_0x5c0a('0x3f')]['describe']()[_0x5c0a('0x23')](respondWithResult(_0xa83abb,null))[_0x5c0a('0x43')](handleError(_0xa83abb,null));};