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 _0x83d0=['send','map','SquareReport','rawAttributes','fieldName','type','key','model','query','filters','intersection','fields','attributes','hasOwnProperty','nolimit','order','sort','pick','filter','merge','where','options','include','rows','catch','show','params','keys','length','includeAll','find','create','update','body','describe','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','path','sox','to-csv','ejs','lodash','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api','../../config/utils','../../config/license/util','../../mysqldb','status','end','json','count','offset','limit','set','Content-Range','apply','save','then','destroy','sendStatus','error','stack','name'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0x83d0,0xb7));var _0x083d=function(_0x812af8,_0x1b5ad3){_0x812af8=_0x812af8-0x0;var _0x307650=_0x83d0[_0x812af8];return _0x307650;};'use strict';var pdf=require(_0x083d('0x0'));var emlformat=require(_0x083d('0x1'));var rimraf=require(_0x083d('0x2'));var zipdir=require(_0x083d('0x3'));var jsonpatch=require(_0x083d('0x4'));var rp=require(_0x083d('0x5'));var moment=require('moment');var BPromise=require(_0x083d('0x6'));var Mustache=require('mustache');var util=require('util');var path=require(_0x083d('0x7'));var sox=require(_0x083d('0x8'));var csv=require(_0x083d('0x9'));var ejs=require(_0x083d('0xa'));var fs=require('fs');var _=require(_0x083d('0xb'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x083d('0xc'));var deskjs=require(_0x083d('0xd'));var toCsv=require(_0x083d('0x9'));var querystring=require('querystring');var Papa=require(_0x083d('0xe'));var Redis=require(_0x083d('0xf'));var authService=require(_0x083d('0x10'));var qs=require(_0x083d('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x083d('0x12'));var logger=require('../../config/logger')(_0x083d('0x13'));var utils=require(_0x083d('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0x083d('0x15'));var db=require(_0x083d('0x16'))['db'];function respondWithStatusCode(_0x23ccf2,_0x3e5be5){_0x3e5be5=_0x3e5be5||0xcc;return function(_0x3dfe4a){if(_0x3dfe4a){return _0x23ccf2['sendStatus'](_0x3e5be5);}return _0x23ccf2[_0x083d('0x17')](_0x3e5be5)[_0x083d('0x18')]();};}function respondWithResult(_0x4ee93c,_0x11c03f){_0x11c03f=_0x11c03f||0xc8;return function(_0x525a36){if(_0x525a36){return _0x4ee93c['status'](_0x11c03f)[_0x083d('0x19')](_0x525a36);}};}function respondWithFilteredResult(_0x3c95fe,_0x356d8e){return function(_0x20ca5f){if(_0x20ca5f){var _0x381455=_0x20ca5f[_0x083d('0x1a')],_0x4d6456=_0x356d8e[_0x083d('0x1b')],_0x2ec521=_0x356d8e[_0x083d('0x1b')]+_0x356d8e[_0x083d('0x1c')],_0x5ec496;if(_0x2ec521>=_0x381455){_0x2ec521=_0x381455;_0x5ec496=0xc8;}else{_0x5ec496=0xce;}_0x3c95fe[_0x083d('0x17')](_0x5ec496);return _0x3c95fe[_0x083d('0x1d')](_0x083d('0x1e'),_0x4d6456+'-'+_0x2ec521+'/'+_0x381455)[_0x083d('0x19')](_0x20ca5f);}return null;};}function patchUpdates(_0x160afb){return function(_0x2cb79c){try{jsonpatch[_0x083d('0x1f')](_0x2cb79c,_0x160afb,!![]);}catch(_0xb8a16f){return BPromise['reject'](_0xb8a16f);}return _0x2cb79c[_0x083d('0x20')]();};}function saveUpdates(_0x56d7f2,_0x21ac51){return function(_0x444397){if(_0x444397){return _0x444397['update'](_0x56d7f2)[_0x083d('0x21')](function(_0x4bd7c2){return _0x4bd7c2;});}return null;};}function removeEntity(_0x4efbea,_0x59828a){return function(_0xcde93c){if(_0xcde93c){return _0xcde93c[_0x083d('0x22')]()[_0x083d('0x21')](function(){_0x4efbea[_0x083d('0x17')](0xcc)[_0x083d('0x18')]();});}};}function handleEntityNotFound(_0x1b2e65,_0x5d8397){return function(_0x9e0377){if(!_0x9e0377){_0x1b2e65[_0x083d('0x23')](0x194);}return _0x9e0377;};}function handleError(_0x5e6e43,_0x3a0ce2){_0x3a0ce2=_0x3a0ce2||0x1f4;return function(_0x38ca23){logger[_0x083d('0x24')](_0x38ca23[_0x083d('0x25')]);if(_0x38ca23[_0x083d('0x26')]){delete _0x38ca23[_0x083d('0x26')];}_0x5e6e43[_0x083d('0x17')](_0x3a0ce2)[_0x083d('0x27')](_0x38ca23);};}exports['index']=function(_0x6bccbd,_0x50e5ae){var _0x2252fa={},_0x166eb7={},_0x252340={'count':0x0,'rows':[]};var _0x449ed8=_[_0x083d('0x28')](db[_0x083d('0x29')][_0x083d('0x2a')],function(_0xfbe79b){return{'name':_0xfbe79b[_0x083d('0x2b')],'type':_0xfbe79b[_0x083d('0x2c')][_0x083d('0x2d')]};});_0x166eb7[_0x083d('0x2e')]=_[_0x083d('0x28')](_0x449ed8,_0x083d('0x26'));_0x166eb7[_0x083d('0x2f')]=_['keys'](_0x6bccbd[_0x083d('0x2f')]);_0x166eb7[_0x083d('0x30')]=_['intersection'](_0x166eb7['model'],_0x166eb7[_0x083d('0x2f')]);_0x2252fa['attributes']=_[_0x083d('0x31')](_0x166eb7['model'],qs[_0x083d('0x32')](_0x6bccbd['query'][_0x083d('0x32')]));_0x2252fa[_0x083d('0x33')]=_0x2252fa[_0x083d('0x33')]['length']?_0x2252fa['attributes']:_0x166eb7[_0x083d('0x2e')];if(!_0x6bccbd['query'][_0x083d('0x34')](_0x083d('0x35'))){_0x2252fa[_0x083d('0x1c')]=qs[_0x083d('0x1c')](_0x6bccbd['query'][_0x083d('0x1c')]);_0x2252fa[_0x083d('0x1b')]=qs[_0x083d('0x1b')](_0x6bccbd[_0x083d('0x2f')]['offset']);}_0x2252fa[_0x083d('0x36')]=qs[_0x083d('0x37')](_0x6bccbd[_0x083d('0x2f')][_0x083d('0x37')]);_0x2252fa['where']=qs['filters'](_[_0x083d('0x38')](_0x6bccbd[_0x083d('0x2f')],_0x166eb7[_0x083d('0x30')]),_0x449ed8);if(_0x6bccbd[_0x083d('0x2f')][_0x083d('0x39')]){_0x2252fa['where']=_[_0x083d('0x3a')](_0x2252fa[_0x083d('0x3b')],{'$or':_['map'](_0x449ed8,function(_0x952022){if(_0x952022['type']!=='VIRTUAL'){var _0x27b2f3={};_0x27b2f3[_0x952022[_0x083d('0x26')]]={'$like':'%'+_0x6bccbd['query'][_0x083d('0x39')]+'%'};return _0x27b2f3;}})});}_0x2252fa=_[_0x083d('0x3a')]({},_0x2252fa,_0x6bccbd[_0x083d('0x3c')]);var _0x594327={'where':_0x2252fa['where']};return db['SquareReport']['count'](_0x594327)[_0x083d('0x21')](function(_0x417585){_0x252340[_0x083d('0x1a')]=_0x417585;if(_0x6bccbd[_0x083d('0x2f')]['includeAll']){_0x2252fa[_0x083d('0x3d')]=[{'all':!![]}];}return db[_0x083d('0x29')]['findAll'](_0x2252fa);})[_0x083d('0x21')](function(_0x368241){_0x252340[_0x083d('0x3e')]=_0x368241;return _0x252340;})[_0x083d('0x21')](respondWithFilteredResult(_0x50e5ae,_0x2252fa))[_0x083d('0x3f')](handleError(_0x50e5ae,null));};exports[_0x083d('0x40')]=function(_0x10cb3a,_0x30b913){var _0x4bf0c6={'raw':!![],'where':{'id':_0x10cb3a[_0x083d('0x41')]['id']}},_0x38de47={};_0x38de47[_0x083d('0x2e')]=_[_0x083d('0x42')](db[_0x083d('0x29')][_0x083d('0x2a')]);_0x38de47[_0x083d('0x2f')]=_['keys'](_0x10cb3a[_0x083d('0x2f')]);_0x38de47[_0x083d('0x30')]=_['intersection'](_0x38de47[_0x083d('0x2e')],_0x38de47[_0x083d('0x2f')]);_0x4bf0c6[_0x083d('0x33')]=_[_0x083d('0x31')](_0x38de47[_0x083d('0x2e')],qs['fields'](_0x10cb3a[_0x083d('0x2f')][_0x083d('0x32')]));_0x4bf0c6[_0x083d('0x33')]=_0x4bf0c6[_0x083d('0x33')][_0x083d('0x43')]?_0x4bf0c6['attributes']:_0x38de47[_0x083d('0x2e')];if(_0x10cb3a[_0x083d('0x2f')][_0x083d('0x44')]){_0x4bf0c6[_0x083d('0x3d')]=[{'all':!![]}];}_0x4bf0c6=_[_0x083d('0x3a')]({},_0x4bf0c6,_0x10cb3a[_0x083d('0x3c')]);return db['SquareReport'][_0x083d('0x45')](_0x4bf0c6)[_0x083d('0x21')](handleEntityNotFound(_0x30b913,null))[_0x083d('0x21')](respondWithResult(_0x30b913,null))[_0x083d('0x3f')](handleError(_0x30b913,null));};exports[_0x083d('0x46')]=function(_0x1faad5,_0x916b94){return db['SquareReport']['create'](_0x1faad5['body'],{})[_0x083d('0x21')](respondWithResult(_0x916b94,0xc9))['catch'](handleError(_0x916b94,null));};exports[_0x083d('0x47')]=function(_0x42af7d,_0x45e754){if(_0x42af7d[_0x083d('0x48')]['id']){delete _0x42af7d['body']['id'];}return db[_0x083d('0x29')][_0x083d('0x45')]({'where':{'id':_0x42af7d[_0x083d('0x41')]['id']}})[_0x083d('0x21')](handleEntityNotFound(_0x45e754,null))[_0x083d('0x21')](saveUpdates(_0x42af7d['body'],null))['then'](respondWithResult(_0x45e754,null))['catch'](handleError(_0x45e754,null));};exports[_0x083d('0x22')]=function(_0x34ed6c,_0x35b667){return db[_0x083d('0x29')][_0x083d('0x45')]({'where':{'id':_0x34ed6c[_0x083d('0x41')]['id']}})[_0x083d('0x21')](handleEntityNotFound(_0x35b667,null))[_0x083d('0x21')](removeEntity(_0x35b667,null))[_0x083d('0x3f')](handleError(_0x35b667,null));};exports['describe']=function(_0x4cb4bb,_0x33f3c8){return db['SquareReport'][_0x083d('0x49')]()[_0x083d('0x21')](respondWithResult(_0x33f3c8,null))[_0x083d('0x3f')](handleError(_0x33f3c8,null));};