$values .= ", expl_statut='{$expl_statut}'";
$values .= ", expl_location='{$expl_location}' {$transfert_origine} ";
$values .= ", expl_codestat='{$expl_codestat}'";
$values .= ", expl_note='{$expl_note}'";
$values .= ", expl_comment='{$expl_comment}'";
$values .= ", expl_prix='{$expl_prix}'";
$values .= ", expl_owner='{$expl_owner}'";
$values .= ", type_antivol='{$type_antivol}'";
$values .= ", expl_nbparts='{$f_ex_nbparts}'";
$requete = "INSERT INTO exemplaires set {$values} , create_date=sysdate() ";
$myQuery = pmb_mysql_query($requete, $dbh);
$expl_id = pmb_mysql_insert_id();
audit::insert_creation(AUDIT_EXPL, $expl_id);
}
if ($abt_id && $serial_circ_add) {
$serialcirc_diff = new serialcirc_diff(0, $abt_id);
}
// Si c'est à faire circuler
if ($serialcirc_diff->id) {
$serialcirc_diff->add_circ_expl($expl_id);
}
// traitement des concepts
if ($thesaurus_concepts_active == 1) {
$index_concept = new index_concept($expl_id, TYPE_EXPL);
$index_concept->save();
}
//Insertion des champs personalises
$p_perso->rec_fields_perso($expl_id);
// Mise a jour de la table notices_mots_global_index pour toutes les notices en relation avec l'exemplaire
$req_maj = "SELECT bulletin_notice,num_notice, analysis_notice FROM bulletins LEFT JOIN analysis ON analysis_bulletin=bulletin_id WHERE bulletin_id='" . $expl_bulletin . "'";
$res_maj = pmb_mysql_query($req_maj);
require_once "{$class_path}/serialcirc_diff.class.php";
switch ($sub) {
case 'option_form':
$serialcirc_diff = new serialcirc_diff($id_serialcirc, $num_abt);
ajax_http_send_response($serialcirc_diff->option_form());
break;
case 'ficheformat_form':
$serialcirc_diff = new serialcirc_diff($id_serialcirc, $num_abt);
ajax_http_send_response($serialcirc_diff->ficheformat_form());
break;
case 'empr_form':
$serialcirc_diff = new serialcirc_diff($id_serialcirc, $num_abt);
ajax_http_send_response($serialcirc_diff->empr_form($id_diff));
break;
case 'group_form':
$serialcirc_diff = new serialcirc_diff($id_serialcirc, $num_abt);
ajax_http_send_response($serialcirc_diff->group_form($id_diff));
break;
case 'up_order_circdiff':
serialcirc_diff::up_order_circdiff($tablo);
break;
case 'up_order_circdiffprint':
serialcirc_diff::up_order_circdiffprint($id_serialcirc, $tablo);
break;
case 'up_order_circdiffgroupdrop':
serialcirc_diff::up_order_circdiffgroupdrop($tablo);
break;
case 'get_caddie':
ajax_http_send_response(serialcirc_diff::get_caddie($id_caddie));
break;
}
<?php
// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: serialcirc_diff.inc.php,v 1.10 2015-08-12 09:02:17 ngantier Exp $
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) {
die("no access");
}
require_once "{$class_path}/serialcirc_diff.class.php";
$serialcirc_diff = new serialcirc_diff($id_serialcirc, $num_abt);
switch ($sub) {
case 'option_form':
if ($action == 'save') {
$data['circ_type'] = $circ_type;
// rotative ou étoile
$data['virtual_circ'] = $virtual_circ;
// virtuelle
$data['simple_circ'] = $simple_circ;
// simplifiée
$data['no_ret_circ'] = $no_ret_circ;
$data['duration'] = $duration;
$data['checked'] = $checked;
$data['retard_mode'] = $retard_mode;
$data['allow_resa'] = $allow_resa;
$data['allow_copy'] = $allow_copy;
$data['allow_send_ask'] = $allow_send_ask;
$data['duration_before_send'] = $duration_before_send;
$data['allow_subscription'] = $allow_subscription;
$data['expl_statut_circ'] = $expl_statut_circ;
$data['expl_statut_circ_after'] = $expl_statut_circ_after;
<?php
// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: serialcirc_ask_ajax.inc.php,v 1.1 2011-11-22 14:48:59 ngantier Exp $
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) {
die("no access");
}
require_once "{$class_path}/serialcirc_diff.class.php";
switch ($sub) {
case '':
$serialcirc_diff = new serialcirc_diff($id_serialcirc, $num_abt);
ajax_http_send_response($serialcirc_diff->option_form());
break;
}
function delete()
{
global $dbh;
global $msg;
global $include_path;
// l'abonnement a encore au moins un expl en circulation
if (serialcirc_diff::expl_in_circ($this->abt_id)) {
return $msg['serialcirc_error_delete_abt'];
}
$dummy = "delete FROM abts_abts WHERE abt_id='{$this->abt_id}' ";
$check = mysql_query($dummy, $dbh);
$dummy = "delete FROM abts_grille_abt WHERE num_abt='{$this->abt_id}' ";
$check = mysql_query($dummy, $dbh);
$dummy = "delete FROM abts_abts_modeles WHERE abt_id='{$this->abt_id}' ";
$check = mysql_query($dummy, $dbh);
abts_pointage::delete_retard($this->abt_id);
serialcirc_diff::delete($this->abt_id);
return "";
}
function duplicate($abt_to_id)
{
global $dbh;
$requete = "select id_serialcirc from serialcirc where num_serialcirc_abt=" . $abt_to_id;
$resultat = pmb_mysql_query($requete);
if (pmb_mysql_num_rows($resultat)) {
$status = serialcirc_diff::delete($abt_to_id);
if ($status) {
return $status;
}
// error
}
$req = "INSERT INTO serialcirc SET\r\n\t\t\tnum_serialcirc_abt=" . $abt_to_id . ",\r\n\t\t\tserialcirc_type=" . $this->circ_type . ",\r\n\t\t\tserialcirc_virtual=" . $this->virtual_circ . ",\n\t\t\tserialcirc_simple=" . $this->simple_circ . ",\r\n\t\t\tserialcirc_no_ret=" . $this->no_ret_circ . ",\r\n\t\t\tserialcirc_duration=" . $this->duration . ",\r\n\t\t\tserialcirc_checked=" . $this->checked . ",\r\n\t\t\tserialcirc_retard_mode=" . $this->retard_mode . ",\r\n\t\t\tserialcirc_allow_resa=" . $this->allow_resa . ",\r\n\t\t\tserialcirc_allow_copy=" . $this->allow_copy . ",\r\n\t\t\tserialcirc_allow_send_ask=" . $this->allow_send_ask . ",\r\n\t\t\tserialcirc_allow_subscription=" . $this->allow_subscription . ",\r\n\t\t\tserialcirc_duration_before_send=" . $this->duration_before_send . ",\r\n\t\t\tserialcirc_expl_statut_circ=" . $this->expl_statut_circ . ",\n\t\t\tserialcirc_piedpage='" . $this->piedpage . "',\n\t\t\tserialcirc_tpl='" . $this->tpl . "',\r\n\t\t\tserialcirc_expl_statut_circ_after=" . $this->expl_statut_circ_after . "\r\n\t\t\t";
pmb_mysql_query($req, $dbh);
$new_serialcirc_id = pmb_mysql_insert_id($dbh);
$requete = "select * from serialcirc_diff where num_serialcirc_diff_serialcirc=" . $this->id . " order by serialcirc_diff_order";
$res_empr = pmb_mysql_query($requete);
while ($r_empr = pmb_mysql_fetch_object($res_empr)) {
$req = "INSERT INTO serialcirc_diff SET\n\t\t\t\tnum_serialcirc_diff_serialcirc=" . $new_serialcirc_id . ",\n\t\t\t\tserialcirc_diff_empr_type='" . $r_empr->serialcirc_diff_empr_type . "',\n\t\t\t\tserialcirc_diff_type_diff='" . $r_empr->serialcirc_diff_type_diff . "',\n\t\t\t\tnum_serialcirc_diff_empr='" . $r_empr->num_serialcirc_diff_empr . "',\n\t\t\t\tserialcirc_diff_group_name='" . $r_empr->serialcirc_diff_group_name . "',\n\t\t\t\tserialcirc_diff_duration='" . $r_empr->serialcirc_diff_duration . "',\n\t\t\t\tserialcirc_diff_order=" . $r_empr->serialcirc_diff_order . "\t\t\t\n\t\t\t";
pmb_mysql_query($req, $dbh);
$new_id_serialcirc_diff = pmb_mysql_insert_id($dbh);
$requete = "select * from serialcirc_group where num_serialcirc_group_diff=" . $r_empr->id_serialcirc_diff;
$res_group = pmb_mysql_query($requete);
while ($r_group = pmb_mysql_fetch_object($res_group)) {
$req = "INSERT INTO serialcirc_group SET\n\t\t\t\t\tnum_serialcirc_group_diff=" . $new_id_serialcirc_diff . ",\n\t\t\t\t\tnum_serialcirc_group_empr='" . $r_group->num_serialcirc_group_empr . "',\n\t\t\t\t\tserialcirc_group_responsable='" . $r_group->serialcirc_group_responsable . "',\n\t\t\t\t\tserialcirc_group_order='" . $r_group->serialcirc_group_order . "'\n\t\t\t\t";
pmb_mysql_query($req, $dbh);
}
}
}
function delete($num_abt = 0)
{
global $msg;
if (!$num_abt) {
return;
}
if (serialcirc_diff::expl_in_circ($num_abt)) {
return $msg['serialcirc_error_delete_abt'];
}
$requete = "select id_serialcirc from serialcirc where num_serialcirc_abt=" . $num_abt;
$resultat = mysql_query($requete);
if (mysql_num_rows($resultat)) {
$r = mysql_fetch_object($resultat);
$id_serialcirc = $r->id_serialcirc;
$requete = "select id_serialcirc_diff from serialcirc_diff where num_serialcirc_diff_serialcirc=" . $id_serialcirc;
$res_diff = mysql_query($requete);
while ($r = mysql_fetch_object($res_diff)) {
$id_diff = $r->id_serialcirc_diff;
$requete = "delete from serialcirc_group where num_serialcirc_group_diff=" . $id_diff;
mysql_query($requete);
$requete = "delete from serialcirc_expl where num_serialcirc_expl_serialcirc_diff=" . $id_diff;
mysql_query($requete);
}
$requete = "delete from serialcirc_circ where num_serialcirc_circ_serialcirc=" . $id_serialcirc;
mysql_query($requete);
$requete = "delete from serialcirc_diff where num_serialcirc_diff_serialcirc=" . $id_serialcirc;
mysql_query($requete);
$requete = "delete from serialcirc_ask where num_serialcirc_ask_serialcirc=" . $id_serialcirc;
mysql_query($requete);
$requete = "delete from serialcirc where id_serialcirc=" . $id_serialcirc;
mysql_query($requete);
}
}
ajax_http_send_response($serialcirc_diff->option_form());
break;
case 'ficheformat_form':
$serialcirc_diff = new serialcirc_diff($id_serialcirc, $num_abt);
ajax_http_send_response($serialcirc_diff->ficheformat_form());
break;
case 'empr_form':
$serialcirc_diff = new serialcirc_diff($id_serialcirc, $num_abt);
ajax_http_send_response($serialcirc_diff->empr_form($id_diff));
break;
case 'group_form':
$serialcirc_diff = new serialcirc_diff($id_serialcirc, $num_abt);
ajax_http_send_response($serialcirc_diff->group_form($id_diff));
break;
case 'up_order_circdiff':
serialcirc_diff::up_order_circdiff($tablo);
break;
case 'up_order_circdiffprint':
serialcirc_diff::up_order_circdiffprint($id_serialcirc, $tablo);
break;
case 'up_order_circdiffgroupdrop':
serialcirc_diff::up_order_circdiffgroupdrop($tablo);
break;
case 'get_caddie':
ajax_http_send_response(serialcirc_diff::get_caddie($id_caddie));
break;
case 'duplicate':
$serialcirc_diff = new serialcirc_diff($id_serialcirc, $abt_from);
ajax_http_send_response($serialcirc_diff->duplicate($abt_to));
break;
}
