@extends('layouts/inventory_layout')
@section('title', '| Issue Details Report')
@section('content')
@include('successMsg')
   
    <div class="row">
        <div class="col-md-12">
            <div class="" style="">
            <div class="">            

                <div class="panel panel-default" style="background-color:#708090;">

                    <div class="panel-heading" style="padding-bottom:0px">
                        <div class="panel-options">
                            <a href="" class="btn btn-info pull-right addViewBtn" id="print"><i class="fa fa-print" aria-hidden="true"></i> Print</a>

                        </div>
                        

                        <div class="row" id="filtering-group">
                            
                                <div class="form-horizontal form-groups" style="padding-right: 0px;">

                                    {!! Form::open(['url' => 'viewIssueDetailsReport','method' => 'get']) !!}
                                    @php
                                        $userBranchId = Auth::user()->branchId;
                                    @endphp

                                    @if($userBranchId==1)
                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                             <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Project:', ['class' => 'control-label pull-left']) !!}
                                            </div> 

                                            <div class="col-sm-12">
                                                <select name="searchProject" class="form-control input-sm" id="searchProject">
                                                    <option value="">All</option>                                                    
                                                    @foreach($projects as $project)
                                                    <option value="{{$project->id}}" @if($project->id==$projectSelected){{"selected=selected"}}@endif>{{str_pad($project->projectCode,3,"0",STR_PAD_LEFT).'-'.$project->name}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>
                                    </div>
                                    @endif

                                    @if($userBranchId==1)
                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Pro. Type:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                <select name="searchProjectType" class="form-control input-sm" id="searchProjectType">
                                                      <option value="">All</option>
                                                    @foreach($projectTypes as $projectType)
                                                      <option value="{{$projectType->id}}" @if($projectType->id==$projectTypeSelected){{"selected=selected"}}@endif>{{str_pad($projectType->projectTypeCode,3,"0",STR_PAD_LEFT).'-'.$projectType->name}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>
                                    </div>
                                    @endif

                                    @if($userBranchId==1)
                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Branch:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                <select name="searchBranch" class="form-control input-sm" id="searchBranch">
                                                    <option value="">All</option>
                                                    <option value="0" @if($branchSelected===0){{"selected=selected"}}@endif>All Branches</option>
                                                    @foreach($branches as $branch)
                                                    <option value="{{$branch->id}}" @if($branch->id==$branchSelected){{"selected=selected"}}@endif>{{str_pad($branch->branchCode,3,"0",STR_PAD_LEFT).'-'.$branch->name}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>
                                    </div>
                                    @endif


                                      <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                             <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Group:', ['class' => 'control-label pull-left']) !!}
                                            </div> 

                                            <div class="col-sm-12">
                                                <select name="searchGroup" class="form-control input-sm" id="searchGroup">
                                                    <option value="">All</option>
                                                    @foreach($groups as $group)
                                                    <option value="{{$group->id}}" @if($group->id==$groupSelected){{"selected=selected"}}@endif>{{$group->name}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>
                                    </div>
    
                               

                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                             <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Category:', ['class' => 'control-label pull-left']) !!}
                                            </div> 

                                            <div class="col-sm-12">
                                                <select name="searchCategory" class="form-control input-sm" id="searchCategory">
                                                    <option value="">All</option>
                                                    @foreach($categories as $category)
                                                    <option value="{{$category->id}}" @if($category->id==$categorySelected){{"selected=selected"}}@endif>{{$category->name}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>
                                    </div>

                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                             <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Sub Category:', ['class' => 'control-label pull-left']) !!}
                                            </div> 

                                            <div class="col-sm-12">
                                                <select name="searchSubCategory" class="form-control input-sm" id="searchSubCategory">
                                                    <option value="">All</option>
                                                    @foreach($subCategories as $subCategory)
                                                    <option value="{{$subCategory->id}}" @if($subCategory->id==$subCategorySelected){{"selected=selected"}}@endif>{{$subCategory->name}}</option>
                                                    @endforeach
                                                </select>

                                            </div>
                                        </div>
                                    </div>


                                   <div class="col-md-1">
                                      <div class="form-group" style="font-size: 13px; color:black;">
                                           <div style="text-align: center;" class="col-sm-12">
                                              {!! Form::label('', 'Product:', ['class' => 'control-label pull-left']) !!}
                                          </div> 
                                  
                                          <div class="col-sm-12">
                                              <select name="searchProduct" class="form-control input-sm" id="searchProduct">
                                                  <option value="">All</option>
                                                 @foreach ($products as $products)
                                                    <option value="{{$products->id}}" @if($products->id==$productSelected){{"selected=selected"}}@endif>{{$products->name}}</option>
                                                 @endforeach
                                                 
                                               </select>
                                  
                                          </div>
                                      </div>
                                  </div>
                                  
                                  <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black;">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', 'Search By:', ['class' => 'control-label pull-left']) !!}
                                            </div>

                                            <div class="col-sm-12">
                                                {!! Form::select('searchMethod',[''=>'Please Select','1'=>'Fiscal Year','2'=>'Current Year','3'=>'Date Range'],$searchMethodSelected,['id'=>'searchMethod','class'=>'form-control input-sm']) !!}

                                            </div>
                                        </div>
                                    </div>
                                    

                                    <div class="col-md-1" style="display: none;" id="fiscalYearDiv">
                                        <div class="form-group" style="font-size: 13px; color:black">
                                            {!! Form::label('', ' ', ['class' => 'control-label col-sm-12']) !!}
                                            <div class="col-sm-12" style="padding-top: 18px;">

                                                {!! Form::select('fiscalYear', $fiscalYears, $fiscalYearSelected, array('class'=>'form-control input-sm', 'id' => 'fiscalYear')) !!}

                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-2" style="display: none;" id="dateRangeDiv">
                                        <div class="form-group" style="font-size: 13px; color:black">
                                            <div style="text-align: center;" class="col-sm-12">
                                                {!! Form::label('', ' ', ['class' => 'control-label']) !!}
                                            </div>

                                            <div class="col-sm-12" style="padding-top: 7px;">
                                                <div class="form-group">
                                                    <div class="col-sm-6">
                                                        {!! Form::text('dateFrom',$dateFromSelected,['id'=>'dateFrom','placeholder'=>'From','class'=>'form-control input-sm','readonly','style'=>'cursor:pointer']) !!}
                                                        <p id="dateFrome" style="color: red;display: none;">*Required</p>
                                                    </div>
                                                    <div class="col-sm-6" id="dateToDiv">
                                                        {!! Form::text('dateTo',$dateToSelected,['id'=>'dateTo','placeholder'=>'To','class'=>'form-control input-sm','readonly','style'=>'cursor:pointer']) !!}
                                                        <p id="dateToe" style="color: red;display: none;">*Required</p>
                                                    </div>
                                                </div>

                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="col-md-1">
                                        <div class="form-group" style="font-size: 13px; color:black">

                                            <div class="col-sm-12" style="padding-top: 25px;">

                                                {!! Form::submit('Search',['id'=>'search','class'=>'btn btn-primary btn-xs','style'=>'font-size:15px;']) !!}
                                            </div>
                                        </div>
                                        {!! Form::close() !!}
                                    </div>                                    

                                </div>                            
                            
                        </div> {{-- End Filtering Group --}}


<h2 align="center" style="font-family: Antiqua;letter-spacing: 2px; color: white;margin-top: 0px;">Issue Details Report </h2>
                        
                    </div>
                    <div class="panel-body panelBodyView">
                        <div>
                            
                        </div>
                        @php
                            if($branchSelected===0){
                                $selectedBranchName = "All Branches";
                               }
                           else{
                            $selectedBranchName = DB::table('gnr_branch')->where('id',$branchSelected)->value('name');
                           }
                            $selectedProjectName = DB::table('gnr_project')->where('id',$projectSelected)->value('name');
                            $selectedProjectTypeName = DB::table('gnr_project_type')->where('id',$projectTypeSelected)->value('name');
                           

                        @endphp

                        @if(!$firstRequest )
                        <div id="printingContent">
                        <div style="display: none;text-align: center;" id="hiddenTitle">
                           <h3 style="text-align: center;padding: 0px;margin: 0px;">Ambala Foundation</h3>
                           <p style="text-align: center;padding: 0px;margin: 0px;font-size: 10px;">House # 62, Block # Ka, Piciculture Housing Society, Shyamoli, Dhaka-1207</p>
                           <h4 style="text-align: center;padding: 0px;margin: 0px;">Issue Details Report</h4>                          
                        </div> 
                        <div id="hiddenInfo" style="display: none;">                       

                       <p style="padding: 0px;margin: 0px;font-size: 11px;">Branch Name : @php
                            if($selectedBranchName==null){
                                echo "All";
                            }
                            else{
                                echo $selectedBranchName;
                            }
                        @endphp                               
                              
                        </p>                           
                       
                                                           
                            <p style="padding: 0px;margin: 0px;font-size: 11px;">Project Name : @php
                                        if($selectedProjectName==null){
                                            echo "All";
                                        }
                                        else{
                                            echo $selectedProjectName;
                                        }
                                    @endphp 

                                    <span style='float: right;'>
                                        Reporting Peroid : {{date('d-m-Y',strtotime($startDate))." to ".date('d-m-Y',strtotime($endDate))}}
                                    </span>                               
                                                            
                                    </p>                                
                            

                                                          
                                    <p style="padding: 0px;margin: 0px;font-size: 11px;">Project Type :  @php
                                        if($selectedProjectTypeName==null){
                                            echo "All";
                                        }
                                        else{
                                            echo $selectedProjectTypeName;
                                        }
                                    @endphp                               
                                <span style='float: right;'>
                                    Print Date: {{date("d-m-Y h:m a")}}
                                </span>  
                                
                                    </p>                                
                            
                        </div>
                        <br>

                                    <table id="purchaseReportTable" class="table table-striped table-bordered" style="color:black;font-size:11px;margin-bottom:50px;border-collapse: collapse;" width="100%" border= "1px solid white;" cellpadding="0" cellspacing="0">
                                    <thead>
                                       <tr style="height:30px;">
                                            <th>SL#</th>
                                            <th> Date</th>
                                            <th> Bill No</th>
                                            <th>Branch Name</th>
                                            <th>Product Name</th>
                                            <th>Total Quantity</th>
                                            <th>Total Amount (Tk)</th>
                                             
                                        </tr>
                                    </thead>
                                        <tbody>
        @php                                          

            $totalIssueDetailsAmount = 0;
            $totalIssueDetailsQuantity = 0;
            $totalcount = 0;
                                                                                        
        @endphp

             @foreach($issueDetails as $key => $issueDetail)

        @php
                                     
            $productName = DB::table('inv_product')->where('id',$issueDetail->issueProductId)->value('name'); 

            $issueId = DB::table('inv_tra_issue')->where('id',$issueDetail->issueId)->value('id');

            $branchId = DB::table('inv_tra_issue')->where('id',$issueDetail->issueId)->value('branchId');

            $branchName = DB::table('gnr_branch')->where('id',$branchId)->value('name'); 

             $issueDate = DB::table('inv_tra_issue')->where('id',$issueDetail->issueId)->value('issueDate');
        @endphp

                                   <tr>
        @php
            
            $countForDate = 1; 
            $countForBillNo = 1; 
            $countForBranch = 1;

            $isChangedForDate = 0;
            $isChangedForBillNo = 0;
            $isChangedForBranch = 0;
           


            if ($key>0) {
               
                if ($issueDetails[$key-1]->issueDate!=$issueDetail->issueDate) {
                    $isChangedForDate = 1;
                }
                if ($issueDetails[$key-1]->issueDate!=$issueDetail->issueDate) {
                    $isChangedForBillNo = 1;
                }
                if ($issueDetails[$key-1]->issueDate!=$issueDetail->issueDate) {
                    $isChangedForBranch = 1;
                }
              }

              if ($key == 0 || $isChangedForDate == 1) {
                  $countIssueDetails=clone $countIssue;
                  $countDate = $countIssueDetails->where('issueDate',$issueDetail->issueDate)->count();
                  $totalcount = $totalcount + $countDate;

                  $countIssueDetails=clone $countIssue;
                  $countDateForSubQty = $countIssueDetails->where('issueDate',$issueDetail->issueDate)->sum('issueQuantity');

                  $countIssueDetails=clone $countIssue;
                  $countDateForSubTotal = $countIssueDetails->where('issueDate',$issueDetail->issueDate)->sum('totalPrice');
              }

              if ($key == 0 || $isChangedForBillNo == 1) {
                  $countIssueDetails=clone $countIssue;
                  $countForBillNo = $countIssueDetails->where('issueDate',$issueDetail->issueDate)->count();
              }
              if ($key == 0 || $isChangedForBranch == 1) {
                  $countIssueDetails=clone $countIssue;
                  $countForBranch = $countIssueDetails->where('issueDate',$issueDetail->issueDate)->count();

              }

        @endphp

                                    <td style="text-align: center;">{{$key+1}}</td>

                                    @if($isChangedForDate==1 || $key==0)
                                        <td rowspan="{{$countDate}}" class="name">{{date('d-m-Y',strtotime($issueDate))}}</td>
                                    @endif

                                    @if($isChangedForBillNo==1 || $key==0)
                                        <td rowspan="{{$countForBillNo}}" class="name">{{$issueDetail->issueBillNo}}</td>
                                    @endif

                                    @if($isChangedForBranch==1 || $key==0)
                                        <td rowspan="{{$countForBranch}}" class="name">{{$branchName}}</td>
                                    @endif

                                        <td style="text-align:center;">{{$productName}}</td>
                                        <td style="text-align:center;">{{$issueDetail->issueQuantity}}</td>
                                       
                                        <td style="text-align: right;padding-right: 5px;">{{number_format($issueDetail->totalPrice,2)}}</td>

                                    </tr>

                                    @if($totalcount ==$key+1)
                                        <tr>

                                            <td colspan="5"  style="text-align:center;font-weight: bold;">Sub Total</td>

                                            <td  style="text-align:center; font-weight: bold;">{{$countDateForSubQty}}</td>
                                            <td  style="text-align:right;font-weight: bold; padding-right:5px;" >{{number_format($countDateForSubTotal,2)}}</td>
                                        </tr>
                                    @endif
                                    

                    @php
                        $totalIssueDetailsAmount = $totalIssueDetailsAmount +$issueDetail->totalPrice; 
                                            
                        $totalIssueDetailsQuantity = $totalIssueDetailsQuantity + $issueDetail->issueQuantity;
                    @endphp

                                    

                @endforeach
                                    <tr class="totalRow">
                                        <td colspan="5" style="text-align: center;font-weight: bold; font-size:15px;">Total</td>  

                                        <td style="text-align:center;font-weight: bold;font-size:13px;">{{$totalIssueDetailsQuantity}}</td> 

                                        <td style="text-align:right;font-weight: bold; padding-right: 5px; font-size:13px; ">{{number_format($totalIssueDetailsAmount,2)}}</td>                                                                                              
                                    </tr>

                                    </tbody>
                                </table>
                            </div>
                        @endif
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>


<script type="text/javascript">
  $(document).ready(function() {

    function toDate(dateStr) {
    var parts = dateStr.split("-");
    return new Date(parts[2], parts[1] - 1, parts[0]);
}

    /* Date Range From */
    $("#dateFrom").datepicker({
            changeMonth: true,
            changeYear: true,
            yearRange : "1998:c",
            maxDate: "dateToday",
            dateFormat: 'dd-mm-yy',
            onSelect: function () {
                $('#dateFrome').hide();          
                $("#dateTo").datepicker("option","minDate",new Date(toDate($(this).val())));
                $( "#dateTo" ).datepicker( "option", "disabled", false );      
            }
        });
    /* Date Range From */

   

    /* Date Range To */
    $("#dateTo").datepicker({
            changeMonth: true,
            changeYear: true,
            yearRange : "1998:c",
            maxDate: "dateToday",
            dateFormat: 'dd-mm-yy',
            onSelect: function () {
                $('#dateToe').hide();           
            }
        });
//$( "#dateTo" ).datepicker( "option", "disabled", true );
    /* End Date Range To */

    // var dateFromData = $("#dateFrom").val();

    //  if (dateFromData!="") {
    //     $("#dateTo").datepicker("option","minDate",new Date(toDate(dateFromData)));
    //     //$("#dateTo").datepicker( "option", "disabled", false );  
    // }


    /*Active Deactive Search Option Base on Radio Button*/
     // $("input:radio[name='searchRadio']").click(function() {
     //   var value = $(this).val();
     //   if (value==1) {
        //$('#fiscalYear').prop('disabled', false);
        //$( "#dateFrom" ).datepicker( "option", "disabled", true );
        //$( "#dateFrom" ).datepicker().attr('readonly','readonly');
       // }
       // if (value==2) {
        //$('#fiscalYear').prop('disabled', 'disabled');
        //$( "#dateFrom" ).datepicker( "option", "disabled", false );
     //   }
     // });
      //$("input:radio[name='searchRadio']").trigger('click');      

    /*End Active Deactive Search Option Base on Radio Button*/

    
    
  });/*End Doc Ready*/
</script>

  {{-- Filtering Mehod --}}
  <script type="text/javascript">
      $(document).ready(function() {

          $("#searchMethod").change(function(event) {
            
              var searchMethod = $(this).val();
              if (searchMethod=="") {
                $("#fiscalYearDiv").hide();
                $("#dateRangeDiv").hide();
              }
              //Fiscal Year
              else if(searchMethod==1){
                $("#fiscalYearDiv").show();
                $("#dateRangeDiv").hide();
              }

              //Current Year
              else if(searchMethod==2){
                $("#fiscalYearDiv").hide();
                $("#dateRangeDiv").show();
                var d = new Date();
                var year = d.getFullYear();
                var month = d.getMonth();
                if (month<=5) {
                    year--;
                    month = 6;
                }
                else{
                    month = 6;
                }
                d.setFullYear(year, month, 1); 
                             
                $("#dateFrom").datepicker("option","minDate",new Date(d));
                $("#dateTo").datepicker("option","minDate",new Date(d));

                $("#dateFrom").datepicker("setDate", new Date(d));
                $("#dateFrom").hide();
                $("#dateFrome").hide();

                $("#dateToDiv").attr("class", "col-sm-12");
              }

              //Date Range
              else if(searchMethod==3){
               $("#fiscalYearDiv").hide();
                $("#dateRangeDiv").show();

                 $("#dateToDiv").attr("class", "col-sm-6");
                $("#dateFrom").show();
                //$("#dateFrom").val("");

                $("#dateFrom").datepicker("option","minDate",new Date(Date.parse("1998-01-01")));
              }
          });
          $("#searchMethod").trigger('change');
      });
  </script>
  {{-- End Filtering Mehod --}}

<script type="text/javascript">
    $(document).ready(function() {
        //$('body').width( "3000" );
    });
</script>

{{-- Filtering --}}
<script type="text/javascript">
    jQuery(document).ready(function($) {

        function pad (str, max) {
              str = str.toString();
              return str.length < max ? pad("0" + str, max) : str;
            }

         /* Change Project*/
         $("#searchProject").change(function(){
            
            var projectId = $(this).val();

            var csrf = "<br />
<b>Fatal error</b>:  Uncaught Error: Call to undefined function csrf_token() in /home/shikkhaplus/public_html/resources/views/inventory/reports/issueReport/viewInvIssueDetailsReport.blade.php:601
Stack trace:
#0 {main}
  thrown in <b>/home/shikkhaplus/public_html/resources/views/inventory/reports/issueReport/viewInvIssueDetailsReport.blade.php</b> on line <b>601</b><br />