server/api/chatQueueReport/chatQueueReport.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 _0xe225=['length','hasOwnProperty','nolimit','order','sort','where','filter','merge','type','options','ChatQueueReport','includeAll','include','catch','show','params','find','create','body','rimraf','zip-dir','bluebird','util','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','reject','save','update','then','destroy','error','stack','name','send','index','map','rawAttributes','key','model','query','keys','filters','intersection','fields','attributes'];(function(_0x3ab3ce,_0x5e3960){var _0x2021e1=function(_0x375b64){while(--_0x375b64){_0x3ab3ce['push'](_0x3ab3ce['shift']());}};_0x2021e1(++_0x5e3960);}(_0xe225,0x1bd));var _0x5e22=function(_0x22ada8,_0x23a7ea){_0x22ada8=_0x22ada8-0x0;var _0x506e36=_0xe225[_0x22ada8];return _0x506e36;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x5e22('0x0'));var zipdir=require(_0x5e22('0x1'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x5e22('0x2'));var Mustache=require('mustache');var util=require(_0x5e22('0x3'));var path=require('path');var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x5e22('0x4'));var fs=require('fs');var fs_extra=require(_0x5e22('0x5'));var _=require(_0x5e22('0x6'));var squel=require(_0x5e22('0x7'));var crypto=require(_0x5e22('0x8'));var jsforce=require(_0x5e22('0x9'));var deskjs=require(_0x5e22('0xa'));var toCsv=require(_0x5e22('0xb'));var querystring=require(_0x5e22('0xc'));var Papa=require(_0x5e22('0xd'));var Redis=require(_0x5e22('0xe'));var authService=require(_0x5e22('0xf'));var qs=require('../../components/parsers/qs');var as=require(_0x5e22('0x10'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x5e22('0x11'))(_0x5e22('0x12'));var utils=require(_0x5e22('0x13'));var config=require(_0x5e22('0x14'));var licenseUtil=require('../../config/license/util');var db=require(_0x5e22('0x15'))['db'];function respondWithStatusCode(_0x5e8b51,_0x3f96be){_0x3f96be=_0x3f96be||0xcc;return function(_0x3dd24c){if(_0x3dd24c){return _0x5e8b51[_0x5e22('0x16')](_0x3f96be);}return _0x5e8b51[_0x5e22('0x17')](_0x3f96be)[_0x5e22('0x18')]();};}function respondWithResult(_0x598d29,_0x1eb276){_0x1eb276=_0x1eb276||0xc8;return function(_0x4795ae){if(_0x4795ae){return _0x598d29[_0x5e22('0x17')](_0x1eb276)[_0x5e22('0x19')](_0x4795ae);}};}function respondWithFilteredResult(_0x1e9eff,_0xbae23a){return function(_0x34de3d){if(_0x34de3d){var _0x32bce1=typeof _0xbae23a[_0x5e22('0x1a')]===_0x5e22('0x1b')&&typeof _0xbae23a[_0x5e22('0x1c')]===_0x5e22('0x1b');var _0x1c4b6c=_0x34de3d['count'];var _0x545723=_0x32bce1?0x0:_0xbae23a[_0x5e22('0x1a')];var _0x48c441=_0x32bce1?_0x34de3d[_0x5e22('0x1d')]:_0xbae23a[_0x5e22('0x1a')]+_0xbae23a[_0x5e22('0x1c')];var _0xe3ed1e;if(_0x48c441>=_0x1c4b6c){_0x48c441=_0x1c4b6c;_0xe3ed1e=0xc8;}else{_0xe3ed1e=0xce;}_0x1e9eff[_0x5e22('0x17')](_0xe3ed1e);return _0x1e9eff[_0x5e22('0x1e')](_0x5e22('0x1f'),_0x545723+'-'+_0x48c441+'/'+_0x1c4b6c)[_0x5e22('0x19')](_0x34de3d);}return null;};}function patchUpdates(_0x280988){return function(_0x26509c){try{jsonpatch['apply'](_0x26509c,_0x280988,!![]);}catch(_0x193a42){return BPromise[_0x5e22('0x20')](_0x193a42);}return _0x26509c[_0x5e22('0x21')]();};}function saveUpdates(_0x303f19,_0x1b5d41){return function(_0x310978){if(_0x310978){return _0x310978[_0x5e22('0x22')](_0x303f19)[_0x5e22('0x23')](function(_0x29f733){return _0x29f733;});}return null;};}function removeEntity(_0x495a17,_0x2a5411){return function(_0x5d0a07){if(_0x5d0a07){return _0x5d0a07[_0x5e22('0x24')]()[_0x5e22('0x23')](function(){_0x495a17[_0x5e22('0x17')](0xcc)[_0x5e22('0x18')]();});}};}function handleEntityNotFound(_0x1f0b7d,_0x3564d2){return function(_0x482825){if(!_0x482825){_0x1f0b7d[_0x5e22('0x16')](0x194);}return _0x482825;};}function handleError(_0x8c7950,_0x38b414){_0x38b414=_0x38b414||0x1f4;return function(_0xf7c5e6){logger[_0x5e22('0x25')](_0xf7c5e6[_0x5e22('0x26')]);if(_0xf7c5e6[_0x5e22('0x27')]){delete _0xf7c5e6['name'];}_0x8c7950['status'](_0x38b414)[_0x5e22('0x28')](_0xf7c5e6);};}exports[_0x5e22('0x29')]=function(_0x3c0561,_0x53d5d5){var _0x1a0bb7={},_0x5a4ad1={},_0x50d048={'count':0x0,'rows':[]};var _0x3bd85d=_[_0x5e22('0x2a')](db['ChatQueueReport'][_0x5e22('0x2b')],function(_0x537574){return{'name':_0x537574['fieldName'],'type':_0x537574['type'][_0x5e22('0x2c')]};});_0x5a4ad1[_0x5e22('0x2d')]=_[_0x5e22('0x2a')](_0x3bd85d,'name');_0x5a4ad1[_0x5e22('0x2e')]=_[_0x5e22('0x2f')](_0x3c0561[_0x5e22('0x2e')]);_0x5a4ad1[_0x5e22('0x30')]=_[_0x5e22('0x31')](_0x5a4ad1[_0x5e22('0x2d')],_0x5a4ad1[_0x5e22('0x2e')]);_0x1a0bb7['attributes']=_[_0x5e22('0x31')](_0x5a4ad1[_0x5e22('0x2d')],qs[_0x5e22('0x32')](_0x3c0561[_0x5e22('0x2e')][_0x5e22('0x32')]));_0x1a0bb7[_0x5e22('0x33')]=_0x1a0bb7[_0x5e22('0x33')][_0x5e22('0x34')]?_0x1a0bb7[_0x5e22('0x33')]:_0x5a4ad1['model'];if(!_0x3c0561[_0x5e22('0x2e')][_0x5e22('0x35')](_0x5e22('0x36'))){_0x1a0bb7[_0x5e22('0x1c')]=qs[_0x5e22('0x1c')](_0x3c0561[_0x5e22('0x2e')][_0x5e22('0x1c')]);_0x1a0bb7[_0x5e22('0x1a')]=qs[_0x5e22('0x1a')](_0x3c0561['query'][_0x5e22('0x1a')]);}_0x1a0bb7[_0x5e22('0x37')]=qs[_0x5e22('0x38')](_0x3c0561['query'][_0x5e22('0x38')]);_0x1a0bb7[_0x5e22('0x39')]=qs['filters'](_['pick'](_0x3c0561[_0x5e22('0x2e')],_0x5a4ad1[_0x5e22('0x30')]),_0x3bd85d);if(_0x3c0561[_0x5e22('0x2e')][_0x5e22('0x3a')]){_0x1a0bb7[_0x5e22('0x39')]=_[_0x5e22('0x3b')](_0x1a0bb7['where'],{'$or':_['map'](_0x3bd85d,function(_0x583ebd){if(_0x583ebd[_0x5e22('0x3c')]!=='VIRTUAL'){var _0x33b83a={};_0x33b83a[_0x583ebd[_0x5e22('0x27')]]={'$like':'%'+_0x3c0561['query'][_0x5e22('0x3a')]+'%'};return _0x33b83a;}})});}_0x1a0bb7=_['merge']({},_0x1a0bb7,_0x3c0561[_0x5e22('0x3d')]);var _0x21f509={'where':_0x1a0bb7['where']};return db[_0x5e22('0x3e')][_0x5e22('0x1d')](_0x21f509)[_0x5e22('0x23')](function(_0x30a88f){_0x50d048['count']=_0x30a88f;if(_0x3c0561['query'][_0x5e22('0x3f')]){_0x1a0bb7[_0x5e22('0x40')]=[{'all':!![]}];}return db[_0x5e22('0x3e')]['findAll'](_0x1a0bb7);})[_0x5e22('0x23')](function(_0x4feb13){_0x50d048['rows']=_0x4feb13;return _0x50d048;})['then'](respondWithFilteredResult(_0x53d5d5,_0x1a0bb7))[_0x5e22('0x41')](handleError(_0x53d5d5,null));};exports[_0x5e22('0x42')]=function(_0x16e361,_0x235b65){var _0x536d73={'raw':!![],'where':{'id':_0x16e361[_0x5e22('0x43')]['id']}},_0x59c399={};_0x59c399[_0x5e22('0x2d')]=_[_0x5e22('0x2f')](db['ChatQueueReport'][_0x5e22('0x2b')]);_0x59c399[_0x5e22('0x2e')]=_[_0x5e22('0x2f')](_0x16e361[_0x5e22('0x2e')]);_0x59c399['filters']=_[_0x5e22('0x31')](_0x59c399[_0x5e22('0x2d')],_0x59c399['query']);_0x536d73['attributes']=_[_0x5e22('0x31')](_0x59c399['model'],qs[_0x5e22('0x32')](_0x16e361['query'][_0x5e22('0x32')]));_0x536d73[_0x5e22('0x33')]=_0x536d73[_0x5e22('0x33')]['length']?_0x536d73[_0x5e22('0x33')]:_0x59c399['model'];if(_0x16e361[_0x5e22('0x2e')][_0x5e22('0x3f')]){_0x536d73['include']=[{'all':!![]}];}_0x536d73=_['merge']({},_0x536d73,_0x16e361[_0x5e22('0x3d')]);return db[_0x5e22('0x3e')][_0x5e22('0x44')](_0x536d73)['then'](handleEntityNotFound(_0x235b65,null))[_0x5e22('0x23')](respondWithResult(_0x235b65,null))[_0x5e22('0x41')](handleError(_0x235b65,null));};exports[_0x5e22('0x45')]=function(_0x23f854,_0x45ad69){return db[_0x5e22('0x3e')][_0x5e22('0x45')](_0x23f854['body'],{})[_0x5e22('0x23')](respondWithResult(_0x45ad69,0xc9))[_0x5e22('0x41')](handleError(_0x45ad69,null));};exports['update']=function(_0x3cb7de,_0x5e7a90){if(_0x3cb7de[_0x5e22('0x46')]['id']){delete _0x3cb7de[_0x5e22('0x46')]['id'];}return db['ChatQueueReport'][_0x5e22('0x44')]({'where':{'id':_0x3cb7de[_0x5e22('0x43')]['id']}})[_0x5e22('0x23')](handleEntityNotFound(_0x5e7a90,null))[_0x5e22('0x23')](saveUpdates(_0x3cb7de[_0x5e22('0x46')],null))[_0x5e22('0x23')](respondWithResult(_0x5e7a90,null))[_0x5e22('0x41')](handleError(_0x5e7a90,null));};exports[_0x5e22('0x24')]=function(_0xe75dc,_0xf755c9){return db['ChatQueueReport'][_0x5e22('0x44')]({'where':{'id':_0xe75dc[_0x5e22('0x43')]['id']}})[_0x5e22('0x23')](handleEntityNotFound(_0xf755c9,null))[_0x5e22('0x23')](removeEntity(_0xf755c9,null))[_0x5e22('0x41')](handleError(_0xf755c9,null));};exports['describe']=function(_0x3c1f59,_0x16c8b3){return db['ChatQueueReport']['describe']()[_0x5e22('0x23')](respondWithResult(_0x16c8b3,null))[_0x5e22('0x41')](handleError(_0x16c8b3,null));};