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 _0x2be7=['status','json','offset','undefined','limit','apply','reject','save','then','destroy','error','stack','name','send','index','map','rawAttributes','fieldName','type','key','model','query','filters','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','merge','VIRTUAL','filter','options','SquareReport','count','includeAll','findAll','rows','show','keys','intersection','fields','include','find','create','body','catch','update','params','describe','eml-format','rimraf','fast-json-patch','request-promise','mustache','path','to-csv','fs-extra','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus'];(function(_0x5e5294,_0x3fd52d){var _0x42f6be=function(_0x44fe94){while(--_0x44fe94){_0x5e5294['push'](_0x5e5294['shift']());}};_0x42f6be(++_0x3fd52d);}(_0x2be7,0x112));var _0x72be=function(_0x4fcbbe,_0x55a068){_0x4fcbbe=_0x4fcbbe-0x0;var _0x2ac729=_0x2be7[_0x4fcbbe];return _0x2ac729;};'use strict';var emlformat=require(_0x72be('0x0'));var rimraf=require(_0x72be('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x72be('0x2'));var rp=require(_0x72be('0x3'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x72be('0x4'));var util=require('util');var path=require(_0x72be('0x5'));var sox=require('sox');var csv=require(_0x72be('0x6'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x72be('0x7'));var _=require(_0x72be('0x8'));var squel=require(_0x72be('0x9'));var crypto=require(_0x72be('0xa'));var jsforce=require('jsforce');var deskjs=require(_0x72be('0xb'));var toCsv=require('to-csv');var querystring=require(_0x72be('0xc'));var Papa=require(_0x72be('0xd'));var Redis=require(_0x72be('0xe'));var authService=require('../../components/auth/service');var qs=require(_0x72be('0xf'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x72be('0x10'))(_0x72be('0x11'));var utils=require(_0x72be('0x12'));var config=require(_0x72be('0x13'));var licenseUtil=require('../../config/license/util');var db=require(_0x72be('0x14'))['db'];function respondWithStatusCode(_0xf7d6f5,_0xcbccba){_0xcbccba=_0xcbccba||0xcc;return function(_0x1b0ea5){if(_0x1b0ea5){return _0xf7d6f5[_0x72be('0x15')](_0xcbccba);}return _0xf7d6f5[_0x72be('0x16')](_0xcbccba)['end']();};}function respondWithResult(_0x4d5420,_0x37689c){_0x37689c=_0x37689c||0xc8;return function(_0xba6b31){if(_0xba6b31){return _0x4d5420[_0x72be('0x16')](_0x37689c)[_0x72be('0x17')](_0xba6b31);}};}function respondWithFilteredResult(_0x4e70c8,_0x3418a1){return function(_0x3f2bf2){if(_0x3f2bf2){var _0x2896fd=typeof _0x3418a1[_0x72be('0x18')]===_0x72be('0x19')&&typeof _0x3418a1[_0x72be('0x1a')]===_0x72be('0x19');var _0x704cc5=_0x3f2bf2['count'];var _0x3d7bac=_0x2896fd?0x0:_0x3418a1['offset'];var _0x304264=_0x2896fd?_0x3f2bf2['count']:_0x3418a1['offset']+_0x3418a1[_0x72be('0x1a')];var _0x5ae35b;if(_0x304264>=_0x704cc5){_0x304264=_0x704cc5;_0x5ae35b=0xc8;}else{_0x5ae35b=0xce;}_0x4e70c8['status'](_0x5ae35b);return _0x4e70c8['set']('Content-Range',_0x3d7bac+'-'+_0x304264+'/'+_0x704cc5)['json'](_0x3f2bf2);}return null;};}function patchUpdates(_0x57f275){return function(_0x58bf3e){try{jsonpatch[_0x72be('0x1b')](_0x58bf3e,_0x57f275,!![]);}catch(_0x84311a){return BPromise[_0x72be('0x1c')](_0x84311a);}return _0x58bf3e[_0x72be('0x1d')]();};}function saveUpdates(_0x13130a,_0x9785e2){return function(_0x3df6fd){if(_0x3df6fd){return _0x3df6fd['update'](_0x13130a)[_0x72be('0x1e')](function(_0x355a07){return _0x355a07;});}return null;};}function removeEntity(_0xd66ea2,_0x2615d8){return function(_0x5286ce){if(_0x5286ce){return _0x5286ce[_0x72be('0x1f')]()[_0x72be('0x1e')](function(){_0xd66ea2[_0x72be('0x16')](0xcc)['end']();});}};}function handleEntityNotFound(_0x3aadb7,_0x356182){return function(_0x2b2ecd){if(!_0x2b2ecd){_0x3aadb7['sendStatus'](0x194);}return _0x2b2ecd;};}function handleError(_0x17fff1,_0x154c83){_0x154c83=_0x154c83||0x1f4;return function(_0xa1e4c2){logger[_0x72be('0x20')](_0xa1e4c2[_0x72be('0x21')]);if(_0xa1e4c2['name']){delete _0xa1e4c2[_0x72be('0x22')];}_0x17fff1[_0x72be('0x16')](_0x154c83)[_0x72be('0x23')](_0xa1e4c2);};}exports[_0x72be('0x24')]=function(_0x3c9e1e,_0x1aab90){var _0x35c7fe={},_0x1787db={},_0x327541={'count':0x0,'rows':[]};var _0xf1b44b=_[_0x72be('0x25')](db['SquareReport'][_0x72be('0x26')],function(_0x2c6e5f){return{'name':_0x2c6e5f[_0x72be('0x27')],'type':_0x2c6e5f[_0x72be('0x28')][_0x72be('0x29')]};});_0x1787db[_0x72be('0x2a')]=_[_0x72be('0x25')](_0xf1b44b,'name');_0x1787db[_0x72be('0x2b')]=_['keys'](_0x3c9e1e[_0x72be('0x2b')]);_0x1787db[_0x72be('0x2c')]=_['intersection'](_0x1787db[_0x72be('0x2a')],_0x1787db[_0x72be('0x2b')]);_0x35c7fe[_0x72be('0x2d')]=_['intersection'](_0x1787db[_0x72be('0x2a')],qs['fields'](_0x3c9e1e[_0x72be('0x2b')]['fields']));_0x35c7fe['attributes']=_0x35c7fe[_0x72be('0x2d')][_0x72be('0x2e')]?_0x35c7fe[_0x72be('0x2d')]:_0x1787db['model'];if(!_0x3c9e1e['query'][_0x72be('0x2f')](_0x72be('0x30'))){_0x35c7fe[_0x72be('0x1a')]=qs[_0x72be('0x1a')](_0x3c9e1e[_0x72be('0x2b')]['limit']);_0x35c7fe[_0x72be('0x18')]=qs[_0x72be('0x18')](_0x3c9e1e[_0x72be('0x2b')]['offset']);}_0x35c7fe[_0x72be('0x31')]=qs[_0x72be('0x32')](_0x3c9e1e[_0x72be('0x2b')][_0x72be('0x32')]);_0x35c7fe[_0x72be('0x33')]=qs[_0x72be('0x2c')](_[_0x72be('0x34')](_0x3c9e1e[_0x72be('0x2b')],_0x1787db[_0x72be('0x2c')]),_0xf1b44b);if(_0x3c9e1e['query']['filter']){_0x35c7fe[_0x72be('0x33')]=_[_0x72be('0x35')](_0x35c7fe[_0x72be('0x33')],{'$or':_[_0x72be('0x25')](_0xf1b44b,function(_0x542a8a){if(_0x542a8a[_0x72be('0x28')]!==_0x72be('0x36')){var _0x7132ac={};_0x7132ac[_0x542a8a[_0x72be('0x22')]]={'$like':'%'+_0x3c9e1e[_0x72be('0x2b')][_0x72be('0x37')]+'%'};return _0x7132ac;}})});}_0x35c7fe=_[_0x72be('0x35')]({},_0x35c7fe,_0x3c9e1e[_0x72be('0x38')]);var _0x2d5766={'where':_0x35c7fe[_0x72be('0x33')]};return db[_0x72be('0x39')][_0x72be('0x3a')](_0x2d5766)['then'](function(_0x42c987){_0x327541[_0x72be('0x3a')]=_0x42c987;if(_0x3c9e1e[_0x72be('0x2b')][_0x72be('0x3b')]){_0x35c7fe['include']=[{'all':!![]}];}return db[_0x72be('0x39')][_0x72be('0x3c')](_0x35c7fe);})[_0x72be('0x1e')](function(_0x210ac4){_0x327541[_0x72be('0x3d')]=_0x210ac4;return _0x327541;})[_0x72be('0x1e')](respondWithFilteredResult(_0x1aab90,_0x35c7fe))['catch'](handleError(_0x1aab90,null));};exports[_0x72be('0x3e')]=function(_0x3c828e,_0x54dde2){var _0x1776cc={'raw':!![],'where':{'id':_0x3c828e['params']['id']}},_0x76b57={};_0x76b57['model']=_['keys'](db['SquareReport'][_0x72be('0x26')]);_0x76b57['query']=_[_0x72be('0x3f')](_0x3c828e[_0x72be('0x2b')]);_0x76b57['filters']=_['intersection'](_0x76b57[_0x72be('0x2a')],_0x76b57[_0x72be('0x2b')]);_0x1776cc['attributes']=_[_0x72be('0x40')](_0x76b57['model'],qs['fields'](_0x3c828e[_0x72be('0x2b')][_0x72be('0x41')]));_0x1776cc[_0x72be('0x2d')]=_0x1776cc[_0x72be('0x2d')][_0x72be('0x2e')]?_0x1776cc[_0x72be('0x2d')]:_0x76b57[_0x72be('0x2a')];if(_0x3c828e[_0x72be('0x2b')][_0x72be('0x3b')]){_0x1776cc[_0x72be('0x42')]=[{'all':!![]}];}_0x1776cc=_['merge']({},_0x1776cc,_0x3c828e['options']);return db[_0x72be('0x39')][_0x72be('0x43')](_0x1776cc)[_0x72be('0x1e')](handleEntityNotFound(_0x54dde2,null))[_0x72be('0x1e')](respondWithResult(_0x54dde2,null))['catch'](handleError(_0x54dde2,null));};exports['create']=function(_0x59673f,_0x5e980c){return db[_0x72be('0x39')][_0x72be('0x44')](_0x59673f[_0x72be('0x45')],{})[_0x72be('0x1e')](respondWithResult(_0x5e980c,0xc9))[_0x72be('0x46')](handleError(_0x5e980c,null));};exports[_0x72be('0x47')]=function(_0x8878b0,_0x21eaf5){if(_0x8878b0[_0x72be('0x45')]['id']){delete _0x8878b0[_0x72be('0x45')]['id'];}return db[_0x72be('0x39')][_0x72be('0x43')]({'where':{'id':_0x8878b0['params']['id']}})[_0x72be('0x1e')](handleEntityNotFound(_0x21eaf5,null))['then'](saveUpdates(_0x8878b0['body'],null))[_0x72be('0x1e')](respondWithResult(_0x21eaf5,null))['catch'](handleError(_0x21eaf5,null));};exports[_0x72be('0x1f')]=function(_0xdd5f11,_0x45ac9a){return db[_0x72be('0x39')][_0x72be('0x43')]({'where':{'id':_0xdd5f11[_0x72be('0x48')]['id']}})['then'](handleEntityNotFound(_0x45ac9a,null))[_0x72be('0x1e')](removeEntity(_0x45ac9a,null))[_0x72be('0x46')](handleError(_0x45ac9a,null));};exports[_0x72be('0x49')]=function(_0x404c7c,_0x262627){return db['SquareReport'][_0x72be('0x49')]()[_0x72be('0x1e')](respondWithResult(_0x262627,null))[_0x72be('0x46')](handleError(_0x262627,null));};