@extends('layouts.layout')

@section('title', 'Chit Scheme')

@section('content')

@php
    function schemename($id) {
        $result = DB::table('scheme_name')->where('id',$id)->first();
        return isset($result->scheme_name)?$result->scheme_name:'';
    }
    function groupcount($sid,$gid) {
        return DB::table('chit_details')->where('scheme_id', $sid)->where('group_id', $gid)->count();
    }
@endphp

<section class="content">
    <div class="container-fluid">
        <div class="block-header">
            <div class="row">
                <div class="col-xs-9 col-sm-9 col-md-9 col-lg-9">
                    <ul class="breadcrumb breadcrumb-style ">
                        <li class="breadcrumb-item bcrumb-1">
                            <a href="{{url('/')}}/home">
                                <i class="fas fa-home"></i> Home</a>
                        </li>
                        <li class="breadcrumb-item active">Chit Scheme</li>                            
                        <li class="breadcrumb-item active">Groups</li>                            
                    </ul>
                </div>
                <div class="col-xs-2 col-sm-3 col-md-3 col-lg-3 pull-right text-right">
                    <a href="{{ route('groups.create') }}"><button type="button" id="event_add" class="btn btn-primary waves-effect m-t-15"><i class="fas fa-plus"></i> Add New Group
                    </button></a>
                </div>
            </div>
        </div>
        <!-- Basic Examples -->
        <div class="row clearfix">
            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                <div class="card">
                    <div class="header">
                        <h2>
                            <strong>Group </strong> List</h2>
                    </div>
                    <div class="body">
                        <div class="table-responsive">
                            @if(Session::has('message'))
                                <div class="alert bg-{{Session::get('status')}} alert-dismissible" role="alert">
                                    <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                        <span aria-hidden="true">×</span>
                                    </button>
                                    {{ Session::get('message') }}
                                </div>
                             @endif
                            <table id="adminTable" class="display table table-checkable order-column m-t-20 width-per-100">
                                <thead>
                                    <tr>
                                        <th>#</th>
                                        <th>Scheme Name</th>
                                        <th>Group</th>
                                        <th>Installment Amount</th>
                                        <th>Chit Value</th>
                                        <th>No.of Installment</th>
                                        <!-- <th>Bonus Type</th> -->
                                        <th>Bonus Amount</th>
                                        <th>Total Amount</th>
                                        <th>Status</th>
                                        <th>Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @if(count($groups)>0) 
                                        @foreach($groups as $key=>$item)
                                            <tr>
                                                <td>{{ $key+1 }}</td>
                                                <td>{{ isset($item->scheme_id)?schemename($item->scheme_id):'' }}</td>
                                                <td>@if($item->scheme_id && $item->id)
                                                    <a title="View Member Details" href="{{url('/')}}/chit_users/{{$item->scheme_id}}/{{$item->id}}"> {{ $item->chit_name }} ({{groupcount($item->scheme_id,$item->id)}})</a>
                                                    @else 
                                                     {{ $item->chit_name }} (0)
                                                    @endif</td>
                                                <td><i class="fas fa-rupee-sign"></i> {{ number_format($item->installment_amount) }}</td>
                                                <td><i class="fas fa-rupee-sign"></i> {{ number_format($item->chit_value) }}</td>
                                                <td>{{ $item->no_of_installment }}</td>
                                                <!-- <td>
                                                    @if($item->bonus_type==2) Percentage @endif
                                                    @if($item->bonus_type==1) Fixed Amount @endif
                                                </td> -->
                                                <td><i class="fas fa-rupee-sign"></i>
                                                    @php
                                                        $bonus_amount = $item->bonus_amount;
                                                        if($item->bonus_type==2) {
                                                            $bonus_amount = ($bonus_amount / 100) * $item->chit_value;
                                                        } 
                                                    @endphp 
                                                    {{ number_format($bonus_amount) }}
                                                </td>
                                                <td><i class="fas fa-rupee-sign"></i> {{ number_format($item->chit_value + $bonus_amount) }}</td>
                                                <td>
                                                    @if($item->status=='0')  
                                                    <span class="label bg-warning shadow-style">Inactive</span>
                                                    @endif
                                                    @if($item->status=='1') 
                                                    <span class="label bg-green shadow-style">Active</span>
                                                    @endif
                                                </td>
                                                <td>
                                                    @include('shared._actions', [
                                                        'entity' => 'groups',
                                                        'id' => $item->id
                                                    ])
                                                </td>
                                            </tr>
                                        @endforeach
                                    @else 
                                        <tr>
                                            <td class="text-center" colspan="10">
                                                <img src="{{url('/')}}/assets/images/nodata.png"> 
                                                <br><h3>No records found!</h3> Click <a href="{{ route('groups.create') }}">here</a> to add a new record.
                                            </td>
                                        </tr>
                                    @endif
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>

<script src="{{url('/')}}/assets/js/pages/tables/jquery-datatable.js"></script>
@endsection