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 _0x7649=['role','UserProfileSection','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','addUsers','omit','ids','removeUsers','emit','userSquareProject:remove','getUsers','User','html-pdf','eml-format','zip-dir','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','end','status','json','count','offset','limit','set','Content-Range','apply','save','then','destroy','get','SquareProjects','UserProfileResource','sendStatus','stack','name','index','map','rawAttributes','fieldName','key','model','query','keys','filters','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','type','SquareProject','include','findAll','show','params','filtears','intersection','find','catch','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user'];(function(_0x3e3bee,_0x4f91fe){var _0x3ae14c=function(_0x3861a0){while(--_0x3861a0){_0x3e3bee['push'](_0x3e3bee['shift']());}};_0x3ae14c(++_0x4f91fe);}(_0x7649,0x6d));var _0x9764=function(_0x544cc7,_0x5b02fb){_0x544cc7=_0x544cc7-0x0;var _0x3896d0=_0x7649[_0x544cc7];return _0x3896d0;};'use strict';var pdf=require(_0x9764('0x0'));var emlformat=require(_0x9764('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x9764('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x9764('0x3'));var moment=require(_0x9764('0x4'));var BPromise=require(_0x9764('0x5'));var Mustache=require(_0x9764('0x6'));var util=require('util');var path=require(_0x9764('0x7'));var sox=require(_0x9764('0x8'));var csv=require(_0x9764('0x9'));var ejs=require(_0x9764('0xa'));var fs=require('fs');var _=require(_0x9764('0xb'));var squel=require(_0x9764('0xc'));var crypto=require(_0x9764('0xd'));var jsforce=require(_0x9764('0xe'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x9764('0xf'));var Redis=require(_0x9764('0x10'));var authService=require(_0x9764('0x11'));var qs=require(_0x9764('0x12'));var as=require(_0x9764('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x9764('0x14'))('api');var utils=require(_0x9764('0x15'));var config=require(_0x9764('0x16'));var licenseUtil=require('../../config/license/util');var db=require(_0x9764('0x17'))['db'];config[_0x9764('0x18')]=_[_0x9764('0x19')](config[_0x9764('0x18')],{'host':_0x9764('0x1a'),'port':0x18eb});var socket=require(_0x9764('0x1b'))(new Redis(config[_0x9764('0x18')]));require('./squareProject.socket')['register'](socket);function respondWithStatusCode(_0x5c209d,_0x2d6484){_0x2d6484=_0x2d6484||0xcc;return function(_0x3a57f2){if(_0x3a57f2){return _0x5c209d['sendStatus'](_0x2d6484);}return _0x5c209d['status'](_0x2d6484)[_0x9764('0x1c')]();};}function respondWithResult(_0x24d969,_0x17c7b5){_0x17c7b5=_0x17c7b5||0xc8;return function(_0x3128f6){if(_0x3128f6){return _0x24d969[_0x9764('0x1d')](_0x17c7b5)[_0x9764('0x1e')](_0x3128f6);}};}function respondWithFilteredResult(_0x1b807a,_0x4b01f1){return function(_0x4875cd){if(_0x4875cd){var _0x5385b3=_0x4875cd[_0x9764('0x1f')],_0x265808=_0x4b01f1[_0x9764('0x20')],_0x101a05=_0x4b01f1['offset']+_0x4b01f1[_0x9764('0x21')],_0x571b95;if(_0x101a05>=_0x5385b3){_0x101a05=_0x5385b3;_0x571b95=0xc8;}else{_0x571b95=0xce;}_0x1b807a[_0x9764('0x1d')](_0x571b95);return _0x1b807a[_0x9764('0x22')](_0x9764('0x23'),_0x265808+'-'+_0x101a05+'/'+_0x5385b3)[_0x9764('0x1e')](_0x4875cd);}return null;};}function patchUpdates(_0x44d03e){return function(_0x156f71){try{jsonpatch[_0x9764('0x24')](_0x156f71,_0x44d03e,!![]);}catch(_0x5914ca){return BPromise['reject'](_0x5914ca);}return _0x156f71[_0x9764('0x25')]();};}function saveUpdates(_0x419218,_0x361c50){return function(_0x3ae49b){if(_0x3ae49b){return _0x3ae49b['update'](_0x419218)[_0x9764('0x26')](function(_0x4307b3){return _0x4307b3;});}return null;};}function removeEntity(_0x11b701,_0x5dee91){return function(_0x2b739f){if(_0x2b739f){return _0x2b739f[_0x9764('0x27')]()[_0x9764('0x26')](function(){var _0x42ba98=_0x2b739f[_0x9764('0x28')]({'plain':!![]});var _0x5ba4b2=_0x9764('0x29');return db[_0x9764('0x2a')][_0x9764('0x27')]({'where':{'type':_0x5ba4b2,'resourceId':_0x42ba98['id']}})[_0x9764('0x26')](function(){return _0x2b739f;});})[_0x9764('0x26')](function(){_0x11b701['status'](0xcc)[_0x9764('0x1c')]();});}};}function handleEntityNotFound(_0x1f9440,_0x3d9b78){return function(_0x1fe9b1){if(!_0x1fe9b1){_0x1f9440[_0x9764('0x2b')](0x194);}return _0x1fe9b1;};}function handleError(_0x3ac778,_0x337739){_0x337739=_0x337739||0x1f4;return function(_0x412126){logger['error'](_0x412126[_0x9764('0x2c')]);if(_0x412126[_0x9764('0x2d')]){delete _0x412126[_0x9764('0x2d')];}_0x3ac778[_0x9764('0x1d')](_0x337739)['send'](_0x412126);};}exports[_0x9764('0x2e')]=function(_0x51bd28,_0x388a22){var _0x2d3abb={},_0x237589={},_0x11b026={'count':0x0,'rows':[]};var _0x276bc5=_[_0x9764('0x2f')](db['SquareProject'][_0x9764('0x30')],function(_0x5edbf1){return{'name':_0x5edbf1[_0x9764('0x31')],'type':_0x5edbf1['type'][_0x9764('0x32')]};});_0x237589[_0x9764('0x33')]=_[_0x9764('0x2f')](_0x276bc5,'name');_0x237589[_0x9764('0x34')]=_[_0x9764('0x35')](_0x51bd28[_0x9764('0x34')]);_0x237589[_0x9764('0x36')]=_['intersection'](_0x237589[_0x9764('0x33')],_0x237589[_0x9764('0x34')]);_0x2d3abb[_0x9764('0x37')]=_['intersection'](_0x237589[_0x9764('0x33')],qs[_0x9764('0x38')](_0x51bd28[_0x9764('0x34')][_0x9764('0x38')]));_0x2d3abb[_0x9764('0x37')]=_0x2d3abb[_0x9764('0x37')][_0x9764('0x39')]?_0x2d3abb[_0x9764('0x37')]:_0x237589[_0x9764('0x33')];if(!_0x51bd28['query'][_0x9764('0x3a')](_0x9764('0x3b'))){_0x2d3abb[_0x9764('0x21')]=qs[_0x9764('0x21')](_0x51bd28[_0x9764('0x34')]['limit']);_0x2d3abb['offset']=qs[_0x9764('0x20')](_0x51bd28[_0x9764('0x34')][_0x9764('0x20')]);}_0x2d3abb[_0x9764('0x3c')]=qs[_0x9764('0x3d')](_0x51bd28[_0x9764('0x34')][_0x9764('0x3d')]);_0x2d3abb[_0x9764('0x3e')]=qs[_0x9764('0x36')](_[_0x9764('0x3f')](_0x51bd28['query'],_0x237589[_0x9764('0x36')]),_0x276bc5);if(_0x51bd28[_0x9764('0x34')][_0x9764('0x40')]){_0x2d3abb[_0x9764('0x3e')]=_[_0x9764('0x41')](_0x2d3abb[_0x9764('0x3e')],{'$or':_[_0x9764('0x2f')](_0x276bc5,function(_0x5b9ee3){if(_0x5b9ee3[_0x9764('0x42')]!=='VIRTUAL'){var _0xfc421e={};_0xfc421e[_0x5b9ee3['name']]={'$like':'%'+_0x51bd28['query']['filter']+'%'};return _0xfc421e;}})});}_0x2d3abb=_['merge']({},_0x2d3abb,_0x51bd28['options']);var _0x345e90={'where':_0x2d3abb['where']};return db[_0x9764('0x43')][_0x9764('0x1f')](_0x345e90)['then'](function(_0x38c87b){_0x11b026[_0x9764('0x1f')]=_0x38c87b;if(_0x51bd28[_0x9764('0x34')]['includeAll']){_0x2d3abb[_0x9764('0x44')]=[{'all':!![]}];}return db['SquareProject'][_0x9764('0x45')](_0x2d3abb);})[_0x9764('0x26')](function(_0x8fe3b5){_0x11b026['rows']=_0x8fe3b5;return _0x11b026;})['then'](respondWithFilteredResult(_0x388a22,_0x2d3abb))['catch'](handleError(_0x388a22,null));};exports[_0x9764('0x46')]=function(_0x485db9,_0x5a7e46){var _0x527024={'raw':![],'where':{'id':_0x485db9[_0x9764('0x47')]['id']}},_0x1f0d02={};_0x1f0d02['model']=_['keys'](db[_0x9764('0x43')][_0x9764('0x30')]);_0x1f0d02[_0x9764('0x34')]=_['keys'](_0x485db9[_0x9764('0x34')]);_0x1f0d02[_0x9764('0x48')]=_[_0x9764('0x49')](_0x1f0d02[_0x9764('0x33')],_0x1f0d02[_0x9764('0x34')]);_0x527024[_0x9764('0x37')]=_['intersection'](_0x1f0d02[_0x9764('0x33')],qs[_0x9764('0x38')](_0x485db9['query']['fields']));_0x527024[_0x9764('0x37')]=_0x527024['attributes'][_0x9764('0x39')]?_0x527024[_0x9764('0x37')]:_0x1f0d02[_0x9764('0x33')];if(_0x485db9[_0x9764('0x34')]['includeAll']){_0x527024[_0x9764('0x44')]=[{'all':!![]}];}_0x527024=_[_0x9764('0x41')]({},_0x527024,_0x485db9['options']);return db['SquareProject'][_0x9764('0x4a')](_0x527024)[_0x9764('0x26')](handleEntityNotFound(_0x5a7e46,null))[_0x9764('0x26')](respondWithResult(_0x5a7e46,null))[_0x9764('0x4b')](handleError(_0x5a7e46,null));};exports[_0x9764('0x4c')]=function(_0x2fd134,_0x1dd8b1){return db[_0x9764('0x43')]['create'](_0x2fd134['body'],{})[_0x9764('0x26')](function(_0x293da7){var _0x114801=_0x2fd134[_0x9764('0x4d')][_0x9764('0x28')]({'plain':!![]});if(!_0x114801)throw new Error(_0x9764('0x4e'));if(_0x114801[_0x9764('0x4f')]===_0x9764('0x4d')){var _0x356f41=_0x293da7[_0x9764('0x28')]({'plain':!![]});var _0x1a257d=_0x9764('0x29');return db[_0x9764('0x50')][_0x9764('0x4a')]({'where':{'name':_0x1a257d,'userProfileId':_0x114801[_0x9764('0x51')]},'raw':!![]})[_0x9764('0x26')](function(_0x2206a5){if(_0x2206a5&&_0x2206a5[_0x9764('0x52')]===0x0){return db[_0x9764('0x2a')]['create']({'name':_0x356f41[_0x9764('0x2d')],'resourceId':_0x356f41['id'],'type':_0x2206a5[_0x9764('0x2d')],'sectionId':_0x2206a5['id']},{})['then'](function(){return _0x293da7;});}else{return _0x293da7;}})['catch'](function(_0x4111b0){logger[_0x9764('0x53')](_0x9764('0x54'),_0x4111b0);throw _0x4111b0;});}return _0x293da7;})[_0x9764('0x26')](respondWithResult(_0x1dd8b1,0xc9))[_0x9764('0x4b')](handleError(_0x1dd8b1,null));};exports['update']=function(_0x5732d2,_0x2df8e9){if(_0x5732d2[_0x9764('0x55')]['id']){delete _0x5732d2['body']['id'];}return db[_0x9764('0x43')][_0x9764('0x4a')]({'where':{'id':_0x5732d2['params']['id']}})['then'](handleEntityNotFound(_0x2df8e9,null))[_0x9764('0x26')](saveUpdates(_0x5732d2['body'],null))['then'](respondWithResult(_0x2df8e9,null))[_0x9764('0x4b')](handleError(_0x2df8e9,null));};exports['destroy']=function(_0x3fb070,_0x30423b){return db[_0x9764('0x43')][_0x9764('0x4a')]({'where':{'id':_0x3fb070[_0x9764('0x47')]['id']}})['then'](handleEntityNotFound(_0x30423b,null))['then'](removeEntity(_0x30423b,null))['catch'](handleError(_0x30423b,null));};exports[_0x9764('0x56')]=function(_0x23ef29,_0x50278c,_0x2bcbff){return db['SquareProject']['find']({'where':{'id':_0x23ef29[_0x9764('0x47')]['id']}})[_0x9764('0x26')](handleEntityNotFound(_0x50278c,null))['then'](function(_0x2ec542){if(_0x2ec542){return _0x2ec542[_0x9764('0x56')](_0x23ef29[_0x9764('0x55')]['ids'],_[_0x9764('0x57')](_0x23ef29['body'],[_0x9764('0x58'),'id'])||{});}})[_0x9764('0x26')](respondWithResult(_0x50278c,null))[_0x9764('0x4b')](handleError(_0x50278c,null));};exports[_0x9764('0x59')]=function(_0x3179c0,_0x24d9b5,_0x38c11b){return db[_0x9764('0x43')]['find']({'where':{'id':_0x3179c0['params']['id']}})[_0x9764('0x26')](handleEntityNotFound(_0x24d9b5,null))['then'](function(_0x3a27ab){if(_0x3a27ab){return _0x3a27ab[_0x9764('0x59')](_0x3179c0[_0x9764('0x34')][_0x9764('0x58')])[_0x9764('0x26')](function(){if(_['isArray'](_0x3179c0[_0x9764('0x34')]['ids'])){for(var _0x85dc1a=0x0;_0x85dc1a<_0x3179c0[_0x9764('0x34')][_0x9764('0x58')][_0x9764('0x39')];_0x85dc1a+=0x1){socket[_0x9764('0x5a')](_0x9764('0x5b'),{'UserId':Number(_0x3179c0['query']['ids'][_0x85dc1a]),'SquareProjectId':Number(_0x3179c0[_0x9764('0x47')]['id'])});}}else{socket['emit'](_0x9764('0x5b'),{'UserId':Number(_0x3179c0['query'][_0x9764('0x58')]),'SquareProjectId':Number(_0x3179c0['params']['id'])});}});}})[_0x9764('0x26')](respondWithStatusCode(_0x24d9b5,null))[_0x9764('0x4b')](handleError(_0x24d9b5,null));};exports[_0x9764('0x5c')]=function(_0x2643b5,_0x4cc0b1,_0x1cc7ad){var _0x57595c={};var _0x9e9d7f={};var _0xa76775;var _0x14ce6c;return db[_0x9764('0x43')]['findOne']({'where':{'id':_0x2643b5['params']['id']}})[_0x9764('0x26')](handleEntityNotFound(_0x4cc0b1,null))[_0x9764('0x26')](function(_0x15dd33){if(_0x15dd33){_0xa76775=_0x15dd33;_0x9e9d7f[_0x9764('0x33')]=_[_0x9764('0x35')](db[_0x9764('0x5d')][_0x9764('0x30')]);_0x9e9d7f[_0x9764('0x34')]=_[_0x9764('0x35')](_0x2643b5[_0x9764('0x34')]);_0x9e9d7f[_0x9764('0x36')]=_[_0x9764('0x49')](_0x9e9d7f[_0x9764('0x33')],_0x9e9d7f['query']);_0x57595c[_0x9764('0x37')]=_[_0x9764('0x49')](_0x9e9d7f[_0x9764('0x33')],qs[_0x9764('0x38')](_0x2643b5[_0x9764('0x34')][_0x9764('0x38')]));_0x57595c['attributes']=_0x57595c[_0x9764('0x37')][_0x9764('0x39')]?_0x57595c[_0x9764('0x37')]:_0x9e9d7f[_0x9764('0x33')];_0x57595c[_0x9764('0x3c')]=qs[_0x9764('0x3d')](_0x2643b5[_0x9764('0x34')][_0x9764('0x3d')]);_0x57595c['where']=qs[_0x9764('0x36')](_[_0x9764('0x3f')](_0x2643b5[_0x9764('0x34')],_0x9e9d7f[_0x9764('0x36')]));if(_0x2643b5[_0x9764('0x34')]['filter']){_0x57595c[_0x9764('0x3e')]=_[_0x9764('0x41')](_0x57595c[_0x9764('0x3e')],{'$or':_[_0x9764('0x2f')](_0x57595c[_0x9764('0x37')],function(_0x38e4d5){var _0x3176d2={};_0x3176d2[_0x38e4d5]={'$like':'%'+_0x2643b5[_0x9764('0x34')][_0x9764('0x40')]+'%'};return _0x3176d2;})});}_0x57595c=_[_0x9764('0x41')]({},_0x57595c,_0x2643b5['options']);return _0xa76775['getUsers'](_0x57595c);}})[_0x9764('0x26')](function(_0x2f61ae){if(_0x2f61ae){_0x14ce6c=_0x2f61ae[_0x9764('0x39')];if(!_0x2643b5[_0x9764('0x34')][_0x9764('0x3a')]('nolimit')){_0x57595c[_0x9764('0x21')]=qs[_0x9764('0x21')](_0x2643b5[_0x9764('0x34')][_0x9764('0x21')]);_0x57595c['offset']=qs['offset'](_0x2643b5['query'][_0x9764('0x20')]);}return _0xa76775[_0x9764('0x5c')](_0x57595c);}})[_0x9764('0x26')](function(_0x298658){if(_0x298658){return _0x298658?{'count':_0x14ce6c,'rows':_0x298658}:null;}})['then'](respondWithResult(_0x4cc0b1,null))['catch'](handleError(_0x4cc0b1,null));};