booking/work/order/ajax/get_invoice_ajax.php

<?php
  require_once('../../../fixed/config/go_con.php');
  
  $number = mysqli_real_escape_string($db, $_POST['invNumber']);

  if (!empty($number)) {
  
    $result = mysqli_query($db, "SELECT
      `invoices`.`id` AS `inv_id`,
      `invoices`.`user_id`,
      `tretment`.`id`,
      `tretment`.`name`,
      `tretment`.`number`,
      `dd`.`status_id`

      FROM `invoices`
      INNER JOIN `invoices_has_book` ON `invoices_has_book`.`invoices_id` = `invoices`.`id`
      INNER JOIN `book` ON `book`.`id` = `invoices_has_book`.`book_id`
      INNER JOIN `tretment` ON `book`.`tretment_id` = `tretment`.`id`
      RIGHT JOIN `book_details` AS `dd` ON `dd`.`book_id` = `book`.`id`
      INNER JOIN `services` ON `services`.`id` = `dd`.`services_id`

      WHERE `invoices`.`number_style` = '$number'
      AND `dd`.`id` IN (SELECT MAX(`book_details`.`id`) FROM `book_details` WHERE `book_id` = `dd`.`book_id`)
      AND `dd`.`status_id` IN (21)
    ");
    
    if (mysqli_num_rows($result) > 0) {
      $row = mysqli_fetch_assoc($result);

      if ($row['user_id'] == $admin_id || in_array(50, $rolls) || in_array(78, $rolls)) {
?>
<input name="tretment_id" style="display: none;" value="<?= $row['id'] ?>">
<input name="inv_id" style="display: none;" value="<?= $row['inv_id'] ?>">
<h6 class="mt-0 header-title">معلومات العميل</h6>
<div class="form-group row">
  <div class="col-12 col-sm-12 col-md-12 col-lg-12 col-xl-12">
    <div class="table-responsive">
      <table class="table table-bordered middle text-align-center">
        <tbody>
          <tr>
            <th scope="col" class="bg-primary">اسم العميل</th>
            <th scope="col" class="bg-primary">رقم العميل</th>
          </tr>
          <tr>
            <td><?= $row['name'] ?></td>
            <td><?= $row['number'] ?></td>
          </tr>
        </tbody>
      </table>
    </div>
  </div>
</div>
      
<hr>
<h6 class="mt-0 header-title">يرجى تحديد الخدمات الملغاة</h6>
<div class="form-group row">
  <div class="col-12 col-sm-12 col-md-12 col-lg-12 col-xl-12">
    <div class="table-responsive">
      <table class="table table-bordered middle text-align-center">
        <tbody>
          <tr>
            <th scope="col" class="bg-primary">#</th>
            <th scope="col" class="bg-primary">الخدمات الملغاة</th>
            <th scope="col" class="bg-primary">التاريخ</th>
            <th scope="col" class="bg-primary">الوقت</th>
            <th scope="col" class="bg-primary">الفني</th>
          </tr>
<?php
        $result = mysqli_query($db, "SELECT
          `services`.`id`,
          `services`.`price`,
          `services`.`name`,
          `dd`.`day_date`,
          `dd`.`day_time`,
          `dd`.`book_id`,
          `emplyee`.`name` AS `emp_name`,
          `invoices`.`id` AS `inv_id`
          
          FROM `invoices`
          INNER JOIN `invoices_has_book` ON `invoices_has_book`.`invoices_id` = `invoices`.`id`
          INNER JOIN `book` ON `book`.`id` = `invoices_has_book`.`book_id`
          RIGHT JOIN `book_details` AS `dd` ON `dd`.`book_id` = `book`.`id`
          INNER JOIN `services` ON `services`.`id` = `dd`.`services_id`
          INNER JOIN `emplyee` ON `emplyee`.`id` = `dd`.`emplyee_id`
        
          WHERE `invoices`.`number_style` = '$number'
          AND `dd`.`id` IN (SELECT MAX(`book_details`.`id`) FROM `book_details` WHERE `book_id` = `dd`.`book_id`)
          AND `dd`.`status_id` IN (21)
        ");
        $count = 1;
        while ($row = mysqli_fetch_assoc($result)) {
          if ($row['id'] == 0) {
            $book_id_for_bundle = $row['book_id'];
            $bundle_s = mysqli_query($db, "SELECT 
              `services`.`price`, 
              `bundle_services_has_services`.`how_many`
              FROM `bundle_services_has_services` 
              INNER JOIN `services` ON `services`.`id` = `bundle_services_has_services`.`services_id`
              WHERE `bundle_services_has_services`.`bundle_services_id` = (SELECT `bundle_services_id` FROM `book_details_has_bundle_services` WHERE `book_details_id` = (SELECT MIN(`id`) FROM `book_details` WHERE `book_id` = $book_id_for_bundle AND `status_id` = 4))
            ");
            if (mysqli_num_rows($bundle_s) > 0) {
              while ($bundle_s_row = mysqli_fetch_assoc($bundle_s)) {
                $row['price'] += $bundle_s_row['price'];
              }
            }
          }

          $desc_sql = mysqli_query($db, "SELECT 
            IFNULL(SUM(`T`.`discount`),0) AS `desc`
              FROM (SELECT 
                  `invoices_discount_details`.`discount`
                  FROM `invoices_discount_details`
                  INNER JOIN `invoices_discount` ON `invoices_discount_details`.`invoices_discount_id` = `invoices_discount`.`id`
                  INNER JOIN `invoices_details` ON `invoices_discount`.`invoices_details_id` = `invoices_details`.`id`
                  WHERE `invoices_discount_details`.`services_id` = ".$row['id']." 
                  AND `invoices_details`.`invoices_id` = ".$row['inv_id']."
                  GROUP BY `reason`,`services_id`) AS `T`
        ");
        if (mysqli_num_rows($desc_sql) > 0) {
          $desc_row = mysqli_fetch_assoc($desc_sql);
        }

?>
          <tr>
            <td>
              <div class="checkbox checkbox-primary get-data-checkbox">
                <input type="checkbox" name="services" data-parsley-multiple="groups" data-parsley-mincheck="2" 
                  id="<?=$row['id'].'_'.$count?>" 
                  data-book_id='<?=$row['book_id']?>'
                  data-price='<?=round($row['price'] - $desc_row['desc'],2)?>'
                  data-price-vat='<?=round(($row['price'] - $desc_row['desc']) + ((($row['price'] - $desc_row['desc'])*$vat)/100),2)?>'
                >
                <label class="mb-0 mt-0" for="<?=$row['id'].'_'.$count?>">تحديد</label>
              </div>
            </td>
            <td><?= $row['name'] ?></td>
            <td><?= $row['day_date'] ?></td>
            <td><?= $row['day_time'] ?></td>
            <td><?= $row['emp_name'] ?></td>
          </tr>
<?php
          $count++;
        }
?>
        </tbody>
      </table>
    </div>
  </div>
</div>
<script>
  $("input[name='services']").change(() => {
    curr_price = 0;
    x = $("input[name='services']");
    p = 0;
    data['books_id'] = [];
    for (let i = 0; i < x.length; i++) {
      if (x[i].checked) {
        p += parseFloat(x[i].getAttribute("data-price-vat"));
        data['books_id'].push(x[i].getAttribute("data-book_id"));
      }
    }
    $("#true_price").html(p);
    curr_price = p
  })
  searchClick = 0;
</script>

<?php

      } else {
        echo "
          <script>
            swalfun('تنبية','لم تقم انت ب اصدار هذه الفاتورة','info');
            searchClick = 0;
          </script>
        ";
      }

    } else { 
      echo "
        <script>
          swalfun('تنبية','لا يوجد اي حجوزات ملغية للفاتورة المحددة','info');
          searchClick = 0;
        </script>
      ";
    }
  }