(1061,104,'sale','agent','Pending','no','100','L02667','NORNADIA BT NUAOIRUN','','HADI BIN ILAN','','D10-4b TAMAN IMPIAN INDAH APARTMENT',150000,4740,'transfer','85570884053','MBB',9500,0,'','','','270','uncle teoh','','3000',0,'[{\"url\": \"image/1603082727 - booking D10-4B tmn impian indah.pdf\"}, {\"url\": \"image/1603082727 - Booking Form D10-4B Tmn Impian Indah (Nornadia).pdf\"}, {\"url\": \"image/1603082727 - Booking Fees Payment Receipt D10-4b Taman Impian Indah.pdf\"}]',NULL,NULL,0,'','2020-10-17',NULL,'2020-10-19 04:45:36'),(1062,104,'sale','agent','Pending','no','100','02883','SEE CHWAN SHUO','','CHONG SWEE LENH','','A5-8-7 GREEN ACRE PARK CONDO SUNGAI LONG',280000,8700,'transfer','637605054','CIMB',15600,0,'','','','336.00','','','',0,'[{\"url\": \"image/1603082992 - CIMB Clicks.pdf\"}, {\"url\": \"image/1603095031-IMG_20201019_160845.jpg\"}, {\"url\": \"image/1603095031-IMG_20201019_160834.jpg\"}]',NULL,NULL,0,'','2020-10-19',NULL,'2020-10-19 08:10:31'),(1063,169,'sale','leader','Pending','no','105','s02578','nur hidayah binti saruni','','mas ayu binti mahmood','','a-9-2, sri cempaka apartment, jalan sepakat indah 2/1, 43000, kajang, selangor',200000,2000,'','','',11255,0,'richard tan','vestcom realty','11255','360','','','',0,'[{\"url\": \"image/1603083305 - booking form.pdf\"}]',NULL,NULL,0,'','2020-10-17',NULL,'2020-10-19 04:55:20'),(1064,169,'sale','leader','Pending','no','105','s03055','norsilawati binti berahim','','chong kim seong','','a-12-3, juta mines condominum,taman seri timah, 43300, balakong, selangor.',240000,2500,'','','',8600,0,'cj tan','vestcom realty','8600','432','','','',0,'[{\"url\": \"image/1603083587 - booking A-12-3 juta mines.pdf\"}]',NULL,NULL,0,'','2020-10-18',NULL,'2020-10-19 05:00:03'),(1065,200,'rent','leader','Approved','yes','201','R03019','M CUISINE SDN BHD','','CHUNG MOOK SEM / JONG BOON NEE','','B-G-13A PLAZA ARKADIA',17000,21020,'','','',17000,17000,'','','','1020','','','',3000,'[{\"url\": \"image/1603084924 - B-G-13A Plaza Arkadia.pdf\"}]',NULL,NULL,0,'SST OWNER BEAR','2020-08-30','2020-10-19','2020-10-19 08:12:08'),(1066,167,'sale','leader','Pending','yes','100','s02607','suhaimi bin ismail&nurul liyana izyani','019-2298889','charles agapit paiva &mary ichelle sathamba','012-3366175','menara nilam-12-7 TIARA AMPANG JALAN AMPANG KM7, 68000 Kuala Lumpur, Selangor',390000,7800,'200467955m/201788381m/205799812m','','maybank',7800,7800,'','','','468','','','',0,'[{\"url\": \"image/1603085577 - Tiara Ampang 12-7 booking.pdf\"}, {\"url\": \"image/1603085576 - Official Receipt 608 - LAWRENCE TANG.pdf\"}, {\"url\": \"image/1603085576 - Receipt (10).pdf\"}, {\"url\": \"image/1603085575 - Receipt (9).pdf\"}, {\"url\": \"image/1603085576 - Receipt (11).pdf\"}, {\"url\": \"image/1601270798 - booking Form Sri Wira 200k.pdf\"}]',NULL,NULL,0,'','2020-10-17','2020-11-05','2020-11-05 09:31:46'),(1067,167,'sale','leader','Pending','no','100','s02605','puteri aainaa megat aimuddin','','lim boon wong ','','2d-4-6 Sri Penaga Apartment (Sri Penaga)Jalan Wawasan 4/12, Taman Wawasan, 47100 Puchong, Selangor',225000,2300,'2010-071552475500','','standar chartered',11750,11750,'','','','405','','','',0,'[{\"url\": \"image/1603085887 - Sri Penaga 225k.pdf\"}, {\"url\": \"image/1603085887 - Sri Penaga Comm.pdf\"}, {\"url\": \"image/1603085887 - Official Receipt 599 - LAWRENCE TANG.pdf\"}, {\"url\": \"image/1603085886 - Sri Penaga 230k.pdf\"}, {\"url\": \"image/1603085887 - WhatsApp Image 2020-10-07 at 15.53.47.jpeg\"}]',NULL,NULL,0,'','2020-10-07',NULL,'2020-10-19 05:38:16'),(1068,200,'sale','leader','Approved','yes','201','S02695','YONG JE WEI & LOH MENG HUI','','HO SIP MOI @ JENNY HO KUI MOI','','UNIT 11-10, WESTSIDE 3',1000000,30000,'','','',18832.1,18832.1,'','','','1129.92','','','10038',0,'[{\"url\": \"image/1603088335 - Westside 3 11-10.pdf\"}]',NULL,NULL,0,'SST OWNER BEAR','2020-07-18','2020-10-19','2020-10-19 08:14:48'),(1069,200,'rent','leader','Approved','yes','201','r03018','tan yuan ling','','tai kim hock','','h-1-13 plaza arkadia',5500,6580,'','','',5500,5500,'','','','330','','','',750,'[{\"url\": \"image/1603090047 - H-1-13 Plaza Arkadia.pdf\"}]',NULL,NULL,0,'SST OWNER BEAR','2020-08-03','2020-10-19','2020-10-19 08:13:27'),(1070,200,'rent','leader','Approved','yes','201','','kl mont kiara tfb sdn bhd','','m cuisine sdn bhd','','b-m-13 plaza arkadia',4200,4452,'','','',4200,4200,'','','','252','','','',0,'[{\"url\": \"image/1603092262 - B-M-13 Plaza Arkadia.pdf\"}]',NULL,NULL,0,'SST OWNER BEAR','2020-09-15','2020-10-19','2020-10-19 08:10:33'),(1071,200,'rent','leader','Approved','yes','201','renewal','','','lian chian hong','','d-3-25, plaza arkadia 3',1000,1000,'','','',471.7,471.7,'alvis lim','','471.70','56.6','','','',0,'[{\"url\": \"image/1603092860 - D-3-25 Plaza Arkadia.pdf\"}]',NULL,NULL,0,'SST OWNER BEAR','2020-09-07','2020-10-19','2020-10-19 08:11:16'),(1072,170,'project','leader','Pending','no','117',NULL,'wan ishyah binti wan omar','0179476247',NULL,NULL,NULL,300000,300000,NULL,NULL,NULL,3000,2820,NULL,NULL,NULL,'180','','','',NULL,'[{\"url\": \"image/1603257645 - CamScanner 10-17-2020 13.35.26.pdf\"}]','Circo','1-17-07',300000,'','2020-10-15',NULL,'2020-10-21 05:21:53'),(1073,172,'rent','agent','Approved','yes','101','03072','quantum success advisory','0126488807','low lay choo','0122788613','b-3a-5 (level 6), menara uncang emas',1900,2164,'online transfer maybank2u','','maybank',950,950,'tanny tong','total realty sdn bhd e11572','950.00','114.00','','','',150,'[{\"url\": \"image/1603262242 - CO-BROKE INVOICE SST VESTCOM REALTY.pdf\"}, {\"url\": \"image/1603262221 - B-3A-5 UE3 Office TA Booking Bank.pdf\"}, {\"url\": \"image/1603263679-03072 Case Cobroke Letter.pdf\"}]',NULL,NULL,0,'2 bank transfer receipt in PDF file. SST owner bear. Tenancy fees issue to agent steve cheong','2020-09-30','2020-11-02','2020-11-02 07:37:08'),(1074,162,'sale','leader','Approved','yes','121','locs201912','faizal bin musa','','chia chung yee','','m-15-11, calisa m residence, jalan taman mas, 47100 puchong',238000,2380,'','','',2380,2380,'lai wei lan','lai wei lan','2380','428.40','','','',0,'[{\"url\": \"image/1603264541 - WhatsApp Image 2020-10-19 at 7.34.31 PM (1).jpeg\"}, {\"url\": \"image/1603264541 - RELEVANT PAGES OF STAMPED SNP.pdf\"}, {\"url\": \"image/1603264541 - WhatsApp Image 2020-10-19 at 7.34.31 PM.jpeg\"}]',NULL,NULL,0,'','2020-08-20','2020-11-04','2020-11-04 05:25:50'),(1075,162,'sale','leader','Pending','no','121','s02088','yong yang cheng','','wong yoke chew','','33a-6, altitude 236 condo, no 9, jalan alam damai cheras, 56000 k.l',700000,21000,'187403286m, 187370013m, 187355552m','','mbb',14000,14000,'','','','840','','','',0,'[{\"url\": \"image/1603266641 - Receipt (3).pdf\"}, {\"url\": \"image/1603266641 - Receipt (4).pdf\"}, {\"url\": \"image/1603266641 - Receipt (2).pdf\"}, {\"url\": \"image/1603266641 - WhatsApp Image 2020-10-20 at 3.24.27 PM.jpeg\"}, {\"url\": \"image/1603266641 - WhatsApp Image 2020-10-20 at 3.24.33 PM.jpeg\"}]',NULL,NULL,0,'','2020-10-16',NULL,'2020-10-21 07:50:45'),(1076,145,'sale','agent','Pending','no','114','s 02638','nuraini binti mohd rizal ','0107012519','ong hook kee','0197310135','b-14-08, puncak damansara condo, pju 6, jalan teratai, kampung sungai kayu ara, 47400 petaling jaya, selangor.',325000,1000,'037063805m','','maybank',11500,0,'','','','','','','',0,'[{\"url\": \"image/1603275133 - Receipt (12).pdf\"}]',NULL,NULL,0,'','2020-10-03',NULL,'2020-10-21 10:12:16'),(1077,122,'sale','leader','Pending','no','117','02312','Mohd herme bin smaon','','Teh eng vooi, chin pei san','','7, jalan kesuma 5/1S, Bandar Tasik Kesuma, 43700 Beranang, Semenyih ',415000,3000,'Maybank 8312134917','','',15950,15950,'','','','','','','',0,'[{\"url\": \"image/1603282608 - Document 32_1.jpg\"}, {\"url\": \"image/1603283192-IMG_20201021_202532.jpg\"}, {\"url\": \"image/1603283217-semenyih 2.pdf\"}, {\"url\": \"image/1603283555-S&P 1306_001.pdf\"}]',NULL,NULL,0,'','2020-09-01',NULL,'2020-10-21 12:32:35'),(1078,220,'sale','agent','Approved','yes','103','R03118','Ezmate sdn bhd','0123498357','ashwinder singh a/l sukhdarshan singh','0192119333','88-05-35,apartment abdullah hukum',1600,2146,'online transfered','','',1600,1600,'','','','96','','','',0,'[{\"url\": \"image/1603374000 - 88-05-35.pdf\"}, {\"url\": \"image/1603373573 - d50cbef6-1669-4862-9197-127419a5f213.jpg\"}]',NULL,NULL,0,'','2020-09-21','2020-11-02','2020-11-02 07:28:51'),(1079,145,'sale','agent','Pending','no','114','s02641','zalikha syuhaida binti mohd sumbaji','','mohd azrol bin hashim','','s02-05-13, d\' cassia apartment, jalan ecohill 1/2, 43500 semenyih, selangor. ',245000,1000,'20201021025904','','BANK RAKYAT',9800,0,'','','','','','','',0,'[{\"url\": \"image/1603390843 - WhatsApp Image 2020-10-21 at 9.05.11 PM.jpeg\"}]',NULL,NULL,0,'','2020-10-21',NULL,'2020-10-22 18:20:47'),(1080,146,'sale','leader','Pending','yes','117','Dr33113','Song wei','','CHEW seok wei','','B-11-01, Angkasa CONDO. No.5, jln Puncak  gading, tmn Connaught 56000 Kl. ',1600,1600,'','','',754.72,754.72,'JAMES Wong ka fei','JAMES Wong ka fei','752.00','96.00','','','',0,'[]',NULL,NULL,0,'','2020-09-14','2020-10-27','2020-11-05 08:45:49'),(1081,146,'sale','leader','Pending','yes','117','DR31565','Nor ASHIKIN BINti MOhd saman','','Yong JOh chen ','','B-16-10 maxim residence.',1100,11666,'','','',550,550,'James Wong ka fei','James Wong ka fei','550.00','66.00','','','',0,'[]',NULL,NULL,0,'','2020-06-30','2020-11-05','2020-11-05 08:33:17'),(1082,100,'sale','Management','Pending','no','null','S02869','MUHAMAD ZHARIF SAMION','','Muhamad firdaus bin mat saad','','2-12-1 pantai hillpark 5',280000,3690,'Transfer','','',74000,0,'','','','504','','','',0,'[{\"url\": \"image/1603870338-image.jpg\"}, {\"url\": \"image/1603870350-image.jpg\"}, {\"url\": \"image/1603870370-image.jpg\"}, {\"url\": \"image/1603870676-image.jpg\"}, {\"url\": \"image/1603870702-image.jpg\"}, {\"url\": \"image/1603870719-image.jpg\"}]',NULL,NULL,0,'SST owner bare, 1300 paid to valuer, return to hector','2020-10-12',NULL,'2020-10-28 07:38:47'),(1083,109,'sale','leader','Pending','no','100','S02606','Sophia','','Noureddine','','B-3a-4 gurney height condo',520000,10000,'online transfer','','',24300,0,'','','','558','','','',0,'[]',NULL,NULL,0,'','2020-10-12',NULL,'2020-10-26 04:19:57'),(1084,100,'sale','Management','Pending','no','null','S02699','AZIMAH BINTI OMAN','','Felix VoOn','','5-16-4 pantai hillpark 2',380000,4700,'Transfer ','','',50600,0,'','','','684.00','','','',0,'[{\"url\": \"image/1603870823-image.jpg\"}]',NULL,NULL,0,'Owner bare SST,  hector bare 6444 to lawyer downpayment first','2020-07-05',NULL,'2020-10-28 07:40:27'),(1085,100,'sale','Management','Approved','yes','null','S02867','RADIA NURULFATHIAH BINTI SUKIMAN','','Foo chee ming','','B-9-4 tasik heights ',250000,1000,'Transfer','','',1000,1000,'','','','','','','',0,'[]',NULL,NULL,0,'','2020-07-20','2020-11-02','2020-11-02 07:49:16'),(1086,100,'sale','Management','Pending','no','null','S02437','NUR ASLIN NABILA BINTI MOHAMAD','','Ganahasatten ','','55-3-10 abadi indah condo',240000,2700,'TRANSFER','','',34800,0,'','','','432','','','',0,'[]',NULL,NULL,0,'','2020-08-08',NULL,'2020-10-26 06:06:02'),(1088,112,'sale','agent','Rejected','yes','106','01849','muhammad firdaus bin tajudin','01111611656','abd rahim bin ambak','','d-3-6,sri melor apartment,jalan up4/2,ukay perdana,68000,ampang,selangor',6600,6600,'Transfer','','uob bank',6600,6600,'','','','396.00','','','',0,'[]',NULL,NULL,0,'','2019-04-19','2020-10-27','2020-11-02 08:09:19'),(1089,114,'sale','leader','Process','yes','105','s02947','hashim bin yacob','','noorhazalina','','no 20 jalan p4 fasa 10 taman melawati 53100 kuala lumpur up kuala lumpur',1100000,5000,'85951536696','','maybank',33000,33000,'','','','1980.00','','','',0,'[]',NULL,NULL,0,'','2020-10-25','2020-11-05','2020-11-05 09:49:50'),(1090,200,'sale','leader','Approved','yes','201','','CHIU WAI HON','','GORDEV SINGH A/L GIAN SINGH','','12-.3 OCP CONDOMINIUM',2200000,22000,'','','',22000,22000,'','','','','','','',0,'[]',NULL,NULL,0,'','2020-06-25','2020-10-26','2020-10-26 07:33:20'),(1091,114,'sale','leader','Pending','no','105','s02978','kumaresn a/l therarsan ','','mohd sukry bin mohamad','','p02-02-07 seri pinang apartment , jalan setia permai u13/40 , setia alam seksyan u13 shah alam 40170 selangor',305000,1000,'','','',9575,0,'','','','274.5','','','',0,'[]',NULL,NULL,0,'','2020-10-24',NULL,'2020-10-26 07:38:57'),(1092,211,'sale','leader','Pending','no','101','2958','tan','0193297969','lin','0193297969','lot 147,jalan timah, the mines, 43300,seri kembangan',40760,40760,'','072502','maybank',38000,0,'','','','','','','',0,'[]',NULL,NULL,0,'','2020-10-11',NULL,'2020-10-26 09:24:48'),(1093,142,'sale','agent','Pending','no','114','s 02978','kumaresan a/l theyvarsam','011-26320018','mohd sukry bin mohamed','','p02-02-07, seri pinang apartment, jalan setia permai u13/40, setia alam, seksyen u13, shah alam, 40170, selangor',305000,1000,'','','',9575,0,'','','','274.50','','','',0,'[]',NULL,NULL,0,'','2020-10-24',NULL,'2020-10-26 10:50:48'),(1094,154,'sale','leader','Pending','no','114','s02578','nur hidayah binti saruni','','mas ayu binti mahmood','','p-13-a-09-02, sri cempaka apartment, jln sepakat indah 2/1, 43000 kajang, selangor',200000,2000,'635518312','','cimb',11075,0,'','','','180','','','',0,'[{\"url\": \"image/1603859830-bank slip sri cempaka.jpg\"}, {\"url\": \"image/1603859853-sri cempaka a0902.pdf\"}]',NULL,NULL,0,'','2020-10-17',NULL,'2020-10-28 04:37:33'),(1095,154,'sale','leader','Pending','no','114','s02579','mohd yadzrul bin yahya','','lee wee hoong','','a4-3-3, green acre park condo, jln sg long, bdr sg long, 43000 kajang, selangor.',290000,3000,'666377','','hong leong bank',8700,0,'','','','522','','','',0,'[{\"url\": \"image/1603859878-bank slip green acre park.jpg\"}, {\"url\": \"image/1603859894-green acre park A40303.pdf\"}]',NULL,NULL,0,'','2020-10-22',NULL,'2020-10-28 04:38:14'),(1096,226,'rent','agent','Pending','no','101','03171','Emily ho xi tien','','elena a/p ebinezar','','a-08-3a, block a, x2 residency jalan putra prima utama, taman putra prima',3000,1000,'856940','','public bank',1500,0,'kelly foo hoi yin','','1500.00','180.00','','','',0,'[]',NULL,NULL,0,'','2020-10-24',NULL,'2020-10-27 05:16:02'),(1097,225,'rent','agent','Pending','no','101','R03171','Emily ho xi tien','','elena a/p ebinezar','','a-08-3a, block a, x2 residency jalan putra prima utama, taman putra prima',3000,1000,'856940','','public bank',1500,0,'Andy chong kok kuan','','1500.00','180.00','','','',0,'[]',NULL,NULL,0,'','2020-10-24',NULL,'2020-10-27 05:26:02'),(1098,182,'sale','agent','Pending','yes','165','03089','Ahmad abrar Bin abdul hamid','017-3271005','Chan siew ping','012-6568183','B1-2-1 villa residence, goodview heights 2, jalan goodview 1, 43000 kajang selangOr ',850,850,'Online transfer','No','No',850,850,'No','No','No','51','No','No','No',0,'[{\"url\": \"image/1603808944 - B1-2-1 tenancy.pdf\"}, {\"url\": \"image/1603808901 - B1-2-1 SST.pdf\"}, {\"url\": \"image/1603808861 - B1-2-1 form.pdf\"}, {\"url\": \"image/1603808820 - B1-2-1 booking.pdf\"}]',NULL,NULL,0,'','2020-10-02','2020-11-05','2020-11-05 02:39:38'),(1099,101,'sale','Management','Pending','no','100','S02084','Mohd afdhal uddin bin khairul azam','','Maria TERESA A/p arumugam','','NO20-3b jln CAHAYA 14 tmn cahaya amoang selangor',120000,2000,'1602836602833985','','',21000,0,'','','','','','','',0,'[{\"url\": \"image/1603854887 - 16038548754419088809598396959629.jpg\"}]',NULL,NULL,0,'','2020-10-16',NULL,'2020-10-28 03:14:57'),(1100,158,'sale','agent','Pending','no','154','s02356','Muhammad faroug bin jufri','','chai wah kin','','204-14-03,sri suajaya condo,jln kampung bdr dalam,51100 kl',250000,3000,'902307466m','','maybank',2500,2500,'richard','vestcom','2500','150','','','',0,'[{\"url\": \"image/1608309071 - sri suajaya 6868.jpg\"}, {\"url\": \"image/1608309231 - sri suajaya 6868.jpg2.jpg\"}, {\"url\": \"image/1608309046 - sri suajaya.pdf\"}, {\"url\": \"image/1608309025 - SPA 745 MD FAROUQ JUFRI_20200514105620.pdf\"}]',NULL,NULL,0,'','2019-12-07',NULL,'2020-12-18 16:34:48'),(1101,158,'sale','agent','Pending','no','154','s02884','nor syahida binti nik wil','','viknaswaran a/l m.suppiah','','8-3-11,vantage point condo,tmn desa petaling,57100 kl.',220000,2000,'591176054m','','maybank',6640,0,'richard','vestcom','6640','198','','','',0,'[{\"url\": \"image/1612108381 - vantage point 8311.pdf\"}, {\"url\": \"image/1612108352 - Receipt vantage point 8311.pdf\"}]',NULL,NULL,0,'','2021-01-31',NULL,'2021-01-31 15:53:09'),(1102,158,'sale','agent','Pending','no','154','s02941','wafaa nadhirah binti rahmat','0134175530','andre lee','01110396556','b-2-10 sentul utama condo,jalan taman dato senu,taman sentul utama ,51000 kl',310000,3000,'21500016146','','maybank',4929,4929,'rex','vestcom','4929','279','','','',0,'[{\"url\": \"image/1630507188 - Booking and Exclusive Form.pdf\"}, {\"url\": \"image/1630507160 - 1399 spa_001.pdf\"}, {\"url\": \"image/1630507175 - Bankin Receipt (1).pdf\"}, {\"url\": \"image/1630507150 - Receipt (2).pdf\"}, {\"url\": \"image/1630507135 - WhatsApp Image 2021-05-30 at 14.02.10.jpeg\"}]',NULL,NULL,0,'','2020-10-29',NULL,'2021-09-01 14:41:05');

--
-- Table structure for table `tmpfileloc`
--

CREATE TABLE `tmpfileloc` (
  `fid` int(11) NOT NULL AUTO_INCREMENT,
  `userID` int(11) NOT NULL,
  `fileloc` text NOT NULL,
  `subdate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`fid`)
) ENGINE=MyISAM AUTO_INCREMENT=2677 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tmpfileloc`
--

INSERT INTO `tmpfileloc` VALUES (2247,212,'image/1599542588 - Fairville apt.pdf','2020-09-08 13:23:08');


