Built motion from commit (unavailable).|2.5.21
[motion2.git] / 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 _0xc4ad=['send','map','rawAttributes','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','sort','where','pick','type','SquareProject','includeAll','findAll','rows','catch','show','include','options','find','create','body','user','get','role','UserProfileSection','userProfileId','autoAssociation','destroy','params','addUsers','ids','removeUsers','isArray','userSquareProject:remove','getUsers','User','order','filter','merge','html-pdf','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','jsforce','ioredis','../../components/parsers/advancedSearch','api','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','register','sendStatus','status','end','json','count','offset','set','Content-Range','apply','reject','save','update','then','UserProfileResource','error','name'];(function(_0x5769f5,_0xd0bbaf){var _0x513a6f=function(_0x3d3b3a){while(--_0x3d3b3a){_0x5769f5['push'](_0x5769f5['shift']());}};_0x513a6f(++_0xd0bbaf);}(_0xc4ad,0x190));var _0xdc4a=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0xc4ad[_0x3dd15e];return _0x231fd0;};'use strict';var pdf=require(_0xdc4a('0x0'));var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xdc4a('0x1'));var rp=require('request-promise');var moment=require(_0xdc4a('0x2'));var BPromise=require(_0xdc4a('0x3'));var Mustache=require(_0xdc4a('0x4'));var util=require(_0xdc4a('0x5'));var path=require(_0xdc4a('0x6'));var sox=require(_0xdc4a('0x7'));var csv=require(_0xdc4a('0x8'));var ejs=require(_0xdc4a('0x9'));var fs=require('fs');var _=require(_0xdc4a('0xa'));var squel=require(_0xdc4a('0xb'));var crypto=require('crypto');var jsforce=require(_0xdc4a('0xc'));var deskjs=require('desk.js');var toCsv=require(_0xdc4a('0x8'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0xdc4a('0xd'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0xdc4a('0xe'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xdc4a('0xf'));var utils=require('../../config/utils');var config=require(_0xdc4a('0x10'));var licenseUtil=require(_0xdc4a('0x11'));var db=require(_0xdc4a('0x12'))['db'];config[_0xdc4a('0x13')]=_[_0xdc4a('0x14')](config[_0xdc4a('0x13')],{'host':_0xdc4a('0x15'),'port':0x18eb});var socket=require(_0xdc4a('0x16'))(new Redis(config['redis']));require('./squareProject.socket')[_0xdc4a('0x17')](socket);function respondWithStatusCode(_0x26dd71,_0xe4a470){_0xe4a470=_0xe4a470||0xcc;return function(_0x5cd78b){if(_0x5cd78b){return _0x26dd71[_0xdc4a('0x18')](_0xe4a470);}return _0x26dd71[_0xdc4a('0x19')](_0xe4a470)[_0xdc4a('0x1a')]();};}function respondWithResult(_0x1fe6ab,_0x5a758f){_0x5a758f=_0x5a758f||0xc8;return function(_0x23b8a8){if(_0x23b8a8){return _0x1fe6ab[_0xdc4a('0x19')](_0x5a758f)[_0xdc4a('0x1b')](_0x23b8a8);}};}function respondWithFilteredResult(_0x1bea89,_0x34879b){return function(_0x1d28fe){if(_0x1d28fe){var _0x5358e2=_0x1d28fe[_0xdc4a('0x1c')],_0x88ae31=_0x34879b['offset'],_0x2e3989=_0x34879b[_0xdc4a('0x1d')]+_0x34879b['limit'],_0x593a3b;if(_0x2e3989>=_0x5358e2){_0x2e3989=_0x5358e2;_0x593a3b=0xc8;}else{_0x593a3b=0xce;}_0x1bea89[_0xdc4a('0x19')](_0x593a3b);return _0x1bea89[_0xdc4a('0x1e')](_0xdc4a('0x1f'),_0x88ae31+'-'+_0x2e3989+'/'+_0x5358e2)[_0xdc4a('0x1b')](_0x1d28fe);}return null;};}function patchUpdates(_0x887dea){return function(_0x4a03a4){try{jsonpatch[_0xdc4a('0x20')](_0x4a03a4,_0x887dea,!![]);}catch(_0x1e0cb9){return BPromise[_0xdc4a('0x21')](_0x1e0cb9);}return _0x4a03a4[_0xdc4a('0x22')]();};}function saveUpdates(_0x1a5d49,_0xe64112){return function(_0x5b4d90){if(_0x5b4d90){return _0x5b4d90[_0xdc4a('0x23')](_0x1a5d49)[_0xdc4a('0x24')](function(_0x49696b){return _0x49696b;});}return null;};}function removeEntity(_0x394582,_0x9a3176){return function(_0x170836){if(_0x170836){return _0x170836['destroy']()[_0xdc4a('0x24')](function(){var _0xd80536=_0x170836['get']({'plain':!![]});var _0x1298b7='SquareProjects';return db[_0xdc4a('0x25')]['destroy']({'where':{'type':_0x1298b7,'resourceId':_0xd80536['id']}})[_0xdc4a('0x24')](function(){return _0x170836;});})[_0xdc4a('0x24')](function(){_0x394582['status'](0xcc)[_0xdc4a('0x1a')]();});}};}function handleEntityNotFound(_0x2820f7,_0x2780e7){return function(_0x568aa3){if(!_0x568aa3){_0x2820f7[_0xdc4a('0x18')](0x194);}return _0x568aa3;};}function handleError(_0x3b04c0,_0x242b8c){_0x242b8c=_0x242b8c||0x1f4;return function(_0x400b37){logger[_0xdc4a('0x26')](_0x400b37['stack']);if(_0x400b37[_0xdc4a('0x27')]){delete _0x400b37[_0xdc4a('0x27')];}_0x3b04c0[_0xdc4a('0x19')](_0x242b8c)[_0xdc4a('0x28')](_0x400b37);};}exports['index']=function(_0x434f1,_0x252061){var _0x40f57a={},_0x4affe3={},_0x1601d7={'count':0x0,'rows':[]};var _0x5c202f=_[_0xdc4a('0x29')](db['SquareProject'][_0xdc4a('0x2a')],function(_0x15108e){return{'name':_0x15108e['fieldName'],'type':_0x15108e['type'][_0xdc4a('0x2b')]};});_0x4affe3[_0xdc4a('0x2c')]=_[_0xdc4a('0x29')](_0x5c202f,_0xdc4a('0x27'));_0x4affe3[_0xdc4a('0x2d')]=_[_0xdc4a('0x2e')](_0x434f1['query']);_0x4affe3[_0xdc4a('0x2f')]=_[_0xdc4a('0x30')](_0x4affe3[_0xdc4a('0x2c')],_0x4affe3[_0xdc4a('0x2d')]);_0x40f57a[_0xdc4a('0x31')]=_[_0xdc4a('0x30')](_0x4affe3[_0xdc4a('0x2c')],qs['fields'](_0x434f1['query'][_0xdc4a('0x32')]));_0x40f57a['attributes']=_0x40f57a[_0xdc4a('0x31')][_0xdc4a('0x33')]?_0x40f57a[_0xdc4a('0x31')]:_0x4affe3[_0xdc4a('0x2c')];if(!_0x434f1[_0xdc4a('0x2d')][_0xdc4a('0x34')](_0xdc4a('0x35'))){_0x40f57a[_0xdc4a('0x36')]=qs[_0xdc4a('0x36')](_0x434f1[_0xdc4a('0x2d')][_0xdc4a('0x36')]);_0x40f57a[_0xdc4a('0x1d')]=qs[_0xdc4a('0x1d')](_0x434f1[_0xdc4a('0x2d')][_0xdc4a('0x1d')]);}_0x40f57a['order']=qs['sort'](_0x434f1[_0xdc4a('0x2d')][_0xdc4a('0x37')]);_0x40f57a[_0xdc4a('0x38')]=qs[_0xdc4a('0x2f')](_[_0xdc4a('0x39')](_0x434f1['query'],_0x4affe3['filters']),_0x5c202f);if(_0x434f1[_0xdc4a('0x2d')]['filter']){_0x40f57a['where']=_['merge'](_0x40f57a[_0xdc4a('0x38')],{'$or':_['map'](_0x5c202f,function(_0x351393){if(_0x351393[_0xdc4a('0x3a')]!=='VIRTUAL'){var _0x710921={};_0x710921[_0x351393['name']]={'$like':'%'+_0x434f1['query']['filter']+'%'};return _0x710921;}})});}_0x40f57a=_['merge']({},_0x40f57a,_0x434f1['options']);var _0x262dad={'where':_0x40f57a[_0xdc4a('0x38')]};return db[_0xdc4a('0x3b')]['count'](_0x262dad)['then'](function(_0x324d55){_0x1601d7['count']=_0x324d55;if(_0x434f1[_0xdc4a('0x2d')][_0xdc4a('0x3c')]){_0x40f57a['include']=[{'all':!![]}];}return db['SquareProject'][_0xdc4a('0x3d')](_0x40f57a);})[_0xdc4a('0x24')](function(_0x5673c3){_0x1601d7[_0xdc4a('0x3e')]=_0x5673c3;return _0x1601d7;})['then'](respondWithFilteredResult(_0x252061,_0x40f57a))[_0xdc4a('0x3f')](handleError(_0x252061,null));};exports[_0xdc4a('0x40')]=function(_0x5e0d0e,_0x1ef12a){var _0x7c7b53={'raw':![],'where':{'id':_0x5e0d0e['params']['id']}},_0x2b68a3={};_0x2b68a3['model']=_[_0xdc4a('0x2e')](db[_0xdc4a('0x3b')][_0xdc4a('0x2a')]);_0x2b68a3[_0xdc4a('0x2d')]=_[_0xdc4a('0x2e')](_0x5e0d0e[_0xdc4a('0x2d')]);_0x2b68a3['filters']=_['intersection'](_0x2b68a3['model'],_0x2b68a3['query']);_0x7c7b53['attributes']=_[_0xdc4a('0x30')](_0x2b68a3['model'],qs[_0xdc4a('0x32')](_0x5e0d0e[_0xdc4a('0x2d')]['fields']));_0x7c7b53[_0xdc4a('0x31')]=_0x7c7b53['attributes'][_0xdc4a('0x33')]?_0x7c7b53['attributes']:_0x2b68a3[_0xdc4a('0x2c')];if(_0x5e0d0e[_0xdc4a('0x2d')][_0xdc4a('0x3c')]){_0x7c7b53[_0xdc4a('0x41')]=[{'all':!![]}];}_0x7c7b53=_['merge']({},_0x7c7b53,_0x5e0d0e[_0xdc4a('0x42')]);return db[_0xdc4a('0x3b')][_0xdc4a('0x43')](_0x7c7b53)[_0xdc4a('0x24')](handleEntityNotFound(_0x1ef12a,null))[_0xdc4a('0x24')](respondWithResult(_0x1ef12a,null))[_0xdc4a('0x3f')](handleError(_0x1ef12a,null));};exports[_0xdc4a('0x44')]=function(_0x38de02,_0x53d868){return db['SquareProject'][_0xdc4a('0x44')](_0x38de02[_0xdc4a('0x45')],{})[_0xdc4a('0x24')](function(_0x414e74){var _0x5c70b2=_0x38de02[_0xdc4a('0x46')][_0xdc4a('0x47')]({'plain':!![]});if(!_0x5c70b2)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x5c70b2[_0xdc4a('0x48')]===_0xdc4a('0x46')){var _0x223b6b=_0x414e74['get']({'plain':!![]});var _0x5eb9e3='SquareProjects';return db[_0xdc4a('0x49')]['find']({'where':{'name':_0x5eb9e3,'userProfileId':_0x5c70b2[_0xdc4a('0x4a')]},'raw':!![]})[_0xdc4a('0x24')](function(_0x27603f){if(_0x27603f&&_0x27603f[_0xdc4a('0x4b')]===0x0){return db[_0xdc4a('0x25')][_0xdc4a('0x44')]({'name':_0x223b6b[_0xdc4a('0x27')],'resourceId':_0x223b6b['id'],'type':_0x27603f[_0xdc4a('0x27')],'sectionId':_0x27603f['id']},{})['then'](function(){return _0x414e74;});}else{return _0x414e74;}})[_0xdc4a('0x3f')](function(_0x5caca1){logger[_0xdc4a('0x26')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x5caca1);throw _0x5caca1;});}return _0x414e74;})[_0xdc4a('0x24')](respondWithResult(_0x53d868,0xc9))[_0xdc4a('0x3f')](handleError(_0x53d868,null));};exports[_0xdc4a('0x23')]=function(_0x351082,_0x27319e){if(_0x351082[_0xdc4a('0x45')]['id']){delete _0x351082[_0xdc4a('0x45')]['id'];}return db['SquareProject'][_0xdc4a('0x43')]({'where':{'id':_0x351082['params']['id']}})['then'](handleEntityNotFound(_0x27319e,null))[_0xdc4a('0x24')](saveUpdates(_0x351082[_0xdc4a('0x45')],null))[_0xdc4a('0x24')](respondWithResult(_0x27319e,null))[_0xdc4a('0x3f')](handleError(_0x27319e,null));};exports[_0xdc4a('0x4c')]=function(_0xf844,_0x562e8d){return db[_0xdc4a('0x3b')][_0xdc4a('0x43')]({'where':{'id':_0xf844[_0xdc4a('0x4d')]['id']}})[_0xdc4a('0x24')](handleEntityNotFound(_0x562e8d,null))['then'](removeEntity(_0x562e8d,null))[_0xdc4a('0x3f')](handleError(_0x562e8d,null));};exports[_0xdc4a('0x4e')]=function(_0x492bce,_0x52b944,_0x2184d3){return db['SquareProject']['find']({'where':{'id':_0x492bce[_0xdc4a('0x4d')]['id']}})[_0xdc4a('0x24')](handleEntityNotFound(_0x52b944,null))['then'](function(_0x57f371){if(_0x57f371){return _0x57f371[_0xdc4a('0x4e')](_0x492bce[_0xdc4a('0x45')][_0xdc4a('0x4f')],_['omit'](_0x492bce[_0xdc4a('0x45')],[_0xdc4a('0x4f'),'id'])||{});}})[_0xdc4a('0x24')](respondWithResult(_0x52b944,null))[_0xdc4a('0x3f')](handleError(_0x52b944,null));};exports[_0xdc4a('0x50')]=function(_0x44245f,_0x2be9ff,_0x2737df){return db['SquareProject'][_0xdc4a('0x43')]({'where':{'id':_0x44245f[_0xdc4a('0x4d')]['id']}})[_0xdc4a('0x24')](handleEntityNotFound(_0x2be9ff,null))[_0xdc4a('0x24')](function(_0xdd0add){if(_0xdd0add){return _0xdd0add['removeUsers'](_0x44245f[_0xdc4a('0x2d')][_0xdc4a('0x4f')])[_0xdc4a('0x24')](function(){if(_[_0xdc4a('0x51')](_0x44245f[_0xdc4a('0x2d')][_0xdc4a('0x4f')])){for(var _0x5610f9=0x0;_0x5610f9<_0x44245f[_0xdc4a('0x2d')][_0xdc4a('0x4f')][_0xdc4a('0x33')];_0x5610f9+=0x1){socket['emit'](_0xdc4a('0x52'),{'UserId':Number(_0x44245f[_0xdc4a('0x2d')]['ids'][_0x5610f9]),'SquareProjectId':Number(_0x44245f[_0xdc4a('0x4d')]['id'])});}}else{socket['emit'](_0xdc4a('0x52'),{'UserId':Number(_0x44245f[_0xdc4a('0x2d')]['ids']),'SquareProjectId':Number(_0x44245f['params']['id'])});}});}})[_0xdc4a('0x24')](respondWithStatusCode(_0x2be9ff,null))['catch'](handleError(_0x2be9ff,null));};exports[_0xdc4a('0x53')]=function(_0x41ecc9,_0x4de44d,_0x112fa8){var _0x4529ed={};var _0x55aae1={};var _0x4145a2;var _0x17ac01;return db[_0xdc4a('0x3b')]['findOne']({'where':{'id':_0x41ecc9[_0xdc4a('0x4d')]['id']}})['then'](handleEntityNotFound(_0x4de44d,null))['then'](function(_0x3d4fef){if(_0x3d4fef){_0x4145a2=_0x3d4fef;_0x55aae1[_0xdc4a('0x2c')]=_[_0xdc4a('0x2e')](db[_0xdc4a('0x54')][_0xdc4a('0x2a')]);_0x55aae1[_0xdc4a('0x2d')]=_[_0xdc4a('0x2e')](_0x41ecc9[_0xdc4a('0x2d')]);_0x55aae1[_0xdc4a('0x2f')]=_['intersection'](_0x55aae1['model'],_0x55aae1[_0xdc4a('0x2d')]);_0x4529ed[_0xdc4a('0x31')]=_[_0xdc4a('0x30')](_0x55aae1[_0xdc4a('0x2c')],qs[_0xdc4a('0x32')](_0x41ecc9[_0xdc4a('0x2d')][_0xdc4a('0x32')]));_0x4529ed[_0xdc4a('0x31')]=_0x4529ed[_0xdc4a('0x31')][_0xdc4a('0x33')]?_0x4529ed[_0xdc4a('0x31')]:_0x55aae1['model'];_0x4529ed[_0xdc4a('0x55')]=qs[_0xdc4a('0x37')](_0x41ecc9[_0xdc4a('0x2d')][_0xdc4a('0x37')]);_0x4529ed[_0xdc4a('0x38')]=qs['filters'](_['pick'](_0x41ecc9[_0xdc4a('0x2d')],_0x55aae1['filters']));if(_0x41ecc9['query'][_0xdc4a('0x56')]){_0x4529ed[_0xdc4a('0x38')]=_[_0xdc4a('0x57')](_0x4529ed['where'],{'$or':_[_0xdc4a('0x29')](_0x4529ed[_0xdc4a('0x31')],function(_0x5f14cb){var _0x57d0c8={};_0x57d0c8[_0x5f14cb]={'$like':'%'+_0x41ecc9['query'][_0xdc4a('0x56')]+'%'};return _0x57d0c8;})});}_0x4529ed=_['merge']({},_0x4529ed,_0x41ecc9[_0xdc4a('0x42')]);return _0x4145a2[_0xdc4a('0x53')](_0x4529ed);}})[_0xdc4a('0x24')](function(_0x2599e9){if(_0x2599e9){_0x17ac01=_0x2599e9[_0xdc4a('0x33')];if(!_0x41ecc9[_0xdc4a('0x2d')][_0xdc4a('0x34')](_0xdc4a('0x35'))){_0x4529ed[_0xdc4a('0x36')]=qs[_0xdc4a('0x36')](_0x41ecc9[_0xdc4a('0x2d')][_0xdc4a('0x36')]);_0x4529ed[_0xdc4a('0x1d')]=qs[_0xdc4a('0x1d')](_0x41ecc9[_0xdc4a('0x2d')][_0xdc4a('0x1d')]);}return _0x4145a2[_0xdc4a('0x53')](_0x4529ed);}})['then'](function(_0x597599){if(_0x597599){return _0x597599?{'count':_0x17ac01,'rows':_0x597599}:null;}})[_0xdc4a('0x24')](respondWithResult(_0x4de44d,null))[_0xdc4a('0x3f')](handleError(_0x4de44d,null));};