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 _0x9651=['desk.js','querystring','papaparse','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','json','count','offset','limit','set','Content-Range','reject','save','update','then','error','stack','send','index','map','type','key','name','query','model','attributes','intersection','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge','VIRTUAL','options','SquareReport','includeAll','include','findAll','rows','catch','params','rawAttributes','keys','find','create','body','destroy','describe','rimraf','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','fs-extra','lodash','jsforce'];(function(_0x21125a,_0x24e0f1){var _0x4b99e=function(_0x30af10){while(--_0x30af10){_0x21125a['push'](_0x21125a['shift']());}};_0x4b99e(++_0x24e0f1);}(_0x9651,0x166));var _0x1965=function(_0x48cd74,_0x4b28db){_0x48cd74=_0x48cd74-0x0;var _0x44df56=_0x9651[_0x48cd74];return _0x44df56;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x1965('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0x1965('0x1'));var rp=require(_0x1965('0x2'));var moment=require('moment');var BPromise=require(_0x1965('0x3'));var Mustache=require(_0x1965('0x4'));var util=require(_0x1965('0x5'));var path=require(_0x1965('0x6'));var sox=require(_0x1965('0x7'));var csv=require(_0x1965('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x1965('0x9'));var _=require(_0x1965('0xa'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x1965('0xb'));var deskjs=require(_0x1965('0xc'));var toCsv=require(_0x1965('0x8'));var querystring=require(_0x1965('0xd'));var Papa=require(_0x1965('0xe'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x1965('0xf'));var hardwareService=require(_0x1965('0x10'));var logger=require(_0x1965('0x11'))(_0x1965('0x12'));var utils=require(_0x1965('0x13'));var config=require(_0x1965('0x14'));var licenseUtil=require(_0x1965('0x15'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0xe28598,_0x409727){_0x409727=_0x409727||0xcc;return function(_0x56ee8f){if(_0x56ee8f){return _0xe28598[_0x1965('0x16')](_0x409727);}return _0xe28598[_0x1965('0x17')](_0x409727)[_0x1965('0x18')]();};}function respondWithResult(_0x15d140,_0x516f8c){_0x516f8c=_0x516f8c||0xc8;return function(_0x38dbf4){if(_0x38dbf4){return _0x15d140[_0x1965('0x17')](_0x516f8c)[_0x1965('0x19')](_0x38dbf4);}};}function respondWithFilteredResult(_0x3c190a,_0x2457ba){return function(_0x327fa3){if(_0x327fa3){var _0xd82857=_0x327fa3[_0x1965('0x1a')],_0x25bea6=_0x2457ba[_0x1965('0x1b')],_0x1d8e0c=_0x2457ba[_0x1965('0x1b')]+_0x2457ba[_0x1965('0x1c')],_0x3c97de;if(_0x1d8e0c>=_0xd82857){_0x1d8e0c=_0xd82857;_0x3c97de=0xc8;}else{_0x3c97de=0xce;}_0x3c190a[_0x1965('0x17')](_0x3c97de);return _0x3c190a[_0x1965('0x1d')](_0x1965('0x1e'),_0x25bea6+'-'+_0x1d8e0c+'/'+_0xd82857)[_0x1965('0x19')](_0x327fa3);}return null;};}function patchUpdates(_0x14973b){return function(_0xc9bfad){try{jsonpatch['apply'](_0xc9bfad,_0x14973b,!![]);}catch(_0x27a706){return BPromise[_0x1965('0x1f')](_0x27a706);}return _0xc9bfad[_0x1965('0x20')]();};}function saveUpdates(_0x31e0c0,_0xd881ea){return function(_0x31ee7e){if(_0x31ee7e){return _0x31ee7e[_0x1965('0x21')](_0x31e0c0)[_0x1965('0x22')](function(_0x4a053e){return _0x4a053e;});}return null;};}function removeEntity(_0x314d5d,_0x33afb9){return function(_0xd5320){if(_0xd5320){return _0xd5320['destroy']()['then'](function(){_0x314d5d['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x3029dc,_0x5c06b9){return function(_0x36b5b9){if(!_0x36b5b9){_0x3029dc[_0x1965('0x16')](0x194);}return _0x36b5b9;};}function handleError(_0x581f73,_0x33d030){_0x33d030=_0x33d030||0x1f4;return function(_0x3a3ff4){logger[_0x1965('0x23')](_0x3a3ff4[_0x1965('0x24')]);if(_0x3a3ff4['name']){delete _0x3a3ff4['name'];}_0x581f73[_0x1965('0x17')](_0x33d030)[_0x1965('0x25')](_0x3a3ff4);};}exports[_0x1965('0x26')]=function(_0x41ff51,_0x3ccc77){var _0x34a532={},_0x4eaf92={},_0x466716={'count':0x0,'rows':[]};var _0x50cfd7=_[_0x1965('0x27')](db['SquareReport']['rawAttributes'],function(_0x1c9a7e){return{'name':_0x1c9a7e['fieldName'],'type':_0x1c9a7e[_0x1965('0x28')][_0x1965('0x29')]};});_0x4eaf92['model']=_[_0x1965('0x27')](_0x50cfd7,_0x1965('0x2a'));_0x4eaf92[_0x1965('0x2b')]=_['keys'](_0x41ff51[_0x1965('0x2b')]);_0x4eaf92['filters']=_['intersection'](_0x4eaf92[_0x1965('0x2c')],_0x4eaf92[_0x1965('0x2b')]);_0x34a532[_0x1965('0x2d')]=_[_0x1965('0x2e')](_0x4eaf92[_0x1965('0x2c')],qs['fields'](_0x41ff51[_0x1965('0x2b')][_0x1965('0x2f')]));_0x34a532[_0x1965('0x2d')]=_0x34a532['attributes'][_0x1965('0x30')]?_0x34a532[_0x1965('0x2d')]:_0x4eaf92[_0x1965('0x2c')];if(!_0x41ff51[_0x1965('0x2b')][_0x1965('0x31')](_0x1965('0x32'))){_0x34a532[_0x1965('0x1c')]=qs[_0x1965('0x1c')](_0x41ff51['query'][_0x1965('0x1c')]);_0x34a532[_0x1965('0x1b')]=qs[_0x1965('0x1b')](_0x41ff51[_0x1965('0x2b')][_0x1965('0x1b')]);}_0x34a532[_0x1965('0x33')]=qs[_0x1965('0x34')](_0x41ff51[_0x1965('0x2b')][_0x1965('0x34')]);_0x34a532[_0x1965('0x35')]=qs[_0x1965('0x36')](_[_0x1965('0x37')](_0x41ff51[_0x1965('0x2b')],_0x4eaf92['filters']),_0x50cfd7);if(_0x41ff51[_0x1965('0x2b')][_0x1965('0x38')]){_0x34a532[_0x1965('0x35')]=_[_0x1965('0x39')](_0x34a532[_0x1965('0x35')],{'$or':_['map'](_0x50cfd7,function(_0x303c02){if(_0x303c02['type']!==_0x1965('0x3a')){var _0x3fae0b={};_0x3fae0b[_0x303c02[_0x1965('0x2a')]]={'$like':'%'+_0x41ff51[_0x1965('0x2b')][_0x1965('0x38')]+'%'};return _0x3fae0b;}})});}_0x34a532=_[_0x1965('0x39')]({},_0x34a532,_0x41ff51[_0x1965('0x3b')]);var _0x2e3bae={'where':_0x34a532[_0x1965('0x35')]};return db[_0x1965('0x3c')]['count'](_0x2e3bae)[_0x1965('0x22')](function(_0x4b8460){_0x466716['count']=_0x4b8460;if(_0x41ff51[_0x1965('0x2b')][_0x1965('0x3d')]){_0x34a532[_0x1965('0x3e')]=[{'all':!![]}];}return db[_0x1965('0x3c')][_0x1965('0x3f')](_0x34a532);})[_0x1965('0x22')](function(_0x2d6ea7){_0x466716[_0x1965('0x40')]=_0x2d6ea7;return _0x466716;})['then'](respondWithFilteredResult(_0x3ccc77,_0x34a532))[_0x1965('0x41')](handleError(_0x3ccc77,null));};exports['show']=function(_0xdcdd02,_0x56ee11){var _0x6bdc2a={'raw':!![],'where':{'id':_0xdcdd02[_0x1965('0x42')]['id']}},_0x55b770={};_0x55b770[_0x1965('0x2c')]=_['keys'](db['SquareReport'][_0x1965('0x43')]);_0x55b770['query']=_[_0x1965('0x44')](_0xdcdd02[_0x1965('0x2b')]);_0x55b770['filters']=_[_0x1965('0x2e')](_0x55b770[_0x1965('0x2c')],_0x55b770['query']);_0x6bdc2a[_0x1965('0x2d')]=_[_0x1965('0x2e')](_0x55b770[_0x1965('0x2c')],qs['fields'](_0xdcdd02[_0x1965('0x2b')]['fields']));_0x6bdc2a['attributes']=_0x6bdc2a[_0x1965('0x2d')]['length']?_0x6bdc2a[_0x1965('0x2d')]:_0x55b770[_0x1965('0x2c')];if(_0xdcdd02[_0x1965('0x2b')][_0x1965('0x3d')]){_0x6bdc2a[_0x1965('0x3e')]=[{'all':!![]}];}_0x6bdc2a=_[_0x1965('0x39')]({},_0x6bdc2a,_0xdcdd02[_0x1965('0x3b')]);return db[_0x1965('0x3c')][_0x1965('0x45')](_0x6bdc2a)[_0x1965('0x22')](handleEntityNotFound(_0x56ee11,null))[_0x1965('0x22')](respondWithResult(_0x56ee11,null))['catch'](handleError(_0x56ee11,null));};exports[_0x1965('0x46')]=function(_0x1b999e,_0x205039){return db[_0x1965('0x3c')]['create'](_0x1b999e[_0x1965('0x47')],{})[_0x1965('0x22')](respondWithResult(_0x205039,0xc9))[_0x1965('0x41')](handleError(_0x205039,null));};exports[_0x1965('0x21')]=function(_0x3f66f1,_0x344e60){if(_0x3f66f1['body']['id']){delete _0x3f66f1[_0x1965('0x47')]['id'];}return db[_0x1965('0x3c')][_0x1965('0x45')]({'where':{'id':_0x3f66f1[_0x1965('0x42')]['id']}})[_0x1965('0x22')](handleEntityNotFound(_0x344e60,null))[_0x1965('0x22')](saveUpdates(_0x3f66f1[_0x1965('0x47')],null))[_0x1965('0x22')](respondWithResult(_0x344e60,null))['catch'](handleError(_0x344e60,null));};exports[_0x1965('0x48')]=function(_0x1f9f82,_0x254dec){return db['SquareReport'][_0x1965('0x45')]({'where':{'id':_0x1f9f82[_0x1965('0x42')]['id']}})[_0x1965('0x22')](handleEntityNotFound(_0x254dec,null))['then'](removeEntity(_0x254dec,null))[_0x1965('0x41')](handleError(_0x254dec,null));};exports[_0x1965('0x49')]=function(_0x5e7657,_0x1a9ed3){return db[_0x1965('0x3c')]['describe']()[_0x1965('0x22')](respondWithResult(_0x1a9ed3,null))[_0x1965('0x41')](handleError(_0x1a9ed3,null));};