Alhamdulillah, berkat masukan mba wardah, dan yang lain pada diskusi ini : http://sas.openthinklabs.com/f…..aru-online, maka modul PSB sudah makin dimatangkan.
Ada beberapa input yg ditambahkan diantaranya :
- nisn (nisn yg didapat dari jenjang sekolah sebelumnya)
- No Peserta UN
- No Ijazah
- File stl (berkas digital dapat diupload, baik oleh calon orang tua siswa yang mendaftar online atau oleh staff TU)
Form Registrasi Siswa Baru jika diakses oleh calon orang tua maka menggunakan captcha (http://id.wikipedia.org/wiki/CAPTCHA), sebagai pengaman agar tidak ada spam yang masuk. seperti terlihat pada gambar berikut :
Selain itu, dihalaman modul PSB untuk staff TU, Yayasan, Panitia PSB (pengguna yang memilik hak akses ke modul ini), dapat melihat mana siswa yang mendaftar secara online (dalam hal ini calon orang tua siswa mendaftar sendiri secara online) atau offline (data dientri secara manual oleh staff sekolah).
Ada beberapa perubahan struktur database juga, untuk tabel siswa kolom nis, dan kd_unit_kerja dibuat unique. Jadi nis adalah no induk siswa internal sekolah dan nisn adalah no induk siswa nasional. berikut adalah diff perubahan schema nya :
Index: branches/openthinksas-alpha-sf10/config/schema.xml =================================================================== --- branches/openthinksas-alpha-sf10/config/schema.xml (revision 60) +++ branches/openthinksas-alpha-sf10/config/schema.xml (revision 64) @@ -1616,4 +1616,5 @@ <column name="nis" type="VARCHAR" size="12" required="true" primaryKey="true" /> + <column name="nisn" type="VARCHAR" size="12" required="true"/> <column name="nama" type="VARCHAR" size="100" required="true" /> <column name="panggilan" type="VARCHAR" size="50" @@ -1625,4 +1626,8 @@ <reference local="kd_unit_kerja" foreign="kd_unit_kerja" /> </foreign-key> + <unique name="siswa_unique"> + <unique-column name="nis" /> + <unique-column name="kd_unit_kerja" /> + </unique> <column name="jenis_kelamin" type="CHAR" size="1" required="true" /> @@ -1757,4 +1762,6 @@ <column name="no_pendaftaran" type="VARCHAR" size="12" required="true" /> + <column name="no_tes" type="VARCHAR" size="12" + required="true" /> <column name="id_gelombang" type="integer" required="false" /> <foreign-key foreignTable="gelombang_pendaftaran" @@ -1807,5 +1814,10 @@ <column name="sdr_angkat" type="INTEGER" size="2" /> <column name="bahasa_rumah" type="VARCHAR" size="255" /> + <!-- informasi pendidikan sebelumnya --> + <column name="nisn" type="VARCHAR" size="12" /> + <column name="no_peserta_un" type="VARCHAR" size="100" /> + <column name="no_ijazah" type="VARCHAR" size="100" /> <column name="no_stl" type="VARCHAR" size="120" /> + <column name="file_stl" type="VARCHAR" size="200" /> <column name="nem" type="FLOAT" size="10" /> <column name="kd_sekolah_asal" type="INTEGER" /> @@ -1813,4 +1825,5 @@ <reference local="kd_sekolah_asal" foreign="kd_sekolah" /> </foreign-key> + <!-- informasi orang tua --> <column name="id_ortu" type="INTEGER" required="false" /> <foreign-key foreignTable="siswa_ortu"> @@ -1881,4 +1894,5 @@ <column name="catatan" type="LONGVARCHAR" /> <column name="is_processed" type="BOOLEAN" /> + <column name="is_register_online" type="BOOLEAN" default="true"/> <column name="created_at" type="timestamp" /> <column name="updated_at" type="timestamp" />
Berikut ini adalah rangkuman perubahan pada revisi 64.
Changeset 64
- Timestamp:
- 02/26/10 22:59:06
- Location:
- branches/openthinksas-alpha-sf10
- Files:
-
- 27 added
- 1 removed
- 52 modified
- apps/openthinksas/config/app.yml (1 diff)
- apps/openthinksas/config/config.php (3 diffs)
- apps/openthinksas/config/routing.yml (2 diffs)
- apps/openthinksas/config/settings.yml (1 diff)
- apps/openthinksas/modules/academic/actions/actions.class.php (6 diffs)
- apps/openthinksas/modules/errors/templates/error404Success.php (1 diff)
- apps/openthinksas/modules/master/templates/ListSekolahSuccess.php (4 diffs, 1 prop)
- apps/openthinksas/modules/pegawai/templates/ListPegawaiSuccess.php (1 diff, 1 prop)
- apps/openthinksas/modules/pegawai/templates/_pegawai_menutab.php (1 diff, 1 prop)
- apps/openthinksas/modules/psb/actions/ListCalonSiswaAction.class.php
- apps/openthinksas/modules/psb/actions/actions.class.php (14 diffs, 1 prop)
- apps/openthinksas/modules/psb/actions/downloadBerkasStlAction.class.php
- apps/openthinksas/modules/psb/config/security.yml (1 diff)
- apps/openthinksas/modules/psb/templates/EditCalonSiswaSuccess.php (13 diffs)
- apps/openthinksas/modules/psb/templates/ListCalonSiswaSuccess.php (2 diffs, 1 prop)
- apps/openthinksas/modules/psb/templates/NuhunSuccess.php
- apps/openthinksas/modules/psb/templates/RegistrasiOnlineSuccess.php
- apps/openthinksas/modules/psb/templates/ShowCalonSiswaSuccess.php (9 diffs, 1 prop)
- apps/openthinksas/modules/psb/templates/_captcha.php
- apps/openthinksas/modules/psb/templates/_menutab.php
- apps/openthinksas/modules/psb/validate/ProsesRegistrasiOnline.yml
- apps/openthinksas/modules/psb/validate/UpdateCalonSiswa.yml (2 diffs)
- apps/openthinksas/modules/sekolah/templates/LookUpOrtuSiswaSuccess.php (2 diffs)
- apps/openthinksas/templates/layout.php (1 diff)
- config/propel.ini (1 diff)
- config/schema-transformed.xml (1 diff)
- config/schema.xml (6 diffs)
- data/sql/lib.model.schema.sql (145 diffs)
- data/sql/plugins.nahoWikiPlugin.lib.model.schema.sql (3 diffs)
- data/sql/plugins.sfJobQueuePlugin.lib.model.schema.sql (3 diffs)
- data/sql/plugins.sfSimpleCMSPlugin.lib.model.schema.sql (2 diffs)
- data/sql/plugins.sfSimpleForumPlugin.lib.model.schema.sql (5 diffs)
- lib/OpenThinkSAS.class.php
- lib/jpgraph
- lib/jpgraph/README
- lib/jpgraph/VERSION
- lib/jpgraph/jpgraph.php
- lib/jpgraph/jpgraph_antispam.php
- lib/model/map/SiswaCalonMapBuilder.php (3 diffs)
- lib/model/map/SiswaMapBuilder.php (1 diff)
- lib/model/om/BaseBeritaPeer.php (3 diffs)
- lib/model/om/BaseGuruMatapelajaranPeer.php (3 diffs)
- lib/model/om/BaseJamPelajaran.php (3 diffs)
- lib/model/om/BaseKelompokMatapelajaranPeer.php (3 diffs)
- lib/model/om/BaseKodeMatapelajaranPeer.php (3 diffs)
- lib/model/om/BaseManajemenPmhPeer.php (3 diffs)
- lib/model/om/BaseSiswa.php (11 diffs)
- lib/model/om/BaseSiswaCalon.php (22 diffs)
- lib/model/om/BaseSiswaCalonPeer.php (8 diffs)
- lib/model/om/BaseSiswaPeer.php (4 diffs)
- lib/model/om/BasesfGuardGroupPeer.php (3 diffs)
- lib/model/om/BasesfGuardPermissionPeer.php (3 diffs)
- lib/model/om/BasesfGuardUserPeer.php (3 diffs)
- plugins/.channels/pear.symfony-project.com.reg (1 diff)
- plugins/.filemap (1 diff)
- plugins/.registry/.channel.pear.symfony-project.com/sfcaptchaplugin.reg
- plugins/.registry/.channel.pear.symfony-project.com/symfony.reg (1 diff)
- plugins/nahoWikiPlugin/lib/model/om/BasenahoWikiContentPeer.php (3 diffs)
- plugins/nahoWikiPlugin/lib/model/om/BasenahoWikiPagePeer.php (3 diffs)
- plugins/sfCaptchaPlugin
- plugins/sfCaptchaPlugin/LICENSE
- plugins/sfCaptchaPlugin/README
- plugins/sfCaptchaPlugin/config
- plugins/sfCaptchaPlugin/config/config.php
- plugins/sfCaptchaPlugin/lib
- plugins/sfCaptchaPlugin/lib/Captcha.class.php
- plugins/sfCaptchaPlugin/lib/captchaValidator.class.php
- plugins/sfCaptchaPlugin/modules
- plugins/sfCaptchaPlugin/modules/sfCaptcha
- plugins/sfCaptchaPlugin/modules/sfCaptcha/actions
- plugins/sfCaptchaPlugin/modules/sfCaptcha/actions/actions.class.php
- plugins/sfCaptchaPlugin/modules/sfCaptcha/templates
- plugins/sfCaptchaPlugin/modules/sfCaptcha/templates/indexSuccess.php
- plugins/sfJobQueuePlugin/lib/model/om/BasesfJobPeer.php (3 diffs)
- plugins/sfJobQueuePlugin/lib/model/om/BasesfJobQueuePeer.php (3 diffs)
- plugins/sfSimpleCMSPlugin/lib/model/om/BasesfSimpleCMSPagePeer.php (3 diffs)
- plugins/sfSimpleForumPlugin/lib/model/om/BasesfSimpleForumCategoryPeer.php (3 diffs)
- plugins/sfSimpleForumPlugin/lib/model/om/BasesfSimpleForumForumPeer.php (3 diffs)
- plugins/sfSimpleForumPlugin/lib/model/om/BasesfSimpleForumPostPeer.php (3 diffs)
- plugins/sfSimpleForumPlugin/lib/model/om/BasesfSimpleForumTopicPeer.php (3 diffs)
Recent Comments