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 _0x1fe2=['save','then','destroy','error','stack','name','send','index','map','rawAttributes','type','model','query','keys','filters','intersection','attributes','length','hasOwnProperty','nolimit','sort','where','pick','merge','VIRTUAL','options','SquareReport','includeAll','include','findAll','rows','catch','show','params','fields','find','create','body','update','describe','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','lodash','crypto','jsforce','desk.js','papaparse','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','status','json','count','offset','limit','set','Content-Range','apply','reject'];(function(_0x1a9aa6,_0x5aa13d){var _0x3cd246=function(_0x1bd201){while(--_0x1bd201){_0x1a9aa6['push'](_0x1a9aa6['shift']());}};_0x3cd246(++_0x5aa13d);}(_0x1fe2,0x72));var _0x21fe=function(_0x2b44fa,_0x35bb63){_0x2b44fa=_0x2b44fa-0x0;var _0x476b71=_0x1fe2[_0x2b44fa];return _0x476b71;};'use strict';var emlformat=require(_0x21fe('0x0'));var rimraf=require(_0x21fe('0x1'));var zipdir=require(_0x21fe('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x21fe('0x3'));var moment=require(_0x21fe('0x4'));var BPromise=require(_0x21fe('0x5'));var Mustache=require(_0x21fe('0x6'));var util=require(_0x21fe('0x7'));var path=require('path');var sox=require(_0x21fe('0x8'));var csv=require(_0x21fe('0x9'));var ejs=require(_0x21fe('0xa'));var fs=require('fs');var fs_extra=require(_0x21fe('0xb'));var _=require(_0x21fe('0xc'));var squel=require('squel');var crypto=require(_0x21fe('0xd'));var jsforce=require(_0x21fe('0xe'));var deskjs=require(_0x21fe('0xf'));var toCsv=require(_0x21fe('0x9'));var querystring=require('querystring');var Papa=require(_0x21fe('0x10'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x21fe('0x11'));var logger=require(_0x21fe('0x12'))(_0x21fe('0x13'));var utils=require('../../config/utils');var config=require(_0x21fe('0x14'));var licenseUtil=require(_0x21fe('0x15'));var db=require(_0x21fe('0x16'))['db'];function respondWithStatusCode(_0x5cb17e,_0x257be5){_0x257be5=_0x257be5||0xcc;return function(_0xb5260e){if(_0xb5260e){return _0x5cb17e[_0x21fe('0x17')](_0x257be5);}return _0x5cb17e['status'](_0x257be5)[_0x21fe('0x18')]();};}function respondWithResult(_0x2ec17d,_0x12a383){_0x12a383=_0x12a383||0xc8;return function(_0x3edea7){if(_0x3edea7){return _0x2ec17d[_0x21fe('0x19')](_0x12a383)[_0x21fe('0x1a')](_0x3edea7);}};}function respondWithFilteredResult(_0x1fa00c,_0x38d9ab){return function(_0x5cff2a){if(_0x5cff2a){var _0x15f42c=_0x5cff2a[_0x21fe('0x1b')],_0x5f3934=_0x38d9ab[_0x21fe('0x1c')],_0x3b952f=_0x38d9ab[_0x21fe('0x1c')]+_0x38d9ab[_0x21fe('0x1d')],_0x3fa079;if(_0x3b952f>=_0x15f42c){_0x3b952f=_0x15f42c;_0x3fa079=0xc8;}else{_0x3fa079=0xce;}_0x1fa00c[_0x21fe('0x19')](_0x3fa079);return _0x1fa00c[_0x21fe('0x1e')](_0x21fe('0x1f'),_0x5f3934+'-'+_0x3b952f+'/'+_0x15f42c)['json'](_0x5cff2a);}return null;};}function patchUpdates(_0x2e0618){return function(_0x4d1801){try{jsonpatch[_0x21fe('0x20')](_0x4d1801,_0x2e0618,!![]);}catch(_0xa1f61a){return BPromise[_0x21fe('0x21')](_0xa1f61a);}return _0x4d1801[_0x21fe('0x22')]();};}function saveUpdates(_0x19fee3,_0x1e7ced){return function(_0x1a5c80){if(_0x1a5c80){return _0x1a5c80['update'](_0x19fee3)[_0x21fe('0x23')](function(_0x26ba51){return _0x26ba51;});}return null;};}function removeEntity(_0xdfcf8b,_0x17f0a7){return function(_0x244d44){if(_0x244d44){return _0x244d44[_0x21fe('0x24')]()[_0x21fe('0x23')](function(){_0xdfcf8b['status'](0xcc)[_0x21fe('0x18')]();});}};}function handleEntityNotFound(_0x2229bc,_0xc71dac){return function(_0x2a319f){if(!_0x2a319f){_0x2229bc[_0x21fe('0x17')](0x194);}return _0x2a319f;};}function handleError(_0x2fc16d,_0x465345){_0x465345=_0x465345||0x1f4;return function(_0x10729e){logger[_0x21fe('0x25')](_0x10729e[_0x21fe('0x26')]);if(_0x10729e[_0x21fe('0x27')]){delete _0x10729e[_0x21fe('0x27')];}_0x2fc16d[_0x21fe('0x19')](_0x465345)[_0x21fe('0x28')](_0x10729e);};}exports[_0x21fe('0x29')]=function(_0x53a92f,_0x33372f){var _0x394279={},_0x4ee4d6={},_0x5828dc={'count':0x0,'rows':[]};var _0x128917=_[_0x21fe('0x2a')](db['SquareReport'][_0x21fe('0x2b')],function(_0x566a97){return{'name':_0x566a97['fieldName'],'type':_0x566a97[_0x21fe('0x2c')]['key']};});_0x4ee4d6[_0x21fe('0x2d')]=_[_0x21fe('0x2a')](_0x128917,_0x21fe('0x27'));_0x4ee4d6[_0x21fe('0x2e')]=_[_0x21fe('0x2f')](_0x53a92f[_0x21fe('0x2e')]);_0x4ee4d6[_0x21fe('0x30')]=_[_0x21fe('0x31')](_0x4ee4d6[_0x21fe('0x2d')],_0x4ee4d6[_0x21fe('0x2e')]);_0x394279[_0x21fe('0x32')]=_[_0x21fe('0x31')](_0x4ee4d6[_0x21fe('0x2d')],qs['fields'](_0x53a92f[_0x21fe('0x2e')]['fields']));_0x394279[_0x21fe('0x32')]=_0x394279[_0x21fe('0x32')][_0x21fe('0x33')]?_0x394279[_0x21fe('0x32')]:_0x4ee4d6['model'];if(!_0x53a92f[_0x21fe('0x2e')][_0x21fe('0x34')](_0x21fe('0x35'))){_0x394279[_0x21fe('0x1d')]=qs[_0x21fe('0x1d')](_0x53a92f[_0x21fe('0x2e')][_0x21fe('0x1d')]);_0x394279['offset']=qs[_0x21fe('0x1c')](_0x53a92f[_0x21fe('0x2e')]['offset']);}_0x394279['order']=qs[_0x21fe('0x36')](_0x53a92f[_0x21fe('0x2e')]['sort']);_0x394279[_0x21fe('0x37')]=qs[_0x21fe('0x30')](_[_0x21fe('0x38')](_0x53a92f[_0x21fe('0x2e')],_0x4ee4d6[_0x21fe('0x30')]),_0x128917);if(_0x53a92f['query']['filter']){_0x394279[_0x21fe('0x37')]=_[_0x21fe('0x39')](_0x394279[_0x21fe('0x37')],{'$or':_[_0x21fe('0x2a')](_0x128917,function(_0x2e54fb){if(_0x2e54fb['type']!==_0x21fe('0x3a')){var _0x23f696={};_0x23f696[_0x2e54fb[_0x21fe('0x27')]]={'$like':'%'+_0x53a92f[_0x21fe('0x2e')]['filter']+'%'};return _0x23f696;}})});}_0x394279=_[_0x21fe('0x39')]({},_0x394279,_0x53a92f[_0x21fe('0x3b')]);var _0x4b8aeb={'where':_0x394279[_0x21fe('0x37')]};return db[_0x21fe('0x3c')][_0x21fe('0x1b')](_0x4b8aeb)[_0x21fe('0x23')](function(_0x220b12){_0x5828dc[_0x21fe('0x1b')]=_0x220b12;if(_0x53a92f['query'][_0x21fe('0x3d')]){_0x394279[_0x21fe('0x3e')]=[{'all':!![]}];}return db['SquareReport'][_0x21fe('0x3f')](_0x394279);})[_0x21fe('0x23')](function(_0x31b55b){_0x5828dc[_0x21fe('0x40')]=_0x31b55b;return _0x5828dc;})[_0x21fe('0x23')](respondWithFilteredResult(_0x33372f,_0x394279))[_0x21fe('0x41')](handleError(_0x33372f,null));};exports[_0x21fe('0x42')]=function(_0x2a8741,_0x46c5b8){var _0x1a1690={'raw':!![],'where':{'id':_0x2a8741[_0x21fe('0x43')]['id']}},_0x53dbaa={};_0x53dbaa[_0x21fe('0x2d')]=_[_0x21fe('0x2f')](db[_0x21fe('0x3c')]['rawAttributes']);_0x53dbaa[_0x21fe('0x2e')]=_[_0x21fe('0x2f')](_0x2a8741[_0x21fe('0x2e')]);_0x53dbaa[_0x21fe('0x30')]=_[_0x21fe('0x31')](_0x53dbaa[_0x21fe('0x2d')],_0x53dbaa['query']);_0x1a1690[_0x21fe('0x32')]=_[_0x21fe('0x31')](_0x53dbaa['model'],qs[_0x21fe('0x44')](_0x2a8741[_0x21fe('0x2e')][_0x21fe('0x44')]));_0x1a1690[_0x21fe('0x32')]=_0x1a1690['attributes'][_0x21fe('0x33')]?_0x1a1690['attributes']:_0x53dbaa['model'];if(_0x2a8741[_0x21fe('0x2e')][_0x21fe('0x3d')]){_0x1a1690['include']=[{'all':!![]}];}_0x1a1690=_[_0x21fe('0x39')]({},_0x1a1690,_0x2a8741[_0x21fe('0x3b')]);return db[_0x21fe('0x3c')][_0x21fe('0x45')](_0x1a1690)[_0x21fe('0x23')](handleEntityNotFound(_0x46c5b8,null))[_0x21fe('0x23')](respondWithResult(_0x46c5b8,null))[_0x21fe('0x41')](handleError(_0x46c5b8,null));};exports['create']=function(_0x5172d6,_0x1c154d){return db['SquareReport'][_0x21fe('0x46')](_0x5172d6[_0x21fe('0x47')],{})[_0x21fe('0x23')](respondWithResult(_0x1c154d,0xc9))['catch'](handleError(_0x1c154d,null));};exports[_0x21fe('0x48')]=function(_0x5e5e61,_0x5ed16f){if(_0x5e5e61['body']['id']){delete _0x5e5e61[_0x21fe('0x47')]['id'];}return db[_0x21fe('0x3c')][_0x21fe('0x45')]({'where':{'id':_0x5e5e61['params']['id']}})[_0x21fe('0x23')](handleEntityNotFound(_0x5ed16f,null))[_0x21fe('0x23')](saveUpdates(_0x5e5e61[_0x21fe('0x47')],null))['then'](respondWithResult(_0x5ed16f,null))['catch'](handleError(_0x5ed16f,null));};exports[_0x21fe('0x24')]=function(_0x1702fe,_0xe1643d){return db[_0x21fe('0x3c')][_0x21fe('0x45')]({'where':{'id':_0x1702fe[_0x21fe('0x43')]['id']}})[_0x21fe('0x23')](handleEntityNotFound(_0xe1643d,null))['then'](removeEntity(_0xe1643d,null))[_0x21fe('0x41')](handleError(_0xe1643d,null));};exports[_0x21fe('0x49')]=function(_0x2dc9c5,_0x16eac9){return db[_0x21fe('0x3c')][_0x21fe('0x49')]()['then'](respondWithResult(_0x16eac9,null))[_0x21fe('0x41')](handleError(_0x16eac9,null));};