| 1 |
<?php |
| 2 |
// $Id: num_dossier.php,v 1.7 2010-07-27 09:31:00 fraynaud Exp $ |
| 3 |
include ("../dyn/session.inc"); |
| 4 |
include ("../dyn/var.inc"); |
| 5 |
$aff="num_registre"; |
| 6 |
// librairie utilisée ====================================================== |
| 7 |
require_once $path_pear."DB.php"; |
| 8 |
include ("../dyn/connexion.php"); |
| 9 |
// Paramétrage =============================================================== |
| 10 |
$DEBUG=0; |
| 11 |
// GET ======================================================================== |
| 12 |
if (isset ($_GET['validation'])){ |
| 13 |
$validation=$_GET['validation']; |
| 14 |
}else{ |
| 15 |
$validation=0; |
| 16 |
} |
| 17 |
if (isset ($_GET['idx'])){ |
| 18 |
$idx=$_GET['idx']; |
| 19 |
}else{ |
| 20 |
$idx=0; |
| 21 |
} |
| 22 |
echo "<html>"; |
| 23 |
include("../dyn/var.inc"); |
| 24 |
include("../scr/lang.inc"); |
| 25 |
echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n"; |
| 26 |
echo "<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"fr\" lang=\"fr\">\n"; |
| 27 |
echo "\t<head>\n"; |
| 28 |
echo "\t\t<meta http-equiv=\"Content-Type\" content=\"text/html;charset=iso-8859-1\" />\n"; |
| 29 |
echo "\t\t<title>".lang("title_html")."</title>\n"; |
| 30 |
echo "\t\t<link rel=\"stylesheet\" type=\"text/css\" media=\"screen\" href=\"../dyn/style.css\" />\n"; |
| 31 |
echo "\t\t<link rel=\"stylesheet\" type=\"text/css\" media=\"print\" href=\"../dyn/print.css\" />\n"; |
| 32 |
echo "\t\t<script type=\"text/javascript\" src=\"../dyn/script.js\"></script>\n"; |
| 33 |
echo "\t\t<link rel=\"stylesheet\" type=\"text/css\" href=\"../dyn/menu.css\" />\n"; |
| 34 |
echo "\t\t<script type=\"text/javascript\" src=\"../dyn/menu.js\"></script>\n"; |
| 35 |
echo "\t</head>\n"; |
| 36 |
echo "\t<body class='dossier'>\n"; |
| 37 |
// connexion |
| 38 |
$db=& DB :: connect($dsn, $db_option); |
| 39 |
if (DB :: isError($db)) { |
| 40 |
die($db->getMessage()); |
| 41 |
}else{ |
| 42 |
if($DEBUG==1) |
| 43 |
echo "la base ".$dsn['database']." est connectée<br>"; |
| 44 |
// variables collectivites |
| 45 |
$sql = "SELECT * from collectivite "; |
| 46 |
$res = $db->query($sql); |
| 47 |
if (DB :: isError($res)) |
| 48 |
die($res->getMessage()."erreur ".$sql); |
| 49 |
else{ |
| 50 |
while ($row=& $res->fetchRow()){ |
| 51 |
$ville=$row[0]; |
| 52 |
$logo=$row[1]; |
| 53 |
}} |
| 54 |
$res->free(); |
| 55 |
// variable droit |
| 56 |
$sql = "SELECT profil from droit where droit= '".$aff."'"; |
| 57 |
$droit =$db->getOne($sql); |
| 58 |
echo "\n<div id=\"content\">\n"; |
| 59 |
echo "<table class='dossier' width='95%'>"; |
| 60 |
echo "<tr class='dossier_entete'><td colspan='2'>".lang("remise_a_0")." ".lang("num_registre")."<td align='right'><a href='javascript:aide()'><img src='../img/ico_traitement.png' align='top' hspace='5' border='0' alt='aide'><img src='../img/ico_aide.png' align='top' hspace='5' border='0' alt='aide'>"; |
| 61 |
echo "</a></td></tr></table>"; |
| 62 |
// ============================================================================= |
| 63 |
// validation = 0 |
| 64 |
// ============================================================================= |
| 65 |
if($validation==0){ |
| 66 |
$validation=1; |
| 67 |
echo "<table class='dossier' width='95%'>"; |
| 68 |
echo "<tr class='dossier'><td colspan=2><br><center>"; |
| 69 |
if($numero_unique==1){ |
| 70 |
// numero unique |
| 71 |
$sql1="select id from dossier_seq"; |
| 72 |
$res1=$db->getOne($sql1); |
| 73 |
if (!is_numeric($res1)) $res1=0; |
| 74 |
if ($res1!=0){ |
| 75 |
echo "<br><font size='2'>".lang('dernier_numero')." ".lang('dossier')." : ".$res1."<br>(".lang('depuis_derniere')." ".lang("remise_a_0").")</font><BR><BR></td></tr>"; |
| 76 |
}else{ |
| 77 |
echo "<br><font size='2'>".lang('sans_saisie_depuis')." ". |
| 78 |
lang('dossier')."</font></td></tr>"; |
| 79 |
} |
| 80 |
}else{ |
| 81 |
// numero suivant nature |
| 82 |
$sql1="select id from dossier_pc_seq"; |
| 83 |
$res1=$db->getOne($sql1); |
| 84 |
if (!is_numeric($res1)) $res1=0; |
| 85 |
if ($res1!=0){ |
| 86 |
echo "<br><font size='2'>".lang('dernier_numero')." ".lang('PC*')." : ".$res1." <br>(".lang('depuis_derniere')." ".lang("remise_a_0").")</font><BR><BR>"; |
| 87 |
}else{ |
| 88 |
echo "<br><font size='2'>".lang('sans_saisie_de')." ".lang('PC*')." ".lang('depuis').".</font><BR><BR>"; |
| 89 |
} |
| 90 |
$sql2="select id from dossier_pd_seq"; |
| 91 |
$res2=$db->getOne($sql2); |
| 92 |
if (!is_numeric($res2)) $res2=0; |
| 93 |
if ($res2!=0){ |
| 94 |
echo "<br><font size='2'>".lang('dernier_numero')." ".lang('PD*')." : ".$res2." <br>(".lang('depuis_derniere')." ".lang("remise_a_0").")</font><br><br>"; |
| 95 |
}else{ |
| 96 |
echo "<br><font size='2'>".lang('sans_saisie_de')." ".lang('PD*')." ".lang('depuis').".</font><BR><BR>"; |
| 97 |
} |
| 98 |
$sql3="select id from dossier_pa_seq"; |
| 99 |
$res3=$db->getOne($sql3); |
| 100 |
if (!is_numeric($res3)) $res3=0; |
| 101 |
if ($res3!=0){ |
| 102 |
echo "<br><font size='2'>".lang('dernier_numero')." ".lang('PA*')." : ".$res3." <br>(".lang('depuis_derniere')." ".lang("remise_a_0").")</font><BR><BR>"; |
| 103 |
}else{ |
| 104 |
echo "<br><font size='2'>".lang('sans_saisie_de')." ".lang('PA*')." ".lang('depuis').".</font><BR><BR>"; |
| 105 |
} |
| 106 |
$sql4="select id from dossier_dp_seq"; |
| 107 |
$res4=$db->getOne($sql4); |
| 108 |
if (!is_numeric($res4)) $res4=0; |
| 109 |
if ($res4!=0){ |
| 110 |
echo "<br><font size='2'>".lang('dernier_numero')." ".lang('DP*')." : ".$res4." <br>(".lang('depuis_derniere')." ".lang("remise_a_0").")</font><BR><BR>"; |
| 111 |
}else{ |
| 112 |
echo "<br><font size='2'>".lang('sans_saisie_de')." ".lang('DP*')." ".lang('depuis').".</font><BR><BR>"; |
| 113 |
} |
| 114 |
$sql5="select id from dossier_cu_seq"; |
| 115 |
$res5=$db->getOne($sql5); |
| 116 |
if (!is_numeric($res5)) $res5=0; |
| 117 |
if ($res5!=0){ |
| 118 |
echo "<br><font size='2'>".lang('dernier_numero')." ".lang('CU*')." : ".$res5." ''<br>(".lang('depuis_derniere')." ".lang("remise_a_0").")</font><BR><BR></td></tr>"; |
| 119 |
}else{ |
| 120 |
echo "<br><font size='2'>".lang('sans_saisie_de')." ".lang('CU*')." ".lang('depuis').".</font><BR><BR></td></tr>"; |
| 121 |
} |
| 122 |
} |
| 123 |
echo "<form method=\"POST\" action=\"num_dossier.php?validation=".$validation."\" name=f1>"; |
| 124 |
// date exhumation |
| 125 |
?> |
| 126 |
<script language="javascript"> |
| 127 |
var pfenetre; |
| 128 |
var fenetreouverte=false; |
| 129 |
|
| 130 |
function aide() |
| 131 |
{ |
| 132 |
if(fenetreouverte==true) |
| 133 |
pfenetre.close(); |
| 134 |
pfenetre=window.open("../doc/<?php echo $langue;?>/num_dossier.html","Aide","toolbar=no,scrollbars=yes,status=no, width=600,height=400,top=120,left=120"); |
| 135 |
fenetreouverte=true; |
| 136 |
} |
| 137 |
</script> |
| 138 |
<?php |
| 139 |
If ($_SESSION['profil'] >= $droit){ |
| 140 |
echo "<tr class='tabcol'><td colspan=2><br><center>"; |
| 141 |
echo "<input type='submit' value='".lang("remise_a_0")."' style=".$styleBouton.">"; |
| 142 |
}else |
| 143 |
echo "<tr><td colspan=2><center>".lang("droit_insufisant"); |
| 144 |
echo "</form>"; |
| 145 |
echo "</td></tr>"; |
| 146 |
echo "</table>"; |
| 147 |
}else { // ===================== mise a jour ================================= |
| 148 |
$valF=array(); |
| 149 |
$correct=true; |
| 150 |
if ($correct==true){ |
| 151 |
echo "<br><br>"; |
| 152 |
$valF['id']=0; |
| 153 |
if($numero_unique==1){ |
| 154 |
$res1= $db->autoExecute("dossier_seq",$valF,DB_AUTOQUERY_UPDATE); |
| 155 |
if (DB :: isError($res1)){ |
| 156 |
echo $res1->getDebugInfo()." ".$res1->getMessage()."<br>"; |
| 157 |
}else{ |
| 158 |
echo "<center><font size='2'><b>".lang("remise_a_0_compteur")." ".lang("reussie")." - ".lang("le_prochain")." ".lang("dossier")." ".lang("portera_no_1")."</b></font>"; |
| 159 |
} |
| 160 |
}else{ // pas de numero unique |
| 161 |
$res1= $db->autoExecute("dossier_PC_seq",$valF,DB_AUTOQUERY_UPDATE); |
| 162 |
if (DB :: isError($res1)){ |
| 163 |
echo "<br>".$res1->getDebugInfo()." ".$res1->getMessage()."<br>"; |
| 164 |
}else{ |
| 165 |
echo "<center><font size='2'><b>".lang("remise_a_0_compteur")." ".lang("reussie")." - ".lang("le_prochain")." ".lang("PC*")." ".lang("portera_no_1")."</b></font>"; |
| 166 |
} |
| 167 |
$res2= $db->autoExecute("dossier_PD_seq",$valF,DB_AUTOQUERY_UPDATE); |
| 168 |
if (DB :: isError($res2)){ |
| 169 |
echo "<br>".$res2->getDebugInfo()." ".$res2->getMessage()."<br>"; |
| 170 |
}else{ |
| 171 |
echo "<center><font size='2'><b>".lang("remise_a_0_compteur")." ".lang("reussie")." - ".lang("le_prochain")." ".lang("PD*")." ".lang("portera_no_1")."</b></font>"; |
| 172 |
} |
| 173 |
$res3= $db->autoExecute("dossier_PA_seq",$valF,DB_AUTOQUERY_UPDATE); |
| 174 |
if (DB :: isError($res3)){ |
| 175 |
echo "<br>".$res3->getDebugInfo()." ".$res3->getMessage()."<br>"; |
| 176 |
}else{ |
| 177 |
echo "<center><font size='2'><b>".lang("remise_a_0_compteur")." ".lang("reussie")." - ".lang("le_prochain")." ".lang("PA*")." ".lang("portera_no_1")."</b></font>"; |
| 178 |
} |
| 179 |
$res4= $db->autoExecute("dossier_DP_seq",$valF,DB_AUTOQUERY_UPDATE); |
| 180 |
if (DB :: isError($res4)){ |
| 181 |
echo "<br>".$res4->getDebugInfo()." ".$res4->getMessage()."<br>"; |
| 182 |
}else{ |
| 183 |
echo "<center><font size='2'><b>".lang("remise_a_0_compteur")." ".lang("reussie")." - ".lang("le_prochain")." ".lang("DP*")." ".lang("portera_no_1")."</b></font>"; |
| 184 |
} |
| 185 |
$res5= $db->autoExecute("dossier_CU_seq",$valF,DB_AUTOQUERY_UPDATE); |
| 186 |
if (DB :: isError($res5)){ |
| 187 |
echo "<br>".$res5->getDebugInfo()." ".$res5->getMessage()."<br>"; |
| 188 |
}else{ |
| 189 |
echo "<center><font size='2'><b>".lang("remise_a_0_compteur")." ".lang("reussie")." - ".lang("le_prochain")." ".lang("CU*")." ".lang("portera_no_1")."</b></font>"; |
| 190 |
|
| 191 |
} |
| 192 |
} |
| 193 |
echo "<br><br><a href='../trt/num_dossier.php'>"; |
| 194 |
echo"<img src='../img/retour.png' align='top' border='0'>"; |
| 195 |
echo "</a></center>"; |
| 196 |
} |
| 197 |
}//validation |
| 198 |
// deconnexion de la base |
| 199 |
echo "</div>"; |
| 200 |
echo "<a class='lientable' href='#' onclick='window.close();'>"; |
| 201 |
echo "<br><br><center><img src='../img/fermer_fenetre.gif' align='middle' alt='".lang("fermer")."' title='".lang("fermer")."' hspace='5' border='0'>"; |
| 202 |
echo "</center></a>"; |
| 203 |
$db->disconnect(); |
| 204 |
if ($DEBUG == 1) |
| 205 |
echo "la base ".$dsn['database']." est déconnectée<br>"; |
| 206 |
} |
| 207 |
//include ("../dyn/menu.inc"); |
| 208 |
echo "</body>"; |
| 209 |
?> |
Parent Directory
| 
Revision Log