@extends('layout.master')
@section('pageTitle')
  <title>Pawnshop Management System</title>
@endsection
@section('metaCSRF')
  <meta name="csrf-token" content="{{ csrf_token() }}">
@endsection
@section('contents')
    <style>
    label {
      font-size:0.9em !important;
    }
    .pac-container {
      z-index: 99999999 !important;
    }
    .ui-front {
      z-index: 9999 !important;
    }
  </style>
  <link rel="stylesheet" href="/css/autocomplete-jquery-ui.css">
  <link rel="stylesheet" href="/theme/plugins/datatables-bs4/css/dataTables.bootstrap4.css">
  <link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">

  <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">Branch Report (Daily)</h1>
          </div><!-- /.col -->
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="#">Home</a></li>
              <li class="breadcrumb-item active">Branch Report</li>
            </ol>
          </div><!-- /.col -->
        </div><!-- /.row -->
      </div><!-- /.container-fluid -->
    </div>
    <!-- /.content-header -->
    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <!-- Small boxes (Stat box) -->
        <div class="row">
          <div class="col-12">
            <div class="card">
              <div class="card-header">
                <h3 class="card-title">Transactions List</h3>
                <br>
                <div class="col-md-3">
                  <div class="form-group">
                    <label>Entry Date</label>
                    <div class="input-group">
                      <div class="input-group-prepend">
                        <span class="input-group-text">
                          <i class="far fa-calendar-alt"></i>
                        </span>
                      </div>
                      <input type="text" class="form-control form-control-sm float-right trans-input" id="entrydate" name="entrydate" value="{{date('Y-m-d')}}">
                      <input type="hidden" id="branchcode" name="branchcode" value="{{$currrentuser['branch']}}">
                      <input type="hidden" id="usercode" name="usercode" value="{{$currrentuser['user']}}">
                      <input type="hidden" id="userlevel" name="userlevel" value="{{$currrentuser['level']}}">
                    </div>
                  </div>
                  <button id="populate-transaction-btn" type="button" class="btn btn-sm btn-success form-control form-control-sm">Populate</button>
                </div>
                @if($isresetAllowed == true)
                    <div class="col-md-3" style="margin-top:5px;">
                      <button id="reset-partial-transaction-btn" type="button" class="btn btn-sm btn-warning form-control form-control-sm">Partial Reset</button>
                    </div>
                    <div class="col-md-3" style="margin-top:5px;">
                      <button id="reset-transaction-btn" type="button" class="btn btn-sm btn-danger form-control form-control-sm">Reset</button>
                    </div>
                @endif
              </div>
              <!-- /.card-header -->
              <div class="card-body">
                <table id="example2" class="table table-bordered table-hover">
                  <thead>
                    <tr style="background:rgba(0,0,0,0.1);">
                      <th>Count/Lottes</th>
                      <th>Transaction Type</th>
                      <th>Transaction Description</th>
                      <th>Debit</th>
                      <th>Credit</th>
                      <th>Status</th>
                    </tr>
                  </thead>
                  <tbody></tbody>
                </table>
                <hr>
                <div class="row">
                  <div class="col-md-6"></div>
                  <div class="col-md-2">
                    <button id="post-transaction-btn" type="button" class="btn btn-sm btn-info form-control form-control-sm">Post</button>
                  </div>
                  <div class="col-md-2">
                    <button id="print-transaction-btn" type="button" class="btn btn-sm btn-warning form-control form-control-sm">Print</button>
                  </div>
                  @if($isresetAllowed == true)
                    <div class="col-md-2">
                      <button id="delete-transaction-btn" type="button" class="btn btn-sm btn-danger form-control form-control-sm">Delete</button>
                    </div>
                  @endif
                </div>
                <hr>
                <div class="row">
                  <div class="col-md-5">
                    <div class="row">
                      <div class="col-md-6">
                        <div class="form-group">
                          <label>Total Debit: </label><br>
                          <label>Total Credit: </label><br>
                          <hr>
                          <label>Cash in Vault: </label><br>
                          <label>Cash Float: </label><br>
                          <label>Cash Count: </label><br>
                          <label>Total Cash Count: </label><br>
                          <hr>
                          <label>Beginning Balance: </label><br>
                          <label>Ending Balance: </label><br>
                          <label>Variance: </label><br>
                        </div>
                      </div>
                      <div class="col-md-6">
                        <div class="form-group">
                          <label id="totaldeb">0.00</label><br>
                          <label id="totalcre">0.00</label><br>
                          <hr>
                          <label id="cashinvault">0.00</label><br>
                          <label id="cashfloat">0.00</label><br>
                          <label id="cashcount">0.00</label><br>
                          <label id="totalcashcount">0.00</label><br>
                          <hr>
                          <label id="beginbal">0.00</label><br>
                          <label id="endingbal">0.00</label><br>
                          <label id="variance">0.00</label><br>
                        </div>
                      </div>
                    </div>
                  </div>
                  <div class="col-md-7">
                    <h5 style="font-weight:bold;">Cash Count Details</h5>
                    <table id="cashcountTable" class="table table-bordered table-hover">
                      <thead>
                        <tr style="background:rgba(0,0,0,0.1);">
                          <th>Denomination</th>
                          <th>Count</th>
                          <th>Total</th>
                        </tr>
                      </thead>
                      <tbody></tbody>
                    </table>
                    <hr>
                    <h5 style="font-weight:bold;">Inventory Details</h5>
                    <table id="inventoryTable" class="table table-bordered table-hover">
                      <thead>
                        <tr style="background:rgba(0,0,0,0.1);">
                          <th>Pledge Inventory</th>
                          <th>Count</th>
                          <th>Total</th>
                        </tr>
                      </thead>
                      <tbody></tbody>
                    </table>
                  </div>
                </div>
                <form id="itembranchform"></form>
              </div>
              <!-- /.card-body -->
            </div>
            <!-- /.card -->
          </div>
          <!-- /.col -->
        </div>
      </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->
  </div>
  <!-- Modal -->

