'عميل سابق'
AND DATE(`invoices`.`date_time`) = '$date'
AND `dd`.`id` IN (SELECT MAX(`id`) FROM `book_details` WHERE `book_id` = `dd`.`book_id`)
AND `book`.`tretment_id` = $tretment_id");
if (mysqli_num_rows($get_invoices_discount_details_sql) > 0) {
$contnute = false;
echo"
";
}
}
// كود خاص للعرض الصباحي
if ($contnute) {
$get_packages_sql = mysqli_query($db, "SELECT `id`, `name`, `price` FROM `packages` WHERE `id`= '$pack_id' AND `activation_id` = 2 LIMIT 1");
if (mysqli_num_rows($get_packages_sql) > 0) {
$row_packages = mysqli_fetch_assoc($get_packages_sql);
if (!empty($vat)) {
$pack_price_from_db = round($row_packages['price'] + (($row_packages['price']*$vat)/100),2);
} else {
$pack_price_from_db = round($row_packages['price'],2);
}
$current_price = $price;
$payments = $cash_pay + $card_pay + $trans_pay;
if ($current_price == $pack_price_from_db && $pack_price_from_db == $payments) {
$get_commercial_register_sql = mysqli_query($db, "SELECT
`commercial_register`.`word_tag`
FROM `packages`
LEFT JOIN `commercial_register` ON `packages`.`commercial_register_id` = `commercial_register`.`id`
WHERE `packages`.`id` = '$pack_id'
");
if (mysqli_num_rows($get_commercial_register_sql) > 0) {
$row_commercial_register = mysqli_fetch_assoc($get_commercial_register_sql);
$number_style = date('y', strtotime($date_time)) . $row_commercial_register['word_tag'];
$get_bonds_sql = mysqli_query($db, "SELECT
`number`,
`number_style`
FROM `bonds`
WHERE `number_style` LIKE '$number_style%'
AND `number` IN (SELECT MAX(`number`) FROM `bonds` WHERE `number_style` LIKE '$number_style%')"
);
$number = '';
if (mysqli_num_rows($get_bonds_sql) > 0) {
$row_bonds = mysqli_fetch_assoc($get_bonds_sql);
$number = $row_bonds['number'] + 1;
$number_style = date('y', strtotime($date_time)) . $row_commercial_register['word_tag'] . str_pad($number, 7, '0', STR_PAD_LEFT);
} else {
$number_style = date('y', strtotime($date_time)) . $row_commercial_register['word_tag'] . "0000001";
$number = 1;
}
if(mysqli_query(
$db,
"INSERT INTO `bonds`(`number`, `number_style`, `price`, `notes`, `tretment_id`, `invoices_page_id`, `bonds_type_id`, `bonds_type_type_id`, `date_time`, `user_id`, `activation_id`)
VALUES ('$number','$number_style','$current_price','$pack_note','$tretment_id','3','2','3','$date_time','$admin_id','2')"
)) {
$last_id = mysqli_insert_id($db);
if(mysqli_query($db,
"INSERT INTO `bonds_details`(`pay`, `notes`, `bonds_id`, `bonds_status_id`, `branch_id`, `date_time`, `user_id`, `activation_id`)
VALUES ('$payments','$pack_note','$last_id','1','$admin_branch_id','$date_time','$admin_id','2')"
)) {
$last_id_2 = mysqli_insert_id($db);
if (!empty($cash_pay)) {
mysqli_query($db,
"INSERT INTO `bonds_details_has_how_pay`(`bonds_details_id`, `how_pay_id`, `pay`, `notes`, `date_time`, `user_id`, `activation_id`)
VALUES ('$last_id_2','1','$cash_pay','$cash_note','$date_time','$admin_id','2')"
);
$query = "SELECT * FROM `walla_answers` WHERE `tretment_id`= $tretment_id";
$sql = mysqli_query($db, $query);
if (mysqli_num_rows($sql) > 0) {
$cash_pay_walla = round(($cash_pay / 1.15) * $double_ranks_walla);
mysqli_query(
$db,
"INSERT INTO `walla_points`(`points`, `notes`, `tretment_id`, `walla_reasons_id`, `date_time`, `user_id`, `activation_id`)
VALUES ('$cash_pay_walla','','$tretment_id','7','$date_time','$admin_id','2')"
);
}
}
if (!empty($card_pay)) {
mysqli_query($db,
"INSERT INTO `bonds_details_has_how_pay`(`bonds_details_id`, `how_pay_id`, `pay`, `notes`, `date_time`, `user_id`, `activation_id`)
VALUES ('$last_id_2','2','$card_pay','$card_note','$date_time','$admin_id','2')"
);
$query = "SELECT * FROM `walla_answers` WHERE `tretment_id`= $tretment_id";
$sql = mysqli_query($db, $query);
if (mysqli_num_rows($sql) > 0) {
$card_pay_walla = round(($card_pay / 1.15) * $double_ranks_walla);
mysqli_query(
$db,
"INSERT INTO `walla_points`(`points`, `notes`, `tretment_id`, `walla_reasons_id`, `date_time`, `user_id`, `activation_id`)
VALUES ('$card_pay_walla','','$tretment_id','7','$date_time','$admin_id','2')"
);
}
}
if (!empty($trans_pay)) {
mysqli_query($db,
"INSERT INTO `bonds_details_has_how_pay`(`bonds_details_id`, `how_pay_id`, `pay`, `notes`, `date_time`, `user_id`, `activation_id`)
VALUES ('$last_id_2','$trans_type','$trans_pay','$trans_note','$date_time','$admin_id','2')"
);
$query = "SELECT * FROM `walla_answers` WHERE `tretment_id`= $tretment_id";
$sql = mysqli_query($db, $query);
if (mysqli_num_rows($sql) > 0) {
$trans_pay_walla = round(($trans_pay / 1.15) * $double_ranks_walla);
mysqli_query(
$db,
"INSERT INTO `walla_points`(`points`, `notes`, `tretment_id`, `walla_reasons_id`, `date_time`, `user_id`, `activation_id`)
VALUES ('$trans_pay_walla','','$tretment_id','7','$date_time','$admin_id','2')"
);
}
}
if(mysqli_query($db,
"INSERT INTO `bonds_details_has_packages`(`bonds_details_id`, `packages_id`, `date_time`, `user_id`, `activation_id`)
VALUES ('$last_id_2','$pack_id','$date_time','$admin_id','2')"
)) {
$get_packages_has_services_sql = mysqli_query($db, "SELECT
`services_id`,
`how_many`
FROM `packages_has_services`
WHERE `packages_id` = '$pack_id'
");
if (mysqli_num_rows($get_packages_has_services_sql) > 0) {
while ($row_packages_has_services = mysqli_fetch_assoc($get_packages_has_services_sql)) {
$services_id = $row_packages_has_services['services_id'];
$how_many = $row_packages_has_services['how_many'];
for ($i=0; $i < $how_many; $i++) {
mysqli_query($db,
"INSERT INTO
`tretment_has_service`(
`tretment_id`,
`services_id`,
`inv_from_db_tables_id`,
`inv_table_id`,
`done_id`,
`date_time`,
`user_id`,
`activation_id`
)
VALUES (
'$tretment_id',
'$services_id',
(SELECT `id` FROM `db_tables` WHERE `name` = 'bonds' LIMIT 1),
'$last_id',
'1',
'$date_time',
'$admin_id',
'2'
)
"
);
}
}
echo"
";
} else {
echo"
";
}
} else {
echo"
";
}
} else {
echo"
";
}
} else {
echo"
";
}
} else {
echo"
";
}
} else {
echo"
";
}
} else {
echo"
";
}
}
?>