--
-- Host: localhost    Database: kapil
-- ------------------------------------------------------


--
-- Table structure for table `kb_chspr`
--

CREATE TABLE `kb_chspr` (
  `logprid` int NOT NULL AUTO_INCREMENT,
  `logjobno` varchar(255) DEFAULT NULL,
  `logname` varchar(500) DEFAULT NULL,
  `loguser` varchar(255) DEFAULT NULL,
  `logpass` varchar(255) DEFAULT NULL,
  `logdate` date DEFAULT NULL,
  `logdevelop` varchar(500) DEFAULT NULL,
  `logdec` varchar(5000) DEFAULT NULL,
  `logphoto` varchar(255) DEFAULT NULL,
  `logflag` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`logprid`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kb_chspr`
--


--
-- Table structure for table `kb_manag`
--

CREATE TABLE `kb_manag` (
  `mtid` int NOT NULL AUTO_INCREMENT,
  `mtsr` varchar(10) DEFAULT NULL,
  `mtname` varchar(500) DEFAULT NULL,
  `mtage` varchar(10) DEFAULT NULL,
  `mtdes` varchar(500) DEFAULT NULL,
  `mtemail` varchar(200) DEFAULT NULL,
  `mtqul` varchar(1000) DEFAULT NULL,
  `mtreg` varchar(1000) DEFAULT NULL,
  `mtexp` text,
  `mtflag` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`mtid`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kb_manag`
--

INSERT INTO `kb_manag` VALUES (3,'2','KAPIL S. BAKSHI','','','admin@kapilbakshi.in','Completed Architecture from Rachana Sansad\'s Academy of Architecture, Prabhadevi in the \r\nyear 1993.','Council of Architecture, New Delhi.     \r\nP. E. A. T. A. ( Practising Engineers Architects & Town Planners Association )','Experience of more than 28 years in field of Architecture, Project Management & \r\nInterior \r\nDesigning<br><br>\r\nStarted career by working with \'Talati & Panthaky - Associated Pvt Ltd\', one of the \r\nlargest and the most respected Architectural firm in India. During this period worked \r\nas \r\nProject Architect on Township project spread over 52 acres and corporate office \r\nbuilding \r\nfor one of the largest industrial houses in India.<br><br>\r\nStarted own firm by name of <b>Kapil S. Bakshi, Architects & PMC</b> by year 1996. \r\nHandled \r\nPMC for projects of Residential, Commercial structures, Institutional structures. \r\nWorked \r\nas PMC for Interior Designing of custodial center of a foreign bank in Mumbai.',''),(4,'3','Mrs. PARISHA DESAI','','','','Completed Architecture from Kamala Raheja college of Architecture, Juhu in the year  \r\n1997.','.','Experience of more than 24 years in field of Architecture, Project Management.<br><br>\r\nStarted career by working with \'Talati & Panthaky - Associated Pvt Ltd\', one of the \r\nlargest \r\nand most respected Architectural firm in India. During this period worked as Project \r\nArchitect on Residential & Commercial structures.<br><br>\r\nInvolved in coordination of site activities and planning scheduling.','');

--
-- Table structure for table `kb_mepdf`
--

CREATE TABLE `kb_mepdf` (
  `pdfid` int NOT NULL AUTO_INCREMENT,
  `logprid` varchar(11) DEFAULT NULL,
  `logjobno` varchar(255) DEFAULT NULL,
  `pdfdate` date DEFAULT NULL,
  `pdffile` varchar(500) DEFAULT NULL,
  `pdfflag` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`pdfid`)
) ENGINE=MyISAM AUTO_INCREMENT=133 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kb_mepdf`
--


--
-- Table structure for table `kb_mephoto`
--

CREATE TABLE `kb_mephoto` (
  `photoid` int NOT NULL AUTO_INCREMENT,
  `logprid` varchar(100) DEFAULT NULL,
  `logjobno` varchar(255) DEFAULT NULL,
  `photodate` date DEFAULT NULL,
  `photofile` varchar(500) DEFAULT NULL,
  `photodec` varchar(500) DEFAULT NULL,
  `photoflag` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`photoid`)
) ENGINE=MyISAM AUTO_INCREMENT=126 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kb_mephoto`
--


