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 _0x10b9=['include','findAll','rows','catch','show','params','intersection','includeAll','role','user','SquareProjects','find','userProfileId','create','update','body','addUsers','ids','omit','removeUsers','emit','userSquareProject:remove','getUsers','User','order','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','to-csv','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/parsers/advancedSearch','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./squareProject.socket','register','status','end','count','offset','set','Content-Range','apply','reject','save','then','destroy','get','UserProfileResource','error','stack','name','send','index','SquareProject','rawAttributes','fieldName','model','map','query','keys','attributes','fields','length','hasOwnProperty','nolimit','limit','sort','where','filters','pick','filter','merge','type','options'];(function(_0x584043,_0x3f19bc){var _0x2e4ec6=function(_0x138c3b){while(--_0x138c3b){_0x584043['push'](_0x584043['shift']());}};_0x2e4ec6(++_0x3f19bc);}(_0x10b9,0x12d));var _0x910b=function(_0x33a694,_0x9b6640){_0x33a694=_0x33a694-0x0;var _0x41ff01=_0x10b9[_0x33a694];return _0x41ff01;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x910b('0x0'));var rimraf=require(_0x910b('0x1'));var zipdir=require(_0x910b('0x2'));var jsonpatch=require(_0x910b('0x3'));var rp=require(_0x910b('0x4'));var moment=require('moment');var BPromise=require(_0x910b('0x5'));var Mustache=require(_0x910b('0x6'));var util=require(_0x910b('0x7'));var path=require('path');var sox=require('sox');var csv=require(_0x910b('0x8'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x910b('0x9'));var squel=require(_0x910b('0xa'));var crypto=require(_0x910b('0xb'));var jsforce=require(_0x910b('0xc'));var deskjs=require(_0x910b('0xd'));var toCsv=require(_0x910b('0x8'));var querystring=require(_0x910b('0xe'));var Papa=require(_0x910b('0xf'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x910b('0x10'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x910b('0x11'));var utils=require(_0x910b('0x12'));var config=require(_0x910b('0x13'));var licenseUtil=require(_0x910b('0x14'));var db=require(_0x910b('0x15'))['db'];config[_0x910b('0x16')]=_[_0x910b('0x17')](config[_0x910b('0x16')],{'host':_0x910b('0x18'),'port':0x18eb});var socket=require(_0x910b('0x19'))(new Redis(config['redis']));require(_0x910b('0x1a'))[_0x910b('0x1b')](socket);function respondWithStatusCode(_0x14930b,_0x270d9b){_0x270d9b=_0x270d9b||0xcc;return function(_0x3c8a3b){if(_0x3c8a3b){return _0x14930b['sendStatus'](_0x270d9b);}return _0x14930b[_0x910b('0x1c')](_0x270d9b)[_0x910b('0x1d')]();};}function respondWithResult(_0x3a2775,_0x52ca57){_0x52ca57=_0x52ca57||0xc8;return function(_0x226749){if(_0x226749){return _0x3a2775[_0x910b('0x1c')](_0x52ca57)['json'](_0x226749);}};}function respondWithFilteredResult(_0x33ea80,_0x46fda8){return function(_0x1307fa){if(_0x1307fa){var _0x465497=_0x1307fa[_0x910b('0x1e')],_0x4c5edc=_0x46fda8['offset'],_0x455ac5=_0x46fda8[_0x910b('0x1f')]+_0x46fda8['limit'],_0x372a5e;if(_0x455ac5>=_0x465497){_0x455ac5=_0x465497;_0x372a5e=0xc8;}else{_0x372a5e=0xce;}_0x33ea80[_0x910b('0x1c')](_0x372a5e);return _0x33ea80[_0x910b('0x20')](_0x910b('0x21'),_0x4c5edc+'-'+_0x455ac5+'/'+_0x465497)['json'](_0x1307fa);}return null;};}function patchUpdates(_0x11da91){return function(_0x3fa2f4){try{jsonpatch[_0x910b('0x22')](_0x3fa2f4,_0x11da91,!![]);}catch(_0x2522d4){return BPromise[_0x910b('0x23')](_0x2522d4);}return _0x3fa2f4[_0x910b('0x24')]();};}function saveUpdates(_0x4c77e4,_0x143168){return function(_0x2ae86b){if(_0x2ae86b){return _0x2ae86b['update'](_0x4c77e4)[_0x910b('0x25')](function(_0x3c11d2){return _0x3c11d2;});}return null;};}function removeEntity(_0x468aa3,_0x121b6e){return function(_0x133485){if(_0x133485){return _0x133485[_0x910b('0x26')]()[_0x910b('0x25')](function(){var _0x53c21d=_0x133485[_0x910b('0x27')]({'plain':!![]});var _0x226cf2='SquareProjects';return db[_0x910b('0x28')]['destroy']({'where':{'type':_0x226cf2,'resourceId':_0x53c21d['id']}})['then'](function(){return _0x133485;});})['then'](function(){_0x468aa3[_0x910b('0x1c')](0xcc)[_0x910b('0x1d')]();});}};}function handleEntityNotFound(_0x5c3d98,_0x527c43){return function(_0x2fb281){if(!_0x2fb281){_0x5c3d98['sendStatus'](0x194);}return _0x2fb281;};}function handleError(_0x355c20,_0x157b91){_0x157b91=_0x157b91||0x1f4;return function(_0x58005a){logger[_0x910b('0x29')](_0x58005a[_0x910b('0x2a')]);if(_0x58005a['name']){delete _0x58005a[_0x910b('0x2b')];}_0x355c20[_0x910b('0x1c')](_0x157b91)[_0x910b('0x2c')](_0x58005a);};}exports[_0x910b('0x2d')]=function(_0x470d4b,_0x84ac34){var _0x327062={},_0x5aed91={},_0x1da4f1={'count':0x0,'rows':[]};var _0x438e7e=_['map'](db[_0x910b('0x2e')][_0x910b('0x2f')],function(_0x46719d){return{'name':_0x46719d[_0x910b('0x30')],'type':_0x46719d['type']['key']};});_0x5aed91[_0x910b('0x31')]=_[_0x910b('0x32')](_0x438e7e,'name');_0x5aed91[_0x910b('0x33')]=_[_0x910b('0x34')](_0x470d4b[_0x910b('0x33')]);_0x5aed91['filters']=_['intersection'](_0x5aed91[_0x910b('0x31')],_0x5aed91[_0x910b('0x33')]);_0x327062[_0x910b('0x35')]=_['intersection'](_0x5aed91[_0x910b('0x31')],qs[_0x910b('0x36')](_0x470d4b[_0x910b('0x33')]['fields']));_0x327062[_0x910b('0x35')]=_0x327062[_0x910b('0x35')][_0x910b('0x37')]?_0x327062[_0x910b('0x35')]:_0x5aed91[_0x910b('0x31')];if(!_0x470d4b[_0x910b('0x33')][_0x910b('0x38')](_0x910b('0x39'))){_0x327062[_0x910b('0x3a')]=qs[_0x910b('0x3a')](_0x470d4b['query']['limit']);_0x327062[_0x910b('0x1f')]=qs[_0x910b('0x1f')](_0x470d4b[_0x910b('0x33')]['offset']);}_0x327062['order']=qs['sort'](_0x470d4b['query'][_0x910b('0x3b')]);_0x327062[_0x910b('0x3c')]=qs[_0x910b('0x3d')](_[_0x910b('0x3e')](_0x470d4b[_0x910b('0x33')],_0x5aed91['filters']),_0x438e7e);if(_0x470d4b[_0x910b('0x33')][_0x910b('0x3f')]){_0x327062[_0x910b('0x3c')]=_[_0x910b('0x40')](_0x327062[_0x910b('0x3c')],{'$or':_[_0x910b('0x32')](_0x438e7e,function(_0x50ca83){if(_0x50ca83[_0x910b('0x41')]!=='VIRTUAL'){var _0x19e526={};_0x19e526[_0x50ca83[_0x910b('0x2b')]]={'$like':'%'+_0x470d4b[_0x910b('0x33')][_0x910b('0x3f')]+'%'};return _0x19e526;}})});}_0x327062=_[_0x910b('0x40')]({},_0x327062,_0x470d4b[_0x910b('0x42')]);var _0x512f7c={'where':_0x327062[_0x910b('0x3c')]};return db[_0x910b('0x2e')][_0x910b('0x1e')](_0x512f7c)[_0x910b('0x25')](function(_0x2f1b81){_0x1da4f1[_0x910b('0x1e')]=_0x2f1b81;if(_0x470d4b['query']['includeAll']){_0x327062[_0x910b('0x43')]=[{'all':!![]}];}return db[_0x910b('0x2e')][_0x910b('0x44')](_0x327062);})[_0x910b('0x25')](function(_0x3c709e){_0x1da4f1[_0x910b('0x45')]=_0x3c709e;return _0x1da4f1;})[_0x910b('0x25')](respondWithFilteredResult(_0x84ac34,_0x327062))[_0x910b('0x46')](handleError(_0x84ac34,null));};exports[_0x910b('0x47')]=function(_0x1c4194,_0x3f4295){var _0x3b1156={'raw':![],'where':{'id':_0x1c4194[_0x910b('0x48')]['id']}},_0x38f448={};_0x38f448[_0x910b('0x31')]=_[_0x910b('0x34')](db[_0x910b('0x2e')]['rawAttributes']);_0x38f448[_0x910b('0x33')]=_['keys'](_0x1c4194['query']);_0x38f448['filters']=_[_0x910b('0x49')](_0x38f448['model'],_0x38f448[_0x910b('0x33')]);_0x3b1156[_0x910b('0x35')]=_['intersection'](_0x38f448['model'],qs[_0x910b('0x36')](_0x1c4194[_0x910b('0x33')]['fields']));_0x3b1156[_0x910b('0x35')]=_0x3b1156[_0x910b('0x35')][_0x910b('0x37')]?_0x3b1156[_0x910b('0x35')]:_0x38f448['model'];if(_0x1c4194['query'][_0x910b('0x4a')]){_0x3b1156[_0x910b('0x43')]=[{'all':!![]}];}_0x3b1156=_[_0x910b('0x40')]({},_0x3b1156,_0x1c4194[_0x910b('0x42')]);return db[_0x910b('0x2e')]['find'](_0x3b1156)[_0x910b('0x25')](handleEntityNotFound(_0x3f4295,null))['then'](respondWithResult(_0x3f4295,null))[_0x910b('0x46')](handleError(_0x3f4295,null));};exports['create']=function(_0xcc41e,_0x1a6f45){return db[_0x910b('0x2e')]['create'](_0xcc41e['body'],{})['then'](function(_0x38cfae){var _0x5211c9=_0xcc41e['user'][_0x910b('0x27')]({'plain':!![]});if(!_0x5211c9)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x5211c9[_0x910b('0x4b')]===_0x910b('0x4c')){var _0x2861aa=_0x38cfae[_0x910b('0x27')]({'plain':!![]});var _0x14c489=_0x910b('0x4d');return db['UserProfileSection'][_0x910b('0x4e')]({'where':{'name':_0x14c489,'userProfileId':_0x5211c9[_0x910b('0x4f')]},'raw':!![]})['then'](function(_0x12cafa){if(_0x12cafa&&_0x12cafa['autoAssociation']===0x0){return db[_0x910b('0x28')][_0x910b('0x50')]({'name':_0x2861aa['name'],'resourceId':_0x2861aa['id'],'type':_0x12cafa['name'],'sectionId':_0x12cafa['id']},{})[_0x910b('0x25')](function(){return _0x38cfae;});}else{return _0x38cfae;}})['catch'](function(_0x5e72dd){logger[_0x910b('0x29')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x5e72dd);throw _0x5e72dd;});}return _0x38cfae;})[_0x910b('0x25')](respondWithResult(_0x1a6f45,0xc9))[_0x910b('0x46')](handleError(_0x1a6f45,null));};exports[_0x910b('0x51')]=function(_0x20fd19,_0x3d76f4){if(_0x20fd19['body']['id']){delete _0x20fd19[_0x910b('0x52')]['id'];}return db['SquareProject'][_0x910b('0x4e')]({'where':{'id':_0x20fd19[_0x910b('0x48')]['id']}})['then'](handleEntityNotFound(_0x3d76f4,null))[_0x910b('0x25')](saveUpdates(_0x20fd19[_0x910b('0x52')],null))[_0x910b('0x25')](respondWithResult(_0x3d76f4,null))[_0x910b('0x46')](handleError(_0x3d76f4,null));};exports[_0x910b('0x26')]=function(_0x433c11,_0x2da61c){return db['SquareProject']['find']({'where':{'id':_0x433c11[_0x910b('0x48')]['id']}})[_0x910b('0x25')](handleEntityNotFound(_0x2da61c,null))[_0x910b('0x25')](removeEntity(_0x2da61c,null))['catch'](handleError(_0x2da61c,null));};exports[_0x910b('0x53')]=function(_0x3c812e,_0x1dde6a,_0x5a5577){return db[_0x910b('0x2e')]['find']({'where':{'id':_0x3c812e[_0x910b('0x48')]['id']}})[_0x910b('0x25')](handleEntityNotFound(_0x1dde6a,null))[_0x910b('0x25')](function(_0xcc8d7d){if(_0xcc8d7d){return _0xcc8d7d[_0x910b('0x53')](_0x3c812e[_0x910b('0x52')][_0x910b('0x54')],_[_0x910b('0x55')](_0x3c812e[_0x910b('0x52')],['ids','id'])||{});}})[_0x910b('0x25')](respondWithResult(_0x1dde6a,null))[_0x910b('0x46')](handleError(_0x1dde6a,null));};exports['removeUsers']=function(_0x226378,_0x2c4077,_0x2b715d){return db['SquareProject'][_0x910b('0x4e')]({'where':{'id':_0x226378[_0x910b('0x48')]['id']}})[_0x910b('0x25')](handleEntityNotFound(_0x2c4077,null))[_0x910b('0x25')](function(_0x1c8c36){if(_0x1c8c36){return _0x1c8c36[_0x910b('0x56')](_0x226378[_0x910b('0x33')][_0x910b('0x54')])[_0x910b('0x25')](function(){if(_['isArray'](_0x226378['query'][_0x910b('0x54')])){for(var _0x53c742=0x0;_0x53c742<_0x226378['query']['ids'][_0x910b('0x37')];_0x53c742+=0x1){socket[_0x910b('0x57')](_0x910b('0x58'),{'UserId':Number(_0x226378[_0x910b('0x33')][_0x910b('0x54')][_0x53c742]),'SquareProjectId':Number(_0x226378['params']['id'])});}}else{socket[_0x910b('0x57')](_0x910b('0x58'),{'UserId':Number(_0x226378[_0x910b('0x33')][_0x910b('0x54')]),'SquareProjectId':Number(_0x226378[_0x910b('0x48')]['id'])});}});}})[_0x910b('0x25')](respondWithStatusCode(_0x2c4077,null))['catch'](handleError(_0x2c4077,null));};exports[_0x910b('0x59')]=function(_0x132e58,_0x5c0a62,_0x1cd91e){var _0x545ae5={};var _0x510c8c={};var _0x4cec18;var _0x13e6a4;return db['SquareProject']['findOne']({'where':{'id':_0x132e58[_0x910b('0x48')]['id']}})[_0x910b('0x25')](handleEntityNotFound(_0x5c0a62,null))[_0x910b('0x25')](function(_0x369c2f){if(_0x369c2f){_0x4cec18=_0x369c2f;_0x510c8c[_0x910b('0x31')]=_[_0x910b('0x34')](db[_0x910b('0x5a')][_0x910b('0x2f')]);_0x510c8c[_0x910b('0x33')]=_[_0x910b('0x34')](_0x132e58[_0x910b('0x33')]);_0x510c8c['filters']=_[_0x910b('0x49')](_0x510c8c[_0x910b('0x31')],_0x510c8c[_0x910b('0x33')]);_0x545ae5[_0x910b('0x35')]=_[_0x910b('0x49')](_0x510c8c[_0x910b('0x31')],qs[_0x910b('0x36')](_0x132e58[_0x910b('0x33')]['fields']));_0x545ae5[_0x910b('0x35')]=_0x545ae5['attributes'][_0x910b('0x37')]?_0x545ae5[_0x910b('0x35')]:_0x510c8c['model'];_0x545ae5[_0x910b('0x5b')]=qs[_0x910b('0x3b')](_0x132e58[_0x910b('0x33')][_0x910b('0x3b')]);_0x545ae5[_0x910b('0x3c')]=qs[_0x910b('0x3d')](_[_0x910b('0x3e')](_0x132e58[_0x910b('0x33')],_0x510c8c['filters']));if(_0x132e58[_0x910b('0x33')][_0x910b('0x3f')]){_0x545ae5[_0x910b('0x3c')]=_[_0x910b('0x40')](_0x545ae5[_0x910b('0x3c')],{'$or':_[_0x910b('0x32')](_0x545ae5[_0x910b('0x35')],function(_0x9e6b82){var _0x723330={};_0x723330[_0x9e6b82]={'$like':'%'+_0x132e58[_0x910b('0x33')][_0x910b('0x3f')]+'%'};return _0x723330;})});}_0x545ae5=_[_0x910b('0x40')]({},_0x545ae5,_0x132e58[_0x910b('0x42')]);return _0x4cec18[_0x910b('0x59')](_0x545ae5);}})['then'](function(_0x49f4d9){if(_0x49f4d9){_0x13e6a4=_0x49f4d9[_0x910b('0x37')];if(!_0x132e58[_0x910b('0x33')][_0x910b('0x38')](_0x910b('0x39'))){_0x545ae5['limit']=qs['limit'](_0x132e58[_0x910b('0x33')][_0x910b('0x3a')]);_0x545ae5[_0x910b('0x1f')]=qs[_0x910b('0x1f')](_0x132e58[_0x910b('0x33')]['offset']);}return _0x4cec18[_0x910b('0x59')](_0x545ae5);}})[_0x910b('0x25')](function(_0x171b59){if(_0x171b59){return _0x171b59?{'count':_0x13e6a4,'rows':_0x171b59}:null;}})[_0x910b('0x25')](respondWithResult(_0x5c0a62,null))[_0x910b('0x46')](handleError(_0x5c0a62,null));};