| Server IP : 127.0.0.1 / Your IP : 216.73.216.48 Web Server : Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12 System : Windows NT DESKTOP-3H4FHQJ 10.0 build 19045 (Windows 10) AMD64 User : win 10 ( 0) PHP Version : 8.2.12 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : D:/Desktop/setup/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 4.8.4 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Apr 02, 2020 at 09:40 AM -- Server version: 10.1.37-MariaDB -- PHP Version: 7.3.1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!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 utf8mb4 */; -- -- Database: `khalaf_sonsdb` -- -- -------------------------------------------------------- -- -- Table structure for table `adverttb` -- CREATE TABLE `adverttb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `building_name` varchar(255) NOT NULL, `location` varchar(255) NOT NULL, `building_no` varchar(255) NOT NULL, `road_no` varchar(255) NOT NULL, `bedroom_no` varchar(255) NOT NULL, `bathroom_no` varchar(255) NOT NULL, `price` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `kitchen` varchar(255) NOT NULL, `swimming_pool` varchar(255) NOT NULL, `suana` varchar(255) NOT NULL, `squash` varchar(255) NOT NULL, `furniture` varchar(255) NOT NULL, `gym` varchar(255) NOT NULL, `steam` varchar(255) NOT NULL, `balicon` varchar(255) NOT NULL, `image_url` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `adverttb` -- INSERT INTO `adverttb` (`id`, `user_id`, `building_name`, `location`, `building_no`, `road_no`, `bedroom_no`, `bathroom_no`, `price`, `description`, `kitchen`, `swimming_pool`, `suana`, `squash`, `furniture`, `gym`, `steam`, `balicon`, `image_url`, `curr_date`, `curr_time`) VALUES (1, '1', 'Real Suites A', 'Mahooz', '1036', '3321', '1', '1', '', 'Residential', 'Open', 'Yes', 'Yes', 'Yes', 'Fully Furnished', 'Yes', 'Yes', 'No', '521990193.JPG', '2019-03-22', '16:12:42'), (2, '1', 'Patrex Tower', 'Patrex', '', '', '1', '1', '', 'Residential', 'Closed', 'Yes', 'Yes', 'No', 'Fully Furnished', 'Yes', 'Yes', 'Yes', '1022832310.JPG', '2019-03-22', '16:21:52'), (3, '1', 'Salmaniya Plaza', 'Salmaniya', '', '', '2', '2', '', 'Residential', 'Open', 'Yes', 'No', 'No', 'Fully Furnished', 'Yes', 'No', 'No', '1412367304.JPG', '2019-03-23', '09:59:42'), (4, '1', 'Real Suites A', 'Mahooz', '1036', '3321', '2', '2', '', 'Residential', 'Open', 'Yes', 'Yes', 'Yes', 'Fully Furnished', 'Yes', 'Yes', 'No', '280516737.JPG', '2019-03-22', '16:14:48'), (5, '1', 'Saj 1', 'Mahooz', '', '', '2', '2', '', 'Residential', 'Closed', 'No', 'Yes', 'No', 'Semi Furnished', 'Yes', 'Yes', 'Yes', '655326602.JPG', '2019-03-23', '11:06:55'), (6, '1', 'Real Suites B', 'Mahooz', '1038', '3321', '2', '2', '', 'Residential', 'Open', 'Yes', 'Yes', 'Yes', 'Fully Furnished', 'Yes', 'Yes', 'No', '1567143876.JPG', '2019-03-22', '16:30:16'), (7, '1', 'Real Suites B', 'Mahooz', '1038', '3321', '1', '1', '', 'Residential', 'Open', 'Yes', 'Yes', 'Yes', 'Fully Furnished', 'Yes', 'Yes', 'No', '1716607035.JPG', '2019-03-22', '16:36:27'), (8, '1', 'Adliya Tower', 'Adliya', '', '', '1', '1', '', 'Office', 'Closed', 'No', 'No', 'No', 'Un Furnished', 'No', 'No', 'No', '647539857.JPG', '2019-03-23', '09:53:56'), (9, '1', 'Real Suites A', 'Mahooz', '1036', '3321', 'Studio', '1', '', 'Residential', 'Open', 'Yes', 'Yes', 'Yes', 'Fully Furnished', 'Yes', 'Yes', 'No', '1711404267.JPG', '2019-03-22', '16:19:24'), (10, '1', 'Salmaniya Plaza', 'Salmaniya', '', '', '1', '1', '', 'Residential', 'Open', 'Yes', 'No', 'No', 'Fully Furnished', 'No', 'No', 'No', '426912845.JPG', '2019-03-23', '10:14:33'), (11, '1', 'Saj 1', 'Mahooz', '', '', '2', '2', '', 'Residential', 'Closed', 'No', 'Yes', 'No', 'Semi Furnished', 'Yes', 'Yes', 'No', '1147310389.JPG', '2019-03-23', '11:02:36'), (12, '1', 'Patrex Tower', 'Patrex', '', '', '2', '2', '', 'Residential', 'Closed', 'Yes', 'Yes', 'No', 'Fully Furnished', 'Yes', 'Yes', 'Yes', '814633903.JPG', '2019-03-22', '16:26:16'), (13, '1', 'Lenox 1', 'Segeya', '1627', '3241', '2', '2', '', 'Residential', 'Closed', 'No', 'Yes', 'No', 'Fully Furnished', 'No', 'No', 'No', '1939682329.JPG', '2019-05-04', '17:40:46'), (14, '1', 'Lenox 1', 'Segeya', '1627', '3241', '1', '1', '', 'Residential', 'Closed', 'No', 'No', 'No', 'Semi Furnished', 'Yes', 'No', 'No', '2143866705.JPG', '2019-05-05', '11:04:23'), (15, '1', 'Lenox 2', 'Segeya', '1625', '3241', '2', '2', '', 'Residential', 'Closed', 'No', 'No', 'No', 'Fully Furnished', 'No', 'No', 'No', '339139075.JPG', '2019-05-05', '11:24:24'), (16, '1', 'Lenox 2', 'Segeya', '1625', '3241', '1', '1', '', 'Residential', 'Closed', 'No', 'No', 'No', 'Fully Furnished', 'No', 'No', 'No', '954750471.JPG', '2019-05-05', '11:27:36'), (17, '1', 'Saj 2', 'Mahooz', '922', '3318', '2', '2', '360', 'Residential', 'Closed', 'No', 'No', 'No', 'Semi Furnished', 'Yes', 'No', 'Yes', '356673589.jpg', '2019-07-06', '11:19:42'), (18, '1', 'Brown Tower', 'Juffair', '767', '2412', '2', '2', '', 'Residential', 'Closed', 'Yes', 'Yes', 'Yes', 'Fully Furnished', 'Yes', 'Yes', 'Yes', '11347453.jpeg', '2020-02-27', '13:00:23'), (19, '1', 'Brown Tower', 'Juffair', '767', '2412', 'Studio', '1', '', 'Residential', 'Open', 'Yes', 'Yes', 'Yes', 'Fully Furnished', 'Yes', 'Yes', 'Yes', '1834877323.jpeg', '2020-02-27', '13:02:27'), (20, '1', 'Tubli Center', 'Tubli', '1288', '1325', '4', '1', '', 'Shop', 'Open', 'No', 'No', 'No', 'Un Furnished', 'No', 'No', 'No', '569791994.jpeg', '2020-02-27', '14:39:46'), (21, '1', 'Brown Tower', 'Mahooz', '767', '2412', '2', '2', '', 'Residential', 'Closed', 'Yes', 'Yes', 'Yes', 'Fully Furnished', 'Yes', 'Yes', 'No', '1619454479.jpeg', '2020-02-27', '14:44:10'), (22, '1', 'Brown Tower', 'Juffair', '767', '2412', '2', '2', '', 'Residential', 'Closed', 'Yes', 'Yes', 'Yes', 'Fully Furnished', 'Yes', 'Yes', 'Yes', '2145722713.jpeg', '2020-02-27', '14:48:32'), (23, '1', 'Brown Tower', 'Juffair', '767', '2412', '2', '2', '', 'Residential', 'Closed', 'Yes', 'Yes', 'Yes', 'Fully Furnished', 'Yes', 'Yes', 'Yes', '402675974.jpeg', '2020-02-27', '14:52:17'), (24, '1', 'Tubli Center', 'Tubli', '1288', '1325', '5', '1', '', 'Office', 'Open', 'No', 'No', 'No', 'Un Furnished', 'No', 'No', 'Yes', '1207550308.jpeg', '2020-02-27', '14:57:55'), (25, '1', 'Tubli Center', 'Tubli', '1288', '1325', '3', '1', '', 'Office', 'Open', 'No', 'No', 'No', 'Un Furnished', 'No', 'No', 'No', '786869360.jpeg', '2020-02-27', '15:00:48'), (26, '1', 'Tubli Center', 'Tubli', '1288', '1325', 'Large', '1', '', 'Show Room', 'Open', 'No', 'No', 'No', 'Un Furnished', 'No', 'No', 'Yes', '1829611428.jpeg', '2020-03-17', '15:28:50'); -- -------------------------------------------------------- -- -- Table structure for table `advert_albumtb` -- CREATE TABLE `advert_albumtb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `post_id` varchar(255) NOT NULL, `building_name` varchar(255) NOT NULL, `building_no` varchar(255) NOT NULL, `location` varchar(255) NOT NULL, `image_url` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `advert_albumtb` -- INSERT INTO `advert_albumtb` (`id`, `user_id`, `post_id`, `building_name`, `building_no`, `location`, `image_url`, `curr_date`, `curr_time`) VALUES (1, '1', '1', 'Real Suites A', '1036', 'Mahooz', '1441234857.JPG', '2019-03-23', '12:03:02'), (2, '1', '1', 'Real Suites A', '1036', 'Mahooz', '1596341156.JPG', '2019-03-23', '12:03:13'), (3, '1', '1', 'Real Suites A', '1036', 'Mahooz', '1290549276.JPG', '2019-03-23', '12:06:07'), (4, '1', '1', 'Real Suites A', '1036', 'Mahooz', '152487108.JPG', '2019-03-23', '12:06:23'), (5, '1', '4', 'Real Suites A', '1036', 'Mahooz', '646521173.JPG', '2019-03-23', '12:09:36'), (6, '1', '4', 'Real Suites A', '1036', 'Mahooz', '679089202.JPG', '2019-03-23', '12:12:52'), (7, '1', '4', 'Real Suites A', '1036', 'Mahooz', '685168566.JPG', '2019-03-23', '12:15:12'), (8, '1', '4', 'Real Suites A', '1036', 'Mahooz', '830449926.JPG', '2019-03-23', '12:15:34'), (9, '1', '7', 'Real Suites B', '1038', 'Mahooz', '517997250.JPG', '2019-03-23', '12:18:44'), (10, '1', '7', 'Real Suites B', '1038', 'Mahooz', '1352306324.JPG', '2019-03-23', '12:18:59'), (11, '1', '7', 'Real Suites B', '1038', 'Mahooz', '1155817171.JPG', '2019-03-23', '12:19:11'), (12, '1', '7', 'Real Suites B', '1038', 'Mahooz', '786500692.JPG', '2019-03-23', '12:19:21'), (13, '1', '9', 'Real Suites A', '1036', 'Mahooz', '1814585002.JPG', '2019-03-23', '12:21:31'), (14, '1', '9', 'Real Suites A', '1036', 'Mahooz', '60399969.JPG', '2019-03-23', '12:22:08'), (15, '1', '9', 'Real Suites A', '1036', 'Mahooz', '1933838893.JPG', '2019-03-23', '12:22:18'), (16, '1', '9', 'Real Suites A', '1036', 'Mahooz', '1856384435.JPG', '2019-03-23', '12:22:25'), (17, '1', '6', 'Real Suites B', '1038', 'Mahooz', '1180355296.JPG', '2019-03-23', '12:23:06'), (18, '1', '6', 'Real Suites B', '1038', 'Mahooz', '1669447230.JPG', '2019-03-23', '12:23:18'), (19, '1', '6', 'Real Suites B', '1038', 'Mahooz', '505844901.JPG', '2019-03-23', '12:23:36'), (20, '1', '6', 'Real Suites B', '1038', 'Mahooz', '422956229.JPG', '2019-03-23', '12:24:20'), (21, '1', '2', 'Patrex Tower', '', 'Patrex', '2054334651.JPG', '2019-03-23', '12:25:35'), (22, '1', '2', 'Patrex Tower', '', 'Patrex', '2067413336.JPG', '2019-03-23', '12:26:01'), (23, '1', '2', 'Patrex Tower', '', 'Patrex', '793795538.JPG', '2019-03-23', '12:26:40'), (24, '1', '2', 'Patrex Tower', '', 'Patrex', '324450368.JPG', '2019-03-23', '12:27:08'), (25, '1', '2', 'Patrex Tower', '', 'Patrex', '2141211203.JPG', '2019-03-23', '12:27:31'), (26, '1', '10', 'Salmaniya Plaza', '', 'Salmaniya', '1027441111.JPG', '2019-03-23', '13:02:12'), (27, '1', '10', 'Salmaniya Plaza', '', 'Salmaniya', '173792802.JPG', '2019-03-23', '13:02:41'), (28, '1', '10', 'Salmaniya Plaza', '', 'Salmaniya', '457590239.JPG', '2019-03-23', '13:03:08'), (29, '1', '3', 'Salmaniya Plaza', '', 'Salmaniya', '1821502762.JPG', '2019-03-23', '13:05:07'), (30, '1', '3', 'Salmaniya Plaza', '', 'Salmaniya', '1458831.JPG', '2019-03-23', '13:05:29'), (31, '1', '3', 'Salmaniya Plaza', '', 'Salmaniya', '1503278568.JPG', '2019-03-23', '13:05:53'), (32, '1', '5', 'Saj 1', '', 'Mahooz', '1727416769.JPG', '2019-03-23', '13:06:41'), (33, '1', '5', 'Saj 1', '', 'Mahooz', '580459341.JPG', '2019-03-23', '13:06:50'), (34, '1', '5', 'Saj 1', '', 'Mahooz', '1867694984.JPG', '2019-03-23', '13:06:56'), (38, '1', '11', 'Saj 1', '', 'Mahooz', '604588386.JPG', '2019-05-04', '17:20:16'), (39, '1', '11', 'Saj 1', '', 'Mahooz', '1151663666.JPG', '2019-05-04', '17:20:27'), (40, '1', '8', 'Adliya Tower', '', 'Adliya', '1148915686.JPG', '2019-05-04', '17:21:49'), (41, '1', '8', 'Adliya Tower', '', 'Adliya', '496623396.JPG', '2019-05-04', '17:22:05'), (42, '1', '12', 'Patrex Tower', '', 'Patrex', '8935211.JPG', '2019-05-04', '17:23:38'), (43, '1', '12', 'Patrex Tower', '', 'Patrex', '570698612.JPG', '2019-05-04', '17:23:48'), (44, '1', '12', 'Patrex Tower', '', 'Patrex', '2044557347.JPG', '2019-05-04', '17:24:00'), (45, '1', '13', 'Lenox 1', '2222', 'Segeya', '619539998.JPG', '2019-05-04', '17:42:07'), (46, '1', '13', 'Lenox 1', '2222', 'Segeya', '1772829081.JPG', '2019-05-04', '17:42:16'), (47, '1', '13', 'Lenox 1', '2222', 'Segeya', '711078413.JPG', '2019-05-04', '17:42:31'), (48, '1', '13', 'Lenox 1', '2222', 'Segeya', '1879496439.JPG', '2019-05-04', '17:42:45'), (49, '1', '13', 'Lenox 1', '2222', 'Segeya', '1060113289.JPG', '2019-05-04', '17:42:56'), (50, '1', '14', 'Lenox 1', '1627', 'Segeya', '46477619.JPG', '2019-05-05', '11:05:43'), (51, '1', '14', 'Lenox 1', '1627', 'Segeya', '611278288.JPG', '2019-05-05', '11:05:55'), (52, '1', '15', 'Lenox 2', '1625', 'Segeya', '2082159816.JPG', '2019-05-05', '11:29:11'), (53, '1', '15', 'Lenox 2', '1625', 'Segeya', '1142046559.JPG', '2019-05-05', '11:29:23'), (54, '1', '15', 'Lenox 2', '1625', 'Segeya', '1923126355.JPG', '2019-05-05', '11:29:37'), (55, '1', '15', 'Lenox 2', '1625', 'Segeya', '2141166203.JPG', '2019-05-05', '11:29:45'), (56, '1', '16', 'Lenox 2', '1625', 'Segeya', '2129218352.JPG', '2019-05-05', '11:31:05'), (57, '1', '16', 'Lenox 2', '1625', 'Segeya', '439796846.JPG', '2019-05-05', '11:31:24'), (58, '1', '16', 'Lenox 2', '1625', 'Segeya', '1471261010.JPG', '2019-05-05', '11:31:36'), (59, '1', '18', 'Brown Tower', '767', 'Juffair', '734585770.jpeg', '2020-02-27', '15:34:12'), (60, '1', '18', 'Brown Tower', '767', 'Juffair', '697830656.jpeg', '2020-02-27', '15:36:19'), (61, '1', '18', 'Brown Tower', '767', 'Juffair', '132406015.jpeg', '2020-02-27', '15:36:59'), (62, '1', '18', 'Brown Tower', '767', 'Juffair', '366696797.jpeg', '2020-02-27', '15:39:19'), (63, '1', '19', 'Brown Tower', '767', 'Juffair', '86309873.jpeg', '2020-02-27', '15:41:34'), (64, '1', '19', 'Brown Tower', '767', 'Juffair', '680466812.jpeg', '2020-02-27', '15:42:18'), (65, '1', '19', 'Brown Tower', '767', 'Juffair', '259515624.jpeg', '2020-02-27', '15:42:34'), (66, '1', '23', 'Brown Tower', '767', 'Juffair', '846541069.jpeg', '2020-02-27', '15:45:39'), (67, '1', '23', 'Brown Tower', '767', 'Juffair', '2131370265.jpeg', '2020-02-27', '15:47:03'), (68, '1', '23', 'Brown Tower', '767', 'Juffair', '1818027264.jpeg', '2020-02-27', '15:49:11'), (69, '1', '23', 'Brown Tower', '767', 'Juffair', '170775765.jpeg', '2020-02-27', '15:50:27'), (70, '1', '23', 'Brown Tower', '767', 'Juffair', '434954457.jpeg', '2020-02-27', '15:51:24'), (71, '1', '21', 'Brown Tower', '767', 'Mahooz', '1345076713.jpeg', '2020-02-27', '15:55:46'), (72, '1', '21', 'Brown Tower', '767', 'Mahooz', '818286083.jpeg', '2020-02-27', '15:58:55'), (73, '1', '21', 'Brown Tower', '767', 'Mahooz', '1393926389.jpeg', '2020-02-27', '16:00:07'), (74, '1', '21', 'Brown Tower', '767', 'Mahooz', '1461166095.jpeg', '2020-02-27', '16:01:24'), (75, '1', '22', 'Brown Tower', '767', 'Juffair', '1620763169.jpeg', '2020-02-27', '16:05:30'), (76, '1', '22', 'Brown Tower', '767', 'Juffair', '1173034937.jpeg', '2020-02-27', '16:06:39'), (77, '1', '22', 'Brown Tower', '767', 'Juffair', '745796309.jpeg', '2020-02-27', '16:12:28'), (78, '1', '22', 'Brown Tower', '767', 'Juffair', '1768686404.jpeg', '2020-02-27', '16:13:11'), (79, '1', '20', 'Tubli Center', '1288', 'Tubli', '332012597.jpeg', '2020-02-27', '16:34:13'), (80, '1', '20', 'Tubli Center', '1288', 'Tubli', '1735665089.jpeg', '2020-02-27', '16:36:03'), (81, '1', '24', 'Tubli Center', '1288', 'Tubli', '615752987.jpeg', '2020-02-27', '16:36:29'), (82, '1', '24', 'Tubli Center', '1288', 'Tubli', '1684679503.jpeg', '2020-02-27', '16:36:43'), (83, '1', '24', 'Tubli Center', '1288', 'Tubli', '894845819.jpeg', '2020-02-27', '16:37:01'), (84, '1', '24', 'Tubli Center', '1288', 'Tubli', '917213013.jpeg', '2020-02-27', '16:37:16'), (85, '1', '25', 'Tubli Center', '1288', 'Tubli', '1802099460.jpeg', '2020-02-27', '16:38:27'), (86, '1', '25', 'Tubli Center', '1288', 'Tubli', '2062795776.jpeg', '2020-02-27', '16:40:09'), (87, '1', '25', 'Tubli Center', '1288', 'Tubli', '1075424729.jpeg', '2020-02-27', '16:40:10'), (88, '1', '26', 'Tubli Center', '1288', 'Tubli', '908691589.jpeg', '2020-03-17', '15:33:31'), (89, '1', '26', 'Tubli Center', '1288', 'Tubli', '1799647951.jpeg', '2020-03-17', '15:33:40'), (90, '1', '26', 'Tubli Center', '1288', 'Tubli', '1096979283.jpeg', '2020-03-17', '15:33:54'), (91, '1', '26', 'Tubli Center', '1288', 'Tubli', '372676329.jpeg', '2020-03-17', '15:34:05'), (92, '1', '26', 'Tubli Center', '1288', 'Tubli', '320237730.jpeg', '2020-03-17', '15:34:14'); -- -------------------------------------------------------- -- -- Table structure for table `ad_viewstb` -- CREATE TABLE `ad_viewstb` ( `id` int(11) NOT NULL, `advert_id` varchar(255) NOT NULL, `user_ip` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `ad_viewstb` -- INSERT INTO `ad_viewstb` (`id`, `advert_id`, `user_ip`, `country`, `city`, `curr_date`, `curr_time`) VALUES (1, '17', '66.249.64.154', 'United States', '', '2020-02-04', '08:30:37'), (2, '5', '66.249.64.156', 'United States', '', '2020-02-04', '10:21:00'), (3, '14', '66.249.64.156', 'United States', '', '2020-02-04', '11:10:57'), (4, '13', '66.249.64.152', 'United States', '', '2020-02-04', '11:21:09'), (5, '1', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-04', '12:47:03'), (6, '12', '66.249.64.152', 'United States', '', '2020-02-04', '18:03:04'), (7, '17', '66.249.64.152', 'United States', '', '2020-02-04', '19:02:53'), (8, '11', '66.249.64.156', 'United States', '', '2020-02-04', '19:13:14'), (9, '3', '66.249.73.25', 'United States', '', '2020-02-04', '21:53:41'), (10, '5', '66.249.73.24', 'United States', '', '2020-02-05', '01:54:01'), (11, '15', '66.249.73.24', 'United States', '', '2020-02-05', '03:44:45'), (12, '17', '66.249.73.25', 'United States', '', '2020-02-05', '04:31:29'), (13, '3', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-05', '08:29:25'), (14, '2', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-05', '08:30:40'), (15, '4', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-05', '08:31:25'), (16, '5', '66.249.73.23', 'United States', '', '2020-02-05', '11:40:55'), (17, '3', '66.249.68.24', 'United States', '', '2020-02-05', '19:33:18'), (18, '6', '54.36.150.67', 'France', '', '2020-02-06', '18:38:08'), (19, '3', '54.36.148.106', 'France', '', '2020-02-07', '12:59:21'), (20, '8', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:27:18'), (21, '9', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:28:08'), (22, '10', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:28:47'), (23, '11', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:29:40'), (24, '12', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:30:02'), (25, '13', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:30:49'), (26, '15', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:32:02'), (27, '17', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:32:24'), (28, '16', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-08', '09:32:44'), (29, '7', '66.249.68.28', 'United States', '', '2020-02-08', '10:19:36'), (30, '17', '66.249.68.28', 'United States', '', '2020-02-08', '11:09:47'), (31, '17', '66.249.68.26', 'United States', '', '2020-02-08', '23:14:21'), (32, '14', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-16', '08:32:03'), (33, '5', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-19', '09:04:32'), (34, '16', '66.249.68.24', 'United States', '', '2020-02-20', '23:26:22'), (35, '16', '66.249.68.26', 'United States', '', '2020-02-21', '00:27:04'), (36, '7', '46.229.168.134', 'United States', 'Ashburn', '2020-02-21', '05:07:07'), (37, '5', '54.36.148.40', 'France', '', '2020-02-22', '09:56:26'), (38, '16', '66.249.68.28', 'United States', '', '2020-02-22', '10:20:02'), (39, '9', '54.36.150.181', 'France', '', '2020-02-22', '10:25:55'), (40, '14', '54.36.150.129', 'France', '', '2020-02-22', '10:44:28'), (41, '4', '54.36.148.27', 'France', '', '2020-02-23', '12:43:42'), (42, '5', '46.229.168.148', 'United States', 'Ashburn', '2020-02-24', '08:36:35'), (43, '13', '46.229.168.151', 'United States', 'Ashburn', '2020-02-25', '00:49:00'), (44, '16', '46.229.168.138', 'United States', 'Ashburn', '2020-02-25', '04:01:20'), (45, '13', '54.36.148.196', 'France', '', '2020-02-25', '09:09:48'), (46, '11', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:50:56'), (47, '12', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:50:57'), (48, '13', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:50:58'), (49, '14', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:50:59'), (50, '15', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:51:00'), (51, '16', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:51:00'), (52, '17', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:51:01'), (53, '10', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:51:03'), (54, '8', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:51:05'), (55, '9', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:51:06'), (56, '1', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:51:06'), (57, '2', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:51:07'), (58, '3', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:51:07'), (59, '4', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:51:09'), (60, '5', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:51:09'), (61, '6', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:51:10'), (62, '7', '211.56.145.140', 'Republic of Korea', '', '2020-02-25', '09:51:10'), (63, '17', '46.229.168.147', 'United States', 'Ashburn', '2020-02-25', '09:54:33'), (64, '1', '54.36.148.80', 'France', '', '2020-02-25', '16:16:12'), (65, '10', '46.229.168.141', 'United States', 'Ashburn', '2020-02-25', '18:47:55'), (66, '1', '46.229.168.134', 'United States', 'Ashburn', '2020-02-25', '21:30:41'), (67, '8', '46.229.168.144', 'United States', 'Ashburn', '2020-02-26', '05:58:31'), (68, '10', '54.36.148.208', 'France', '', '2020-02-26', '17:40:03'), (69, '12', '46.229.168.145', 'United States', 'Ashburn', '2020-02-26', '21:42:42'), (70, '3', '46.229.168.135', 'United States', 'Ashburn', '2020-02-26', '23:38:12'), (71, '12', '3.230.148.211', 'United States', '', '2020-02-27', '09:42:58'), (72, '11', '3.230.148.211', 'United States', '', '2020-02-27', '09:45:38'), (73, '10', '3.230.148.211', 'United States', '', '2020-02-27', '09:50:16'), (74, '9', '3.230.148.211', 'United States', '', '2020-02-27', '10:34:39'), (75, '8', '3.230.148.211', 'United States', '', '2020-02-27', '10:35:55'), (76, '7', '3.230.148.211', 'United States', '', '2020-02-27', '10:37:12'), (77, '6', '3.230.148.211', 'United States', '', '2020-02-27', '10:38:30'), (78, '5', '3.230.148.211', 'United States', '', '2020-02-27', '10:39:34'), (79, '4', '3.230.148.211', 'United States', '', '2020-02-27', '10:40:37'), (80, '3', '3.230.148.211', 'United States', '', '2020-02-27', '10:41:41'), (81, '2', '3.230.148.211', 'United States', '', '2020-02-27', '10:42:43'), (82, '1', '3.230.148.211', 'United States', '', '2020-02-27', '10:43:43'), (83, '17', '3.230.148.211', 'United States', '', '2020-02-27', '11:02:57'), (84, '16', '3.230.148.211', 'United States', '', '2020-02-27', '11:09:19'), (85, '15', '3.230.148.211', 'United States', '', '2020-02-27', '11:15:12'), (86, '14', '3.230.148.211', 'United States', '', '2020-02-27', '11:21:38'), (87, '13', '3.230.148.211', 'United States', '', '2020-02-27', '11:27:11'), (88, '23', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-27', '14:52:27'), (89, '18', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-27', '15:39:32'), (90, '19', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-27', '15:40:17'), (91, '21', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-27', '15:52:53'), (92, '22', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-27', '16:04:04'), (93, '24', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-27', '16:37:42'), (94, '25', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-27', '16:42:50'), (95, '20', '88.201.36.140', 'Bahrain', 'Manama', '2020-02-27', '16:43:19'), (96, '23', '66.249.79.247', 'United States', '', '2020-02-27', '23:35:14'), (97, '20', '66.249.79.245', 'United States', '', '2020-02-27', '23:35:21'), (98, '19', '66.249.79.243', 'United States', '', '2020-02-27', '23:35:58'), (99, '21', '66.249.79.247', 'United States', '', '2020-02-27', '23:36:14'), (100, '18', '66.249.79.243', 'United States', '', '2020-02-27', '23:36:31'), (101, '24', '66.249.79.243', 'United States', '', '2020-02-27', '23:36:53'), (102, '25', '66.249.79.247', 'United States', '', '2020-02-27', '23:43:36'), (103, '22', '66.249.79.247', 'United States', '', '2020-02-27', '23:45:58'), (104, '6', '46.229.168.147', 'United States', 'Ashburn', '2020-02-28', '05:15:23'), (105, '25', '66.249.79.50', 'United States', '', '2020-02-28', '18:22:55'), (106, '20', '66.249.79.50', 'United States', '', '2020-02-28', '18:23:13'), (107, '24', '66.249.79.50', 'United States', '', '2020-02-28', '18:23:32'), (108, '22', '66.249.79.47', 'United States', '', '2020-02-28', '18:23:52'), (109, '19', '66.249.79.47', 'United States', '', '2020-02-28', '18:24:17'), (110, '18', '66.249.79.47', 'United States', '', '2020-02-28', '18:24:51'), (111, '23', '66.249.79.50', 'United States', '', '2020-02-28', '18:25:43'), (112, '21', '66.249.79.50', 'United States', '', '2020-02-28', '18:26:33'), (113, '15', '46.229.168.142', 'United States', 'Ashburn', '2020-02-28', '18:33:08'), (114, '11', '46.229.168.136', 'United States', 'Ashburn', '2020-02-28', '18:36:10'), (115, '2', '46.229.168.146', 'United States', 'Ashburn', '2020-02-29', '03:10:54'), (116, '8', '66.249.64.216', 'United States', '', '2020-02-29', '08:48:05'), (117, '5', '66.249.64.216', 'United States', '', '2020-02-29', '09:47:02'), (118, '2', '66.249.64.216', 'United States', '', '2020-02-29', '11:11:42'), (119, '7', '66.249.64.212', 'United States', '', '2020-02-29', '12:33:12'), (120, '4', '66.249.64.212', 'United States', '', '2020-02-29', '13:50:24'), (121, '6', '66.249.64.214', 'United States', '', '2020-02-29', '14:59:22'), (122, '3', '66.249.64.216', 'United States', '', '2020-02-29', '16:05:43'), (123, '9', '66.249.64.214', 'United States', '', '2020-02-29', '17:25:09'), (124, '1', '66.249.64.216', 'United States', '', '2020-02-29', '18:40:19'), (125, '20', '66.249.73.88', 'United States', '', '2020-02-29', '20:04:26'), (126, '14', '46.229.168.142', 'United States', 'Ashburn', '2020-03-01', '00:53:08'), (127, '16', '66.249.73.88', 'United States', '', '2020-03-01', '06:04:51'), (128, '13', '66.249.73.84', 'United States', '', '2020-03-01', '07:27:51'), (129, '15', '66.249.73.88', 'United States', '', '2020-03-01', '08:40:21'), (130, '10', '66.249.73.84', 'United States', '', '2020-03-01', '09:57:29'), (131, '14', '66.249.73.84', 'United States', '', '2020-03-01', '11:19:29'), (132, '21', '66.249.73.88', 'United States', '', '2020-03-01', '12:21:30'), (133, '11', '66.249.73.86', 'United States', '', '2020-03-01', '13:37:27'), (134, '24', '66.249.73.84', 'United States', '', '2020-03-01', '15:05:22'), (135, '12', '66.249.73.86', 'United States', '', '2020-03-01', '16:11:14'), (136, '2', '66.249.73.88', 'United States', '', '2020-03-01', '17:28:20'), (137, '8', '66.249.73.86', 'United States', '', '2020-03-01', '17:28:50'), (138, '5', '66.249.73.84', 'United States', '', '2020-03-01', '17:29:03'), (139, '6', '66.249.73.86', 'United States', '', '2020-03-01', '17:29:07'), (140, '3', '66.249.73.84', 'United States', '', '2020-03-01', '17:29:11'), (141, '9', '66.249.73.84', 'United States', '', '2020-03-01', '17:29:19'), (142, '16', '66.249.73.84', 'United States', '', '2020-03-01', '17:29:24'), (143, '7', '66.249.73.84', 'United States', '', '2020-03-01', '17:29:41'), (144, '4', '66.249.73.84', 'United States', '', '2020-03-01', '17:29:53'), (145, '15', '66.249.73.84', 'United States', '', '2020-03-01', '17:30:01'), (146, '23', '66.249.73.86', 'United States', '', '2020-03-01', '17:30:02'), (147, '1', '66.249.73.86', 'United States', '', '2020-03-01', '17:30:13'), (148, '11', '66.249.73.84', 'United States', '', '2020-03-01', '17:30:34'), (149, '7', '66.249.73.180', 'United States', '', '2020-03-01', '17:30:48'), (150, '6', '66.249.73.182', 'United States', '', '2020-03-01', '17:30:54'), (151, '3', '66.249.73.180', 'United States', '', '2020-03-01', '17:30:58'), (152, '12', '66.249.73.182', 'United States', '', '2020-03-01', '17:31:03'), (153, '12', '66.249.73.88', 'United States', '', '2020-03-01', '17:31:09'), (154, '17', '66.249.73.182', 'United States', '', '2020-03-01', '17:31:18'), (155, '17', '66.249.73.84', 'United States', '', '2020-03-01', '17:31:49'), (156, '4', '66.249.73.180', 'United States', '', '2020-03-01', '17:31:58'), (157, '5', '66.249.73.180', 'United States', '', '2020-03-01', '17:32:13'), (158, '9', '66.249.73.180', 'United States', '', '2020-03-01', '17:32:22'), (159, '8', '66.249.73.180', 'United States', '', '2020-03-01', '17:32:39'), (160, '2', '66.249.73.180', 'United States', '', '2020-03-01', '17:32:47'), (161, '1', '66.249.73.180', 'United States', '', '2020-03-01', '17:33:10'), (162, '15', '66.249.73.180', 'United States', '', '2020-03-01', '17:33:50'), (163, '16', '66.249.73.180', 'United States', '', '2020-03-01', '17:34:22'), (164, '13', '66.249.73.180', 'United States', '', '2020-03-01', '17:34:45'), (165, '10', '66.249.73.180', 'United States', '', '2020-03-01', '17:34:54'), (166, '14', '66.249.73.184', 'United States', '', '2020-03-01', '17:35:02'), (167, '11', '66.249.73.180', 'United States', '', '2020-03-01', '17:35:08'), (168, '22', '66.249.73.88', 'United States', '', '2020-03-01', '17:36:03'), (169, '24', '66.249.73.86', 'United States', '', '2020-03-01', '17:41:20'), (170, '18', '66.249.73.86', 'United States', '', '2020-03-01', '18:39:15'), (171, '17', '66.249.79.247', 'United States', '', '2020-03-01', '21:15:37'), (172, '22', '66.249.79.243', 'United States', '', '2020-03-01', '22:53:52'), (173, '9', '46.229.168.131', 'United States', 'Ashburn', '2020-03-03', '12:56:12'), (174, '15', '54.36.150.171', 'France', '', '2020-03-03', '19:33:22'), (175, '25', '66.249.68.28', 'United States', '', '2020-03-04', '06:24:36'), (176, '22', '66.249.68.24', 'United States', '', '2020-03-04', '06:24:53'), (177, '21', '66.249.68.28', 'United States', '', '2020-03-04', '06:25:15'), (178, '24', '66.249.68.26', 'United States', '', '2020-03-04', '06:27:39'), (179, '23', '66.249.68.24', 'United States', '', '2020-03-04', '06:27:40'), (180, '18', '66.249.68.26', 'United States', '', '2020-03-04', '06:27:40'), (181, '20', '66.249.68.24', 'United States', '', '2020-03-04', '06:27:41'), (182, '19', '66.249.68.24', 'United States', '', '2020-03-04', '06:27:42'), (183, '5', '66.249.68.26', 'United States', '', '2020-03-04', '18:27:19'), (184, '7', '66.249.68.26', 'United States', '', '2020-03-04', '20:37:53'), (185, '17', '66.249.68.24', 'United States', '', '2020-03-04', '22:48:33'), (186, '11', '66.249.68.28', 'United States', '', '2020-03-05', '00:58:54'), (187, '5', '66.249.68.28', 'United States', '', '2020-03-05', '04:40:39'), (188, '8', '54.36.149.42', 'France', '', '2020-03-05', '08:35:20'), (189, '22', '46.229.168.142', 'United States', 'Ashburn', '2020-03-05', '14:24:31'), (190, '12', '54.36.150.129', 'France', '', '2020-03-06', '03:33:32'), (191, '22', '81.22.30.101', 'Bahrain', 'Manama', '2020-03-06', '07:35:31'), (192, '16', '54.36.150.48', 'France', '', '2020-03-06', '15:36:20'), (193, '23', '81.22.30.101', 'Bahrain', 'Manama', '2020-03-06', '16:30:37'), (194, '10', '81.22.30.101', 'Bahrain', 'Manama', '2020-03-06', '16:31:27'), (195, '17', '46.229.168.141', 'United States', 'Ashburn', '2020-03-06', '17:19:42'), (196, '10', '46.229.168.146', 'United States', 'Ashburn', '2020-03-06', '23:46:13'), (197, '7', '54.36.150.13', 'France', '', '2020-03-07', '03:02:38'), (198, '8', '46.229.168.163', 'United States', 'Ashburn', '2020-03-07', '05:29:15'), (199, '23', '46.229.168.154', 'United States', 'Ashburn', '2020-03-09', '02:50:36'), (200, '3', '62.209.14.115', 'Bahrain', 'Manama', '2020-03-09', '14:49:22'), (201, '10', '37.131.58.102', 'Bahrain', 'Manama', '2020-03-09', '14:52:41'), (202, '8', '109.161.172.103', 'Bahrain', 'Manama', '2020-03-09', '14:56:48'), (203, '9', '109.161.172.103', 'Bahrain', 'Manama', '2020-03-09', '14:57:29'), (204, '4', '89.148.43.216', 'Bahrain', 'Manama', '2020-03-09', '15:27:58'), (205, '1', '37.131.55.23', 'Bahrain', '', '2020-03-09', '17:45:15'), (206, '1', '94.76.0.19', 'Bahrain', 'Al Muharraq', '2020-03-09', '20:04:24'), (207, '25', '188.137.141.150', 'Bahrain', '', '2020-03-10', '10:00:12'), (208, '6', '109.161.158.224', 'Bahrain', 'Manama', '2020-03-10', '14:18:50'), (209, '20', '158.69.54.207', 'Canada', 'Montreal', '2020-03-11', '12:28:07'), (210, '21', '158.69.54.207', 'Canada', 'Montreal', '2020-03-11', '12:28:08'), (211, '2', '158.69.54.207', 'Canada', 'Montreal', '2020-03-11', '12:28:09'), (212, '22', '158.69.54.207', 'Canada', 'Montreal', '2020-03-11', '12:28:10'), (213, '25', '81.22.30.101', 'Bahrain', 'Manama', '2020-03-11', '18:34:00'), (214, '18', '81.22.30.101', 'Bahrain', 'Manama', '2020-03-11', '18:34:56'), (215, '21', '95.84.109.165', 'Bahrain', '', '2020-03-14', '08:44:45'), (216, '19', '81.22.30.101', 'Bahrain', 'Manama', '2020-03-15', '06:09:12'), (217, '7', '81.22.30.101', 'Bahrain', 'Manama', '2020-03-15', '06:11:27'), (218, '20', '88.201.39.36', 'Bahrain', 'Manama', '2020-03-15', '15:12:40'), (219, '17', '66.249.79.227', 'United States', '', '2020-03-18', '02:32:39'), (220, '26', '66.249.79.62', 'United States', '', '2020-03-18', '03:14:29'), (221, '17', '66.249.79.38', 'United States', '', '2020-03-18', '09:31:25'), (222, '26', '88.201.36.140', 'Bahrain', 'Manama', '2020-03-18', '09:52:57'), (223, '23', '66.249.79.225', 'United States', '', '2020-03-22', '13:00:24'), (224, '21', '66.249.79.225', 'United States', '', '2020-03-22', '16:41:53'), (225, '18', '66.249.79.227', 'United States', '', '2020-03-22', '20:23:15'), (226, '23', '66.249.79.227', 'United States', '', '2020-03-22', '22:33:46'), (227, '26', '37.131.55.33', 'Bahrain', '', '2020-03-24', '17:32:53'), (228, '1', '81.22.30.101', 'Bahrain', 'Manama', '2020-03-29', '19:38:11'), (229, '23', '66.249.75.190', 'United States', '', '2020-03-31', '10:25:28'), (230, '21', '66.249.75.164', 'United States', '', '2020-03-31', '11:55:45'), (231, '17', '66.249.75.161', 'United States', '', '2020-03-31', '12:56:02'), (232, '21', '66.249.79.253', 'United States', '', '2020-03-31', '20:48:32'), (233, '17', '66.249.79.225', 'United States', '', '2020-03-31', '22:09:10'), (234, '21', '66.249.79.227', 'United States', '', '2020-04-01', '08:42:31'), (235, '2', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:30'), (236, '1', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:31'), (237, '3', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:34'), (238, '5', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:35'), (239, '4', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:35'), (240, '6', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:35'), (241, '7', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:38'), (242, '8', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:39'), (243, '9', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:40'), (244, '10', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:41'), (245, '11', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:42'), (246, '12', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:45'), (247, '13', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:46'), (248, '14', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:47'), (249, '15', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:47'), (250, '16', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:49'), (251, '17', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:51'), (252, '18', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:52'), (253, '20', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:54'), (254, '19', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:54'), (255, '21', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:56'), (256, '23', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:56'), (257, '22', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:56'), (258, '24', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:15:59'), (259, '25', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:16:00'), (260, '26', '41.69.93.94', 'Egypt', '', '2020-04-01', '15:16:03'); -- -------------------------------------------------------- -- -- Table structure for table `agent_calltb` -- CREATE TABLE `agent_calltb` ( `id` int(11) NOT NULL, `my_ip` varchar(255) NOT NULL, `user_id` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `agent_calltb` -- INSERT INTO `agent_calltb` (`id`, `my_ip`, `user_id`, `country`, `city`, `curr_date`, `curr_time`) VALUES (1, '157.39.196.236', '1', 'India', 'Jalandhar', '2020-03-09', '20:28:05'), (2, '188.137.141.150', '1', 'Bahrain', '', '2020-03-10', '10:01:46'); -- -------------------------------------------------------- -- -- Table structure for table `agent_viewtb` -- CREATE TABLE `agent_viewtb` ( `id` int(11) NOT NULL, `my_ip` varchar(255) NOT NULL, `user_id` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `agent_viewtb` -- INSERT INTO `agent_viewtb` (`id`, `my_ip`, `user_id`, `country`, `city`, `curr_date`, `curr_time`) VALUES (32, '54.36.148.37', '2', 'France', '', '2020-02-07', '04:19:17'), (33, '88.201.36.140', '1', 'Bahrain', 'Manama', '2020-02-13', '16:41:09'), (34, '54.36.150.32', '1', 'France', '', '2020-02-25', '00:58:57'), (35, '66.249.73.84', '1', 'United States', '', '2020-03-01', '17:35:48'), (36, '66.249.79.245', '1', 'United States', '', '2020-03-01', '23:08:50'), (37, '46.229.168.151', '1', 'United States', 'Ashburn', '2020-03-02', '03:49:02'), (38, '66.249.79.47', '1', 'United States', '', '2020-03-02', '15:59:37'), (39, '88.201.94.240', '1', 'Bahrain', '', '2020-03-08', '02:57:02'), (40, '89.148.63.106', '1', 'Bahrain', 'Manama', '2020-03-08', '11:56:43'), (41, '94.76.0.51', '1', 'Bahrain', 'Al Muharraq', '2020-03-09', '12:49:40'), (42, '95.84.104.135', '1', 'Bahrain', '', '2020-03-09', '13:59:02'), (43, '88.201.6.42', '1', 'Bahrain', 'Madinat Hamad', '2020-03-09', '16:18:20'), (44, '157.39.196.236', '1', 'India', 'Jalandhar', '2020-03-09', '20:27:56'), (45, '84.255.156.182', '1', 'Bahrain', '', '2020-03-10', '08:14:50'), (46, '188.137.141.150', '1', 'Bahrain', '', '2020-03-10', '10:01:37'), (47, '193.188.105.84', '1', 'Bahrain', 'Manama', '2020-03-17', '23:06:20'); -- -------------------------------------------------------- -- -- Table structure for table `bd_locationtb` -- CREATE TABLE `bd_locationtb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `location_name` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `bd_locationtb` -- INSERT INTO `bd_locationtb` (`id`, `user_id`, `location_name`, `curr_date`, `curr_time`) VALUES (1, '', 'Mahooz', '2019-02-14', '10:23:08'), (2, '', 'Juffair', '2019-02-14', '10:23:25'), (3, '', 'Tubli', '2019-02-14', '10:23:33'), (4, '1', 'Hoora', '2019-11-21', '16:22:35'), (5, '', 'Manama', '2019-02-14', '10:23:56'), (6, '', 'Salmaniya', '2019-02-14', '10:24:16'), (7, '', 'Adliya', '2019-02-14', '10:24:32'), (8, '', 'Un Al Hassam', '2019-02-14', '10:24:51'), (9, '', 'Panorama', '2019-02-14', '10:31:09'), (10, '', 'Segeya', '2019-02-14', '10:32:42'), (11, '1', 'Bu Ashira', '2019-11-21', '16:19:38'), (12, '1', 'Exhibition Road', '2019-11-21', '16:21:57'), (13, '1', 'Zinji', '2019-11-21', '16:22:19'); -- -------------------------------------------------------- -- -- Table structure for table `buliding_type` -- CREATE TABLE `buliding_type` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `buliding_name` varchar(255) NOT NULL, `location` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `buliding_type` -- INSERT INTO `buliding_type` (`id`, `user_id`, `buliding_name`, `location`, `description`, `curr_date`, `curr_time`) VALUES (1, '', 'Real Suites A', 'Mahooz', 'Residential', '2019-02-14', '10:25:29'), (2, '', 'Real Suites B', 'Mahooz', 'Residential', '2019-02-14', '10:25:44'), (3, '', 'Adliya Tower', 'Adliya', 'Office', '2019-02-14', '10:26:52'), (4, '', 'Adliya Tower', 'Adliya', 'Shop', '2019-02-14', '10:27:05'), (5, '', 'Patrex Tower', 'patrex', 'Residential', '2019-02-14', '10:27:59'), (6, '', 'Salmaniya Plaza', 'Salmaniya', 'Residential', '2019-02-14', '10:28:45'), (7, '', 'Saj 1', 'Un Al Hassam', 'Residential', '2019-02-14', '10:29:22'), (8, '', 'Saj 2', 'Mahooz', 'Residential', '2019-02-14', '10:29:36'), (9, '', 'Saj 3', 'Manama', 'Residential', '2019-02-14', '10:30:07'), (10, '', 'Saj 3', 'Manama', 'Office', '2019-02-14', '10:30:28'), (11, '', 'Saj 3', 'Manama', 'Shop', '2019-02-14', '10:30:39'), (12, '', 'Panorama Center', 'Panorama', 'Residential', '2019-02-14', '10:31:37'), (13, '', 'Panorama Center', 'Panorama', 'Shop', '2019-02-14', '10:32:16'), (14, '', 'Lenox 1', 'Segeya', 'Residential', '2019-02-14', '10:33:01'), (15, '', 'Lenox 2', 'Segeya', 'Residential', '2019-02-14', '10:33:21'), (16, '', 'Lenox 3', 'Segeya', 'Residential', '2019-02-14', '10:33:39'), (17, '1', 'Adel House', 'Bu Ashira', 'Residential', '2019-11-28', '16:04:02'); -- -------------------------------------------------------- -- -- Table structure for table `complainttb` -- CREATE TABLE `complainttb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `building_name` varchar(255) NOT NULL, `flat_no` varchar(255) NOT NULL, `complaint_detail` text NOT NULL, `complaint_by` varchar(255) NOT NULL, `complaint_to` varchar(255) NOT NULL, `comp_status` varchar(255) NOT NULL, `comp_finished_by` varchar(255) NOT NULL, `id_edit_comp_to` varchar(255) NOT NULL, `id_edit_comp_status` varchar(255) NOT NULL, `id_edit_comp_done_by` varchar(255) NOT NULL, `curr_day` varchar(255) NOT NULL, `curr_month` varchar(255) NOT NULL, `curr_year` varchar(255) NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `complainttb` -- INSERT INTO `complainttb` (`id`, `my_id`, `building_name`, `flat_no`, `complaint_detail`, `complaint_by`, `complaint_to`, `comp_status`, `comp_finished_by`, `id_edit_comp_to`, `id_edit_comp_status`, `id_edit_comp_done_by`, `curr_day`, `curr_month`, `curr_year`, `curr_time`) VALUES (1, '1', 'Salmaniya Plaza', '23', 'No Tv signal,MBC not working ', 'Adul', 'Madan', 'Replaced New', 'Vicent', '1', '1', '1', '04', '02', '2020', '12:34:06'), (2, '1', 'Saj 2', '24', 'Tv give bad sound', 'Sayed H', 'Madan', 'Working', 'Vicent/Sayed M', '1', '1', '1', '04', '02', '2020', '12:35:39'), (3, '1', 'Saj 2', '11', 'Tv not working at all', 'Sayed H', 'Madan', 'Done', 'Vicent/Sayed M', '1', '1', '1', '04', '02', '2020', '12:36:48'), (4, '1', 'Saj 2', '12', 'Water leak form roof top to bedroom comp by Client ', 'Abid', 'Jose', 'Working', 'Jose/Sebin', '1', '1', '1', '05', '02', '2020', '15:06:41'), (5, '1', 'Panorama Center', '54', 'Tv not working locked with password smart tv', 'Suresh', 'Jamil/Madan', 'Done', 'Vicent/Hakim/Sayed M', '1', '1', '1', '05', '02', '2020', '15:31:26'), (6, '1', 'Lenox 2', '24', 'Fridge working but bad smell coming out', 'Dinesh', 'Madan', 'Replaced New', 'Madan/salam gas', '1', '1', '1', '06', '02', '2020', '08:24:17'), (7, '1', 'Real Suites A', '92', 'Water heater not working', 'Jihad', 'Jose/Sebin', 'Done', 'Jose/Sebin', '1', '', '', '06', '02', '2020', '08:41:13'), (8, '1', 'Panorama Center', '51', 'One sofa damaged need repair', 'Suresh', 'Madan', 'No Action', '', '1', '', '', '06', '02', '2020', '08:42:03'), (9, '1', 'Panorama Center', '45', 'Mattress not good', 'Suresh', 'Madan', 'Failed', 'Madan', '1', '', '1', '06', '02', '2020', '08:42:38'), (10, '1', 'Panorama Center', '36', 'There is water leak in the bathroom', 'Suresh', 'Madan', 'Done', 'Suresh', '1', '', '1', '06', '02', '2020', '08:43:46'), (11, '1', 'Saj 2', '13', 'Sweet water machine tank not workingkitchen area', 'Sayed H', 'Madan', 'Working', 'Sayed H', '1', '1', '1', '06', '02', '2020', '10:48:34'), (12, '1', 'Lenox 1', '32', 'Kitchen light 2 not working', 'Tenant', 'Dinesh', 'Done', 'Dinesh', '1', '1', '1', '08', '02', '2020', '10:35:42'), (13, '1', 'Lenox 1', '32', 'kitchen cabinet top need to chane', 'Dinesh', 'Madan', 'Replaced New', 'Juipur inter D', '1', '', '', '09', '02', '2020', '11:53:14'), (14, '1', 'Real Suites A', '92', 'Water heater not woriking master bedroom', 'Sebin', 'Jose/Sebin', 'Working', 'Jose/Sebin', '1', '1', '1', '09', '02', '2020', '12:02:51'), (15, '1', 'Lenox 3', '42', 'Some Tv channels are not working', 'Tenant', 'M khalaf', 'Done', 'M Khalaf', '1', '1', '1', '09', '02', '2020', '13:14:34'), (16, '1', 'Lenox 3', 'Main tank', 'Ground tank overflow', 'Rajack', 'Madan/Hamad', 'Done', 'Jose/Sebin', '1', '', '', '09', '02', '2020', '14:22:02'), (17, '1', 'Lenox 1', '33', 'Bathroom,Shower basin broken cl 2:00pm', 'Dinesh', 'Madan', 'Done', 'Sebin/Dinesh', '1', '', '', '11', '02', '2020', '11:51:51'), (18, '434343', 'Lenox 3', 'All', 'Tank Water overflow ', 'Rajack', 'Jose', 'Done', 'Jose/Sebin', '', '', '', '12', '02', '2020', '15:08:48'), (19, '434343', 'Lenox 2', '12', 'water leak from roof', 'Abid', 'Madan', 'Failed', 'cancelled', '', '', '', '12', '02', '2020', '15:13:29'), (20, '434343', 'Saj 2', '33', 'Water leak washing machine', 'Sayed H', 'Ram', 'Done', 'Ram', '', '', '', '13', '02', '2020', '10:56:01'), (21, '921205929', 'Lenox 1', 'All', 'Pump not working', 'Dinesh', 'Jose/Sebin', 'Replaced New', 'Jose/Sebin', '', '', '', '09', '02', '2020', '15:38:27'), (22, '921205929', 'Lenox 1', 'all', 'pump not working ', 'Dinesh', 'Jose/Sebin', 'Replaced New', 'Jose/Sebin', '', '', '', '13', '02', '2020', '15:41:09'), (23, '434343', 'Saj 2', '21', 'Washing machine not working ', 'Luku', 'Madan', 'Replaced New', 'Madan', '', '', '', '15', '02', '2020', '09:54:08'), (24, '434343', 'Panorama Center', '64', 'Cooker not working', 'Sureh', 'Madan', 'Done', 'Ram', '', '', '', '17', '02', '2020', '10:06:38'), (25, '434343', 'Real Suites B', '83', 'Internet not working', 'Jihad', 'Vicent', 'Done', 'Vicent', '', '', '', '15', '02', '2020', '10:11:10'), (26, '434343', 'Panorama Center', '22', 'I changed one Tv from Real suites A Store to Panorama flat 22 ord by Madan', 'Suresh', 'Madan', 'Replaced Old', 'Vicent/Sayed H', '', '', '', '17', '02', '2020', '15:39:23'), (27, '434343', 'Lenox 1', '31', 'No micro wave,Need one', 'Dinesh', 'Madan', 'Working', 'M khalaf', '', '', '', '17', '02', '2020', '15:42:14'), (28, '434343', 'Panorama Center', '63', 'Water leak from the sink', 'Suresh', 'Suresh', 'Done', 'Suresh', '', '', '', '18', '02', '2020', '15:33:15'), (29, '434343', 'Lenox 2', '22', 'There is AC leak tenant(2:00pm) ', 'Dinesh', 'Madan', 'Done', 'Ram', '', '', '', '18', '02', '2020', '15:35:25'), (30, '921205929', 'Real Suites A', '42', 'Rental paid ', 's.Jehad ', 'Jehad', 'Done', 'Jehad', '', '', '', '20', '02', '2020', '08:36:32'), (31, '921205929', 'Real Suites A', '62', 'a Customer her Name DR Amani she visit the building and she take a look for flat 62 ', 'S.Jehad ', 'Jehad', 'Done', 'Jehad', '', '', '', '20', '02', '2020', '08:38:07'), (32, '921205929', 'Panorama Center', '64', 'cooker not working ', 'Suresh ', 'Ram', 'Done', 'Ram', '', '', '', '20', '02', '2020', '08:47:38'), (33, '921205929', 'Real Suites A', '83', 'Rental Paid ', 'S.Jehad ', 'Jehad', 'Done', 'Jehad', '', '', '', '20', '02', '2020', '08:55:42'), (34, '921205929', 'Saj 2', '12', 'leak from the 22 flat and the water fall on His bedroom.', 'customer ', 'Madan', 'Working', '', '', '', '', '20', '02', '2020', '09:51:06'), (35, '921205929', 'Real Suites B', '82', 'issue with the fridge ', 'S.Jehad ', 'Ram', 'No Action', '', '', '', '', '20', '02', '2020', '15:49:40'), (36, '921205929', 'Lenox 2', '13', 'kitchen fan ', 'Denish ', 'Dinesh', 'Done', 'Dinesh', '', '', '', '22', '02', '2020', '08:53:16'), (37, '921205929', 'Panorama Center', '66', 'water heater not wrking ', 'suresh ', 'Suresh', 'Done', 'Suresh', '', '', '', '22', '02', '2020', '09:34:10'), (38, '921205929', 'Saj 2', '31', 'bathroom curtain and paint for the borders', 'S. Hassan ', 'Madan', 'Replaced New', 'M khalaf', '', '', '', '22', '02', '2020', '16:06:06'), (39, '921205929', 'Real Suites A', '', 'cleaning fabrics ', 's.jehad ', 'Order', 'Done', 'M Khalaf', '', '', '', '23', '02', '2020', '11:41:10'), (40, '921205929', 'Saj 2', '11', 'water leak', 's.hassan ', 'Jose', 'Working', '', '', '', '', '24', '02', '2020', '16:25:58'), (41, '921205929', 'Saj 2', '14 ', 'water filter have to be changed ', 's. hassan ', 'Sayed H', 'Replaced New', 'Sayed H', '', '', '', '25', '02', '2020', '10:49:17'), (42, '921205929', 'Saj 2', '45', 'leak with the sweet water ', 's.hassan ', '', '', '', '', '', '', '25', '02', '2020', '10:49:58'), (43, '921205929', 'Panorama Center', '23', 'window lock kitchen light ', 'Suresh ', 'Order', 'Done', 'M Khalaf', '', '', '', '26', '02', '2020', '10:32:22'), (44, '921205929', 'Lenox 2', 'loopy', 'loopy light ', 'Denish ', 'Order/Mk', '', '', '', '', '', '26', '02', '2020', '10:34:08'), (45, '921205929', 'Saj 1', '33', 'bedroom mirror ', 's. hassan ', 'Order', 'Replaced New', 'MK/Parkash', '', '', '', '26', '02', '2020', '11:02:17'), (46, '921205929', 'Panorama Center', 'f 56', 'cooker ', 'suresh', 'Order cooker switch', 'Done', 'M Khalaf', '', '', '', '27', '02', '2020', '09:03:51'), (47, '921205929', 'Panorama Center', 'f 25', 'sound from the A/C', 'suresh ', 'Madan', 'Done', 'Ram', '', '', '', '27', '02', '2020', '09:04:49'), (48, '434343', 'Panorama Center', '34', 'Sofa set need repair,it goes down when a person sits on it', 'Jamil', 'Madan', '', '', '', '', '', '27', '02', '2020', '16:42:08'), (49, '921205929', 'Saj 2', '41', 'internet issue and maybe with the all the building ', 'looko ', 'Vicent', 'Done', 'Vicent', '', '', '', '29', '02', '2020', '09:06:38'), (50, '921205929', 'Real Suites A', '22 ', 'A/C not working ', 's.jehad ', 'Ram', 'Done', 'Ram', '', '', '', '29', '02', '2020', '16:22:22'), (51, '921205929', 'Real Suites B', '61 ', 'the switch for the A/C need to be change ', 's. jehad ', 'Ram', 'Done', 'Ram', '', '', '', '29', '02', '2020', '16:23:25'), (52, '921205929', 'Saj 1', '83 ', 'mirror light full set ', 'looko ', 'Order', 'Done', 'M Khalaf', '', '', '', '01', '03', '2020', '08:36:06'), (53, '921205929', 'Panorama Center', '58 ', 'water leak inside kitchen ', 'Suresh', 'Suresh', 'Done', 'Suresh', '', '', '', '01', '03', '2020', '11:33:29'), (54, '921205929', 'Panorama Center', '51 ', 'there is sound from A/C on the bedroom ', 'sursh ', 'Ram', 'Done', 'Ram', '', '', '', '01', '03', '2020', '11:36:00'), (55, '921205929', 'Real Suites B', '74', 'mixer for the bathroom ', 's jehad ', 'Order/Mk', 'Replaced New', 'Jose/Sebin', '', '', '', '01', '03', '2020', '15:51:05'), (56, '921205929', 'Saj 2', '33', 'cooker not working ', 's.hassan ', 'Ram', 'Working', '', '', '', '', '01', '03', '2020', '15:52:57'), (57, '921205929', 'Panorama Center', '34', 'Oven not working ', 'Suresh ', 'Ram', 'Done', 'Ram', '', '', '', '02', '03', '2020', '08:50:55'), (58, '921205929', 'Panorama Center', '23', 'one light not working in the kitchen ', 'suresh ', 'Order/Mk', 'Replaced New', 'Suresh', '', '', '', '02', '03', '2020', '08:51:53'), (59, '921205929', 'Panorama Center', '22', 'T.V Not working ', 'suresh ', 'Change Ft31 to 22', 'Replaced Old', 'Suresh', '', '', '', '02', '03', '2020', '15:17:38'), (60, '921205929', 'Panorama Center', '53', 'the A/C not cold ', 'suresh ', 'Ram', 'Done', 'Ram', '', '', '', '03', '03', '2020', '16:25:39'), (61, '921205929', 'Panorama Center', '52', 'water broke ', 'suresh ', 'Suresh', 'Done', 'Suresh', '', '', '', '03', '03', '2020', '16:26:25'), (62, '921205929', 'Lenox 1', '13', 'bathroom light need to be changed ', 'Denish ', 'Dinesh', 'Done', 'Dinesh', '', '', '', '04', '03', '2020', '09:19:35'), (63, '921205929', 'Brown Tower', '184', 'crack floor ', 'Hani ', 'Madan', 'Working', '', '', '', '', '04', '03', '2020', '09:27:09'), (64, '921205929', 'Real Suites A', '42', 'new vacated need repair they need the below order paint ', 's.jehad ', 'Jose', 'Done', 'Jose/Sebin', '', '', '', '04', '03', '2020', '09:53:37'), (65, '921205929', 'Panorama Center', '41', 'Cooker not working ', 'suresh ', 'Ram call tenant ap sat', 'Working', '', '', '', '', '05', '03', '2020', '09:35:08'), (66, '921205929', 'Real Suites B', '83 ', 'The key for the wash machine not working ', 's.jehad ', 'Ram', 'Working', 'Ashok', '', '', '', '05', '03', '2020', '09:35:49'), (67, '921205929', 'Real Suites B', '82 ', 'issue with fridge ', 's.jehad ', 'Ram', 'Working', '', '', '', '', '05', '03', '2020', '09:37:07'), (68, '921205929', 'Saj 2', '32 ', 'the cooker fans not working ', 's.hassan ', 'Waiting Ram report', 'Replaced New', 'Al Salam 405346', '', '', '', '05', '03', '2020', '09:38:19'), (69, '921205929', 'Brown Tower', '43', 'Crack floor in vacated flat ', 'Hany ', 'Madan', 'Working', '', '', '', '', '07', '03', '2020', '12:11:25'), (70, '921205929', 'Panorama Center', '45', 'bathroom water leak ', 'suresh ', 'Suresh', 'Replaced New', 'M khalaf', '', '', '', '07', '03', '2020', '15:47:57'), (71, '921205929', 'Panorama Center', '37', '1 stone from the cooker not working ', 'suresh ', 'Ram', 'Done', 'Ram', '', '', '', '07', '03', '2020', '15:48:32'), (72, '921205929', 'Panorama Center', '45', 'shower pipe broken ', 'Suresh ', 'Order', 'Replaced New', 'M khalaf', '', '', '', '09', '03', '2020', '09:21:54'), (73, '921205929', 'Panorama Center', '6 floor ', 'issue with door closer in the loopy in 6 floor ', 'suresh ', 'Order', 'Replaced New', 'M khalaf', '', '', '', '09', '03', '2020', '15:58:22'), (74, '921205929', 'Real Suites B', 'swimming pool', 'the switched for the bum need to be changed ', 's.hassan ', 'Madan/Jose', 'No Action', 'Jose/checked', '', '', '', '10', '03', '2020', '16:27:58'), (75, '921205929', 'Brown Tower', '54', 'simple leak in the kitchen ', 'Hani ', 'Madan', '', '', '', '', '', '10', '03', '2020', '16:29:10'), (76, '921205929', 'Real Suites A', '64', 'light for living room ', 'S.mohamed ', 'Bibash', 'Done', 'Bibash', '', '', '', '14', '03', '2020', '10:30:12'), (77, '921205929', 'Real Suites A', '44', 'A/C Not working ', 's.mohamed ', 'Ram', 'Done', 'Ram', '', '', '', '14', '03', '2020', '10:31:12'), (78, '921205929', 'Real Suites B', 'loopy ', 'water leak in the toilet for securitywater leak on the toilet for labors on 9 floor', ' S.mohamed ', 'Order/Sayed M', 'Replaced New', 'Jose/Sebin', '', '', '', '14', '03', '2020', '11:07:11'), (79, '921205929', 'Real Suites B', '35', 'table lamp not working ', 's.mohamed ', 'Bibash', 'Done', 'Bibash', '', '', '', '14', '03', '2020', '11:08:19'), (80, '921205929', 'Panorama Center', '27', 'bad smell from the A/C ', 'suresh ', 'Ram', 'Done', 'Ram', '', '', '', '14', '03', '2020', '11:44:35'), (81, '921205929', 'Panorama Center', '42 ', 'sound from the A/C ', 'suresh ', 'Ram', 'Done', 'Ram', '', '', '', '14', '03', '2020', '11:45:52'), (82, '921205929', 'Panorama Center', '22', 'water leak in the kitchen ', 'suresh ', 'Suresh', 'Done', 'Ram', '', '', '', '14', '03', '2020', '11:49:09'), (83, '921205929', 'Panorama Center', '58', 'the shower pipe broken ', 'Suresh ', 'Order', 'Replaced New', 'M khalaf', '', '', '', '15', '03', '2020', '11:09:19'), (84, '921205929', 'Panorama Center', '52', 'A/C not Cold ', 'Suresh ', 'Ram', 'Done', 'Ram', '', '', '', '16', '03', '2020', '09:53:33'), (85, '921205929', 'Real Suites B', '33', 'A/C Not working ', 's.mohamed ', 'Ram', 'Done', 'Ram', '', '', '', '16', '03', '2020', '11:17:05'), (86, '921205929', 'Panorama Center', '65', 'water leak in the kitchen ', 'panorama', 'Suresh', 'Replaced New', 'M khalaf', '', '', '', '16', '03', '2020', '15:47:34'), (87, '921205929', 'Saj 2', '31', 'damage curtain ', 's.hassan ', 'Sayed H/Daud', 'Done', 'Rubi int 144', '', '', '', '17', '03', '2020', '10:38:00'), (88, '921205929', 'Real Suites A', '83', 'issue with the electricity and the receiver. ', 's.hassan ', 'Jose/Sebin', 'Done', 'Sebin/Bibash', '', '', '', '17', '03', '2020', '10:47:16'), (89, '921205929', 'Panorama Center', '41', 'Issue with the bathroom fan', 'Suresh ', 'Suresh', 'Done', 'Suresh', '', '', '', '18', '03', '2020', '10:52:03'), (90, '921205929', 'Patrex Tower', '7 floor ', 'Intercom not working ', 'Yousif', 'Hamad/Amps', '', '', '', '', '', '18', '03', '2020', '10:52:43'), (91, '921205929', 'Saj 2', '21', 'A/C Not cold Customer request to visit him after 03:00 PM ', 's.hassan ', 'Ram', 'Done', 'Ram', '', '', '', '18', '03', '2020', '15:05:10'), (92, '921205929', 'Real Suites A', '92', 'A/C Leak ', 's.mohamed ', 'Ram', '', '', '', '', '', '18', '03', '2020', '16:11:59'), (93, '921205929', 'Brown Tower', '54', 'Leak on the wall in the kitchen ', 'Hany', 'Hani', '', '', '', '', '', '18', '03', '2020', '16:14:35'), (94, '921205929', 'Panorama Center', '26', 'A/C not cooling ', 'suresh', 'Ram', 'Working', '', '', '', '', '22', '03', '2020', '10:56:07'), (95, '900100702', 'Panorama Center', '62', 'customer called complain about A/C not working ', 'Customer', 'Madan/Jamil', 'Replaced New', 'Al Salam gas', '', '', '', '23', '03', '2020', '15:21:19'), (96, '900100702', 'Panorama Center', '25', 'sound from the Air condition ', 'suresh', 'Ram', 'Working', '', '', '', '', '24', '03', '2020', '09:23:30'), (97, '900100702', 'Real Suites A', '92', 'leak on the A/C', 's.mohamed', 'Ram', 'Done', 'Ram', '', '', '', '25', '03', '2020', '08:30:10'), (98, '900100702', 'Panorama Center', '45', 'waterheater leak ', 'suresh ', 'Order', 'Replaced New', 'M khalaf', '', '', '', '25', '03', '2020', '15:19:56'), (99, '900100702', 'Panorama Center', '42', 'w/c set cover broke ', 'suresh ', '', '', '', '', '', '', '26', '03', '2020', '08:59:54'), (100, '900100702', 'Saj 3', '9 floor ', 'floor ceramic broken ', 'Kamrul ', '', '', '', '', '', '', '26', '03', '2020', '09:13:55'), (101, '900100702', 'Panorama Center', '31', 'A/C not cooling ', 'suresh ', '', '', '', '', '', '', '28', '03', '2020', '09:07:15'), (102, '900100702', 'Real Suites B', '31', 'mixer on the kitchen need to be Fixed ', 's.mohamed ', '', '', '', '', '', '', '29', '03', '2020', '09:18:16'), (103, '900100702', 'Lenox 3', 'loopy ', 'handle damage for the stairs door ', 'Fatima', '', 'Working', '', '', '', '', '30', '03', '2020', '09:20:03'); -- -------------------------------------------------------- -- -- Table structure for table `complaint_datingtb` -- CREATE TABLE `complaint_datingtb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `curr_day` varchar(255) NOT NULL, `curr_month` varchar(255) NOT NULL, `curr_year` varchar(255) NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `complaint_datingtb` -- INSERT INTO `complaint_datingtb` (`id`, `my_id`, `curr_day`, `curr_month`, `curr_year`, `curr_time`) VALUES (2, '1', '04', '02', '2020', '12:34:06'), (3, '1', '05', '02', '2020', '15:06:41'), (4, '1', '06', '02', '2020', '08:24:17'), (5, '1', '08', '02', '2020', '10:35:42'), (6, '1', '09', '02', '2020', '11:53:14'), (7, '1', '11', '02', '2020', '11:51:51'), (8, '434343', '12', '02', '2020', '15:08:48'), (9, '434343', '13', '02', '2020', '10:56:01'), (10, '434343', '15', '02', '2020', '09:54:08'), (11, '434343', '17', '02', '2020', '10:06:38'), (12, '434343', '18', '02', '2020', '15:33:15'), (13, '921205929', '20', '02', '2020', '08:36:32'), (14, '921205929', '22', '02', '2020', '08:53:16'), (15, '921205929', '23', '02', '2020', '11:41:10'), (16, '921205929', '24', '02', '2020', '16:25:58'), (17, '921205929', '25', '02', '2020', '10:49:17'), (18, '921205929', '26', '02', '2020', '10:32:22'), (19, '921205929', '27', '02', '2020', '09:03:51'), (20, '921205929', '29', '02', '2020', '09:06:38'), (21, '921205929', '01', '03', '2020', '08:36:06'), (22, '921205929', '02', '03', '2020', '08:50:55'), (23, '921205929', '03', '03', '2020', '16:25:39'), (24, '921205929', '04', '03', '2020', '09:19:35'), (25, '921205929', '05', '03', '2020', '09:35:08'), (26, '921205929', '07', '03', '2020', '12:11:25'), (27, '921205929', '09', '03', '2020', '09:21:54'), (28, '921205929', '10', '03', '2020', '16:27:58'), (29, '921205929', '14', '03', '2020', '10:30:12'), (30, '921205929', '15', '03', '2020', '11:09:19'), (31, '921205929', '16', '03', '2020', '09:53:33'), (32, '921205929', '17', '03', '2020', '10:38:00'), (33, '921205929', '18', '03', '2020', '10:52:03'), (34, '921205929', '22', '03', '2020', '10:56:07'), (35, '900100702', '23', '03', '2020', '15:21:19'), (36, '900100702', '24', '03', '2020', '09:23:29'), (37, '900100702', '25', '03', '2020', '08:30:10'), (38, '900100702', '26', '03', '2020', '08:59:54'), (39, '900100702', '28', '03', '2020', '09:07:15'), (40, '900100702', '29', '03', '2020', '09:18:16'), (41, '900100702', '30', '03', '2020', '09:20:03'); -- -------------------------------------------------------- -- -- Table structure for table `expendituretb` -- CREATE TABLE `expendituretb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `shop_id` varchar(255) NOT NULL, `shop_name` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, `start_date` varchar(255) NOT NULL, `end_date` varchar(255) NOT NULL, `curr_day` varchar(255) NOT NULL, `curr_month` varchar(255) NOT NULL, `curr_year` varchar(255) NOT NULL, `currtime` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `expendituretb` -- INSERT INTO `expendituretb` (`id`, `my_id`, `shop_id`, `shop_name`, `amount`, `start_date`, `end_date`, `curr_day`, `curr_month`, `curr_year`, `currtime`) VALUES (1, '1', '1', 'Salman Fardan', '779.6', '01-09-2019', '15-09-2019', '25', '11', '2019', '15:57:36'), (2, '1', '2', 'Javed Air Conditioners', '535.920', '01-08-2019', '11-09-2019', '25', '11', '2019', '16:08:47'), (3, '1', '3', 'Al Salam Gas', '6290.998', '09-06-2019', '26-09-2019', '25', '11', '2019', '16:43:28'), (4, '1', '1', 'Salman Fardan', '1061.7', '15-09-2019', '30-09-2019', '27', '11', '2019', '16:51:17'), (5, '1', '2', 'Javed Air Conditioners', '565.635', '12-09-2019', '21-10-2019', '27', '11', '2019', '16:53:09'), (6, '1', '1', 'Salman Fardan', '835.150', '30-09-2019', '16-10-2019', '28', '11', '2019', '10:33:36'), (7, '1', '2', 'Javed Air Conditioners', '183.070', '24-10-2019', '19-11-2019', '28', '11', '2019', '10:34:36'), (8, '1', '3', 'Al Salam Gas', '1911.998', '05-10-2019', '31-10-2019', '28', '11', '2019', '10:35:20'), (9, '1', '1', 'Salman Fardan', '680.6', '17-10-2019', '02-11-2019', '28', '11', '2019', '10:36:03'), (10, '1', '1', 'Salman Fardan', '766.8', '02-11-2019', '14-11-2019', '28', '11', '2019', '10:48:25'), (11, '1', '1', 'Salman Fardan', '560.2', '14-11-2019', '01-12-2019', '02', '12', '2019', '16:22:02'), (12, '1', '1', 'Salman Fardan', '527.9', '01-12-2019', '15-12-2019', '19', '12', '2019', '09:53:25'), (13, '1', '3', 'Al Salam Gas', '618', '01-01-2020', '31-01-2020', '15', '03', '2020', '15:32:03'), (14, '1', '2', 'Javed Air Conditioners', '17.85', '01-01-2020', '31-01-2020', '15', '03', '2020', '15:55:59'), (15, '1', '1', 'Salman Fardan', '1209.758', '01-01-2020', '31-01-2020', '15', '03', '2020', '15:56:32'), (16, '1', '3', 'Al Salam Gas', '443', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:11:29'), (17, '1', '2', 'Javed Air Conditioners', '141.225', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:11:48'), (18, '1', '1', 'Salman Fardan', '1644.773', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:12:03'); -- -------------------------------------------------------- -- -- Table structure for table `graph_calendartb` -- CREATE TABLE `graph_calendartb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `status_code` varchar(255) NOT NULL, `shop_name` varchar(255) NOT NULL, `total_amount` varchar(255) NOT NULL, `start_date` varchar(255) NOT NULL, `end_date` varchar(255) NOT NULL, `curr_day` varchar(255) NOT NULL, `curr_month` varchar(255) NOT NULL, `curr_year` varchar(255) NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `graph_calendartb` -- INSERT INTO `graph_calendartb` (`id`, `my_id`, `status_code`, `shop_name`, `total_amount`, `start_date`, `end_date`, `curr_day`, `curr_month`, `curr_year`, `curr_time`) VALUES (1, '1', '530515', 'Salman Fardan', '779.6', '01-09-2019', '15-09-2019', '28', '11', '2019', '16:14:06'), (2, '1', '304065', 'Javed Air Conditioners', '535.920', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:09:26'), (3, '1', '274059', 'Al Salam Gas', '6290.998', '09-06-2019', '26-09-2019', '07', '12', '2019', '15:59:25'), (4, '1', '44624', 'Salman Fardan', '1061.7', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:25:59'), (5, '1', '854028', 'Javed Air Conditioners', '565.635', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:47:24'), (6, '1', '746228', 'Salman Fardan', '835.150', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:11:16'), (7, '1', '879994', 'Javed Air Conditioners', '183.070', '24-10-2019', '19-11-2019', '08', '12', '2019', '11:57:10'), (8, '1', '500320', 'Al Salam Gas', '1911.998', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:46:52'), (9, '1', '765857', 'Salman Fardan', '680.6', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:23:55'), (10, '1', '339022', 'Salman Fardan', '766.8', '02-11-2019', '14-11-2019', '08', '12', '2019', '15:38:28'), (11, '1', '286587', 'Salman Fardan', '560.2', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:53:28'), (12, '1', '247998', 'Salman Fardan', '527.9', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:30:07'), (13, '1', '203508', 'Al Salam Gas', '618', '01-01-2020', '31-01-2020', '15', '03', '2020', '15:34:42'), (14, '1', '955111', 'Javed Air Conditioners', '17.85', '01-01-2020', '31-01-2020', '15', '03', '2020', '15:57:34'), (15, '1', '249899', 'Salman Fardan', '1209.758', '01-01-2020', '31-01-2020', '15', '03', '2020', '15:58:15'), (16, '1', '645295', 'Javed Air Conditioners', '141.225', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:16:03'), (17, '1', '912022', 'Al Salam Gas', '443', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:16:37'), (18, '1', '864790', 'Salman Fardan', '1644.773', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:16:56'); -- -------------------------------------------------------- -- -- Table structure for table `graph_datatb` -- CREATE TABLE `graph_datatb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `status_code` varchar(255) NOT NULL, `property_name` varchar(255) NOT NULL, `property_ower` varchar(255) NOT NULL, `amount` varchar(255) NOT NULL, `trans_start_date` varchar(255) NOT NULL, `trans_end_date` varchar(255) NOT NULL, `cur_day` varchar(255) NOT NULL, `cur_month` varchar(255) NOT NULL, `cur_year` varchar(255) NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `graph_datatb` -- INSERT INTO `graph_datatb` (`id`, `my_id`, `status_code`, `property_name`, `property_ower`, `amount`, `trans_start_date`, `trans_end_date`, `cur_day`, `cur_month`, `cur_year`, `cur_time`) VALUES (1, '1', '530515', 'Adel House', 'ADEL', '23.3', '01-09-2019', '15-09-2019', '28', '11', '2019', '16:14:06'), (2, '1', '530515', 'Brown Tower', 'ADEL AND SALAH', '15.8', '01-09-2019', '15-09-2019', '28', '11', '2019', '16:23:55'), (3, '1', '530515', 'Lenox 1', 'KHALAF SONS', '50.9', '01-09-2019', '15-09-2019', '28', '11', '2019', '16:26:41'), (4, '1', '530515', 'Lenox 2', 'KHALAF SONS', '45.5', '01-09-2019', '15-09-2019', '28', '11', '2019', '16:27:39'), (5, '1', '530515', 'Lenox 3', 'KHALAF SONS', '29.3', '01-09-2019', '15-09-2019', '28', '11', '2019', '16:28:32'), (6, '1', '530515', 'Capital Medical Complex', 'KHALAF SONS', '26.8', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:26:30'), (7, '1', '530515', 'Indonesian Embassy', 'KHALAF SONS', '6.5', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:27:10'), (8, '1', '530515', 'Panorama Center', 'KHALAF SONS', '47.9', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:27:32'), (9, '1', '530515', 'Patrex Tower', 'KHALAF SONS', '84.3', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:27:50'), (10, '1', '530515', 'Real Suites A', 'ADEL AND SALAH', '32.650', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:28:16'), (11, '1', '530515', 'Real Suites B', 'ADEL AND SALAH', '88.050', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:28:30'), (12, '1', '530515', 'Saj 1', 'KHALAF SONS', '13', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:28:45'), (13, '1', '530515', 'Saj 2', 'KHALAF SONS', '9', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:28:57'), (14, '1', '530515', 'Saj 3', 'KHALAF SONS', '27.9', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:29:11'), (15, '1', '530515', 'Salah House', 'SALAH', '79.8', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:41:10'), (16, '1', '530515', 'Salmaniya Plaza', 'ADEL AND SALAH', '168.4', '01-09-2019', '15-09-2019', '02', '12', '2019', '12:41:25'), (17, '1', '530515', 'Tubli Center', 'ADEL', '13', '01-09-2019', '15-09-2019', '03', '12', '2019', '12:46:04'), (18, '1', '530515', 'Vintage', 'SALAH', '15', '01-09-2019', '15-09-2019', '03', '12', '2019', '12:46:33'), (19, '1', '304065', 'Adel House', 'ADEL', '7.875', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:09:26'), (20, '1', '304065', 'Lenox 1', 'KHALAF SONS', '6.3', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:14:45'), (21, '1', '304065', 'Lenox 2', 'KHALAF SONS', '51.450', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:15:00'), (22, '1', '304065', 'Lenox 3', 'KHALAF SONS', '2.1', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:19:11'), (23, '1', '304065', 'Panorama Center', 'KHALAF SONS', '3.78', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:19:26'), (24, '1', '304065', 'Patrex Tower', 'KHALAF SONS', '133.77', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:19:39'), (25, '1', '304065', 'Real Suites A', 'ADEL AND SALAH', '67.725', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:19:56'), (26, '1', '304065', 'Real Suites B', 'ADEL AND SALAH', '105.525', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:20:07'), (27, '1', '304065', 'Saj 1', 'KHALAF SONS', '4.620', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:20:23'), (28, '1', '304065', 'Saj 2', 'KHALAF SONS', '38.325', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:20:37'), (29, '1', '304065', 'Salmaniya Plaza', 'ADEL AND SALAH', '114.45', '01-08-2019', '11-09-2019', '07', '12', '2019', '15:20:55'), (30, '1', '274059', 'Adel House', 'ADEL', '129.999', '09-06-2019', '26-09-2019', '07', '12', '2019', '15:59:25'), (31, '1', '274059', 'Brown Tower', 'ADEL AND SALAH', '100', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:00:42'), (32, '1', '274059', 'Lenox 1', 'KHALAF SONS', '572', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:00:57'), (33, '1', '274059', 'Lenox 2', 'KHALAF SONS', '425', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:01:07'), (34, '1', '274059', 'Lenox 3', 'KHALAF SONS', '250', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:01:17'), (35, '1', '274059', 'Panorama Center', 'KHALAF SONS', '1640', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:01:32'), (36, '1', '274059', 'Patrex Tower', 'KHALAF SONS', '496', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:01:45'), (37, '1', '274059', 'Real Suites A', 'ADEL AND SALAH', '661', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:01:59'), (38, '1', '274059', 'Real Suites B', 'ADEL AND SALAH', '680', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:02:08'), (39, '1', '274059', 'Saj 1', 'KHALAF SONS', '214', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:02:20'), (40, '1', '274059', 'Saj 2', 'KHALAF SONS', '365', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:02:32'), (41, '1', '274059', 'Salmaniya Plaza', 'ADEL AND SALAH', '493', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:02:46'), (42, '1', '274059', 'Vintage', 'SALAH', '264.999', '09-06-2019', '26-09-2019', '07', '12', '2019', '16:03:03'), (43, '1', '44624', '5Villa', 'ADEL', '37.4', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:25:59'), (44, '1', '44624', 'Adel House', 'ADEL', '15', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:26:34'), (45, '1', '44624', 'Brown Tower', 'ADEL AND SALAH', '50.2', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:26:52'), (46, '1', '44624', 'Capital Medical Complex', 'KHALAF SONS', '28', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:27:03'), (47, '1', '44624', 'Indonesian Embassy', 'KHALAF SONS', '0.8', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:27:21'), (48, '1', '44624', 'Korean Embassy', 'KHALAF SONS', '4', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:27:32'), (49, '1', '44624', 'Lenox 1', 'KHALAF SONS', '50.3', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:27:43'), (50, '1', '44624', 'Lenox 2', 'KHALAF SONS', '24', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:27:51'), (51, '1', '44624', 'Lenox 3', 'KHALAF SONS', '16.4', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:28:05'), (52, '1', '44624', 'Panorama Center', 'KHALAF SONS', '67.2', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:28:17'), (53, '1', '44624', 'Patrex Tower', 'KHALAF SONS', '146.7', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:28:32'), (54, '1', '44624', 'Real Suites A', 'ADEL AND SALAH', '84.2', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:28:47'), (55, '1', '44624', 'Real Suites B', 'ADEL AND SALAH', '152', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:28:54'), (56, '1', '44624', 'Saj 1', 'KHALAF SONS', '83.7', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:29:11'), (57, '1', '44624', 'Saj 2', 'KHALAF SONS', '93.2', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:29:25'), (58, '1', '44624', 'Saj 3', 'KHALAF SONS', '8.5', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:29:35'), (59, '1', '44624', 'Salmaniya Plaza', 'ADEL AND SALAH', '157.6', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:29:48'), (60, '1', '44624', 'Tubli Center', 'ADEL', '40', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:30:14'), (61, '1', '44624', 'Vintage', 'SALAH', '2.5', '15-09-2019', '30-09-2019', '07', '12', '2019', '16:30:28'), (62, '1', '854028', 'Lenox 1', 'Select Holder', '31.5', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:47:24'), (63, '1', '854028', 'Lenox 2', 'KHALAF SONS', '14.7', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:48:43'), (64, '1', '854028', 'Lenox 3', 'KHALAF SONS', '8.4', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:48:57'), (65, '1', '854028', 'Panorama Center', 'KHALAF SONS', '41.475', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:49:22'), (66, '1', '854028', 'Patrex Tower', 'KHALAF SONS', '120.435', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:49:38'), (67, '1', '854028', 'Real Suites A', 'ADEL AND SALAH', '42.525', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:49:55'), (68, '1', '854028', 'Real Suites B', 'ADEL AND SALAH', '63', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:50:02'), (69, '1', '854028', 'Saj 1', 'KHALAF SONS', '67.2', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:50:43'), (70, '1', '854028', 'Saj 2', 'KHALAF SONS', '45.15', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:50:55'), (71, '1', '854028', 'Salmaniya Plaza', 'ADEL AND SALAH', '131.25', '12-09-2019', '21-10-2019', '07', '12', '2019', '16:51:16'), (72, '1', '746228', '5Villa', 'ADEL', '24', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:11:16'), (73, '1', '746228', 'Adliya Tower', 'KHALAF SONS', '15', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:12:25'), (74, '1', '746228', 'Brown Tower', 'ADEL AND SALAH', '25.1', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:12:50'), (75, '1', '746228', 'Indonesian Embassy', 'KHALAF SONS', '27.6', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:14:06'), (76, '1', '746228', 'Korean Embassy', 'KHALAF SONS', '35.6', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:14:30'), (77, '1', '746228', 'Lenox 1', 'KHALAF SONS', '7.1', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:14:43'), (78, '1', '746228', 'Lenox 2', 'KHALAF SONS', '3', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:14:51'), (79, '1', '746228', 'Lenox 3', 'KHALAF SONS', '31.8', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:15:03'), (80, '1', '746228', 'Panorama Center', 'KHALAF SONS', '78.6', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:15:16'), (81, '1', '746228', 'Patrex Tower', 'KHALAF SONS', '81.8', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:15:38'), (82, '1', '746228', 'Real Suites A', 'ADEL AND SALAH', '65.85', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:15:58'), (83, '1', '746228', 'Real Suites B', 'ADEL AND SALAH', '308.2', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:16:10'), (84, '1', '746228', 'Saj 1', 'KHALAF SONS', '61.8', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:16:27'), (85, '1', '746228', 'Saj 2', 'KHALAF SONS', '15.8', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:16:39'), (86, '1', '746228', 'Saj 3', 'KHALAF SONS', '13', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:16:50'), (87, '1', '746228', 'Salmaniya Plaza', 'ADEL AND SALAH', '9', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:17:03'), (88, '1', '746228', 'Tubli Center', 'ADEL', '19.4', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:17:24'), (89, '1', '746228', 'Vintage', 'SALAH', '12.5', '30-09-2019', '16-10-2019', '08', '12', '2019', '11:17:43'), (90, '1', '879994', 'Adel House', 'ADEL', '18.05', '24-10-2019', '19-11-2019', '08', '12', '2019', '11:57:11'), (91, '1', '879994', 'Capital Medical Complex', 'KHALAF SONS', '40.95', '24-10-2019', '19-11-2019', '08', '12', '2019', '11:58:46'), (92, '1', '879994', 'Korean Embassy', 'KHALAF SONS', '2.3', '24-10-2019', '19-11-2019', '08', '12', '2019', '11:59:21'), (93, '1', '879994', 'Lenox 2', 'KHALAF SONS', '15.12', '24-10-2019', '19-11-2019', '08', '12', '2019', '11:59:35'), (94, '1', '879994', 'Patrex Tower', 'KHALAF SONS', '43.575', '24-10-2019', '19-11-2019', '08', '12', '2019', '11:59:51'), (95, '1', '879994', 'Real Suites A', 'ADEL AND SALAH', '2.625', '24-10-2019', '19-11-2019', '08', '12', '2019', '12:00:06'), (96, '1', '879994', 'Real Suites B', 'ADEL AND SALAH', '9', '24-10-2019', '19-11-2019', '08', '12', '2019', '12:00:28'), (97, '1', '879994', 'Salmaniya Plaza', 'ADEL AND SALAH', '51.45', '24-10-2019', '19-11-2019', '08', '12', '2019', '12:00:52'), (98, '1', '500320', 'Brown Tower', 'ADEL AND SALAH', '560', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:46:52'), (99, '1', '500320', 'Manama Office', 'KHALAF SONS', '32', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:48:12'), (100, '1', '500320', 'Panorama Center', 'KHALAF SONS', '154', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:48:28'), (101, '1', '500320', 'Patrex Tower', 'KHALAF SONS', '283.999', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:48:43'), (102, '1', '500320', 'Real Suites B', 'ADEL AND SALAH', '667', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:49:06'), (103, '1', '500320', 'Salmaniya Plaza', 'ADEL AND SALAH', '79.999', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:49:23'), (104, '1', '500320', 'Vintage', 'SALAH', '135', '05-10-2019', '31-10-2019', '08', '12', '2019', '12:49:36'), (105, '1', '765857', 'Adel House', 'ADEL', '6.3', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:23:55'), (106, '1', '765857', 'Adliya Tower', 'KHALAF SONS', '3.5', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:24:49'), (107, '1', '765857', 'Brown Tower', 'ADEL AND SALAH', '24.7', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:25:06'), (108, '1', '765857', 'Capital Medical Complex', 'KHALAF SONS', '15.5', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:25:25'), (109, '1', '765857', 'Indonesian Embassy', 'KHALAF SONS', '214.1', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:25:40'), (110, '1', '765857', 'Lenox 1', 'KHALAF SONS', '12', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:25:50'), (111, '1', '765857', 'Lenox 2', 'KHALAF SONS', '16.8', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:26:03'), (112, '1', '765857', 'Panorama Center', 'KHALAF SONS', '25.4', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:26:15'), (113, '1', '765857', 'Patrex Tower', 'KHALAF SONS', '129.8', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:26:29'), (114, '1', '765857', 'Real Suites A', 'ADEL AND SALAH', '33', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:26:42'), (115, '1', '765857', 'Real Suites B', 'ADEL AND SALAH', '11.5', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:26:52'), (116, '1', '765857', 'Saj 1', 'KHALAF SONS', '42.6', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:27:05'), (117, '1', '765857', 'Saj 2', 'KHALAF SONS', '61.4', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:27:20'), (118, '1', '765857', 'Saj 3', 'KHALAF SONS', '64.6', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:27:35'), (119, '1', '765857', 'Salmaniya Plaza', 'ADEL AND SALAH', '19.4', '17-10-2019', '02-11-2019', '08', '12', '2019', '15:27:53'), (120, '1', '339022', '5Villa', 'ADEL', '7', '02-11-2019', '14-11-2019', '08', '12', '2019', '15:38:28'), (121, '1', '339022', 'Adliya Tower', 'KHALAF SONS', '84.7', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:39:07'), (122, '1', '339022', 'Brown Tower', 'ADEL AND SALAH', '15.5', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:39:28'), (123, '1', '339022', 'Capital Medical Complex', 'KHALAF SONS', '9', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:39:39'), (124, '1', '339022', 'Indonesian Embassy', 'KHALAF SONS', '129.1', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:39:56'), (125, '1', '339022', 'Korean Embassy', 'KHALAF SONS', '50.5', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:40:13'), (126, '1', '339022', 'Lenox 1', 'KHALAF SONS', '37', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:40:27'), (127, '1', '339022', 'Lenox 2', 'KHALAF SONS', '39.9', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:40:35'), (128, '1', '339022', 'Lenox 3', 'KHALAF SONS', '2', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:40:43'), (129, '1', '339022', 'Panorama Center', 'KHALAF SONS', '33', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:40:52'), (130, '1', '339022', 'Patrex Tower', 'KHALAF SONS', '80.5', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:41:03'), (131, '1', '339022', 'Real Suites A', 'ADEL AND SALAH', '70.4', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:41:21'), (132, '1', '339022', 'Real Suites B', 'ADEL AND SALAH', '67.3', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:41:37'), (133, '1', '339022', 'Saj 1', 'KHALAF SONS', '16.6', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:41:53'), (134, '1', '339022', 'Saj 2', 'KHALAF SONS', '63', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:42:02'), (135, '1', '339022', 'Salmaniya Plaza', 'ADEL AND SALAH', '26.8', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:42:18'), (136, '1', '339022', 'Tubli Center', 'ADEL', '12', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:42:32'), (137, '1', '339022', 'Vintage', 'SALAH', '22.5', '02-11-2019', '11-11-2019', '08', '12', '2019', '15:42:52'), (138, '1', '286587', '5Villa', 'ADEL', '17', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:53:28'), (139, '1', '286587', 'Adel House', 'ADEL', '34.7', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:54:21'), (140, '1', '286587', 'Brown Tower', 'ADEL AND SALAH', '113.1', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:54:40'), (141, '1', '286587', 'Indonesian Embassy', 'KHALAF SONS', '107.6', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:54:59'), (142, '1', '286587', 'Korean Embassy', 'KHALAF SONS', '3.8', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:55:12'), (143, '1', '286587', 'Lenox 1', 'KHALAF SONS', '8', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:55:23'), (144, '1', '286587', 'Lenox 2', 'KHALAF SONS', '24.5', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:55:30'), (145, '1', '286587', 'Lenox 3', 'KHALAF SONS', '17', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:55:40'), (146, '1', '286587', 'Panorama Center', 'KHALAF SONS', '21', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:55:51'), (147, '1', '286587', 'Patrex Tower', 'KHALAF SONS', '42.3', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:56:02'), (148, '1', '286587', 'Real Suites A', 'ADEL AND SALAH', '20.2', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:56:22'), (149, '1', '286587', 'Real Suites B', 'ADEL AND SALAH', '16.7', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:56:33'), (150, '1', '286587', 'Saj 1', 'KHALAF SONS', '19', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:56:52'), (151, '1', '286587', 'Saj 2', 'KHALAF SONS', '5.8', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:57:07'), (152, '1', '286587', 'Saj 3', 'KHALAF SONS', '16', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:57:17'), (153, '1', '286587', 'Salmaniya Plaza', 'ADEL AND SALAH', '27.5', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:57:30'), (154, '1', '286587', 'Vintage', 'SALAH', '66', '14-11-2019', '01-12-2019', '08', '12', '2019', '15:57:43'), (155, '1', '247998', '5Villa', 'ADEL', '6.8', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:30:07'), (156, '1', '247998', 'Adel House', 'ADEL', '98.4', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:41:35'), (157, '1', '247998', 'Brown Tower', 'ADEL AND SALAH', '44', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:42:06'), (158, '1', '247998', 'Capital Medical Complex', 'KHALAF SONS', '3.4', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:43:39'), (159, '1', '247998', 'Indonesian Embassy', 'KHALAF SONS', '12.3', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:44:19'), (160, '1', '247998', 'Korean Embassy', 'KHALAF SONS', '2', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:44:41'), (161, '1', '247998', 'Lenox 1', 'KHALAF SONS', '48.1', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:45:06'), (162, '1', '247998', 'Lenox 2', 'KHALAF SONS', '28.5', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:45:36'), (163, '1', '247998', 'Lenox 3', 'KHALAF SONS', '86.3', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:46:07'), (164, '1', '247998', 'Panorama Center', 'KHALAF SONS', '26.7', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:47:01'), (165, '1', '247998', 'Real Suites A', 'KHALAF SONS', '21.5', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:48:13'), (166, '1', '247998', 'Saj 3', 'KHALAF SONS', '3.5', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:50:13'), (167, '1', '247998', 'Korean Embassy', 'SALAH', '42.6', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:51:38'), (168, '1', '247998', 'Salmaniya Plaza', 'ADEL AND SALAH', '3.6', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:52:20'), (169, '1', '247998', 'Vintage', 'SALAH', '4.5', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:53:07'), (170, '1', '247998', 'Patrex Tower', 'KHALAF SONS', '84.2', '01-12-2019', '15-12-2019', '24', '12', '2019', '10:59:00'), (171, '1', '247998', 'Saj 2', 'KHALAF SONS', '11.5', '01-12-2019', '15-12-2019', '24', '12', '2019', '11:00:36'), (172, '1', '203508', 'Lenox 2', 'KHALAF SONS', '112.381', '01-01-2020', '31-01-2020', '15', '03', '2020', '15:34:42'), (173, '1', '203508', 'Lenox 3', 'KHALAF SONS', '104.762', '01-01-2020', '31-01-2020', '15', '03', '2020', '15:49:16'), (174, '1', '203508', 'Real Suites A', 'ADEL AND SALAH', '119.048', '01-01-2020', '31-01-2020', '15', '03', '2020', '15:49:39'), (175, '1', '203508', 'Saj 2', 'KHALAF SONS', '109.524', '01-01-2020', '31-01-2020', '15', '03', '2020', '15:50:00'), (176, '1', '203508', 'Salmaniya Plaza', 'ADEL AND SALAH', '142.857', '01-01-2020', '31-01-2020', '15', '03', '2020', '15:50:23'), (177, '1', '955111', 'Patrex Tower', 'KHALAF SONS', '4.5', '01-01-2020', '31-01-2020', '15', '03', '2020', '15:57:34'), (178, '1', '249899', '5Villa', 'ADEL', '9.8', '01-01-2020', '31-01-2020', '15', '03', '2020', '15:58:15'), (179, '1', '955111', 'Real Suites A', 'ADEL AND SALAH', '11.5', '01-01-2020', '31-01-2020', '15', '03', '2020', '15:59:12'), (180, '1', '955111', 'Salmaniya Plaza', 'ADEL AND SALAH', '1', '01-01-2020', '31-01-2020', '15', '03', '2020', '15:59:25'), (181, '1', '249899', 'Adel House', 'ADEL', '90.7', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:01:32'), (182, '1', '249899', 'Brown Tower', 'ADEL AND SALAH', '151.5', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:01:52'), (183, '1', '249899', 'Capital Medical Complex', 'KHALAF SONS', '37.2', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:02:11'), (184, '1', '249899', 'Indonesian Embassy', 'KHALAF SONS', '3.6', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:02:28'), (185, '1', '249899', 'Korean Embassy', 'KHALAF SONS', '5.1', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:02:40'), (186, '1', '249899', 'Lenox 1', 'KHALAF SONS', '18.3', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:02:54'), (187, '1', '249899', 'Lenox 2', 'KHALAF SONS', '13.4', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:03:06'), (188, '1', '249899', 'Lenox 3', 'KHALAF SONS', '29', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:03:19'), (189, '1', '249899', 'Manama Office', 'KHALAF SONS', '3.2', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:03:42'), (190, '1', '249899', 'Panorama Center', 'KHALAF SONS', '59.3', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:03:58'), (191, '1', '249899', 'Patrex Tower', 'KHALAF SONS', '280.1', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:04:17'), (192, '1', '249899', 'Real Suites A', 'ADEL AND SALAH', '52.5', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:04:31'), (193, '1', '249899', 'Real Suites B', 'ADEL AND SALAH', '73.8', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:04:43'), (194, '1', '249899', 'Saj 1', 'KHALAF SONS', '48.3', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:05:16'), (195, '1', '249899', 'Saj 2', 'KHALAF SONS', '165.15', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:05:39'), (196, '1', '249899', 'Saj 3', 'KHALAF SONS', '14.5', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:05:52'), (197, '1', '249899', 'Salmaniya Plaza', 'ADEL AND SALAH', '26.3', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:06:32'), (198, '1', '249899', 'Tubli Center', 'ADEL', '6', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:06:49'), (199, '1', '249899', 'Vintage', 'SALAH', '64.4', '01-01-2020', '31-01-2020', '15', '03', '2020', '16:07:05'), (200, '1', '645295', 'Real Suites A', 'ADEL AND SALAH', '59.5', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:16:03'), (201, '1', '912022', 'Lenox 2', 'KHALAF SONS', '109.524', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:16:37'), (202, '1', '864790', '5Villa', 'ADEL', '15.5', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:16:56'), (203, '1', '645295', 'Real Suites B', 'ADEL AND SALAH', '56', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:17:47'), (204, '1', '645295', 'Saj 2', 'KHALAF SONS', '19', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:18:23'), (205, '1', '912022', 'Panorama Center', 'KHALAF SONS', '190.476', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:19:20'), (206, '1', '912022', 'Saj 2', 'KHALAF SONS', '121.905', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:19:37'), (207, '1', '864790', 'Adel House', 'ADEL', '34.7', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:20:38'), (208, '1', '864790', 'Adliya Tower', 'KHALAF SONS', '12', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:20:51'), (209, '1', '864790', 'Brown Tower', 'ADEL AND SALAH', '58.7', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:21:05'), (210, '1', '864790', 'Capital Medical Complex', 'KHALAF SONS', '30.6', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:21:18'), (211, '1', '864790', 'Indonesian Embassy', 'KHALAF SONS', '147.5', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:21:31'), (212, '1', '864790', 'Lenox 1', 'KHALAF SONS', '20.7', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:21:43'), (213, '1', '864790', 'Lenox 2', 'KHALAF SONS', '103', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:21:54'), (214, '1', '864790', 'Lenox 3', 'KHALAF SONS', '53.9', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:22:17'), (215, '1', '864790', 'Manama Office', 'KHALAF SONS', '3.3', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:22:33'), (216, '1', '864790', 'Panorama Center', 'KHALAF SONS', '101.3', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:22:43'), (217, '1', '864790', 'Patrex Tower', 'KHALAF SONS', '219.9', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:22:57'), (218, '1', '864790', 'Real Suites A', 'ADEL AND SALAH', '169.1', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:23:54'), (219, '1', '864790', 'Real Suites B', 'ADEL AND SALAH', '34.75', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:24:23'), (220, '1', '864790', 'Saj 1', 'KHALAF SONS', '24.3', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:24:47'), (221, '1', '864790', 'Saj 2', 'KHALAF SONS', '296.1', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:25:02'), (222, '1', '864790', 'Saj 3', 'KHALAF SONS', '4', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:25:46'), (223, '1', '864790', 'Panorama Center', 'KHALAF SONS', '34.9', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:26:08'), (224, '1', '864790', 'Vintage', 'KHALAF SONS', '202.2', '01-02-2020', '29-02-2020', '15', '03', '2020', '16:26:24'); -- -------------------------------------------------------- -- -- Table structure for table `jobstb` -- CREATE TABLE `jobstb` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `job_title` text NOT NULL, `job_description` text NOT NULL, `job_location` varchar(255) NOT NULL, `user_ip` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `jobstb` -- INSERT INTO `jobstb` (`id`, `user_id`, `job_title`, `job_description`, `job_location`, `user_ip`, `country`, `city`, `curr_date`, `curr_time`) VALUES (1, 1, 'SECRETARY', 'Now hiring! \r\nKhalaf Sons Real estate company are looking for a secretary for immediate joining.\r\nCandidate must have the following conditions in order to cover the job responsibilities and duties requirements:\r\n- Fluent in English and Arabic /speaking / reading / writing. \r\n- Being able to multitask. \r\n- Quick forecast.\r\n- Two years as a minimum year of experience. \r\n- Office management experienced and skills.\r\nPlease send your updated cv and attached the following:\r\n - Passport copy.\r\n - CPR copy.\r\n\r\n', 'Bu Ashira', '', '', '', '2020-03-08', '12:21:19'), (2, 1, 'DRIVER', 'Now hiring! \r\nKhalaf Sons Real estate company are looking for Driver for immediate joining.\r\nPlease send your updated cv and attached the following:\r\n - Passport copy.\r\n - CPR copy.\r\n - Attach your professional certificates.\r\nKindly attach the documents.\r\nCandidates with missing documents will be rejected.\r\nwww.khalafsons.com', 'Bu Ashira', '', '', '', '2020-03-08', '12:32:52'); -- -------------------------------------------------------- -- -- Table structure for table `khalaf_admintb` -- CREATE TABLE `khalaf_admintb` ( `id` int(11) NOT NULL, `user_id_adm` varchar(255) NOT NULL, `user_cpr` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `khalaf_admintb` -- INSERT INTO `khalaf_admintb` (`id`, `user_id_adm`, `user_cpr`, `country`, `city`, `curr_date`, `curr_time`) VALUES (1, '1', '434343', '', '', '2019-02-25', '10:31:48'); -- -------------------------------------------------------- -- -- Table structure for table `khalaf_agenttb` -- CREATE TABLE `khalaf_agenttb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `cpr_no` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `khalaf_agenttb` -- INSERT INTO `khalaf_agenttb` (`id`, `user_id`, `cpr_no`, `country`, `city`, `curr_date`, `curr_time`) VALUES (1, '921205929', '921205929', 'Bahrain', 'Manama', '2020-02-13', '16:40:38'); -- -------------------------------------------------------- -- -- Table structure for table `khalaf_cvtb` -- CREATE TABLE `khalaf_cvtb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `cv_title` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `contact` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `cv_cover` text NOT NULL, `file_url` text NOT NULL, `user_ip` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `khalaf_cvtb` -- INSERT INTO `khalaf_cvtb` (`id`, `user_id`, `cv_title`, `name`, `contact`, `email`, `cv_cover`, `file_url`, `user_ip`, `country`, `city`, `curr_date`, `curr_time`) VALUES (2, '6', 'SECRETARY', 'Asmaa Karani', '+97333180612', 'asmaamk21@gmail.com', ' ', '1428988652.pdf', '95.84.110.2', 'Bahrain', '', '2020-03-09', '12:31:25'), (3, '7', 'DRIVER', 'Daniel Ofori', '35187802', 'danieloforidarko63@gmail.com', 'Dear Sir/Madam,\r\n\r\n APPLICATION FOR EMPLOYMENT AS A DRIVER\r\n\r\nI wish apply for employment as a driver in your reputable company.\r\n\r\nI have seven year experience as a driver in Ghana and experience in Bahrain also as a driver, I have worked with Nexcel Computer Solutions as a delivery driver and i know most of the route in Bahrain.\r\n\r\nPlease am employed i will work hard to ensure that the company will achieve it goals and objectives.\r\n\r\nI hope to hear from you soon. Thank you.\r\n\r\nYours Faithfully,\r\nDaniel Ofori\r\nTel:35187802 \r\n', '1000957109.pdf', '94.76.0.51', 'Bahrain', 'Al Muharraq', '2020-03-09', '12:55:05'), (4, '', 'DRIVER', 'Sulaiman Safwan', '32054496', 'safwanpvk@gmail.com', ' ', '1888713316.pdf', '84.255.170.15', 'Bahrain', 'Tubli', '2020-03-09', '13:07:23'), (5, '', 'DRIVER', 'Sulaiman Safwan', '32054496', 'safwanpvk@gmail.com', ' ', '405655661.pdf', '84.255.170.15', 'Bahrain', 'Tubli', '2020-03-09', '13:08:01'), (6, '', 'DRIVER', 'FAIZAL', '33866965', 'faizalce@gmail.com', ' Interested as Engineer cum driving with valid driving licence. ', '2005271676.pdf', '89.148.48.104', 'Bahrain', 'Manama', '2020-03-09', '13:12:38'), (7, '', 'DRIVER', 'Muhammad Nizar', '37131525', 'Pulikkal.nizar@gmail.com', ' ', '1817534966.docx', '37.131.50.50', 'Bahrain', '', '2020-03-09', '13:14:27'), (8, '', 'SECRETARY', 'Khushboo Vagadiya', '33265405', 'vagadiyakhushboo@gmail.com', ' ', '530091379.pdf', '95.84.124.95', 'Bahrain', '', '2020-03-09', '13:25:16'), (9, '', 'SECRETARY', 'Khushboo Vagadiya', '33265405', 'vagadiyakhushboo@gmail.com', ' ', '780080159.pdf', '95.84.124.95', 'Bahrain', '', '2020-03-09', '13:26:28'), (10, '', 'SECRETARY', 'Rahul sing', '38295246', 'rs77069@gmail.com', ' ', '842975869.pdf', '88.201.58.69', 'Bahrain', 'Manama', '2020-03-09', '13:27:37'), (11, '', 'DRIVER', 'ajay kumar', '33122803', 'wayajay1@gmail.com', ' ', '912102465.docx', '37.131.125.30', 'Bahrain', '', '2020-03-09', '13:27:46'), (12, '', 'DRIVER', 'ajay kumar', '33122803', 'wayajay1@gmail.com', ' ', '1273756462.docx', '37.131.125.30', 'Bahrain', '', '2020-03-09', '13:27:47'), (13, '', 'SECRETARY', 'Amjid farooq', '33807758', 'amjad.farooq79@gmail.com', ' ', '309286983.docx', '109.161.170.243', 'Bahrain', 'Bani Jamrah', '2020-03-09', '13:38:55'), (14, '', 'SECRETARY', 'FAZAL E REHMAN', '33417745', 'Fazale.bh@gmail.com', ' Dear Mr. / Ms. Hiring Manager:\r\nI am interesting in applying for the role of Secretary in your organization; I submit my Curriculum vitae for your review.', '1794414167.pdf', '95.84.104.135', 'Bahrain', '', '2020-03-09', '13:57:19'), (15, '', 'SECRETARY', 'Amjad Farooq', '33807758', 'amjad.farooq79@gmail.com', ' ', '1260056330.pdf', '109.161.170.243', 'Bahrain', 'Bani Jamrah', '2020-03-09', '13:57:33'), (16, '', 'SECRETARY', 'FAZAL E REHMAN', '33417745', 'Fazale.bh@gmail.com', ' Dear Mr. / Ms. Hiring Manager:\r\nI am interesting in applying for the role of Secretary in your organization; I submit my Curriculum vitae for your review.', '429770195.pdf', '95.84.104.135', 'Bahrain', '', '2020-03-09', '13:58:26'), (17, '', 'SECRETARY', 'anjum iqbal', '36042301', 'anjumiqbal815@gmail.com', ' cv', '102038911.pdf', '109.161.168.92', 'Bahrain', 'Madinat Hamad', '2020-03-09', '14:08:04'), (18, '', 'DRIVER', 'JOHN AJU JOHN ', '39849942', 'johnaju458@gmail.com', ' APPLIED FOR DRIVER POST ', '321564686.pdf', '84.255.142.82', 'Bahrain', '', '2020-03-09', '14:10:33'), (19, '', '', 'Anish Antony', '+97335465448', 'aneeshantony789@gmail.com', ' ', '633047520.docx', '37.125.194.40', 'Saudi Arabia', 'Dammam', '2020-03-09', '14:12:20'), (20, '', '', 'Anish Antony', '+97335465448', 'aneeshantony789@gmail.com', ' ', '22533909.docx', '37.125.194.40', 'Saudi Arabia', 'Dammam', '2020-03-09', '14:13:00'), (21, '', 'SECRETARY', 'Abdul Qadeer Aziz ', '34010136', 'abdulqadeeraziz.786@gmail.com', ' ', '1194037742.pdf', '37.131.102.217', 'Bahrain', '', '2020-03-09', '14:19:34'), (22, '', 'DRIVER', 'Muhammad Aqib javaid', '39830124 ', 'Aqibkashmire22@gmail.com ', ' Resume for driver job ', '2134602788.pdf', '193.188.122.5', 'Bahrain', 'Manama', '2020-03-09', '14:50:33'), (23, '', 'DRIVER', 'Sukhdev', '00917814960087', 'bangersunny22@gmail.com', ' Hi sir I want driving job I have experience 4 years in Bahrain and also I have vild license Bahrain ', '580771288.docx', '157.39.77.209', 'India', 'Kapurthala Town', '2020-03-09', '14:55:28'), (24, '', '', 'Adnan Ahmad', '33453889', 'aadnan_15@yahoo.com', ' i have exp 7 years for driving ', '1999283854.docx', '109.161.146.164', 'Bahrain', 'Manama', '2020-03-09', '15:05:25'), (25, '', '', 'Adnan Ahmad', '33453889', 'aadnan_15@yahoo.com', ' i have exp 7 years for driving ', '1527016775.docx', '109.161.146.164', 'Bahrain', 'Manama', '2020-03-09', '15:05:43'), (26, '', 'DRIVER', 'Adnan Ahmad', '33453889', 'aadnan_15@yahoo.com', ' ', '1549878617.docx', '109.161.146.164', 'Bahrain', 'Manama', '2020-03-09', '15:06:04'), (27, '', 'DRIVER', 'Maneesh ', '38101086', 'Maneeshponnani@gmail.com', ' ', '1338928154.pdf', '88.201.43.192', 'Bahrain', 'Madinat `Isa', '2020-03-09', '15:26:24'), (28, '', 'DRIVER', 'Subail sabir', '34046288', 'Suhailck168@gmail.com', ' Dear Sir/Madam, Greetings..! I am applying for the above position and please find my CV attached herewith for your kind reference. I thank you in advance for your time and also looking forward to hear from you. Yours sincerely,', '162169473.pdf', '109.161.135.123', 'Bahrain', 'Manama', '2020-03-09', '15:28:39'), (29, '', 'DRIVER', 'SHohidul islam', '0097336257351', 'Shoponh3@gmail.com', ' ', '1293299357.pdf', '62.209.14.204', 'Bahrain', 'Manama', '2020-03-09', '15:38:57'), (30, '', 'DRIVER', 'Imran Ashraf ', '33552757', 'Imranashraf12344321@gmail.com ', ' Driver ', '1275512919.pdf', '37.131.56.56', 'Bahrain', '', '2020-03-09', '15:43:53'), (31, '', 'DRIVER', 'MOHAMED SIKKANDER', '+97337703858', 'rsikkander007@gmail.com', ' This is MOHAMED SIKKANDER I am working before sphinx services messenger driver now I am currently abudhabi I also have BAHRAIN visit visa still I you interested call me anytime I joined thanks', '1482568591.pdf', '31.215.114.211', 'United Arab Emirates', 'Abu Dhabi', '2020-03-09', '16:13:13'), (32, '', 'SECRETARY', 'Florence Reynolds', '33391090', 'florencerey09@hotmail.com', ' ', '1722874067.pdf', '217.17.225.219', 'Bahrain', 'Manama', '2020-03-09', '16:17:15'), (33, '', 'SECRETARY', 'Ashar farook', '38759152', 'Ash2015bh@gmail.com ', ' Attached with cv', '1596049241.pdf', '88.201.6.42', 'Bahrain', 'Madinat Hamad', '2020-03-09', '16:17:16'), (34, '', 'SECRETARY', 'Florence Reynolds', '33391090', 'florencerey09@hotmail.com', ' ', '1617844009.pdf', '217.17.225.219', 'Bahrain', 'Manama', '2020-03-09', '16:19:41'), (35, '', 'DRIVER', 'Anjum', '36042301', 'Anjumiqbal815@gmail.com', ' How can i upload 2 document at a time', '654623904.pdf', '109.161.168.92', 'Bahrain', 'Madinat Hamad', '2020-03-09', '16:20:40'), (36, '', 'DRIVER', 'Mujib Mohammed', '33642845', 'msawratkar@gmail.com', ' Dear Sir/Madam,\r\n\r\nGreetings of the day..!!\r\n\r\nI am writing to apply for a recent job opening advertised on Expatriate.com for the position of ‘Van Driver’. The position and responsibilities seem exciting and matching to my interest areas and career goals. For more information, I have attached my resume for your consideration.\r\n\r\n\r\n\r\nThanks and Regards,\r\n\r\nMujib Mohammed\r\n\r\n+973 33642845', '551922395.pdf', '37.131.30.210', 'Bahrain', '', '2020-03-09', '16:29:08'), (37, '', 'SECRETARY', 'Naib khan', '+97338063471', 'Naibk788@gmail.com', ' For driving I have good experience more than 9 years knows about banking work ', '662809089.pdf', '193.188.99.224', 'Bahrain', 'Manama', '2020-03-09', '16:31:50'), (38, '', '', 'Umer Ejaz', '33554549', 'Buayaan2016@gmail.com', ' Good Evening, have a valid Bahraini Driving License sine 2005. My Cv is attached too.', '452658344.docx', '94.76.13.158', 'Bahrain', 'Manama', '2020-03-09', '16:34:42'), (39, '', 'DRIVER', 'Parthiban kannan', '34459140', 'Varunparhiban9090@gmail.com ', ' ', '1446050919.docx', '193.188.122.211', 'Bahrain', 'Manama', '2020-03-09', '17:36:54'), (40, '', 'SECRETARY', 'DULAL HAWLADER', '37217525', 'saiful33961335@gmail.com', ' ', '495401016.pdf', '109.161.172.230', 'Bahrain', 'Manama', '2020-03-09', '17:38:45'), (41, '', '', 'DULAL HAWLADER', '37217525', 'saiful33961335@gmail.com', ' I am looking for driver job official messenger and real estate company', '1831983946.pdf', '109.161.172.230', 'Bahrain', 'Manama', '2020-03-09', '17:40:32'), (42, '', '', 'DULAL HAWLADER', '37217525', 'saiful33961335@gmail.com', ' I am looking for driver job official messenger and real estate company', '76013736.pdf', '109.161.172.230', 'Bahrain', 'Manama', '2020-03-09', '17:40:41'), (43, '', 'DRIVER', 'M A Hannan', '33367133', 'ssfhannan@gmail.com', ' \r\n\r\n\r\n\r\n\r\n\r\nHANNAN A K M ABDUL GAFUR \r\nEmail: ssfhannan@gmail.com\r\nMobile No: 33367133, 36210425 (Kingdom Of Bahrain) \r\nNationality: Bangladeshi\r\nMarital Status: Married. \r\nJob Objectives:\r\nMy work experiences, My commitment to delivering high levels of Driving service and my drive to succeed make me an excellent candidate with your company.\r\nWith Around Up To Two Years of experience in Company, I have continuously demonstrated my commitment to high levels of my service. At last I Like to work as team. So I can achieve more and more than before. \r\nWorking Experience:\r\n Working As a Driver Juffair Fontana Suites From 8th july 2018 to till…\r\n Working as a Driver with Oasis Plaza, Juffair, Bahrain From 10th June 2017 to 5th July 2018..\r\n Worked as a Security Guard with Mandarine Business Centre, Seef District, Bahrain from 11 May 2010 to till 09th June 2017.\r\n\r\n Worked as a Security Guard with Awal Security Company, Adliya, Bahrain From 01th June 2009 to till 01May 2010.\r\n Worked as a Armed Police Battalion in Bangladesh Police, From 15th February 2002 to till 24th February 2009.\r\nEducation:\r\nBachelors of Social Science.\r\nTechnical Skills:\r\n Microsoft office application \r\nLanguage:\r\nEnglish (Spoken & Written), Arabic (Medium),Urdu, Hindi, Bengali (Mother tongue) . \r\nExtra Qualification:\r\n\r\n Candidate Have Valid Driving License (Car & Bike)\r\n\r\n\r\nDeclaration:\r\nI hereby declare that the information furnish are true to the best of my knowledge and belief.\r\n', '1252547965.docx', '109.161.172.234', 'Bahrain', 'Manama', '2020-03-09', '17:42:13'), (44, '', 'DRIVER', 'DULAL HAWLADER', '37217525', 'saiful33961335@gmail.com', 'I am experienced driver and office messenger and real estate company more than nine years', '1849690541.pdf', '109.161.172.230', 'Bahrain', 'Manama', '2020-03-09', '17:42:36'), (45, '', 'DRIVER', 'DULAL HAWLADER', '37217525', 'saiful33961335@gmail.com', 'I am experienced driver and office messenger and real estate company more than nine years', '2048060642.pdf', '109.161.172.230', 'Bahrain', 'Manama', '2020-03-09', '17:43:58'), (46, '', 'SECRETARY', 'Naib khan', '38063471', 'Naibk788@gmail.com', ' CV for a driver excellent experience more than 9years ', '2010896078.pdf', '193.188.99.224', 'Bahrain', 'Manama', '2020-03-09', '17:56:45'), (47, '', 'SECRETARY', 'Mohammed Malik ', '36646670 ', 'Mohdjps@yahoo.com', ' Dear Sir/Madam,\r\n\r\nI am offering my services for this position in your esteemed Organization. I expect that I will be considered favorably\r\n\r\nRegards,\r\n\r\n\r\n', '2067220908.pdf', '88.201.94.240', 'Bahrain', '', '2020-03-09', '19:28:55'), (48, '', 'DRIVER', 'Mujeeb Noushad Manzil', '38080252', 'mujeebthesrinm@gmail.com', ' ', '171361930.pdf', '89.148.42.188', 'Bahrain', 'Manama', '2020-03-09', '19:42:40'), (49, '', 'SECRETARY', 'Faraz Arif', '3505 1969', 'farazarif95@gmail.com', ' Dear HR & Admin,\r\n\r\nFollowing to the posted advertisement,\r\n\r\nI am writing to apply for advertised position Enclosed is my resume, which describes my academic and professional experiences to date. As my resume details\r\n\r\nI have experience in the Sales, Marketing, HR & Office Administration. I believe that my academic background along with my professional experiences provides a solid foundation for the advertised position.\r\n\r\nThank you for your time and consideration.\r\n\r\nI look forward to speaking with you.\r\n\r\nRegards\r\n\r\nFaraz Arif\r\n\r\n3505 1969', '181472841.pdf', '37.131.57.139', 'Bahrain', '', '2020-03-09', '21:11:24'), (50, '', 'DRIVER', 'Jomar Brizuela Padayao ', '37375714', 'padayao_jomar@yahoo.com', ' ', '1854881862.docx', '37.131.51.5', 'Bahrain', 'Madinat Hamad', '2020-03-09', '22:00:58'), (51, '', '', 'Jomar Brizuela Padayao ', '37375714', 'padayao_jomar@yahoo.com', ' ', '1548778879.docx', '37.131.51.5', 'Bahrain', 'Madinat Hamad', '2020-03-09', '22:02:37'), (52, '', 'DRIVER', 'Hannan A K M Abdul Gafur ', '33367133', 'ssfhannan@gmail.com', ' Driver Job Application', '1756722985.docx', '109.161.172.128', 'Bahrain', 'Manama', '2020-03-09', '22:04:18'), (53, '', 'DRIVER', 'Hannan A K M Abdul Gafur ', '33367133', 'ssfhannan@gmail.com', ' Driver Job Application', '1586911796.docx', '109.161.172.128', 'Bahrain', 'Manama', '2020-03-09', '22:04:22'), (54, '', 'SECRETARY', 'Nkongkuku Collins Timah', '+97335092294', 'nkongcollins@gmail.com', ' ', '1874586103.docx', '94.76.53.198', 'Bahrain', 'Manama', '2020-03-09', '23:19:05'), (55, '', '', 'Nkongkuku Collins Timah', '+97335092294', 'nkongcollins@gmail.com', ' ', '316245090.docx', '94.76.53.198', 'Bahrain', 'Manama', '2020-03-09', '23:19:49'), (56, '', 'DRIVER', 'Muhammad Amir ', '39886409 ', 'amirlateef90@yahoo.com ', ' ', '1530069443.docx', '82.194.43.179', 'Bahrain', 'Maqaba', '2020-03-09', '23:29:09'), (57, '', 'SECRETARY', 'Shorouq Mohamed Kenawy', '37778614', 'sh20133935@gmail.com', ' ', '702566685.pdf', '89.148.53.63', 'Bahrain', '', '2020-03-10', '04:20:13'), (58, '', 'SECRETARY', 'Hend Buashwan', '37766031', 'hindbuashwan@gmail.com', 'Dear Sir/Madam,\r\n\r\nI am offering my services for the vacancy Secretary in your respected organization. I expect to be considered favorably.\r\n\r\nP.S one file can be uploaded per application. kindly share your e-mail to enable me to share my CPR and passport copy. \r\n\r\nWarm regards,\r\nHend Buashwan\r\n\r\n37766031\r\n', '221691356.pdf', '109.161.166.15', 'Bahrain', 'Sanad', '2020-03-10', '06:21:42'), (59, '', 'DRIVER', 'Venkateswar Mellam', '00973-36890053', 'log2venkat13@gmail.com', ' Dear sir, madam\r\n\r\nI applied for post company driver if there any chance please give me opportunity\r\n\r\nThank you\r\n\r\nBest regards\r\nVenkateswar Mellam\r\n00973-36890053', '965723954.pdf', '62.209.10.77', 'Bahrain', '', '2020-03-10', '07:14:43'), (60, '', 'SECRETARY', 'Aiman Javaid', '+973 34061430', 'aimanjavaid2011@hotmail.com', ' ', '1589786206.pdf', '89.148.54.111', 'Bahrain', '', '2020-03-10', '08:08:48'), (61, '', 'SECRETARY', 'Vity Elizabeth George', '36529915', 'elizabeth17george@gmail.com', 'Greetings,\r\n\r\nI am writing to apply for the job of a Secretary.\r\nI offer myself as a prime candidate with my strong interpersonal skills and an ability to interface with individuals at all levels.\r\nAlso, I can skillfully create communication pieces and work effectively to consistently complete the assigned work within challenging time.\r\nPresently I am working as a Secretary to the Chairman and Vice Chairman.\r\nI am sure to make a positive contribution towards your esteemed organization and look forward to discussing my capabilities in more details. \r\nMy resume is attached with for your kind perusal.\r\nI am available for a personal interview at your convenience.\r\n\r\nThank you for your time and consideration.\r\n\r\nSincerely\r\n\r\nVity Elizabeth George\r\n36529915 ', '259367735.docx', '188.137.137.222', 'Bahrain', '', '2020-03-10', '08:35:28'), (62, '', 'DRIVER', 'Riyas khan', '38497839', 'Riyaskhansalim@gmail.com', ' now iam in visit visa\r\n10 years expirience driving in gcc and holding waild kuwait licence', '148641740.docx', '193.188.105.112', 'Bahrain', 'Al Muharraq', '2020-03-10', '08:39:12'), (63, '', '', 'Dinesh Chandra Regmi', '36625334', 'dcr_waling@yahoo.com', ' Already attach CV', '1332727538.pdf', '109.161.146.234', 'Bahrain', 'Manama', '2020-03-10', '09:10:08'), (64, '', 'DRIVER', 'MOHAMMED FAIZAN', '3324 1175', 'muhammednaaz78@gmail.com', ' Dear Sir/madam Subject†Application for the post of Driver†Your recent job posting indicated that you are looking for a responsible, experienced driver to join your team. Throughout my career, I have taken pride in my ability to offer courteous, reliable service, and have worked hard to meet deadlines efficiently. I am dedicated to my colleagues and do my best to ensure that the customer’s and company’s needs are met. I have experience in warehouse operations, as well as product distribution. Though meeting delivery times is important, I prioritize safety above all else, taking the necessary steps to ensure a safe work environment for me and my fellow colleagues. I pay close attention to detail, from delivery slips to invoices, to keep the business on track. When problems arise, I do not shy away from accountability, but redouble my efforts to solve them. My commitment to quality, timely service is what sets me apart from the typical driver. I work well with my colleagues, assuming the necessary roles needed to get the job done. If you’re looking for someone who takes initiative and strives to help the company grow, I believe I am the candidate for you. I look forward to speaking with you and thank you for your time. Thanks & regards, Momin Faizan\r\n973 3324 1175', '1020992361.pdf', '84.255.152.118', 'Bahrain', 'Manama', '2020-03-10', '09:58:17'), (65, '', '', 'MOHAMMED FAIZAN', '+973 3324 1175', 'muhammednaaz78@gmail.com', ' Dear Sir/madam Subject†Application for the post of Driver†Your recent job posting indicated that you are looking for a responsible, experienced driver to join your team. Throughout my career, I have taken pride in my ability to offer courteous, reliable service, and have worked hard to meet deadlines efficiently. I am dedicated to my colleagues and do my best to ensure that the customer’s and company’s needs are met. I have experience in warehouse operations, as well as product distribution. Though meeting delivery times is important, I prioritize safety above all else, taking the necessary steps to ensure a safe work environment for me and my fellow colleagues. I pay close attention to detail, from delivery slips to invoices, to keep the business on track. When problems arise, I do not shy away from accountability, but redouble my efforts to solve them. My commitment to quality, timely service is what sets me apart from the typical driver. I work well with my colleagues, assuming the necessary roles needed to get the job done. If you’re looking for someone who takes initiative and strives to help the company grow, I believe I am the candidate for you. I look forward to speaking with you and thank you for your time. Thanks & regards, Momin Faizan\r\n973 3324 1175', '1645814625.pdf', '84.255.152.118', 'Bahrain', 'Manama', '2020-03-10', '09:59:07'), (66, '', 'SECRETARY', 'Karen M. Aniversario', '66605809', 'kmaniversario79@gmail.com', ' • Works effectively with all levels of employees supervisory levels of management.\r\n• A team player and exposed to diverse nationalities.\r\n• Works independently, flexible, and have the ability to multi-task, \r\n• Handles company information with confidentiality and discretion.\r\n• Have knowledge in MS Office software application such as Word, Excel, Outlook. \r\n• Have ten years of insurance related tasks, customer / patient services skills in health care facilities and operations and performs administratively related duties. \r\n• Knowledgeable in records keeping and management\r\n', '527644604.pdf', '109.161.144.179', 'Bahrain', 'Al Muharraq', '2020-03-10', '14:12:55'), (67, '', 'DRIVER', 'mahmood', '33730857', 'aml19@live.com', ' ', '1179795150.docx', '95.84.99.28', 'Bahrain', '', '2020-03-10', '15:03:11'), (68, '', 'SECRETARY', 'Annabelle Roxanne Mañalac', '33602051', 'Anne_z09@yahoo.com', 'Dear Mr./ Ms.,\r\n\r\nGood Day.\r\n\r\nI am very interested in applying for the Position mention on my email.\r\n- Secretary\r\nMy qualifications and experience is attached on my cv.\r\n\r\nPlease take a moment to review my attached application document:\r\n- up to date Resume\r\n\r\nThank you and i looking forward to hearing from you.\r\n\r\nBest Regards,\r\n\r\nAnnabelle Roxanne Mañalac', '2036323988.pdf', '89.148.3.179', 'Bahrain', '', '2020-03-10', '15:34:43'), (69, '', 'SECRETARY', 'Annabelle Roxanne Mañalac', '33602051', 'Anne_z09@yahoo.com', 'Dear Mr./ Ms.,\r\n\r\nGood Day.\r\n\r\nI am very interested in applying for the Position mention on my email.\r\n- Secretary\r\nMy qualifications and experience is attached on my cv.\r\n\r\nPlease take a moment to review my attached application document:\r\n- up to date Resume\r\n\r\nThank you and i looking forward to hearing from you.\r\n\r\nBest Regards,\r\n\r\nAnnabelle Roxanne Mañalac', '1901263781.pdf', '89.148.3.179', 'Bahrain', '', '2020-03-10', '15:34:46'), (70, '', 'DRIVER', 'Maariappan', '66334937', 'sivailango3@gmail.com', ' ', '202803719.pdf', '109.161.146.204', 'Bahrain', 'Manama', '2020-03-10', '16:02:12'), (71, '', 'DRIVER', 'Zeeshan Abbas', '38706150', 'Zeeshan49188@outlook.com', ' hi Good Evening !\r\nThis is Zeeshan Abbas Applying for Driver job in your Company. Thank you', '1934891124.docx', '37.131.26.2', 'Bahrain', '', '2020-03-10', '16:45:18'), (72, '', 'DRIVER', 'Muhammad hasib ', '37765884', 'mhasib31@yahoo.com', ' ', '773167.docx', '109.161.146.252', 'Bahrain', 'Manama', '2020-03-10', '16:52:37'), (73, '', '', 'Muhammad hasib ', '37765884', 'mhasib31@yahoo.com', ' I can provide all my documents once I get a call for interview ', '1994653824.docx', '109.161.146.252', 'Bahrain', 'Manama', '2020-03-10', '16:54:03'), (74, '', 'SECRETARY', 'VITY ELIZABETH GEORGE', '+973 36529915', 'elizabeth17george@gmail.com', ' ', '1317339024.docx', '81.22.30.59', 'Bahrain', 'Manama', '2020-03-12', '10:52:26'), (75, '', 'Punjab', 'Surinder Kumar', '+918968282564', 'GAGANENTERPRISES.LAS@GMAIL.COM', ' ', '1470609481.pdf', '117.223.230.155', 'India', 'Adamwal', '2020-03-12', '14:51:48'), (76, '', 'DRIVER', 'Jaffer abdul shaheed', '66989100', 'jfrj818@gmail.com', ' ', '1781959431.pdf', '109.161.166.35', 'Bahrain', 'Sanad', '2020-03-12', '18:40:54'), (77, '', 'DRIVER', 'Ali hani', '66924155', 'alialmajed210@icloud.com', ' ', '1281727029.docx', '62.209.8.113', 'Bahrain', '', '2020-03-13', '02:40:26'), (78, '', 'SECRETARY', 'Abdul Azeez', '39880754', 'abdulazeez.m1995@gmail.com', ' ', '1664924814.pdf', '62.209.8.95', 'Bahrain', '', '2020-03-16', '10:15:59'), (79, '', 'DRIVER', 'Doyle legal', '34629111', 'Doylevincentlegal@gmail.com', ' ', '1224862050.docx', '95.84.93.196', 'Bahrain', '', '2020-03-16', '15:16:28'), (80, '', 'DRIVER', 'V. G. Krishna', '34050124', 'Vardhanapugideon@gmail.com', 'www.khalafsons.com/jobs', '68921257.pdf', '95.84.125.152', 'Bahrain', '', '2020-03-17', '23:18:00'), (81, '', 'DRIVER', 'ABDUL HAMEED', '35119186', 'hammihr769@gmail.com', 'Dear Manager,\r\nI am searching for Executive Jobs in bahrain\r\nIf any vacancy is available, please reply to my email with your company name and contact details.\r\nI am available for interview at your convenient date & time either by phone.\r\nI now look forward to receive your positive reply soon.\r\n\r\nSincerely,\r\nAbdul Hameed', '1527859560.pdf', '37.131.77.70', 'Bahrain', 'Manama', '2020-03-18', '19:52:00'), (82, '', 'DRIVER', 'Zurehman ', '33264909', 'Ranaxain666@gmail.com ', ' Cv ', '340777456.pdf', '94.76.1.20', 'Bahrain', 'Manama', '2020-03-20', '21:18:39'), (83, '', 'DRIVER', 'Muhammad Qasim ', '33036907', 'khankashi037@gmail.com', ' ', '1156550653.pdf', '95.84.91.213', 'Bahrain', '', '2020-03-21', '12:18:00'), (84, '', 'DRIVER', 'Sadeq', '66924336', 'sss_f1979@hotmail.com', ' ', '1064725279.pdf', '88.201.109.202', 'Bahrain', 'Manama', '2020-03-21', '12:52:10'), (85, '', 'SECRETARY', 'Emma Bruneau', '36347436', 'emma.bruneau@gmail.com', ' Dear Hiring Team,\r\n\r\nI hope this email finds you well.\r\n\r\nI would like to express my interest in the Secretary position. \r\n\r\nMy profile may not be the perfect match for the role and I am not a fluent Arabic speaker but with my experience, commitment and dedication, I am confident that I can meet the expectations for the position.\r\n\r\nKindly note that I am available to join immediately and currently on a visit visa. \r\n\r\nI would be grateful if my profile could be considered and would appreciate the opportunity to interview for this opening.\r\n\r\nThank you and looking forward to hearing from you. \r\n\r\nBest regards,\r\n\r\nEmma Bruneau', '1748728687.pdf', '109.161.162.211', 'Bahrain', 'Manama', '2020-03-23', '09:53:55'), (86, '', 'DRIVER', 'Habib Zuhair', '38153293', 'habiblilspiky69@gmail.com', ' ', '1361267435.docx', '193.188.122.151', 'Bahrain', 'Manama', '2020-03-23', '17:05:37'), (87, '', '', 'Habib Zuhair', '38153293', 'habiblilspiky69@gmail.com', ' Apply for Driver ', '1036754560.docx', '193.188.122.151', 'Bahrain', 'Manama', '2020-03-23', '17:06:50'), (88, '', 'DRIVER', 'Tejvinder singh', '36087007', 'Rabjanne13@gmail.com', ' ', '897864710.pdf', '62.209.10.237', 'Bahrain', '', '2020-03-24', '13:42:49'), (89, '', 'DRIVER', 'Muhammad Saad', '35620296', 'muhmmadsaad1170@outlook.com', 'If you need other documents so send me mesg. or call \r\nThank you with best regards.', '684921972.pdf', '37.131.12.26', 'Bahrain', 'Manama', '2020-03-31', '13:35:14'); -- -------------------------------------------------------- -- -- Table structure for table `khalaf_hrtb` -- CREATE TABLE `khalaf_hrtb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `employee_cpr` varchar(255) NOT NULL, `permission_status` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `curr_day` varchar(255) NOT NULL, `curr_month` varchar(255) NOT NULL, `curr_year` varchar(255) NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `khalaf_hrtb` -- INSERT INTO `khalaf_hrtb` (`id`, `my_id`, `employee_cpr`, `permission_status`, `country`, `city`, `curr_day`, `curr_month`, `curr_year`, `curr_time`) VALUES (1, '434343', '434343', 'Full Permission', 'Bahrain', 'Manama', '09', '03', '2020', '16:43:26'); -- -------------------------------------------------------- -- -- Table structure for table `khalaf_messagetb` -- CREATE TABLE `khalaf_messagetb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `user_id` varchar(255) NOT NULL, `message` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `khalaf_messagetb` -- INSERT INTO `khalaf_messagetb` (`id`, `my_id`, `user_id`, `message`, `curr_date`, `curr_time`) VALUES (1, '5', '1', 'hi', '2020-03-31', '10:32:38'); -- -------------------------------------------------------- -- -- Table structure for table `khalaf_propertytbb` -- CREATE TABLE `khalaf_propertytbb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `property_name` varchar(255) NOT NULL, `property_details` text NOT NULL, `property_location` varchar(255) NOT NULL, `property_road_no` varchar(255) NOT NULL, `property_build_no` varchar(255) NOT NULL, `property_image` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `khalaf_propertytbb` -- INSERT INTO `khalaf_propertytbb` (`id`, `user_id`, `property_name`, `property_details`, `property_location`, `property_road_no`, `property_build_no`, `property_image`, `curr_date`, `curr_time`) VALUES (1, '', 'REAL SUITES TOWERS', '\r\nWhen we talk about Real Suites we are not only talking about the building,\r\nbut a twin tower with 13 floors each located in Mahooz,Road no.3321,Block no.333 few meters off to Saudi high way.\r\nReal suites flats has the best furniture that solves the uncomfortability problem.\r\nit\'s calm ,with enough car parking space for each flat and secure with a 24/7 hour security guard and CCTV cameras on each floor.\r\nReal suites has it\'s own maintenance team that is always there to solve faults. \r\n\r\n\r\n', 'Mahooz', '3321', '1036', '1139191632.JPG', '2019-02-14', '12:44:16'), (2, '', 'PATREX TOWER', 'The Giant building in the heart of the city of the Kingdom of Bahrain.\r\nWith a great view of the city,\r\nSpeak of luxury, Patrex Tower stands to take a shapes in our imagination, that take our life from the usual routine to an extraordinary adventure', 'Patrex', '100', '200', '418091599.JPG', '2019-02-14', '14:03:25'), (3, '', 'ADLIYA TOWER', 'A Building constructed for both Shops and offices in the heart of the city of the Kingdom of Bahrain. For Local and International Business Lords, With Large, Medium and Small spaces, Parking area for all shops and Office. Taking a space for your Business give you a chance to rank among the greatest business lords in the world. The Tower’s location gives you all the business opportunities. \r\nArea Adliya Bd no.1033 | Rd no.2721\r\n\r\n\r\n', 'Adliya', '300', '400', '1274061614.JPG', '2019-02-14', '14:42:49'), (4, '434343', 'Tubli Center', 'The Center of Business where both Local and International Investors prove their ability to gigantically rule the world. It’s a Trading Center building, Well Constructed to Meet the Needs or requirements of any Business (Offices, Shops and Showrooms). In otherwise she is called the Trading Land for business Development.', 'Tubli', '1325', '1288', '1329120667.jpeg', '2020-03-18', '14:56:10'); -- -------------------------------------------------------- -- -- Table structure for table `khalaf_usertb` -- CREATE TABLE `khalaf_usertb` ( `id` int(11) NOT NULL, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `contact` varchar(255) NOT NULL, `user_cpr` varchar(255) NOT NULL, `gender` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `image_url` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `khalaf_usertb` -- INSERT INTO `khalaf_usertb` (`id`, `first_name`, `last_name`, `contact`, `user_cpr`, `gender`, `email`, `password`, `image_url`, `curr_date`, `curr_time`) VALUES (1, 'kaketo', 'ben', '11223344', '434343', 'Male', 'ben@kvt.com', '1234', '910731546.jpg', '2019-02-13', '12:31:35'), (2, 'Remmie', 'Kb', '4454533', '', 'Female', 'remmie@kvt.com', '1234', '828215514.jpg', '2019-02-24', '12:05:45'), (3, 'Dora', 'kirabo', '34343434', '545454', 'Female', 'dora@kvt.com', '1234', 'avatar2.jpg', '2019-02-26', '15:10:17'), (4, 'mama', 'papa', '21212121', '', 'Female', 'mama@kvt.com', '1234', 'avatar2.jpg', '2020-02-04', '11:47:19'), (5, 'sayed', 'mohamed', '36738381', '921205929', 'Male', 'sayed@kvt.com', '1223', '1582253659.JPG', '2020-02-04', '12:40:29'), (6, 'Asmaa', 'Karani', '33180612', '', 'Female', 'asmaamk21@gmail.com', 'shamilamk', 'avatar2.jpg', '2020-03-09', '12:30:53'), (7, 'Daniel', 'Ofori', '35187802', '880687614', 'Male', 'danieloforidarko63@gmail.com', 'tink2ice', '1594368562.jpg', '2020-03-09', '12:48:05'), (8, 'halleluyah', 'oluwafemi', '36944129', '74257552', 'Male', 'fhalelluyhah@yahoo.com', 'gbolaru111', 'avatar2.jpg', '2020-03-09', '13:02:26'), (9, 'Fatima', 'alwarqa ', '33154313', '900100702', 'Female', 'fatima@kh.com', '161215', 'avatar2.jpg', '2020-03-22', '11:04:40'); -- -------------------------------------------------------- -- -- Table structure for table `lang_transtb` -- CREATE TABLE `lang_transtb` ( `id` int(11) NOT NULL, `english` varchar(255) NOT NULL, `arabic` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `lang_transtb` -- INSERT INTO `lang_transtb` (`id`, `english`, `arabic`) VALUES (1, 'shop name', 'اسم المحل'), (2, 'Money', 'مال'), (3, 'percentge ', 'النسبة المئوية'), (4, 'expenses', 'المصروفات'), (5, 'Salman Fardan', 'سلمان الفردان'), (6, 'Javed Air Conditioners', 'مكيفات جاويد'), (7, 'print', 'طباعة'), (8, 'details', 'تفاصيل'), (9, 'property', 'خاصية'), (10, 'careers', 'وظائف'), (11, 'our agents', 'وكلائنا'), (12, 'about', 'حول'), (13, 'extraction ', 'استخلاص'), (14, 'exit', 'الخروج'), (15, 'property name ', 'اسم الخاصية'), (16, 'date', 'تاريخ'), (17, 'Lenox 1', 'لينوكس 1\r\n'), (18, 'Indonesian Embassy', 'السفارة الاندونيسية\r\n'), (19, 'Saj 1', 'صاج 1'), (20, 'Brown Tower', 'برج براون'), (21, 'Capital Medical Complex', 'مجمع العاصمة الطبي'), (22, 'Patrex Tower', 'برج باتريكس'), (23, 'Salmaniya Plaza', 'السلمانية بلازا'), (24, 'Tubli Center', 'مركز توبلي'), (25, 'Panorama Center', 'مركز بانوراما'), (26, 'Saj 2', 'صاج 2'), (27, 'Saj 3', 'صاج 3'), (28, 'Lenox 2', 'لينوكس 2'), (29, 'Salah House', 'بيت صلاح'); -- -------------------------------------------------------- -- -- Table structure for table `mainttb` -- CREATE TABLE `mainttb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `employee_cpr` varchar(255) NOT NULL, `permission_status` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `curr_day` varchar(255) NOT NULL, `curr_month` varchar(255) NOT NULL, `curr_year` varchar(255) NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `mainttb` -- INSERT INTO `mainttb` (`id`, `my_id`, `employee_cpr`, `permission_status`, `country`, `city`, `curr_day`, `curr_month`, `curr_year`, `curr_time`) VALUES (1, '1', '434343', 'Full Permission', '', '', '29', '01', '2020', '15:33:32'), (2, '1', '921205929', 'Read/Write', 'Bahrain', 'Manama', '04', '02', '2020', '12:47:39'), (3, '434343', '900100702', 'Read/Write', 'Bahrain', 'Manama', '22', '03', '2020', '11:08:17'); -- -------------------------------------------------------- -- -- Table structure for table `main_buildingtb` -- CREATE TABLE `main_buildingtb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `building_name` varchar(255) NOT NULL, `building_location` varchar(255) NOT NULL, `bd_description` varchar(255) NOT NULL, `building_no` varchar(255) NOT NULL, `road_no` varchar(255) NOT NULL, `manager_name` varchar(255) NOT NULL, `manager_tel` varchar(255) NOT NULL, `image_url` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `main_buildingtb` -- INSERT INTO `main_buildingtb` (`id`, `user_id`, `building_name`, `building_location`, `bd_description`, `building_no`, `road_no`, `manager_name`, `manager_tel`, `image_url`, `curr_date`, `curr_time`) VALUES (1, '1', 'Real Suites A', 'Mahooz', 'Residential', '1036', '3321', 'Jehad', '32213149', '218762400.JPG', '2019-02-14', '12:05:27'), (2, '1', 'Real Suites B', 'Un Al Hassam', 'Residential', '1038', '3321', 'Jihad', '33213149', '1218736699.JPG', '2019-11-23', '12:51:43'), (3, '1', 'Lenox 1', 'Segeya', 'Residential', '1627', '3241', 'Jamil', '39616064', '79621283.JPG', '2019-05-04', '17:38:16'), (4, '1', 'Lenox 2', 'Segeya', 'Residential', '1625', '3241', 'Jamil', '39616064', '194364817.JPG', '2019-05-05', '11:22:20'), (5, '1', 'Lenox 3', 'Bu Ashira', 'Residential', '19', '3201', 'Kumar', '39142917', '2094162997.JPG', '2019-11-23', '12:57:29'), (6, '1', 'Saj 1', 'Un Al Hassam', 'Residential', '924', '3318', 'Sayed Hassan', '39600062', '999876390.JPG', '2019-11-23', '12:29:40'), (7, '1', 'Saj 2', 'Mahooz', 'Residential', '922', '3318', 'Sayed Hassan', '39600062', '1773446624.JPG', '2019-07-06', '11:16:40'), (8, '1', 'Saj 3', 'Manama', 'Residential', '743', '515', 'Kumar', '39142917', '65906118.JPG', '2019-11-23', '12:45:33'), (9, '1', 'Adliya Tower', 'Adliya', 'Residential', '2000', '3321', 'Jamil', '39616064', '1581047250.JPG', '2019-02-16', '14:58:28'), (10, '1', 'Patrex Tower', 'patrex', 'Residential', '111', '222', 'Kumar', '39142917', '1286671067.JPG', '2019-02-18', '11:16:06'), (11, '1', 'Panorama Center', 'Exhibition Road', 'Residential', '189', '18', 'Jamil', '39616064', '1550418107.JPG', '2019-11-23', '13:03:32'), (12, '1', 'Salmaniya Plaza', 'Salmaniya', 'Residential', '234', '2903', 'Jamil', '39616064', '1455400190.JPG', '2019-11-23', '13:11:59'), (13, '1', 'Adel House', 'Bu Ashira', 'Residential', '18', '3241', 'Jamil', '39616064', '1410182882.JPG', '2019-11-28', '16:07:22'), (14, '1', 'Brown Tower', 'Juffair', 'Residential', '767', '2412', 'Aziz', '33729709', '1045443179.jpeg', '2019-11-28', '16:22:34'), (15, '1', 'Capital Medical Complex', 'Zinji', 'Medical Shop', '71', '3201', 'Jamil', '39616064', '308882575.jpg', '2019-12-01', '14:49:40'), (16, '1', 'Korean Embassy', 'Manama', 'Villa', '401', '915', 'Jamil', '39616064', '292070803.jpg', '2019-12-01', '14:56:39'), (17, '1', 'Indonesian Embassy', 'Manama', 'Villa', '2113', '2432', 'Jamil', '+97339616064', '922918280.JPEG', '2019-12-01', '14:58:15'), (18, '1', 'Vintage', 'Bu Ashira', 'Residential', '747', '3214', 'Jamil', '39616064', '557643344.JPEG', '2019-12-01', '15:04:47'), (19, '1', '5Villa', 'Bu Ashira', 'Residential', '1255', '3227', 'Jamil', '39616064', '920052564.jpeg', '2019-12-01', '15:11:52'), (20, '1', 'Salah House', 'Bu Ashira', 'Residential', '747', '3214', 'SALAH', '17822550', '1290914002.jpeg', '2019-12-02', '12:39:22'), (21, '1', 'Tubli Center', 'Tubli', 'Shop', '1288', '1325', 'Qasim', '33346212', '1435905923.jpeg', '2019-12-02', '13:00:05'), (22, '1', 'Manama Office', 'Bu Ashira', 'Office', '19', '3201', 'Jamil', '39616064', '1715816998.jpg', '2019-12-08', '12:34:20'); -- -------------------------------------------------------- -- -- Table structure for table `new_ordertb` -- CREATE TABLE `new_ordertb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `building_name` varchar(255) NOT NULL, `flat_no` varchar(255) NOT NULL, `product_name` varchar(255) NOT NULL, `product_qty` varchar(255) NOT NULL, `order_by_id` varchar(255) NOT NULL, `image_url_one` text NOT NULL, `image_url_two` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `notiftb` -- CREATE TABLE `notiftb` ( `id` int(11) NOT NULL, `complaint_id` varchar(255) NOT NULL, `user_cpr` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `notiftb` -- INSERT INTO `notiftb` (`id`, `complaint_id`, `user_cpr`) VALUES (134, '95', '921205929'), (136, '96', '921205929'), (138, '97', '921205929'), (140, '98', '921205929'), (142, '99', '921205929'), (144, '100', '921205929'), (146, '101', '921205929'), (148, '102', '921205929'), (150, '103', '921205929'); -- -------------------------------------------------------- -- -- Table structure for table `projecttb` -- CREATE TABLE `projecttb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `description` text NOT NULL, `file_url` varchar(255) NOT NULL, `file_type` varchar(255) NOT NULL, `curr_day` varchar(255) NOT NULL, `curr_month` varchar(255) NOT NULL, `curr_year` varchar(255) NOT NULL, `time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `projecttb` -- INSERT INTO `projecttb` (`id`, `my_id`, `description`, `file_url`, `file_type`, `curr_day`, `curr_month`, `curr_year`, `time`) VALUES (1, '1', 'Brown Tower Pump room construction', '2016567356', '.mp4', '26', '10', '2019', '13:04:49'), (2, '1', 'Brown Tower Pumproom constraction', '107276055', '.jpeg', '26', '10', '2019', '14:48:18'), (3, '1', 'Brown Tower Pump room construction', '432598856', '.jpeg', '27', '10', '2019', '14:36:20'), (4, '1', '', '1284545662', '.jpeg', '27', '10', '2019', '14:37:22'), (5, '1', '', '538572176', '.jpeg', '27', '10', '2019', '14:38:24'), (6, '1', 'Brown Tower Pump room construction', '798208515', '.mp4', '27', '10', '2019', '14:39:35'), (7, '1', '', '165816346', '.jpeg', '27', '10', '2019', '14:54:30'), (9, '1', 'Brown Tower Pump room construction', '1820273032', '.mp4', '27', '10', '2019', '15:03:48'), (10, '1', 'Brown Tower Pump room construction', '105159777', '.jpeg', '27', '10', '2019', '15:12:23'), (11, '1', '', '1850480707', '.jpeg', '27', '10', '2019', '15:14:19'); -- -------------------------------------------------------- -- -- Table structure for table `property_albumtb` -- CREATE TABLE `property_albumtb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `property_id` varchar(255) NOT NULL, `image_url` text NOT NULL, `curr_date` date NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `property_albumtb` -- INSERT INTO `property_albumtb` (`id`, `user_id`, `property_id`, `image_url`, `curr_date`, `curr_time`) VALUES (1, '', '1', '673881864.JPG', '2019-02-14', '12:47:22'), (2, '', '1', '1410748263.JPG', '2019-02-14', '12:47:36'), (3, '', '1', '314019947.JPG', '2019-02-14', '12:47:57'), (4, '1', '2', '2023187209.JPG', '2020-01-05', '12:04:41'), (5, '1', '2', '2018866092.JPG', '2020-01-05', '12:04:50'), (6, '1', '4', '1930759225.jpeg', '2020-03-18', '15:04:05'), (7, '1', '4', '1803280476.jpeg', '2020-03-18', '15:18:20'), (8, '1', '4', '734776073.jpeg', '2020-03-18', '15:18:36'), (9, '1', '4', '1342885577.jpeg', '2020-03-18', '15:18:54'), (10, '1', '4', '1123283287.jpeg', '2020-03-18', '15:19:14'), (11, '1', '4', '1793752631.jpeg', '2020-03-18', '15:19:29'), (12, '1', '4', '1889469654.jpeg', '2020-03-18', '15:19:51'), (13, '1', '3', '607669948.JPG', '2020-03-18', '16:06:27'), (14, '1', '3', '694160879.JPG', '2020-03-18', '16:06:34'), (15, '1', '3', '551903303.JPG', '2020-03-18', '16:06:40'), (16, '1', '3', '728253144.JPG', '2020-03-18', '16:06:47'), (17, '1', '3', '499701234.JPG', '2020-03-18', '16:06:53'), (18, '1', '3', '780546365.JPG', '2020-03-18', '16:07:01'), (19, '1', '3', '906867634.JPG', '2020-03-18', '16:07:07'), (20, '1', '3', '843344220.JPG', '2020-03-18', '16:07:14'); -- -------------------------------------------------------- -- -- Table structure for table `purchased_producttb` -- CREATE TABLE `purchased_producttb` ( `id` int(11) NOT NULL, `user_id` varchar(255) NOT NULL, `order_id` varchar(255) NOT NULL, `building_name` varchar(255) NOT NULL, `flat_no` varchar(255) NOT NULL, `product_name` varchar(255) NOT NULL, `product_qty` varchar(255) NOT NULL, `shop_iterm` varchar(255) NOT NULL, `total_price` varchar(255) NOT NULL, `order_by_id` varchar(255) NOT NULL, `picked_by` varchar(255) NOT NULL, `invoice_no` varchar(255) NOT NULL, `curr_date` varchar(255) NOT NULL, `curr_month` varchar(255) NOT NULL, `curr_year` varchar(255) NOT NULL, `curr_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `shoptb` -- CREATE TABLE `shoptb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `shop_name` varchar(255) NOT NULL, `curr_day` varchar(255) NOT NULL, `curr_month` varchar(255) NOT NULL, `curr_year` varchar(255) NOT NULL, `time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `shoptb` -- INSERT INTO `shoptb` (`id`, `my_id`, `shop_name`, `curr_day`, `curr_month`, `curr_year`, `time`) VALUES (1, '1', 'Salman Fardan', '25', '11', '2019', '14:49:00'), (2, '1', 'Javed Air Conditioners', '25', '11', '2019', '14:58:52'), (3, '1', 'Al Salam Gas', '25', '11', '2019', '15:07:40'); -- -- Indexes for dumped tables -- -- -- Indexes for table `adverttb` -- ALTER TABLE `adverttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `advert_albumtb` -- ALTER TABLE `advert_albumtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ad_viewstb` -- ALTER TABLE `ad_viewstb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `agent_calltb` -- ALTER TABLE `agent_calltb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `agent_viewtb` -- ALTER TABLE `agent_viewtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bd_locationtb` -- ALTER TABLE `bd_locationtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `buliding_type` -- ALTER TABLE `buliding_type` ADD PRIMARY KEY (`id`); -- -- Indexes for table `complainttb` -- ALTER TABLE `complainttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `complaint_datingtb` -- ALTER TABLE `complaint_datingtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `expendituretb` -- ALTER TABLE `expendituretb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `graph_calendartb` -- ALTER TABLE `graph_calendartb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `graph_datatb` -- ALTER TABLE `graph_datatb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `jobstb` -- ALTER TABLE `jobstb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `khalaf_admintb` -- ALTER TABLE `khalaf_admintb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `khalaf_agenttb` -- ALTER TABLE `khalaf_agenttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `khalaf_cvtb` -- ALTER TABLE `khalaf_cvtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `khalaf_hrtb` -- ALTER TABLE `khalaf_hrtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `khalaf_messagetb` -- ALTER TABLE `khalaf_messagetb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `khalaf_propertytbb` -- ALTER TABLE `khalaf_propertytbb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `khalaf_usertb` -- ALTER TABLE `khalaf_usertb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `lang_transtb` -- ALTER TABLE `lang_transtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `mainttb` -- ALTER TABLE `mainttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `main_buildingtb` -- ALTER TABLE `main_buildingtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `new_ordertb` -- ALTER TABLE `new_ordertb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `notiftb` -- ALTER TABLE `notiftb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `projecttb` -- ALTER TABLE `projecttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `property_albumtb` -- ALTER TABLE `property_albumtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `purchased_producttb` -- ALTER TABLE `purchased_producttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `shoptb` -- ALTER TABLE `shoptb` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `adverttb` -- ALTER TABLE `adverttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27; -- -- AUTO_INCREMENT for table `advert_albumtb` -- ALTER TABLE `advert_albumtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=93; -- -- AUTO_INCREMENT for table `ad_viewstb` -- ALTER TABLE `ad_viewstb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=261; -- -- AUTO_INCREMENT for table `agent_calltb` -- ALTER TABLE `agent_calltb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `agent_viewtb` -- ALTER TABLE `agent_viewtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48; -- -- AUTO_INCREMENT for table `bd_locationtb` -- ALTER TABLE `bd_locationtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `buliding_type` -- ALTER TABLE `buliding_type` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `complainttb` -- ALTER TABLE `complainttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=104; -- -- AUTO_INCREMENT for table `complaint_datingtb` -- ALTER TABLE `complaint_datingtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42; -- -- AUTO_INCREMENT for table `expendituretb` -- ALTER TABLE `expendituretb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `graph_calendartb` -- ALTER TABLE `graph_calendartb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `graph_datatb` -- ALTER TABLE `graph_datatb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=225; -- -- AUTO_INCREMENT for table `jobstb` -- ALTER TABLE `jobstb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `khalaf_admintb` -- ALTER TABLE `khalaf_admintb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `khalaf_agenttb` -- ALTER TABLE `khalaf_agenttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `khalaf_cvtb` -- ALTER TABLE `khalaf_cvtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=90; -- -- AUTO_INCREMENT for table `khalaf_hrtb` -- ALTER TABLE `khalaf_hrtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `khalaf_messagetb` -- ALTER TABLE `khalaf_messagetb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `khalaf_propertytbb` -- ALTER TABLE `khalaf_propertytbb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `khalaf_usertb` -- ALTER TABLE `khalaf_usertb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `lang_transtb` -- ALTER TABLE `lang_transtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30; -- -- AUTO_INCREMENT for table `mainttb` -- ALTER TABLE `mainttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `main_buildingtb` -- ALTER TABLE `main_buildingtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `new_ordertb` -- ALTER TABLE `new_ordertb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `notiftb` -- ALTER TABLE `notiftb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=151; -- -- AUTO_INCREMENT for table `projecttb` -- ALTER TABLE `projecttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `property_albumtb` -- ALTER TABLE `property_albumtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- AUTO_INCREMENT for table `purchased_producttb` -- ALTER TABLE `purchased_producttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `shoptb` -- ALTER TABLE `shoptb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; COMMIT; /*!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 */;