source: pmb4.2/trunk/fuentes/pmb/circ/transferts/ajax/chg_loc_retrait.inc.php @ 815

Last change on this file since 815 was 815, checked in by jrpelegrina, 4 years ago

Initial release of pmb 4.2

  • Property svn:executable set to *
File size: 1.1 KB
Line 
1<?php
2// +-------------------------------------------------+
3// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
4// +-------------------------------------------------+
5// $Id: chg_loc_retrait.inc.php,v 1.2 2015-04-03 11:16:27 jpermanne Exp $
6
7if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) die("no access");
8
9$rqt = "UPDATE resa SET resa_loc_retrait=".$loc." WHERE id_resa=".$id;
10
11pmb_mysql_query($rqt);
12
13$rqt = "SELECT trim(concat(ifnull(notices_m.tit1,''),ifnull(notices_s.tit1,''),' ',ifnull(bulletin_numero,''), if (mention_date, concat(' (',mention_date,')') ,''))) as tit ".
14                " FROM (((resa LEFT JOIN notices AS notices_m ON resa_idnotice = notices_m.notice_id ) ".
15                        " LEFT JOIN bulletins ON resa_idbulletin = bulletins.bulletin_id) ".
16                        " LEFT JOIN notices AS notices_s ON bulletin_notice = notices_s.notice_id) ".
17                "WHERE id_resa=".$id;
18$lib_titre = pmb_mysql_result(pmb_mysql_query($rqt),0);
19$message = str_replace("!!titre!!",$lib_titre,$msg["transferts_circ_resa_msg_chg_loc_retrait"]);
20
21ajax_http_send_response($message,"text/xml");
22
23?>
Note: See TracBrowser for help on using the repository browser.