001.
<?php
002.
function
SheetStatus(
$Type
)
003.
{
004.
if
(
$Type
==
"ACTIVE"
)
005.
{
006.
$Icons
=
"<div class='btn btn-lg btn-eable btn-circle'></div>"
;
007.
return
$Icons
;
008.
}
009.
else
010.
{
011.
$Icons
=
"<div class='btn btn-lg btn-disable btn-circle'></div>"
;
012.
return
$Icons
;
013.
}
014.
}
015.
016.
017.
$aColumns
=
array
(
'Sheet_Name'
,
'Sheet_Detail'
,
'Sheet_Date'
,
'Sheet_Status'
,
'Sheet_Count'
,
'Sheet_Author'
,
'SheetID'
);
018.
019.
020.
$sIndexColumn
=
"SheetID"
;
021.
022.
023.
$sTable
=
"tb_sheet"
;
024.
025.
026.
$gaSql
[
'user'
] =
"root"
;
027.
$gaSql
[
'password'
] =
"12345678"
;
028.
$gaSql
[
'db'
] =
"edoc"
;
029.
$gaSql
[
'server'
] =
"localhost"
;
030.
031.
032.
033.
$gaSql
[
'link'
] = mysql_pconnect(
$gaSql
[
'server'
],
$gaSql
[
'user'
],
$gaSql
[
'password'
] )
or
034.
die
(
'Could not open connection to server'
);
035.
036.
mysql_select_db(
$gaSql
[
'db'
],
$gaSql
[
'link'
] )
or
037.
die
(
'Could not select database '
.
$gaSql
[
'db'
] );
038.
mysql_query(
"SET NAMES UTF8"
);
039.
040.
$sLimit
=
""
;
041.
if
( isset(
$_GET
[
'iDisplayStart'
] ) &&
$_GET
[
'iDisplayLength'
] !=
'-1'
)
042.
{
043.
$sLimit
=
"LIMIT "
.mysql_real_escape_string(
$_GET
[
'iDisplayStart'
] ).
", "
.
044.
mysql_real_escape_string(
$_GET
[
'iDisplayLength'
] );
045.
}
046.
047.
$sOrder
=
""
;
048.
if
( isset(
$_GET
[
'iSortCol_0'
] ) )
049.
{
050.
$sOrder
=
"ORDER BY "
;
051.
for
(
$i
=0 ;
$i
<
intval
(
$_GET
[
'iSortingCols'
] ) ;
$i
++ )
052.
{
053.
if
(
$_GET
[
'bSortable_'
.
intval
(
$_GET
[
'iSortCol_'
.
$i
]) ] ==
"true"
)
054.
{
055.
$sOrder
.=
$aColumns
[
intval
(
$_GET
[
'iSortCol_'
.
$i
] ) ]."
056.
".mysql_real_escape_string( $_GET['sSortDir_'.$i] ) ."
, ";
057.
}
058.
}
059.
060.
$sOrder
= substr_replace(
$sOrder
,
""
, -2 );
061.
if
(
$sOrder
==
"ORDER BY"
)
062.
{
063.
$sOrder
=
""
;
064.
}
065.
}
066.
$sWhere
=
""
;
067.
if
( isset(
$_GET
[
'sSearch'
]) &&
$_GET
[
'sSearch'
] !=
""
)
068.
{
069.
$sWhere
=
"WHERE ("
;
070.
for
(
$i
=0 ;
$i
<
count
(
$aColumns
) ;
$i
++ )
071.
{
072.
$sWhere
.=
$aColumns
[
$i
].
" LIKE '%"
.mysql_real_escape_string(
$_GET
['sSearch
'] )."%'
OR ";
073.
}
074.
$sWhere
= substr_replace(
$sWhere
,
""
, -3 );
075.
$sWhere
.=
')'
;
076.
}
077.
078.
for
(
$i
=0 ;
$i
<
count
(
$aColumns
) ;
$i
++ )
079.
{
080.
if
( isset(
$_GET
[
'bSearchable_'
.
$i
]) &&
$_GET
[
'bSearchable_'
.
$i
] ==
"true"
&&
$_GET
[
'sSearch_'
.
$i
] !=
''
)
081.
{
082.
if
(
$sWhere
==
""
)
083.
{
084.
$sWhere
=
"WHERE "
;
085.
}
086.
else
087.
{
088.
$sWhere
.=
" AND "
;
089.
}
090.
$sWhere
.=
$aColumns
[
$i
].
" LIKE '%"
.mysql_real_escape_string(
$_GET
['sSearch_
'.$i])."%'
";
091.
}
092.
}
093.
094.
$sQuery
= "
095.
SELECT SQL_CALC_FOUND_ROWS
".str_replace("
,
", "
", implode("
,
", $aColumns))."
096.
FROM
$sTable
097.
$sWhere
098.
$sOrder
099.
$sLimit
100.
";
101.
$rResult
= mysql_query(
$sQuery
,
$gaSql
[
'link'
] )
or
die
(mysql_error());
102.
103.
104.
$sQuery
= "
105.
SELECT FOUND_ROWS()
106.
";
107.
$rResultFilterTotal
= mysql_query(
$sQuery
,
$gaSql
[
'link'
] )
or
die
(mysql_error());
108.
$aResultFilterTotal
= mysql_fetch_array(
$rResultFilterTotal
);
109.
$iFilteredTotal
=
$aResultFilterTotal
[0];
110.
111.
112.
$sQuery
= "
113.
SELECT
COUNT
(
".$sIndexColumn."
)
114.
FROM
$sTable
115.
";
116.
$rResultTotal
= mysql_query(
$sQuery
,
$gaSql
[
'link'
] )
or
die
(mysql_error());
117.
$aResultTotal
= mysql_fetch_array(
$rResultTotal
);
118.
$iTotal
=
$aResultTotal
[0];
119.
120.
$output
=
array
(
121.
"sEcho"
=>
intval
(
$_GET
[
'sEcho'
]),
122.
"iTotalRecords"
=>
$iTotal
,
123.
"iTotalDisplayRecords"
=>
$iFilteredTotal
,
124.
"aaData"
=>
array
()
125.
);
126.
while
(
$aRow
= mysql_fetch_array(
$rResult
) )
127.
{
128.
$row
=
array
();
129.
130.
for
(
$i
=0 ;
$i
<
count
(
$aColumns
) ;
$i
++ )
131.
{
132.
if
(
$aColumns
[
$i
] ==
"SheetID"
)
133.
{
134.
$SheetID
=
$aRow
[
'SheetID'
];
135.
136.
$row
[] = "
137.
138.
<a
class
=
'view'
data-fancybox-type=
'iframe'
href=
'teacher/sheet_change.php?UserID=".$SheetID."&do=sheetview'
><div
class
=
'btn btn-sm btn-outline-secondary'
><strong>view</strong></div></a>
139.
<a
class
=
'edit'
data-fancybox-type=
'iframe'
href=
'teacher/sheet_change.php?UserID=".$SheetID."&do=sheetedit'
><div
class
=
'btn btn-sm btn-outline-info'
><strong>edit</strong></div></a>
140.
<a
class
=
'status'
data-fancybox-type=
'iframe'
href=
'teacher/sheet_change.php?UserID=".$SheetID."&do=sheetstatus'
><div
class
=
'btn btn-sm btn-outline-warning'
><strong>status</strong></div></a>
141.
<a
class
=
'del'
data-fancybox-type=
'iframe'
href=
'teacher/sheet_change.php?UserID=".$SheetID."&do=sheetdel'
><div
class
=
'btn btn-sm btn-outline-danger'
><strong>
delete
</strong></div></a>" ;
142.
}
143.
144.
else
if
(
$aColumns
[
$i
] ==
"Sheet_Status"
)
145.
{
146.
$SheetStatusIcon
= SheetStatus(
$aRow
[
"Sheet_Status"
]);
147.
$row
[] =
$SheetStatusIcon
;
148.
}
149.
150.
else
if
(
$aColumns
[
$i
] !=
' '
)
151.
{
152.
153.
$row
[] =
$aRow
[
$aColumns
[
$i
] ];
154.
}
155.
}
156.
$output
[
'aaData'
][] =
$row
;
157.
}
158.
echo
json_encode(
$output
);
159.
?>