booking/work/order/ajax/tretments_ajax.php
2025-03-24 22:58:00 +03:00

694 lines
32 KiB
PHP
Executable File

<?php
require_once('../../../fixed/config/go_con.php');
$number = mysqli_real_escape_string($db, $_POST['number']);
if (!empty($number)) {
$get_tretment_sql = mysqli_query($db, "SELECT
`tretment`.`id` AS `tr_id`,
`tretment`.`id_number`,
`tretment`.`name`,
`tretment`.`number`,
`tretment`.`an_employee_offer_id`,
DATE(`tretment`.`date_time`) AS `date_time`,
IFNULL(`tretment_user`.`id`, 0) AS `id`
FROM `tretment`
LEFT JOIN `tretment_user` ON `tretment_user`.`tretment_id` = `tretment`.`id`
WHERE `tretment`.`number` = '$number'
AND `tretment`.`commercial_register_id` = '$commercial_register_id'
AND `tretment`.`activation_id` = 2
");
if (mysqli_num_rows($get_tretment_sql) > 0) {
$tretment_row = mysqli_fetch_assoc($get_tretment_sql);
$tretment_id = $tretment_row['tr_id'];
$tretment_id_number = $tretment_row['id_number'];
$cu_date = $tretment_row['date_time'];
?>
<div class="email-wrap bookmark-wrap">
<div class="row">
<div class="col-xl-3 xl-30">
<div class="email-sidebar"><a class="btn btn-primary email-aside-toggle" href="javascript:void(0)">#</a>
<div class="email-left-aside">
<div class="card">
<div class="card-body">
<div class="email-app-sidebar left-bookmark">
<div class="media">
<div class="media-size-email"><img class="me-3 rounded-circle" src="assets/images/user/user.png" alt=""></div>
<div class="media-body"><a href="user-profile.html">
<h6 class="f-w-700"><?=$tretment_row['name']?></h6></a>
<p>البريد الالكتروني الرسمي</p>
<?php
if (empty($tretment_row['id'])) {
?>
<p style="color:red">تنبيه : المستخدم ليس لديه حساب</p>
<?php
}
?>
</div>
</div>
<ul class="nav main-menu contact-options" role="tablist">
<li class="nav-item" style="height: 50px;"></li>
<li class="nav-item"><span class="main-title"> القوائم</span></li>
<li>
<a id="tap-personal-tab" data-bs-toggle="pill" href="#tap-personal" role="tab" aria-controls="tap-personal" aria-selected="true" class="active">
<span class="title">المعلومات الاساسية</span>
</a>
</li>
<li>
<a class="show" id="tap-offers-tab" data-bs-toggle="pill" href="#tap-offers" role="tab" aria-controls="tap-offers" aria-selected="false">
<span class="title">العروض</span>
</a>
</li>
<li>
<a class="show" id="tab-notes-tab" data-bs-toggle="pill" href="#tab-notes" role="tab" aria-controls="tab-notes" aria-selected="false">
<span class="title">الملاحظات</span>
</a>
</li>
<li>
<a class="show" id="tab-books-tap" data-bs-toggle="pill" href="#tab-books" role="tab" aria-controls="tab-books" aria-selected="false">
<span class="title">الحجوزات</span>
</a>
</li>
<li>
<a class="show" id="tap-massge-tap" data-bs-toggle="pill" href="#tap-massge" role="tab" aria-controls="tap-massge" aria-selected="false">
<span class="title">التفاعل</span>
</a>
</li>
<li>
<a class="show" id="tap-loyalty-tap" data-bs-toggle="pill" href="#tap-loyalty" role="tab" aria-controls="tap-loyalty" aria-selected="false">
<span class="title">الولاء</span>
</a>
</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-xl-9 col-md-12 box-col-8 xl-70">
<div class="email-right-aside bookmark-tabcontent contacts-tabs">
<div class="card email-body radius-left">
<div class="ps-0">
<div class="tab-content">
<div class="tab-pane fade active show" id="tap-personal" role="tabpanel" aria-labelledby="tap-personal-tab">
<div class="card mb-0">
<div class="card-header d-flex">
<h5>المعلومات الاساسية</h5>
</div>
<div class="card-body">
<div class="row">
<div class="col-lg-12">
<form class="form-horizontal form-material mb-0">
<div class="form-group row">
<div class="col-md-4">
<label for="name" class="col-form-label text-right">الاسم</label>
<input id="name" type="text" placeholder="الاسم" class="form-control clickfun" value="<?=$tretment_row['name']?>">
</div>
<div class="col-md-4">
<label for="number12" class="col-form-label text-right">رقم الجوال</label>
<input id="number12" type="number" placeholder="الرقم" class="form-control clickfun" value="<?=$tretment_row['number']?>">
</div>
<div class="col-md-4">
<label for="id_number" class="col-form-label text-right">رقم الهوية</label>
<input id="id_number" type="number" placeholder="الهوية" class="form-control clickfun" value="<?=$tretment_id_number?>">
</div>
</div>
<div class="form-group row">
<div class="col-lg-6 col-sm-6">
<label for="tretment_offer" class="col-form-label text-right">جهه العمل</label>
<select id="tretment_offer" class="form-control">
<?php
$get_an_employee_offer_sql = mysqli_query($db, "SELECT `id`,`name`,`upload_image_id` FROM `an_employee_offer` WHERE `activation_id` = 2");
while ($get_an_employee_offer = mysqli_fetch_assoc($get_an_employee_offer_sql)) {
?>
<option value="<?=$get_an_employee_offer['id']?>" data-upload="<?=$get_an_employee_offer['upload_image_id']?>" <?php if($get_an_employee_offer['id'] == $tretment_row['an_employee_offer_id']){echo'selected';} ?>><?=$get_an_employee_offer['name']?></option>
<?php
}
?>
</select>
</div>
<div class="col-lg-6 col-sm-6">
<label for="tretment_offer" class="col-form-label text-right">تصحيح التاريخ</label>
<input id="Select-date" class="form-control" type="date" value="<?=$cu_date?>" style="text-align: center !important;">
<input id="Select-input" class="form-control" type="text" value="<?=$cu_date?>" style="display:none">
</div>
</div>
<div class="form-group row">
<div id="edit_tretment" class="btn btn-primary btn-sm text-light mt-3 float-right mb-0 text-center col-md-12">تعديل</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<div class="tab-pane fade" id="tap-offers" role="tabpanel" aria-labelledby="tap-offers-tab">
<div class="card mb-0">
<div class="card-header d-flex">
<h5>العروض الخاصة</h5>
</div>
<div class="card-body">
<form action="" method="post" enctype="multipart/form-data">
<div class="form-group row">
<div class="col-lg-12 col-sm-12">
<label for="tretment_has_special_offer" class="col-form-label text-right">العروض</label>
<select id="tretment_has_special_offer" class="form-control">
<option value="0">يرجى الاختيار</option>
<?php
$get_special_offer_sql = mysqli_query($db, "SELECT `id`, `name` FROM `special_offer` WHERE `activation_id` = 2 AND `id` NOT IN (18, 26)");
while ($get_special_offer = mysqli_fetch_assoc($get_special_offer_sql)) {
?>
<option value="<?=$get_special_offer['id']?>"><?=$get_special_offer['name']?></option>
<?php
}
?>
</select>
</div>
</div>
<hr>
<div class="form-group row">
<div class="col-lg-12">
<div id="tretment_has_special_offer_b" style="background-color: #086367; color:white; text-align:center; cursor: pointer;" class="form-control">إضافة</div>
</div>
</div>
</form>
</div>
</div>
<div class="card mb-0">
<div class="card-header d-flex">
<h5>العروض المضافة للعميل</h5>
</div>
<div class="card-body">
<div class="col-lg-12">
<div class="table-responsive">
<table class="table table-bordered text-center">
<thead class="table-primary">
<tr>
<th scope="col">#</th>
<th scope="col">اسم العرض</th>
</tr>
</thead>
<tbody>
<?php
$count = 1;
$get_an_employee_offer_sql = mysqli_query($db, "SELECT `tretment_id`, `special_offer`.`name`
FROM `tretment_has_special_offer`
LEFT JOIN `special_offer` ON `special_offer`.`id` = `tretment_has_special_offer`.`special_offer_id`
WHERE `tretment_has_special_offer`.`tretment_id` = $tretment_id");
while ($get_an_employee_offer = mysqli_fetch_assoc($get_an_employee_offer_sql)) {
?>
<tr>
<th scope="row"><?=$count?></th>
<td><?=$get_an_employee_offer['name']?></td>
</tr>
<?php
$count++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<div class="fade tab-pane" id="tab-notes" role="tabpanel" aria-labelledby="tab-notes-tap">
<div class="card mb-0">
<div class="card-header d-flex">
<h5>ملاحظات خاصه بالمركز</h5>
</div>
<div class="card-body">
<div class="row">
<div class="col-lg-12">
<form class="form-horizontal form-material mb-0">
<div class="form-group row">
<div class="col-md-12">
<label for="note" class="col-form-label text-right">كتابة ملاحظة</label>
<textarea id="note" rows="5" placeholder="ملاحظات خاصه بالمركز" class="form-control"></textarea>
</div>
</div>
<div class="form-group row">
<div id="edit_tment" class="btn btn-primary btn-sm text-light mt-3 float-right mb-0 text-center col-md-12">اضافة</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<div class="fade tab-pane" id="tab-books" role="tabpanel" aria-labelledby="tab-books-tap">
<div class="card mb-0">
<div class="card-header d-flex">
<h5>الحجوزات</h5>
</div>
<div class="card-body">
<div class="row">
<div class="col-lg-12">
<div>
<table class="table table-bordered text-center" style="vertical-align: middle;">
<thead class="table-primary">
<tr class="align-self-center">
<th>#</th>
<th>التاريخ</th>
<th>الوقت</th>
<th>الفني</th>
<th>الخدمة</th>
<th>ملاحظات</th>
<th>الحالة</th>
<th>تفاصيل</th>
</tr>
</thead>
<tbody>
<?php
$get_tretment_sql = mysqli_query($db, "SELECT
`book_details`.`day_date`,
`book_details`.`day_time`,
`book`.`notes`,
`emplyee`.`id` AS `emp_id`,
`emplyee`.`his_img`,
`emplyee`.`name`AS `emp_name`,
`services`.`name`,
`status`.`id` AS `state`,
`status`.`small_name` AS `state_string`
FROM `tretment`
LEFT JOIN `book` ON `book`.`tretment_id` = `tretment`.`id`
LEFT JOIN `book_details` ON `book`.`id` = `book_details`.`book_id`
LEFT JOIN `services` ON `book_details`.`services_id` = `services`.`id`
LEFT JOIN `emplyee` ON `book_details`.`emplyee_id` = `emplyee`.`id`
LEFT JOIN `status` ON `book_details`.`status_id` = `status`.`id`
LEFT JOIN `branch` ON `book_details`.`branch_id` = `branch`.`id`
WHERE `tretment`.`number` = '$number'
AND `branch`.`commercial_register_id`= '$commercial_register_id'
AND `book_details`.`id` IN (SELECT MAX(`book_details`.`id`) FROM `book_details` GROUP BY `book_details`.`book_id`)
ORDER BY `book_details`.`day_date` DESC, `book_details`.`day_time` DESC"
);
$coount = 1;
while ($get_tretment = mysqli_fetch_assoc($get_tretment_sql)) {
?>
<tr>
<td><?=$count?></td>
<td><?=$get_tretment['day_date']?></td>
<td><?=$get_tretment['day_time']?></td>
<td><img src="uploads/emplyee/<?=$get_tretment['emp_id']?>/face/<?=$get_tretment['his_img']?>" alt="emp_img" class="thumb-sm rounded-circle mr-2"><bt /><?=$get_tretment['emp_name']?></td>
<td><?=$get_tretment['name']?></td>
<td><?=$get_tretment['notes']?></td>
<td style="background-image:
<?php
switch ($get_tretment['state']) {
case '4': // انتظار
echo "linear-gradient(120deg, #f6d365 0, #ff7850 100%);";
break;
case '6': // مسدد
echo "linear-gradient(120deg, #f93b7a 0, #e0004a 100%);";
break;
case '8': // مجاني
echo "linear-gradient(120deg, #f93b7a 0, #0095e2 100%);";
break;
case '20': // محجوز وغير مدفوع (ملغي)
echo "linear-gradient(120deg, #a9a2a2 0, #b5a6ab 100%);";
break;
case '21': // محجوز ومدفوع (ملغي)
echo "linear-gradient(120deg, #a9a2a2 0, #b5a6ab 100%);";
break;
default:
echo "none;";
break;
}
?>
"><?=$get_tretment['state_string']?></td>
<td>
<div class="dropdown-basic">
<div class="dropdown">
<div class="btn-group mb-0">
<button class="dropbtn btn-primary" type="button" data-bs-original-title="" title=""><span><i class="icofont icofont-arrow-down"></i></span></button>
<div class="dropdown-content">
<a href="#" data-bs-original-title="" title="">نعديل</a>
<a href="#" data-bs-original-title="" title="">الغاء</a>
<a href="#" data-bs-original-title="" title="">تفاصيل</a>
<a href="#" data-bs-original-title="" title="">ارسال رسالة</a>
</div>
</div>
</div>
</div>
</td>
</tr>
<?php
$coount++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="fade tab-pane" id="tap-massge" role="tabpanel" aria-labelledby="tap-massge-tap">
<div class="card mb-0">
<div class="card-header d-flex">
<h5> رسالة نصية </h5>
</div>
<div class="card-body">
<div class="row">
<div class="col-lg-12">
<form class="form-horizontal form-material mb-0">
<div class="form-group row">
<div class="col-md-12">
<label for="sms_msg" class="col-form-label text-right">كتابة رسالة نصية للعميل</label>
<textarea id="sms_msg" rows="5" placeholder="كتابة رسالة نصية للعميل" class="form-control" ></textarea>
</div>
</div>
<div class="form-group row">
<div id="action_sms_msg" class="btn btn-primary btn-sm text-light mt-3 float-right mb-0 text-center col-md-12">ارسال</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<div class="fade tab-pane" id="tap-loyalty" role="tabpanel" aria-labelledby="tap-loyalty-tap">
<div class="card mb-0">
<div class="card-header d-flex">
<h5> إضافة عميل </h5>
</div>
<div class="card-body">
<form action="" method="post" enctype="multipart/form-data">
<div class="form-group row">
<div class="col-lg-12 col-sm-12">
<h4 class="mt-0 header-title">معلومات البحث</h4>
<div class="form-group row">
<div class="col-8 col-sm-6 col-lg-2 ">
<label for="" class="col-form-label text-right">رقم الجوال</label>
<input id="number_for_add" name="tretment_number" class="form-control clickfun2" type="number" required>
</div>
<div class="col-4 col-sm-6 col-lg-1 ">
<label style="visibility: hidden;" for="" class="col-form-label text-right">..</label>
<div class="form-control" style="background-color: #086367; color:white; text-align:center; cursor: pointer;" id="search">بحث</div>
</div>
</div>
</div>
<div id="get_tretment">
</div>
</div>
<hr>
<div class="form-group row">
<div class="col-lg-12">
<!-- <div id="add_tret_to_tretment" style="background-color: #086367; color:white; text-align:center; cursor: pointer;" class="form-control">إضافة</div> -->
</div>
</div>
</form>
</div>
</div>
<div class="card mb-0">
<div class="card-header d-flex">
<h5>العملاء المضافين</h5>
</div>
<div class="card-body">
<div class="col-lg-12">
<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>
</tr>
</thead>
<tbody>
<?php
$count = 1;
$get_tretment_come_from_sql = mysqli_query($db, "SELECT `tretment`.`name`, `tretment`.`number`
FROM `tretment_come_from`
LEFT JOIN `tretment` ON `tretment`.`id` = `tretment_come_from`.`tretment_id`
WHERE `tretment_come_from`.`come_from_tretment_id` = $tretment_id");
while ($get_tretment_come_from = mysqli_fetch_assoc($get_tretment_come_from_sql)) {
?>
<tr>
<th scope="row"><?=$count?></th>
<td><?=$get_tretment_come_from['name']?></td>
<td><?=$get_tretment_come_from['number']?></td>
</tr>
<?php
$count++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<div class="card mb-0">
<div class="card-header d-flex">
<h5>كشف حساب ولاء</h5>
</div>
<div class="card-body">
<div class="col-lg-12">
<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>
</tr>
</thead>
<tbody>
<?php
$count = 1;
$get_tretment_come_from_sql = mysqli_query($db, "SELECT `walla_points`.`points`, `walla_points`.`date_time`, `walla_reasons`.`reason`
FROM `walla_points`
INNER JOIN `walla_reasons` ON `walla_reasons`.`id` = `walla_points`.`walla_reasons_id`
WHERE `walla_points`.`activation_id` = 2 AND `walla_points`.`tretment_id` = $tretment_id
ORDER BY `walla_points`.`date_time`");
while ($get_tretment_come_from = mysqli_fetch_assoc($get_tretment_come_from_sql)) {
?>
<tr>
<th scope="row"><?=$count?></th>
<td><?=$get_tretment_come_from['points']?></td>
<td><?=$get_tretment_come_from['reason']?></td>
<td><?=$get_tretment_come_from['date_time']?></td>
</tr>
<?php
$count++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<script>
// المعلومات الاساسية
$('.clickfun').keypress(function (e) {
var key = e.which;
if(key == 13) {
get_tretment();
}
});
$(function() {
$("#edit_tretment").click(function() {
edit_tretment();
});
});
edit_click = 0;
function edit_tretment() {
let name = $("#name").val();
if (name == '') {
swalfun('حدث خطأ', 'يرجى ادخال اسم العميل', 'error');
}
let number = $("#number12").val();
if (number.length !== 9) {
swalfun('حدث خطأ', 'رقم الجوال يجب أن يتكون من 9 أرقام وبدون 0 في البداية', 'error');
return false;
}
let id_number = $("#id_number").val();
let tretment_offer = $("#tretment_offer").val();
let id = <?=json_encode($tretment_row['tr_id'])?>;
let cu_date = $("#Select-date").val();
if (cu_date == '') {
cu_date = new Date(Date.parse($("#Select-input").val()));
}
if (edit_click == 0) {
edit_click++
$.post("work/order/ajax/edit_tretments_ajax.php", {
id,
id_number,
name,
number,
cu_date,
tretment_offer
}, function(get_data) {
$("#get_data2").html(get_data);
})
} else {
swalfun("يرجى الانتظار", "تم بالفعل الضعط علية", "warning");
}
}
// المعلومات الاساسية
// الولاء
$(function() {
$("#search").click(function() {
get_tretment();
});
});
$('.clickfun2').keypress(function (e) {
var key = e.which;
if(key == 13) {
get_tretment();
}
});
click = 0;
function get_tretment() {
let tretmentNumber = $("#number_for_add").val();
if (tretmentNumber.length !== 9) {
swalfun('حدث خطأ', 'رقم الجوال يجب أن يتكون من 9 أرقام وبدون 0 في البداية', 'error');
return false;
}
if (click == 0) {
click++
$.post("work/order/ajax/get_tretment_ajax.php", {
tretmentNumber
}, function(get_tretment) {
$("#get_tretment").html(get_tretment);
})
} else {
swalfun("يرجى الانتظار", "تم بالفعل الضعط علية", "warning");
}
}
$(function() {
$("#add_tret_to_tretment").click(function() {
add_tret_to_tretment();
});
});
click2 = 0;
function add_tret_to_tretment() {
let tretment_id = <?=json_encode($tretment_id)?>
let tretment_id_to_add = $("[name='tretment_id']").val();
if (tretment_id_to_add == undefined) {
swalfun('حدث خطأ', 'يرجى تحديد العميل', 'error');
return false;
}
if (tretment_id_to_add == tretment_id) {
swalfun('حدث خطأ', 'لا يمكن اضافة العميل لنفسه', 'error');
return false;
}
if (click2 == 0) {
click2++
$.post("work/order/ajax/add_tret_to_tretment_ajaxxx.php", {
tretment_id,
tretment_id_to_add,
}, function(get_tretment) {
$("#get_tretment").html(get_tretment);
})
} else {
swalfun("يرجى الانتظار", "تم بالفعل الضعط علية", "warning");
}
}
// الولاء
// العروض
$(function() {
$("#tretment_has_special_offer_b").click(function() {
tretment_has_special_offer();
});
});
click3 = 0;
function tretment_has_special_offer() {
let tretment_id = <?=json_encode($tretment_id)?>
let special_offer_id = $("#tretment_has_special_offer").val();
if (special_offer_id == 0) {
swalfun('حدث خطأ', 'يرجى تحديد العرض', 'error');
return false;
}
if (click2 == 0) {
click3++
$.post("work/order/ajax/add_tretment_has_special_offer_ajax.php", {
tretment_id,
special_offer_id
}, function(get_tretment) {
$("#get_tretment").html(get_tretment);
})
} else {
swalfun("يرجى الانتظار", "تم بالفعل الضعط علية", "warning");
}
}
// العروض
</script>
<?php
} else {
echo"
<script>
swalfun('تنبية','لا يوجد اي بيانات لهذا الرقم','info');
click = 0;
</script>
";
}
} else {
echo"
<script>
swalfun('حدث خطأ', 'رقم الجوال يجب أن يتكون من 9 أرقام وبدون 0 في البداية', 'error');
click = 0;
</script>
";
}
?>