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 _0x5c73=['stack','name','send','index','map','SquareReport','fieldName','type','key','model','query','keys','filters','attributes','fields','length','hasOwnProperty','limit','order','sort','where','filter','merge','VIRTUAL','options','count','includeAll','include','findAll','catch','show','intersection','find','body','describe','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','fs-extra','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','status','end','json','offset','undefined','set','apply','save','update','then','destroy','sendStatus','error'];(function(_0x121b92,_0x2e60eb){var _0x36cf76=function(_0x130da1){while(--_0x130da1){_0x121b92['push'](_0x121b92['shift']());}};_0x36cf76(++_0x2e60eb);}(_0x5c73,0x1d3));var _0x35c7=function(_0x35bb68,_0x336915){_0x35bb68=_0x35bb68-0x0;var _0xe54a6e=_0x5c73[_0x35bb68];return _0xe54a6e;};'use strict';var emlformat=require(_0x35c7('0x0'));var rimraf=require(_0x35c7('0x1'));var zipdir=require(_0x35c7('0x2'));var jsonpatch=require(_0x35c7('0x3'));var rp=require(_0x35c7('0x4'));var moment=require(_0x35c7('0x5'));var BPromise=require(_0x35c7('0x6'));var Mustache=require(_0x35c7('0x7'));var util=require(_0x35c7('0x8'));var path=require(_0x35c7('0x9'));var sox=require(_0x35c7('0xa'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x35c7('0xb'));var _=require('lodash');var squel=require('squel');var crypto=require(_0x35c7('0xc'));var jsforce=require(_0x35c7('0xd'));var deskjs=require(_0x35c7('0xe'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x35c7('0xf'));var Redis=require(_0x35c7('0x10'));var authService=require(_0x35c7('0x11'));var qs=require(_0x35c7('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x35c7('0x13'))(_0x35c7('0x14'));var utils=require('../../config/utils');var config=require(_0x35c7('0x15'));var licenseUtil=require(_0x35c7('0x16'));var db=require(_0x35c7('0x17'))['db'];function respondWithStatusCode(_0x1fa476,_0x449c18){_0x449c18=_0x449c18||0xcc;return function(_0x1adfcd){if(_0x1adfcd){return _0x1fa476['sendStatus'](_0x449c18);}return _0x1fa476[_0x35c7('0x18')](_0x449c18)[_0x35c7('0x19')]();};}function respondWithResult(_0x54465e,_0x215641){_0x215641=_0x215641||0xc8;return function(_0x521613){if(_0x521613){return _0x54465e[_0x35c7('0x18')](_0x215641)[_0x35c7('0x1a')](_0x521613);}};}function respondWithFilteredResult(_0x4d1f51,_0x1c3866){return function(_0x9749fe){if(_0x9749fe){var _0x20be7b=typeof _0x1c3866[_0x35c7('0x1b')]==='undefined'&&typeof _0x1c3866['limit']===_0x35c7('0x1c');var _0x35282c=_0x9749fe['count'];var _0x1fa340=_0x20be7b?0x0:_0x1c3866[_0x35c7('0x1b')];var _0x3de2bb=_0x20be7b?_0x9749fe['count']:_0x1c3866[_0x35c7('0x1b')]+_0x1c3866['limit'];var _0x2cfaf2;if(_0x3de2bb>=_0x35282c){_0x3de2bb=_0x35282c;_0x2cfaf2=0xc8;}else{_0x2cfaf2=0xce;}_0x4d1f51[_0x35c7('0x18')](_0x2cfaf2);return _0x4d1f51[_0x35c7('0x1d')]('Content-Range',_0x1fa340+'-'+_0x3de2bb+'/'+_0x35282c)[_0x35c7('0x1a')](_0x9749fe);}return null;};}function patchUpdates(_0x1e63d6){return function(_0x4e57ed){try{jsonpatch[_0x35c7('0x1e')](_0x4e57ed,_0x1e63d6,!![]);}catch(_0x1f0a35){return BPromise['reject'](_0x1f0a35);}return _0x4e57ed[_0x35c7('0x1f')]();};}function saveUpdates(_0xf4e5a4,_0x1b7758){return function(_0x420c80){if(_0x420c80){return _0x420c80[_0x35c7('0x20')](_0xf4e5a4)[_0x35c7('0x21')](function(_0x317bb2){return _0x317bb2;});}return null;};}function removeEntity(_0x3f0d12,_0x1ca2f4){return function(_0x49b1ff){if(_0x49b1ff){return _0x49b1ff[_0x35c7('0x22')]()[_0x35c7('0x21')](function(){_0x3f0d12[_0x35c7('0x18')](0xcc)[_0x35c7('0x19')]();});}};}function handleEntityNotFound(_0x43906a,_0x1a69f1){return function(_0x364c98){if(!_0x364c98){_0x43906a[_0x35c7('0x23')](0x194);}return _0x364c98;};}function handleError(_0x1bda9c,_0x1dad30){_0x1dad30=_0x1dad30||0x1f4;return function(_0x2d01e3){logger[_0x35c7('0x24')](_0x2d01e3[_0x35c7('0x25')]);if(_0x2d01e3[_0x35c7('0x26')]){delete _0x2d01e3[_0x35c7('0x26')];}_0x1bda9c[_0x35c7('0x18')](_0x1dad30)[_0x35c7('0x27')](_0x2d01e3);};}exports[_0x35c7('0x28')]=function(_0x5c3c0b,_0x5be9b6){var _0x23c59d={},_0x731377={},_0x9af01a={'count':0x0,'rows':[]};var _0x404915=_[_0x35c7('0x29')](db[_0x35c7('0x2a')]['rawAttributes'],function(_0x2af9b9){return{'name':_0x2af9b9[_0x35c7('0x2b')],'type':_0x2af9b9[_0x35c7('0x2c')][_0x35c7('0x2d')]};});_0x731377[_0x35c7('0x2e')]=_[_0x35c7('0x29')](_0x404915,'name');_0x731377[_0x35c7('0x2f')]=_[_0x35c7('0x30')](_0x5c3c0b[_0x35c7('0x2f')]);_0x731377[_0x35c7('0x31')]=_['intersection'](_0x731377['model'],_0x731377[_0x35c7('0x2f')]);_0x23c59d[_0x35c7('0x32')]=_['intersection'](_0x731377[_0x35c7('0x2e')],qs['fields'](_0x5c3c0b[_0x35c7('0x2f')][_0x35c7('0x33')]));_0x23c59d[_0x35c7('0x32')]=_0x23c59d[_0x35c7('0x32')][_0x35c7('0x34')]?_0x23c59d[_0x35c7('0x32')]:_0x731377[_0x35c7('0x2e')];if(!_0x5c3c0b[_0x35c7('0x2f')][_0x35c7('0x35')]('nolimit')){_0x23c59d['limit']=qs[_0x35c7('0x36')](_0x5c3c0b[_0x35c7('0x2f')]['limit']);_0x23c59d['offset']=qs[_0x35c7('0x1b')](_0x5c3c0b[_0x35c7('0x2f')][_0x35c7('0x1b')]);}_0x23c59d[_0x35c7('0x37')]=qs[_0x35c7('0x38')](_0x5c3c0b['query'][_0x35c7('0x38')]);_0x23c59d[_0x35c7('0x39')]=qs['filters'](_['pick'](_0x5c3c0b[_0x35c7('0x2f')],_0x731377[_0x35c7('0x31')]),_0x404915);if(_0x5c3c0b[_0x35c7('0x2f')][_0x35c7('0x3a')]){_0x23c59d['where']=_[_0x35c7('0x3b')](_0x23c59d['where'],{'$or':_['map'](_0x404915,function(_0x33d315){if(_0x33d315[_0x35c7('0x2c')]!==_0x35c7('0x3c')){var _0x414f96={};_0x414f96[_0x33d315[_0x35c7('0x26')]]={'$like':'%'+_0x5c3c0b[_0x35c7('0x2f')]['filter']+'%'};return _0x414f96;}})});}_0x23c59d=_[_0x35c7('0x3b')]({},_0x23c59d,_0x5c3c0b[_0x35c7('0x3d')]);var _0x893314={'where':_0x23c59d[_0x35c7('0x39')]};return db[_0x35c7('0x2a')][_0x35c7('0x3e')](_0x893314)[_0x35c7('0x21')](function(_0x456bd7){_0x9af01a[_0x35c7('0x3e')]=_0x456bd7;if(_0x5c3c0b[_0x35c7('0x2f')][_0x35c7('0x3f')]){_0x23c59d[_0x35c7('0x40')]=[{'all':!![]}];}return db[_0x35c7('0x2a')][_0x35c7('0x41')](_0x23c59d);})['then'](function(_0x38bc99){_0x9af01a['rows']=_0x38bc99;return _0x9af01a;})[_0x35c7('0x21')](respondWithFilteredResult(_0x5be9b6,_0x23c59d))[_0x35c7('0x42')](handleError(_0x5be9b6,null));};exports[_0x35c7('0x43')]=function(_0x43e914,_0x5101fa){var _0x1504bd={'raw':!![],'where':{'id':_0x43e914['params']['id']}},_0x253c6d={};_0x253c6d[_0x35c7('0x2e')]=_[_0x35c7('0x30')](db[_0x35c7('0x2a')]['rawAttributes']);_0x253c6d[_0x35c7('0x2f')]=_['keys'](_0x43e914[_0x35c7('0x2f')]);_0x253c6d[_0x35c7('0x31')]=_['intersection'](_0x253c6d[_0x35c7('0x2e')],_0x253c6d[_0x35c7('0x2f')]);_0x1504bd[_0x35c7('0x32')]=_[_0x35c7('0x44')](_0x253c6d['model'],qs[_0x35c7('0x33')](_0x43e914[_0x35c7('0x2f')][_0x35c7('0x33')]));_0x1504bd[_0x35c7('0x32')]=_0x1504bd['attributes'][_0x35c7('0x34')]?_0x1504bd[_0x35c7('0x32')]:_0x253c6d[_0x35c7('0x2e')];if(_0x43e914[_0x35c7('0x2f')][_0x35c7('0x3f')]){_0x1504bd[_0x35c7('0x40')]=[{'all':!![]}];}_0x1504bd=_[_0x35c7('0x3b')]({},_0x1504bd,_0x43e914[_0x35c7('0x3d')]);return db[_0x35c7('0x2a')][_0x35c7('0x45')](_0x1504bd)[_0x35c7('0x21')](handleEntityNotFound(_0x5101fa,null))[_0x35c7('0x21')](respondWithResult(_0x5101fa,null))[_0x35c7('0x42')](handleError(_0x5101fa,null));};exports['create']=function(_0x251a67,_0x3c0e8c){return db[_0x35c7('0x2a')]['create'](_0x251a67[_0x35c7('0x46')],{})['then'](respondWithResult(_0x3c0e8c,0xc9))[_0x35c7('0x42')](handleError(_0x3c0e8c,null));};exports[_0x35c7('0x20')]=function(_0x215df0,_0x258931){if(_0x215df0[_0x35c7('0x46')]['id']){delete _0x215df0[_0x35c7('0x46')]['id'];}return db[_0x35c7('0x2a')][_0x35c7('0x45')]({'where':{'id':_0x215df0['params']['id']}})[_0x35c7('0x21')](handleEntityNotFound(_0x258931,null))[_0x35c7('0x21')](saveUpdates(_0x215df0[_0x35c7('0x46')],null))[_0x35c7('0x21')](respondWithResult(_0x258931,null))['catch'](handleError(_0x258931,null));};exports[_0x35c7('0x22')]=function(_0x544af5,_0x3ddec9){return db[_0x35c7('0x2a')][_0x35c7('0x45')]({'where':{'id':_0x544af5['params']['id']}})[_0x35c7('0x21')](handleEntityNotFound(_0x3ddec9,null))[_0x35c7('0x21')](removeEntity(_0x3ddec9,null))['catch'](handleError(_0x3ddec9,null));};exports['describe']=function(_0x25322f,_0x2e52f2){return db[_0x35c7('0x2a')][_0x35c7('0x47')]()[_0x35c7('0x21')](respondWithResult(_0x2e52f2,null))[_0x35c7('0x42')](handleError(_0x2e52f2,null));};