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 _0x73f1=['includeAll','find','create','body','params','describe','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','count','offset','set','Content-Range','apply','reject','update','then','destroy','stack','name','send','index','map','type','key','model','query','keys','intersection','attributes','fields','length','hasOwnProperty','limit','sort','where','filters','pick','filter','merge','VIRTUAL','options','SquareReport','include','findAll','rows','catch','show','rawAttributes'];(function(_0x8e100e,_0x207dc3){var _0x21cdba=function(_0x253188){while(--_0x253188){_0x8e100e['push'](_0x8e100e['shift']());}};_0x21cdba(++_0x207dc3);}(_0x73f1,0xe7));var _0x173f=function(_0x3b21e1,_0x116f8e){_0x3b21e1=_0x3b21e1-0x0;var _0x4ea4af=_0x73f1[_0x3b21e1];return _0x4ea4af;};'use strict';var pdf=require(_0x173f('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x173f('0x1'));var zipdir=require(_0x173f('0x2'));var jsonpatch=require(_0x173f('0x3'));var rp=require(_0x173f('0x4'));var moment=require(_0x173f('0x5'));var BPromise=require(_0x173f('0x6'));var Mustache=require('mustache');var util=require(_0x173f('0x7'));var path=require(_0x173f('0x8'));var sox=require(_0x173f('0x9'));var csv=require(_0x173f('0xa'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x173f('0xb'));var squel=require(_0x173f('0xc'));var crypto=require(_0x173f('0xd'));var jsforce=require(_0x173f('0xe'));var deskjs=require(_0x173f('0xf'));var toCsv=require(_0x173f('0xa'));var querystring=require(_0x173f('0x10'));var Papa=require(_0x173f('0x11'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x173f('0x12'));var hardwareService=require(_0x173f('0x13'));var logger=require(_0x173f('0x14'))(_0x173f('0x15'));var utils=require(_0x173f('0x16'));var config=require(_0x173f('0x17'));var db=require(_0x173f('0x18'))['db'];function respondWithStatusCode(_0xb55967,_0x5c8f09){_0x5c8f09=_0x5c8f09||0xcc;return function(_0xed85bf){if(_0xed85bf){return _0xb55967[_0x173f('0x19')](_0x5c8f09);}return _0xb55967[_0x173f('0x1a')](_0x5c8f09)[_0x173f('0x1b')]();};}function respondWithResult(_0x15cbff,_0x5ccd74){_0x5ccd74=_0x5ccd74||0xc8;return function(_0x580b44){if(_0x580b44){return _0x15cbff[_0x173f('0x1a')](_0x5ccd74)[_0x173f('0x1c')](_0x580b44);}};}function respondWithFilteredResult(_0x12b74c,_0x52f9ca){return function(_0x154dd1){if(_0x154dd1){var _0xced7e2=_0x154dd1[_0x173f('0x1d')],_0x298dc2=_0x52f9ca[_0x173f('0x1e')],_0x33608d=_0x52f9ca[_0x173f('0x1e')]+_0x52f9ca['limit'],_0x203631;if(_0x33608d>=_0xced7e2){_0x33608d=_0xced7e2;_0x203631=0xc8;}else{_0x203631=0xce;}_0x12b74c[_0x173f('0x1a')](_0x203631);return _0x12b74c[_0x173f('0x1f')](_0x173f('0x20'),_0x298dc2+'-'+_0x33608d+'/'+_0xced7e2)[_0x173f('0x1c')](_0x154dd1);}return null;};}function patchUpdates(_0x402b76){return function(_0xffbea9){try{jsonpatch[_0x173f('0x21')](_0xffbea9,_0x402b76,!![]);}catch(_0x171fce){return BPromise[_0x173f('0x22')](_0x171fce);}return _0xffbea9['save']();};}function saveUpdates(_0x11c266,_0x17f92a){return function(_0x44bb31){if(_0x44bb31){return _0x44bb31[_0x173f('0x23')](_0x11c266)[_0x173f('0x24')](function(_0x496578){return _0x496578;});}return null;};}function removeEntity(_0x5232a6,_0x4b19d4){return function(_0x4bd0ad){if(_0x4bd0ad){return _0x4bd0ad[_0x173f('0x25')]()[_0x173f('0x24')](function(){_0x5232a6[_0x173f('0x1a')](0xcc)['end']();});}};}function handleEntityNotFound(_0x4ffd7e,_0x398d98){return function(_0x220f68){if(!_0x220f68){_0x4ffd7e['sendStatus'](0x194);}return _0x220f68;};}function handleError(_0x538b30,_0x4ce575){_0x4ce575=_0x4ce575||0x1f4;return function(_0x562539){logger['error'](_0x562539[_0x173f('0x26')]);if(_0x562539[_0x173f('0x27')]){delete _0x562539[_0x173f('0x27')];}_0x538b30[_0x173f('0x1a')](_0x4ce575)[_0x173f('0x28')](_0x562539);};}exports[_0x173f('0x29')]=function(_0x445ca9,_0x25b15b){var _0x4cdcb8={},_0x4bb406={},_0xb76718={'count':0x0,'rows':[]};var _0x3836e6=_[_0x173f('0x2a')](db['SquareReport']['rawAttributes'],function(_0x15bbc9){return{'name':_0x15bbc9['fieldName'],'type':_0x15bbc9[_0x173f('0x2b')][_0x173f('0x2c')]};});_0x4bb406[_0x173f('0x2d')]=_[_0x173f('0x2a')](_0x3836e6,_0x173f('0x27'));_0x4bb406[_0x173f('0x2e')]=_[_0x173f('0x2f')](_0x445ca9[_0x173f('0x2e')]);_0x4bb406['filters']=_[_0x173f('0x30')](_0x4bb406[_0x173f('0x2d')],_0x4bb406[_0x173f('0x2e')]);_0x4cdcb8[_0x173f('0x31')]=_[_0x173f('0x30')](_0x4bb406['model'],qs[_0x173f('0x32')](_0x445ca9[_0x173f('0x2e')][_0x173f('0x32')]));_0x4cdcb8[_0x173f('0x31')]=_0x4cdcb8[_0x173f('0x31')][_0x173f('0x33')]?_0x4cdcb8[_0x173f('0x31')]:_0x4bb406[_0x173f('0x2d')];if(!_0x445ca9['query'][_0x173f('0x34')]('nolimit')){_0x4cdcb8['limit']=qs[_0x173f('0x35')](_0x445ca9['query']['limit']);_0x4cdcb8[_0x173f('0x1e')]=qs[_0x173f('0x1e')](_0x445ca9[_0x173f('0x2e')][_0x173f('0x1e')]);}_0x4cdcb8['order']=qs[_0x173f('0x36')](_0x445ca9[_0x173f('0x2e')][_0x173f('0x36')]);_0x4cdcb8[_0x173f('0x37')]=qs[_0x173f('0x38')](_[_0x173f('0x39')](_0x445ca9[_0x173f('0x2e')],_0x4bb406[_0x173f('0x38')]),_0x3836e6);if(_0x445ca9[_0x173f('0x2e')][_0x173f('0x3a')]){_0x4cdcb8[_0x173f('0x37')]=_[_0x173f('0x3b')](_0x4cdcb8['where'],{'$or':_[_0x173f('0x2a')](_0x3836e6,function(_0x46889b){if(_0x46889b['type']!==_0x173f('0x3c')){var _0x3d34af={};_0x3d34af[_0x46889b[_0x173f('0x27')]]={'$like':'%'+_0x445ca9[_0x173f('0x2e')][_0x173f('0x3a')]+'%'};return _0x3d34af;}})});}_0x4cdcb8=_[_0x173f('0x3b')]({},_0x4cdcb8,_0x445ca9[_0x173f('0x3d')]);var _0x30a509={'where':_0x4cdcb8[_0x173f('0x37')]};return db[_0x173f('0x3e')][_0x173f('0x1d')](_0x30a509)[_0x173f('0x24')](function(_0x4d74a0){_0xb76718['count']=_0x4d74a0;if(_0x445ca9['query']['includeAll']){_0x4cdcb8[_0x173f('0x3f')]=[{'all':!![]}];}return db['SquareReport'][_0x173f('0x40')](_0x4cdcb8);})[_0x173f('0x24')](function(_0x456e0c){_0xb76718[_0x173f('0x41')]=_0x456e0c;return _0xb76718;})[_0x173f('0x24')](respondWithFilteredResult(_0x25b15b,_0x4cdcb8))[_0x173f('0x42')](handleError(_0x25b15b,null));};exports[_0x173f('0x43')]=function(_0x4298f4,_0x10499e){var _0x1153ec={'raw':!![],'where':{'id':_0x4298f4['params']['id']}},_0x359179={};_0x359179[_0x173f('0x2d')]=_[_0x173f('0x2f')](db[_0x173f('0x3e')][_0x173f('0x44')]);_0x359179[_0x173f('0x2e')]=_[_0x173f('0x2f')](_0x4298f4[_0x173f('0x2e')]);_0x359179[_0x173f('0x38')]=_['intersection'](_0x359179[_0x173f('0x2d')],_0x359179[_0x173f('0x2e')]);_0x1153ec[_0x173f('0x31')]=_[_0x173f('0x30')](_0x359179[_0x173f('0x2d')],qs[_0x173f('0x32')](_0x4298f4['query'][_0x173f('0x32')]));_0x1153ec['attributes']=_0x1153ec[_0x173f('0x31')][_0x173f('0x33')]?_0x1153ec['attributes']:_0x359179[_0x173f('0x2d')];if(_0x4298f4[_0x173f('0x2e')][_0x173f('0x45')]){_0x1153ec['include']=[{'all':!![]}];}_0x1153ec=_[_0x173f('0x3b')]({},_0x1153ec,_0x4298f4[_0x173f('0x3d')]);return db[_0x173f('0x3e')][_0x173f('0x46')](_0x1153ec)[_0x173f('0x24')](handleEntityNotFound(_0x10499e,null))[_0x173f('0x24')](respondWithResult(_0x10499e,null))[_0x173f('0x42')](handleError(_0x10499e,null));};exports[_0x173f('0x47')]=function(_0x8a7d74,_0x17113e){return db['SquareReport'][_0x173f('0x47')](_0x8a7d74[_0x173f('0x48')],{})['then'](respondWithResult(_0x17113e,0xc9))[_0x173f('0x42')](handleError(_0x17113e,null));};exports[_0x173f('0x23')]=function(_0x2389ba,_0x1acbae){if(_0x2389ba[_0x173f('0x48')]['id']){delete _0x2389ba[_0x173f('0x48')]['id'];}return db[_0x173f('0x3e')][_0x173f('0x46')]({'where':{'id':_0x2389ba[_0x173f('0x49')]['id']}})['then'](handleEntityNotFound(_0x1acbae,null))[_0x173f('0x24')](saveUpdates(_0x2389ba[_0x173f('0x48')],null))[_0x173f('0x24')](respondWithResult(_0x1acbae,null))['catch'](handleError(_0x1acbae,null));};exports[_0x173f('0x25')]=function(_0x1e7690,_0x2fc0d0){return db['SquareReport'][_0x173f('0x46')]({'where':{'id':_0x1e7690['params']['id']}})[_0x173f('0x24')](handleEntityNotFound(_0x2fc0d0,null))[_0x173f('0x24')](removeEntity(_0x2fc0d0,null))[_0x173f('0x42')](handleError(_0x2fc0d0,null));};exports[_0x173f('0x4a')]=function(_0x4336b4,_0x3314d8){return db['SquareReport'][_0x173f('0x4a')]()[_0x173f('0x24')](respondWithResult(_0x3314d8,null))[_0x173f('0x42')](handleError(_0x3314d8,null));};