← Back
Editing: promozioni_ed.php
<?php ###___###___###___###___###___###___###___###___###___###___###___###___### ### SmaDIB: Smart Database Interface Builder 1.0.b1 ### ### by Smartmedia 2000 http://www.smartmedia2000.it/ ### ### info email: smadib@smartmedia2000.it ### ###___###___###___###___###___###___###___###___###___###___###___###___### require_once ("../funct.php"); require_once ("sess.php"); require_once ("conn.php"); require_once ("class.php"); require_once ($dominio."/param_b.php"); $aa = $_GET['aa'] ? $_GET['aa'] : date ("Y"); $ajCal = "y"; $tipoAr0 = $tipoAr; $tipoAr0[0] = ""; $ptitolo = "Promozioni ".$tipoAr[$_REQUEST[tp]]; $table = "promozioni"; require_once ("testacoda.php"); $urlParam = "?aa=".$aa."&tp=".$tp; $ptitolo.= " per anno ".$aa; $rigaA.= "<table border=\"1\" cellpadding=\"5\" cellspacing=\"0\" align=\"center\"><tr> <td><a href=\"".$_SERVER['PHP_SELF']."?tp=".$tp."&aa=".date ("Y")."\">".date ("Y")."</a></td> <td><a href=\"".$_SERVER['PHP_SELF']."?tp=".$tp."&aa=".(date ("Y")+1)."\">".(date ("Y")+1)."</a></td> </tr></table>\n"; $noEmpty = array ('data_in', 'data_fi', 'notti'); $query = new doQuery(); if ($az=="canc") { $query->delete (); header("Location: ".$_SERVER['PHP_SELF']); } if ($op == "ds") { $query->insert ($_POST, $noEmpty); } else if ($op == "up") { $query->update ($_POST, $noEmpty); } if ($az=="ed") { $row = $query->selectById (0); $id = $row->id; $valop = "up"; } $elenco.= "<tr bgcolor=\"#FFFFFF\"><td valign=\"bottom\" align=\"center\" rowspan=\"5\">funzioni</td> <td colspan=\"2\"><b>Titolo</b></td> <td><b>Sconto</b></td> <td><b>Tipo sc.</b></td> <td><b>Min. notti</b></td> <td><b>Max. notti</b></td> <td><b>limitato a</b></td> </tr> <tr bgcolor=\"#EEEEEE\"> <td colspan=\"2\"><input name=\"titolo\" type=\"text\" size=\"28\" value=\"".$row->titolo."\"></td> <td><input name=\"sconto\" type=\"text\" size=\"6\" maxlenght=\"6,2\" value=\"".$row->sconto."\" /></td> <td>".selList ('tipo_sc', $tipoScontoAr, '', $row->tipo_sc, '', '')."</td> <td><input name=\"min_notti\" type=\"text\" size=\"2\" value=\"".$row->min_notti."\"></td> <td><input name=\"max_notti\" type=\"text\" size=\"2\" value=\"".$row->max_notti."\"></td> <td>".selList ('tipo_strutt', $tipoAr0, '', $row->tipo_strutt, '', '')."</td> </tr> <tr bgcolor=\"#FFFFFF\"> <td><b>Data inizio promoz</b></td> <td><b>Data fine promoz</b></td> <td colspan=\"2\"><b>Data inizio periodo</b></td> <td colspan=\"2\"><b>Data fine periodo</b></td> <td><b></b></td> </tr> <tr bgcolor=\"#EEEEEE\"> <td><input name=\"data_in_pro\" type=\"text\" id=\"data_in_per\" size=\"12\" maxlenght=\"12\" value=\"".date2data ($row->data_in_pro)."\" /></td> <td><input name=\"data_fi_pro\" type=\"text\" id=\"data_fi_per\" size=\"12\" maxlenght=\"12\" value=\"".date2data ($row->data_fi_pro)."\" /></td> <td colspan=\"2\"><input name=\"data_in_per\" type=\"text\" id=\"data_in_pro\" size=\"12\" maxlenght=\"12\" value=\"".date2data ($row->data_in_per)."\" /></td> <td colspan=\"2\"><input name=\"data_fi_per\" type=\"text\" id=\"data_fi_pro\" size=\"12\" maxlenght=\"12\" value=\"".date2data ($row->data_fi_per)."\" /></td> <td></td> </tr><tr bgcolor=\"#FFFFFF\"> <td colspan=\"8\" align=\"center\"> <input type=\"submit\" name=\"invio\" value=\"".$intesta."\" /> <input type=\"hidden\" name=\"tp\" value=\"".$tp."\" /> <input type=\"hidden\" name=\"tipo_sist\" value=\"".$tp."\" /> <input type=\"hidden\" name=\"op\" value=\"".$valop."\" /> <input type=\"hidden\" name=\"id\" value=\"".$row->id."\" /> </td></tr> <tr><td colspan=\"8\" bgcolor=\"#000000\" height=\"1\"></td></tr>\n"; $sql = "SELECT * FROM `".$table."` WHERE `id_utente` = ".ID_UTENTE." AND `tipo_sist` = ".$tp." AND `data_in_per` LIKE '".$aa."-%' ORDER BY 'data_in_pro' ASC, `data_in_per` ASC"; $rows = $query->freeQuery ($sql, 0); foreach ($rows as $i=>$row) { $bgcolor = rowCol ($i); $elenco.= " <tr bgcolor=\"#".$bgcolor."\"><td nowrap rowspan=\"2\">\n"; if ($az!="ed") $elenco.= "<a href=\"".$_SERVER['PHP_SELF']."?id=$row->id&az=ed&pg=$pg\" title=\"modifica riga\"><img src=\"images/edit.gif\" border=\"0\" hspace=\"3\" alt=\"modifica riga\" align=\"absmiddle\" /></a> <a href=\"#\" onClick=\"javascript:confDel($row->id)\" title=\"cancella riga\"><img src=\"images/delete.gif\" border=\"0\" alt=\"cancella riga\" align=\"absmiddle\" /></a> </td>"; $elenco.= " <td colspan=\"2\"><b>".$row->titolo."</b></td> <td>".$row->sconto."</td> <td>".$tipoScontoAr[$row->tipo_sc]."</td> <td>".$row->min_notti."</td> <td>".$row->max_notti."</td> <td>".$tipoAr0[$row->tipo_strutt]."</td> </tr> <tr bgcolor=\"#".$bgcolor."\"> <td>".date2data ($row->data_in_pro)."</td> <td>".date2data ($row->data_fi_pro)."</td> <td colspan=\"2\">".date2data ($row->data_in_per)."</td> <td colspan=\"2\">".date2data ($row->data_fi_per)."</td> <td></td></tr>\n"; } $elenco.= " <tr><td colspan=\"8\" bgcolor=\"#000000\" height=\"1\"></td></tr>\n"; echo $testa; ?> <script type="text/javascript" language="javascript"> <!-- function confDel(id) { if (confirm('Vuoi cancellare veramente questa riga? Premi OK per confermare.')) document.location='<?php echo $_SERVER['PHP_SELF']; ?>?id='+ id +'&az=canc'; } $(function() { $('#data_in_per').datepicker({ changeMonth: true, changeYear: true }); }); $(function() { $('#data_fi_per').datepicker({ changeMonth: true, changeYear: true }); }); $(function() { $('#data_in_pro').datepicker({ changeMonth: true, changeYear: true }); }); $(function() { $('#data_fi_pro').datepicker({ changeMonth: true, changeYear: true }); }); //--> </script> <div align="center"> <form name="form1" method="post" action="<?php echo $_SERVER['PHP_SELF'].$urlParam; ?>"> <h2><?php echo $ptitolo; ?></h2> <?php echo $rigaA; ?> <table align=\"center\"> <?php echo $elenco; ?> </table> </form> <?php echo $coda; ?>
Save File
Cancel