Built motion from commit 4ffc18b1.|2.6.31
[motion2.git] / server / api / cmList / cmList.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 _0x7f54=['distinct','c.cf_','field','cm_contact_has_items','ItemTypeId\x20=\x20?','CmContactId\x20=\x20c.id','additionalPhone_','description','description_additionalPhone_','toString','now','writeFileSync','format','/tmp/list_%d_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','list_%d_%s.csv','Content-type','text/csv','download','addCustomField','sequelize','transaction','addCustomFields','Sequelize','TEXT','text','number','INTEGER','BOOLEAN','defaultValue','queryInterface','addColumn','cf_%s','getCustomFields','findAndCountAll','addAgents','emit','userCmList:save','removeAgents','getAgents','User','spread','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','sox','to-csv','fs-extra','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/environment','../../config/license/util','../../mysqldb','redis','./cmList.socket','register','sendStatus','status','end','json','offset','undefined','count','limit','set','Content-Range','reject','update','then','destroy','get','error','stack','name','send','index','map','CmList','rawAttributes','fieldName','type','key','model','query','keys','attributes','intersection','fields','length','nolimit','order','sort','where','filters','pick','filter','merge','VIRTUAL','options','includeAll','include','findAll','catch','show','params','body','user','role','find','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','describe','addDisposition','ListId','Disposition','create','findOne','hasOwnProperty','rows','removeDispositions','ids','addContacts','CmContact','tags','isArray','join','push','each','omit','dataValues','errors','message','Malformed\x20request\x20syntax','getContacts','CmCustomField','CustomFields','concat','cf_%d','raw','getContactsCsv','ContactItemType','OrderBy','alias','select','from','cm_contacts','c.ListId\x20=\x20?'];(function(_0x122ef9,_0x451d2a){var _0x42fba0=function(_0x17c9d3){while(--_0x17c9d3){_0x122ef9['push'](_0x122ef9['shift']());}};_0x42fba0(++_0x451d2a);}(_0x7f54,0xd1));var _0x47f5=function(_0x250f95,_0x5a5728){_0x250f95=_0x250f95-0x0;var _0x4ada97=_0x7f54[_0x250f95];return _0x4ada97;};'use strict';var emlformat=require(_0x47f5('0x0'));var rimraf=require(_0x47f5('0x1'));var zipdir=require(_0x47f5('0x2'));var jsonpatch=require(_0x47f5('0x3'));var rp=require(_0x47f5('0x4'));var moment=require('moment');var BPromise=require(_0x47f5('0x5'));var Mustache=require(_0x47f5('0x6'));var util=require(_0x47f5('0x7'));var path=require('path');var sox=require(_0x47f5('0x8'));var csv=require(_0x47f5('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x47f5('0xa'));var _=require(_0x47f5('0xb'));var squel=require(_0x47f5('0xc'));var crypto=require(_0x47f5('0xd'));var jsforce=require('jsforce');var deskjs=require(_0x47f5('0xe'));var toCsv=require('to-csv');var querystring=require(_0x47f5('0xf'));var Papa=require(_0x47f5('0x10'));var Redis=require(_0x47f5('0x11'));var authService=require(_0x47f5('0x12'));var qs=require(_0x47f5('0x13'));var as=require(_0x47f5('0x14'));var hardwareService=require(_0x47f5('0x15'));var logger=require(_0x47f5('0x16'))('api');var utils=require('../../config/utils');var config=require(_0x47f5('0x17'));var licenseUtil=require(_0x47f5('0x18'));var db=require(_0x47f5('0x19'))['db'];var csv_results;config['redis']=_['defaults'](config[_0x47f5('0x1a')],{'host':'localhost','port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x47f5('0x1a')]));require(_0x47f5('0x1b'))[_0x47f5('0x1c')](socket);function respondWithStatusCode(_0x37d89d,_0x3854b5){_0x3854b5=_0x3854b5||0xcc;return function(_0x1eba75){if(_0x1eba75){return _0x37d89d[_0x47f5('0x1d')](_0x3854b5);}return _0x37d89d[_0x47f5('0x1e')](_0x3854b5)[_0x47f5('0x1f')]();};}function respondWithResult(_0x1c2124,_0x232570){_0x232570=_0x232570||0xc8;return function(_0x35228e){if(_0x35228e){return _0x1c2124['status'](_0x232570)[_0x47f5('0x20')](_0x35228e);}};}function respondWithFilteredResult(_0x24ac50,_0x58e1d6){return function(_0x448ba8){if(_0x448ba8){var _0x59264f=typeof _0x58e1d6[_0x47f5('0x21')]===_0x47f5('0x22')&&typeof _0x58e1d6['limit']===_0x47f5('0x22');var _0x3d4993=_0x448ba8[_0x47f5('0x23')];var _0x3c0034=_0x59264f?0x0:_0x58e1d6['offset'];var _0x3c1687=_0x59264f?_0x448ba8[_0x47f5('0x23')]:_0x58e1d6[_0x47f5('0x21')]+_0x58e1d6[_0x47f5('0x24')];var _0x2a8390;if(_0x3c1687>=_0x3d4993){_0x3c1687=_0x3d4993;_0x2a8390=0xc8;}else{_0x2a8390=0xce;}_0x24ac50['status'](_0x2a8390);return _0x24ac50[_0x47f5('0x25')](_0x47f5('0x26'),_0x3c0034+'-'+_0x3c1687+'/'+_0x3d4993)[_0x47f5('0x20')](_0x448ba8);}return null;};}function patchUpdates(_0x305f30){return function(_0x4d9a8a){try{jsonpatch['apply'](_0x4d9a8a,_0x305f30,!![]);}catch(_0x1fd192){return BPromise[_0x47f5('0x27')](_0x1fd192);}return _0x4d9a8a['save']();};}function saveUpdates(_0x3e6278,_0x21c89e){return function(_0x468a9b){if(_0x468a9b){return _0x468a9b[_0x47f5('0x28')](_0x3e6278)[_0x47f5('0x29')](function(_0x412775){return _0x412775;});}return null;};}function removeEntity(_0x5f2d04,_0x23b385){return function(_0xfd8ca1){if(_0xfd8ca1){return _0xfd8ca1[_0x47f5('0x2a')]()['then'](function(){var _0x283c1f=_0xfd8ca1[_0x47f5('0x2b')]({'plain':!![]});var _0x302e4d='Lists';return db['UserProfileResource'][_0x47f5('0x2a')]({'where':{'type':_0x302e4d,'resourceId':_0x283c1f['id']}})[_0x47f5('0x29')](function(){return _0xfd8ca1;});})['then'](function(){_0x5f2d04[_0x47f5('0x1e')](0xcc)[_0x47f5('0x1f')]();});}};}function handleEntityNotFound(_0x1b66ba,_0xcc0468){return function(_0x4d9f62){if(!_0x4d9f62){_0x1b66ba[_0x47f5('0x1d')](0x194);}return _0x4d9f62;};}function handleError(_0x7aa9df,_0x97b052){_0x97b052=_0x97b052||0x1f4;return function(_0x552f7a){logger[_0x47f5('0x2c')](_0x552f7a[_0x47f5('0x2d')]);if(_0x552f7a[_0x47f5('0x2e')]){delete _0x552f7a[_0x47f5('0x2e')];}_0x7aa9df[_0x47f5('0x1e')](_0x97b052)[_0x47f5('0x2f')](_0x552f7a);};}exports[_0x47f5('0x30')]=function(_0x454811,_0x486775){var _0x177ee7={},_0x32ebc4={},_0x3c4908={'count':0x0,'rows':[]};var _0x5255e4=_[_0x47f5('0x31')](db[_0x47f5('0x32')][_0x47f5('0x33')],function(_0x5a37d0){return{'name':_0x5a37d0[_0x47f5('0x34')],'type':_0x5a37d0[_0x47f5('0x35')][_0x47f5('0x36')]};});_0x32ebc4[_0x47f5('0x37')]=_[_0x47f5('0x31')](_0x5255e4,_0x47f5('0x2e'));_0x32ebc4[_0x47f5('0x38')]=_[_0x47f5('0x39')](_0x454811[_0x47f5('0x38')]);_0x32ebc4['filters']=_['intersection'](_0x32ebc4['model'],_0x32ebc4[_0x47f5('0x38')]);_0x177ee7[_0x47f5('0x3a')]=_[_0x47f5('0x3b')](_0x32ebc4[_0x47f5('0x37')],qs[_0x47f5('0x3c')](_0x454811[_0x47f5('0x38')][_0x47f5('0x3c')]));_0x177ee7[_0x47f5('0x3a')]=_0x177ee7[_0x47f5('0x3a')][_0x47f5('0x3d')]?_0x177ee7[_0x47f5('0x3a')]:_0x32ebc4[_0x47f5('0x37')];if(!_0x454811[_0x47f5('0x38')]['hasOwnProperty'](_0x47f5('0x3e'))){_0x177ee7[_0x47f5('0x24')]=qs[_0x47f5('0x24')](_0x454811[_0x47f5('0x38')][_0x47f5('0x24')]);_0x177ee7[_0x47f5('0x21')]=qs[_0x47f5('0x21')](_0x454811[_0x47f5('0x38')]['offset']);}_0x177ee7[_0x47f5('0x3f')]=qs[_0x47f5('0x40')](_0x454811[_0x47f5('0x38')][_0x47f5('0x40')]);_0x177ee7[_0x47f5('0x41')]=qs[_0x47f5('0x42')](_[_0x47f5('0x43')](_0x454811['query'],_0x32ebc4[_0x47f5('0x42')]),_0x5255e4);if(_0x454811['query'][_0x47f5('0x44')]){_0x177ee7['where']=_[_0x47f5('0x45')](_0x177ee7[_0x47f5('0x41')],{'$or':_['map'](_0x5255e4,function(_0x2d22ee){if(_0x2d22ee[_0x47f5('0x35')]!==_0x47f5('0x46')){var _0x397f1d={};_0x397f1d[_0x2d22ee[_0x47f5('0x2e')]]={'$like':'%'+_0x454811[_0x47f5('0x38')][_0x47f5('0x44')]+'%'};return _0x397f1d;}})});}_0x177ee7=_['merge']({},_0x177ee7,_0x454811[_0x47f5('0x47')]);var _0x28730e={'where':_0x177ee7[_0x47f5('0x41')]};return db[_0x47f5('0x32')][_0x47f5('0x23')](_0x28730e)[_0x47f5('0x29')](function(_0x1bd49a){_0x3c4908['count']=_0x1bd49a;if(_0x454811[_0x47f5('0x38')][_0x47f5('0x48')]){_0x177ee7[_0x47f5('0x49')]=[{'all':!![]}];}return db[_0x47f5('0x32')][_0x47f5('0x4a')](_0x177ee7);})[_0x47f5('0x29')](function(_0x5d893f){_0x3c4908['rows']=_0x5d893f;return _0x3c4908;})[_0x47f5('0x29')](respondWithFilteredResult(_0x486775,_0x177ee7))[_0x47f5('0x4b')](handleError(_0x486775,null));};exports[_0x47f5('0x4c')]=function(_0x4b8a5f,_0x88ea1e){var _0x106ed1={'raw':![],'where':{'id':_0x4b8a5f[_0x47f5('0x4d')]['id']}},_0x269979={};_0x269979[_0x47f5('0x37')]=_[_0x47f5('0x39')](db[_0x47f5('0x32')][_0x47f5('0x33')]);_0x269979[_0x47f5('0x38')]=_[_0x47f5('0x39')](_0x4b8a5f[_0x47f5('0x38')]);_0x269979[_0x47f5('0x42')]=_[_0x47f5('0x3b')](_0x269979['model'],_0x269979['query']);_0x106ed1['attributes']=_[_0x47f5('0x3b')](_0x269979[_0x47f5('0x37')],qs[_0x47f5('0x3c')](_0x4b8a5f[_0x47f5('0x38')]['fields']));_0x106ed1[_0x47f5('0x3a')]=_0x106ed1[_0x47f5('0x3a')][_0x47f5('0x3d')]?_0x106ed1[_0x47f5('0x3a')]:_0x269979[_0x47f5('0x37')];if(_0x4b8a5f[_0x47f5('0x38')][_0x47f5('0x48')]){_0x106ed1['include']=[{'all':!![]}];}_0x106ed1=_[_0x47f5('0x45')]({},_0x106ed1,_0x4b8a5f[_0x47f5('0x47')]);return db['CmList']['find'](_0x106ed1)[_0x47f5('0x29')](handleEntityNotFound(_0x88ea1e,null))[_0x47f5('0x29')](respondWithResult(_0x88ea1e,null))[_0x47f5('0x4b')](handleError(_0x88ea1e,null));};exports['create']=function(_0x42b711,_0x211454){return db[_0x47f5('0x32')]['create'](_0x42b711[_0x47f5('0x4e')],{})['then'](function(_0x22ef70){var _0x1d9bf6=_0x42b711[_0x47f5('0x4f')][_0x47f5('0x2b')]({'plain':!![]});if(!_0x1d9bf6)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x1d9bf6[_0x47f5('0x50')]===_0x47f5('0x4f')){var _0x5ba276=_0x22ef70[_0x47f5('0x2b')]({'plain':!![]});var _0x341d56='Lists';return db['UserProfileSection'][_0x47f5('0x51')]({'where':{'name':_0x341d56,'userProfileId':_0x1d9bf6['userProfileId']},'raw':!![]})[_0x47f5('0x29')](function(_0x3b53cb){if(_0x3b53cb&&_0x3b53cb[_0x47f5('0x52')]===0x0){return db[_0x47f5('0x53')]['create']({'name':_0x5ba276['name'],'resourceId':_0x5ba276['id'],'type':_0x3b53cb['name'],'sectionId':_0x3b53cb['id']},{})[_0x47f5('0x29')](function(){return _0x22ef70;});}else{return _0x22ef70;}})['catch'](function(_0x15a386){logger[_0x47f5('0x2c')](_0x47f5('0x54'),_0x15a386);throw _0x15a386;});}return _0x22ef70;})[_0x47f5('0x29')](respondWithResult(_0x211454,0xc9))[_0x47f5('0x4b')](handleError(_0x211454,null));};exports[_0x47f5('0x28')]=function(_0x587aba,_0x2a3840){if(_0x587aba['body']['id']){delete _0x587aba[_0x47f5('0x4e')]['id'];}return db[_0x47f5('0x32')][_0x47f5('0x51')]({'where':{'id':_0x587aba[_0x47f5('0x4d')]['id']}})[_0x47f5('0x29')](handleEntityNotFound(_0x2a3840,null))['then'](saveUpdates(_0x587aba[_0x47f5('0x4e')],null))['then'](respondWithResult(_0x2a3840,null))['catch'](handleError(_0x2a3840,null));};exports[_0x47f5('0x2a')]=function(_0x5115bd,_0x5d4ce0){return db[_0x47f5('0x32')][_0x47f5('0x51')]({'where':{'id':_0x5115bd[_0x47f5('0x4d')]['id']}})[_0x47f5('0x29')](handleEntityNotFound(_0x5d4ce0,null))[_0x47f5('0x29')](removeEntity(_0x5d4ce0,null))[_0x47f5('0x4b')](handleError(_0x5d4ce0,null));};exports[_0x47f5('0x55')]=function(_0xfcd499,_0x1715d4){return db['CmList'][_0x47f5('0x55')]()[_0x47f5('0x29')](respondWithResult(_0x1715d4,null))[_0x47f5('0x4b')](handleError(_0x1715d4,null));};exports[_0x47f5('0x56')]=function(_0x2f92af,_0x440230,_0x343cd5){if(_0x2f92af[_0x47f5('0x4e')]['id']){delete _0x2f92af[_0x47f5('0x4e')]['id'];}return db[_0x47f5('0x32')][_0x47f5('0x51')]({'where':{'id':_0x2f92af[_0x47f5('0x4d')]['id']}})[_0x47f5('0x29')](handleEntityNotFound(_0x440230,null))[_0x47f5('0x29')](function(_0x55c7bc){if(_0x55c7bc){_0x2f92af[_0x47f5('0x4e')][_0x47f5('0x57')]=_0x55c7bc['id'];return db[_0x47f5('0x58')][_0x47f5('0x59')](_0x2f92af['body']);}})[_0x47f5('0x29')](respondWithResult(_0x440230,null))[_0x47f5('0x4b')](handleError(_0x440230,null));};exports['getDispositions']=function(_0x584d92,_0x14d86a,_0x3086a1){var _0x32242a={'raw':![],'where':{}};var _0x4aafd1={};var _0x37ca1f={'count':0x0,'rows':[]};return db['CmList'][_0x47f5('0x5a')]({'where':{'id':_0x584d92[_0x47f5('0x4d')]['id']}})[_0x47f5('0x29')](handleEntityNotFound(_0x14d86a,null))[_0x47f5('0x29')](function(_0x2846d3){if(_0x2846d3){_0x4aafd1[_0x47f5('0x37')]=_[_0x47f5('0x39')](db[_0x47f5('0x58')][_0x47f5('0x33')]);_0x4aafd1[_0x47f5('0x38')]=_[_0x47f5('0x39')](_0x584d92[_0x47f5('0x38')]);_0x4aafd1[_0x47f5('0x42')]=_[_0x47f5('0x3b')](_0x4aafd1[_0x47f5('0x37')],_0x4aafd1[_0x47f5('0x38')]);_0x32242a[_0x47f5('0x3a')]=_[_0x47f5('0x3b')](_0x4aafd1[_0x47f5('0x37')],qs[_0x47f5('0x3c')](_0x584d92[_0x47f5('0x38')]['fields']));_0x32242a[_0x47f5('0x3a')]=_0x32242a[_0x47f5('0x3a')][_0x47f5('0x3d')]?_0x32242a['attributes']:_0x4aafd1['model'];if(!_0x584d92[_0x47f5('0x38')][_0x47f5('0x5b')]('nolimit')){_0x32242a['limit']=qs[_0x47f5('0x24')](_0x584d92[_0x47f5('0x38')]['limit']);_0x32242a[_0x47f5('0x21')]=qs[_0x47f5('0x21')](_0x584d92['query'][_0x47f5('0x21')]);}_0x32242a[_0x47f5('0x3f')]=qs['sort'](_0x584d92[_0x47f5('0x38')][_0x47f5('0x40')]);_0x32242a[_0x47f5('0x41')]=qs['filters'](_[_0x47f5('0x43')](_0x584d92[_0x47f5('0x38')],_0x4aafd1[_0x47f5('0x42')]));_0x32242a[_0x47f5('0x41')][_0x47f5('0x57')]=_0x2846d3['id'];if(_0x584d92[_0x47f5('0x38')][_0x47f5('0x44')]){_0x32242a[_0x47f5('0x41')]=_[_0x47f5('0x45')](_0x32242a[_0x47f5('0x41')],{'$or':_['map'](_0x32242a['attributes'],function(_0x27c62c){var _0x577fe3={};_0x577fe3[_0x27c62c]={'$like':'%'+_0x584d92[_0x47f5('0x38')]['filter']+'%'};return _0x577fe3;})});}_0x32242a=_[_0x47f5('0x45')]({},_0x32242a,_0x584d92[_0x47f5('0x47')]);return db[_0x47f5('0x58')][_0x47f5('0x23')]({'where':_0x32242a['where']})[_0x47f5('0x29')](function(_0x192ae7){_0x37ca1f[_0x47f5('0x23')]=_0x192ae7;if(_0x584d92['query'][_0x47f5('0x48')]){_0x32242a[_0x47f5('0x49')]=[{'all':!![]}];}return db[_0x47f5('0x58')]['findAll'](_0x32242a);})[_0x47f5('0x29')](function(_0xb5ac96){_0x37ca1f[_0x47f5('0x5c')]=_0xb5ac96;return _0x37ca1f;});}})[_0x47f5('0x29')](respondWithFilteredResult(_0x14d86a,_0x32242a))[_0x47f5('0x4b')](handleError(_0x14d86a,null));};exports[_0x47f5('0x5d')]=function(_0xb93bd9,_0xf88f06,_0x3a46e5){return db[_0x47f5('0x32')][_0x47f5('0x51')]({'where':{'id':_0xb93bd9[_0x47f5('0x4d')]['id']}})[_0x47f5('0x29')](handleEntityNotFound(_0xf88f06,null))[_0x47f5('0x29')](function(_0x37d71a){if(_0x37d71a){return _0x37d71a[_0x47f5('0x5d')](_0xb93bd9[_0x47f5('0x38')][_0x47f5('0x5e')]);}})[_0x47f5('0x29')](respondWithStatusCode(_0xf88f06,null))[_0x47f5('0x4b')](handleError(_0xf88f06,null));};exports[_0x47f5('0x5f')]=function(_0x4e1ae4,_0x18ce72,_0x27701a){return db[_0x47f5('0x32')][_0x47f5('0x51')]({'where':{'id':_0x4e1ae4[_0x47f5('0x4d')]['id']}})[_0x47f5('0x29')](handleEntityNotFound(_0x18ce72,null))['then'](function(_0x368c91){if(_0x368c91){var _0x1d1caa=[];var _0x333175={'success':[],'errors':[]};return db[_0x47f5('0x60')][_0x47f5('0x55')]()[_0x47f5('0x29')](function(_0x5b898b){if(_0x4e1ae4['body'][_0x47f5('0x61')]&&_[_0x47f5('0x62')](_0x4e1ae4[_0x47f5('0x4e')][_0x47f5('0x61')])){if(_0x4e1ae4[_0x47f5('0x4e')]['tags'][_0x47f5('0x3d')]){_0x4e1ae4['body'][_0x47f5('0x61')]=_0x4e1ae4[_0x47f5('0x4e')]['tags'][_0x47f5('0x63')](';')+';';}else{_0x4e1ae4[_0x47f5('0x4e')][_0x47f5('0x61')]=null;}}else{_0x4e1ae4[_0x47f5('0x4e')][_0x47f5('0x61')]=null;}if(_0x4e1ae4['body']&&_[_0x47f5('0x62')](_0x4e1ae4[_0x47f5('0x4e')])){for(var _0x27df10=0x0;_0x27df10<_0x4e1ae4[_0x47f5('0x4e')]['length'];_0x27df10+=0x1){_0x4e1ae4[_0x47f5('0x4e')][_0x27df10]['ListId']=_0x4e1ae4['params']['id'];_0x1d1caa[_0x47f5('0x64')](_0x4e1ae4[_0x47f5('0x4e')][_0x27df10]);}return BPromise[_0x47f5('0x65')](_0x1d1caa,function(_0x4daaf4){return db['CmContact'][_0x47f5('0x59')](_[_0x47f5('0x66')](_0x4daaf4,['ids','id'])||{},{'fields':_[_0x47f5('0x39')](_0x5b898b),'raw':!![]})[_0x47f5('0x29')](function(_0x16dcb4){_0x333175['success'][_0x47f5('0x64')](_0x16dcb4[_0x47f5('0x67')]);})[_0x47f5('0x4b')](function(_0x561a9c){_0x333175[_0x47f5('0x68')][_0x47f5('0x64')]({'data':_0x4daaf4,'error':_0x561a9c[_0x47f5('0x69')]});});})[_0x47f5('0x29')](function(_0x15c332){return _0x333175;})[_0x47f5('0x4b')](function(_0x43445a){return _0x43445a;});}else{_0x18ce72['status'](0x190)['json']({'message':_0x47f5('0x6a')});}});}})[_0x47f5('0x29')](respondWithResult(_0x18ce72,null))[_0x47f5('0x4b')](handleError(_0x18ce72,null));};exports[_0x47f5('0x6b')]=function(_0x2d781c,_0x5aea66,_0x5d4624){var _0x5a4847;return db[_0x47f5('0x32')][_0x47f5('0x51')]({'where':{'id':_0x2d781c[_0x47f5('0x4d')]['id']},'include':[{'model':db[_0x47f5('0x6c')],'as':_0x47f5('0x6d')}]})[_0x47f5('0x29')](handleEntityNotFound(_0x5aea66,null))['then'](function(_0x27a4d6){if(_0x27a4d6){_0x5a4847=_0x27a4d6;return db[_0x47f5('0x60')][_0x47f5('0x33')];}})[_0x47f5('0x29')](function(_0x40b269){if(_0x40b269){var _0x241a1c={};var _0x30e364={};_0x30e364[_0x47f5('0x37')]=_[_0x47f5('0x6e')](_[_0x47f5('0x39')](_0x40b269),_[_0x47f5('0x31')](_0x5a4847[_0x47f5('0x6d')],function(_0x460bf3){return util['format'](_0x47f5('0x6f'),_0x460bf3['id']);}));_0x30e364[_0x47f5('0x38')]=_[_0x47f5('0x39')](_0x2d781c[_0x47f5('0x38')]);_0x30e364[_0x47f5('0x42')]=_[_0x47f5('0x3b')](_0x30e364[_0x47f5('0x37')],_0x30e364[_0x47f5('0x38')]);_0x241a1c[_0x47f5('0x3a')]=_[_0x47f5('0x3b')](_0x30e364[_0x47f5('0x37')],qs[_0x47f5('0x3c')](_0x2d781c[_0x47f5('0x38')][_0x47f5('0x3c')]));_0x241a1c[_0x47f5('0x3a')]=_0x241a1c[_0x47f5('0x3a')]['length']?_0x241a1c['attributes']:_0x30e364[_0x47f5('0x37')];if(!_0x2d781c[_0x47f5('0x38')][_0x47f5('0x5b')](_0x47f5('0x3e'))){_0x241a1c[_0x47f5('0x24')]=qs[_0x47f5('0x24')](_0x2d781c[_0x47f5('0x38')]['limit']);_0x241a1c[_0x47f5('0x21')]=qs['offset'](_0x2d781c[_0x47f5('0x38')]['offset']);}_0x241a1c[_0x47f5('0x3f')]=qs[_0x47f5('0x40')](_0x2d781c[_0x47f5('0x38')][_0x47f5('0x40')]);_0x241a1c['where']=qs['filters'](_['pick'](_0x2d781c[_0x47f5('0x38')],_0x30e364[_0x47f5('0x42')]));_0x241a1c[_0x47f5('0x70')]=!![];if(_0x2d781c[_0x47f5('0x38')]['filter']){_0x241a1c['where']=_[_0x47f5('0x45')](_0x241a1c[_0x47f5('0x41')],{'$or':_[_0x47f5('0x31')](_0x241a1c['attributes'],function(_0x1022b3){var _0x26ca00={};_0x26ca00[_0x1022b3]={'$like':'%'+_0x2d781c[_0x47f5('0x38')][_0x47f5('0x44')]+'%'};return _0x26ca00;})});}_0x241a1c=_[_0x47f5('0x45')]({},_0x241a1c,_0x2d781c[_0x47f5('0x47')]);return _0x5a4847[_0x47f5('0x6b')](_0x241a1c);}})[_0x47f5('0x29')](respondWithResult(_0x5aea66,null))[_0x47f5('0x4b')](handleError(_0x5aea66,null));};exports[_0x47f5('0x71')]=function(_0xa0afab,_0x5f37c3,_0x167886){var _0x2bde97;var _0x29bd99;var _0x417817;var _0x7838c3=_0xa0afab[_0x47f5('0x4d')]['id'];csv_results=[];return db[_0x47f5('0x72')]['findAll']({'attributes':['id',_0x47f5('0x2e')],'raw':!![],'order':[_0x47f5('0x73')]})[_0x47f5('0x29')](function(_0x3402f8){_0x2bde97=_0x3402f8;var _0x20bd1e=_[_0x47f5('0x39')](db[_0x47f5('0x60')][_0x47f5('0x33')]);return db[_0x47f5('0x6c')][_0x47f5('0x4a')]({'raw':!![],'attributes':['id',_0x47f5('0x74')]})[_0x47f5('0x29')](function(_0x4172d7){_0x29bd99=_0x4172d7;var _0x2b9757=squel[_0x47f5('0x75')]()['fields'](_0x20bd1e)[_0x47f5('0x76')](_0x47f5('0x77'),'c')['where'](_0x47f5('0x78'),_0x7838c3)[_0x47f5('0x41')]('c.deletedAt\x20is\x20null')[_0x47f5('0x79')]();for(var _0x2d318d=0x0;_0x2d318d<_0x29bd99[_0x47f5('0x3d')];_0x2d318d++){_0x2b9757['field'](_0x47f5('0x7a')+_0x29bd99[_0x2d318d]['id'],'customField_'+_0x29bd99[_0x2d318d][_0x47f5('0x74')]);}for(var _0x2d318d=0x0;_0x2d318d<_0x2bde97['length'];_0x2d318d++){_0x2b9757[_0x47f5('0x7b')](squel[_0x47f5('0x75')]()['field']('item')[_0x47f5('0x76')](_0x47f5('0x7c'))[_0x47f5('0x41')](_0x47f5('0x7d'),_0x2bde97[_0x2d318d]['id'])[_0x47f5('0x41')](_0x47f5('0x7e')),_0x47f5('0x7f')+_0x2bde97[_0x2d318d][_0x47f5('0x2e')]);_0x2b9757[_0x47f5('0x7b')](squel[_0x47f5('0x75')]()[_0x47f5('0x7b')](_0x47f5('0x80'))[_0x47f5('0x76')](_0x47f5('0x7c'))[_0x47f5('0x41')](_0x47f5('0x7d'),_0x2bde97[_0x2d318d]['id'])['where'](_0x47f5('0x7e')),_0x47f5('0x81')+_0x2bde97[_0x2d318d][_0x47f5('0x2e')]);}var _0x16bcb6=[];_0x16bcb6['push'](_0x2b9757[_0x47f5('0x82')]());BPromise[_0x47f5('0x65')](_0x16bcb6,handleQuery)[_0x47f5('0x29')](function(_0x186ce5){handleQuery(_0x2b9757[_0x47f5('0x82')]());var _0x2d9a45=csv_results[0x0];if(!_['isEmpty'](_0x2d9a45)){var _0x7fded1=toCsv(_0x2d9a45);var _0x14fc44=Date[_0x47f5('0x83')]();fs[_0x47f5('0x84')](util[_0x47f5('0x85')](_0x47f5('0x86'),_0x7838c3,_0x14fc44),_0x7fded1);_0x5f37c3[_0x47f5('0x87')](_0x47f5('0x88'),_0x47f5('0x89')+util[_0x47f5('0x85')](_0x47f5('0x8a'),_0x7838c3,_0x14fc44));_0x5f37c3[_0x47f5('0x87')](_0x47f5('0x8b'),_0x47f5('0x8c'));return _0x5f37c3[_0x47f5('0x8d')](util['format'](_0x47f5('0x86'),_0x7838c3,_0x14fc44));}else{return _0x5f37c3[_0x47f5('0x1d')](0xcc);}});});});};exports[_0x47f5('0x8e')]=function(_0x442df8,_0x49f6ed,_0x23aafd){var _0x4a400a;delete _0x442df8[_0x47f5('0x4e')]['id'];return db[_0x47f5('0x32')][_0x47f5('0x5a')]({'where':{'id':_0x442df8[_0x47f5('0x4d')]['id']}})[_0x47f5('0x29')](handleEntityNotFound(_0x49f6ed,null))[_0x47f5('0x29')](function(_0x305fbd){if(_0x305fbd){return db[_0x47f5('0x8f')][_0x47f5('0x90')](function(_0x3c9e4f){return db[_0x47f5('0x6c')][_0x47f5('0x59')](_0x442df8[_0x47f5('0x4e')],{'transaction':_0x3c9e4f})[_0x47f5('0x29')](function(_0xc8fc7){_0x4a400a=_0xc8fc7;return _0x305fbd[_0x47f5('0x91')](_0xc8fc7,{'transaction':_0x3c9e4f});})[_0x47f5('0x29')](function(){var _0x1e18db={'type':db[_0x47f5('0x92')][_0x47f5('0x93')],'transaction':_0x3c9e4f};switch(_0x442df8[_0x47f5('0x4e')]['type']){case _0x47f5('0x94'):_0x1e18db[_0x47f5('0x35')]=db['Sequelize'][_0x47f5('0x93')];break;case _0x47f5('0x95'):_0x1e18db['type']=db[_0x47f5('0x92')][_0x47f5('0x96')];break;case'switch':_0x1e18db['type']=db[_0x47f5('0x92')][_0x47f5('0x97')];_0x1e18db[_0x47f5('0x98')]=![];break;default:}return db[_0x47f5('0x8f')][_0x47f5('0x99')][_0x47f5('0x9a')](_0x47f5('0x77'),util[_0x47f5('0x85')](_0x47f5('0x9b'),_0x4a400a['id']),_0x1e18db);})[_0x47f5('0x29')](function(){return _0x4a400a;});});}})[_0x47f5('0x29')](respondWithResult(_0x49f6ed,null))[_0x47f5('0x4b')](handleError(_0x49f6ed,null));};exports[_0x47f5('0x9c')]=function(_0x2b8731,_0x4ae666,_0x4b86f3){var _0x4e2b02={};var _0x12eae1={};var _0x1a195c;var _0x416aae;return db[_0x47f5('0x32')]['findOne']({'where':{'id':_0x2b8731[_0x47f5('0x4d')]['id']}})[_0x47f5('0x29')](handleEntityNotFound(_0x4ae666,null))['then'](function(_0x4edc6e){if(_0x4edc6e){_0x1a195c=_0x4edc6e;_0x12eae1[_0x47f5('0x37')]=_[_0x47f5('0x39')](db[_0x47f5('0x6c')]['rawAttributes']);_0x12eae1[_0x47f5('0x38')]=_[_0x47f5('0x39')](_0x2b8731[_0x47f5('0x38')]);_0x12eae1[_0x47f5('0x42')]=_[_0x47f5('0x3b')](_0x12eae1[_0x47f5('0x37')],_0x12eae1[_0x47f5('0x38')]);_0x4e2b02['attributes']=_[_0x47f5('0x3b')](_0x12eae1['model'],qs['fields'](_0x2b8731['query'][_0x47f5('0x3c')]));_0x4e2b02[_0x47f5('0x3a')]=_0x4e2b02[_0x47f5('0x3a')]['length']?_0x4e2b02[_0x47f5('0x3a')]:_0x12eae1[_0x47f5('0x37')];_0x4e2b02['order']=qs[_0x47f5('0x40')](_0x2b8731[_0x47f5('0x38')][_0x47f5('0x40')]);_0x4e2b02[_0x47f5('0x41')]=qs['filters'](_[_0x47f5('0x43')](_0x2b8731[_0x47f5('0x38')],_0x12eae1[_0x47f5('0x42')]));_0x4e2b02[_0x47f5('0x41')]=_[_0x47f5('0x45')](_0x4e2b02[_0x47f5('0x41')],{'$or':[{'ListId':_0x4edc6e['id']},{'ListId':null}]});if(_0x2b8731[_0x47f5('0x38')]['filter']){_0x4e2b02[_0x47f5('0x41')]=_[_0x47f5('0x45')](_0x4e2b02[_0x47f5('0x41')],{'$or':_[_0x47f5('0x31')](_0x4e2b02['attributes'],function(_0x3a36f4){var _0x5e356b={};_0x5e356b[_0x3a36f4]={'$like':'%'+_0x2b8731[_0x47f5('0x38')][_0x47f5('0x44')]+'%'};return _0x5e356b;})});}_0x4e2b02=_[_0x47f5('0x45')]({},_0x4e2b02,_0x2b8731[_0x47f5('0x47')]);return db[_0x47f5('0x6c')][_0x47f5('0x9d')](_0x4e2b02);}})[_0x47f5('0x29')](respondWithResult(_0x4ae666,null))[_0x47f5('0x4b')](handleError(_0x4ae666,null));};exports['getGlobalCustomFields']=function(_0x4868dc,_0x117e1c){return db[_0x47f5('0x6c')]['findAndCountAll']({'where':{'ListId':null}})[_0x47f5('0x29')](handleEntityNotFound(_0x117e1c,null))[_0x47f5('0x29')](function(_0x2ab9f7){return _0x2ab9f7;})[_0x47f5('0x29')](respondWithResult(_0x117e1c,null))['catch'](handleError(_0x117e1c,null));};exports[_0x47f5('0x9e')]=function(_0x4f0688,_0xbd8e33,_0x1f8226){return db[_0x47f5('0x32')][_0x47f5('0x51')]({'where':{'id':_0x4f0688[_0x47f5('0x4d')]['id']}})['then'](handleEntityNotFound(_0xbd8e33,null))['then'](function(_0x14897e){if(_0x14897e){return _0x14897e[_0x47f5('0x9e')](_0x4f0688[_0x47f5('0x4e')][_0x47f5('0x5e')],_[_0x47f5('0x66')](_0x4f0688[_0x47f5('0x4e')],[_0x47f5('0x5e'),'id'])||{})['spread'](function(_0x3b91f9){for(var _0x2316cd=0x0;_0x2316cd<_0x4f0688['body'][_0x47f5('0x5e')][_0x47f5('0x3d')];_0x2316cd+=0x1){socket[_0x47f5('0x9f')](_0x47f5('0xa0'),{'UserId':Number(_0x4f0688['body'][_0x47f5('0x5e')][_0x2316cd]),'CmListId':Number(_0x4f0688[_0x47f5('0x4d')]['id'])});}return _0x3b91f9;});}})[_0x47f5('0x29')](respondWithResult(_0xbd8e33,null))[_0x47f5('0x4b')](handleError(_0xbd8e33,null));};exports[_0x47f5('0xa1')]=function(_0x1444bd,_0x4f84b7,_0x433d81){return db['CmList'][_0x47f5('0x51')]({'where':{'id':_0x1444bd[_0x47f5('0x4d')]['id']}})[_0x47f5('0x29')](handleEntityNotFound(_0x4f84b7,null))[_0x47f5('0x29')](function(_0x2ec3f4){if(_0x2ec3f4){return _0x2ec3f4[_0x47f5('0xa1')](_0x1444bd[_0x47f5('0x38')][_0x47f5('0x5e')])[_0x47f5('0x29')](function(){if(_[_0x47f5('0x62')](_0x1444bd[_0x47f5('0x38')][_0x47f5('0x5e')])){for(var _0x34ae83=0x0;_0x34ae83<_0x1444bd['query'][_0x47f5('0x5e')][_0x47f5('0x3d')];_0x34ae83+=0x1){socket[_0x47f5('0x9f')]('userCmList:remove',{'UserId':Number(_0x1444bd[_0x47f5('0x38')][_0x47f5('0x5e')][_0x34ae83]),'CmListId':Number(_0x1444bd[_0x47f5('0x4d')]['id'])});}}else{socket[_0x47f5('0x9f')]('userCmList:remove',{'UserId':Number(_0x1444bd[_0x47f5('0x38')][_0x47f5('0x5e')]),'CmListId':Number(_0x1444bd['params']['id'])});}});}})['then'](respondWithStatusCode(_0x4f84b7,null))[_0x47f5('0x4b')](handleError(_0x4f84b7,null));};exports[_0x47f5('0xa2')]=function(_0x3367ba,_0x3099d5,_0x444c38){var _0x3dd228={};var _0x371f51={};var _0x5d18ce;var _0x1b70ba;return db[_0x47f5('0x32')][_0x47f5('0x5a')]({'where':{'id':_0x3367ba[_0x47f5('0x4d')]['id']}})['then'](handleEntityNotFound(_0x3099d5,null))[_0x47f5('0x29')](function(_0x5c735d){if(_0x5c735d){_0x5d18ce=_0x5c735d;_0x371f51[_0x47f5('0x37')]=_[_0x47f5('0x39')](db[_0x47f5('0xa3')][_0x47f5('0x33')]);_0x371f51[_0x47f5('0x38')]=_[_0x47f5('0x39')](_0x3367ba[_0x47f5('0x38')]);_0x371f51[_0x47f5('0x42')]=_[_0x47f5('0x3b')](_0x371f51[_0x47f5('0x37')],_0x371f51['query']);_0x3dd228[_0x47f5('0x3a')]=_[_0x47f5('0x3b')](_0x371f51[_0x47f5('0x37')],qs[_0x47f5('0x3c')](_0x3367ba[_0x47f5('0x38')][_0x47f5('0x3c')]));_0x3dd228[_0x47f5('0x3a')]=_0x3dd228[_0x47f5('0x3a')][_0x47f5('0x3d')]?_0x3dd228[_0x47f5('0x3a')]:_0x371f51[_0x47f5('0x37')];_0x3dd228[_0x47f5('0x3f')]=qs[_0x47f5('0x40')](_0x3367ba[_0x47f5('0x38')][_0x47f5('0x40')]);_0x3dd228[_0x47f5('0x41')]=qs[_0x47f5('0x42')](_['pick'](_0x3367ba[_0x47f5('0x38')],_0x371f51['filters']));if(_0x3367ba[_0x47f5('0x38')]['filter']){_0x3dd228[_0x47f5('0x41')]=_[_0x47f5('0x45')](_0x3dd228[_0x47f5('0x41')],{'$or':_['map'](_0x3dd228[_0x47f5('0x3a')],function(_0x2bdef8){var _0x39375a={};_0x39375a[_0x2bdef8]={'$like':'%'+_0x3367ba['query']['filter']+'%'};return _0x39375a;})});}_0x3dd228=_[_0x47f5('0x45')]({},_0x3dd228,_0x3367ba['options']);return _0x5d18ce[_0x47f5('0xa2')](_0x3dd228);}})[_0x47f5('0x29')](function(_0x4760a8){if(_0x4760a8){_0x1b70ba=_0x4760a8[_0x47f5('0x3d')];if(!_0x3367ba[_0x47f5('0x38')]['hasOwnProperty']('nolimit')){_0x3dd228['limit']=qs['limit'](_0x3367ba[_0x47f5('0x38')][_0x47f5('0x24')]);_0x3dd228[_0x47f5('0x21')]=qs[_0x47f5('0x21')](_0x3367ba[_0x47f5('0x38')][_0x47f5('0x21')]);}return _0x5d18ce[_0x47f5('0xa2')](_0x3dd228);}})[_0x47f5('0x29')](function(_0x2a7891){if(_0x2a7891){return _0x2a7891?{'count':_0x1b70ba,'rows':_0x2a7891}:null;}})[_0x47f5('0x29')](respondWithResult(_0x3099d5,null))['catch'](handleError(_0x3099d5,null));};function handleQuery(_0x1582a3){logger['info'](_0x1582a3);return db[_0x47f5('0x8f')][_0x47f5('0x38')](_0x1582a3)[_0x47f5('0xa4')](function(_0x494a75){csv_results['push'](_0x494a75);})['catch'](function(_0x688a1a){logger[_0x47f5('0x2c')](_0x688a1a[_0x47f5('0x69')]);});}