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 _0x646b=['attributes','model','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','VIRTUAL','filter','merge','includeAll','findAll','params','fields','include','options','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','SquareProjects','UserProfileSection','find','userProfileId','addUsers','ids','removeUsers','isArray','userSquareProject:remove','emit','getUsers','findOne','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','sox','to-csv','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./squareProject.socket','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','reject','save','update','then','destroy','get','UserProfileResource','error','stack','name','index','map','SquareProject','rawAttributes','fieldName','type','key','keys','query','intersection'];(function(_0x149f8c,_0x3267bd){var _0x5d6ddd=function(_0x337aeb){while(--_0x337aeb){_0x149f8c['push'](_0x149f8c['shift']());}};_0x5d6ddd(++_0x3267bd);}(_0x646b,0x85));var _0xb646=function(_0x6acb69,_0xd36dbf){_0x6acb69=_0x6acb69-0x0;var _0x29a021=_0x646b[_0x6acb69];return _0x29a021;};'use strict';var pdf=require(_0xb646('0x0'));var emlformat=require(_0xb646('0x1'));var rimraf=require(_0xb646('0x2'));var zipdir=require(_0xb646('0x3'));var jsonpatch=require(_0xb646('0x4'));var rp=require(_0xb646('0x5'));var moment=require(_0xb646('0x6'));var BPromise=require(_0xb646('0x7'));var Mustache=require(_0xb646('0x8'));var util=require('util');var path=require('path');var sox=require(_0xb646('0x9'));var csv=require(_0xb646('0xa'));var ejs=require('ejs');var fs=require('fs');var _=require(_0xb646('0xb'));var squel=require(_0xb646('0xc'));var crypto=require(_0xb646('0xd'));var jsforce=require(_0xb646('0xe'));var deskjs=require(_0xb646('0xf'));var toCsv=require(_0xb646('0xa'));var querystring=require(_0xb646('0x10'));var Papa=require(_0xb646('0x11'));var Redis=require(_0xb646('0x12'));var authService=require(_0xb646('0x13'));var qs=require(_0xb646('0x14'));var as=require(_0xb646('0x15'));var hardwareService=require(_0xb646('0x16'));var logger=require(_0xb646('0x17'))('api');var utils=require(_0xb646('0x18'));var config=require('../../config/environment');var db=require(_0xb646('0x19'))['db'];config[_0xb646('0x1a')]=_[_0xb646('0x1b')](config[_0xb646('0x1a')],{'host':_0xb646('0x1c'),'port':0x18eb});var socket=require(_0xb646('0x1d'))(new Redis(config['redis']));require(_0xb646('0x1e'))['register'](socket);function respondWithStatusCode(_0x22cbee,_0x467e6c){_0x467e6c=_0x467e6c||0xcc;return function(_0x2b91dd){if(_0x2b91dd){return _0x22cbee[_0xb646('0x1f')](_0x467e6c);}return _0x22cbee[_0xb646('0x20')](_0x467e6c)[_0xb646('0x21')]();};}function respondWithResult(_0x3da72b,_0x4299ee){_0x4299ee=_0x4299ee||0xc8;return function(_0x166916){if(_0x166916){return _0x3da72b[_0xb646('0x20')](_0x4299ee)[_0xb646('0x22')](_0x166916);}};}function respondWithFilteredResult(_0x4d118e,_0x2a93c3){return function(_0x24023f){if(_0x24023f){var _0x9eb244=_0x24023f[_0xb646('0x23')],_0xb0f3d6=_0x2a93c3[_0xb646('0x24')],_0x383b30=_0x2a93c3[_0xb646('0x24')]+_0x2a93c3[_0xb646('0x25')],_0x167530;if(_0x383b30>=_0x9eb244){_0x383b30=_0x9eb244;_0x167530=0xc8;}else{_0x167530=0xce;}_0x4d118e[_0xb646('0x20')](_0x167530);return _0x4d118e[_0xb646('0x26')](_0xb646('0x27'),_0xb0f3d6+'-'+_0x383b30+'/'+_0x9eb244)[_0xb646('0x22')](_0x24023f);}return null;};}function patchUpdates(_0x44e2e8){return function(_0x403ee8){try{jsonpatch[_0xb646('0x28')](_0x403ee8,_0x44e2e8,!![]);}catch(_0x498e05){return BPromise[_0xb646('0x29')](_0x498e05);}return _0x403ee8[_0xb646('0x2a')]();};}function saveUpdates(_0x2ddae5,_0x5018c2){return function(_0x17ed5){if(_0x17ed5){return _0x17ed5[_0xb646('0x2b')](_0x2ddae5)[_0xb646('0x2c')](function(_0xa64268){return _0xa64268;});}return null;};}function removeEntity(_0x57092b,_0x1964a0){return function(_0x3f3039){if(_0x3f3039){return _0x3f3039[_0xb646('0x2d')]()[_0xb646('0x2c')](function(){var _0x4c9a70=_0x3f3039[_0xb646('0x2e')]({'plain':!![]});var _0x13fff2='SquareProjects';return db[_0xb646('0x2f')]['destroy']({'where':{'type':_0x13fff2,'resourceId':_0x4c9a70['id']}})[_0xb646('0x2c')](function(){return _0x3f3039;});})[_0xb646('0x2c')](function(){_0x57092b[_0xb646('0x20')](0xcc)[_0xb646('0x21')]();});}};}function handleEntityNotFound(_0x3b47bc,_0x5414a6){return function(_0x13a410){if(!_0x13a410){_0x3b47bc['sendStatus'](0x194);}return _0x13a410;};}function handleError(_0x51d179,_0x2e318c){_0x2e318c=_0x2e318c||0x1f4;return function(_0x2fb208){logger[_0xb646('0x30')](_0x2fb208[_0xb646('0x31')]);if(_0x2fb208[_0xb646('0x32')]){delete _0x2fb208[_0xb646('0x32')];}_0x51d179[_0xb646('0x20')](_0x2e318c)['send'](_0x2fb208);};}exports[_0xb646('0x33')]=function(_0x1c60b3,_0xbee3b5){var _0x2ae4a6={},_0x359a44={},_0x2b9cd5={'count':0x0,'rows':[]};var _0x2432a1=_[_0xb646('0x34')](db[_0xb646('0x35')][_0xb646('0x36')],function(_0x4f7bc7){return{'name':_0x4f7bc7[_0xb646('0x37')],'type':_0x4f7bc7[_0xb646('0x38')][_0xb646('0x39')]};});_0x359a44['model']=_[_0xb646('0x34')](_0x2432a1,'name');_0x359a44['query']=_[_0xb646('0x3a')](_0x1c60b3[_0xb646('0x3b')]);_0x359a44['filters']=_[_0xb646('0x3c')](_0x359a44['model'],_0x359a44[_0xb646('0x3b')]);_0x2ae4a6[_0xb646('0x3d')]=_['intersection'](_0x359a44[_0xb646('0x3e')],qs['fields'](_0x1c60b3[_0xb646('0x3b')]['fields']));_0x2ae4a6[_0xb646('0x3d')]=_0x2ae4a6[_0xb646('0x3d')][_0xb646('0x3f')]?_0x2ae4a6[_0xb646('0x3d')]:_0x359a44[_0xb646('0x3e')];if(!_0x1c60b3[_0xb646('0x3b')][_0xb646('0x40')](_0xb646('0x41'))){_0x2ae4a6[_0xb646('0x25')]=qs[_0xb646('0x25')](_0x1c60b3[_0xb646('0x3b')]['limit']);_0x2ae4a6['offset']=qs['offset'](_0x1c60b3[_0xb646('0x3b')][_0xb646('0x24')]);}_0x2ae4a6[_0xb646('0x42')]=qs[_0xb646('0x43')](_0x1c60b3['query']['sort']);_0x2ae4a6[_0xb646('0x44')]=qs[_0xb646('0x45')](_[_0xb646('0x46')](_0x1c60b3[_0xb646('0x3b')],_0x359a44[_0xb646('0x45')]),_0x2432a1);if(_0x1c60b3[_0xb646('0x3b')]['filter']){_0x2ae4a6['where']=_['merge'](_0x2ae4a6['where'],{'$or':_[_0xb646('0x34')](_0x2432a1,function(_0x1f79f1){if(_0x1f79f1[_0xb646('0x38')]!==_0xb646('0x47')){var _0x1e6c78={};_0x1e6c78[_0x1f79f1[_0xb646('0x32')]]={'$like':'%'+_0x1c60b3['query'][_0xb646('0x48')]+'%'};return _0x1e6c78;}})});}_0x2ae4a6=_[_0xb646('0x49')]({},_0x2ae4a6,_0x1c60b3['options']);var _0x4741ea={'where':_0x2ae4a6[_0xb646('0x44')]};return db[_0xb646('0x35')][_0xb646('0x23')](_0x4741ea)[_0xb646('0x2c')](function(_0x577a84){_0x2b9cd5[_0xb646('0x23')]=_0x577a84;if(_0x1c60b3[_0xb646('0x3b')][_0xb646('0x4a')]){_0x2ae4a6['include']=[{'all':!![]}];}return db[_0xb646('0x35')][_0xb646('0x4b')](_0x2ae4a6);})[_0xb646('0x2c')](function(_0x342ef9){_0x2b9cd5['rows']=_0x342ef9;return _0x2b9cd5;})[_0xb646('0x2c')](respondWithFilteredResult(_0xbee3b5,_0x2ae4a6))['catch'](handleError(_0xbee3b5,null));};exports['show']=function(_0x5e2426,_0x3266c7){var _0x38e765={'raw':![],'where':{'id':_0x5e2426[_0xb646('0x4c')]['id']}},_0x51a541={};_0x51a541['model']=_[_0xb646('0x3a')](db[_0xb646('0x35')]['rawAttributes']);_0x51a541['query']=_[_0xb646('0x3a')](_0x5e2426['query']);_0x51a541[_0xb646('0x45')]=_['intersection'](_0x51a541[_0xb646('0x3e')],_0x51a541[_0xb646('0x3b')]);_0x38e765[_0xb646('0x3d')]=_[_0xb646('0x3c')](_0x51a541[_0xb646('0x3e')],qs[_0xb646('0x4d')](_0x5e2426[_0xb646('0x3b')]['fields']));_0x38e765[_0xb646('0x3d')]=_0x38e765['attributes']['length']?_0x38e765['attributes']:_0x51a541['model'];if(_0x5e2426[_0xb646('0x3b')][_0xb646('0x4a')]){_0x38e765[_0xb646('0x4e')]=[{'all':!![]}];}_0x38e765=_['merge']({},_0x38e765,_0x5e2426[_0xb646('0x4f')]);return db[_0xb646('0x35')]['find'](_0x38e765)[_0xb646('0x2c')](handleEntityNotFound(_0x3266c7,null))[_0xb646('0x2c')](respondWithResult(_0x3266c7,null))[_0xb646('0x50')](handleError(_0x3266c7,null));};exports['create']=function(_0xcbef51,_0x4ed7d0){return db['SquareProject'][_0xb646('0x51')](_0xcbef51[_0xb646('0x52')],{})[_0xb646('0x2c')](function(_0x2a8224){var _0x2c98f3=_0xcbef51[_0xb646('0x53')][_0xb646('0x2e')]({'plain':!![]});if(!_0x2c98f3)throw new Error(_0xb646('0x54'));if(_0x2c98f3['role']===_0xb646('0x53')){var _0x2b4e56=_0x2a8224['get']({'plain':!![]});var _0xb029f1=_0xb646('0x55');return db[_0xb646('0x56')][_0xb646('0x57')]({'where':{'name':_0xb029f1,'userProfileId':_0x2c98f3[_0xb646('0x58')]},'raw':!![]})[_0xb646('0x2c')](function(_0x4f5ad7){if(_0x4f5ad7&&_0x4f5ad7['autoAssociation']===0x0){return db[_0xb646('0x2f')][_0xb646('0x51')]({'name':_0x2b4e56['name'],'resourceId':_0x2b4e56['id'],'type':_0x4f5ad7['name'],'sectionId':_0x4f5ad7['id']},{})[_0xb646('0x2c')](function(){return _0x2a8224;});}else{return _0x2a8224;}})['catch'](function(_0xf96a26){logger[_0xb646('0x30')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0xf96a26);throw _0xf96a26;});}return _0x2a8224;})[_0xb646('0x2c')](respondWithResult(_0x4ed7d0,0xc9))[_0xb646('0x50')](handleError(_0x4ed7d0,null));};exports[_0xb646('0x2b')]=function(_0x4200ca,_0x5902db){if(_0x4200ca[_0xb646('0x52')]['id']){delete _0x4200ca['body']['id'];}return db[_0xb646('0x35')][_0xb646('0x57')]({'where':{'id':_0x4200ca[_0xb646('0x4c')]['id']}})[_0xb646('0x2c')](handleEntityNotFound(_0x5902db,null))[_0xb646('0x2c')](saveUpdates(_0x4200ca[_0xb646('0x52')],null))['then'](respondWithResult(_0x5902db,null))['catch'](handleError(_0x5902db,null));};exports['destroy']=function(_0x3ef81a,_0x47f5cc){return db[_0xb646('0x35')]['find']({'where':{'id':_0x3ef81a[_0xb646('0x4c')]['id']}})['then'](handleEntityNotFound(_0x47f5cc,null))[_0xb646('0x2c')](removeEntity(_0x47f5cc,null))['catch'](handleError(_0x47f5cc,null));};exports[_0xb646('0x59')]=function(_0x3b24c4,_0x1b3d7f,_0x1c17c9){return db['SquareProject']['find']({'where':{'id':_0x3b24c4[_0xb646('0x4c')]['id']}})[_0xb646('0x2c')](handleEntityNotFound(_0x1b3d7f,null))['then'](function(_0x711c1d){if(_0x711c1d){return _0x711c1d[_0xb646('0x59')](_0x3b24c4[_0xb646('0x52')][_0xb646('0x5a')],_['omit'](_0x3b24c4['body'],['ids','id'])||{});}})[_0xb646('0x2c')](respondWithResult(_0x1b3d7f,null))[_0xb646('0x50')](handleError(_0x1b3d7f,null));};exports[_0xb646('0x5b')]=function(_0x2f8279,_0x3d30af,_0x2d50f5){return db['SquareProject'][_0xb646('0x57')]({'where':{'id':_0x2f8279[_0xb646('0x4c')]['id']}})[_0xb646('0x2c')](handleEntityNotFound(_0x3d30af,null))[_0xb646('0x2c')](function(_0x33aa4e){if(_0x33aa4e){return _0x33aa4e[_0xb646('0x5b')](_0x2f8279[_0xb646('0x3b')][_0xb646('0x5a')])[_0xb646('0x2c')](function(){if(_[_0xb646('0x5c')](_0x2f8279[_0xb646('0x3b')][_0xb646('0x5a')])){for(var _0x2b813b=0x0;_0x2b813b<_0x2f8279[_0xb646('0x3b')][_0xb646('0x5a')]['length'];_0x2b813b+=0x1){socket['emit'](_0xb646('0x5d'),{'UserId':Number(_0x2f8279[_0xb646('0x3b')]['ids'][_0x2b813b]),'SquareProjectId':Number(_0x2f8279[_0xb646('0x4c')]['id'])});}}else{socket[_0xb646('0x5e')](_0xb646('0x5d'),{'UserId':Number(_0x2f8279[_0xb646('0x3b')][_0xb646('0x5a')]),'SquareProjectId':Number(_0x2f8279[_0xb646('0x4c')]['id'])});}});}})[_0xb646('0x2c')](respondWithStatusCode(_0x3d30af,null))['catch'](handleError(_0x3d30af,null));};exports[_0xb646('0x5f')]=function(_0x40ac05,_0x4708c6,_0x3e80ff){var _0x44816b={};var _0x354f6f={};var _0x59154d;var _0x71f22;return db[_0xb646('0x35')][_0xb646('0x60')]({'where':{'id':_0x40ac05[_0xb646('0x4c')]['id']}})[_0xb646('0x2c')](handleEntityNotFound(_0x4708c6,null))[_0xb646('0x2c')](function(_0x21944f){if(_0x21944f){_0x59154d=_0x21944f;_0x354f6f[_0xb646('0x3e')]=_[_0xb646('0x3a')](db['User'][_0xb646('0x36')]);_0x354f6f[_0xb646('0x3b')]=_[_0xb646('0x3a')](_0x40ac05[_0xb646('0x3b')]);_0x354f6f['filters']=_[_0xb646('0x3c')](_0x354f6f[_0xb646('0x3e')],_0x354f6f[_0xb646('0x3b')]);_0x44816b['attributes']=_['intersection'](_0x354f6f[_0xb646('0x3e')],qs[_0xb646('0x4d')](_0x40ac05[_0xb646('0x3b')]['fields']));_0x44816b[_0xb646('0x3d')]=_0x44816b[_0xb646('0x3d')][_0xb646('0x3f')]?_0x44816b[_0xb646('0x3d')]:_0x354f6f[_0xb646('0x3e')];_0x44816b[_0xb646('0x42')]=qs['sort'](_0x40ac05[_0xb646('0x3b')][_0xb646('0x43')]);_0x44816b['where']=qs[_0xb646('0x45')](_['pick'](_0x40ac05['query'],_0x354f6f[_0xb646('0x45')]));if(_0x40ac05['query'][_0xb646('0x48')]){_0x44816b['where']=_[_0xb646('0x49')](_0x44816b[_0xb646('0x44')],{'$or':_[_0xb646('0x34')](_0x44816b[_0xb646('0x3d')],function(_0x141229){var _0x17e314={};_0x17e314[_0x141229]={'$like':'%'+_0x40ac05[_0xb646('0x3b')][_0xb646('0x48')]+'%'};return _0x17e314;})});}_0x44816b=_[_0xb646('0x49')]({},_0x44816b,_0x40ac05['options']);return _0x59154d[_0xb646('0x5f')](_0x44816b);}})[_0xb646('0x2c')](function(_0x41fa35){if(_0x41fa35){_0x71f22=_0x41fa35[_0xb646('0x3f')];if(!_0x40ac05[_0xb646('0x3b')][_0xb646('0x40')]('nolimit')){_0x44816b[_0xb646('0x25')]=qs[_0xb646('0x25')](_0x40ac05[_0xb646('0x3b')][_0xb646('0x25')]);_0x44816b[_0xb646('0x24')]=qs['offset'](_0x40ac05[_0xb646('0x3b')][_0xb646('0x24')]);}return _0x59154d['getUsers'](_0x44816b);}})['then'](function(_0x335008){if(_0x335008){return _0x335008?{'count':_0x71f22,'rows':_0x335008}:null;}})[_0xb646('0x2c')](respondWithResult(_0x4708c6,null))[_0xb646('0x50')](handleError(_0x4708c6,null));};