#!/usr/local/bin/php
<?php
  /*
   * もっと、遥かな山旅を 山旅スライドのバージョンアップ2
   * File :  xml2sql.php
   *
   *         Ver 0.10 2005-02-21 新規作成開始 S.Ishizumi
   *         Ver 0.20 2005-03-01 slide_no_seqをやめる S.Ishizumi
   *         Ver 0.30 2005-03-05 各スライドディレクトリにalbum.xmlファイルを作成
   *         Ver 0.40 2005-03-07 Google AdSense広告付きhtmlファイルを作成
   *
   *  Copyright (C) 2005 Shingo.Ishizumi All Right Reserved
   */

  // Ver2用xmlファイルをsqlファイルに変更
  $fp = fopen("slide2-1.sql", "w");
  fwrite($fp, "drop table slide;\n");
  fwrite($fp, "create table slide(\n");
  fwrite($fp, "no int4,\n");
  fwrite($fp, "album_no int4,\n");
  fwrite($fp, "title text,\n");
  fwrite($fp, "t_date timestamp,\n");
  fwrite($fp, "author text,\n");
  fwrite($fp, "mail text,\n");
  fwrite($fp, "passwd text,\n");
  fwrite($fp, "id text,\n");
  fwrite($fp, "comment text,\n");
  fwrite($fp, "hp text,\n");
  fwrite($fp, "hp_url text,\n");
  fwrite($fp, "link1 text,\n");
  fwrite($fp, "link1_url text,\n");
  fwrite($fp, "thumbnail_no int4,\n");
  fwrite($fp, "thumbnail_kind text,\n");
  fwrite($fp, "bgm text,\n");
  fwrite($fp, "fade_wid int4,\n");
  fwrite($fp, "fade_hig int4,\n");
  fwrite($fp, "fade_spd float4,\n");
  fwrite($fp, "fade_wat int4,\n");
  fwrite($fp, "fade_msk text,\n");
  fwrite($fp, "zoom_wid int4,\n");
  fwrite($fp, "zoom_hig int4,\n");
  fwrite($fp, "zoom_spd float4,\n");
  fwrite($fp, "zoom_wat int4,\n");
  fwrite($fp, "zoom_max int4,\n");
  fwrite($fp, "zoom_md1 int4,\n");
  fwrite($fp, "zoom_md2 int4,\n");
  fwrite($fp, "zoom_min int4,\n");
  fwrite($fp, "zoom_msk text,\n");
  fwrite($fp, "roll_wid int4,\n");
  fwrite($fp, "roll_hig int4,\n");
  fwrite($fp, "roll_spd float4,\n");
  fwrite($fp, "roll_wat int4,\n");
  fwrite($fp, "roll_msk text,\n");
  fwrite($fp, "category text,\n");
  fwrite($fp, "img_cnt int4,\n");
  fwrite($fp, "txt1 text,\n");
  fwrite($fp, "txt2 text,\n");
  fwrite($fp, "txt3 text,\n");
  fwrite($fp, "txt4 text,\n");
  fwrite($fp, "txt5 text,\n");
  fwrite($fp, "txt6 text,\n");
  fwrite($fp, "txt7 text,\n");
  fwrite($fp, "txt8 text,\n");
  fwrite($fp, "update_cnt int4,\n");
  fwrite($fp, "access_cnt int4,\n");
  fwrite($fp, "PRIMARY KEY (\"no\")\n");
  fwrite($fp, ");\n");

  $dom = domxml_open_file("album2-1.xml");
  if (!$dom) {
    printf("album2-1.xmlをパースできません。\n");
    exit;
  }
  $Album = $dom->get_elements_by_tagname("Album");
  for ($i = 0; $i < count($Album); $i++) {
    fwrite($fp, "insert into slide values(");
    $slide_no = $Album[$i]->get_attribute("No");
    fwrite($fp, "$slide_no,");
    fwrite($fp, "0001,");
    $tmp1 = $Album[$i]->get_elements_by_tagname("Title");
    $slide = mb_convert_encoding($tmp1[0]->get_content(), "SJIS", "UTF-8");
    fwrite($fp, "'$slide',");
    $tmp2 = $tmp1[0]->get_attribute("Date");
    $date = $tmp2." 12:00:00";
    fwrite($fp, "'$date',");

    $tmp1 = $Album[$i]->get_elements_by_tagname("Author");
    $name = mb_convert_encoding($tmp1[0]->get_content(), "SJIS", "UTF-8");
    fwrite($fp, "'$name',");
    $mail = $tmp1[0]->get_attribute("Mail");
    fwrite($fp, "'$mail',");
    $pass = $tmp1[0]->get_attribute("Passwd");
    fwrite($fp, "'$pass',");
    $id   = $tmp1[0]->get_attribute("ID");
    fwrite($fp, "'$id',");

    $tmp1 = $Album[$i]->get_elements_by_tagname("Comment");
    $comment = mb_convert_encoding($tmp1[0]->get_content(), "SJIS", "UTF-8");
    fwrite($fp, "'$comment',");

    $tmp1 = $Album[$i]->get_elements_by_tagname("HP");
    $hp   = mb_convert_encoding($tmp1[0]->get_content(), "SJIS", "UTF-8");
    fwrite($fp, "'$hp',");
    $url  = $tmp1[0]->get_attribute("URL");
    $url  = ereg_replace("&", "&amp;", $url);
    fwrite($fp, "'$url',");

    $tmp1 = $Album[$i]->get_elements_by_tagname("Link1");
    $link1= mb_convert_encoding($tmp1[0]->get_content(), "SJIS", "UTF-8");
    fwrite($fp, "'$link1',");
    $link1_url = $tmp1[0]->get_attribute("URL");
    fwrite($fp, "'$link1_url',");

    $tmp1 = $Album[$i]->get_elements_by_tagname("Thumbnail");
    $thum_no = $tmp1[0]->get_attribute("No");
    fwrite($fp, "$thum_no,");
    $thum_kind = $tmp1[0]->get_attribute("Kind");
    fwrite($fp, "'$thum_kind',");

    $tmp1 = $Album[$i]->get_elements_by_tagname("BGM");
    $midi = $tmp1[0]->get_attribute("Defult");
    fwrite($fp, "'$midi',");

    $tmp1 = $Album[$i]->get_elements_by_tagname("Slide");
    $fade_wid = $tmp1[0]->get_attribute("Width");
    fwrite($fp, "$fade_wid,");
    $fade_hig = $tmp1[0]->get_attribute("Height");
    fwrite($fp, "$fade_hig,");
    $fade_spd = $tmp1[0]->get_attribute("Speed");
    fwrite($fp, "$fade_spd,");
    $fade_wat = $tmp1[0]->get_attribute("Wait");
    fwrite($fp, "$fade_wat,");
    $fade_msk = $tmp1[0]->get_attribute("Mask");
    fwrite($fp, "'$fade_msk',");

    $zoom_wid = $tmp1[1]->get_attribute("Width");
    fwrite($fp, "$zoom_wid,");
    $zoom_hig = $tmp1[1]->get_attribute("Height");
    fwrite($fp, "$zoom_hig,");
    $zoom_spd = $tmp1[1]->get_attribute("Speed");
    fwrite($fp, "$zoom_spd,");
    $zoom_wat = $tmp1[1]->get_attribute("Wait");
    fwrite($fp, "$zoom_wat,");
    $zoom_max = $tmp1[1]->get_attribute("Max");
    fwrite($fp, "$zoom_max,");
    $zoom_md1 = $tmp1[1]->get_attribute("Md1");
    fwrite($fp, "$zoom_md1,");
    $zoom_md2 = $tmp1[1]->get_attribute("Md2");
    fwrite($fp, "$zoom_md2,");
    $zoom_min = $tmp1[1]->get_attribute("Min");
    fwrite($fp, "$zoom_min,");
    $zoom_msk = $tmp1[1]->get_attribute("Mask");
    fwrite($fp, "'$zoom_msk',");

    $roll_wid = $tmp1[2]->get_attribute("Width");
    fwrite($fp, "$roll_wid,");
    $roll_hig = $tmp1[2]->get_attribute("Height");
    fwrite($fp, "$roll_hig,");
    $roll_spd = $tmp1[2]->get_attribute("Speed");
    fwrite($fp, "$roll_spd,");
    $roll_wat = 1;
    fwrite($fp, "$roll_wat,");
    $roll_msk = $tmp1[2]->get_attribute("Mask");
    fwrite($fp, "'$roll_msk',");

    $category = mb_convert_encoding("山", "SJIS", "SJIS");
    fwrite($fp, "'$category',");

    $Image = $Album[$i]->get_elements_by_tagname("Image");
    $file_no  = count($Image);
    fwrite($fp, "$file_no,");
    for ($j = 0; $j < 8; $j++) {
      if ($j < $file_no) {
        $wid[$j] = $Image[$j]->get_attribute("Width");
        $hig[$j] = $Image[$j]->get_attribute("Height");
        $tmp1    = $Image[$j]->get_elements_by_tagname("Title");
        $txt[$j] = mb_convert_encoding($tmp1[0]->get_content(), "SJIS", "UTF-8");
        fwrite($fp, "'$txt[$j]',");
      }
      else {
        fwrite($fp, "'',");
      }
    }

    fwrite($fp, "1,");
    $file = sprintf("%04d/count.data", $slide_no);
    $fp2 = fopen($file,"r");
    if ($fp2 == False) {
      fwrite($fp, "00000");
    }
    else {
      fwrite($fp, fgets($fp2, 512));
      fclose($fp2);
    }
    fwrite($fp, ");\n");

    // album.xml ファイルの作成 2005-03-05
    $dir      = sprintf("%04d", $slide_no);
    $xml_file = $dir."/album.xml";
    $fp1 = fopen($xml_file, "w");
    if ($fp1 == false) {
      printf("ファイル(%s)のオープンに失敗しました。\n", $xml_file);
    }
    fwrite($fp1, "<?xml version=\"1.0\" encoding=\"SJIS\"?>\n");
    fwrite($fp1, "<Albums No=\"0001\">\n");
    fwrite($fp1, "  <Property>\n");
    fwrite($fp1, "    <DIR root=\"../../..\" current=\"cgi/slide/data\" img=\"0001\" mobile=\"0001\" slide=\"0001\"/>\n");
    fwrite($fp1, "    <Title Date=\"2004-06-28\">山の旅人たちのスライドショー </Title>\n");
    fwrite($fp1, "    <Comment>山の旅人たちのスライドショー スライドショーの作成も可能です。</Comment>\n");
    fwrite($fp1, "    <HP URL=\"http://yama-tabi.net/\">もっと、遙かな山旅を</HP>\n");
    fwrite($fp1, "    <UPLink URL=\"../../i-camera/syasinn.htm\">写真集</UPLink>\n");
    fwrite($fp1, "    <Link1 URL=\"http://yama-tabi.net/\" />\n");
    fwrite($fp1, "    <Thumbnail No=\"001\" Kind=\"jpg\" />\n");
    fwrite($fp1, "  </Property>\n");
    fwrite($fp1, "  <Album No=\"$slide_no\">\n");
    fwrite($fp1, "    <Property>\n");
    fwrite($fp1, "      <DIR root=\"../../..\" current=\"cgi/slide/date\" img=\"$slide_no\" mobile=\"$slide_no\" slide=\"$slide_no\" />\n");
    fwrite($fp1, "      <Title Date=\"$date\">$slide</Title>\n");
    fwrite($fp1, "      <Author Mail=\"$mail\" Passwd=\"$pass\" ID=\"$id\">$name</Author>\n");
    fwrite($fp1, "      <Comment>$comment</Comment>\n");
    fwrite($fp1, "      <HP URL=\"$url\">$hp</HP>\n");
    fwrite($fp1, "      <Link1 URL=\"http://yama-tabi.net/\" />\n");
    fwrite($fp1, "      <Thumbnail No=\"001\" Kind=\"jpg\" />\n");
    fwrite($fp1, "      <BGM DIR=\".\" Defult=\"$midi\" />\n");
    fwrite($fp1, "      <Slide Name=\"Fade\" Width=\"$fade_wid\" Height=\"$fade_hig\" Speed=\"$fade_spd\" Wait=\"$fade_wat\" Mask=\"null\">Fade</Slide>\n");
    fwrite($fp1, "      <Slide Name=\"Zoom\" Width=\"$zoom_wid\" Height=\"$zoom_hig\" Speed=\"$zoom_spd\" Wait=\"$zoom_wat\" Max=\"$zoom_max\" Md1=\"$zoom_md1\" Md2=\"$zoom_md2\" Min=\"$zoom_min\" Mask=\"null\">Zoom</Slide>\n");
    fwrite($fp1, "      <Slide Name=\"Roll\" Width=\"$roll_wid\" Height=\"$roll_hig\" Speed=\"$roll_spd\" Wait=\"$roll_wat\" Mask=\"null\">Roll</Slide>\n");
    fwrite($fp1, "    </Property>\n");
    for ($j = 0; $j < $file_no; $j++) {
      $no   = $j+1;
      $x_no = sprintf("%03d",  $no);
      fwrite($fp1, "    <Image Kind=\"jpg\" No=\"$x_no\" Width=\"$wid[$j]\" Height=\"$hig[$j]\">\n");
      fwrite($fp1, "      <Title>$txt[$j]</Title>\n");
      fwrite($fp1, "      <Camera Tv=\"\" Av=\"\" />\n");
      fwrite($fp1, "      <Date />\n");
      fwrite($fp1, "      <Place />\n");
      fwrite($fp1, "      <Author Mail=\"\" Passwd=\"\" ID=\"\" />\n");
      fwrite($fp1, "      <Comment />\n");
      fwrite($fp1, "      <Link1 URL=\"\" />\n");
      fwrite($fp1, "    </Image>\n");
    }
    fwrite($fp1, "  </Album>\n");
    fwrite($fp1, "</Albums>\n");
    fclose($fp1);
    chmod ($xml_file, 0666);

    /*** slide.xml ファイルの作成	***/
    $strDir = dirname(__FILE__);
    $strXml = $strDir."/".$dir."/album.xml";
    $strXsl = $strDir."/slide_xml.xsl";
    $objPrc = xslt_create();
    xslt_set_encoding($objPrc, "SJIS");
    $arg    = array();
    $param  = array("AlbumNo"=>"0001", "Kind"=>"fade");
    $param[AlbumNo] = $slide_no;
//    $dst_file = $strDir."/".$dir."/slide.xml";
//    $result = xslt_process($objPrc, $strXml, $strXsl, $dst_file, $arg, $param);
//    chmod ($dst_file, 0666);

    // fade.html ファイルの作成
    $strXsl = $strDir."/slide_fade.xsl";
    $param[AlbumNo] = $slide_no;
    $param[Kind] = "fade";
    $dst_file = $strDir."/".$dir."/fade.html";
    $result = xslt_process($objPrc, $strXml, $strXsl, $dst_file, $arg, $param);
    chmod ($dst_file, 0666);

    // zoom.html ファイルの作成
    $param[Kind] = "zoom";
    $dst_file = $strDir."/".$dir."/zoom.html";
    $result = xslt_process($objPrc, $strXml, $strXsl, $dst_file, $arg, $param);
    chmod ($dst_file, 0666);

    // roll.html ファイルの作成
    $param[Kind] = "roll";
    $dst_file = $strDir."/".$dir."/roll.html";
    $result = xslt_process($objPrc, $strXml, $strXsl, $dst_file, $arg, $param);
    chmod ($dst_file, 0666);

    // index.html ファイルの作成
    $param[Kind] = "index";
    $dst_file = $strDir."/".$dir."/index.html";
    $result = xslt_process($objPrc, $strXml, $strXsl, $dst_file, $arg, $param);
    chmod ($dst_file, 0666);

    // n.htm ファイルの作成
    $strXsl = $strDir."/photo.xsl";
    $param  = array("AlbumNo"=>"0001", "ImageNo"=>"001");
    $param[AlbumNo] = $slide_no;
    for ($j = 0; $j < $file_no; $j++) {
      $no   = $j+1;
      $x_no = sprintf("%03d",  $no);
      $param[ImageNo] = $x_no;
      $dst_file = $strDir."/".$dir."/".$x_no.".html";
      $result = xslt_process($objPrc, $strXml, $strXsl, $dst_file, $arg, $param);
      chmod ($dst_file, 0666);
    }
    printf("slide_no=%s \n", $dir);

  }
  fwrite($fp, "grant all on slide to nobody;\n");
  fclose($fp);
  chmod("slide2-1.sql", 0666);
?>