Built motion from commit 00bf23f6.|2.6.16
[motion2.git] / server / api / squareProject / squareProject.controller.js
index 8054831..2f3807b 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x61a3=['papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','redis','localhost','socket.io-emitter','./squareProject.socket','status','end','json','offset','undefined','count','limit','set','Content-Range','apply','save','update','then','destroy','get','SquareProjects','UserProfileResource','error','name','send','index','SquareProject','rawAttributes','fieldName','type','key','model','map','query','keys','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','where','filters','pick','filter','merge','VIRTUAL','include','findAll','rows','catch','show','params','includeAll','options','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','userProfileId','autoAssociation','addUsers','ids','omit','removeUsers','isArray','emit','userSquareProject:remove','getUsers','findOne','User','order','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','ejs','lodash','crypto','jsforce','desk.js','querystring'];(function(_0x5955d8,_0x2367a0){var _0x2d1017=function(_0x523470){while(--_0x523470){_0x5955d8['push'](_0x5955d8['shift']());}};_0x2d1017(++_0x2367a0);}(_0x61a3,0x112));var _0x361a=function(_0x122ef9,_0x451d2a){_0x122ef9=_0x122ef9-0x0;var _0x42fba0=_0x61a3[_0x122ef9];return _0x42fba0;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x361a('0x0'));var zipdir=require(_0x361a('0x1'));var jsonpatch=require(_0x361a('0x2'));var rp=require(_0x361a('0x3'));var moment=require(_0x361a('0x4'));var BPromise=require(_0x361a('0x5'));var Mustache=require(_0x361a('0x6'));var util=require(_0x361a('0x7'));var path=require('path');var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x361a('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x361a('0x9'));var squel=require('squel');var crypto=require(_0x361a('0xa'));var jsforce=require(_0x361a('0xb'));var deskjs=require(_0x361a('0xc'));var toCsv=require('to-csv');var querystring=require(_0x361a('0xd'));var Papa=require(_0x361a('0xe'));var Redis=require('ioredis');var authService=require(_0x361a('0xf'));var qs=require(_0x361a('0x10'));var as=require(_0x361a('0x11'));var hardwareService=require(_0x361a('0x12'));var logger=require(_0x361a('0x13'))(_0x361a('0x14'));var utils=require(_0x361a('0x15'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];config[_0x361a('0x16')]=_['defaults'](config[_0x361a('0x16')],{'host':_0x361a('0x17'),'port':0x18eb});var socket=require(_0x361a('0x18'))(new Redis(config['redis']));require(_0x361a('0x19'))['register'](socket);function respondWithStatusCode(_0x321d17,_0x3e4e86){_0x3e4e86=_0x3e4e86||0xcc;return function(_0x1d8855){if(_0x1d8855){return _0x321d17['sendStatus'](_0x3e4e86);}return _0x321d17[_0x361a('0x1a')](_0x3e4e86)[_0x361a('0x1b')]();};}function respondWithResult(_0x1aef6c,_0x4cbb69){_0x4cbb69=_0x4cbb69||0xc8;return function(_0x5a51e5){if(_0x5a51e5){return _0x1aef6c[_0x361a('0x1a')](_0x4cbb69)[_0x361a('0x1c')](_0x5a51e5);}};}function respondWithFilteredResult(_0x171cfa,_0x296a09){return function(_0x376197){if(_0x376197){var _0x43907f=typeof _0x296a09[_0x361a('0x1d')]===_0x361a('0x1e')&&typeof _0x296a09['limit']===_0x361a('0x1e');var _0x2d0027=_0x376197['count'];var _0x10d3bd=_0x43907f?0x0:_0x296a09[_0x361a('0x1d')];var _0x3d3708=_0x43907f?_0x376197[_0x361a('0x1f')]:_0x296a09[_0x361a('0x1d')]+_0x296a09[_0x361a('0x20')];var _0x118d0e;if(_0x3d3708>=_0x2d0027){_0x3d3708=_0x2d0027;_0x118d0e=0xc8;}else{_0x118d0e=0xce;}_0x171cfa[_0x361a('0x1a')](_0x118d0e);return _0x171cfa[_0x361a('0x21')](_0x361a('0x22'),_0x10d3bd+'-'+_0x3d3708+'/'+_0x2d0027)[_0x361a('0x1c')](_0x376197);}return null;};}function patchUpdates(_0x114043){return function(_0x1fef01){try{jsonpatch[_0x361a('0x23')](_0x1fef01,_0x114043,!![]);}catch(_0x301033){return BPromise['reject'](_0x301033);}return _0x1fef01[_0x361a('0x24')]();};}function saveUpdates(_0x455813,_0xf0686d){return function(_0x203987){if(_0x203987){return _0x203987[_0x361a('0x25')](_0x455813)[_0x361a('0x26')](function(_0x1812ff){return _0x1812ff;});}return null;};}function removeEntity(_0x311bc5,_0x340eac){return function(_0x6911fc){if(_0x6911fc){return _0x6911fc[_0x361a('0x27')]()[_0x361a('0x26')](function(){var _0x14fb6f=_0x6911fc[_0x361a('0x28')]({'plain':!![]});var _0x977fb3=_0x361a('0x29');return db[_0x361a('0x2a')]['destroy']({'where':{'type':_0x977fb3,'resourceId':_0x14fb6f['id']}})[_0x361a('0x26')](function(){return _0x6911fc;});})[_0x361a('0x26')](function(){_0x311bc5['status'](0xcc)[_0x361a('0x1b')]();});}};}function handleEntityNotFound(_0x3f090c,_0x36d65d){return function(_0x496538){if(!_0x496538){_0x3f090c['sendStatus'](0x194);}return _0x496538;};}function handleError(_0x3d0448,_0x3f29e9){_0x3f29e9=_0x3f29e9||0x1f4;return function(_0x26d720){logger[_0x361a('0x2b')](_0x26d720['stack']);if(_0x26d720[_0x361a('0x2c')]){delete _0x26d720['name'];}_0x3d0448['status'](_0x3f29e9)[_0x361a('0x2d')](_0x26d720);};}exports[_0x361a('0x2e')]=function(_0x283c9b,_0x1b20f1){var _0x18c8fe={},_0x27d798={},_0x54b015={'count':0x0,'rows':[]};var _0x4e3e36=_['map'](db[_0x361a('0x2f')][_0x361a('0x30')],function(_0xc696f4){return{'name':_0xc696f4[_0x361a('0x31')],'type':_0xc696f4[_0x361a('0x32')][_0x361a('0x33')]};});_0x27d798[_0x361a('0x34')]=_[_0x361a('0x35')](_0x4e3e36,_0x361a('0x2c'));_0x27d798[_0x361a('0x36')]=_[_0x361a('0x37')](_0x283c9b[_0x361a('0x36')]);_0x27d798['filters']=_[_0x361a('0x38')](_0x27d798[_0x361a('0x34')],_0x27d798[_0x361a('0x36')]);_0x18c8fe[_0x361a('0x39')]=_['intersection'](_0x27d798[_0x361a('0x34')],qs[_0x361a('0x3a')](_0x283c9b[_0x361a('0x36')][_0x361a('0x3a')]));_0x18c8fe[_0x361a('0x39')]=_0x18c8fe['attributes'][_0x361a('0x3b')]?_0x18c8fe[_0x361a('0x39')]:_0x27d798[_0x361a('0x34')];if(!_0x283c9b['query'][_0x361a('0x3c')](_0x361a('0x3d'))){_0x18c8fe[_0x361a('0x20')]=qs[_0x361a('0x20')](_0x283c9b[_0x361a('0x36')][_0x361a('0x20')]);_0x18c8fe[_0x361a('0x1d')]=qs['offset'](_0x283c9b[_0x361a('0x36')][_0x361a('0x1d')]);}_0x18c8fe['order']=qs[_0x361a('0x3e')](_0x283c9b['query'][_0x361a('0x3e')]);_0x18c8fe[_0x361a('0x3f')]=qs[_0x361a('0x40')](_[_0x361a('0x41')](_0x283c9b[_0x361a('0x36')],_0x27d798[_0x361a('0x40')]),_0x4e3e36);if(_0x283c9b['query'][_0x361a('0x42')]){_0x18c8fe['where']=_[_0x361a('0x43')](_0x18c8fe[_0x361a('0x3f')],{'$or':_[_0x361a('0x35')](_0x4e3e36,function(_0x2806c5){if(_0x2806c5[_0x361a('0x32')]!==_0x361a('0x44')){var _0x21290e={};_0x21290e[_0x2806c5[_0x361a('0x2c')]]={'$like':'%'+_0x283c9b[_0x361a('0x36')][_0x361a('0x42')]+'%'};return _0x21290e;}})});}_0x18c8fe=_[_0x361a('0x43')]({},_0x18c8fe,_0x283c9b['options']);var _0x102d10={'where':_0x18c8fe[_0x361a('0x3f')]};return db[_0x361a('0x2f')]['count'](_0x102d10)[_0x361a('0x26')](function(_0x41eb26){_0x54b015[_0x361a('0x1f')]=_0x41eb26;if(_0x283c9b[_0x361a('0x36')]['includeAll']){_0x18c8fe[_0x361a('0x45')]=[{'all':!![]}];}return db[_0x361a('0x2f')][_0x361a('0x46')](_0x18c8fe);})[_0x361a('0x26')](function(_0x9aeb17){_0x54b015[_0x361a('0x47')]=_0x9aeb17;return _0x54b015;})[_0x361a('0x26')](respondWithFilteredResult(_0x1b20f1,_0x18c8fe))[_0x361a('0x48')](handleError(_0x1b20f1,null));};exports[_0x361a('0x49')]=function(_0x54911a,_0x1bc385){var _0x217541={'raw':![],'where':{'id':_0x54911a[_0x361a('0x4a')]['id']}},_0x226a59={};_0x226a59['model']=_[_0x361a('0x37')](db['SquareProject']['rawAttributes']);_0x226a59['query']=_['keys'](_0x54911a['query']);_0x226a59[_0x361a('0x40')]=_['intersection'](_0x226a59[_0x361a('0x34')],_0x226a59[_0x361a('0x36')]);_0x217541[_0x361a('0x39')]=_[_0x361a('0x38')](_0x226a59[_0x361a('0x34')],qs['fields'](_0x54911a[_0x361a('0x36')]['fields']));_0x217541[_0x361a('0x39')]=_0x217541[_0x361a('0x39')][_0x361a('0x3b')]?_0x217541[_0x361a('0x39')]:_0x226a59[_0x361a('0x34')];if(_0x54911a[_0x361a('0x36')][_0x361a('0x4b')]){_0x217541[_0x361a('0x45')]=[{'all':!![]}];}_0x217541=_[_0x361a('0x43')]({},_0x217541,_0x54911a[_0x361a('0x4c')]);return db[_0x361a('0x2f')][_0x361a('0x4d')](_0x217541)['then'](handleEntityNotFound(_0x1bc385,null))[_0x361a('0x26')](respondWithResult(_0x1bc385,null))[_0x361a('0x48')](handleError(_0x1bc385,null));};exports['create']=function(_0x42764c,_0x4df8f6){return db[_0x361a('0x2f')][_0x361a('0x4e')](_0x42764c[_0x361a('0x4f')],{})[_0x361a('0x26')](function(_0x29df14){var _0x31285e=_0x42764c[_0x361a('0x50')][_0x361a('0x28')]({'plain':!![]});if(!_0x31285e)throw new Error(_0x361a('0x51'));if(_0x31285e[_0x361a('0x52')]===_0x361a('0x50')){var _0x569941=_0x29df14[_0x361a('0x28')]({'plain':!![]});var _0x5cb326='SquareProjects';return db['UserProfileSection'][_0x361a('0x4d')]({'where':{'name':_0x5cb326,'userProfileId':_0x31285e[_0x361a('0x53')]},'raw':!![]})[_0x361a('0x26')](function(_0x17d5b1){if(_0x17d5b1&&_0x17d5b1[_0x361a('0x54')]===0x0){return db[_0x361a('0x2a')][_0x361a('0x4e')]({'name':_0x569941[_0x361a('0x2c')],'resourceId':_0x569941['id'],'type':_0x17d5b1[_0x361a('0x2c')],'sectionId':_0x17d5b1['id']},{})[_0x361a('0x26')](function(){return _0x29df14;});}else{return _0x29df14;}})[_0x361a('0x48')](function(_0x54c8e5){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x54c8e5);throw _0x54c8e5;});}return _0x29df14;})[_0x361a('0x26')](respondWithResult(_0x4df8f6,0xc9))[_0x361a('0x48')](handleError(_0x4df8f6,null));};exports[_0x361a('0x25')]=function(_0xc8c74c,_0x427f9d){if(_0xc8c74c['body']['id']){delete _0xc8c74c[_0x361a('0x4f')]['id'];}return db[_0x361a('0x2f')][_0x361a('0x4d')]({'where':{'id':_0xc8c74c['params']['id']}})['then'](handleEntityNotFound(_0x427f9d,null))[_0x361a('0x26')](saveUpdates(_0xc8c74c[_0x361a('0x4f')],null))[_0x361a('0x26')](respondWithResult(_0x427f9d,null))[_0x361a('0x48')](handleError(_0x427f9d,null));};exports['destroy']=function(_0x4576f8,_0x4c1fc5){return db['SquareProject']['find']({'where':{'id':_0x4576f8[_0x361a('0x4a')]['id']}})['then'](handleEntityNotFound(_0x4c1fc5,null))[_0x361a('0x26')](removeEntity(_0x4c1fc5,null))['catch'](handleError(_0x4c1fc5,null));};exports['addUsers']=function(_0x415fb2,_0x4b8c6a,_0x491145){return db['SquareProject'][_0x361a('0x4d')]({'where':{'id':_0x415fb2['params']['id']}})['then'](handleEntityNotFound(_0x4b8c6a,null))[_0x361a('0x26')](function(_0x5e2042){if(_0x5e2042){return _0x5e2042[_0x361a('0x55')](_0x415fb2['body'][_0x361a('0x56')],_[_0x361a('0x57')](_0x415fb2[_0x361a('0x4f')],[_0x361a('0x56'),'id'])||{});}})[_0x361a('0x26')](respondWithResult(_0x4b8c6a,null))[_0x361a('0x48')](handleError(_0x4b8c6a,null));};exports[_0x361a('0x58')]=function(_0x578070,_0x34f6bc,_0x1f3e94){return db[_0x361a('0x2f')][_0x361a('0x4d')]({'where':{'id':_0x578070[_0x361a('0x4a')]['id']}})[_0x361a('0x26')](handleEntityNotFound(_0x34f6bc,null))['then'](function(_0x5c5f56){if(_0x5c5f56){return _0x5c5f56[_0x361a('0x58')](_0x578070[_0x361a('0x36')][_0x361a('0x56')])[_0x361a('0x26')](function(){if(_[_0x361a('0x59')](_0x578070[_0x361a('0x36')][_0x361a('0x56')])){for(var _0x23a22f=0x0;_0x23a22f<_0x578070[_0x361a('0x36')][_0x361a('0x56')][_0x361a('0x3b')];_0x23a22f+=0x1){socket[_0x361a('0x5a')]('userSquareProject:remove',{'UserId':Number(_0x578070[_0x361a('0x36')]['ids'][_0x23a22f]),'SquareProjectId':Number(_0x578070[_0x361a('0x4a')]['id'])});}}else{socket[_0x361a('0x5a')](_0x361a('0x5b'),{'UserId':Number(_0x578070[_0x361a('0x36')][_0x361a('0x56')]),'SquareProjectId':Number(_0x578070[_0x361a('0x4a')]['id'])});}});}})['then'](respondWithStatusCode(_0x34f6bc,null))['catch'](handleError(_0x34f6bc,null));};exports[_0x361a('0x5c')]=function(_0x32323f,_0x5d5d2b,_0x3c0a28){var _0x59fdfe={};var _0x333b77={};var _0x3a98d9;var _0x43229a;return db[_0x361a('0x2f')][_0x361a('0x5d')]({'where':{'id':_0x32323f['params']['id']}})[_0x361a('0x26')](handleEntityNotFound(_0x5d5d2b,null))['then'](function(_0x23fb2c){if(_0x23fb2c){_0x3a98d9=_0x23fb2c;_0x333b77[_0x361a('0x34')]=_['keys'](db[_0x361a('0x5e')]['rawAttributes']);_0x333b77[_0x361a('0x36')]=_[_0x361a('0x37')](_0x32323f[_0x361a('0x36')]);_0x333b77[_0x361a('0x40')]=_[_0x361a('0x38')](_0x333b77[_0x361a('0x34')],_0x333b77[_0x361a('0x36')]);_0x59fdfe[_0x361a('0x39')]=_[_0x361a('0x38')](_0x333b77[_0x361a('0x34')],qs['fields'](_0x32323f[_0x361a('0x36')][_0x361a('0x3a')]));_0x59fdfe[_0x361a('0x39')]=_0x59fdfe[_0x361a('0x39')][_0x361a('0x3b')]?_0x59fdfe[_0x361a('0x39')]:_0x333b77[_0x361a('0x34')];_0x59fdfe[_0x361a('0x5f')]=qs[_0x361a('0x3e')](_0x32323f[_0x361a('0x36')][_0x361a('0x3e')]);_0x59fdfe[_0x361a('0x3f')]=qs[_0x361a('0x40')](_[_0x361a('0x41')](_0x32323f[_0x361a('0x36')],_0x333b77[_0x361a('0x40')]));if(_0x32323f[_0x361a('0x36')][_0x361a('0x42')]){_0x59fdfe[_0x361a('0x3f')]=_['merge'](_0x59fdfe[_0x361a('0x3f')],{'$or':_[_0x361a('0x35')](_0x59fdfe[_0x361a('0x39')],function(_0x538110){var _0x3203ed={};_0x3203ed[_0x538110]={'$like':'%'+_0x32323f[_0x361a('0x36')][_0x361a('0x42')]+'%'};return _0x3203ed;})});}_0x59fdfe=_['merge']({},_0x59fdfe,_0x32323f['options']);return _0x3a98d9[_0x361a('0x5c')](_0x59fdfe);}})['then'](function(_0x1b4216){if(_0x1b4216){_0x43229a=_0x1b4216[_0x361a('0x3b')];if(!_0x32323f[_0x361a('0x36')][_0x361a('0x3c')](_0x361a('0x3d'))){_0x59fdfe['limit']=qs[_0x361a('0x20')](_0x32323f[_0x361a('0x36')][_0x361a('0x20')]);_0x59fdfe['offset']=qs[_0x361a('0x1d')](_0x32323f['query'][_0x361a('0x1d')]);}return _0x3a98d9[_0x361a('0x5c')](_0x59fdfe);}})[_0x361a('0x26')](function(_0x5799de){if(_0x5799de){return _0x5799de?{'count':_0x43229a,'rows':_0x5799de}:null;}})[_0x361a('0x26')](respondWithResult(_0x5d5d2b,null))[_0x361a('0x48')](handleError(_0x5d5d2b,null));};
\ No newline at end of file
+var _0x9e42=['query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','type','options','includeAll','rows','catch','show','params','merge','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','lodash','ioredis','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../mysqldb','localhost','redis','register','status','offset','undefined','count','limit','set','json','update','then','destroy','get','SquareProjects','UserProfileResource','publish','stringify','end','error','name','send','index','map','SquareProject','rawAttributes','fieldName','key','model'];(function(_0x14f30b,_0x4ac7ca){var _0x248b2e=function(_0x800f64){while(--_0x800f64){_0x14f30b['push'](_0x14f30b['shift']());}};_0x248b2e(++_0x4ac7ca);}(_0x9e42,0x1dc));var _0x29e4=function(_0x5235a6,_0x680b76){_0x5235a6=_0x5235a6-0x0;var _0x1cf37e=_0x9e42[_0x5235a6];return _0x1cf37e;};'use strict';var _=require(_0x29e4('0x0'));var Redis=require(_0x29e4('0x1'));var qs=require(_0x29e4('0x2'));var logger=require(_0x29e4('0x3'))(_0x29e4('0x4'));var config=require(_0x29e4('0x5'));var db=require(_0x29e4('0x6'))['db'];config['redis']=_['defaults'](config['redis'],{'host':_0x29e4('0x7'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x29e4('0x8')]));require('./squareProject.socket')[_0x29e4('0x9')](socket);function respondWithResult(_0x38f655,_0x93aaae){_0x93aaae=_0x93aaae||0xc8;return function(_0x332234){if(_0x332234){return _0x38f655[_0x29e4('0xa')](_0x93aaae)['json'](_0x332234);}};}function respondWithFilteredResult(_0x4761d4,_0x473797){return function(_0x50c833){if(_0x50c833){var _0x524714=typeof _0x473797[_0x29e4('0xb')]===_0x29e4('0xc')&&typeof _0x473797['limit']===_0x29e4('0xc');var _0x3409b3=_0x50c833['count'];var _0x2309e6=_0x524714?0x0:_0x473797['offset'];var _0x2d9c52=_0x524714?_0x50c833[_0x29e4('0xd')]:_0x473797['offset']+_0x473797[_0x29e4('0xe')];var _0x12d715;if(_0x2d9c52>=_0x3409b3){_0x2d9c52=_0x3409b3;_0x12d715=0xc8;}else{_0x12d715=0xce;}_0x4761d4[_0x29e4('0xa')](_0x12d715);return _0x4761d4[_0x29e4('0xf')]('Content-Range',_0x2309e6+'-'+_0x2d9c52+'/'+_0x3409b3)[_0x29e4('0x10')](_0x50c833);}return null;};}function saveUpdates(_0x442bec){return function(_0x395162){if(_0x395162){return _0x395162[_0x29e4('0x11')](_0x442bec)[_0x29e4('0x12')](function(_0x73e6f5){return _0x73e6f5;});}return null;};}function removeEntity(_0x36125c){return function(_0x1d3fad){if(_0x1d3fad){return _0x1d3fad[_0x29e4('0x13')]()['then'](function(){var _0x44cf88=_0x1d3fad[_0x29e4('0x14')]({'plain':!![]});var _0x4ccaa4=_0x29e4('0x15');return db[_0x29e4('0x16')][_0x29e4('0x13')]({'where':{'type':_0x4ccaa4,'resourceId':_0x44cf88['id']}})[_0x29e4('0x12')](function(){return _0x1d3fad;});})[_0x29e4('0x12')](function(){var _0x4a26fa=new Redis(config[_0x29e4('0x8')]);_0x4a26fa[_0x29e4('0x17')]('agi',JSON[_0x29e4('0x18')]({'id':_0x1d3fad['id'],'deleted':!![]}));})['then'](function(){_0x36125c[_0x29e4('0xa')](0xcc)[_0x29e4('0x19')]();});}};}function handleEntityNotFound(_0x5d56c7){return function(_0x500230){if(!_0x500230){_0x5d56c7['sendStatus'](0x194);}return _0x500230;};}function handleError(_0xf2a29f,_0x412bd8){_0x412bd8=_0x412bd8||0x1f4;return function(_0x1cf111){logger[_0x29e4('0x1a')](_0x1cf111['stack']);if(_0x1cf111[_0x29e4('0x1b')]){delete _0x1cf111[_0x29e4('0x1b')];}_0xf2a29f[_0x29e4('0xa')](_0x412bd8)[_0x29e4('0x1c')](_0x1cf111);};}exports[_0x29e4('0x1d')]=function(_0x107830,_0x4f9c69){var _0x13a365={},_0x4c6e57={},_0x48d1d3={'count':0x0,'rows':[]};var _0x27b70d=_[_0x29e4('0x1e')](db[_0x29e4('0x1f')][_0x29e4('0x20')],function(_0x12700e){return{'name':_0x12700e[_0x29e4('0x21')],'type':_0x12700e['type'][_0x29e4('0x22')]};});_0x4c6e57[_0x29e4('0x23')]=_[_0x29e4('0x1e')](_0x27b70d,_0x29e4('0x1b'));_0x4c6e57[_0x29e4('0x24')]=_[_0x29e4('0x25')](_0x107830[_0x29e4('0x24')]);_0x4c6e57[_0x29e4('0x26')]=_[_0x29e4('0x27')](_0x4c6e57['model'],_0x4c6e57['query']);_0x13a365[_0x29e4('0x28')]=_['intersection'](_0x4c6e57[_0x29e4('0x23')],qs[_0x29e4('0x29')](_0x107830[_0x29e4('0x24')]['fields']));_0x13a365[_0x29e4('0x28')]=_0x13a365[_0x29e4('0x28')][_0x29e4('0x2a')]?_0x13a365[_0x29e4('0x28')]:_0x4c6e57['model'];if(!_0x107830['query'][_0x29e4('0x2b')](_0x29e4('0x2c'))){_0x13a365[_0x29e4('0xe')]=qs[_0x29e4('0xe')](_0x107830[_0x29e4('0x24')]['limit']);_0x13a365[_0x29e4('0xb')]=qs[_0x29e4('0xb')](_0x107830[_0x29e4('0x24')][_0x29e4('0xb')]);}_0x13a365[_0x29e4('0x2d')]=qs['sort'](_0x107830['query'][_0x29e4('0x2e')]);_0x13a365[_0x29e4('0x2f')]=qs[_0x29e4('0x26')](_[_0x29e4('0x30')](_0x107830[_0x29e4('0x24')],_0x4c6e57[_0x29e4('0x26')]),_0x27b70d);if(_0x107830[_0x29e4('0x24')][_0x29e4('0x31')]){_0x13a365[_0x29e4('0x2f')]=_['merge'](_0x13a365[_0x29e4('0x2f')],{'$or':_[_0x29e4('0x1e')](_0x27b70d,function(_0x527aa5){if(_0x527aa5[_0x29e4('0x32')]!=='VIRTUAL'){var _0x4057f6={};_0x4057f6[_0x527aa5[_0x29e4('0x1b')]]={'$like':'%'+_0x107830['query']['filter']+'%'};return _0x4057f6;}})});}_0x13a365=_['merge']({},_0x13a365,_0x107830[_0x29e4('0x33')]);var _0x2384c6={'where':_0x13a365[_0x29e4('0x2f')]};return db['SquareProject']['count'](_0x2384c6)[_0x29e4('0x12')](function(_0x418d44){_0x48d1d3[_0x29e4('0xd')]=_0x418d44;if(_0x107830[_0x29e4('0x24')][_0x29e4('0x34')]){_0x13a365['include']=[{'all':!![]}];}return db[_0x29e4('0x1f')]['findAll'](_0x13a365);})[_0x29e4('0x12')](function(_0x429f33){_0x48d1d3[_0x29e4('0x35')]=_0x429f33;return _0x48d1d3;})['then'](respondWithFilteredResult(_0x4f9c69,_0x13a365))[_0x29e4('0x36')](handleError(_0x4f9c69,null));};exports[_0x29e4('0x37')]=function(_0x3aaa9c,_0x36e714){var _0x170924={'raw':![],'where':{'id':_0x3aaa9c[_0x29e4('0x38')]['id']}},_0x274ad6={};_0x274ad6['model']=_[_0x29e4('0x25')](db[_0x29e4('0x1f')][_0x29e4('0x20')]);_0x274ad6[_0x29e4('0x24')]=_[_0x29e4('0x25')](_0x3aaa9c[_0x29e4('0x24')]);_0x274ad6[_0x29e4('0x26')]=_[_0x29e4('0x27')](_0x274ad6[_0x29e4('0x23')],_0x274ad6['query']);_0x170924['attributes']=_['intersection'](_0x274ad6[_0x29e4('0x23')],qs[_0x29e4('0x29')](_0x3aaa9c[_0x29e4('0x24')]['fields']));_0x170924[_0x29e4('0x28')]=_0x170924['attributes'][_0x29e4('0x2a')]?_0x170924[_0x29e4('0x28')]:_0x274ad6['model'];if(_0x3aaa9c[_0x29e4('0x24')][_0x29e4('0x34')]){_0x170924['include']=[{'all':!![]}];}_0x170924=_[_0x29e4('0x39')]({},_0x170924,_0x3aaa9c[_0x29e4('0x33')]);return db[_0x29e4('0x1f')][_0x29e4('0x3a')](_0x170924)[_0x29e4('0x12')](handleEntityNotFound(_0x36e714,null))[_0x29e4('0x12')](respondWithResult(_0x36e714,null))['catch'](handleError(_0x36e714,null));};exports[_0x29e4('0x3b')]=function(_0x49ec5e,_0x55e1f5){return db[_0x29e4('0x1f')]['create'](_0x49ec5e[_0x29e4('0x3c')],{})['then'](function(_0x31d40d){var _0x5c2ae2=_0x49ec5e[_0x29e4('0x3d')][_0x29e4('0x14')]({'plain':!![]});if(!_0x5c2ae2)throw new Error(_0x29e4('0x3e'));if(_0x5c2ae2[_0x29e4('0x3f')]===_0x29e4('0x3d')){var _0xee82d5=_0x31d40d[_0x29e4('0x14')]({'plain':!![]});var _0x4e5292=_0x29e4('0x15');return db['UserProfileSection'][_0x29e4('0x3a')]({'where':{'name':_0x4e5292,'userProfileId':_0x5c2ae2['userProfileId']},'raw':!![]})['then'](function(_0x3944f3){if(_0x3944f3&&_0x3944f3['autoAssociation']===0x0){return db[_0x29e4('0x16')][_0x29e4('0x3b')]({'name':_0xee82d5[_0x29e4('0x1b')],'resourceId':_0xee82d5['id'],'type':_0x3944f3[_0x29e4('0x1b')],'sectionId':_0x3944f3['id']},{})[_0x29e4('0x12')](function(){return _0x31d40d;});}else{return _0x31d40d;}})[_0x29e4('0x36')](function(_0x595158){logger[_0x29e4('0x1a')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x595158);throw _0x595158;});}return _0x31d40d;})[_0x29e4('0x12')](respondWithResult(_0x55e1f5,0xc9))['catch'](handleError(_0x55e1f5,null));};exports['update']=function(_0x2897d5,_0x1be9f7){if(_0x2897d5[_0x29e4('0x3c')]['id']){delete _0x2897d5[_0x29e4('0x3c')]['id'];}return db[_0x29e4('0x1f')][_0x29e4('0x3a')]({'where':{'id':_0x2897d5['params']['id']}})[_0x29e4('0x12')](handleEntityNotFound(_0x1be9f7,null))[_0x29e4('0x12')](saveUpdates(_0x2897d5[_0x29e4('0x3c')],null))[_0x29e4('0x12')](function(_0x498393){if(!_0x498393)return;var _0x2b107b=_0x498393[_0x29e4('0x14')]({'plain':!![]});return _0x2b107b;})['then'](function(_0x5c9694){var _0x5f43e2=new Redis(config[_0x29e4('0x8')]);_0x5f43e2['publish']('agi',JSON[_0x29e4('0x18')](_[_0x29e4('0x30')](_0x5c9694,['id',_0x29e4('0x1b'),'production'])));return _0x5c9694;})['then'](respondWithResult(_0x1be9f7,null))[_0x29e4('0x36')](handleError(_0x1be9f7,null));};exports[_0x29e4('0x13')]=function(_0x1831bb,_0x43be85){return db['SquareProject']['find']({'where':{'id':_0x1831bb[_0x29e4('0x38')]['id']}})[_0x29e4('0x12')](handleEntityNotFound(_0x43be85,null))[_0x29e4('0x12')](removeEntity(_0x43be85,null))[_0x29e4('0x36')](handleError(_0x43be85,null));};
\ No newline at end of file