function ShowReserveText($reserve_id)
{
require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/billing.php";
global $session, $DB;
session_start();
$uid = get_uid(false);
$objResponse = new xajaxResponse();
$info = false;
if ($reserve_id) {
$sql = "\n WITH bill_queue_ammount AS (\n SELECT SUM(CASE WHEN pro_ammount > 0 THEN pro_ammount ELSE ammount END) as ammount, reserve_id FROM bill_queue\n WHERE reserve_id = ?i\n GROUP BY reserve_id\n )\n SELECT 'Список заказов №'|| id ||' на сумму ' || round(bq.ammount, 2) || ' руб' as op_name, id, " . billing::RESERVE_OP_CODE . " as op_code\n FROM bill_reserve\n INNER JOIN bill_queue_ammount as bq ON bq.reserve_id = bill_reserve.id\n WHERE id = ?i AND uid = ?i";
$row = $DB->row($sql, $reserve_id, $reserve_id, $uid);
if ($row && !empty($row['op_name'])) {
$info = account::GetHistoryText($row);
}
}
if ($info) {
$objResponse->assign("res" . $reserve_id, "innerHTML", $info);
}
return $objResponse;
}
<td class="b-layout__td b-layout__td_bordbot_3_e6 b-layout__td_padbot_10 b-layout__td_padleft_10 b-layout__td_width_90">
<div class="b-layout__txt b-layout__txt_italic">Сумма, руб.</div>
</td>
<td class="b-layout__td b-layout__td_bordbot_3_e6 b-layout__td_padbot_10 b-layout__td_padleft_10 b-layout__td_width_90">
<div class="b-layout__txt b-layout__txt_italic">Баланс, руб.</div>
</td>
<td class="b-layout__td b-layout__td_bordbot_3_e6 b-layout__td_padbot_10 b-layout__td_padleft_10 b-layout__td_width_240">
<div class="b-layout__txt b-layout__txt_italic">Примечание</div>
</td>
</tr>
<?php
foreach ($history['items'] as $item) {
?>
<?php
$itemName = account::GetHistoryText($item);
$itemText = str_replace('%username%', $_SESSION['login'], $itemText);
?>
<tr class="b-layout__tr">
<td class="b-layout__td b-layout__td_padtb_10 b-layout__td_width_90 b-layout__td_bordbot_e6">
<div class="b-layout__txt b-layout__txt_color_808080 b-layout__txt_fontsize_11"><?php
echo date('d.m.Y', strtotime($item['op_date']));
?>
<br><?php
echo date('H:i', strtotime($item['op_date']));
?>
</div>
</td>
<td class="b-layout__td b-layout__td_padtb_10 b-layout__td_padleft_10 b-layout__td_bordbot_e6">
<div class="b-layout__txt <?php
echo $item['status'] == 'cancel' ? 'b-layout__txt_color_808080' : '';
