$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());