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 _0x7035=['jsforce','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','status','json','offset','undefined','limit','count','set','apply','reject','save','update','then','destroy','error','name','index','SquareReport','rawAttributes','fieldName','type','map','query','keys','model','attributes','intersection','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','options','includeAll','include','findAll','rows','catch','show','params','filters','find','create','body','describe','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','fs-extra','lodash','squel','crypto'];(function(_0x2610db,_0x454344){var _0x5d4d96=function(_0x3794de){while(--_0x3794de){_0x2610db['push'](_0x2610db['shift']());}};_0x5d4d96(++_0x454344);}(_0x7035,0x177));var _0x5703=function(_0x56ad76,_0x233586){_0x56ad76=_0x56ad76-0x0;var _0x5f473b=_0x7035[_0x56ad76];return _0x5f473b;};'use strict';var emlformat=require(_0x5703('0x0'));var rimraf=require(_0x5703('0x1'));var zipdir=require(_0x5703('0x2'));var jsonpatch=require(_0x5703('0x3'));var rp=require(_0x5703('0x4'));var moment=require(_0x5703('0x5'));var BPromise=require(_0x5703('0x6'));var Mustache=require(_0x5703('0x7'));var util=require(_0x5703('0x8'));var path=require('path');var sox=require(_0x5703('0x9'));var csv=require(_0x5703('0xa'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x5703('0xb'));var _=require(_0x5703('0xc'));var squel=require(_0x5703('0xd'));var crypto=require(_0x5703('0xe'));var jsforce=require(_0x5703('0xf'));var deskjs=require('desk.js');var toCsv=require(_0x5703('0xa'));var querystring=require(_0x5703('0x10'));var Papa=require(_0x5703('0x11'));var Redis=require(_0x5703('0x12'));var authService=require('../../components/auth/service');var qs=require(_0x5703('0x13'));var as=require(_0x5703('0x14'));var hardwareService=require(_0x5703('0x15'));var logger=require(_0x5703('0x16'))(_0x5703('0x17'));var utils=require('../../config/utils');var config=require(_0x5703('0x18'));var licenseUtil=require(_0x5703('0x19'));var db=require(_0x5703('0x1a'))['db'];function respondWithStatusCode(_0x2e6940,_0x3064fc){_0x3064fc=_0x3064fc||0xcc;return function(_0x3eac2a){if(_0x3eac2a){return _0x2e6940[_0x5703('0x1b')](_0x3064fc);}return _0x2e6940['status'](_0x3064fc)[_0x5703('0x1c')]();};}function respondWithResult(_0x57d034,_0x585308){_0x585308=_0x585308||0xc8;return function(_0x554f71){if(_0x554f71){return _0x57d034[_0x5703('0x1d')](_0x585308)[_0x5703('0x1e')](_0x554f71);}};}function respondWithFilteredResult(_0xe74380,_0x29e070){return function(_0x5d0320){if(_0x5d0320){var _0x32dec4=typeof _0x29e070[_0x5703('0x1f')]===_0x5703('0x20')&&typeof _0x29e070[_0x5703('0x21')]===_0x5703('0x20');var _0x31337b=_0x5d0320[_0x5703('0x22')];var _0x38a111=_0x32dec4?0x0:_0x29e070[_0x5703('0x1f')];var _0x55900e=_0x32dec4?_0x5d0320['count']:_0x29e070[_0x5703('0x1f')]+_0x29e070[_0x5703('0x21')];var _0x5e82e1;if(_0x55900e>=_0x31337b){_0x55900e=_0x31337b;_0x5e82e1=0xc8;}else{_0x5e82e1=0xce;}_0xe74380[_0x5703('0x1d')](_0x5e82e1);return _0xe74380[_0x5703('0x23')]('Content-Range',_0x38a111+'-'+_0x55900e+'/'+_0x31337b)[_0x5703('0x1e')](_0x5d0320);}return null;};}function patchUpdates(_0x5f2967){return function(_0xdce5c5){try{jsonpatch[_0x5703('0x24')](_0xdce5c5,_0x5f2967,!![]);}catch(_0x188d8e){return BPromise[_0x5703('0x25')](_0x188d8e);}return _0xdce5c5[_0x5703('0x26')]();};}function saveUpdates(_0x7cb8d9,_0x55f92d){return function(_0x3d5690){if(_0x3d5690){return _0x3d5690[_0x5703('0x27')](_0x7cb8d9)[_0x5703('0x28')](function(_0x27e217){return _0x27e217;});}return null;};}function removeEntity(_0x455cc8,_0x5f2b4b){return function(_0x57de07){if(_0x57de07){return _0x57de07[_0x5703('0x29')]()[_0x5703('0x28')](function(){_0x455cc8[_0x5703('0x1d')](0xcc)[_0x5703('0x1c')]();});}};}function handleEntityNotFound(_0x578ed3,_0x328cf6){return function(_0x65ea8b){if(!_0x65ea8b){_0x578ed3[_0x5703('0x1b')](0x194);}return _0x65ea8b;};}function handleError(_0x52b2ad,_0x9b10f){_0x9b10f=_0x9b10f||0x1f4;return function(_0x56b48b){logger[_0x5703('0x2a')](_0x56b48b['stack']);if(_0x56b48b[_0x5703('0x2b')]){delete _0x56b48b['name'];}_0x52b2ad[_0x5703('0x1d')](_0x9b10f)['send'](_0x56b48b);};}exports[_0x5703('0x2c')]=function(_0x330013,_0x4ec09c){var _0x322cfb={},_0x145a9c={},_0x5662ef={'count':0x0,'rows':[]};var _0x4af3f5=_['map'](db[_0x5703('0x2d')][_0x5703('0x2e')],function(_0x28e7e9){return{'name':_0x28e7e9[_0x5703('0x2f')],'type':_0x28e7e9[_0x5703('0x30')]['key']};});_0x145a9c['model']=_[_0x5703('0x31')](_0x4af3f5,_0x5703('0x2b'));_0x145a9c[_0x5703('0x32')]=_[_0x5703('0x33')](_0x330013['query']);_0x145a9c['filters']=_['intersection'](_0x145a9c[_0x5703('0x34')],_0x145a9c['query']);_0x322cfb[_0x5703('0x35')]=_[_0x5703('0x36')](_0x145a9c[_0x5703('0x34')],qs[_0x5703('0x37')](_0x330013[_0x5703('0x32')][_0x5703('0x37')]));_0x322cfb['attributes']=_0x322cfb[_0x5703('0x35')][_0x5703('0x38')]?_0x322cfb[_0x5703('0x35')]:_0x145a9c[_0x5703('0x34')];if(!_0x330013[_0x5703('0x32')][_0x5703('0x39')](_0x5703('0x3a'))){_0x322cfb['limit']=qs[_0x5703('0x21')](_0x330013[_0x5703('0x32')][_0x5703('0x21')]);_0x322cfb[_0x5703('0x1f')]=qs[_0x5703('0x1f')](_0x330013[_0x5703('0x32')][_0x5703('0x1f')]);}_0x322cfb[_0x5703('0x3b')]=qs['sort'](_0x330013[_0x5703('0x32')][_0x5703('0x3c')]);_0x322cfb['where']=qs['filters'](_[_0x5703('0x3d')](_0x330013[_0x5703('0x32')],_0x145a9c['filters']),_0x4af3f5);if(_0x330013['query'][_0x5703('0x3e')]){_0x322cfb[_0x5703('0x3f')]=_[_0x5703('0x40')](_0x322cfb['where'],{'$or':_[_0x5703('0x31')](_0x4af3f5,function(_0x577e84){if(_0x577e84['type']!=='VIRTUAL'){var _0x1ab1a3={};_0x1ab1a3[_0x577e84[_0x5703('0x2b')]]={'$like':'%'+_0x330013[_0x5703('0x32')][_0x5703('0x3e')]+'%'};return _0x1ab1a3;}})});}_0x322cfb=_['merge']({},_0x322cfb,_0x330013[_0x5703('0x41')]);var _0x367ef9={'where':_0x322cfb[_0x5703('0x3f')]};return db[_0x5703('0x2d')]['count'](_0x367ef9)[_0x5703('0x28')](function(_0x1b3da6){_0x5662ef[_0x5703('0x22')]=_0x1b3da6;if(_0x330013[_0x5703('0x32')][_0x5703('0x42')]){_0x322cfb[_0x5703('0x43')]=[{'all':!![]}];}return db[_0x5703('0x2d')][_0x5703('0x44')](_0x322cfb);})['then'](function(_0x16031f){_0x5662ef[_0x5703('0x45')]=_0x16031f;return _0x5662ef;})[_0x5703('0x28')](respondWithFilteredResult(_0x4ec09c,_0x322cfb))[_0x5703('0x46')](handleError(_0x4ec09c,null));};exports[_0x5703('0x47')]=function(_0x5efc65,_0x53fb54){var _0x562f05={'raw':!![],'where':{'id':_0x5efc65[_0x5703('0x48')]['id']}},_0x24bc94={};_0x24bc94[_0x5703('0x34')]=_[_0x5703('0x33')](db['SquareReport']['rawAttributes']);_0x24bc94[_0x5703('0x32')]=_['keys'](_0x5efc65[_0x5703('0x32')]);_0x24bc94[_0x5703('0x49')]=_[_0x5703('0x36')](_0x24bc94[_0x5703('0x34')],_0x24bc94[_0x5703('0x32')]);_0x562f05['attributes']=_[_0x5703('0x36')](_0x24bc94['model'],qs[_0x5703('0x37')](_0x5efc65[_0x5703('0x32')][_0x5703('0x37')]));_0x562f05[_0x5703('0x35')]=_0x562f05[_0x5703('0x35')]['length']?_0x562f05[_0x5703('0x35')]:_0x24bc94['model'];if(_0x5efc65[_0x5703('0x32')][_0x5703('0x42')]){_0x562f05[_0x5703('0x43')]=[{'all':!![]}];}_0x562f05=_[_0x5703('0x40')]({},_0x562f05,_0x5efc65[_0x5703('0x41')]);return db[_0x5703('0x2d')][_0x5703('0x4a')](_0x562f05)[_0x5703('0x28')](handleEntityNotFound(_0x53fb54,null))['then'](respondWithResult(_0x53fb54,null))[_0x5703('0x46')](handleError(_0x53fb54,null));};exports[_0x5703('0x4b')]=function(_0xb3677c,_0x3031c7){return db[_0x5703('0x2d')]['create'](_0xb3677c[_0x5703('0x4c')],{})[_0x5703('0x28')](respondWithResult(_0x3031c7,0xc9))[_0x5703('0x46')](handleError(_0x3031c7,null));};exports[_0x5703('0x27')]=function(_0x329f0e,_0x13c684){if(_0x329f0e['body']['id']){delete _0x329f0e['body']['id'];}return db[_0x5703('0x2d')][_0x5703('0x4a')]({'where':{'id':_0x329f0e['params']['id']}})[_0x5703('0x28')](handleEntityNotFound(_0x13c684,null))[_0x5703('0x28')](saveUpdates(_0x329f0e[_0x5703('0x4c')],null))[_0x5703('0x28')](respondWithResult(_0x13c684,null))[_0x5703('0x46')](handleError(_0x13c684,null));};exports[_0x5703('0x29')]=function(_0x4fdbeb,_0x1d7078){return db[_0x5703('0x2d')][_0x5703('0x4a')]({'where':{'id':_0x4fdbeb[_0x5703('0x48')]['id']}})[_0x5703('0x28')](handleEntityNotFound(_0x1d7078,null))[_0x5703('0x28')](removeEntity(_0x1d7078,null))[_0x5703('0x46')](handleError(_0x1d7078,null));};exports[_0x5703('0x4d')]=function(_0x3234f5,_0x2cbdac){return db['SquareReport'][_0x5703('0x4d')]()[_0x5703('0x28')](respondWithResult(_0x2cbdac,null))[_0x5703('0x46')](handleError(_0x2cbdac,null));};