function hocvien($kh, $lh, $gv)
{
$data = array();
$data[] = array('STT', 'Mã HV', 'Họ & tên', 'Ngày sinh', 'Giới tính', 'Điện thoại', 'Email', 'Địa chỉ', 'Mã lớp', 'Lớp học', 'Cấp độ', 'Giảng viên');
if ($kh != 0) {
if ($gv != 0) {
$qr_gv = " AND id_giangvien='{$gv}' ";
}
if ($lh != 0) {
$qr_lh = " AND daotao_lophoc.id='{$lh}' ";
}
$qr_lh = "SELECT daotao_lophoc.id,daotao_lophoc.name,capdo,daotao_giangvien.name as giangvien \r\n\t\t\tFROM daotao_lophoc,daotao_giangvien \r\n\t\t\tWHERE daotao_lophoc.`delete`=0 AND id_khoahoc='{$kh}' AND id_giangvien=daotao_giangvien.id {$qr_lh} {$qr_gv}\r\n\t\t\tORDER BY daotao_lophoc.`name` ";
$qr_lh = mysql_query($qr_lh);
while ($row_lh = mysql_fetch_array($qr_lh)) {
$i = 0;
$qr = mysql_query("SELECT id,name,ngaysinh,gioitinh,phone,email,diachi FROM daotao_hocvien WHERE `delete`=0 AND ds_lophoc LIKE '%,{$row_lh['id']},%' ORDER BY `name` ");
while ($row = mysql_fetch_array($qr)) {
$i++;
if ($row['gioitinh'] == 1) {
$gioitinh = 'Nam';
} else {
$gioitinh = 'Nữ';
}
$data[] = array($i, $row['id'], $row['name'], date('m/d/Y', strtotime($row['ngaysinh'])), $gioitinh, $row['phone'], $row['email'], $row['diachi'], $row_lh['id'], $row_lh['name'], $row_lh['capdo'], $row_lh['giangvien']);
}
}
} elseif ($gv != 0) {
$qr_lh = "SELECT daotao_lophoc.id,daotao_lophoc.name,capdo,daotao_giangvien.name as giangvien \r\n\t\t\tFROM daotao_lophoc,daotao_giangvien \r\n\t\t\tWHERE daotao_lophoc.`delete`=0 AND id_giangvien=daotao_giangvien.id AND id_giangvien='{$gv}'\r\n\t\t\tORDER BY daotao_lophoc.`name` ";
$qr_lh = mysql_query($qr_lh);
while ($row_lh = mysql_fetch_array($qr_lh)) {
$i = 0;
$qr = mysql_query("SELECT id,name,ngaysinh,gioitinh,phone,email,diachi FROM daotao_hocvien WHERE `delete`=0 AND ds_lophoc LIKE '%,{$row_lh['id']},%' ORDER BY `name` ");
while ($row = mysql_fetch_array($qr)) {
$i++;
if ($row['gioitinh'] == 1) {
$gioitinh = 'Nam';
} else {
$gioitinh = 'Nữ';
}
$data[] = array($i, $row['id'], $row['name'], date('m/d/Y', strtotime($row['ngaysinh'])), $gioitinh, $row['phone'], $row['email'], $row['diachi'], $row_lh['id'], $row_lh['name'], $row_lh['capdo'], $row_lh['giangvien']);
}
}
}
export_excel($data, 'hocvien-' . date('His'));
}
return false;
} else {
$i = 0;
$str = "SELECT daotao_hocvien.* FROM daotao_hocvien,daotao_khoahoc WHERE daotao_hocvien.`delete`=0 AND daotao_hocvien.status=1 AND id_hocvien=daotao_hocvien.id AND id_lophoc='{$lophoc}'";
$qr = mysql_query($str);
while($row = mysql_fetch_array($qr)){
$i++;
$data[] = array($i,$row['name'],$row['email'],$row['phone'],$row['diachi'],$row['username']);
}
mysql_free_result($qr);
}
export_excel($data,'lophoc-');*/
} else {
if ($type == 2 || $type == 4) {
$khoahoc = $_GET['danhsach'];
export_excel($data, 'bangdiem-');
}
}
}
?>
<div style="margin:30px">
<form name="export_excel" action="export_excel/export_excel.php" method="get">
<p><span style="display:block; color:#F00; font-weight:bold; font-size:120%; padding-bottom:10px">Chọn thông tin muốn xuất ra excel</span>
<select name="type_export_excel" style="width:300px; padding:3px 10px" id="type_export_excel">
<option value="0">-- Chọn loại muốn xuất --</option>
<optgroup label="Xuất thông tin học viên" >
<option value="1">Theo lớp học</option>
<option value="2">Theo khóa học</option>
</optgroup>
$seperator = "Sno.";
$comma = ",";
foreach ($row as $name => $value) {
$seperator .= $comma . '' . str_replace('', '""', $name);
$comma = ",";
}
$seperator .= "\n";
fputs($fp, $seperator);
$db->data_seek($sql, 0);
$row_number = 1;
while ($row = $db->fetch_as_associate_array($sql)) {
$seperator = "{$row_number}";
$comma = ",";
foreach ($row as $name => $value) {
$seperator .= $comma . '' . str_replace('', '""', $value);
$comma = ",";
}
$row_number++;
$seperator .= "\n";
fputs($fp, $seperator);
}
fclose($fp);
echo "Your file is ready. You can download it from <a href='{$filename}'>here!</a>";
} else {
echo "There is no record in your Database";
}
}
$test_name = $_GET["test_name"];
$table = $test_name . "_users";
export_excel($table);
function bangdiem_theokhoa($khoahoc)
{
$qr = mysql_query("SELECT name FROM info WHERE id='{$khoahoc}' AND `delete`=0 ");
$row = mysql_fetch_array($qr);
$data = array();
$data[] = array('Tên khóa: ', $row['name']);
$data[] = array();
$data[] = array('STT', 'Họ & tên', 'Lớp học', 'Cấp độ', 'Giảng viên', 'Cột 1', 'Cột 2', 'Cột 3', 'Cột 4', 'Cột 5', 'Cột 6', 'Cột 7', 'Cột 8');
if ($khoahoc == '' || $khoahoc == '0') {
echo 'Ban chua chon lop hoc de xuat du lieu';
return false;
} else {
$i = 0;
$str = "SELECT daotao_lophoc.id,daotao_lophoc.name as lophoc,capdo,daotao_giangvien.name as giangvien FROM daotao_lophoc,daotao_giangvien WHERE daotao_lophoc.`delete`=0 AND id_khoahoc='{$khoahoc}' AND id_giangvien=daotao_giangvien.id";
$qr = mysql_query($str);
while ($row = mysql_fetch_array($qr)) {
$str = "SELECT daotao_hocvien.name,diem1,diem2,diem3,diem4,diem5,diem6,diem7,diem8 FROM daotao_hocvien,daotao_bangdiem WHERE daotao_bangdiem.`delete`=0 AND daotao_bangdiem.status=1 AND id_lophoc='{$row['id']}' AND daotao_hocvien.id=id_hocvien ORDER BY daotao_hocvien.`name`";
$qr1 = mysql_query($str);
while ($row1 = mysql_fetch_array($qr1)) {
$i++;
$data[] = array($i, $row1['name'], $row['lophoc'], $row['capdo'], $row['giangvien'], $row1['diem1'], $row1['diem2'], $row1['diem3'], $row1['diem4'], $row1['diem5'], $row1['diem6'], $row1['diem7'], $row1['diem8']);
}
}
mysql_free_result($qr);
}
export_excel($data, 'khoahoc-');
}
