1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
|
<?php
function scilab_fixer_menu() {
$items = array();
$items["fix/caption"] = array(
"title" => "Fix TBC captions",
"page callback" => "scilab_fixer_caption_all",
"access arguments" => array("fix scilab"),
"type" => MENU_NORMAL_ITEM
);
$items["fix/ajax"] = array(
"page callback" => "scilab_fixer_ajax",
"access callback" => TRUE,
"type" => MENU_CALLBACK
);
return $items;
}
function scilab_fixer_perm() {
return array(
"fix scilab",
);
}
function scilab_fixer_caption_form($form_state) {
$form = array();
$form["wrapper"] = array(
"#type" => "fieldset",
"#title"=> "Caption change form",
"#prefix" => "<div id='fix-caption-form'>",
"#suffix" => "</div>",
);
$form["wrapper"]["category"] = array(
"#type" => "select",
"#title" => t("Please select the category"),
'#options' => array(
0 => 'Please select a category',
1 => 'Fluid Mechanics',
2 => 'Control Theory & Control Systems',
3 => 'Chemical Engineering',
4 => 'Thermodynamics',
5 => 'Mechanical Engineering',
6 => 'Signal Processing',
7 => 'Digital Communications',
8 => 'Electrical Technology',
9 => 'Mathematics & Pure Science',
10 => 'Analog Electronics',
11 => 'Digital Electronics',
12 => 'Computer Programming',
13 => 'Others'
),
);
$form["wrapper"]["book"] = array(
"#type" => "select",
"#title" => t("Please select the book."),
"#options" => array(
0 => "Please select a book"
)
);
$form["wrapper"]["chapter"] = array(
"#type" => "select",
"#title" => t("Please select the chapter"),
"#options" => array(
0 => "Please select a chapter"
)
);
$form["wrapper"]["example"] = array(
"#type" => "select",
"#title" => t("Please select the example"),
"#options" => array(
0 => "Please select a example"
)
);
$form["wrapper"]["caption"] = array(
"#type" => "textfield",
"#title" => t("Enter new caption"),
);
$form["wrapper"]["submit"] = array(
"#type" => "submit",
"#value" => "Update"
);
$form["wrapper"]["code"] = array(
"#type" => "fieldset",
"#description" => t("No code to display"),
"#prefix" => "<div class='well'><pre id='fix-caption-code'>",
"#suffix" => "</pre></div>",
);
return $form;
}
function scilab_fixer_caption_all() {
$page_content = "";
$page_content .= "<div id='fix-caption-page'>";
$page_content .= "<center><span id='updating'>Updating...</span></center>";
$page_content .= "<span id='done'>Done.</span>";
$page_content .= drupal_get_form("scilab_fixer_caption_form");
$page_content .= "</div>";
return $page_content;
}
function scilab_fixer_ajax($item, $key) {
$data = "";
if($item == "category" && $key) {
$query = "
SELECT pre.id AS id, pre.book, pre.author FROM textbook_companion_preference pre
LEFT JOIN textbook_companion_proposal pro ON pro.id = pre.proposal_id
WHERE pro.proposal_status = 3 AND pre.approval_status = 1 AND pre.category = %d
ORDER BY pre.book ASC
";
$result = db_query($query, $key);
$data .= "<option value='0'>Please select the book.</option>";
while($row = db_fetch_object($result)) {
$data .= "<option value='{$row->id}'>{$row->book}</option>";
}
} else if($item == "book" && $key) {
$query = "SELECT * FROM {textbook_companion_chapter} WHERE preference_id = %d ORDER BY number";
$result = db_query($query, $key);
$data .= "<option value='0'>Please select the chapter.</option>";
while($row = db_fetch_object($result)) {
$data .= "<option value='{$row->id}'>{$row->number} {$row->name}</option>";
}
} else if($item == "chapter" && $key) {
$query = "SELECT * FROM {textbook_companion_example} WHERE chapter_id = %d ORDER BY number";
$result = db_query($query, $key);
$data .= "<option value='0'>Please select the example.</option>";
while($row = db_fetch_object($result)) {
$data .= "<option value='{$row->id}'>{$row->number} {$row->caption}</option>";
}
} else if($item == "example" && $key) {
$query = "
SELECT * FROM textbook_companion_example_files fil
LEFT JOIN textbook_companion_example exa ON exa.id = fil.example_id
WHERE example_id = %d
";
$result = db_query($query, $key);
$row = db_fetch_object($result);
/* fetching example file data */
$uploads_dir = $_SERVER['DOCUMENT_ROOT'] . base_path() . "uploads/";
$example_path = $uploads_dir . $row->filepath;
$example = file_get_contents($example_path);
$data .= "<div id='caption'>{$row->caption}</div>";
$data .= "<div id='code'>{$example}</div>";
} else if($item == "update") {
$example_id = $_POST["example_id"];
$caption = $_POST["caption"];
$query = "
UPDATE textbook_companion_example
SET caption = '%s'
WHERE id = %d
";
$result = db_query($query, $caption, $example_id);
$data .= "Updated";
} else {
$data = "Nothing to display.";
}
echo $data;
exit();
}
function scilab_fixer_init() {
drupal_add_css(drupal_get_path("module", "scilab_fixer") . "/css/scilab_fixer.css");
drupal_add_js(drupal_get_path("module", "scilab_fixer") . "/js/scilab_fixer.js");
}
?>
|
