<?
include ("forixinc.php");
include ("util.php");



function sommario()
{
    extract($GLOBALS);

    fxhead("Forix: Autosprint");
    tab_ini();
    tab_bar(4);
    echo("<TR><TH VALIGN=\"middle\"><FONT SIZE=\"+3\">");
    if ($ano_p>0)
	echo("<A HREF=\"autosprint.asp?$args&y=$ano_p&n=$num_p&c=0\"><IMG SRC=\"../pic/ante.gif\" ALT=\"&lt;\" ALIGN=\"absmiddle\" BORDER=\"0\"></A>&nbsp;&nbsp;");
    echo("Autosprint n.$num");
    if ($ano_n>0)
	echo("&nbsp;&nbsp;<A HREF=\"autosprint.asp?$args&y=$ano_n&n=$num_n&c=0\"><IMG SRC=\"../pic/prox.gif\" ALT=\"&gt;\" ALIGN=\"absmiddle\" BORDER=\"0\"></A>");
    echo("</FONT></TH></TR>");

    echo("<TR><TH><FONT SIZE=\"+1\">");
    if ($ini_m == $fim_m && $ini_a == $fim_a)
	echo $ini_d;
    else
    if ($ini_a == $fim_a)
	echo pri_data($ini_d,$ini_m,0,1);
    else
	echo pri_data($ini_d,$ini_m,$ini_a,1);
    echo("&nbsp;-&nbsp;".pri_data($fim_d,$fim_m,$fim_a,1)."</FONT></TH></TR>");
    tab_bar(4);
    echo("<TR><TD ALIGN=\"center\"><FONT SIZE=\"2\">e-mail: <A HREF=\"mailto:posta@autosprint.it\">posta@autosprint.it</A></FONT></TD></TR>");
    tab_bar(6);
    tab_bor();

    echo("<TR BGCOLOR=\"$TR1_BGC\"><TD ALIGN=\"center\">");
    echo("<table border=\"0\" cellspacing=\"0\" cellpadding=\"6\">");
    echo("<TR BGCOLOR=\"$TR1_BGC\"><TD width=\"500\" ALIGN=\"left\"><img src=\"picture.php?p=imgz/autosprint/".($ano*100+$num).".jpg\" border=\"1\" align=\"right\">");

    $SQLQuery="SELECT topic, title FROM as_sommario WHERE year=".$ano." and num=".$num." order by page";
    if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0) {
	echo("<font size=\"4\"><B>Sommario</B></font><BR><BR>");
	while ($RSList= mysql_fetch_array($result)) {
	    echo("<font size=\"1\">&gt; </font>");
	    if (strlen($RSList["topic"]) > 0)
		echo("<B>".$RSList["topic"]."</B> - ");
	    echo($RSList["title"]."<BR>");
	}
    }
    echo("</TABLE></TD></TR>");

// Index
    $SQLQuery="SELECT * FROM as_datas WHERE year>=2002 Order by year desc, num desc";
    if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0) {
	tab_bor();
	tab_bar2(6);
	echo("<FORM NAME=\"formtitulos\"><TR BGCOLOR=\"$TR2_BGC\"><TD ALIGN=\"center\"><B>Seleziona un altro numero&nbsp;</B>");
	echo("<SELECT NAME=\"titulos\" size=\"1\" ONCHANGE=\"window.location.href = document.formtitulos.titulos.options[document.formtitulos.titulos.selectedIndex].value\";>");
	while ($RSList= mysql_fetch_array($result)) {
	    echo("<OPTION VALUE=\"autosprint.asp?$args&y=".$RSList["year"]."&n=".$RSList["num"]."&c=0\"");
	    if ($RSList["year"]==$ano && $RSList["num"]==$num)
		echo(" Selected");
	    echo(">Autosprint n.".$RSList["num"].": ".pri_data($RSList["ini_d"],$RSList["ini_m"],$RSList["ini_a"],1));
	}
	echo("</select></TD></TR></form>");
	tab_bar2(6);
    }

    if ($username == "forix") {
	tab_bor();
	tab_bar2(4);
	echo("<tr bgcolor=\"$TR2_BGC\"><td align=\"center\"><b>Edit: <A HREF=\"autosprint.asp?$args&y=$ano&n=$num&c=$cmdEdit_dat\">datas</A>, <A HREF=\"autosprint.asp?$args&y=$ano&n=$num&c=$cmdEdit_som\">sommario</A></b></td></tr>");
	tab_bar2(4);
    }

tab_fim();
fxtail();
}



