Built motion from commit d5e4af8c.|2.6.23
[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 _0xbe57=['toString','now','writeFileSync','format','/tmp/list_%d_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','Content-type','text/csv','download','addCustomField','sequelize','transaction','addCustomFields','TEXT','text','number','Sequelize','INTEGER','defaultValue','queryInterface','getCustomFields','findAndCountAll','getGlobalCustomFields','addAgents','omit','spread','emit','userCmList:save','removeAgents','userCmList:remove','getAgents','User','info','message','eml-format','zip-dir','fast-json-patch','request-promise','mustache','util','path','sox','to-csv','ejs','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','defaults','redis','socket.io-emitter','register','status','end','offset','undefined','limit','count','set','Content-Range','json','reject','save','update','then','destroy','get','Lists','UserProfileResource','sendStatus','name','index','map','CmList','fieldName','type','model','query','keys','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','sort','pick','filter','where','VIRTUAL','merge','options','includeAll','include','findAll','rows','catch','show','params','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','addDisposition','ListId','Disposition','findOne','order','ids','addContacts','CmContact','describe','tags','isArray','join','push','each','dataValues','errors','Malformed\x20request\x20syntax','CmCustomField','CustomFields','rawAttributes','concat','raw','getContacts','getContactsCsv','ContactItemType','select','cm_contacts','c.ListId\x20=\x20?','c.deletedAt\x20is\x20null','field','c.cf_','customField_','alias','item','from','ItemTypeId\x20=\x20?','CmContactId\x20=\x20c.id','description','cm_contact_has_items','description_additionalPhone_'];(function(_0x41e212,_0x5f0e87){var _0x1a1999=function(_0x574b30){while(--_0x574b30){_0x41e212['push'](_0x41e212['shift']());}};_0x1a1999(++_0x5f0e87);}(_0xbe57,0x166));var _0x7be5=function(_0x50867d,_0x1087ee){_0x50867d=_0x50867d-0x0;var _0x50b02a=_0xbe57[_0x50867d];return _0x50b02a;};'use strict';var emlformat=require(_0x7be5('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x7be5('0x1'));var jsonpatch=require(_0x7be5('0x2'));var rp=require(_0x7be5('0x3'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x7be5('0x4'));var util=require(_0x7be5('0x5'));var path=require(_0x7be5('0x6'));var sox=require(_0x7be5('0x7'));var csv=require(_0x7be5('0x8'));var ejs=require(_0x7be5('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require(_0x7be5('0xa'));var crypto=require(_0x7be5('0xb'));var jsforce=require(_0x7be5('0xc'));var deskjs=require(_0x7be5('0xd'));var toCsv=require(_0x7be5('0x8'));var querystring=require(_0x7be5('0xe'));var Papa=require(_0x7be5('0xf'));var Redis=require('ioredis');var authService=require(_0x7be5('0x10'));var qs=require(_0x7be5('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x7be5('0x12'));var logger=require(_0x7be5('0x13'))(_0x7be5('0x14'));var utils=require(_0x7be5('0x15'));var config=require('../../config/environment');var licenseUtil=require(_0x7be5('0x16'));var db=require(_0x7be5('0x17'))['db'];var csv_results;config['redis']=_[_0x7be5('0x18')](config[_0x7be5('0x19')],{'host':'localhost','port':0x18eb});var socket=require(_0x7be5('0x1a'))(new Redis(config[_0x7be5('0x19')]));require('./cmList.socket')[_0x7be5('0x1b')](socket);function respondWithStatusCode(_0x16a666,_0x4c79b4){_0x4c79b4=_0x4c79b4||0xcc;return function(_0x1004ee){if(_0x1004ee){return _0x16a666['sendStatus'](_0x4c79b4);}return _0x16a666[_0x7be5('0x1c')](_0x4c79b4)[_0x7be5('0x1d')]();};}function respondWithResult(_0x640c06,_0x1e1e43){_0x1e1e43=_0x1e1e43||0xc8;return function(_0x5fdab){if(_0x5fdab){return _0x640c06[_0x7be5('0x1c')](_0x1e1e43)['json'](_0x5fdab);}};}function respondWithFilteredResult(_0x1c20f4,_0x1b3ac4){return function(_0x40cb44){if(_0x40cb44){var _0x58cea8=typeof _0x1b3ac4[_0x7be5('0x1e')]===_0x7be5('0x1f')&&typeof _0x1b3ac4[_0x7be5('0x20')]===_0x7be5('0x1f');var _0x42b83c=_0x40cb44[_0x7be5('0x21')];var _0x82252d=_0x58cea8?0x0:_0x1b3ac4[_0x7be5('0x1e')];var _0x2e80cb=_0x58cea8?_0x40cb44[_0x7be5('0x21')]:_0x1b3ac4['offset']+_0x1b3ac4['limit'];var _0xd585e2;if(_0x2e80cb>=_0x42b83c){_0x2e80cb=_0x42b83c;_0xd585e2=0xc8;}else{_0xd585e2=0xce;}_0x1c20f4[_0x7be5('0x1c')](_0xd585e2);return _0x1c20f4[_0x7be5('0x22')](_0x7be5('0x23'),_0x82252d+'-'+_0x2e80cb+'/'+_0x42b83c)[_0x7be5('0x24')](_0x40cb44);}return null;};}function patchUpdates(_0x2c6ad0){return function(_0x4feb78){try{jsonpatch['apply'](_0x4feb78,_0x2c6ad0,!![]);}catch(_0x17d96c){return BPromise[_0x7be5('0x25')](_0x17d96c);}return _0x4feb78[_0x7be5('0x26')]();};}function saveUpdates(_0x3b482d,_0x51af27){return function(_0x3a1bcd){if(_0x3a1bcd){return _0x3a1bcd[_0x7be5('0x27')](_0x3b482d)[_0x7be5('0x28')](function(_0x263632){return _0x263632;});}return null;};}function removeEntity(_0x48bd45,_0x11bbfb){return function(_0x2c12f8){if(_0x2c12f8){return _0x2c12f8[_0x7be5('0x29')]()['then'](function(){var _0x141135=_0x2c12f8[_0x7be5('0x2a')]({'plain':!![]});var _0x1d8007=_0x7be5('0x2b');return db[_0x7be5('0x2c')]['destroy']({'where':{'type':_0x1d8007,'resourceId':_0x141135['id']}})[_0x7be5('0x28')](function(){return _0x2c12f8;});})[_0x7be5('0x28')](function(){_0x48bd45[_0x7be5('0x1c')](0xcc)[_0x7be5('0x1d')]();});}};}function handleEntityNotFound(_0x424437,_0x47dd62){return function(_0x1d0f8d){if(!_0x1d0f8d){_0x424437[_0x7be5('0x2d')](0x194);}return _0x1d0f8d;};}function handleError(_0x472ed0,_0x9dfe4a){_0x9dfe4a=_0x9dfe4a||0x1f4;return function(_0x5be7aa){logger['error'](_0x5be7aa['stack']);if(_0x5be7aa[_0x7be5('0x2e')]){delete _0x5be7aa[_0x7be5('0x2e')];}_0x472ed0['status'](_0x9dfe4a)['send'](_0x5be7aa);};}exports[_0x7be5('0x2f')]=function(_0x25dec8,_0xeed4b5){var _0xd7d696={},_0x3ba143={},_0xdc91ac={'count':0x0,'rows':[]};var _0x22f94c=_[_0x7be5('0x30')](db[_0x7be5('0x31')]['rawAttributes'],function(_0x239cef){return{'name':_0x239cef[_0x7be5('0x32')],'type':_0x239cef[_0x7be5('0x33')]['key']};});_0x3ba143[_0x7be5('0x34')]=_[_0x7be5('0x30')](_0x22f94c,'name');_0x3ba143[_0x7be5('0x35')]=_[_0x7be5('0x36')](_0x25dec8[_0x7be5('0x35')]);_0x3ba143[_0x7be5('0x37')]=_['intersection'](_0x3ba143[_0x7be5('0x34')],_0x3ba143[_0x7be5('0x35')]);_0xd7d696[_0x7be5('0x38')]=_[_0x7be5('0x39')](_0x3ba143[_0x7be5('0x34')],qs['fields'](_0x25dec8['query'][_0x7be5('0x3a')]));_0xd7d696[_0x7be5('0x38')]=_0xd7d696['attributes'][_0x7be5('0x3b')]?_0xd7d696[_0x7be5('0x38')]:_0x3ba143['model'];if(!_0x25dec8[_0x7be5('0x35')][_0x7be5('0x3c')](_0x7be5('0x3d'))){_0xd7d696[_0x7be5('0x20')]=qs[_0x7be5('0x20')](_0x25dec8[_0x7be5('0x35')][_0x7be5('0x20')]);_0xd7d696[_0x7be5('0x1e')]=qs[_0x7be5('0x1e')](_0x25dec8[_0x7be5('0x35')]['offset']);}_0xd7d696['order']=qs[_0x7be5('0x3e')](_0x25dec8['query']['sort']);_0xd7d696['where']=qs[_0x7be5('0x37')](_[_0x7be5('0x3f')](_0x25dec8['query'],_0x3ba143[_0x7be5('0x37')]),_0x22f94c);if(_0x25dec8[_0x7be5('0x35')][_0x7be5('0x40')]){_0xd7d696[_0x7be5('0x41')]=_['merge'](_0xd7d696[_0x7be5('0x41')],{'$or':_[_0x7be5('0x30')](_0x22f94c,function(_0x4264be){if(_0x4264be[_0x7be5('0x33')]!==_0x7be5('0x42')){var _0x165b47={};_0x165b47[_0x4264be[_0x7be5('0x2e')]]={'$like':'%'+_0x25dec8['query']['filter']+'%'};return _0x165b47;}})});}_0xd7d696=_[_0x7be5('0x43')]({},_0xd7d696,_0x25dec8[_0x7be5('0x44')]);var _0x13241d={'where':_0xd7d696[_0x7be5('0x41')]};return db[_0x7be5('0x31')][_0x7be5('0x21')](_0x13241d)[_0x7be5('0x28')](function(_0x3e9e33){_0xdc91ac[_0x7be5('0x21')]=_0x3e9e33;if(_0x25dec8['query'][_0x7be5('0x45')]){_0xd7d696[_0x7be5('0x46')]=[{'all':!![]}];}return db['CmList'][_0x7be5('0x47')](_0xd7d696);})[_0x7be5('0x28')](function(_0x5d1663){_0xdc91ac[_0x7be5('0x48')]=_0x5d1663;return _0xdc91ac;})[_0x7be5('0x28')](respondWithFilteredResult(_0xeed4b5,_0xd7d696))[_0x7be5('0x49')](handleError(_0xeed4b5,null));};exports[_0x7be5('0x4a')]=function(_0x4cec42,_0x58f89b){var _0x582ce={'raw':![],'where':{'id':_0x4cec42[_0x7be5('0x4b')]['id']}},_0x2aba3c={};_0x2aba3c[_0x7be5('0x34')]=_[_0x7be5('0x36')](db['CmList']['rawAttributes']);_0x2aba3c[_0x7be5('0x35')]=_[_0x7be5('0x36')](_0x4cec42[_0x7be5('0x35')]);_0x2aba3c[_0x7be5('0x37')]=_['intersection'](_0x2aba3c[_0x7be5('0x34')],_0x2aba3c[_0x7be5('0x35')]);_0x582ce['attributes']=_['intersection'](_0x2aba3c['model'],qs['fields'](_0x4cec42['query'][_0x7be5('0x3a')]));_0x582ce['attributes']=_0x582ce[_0x7be5('0x38')][_0x7be5('0x3b')]?_0x582ce['attributes']:_0x2aba3c[_0x7be5('0x34')];if(_0x4cec42['query']['includeAll']){_0x582ce['include']=[{'all':!![]}];}_0x582ce=_['merge']({},_0x582ce,_0x4cec42[_0x7be5('0x44')]);return db[_0x7be5('0x31')][_0x7be5('0x4c')](_0x582ce)[_0x7be5('0x28')](handleEntityNotFound(_0x58f89b,null))[_0x7be5('0x28')](respondWithResult(_0x58f89b,null))[_0x7be5('0x49')](handleError(_0x58f89b,null));};exports[_0x7be5('0x4d')]=function(_0x489928,_0x46a124){return db[_0x7be5('0x31')][_0x7be5('0x4d')](_0x489928[_0x7be5('0x4e')],{})[_0x7be5('0x28')](function(_0x4b9740){var _0x1c5dd7=_0x489928[_0x7be5('0x4f')][_0x7be5('0x2a')]({'plain':!![]});if(!_0x1c5dd7)throw new Error(_0x7be5('0x50'));if(_0x1c5dd7['role']===_0x7be5('0x4f')){var _0x38bdd8=_0x4b9740[_0x7be5('0x2a')]({'plain':!![]});var _0x114f2c=_0x7be5('0x2b');return db['UserProfileSection'][_0x7be5('0x4c')]({'where':{'name':_0x114f2c,'userProfileId':_0x1c5dd7[_0x7be5('0x51')]},'raw':!![]})['then'](function(_0x38f654){if(_0x38f654&&_0x38f654[_0x7be5('0x52')]===0x0){return db[_0x7be5('0x2c')]['create']({'name':_0x38bdd8['name'],'resourceId':_0x38bdd8['id'],'type':_0x38f654['name'],'sectionId':_0x38f654['id']},{})['then'](function(){return _0x4b9740;});}else{return _0x4b9740;}})['catch'](function(_0x14f71d){logger[_0x7be5('0x53')](_0x7be5('0x54'),_0x14f71d);throw _0x14f71d;});}return _0x4b9740;})[_0x7be5('0x28')](respondWithResult(_0x46a124,0xc9))[_0x7be5('0x49')](handleError(_0x46a124,null));};exports[_0x7be5('0x27')]=function(_0x13ab1e,_0x4eaadf){if(_0x13ab1e[_0x7be5('0x4e')]['id']){delete _0x13ab1e[_0x7be5('0x4e')]['id'];}return db[_0x7be5('0x31')][_0x7be5('0x4c')]({'where':{'id':_0x13ab1e[_0x7be5('0x4b')]['id']}})[_0x7be5('0x28')](handleEntityNotFound(_0x4eaadf,null))[_0x7be5('0x28')](saveUpdates(_0x13ab1e[_0x7be5('0x4e')],null))[_0x7be5('0x28')](respondWithResult(_0x4eaadf,null))[_0x7be5('0x49')](handleError(_0x4eaadf,null));};exports[_0x7be5('0x29')]=function(_0x46c84e,_0x5d9d4d){return db['CmList'][_0x7be5('0x4c')]({'where':{'id':_0x46c84e[_0x7be5('0x4b')]['id']}})[_0x7be5('0x28')](handleEntityNotFound(_0x5d9d4d,null))[_0x7be5('0x28')](removeEntity(_0x5d9d4d,null))[_0x7be5('0x49')](handleError(_0x5d9d4d,null));};exports['describe']=function(_0x5924b6,_0x62e1f4){return db['CmList']['describe']()[_0x7be5('0x28')](respondWithResult(_0x62e1f4,null))[_0x7be5('0x49')](handleError(_0x62e1f4,null));};exports[_0x7be5('0x55')]=function(_0x1a57d6,_0x441084,_0xa6d1d){if(_0x1a57d6[_0x7be5('0x4e')]['id']){delete _0x1a57d6['body']['id'];}return db['CmList']['find']({'where':{'id':_0x1a57d6['params']['id']}})['then'](handleEntityNotFound(_0x441084,null))['then'](function(_0x37feb3){if(_0x37feb3){_0x1a57d6[_0x7be5('0x4e')][_0x7be5('0x56')]=_0x37feb3['id'];return db[_0x7be5('0x57')][_0x7be5('0x4d')](_0x1a57d6[_0x7be5('0x4e')]);}})[_0x7be5('0x28')](respondWithResult(_0x441084,null))[_0x7be5('0x49')](handleError(_0x441084,null));};exports['getDispositions']=function(_0x44c283,_0x3cd091,_0x432f22){var _0x302b64={'raw':![],'where':{}};var _0x467481={};var _0x513856={'count':0x0,'rows':[]};return db[_0x7be5('0x31')][_0x7be5('0x58')]({'where':{'id':_0x44c283['params']['id']}})[_0x7be5('0x28')](handleEntityNotFound(_0x3cd091,null))['then'](function(_0x56f324){if(_0x56f324){_0x467481[_0x7be5('0x34')]=_[_0x7be5('0x36')](db[_0x7be5('0x57')]['rawAttributes']);_0x467481[_0x7be5('0x35')]=_[_0x7be5('0x36')](_0x44c283[_0x7be5('0x35')]);_0x467481[_0x7be5('0x37')]=_[_0x7be5('0x39')](_0x467481[_0x7be5('0x34')],_0x467481[_0x7be5('0x35')]);_0x302b64[_0x7be5('0x38')]=_[_0x7be5('0x39')](_0x467481[_0x7be5('0x34')],qs[_0x7be5('0x3a')](_0x44c283[_0x7be5('0x35')][_0x7be5('0x3a')]));_0x302b64['attributes']=_0x302b64[_0x7be5('0x38')][_0x7be5('0x3b')]?_0x302b64[_0x7be5('0x38')]:_0x467481[_0x7be5('0x34')];if(!_0x44c283[_0x7be5('0x35')][_0x7be5('0x3c')](_0x7be5('0x3d'))){_0x302b64[_0x7be5('0x20')]=qs['limit'](_0x44c283['query'][_0x7be5('0x20')]);_0x302b64['offset']=qs['offset'](_0x44c283[_0x7be5('0x35')][_0x7be5('0x1e')]);}_0x302b64[_0x7be5('0x59')]=qs[_0x7be5('0x3e')](_0x44c283[_0x7be5('0x35')][_0x7be5('0x3e')]);_0x302b64[_0x7be5('0x41')]=qs[_0x7be5('0x37')](_[_0x7be5('0x3f')](_0x44c283[_0x7be5('0x35')],_0x467481['filters']));_0x302b64['where']['ListId']=_0x56f324['id'];if(_0x44c283[_0x7be5('0x35')][_0x7be5('0x40')]){_0x302b64[_0x7be5('0x41')]=_['merge'](_0x302b64[_0x7be5('0x41')],{'$or':_[_0x7be5('0x30')](_0x302b64[_0x7be5('0x38')],function(_0xdeac95){var _0x479444={};_0x479444[_0xdeac95]={'$like':'%'+_0x44c283[_0x7be5('0x35')]['filter']+'%'};return _0x479444;})});}_0x302b64=_[_0x7be5('0x43')]({},_0x302b64,_0x44c283[_0x7be5('0x44')]);return db[_0x7be5('0x57')][_0x7be5('0x21')]({'where':_0x302b64[_0x7be5('0x41')]})[_0x7be5('0x28')](function(_0x16d417){_0x513856['count']=_0x16d417;if(_0x44c283[_0x7be5('0x35')][_0x7be5('0x45')]){_0x302b64['include']=[{'all':!![]}];}return db[_0x7be5('0x57')][_0x7be5('0x47')](_0x302b64);})[_0x7be5('0x28')](function(_0x517346){_0x513856[_0x7be5('0x48')]=_0x517346;return _0x513856;});}})[_0x7be5('0x28')](respondWithFilteredResult(_0x3cd091,_0x302b64))[_0x7be5('0x49')](handleError(_0x3cd091,null));};exports['removeDispositions']=function(_0x40997e,_0x1963ba,_0x37105a){return db['CmList']['find']({'where':{'id':_0x40997e[_0x7be5('0x4b')]['id']}})[_0x7be5('0x28')](handleEntityNotFound(_0x1963ba,null))[_0x7be5('0x28')](function(_0x26acf0){if(_0x26acf0){return _0x26acf0['removeDispositions'](_0x40997e[_0x7be5('0x35')][_0x7be5('0x5a')]);}})[_0x7be5('0x28')](respondWithStatusCode(_0x1963ba,null))[_0x7be5('0x49')](handleError(_0x1963ba,null));};exports[_0x7be5('0x5b')]=function(_0x186dc3,_0x3ef3fb,_0x1bd59b){return db[_0x7be5('0x31')][_0x7be5('0x4c')]({'where':{'id':_0x186dc3[_0x7be5('0x4b')]['id']}})[_0x7be5('0x28')](handleEntityNotFound(_0x3ef3fb,null))[_0x7be5('0x28')](function(_0x557f93){if(_0x557f93){var _0x27d7f4=[];var _0x1511c0={'success':[],'errors':[]};return db[_0x7be5('0x5c')][_0x7be5('0x5d')]()[_0x7be5('0x28')](function(_0x1a3812){if(_0x186dc3['body'][_0x7be5('0x5e')]&&_[_0x7be5('0x5f')](_0x186dc3[_0x7be5('0x4e')]['tags'])){if(_0x186dc3[_0x7be5('0x4e')][_0x7be5('0x5e')][_0x7be5('0x3b')]){_0x186dc3[_0x7be5('0x4e')][_0x7be5('0x5e')]=_0x186dc3[_0x7be5('0x4e')][_0x7be5('0x5e')][_0x7be5('0x60')](';')+';';}else{_0x186dc3[_0x7be5('0x4e')][_0x7be5('0x5e')]=null;}}else{_0x186dc3['body'][_0x7be5('0x5e')]=null;}if(_0x186dc3[_0x7be5('0x4e')]&&_['isArray'](_0x186dc3[_0x7be5('0x4e')])){for(var _0x1fb457=0x0;_0x1fb457<_0x186dc3[_0x7be5('0x4e')][_0x7be5('0x3b')];_0x1fb457+=0x1){_0x186dc3[_0x7be5('0x4e')][_0x1fb457]['ListId']=_0x186dc3[_0x7be5('0x4b')]['id'];_0x27d7f4[_0x7be5('0x61')](_0x186dc3[_0x7be5('0x4e')][_0x1fb457]);}return BPromise[_0x7be5('0x62')](_0x27d7f4,function(_0x1f7675){return db[_0x7be5('0x5c')][_0x7be5('0x4d')](_['omit'](_0x1f7675,[_0x7be5('0x5a'),'id'])||{},{'fields':_[_0x7be5('0x36')](_0x1a3812),'raw':!![]})['then'](function(_0x15812c){_0x1511c0['success']['push'](_0x15812c[_0x7be5('0x63')]);})[_0x7be5('0x49')](function(_0x173fdf){_0x1511c0[_0x7be5('0x64')]['push']({'data':_0x1f7675,'error':_0x173fdf['message']});});})['then'](function(_0x364a06){return _0x1511c0;})[_0x7be5('0x49')](function(_0x282f1d){return _0x282f1d;});}else{_0x3ef3fb[_0x7be5('0x1c')](0x190)[_0x7be5('0x24')]({'message':_0x7be5('0x65')});}});}})[_0x7be5('0x28')](respondWithResult(_0x3ef3fb,null))[_0x7be5('0x49')](handleError(_0x3ef3fb,null));};exports['getContacts']=function(_0x24b358,_0x536764,_0xea5a6c){var _0x32f3a6;return db[_0x7be5('0x31')]['find']({'where':{'id':_0x24b358['params']['id']},'include':[{'model':db[_0x7be5('0x66')],'as':_0x7be5('0x67')}]})[_0x7be5('0x28')](handleEntityNotFound(_0x536764,null))['then'](function(_0x55cb14){if(_0x55cb14){_0x32f3a6=_0x55cb14;return db[_0x7be5('0x5c')][_0x7be5('0x68')];}})[_0x7be5('0x28')](function(_0x289d83){if(_0x289d83){var _0x3af10a={};var _0x1612d5={};_0x1612d5['model']=_[_0x7be5('0x69')](_[_0x7be5('0x36')](_0x289d83),_[_0x7be5('0x30')](_0x32f3a6['CustomFields'],function(_0x170818){return util['format']('cf_%d',_0x170818['id']);}));_0x1612d5[_0x7be5('0x35')]=_[_0x7be5('0x36')](_0x24b358[_0x7be5('0x35')]);_0x1612d5[_0x7be5('0x37')]=_[_0x7be5('0x39')](_0x1612d5[_0x7be5('0x34')],_0x1612d5[_0x7be5('0x35')]);_0x3af10a[_0x7be5('0x38')]=_['intersection'](_0x1612d5['model'],qs['fields'](_0x24b358[_0x7be5('0x35')][_0x7be5('0x3a')]));_0x3af10a[_0x7be5('0x38')]=_0x3af10a[_0x7be5('0x38')][_0x7be5('0x3b')]?_0x3af10a[_0x7be5('0x38')]:_0x1612d5['model'];if(!_0x24b358[_0x7be5('0x35')][_0x7be5('0x3c')](_0x7be5('0x3d'))){_0x3af10a[_0x7be5('0x20')]=qs['limit'](_0x24b358[_0x7be5('0x35')][_0x7be5('0x20')]);_0x3af10a[_0x7be5('0x1e')]=qs[_0x7be5('0x1e')](_0x24b358[_0x7be5('0x35')][_0x7be5('0x1e')]);}_0x3af10a['order']=qs[_0x7be5('0x3e')](_0x24b358[_0x7be5('0x35')][_0x7be5('0x3e')]);_0x3af10a[_0x7be5('0x41')]=qs[_0x7be5('0x37')](_[_0x7be5('0x3f')](_0x24b358[_0x7be5('0x35')],_0x1612d5[_0x7be5('0x37')]));_0x3af10a[_0x7be5('0x6a')]=!![];if(_0x24b358[_0x7be5('0x35')][_0x7be5('0x40')]){_0x3af10a[_0x7be5('0x41')]=_[_0x7be5('0x43')](_0x3af10a[_0x7be5('0x41')],{'$or':_['map'](_0x3af10a[_0x7be5('0x38')],function(_0x295ff6){var _0x4d44b2={};_0x4d44b2[_0x295ff6]={'$like':'%'+_0x24b358[_0x7be5('0x35')][_0x7be5('0x40')]+'%'};return _0x4d44b2;})});}_0x3af10a=_['merge']({},_0x3af10a,_0x24b358['options']);return _0x32f3a6[_0x7be5('0x6b')](_0x3af10a);}})['then'](respondWithResult(_0x536764,null))['catch'](handleError(_0x536764,null));};exports[_0x7be5('0x6c')]=function(_0x478b34,_0x129f07,_0x16e6fb){var _0x1c17b0;var _0x1089b2;var _0x53fff3;var _0x36db52=_0x478b34[_0x7be5('0x4b')]['id'];csv_results=[];return db[_0x7be5('0x6d')][_0x7be5('0x47')]({'attributes':['id',_0x7be5('0x2e')],'raw':!![],'order':['OrderBy']})['then'](function(_0x5b7603){_0x1c17b0=_0x5b7603;var _0x50e05c=_[_0x7be5('0x36')](db['CmContact'][_0x7be5('0x68')]);return db[_0x7be5('0x66')][_0x7be5('0x47')]({'raw':!![],'attributes':['id','alias']})[_0x7be5('0x28')](function(_0x1f6666){_0x1089b2=_0x1f6666;var _0x555bdc=squel[_0x7be5('0x6e')]()[_0x7be5('0x3a')](_0x50e05c)['from'](_0x7be5('0x6f'),'c')[_0x7be5('0x41')](_0x7be5('0x70'),_0x36db52)[_0x7be5('0x41')](_0x7be5('0x71'))['distinct']();for(var _0x171beb=0x0;_0x171beb<_0x1089b2[_0x7be5('0x3b')];_0x171beb++){_0x555bdc[_0x7be5('0x72')](_0x7be5('0x73')+_0x1089b2[_0x171beb]['id'],_0x7be5('0x74')+_0x1089b2[_0x171beb][_0x7be5('0x75')]);}for(var _0x171beb=0x0;_0x171beb<_0x1c17b0[_0x7be5('0x3b')];_0x171beb++){_0x555bdc[_0x7be5('0x72')](squel[_0x7be5('0x6e')]()[_0x7be5('0x72')](_0x7be5('0x76'))[_0x7be5('0x77')]('cm_contact_has_items')[_0x7be5('0x41')](_0x7be5('0x78'),_0x1c17b0[_0x171beb]['id'])[_0x7be5('0x41')](_0x7be5('0x79')),'additionalPhone_'+_0x1c17b0[_0x171beb][_0x7be5('0x2e')]);_0x555bdc[_0x7be5('0x72')](squel[_0x7be5('0x6e')]()[_0x7be5('0x72')](_0x7be5('0x7a'))['from'](_0x7be5('0x7b'))[_0x7be5('0x41')]('ItemTypeId\x20=\x20?',_0x1c17b0[_0x171beb]['id'])['where'](_0x7be5('0x79')),_0x7be5('0x7c')+_0x1c17b0[_0x171beb][_0x7be5('0x2e')]);}var _0x259b14=[];_0x259b14[_0x7be5('0x61')](_0x555bdc[_0x7be5('0x7d')]());BPromise[_0x7be5('0x62')](_0x259b14,handleQuery)[_0x7be5('0x28')](function(_0x34977a){handleQuery(_0x555bdc[_0x7be5('0x7d')]());var _0x43c656=csv_results[0x0];if(!_['isEmpty'](_0x43c656)){var _0x3dbd3c=toCsv(_0x43c656);var _0x13eab4=Date[_0x7be5('0x7e')]();fs[_0x7be5('0x7f')](util[_0x7be5('0x80')](_0x7be5('0x81'),_0x36db52,_0x13eab4),_0x3dbd3c);_0x129f07[_0x7be5('0x82')](_0x7be5('0x83'),_0x7be5('0x84')+util[_0x7be5('0x80')]('list_%d_%s.csv',_0x36db52,_0x13eab4));_0x129f07[_0x7be5('0x82')](_0x7be5('0x85'),_0x7be5('0x86'));return _0x129f07[_0x7be5('0x87')](util[_0x7be5('0x80')](_0x7be5('0x81'),_0x36db52,_0x13eab4));}else{return _0x129f07[_0x7be5('0x2d')](0xcc);}});});});};exports[_0x7be5('0x88')]=function(_0x133b2c,_0x194bdf,_0x213fe8){var _0x23a88c;delete _0x133b2c[_0x7be5('0x4e')]['id'];return db[_0x7be5('0x31')][_0x7be5('0x58')]({'where':{'id':_0x133b2c[_0x7be5('0x4b')]['id']}})['then'](handleEntityNotFound(_0x194bdf,null))['then'](function(_0x4e821f){if(_0x4e821f){return db[_0x7be5('0x89')][_0x7be5('0x8a')](function(_0x23042d){return db[_0x7be5('0x66')][_0x7be5('0x4d')](_0x133b2c[_0x7be5('0x4e')],{'transaction':_0x23042d})['then'](function(_0x506773){_0x23a88c=_0x506773;return _0x4e821f[_0x7be5('0x8b')](_0x506773,{'transaction':_0x23042d});})[_0x7be5('0x28')](function(){var _0xf2ae99={'type':db['Sequelize'][_0x7be5('0x8c')],'transaction':_0x23042d};switch(_0x133b2c[_0x7be5('0x4e')][_0x7be5('0x33')]){case _0x7be5('0x8d'):_0xf2ae99[_0x7be5('0x33')]=db['Sequelize'][_0x7be5('0x8c')];break;case _0x7be5('0x8e'):_0xf2ae99[_0x7be5('0x33')]=db[_0x7be5('0x8f')][_0x7be5('0x90')];break;case'switch':_0xf2ae99[_0x7be5('0x33')]=db['Sequelize']['BOOLEAN'];_0xf2ae99[_0x7be5('0x91')]=![];break;default:}return db[_0x7be5('0x89')][_0x7be5('0x92')]['addColumn']('cm_contacts',util[_0x7be5('0x80')]('cf_%s',_0x23a88c['id']),_0xf2ae99);})[_0x7be5('0x28')](function(){return _0x23a88c;});});}})[_0x7be5('0x28')](respondWithResult(_0x194bdf,null))[_0x7be5('0x49')](handleError(_0x194bdf,null));};exports[_0x7be5('0x93')]=function(_0x4e4fac,_0x993fca,_0x3be878){var _0x3b6588={};var _0xa0d60a={};var _0x8f7ad3;var _0x5a71fb;return db[_0x7be5('0x31')]['findOne']({'where':{'id':_0x4e4fac[_0x7be5('0x4b')]['id']}})['then'](handleEntityNotFound(_0x993fca,null))[_0x7be5('0x28')](function(_0x16f355){if(_0x16f355){_0x8f7ad3=_0x16f355;_0xa0d60a[_0x7be5('0x34')]=_['keys'](db[_0x7be5('0x66')]['rawAttributes']);_0xa0d60a[_0x7be5('0x35')]=_['keys'](_0x4e4fac['query']);_0xa0d60a[_0x7be5('0x37')]=_[_0x7be5('0x39')](_0xa0d60a[_0x7be5('0x34')],_0xa0d60a[_0x7be5('0x35')]);_0x3b6588[_0x7be5('0x38')]=_[_0x7be5('0x39')](_0xa0d60a['model'],qs[_0x7be5('0x3a')](_0x4e4fac[_0x7be5('0x35')][_0x7be5('0x3a')]));_0x3b6588[_0x7be5('0x38')]=_0x3b6588['attributes'][_0x7be5('0x3b')]?_0x3b6588[_0x7be5('0x38')]:_0xa0d60a['model'];_0x3b6588[_0x7be5('0x59')]=qs[_0x7be5('0x3e')](_0x4e4fac['query'][_0x7be5('0x3e')]);_0x3b6588[_0x7be5('0x41')]=qs[_0x7be5('0x37')](_[_0x7be5('0x3f')](_0x4e4fac[_0x7be5('0x35')],_0xa0d60a[_0x7be5('0x37')]));_0x3b6588[_0x7be5('0x41')]=_[_0x7be5('0x43')](_0x3b6588[_0x7be5('0x41')],{'$or':[{'ListId':_0x16f355['id']},{'ListId':null}]});if(_0x4e4fac[_0x7be5('0x35')][_0x7be5('0x40')]){_0x3b6588['where']=_[_0x7be5('0x43')](_0x3b6588[_0x7be5('0x41')],{'$or':_[_0x7be5('0x30')](_0x3b6588['attributes'],function(_0x14558f){var _0x4631f2={};_0x4631f2[_0x14558f]={'$like':'%'+_0x4e4fac[_0x7be5('0x35')][_0x7be5('0x40')]+'%'};return _0x4631f2;})});}_0x3b6588=_[_0x7be5('0x43')]({},_0x3b6588,_0x4e4fac['options']);return db[_0x7be5('0x66')][_0x7be5('0x94')](_0x3b6588);}})[_0x7be5('0x28')](respondWithResult(_0x993fca,null))['catch'](handleError(_0x993fca,null));};exports[_0x7be5('0x95')]=function(_0x22e5d6,_0x1e0128){return db[_0x7be5('0x66')]['findAndCountAll']({'where':{'ListId':null}})[_0x7be5('0x28')](handleEntityNotFound(_0x1e0128,null))[_0x7be5('0x28')](function(_0x39c330){return _0x39c330;})[_0x7be5('0x28')](respondWithResult(_0x1e0128,null))[_0x7be5('0x49')](handleError(_0x1e0128,null));};exports[_0x7be5('0x96')]=function(_0x2262e2,_0x14625d,_0x163dca){return db[_0x7be5('0x31')]['find']({'where':{'id':_0x2262e2['params']['id']}})[_0x7be5('0x28')](handleEntityNotFound(_0x14625d,null))[_0x7be5('0x28')](function(_0x2b90b0){if(_0x2b90b0){return _0x2b90b0[_0x7be5('0x96')](_0x2262e2[_0x7be5('0x4e')][_0x7be5('0x5a')],_[_0x7be5('0x97')](_0x2262e2[_0x7be5('0x4e')],[_0x7be5('0x5a'),'id'])||{})[_0x7be5('0x98')](function(_0x2f8250){for(var _0x25607c=0x0;_0x25607c<_0x2262e2[_0x7be5('0x4e')][_0x7be5('0x5a')][_0x7be5('0x3b')];_0x25607c+=0x1){socket[_0x7be5('0x99')](_0x7be5('0x9a'),{'UserId':Number(_0x2262e2[_0x7be5('0x4e')][_0x7be5('0x5a')][_0x25607c]),'CmListId':Number(_0x2262e2[_0x7be5('0x4b')]['id'])});}return _0x2f8250;});}})[_0x7be5('0x28')](respondWithResult(_0x14625d,null))[_0x7be5('0x49')](handleError(_0x14625d,null));};exports[_0x7be5('0x9b')]=function(_0x3a6243,_0x19e84f,_0x127de3){return db['CmList']['find']({'where':{'id':_0x3a6243[_0x7be5('0x4b')]['id']}})[_0x7be5('0x28')](handleEntityNotFound(_0x19e84f,null))[_0x7be5('0x28')](function(_0x47a31c){if(_0x47a31c){return _0x47a31c['removeAgents'](_0x3a6243[_0x7be5('0x35')]['ids'])[_0x7be5('0x28')](function(){if(_[_0x7be5('0x5f')](_0x3a6243['query'][_0x7be5('0x5a')])){for(var _0x4e02da=0x0;_0x4e02da<_0x3a6243[_0x7be5('0x35')]['ids'][_0x7be5('0x3b')];_0x4e02da+=0x1){socket[_0x7be5('0x99')](_0x7be5('0x9c'),{'UserId':Number(_0x3a6243[_0x7be5('0x35')]['ids'][_0x4e02da]),'CmListId':Number(_0x3a6243[_0x7be5('0x4b')]['id'])});}}else{socket[_0x7be5('0x99')](_0x7be5('0x9c'),{'UserId':Number(_0x3a6243['query'][_0x7be5('0x5a')]),'CmListId':Number(_0x3a6243[_0x7be5('0x4b')]['id'])});}});}})[_0x7be5('0x28')](respondWithStatusCode(_0x19e84f,null))[_0x7be5('0x49')](handleError(_0x19e84f,null));};exports[_0x7be5('0x9d')]=function(_0x353791,_0x17792c,_0x19b639){var _0x2059a7={};var _0x5ed163={};var _0x15a1fb;var _0x580f9a;return db[_0x7be5('0x31')][_0x7be5('0x58')]({'where':{'id':_0x353791['params']['id']}})[_0x7be5('0x28')](handleEntityNotFound(_0x17792c,null))[_0x7be5('0x28')](function(_0x5808ff){if(_0x5808ff){_0x15a1fb=_0x5808ff;_0x5ed163['model']=_[_0x7be5('0x36')](db[_0x7be5('0x9e')][_0x7be5('0x68')]);_0x5ed163['query']=_[_0x7be5('0x36')](_0x353791['query']);_0x5ed163['filters']=_[_0x7be5('0x39')](_0x5ed163[_0x7be5('0x34')],_0x5ed163[_0x7be5('0x35')]);_0x2059a7[_0x7be5('0x38')]=_['intersection'](_0x5ed163[_0x7be5('0x34')],qs['fields'](_0x353791[_0x7be5('0x35')][_0x7be5('0x3a')]));_0x2059a7[_0x7be5('0x38')]=_0x2059a7['attributes'][_0x7be5('0x3b')]?_0x2059a7[_0x7be5('0x38')]:_0x5ed163[_0x7be5('0x34')];_0x2059a7[_0x7be5('0x59')]=qs['sort'](_0x353791['query']['sort']);_0x2059a7[_0x7be5('0x41')]=qs[_0x7be5('0x37')](_['pick'](_0x353791['query'],_0x5ed163[_0x7be5('0x37')]));if(_0x353791['query'][_0x7be5('0x40')]){_0x2059a7[_0x7be5('0x41')]=_[_0x7be5('0x43')](_0x2059a7[_0x7be5('0x41')],{'$or':_[_0x7be5('0x30')](_0x2059a7['attributes'],function(_0x2f253e){var _0x61ad4d={};_0x61ad4d[_0x2f253e]={'$like':'%'+_0x353791[_0x7be5('0x35')][_0x7be5('0x40')]+'%'};return _0x61ad4d;})});}_0x2059a7=_['merge']({},_0x2059a7,_0x353791['options']);return _0x15a1fb['getAgents'](_0x2059a7);}})[_0x7be5('0x28')](function(_0x9a439c){if(_0x9a439c){_0x580f9a=_0x9a439c[_0x7be5('0x3b')];if(!_0x353791[_0x7be5('0x35')]['hasOwnProperty'](_0x7be5('0x3d'))){_0x2059a7['limit']=qs['limit'](_0x353791['query'][_0x7be5('0x20')]);_0x2059a7[_0x7be5('0x1e')]=qs[_0x7be5('0x1e')](_0x353791[_0x7be5('0x35')][_0x7be5('0x1e')]);}return _0x15a1fb[_0x7be5('0x9d')](_0x2059a7);}})[_0x7be5('0x28')](function(_0x1867a1){if(_0x1867a1){return _0x1867a1?{'count':_0x580f9a,'rows':_0x1867a1}:null;}})[_0x7be5('0x28')](respondWithResult(_0x17792c,null))['catch'](handleError(_0x17792c,null));};function handleQuery(_0x36f0f5){logger[_0x7be5('0x9f')](_0x36f0f5);return db[_0x7be5('0x89')]['query'](_0x36f0f5)[_0x7be5('0x98')](function(_0x22f87e){csv_results[_0x7be5('0x61')](_0x22f87e);})[_0x7be5('0x49')](function(_0x4f56bd){logger['error'](_0x4f56bd[_0x7be5('0xa0')]);});}