nuBuilder Forum

Code: Select all

$page =  $_SERVER['HTTP_REFERER'];
if('#verleng#' ==''){
  echo 'Je moet eerst een datum invullen. Tot wanneer wil je deze boeken verlengen?';
} else{

$c=("select  date_format(r.reg_from,'%d-%m-%Y') as reg_from, b.bib_titel from registratie r left join reservaties s on r.reg_id left join bibliotheek b on b.bib_id = s.res_artikel where s.res_reg_id = r.reg_id and res_artikel in (select res_artikel from reservaties where res_reg_id = '#runIt1#' and res_in is null) and STR_TO_DATE('#verleng#', '%d-%m-%Y') between reg_from and reg_to and reg_id != '#runIt1#'and reg_datum_in is null order by reg_from");

$z =nuRunQuery($c);

 $mess = '';
  
while($row= mysql_fetch_array($z))

{

$mess .= $row["bib_titel"];
$mess .= "\n";
  $mess .= "werd opnieuw gereserveerd op: ";
$mess .= $row["reg_from"];
   $mess .= "en kan niet verlengd worden. ";
  $mess .= "</BR>";

}

if(db_num_rows($z)<> 0) {
  
echo" 'Deze boeken: </BR>'$mess  ";
  
return false;
}else {
  
nuRunQuery("update registratie set reg_to = STR_TO_DATE('#verleng#', '%d-%m-%Y') where reg_id = '#runIt1#'");
echo" Deze boeken werden verlengd.  ";
  header('Location:'.$page);
  return true ;
}

}