$max_count = mysql_num_rows($res);
if ($max_count > 0) {
$i = 0;
$olddivname = '';
while ($row = mysql_fetch_array($res)) {
if ($olddivname != $row['sourcedivname']) {
$olddivname = $row['sourcedivname'];
$div_parent = get_div_parent($row['sourcediv_id']);
echo "\n\t <table width=100% border=0 cellspacing=1 cellpadding=1>\n\t <tr>\n\t <td ";
if (isset($_GET['head'])) {
echo "colspan=10";
}
echo " width=100% class='let_list_fixed'>  {$div_parent} <b>{$row['sourcedivname']}</b></td>\n\t </tr>\n\t </table>\n\n\t ";
}
$let_summ = number_format($row['letsum'], 2, '.', ' ');
$total_summ = number_format(get_full_letter_summ($row['let_id']), 2, '.', ' ');
echo "\n\n\t <table width=100% border";
if (!isset($_GET['head'])) {
echo "=0 ";
}
echo " cellspacing=1 cellpadding=1>\n\t <tr id={$row['letno']}";
// ondblclick='f_dblclick(id)';
echo ">\n\t <td bgcolor=white width=25 class='let_list_fixed' align=center>" . ($i + 1) . "</td>";
if (!isset($_GET['head'])) {
echo "\n\t <td width=25 class='let_list_fixed' ";
if (isset($_POST['sub_search'])) {
echo "style='background-color:{$row['loscolor']}'";
}
echo " align=center>";
if (!isset($_POST['sub_search'])) {
echo "<input checked type='checkbox' value='" . $row['let_id'] . "' name='ch[]'>";
function country_sum($query, $flag, $ch)
{
echo "\n <td class='main_oper_list' align=center valign=top width=50%>\n <table width=100% border=0 cellspacing=1 cellpadding=1>\n <tr>\n <td class='main_oper_list' align=center valign=top width=50%>\n <table width=100% border=0 cellspacing=2 cellpadding=0>";
$total = 0;
$total_all = 0;
$sum = 0;
$total_addsum = array_fill(0, 20, 0);
$total_addsum_name = array_fill(0, 20, "");
$itog_total_addsum = array_fill(0, 20, 0);
$i = 0;
$result_country = mysql_query($query) or die(mysql_error("Ошибка запроса"));
while (list($div_id, $divname) = mysql_fetch_row($result_country)) {
$query = "select let_id,letsum from letters l where";
if ($flag == 1) {
$query .= " div_id=";
} elseif ($flag == 2) {
$query .= " sourcediv_id=";
}
$query .= "{$div_id} ";
if ($ch != 0) {
$query .= "and let_id in(";
$query1 = "";
while (list($index, $value) = each($ch)) {
$query1 .= "{$value},";
$query .= "{$value},";
}
$query = substr($query, 0, -1);
$query1 = substr($query1, 0, -1);
$query .= ");";
reset($ch);
} else {
if (!isset($_GET['head'])) {
require "oper/letters/search_add_query_ctrl.php";
} else {
require "letters/search_add_query_ctrl.php";
}
}
$res = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($res)) {
$total_summ = get_full_letter_summ($row['let_id']);
$total += $total_summ;
$sum += $row['letsum'];
$query_addsum = "select last_id,lastname from letaddsummtypes,letactiontypes\n where letaddsummtypes.lat_id=letactiontypes.lat_id ";
$res2 = mysql_query($query_addsum) or die(mysql_error());
while ($row2 = mysql_fetch_array($res2)) {
$last_summ = get_letter_summ($row2['last_id'], $row['let_id']);
if ($last_summ != 0) {
$total_addsum[$i] += $last_summ;
if ($row2['lastname'] != "") {
$total_addsum_name[$i] = $row2['lastname'];
}
}
$i++;
}
$i = 0;
}
if ($total != 0) {
$str = number_format($total, 2, '.', ' ');
$str3 = number_format($sum, 2, '.', ' ');
$s1 = get_div_parent($div_id);
echo "\n <tr>\n <td class='total_oper_text' valign=center width=50% align=right>\n {$s1}.<b>{$divname}</b>\n </td>\n <td class='total_oper_text'>\n <table width=100% border=0 cellspacing=0 cellpadding=2>\n <tr>\n <td class='let_list_data' style='BORDER: 0px solid;font-size=7pt;color:#888888' align=right valign=center width=15% align=left>\n к передаче\n </td>\n <td class='let_list_data' style='BORDER: 0px solid;font-size=8pt;color:#990000' valign=center width=15% align=right>\n {$str3}\n </td>\n </tr>";
while (list($index, $value) = each($total_addsum)) {
if ($value == 0) {
break;
}
echo "\n <tr>\n <td class='let_list_data' style='BORDER: 0px solid;font-size=7pt;color:#888888' align=right valign=center width=15% align=left>\n {$total_addsum_name[$index]}";
$itog_total_addsum[$index] += $total_addsum[$index];
echo "\n </td>\n <td class='let_list_data' style='BORDER: 0px solid;font-size=8pt;color:#996666' valign=center width=15% align=right>";
$str1 = number_format($value, 2, '.', ' ');
echo "\n {$str1}\n </td>\n </tr>";
}
reset($total_addsum);
echo "\n </table>\n </td >\n\n </tr>\n\n\n ";
$total_all += $sum;
$total_addsum = array_fill(0, 20, 0);
}
$total = 0;
$sum = 0;
}
$totalstr = number_format($total_all, 2, '.', ' ');
echo "\n\n\n\n\n <tr>\n <td align=right class='total_oper_text' style='background-color:#EEEEEE' valign=center width=50%>\n <b>ИТОГО </b>\n </td>\n <td class='total_oper_num' style='background-color:#EEEEEE' valign=center width=50% align=right>\n <table width=100% border=0 cellspacing=0 cellpadding=2>\n ";
echo "\n <tr>\n <td class='total_oper_text' style='background-color:#EEEEEE;BORDER: 0px solid;' align=right valign=center width=15% align=left>\n к передаче\n </td>\n\n <td class='total_oper_num' style='background-color:#EEEEEE;BORDER: 0px solid;' valign=center width=15% align=right>";
echo " <b>{$totalstr}</b>\n\n </td>\n </tr>";
while (list($index, $value) = each($total_addsum_name)) {
if ($total_addsum_name[$index] == "") {
break;
}
echo "\n <tr>\n <td class='total_oper_text' style='background-color:#EEEEEE;BORDER: 0px solid;' align=right valign=center width=15% align=left>\n {$total_addsum_name[$index]}\n </td>\n\n <td class='total_oper_num' style='background-color:#EEEEEE;BORDER: 0px solid;' valign=center width=15% align=right>";
$str1 = number_format($itog_total_addsum[$index], 2, '.', ' ');
echo " {$str1}\n\n </td>\n </tr>";
}
echo "\n\n </table>\n </td>\n </tr>\n </table>\n </td>\n\n ";
echo "\n </tr>\n <tr><td height=1></td></tr>\n </table>\n </td>";
}
echo "\n\t <table width=100% border";
if (!isset($_GET['head'])) {
echo "=0 ";
}
echo " cellspacing=1 cellpadding=1>\n\n\n\n\n\t ";
$total = 0;
$total_all = 0;
$query_country = "select {$dbname}.div.div_id, {$dbname}.div.divname\n\t from {$dbname}.div,divext\n\t where {$dbname}.div.div_id=divext.div_id and divext.dl_id=7;";
$result_country = mysql_query($query_country) or die(mysql_error("ќшибка запроса"));
while (list($div_id, $divname) = mysql_fetch_row($result_country)) {
$query = "select l.let_id\n \t\t\t\t\tfrom letters l, {$dbname}.div dd, {$dbname}.div sd, clients cl, payee p, iusers u,letoperstate los\n\t\t\t\t\t\t\t\twhere l.user_id=u.user_id and l.client_id=cl.client_id and l.div_id=dd.div_id and\n\t\t\t\t\t\t\t\tl.sourcediv_id=sd.div_id and l.payee_id=p.payee_id and l.los_id=los.los_id and l.sourcediv_id=" . $_SESSION['div'] . " and l.div_id={$div_id}";
require "search_add_query.php";
$query .= " order by l.let_id";
$res = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($res)) {
$total_summ = get_full_letter_summ($row['let_id']);
$total += $total_summ;
}
if ($total != 0) {
$str = number_format($total, 2, '.', ' ');
$s1 = get_div_parent($div_id);
echo "<tr>\n\t <td ";
if (isset($_GET['head'])) {
echo "colspan=4";
}
echo " class='total_oper_text' valign=center width=70% align=right>\n\t {$s1}.<b>{$divname}</b>\n\t </td>\n\t <td class='total_oper_num' valign=center width=30% align=right>\n\t {$str}\n\t </td>\n\t </tr>\n\t ";
$total_all += $total;
}
$total = 0;
}
echo "</table>";