--
-- Table structure for table `kb_metest`
--

CREATE TABLE `kb_metest` (
  `testid` int NOT NULL AUTO_INCREMENT,
  `logprid` varchar(100) DEFAULT NULL,
  `logjobno` varchar(500) DEFAULT NULL,
  `testdate` date DEFAULT NULL,
  `testfile` varchar(500) DEFAULT NULL,
  `testflag` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`testid`)
) ENGINE=MyISAM AUTO_INCREMENT=95 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kb_metest`
--


--
-- Table structure for table `kb_project`
--

CREATE TABLE `kb_project` (
  `prid` int NOT NULL AUTO_INCREMENT,
  `prno` varchar(20) DEFAULT NULL,
  `prname` varchar(500) DEFAULT NULL,
  `pradd` varchar(500) DEFAULT NULL,
  `prdec` text,
  `prstatus` text,
  `prexdate` date DEFAULT NULL,
  `prphoto1` varchar(200) DEFAULT NULL,
  `prphoto2` varchar(200) DEFAULT NULL,
  `prphoto3` varchar(200) DEFAULT NULL,
  `prphoto4` varchar(200) DEFAULT NULL,
  `prphoto5` varchar(200) DEFAULT NULL,
  `prphoto6` varchar(200) DEFAULT NULL,
  `prphoto7` varchar(200) DEFAULT NULL,
  `prphoto8` varchar(200) DEFAULT NULL,
  `prphoto9` varchar(200) DEFAULT NULL,
  `prphoto10` varchar(200) DEFAULT NULL,
  `prcat` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`prid`),
  UNIQUE KEY `prid` (`prid`)
) ENGINE=MyISAM AUTO_INCREMENT=113 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kb_project`
--

