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 _0x1d63=['pick','filter','type','VIRTUAL','merge','options','includeAll','include','findAll','catch','show','length','find','create','body','destroy','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','lodash','squel','jsforce','desk.js','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','count','offset','limit','set','Content-Range','json','reject','save','update','then','end','error','stack','name','index','map','SquareReport','rawAttributes','fieldName','key','model','keys','filters','intersection','query','fields','attributes','nolimit','order','sort','where'];(function(_0x1f36e9,_0x28d092){var _0x10e84b=function(_0x268d43){while(--_0x268d43){_0x1f36e9['push'](_0x1f36e9['shift']());}};_0x10e84b(++_0x28d092);}(_0x1d63,0xa4));var _0x31d6=function(_0x53ca4f,_0x466ff9){_0x53ca4f=_0x53ca4f-0x0;var _0x1666f2=_0x1d63[_0x53ca4f];return _0x1666f2;};'use strict';var pdf=require(_0x31d6('0x0'));var emlformat=require(_0x31d6('0x1'));var rimraf=require(_0x31d6('0x2'));var zipdir=require(_0x31d6('0x3'));var jsonpatch=require(_0x31d6('0x4'));var rp=require('request-promise');var moment=require(_0x31d6('0x5'));var BPromise=require(_0x31d6('0x6'));var Mustache=require(_0x31d6('0x7'));var util=require(_0x31d6('0x8'));var path=require(_0x31d6('0x9'));var sox=require(_0x31d6('0xa'));var csv=require(_0x31d6('0xb'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x31d6('0xc'));var squel=require(_0x31d6('0xd'));var crypto=require('crypto');var jsforce=require(_0x31d6('0xe'));var deskjs=require(_0x31d6('0xf'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x31d6('0x10'));var authService=require(_0x31d6('0x11'));var qs=require(_0x31d6('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x31d6('0x13'));var logger=require(_0x31d6('0x14'))(_0x31d6('0x15'));var utils=require(_0x31d6('0x16'));var config=require(_0x31d6('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0x31d6('0x18'))['db'];function respondWithStatusCode(_0x935b4f,_0x267f2b){_0x267f2b=_0x267f2b||0xcc;return function(_0x4639b8){if(_0x4639b8){return _0x935b4f[_0x31d6('0x19')](_0x267f2b);}return _0x935b4f[_0x31d6('0x1a')](_0x267f2b)['end']();};}function respondWithResult(_0x45dfa1,_0x218463){_0x218463=_0x218463||0xc8;return function(_0x6365a8){if(_0x6365a8){return _0x45dfa1[_0x31d6('0x1a')](_0x218463)['json'](_0x6365a8);}};}function respondWithFilteredResult(_0x3c047b,_0x5614f5){return function(_0x3d1f67){if(_0x3d1f67){var _0x2dc606=_0x3d1f67[_0x31d6('0x1b')],_0xd95c1a=_0x5614f5['offset'],_0x4521bb=_0x5614f5[_0x31d6('0x1c')]+_0x5614f5[_0x31d6('0x1d')],_0x189784;if(_0x4521bb>=_0x2dc606){_0x4521bb=_0x2dc606;_0x189784=0xc8;}else{_0x189784=0xce;}_0x3c047b[_0x31d6('0x1a')](_0x189784);return _0x3c047b[_0x31d6('0x1e')](_0x31d6('0x1f'),_0xd95c1a+'-'+_0x4521bb+'/'+_0x2dc606)[_0x31d6('0x20')](_0x3d1f67);}return null;};}function patchUpdates(_0x510418){return function(_0x3ea416){try{jsonpatch['apply'](_0x3ea416,_0x510418,!![]);}catch(_0x5d02e4){return BPromise[_0x31d6('0x21')](_0x5d02e4);}return _0x3ea416[_0x31d6('0x22')]();};}function saveUpdates(_0x442145,_0x83749e){return function(_0x29df2d){if(_0x29df2d){return _0x29df2d[_0x31d6('0x23')](_0x442145)[_0x31d6('0x24')](function(_0x1d0351){return _0x1d0351;});}return null;};}function removeEntity(_0x2eef78,_0x5d3e78){return function(_0x468b7d){if(_0x468b7d){return _0x468b7d['destroy']()['then'](function(){_0x2eef78[_0x31d6('0x1a')](0xcc)[_0x31d6('0x25')]();});}};}function handleEntityNotFound(_0x46b843,_0x4b836f){return function(_0x12fa6d){if(!_0x12fa6d){_0x46b843[_0x31d6('0x19')](0x194);}return _0x12fa6d;};}function handleError(_0x411159,_0x37102d){_0x37102d=_0x37102d||0x1f4;return function(_0x2552e0){logger[_0x31d6('0x26')](_0x2552e0[_0x31d6('0x27')]);if(_0x2552e0[_0x31d6('0x28')]){delete _0x2552e0[_0x31d6('0x28')];}_0x411159[_0x31d6('0x1a')](_0x37102d)['send'](_0x2552e0);};}exports[_0x31d6('0x29')]=function(_0x48fd41,_0x51cfd8){var _0x404c6a={},_0x52d7a7={},_0x234435={'count':0x0,'rows':[]};var _0x67e0a7=_[_0x31d6('0x2a')](db[_0x31d6('0x2b')][_0x31d6('0x2c')],function(_0x1d1539){return{'name':_0x1d1539[_0x31d6('0x2d')],'type':_0x1d1539['type'][_0x31d6('0x2e')]};});_0x52d7a7[_0x31d6('0x2f')]=_[_0x31d6('0x2a')](_0x67e0a7,_0x31d6('0x28'));_0x52d7a7['query']=_[_0x31d6('0x30')](_0x48fd41['query']);_0x52d7a7[_0x31d6('0x31')]=_[_0x31d6('0x32')](_0x52d7a7[_0x31d6('0x2f')],_0x52d7a7[_0x31d6('0x33')]);_0x404c6a['attributes']=_['intersection'](_0x52d7a7[_0x31d6('0x2f')],qs[_0x31d6('0x34')](_0x48fd41[_0x31d6('0x33')][_0x31d6('0x34')]));_0x404c6a[_0x31d6('0x35')]=_0x404c6a['attributes']['length']?_0x404c6a[_0x31d6('0x35')]:_0x52d7a7[_0x31d6('0x2f')];if(!_0x48fd41[_0x31d6('0x33')]['hasOwnProperty'](_0x31d6('0x36'))){_0x404c6a[_0x31d6('0x1d')]=qs['limit'](_0x48fd41[_0x31d6('0x33')][_0x31d6('0x1d')]);_0x404c6a['offset']=qs['offset'](_0x48fd41[_0x31d6('0x33')][_0x31d6('0x1c')]);}_0x404c6a[_0x31d6('0x37')]=qs[_0x31d6('0x38')](_0x48fd41[_0x31d6('0x33')][_0x31d6('0x38')]);_0x404c6a[_0x31d6('0x39')]=qs[_0x31d6('0x31')](_[_0x31d6('0x3a')](_0x48fd41['query'],_0x52d7a7[_0x31d6('0x31')]),_0x67e0a7);if(_0x48fd41[_0x31d6('0x33')][_0x31d6('0x3b')]){_0x404c6a[_0x31d6('0x39')]=_['merge'](_0x404c6a[_0x31d6('0x39')],{'$or':_['map'](_0x67e0a7,function(_0x36b98b){if(_0x36b98b[_0x31d6('0x3c')]!==_0x31d6('0x3d')){var _0x3d1fbf={};_0x3d1fbf[_0x36b98b[_0x31d6('0x28')]]={'$like':'%'+_0x48fd41[_0x31d6('0x33')][_0x31d6('0x3b')]+'%'};return _0x3d1fbf;}})});}_0x404c6a=_[_0x31d6('0x3e')]({},_0x404c6a,_0x48fd41[_0x31d6('0x3f')]);var _0xed2655={'where':_0x404c6a[_0x31d6('0x39')]};return db[_0x31d6('0x2b')][_0x31d6('0x1b')](_0xed2655)[_0x31d6('0x24')](function(_0x12bdd0){_0x234435[_0x31d6('0x1b')]=_0x12bdd0;if(_0x48fd41['query'][_0x31d6('0x40')]){_0x404c6a[_0x31d6('0x41')]=[{'all':!![]}];}return db[_0x31d6('0x2b')][_0x31d6('0x42')](_0x404c6a);})[_0x31d6('0x24')](function(_0x1430e2){_0x234435['rows']=_0x1430e2;return _0x234435;})[_0x31d6('0x24')](respondWithFilteredResult(_0x51cfd8,_0x404c6a))[_0x31d6('0x43')](handleError(_0x51cfd8,null));};exports[_0x31d6('0x44')]=function(_0x4e3655,_0x1e7c20){var _0x19dece={'raw':!![],'where':{'id':_0x4e3655['params']['id']}},_0x17ebec={};_0x17ebec[_0x31d6('0x2f')]=_[_0x31d6('0x30')](db['SquareReport']['rawAttributes']);_0x17ebec['query']=_[_0x31d6('0x30')](_0x4e3655['query']);_0x17ebec['filters']=_['intersection'](_0x17ebec['model'],_0x17ebec[_0x31d6('0x33')]);_0x19dece[_0x31d6('0x35')]=_[_0x31d6('0x32')](_0x17ebec[_0x31d6('0x2f')],qs[_0x31d6('0x34')](_0x4e3655[_0x31d6('0x33')][_0x31d6('0x34')]));_0x19dece[_0x31d6('0x35')]=_0x19dece[_0x31d6('0x35')][_0x31d6('0x45')]?_0x19dece[_0x31d6('0x35')]:_0x17ebec[_0x31d6('0x2f')];if(_0x4e3655[_0x31d6('0x33')][_0x31d6('0x40')]){_0x19dece[_0x31d6('0x41')]=[{'all':!![]}];}_0x19dece=_[_0x31d6('0x3e')]({},_0x19dece,_0x4e3655[_0x31d6('0x3f')]);return db[_0x31d6('0x2b')][_0x31d6('0x46')](_0x19dece)[_0x31d6('0x24')](handleEntityNotFound(_0x1e7c20,null))[_0x31d6('0x24')](respondWithResult(_0x1e7c20,null))['catch'](handleError(_0x1e7c20,null));};exports[_0x31d6('0x47')]=function(_0x7d4824,_0x893da5){return db[_0x31d6('0x2b')][_0x31d6('0x47')](_0x7d4824[_0x31d6('0x48')],{})[_0x31d6('0x24')](respondWithResult(_0x893da5,0xc9))[_0x31d6('0x43')](handleError(_0x893da5,null));};exports[_0x31d6('0x23')]=function(_0x486980,_0x1abbeb){if(_0x486980[_0x31d6('0x48')]['id']){delete _0x486980['body']['id'];}return db[_0x31d6('0x2b')][_0x31d6('0x46')]({'where':{'id':_0x486980['params']['id']}})['then'](handleEntityNotFound(_0x1abbeb,null))['then'](saveUpdates(_0x486980['body'],null))['then'](respondWithResult(_0x1abbeb,null))[_0x31d6('0x43')](handleError(_0x1abbeb,null));};exports[_0x31d6('0x49')]=function(_0x33c92a,_0x441258){return db[_0x31d6('0x2b')][_0x31d6('0x46')]({'where':{'id':_0x33c92a['params']['id']}})[_0x31d6('0x24')](handleEntityNotFound(_0x441258,null))[_0x31d6('0x24')](removeEntity(_0x441258,null))[_0x31d6('0x43')](handleError(_0x441258,null));};exports['describe']=function(_0x4eff26,_0x291e86){return db[_0x31d6('0x2b')]['describe']()['then'](respondWithResult(_0x291e86,null))[_0x31d6('0x43')](handleError(_0x291e86,null));};