-
Notifications
You must be signed in to change notification settings - Fork 9
/
show-note-categories.php
66 lines (45 loc) · 2.1 KB
/
show-note-categories.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
<?php
require 'class.base.php';
require 'class.html.php';
$base_instance=new base();
$html_instance=new html();
$userid=$base_instance->get_userid();
$html_instance->add_parameter(
array('ACTION'=>'show_content',
'ENTITY'=>'NOTE',
'SUBENTITY'=>'CATEGORY',
'MAXHITS'=>40,
'WHERE'=>"WHERE user='$userid'",
'ORDER_COL'=>'title',
'ORDER_TYPE'=>'ASC',
'HEADER'=>'Notes Categories <a href="add-note-category.php">[Add Category]</a>',
'INNER_TABLE_WIDTH'=>'80%'
));
$data=$html_instance->get_items();
if (!$data) { $base_instance->show_message('No notes categories added yet','<a href="add-note-category.php">[Add new Category]</a>'); }
else {
$all_text='<table width="100%" border cellspacing=0 cellpadding=5 class="pastel">';
for ($index=1; $index <= sizeof($data); $index++) {
$ID=$data[$index]->ID;
$title=$data[$index]->title;
#
$data2=$base_instance->get_data("SELECT COUNT(*) AS total FROM {$base_instance->entity['NOTE']['MAIN']} WHERE user='$userid' AND category=$ID");
$number_note=$data2[1]->total;
$all_text.='<tr onMouseOver=\'this.style.background="#e9e9e9"\' onMouseOut=\'this.style.background="#ffffff"\'>
<td width=140><a href="show-note.php?category_id='.$ID.'"><strong>'.$title.'</strong></a></td>
<td align="left"><strong>Total:</strong> '.$number_note.'</td>
<td align="center"><a href="add-note.php?category_id='.$ID.'">[Add]</a></td>
<td align="center"><a href="show-note.php?category_id='.$ID.'">[Show]</a></td>
<td align="center"><a href="show-note-print.php?category_id='.$ID.'" target="_blank">[Print]</a></td>
<td align="center"><a href="search-note.php?category_id='.$ID.'">[Search]</a></td>
<td align="center"><a href="edit-note-category.php?category_id='.$ID.'">[Edit]</a></td>
<td align="center"><a href="merge-note-category.php?category_id='.$ID.'">[Merge]</a></td>
<td align="center"><a href="javascript:void(window.open(\'delete-note-category.php?category_id='.$ID.'\',\'\',\'width=450,height=200,top=100,left=100\'))">[Delete]</a></td>
</tr>';
}
$all_text.='</table>';
}
$content_array[1]=array('MAIN'=>$all_text);
$html_instance->content=$content_array;
$html_instance->process();
?>