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