EliteConf
 All Data Structures Namespaces Files Functions Variables Pages
AdmintableviewController.php
Go to the documentation of this file.
1 <?php
7 class AdmintableviewController extends Controller
8 {
9 
10  public function actionIndex()
11  {
12  $this->render('index');
13  }
14 
18  public function viewall()
19  {
20 
21  $sorting = $_GET['sort'];
22 
23  echo "<form action='index.php?r=approvepaper/index' method='post'>";
24 
25  echo("");
26 
27  echo("<BR>");
28  echo("<table border=3>");
29 
30  echo("<tr>
31  <th><a href=./index.php?r=admintableview/index&sort=1><h3>Paper Id </h3></a></th>
32  <th><a href=./index.php?r=admintableview/index&sort=2><h3>Paper Name </h3></a></th>
33  <th><h3>Evaluations</h3></th>
34  <th><a href=./index.php?r=admintableview/index&sort=4><h3>Author </h3></a></th>
35  <th><a href=./index.php?r=admintableview/index&sort=5><h3>Conference</h3> </a></th>
36  <th><h3>Approve</h3></th>
37  <th><h3>Reject</h3></th></tr>");
38 
39  $checked = "";
40 
41  Connect_DatabaseController::connect();
42 
43  if(Yii::app()->user->id != NULL)
44  $usid = Yii::app()->user->id;
45  else
46  $usid = 0;
47 
48  $app = "not approved";
49 
50  if($sorting==1)
51  {
52  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN
53  (SELECT paperid FROM conference_paper WHERE conferenceid IN
54  (SELECT conferenceid FROM conference_user_type WHERE userid=$usid AND usertype=1)
55  ) AND id IN (SELECT paper_id FROM paper_evaluation)");
56 
57  while($row = mysql_fetch_array($allpapers))
58  {
59 
60  $papername = $row['name'];
61  $paperid = $row['id'];
62  $papersize = $row['paper_size'];
63  $approved = $row['approved'];
64 // save
65  if($row['saved_approval']==1) $checked1="checked";
66  else $checked1="";
67 
68  if($row['saved_approval']==2) $checked2="checked";
69  else $checked2="";
70 
71  $authors = mysql_query("SELECT * FROM users WHERE userid
72  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
73 
74  if($approved == 0) $app = "not approved";
75  else if($approved == 1) $app = "approved";
76  else if($approved == 2) $app = "rejected";
77 
78  while($row2 = mysql_fetch_array($authors))
79  {
80 
81  $authorname = $row2['username'];
82 
83  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
84  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
85 
86  while($row3 = mysql_fetch_array($conferences))
87  {
88 
89 
90 
91  $conferencename = $row3['name'];
92 
93 
94 // echo "<a href='javascript:popup()'>Here is a popup window.</a>";
95  echo(" <tr><th>");
96  echo($paperid . "(" . $app . ")");
97  echo(" </th><th>");
98  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
99 
100  echo(" </th><th>");
101  echo "<a href='javascript:popup($paperid)'>View Evaluations</a>";
102  echo "<script type='text/javascript'>";
103  echo "function popup(paperid){cuteLittleWindow = window.open('./index.php?r=adminviewevaluations/index&paperid=' + paperid, 'littleWindow', 'location=no,width=800,height=800'); }";
104  echo "</script>";
105 
106  echo("</th> <th>");
107  echo("$authorname");
108  echo("</th> <th>");
109  echo("$conferencename");
110  echo("</th> <th>");
111  echo "<input type='checkbox' name='approve[]' value=$paperid $checked1>";
112  echo("</th> <th>");
113  echo "<input type='checkbox' name='reject[]' value=$paperid $checked2>";
114  echo "<input hidden name='val' value='$paperid'>";
115  echo("</tr> ");
116  }
117 
118 
119  }
120  }
121  }
122 
123  else if($sorting==2)
124  {
125  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM conference_paper WHERE conferenceid IN
126  (SELECT conferenceid FROM conference_user_type WHERE userid=$usid AND usertype=1))
127  AND id IN (SELECT paper_id FROM paper_evaluation) ORDER BY paper_name");
128 
129  while($row = mysql_fetch_array($allpapers))
130  {
131 
132  $papername = $row['name'];
133  $paperid = $row['id'];
134  $papersize = $row['paper_size'];
135  $approved = $row['approved'];
136 
137 // save
138  if($row['saved_approval']==1) $checked1="checked";
139  else $checked1="";
140 
141  if($row['saved_approval']==2) $checked2="checked";
142  else $checked2="";
143 
144  if($approved == 0) $app = "not approved";
145  else if($approved == 1) $app = "approved";
146  else if($approved == 2) $app = "rejected";
147 
148  $authors = mysql_query("SELECT * FROM users WHERE userid
149  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
150 
151  while($row2 = mysql_fetch_array($authors))
152  {
153 
154  $authorname = $row2['username'];
155 
156  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
157  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
158 
159  while($row3 = mysql_fetch_array($conferences))
160  {
161 
162  $conferencename = $row3['name'];
163 
164 
165  echo(" <tr><th>");
166  echo($paperid . "(" . $app . ")");
167  echo(" </th><th>");
168  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
169 
170  echo(" </th><th>");
171  echo "<a href='javascript:popup($paperid)'>View Evaluations</a>";
172  echo "<script type='text/javascript'>";
173  echo "function popup(paperid){cuteLittleWindow = window.open('./index.php?r=adminviewevaluations/index&paperid=' + paperid, 'littleWindow', 'location=no,width=800,height=800'); }";
174  echo "</script>";
175 
176  echo("</th> <th>");
177  echo("$authorname");
178  echo("</th> <th>");
179  echo("$conferencename");
180  echo("</th> <th>");
181  echo "<input type='checkbox' name='approve[]' value=$paperid $checked1>";
182  echo("</th> <th>");
183  echo "<input type='checkbox' name='reject[]' value=$paperid $checked2>";
184  echo "<input hidden name='val' value='$paperid'>";
185  echo("</tr> ");
186 
187  }
188 
189 
190  }
191  }
192  }
193 
194 
195  else if($sorting==4)
196  {
197  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM conference_paper WHERE conferenceid IN
198  (SELECT conferenceid FROM conference_user_type WHERE userid=$usid AND usertype=1
199  AND paperid IN
200  (SELECT paperid FROM paper_author WHERE userid IN
201  (SELECT userid FROM users ORDER BY userid)) ORDER BY userid))
202  AND id IN (SELECT paper_id FROM paper_evaluation)");
203 
204  while($row = mysql_fetch_array($allpapers))
205  {
206 
207  $papername = $row['name'];
208  $paperid = $row['id'];
209  $papersize = $row['paper_size'];
210  $approved = $row['approved'];
211 
212 // save
213  if($row['saved_approval']==1) $checked1="checked";
214  else $checked1="";
215 
216  if($row['saved_approval']==2) $checked2="checked";
217  else $checked2="";
218 
219  if($approved == 0) $app = "not approved";
220  else if($approved == 1) $app = "approved";
221  else if($approved == 2) $app = "rejected";
222 
223  $authors = mysql_query("SELECT * FROM users WHERE userid
224  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
225 
226  while($row2 = mysql_fetch_array($authors))
227  {
228 
229  $authorname = $row2['username'];
230 
231  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
232  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
233 
234  while($row3 = mysql_fetch_array($conferences))
235  {
236 
237  $conferencename = $row3['name'];
238 
239  echo(" <tr><th>");
240  echo($paperid . "(" . $app . ")");
241  echo(" </th><th>");
242  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
243 
244  echo(" </th><th>");
245  echo "<a href='javascript:popup($paperid)'>View Evaluations</a>";
246  echo "<script type='text/javascript'>";
247  echo "function popup(paperid){cuteLittleWindow = window.open('./index.php?r=adminviewevaluations/index&paperid=' + paperid, 'littleWindow', 'location=no,width=800,height=800'); }";
248  echo "</script>";
249 
250  echo("</th> <th>");
251  echo("$authorname");
252  echo("</th> <th>");
253  echo("$conferencename");
254  echo("</th> <th>");
255  echo "<input type='checkbox' name='approve[]' value=$paperid $checked1>";
256  echo("</th> <th>");
257  echo "<input type='checkbox' name='reject[]' value=$paperid $checked2>";
258  echo "<input hidden name='val' value='$paperid'>";
259  echo("</tr> ");
260  }
261 
262 
263  }
264  }
265  }
266 
267 
268  else if($sorting==5)
269  {
270 
271  $allpapers = mysql_query("SELECT * FROM paper WHERE id IN (SELECT paperid FROM conference_paper WHERE conferenceid IN
272  (SELECT conferenceid FROM conference_user_type WHERE userid=$usid AND usertype=1 ORDER BY conferenceid))
273  AND id IN (SELECT paper_id FROM paper_evaluation)");
274 
275  while($row = mysql_fetch_array($allpapers))
276  {
277 
278  $papername = $row['name'];
279  $paperid = $row['id'];
280  $papersize = $row['paper_size'];
281  $approved = $row['approved'];
282 
283 // save
284  if($row['saved_approval']==1) $checked1="checked";
285  else $checked1="";
286 
287  if($row['saved_approval']==2) $checked2="checked";
288  else $checked2="";
289 
290  if($approved == 0) $app = "not approved";
291  else if($approved == 1) $app = "approved";
292  else if($approved == 2) $app = "rejected";
293 
294  $authors = mysql_query("SELECT * FROM users WHERE userid
295  IN (SELECT userid FROM paper_author WHERE paperid=$paperid)");
296 
297  while($row2 = mysql_fetch_array($authors))
298  {
299 
300  $authorname = $row2['username'];
301 
302  $conferences = mysql_query("SELECT * FROM conference WHERE conferenceid
303  IN (SELECT conferenceid FROM conference_paper WHERE paperid = $paperid)");
304 
305  while($row3 = mysql_fetch_array($conferences))
306  {
307 
308  $conferencename = $row3['name'];
309 
310  echo(" <tr><th>");
311  echo($paperid . "(" . $app . ")");
312  echo(" </th><th>");
313  echo "<a href=\" ./index.php?r=paper/view&id=$paperid\">$papername</a>";
314 
315  echo(" </th><th>");
316  echo "<a href='javascript:popup($paperid)'>View Evaluations</a>";
317  echo "<script type='text/javascript'>";
318  echo "function popup(paperid){cuteLittleWindow = window.open('./index.php?r=adminviewevaluations/index&paperid=' + paperid, 'littleWindow', 'location=no,width=800,height=800'); }";
319  echo "</script>";
320 
321  echo("</th> <th>");
322  echo("$authorname");
323  echo("</th> <th>");
324  echo("$conferencename");
325  echo("</th> <th>");
326  echo "<input type='checkbox' name='approve[]' value=$paperid $checked1>";
327  echo("</th> <th>");
328  echo "<input type='checkbox' name='reject[]' value=$paperid $checked2>";
329  echo "<input hidden name='val' value='$paperid'>";
330  echo("</tr> ");
331  }
332 
333 
334  }
335  }
336  }
337  echo("</table>");
338 
339  echo "<input type='submit' name='formSubmit' value='Submit Selections' />";
340 
341  echo "<input type='submit' name='formSubmit2' value='Save Selections' />";
342 echo "</form>";
343 
344  echo"</form>";
345 
346  }
347  // Uncomment the following methods and override them if needed
348  /*
349  public function filters()
350  {
351  // return the filter configuration for this controller, e.g.:
352  return array(
353  'inlineFilterName',
354  array(
355  'class'=>'path.to.FilterClass',
356  'propertyName'=>'propertyValue',
357  ),
358  );
359  }
360 
361  public function actions()
362  {
363  // return external action classes, e.g.:
364  return array(
365  'action1'=>'path.to.ActionClass',
366  'action2'=>array(
367  'class'=>'path.to.AnotherActionClass',
368  'propertyName'=>'propertyValue',
369  ),
370  );
371  }
372  */
373 
374 }
Generated on Sun Jun 2 2013 05:35:37 for EliteConf by   doxygen 1.8.4