(* COCANWIKI scripts.
 * Written by Richard W.M. Jones <rich@merjis.com>.
 * Copyright (C) 2004 Merjis Ltd.
 * $Id: edit_emails_form.ml,v 1.2 2004/09/07 13:40:10 rich Exp $
 *)

open Apache
open Registry
open Cgi
open Printf

open Cocanwiki
open Cocanwiki_template

let template = get_template "admin/edit_emails_form.html"

let run r (q : cgi) (dbh : Dbi.connection) _ _ =
  let hostid = int_of_string (q#param "hostid") in

  template#set "id" (string_of_int hostid);

  let sth = dbh#prepare_cached
	      "select canonical_hostname from hosts where id = ?" in
  sth#execute [`Int hostid];

  let canonical_hostname = sth#fetch1string () in
  template#set "canonical_hostname" canonical_hostname;

  let sth = dbh#prepare_cached
	      "select email, name from email_notify where hostid = ?" in
  sth#execute [`Int hostid];

  let emails = sth#map (function
			    [`String email; `Null] ->
			      email
			  | [`String email; `String name] ->
			      sprintf "%s <%s>" name email
			  | _ -> assert false) in

  template#set "emails" (String.concat "\n" emails);

  q#template template

let () =
  register_script run