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 _0xc812=['query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','VIRTUAL','options','count','include','findAll','rows','catch','show','params','includeAll','create','body','find','destroy','describe','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','util','path','to-csv','ejs','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','status','end','json','offset','limit','set','Content-Range','apply','reject','save','update','then','sendStatus','error','stack','name','send','index','map','SquareReport','rawAttributes','fieldName','type','key','model','keys'];(function(_0x3801ce,_0x12a546){var _0x8cca9b=function(_0x4f263d){while(--_0x4f263d){_0x3801ce['push'](_0x3801ce['shift']());}};_0x8cca9b(++_0x12a546);}(_0xc812,0xbc));var _0x2c81=function(_0x28dff3,_0x5d9089){_0x28dff3=_0x28dff3-0x0;var _0x51e272=_0xc812[_0x28dff3];return _0x51e272;};'use strict';var pdf=require(_0x2c81('0x0'));var emlformat=require(_0x2c81('0x1'));var rimraf=require(_0x2c81('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x2c81('0x3'));var rp=require(_0x2c81('0x4'));var moment=require(_0x2c81('0x5'));var BPromise=require(_0x2c81('0x6'));var Mustache=require('mustache');var util=require(_0x2c81('0x7'));var path=require(_0x2c81('0x8'));var sox=require('sox');var csv=require(_0x2c81('0x9'));var ejs=require(_0x2c81('0xa'));var fs=require('fs');var _=require(_0x2c81('0xb'));var squel=require(_0x2c81('0xc'));var crypto=require(_0x2c81('0xd'));var jsforce=require(_0x2c81('0xe'));var deskjs=require('desk.js');var toCsv=require(_0x2c81('0x9'));var querystring=require(_0x2c81('0xf'));var Papa=require(_0x2c81('0x10'));var Redis=require(_0x2c81('0x11'));var authService=require(_0x2c81('0x12'));var qs=require('../../components/parsers/qs');var as=require(_0x2c81('0x13'));var hardwareService=require(_0x2c81('0x14'));var logger=require(_0x2c81('0x15'))(_0x2c81('0x16'));var utils=require(_0x2c81('0x17'));var config=require(_0x2c81('0x18'));var licenseUtil=require(_0x2c81('0x19'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x22a187,_0x2270da){_0x2270da=_0x2270da||0xcc;return function(_0x5e2812){if(_0x5e2812){return _0x22a187['sendStatus'](_0x2270da);}return _0x22a187[_0x2c81('0x1a')](_0x2270da)[_0x2c81('0x1b')]();};}function respondWithResult(_0x4def60,_0x425a60){_0x425a60=_0x425a60||0xc8;return function(_0x258b0f){if(_0x258b0f){return _0x4def60[_0x2c81('0x1a')](_0x425a60)[_0x2c81('0x1c')](_0x258b0f);}};}function respondWithFilteredResult(_0x2de1ee,_0x3a51aa){return function(_0x35c42b){if(_0x35c42b){var _0x169c74=_0x35c42b['count'],_0x59ff30=_0x3a51aa[_0x2c81('0x1d')],_0x3541ea=_0x3a51aa[_0x2c81('0x1d')]+_0x3a51aa[_0x2c81('0x1e')],_0x24c35c;if(_0x3541ea>=_0x169c74){_0x3541ea=_0x169c74;_0x24c35c=0xc8;}else{_0x24c35c=0xce;}_0x2de1ee[_0x2c81('0x1a')](_0x24c35c);return _0x2de1ee[_0x2c81('0x1f')](_0x2c81('0x20'),_0x59ff30+'-'+_0x3541ea+'/'+_0x169c74)['json'](_0x35c42b);}return null;};}function patchUpdates(_0x29a2c7){return function(_0x9ec98){try{jsonpatch[_0x2c81('0x21')](_0x9ec98,_0x29a2c7,!![]);}catch(_0x7ddde6){return BPromise[_0x2c81('0x22')](_0x7ddde6);}return _0x9ec98[_0x2c81('0x23')]();};}function saveUpdates(_0x27bc2e,_0x46e141){return function(_0x5050ef){if(_0x5050ef){return _0x5050ef[_0x2c81('0x24')](_0x27bc2e)[_0x2c81('0x25')](function(_0x5e6593){return _0x5e6593;});}return null;};}function removeEntity(_0x296b46,_0x5d1d30){return function(_0x573dce){if(_0x573dce){return _0x573dce['destroy']()[_0x2c81('0x25')](function(){_0x296b46[_0x2c81('0x1a')](0xcc)[_0x2c81('0x1b')]();});}};}function handleEntityNotFound(_0x3e529f,_0x5a8980){return function(_0x3ca8bf){if(!_0x3ca8bf){_0x3e529f[_0x2c81('0x26')](0x194);}return _0x3ca8bf;};}function handleError(_0x34568e,_0x7ed8a0){_0x7ed8a0=_0x7ed8a0||0x1f4;return function(_0x309b2f){logger[_0x2c81('0x27')](_0x309b2f[_0x2c81('0x28')]);if(_0x309b2f['name']){delete _0x309b2f[_0x2c81('0x29')];}_0x34568e[_0x2c81('0x1a')](_0x7ed8a0)[_0x2c81('0x2a')](_0x309b2f);};}exports[_0x2c81('0x2b')]=function(_0xbc7426,_0x5959ab){var _0x2486fb={},_0xc98e18={},_0x2456ee={'count':0x0,'rows':[]};var _0xbf2d26=_[_0x2c81('0x2c')](db[_0x2c81('0x2d')][_0x2c81('0x2e')],function(_0x3adf97){return{'name':_0x3adf97[_0x2c81('0x2f')],'type':_0x3adf97[_0x2c81('0x30')][_0x2c81('0x31')]};});_0xc98e18[_0x2c81('0x32')]=_[_0x2c81('0x2c')](_0xbf2d26,_0x2c81('0x29'));_0xc98e18['query']=_[_0x2c81('0x33')](_0xbc7426[_0x2c81('0x34')]);_0xc98e18[_0x2c81('0x35')]=_[_0x2c81('0x36')](_0xc98e18['model'],_0xc98e18[_0x2c81('0x34')]);_0x2486fb[_0x2c81('0x37')]=_[_0x2c81('0x36')](_0xc98e18[_0x2c81('0x32')],qs[_0x2c81('0x38')](_0xbc7426[_0x2c81('0x34')][_0x2c81('0x38')]));_0x2486fb[_0x2c81('0x37')]=_0x2486fb[_0x2c81('0x37')][_0x2c81('0x39')]?_0x2486fb['attributes']:_0xc98e18['model'];if(!_0xbc7426[_0x2c81('0x34')][_0x2c81('0x3a')](_0x2c81('0x3b'))){_0x2486fb[_0x2c81('0x1e')]=qs[_0x2c81('0x1e')](_0xbc7426[_0x2c81('0x34')]['limit']);_0x2486fb[_0x2c81('0x1d')]=qs[_0x2c81('0x1d')](_0xbc7426['query']['offset']);}_0x2486fb['order']=qs[_0x2c81('0x3c')](_0xbc7426[_0x2c81('0x34')][_0x2c81('0x3c')]);_0x2486fb[_0x2c81('0x3d')]=qs[_0x2c81('0x35')](_[_0x2c81('0x3e')](_0xbc7426[_0x2c81('0x34')],_0xc98e18[_0x2c81('0x35')]),_0xbf2d26);if(_0xbc7426['query'][_0x2c81('0x3f')]){_0x2486fb[_0x2c81('0x3d')]=_[_0x2c81('0x40')](_0x2486fb[_0x2c81('0x3d')],{'$or':_[_0x2c81('0x2c')](_0xbf2d26,function(_0x221f2b){if(_0x221f2b[_0x2c81('0x30')]!==_0x2c81('0x41')){var _0x3a7884={};_0x3a7884[_0x221f2b[_0x2c81('0x29')]]={'$like':'%'+_0xbc7426[_0x2c81('0x34')][_0x2c81('0x3f')]+'%'};return _0x3a7884;}})});}_0x2486fb=_[_0x2c81('0x40')]({},_0x2486fb,_0xbc7426[_0x2c81('0x42')]);var _0x43e4ff={'where':_0x2486fb[_0x2c81('0x3d')]};return db[_0x2c81('0x2d')]['count'](_0x43e4ff)[_0x2c81('0x25')](function(_0x57a86f){_0x2456ee[_0x2c81('0x43')]=_0x57a86f;if(_0xbc7426[_0x2c81('0x34')]['includeAll']){_0x2486fb[_0x2c81('0x44')]=[{'all':!![]}];}return db['SquareReport'][_0x2c81('0x45')](_0x2486fb);})['then'](function(_0x2d812e){_0x2456ee[_0x2c81('0x46')]=_0x2d812e;return _0x2456ee;})[_0x2c81('0x25')](respondWithFilteredResult(_0x5959ab,_0x2486fb))[_0x2c81('0x47')](handleError(_0x5959ab,null));};exports[_0x2c81('0x48')]=function(_0x2c0c2e,_0x20d254){var _0x493dc8={'raw':!![],'where':{'id':_0x2c0c2e[_0x2c81('0x49')]['id']}},_0x594ead={};_0x594ead[_0x2c81('0x32')]=_[_0x2c81('0x33')](db[_0x2c81('0x2d')][_0x2c81('0x2e')]);_0x594ead[_0x2c81('0x34')]=_[_0x2c81('0x33')](_0x2c0c2e['query']);_0x594ead['filters']=_[_0x2c81('0x36')](_0x594ead[_0x2c81('0x32')],_0x594ead['query']);_0x493dc8[_0x2c81('0x37')]=_[_0x2c81('0x36')](_0x594ead[_0x2c81('0x32')],qs[_0x2c81('0x38')](_0x2c0c2e[_0x2c81('0x34')][_0x2c81('0x38')]));_0x493dc8[_0x2c81('0x37')]=_0x493dc8[_0x2c81('0x37')][_0x2c81('0x39')]?_0x493dc8[_0x2c81('0x37')]:_0x594ead[_0x2c81('0x32')];if(_0x2c0c2e[_0x2c81('0x34')][_0x2c81('0x4a')]){_0x493dc8['include']=[{'all':!![]}];}_0x493dc8=_[_0x2c81('0x40')]({},_0x493dc8,_0x2c0c2e[_0x2c81('0x42')]);return db[_0x2c81('0x2d')]['find'](_0x493dc8)[_0x2c81('0x25')](handleEntityNotFound(_0x20d254,null))['then'](respondWithResult(_0x20d254,null))[_0x2c81('0x47')](handleError(_0x20d254,null));};exports[_0x2c81('0x4b')]=function(_0x7cc606,_0x29e268){return db[_0x2c81('0x2d')][_0x2c81('0x4b')](_0x7cc606[_0x2c81('0x4c')],{})[_0x2c81('0x25')](respondWithResult(_0x29e268,0xc9))[_0x2c81('0x47')](handleError(_0x29e268,null));};exports['update']=function(_0x299f15,_0x7c08){if(_0x299f15[_0x2c81('0x4c')]['id']){delete _0x299f15['body']['id'];}return db[_0x2c81('0x2d')][_0x2c81('0x4d')]({'where':{'id':_0x299f15[_0x2c81('0x49')]['id']}})[_0x2c81('0x25')](handleEntityNotFound(_0x7c08,null))[_0x2c81('0x25')](saveUpdates(_0x299f15[_0x2c81('0x4c')],null))[_0x2c81('0x25')](respondWithResult(_0x7c08,null))[_0x2c81('0x47')](handleError(_0x7c08,null));};exports[_0x2c81('0x4e')]=function(_0x345a3c,_0x53fe5f){return db[_0x2c81('0x2d')][_0x2c81('0x4d')]({'where':{'id':_0x345a3c[_0x2c81('0x49')]['id']}})[_0x2c81('0x25')](handleEntityNotFound(_0x53fe5f,null))[_0x2c81('0x25')](removeEntity(_0x53fe5f,null))[_0x2c81('0x47')](handleError(_0x53fe5f,null));};exports[_0x2c81('0x4f')]=function(_0x152c04,_0x4d31f6){return db[_0x2c81('0x2d')][_0x2c81('0x4f')]()['then'](respondWithResult(_0x4d31f6,null))['catch'](handleError(_0x4d31f6,null));};