config=$config;
}
function getRessource(){
$DB=$this->connectDB($this->config,'database_cel');
// $query="SELECT id, location, id_location, date_observation, identifiant FROM cel_inventory WHERE transmission=1 ";
$query="SELECT id, location, id_location, date_observation, identifiant FROM cel_inventory";
$res =& $DB->query($query);
if (DB::isError($res)) {
die($res->getMessage());
}
while ($row =& $res->fetchrow(DB_FETCHMODE_ASSOC)) {
if ($row['id_location']!="000null") {
$query="select * from locations where name = '".mysql_escape_string($row['location'])."' and code='".mysql_escape_string($row['id_location'])."' limit 1";
}
else {
$query="select * from locations where name = '".mysql_escape_string($row['location'])."' limit 1";
}
$resloc =& $DB->query($query);
if (DB::isError($resloc)) {
die($resloc->getMessage());
}
if ($resloc->numRows() == 0) {
print $row['id'];
print " ";
print $row['identifiant'];
print " : ";
print $row['location'];
print " - ";
print $row['id_location'];
print " - ";
$lk="http://www.tela-botanica.org/cel/jrest/util/cel_inventory.php?PME_sys_fl=0&PME_sys_fm=0&PME_sys_sfn[0]=0&PME_sys_operation=PME_op_Change&PME_sys_rec=".$row['id'];
$link_desc=' Correction';
print $link_desc;
print "
";
}
}
}
}
/* +--Fin du code ---------------------------------------------------------------------------------------+
* $Log$
* Revision 1.2 2008-01-30 08:57:28 ddelon
* fin mise en place mygwt
*
* Revision 1.1 2007-06-06 13:31:16 ddelon
* v0.09
*
* Revision 1.3 2007-05-22 12:54:09 ddelon
* Securisation acces utilisateur
*
*
*
*/
?>