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 _0x9957=['type','map','keys','query','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','filters','merge','VIRTUAL','filter','includeAll','findAll','show','params','rawAttributes','options','catch','create','user','role','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','find','ids','omit','removeUsers','isArray','emit','userSquareProject:remove','getUsers','findOne','User','pick','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','register','sendStatus','status','end','json','offset','undefined','count','set','Content-Range','apply','reject','save','update','destroy','then','get','SquareProjects','UserProfileResource','error','stack','name','send','render','body','contact','message','agent','interaction','index','SquareProject','fieldName'];(function(_0x2cf2e9,_0xd58ea1){var _0xd3670d=function(_0x272868){while(--_0x272868){_0x2cf2e9['push'](_0x2cf2e9['shift']());}};_0xd3670d(++_0xd58ea1);}(_0x9957,0x93));var _0x7995=function(_0x4cf98e,_0xba4b79){_0x4cf98e=_0x4cf98e-0x0;var _0x1623ac=_0x9957[_0x4cf98e];return _0x1623ac;};'use strict';var emlformat=require(_0x7995('0x0'));var rimraf=require(_0x7995('0x1'));var zipdir=require(_0x7995('0x2'));var jsonpatch=require(_0x7995('0x3'));var rp=require('request-promise');var moment=require(_0x7995('0x4'));var BPromise=require(_0x7995('0x5'));var Mustache=require(_0x7995('0x6'));var util=require(_0x7995('0x7'));var path=require('path');var sox=require(_0x7995('0x8'));var csv=require(_0x7995('0x9'));var ejs=require(_0x7995('0xa'));var fs=require('fs');var fs_extra=require(_0x7995('0xb'));var _=require(_0x7995('0xc'));var squel=require(_0x7995('0xd'));var crypto=require('crypto');var jsforce=require(_0x7995('0xe'));var deskjs=require(_0x7995('0xf'));var toCsv=require('to-csv');var querystring=require(_0x7995('0x10'));var Papa=require(_0x7995('0x11'));var Redis=require(_0x7995('0x12'));var authService=require(_0x7995('0x13'));var qs=require(_0x7995('0x14'));var as=require(_0x7995('0x15'));var hardwareService=require(_0x7995('0x16'));var logger=require('../../config/logger')(_0x7995('0x17'));var utils=require(_0x7995('0x18'));var config=require('../../config/environment');var licenseUtil=require(_0x7995('0x19'));var db=require(_0x7995('0x1a'))['db'];config[_0x7995('0x1b')]=_[_0x7995('0x1c')](config[_0x7995('0x1b')],{'host':_0x7995('0x1d'),'port':0x18eb});var socket=require(_0x7995('0x1e'))(new Redis(config['redis']));require('./squareProject.socket')[_0x7995('0x1f')](socket);function respondWithStatusCode(_0x2233dd,_0x24b5bb){_0x24b5bb=_0x24b5bb||0xcc;return function(_0x321ae8){if(_0x321ae8){return _0x2233dd[_0x7995('0x20')](_0x24b5bb);}return _0x2233dd[_0x7995('0x21')](_0x24b5bb)[_0x7995('0x22')]();};}function respondWithResult(_0x41cbf0,_0x5377e5){_0x5377e5=_0x5377e5||0xc8;return function(_0x2eeacc){if(_0x2eeacc){return _0x41cbf0['status'](_0x5377e5)[_0x7995('0x23')](_0x2eeacc);}};}function respondWithFilteredResult(_0x37f297,_0x43d4b8){return function(_0x291317){if(_0x291317){var _0x1e1415=typeof _0x43d4b8[_0x7995('0x24')]==='undefined'&&typeof _0x43d4b8['limit']===_0x7995('0x25');var _0x5e6f90=_0x291317['count'];var _0x3ec178=_0x1e1415?0x0:_0x43d4b8[_0x7995('0x24')];var _0x4cbe10=_0x1e1415?_0x291317[_0x7995('0x26')]:_0x43d4b8['offset']+_0x43d4b8['limit'];var _0x3e4c54;if(_0x4cbe10>=_0x5e6f90){_0x4cbe10=_0x5e6f90;_0x3e4c54=0xc8;}else{_0x3e4c54=0xce;}_0x37f297[_0x7995('0x21')](_0x3e4c54);return _0x37f297[_0x7995('0x27')](_0x7995('0x28'),_0x3ec178+'-'+_0x4cbe10+'/'+_0x5e6f90)[_0x7995('0x23')](_0x291317);}return null;};}function patchUpdates(_0x1c278a){return function(_0x5d40ae){try{jsonpatch[_0x7995('0x29')](_0x5d40ae,_0x1c278a,!![]);}catch(_0x46ee4b){return BPromise[_0x7995('0x2a')](_0x46ee4b);}return _0x5d40ae[_0x7995('0x2b')]();};}function saveUpdates(_0x563799,_0x13bc35){return function(_0x475351){if(_0x475351){return _0x475351[_0x7995('0x2c')](_0x563799)['then'](function(_0x39df42){return _0x39df42;});}return null;};}function removeEntity(_0x34e70c,_0x401dc3){return function(_0x268ce7){if(_0x268ce7){return _0x268ce7[_0x7995('0x2d')]()[_0x7995('0x2e')](function(){var _0x56691a=_0x268ce7[_0x7995('0x2f')]({'plain':!![]});var _0x5911c3=_0x7995('0x30');return db[_0x7995('0x31')][_0x7995('0x2d')]({'where':{'type':_0x5911c3,'resourceId':_0x56691a['id']}})[_0x7995('0x2e')](function(){return _0x268ce7;});})[_0x7995('0x2e')](function(){_0x34e70c['status'](0xcc)[_0x7995('0x22')]();});}};}function handleEntityNotFound(_0x514445,_0x456a28){return function(_0x3250e0){if(!_0x3250e0){_0x514445[_0x7995('0x20')](0x194);}return _0x3250e0;};}function handleError(_0x574574,_0x530611){_0x530611=_0x530611||0x1f4;return function(_0x48e573){logger[_0x7995('0x32')](_0x48e573[_0x7995('0x33')]);if(_0x48e573[_0x7995('0x34')]){delete _0x48e573[_0x7995('0x34')];}_0x574574[_0x7995('0x21')](_0x530611)[_0x7995('0x35')](_0x48e573);};}function getMustacheRender(_0x538841,_0x481c74){return Mustache[_0x7995('0x36')](_0x538841,_['merge'](_0x481c74[_0x7995('0x37')],{'contact':_0x481c74[_0x7995('0x38')],'message':_0x481c74[_0x7995('0x39')],'agent':_0x481c74[_0x7995('0x3a')],'interaction':_0x481c74[_0x7995('0x3b')],'account':_0x481c74['account']}))||'';}exports[_0x7995('0x3c')]=function(_0x33e24e,_0x5dd802){var _0x48db25={},_0x577412={},_0x45bc5e={'count':0x0,'rows':[]};var _0x3acfc3=_['map'](db[_0x7995('0x3d')]['rawAttributes'],function(_0x37917b){return{'name':_0x37917b[_0x7995('0x3e')],'type':_0x37917b[_0x7995('0x3f')]['key']};});_0x577412['model']=_[_0x7995('0x40')](_0x3acfc3,'name');_0x577412['query']=_[_0x7995('0x41')](_0x33e24e[_0x7995('0x42')]);_0x577412['filters']=_[_0x7995('0x43')](_0x577412[_0x7995('0x44')],_0x577412[_0x7995('0x42')]);_0x48db25[_0x7995('0x45')]=_[_0x7995('0x43')](_0x577412['model'],qs[_0x7995('0x46')](_0x33e24e[_0x7995('0x42')][_0x7995('0x46')]));_0x48db25[_0x7995('0x45')]=_0x48db25['attributes'][_0x7995('0x47')]?_0x48db25[_0x7995('0x45')]:_0x577412[_0x7995('0x44')];if(!_0x33e24e[_0x7995('0x42')][_0x7995('0x48')](_0x7995('0x49'))){_0x48db25['limit']=qs[_0x7995('0x4a')](_0x33e24e[_0x7995('0x42')][_0x7995('0x4a')]);_0x48db25[_0x7995('0x24')]=qs[_0x7995('0x24')](_0x33e24e[_0x7995('0x42')][_0x7995('0x24')]);}_0x48db25[_0x7995('0x4b')]=qs[_0x7995('0x4c')](_0x33e24e[_0x7995('0x42')][_0x7995('0x4c')]);_0x48db25[_0x7995('0x4d')]=qs[_0x7995('0x4e')](_['pick'](_0x33e24e['query'],_0x577412[_0x7995('0x4e')]),_0x3acfc3);if(_0x33e24e[_0x7995('0x42')]['filter']){_0x48db25['where']=_[_0x7995('0x4f')](_0x48db25['where'],{'$or':_['map'](_0x3acfc3,function(_0x23da6b){if(_0x23da6b[_0x7995('0x3f')]!==_0x7995('0x50')){var _0x576b96={};_0x576b96[_0x23da6b[_0x7995('0x34')]]={'$like':'%'+_0x33e24e['query'][_0x7995('0x51')]+'%'};return _0x576b96;}})});}_0x48db25=_['merge']({},_0x48db25,_0x33e24e['options']);var _0x39c5b8={'where':_0x48db25[_0x7995('0x4d')]};return db[_0x7995('0x3d')][_0x7995('0x26')](_0x39c5b8)['then'](function(_0x3c5cde){_0x45bc5e[_0x7995('0x26')]=_0x3c5cde;if(_0x33e24e[_0x7995('0x42')][_0x7995('0x52')]){_0x48db25['include']=[{'all':!![]}];}return db['SquareProject'][_0x7995('0x53')](_0x48db25);})['then'](function(_0x23c41d){_0x45bc5e['rows']=_0x23c41d;return _0x45bc5e;})[_0x7995('0x2e')](respondWithFilteredResult(_0x5dd802,_0x48db25))['catch'](handleError(_0x5dd802,null));};exports[_0x7995('0x54')]=function(_0x1b0373,_0x4d9245){var _0x3e9e62={'raw':![],'where':{'id':_0x1b0373[_0x7995('0x55')]['id']}},_0x336ff2={};_0x336ff2[_0x7995('0x44')]=_['keys'](db[_0x7995('0x3d')][_0x7995('0x56')]);_0x336ff2[_0x7995('0x42')]=_['keys'](_0x1b0373[_0x7995('0x42')]);_0x336ff2[_0x7995('0x4e')]=_[_0x7995('0x43')](_0x336ff2[_0x7995('0x44')],_0x336ff2[_0x7995('0x42')]);_0x3e9e62['attributes']=_[_0x7995('0x43')](_0x336ff2[_0x7995('0x44')],qs['fields'](_0x1b0373[_0x7995('0x42')]['fields']));_0x3e9e62[_0x7995('0x45')]=_0x3e9e62[_0x7995('0x45')][_0x7995('0x47')]?_0x3e9e62[_0x7995('0x45')]:_0x336ff2[_0x7995('0x44')];if(_0x1b0373[_0x7995('0x42')][_0x7995('0x52')]){_0x3e9e62['include']=[{'all':!![]}];}_0x3e9e62=_[_0x7995('0x4f')]({},_0x3e9e62,_0x1b0373[_0x7995('0x57')]);return db[_0x7995('0x3d')]['find'](_0x3e9e62)[_0x7995('0x2e')](handleEntityNotFound(_0x4d9245,null))[_0x7995('0x2e')](respondWithResult(_0x4d9245,null))[_0x7995('0x58')](handleError(_0x4d9245,null));};exports['create']=function(_0x4ec548,_0x5a592e){return db[_0x7995('0x3d')][_0x7995('0x59')](_0x4ec548['body'],{})[_0x7995('0x2e')](function(_0x29f300){var _0x31f27c=_0x4ec548[_0x7995('0x5a')][_0x7995('0x2f')]({'plain':!![]});if(!_0x31f27c)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x31f27c[_0x7995('0x5b')]==='user'){var _0x14fe7f=_0x29f300[_0x7995('0x2f')]({'plain':!![]});var _0x206d2a='SquareProjects';return db['UserProfileSection']['find']({'where':{'name':_0x206d2a,'userProfileId':_0x31f27c['userProfileId']},'raw':!![]})[_0x7995('0x2e')](function(_0x3709de){if(_0x3709de&&_0x3709de[_0x7995('0x5c')]===0x0){return db[_0x7995('0x31')][_0x7995('0x59')]({'name':_0x14fe7f[_0x7995('0x34')],'resourceId':_0x14fe7f['id'],'type':_0x3709de[_0x7995('0x34')],'sectionId':_0x3709de['id']},{})[_0x7995('0x2e')](function(){return _0x29f300;});}else{return _0x29f300;}})[_0x7995('0x58')](function(_0x17ecd3){logger[_0x7995('0x32')](_0x7995('0x5d'),_0x17ecd3);throw _0x17ecd3;});}return _0x29f300;})[_0x7995('0x2e')](respondWithResult(_0x5a592e,0xc9))[_0x7995('0x58')](handleError(_0x5a592e,null));};exports[_0x7995('0x2c')]=function(_0x416133,_0x447a2b){if(_0x416133[_0x7995('0x37')]['id']){delete _0x416133[_0x7995('0x37')]['id'];}return db['SquareProject'][_0x7995('0x5e')]({'where':{'id':_0x416133[_0x7995('0x55')]['id']}})[_0x7995('0x2e')](handleEntityNotFound(_0x447a2b,null))[_0x7995('0x2e')](saveUpdates(_0x416133['body'],null))['then'](respondWithResult(_0x447a2b,null))[_0x7995('0x58')](handleError(_0x447a2b,null));};exports[_0x7995('0x2d')]=function(_0x5b9467,_0x332a85){return db['SquareProject'][_0x7995('0x5e')]({'where':{'id':_0x5b9467[_0x7995('0x55')]['id']}})[_0x7995('0x2e')](handleEntityNotFound(_0x332a85,null))[_0x7995('0x2e')](removeEntity(_0x332a85,null))['catch'](handleError(_0x332a85,null));};exports['addUsers']=function(_0x40e5fc,_0x398fac,_0x6c0221){return db[_0x7995('0x3d')][_0x7995('0x5e')]({'where':{'id':_0x40e5fc[_0x7995('0x55')]['id']}})[_0x7995('0x2e')](handleEntityNotFound(_0x398fac,null))[_0x7995('0x2e')](function(_0x984c23){if(_0x984c23){return _0x984c23['addUsers'](_0x40e5fc[_0x7995('0x37')][_0x7995('0x5f')],_[_0x7995('0x60')](_0x40e5fc[_0x7995('0x37')],['ids','id'])||{});}})['then'](respondWithResult(_0x398fac,null))[_0x7995('0x58')](handleError(_0x398fac,null));};exports[_0x7995('0x61')]=function(_0x47d5d7,_0x971a23,_0x375fc9){return db[_0x7995('0x3d')][_0x7995('0x5e')]({'where':{'id':_0x47d5d7[_0x7995('0x55')]['id']}})['then'](handleEntityNotFound(_0x971a23,null))[_0x7995('0x2e')](function(_0x564fca){if(_0x564fca){return _0x564fca[_0x7995('0x61')](_0x47d5d7[_0x7995('0x42')][_0x7995('0x5f')])[_0x7995('0x2e')](function(){if(_[_0x7995('0x62')](_0x47d5d7[_0x7995('0x42')][_0x7995('0x5f')])){for(var _0x44372a=0x0;_0x44372a<_0x47d5d7[_0x7995('0x42')][_0x7995('0x5f')][_0x7995('0x47')];_0x44372a+=0x1){socket[_0x7995('0x63')]('userSquareProject:remove',{'UserId':Number(_0x47d5d7[_0x7995('0x42')][_0x7995('0x5f')][_0x44372a]),'SquareProjectId':Number(_0x47d5d7[_0x7995('0x55')]['id'])});}}else{socket[_0x7995('0x63')](_0x7995('0x64'),{'UserId':Number(_0x47d5d7['query']['ids']),'SquareProjectId':Number(_0x47d5d7[_0x7995('0x55')]['id'])});}});}})[_0x7995('0x2e')](respondWithStatusCode(_0x971a23,null))[_0x7995('0x58')](handleError(_0x971a23,null));};exports[_0x7995('0x65')]=function(_0x5aa2ec,_0x22d317,_0x50a12e){var _0x5df621={};var _0xca8238={};var _0x36d27d;var _0x3f0a71;return db[_0x7995('0x3d')][_0x7995('0x66')]({'where':{'id':_0x5aa2ec[_0x7995('0x55')]['id']}})[_0x7995('0x2e')](handleEntityNotFound(_0x22d317,null))[_0x7995('0x2e')](function(_0x3fde86){if(_0x3fde86){_0x36d27d=_0x3fde86;_0xca8238[_0x7995('0x44')]=_['keys'](db[_0x7995('0x67')][_0x7995('0x56')]);_0xca8238[_0x7995('0x42')]=_['keys'](_0x5aa2ec[_0x7995('0x42')]);_0xca8238[_0x7995('0x4e')]=_[_0x7995('0x43')](_0xca8238[_0x7995('0x44')],_0xca8238[_0x7995('0x42')]);_0x5df621[_0x7995('0x45')]=_[_0x7995('0x43')](_0xca8238[_0x7995('0x44')],qs[_0x7995('0x46')](_0x5aa2ec[_0x7995('0x42')][_0x7995('0x46')]));_0x5df621['attributes']=_0x5df621['attributes'][_0x7995('0x47')]?_0x5df621[_0x7995('0x45')]:_0xca8238[_0x7995('0x44')];_0x5df621[_0x7995('0x4b')]=qs['sort'](_0x5aa2ec[_0x7995('0x42')][_0x7995('0x4c')]);_0x5df621['where']=qs['filters'](_[_0x7995('0x68')](_0x5aa2ec[_0x7995('0x42')],_0xca8238['filters']));if(_0x5aa2ec[_0x7995('0x42')]['filter']){_0x5df621[_0x7995('0x4d')]=_[_0x7995('0x4f')](_0x5df621['where'],{'$or':_['map'](_0x5df621[_0x7995('0x45')],function(_0x50c1a4){var _0x31b9e6={};_0x31b9e6[_0x50c1a4]={'$like':'%'+_0x5aa2ec[_0x7995('0x42')][_0x7995('0x51')]+'%'};return _0x31b9e6;})});}_0x5df621=_[_0x7995('0x4f')]({},_0x5df621,_0x5aa2ec[_0x7995('0x57')]);return _0x36d27d[_0x7995('0x65')](_0x5df621);}})[_0x7995('0x2e')](function(_0x14cb17){if(_0x14cb17){_0x3f0a71=_0x14cb17[_0x7995('0x47')];if(!_0x5aa2ec[_0x7995('0x42')][_0x7995('0x48')](_0x7995('0x49'))){_0x5df621[_0x7995('0x4a')]=qs[_0x7995('0x4a')](_0x5aa2ec[_0x7995('0x42')][_0x7995('0x4a')]);_0x5df621[_0x7995('0x24')]=qs[_0x7995('0x24')](_0x5aa2ec[_0x7995('0x42')][_0x7995('0x24')]);}return _0x36d27d[_0x7995('0x65')](_0x5df621);}})[_0x7995('0x2e')](function(_0x11fe75){if(_0x11fe75){return _0x11fe75?{'count':_0x3f0a71,'rows':_0x11fe75}:null;}})[_0x7995('0x2e')](respondWithResult(_0x22d317,null))[_0x7995('0x58')](handleError(_0x22d317,null));};