| 1,58 → 1,61 |
|---|
| <?php |
| // ATTENTION ! Classe compatible uniquement avec nouveau format de bdd du cel // |
| |
| // In utf8 |
| // Out utf8 |
| /** |
| * PHP Version 5 |
| * |
| * @category PHP |
| * @package papyrus_bp |
| * @author David Delon <delon@tela-botanica.org> |
| * @copyright 2010 Tela-Botanica |
| * @license http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL |
| * @version SVN: <svn_id> |
| * @link /doc/ |
| */ |
| |
| // Utilitaire mise a jour enregistrement inventaire |
| /** |
| * |
| * Utilitaire mise a jour enregistrement inventaire |
| * A voir avec David mais ne devrait plus être décidé |
| * |
| */ |
| class InventoryCheck extends Cel { |
| |
| |
| Class InventoryCheck extends DBAccessor { |
| |
| |
| var $config; |
| |
| function InventoryCheck($config) { |
| |
| $this->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); |
| return; |
| |
| $requete_obs ="SELECT id_observation, zone_geo, ce_zone_geo, date_observation, ce_utilisateur, courriel_utilisateur FROM cel_obs"; |
| |
| $resultat_obs = $this->requeter($requete_obs); |
| |
| if (DB::isError($res)) { |
| die($res->getMessage()); |
| $observations = array(); |
| if (is_array($resultat_obs)) { |
| $observations = $resultat_obs; |
| } |
| |
| while ($row =& $res->fetchrow(DB_FETCHMODE_ASSOC)) { |
| foreach ($observations as $obs) { |
| |
| 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"; |
| if ($obs['ce_zone_geo']!="000null") { |
| $requete_lieu = "select * from cel_zones_geo where nom = '".mysql_escape_string($obs['zone_geo'])."' and id_zone_geo='".mysql_escape_string($obs['ce_zone_geo'])."' limit 1"; |
| } |
| else { |
| $query="select * from locations where name = '".mysql_escape_string($row['location'])."' limit 1"; |
| $requete_lieu = "select * from cel_zones_geo where name = '".mysql_escape_string($obs['zone_geo'])."' limit 1"; |
| } |
| $resloc =& $DB->query($query); |
| |
| $res_loc = $this->requeter($requete_lieu); |
| |
| if (DB::isError($resloc)) { |
| die($resloc->getMessage()); |
| } |
| if ($resloc->numRows() == 0) { |
| print $row['id']; |
| if (is_array($res_loc) && count($res_loc) > 0) { |
| |
| print $obs['id_observation']; |
| print " "; |
| print $row['identifiant']; |
| print $obs['mail_utilisateur']; |
| print " : "; |
| print $row['location']; |
| print $obs['zone_geo']; |
| print " - "; |
| print $row['id_location']; |
| print $obs['ce_zone_geo']; |
| 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']; |
| $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=".$obs['id_observation']; |
| $link_desc=' <a href="'.$lk.'">Correction</a>'; |
| print $link_desc; |
| print "<br>"; |
| 59,10 → 62,7 |
|---|
| |
| } |
| } |
| |
| } |
| |
| |
| } |
| } |
| |
| /* +--Fin du code ---------------------------------------------------------------------------------------+ |
| 79,5 → 79,4 |
|---|
| * |
| * |
| */ |
| |
| ?> |
| ?> |