Hotline 6.42

cosmogramme/php/classes/classe_notice_integration.php

@@ -705,34 +705,33 @@ class notice_integration
private function ecrireExemplaires($id_notice) {
global $sql;
-		$unicite_codes_barres=getVariable("unicite_code_barres");
-		if($unicite_codes_barres=="1") $condition_bib="";
-		else $condition_bib=" and id_bib=$id_bib";
-		$id_bib=$this->id_bib;
-		$to_insert=[];
+		$id_bib = $this->id_bib;
+		$to_insert = [];
+		$unicite_codes_barres = getVariable('unicite_code_barres');
+		$condition_bib = ($unicite_codes_barres == '1') ? '' : ' and id_bib=' . $id_bib;
$code_barres = [];
-		foreach($this->notice['exemplaires'] as $ex) {
-			$code_barres []= '\''.$ex['code_barres'].'\'';
-			if($ex["activite"]=="d") continue;
-
-			$data=$ex;
-			$data["id_notice"]=$id_notice;
-			$data["id_bib"]=$id_bib;
-			$data["id_origine"]=$this->notice["id_origine"];
-			$to_insert[]=$data;
+		foreach ($this->notice['exemplaires'] as $ex) {
+			$code_barres []= '\'' . $ex['code_barres'] . '\'';
+			if ($ex["activite"]=="d")
+				continue;
+
+			$data = $ex;
+			$data['id_notice'] = $id_notice;
+			$data['id_bib'] = $id_bib;
+			$data['id_origine'] = $this->notice['id_origine'];
+			$to_insert[] = $data;
}
if (!empty($code_barres))  {
-			$req_delete="delete from exemplaires where id_notice=$id_notice ".$condition_bib." and code_barres in (".implode(',', $code_barres).")";
+			$req_delete = 'delete from exemplaires where id_notice=' . $id_notice . $condition_bib . ' and code_barres in (' . implode(',', $code_barres) . ')';
$sql->execute($req_delete);
}
-		foreach($to_insert as $data) {
-			$sql->insert("exemplaires",$data);
-		}
-		$date_maj=dateDuJour(2);
+		foreach($to_insert as $data)
+			$sql->insert('exemplaires', $data);
+		$date_maj = dateDuJour(2);
$sql->execute("update notices set date_maj='$date_maj' where id_notice=$id_notice");
}