100 lines
6.6 KiB
PHP
Executable File
100 lines
6.6 KiB
PHP
Executable File
<?php
|
|
require_once('fixed/config/go_con.php');
|
|
|
|
?>
|
|
<!DOCTYPE html>
|
|
<html lang="en" dir="rtl">
|
|
<?php require_once('fixed/head/go.php'); ?>
|
|
<body class="rtl">
|
|
<link rel="stylesheet" href="//cdn.jsdelivr.net/npm/@mdi/font@6.5.95/css/materialdesignicons.min.css">
|
|
<?php require_once('fixed/loader/go.php'); ?>
|
|
<!-- page-wrapper Start-->
|
|
<div class="page-wrapper" id="pageWrapper">
|
|
<?php require_once('fixed/header/go.php'); ?>
|
|
<!-- Page Body Start-->
|
|
<div class="page-body-wrapper">
|
|
<?php require_once('fixed/sidebar/go.php'); ?>
|
|
<div class="page-body">
|
|
<!-- Container-fluid starts-->
|
|
<div class="container-fluid">
|
|
<div class="row">
|
|
<div class="col-12">
|
|
<div class="card">
|
|
<div class="tab-pane p-3 active" id="tab<?=$tabs?>" role="tabpanel">
|
|
<div class="card-body new-user order-list">
|
|
<div class="table-responsive">
|
|
<table class="table table-bordered text-center">
|
|
<thead class="table-primary">
|
|
<tr>
|
|
<th scope="col">#</th>
|
|
<th scope="col">#</th>
|
|
<th scope="col">تصنيف الخدمة</th>
|
|
<th scope="col">اسم الخدمة</th>
|
|
<th scope="col">السعر الاساسي</th>
|
|
<th scope="col">السعر شامل الضريبة</th>
|
|
<th scope="col">اقل مدة</th>
|
|
<th scope="col">اعلى مدة</th>
|
|
<th scope="col">الحالة</th>
|
|
<th scope="col">اعدادات</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
$get_services_sql = mysqli_query($db,
|
|
"SELECT
|
|
`services`.`id`,
|
|
`services`.`name`,
|
|
`services`.`price`,
|
|
`services`.`minimum`,
|
|
`services`.`maxmum`,
|
|
`type_of_services`.`name` AS `type_name`,
|
|
`activation`.`id` AS `ac_id`,
|
|
`activation`.`name` AS `status`
|
|
|
|
FROM `services`
|
|
LEFT JOIN `type_of_services` ON `services`.`type_of_services_id` = `type_of_services`.`id`
|
|
LEFT JOIN `activation` ON `services`.`activation_id` = `activation`.`id`
|
|
|
|
WHERE `commercial_register_id` = $commercial_register_id
|
|
ORDER BY `type_name` DESC
|
|
|
|
");
|
|
$count = 1;
|
|
while ($get_services = mysqli_fetch_assoc($get_services_sql)) {
|
|
?>
|
|
<tr <?php if($get_services['ac_id'] == 1){echo"style='background: red;'";}?>>
|
|
<th scope="row"><?=$count?></th>
|
|
<th scope="row"><?=$get_services['id']?></th>
|
|
<td><?=$get_services['type_name']?></td>
|
|
<td><?=$get_services['name']?></td>
|
|
<td><?=$get_services['price']?></td>
|
|
<td><?=round($get_services['price'] + (($get_services['price']*$vat)/100),2)?></td>
|
|
<td><?=$get_services['minimum']?></td>
|
|
<td><?=$get_services['maxmum']?></td>
|
|
<td><?=$get_services['status']?></td>
|
|
<td></td>
|
|
</tr>
|
|
<?php
|
|
$count++;
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<!--end card-body-->
|
|
</div>
|
|
<!--end card-->
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<!-- Container-fluid Ends-->
|
|
</div>
|
|
|
|
<?php require_once('fixed/footer/go.php'); ?>
|
|
</div>
|
|
</div>
|
|
<?php require_once('fixed/js/go.php'); ?>
|
|
</body>
|
|
</html>
|