| Nama |
Template |
Sql |
| Pengumuman diterima sebagai calon Mahasiswa Baru PSSB |
Selamat kpd Sdr. [$nama] Noform: [$noform]. Anda diterima di USAKTI pada prodi [$program] peringkat [$rank]. Surat panggilan silahkan diunduh portal masing-masing mulai tgl 18 Januari 2016. |
select at_pes_id as noform,CONCAT(appl_fname,' ',appl_mname,' ',appl_lname) as nama, prs.ArabicName as program, aar_rating_rector as rank from applicant_transaction as a inner join applicant_profile as b on a.at_appl_id=b.appl_id inner join (select ArabicName,ap_at_trans_id from applicant_program as pr inner join tbl_program as p on pr.ap_prog_code=p.programcode ) as prs on prs.ap_at_trans_id=a.at_trans_id inner join applicant_assessment as pp on pp.aar_trans_id=a.at_trans_id
|
| Pengumuman diterima sebagai calon Mahasiswa Baru USM |
Selamat kpd Sdr. [$nama] Noform: [$noform]. Anda diterima di USAKTI prodi [$program] peringkat [$rank]. Surat panggilan silahkan anda unduh di portal masing-masing mulai tgl 18 Januari 2016. |
select at_pes_id as noform,CONCAT(appl_fname,' ',appl_mname,' ',appl_lname) as nama, prs.ArabicName as program, aau_rector_ranking as rank from applicant_transaction as a inner join applicant_profile as b on a.at_appl_id=b.appl_id inner join (select ArabicName,ap_at_trans_id from applicant_program as pr inner join tbl_program as p on pr.ap_prog_code=p.programcode where ap_usm_status='1') as prs on prs.ap_at_trans_id=a.at_trans_id inner join applicant_assessment_usm as pp on pp.aau_trans_id=a.at_trans_id |
| Pengumuman diterima sebagai calon Mahasiswa Baru USM Tahap 1 |
Selamat kpd Sdr. [$nama] Noform: [$noform]. Anda lulus seleksi Tahap I di USAKTI prodi [$program]. Untuk Kartu Peserta Ujian tahap ke-2 silahkan anda unduh di portal masing-masing. |
select at_pes_id as noform,CONCAT(appl_fname,' ',appl_mname,' ',appl_lname) as nama, prs.ArabicName as program, aau_rector_ranking as rank from applicant_transaction as a inner join applicant_profile as b on a.at_appl_id=b.appl_id inner join (select ArabicName,ap_at_trans_id from applicant_program as pr inner join tbl_program as p on pr.ap_prog_code=p.programcode where ap_usm_status='1') as prs on prs.ap_at_trans_id=a.at_trans_id inner join applicant_assessment_usm as pp on pp.aau_trans_id=a.at_trans_id |
| Pengumuman diterima sebagai calon Mahasiswa Baru PSSB Tahap 1 |
Selamat kpd Sdr. [$nama] Noform: [$noform]. Anda lulus seleksi Tahap I di USAKTI prodi [$program]. Untuk Kartu Ujian tahap ke-2 unduh di portal masing-masing. |
select at_pes_id as noform,CONCAT(appl_fname,' ',appl_mname,' ',appl_lname) as nama, prs.ArabicName as program, aar_rating_rector as rank from applicant_transaction as a inner join applicant_profile as b on a.at_appl_id=b.appl_id inner join (select ArabicName,ap_at_trans_id from applicant_program as pr inner join tbl_program as p on pr.ap_prog_code=p.programcode ) as prs on prs.ap_at_trans_id=a.at_trans_id inner join applicant_assessment as pp on pp.aar_trans_id=a.at_trans_id |
| Password |
User id : [$userid] dan password anda: [$passwd] login di www.spmb.trisakti.ac.id |
select c.appl_email as userid, c.appl_password as passwd from student_profile as a inner join tbl_studentregistration as b on a.appl_id=b.idapplication inner join applicant_profile as c on c.appl_id=a.appl_id |
| Password Karyawan |
User id : [$userid] dan password anda: [$passwd] Login di www.sis.trisakti.ac.id. Ubah password anda di menu ubah password |
select LoginName as userid, passwd_b as passwd from tbl_staffmaster as a inner join tbl_user as b on a.IdStaff=b.IdStaff |
| password OT (lama) |
User id : [$userid] dan password anda: [$passwd] login di www.spmb.trisakti.ac.id |
SELECT IF( af.af_email = '', c.appl_email, af_email ) AS userid, af.af_password AS passwd
FROM student_profile AS a
INNER JOIN tbl_studentregistration AS b ON a.appl_id = b.idapplication
INNER JOIN applicant_profile AS c ON c.appl_id = a.appl_id
INNER JOIN applicant_family AS af ON af.af_appl_id = a.appl_id |
| Password New |
Info Akademik, KRS Online dan Isi SKPI, User id : [$userid] dan password anda: [$passwd] login di https://spmb.trisakti.ac.id Bagi yang belum menerima User dan Password, silahkan menghubungi bagian Akademik/Administrasi Fakultas/Prodi Anda. |
select c.appl_email as userid, c.appl_password as passwd from student_profile as a inner join tbl_studentregistration as b on a.appl_id=b.idapplication inner join applicant_profile as c on c.appl_id=a.appl_id |
| Test Wawancara Daring |
Test wawancara saudara [$nama] dengan media daring [$provider] pada tgl [$tanggal] mulai jam [$waktu] dengan tautan alamat [$url] User Id: [$userid] dan Password: [$passwordvc]. Persiapkan diri anda 30 menit sebelum wawancara. |
SELECT CONCAT( appl_fname, ' ', appl_mname, ' ', appl_lname ) AS nama, apv_vc_provider AS provider, apv_vc_url AS url, apv_vc_id AS userid, apv_vc_password AS
passwordvc , apv_vc_date AS tanggal, apv_vc_time AS waktu
FROM applicant_transaction AS a
INNER JOIN applicant_profile AS b ON a.at_appl_id = b.appl_id
INNER JOIN applicant_ptest AS c ON c.apt_at_trans_id = a.at_trans_id
INNER JOIN application_ptest_detail AS d ON d.apt_id = c.apt_id
INNER JOIN applicant_ptest_vc AS e ON d.apd_id = e.apv_apd_id
WHERE app_comp_code = '12' |
| password OT New |
Untuk mengetahui informasi akademik Putra/Putri Saudara, dapat menggunakan User id : [$userid] dan password : [$passwd] login di https://student.trisakti.ac.id |
SELECT IF( af.af_email = '', c.appl_email, af_email ) AS userid, af.af_password AS passwd FROM student_profile AS a INNER JOIN tbl_studentregistration AS b ON a.appl_id = b.idapplication INNER JOIN applicant_profile AS c ON c.appl_id = a.appl_id INNER JOIN applicant_family AS af ON af.af_appl_id = a.appl_id |
| Password Karyawan New |
Input Nilai dan Informasi Akademik Mhs, User id : [$userid] dan password anda: [$passwd] Login di www.sis.trisakti.ac.id Jaga kerahasiaan User dan Password Anda! |
select LoginName as userid, passwd_b as passwd from tbl_staffmaster as a inner join tbl_user as b on a.IdStaff=b.IdStaff |
| Password Dosen |
Input Nilai dan Informasi Akademik Mhs, User id : [$userid] dan password anda: [$passwd] Login di https://sis.trisakti.ac.id Jaga kerahasiaan User dan Password Anda! |
select LoginName as userid, passwd_b as passwd from tbl_staffmaster as a inner join tbl_user as b on a.IdStaff=b.IdStaff |
|
|
select LoginName as userid, passwd_b as passwd from tbl_staffmaster as a inner join tbl_user as b on a.IdStaff=b.IdStaff |
|
Selamat kpd Sdr. [$Sandi Alfarizi] Noform: [$235562920501]. Anda diterima di USAKTI pada prodi [$teknik elektro] peringkat [$7]. Surat panggilan silahkan diunduh portal masing-masing mulai tgl 29 Mei 2024. |
select at_pes_id as noform,CONCAT(appl_fname,' ',appl_mname,' ',appl_lname) as nama, prs.ArabicName as program, aar_rating_rector as rank from applicant_transaction as a inner join applicant_profile as b on a.at_appl_id=b.appl_id inner join (select ArabicName,ap_at_trans_id from applicant_program as pr inner join tbl_program as p on pr.ap_prog_code=p.programcode ) as prs on prs.ap_at_trans_id=a.at_trans_id inner join applicant_assessment as pp on pp.aar_trans_id=a.at_trans_id |
|
Selamat kpd Sdr. [$Sandi Alfarizi] Noform: [$235562920501]. Anda diterima di USAKTI pada prodi [$teknik elektro] peringkat [$7]. Surat panggilan silahkan diunduh portal masing-masing mulai tgl 29 Mei 2024. |
select at_pes_id as noform,CONCAT(appl_fname,' ',appl_mname,' ',appl_lname) as nama, prs.ArabicName as program, aar_rating_rector as rank from applicant_transaction as a inner join applicant_profile as b on a.at_appl_id=b.appl_id inner join (select ArabicName,ap_at_trans_id from applicant_program as pr inner join tbl_program as p on pr.ap_prog_code=p.programcode ) as prs on prs.ap_at_trans_id=a.at_trans_id inner join applicant_assessment as pp on pp.aar_trans_id=a.at_trans_id |
|
Selamat kpd Sdr. [$Sandi Alfarizi] Noform: [$235562920501]. Anda diterima di USAKTI pada prodi [$teknik elektro] peringkat [$7]. Surat panggilan silahkan diunduh portal masing-masing mulai tgl 29 Mei 2024. |
|
|
Selamat kpd Sdr. [$Sandi Alfarizi] Noform: [$235562920501]. Anda diterima di USAKTI pada prodi [$teknik elektro] peringkat [$7]. Surat panggilan silahkan diunduh portal masing-masing mulai tgl 29 Mei 2024. |
|
|
Selamat kpd Sdr. [$Sandi Alfarizi] Noform: [$235562920501]. Anda diterima di USAKTI pada prodi [$teknik elektro] peringkat [$7]. Surat panggilan silahkan diunduh portal masing-masing mulai tgl 29 Mei 2024. |
|
|
Selamat kpd Sdr. [$Sandi Alfarizi] Noform: [$235562920501]. Anda diterima di USAKTI pada prodi [$teknik elektro] peringkat [$7]. Surat panggilan silahkan diunduh portal masing-masing mulai tgl 29 Mei 2024. |
select at_pes_id as noform,CONCAT(appl_fname,' ',appl_mname,' ',appl_lname) as nama, prs.ArabicName as program, aar_rating_rector as rank from applicant_transaction as a inner join applicant_profile as b on a.at_appl_id=b.appl_id inner join (select ArabicName,ap_at_trans_id from applicant_program as pr inner join tbl_program as p on pr.ap_prog_code=p.programcode ) as prs on prs.ap_at_trans_id=a.at_trans_id inner join applicant_assessment as pp on pp.aar_trans_id=a.at_trans_id |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|