@extends('layouts.app')
@section('content')

<style>
  :root {
    --primary-color: #34548A;
    --secondary-color: #ebe7e7;
    --border-color: #d7d7d7;
  }

  /* Pagination button styles */
  .dataTables_wrapper .dataTables_paginate .paginate_button {
    border: 2px solid var(--border-color) !important;
    color: var(--primary-color) !important;
    font-weight: bold;
  }

  .dataTables_wrapper .dataTables_paginate .paginate_button.current,
  .dataTables_wrapper .dataTables_paginate .paginate_button.current:hover {
    color: var(--secondary-color) !important;
    background: var(--primary-color) !important;
    border-color: var(--primary-color) !important;
    font-weight: bold !important;
  }

  .dataTables_wrapper .dataTables_paginate .paginate_button:hover {
    border: 2px solid var(--primary-color) !important;
    background: var(--primary-color) !important;
    color: var(--secondary-color) !important;
    font-weight: bold !important;
  }

  .dataTables_wrapper .dataTables_paginate .paginate_button.disabled,
  .dataTables_wrapper .dataTables_paginate .paginate_button.disabled:hover,
  .dataTables_wrapper .dataTables_paginate .paginate_button.disabled:active {
    color: var(--secondary-color) !important;
  }

  .dataTables_info {
    color: var(--primary-color) !important;
    font-size: 16px;
    font-weight: bold;
  }

  table.dataTable {
    border: none !important;
  }

  .dataTables_length {
    display: none;
  }

  .dataTables_processing {
    position: absolute;
    top: 40%;
    left: 50%;
    text-align: center;
    background: rgba(0, 0, 0, 0.71);
    z-index: 99;
    transform: translate(-50%, -50%);
    color: #fff;
    padding: 10px 20px;
  }

  table.dataTable thead {
    background-color: var(--primary-color) !important;
    border: 0 !important;
    padding: 5px !important;
    color: var(--secondary-color) !important;
    padding-top: 10px;
    padding-bottom: 10px;
  }

  table.dataTable thead th,
  table.dataTable tbody td {
    border: none !important;
  }

  table.dataTable tbody th,
  table.dataTable tbody td {
    padding: 16px 6px;
  }

  table.dataTable.stripe tbody tr.odd,
  table.dataTable.display tbody tr.odd {
    background-color: #f9f9f9;
  }

  .dataTables_filter {
    margin-bottom: 35px !important;
  }

  table tbody tr:nth-child(even) {
    background-color: #d7d7d7 !important;
  }

  table tbody tr:nth-child(odd) {
    background-color: #f8f8f8;
  }

  tbody tr td {
    color: #34548a;
    font-family: "Montserrat";
  }

  #historySection::-webkit-scrollbar {
    width: 12px;
  }

  #historySection::-webkit-scrollbar-track {
    background: #f1f1f1;
  }

  #historySection::-webkit-scrollbar-thumb {
    background-color: #34548A;
    border-radius: 10px;
    border: 3px solid #f1f1f1;
  }

  #historyTable_filter {
    margin-bottom: 20px !important;
    margin: 0px 17px;
    display: flex;
    align-items: baseline;
    justify-content: end;
  }

  #historyTable_filter input[type="search"] {
    padding: 9px 40px 9px 20px !important;
    letter-spacing: normal;
    border: 1px solid rgba(0, 0, 0, 0.2) !important;
    background-color: #fff;
    font-size: 15px !important;
    color: #4e4e4e;
    font-family: "Montserrat";
    border-radius: 30px;
    width: 75%;
    outline: none;
  }

  .search-icon,
  .spin-icon {
    position: absolute;
    z-index: 2;
    right: 15px !important;
    font-size: 16px;
    width: 20px;
    margin-left: -2.5px;
    text-align: center;
    opacity: 0.7;
    padding: 10px 0;
    top: 0px;
    color: #c2c2c2;
  }

  .spin-icon {
    display: none;
  }

  #historySection {
    width: 91%;
    margin: auto;
    margin-top: 30px;
    max-height: 87%;
    overflow-y: auto;
  }

  .date-div {
    width: 300px;
  }

  .datepicker {
    width: 100%;
    border: 1px solid #aaa;
    height: 37px;
    padding: 6px 12px;
    font-size: 14px;
  }

  .content_parent {
    margin-bottom: 20px;
    display: flex;
    flex-direction: column;
    align-items: baseline;
    margin-left: 6%;
  }

  .content-section {
    width: 40%;
    background: #fff;
  }

  .daterangepicker {
    z-index: 1050 !important;
  }

  .daterangepicker .calendar-table th,
  .daterangepicker .calendar-table td {
    min-width: 18px;
    width: 18px;
    height: 15px;
    line-height: 15px;
    font-size: 12px;
    font-family: "Montserrat";
  }

  #cdrSection {
    width: 91%;
    margin: auto;
    margin-top: 4%;
    margin-bottom: 5%;
  }

  .client-div,
  .report-div {
    width: 300px;
  }

  .fs-wrap,
  .fs-dropdown {
    width: 300px !important;
  }

  .fs-label-wrap .fs-label {
    padding: 10px 22px 10px 8px !important;
  }

  #submitBtn:focus,
  #downloadBillingReport:focus,
  #cdrDetailBtn:focus,
  select:focus {
    outline: none;
    box-shadow: none;
  }

  .submit-btn {
    margin-top: 15px;
  }

  .billing-div {
    display: flex;
    justify-content: space-evenly;
  }

  .inbound-card,
  .outbound-card {
    width: 42.2%;
    padding: 15px 0px;
    background-color: #fff;
  }

  .card-div {
    display: flex;
    justify-content: center;
    gap: 5%;
  }

  .text-div {
    display: flex;
    flex-direction: column;
    align-items: flex-start;
    margin-left: 5%;
  }

  .download-btn {
    margin-right: 5%;
  }

  /* .details-btn {
    margin-top: 2%;
  } */

  .mc-row {
    border-bottom: 2px dashed #34548A;
    padding-bottom: 50px;
  }

  .common-modal {
    position: fixed;
    top: 50%;
    left: 50%;
    transform: translate(-50%, -50%);
    padding: 20px;
    border-radius: 5px;
    box-shadow: 5px 5px 10px rgba(0, 0, 0, 0.3);
    border: 1px solid #e2e2e2;
    text-align: center;
    background-color: #f8f8f8;
    box-shadow: 0px 1px 15px rgba(0, 0, 0, 0.2);
    -moz-box-shadow: 0px 1px 15px rgba(0, 0, 0, 0.2);
    -webkit-box-shadow: 0px 1px 15px rgba(0, 0, 0, 0.2);
    z-index: 999;
    -webkit-box-shadow: 0px 0px 0px 9999px rgba(0, 0, 0, 0.5);
    -moz-box-shadow: 0px 0px 0px 9999px rgba(0, 0, 0, 0.5);
    box-shadow: 0px 0px 0px 9999px rgba(0, 0, 0, 0.5);
  }

  #historyModal {
    width: 80%;
    height: 90%;
  }

  .history-modal-close {
    cursor: pointer;
    font-size: 20px;
    line-height: 25px;
    margin-left: 98%;
    color: #64677a;
    font-weight: 100;
    z-index: 2;
  }

  /* ===========================
        CDR DASHBOARD
=========================== */

  .cdr-dashboard {
    margin-top: 30px;
    font-family: 'Segoe UI', sans-serif;
  }

  .dashboard-header {
    margin-bottom: 25px;
  }

  .dashboard-header h2 {
    margin: 0;
    font-size: 30px;
    font-weight: 700;
    color: #263238;
  }


  /* ===========================
        KPI CARDS
=========================== */

  .kpi-container {
    display: grid;
    grid-template-columns: repeat(4, 1fr);
    gap: 20px;
    margin-bottom: 30px;
  }

  .kpi-card {
    display: flex;
    align-items: center;
    background: #fff;
    border-radius: 14px;
    padding: 22px;
    box-shadow: 0 10px 25px rgba(0, 0, 0, .08);
    transition: .3s;
    border-left: 6px solid transparent;
  }

  .kpi-card:hover {
    transform: translateY(-5px);
    box-shadow: 0 18px 35px rgba(0, 0, 0, .15);
  }

  .kpi-icon {
    width: 65px;
    height: 65px;
    border-radius: 50%;
    display: flex;
    align-items: center;
    justify-content: center;
    font-size: 30px;
    margin-right: 18px;
    color: #fff;
  }

  .kpi-content {
    flex: 1;
  }

  .kpi-title {
    display: block;
    color: #7f8c8d;
    font-size: 14px;
    margin-bottom: 6px;
  }

  .kpi-content h3 {
    margin: 0;
    font-size: 32px;
    font-weight: bold;
    color: #263238;
  }

  .kpi-content small {
    color: #9e9e9e;
  }


  /* COLORS */

  .kpi-card.blue {
    border-color: #2196F3;
  }

  .kpi-card.blue .kpi-icon {
    background: #2196F3;
  }

  .kpi-card.green {
    border-color: #2ecc71;
  }

  .kpi-card.green .kpi-icon {
    background: #2ecc71;
  }

  .kpi-card.orange {
    border-color: #f39c12;
  }

  .kpi-card.orange .kpi-icon {
    background: #f39c12;
  }

  .kpi-card.red {
    border-color: #e74c3c;
  }

  .kpi-card.red .kpi-icon {
    background: #e74c3c;
  }


  /* ===========================
      INBOUND OUTBOUND
=========================== */

  .summary-wrapper {
    display: grid;
    grid-template-columns: 1fr 1fr;
    gap: 25px;
  }

  .summary-card {
    background: #fff;
    border-radius: 15px;
    overflow: hidden;
    box-shadow: 0 12px 30px rgba(0, 0, 0, .08);
  }

  .card-header {
    padding: 18px;
    font-size: 20px;
    font-weight: 600;
    color: #fff;
  }

  .card-header.inbound {
    background: #27ae60;
  }

  .card-header.outbound {
    background: #2980b9;
  }

  .card-body {
    padding: 22px;
  }

  .summary-row {
    display: flex;
    justify-content: space-between;
    align-items: center;
    padding: 10px 0;
    font-size: 15px;
  }

  .summary-row span {
    color: #666;
  }

  .summary-row strong {
    font-size: 17px;
    color: #2d3436;
  }

  .summary-card hr {
    margin: 18px 0;
    border: none;
    border-top: 1px solid #ececec;
  }


  /* =======================
      VALUE COLORS
======================= */

  .green {
    color: #2ecc71 !important;
  }

  .red {
    color: #e74c3c !important;
  }

  .orange {
    color: #f39c12 !important;
  }

  .blue {
    color: #2196F3 !important;
  }


  /* =======================
      DETAILS BUTTON
======================= */

  .detail-btn-wrapper {
    margin-top: 35px;
  }

  .details-btn {
    background: #1976d2;
    color: #fff;
    border: none;
    padding: 13px 35px;
    border-radius: 8px;
    cursor: pointer;
    font-size: 15px;
    font-weight: 600;
    transition: .3s;
  }

  .details-btn:hover {
    background: #125ca1;
  }


  /* ===========================
      RESPONSIVE
=========================== */

  @media(max-width:1200px) {
    .kpi-container {
      grid-template-columns: repeat(2, 1fr);
    }

  }

  @media(max-width:768px) {
    .summary-wrapper {
      grid-template-columns: 1fr;
    }

    .kpi-container {
      grid-template-columns: 1fr;
    }

    .dashboard-header h2 {
      font-size: 24px;
    }

  }

  .dashboard-title {
    text-align: center;
    margin-bottom: 30px;
  }

  .dashboard-title h1 {
    font-size: 42px;
    font-weight: 700;
    color: #1d3557;
    margin: 0;
  }



  /* ==========================================
            BILLING FILTER CARD
========================================== */
  .filter-card {
    width: 91%;
    max-width: 95%;
    margin: 0 auto 40px;
    background: #fff;
    border-radius: 18px;
    padding: 35px 40px;
    box-shadow: 0 10px 30px rgba(0, 0, 0, .08);
  }

  /* ==========================================
            FILTER ROW
========================================== */

  .filter-row {
    display: flex;
    gap: 40px;
  }

  .filter-group {
    flex: 1;
  }

  .filter-group label {
    display: block;
    margin-bottom: 10px;
    font-size: 15px;
    font-weight: 600;
    color: #444;
  }

  /* ==========================================
            INPUTS & SELECT
========================================== */

  .filter-group select,
  .filter-group input {
    width: 80%;
    height: 47px;
    border: 1px solid #d9dee7;
    border-radius: 10px;
    background: #fff;
    padding: 0 18px;
    font-size: 16px;
    color: #333;
    box-sizing: border-box;
    transition: all .25s ease;
  }

  .filter-group select {
    appearance: none;
    -webkit-appearance: none;
    -moz-appearance: none;

    background:
      url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='14' height='14' fill='%23666' viewBox='0 0 16 16'%3E%3Cpath d='M1.5 5l6.5 6 6.5-6'/%3E%3C/svg%3E") no-repeat right 18px center;
    background-color: #fff;
    cursor: pointer;
  }

  .filter-group input:focus,
  .filter-group select:focus {

    outline: none;
    border-color: #1976d2;
    box-shadow: 0 0 0 4px rgba(25, 118, 210, .15);

  }

  /* ==========================================
            DATE PICKER
========================================== */

  .datepicker {
    cursor: pointer;
  }

  .daterangepicker {
    border-radius: 12px !important;
    box-shadow: 0 15px 35px rgba(0, 0, 0, .15) !important;
    border: none !important;
  }

  /* ==========================================
            BUTTON
========================================== */

  .filter-button {
    margin-top: 35px;
    text-align: center;
  }

  .submit-dashboard-btn {
    border: none;
    background: linear-gradient(90deg, #1f7ae0, #1355b8);
    color: #fff;
    padding: 14px 42px;
    border-radius: 30px;
    font-size: 16px;
    font-weight: 600;
    cursor: pointer;
    transition: .25s;
    box-shadow: 0 8px 20px rgba(25, 118, 210, .30);
    width: 300px;
  }

  .submit-dashboard-btn:hover {
    transform: translateY(-2px);
    box-shadow: 0 12px 30px rgba(25, 118, 210, .40);
  }

  /* ==========================================
            RESPONSIVE
========================================== */

  @media(max-width:768px) {

    .filter-card {
      padding: 25px
    }

    .filter-row {
      flex-direction: column;
      gap: 20px;
    }

  }
</style>

<div class="container">
  <div class="dashboard-title">
    <h1>Billing Dashboard</h1>
  </div>

  <div id="billingreport" class="filter-card">

    <div class="filter-row">

      <div class="filter-group">
        <label>Select Report</label>

        <select id="report_type" class="dashboard-input">
          <option value="1">CDR Billing</option>
        </select>
      </div>

      <div class="filter-group">
        <label>Select Date</label>

        <input
          type="text"
          class="datepicker"
          id="date_range"
          name="datetimes"
          placeholder="YYYY-MM-DD - YYYY-MM-DD" />
      </div>

      <div class="filter-button">
        <button id="submitBtn" class="submit-dashboard-btn">
          Search Report
        </button>
      </div>
    </div>


  </div>
  <!-- <div>
    <h2 style="margin-bottom: 2%;">Billing Dashboard</h2>
  </div>


  <div id="billingreport" class="content-section mc-col">
    <div class="billing-div">

      <div class="content_parent">
        <label class="form-group-label"><b>Select Report:</b></label>
        <div class="report-div">
          <select class="report-detail fselect-report" id="report_type">
            <option value="1">CDR Billing</option>
          </select>
        </div>
      </div>

      <div class="content_parent">
        <label class="form-group-label"><b>Select Date:</b></label>
        <div class="date-div">
          <input
            type="text"
            class="datepicker"
            id="date_range"
            name="datetimes"
            placeholder="YYYY-MM-DD - YYYY-MM-DD" />
        </div>
      </div>
    </div>
    <button type="button" class="submit-btn button" id="submitBtn">SUBMIT</button>
  </div> -->
  <!-- <div class="mc-row"></div> -->

  <!-- file detail section -->
  <!-- <div id="cdrSection" class="mc-row" style="display:none; margin-top:30px;">
    <h2 style="margin-bottom: 3%;">CDR Summary</h2>

    <div class="card-div">
      <div class="inbound-card mc-col">
        <div class="card-detail-div" style="padding:15px;">
          <h4>Inbound</h4>
          <div class="text-div">
            <p><strong>Files Received:</strong> <span id="inboundFiles"></span></p>
            <p><strong>Total Rows:</strong> <span id="inboundRows"></span></p>
            <p><strong>Blank Call Type:</strong> <span id="inboundBlankCallType"></span></p>

            <hr>

            <p><strong>SIP 200:</strong> <span id="inbound200Count"></span></p>
            <p><strong>Other SIP:</strong> <span id="inboundOtherCount"></span></p>

            <hr>

            <p><strong>SRC GW Group Present:</strong> <span id="inboundSrcGwPresent"></span></p>
            <p><strong>SRC GW Group Blank:</strong> <span id="inboundSrcGwBlank"></span></p>

            <hr>

            <p><strong>DST GW Group Present:</strong> <span id="inboundDstGwPresent"></span></p>
            <p><strong>DST GW Group Blank:</strong> <span id="inboundDstGwBlank"></span></p>
          </div>
        </div>
      </div>

      <div class="outbound-card mc-col">
        <div class="card-detail-div" style="padding:15px;">
          <h4>Outbound</h4>
          <div class="text-div">
            <p><strong>Files Received:</strong> <span id="outboundFiles"></span></p>
            <p><strong>Total Rows:</strong> <span id="outboundRows"></span></p>
            <p><strong>Blank Call Type:</strong> <span id="outboundBlankCallType"></span></p>

            <hr>

            <p><strong>SIP 200:</strong> <span id="outbound200Count"></span></p>
            <p><strong>Other SIP:</strong> <span id="outboundOtherCount"></span></p>

            <hr>

            <p><strong>SRC GW Group Present:</strong> <span id="outboundSrcGwPresent"></span></p>
            <p><strong>SRC GW Group Blank:</strong> <span id="outboundSrcGwBlank"></span></p>

            <hr>

            <p><strong>DST GW Group Present:</strong> <span id="outboundDstGwPresent"></span></p>
            <p><strong>DST GW Group Blank:</strong> <span id="outboundDstGwBlank"></span></p>
          </div>
        </div>
      </div>
    </div>
    <button type="button" class="details-btn button" id="cdrDetailBtn">DETAILS</button>
  </div> -->
  <div id="cdrSection" class="cdr-dashboard" style="display:none;">

    <div class="dashboard-header">
      <h2>📊 CDR Summary</h2>
    </div>

    <!-- ================= KPI CARDS ================= -->

    <div class="kpi-container">

      <div class="kpi-card blue">
        <div class="kpi-icon">📂</div>
        <div class="kpi-content">
          <span class="kpi-title">Files Received</span>
          <h3 id="totalFiles">0</h3>
          <small>Total Files</small>
        </div>
      </div>

      <div class="kpi-card green">
        <div class="kpi-icon">📋</div>
        <div class="kpi-content">
          <span class="kpi-title">Total Rows</span>
          <h3 id="totalRows">0</h3>
          <small>All Records</small>
        </div>
      </div>

      <div class="kpi-card orange">
        <div class="kpi-icon">✅</div>
        <div class="kpi-content">
          <span class="kpi-title">SIP 200</span>
          <h3 id="totalSip200">0</h3>
          <small>Successful</small>
        </div>
      </div>

      <div class="kpi-card red">
        <div class="kpi-icon">⚠️</div>
        <div class="kpi-content">
          <span class="kpi-title">Other SIP</span>
          <h3 id="totalOtherSip">0</h3>
          <small>Failed Calls</small>
        </div>
      </div>

    </div>
    <!-- ================= MAIN CARDS ================= -->
    <div class="summary-wrapper">
      <!-- ================= INBOUND ================= -->
      <div class="summary-card">
        <div class="card-header inbound">
          ⬇ Inbound
        </div>
        <div class="card-body">

          <div class="summary-row">
            <span>Files Received</span>
            <strong id="inboundFiles"></strong>
          </div>

          <div class="summary-row">
            <span>Total Rows</span>
            <strong id="inboundRows"></strong>
          </div>

          <div class="summary-row">
            <span>Blank Call Type</span>
            <strong class="green" id="inboundBlankCallType"></strong>
          </div>

          <hr>

          <div class="summary-row">
            <span>SIP 200</span>
            <strong class="blue" id="inbound200Count"></strong>
          </div>

          <div class="summary-row">
            <span>Other SIP</span>
            <strong class="orange" id="inboundOtherCount"></strong>
          </div>

          <hr>

          <div class="summary-row">
            <span>Account Code Present</span>
            <strong id="inboundAccountCodePresent"></strong>
          </div>

          <div class="summary-row">
            <span>Account Code Blank</span>
            <strong class="green" id="inboundAccountCodeBlank"></strong>
          </div>

          <hr>

          <div class="summary-row">
            <span>SRC GW Present</span>
            <strong id="inboundSrcGwPresent"></strong>
          </div>

          <div class="summary-row">
            <span>SRC GW Blank</span>
            <strong class="green" id="inboundSrcGwBlank"></strong>
          </div>

          <hr>

          <div class="summary-row">
            <span>DST GW Present</span>
            <strong id="inboundDstGwPresent"></strong>
          </div>

          <div class="summary-row">
            <span>DST GW Blank</span>
            <strong class="green" id="inboundDstGwBlank"></strong>
          </div>

        </div>

      </div>


      <!-- ================= OUTBOUND ================= -->

      <div class="summary-card">

        <div class="card-header outbound">
          ⬆ Outbound
        </div>

        <div class="card-body">

          <div class="summary-row">
            <span>Files Received</span>
            <strong id="outboundFiles"></strong>
          </div>

          <div class="summary-row">
            <span>Total Rows</span>
            <strong id="outboundRows"></strong>
          </div>

          <div class="summary-row">
            <span>Blank Call Type</span>
            <strong class="red" id="outboundBlankCallType"></strong>
          </div>

          <hr>

          <div class="summary-row">
            <span>SIP 200</span>
            <strong class="blue" id="outbound200Count"></strong>
          </div>

          <div class="summary-row">
            <span>Other SIP</span>
            <strong class="orange" id="outboundOtherCount"></strong>
          </div>
          <hr>
          <div class="summary-row">
            <span>Account Code Present</span>
            <strong id="outboundAccountCodePresent"></strong>
          </div>
          <div class="summary-row">
            <span>Account Code Blank</span>
            <strong class="green" id="outboundAccountCodeBlank"></strong>
          </div>
          <hr>
          <div class="summary-row">
            <span>SRC GW Present</span>
            <strong id="outboundSrcGwPresent"></strong>
          </div>
          <div class="summary-row">
            <span>SRC GW Blank</span>
            <strong class="green" id="outboundSrcGwBlank"></strong>
          </div>
          <hr>
          <div class="summary-row">
            <span>DST GW Present</span>
            <strong id="outboundDstGwPresent"></strong>
          </div>
          <div class="summary-row">
            <span>DST GW Blank</span>
            <strong class="green" id="outboundDstGwBlank"></strong>
          </div>
        </div>
      </div>
    </div>
    <div class="detail-btn-wrapper">
      <button class="details-btn" id="cdrDetailBtn">
        DETAILS →
      </button>
    </div>

  </div>

  <!-- history table section -->
  <div class="common-modal" id="historyModal" style="display: none;">
    <i class="fa fa-times history-modal-close" aria-hidden="true"></i>
    <div id="historySection">
      <h2 style="margin-bottom: 3%;">CDR Billing Details</h2>

      <div id="historyTable_filter" class="dataTables_filter icon-addon" style="position: relative;">
        <button type="button" class="download-btn button" id="downloadBillingReport">DOWNLOAD</button>
        <label class="contact-no-detail-label">
          <form autocomplete="off">
            <span class="search-input">
              <input type="search" class="historyTable_search"
                id="historyTable_search" placeholder="Search"
                aria-controls="historyTable" autocomplete="off" />
              <i for="search-number" class="lyphicon search-icon glyphicon-search fa fa-search"></i>
              <i class="fas spin-icon fa-spinner fa-pulse"></i>
            </span>
          </form>
        </label>
      </div>
      <div class="container daily-calling-status-table-container" style="position: relative">
        <div id="historyTable_processing" class="dataTables_processing" style="display: none;">
          Loading...</div>
        <table id="historyTable" class="stripe">
          <thead>
            <tr>
              <th>File Type</th>
              <th>SIP Code</th>
              <th>SIP Reason</th>
              <th>Total Count</th>
              <th>Date</th>
            </tr>
          </thead>
        </table>
        <div class="jump-to-page-wrapper" style="display:none;">
          <label>Jump to page: </label>
          <input type="number" onkeyup="if(/\D/g.test(this.value)) this.value = this.value.replace(/\D/g,'')"
            name="jump_to_page" id="jump_to_page_num">
          <a href="javascript:void(0);" id="go_to_page">GO</a>
        </div>
      </div>
    </div>
  </div>

  <div id="loaderModal" class="modal">
    <img class="loader-img" src="../images/ajax-spinner.gif">
    <span class="loader-text">Please wait ...</span>
  </div>
</div>

<script src="https://cdn.jsdelivr.net/npm/moment@2.29.4/moment.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>
<script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.11.1/js/jquery.dataTables.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.11.1/css/jquery.dataTables.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css" />
<link rel="stylesheet" href="{{ asset('css/fselect.css') }}">
<script src="{{ asset('js/fselect.js') }}"></script>

<script>
  var baseURL = "{{ URL::to('/') }}" + "/";
  var DownloadCdrBillingUrl = baseURL + 'downloadCdrBilling';
  var getPartnersUrl = baseURL + 'getPartners';
  var getCdrDataUrl = baseURL + 'getCdrData';
  $(document).ready(function() {
    // getPartners();

    $('.fselect-client').fSelect({
      placeholder: 'Select Partner',
      showSearch: true
    });

    $('.fselect-report').fSelect({
      placeholder: 'Select Report',
      showSearch: true
    });

    var d = new Date();
    $('input[name="datetimes"]').daterangepicker({
      startDate: moment().startOf('month'),
      endDate: moment().startOf('hour'),
      locale: {
        format: 'YYYY-MM-DD'
      },
      maxDate: d,
    });

    $(document).on('click', '#submitBtn', function(e) {
      e.preventDefault();
      jQuery("#loaderModal").show();
      // const clientId = $('#client_id').val();
      const reportType = $('#report_type').val();
      const dateRange = $('#date_range').val();

      if (!reportType || !dateRange) {
        alert('Please select Client, Report Type, and Date Range');
        jQuery("#loaderModal").hide();
        return;
      }

      const dates = dateRange.split(' - ');

      getCdrData(dateRange);

    });

    $('#cdrDetailBtn').on('click', function() {
      $('#historyModal').show();
      if ($.fn.DataTable.isDataTable('#historyTable')) {
        $('#historyTable').DataTable().ajax.reload();
      } else {
        getCdrBillingHistory();
      }
    });

    $('.history-modal-close').click(function() {
      $('#historyModal').css("display", "none");
    });

    $('#downloadBillingReport').on('click', function() {
      const dateRange = $('#date_range').val();
      jQuery("#loaderModal").show();
      downloadCdrBilling(dateRange);
    });

    //search functionality for history table
    var historyTimer;
    jQuery("#historyTable_filter input[type='search']").on('search', function(evt) {
      var currSearchText = jQuery(this).val();
      if (currSearchText == "" || currSearchText == null) {
        var historyTableObj = jQuery('#historyTable').DataTable();
        historyTableObj.ajax.reload();
      }
    });

    jQuery("#historyTable_filter input[type='search']").on("keyup keypress", function(e) {
      if (historyTimer) {
        clearTimeout(historyTimer);
      }
      var keyCode = e.keyCode || e.which;
      if (keyCode === 13) {
        e.preventDefault();
        var historyTableObj = jQuery('#historyTable').DataTable();
        historyTableObj.ajax.reload();
        jQuery(".dataTables_filter .glyphicon-search.fa.fa-search").css('display', 'none');
        jQuery(".dataTables_filter .fa-spinner").css('display', 'inline-block');
        return false;
      }
      var currSearchText = jQuery(this).val();
      var currSearchEle = jQuery(this);
      if (currSearchText != "") {
        historyTimer = setTimeout(function() {
          jQuery(".dataTables_filter .glyphicon-search.fa.fa-search").css('display',
            'none');
          jQuery(".dataTables_filter .fa-spinner").css('display', 'inline-block');
          currSearchEle.prop("disabled", true);
          // currSearchEle.prop("disabled", true);
          var historyTableObj = jQuery('#historyTable')
            .DataTable();
          historyTableObj.ajax.reload();
        }, 1000);
      }
      if (keyCode === 8) {
        if (currSearchText == "" || currSearchText == null) {
          var historyTableObj = jQuery('#historyTable').DataTable();
          historyTableObj.ajax.reload();
        }
      }
    });
  });

  function getPartners() {
    jQuery("#loaderModal").show();
    jQuery.ajax({
      url: getPartnersUrl,
      type: 'GET',
      success: function(response) {
        if (response.status == 'success') {
          jQuery("#loaderModal").hide();
          let options = '';
          response.data.forEach((partner) => {
            options += `
              <option value="${partner.user_referance_id}">
                ${partner.account_name}
              </option>
            `;
          });
          $('#client_id').html('');
          $('#client_id').append(options);
          $('#client_id').fSelect('reload');
        }
      },
      error: function(error) {
        console.error('Failed to fetch partners', error);
      }
    });
  }

  function getCdrData(dateRange) {
    jQuery("#loaderModal").show();
    jQuery.ajax({
      url: getCdrDataUrl,
      data: {
        date: dateRange
      },
      type: 'GET',
      success: function(response) {
        if (response.status == 'success') {
          jQuery("#loaderModal").hide();
          //total
          $('#totalFiles').text(Number(response.inbound_file_count) + Number(response.outbound_file_count));
          $('#totalRows').text(Number(response.inbound_total_rows) + Number(response.outbound_total_rows));
          $('#totalSip200').text(Number(response.inbound_200_count) + Number(response.outbound_200_count));
          $('#totalOtherSip').text(Number(response.inbound_other_count) + Number(response.outbound_other_count));

          //inbound
          $('#inboundFiles').text(response.inbound_file_count || 0);
          $('#inboundRows').text(response.inbound_total_rows || 0);
          $('#inboundBlankCallType').text(response.inbound_blank_call_type || 0);

          $('#inbound200Count').text(response.inbound_200_count || 0);
          $('#inboundOtherCount').text(response.inbound_other_count || 0);

          $('#inboundAccountCodePresent').text(response.inbound_account_code_present || 0);
          $('#inboundAccountCodeBlank').text(response.inbound_account_code_blank || 0);

          $('#inboundSrcGwPresent').text(response.inbound_src_gwgroup_present || 0);
          $('#inboundSrcGwBlank').text(response.inbound_src_gwgroup_blank || 0);

          $('#inboundDstGwPresent').text(response.inbound_dst_gwgroup_present || 0);
          $('#inboundDstGwBlank').text(response.inbound_dst_gwgroup_blank || 0);


          // Outbound
          $('#outboundFiles').text(response.outbound_file_count || 0);
          $('#outboundRows').text(response.outbound_total_rows || 0);
          $('#outboundBlankCallType').text(response.outbound_blank_call_type || 0);

          $('#outbound200Count').text(response.outbound_200_count || 0);
          $('#outboundOtherCount').text(response.outbound_other_count || 0);

          $('#outboundAccountCodePresent').text(response.outbound_account_code_present || 0);
          $('#outboundAccountCodeBlank').text(response.outbound_account_code_blank || 0);

          $('#outboundSrcGwPresent').text(response.outbound_src_gwgroup_present || 0);
          $('#outboundSrcGwBlank').text(response.outbound_src_gwgroup_blank || 0);

          $('#outboundDstGwPresent').text(response.outbound_dst_gwgroup_present || 0);
          $('#outboundDstGwBlank').text(response.outbound_dst_gwgroup_blank || 0);

          $('#cdrSection').show();
        }
      },
      error: function(error) {
        console.error('Failed to fetch Cdr data', error);
      }
    });
  }

  function downloadCdrBilling(dateRange) {
    var xhr = jQuery.ajax({
      type: 'GET',
      url: DownloadCdrBillingUrl,
      data: {
        dateRange: dateRange
      },
      success: function(res) {
        jQuery("#loaderModal").hide();
        var blob = new Blob([res], {
          type: 'text/csv'
        });
        var filename = "";
        if (xhr.getAllResponseHeaders().indexOf("Content-Disposition") >= 0) {
          console.log("header:", xhr.getResponseHeader('Content-Disposition'));
        }
        var disposition = xhr.getResponseHeader('Content-Disposition');
        if (disposition && disposition.indexOf('attachment') !== -1) {
          var filenameRegex = /filename[^;=\n]*=((['"]).*?\2|[^;\n]*)/;
          var matches = filenameRegex.exec(disposition);
          if (matches != null && matches[1]) {
            filename = matches[1].replace(/['"]/g, '');
          }
        }
        var link = document.createElement('a');
        link.href = window.URL.createObjectURL(blob);
        link.download = filename;
        document.body.appendChild(link);
        link.click();
        document.body.removeChild(link);
      },
      error: function(xhr, status, error) {
        $("#loaderModal").hide();
        console.error('Download failed:', error);
        alert('Failed to download CDR Billing Report. Please try again.');
      },
    });
  }

  function getCdrBillingHistory() {
    var datatable = jQuery('#historyTable').DataTable({
      "buttons": ['colvis'],
      "serverSide": true,
      "scrollX": true,
      "sScrollXInner": "100%",
      "scrollCollapse": true,
      "processing": false,
      "searching": false,
      "order": [
        [0, 'asc']
      ],
      "pageLength": 20,
      "oLanguage": {
        "sEmptyTable": '<div id="list-number-note"><span><a href="/add-number/"><em></em></a> No Result Found</span></div>',
        'sSearch': '',
        'sSearchPlaceholder': "Search"
      },
      "aoColumnDefs": [{
        "bSortable": false,
        "aTargets": [0]
      }, {
        "bSearchable": false,
        "aTargets": [0]
      }],
      "responsive": {
        "breakpoints": [{
          name: 'desktop',
          width: Infinity
        }, {
          name: 'tablet',
          width: 1024
        }, {
          name: 'fablet',
          width: 768
        }, {
          name: 'phone',
          width: 480
        }]
      },
      'ajax': function(data, callback, settings) {
        jQuery("#historyTable_processing").show();
        var historyTableObj = jQuery('#historyTable').DataTable();
        var params = historyTableObj ? historyTableObj.ajax.params() : '';
        var column_name = '';
        var sort_order = '';
        if (params.order[0].column == 1) {
          column_name = 'file_type';
          sort_order = params.order[0].dir;
        } else if (params.order[0].column == 2) {
          column_name = 'sip_code';
          sort_order = params.order[0].dir;
        } else if (params.order[0].column == 3) {
          column_name = 'sip_reason';
          sort_order = params.order[0].dir;
        } else if (params.order[0].column == 4) {
          column_name = 'total_count';
          sort_order = params.order[0].dir;
        } else if (params.order[0].column == 5) {
          column_name = 'created_date';
          sort_order = params.order[0].dir;
        }

        const dateRange = $('#date_range').val();

        var postData = {
          dateRange: dateRange,
          pageSize: 20,
          pageNumber: (historyTableObj.page.info().page + 1),
          searchKeyword: (jQuery('#historyTable_filter input').val()) || '',
          userFilter: (jQuery('#historyTable_filter select').val()) || '',
          sortField: column_name,
          sortDirection: sort_order
        };

        jQuery.ajax({
          url: baseURL + "getCdrBillingHistory",
          type: 'GET',
          data: postData,
          success: function(response) {
            jQuery(".dataTables_filter .glyphicon-search.fa.fa-search").css(
              'display', 'inline-block');
            jQuery(".dataTables_filter .fa-spinner").css('display', 'none');
            jQuery("#historyTable_filter input[type='search']").prop(
              "disabled", false);
            jQuery("#historyTable_processing").hide();
            $("#loaderModal").hide();

            var tempDataTableArr = [];
            var totalRecords = response.data;

            if (totalRecords && totalRecords.length > 0) {
              for (var i = 0; i < totalRecords.length; i++) {
                tempDataTableArr.push({
                  fileType: totalRecords[i].file_type || '-',
                  sipCode: totalRecords[i].sip_code || '-',
                  sipReason: totalRecords[i].sip_reason || '-',
                  totalCount: totalRecords[i].total_count || '-',
                  createdDate: totalRecords[i].created_date || '-'
                });
              }

              callback({
                data: tempDataTableArr,
                recordsTotal: response.recordsTotal,
                recordsFiltered: response.recordsFiltered
              });
            } else {
              jQuery("#historyTable tbody").html(
                "<tr><td></td><td></td><td></td><td>No Records Found.</td><td></td><td></td><td></td><td></td></tr>"
              );
              // jQuery('.dataTables_paginate').hide();
              jQuery('#historyTable_info').hide();
              jQuery("#historyTable_processing").hide();
            }
            jQuery("#historyTable_processing").hide();
          },
          error: function(jqXhr, textStatus, errorThrown) {
            // alert('Error fetching data: ' + (errorThrown || textStatus));
          }
        });
      },
      'columns': [{
          data: 'fileType'
        },
        {
          data: 'sipCode'
        },
        {
          data: 'sipReason'
        },
        {
          data: 'totalCount'
        },
        {
          data: 'createdDate'
        }
      ]
    });
  }
</script>

@endsection