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 _0xb511=['../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','count','offset','limit','set','Content-Range','json','apply','save','update','then','destroy','error','stack','name','index','SquareReport','rawAttributes','type','key','model','map','query','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','pick','filter','options','includeAll','include','findAll','rows','catch','show','params','length','merge','create','body','describe','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','bluebird','mustache','util','sox','to-csv','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service'];(function(_0x329ead,_0x368cdb){var _0x48693e=function(_0x4a25c5){while(--_0x4a25c5){_0x329ead['push'](_0x329ead['shift']());}};_0x48693e(++_0x368cdb);}(_0xb511,0x165));var _0x1b51=function(_0x53598f,_0x271ff9){_0x53598f=_0x53598f-0x0;var _0x3b3f65=_0xb511[_0x53598f];return _0x3b3f65;};'use strict';var pdf=require(_0x1b51('0x0'));var emlformat=require(_0x1b51('0x1'));var rimraf=require(_0x1b51('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x1b51('0x3'));var rp=require(_0x1b51('0x4'));var moment=require('moment');var BPromise=require(_0x1b51('0x5'));var Mustache=require(_0x1b51('0x6'));var util=require(_0x1b51('0x7'));var path=require('path');var sox=require(_0x1b51('0x8'));var csv=require(_0x1b51('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x1b51('0xa'));var squel=require(_0x1b51('0xb'));var crypto=require('crypto');var jsforce=require(_0x1b51('0xc'));var deskjs=require(_0x1b51('0xd'));var toCsv=require(_0x1b51('0x9'));var querystring=require(_0x1b51('0xe'));var Papa=require(_0x1b51('0xf'));var Redis=require(_0x1b51('0x10'));var authService=require(_0x1b51('0x11'));var qs=require(_0x1b51('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x1b51('0x13'));var logger=require(_0x1b51('0x14'))(_0x1b51('0x15'));var utils=require(_0x1b51('0x16'));var config=require(_0x1b51('0x17'));var licenseUtil=require(_0x1b51('0x18'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0xfa36a5,_0x11e29e){_0x11e29e=_0x11e29e||0xcc;return function(_0x146dc0){if(_0x146dc0){return _0xfa36a5[_0x1b51('0x19')](_0x11e29e);}return _0xfa36a5[_0x1b51('0x1a')](_0x11e29e)[_0x1b51('0x1b')]();};}function respondWithResult(_0x159c9a,_0x58a1db){_0x58a1db=_0x58a1db||0xc8;return function(_0x23f5f7){if(_0x23f5f7){return _0x159c9a['status'](_0x58a1db)['json'](_0x23f5f7);}};}function respondWithFilteredResult(_0x46b28f,_0x3c427a){return function(_0x4bfe72){if(_0x4bfe72){var _0x231475=_0x4bfe72[_0x1b51('0x1c')],_0x3ece8d=_0x3c427a[_0x1b51('0x1d')],_0x3f3850=_0x3c427a[_0x1b51('0x1d')]+_0x3c427a[_0x1b51('0x1e')],_0x4ea5e3;if(_0x3f3850>=_0x231475){_0x3f3850=_0x231475;_0x4ea5e3=0xc8;}else{_0x4ea5e3=0xce;}_0x46b28f['status'](_0x4ea5e3);return _0x46b28f[_0x1b51('0x1f')](_0x1b51('0x20'),_0x3ece8d+'-'+_0x3f3850+'/'+_0x231475)[_0x1b51('0x21')](_0x4bfe72);}return null;};}function patchUpdates(_0x556762){return function(_0x5e222b){try{jsonpatch[_0x1b51('0x22')](_0x5e222b,_0x556762,!![]);}catch(_0x3ff992){return BPromise['reject'](_0x3ff992);}return _0x5e222b[_0x1b51('0x23')]();};}function saveUpdates(_0x695f55,_0x527647){return function(_0x4f1813){if(_0x4f1813){return _0x4f1813[_0x1b51('0x24')](_0x695f55)[_0x1b51('0x25')](function(_0x15e196){return _0x15e196;});}return null;};}function removeEntity(_0x17381b,_0x5628cf){return function(_0x495173){if(_0x495173){return _0x495173[_0x1b51('0x26')]()[_0x1b51('0x25')](function(){_0x17381b['status'](0xcc)[_0x1b51('0x1b')]();});}};}function handleEntityNotFound(_0x4ba07e,_0x4a2e45){return function(_0x3d9178){if(!_0x3d9178){_0x4ba07e['sendStatus'](0x194);}return _0x3d9178;};}function handleError(_0x1eac36,_0x2a720f){_0x2a720f=_0x2a720f||0x1f4;return function(_0x54a526){logger[_0x1b51('0x27')](_0x54a526[_0x1b51('0x28')]);if(_0x54a526[_0x1b51('0x29')]){delete _0x54a526[_0x1b51('0x29')];}_0x1eac36['status'](_0x2a720f)['send'](_0x54a526);};}exports[_0x1b51('0x2a')]=function(_0x1a6c68,_0x9f3268){var _0x46797d={},_0x25cb80={},_0x23cfcd={'count':0x0,'rows':[]};var _0x19f20f=_['map'](db[_0x1b51('0x2b')][_0x1b51('0x2c')],function(_0x2162dc){return{'name':_0x2162dc['fieldName'],'type':_0x2162dc[_0x1b51('0x2d')][_0x1b51('0x2e')]};});_0x25cb80[_0x1b51('0x2f')]=_[_0x1b51('0x30')](_0x19f20f,_0x1b51('0x29'));_0x25cb80[_0x1b51('0x31')]=_[_0x1b51('0x32')](_0x1a6c68['query']);_0x25cb80[_0x1b51('0x33')]=_[_0x1b51('0x34')](_0x25cb80[_0x1b51('0x2f')],_0x25cb80[_0x1b51('0x31')]);_0x46797d[_0x1b51('0x35')]=_[_0x1b51('0x34')](_0x25cb80[_0x1b51('0x2f')],qs[_0x1b51('0x36')](_0x1a6c68[_0x1b51('0x31')]['fields']));_0x46797d[_0x1b51('0x35')]=_0x46797d[_0x1b51('0x35')]['length']?_0x46797d[_0x1b51('0x35')]:_0x25cb80['model'];if(!_0x1a6c68[_0x1b51('0x31')][_0x1b51('0x37')](_0x1b51('0x38'))){_0x46797d[_0x1b51('0x1e')]=qs['limit'](_0x1a6c68[_0x1b51('0x31')][_0x1b51('0x1e')]);_0x46797d[_0x1b51('0x1d')]=qs[_0x1b51('0x1d')](_0x1a6c68['query']['offset']);}_0x46797d[_0x1b51('0x39')]=qs[_0x1b51('0x3a')](_0x1a6c68[_0x1b51('0x31')][_0x1b51('0x3a')]);_0x46797d[_0x1b51('0x3b')]=qs['filters'](_[_0x1b51('0x3c')](_0x1a6c68[_0x1b51('0x31')],_0x25cb80[_0x1b51('0x33')]),_0x19f20f);if(_0x1a6c68[_0x1b51('0x31')][_0x1b51('0x3d')]){_0x46797d[_0x1b51('0x3b')]=_['merge'](_0x46797d[_0x1b51('0x3b')],{'$or':_[_0x1b51('0x30')](_0x19f20f,function(_0x2fbcc5){if(_0x2fbcc5[_0x1b51('0x2d')]!=='VIRTUAL'){var _0x183638={};_0x183638[_0x2fbcc5[_0x1b51('0x29')]]={'$like':'%'+_0x1a6c68[_0x1b51('0x31')][_0x1b51('0x3d')]+'%'};return _0x183638;}})});}_0x46797d=_['merge']({},_0x46797d,_0x1a6c68[_0x1b51('0x3e')]);var _0x1d3d24={'where':_0x46797d[_0x1b51('0x3b')]};return db['SquareReport']['count'](_0x1d3d24)[_0x1b51('0x25')](function(_0x5e45d8){_0x23cfcd[_0x1b51('0x1c')]=_0x5e45d8;if(_0x1a6c68['query'][_0x1b51('0x3f')]){_0x46797d[_0x1b51('0x40')]=[{'all':!![]}];}return db['SquareReport'][_0x1b51('0x41')](_0x46797d);})['then'](function(_0x2d4bac){_0x23cfcd[_0x1b51('0x42')]=_0x2d4bac;return _0x23cfcd;})[_0x1b51('0x25')](respondWithFilteredResult(_0x9f3268,_0x46797d))[_0x1b51('0x43')](handleError(_0x9f3268,null));};exports[_0x1b51('0x44')]=function(_0x14328f,_0x488c1b){var _0xab381f={'raw':!![],'where':{'id':_0x14328f[_0x1b51('0x45')]['id']}},_0x456c47={};_0x456c47[_0x1b51('0x2f')]=_[_0x1b51('0x32')](db[_0x1b51('0x2b')]['rawAttributes']);_0x456c47[_0x1b51('0x31')]=_[_0x1b51('0x32')](_0x14328f[_0x1b51('0x31')]);_0x456c47[_0x1b51('0x33')]=_[_0x1b51('0x34')](_0x456c47[_0x1b51('0x2f')],_0x456c47['query']);_0xab381f[_0x1b51('0x35')]=_[_0x1b51('0x34')](_0x456c47['model'],qs[_0x1b51('0x36')](_0x14328f[_0x1b51('0x31')][_0x1b51('0x36')]));_0xab381f[_0x1b51('0x35')]=_0xab381f[_0x1b51('0x35')][_0x1b51('0x46')]?_0xab381f[_0x1b51('0x35')]:_0x456c47[_0x1b51('0x2f')];if(_0x14328f[_0x1b51('0x31')][_0x1b51('0x3f')]){_0xab381f[_0x1b51('0x40')]=[{'all':!![]}];}_0xab381f=_[_0x1b51('0x47')]({},_0xab381f,_0x14328f[_0x1b51('0x3e')]);return db[_0x1b51('0x2b')]['find'](_0xab381f)[_0x1b51('0x25')](handleEntityNotFound(_0x488c1b,null))[_0x1b51('0x25')](respondWithResult(_0x488c1b,null))[_0x1b51('0x43')](handleError(_0x488c1b,null));};exports[_0x1b51('0x48')]=function(_0x1a15b3,_0x32079c){return db['SquareReport'][_0x1b51('0x48')](_0x1a15b3[_0x1b51('0x49')],{})[_0x1b51('0x25')](respondWithResult(_0x32079c,0xc9))[_0x1b51('0x43')](handleError(_0x32079c,null));};exports[_0x1b51('0x24')]=function(_0xcce418,_0x514fd0){if(_0xcce418[_0x1b51('0x49')]['id']){delete _0xcce418[_0x1b51('0x49')]['id'];}return db[_0x1b51('0x2b')]['find']({'where':{'id':_0xcce418[_0x1b51('0x45')]['id']}})[_0x1b51('0x25')](handleEntityNotFound(_0x514fd0,null))[_0x1b51('0x25')](saveUpdates(_0xcce418[_0x1b51('0x49')],null))[_0x1b51('0x25')](respondWithResult(_0x514fd0,null))[_0x1b51('0x43')](handleError(_0x514fd0,null));};exports[_0x1b51('0x26')]=function(_0x2d5a57,_0x53341c){return db['SquareReport']['find']({'where':{'id':_0x2d5a57[_0x1b51('0x45')]['id']}})[_0x1b51('0x25')](handleEntityNotFound(_0x53341c,null))['then'](removeEntity(_0x53341c,null))['catch'](handleError(_0x53341c,null));};exports['describe']=function(_0x440a8e,_0x3bf444){return db['SquareReport'][_0x1b51('0x4a')]()[_0x1b51('0x25')](respondWithResult(_0x3bf444,null))[_0x1b51('0x43')](handleError(_0x3bf444,null));};