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 _0x229c=['ejs','squel','crypto','desk.js','to-csv','ioredis','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','count','offset','set','Content-Range','apply','save','destroy','then','error','stack','name','send','index','map','SquareReport','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','hasOwnProperty','nolimit','limit','order','sort','where','pick','filter','options','includeAll','include','findAll','rows','catch','show','params','fields','length','merge','create','body','update','find','eml-format','fast-json-patch','bluebird','util','path','sox'];(function(_0x77b868,_0x45ea4b){var _0x1f54ea=function(_0x3cb8a6){while(--_0x3cb8a6){_0x77b868['push'](_0x77b868['shift']());}};_0x1f54ea(++_0x45ea4b);}(_0x229c,0xcf));var _0xc229=function(_0x3f7a4b,_0x24f6d7){_0x3f7a4b=_0x3f7a4b-0x0;var _0x55648b=_0x229c[_0x3f7a4b];return _0x55648b;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xc229('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xc229('0x1'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0xc229('0x2'));var Mustache=require('mustache');var util=require(_0xc229('0x3'));var path=require(_0xc229('0x4'));var sox=require(_0xc229('0x5'));var csv=require('to-csv');var ejs=require(_0xc229('0x6'));var fs=require('fs');var _=require('lodash');var squel=require(_0xc229('0x7'));var crypto=require(_0xc229('0x8'));var jsforce=require('jsforce');var deskjs=require(_0xc229('0x9'));var toCsv=require(_0xc229('0xa'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0xc229('0xb'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0xc229('0xc'));var hardwareService=require(_0xc229('0xd'));var logger=require(_0xc229('0xe'))(_0xc229('0xf'));var utils=require(_0xc229('0x10'));var config=require(_0xc229('0x11'));var licenseUtil=require(_0xc229('0x12'));var db=require(_0xc229('0x13'))['db'];function respondWithStatusCode(_0xf7cd15,_0x337ae0){_0x337ae0=_0x337ae0||0xcc;return function(_0x1faf37){if(_0x1faf37){return _0xf7cd15[_0xc229('0x14')](_0x337ae0);}return _0xf7cd15[_0xc229('0x15')](_0x337ae0)['end']();};}function respondWithResult(_0x36cfb4,_0x53ba7a){_0x53ba7a=_0x53ba7a||0xc8;return function(_0x6dd4c2){if(_0x6dd4c2){return _0x36cfb4[_0xc229('0x15')](_0x53ba7a)[_0xc229('0x16')](_0x6dd4c2);}};}function respondWithFilteredResult(_0x1cc8ed,_0x1d9efd){return function(_0x7b71c3){if(_0x7b71c3){var _0x292f30=_0x7b71c3[_0xc229('0x17')],_0x2bc9ea=_0x1d9efd[_0xc229('0x18')],_0x569bdd=_0x1d9efd[_0xc229('0x18')]+_0x1d9efd['limit'],_0x3c3b1c;if(_0x569bdd>=_0x292f30){_0x569bdd=_0x292f30;_0x3c3b1c=0xc8;}else{_0x3c3b1c=0xce;}_0x1cc8ed[_0xc229('0x15')](_0x3c3b1c);return _0x1cc8ed[_0xc229('0x19')](_0xc229('0x1a'),_0x2bc9ea+'-'+_0x569bdd+'/'+_0x292f30)[_0xc229('0x16')](_0x7b71c3);}return null;};}function patchUpdates(_0x3b5c2b){return function(_0x14ef5e){try{jsonpatch[_0xc229('0x1b')](_0x14ef5e,_0x3b5c2b,!![]);}catch(_0x49c4aa){return BPromise['reject'](_0x49c4aa);}return _0x14ef5e[_0xc229('0x1c')]();};}function saveUpdates(_0x53dbba,_0x46b7b0){return function(_0x235605){if(_0x235605){return _0x235605['update'](_0x53dbba)['then'](function(_0x208e64){return _0x208e64;});}return null;};}function removeEntity(_0x40d549,_0x3a9957){return function(_0x3b20af){if(_0x3b20af){return _0x3b20af[_0xc229('0x1d')]()[_0xc229('0x1e')](function(){_0x40d549[_0xc229('0x15')](0xcc)['end']();});}};}function handleEntityNotFound(_0x5cb52f,_0x8c4f83){return function(_0xe55ddf){if(!_0xe55ddf){_0x5cb52f['sendStatus'](0x194);}return _0xe55ddf;};}function handleError(_0x5400f7,_0x100ffd){_0x100ffd=_0x100ffd||0x1f4;return function(_0x30c711){logger[_0xc229('0x1f')](_0x30c711[_0xc229('0x20')]);if(_0x30c711[_0xc229('0x21')]){delete _0x30c711[_0xc229('0x21')];}_0x5400f7['status'](_0x100ffd)[_0xc229('0x22')](_0x30c711);};}exports[_0xc229('0x23')]=function(_0x42e7f2,_0x537033){var _0x524908={},_0x155a51={},_0x52f0e6={'count':0x0,'rows':[]};var _0x3dfbc9=_[_0xc229('0x24')](db[_0xc229('0x25')][_0xc229('0x26')],function(_0xfa1ba2){return{'name':_0xfa1ba2[_0xc229('0x27')],'type':_0xfa1ba2[_0xc229('0x28')][_0xc229('0x29')]};});_0x155a51[_0xc229('0x2a')]=_[_0xc229('0x24')](_0x3dfbc9,_0xc229('0x21'));_0x155a51[_0xc229('0x2b')]=_[_0xc229('0x2c')](_0x42e7f2[_0xc229('0x2b')]);_0x155a51[_0xc229('0x2d')]=_[_0xc229('0x2e')](_0x155a51[_0xc229('0x2a')],_0x155a51[_0xc229('0x2b')]);_0x524908[_0xc229('0x2f')]=_[_0xc229('0x2e')](_0x155a51[_0xc229('0x2a')],qs['fields'](_0x42e7f2[_0xc229('0x2b')]['fields']));_0x524908[_0xc229('0x2f')]=_0x524908[_0xc229('0x2f')]['length']?_0x524908[_0xc229('0x2f')]:_0x155a51[_0xc229('0x2a')];if(!_0x42e7f2[_0xc229('0x2b')][_0xc229('0x30')](_0xc229('0x31'))){_0x524908[_0xc229('0x32')]=qs['limit'](_0x42e7f2[_0xc229('0x2b')][_0xc229('0x32')]);_0x524908[_0xc229('0x18')]=qs[_0xc229('0x18')](_0x42e7f2[_0xc229('0x2b')][_0xc229('0x18')]);}_0x524908[_0xc229('0x33')]=qs[_0xc229('0x34')](_0x42e7f2[_0xc229('0x2b')][_0xc229('0x34')]);_0x524908[_0xc229('0x35')]=qs['filters'](_[_0xc229('0x36')](_0x42e7f2[_0xc229('0x2b')],_0x155a51[_0xc229('0x2d')]),_0x3dfbc9);if(_0x42e7f2['query'][_0xc229('0x37')]){_0x524908[_0xc229('0x35')]=_['merge'](_0x524908['where'],{'$or':_[_0xc229('0x24')](_0x3dfbc9,function(_0x4eafbd){if(_0x4eafbd['type']!=='VIRTUAL'){var _0x290c25={};_0x290c25[_0x4eafbd['name']]={'$like':'%'+_0x42e7f2['query'][_0xc229('0x37')]+'%'};return _0x290c25;}})});}_0x524908=_['merge']({},_0x524908,_0x42e7f2[_0xc229('0x38')]);var _0x3f0008={'where':_0x524908[_0xc229('0x35')]};return db[_0xc229('0x25')][_0xc229('0x17')](_0x3f0008)['then'](function(_0x82b760){_0x52f0e6['count']=_0x82b760;if(_0x42e7f2[_0xc229('0x2b')][_0xc229('0x39')]){_0x524908[_0xc229('0x3a')]=[{'all':!![]}];}return db[_0xc229('0x25')][_0xc229('0x3b')](_0x524908);})[_0xc229('0x1e')](function(_0x47d54f){_0x52f0e6[_0xc229('0x3c')]=_0x47d54f;return _0x52f0e6;})[_0xc229('0x1e')](respondWithFilteredResult(_0x537033,_0x524908))[_0xc229('0x3d')](handleError(_0x537033,null));};exports[_0xc229('0x3e')]=function(_0x36c730,_0x48e504){var _0x553fa8={'raw':!![],'where':{'id':_0x36c730[_0xc229('0x3f')]['id']}},_0xac6500={};_0xac6500[_0xc229('0x2a')]=_[_0xc229('0x2c')](db['SquareReport'][_0xc229('0x26')]);_0xac6500[_0xc229('0x2b')]=_[_0xc229('0x2c')](_0x36c730[_0xc229('0x2b')]);_0xac6500[_0xc229('0x2d')]=_[_0xc229('0x2e')](_0xac6500[_0xc229('0x2a')],_0xac6500['query']);_0x553fa8['attributes']=_[_0xc229('0x2e')](_0xac6500[_0xc229('0x2a')],qs[_0xc229('0x40')](_0x36c730[_0xc229('0x2b')][_0xc229('0x40')]));_0x553fa8[_0xc229('0x2f')]=_0x553fa8[_0xc229('0x2f')][_0xc229('0x41')]?_0x553fa8[_0xc229('0x2f')]:_0xac6500[_0xc229('0x2a')];if(_0x36c730['query'][_0xc229('0x39')]){_0x553fa8['include']=[{'all':!![]}];}_0x553fa8=_[_0xc229('0x42')]({},_0x553fa8,_0x36c730[_0xc229('0x38')]);return db[_0xc229('0x25')]['find'](_0x553fa8)[_0xc229('0x1e')](handleEntityNotFound(_0x48e504,null))['then'](respondWithResult(_0x48e504,null))[_0xc229('0x3d')](handleError(_0x48e504,null));};exports[_0xc229('0x43')]=function(_0x43817e,_0x4deb08){return db[_0xc229('0x25')][_0xc229('0x43')](_0x43817e[_0xc229('0x44')],{})[_0xc229('0x1e')](respondWithResult(_0x4deb08,0xc9))[_0xc229('0x3d')](handleError(_0x4deb08,null));};exports[_0xc229('0x45')]=function(_0xee1aa1,_0x3b57a1){if(_0xee1aa1[_0xc229('0x44')]['id']){delete _0xee1aa1[_0xc229('0x44')]['id'];}return db[_0xc229('0x25')][_0xc229('0x46')]({'where':{'id':_0xee1aa1[_0xc229('0x3f')]['id']}})[_0xc229('0x1e')](handleEntityNotFound(_0x3b57a1,null))[_0xc229('0x1e')](saveUpdates(_0xee1aa1[_0xc229('0x44')],null))[_0xc229('0x1e')](respondWithResult(_0x3b57a1,null))[_0xc229('0x3d')](handleError(_0x3b57a1,null));};exports[_0xc229('0x1d')]=function(_0x4559a1,_0x49aeba){return db['SquareReport'][_0xc229('0x46')]({'where':{'id':_0x4559a1[_0xc229('0x3f')]['id']}})[_0xc229('0x1e')](handleEntityNotFound(_0x49aeba,null))[_0xc229('0x1e')](removeEntity(_0x49aeba,null))['catch'](handleError(_0x49aeba,null));};exports['describe']=function(_0x23dd48,_0x518d63){return db[_0xc229('0x25')]['describe']()[_0xc229('0x1e')](respondWithResult(_0x518d63,null))[_0xc229('0x3d')](handleError(_0x518d63,null));};