Built motion from commit da617fac.|2.6.6
[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 _0x32bf=['describe','addDisposition','params','ListId','Disposition','findOne','nolimit','filter','findAll','rows','removeDispositions','addContacts','CmContact','tags','isArray','join','push','each','ids','success','dataValues','errors','message','Malformed\x20request\x20syntax','getContacts','CmCustomField','concat','CustomFields','format','cf_%d','raw','getContactsCsv','ContactItemType','OrderBy','alias','select','from','cm_contacts','c.ListId\x20=\x20?','c.deletedAt\x20is\x20null','distinct','field','c.cf_','customField_','item','cm_contact_has_items','ItemTypeId\x20=\x20?','additionalPhone_','description','CmContactId\x20=\x20c.id','toString','isEmpty','now','writeFileSync','/tmp/list_%d_%s.csv','Content-disposition','attachment;\x20filename=','list_%d_%s.csv','setHeader','Content-type','text/csv','sequelize','transaction','addCustomFields','Sequelize','TEXT','number','INTEGER','switch','queryInterface','addColumn','cf_%s','getCustomFields','findAndCountAll','getGlobalCustomFields','addAgents','omit','spread','emit','userCmList:save','removeAgents','userCmList:remove','getAgents','User','info','eml-format','rimraf','fast-json-patch','moment','mustache','util','path','to-csv','ejs','lodash','jsforce','papaparse','../../components/auth/service','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','redis','defaults','localhost','socket.io-emitter','./cmList.socket','register','sendStatus','status','end','json','offset','undefined','limit','count','Content-Range','reject','save','update','then','destroy','get','error','stack','name','index','map','CmList','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','hasOwnProperty','order','sort','where','pick','merge','VIRTUAL','includeAll','include','show','length','options','find','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Lists','UserProfileSection','userProfileId','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s'];(function(_0x36eaaa,_0x326732){var _0x461349=function(_0x4e4180){while(--_0x4e4180){_0x36eaaa['push'](_0x36eaaa['shift']());}};_0x461349(++_0x326732);}(_0x32bf,0xf9));var _0xf32b=function(_0x23f2be,_0x21e788){_0x23f2be=_0x23f2be-0x0;var _0x5eea88=_0x32bf[_0x23f2be];return _0x5eea88;};'use strict';var emlformat=require(_0xf32b('0x0'));var rimraf=require(_0xf32b('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xf32b('0x2'));var rp=require('request-promise');var moment=require(_0xf32b('0x3'));var BPromise=require('bluebird');var Mustache=require(_0xf32b('0x4'));var util=require(_0xf32b('0x5'));var path=require(_0xf32b('0x6'));var sox=require('sox');var csv=require(_0xf32b('0x7'));var ejs=require(_0xf32b('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xf32b('0x9'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xf32b('0xa'));var deskjs=require('desk.js');var toCsv=require(_0xf32b('0x7'));var querystring=require('querystring');var Papa=require(_0xf32b('0xb'));var Redis=require('ioredis');var authService=require(_0xf32b('0xc'));var qs=require('../../components/parsers/qs');var as=require(_0xf32b('0xd'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xf32b('0xe'))(_0xf32b('0xf'));var utils=require(_0xf32b('0x10'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];var csv_results;config[_0xf32b('0x11')]=_[_0xf32b('0x12')](config[_0xf32b('0x11')],{'host':_0xf32b('0x13'),'port':0x18eb});var socket=require(_0xf32b('0x14'))(new Redis(config[_0xf32b('0x11')]));require(_0xf32b('0x15'))[_0xf32b('0x16')](socket);function respondWithStatusCode(_0x2940b4,_0x47cc47){_0x47cc47=_0x47cc47||0xcc;return function(_0xc43765){if(_0xc43765){return _0x2940b4[_0xf32b('0x17')](_0x47cc47);}return _0x2940b4[_0xf32b('0x18')](_0x47cc47)[_0xf32b('0x19')]();};}function respondWithResult(_0x231560,_0x4c3356){_0x4c3356=_0x4c3356||0xc8;return function(_0x347feb){if(_0x347feb){return _0x231560['status'](_0x4c3356)[_0xf32b('0x1a')](_0x347feb);}};}function respondWithFilteredResult(_0x1fbf7e,_0x54266f){return function(_0x148639){if(_0x148639){var _0x2ab137=typeof _0x54266f[_0xf32b('0x1b')]===_0xf32b('0x1c')&&typeof _0x54266f[_0xf32b('0x1d')]===_0xf32b('0x1c');var _0x27cc12=_0x148639[_0xf32b('0x1e')];var _0x46f045=_0x2ab137?0x0:_0x54266f[_0xf32b('0x1b')];var _0x2c0f4e=_0x2ab137?_0x148639[_0xf32b('0x1e')]:_0x54266f['offset']+_0x54266f['limit'];var _0x4f3040;if(_0x2c0f4e>=_0x27cc12){_0x2c0f4e=_0x27cc12;_0x4f3040=0xc8;}else{_0x4f3040=0xce;}_0x1fbf7e[_0xf32b('0x18')](_0x4f3040);return _0x1fbf7e['set'](_0xf32b('0x1f'),_0x46f045+'-'+_0x2c0f4e+'/'+_0x27cc12)[_0xf32b('0x1a')](_0x148639);}return null;};}function patchUpdates(_0x4c7982){return function(_0x58a0ae){try{jsonpatch['apply'](_0x58a0ae,_0x4c7982,!![]);}catch(_0x44a51b){return BPromise[_0xf32b('0x20')](_0x44a51b);}return _0x58a0ae[_0xf32b('0x21')]();};}function saveUpdates(_0x1e943f,_0x9744ff){return function(_0x5a4886){if(_0x5a4886){return _0x5a4886[_0xf32b('0x22')](_0x1e943f)[_0xf32b('0x23')](function(_0x6ce394){return _0x6ce394;});}return null;};}function removeEntity(_0x197d83,_0x42dc8f){return function(_0x3540b5){if(_0x3540b5){return _0x3540b5[_0xf32b('0x24')]()['then'](function(){var _0x8a2e13=_0x3540b5[_0xf32b('0x25')]({'plain':!![]});var _0xad781b='Lists';return db['UserProfileResource'][_0xf32b('0x24')]({'where':{'type':_0xad781b,'resourceId':_0x8a2e13['id']}})[_0xf32b('0x23')](function(){return _0x3540b5;});})[_0xf32b('0x23')](function(){_0x197d83['status'](0xcc)[_0xf32b('0x19')]();});}};}function handleEntityNotFound(_0x481615,_0x57df47){return function(_0x21d8f8){if(!_0x21d8f8){_0x481615[_0xf32b('0x17')](0x194);}return _0x21d8f8;};}function handleError(_0x508257,_0x1d82f3){_0x1d82f3=_0x1d82f3||0x1f4;return function(_0x307852){logger[_0xf32b('0x26')](_0x307852[_0xf32b('0x27')]);if(_0x307852[_0xf32b('0x28')]){delete _0x307852[_0xf32b('0x28')];}_0x508257[_0xf32b('0x18')](_0x1d82f3)['send'](_0x307852);};}exports[_0xf32b('0x29')]=function(_0x5519ef,_0x432727){var _0x1454db={},_0x39132d={},_0x10578c={'count':0x0,'rows':[]};var _0x11f7ab=_[_0xf32b('0x2a')](db[_0xf32b('0x2b')][_0xf32b('0x2c')],function(_0x41c0cf){return{'name':_0x41c0cf[_0xf32b('0x2d')],'type':_0x41c0cf[_0xf32b('0x2e')][_0xf32b('0x2f')]};});_0x39132d[_0xf32b('0x30')]=_[_0xf32b('0x2a')](_0x11f7ab,'name');_0x39132d[_0xf32b('0x31')]=_[_0xf32b('0x32')](_0x5519ef['query']);_0x39132d[_0xf32b('0x33')]=_[_0xf32b('0x34')](_0x39132d[_0xf32b('0x30')],_0x39132d['query']);_0x1454db[_0xf32b('0x35')]=_[_0xf32b('0x34')](_0x39132d[_0xf32b('0x30')],qs[_0xf32b('0x36')](_0x5519ef['query'][_0xf32b('0x36')]));_0x1454db[_0xf32b('0x35')]=_0x1454db[_0xf32b('0x35')]['length']?_0x1454db['attributes']:_0x39132d['model'];if(!_0x5519ef[_0xf32b('0x31')][_0xf32b('0x37')]('nolimit')){_0x1454db[_0xf32b('0x1d')]=qs[_0xf32b('0x1d')](_0x5519ef[_0xf32b('0x31')][_0xf32b('0x1d')]);_0x1454db[_0xf32b('0x1b')]=qs['offset'](_0x5519ef[_0xf32b('0x31')][_0xf32b('0x1b')]);}_0x1454db[_0xf32b('0x38')]=qs[_0xf32b('0x39')](_0x5519ef[_0xf32b('0x31')][_0xf32b('0x39')]);_0x1454db[_0xf32b('0x3a')]=qs[_0xf32b('0x33')](_[_0xf32b('0x3b')](_0x5519ef[_0xf32b('0x31')],_0x39132d['filters']),_0x11f7ab);if(_0x5519ef[_0xf32b('0x31')]['filter']){_0x1454db[_0xf32b('0x3a')]=_[_0xf32b('0x3c')](_0x1454db['where'],{'$or':_[_0xf32b('0x2a')](_0x11f7ab,function(_0x1944cd){if(_0x1944cd['type']!==_0xf32b('0x3d')){var _0x33434e={};_0x33434e[_0x1944cd[_0xf32b('0x28')]]={'$like':'%'+_0x5519ef[_0xf32b('0x31')]['filter']+'%'};return _0x33434e;}})});}_0x1454db=_['merge']({},_0x1454db,_0x5519ef['options']);var _0x4334dd={'where':_0x1454db[_0xf32b('0x3a')]};return db['CmList'][_0xf32b('0x1e')](_0x4334dd)[_0xf32b('0x23')](function(_0x7bda7c){_0x10578c[_0xf32b('0x1e')]=_0x7bda7c;if(_0x5519ef[_0xf32b('0x31')][_0xf32b('0x3e')]){_0x1454db[_0xf32b('0x3f')]=[{'all':!![]}];}return db[_0xf32b('0x2b')]['findAll'](_0x1454db);})[_0xf32b('0x23')](function(_0x3ffd66){_0x10578c['rows']=_0x3ffd66;return _0x10578c;})[_0xf32b('0x23')](respondWithFilteredResult(_0x432727,_0x1454db))['catch'](handleError(_0x432727,null));};exports[_0xf32b('0x40')]=function(_0x2dfda7,_0x3df429){var _0x49ed45={'raw':![],'where':{'id':_0x2dfda7['params']['id']}},_0x3968ba={};_0x3968ba['model']=_[_0xf32b('0x32')](db['CmList']['rawAttributes']);_0x3968ba['query']=_[_0xf32b('0x32')](_0x2dfda7[_0xf32b('0x31')]);_0x3968ba[_0xf32b('0x33')]=_['intersection'](_0x3968ba[_0xf32b('0x30')],_0x3968ba[_0xf32b('0x31')]);_0x49ed45[_0xf32b('0x35')]=_['intersection'](_0x3968ba[_0xf32b('0x30')],qs[_0xf32b('0x36')](_0x2dfda7[_0xf32b('0x31')]['fields']));_0x49ed45[_0xf32b('0x35')]=_0x49ed45[_0xf32b('0x35')][_0xf32b('0x41')]?_0x49ed45[_0xf32b('0x35')]:_0x3968ba[_0xf32b('0x30')];if(_0x2dfda7[_0xf32b('0x31')]['includeAll']){_0x49ed45[_0xf32b('0x3f')]=[{'all':!![]}];}_0x49ed45=_['merge']({},_0x49ed45,_0x2dfda7[_0xf32b('0x42')]);return db[_0xf32b('0x2b')][_0xf32b('0x43')](_0x49ed45)[_0xf32b('0x23')](handleEntityNotFound(_0x3df429,null))[_0xf32b('0x23')](respondWithResult(_0x3df429,null))[_0xf32b('0x44')](handleError(_0x3df429,null));};exports[_0xf32b('0x45')]=function(_0x46bce9,_0x2a4b9c){return db[_0xf32b('0x2b')][_0xf32b('0x45')](_0x46bce9[_0xf32b('0x46')],{})[_0xf32b('0x23')](function(_0x577b3f){var _0x30c58a=_0x46bce9[_0xf32b('0x47')][_0xf32b('0x25')]({'plain':!![]});if(!_0x30c58a)throw new Error(_0xf32b('0x48'));if(_0x30c58a[_0xf32b('0x49')]===_0xf32b('0x47')){var _0x53edd7=_0x577b3f['get']({'plain':!![]});var _0x4851c0=_0xf32b('0x4a');return db[_0xf32b('0x4b')][_0xf32b('0x43')]({'where':{'name':_0x4851c0,'userProfileId':_0x30c58a[_0xf32b('0x4c')]},'raw':!![]})['then'](function(_0x2044a1){if(_0x2044a1&&_0x2044a1['autoAssociation']===0x0){return db[_0xf32b('0x4d')][_0xf32b('0x45')]({'name':_0x53edd7[_0xf32b('0x28')],'resourceId':_0x53edd7['id'],'type':_0x2044a1['name'],'sectionId':_0x2044a1['id']},{})[_0xf32b('0x23')](function(){return _0x577b3f;});}else{return _0x577b3f;}})[_0xf32b('0x44')](function(_0xac69b6){logger[_0xf32b('0x26')](_0xf32b('0x4e'),_0xac69b6);throw _0xac69b6;});}return _0x577b3f;})[_0xf32b('0x23')](respondWithResult(_0x2a4b9c,0xc9))['catch'](handleError(_0x2a4b9c,null));};exports['update']=function(_0x59ac1b,_0x37d567){if(_0x59ac1b[_0xf32b('0x46')]['id']){delete _0x59ac1b[_0xf32b('0x46')]['id'];}return db[_0xf32b('0x2b')][_0xf32b('0x43')]({'where':{'id':_0x59ac1b['params']['id']}})[_0xf32b('0x23')](handleEntityNotFound(_0x37d567,null))[_0xf32b('0x23')](saveUpdates(_0x59ac1b[_0xf32b('0x46')],null))[_0xf32b('0x23')](respondWithResult(_0x37d567,null))[_0xf32b('0x44')](handleError(_0x37d567,null));};exports[_0xf32b('0x24')]=function(_0x58048e,_0x51460c){return db[_0xf32b('0x2b')][_0xf32b('0x43')]({'where':{'id':_0x58048e['params']['id']}})[_0xf32b('0x23')](handleEntityNotFound(_0x51460c,null))[_0xf32b('0x23')](removeEntity(_0x51460c,null))[_0xf32b('0x44')](handleError(_0x51460c,null));};exports[_0xf32b('0x4f')]=function(_0x5b428e,_0x211c21){return db[_0xf32b('0x2b')][_0xf32b('0x4f')]()[_0xf32b('0x23')](respondWithResult(_0x211c21,null))[_0xf32b('0x44')](handleError(_0x211c21,null));};exports[_0xf32b('0x50')]=function(_0x3c6102,_0x58c372,_0x247385){if(_0x3c6102['body']['id']){delete _0x3c6102['body']['id'];}return db[_0xf32b('0x2b')][_0xf32b('0x43')]({'where':{'id':_0x3c6102[_0xf32b('0x51')]['id']}})[_0xf32b('0x23')](handleEntityNotFound(_0x58c372,null))[_0xf32b('0x23')](function(_0x499e8a){if(_0x499e8a){_0x3c6102[_0xf32b('0x46')][_0xf32b('0x52')]=_0x499e8a['id'];return db[_0xf32b('0x53')][_0xf32b('0x45')](_0x3c6102[_0xf32b('0x46')]);}})[_0xf32b('0x23')](respondWithResult(_0x58c372,null))[_0xf32b('0x44')](handleError(_0x58c372,null));};exports['getDispositions']=function(_0x2e8c32,_0x122ac7,_0x3321bc){var _0x550ac3={'raw':![],'where':{}};var _0x16302f={};var _0x452beb={'count':0x0,'rows':[]};return db[_0xf32b('0x2b')][_0xf32b('0x54')]({'where':{'id':_0x2e8c32[_0xf32b('0x51')]['id']}})['then'](handleEntityNotFound(_0x122ac7,null))['then'](function(_0x36992e){if(_0x36992e){_0x16302f[_0xf32b('0x30')]=_[_0xf32b('0x32')](db[_0xf32b('0x53')][_0xf32b('0x2c')]);_0x16302f[_0xf32b('0x31')]=_[_0xf32b('0x32')](_0x2e8c32[_0xf32b('0x31')]);_0x16302f[_0xf32b('0x33')]=_[_0xf32b('0x34')](_0x16302f[_0xf32b('0x30')],_0x16302f[_0xf32b('0x31')]);_0x550ac3[_0xf32b('0x35')]=_[_0xf32b('0x34')](_0x16302f['model'],qs[_0xf32b('0x36')](_0x2e8c32[_0xf32b('0x31')]['fields']));_0x550ac3[_0xf32b('0x35')]=_0x550ac3[_0xf32b('0x35')][_0xf32b('0x41')]?_0x550ac3[_0xf32b('0x35')]:_0x16302f[_0xf32b('0x30')];if(!_0x2e8c32['query'][_0xf32b('0x37')](_0xf32b('0x55'))){_0x550ac3[_0xf32b('0x1d')]=qs[_0xf32b('0x1d')](_0x2e8c32[_0xf32b('0x31')][_0xf32b('0x1d')]);_0x550ac3['offset']=qs[_0xf32b('0x1b')](_0x2e8c32[_0xf32b('0x31')][_0xf32b('0x1b')]);}_0x550ac3[_0xf32b('0x38')]=qs['sort'](_0x2e8c32[_0xf32b('0x31')]['sort']);_0x550ac3['where']=qs[_0xf32b('0x33')](_[_0xf32b('0x3b')](_0x2e8c32['query'],_0x16302f[_0xf32b('0x33')]));_0x550ac3[_0xf32b('0x3a')][_0xf32b('0x52')]=_0x36992e['id'];if(_0x2e8c32[_0xf32b('0x31')][_0xf32b('0x56')]){_0x550ac3[_0xf32b('0x3a')]=_[_0xf32b('0x3c')](_0x550ac3[_0xf32b('0x3a')],{'$or':_[_0xf32b('0x2a')](_0x550ac3[_0xf32b('0x35')],function(_0x14a770){var _0x38abf5={};_0x38abf5[_0x14a770]={'$like':'%'+_0x2e8c32[_0xf32b('0x31')][_0xf32b('0x56')]+'%'};return _0x38abf5;})});}_0x550ac3=_[_0xf32b('0x3c')]({},_0x550ac3,_0x2e8c32[_0xf32b('0x42')]);return db[_0xf32b('0x53')][_0xf32b('0x1e')]({'where':_0x550ac3[_0xf32b('0x3a')]})[_0xf32b('0x23')](function(_0x2b3394){_0x452beb['count']=_0x2b3394;if(_0x2e8c32[_0xf32b('0x31')][_0xf32b('0x3e')]){_0x550ac3['include']=[{'all':!![]}];}return db[_0xf32b('0x53')][_0xf32b('0x57')](_0x550ac3);})[_0xf32b('0x23')](function(_0x219278){_0x452beb[_0xf32b('0x58')]=_0x219278;return _0x452beb;});}})[_0xf32b('0x23')](respondWithFilteredResult(_0x122ac7,_0x550ac3))['catch'](handleError(_0x122ac7,null));};exports[_0xf32b('0x59')]=function(_0x367007,_0xc7834e,_0x29592a){return db[_0xf32b('0x2b')][_0xf32b('0x43')]({'where':{'id':_0x367007[_0xf32b('0x51')]['id']}})['then'](handleEntityNotFound(_0xc7834e,null))[_0xf32b('0x23')](function(_0x5b8cf2){if(_0x5b8cf2){return _0x5b8cf2[_0xf32b('0x59')](_0x367007[_0xf32b('0x31')]['ids']);}})[_0xf32b('0x23')](respondWithStatusCode(_0xc7834e,null))[_0xf32b('0x44')](handleError(_0xc7834e,null));};exports[_0xf32b('0x5a')]=function(_0x5762b1,_0x44ba1b,_0x5960aa){return db[_0xf32b('0x2b')][_0xf32b('0x43')]({'where':{'id':_0x5762b1[_0xf32b('0x51')]['id']}})[_0xf32b('0x23')](handleEntityNotFound(_0x44ba1b,null))[_0xf32b('0x23')](function(_0x7c015b){if(_0x7c015b){var _0x4e1d29=[];var _0x250a46={'success':[],'errors':[]};return db[_0xf32b('0x5b')][_0xf32b('0x4f')]()[_0xf32b('0x23')](function(_0x15dbaa){if(_0x5762b1[_0xf32b('0x46')][_0xf32b('0x5c')]&&_[_0xf32b('0x5d')](_0x5762b1[_0xf32b('0x46')][_0xf32b('0x5c')])){if(_0x5762b1[_0xf32b('0x46')]['tags'][_0xf32b('0x41')]){_0x5762b1['body'][_0xf32b('0x5c')]=_0x5762b1['body'][_0xf32b('0x5c')][_0xf32b('0x5e')](';')+';';}else{_0x5762b1[_0xf32b('0x46')][_0xf32b('0x5c')]=null;}}else{_0x5762b1[_0xf32b('0x46')][_0xf32b('0x5c')]=null;}if(_0x5762b1['body']&&_['isArray'](_0x5762b1[_0xf32b('0x46')])){for(var _0x341d40=0x0;_0x341d40<_0x5762b1['body'][_0xf32b('0x41')];_0x341d40+=0x1){_0x5762b1['body'][_0x341d40]['ListId']=_0x5762b1[_0xf32b('0x51')]['id'];_0x4e1d29[_0xf32b('0x5f')](_0x5762b1['body'][_0x341d40]);}return BPromise[_0xf32b('0x60')](_0x4e1d29,function(_0x40216e){return db[_0xf32b('0x5b')][_0xf32b('0x45')](_['omit'](_0x40216e,[_0xf32b('0x61'),'id'])||{},{'fields':_[_0xf32b('0x32')](_0x15dbaa),'raw':!![]})[_0xf32b('0x23')](function(_0x15a608){_0x250a46[_0xf32b('0x62')]['push'](_0x15a608[_0xf32b('0x63')]);})[_0xf32b('0x44')](function(_0x4926a3){_0x250a46[_0xf32b('0x64')][_0xf32b('0x5f')]({'data':_0x40216e,'error':_0x4926a3[_0xf32b('0x65')]});});})[_0xf32b('0x23')](function(_0x2e2b0c){return _0x250a46;})['catch'](function(_0x1a6bd1){return _0x1a6bd1;});}else{_0x44ba1b[_0xf32b('0x18')](0x190)[_0xf32b('0x1a')]({'message':_0xf32b('0x66')});}});}})['then'](respondWithResult(_0x44ba1b,null))[_0xf32b('0x44')](handleError(_0x44ba1b,null));};exports[_0xf32b('0x67')]=function(_0x2ca96d,_0x3dc2a5,_0x4aa3af){var _0x129e0f;return db[_0xf32b('0x2b')]['find']({'where':{'id':_0x2ca96d[_0xf32b('0x51')]['id']},'include':[{'model':db[_0xf32b('0x68')],'as':'CustomFields'}]})[_0xf32b('0x23')](handleEntityNotFound(_0x3dc2a5,null))[_0xf32b('0x23')](function(_0x1f679c){if(_0x1f679c){_0x129e0f=_0x1f679c;return db[_0xf32b('0x5b')][_0xf32b('0x2c')];}})['then'](function(_0xe3615f){if(_0xe3615f){var _0x26a3b8={};var _0x177883={};_0x177883[_0xf32b('0x30')]=_[_0xf32b('0x69')](_[_0xf32b('0x32')](_0xe3615f),_['map'](_0x129e0f[_0xf32b('0x6a')],function(_0x503fb6){return util[_0xf32b('0x6b')](_0xf32b('0x6c'),_0x503fb6['id']);}));_0x177883[_0xf32b('0x31')]=_[_0xf32b('0x32')](_0x2ca96d[_0xf32b('0x31')]);_0x177883['filters']=_[_0xf32b('0x34')](_0x177883[_0xf32b('0x30')],_0x177883[_0xf32b('0x31')]);_0x26a3b8[_0xf32b('0x35')]=_[_0xf32b('0x34')](_0x177883['model'],qs[_0xf32b('0x36')](_0x2ca96d[_0xf32b('0x31')]['fields']));_0x26a3b8[_0xf32b('0x35')]=_0x26a3b8[_0xf32b('0x35')]['length']?_0x26a3b8[_0xf32b('0x35')]:_0x177883[_0xf32b('0x30')];if(!_0x2ca96d['query'][_0xf32b('0x37')](_0xf32b('0x55'))){_0x26a3b8['limit']=qs[_0xf32b('0x1d')](_0x2ca96d['query'][_0xf32b('0x1d')]);_0x26a3b8[_0xf32b('0x1b')]=qs[_0xf32b('0x1b')](_0x2ca96d[_0xf32b('0x31')][_0xf32b('0x1b')]);}_0x26a3b8[_0xf32b('0x38')]=qs['sort'](_0x2ca96d[_0xf32b('0x31')][_0xf32b('0x39')]);_0x26a3b8['where']=qs['filters'](_[_0xf32b('0x3b')](_0x2ca96d[_0xf32b('0x31')],_0x177883['filters']));_0x26a3b8[_0xf32b('0x6d')]=!![];if(_0x2ca96d[_0xf32b('0x31')][_0xf32b('0x56')]){_0x26a3b8[_0xf32b('0x3a')]=_['merge'](_0x26a3b8['where'],{'$or':_['map'](_0x26a3b8[_0xf32b('0x35')],function(_0x3e8230){var _0x30021b={};_0x30021b[_0x3e8230]={'$like':'%'+_0x2ca96d['query']['filter']+'%'};return _0x30021b;})});}_0x26a3b8=_['merge']({},_0x26a3b8,_0x2ca96d[_0xf32b('0x42')]);return _0x129e0f[_0xf32b('0x67')](_0x26a3b8);}})[_0xf32b('0x23')](respondWithResult(_0x3dc2a5,null))[_0xf32b('0x44')](handleError(_0x3dc2a5,null));};exports[_0xf32b('0x6e')]=function(_0x1c657e,_0x172d4a,_0x346d96){var _0x181b08;var _0x48c461;var _0x421c35;var _0x5994a5=_0x1c657e[_0xf32b('0x51')]['id'];csv_results=[];return db[_0xf32b('0x6f')][_0xf32b('0x57')]({'attributes':['id',_0xf32b('0x28')],'raw':!![],'order':[_0xf32b('0x70')]})[_0xf32b('0x23')](function(_0x344a3d){_0x181b08=_0x344a3d;var _0x41d116=_[_0xf32b('0x32')](db[_0xf32b('0x5b')]['rawAttributes']);return db[_0xf32b('0x68')][_0xf32b('0x57')]({'raw':!![],'attributes':['id',_0xf32b('0x71')]})[_0xf32b('0x23')](function(_0x379e4e){_0x48c461=_0x379e4e;var _0x40e949=squel[_0xf32b('0x72')]()['fields'](_0x41d116)[_0xf32b('0x73')](_0xf32b('0x74'),'c')[_0xf32b('0x3a')](_0xf32b('0x75'),_0x5994a5)[_0xf32b('0x3a')](_0xf32b('0x76'))[_0xf32b('0x77')]();for(var _0x4f678d=0x0;_0x4f678d<_0x48c461[_0xf32b('0x41')];_0x4f678d++){_0x40e949[_0xf32b('0x78')](_0xf32b('0x79')+_0x48c461[_0x4f678d]['id'],_0xf32b('0x7a')+_0x48c461[_0x4f678d][_0xf32b('0x71')]);}for(var _0x4f678d=0x0;_0x4f678d<_0x181b08[_0xf32b('0x41')];_0x4f678d++){_0x40e949['field'](squel[_0xf32b('0x72')]()[_0xf32b('0x78')](_0xf32b('0x7b'))[_0xf32b('0x73')](_0xf32b('0x7c'))['where'](_0xf32b('0x7d'),_0x181b08[_0x4f678d]['id'])[_0xf32b('0x3a')]('CmContactId\x20=\x20c.id'),_0xf32b('0x7e')+_0x181b08[_0x4f678d][_0xf32b('0x28')]);_0x40e949[_0xf32b('0x78')](squel[_0xf32b('0x72')]()[_0xf32b('0x78')](_0xf32b('0x7f'))[_0xf32b('0x73')](_0xf32b('0x7c'))['where']('ItemTypeId\x20=\x20?',_0x181b08[_0x4f678d]['id'])[_0xf32b('0x3a')](_0xf32b('0x80')),'description_additionalPhone_'+_0x181b08[_0x4f678d]['name']);}var _0x5d5066=[];_0x5d5066[_0xf32b('0x5f')](_0x40e949[_0xf32b('0x81')]());BPromise[_0xf32b('0x60')](_0x5d5066,handleQuery)[_0xf32b('0x23')](function(_0x4e453a){handleQuery(_0x40e949[_0xf32b('0x81')]());var _0x237242=csv_results[0x0];if(!_[_0xf32b('0x82')](_0x237242)){var _0x5182c8=toCsv(_0x237242);var _0x41b48e=Date[_0xf32b('0x83')]();fs[_0xf32b('0x84')](util[_0xf32b('0x6b')](_0xf32b('0x85'),_0x5994a5,_0x41b48e),_0x5182c8);_0x172d4a['setHeader'](_0xf32b('0x86'),_0xf32b('0x87')+util[_0xf32b('0x6b')](_0xf32b('0x88'),_0x5994a5,_0x41b48e));_0x172d4a[_0xf32b('0x89')](_0xf32b('0x8a'),_0xf32b('0x8b'));return _0x172d4a['download'](util[_0xf32b('0x6b')](_0xf32b('0x85'),_0x5994a5,_0x41b48e));}else{return _0x172d4a[_0xf32b('0x17')](0xcc);}});});});};exports['addCustomField']=function(_0x999d6d,_0x2f089e,_0x11bb73){var _0x131fb9;delete _0x999d6d[_0xf32b('0x46')]['id'];return db[_0xf32b('0x2b')][_0xf32b('0x54')]({'where':{'id':_0x999d6d[_0xf32b('0x51')]['id']}})[_0xf32b('0x23')](handleEntityNotFound(_0x2f089e,null))[_0xf32b('0x23')](function(_0x548105){if(_0x548105){return db[_0xf32b('0x8c')][_0xf32b('0x8d')](function(_0x58e320){return db['CmCustomField']['create'](_0x999d6d['body'],{'transaction':_0x58e320})['then'](function(_0x1bc9d1){_0x131fb9=_0x1bc9d1;return _0x548105[_0xf32b('0x8e')](_0x1bc9d1,{'transaction':_0x58e320});})[_0xf32b('0x23')](function(){var _0x3ce490={'type':db[_0xf32b('0x8f')][_0xf32b('0x90')],'transaction':_0x58e320};switch(_0x999d6d[_0xf32b('0x46')][_0xf32b('0x2e')]){case'text':_0x3ce490[_0xf32b('0x2e')]=db['Sequelize'][_0xf32b('0x90')];break;case _0xf32b('0x91'):_0x3ce490['type']=db[_0xf32b('0x8f')][_0xf32b('0x92')];break;case _0xf32b('0x93'):_0x3ce490['type']=db[_0xf32b('0x8f')]['BOOLEAN'];_0x3ce490['defaultValue']=![];break;default:}return db[_0xf32b('0x8c')][_0xf32b('0x94')][_0xf32b('0x95')]('cm_contacts',util['format'](_0xf32b('0x96'),_0x131fb9['id']),_0x3ce490);})[_0xf32b('0x23')](function(){return _0x131fb9;});});}})[_0xf32b('0x23')](respondWithResult(_0x2f089e,null))[_0xf32b('0x44')](handleError(_0x2f089e,null));};exports[_0xf32b('0x97')]=function(_0x460e18,_0x5a533f,_0x123e1c){var _0x5973f7={};var _0x210e5e={};var _0x5e16de;var _0x484c91;return db[_0xf32b('0x2b')]['findOne']({'where':{'id':_0x460e18['params']['id']}})['then'](handleEntityNotFound(_0x5a533f,null))[_0xf32b('0x23')](function(_0x3dd896){if(_0x3dd896){_0x5e16de=_0x3dd896;_0x210e5e[_0xf32b('0x30')]=_[_0xf32b('0x32')](db[_0xf32b('0x68')]['rawAttributes']);_0x210e5e[_0xf32b('0x31')]=_[_0xf32b('0x32')](_0x460e18[_0xf32b('0x31')]);_0x210e5e[_0xf32b('0x33')]=_[_0xf32b('0x34')](_0x210e5e[_0xf32b('0x30')],_0x210e5e[_0xf32b('0x31')]);_0x5973f7[_0xf32b('0x35')]=_['intersection'](_0x210e5e['model'],qs[_0xf32b('0x36')](_0x460e18[_0xf32b('0x31')][_0xf32b('0x36')]));_0x5973f7[_0xf32b('0x35')]=_0x5973f7['attributes'][_0xf32b('0x41')]?_0x5973f7[_0xf32b('0x35')]:_0x210e5e[_0xf32b('0x30')];_0x5973f7[_0xf32b('0x38')]=qs[_0xf32b('0x39')](_0x460e18[_0xf32b('0x31')]['sort']);_0x5973f7[_0xf32b('0x3a')]=qs[_0xf32b('0x33')](_[_0xf32b('0x3b')](_0x460e18[_0xf32b('0x31')],_0x210e5e[_0xf32b('0x33')]));_0x5973f7[_0xf32b('0x3a')]=_[_0xf32b('0x3c')](_0x5973f7[_0xf32b('0x3a')],{'$or':[{'ListId':_0x3dd896['id']},{'ListId':null}]});if(_0x460e18[_0xf32b('0x31')][_0xf32b('0x56')]){_0x5973f7[_0xf32b('0x3a')]=_['merge'](_0x5973f7[_0xf32b('0x3a')],{'$or':_[_0xf32b('0x2a')](_0x5973f7[_0xf32b('0x35')],function(_0x2821ee){var _0x4703e3={};_0x4703e3[_0x2821ee]={'$like':'%'+_0x460e18[_0xf32b('0x31')][_0xf32b('0x56')]+'%'};return _0x4703e3;})});}_0x5973f7=_[_0xf32b('0x3c')]({},_0x5973f7,_0x460e18[_0xf32b('0x42')]);return db[_0xf32b('0x68')][_0xf32b('0x98')](_0x5973f7);}})[_0xf32b('0x23')](respondWithResult(_0x5a533f,null))[_0xf32b('0x44')](handleError(_0x5a533f,null));};exports[_0xf32b('0x99')]=function(_0x18e48f,_0x4596f3){return db[_0xf32b('0x68')][_0xf32b('0x98')]({'where':{'ListId':null}})['then'](handleEntityNotFound(_0x4596f3,null))[_0xf32b('0x23')](function(_0x22b2d7){return _0x22b2d7;})[_0xf32b('0x23')](respondWithResult(_0x4596f3,null))['catch'](handleError(_0x4596f3,null));};exports[_0xf32b('0x9a')]=function(_0x2b5168,_0x4a5606,_0x13260b){return db[_0xf32b('0x2b')][_0xf32b('0x43')]({'where':{'id':_0x2b5168[_0xf32b('0x51')]['id']}})[_0xf32b('0x23')](handleEntityNotFound(_0x4a5606,null))['then'](function(_0x27aabe){if(_0x27aabe){return _0x27aabe[_0xf32b('0x9a')](_0x2b5168['body']['ids'],_[_0xf32b('0x9b')](_0x2b5168['body'],[_0xf32b('0x61'),'id'])||{})[_0xf32b('0x9c')](function(_0x3441d8){for(var _0x215279=0x0;_0x215279<_0x2b5168[_0xf32b('0x46')][_0xf32b('0x61')][_0xf32b('0x41')];_0x215279+=0x1){socket[_0xf32b('0x9d')](_0xf32b('0x9e'),{'UserId':Number(_0x2b5168[_0xf32b('0x46')][_0xf32b('0x61')][_0x215279]),'CmListId':Number(_0x2b5168[_0xf32b('0x51')]['id'])});}return _0x3441d8;});}})['then'](respondWithResult(_0x4a5606,null))[_0xf32b('0x44')](handleError(_0x4a5606,null));};exports[_0xf32b('0x9f')]=function(_0x9d90fc,_0x4dffec,_0x16bd6f){return db[_0xf32b('0x2b')][_0xf32b('0x43')]({'where':{'id':_0x9d90fc[_0xf32b('0x51')]['id']}})[_0xf32b('0x23')](handleEntityNotFound(_0x4dffec,null))[_0xf32b('0x23')](function(_0x53764a){if(_0x53764a){return _0x53764a[_0xf32b('0x9f')](_0x9d90fc['query'][_0xf32b('0x61')])['then'](function(){if(_[_0xf32b('0x5d')](_0x9d90fc[_0xf32b('0x31')][_0xf32b('0x61')])){for(var _0x3c75bc=0x0;_0x3c75bc<_0x9d90fc[_0xf32b('0x31')][_0xf32b('0x61')][_0xf32b('0x41')];_0x3c75bc+=0x1){socket[_0xf32b('0x9d')](_0xf32b('0xa0'),{'UserId':Number(_0x9d90fc['query'][_0xf32b('0x61')][_0x3c75bc]),'CmListId':Number(_0x9d90fc['params']['id'])});}}else{socket[_0xf32b('0x9d')](_0xf32b('0xa0'),{'UserId':Number(_0x9d90fc['query'][_0xf32b('0x61')]),'CmListId':Number(_0x9d90fc['params']['id'])});}});}})[_0xf32b('0x23')](respondWithStatusCode(_0x4dffec,null))[_0xf32b('0x44')](handleError(_0x4dffec,null));};exports[_0xf32b('0xa1')]=function(_0x183066,_0x22f89f,_0x2ed169){var _0x3f975c={};var _0xf2e82a={};var _0x5a7d3c;var _0x2e2b76;return db[_0xf32b('0x2b')][_0xf32b('0x54')]({'where':{'id':_0x183066['params']['id']}})['then'](handleEntityNotFound(_0x22f89f,null))[_0xf32b('0x23')](function(_0x5b4ab3){if(_0x5b4ab3){_0x5a7d3c=_0x5b4ab3;_0xf2e82a[_0xf32b('0x30')]=_[_0xf32b('0x32')](db[_0xf32b('0xa2')][_0xf32b('0x2c')]);_0xf2e82a[_0xf32b('0x31')]=_[_0xf32b('0x32')](_0x183066[_0xf32b('0x31')]);_0xf2e82a[_0xf32b('0x33')]=_[_0xf32b('0x34')](_0xf2e82a[_0xf32b('0x30')],_0xf2e82a['query']);_0x3f975c[_0xf32b('0x35')]=_[_0xf32b('0x34')](_0xf2e82a['model'],qs[_0xf32b('0x36')](_0x183066['query'][_0xf32b('0x36')]));_0x3f975c[_0xf32b('0x35')]=_0x3f975c[_0xf32b('0x35')]['length']?_0x3f975c[_0xf32b('0x35')]:_0xf2e82a['model'];_0x3f975c['order']=qs[_0xf32b('0x39')](_0x183066[_0xf32b('0x31')]['sort']);_0x3f975c[_0xf32b('0x3a')]=qs[_0xf32b('0x33')](_[_0xf32b('0x3b')](_0x183066['query'],_0xf2e82a[_0xf32b('0x33')]));if(_0x183066['query']['filter']){_0x3f975c[_0xf32b('0x3a')]=_[_0xf32b('0x3c')](_0x3f975c[_0xf32b('0x3a')],{'$or':_[_0xf32b('0x2a')](_0x3f975c[_0xf32b('0x35')],function(_0x52bbf5){var _0x3c9435={};_0x3c9435[_0x52bbf5]={'$like':'%'+_0x183066[_0xf32b('0x31')]['filter']+'%'};return _0x3c9435;})});}_0x3f975c=_[_0xf32b('0x3c')]({},_0x3f975c,_0x183066[_0xf32b('0x42')]);return _0x5a7d3c['getAgents'](_0x3f975c);}})[_0xf32b('0x23')](function(_0xc75f8e){if(_0xc75f8e){_0x2e2b76=_0xc75f8e[_0xf32b('0x41')];if(!_0x183066[_0xf32b('0x31')]['hasOwnProperty'](_0xf32b('0x55'))){_0x3f975c[_0xf32b('0x1d')]=qs['limit'](_0x183066['query'][_0xf32b('0x1d')]);_0x3f975c[_0xf32b('0x1b')]=qs['offset'](_0x183066[_0xf32b('0x31')][_0xf32b('0x1b')]);}return _0x5a7d3c[_0xf32b('0xa1')](_0x3f975c);}})[_0xf32b('0x23')](function(_0xedf72b){if(_0xedf72b){return _0xedf72b?{'count':_0x2e2b76,'rows':_0xedf72b}:null;}})['then'](respondWithResult(_0x22f89f,null))[_0xf32b('0x44')](handleError(_0x22f89f,null));};function handleQuery(_0x4a9b5a){logger[_0xf32b('0xa3')](_0x4a9b5a);return db[_0xf32b('0x8c')][_0xf32b('0x31')](_0x4a9b5a)[_0xf32b('0x9c')](function(_0x10632f){csv_results[_0xf32b('0x5f')](_0x10632f);})[_0xf32b('0x44')](function(_0x559df5){logger[_0xf32b('0x26')](_0x559df5[_0xf32b('0x65')]);});}