server/api/intSugarcrmField/intSugarcrmField.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 _0x6d7d=['attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','merge','options','includeAll','include','findAll','rows','catch','show','params','keys','find','create','body','rimraf','zip-dir','request-promise','moment','util','path','to-csv','fs-extra','lodash','crypto','desk.js','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','update','destroy','then','error','stack','name','send','index','map','SugarcrmField','rawAttributes','fieldName','type','key','model','query','filters','intersection'];(function(_0x34bc6c,_0x10d089){var _0x168820=function(_0xb058d9){while(--_0xb058d9){_0x34bc6c['push'](_0x34bc6c['shift']());}};_0x168820(++_0x10d089);}(_0x6d7d,0x1c0));var _0xd6d7=function(_0xce6a78,_0x574329){_0xce6a78=_0xce6a78-0x0;var _0x1938c3=_0x6d7d[_0xce6a78];return _0x1938c3;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xd6d7('0x0'));var zipdir=require(_0xd6d7('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0xd6d7('0x2'));var moment=require(_0xd6d7('0x3'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0xd6d7('0x4'));var path=require(_0xd6d7('0x5'));var sox=require('sox');var csv=require(_0xd6d7('0x6'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xd6d7('0x7'));var _=require(_0xd6d7('0x8'));var squel=require('squel');var crypto=require(_0xd6d7('0x9'));var jsforce=require('jsforce');var deskjs=require(_0xd6d7('0xa'));var toCsv=require(_0xd6d7('0x6'));var querystring=require('querystring');var Papa=require(_0xd6d7('0xb'));var Redis=require(_0xd6d7('0xc'));var authService=require('../../components/auth/service');var qs=require(_0xd6d7('0xd'));var as=require(_0xd6d7('0xe'));var hardwareService=require(_0xd6d7('0xf'));var logger=require('../../config/logger')(_0xd6d7('0x10'));var utils=require('../../config/utils');var config=require(_0xd6d7('0x11'));var licenseUtil=require('../../config/license/util');var db=require(_0xd6d7('0x12'))['db'];function respondWithStatusCode(_0xcfe390,_0x271fe6){_0x271fe6=_0x271fe6||0xcc;return function(_0x3d6c9e){if(_0x3d6c9e){return _0xcfe390[_0xd6d7('0x13')](_0x271fe6);}return _0xcfe390[_0xd6d7('0x14')](_0x271fe6)[_0xd6d7('0x15')]();};}function respondWithResult(_0x428841,_0x4fca33){_0x4fca33=_0x4fca33||0xc8;return function(_0x4f4d59){if(_0x4f4d59){return _0x428841[_0xd6d7('0x14')](_0x4fca33)[_0xd6d7('0x16')](_0x4f4d59);}};}function respondWithFilteredResult(_0x3067ff,_0x4c7665){return function(_0x1d0b62){if(_0x1d0b62){var _0x1bec08=typeof _0x4c7665[_0xd6d7('0x17')]===_0xd6d7('0x18')&&typeof _0x4c7665[_0xd6d7('0x19')]===_0xd6d7('0x18');var _0x304363=_0x1d0b62['count'];var _0x2723c8=_0x1bec08?0x0:_0x4c7665[_0xd6d7('0x17')];var _0x6aaaa9=_0x1bec08?_0x1d0b62[_0xd6d7('0x1a')]:_0x4c7665[_0xd6d7('0x17')]+_0x4c7665[_0xd6d7('0x19')];var _0x4c12d5;if(_0x6aaaa9>=_0x304363){_0x6aaaa9=_0x304363;_0x4c12d5=0xc8;}else{_0x4c12d5=0xce;}_0x3067ff[_0xd6d7('0x14')](_0x4c12d5);return _0x3067ff[_0xd6d7('0x1b')](_0xd6d7('0x1c'),_0x2723c8+'-'+_0x6aaaa9+'/'+_0x304363)['json'](_0x1d0b62);}return null;};}function patchUpdates(_0x559d43){return function(_0x272357){try{jsonpatch[_0xd6d7('0x1d')](_0x272357,_0x559d43,!![]);}catch(_0x155ce9){return BPromise[_0xd6d7('0x1e')](_0x155ce9);}return _0x272357['save']();};}function saveUpdates(_0x3b3891,_0x403f9a){return function(_0x1e3920){if(_0x1e3920){return _0x1e3920[_0xd6d7('0x1f')](_0x3b3891)['then'](function(_0x3fb237){return _0x3fb237;});}return null;};}function removeEntity(_0x2796be,_0x3493ca){return function(_0x40651b){if(_0x40651b){return _0x40651b[_0xd6d7('0x20')]()[_0xd6d7('0x21')](function(){_0x2796be[_0xd6d7('0x14')](0xcc)[_0xd6d7('0x15')]();});}};}function handleEntityNotFound(_0x4e010b,_0x2e0913){return function(_0x5be889){if(!_0x5be889){_0x4e010b['sendStatus'](0x194);}return _0x5be889;};}function handleError(_0x31f41a,_0x4fcc6e){_0x4fcc6e=_0x4fcc6e||0x1f4;return function(_0x50ee50){logger[_0xd6d7('0x22')](_0x50ee50[_0xd6d7('0x23')]);if(_0x50ee50[_0xd6d7('0x24')]){delete _0x50ee50['name'];}_0x31f41a[_0xd6d7('0x14')](_0x4fcc6e)[_0xd6d7('0x25')](_0x50ee50);};}exports[_0xd6d7('0x26')]=function(_0x5c93fb,_0x1b91a1){var _0x43e50e={},_0x867d81={},_0x58f26b={'count':0x0,'rows':[]};var _0x4164bf=_[_0xd6d7('0x27')](db[_0xd6d7('0x28')][_0xd6d7('0x29')],function(_0x1949b1){return{'name':_0x1949b1[_0xd6d7('0x2a')],'type':_0x1949b1[_0xd6d7('0x2b')][_0xd6d7('0x2c')]};});_0x867d81[_0xd6d7('0x2d')]=_['map'](_0x4164bf,_0xd6d7('0x24'));_0x867d81[_0xd6d7('0x2e')]=_['keys'](_0x5c93fb[_0xd6d7('0x2e')]);_0x867d81[_0xd6d7('0x2f')]=_[_0xd6d7('0x30')](_0x867d81[_0xd6d7('0x2d')],_0x867d81[_0xd6d7('0x2e')]);_0x43e50e[_0xd6d7('0x31')]=_[_0xd6d7('0x30')](_0x867d81['model'],qs[_0xd6d7('0x32')](_0x5c93fb[_0xd6d7('0x2e')]['fields']));_0x43e50e[_0xd6d7('0x31')]=_0x43e50e[_0xd6d7('0x31')][_0xd6d7('0x33')]?_0x43e50e['attributes']:_0x867d81['model'];if(!_0x5c93fb[_0xd6d7('0x2e')][_0xd6d7('0x34')](_0xd6d7('0x35'))){_0x43e50e[_0xd6d7('0x19')]=qs[_0xd6d7('0x19')](_0x5c93fb['query'][_0xd6d7('0x19')]);_0x43e50e['offset']=qs['offset'](_0x5c93fb[_0xd6d7('0x2e')][_0xd6d7('0x17')]);}_0x43e50e[_0xd6d7('0x36')]=qs[_0xd6d7('0x37')](_0x5c93fb[_0xd6d7('0x2e')][_0xd6d7('0x37')]);_0x43e50e[_0xd6d7('0x38')]=qs[_0xd6d7('0x2f')](_[_0xd6d7('0x39')](_0x5c93fb[_0xd6d7('0x2e')],_0x867d81[_0xd6d7('0x2f')]),_0x4164bf);if(_0x5c93fb[_0xd6d7('0x2e')]['filter']){_0x43e50e[_0xd6d7('0x38')]=_[_0xd6d7('0x3a')](_0x43e50e['where'],{'$or':_['map'](_0x4164bf,function(_0x210416){if(_0x210416[_0xd6d7('0x2b')]!=='VIRTUAL'){var _0x202fe3={};_0x202fe3[_0x210416[_0xd6d7('0x24')]]={'$like':'%'+_0x5c93fb[_0xd6d7('0x2e')]['filter']+'%'};return _0x202fe3;}})});}_0x43e50e=_['merge']({},_0x43e50e,_0x5c93fb[_0xd6d7('0x3b')]);var _0x423800={'where':_0x43e50e[_0xd6d7('0x38')]};return db[_0xd6d7('0x28')]['count'](_0x423800)['then'](function(_0x3430ce){_0x58f26b[_0xd6d7('0x1a')]=_0x3430ce;if(_0x5c93fb[_0xd6d7('0x2e')][_0xd6d7('0x3c')]){_0x43e50e[_0xd6d7('0x3d')]=[{'all':!![]}];}return db[_0xd6d7('0x28')][_0xd6d7('0x3e')](_0x43e50e);})[_0xd6d7('0x21')](function(_0x3c7bfe){_0x58f26b[_0xd6d7('0x3f')]=_0x3c7bfe;return _0x58f26b;})['then'](respondWithFilteredResult(_0x1b91a1,_0x43e50e))[_0xd6d7('0x40')](handleError(_0x1b91a1,null));};exports[_0xd6d7('0x41')]=function(_0x4e4280,_0x51c87f){var _0x351b13={'raw':!![],'where':{'id':_0x4e4280[_0xd6d7('0x42')]['id']}},_0x2304ad={};_0x2304ad[_0xd6d7('0x2d')]=_[_0xd6d7('0x43')](db[_0xd6d7('0x28')]['rawAttributes']);_0x2304ad[_0xd6d7('0x2e')]=_[_0xd6d7('0x43')](_0x4e4280[_0xd6d7('0x2e')]);_0x2304ad[_0xd6d7('0x2f')]=_[_0xd6d7('0x30')](_0x2304ad[_0xd6d7('0x2d')],_0x2304ad[_0xd6d7('0x2e')]);_0x351b13[_0xd6d7('0x31')]=_[_0xd6d7('0x30')](_0x2304ad['model'],qs[_0xd6d7('0x32')](_0x4e4280['query'][_0xd6d7('0x32')]));_0x351b13['attributes']=_0x351b13[_0xd6d7('0x31')][_0xd6d7('0x33')]?_0x351b13[_0xd6d7('0x31')]:_0x2304ad[_0xd6d7('0x2d')];if(_0x4e4280[_0xd6d7('0x2e')][_0xd6d7('0x3c')]){_0x351b13[_0xd6d7('0x3d')]=[{'all':!![]}];}_0x351b13=_[_0xd6d7('0x3a')]({},_0x351b13,_0x4e4280[_0xd6d7('0x3b')]);return db['SugarcrmField'][_0xd6d7('0x44')](_0x351b13)['then'](handleEntityNotFound(_0x51c87f,null))[_0xd6d7('0x21')](respondWithResult(_0x51c87f,null))[_0xd6d7('0x40')](handleError(_0x51c87f,null));};exports[_0xd6d7('0x45')]=function(_0x16009c,_0x39fd81){return db[_0xd6d7('0x28')][_0xd6d7('0x45')](_0x16009c[_0xd6d7('0x46')],{})['then'](respondWithResult(_0x39fd81,0xc9))[_0xd6d7('0x40')](handleError(_0x39fd81,null));};exports['update']=function(_0x4ae16b,_0x56d2b7){if(_0x4ae16b[_0xd6d7('0x46')]['id']){delete _0x4ae16b[_0xd6d7('0x46')]['id'];}return db[_0xd6d7('0x28')][_0xd6d7('0x44')]({'where':{'id':_0x4ae16b['params']['id']}})[_0xd6d7('0x21')](handleEntityNotFound(_0x56d2b7,null))[_0xd6d7('0x21')](saveUpdates(_0x4ae16b[_0xd6d7('0x46')],null))[_0xd6d7('0x21')](respondWithResult(_0x56d2b7,null))[_0xd6d7('0x40')](handleError(_0x56d2b7,null));};exports[_0xd6d7('0x20')]=function(_0x30790d,_0x3c7416){return db[_0xd6d7('0x28')][_0xd6d7('0x44')]({'where':{'id':_0x30790d[_0xd6d7('0x42')]['id']}})[_0xd6d7('0x21')](handleEntityNotFound(_0x3c7416,null))[_0xd6d7('0x21')](removeEntity(_0x3c7416,null))[_0xd6d7('0x40')](handleError(_0x3c7416,null));};