INSERT INTO `kb_project` VALUES (14,'SR08','Jay Kruppa CHSL','Santacruz (W)','<li> Constructable area of 32,000 sq ft.</li>\r\n<li> Development agreement to be approved by society</li>\r\n<li> Plans finalised </li>\r\n\r\n','','0000-00-00','SR0830.jpg','SR0831.jpg','SR0832.jpg','','','','','','','','3'),(94,'SR241','Syndicate Bank Staff “ABHIMAN” Co-op. Hsg. Soc. Ltd.',' Shimpoli Road, Borivali (West),','<li> Construction Area  :  30,000 sft. <br>\r\n<li> Appointed for Phase II <br>\r\n<li> Appointed Developer to be done\r\nAs a part of Sharad Bakshi Architects <br><br>\r\n\r\n\r\n<li><bl> WORK  IN  PROGRESS</li>\r\n\r\na) POCLAIN   ON  TOP  OF  THE  DEBRIS. <br>\r\nb) VIEW  OF  WING  ‘A’ –  TOP  DEMOLISHED','','0000-00-00','SR24130.jpg','SR24131.jpeg','SR24132.jpeg','','','','','','','','3'),(24,'PMC01','Suvidha Square','Amboli, Andheri  (W)','','CONSTRUCTION MANAGEMENT<br>\r\n<li>Commercial Structure at Andheri West, spread over 1,25,000 sq ft. of\r\ntotal construction area.<br>\r\n<li>Comprises of Basement, Ground floor and 9 Upper floors.<br>\r\n<li>Major construction is done in Post Tensioning ( P T).<br>\r\n<li>Facade is in structural glazing, ACP and Aluminium Louvers\r\n<li> All  9 floors  completed with glass cladding and ACP.</li>\r\n<li>Part occupation certificate received and shifted existing shops on ground floor.\r\n</li>\r\n<li> Construction completed for Phase 1</li>\r\n<li> Vertical extension of about 4 floors to commence Phase 2.</li><br>','0000-00-00','PMC0120.jpg','PMC0121.jpg','PMC0122.jpg','PMC0123.jpg','PMC0124.jpg','PMC0125.jpg','','','PMC0128.jpg','PMC0129.jpg','2'),(82,'SR242','Bhandari Chs','Nehru  Nagar,  Kanjurmarg (East)','<li> Constructable  Area  - 1,10,000 sft.\r\n<li> Developer appointed through  Dy.Registrar\'s process \r\n<li> Plans and DA approved by society \r\n<li> plans submitted to MCGM for IOD','','0000-00-00','SR24230.jpg','','','','','','','','','','3'),(25,'PMC02','Hotel Reeva','5 Star Hotel - Shirdi','Structure for proposed 4/5 star hotel at Shirdi, Maharashtra. It is spread over  75,000 \r\nsft. of total constructable area.<br><br>\r\nComprises of Ground floor, Service floor  and Upper  7 floors.<br><br>\r\nIt has a swimming pool and kids pool at terrace level.<br><br>\r\nFacade is in textured paint , ACP and glazing.\r\n','<li>RCC work, brickwork, internal & external plastering is completed</li><br>\r\n<li> Electrical, plumbing , HVAC  work  is near completion. \r\n<li> On Hold Currently </li>','0000-00-00','PMC0220.jpg','PMC0221.START WORK.jpg','PMC0222.RCC WORK.jpg','PMC0223.slab work progress.jpg','PMC0224.fourth floor work.jpg','PMC0225.COMPLATE CONSTRUCTION.JPG','','','','','2'),(105,'SR19','Mahavir Nagar Shri Siddhi Vinayak CHSL - SELF REDEVELOPMENT','Mahavir Nagar, Kandivali (W)','<li>Self Redevelopment of society\r\n<li>Plot area - 2,500 sq mts - MHADA layout\r\n<li>Construction of about 2,00,000 sq ft in Gr + 37 storeyed structure\r\n<li>Feasibility report and plans approved by society\r\n<li>As a partner of Ardeshir & Bakshi Associets\r\n','','0000-00-00','SR1930.mhv-ngr-pre-1-typ pln-20-01-03.pdf','SR1931.mhv-ngr-pre-1-typ pln-wng-a-20-01-03.pdf','SR1932.mhv-ngr-pre-1-typ pln-wng-b-20-01-03.pdf','','','','','','','','3'),(102,'SR061','Gandhinagar Group -1 CHS Assoc. ltd','Gandhi Nagar, Bandra East','<li> built up area 12,00,000 + sft.\r\n<li> Plot area approx 7.800 sq mts - MHADA layout\r\n    <li>  two  Developers are short listed\r\n<br>  (as a Partner of Renaissance PMC LLP)','','0000-00-00','SR06130.png','','','','','','','','','','3'),(57,'SR18','Jaymala Sadan Chs','Liberty Garden, Malad (W)','<li> Constructable area 43,000 sft.\r\n<li> Developer appointed.</li>\r\n<li>Plans submitted to MCGM for IOD','','0000-00-00','SR1830.jpg','','','','','','','','','','3'),(34,'AR 02','SAMRUDDHI','DADAR (W) -COMPLETED','50000 SFT.','','0000-00-00','AR 0210.jpg','','','','','','','','','','1'),(27,'PMC011','Suvidha Emerald ','Prabhadevi -  Dadar (W) - COMPLETED','','CONSTRUCTION MANAGEMENT<br>\r\n<li>Residential  Structural  at  Prabhadevi.</li>\r\n<li><b>21 floors  highrise with 4 podiums for car parking and 5th podium level  for swimming \r\npool, Club house</b></li>\r\n\r\n<li>Occupation Certificate Received.','0000-00-00','PMC01120.jpg','PMC01121.jpg','PMC01122.jpg','PMC01123.jpg','PMC01124.jpg','PMC01125.jpg','PMC01126.jpg','PMC01127.jpg','PMC01128.jpg','PMC01129.jpg','2'),(30,'PMC11','Parle Tilak Vidyalaya - COMPLETED','Vile Parle - E -COMPLETED','Parle  Tilik  Vidyalaya, Marathi  Medium , Vile Parle (E), 56,000 sft.\r\nCONSTRUCTION MANAGEMENT','<li>Structure  is  occupied.</li><br>\r\n<li>Occupation Certificate is received.</li><br>\r\n<li>Time  taken  to  complete-13  months for phase-1 & 09 more months for full \r\ncompletion \r\nincluding occupation certificate.</li> ','0000-00-00','PMC1120.PARLETILAK SCHOOL.jpg','PMC1121.working.jpg','PMC1122.working.jpg','PMC1123.construction.jpg','PMC1124.complate.jpg','PMC1125.complate.jpg','','','','','2'),(31,'PMC12','Magnet Hypermarket - COMPLETED','Pan India - COMPLETED','<li>For a chain of hypermarkets, Project coordination along with designing was done.</li>\r\n<br>\r\n<li>Stores were in different states in India, including Maharashtra.</li><br>\r\n<li>Smallest store was 12,000 sft and the largest at approx. 1,00,000 sq ft at single \r\nfloor plate at Ahmedabad.</li><br>\r\n<li>In all 10 stores were done in a span of 03 years</li><br>\r\n<li>The chain is operating only one store now.</li>','Completed','0000-00-00','PMC1220.jpg','PMC1221.jpg','PMC1222.jpg','','','','','','','','2'),(35,'AR 03','BUTTERFLY','DADAR (W) - COMPLETED','<li> 50000 SFT. ','','0000-00-00','AR 0310.php.jpg','AR 0311.php','','','','','','','','','1'),(36,'AR 04','Bungalow for Thadanis','BANDRA (W) _ COMPLETED','<li>5116 SFT.\r\n<li> in association with Design Culture Pvt Ltd','','0000-00-00','AR 0410.THADANI NORTH SIDE -- AT  -BANDRA- 5116 sft..jpg','AR 0411.THADANI NORTH SIDE -- AT BANDRA.jpg','','','','','','','','','1'),(38,'SR20','Borivali Raj Ratna CHS.','Yogi Nagar, Borivali (W) ','<li> Constructable are of 32,000 sq. ft.</li>\r\n<li> Developer is appointed</li>\r\n<li> Name od society on P.R. Card completed\r\n<li> D.A. & plan finalization in Progress</li>\r\n<li>As part of Sharad Bakshi, Architects\r\n<li>Society is exploring option of Self Redevelopment\r\n<li>As Sharad Bakshi PMC','','0000-00-00','SR2030.jpg','','','','','','','','','','3'),(39,'SR21','Om Vasudev CHS.','Devidas Lane, Borivali (W)','<li> Constructable area of 37,000 sq ft.</li>\r\n<li> New developer appointed</li>\r\n<li> DA & PLAN finalization </li>\r\nAs a part of Sharad Bakshi Architects','','0000-00-00','SR2130.jpg','SR2131.jpg','SR2132.jpg','','','','','','','','3'),(40,'SR25','M.S.C.Bank Staff Deepjyot  C.H.S. - COMPLETED','Shimpoli Road, Borivali (W)','<li> Constructable area of 25,000 sq ft.</li>\r\n<li> Developer  M/s Mahavir Corporation\r\n<li> work is completed 	\r\n<li> Occupation Certificate received.<br>\r\nas Sharad Bakshi PMC','','0000-00-00','SR2530.jpg','SR2531.dscf3185 3-9-2013.jpg','SR2532.jpg','','','','','','','','3'),(68,'SR12','Amber Palace - Sunder C.H.S. Ltd.','Vile Parle (E)','<li> Constructable Area - 35,000 sft.\r\n<li> DA & plan under preparation. ','','0000-00-00','SR1230.jpg','','','','','','','','','','3'),(79,'SR23','Om Sundar Vichar C.H.S. Ltd','Kastur Park, Borivali (West) ','<li> Construction Area - 80,500 sft.\r\n<li> Developer - M/s MODI   REALTY  AND  INFRA  BUILDCON   PVT.  LTD. <br><br>\r\n<li>WORK IN PROGRESS</li>\r\n\r\n     a)  SECOND  SLAB – WING ‘B’ CONCRETING IN PROGRESS <br>\r\n     b)  FRONT  SIDE  VIEW  FROM  SHOP','','0000-00-00','SR2330.ltd  - view.jpg','SR2331.jpeg','SR2332.jpeg','','','','','','','','3'),(53,'SR04','Swa- Griha Chs ','Prabhadevi, Dadar West','<li> Constructable area - 1,94,000 sq ft </li>\r\n<li> Construction is in progress.\r\n       Plinth is completed.\r\n','','0000-00-00','SR0430.jpg','SR0431.jpg','SR0432.webp','','','','','','','','3'),(49,'PMC018','Shree Sai Samarth Developers - A & B - COMPLETED','Prabhadevi','Comprises of Ground floor and Upper 17 residential floors for A & B wing.<br><br>\r\nCONSTRUCTION MANAGEMENT','17 floors RCC & brickwork completed. Internal & external Plastering, internal finishing, \r\nplumbing completed. Occupation Certificate Received. <br>\r\n<li> Occupied. ','0000-00-00','PMC0420.Sai Suvidha -B.jpg','PMC0421.start work.jpg','PMC0422.Plianth work.jpg','PMC0423.BRICK WORK COMPLATE.jpg','PMC0424.Plaster work complete.jpg','PMC0425.Painting work Complete.jpg','','','','','2'),(50,'PMC012','Bhagat Grandeur ','Link Road, Malad (W) - COMPLETED','','CONSTRUCTION MANAGEMENT<br>\r\n<li>Mixed User Structure at Link Road, Malad (W)<br>\r\n<bl>Basement + Ground + 17/ 18 floors highrise<br> \r\n<li>Total construction area about 2,03,000 sq ft<br>\r\n<li> Project Completed.<br>\r\n<li> Part Occupation Certificate received\r\n','0000-00-00','PMC0620.jpg','PMC01221.jpg','PMC01222.jpg','PMC01223.jpg','PMC01224.jpg','PMC01225.jpg','PMC01226.jpg','PMC01227.jpg','PMC01228.jpg','','2'),(103,'SR16','Sampada Chs','Telli Gully Cross Road, Andheri E','<li>Tender advertisement issued for developers.\r\n<li>As partner of Ardeshir & Bakshi Associates','','0000-00-00','','','','','','','','','','','3'),(104,'SR15','Sakar Swapna Chs - SELF REDEVELOPMENT','Dr. S. Radhakrishnan Cross Road, Andheri (E)','Self Redevelopment of Society\r\n<li>Construction area above 1,00,000+ sq ft\r\n<li> received upto 9th floor.\r\n<li>Existing structure demolished.\r\nAs part of Sharad Bakshi, Architects','','0000-00-00','SR1530.gr flr.pdf','SR1531.typ flr.pdf','SR1532.jpg','','','','','','','','3'),(89,'SR06','MIG -VI  CHS  Ltd.','Gandhi Nagar,  Bandra (E)','<li> built up area 10,50,000 + sft. - MHADA layout\r\n<li> Plot area approx 8.000 sq mts \r\n       <li>Development Agreement approved by society.\r\n       <li>Plans under discussion\r\n<br>  (as a Partner of Renaissance PMC LLP)','','0000-00-00','SR0630.jpg','','','','','','','','','','3'),(65,'PMC013','Suvidha Pearl ','P. M. Road, Vile Parle (E)','CONSTRUCTION MANAGEMENT\r\n<li> Two wings of 13 floors spread over almost 1,00,000 sq ft.</li>\r\n<li> It has rehab & sale component</li>\r\n<li> Parking tower for about 50 cars is provided for car parking  </li>\r\n<li>Swimming pool and landscaped garden at terrace level</li>\r\n\r\n    \r\n','<li> Rehab - OC received\r\n<li> Sale wing - OC received\r\n\r\n','2021-12-31','PMC01320.jpg','PMC01321.jpg','PMC01322.jpg','PMC01323.jpg','PMC01324.jpg','PMC01325.jpg','PMC01326.jpg','PMC01327.jpg','PMC01328.jpg','PMC01329.jpg','2'),(64,'SR22','Om Sadvichar Chs Ltd','Shimpoli Road, Borivali (W)','<li> Constructable area 53,000 sft\r\n<li> Developer appointed\r\n<li> Second Phase Work\r\n<li> Deemed Conveyance Received\r\n<li> Name of Society on P.R. Card is Completed \r\nAs a part of Sharad Bakshi Architects','','0000-00-00','SR2230.jpg','','','','','','','','','','3'),(74,'SR01','Parnali Chs ','Hindu Colony, Dadar (East)','<li> Construction Area 34,000 sft.\r\n<li>Development Agreement & Plans to be approved by society\r\n','','0000-00-00','SR0130.jpg','','','','','','','','','','3'),(78,'SR13','Date Bungalow C.H.S. , ','Vile Parle (East)','<li> Construction Area - 11,500 sft.\r\n<li> Feasibility Report under preparation ','','0000-00-00','SR1330.jpg','','','','','','','','','','3'),(91,'SR03','Mandarmala Chs','Dadar west','<li> area - 56,000 sq ft\r\n<li>Feasibility Report submitted to society','','0000-00-00','','','','','','','','','','','3'),(108,'PMC015','Lashkaria Empress','Link Road, Andheri West','Residential structure Gr + 2 podiums + 17 upper floor\r\nConstruction area about 80,000 sq ft\r\nTo be applied for Occupation Certificate shortly','','2020-06-30','PMC01520.jpg','PMC01521.jpg','','','','','','','','','2'),(84,'PMC014','M-19','MATUNGA EAST','<li> residential  Structure  at  Ambedkar Road, Matunga East 60,000 sft.<br>\r\n     of total constructable area.\r\n<li> Comprises of Basement + Ground floor+ Fourth Floor Podium + 15 Upper floors.','<li> Finishing work is in progress','2021-12-31','PMC01420.jpg','PMC1621.jpg','PMC1622.jpg','PMC01423.jpg','PMC01424.jpg','PMC01425.jpg','','','','','2'),(92,'PMC016','New Diu Township','Gir, Somnath, Gujrath','A township of about 100 bungalows, 2 apartment buildings of 9 floors each, club house, \r\ntemple etc.\r\nRCC frame completed for about 30 bungalows','','0000-00-00','PMC0920.png','PMC0921.png','PMC0922.tif','PMC0923.png','PMC0924.png','PMC0925.png','','','','','2'),(85,'SR05','Prashant  Chs.','Senapati Bapat Marg, - Matunga (W)','<li>  Constructable area  - 82,000 sft.\r\n<li>  Developer appointed by the society\r\n  <li>Development agreement & plan finalisation.','','0000-00-00','SR0530.jpg','','','','','','','','','','3'),(87,'SR17','Uday  Chs.  - SELF-REDEVELOPMENT','Ambamatha  Marg, Goregaon (W)','<li>  Constructable Area - 1,24,000 sft.\r\n<li>  Self redevelopment project\r\n<li>  As a partner of Ardeshir & Bakshi Associates\r\n','','0000-00-00','SR1730.jpg','','','','','','','','','','3'),(106,'SR243','Shri Ganesh Chs','Pant Nagar, Ghatkopar East','Construction area about 1,05,000 sq ft\r\nConstruction is in progress.\r\nRaft is casted.\r\nAs a partner of Ardeshir & Bakshi Associates','','0000-00-00','SR24330.57.59 pm.jpeg','','','','','','','','','','3'),(110,'SR051','Mahim Jardin CHSL ( Garden Apts)','Mahim','<li>Feasibility report approved by the society\r\n<li>Tender advertisement issued.','','0000-00-00','','','','','','','','','','','3'),(111,'SR161','Bee Jumbo Darshan CHSL','Andheri East','Feasibility report under preparation','','0000-00-00','','','','','','','','','','','3'),(112,'PMC0141','Red Stone','JVPD','<li>Premium residential project\r\n<li> Ground plus thirteen upper floors\r\n<li>submitted to M.C.G.M. for I.O.D.','','0000-00-00','PMC014120.jpg','','','','','','','','','','2');


