(* COCANWIKI scripts.
 * Written by Richard W.M. Jones <rich@merjis.com>.
 * Copyright (C) 2004 Merjis Ltd.
 * $Id: edit_page_css.ml,v 1.3 2004/09/07 14:58:34 rich Exp $
 *)

open Apache
open Registry
open Cgi
open Printf

open Cocanwiki
open Cocanwiki_ok
open Cocanwiki_diff
open Cocanwiki_emailnotify
open Cocanwiki_strings

let run r (q : cgi) (dbh : Dbi.connection) (hostid, hostname, _) _ =
  let page = q#param "page" in
  let css = q#param "css" in

  let css = if string_is_whitespace css then `Null else `String css in

  (* Get the IP address of the user, if available. *)
  let logged_ip =
    try `String (Connection.remote_ip (Request.connection r))
    with Not_found -> `Null in

  (* Changing the CSS creates a new version of the page.  This enables
   * us to revert changes to the CSS easily.
   *)
  let sth = dbh#prepare_cached "select id, title, description, creation_date,
                                       redirect
                                  from pages
                                 where hostid = ? and url = ?" in
  sth#execute [`Int hostid; `String page];

  let oldpageid, title, description, creation_date, redirect =
    match sth#fetch1 () with
	[ `Int id; title; description; creation_date; redirect ] ->
	  id, title, description, creation_date, redirect
      | _ -> assert false in

  let sth = dbh#prepare_cached "set constraints pages_redirect_cn deferred" in
  sth#execute [];

  let sth = dbh#prepare_cached "update pages set url_deleted = url,
                                                 url = null
                                 where hostid = ? and id = ?" in
  sth#execute [`Int hostid; `Int oldpageid];

  let sth = dbh#prepare_cached "insert into pages (hostid, url, title,
                                   description, creation_date, logged_ip,
                                   redirect, css)
                                values (?, ?, ?, ?, ?, ?, ?, ?)" in
  sth#execute [`Int hostid; `String page; title; description;
	       creation_date; logged_ip; redirect; css ];

  let pageid = sth#serial "pages_id_seq" in

  let sth = dbh#prepare_cached "insert into contents (pageid, ordering,
                                       sectionname, content, divname)
                                select ? as pageid, ordering, sectionname,
                                            content, divname
                                  from contents
                                 where pageid = ?" in
  sth#execute [`Int pageid; `Int oldpageid];

  dbh#commit ();

  (* Email notification. *)
  let subject = "CSS for page " ^ page ^ " has been modified" in
  let body = fun () ->
    let diff, _ =
      get_diff dbh hostid page ~version:pageid ~old_version:oldpageid () in
    "Page: http://" ^ hostname ^ "/" ^ page ^ "\n\n" ^
    diff in

  email_notify ~subject ~body dbh hostid;

  let buttons = [ ok_button ("/" ^ page);
		  { StdPages.label = "Edit stylesheet again";
		    StdPages.link = "/_bin/edit_page_css_form.cmo";
		    StdPages.method_ = None;
		    StdPages.params = [ "page", page ] } ] in
  ok ~title:"Stylesheet changed" ~buttons
    q ("The stylesheet was changed successfully.  " ^
       "Note: You must RELOAD the page to see changes to stylesheets.")

let () =
  register_script run