Built motion from commit 449495f6.|2.6.27
[motion2.git] / server / api / jscriptySessionReport / jscriptySessionReport.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 _0xf30d=['model','query','keys','filters','attributes','intersection','fields','length','hasOwnProperty','order','sort','pick','filter','where','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','create','find','body','getQuestions','findOne','JscriptyQuestionReport','count','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','fs-extra','lodash','crypto','jsforce','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','set','apply','reject','update','then','destroy','stack','name','send','index','map','JscriptySessionReport','rawAttributes','fieldName','type','key'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0xf30d,0x153));var _0xdf30=function(_0x2e5016,_0x5bc3f4){_0x2e5016=_0x2e5016-0x0;var _0x38eeab=_0xf30d[_0x2e5016];return _0x38eeab;};'use strict';var emlformat=require(_0xdf30('0x0'));var rimraf=require(_0xdf30('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xdf30('0x2'));var rp=require(_0xdf30('0x3'));var moment=require(_0xdf30('0x4'));var BPromise=require(_0xdf30('0x5'));var Mustache=require(_0xdf30('0x6'));var util=require(_0xdf30('0x7'));var path=require(_0xdf30('0x8'));var sox=require('sox');var csv=require(_0xdf30('0x9'));var ejs=require(_0xdf30('0xa'));var fs=require('fs');var fs_extra=require(_0xdf30('0xb'));var _=require(_0xdf30('0xc'));var squel=require('squel');var crypto=require(_0xdf30('0xd'));var jsforce=require(_0xdf30('0xe'));var deskjs=require('desk.js');var toCsv=require(_0xdf30('0x9'));var querystring=require(_0xdf30('0xf'));var Papa=require('papaparse');var Redis=require(_0xdf30('0x10'));var authService=require(_0xdf30('0x11'));var qs=require(_0xdf30('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xdf30('0x13'));var utils=require(_0xdf30('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0xdf30('0x15'));var db=require(_0xdf30('0x16'))['db'];function respondWithStatusCode(_0x105940,_0x1d8b28){_0x1d8b28=_0x1d8b28||0xcc;return function(_0x208261){if(_0x208261){return _0x105940[_0xdf30('0x17')](_0x1d8b28);}return _0x105940[_0xdf30('0x18')](_0x1d8b28)[_0xdf30('0x19')]();};}function respondWithResult(_0x189ee5,_0x306975){_0x306975=_0x306975||0xc8;return function(_0x52d2cb){if(_0x52d2cb){return _0x189ee5[_0xdf30('0x18')](_0x306975)[_0xdf30('0x1a')](_0x52d2cb);}};}function respondWithFilteredResult(_0x1ad936,_0x199167){return function(_0x41ad4d){if(_0x41ad4d){var _0x3dc5da=typeof _0x199167[_0xdf30('0x1b')]===_0xdf30('0x1c')&&typeof _0x199167[_0xdf30('0x1d')]==='undefined';var _0x2d09c9=_0x41ad4d['count'];var _0x2baf25=_0x3dc5da?0x0:_0x199167[_0xdf30('0x1b')];var _0x55c213=_0x3dc5da?_0x41ad4d['count']:_0x199167[_0xdf30('0x1b')]+_0x199167[_0xdf30('0x1d')];var _0x45a049;if(_0x55c213>=_0x2d09c9){_0x55c213=_0x2d09c9;_0x45a049=0xc8;}else{_0x45a049=0xce;}_0x1ad936[_0xdf30('0x18')](_0x45a049);return _0x1ad936[_0xdf30('0x1e')]('Content-Range',_0x2baf25+'-'+_0x55c213+'/'+_0x2d09c9)['json'](_0x41ad4d);}return null;};}function patchUpdates(_0x302322){return function(_0x86bf30){try{jsonpatch[_0xdf30('0x1f')](_0x86bf30,_0x302322,!![]);}catch(_0x38dd3d){return BPromise[_0xdf30('0x20')](_0x38dd3d);}return _0x86bf30['save']();};}function saveUpdates(_0x9332f,_0x5e88a9){return function(_0x2558e3){if(_0x2558e3){return _0x2558e3[_0xdf30('0x21')](_0x9332f)[_0xdf30('0x22')](function(_0x18405f){return _0x18405f;});}return null;};}function removeEntity(_0x1abd97,_0x551100){return function(_0x507b73){if(_0x507b73){return _0x507b73[_0xdf30('0x23')]()['then'](function(){_0x1abd97[_0xdf30('0x18')](0xcc)[_0xdf30('0x19')]();});}};}function handleEntityNotFound(_0x1cd2a6,_0x2270bc){return function(_0x36df88){if(!_0x36df88){_0x1cd2a6[_0xdf30('0x17')](0x194);}return _0x36df88;};}function handleError(_0x26e08f,_0xa1c43b){_0xa1c43b=_0xa1c43b||0x1f4;return function(_0x1e7db8){logger['error'](_0x1e7db8[_0xdf30('0x24')]);if(_0x1e7db8[_0xdf30('0x25')]){delete _0x1e7db8[_0xdf30('0x25')];}_0x26e08f[_0xdf30('0x18')](_0xa1c43b)[_0xdf30('0x26')](_0x1e7db8);};}exports[_0xdf30('0x27')]=function(_0x5ac03e,_0x1f6a62){var _0x4b2838={},_0x2d1cec={},_0x4d96c7={'count':0x0,'rows':[]};var _0x5f2444=_[_0xdf30('0x28')](db[_0xdf30('0x29')][_0xdf30('0x2a')],function(_0xa08717){return{'name':_0xa08717[_0xdf30('0x2b')],'type':_0xa08717[_0xdf30('0x2c')][_0xdf30('0x2d')]};});_0x2d1cec[_0xdf30('0x2e')]=_['map'](_0x5f2444,_0xdf30('0x25'));_0x2d1cec[_0xdf30('0x2f')]=_[_0xdf30('0x30')](_0x5ac03e[_0xdf30('0x2f')]);_0x2d1cec[_0xdf30('0x31')]=_['intersection'](_0x2d1cec[_0xdf30('0x2e')],_0x2d1cec[_0xdf30('0x2f')]);_0x4b2838[_0xdf30('0x32')]=_[_0xdf30('0x33')](_0x2d1cec[_0xdf30('0x2e')],qs[_0xdf30('0x34')](_0x5ac03e['query'][_0xdf30('0x34')]));_0x4b2838['attributes']=_0x4b2838['attributes'][_0xdf30('0x35')]?_0x4b2838[_0xdf30('0x32')]:_0x2d1cec['model'];if(!_0x5ac03e[_0xdf30('0x2f')][_0xdf30('0x36')]('nolimit')){_0x4b2838[_0xdf30('0x1d')]=qs['limit'](_0x5ac03e[_0xdf30('0x2f')][_0xdf30('0x1d')]);_0x4b2838[_0xdf30('0x1b')]=qs[_0xdf30('0x1b')](_0x5ac03e[_0xdf30('0x2f')][_0xdf30('0x1b')]);}_0x4b2838[_0xdf30('0x37')]=qs[_0xdf30('0x38')](_0x5ac03e['query'][_0xdf30('0x38')]);_0x4b2838['where']=qs['filters'](_[_0xdf30('0x39')](_0x5ac03e[_0xdf30('0x2f')],_0x2d1cec[_0xdf30('0x31')]),_0x5f2444);if(_0x5ac03e[_0xdf30('0x2f')][_0xdf30('0x3a')]){_0x4b2838[_0xdf30('0x3b')]=_[_0xdf30('0x3c')](_0x4b2838['where'],{'$or':_[_0xdf30('0x28')](_0x5f2444,function(_0xefd5b3){if(_0xefd5b3[_0xdf30('0x2c')]!==_0xdf30('0x3d')){var _0x146a8f={};_0x146a8f[_0xefd5b3[_0xdf30('0x25')]]={'$like':'%'+_0x5ac03e[_0xdf30('0x2f')][_0xdf30('0x3a')]+'%'};return _0x146a8f;}})});}_0x4b2838=_[_0xdf30('0x3c')]({},_0x4b2838,_0x5ac03e[_0xdf30('0x3e')]);var _0x2c5b54={'where':_0x4b2838[_0xdf30('0x3b')]};return db['JscriptySessionReport']['count'](_0x2c5b54)['then'](function(_0x83c4fe){_0x4d96c7['count']=_0x83c4fe;if(_0x5ac03e[_0xdf30('0x2f')][_0xdf30('0x3f')]){_0x4b2838[_0xdf30('0x40')]=[{'all':!![]}];}return db[_0xdf30('0x29')][_0xdf30('0x41')](_0x4b2838);})[_0xdf30('0x22')](function(_0x516040){_0x4d96c7[_0xdf30('0x42')]=_0x516040;return _0x4d96c7;})[_0xdf30('0x22')](respondWithFilteredResult(_0x1f6a62,_0x4b2838))[_0xdf30('0x43')](handleError(_0x1f6a62,null));};exports[_0xdf30('0x44')]=function(_0x2bc7f3,_0x1b2225){var _0x84ec24={'raw':!![],'where':{'id':_0x2bc7f3[_0xdf30('0x45')]['id']}},_0x202f8a={};_0x202f8a['model']=_['keys'](db[_0xdf30('0x29')][_0xdf30('0x2a')]);_0x202f8a[_0xdf30('0x2f')]=_['keys'](_0x2bc7f3[_0xdf30('0x2f')]);_0x202f8a[_0xdf30('0x31')]=_[_0xdf30('0x33')](_0x202f8a[_0xdf30('0x2e')],_0x202f8a[_0xdf30('0x2f')]);_0x84ec24[_0xdf30('0x32')]=_[_0xdf30('0x33')](_0x202f8a[_0xdf30('0x2e')],qs[_0xdf30('0x34')](_0x2bc7f3[_0xdf30('0x2f')][_0xdf30('0x34')]));_0x84ec24[_0xdf30('0x32')]=_0x84ec24[_0xdf30('0x32')]['length']?_0x84ec24[_0xdf30('0x32')]:_0x202f8a['model'];if(_0x2bc7f3['query'][_0xdf30('0x3f')]){_0x84ec24[_0xdf30('0x40')]=[{'all':!![]}];}_0x84ec24=_[_0xdf30('0x3c')]({},_0x84ec24,_0x2bc7f3[_0xdf30('0x3e')]);return db[_0xdf30('0x29')]['find'](_0x84ec24)[_0xdf30('0x22')](handleEntityNotFound(_0x1b2225,null))[_0xdf30('0x22')](respondWithResult(_0x1b2225,null))[_0xdf30('0x43')](handleError(_0x1b2225,null));};exports[_0xdf30('0x46')]=function(_0x1a9fc0,_0x5dfea1){return db[_0xdf30('0x29')][_0xdf30('0x46')](_0x1a9fc0['body'],{})[_0xdf30('0x22')](respondWithResult(_0x5dfea1,0xc9))[_0xdf30('0x43')](handleError(_0x5dfea1,null));};exports[_0xdf30('0x21')]=function(_0x230776,_0x1b971e){if(_0x230776['body']['id']){delete _0x230776['body']['id'];}return db[_0xdf30('0x29')][_0xdf30('0x47')]({'where':{'id':_0x230776[_0xdf30('0x45')]['id']}})['then'](handleEntityNotFound(_0x1b971e,null))['then'](saveUpdates(_0x230776[_0xdf30('0x48')],null))[_0xdf30('0x22')](respondWithResult(_0x1b971e,null))[_0xdf30('0x43')](handleError(_0x1b971e,null));};exports['destroy']=function(_0x21fed5,_0x213883){return db[_0xdf30('0x29')][_0xdf30('0x47')]({'where':{'id':_0x21fed5['params']['id']}})[_0xdf30('0x22')](handleEntityNotFound(_0x213883,null))[_0xdf30('0x22')](removeEntity(_0x213883,null))['catch'](handleError(_0x213883,null));};exports['describe']=function(_0x24adf9,_0x2b5e36){return db['JscriptySessionReport']['describe']()[_0xdf30('0x22')](respondWithResult(_0x2b5e36,null))['catch'](handleError(_0x2b5e36,null));};exports[_0xdf30('0x49')]=function(_0xa8892a,_0x3a3b4f,_0x2c3027){var _0x406eca={'raw':!![],'where':{}};var _0x353246={};var _0xbf1fd7={'count':0x0,'rows':[]};return db[_0xdf30('0x29')][_0xdf30('0x4a')]({'where':{'id':_0xa8892a[_0xdf30('0x45')]['id']}})['then'](handleEntityNotFound(_0x3a3b4f,null))[_0xdf30('0x22')](function(_0x4824b6){if(_0x4824b6){_0x353246['model']=_[_0xdf30('0x30')](db[_0xdf30('0x4b')][_0xdf30('0x2a')]);_0x353246['query']=_[_0xdf30('0x30')](_0xa8892a[_0xdf30('0x2f')]);_0x353246[_0xdf30('0x31')]=_[_0xdf30('0x33')](_0x353246[_0xdf30('0x2e')],_0x353246['query']);_0x406eca[_0xdf30('0x32')]=_[_0xdf30('0x33')](_0x353246[_0xdf30('0x2e')],qs[_0xdf30('0x34')](_0xa8892a[_0xdf30('0x2f')][_0xdf30('0x34')]));_0x406eca[_0xdf30('0x32')]=_0x406eca['attributes']['length']?_0x406eca[_0xdf30('0x32')]:_0x353246[_0xdf30('0x2e')];if(!_0xa8892a['query']['hasOwnProperty']('nolimit')){_0x406eca[_0xdf30('0x1d')]=qs[_0xdf30('0x1d')](_0xa8892a[_0xdf30('0x2f')][_0xdf30('0x1d')]);_0x406eca[_0xdf30('0x1b')]=qs['offset'](_0xa8892a[_0xdf30('0x2f')][_0xdf30('0x1b')]);}_0x406eca[_0xdf30('0x37')]=qs[_0xdf30('0x38')](_0xa8892a[_0xdf30('0x2f')]['sort']);_0x406eca[_0xdf30('0x3b')]=qs['filters'](_[_0xdf30('0x39')](_0xa8892a['query'],_0x353246[_0xdf30('0x31')]));_0x406eca['where']['SessionId']=_0x4824b6['id'];if(_0xa8892a['query']['filter']){_0x406eca[_0xdf30('0x3b')]=_[_0xdf30('0x3c')](_0x406eca[_0xdf30('0x3b')],{'$or':_['map'](_0x406eca[_0xdf30('0x32')],function(_0x2bc5bc){var _0xe4c56a={};_0xe4c56a[_0x2bc5bc]={'$like':'%'+_0xa8892a['query']['filter']+'%'};return _0xe4c56a;})});}_0x406eca=_[_0xdf30('0x3c')]({},_0x406eca,_0xa8892a[_0xdf30('0x3e')]);return db[_0xdf30('0x4b')][_0xdf30('0x4c')]({'where':_0x406eca[_0xdf30('0x3b')]})[_0xdf30('0x22')](function(_0x536ea3){_0xbf1fd7['count']=_0x536ea3;if(_0xa8892a[_0xdf30('0x2f')][_0xdf30('0x3f')]){_0x406eca[_0xdf30('0x40')]=[{'all':!![]}];}return db[_0xdf30('0x4b')]['findAll'](_0x406eca);})[_0xdf30('0x22')](function(_0x490762){_0xbf1fd7[_0xdf30('0x42')]=_0x490762;return _0xbf1fd7;});}})[_0xdf30('0x22')](respondWithFilteredResult(_0x3a3b4f,_0x406eca))[_0xdf30('0x43')](handleError(_0x3a3b4f,null));};