function sprav($mysqli, $id)
{
$q = 'SELECT * FROM sprav WHERE id ="' . $id . '" ORDER BY kod';
$res = mysqli_query($mysqli, $q) or die(mysqli_error($mysqli));
$row = mysqli_fetch_array($res);
//выберем одну строку (она и должна быть одна)
$link = '' . PATH . '/?org=' . $row['alias_ru'];
echo '<div class="element">';
//отдельный контейнер по элементам, более узкий, все остальное выводим туда
//выводим шапку элемента <div class="naimenovanie_na_pechat"> </div>
echo '<div class="naimenovanie_na_pechat"><a href=' . $link . ' class="naimenovanie_na_pechat_a">' . $row['naimenovanie_na_pechat'] . '</a></div>';
if ($row['podzagolovok'] != "") {
echo '<div class="podzagolovok">' . $row['podzagolovok'] . '</div>';
}
if ($row['yuridicheskiy_status'] != "") {
echo '<div class="yuridicheskiy_status">' . $row['yuridicheskiy_status'] . '</div>';
}
if ($row['adres'] != "") {
echo '<div class="adres">' . $row['adres'] . '</div>';
}
if ($row['litso_dolzhnost'] != "") {
echo '<div class="litso_dolzhnost">' . $row['litso_dolzhnost'] . '</div>';
}
if ($row['litso_fio'] != "") {
echo '<div class="litso_fio">' . $row['litso_fio'] . '</div>';
}
$q_tel = 'SELECT * FROM sprav_tel WHERE idr ="' . $id . '" ORDER BY nom_str';
$res_tel = mysqli_query($mysqli, $q_tel) or die(mysqli_error($mysqli));
echo '<table class="table_tel">';
//123
while ($row = mysqli_fetch_assoc($res_tel)) {
//цикл по телефонам
//01_adres_telefony_v_odnoy_stroke = Адрес, телефоны в одной строке
if ($row['format_vyvoda_strok'] == '01_adres_telefony_v_odnoy_stroke') {
$adres = $row['adres'];
$tel = tel($row['telefony']);
//адрес, телефон
echo '<tr>';
echo '<td class="adres_table">' . $adres . '</td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '01_adres_dolzhnost_fio_telefony_v_raznykh_strokakh') {
$adres = $row['adres'];
$litso_dolzhnost = $row['litso_dolzhnost'];
$litso_fio = $row['litso_fio'];
$tel = tel($row['telefony']);
//адрес, теелфон
echo '<tr>';
echo '<td class="adres_table">' . $adres . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_dolzhnost_table">' . $litso_dolzhnost . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_fio">' . $litso_fio . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '02_adres_telefony_v_raznykh_strokakh') {
$adres = $row['adres'];
$tel = tel($row['telefony']);
//адрес
echo '<tr>';
echo '<td class="adres_table">' . $adres . '</td><td></td>';
echo '</tr>';
//телефон
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '03_dolzhnost_telefony_v_odnoy_stroke') {
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td class="litso_dolzhnost_table">' . $row['litso_dolzhnost'] . '</td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '04_dolzhnost_telefony_v_raznykh_strokakh') {
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td class="litso_dolzhnost_table">' . $row['litso_dolzhnost'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '05_dolzhnost_fio_v_odnoy_stroke') {
$litso_dolzhnost = $row['litso_dolzhnost'];
$litso_fio = $row['litso_fio'];
echo '<tr>';
echo '<td class="litso_dolzhnost">' . $litso_dolzhnost . '<span class="litso_fio">' . $litso_fio . '</span></td><td></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '06_dolzhnost_fio_telefony_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="litso_dolzhnost">' . $row['litso_dolzhnost'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_fio">' . $row['litso_fio'] . '</td><td></td>';
echo '</tr>';
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '09_podrazdelenie_adres_v_odnoy_stroke') {
$podr = $row['podrazdelenie_filial'];
$adres = $row['adres'];
echo '<tr>';
echo '<td class="podrazdelenie_filial">' . $podr . '</td><td class="adres_table">' . $adres . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '10_podrazdelenie_adres_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="podrazdelenie_filial">' . $row['podrazdelenie_filial'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="adres_table">' . $row['adres'] . '</td><td></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '11_podrazdelenie_adres_telefony_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="podrazdelenie_filial_table">' . $row['podrazdelenie_filial'] . '</td><td class="tel"></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="adres_table">' . $row['adres'] . '</td><td class="tel"></td>';
echo '</tr>';
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '12_podrazdelenie_dolzhnost_telefony_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="podrazdelenie_filial_table">' . $row['podrazdelenie_filial'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_dolzhnost_table">' . $row['litso_dolzhnost'] . '</td><td></td>';
echo '</tr>';
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '13_podrazdelenie_dolzhnost_fio_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="podrazdelenie_filial_table">' . $row['podrazdelenie_filial'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_dolzhnost_table">' . $row['litso_dolzhnost'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_fio">' . $row['litso_fio'] . '</td><td></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '14_podrazdelenie_dolzhnost_fio_telefony_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="podrazdelenie_filial">' . $row['podrazdelenie_filial'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_dolzhnost">' . $row['litso_dolzhnost'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_fio">' . $row['litso_fio'] . '</td><td></td>';
echo '</tr>';
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '15_podrazdelenie_telefony_v_odnoy_stroke') {
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td class="podrazdelenie_filial">' . $row['podrazdelenie_filial'] . '</td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '16_podrazdelenie_telefony_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="podrazdelenie_filial">' . $row['podrazdelenie_filial'] . '</td><td class="tel"></td>';
echo '</tr>';
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '17_rezhim_raboty') {
echo '<tr>';
echo '<td class="rezhimrabotystroka">' . $row['rezhimrabotystroka'] . '</td><td class="tel"></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '18_rezhim_raboty_s_dop_inf_v_raznykh_str_') {
echo '<tr>';
echo '<td class="dop_informatsiya">' . $row['dop_informatsiya'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="rezhimrabotystroka">' . $row['rezhimrabotystroka'] . '</td><td></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '19_sayt_') {
$sayt = $row['elpochta_sayt'];
echo '<tr>';
echo '<td class="sayt_"></td><td class="sayt"><a class="elpochta_a" href="http://' . $sayt . '">' . $sayt . '</a></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '20_tolko_adres') {
$adres = $row['adres'];
echo '<tr>';
echo '<td class="adres_table">' . $row['adres'] . '</td><td></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '21_tolko_podrazdelenie') {
echo '<tr>';
echo '<td class="podrazdelenie_filial">' . $row['podrazdelenie_filial'] . '</td><td></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '22_tolko_telefony') {
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '23_dop_informatsiya') {
echo '<tr>';
echo '<td class="dop_informatsiya">' . $row['dop_informatsiya'] . '</td><td></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '24_fio_telefony_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="litso_fio">' . $row['litso_fio'] . '</td><td></td>';
echo '</tr>';
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '25_fio_telefony_v_odnoy_stroke') {
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td class="litso_fio">' . $row['litso_fio'] . '</td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '25_elpochta') {
$elpochta = $row['elpochta_sayt'];
echo '<tr>';
echo '<td class="elpochta_">Эл.почта:</td><td class="elpochta"><a class="elpochta_a" href="mailto:' . $elpochta . '">' . $elpochta . '</a></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '26_aska') {
$ICQ = $row['elpochta_sayt'];
echo '<tr>';
echo '<td class="icq_table_">ICQ</td><td class="tel">' . $ICQ . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '27_skayp') {
$Skype = $row['elpochta_sayt'];
echo '<tr>';
echo '<td class="skype_table_">Skype:</td><td class="skype"><a class="elpochta_a" href="skype:' . $Skype . '?call">' . $Skype . '</a></td>';
echo '</tr>';
} else {
echo '<tr>';
echo '<td>' . $row['nom_str'] . '</td><td>' . $row['format_vyvoda_strok'] . '</td>';
echo '</tr>';
}
}
//конец цикла по телефонам
echo '</table>';
//echo '<table class="table_tel">';
$q = 'SELECT * FROM sprav_dop WHERE idr ="' . $id . '" ORDER BY id';
$res_mat = mysqli_query($mysqli, $q) or die(mysqli_error($mysqli));
while ($row_mat = mysqli_fetch_assoc($res_mat)) {
echo '' . $row_mat['html_code'];
}
//конец вывода доп.материала if ($mysqli->connect_error) {
echo '</div>';
//'<div class="element">'; //отдельный контейнер по элементам, более узкий, все остальное выводим туда
//mysqli_close($mysqli);
}
//function voor tellen items array
function tel($ararray)
{
//beginnen met tellen bij 0
$iaantal = 0;
//array doorlopen en 1 optellen bij $iaantal optellen
foreach ($ararray as $waarde) {
//tel 1 bij $iaantal op
$iaantal++;
}
//eind getal na optellen
return $iaantal;
}
$arraytest = array(1, 2, 3, 4, 5);
//functie testen
echo '$arraytest bevat ' . tel($arraytest) . ' items. ';
$sgebruikersnaam = 'adminadmiadmiadmiadmi';
//gebruikersnaam testen op lengte en mag niet admin zijn en langer dan 15 letters is niet goed.
function checkgebruiker($sgebruikersnaam)
{
if (strlen($sgebruikersnaam) > 15) {
return false;
} elseif ($sgebruikersnaam == 'admin') {
return false;
} elseif (strlen($sgebruikersnaam) > 3) {
return true;
} else {
return false;
}
}
if (checkgebruiker($sgebruikersnaam)) {
}
echo '</thead>' . "\r\n";
echo '<tbody>' . "\r\n";
foreach ($fisler as $fis) {
echo ' <tr id="fis_' . $fis->fis_no . '">' . "\r\n";
echo ' <td class="listeIslemDivi">' . "\r\n";
echo ' <a href="javascript:;" onclick="servisFisiEkle(' . $fis->fis_no . ', \'' . $fis->is_numarasi . '\');">' . "\r\n";
echo ' <img src="' . base_url() . 'resimler/fis_duzenle_icon.png" title="' . $fis->musteri_adi . ' isimli Müşterinin Fişini İncele">' . "\r\n";
echo ' </a>' . "\r\n";
echo ' <a href="' . base_url() . 'servis/servis_fis_sil/' . $fis->fis_no . '" onclick="return confirm(\'' . @$fis->musteri_adi . ' isimli Müşterinin Fişini Silmek istediğinize emin misiniz?\');">' . "\r\n";
echo ' <img src="' . base_url() . 'resimler/Close-2-icon.png" title="' . $fis->musteri_adi . ' isimli Müşterinin Fişini Sil">' . "\r\n";
echo ' </a>' . "\r\n";
echo ' </td>' . "\r\n";
echo ' <td class="isNumarasi">' . $fis->is_numarasi . '</td>' . "\r\n";
echo ' <td class="gelisTarihi">' . date('d.m.Y', $fis->gelis_tarihi) . '</td>' . "\r\n";
echo ' <td class="musteriAdi">' . $fis->musteri_adi . '</td>' . "\r\n";
echo ' <td class="tel">' . tel($fis->tel) . '</td>' . "\r\n";
echo ' <td class="email">' . (strlen($fis->email) ? $fis->email : '') . '</td>' . "\r\n";
echo ' <td class="durum"><img src="' . base_url() . 'resimler/durumlar/durum_' . $fis->durum . '.png" width="30"> ' . $fis->durum_aciklama . '</td>
<td class="urunTur"><img src="' . base_url() . 'resimler/markalar/' . $fis->marka_resim . '" width="30"> <img src="' . base_url() . 'resimler/cihazlar/' . $fis->tur_resim . '"></td>
<td class="urunKodu">' . $fis->urun_kodu . '</td>
<td class="urunAdi">' . $fis->urun_adi . '</td>
<td class="seriNo">' . $fis->seri_no . '</td>
</tr>' . "\r\n" . "\r\n";
}
echo '</tbody>';
/* servis_liste.php Dosyasının Sonu */
/* Hazırlayan Güner ARIK */
/* 0(546) 862 62 48 */
/* guner@gunerarik.com.tr */
/* ./application/views/servis_liste.php Adresinde Kayıtlı */
EOF;
//メール確認画面のボタン
$confirmBtn = <<<EOF
<input type='button' value='入力画面に戻る' alt='入力画面に戻る' onclick='history.back()' /> <input type='submit' name='submit' value='送信' />
EOF;
//メール送信後画面のボタン
$returnBtn = <<<EOF
<input type='submit' value='フォームに戻る' alt='フォームに戻る' />
EOF;
//メール送信後画面のボタンのリンク先(初期設定はメール入力画面)
$returnPath = "form.html";
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
require $configpath;
//消さないで！！
//テンプレートタグの設定(カンマ区切りで複数指定してください。)
$post = array("■お問い合わせ" => output("お問い合わせ", "true"), "■以前当院にお問い合わせ・ご来院はございますか" => checkBox("ご来院", ", ", "false"), "■お名前" => name("姓", "名", "true"), "■性別" => output("性別", "true"), "■年齢" => output("年齢", "true"), "■メールアドレス" => mailAdd("メール", "メール確認", "true"), "■メールアドレス(確認)" => mailAdd("メール確認", "メール", "true"), "■お電話番号" => tel("電話番号1", "電話番号2", "電話番号3", "true"), "■身長" => output("身長", "true", "", "ｃｍ"), "■体重" => output("体重", "true", "", "ｋｇ"), "■ご相談個所" => checkBox("ご相談個所", ", ", "false"), "■お問い合わせ内容" => output("お問い合わせ内容", "false"), "■第一希望・月" => output("第一希望・月", "true", "", "月"), "■第一希望・日" => output("第一希望・日", "true", "", "日"), "■第一希望・時" => output("第一希望・時", "true", "", ""), "■第二希望・月" => output("第二希望・月", "false", "", "月"), "■第二希望・日" => output("第二希望・日", "false", "", "日"), "■第二希望・時" => output("第二希望・時", "false", "", ""), "■第三希望・月" => output("第三希望・月", "false", "", "月"), "■第三希望・日" => output("第三希望・日", "false", "", "日"), "■第三希望・時" => output("第三希望・時", "false", "", ""), "■ご連絡方法" => output("ご連絡方法", "false"), "■連絡の希望時間帯" => output("連絡の希望時間帯", "false", "", ""), "■ご来院時当日のご希望" => output("ご来院時当日のご希望", "false"));
$post_name = array("■お名前" => name("姓", "名", "true"));
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//
// テンプレートタグ一覧（コピーして$postに追加してください。また、name値はinputの設定に応じてに変更してください。）
//
// "テキスト、セレクト、ラジオボタンなど" => output("name値","false","テキスト","テキスト"),
//
// "お名前" => name("姓","名","true"),
//
// "生年月日" => birthday("年","月","日","false","西暦"),
//
// "郵便番号" => postcode("郵便番号1","郵便番号2","false"),
//
// "電話番号" => tel("電話番号1","電話番号2","電話番号3","false"),
//
function f_search($search)
{
//function search($_GET['search'])
$mysqli = mysqli_connect(HOST, USER, PASSWORD, DB_SPRAV89);
if ($mysqli->connect_error) {
die('Ошибка подключения (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error);
}
mysqli_query($mysqli, "SET NAMES utf8");
$q = 'SELECT * FROM sprav WHERE naimenovanie_na_pechat LIKE "%' . $search . '%"';
$res = mysqli_query($mysqli, $q) or die(mysqli_error($mysqli));
while ($row = mysqli_fetch_array($res)) {
$q_rod = 'SELECT * FROM roditel2 WHERE id ="' . $row['idr'] . '"';
$res_rod = mysqli_query($mysqli, $q_rod) or die(mysqli_error($mysqli));
$row_rod = mysqli_fetch_array($res_rod);
$link = '' . PATH . '?org=' . $row['alias_ru'] . '';
echo '<div class="element">';
//отдельный контейнер по элементам, более узкий, все остальное выводим туда
//выводим шапку элемента
echo '<div class="naimenovanie_na_pechat"><a href=' . $link . ' class="naimenovanie_na_pechat_a">' . $row['naimenovanie_na_pechat'] . '</a></div>';
//Найдем группу - родителя
if ($row['podzagolovok'] != "") {
echo '<div class="podzagolovok">' . $row['podzagolovok'] . '</div>';
}
if ($row['yuridicheskiy_status'] != "") {
echo '<div class="yuridicheskiy_status">' . $row['yuridicheskiy_status'] . '</div>';
}
if ($row['adres'] != "") {
echo '<div class="adres">' . $row['adres'] . '</div>';
}
if ($row['litso_dolzhnost'] != "") {
echo '<div class="litso_dolzhnost">' . $row['litso_dolzhnost'] . '</div>';
}
if ($row['litso_fio'] != "") {
echo '<div class="litso_fio">' . $row['litso_fio'] . '</div>';
}
//
$idsprav = $row['id'];
$aliassprav = $row['alias_ru'];
$q_tel = 'SELECT * FROM sprav_tel WHERE idr ="' . $idsprav . '" ORDER BY nom_str';
$res_tel = mysqli_query($mysqli, $q_tel) or die(mysqli_error($mysqli));
echo '<table class="table_tel">';
//123
while ($row = mysqli_fetch_assoc($res_tel)) {
//цикл по телефонам
//01_adres_telefony_v_odnoy_stroke = Адрес, телефоны в одной строке
if ($row['format_vyvoda_strok'] == '01_adres_telefony_v_odnoy_stroke') {
$adres = $row['adres'];
$tel = tel($row['telefony']);
//адрес, теелфон
echo '<tr>';
echo '<td class="adres_table">' . $adres . '</td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '01_adres_dolzhnost_fio_telefony_v_raznykh_strokakh') {
$adres = $row['adres'];
$litso_dolzhnost = $row['litso_dolzhnost'];
$litso_fio = $row['litso_fio'];
$tel = tel($row['telefony']);
//адрес, теелфон
echo '<tr>';
echo '<td class="adres_table">' . $adres . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_dolzhnost_table">' . $litso_dolzhnost . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_fio">' . $litso_fio . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '02_adres_telefony_v_raznykh_strokakh') {
$adres = $row['adres'];
$tel = tel($row['telefony']);
//адрес
echo '<tr>';
echo '<td class="adres_table">' . $adres . '</td><td></td>';
echo '</tr>';
//телефон
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '03_dolzhnost_telefony_v_odnoy_stroke') {
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td class="litso_dolzhnost_table">' . $row['litso_dolzhnost'] . '</td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '04_dolzhnost_telefony_v_raznykh_strokakh') {
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td class="litso_dolzhnost_table">' . $row['litso_dolzhnost'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '05_dolzhnost_fio_v_odnoy_stroke') {
$litso_dolzhnost = $row['litso_dolzhnost'];
$litso_fio = $row['litso_fio'];
echo '<tr>';
echo '<td class="litso_dolzhnost">' . $litso_dolzhnost . '<span class="litso_fio">' . $litso_fio . '</span></td><td></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '06_dolzhnost_fio_telefony_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="litso_dolzhnost">' . $row['litso_dolzhnost'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_fio">' . $row['litso_fio'] . '</td><td></td>';
echo '</tr>';
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '09_podrazdelenie_adres_v_odnoy_stroke') {
$podr = $row['podrazdelenie_filial'];
$adres = $row['adres'];
echo '<tr>';
echo '<td class="podrazdelenie_filial">' . $podr . '</td><td class="adres_table">' . $adres . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '10_podrazdelenie_adres_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="podrazdelenie_filial">' . $row['podrazdelenie_filial'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="adres_table">' . $row['adres'] . '</td><td></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '11_podrazdelenie_adres_telefony_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="podrazdelenie_filial_table">' . $row['podrazdelenie_filial'] . '</td><td class="tel"></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="adres_table">' . $row['adres'] . '</td><td class="tel"></td>';
echo '</tr>';
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '12_podrazdelenie_dolzhnost_telefony_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="podrazdelenie_filial_table">' . $row['podrazdelenie_filial'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_dolzhnost_table">' . $row['litso_dolzhnost'] . '</td><td></td>';
echo '</tr>';
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '13_podrazdelenie_dolzhnost_fio_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="podrazdelenie_filial_table">' . $row['podrazdelenie_filial'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_dolzhnost_table">' . $row['litso_dolzhnost'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_fio">' . $row['litso_fio'] . '</td><td></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '14_podrazdelenie_dolzhnost_fio_telefony_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="podrazdelenie_filial">' . $row['podrazdelenie_filial'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_dolzhnost">' . $row['litso_dolzhnost'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="litso_fio">' . $row['litso_fio'] . '</td><td></td>';
echo '</tr>';
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '15_podrazdelenie_telefony_v_odnoy_stroke') {
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td class="podrazdelenie_filial">' . $row['podrazdelenie_filial'] . '</td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '16_podrazdelenie_telefony_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="podrazdelenie_filial">' . $row['podrazdelenie_filial'] . '</td><td class="tel"></td>';
echo '</tr>';
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '17_rezhim_raboty') {
echo '<tr>';
echo '<td class="rezhimrabotystroka">' . $row['rezhimrabotystroka'] . '</td><td class="tel"></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '18_rezhim_raboty_s_dop_inf_v_raznykh_str_') {
echo '<tr>';
echo '<td class="rezhimrabotystroka">' . $row['rezhimrabotystroka'] . '</td><td></td>';
echo '</tr>';
echo '<tr>';
echo '<td class="dop_informatsiya">' . $row['dop_informatsiya'] . '</td><td></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '19_sayt_') {
$sayt = $row['elpochta_sayt'];
echo '<tr>';
echo '<td class="sayt_">Сайт:</td><td class="sayt"><a class="sayt_a" href="http://' . $sayt . '">' . $sayt . '</a></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '20_tolko_adres') {
$adres = $row['adres'];
echo '<tr>';
echo '<td class="adres_table">' . $row['adres'] . '</td><td></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '21_tolko_podrazdelenie') {
echo '<tr>';
echo '<td class="podrazdelenie_filial">' . $row['podrazdelenie_filial'] . '</td><td></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '22_tolko_telefony') {
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '23_dop_informatsiya') {
echo '<tr>';
echo '<td class="dop_informatsiya">' . $row['dop_informatsiya'] . '</td><td></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '24_fio_telefony_v_raznykh_strokakh') {
echo '<tr>';
echo '<td class="litso_fio">' . $row['litso_fio'] . '</td><td></td>';
echo '</tr>';
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td></td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '25_fio_telefony_v_odnoy_stroke') {
$tel = tel($row['telefony']);
echo '<tr>';
echo '<td class="litso_fio">' . $row['litso_fio'] . '</td><td class="tel">' . $tel . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '25_elpochta') {
$elpochta = $row['elpochta_sayt'];
echo '<tr>';
echo '<td class="elpochta_">Эл.почта:</td><td class="elpochta"><a class="elpochta_a" href="mailto:' . $elpochta . '">' . $elpochta . '</a></td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '26_aska') {
$ICQ = $row['elpochta_sayt'];
echo '<tr>';
echo '<td class="icq_table_">ICQ</td><td class="tel">' . $ICQ . '</td>';
echo '</tr>';
} elseif ($row['format_vyvoda_strok'] == '27_skayp') {
$Skype = $row['elpochta_sayt'];
echo '<tr>';
echo '<td class="skype_table_">Skype</td><td class="tel">' . $Skype . '</td>';
echo '</tr>';
} else {
echo '<tr>';
echo '<td>' . $row['nom_str'] . '</td><td>' . $row['format_vyvoda_strok'] . '</td>';
echo '</tr>';
}
}
//конец цикла по телефонам
echo '</table>';
//echo '<table class="table_tel">';
$q = 'SELECT * FROM sprav_dop WHERE idr ="' . $idsprav . '" ORDER BY id';
$res_mat = mysqli_query($mysqli, $q) or die(mysqli_error($mysqli));
while ($row_mat = mysqli_fetch_assoc($res_mat)) {
echo '' . $row_mat['html_code'];
}
//конец вывода доп.материала if ($mysqli->connect_error) {
echo '</div>';
//'<div class="element">'; //отдельный контейнер по элементам, более узкий, все остальное выводим туда
//добавляем строу навигации справочно
$linknavy = navy_by_alias($mysqli, $aliassprav);
echo '<div style="font-size: 85%; margin: 0px 10px 0px 4px; text-align: right"">' . $linknavy . '</div>';
}
}
