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 _0xfd1e=['length','includeAll','find','create','body','destroy','describe','html-pdf','eml-format','rimraf','request-promise','bluebird','mustache','util','sox','to-csv','ejs','lodash','squel','crypto','desk.js','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/environment','../../mysqldb','sendStatus','status','end','json','count','offset','limit','apply','save','update','then','name','send','map','SquareReport','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','sort','where','pick','merge','VIRTUAL','filter','options','findAll','rows','catch','show','params'];(function(_0x102c14,_0x5839b9){var _0xdf57b4=function(_0x288d50){while(--_0x288d50){_0x102c14['push'](_0x102c14['shift']());}};_0xdf57b4(++_0x5839b9);}(_0xfd1e,0x1a5));var _0xefd1=function(_0x3b4a24,_0x434a1c){_0x3b4a24=_0x3b4a24-0x0;var _0x27e8da=_0xfd1e[_0x3b4a24];return _0x27e8da;};'use strict';var pdf=require(_0xefd1('0x0'));var emlformat=require(_0xefd1('0x1'));var rimraf=require(_0xefd1('0x2'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0xefd1('0x3'));var moment=require('moment');var BPromise=require(_0xefd1('0x4'));var Mustache=require(_0xefd1('0x5'));var util=require(_0xefd1('0x6'));var path=require('path');var sox=require(_0xefd1('0x7'));var csv=require(_0xefd1('0x8'));var ejs=require(_0xefd1('0x9'));var fs=require('fs');var _=require(_0xefd1('0xa'));var squel=require(_0xefd1('0xb'));var crypto=require(_0xefd1('0xc'));var jsforce=require('jsforce');var deskjs=require(_0xefd1('0xd'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0xefd1('0xe'));var authService=require(_0xefd1('0xf'));var qs=require(_0xefd1('0x10'));var as=require(_0xefd1('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xefd1('0x12'))(_0xefd1('0x13'));var utils=require('../../config/utils');var config=require(_0xefd1('0x14'));var db=require(_0xefd1('0x15'))['db'];function respondWithStatusCode(_0x47d6a4,_0x3bd001){_0x3bd001=_0x3bd001||0xcc;return function(_0x3ce109){if(_0x3ce109){return _0x47d6a4[_0xefd1('0x16')](_0x3bd001);}return _0x47d6a4[_0xefd1('0x17')](_0x3bd001)[_0xefd1('0x18')]();};}function respondWithResult(_0x4cd767,_0x3aabe6){_0x3aabe6=_0x3aabe6||0xc8;return function(_0x33af77){if(_0x33af77){return _0x4cd767[_0xefd1('0x17')](_0x3aabe6)[_0xefd1('0x19')](_0x33af77);}};}function respondWithFilteredResult(_0x2855cd,_0xff8e2d){return function(_0x56bd75){if(_0x56bd75){var _0x460da8=_0x56bd75[_0xefd1('0x1a')],_0x5910ce=_0xff8e2d['offset'],_0x4a8b54=_0xff8e2d[_0xefd1('0x1b')]+_0xff8e2d[_0xefd1('0x1c')],_0x4c0819;if(_0x4a8b54>=_0x460da8){_0x4a8b54=_0x460da8;_0x4c0819=0xc8;}else{_0x4c0819=0xce;}_0x2855cd[_0xefd1('0x17')](_0x4c0819);return _0x2855cd['set']('Content-Range',_0x5910ce+'-'+_0x4a8b54+'/'+_0x460da8)[_0xefd1('0x19')](_0x56bd75);}return null;};}function patchUpdates(_0x3e5363){return function(_0x14b354){try{jsonpatch[_0xefd1('0x1d')](_0x14b354,_0x3e5363,!![]);}catch(_0x2169a0){return BPromise['reject'](_0x2169a0);}return _0x14b354[_0xefd1('0x1e')]();};}function saveUpdates(_0x22946a,_0x301d16){return function(_0x5f3c01){if(_0x5f3c01){return _0x5f3c01[_0xefd1('0x1f')](_0x22946a)[_0xefd1('0x20')](function(_0x267d98){return _0x267d98;});}return null;};}function removeEntity(_0x49336f,_0x3b9563){return function(_0x29aebf){if(_0x29aebf){return _0x29aebf['destroy']()['then'](function(){_0x49336f[_0xefd1('0x17')](0xcc)[_0xefd1('0x18')]();});}};}function handleEntityNotFound(_0x52807f,_0x43dc1a){return function(_0x438e21){if(!_0x438e21){_0x52807f[_0xefd1('0x16')](0x194);}return _0x438e21;};}function handleError(_0x6dfc2f,_0x947ee6){_0x947ee6=_0x947ee6||0x1f4;return function(_0xe6c3f4){logger['error'](_0xe6c3f4['stack']);if(_0xe6c3f4['name']){delete _0xe6c3f4[_0xefd1('0x21')];}_0x6dfc2f[_0xefd1('0x17')](_0x947ee6)[_0xefd1('0x22')](_0xe6c3f4);};}exports['index']=function(_0x143e39,_0x2b32fb){var _0x2a914e={},_0x164634={},_0x339f3c={'count':0x0,'rows':[]};var _0x554a93=_[_0xefd1('0x23')](db[_0xefd1('0x24')][_0xefd1('0x25')],function(_0x210b5b){return{'name':_0x210b5b[_0xefd1('0x26')],'type':_0x210b5b[_0xefd1('0x27')][_0xefd1('0x28')]};});_0x164634[_0xefd1('0x29')]=_[_0xefd1('0x23')](_0x554a93,_0xefd1('0x21'));_0x164634[_0xefd1('0x2a')]=_[_0xefd1('0x2b')](_0x143e39['query']);_0x164634[_0xefd1('0x2c')]=_[_0xefd1('0x2d')](_0x164634[_0xefd1('0x29')],_0x164634[_0xefd1('0x2a')]);_0x2a914e['attributes']=_[_0xefd1('0x2d')](_0x164634['model'],qs['fields'](_0x143e39[_0xefd1('0x2a')][_0xefd1('0x2e')]));_0x2a914e[_0xefd1('0x2f')]=_0x2a914e[_0xefd1('0x2f')]['length']?_0x2a914e[_0xefd1('0x2f')]:_0x164634['model'];if(!_0x143e39[_0xefd1('0x2a')][_0xefd1('0x30')](_0xefd1('0x31'))){_0x2a914e[_0xefd1('0x1c')]=qs[_0xefd1('0x1c')](_0x143e39[_0xefd1('0x2a')][_0xefd1('0x1c')]);_0x2a914e[_0xefd1('0x1b')]=qs[_0xefd1('0x1b')](_0x143e39[_0xefd1('0x2a')][_0xefd1('0x1b')]);}_0x2a914e['order']=qs[_0xefd1('0x32')](_0x143e39[_0xefd1('0x2a')][_0xefd1('0x32')]);_0x2a914e[_0xefd1('0x33')]=qs[_0xefd1('0x2c')](_[_0xefd1('0x34')](_0x143e39['query'],_0x164634[_0xefd1('0x2c')]),_0x554a93);if(_0x143e39['query']['filter']){_0x2a914e['where']=_[_0xefd1('0x35')](_0x2a914e[_0xefd1('0x33')],{'$or':_[_0xefd1('0x23')](_0x554a93,function(_0x2876c0){if(_0x2876c0[_0xefd1('0x27')]!==_0xefd1('0x36')){var _0x1ae384={};_0x1ae384[_0x2876c0[_0xefd1('0x21')]]={'$like':'%'+_0x143e39[_0xefd1('0x2a')][_0xefd1('0x37')]+'%'};return _0x1ae384;}})});}_0x2a914e=_[_0xefd1('0x35')]({},_0x2a914e,_0x143e39[_0xefd1('0x38')]);var _0x4c7e16={'where':_0x2a914e['where']};return db['SquareReport'][_0xefd1('0x1a')](_0x4c7e16)[_0xefd1('0x20')](function(_0x5f2f68){_0x339f3c[_0xefd1('0x1a')]=_0x5f2f68;if(_0x143e39['query']['includeAll']){_0x2a914e['include']=[{'all':!![]}];}return db[_0xefd1('0x24')][_0xefd1('0x39')](_0x2a914e);})[_0xefd1('0x20')](function(_0x311d88){_0x339f3c[_0xefd1('0x3a')]=_0x311d88;return _0x339f3c;})[_0xefd1('0x20')](respondWithFilteredResult(_0x2b32fb,_0x2a914e))[_0xefd1('0x3b')](handleError(_0x2b32fb,null));};exports[_0xefd1('0x3c')]=function(_0x40eeda,_0xad179b){var _0x496834={'raw':!![],'where':{'id':_0x40eeda[_0xefd1('0x3d')]['id']}},_0x1bc5bc={};_0x1bc5bc[_0xefd1('0x29')]=_['keys'](db[_0xefd1('0x24')][_0xefd1('0x25')]);_0x1bc5bc[_0xefd1('0x2a')]=_[_0xefd1('0x2b')](_0x40eeda[_0xefd1('0x2a')]);_0x1bc5bc[_0xefd1('0x2c')]=_['intersection'](_0x1bc5bc[_0xefd1('0x29')],_0x1bc5bc[_0xefd1('0x2a')]);_0x496834[_0xefd1('0x2f')]=_[_0xefd1('0x2d')](_0x1bc5bc[_0xefd1('0x29')],qs[_0xefd1('0x2e')](_0x40eeda[_0xefd1('0x2a')][_0xefd1('0x2e')]));_0x496834[_0xefd1('0x2f')]=_0x496834['attributes'][_0xefd1('0x3e')]?_0x496834[_0xefd1('0x2f')]:_0x1bc5bc[_0xefd1('0x29')];if(_0x40eeda['query'][_0xefd1('0x3f')]){_0x496834['include']=[{'all':!![]}];}_0x496834=_[_0xefd1('0x35')]({},_0x496834,_0x40eeda[_0xefd1('0x38')]);return db[_0xefd1('0x24')][_0xefd1('0x40')](_0x496834)[_0xefd1('0x20')](handleEntityNotFound(_0xad179b,null))[_0xefd1('0x20')](respondWithResult(_0xad179b,null))['catch'](handleError(_0xad179b,null));};exports[_0xefd1('0x41')]=function(_0x4e8e62,_0xecf284){return db[_0xefd1('0x24')]['create'](_0x4e8e62[_0xefd1('0x42')],{})[_0xefd1('0x20')](respondWithResult(_0xecf284,0xc9))[_0xefd1('0x3b')](handleError(_0xecf284,null));};exports[_0xefd1('0x1f')]=function(_0x5681c6,_0x200fdc){if(_0x5681c6[_0xefd1('0x42')]['id']){delete _0x5681c6[_0xefd1('0x42')]['id'];}return db[_0xefd1('0x24')]['find']({'where':{'id':_0x5681c6[_0xefd1('0x3d')]['id']}})['then'](handleEntityNotFound(_0x200fdc,null))[_0xefd1('0x20')](saveUpdates(_0x5681c6[_0xefd1('0x42')],null))[_0xefd1('0x20')](respondWithResult(_0x200fdc,null))['catch'](handleError(_0x200fdc,null));};exports[_0xefd1('0x43')]=function(_0x1a361c,_0x1490ef){return db[_0xefd1('0x24')][_0xefd1('0x40')]({'where':{'id':_0x1a361c[_0xefd1('0x3d')]['id']}})[_0xefd1('0x20')](handleEntityNotFound(_0x1490ef,null))['then'](removeEntity(_0x1490ef,null))[_0xefd1('0x3b')](handleError(_0x1490ef,null));};exports[_0xefd1('0x44')]=function(_0x581b5a,_0xca395d){return db[_0xefd1('0x24')][_0xefd1('0x44')]()[_0xefd1('0x20')](respondWithResult(_0xca395d,null))[_0xefd1('0x3b')](handleError(_0xca395d,null));};