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 _0x0b2a=['filter','options','includeAll','findAll','catch','show','length','include','find','create','user','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','params','addUsers','ids','removeUsers','isArray','emit','userSquareProject:remove','findOne','User','pick','getUsers','nolimit','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','api','../../config/utils','../../config/environment','redis','defaults','socket.io-emitter','./squareProject.socket','status','end','json','count','offset','limit','set','reject','save','update','then','get','SquareProjects','destroy','error','stack','name','send','index','map','SquareProject','rawAttributes','fieldName','type','key','model','query','keys','intersection','fields','attributes','hasOwnProperty','order','sort','where','filters','merge'];(function(_0x2b5dab,_0x292954){var _0xbd0978=function(_0x23bfbb){while(--_0x23bfbb){_0x2b5dab['push'](_0x2b5dab['shift']());}};_0xbd0978(++_0x292954);}(_0x0b2a,0xd3));var _0xa0b2=function(_0x96635c,_0x2e12aa){_0x96635c=_0x96635c-0x0;var _0x47d76f=_0x0b2a[_0x96635c];return _0x47d76f;};'use strict';var pdf=require(_0xa0b2('0x0'));var emlformat=require(_0xa0b2('0x1'));var rimraf=require(_0xa0b2('0x2'));var zipdir=require(_0xa0b2('0x3'));var jsonpatch=require(_0xa0b2('0x4'));var rp=require(_0xa0b2('0x5'));var moment=require('moment');var BPromise=require(_0xa0b2('0x6'));var Mustache=require(_0xa0b2('0x7'));var util=require(_0xa0b2('0x8'));var path=require(_0xa0b2('0x9'));var sox=require(_0xa0b2('0xa'));var csv=require(_0xa0b2('0xb'));var ejs=require('ejs');var fs=require('fs');var _=require(_0xa0b2('0xc'));var squel=require(_0xa0b2('0xd'));var crypto=require(_0xa0b2('0xe'));var jsforce=require('jsforce');var deskjs=require(_0xa0b2('0xf'));var toCsv=require(_0xa0b2('0xb'));var querystring=require(_0xa0b2('0x10'));var Papa=require(_0xa0b2('0x11'));var Redis=require(_0xa0b2('0x12'));var authService=require(_0xa0b2('0x13'));var qs=require(_0xa0b2('0x14'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xa0b2('0x15'));var utils=require(_0xa0b2('0x16'));var config=require(_0xa0b2('0x17'));var db=require('../../mysqldb')['db'];config[_0xa0b2('0x18')]=_[_0xa0b2('0x19')](config[_0xa0b2('0x18')],{'host':'localhost','port':0x18eb});var socket=require(_0xa0b2('0x1a'))(new Redis(config[_0xa0b2('0x18')]));require(_0xa0b2('0x1b'))['register'](socket);function respondWithStatusCode(_0x2dd006,_0xf36a05){_0xf36a05=_0xf36a05||0xcc;return function(_0x2b3bf9){if(_0x2b3bf9){return _0x2dd006['sendStatus'](_0xf36a05);}return _0x2dd006[_0xa0b2('0x1c')](_0xf36a05)[_0xa0b2('0x1d')]();};}function respondWithResult(_0x56fb72,_0x1acb9b){_0x1acb9b=_0x1acb9b||0xc8;return function(_0x34dc62){if(_0x34dc62){return _0x56fb72['status'](_0x1acb9b)[_0xa0b2('0x1e')](_0x34dc62);}};}function respondWithFilteredResult(_0x7193a8,_0x385fa6){return function(_0x31be97){if(_0x31be97){var _0x576a19=_0x31be97[_0xa0b2('0x1f')],_0x45c447=_0x385fa6[_0xa0b2('0x20')],_0x306f9a=_0x385fa6['offset']+_0x385fa6[_0xa0b2('0x21')],_0x720958;if(_0x306f9a>=_0x576a19){_0x306f9a=_0x576a19;_0x720958=0xc8;}else{_0x720958=0xce;}_0x7193a8['status'](_0x720958);return _0x7193a8[_0xa0b2('0x22')]('Content-Range',_0x45c447+'-'+_0x306f9a+'/'+_0x576a19)[_0xa0b2('0x1e')](_0x31be97);}return null;};}function patchUpdates(_0xac7baa){return function(_0x3d60c0){try{jsonpatch['apply'](_0x3d60c0,_0xac7baa,!![]);}catch(_0x2a4875){return BPromise[_0xa0b2('0x23')](_0x2a4875);}return _0x3d60c0[_0xa0b2('0x24')]();};}function saveUpdates(_0x10509b,_0x2789b4){return function(_0x37e5c9){if(_0x37e5c9){return _0x37e5c9[_0xa0b2('0x25')](_0x10509b)['then'](function(_0x4b64d4){return _0x4b64d4;});}return null;};}function removeEntity(_0x4427c9,_0x478bb8){return function(_0x2aa194){if(_0x2aa194){return _0x2aa194['destroy']()[_0xa0b2('0x26')](function(){var _0x35b698=_0x2aa194[_0xa0b2('0x27')]({'plain':!![]});var _0x5507f7=_0xa0b2('0x28');return db['UserProfileResource'][_0xa0b2('0x29')]({'where':{'type':_0x5507f7,'resourceId':_0x35b698['id']}})[_0xa0b2('0x26')](function(){return _0x2aa194;});})['then'](function(){_0x4427c9[_0xa0b2('0x1c')](0xcc)[_0xa0b2('0x1d')]();});}};}function handleEntityNotFound(_0x418671,_0xc71c45){return function(_0x33a2a2){if(!_0x33a2a2){_0x418671['sendStatus'](0x194);}return _0x33a2a2;};}function handleError(_0x43e1c2,_0x5035d1){_0x5035d1=_0x5035d1||0x1f4;return function(_0x135288){logger[_0xa0b2('0x2a')](_0x135288[_0xa0b2('0x2b')]);if(_0x135288[_0xa0b2('0x2c')]){delete _0x135288[_0xa0b2('0x2c')];}_0x43e1c2[_0xa0b2('0x1c')](_0x5035d1)[_0xa0b2('0x2d')](_0x135288);};}exports[_0xa0b2('0x2e')]=function(_0x37f079,_0x5e33ca){var _0x1ef99f={},_0x49b7a3={},_0x1132b7={'count':0x0,'rows':[]};var _0x400091=_[_0xa0b2('0x2f')](db[_0xa0b2('0x30')][_0xa0b2('0x31')],function(_0x3d403b){return{'name':_0x3d403b[_0xa0b2('0x32')],'type':_0x3d403b[_0xa0b2('0x33')][_0xa0b2('0x34')]};});_0x49b7a3[_0xa0b2('0x35')]=_['map'](_0x400091,_0xa0b2('0x2c'));_0x49b7a3[_0xa0b2('0x36')]=_[_0xa0b2('0x37')](_0x37f079[_0xa0b2('0x36')]);_0x49b7a3['filters']=_[_0xa0b2('0x38')](_0x49b7a3['model'],_0x49b7a3[_0xa0b2('0x36')]);_0x1ef99f['attributes']=_['intersection'](_0x49b7a3[_0xa0b2('0x35')],qs[_0xa0b2('0x39')](_0x37f079[_0xa0b2('0x36')][_0xa0b2('0x39')]));_0x1ef99f['attributes']=_0x1ef99f[_0xa0b2('0x3a')]['length']?_0x1ef99f['attributes']:_0x49b7a3[_0xa0b2('0x35')];if(!_0x37f079[_0xa0b2('0x36')][_0xa0b2('0x3b')]('nolimit')){_0x1ef99f[_0xa0b2('0x21')]=qs[_0xa0b2('0x21')](_0x37f079[_0xa0b2('0x36')]['limit']);_0x1ef99f[_0xa0b2('0x20')]=qs[_0xa0b2('0x20')](_0x37f079['query'][_0xa0b2('0x20')]);}_0x1ef99f[_0xa0b2('0x3c')]=qs['sort'](_0x37f079['query'][_0xa0b2('0x3d')]);_0x1ef99f[_0xa0b2('0x3e')]=qs[_0xa0b2('0x3f')](_['pick'](_0x37f079[_0xa0b2('0x36')],_0x49b7a3[_0xa0b2('0x3f')]),_0x400091);if(_0x37f079[_0xa0b2('0x36')]['filter']){_0x1ef99f[_0xa0b2('0x3e')]=_[_0xa0b2('0x40')](_0x1ef99f[_0xa0b2('0x3e')],{'$or':_[_0xa0b2('0x2f')](_0x400091,function(_0x38b0e6){if(_0x38b0e6[_0xa0b2('0x33')]!=='VIRTUAL'){var _0x472a0b={};_0x472a0b[_0x38b0e6[_0xa0b2('0x2c')]]={'$like':'%'+_0x37f079[_0xa0b2('0x36')][_0xa0b2('0x41')]+'%'};return _0x472a0b;}})});}_0x1ef99f=_[_0xa0b2('0x40')]({},_0x1ef99f,_0x37f079[_0xa0b2('0x42')]);var _0x190328={'where':_0x1ef99f[_0xa0b2('0x3e')]};return db[_0xa0b2('0x30')]['count'](_0x190328)['then'](function(_0x5be8eb){_0x1132b7[_0xa0b2('0x1f')]=_0x5be8eb;if(_0x37f079[_0xa0b2('0x36')][_0xa0b2('0x43')]){_0x1ef99f['include']=[{'all':!![]}];}return db[_0xa0b2('0x30')][_0xa0b2('0x44')](_0x1ef99f);})[_0xa0b2('0x26')](function(_0xf73bae){_0x1132b7['rows']=_0xf73bae;return _0x1132b7;})[_0xa0b2('0x26')](respondWithFilteredResult(_0x5e33ca,_0x1ef99f))[_0xa0b2('0x45')](handleError(_0x5e33ca,null));};exports[_0xa0b2('0x46')]=function(_0x445a03,_0x5ab949){var _0x41521d={'raw':![],'where':{'id':_0x445a03['params']['id']}},_0x470137={};_0x470137['model']=_['keys'](db['SquareProject'][_0xa0b2('0x31')]);_0x470137[_0xa0b2('0x36')]=_[_0xa0b2('0x37')](_0x445a03[_0xa0b2('0x36')]);_0x470137[_0xa0b2('0x3f')]=_[_0xa0b2('0x38')](_0x470137[_0xa0b2('0x35')],_0x470137[_0xa0b2('0x36')]);_0x41521d[_0xa0b2('0x3a')]=_[_0xa0b2('0x38')](_0x470137['model'],qs[_0xa0b2('0x39')](_0x445a03[_0xa0b2('0x36')][_0xa0b2('0x39')]));_0x41521d[_0xa0b2('0x3a')]=_0x41521d[_0xa0b2('0x3a')][_0xa0b2('0x47')]?_0x41521d[_0xa0b2('0x3a')]:_0x470137[_0xa0b2('0x35')];if(_0x445a03[_0xa0b2('0x36')][_0xa0b2('0x43')]){_0x41521d[_0xa0b2('0x48')]=[{'all':!![]}];}_0x41521d=_['merge']({},_0x41521d,_0x445a03[_0xa0b2('0x42')]);return db[_0xa0b2('0x30')][_0xa0b2('0x49')](_0x41521d)['then'](handleEntityNotFound(_0x5ab949,null))['then'](respondWithResult(_0x5ab949,null))[_0xa0b2('0x45')](handleError(_0x5ab949,null));};exports[_0xa0b2('0x4a')]=function(_0x573f70,_0x50c4a3){return db[_0xa0b2('0x30')][_0xa0b2('0x4a')](_0x573f70['body'],{})[_0xa0b2('0x26')](function(_0x426816){var _0x2297ae=_0x573f70[_0xa0b2('0x4b')][_0xa0b2('0x27')]({'plain':!![]});if(!_0x2297ae)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x2297ae['role']==='user'){var _0x2c3d74=_0x426816['get']({'plain':!![]});var _0x31b6dc='SquareProjects';return db[_0xa0b2('0x4c')][_0xa0b2('0x49')]({'where':{'name':_0x31b6dc,'userProfileId':_0x2297ae['userProfileId']},'raw':!![]})['then'](function(_0x2c2bc5){if(_0x2c2bc5&&_0x2c2bc5[_0xa0b2('0x4d')]===0x0){return db['UserProfileResource'][_0xa0b2('0x4a')]({'name':_0x2c3d74['name'],'resourceId':_0x2c3d74['id'],'type':_0x2c2bc5[_0xa0b2('0x2c')],'sectionId':_0x2c2bc5['id']},{})[_0xa0b2('0x26')](function(){return _0x426816;});}else{return _0x426816;}})[_0xa0b2('0x45')](function(_0xd37e70){logger[_0xa0b2('0x2a')](_0xa0b2('0x4e'),_0xd37e70);throw _0xd37e70;});}return _0x426816;})['then'](respondWithResult(_0x50c4a3,0xc9))[_0xa0b2('0x45')](handleError(_0x50c4a3,null));};exports[_0xa0b2('0x25')]=function(_0x4935b9,_0x59cbe3){if(_0x4935b9[_0xa0b2('0x4f')]['id']){delete _0x4935b9['body']['id'];}return db[_0xa0b2('0x30')][_0xa0b2('0x49')]({'where':{'id':_0x4935b9[_0xa0b2('0x50')]['id']}})[_0xa0b2('0x26')](handleEntityNotFound(_0x59cbe3,null))[_0xa0b2('0x26')](saveUpdates(_0x4935b9[_0xa0b2('0x4f')],null))[_0xa0b2('0x26')](respondWithResult(_0x59cbe3,null))[_0xa0b2('0x45')](handleError(_0x59cbe3,null));};exports[_0xa0b2('0x29')]=function(_0x3a333d,_0x4af051){return db[_0xa0b2('0x30')]['find']({'where':{'id':_0x3a333d['params']['id']}})[_0xa0b2('0x26')](handleEntityNotFound(_0x4af051,null))[_0xa0b2('0x26')](removeEntity(_0x4af051,null))[_0xa0b2('0x45')](handleError(_0x4af051,null));};exports[_0xa0b2('0x51')]=function(_0x466c4a,_0x33e201,_0x256871){return db[_0xa0b2('0x30')]['find']({'where':{'id':_0x466c4a[_0xa0b2('0x50')]['id']}})[_0xa0b2('0x26')](handleEntityNotFound(_0x33e201,null))[_0xa0b2('0x26')](function(_0x47199a){if(_0x47199a){return _0x47199a['addUsers'](_0x466c4a[_0xa0b2('0x4f')][_0xa0b2('0x52')],_['omit'](_0x466c4a['body'],[_0xa0b2('0x52'),'id'])||{});}})[_0xa0b2('0x26')](respondWithResult(_0x33e201,null))[_0xa0b2('0x45')](handleError(_0x33e201,null));};exports[_0xa0b2('0x53')]=function(_0x3ffa99,_0x3c01cf,_0x2d130f){return db['SquareProject']['find']({'where':{'id':_0x3ffa99[_0xa0b2('0x50')]['id']}})['then'](handleEntityNotFound(_0x3c01cf,null))['then'](function(_0x2458b3){if(_0x2458b3){return _0x2458b3[_0xa0b2('0x53')](_0x3ffa99[_0xa0b2('0x36')][_0xa0b2('0x52')])['then'](function(){if(_[_0xa0b2('0x54')](_0x3ffa99[_0xa0b2('0x36')][_0xa0b2('0x52')])){for(var _0x441a09=0x0;_0x441a09<_0x3ffa99[_0xa0b2('0x36')][_0xa0b2('0x52')][_0xa0b2('0x47')];_0x441a09+=0x1){socket[_0xa0b2('0x55')](_0xa0b2('0x56'),{'UserId':Number(_0x3ffa99[_0xa0b2('0x36')][_0xa0b2('0x52')][_0x441a09]),'SquareProjectId':Number(_0x3ffa99[_0xa0b2('0x50')]['id'])});}}else{socket[_0xa0b2('0x55')]('userSquareProject:remove',{'UserId':Number(_0x3ffa99[_0xa0b2('0x36')][_0xa0b2('0x52')]),'SquareProjectId':Number(_0x3ffa99[_0xa0b2('0x50')]['id'])});}});}})[_0xa0b2('0x26')](respondWithStatusCode(_0x3c01cf,null))[_0xa0b2('0x45')](handleError(_0x3c01cf,null));};exports['getUsers']=function(_0x5d5f68,_0x14beb6,_0x875f0){var _0x23c175={};var _0x58433a={};var _0x2d67cf;var _0x3f648b;return db[_0xa0b2('0x30')][_0xa0b2('0x57')]({'where':{'id':_0x5d5f68[_0xa0b2('0x50')]['id']}})[_0xa0b2('0x26')](handleEntityNotFound(_0x14beb6,null))[_0xa0b2('0x26')](function(_0x204fd6){if(_0x204fd6){_0x2d67cf=_0x204fd6;_0x58433a[_0xa0b2('0x35')]=_[_0xa0b2('0x37')](db[_0xa0b2('0x58')]['rawAttributes']);_0x58433a['query']=_[_0xa0b2('0x37')](_0x5d5f68['query']);_0x58433a[_0xa0b2('0x3f')]=_[_0xa0b2('0x38')](_0x58433a[_0xa0b2('0x35')],_0x58433a['query']);_0x23c175[_0xa0b2('0x3a')]=_[_0xa0b2('0x38')](_0x58433a[_0xa0b2('0x35')],qs[_0xa0b2('0x39')](_0x5d5f68['query']['fields']));_0x23c175['attributes']=_0x23c175[_0xa0b2('0x3a')][_0xa0b2('0x47')]?_0x23c175[_0xa0b2('0x3a')]:_0x58433a[_0xa0b2('0x35')];_0x23c175['order']=qs[_0xa0b2('0x3d')](_0x5d5f68[_0xa0b2('0x36')][_0xa0b2('0x3d')]);_0x23c175[_0xa0b2('0x3e')]=qs[_0xa0b2('0x3f')](_[_0xa0b2('0x59')](_0x5d5f68[_0xa0b2('0x36')],_0x58433a[_0xa0b2('0x3f')]));if(_0x5d5f68[_0xa0b2('0x36')][_0xa0b2('0x41')]){_0x23c175['where']=_[_0xa0b2('0x40')](_0x23c175[_0xa0b2('0x3e')],{'$or':_['map'](_0x23c175[_0xa0b2('0x3a')],function(_0x3aebd0){var _0x2dc417={};_0x2dc417[_0x3aebd0]={'$like':'%'+_0x5d5f68[_0xa0b2('0x36')][_0xa0b2('0x41')]+'%'};return _0x2dc417;})});}_0x23c175=_[_0xa0b2('0x40')]({},_0x23c175,_0x5d5f68[_0xa0b2('0x42')]);return _0x2d67cf[_0xa0b2('0x5a')](_0x23c175);}})[_0xa0b2('0x26')](function(_0x517509){if(_0x517509){_0x3f648b=_0x517509['length'];if(!_0x5d5f68[_0xa0b2('0x36')][_0xa0b2('0x3b')](_0xa0b2('0x5b'))){_0x23c175['limit']=qs[_0xa0b2('0x21')](_0x5d5f68[_0xa0b2('0x36')][_0xa0b2('0x21')]);_0x23c175[_0xa0b2('0x20')]=qs[_0xa0b2('0x20')](_0x5d5f68[_0xa0b2('0x36')]['offset']);}return _0x2d67cf[_0xa0b2('0x5a')](_0x23c175);}})[_0xa0b2('0x26')](function(_0x269ef6){if(_0x269ef6){return _0x269ef6?{'count':_0x3f648b,'rows':_0x269ef6}:null;}})[_0xa0b2('0x26')](respondWithResult(_0x14beb6,null))[_0xa0b2('0x45')](handleError(_0x14beb6,null));};