0fda3b559ebfe63e4916a6bdeafe5ba829f4b89b
[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 _0xccf0=['VIRTUAL','merge','count','includeAll','include','findAll','catch','show','params','length','create','body','find','describe','JscriptyQuestionReport','rawAttributes','pick','SessionId','options','rows','eml-format','zip-dir','fast-json-patch','moment','path','sox','to-csv','ejs','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','set','Content-Range','apply','save','then','destroy','error','name','index','map','JscriptySessionReport','fieldName','type','key','model','query','keys','filters','attributes','intersection','fields','hasOwnProperty','nolimit','order','sort','where','filter'];(function(_0x3b5250,_0x7a0b2c){var _0xc844a1=function(_0x2fbc98){while(--_0x2fbc98){_0x3b5250['push'](_0x3b5250['shift']());}};_0xc844a1(++_0x7a0b2c);}(_0xccf0,0xb0));var _0x0ccf=function(_0x3a0328,_0x4b819f){_0x3a0328=_0x3a0328-0x0;var _0x119523=_0xccf0[_0x3a0328];return _0x119523;};'use strict';var emlformat=require(_0x0ccf('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x0ccf('0x1'));var jsonpatch=require(_0x0ccf('0x2'));var rp=require('request-promise');var moment=require(_0x0ccf('0x3'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require('util');var path=require(_0x0ccf('0x4'));var sox=require(_0x0ccf('0x5'));var csv=require(_0x0ccf('0x6'));var ejs=require(_0x0ccf('0x7'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x0ccf('0x8'));var squel=require('squel');var crypto=require(_0x0ccf('0x9'));var jsforce=require(_0x0ccf('0xa'));var deskjs=require(_0x0ccf('0xb'));var toCsv=require(_0x0ccf('0x6'));var querystring=require(_0x0ccf('0xc'));var Papa=require(_0x0ccf('0xd'));var Redis=require(_0x0ccf('0xe'));var authService=require(_0x0ccf('0xf'));var qs=require(_0x0ccf('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x0ccf('0x11'));var logger=require(_0x0ccf('0x12'))(_0x0ccf('0x13'));var utils=require(_0x0ccf('0x14'));var config=require(_0x0ccf('0x15'));var licenseUtil=require(_0x0ccf('0x16'));var db=require(_0x0ccf('0x17'))['db'];function respondWithStatusCode(_0x253f3b,_0xa2201b){_0xa2201b=_0xa2201b||0xcc;return function(_0xf766b7){if(_0xf766b7){return _0x253f3b[_0x0ccf('0x18')](_0xa2201b);}return _0x253f3b[_0x0ccf('0x19')](_0xa2201b)[_0x0ccf('0x1a')]();};}function respondWithResult(_0x289019,_0x163dae){_0x163dae=_0x163dae||0xc8;return function(_0x17807c){if(_0x17807c){return _0x289019['status'](_0x163dae)[_0x0ccf('0x1b')](_0x17807c);}};}function respondWithFilteredResult(_0x1398e4,_0x2a331c){return function(_0xc939c5){if(_0xc939c5){var _0x181833=typeof _0x2a331c[_0x0ccf('0x1c')]===_0x0ccf('0x1d')&&typeof _0x2a331c[_0x0ccf('0x1e')]===_0x0ccf('0x1d');var _0x1e68d8=_0xc939c5['count'];var _0x3a33de=_0x181833?0x0:_0x2a331c[_0x0ccf('0x1c')];var _0x4dcad9=_0x181833?_0xc939c5['count']:_0x2a331c['offset']+_0x2a331c['limit'];var _0x17a387;if(_0x4dcad9>=_0x1e68d8){_0x4dcad9=_0x1e68d8;_0x17a387=0xc8;}else{_0x17a387=0xce;}_0x1398e4[_0x0ccf('0x19')](_0x17a387);return _0x1398e4[_0x0ccf('0x1f')](_0x0ccf('0x20'),_0x3a33de+'-'+_0x4dcad9+'/'+_0x1e68d8)[_0x0ccf('0x1b')](_0xc939c5);}return null;};}function patchUpdates(_0x4c4555){return function(_0x14d1d2){try{jsonpatch[_0x0ccf('0x21')](_0x14d1d2,_0x4c4555,!![]);}catch(_0x3bfdd4){return BPromise['reject'](_0x3bfdd4);}return _0x14d1d2[_0x0ccf('0x22')]();};}function saveUpdates(_0x250e42,_0x41dc51){return function(_0x82933f){if(_0x82933f){return _0x82933f['update'](_0x250e42)[_0x0ccf('0x23')](function(_0x57a393){return _0x57a393;});}return null;};}function removeEntity(_0x590d9a,_0x2a06d6){return function(_0xb57fb2){if(_0xb57fb2){return _0xb57fb2[_0x0ccf('0x24')]()[_0x0ccf('0x23')](function(){_0x590d9a[_0x0ccf('0x19')](0xcc)[_0x0ccf('0x1a')]();});}};}function handleEntityNotFound(_0x3a575e,_0x41e6a3){return function(_0x17660f){if(!_0x17660f){_0x3a575e[_0x0ccf('0x18')](0x194);}return _0x17660f;};}function handleError(_0x110d49,_0x4365dc){_0x4365dc=_0x4365dc||0x1f4;return function(_0x3a8846){logger[_0x0ccf('0x25')](_0x3a8846['stack']);if(_0x3a8846[_0x0ccf('0x26')]){delete _0x3a8846[_0x0ccf('0x26')];}_0x110d49['status'](_0x4365dc)['send'](_0x3a8846);};}exports[_0x0ccf('0x27')]=function(_0xd384d0,_0x4ec21c){var _0x39a96f={},_0x3b5099={},_0x5d0d67={'count':0x0,'rows':[]};var _0x125794=_[_0x0ccf('0x28')](db[_0x0ccf('0x29')]['rawAttributes'],function(_0x321549){return{'name':_0x321549[_0x0ccf('0x2a')],'type':_0x321549[_0x0ccf('0x2b')][_0x0ccf('0x2c')]};});_0x3b5099[_0x0ccf('0x2d')]=_[_0x0ccf('0x28')](_0x125794,'name');_0x3b5099[_0x0ccf('0x2e')]=_[_0x0ccf('0x2f')](_0xd384d0[_0x0ccf('0x2e')]);_0x3b5099[_0x0ccf('0x30')]=_['intersection'](_0x3b5099[_0x0ccf('0x2d')],_0x3b5099[_0x0ccf('0x2e')]);_0x39a96f[_0x0ccf('0x31')]=_[_0x0ccf('0x32')](_0x3b5099[_0x0ccf('0x2d')],qs[_0x0ccf('0x33')](_0xd384d0[_0x0ccf('0x2e')][_0x0ccf('0x33')]));_0x39a96f[_0x0ccf('0x31')]=_0x39a96f['attributes']['length']?_0x39a96f[_0x0ccf('0x31')]:_0x3b5099[_0x0ccf('0x2d')];if(!_0xd384d0['query'][_0x0ccf('0x34')](_0x0ccf('0x35'))){_0x39a96f[_0x0ccf('0x1e')]=qs[_0x0ccf('0x1e')](_0xd384d0[_0x0ccf('0x2e')]['limit']);_0x39a96f[_0x0ccf('0x1c')]=qs[_0x0ccf('0x1c')](_0xd384d0[_0x0ccf('0x2e')]['offset']);}_0x39a96f[_0x0ccf('0x36')]=qs[_0x0ccf('0x37')](_0xd384d0['query']['sort']);_0x39a96f[_0x0ccf('0x38')]=qs['filters'](_['pick'](_0xd384d0[_0x0ccf('0x2e')],_0x3b5099[_0x0ccf('0x30')]),_0x125794);if(_0xd384d0['query'][_0x0ccf('0x39')]){_0x39a96f[_0x0ccf('0x38')]=_['merge'](_0x39a96f['where'],{'$or':_['map'](_0x125794,function(_0x1f28c8){if(_0x1f28c8[_0x0ccf('0x2b')]!==_0x0ccf('0x3a')){var _0x30139d={};_0x30139d[_0x1f28c8[_0x0ccf('0x26')]]={'$like':'%'+_0xd384d0[_0x0ccf('0x2e')]['filter']+'%'};return _0x30139d;}})});}_0x39a96f=_[_0x0ccf('0x3b')]({},_0x39a96f,_0xd384d0['options']);var _0x3bf62f={'where':_0x39a96f[_0x0ccf('0x38')]};return db[_0x0ccf('0x29')][_0x0ccf('0x3c')](_0x3bf62f)['then'](function(_0x38dd7f){_0x5d0d67['count']=_0x38dd7f;if(_0xd384d0[_0x0ccf('0x2e')][_0x0ccf('0x3d')]){_0x39a96f[_0x0ccf('0x3e')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x0ccf('0x3f')](_0x39a96f);})['then'](function(_0x160868){_0x5d0d67['rows']=_0x160868;return _0x5d0d67;})[_0x0ccf('0x23')](respondWithFilteredResult(_0x4ec21c,_0x39a96f))[_0x0ccf('0x40')](handleError(_0x4ec21c,null));};exports[_0x0ccf('0x41')]=function(_0x5f2c0f,_0x59a98d){var _0x5ccde7={'raw':!![],'where':{'id':_0x5f2c0f[_0x0ccf('0x42')]['id']}},_0x40f777={};_0x40f777['model']=_[_0x0ccf('0x2f')](db[_0x0ccf('0x29')]['rawAttributes']);_0x40f777[_0x0ccf('0x2e')]=_['keys'](_0x5f2c0f[_0x0ccf('0x2e')]);_0x40f777[_0x0ccf('0x30')]=_['intersection'](_0x40f777[_0x0ccf('0x2d')],_0x40f777['query']);_0x5ccde7[_0x0ccf('0x31')]=_[_0x0ccf('0x32')](_0x40f777[_0x0ccf('0x2d')],qs[_0x0ccf('0x33')](_0x5f2c0f[_0x0ccf('0x2e')][_0x0ccf('0x33')]));_0x5ccde7['attributes']=_0x5ccde7[_0x0ccf('0x31')][_0x0ccf('0x43')]?_0x5ccde7[_0x0ccf('0x31')]:_0x40f777[_0x0ccf('0x2d')];if(_0x5f2c0f['query'][_0x0ccf('0x3d')]){_0x5ccde7[_0x0ccf('0x3e')]=[{'all':!![]}];}_0x5ccde7=_[_0x0ccf('0x3b')]({},_0x5ccde7,_0x5f2c0f['options']);return db[_0x0ccf('0x29')]['find'](_0x5ccde7)['then'](handleEntityNotFound(_0x59a98d,null))['then'](respondWithResult(_0x59a98d,null))[_0x0ccf('0x40')](handleError(_0x59a98d,null));};exports['create']=function(_0x9710c3,_0x18070a){return db['JscriptySessionReport'][_0x0ccf('0x44')](_0x9710c3[_0x0ccf('0x45')],{})[_0x0ccf('0x23')](respondWithResult(_0x18070a,0xc9))[_0x0ccf('0x40')](handleError(_0x18070a,null));};exports['update']=function(_0x1d5f7b,_0x53e433){if(_0x1d5f7b[_0x0ccf('0x45')]['id']){delete _0x1d5f7b[_0x0ccf('0x45')]['id'];}return db[_0x0ccf('0x29')][_0x0ccf('0x46')]({'where':{'id':_0x1d5f7b[_0x0ccf('0x42')]['id']}})[_0x0ccf('0x23')](handleEntityNotFound(_0x53e433,null))[_0x0ccf('0x23')](saveUpdates(_0x1d5f7b[_0x0ccf('0x45')],null))['then'](respondWithResult(_0x53e433,null))[_0x0ccf('0x40')](handleError(_0x53e433,null));};exports['destroy']=function(_0x27d205,_0x212bf0){return db[_0x0ccf('0x29')][_0x0ccf('0x46')]({'where':{'id':_0x27d205['params']['id']}})[_0x0ccf('0x23')](handleEntityNotFound(_0x212bf0,null))[_0x0ccf('0x23')](removeEntity(_0x212bf0,null))['catch'](handleError(_0x212bf0,null));};exports[_0x0ccf('0x47')]=function(_0x16ff44,_0x4cfb64){return db['JscriptySessionReport'][_0x0ccf('0x47')]()['then'](respondWithResult(_0x4cfb64,null))[_0x0ccf('0x40')](handleError(_0x4cfb64,null));};exports['getQuestions']=function(_0x285aaf,_0xe340c8,_0x38a772){var _0x3e16e7={'raw':!![],'where':{}};var _0x3c2b5e={};var _0x4d1199={'count':0x0,'rows':[]};return db['JscriptySessionReport']['findOne']({'where':{'id':_0x285aaf['params']['id']}})['then'](handleEntityNotFound(_0xe340c8,null))[_0x0ccf('0x23')](function(_0x37507c){if(_0x37507c){_0x3c2b5e[_0x0ccf('0x2d')]=_[_0x0ccf('0x2f')](db[_0x0ccf('0x48')][_0x0ccf('0x49')]);_0x3c2b5e['query']=_[_0x0ccf('0x2f')](_0x285aaf[_0x0ccf('0x2e')]);_0x3c2b5e[_0x0ccf('0x30')]=_[_0x0ccf('0x32')](_0x3c2b5e[_0x0ccf('0x2d')],_0x3c2b5e['query']);_0x3e16e7[_0x0ccf('0x31')]=_['intersection'](_0x3c2b5e[_0x0ccf('0x2d')],qs[_0x0ccf('0x33')](_0x285aaf[_0x0ccf('0x2e')][_0x0ccf('0x33')]));_0x3e16e7[_0x0ccf('0x31')]=_0x3e16e7[_0x0ccf('0x31')][_0x0ccf('0x43')]?_0x3e16e7[_0x0ccf('0x31')]:_0x3c2b5e[_0x0ccf('0x2d')];if(!_0x285aaf[_0x0ccf('0x2e')][_0x0ccf('0x34')](_0x0ccf('0x35'))){_0x3e16e7[_0x0ccf('0x1e')]=qs['limit'](_0x285aaf[_0x0ccf('0x2e')][_0x0ccf('0x1e')]);_0x3e16e7[_0x0ccf('0x1c')]=qs[_0x0ccf('0x1c')](_0x285aaf[_0x0ccf('0x2e')][_0x0ccf('0x1c')]);}_0x3e16e7['order']=qs['sort'](_0x285aaf[_0x0ccf('0x2e')][_0x0ccf('0x37')]);_0x3e16e7['where']=qs[_0x0ccf('0x30')](_[_0x0ccf('0x4a')](_0x285aaf[_0x0ccf('0x2e')],_0x3c2b5e[_0x0ccf('0x30')]));_0x3e16e7[_0x0ccf('0x38')][_0x0ccf('0x4b')]=_0x37507c['id'];if(_0x285aaf[_0x0ccf('0x2e')][_0x0ccf('0x39')]){_0x3e16e7[_0x0ccf('0x38')]=_[_0x0ccf('0x3b')](_0x3e16e7['where'],{'$or':_[_0x0ccf('0x28')](_0x3e16e7[_0x0ccf('0x31')],function(_0x208bb0){var _0x114996={};_0x114996[_0x208bb0]={'$like':'%'+_0x285aaf[_0x0ccf('0x2e')][_0x0ccf('0x39')]+'%'};return _0x114996;})});}_0x3e16e7=_[_0x0ccf('0x3b')]({},_0x3e16e7,_0x285aaf[_0x0ccf('0x4c')]);return db[_0x0ccf('0x48')][_0x0ccf('0x3c')]({'where':_0x3e16e7[_0x0ccf('0x38')]})[_0x0ccf('0x23')](function(_0x45f4c8){_0x4d1199['count']=_0x45f4c8;if(_0x285aaf[_0x0ccf('0x2e')][_0x0ccf('0x3d')]){_0x3e16e7[_0x0ccf('0x3e')]=[{'all':!![]}];}return db['JscriptyQuestionReport'][_0x0ccf('0x3f')](_0x3e16e7);})['then'](function(_0x2bd46c){_0x4d1199[_0x0ccf('0x4d')]=_0x2bd46c;return _0x4d1199;});}})[_0x0ccf('0x23')](respondWithFilteredResult(_0xe340c8,_0x3e16e7))[_0x0ccf('0x40')](handleError(_0xe340c8,null));};