Thanasis Naskos / CUREX - Knowledge Extraction Analytics - KEA

XlsiemController.php 2.84 KB
edit raw blame history 
  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
<?php

namespace App\Http\Controllers\V1\Partners;

use App\Http\Controllers\Controller;
use App\Http\Requests\XlsiemRequest;
use Carbon\Carbon;
use Illuminate\Support\Facades\DB;
use Salman\Mqtt\Facades\Mqtt;

class XlsiemController extends Controller
{
    public function store(XlsiemRequest $request)
    {
        $dbEvents = [];
        $eventAlarms = [];
        foreach ($request->get('event_alarm') as $ev) {
            $dbEvents[] = [
                'asset_id' => $request->get('asset_id'),
                'event_alarm_id' => $ev['event_alarm_id'],
                'event_alarm_char' => $ev['event_alarm_char'],
                'name' => isset($ev['name']) ? $ev['name'] : null,
                'time' => Carbon::createFromTimestamp($request->get('timestamp')),
                'source_ip' => $ev['source_ip'],
                'source_port' => isset($ev['source_port']) ? $ev['source_port'] : null,
                'destination_ip' => $ev['destination_ip'],
                'destination_port' => isset($ev['destination_port']) ? $ev['destination_port'] : null,
                'priority' => isset($ev['priority']) ? $ev['priority'] : null,
                'confidence' => isset($ev['confidence']) ? $ev['confidence'] : null,
            ];
            $eventAlarms[] = [
                'event_alarm_id' => $ev['event_alarm_id'],
                'event_alarm_char' => $ev['event_alarm_char'],
                'name' => isset($ev['name']) ? $ev['name'] : null,
                'source_ip' => $ev['source_ip'],
                'source_port' => isset($ev['source_port']) ? $ev['source_port'] : null,
                'destination_ip' => $ev['destination_ip'],
                'destination_port' => isset($ev['destination_port']) ? $ev['destination_port'] : null,
                'priority' => isset($ev['priority']) ? $ev['priority'] : null,
                'confidence' => isset($ev['confidence']) ? $ev['confidence'] : null
            ];
        }
        $mqttEvents = array(
        	'asset_id' => $request->get('asset_id'),
        	'timestamp' => Carbon::createFromTimestamp($request->get('timestamp')),
        	'event_alarm' => $eventAlarms
        );
        

        // publish to MQTT Broker
        //Mqtt::ConnectAndPublish('xlsiem/event', json_encode($mqttEvents), $request->user()->id);
        Mqtt::ConnectAndPublish('xlsiem/event', json_encode($mqttEvents), 1);
        DB::table('xlsiem')->insert($dbEvents);

        return response()->json(['success' => 'success'], 200);
    }

    public function get()
    {
        return DB::table('xlsiem')->select([
            'asset_id',
            'event_alarm_id',
            'event_alarm_char',
            'name',
            'time',
            'source_ip',
            'source_port',
            'destination_ip',
            'destination_port',
            'priority',
            'confidence',
        ])->paginate(20);
    }
}