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 _0x7c09=['reject','update','destroy','then','stack','name','SquareReport','rawAttributes','type','key','model','map','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','filter','where','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','keys','find','create','body','describe','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','lodash','squel','crypto','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','count','offset','limit','set','Content-Range','json','apply'];(function(_0x2932cf,_0x362fd9){var _0x1711dd=function(_0x2d8de6){while(--_0x2d8de6){_0x2932cf['push'](_0x2932cf['shift']());}};_0x1711dd(++_0x362fd9);}(_0x7c09,0x102));var _0x97c0=function(_0xe2114d,_0x274ddb){_0xe2114d=_0xe2114d-0x0;var _0x23c442=_0x7c09[_0xe2114d];return _0x23c442;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x97c0('0x0'));var rimraf=require(_0x97c0('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x97c0('0x2'));var rp=require(_0x97c0('0x3'));var moment=require(_0x97c0('0x4'));var BPromise=require(_0x97c0('0x5'));var Mustache=require(_0x97c0('0x6'));var util=require(_0x97c0('0x7'));var path=require(_0x97c0('0x8'));var sox=require('sox');var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require(_0x97c0('0x9'));var squel=require(_0x97c0('0xa'));var crypto=require(_0x97c0('0xb'));var jsforce=require(_0x97c0('0xc'));var deskjs=require(_0x97c0('0xd'));var toCsv=require('to-csv');var querystring=require(_0x97c0('0xe'));var Papa=require('papaparse');var Redis=require(_0x97c0('0xf'));var authService=require(_0x97c0('0x10'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x97c0('0x11'));var logger=require(_0x97c0('0x12'))(_0x97c0('0x13'));var utils=require(_0x97c0('0x14'));var config=require(_0x97c0('0x15'));var licenseUtil=require(_0x97c0('0x16'));var db=require(_0x97c0('0x17'))['db'];function respondWithStatusCode(_0x39a3b4,_0x9ca3c1){_0x9ca3c1=_0x9ca3c1||0xcc;return function(_0x2ecf34){if(_0x2ecf34){return _0x39a3b4[_0x97c0('0x18')](_0x9ca3c1);}return _0x39a3b4[_0x97c0('0x19')](_0x9ca3c1)[_0x97c0('0x1a')]();};}function respondWithResult(_0x514782,_0x3f2fc2){_0x3f2fc2=_0x3f2fc2||0xc8;return function(_0x15b336){if(_0x15b336){return _0x514782[_0x97c0('0x19')](_0x3f2fc2)['json'](_0x15b336);}};}function respondWithFilteredResult(_0x42027d,_0x9ca6a8){return function(_0x379951){if(_0x379951){var _0x21e5f7=_0x379951[_0x97c0('0x1b')],_0x482be5=_0x9ca6a8[_0x97c0('0x1c')],_0x13d46e=_0x9ca6a8['offset']+_0x9ca6a8[_0x97c0('0x1d')],_0x49c0d9;if(_0x13d46e>=_0x21e5f7){_0x13d46e=_0x21e5f7;_0x49c0d9=0xc8;}else{_0x49c0d9=0xce;}_0x42027d[_0x97c0('0x19')](_0x49c0d9);return _0x42027d[_0x97c0('0x1e')](_0x97c0('0x1f'),_0x482be5+'-'+_0x13d46e+'/'+_0x21e5f7)[_0x97c0('0x20')](_0x379951);}return null;};}function patchUpdates(_0x3e7a52){return function(_0x4fed42){try{jsonpatch[_0x97c0('0x21')](_0x4fed42,_0x3e7a52,!![]);}catch(_0x432705){return BPromise[_0x97c0('0x22')](_0x432705);}return _0x4fed42['save']();};}function saveUpdates(_0x554122,_0x2b74a2){return function(_0xa3f59d){if(_0xa3f59d){return _0xa3f59d[_0x97c0('0x23')](_0x554122)['then'](function(_0x13a6c9){return _0x13a6c9;});}return null;};}function removeEntity(_0x20bc4c,_0x31ffb7){return function(_0x272314){if(_0x272314){return _0x272314[_0x97c0('0x24')]()[_0x97c0('0x25')](function(){_0x20bc4c[_0x97c0('0x19')](0xcc)['end']();});}};}function handleEntityNotFound(_0x60ab00,_0x29b3aa){return function(_0x1f7adb){if(!_0x1f7adb){_0x60ab00[_0x97c0('0x18')](0x194);}return _0x1f7adb;};}function handleError(_0x5a17df,_0x2bda6c){_0x2bda6c=_0x2bda6c||0x1f4;return function(_0x14cada){logger['error'](_0x14cada[_0x97c0('0x26')]);if(_0x14cada[_0x97c0('0x27')]){delete _0x14cada[_0x97c0('0x27')];}_0x5a17df['status'](_0x2bda6c)['send'](_0x14cada);};}exports['index']=function(_0x11b8ad,_0x8e3ee7){var _0x3a744c={},_0x225e43={},_0x26939e={'count':0x0,'rows':[]};var _0x153b14=_['map'](db[_0x97c0('0x28')][_0x97c0('0x29')],function(_0x325090){return{'name':_0x325090['fieldName'],'type':_0x325090[_0x97c0('0x2a')][_0x97c0('0x2b')]};});_0x225e43[_0x97c0('0x2c')]=_[_0x97c0('0x2d')](_0x153b14,_0x97c0('0x27'));_0x225e43['query']=_['keys'](_0x11b8ad[_0x97c0('0x2e')]);_0x225e43[_0x97c0('0x2f')]=_[_0x97c0('0x30')](_0x225e43['model'],_0x225e43[_0x97c0('0x2e')]);_0x3a744c[_0x97c0('0x31')]=_['intersection'](_0x225e43[_0x97c0('0x2c')],qs[_0x97c0('0x32')](_0x11b8ad[_0x97c0('0x2e')][_0x97c0('0x32')]));_0x3a744c[_0x97c0('0x31')]=_0x3a744c[_0x97c0('0x31')][_0x97c0('0x33')]?_0x3a744c[_0x97c0('0x31')]:_0x225e43[_0x97c0('0x2c')];if(!_0x11b8ad[_0x97c0('0x2e')][_0x97c0('0x34')](_0x97c0('0x35'))){_0x3a744c[_0x97c0('0x1d')]=qs[_0x97c0('0x1d')](_0x11b8ad[_0x97c0('0x2e')]['limit']);_0x3a744c[_0x97c0('0x1c')]=qs[_0x97c0('0x1c')](_0x11b8ad[_0x97c0('0x2e')][_0x97c0('0x1c')]);}_0x3a744c[_0x97c0('0x36')]=qs[_0x97c0('0x37')](_0x11b8ad[_0x97c0('0x2e')][_0x97c0('0x37')]);_0x3a744c['where']=qs[_0x97c0('0x2f')](_['pick'](_0x11b8ad[_0x97c0('0x2e')],_0x225e43[_0x97c0('0x2f')]),_0x153b14);if(_0x11b8ad[_0x97c0('0x2e')][_0x97c0('0x38')]){_0x3a744c[_0x97c0('0x39')]=_[_0x97c0('0x3a')](_0x3a744c[_0x97c0('0x39')],{'$or':_[_0x97c0('0x2d')](_0x153b14,function(_0x38f37a){if(_0x38f37a[_0x97c0('0x2a')]!==_0x97c0('0x3b')){var _0x4a1dad={};_0x4a1dad[_0x38f37a[_0x97c0('0x27')]]={'$like':'%'+_0x11b8ad[_0x97c0('0x2e')]['filter']+'%'};return _0x4a1dad;}})});}_0x3a744c=_[_0x97c0('0x3a')]({},_0x3a744c,_0x11b8ad[_0x97c0('0x3c')]);var _0x2aeffc={'where':_0x3a744c[_0x97c0('0x39')]};return db['SquareReport'][_0x97c0('0x1b')](_0x2aeffc)['then'](function(_0x1acf31){_0x26939e[_0x97c0('0x1b')]=_0x1acf31;if(_0x11b8ad['query'][_0x97c0('0x3d')]){_0x3a744c[_0x97c0('0x3e')]=[{'all':!![]}];}return db[_0x97c0('0x28')][_0x97c0('0x3f')](_0x3a744c);})[_0x97c0('0x25')](function(_0x2121e8){_0x26939e[_0x97c0('0x40')]=_0x2121e8;return _0x26939e;})[_0x97c0('0x25')](respondWithFilteredResult(_0x8e3ee7,_0x3a744c))[_0x97c0('0x41')](handleError(_0x8e3ee7,null));};exports[_0x97c0('0x42')]=function(_0x25e099,_0x2cca4c){var _0x1351d2={'raw':!![],'where':{'id':_0x25e099[_0x97c0('0x43')]['id']}},_0x5da697={};_0x5da697[_0x97c0('0x2c')]=_[_0x97c0('0x44')](db[_0x97c0('0x28')][_0x97c0('0x29')]);_0x5da697[_0x97c0('0x2e')]=_[_0x97c0('0x44')](_0x25e099['query']);_0x5da697['filters']=_[_0x97c0('0x30')](_0x5da697[_0x97c0('0x2c')],_0x5da697[_0x97c0('0x2e')]);_0x1351d2[_0x97c0('0x31')]=_[_0x97c0('0x30')](_0x5da697['model'],qs['fields'](_0x25e099['query'][_0x97c0('0x32')]));_0x1351d2['attributes']=_0x1351d2['attributes'][_0x97c0('0x33')]?_0x1351d2[_0x97c0('0x31')]:_0x5da697[_0x97c0('0x2c')];if(_0x25e099[_0x97c0('0x2e')][_0x97c0('0x3d')]){_0x1351d2['include']=[{'all':!![]}];}_0x1351d2=_[_0x97c0('0x3a')]({},_0x1351d2,_0x25e099[_0x97c0('0x3c')]);return db[_0x97c0('0x28')][_0x97c0('0x45')](_0x1351d2)[_0x97c0('0x25')](handleEntityNotFound(_0x2cca4c,null))[_0x97c0('0x25')](respondWithResult(_0x2cca4c,null))[_0x97c0('0x41')](handleError(_0x2cca4c,null));};exports[_0x97c0('0x46')]=function(_0x2c50ff,_0x8a952c){return db['SquareReport'][_0x97c0('0x46')](_0x2c50ff[_0x97c0('0x47')],{})[_0x97c0('0x25')](respondWithResult(_0x8a952c,0xc9))[_0x97c0('0x41')](handleError(_0x8a952c,null));};exports['update']=function(_0x597a0f,_0x207620){if(_0x597a0f[_0x97c0('0x47')]['id']){delete _0x597a0f[_0x97c0('0x47')]['id'];}return db['SquareReport'][_0x97c0('0x45')]({'where':{'id':_0x597a0f[_0x97c0('0x43')]['id']}})[_0x97c0('0x25')](handleEntityNotFound(_0x207620,null))[_0x97c0('0x25')](saveUpdates(_0x597a0f[_0x97c0('0x47')],null))['then'](respondWithResult(_0x207620,null))[_0x97c0('0x41')](handleError(_0x207620,null));};exports[_0x97c0('0x24')]=function(_0x3b8b07,_0x5651c5){return db['SquareReport'][_0x97c0('0x45')]({'where':{'id':_0x3b8b07['params']['id']}})['then'](handleEntityNotFound(_0x5651c5,null))[_0x97c0('0x25')](removeEntity(_0x5651c5,null))[_0x97c0('0x41')](handleError(_0x5651c5,null));};exports[_0x97c0('0x48')]=function(_0x53a255,_0x5eb3da){return db['SquareReport'][_0x97c0('0x48')]()[_0x97c0('0x25')](respondWithResult(_0x5eb3da,null))[_0x97c0('0x41')](handleError(_0x5eb3da,null));};