Содержимое файла | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
2 | leon | 1 | <?PHP |
2 | session_start(); |
||
3 | if ($_SESSION['$user_privileges'] < 16) |
||
4 | header("Location: index.php"); |
||
5 | include "head.php"; |
||
6 | include "config.php"; |
||
7 | $template_id = $_GET['template_id']; |
||
8 | if ($debug == "1") |
||
9 | print "<br/>Переданный ID шаблона:<br/>$template_id<br/>"; |
||
10 | $db = mysql_connect("localhost", "linwin"); |
||
11 | mysql_select_db("linwin", $db); |
||
12 | mysql_query("SET NAMES 'utf8';", $db); |
||
13 | |||
14 | //Загружаем данные о шаблоне |
||
15 | $sql = "SELECT name FROM templates WHERE id = ". $template_id; |
||
16 | $query=mysql_query($sql, $db); |
||
17 | $template_name = mysql_result($query,0,0); |
||
18 | |||
19 | //Загружаем id программ входящих в шаблон |
||
20 | $sql = "SELECT pid FROM prog_in_temp WHERE tid = ". $template_id; |
||
21 | $query = mysql_query($sql, $db); |
||
22 | $mas_program_id = array(); |
||
23 | $num_record = mysql_num_rows($query); |
||
24 | for ($i = 0; $i < $num_record; $i++) |
||
25 | { |
||
26 | $mas_program_id[] = mysql_result($query, $i, 0); |
||
27 | } |
||
28 | |||
29 | //Создаем группу ID программ входящих в шаблон |
||
30 | $sql_part = "('". $mas_program_id[0]; |
||
31 | if ($num_record > 0) |
||
32 | { |
||
33 | for ($i = 1; $i < $num_record; $i++) |
||
34 | { |
||
35 | $sql_part = $sql_part. "','". $mas_program_id[$i]; |
||
36 | } |
||
37 | } |
||
38 | $sql_part = $sql_part ."')"; |
||
39 | if ($debug == "1") |
||
40 | print "<br/>Группа ID программ входящих в шаблон:<br/>$sql_part<br/>"; |
||
41 | |||
42 | //Загружаем данные о программах входящих в шаблон |
||
43 | $sql = "SELECT id, name, manufacturer, description FROM program WHERE id in ". $sql_part. " ORDER BY name"; |
||
44 | $query = mysql_query($sql, $db); |
||
45 | $mas_program_id = array(); |
||
46 | $mas_program_name = array(); |
||
47 | $mas_program_manufacturer = array(); |
||
48 | $mas_program_description = array(); |
||
49 | $num_record_program = mysql_num_rows($query); |
||
50 | for ($i = 0; $i < $num_record_program; $i++) |
||
51 | { |
||
52 | $mas_program_id[] = mysql_result($query, $i, 0); |
||
53 | $mas_program_name[] = mysql_result($query, $i, 1); |
||
54 | $mas_program_manufacturer[] = mysql_result($query, $i, 2); |
||
55 | $mas_program_description[] = mysql_result($query, $i, 3); |
||
56 | } |
||
57 | |||
58 | //Загружаем данные о программах НЕ входящих в шаблон |
||
59 | $sql = "SELECT id, name, manufacturer, description FROM program WHERE id not in ". $sql_part. " ORDER BY name"; |
||
60 | $query = mysql_query($sql, $db); |
||
61 | $mas_noprogram_id = array(); |
||
62 | $mas_noprogram_name = array(); |
||
63 | $mas_noprogram_manufacturer = array(); |
||
64 | $mas_noprogram_description = array(); |
||
65 | $num_record_noprogram = mysql_num_rows($query); |
||
66 | for ($i = 0; $i < $num_record_noprogram; $i++) |
||
67 | { |
||
68 | $mas_noprogram_id[] = mysql_result($query, $i, 0); |
||
69 | $mas_noprogram_name[] = mysql_result($query, $i, 1); |
||
70 | $mas_noprogram_manufacturer[] = mysql_result($query, $i, 2); |
||
71 | $mas_noprogram_description[] = mysql_result($query, $i, 3); |
||
72 | } |
||
73 | print " |
||
74 | <form action = \"edit_template_sql.php\"> |
||
75 | <table align = \"center\"> |
||
76 | <tr><td colspan = \"2\" align = \"center\"><b>Общие данные о шаблоне:</b></td></tr> |
||
77 | <tr><td><input type = \"hidden\" name = \"template_id\" value = \"$template_id\"/></td><td></td></tr> |
||
78 | <tr><td>Имя шаблона:</td><td><input type = \"text\" class = \"text\" size = \"40\" name = \"template_name\" value = \"$template_name\"/></td></tr> |
||
79 | </table>"; |
||
80 | print " |
||
81 | <table> |
||
82 | <tr><td><b>Программы входящие в шаблон:</b></td><td><b>Программы не входящие в шаблон</b></td></tr> |
||
83 | <tr><td valign = \"top\">"; |
||
84 | for ($i = 0; $i < $num_record_program; $i++) |
||
85 | { |
||
86 | print "<input type = \"checkbox\" name = \"mas_program_id[]\" value = \"$mas_program_id[$i]\">$mas_program_name[$i],$mas_program_manufacturer[$i]</input><br/>"; |
||
87 | } |
||
88 | print "</td><td valign = \"top\">"; |
||
89 | for ($i = 0; $i < $num_record_noprogram; $i++) |
||
90 | { |
||
91 | print "<input type = \"checkbox\" name = \"mas_noprogram_id[]\" value = \"$mas_noprogram_id[$i]\">$mas_noprogram_name[$i], $mas_noprogram_manufacturer[$i]</input><br/>"; |
||
92 | } |
||
93 | print " |
||
94 | </td></tr> |
||
95 | <tr><td><br/><input type = \"submit\" class = \"submit\" name = \"delete_template\" value = \"delete\"/></td> |
||
96 | <td><br/><input type = \"submit\" class = \"submit\" name = \"save_template\" value = \"save\"/></td></tr> |
||
97 | </table> |
||
98 | </form>"; |
||
99 | include "foot.php"; |
||
100 | ?> |