(root)/trunk/view_section_wood.php - Редакция 2
Авторство |
Последнее изменение |
Открыть журнал
| RSS
<?PHP
include "head.php";
include "config.php";
$mas_no_section_id_transfer = array();
$mas_no_section_id_transfer[] = $_GET['section_id'];
if (count($_GET['no_section_id']) > 0)
foreach ($_GET['no_section_id'] as $val)
$mas_no_section_id_transfer[] = $val;
$section_id_transfer = $_GET['section_id'];
$db = mysql_connect("localhost", "linwin");
mysql_select_db("linwin", $db);
mysql_query("SET NAMES 'utf8';", $db);
$sql = "SELECT pid FROM prog_in_sect WHERE sid = ". $mas_no_section_id_transfer[0];
$query=mysql_query($sql, $db);
$mas_sect_id = array();
$num_record = mysql_num_rows($query);
for($i = 0; $i < $num_record; $i++)
{
$mas_prog_in_sect_id[0][$i] = mysql_result($query,$i,0);
}
for ($j = 1; $j < count($mas_no_section_id_transfer); $j++)
{
$sql_part = "('";
for ($i = 0; $i < $num_record; $i++)
$sql_part = $sql_part. "','". $mas_prog_in_sect_id[$j-1][$i];
$sql_part = $sql_part. "')";
$sql ="SELECT pid FROM prog_in_sect WHERE sid = ". $mas_no_section_id_transfer[$j]. " and pid in ". $sql_part;
$query=mysql_query($sql, $db);
$mas_sect_id = array();
$num_record = mysql_num_rows($query);
for($i = 0; $i < $num_record; $i++)
$mas_prog_in_sect_id[$j][$i] = mysql_result($query,$i,0);
}
$sql_part = "('". $mas_prog_in_sect_id[count($mas_prog_in_sect_id)-1][0];
for ($i = 1; $i < count($mas_prog_in_sect_id[count($mas_prog_in_sect_id)-1]); $i++)
$sql_part = $sql_part. "','". $mas_prog_in_sect_id[count($mas_prog_in_sect_id)-1][$i];
$sql_part = $sql_part. "')";
if ($debug == "1")
print "<br/>sql_part:<br/>$sql_part<br/>";
$sql = "SELECT id, name, description FROM program WHERE id in ". $sql_part. " ORDER BY name";
$query = mysql_query($sql, $db);
$num_record = mysql_num_rows($query);
$mas_program_id = array();
$mas_program_name = array();
$mas_program_description = array();
for ($i = 0; $i < $num_record; $i++)
{
$mas_program_id[$i] = mysql_result($query, $i, 0);
$mas_program_name[$i] = mysql_result($query, $i, 1);
$mas_program_description[$i] = mysql_result($query, $i, 2);
}
$sql_part = "pid in ('". $mas_prog_in_sect_id[count($mas_prog_in_sect_id)-1][0];
for ($i = 1; $i < count($mas_prog_in_sect_id[count($mas_prog_in_sect_id)-1]); $i++)
$sql_part = $sql_part. "','". $mas_prog_in_sect_id[count($mas_prog_in_sect_id)-1][$i];
$sql_part = $sql_part. "')";
if (count($mas_no_section_id_transfer))
{
$sql_part = $sql_part. " and sid not in ('". $mas_no_section_id_transfer[0];
for ($i = 1; $i < count($mas_no_section_id_transfer); $i++)
$sql_part = $sql_part. "','". $mas_no_section_id_transfer[$i];
$sql_part = $sql_part. "')";
}
$sql = "SELECT sid FROM prog_in_sect WHERE ". $sql_part;
$query=mysql_query($sql, $db);
$mas_sect_id = array();
$num_record = mysql_num_rows($query);
for($i = 0; $i < $num_record; $i++)
{
$mas_section_id[] = mysql_result($query,$i,0);
}
if (count($mas_section_id))
{
$sql_part = "('". $mas_section_id[0];
for ($i = 1; $i < count($mas_section_id); $i++)
$sql_part = $sql_part. "','". $mas_section_id[$i];
$sql_part = $sql_part. "')";
$sql = "SELECT id, name FROM section WHERE id in ". $sql_part. " ORDER BY name";
$query = mysql_query($sql, $db);
$mas_section_id = array();
$mas_section_name = array();
$num_record = mysql_num_rows($query);
for ($i = 0; $i < $num_record; $i++)
{
$mas_section_id[] = mysql_result($query, $i, 0);
$mas_section_name[] = mysql_result($query, $i, 1);
}
}
$sql_part = "('". $mas_no_section_id_transfer[0];
for ($i = 1; $i < count($mas_no_section_id_transfer); $i++)
$sql_part = $sql_part. "','". $mas_no_section_id_transfer[$i];
$sql_part = $sql_part. "')";
$sql = "SELECT id, name FROM section WHERE id in ". $sql_part. " ORDER BY name";
$query = mysql_query($sql, $db);
$mas_section_in_id = array();
$mas_section_in_name = array();
$num_record = mysql_num_rows($query);
for ($i = 0; $i < $num_record; $i++)
{
$mas_section_in_id[] = mysql_result($query, $i, 0);
$mas_section_in_name[] = mysql_result($query, $i, 1);
}
mysql_close($db);
print "
<table width = \"100%\" align = \"center\">
<tr><td width = \"50%\" align = \"left\" valign = \"top\"><b>Программы находятся в группах:</b><br/>";
for ($i = 0; $i < count($mas_section_in_id); $i++)
print "$mas_section_in_name[$i]<br/> ";
print "
</td><td><table>";
$no_section_id = "";
for ($i = 0; $i < count($mas_no_section_id_transfer); $i++)
$no_section_id = $no_section_id. "&no_section_id%5B%5D=". $mas_no_section_id_transfer[$i];
print "<tr><td><b>Группы:</b><br/>";
for ($i = 0; $i < count($mas_section_id); $i++)
print "<a href = \"view_section_wood.php?section_id=$mas_section_id[$i]&$no_section_id\">$mas_section_name[$i]</a><br/>";
print "
</td></tr></table></td></tr>
<tr><td colspan = \"2\"><hr/></td></tr>
<tr><td align = \"center\" colspan = \"2\"><b>Программы:</b><br/>
<table width = \"100%\" class = \"without-border\" cellpadding = \"0\" cellspacing = \"1\" bgcolor = \"cccccc\">
<tr><td><b>Название программы</b></td><td><b>Описание</b></td>
</tr>";
for ($i = 0; $i < count($mas_program_id); $i++)
{
print "<tr><td bgcolor = \"ffffff\"><a href = what_is_the_program.php?program_id=$mas_program_id[$i] >$mas_program_name[$i]</a></td><td bgcolor = \"ffffff\">$mas_program_description[$i]</td></tr>";
}
print "
</table>
</td></tr></table>";
include "foot.php";
?>