
-logout after idle 30 minit
-table for mobile operator for send sms





sentry_id=30019 is paid

MPSJ/KUB/300-1/1/30/2012#1
MPSJ/KUB/300-1/1/85/2011#1
MPSJ/KUB/300-1/1/112/2011#1

/////////////////////////////////////////////////////
https://enquiry.mpsj.gov.my/v2/service/kon_dokumen/001457348U/2012/
kalaulah select * from kewangan.majlis.ap_pohdr where id_pem = '001457348U'
kalaulah select a.*, 'xxxxxx', b.* from kewangan.majlis.ap_pohdr as a left outer join kewangan.majlis.ap_tender as b on a.no_obligasi = b.no_obligasi where a.id_pem = '001457348U'
kalaulah select a.*, 'xxxxxx', b.* from kewangan.majlis.ap_pohdr as a left outer join kewangan.majlis.ap_tender as b on a.no_obligasi = b.no_obligasi where a.id_pem = '001457348U'
kalaulah select b.* from kewangan.majlis.ap_inboishdr b where b.no_dok = '2012090652'

http://127.0.0.1/mpsj_enquiry_v2/service/kon_dokumen/001125370M/2010/
/////////////////////////////////////////////////////

3nqu1ry~20!@


potong rumput & cuci longkang
param utk penyelia tempahan rumah rehat



fariz.izuan 012-9746634

cukai
login poupou79 / x

kompaun
login akuazhar / x

tempahan
login awis30 / x

660929085001 / abcde12345 (ridzuan_sul)
0501020040073000 SHAFIQUE B YUSOFF/NADIA SHAFIQA LORETTA 701219115163



-upload aduan
-delete akaun cukai pengguna oleh admin
-delete akaun sewa pengguna oleh admin
--function get param utk lokasi all
--buat baru page param utk lokasi, pop add, pop edit, drag sort, font
--store param at sybase but get from mysql and sortable param


- tambah button carian di skrin kanan cukai
- user boleh mohon/request akaun cukai "sila nyatakan no akaun cukai bagi mana2 hak milik rumah yang tiada di paparan"
- kat admin.. papar senarai/list nama ic noakaun date checkbox(nak tunjuk dah update kat sigma)
----- tambah tab cukai.. tukar alamat
----- ayat "senarai transaksi" tukar "penyata cukai"
----- tab "bil terkini" tukar "Cukai Terkini"
----- Tarikh Notis	01 Jan 2013 ==> tukar bold merah

- ikon pembayaran diatas
--------- atas "web pertanyaan" tukar "web pelanggan"

sewaan
------
boleh add konsep macam cukai. enq lama xde

epusara
---------
allow add n edit gambar

pending
-----------
- sms setiap trans n registration/pengesahan
-tambah upload file kat aduan je la kan.. cuma nanti cepat la penuh hdd ko.. hehe
-Mohon tambah buttuon hapus untuk cukai dalam senarai pengguna cukai.
-Permohonan cagaran aku amik urs lepas raya (project ni sebenar sekali ngan sistem kontraktor)



















-------------------------------------------------------------------------------------------------------------------------------------------------------------------
kalaulah select s.*, tarikh_format = convert(varchar, s.dateAndTime, 103), s.dateAndTime as masa_format, 
r.transactionId as sentry_id, r.primaryAccountNumber as order_id, r.submit_id, r.msgId, r.cardAcceptorTerminalId, r.ReferenceNo, r.AuthCode 
from web.majlis.wb_transaction_submit as s 
left outer join web.majlis.wb_transaction_response as r on s.id = r.id 
where s.custId='860630435114' order by s.id asc
SQL RESULT
id	primaryAccountNumber	custName	custId	custName_bil	custId_bil	strTransId	cardNum	cardExpire	cardCvv	transactionAmount	transTime	systemTraceAuditNo	cardType	dateAndTime	status	tarikh_format	masa_format	sentry_id	order_id	submit_id	msgId	cardAcceptorTerminalId	ReferenceNo	AuthCode
98037		ATHIRAH IBRAHIM	860630435114	ATHIRAH IBRAHIM	860630435114	MPSJ-WEB-0000098037	1	5	0	700		27563	s	Dec 27 2013 12:56PM	1	27/12/2013	Dec 27 2013 12:56PM	23552	MPSJ-ONLINE-0000023552	65569	OP	XXXXXXXXXXXX6831	336101257900	000523
98093		ATHIRAH IBRAHIM	860630435114	ATHIRAH IBRAHIM	860630435114	MPSJ-WEB-0000098093	1	5	0	700		27563	s	Dec 29 2013 1:52AM	1	29/12/2013	Dec 29 2013 1:52AM	23552	MPSJ-ONLINE-0000023552	65625	OP	XXXXXXXXXXXX6831	336101257900	000523
98094		ATHIRAH IBRAHIM	860630435114	ATHIRAH IBRAHIM	860630435114	MPSJ-WEB-0000098094	1	5	0	700		27563	s	Dec 29 2013 1:58AM	1	29/12/2013	Dec 29 2013 1:58AM	23552	MPSJ-ONLINE-0000023552	65626	OP	XXXXXXXXXXXX6831	336101257900	000523
98095		ATHIRAH IBRAHIM	860630435114	ATHIRAH IBRAHIM	860630435114	MPSJ-WEB-0000098095	1	5	0	700		27563	s	Dec 29 2013 2:15AM	1	29/12/2013	Dec 29 2013 2:15AM	23552	MPSJ-ONLINE-0000023552	65627	OP	XXXXXXXXXXXX6831	336101257900	000523
98096	SD20131200249	ATHIRAH IBRAHIM	860630435114	ATHIRAH IBRAHIM	860630435114	MPSJ-WEB-0000098096	0	7	0	1400		0	s	Dec 29 2013 2:49AM	1	29/12/2013	Dec 29 2013 2:49AM	23552	MPSJ-ONLINE-0000023552	65628	OP	XXXXXXXXXXXX6831	336101257900	000523
98097	SD2013000323	ATHIRAH IBRAHIM	860630435114	ATHIRAH IBRAHIM	860630435114	MPSJ-WEB-0000098097	1	5	0	700		27563	s	Dec 29 2013 2:49AM	1	29/12/2013	Dec 29 2013 2:49AM	23552	MPSJ-ONLINE-0000023552	65629	OP	XXXXXXXXXXXX6831	336101257900	000523
TOTAL: 6
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
