New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Penyempurnaan Lalu Lintas PTN : Guru BK dapat membuka/menutup akses input Pilihan PTN-Program Studi Oleh Siswa #399

Closed
wildanm opened this Issue Sep 27, 2016 · 2 comments

Comments

Projects
None yet
1 participant
@wildanm
Member

wildanm commented Sep 27, 2016

Saat ini, siswa/i kelas 12 hanya dapat melihat pilihan PTN-Program Studi yang sudah diinput oleh Guru BK.

Agar meringankan Guru BK, maka siswa/i dapat menginput sendiri pilihan PTN/Program Studi-nya, tapi hanya JIKA diberikan akses oleh Guru BK.

@wildanm wildanm added the enhancement label Sep 27, 2016

@wildanm wildanm added this to the SIT NF - TA : 2016/2017-1 milestone Sep 27, 2016

@wildanm wildanm self-assigned this Sep 27, 2016

@wildanm

This comment has been minimized.

Show comment
Hide comment
@wildanm

wildanm Sep 27, 2016

Member

Jalankan SQL Berikut :

CREATE TABLE `lalu_lintas_ptn_hak_akses_siswa`
(
    `id` INTEGER  NOT NULL AUTO_INCREMENT,
    `siswa_kelas_id` INTEGER  NOT NULL,
    `is_closed` INTEGER,
    PRIMARY KEY (`id`),
    KEY `lalu_lintas_hak_akses_siswa_kelas_id_fk`(`siswa_kelas_id`),
    CONSTRAINT `lalu_lintas_hak_akses_siswa_FK_1`
        FOREIGN KEY (`siswa_kelas_id`)
        REFERENCES `siswa_kelas` (`id`)
        ON UPDATE RESTRICT
        ON DELETE RESTRICT
)Engine=InnoDB DEFAULT CHARSET=latin1; 
Member

wildanm commented Sep 27, 2016

Jalankan SQL Berikut :

CREATE TABLE `lalu_lintas_ptn_hak_akses_siswa`
(
    `id` INTEGER  NOT NULL AUTO_INCREMENT,
    `siswa_kelas_id` INTEGER  NOT NULL,
    `is_closed` INTEGER,
    PRIMARY KEY (`id`),
    KEY `lalu_lintas_hak_akses_siswa_kelas_id_fk`(`siswa_kelas_id`),
    CONSTRAINT `lalu_lintas_hak_akses_siswa_FK_1`
        FOREIGN KEY (`siswa_kelas_id`)
        REFERENCES `siswa_kelas` (`id`)
        ON UPDATE RESTRICT
        ON DELETE RESTRICT
)Engine=InnoDB DEFAULT CHARSET=latin1; 
@wildanm

This comment has been minimized.

Show comment
Hide comment
@wildanm

wildanm Sep 27, 2016

Member

Done in a1f0949 (bitbucket)

Member

wildanm commented Sep 27, 2016

Done in a1f0949 (bitbucket)

@wildanm wildanm closed this Sep 27, 2016

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment