-
Notifications
You must be signed in to change notification settings - Fork 2
/
to_do.txt
85 lines (66 loc) · 2.47 KB
/
to_do.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
-procedure untuk nyimpan artikel
-ciew nampilkan fitur dimana fitur tidak ada di tabel main(DONE)
-buat trigger jika ada warna yg sama disimpan jadi error
-ERD
-view nampilin semua gallery
-view nampilin semua artikel+penulis
-view nampilin semua navbar
-------------------- fitur
-trigger anti cheater
-upload dan posting(DONE)
-----------------------------
ORDER -> FAHMI btw navdrop + navigasi hapus aja uda ga dipake
tipe di subnav enumnya divider . item
id_sub jangan jadikan primary key lagi
view dropdown <-ininamanyna ya = id_item , label(navitem) , link(navitem), tipe(navitem), tipe(subnav), capek pun ini query nya
select navitem.id_item , subnavitem.label ,subnavitem.link, subnavitem.id_sub from navitem inner join subnavitem where subnavitem.id_item = navitem.id_item;
kalo kau nanya kenapa ga kau aja yg buat bay jawab ku = karna aku rajin ga kaya kau
-----------------------------------
query view allpost
create or replace view allpost as select b.nama , a.judul, a.tanggal, a.status, a.kategori from post a inner join user on a.id_user = b.id_user ;
create or replace view allpost as select a.slug, a.id_post, a.isi, a.judul, b.nama, a.tanggal,d.id_kategori, a.status, d.nama_kategori, a.cover from post a inner join user b on a.id_user = b.id_user inner join kategori d on a.id_kategori = d.id_kategori
DELIMITER $$
DECLARE @cnt integer;
CREATE TRIGGER maks
BEFORE INSERT
ON navitem
FOR EACH ROW
BEGIN
SELECT COUNT(*) INTO @cnt FROM navitem
IF @cnt >= 25 THEN
CALL sth();
END IF;
END
$$
DELIMITER ;
SET collation_connection = 'utf8_general_ci';
ALTER DATABASE sisko CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE post CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE TRIGGER `hapus_siswa` AFTER DELETE ON `siswa`
FOR EACH ROW BEGIN
INSERT INTO log_siswa
SET
nis=old.nis,
nama_siswa=old.nama_siswa,
alamat=old.alamat,
jenis_kelamin=old.jenis_kel,
waktu=NOW(),
status="hapus";
END
CREATE TRIGGER `ubah_siswa` AFTER UPDATE ON `siswa`
FOR EACH ROW BEGIN
INSERT INTO log_siswa
SET
nis=old.nis,
nama_siswa=old.nama_siswa,
alamat=old.alamat,
jenis_kelamin=old.jenis_kel,
waktu=NOW(),
status="ubah";
END
CREATE or replace view allcount AS SELECT COUNT(*) AS jumlah_guru,
(SELECT COUNT(*) FROM allpost) AS jumlah_post,
(SELECT COUNT(*) FROM siswa where status="aktif") as jumlah_siswa_aktif,
(SELECT COUNT(*) FROM siswa WHERE status="pending") AS jumlah_siswa_pending,
(SELECT COUNT(*) FROM siswa WHERE status="seleksi") AS jumlah_siswa_seleksi
FROM ket_guru;