Notice: Undefined index: sql_stmt in /var/www/html/sis/application/modules/smsgateway/controllers/SmsController.php on line 275
[{"id":"1","name":"Pengumuman diterima sebagai calon Mahasiswa Baru PSSB","template":"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.","sql_stmt":"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\r\n","active":"1"},{"id":"3","name":"Pengumuman diterima sebagai calon Mahasiswa Baru USM","template":"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.","sql_stmt":"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","active":"1"},{"id":"5","name":"Pengumuman diterima sebagai calon Mahasiswa Baru USM Tahap 1","template":"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.","sql_stmt":"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","active":"1"},{"id":"7","name":"Pengumuman diterima sebagai calon Mahasiswa Baru PSSB Tahap 1","template":"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.","sql_stmt":"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","active":"1"},{"id":"9","name":"Password","template":"User id : [$userid] dan password anda: [$passwd] login di www.spmb.trisakti.ac.id","sql_stmt":"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","active":"1"},{"id":"10","name":"Password Karyawan","template":"User id : [$userid] dan password anda: [$passwd] Login di www.sis.trisakti.ac.id. Ubah password anda di menu ubah password","sql_stmt":"select LoginName as userid, passwd_b as passwd from tbl_staffmaster as a inner join tbl_user as b on a.IdStaff=b.IdStaff","active":"1"},{"id":"12","name":"password OT (lama)","template":"User id : [$userid] dan password anda: [$passwd] login di www.spmb.trisakti.ac.id","sql_stmt":"SELECT IF( af.af_email = '', c.appl_email, af_email ) AS userid, af.af_password AS passwd\nFROM student_profile AS a\nINNER JOIN tbl_studentregistration AS b ON a.appl_id = b.idapplication\nINNER JOIN applicant_profile AS c ON c.appl_id = a.appl_id\nINNER JOIN applicant_family AS af ON af.af_appl_id = a.appl_id","active":"1"},{"id":"13","name":"Password New","template":"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.","sql_stmt":"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","active":"1"},{"id":"14","name":"Test Wawancara Daring","template":"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.","sql_stmt":"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\npasswordvc , apv_vc_date AS tanggal, apv_vc_time AS waktu\nFROM applicant_transaction AS a\nINNER JOIN applicant_profile AS b ON a.at_appl_id = b.appl_id\nINNER JOIN applicant_ptest AS c ON c.apt_at_trans_id = a.at_trans_id\nINNER JOIN application_ptest_detail AS d ON d.apt_id = c.apt_id\nINNER JOIN applicant_ptest_vc AS e ON d.apd_id = e.apv_apd_id\nWHERE app_comp_code = '12'","active":"1"},{"id":"15","name":"password OT New","template":"Untuk mengetahui informasi akademik Putra\/Putri Saudara, dapat menggunakan User id : [$userid] dan password : [$passwd] login di https:\/\/student.trisakti.ac.id","sql_stmt":"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","active":"1"},{"id":"16","name":"Password Karyawan New","template":"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!","sql_stmt":"select LoginName as userid, passwd_b as passwd from tbl_staffmaster as a inner join tbl_user as b on a.IdStaff=b.IdStaff","active":"1"},{"id":"17","name":"Password Dosen","template":"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!","sql_stmt":"select LoginName as userid, passwd_b as passwd from tbl_staffmaster as a inner join tbl_user as b on a.IdStaff=b.IdStaff","active":"1"},{"id":"18","name":"","template":"","sql_stmt":"select LoginName as userid, passwd_b as passwd from tbl_staffmaster as a inner join tbl_user as b on a.IdStaff=b.IdStaff","active":"1"},{"id":"19","name":"","template":"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.","sql_stmt":"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","active":"1"},{"id":"20","name":"","template":"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.","sql_stmt":"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","active":"1"},{"id":"21","name":"","template":"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.","sql_stmt":"","active":"1"},{"id":"22","name":"","template":"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.","sql_stmt":"","active":"1"},{"id":"23","name":"","template":"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.","sql_stmt":"","active":"1"},{"id":"24","name":"","template":"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.","sql_stmt":"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","active":"1"},{"id":"25","name":"","template":"","sql_stmt":"","active":"1"},{"id":"26","name":"","template":"","sql_stmt":"","active":"1"},{"id":"27","name":"","template":"","sql_stmt":"","active":"1"},{"id":"28","name":"","template":"","sql_stmt":"","active":"1"},{"id":"29","name":"","template":"","sql_stmt":"","active":"1"}]