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 _0x0f1d=['../../components/parsers/qs','../../config/logger','api','../../mysqldb','sendStatus','status','offset','limit','set','Content-Range','apply','reject','update','then','destroy','end','error','stack','index','SquareReport','model','keys','query','dateStart','dateEnd','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','pick','add','day','merge','where','filter','options','count','include','findAll','rows','catch','params','find','create','body','describe','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','path','sox','to-csv','ejs','lodash','crypto','jsforce','querystring','papaparse'];(function(_0x321bb2,_0x202794){var _0x9c12ed=function(_0x263dd3){while(--_0x263dd3){_0x321bb2['push'](_0x321bb2['shift']());}};_0x9c12ed(++_0x202794);}(_0x0f1d,0xbb));var _0xd0f1=function(_0x4b7d02,_0xf0be5){_0x4b7d02=_0x4b7d02-0x0;var _0x5f409e=_0x0f1d[_0x4b7d02];return _0x5f409e;};'use strict';var pdf=require(_0xd0f1('0x0'));var emlformat=require(_0xd0f1('0x1'));var rimraf=require(_0xd0f1('0x2'));var zipdir=require(_0xd0f1('0x3'));var jsonpatch=require(_0xd0f1('0x4'));var rp=require(_0xd0f1('0x5'));var moment=require(_0xd0f1('0x6'));var BPromise=require(_0xd0f1('0x7'));var Mustache=require('mustache');var util=require('util');var path=require(_0xd0f1('0x8'));var sox=require(_0xd0f1('0x9'));var csv=require(_0xd0f1('0xa'));var ejs=require(_0xd0f1('0xb'));var fs=require('fs');var _=require(_0xd0f1('0xc'));var squel=require('squel');var crypto=require(_0xd0f1('0xd'));var jsforce=require(_0xd0f1('0xe'));var deskjs=require('desk.js');var toCsv=require(_0xd0f1('0xa'));var querystring=require(_0xd0f1('0xf'));var Papa=require(_0xd0f1('0x10'));var qs=require(_0xd0f1('0x11'));var logger=require(_0xd0f1('0x12'))(_0xd0f1('0x13'));var utils=require('../../config/utils');var config=require('../../config/environment');var db=require(_0xd0f1('0x14'))['db'];function respondWithStatusCode(_0xc5e4f1,_0x390905){_0x390905=_0x390905||0xcc;return function(_0x44f313){if(_0x44f313){return _0xc5e4f1[_0xd0f1('0x15')](_0x390905);}return _0xc5e4f1[_0xd0f1('0x16')](_0x390905)['end']();};}function respondWithResult(_0x37d05f,_0x285e8b){_0x285e8b=_0x285e8b||0xc8;return function(_0x4ae6d4){if(_0x4ae6d4){return _0x37d05f['status'](_0x285e8b)['json'](_0x4ae6d4);}};}function respondWithFilteredResult(_0x30661d,_0x3f442b){return function(_0x1aa63d){if(_0x1aa63d){var _0x27cd24=_0x1aa63d['count'],_0x438195=_0x3f442b[_0xd0f1('0x17')],_0x5878d0=_0x3f442b[_0xd0f1('0x17')]+_0x3f442b[_0xd0f1('0x18')],_0x3850f3;if(_0x5878d0>=_0x27cd24){_0x5878d0=_0x27cd24;_0x3850f3=0xc8;}else{_0x3850f3=0xce;}_0x30661d['status'](_0x3850f3);return _0x30661d[_0xd0f1('0x19')](_0xd0f1('0x1a'),_0x438195+'-'+_0x5878d0+'/'+_0x27cd24)['json'](_0x1aa63d);}return null;};}function patchUpdates(_0xd5ac9f){return function(_0x8b192b){try{jsonpatch[_0xd0f1('0x1b')](_0x8b192b,_0xd5ac9f,!![]);}catch(_0xb44a84){return BPromise[_0xd0f1('0x1c')](_0xb44a84);}return _0x8b192b['save']();};}function saveUpdates(_0x4c788d,_0x1221a1){return function(_0x152022){if(_0x152022){return _0x152022[_0xd0f1('0x1d')](_0x4c788d)[_0xd0f1('0x1e')](function(_0x27cd2b){return _0x27cd2b;});}return null;};}function removeEntity(_0x19e19c,_0x505ddc){return function(_0x54915c){if(_0x54915c){return _0x54915c[_0xd0f1('0x1f')]()[_0xd0f1('0x1e')](function(){_0x19e19c['status'](0xcc)[_0xd0f1('0x20')]();});}};}function handleEntityNotFound(_0x368836,_0x40fb07){return function(_0x30d4fd){if(!_0x30d4fd){_0x368836['sendStatus'](0x194);}return _0x30d4fd;};}function handleError(_0xeef36b,_0x3433f9){_0x3433f9=_0x3433f9||0x1f4;return function(_0x87c8b2){logger[_0xd0f1('0x21')](_0x87c8b2[_0xd0f1('0x22')]);if(_0x87c8b2['name']){delete _0x87c8b2['name'];}_0xeef36b[_0xd0f1('0x16')](_0x3433f9)['send'](_0x87c8b2);};}exports[_0xd0f1('0x23')]=function(_0x3755dd,_0x428630){var _0x23ffa2={},_0x5acf31={},_0x4ae8a1={'count':0x0,'rows':[]};var _0x233f0a=db[_0xd0f1('0x24')]['rawAttributes'];_0x5acf31[_0xd0f1('0x25')]=_[_0xd0f1('0x26')](_0x233f0a);var _0x562086={'dateStart':_0x3755dd[_0xd0f1('0x27')][_0xd0f1('0x28')],'dateEnd':_0x3755dd[_0xd0f1('0x27')][_0xd0f1('0x29')]};delete _0x3755dd[_0xd0f1('0x27')][_0xd0f1('0x28')];delete _0x3755dd[_0xd0f1('0x27')]['dateEnd'];_0x5acf31[_0xd0f1('0x27')]=_[_0xd0f1('0x26')](_0x3755dd['query']);_0x5acf31[_0xd0f1('0x2a')]=_[_0xd0f1('0x2b')](_0x5acf31[_0xd0f1('0x25')],_0x5acf31[_0xd0f1('0x27')]);_0x23ffa2[_0xd0f1('0x2c')]=_[_0xd0f1('0x2b')](_0x5acf31[_0xd0f1('0x25')],qs[_0xd0f1('0x2d')](_0x3755dd[_0xd0f1('0x27')][_0xd0f1('0x2d')]));_0x23ffa2[_0xd0f1('0x2c')]=_0x23ffa2[_0xd0f1('0x2c')][_0xd0f1('0x2e')]?_0x23ffa2[_0xd0f1('0x2c')]:_0x5acf31[_0xd0f1('0x25')];if(!_0x3755dd['query'][_0xd0f1('0x2f')](_0xd0f1('0x30'))){_0x23ffa2['limit']=qs[_0xd0f1('0x18')](_0x3755dd['query'][_0xd0f1('0x18')]);_0x23ffa2[_0xd0f1('0x17')]=qs[_0xd0f1('0x17')](_0x3755dd[_0xd0f1('0x27')]['offset']);}_0x23ffa2[_0xd0f1('0x31')]=qs['sort'](_0x3755dd[_0xd0f1('0x27')][_0xd0f1('0x32')]);_0x23ffa2['where']=qs[_0xd0f1('0x2a')](_[_0xd0f1('0x33')](_0x3755dd[_0xd0f1('0x27')],_0x5acf31['filters']));if(_0x562086[_0xd0f1('0x28')]){if(_0x562086[_0xd0f1('0x29')]){_0x562086[_0xd0f1('0x29')]=moment(_0x562086[_0xd0f1('0x29')])[_0xd0f1('0x34')](0x1,_0xd0f1('0x35'));}else{_0x562086[_0xd0f1('0x29')]=moment(_0x562086[_0xd0f1('0x28')])['add'](0x1,_0xd0f1('0x35'));}_[_0xd0f1('0x36')](_0x23ffa2[_0xd0f1('0x37')],{'createdAt':{'$gte':_0x562086[_0xd0f1('0x28')],'$lte':_0x562086[_0xd0f1('0x29')]}});}if(_0x3755dd[_0xd0f1('0x27')][_0xd0f1('0x38')]){_0x23ffa2['where']=_['merge'](_0x23ffa2[_0xd0f1('0x37')],{'$or':_['map'](_0x23ffa2[_0xd0f1('0x2c')],function(_0x3d03c7){var _0x450a8a={};_0x450a8a[_0x3d03c7]={'$like':'%'+_0x3755dd[_0xd0f1('0x27')][_0xd0f1('0x38')]+'%'};return _0x450a8a;})});}_0x23ffa2=_[_0xd0f1('0x36')]({},_0x23ffa2,_0x3755dd[_0xd0f1('0x39')]);var _0x4e5b21={'where':_0x23ffa2['where']};return db[_0xd0f1('0x24')][_0xd0f1('0x3a')](_0x4e5b21)[_0xd0f1('0x1e')](function(_0x3f8996){_0x4ae8a1[_0xd0f1('0x3a')]=_0x3f8996;if(_0x3755dd[_0xd0f1('0x27')]['includeAll']){_0x23ffa2[_0xd0f1('0x3b')]=[{'all':!![]}];}return db[_0xd0f1('0x24')][_0xd0f1('0x3c')](_0x23ffa2);})[_0xd0f1('0x1e')](function(_0x25d3af){_0x4ae8a1[_0xd0f1('0x3d')]=_0x25d3af;return _0x4ae8a1;})[_0xd0f1('0x1e')](respondWithFilteredResult(_0x428630,_0x23ffa2))[_0xd0f1('0x3e')](handleError(_0x428630,null));};exports['show']=function(_0x216382,_0x308df9){var _0xe48eb4={'raw':!![],'where':{'id':_0x216382[_0xd0f1('0x3f')]['id']}},_0x8d5fdc={};_0x8d5fdc['model']=_[_0xd0f1('0x26')](db[_0xd0f1('0x24')]['rawAttributes']);_0x8d5fdc[_0xd0f1('0x27')]=_[_0xd0f1('0x26')](_0x216382[_0xd0f1('0x27')]);_0x8d5fdc[_0xd0f1('0x2a')]=_[_0xd0f1('0x2b')](_0x8d5fdc[_0xd0f1('0x25')],_0x8d5fdc[_0xd0f1('0x27')]);_0xe48eb4[_0xd0f1('0x2c')]=_[_0xd0f1('0x2b')](_0x8d5fdc[_0xd0f1('0x25')],qs[_0xd0f1('0x2d')](_0x216382[_0xd0f1('0x27')][_0xd0f1('0x2d')]));_0xe48eb4[_0xd0f1('0x2c')]=_0xe48eb4[_0xd0f1('0x2c')]['length']?_0xe48eb4['attributes']:_0x8d5fdc[_0xd0f1('0x25')];if(_0x216382[_0xd0f1('0x27')]['includeAll']){_0xe48eb4['include']=[{'all':!![]}];}_0xe48eb4=_['merge']({},_0xe48eb4,_0x216382[_0xd0f1('0x39')]);return db['SquareReport'][_0xd0f1('0x40')](_0xe48eb4)['then'](handleEntityNotFound(_0x308df9,null))[_0xd0f1('0x1e')](respondWithResult(_0x308df9,null))[_0xd0f1('0x3e')](handleError(_0x308df9,null));};exports[_0xd0f1('0x41')]=function(_0x7d3dd,_0xd5e3fe){return db[_0xd0f1('0x24')]['create'](_0x7d3dd[_0xd0f1('0x42')],{})['then'](respondWithResult(_0xd5e3fe,0xc9))['catch'](handleError(_0xd5e3fe,null));};exports[_0xd0f1('0x1d')]=function(_0x53e3de,_0x14519a){if(_0x53e3de[_0xd0f1('0x42')]['id']){delete _0x53e3de[_0xd0f1('0x42')]['id'];}return db[_0xd0f1('0x24')][_0xd0f1('0x40')]({'where':{'id':_0x53e3de[_0xd0f1('0x3f')]['id']}})['then'](handleEntityNotFound(_0x14519a,null))['then'](saveUpdates(_0x53e3de['body'],null))[_0xd0f1('0x1e')](respondWithResult(_0x14519a,null))[_0xd0f1('0x3e')](handleError(_0x14519a,null));};exports[_0xd0f1('0x1f')]=function(_0x5928af,_0x453dba){return db[_0xd0f1('0x24')][_0xd0f1('0x40')]({'where':{'id':_0x5928af['params']['id']}})[_0xd0f1('0x1e')](handleEntityNotFound(_0x453dba,null))[_0xd0f1('0x1e')](removeEntity(_0x453dba,null))['catch'](handleError(_0x453dba,null));};exports[_0xd0f1('0x43')]=function(_0x5a6880,_0x587b6c){return db[_0xd0f1('0x24')][_0xd0f1('0x43')]()[_0xd0f1('0x1e')](respondWithResult(_0x587b6c,null))['catch'](handleError(_0x587b6c,null));};