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 _0x3c03=['ids','omit','removeUsers','isArray','emit','userSquareProject:remove','getUsers','User','hasOwnProperty','nolimit','limit','html-pdf','eml-format','rimraf','zip-dir','request-promise','bluebird','mustache','util','path','to-csv','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','redis','defaults','localhost','./squareProject.socket','status','end','json','offset','set','apply','update','then','destroy','get','SquareProjects','UserProfileResource','error','stack','name','send','map','SquareProject','rawAttributes','fieldName','key','model','query','keys','attributes','intersection','fields','length','order','sort','where','filters','pick','filter','merge','VIRTUAL','options','count','includeAll','include','findAll','rows','catch','show','params','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s'];(function(_0x86f458,_0x33ff3c){var _0x298beb=function(_0x5523f9){while(--_0x5523f9){_0x86f458['push'](_0x86f458['shift']());}};_0x298beb(++_0x33ff3c);}(_0x3c03,0x1dc));var _0x33c0=function(_0x5037ab,_0x43209e){_0x5037ab=_0x5037ab-0x0;var _0x512adb=_0x3c03[_0x5037ab];return _0x512adb;};'use strict';var pdf=require(_0x33c0('0x0'));var emlformat=require(_0x33c0('0x1'));var rimraf=require(_0x33c0('0x2'));var zipdir=require(_0x33c0('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0x33c0('0x4'));var moment=require('moment');var BPromise=require(_0x33c0('0x5'));var Mustache=require(_0x33c0('0x6'));var util=require(_0x33c0('0x7'));var path=require(_0x33c0('0x8'));var sox=require('sox');var csv=require(_0x33c0('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require('lodash');var squel=require(_0x33c0('0xa'));var crypto=require(_0x33c0('0xb'));var jsforce=require(_0x33c0('0xc'));var deskjs=require('desk.js');var toCsv=require(_0x33c0('0x9'));var querystring=require(_0x33c0('0xd'));var Papa=require(_0x33c0('0xe'));var Redis=require(_0x33c0('0xf'));var authService=require('../../components/auth/service');var qs=require(_0x33c0('0x10'));var as=require(_0x33c0('0x11'));var hardwareService=require(_0x33c0('0x12'));var logger=require(_0x33c0('0x13'))(_0x33c0('0x14'));var utils=require(_0x33c0('0x15'));var config=require('../../config/environment');var licenseUtil=require(_0x33c0('0x16'));var db=require(_0x33c0('0x17'))['db'];config[_0x33c0('0x18')]=_[_0x33c0('0x19')](config[_0x33c0('0x18')],{'host':_0x33c0('0x1a'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x33c0('0x18')]));require(_0x33c0('0x1b'))['register'](socket);function respondWithStatusCode(_0x533ebe,_0x3185d6){_0x3185d6=_0x3185d6||0xcc;return function(_0x55c633){if(_0x55c633){return _0x533ebe['sendStatus'](_0x3185d6);}return _0x533ebe[_0x33c0('0x1c')](_0x3185d6)[_0x33c0('0x1d')]();};}function respondWithResult(_0x27f85a,_0x178ec2){_0x178ec2=_0x178ec2||0xc8;return function(_0x5ea230){if(_0x5ea230){return _0x27f85a['status'](_0x178ec2)[_0x33c0('0x1e')](_0x5ea230);}};}function respondWithFilteredResult(_0x37fa78,_0x17e4b6){return function(_0x193401){if(_0x193401){var _0x38e3c9=_0x193401['count'],_0x2c3d14=_0x17e4b6[_0x33c0('0x1f')],_0x40f8ed=_0x17e4b6[_0x33c0('0x1f')]+_0x17e4b6['limit'],_0x254b06;if(_0x40f8ed>=_0x38e3c9){_0x40f8ed=_0x38e3c9;_0x254b06=0xc8;}else{_0x254b06=0xce;}_0x37fa78[_0x33c0('0x1c')](_0x254b06);return _0x37fa78[_0x33c0('0x20')]('Content-Range',_0x2c3d14+'-'+_0x40f8ed+'/'+_0x38e3c9)[_0x33c0('0x1e')](_0x193401);}return null;};}function patchUpdates(_0xf1525e){return function(_0x12305a){try{jsonpatch[_0x33c0('0x21')](_0x12305a,_0xf1525e,!![]);}catch(_0x297a7d){return BPromise['reject'](_0x297a7d);}return _0x12305a['save']();};}function saveUpdates(_0x1a84b0,_0xaa7f97){return function(_0x1f6b87){if(_0x1f6b87){return _0x1f6b87[_0x33c0('0x22')](_0x1a84b0)[_0x33c0('0x23')](function(_0x3aa3cd){return _0x3aa3cd;});}return null;};}function removeEntity(_0x51e723,_0x48a38b){return function(_0x36412b){if(_0x36412b){return _0x36412b[_0x33c0('0x24')]()[_0x33c0('0x23')](function(){var _0x3880c9=_0x36412b[_0x33c0('0x25')]({'plain':!![]});var _0x3d8cc4=_0x33c0('0x26');return db[_0x33c0('0x27')][_0x33c0('0x24')]({'where':{'type':_0x3d8cc4,'resourceId':_0x3880c9['id']}})['then'](function(){return _0x36412b;});})[_0x33c0('0x23')](function(){_0x51e723[_0x33c0('0x1c')](0xcc)[_0x33c0('0x1d')]();});}};}function handleEntityNotFound(_0x4a6aba,_0x2bca80){return function(_0x162f67){if(!_0x162f67){_0x4a6aba['sendStatus'](0x194);}return _0x162f67;};}function handleError(_0xcd220b,_0x44e2ec){_0x44e2ec=_0x44e2ec||0x1f4;return function(_0x1af522){logger[_0x33c0('0x28')](_0x1af522[_0x33c0('0x29')]);if(_0x1af522[_0x33c0('0x2a')]){delete _0x1af522[_0x33c0('0x2a')];}_0xcd220b[_0x33c0('0x1c')](_0x44e2ec)[_0x33c0('0x2b')](_0x1af522);};}exports['index']=function(_0x86d52d,_0x4ca363){var _0x499c0a={},_0x37acb5={},_0x1351d8={'count':0x0,'rows':[]};var _0x3f3a74=_[_0x33c0('0x2c')](db[_0x33c0('0x2d')][_0x33c0('0x2e')],function(_0x2beb1d){return{'name':_0x2beb1d[_0x33c0('0x2f')],'type':_0x2beb1d['type'][_0x33c0('0x30')]};});_0x37acb5[_0x33c0('0x31')]=_[_0x33c0('0x2c')](_0x3f3a74,_0x33c0('0x2a'));_0x37acb5[_0x33c0('0x32')]=_[_0x33c0('0x33')](_0x86d52d[_0x33c0('0x32')]);_0x37acb5['filters']=_['intersection'](_0x37acb5[_0x33c0('0x31')],_0x37acb5[_0x33c0('0x32')]);_0x499c0a[_0x33c0('0x34')]=_[_0x33c0('0x35')](_0x37acb5[_0x33c0('0x31')],qs['fields'](_0x86d52d[_0x33c0('0x32')][_0x33c0('0x36')]));_0x499c0a[_0x33c0('0x34')]=_0x499c0a[_0x33c0('0x34')][_0x33c0('0x37')]?_0x499c0a[_0x33c0('0x34')]:_0x37acb5['model'];if(!_0x86d52d['query']['hasOwnProperty']('nolimit')){_0x499c0a['limit']=qs['limit'](_0x86d52d[_0x33c0('0x32')]['limit']);_0x499c0a[_0x33c0('0x1f')]=qs['offset'](_0x86d52d[_0x33c0('0x32')][_0x33c0('0x1f')]);}_0x499c0a[_0x33c0('0x38')]=qs[_0x33c0('0x39')](_0x86d52d[_0x33c0('0x32')][_0x33c0('0x39')]);_0x499c0a[_0x33c0('0x3a')]=qs[_0x33c0('0x3b')](_[_0x33c0('0x3c')](_0x86d52d[_0x33c0('0x32')],_0x37acb5[_0x33c0('0x3b')]),_0x3f3a74);if(_0x86d52d[_0x33c0('0x32')][_0x33c0('0x3d')]){_0x499c0a[_0x33c0('0x3a')]=_[_0x33c0('0x3e')](_0x499c0a[_0x33c0('0x3a')],{'$or':_[_0x33c0('0x2c')](_0x3f3a74,function(_0x41bc7b){if(_0x41bc7b['type']!==_0x33c0('0x3f')){var _0x452d10={};_0x452d10[_0x41bc7b[_0x33c0('0x2a')]]={'$like':'%'+_0x86d52d[_0x33c0('0x32')][_0x33c0('0x3d')]+'%'};return _0x452d10;}})});}_0x499c0a=_[_0x33c0('0x3e')]({},_0x499c0a,_0x86d52d[_0x33c0('0x40')]);var _0x7ec5c0={'where':_0x499c0a[_0x33c0('0x3a')]};return db[_0x33c0('0x2d')][_0x33c0('0x41')](_0x7ec5c0)[_0x33c0('0x23')](function(_0x18ee57){_0x1351d8[_0x33c0('0x41')]=_0x18ee57;if(_0x86d52d[_0x33c0('0x32')][_0x33c0('0x42')]){_0x499c0a[_0x33c0('0x43')]=[{'all':!![]}];}return db[_0x33c0('0x2d')][_0x33c0('0x44')](_0x499c0a);})[_0x33c0('0x23')](function(_0x2f20be){_0x1351d8[_0x33c0('0x45')]=_0x2f20be;return _0x1351d8;})['then'](respondWithFilteredResult(_0x4ca363,_0x499c0a))[_0x33c0('0x46')](handleError(_0x4ca363,null));};exports[_0x33c0('0x47')]=function(_0x9121ff,_0x50886b){var _0x112184={'raw':![],'where':{'id':_0x9121ff[_0x33c0('0x48')]['id']}},_0x21a3d7={};_0x21a3d7[_0x33c0('0x31')]=_[_0x33c0('0x33')](db[_0x33c0('0x2d')][_0x33c0('0x2e')]);_0x21a3d7[_0x33c0('0x32')]=_[_0x33c0('0x33')](_0x9121ff[_0x33c0('0x32')]);_0x21a3d7[_0x33c0('0x3b')]=_[_0x33c0('0x35')](_0x21a3d7['model'],_0x21a3d7[_0x33c0('0x32')]);_0x112184[_0x33c0('0x34')]=_[_0x33c0('0x35')](_0x21a3d7[_0x33c0('0x31')],qs[_0x33c0('0x36')](_0x9121ff[_0x33c0('0x32')][_0x33c0('0x36')]));_0x112184[_0x33c0('0x34')]=_0x112184[_0x33c0('0x34')][_0x33c0('0x37')]?_0x112184[_0x33c0('0x34')]:_0x21a3d7[_0x33c0('0x31')];if(_0x9121ff[_0x33c0('0x32')][_0x33c0('0x42')]){_0x112184[_0x33c0('0x43')]=[{'all':!![]}];}_0x112184=_['merge']({},_0x112184,_0x9121ff[_0x33c0('0x40')]);return db[_0x33c0('0x2d')][_0x33c0('0x49')](_0x112184)['then'](handleEntityNotFound(_0x50886b,null))[_0x33c0('0x23')](respondWithResult(_0x50886b,null))[_0x33c0('0x46')](handleError(_0x50886b,null));};exports[_0x33c0('0x4a')]=function(_0x4788be,_0x10d0a8){return db[_0x33c0('0x2d')]['create'](_0x4788be[_0x33c0('0x4b')],{})[_0x33c0('0x23')](function(_0x7661e3){var _0x57a095=_0x4788be[_0x33c0('0x4c')][_0x33c0('0x25')]({'plain':!![]});if(!_0x57a095)throw new Error(_0x33c0('0x4d'));if(_0x57a095[_0x33c0('0x4e')]===_0x33c0('0x4c')){var _0x85ac89=_0x7661e3[_0x33c0('0x25')]({'plain':!![]});var _0x4b7dc1='SquareProjects';return db['UserProfileSection'][_0x33c0('0x49')]({'where':{'name':_0x4b7dc1,'userProfileId':_0x57a095[_0x33c0('0x4f')]},'raw':!![]})[_0x33c0('0x23')](function(_0x586e61){if(_0x586e61&&_0x586e61[_0x33c0('0x50')]===0x0){return db[_0x33c0('0x27')][_0x33c0('0x4a')]({'name':_0x85ac89[_0x33c0('0x2a')],'resourceId':_0x85ac89['id'],'type':_0x586e61['name'],'sectionId':_0x586e61['id']},{})[_0x33c0('0x23')](function(){return _0x7661e3;});}else{return _0x7661e3;}})[_0x33c0('0x46')](function(_0x47a272){logger[_0x33c0('0x28')](_0x33c0('0x51'),_0x47a272);throw _0x47a272;});}return _0x7661e3;})['then'](respondWithResult(_0x10d0a8,0xc9))[_0x33c0('0x46')](handleError(_0x10d0a8,null));};exports['update']=function(_0x21cb11,_0x5531d8){if(_0x21cb11[_0x33c0('0x4b')]['id']){delete _0x21cb11[_0x33c0('0x4b')]['id'];}return db[_0x33c0('0x2d')][_0x33c0('0x49')]({'where':{'id':_0x21cb11['params']['id']}})['then'](handleEntityNotFound(_0x5531d8,null))[_0x33c0('0x23')](saveUpdates(_0x21cb11[_0x33c0('0x4b')],null))['then'](respondWithResult(_0x5531d8,null))[_0x33c0('0x46')](handleError(_0x5531d8,null));};exports['destroy']=function(_0x5179d9,_0x16d2d3){return db[_0x33c0('0x2d')][_0x33c0('0x49')]({'where':{'id':_0x5179d9[_0x33c0('0x48')]['id']}})[_0x33c0('0x23')](handleEntityNotFound(_0x16d2d3,null))[_0x33c0('0x23')](removeEntity(_0x16d2d3,null))[_0x33c0('0x46')](handleError(_0x16d2d3,null));};exports['addUsers']=function(_0x446493,_0x14a082,_0x34b15b){return db[_0x33c0('0x2d')][_0x33c0('0x49')]({'where':{'id':_0x446493[_0x33c0('0x48')]['id']}})[_0x33c0('0x23')](handleEntityNotFound(_0x14a082,null))[_0x33c0('0x23')](function(_0x32e36b){if(_0x32e36b){return _0x32e36b['addUsers'](_0x446493[_0x33c0('0x4b')][_0x33c0('0x52')],_[_0x33c0('0x53')](_0x446493[_0x33c0('0x4b')],[_0x33c0('0x52'),'id'])||{});}})[_0x33c0('0x23')](respondWithResult(_0x14a082,null))[_0x33c0('0x46')](handleError(_0x14a082,null));};exports[_0x33c0('0x54')]=function(_0x51ec62,_0x53342c,_0x58a79f){return db[_0x33c0('0x2d')]['find']({'where':{'id':_0x51ec62['params']['id']}})[_0x33c0('0x23')](handleEntityNotFound(_0x53342c,null))[_0x33c0('0x23')](function(_0x3a409f){if(_0x3a409f){return _0x3a409f[_0x33c0('0x54')](_0x51ec62['query'][_0x33c0('0x52')])[_0x33c0('0x23')](function(){if(_[_0x33c0('0x55')](_0x51ec62[_0x33c0('0x32')]['ids'])){for(var _0x170838=0x0;_0x170838<_0x51ec62[_0x33c0('0x32')][_0x33c0('0x52')][_0x33c0('0x37')];_0x170838+=0x1){socket[_0x33c0('0x56')]('userSquareProject:remove',{'UserId':Number(_0x51ec62[_0x33c0('0x32')][_0x33c0('0x52')][_0x170838]),'SquareProjectId':Number(_0x51ec62[_0x33c0('0x48')]['id'])});}}else{socket[_0x33c0('0x56')](_0x33c0('0x57'),{'UserId':Number(_0x51ec62[_0x33c0('0x32')][_0x33c0('0x52')]),'SquareProjectId':Number(_0x51ec62[_0x33c0('0x48')]['id'])});}});}})[_0x33c0('0x23')](respondWithStatusCode(_0x53342c,null))[_0x33c0('0x46')](handleError(_0x53342c,null));};exports[_0x33c0('0x58')]=function(_0x57eb92,_0x1b1726,_0x50ff30){var _0x5e4021={};var _0x4bef00={};var _0x4af16c;var _0x5eafc0;return db[_0x33c0('0x2d')]['findOne']({'where':{'id':_0x57eb92[_0x33c0('0x48')]['id']}})['then'](handleEntityNotFound(_0x1b1726,null))[_0x33c0('0x23')](function(_0x1d250d){if(_0x1d250d){_0x4af16c=_0x1d250d;_0x4bef00[_0x33c0('0x31')]=_['keys'](db[_0x33c0('0x59')][_0x33c0('0x2e')]);_0x4bef00[_0x33c0('0x32')]=_[_0x33c0('0x33')](_0x57eb92['query']);_0x4bef00['filters']=_['intersection'](_0x4bef00[_0x33c0('0x31')],_0x4bef00[_0x33c0('0x32')]);_0x5e4021['attributes']=_[_0x33c0('0x35')](_0x4bef00[_0x33c0('0x31')],qs[_0x33c0('0x36')](_0x57eb92['query'][_0x33c0('0x36')]));_0x5e4021[_0x33c0('0x34')]=_0x5e4021[_0x33c0('0x34')][_0x33c0('0x37')]?_0x5e4021[_0x33c0('0x34')]:_0x4bef00[_0x33c0('0x31')];_0x5e4021['order']=qs[_0x33c0('0x39')](_0x57eb92[_0x33c0('0x32')][_0x33c0('0x39')]);_0x5e4021[_0x33c0('0x3a')]=qs['filters'](_[_0x33c0('0x3c')](_0x57eb92[_0x33c0('0x32')],_0x4bef00[_0x33c0('0x3b')]));if(_0x57eb92[_0x33c0('0x32')][_0x33c0('0x3d')]){_0x5e4021[_0x33c0('0x3a')]=_[_0x33c0('0x3e')](_0x5e4021[_0x33c0('0x3a')],{'$or':_[_0x33c0('0x2c')](_0x5e4021[_0x33c0('0x34')],function(_0x309b9b){var _0x51bd9d={};_0x51bd9d[_0x309b9b]={'$like':'%'+_0x57eb92[_0x33c0('0x32')][_0x33c0('0x3d')]+'%'};return _0x51bd9d;})});}_0x5e4021=_[_0x33c0('0x3e')]({},_0x5e4021,_0x57eb92[_0x33c0('0x40')]);return _0x4af16c['getUsers'](_0x5e4021);}})[_0x33c0('0x23')](function(_0x552420){if(_0x552420){_0x5eafc0=_0x552420[_0x33c0('0x37')];if(!_0x57eb92['query'][_0x33c0('0x5a')](_0x33c0('0x5b'))){_0x5e4021[_0x33c0('0x5c')]=qs['limit'](_0x57eb92[_0x33c0('0x32')][_0x33c0('0x5c')]);_0x5e4021[_0x33c0('0x1f')]=qs[_0x33c0('0x1f')](_0x57eb92['query'][_0x33c0('0x1f')]);}return _0x4af16c[_0x33c0('0x58')](_0x5e4021);}})[_0x33c0('0x23')](function(_0x32147e){if(_0x32147e){return _0x32147e?{'count':_0x5eafc0,'rows':_0x32147e}:null;}})[_0x33c0('0x23')](respondWithResult(_0x1b1726,null))[_0x33c0('0x46')](handleError(_0x1b1726,null));};