if ($_SESSION['wiz_zlec_det'][$row['id']] == 'on') { echo 'checked'; } echo '>' . $row['nazwa'] . '</td></tr>'; } echo ''; } if ($_POST['wiz_wyniki_badan'] || $_SESSION['wiz_skad'] == 'wiz_wyniki_badan') { echo '<tr><td>Wyniki badań</td><td align="left">'; $sql = "select * from sl_badania order by nazwa"; $result = mysql_query($sql); $rodz_bad[10000] = 'Wybierz ..'; while ($row = mysql_fetch_array($result)) { $rodz_bad[$row[0]] = $row[1]; } form_auto_submit_2n('rodz_bad', $rodz_bad, $_SESSION['rodz_bad']); echo '<input type=submit value="Wybierz" name="wyw" class="butt">'; if ($_SESSION['rodz_bad'] != '' || $_SESSION['rodz_bad'] != '10000') { echo '<table>'; $sql = "select * from sl_badania_det where id_bad = " . $_SESSION['rodz_bad']; $result = mysql_query($sql); while ($row = @mysql_fetch_array($result)) { echo '<tr class="linia"><td class="linia">' . $row['nazwa'] . '</td><td><input type=text size=15 name="bad_wyn_jedn[' . $row[1] . ']" value="' . $_SESSION['bad_wyn_jedn'][$_SESSION['rodz_bad']][$row[1]] . '" class="butt2"></td><td class="linia">' . $row['jedn'] . '</td></tr>'; } echo '</table>'; } echo '</td></tr>'; } if ($_POST['wiz_leki'] || $_SESSION['wiz_skad'] == 'wiz_leki') { if ($_SESSION['wyb_lek_id']) { $wyb_id_lek = implode(", ", $_SESSION['wyb_lek_id']);
echo '<form class="fancy" id="fancy" method="post" action="">'; echo '<div id="tabs">'; echo '<ul>'; foreach ($bad_gr as $i => $w) { echo '<li><a href="#' . $i . '"><span>' . $w . '</span></a></li>'; } echo '</ul>'; echo '<br>'; $sql = "select * from sl_firmy"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $sl_f[$row[0]] = $row[1]; } $sl_f[0] = 'Pełnopłatny'; echo ' Płatnik:'; form_auto_submit_2n('platnik', $sl_f); foreach ($bad as $in => $wa) { echo '<div id="' . $in . '">'; echo '<fieldset >'; echo '<legend>' . $bad_gr[$in] . '</legend>'; echo '<ul>'; #echo '<label for="cnaz">'.$bad_gr[$in].'</label>'; foreach ($bad[$in] as $ind => $war) { echo '<li>'; echo '<input id=bad' . $ind . ' type="checkbox" name="bad_lab[' . $ind . ']" value="' . $war . '" />' . $war . '<br/>'; echo '</li>'; } echo '</ul>'; echo '</fieldset>'; echo '</div>'; }
$nrl++; $nr++; } $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('I')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('J')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('K')->setAutoSize(true); $objPHPExcel->getActiveSheet()->setTitle('Darmedicus'); $objPHPExcel->setActiveSheetIndex(0); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('../allianz/allianz' . $_COOKIE['PHPSESSID'] . '.xls'); #koniec excella echo '<a href="../allianz/allianz' . $_COOKIE['PHPSESSID'] . '.xls">Pobierz zestawienie</a>'; } html(); echo '<form method=post action=wydr_allianz.php><table><tr><td>Zestawienie za okres:</td><td>'; form_auto_submit_2n('mies', $data, $_POST['mies']); echo '</td></tr>'; echo '<tr><td>Płatnik:</td><td>'; form_auto_submit_2n('firma', $list_f, $_POST['firma']); echo '</td></tr>'; echo '<tr><td colspan=2><input type="submit" value="Generuj" class="butt2"></td></tr>'; echo '</table></form>'; #zmienne();