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 _0x6ec9=['limit','set','Content-Range','apply','save','update','then','destroy','stack','name','send','index','map','SquareReport','fieldName','model','query','keys','intersection','fields','attributes','length','hasOwnProperty','nolimit','sort','filters','pick','filter','type','VIRTUAL','merge','options','where','includeAll','include','findAll','catch','show','params','find','create','body','describe','eml-format','fast-json-patch','request-promise','bluebird','mustache','path','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','papaparse','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','sendStatus','status','end','json','offset','undefined','count'];(function(_0x2baddd,_0x278938){var _0x568547=function(_0x1c002f){while(--_0x1c002f){_0x2baddd['push'](_0x2baddd['shift']());}};_0x568547(++_0x278938);}(_0x6ec9,0xbb));var _0x96ec=function(_0x572690,_0x4f3410){_0x572690=_0x572690-0x0;var _0x13222c=_0x6ec9[_0x572690];return _0x13222c;};'use strict';var emlformat=require(_0x96ec('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x96ec('0x1'));var rp=require(_0x96ec('0x2'));var moment=require('moment');var BPromise=require(_0x96ec('0x3'));var Mustache=require(_0x96ec('0x4'));var util=require('util');var path=require(_0x96ec('0x5'));var sox=require(_0x96ec('0x6'));var csv=require(_0x96ec('0x7'));var ejs=require(_0x96ec('0x8'));var fs=require('fs');var fs_extra=require(_0x96ec('0x9'));var _=require('lodash');var squel=require(_0x96ec('0xa'));var crypto=require(_0x96ec('0xb'));var jsforce=require(_0x96ec('0xc'));var deskjs=require(_0x96ec('0xd'));var toCsv=require(_0x96ec('0x7'));var querystring=require('querystring');var Papa=require(_0x96ec('0xe'));var Redis=require('ioredis');var authService=require(_0x96ec('0xf'));var qs=require('../../components/parsers/qs');var as=require(_0x96ec('0x10'));var hardwareService=require(_0x96ec('0x11'));var logger=require(_0x96ec('0x12'))(_0x96ec('0x13'));var utils=require(_0x96ec('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0x96ec('0x15'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x14c751,_0x146fb6){_0x146fb6=_0x146fb6||0xcc;return function(_0x571801){if(_0x571801){return _0x14c751[_0x96ec('0x16')](_0x146fb6);}return _0x14c751[_0x96ec('0x17')](_0x146fb6)[_0x96ec('0x18')]();};}function respondWithResult(_0x57a7ba,_0x193f0d){_0x193f0d=_0x193f0d||0xc8;return function(_0x8c44cb){if(_0x8c44cb){return _0x57a7ba[_0x96ec('0x17')](_0x193f0d)[_0x96ec('0x19')](_0x8c44cb);}};}function respondWithFilteredResult(_0x476cc0,_0x380885){return function(_0x526619){if(_0x526619){var _0x2e17b1=typeof _0x380885[_0x96ec('0x1a')]===_0x96ec('0x1b')&&typeof _0x380885['limit']==='undefined';var _0x14eb2c=_0x526619[_0x96ec('0x1c')];var _0x17c2e4=_0x2e17b1?0x0:_0x380885[_0x96ec('0x1a')];var _0x1da075=_0x2e17b1?_0x526619['count']:_0x380885['offset']+_0x380885[_0x96ec('0x1d')];var _0x13c759;if(_0x1da075>=_0x14eb2c){_0x1da075=_0x14eb2c;_0x13c759=0xc8;}else{_0x13c759=0xce;}_0x476cc0[_0x96ec('0x17')](_0x13c759);return _0x476cc0[_0x96ec('0x1e')](_0x96ec('0x1f'),_0x17c2e4+'-'+_0x1da075+'/'+_0x14eb2c)[_0x96ec('0x19')](_0x526619);}return null;};}function patchUpdates(_0x172394){return function(_0x5a532f){try{jsonpatch[_0x96ec('0x20')](_0x5a532f,_0x172394,!![]);}catch(_0x552f15){return BPromise['reject'](_0x552f15);}return _0x5a532f[_0x96ec('0x21')]();};}function saveUpdates(_0x239395,_0x38cdef){return function(_0x4427c2){if(_0x4427c2){return _0x4427c2[_0x96ec('0x22')](_0x239395)[_0x96ec('0x23')](function(_0x1e424e){return _0x1e424e;});}return null;};}function removeEntity(_0x164dfd,_0x10778b){return function(_0x288cbb){if(_0x288cbb){return _0x288cbb[_0x96ec('0x24')]()[_0x96ec('0x23')](function(){_0x164dfd[_0x96ec('0x17')](0xcc)[_0x96ec('0x18')]();});}};}function handleEntityNotFound(_0x25e3c9,_0x3e4099){return function(_0x1ef784){if(!_0x1ef784){_0x25e3c9[_0x96ec('0x16')](0x194);}return _0x1ef784;};}function handleError(_0xbf59fc,_0x4be2b2){_0x4be2b2=_0x4be2b2||0x1f4;return function(_0x3cfea1){logger['error'](_0x3cfea1[_0x96ec('0x25')]);if(_0x3cfea1[_0x96ec('0x26')]){delete _0x3cfea1['name'];}_0xbf59fc[_0x96ec('0x17')](_0x4be2b2)[_0x96ec('0x27')](_0x3cfea1);};}exports[_0x96ec('0x28')]=function(_0xa5c3f0,_0x4eb474){var _0x4acd23={},_0x45caf4={},_0x284317={'count':0x0,'rows':[]};var _0x3efe52=_[_0x96ec('0x29')](db[_0x96ec('0x2a')]['rawAttributes'],function(_0x4ce061){return{'name':_0x4ce061[_0x96ec('0x2b')],'type':_0x4ce061['type']['key']};});_0x45caf4[_0x96ec('0x2c')]=_[_0x96ec('0x29')](_0x3efe52,_0x96ec('0x26'));_0x45caf4[_0x96ec('0x2d')]=_[_0x96ec('0x2e')](_0xa5c3f0['query']);_0x45caf4['filters']=_['intersection'](_0x45caf4[_0x96ec('0x2c')],_0x45caf4[_0x96ec('0x2d')]);_0x4acd23['attributes']=_[_0x96ec('0x2f')](_0x45caf4['model'],qs[_0x96ec('0x30')](_0xa5c3f0[_0x96ec('0x2d')]['fields']));_0x4acd23[_0x96ec('0x31')]=_0x4acd23['attributes'][_0x96ec('0x32')]?_0x4acd23['attributes']:_0x45caf4[_0x96ec('0x2c')];if(!_0xa5c3f0['query'][_0x96ec('0x33')](_0x96ec('0x34'))){_0x4acd23[_0x96ec('0x1d')]=qs[_0x96ec('0x1d')](_0xa5c3f0[_0x96ec('0x2d')][_0x96ec('0x1d')]);_0x4acd23[_0x96ec('0x1a')]=qs[_0x96ec('0x1a')](_0xa5c3f0[_0x96ec('0x2d')][_0x96ec('0x1a')]);}_0x4acd23['order']=qs[_0x96ec('0x35')](_0xa5c3f0['query'][_0x96ec('0x35')]);_0x4acd23['where']=qs[_0x96ec('0x36')](_[_0x96ec('0x37')](_0xa5c3f0[_0x96ec('0x2d')],_0x45caf4[_0x96ec('0x36')]),_0x3efe52);if(_0xa5c3f0[_0x96ec('0x2d')][_0x96ec('0x38')]){_0x4acd23['where']=_['merge'](_0x4acd23['where'],{'$or':_['map'](_0x3efe52,function(_0x2974ee){if(_0x2974ee[_0x96ec('0x39')]!==_0x96ec('0x3a')){var _0x3be924={};_0x3be924[_0x2974ee[_0x96ec('0x26')]]={'$like':'%'+_0xa5c3f0[_0x96ec('0x2d')][_0x96ec('0x38')]+'%'};return _0x3be924;}})});}_0x4acd23=_[_0x96ec('0x3b')]({},_0x4acd23,_0xa5c3f0[_0x96ec('0x3c')]);var _0x48f89c={'where':_0x4acd23[_0x96ec('0x3d')]};return db['SquareReport']['count'](_0x48f89c)[_0x96ec('0x23')](function(_0x27b330){_0x284317[_0x96ec('0x1c')]=_0x27b330;if(_0xa5c3f0[_0x96ec('0x2d')][_0x96ec('0x3e')]){_0x4acd23[_0x96ec('0x3f')]=[{'all':!![]}];}return db[_0x96ec('0x2a')][_0x96ec('0x40')](_0x4acd23);})[_0x96ec('0x23')](function(_0x4d1f25){_0x284317['rows']=_0x4d1f25;return _0x284317;})[_0x96ec('0x23')](respondWithFilteredResult(_0x4eb474,_0x4acd23))[_0x96ec('0x41')](handleError(_0x4eb474,null));};exports[_0x96ec('0x42')]=function(_0x5f3675,_0x59b677){var _0x249c34={'raw':!![],'where':{'id':_0x5f3675[_0x96ec('0x43')]['id']}},_0x1c86f7={};_0x1c86f7[_0x96ec('0x2c')]=_[_0x96ec('0x2e')](db[_0x96ec('0x2a')]['rawAttributes']);_0x1c86f7[_0x96ec('0x2d')]=_['keys'](_0x5f3675['query']);_0x1c86f7[_0x96ec('0x36')]=_['intersection'](_0x1c86f7[_0x96ec('0x2c')],_0x1c86f7[_0x96ec('0x2d')]);_0x249c34[_0x96ec('0x31')]=_[_0x96ec('0x2f')](_0x1c86f7[_0x96ec('0x2c')],qs[_0x96ec('0x30')](_0x5f3675['query'][_0x96ec('0x30')]));_0x249c34[_0x96ec('0x31')]=_0x249c34[_0x96ec('0x31')][_0x96ec('0x32')]?_0x249c34[_0x96ec('0x31')]:_0x1c86f7[_0x96ec('0x2c')];if(_0x5f3675[_0x96ec('0x2d')]['includeAll']){_0x249c34[_0x96ec('0x3f')]=[{'all':!![]}];}_0x249c34=_[_0x96ec('0x3b')]({},_0x249c34,_0x5f3675['options']);return db[_0x96ec('0x2a')][_0x96ec('0x44')](_0x249c34)[_0x96ec('0x23')](handleEntityNotFound(_0x59b677,null))[_0x96ec('0x23')](respondWithResult(_0x59b677,null))[_0x96ec('0x41')](handleError(_0x59b677,null));};exports[_0x96ec('0x45')]=function(_0xbf735a,_0xfcb7c3){return db[_0x96ec('0x2a')][_0x96ec('0x45')](_0xbf735a[_0x96ec('0x46')],{})[_0x96ec('0x23')](respondWithResult(_0xfcb7c3,0xc9))[_0x96ec('0x41')](handleError(_0xfcb7c3,null));};exports['update']=function(_0x4510f8,_0x1902d8){if(_0x4510f8[_0x96ec('0x46')]['id']){delete _0x4510f8[_0x96ec('0x46')]['id'];}return db['SquareReport'][_0x96ec('0x44')]({'where':{'id':_0x4510f8[_0x96ec('0x43')]['id']}})['then'](handleEntityNotFound(_0x1902d8,null))['then'](saveUpdates(_0x4510f8[_0x96ec('0x46')],null))[_0x96ec('0x23')](respondWithResult(_0x1902d8,null))['catch'](handleError(_0x1902d8,null));};exports[_0x96ec('0x24')]=function(_0x1df0d9,_0x5f24e8){return db[_0x96ec('0x2a')][_0x96ec('0x44')]({'where':{'id':_0x1df0d9['params']['id']}})[_0x96ec('0x23')](handleEntityNotFound(_0x5f24e8,null))['then'](removeEntity(_0x5f24e8,null))[_0x96ec('0x41')](handleError(_0x5f24e8,null));};exports[_0x96ec('0x47')]=function(_0x380968,_0x4dc7df){return db[_0x96ec('0x2a')][_0x96ec('0x47')]()[_0x96ec('0x23')](respondWithResult(_0x4dc7df,null))[_0x96ec('0x41')](handleError(_0x4dc7df,null));};