@endsection
@section('js')
<script src="/theme/plugins/datatables/jquery.dataTables.js"></script>
<script src="/theme/plugins/datatables-bs4/js/dataTables.bootstrap4.js"></script>

<script src="/theme/dist/js/pages/dashboard.js"></script>
<script src="/theme/dist/js/demo.js"></script>
<script src="/theme/plugins/datatables/jquery.dataTables.js"></script>
<script src="/theme/plugins/datatables-bs4/js/dataTables.bootstrap4.js"></script>

<script>
  $("#entrydate").datepicker({
    dateFormat: "yy-mm-dd",
    maxDate: new Date
  });
  var dataTable = $('#example2').DataTable({
      keys: true,
      draw: true,
      "dom": '<"top"i>rt<"bottom"flp><"clear">',
    });
  var countTable = $('#cashcountTable').DataTable({
      keys: true,
      draw: true,
      "dom": '<"top"i>rt<"bottom"flp><"clear">',
    });
  var invTable = $('#inventoryTable').DataTable({
      keys: true,
      draw: true,
      "dom": '<"top"i>rt<"bottom"flp><"clear">',
    });
  function computeTotal(){
    var capital = $('#capital').val();
    var servicefee = $('#servicefee').val();
    var handlingfee = $('#handlingfee').val();
    var totalamount = parseFloat(capital) + parseFloat(servicefee) + parseFloat(handlingfee);
    $('#totalamount').val(totalamount.toFixed(2));
  }
  $('#populate-transaction-btn').on('click',function(event){
    event.preventDefault();
    populateServiceData();
  });
  $('#post-transaction-btn').on('click',function(event){
    event.preventDefault();
    var delr = confirm("Confirm Posting!");
    if (delr == true) {
      postServiceData();
    }
  });
  $('#reset-transaction-btn').on('click',function(event){
    event.preventDefault();
    var delr = confirm("Confirm Full Reset!");
    if (delr == true) {
      resetServiceData();
    }
  });
  $('#reset-partial-transaction-btn').on('click',function(event){
    event.preventDefault();
    var delr = confirm("Confirm Partial Reset!");
    if (delr == true) {
      resetServiceDataPartial();
    }
  });
  $('#delete-transaction-btn').on('click',function(event){
    event.preventDefault();
    var delr = confirm("Confirm Delete!");
    if (delr == true) {
      deleteServiceData();
    }
  });
  function populateServiceData(){
    $.ajax({
        url: '/settings-request',
        headers: {'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')},
        type:'POST',
        data: {request: 'branchreport', type: 'getdailytrans', date: $('#entrydate').val(), branch: $('#branchcode').val(), user: $('#usercode').val(), userlevel: $('#userlevel').val()},
        success:function(data){
          if(data){
            console.log(data);
            var e = data.journal;
            dataSet = [];
            var drtotal = 0;
            var crtotal = 0;
						for(num in e){
              var dr = "";
              var cr = "";
              var ispostedStr = e[num].isposted;

              if(e[num].normalbalance == "Dr") {
                drtotal = parseFloat(drtotal) + parseFloat(e[num].amount);
                dr = parseFloat(e[num].amount).toFixed(2);
              }
              else if(e[num].normalbalance == "Cr") {
                crtotal = parseFloat(crtotal) + parseFloat(e[num].amount);
                cr = parseFloat(e[num].amount).toFixed(2);
              }
              if(ispostedStr == "Draft"){
                if(e[num].transtypecode == "OS"){
                  if($('#userlevel').val() == "checker"){
                    ispostedStr = e[num].isposted + ' <input id="'+e[num].id+'"type="checkbox" value="'+e[num].id+'" />';
                  }
                  else {
                    if($('#entrydate').val() > '2021-08-16'){
                      if(e[num].transcode == "GCIN") ispostedStr = e[num].isposted;
                      else if(e[num].transcode == "GCOT") ispostedStr = e[num].isposted;
                      else ispostedStr = e[num].isposted + ' <input id="'+e[num].id+'"type="checkbox" value="'+e[num].id+'" />';
                    }
                    else ispostedStr = e[num].isposted + ' <input id="'+e[num].id+'"type="checkbox" value="'+e[num].id+'" />';
                  }
                }
                else if(e[num].transtypecode == "FX") ispostedStr = e[num].isposted + ' <input id="'+e[num].id+'"type="checkbox" value="'+e[num].id+'" />';
                else if(e[num].transtypecode == "FT") ispostedStr = e[num].isposted + ' <input id="'+e[num].id+'"type="checkbox" value="'+e[num].id+'" />';
                else if(e[num].transtypecode == "MS") ispostedStr = e[num].isposted + ' <input id="'+e[num].id+'"type="checkbox" value="'+e[num].id+'" />';
              }
              var lottes = "";
              if(parseInt(e[num].count) > 0) lottes = e[num].count;
              dataSet.push([
								//e[num].transcode,
                lottes,
								e[num].transtype,
								e[num].description,
                dr,
                cr,
                ispostedStr,
              ]);
						}
            dataSet.push([
              "",
              "",
              "<b>Total</b>",
              "<b>"+drtotal.toFixed(2)+"</b>",
              "<b>"+crtotal.toFixed(2)+"</b>",
              ""
            ]);
						dataTable.destroy();
						dataTable.draw();
						$('#example2').DataTable({
              "scrollY":"auto",
              keys: true,
              draw: true,
              paging:   false,
              info:     false,
              "autoWidth": false,
              "ordering": false,
							data: dataSet,
							columns: [
								{ title: "Count/Lottes" },
								{ title: "Transaction Type" },
                { title: "Description" },
                { title: "Debit" },
                { title: "Credit" },
                { title: "Status" },
							]}),
							dataTable = $('#example2').DataTable();
            generateCashCount(data.cashcountdaily);
            generateInventory(data.inventorylist);
            $('#beginbal').text(parseFloat(data.beginbal).toFixed(2));
            $('#totaldeb').text(parseFloat(data.debit).toFixed(2) + "(Dr)");
            $('#totalcre').text(parseFloat(data.credit).toFixed(2) + "(Cr)");
            $('#cashinvault').text(parseFloat(data.civ).toFixed(2));
            $('#cashfloat').text(parseFloat(data.caf).toFixed(2));
            $('#cashcount').text(parseFloat(data.cashcount).toFixed(2));
            $('#totalcashcount').text(parseFloat(data.totalcashcount).toFixed(2));
            $('#endingbal').text(parseFloat(data.endbal).toFixed(2));
            $('#variance').text(parseFloat(data.variance).toFixed(2));
            if(data.isposted == 1){
              $('#post-transaction-btn').prop('disabled',true);
            }
            else {
              var variance = parseFloat(data.variance).toFixed(2);
              if(variance != 0) $('#post-transaction-btn').prop('disabled',true);
              else $('#post-transaction-btn').prop('disabled',false);
            }


          }
        }
    });
  }
  function postServiceData(){
    $('#post-transaction-btn').text('Please wait..');
    $('#post-transaction-btn').prop('disabled',true);
    $.ajax({
        url: '/settings-request',
        headers: {'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')},
        type:'POST',
        data: {request: 'branchreport', type: 'postdailytrans', date: $('#entrydate').val(), branch: $('#branchcode').val(), user: $('#usercode').val(), userlevel: $('#userlevel').val()},
        success:function(data){
          if(data){
            console.log(data);
            $('#post-transaction-btn').text('Post');
            $('#post-transaction-btn').prop('disabled',false);
            populateServiceData();
          }
        }
    });
  }
  function deleteServiceData(){
    var itemList = '';
    itemList = itemList + '<input type="hidden" name="transdate" value="'+$('#entrydate').val()+'"/>';
    itemList = itemList + '<input type="hidden" name="branch" value="'+$('#branchcode').val()+'"/>';
    itemList = itemList + '<input type="hidden" name="request" value="branchreport"/>';
    itemList = itemList + '<input type="hidden" name="type" value="deletedailytrans"/>';
    $(':checkbox:checked').each(function(){
      var itemListId = $(this).attr('id');
      itemList = itemList + '<input type="hidden" value="'+itemListId+'" name="items[]" />'
      console.log(itemListId);
    });
    $('#itembranchform').html(itemList);
    console.log(itemList);
    $.ajax({
        url: '/settings-request',
        headers: {'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')},
        type:'POST',
        data: $('#itembranchform').serialize(),
        success:function(data){
          if(data){
            console.log(data);
            populateServiceData();
          }
        }
    });
  }
  function resetServiceData(){
    var itemList = '';
    itemList = itemList + '<input type="hidden" name="transdate" value="'+$('#entrydate').val()+'"/>';
    itemList = itemList + '<input type="hidden" name="branch" value="'+$('#branchcode').val()+'"/>';
    itemList = itemList + '<input type="hidden" name="request" value="branchreport"/>';
    itemList = itemList + '<input type="hidden" name="type" value="resetdailytrans"/>';
    $(':checkbox:checked').each(function(){
      var itemListId = $(this).attr('id');
      itemList = itemList + '<input type="hidden" value="'+itemListId+'" name="items[]" />'
      console.log(itemListId);
    });
    $('#itembranchform').html(itemList);
    console.log(itemList);
    $.ajax({
        url: '/settings-request',
        headers: {'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')},
        type:'POST',
        data: $('#itembranchform').serialize(),
        success:function(data){
          populateServiceData();
        }
    });
  }
  function resetServiceDataPartial(){
    var itemList = '';
    itemList = itemList + '<input type="hidden" name="transdate" value="'+$('#entrydate').val()+'"/>';
    itemList = itemList + '<input type="hidden" name="branch" value="'+$('#branchcode').val()+'"/>';
    itemList = itemList + '<input type="hidden" name="request" value="branchreport"/>';
    itemList = itemList + '<input type="hidden" name="type" value="partialresetdailytrans"/>';
    $(':checkbox:checked').each(function(){
      var itemListId = $(this).attr('id');
      itemList = itemList + '<input type="hidden" value="'+itemListId+'" name="items[]" />'
      console.log(itemListId);
    });
    $('#itembranchform').html(itemList);
    console.log(itemList);
    $.ajax({
        url: '/settings-request',
        headers: {'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')},
        type:'POST',
        data: $('#itembranchform').serialize(),
        success:function(data){
          populateServiceData();
        }
    });
  }

  function generateCashCount(cashcountdaily){
    var cc = cashcountdaily;
    var countSet = [];
    for(num in cc){
      countSet.push([
        cc[num].denomination,
        cc[num].count,
        numberWithCommas(parseFloat(cc[num].total).toFixed(2)),
      ]);
    }
    countTable.destroy();
    countTable.draw();
    $('#cashcountTable').DataTable({
      "scrollY":"auto",
      keys: true,
      draw: true,
      paging:   false,
      info:     false,
      "autoWidth": false,
      "ordering": false,
      data: countSet,
      columns: [
        { title: "Denomination" },
        { title: "Count" },
        { title: "Total" },
      ]}),
      countTable = $('#cashcountTable').DataTable();
  }
  function generateInventory(inventorydaily){
    var inv = inventorydaily;
    var invSet = [];
    for(num in inv){
      if(parseInt(inv[num].count) > 0){
        invSet.push([
          inv[num].pledge,
          inv[num].count,
          numberWithCommas(parseFloat(inv[num].capital).toFixed(2)),
        ]);
      }
    }
    invTable.destroy();
    invTable.draw();
    $('#inventoryTable').DataTable({
      "scrollY":"auto",
      keys: true,
      draw: true,
      paging:   false,
      info:     false,
      "autoWidth": false,
      "ordering": false,
      data: invSet,
      columns: [
        { title: "Pledge Inventory" },
        { title: "Count" },
        { title: "Total" },
      ]}),
      invTable = $('#inventoryTable').DataTable();
  }
  function numberWithCommas(x) {
    return x.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ",");
  }
</script>
<script>
</script>

<script>
  $('#print-transaction-btn').on('click',function(){
    $.ajax({
        url: '/daily-report-print-request',
        headers: {'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')},
        type:'POST',
        data: {request: 'branchreport', type: 'getdailytrans', date: $('#entrydate').val(), branch: $('#branchcode').val(), user: $('#usercode').val(), userlevel: $('#userlevel').val()},
        success:function(e){
          if(e){
            console.log(e);
            let params = 'scrollbars=no,resizable=no,status=no,location=no,toolbar=no,menubar=no,width=700,height=500,left=-10,top=-10';
            window.open(e,"_blank",params);
            return false;
          }
        }
    });
  });
</script>

@endsection