ammarhamzi/agc-chatbot
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
agc-chatbot/Data/Seksyen 39B/LT_LKK_PERSON_INVOLVE.sql

22 lines
10 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

/*
-- Query: select * from ilims_usr.LT_LKK_PERSON_INVOLVE
WHERE LKK_INFOID IN (8,17,23,31,43)
-- Date: 2025-04-18 13:34
*/
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (1,'{\"peranan\": \"HAKIM MAHKAMAH TINGGI\", \"category\": \"corum\", \"namaPihak\": \"YA TUAN HASBULLAH BIN ADAM \"}',8,'2022-09-01 15:18:14','','2022-09-01 15:19:17','');
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (2,'{\"noKP\": \"tiada berkaitan \", \"negaraO\": \"MYS\", \"poskodO\": \"40000\", \"category\": \"prosecutors\", \"daerahId\": \"43\", \"negeriId\": \"10\", \"daerahDesc\": \"SHAH ALAM\", \"negaraDesc\": \"MALAYSIA\", \"negeriDesc\": \"SELANGOR\", \"guamanAgensi\": \"ALFRED EGIN & CO\", \"namaPeguamTpr\": \"ALFRED EGIN\", \"officeAddressO\": \" Pkns Bizpoint, No. 67B, Tingkat 2, \\r\\n Jalan Plumbum P7/P, Seksyen 7 \\r\\n 40000 Shah Alam, Selangor\\r\\n\", \"officePhoneNoO\": \"\", \"PerayuRespondenId\": \"Pendakwa Raya\", \"namaPerayuResponden\": \"NUR ZATIL HIDAYAH BINTI ALI\", \"emailPerayuResponden\": \"zatil.hidayah@agc.gov.my\", \"noPhonePerayuResponden\": \"0176294886\"}',8,'2022-09-01 15:23:06','',NULL,NULL);
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (8,'{\"peranan\": \"HAKIM\", \"category\": \"corum\", \"namaPihak\": \"YA Dato’ Haji Mohd Yazid bin Haji Mustafa\"}',17,'2022-09-05 10:32:03','mary.pkm',NULL,NULL);
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (9,'{\"noKP\": \"911023-08-6757\", \"negaraO\": \"-1\", \"poskodO\": \"\", \"category\": \"accused\", \"daerahId\": \"\", \"negeriId\": \"-1\", \"daerahDesc\": \"\", \"negaraDesc\": \"\", \"negeriDesc\": \"\", \"guamanAgensi\": \"Kuan Ling & C C Goh\", \"namaPeguamTpr\": \"Tong Kuan Ling & Goh Chuan Chean \", \"officeAddressO\": \"No. 7-1 (1st Floor), Jalan Puteri ¼, \\r\\nBandar Puteri, \\r\\n47100 Puchong\\r\\nSelangor Darul Ehsan\", \"officePhoneNoO\": \"0380664280\", \"PerayuRespondenId\": \"Tertuduh\", \"namaPerayuResponden\": \"ANBARASAN A/L MURUGAYAH\", \"emailPerayuResponden\": \"klccgoh@gmail.com\", \"noPhonePerayuResponden\": \"0124617922\"}',17,'2022-09-05 10:37:14','mary.pkm','2022-10-05 14:14:22','mary.pkm');
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (10,'{\"noKP\": \"tiada\", \"negaraO\": \"-1\", \"poskodO\": \"\", \"category\": \"prosecutors\", \"daerahId\": null, \"negeriId\": \"-1\", \"daerahDesc\": \"\", \"negaraDesc\": \"\", \"negeriDesc\": \"\", \"guamanAgensi\": \"\", \"namaPeguamTpr\": \"\", \"officeAddressO\": \"\", \"officePhoneNoO\": \"\", \"PerayuRespondenId\": \"Pendakwa Raya\", \"namaPerayuResponden\": \"Mary Phoon Keat\", \"emailPerayuResponden\": \"mary.pkm@agc.gov.my\", \"noPhonePerayuResponden\": \"0129028512\"}',17,'2022-09-05 10:37:56','mary.pkm',NULL,NULL);
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (16,'{\"peranan\": \"HAKIM\", \"category\": \"corum\", \"namaPihak\": \"YA DATO\' INDERA HAJI AB KARIM BIN AB RAHMAN\"}',23,'2022-09-08 14:45:55','tengku.intan','2022-09-08 14:46:35','tengku.intan');
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (17,'{\"noKP\": \"tidak berkaitan\", \"negaraO\": \"-1\", \"poskodO\": \"\", \"category\": \"prosecutors\", \"daerahId\": null, \"negeriId\": \"-1\", \"daerahDesc\": \"\", \"negaraDesc\": \"\", \"negeriDesc\": \"\", \"guamanAgensi\": \"\", \"namaPeguamTpr\": \"\", \"officeAddressO\": \"\", \"officePhoneNoO\": \"\", \"PerayuRespondenId\": \"Pendakwa Raya\", \"namaPerayuResponden\": \"TENGKU INTAN SURAYA TENGKU ISMAIL\", \"emailPerayuResponden\": \"tengku.intan@agc.gov.my\", \"noPhonePerayuResponden\": \"0193019619\"}',23,'2022-09-08 14:46:26','tengku.intan',NULL,NULL);
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (18,'{\"noKP\": \"tidak berkaitan\", \"negaraO\": \"-1\", \"poskodO\": \"70300\", \"category\": \"accused\", \"daerahId\": \"0505\", \"negeriId\": \"05\", \"daerahDesc\": \"SEREMBAN\", \"negaraDesc\": \"\", \"negeriDesc\": \"NEGERI SEMBILAN\", \"guamanAgensi\": \"TETUAN ZAFLEE % CO\", \"namaPeguamTpr\": \"\", \"officeAddressO\": \"121-1, Jalan S2 B20, Pusat Dagangan, Seremban 2\", \"officePhoneNoO\": \"066011760\", \"PerayuRespondenId\": \"Tertuduh\", \"namaPerayuResponden\": \"ZAFLEE BIN PAKWANTEH\", \"emailPerayuResponden\": \"zafleepakwanteh@yahoo.com\", \"noPhonePerayuResponden\": \"066011760\"}',23,'2022-09-08 14:49:50','tengku.intan',NULL,NULL);
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (28,'{\"peranan\": \"HAKIM\", \"category\": \"corum\", \"namaPihak\": \"Y.A. TUAN HASBULLAH BIN ADAM\"}',31,'2022-09-11 20:55:52','siti.suriatey',NULL,NULL);
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (29,'{\"noKP\": \"tiada berkaitan \", \"negaraO\": \"MYS\", \"poskodO\": \"50480\", \"category\": \"prosecutors\", \"daerahId\": \"1401\", \"negeriId\": \"14\", \"daerahDesc\": \"KUALA LUMPUR\", \"negaraDesc\": \"MALAYSIA\", \"negeriDesc\": \"WILAYAH PERSEKUTUAN (KUALA LUMPUR)\", \"guamanAgensi\": \"TETUAN SCEVETTI & ASSOCIATES\", \"namaPeguamTpr\": \"WAN AZWAN & EFA\", \"officeAddressO\": \"5M-2-20, Plaza Damas. 60, Jalan Sri Hartamas 1, Sri Hartamas, 50480, Kuala Lumpur.\", \"officePhoneNoO\": \"tiada maklumat \", \"PerayuRespondenId\": \"Pendakwa Raya\", \"namaPerayuResponden\": \"NUR ZATIL HIDAYAH BINTI ALI\", \"emailPerayuResponden\": \"zatil.hidayah@agc.gov.my\", \"noPhonePerayuResponden\": \"0176294886\"}',31,'2022-09-11 21:32:10','siti.suriatey',NULL,NULL);
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (48,'{\"peranan\": \"HAKIM\", \"category\": \"corum\", \"namaPihak\": \"YA DATO\' INDERA HAJI AB KARIM BIN AB RAHMAN\"}',43,'2022-09-14 22:26:31','tengku.intan',NULL,NULL);
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (49,'{\"noKP\": \"tidak berkaitan\", \"negaraO\": \"-1\", \"poskodO\": \"\", \"category\": \"prosecutors\", \"daerahId\": null, \"negeriId\": \"-1\", \"daerahDesc\": \"\", \"negaraDesc\": \"\", \"negeriDesc\": \"\", \"guamanAgensi\": \"\", \"namaPeguamTpr\": \"\", \"officeAddressO\": \"\", \"officePhoneNoO\": \"\", \"PerayuRespondenId\": \"Pendakwa Raya\", \"namaPerayuResponden\": \"TENGKU INTAN SURAYA TENGKU ISMAIL\", \"emailPerayuResponden\": \"tengku.intan@agc.gov.my\", \"noPhonePerayuResponden\": \"0193019619\"}',43,'2022-09-14 22:27:19','tengku.intan',NULL,NULL);
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (50,'{\"noKP\": \"800509-05-5473\", \"negaraO\": \"-1\", \"poskodO\": \"\", \"category\": \"accused\", \"daerahId\": \"-1\", \"negeriId\": \"-1\", \"daerahDesc\": \"\", \"negaraDesc\": \"\", \"negeriDesc\": \"\", \"guamanAgensi\": \"Tetuan Law Practice of Rafique\", \"namaPeguamTpr\": \"Muhammad Rafique Bin Rashid Ali\", \"officeAddressO\": \"No. 25-3A, Jalan PJU 1/3b\\r\\nSunwaymas Commercial Centre\\r\\n47301 Petaling Jaya, Selangor\\r\\n\", \"officePhoneNoO\": \"03-78041216\", \"PerayuRespondenId\": \"Tertuduh\", \"namaPerayuResponden\": \"YONG CHIN CAN\", \"emailPerayuResponden\": \"tiada\", \"noPhonePerayuResponden\": \"tiada\"}',43,'2022-09-14 22:29:13','tengku.intan','2022-09-14 22:29:36','tengku.intan');
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (51,'{\"noKP\": \"881006-03-5793\", \"negaraO\": \"-1\", \"poskodO\": \"\", \"category\": \"accused\", \"daerahId\": null, \"negeriId\": \"-1\", \"daerahDesc\": \"\", \"negaraDesc\": \"\", \"negeriDesc\": \"\", \"guamanAgensi\": \"Tetuan Wan Haron Sukri & Nordin\", \"namaPeguamTpr\": \"Dato’ Sukri bin Mohamed\", \"officeAddressO\": \"PT. 1180-1183, Jln Kebun Sultan\\r\\nBandar Kota Bharu\\r\\n15350 Kota Bharu\\r\\nKelantan\\r\\n\", \"officePhoneNoO\": \"09-7440011\", \"PerayuRespondenId\": \"Tertuduh\", \"namaPerayuResponden\": \"MOHAMAD KHAIRUL HAFIZ BIN ADNAN\", \"emailPerayuResponden\": \"TIADA\", \"noPhonePerayuResponden\": \"TIADA\"}',43,'2022-09-14 22:31:32','tengku.intan',NULL,NULL);
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (52,'{\"noKP\": \"AB2216176\", \"negaraO\": \"-1\", \"poskodO\": \"\", \"category\": \"accused\", \"daerahId\": null, \"negeriId\": \"-1\", \"daerahDesc\": \"\", \"negaraDesc\": \"\", \"negeriDesc\": \"\", \"guamanAgensi\": \"Tetuan Wan Haron Sukri & Nordin\", \"namaPeguamTpr\": \"Dato’ Sukri bin Mohamed\", \"officeAddressO\": \"PT. 1180-1183, Jln Kebun Sultan\\r\\nBandar Kota Bharu\\r\\n15350 Kota Bharu\\r\\nKelantan\\r\\n\", \"officePhoneNoO\": \"09-7440011\", \"PerayuRespondenId\": \"Tertuduh\", \"namaPerayuResponden\": \"MR HAKEEM SAMAE\", \"emailPerayuResponden\": \"TIADA\", \"noPhonePerayuResponden\": \"TIADA\"}',43,'2022-09-14 22:32:40','tengku.intan',NULL,NULL);
INSERT INTO `LT_LKK_PERSON_INVOLVE` (`LTL_PERSON_ID`,`LTL_DATA`,`LKK_INFOID`,`CREATEDDATE`,`CREATEDBY`,`UPDATEDDATE`,`UPDATEDBY`) VALUES (53,'{\"noKP\": \"910531-11-5011\", \"negaraO\": \"-1\", \"poskodO\": \"\", \"category\": \"accused\", \"daerahId\": null, \"negeriId\": \"-1\", \"daerahDesc\": \"\", \"negaraDesc\": \"\", \"negeriDesc\": \"\", \"guamanAgensi\": \"Tetuan Zaleha Hayat & Co\", \"namaPeguamTpr\": \"Zaleha Sikkander Hayat\", \"officeAddressO\": \"No. F-07-03, Kompleks Permaisuri 6\\r\\nJalan Sri Permaisuri\\r\\n56000 Kuala Lumpur\\r\\n\", \"officePhoneNoO\": \"03-91746338\", \"PerayuRespondenId\": \"Tertuduh\", \"namaPerayuResponden\": \"SYAMIL BIN TAUFIK @ ZAINAL ABIDIN\", \"emailPerayuResponden\": \"TIADA\", \"noPhonePerayuResponden\": \"TIADA\"}',43,'2022-09-14 22:33:50','tengku.intan',NULL,NULL);
Reference in New Issue View Git Blame Copy Permalink