-
Notifications
You must be signed in to change notification settings - Fork 0
/
itemLists.php
125 lines (110 loc) · 4.36 KB
/
itemLists.php
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
<?php
// rewrite of lists.inc.php and reportLists.php
// called from itemReport.php
$resultListX = query("getchildlists",$config,$values,$sort);
/*
echo '<pre>';
var_dump($config);
var_dump($values);
var_dump($sort);
var_dump($resultListN);
die;
*/
if (is_array($resultListX)) {
foreach ($resultListX as $resultListN) {
$isChecklist = false;
if($resultListN['type']==='c') $isChecklist = true;
if ($isChecklist) {
$type='c';
$check='check';
} else {
$type='l';
$check='';
}
$values=array(
'listId' => $resultListN['listId'],
'itemId' => '',
'categoryId'=> ''
);
$urlSuffix="type=$type";
$resultList = query("select{$check}list",$config,$values,$sort);
if ($resultList==1) {
echo "<p class='error'>{$check}list" . $resultListN['listId'] . " does not exist</p>\n";
exit();
}
$row=$resultList[0];
$values['filterquery']= " AND ".sqlparts("activelistitems",$config,$values);
$resultList1=query("get{$check}listitems",$config,$values,$sort);
if (!$isChecklist) {
$values['filterquery']= " AND ".sqlparts("completedlistitems",$config,$sort);
$resultList2=query("get{$check}listitems",$config,$values,$sort);
if (!$resultList2) $resultList2=array();
}
$createURL="editListItems.php?listId={$row['listId']}&$urlSuffix";
?>
<br>
<h2>The <a href='reportLists.php?listId=<?php echo $row['listId'],'&',$urlSuffix; ?>'>
<?php echo $row['title'],' ',$check; ?></a>list
<?php
if ($row['hyperlink']) {
echo " [ " . faLink($row['hyperlink']) . " ]";
}
?></h2>
<?php if ($resultList1) { ?>
<form action='processLists.php' method='post'>
<table class="datatable sortable" id="itemtable" summary="table of list items">
<thead>
<tr>
<th>Item</th>
<th>Description</th>
<?php if ($type == 'c') { ?>
<th>Completed</th>
<?php } ?>
</tr>
</thead>
<tbody>
<?php foreach($resultList1 as $row) {
if ($row['checked']==='y') {
echo "<tr style=\"display:none\">";
} else {
echo "<tr>";
}
?>
<td class="JKSmallPadding"><a href="editListItems.php?itemId=<?php
echo $row['itemId'],'&',$urlSuffix;
?>" title="Edit"><?php echo makeclean($row['item']); ?></a></td>
<td class="JKSmallPadding">
<?php
echo trimTaggedString($row['notes']);
if ($row['hyperlink']) {
echo "<br><br>" . faLink($row['hyperlink']);
}
?>
</td>
<?php if ($type == 'c') { ?>
<td class="JKSmallPadding"><input type="checkbox" name="completed[]" title="Complete" value="<?php
echo $row['itemId'],'"',($isChecklist && $row['checked']==='y')?" checked='checked' ":'';
?> />
</td>
<?php } ?>
</tr><?php
} ?>
</tbody>
</table>
<div class='formbuttons'>
<?php if ($isChecklist) { ?>
<input type='submit' name='submit' value='update' />
JK
<input type='submit' name='listclear' value='Clear all' />
<?php } ?>
<input type='hidden' name='listId' value='<?php echo $row['listId']; ?>' />
<input type='hidden' name='action' value='listcomplete' />
<input type='hidden' name='source' value='true' />
<input type='hidden' name='type' value='<?php echo $type; ?>' />
</div>
</form>
<?php
}
}
}
?>