-- http://www.phpmyadmin.net
--




--
-- Database: `001_tender`
--
CREATE DATABASE `001_tender` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `001_tender`;

-- --------------------------------------------------------

--
-- Table structure for table `asset_division_info`
--

CREATE TABLE IF NOT EXISTS `asset_division_info` (
  `division_id` int(2) unsigned NOT NULL AUTO_INCREMENT,
  `division_serial` int(2) unsigned NOT NULL,
  `division_name` varchar(30) NOT NULL,
  `bn_name` varchar(50) NOT NULL,
  `lat` double NOT NULL,
  `lon` double NOT NULL,
  `website` varchar(100) NOT NULL,
  PRIMARY KEY (`division_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=66 ;

--
-- Dumping data for table `asset_division_info`
--

INSERT INTO `asset_division_info` (`division_id`, `division_serial`, `division_name`, `bn_name`, `lat`, `lon`, `website`) VALUES
(1, 3, 'Dhaka Division', 'ঢাকা', 23.7115253, 90.4111451, 'www.dhaka.gov.bd'),
(2, 3, 'Faridpur Division', 'ফরিদপুর', 23.6070822, 89.8429406, 'www.faridpur.gov.bd'),
(3, 3, 'Gazipur Division', 'গাজীপুর', 24.0022858, 90.4264283, 'www.gazipur.gov.bd'),
(4, 3, 'Gopalganj Division', 'গোপালগঞ্জ', 23.0050857, 89.8266059, 'www.gopalganj.gov.bd'),
(5, 3, 'Jamalpur Division', 'জামালপুর', 24.937533, 89.937775, 'www.jamalpur.gov.bd'),
(6, 3, 'Kishoreganj Division', 'কিশোরগঞ্জ', 24.444937, 90.776575, 'www.kishoreganj.gov.bd'),
(7, 3, 'Madaripur Division', 'মাদারীপুর', 23.164102, 90.1896805, 'www.madaripur.gov.bd'),
(8, 3, 'Manikganj Division', 'মানিকগঞ্জ', 0, 0, 'www.manikganj.gov.bd'),
(9, 3, 'Munshiganj Division', 'মুন্সিগঞ্জ', 0, 0, 'www.munshiganj.gov.bd'),
(10, 3, 'Mymensingh Division', 'ময়মনসিং', 0, 0, 'www.mymensingh.gov.bd'),
(11, 3, 'Narayanganj Division', 'নারায়াণগঞ্জ', 23.63366, 90.496482, 'www.narayanganj.gov.bd'),
(12, 3, 'Narsingdi Division', 'নরসিংদী', 23.932233, 90.71541, 'www.narsingdi.gov.bd'),
(13, 3, 'Netrokona Division', 'নেত্রকোনা', 24.870955, 90.727887, 'www.netrokona.gov.bd'),
(14, 3, 'Rajbari Division', 'রাজবাড়ি', 23.7574305, 89.6444665, 'www.rajbari.gov.bd'),
(15, 3, 'Shariatpur Division', 'শরীয়তপুর', 0, 0, 'www.shariatpur.gov.bd'),
(16, 3, 'Sherpur Division', 'শেরপুর', 25.0204933, 90.0152966, 'www.sherpur.gov.bd'),
(17, 3, 'Tangail Division', 'টাঙ্গাইল', 0, 0, 'www.tangail.gov.bd'),
(18, 5, 'Bogra Division', 'বগুড়া', 24.8465228, 89.377755, 'www.bogra.gov.bd'),
(19, 5, 'Joypurhat Division', 'জয়পুরহাট', 0, 0, 'www.joypurhat.gov.bd'),
(20, 5, 'Naogaon Division', 'নওগাঁ', 0, 0, 'www.naogaon.gov.bd'),
(21, 5, 'Natore Division', 'নাটোর', 24.420556, 89.000282, 'www.natore.gov.bd'),
(22, 5, 'Nawabganj Division', 'নবাবগঞ্জ', 24.5965034, 88.2775122, 'www.chapainawabganj.gov.bd'),
(23, 5, 'Pabna Division', 'পাবনা', 23.998524, 89.233645, 'www.pabna.gov.bd'),
(24, 5, 'Rajshahi Division', 'রাজশাহী', 0, 0, 'www.rajshahi.gov.bd'),
(25, 5, 'Sirajgonj Division', 'সিরাজগঞ্জ', 24.4533978, 89.7006815, 'www.sirajganj.gov.bd'),
(26, 6, 'Dinajpur Division', 'দিনাজপুর', 25.6217061, 88.6354504, 'www.dinajpur.gov.bd'),
(27, 6, 'Gaibandha Division', 'গাইবান্ধা', 25.328751, 89.528088, 'www.gaibandha.gov.bd'),
(28, 6, 'Kurigram Division', 'কুড়িগ্রাম', 25.805445, 89.636174, 'www.kurigram.gov.bd'),
(29, 6, 'Lalmonirhat Division', 'লালমনিরহাট', 0, 0, 'www.lalmonirhat.gov.bd'),
(30, 6, 'Nilphamari Division', 'নীলফামারী', 25.931794, 88.856006, 'www.nilphamari.gov.bd'),
(31, 6, 'Panchagarh Division', 'পঞ্চগড়', 26.3411, 88.5541606, 'www.panchagarh.gov.bd'),
(32, 6, 'Rangpur Division', 'রংপুর', 25.7558096, 89.244462, 'www.rangpur.gov.bd'),
(33, 6, 'Thakurgaon Division', 'ঠাকুরগাঁও', 26.0336945, 88.4616834, 'www.thakurgaon.gov.bd'),
(34, 1, 'Barguna Division', 'বরগুনা', 0, 0, 'www.barguna.gov.bd'),
(35, 1, 'Barisal Division', 'বরিশাল', 0, 0, 'www.barisal.gov.bd'),
(36, 1, 'Bhola Division', 'ভোলা', 22.685923, 90.648179, 'www.bhola.gov.bd'),
(37, 1, 'Jhalokati Division', 'ঝালকাঠি', 0, 0, 'www.jhalakathi.gov.bd'),
(38, 1, 'Patuakhali Division', 'পটুয়াখালী', 22.3596316, 90.3298712, 'www.patuakhali.gov.bd'),
(39, 1, 'Pirojpur Division', 'পিরোজপুর', 0, 0, 'www.pirojpur.gov.bd'),
(40, 2, 'Bandarban Division', 'বান্দরবান', 22.1953275, 92.2183773, 'www.bandarban.gov.bd'),
(41, 2, 'Brahmanbaria Division', 'ব্রাহ্মণবাড়িয়া', 23.9570904, 91.1119286, 'www.brahmanbaria.gov.bd'),
(42, 2, 'Chandpur Division', 'চাঁদপুর', 23.2332585, 90.6712912, 'www.chandpur.gov.bd'),
(43, 2, 'Chittagong Division', 'চট্টগ্রাম', 22.335109, 91.834073, 'www.chittagong.gov.bd'),
(44, 2, 'Comilla Division', 'কুমিল্লা', 23.4682747, 91.1788135, 'www.comilla.gov.bd'),
(45, 2, 'Cox''s Bazar Division', 'কক্স বাজার', 0, 0, 'www.coxsbazar.gov.bd'),
(46, 2, 'Feni Division', 'ফেনী', 23.023231, 91.3840844, 'www.feni.gov.bd'),
(47, 2, 'Khagrachari Division', 'খাগড়াছড়ি', 23.119285, 91.984663, 'www.khagrachhari.gov.bd'),
(48, 2, 'Lakshmipur Division', 'লক্ষ্মীপুর', 22.942477, 90.841184, 'www.lakshmipur.gov.bd'),
(49, 2, 'Noakhali Division', 'নোয়াখালী', 22.869563, 91.099398, 'www.noakhali.gov.bd'),
(50, 2, 'Rangamati Division', 'রাঙ্গামাটি', 0, 0, 'www.rangamati.gov.bd'),
(51, 7, 'Habiganj Division', 'হবিগঞ্জ', 24.374945, 91.41553, 'www.habiganj.gov.bd'),
(52, 7, 'Maulvibazar Division', 'মৌলভীবাজার', 24.482934, 91.777417, 'www.moulvibazar.gov.bd'),
(53, 7, 'Sunamganj Division', 'সুনামগঞ্জ', 25.0658042, 91.3950115, 'www.sunamganj.gov.bd'),
(54, 7, 'Sylhet Division', 'সিলেট', 24.8897956, 91.8697894, 'www.sylhet.gov.bd'),
(55, 4, 'Bagerhat Division', 'বাগেরহাট', 22.651568, 89.785938, 'www.bagerhat.gov.bd'),
(56, 4, 'Chuadanga Division', 'চুয়াডাঙ্গা', 23.6401961, 88.841841, 'www.chuadanga.gov.bd'),
(57, 4, 'Jessore Division', 'যশোর', 23.16643, 89.2081126, 'www.jessore.gov.bd'),
(58, 4, 'Jhenaidah Division', 'ঝিনাইদহ', 23.5448176, 89.1539213, 'www.jhenaidah.gov.bd'),
(59, 4, 'Khulna Division', 'খুলনা', 22.815774, 89.568679, 'www.khulna.gov.bd'),
(60, 4, 'Kushtia Division', 'কুষ্টিয়া', 23.901258, 89.120482, 'www.kushtia.gov.bd'),
(61, 4, 'Magura Division', 'মাগুরা', 23.487337, 89.419956, 'www.magura.gov.bd'),
(62, 4, 'Meherpur Division', 'মেহেরপুর', 23.762213, 88.631821, 'www.meherpur.gov.bd'),
(63, 4, 'Narail Division', 'নড়াইল', 23.172534, 89.512672, 'www.narail.gov.bd'),
(64, 4, 'Satkhira Division', 'সাতক্ষীরা', 0, 0, 'www.satkhira.gov.bd'),
(65, 2, 'Dohazari Division', '', 0, 0, '');

-- --------------------------------------------------------

--
-- Table structure for table `branch`
--

CREATE TABLE IF NOT EXISTS `branch` (
  `branch_id` int(3) NOT NULL AUTO_INCREMENT,
  `branch_name` varchar(150) CHARACTER SET utf8 NOT NULL,
  `branch_sl` int(11) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`branch_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `branch`
--

INSERT INTO `branch` (`branch_id`, `branch_name`, `branch_sl`, `status`) VALUES
(1, 'Maintenance Branch', 2, 'Active'),
(2, 'GFDP Branch', 1, 'Active'),
(3, 'ICT Unit', 3, 'Active');

-- --------------------------------------------------------

--
-- Table structure for table `budget`
--

CREATE TABLE IF NOT EXISTS `budget` (
  `budget_id` int(11) NOT NULL AUTO_INCREMENT,
  `budget_name` varchar(100) NOT NULL,
  PRIMARY KEY (`budget_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `budget`
--

INSERT INTO `budget` (`budget_id`, `budget_name`) VALUES
(1, 'Revenue'),
(2, 'Development');

-- --------------------------------------------------------

--
-- Table structure for table `office_info`
--

CREATE TABLE IF NOT EXISTS `office_info` (
  `office_id` int(4) NOT NULL AUTO_INCREMENT,
  `office_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `office_sl` int(5) NOT NULL,
  PRIMARY KEY (`office_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=14 ;

--
-- Dumping data for table `office_info`
--

INSERT INTO `office_info` (`office_id`, `office_name`, `office_sl`) VALUES
(1, 'Dhaka Zone', 0),
(2, 'Mymensingh Zone', 0),
(3, 'Sylhet Zone', 0),
(4, 'Comilla Zone', 0),
(5, 'Chittagong Zone', 0),
(6, 'Barisal Zone', 0),
(7, 'Khulna Zone', 0),
(8, 'Rangpur Zone', 0),
(9, 'Rajshahi Zone', 0),
(10, 'Gopalgonj Zone', 0),
(11, 'Dhaka Circle', 0),
(12, 'Chittagong Circle', 0),
(13, 'Mymensingh Circle', 0);

-- --------------------------------------------------------

--
-- Table structure for table `poor_list`
--

CREATE TABLE IF NOT EXISTS `poor_list` (
  `debarment_id` int(5) NOT NULL AUTO_INCREMENT,
  `debarment_name` text CHARACTER SET utf8 NOT NULL,
  `duration_start` date NOT NULL,
  `duration_end` date NOT NULL,
  `tender_id` varchar(200) NOT NULL,
  `description` text CHARACTER SET utf8 NOT NULL,
  `region` text CHARACTER SET utf8 NOT NULL,
  `debarment_by` varchar(200) CHARACTER SET utf8 NOT NULL,
  `debarment_date` date NOT NULL,
  `memo_no` varchar(200) CHARACTER SET utf8 NOT NULL,
  `debarment_reason` text CHARACTER SET utf8 NOT NULL,
  `system_date` datetime NOT NULL,
  `system_date_edit` datetime NOT NULL,
  `user_add` int(3) NOT NULL,
  `user_edit` int(3) NOT NULL,
  `path` varchar(100) NOT NULL,
  `serial_no` int(5) NOT NULL,
  `status` enum('Active','Inactive','Release') NOT NULL DEFAULT 'Active',
  `remark` text CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`debarment_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `poor_list`
--

INSERT INTO `poor_list` (`debarment_id`, `debarment_name`, `duration_start`, `duration_end`, `tender_id`, `description`, `region`, `debarment_by`, `debarment_date`, `memo_no`, `debarment_reason`, `system_date`, `system_date_edit`, `user_add`, `user_edit`, `path`, `serial_no`, `status`, `remark`) VALUES
(8, 'Engineering Planning Consultancy Team', '2015-04-09', '2016-04-08', 'For all types Works.', '', 'Sylhet Zone', 'Roads and Highways Department', '2015-04-09', 'No. 1393-CE, Date 09/04/15', '&#2488;&#2451;&#2460;&#2480; &#2479;&#2503; &#2453;&#2507;&#2472; &#2478;&#2499;&#2468;&#2509;&#2468;&#2495;&#2453;&#2494; &#2437;&#2472;&#2497;&#2488;&#2472;&#2509;&#2471;&#2494;&#2472;&#2503;&#2480; &#2453;&#2494;&#2460;&#2503;&#2480; &#2460;&#2472;&#2509;&#2479; Debar &#2453;&#2480;&#2494; &#2489;&#2482;&#2404;', '2015-06-29 11:14:58', '2015-06-29 11:18:02', 19, 19, '', 0, 'Active', ''),
(7, 'M/S Richi Enterprise', '2015-02-09', '2016-02-08', 'Tender ID 9466', '104/A, Nayatola, Mogbazar, Dhaka.', 'Dhaka Zone', 'Roads and Highways Department', '2015-02-09', 'No. 622-DZ, Date 09-02-15', '&#2470;&#2494;&#2454;&#2495;&#2482;&#2453;&#2499;&#2468; &#2470;&#2482;&#2495;&#2482;&#2503; &#2460;&#2494;&#2482;&#2495;&#2527;&#2494;&#2468;&#2496;&#2480; &#2438;&#2486;&#2509;&#2480;&#2527;&#2404;', '2015-06-29 11:05:01', '2015-06-29 11:07:18', 19, 19, 'admin/docs/office_order/moc_70a80b4bd585c1d56b77df9a2e9f7936.pdf', 0, 'Active', ''),
(6, 'OTBL-TE (JV)', '2014-12-22', '2017-12-21', 'Tender ID 9810 & 9821', 'House No. 37 (3rd Floor), Road No. 6, Block-D, Niketon, Gulshan-1, Dhaka-1212.', 'Rangpur Zone', 'Roads and Highways Department', '2014-12-22', 'No. 3101 (3)-RZ, Date 22/12/14', '.', '2015-06-29 11:01:47', '2016-08-14 13:44:31', 19, 19, 'admin/docs/office_order/moc_46f735cee52c257f43bf744e988c2dc5.pdf', 0, 'Release', ''),
(19, 'Md. Khurshaduzzaman', '2016-07-17', '2017-07-16', 'x', 'Eastern Elite Center, G-5, House No.-50, Road No.-9/A, Dhanmondi, Dhaka.', '&#2472;&#2495;&#2478;&#2509;&#2472; &#2478;&#2494;&#2472;&#2503;&#2480; &#2474;&#2494;&#2469;&#2480; &#2453;&#2494;&#2460;&#2503;&#2480; &#2488;&#2494;&#2439;&#2463;&#2503; &#2478;&#2460;&#2497;&#2470; &#2453;&#2480;&#2494;&#2480; &#2453;&#2494;&#2480;&#2467;&#2503;&#2404;', 'Roads and Highways Department', '2016-07-17', '&#2488;&#2509;&#2478;&#2494;&#2480;&#2453; &#2472;&#2434;&#2435;&#2535;&#2534;&#2536;/&#2535;&#2539;-&#2538;&#2534;&#2536;&#2542;-&#2465;&#2495;&#2460;&#2503;&#2465;', '&#2536;&#2534;&#2535;&#2539;-&#2536;&#2534;&#2535;&#2540; &#2437;&#2480;&#2509;&#2469;&#2476;&#2459;&#2480;&#2503; &#2455;&#2494;&#2460;&#2496;&#2474;&#2497;&#2480; &#2488;&#2524;&#2453; &#2476;&#2495;&#2477;&#2494;&#2455;&#2494;&#2471;&#2496;&#2472; &#2474;&#2495;&#2447;&#2478;&#2474;&#2495; (&#2488;&#2503;&#2468;&#2497;/&#2453;&#2494;&#2482;&#2477;&#2494;&#2480;&#2509;&#2463;) &#2447;&#2480; &#2438;&#2451;&#2468;&#2494;&#2527; &#2455;&#2494;&#2460;&#2496;&#2474;&#2497;&#2480; &#2438;&#2460;&#2478;&#2468;&#2474;&#2497;&#2480;-&#2439;&#2463;&#2494;&#2454;&#2507;&#2482;&#2494; &#2438;&#2462;&#2509;&#2458;&#2482;&#2495;&#2453; &#2478;&#2489;&#2494;&#2488;&#2524;&#2453;&#2503;&#2480; (&#2438;&#2480;-&#2537;&#2535;&#2534;) &#2539;&#2478; &#2453;&#2495;&#2482;&#2507;&#2478;&#2495;&#2463;&#2494;&#2480; &#2447; &#2540;&#2537;.&#2542;&#2534; &#2478;&#2495;&#2463;&#2494;&#2480;(&#2535;x&#2535;&#2539;.&#2536;&#2539; + &#2536;x&#2537;&#2534;.&#2538;&#2542;&#2542;) &#2470;&#2504;&#2480;&#2509;&#2456;&#2509;&#2479;&#2503;&#2480; &#2438;&#2480;&#2488;&#2495;&#2488;&#2495;-&#2474;&#2495;&#2488;&#2495; &#2455;&#2494;&#2480;&#2509;&#2465;&#2494;&#2480; &#2488;&#2503;&#2468;&#2497; &#2472;&#2495;&#2480;&#2509;&#2478;&#2494;&#2467;&#2503;&#2480; &#2482;&#2453;&#2509;&#2487;&#2509;&#2479;&#2503; &#2472;&#2495;&#2478;&#2509;&#2472; &#2478;&#2494;&#2472;&#2503;&#2480; &#2474;&#2494;&#2469;&#2480; &#2453;&#2494;&#2460;&#2503;&#2480; &#2488;&#2494;&#2439;&#2463;&#2503; &#2478;&#2460;&#2497;&#2470; &#2453;&#2480;&#2494;&#2480; &#2453;&#2494;&#2480;&#2467;&#2503;&#2404;', '2016-07-24 15:23:10', '2016-07-24 15:44:24', 19, 19, 'admin/docs/office_order/moc_914f6c711650acc1decd3794fdf35d33.pdf', 0, 'Active', ''),
(9, 'Project Builders Limited ( PBL)', '2015-06-15', '2018-06-14', 'Contract No. PMP 2005-2006/TS/CM-01/C-07', 'PBL Tower, 5th & 6th Floor, 17. (North) C/A, Gulshan-2, Dhaka-1212.', 'Comilla Zone', 'Roads and Highways Department', '2015-06-15', '1354/2(3)', '&#2453;&#2494;&#2460; &#2472;&#2495;&#2480;&#2509;&#2471;&#2494;&#2480;&#2495;&#2468; &#2488;&#2478;&#2527;&#2503; &#2488;&#2478;&#2509;&#2474;&#2472;&#2509;&#2472; &#2453;&#2480;&#2468;&#2503; &#2472;&#2494; &#2474;&#2494;&#2480;&#2494;&#2527;', '2015-06-29 11:27:43', '0000-00-00 00:00:00', 19, 0, 'admin/docs/office_order/moc_df124afcaa2c5215b37a2c3ec319a96e.pdf', 0, 'Active', ''),
(10, 'Project Builders Limited ( PBL)', '2015-06-15', '2018-06-14', 'Contract No. e-GP/PMP/CZ-02/2012-2013 and Contract No. PMP/CZ-4 (Retender) 2012-2013', 'PBL Tower, 5th & 6th Floor, 17. (North) C/A, Gulshan-2, Dhaka-1212.', 'Chittagong Zone', 'Roads and Highways Department', '2015-06-15', '1237 /2(3)', '&#2453;&#2494;&#2460; &#2472;&#2495;&#2480;&#2509;&#2471;&#2494;&#2480;&#2495;&#2468; &#2488;&#2478;&#2527;&#2503; &#2488;&#2478;&#2509;&#2474;&#2472;&#2509;&#2472; &#2453;&#2480;&#2468;&#2503; &#2472;&#2494; &#2474;&#2494;&#2480;&#2494;&#2527;&#2404;', '2015-06-29 11:33:53', '0000-00-00 00:00:00', 19, 0, 'admin/docs/office_order/moc_df4f5a32cb8f13f678763e6ac74a0a92.pdf', 0, 'Active', ''),
(11, 'Multi Tech Engineering', '2015-07-05', '2016-07-04', 'Tender ID No. 14922', '70/A (1st Floor) New Eskaton Road, Dhaka-100', 'BRRL, Dhaka', 'Roads and Highways Department', '2015-07-05', '02', '&#2470;&#2494;&#2454;&#2495;&#2482;&#2453;&#2499;&#2468; &#2470;&#2482;&#2495;&#2482;&#2503; &#2460;&#2494;&#2482;&#2495;&#2479;&#2492;&#2494;&#2468;&#2495;&#2480; &#2438;&#2486;&#2509;&#2480;&#2479;&#2492;', '2015-07-09 14:26:32', '2015-07-09 14:33:51', 19, 19, 'admin/docs/office_order/moc_c1738f2012246bdc47c640912624ed29.pdf', 0, 'Active', ''),
(12, 'Multi Tech Engineering', '2015-07-05', '2016-07-04', 'Tender ID No. 14922', '70/A (1st Floor) New Eskaton Road, Dhaka-1000.', 'BRRL, Dhaka', 'Roads and Highways Department', '2015-07-05', '02', '&#2470;&#2494;&#2454;&#2495;&#2482;&#2453;&#2499;&#2468; &#2470;&#2482;&#2495;&#2482;&#2503; &#2460;&#2494;&#2482;&#2495;&#2527;&#2494;&#2468;&#2496;&#2480; &#2438;&#2486;&#2509;&#2480;&#2527;&#2404;', '2015-07-09 14:41:26', '0000-00-00 00:00:00', 19, 0, 'admin/docs/office_order/moc_ebb98c645c7a46a9e48c5f35370087d7.pdf', 0, 'Inactive', ''),
(13, '&#2470;&#2495; &#2438;&#2460;&#2494;&#2470; &#2439;&#2462;&#2509;&#2460;&#2495;&#2472;&#2495;&#2527;&#2494;&#2480;&#2509;&#2488;', '2015-09-27', '2018-09-26', '&#2488;&#2509;&#2478;&#2494;&#2480;&#2453; &#2472;&#2434; &#2537;&#2539;.&#2534;&#2534;.&#2534;&#2534;&#2534;&#2534;.&#2534;&#2535;&#2539;.&#2536;&#2534;.&#2534;&#2534;&#2540;.&#2535;&#2539; -&#2538;&', '&#2542;&#2543; &#2480;&#2503;&#2482;&#2451;&#2527;&#2503; &#2447;&#2509;&#2479;&#2494;&#2474;&#2509;&#2480;&#2507;&#2458; &#2488;&#2524;&#2453; (&#2488;&#2509;&#2463;&#2503;&#2486;&#2472; &#2480;&#2507;&#2465;), &#2454;&#2497;&#2482;&#2472;&#2494;', '&#2454;&#2497;&#2482;&#2472;&#2494; &#2460;&#2507;&#2472; &#2447;&#2476;&#2434; &#2439;&#2489;&#2494;&#2480; &#2437;&#2471;&#2496;&#2472; &#2488;&#2453;&#2482; &#2453;&#2509;&#2480;&#2527;&#2453;', 'Roads and Highways Department', '2015-09-27', '982', '&#2472;&#2495;&#2480;&#2509;&#2471;&#2494;&#2480;&#2495;&#2468; &#2488;&#2478;&#2527;&#2503;&#2480; &#2474;&#2480; &#2451; &#2476;&#2480;&#2509;&#2471;&#2495;&#2468; &#2536;&#2540;&#2541; &#2470;&#2495;&#2472; &#2488;&#2478;&#2527;&#2503; &#2488;&#2478;&#2494;&#2474;&#2509;&#2468; &#2472;&#2494; &#2453;&#2480;&#2494; &#2447;&#2476;&#2434; &#2453;&#2494;&#2460; &#2437;&#2488;&#2478;&#2494;&#2474;&#2509;&#2468; &#2480;&#2503;&#2454;&#2503; &#2478;&#2494;&#2482;&#2494;&#2478;&#2494;&#2482; &#2451; &#2472;&#2495;&#2480;&#2509;&#2478;&#2494;&#2467; &#2453;&#2494;&#2460;&#2503; &#2476;&#2509;&#2479;&#2476;&#2489;&#2499;&#2468; &#2479;&#2472;&#2509;&#2468;&#2509;&#2480;&#2474;&#2494;&#2468;&#2495; &#2488;&#2494;&#2439;&#2465; &#2469;&#2503;&#2453;&#2503; &#2472;&#2495;&#2527;&#2503; &#2458;&#2482;&#2503; &#2455;&#2495;&#2527;&#2503; &#2458;&#2497;&#2453;&#2509;&#2468;&#2495;&#2472;&#2494;&#2478;&#2494;&#2480; &#2486;&#2480;&#2509;&#2468; &#2477;&#2434;&#2455; &#2453;&#2480;&#2494;&#2527;&#2404;', '2015-09-27 17:05:56', '2015-09-27 17:13:39', 19, 19, 'admin/docs/office_order/moc_9b7ebfac14c56adae2d6fda8ce2b8e27.pdf', 0, 'Active', ''),
(14, '&#2470;&#2495; &#2438;&#2460;&#2494;&#2470; &#2439;&#2462;&#2509;&#2460;&#2495;&#2472;&#2495;&#2527;&#2494;&#2480;&#2509;&#2488;', '2015-09-27', '2018-09-26', '.', '&#2542;&#2543;, &#2480;&#2503;&#2482;&#2451;&#2527;&#2503; &#2447;&#2474;&#2509;&#2480;&#2507;&#2458; &#2488;&#2524;&#2453; (&#2487;&#2509;&#2463;&#2503;&#2486;&#2472; &#2480;&#2507;&#2465;), &#2454;&#2497;&#2482;&#2472;&#2494;', '&#2454;&#2497;&#2482;&#2472;&#2494; &#2460;&#2507;&#2472; &#2451; &#2439;&#2489;&#2494;&#2480; &#2437;&#2471;&#2496;&#2472; &#2488;&#2453;&#2482; &#2453;&#2509;&#2480;&#2527;&#2453;&#2494;&#2480;&#2496; &#2470;&#2474;&#2509;&#2468;&#2480;', 'Roads and Highways Department', '2015-09-27', '&#2447;&#2475;.&#2465;&#2495;-&#2536;/&#2543;&#2542;&#2536; &#2468;&#2494;&#2480;&#2495;&#2454; &#2536;&#2541;-&#2534;&#2543;-&#2536;&#2534;&#2535;&#2539;', '&#2454;&#2497;&#2482;&#2472;&#2494;-&#2458;&#2497;&#2453;&#2472;&#2455;&#2480;-&#2488;&#2494;&#2468;&#2453;&#2509;&#2487;&#2495;&#2480;&#2494; &#2488;&#2524;&#2453;&#2503;&#2480; &#2539;&#2537;&#2468;&#2478; (&#2438;&#2434;&#2486;), &#2539;&#2538;&#2468;&#2478; (&#2438;&#2434;&#2486;)&#2453;&#2495;&#2435;&#2478;&#2495;&#2435; &#2441;&#2458;&#2497;&#2453;&#2480;&#2467;&#2488;&#2489; &#2453;&#2494;&#2480;&#2509;&#2474;&#2503;&#2463;&#2495;&#2434; &#2441;&#2458;&#2497;&#2453;&#2480;&#2467;&#2488;&#2489; &#2453;&#2494;&#2480;&#2509;&#2474;&#2503;&#2463;&#2495;&#2434; &#2488;&#2495;&#2482;&#2453;&#2507;&#2463; &#2453;&#2494;&#2460;&#2463;&#2495; &#2453;&#2494;&#2480;&#2509;&#2479;&#2494;&#2470;&#2503;&#2486; &#2437;&#2472;&#2497;&#2479;&#2494;&#2527;&#2496; &#2472;&#2495;&#2480;&#2509;&#2471;&#2494;&#2480;&#2495;&#2468; &#2488;&#2478;&#2527;&#2503;&#2480; &#2474;&#2480; &#2451; &#2476;&#2480;&#2509;&#2471;&#2495;&#2468; &#2536;&#2540;&#2541; &#2470;&#2495;&#2472; &#2488;&#2478;&#2527;&#2503; &#2488;&#2478;&#2494;&#2474;&#2509;&#2468; &#2472;&#2494; &#2453;&#2480;&#2494; &#2447;&#2476;&#2434; &#2453;&#2494;&#2460; &#2437;&#2488;&#2478;&#2494;&#2474;&#2509;&#2468; &#2480;&#2503;&#2454;&#2503; &#2478;&#2494;&#2482;&#2494;&#2478;&#2494;&#2482; &#2451; &#2472;&#2495;&#2480;&#2509;&#2478;&#2494;&#2472; &#2453;&#2494;&#2460;&#2503; &#2476;&#2509;&#2479;&#2476;&#2489;&#2499;&#2468; &#2479;&#2472;&#2509;&#2468;&#2509;&#2480;&#2474;&#2494;&#2468;&#2495; &#2488;&#2494;&#2439;&#2465; &#2469;&#2503;&#2453;&#2503; &#2472;&#2495;&#2527;&#2503; &#2458;&#2482;&#2503; &#2455;&#2495;&#2527;&#2503; &#2458;&#2497;&#2453;&#2509;&#2468;&#2495;&#2472;&#2494;&#2478;&#2494;', '2015-10-05 12:17:32', '0000-00-00 00:00:00', 19, 0, 'admin/docs/office_order/moc_c518fe8e1c61e3440c96cf8bfa858eb3.pdf', 0, 'Inactive', ''),
(15, 'M/S M.A. Engineering', '2015-12-15', '2018-12-14', 'Contract No/02(Two)/2011-2012/SE/SRC', 'Suite # 607, Paltan Tower (6th Floor), 87 Purana Paltan Lane, Dhaka-1000', '&#2488;&#2495;&#2482;&#2503;&#2463; &#2488;&#2524;&#2453; &#2488;&#2494;&#2480;&#2509;&#2453;&#2503;&#2482; &#2451; &#2439;&#2489;&#2494;&#2480; &#2437;&#2471;&#2496;&#2472; &#2488;&#2453;&#2482; &#2453;&#2509;&#2480;&#2527;&#2453;&#2494;&#2480;&#2496;&#2480; &#2470;&#2474;&#2509;&#2468;&#2480;', 'Roads and Highways Department', '2015-12-15', 'No. 5-679/5018/1(6)', '&#2488;&#2524;&#2453; &#2474;&#2480;&#2495;&#2476;&#2489;&#2472; &#2451; &#2478;&#2489;&#2494;&#2488;&#2524;&#2453; &#2476;&#2495;&#2477;&#2494;&#2455; &#2447;&#2480; &#2488;&#2509;&#2478;&#2494;&#2480;&#2453; &#2472;&#2434;-&#2537;&#2539;.&#2534;&#2534;.&#2534;&#2534;&#2534;&#2534;.&#2534;&#2535;&#2539;.&#2536;&#2534;.&#2534;&#2536;&#2539;.&#2535;&#2539;-&#2543;&#2541;&#2536; &#2468;&#2494;&#2434; &#2536;&#2543;-&#2535;&#2534;-&#2536;&#2534;&#2535;&#2539; &#2451; &#2474;&#2509;&#2480;&#2471;&#2494;&#2472; &#2474;&#2509;&#2480;&#2453;&#2508;&#2486;&#2482;&#2496; (HOPE) &#2488;&#2524;&#2453; &#2451; &#2460;&#2472;&#2474;&#2469; &#2437;&#2471;&#2495;&#2470;&#2474;&#2509;&#2468;&#2480;, &#2488;&#2524;&#2453; &#2477;&#2476;&#2472;, &#2468;&#2503;&#2460;&#2455;&#2494;&#2433;&#2451;, &#2466;&#2494;&#2453;&#2494; &#2447;&#2480; &#2474;&#2509;&#2480;&#2503;&#2453;&#2509;&#2487;&#2495;&#2468;&#2503; &#2537; (&#2468;&#2495;&#2472;) &#2476;&#2459;&#2480;&#2503;&#2480; &#2460;&#2472;&#2509;&#2479; Debar &#2456;&#2507;&#2487;&#2472;&#2494; &#2453;&#2480;&#2494; &#2489;&#2482;&#2404;', '2016-01-05 11:01:49', '2017-01-02 12:53:13', 19, 19, 'admin/docs/office_order/moc_212ff8f125f101c3fd818a7595066fdd.pdf', 0, 'Active', ''),
(16, '&#2438;&#2480;&#2486;&#2494;&#2470; &#2438;&#2482;&#2496; &#2447;&#2472;&#2509;&#2463;&#2494;&#2480;&#2474;&#2509;&#2480;&#2494;&#2439;&#2460; &#2447;&#2480; &#2488;&#2509;&#2476;&#2468;&#2509;&#2468;&#2509;&#2476;&#2494;&#2471;&#2495;&#2453;&#2494;&#2480;&#2496; &#2438;&#2476;&#2509;&#2470;&#2497;&#2480; &#2480;&#2489;&#2495;&#2478;', '2016-01-12', '2099-01-01', 'x', '&#2538;&#2534;/&#2465;&#2495;, &#2482;&#2507;&#2489;&#2494;&#2480;&#2474;&#2494;&#2524;&#2494;, &#2453;&#2507;&#2468;&#2527;&#2494;&#2482;&#2496;, &#2488;&#2495;&#2482;&#2503;&#2463;&#2404;', '&#2488;&#2524;&#2453; &#2451; &#2460;&#2472;&#2474;&#2469; &#2437;&#2471;&#2495;&#2470;&#2474;&#2509;&#2468;&#2480;&#2503;&#2480; &#2488;&#2495;&#2482;&#2503;&#2463; &#2488;&#2524;&#2453; &#2488;&#2494;&#2480;&#2509;&#2453;&#2503;&#2482; &#2451; &#2441;&#2489;&#2494;&#2480; &#2437;&#2471;&#2496;&#2472; &#2488;&#2453;&#2482; &#2453;&#2509;&#2480;&#2527;&#2453;&#2494;&#2480;&#2496;&#2480; &#2470;&#2474;&#2509;&#2468;&#2480;&#2503; &#2479;&#2503; &#2453;&#2507;&#2472; &#2470;&#2480;&#2474;&#2468;&#2509;&#2480;&#2503; &#2437;&#2434;&#2486; &#2455;&#2509;&#2480;&#2489;&#2467;&#2503; &#2437;&#2479;&#2507;&#2455;&#2509;&#2479; (Debar) &#2476;&#2482;&#2503; &#2456;&#2507;&#2487;&#2472;&#2494;&#2404;', 'Roads and Highways Department', '2016-01-12', 'Memo No. 2-12/204, Date 12-01-2016', '&#2441;&#2474;-&#2476;&#2495;&#2477;&#2494;&#2455;&#2496;&#2527; &#2474;&#2509;&#2480;&#2453;&#2508;&#2486;&#2482;&#2496;, &#2488;&#2451;&#2460;, &#2488;&#2524;&#2453; &#2441;&#2474;-&#2476;&#2495;&#2477;&#2494;&#2455;, &#2488;&#2495;&#2482;&#2503;&#2463;&#2453;&#2503; &#2455;&#2494;&#2482;&#2495;&#2455;&#2494;&#2482;&#2494;&#2460; &#2488;&#2489; &#2486;&#2494;&#2480;&#2495;&#2480;&#2496;&#2453;&#2477;&#2494;&#2476;&#2503; &#2482;&#2494;&#2462;&#2509;&#2458;&#2495;&#2468; &#2453;&#2480;&#2503;&#2472; &#2479;&#2494; PPR-2008 &#2447;&#2480; &#2476;&#2495;&#2471;&#2495; &#2535;&#2536;&#2541;(&#2536;)(&#2456;) &#2437;&#2472;&#2497;&#2479;&#2494;&#2527;&#2496; "&#2460;&#2476;&#2480;&#2470;&#2488;&#2509;&#2468;&#2495;&#2478;&#2498;&#2482;&#2453; &#2453;&#2494;&#2480;&#2509;&#2479;" &#2447;&#2480; &#2437;&#2472;&#2509;&#2468;&#2480;&#2509;&#2477;&#2497;&#2453;&#2509;&#2468; &#2479;&#2494; &#2474;&#2503;&#2486;&#2494;&#2455;&#2468; &#2437;&#2488;&#2470;&#2494;&#2458;&#2480;&#2467; &#2451; &#2437;&#2474;&#2480;&#2494;&#2471; &#2489;&#2495;&#2488;&#2503;&#2476;&#2503; &#2455;&#2472;&#2509;&#2479; &#2489;&#2451;&#2527;&#2494;&#2527; &#2488;&#2524;&#2453; &#2474;&#2480;&#2495;&#2476;&#2489;&#2472; &#2451; &#2478;&#2489;&#2494;&#2488;&#2524;&#2453; &#2476;&#2495;&#2477;&#2494;&#2455; &#2447;&#2480; &#2488;&#2509;&#2478;&#2494;&#2480;&#2453; &#2472;&#2434;-&#2537;&#2539;.&#2534;&#2534;.&#2534;&#2534;&#2534;&#2534;.&#2534;&#2535;&#2539;.&#2534;&#2541;.&#2534;&#2536;&#2543;.&#2535;&#2539;-&#2535;&#2541; &#2468;&#2494;&#2434; &#2534;&#2541;-&#2534;&#2535;-&#2536;&#2534;&#2535;&#2540; &#2447;&#2480; &#2474;&#2509;&#2480;&#2453;&#2509;&#2487;&#2495;&#2468;&#2503; &#2470;&#2480;&#2474;&#2468;&#2509;&#2480;&#2503; &#2437;&#2434;&#2486; &#2455;&#2509;&#2480;&#2489;&#2467;&#2503; &#2437;&#2479;&#2507;&#2455;&#2509;&#2479; (Debar) &#2476;&#2482;&#2503; &#2456;&#2507;&#2487;&#2472;&#2494; &#2453;&#2480;&#2494; &#2489;&#2527;&#2404;', '2016-01-31 14:49:25', '2016-01-31 14:51:24', 19, 19, 'admin/docs/office_order/moc_352968f278c68327bf53e1de4c953337.pdf', 0, 'Active', ''),
(17, '&#2478;&#2503;&#2488;&#2494;&#2480;&#2509;&#2488; &#2468;&#2494;&#2488;&#2472;&#2495;&#2527;&#2494; &#2453;&#2472;&#2509;&#2488;&#2463;&#2509;&#2480;&#2494;&#2453;&#2486;&#2472; &#2447;&#2480; &#2488;&#2509;&#2476;&#2468;&#2509;&#2468;&#2509;&#2476;&#2494;&#2471;&#2495;&#2453;&#2494;&#2480;&#2496; &#2478;&#2507;&#2460;&#2494;&#2478;&#2509;&#2478;&#2503;&#2482; &#2489;&#2507;&#2488;&#2503;&#2472; &#2472;&#2494;&#2472;&#2509;&#2463;&#2497;', '2016-01-12', '2099-01-01', 'x', '&#2536;&#2539; &#2438;&#2482;&#2488;&#2494;&#2475;&#2494; &#2438;/&#2447;, &#2474;&#2494;&#2464;&#2494;&#2472;&#2463;&#2497;&#2482;&#2494;, &#2488;&#2495;&#2482;&#2503;&#2463;', '&#2488;&#2524;&#2453; &#2451; &#2460;&#2472;&#2474;&#2469; &#2437;&#2471;&#2495;&#2470;&#2474;&#2509;&#2468;&#2480;&#2503;&#2480; &#2488;&#2495;&#2482;&#2503;&#2463; &#2488;&#2524;&#2453; &#2488;&#2494;&#2480;&#2509;&#2453;&#2503;&#2482; &#2451; &#2441;&#2489;&#2494;&#2480; &#2437;&#2471;&#2496;&#2472; &#2488;&#2453;&#2482; &#2453;&#2509;&#2480;&#2527;&#2453;&#2494;&#2480;&#2496;&#2480; &#2470;&#2474;&#2509;&#2468;&#2480;&#2503; &#2479;&#2503; &#2453;&#2507;&#2472; &#2470;&#2480;&#2474;&#2468;&#2509;&#2480;&#2503; &#2437;&#2434;&#2486; &#2455;&#2509;&#2480;&#2489;&#2467;&#2503; &#2437;&#2479;&#2507;&#2455;&#2509;&#2479; (Debar) &#2476;&#2482;&#2503; &#2456;&#2507;&#2487;&#2472;&#2494;&#2404;', 'Roads and Highways Department', '2016-01-12', 'Memo No. 2-12/203, Date 12-01-2016', '&#2488;&#2495;&#2482;&#2503;&#2463; &#2441;&#2474;-&#2476;&#2495;&#2477;&#2494;&#2455;&#2496;&#2527; &#2474;&#2509;&#2480;&#2453;&#2508;&#2486;&#2482;&#2496;, &#2488;&#2524;&#2453; &#2441;&#2474;-&#2476;&#2495;&#2477;&#2494;&#2455;, &#2488;&#2495;&#2482;&#2503;&#2463;&#2453;&#2503; &#2455;&#2494;&#2482;&#2495;&#2455;&#2494;&#2482;&#2494;&#2460; &#2488;&#2489; &#2486;&#2494;&#2480;&#2495;&#2480;&#2496;&#2453;&#2477;&#2494;&#2476;&#2503; &#2482;&#2494;&#2462;&#2509;&#2458;&#2495;&#2468; &#2453;&#2480;&#2503;&#2472; &#2479;&#2494;, PPR-2008 &#2447;&#2480; &#2476;&#2495;&#2471;&#2495; &#2535;&#2536;&#2541;(&#2536;)(&#2456;) &#2437;&#2472;&#2497;&#2479;&#2494;&#2527;&#2496; \\"&#2460;&#2476;&#2480;&#2470;&#2488;&#2509;&#2468;&#2495;&#2478;&#2498;&#2482;&#2453; &#2453;&#2494;&#2480;&#2509;&#2479;\\" &#2447;&#2480; &#2437;&#2472;&#2509;&#2468;&#2480;&#2509;&#2477;&#2497;&#2453;&#2509;&#2468; &#2479;&#2494; &#2474;&#2503;&#2486;&#2494;&#2455;&#2468; &#2437;&#2488;&#2470;&#2494;&#2458;&#2480;&#2467; &#2451; &#2437;&#2474;&#2480;&#2494;&#2471; &#2489;&#2495;&#2488;&#2503;&#2476;&#2503; &#2455;&#2472;&#2509;&#2479; &#2489;&#2451;&#2527;&#2494;&#2527; &#2488;&#2524;&#2453; &#2474;&#2480;&#2495;&#2476;&#2489;&#2472; &#2451; &#2478;&#2489;&#2494;&#2488;&#2524;&#2453; &#2476;&#2495;&#2477;&#2494;&#2455; &#2447;&#2480; &#2488;&#2509;&#2478;&#2494;&#2480;&#2453; &#2472;&#2434;-&#2537;&#2539;.&#2534;&#2534;.&#2534;&#2534;&#2534;&#2534;.&#2534;&#2535;&#2539;.&#2534;&#2541;.&#2534;&#2536;&#2543;.&#2535;&#2539;-&#2535;&#2541; &#2468;&#2494;&#2434; &#2534;&#2541;-&#2534;&#2535;-&#2536;&#2534;&#2535;&#2540; &#2447;&#2480; &#2488;&#2470;&#2527; &#2472;&#2495;&#2480;&#2509;&#2470;&#2503;&#2486;&#2472;&#2494;&#2480; &#2474;&#2509;&#2480;&#2503;&#2453;&#2509;&#2487;&#2495;&#2468;&#2503; &#2470;&#2480;&#2474;&#2468;&#2509;&#2480;&#2503; &#2438;&#2434;&#2486; &#2455;&#2509;&#2480;&#2489;&#2467;&#2503; &#2438;&#2479;&#2507;&#2455;&#2509;&#2479; (Debar) &#2476;&#2482;&#2503; &#2456;&#2507;&#2487;&#2472;&#2494; &#2453;&#2480;&#2494; &#2489;&#2527;&#2404;', '2016-01-31 16:28:31', '0000-00-00 00:00:00', 19, 0, 'admin/docs/office_order/moc_5d6f538088323e14bbb90f0f60021895.pdf', 0, 'Active', ''),
(18, '&#2478;&#2503;&#2488;&#2494;&#2480;&#2509;&#2488; &#2438;&#2453;&#2476;&#2480; &#2489;&#2507;&#2488;&#2503;&#2472; &#2488;&#2509;&#2476;&#2468;&#2509;&#2468;&#2509;&#2476;&#2494;&#2471;&#2495;&#2453;&#2494;&#2480;&#2496; &#2478;&#2507;&#2435; &#2438;&#2482;&#2496; &#2438;&#2453;&#2476;&#2480;', '2016-01-12', '2099-01-01', 'Tender ID No. 33237, Contract No. e-GP/16(Sixteen)/SE/SRC/2015-2016', '&#2488;&#2509;&#2476;&#2480;&#2509;&#2467;&#2486;&#2495;&#2454;&#2494;-&#2535;&#2540;&#2534;, &#2453;&#2470;&#2478;&#2468;&#2482;&#2496;, &#2488;&#2495;&#2482;&#2503;&#2463;', '&#2488;&#2524;&#2453; &#2451; &#2460;&#2472;&#2474;&#2469; &#2437;&#2471;&#2495;&#2470;&#2474;&#2509;&#2468;&#2480;&#2503;&#2480; &#2488;&#2495;&#2482;&#2503;&#2463; &#2488;&#2524;&#2453; &#2488;&#2494;&#2480;&#2509;&#2453;&#2503;&#2482; &#2451; &#2441;&#2489;&#2494;&#2480; &#2437;&#2471;&#2496;&#2472; &#2488;&#2453;&#2482; &#2453;&#2509;&#2480;&#2527;&#2453;&#2494;&#2480;&#2496;&#2480; &#2470;&#2474;&#2509;&#2468;&#2480;&#2503; &#2479;&#2503; &#2453;&#2507;&#2472; &#2470;&#2480;&#2474;&#2468;&#2509;&#2480;&#2503; &#2437;&#2434;&#2486; &#2455;&#2509;&#2480;&#2489;&#2467;&#2503; &#2437;&#2479;&#2507;&#2455;&#2509;&#2479; (Debar) &#2476;&#2482;&#2503; &#2456;&#2507;&#2487;&#2472;&#2494;&#2404;', 'Roads and Highways Department', '2016-01-12', 'Memo No. 2-12/202', '&#2441;&#2474;-&#2476;&#2495;&#2477;&#2494;&#2455;&#2496;&#2527; &#2474;&#2509;&#2480;&#2453;&#2508;&#2486;&#2482;&#2496;, &#2488;&#2451;&#2460;, &#2488;&#2524;&#2453; &#2441;&#2474;-&#2476;&#2495;&#2477;&#2494;&#2455;, &#2488;&#2495;&#2482;&#2503;&#2463;&#2453;&#2503; &#2455;&#2494;&#2482;&#2496;&#2455;&#2494;&#2482;&#2494;&#2460; &#2488;&#2489; &#2486;&#2494;&#2480;&#2495;&#2480;&#2496;&#2453;&#2477;&#2494;&#2476;&#2503; &#2482;&#2494;&#2462;&#2509;&#2458;&#2495;&#2468; &#2453;&#2480;&#2503;&#2472;&#2404; &#2441;&#2453;&#2509;&#2468; &#2453;&#2494;&#2480;&#2509;&#2479;&#2453;&#2482;&#2494;&#2474; PPR-2008 &#2447;&#2480; &#2476;&#2495;&#2471;&#2495; &#2535;&#2536;&#2541;(&#2536;)(&#2454;) &#2447;&#2476;&#2434; &#2458;&#2497;&#2453;&#2509;&#2468;&#2495;&#2480; GCC Clause 2.2 &#2437;&#2472;&#2497;&#2479;&#2494;&#2527;&#2496; \\"&#2460;&#2476;&#2480;&#2470;&#2488;&#2509;&#2468;&#2495;&#2478;&#2498;&#2482;&#2453; &#2453;&#2494;&#2480;&#2509;&#2479;\\" &#2447;&#2480; &#2437;&#2472;&#2509;&#2468;&#2480;&#2509;&#2477;&#2497;&#2453;&#2509;&#2468; &#2479;&#2494; &#2474;&#2503;&#2486;&#2494;&#2455;&#2468; &#2437;&#2488;&#2470;&#2494;&#2458;&#2480;&#2467; &#2451; &#2437;&#2474;&#2480;&#2494;&#2471; &#2489;&#2495;&#2488;&#2503;&#2476;&#2503; &#2455;&#2472;&#2509;&#2479; &#2489;&#2451;&#2527;&#2494;&#2527; &#2488;&#2524;&#2453; &#2474;&#2480;&#2495;&#2476;&#2489;&#2472; &#2451; &#2478;&#2489;&#2494;&#2488;&#2524;&#2453; &#2476;&#2495;&#2477;&#2494;&#2455; &#2447;&#2480; &#2488;&#2509;&#2478;&#2494;&#2480;&#2453; &#2472;&#2434;-&#2537;&#2539;.&#2534;&#2534;.&#2534;&#2534;&#2534;&#2534;.&#2534;&#2535;&#2539;.&#2534;&#2541;.&#2534;&#2536;&#2543;.&#2535;&#2539;-&#2535;&#2541; &#2468;&#2494;&#2434; &#2534;&#2541;-&#2534;&#2535;-&#2536;&#2534;&#2535;&#2540; &#2454;&#2509;&#2480;&#2495;&#2487;&#2509;&#2463;&#2494;&#2476;&#2509;&#2470; &#2447;&#2480; &#2488;&#2470;&#2527; &#2472;&#2495;&#2480;&#2509;&#2470;&#2503;&#2486;&#2472;&#2494;&#2480; &#2474;&#2509;&#2480;&#2503;&#2453;&#2509;&#2487;&#2495;&#2468;&#2503; &#2488;&#2495;&#2482;&#2503;&#2463; &#2488;&#2524;&#2453; &#2488;&#2494;&#2480;&#2509;&#2453;&#2503;&#2482; &#2451; &#2441;&#2489;&#2494;&#2480; &#2437;&#2471;&#2496;&#2472; &#2488;&#2453;&#2482; &#2453;&#2509;&#2480;&#2527;&#2453;&#2494;&#2480;&#2496; &#2470;&#2474;&#2509;&#2468;&#2480;&#2503;&#2480; &#2479;&#2503; &#2453;&#2507;&#2472; &#2470;&#2480;&#2474;&#2468;&#2509;&#2480;&#2503; &#2438;&#2434;&#2486; &#2455;&#2509;&#2480;&#2489;&#2467;&#2503; &#2437;&#2479;&#2507;&#2455;&#2509;&#2479; (Debar) &#2476;&#2482;&#2503; &#2456;&#2507;&#2487;&#2472;&#2494; &#2453;&#2480;&#2494; &#2489;&#2527;&#2404;', '2016-02-01 09:08:19', '0000-00-00 00:00:00', 19, 0, 'admin/docs/office_order/moc_bbda331577c51a7e993ada62bc4730e0.pdf', 0, 'Active', '');

-- --------------------------------------------------------

--
-- Table structure for table `rate_details`
--

CREATE TABLE IF NOT EXISTS `rate_details` (
  `rate_id` int(4) NOT NULL AUTO_INCREMENT,
  `tenderer_id` int(4) NOT NULL,
  `service_id` int(4) NOT NULL,
  `service_rate` decimal(10,2) NOT NULL,
  PRIMARY KEY (`rate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `service_info`
--

CREATE TABLE IF NOT EXISTS `service_info` (
  `service_id` int(4) NOT NULL AUTO_INCREMENT,
  `service_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `service_details` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('Active','Inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`service_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;

--
-- Dumping data for table `service_info`
--

INSERT INTO `service_info` (`service_id`, `service_name`, `service_details`, `status`) VALUES
(1, 'Pending', 'Pending', 'Active'),
(2, 'Accepted', 'Accepted', 'Active'),
(3, 'Processed in File', 'Processed in File', 'Active'),
(4, 'Processed in E-GP', 'Processed in E-GP', 'Active'),
(5, 'Re-tender', 'Re-tender', 'Active'),
(6, 'Re-evaluation', 'Re-evaluation', 'Active'),
(8, 'Approved in E-GP', 'Approved in E-GP', 'Active');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_financial_year`
--

CREATE TABLE IF NOT EXISTS `tbl_financial_year` (
  `f_year_id` int(4) NOT NULL AUTO_INCREMENT,
  `f_year` varchar(15) NOT NULL,
  PRIMARY KEY (`f_year_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tbl_financial_year`
--

INSERT INTO `tbl_financial_year` (`f_year_id`, `f_year`) VALUES
(1, '2015-2016'),
(2, '2016-2017'),
(3, '2017-2018'),
(4, '2018-2019');

-- --------------------------------------------------------

--
-- Table structure for table `tender_documents`
--

CREATE TABLE IF NOT EXISTS `tender_documents` (
  `document_id` int(6) NOT NULL AUTO_INCREMENT,
  `document_name` text CHARACTER SET utf8 NOT NULL,
  `document_path` text CHARACTER SET utf8 NOT NULL,
  `uploader_id` int(4) NOT NULL,
  `date_time` datetime NOT NULL,
  `tender_id` int(5) NOT NULL,
  `doc_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`document_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

--
-- Dumping data for table `tender_documents`
--

INSERT INTO `tender_documents` (`document_id`, `document_name`, `document_path`, `uploader_id`, `date_time`, `tender_id`, `doc_status`) VALUES
(3, '', 'egp_fccb6e27f9ebee75ce31261316b490d1.pdf', 3, '2017-08-02 12:01:50', 19, 'Active'),
(4, '', 'egp_16009d221ed7d6003b39c1b2ee9d6029.pdf', 3, '2017-08-02 12:30:43', 20, 'Active'),
(5, '', 'egp_f220b035dbe982c3fa5a3f430cddc401.pdf', 3, '2017-08-02 12:38:46', 22, 'Active'),
(6, '', 'egp_fee538bf7549baf6236acbd103764ec9.pdf', 3, '2017-08-02 12:39:19', 23, 'Active'),
(7, '', 'egp_3fe12f3b961652f7630ed19546ed006c.pdf', 3, '2017-08-02 12:39:31', 24, 'Active'),
(8, '', 'egp_e70f1c5a6f98a2a719dc4346e066c46b.pdf', 3, '2017-08-02 12:40:11', 25, 'Active'),
(9, '', 'egp_7a3f410d922a45405cd652353bd55912.pdf', 3, '2017-08-02 12:40:14', 26, 'Active'),
(10, '', 'egp_7d904857a19317fb93e55ab113f3c633.pdf', 3, '2017-08-02 12:40:34', 27, 'Active'),
(11, '', 'egp_0dec7f7bc210e7cf3d4d8acdc7c3cbed.pdf', 3, '2017-08-08 09:22:46', 28, 'Active'),
(12, 'Test 2', 'egp_7a5d9ca9f9eda8534946f6232d237f8b.pdf', 3, '2017-08-08 09:31:19', 29, 'Active'),
(13, 'Test 2', 'egp_6e3bef0da5c34b44a48d4ecd8f4e4879.pdf', 3, '2017-08-08 09:32:06', 30, 'Active'),
(14, 'Test 1', 'egp_c875c3e6f6f064bc4e9d897fcb04687f.pdf', 3, '2017-08-08 09:32:06', 30, 'Active'),
(15, 'Test 2', 'egp_4ca19615c54263bd53c3a799c23555d0.pdf', 3, '2017-08-17 09:21:45', 31, 'Active'),
(16, 'tender doc', 'egp_b47aea32ba026ff7fc4a9c531e9b7245.pdf', 1, '2017-08-23 11:56:08', 32, 'Active'),
(17, 'evaliation sheet', 'egp_16efebba65d522984dcc5733e01df10e.pdf', 1, '2017-08-23 11:56:08', 32, 'Active'),
(18, 'evaliation sheet', 'egp_bb411291d9b62774bd1f1f7130d66a81.pdf', 1, '2017-08-24 07:30:43', 33, 'Active'),
(19, 'tender doc', 'egp_5f5cafc82493227743d022c6ea2572eb.pdf', 1, '2017-08-24 07:30:43', 33, 'Active'),
(20, 'doc 2', 'egp_f771c9224f32d26e1bd7add9fe16bfd0.pdf', 1, '2017-08-24 08:07:41', 33, 'Active'),
(21, 'doc 2', 'egp_f6af9bde30a3ee06206f47f6b060f3cf.pdf', 1, '2017-08-24 08:07:48', 33, 'Inactive'),
(22, 'doc 2', 'egp_830f4723416424865a3114c0da75da41.pdf', 1, '2017-08-24 08:08:58', 33, 'Inactive'),
(23, 'doc 2', 'egp_4c62fd4c0e52f730b684086265bbaec5.pdf', 1, '2017-08-24 08:10:54', 33, 'Inactive'),
(24, 're tender doc', 'egp_f34b873905cd246fc0c246adef65af8b.pdf', 1, '2017-08-24 08:11:15', 33, 'Inactive'),
(25, 'doc 1', 'egp_5663fc01c00c3c210900b44801c44278.pdf', 1, '2017-08-24 09:06:36', 31, 'Active'),
(26, 'Approval GO', 'egp_8b59e37cc49b47bc3cff53f606643701.pdf', 1, '2017-09-17 09:01:55', 32, 'Active'),
(27, 'Test 2', 'egp_36fe91f161ea0cc1f59ff46406ae558b.pdf', 3, '2017-10-16 12:21:53', 1, 'Inactive'),
(28, 'CE Reconnendation', 'egp_2340f427a5f68bd654b64e48690067b5.pdf', 3, '2017-11-13 08:11:45', 2, 'Active'),
(29, 'TER_BOQ', 'egp_46ac0e1aab20d6b5e2ef5edaf507e371.pdf', 3, '2017-11-13 08:11:45', 2, 'Active'),
(30, 'Tender Documents', 'egp_ef43a0a1ddaaa6bb7e8f80a103b7eb88.pdf', 3, '2017-12-03 11:23:06', 4, 'Inactive'),
(31, 'CE Reconnendation', 'egp_2b3ca0073c5d2c46a322cf7451491273.pdf', 3, '2017-12-03 11:42:13', 0, 'Inactive'),
(32, 'Tender_documents', 'egp_71972ff771fc5798429813678efc032a.pdf', 3, '2017-12-03 11:43:08', 0, 'Inactive'),
(33, 'Tender_documents', 'egp_1532c1bbc041967427c70750d140c472.pdf', 3, '2017-12-03 11:43:22', 0, 'Inactive'),
(34, 'Tender_documents', 'egp_f4bbdad7a2b9e7030349d679c7d53502.pdf', 3, '2017-12-03 11:45:35', 4, 'Inactive'),
(35, 'TER_BOQ', 'egp_a05c5d9b6360007856535f59bbbf1559.pdf', 3, '2017-12-03 11:45:45', 4, 'Active');

-- --------------------------------------------------------

--
-- Table structure for table `tender_info`
--

CREATE TABLE IF NOT EXISTS `tender_info` (
  `tender_id` int(8) NOT NULL AUTO_INCREMENT,
  `tender_egp_id` int(8) NOT NULL,
  `office_id` int(4) NOT NULL,
  `tenderer_id` int(4) NOT NULL,
  `division_id` int(4) NOT NULL,
  `service_id` int(3) NOT NULL,
  `opening_date` date NOT NULL,
  `add_date` datetime NOT NULL,
  `tender_details` text COLLATE utf8_unicode_ci NOT NULL,
  `cost_estimation` decimal(14,3) NOT NULL,
  `status` enum('live','archive','cancel','inactive','pending') COLLATE utf8_unicode_ci NOT NULL,
  `branch_id` int(3) NOT NULL,
  `budget_id` int(3) NOT NULL,
  `f_year_id` int(3) NOT NULL,
  `user_id` int(5) NOT NULL,
  `package` varchar(100) CHARACTER SET utf8 NOT NULL,
  `w_type` int(4) NOT NULL,
  PRIMARY KEY (`tender_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tender_info`
--

INSERT INTO `tender_info` (`tender_id`, `tender_egp_id`, `office_id`, `tenderer_id`, `division_id`, `service_id`, `opening_date`, `add_date`, `tender_details`, `cost_estimation`, `status`, `branch_id`, `budget_id`, `f_year_id`, `user_id`, `package`, `w_type`) VALUES
(4, 122571, 10, 0, 47, 6, '0000-00-00', '2017-12-04 09:49:47', 'test data 22', 0.000, 'live', 1, 1, 1, 3, '2334', 2),
(5, 12345, 6, 0, 38, 1, '0000-00-00', '2017-12-04 09:43:40', '', 0.000, 'live', 2, -1, -1, 3, '', -1);

-- --------------------------------------------------------

--
-- Table structure for table `tenderer_info`
--

CREATE TABLE IF NOT EXISTS `tenderer_info` (
  `tenderer_id` int(4) NOT NULL AUTO_INCREMENT,
  `tenderer_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `tenderer_details` text COLLATE utf8_unicode_ci NOT NULL,
  `phone_number` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`tenderer_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tenderer_info`
--

INSERT INTO `tenderer_info` (`tenderer_id`, `tenderer_name`, `tenderer_details`, `phone_number`, `email`) VALUES
(1, 'Road Construction', '', '', ''),
(2, 'Bridge/Culvert Construction', '', '', ''),
(3, 'Evaluation Commettee Approval', '', '', '');

