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 _0x1d65=['fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','options','count','includeAll','include','findAll','catch','show','params','rawAttributes','find','create','body','update','describe','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','offset','limit','set','Content-Range','json','apply','reject','save','then','destroy','error','stack','name','send','index','SquareReport','fieldName','type','model','map','keys','query','filters','intersection','attributes'];(function(_0x330c5a,_0x53df10){var _0x7c6e5=function(_0xb31d34){while(--_0xb31d34){_0x330c5a['push'](_0x330c5a['shift']());}};_0x7c6e5(++_0x53df10);}(_0x1d65,0x19e));var _0x51d6=function(_0x442b31,_0x278d58){_0x442b31=_0x442b31-0x0;var _0x2c1151=_0x1d65[_0x442b31];return _0x2c1151;};'use strict';var pdf=require(_0x51d6('0x0'));var emlformat=require(_0x51d6('0x1'));var rimraf=require(_0x51d6('0x2'));var zipdir=require(_0x51d6('0x3'));var jsonpatch=require(_0x51d6('0x4'));var rp=require('request-promise');var moment=require(_0x51d6('0x5'));var BPromise=require(_0x51d6('0x6'));var Mustache=require(_0x51d6('0x7'));var util=require(_0x51d6('0x8'));var path=require(_0x51d6('0x9'));var sox=require(_0x51d6('0xa'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require('lodash');var squel=require(_0x51d6('0xb'));var crypto=require(_0x51d6('0xc'));var jsforce=require(_0x51d6('0xd'));var deskjs=require(_0x51d6('0xe'));var toCsv=require(_0x51d6('0xf'));var querystring=require(_0x51d6('0x10'));var Papa=require(_0x51d6('0x11'));var Redis=require(_0x51d6('0x12'));var authService=require(_0x51d6('0x13'));var qs=require(_0x51d6('0x14'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x51d6('0x15'))(_0x51d6('0x16'));var utils=require(_0x51d6('0x17'));var config=require(_0x51d6('0x18'));var db=require(_0x51d6('0x19'))['db'];function respondWithStatusCode(_0x159f2b,_0x29481b){_0x29481b=_0x29481b||0xcc;return function(_0x4ff562){if(_0x4ff562){return _0x159f2b[_0x51d6('0x1a')](_0x29481b);}return _0x159f2b[_0x51d6('0x1b')](_0x29481b)[_0x51d6('0x1c')]();};}function respondWithResult(_0x27cb87,_0x5f5b0e){_0x5f5b0e=_0x5f5b0e||0xc8;return function(_0x12b849){if(_0x12b849){return _0x27cb87[_0x51d6('0x1b')](_0x5f5b0e)['json'](_0x12b849);}};}function respondWithFilteredResult(_0x4d03c7,_0x98133f){return function(_0xf7db13){if(_0xf7db13){var _0x1c8135=_0xf7db13['count'],_0x28f8e6=_0x98133f[_0x51d6('0x1d')],_0x37a0e5=_0x98133f[_0x51d6('0x1d')]+_0x98133f[_0x51d6('0x1e')],_0x2e6731;if(_0x37a0e5>=_0x1c8135){_0x37a0e5=_0x1c8135;_0x2e6731=0xc8;}else{_0x2e6731=0xce;}_0x4d03c7[_0x51d6('0x1b')](_0x2e6731);return _0x4d03c7[_0x51d6('0x1f')](_0x51d6('0x20'),_0x28f8e6+'-'+_0x37a0e5+'/'+_0x1c8135)[_0x51d6('0x21')](_0xf7db13);}return null;};}function patchUpdates(_0x255876){return function(_0xe32b07){try{jsonpatch[_0x51d6('0x22')](_0xe32b07,_0x255876,!![]);}catch(_0x4cc038){return BPromise[_0x51d6('0x23')](_0x4cc038);}return _0xe32b07[_0x51d6('0x24')]();};}function saveUpdates(_0x4811ba,_0x456bd1){return function(_0xf3f7cf){if(_0xf3f7cf){return _0xf3f7cf['update'](_0x4811ba)[_0x51d6('0x25')](function(_0x2a4501){return _0x2a4501;});}return null;};}function removeEntity(_0x3cd593,_0x444280){return function(_0x47371b){if(_0x47371b){return _0x47371b[_0x51d6('0x26')]()['then'](function(){_0x3cd593[_0x51d6('0x1b')](0xcc)[_0x51d6('0x1c')]();});}};}function handleEntityNotFound(_0x3455ae,_0x4a71a5){return function(_0x31de4d){if(!_0x31de4d){_0x3455ae[_0x51d6('0x1a')](0x194);}return _0x31de4d;};}function handleError(_0x13bde0,_0x212c11){_0x212c11=_0x212c11||0x1f4;return function(_0xd67964){logger[_0x51d6('0x27')](_0xd67964[_0x51d6('0x28')]);if(_0xd67964[_0x51d6('0x29')]){delete _0xd67964[_0x51d6('0x29')];}_0x13bde0[_0x51d6('0x1b')](_0x212c11)[_0x51d6('0x2a')](_0xd67964);};}exports[_0x51d6('0x2b')]=function(_0x58cfd5,_0xa98479){var _0x54cc94={},_0x3b0eca={},_0x111c08={'count':0x0,'rows':[]};var _0x53cf28=_['map'](db[_0x51d6('0x2c')]['rawAttributes'],function(_0x1c4176){return{'name':_0x1c4176[_0x51d6('0x2d')],'type':_0x1c4176[_0x51d6('0x2e')]['key']};});_0x3b0eca[_0x51d6('0x2f')]=_[_0x51d6('0x30')](_0x53cf28,_0x51d6('0x29'));_0x3b0eca['query']=_[_0x51d6('0x31')](_0x58cfd5[_0x51d6('0x32')]);_0x3b0eca[_0x51d6('0x33')]=_[_0x51d6('0x34')](_0x3b0eca['model'],_0x3b0eca['query']);_0x54cc94[_0x51d6('0x35')]=_[_0x51d6('0x34')](_0x3b0eca[_0x51d6('0x2f')],qs[_0x51d6('0x36')](_0x58cfd5[_0x51d6('0x32')]['fields']));_0x54cc94[_0x51d6('0x35')]=_0x54cc94['attributes'][_0x51d6('0x37')]?_0x54cc94[_0x51d6('0x35')]:_0x3b0eca['model'];if(!_0x58cfd5[_0x51d6('0x32')][_0x51d6('0x38')](_0x51d6('0x39'))){_0x54cc94['limit']=qs['limit'](_0x58cfd5[_0x51d6('0x32')][_0x51d6('0x1e')]);_0x54cc94[_0x51d6('0x1d')]=qs[_0x51d6('0x1d')](_0x58cfd5[_0x51d6('0x32')][_0x51d6('0x1d')]);}_0x54cc94[_0x51d6('0x3a')]=qs[_0x51d6('0x3b')](_0x58cfd5['query'][_0x51d6('0x3b')]);_0x54cc94[_0x51d6('0x3c')]=qs[_0x51d6('0x33')](_[_0x51d6('0x3d')](_0x58cfd5['query'],_0x3b0eca[_0x51d6('0x33')]),_0x53cf28);if(_0x58cfd5[_0x51d6('0x32')][_0x51d6('0x3e')]){_0x54cc94[_0x51d6('0x3c')]=_['merge'](_0x54cc94['where'],{'$or':_['map'](_0x53cf28,function(_0x335d78){if(_0x335d78[_0x51d6('0x2e')]!=='VIRTUAL'){var _0x3808ba={};_0x3808ba[_0x335d78[_0x51d6('0x29')]]={'$like':'%'+_0x58cfd5[_0x51d6('0x32')][_0x51d6('0x3e')]+'%'};return _0x3808ba;}})});}_0x54cc94=_[_0x51d6('0x3f')]({},_0x54cc94,_0x58cfd5[_0x51d6('0x40')]);var _0x19bcc8={'where':_0x54cc94['where']};return db[_0x51d6('0x2c')][_0x51d6('0x41')](_0x19bcc8)[_0x51d6('0x25')](function(_0x53da1f){_0x111c08['count']=_0x53da1f;if(_0x58cfd5[_0x51d6('0x32')][_0x51d6('0x42')]){_0x54cc94[_0x51d6('0x43')]=[{'all':!![]}];}return db[_0x51d6('0x2c')][_0x51d6('0x44')](_0x54cc94);})[_0x51d6('0x25')](function(_0x174a3b){_0x111c08['rows']=_0x174a3b;return _0x111c08;})[_0x51d6('0x25')](respondWithFilteredResult(_0xa98479,_0x54cc94))[_0x51d6('0x45')](handleError(_0xa98479,null));};exports[_0x51d6('0x46')]=function(_0x266a44,_0x5691ad){var _0x25b08a={'raw':!![],'where':{'id':_0x266a44[_0x51d6('0x47')]['id']}},_0x3aa6c9={};_0x3aa6c9[_0x51d6('0x2f')]=_[_0x51d6('0x31')](db[_0x51d6('0x2c')][_0x51d6('0x48')]);_0x3aa6c9[_0x51d6('0x32')]=_[_0x51d6('0x31')](_0x266a44[_0x51d6('0x32')]);_0x3aa6c9['filters']=_[_0x51d6('0x34')](_0x3aa6c9[_0x51d6('0x2f')],_0x3aa6c9[_0x51d6('0x32')]);_0x25b08a['attributes']=_[_0x51d6('0x34')](_0x3aa6c9['model'],qs[_0x51d6('0x36')](_0x266a44['query'][_0x51d6('0x36')]));_0x25b08a[_0x51d6('0x35')]=_0x25b08a[_0x51d6('0x35')][_0x51d6('0x37')]?_0x25b08a['attributes']:_0x3aa6c9[_0x51d6('0x2f')];if(_0x266a44[_0x51d6('0x32')][_0x51d6('0x42')]){_0x25b08a[_0x51d6('0x43')]=[{'all':!![]}];}_0x25b08a=_[_0x51d6('0x3f')]({},_0x25b08a,_0x266a44[_0x51d6('0x40')]);return db[_0x51d6('0x2c')][_0x51d6('0x49')](_0x25b08a)[_0x51d6('0x25')](handleEntityNotFound(_0x5691ad,null))['then'](respondWithResult(_0x5691ad,null))[_0x51d6('0x45')](handleError(_0x5691ad,null));};exports['create']=function(_0x1f2843,_0x2e34e0){return db[_0x51d6('0x2c')][_0x51d6('0x4a')](_0x1f2843[_0x51d6('0x4b')],{})[_0x51d6('0x25')](respondWithResult(_0x2e34e0,0xc9))[_0x51d6('0x45')](handleError(_0x2e34e0,null));};exports[_0x51d6('0x4c')]=function(_0x7774cc,_0x55c5f0){if(_0x7774cc[_0x51d6('0x4b')]['id']){delete _0x7774cc[_0x51d6('0x4b')]['id'];}return db[_0x51d6('0x2c')][_0x51d6('0x49')]({'where':{'id':_0x7774cc['params']['id']}})[_0x51d6('0x25')](handleEntityNotFound(_0x55c5f0,null))['then'](saveUpdates(_0x7774cc[_0x51d6('0x4b')],null))[_0x51d6('0x25')](respondWithResult(_0x55c5f0,null))[_0x51d6('0x45')](handleError(_0x55c5f0,null));};exports['destroy']=function(_0x5e5c8f,_0x47ba5f){return db[_0x51d6('0x2c')][_0x51d6('0x49')]({'where':{'id':_0x5e5c8f[_0x51d6('0x47')]['id']}})['then'](handleEntityNotFound(_0x47ba5f,null))[_0x51d6('0x25')](removeEntity(_0x47ba5f,null))['catch'](handleError(_0x47ba5f,null));};exports[_0x51d6('0x4d')]=function(_0x20b006,_0x18db5d){return db[_0x51d6('0x2c')][_0x51d6('0x4d')]()[_0x51d6('0x25')](respondWithResult(_0x18db5d,null))['catch'](handleError(_0x18db5d,null));};