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 _0xa393=['lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','limit','undefined','count','Content-Range','apply','save','then','destroy','error','stack','name','send','index','map','SquareReport','rawAttributes','key','model','query','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','type','VIRTUAL','options','includeAll','findAll','rows','catch','show','params','include','find','create','body','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','to-csv','ejs','fs-extra'];(function(_0x37b7b6,_0x165a5c){var _0x10c4c3=function(_0x16d71e){while(--_0x16d71e){_0x37b7b6['push'](_0x37b7b6['shift']());}};_0x10c4c3(++_0x165a5c);}(_0xa393,0x11f));var _0x3a39=function(_0x1f36bb,_0x8af718){_0x1f36bb=_0x1f36bb-0x0;var _0xaf97fa=_0xa393[_0x1f36bb];return _0xaf97fa;};'use strict';var emlformat=require(_0x3a39('0x0'));var rimraf=require(_0x3a39('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x3a39('0x2'));var rp=require(_0x3a39('0x3'));var moment=require(_0x3a39('0x4'));var BPromise=require(_0x3a39('0x5'));var Mustache=require('mustache');var util=require('util');var path=require('path');var sox=require('sox');var csv=require(_0x3a39('0x6'));var ejs=require(_0x3a39('0x7'));var fs=require('fs');var fs_extra=require(_0x3a39('0x8'));var _=require(_0x3a39('0x9'));var squel=require('squel');var crypto=require(_0x3a39('0xa'));var jsforce=require(_0x3a39('0xb'));var deskjs=require(_0x3a39('0xc'));var toCsv=require('to-csv');var querystring=require(_0x3a39('0xd'));var Papa=require(_0x3a39('0xe'));var Redis=require(_0x3a39('0xf'));var authService=require(_0x3a39('0x10'));var qs=require(_0x3a39('0x11'));var as=require(_0x3a39('0x12'));var hardwareService=require(_0x3a39('0x13'));var logger=require('../../config/logger')(_0x3a39('0x14'));var utils=require('../../config/utils');var config=require(_0x3a39('0x15'));var licenseUtil=require(_0x3a39('0x16'));var db=require(_0x3a39('0x17'))['db'];function respondWithStatusCode(_0x21cbcb,_0x1ec2fb){_0x1ec2fb=_0x1ec2fb||0xcc;return function(_0x27e76){if(_0x27e76){return _0x21cbcb[_0x3a39('0x18')](_0x1ec2fb);}return _0x21cbcb[_0x3a39('0x19')](_0x1ec2fb)[_0x3a39('0x1a')]();};}function respondWithResult(_0x2614a0,_0x4f1fa7){_0x4f1fa7=_0x4f1fa7||0xc8;return function(_0x588c2b){if(_0x588c2b){return _0x2614a0[_0x3a39('0x19')](_0x4f1fa7)[_0x3a39('0x1b')](_0x588c2b);}};}function respondWithFilteredResult(_0x2e1b73,_0x5c72aa){return function(_0x50abf0){if(_0x50abf0){var _0x22729e=typeof _0x5c72aa[_0x3a39('0x1c')]==='undefined'&&typeof _0x5c72aa[_0x3a39('0x1d')]===_0x3a39('0x1e');var _0x464995=_0x50abf0[_0x3a39('0x1f')];var _0x37caed=_0x22729e?0x0:_0x5c72aa[_0x3a39('0x1c')];var _0x3b98ce=_0x22729e?_0x50abf0[_0x3a39('0x1f')]:_0x5c72aa[_0x3a39('0x1c')]+_0x5c72aa[_0x3a39('0x1d')];var _0x3c60b6;if(_0x3b98ce>=_0x464995){_0x3b98ce=_0x464995;_0x3c60b6=0xc8;}else{_0x3c60b6=0xce;}_0x2e1b73[_0x3a39('0x19')](_0x3c60b6);return _0x2e1b73['set'](_0x3a39('0x20'),_0x37caed+'-'+_0x3b98ce+'/'+_0x464995)['json'](_0x50abf0);}return null;};}function patchUpdates(_0x32e1da){return function(_0x1382c3){try{jsonpatch[_0x3a39('0x21')](_0x1382c3,_0x32e1da,!![]);}catch(_0x33f9ee){return BPromise['reject'](_0x33f9ee);}return _0x1382c3[_0x3a39('0x22')]();};}function saveUpdates(_0x24815c,_0x312525){return function(_0x5524d5){if(_0x5524d5){return _0x5524d5['update'](_0x24815c)[_0x3a39('0x23')](function(_0x4d70d0){return _0x4d70d0;});}return null;};}function removeEntity(_0x6d92e,_0x410d07){return function(_0x2d9bb3){if(_0x2d9bb3){return _0x2d9bb3[_0x3a39('0x24')]()[_0x3a39('0x23')](function(){_0x6d92e[_0x3a39('0x19')](0xcc)[_0x3a39('0x1a')]();});}};}function handleEntityNotFound(_0x573a4a,_0x3df153){return function(_0x12f6b0){if(!_0x12f6b0){_0x573a4a['sendStatus'](0x194);}return _0x12f6b0;};}function handleError(_0x5bdfb5,_0x344b39){_0x344b39=_0x344b39||0x1f4;return function(_0x13c2af){logger[_0x3a39('0x25')](_0x13c2af[_0x3a39('0x26')]);if(_0x13c2af[_0x3a39('0x27')]){delete _0x13c2af['name'];}_0x5bdfb5[_0x3a39('0x19')](_0x344b39)[_0x3a39('0x28')](_0x13c2af);};}exports[_0x3a39('0x29')]=function(_0x1862f6,_0xda2053){var _0x3fea3b={},_0x285b94={},_0x4d5bf8={'count':0x0,'rows':[]};var _0x210420=_[_0x3a39('0x2a')](db[_0x3a39('0x2b')][_0x3a39('0x2c')],function(_0x5e01aa){return{'name':_0x5e01aa['fieldName'],'type':_0x5e01aa['type'][_0x3a39('0x2d')]};});_0x285b94[_0x3a39('0x2e')]=_[_0x3a39('0x2a')](_0x210420,_0x3a39('0x27'));_0x285b94[_0x3a39('0x2f')]=_[_0x3a39('0x30')](_0x1862f6[_0x3a39('0x2f')]);_0x285b94[_0x3a39('0x31')]=_[_0x3a39('0x32')](_0x285b94[_0x3a39('0x2e')],_0x285b94[_0x3a39('0x2f')]);_0x3fea3b['attributes']=_[_0x3a39('0x32')](_0x285b94[_0x3a39('0x2e')],qs[_0x3a39('0x33')](_0x1862f6[_0x3a39('0x2f')][_0x3a39('0x33')]));_0x3fea3b[_0x3a39('0x34')]=_0x3fea3b[_0x3a39('0x34')]['length']?_0x3fea3b[_0x3a39('0x34')]:_0x285b94[_0x3a39('0x2e')];if(!_0x1862f6[_0x3a39('0x2f')][_0x3a39('0x35')](_0x3a39('0x36'))){_0x3fea3b[_0x3a39('0x1d')]=qs[_0x3a39('0x1d')](_0x1862f6[_0x3a39('0x2f')][_0x3a39('0x1d')]);_0x3fea3b[_0x3a39('0x1c')]=qs[_0x3a39('0x1c')](_0x1862f6[_0x3a39('0x2f')][_0x3a39('0x1c')]);}_0x3fea3b[_0x3a39('0x37')]=qs[_0x3a39('0x38')](_0x1862f6['query'][_0x3a39('0x38')]);_0x3fea3b['where']=qs[_0x3a39('0x31')](_[_0x3a39('0x39')](_0x1862f6[_0x3a39('0x2f')],_0x285b94[_0x3a39('0x31')]),_0x210420);if(_0x1862f6[_0x3a39('0x2f')][_0x3a39('0x3a')]){_0x3fea3b[_0x3a39('0x3b')]=_[_0x3a39('0x3c')](_0x3fea3b[_0x3a39('0x3b')],{'$or':_[_0x3a39('0x2a')](_0x210420,function(_0x4a201b){if(_0x4a201b[_0x3a39('0x3d')]!==_0x3a39('0x3e')){var _0x5cb7db={};_0x5cb7db[_0x4a201b['name']]={'$like':'%'+_0x1862f6['query'][_0x3a39('0x3a')]+'%'};return _0x5cb7db;}})});}_0x3fea3b=_[_0x3a39('0x3c')]({},_0x3fea3b,_0x1862f6[_0x3a39('0x3f')]);var _0x20fdf2={'where':_0x3fea3b[_0x3a39('0x3b')]};return db[_0x3a39('0x2b')][_0x3a39('0x1f')](_0x20fdf2)[_0x3a39('0x23')](function(_0x1fcc82){_0x4d5bf8[_0x3a39('0x1f')]=_0x1fcc82;if(_0x1862f6[_0x3a39('0x2f')][_0x3a39('0x40')]){_0x3fea3b['include']=[{'all':!![]}];}return db[_0x3a39('0x2b')][_0x3a39('0x41')](_0x3fea3b);})[_0x3a39('0x23')](function(_0x14abf7){_0x4d5bf8[_0x3a39('0x42')]=_0x14abf7;return _0x4d5bf8;})[_0x3a39('0x23')](respondWithFilteredResult(_0xda2053,_0x3fea3b))[_0x3a39('0x43')](handleError(_0xda2053,null));};exports[_0x3a39('0x44')]=function(_0x5524fe,_0x3256a7){var _0x2f1041={'raw':!![],'where':{'id':_0x5524fe[_0x3a39('0x45')]['id']}},_0x49e488={};_0x49e488[_0x3a39('0x2e')]=_['keys'](db[_0x3a39('0x2b')][_0x3a39('0x2c')]);_0x49e488['query']=_[_0x3a39('0x30')](_0x5524fe[_0x3a39('0x2f')]);_0x49e488[_0x3a39('0x31')]=_['intersection'](_0x49e488[_0x3a39('0x2e')],_0x49e488[_0x3a39('0x2f')]);_0x2f1041[_0x3a39('0x34')]=_[_0x3a39('0x32')](_0x49e488[_0x3a39('0x2e')],qs[_0x3a39('0x33')](_0x5524fe[_0x3a39('0x2f')][_0x3a39('0x33')]));_0x2f1041[_0x3a39('0x34')]=_0x2f1041[_0x3a39('0x34')]['length']?_0x2f1041['attributes']:_0x49e488[_0x3a39('0x2e')];if(_0x5524fe[_0x3a39('0x2f')]['includeAll']){_0x2f1041[_0x3a39('0x46')]=[{'all':!![]}];}_0x2f1041=_[_0x3a39('0x3c')]({},_0x2f1041,_0x5524fe[_0x3a39('0x3f')]);return db['SquareReport'][_0x3a39('0x47')](_0x2f1041)[_0x3a39('0x23')](handleEntityNotFound(_0x3256a7,null))[_0x3a39('0x23')](respondWithResult(_0x3256a7,null))['catch'](handleError(_0x3256a7,null));};exports[_0x3a39('0x48')]=function(_0x10b7c2,_0x1b4b78){return db[_0x3a39('0x2b')][_0x3a39('0x48')](_0x10b7c2[_0x3a39('0x49')],{})[_0x3a39('0x23')](respondWithResult(_0x1b4b78,0xc9))['catch'](handleError(_0x1b4b78,null));};exports['update']=function(_0x226676,_0x4f3ef2){if(_0x226676[_0x3a39('0x49')]['id']){delete _0x226676['body']['id'];}return db[_0x3a39('0x2b')][_0x3a39('0x47')]({'where':{'id':_0x226676[_0x3a39('0x45')]['id']}})[_0x3a39('0x23')](handleEntityNotFound(_0x4f3ef2,null))[_0x3a39('0x23')](saveUpdates(_0x226676['body'],null))[_0x3a39('0x23')](respondWithResult(_0x4f3ef2,null))[_0x3a39('0x43')](handleError(_0x4f3ef2,null));};exports[_0x3a39('0x24')]=function(_0x1cc77d,_0x2e1d9e){return db[_0x3a39('0x2b')][_0x3a39('0x47')]({'where':{'id':_0x1cc77d[_0x3a39('0x45')]['id']}})[_0x3a39('0x23')](handleEntityNotFound(_0x2e1d9e,null))[_0x3a39('0x23')](removeEntity(_0x2e1d9e,null))['catch'](handleError(_0x2e1d9e,null));};exports['describe']=function(_0x2ce458,_0x5d295f){return db[_0x3a39('0x2b')]['describe']()[_0x3a39('0x23')](respondWithResult(_0x5d295f,null))[_0x3a39('0x43')](handleError(_0x5d295f,null));};