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 _0x6e89=['apply','reject','save','update','then','destroy','get','SquareProjects','UserProfileResource','end','name','send','index','map','SquareProject','rawAttributes','fieldName','type','query','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','includeAll','include','findAll','catch','show','params','keys','options','create','user','UserProfileSection','userProfileId','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','find','body','addUsers','ids','omit','removeUsers','emit','userSquareProject:remove','getUsers','findOne','html-pdf','eml-format','zip-dir','fast-json-patch','moment','bluebird','util','path','sox','to-csv','ejs','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/environment','redis','localhost','./squareProject.socket','register','sendStatus','status','json','offset','limit','set','Content-Range'];(function(_0x443e9e,_0x3c1baf){var _0x5db340=function(_0x201893){while(--_0x201893){_0x443e9e['push'](_0x443e9e['shift']());}};_0x5db340(++_0x3c1baf);}(_0x6e89,0x147));var _0x96e8=function(_0x417767,_0x54ec1f){_0x417767=_0x417767-0x0;var _0x21aa0a=_0x6e89[_0x417767];return _0x21aa0a;};'use strict';var pdf=require(_0x96e8('0x0'));var emlformat=require(_0x96e8('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x96e8('0x2'));var jsonpatch=require(_0x96e8('0x3'));var rp=require('request-promise');var moment=require(_0x96e8('0x4'));var BPromise=require(_0x96e8('0x5'));var Mustache=require('mustache');var util=require(_0x96e8('0x6'));var path=require(_0x96e8('0x7'));var sox=require(_0x96e8('0x8'));var csv=require(_0x96e8('0x9'));var ejs=require(_0x96e8('0xa'));var fs=require('fs');var _=require(_0x96e8('0xb'));var squel=require('squel');var crypto=require(_0x96e8('0xc'));var jsforce=require(_0x96e8('0xd'));var deskjs=require(_0x96e8('0xe'));var toCsv=require(_0x96e8('0x9'));var querystring=require(_0x96e8('0xf'));var Papa=require(_0x96e8('0x10'));var Redis=require(_0x96e8('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x96e8('0x12'));var as=require(_0x96e8('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x96e8('0x14'))('api');var utils=require('../../config/utils');var config=require(_0x96e8('0x15'));var db=require('../../mysqldb')['db'];config[_0x96e8('0x16')]=_['defaults'](config[_0x96e8('0x16')],{'host':_0x96e8('0x17'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x96e8('0x16')]));require(_0x96e8('0x18'))[_0x96e8('0x19')](socket);function respondWithStatusCode(_0x3860df,_0x4b7f77){_0x4b7f77=_0x4b7f77||0xcc;return function(_0x53e187){if(_0x53e187){return _0x3860df[_0x96e8('0x1a')](_0x4b7f77);}return _0x3860df[_0x96e8('0x1b')](_0x4b7f77)['end']();};}function respondWithResult(_0x1f5ee2,_0x21c35c){_0x21c35c=_0x21c35c||0xc8;return function(_0x2f0531){if(_0x2f0531){return _0x1f5ee2[_0x96e8('0x1b')](_0x21c35c)[_0x96e8('0x1c')](_0x2f0531);}};}function respondWithFilteredResult(_0x4b5d3a,_0x12fd14){return function(_0x23e759){if(_0x23e759){var _0x400554=_0x23e759['count'],_0x4799a0=_0x12fd14[_0x96e8('0x1d')],_0x334f78=_0x12fd14[_0x96e8('0x1d')]+_0x12fd14[_0x96e8('0x1e')],_0x3f6250;if(_0x334f78>=_0x400554){_0x334f78=_0x400554;_0x3f6250=0xc8;}else{_0x3f6250=0xce;}_0x4b5d3a[_0x96e8('0x1b')](_0x3f6250);return _0x4b5d3a[_0x96e8('0x1f')](_0x96e8('0x20'),_0x4799a0+'-'+_0x334f78+'/'+_0x400554)[_0x96e8('0x1c')](_0x23e759);}return null;};}function patchUpdates(_0x58543f){return function(_0x38fae9){try{jsonpatch[_0x96e8('0x21')](_0x38fae9,_0x58543f,!![]);}catch(_0x21bf42){return BPromise[_0x96e8('0x22')](_0x21bf42);}return _0x38fae9[_0x96e8('0x23')]();};}function saveUpdates(_0x278ae7,_0x27aee4){return function(_0x2d4cfd){if(_0x2d4cfd){return _0x2d4cfd[_0x96e8('0x24')](_0x278ae7)[_0x96e8('0x25')](function(_0xb3d617){return _0xb3d617;});}return null;};}function removeEntity(_0x2c3a03,_0x1f071b){return function(_0x1b93cc){if(_0x1b93cc){return _0x1b93cc[_0x96e8('0x26')]()[_0x96e8('0x25')](function(){var _0x532767=_0x1b93cc[_0x96e8('0x27')]({'plain':!![]});var _0x5f22d6=_0x96e8('0x28');return db[_0x96e8('0x29')][_0x96e8('0x26')]({'where':{'type':_0x5f22d6,'resourceId':_0x532767['id']}})[_0x96e8('0x25')](function(){return _0x1b93cc;});})[_0x96e8('0x25')](function(){_0x2c3a03[_0x96e8('0x1b')](0xcc)[_0x96e8('0x2a')]();});}};}function handleEntityNotFound(_0x10f6ad,_0x3bdd64){return function(_0x3fff04){if(!_0x3fff04){_0x10f6ad[_0x96e8('0x1a')](0x194);}return _0x3fff04;};}function handleError(_0x565f21,_0x2f4cbb){_0x2f4cbb=_0x2f4cbb||0x1f4;return function(_0x3e7349){logger['error'](_0x3e7349['stack']);if(_0x3e7349[_0x96e8('0x2b')]){delete _0x3e7349[_0x96e8('0x2b')];}_0x565f21['status'](_0x2f4cbb)[_0x96e8('0x2c')](_0x3e7349);};}exports[_0x96e8('0x2d')]=function(_0x2d636a,_0x186164){var _0x10aa46={},_0x2fb162={},_0x27180e={'count':0x0,'rows':[]};var _0x18facd=_[_0x96e8('0x2e')](db[_0x96e8('0x2f')][_0x96e8('0x30')],function(_0x2ce795){return{'name':_0x2ce795[_0x96e8('0x31')],'type':_0x2ce795[_0x96e8('0x32')]['key']};});_0x2fb162['model']=_[_0x96e8('0x2e')](_0x18facd,_0x96e8('0x2b'));_0x2fb162[_0x96e8('0x33')]=_['keys'](_0x2d636a['query']);_0x2fb162[_0x96e8('0x34')]=_[_0x96e8('0x35')](_0x2fb162[_0x96e8('0x36')],_0x2fb162[_0x96e8('0x33')]);_0x10aa46[_0x96e8('0x37')]=_[_0x96e8('0x35')](_0x2fb162[_0x96e8('0x36')],qs[_0x96e8('0x38')](_0x2d636a[_0x96e8('0x33')][_0x96e8('0x38')]));_0x10aa46['attributes']=_0x10aa46[_0x96e8('0x37')][_0x96e8('0x39')]?_0x10aa46['attributes']:_0x2fb162['model'];if(!_0x2d636a['query'][_0x96e8('0x3a')](_0x96e8('0x3b'))){_0x10aa46[_0x96e8('0x1e')]=qs['limit'](_0x2d636a['query']['limit']);_0x10aa46[_0x96e8('0x1d')]=qs[_0x96e8('0x1d')](_0x2d636a['query'][_0x96e8('0x1d')]);}_0x10aa46[_0x96e8('0x3c')]=qs[_0x96e8('0x3d')](_0x2d636a[_0x96e8('0x33')][_0x96e8('0x3d')]);_0x10aa46['where']=qs[_0x96e8('0x34')](_[_0x96e8('0x3e')](_0x2d636a[_0x96e8('0x33')],_0x2fb162['filters']),_0x18facd);if(_0x2d636a['query'][_0x96e8('0x3f')]){_0x10aa46[_0x96e8('0x40')]=_['merge'](_0x10aa46[_0x96e8('0x40')],{'$or':_[_0x96e8('0x2e')](_0x18facd,function(_0x406108){if(_0x406108[_0x96e8('0x32')]!=='VIRTUAL'){var _0x261c9b={};_0x261c9b[_0x406108[_0x96e8('0x2b')]]={'$like':'%'+_0x2d636a[_0x96e8('0x33')]['filter']+'%'};return _0x261c9b;}})});}_0x10aa46=_[_0x96e8('0x41')]({},_0x10aa46,_0x2d636a['options']);var _0x48978d={'where':_0x10aa46[_0x96e8('0x40')]};return db[_0x96e8('0x2f')]['count'](_0x48978d)[_0x96e8('0x25')](function(_0x504c03){_0x27180e['count']=_0x504c03;if(_0x2d636a[_0x96e8('0x33')][_0x96e8('0x42')]){_0x10aa46[_0x96e8('0x43')]=[{'all':!![]}];}return db[_0x96e8('0x2f')][_0x96e8('0x44')](_0x10aa46);})[_0x96e8('0x25')](function(_0x2f19c4){_0x27180e['rows']=_0x2f19c4;return _0x27180e;})[_0x96e8('0x25')](respondWithFilteredResult(_0x186164,_0x10aa46))[_0x96e8('0x45')](handleError(_0x186164,null));};exports[_0x96e8('0x46')]=function(_0x13da8a,_0x2d3da5){var _0x2f04f2={'raw':![],'where':{'id':_0x13da8a[_0x96e8('0x47')]['id']}},_0x35b0fb={};_0x35b0fb[_0x96e8('0x36')]=_['keys'](db['SquareProject']['rawAttributes']);_0x35b0fb[_0x96e8('0x33')]=_[_0x96e8('0x48')](_0x13da8a['query']);_0x35b0fb[_0x96e8('0x34')]=_['intersection'](_0x35b0fb['model'],_0x35b0fb[_0x96e8('0x33')]);_0x2f04f2[_0x96e8('0x37')]=_[_0x96e8('0x35')](_0x35b0fb[_0x96e8('0x36')],qs[_0x96e8('0x38')](_0x13da8a[_0x96e8('0x33')][_0x96e8('0x38')]));_0x2f04f2[_0x96e8('0x37')]=_0x2f04f2[_0x96e8('0x37')][_0x96e8('0x39')]?_0x2f04f2[_0x96e8('0x37')]:_0x35b0fb[_0x96e8('0x36')];if(_0x13da8a[_0x96e8('0x33')]['includeAll']){_0x2f04f2['include']=[{'all':!![]}];}_0x2f04f2=_[_0x96e8('0x41')]({},_0x2f04f2,_0x13da8a[_0x96e8('0x49')]);return db['SquareProject']['find'](_0x2f04f2)[_0x96e8('0x25')](handleEntityNotFound(_0x2d3da5,null))[_0x96e8('0x25')](respondWithResult(_0x2d3da5,null))[_0x96e8('0x45')](handleError(_0x2d3da5,null));};exports[_0x96e8('0x4a')]=function(_0x556d12,_0x1481b0){return db['SquareProject'][_0x96e8('0x4a')](_0x556d12['body'],{})[_0x96e8('0x25')](function(_0xc9ed8d){var _0x25b30b=_0x556d12[_0x96e8('0x4b')][_0x96e8('0x27')]({'plain':!![]});if(!_0x25b30b)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x25b30b['role']===_0x96e8('0x4b')){var _0x2c9a73=_0xc9ed8d['get']({'plain':!![]});var _0x250e65=_0x96e8('0x28');return db[_0x96e8('0x4c')]['find']({'where':{'name':_0x250e65,'userProfileId':_0x25b30b[_0x96e8('0x4d')]},'raw':!![]})[_0x96e8('0x25')](function(_0x35ddfe){if(_0x35ddfe&&_0x35ddfe['autoAssociation']===0x0){return db[_0x96e8('0x29')][_0x96e8('0x4a')]({'name':_0x2c9a73['name'],'resourceId':_0x2c9a73['id'],'type':_0x35ddfe[_0x96e8('0x2b')],'sectionId':_0x35ddfe['id']},{})[_0x96e8('0x25')](function(){return _0xc9ed8d;});}else{return _0xc9ed8d;}})['catch'](function(_0xfbd7f0){logger[_0x96e8('0x4e')](_0x96e8('0x4f'),_0xfbd7f0);throw _0xfbd7f0;});}return _0xc9ed8d;})[_0x96e8('0x25')](respondWithResult(_0x1481b0,0xc9))[_0x96e8('0x45')](handleError(_0x1481b0,null));};exports[_0x96e8('0x24')]=function(_0x5a21c7,_0xc75f63){if(_0x5a21c7['body']['id']){delete _0x5a21c7['body']['id'];}return db[_0x96e8('0x2f')][_0x96e8('0x50')]({'where':{'id':_0x5a21c7[_0x96e8('0x47')]['id']}})[_0x96e8('0x25')](handleEntityNotFound(_0xc75f63,null))[_0x96e8('0x25')](saveUpdates(_0x5a21c7[_0x96e8('0x51')],null))[_0x96e8('0x25')](respondWithResult(_0xc75f63,null))['catch'](handleError(_0xc75f63,null));};exports[_0x96e8('0x26')]=function(_0x395595,_0x21e5bc){return db['SquareProject']['find']({'where':{'id':_0x395595[_0x96e8('0x47')]['id']}})[_0x96e8('0x25')](handleEntityNotFound(_0x21e5bc,null))[_0x96e8('0x25')](removeEntity(_0x21e5bc,null))[_0x96e8('0x45')](handleError(_0x21e5bc,null));};exports[_0x96e8('0x52')]=function(_0x18a812,_0x4089fb,_0x4b520a){return db[_0x96e8('0x2f')][_0x96e8('0x50')]({'where':{'id':_0x18a812[_0x96e8('0x47')]['id']}})[_0x96e8('0x25')](handleEntityNotFound(_0x4089fb,null))[_0x96e8('0x25')](function(_0x53ca85){if(_0x53ca85){return _0x53ca85[_0x96e8('0x52')](_0x18a812[_0x96e8('0x51')][_0x96e8('0x53')],_[_0x96e8('0x54')](_0x18a812[_0x96e8('0x51')],[_0x96e8('0x53'),'id'])||{});}})[_0x96e8('0x25')](respondWithResult(_0x4089fb,null))[_0x96e8('0x45')](handleError(_0x4089fb,null));};exports[_0x96e8('0x55')]=function(_0x29a4a9,_0x11400e,_0x4b6aca){return db[_0x96e8('0x2f')][_0x96e8('0x50')]({'where':{'id':_0x29a4a9[_0x96e8('0x47')]['id']}})[_0x96e8('0x25')](handleEntityNotFound(_0x11400e,null))[_0x96e8('0x25')](function(_0x22a41d){if(_0x22a41d){return _0x22a41d['removeUsers'](_0x29a4a9[_0x96e8('0x33')][_0x96e8('0x53')])[_0x96e8('0x25')](function(){if(_['isArray'](_0x29a4a9['query'][_0x96e8('0x53')])){for(var _0xaeceeb=0x0;_0xaeceeb<_0x29a4a9[_0x96e8('0x33')]['ids'][_0x96e8('0x39')];_0xaeceeb+=0x1){socket[_0x96e8('0x56')](_0x96e8('0x57'),{'UserId':Number(_0x29a4a9[_0x96e8('0x33')][_0x96e8('0x53')][_0xaeceeb]),'SquareProjectId':Number(_0x29a4a9[_0x96e8('0x47')]['id'])});}}else{socket[_0x96e8('0x56')](_0x96e8('0x57'),{'UserId':Number(_0x29a4a9[_0x96e8('0x33')][_0x96e8('0x53')]),'SquareProjectId':Number(_0x29a4a9[_0x96e8('0x47')]['id'])});}});}})['then'](respondWithStatusCode(_0x11400e,null))[_0x96e8('0x45')](handleError(_0x11400e,null));};exports[_0x96e8('0x58')]=function(_0x4a0b83,_0x1a7106,_0x2c9cd0){var _0x1f4f16={};var _0x511e2a={};var _0x34f44b;var _0x574b74;return db['SquareProject'][_0x96e8('0x59')]({'where':{'id':_0x4a0b83[_0x96e8('0x47')]['id']}})[_0x96e8('0x25')](handleEntityNotFound(_0x1a7106,null))[_0x96e8('0x25')](function(_0x1b15e9){if(_0x1b15e9){_0x34f44b=_0x1b15e9;_0x511e2a[_0x96e8('0x36')]=_[_0x96e8('0x48')](db['User'][_0x96e8('0x30')]);_0x511e2a[_0x96e8('0x33')]=_[_0x96e8('0x48')](_0x4a0b83[_0x96e8('0x33')]);_0x511e2a[_0x96e8('0x34')]=_[_0x96e8('0x35')](_0x511e2a['model'],_0x511e2a[_0x96e8('0x33')]);_0x1f4f16['attributes']=_[_0x96e8('0x35')](_0x511e2a[_0x96e8('0x36')],qs[_0x96e8('0x38')](_0x4a0b83[_0x96e8('0x33')][_0x96e8('0x38')]));_0x1f4f16[_0x96e8('0x37')]=_0x1f4f16[_0x96e8('0x37')][_0x96e8('0x39')]?_0x1f4f16['attributes']:_0x511e2a[_0x96e8('0x36')];_0x1f4f16[_0x96e8('0x3c')]=qs[_0x96e8('0x3d')](_0x4a0b83[_0x96e8('0x33')][_0x96e8('0x3d')]);_0x1f4f16[_0x96e8('0x40')]=qs[_0x96e8('0x34')](_['pick'](_0x4a0b83[_0x96e8('0x33')],_0x511e2a[_0x96e8('0x34')]));if(_0x4a0b83[_0x96e8('0x33')][_0x96e8('0x3f')]){_0x1f4f16['where']=_[_0x96e8('0x41')](_0x1f4f16['where'],{'$or':_[_0x96e8('0x2e')](_0x1f4f16[_0x96e8('0x37')],function(_0x407bbf){var _0x1ff533={};_0x1ff533[_0x407bbf]={'$like':'%'+_0x4a0b83['query'][_0x96e8('0x3f')]+'%'};return _0x1ff533;})});}_0x1f4f16=_[_0x96e8('0x41')]({},_0x1f4f16,_0x4a0b83[_0x96e8('0x49')]);return _0x34f44b['getUsers'](_0x1f4f16);}})[_0x96e8('0x25')](function(_0x1ce2de){if(_0x1ce2de){_0x574b74=_0x1ce2de[_0x96e8('0x39')];if(!_0x4a0b83[_0x96e8('0x33')][_0x96e8('0x3a')](_0x96e8('0x3b'))){_0x1f4f16[_0x96e8('0x1e')]=qs[_0x96e8('0x1e')](_0x4a0b83[_0x96e8('0x33')][_0x96e8('0x1e')]);_0x1f4f16['offset']=qs['offset'](_0x4a0b83[_0x96e8('0x33')][_0x96e8('0x1d')]);}return _0x34f44b[_0x96e8('0x58')](_0x1f4f16);}})[_0x96e8('0x25')](function(_0x138616){if(_0x138616){return _0x138616?{'count':_0x574b74,'rows':_0x138616}:null;}})[_0x96e8('0x25')](respondWithResult(_0x1a7106,null))[_0x96e8('0x45')](handleError(_0x1a7106,null));};