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 _0xf51b=['path','sox','to-csv','ejs','lodash','squel','jsforce','querystring','ioredis','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','redis','defaults','localhost','socket.io-emitter','./squareProject.socket','register','end','status','json','count','offset','limit','set','Content-Range','apply','save','update','then','destroy','get','SquareProjects','UserProfileResource','error','stack','name','index','map','SquareProject','rawAttributes','fieldName','type','model','query','intersection','fields','attributes','length','hasOwnProperty','nolimit','sort','where','filters','pick','merge','options','include','catch','show','keys','includeAll','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','userProfileId','autoAssociation','body','addUsers','params','omit','ids','removeUsers','isArray','emit','userSquareProject:remove','findOne','User','order','filter','getUsers','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','mustache'];(function(_0x4e8165,_0x4aac69){var _0x56f576=function(_0x2ce95c){while(--_0x2ce95c){_0x4e8165['push'](_0x4e8165['shift']());}};_0x56f576(++_0x4aac69);}(_0xf51b,0x10b));var _0xbf51=function(_0x20a584,_0xe384a5){_0x20a584=_0x20a584-0x0;var _0x4b41a8=_0xf51b[_0x20a584];return _0x4b41a8;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xbf51('0x0'));var rimraf=require(_0xbf51('0x1'));var zipdir=require(_0xbf51('0x2'));var jsonpatch=require(_0xbf51('0x3'));var rp=require(_0xbf51('0x4'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0xbf51('0x5'));var util=require('util');var path=require(_0xbf51('0x6'));var sox=require(_0xbf51('0x7'));var csv=require(_0xbf51('0x8'));var ejs=require(_0xbf51('0x9'));var fs=require('fs');var _=require(_0xbf51('0xa'));var squel=require(_0xbf51('0xb'));var crypto=require('crypto');var jsforce=require(_0xbf51('0xc'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0xbf51('0xd'));var Papa=require('papaparse');var Redis=require(_0xbf51('0xe'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xbf51('0xf'));var logger=require(_0xbf51('0x10'))(_0xbf51('0x11'));var utils=require(_0xbf51('0x12'));var config=require(_0xbf51('0x13'));var db=require('../../mysqldb')['db'];config[_0xbf51('0x14')]=_[_0xbf51('0x15')](config[_0xbf51('0x14')],{'host':_0xbf51('0x16'),'port':0x18eb});var socket=require(_0xbf51('0x17'))(new Redis(config[_0xbf51('0x14')]));require(_0xbf51('0x18'))[_0xbf51('0x19')](socket);function respondWithStatusCode(_0x3217fc,_0x4656d9){_0x4656d9=_0x4656d9||0xcc;return function(_0x41c122){if(_0x41c122){return _0x3217fc['sendStatus'](_0x4656d9);}return _0x3217fc['status'](_0x4656d9)[_0xbf51('0x1a')]();};}function respondWithResult(_0x4eb2f9,_0xf8b104){_0xf8b104=_0xf8b104||0xc8;return function(_0x594aff){if(_0x594aff){return _0x4eb2f9[_0xbf51('0x1b')](_0xf8b104)[_0xbf51('0x1c')](_0x594aff);}};}function respondWithFilteredResult(_0x24eb78,_0x17cf0c){return function(_0x577f61){if(_0x577f61){var _0x153cf3=_0x577f61[_0xbf51('0x1d')],_0x98312e=_0x17cf0c[_0xbf51('0x1e')],_0x5a2c9f=_0x17cf0c[_0xbf51('0x1e')]+_0x17cf0c[_0xbf51('0x1f')],_0x3e8ce0;if(_0x5a2c9f>=_0x153cf3){_0x5a2c9f=_0x153cf3;_0x3e8ce0=0xc8;}else{_0x3e8ce0=0xce;}_0x24eb78[_0xbf51('0x1b')](_0x3e8ce0);return _0x24eb78[_0xbf51('0x20')](_0xbf51('0x21'),_0x98312e+'-'+_0x5a2c9f+'/'+_0x153cf3)[_0xbf51('0x1c')](_0x577f61);}return null;};}function patchUpdates(_0x3dae8d){return function(_0x30b4f8){try{jsonpatch[_0xbf51('0x22')](_0x30b4f8,_0x3dae8d,!![]);}catch(_0x31f78f){return BPromise['reject'](_0x31f78f);}return _0x30b4f8[_0xbf51('0x23')]();};}function saveUpdates(_0x3b736e,_0x44f538){return function(_0xf26d86){if(_0xf26d86){return _0xf26d86[_0xbf51('0x24')](_0x3b736e)[_0xbf51('0x25')](function(_0x3ac569){return _0x3ac569;});}return null;};}function removeEntity(_0x3baf88,_0x19620e){return function(_0x14d86a){if(_0x14d86a){return _0x14d86a[_0xbf51('0x26')]()[_0xbf51('0x25')](function(){var _0x2c0d53=_0x14d86a[_0xbf51('0x27')]({'plain':!![]});var _0x2c388f=_0xbf51('0x28');return db[_0xbf51('0x29')][_0xbf51('0x26')]({'where':{'type':_0x2c388f,'resourceId':_0x2c0d53['id']}})['then'](function(){return _0x14d86a;});})[_0xbf51('0x25')](function(){_0x3baf88[_0xbf51('0x1b')](0xcc)['end']();});}};}function handleEntityNotFound(_0x33fabd,_0x286c9b){return function(_0x6b8cf1){if(!_0x6b8cf1){_0x33fabd['sendStatus'](0x194);}return _0x6b8cf1;};}function handleError(_0x6953fe,_0x3d1b8d){_0x3d1b8d=_0x3d1b8d||0x1f4;return function(_0x45b0e2){logger[_0xbf51('0x2a')](_0x45b0e2[_0xbf51('0x2b')]);if(_0x45b0e2[_0xbf51('0x2c')]){delete _0x45b0e2[_0xbf51('0x2c')];}_0x6953fe['status'](_0x3d1b8d)['send'](_0x45b0e2);};}exports[_0xbf51('0x2d')]=function(_0x2b6468,_0x31af64){var _0x3b401d={},_0x2594c3={},_0x2f9c55={'count':0x0,'rows':[]};var _0x309d81=_[_0xbf51('0x2e')](db[_0xbf51('0x2f')][_0xbf51('0x30')],function(_0x23cea6){return{'name':_0x23cea6[_0xbf51('0x31')],'type':_0x23cea6[_0xbf51('0x32')]['key']};});_0x2594c3[_0xbf51('0x33')]=_['map'](_0x309d81,_0xbf51('0x2c'));_0x2594c3[_0xbf51('0x34')]=_['keys'](_0x2b6468['query']);_0x2594c3['filters']=_[_0xbf51('0x35')](_0x2594c3[_0xbf51('0x33')],_0x2594c3[_0xbf51('0x34')]);_0x3b401d['attributes']=_['intersection'](_0x2594c3[_0xbf51('0x33')],qs[_0xbf51('0x36')](_0x2b6468[_0xbf51('0x34')]['fields']));_0x3b401d[_0xbf51('0x37')]=_0x3b401d[_0xbf51('0x37')][_0xbf51('0x38')]?_0x3b401d[_0xbf51('0x37')]:_0x2594c3[_0xbf51('0x33')];if(!_0x2b6468[_0xbf51('0x34')][_0xbf51('0x39')](_0xbf51('0x3a'))){_0x3b401d['limit']=qs[_0xbf51('0x1f')](_0x2b6468[_0xbf51('0x34')]['limit']);_0x3b401d[_0xbf51('0x1e')]=qs[_0xbf51('0x1e')](_0x2b6468[_0xbf51('0x34')]['offset']);}_0x3b401d['order']=qs[_0xbf51('0x3b')](_0x2b6468[_0xbf51('0x34')][_0xbf51('0x3b')]);_0x3b401d[_0xbf51('0x3c')]=qs[_0xbf51('0x3d')](_[_0xbf51('0x3e')](_0x2b6468[_0xbf51('0x34')],_0x2594c3[_0xbf51('0x3d')]),_0x309d81);if(_0x2b6468['query']['filter']){_0x3b401d[_0xbf51('0x3c')]=_[_0xbf51('0x3f')](_0x3b401d[_0xbf51('0x3c')],{'$or':_['map'](_0x309d81,function(_0x2042ba){if(_0x2042ba[_0xbf51('0x32')]!=='VIRTUAL'){var _0x304a2f={};_0x304a2f[_0x2042ba[_0xbf51('0x2c')]]={'$like':'%'+_0x2b6468['query']['filter']+'%'};return _0x304a2f;}})});}_0x3b401d=_[_0xbf51('0x3f')]({},_0x3b401d,_0x2b6468[_0xbf51('0x40')]);var _0x2d21c5={'where':_0x3b401d['where']};return db[_0xbf51('0x2f')][_0xbf51('0x1d')](_0x2d21c5)[_0xbf51('0x25')](function(_0x20d9c5){_0x2f9c55[_0xbf51('0x1d')]=_0x20d9c5;if(_0x2b6468[_0xbf51('0x34')]['includeAll']){_0x3b401d[_0xbf51('0x41')]=[{'all':!![]}];}return db[_0xbf51('0x2f')]['findAll'](_0x3b401d);})[_0xbf51('0x25')](function(_0x4b2a13){_0x2f9c55['rows']=_0x4b2a13;return _0x2f9c55;})['then'](respondWithFilteredResult(_0x31af64,_0x3b401d))[_0xbf51('0x42')](handleError(_0x31af64,null));};exports[_0xbf51('0x43')]=function(_0x1600a3,_0x4ed61d){var _0x2a24f1={'raw':![],'where':{'id':_0x1600a3['params']['id']}},_0x169b00={};_0x169b00[_0xbf51('0x33')]=_[_0xbf51('0x44')](db[_0xbf51('0x2f')][_0xbf51('0x30')]);_0x169b00[_0xbf51('0x34')]=_[_0xbf51('0x44')](_0x1600a3[_0xbf51('0x34')]);_0x169b00[_0xbf51('0x3d')]=_['intersection'](_0x169b00['model'],_0x169b00[_0xbf51('0x34')]);_0x2a24f1['attributes']=_[_0xbf51('0x35')](_0x169b00['model'],qs['fields'](_0x1600a3[_0xbf51('0x34')][_0xbf51('0x36')]));_0x2a24f1[_0xbf51('0x37')]=_0x2a24f1['attributes'][_0xbf51('0x38')]?_0x2a24f1[_0xbf51('0x37')]:_0x169b00['model'];if(_0x1600a3[_0xbf51('0x34')][_0xbf51('0x45')]){_0x2a24f1['include']=[{'all':!![]}];}_0x2a24f1=_[_0xbf51('0x3f')]({},_0x2a24f1,_0x1600a3[_0xbf51('0x40')]);return db['SquareProject'][_0xbf51('0x46')](_0x2a24f1)[_0xbf51('0x25')](handleEntityNotFound(_0x4ed61d,null))[_0xbf51('0x25')](respondWithResult(_0x4ed61d,null))['catch'](handleError(_0x4ed61d,null));};exports[_0xbf51('0x47')]=function(_0x9a0465,_0x3cab3c){return db['SquareProject'][_0xbf51('0x47')](_0x9a0465['body'],{})['then'](function(_0x2d68b0){var _0x2ea119=_0x9a0465[_0xbf51('0x48')][_0xbf51('0x27')]({'plain':!![]});if(!_0x2ea119)throw new Error(_0xbf51('0x49'));if(_0x2ea119[_0xbf51('0x4a')]==='user'){var _0x3a9930=_0x2d68b0[_0xbf51('0x27')]({'plain':!![]});var _0x3693a1=_0xbf51('0x28');return db['UserProfileSection']['find']({'where':{'name':_0x3693a1,'userProfileId':_0x2ea119[_0xbf51('0x4b')]},'raw':!![]})[_0xbf51('0x25')](function(_0x307e60){if(_0x307e60&&_0x307e60[_0xbf51('0x4c')]===0x0){return db['UserProfileResource']['create']({'name':_0x3a9930[_0xbf51('0x2c')],'resourceId':_0x3a9930['id'],'type':_0x307e60['name'],'sectionId':_0x307e60['id']},{})['then'](function(){return _0x2d68b0;});}else{return _0x2d68b0;}})[_0xbf51('0x42')](function(_0x314fcf){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x314fcf);throw _0x314fcf;});}return _0x2d68b0;})[_0xbf51('0x25')](respondWithResult(_0x3cab3c,0xc9))['catch'](handleError(_0x3cab3c,null));};exports[_0xbf51('0x24')]=function(_0x2fda8a,_0x3a8740){if(_0x2fda8a[_0xbf51('0x4d')]['id']){delete _0x2fda8a[_0xbf51('0x4d')]['id'];}return db[_0xbf51('0x2f')]['find']({'where':{'id':_0x2fda8a['params']['id']}})['then'](handleEntityNotFound(_0x3a8740,null))[_0xbf51('0x25')](saveUpdates(_0x2fda8a[_0xbf51('0x4d')],null))['then'](respondWithResult(_0x3a8740,null))[_0xbf51('0x42')](handleError(_0x3a8740,null));};exports['destroy']=function(_0x25d5ea,_0x3727c3){return db[_0xbf51('0x2f')][_0xbf51('0x46')]({'where':{'id':_0x25d5ea['params']['id']}})[_0xbf51('0x25')](handleEntityNotFound(_0x3727c3,null))[_0xbf51('0x25')](removeEntity(_0x3727c3,null))[_0xbf51('0x42')](handleError(_0x3727c3,null));};exports[_0xbf51('0x4e')]=function(_0x168204,_0xef57c2,_0x3eb18e){return db[_0xbf51('0x2f')][_0xbf51('0x46')]({'where':{'id':_0x168204[_0xbf51('0x4f')]['id']}})[_0xbf51('0x25')](handleEntityNotFound(_0xef57c2,null))[_0xbf51('0x25')](function(_0x59bd77){if(_0x59bd77){return _0x59bd77[_0xbf51('0x4e')](_0x168204['body']['ids'],_[_0xbf51('0x50')](_0x168204[_0xbf51('0x4d')],[_0xbf51('0x51'),'id'])||{});}})[_0xbf51('0x25')](respondWithResult(_0xef57c2,null))[_0xbf51('0x42')](handleError(_0xef57c2,null));};exports[_0xbf51('0x52')]=function(_0x44b39a,_0x473742,_0x106645){return db[_0xbf51('0x2f')]['find']({'where':{'id':_0x44b39a[_0xbf51('0x4f')]['id']}})[_0xbf51('0x25')](handleEntityNotFound(_0x473742,null))[_0xbf51('0x25')](function(_0x44e3b9){if(_0x44e3b9){return _0x44e3b9[_0xbf51('0x52')](_0x44b39a['query'][_0xbf51('0x51')])[_0xbf51('0x25')](function(){if(_[_0xbf51('0x53')](_0x44b39a[_0xbf51('0x34')][_0xbf51('0x51')])){for(var _0x40122b=0x0;_0x40122b<_0x44b39a[_0xbf51('0x34')]['ids'][_0xbf51('0x38')];_0x40122b+=0x1){socket[_0xbf51('0x54')](_0xbf51('0x55'),{'UserId':Number(_0x44b39a[_0xbf51('0x34')][_0xbf51('0x51')][_0x40122b]),'SquareProjectId':Number(_0x44b39a['params']['id'])});}}else{socket[_0xbf51('0x54')](_0xbf51('0x55'),{'UserId':Number(_0x44b39a[_0xbf51('0x34')][_0xbf51('0x51')]),'SquareProjectId':Number(_0x44b39a['params']['id'])});}});}})[_0xbf51('0x25')](respondWithStatusCode(_0x473742,null))[_0xbf51('0x42')](handleError(_0x473742,null));};exports['getUsers']=function(_0x4b71eb,_0x3d37cc,_0x135ab4){var _0x37ad04={};var _0x410eba={};var _0x191676;var _0x20b4c7;return db[_0xbf51('0x2f')][_0xbf51('0x56')]({'where':{'id':_0x4b71eb[_0xbf51('0x4f')]['id']}})[_0xbf51('0x25')](handleEntityNotFound(_0x3d37cc,null))[_0xbf51('0x25')](function(_0xe0241c){if(_0xe0241c){_0x191676=_0xe0241c;_0x410eba[_0xbf51('0x33')]=_[_0xbf51('0x44')](db[_0xbf51('0x57')][_0xbf51('0x30')]);_0x410eba[_0xbf51('0x34')]=_['keys'](_0x4b71eb[_0xbf51('0x34')]);_0x410eba[_0xbf51('0x3d')]=_['intersection'](_0x410eba[_0xbf51('0x33')],_0x410eba[_0xbf51('0x34')]);_0x37ad04[_0xbf51('0x37')]=_[_0xbf51('0x35')](_0x410eba[_0xbf51('0x33')],qs[_0xbf51('0x36')](_0x4b71eb[_0xbf51('0x34')][_0xbf51('0x36')]));_0x37ad04[_0xbf51('0x37')]=_0x37ad04[_0xbf51('0x37')][_0xbf51('0x38')]?_0x37ad04[_0xbf51('0x37')]:_0x410eba[_0xbf51('0x33')];_0x37ad04[_0xbf51('0x58')]=qs[_0xbf51('0x3b')](_0x4b71eb['query'][_0xbf51('0x3b')]);_0x37ad04[_0xbf51('0x3c')]=qs[_0xbf51('0x3d')](_[_0xbf51('0x3e')](_0x4b71eb['query'],_0x410eba[_0xbf51('0x3d')]));if(_0x4b71eb[_0xbf51('0x34')][_0xbf51('0x59')]){_0x37ad04[_0xbf51('0x3c')]=_[_0xbf51('0x3f')](_0x37ad04[_0xbf51('0x3c')],{'$or':_['map'](_0x37ad04[_0xbf51('0x37')],function(_0x1c06e4){var _0x13c43a={};_0x13c43a[_0x1c06e4]={'$like':'%'+_0x4b71eb[_0xbf51('0x34')][_0xbf51('0x59')]+'%'};return _0x13c43a;})});}_0x37ad04=_[_0xbf51('0x3f')]({},_0x37ad04,_0x4b71eb[_0xbf51('0x40')]);return _0x191676[_0xbf51('0x5a')](_0x37ad04);}})[_0xbf51('0x25')](function(_0x5c0e9d){if(_0x5c0e9d){_0x20b4c7=_0x5c0e9d[_0xbf51('0x38')];if(!_0x4b71eb[_0xbf51('0x34')][_0xbf51('0x39')](_0xbf51('0x3a'))){_0x37ad04['limit']=qs[_0xbf51('0x1f')](_0x4b71eb[_0xbf51('0x34')][_0xbf51('0x1f')]);_0x37ad04[_0xbf51('0x1e')]=qs[_0xbf51('0x1e')](_0x4b71eb[_0xbf51('0x34')][_0xbf51('0x1e')]);}return _0x191676[_0xbf51('0x5a')](_0x37ad04);}})[_0xbf51('0x25')](function(_0x4ccf99){if(_0x4ccf99){return _0x4ccf99?{'count':_0x20b4c7,'rows':_0x4ccf99}:null;}})[_0xbf51('0x25')](respondWithResult(_0x3d37cc,null))[_0xbf51('0x42')](handleError(_0x3d37cc,null));};