@extends('layouts.master') 

@section('content')

<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
  <!-- Content Header (Page header) -->
  <div class="content-header">
    <div class="container-fluid">
      <div class="row mb-2">
        <div class="col-sm-6">
          <h1 class="m-0 text-dark">{{ trans('breadcrumbs.Business Report') }}</h1>
        </div>
        <!-- /.col -->
        <div class="col-sm-3"></div>
        <div class="col-sm-3">
          <ol class="breadcrumb float-sm-right">
            <li class="breadcrumb-item">{{ Breadcrumbs::render('Business Report') }}</li>
          </ol>
        </div>
        <!-- /.col -->
      </div>
      <!-- /.row -->
    </div>
    <!-- /.container-fluid -->
  </div>
  <!-- /.content-header -->

  <section class="content">
    <div class="card">
      <div class="card-header">
        <h3 class="card-title">{{ trans('reports.Filter') }}</h3>           
        <div class="col-md-6 card-primary card-form-1">
          <div class="card-body">
            {{ Form::open(['route' => 'businessReports','class' => 'card-body', 'id' => 'my-form', 'autocomplete' => 'off']) }}
            <div class="form-col-1">
                {{ Form::label('DATE_RANGE',trans('reports.Select Date Range')) }}<br>
                <button type="button" style="width: 100%;" class="btn btn-default" id="daterange-btn1">
                 <span class="daterange_span pull-left">{{ $dateLabel }}</span>
                </button>
              <input type="hidden" name="selected_datatime" id="selected_datatime" value="{{ $requestDate }}">
            </div>
            <br> <br>
            <div class="button_sec">
              {{ Form::submit(
               trans('reports.Submit'), ['class' => 'btn btn-primary']) }}
              <a class="btn btn-default" id="clear">{{trans ('reports.Clear') }}</a>
            </div>
            {{ Form::close() }}
          </div>
        </div> 
      </div>
      <!-- /.card-body -->
    </div>
    

  @if($report)
    <div class="card">
      <div class="card-header">
        <h3 class="card-title"><b>{{trans ('reports.Business Report Summary')}}: {{ $dateLabel }}</b></h3>
        {{-- [Period: {{ trans( date('Y-m-d 00:00:00', strtotime($selected_datatime[0]))." - ". date('Y-m-d 00:00:00', strtotime($selected_datatime[0]))) }}]
       --}}
      </div>
      <div class="card-body">
          <table class="table table-bordered table-striped">
          <thead>
            <tr>
                <th class="text-center"><h5><b>{{trans ('reports.Particulars')}}</b></h5></th>
                <th class="text-center"><h5><b>{{trans ('reports.Amount')}}</b></h5></th>
            </tr>
          </thead>
          <tbody>  
             <!-- Company Revenue -->
              <tr>
                  <th class="text-left"><h6><b>{{trans ('reports.COMPANY REVENUE')}}</b></h6></th>
                  <th class="text-right"></th>
                </tr>          
            <tr>
              <th class="text-left">{{trans ('reports.GRC')}}</th>
              <th class="text-right">{{ $GROSS_RAKE }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.BRC')}}</th>
              <th class="text-right">{{ $BONUS_RAKE }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.GST')}}</th>
              <th class="text-right">{{ $TOTAL_GST }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.NRC')}}</th>
              <th class="text-right">{{ $NET_RAKE_DEPOSIT }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Internal Player Loss/win')}}</th>
              <th class="text-right">{{ $INTERNAL_PLAYER_LOSS }}</th>
            </tr>
 <!-- Company D & W -->
            <tr>
                <th class="text-left"><h6><b>{{trans ('reports.COMPANY D & WE')}}</b></h6></th>
                <th class="text-right"></th>
              </tr> 
            <tr>
              <th class="text-left">{{trans ('reports.Tournament rake')}}</th>
              <th class="text-right">{{ $REAL_PLAYER_TOUR_RAKE }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Deposits')}}</th>
              <th class="text-right">{{ $TOTAL_DEPOSIT }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Withdrawals')}}</th>
              <th class="text-right">{{ $TOTAL_WITHDRAW }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.D - W')}}</th>
              <th class="text-right">{{ $TOTAL_DW }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Previous days withdrawal reverted in this in this period')}}</th>
              <th class="text-right">{{ $PRE_PENDING_TODAY_REVERT }}</th>
            </tr>
            {{-- <tr>
              <th class="text-left">Tournament Refund (Previous Period refunded in this Period)</th>
              <th class="text-right">{{ $TOUR_PRE_REFUND_TODAY }}</th>
            </tr> --}}
            <tr>
              <th class="text-left">{{trans ('reports.TDS')}}</th>
              <th class="text-right">{{ $TDS_AMOUNT }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Process Fee')}}</th>
              <th class="text-right">{{ $PROCESSING_FEE }}</th>
            </tr>
    <!-- Player Activity -->
            <tr>
                <th class="text-left"><h6><b>{{trans ('reports.PLAYER ACTIVITY')}}</b></h6></th>
                <th class="text-right"></th>
              </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Active Real Money Players (AP)')}}</th>
              <th class="text-right">{{ $AP_TOTAL_REAL_REVENUE }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Active Depositing Players (ADP)')}}</th>
              <th class="text-right">{{ $APS_user_id }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.New Registrations')}}</th>
              <th class="text-right">{{ $NEW_REGISTRATION }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Total Registered Players')}}</th>
              <th class="text-right">{{ $TOTAL_REGISTRATION }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.FTDs')}}</th>
              <th class="text-right">{{ $FIRST_TIME_DEPOSIT_COUNT }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Total Depositors')}}</th>
              <th class="text-right">{{ $TOTAL_DEPOSITER }}</th>
            </tr>
            <!-- Player Balances -->
            <tr>
                <th class="text-left"><h6><b>{{trans ('reports.PLAYER BALANCES')}}</b></h6></th>
                <th class="text-right"></th>
              </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Opening Player Balance')}}</th>
              <th class="text-right">{{ $REAL_PLAYER_BALANCE_OPEN }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Closing Player Balance')}}</th>
              <th class="text-right">{{ $REAL_PLAYER_BALANCE_CLOSED }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Opening promo balance')}}</th>
              <th class="text-right">{{ $REAL_PLAYER_PROMO_BALANCE_OPEN }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Closing promo balance')}}</th>
              <th class="text-right">{{ $REAL_PLAYER_PROMO_BALANCE_CLOSED }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Opening Money In Play')}}</th>
              <th class="text-right">{{ $REAL_PLAYER_TABLE_BALANCE_OPEN }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Closing Money In Play')}}</th>
              <th class="text-right">{{ $REAL_PLAYER_TABLE_BALANCE_CLOSED }}</th>
            </tr>

                <!-- Bet Analysis -->
            <tr>
                <th class="text-left"><h6><b>{{trans ('reports.BET ANALYSIS')}}</b></h6></th>
                <th class="text-right"></th>
              </tr>
            <tr>

              <th class="text-left">{{trans ('reports.Total Bets Placed')}}</th>
              <th class="text-right">{{ $TOTAL_BET }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Total Wins')}}</th>
              <th class="text-right">{{ $TOTAL_WIN }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Bets Placed/AP')}}</th>
              <th class="text-right">{{ $WIN_AP }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Bets Placed/ADP')}}</th>
              <th class="text-right">{{ $BET_APD }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Promo Campaign')}}</th>
              <th class="text-right">{{ $REAL_PLAYER_REGI_PROMO_BONUS }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.RAF Bonus')}}</th>
              <th class="text-right">{{ $TOTAL_RAF_BONUS }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Total')}}</th>
              <th class="text-right">{{ $totalNonACQ = $REAL_PLAYER_REGI_PROMO_BONUS + $TOTAL_RAF_BONUS}}</th>
            </tr>
<!-- Bonuses -->
            <tr>
                <th class="text-left"><h6><b>{{trans ('reports.NON CASH RETENTION BONUS')}}</b></h6></th>
                <th class="text-right"></th>
              </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Adjust Promo')}}
              <span class="smallfont">{{trans ('reports.(Adjust Promo Add - Adjust Promo Subtract)')}}</span></th>
             <th class="text-right">
                @if(!empty($P_ADJUSTMENT_AMOUNT))
              {{ $P_ADJUSTMENT_AMOUNT .' ('.$P_ADJUSTMENT_AMOUNT_ADD .' - '.$P_ADJUSTMENT_AMOUNT_REMOVE.')' }}</th>
                
                @else
                {{$P_ADJUSTMENT_AMOUNT}}
              @endif
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Rewards Bonus')}}</th>
              <th class="text-right">{{ $REAL_PLAYER_REWARD_REDEM_BONUS }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Released Bonus')}}</th>
              <th class="text-right">{{ $REAL_PLAYER_RELEASED_BONUS }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Tournament Wins')}}
                <span class="smallfont">{{trans ('reports.(Only Freeroll and Beginners)')}}</span></th>
              <th class="text-right">{{ $REAL_PLAYER_TOUR_WIN }}</th>
            </tr>
    
            <tr>
              <th class="text-left">{{trans ('reports.Adjust Win')}}
                <span class="smallfont">{{trans ('reports.(Adjust Win Add - Adjust Win Subtract)')}}</span></th>
              <th class="text-right">
                  @if(!empty($W_ADJUSTMENT_AMOUNT))
                {{ $W_ADJUSTMENT_AMOUNT .' ('.$W_ADJUSTMENT_AMOUNT_ADD .' - '.$W_ADJUSTMENT_AMOUNT_REMOVE.')'}}</th>
                  
                  @else
                  {{$W_ADJUSTMENT_AMOUNT}}
                @endif
              </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Adjust Deposit')}}
                  <span class="smallfont">{{trans ('reports.(Adjust Deposit Add - Adjust Deposit Subtract)')}}</span></th>
              <th class="text-right">
                  @if(!empty($D_ADJUSTMENT_AMOUNT))
                  {{ $D_ADJUSTMENT_AMOUNT .' ('.$D_ADJUSTMENT_AMOUNT_ADD .' - '.$D_ADJUSTMENT_AMOUNT_REMOVE.')'}}</th>
                  
                  @else
                    {{$D_ADJUSTMENT_AMOUNT}}
                  @endif
                </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Total All Bonus')}}</th>
              <th class="text-right">{{ $totalNonRetentionBonus = $P_ADJUSTMENT_AMOUNT + $REAL_PLAYER_REWARD_REDEM_BONUS + $REAL_PLAYER_RELEASED_BONUS + $REAL_PLAYER_TOUR_WIN + $W_ADJUSTMENT_AMOUNT + $D_ADJUSTMENT_AMOUNT }}</th>
            </tr>

                <!-- GST -->

            <tr>
                <th class="text-left"><h6><b>{{trans ('reports.GST')}}</b></h6></th>
                <th class="text-right"></th>
              </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Cash Game GST')}}</th>
              <th class="text-right">{{ $CASH_GST }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Tournament GST')}}</th>
              <th class="text-right">{{ $TOUR_GST }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.TOTAL GST')}}</th>
              <th class="text-right">{{ $TOTAL_GST }}</th>
            </tr>
  <!-- Match Bonus -->
            <tr>
                <th class="text-left"><h6><b>{{trans ('reports.MATCH/CASH BONUSES')}}</b></h6></th>
                <th class="text-right"></th>
              </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Opening Match Bonus Balance')}}</th>
              <th class="text-right">{{ $MATCH_BONUS_OPEN_BALANCE }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Closing Match Bonus Balance')}}</th>
              <th class="text-right">{{ $MATCH_BONUS_CLOSED_BALANCE }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Match Bonus expired during the period')}}</th>
              <th class="text-right">{{ $MATCH_BONUS_EXPIRED }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Cash Tournament Win Amount')}}</th>
              <th class="text-right">{{ $CASH_TOUR_WIN_AMOUNT }}</th>
            </tr>
            <tr>
              <th class="text-left">{{trans ('reports.Affiliation Commission Paid')}}</th>
              <th class="text-right">{{ $AFFILIATE_COMM_PAID }}</th>
            </tr>
            
            <tr>
              <th class="text-left">{{trans ('reports.Pending Withdrawal Taken To Next Period')}}</th>
              <th class="text-right">{{ $PENDING_WITHDRAW_CARRIED_NXT_PERIOD }}</th>
            </tr>
          </tbody>
        </table>
      </div>
      <!-- /.card-body -->
    </div>
  @endif

  </section>

</div>
@endsection
@section('javascript')
@include('datatablejs')
<script type="text/javascript"> 
var date = new Date();
var time = date.toTimeString().split(' ')[0].split(':');

var start = moment().subtract(29, 'days');
var end = moment();

function setDate(start, end) {
    $('#daterange-btn1 span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'))
    var selected_datatime = start.format('DD-MM-YYYY') + ' 00:00:00&' + end.format('DD-MM-YYYY')+' '+time[0]+':'+time[1]+':'+time[2];
    $("#selected_datatime").val(selected_datatime);
}

$('#daterange-btn1').daterangepicker(
    {
        opens: 'right',
        showDropdowns: true,
        linkedCalendars: false,
        maxDate: moment().add(1, 'days'),
        ranges   : {
          'Today': [moment(), moment()],
          'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
          'This Week': [moment().startOf('week').add(1, 'days'), moment().endOf('week').add(1, 'days')],
          'Last 7 Days': [moment().subtract(6, 'days'), moment()],
          'Last 30 Days': [moment().subtract(29, 'days'), moment()],
          'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')],
          'This Month': [moment().startOf('month'), moment().endOf('month')]
        },
        startDate: start,
        endDate  : end
    },setDate);
@if(!$report)
setDate(start, end);
@endif

$("#clear").click(function(){
  var s = window.location;
  s.href = "{{ route('businessReports') }}";
});

</script>
@stop