b773d10a5b9fbb77127114408ebea53c506180d7
[atutor.git] / docs / mods / _standard / reading_list / new_reading_url.php
1 <?php
2 /****************************************************************/
3 /* ATutor                                                                                                               */
4 /****************************************************************/
5 /* Copyright (c) 2002-2008                                      */
6 /* Written by Greg Gay, Joel Kronenberg & Chris Ridpath         */
7 /* Inclusive Design Institute                                   */
8 /* http://atutor.ca                                                                                             */
9 /*                                                              */
10 /* This program is free software. You can redistribute it and/or*/
11 /* modify it under the terms of the GNU General Public License  */
12 /* as published by the Free Software Foundation.                                */
13 /****************************************************************/
14 // $Id$
15 define('AT_INCLUDE_PATH', '../../../include/');
16 require (AT_INCLUDE_PATH.'vitals.inc.php');
17 authenticate(AT_PRIV_READING_LIST);
18
19 $existing = -1;
20
21 if (isset($_POST['cancel'])) {
22         $msg->addFeedback('CANCELLED');
23         header('Location: index_instructor.php');
24         exit;
25 } else if (isset($_POST['submit'])) {
26
27         $_POST['existing'] = intval($_POST['existing']);
28         $existingurl = $_POST['existing'];
29         $_POST['hasdate'] = $addslashes($_POST['hasdate']);
30         $_POST['readstatus'] = $addslashes($_POST['readstatus']);
31         $_POST['comment'] = $addslashes($_POST['comment']);
32         $_POST['startday'] = intval($_POST['startday']);
33         $_POST['startmonth'] = intval($_POST['startmonth']);
34         $_POST['startyear'] = intval($_POST['startyear']);
35         $_POST['endday'] = intval($_POST['endday']);
36         $_POST['endmonth'] = intval($_POST['endmonth']);
37         $_POST['endyear'] = intval($_POST['endyear']);
38
39         $date_start = '0000-00-00';
40         $date_end = '0000-00-00';
41         if ($_POST['hasdate'] == 'true'){
42                 $date_start = $_POST['startyear']. '-' .str_pad ($_POST['startmonth'], 2, "0", STR_PAD_LEFT). '-' .str_pad ($_POST['startday'], 2, "0", STR_PAD_LEFT);
43                 $date_end = $_POST['endyear']. '-' .str_pad ($_POST['endmonth'], 2, "0", STR_PAD_LEFT). '-' .str_pad ($_POST['endday'], 2, "0", STR_PAD_LEFT);
44         }
45
46         $sql = "INSERT INTO ".TABLE_PREFIX."reading_list VALUES (NULL, $_SESSION[course_id],
47                 '$_POST[existing]',
48                 '$_POST[readstatus]',
49                 '$date_start',
50                 '$date_end',
51                 '$_POST[comment]'
52                 )";
53         $result = mysql_query($sql,$db);
54
55         $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');
56         header('Location: index_instructor.php');
57         exit;
58 }
59
60 if (isset($_GET['existing'])){
61         $existing = intval ($_GET['existing']);
62 }
63
64 $today = getdate();
65
66 $sql = "SELECT title, resource_id FROM ".TABLE_PREFIX."external_resources WHERE course_id=$_SESSION[course_id] AND type=".RL_TYPE_URL." ORDER BY title";
67 $url_result = mysql_query($sql, $db);
68
69 if (!mysql_num_rows($url_result)) {
70         header('Location: add_resource_url.php?page_return=new_reading_url.php');
71         exit;
72 }
73
74 $onload = 'document.form.name.focus();';
75
76 require(AT_INCLUDE_PATH.'header.inc.php');
77
78 ?>
79 <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" name="form">
80 <div class="input-form">        
81         <fieldset class="group_form"><legend class="group_form"><?php echo _AT('url_to_read'); ?></legend>
82
83         <div class="row">
84                 <label for="urltitle"><?php  echo _AT('rl_select_url'); ?>:</label>
85                 <select name="existing" id="urltitle">
86
87                         <?php while ($row = mysql_fetch_assoc($url_result)): ?>
88                                 <option value="<?php echo $row['resource_id']; ?>"<?php if ($row['resource_id'] == $existing) { echo ' selected="selected"'; } ?>><?php echo htmlspecialchars($row['title']); ?></option>
89                         <?php endwhile; ?>
90                 
91                 </select>
92
93                 <?php  echo _AT('rl_or'); ?> <a href="mods/_standard/reading_list/add_resource_url.php"><?php  echo _AT('rl_create_new_url'); ?></a>
94         </div>
95
96         <div class="row">
97                 <input type="radio" name="readstatus" value="required" id="required" <?php
98                 if (isset($_POST['readstatus'])){
99                         if ($_POST['readstatus'] == 'required'){
100                                 echo 'checked="checked"';
101                         }
102                 }
103                 else {
104                         echo 'checked="checked"';
105                 }?>/>
106                 <label for="required"><?php  echo _AT('required'); ?></label>
107                 <input type="radio" name="readstatus" value="optional" id="optional" <?php if (isset($_POST['readstatus']) && ($_POST['readstatus'] == 'optional')) { echo ' checked="checked"'; } ?>/>
108                 <label for="optional"><?php  echo _AT('optional'); ?></label>
109         </div>  
110         
111         <div class="row">
112         <label for="comment"><?php  echo _AT('comment'); ?>:</label><input type="text" id="comment" size="75" name="comment" value="<?php if (isset($_POST['comment'])) echo $stripslashes($_POST['comment']);  ?>" />
113         </div>
114
115 <h3><?php echo _AT('rl_read_by_date'); ?></h3>
116
117         <div class="row">
118                 <input type="radio" id="nodate" name="hasdate" value="false" <?php
119                 if (isset($_POST['hasdate'])){
120                         if ($_POST['hasdate'] != 'true'){
121                                 echo ' checked="checked"';
122                         }
123                 }
124                 else {
125                         echo ' checked="checked"';
126                 }?>/>
127                 <label for="nodate"><?php  echo _AT('rl_no_read_by_date'); ?></label>
128         </div>
129
130         <div class="row">
131                 <input type="radio" id="hasdate" name="hasdate" value="true" <?php if (isset($_POST['hasdate']) && ($_POST['hasdate'] == 'true')) { echo ' checked="checked"'; } ?>/>
132                 <label for="hasdate"><?php  echo _AT('rl_reading_date'); ?></label><br/>
133
134                 <label for="startdate"><?php  echo _AT('start_date'); ?>:</label>
135
136                 <select name="startday" id="startdate">
137                 <?php for ($i = 1; $i <= 31; $i++){ ?>
138                         <option value="<?php echo $i ?>" <?php if ($i == $today['mday']) { echo ' selected="selected"'; } ?>><?php echo $i ?></option>
139                 <?php } ?>
140                 </select>
141                 
142                 <select name="startmonth">
143                 <?php for ($i = 1; $i <= 12; $i++){ ?>
144                         <option value="<?php echo $i ?>" <?php if ($i == $today['mon']) { echo ' selected="selected"'; } ?>><?php echo AT_Date('%M', $i, AT_DATE_INDEX_VALUE) ?></option>
145                 <?php } ?>
146                 </select>
147
148                 <select name="startyear">
149                 <?php for ($i = ($today['year'] - 1); $i <= ($today['year'] + 4); $i++){ ?>
150                         <option value="<?php echo $i ?>" <?php if ($i == $today['year']) { echo ' selected="selected"'; } ?>><?php echo $i ?></option>
151                 <?php } ?>
152                 </select>
153         
154         
155                 <br/><label for="enddate"><?php  echo _AT('end_date'); ?>:</label>
156
157                 <select name="endday" id="enddate">
158                 <?php for ($i = 1; $i <= 31; $i++){ ?>
159                         <option value="<?php echo $i ?>" <?php if ($i == $today['mday']) { echo ' selected="selected"'; } ?>><?php echo $i ?></option>
160                 <?php } ?>
161                 </select>
162         
163                 <select name="endmonth">
164                 <?php for ($i = 1; $i <= 12; $i++){ ?>
165                         <option value="<?php echo $i ?>" <?php if ($i == $today['mon']) { echo ' selected="selected"'; } ?>><?php echo AT_Date('%M', $i, AT_DATE_INDEX_VALUE) ?></option>
166                 <?php } ?>
167                 </select>
168         
169                 <select name="endyear">
170                 <?php for ($i = ($today['year'] - 1); $i <= ($today['year'] + 4); $i++){ ?>
171                         <option value="<?php echo $i ?>" <?php if ($i == $today['year']) { echo ' selected="selected"'; } ?>><?php echo $i ?></option>
172                 <?php } ?>
173                 </select>       
174         </div>
175
176         <div class="row buttons">
177                 <input type="submit" name="submit" value="<?php echo _AT('save'); ?>" accesskey="s" />
178                 <input type="submit" name="cancel" value="<?php echo _AT('cancel'); ?>" />
179         </div>
180         </fieldset>
181 </div>
182 </form>
183
184 <?php require(AT_INCLUDE_PATH.'footer.inc.php'); ?>