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
|
<?php
assert_redir(count($args) == 3, 'study');
$studyid = intval($args[2]);
$study = mysql_fetch_assoc(sql(
"SELECT lists.id AS listid, lists.name AS listname, account.login AS listowner, ".
" list_study.user AS learn_user ".
"FROM list_study LEFT JOIN lists ON list_study.list = lists.id LEFT JOIN account ON account.id = lists.owner ".
"WHERE list_study.id = $studyid"));
assert_error($study && $study['learn_user'] == $user['id'], "You are not at the right place here.");
$filters = array(
"order" => array(
"name" => "name",
"lr_score" => "last score",
"lr_date" => "last reviewed"
),
"way" => $ord_ways,
);
$fdefaults = array(
"order" => "name",
"way" => "ASC",
);
$batches = array();
$n = sql(
"SELECT batches.id AS id, batches.name AS name, ".
"batch_study.id AS bs_id, ba.date AS lr_date, TO_DAYS(NOW()) - TO_DAYS(ba.date) AS lr_days, ".
"ba.score AS lr_score, bc.date AS blr_date, bc.score AS blr_score, ".
"COUNT(bb.id) AS num_reviews ".
"FROM batches ".
"LEFT JOIN batch_study ON batch_study.batch = batches.id AND batch_study.user = " . $user['id'] . " " .
"LEFT JOIN batch_review ba ON ba.id = batch_study.last_review ".
"LEFT JOIN batch_review bb ON bb.batch = batches.id AND bb.user = " . $user['id'] . " ".
"LEFT JOIN batch_review bc ON bc.id = batch_study.before_last_review ".
"WHERE batches.list = " . $study['listid'] . " " .
"GROUP BY batches.id ".
"ORDER BY " . get_filter("order") . " " . get_filter("way")
);
while ($b = mysql_fetch_assoc($n)) $batches[] = $b;
require("tpl/study/list.php");
|