0) {
$tretment_row = mysqli_fetch_assoc($get_tretment_sql);
if (!($id == $tretment_row['id'])) {
echo "
";
} 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"
";
} 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"
";
} else {
echo "
";
}
}
}
} 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"
";
} 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"
";
} else {
echo "
";
}
}
}
} else {
echo "
";
}
?>