forked from ashl1/datatables-rowsgroup
-
Notifications
You must be signed in to change notification settings - Fork 0
/
anotherExample.html
122 lines (111 loc) · 8.78 KB
/
anotherExample.html
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
<html>
<head>
<link rel="stylesheet" href="http://cdn.datatables.net/1.10.7/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
<script src="http://code.jquery.com/jquery-2.1.4.min.js"></script>
<script src="http://cdn.datatables.net/1.10.7/js/jquery.dataTables.js"></script>
<script src="dataTables.rowsGroup.js"></script>
</head>
<body>
<div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
<div class="panel">
<div class="panel-body-users-tab panel-default top-panel">
</div>
<div class="panel-body-users-tab no-padding">
<table id="curriculum-students-dataTable" class="table table-users-tab table-responsive table-striped table-hover">
<thead>
<tr>
<th class="tableColumnMediumWidth">Name</th>
<th class="tableColumnMediumWidth">StudentID</th>
<th class="tableColumnMediumWidth">Email</th>
<th class="tableColumnMediumWidth">Unit</th>
<th class="tableColumnMediumWidth">Placement</th>
<th class="tableColumnMediumWidth">Site</th>
<th class="tableColumnMediumWidth">Section</th>
<th class="tableColumnMediumWidth">AdvisorSection</th>
</tr>
</thead>
<tbody></tbody>
</table>
</div>
</div>
</div>
</body>
<script type="text/javascript">
var model=[{"UserId":1311,"Email":"[email protected]","Password":null,"LastName":"Lopez","FirstName":"Carlos","StudentOrTeacherRegistrationNumber":"805687001","Section":"2","AdvisorSection":"0","Placement":"NoPlacement","Site":"NoSite","Unit":"NoUnit","UnitId":233,"StudentOrTeacherUnitId":3520},
{"UserId":1319,"Email":"[email protected]","Password":null,"LastName":"Griffin","FirstName":"David","StudentOrTeacherRegistrationNumber":"804790491 ","Section":"7930sdd","AdvisorSection":"0ass","Placement":"NoPlacement","Site":"NoSite","Unit":"NoUnit","UnitId":233,"StudentOrTeacherUnitId":3502},
{"UserId":1648,"Email":"[email protected]","Password":null,"LastName":"Meyer","FirstName":"Scott","StudentOrTeacherRegistrationNumber":"N00686366 ","Section":"7930","AdvisorSection":"0","Placement":"Agency","Site":"Bridgepoint","Unit":"2155-8","UnitId":177,"StudentOrTeacherUnitId":3503},
{"UserId":1693,"Email":"[email protected]","Password":null,"LastName":"Long","FirstName":"Robin","StudentOrTeacherRegistrationNumber":"bllk0246","Section":"7930","AdvisorSection":"0","Placement":"NoPlacement","Site":"NoSite","Unit":"NoUnit","UnitId":233,"StudentOrTeacherUnitId":3504},
{"UserId":1738,"Email":"[email protected]","Password":null,"LastName":"Long","FirstName":"Robin","StudentOrTeacherRegistrationNumber":"bllk0246","Section":"7930","AdvisorSection":"0","Placement":"Agency","Site":"Bridgepoint","Unit":"2155-8","UnitId":177,"StudentOrTeacherUnitId":3505},
{"UserId":1739,"Email":"[email protected]","Password":null,"LastName":"Long","FirstName":"Michael","StudentOrTeacherRegistrationNumber":"bkrj0147 ","Section":"7930","AdvisorSection":"0","Placement":"Agency","Site":"Bridgepoint","Unit":"2155-8","UnitId":177,"StudentOrTeacherUnitId":3506},
{"UserId":1740,"Email":"[email protected]","Password":null,"LastName":"Ray","FirstName":"Ernest","StudentOrTeacherRegistrationNumber":"dmch0050 ","Section":"7930","AdvisorSection":"0","Placement":"Agency","Site":"Bridgepoint","Unit":"2155-8","UnitId":177,"StudentOrTeacherUnitId":3507},
{"UserId":1755,"Email":"[email protected]","Password":null,"LastName":"Robertson","FirstName":"Joyce","StudentOrTeacherRegistrationNumber":"brdm0412 ","Section":"7930","AdvisorSection":"0","Placement":"Agency","Site":"Bridgepoint","Unit":"2155-8","UnitId":177,"StudentOrTeacherUnitId":3508},
{"UserId":1877,"Email":"[email protected]","Password":null,"LastName":"Wells","FirstName":"Clarence","StudentOrTeacherRegistrationNumber":"dmmr0027 ","Section":"7930","AdvisorSection":"0","Placement":"Agency","Site":"Bridgepoint","Unit":"2155-8","UnitId":177,"StudentOrTeacherUnitId":3509},
{"UserId":2093,"Email":"[email protected]","Password":null,"LastName":"Mills","FirstName":"Jeremy","StudentOrTeacherRegistrationNumber":"N00397173 ","Section":"7930","AdvisorSection":"0","Placement":"Agency","Site":"Bridgepoint","Unit":"2155-8","UnitId":177,"StudentOrTeacherUnitId":3510},
{"UserId":2307,"Email":"[email protected]","Password":null,"LastName":"Parker","FirstName":"Rachel","StudentOrTeacherRegistrationNumber":"N00118511 ","Section":"7930","AdvisorSection":"0","Placement":"Agency","Site":"Bridgepoint","Unit":"2155-8","UnitId":177,"StudentOrTeacherUnitId":3511},
{"UserId":2350,"Email":"[email protected]","Password":null,"LastName":"Wright","FirstName":"Frank","StudentOrTeacherRegistrationNumber":"N00307407 ","Section":"7930","AdvisorSection":"0","Placement":"Agency","Site":"Bridgepoint","Unit":"2155-8","UnitId":177,"StudentOrTeacherUnitId":3512},
{"UserId":2434,"Email":"[email protected]","Password":null,"LastName":"Harvey","FirstName":"Charles","StudentOrTeacherRegistrationNumber":"N00581144 ","Section":"7930","AdvisorSection":"0","Placement":"Agency","Site":"Bridgepoint","Unit":"2155-8","UnitId":177,"StudentOrTeacherUnitId":3513},
{"UserId":4812,"Email":"[email protected]","Password":null,"LastName":"lns12","FirstName":"fs12","StudentOrTeacherRegistrationNumber":"22","Section":"12","AdvisorSection":"34","Placement":"Agency","Site":"Dixon Grove JMS","Unit":"U8","UnitId":59,"StudentOrTeacherUnitId":3525},
{"UserId":4812,"Email":"[email protected]","Password":null,"LastName":"lns12","FirstName":"fs12","StudentOrTeacherRegistrationNumber":"22","Section":"2","AdvisorSection":"2","Placement":"NoPlacement","Site":"NoSite","Unit":"NoUnit","UnitId":233,"StudentOrTeacherUnitId":3514},
{"UserId":4812,"Email":"[email protected]","Password":null,"LastName":"lns12","FirstName":"fs12","StudentOrTeacherRegistrationNumber":"22","Section":"45","AdvisorSection":"56","Placement":"Agency","Site":"AIDS Committee of Toronto (ACT)","Unit":"U3","UnitId":53,"StudentOrTeacherUnitId":3524},
{"UserId":4813,"Email":"[email protected]","Password":null,"LastName":"lns13","FirstName":"fs13","StudentOrTeacherRegistrationNumber":"3","Section":"2","AdvisorSection":"33","Placement":"NoPlacement","Site":"NoSite","Unit":"NoUnit","UnitId":233,"StudentOrTeacherUnitId":3515},
{"UserId":4813,"Email":"[email protected]","Password":null,"LastName":"lns13","FirstName":"fs13","StudentOrTeacherRegistrationNumber":"3","Section":"gh","AdvisorSection":"hj","Placement":"Kindergarten","Site":"Claireville \u0026 James Bell","Unit":"K8","UnitId":97,"StudentOrTeacherUnitId":3526},
{"UserId":4815,"Email":"[email protected]","Password":null,"LastName":"lns15","FirstName":"fs15","StudentOrTeacherRegistrationNumber":"5","Section":"2","AdvisorSection":"5","Placement":"NoPlacement","Site":"NoSite","Unit":"NoUnit","UnitId":233,"StudentOrTeacherUnitId":3516},
{"UserId":4816,"Email":"[email protected]","Password":null,"LastName":"lns16","FirstName":"fs16","StudentOrTeacherRegistrationNumber":"6","Section":"2","AdvisorSection":"77","Placement":"NoPlacement","Site":"NoSite","Unit":"NoUnit","UnitId":233,"StudentOrTeacherUnitId":3517},
{"UserId":5068,"Email":"[email protected]","Password":null,"LastName":"raaaaa","FirstName":"raaaraa","StudentOrTeacherRegistrationNumber":"666","Section":"2","AdvisorSection":"asdsa","Placement":"NoPlacement","Site":"NoSite","Unit":"NoUnit","UnitId":233,"StudentOrTeacherUnitId":3518},
{"UserId":5072,"Email":"[email protected]","Password":null,"LastName":"dfhdshs","FirstName":"fdhdfe","StudentOrTeacherRegistrationNumber":"455235","Section":"2","AdvisorSection":"asdsa","Placement":"NoPlacement","Site":"NoSite","Unit":"NoUnit","UnitId":233,"StudentOrTeacherUnitId":3519}];
var curriculumStudentsDataTable;
$(document).ready(function () {
DisplayStudentsCurriculumTableData(model);
});
function DisplayStudentsCurriculumTableData(model) {
curriculumStudentsDataTable = $('#curriculum-students-dataTable').dataTable({
//"bRetrieve": true,
"sPaginationType": "full_numbers",
paging: true,
//"bProcessing": true,
//"bAutoWidth": false,
//"bStateSave": true,
"aaSorting": [[1, 'asc']],
"aaData": model,
rowsGroup: [0,1,2],
"aoColumns": [
{
"data": function (data) {
return data.LastName+ ', ' +data.FirstName;
},
sDefaultContent: ""
},
{
"data": "StudentOrTeacherRegistrationNumber",
sDefaultContent: ""
},
{
"data": "Email",
sDefaultContent: ""
},
{
"data": "Unit",
sDefaultContent: ""
},
{
"data": "Placement",
sDefaultContent: ""
},
{
"data": "Site",
sDefaultContent: ""
},
{
"data": "Section",
sDefaultContent: ""
},
{
"data": "AdvisorSection",
sDefaultContent: ""
}
]
});
}
</script>
</html>