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 _0x36d7=['eml-format','rimraf','fast-json-patch','request-promise','mustache','to-csv','ejs','squel','jsforce','desk.js','querystring','papaparse','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','./squareProject.socket','sendStatus','status','json','count','offset','limit','set','Content-Range','apply','reject','save','update','destroy','then','get','SquareProjects','end','error','stack','name','send','map','fieldName','type','key','model','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','order','sort','where','filter','merge','options','SquareProject','include','rows','catch','show','rawAttributes','includeAll','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','find','params','addUsers','omit','ids','removeUsers','isArray','emit','userSquareProject:remove','getUsers','findOne','User','pick','nolimit'];(function(_0x9c2427,_0x17c865){var _0x51984f=function(_0x177af6){while(--_0x177af6){_0x9c2427['push'](_0x9c2427['shift']());}};_0x51984f(++_0x17c865);}(_0x36d7,0x1d1));var _0x736d=function(_0x477ffc,_0x58d9db){_0x477ffc=_0x477ffc-0x0;var _0x1fe1c3=_0x36d7[_0x477ffc];return _0x1fe1c3;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x736d('0x0'));var rimraf=require(_0x736d('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x736d('0x2'));var rp=require(_0x736d('0x3'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x736d('0x4'));var util=require('util');var path=require('path');var sox=require('sox');var csv=require(_0x736d('0x5'));var ejs=require(_0x736d('0x6'));var fs=require('fs');var _=require('lodash');var squel=require(_0x736d('0x7'));var crypto=require('crypto');var jsforce=require(_0x736d('0x8'));var deskjs=require(_0x736d('0x9'));var toCsv=require(_0x736d('0x5'));var querystring=require(_0x736d('0xa'));var Papa=require(_0x736d('0xb'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x736d('0xc'));var as=require(_0x736d('0xd'));var hardwareService=require(_0x736d('0xe'));var logger=require(_0x736d('0xf'))('api');var utils=require(_0x736d('0x10'));var config=require(_0x736d('0x11'));var db=require(_0x736d('0x12'))['db'];config[_0x736d('0x13')]=_[_0x736d('0x14')](config[_0x736d('0x13')],{'host':_0x736d('0x15'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require(_0x736d('0x16'))['register'](socket);function respondWithStatusCode(_0x16de31,_0x8bd116){_0x8bd116=_0x8bd116||0xcc;return function(_0x56f39a){if(_0x56f39a){return _0x16de31[_0x736d('0x17')](_0x8bd116);}return _0x16de31[_0x736d('0x18')](_0x8bd116)['end']();};}function respondWithResult(_0x138efc,_0x2501dd){_0x2501dd=_0x2501dd||0xc8;return function(_0x43f3e2){if(_0x43f3e2){return _0x138efc[_0x736d('0x18')](_0x2501dd)[_0x736d('0x19')](_0x43f3e2);}};}function respondWithFilteredResult(_0xa87a48,_0x5a80ec){return function(_0x398608){if(_0x398608){var _0x36b939=_0x398608[_0x736d('0x1a')],_0x249fbc=_0x5a80ec['offset'],_0x21a70d=_0x5a80ec[_0x736d('0x1b')]+_0x5a80ec[_0x736d('0x1c')],_0x493e0a;if(_0x21a70d>=_0x36b939){_0x21a70d=_0x36b939;_0x493e0a=0xc8;}else{_0x493e0a=0xce;}_0xa87a48[_0x736d('0x18')](_0x493e0a);return _0xa87a48[_0x736d('0x1d')](_0x736d('0x1e'),_0x249fbc+'-'+_0x21a70d+'/'+_0x36b939)['json'](_0x398608);}return null;};}function patchUpdates(_0x946f08){return function(_0x4786e5){try{jsonpatch[_0x736d('0x1f')](_0x4786e5,_0x946f08,!![]);}catch(_0x11d505){return BPromise[_0x736d('0x20')](_0x11d505);}return _0x4786e5[_0x736d('0x21')]();};}function saveUpdates(_0x47537e,_0x3a1801){return function(_0x2bc41a){if(_0x2bc41a){return _0x2bc41a[_0x736d('0x22')](_0x47537e)['then'](function(_0x5d3f61){return _0x5d3f61;});}return null;};}function removeEntity(_0x450ead,_0x440c99){return function(_0x49a56){if(_0x49a56){return _0x49a56[_0x736d('0x23')]()[_0x736d('0x24')](function(){var _0x39beed=_0x49a56[_0x736d('0x25')]({'plain':!![]});var _0x8724ec=_0x736d('0x26');return db['UserProfileResource']['destroy']({'where':{'type':_0x8724ec,'resourceId':_0x39beed['id']}})['then'](function(){return _0x49a56;});})[_0x736d('0x24')](function(){_0x450ead[_0x736d('0x18')](0xcc)[_0x736d('0x27')]();});}};}function handleEntityNotFound(_0x1a1671,_0x46ae7d){return function(_0x38f968){if(!_0x38f968){_0x1a1671[_0x736d('0x17')](0x194);}return _0x38f968;};}function handleError(_0x4d677c,_0x633a10){_0x633a10=_0x633a10||0x1f4;return function(_0x4a34f4){logger[_0x736d('0x28')](_0x4a34f4[_0x736d('0x29')]);if(_0x4a34f4[_0x736d('0x2a')]){delete _0x4a34f4[_0x736d('0x2a')];}_0x4d677c['status'](_0x633a10)[_0x736d('0x2b')](_0x4a34f4);};}exports['index']=function(_0x194efe,_0x15ec31){var _0x3cdce5={},_0x508d4a={},_0x446077={'count':0x0,'rows':[]};var _0x11cdbf=_[_0x736d('0x2c')](db['SquareProject']['rawAttributes'],function(_0x195774){return{'name':_0x195774[_0x736d('0x2d')],'type':_0x195774[_0x736d('0x2e')][_0x736d('0x2f')]};});_0x508d4a[_0x736d('0x30')]=_['map'](_0x11cdbf,_0x736d('0x2a'));_0x508d4a[_0x736d('0x31')]=_[_0x736d('0x32')](_0x194efe['query']);_0x508d4a[_0x736d('0x33')]=_['intersection'](_0x508d4a[_0x736d('0x30')],_0x508d4a[_0x736d('0x31')]);_0x3cdce5['attributes']=_[_0x736d('0x34')](_0x508d4a[_0x736d('0x30')],qs[_0x736d('0x35')](_0x194efe[_0x736d('0x31')][_0x736d('0x35')]));_0x3cdce5[_0x736d('0x36')]=_0x3cdce5[_0x736d('0x36')][_0x736d('0x37')]?_0x3cdce5[_0x736d('0x36')]:_0x508d4a['model'];if(!_0x194efe[_0x736d('0x31')][_0x736d('0x38')]('nolimit')){_0x3cdce5[_0x736d('0x1c')]=qs[_0x736d('0x1c')](_0x194efe[_0x736d('0x31')][_0x736d('0x1c')]);_0x3cdce5[_0x736d('0x1b')]=qs[_0x736d('0x1b')](_0x194efe[_0x736d('0x31')][_0x736d('0x1b')]);}_0x3cdce5[_0x736d('0x39')]=qs[_0x736d('0x3a')](_0x194efe[_0x736d('0x31')][_0x736d('0x3a')]);_0x3cdce5[_0x736d('0x3b')]=qs['filters'](_['pick'](_0x194efe[_0x736d('0x31')],_0x508d4a[_0x736d('0x33')]),_0x11cdbf);if(_0x194efe['query'][_0x736d('0x3c')]){_0x3cdce5[_0x736d('0x3b')]=_[_0x736d('0x3d')](_0x3cdce5[_0x736d('0x3b')],{'$or':_['map'](_0x11cdbf,function(_0x47b894){if(_0x47b894[_0x736d('0x2e')]!=='VIRTUAL'){var _0x4b89d0={};_0x4b89d0[_0x47b894[_0x736d('0x2a')]]={'$like':'%'+_0x194efe[_0x736d('0x31')][_0x736d('0x3c')]+'%'};return _0x4b89d0;}})});}_0x3cdce5=_[_0x736d('0x3d')]({},_0x3cdce5,_0x194efe[_0x736d('0x3e')]);var _0x13c9c1={'where':_0x3cdce5['where']};return db[_0x736d('0x3f')]['count'](_0x13c9c1)['then'](function(_0x5652ae){_0x446077[_0x736d('0x1a')]=_0x5652ae;if(_0x194efe[_0x736d('0x31')]['includeAll']){_0x3cdce5[_0x736d('0x40')]=[{'all':!![]}];}return db[_0x736d('0x3f')]['findAll'](_0x3cdce5);})[_0x736d('0x24')](function(_0x66d383){_0x446077[_0x736d('0x41')]=_0x66d383;return _0x446077;})[_0x736d('0x24')](respondWithFilteredResult(_0x15ec31,_0x3cdce5))[_0x736d('0x42')](handleError(_0x15ec31,null));};exports[_0x736d('0x43')]=function(_0x3452e1,_0x4cbe81){var _0x250190={'raw':![],'where':{'id':_0x3452e1['params']['id']}},_0x2ff13a={};_0x2ff13a[_0x736d('0x30')]=_['keys'](db['SquareProject'][_0x736d('0x44')]);_0x2ff13a['query']=_[_0x736d('0x32')](_0x3452e1[_0x736d('0x31')]);_0x2ff13a[_0x736d('0x33')]=_['intersection'](_0x2ff13a[_0x736d('0x30')],_0x2ff13a[_0x736d('0x31')]);_0x250190[_0x736d('0x36')]=_[_0x736d('0x34')](_0x2ff13a['model'],qs['fields'](_0x3452e1[_0x736d('0x31')][_0x736d('0x35')]));_0x250190[_0x736d('0x36')]=_0x250190[_0x736d('0x36')][_0x736d('0x37')]?_0x250190['attributes']:_0x2ff13a[_0x736d('0x30')];if(_0x3452e1[_0x736d('0x31')][_0x736d('0x45')]){_0x250190[_0x736d('0x40')]=[{'all':!![]}];}_0x250190=_[_0x736d('0x3d')]({},_0x250190,_0x3452e1[_0x736d('0x3e')]);return db[_0x736d('0x3f')]['find'](_0x250190)[_0x736d('0x24')](handleEntityNotFound(_0x4cbe81,null))[_0x736d('0x24')](respondWithResult(_0x4cbe81,null))[_0x736d('0x42')](handleError(_0x4cbe81,null));};exports[_0x736d('0x46')]=function(_0x2e9d71,_0x1ba582){return db['SquareProject']['create'](_0x2e9d71[_0x736d('0x47')],{})[_0x736d('0x24')](function(_0x22e7a0){var _0x589233=_0x2e9d71[_0x736d('0x48')]['get']({'plain':!![]});if(!_0x589233)throw new Error(_0x736d('0x49'));if(_0x589233[_0x736d('0x4a')]===_0x736d('0x48')){var _0xd02e30=_0x22e7a0['get']({'plain':!![]});var _0x217c8e=_0x736d('0x26');return db[_0x736d('0x4b')]['find']({'where':{'name':_0x217c8e,'userProfileId':_0x589233[_0x736d('0x4c')]},'raw':!![]})['then'](function(_0x18f259){if(_0x18f259&&_0x18f259[_0x736d('0x4d')]===0x0){return db['UserProfileResource'][_0x736d('0x46')]({'name':_0xd02e30[_0x736d('0x2a')],'resourceId':_0xd02e30['id'],'type':_0x18f259[_0x736d('0x2a')],'sectionId':_0x18f259['id']},{})[_0x736d('0x24')](function(){return _0x22e7a0;});}else{return _0x22e7a0;}})[_0x736d('0x42')](function(_0x424516){logger['error'](_0x736d('0x4e'),_0x424516);throw _0x424516;});}return _0x22e7a0;})[_0x736d('0x24')](respondWithResult(_0x1ba582,0xc9))[_0x736d('0x42')](handleError(_0x1ba582,null));};exports['update']=function(_0x5cb1e7,_0x3b1c92){if(_0x5cb1e7[_0x736d('0x47')]['id']){delete _0x5cb1e7[_0x736d('0x47')]['id'];}return db[_0x736d('0x3f')][_0x736d('0x4f')]({'where':{'id':_0x5cb1e7[_0x736d('0x50')]['id']}})['then'](handleEntityNotFound(_0x3b1c92,null))[_0x736d('0x24')](saveUpdates(_0x5cb1e7[_0x736d('0x47')],null))[_0x736d('0x24')](respondWithResult(_0x3b1c92,null))[_0x736d('0x42')](handleError(_0x3b1c92,null));};exports[_0x736d('0x23')]=function(_0x5824f9,_0x35c460){return db[_0x736d('0x3f')][_0x736d('0x4f')]({'where':{'id':_0x5824f9[_0x736d('0x50')]['id']}})[_0x736d('0x24')](handleEntityNotFound(_0x35c460,null))[_0x736d('0x24')](removeEntity(_0x35c460,null))['catch'](handleError(_0x35c460,null));};exports[_0x736d('0x51')]=function(_0x2dbc8b,_0x17db97,_0x52c17b){return db['SquareProject'][_0x736d('0x4f')]({'where':{'id':_0x2dbc8b['params']['id']}})[_0x736d('0x24')](handleEntityNotFound(_0x17db97,null))[_0x736d('0x24')](function(_0x386b6d){if(_0x386b6d){return _0x386b6d[_0x736d('0x51')](_0x2dbc8b[_0x736d('0x47')]['ids'],_[_0x736d('0x52')](_0x2dbc8b[_0x736d('0x47')],[_0x736d('0x53'),'id'])||{});}})[_0x736d('0x24')](respondWithResult(_0x17db97,null))['catch'](handleError(_0x17db97,null));};exports[_0x736d('0x54')]=function(_0x173fcd,_0x585da2,_0x25ac0a){return db['SquareProject'][_0x736d('0x4f')]({'where':{'id':_0x173fcd['params']['id']}})['then'](handleEntityNotFound(_0x585da2,null))[_0x736d('0x24')](function(_0x1fa69b){if(_0x1fa69b){return _0x1fa69b[_0x736d('0x54')](_0x173fcd[_0x736d('0x31')]['ids'])[_0x736d('0x24')](function(){if(_[_0x736d('0x55')](_0x173fcd['query'][_0x736d('0x53')])){for(var _0x1eecc6=0x0;_0x1eecc6<_0x173fcd[_0x736d('0x31')][_0x736d('0x53')][_0x736d('0x37')];_0x1eecc6+=0x1){socket[_0x736d('0x56')](_0x736d('0x57'),{'UserId':Number(_0x173fcd['query'][_0x736d('0x53')][_0x1eecc6]),'SquareProjectId':Number(_0x173fcd['params']['id'])});}}else{socket[_0x736d('0x56')](_0x736d('0x57'),{'UserId':Number(_0x173fcd[_0x736d('0x31')][_0x736d('0x53')]),'SquareProjectId':Number(_0x173fcd[_0x736d('0x50')]['id'])});}});}})[_0x736d('0x24')](respondWithStatusCode(_0x585da2,null))[_0x736d('0x42')](handleError(_0x585da2,null));};exports[_0x736d('0x58')]=function(_0x7b7661,_0x5508a1,_0x1ccd6b){var _0x59aa5a={};var _0x21e864={};var _0x56a696;var _0x4ebdc3;return db[_0x736d('0x3f')][_0x736d('0x59')]({'where':{'id':_0x7b7661['params']['id']}})[_0x736d('0x24')](handleEntityNotFound(_0x5508a1,null))[_0x736d('0x24')](function(_0x37790f){if(_0x37790f){_0x56a696=_0x37790f;_0x21e864[_0x736d('0x30')]=_['keys'](db[_0x736d('0x5a')][_0x736d('0x44')]);_0x21e864[_0x736d('0x31')]=_[_0x736d('0x32')](_0x7b7661[_0x736d('0x31')]);_0x21e864[_0x736d('0x33')]=_[_0x736d('0x34')](_0x21e864[_0x736d('0x30')],_0x21e864[_0x736d('0x31')]);_0x59aa5a[_0x736d('0x36')]=_[_0x736d('0x34')](_0x21e864[_0x736d('0x30')],qs[_0x736d('0x35')](_0x7b7661[_0x736d('0x31')]['fields']));_0x59aa5a[_0x736d('0x36')]=_0x59aa5a[_0x736d('0x36')][_0x736d('0x37')]?_0x59aa5a[_0x736d('0x36')]:_0x21e864['model'];_0x59aa5a['order']=qs['sort'](_0x7b7661[_0x736d('0x31')]['sort']);_0x59aa5a[_0x736d('0x3b')]=qs[_0x736d('0x33')](_[_0x736d('0x5b')](_0x7b7661['query'],_0x21e864[_0x736d('0x33')]));if(_0x7b7661[_0x736d('0x31')]['filter']){_0x59aa5a[_0x736d('0x3b')]=_[_0x736d('0x3d')](_0x59aa5a[_0x736d('0x3b')],{'$or':_[_0x736d('0x2c')](_0x59aa5a[_0x736d('0x36')],function(_0x2b572d){var _0xc37cda={};_0xc37cda[_0x2b572d]={'$like':'%'+_0x7b7661[_0x736d('0x31')][_0x736d('0x3c')]+'%'};return _0xc37cda;})});}_0x59aa5a=_['merge']({},_0x59aa5a,_0x7b7661[_0x736d('0x3e')]);return _0x56a696[_0x736d('0x58')](_0x59aa5a);}})[_0x736d('0x24')](function(_0x26388e){if(_0x26388e){_0x4ebdc3=_0x26388e[_0x736d('0x37')];if(!_0x7b7661[_0x736d('0x31')]['hasOwnProperty'](_0x736d('0x5c'))){_0x59aa5a['limit']=qs[_0x736d('0x1c')](_0x7b7661[_0x736d('0x31')][_0x736d('0x1c')]);_0x59aa5a[_0x736d('0x1b')]=qs[_0x736d('0x1b')](_0x7b7661[_0x736d('0x31')][_0x736d('0x1b')]);}return _0x56a696['getUsers'](_0x59aa5a);}})[_0x736d('0x24')](function(_0x51787b){if(_0x51787b){return _0x51787b?{'count':_0x4ebdc3,'rows':_0x51787b}:null;}})[_0x736d('0x24')](respondWithResult(_0x5508a1,null))[_0x736d('0x42')](handleError(_0x5508a1,null));};