Etiquette : cd

Created by: cplumejeaud

Pour un échantillon, cd doit valoir sample_date (date de prélèvement de l'échantillon) Pour un container, c'est la date de dernier mouvement (permet d'avoir une idée de la "fraîcheur" de l'étiquette).

vi /home/collec/collec-lienss/collec-release-1.2/modules/classes/object.class.php Fonction generateQrcode, ligne 347

sql = "select uid, identifier as id, clp_classification as clp, '' as pn, 'APPLI_code' as db, '' as prj, storage_product as prod, wgs84_x as x, wgs84_y as y, null as cd, null as metadata, null as loc from object join container using (uid) join container_type using (container_type_id) where uid in (uids) UNION select uid, identifier as id, clp_classification as clp, protocol_name as pn, 'APPLI_code' as db, project_name as prj, storage_product as prod, wgs84_x as x, wgs84_y as y, sample_creation_date as cd, metadata::varchar, sampling_place_name as loc from object join sample using (uid) join sample_type using (sample_type_id) join project using (project_id) left outer join sampling_place using (sampling_place_id) left outer join container_type using (container_type_id) left outer join operation using (operation_id) left outer join protocol using (protocol_id) where uid in ($uids) ";

---

Remplacé par

sql = "select uid, identifier as id, clp_classification as clp, '' as pn, 'APPLI_code' as db, '' as prj, storage_product as prod, wgs84_x as x, wgs84_y as y, storage_date as cd, null as metadata, null as loc from object join container using (uid) join container_type using (container_type_id) left outer join last_movement using (uid) where uid in (uids) UNION select uid, identifier as id, clp_classification as clp, protocol_name as pn, 'APPLI_code' as db, project_name as prj, storage_product as prod, wgs84_x as x, wgs84_y as y, sample_date as cd, metadata::varchar, sampling_place_name as loc from object join sample using (uid) join sample_type using (sample_type_id) join project using (project_id) left outer join sampling_place using (sampling_place_id) left outer join container_type using (container_type_id) left outer join operation using (operation_id) left outer join protocol using (protocol_id) where uid in ($uids) ";