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 _0xd08d=['squel','crypto','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','count','offset','limit','reject','save','update','then','error','name','rawAttributes','fieldName','type','key','model','map','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','pick','filter','merge','VIRTUAL','options','where','include','SquareReport','catch','params','includeAll','find','body','destroy','describe','eml-format','rimraf','fast-json-patch','request-promise','moment','mustache','util','path','to-csv','ejs','lodash'];(function(_0x1a3017,_0x5769ff){var _0x1c0f9b=function(_0x86b1ae){while(--_0x86b1ae){_0x1a3017['push'](_0x1a3017['shift']());}};_0x1c0f9b(++_0x5769ff);}(_0xd08d,0x81));var _0xdd08=function(_0xac151d,_0x4ea1d2){_0xac151d=_0xac151d-0x0;var _0x111dba=_0xd08d[_0xac151d];return _0x111dba;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xdd08('0x0'));var rimraf=require(_0xdd08('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xdd08('0x2'));var rp=require(_0xdd08('0x3'));var moment=require(_0xdd08('0x4'));var BPromise=require('bluebird');var Mustache=require(_0xdd08('0x5'));var util=require(_0xdd08('0x6'));var path=require(_0xdd08('0x7'));var sox=require('sox');var csv=require(_0xdd08('0x8'));var ejs=require(_0xdd08('0x9'));var fs=require('fs');var _=require(_0xdd08('0xa'));var squel=require(_0xdd08('0xb'));var crypto=require(_0xdd08('0xc'));var jsforce=require('jsforce');var deskjs=require(_0xdd08('0xd'));var toCsv=require(_0xdd08('0x8'));var querystring=require(_0xdd08('0xe'));var Papa=require('papaparse');var Redis=require(_0xdd08('0xf'));var authService=require(_0xdd08('0x10'));var qs=require(_0xdd08('0x11'));var as=require(_0xdd08('0x12'));var hardwareService=require(_0xdd08('0x13'));var logger=require(_0xdd08('0x14'))(_0xdd08('0x15'));var utils=require(_0xdd08('0x16'));var config=require(_0xdd08('0x17'));var licenseUtil=require(_0xdd08('0x18'));var db=require(_0xdd08('0x19'))['db'];function respondWithStatusCode(_0x1543c8,_0x4bf79b){_0x4bf79b=_0x4bf79b||0xcc;return function(_0x2ef721){if(_0x2ef721){return _0x1543c8[_0xdd08('0x1a')](_0x4bf79b);}return _0x1543c8[_0xdd08('0x1b')](_0x4bf79b)[_0xdd08('0x1c')]();};}function respondWithResult(_0x415169,_0x3ed0d1){_0x3ed0d1=_0x3ed0d1||0xc8;return function(_0x32a6d5){if(_0x32a6d5){return _0x415169[_0xdd08('0x1b')](_0x3ed0d1)[_0xdd08('0x1d')](_0x32a6d5);}};}function respondWithFilteredResult(_0x11aad3,_0x2fc29c){return function(_0x9a6225){if(_0x9a6225){var _0x784541=_0x9a6225[_0xdd08('0x1e')],_0xe7a7c9=_0x2fc29c[_0xdd08('0x1f')],_0x46838e=_0x2fc29c[_0xdd08('0x1f')]+_0x2fc29c[_0xdd08('0x20')],_0x278f5e;if(_0x46838e>=_0x784541){_0x46838e=_0x784541;_0x278f5e=0xc8;}else{_0x278f5e=0xce;}_0x11aad3[_0xdd08('0x1b')](_0x278f5e);return _0x11aad3['set']('Content-Range',_0xe7a7c9+'-'+_0x46838e+'/'+_0x784541)[_0xdd08('0x1d')](_0x9a6225);}return null;};}function patchUpdates(_0xcdad2e){return function(_0x4d815e){try{jsonpatch['apply'](_0x4d815e,_0xcdad2e,!![]);}catch(_0x50cbe8){return BPromise[_0xdd08('0x21')](_0x50cbe8);}return _0x4d815e[_0xdd08('0x22')]();};}function saveUpdates(_0x1cfc12,_0x4a587b){return function(_0xa365f7){if(_0xa365f7){return _0xa365f7[_0xdd08('0x23')](_0x1cfc12)[_0xdd08('0x24')](function(_0x12f5d3){return _0x12f5d3;});}return null;};}function removeEntity(_0x5c9ebe,_0x4f807b){return function(_0x1ef21d){if(_0x1ef21d){return _0x1ef21d['destroy']()[_0xdd08('0x24')](function(){_0x5c9ebe[_0xdd08('0x1b')](0xcc)['end']();});}};}function handleEntityNotFound(_0x4b1be1,_0x2f3361){return function(_0x2f5007){if(!_0x2f5007){_0x4b1be1['sendStatus'](0x194);}return _0x2f5007;};}function handleError(_0x37b095,_0x53afa1){_0x53afa1=_0x53afa1||0x1f4;return function(_0x1e84d6){logger[_0xdd08('0x25')](_0x1e84d6['stack']);if(_0x1e84d6[_0xdd08('0x26')]){delete _0x1e84d6[_0xdd08('0x26')];}_0x37b095[_0xdd08('0x1b')](_0x53afa1)['send'](_0x1e84d6);};}exports['index']=function(_0x13d1ab,_0x879dcb){var _0x26cbf8={},_0x268304={},_0x3e9b2f={'count':0x0,'rows':[]};var _0x8f28d1=_['map'](db['SquareReport'][_0xdd08('0x27')],function(_0xbed010){return{'name':_0xbed010[_0xdd08('0x28')],'type':_0xbed010[_0xdd08('0x29')][_0xdd08('0x2a')]};});_0x268304[_0xdd08('0x2b')]=_[_0xdd08('0x2c')](_0x8f28d1,'name');_0x268304[_0xdd08('0x2d')]=_[_0xdd08('0x2e')](_0x13d1ab[_0xdd08('0x2d')]);_0x268304[_0xdd08('0x2f')]=_[_0xdd08('0x30')](_0x268304[_0xdd08('0x2b')],_0x268304[_0xdd08('0x2d')]);_0x26cbf8[_0xdd08('0x31')]=_['intersection'](_0x268304['model'],qs[_0xdd08('0x32')](_0x13d1ab[_0xdd08('0x2d')][_0xdd08('0x32')]));_0x26cbf8['attributes']=_0x26cbf8['attributes'][_0xdd08('0x33')]?_0x26cbf8[_0xdd08('0x31')]:_0x268304[_0xdd08('0x2b')];if(!_0x13d1ab[_0xdd08('0x2d')][_0xdd08('0x34')](_0xdd08('0x35'))){_0x26cbf8[_0xdd08('0x20')]=qs['limit'](_0x13d1ab[_0xdd08('0x2d')][_0xdd08('0x20')]);_0x26cbf8[_0xdd08('0x1f')]=qs[_0xdd08('0x1f')](_0x13d1ab[_0xdd08('0x2d')][_0xdd08('0x1f')]);}_0x26cbf8[_0xdd08('0x36')]=qs['sort'](_0x13d1ab[_0xdd08('0x2d')]['sort']);_0x26cbf8['where']=qs['filters'](_[_0xdd08('0x37')](_0x13d1ab['query'],_0x268304[_0xdd08('0x2f')]),_0x8f28d1);if(_0x13d1ab[_0xdd08('0x2d')][_0xdd08('0x38')]){_0x26cbf8['where']=_[_0xdd08('0x39')](_0x26cbf8['where'],{'$or':_[_0xdd08('0x2c')](_0x8f28d1,function(_0x50ac2b){if(_0x50ac2b[_0xdd08('0x29')]!==_0xdd08('0x3a')){var _0x182ba0={};_0x182ba0[_0x50ac2b[_0xdd08('0x26')]]={'$like':'%'+_0x13d1ab[_0xdd08('0x2d')][_0xdd08('0x38')]+'%'};return _0x182ba0;}})});}_0x26cbf8=_['merge']({},_0x26cbf8,_0x13d1ab[_0xdd08('0x3b')]);var _0x1e0573={'where':_0x26cbf8[_0xdd08('0x3c')]};return db['SquareReport']['count'](_0x1e0573)[_0xdd08('0x24')](function(_0x1dfe70){_0x3e9b2f['count']=_0x1dfe70;if(_0x13d1ab['query']['includeAll']){_0x26cbf8[_0xdd08('0x3d')]=[{'all':!![]}];}return db[_0xdd08('0x3e')]['findAll'](_0x26cbf8);})[_0xdd08('0x24')](function(_0x386950){_0x3e9b2f['rows']=_0x386950;return _0x3e9b2f;})[_0xdd08('0x24')](respondWithFilteredResult(_0x879dcb,_0x26cbf8))[_0xdd08('0x3f')](handleError(_0x879dcb,null));};exports['show']=function(_0xf740c4,_0x58f39e){var _0x4807a0={'raw':!![],'where':{'id':_0xf740c4[_0xdd08('0x40')]['id']}},_0x574034={};_0x574034[_0xdd08('0x2b')]=_[_0xdd08('0x2e')](db[_0xdd08('0x3e')][_0xdd08('0x27')]);_0x574034['query']=_[_0xdd08('0x2e')](_0xf740c4[_0xdd08('0x2d')]);_0x574034['filters']=_[_0xdd08('0x30')](_0x574034[_0xdd08('0x2b')],_0x574034['query']);_0x4807a0[_0xdd08('0x31')]=_[_0xdd08('0x30')](_0x574034[_0xdd08('0x2b')],qs[_0xdd08('0x32')](_0xf740c4[_0xdd08('0x2d')]['fields']));_0x4807a0['attributes']=_0x4807a0[_0xdd08('0x31')][_0xdd08('0x33')]?_0x4807a0[_0xdd08('0x31')]:_0x574034[_0xdd08('0x2b')];if(_0xf740c4['query'][_0xdd08('0x41')]){_0x4807a0[_0xdd08('0x3d')]=[{'all':!![]}];}_0x4807a0=_[_0xdd08('0x39')]({},_0x4807a0,_0xf740c4[_0xdd08('0x3b')]);return db[_0xdd08('0x3e')][_0xdd08('0x42')](_0x4807a0)[_0xdd08('0x24')](handleEntityNotFound(_0x58f39e,null))[_0xdd08('0x24')](respondWithResult(_0x58f39e,null))[_0xdd08('0x3f')](handleError(_0x58f39e,null));};exports['create']=function(_0x324997,_0x13ecf0){return db[_0xdd08('0x3e')]['create'](_0x324997[_0xdd08('0x43')],{})['then'](respondWithResult(_0x13ecf0,0xc9))[_0xdd08('0x3f')](handleError(_0x13ecf0,null));};exports['update']=function(_0x543dee,_0x4a6ac5){if(_0x543dee['body']['id']){delete _0x543dee[_0xdd08('0x43')]['id'];}return db[_0xdd08('0x3e')][_0xdd08('0x42')]({'where':{'id':_0x543dee[_0xdd08('0x40')]['id']}})['then'](handleEntityNotFound(_0x4a6ac5,null))[_0xdd08('0x24')](saveUpdates(_0x543dee['body'],null))[_0xdd08('0x24')](respondWithResult(_0x4a6ac5,null))[_0xdd08('0x3f')](handleError(_0x4a6ac5,null));};exports[_0xdd08('0x44')]=function(_0x78c399,_0x1d3a9e){return db[_0xdd08('0x3e')]['find']({'where':{'id':_0x78c399[_0xdd08('0x40')]['id']}})[_0xdd08('0x24')](handleEntityNotFound(_0x1d3a9e,null))[_0xdd08('0x24')](removeEntity(_0x1d3a9e,null))[_0xdd08('0x3f')](handleError(_0x1d3a9e,null));};exports[_0xdd08('0x45')]=function(_0x58d234,_0x4879cf){return db[_0xdd08('0x3e')]['describe']()[_0xdd08('0x24')](respondWithResult(_0x4879cf,null))[_0xdd08('0x3f')](handleError(_0x4879cf,null));};