/
home
/
sjslayjy
/
public_html
/
cropnet
/
resources
/
views
/
admin
/
report
/
Upload File
HOME
@extends('admin.layouts.app') @section('title','Members') @section('style') <meta name="csrf-token" content="{{ csrf_token() }}"> {{-- {{Html::style("assets/css/bootstrap-datepicker3.min.css")}} --}} @endsection @section('content') <!-- Content Wrapper. Contains page content --> <div class="content-wrapper"> <div class="container-full"> <!-- Header Dynamic --> <div class="content-header"> <div class="d-flex align-items-center"> <div class="me-auto"> <h4 class="page-title">{{$page}}</h4> <div class="d-inline-block align-items-center"> <nav> <ol class="breadcrumb"> <li class="breadcrumb-item"><a href="#"><i class="fa fa-home"></i></a></li> <li class="breadcrumb-item active" aria-current="page">{{$page}}</li> </ol> </nav> </div> </div> </div> </div> <!-- End Header Dynamic --> <!-- Main content --> <section class="content"> <div class="row"> <div class="col-12"> <div class="box"> <div class="box-header with-border"> <div class="clearfix"> <form action="" method="POST" role="form"> {{csrf_field()}} <div class="row"> {{-- <div class="col-md-2"> <div class="form-group"> <label for="user" class="form-label">Field User :</label> <select class="form-control select2" id="user_id" name="user" onchange="getpibuserByuser()" > <option value="">Select</option> @foreach($user as $m ) <option value="{{$m->id}}">{{$m->name}}</option> @endforeach </select> @if ($errors->has('user')) <span class="label label-danger">{{ $errors->first('user') }}</span> @endif </div> </div> --}} <div class="col-md-2"> <div class="form-group"> <label for="relation_with_application" class="form-label">MCC :</label> <select class="form-control select2" id="mcc_name" name="mcc_name" onchange="getMppByMcc()"> <option value="">Select</option> @foreach($mcc as $m) <option value="{{$m->code}}" @if(isset($mccCode)) @if($mccCode==$m->code) {{'selected'}} @endif @elseif(old('mcc_name')) @if(old('mcc_name') == $m->code) {{'selected'}} @endif @endif>{{$m->name}}</option> @endforeach </select> @if ($errors->has('mcc_name')) <span class="label label-danger">{{ $errors->first('mcc_name') }}</span> @endif </div> </div> <div class="col-md-2"> <div class="form-group"> <label for="mpp_name" class="form-label">MPP :</label> <select class="form-control select2" id="mpp_name" name="mpp_name" style="width: 100%;"> <option value="">Select</option> @foreach($mpps as $mpp) <option value="{{$mpp->code}}" @if(isset($mppCode)) @if($mppCode==$mpp->code) {{'selected'}} @endif @elseif(old('mpp_name')) @if(old('mpp_name') == $mpp->code) {{'selected'}} @endif @endif>{{$mpp->name}}</option> @endforeach </select> @if ($errors->has('mpp_name')) <span class="label label-danger">{{ $errors->first('mpp_name') }}</span> @endif </div> <!--<input type="checkbox" id="select_all" name="select_all" ><label for="select_all">Select All Mpp</label>--> </div> {{-- <div class="col-md-2"> <div class="form-group"> <label for="user" class="form-label">PIB Officer :</label> <select class="form-control select2" id="pibuser_id" name="pibuser" > <option value="">Select</option> @foreach($pibuser as $m ) <option value="{{$m->id}}">{{$m->name}}</option> @endforeach </select> </div> </div> --}} <div class="col-md-2"> <div class="form-group"> <label for="relation_with_application" class="form-label">From Date :</label> <input type="date" name="from_date" id="from_date" class="form-control" @if(isset($fromDate)) value="{{$fromDate}}" @else value="{{old('from_date')}}" @endif/> @if($errors->first('from_date')) <span class="label label-danger" style="text-align: left;">{{$errors->first('from_date')}}</span> @endif </div> </div> <div class="col-md-2"> <div class="form-group"> <label for="relation_with_application" class="form-label">To Date :</label> <input type="date" name="to_date" id="to_date" class="form-control" @if(isset($toDate)) value="{{$toDate}}" @else value="{{old('to_date')}}" @endif/> @if($errors->first('to_date')) <span class="label label-danger" style="text-align: left;">{{$errors->first('to_date')}}</span> @endif </div> </div> <div class="col-md-2"> <div class="form-group"> <button type="submit" class="btn btn-primary btn-sm" style="padding: 6px 16px;font-size: 15px;margin-top: 27px;">Filter</button> </div> </div> </div> </form> </div> </div> <!-- /.box-header --> <!-- /.box-header --> <div class="box-body"> <div class="row" style="padding-bottom: 14px;"> <div class="col-sm-6"> <h3 style="font-size: 22px;">Report Table</h3> </div> <div class="col-sm-6"> <form action="{{url('admin/download-user-form-report-excel')}}" method="post"> {{csrf_field()}} <input type="hidden" name="mcc_name_export" value="@if(isset($mccCode)){{$mccCode}}@endif"> <input type="hidden" name="mpp_name_export" value="@if(isset($mppCode)){{$mppCode}}@endif"> <input type="hidden" name="from_date_export" value="@if(isset($fromDate)){{$fromDate}}@endif"> <input type="hidden" name="to_date_export" value="@if(isset($toDate)){{$toDate}}@endif"> <button type="submit" name="export_data" class="btn buttons-excel buttons-html5 btn-success bg-success-light btn-bold" style="float:right">Excel <i class="fa fa-download"></i></button> </form> </div> </div> <div class="table-responsive"> <table id="dynamic-table" class="table table-bordered table-hover display nowrap margin-top-10 w-p100 text-center"> <thead> <tr> <th style="text-align: center;">Form No</th> <th style="text-align: center;">Facilitator</th> <th style="text-align: center;">MCC</th> <th style="text-align: center;">MPP</th> <th style="text-align: center;">PIB Officer Status</th> <!--<th style="text-align: center;">Area Officer Name</th>--> <!-- <th style="text-align: center;">Legal Officer Status</th> --> <!--<th style="text-align: center;">Legal Officer Name</th>--> <th style="text-align: center;">Finance Officer Status</th> <!--<th style="text-align: center;">Finance Officer Name</th>--> <th style="text-align: center;">Final Approval Status</th> <th style="text-align: center;">Final Approved By</th> <th style="text-align: center;">Remark</th> </tr> </thead> <tbody> @if(!empty($form)) @foreach($form as $key=>$user) <tr> <td>{{ $user['form_no'] }}</td> <td>{{ $user['created_by'] }}</td> <td>{{ $user['mcc_name'] }}</td> <td>{{ $user['mpp_name'] }}</td> <td> @if($user['ao_approval_status']) {{$user['ao_approval_status'] }} @else <span >...</span> @endif </td> <td> @if($user['fo_approval_status']) {{$user['fo_approval_status'] }} @else <span >...</span> @endif </td> <td> @if($user['final_approval_status']) {{$user['final_approval_status'] }} @else <span >Pending</span> @endif </td> <td> @if($user['final_approved_by']) {{ $user['final_approved_by'] }} @else <span >...</span> @endif </td> <td> @if($user['remark']) {{ $user['remark'] }} @else <span >...</span> @endif </td> </tr> @endforeach @endif </tbody> <tfoot> </tfoot> </table> </div> </div> <!-- /.box-body --> <!-- /.box-body --> </div> <!-- /.box --> </div> </div> </section> <!-- /.content --> </div> </div> @endsection @section('script') {{-- <script src="{{asset("src/js/pages/patients.js")}}"></script> --}} <script src="../src/js/pages/validation.js"></script> <script src="../src/js/pages/form-validation.js"></script> <script> function getpibuserByuser() { var user = $("#user_id").val(); if (user_id != "") { $.ajaxSetup({ headers: { 'X-CSRF-TOKEN': $('meta[name="_token"]').attr('content') } }); $.ajax({ url: '/admin/get-user-by-pibuser', type: 'POST', data: {user_id: user}, success:function(data){ console.log(data); var option = ""; if (data.flag) { $.each(data.pibuser, function(index, pibuser) { option += "<option value='"+pibuser.id+"'>"+pibuser.name+"</option>"; }); } else { option += "<option>"+data.message+"</option>"; } $("#pibuser_id").html(option); } }); } else { swal({ title : "User Id Missing!", text : "Please select User Id first.", icon : "error" }).then(function(){ // $("#siteId").html("<option>Select Site ID</option>"); }); } } function getMppByMcc() { var mcc_name = $("#mcc_name").val(); if (mcc_name != "") { $.ajaxSetup({ headers: { 'X-CSRF-TOKEN': $('meta[name="_token"]').attr('content') } }); $.ajax({ url: '/admin/get-mpp-by-mcc', type: 'POST', data: {mcc_name: mcc_name}, success:function(data){ // console.log(data); var option = ""; if (data.flag) { option += "<option value=''>Select</option>"; $.each(data.mpp, function(index, mpp) { option += "<option value='"+mpp.code+"'>"+mpp.name+"</option>"; }); } else { option += "<option>"+data.message+"</option>"; } $("#mpp_name").html(option); } }); } else { swal({ title : "mcc Missing!", text : "Please select mcc first.", icon : "error" }).then(function(){ // $("#siteId").html("<option>Select Site ID</option>"); }); } } function assignToUser(){ $.ajaxSetup({ headers: { 'X-CSRF-TOKEN': $('meta[name="_token"]').attr('content') } }); var mcc_name = $('#mcc_name').val(); var user_id = $('#user_id').val(); var from_date = $('#form_date').val(); var to_date = $('#to_date').val(); var options = []; if ($('#select_all').is(':checked')) { $("#mpp_name option").prop('disabled', true); $('#mpp_name option').each(function() { options.push($(this).val()); }); } else { options = $('#mpp_name').val(); } $.ajax({ url: $('#addAssignUserForm').attr('action'), method: 'POST', data: { user_id: user_id, mcc_name: mcc_name, mpp_name: options, from_date: form_date, to_date: to_date }, // data: $('#addAssignUserForm').serialize(), success: function(data){ if(!data.flag){ swal("Error", data.error, "error"); }else{ swal({ title: "Success!", text: data.message, type: "success" }).then( function() { window.location.reload(); }); } } }); } </script> @endsection