$typeP = $row3['type'];
if ($typeP == $typeS) {
$html .= "";
} else {
$html .= "<b>" . $row3['cod_name'] . " :</b><br/>" . $row3['name'] . ".<br/> <b>Адрес:</b> " . $row3['address'] . "<br/>";
}
$typeS = $row3['type'];
}
$html .= "</div>";
$html .= "</td>";
$html .= "</tr>";
$html .= "<tr>";
$html .= "<td>";
$html .= "Начин на представителство";
$html .= "</td>";
$html .= "<td>" . getPredstavitelstvo($row2['predst']) . "</td>";
$html .= "</tr>";
$html .= "<tr>";
$html .= "<td height='150px' valign='top'>";
$html .= "Документи";
$html .= "</td>";
$html .= "<td valign='top'>";
$sql4 = "SELECT e.cod_name, d.number, d.theirs_date, d.status, d.type_flag \n\t\t\t\t\t\t\t\t\t\t FROM elements e, documents d \n\t\t\t\t\t\t\t\t\t\t WHERE e.cod_cod = d.status \n\t\t\t\t\t\t\t\t\t\t AND d.asoc_id = '" . $row2['asoc_id'] . "'\n\t\t\t\t\t\t\t\t\t\t AND e.nom_code = IF (d.type_flag<10,CONCAT('0',d.type_flag),d.type_flag)";
$res4 = mysql_query($sql4) or die(mysql_error());
$statusS = "";
while ($row4 = mysql_fetch_assoc($res4)) {
if ($row4['type_flag'] == '5') {
$type_flag = 'Заявление: ';
}
if ($row4['type_flag'] == '50') {
$type_flag = 'Договор: ';
$resUd = mysql_query($sqlUd) or die(mysql_error());
while ($rowUd = mysql_fetch_assoc($resUd)) {
$vh_nom = $rowUd['number'];
$preds = $rowUd['name'];
$sdr_name = $rowUd['asoc_name'];
$vp_date = $rowUd['date_of_entry'];
$aso_id = $rowUd['asoc_numb'];
$kvIra = getKvAndRaion($rowUd['kvartal']);
$street = $rowUd['street'];
$bl = $rowUd['build_numb'];
$address = $kvIra . ', ' . $street . ' №' . $rowUd['str_nom'] . ', бл.' . $bl;
$predmet = getPredmet($rowUd['predmet']);
$srok = $rowUd['srok'];
$ideal = $rowUd['asoc_ideal_parts'];
$name = $rowUd['name'];
$n_predst = getPredstavitelstvo($rowUd['predst']);
}
//echo $vh_nom;
//echo $preds;
//echo $sdr_name;
//echo convertDate($vp_date);
//echo $r;
//echo $address;
// echo $predmet;
//echo $srok;
//echo $ideal;
// echo $chlens; //za ponedelnik
// echo $n_predst;
///////////////////////////////////////////////////////////////////////////////////////////////////////////
$sqlReg = "SELECT b.build_identify, b.year_of_const, b.type_const, b.total_square, b.numb_on_ground, \n\t\t\t\t\tb.numb_half_under, b.numb_under_floors, b.numb_floors,b.all_objects, a.asoc_numb, u.id, a.id \n\t\t\t FROM buildings b, asoc a, users u \n\t\t\t WHERE a.building_id = b.id AND a.id = '{$a_id}' and a.invalid='0' and b.invalid='0'";
$resReg = mysql_query($sqlReg) or die(mysql_error());
