server/api/intVtigerField/intVtigerField.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 _0xd73d=['map','rawAttributes','fieldName','type','key','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','options','VtigerField','then','includeAll','include','rows','catch','show','find','create','body','params','destroy','eml-format','rimraf','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','fs-extra','squel','jsforce','desk.js','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/license/util','../../mysqldb','sendStatus','status','undefined','limit','count','offset','set','Content-Range','json','update','error','name','index'];(function(_0x3d95e5,_0x2b0c10){var _0x10718f=function(_0x399670){while(--_0x399670){_0x3d95e5['push'](_0x3d95e5['shift']());}};_0x10718f(++_0x2b0c10);}(_0xd73d,0x180));var _0xdd73=function(_0x343a83,_0x218650){_0x343a83=_0x343a83-0x0;var _0x19aa04=_0xd73d[_0x343a83];return _0x19aa04;};'use strict';var emlformat=require(_0xdd73('0x0'));var rimraf=require(_0xdd73('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0xdd73('0x2'));var moment=require(_0xdd73('0x3'));var BPromise=require(_0xdd73('0x4'));var Mustache=require(_0xdd73('0x5'));var util=require(_0xdd73('0x6'));var path=require(_0xdd73('0x7'));var sox=require(_0xdd73('0x8'));var csv=require(_0xdd73('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xdd73('0xa'));var _=require('lodash');var squel=require(_0xdd73('0xb'));var crypto=require('crypto');var jsforce=require(_0xdd73('0xc'));var deskjs=require(_0xdd73('0xd'));var toCsv=require(_0xdd73('0x9'));var querystring=require('querystring');var Papa=require(_0xdd73('0xe'));var Redis=require('ioredis');var authService=require(_0xdd73('0xf'));var qs=require(_0xdd73('0x10'));var as=require(_0xdd73('0x11'));var hardwareService=require(_0xdd73('0x12'));var logger=require(_0xdd73('0x13'))(_0xdd73('0x14'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0xdd73('0x15'));var db=require(_0xdd73('0x16'))['db'];function respondWithStatusCode(_0x28cede,_0x297d55){_0x297d55=_0x297d55||0xcc;return function(_0x53d9ef){if(_0x53d9ef){return _0x28cede[_0xdd73('0x17')](_0x297d55);}return _0x28cede[_0xdd73('0x18')](_0x297d55)['end']();};}function respondWithResult(_0xae861c,_0x1ee7bc){_0x1ee7bc=_0x1ee7bc||0xc8;return function(_0x4d2807){if(_0x4d2807){return _0xae861c[_0xdd73('0x18')](_0x1ee7bc)['json'](_0x4d2807);}};}function respondWithFilteredResult(_0x51e1a8,_0x3ea450){return function(_0x3757df){if(_0x3757df){var _0x562d65=typeof _0x3ea450['offset']===_0xdd73('0x19')&&typeof _0x3ea450[_0xdd73('0x1a')]===_0xdd73('0x19');var _0x242961=_0x3757df[_0xdd73('0x1b')];var _0x1c0d1d=_0x562d65?0x0:_0x3ea450[_0xdd73('0x1c')];var _0x479bf6=_0x562d65?_0x3757df['count']:_0x3ea450[_0xdd73('0x1c')]+_0x3ea450[_0xdd73('0x1a')];var _0x23437a;if(_0x479bf6>=_0x242961){_0x479bf6=_0x242961;_0x23437a=0xc8;}else{_0x23437a=0xce;}_0x51e1a8[_0xdd73('0x18')](_0x23437a);return _0x51e1a8[_0xdd73('0x1d')](_0xdd73('0x1e'),_0x1c0d1d+'-'+_0x479bf6+'/'+_0x242961)[_0xdd73('0x1f')](_0x3757df);}return null;};}function patchUpdates(_0xc66e3){return function(_0xa8c227){try{jsonpatch['apply'](_0xa8c227,_0xc66e3,!![]);}catch(_0x356441){return BPromise['reject'](_0x356441);}return _0xa8c227['save']();};}function saveUpdates(_0x21b682,_0x5ab1ee){return function(_0x190d74){if(_0x190d74){return _0x190d74[_0xdd73('0x20')](_0x21b682)['then'](function(_0x1797a3){return _0x1797a3;});}return null;};}function removeEntity(_0xd9a40,_0x2330c1){return function(_0x156e15){if(_0x156e15){return _0x156e15['destroy']()['then'](function(){_0xd9a40[_0xdd73('0x18')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1d4238,_0x36ba2c){return function(_0x4c134b){if(!_0x4c134b){_0x1d4238['sendStatus'](0x194);}return _0x4c134b;};}function handleError(_0x2dae3f,_0x55eb13){_0x55eb13=_0x55eb13||0x1f4;return function(_0x50aeff){logger[_0xdd73('0x21')](_0x50aeff['stack']);if(_0x50aeff[_0xdd73('0x22')]){delete _0x50aeff[_0xdd73('0x22')];}_0x2dae3f['status'](_0x55eb13)['send'](_0x50aeff);};}exports[_0xdd73('0x23')]=function(_0x54f138,_0x2ac4cb){var _0x176860={},_0x49ee77={},_0x5604a0={'count':0x0,'rows':[]};var _0xf2ac76=_[_0xdd73('0x24')](db['VtigerField'][_0xdd73('0x25')],function(_0xefe0d2){return{'name':_0xefe0d2[_0xdd73('0x26')],'type':_0xefe0d2[_0xdd73('0x27')][_0xdd73('0x28')]};});_0x49ee77[_0xdd73('0x29')]=_[_0xdd73('0x24')](_0xf2ac76,_0xdd73('0x22'));_0x49ee77['query']=_[_0xdd73('0x2a')](_0x54f138[_0xdd73('0x2b')]);_0x49ee77[_0xdd73('0x2c')]=_[_0xdd73('0x2d')](_0x49ee77[_0xdd73('0x29')],_0x49ee77[_0xdd73('0x2b')]);_0x176860[_0xdd73('0x2e')]=_[_0xdd73('0x2d')](_0x49ee77[_0xdd73('0x29')],qs['fields'](_0x54f138[_0xdd73('0x2b')][_0xdd73('0x2f')]));_0x176860[_0xdd73('0x2e')]=_0x176860[_0xdd73('0x2e')][_0xdd73('0x30')]?_0x176860['attributes']:_0x49ee77[_0xdd73('0x29')];if(!_0x54f138[_0xdd73('0x2b')][_0xdd73('0x31')](_0xdd73('0x32'))){_0x176860[_0xdd73('0x1a')]=qs[_0xdd73('0x1a')](_0x54f138[_0xdd73('0x2b')][_0xdd73('0x1a')]);_0x176860[_0xdd73('0x1c')]=qs[_0xdd73('0x1c')](_0x54f138[_0xdd73('0x2b')]['offset']);}_0x176860[_0xdd73('0x33')]=qs[_0xdd73('0x34')](_0x54f138[_0xdd73('0x2b')][_0xdd73('0x34')]);_0x176860[_0xdd73('0x35')]=qs['filters'](_[_0xdd73('0x36')](_0x54f138[_0xdd73('0x2b')],_0x49ee77[_0xdd73('0x2c')]),_0xf2ac76);if(_0x54f138[_0xdd73('0x2b')]['filter']){_0x176860['where']=_['merge'](_0x176860['where'],{'$or':_[_0xdd73('0x24')](_0xf2ac76,function(_0x188610){if(_0x188610[_0xdd73('0x27')]!=='VIRTUAL'){var _0x3ac45d={};_0x3ac45d[_0x188610[_0xdd73('0x22')]]={'$like':'%'+_0x54f138[_0xdd73('0x2b')][_0xdd73('0x37')]+'%'};return _0x3ac45d;}})});}_0x176860=_[_0xdd73('0x38')]({},_0x176860,_0x54f138[_0xdd73('0x39')]);var _0x43c027={'where':_0x176860[_0xdd73('0x35')]};return db[_0xdd73('0x3a')]['count'](_0x43c027)[_0xdd73('0x3b')](function(_0x400581){_0x5604a0[_0xdd73('0x1b')]=_0x400581;if(_0x54f138[_0xdd73('0x2b')][_0xdd73('0x3c')]){_0x176860[_0xdd73('0x3d')]=[{'all':!![]}];}return db[_0xdd73('0x3a')]['findAll'](_0x176860);})[_0xdd73('0x3b')](function(_0x4fefb8){_0x5604a0[_0xdd73('0x3e')]=_0x4fefb8;return _0x5604a0;})['then'](respondWithFilteredResult(_0x2ac4cb,_0x176860))[_0xdd73('0x3f')](handleError(_0x2ac4cb,null));};exports[_0xdd73('0x40')]=function(_0x5de3b5,_0xe261b9){var _0x3c388e={'raw':!![],'where':{'id':_0x5de3b5['params']['id']}},_0x688da0={};_0x688da0['model']=_[_0xdd73('0x2a')](db[_0xdd73('0x3a')]['rawAttributes']);_0x688da0[_0xdd73('0x2b')]=_[_0xdd73('0x2a')](_0x5de3b5[_0xdd73('0x2b')]);_0x688da0[_0xdd73('0x2c')]=_['intersection'](_0x688da0['model'],_0x688da0['query']);_0x3c388e[_0xdd73('0x2e')]=_['intersection'](_0x688da0['model'],qs['fields'](_0x5de3b5[_0xdd73('0x2b')]['fields']));_0x3c388e[_0xdd73('0x2e')]=_0x3c388e['attributes'][_0xdd73('0x30')]?_0x3c388e[_0xdd73('0x2e')]:_0x688da0['model'];if(_0x5de3b5[_0xdd73('0x2b')][_0xdd73('0x3c')]){_0x3c388e['include']=[{'all':!![]}];}_0x3c388e=_[_0xdd73('0x38')]({},_0x3c388e,_0x5de3b5[_0xdd73('0x39')]);return db[_0xdd73('0x3a')][_0xdd73('0x41')](_0x3c388e)[_0xdd73('0x3b')](handleEntityNotFound(_0xe261b9,null))[_0xdd73('0x3b')](respondWithResult(_0xe261b9,null))['catch'](handleError(_0xe261b9,null));};exports[_0xdd73('0x42')]=function(_0xae4947,_0x4a0a85){return db[_0xdd73('0x3a')][_0xdd73('0x42')](_0xae4947['body'],{})[_0xdd73('0x3b')](respondWithResult(_0x4a0a85,0xc9))[_0xdd73('0x3f')](handleError(_0x4a0a85,null));};exports[_0xdd73('0x20')]=function(_0x12de91,_0x81ae3d){if(_0x12de91['body']['id']){delete _0x12de91[_0xdd73('0x43')]['id'];}return db[_0xdd73('0x3a')][_0xdd73('0x41')]({'where':{'id':_0x12de91[_0xdd73('0x44')]['id']}})[_0xdd73('0x3b')](handleEntityNotFound(_0x81ae3d,null))['then'](saveUpdates(_0x12de91[_0xdd73('0x43')],null))[_0xdd73('0x3b')](respondWithResult(_0x81ae3d,null))[_0xdd73('0x3f')](handleError(_0x81ae3d,null));};exports[_0xdd73('0x45')]=function(_0x440534,_0x16d27f){return db[_0xdd73('0x3a')][_0xdd73('0x41')]({'where':{'id':_0x440534[_0xdd73('0x44')]['id']}})[_0xdd73('0x3b')](handleEntityNotFound(_0x16d27f,null))[_0xdd73('0x3b')](removeEntity(_0x16d27f,null))[_0xdd73('0x3f')](handleError(_0x16d27f,null));};