@extends('layouts.app')
@section('title', 'Item Wise Sales Statement')
@section('pages')
<style type="text/css">
  .breadcrumb-title {
    border-right: none;
  }
  .thbutton {
    width: 7% !important;
}
</style>
@php $pageTitle="Item Wise Sales Statement"; @endphp

<link rel="stylesheet" type="text/css" href="{{ asset('admin/plugins/datepicker/less/datepicker.less') }}">
<link href="{{ asset('admin/plugins/datepicker/css/datepicker.css') }}" rel="stylesheet" />
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/intl-tel-input/12.1.10/css/intlTelInput.css">
<link href="{{ asset('admin/css/print.css')}}" rel="stylesheet" />

<!--breadcrumb-->
<div class="page-breadcrumb d-flex align-items-center mb-3 px-3 px-md-0">
  <div class="breadcrumb-title pe-3"><i class="bi bi-list"></i> Item Wise Sales Statement</div>

  <div class="ms-auto">
    <div class="btn-group">
        <a href="{{ route('sale.index') }}" class="btn btn-outline-secondary me-2"><i class="bx bx-arrow-back ms-0 me-1"></i>Back</a>
    </div>
  </div>
</div>
<!--end breadcrumb-->

<div class="card shadow-none radius-5 min-height">
  <div class="card-header py-3">
    <div class="row gx-2 custom_grid align-items-end gx-0 mt-4 mb-3">

      <div class="col-lg-3 col-md-3 col-3 mb-3">
        <div class="input-group">
          <label class="form-label">Company <span class="text-danger"><b></b></span></label>
          <select class="form-control br-0" id="company" name="company" required>
            <option value="">All Companies</option>
            @foreach($companies as $list)
              <option value="{{ $list->id}}">{{ $list->name }}</option>
            @endforeach
          </select>
        </div>
      </div>

      <div class="col-lg-3 col-md-3 col-3 mb-3">
        <div class="input-group">
          <label class="form-label">From Date <span class="text-danger"><b></b></span></label>
          <input class="form-control" type="text" id="from_date" name="from_date" placeholder="dd/mm/YY" value="">
        </div>

      </div>
      <div class="col-lg-3 col-md-3 col-3 mb-3">
        <div class="input-group">
          <label class="form-label">To Date <span class="text-danger"><b></b></span></label>
          <input class="form-control" type="text" id="to_date" name="to_date" placeholder="dd/mm/YY" value="">

        </div>
      </div>

   <!--    <div class="col-lg-3 col-md-3 col-3 mb-3">
        <div class="input-group references">
          <label class="form-label">Collection Status <span class="text-danger"><b></b></span></label>
          <select class="form-control br-0" id="collection_status" name="collection_status" required>
            <option value="">All Bill</option>
            <option value="due">Due</option>
            <option value="collected">Collected</option>
          </select>
        </div>
      </div>
 -->
      <div class="col-lg-3 col-md-3 col-3 mb-3">
        <div class="input-group">
          <label class="form-label">User Name / ID<span class="text-danger"><b></b></span></label>
          <select name="created_by" class="form-control" id="created_by">
            @if(auth::user()->user_type=='admin')
            <option value="" selected>All User</option>
            @endif
              
            @foreach(allActiveUsers() as $key => $value)
              @if(auth::user()->user_type=='admin')
              <option value="{!! $value->id !!}" {!! $value->id==auth::user()->id && auth::user()->user_type!='admin'?'selected':''  !!}>{!! $value->name !!} ({!! $value->email !!})</option>
              @elseif($value->id==auth::user()->id)
              <option value="{!! $value->id !!}" {!! $value->id==auth::user()->id && auth::user()->user_type!='admin'?'selected':''  !!}>{!! $value->name !!} ({!! $value->email !!})</option>
              @endif
            @endforeach
          </select>
          <a href="javascript:void(0)" class="hiddenReferral fw-bold" id="add_reference" style="padding: 10px;"><i class="bx bx-plus"></i></a>
        </div>
      </div>

      <div class="col-lg-3 col-md-3 col-3">
        <div class="input-group references" style="display:none;">
          <label class="form-label">Doctor<span class="text-danger"><b></b></span></label>

          <input type="text" name="" id="doctor_id" class="doctor-select form-control" placeholder="Search Doctor" value="">
          <ul class="searchResult"></ul>
          <input type="hidden" name="doctor_id" value="{!! $doctor->id ?? '' !!}">
        </div>
      </div>
      <div class="col-lg-2 col-md-2 col-2">
        <div class="input-group references" style="display:none;">
          <label class="form-label">Voucher Type<span class="text-danger"><b></b></span></label>
          <select name="voucher_type_code" class="form-control" id="voucher_type_code">
            <option value="" selected>All Vouchers</option>
              @foreach($voucher_types as $list)
                <option value="{{ $list->code}}">{{ $list->name }}</option>
              @endforeach
          </select>
        </div>
      </div>
        <div class="col-lg-2 col-md-2 col-2 dataTables_length" id="example_length">
          <div class="input-group references" style="display:none;">
              <label class="form-label">Item Group</label>
              <select class="form-select group_id" id="group_id" name="example_length" aria-controls="example">
                  <option value="">All Group</option>
                  @foreach ($group as $value)
                      <option value="{!! $value->id !!}">{!! $value->name !!}</option>
                  @endforeach
              </select>
          </div>
        </div>
        <div class="col-lg-2 col-md-2 col-2 dataTables_length" id="example_length">
          <div class="input-group references" style="display:none;">
              <label class="form-label">Item Brand</label>
              <select class="form-select brand_id" id="brand_id" name="example_length" aria-controls="example">
                  <option value="">All Brand</option>
                  @foreach ($brand as $value)
                      <option value="{!! $value->id !!}">{!! $value->name !!}</option>
                  @endforeach
              </select>
          </div>
        </div>
        <div class="col-lg-2 col-md-2 col-2 dataTables_length" id="example_length">
          <div class="input-group references" style="display:none;">
              <label class="form-label">Item Category</label>
              <select class="form-select category_id" id="category_id" name="example_length" aria-controls="example">
                  <option value="">All Category</option>
                  @foreach ($category as $value)
                      <option value="{!! $value->id !!}">{!! $value->name !!}</option>
                  @endforeach
              </select>
          </div>
        </div>
        <div class="col-lg-2 col-md-2 col-2 dataTables_length mt-4" id="example_length">
          <div class="input-group references" style="display:none;">
              <label class="form-label">Business Division</label>
              <select class="form-select division_id" id="division_id" name="example_length" aria-controls="example">
                  <option value="">All Business Division</option>
                  @foreach ($business_division as $value)
                      <option value="{!! $value->id !!}">{!! $value->name !!}</option>
                  @endforeach
              </select>
          </div>
        </div>

      <div class="col-lg-2 col-md-2 col-2 mt-4">
        <div class="input-group references" style="display:none;">
          <label class="form-label">Search Account <span class="text-danger"><b></b></span></label>
          <input type="text" name="search_account" id="search_account" class="form-control" placeholder="Search Account">
        </div>
      </div>

    </div>
    <div class="row mt-2">
      <div class="col-lg-12 col-md-12 col-12 text-center">
        <button class="btn btn-primary" id="submit" type="button" style="height: 40px; width: 25% !important;"><i class="bi bi-search"></i> Search</button>
      </div>
    </div>
    <input type="hidden" name="hidden_page" id="hidden_page" value="1" />
    <input type="hidden" name="hidden_column_name" id="hidden_column_name" value="name" />
    <input type="hidden" name="hidden_sort_type" id="hidden_sort_type" value="asc" />
  <hr>
    <div class="card-body" >
        <div class="row" style="">
          <div class="col-md-12" id="tables">
            
          </div>
        </div>
    </div>
    <script type="text/javascript" src="{{ asset('admin/plugins/datepicker/js/bootstrap-datepicker.js')}}"></script>
    <script>

      $(document).on('click', '#add_reference', function() {
        if ($('#add_reference').hasClass('hiddenReferral')) {
            $('.references').show();
            $('#add_reference').html('<i class="bx bx-minus"></i>');
            $('#add_reference').removeClass('hiddenReferral');
        } else {
            $('.references').hide();
            $('#add_reference').html('<i class="bx bx-plus"></i>');
            $('#add_reference').addClass('hiddenReferral');
        }
      });
       $('[name="from_date"]').datepicker({
        format: "{!! $companyDateFormate??'dd-mm-yyyy' !!}",
        autoclose: true,
        //startDate: financialYearDates.fromDate,//optional
        //endDate: financialYearDates.toDate//optional
        }).datepicker("setDate", new Date());
      $('[name="to_date"]').datepicker({
      format: "{!! $companyDateFormate??'dd-mm-yyyy' !!}",
      autoclose: true,
      //startDate: financialYearDates.fromDate,//optional
      //endDate: financialYearDates.toDate//optional
      }).datepicker("setDate", new Date());
      $(document).ready(function() {
        function clear_icon() {
          $('#id_icon').html('');
          $('#post_title_icon').html('');
        }

        function fetch_data(category, from_date, brand, to_date, search_account, collection_status,company,created_by) {

          $('#submit').prop('disabled',true);
          $('#submit').html('Loading Please Wait.');

          var voucher_type_code = $('#voucher_type_code').val();
          var group_id    = $('#group_id').val();
          var brand_id    = $('#brand_id').val();
          var category_id = $('#category_id').val();
          var division_id = $('#division_id').val();
          var doctor_id = $('[name="doctor_id"]').val();

          $.ajax({
            url: "?from_date=" + from_date + "&to_date=" + to_date + "&search_account=" + search_account + "&collection_status=" + collection_status + "&company=" + company + "&voucher_type_code=" + voucher_type_code + "&created_by=" + created_by + "&group_id=" + group_id + "&brand_id=" + brand_id + "&category_id=" + category_id + "&division_id=" + division_id + "&doctor_id=" + doctor_id,
            success: function(data) {
              $('#tables').html('');
              $('#tables').html(data);
              $('#submit').prop('disabled',false);
              $('#submit').html('<i class="bi bi-search"></i> Search');
              // $(document).ready(function() {
              //   $.switcher();
              // });
              $('#example').dataTable({
                paging: false,
                searching: false,
                info: false
              });
            }
          })
        }

        $("body").on("click", '#submit', function(event) {
          var category          = $('#category').val();
          var brand             = $('#brand').val();
          var from_date         = $('#from_date').val();
          var to_date           = $('#to_date').val();
          var search_account    = $('#search_account').val();
          var collection_status = $('#collection_status').val();
          var created_by        = $('#created_by').val();
          var company           = $('#company').val();

          fetch_data(category, from_date, brand, to_date, search_account, collection_status,company,created_by);
        });

        $("body").on("click", '.export-statement', function(event) {
          var category          = $('#category').val();
          var brand             = $('#brand').val();
          var from_date         = $('#from_date').val();
          var to_date           = $('#to_date').val();
          var search_account    = $('#search_account').val();
          var collection_status = $('#collection_status').val();
          var created_by        = $('#created_by').val();
          var company           = $('#company').val();
          var group_id          = $('#group_id').val();
          var brand_id          = $('#brand_id').val();
          var category_id       = $('#category_id').val();
          var division_id       = $('#division_id').val();
          var doctor_id         = $('[name="doctor_id"]').val();

          var queryStr          = "from_date=" + from_date + "&brand=" + brand + "&to_date=" + to_date + "&search_account=" + search_account + "&company=" + company + "&created_by=" + created_by + "&group_id=" + group_id + "&brand_id=" + brand_id + "&category_id=" + category_id + "&division_id=" + division_id + "&doctor_id=" + doctor_id;

          window.location.href="{!! route('sale-return-item-wise.statement-export') !!}?" + queryStr; 
    });


      });
    </script>



    <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/1.3.4/jspdf.min.js"></script>

    <script>
    $(document).ready(function() {
        var page_title = $('#page_title').val();
        $("title").html(page_title);
        $(document).on('click', '#btn_print', function(event) {
            event.preventDefault();
            $('#btn_back').hide();
            printInvoice();
            return;
            // printInvoice(page_title);
            /*$('#print_div').printThis({
                importStyle: true,
            });*/
            $(this).hide();
            var printContents = document.getElementById('print_div').innerHTML;
            var originalContents = document.body.innerHTML;

            document.body.innerHTML = printContents;

            window.print();

            document.body.innerHTML = originalContents;

            $(this).show();
            $('#btn_back').show();
            $('#btn_print').show();
        });

        $(document).on('click', '#btn_pdf', function(e) {
            html2canvas($('#print_div'), {
                background: "#ffffff",
                onrendered: function(canvas) {
                    var myImage = canvas.toDataURL("image/png", 1.0);
                    // Adjust width and height
                    var imgWidth = (canvas.width * 43) / 250;
                    var imgHeight = (canvas.height * 48) / 250;
                    // jspdf changes
                    var pdf = new jsPDF('p', 'mm', 'a4');
                    pdf.addImage(myImage, 'png', 5, 5, imgWidth, imgHeight); // 2: 19
                    pdf.save(`${$('#page_title').val()}.pdf`);
                }
            });
        });
    });

    function printInvoice() {
        let printDiv = $('#print_div').html();
        let content = window.open('', '', 'height=750px,width=960px');
        let doc = content.document;
        let head = doc.head;
        let body = doc.body;

        $(head).append('<Title>{{$pageTitle}}</Title>');
        $(head).append('<link rel="stylesheet" href="{{ asset('admin/css/bootstrap.min.css') }}" type="text/css">');
        $(head).append('<link rel="stylesheet" href="{{ asset('admin/css/print.css') }}" type="text/css">');
        $(head).append('<style>@page {size: auto;}</style>');
        $(body).append(printDiv);

        setTimeout(function() {
            content.print();
        }, 500);
    }


    $(document).ready(function(){
      $('.doctor-select').autocomplete({
          autoFocus: true,
          minLength: 0,
          source: function(request, response) {
              if (request.term.length < 2) {
                  $('[name="doctor_id"]').val('');
                  return false;
              }

              $.ajax({
                  url     : "{{ route('billings-search-doctors') }}",
                  type    : 'POST',
                  dataType: 'json',
                  data    : {
                      search_text: request.term
                  },
                  success: function(json) {
                      if (json.error) {
                          $('[name="doctor_id"]').val('');
                          return false;
                      }
                      response($.map(json.result, function(item) {
                          return {
                              id           : item.id,
                              name         : item.name,
                              code         : item.code,
                              gender       : item.gender,
                              phone_no     : item.phone_no,
                              date_of_birth: item.date_of_birth,
                          };
                      }));
                  }
              });
          },
          select: function(event, ui) {
              event.preventDefault();
              var age      = ui.item.date_of_birth != null ? ', ' + getAge(ui.item.date_of_birth) + ' Years' : '';
              var gender   = ui.item.gender != null ? ', ' + ui.item.gender : '';
              var phone_no = ui.item.phone_no != null ? ', ' + ui.item.phone_no : '';
              var code = ui.item.code != null ? ', ' + ui.item.code : '';

              $(this).val(ui.item.name + code + gender + age + phone_no + "");
              $('[name="doctor_id"]').val(ui.item.id);

              $.ajax({
                url     : '{!! route("ipd-cart-product-update") !!}',
                method  : 'post',
                data    : {
                      "_token": $('meta[name ="csrf-token"]').attr('content'),
                      "doctor_id": ui.item.id,
                }
              });

              return false;
          }
      }).data("ui-autocomplete")._renderItem = function(ul, item) {
          var age      = item.date_of_birth != null ? ', ' + getAge(item.date_of_birth) + ' Years' : '';
          var gender   = item.gender != null ? ', ' + item.gender : '';
          var phone_no = item.phone_no != null ? ', ' + item.phone_no : '';
          var code = item.code != null ? ', ' + item.code : '';

          return $("<li>")
              .append("<a>" + item.name + code + gender + age + phone_no + "</a>")
              .appendTo(ul);
      };
    });
</script>
    @endsection