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 _0x2e54=['request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','squel','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','redis','defaults','localhost','socket.io-emitter','./squareProject.socket','register','sendStatus','status','end','json','count','limit','Content-Range','apply','reject','update','then','destroy','get','error','stack','name','send','index','SquareProject','rawAttributes','fieldName','model','keys','query','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','offset','order','sort','where','pick','filter','merge','map','type','VIRTUAL','options','includeAll','findAll','rows','catch','show','params','include','find','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','SquareProjects','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','addUsers','ids','omit','removeUsers','isArray','emit','getUsers','findOne','User','html-pdf','zip-dir','fast-json-patch'];(function(_0xbb091,_0x3fe7ee){var _0x467a04=function(_0x3a978d){while(--_0x3a978d){_0xbb091['push'](_0xbb091['shift']());}};_0x467a04(++_0x3fe7ee);}(_0x2e54,0x1dd));var _0x42e5=function(_0x5ccd3e,_0x3b5044){_0x5ccd3e=_0x5ccd3e-0x0;var _0x4d9ead=_0x2e54[_0x5ccd3e];return _0x4d9ead;};'use strict';var pdf=require(_0x42e5('0x0'));var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0x42e5('0x1'));var jsonpatch=require(_0x42e5('0x2'));var rp=require(_0x42e5('0x3'));var moment=require(_0x42e5('0x4'));var BPromise=require(_0x42e5('0x5'));var Mustache=require(_0x42e5('0x6'));var util=require(_0x42e5('0x7'));var path=require('path');var sox=require(_0x42e5('0x8'));var csv=require(_0x42e5('0x9'));var ejs=require(_0x42e5('0xa'));var fs=require('fs');var _=require('lodash');var squel=require(_0x42e5('0xb'));var crypto=require('crypto');var jsforce=require(_0x42e5('0xc'));var deskjs=require('desk.js');var toCsv=require(_0x42e5('0x9'));var querystring=require(_0x42e5('0xd'));var Papa=require(_0x42e5('0xe'));var Redis=require(_0x42e5('0xf'));var authService=require(_0x42e5('0x10'));var qs=require(_0x42e5('0x11'));var as=require(_0x42e5('0x12'));var hardwareService=require(_0x42e5('0x13'));var logger=require(_0x42e5('0x14'))('api');var utils=require(_0x42e5('0x15'));var config=require(_0x42e5('0x16'));var db=require('../../mysqldb')['db'];config[_0x42e5('0x17')]=_[_0x42e5('0x18')](config[_0x42e5('0x17')],{'host':_0x42e5('0x19'),'port':0x18eb});var socket=require(_0x42e5('0x1a'))(new Redis(config[_0x42e5('0x17')]));require(_0x42e5('0x1b'))[_0x42e5('0x1c')](socket);function respondWithStatusCode(_0x447648,_0x23957f){_0x23957f=_0x23957f||0xcc;return function(_0x51b2f4){if(_0x51b2f4){return _0x447648[_0x42e5('0x1d')](_0x23957f);}return _0x447648[_0x42e5('0x1e')](_0x23957f)[_0x42e5('0x1f')]();};}function respondWithResult(_0x388300,_0x2f4999){_0x2f4999=_0x2f4999||0xc8;return function(_0x263a3d){if(_0x263a3d){return _0x388300[_0x42e5('0x1e')](_0x2f4999)[_0x42e5('0x20')](_0x263a3d);}};}function respondWithFilteredResult(_0x16c753,_0x3c7b79){return function(_0x22655f){if(_0x22655f){var _0x38282d=_0x22655f[_0x42e5('0x21')],_0x11550e=_0x3c7b79['offset'],_0x23fe09=_0x3c7b79['offset']+_0x3c7b79[_0x42e5('0x22')],_0x54fcfc;if(_0x23fe09>=_0x38282d){_0x23fe09=_0x38282d;_0x54fcfc=0xc8;}else{_0x54fcfc=0xce;}_0x16c753[_0x42e5('0x1e')](_0x54fcfc);return _0x16c753['set'](_0x42e5('0x23'),_0x11550e+'-'+_0x23fe09+'/'+_0x38282d)[_0x42e5('0x20')](_0x22655f);}return null;};}function patchUpdates(_0x1c2169){return function(_0x3fde76){try{jsonpatch[_0x42e5('0x24')](_0x3fde76,_0x1c2169,!![]);}catch(_0xa6825e){return BPromise[_0x42e5('0x25')](_0xa6825e);}return _0x3fde76['save']();};}function saveUpdates(_0x4da508,_0x283d44){return function(_0x52d319){if(_0x52d319){return _0x52d319[_0x42e5('0x26')](_0x4da508)[_0x42e5('0x27')](function(_0x37d10e){return _0x37d10e;});}return null;};}function removeEntity(_0x49490f,_0x32380f){return function(_0x5d6b24){if(_0x5d6b24){return _0x5d6b24[_0x42e5('0x28')]()[_0x42e5('0x27')](function(){var _0x14640d=_0x5d6b24[_0x42e5('0x29')]({'plain':!![]});var _0x4638bc='SquareProjects';return db['UserProfileResource'][_0x42e5('0x28')]({'where':{'type':_0x4638bc,'resourceId':_0x14640d['id']}})['then'](function(){return _0x5d6b24;});})['then'](function(){_0x49490f[_0x42e5('0x1e')](0xcc)['end']();});}};}function handleEntityNotFound(_0x392c6b,_0x2d9e65){return function(_0x4fd119){if(!_0x4fd119){_0x392c6b[_0x42e5('0x1d')](0x194);}return _0x4fd119;};}function handleError(_0x27ae27,_0x2f1edc){_0x2f1edc=_0x2f1edc||0x1f4;return function(_0x59a46b){logger[_0x42e5('0x2a')](_0x59a46b[_0x42e5('0x2b')]);if(_0x59a46b[_0x42e5('0x2c')]){delete _0x59a46b[_0x42e5('0x2c')];}_0x27ae27[_0x42e5('0x1e')](_0x2f1edc)[_0x42e5('0x2d')](_0x59a46b);};}exports[_0x42e5('0x2e')]=function(_0x282cbf,_0x5a4930){var _0x2ba9ef={},_0x2c7542={},_0x3d9e8b={'count':0x0,'rows':[]};var _0x28a178=_['map'](db[_0x42e5('0x2f')][_0x42e5('0x30')],function(_0x14c8fd){return{'name':_0x14c8fd[_0x42e5('0x31')],'type':_0x14c8fd['type']['key']};});_0x2c7542[_0x42e5('0x32')]=_['map'](_0x28a178,_0x42e5('0x2c'));_0x2c7542['query']=_[_0x42e5('0x33')](_0x282cbf[_0x42e5('0x34')]);_0x2c7542[_0x42e5('0x35')]=_['intersection'](_0x2c7542[_0x42e5('0x32')],_0x2c7542[_0x42e5('0x34')]);_0x2ba9ef['attributes']=_[_0x42e5('0x36')](_0x2c7542['model'],qs[_0x42e5('0x37')](_0x282cbf[_0x42e5('0x34')][_0x42e5('0x37')]));_0x2ba9ef[_0x42e5('0x38')]=_0x2ba9ef[_0x42e5('0x38')][_0x42e5('0x39')]?_0x2ba9ef[_0x42e5('0x38')]:_0x2c7542['model'];if(!_0x282cbf['query'][_0x42e5('0x3a')](_0x42e5('0x3b'))){_0x2ba9ef[_0x42e5('0x22')]=qs['limit'](_0x282cbf['query']['limit']);_0x2ba9ef['offset']=qs[_0x42e5('0x3c')](_0x282cbf[_0x42e5('0x34')][_0x42e5('0x3c')]);}_0x2ba9ef[_0x42e5('0x3d')]=qs[_0x42e5('0x3e')](_0x282cbf[_0x42e5('0x34')][_0x42e5('0x3e')]);_0x2ba9ef[_0x42e5('0x3f')]=qs['filters'](_[_0x42e5('0x40')](_0x282cbf['query'],_0x2c7542[_0x42e5('0x35')]));if(_0x282cbf[_0x42e5('0x34')][_0x42e5('0x41')]){_0x2ba9ef[_0x42e5('0x3f')]=_[_0x42e5('0x42')](_0x2ba9ef[_0x42e5('0x3f')],{'$or':_[_0x42e5('0x43')](_0x28a178,function(_0x5ab9b8){if(_0x5ab9b8[_0x42e5('0x44')]!==_0x42e5('0x45')){var _0x5362c8={};_0x5362c8[_0x5ab9b8[_0x42e5('0x2c')]]={'$like':'%'+_0x282cbf['query']['filter']+'%'};return _0x5362c8;}})});}_0x2ba9ef=_['merge']({},_0x2ba9ef,_0x282cbf[_0x42e5('0x46')]);var _0x40d878={'where':_0x2ba9ef[_0x42e5('0x3f')]};return db[_0x42e5('0x2f')][_0x42e5('0x21')](_0x40d878)[_0x42e5('0x27')](function(_0x1fbde){_0x3d9e8b['count']=_0x1fbde;if(_0x282cbf[_0x42e5('0x34')][_0x42e5('0x47')]){_0x2ba9ef['include']=[{'all':!![]}];}return db[_0x42e5('0x2f')][_0x42e5('0x48')](_0x2ba9ef);})['then'](function(_0x33054f){_0x3d9e8b[_0x42e5('0x49')]=_0x33054f;return _0x3d9e8b;})[_0x42e5('0x27')](respondWithFilteredResult(_0x5a4930,_0x2ba9ef))[_0x42e5('0x4a')](handleError(_0x5a4930,null));};exports[_0x42e5('0x4b')]=function(_0x4d32f4,_0x41e1fd){var _0xc34e51={'raw':![],'where':{'id':_0x4d32f4[_0x42e5('0x4c')]['id']}},_0x19f684={};_0x19f684['model']=_[_0x42e5('0x33')](db[_0x42e5('0x2f')][_0x42e5('0x30')]);_0x19f684[_0x42e5('0x34')]=_[_0x42e5('0x33')](_0x4d32f4[_0x42e5('0x34')]);_0x19f684[_0x42e5('0x35')]=_[_0x42e5('0x36')](_0x19f684['model'],_0x19f684[_0x42e5('0x34')]);_0xc34e51['attributes']=_['intersection'](_0x19f684[_0x42e5('0x32')],qs[_0x42e5('0x37')](_0x4d32f4[_0x42e5('0x34')][_0x42e5('0x37')]));_0xc34e51[_0x42e5('0x38')]=_0xc34e51[_0x42e5('0x38')][_0x42e5('0x39')]?_0xc34e51['attributes']:_0x19f684[_0x42e5('0x32')];if(_0x4d32f4[_0x42e5('0x34')][_0x42e5('0x47')]){_0xc34e51[_0x42e5('0x4d')]=[{'all':!![]}];}_0xc34e51=_[_0x42e5('0x42')]({},_0xc34e51,_0x4d32f4[_0x42e5('0x46')]);return db[_0x42e5('0x2f')][_0x42e5('0x4e')](_0xc34e51)['then'](handleEntityNotFound(_0x41e1fd,null))[_0x42e5('0x27')](respondWithResult(_0x41e1fd,null))[_0x42e5('0x4a')](handleError(_0x41e1fd,null));};exports[_0x42e5('0x4f')]=function(_0x48757e,_0x2ab52a){return db[_0x42e5('0x2f')][_0x42e5('0x4f')](_0x48757e[_0x42e5('0x50')],{})[_0x42e5('0x27')](function(_0x528ddd){var _0x3db35c=_0x48757e['user'][_0x42e5('0x29')]({'plain':!![]});if(!_0x3db35c)throw new Error(_0x42e5('0x51'));if(_0x3db35c[_0x42e5('0x52')]==='user'){var _0x50f59c=_0x528ddd['get']({'plain':!![]});var _0x3e2747=_0x42e5('0x53');return db[_0x42e5('0x54')][_0x42e5('0x4e')]({'where':{'name':_0x3e2747,'userProfileId':_0x3db35c['userProfileId']},'raw':!![]})[_0x42e5('0x27')](function(_0x26782e){if(_0x26782e&&_0x26782e[_0x42e5('0x55')]===0x0){return db['UserProfileResource'][_0x42e5('0x4f')]({'name':_0x50f59c['name'],'resourceId':_0x50f59c['id'],'type':_0x26782e[_0x42e5('0x2c')],'sectionId':_0x26782e['id']},{})[_0x42e5('0x27')](function(){return _0x528ddd;});}else{return _0x528ddd;}})['catch'](function(_0x2588e6){logger[_0x42e5('0x2a')](_0x42e5('0x56'),_0x2588e6);throw _0x2588e6;});}return _0x528ddd;})[_0x42e5('0x27')](respondWithResult(_0x2ab52a,0xc9))[_0x42e5('0x4a')](handleError(_0x2ab52a,null));};exports[_0x42e5('0x26')]=function(_0x41c1dc,_0xc71ddb){if(_0x41c1dc[_0x42e5('0x50')]['id']){delete _0x41c1dc[_0x42e5('0x50')]['id'];}return db['SquareProject'][_0x42e5('0x4e')]({'where':{'id':_0x41c1dc[_0x42e5('0x4c')]['id']}})[_0x42e5('0x27')](handleEntityNotFound(_0xc71ddb,null))[_0x42e5('0x27')](saveUpdates(_0x41c1dc[_0x42e5('0x50')],null))['then'](respondWithResult(_0xc71ddb,null))[_0x42e5('0x4a')](handleError(_0xc71ddb,null));};exports[_0x42e5('0x28')]=function(_0x40b633,_0x106a4d){return db['SquareProject']['find']({'where':{'id':_0x40b633['params']['id']}})[_0x42e5('0x27')](handleEntityNotFound(_0x106a4d,null))[_0x42e5('0x27')](removeEntity(_0x106a4d,null))['catch'](handleError(_0x106a4d,null));};exports[_0x42e5('0x57')]=function(_0xb73aa8,_0x10346e,_0x2ced33){return db[_0x42e5('0x2f')][_0x42e5('0x4e')]({'where':{'id':_0xb73aa8[_0x42e5('0x4c')]['id']}})[_0x42e5('0x27')](handleEntityNotFound(_0x10346e,null))[_0x42e5('0x27')](function(_0x5688a4){if(_0x5688a4){return _0x5688a4[_0x42e5('0x57')](_0xb73aa8['body'][_0x42e5('0x58')],_[_0x42e5('0x59')](_0xb73aa8[_0x42e5('0x50')],[_0x42e5('0x58'),'id'])||{});}})[_0x42e5('0x27')](respondWithResult(_0x10346e,null))[_0x42e5('0x4a')](handleError(_0x10346e,null));};exports[_0x42e5('0x5a')]=function(_0x3cc77f,_0x15c44a,_0x397481){return db[_0x42e5('0x2f')]['find']({'where':{'id':_0x3cc77f[_0x42e5('0x4c')]['id']}})['then'](handleEntityNotFound(_0x15c44a,null))[_0x42e5('0x27')](function(_0x4ae828){if(_0x4ae828){return _0x4ae828[_0x42e5('0x5a')](_0x3cc77f[_0x42e5('0x34')]['ids'])[_0x42e5('0x27')](function(){if(_[_0x42e5('0x5b')](_0x3cc77f['query'][_0x42e5('0x58')])){for(var _0x9b93a9=0x0;_0x9b93a9<_0x3cc77f['query'][_0x42e5('0x58')][_0x42e5('0x39')];_0x9b93a9+=0x1){socket[_0x42e5('0x5c')]('userSquareProject:remove',{'UserId':Number(_0x3cc77f[_0x42e5('0x34')][_0x42e5('0x58')][_0x9b93a9]),'SquareProjectId':Number(_0x3cc77f[_0x42e5('0x4c')]['id'])});}}else{socket[_0x42e5('0x5c')]('userSquareProject:remove',{'UserId':Number(_0x3cc77f[_0x42e5('0x34')]['ids']),'SquareProjectId':Number(_0x3cc77f[_0x42e5('0x4c')]['id'])});}});}})[_0x42e5('0x27')](respondWithStatusCode(_0x15c44a,null))[_0x42e5('0x4a')](handleError(_0x15c44a,null));};exports[_0x42e5('0x5d')]=function(_0x44019c,_0x3c6914,_0x15ff42){var _0x590f7b={};var _0x2b5679={};var _0x43a74d;var _0xcb0a66;return db[_0x42e5('0x2f')][_0x42e5('0x5e')]({'where':{'id':_0x44019c[_0x42e5('0x4c')]['id']}})[_0x42e5('0x27')](handleEntityNotFound(_0x3c6914,null))[_0x42e5('0x27')](function(_0x292249){if(_0x292249){_0x43a74d=_0x292249;_0x2b5679['model']=_[_0x42e5('0x33')](db[_0x42e5('0x5f')][_0x42e5('0x30')]);_0x2b5679[_0x42e5('0x34')]=_['keys'](_0x44019c[_0x42e5('0x34')]);_0x2b5679[_0x42e5('0x35')]=_[_0x42e5('0x36')](_0x2b5679[_0x42e5('0x32')],_0x2b5679['query']);_0x590f7b['attributes']=_['intersection'](_0x2b5679[_0x42e5('0x32')],qs[_0x42e5('0x37')](_0x44019c[_0x42e5('0x34')][_0x42e5('0x37')]));_0x590f7b[_0x42e5('0x38')]=_0x590f7b[_0x42e5('0x38')][_0x42e5('0x39')]?_0x590f7b[_0x42e5('0x38')]:_0x2b5679[_0x42e5('0x32')];_0x590f7b['order']=qs[_0x42e5('0x3e')](_0x44019c[_0x42e5('0x34')][_0x42e5('0x3e')]);_0x590f7b[_0x42e5('0x3f')]=qs[_0x42e5('0x35')](_[_0x42e5('0x40')](_0x44019c[_0x42e5('0x34')],_0x2b5679[_0x42e5('0x35')]));if(_0x44019c['query']['filter']){_0x590f7b[_0x42e5('0x3f')]=_[_0x42e5('0x42')](_0x590f7b['where'],{'$or':_['map'](_0x590f7b['attributes'],function(_0x24bcf6){var _0x33446a={};_0x33446a[_0x24bcf6]={'$like':'%'+_0x44019c['query'][_0x42e5('0x41')]+'%'};return _0x33446a;})});}_0x590f7b=_[_0x42e5('0x42')]({},_0x590f7b,_0x44019c['options']);return _0x43a74d[_0x42e5('0x5d')](_0x590f7b);}})[_0x42e5('0x27')](function(_0x4a3b99){if(_0x4a3b99){_0xcb0a66=_0x4a3b99[_0x42e5('0x39')];if(!_0x44019c['query']['hasOwnProperty']('nolimit')){_0x590f7b['limit']=qs[_0x42e5('0x22')](_0x44019c[_0x42e5('0x34')]['limit']);_0x590f7b[_0x42e5('0x3c')]=qs[_0x42e5('0x3c')](_0x44019c[_0x42e5('0x34')][_0x42e5('0x3c')]);}return _0x43a74d[_0x42e5('0x5d')](_0x590f7b);}})[_0x42e5('0x27')](function(_0x53f9df){if(_0x53f9df){return _0x53f9df?{'count':_0xcb0a66,'rows':_0x53f9df}:null;}})[_0x42e5('0x27')](respondWithResult(_0x3c6914,null))[_0x42e5('0x4a')](handleError(_0x3c6914,null));};