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
126
|
<script type="text/javascript">
<!--
function popup_category(page,largeur,hauteur,options)
{
var top=(screen.height-hauteur)/2;
var left=(screen.width-largeur)/2;
window.open(page,"","top="+top+",left="+left+",width="+largeur+",height="+hauteur+","+options);
}
-->
</script>
<div id="tablewrapper">
<div id="tableheader">
<div class="search">
<select id="columns" onchange="sorter.search('query')"></select>
<input type="text" id="query" onkeyup="sorter.search('query')" />
</div>
<span class="details">
<div>Records <span id="startrecord"></span>-<span id="endrecord"></span> of <span id="totalrecords"></span></div>
<div><a href="javascript:sorter.reset()">reset</a></div>
</span>
</div>
<table cellpadding="0" cellspacing="0" border="0" id="table" class="tinytable">
<thead>
<tr>
<th class="nosort"><h3>ID</h3></th>
<th><h3>Name Category</h3></th>
<th><h3>Category Free</h3></th>
<th><h3>Amount</h3></th>
<th class="nosort"><h3></h3></th>
<th class="nosort"><h3></h3></th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT * FROM category_parent;";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)){
echo "<tr>\n";
echo "<td>".$row["cp_id_category_parent"]."</td>\n";
echo "<td><a href=\"".htmlentities("?section=manage_category_child&id=".$row["cp_id_category_parent"]."")."\">".$row["cp_name_category"]."</a></td>\n";
if($row["cp_free"] == 0){
echo "<td>No</td>\n";
}else{
echo "<td>Yes</td>\n";
}
echo "<td>".$row["cp_amount"]."</td>\n";
if($row["cp_active"] == 1){
echo "<td><a href=\"".htmlentities("?section=active_category&id=".$row["cp_id_category_parent"]."")."\"><img src=\"css/img/yes.png\" width=\"16\" height=\"16\" title=\"Active: Yes\" alt=\"Yes\" /></a></td>\n";
}else{
echo "<td><a href=\"".htmlentities("?section=active_category&id=".$row["cp_id_category_parent"]."")."\"><img src=\"css/img/delete.png\" width=\"16\" height=\"16\" title=\"Active: No\" alt=\"No\" /></a></td>\n";
}
?>
<td><a name="tagada" href='javascript:popup_category("<?php echo htmlentities("?section=edit_category&id=".$row["cp_id_category_parent"]."");?>",500,500,"location=no,resizable=no,menubar=no,scrollbars=no,statusbar=no")'><img src="css/img/edit.png" width="16" height="16" title="Edit the category" alt="edit" /></a></td>
<?
//echo "<td><a href=\"".htmlentities("?section=edit_category&id=".$row["cp_id_category_parent"]."")."\"><img src=\"css/img/edit.png\" width=\"16\" height=\"16\" title=\"Edit the category\" alt=\"edit\" /></a></td>\n";
echo "</tr>\n";
}
?>
</tbody>
</table>
<table cellpadding="0" cellspacing="0" border="0" class="tinytable">
<tbody>
</tbody>
</table>
<div id="tablefooter">
<div id="tablenav">
<div>
<img src="css/img/first.gif" width="16" height="16" alt="First Page" onclick="sorter.move(-1,true)" />
<img src="css/img/previous.gif" width="16" height="16" alt="First Page" onclick="sorter.move(-1)" />
<img src="css/img/next.gif" width="16" height="16" alt="First Page" onclick="sorter.move(1)" />
<img src="css/img/last.gif" width="16" height="16" alt="Last Page" onclick="sorter.move(1,true)" />
</div>
<div>
<select id="pagedropdown"></select>
</div>
<div>
<a href="javascript:sorter.showall()">view all</a>
</div>
</div>
<div id="tablelocation">
<div>
<select onchange="sorter.size(this.value)">
<option value="5">5</option>
<option value="10" selected="selected">10</option>
<option value="20">20</option>
<option value="50">50</option>
<option value="100">100</option>
</select>
<span>Entries Per Page</span>
</div>
<div class="page">Page <span id="currentpage"></span> of <span id="totalpages"></span></div>
</div>
</div>
</div>
<script type="text/javascript">
var sorter = new TINY.table.sorter('sorter','table',{
headclass:'head',
ascclass:'asc',
descclass:'desc',
evenclass:'evenrow',
oddclass:'oddrow',
evenselclass:'evenselected',
oddselclass:'oddselected',
paginate:true,
size:10,
colddid:'columns',
currentid:'currentpage',
totalid:'totalpages',
startingrecid:'startrecord',
endingrecid:'endrecord',
totalrecid:'totalrecords',
hoverid:'selectedrow',
pageddid:'pagedropdown',
navid:'tablenav',
sortcolumn:1,
sortdir:1,
//sum:[8],
//avg:[6,7,8,9],
columns:[{index:7, format:'%', decimals:1},{index:8, format:'$', decimals:0}],
init:true
});
</script> |
