← Back
Editing: mappa_camp.php
<?php ###___###___###___###___###___###___###___###___###___###___###___###___### ### SmaDIB: Smart Database Interface Builder 0.6.0.1 ### ### by Smartmedia 2000 http://www.smartmedia2000.it/ ### ### info email: smadib@smartmedia2000.it ### ###___###___###___###___###___###___###___###___###___###___###___###___### require_once ("../funct.php"); require_once ("sess.php"); require_once ("conn.php"); $ptitolo = "Mappa ".$tipoAr[$_REQUEST[$tp]]; $data = $_REQUEST['data'] ? $_REQUEST['data'] : date ("d/m/Y"); $ajCal = "y"; require_once ("testacoda.php"); $query = new doQuery(); require_once ($dominio."/mappa.php"); foreach ($arMappa as $tr) { $mappa.= "<tr>"; foreach ($tr as $td) { if (substr ($td, 0, 3) == "td=") { # celle di piazzole $nome = substr ($td, 3); $sqlC = "SELECT `contratti`.`id`, `numero`, `piazzola`, `contratti`.`stato`, `contratti`.`data_in`, `contratti`.`data_out`, DATE_FORMAT(`contratti`.`data_scad`, '%d/%m') AS `data_scad`, `cognome`, `persone`.`nome`, `persone`, `adulti`, `bambini`, `neonati`, `cani0`, `cani1`, `cani2`, `tipo_strutt`, `caratt_strutt` FROM `sistemazioni`, ".$wc2p." AND `sistemazioni`.`nome` = '".$nome."' AND `id_sistemaz` = `sistemazioni`.`id` AND `contratti`.`data_in` <= '".data2date ($data)."' AND `contratti`.`data_out` >= '".data2date ($data)."' AND (`presenze`.`tipo_pers` = 1 OR `presenze`.`tipo_pers` = 2) AND (`contratti`.`stato` = 6 OR `contratti`.`stato` = 7 OR `contratti`.`stato` = 16 OR `contratti`.`stato` = 17) ORDER BY `contratti`.`data_in`"; $rowC = $query->freeQuery ($sqlC, 0); $st = $rowC[0]->stato ? $rowC[0]->stato : 0; # segna diverso l'ultimo giorno if ($rowC[0]->data_out == data2date ($data)) $st.= "U"; if ($rowC[0]->id) $mappa.= "<td class=\"st".$st."\"><a href=\"contratti_ed.php?tp=".$tp."&st=".$st."&id=".$rowC[0]->id."&az=ed\" title=\"".$rowC[0]->numero." ".$rowC[0]->cognome." ".$rowC[0]->nome."\">".$nome."</a></td>\n"; else { $mappa.= "<td class=\"st".$st."\">".$nome."</td>\n"; } } else { # altre celle $mappa.= $td."</td>";; } } $mappa.= "</tr>\n"; } $legenda = "<table align=\"center\" border><tr>"; foreach ($coloriSt as $st=>$col) $legenda.= "<td bgcolor=\"$col\">".$statoAr[$st]."</td>"; $legenda.= "</tr></table>"; echo $testa; ?> <style type="text/css"> <?php echo $stile; ?> </style> <script type="text/javascript" language="javascript"> <!-- $(function() { $('#data').datepicker({ changeMonth: true, changeYear: true }); }); //--> </script> <form name="form1" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <h2 align="center"><?php echo $ptitolo." ".$tipoAr[$tp]; ?> del <input type="text" id="data" name="data" value="<?php echo $data; ?>" size="12" onchange="javascript:document.form1.submit()" /></h2> <input type="hidden" name="tp" value="<?php echo $tp; ?>" /> </form> <?php echo $legenda; ?></div> <table align="center" border="1" cellpadding="5"> <?php echo $mappa; ?> </table> <?php echo $coda; ?>
Save File
Cancel