server/api/squareReport/squareReport.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 _0x1bcc=['body','describe','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','ejs','lodash','crypto','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','offset','undefined','limit','Content-Range','apply','reject','save','update','destroy','then','error','name','index','map','rawAttributes','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','order','sort','where','pick','filter','merge','type','SquareReport','count','includeAll','include','findAll','rows','catch','show','params','options','find','create'];(function(_0x2c91e9,_0x2fb965){var _0x13f0ff=function(_0xb39edf){while(--_0xb39edf){_0x2c91e9['push'](_0x2c91e9['shift']());}};_0x13f0ff(++_0x2fb965);}(_0x1bcc,0x9a));var _0xc1bc=function(_0x3b5226,_0x496a84){_0x3b5226=_0x3b5226-0x0;var _0x3a13d1=_0x1bcc[_0x3b5226];return _0x3a13d1;};'use strict';var emlformat=require(_0xc1bc('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xc1bc('0x1'));var jsonpatch=require(_0xc1bc('0x2'));var rp=require(_0xc1bc('0x3'));var moment=require(_0xc1bc('0x4'));var BPromise=require(_0xc1bc('0x5'));var Mustache=require(_0xc1bc('0x6'));var util=require(_0xc1bc('0x7'));var path=require('path');var sox=require(_0xc1bc('0x8'));var csv=require('to-csv');var ejs=require(_0xc1bc('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xc1bc('0xa'));var squel=require('squel');var crypto=require(_0xc1bc('0xb'));var jsforce=require('jsforce');var deskjs=require(_0xc1bc('0xc'));var toCsv=require(_0xc1bc('0xd'));var querystring=require(_0xc1bc('0xe'));var Papa=require(_0xc1bc('0xf'));var Redis=require(_0xc1bc('0x10'));var authService=require(_0xc1bc('0x11'));var qs=require(_0xc1bc('0x12'));var as=require(_0xc1bc('0x13'));var hardwareService=require(_0xc1bc('0x14'));var logger=require(_0xc1bc('0x15'))(_0xc1bc('0x16'));var utils=require(_0xc1bc('0x17'));var config=require(_0xc1bc('0x18'));var licenseUtil=require(_0xc1bc('0x19'));var db=require(_0xc1bc('0x1a'))['db'];function respondWithStatusCode(_0x8e0c7e,_0x57455e){_0x57455e=_0x57455e||0xcc;return function(_0x11a701){if(_0x11a701){return _0x8e0c7e[_0xc1bc('0x1b')](_0x57455e);}return _0x8e0c7e[_0xc1bc('0x1c')](_0x57455e)[_0xc1bc('0x1d')]();};}function respondWithResult(_0x199028,_0x169ca7){_0x169ca7=_0x169ca7||0xc8;return function(_0x58749d){if(_0x58749d){return _0x199028[_0xc1bc('0x1c')](_0x169ca7)['json'](_0x58749d);}};}function respondWithFilteredResult(_0xdac3fa,_0x3e8abe){return function(_0x5b3f9){if(_0x5b3f9){var _0xe95fdf=typeof _0x3e8abe[_0xc1bc('0x1e')]===_0xc1bc('0x1f')&&typeof _0x3e8abe[_0xc1bc('0x20')]===_0xc1bc('0x1f');var _0x1dcadd=_0x5b3f9['count'];var _0x465f6f=_0xe95fdf?0x0:_0x3e8abe[_0xc1bc('0x1e')];var _0x22d3e4=_0xe95fdf?_0x5b3f9['count']:_0x3e8abe[_0xc1bc('0x1e')]+_0x3e8abe[_0xc1bc('0x20')];var _0x2afb4c;if(_0x22d3e4>=_0x1dcadd){_0x22d3e4=_0x1dcadd;_0x2afb4c=0xc8;}else{_0x2afb4c=0xce;}_0xdac3fa[_0xc1bc('0x1c')](_0x2afb4c);return _0xdac3fa['set'](_0xc1bc('0x21'),_0x465f6f+'-'+_0x22d3e4+'/'+_0x1dcadd)['json'](_0x5b3f9);}return null;};}function patchUpdates(_0x203439){return function(_0x1988a9){try{jsonpatch[_0xc1bc('0x22')](_0x1988a9,_0x203439,!![]);}catch(_0x255ad8){return BPromise[_0xc1bc('0x23')](_0x255ad8);}return _0x1988a9[_0xc1bc('0x24')]();};}function saveUpdates(_0x508038,_0x33f181){return function(_0x1928b1){if(_0x1928b1){return _0x1928b1[_0xc1bc('0x25')](_0x508038)['then'](function(_0x525430){return _0x525430;});}return null;};}function removeEntity(_0x40b266,_0x976a9a){return function(_0x1f13fc){if(_0x1f13fc){return _0x1f13fc[_0xc1bc('0x26')]()[_0xc1bc('0x27')](function(){_0x40b266[_0xc1bc('0x1c')](0xcc)[_0xc1bc('0x1d')]();});}};}function handleEntityNotFound(_0x418a6d,_0x22887a){return function(_0x317268){if(!_0x317268){_0x418a6d[_0xc1bc('0x1b')](0x194);}return _0x317268;};}function handleError(_0x4df4d9,_0x3a21d4){_0x3a21d4=_0x3a21d4||0x1f4;return function(_0x119bc2){logger[_0xc1bc('0x28')](_0x119bc2['stack']);if(_0x119bc2[_0xc1bc('0x29')]){delete _0x119bc2[_0xc1bc('0x29')];}_0x4df4d9['status'](_0x3a21d4)['send'](_0x119bc2);};}exports[_0xc1bc('0x2a')]=function(_0x299b42,_0x562885){var _0x3adc90={},_0x1e6124={},_0x48d99b={'count':0x0,'rows':[]};var _0x3df581=_[_0xc1bc('0x2b')](db['SquareReport'][_0xc1bc('0x2c')],function(_0x4f473c){return{'name':_0x4f473c['fieldName'],'type':_0x4f473c['type'][_0xc1bc('0x2d')]};});_0x1e6124[_0xc1bc('0x2e')]=_[_0xc1bc('0x2b')](_0x3df581,'name');_0x1e6124[_0xc1bc('0x2f')]=_[_0xc1bc('0x30')](_0x299b42[_0xc1bc('0x2f')]);_0x1e6124[_0xc1bc('0x31')]=_[_0xc1bc('0x32')](_0x1e6124[_0xc1bc('0x2e')],_0x1e6124[_0xc1bc('0x2f')]);_0x3adc90[_0xc1bc('0x33')]=_[_0xc1bc('0x32')](_0x1e6124['model'],qs[_0xc1bc('0x34')](_0x299b42['query'][_0xc1bc('0x34')]));_0x3adc90[_0xc1bc('0x33')]=_0x3adc90[_0xc1bc('0x33')][_0xc1bc('0x35')]?_0x3adc90[_0xc1bc('0x33')]:_0x1e6124[_0xc1bc('0x2e')];if(!_0x299b42[_0xc1bc('0x2f')][_0xc1bc('0x36')]('nolimit')){_0x3adc90[_0xc1bc('0x20')]=qs['limit'](_0x299b42[_0xc1bc('0x2f')][_0xc1bc('0x20')]);_0x3adc90[_0xc1bc('0x1e')]=qs[_0xc1bc('0x1e')](_0x299b42[_0xc1bc('0x2f')]['offset']);}_0x3adc90[_0xc1bc('0x37')]=qs[_0xc1bc('0x38')](_0x299b42[_0xc1bc('0x2f')][_0xc1bc('0x38')]);_0x3adc90[_0xc1bc('0x39')]=qs[_0xc1bc('0x31')](_[_0xc1bc('0x3a')](_0x299b42[_0xc1bc('0x2f')],_0x1e6124[_0xc1bc('0x31')]),_0x3df581);if(_0x299b42['query'][_0xc1bc('0x3b')]){_0x3adc90[_0xc1bc('0x39')]=_[_0xc1bc('0x3c')](_0x3adc90[_0xc1bc('0x39')],{'$or':_['map'](_0x3df581,function(_0x5df058){if(_0x5df058[_0xc1bc('0x3d')]!=='VIRTUAL'){var _0x15575a={};_0x15575a[_0x5df058[_0xc1bc('0x29')]]={'$like':'%'+_0x299b42['query'][_0xc1bc('0x3b')]+'%'};return _0x15575a;}})});}_0x3adc90=_['merge']({},_0x3adc90,_0x299b42['options']);var _0x49fcbd={'where':_0x3adc90[_0xc1bc('0x39')]};return db[_0xc1bc('0x3e')][_0xc1bc('0x3f')](_0x49fcbd)[_0xc1bc('0x27')](function(_0x363b1f){_0x48d99b[_0xc1bc('0x3f')]=_0x363b1f;if(_0x299b42[_0xc1bc('0x2f')][_0xc1bc('0x40')]){_0x3adc90[_0xc1bc('0x41')]=[{'all':!![]}];}return db[_0xc1bc('0x3e')][_0xc1bc('0x42')](_0x3adc90);})[_0xc1bc('0x27')](function(_0x4b46ae){_0x48d99b[_0xc1bc('0x43')]=_0x4b46ae;return _0x48d99b;})[_0xc1bc('0x27')](respondWithFilteredResult(_0x562885,_0x3adc90))[_0xc1bc('0x44')](handleError(_0x562885,null));};exports[_0xc1bc('0x45')]=function(_0x351a8f,_0x3b31e4){var _0x3b9fb9={'raw':!![],'where':{'id':_0x351a8f[_0xc1bc('0x46')]['id']}},_0x4a462a={};_0x4a462a[_0xc1bc('0x2e')]=_[_0xc1bc('0x30')](db['SquareReport']['rawAttributes']);_0x4a462a['query']=_[_0xc1bc('0x30')](_0x351a8f[_0xc1bc('0x2f')]);_0x4a462a[_0xc1bc('0x31')]=_['intersection'](_0x4a462a[_0xc1bc('0x2e')],_0x4a462a[_0xc1bc('0x2f')]);_0x3b9fb9[_0xc1bc('0x33')]=_[_0xc1bc('0x32')](_0x4a462a['model'],qs[_0xc1bc('0x34')](_0x351a8f['query'][_0xc1bc('0x34')]));_0x3b9fb9[_0xc1bc('0x33')]=_0x3b9fb9['attributes'][_0xc1bc('0x35')]?_0x3b9fb9['attributes']:_0x4a462a[_0xc1bc('0x2e')];if(_0x351a8f[_0xc1bc('0x2f')][_0xc1bc('0x40')]){_0x3b9fb9[_0xc1bc('0x41')]=[{'all':!![]}];}_0x3b9fb9=_[_0xc1bc('0x3c')]({},_0x3b9fb9,_0x351a8f[_0xc1bc('0x47')]);return db['SquareReport'][_0xc1bc('0x48')](_0x3b9fb9)['then'](handleEntityNotFound(_0x3b31e4,null))[_0xc1bc('0x27')](respondWithResult(_0x3b31e4,null))[_0xc1bc('0x44')](handleError(_0x3b31e4,null));};exports[_0xc1bc('0x49')]=function(_0x5d8669,_0x32e80c){return db['SquareReport'][_0xc1bc('0x49')](_0x5d8669[_0xc1bc('0x4a')],{})[_0xc1bc('0x27')](respondWithResult(_0x32e80c,0xc9))[_0xc1bc('0x44')](handleError(_0x32e80c,null));};exports[_0xc1bc('0x25')]=function(_0x34cb0e,_0x4eed0d){if(_0x34cb0e[_0xc1bc('0x4a')]['id']){delete _0x34cb0e[_0xc1bc('0x4a')]['id'];}return db[_0xc1bc('0x3e')][_0xc1bc('0x48')]({'where':{'id':_0x34cb0e['params']['id']}})[_0xc1bc('0x27')](handleEntityNotFound(_0x4eed0d,null))[_0xc1bc('0x27')](saveUpdates(_0x34cb0e[_0xc1bc('0x4a')],null))['then'](respondWithResult(_0x4eed0d,null))[_0xc1bc('0x44')](handleError(_0x4eed0d,null));};exports[_0xc1bc('0x26')]=function(_0x3d74c6,_0x4b6269){return db[_0xc1bc('0x3e')][_0xc1bc('0x48')]({'where':{'id':_0x3d74c6[_0xc1bc('0x46')]['id']}})[_0xc1bc('0x27')](handleEntityNotFound(_0x4b6269,null))['then'](removeEntity(_0x4b6269,null))[_0xc1bc('0x44')](handleError(_0x4b6269,null));};exports[_0xc1bc('0x4b')]=function(_0xb337ee,_0x325122){return db[_0xc1bc('0x3e')]['describe']()[_0xc1bc('0x27')](respondWithResult(_0x325122,null))[_0xc1bc('0x44')](handleError(_0x325122,null));};