172 lines
6.2 KiB
PHP
Executable File
172 lines
6.2 KiB
PHP
Executable File
<?php
|
|
require_once('../../../fixed/config/go_con.php');
|
|
|
|
$id = mysqli_real_escape_string($db, $_POST['id']);
|
|
$name = mysqli_real_escape_string($db, $_POST['name']);
|
|
$number = mysqli_real_escape_string($db, $_POST['number']);
|
|
$id_number = mysqli_real_escape_string($db, $_POST['id_number']);
|
|
|
|
$tretment_offer = mysqli_real_escape_string($db, $_POST['tretment_offer']);
|
|
$cu_date = mysqli_real_escape_string($db, $_POST['cu_date']);
|
|
|
|
if (!empty($name) && !empty($number)) {
|
|
|
|
$get_tretment_sql = mysqli_query($db, "SELECT `id` FROM `tretment` WHERE `number`='$number' AND `commercial_register_id` = '$commercial_register_id'");
|
|
|
|
if (mysqli_num_rows($get_tretment_sql) > 0) {
|
|
$tretment_row = mysqli_fetch_assoc($get_tretment_sql);
|
|
if (!($id == $tretment_row['id'])) {
|
|
echo "
|
|
<script>
|
|
swalfun('العميل مسجل','قم بإدخال رقم جوال آخر', 'error');
|
|
click = 0;
|
|
</script>
|
|
";
|
|
} else {
|
|
if(!mysqli_query(
|
|
$db,
|
|
"INSERT INTO `tretment_changes`(
|
|
`name_from`,
|
|
`name_to`,
|
|
`number_from`,
|
|
`number_to`,
|
|
`tr_date_from`,
|
|
`tr_date_to`,
|
|
`an_employee_offer_id_from`,
|
|
`an_employee_offer_id_to`,
|
|
`tretment_id`,
|
|
`date_time`,
|
|
`user_id`,
|
|
`activation_id`
|
|
) SELECT
|
|
`tretment`.`name`,
|
|
'$name',
|
|
`tretment`.`number`,
|
|
'$number',
|
|
DATE(`tretment`.`date_time`),
|
|
'$cu_date',
|
|
`tretment`.`an_employee_offer_id`,
|
|
'$tretment_offer',
|
|
'$id',
|
|
'$date_time',
|
|
'$admin_id',
|
|
'2'
|
|
FROM `tretment`
|
|
WHERE `tretment`.`id` = '$id'
|
|
AND `tretment`.`commercial_register_id` = '$commercial_register_id'
|
|
AND `tretment`.`activation_id` = 2"
|
|
)) {
|
|
echo"
|
|
<script>
|
|
swalfun('LA034-7','','error');
|
|
edit_click = 0;
|
|
</script>
|
|
";
|
|
} else {
|
|
if(!mysqli_query(
|
|
$db,
|
|
"UPDATE `tretment` SET
|
|
`name`='$name',
|
|
`id_number`='$id_number',
|
|
`number`='$number',
|
|
`an_employee_offer_id`='$tretment_offer',
|
|
`date_time`= CONCAT('$cu_date', ' ', TIME(`date_time`))
|
|
WHERE `id`= $id"
|
|
)) {
|
|
echo"
|
|
<script>
|
|
swalfun('LA030-7','','error');
|
|
edit_click = 0;
|
|
</script>
|
|
";
|
|
} else {
|
|
echo "
|
|
<script>
|
|
swalfun('تم تعديل العميل بنجاح','', 'success');
|
|
edit_click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
} else {
|
|
if(!mysqli_query(
|
|
$db,
|
|
"INSERT INTO `tretment_changes`(
|
|
`name_from`,
|
|
`name_to`,
|
|
`number_from`,
|
|
`number_to`,
|
|
`tr_date_from`,
|
|
`tr_date_to`,
|
|
`an_employee_offer_id_from`,
|
|
`an_employee_offer_id_to`,
|
|
`tretment_id`,
|
|
`date_time`,
|
|
`user_id`,
|
|
`activation_id`
|
|
) SELECT
|
|
`tretment`.`name`,
|
|
'$name',
|
|
`tretment`.`number`,
|
|
'$number',
|
|
DATE(`tretment`.`date_time`),
|
|
'$cu_date',
|
|
`tretment`.`an_employee_offer_id`,
|
|
'$tretment_offer',
|
|
'$id',
|
|
'$date_time',
|
|
'$admin_id',
|
|
'2'
|
|
FROM `tretment`
|
|
WHERE `tretment`.`id` = '$id'
|
|
AND `tretment`.`commercial_register_id` = '$commercial_register_id'
|
|
AND `tretment`.`activation_id` = 2"
|
|
)) {
|
|
echo"
|
|
<script>
|
|
swalfun('LA024-7','','error');
|
|
edit_click = 0;
|
|
</script>
|
|
";
|
|
} else {
|
|
if(!mysqli_query(
|
|
$db,
|
|
"UPDATE `tretment` SET
|
|
`name`='$name',
|
|
`id_number`='$id_number',
|
|
`number`='$number',
|
|
`an_employee_offer_id`='$tretment_offer',
|
|
`date_time`= CONCAT('$cu_date', ' ', TIME(`date_time`))
|
|
WHERE `id`= $id"
|
|
)) {
|
|
echo"
|
|
<script>
|
|
swalfun('LA730-7','','error');
|
|
edit_click = 0;
|
|
</script>
|
|
";
|
|
} else {
|
|
echo "
|
|
<script>
|
|
swalfun('تم تعديل العميل بنجاح','', 'success');
|
|
edit_click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
}
|
|
}
|
|
} else {
|
|
echo "
|
|
<script>
|
|
swalfun('حدث خطأ', '', 'error');
|
|
edit_click = 0;
|
|
</script>
|
|
";
|
|
}
|
|
|
|
|
|
?>
|