[motion2.git] / server / api / jscriptySessionReport / jscriptySessionReport.controller.js

// *************************************************************************
// *                                                                       *
// * xCALLY Motion -  The Omnichannel Contact Center                       *
// * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * Email: info@xcally.com                                                *
// * Website: https://www.xcally.com                                       *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * The SOFTWARE PRODUCT is protected by copyright laws and international *
// * copyright treaties, as well as other intellectual property laws and   *
// * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
// *                                                                       *
// *************************************************************************
var _0x7d98=['api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','offset','undefined','limit','count','set','Content-Range','json','apply','reject','save','then','status','error','stack','name','index','map','JscriptySessionReport','rawAttributes','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','order','where','filter','merge','VIRTUAL','options','include','findAll','rows','catch','params','includeAll','find','create','update','body','destroy','describe','getQuestions','findOne','nolimit','sort','SessionId','JscriptyQuestionReport','eml-format','rimraf','zip-dir','request-promise','bluebird','mustache','to-csv','ejs','fs-extra','lodash','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch'];(function(_0x4f5150,_0x524744){var _0x4d0aa2=function(_0xd21bdc){while(--_0xd21bdc){_0x4f5150['push'](_0x4f5150['shift']());}};_0x4d0aa2(++_0x524744);}(_0x7d98,0xd8));var _0x87d9=function(_0x3b7b8a,_0x52c3b0){_0x3b7b8a=_0x3b7b8a-0x0;var _0x441206=_0x7d98[_0x3b7b8a];return _0x441206;};'use strict';var emlformat=require(_0x87d9('0x0'));var rimraf=require(_0x87d9('0x1'));var zipdir=require(_0x87d9('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x87d9('0x3'));var moment=require('moment');var BPromise=require(_0x87d9('0x4'));var Mustache=require(_0x87d9('0x5'));var util=require('util');var path=require('path');var sox=require('sox');var csv=require(_0x87d9('0x6'));var ejs=require(_0x87d9('0x7'));var fs=require('fs');var fs_extra=require(_0x87d9('0x8'));var _=require(_0x87d9('0x9'));var squel=require('squel');var crypto=require(_0x87d9('0xa'));var jsforce=require(_0x87d9('0xb'));var deskjs=require(_0x87d9('0xc'));var toCsv=require(_0x87d9('0x6'));var querystring=require(_0x87d9('0xd'));var Papa=require(_0x87d9('0xe'));var Redis=require('ioredis');var authService=require(_0x87d9('0xf'));var qs=require(_0x87d9('0x10'));var as=require(_0x87d9('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x87d9('0x12'));var utils=require(_0x87d9('0x13'));var config=require(_0x87d9('0x14'));var licenseUtil=require(_0x87d9('0x15'));var db=require(_0x87d9('0x16'))['db'];function respondWithStatusCode(_0xee02cb,_0xa0266c){_0xa0266c=_0xa0266c||0xcc;return function(_0x1f41b0){if(_0x1f41b0){return _0xee02cb[_0x87d9('0x17')](_0xa0266c);}return _0xee02cb['status'](_0xa0266c)[_0x87d9('0x18')]();};}function respondWithResult(_0x51856d,_0x95ae5b){_0x95ae5b=_0x95ae5b||0xc8;return function(_0x5ecf27){if(_0x5ecf27){return _0x51856d['status'](_0x95ae5b)['json'](_0x5ecf27);}};}function respondWithFilteredResult(_0x2f3629,_0x4d6c12){return function(_0x31310f){if(_0x31310f){var _0x6e38c9=typeof _0x4d6c12[_0x87d9('0x19')]===_0x87d9('0x1a')&&typeof _0x4d6c12[_0x87d9('0x1b')]==='undefined';var _0x3ee5bd=_0x31310f['count'];var _0x25e1f8=_0x6e38c9?0x0:_0x4d6c12[_0x87d9('0x19')];var _0x40c3c8=_0x6e38c9?_0x31310f[_0x87d9('0x1c')]:_0x4d6c12['offset']+_0x4d6c12[_0x87d9('0x1b')];var _0xab126c;if(_0x40c3c8>=_0x3ee5bd){_0x40c3c8=_0x3ee5bd;_0xab126c=0xc8;}else{_0xab126c=0xce;}_0x2f3629['status'](_0xab126c);return _0x2f3629[_0x87d9('0x1d')](_0x87d9('0x1e'),_0x25e1f8+'-'+_0x40c3c8+'/'+_0x3ee5bd)[_0x87d9('0x1f')](_0x31310f);}return null;};}function patchUpdates(_0x3361c4){return function(_0x36854b){try{jsonpatch[_0x87d9('0x20')](_0x36854b,_0x3361c4,!![]);}catch(_0x537a89){return BPromise[_0x87d9('0x21')](_0x537a89);}return _0x36854b[_0x87d9('0x22')]();};}function saveUpdates(_0xfeaea4,_0xb0e892){return function(_0x48aad7){if(_0x48aad7){return _0x48aad7['update'](_0xfeaea4)[_0x87d9('0x23')](function(_0xf00b2f){return _0xf00b2f;});}return null;};}function removeEntity(_0x1b5b85,_0x48b8ff){return function(_0x39e389){if(_0x39e389){return _0x39e389['destroy']()[_0x87d9('0x23')](function(){_0x1b5b85[_0x87d9('0x24')](0xcc)[_0x87d9('0x18')]();});}};}function handleEntityNotFound(_0x4beee0,_0x253c93){return function(_0x379d63){if(!_0x379d63){_0x4beee0['sendStatus'](0x194);}return _0x379d63;};}function handleError(_0x2925f7,_0x49baa0){_0x49baa0=_0x49baa0||0x1f4;return function(_0x39bbbd){logger[_0x87d9('0x25')](_0x39bbbd[_0x87d9('0x26')]);if(_0x39bbbd[_0x87d9('0x27')]){delete _0x39bbbd[_0x87d9('0x27')];}_0x2925f7[_0x87d9('0x24')](_0x49baa0)['send'](_0x39bbbd);};}exports[_0x87d9('0x28')]=function(_0x280921,_0x23c9ab){var _0xb88bd2={},_0x102d17={},_0xd9c03c={'count':0x0,'rows':[]};var _0x47e258=_[_0x87d9('0x29')](db[_0x87d9('0x2a')][_0x87d9('0x2b')],function(_0x2f9051){return{'name':_0x2f9051['fieldName'],'type':_0x2f9051['type'][_0x87d9('0x2c')]};});_0x102d17[_0x87d9('0x2d')]=_['map'](_0x47e258,_0x87d9('0x27'));_0x102d17[_0x87d9('0x2e')]=_[_0x87d9('0x2f')](_0x280921[_0x87d9('0x2e')]);_0x102d17[_0x87d9('0x30')]=_[_0x87d9('0x31')](_0x102d17[_0x87d9('0x2d')],_0x102d17[_0x87d9('0x2e')]);_0xb88bd2[_0x87d9('0x32')]=_[_0x87d9('0x31')](_0x102d17[_0x87d9('0x2d')],qs[_0x87d9('0x33')](_0x280921['query'][_0x87d9('0x33')]));_0xb88bd2[_0x87d9('0x32')]=_0xb88bd2[_0x87d9('0x32')][_0x87d9('0x34')]?_0xb88bd2[_0x87d9('0x32')]:_0x102d17[_0x87d9('0x2d')];if(!_0x280921[_0x87d9('0x2e')][_0x87d9('0x35')]('nolimit')){_0xb88bd2[_0x87d9('0x1b')]=qs['limit'](_0x280921[_0x87d9('0x2e')][_0x87d9('0x1b')]);_0xb88bd2[_0x87d9('0x19')]=qs[_0x87d9('0x19')](_0x280921[_0x87d9('0x2e')][_0x87d9('0x19')]);}_0xb88bd2[_0x87d9('0x36')]=qs['sort'](_0x280921[_0x87d9('0x2e')]['sort']);_0xb88bd2[_0x87d9('0x37')]=qs[_0x87d9('0x30')](_['pick'](_0x280921[_0x87d9('0x2e')],_0x102d17[_0x87d9('0x30')]),_0x47e258);if(_0x280921['query'][_0x87d9('0x38')]){_0xb88bd2[_0x87d9('0x37')]=_[_0x87d9('0x39')](_0xb88bd2['where'],{'$or':_[_0x87d9('0x29')](_0x47e258,function(_0x441613){if(_0x441613['type']!==_0x87d9('0x3a')){var _0x1425c0={};_0x1425c0[_0x441613[_0x87d9('0x27')]]={'$like':'%'+_0x280921['query'][_0x87d9('0x38')]+'%'};return _0x1425c0;}})});}_0xb88bd2=_['merge']({},_0xb88bd2,_0x280921[_0x87d9('0x3b')]);var _0x37fff9={'where':_0xb88bd2[_0x87d9('0x37')]};return db[_0x87d9('0x2a')][_0x87d9('0x1c')](_0x37fff9)['then'](function(_0x19eccf){_0xd9c03c[_0x87d9('0x1c')]=_0x19eccf;if(_0x280921[_0x87d9('0x2e')]['includeAll']){_0xb88bd2[_0x87d9('0x3c')]=[{'all':!![]}];}return db[_0x87d9('0x2a')][_0x87d9('0x3d')](_0xb88bd2);})['then'](function(_0x51b926){_0xd9c03c[_0x87d9('0x3e')]=_0x51b926;return _0xd9c03c;})[_0x87d9('0x23')](respondWithFilteredResult(_0x23c9ab,_0xb88bd2))[_0x87d9('0x3f')](handleError(_0x23c9ab,null));};exports['show']=function(_0x339888,_0x10f3d8){var _0x215549={'raw':!![],'where':{'id':_0x339888[_0x87d9('0x40')]['id']}},_0x116f85={};_0x116f85[_0x87d9('0x2d')]=_[_0x87d9('0x2f')](db[_0x87d9('0x2a')][_0x87d9('0x2b')]);_0x116f85[_0x87d9('0x2e')]=_[_0x87d9('0x2f')](_0x339888[_0x87d9('0x2e')]);_0x116f85[_0x87d9('0x30')]=_[_0x87d9('0x31')](_0x116f85[_0x87d9('0x2d')],_0x116f85['query']);_0x215549[_0x87d9('0x32')]=_[_0x87d9('0x31')](_0x116f85['model'],qs[_0x87d9('0x33')](_0x339888['query']['fields']));_0x215549[_0x87d9('0x32')]=_0x215549[_0x87d9('0x32')][_0x87d9('0x34')]?_0x215549['attributes']:_0x116f85['model'];if(_0x339888['query'][_0x87d9('0x41')]){_0x215549[_0x87d9('0x3c')]=[{'all':!![]}];}_0x215549=_['merge']({},_0x215549,_0x339888['options']);return db[_0x87d9('0x2a')][_0x87d9('0x42')](_0x215549)[_0x87d9('0x23')](handleEntityNotFound(_0x10f3d8,null))[_0x87d9('0x23')](respondWithResult(_0x10f3d8,null))[_0x87d9('0x3f')](handleError(_0x10f3d8,null));};exports['create']=function(_0x19897b,_0x992f6e){return db[_0x87d9('0x2a')][_0x87d9('0x43')](_0x19897b['body'],{})[_0x87d9('0x23')](respondWithResult(_0x992f6e,0xc9))[_0x87d9('0x3f')](handleError(_0x992f6e,null));};exports[_0x87d9('0x44')]=function(_0x45b178,_0x32af95){if(_0x45b178[_0x87d9('0x45')]['id']){delete _0x45b178[_0x87d9('0x45')]['id'];}return db[_0x87d9('0x2a')][_0x87d9('0x42')]({'where':{'id':_0x45b178[_0x87d9('0x40')]['id']}})[_0x87d9('0x23')](handleEntityNotFound(_0x32af95,null))['then'](saveUpdates(_0x45b178[_0x87d9('0x45')],null))[_0x87d9('0x23')](respondWithResult(_0x32af95,null))['catch'](handleError(_0x32af95,null));};exports[_0x87d9('0x46')]=function(_0x5a059e,_0x2b5239){return db[_0x87d9('0x2a')][_0x87d9('0x42')]({'where':{'id':_0x5a059e['params']['id']}})[_0x87d9('0x23')](handleEntityNotFound(_0x2b5239,null))['then'](removeEntity(_0x2b5239,null))[_0x87d9('0x3f')](handleError(_0x2b5239,null));};exports[_0x87d9('0x47')]=function(_0xc2af58,_0xf01d6f){return db[_0x87d9('0x2a')][_0x87d9('0x47')]()[_0x87d9('0x23')](respondWithResult(_0xf01d6f,null))[_0x87d9('0x3f')](handleError(_0xf01d6f,null));};exports[_0x87d9('0x48')]=function(_0x4e3977,_0x2c83e8,_0x183512){var _0x56f25a={'raw':!![],'where':{}};var _0x74b0fa={};var _0x4f4942={'count':0x0,'rows':[]};return db[_0x87d9('0x2a')][_0x87d9('0x49')]({'where':{'id':_0x4e3977[_0x87d9('0x40')]['id']}})[_0x87d9('0x23')](handleEntityNotFound(_0x2c83e8,null))[_0x87d9('0x23')](function(_0x5ae95c){if(_0x5ae95c){_0x74b0fa[_0x87d9('0x2d')]=_['keys'](db['JscriptyQuestionReport'][_0x87d9('0x2b')]);_0x74b0fa[_0x87d9('0x2e')]=_[_0x87d9('0x2f')](_0x4e3977[_0x87d9('0x2e')]);_0x74b0fa[_0x87d9('0x30')]=_[_0x87d9('0x31')](_0x74b0fa[_0x87d9('0x2d')],_0x74b0fa['query']);_0x56f25a[_0x87d9('0x32')]=_[_0x87d9('0x31')](_0x74b0fa[_0x87d9('0x2d')],qs[_0x87d9('0x33')](_0x4e3977[_0x87d9('0x2e')][_0x87d9('0x33')]));_0x56f25a[_0x87d9('0x32')]=_0x56f25a[_0x87d9('0x32')]['length']?_0x56f25a[_0x87d9('0x32')]:_0x74b0fa['model'];if(!_0x4e3977[_0x87d9('0x2e')][_0x87d9('0x35')](_0x87d9('0x4a'))){_0x56f25a[_0x87d9('0x1b')]=qs[_0x87d9('0x1b')](_0x4e3977[_0x87d9('0x2e')][_0x87d9('0x1b')]);_0x56f25a[_0x87d9('0x19')]=qs[_0x87d9('0x19')](_0x4e3977['query'][_0x87d9('0x19')]);}_0x56f25a['order']=qs['sort'](_0x4e3977['query'][_0x87d9('0x4b')]);_0x56f25a[_0x87d9('0x37')]=qs[_0x87d9('0x30')](_['pick'](_0x4e3977[_0x87d9('0x2e')],_0x74b0fa[_0x87d9('0x30')]));_0x56f25a[_0x87d9('0x37')][_0x87d9('0x4c')]=_0x5ae95c['id'];if(_0x4e3977[_0x87d9('0x2e')][_0x87d9('0x38')]){_0x56f25a[_0x87d9('0x37')]=_[_0x87d9('0x39')](_0x56f25a[_0x87d9('0x37')],{'$or':_[_0x87d9('0x29')](_0x56f25a[_0x87d9('0x32')],function(_0x485a46){var _0xa7b827={};_0xa7b827[_0x485a46]={'$like':'%'+_0x4e3977['query'][_0x87d9('0x38')]+'%'};return _0xa7b827;})});}_0x56f25a=_[_0x87d9('0x39')]({},_0x56f25a,_0x4e3977[_0x87d9('0x3b')]);return db[_0x87d9('0x4d')][_0x87d9('0x1c')]({'where':_0x56f25a[_0x87d9('0x37')]})[_0x87d9('0x23')](function(_0x18cf7a){_0x4f4942[_0x87d9('0x1c')]=_0x18cf7a;if(_0x4e3977[_0x87d9('0x2e')][_0x87d9('0x41')]){_0x56f25a[_0x87d9('0x3c')]=[{'all':!![]}];}return db['JscriptyQuestionReport'][_0x87d9('0x3d')](_0x56f25a);})[_0x87d9('0x23')](function(_0xde6304){_0x4f4942[_0x87d9('0x3e')]=_0xde6304;return _0x4f4942;});}})['then'](respondWithFilteredResult(_0x2c83e8,_0x56f25a))[_0x87d9('0x3f')](handleError(_0x2c83e8,null));};