← Back
Editing: stagioni_ed.php
<?php #______________________________________________________________________# ### made with SmaDIB: Smart Database Interface Builder 0.4.0 ### ### by Smartmedia 2000 http://www.smartmedia2000.it/ ### ### info email: smadib@smartmedia2000.it ### ### released under GPL license http://www.gnu.org/licenses/gpl.txt ### ###___###___###___###___###____###____###____###___###___###___###___### require_once ("../funct.php"); require_once ("sess.php"); require_once ("conn.php"); $ptitolo = "Gestione Listini"; $table = "stagioni"; $html = "y"; $ajCal = "y"; require_once ("testacoda.php"); $novuoto = array ('anno', 'fine', 'numero'); $dateFlds = array ('fine'); $query = new doQuery(); $numeroar = array ('','Prezzo unico','2 Periodi','3 Periodi','4 Periodi','5 Periodi','6 Periodi','7 Periodi','8 Periodi','9 Periodi','10 Periodi','Min - Max','Bassa/Alta','Bassa/Media/Alta','Bassa/Media/Alta/Altissima'); if ($az == "canc") { $query->freeQuery ("DELETE FROM `prezzi` WHERE `id_stagione` = '$id'", 0); $query->freeQuery ("DELETE FROM `periodi` WHERE `id_stagione` = '$id'", 0); $query->delete (); header ("Location: ".$_SERVER['PHP_SELF']); } if ($op == "ds") { $query->insert ($_POST, $novuoto); header ("Location: ".$_SERVER['PHP_SELF']); } else if ($op == "up") $query->update ($_POST, $novuoto); else if ($op == "upp") { $query->update ($_POST, $novuoto); header ("Location: prezzi_ed.php"); } else if ($op == "upme") { $table = "meta"; $query->update ($_POST, array ()); $table = "stagioni"; } if ($az == "ed" || $az == "edp" || $az == "edn") { $row = $query->selectById(1, $conn); $id = $row['id']; $valop = "up"; $anno = $row['anno']; $numero = $row['numero']; $numerosel[$numero] = "selected"; $fine = date2data($row['fine']); } else $valop = "ds"; # metodo per tornare ai prezzi if ($az == "edp" || $az == "edn") { $valop = "upp"; $intesta = "Modifica"; $noMod = $noModP; } $rowM = $query->freeQuery ("SELECT * FROM `meta` WHERE `id_utente` = ".$id_utente, 1); # modificare informazioni aggiuntive, o note. i campi nascosti ci vogliono per il novuoto if ($az == "edn") { for ($i=0; $i<count($lingue); $i++) { $k = array_search ($lingue[$i], $sigLng); $elenco.= "<tr><td><b>Informazioni aggiuntive ".$nomiLng[$lingue[$i]]."</b></td></tr> <tr><td><textarea class=\"fullhtml\" name=\"testo_".$lingue[$i]."\" type=\"text\" rows=\"8\" cols=\"80\">".$row[($k*2)+6]."</textarea> <input name=\"fine\" type=\"hidden\" value=\"$fine\"> <input name=\"anno\" type=\"hidden\" value=\"$anno\"> <input name=\"numero\" type=\"hidden\" value=\"$numero\"> </td></tr>\n"; } } # modificare il resto else { $elenco.= "<tr bgcolor=\"#FFFFFF\"> <td><b>Anno listino</b></td> <td><b>Fine visualizzazione</b></td> <td><b>Periodi</b></td> </tr><tr> <td><select name=\"anno\"><option value=\"".$row['anno']."\">".$row['anno']."</option>\n"; for ($i=date("Y"); $i<date("Y")+3; $i++) $elenco.= "<option value=\"$i\">$i</option>\n"; $elenco.= "</select></td> <td><input name=\"fine\" id=\"fine\" type=\"text\" size=\"10\" maxlenght=\"\" value=\"$fine\"></td> <td><select name=\"numero\"><option value=\"0\" $numerosel[0]>$numeroar[0]</option><option value=\"1\" $numerosel[1]>$numeroar[1]</option><option value=\"2\" $numerosel[2]>$numeroar[2]</option><option value=\"3\" $numerosel[3]>$numeroar[3]</option><option value=\"4\" $numerosel[4]>$numeroar[4]</option><option value=\"5\" $numerosel[5]>$numeroar[5]</option><option value=\"6\" $numerosel[6]>$numeroar[6]</option><option value=\"7\" $numerosel[7]>$numeroar[7]</option><option value=\"8\" $numerosel[8]>$numeroar[8]</option><option value=\"9\" $numerosel[9]>$numeroar[9]</option><option value=\"10\" $numerosel[10]>$numeroar[10]</option><option value=\"11\" $numerosel[11]>$numeroar[11]</option><option value=\"12\" $numerosel[12]>$numeroar[12]</option><option value=\"13\" $numerosel[13]>$numeroar[13]</option><option value=\"14\" $numerosel[14]>$numeroar[14]</option></select></td>\n"; for ($i=0; $i<count($lingue); $i++) { $k = array_search ($lingue[$i], $sigLng); $elenco.= "<tr><td colspan=\"3\"><b>Nome listino".$nomiLng[$lingue[$i]]."</b></td></tr> <tr><td colspan=\"3\"><input name=\"nome_".$lingue[$i]."\" type=\"text\" size=\"40\" maxlenght=\"50\" value=\"".$row[($k*2)+5]."\"></td></tr>\n"; $elencoMeta.= "<table align=\"center\" width=\"400\"> <tr bgcolor=\"#FFFFFF\"> <td>Titolo ".$nomiLng[$lingue[$i]]." (max 60 caratteri)<br /> <input type=\"text\" name=\"titlprezz_".$lingue[$i]."\" value=\"".$rowM[0]['titlprezz_'.$lingue[$i]]."\" size=\"80\" maxlength=\"60\" /></td> </tr><tr bgcolor=\"#FFFFFF\"> <td>Descrizione ".$nomiLng[$lingue[$i]]." (max 160 caratteri)<br /> <textarea name=\"descprezz_".$lingue[$i]."\" id=\"desc\" rows=\"2\" cols=\"80\">".$rowM[0]['descprezz_'.$lingue[$i]]."</textarea></td> </tr><tr bgcolor=\"#FFFFFF\"> <td>Parole chiave o frasi separate dalla virgola ".$nomiLng[$lingue[$i]]." (max 150 caratteri)<br /> <textarea name=\"keywprezz_".$lingue[$i]."\" id=\"keyw\" rows=\"2\" cols=\"80\">".$rowM[0]['keywprezz_'.$lingue[$i]]."</textarea></td> </tr></table><br />\n"; } } $elenco.= "<tr><td colspan=\"4\"><div align=\"center\"> <input type=\"hidden\" name=\"op\" value=\"$valop\"> <input type=\"hidden\" name=\"id\" value=\"$id\"> <input type=\"submit\" name=\"invio\" value=\"$intesta\"> $noMod </div></td></tr></table> <table align=\"center\">\n"; if ($az != "edp" && $az != "edn") { $elenco.= "<tr><td> </td> <td><b>Anno listino</b></td> <td><b>Nome listino</b></td> <td><b>Fine visualizzazione</b></td> <td><b>Periodi</b></td></tr>\n"; $cc = 0; $rows = $query->selectAll ($table, array('anno'=>'DESC', 'id'=>'DESC'), 0); foreach ($rows AS $i=>$row) { $cc++; $colriga = colriga ($cc); $elenco.= "<tr bgcolor=\"#$colriga\"><td nowrap>\n"; if ($az!="ed") $elenco.= "<a href=\"".$_SERVER['PHP_SELF']."?id=".$row->id."&az=ed\" title=\"modifica listino\"><img src=\"images/edit.gif\" border=\"0\" hspace=\"5\" alt=\"modifica listino\" /></a> <a href=\"#\" onClick=\"javascript:confDel(".$row->id.")\" title=\"cancella intero listino con periodi e prezzi\"><img src=\"images/delete.gif\" border=\"0\" alt=\"cancella intero listino con periodi e prezzi\" /></a>\n"; $elenco.= " </td><td>".$row->anno."</td><td>".$row->nome_it."</td><td>".date2data ($row->fine)."</td><td>".$numeroar[$row->numero]."</td></tr>\n"; } } echo $testa; ?> <script type="text/javascript"> $(function() { $('#fine').datepicker({ changeMonth: true, changeYear: true }); }); </script> <h2><div align="center"><?php echo $ptitolo; ?></div></h2> <form name="form1" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <table align="center"> <?php echo $elenco; ?> </table> </form> <?php if ($az != "ed" && $az != "edp"&& $az != "edn") { ?> <hr> <h2><div align="center">SEO - ottimizzazione motori di ricerca</div></h2> <form name="form2" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <?php echo $elencoMeta; ?> <div align="center"> <input type="submit" name="invio" value="Salva meta" /> <input type="hidden" name="id" value="<?php echo $rowM[0]['id']; ?>" /> <input type="hidden" name="op" value="upme" /> </div></form> <?php } echo $coda; ?>
Save File
Cancel