function as_edit_datas ()
{
    extract($GLOBALS);

    if ($tip == 1) {
	$ano   = intval(post_arg("ano"));
	$num   = intval(post_arg("num"));
	$ano_p = intval(post_arg("year_p"));
	$num_p = intval(post_arg("num_p"));
	$ano_n = intval(post_arg("year_n"));
	$num_n = intval(post_arg("num_n"));
	$ini_a = intval(post_arg("ini_a"));
	$ini_m = intval(post_arg("ini_m"));
	$ini_d = intval(post_arg("ini_d"));
	$fim_a = intval(post_arg("fim_a"));
	$fim_m = intval(post_arg("fim_m"));
	$fim_d = intval(post_arg("fim_d"));
    // Delete old record
	$SQLQuery = "Delete from as_datas where year=$ano and num=$num";
	mysql_query($SQLQuery);
    // Insert new record
	$SQLQuery = "Insert into as_datas Values ($ano, $num, $ano_p, $num_p, $ano_n, $num_n, $ini_a, $ini_m, $ini_d, $fim_a, $fim_m, $fim_d)";
//	echo ($SQLQuery);
	mysql_query($SQLQuery);
	header("Location: autosprint.asp?$args&y=$ano&n=$num&c=0");
    }
    fxhead("Forix: Autosprint");
    tab_ini();
    tab_bar(2);
    echo("<TR><TH><FONT SIZE=\"+1\">Autosprint</FONT></TH></TR>");
    tab_bar(4);
    tab_bor();
    tab_bar1(4);
    $SQLQuery="Select * from as_datas where year=$ano and num=$num";
    if (($result = mysql_query($SQLQuery)) and ($RSList = mysql_fetch_array($result))) {
	$ano_p = $RSList["year_p"];
	$num_p = $RSList["num_p"];
	$ano_n = $RSList["year_n"];
	$num_n = $RSList["num_n"];
	$ini_a = $RSList["ini_a"];
	$ini_m = $RSList["ini_m"];
	$ini_d = $RSList["ini_d"];
	$fim_a = $RSList["fim_a"];
	$fim_m = $RSList["fim_m"];
	$fim_d = $RSList["fim_d"];
    } else {
	$ano_p = $ano;
	$num_p = $num-1;
	$ano_n = 0;
	$num_n = 0;
	$ini_a = $ano;
	$ini_m = $hmes;
	$ini_d = 0;
	$fim_a = $ano;
	$fim_m = $hmes;
	$fim_d = 0;
    }
    echo("<FORM METHOD=POST ACTION=\"autosprint.asp?$args&y=$ano&n=$num&c=$cmd&t=1\">");
    echo("<TR BGCOLOR=\"$TR1_BGC\"><TD ALIGN=\"center\">");
    echo("<table border=\"0\" cellspacing=\"0\" cellpadding=\"4\">");
    echo("<TR><TD ALIGN=\"right\" valign=\"top\"><B>Anno</B></TD><td align=\"left\"><INPUT type=\"text\" name=\"ano\" value=\"$ano\" size=\"4\"></td></TR>");
    echo("<TR><TD ALIGN=\"right\" valign=\"top\"><B>Numero</B></TD><td align=\"left\"><INPUT type=\"text\" name=\"num\" value=\"$num\" size=\"4\"></td></TR>");
    echo("<TR><TD ALIGN=\"right\" valign=\"top\"><B>Anterior</B></TD><td align=\"left\"><INPUT type=\"text\" name=\"year_p\" value=\"$ano_p\" size=\"4\"><INPUT type=\"text\" name=\"num_p\" value=\"$num_p\" size=\"2\"></td></TR>");
    echo("<TR><TD ALIGN=\"right\" valign=\"top\"><B>Seguinte</B></TD><td align=\"left\"><INPUT type=\"text\" name=\"year_n\" value=\"$ano_n\" size=\"4\"><INPUT type=\"text\" name=\"num_n\" value=\"$num_n\" size=\"2\"></td></TR>");
    echo("<TR><TD ALIGN=\"right\" valign=\"top\"><B>Inizio</B></TD><td align=\"left\"><INPUT type=\"text\" name=\"ini_a\" value=\"$ini_a\" size=\"4\"><INPUT type=\"text\" name=\"ini_m\" value=\"$ini_m\" size=\"2\"><INPUT type=\"text\" name=\"ini_d\" value=\"$ini_d\" size=\"2\"></td></TR>");
    echo("<TR><TD ALIGN=\"right\" valign=\"top\"><B>Fine</B></TD><td align=\"left\"><INPUT type=\"text\" name=\"fim_a\" value=\"$fim_a\" size=\"4\"><INPUT type=\"text\" name=\"fim_m\" value=\"$fim_m\" size=\"2\"><INPUT type=\"text\" name=\"fim_d\" value=\"$fim_d\" size=\"2\"></td></TR>");
    echo("</table></td></tr>");
    tab_bar1(4);
    tab_bor();
    tab_bar2(6);
    echo("<TR BGCOLOR=\"$TR2_BGC\"><th><INPUT TYPE=\"SUBMIT\" value=\"Ok\"></TH></TR>");
    echo("</FORM>");
    tab_bar2(6);
    tab_fim();
    fxtail();
}



