@php
	use \koolreport\widgets\koolphp\Table;
	use \Constants\SharedConstants;
	use \App\Helpers\DBHelper;
@endphp

@extends('layouts.dashboard')

@section('title', $reportName)

@section('content')

@php
	

	DBHelper::connectToDatabase(SharedConstants::CUSTOMER_DATA_SQL_CONNECTION, Session::get('dbName'));

	$d = DB::connection(SharedConstants::CUSTOMER_DATA_SQL_CONNECTION)->select(DB::raw($query));

@endphp


<section class="pd">
	<div class="container-fluid">
		<div class="row">
			<h3 class="text-center">{{ ucwords($reportName) }}</h3>
			<div class="col-lg-12 col-md-12 col-sm-12">
				<div class="panel panel-default">
					<!-- Default panel contents -->
					<div class="panel-heading">{{ $reportCategory }} > {{ ucwords($reportName) }}</div>
					<div class="panel-body">
						<!-- Table -->
						@php
						
							Table::create([
					            "dataSource"=>DB::connection(SharedConstants::CUSTOMER_DATA_SQL_CONNECTION)->select(DB::raw($query)),
								"columns"=>json_decode($reportColumnDefinition, true),
								"cssClass"=>array(
					                "table"=>"table table-bordered"
					            )
					        ]);
						@endphp
					</div>
				</div>
			</div>
		</div>
	</div>
</section>
<script>
	$('.table').dataTable({
		// "bPaginate": false,
		//order: [],
		@if($reportSortColumn == "")
			order: [],
		@else
			order: [{{$reportSortColumn}}, 'asc'],
		@endif
		pageLength: 50,
		dom: 'lBfrtip',
		buttons: [
			// 'excel', 'csv', 'pdf', 'copy'
			'excel'
		]
	});
</script>

@endsection