server/api/squareProject/squareProject.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 _0x9974=['User','options','eml-format','rimraf','fast-json-patch','moment','util','path','sox','to-csv','ejs','fs-extra','crypto','desk.js','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./squareProject.socket','register','sendStatus','end','status','json','offset','limit','set','Content-Range','apply','reject','save','update','then','destroy','SquareProjects','UserProfileResource','error','stack','name','send','index','map','fieldName','type','key','model','query','keys','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge','VIRTUAL','count','include','findAll','params','rawAttributes','SquareProject','find','body','user','role','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','catch','addUsers','omit','ids','removeUsers','userSquareProject:remove','emit','getUsers','findOne'];(function(_0x459423,_0x3416a8){var _0x42ed14=function(_0x1d4f69){while(--_0x1d4f69){_0x459423['push'](_0x459423['shift']());}};_0x42ed14(++_0x3416a8);}(_0x9974,0xbe));var _0x4997=function(_0x1c5043,_0x579b6b){_0x1c5043=_0x1c5043-0x0;var _0x487132=_0x9974[_0x1c5043];return _0x487132;};'use strict';var emlformat=require(_0x4997('0x0'));var rimraf=require(_0x4997('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x4997('0x2'));var rp=require('request-promise');var moment=require(_0x4997('0x3'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x4997('0x4'));var path=require(_0x4997('0x5'));var sox=require(_0x4997('0x6'));var csv=require(_0x4997('0x7'));var ejs=require(_0x4997('0x8'));var fs=require('fs');var fs_extra=require(_0x4997('0x9'));var _=require('lodash');var squel=require('squel');var crypto=require(_0x4997('0xa'));var jsforce=require('jsforce');var deskjs=require(_0x4997('0xb'));var toCsv=require(_0x4997('0x7'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x4997('0xc'));var authService=require(_0x4997('0xd'));var qs=require(_0x4997('0xe'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x4997('0xf'));var logger=require(_0x4997('0x10'))(_0x4997('0x11'));var utils=require(_0x4997('0x12'));var config=require(_0x4997('0x13'));var licenseUtil=require(_0x4997('0x14'));var db=require(_0x4997('0x15'))['db'];config[_0x4997('0x16')]=_[_0x4997('0x17')](config['redis'],{'host':_0x4997('0x18'),'port':0x18eb});var socket=require(_0x4997('0x19'))(new Redis(config[_0x4997('0x16')]));require(_0x4997('0x1a'))[_0x4997('0x1b')](socket);function respondWithStatusCode(_0x1317d5,_0x561667){_0x561667=_0x561667||0xcc;return function(_0x2a9575){if(_0x2a9575){return _0x1317d5[_0x4997('0x1c')](_0x561667);}return _0x1317d5['status'](_0x561667)[_0x4997('0x1d')]();};}function respondWithResult(_0x494cad,_0x37da0d){_0x37da0d=_0x37da0d||0xc8;return function(_0x12fdce){if(_0x12fdce){return _0x494cad[_0x4997('0x1e')](_0x37da0d)[_0x4997('0x1f')](_0x12fdce);}};}function respondWithFilteredResult(_0x153c4b,_0x4ce3c3){return function(_0xb6e115){if(_0xb6e115){var _0x35d898=_0xb6e115['count'],_0x3ca0ba=_0x4ce3c3[_0x4997('0x20')],_0xe2f772=_0x4ce3c3[_0x4997('0x20')]+_0x4ce3c3[_0x4997('0x21')],_0x2e954a;if(_0xe2f772>=_0x35d898){_0xe2f772=_0x35d898;_0x2e954a=0xc8;}else{_0x2e954a=0xce;}_0x153c4b[_0x4997('0x1e')](_0x2e954a);return _0x153c4b[_0x4997('0x22')](_0x4997('0x23'),_0x3ca0ba+'-'+_0xe2f772+'/'+_0x35d898)[_0x4997('0x1f')](_0xb6e115);}return null;};}function patchUpdates(_0x281fda){return function(_0x2557e1){try{jsonpatch[_0x4997('0x24')](_0x2557e1,_0x281fda,!![]);}catch(_0x14e13e){return BPromise[_0x4997('0x25')](_0x14e13e);}return _0x2557e1[_0x4997('0x26')]();};}function saveUpdates(_0x2fa4d3,_0x286bd9){return function(_0x2f3308){if(_0x2f3308){return _0x2f3308[_0x4997('0x27')](_0x2fa4d3)[_0x4997('0x28')](function(_0x1d14ae){return _0x1d14ae;});}return null;};}function removeEntity(_0x197a8a,_0x1b5715){return function(_0x146371){if(_0x146371){return _0x146371[_0x4997('0x29')]()[_0x4997('0x28')](function(){var _0x220bae=_0x146371['get']({'plain':!![]});var _0x469a5c=_0x4997('0x2a');return db[_0x4997('0x2b')][_0x4997('0x29')]({'where':{'type':_0x469a5c,'resourceId':_0x220bae['id']}})[_0x4997('0x28')](function(){return _0x146371;});})[_0x4997('0x28')](function(){_0x197a8a[_0x4997('0x1e')](0xcc)['end']();});}};}function handleEntityNotFound(_0x590c21,_0xa40fe0){return function(_0x23bc12){if(!_0x23bc12){_0x590c21['sendStatus'](0x194);}return _0x23bc12;};}function handleError(_0x2799d8,_0x5b7a0c){_0x5b7a0c=_0x5b7a0c||0x1f4;return function(_0x38152e){logger[_0x4997('0x2c')](_0x38152e[_0x4997('0x2d')]);if(_0x38152e[_0x4997('0x2e')]){delete _0x38152e[_0x4997('0x2e')];}_0x2799d8[_0x4997('0x1e')](_0x5b7a0c)[_0x4997('0x2f')](_0x38152e);};}exports[_0x4997('0x30')]=function(_0x2a8536,_0x3b929b){var _0x1996c3={},_0x603565={},_0x890f4e={'count':0x0,'rows':[]};var _0x25462d=_[_0x4997('0x31')](db['SquareProject']['rawAttributes'],function(_0x5c74f9){return{'name':_0x5c74f9[_0x4997('0x32')],'type':_0x5c74f9[_0x4997('0x33')][_0x4997('0x34')]};});_0x603565[_0x4997('0x35')]=_[_0x4997('0x31')](_0x25462d,_0x4997('0x2e'));_0x603565[_0x4997('0x36')]=_[_0x4997('0x37')](_0x2a8536[_0x4997('0x36')]);_0x603565['filters']=_[_0x4997('0x38')](_0x603565[_0x4997('0x35')],_0x603565['query']);_0x1996c3[_0x4997('0x39')]=_[_0x4997('0x38')](_0x603565[_0x4997('0x35')],qs[_0x4997('0x3a')](_0x2a8536[_0x4997('0x36')]['fields']));_0x1996c3[_0x4997('0x39')]=_0x1996c3[_0x4997('0x39')][_0x4997('0x3b')]?_0x1996c3[_0x4997('0x39')]:_0x603565[_0x4997('0x35')];if(!_0x2a8536[_0x4997('0x36')][_0x4997('0x3c')](_0x4997('0x3d'))){_0x1996c3[_0x4997('0x21')]=qs[_0x4997('0x21')](_0x2a8536[_0x4997('0x36')][_0x4997('0x21')]);_0x1996c3['offset']=qs[_0x4997('0x20')](_0x2a8536[_0x4997('0x36')][_0x4997('0x20')]);}_0x1996c3[_0x4997('0x3e')]=qs[_0x4997('0x3f')](_0x2a8536[_0x4997('0x36')][_0x4997('0x3f')]);_0x1996c3[_0x4997('0x40')]=qs[_0x4997('0x41')](_[_0x4997('0x42')](_0x2a8536[_0x4997('0x36')],_0x603565[_0x4997('0x41')]),_0x25462d);if(_0x2a8536[_0x4997('0x36')][_0x4997('0x43')]){_0x1996c3[_0x4997('0x40')]=_[_0x4997('0x44')](_0x1996c3[_0x4997('0x40')],{'$or':_[_0x4997('0x31')](_0x25462d,function(_0x2fd1ad){if(_0x2fd1ad[_0x4997('0x33')]!==_0x4997('0x45')){var _0x2b3a7f={};_0x2b3a7f[_0x2fd1ad[_0x4997('0x2e')]]={'$like':'%'+_0x2a8536['query'][_0x4997('0x43')]+'%'};return _0x2b3a7f;}})});}_0x1996c3=_['merge']({},_0x1996c3,_0x2a8536['options']);var _0x59ba12={'where':_0x1996c3[_0x4997('0x40')]};return db['SquareProject'][_0x4997('0x46')](_0x59ba12)[_0x4997('0x28')](function(_0x1f06f6){_0x890f4e[_0x4997('0x46')]=_0x1f06f6;if(_0x2a8536['query']['includeAll']){_0x1996c3[_0x4997('0x47')]=[{'all':!![]}];}return db['SquareProject'][_0x4997('0x48')](_0x1996c3);})['then'](function(_0x312c5c){_0x890f4e['rows']=_0x312c5c;return _0x890f4e;})['then'](respondWithFilteredResult(_0x3b929b,_0x1996c3))['catch'](handleError(_0x3b929b,null));};exports['show']=function(_0x583b2f,_0x58ee2a){var _0x27c983={'raw':![],'where':{'id':_0x583b2f[_0x4997('0x49')]['id']}},_0x5706b3={};_0x5706b3[_0x4997('0x35')]=_[_0x4997('0x37')](db['SquareProject'][_0x4997('0x4a')]);_0x5706b3[_0x4997('0x36')]=_[_0x4997('0x37')](_0x583b2f[_0x4997('0x36')]);_0x5706b3[_0x4997('0x41')]=_[_0x4997('0x38')](_0x5706b3['model'],_0x5706b3['query']);_0x27c983[_0x4997('0x39')]=_[_0x4997('0x38')](_0x5706b3[_0x4997('0x35')],qs[_0x4997('0x3a')](_0x583b2f[_0x4997('0x36')][_0x4997('0x3a')]));_0x27c983[_0x4997('0x39')]=_0x27c983['attributes'][_0x4997('0x3b')]?_0x27c983[_0x4997('0x39')]:_0x5706b3['model'];if(_0x583b2f[_0x4997('0x36')]['includeAll']){_0x27c983[_0x4997('0x47')]=[{'all':!![]}];}_0x27c983=_[_0x4997('0x44')]({},_0x27c983,_0x583b2f['options']);return db[_0x4997('0x4b')][_0x4997('0x4c')](_0x27c983)[_0x4997('0x28')](handleEntityNotFound(_0x58ee2a,null))[_0x4997('0x28')](respondWithResult(_0x58ee2a,null))['catch'](handleError(_0x58ee2a,null));};exports['create']=function(_0x2a5275,_0x46f8e4){return db[_0x4997('0x4b')]['create'](_0x2a5275[_0x4997('0x4d')],{})[_0x4997('0x28')](function(_0x322563){var _0x2c82ae=_0x2a5275[_0x4997('0x4e')]['get']({'plain':!![]});if(!_0x2c82ae)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x2c82ae[_0x4997('0x4f')]===_0x4997('0x4e')){var _0x1618de=_0x322563['get']({'plain':!![]});var _0x597e12=_0x4997('0x2a');return db['UserProfileSection'][_0x4997('0x4c')]({'where':{'name':_0x597e12,'userProfileId':_0x2c82ae[_0x4997('0x50')]},'raw':!![]})['then'](function(_0x4b3e07){if(_0x4b3e07&&_0x4b3e07[_0x4997('0x51')]===0x0){return db[_0x4997('0x2b')]['create']({'name':_0x1618de['name'],'resourceId':_0x1618de['id'],'type':_0x4b3e07['name'],'sectionId':_0x4b3e07['id']},{})['then'](function(){return _0x322563;});}else{return _0x322563;}})['catch'](function(_0x1c4a6a){logger[_0x4997('0x2c')](_0x4997('0x52'),_0x1c4a6a);throw _0x1c4a6a;});}return _0x322563;})[_0x4997('0x28')](respondWithResult(_0x46f8e4,0xc9))[_0x4997('0x53')](handleError(_0x46f8e4,null));};exports['update']=function(_0x34dc21,_0x4d13a4){if(_0x34dc21['body']['id']){delete _0x34dc21[_0x4997('0x4d')]['id'];}return db[_0x4997('0x4b')][_0x4997('0x4c')]({'where':{'id':_0x34dc21[_0x4997('0x49')]['id']}})[_0x4997('0x28')](handleEntityNotFound(_0x4d13a4,null))[_0x4997('0x28')](saveUpdates(_0x34dc21[_0x4997('0x4d')],null))[_0x4997('0x28')](respondWithResult(_0x4d13a4,null))[_0x4997('0x53')](handleError(_0x4d13a4,null));};exports[_0x4997('0x29')]=function(_0x1fe537,_0x200264){return db[_0x4997('0x4b')]['find']({'where':{'id':_0x1fe537['params']['id']}})[_0x4997('0x28')](handleEntityNotFound(_0x200264,null))[_0x4997('0x28')](removeEntity(_0x200264,null))[_0x4997('0x53')](handleError(_0x200264,null));};exports[_0x4997('0x54')]=function(_0x5b1907,_0x4691be,_0x42dc5c){return db[_0x4997('0x4b')][_0x4997('0x4c')]({'where':{'id':_0x5b1907[_0x4997('0x49')]['id']}})[_0x4997('0x28')](handleEntityNotFound(_0x4691be,null))[_0x4997('0x28')](function(_0x3a1692){if(_0x3a1692){return _0x3a1692[_0x4997('0x54')](_0x5b1907[_0x4997('0x4d')]['ids'],_[_0x4997('0x55')](_0x5b1907[_0x4997('0x4d')],[_0x4997('0x56'),'id'])||{});}})[_0x4997('0x28')](respondWithResult(_0x4691be,null))['catch'](handleError(_0x4691be,null));};exports[_0x4997('0x57')]=function(_0x58614c,_0x4dffb0,_0x39d1a3){return db['SquareProject']['find']({'where':{'id':_0x58614c['params']['id']}})[_0x4997('0x28')](handleEntityNotFound(_0x4dffb0,null))[_0x4997('0x28')](function(_0x342f71){if(_0x342f71){return _0x342f71[_0x4997('0x57')](_0x58614c[_0x4997('0x36')]['ids'])[_0x4997('0x28')](function(){if(_['isArray'](_0x58614c[_0x4997('0x36')][_0x4997('0x56')])){for(var _0x4ebffe=0x0;_0x4ebffe<_0x58614c[_0x4997('0x36')]['ids'][_0x4997('0x3b')];_0x4ebffe+=0x1){socket['emit'](_0x4997('0x58'),{'UserId':Number(_0x58614c[_0x4997('0x36')]['ids'][_0x4ebffe]),'SquareProjectId':Number(_0x58614c['params']['id'])});}}else{socket[_0x4997('0x59')]('userSquareProject:remove',{'UserId':Number(_0x58614c[_0x4997('0x36')][_0x4997('0x56')]),'SquareProjectId':Number(_0x58614c[_0x4997('0x49')]['id'])});}});}})['then'](respondWithStatusCode(_0x4dffb0,null))[_0x4997('0x53')](handleError(_0x4dffb0,null));};exports[_0x4997('0x5a')]=function(_0x5f06dc,_0x3baad5,_0x416403){var _0x404d51={};var _0x2bebde={};var _0x61982e;var _0x46aca6;return db[_0x4997('0x4b')][_0x4997('0x5b')]({'where':{'id':_0x5f06dc['params']['id']}})[_0x4997('0x28')](handleEntityNotFound(_0x3baad5,null))[_0x4997('0x28')](function(_0x27f1fa){if(_0x27f1fa){_0x61982e=_0x27f1fa;_0x2bebde[_0x4997('0x35')]=_[_0x4997('0x37')](db[_0x4997('0x5c')][_0x4997('0x4a')]);_0x2bebde[_0x4997('0x36')]=_['keys'](_0x5f06dc[_0x4997('0x36')]);_0x2bebde[_0x4997('0x41')]=_[_0x4997('0x38')](_0x2bebde[_0x4997('0x35')],_0x2bebde[_0x4997('0x36')]);_0x404d51[_0x4997('0x39')]=_['intersection'](_0x2bebde[_0x4997('0x35')],qs[_0x4997('0x3a')](_0x5f06dc['query']['fields']));_0x404d51[_0x4997('0x39')]=_0x404d51[_0x4997('0x39')][_0x4997('0x3b')]?_0x404d51[_0x4997('0x39')]:_0x2bebde[_0x4997('0x35')];_0x404d51[_0x4997('0x3e')]=qs[_0x4997('0x3f')](_0x5f06dc['query'][_0x4997('0x3f')]);_0x404d51[_0x4997('0x40')]=qs['filters'](_[_0x4997('0x42')](_0x5f06dc[_0x4997('0x36')],_0x2bebde[_0x4997('0x41')]));if(_0x5f06dc['query'][_0x4997('0x43')]){_0x404d51['where']=_['merge'](_0x404d51['where'],{'$or':_[_0x4997('0x31')](_0x404d51[_0x4997('0x39')],function(_0x34f18d){var _0xf9efac={};_0xf9efac[_0x34f18d]={'$like':'%'+_0x5f06dc[_0x4997('0x36')][_0x4997('0x43')]+'%'};return _0xf9efac;})});}_0x404d51=_[_0x4997('0x44')]({},_0x404d51,_0x5f06dc[_0x4997('0x5d')]);return _0x61982e['getUsers'](_0x404d51);}})['then'](function(_0x26859d){if(_0x26859d){_0x46aca6=_0x26859d[_0x4997('0x3b')];if(!_0x5f06dc[_0x4997('0x36')][_0x4997('0x3c')](_0x4997('0x3d'))){_0x404d51[_0x4997('0x21')]=qs[_0x4997('0x21')](_0x5f06dc[_0x4997('0x36')][_0x4997('0x21')]);_0x404d51[_0x4997('0x20')]=qs['offset'](_0x5f06dc[_0x4997('0x36')]['offset']);}return _0x61982e[_0x4997('0x5a')](_0x404d51);}})[_0x4997('0x28')](function(_0x525b8a){if(_0x525b8a){return _0x525b8a?{'count':_0x46aca6,'rows':_0x525b8a}:null;}})[_0x4997('0x28')](respondWithResult(_0x3baad5,null))[_0x4997('0x53')](handleError(_0x3baad5,null));};