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 _0x509f=['squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','redis','localhost','socket.io-emitter','./squareProject.socket','register','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','then','SquareProjects','UserProfileResource','destroy','error','stack','name','send','index','rawAttributes','fieldName','model','map','query','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','merge','type','filter','options','SquareProject','includeAll','findAll','show','params','keys','include','find','catch','create','body','user','get','role','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','addUsers','ids','removeUsers','isArray','emit','userSquareProject:remove','getUsers','User','pick','rimraf','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash'];(function(_0x4f50cc,_0xb95ef4){var _0xb188b1=function(_0x1addd4){while(--_0x1addd4){_0x4f50cc['push'](_0x4f50cc['shift']());}};_0xb188b1(++_0xb95ef4);}(_0x509f,0xb8));var _0xf509=function(_0x506803,_0x5dd8d2){_0x506803=_0x506803-0x0;var _0x32f805=_0x509f[_0x506803];return _0x32f805;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xf509('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0xf509('0x1'));var rp=require('request-promise');var moment=require(_0xf509('0x2'));var BPromise=require(_0xf509('0x3'));var Mustache=require(_0xf509('0x4'));var util=require(_0xf509('0x5'));var path=require(_0xf509('0x6'));var sox=require(_0xf509('0x7'));var csv=require(_0xf509('0x8'));var ejs=require(_0xf509('0x9'));var fs=require('fs');var fs_extra=require(_0xf509('0xa'));var _=require(_0xf509('0xb'));var squel=require(_0xf509('0xc'));var crypto=require(_0xf509('0xd'));var jsforce=require(_0xf509('0xe'));var deskjs=require(_0xf509('0xf'));var toCsv=require(_0xf509('0x8'));var querystring=require(_0xf509('0x10'));var Papa=require(_0xf509('0x11'));var Redis=require('ioredis');var authService=require(_0xf509('0x12'));var qs=require(_0xf509('0x13'));var as=require(_0xf509('0x14'));var hardwareService=require(_0xf509('0x15'));var logger=require(_0xf509('0x16'))('api');var utils=require(_0xf509('0x17'));var config=require(_0xf509('0x18'));var licenseUtil=require('../../config/license/util');var db=require(_0xf509('0x19'))['db'];config[_0xf509('0x1a')]=_['defaults'](config['redis'],{'host':_0xf509('0x1b'),'port':0x18eb});var socket=require(_0xf509('0x1c'))(new Redis(config[_0xf509('0x1a')]));require(_0xf509('0x1d'))[_0xf509('0x1e')](socket);function respondWithStatusCode(_0x35d5bd,_0xc9ff18){_0xc9ff18=_0xc9ff18||0xcc;return function(_0x5ef5fa){if(_0x5ef5fa){return _0x35d5bd[_0xf509('0x1f')](_0xc9ff18);}return _0x35d5bd[_0xf509('0x20')](_0xc9ff18)[_0xf509('0x21')]();};}function respondWithResult(_0x476f79,_0x2d91d7){_0x2d91d7=_0x2d91d7||0xc8;return function(_0x548404){if(_0x548404){return _0x476f79[_0xf509('0x20')](_0x2d91d7)[_0xf509('0x22')](_0x548404);}};}function respondWithFilteredResult(_0x4f2d11,_0x58990f){return function(_0x498d8d){if(_0x498d8d){var _0xc53010=typeof _0x58990f[_0xf509('0x23')]===_0xf509('0x24')&&typeof _0x58990f[_0xf509('0x25')]===_0xf509('0x24');var _0x2cf849=_0x498d8d[_0xf509('0x26')];var _0xde2c8f=_0xc53010?0x0:_0x58990f[_0xf509('0x23')];var _0x15b194=_0xc53010?_0x498d8d[_0xf509('0x26')]:_0x58990f['offset']+_0x58990f[_0xf509('0x25')];var _0x5b1b4b;if(_0x15b194>=_0x2cf849){_0x15b194=_0x2cf849;_0x5b1b4b=0xc8;}else{_0x5b1b4b=0xce;}_0x4f2d11[_0xf509('0x20')](_0x5b1b4b);return _0x4f2d11[_0xf509('0x27')](_0xf509('0x28'),_0xde2c8f+'-'+_0x15b194+'/'+_0x2cf849)['json'](_0x498d8d);}return null;};}function patchUpdates(_0x29c7c8){return function(_0x2243c4){try{jsonpatch[_0xf509('0x29')](_0x2243c4,_0x29c7c8,!![]);}catch(_0x419c7f){return BPromise[_0xf509('0x2a')](_0x419c7f);}return _0x2243c4['save']();};}function saveUpdates(_0x556c12,_0x499e75){return function(_0x3cdfec){if(_0x3cdfec){return _0x3cdfec['update'](_0x556c12)['then'](function(_0x296f5f){return _0x296f5f;});}return null;};}function removeEntity(_0x5c4ceb,_0x3f0552){return function(_0x2d13d7){if(_0x2d13d7){return _0x2d13d7['destroy']()[_0xf509('0x2b')](function(){var _0x5db789=_0x2d13d7['get']({'plain':!![]});var _0xcffde6=_0xf509('0x2c');return db[_0xf509('0x2d')][_0xf509('0x2e')]({'where':{'type':_0xcffde6,'resourceId':_0x5db789['id']}})[_0xf509('0x2b')](function(){return _0x2d13d7;});})[_0xf509('0x2b')](function(){_0x5c4ceb[_0xf509('0x20')](0xcc)['end']();});}};}function handleEntityNotFound(_0x2416f6,_0x1489fb){return function(_0x162047){if(!_0x162047){_0x2416f6[_0xf509('0x1f')](0x194);}return _0x162047;};}function handleError(_0x29b5d5,_0x4c3be1){_0x4c3be1=_0x4c3be1||0x1f4;return function(_0x3dbc61){logger[_0xf509('0x2f')](_0x3dbc61[_0xf509('0x30')]);if(_0x3dbc61['name']){delete _0x3dbc61[_0xf509('0x31')];}_0x29b5d5[_0xf509('0x20')](_0x4c3be1)[_0xf509('0x32')](_0x3dbc61);};}exports[_0xf509('0x33')]=function(_0x1cbaa7,_0x9b0f96){var _0x534b91={},_0x18d7a1={},_0x426f1c={'count':0x0,'rows':[]};var _0xb49ed4=_['map'](db['SquareProject'][_0xf509('0x34')],function(_0x5b629f){return{'name':_0x5b629f[_0xf509('0x35')],'type':_0x5b629f['type']['key']};});_0x18d7a1[_0xf509('0x36')]=_[_0xf509('0x37')](_0xb49ed4,_0xf509('0x31'));_0x18d7a1[_0xf509('0x38')]=_['keys'](_0x1cbaa7[_0xf509('0x38')]);_0x18d7a1[_0xf509('0x39')]=_[_0xf509('0x3a')](_0x18d7a1[_0xf509('0x36')],_0x18d7a1[_0xf509('0x38')]);_0x534b91['attributes']=_[_0xf509('0x3a')](_0x18d7a1['model'],qs[_0xf509('0x3b')](_0x1cbaa7[_0xf509('0x38')][_0xf509('0x3b')]));_0x534b91[_0xf509('0x3c')]=_0x534b91['attributes'][_0xf509('0x3d')]?_0x534b91[_0xf509('0x3c')]:_0x18d7a1[_0xf509('0x36')];if(!_0x1cbaa7[_0xf509('0x38')][_0xf509('0x3e')](_0xf509('0x3f'))){_0x534b91[_0xf509('0x25')]=qs[_0xf509('0x25')](_0x1cbaa7[_0xf509('0x38')]['limit']);_0x534b91['offset']=qs[_0xf509('0x23')](_0x1cbaa7['query'][_0xf509('0x23')]);}_0x534b91[_0xf509('0x40')]=qs['sort'](_0x1cbaa7['query'][_0xf509('0x41')]);_0x534b91['where']=qs[_0xf509('0x39')](_['pick'](_0x1cbaa7[_0xf509('0x38')],_0x18d7a1[_0xf509('0x39')]),_0xb49ed4);if(_0x1cbaa7[_0xf509('0x38')]['filter']){_0x534b91[_0xf509('0x42')]=_[_0xf509('0x43')](_0x534b91[_0xf509('0x42')],{'$or':_[_0xf509('0x37')](_0xb49ed4,function(_0x10e495){if(_0x10e495[_0xf509('0x44')]!=='VIRTUAL'){var _0x982274={};_0x982274[_0x10e495['name']]={'$like':'%'+_0x1cbaa7[_0xf509('0x38')][_0xf509('0x45')]+'%'};return _0x982274;}})});}_0x534b91=_[_0xf509('0x43')]({},_0x534b91,_0x1cbaa7[_0xf509('0x46')]);var _0x28a846={'where':_0x534b91[_0xf509('0x42')]};return db[_0xf509('0x47')][_0xf509('0x26')](_0x28a846)[_0xf509('0x2b')](function(_0x58be36){_0x426f1c[_0xf509('0x26')]=_0x58be36;if(_0x1cbaa7[_0xf509('0x38')][_0xf509('0x48')]){_0x534b91['include']=[{'all':!![]}];}return db[_0xf509('0x47')][_0xf509('0x49')](_0x534b91);})[_0xf509('0x2b')](function(_0x2b00c4){_0x426f1c['rows']=_0x2b00c4;return _0x426f1c;})[_0xf509('0x2b')](respondWithFilteredResult(_0x9b0f96,_0x534b91))['catch'](handleError(_0x9b0f96,null));};exports[_0xf509('0x4a')]=function(_0x536268,_0xb9320e){var _0x277c4b={'raw':![],'where':{'id':_0x536268[_0xf509('0x4b')]['id']}},_0x45de8b={};_0x45de8b['model']=_[_0xf509('0x4c')](db[_0xf509('0x47')][_0xf509('0x34')]);_0x45de8b[_0xf509('0x38')]=_[_0xf509('0x4c')](_0x536268[_0xf509('0x38')]);_0x45de8b['filters']=_[_0xf509('0x3a')](_0x45de8b[_0xf509('0x36')],_0x45de8b[_0xf509('0x38')]);_0x277c4b['attributes']=_['intersection'](_0x45de8b[_0xf509('0x36')],qs[_0xf509('0x3b')](_0x536268[_0xf509('0x38')]['fields']));_0x277c4b[_0xf509('0x3c')]=_0x277c4b[_0xf509('0x3c')][_0xf509('0x3d')]?_0x277c4b['attributes']:_0x45de8b['model'];if(_0x536268[_0xf509('0x38')][_0xf509('0x48')]){_0x277c4b[_0xf509('0x4d')]=[{'all':!![]}];}_0x277c4b=_[_0xf509('0x43')]({},_0x277c4b,_0x536268[_0xf509('0x46')]);return db[_0xf509('0x47')][_0xf509('0x4e')](_0x277c4b)[_0xf509('0x2b')](handleEntityNotFound(_0xb9320e,null))['then'](respondWithResult(_0xb9320e,null))[_0xf509('0x4f')](handleError(_0xb9320e,null));};exports[_0xf509('0x50')]=function(_0x2e2761,_0x32feb3){return db[_0xf509('0x47')][_0xf509('0x50')](_0x2e2761[_0xf509('0x51')],{})[_0xf509('0x2b')](function(_0x3a0cc5){var _0x2d9128=_0x2e2761[_0xf509('0x52')][_0xf509('0x53')]({'plain':!![]});if(!_0x2d9128)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x2d9128[_0xf509('0x54')]===_0xf509('0x52')){var _0x2751e2=_0x3a0cc5[_0xf509('0x53')]({'plain':!![]});var _0x1fa9a8=_0xf509('0x2c');return db[_0xf509('0x55')]['find']({'where':{'name':_0x1fa9a8,'userProfileId':_0x2d9128[_0xf509('0x56')]},'raw':!![]})[_0xf509('0x2b')](function(_0x538f0b){if(_0x538f0b&&_0x538f0b['autoAssociation']===0x0){return db[_0xf509('0x2d')][_0xf509('0x50')]({'name':_0x2751e2[_0xf509('0x31')],'resourceId':_0x2751e2['id'],'type':_0x538f0b[_0xf509('0x31')],'sectionId':_0x538f0b['id']},{})[_0xf509('0x2b')](function(){return _0x3a0cc5;});}else{return _0x3a0cc5;}})[_0xf509('0x4f')](function(_0x1f40a0){logger[_0xf509('0x2f')](_0xf509('0x57'),_0x1f40a0);throw _0x1f40a0;});}return _0x3a0cc5;})[_0xf509('0x2b')](respondWithResult(_0x32feb3,0xc9))['catch'](handleError(_0x32feb3,null));};exports[_0xf509('0x58')]=function(_0x166cb4,_0x24e435){if(_0x166cb4['body']['id']){delete _0x166cb4[_0xf509('0x51')]['id'];}return db[_0xf509('0x47')][_0xf509('0x4e')]({'where':{'id':_0x166cb4[_0xf509('0x4b')]['id']}})[_0xf509('0x2b')](handleEntityNotFound(_0x24e435,null))['then'](saveUpdates(_0x166cb4[_0xf509('0x51')],null))[_0xf509('0x2b')](respondWithResult(_0x24e435,null))[_0xf509('0x4f')](handleError(_0x24e435,null));};exports[_0xf509('0x2e')]=function(_0x4c9e3e,_0x4dfb38){return db['SquareProject'][_0xf509('0x4e')]({'where':{'id':_0x4c9e3e['params']['id']}})[_0xf509('0x2b')](handleEntityNotFound(_0x4dfb38,null))[_0xf509('0x2b')](removeEntity(_0x4dfb38,null))[_0xf509('0x4f')](handleError(_0x4dfb38,null));};exports[_0xf509('0x59')]=function(_0x1675d7,_0x1a31f0,_0x1ec08c){return db[_0xf509('0x47')][_0xf509('0x4e')]({'where':{'id':_0x1675d7['params']['id']}})[_0xf509('0x2b')](handleEntityNotFound(_0x1a31f0,null))[_0xf509('0x2b')](function(_0xe5090b){if(_0xe5090b){return _0xe5090b[_0xf509('0x59')](_0x1675d7[_0xf509('0x51')]['ids'],_['omit'](_0x1675d7[_0xf509('0x51')],[_0xf509('0x5a'),'id'])||{});}})[_0xf509('0x2b')](respondWithResult(_0x1a31f0,null))[_0xf509('0x4f')](handleError(_0x1a31f0,null));};exports[_0xf509('0x5b')]=function(_0x20842f,_0x13ebe5,_0x4e100c){return db[_0xf509('0x47')]['find']({'where':{'id':_0x20842f[_0xf509('0x4b')]['id']}})['then'](handleEntityNotFound(_0x13ebe5,null))[_0xf509('0x2b')](function(_0x457a43){if(_0x457a43){return _0x457a43[_0xf509('0x5b')](_0x20842f[_0xf509('0x38')][_0xf509('0x5a')])['then'](function(){if(_[_0xf509('0x5c')](_0x20842f['query'][_0xf509('0x5a')])){for(var _0x24b59e=0x0;_0x24b59e<_0x20842f[_0xf509('0x38')][_0xf509('0x5a')][_0xf509('0x3d')];_0x24b59e+=0x1){socket[_0xf509('0x5d')](_0xf509('0x5e'),{'UserId':Number(_0x20842f[_0xf509('0x38')][_0xf509('0x5a')][_0x24b59e]),'SquareProjectId':Number(_0x20842f[_0xf509('0x4b')]['id'])});}}else{socket[_0xf509('0x5d')]('userSquareProject:remove',{'UserId':Number(_0x20842f['query'][_0xf509('0x5a')]),'SquareProjectId':Number(_0x20842f[_0xf509('0x4b')]['id'])});}});}})[_0xf509('0x2b')](respondWithStatusCode(_0x13ebe5,null))['catch'](handleError(_0x13ebe5,null));};exports[_0xf509('0x5f')]=function(_0x174c10,_0x3062e2,_0x428c32){var _0x61bbde={};var _0x2e7ed3={};var _0x40338c;var _0x329f9e;return db[_0xf509('0x47')]['findOne']({'where':{'id':_0x174c10[_0xf509('0x4b')]['id']}})['then'](handleEntityNotFound(_0x3062e2,null))[_0xf509('0x2b')](function(_0xe80f2d){if(_0xe80f2d){_0x40338c=_0xe80f2d;_0x2e7ed3['model']=_[_0xf509('0x4c')](db[_0xf509('0x60')]['rawAttributes']);_0x2e7ed3[_0xf509('0x38')]=_[_0xf509('0x4c')](_0x174c10[_0xf509('0x38')]);_0x2e7ed3['filters']=_['intersection'](_0x2e7ed3[_0xf509('0x36')],_0x2e7ed3[_0xf509('0x38')]);_0x61bbde['attributes']=_['intersection'](_0x2e7ed3[_0xf509('0x36')],qs[_0xf509('0x3b')](_0x174c10[_0xf509('0x38')]['fields']));_0x61bbde[_0xf509('0x3c')]=_0x61bbde[_0xf509('0x3c')][_0xf509('0x3d')]?_0x61bbde[_0xf509('0x3c')]:_0x2e7ed3[_0xf509('0x36')];_0x61bbde[_0xf509('0x40')]=qs['sort'](_0x174c10['query']['sort']);_0x61bbde[_0xf509('0x42')]=qs[_0xf509('0x39')](_[_0xf509('0x61')](_0x174c10[_0xf509('0x38')],_0x2e7ed3[_0xf509('0x39')]));if(_0x174c10['query'][_0xf509('0x45')]){_0x61bbde['where']=_['merge'](_0x61bbde['where'],{'$or':_[_0xf509('0x37')](_0x61bbde['attributes'],function(_0x4c35b3){var _0x1bf52a={};_0x1bf52a[_0x4c35b3]={'$like':'%'+_0x174c10[_0xf509('0x38')][_0xf509('0x45')]+'%'};return _0x1bf52a;})});}_0x61bbde=_[_0xf509('0x43')]({},_0x61bbde,_0x174c10['options']);return _0x40338c[_0xf509('0x5f')](_0x61bbde);}})[_0xf509('0x2b')](function(_0x4ae6d9){if(_0x4ae6d9){_0x329f9e=_0x4ae6d9[_0xf509('0x3d')];if(!_0x174c10['query'][_0xf509('0x3e')](_0xf509('0x3f'))){_0x61bbde['limit']=qs['limit'](_0x174c10[_0xf509('0x38')]['limit']);_0x61bbde[_0xf509('0x23')]=qs[_0xf509('0x23')](_0x174c10['query']['offset']);}return _0x40338c['getUsers'](_0x61bbde);}})[_0xf509('0x2b')](function(_0x12b567){if(_0x12b567){return _0x12b567?{'count':_0x329f9e,'rows':_0x12b567}:null;}})[_0xf509('0x2b')](respondWithResult(_0x3062e2,null))[_0xf509('0x4f')](handleError(_0x3062e2,null));};