Ejemplo n.º 1
0
function DftrSiswa($pid)
{
    $p = GetFields("presensi p\r\n    left outer join jadwal j on p.JadwalID = j.JadwalID\r\n    left outer join dosen d on d.Login = j.DosenID and d.KodeID='" . KodeID . "'\r\n    left outer join hari h on h.HariID = date_format(p.Tanggal, '%w')\r\n\tleft outer join jenisjadwal jj on jj.JenisJadwalID = j.JenisJadwalID", "p.PresensiID", $pid, "p.*, j.MKKode, j.Nama, h.Nama as _HR,\r\n    concat(d.Nama, ' <sup>', d.Gelar, '</sup>') as DSN,\r\n    date_format(p.Tanggal, '%d-%m-%Y') as _Tanggal,\r\n    left(p.JamMulai, 5) as _JM, left(p.JamSelesai, 5) as _JS,\r\n\tjj.Nama as _NamaJenisJadwal, jj.Tambahan");
    TampilkanHeader($p);
    CekKRSMhsw($p);
    TampilkanPresensiMhsw($p);
}
Ejemplo n.º 2
0
function DftrSiswa($pid)
{
    $p = GetFields("presensiremedial pr \r\n    left outer join jadwalremedial jr on pr.JadwalRemedialID = jr.JadwalRemedialID\r\n    left outer join dosen d on d.Login = jr.DosenID and d.KodeID='" . KodeID . "'\r\n    left outer join hari h on h.HariID = date_format(pr.Tanggal, '%w')", "pr.PresensiRemedialID", $pid, "pr.*, jr.MKKode, jr.Nama, h.Nama as _HR,\r\n    concat(d.Nama, ' <sup>', d.Gelar, '</sup>') as DSN,\r\n    date_format(pr.Tanggal, '%d-%m-%Y') as _Tanggal,\r\n    left(pr.JamMulai, 5) as _JM, left(pr.JamSelesai, 5) as _JS");
    TampilkanHeader($p);
    CekKRSMhsw($p);
    TampilkanPresensiMhsw($p);
}