function as_edit_sommario ()
{
    extract($GLOBALS);

    if ($tip == 1) {
	$ano = intval(post_arg("ano"));
	$num = intval(post_arg("num"));
	$txt = trim(post_arg("txt"));
	if (strlen($txt) > 0) {
	// Delete old records
	    $SQLQuery = "Delete from as_sommario where year=$ano and num=$num";
	    mysql_query($SQLQuery);
	    $linhas= explode(chr(10), $txt);
	    for ($i=0; $i < count($linhas); $i++) {
		$pag = intval(strtok($linhas[$i], '|'));
		$tit = trim(strtok('|'));
		$top = trim(strtok('|'));
		$aut = trim(strtok('|'));
	    // Insert new record
		$SQLQuery = "Insert into as_sommario Values ($ano, $num, $pag, '".$tit."','".$top."','".$aut."')";
//		echo ($SQLQuery);
		mysql_query($SQLQuery);
	    }
	    header("Location: autosprint.asp?$args&y=$ano&n=$num&c=0");
	}
    }
    fxhead("Forix: Autosprint");
    tab_ini();
    tab_bar(2);
    echo("<TR><TH><FONT SIZE=\"+1\">Autosprint</FONT></TH></TR>");
    tab_bar(4);
    tab_bor();
    tab_bar1(4);
    echo("<FORM METHOD=POST ACTION=\"autosprint.asp?$args&y=$ano&n=$num&c=$cmd&t=1\">");
    echo("<TR BGCOLOR=\"$TR1_BGC\"><TD ALIGN=\"center\">");
    echo("<table border=\"0\" cellspacing=\"0\" cellpadding=\"4\">");
    echo("<TR><TD ALIGN=\"right\" valign=\"top\"><B>Anno</B></TD><td align=\"left\"><INPUT type=\"text\" name=\"ano\" value=\"$ano\" size=\"4\"></td></TR>");
    echo("<TR><TD ALIGN=\"right\" valign=\"top\"><B>Numero</B></TD><td align=\"left\"><INPUT type=\"text\" name=\"num\" value=\"$num\" size=\"4\"></td></TR>");
    echo("<TR><TD align=\"right\" valign=\"top\"><B>Sommario</B></TD><td align=\"left\"><TEXTAREA name=\"txt\" ROWS=\"24\" COLS=\"40\">");
    $SQLQuery="Select * from as_sommario where year=$ano and num=$num order by page";
    if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0)
	while ($RSList= mysql_fetch_array($result))
	    echo($RSList["page"]. "|" .$RSList["title"]. "|" .$RSList["topic"]. "|". $RSList["author"]. chr(10));
    else
	echo("page|title|topic|author".chr(10));
    echo("</TEXTAREA></TD></TR>");
    echo("</table></td></tr>");
    tab_bar1(4);
    tab_bor();
    tab_bar2(6);
    echo("<TR BGCOLOR=\"$TR2_BGC\"><th><INPUT TYPE=\"SUBMIT\" value=\"Ok\"></TH></TR>");
    echo("</FORM>");
    tab_bar2(6);
    tab_fim();
    fxtail();
}



$cmdEdit_dat = 11;
$cmdEdit_som = 12;

$pub_part=0;

$cmd=intval(get_arg("c"));
$ano=intval(get_arg("y"));
$num=intval(get_arg("n"));
$tip=intval(get_arg("t"));

log_page($REF_ASIT,$ano*100+$num,$cmd);

if ($cmd == $cmdEdit_dat and $username == "forix")
    as_edit_datas ();
else if ($cmd == $cmdEdit_som and $username == "forix")
    as_edit_sommario ();
else {
    $SQLQuery="Select * from as_datas where year=".$ano." and num=".$num;
    if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0)
	$RSList = mysql_fetch_array($result);
    else {
	$SQLQuery="Select * from as_datas order by year desc, num desc limit 1";
	$RSList = mysql_fetch_array(mysql_query($SQLQuery));
    }

    $ano=$RSList["year"];
    $num=$RSList["num"];
    $ano_p=$RSList["year_p"];
    $num_p=$RSList["num_p"];
    $ano_n=$RSList["year_n"];
    $num_n=$RSList["num_n"];
    $ini_a=$RSList["ini_a"];
    $ini_m=$RSList["ini_m"];
    $ini_d=$RSList["ini_d"];
    $fim_a=$RSList["fim_a"];
    $fim_m=$RSList["fim_m"];
    $fim_d=$RSList["fim_d"];

    sommario();
}

?>
