(* COCANWIKI - a wiki written in Objective CAML.
 * Written by Richard W.M. Jones <rich@merjis.com>.
 * Copyright (C) 2004 Merjis Ltd.
 * $Id: edit_page_css.ml,v 1.11 2004/10/07 11:36:46 rich Exp $
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; see the file COPYING.  If not, write to
 * the Free Software Foundation, Inc., 59 Temple Place - Suite 330,
 * Boston, MA 02111-1307, USA.
 *)

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 = hostname} user =
  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

  let logged_user =
    match user with
      | User (id, _, _) -> `Int id
      | _ -> `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, sitemenu_url_cn,
                   page_emails_url_cn, links_from_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,
                                   logged_user, redirect, css)
                                values (?, ?, ?, ?, ?, ?, ?, ?, ?)" in
  sth#execute [`Int hostid; `String page; title; description;
	       creation_date; logged_ip; logged_user; 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 ~restrict:[CanEdit] run