-- MySQL dump 10.13  Distrib 5.5.62, for linux-glibc2.12 (x86_64)
--
-- Host: localhost    Database: waqfmaha
-- ------------------------------------------------------
-- Server version	5.5.62

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `wmr_gratuity`
--

DROP TABLE IF EXISTS `wmr_gratuity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wmr_gratuity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `months` varchar(33) NOT NULL,
  `year` varchar(33) NOT NULL,
  `date` varchar(33) NOT NULL,
  `code` varchar(33) NOT NULL,
  `account_head` varchar(33) NOT NULL,
  `employee_name` varchar(33) NOT NULL,
  `totalgratuity_amount` varchar(33) NOT NULL,
  `gratuityamount_paid` varchar(33) NOT NULL,
  `balance_any` varchar(33) NOT NULL,
  `remarks` varchar(33) NOT NULL,
  `session_username` varchar(33) NOT NULL,
  `timestamp` varchar(33) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wmr_gratuity`
--

LOCK TABLES `wmr_gratuity` WRITE;
/*!40000 ALTER TABLE `wmr_gratuity` DISABLE KEYS */;
INSERT INTO `wmr_gratuity` VALUES (2,'August','1','01-09-2018','11','Waqf Fund A/c','Sri Late M.Sarfaraz Hussain, Sr.A','317864','317864','0000000','6th and final Installment.','majaleel','1541580545'),(3,'August','1','01-09-2018','11','Waqf Fund A/c','Sri Mir Sadath Ali Sr.Asst., Retd','385543','192770','192773','Balance amount to be paid in (01)','majaleel','1541580687'),(4,'August','1','01-09-2018','11','Waqf Fund A/c','Sri M A Quddus, Sr.Asst., Retd, T','231364','231364','0000000','5th and final Installment.','majaleel','1541580838'),(5,'August','1','01-09-2018','11','Waqf Fund A/c','Sri Syed Hussain, AS Retd, TSWB','816292','204072','612220','Balance amount to be paid in (03)','majaleel','1541580957'),(6,'August','1','01-09-2018','11','Waqf fund A/c','Sri Mohd Ghouse, Supdt., Retd, TS','1502061','300412','1201649','Balance amount to be paid in (04)','majaleel','1541581036'),(7,'September','1','01-10-2018','11','Waqf Fund A/c','Sri Mir Sadath Ali, Sr.Asst., Ret','192773','192773','0000000','6th','majaleel','1541581230'),(8,'September','1','01-10-2018','11','Waqf Fund A/c','Sri Syed Huusain, AS Retd, TSWB','612220','204072','408148','Balance amount to be paid in (02)','majaleel','1541581378'),(9,'September','1','01-10-2018','11','Waqf Fund A/c','Sri Mohd Ghouse, Supdt., Retd, TS','1201649','300412','901237','Balance amount to be paid in (03)','majaleel','1541581458'),(10,'October','1','01-11-2018','11','Waqf Fund A/c','Sri Mohd Ghouse, Supdt., Retd, TS','901237','300412','600825','Balance amount to be paid in (02)','majaleel','1541581728'),(11,'October','1','01-11-2018','11','Waqf Fund A/c','Sri Syed Hussain, AS, Retd, TSWB','408148','204072','204706','Balance amount to be paid in (01)','majaleel','1541581796'),(12,'October','1','01-11-2018','11','Waqf Fund A/c','Late M.A Sami, Supdt., Retd, TSWB','393101','393101','00000000','4th and Final Installment.','majaleel','1541581890'),(13,'November','1','01-12-2018','11','Waqf Fund','Sri Syed Hussain, AS Retd., TSWB','204076','204076','000000','5th and Final Installment.','majaleel','1545223764'),(14,'November','1','01-12-2018','11','Waqf Fund','Sri Mohd Ghouse, Supdt., Rted, TS','600825','300412','300413','5th Installment, Balance amount t','majaleel','1545223900'),(15,'April','1','28-04-2021','11','Waqf Fund','Sri Mohd Zakir Hussain, Sr.Asst.,','3,75,280','3,75,280','00','Sri Mohd Zakir Hussain, Sr.Asst.,','majaleel','1630493037'),(16,'April','1','28-09-2021','11','Waqf Fund','Sri Zia Ul Arifain, T.O., Retired','2,31,381','2,31,381','00','Sri Zia Ul Arifain, T.O., Retired','majaleel','1630493112'),(17,'April','1','28-04-2021','11','Waqf Fund','Sri Syed Mansoor, OS, Retired, TS','7,73,789','2,57,929','5,15,860','Sri Syed Mansoor, OS, Retired, TS','majaleel','1630493214'),(18,'May','1','20-05-2021','11','Waqf Fund','Sri Mohd Abdul Khaleel, OS, Retir','15,03,233','5,01,077','10,02,156','Sri Mohd Abdul Khaleel, OS, Retir','majaleel','1630493379'),(19,'June','1','16-06-2021','11','Waqf Fund','Smt., Nazreen Sultana W/o Late Sr','7,98,649','5,08,997','2,89,652','Smt., Nazreen Sultana W/o Late Sr','majaleel','1630493556'),(20,'May','1','16-06-2021','11','Waqf Fund','Sri Mohd Abdul Khaleel, OS, Retir','10,02,156','5,01,077','5,01,079','Sri Mohd Abdul Khaleel, OS, Retir','majaleel','1630493625'),(21,'July','1','08-07-2021','11','Waqf Fund','Sri Mohd Irshad Ali S/o Late Sri ','2,89,652','1,44,826','1,44,826','Sri Mohd Irshad Ali S/o Late Sri ','majaleel','1630493847'),(22,'July','1','08-07-2021','11','Waqf Fund','Sri Mohd Abdul Khaleel, OS, Retir','5,01,079','5,01,079','00','Sri Mohd Abdul Khaleel, OS, Retir','majaleel','1630493898'),(23,'July','1','09-07-2021','11','Waqf Fund','Sri Syed Mansoor, OS, Retired, TS','5,15,860','2,57,929','2,57,931','Sri Syed Mansoor, OS, Retired, TS','majaleel','1630493979'),(24,'May','1','05-05-2021','22','institution','MOHD ZAFARULLAH KHAN, JPITI','470955/-','470955/-','00','GRATUITY,EL HPL','faqruddin','1630494608'),(25,'September','1','13-09-2021','11','Waqf Fund','Sri Syed Mansoor, OS, Retired, TS','2,57,931','2,57,931','00','Sri Syed Mansoor, OS, Retired, TS','majaleel','1635761472'),(26,'September','1','13-09-2021','11','Waqf Fund','Smt., Nayeem Unnisa D/o Late Sri ','1,44,826','1,44,826','00','Smt Nayeem Unnisa D/o Late Sri Mo','majaleel','1635761546'),(27,'September','1','13-09-2021','11','Waqf Fund','Sri Zakiuddin Ahmed Shafeeq, Sr. ','15,48,560','3,09,712','12,38,848','Sri Zakiuddin Ahmed Shafeeq, Sr. ','majaleel','1635761664'),(28,'November','1','03-11-2021','11','Waqf Fund','Sri Nazeeb Ahmed, Sr.Asst., Retir','8,96,028','7,81,028','00','Sri Nazeeb Ahmed, Sr.Asst., Retir','majaleel','1640916941'),(29,'November','1','03-11-2021','11','Waqf Fund','Sri Zakiuddin Ahmed Shafeeq, Sr. ','12,38,848','3,09,712','9,29,136','Sri Zakiuddin Ahmed Shafeeq, Sr. ','majaleel','1640917103'),(30,'November','1','03-11-2021','11','Waqf Fund','Sri Davood Khan, Sr. Asst., Retir','45,071','45,071','00','Sri Davood Khan, Sr.Asst., Retire','majaleel','1640917192'),(31,'December','1','04-12-2021','11','Waqf Fund','Sri Zakiuddin Ahmed Shafeeq, Sr. ','9,29,136','3,09,712','6,19,424','Sri Zakiuddin Ahmed Shafeeq, Sr. ','majaleel','1640917359'),(32,'December','1','21-12-2021','11','Waqf Fund','Sri Mutaher Hussain, Supdt., Reti','20,63,076','4,04,615','16,58,461','Sri Mutaher Hussain, Supdt., Reti','majaleel','1640917525'),(33,'November','1','21-12-2021','11','Waqf Fund','Smt., Razia Sultana towards Gratu','13,64,490','2,45,696','11,18,794','Smt., Razia Sultana towards Gratu','majaleel','1640917609'),(34,'December','1','21-12-2021','11','Waqf Fund','Sri Mohammad Khaja Saleemuddin to','14,82,098','2,96,419','11,85,679','Sri Mohammad Khaja Saleemuddin to','majaleel','1640917706');
/*!40000 ALTER TABLE `wmr_gratuity` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-08-05 22:00:28
