-- Table structure for table `TECH_BOULEVARDevents`
--

CREATE TABLE `TECH_BOULEVARDevents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `location` mediumtext COLLATE utf8_unicode_ci,
  `files` mediumtext COLLATE utf8_unicode_ci,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci NOT NULL,
  `share_with` mediumtext COLLATE utf8_unicode_ci,
  `editable_google_event` tinyint(1) NOT NULL DEFAULT '0',
  `google_event_id` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  `color` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `recurring` int(1) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `last_start_date` date DEFAULT NULL,
  `recurring_dates` longtext COLLATE utf8_unicode_ci NOT NULL,
  `confirmed_by` text COLLATE utf8_unicode_ci NOT NULL,
  `rejected_by` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDevents`
--


--
-- Table structure for table `TECH_BOULEVARDexpense_categories`
--

CREATE TABLE `TECH_BOULEVARDexpense_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDexpense_categories`
--


--
-- Table structure for table `TECH_BOULEVARDexpenses`
--

CREATE TABLE `TECH_BOULEVARDexpenses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `expense_date` date NOT NULL,
  `category_id` int(11) NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `amount` double NOT NULL,
  `payment_mode` enum('bank','cash_on_hand','cheque','reimbursement','pt_cash') COLLATE utf8_unicode_ci NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` int(11) DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `client_id` int(11) NOT NULL DEFAULT '0',
  `status` enum('draft','request_approval','approved','rejected') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `transaction_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDexpenses`
--


--
-- Table structure for table `TECH_BOULEVARDgeneral_files`
--

CREATE TABLE `TECH_BOULEVARDgeneral_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` text COLLATE utf8_unicode_ci NOT NULL,
  `file_id` text COLLATE utf8_unicode_ci,
  `service_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `file_size` double NOT NULL,
  `created_at` datetime NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `eroom_id` int(11) NOT NULL DEFAULT '0',
  `uploaded_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDgeneral_files`
--


--
-- Table structure for table `TECH_BOULEVARDhelp_articles`
--

CREATE TABLE `TECH_BOULEVARDhelp_articles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `category_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `files` text COLLATE utf8_unicode_ci NOT NULL,
  `total_views` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDhelp_articles`
--


--
-- Table structure for table `TECH_BOULEVARDhelp_categories`
--

CREATE TABLE `TECH_BOULEVARDhelp_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `type` enum('help','knowledge_base') COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDhelp_categories`
--


--
-- Table structure for table `TECH_BOULEVARDinternal_transactions`
--

CREATE TABLE `TECH_BOULEVARDinternal_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `from_employee` int(11) NOT NULL,
  `to_employee` int(11) NOT NULL,
  `amount` float(10,3) NOT NULL,
  `note` text COLLATE utf8_bin NOT NULL,
  `status` enum('draft','approved') COLLATE utf8_bin NOT NULL DEFAULT 'draft',
  `transaction_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `TECH_BOULEVARDinternal_transactions`
--


--
-- Table structure for table `TECH_BOULEVARDinvoice_items`
--

CREATE TABLE `TECH_BOULEVARDinvoice_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `cost` double DEFAULT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `invoice_id` int(11) NOT NULL,
  `tax_id` int(11) DEFAULT '0',
  `tax_id2` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=672 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDinvoice_items`
--

INSERT INTO `TECH_BOULEVARDinvoice_items` VALUES (1,34,'TL-EAP650','ACCESS POINT',22,'',66,NULL,1452,0,2022300,0,0,0),(2,35,'TL-SG1210P POE SWITCH 8 PORTS','',22,'',28,NULL,616,0,2022300,0,0,0),(3,36,'HIKVISION CAT6 Roll 300 MTR','',4,'',45,NULL,180,0,2022300,0,0,0),(4,37,'RJ-45 connectors','',1,'',10,NULL,10,0,2022300,0,0,0),(5,39,'RJ-45 Cable Teaster','',1,'',6,NULL,6,0,2022300,0,0,0),(6,38,'CRIMPING TOOL','',1,'',6,NULL,6,0,2022300,0,0,0),(7,40,'TL-OC200 OMADO CLOUD CONTROLLER','',1,'',40,NULL,40,0,2022300,0,0,0),(8,34,'TL-EAP650','ACCESS POINT',22,'',66,NULL,1452,0,2022301,0,0,0),(9,35,'TL-SG1210P POE SWITCH 8 PORTS','',22,'',28,NULL,616,1,2022301,0,0,0),(10,36,'HIKVISION CAT6 Roll 300 MTR','',4,'',45,NULL,180,3,2022301,0,0,0),(11,37,'RJ-45 connectors','',1,'',10,NULL,10,4,2022301,0,0,0),(12,39,'RJ-45 Cable Teaster','',1,'',6,NULL,6,5,2022301,0,0,0),(13,38,'CRIMPING TOOL','',1,'',6,NULL,6,6,2022301,0,0,0),(14,40,'TL-OC200 OMADO CLOUD CONTROLLER','',1,'',40,NULL,40,2,2022301,0,0,0),(15,34,'TL-EAP650','ACCESS POINT',22,'',66,NULL,1452,0,2022302,1,0,0),(16,35,'TL-SG1210P POE SWITCH 8 PORTS','',22,'',28,NULL,616,0,2022302,1,0,0),(17,36,'HIKVISION CAT6 Roll 300 MTR','',4,'',45,NULL,180,0,2022302,1,0,0),(18,37,'RJ-45 connectors','',1,'',10,NULL,10,0,2022302,1,0,0),(19,39,'RJ-45 Cable Teaster','',1,'',6,NULL,6,0,2022302,1,0,0),(20,38,'CRIMPING TOOL','',1,'',6,NULL,6,0,2022302,1,0,0),(21,40,'TL-OC200 OMADO CLOUD CONTROLLER','',1,'',40,NULL,40,0,2022302,1,0,0),(22,23,'NEC TELEPHONEY SYSTEM PACKAGE','TELEPHONEY SYSTEM Package\nSystem with (308 card)\n5 digital phones\nUnloaded Patch Panel\nInstalltion and programming',1,'',280,NULL,280,0,2022303,1,0,0),(23,24,'ANALOGE PHONE','',3,'',12.5,NULL,37.5,0,2022303,1,0,0),(24,29,'RJ45 Module keystone cat6','',22,'',1.3,NULL,28.6,0,2022303,1,0,0),(25,30,'RJ45 phase plate Dual','',10,'',2.9,NULL,29,0,2022303,1,0,0),(26,32,'CABLING','CABLE BULLING with termination\n8* cat 6\ntotal metres 160 Meter',8,'',3.8,NULL,30.4,0,2022303,1,0,0),(27,33,'PIPE','OUTDOOR PIPE',20,'Meter',0.75,NULL,15,0,2022303,1,0,0),(28,31,'PDU 6 WAY','POWER expansion for cabinet',1,'',9,NULL,9,0,2022303,1,0,0),(29,41,'TL-EAP225','',1,'',39,NULL,39,0,2022304,1,0,0),(30,42,'FIXING & Programming','',1,'',10,NULL,10,0,2022304,1,0,0),(31,43,'FIBER PATCH CORD 20 MTR','',1,'',10,NULL,10,0,2022305,1,0,0),(32,42,'FIXING & Programming','',1,'',10,NULL,10,0,2022305,1,0,0),(33,43,'FIBER PATCH CORD 20 MTR','',1,'',10,NULL,10,0,2022306,1,0,0),(34,42,'FIXING & Programming','',1,'',10,NULL,10,0,2022306,1,0,0),(35,41,'TL-EAP225','',1,'',39,NULL,39,0,2022307,1,0,0),(36,42,'FIXING & Programming','',1,'',10,NULL,10,0,2022307,1,0,0),(37,34,'TL-EAP650','ACCESS POINT',22,'',66,NULL,1452,0,2022308,1,0,0),(38,35,'TL-SG1210P POE SWITCH 8 PORTS','',22,'',28,NULL,616,1,2022308,1,0,0),(39,36,'HIKVISION CAT6 Roll 300 MTR','',2,'',45,NULL,90,3,2022308,1,0,0),(40,37,'RJ-45 connectors','',1,'',10,NULL,10,5,2022308,1,0,0),(41,39,'RJ-45 Cable Teaster','',1,'',6,NULL,6,6,2022308,1,0,0),(42,38,'CRIMPING TOOL','',1,'',6,NULL,6,7,2022308,1,0,0),(43,40,'TL-OC200 OMADO CLOUD CONTROLLER','',1,'',40,NULL,40,2,2022308,1,0,0),(44,44,'schneider cat 6 Roll','',2,'',54.5,NULL,109,4,2022308,1,0,0),(45,34,'TL-EAP650','ACCESS POINT',9,'',74,NULL,666,0,2022309,1,0,0),(46,35,'TL-SG1210P POE SWITCH 8 PORTS','',1,'',35,NULL,35,0,2022309,1,0,0),(47,32,'CABLING','CABLE BULLING',1,'',120,NULL,120,0,2022309,1,0,0),(48,44,'schneider cat 6 Roll','',1,'',48,NULL,48,0,2022310,1,0,0),(49,88,'CAT6 to HDMI ADAPTER WITH MOUSE','',1,'',22,NULL,22,1,2022310,1,0,0),(50,30,'RJ45 phase plate Dual','WITH 8 RJ45 Module Keystone Cat6',4,'',3,NULL,12,2,2022310,1,0,0),(51,32,'CABLING','8 CABLES TERMINATION',1,'',15,NULL,15,3,2022310,1,0,0),(52,31,'PDU 6 WAY 13A','',1,'',5,NULL,5,4,2022310,1,0,0),(53,93,'TP-link EAP225- OUTDOOR','',1,'',43,NULL,43,0,2022311,1,0,0),(54,95,'42u Cabinnet 1000x600','with fan and 6way pdu',1,'',235,NULL,235,0,2022312,1,0,0),(55,94,'TL-SG2210P','Managed Switch 8 POE+  Giga ports',1,'',45,NULL,45,2,2022312,1,0,0),(56,96,'2u Shelf 750 heavy duty','',1,'',13,NULL,13,1,2022312,1,0,0),(57,97,'MOUSE PAD GEL','',23,'',1.2,NULL,27.6,0,2022313,0,0,0),(58,98,'USB PRINTER CABLE 5 MTR','',2,'',1.2,NULL,2.4,0,2022313,0,0,0),(59,99,'HDMI CABLE 5 MTR','',1,'',3,NULL,3,0,2022313,0,0,0),(60,100,'DP TO HDMI CABLE 3 MTR','',2,'',4,NULL,8,0,2022313,0,0,0),(61,101,'DP TO VGA ADAPTER','',1,'',4,NULL,4,0,2022313,0,0,0),(62,102,'SANDISK 64GB FLASH DRIVE','',4,'',3.5,NULL,14,0,2022313,0,0,0),(63,103,'2SIDE FLASH DRIE 16GB','',3,'',2.5,NULL,7.5,0,2022313,0,0,0),(64,50,'HIKVISION DS-7608NI-K1/8P','8 Chanel Nvr with Built in poe switch',1,'',52,NULL,52,0,2022314,1,0,0),(65,42,'FIXING & Programming','6 Camera cabling\nOriginal schneider cat 6 cable Included',1,'',110,NULL,110,0,2022314,1,0,0),(66,75,'4 TB HDD PURPPLUE','',1,'',40.5,NULL,40.5,0,2022314,1,0,0),(67,104,'DS-2CD1343GO-IUF 4MP INDOOR CAM WITH AUDIO','',6,'',32,NULL,192,0,2022314,1,0,0),(68,26,'6u CABINET','كبينه محول كهرباء',1,'',37,NULL,37,10,2022315,1,0,0),(69,71,'POWER SUPPLY DB 12V 10A 9 CHANEL','محول كهرباء للكاميرات',1,'',10,NULL,10,5,2022315,1,0,0),(70,88,'CAT6 to HDMI ADAPTER WITH MOUSE','جهاز نقل الصورة من جهاز التسجيل الى الشاشه',1,'',23,NULL,23,6,2022315,1,0,0),(71,49,'2 TB HDD WD PURPLE','هارديسك',1,'',23,NULL,23,1,2022315,1,0,0),(72,124,'DS-2CE12KF0T-FS 2.8MM 5MP COLORVU ANALOGE OUTDOOR CAMERA WITH MIC Metal 40 mtr','كاميرا خارجية تصوير ليلي',1,'',15,NULL,15,2,2022315,1,0,0),(73,122,'DS-2CE76H0T-ITPFS 2.8 5MP INDOOR ANALOGE CAMERA WITH MIC','كاميرات داخلية وضوح 5 ام بي',2,'',12,NULL,24,3,2022315,1,0,0),(74,32,'CABLING','كيبل 3 كاميرات + كيبل للشاشة\nبيب ابيض خارجي للغرف الخلفية\nتركيب وتثبيت 3 كاميرات \nستاند لكاميرة المواقف الامامية\nوصلات',1,'',65,NULL,65,8,2022315,1,0,0),(75,100,'HDMI CABLE','',2,'',4,NULL,8,9,2022315,1,0,0),(76,32,'CABLING','اضافة كيبل جديد مع الترنك',1,'',10,NULL,10,7,2022315,1,0,0),(77,67,'IDS-7208HUHI-MI 8 chanel DVR','8 chanel DVR, SUPPORT til (1- 8MP)',1,'',57,NULL,57,0,2022315,1,0,0),(78,125,'DS-2CE70KF0T-PFS ANALOGE INDOOR CAMERA 4MP COLOR','كاميرات داخلية وضوح 4 ام بي\nتصوير ليلي',1,'',13,NULL,13,4,2022315,1,0,0),(79,32,'CABLING','CABLE BULLING',1,'',105,NULL,105,0,2022316,1,0,0),(80,34,'TL-EAP650','ACCESS POINT',6,'',66,NULL,396,0,2022316,1,0,0),(81,40,'TL-OC200 OMADO CLOUD CONTROLLER','',1,'',40,NULL,40,0,2022316,1,0,0),(82,35,'TL-SG1210P POE SWITCH 8 PORTS','',3,'',33,NULL,99,0,2022316,1,0,0),(83,47,'NVR DS-7608-Q1/8p','NVR 8 channel with 8 POE switch\nجهاز تسجيل كاميرات المراقبة',1,'',53,NULL,53,0,2022317,1,0,0),(84,49,'2 TB HDD WD PURPLE','هاردسك سعة 2 تيرا',1,'',23,NULL,23,0,2022317,1,0,0),(85,82,'DS-2CD2047G2-L COLOR CAM 4MP','4 MP ColorVu Fixed Mini Bullet Network Camera\nكاميرات تصوير ليلي وضوح 4 ام بي',2,'',38,NULL,76,0,2022317,1,0,0),(86,131,'4u cabinet 530*350','كبينة',1,'',15.5,NULL,15.5,0,2022317,1,0,0),(87,31,'PDU 6 WAY 13A','محول كهرباء للكبينة',1,'',7,NULL,7,0,2022317,1,0,0),(88,132,'TL-EAP610','Access Point AX1800- Wifi6 ',2,'',39,NULL,78,0,2022317,1,0,0),(89,35,'TL-SG1210P POE SWITCH 8 PORTS','سويتش 8 منافذ جيجا بورت بخاصية POE',2,'',28,NULL,56,0,2022317,1,0,0),(90,32,'CABLING','CABLE BULLING',1,'',30,NULL,30,0,2022317,1,0,0),(91,42,'FIXING & Programming','',1,'',0,NULL,0,0,2022317,1,0,0),(92,31,'PDU 6 WAY 13A','',1,'',12,NULL,12,0,2022318,1,0,0),(93,52,'27u Wheels Cabinet 600 x 600','',1,'',169,NULL,169,0,2022319,1,0,0),(94,27,'Unloaded PATCH PANNEL 24 port','',6,'',12,NULL,72,0,2022319,1,0,0),(95,53,'RJ45 Module Keystone Cat6 Press','',94,'',2.9,NULL,272.6,0,2022319,1,0,0),(96,54,'1u Brush','',5,'',3.4,NULL,17,0,2022319,1,0,0),(97,55,'Shelf 470x300','',4,'',6.2,NULL,24.8,0,2022319,1,0,0),(98,57,'Patchcord cat6 1mtr Grey','',80,'',1,NULL,80,0,2022319,1,0,0),(99,58,'UPS 30 MINUTES','',1,'',43,NULL,43,0,2022319,1,0,0),(100,40,'TL-OC200 OMADO CLOUD CONTROLLER','',1,'',40,NULL,40,0,2022319,1,0,0),(101,34,'TL-EAP650','ACCESS POINT',7,'',74,NULL,518,0,2022319,1,0,0),(102,59,'NVR DS7732NI-k4','32 chanel',1,'',108,NULL,108,0,2022319,1,0,0),(103,6,'DS-2CD1143G0','IP INDOOR CAMERA 4MP',14,'',24,NULL,336,0,2022319,1,0,0),(104,49,'2 TB HDD','',2,'',24,NULL,48,0,2022319,1,0,0),(105,64,'TL-SG1024D 24 Giga port Switch','24 Giga port Switch',1,'',42,NULL,42,0,2022319,1,0,0),(106,63,'Hikvision DS-3E0526P E/m 24 Giga Port POE Switch','24 Giga Port POE Switch',1,'',112,NULL,112,0,2022319,1,0,0),(107,62,'NEC DIGITAL Phone 24 button ','',2,'',24,NULL,48,0,2022319,1,0,0),(108,24,'ANALOGE PHONE','',22,'',13.2,NULL,290.4,0,2022319,1,0,0),(109,32,'CABLING','CABINET CABLE TERMINATIONS ',1,'',135,NULL,135,0,2022319,1,0,0),(110,42,'FIXING & Programming','NVR CCTV SYSTEM\nNETWORK WIFI SYSTEM\nPBX TELEPHONEY SYSTEM\n',1,'',90,NULL,90,0,2022319,1,0,0),(111,60,'NEC TELEPHONEY SYSTEM','CPU card\n24 Extensions ports\n9 CO LINES\n1 PRI CARD\n4 slots Chassis\n',1,'',440,NULL,440,0,2022319,1,0,0),(112,52,'27u Wheels Cabinet 600 x 600','',1,'',169,NULL,169,5,2022320,1,0,0),(113,27,'Unloaded PATCH PANNEL 24 port','',6,'',12,NULL,72,6,2022320,1,0,0),(114,53,'RJ45 Module Keystone Cat6 Press','',94,'',2.9,NULL,272.6,7,2022320,1,0,0),(115,54,'1u Brush','',4,'',3.4,NULL,13.6,8,2022320,1,0,0),(116,55,'Shelf 470x300','',1,'',6.2,NULL,6.2,9,2022320,1,0,0),(117,57,'Patchcord cat6 1mtr Grey','',25,'',1,NULL,25,10,2022320,1,0,0),(118,40,'TL-OC200 OMADO CLOUD CONTROLLER','',1,'',40,NULL,40,3,2022320,1,0,0),(119,34,'TL-EAP650','ACCESS POINT',7,'',74,NULL,518,4,2022320,1,0,0),(120,59,'NVR DS7732NI-k4','32 chanel',1,'',108,NULL,108,0,2022320,1,0,0),(121,6,'DS-2CD1143G0','IP INDOOR CAMERA 4MP',14,'',24,NULL,336,1,2022320,1,0,0),(122,49,'2 TB HDD','',2,'',24,NULL,48,2,2022320,1,0,0),(123,64,'TL-SG1024D 24 Giga port Switch','24 Giga port Switch',1,'',42,NULL,42,11,2022320,1,0,0),(124,63,'Hikvision DS-3E0526P E/m 24 Giga Port POE Switch','24 Giga Port POE Switch',1,'',112,NULL,112,12,2022320,1,0,0),(125,32,'CABLING','CABINET CABLE TERMINATIONS ',1,'',135,NULL,135,13,2022320,1,0,0),(126,42,'FIXING & Programming','NVR CCTV SYSTEM\nNETWORK WIFI SYSTEM\n\n',1,'',75,NULL,75,14,2022320,1,0,0),(127,150,'Patchcord Cat6 50cm','',25,'',0.8,NULL,20,15,2022320,1,0,0),(128,52,'27u Wheels Cabinet 600 x 600','',1,'',169,NULL,169,7,2022321,1,0,0),(129,27,'Unloaded PATCH PANNEL 24 port','',6,'',12,NULL,72,8,2022321,1,0,0),(130,53,'RJ45 Module Keystone Cat6 Press','',94,'',2.9,NULL,272.6,9,2022321,1,0,0),(131,54,'1u Brush','',4,'',3.4,NULL,13.6,10,2022321,1,0,0),(132,55,'Shelf 470x300','',1,'',6.2,NULL,6.2,11,2022321,1,0,0),(133,57,'Patchcord cat6 1mtr Grey','',25,'',1,NULL,25,12,2022321,1,0,0),(134,40,'TL-OC200 OMADO CLOUD CONTROLLER','',1,'',40,NULL,40,3,2022321,1,0,0),(135,34,'TL-EAP650','ACCESS POINT',7,'',74,NULL,518,6,2022321,1,0,0),(136,59,'NVR DS7732NI-k4','32 chanel',1,'',108,NULL,108,0,2022321,1,0,0),(137,6,'DS-2CD1143G0','IP INDOOR CAMERA 4MP',14,'',24,NULL,336,1,2022321,1,0,0),(138,49,'2 TB HDD','',2,'',24,NULL,48,2,2022321,1,0,0),(139,64,'TL-SG1024D 24 Giga port Switch','24 Giga port Switch',1,'',42,NULL,42,5,2022321,1,0,0),(140,32,'CABLING','CABINET CABLE TERMINATIONS ',1,'',135,NULL,135,14,2022321,1,0,0),(141,42,'FIXING & Programming','NVR CCTV SYSTEM\nNETWORK WIFI SYSTEM\n\n',1,'',75,NULL,75,15,2022321,1,0,0),(142,150,'Patchcord Cat6 50cm','',25,'',0.8,NULL,20,13,2022321,1,0,0),(143,80,'TL- SG2428P','JetStream 28-Port Gigabit Smart Switch with 24-Port PoE+',1,'',112,NULL,112,4,2022321,1,0,0),(144,34,'TL-EAP650','ACCESS POINT',1,'',74,NULL,74,0,2022322,1,0,0),(145,32,'CABLING','CABLING AND FIXING',1,'',35,NULL,35,0,2022322,1,0,0),(146,48,'NVR 7616NI-Q2/16P','جهاز تسجيل كاميرات مراقبة سعة 16 كاميرا\nNVR 16 channel with 16 POE port switch',1,'',74,NULL,74,0,2022323,1,0,0),(147,49,'2 TB HDD WD PURPLE','هاردسك',1,'',23,NULL,23,0,2022323,1,0,0),(148,118,'DS-2CD1043GO-IUF 4MP Network OutdoorCAM WITH AUDIO','كاميرات خارجية وضوح 4mp مع المايك',5,'',32,NULL,160,0,2022323,1,0,0),(149,82,'DS-2CD2047G2-L COLOR CAM 4MP','4 MP ColorVu Fixed Mini Bullet Network Camera\nكاميرات خارجية وضوح 4mp تصوير ليلي  مع المايك',2,'',42,NULL,84,0,2022323,1,0,0),(150,104,'DS-2CD1343GO-IUF 4MP Network INDOOR CAM WITH AUDIO','كاميرات داخلية وضوح 4mp مع المايك',2,'',32,NULL,64,0,2022323,1,0,0),(151,107,'INTERCOM OUTDOOR STATION DS KD8003 IME1','جرس مع كاميرا',1,'',37,NULL,37,0,2022323,1,0,0),(152,108,'INTERCOM SCREEN DSKH630 WTE1','شاشة داخلية للجرس',1,'',37,NULL,37,0,2022323,1,0,0),(153,120,'4 port switch poe','سويتش للانتركوم',1,'',22,NULL,22,0,2022323,1,0,0),(154,93,'TP-link EAP225- OUTDOOR','جهاز بث واي فاي',2,'',40,NULL,80,0,2022323,1,0,0),(155,110,'YALE LOCK','قفل كهربائي',1,'',22,NULL,22,0,2022323,1,0,0),(156,42,'FIXING & Programming','تركيب 9 كاميرات\nتركيب الانتركوم والشاشة الداخليه\n2 مع البوكسات عدد \nمع الستاندات عدد 3\nالوصلات',1,'',110,NULL,110,0,2022323,1,0,0),(157,26,'6u CABINET','كبينة',1,'',40,NULL,40,0,2022323,1,0,0),(158,47,'NVR DS-7608NI-Q1/8p','NVR 8 channel with 8 POE switch with 1 HDD slot',1,'',59,NULL,59,0,2022324,1,0,0),(159,2,'DS-2CD1043G0 Outdoor Network Camera 4mp','كاميرات خارجية وضوح 4 ام بي',5,'',23,NULL,115,0,2022324,1,0,0),(160,82,'DS-2CD2047G2-LU 4 MP ColorVu Fixed outdoor Mini Bullet Network Camera With Mic','4 MP ColorVu Fixed Mini Bullet Network Camera\nكاميرات خارجية تصوير ليلي وضوح 4 ام بي',2,'',35.5,NULL,71,0,2022324,1,0,0),(161,75,'4 TB HDD PURPPLUE','هارديسك سعه 4 تيرا',1,'',40,NULL,40,0,2022324,1,0,0),(162,26,'6u CABINET','كبينه',1,'',38,NULL,38,0,2022324,1,0,0),(163,32,'CABLING','ترنك (البيبات البيضاء لحماية الكيبلات من الشمس)\n+  كيبلات عدد 2 روله كات 6 شنايدر\n+ سحب الكوابل',1,'',165,NULL,165,0,2022324,1,0,0),(164,42,'FIXING & Programming','تثبيت 7 كاميرات\n+ 5 بوكسات واتر بروف\n+ 2 ستاند للكاميرات\n+ وصلات للكيبل\n\n',1,'',75,NULL,75,0,2022324,1,0,0),(165,151,'SCREEN 19 INCH','شاشة لعرض الكاميرات',1,'',25,NULL,25,0,2022324,1,0,0),(166,79,'TL- SG3452P JETSTREAM SWITCH 48 PORT GIGA MANAGED SWITCH','JetStream 52-Port Gigabit L2+ Managed Switch with 48-Port PoE+',1,'',200,NULL,200,0,2022325,1,0,0),(167,34,'TL-EAP650 Ceiling mount','ACCESS POINT',6,'',64,NULL,384,0,2022325,1,0,0),(168,156,'TL-EAP650 wall mount','',1,'',56,NULL,56,0,2022325,1,0,0),(169,93,'TP-link EAP225- OUTDOOR','',1,'',45,NULL,45,0,2022325,1,0,0),(170,40,'TL-OC200 OMADO CLOUD CONTROLLER','',1,'',40,NULL,40,0,2022325,1,0,0),(171,42,'FIXING & Programming','',1,'',0,NULL,0,0,2022325,1,0,0),(172,157,'ZKT Biopro MH40','',1,'',125,NULL,125,0,2022326,1,0,0),(173,60,'NEC TELEPHONEY SYSTEM','CPU card\n24 Extensions ports\n6 CO LINES\n4 slots Chassis\n',1,'',440,NULL,440,0,2022328,1,0,0),(174,62,'NEC DIGITAL Phone 24 button ','',2,'',23.5,NULL,47,1,2022328,1,0,0),(175,159,'GIGASET A270','Cordless phone',10,'',13.5,NULL,135,2,2022328,1,0,0),(176,158,'PANASONIC KXT-7703 analoge phone','Desk analoge phone',6,'',9.5,NULL,57,3,2022328,1,0,0),(177,154,'SCREEN 22 INCH','CCTV MONITOR',1,'',26,NULL,26,4,2022328,1,0,0),(178,160,'BOSCH 6W CELLING SPEAKER','',24,'',9.5,NULL,228,7,2022328,1,0,0),(179,161,'SPEAKER CABLE ROLL 100 MTR','',4,'',12.5,NULL,50,8,2022328,1,0,0),(180,162,'CAT6 CABLE','5 cables for RECEPTION DESK',80,'',0.19,NULL,15.2,9,2022328,1,0,0),(181,163,'CABLE TERMINATION','17 Dual point retermination and testing (VOICE and DATA)',17,'',1.5,NULL,25.5,10,2022328,1,0,0),(182,164,'AMPLIFIER 2 ZONE','6 MONTH WARRANTY',1,'',145,NULL,145,5,2022328,1,0,0),(183,165,'VOLUME CONTROLLER','',21,'',6.5,NULL,136.5,6,2022328,1,0,0),(184,167,'DS-2CD2347G2 LU 2.8 INDOOR 4MP IP CAMERA COLOR WITH MIC','',1,'',36.5,NULL,36.5,11,2022328,1,0,0),(185,30,'RJ45 phase plate Dual','FOR RECEPTION DESK',3,'',3,NULL,9,12,2022328,1,0,0),(186,166,'INTERNET 1 MONTH DATA SUBSCRIPTION','',1,'',25,NULL,25,13,2022328,1,0,0),(187,168,'.','CCTV Troubleshooting\nCCTV SHIFTING\nMounting CCTV SCREEN',1,'',35,NULL,35,0,2022329,1,0,0),(188,168,'.','CCTV Monitor fixing',1,'',28.5,NULL,28.5,0,2022330,0,0,0),(189,169,'Hikvision Door Access control DS-K1T804BMF','',1,'',38.5,NULL,38.5,0,2022332,1,0,0),(190,170,'Hikvision Magnetic Lock DS-K4H258s','',1,'',15.5,NULL,15.5,1,2022332,1,0,0),(191,174,'Lexo No Touch Exit Button ','',1,'',5.5,NULL,5.5,3,2022332,1,0,0),(192,175,'TLSG-1005D 5 Port Giga Switch','',1,'',7.2,NULL,7.2,4,2022332,1,0,0),(193,100,'HDMI CABLE','30 Meter 4K For Training Hall ',1,'',18,NULL,18,5,2022332,1,0,0),(194,168,'.','Fixing Door Access + Magnetic Lock With cabling ',1,'',30,NULL,30,2,2022332,1,0,0),(195,168,'.','Cat6 Cables 20 MTR + Cable Pulling + HDMI Cable Pulling + Trunking',1,'',20,NULL,20,6,2022332,1,0,0),(196,170,'Hikvision Magnetic Lock DS-K4H258s','For Forth Floor',1,'',15.5,NULL,15.5,7,2022332,1,0,0),(197,42,'FIXING & Programming','Fixing Door Access',1,'',15,NULL,15,0,2022333,1,0,0),(198,34,'TL-EAP650 Ceiling mount','ACCESS POINT',1,'',64,NULL,64,0,2022334,1,0,0),(199,42,'FIXING & Programming','',1,'',10,NULL,10,0,2022334,1,0,0),(200,139,'TL-SG1218MPE 16 Giga POE Port EASY SMART Switch ','16× PoE+ gigabit RJ45 ports, 2× gigabit non-PoE RJ45 ports and 2× combo gigabit SFP slots.',1,'',67,NULL,67,0,2022335,0,0,0),(201,128,'IDS-7216HUHM-M2/S 16 CAHNNEL DVR SUPPORT 1-8 MP','',1,'',102,NULL,102,0,2022337,1,0,0),(202,168,'.','',1,'',10,NULL,10,0,2022338,0,0,0),(203,44,'schneider cat 6 Roll','',4,'',42.85,NULL,171.4,0,2022339,1,0,0),(204,34,'TL-EAP650 Ceiling mount','ACCESS POINT',3,'',39.5,NULL,118.5,0,2022340,1,0,0),(205,40,'TL-OC200 OMADO CLOUD CONTROLLER','',1,'',34,NULL,34,0,2022340,1,0,0),(206,44,'schneider cat 6 Roll','',4,'',42.85,NULL,171.4,0,2022341,1,0,0),(207,75,'4 TB HDD PURPPLUE','هاردسك سعة 4 تيرا',1,'',37,NULL,37,0,2022342,1,0,0),(208,130,'POWER SUPPLY DB 12V 10A 16 CHANEL','صندوق كهرباء للكاميرات',1,'',16,NULL,16,0,2022342,1,0,0),(209,42,'FIXING & Programming','تركيب الكاميرات عدد 6',6,'',5,NULL,30,0,2022342,1,0,0),(210,32,'CABLING','أستبدال كيبلات عدد 3 كاميرات\nبيب ترنك ابيض\nوصلات',1,'',40,NULL,40,0,2022342,1,0,0),(211,128,'Hikvision IDS-7216HUHM-M2/S 16 CAHNNEL DVR SUPPORT 1-8 MP','سيرفر تسجيل سعة 16 كاميرا',1,'',97,NULL,97,0,2022342,1,0,0),(212,122,'Hikvision DS-2CE76H0T-ITPFS 2.8 5MP INDOOR ANALOGE CAMERA WITH MIC',' كاميرات داخلية وضوح 5 امبي\nعدد 3 للطابق الارضي\nعدد 2 للطابق الاول',5,'',12,NULL,60,0,2022342,1,0,0),(213,127,'Hikvision DS-2CE16H0T-ITFS 5mp Outdoor mini analog camera 30 MTR  WDR mic','كاميرا خارجية وضوح 5 ام بي',1,'',13.5,NULL,13.5,0,2022342,1,0,0),(214,169,'Hikvision Door Access control DS-K1T804BMF','',1,'',38.5,NULL,38.5,0,2022343,1,0,0),(215,170,'Hikvision Magnetic Lock DS-K4H258s','',1,'',15.5,NULL,15.5,0,2022343,1,0,0),(216,174,'Lexo No Touch Exit Button ','',1,'',5.5,NULL,5.5,0,2022343,1,0,0),(217,168,'.','Fixing Door Access + Magnetic Lock With cabling ',1,'',30,NULL,30,0,2022343,1,0,0),(218,175,'TLSG-1005D 5 Port Giga Switch','',1,'',7.2,NULL,7.2,0,2022344,1,0,0),(219,100,'HDMI CABLE','30 Meter 4K For Training Hall ',1,'',18,NULL,18,0,2022344,1,0,0),(220,168,'.','Cat6 Cables 20 MTR + Cable Pulling + HDMI Cable Pulling + Trunking',1,'',20,NULL,20,0,2022344,1,0,0),(221,170,'Hikvision Magnetic Lock DS-K4H258s','For Forth Floor',1,'',15.5,NULL,15.5,0,2022344,1,0,0),(222,179,'Hikvision NVR DS-7604NI-Q1','جهاز تسجيل سعة 4 كاميرات',1,'',25,NULL,25,0,2022345,1,0,0),(223,49,'2 TB HDD WD PURPLE','هاردسك سعة 2 تيرا',1,'',21.5,NULL,21.5,0,2022345,1,0,0),(224,176,'Hikvision DS-2CD1047G0-L 4 MP Color  Fixed Bullet Network Camera','كاميرا خارجية وضوح 4 أم بي (تصوير ليلي ملون)',2,'',28.5,NULL,57,0,2022345,1,0,0),(225,42,'FIXING & Programming','تركيب الكاميرات مع البرمجة',2,'',15,NULL,30,0,2022345,1,0,0),(226,108,'INTERCOM SCREEN DSKH630 WTE1','شاشة انتركوم داخلية',1,'',31.5,NULL,31.5,0,2022345,1,0,0),(227,107,'INTERCOM OUTDOOR STATION DS KD8003 IME1','جرس انتركوم مع الكاميرا',1,'',33,NULL,33,0,2022345,1,0,0),(228,106,'INTERCOM KEYPAD DS KD KP','لوحة الدخول بالارقام',1,'',23,NULL,23,0,2022345,1,0,0),(229,109,'INTERCOM FRAME 2 MODULES DS KD ACW2','فريم للجرس ولوجة الارقام',1,'',15.5,NULL,15.5,0,2022345,1,0,0),(230,180,'Hikvision DS-3E0510P POE 8 Porst giga switch','سويتش للانتركوم وللكاميرات',1,'',26.5,NULL,26.5,0,2022345,1,0,0),(231,42,'FIXING & Programming','تركيب الانتركوم وبرمجته وربطه بالقفل الكهربائي',1,'',30,NULL,30,0,2022345,1,0,0),(232,75,'4 TB HDD PURPPLUE','هاردسك سعة 4 تيرا',1,'',37,NULL,37,0,2022346,1,0,0),(233,130,'POWER SUPPLY DB 12V 10A 16 CHANEL','صندوق كهرباء للكاميرات',1,'',16,NULL,16,0,2022346,1,0,0),(234,42,'FIXING & Programming','تركيب الكاميرات عدد 6',6,'',6.5,NULL,39,0,2022346,1,0,0),(235,32,'CABLING','أستبدال كيبلات عدد 3 كاميرات\nبيب ترنك ابيض\nوصلات',1,'',43,NULL,43,0,2022346,1,0,0),(236,128,'Hikvision IDS-7216HUHM-M2/S 16 CAHNNEL DVR SUPPORT 1-8 MP','سيرفر تسجيل سعة 16 كاميرا',1,'',125,NULL,125,0,2022346,1,0,0),(237,122,'Hikvision DS-2CE76H0T-ITPFS 2.8 5MP INDOOR ANALOGE CAMERA WITH MIC',' كاميرات داخلية وضوح 5 امبي\nعدد 3 للطابق الارضي\nعدد 2 للطابق الاول',5,'',18.2,NULL,91,0,2022346,1,0,0),(238,127,'Hikvision DS-2CE16H0T-ITFS 5mp Outdoor mini analog camera 30 MTR  WDR mic','كاميرا خارجية وضوح 5 ام بي',1,'',19.5,NULL,19.5,0,2022346,1,0,0),(239,183,'Class Pro EK42FHD ','',1,'',175,NULL,175,0,2022346,1,0,0),(240,184,'Impex IX32HD Screen','',1,'',49.8,NULL,49.8,0,2022346,1,0,0),(241,187,'Hikvision  Analog Intercom DS-KIS203T','انتركوم',1,'',36,NULL,36,0,2022348,1,0,0),(242,42,'FIXING & Programming','تركيب الانتركوم',1,'',7,NULL,7,0,2022348,1,0,0),(243,40,'TL-OC200 OMADO CLOUD CONTROLLER','',1,'',33,NULL,33,0,2022349,1,0,0),(244,132,'TL-EAP610','ACCESS POINT Support \n2.4 G  support 574 Mbps\n5 G  support 1200 Mbps',3,'',40,NULL,120,0,2022349,1,0,0),(245,35,'TL-SG1210P POE SWITCH 8 PORTS','Switch Support 1000 mbps with power POE',1,'',25,NULL,25,0,2022349,1,0,0),(246,149,'TL-OC300 OMADO CLOUD CONTROLLER','',1,'',77,NULL,77,0,2022350,1,0,0),(247,156,'TL-EAP650 wall mount','Outdoor Wifi ',2,'',68,NULL,136,1,2022350,1,0,0),(248,34,'TL-EAP650 Ceiling mount','Indoor Wifi',5,'',64,NULL,320,2,2022350,1,0,0),(249,139,'TL-SG1218MPE 16 Giga POE Port EASY SMART Switch  Vlan','16× PoE+ gigabit RJ45 ports, 2× gigabit non-PoE RJ45 ports and 2× combo gigabit SFP slots.',2,'',67,NULL,134,3,2022350,1,0,0),(250,80,'TL- SG2428P  JetStream 28-Port Gigabit Smart Switch With 24-Port PoE+','',1,'',93,NULL,93,4,2022350,1,0,0),(251,42,'FIXING & Programming','Fixing 7 Access Points with Programming\nProgram cisco switches\nIndoor and Outdoor Cable Pulling\nIndoor Cables',1,'',285,NULL,285,5,2022350,1,0,0),(252,131,'4u cabinet 530*350','',2,'',22,NULL,44,6,2022350,1,0,0),(253,197,'SONOS Amplifier','',2,'',385,NULL,770,7,2022350,1,0,0),(254,194,'Bose FS2SE Outdoor Speaker','',3,'',70,NULL,210,8,2022350,1,0,0),(255,195,'Speaker cable Global GSC1154','',1,'',26,NULL,26,9,2022350,1,0,0),(256,196,'Speaker Cable 2MKAB10 1.5mm 100 MTR','',1,'',28,NULL,28,10,2022350,1,0,0),(257,42,'FIXING & Programming','Fixing 3 Outdoor Speakers\nCable Pulling',1,'',75,NULL,75,11,2022350,1,0,0),(258,199,'Hikvision DS-2CD2141G1 WIFI 4 MP Indoor Dome Network Camera with Build-in Mic','',1,'',28,NULL,28,12,2022350,1,0,0),(259,198,'Hikvision DS-2CD1143G2 LIU 4 MP Indoor Dom Network IP camera with Mic','',1,'',29,NULL,29,13,2022350,1,0,0),(260,6,'Hikvision DS-2CD1143G0  4 MP Indoor Network  IP DOM Camera ','',1,'',24,NULL,24,14,2022350,1,0,0),(261,42,'FIXING & Programming','Fixing and programm 7 Cameras\nAll cable Pulling\nIndoor cables \nCamera Boxes\nTrunks',1,'',105,NULL,105,17,2022350,1,0,0),(262,167,'Hikvision DS-2CD2347G2 LU 2.8 INDOOR 4 MP IP Turret CAMERA COLOR WITH MIC','',4,'',39.5,NULL,158,15,2022350,1,0,0),(263,196,'.','Internet Topup',1,'',19,NULL,19,18,2022350,1,0,0),(264,203,'TP Link Tapo c220 wifi Camera 4mp','',1,'',15.5,NULL,15.5,16,2022350,1,0,0),(265,196,'.','<p>Provision of 30 MTR audio cable and laying of cable over ceiling with sound system configuration</p>',1,'',60,NULL,60,0,2022351,0,0,0),(266,35,'TL-SG1210P POE SWITCH 8 PORTS','<p>Switch 3rd Floor Cabinet</p>',1,'',26,NULL,26,1,2022352,1,0,0),(267,196,'.','<p>Pro-Sound Mic set WM209T</p>',1,'',29,NULL,29,0,2022352,1,0,0),(268,204,'FIXING','<p>Shifting and Fixing</p><p>PBX</p><p>CCVT Server</p><p>Cabinet</p><p>Finger Print</p>',1,'',45,NULL,45,0,2022353,1,0,0),(269,204,'FIXING','<p>Fixing 2 Camera</p>',2,'',5,NULL,10,0,2022353,1,0,0),(270,32,'CABLING','<p>Cat6 Cables for&nbsp;</p><p><b>8</b> cables for work stations&nbsp;</p><p><b>2&nbsp; extra cables for stand alone table&nbsp;</b></p><p>2 cables for Reception Office</p><p>2 Cables for Camera</p><p><br></p><p>Power cables for&nbsp;</p><p>Reception Office</p><p>For <b>Printer</b></p>',1,'',68,NULL,68,0,2022353,1,0,0),(271,196,'.','<p>Trunking</p><p>Telephone PBX modules&nbsp; Quantity 8</p><p><b>DATA modules&nbsp; Quantity 8 + 2 + 1</b></p><p>Data Dual Point Quantity<b> 3</b><br></p><p>Dual Power sockets Quantity <b>3</b></p><p>Patch Panel<b> Free</b></p><p>Shelf <b>Free</b></p>',1,'',48,NULL,48,0,2022353,1,0,0),(272,34,'TL-EAP650 Ceiling mount','ACCESS POINT',10,'',64,NULL,640,0,2022354,1,0,0),(273,40,'TL-OC200 OMADO CLOUD CONTROLLER','',1,'',40,NULL,40,0,2022354,1,0,0),(274,32,'CABLING','New Cabling&nbsp;',1,'',80,NULL,80,0,2022354,1,0,0),(275,190,'HikVision DS-9664NI-M8 NVR 64 chanel','64 chanel\nNone POE switch',1,'',410,NULL,410,0,2022355,1,0,0),(276,75,'4 TB HDD PURPPLUE','',3,'',40,NULL,120,0,2022355,1,0,0),(277,42,'FIXING & Programming','Fixing NVR and Reprogram 45 camera\n',1,'',20,NULL,20,0,2022355,1,0,0),(278,168,'.','Hard Reset and Reprogram for 10 camera',1,'',50,NULL,50,0,2022355,1,0,0),(279,196,'.','<p>Arrangement of cabels in 8th floor meeting room<br></p>',1,'',45,NULL,45,0,2022357,0,0,0),(280,205,'TL-EAP653 Ceiling Mount','',1,'',61,NULL,61,0,2022359,1,0,0),(281,207,'test item ','<p>sdfsdfsd</p>',3,'yy',60,NULL,180,0,2022360,0,0,0),(282,199,'Hikvision DS-2CD2141G1 WIFI 4 MP Indoor Dome Network Camera with Build-in Mic','<p>test</p>',3,'',23,21,69,0,2022360,0,0,0),(283,207,'test item ','<p>sdfsdfsd</p>',1,'yy',60,NULL,60,0,2022361,0,0,1),(284,207,'test item ','<p>sdfsdfsd</p>',1,'yy',60,50,60,0,2022361,0,0,1),(285,207,'test item ','<p>sdfsdfsd</p>',1,'yy',60,50,60,0,2022361,0,0,1),(286,207,'test item ','<p>sdfsdfsd</p>',2,'yy',60,50,120,0,2022361,0,0,1),(287,207,'test item ','<p>sdfsdfsd</p>',1,'yy',60,NULL,60,0,2022361,0,0,1),(288,207,'test item ','<p>sdfsdfsd</p>',1,'yy',60,NULL,60,0,2022362,0,0,0),(289,32,'CABLING','<p>Providing Norden CAT 6A AWG23 Cables for DATA and Acess Points</p><p>Providing Norden CAT 6 AWG23 Cables For CCTV</p>',1,'',1850,NULL,1850,0,2022363,1,0,0),(290,53,'RJ45 Module keystone cat6','',41,'',2.6,NULL,106.6,1,2022363,1,0,0),(291,208,'RJ45 Module Keystone Cat 6A tool less ','',60,'',3.2,NULL,192,2,2022363,1,0,0),(292,209,'Patchcord Cat 6A 15 CM','',100,'',1,NULL,100,3,2022363,1,0,0),(293,210,'Unloaded PATCH PANNEL 24 Port CAT 6A','',3,'',14,NULL,42,4,2022363,1,0,0),(294,210,'Unloaded PATCH PANNEL 24 port','',2,'',11,NULL,22,5,2022363,1,0,0),(295,30,'RJ45 phase plate Dual','',17,'',4.5,NULL,76.5,6,2022363,1,0,0),(296,32,'CABLING','Provide Speaker two core Cable&nbsp; 1.5 mm',1,'',837,NULL,837,7,2022363,1,0,0),(297,213,'42u Cabinnet 800x800','',1,'',360,NULL,360,8,2022363,1,0,0),(298,31,'PDU 6 WAY 13A','',2,'',12,NULL,24,9,2022363,1,0,0),(299,54,'1u Brush','',4,'',4.4,NULL,17.6,10,2022363,1,0,0),(300,32,'CABLING','<p>CCTV, Wifi AP and data Cables Pulling, Termination, Testing &amp; labiling&nbsp;</p>',1,'',1700,NULL,1700,11,2022363,1,0,0),(301,207,'test item ','<p>sdfsdfsd</p>',1,'yy',60,52,60,0,2022364,0,0,0),(302,207,'test item ','<p>sdfsdfsd</p>',1,'yy',60,50,60,0,2022365,0,0,0),(303,32,'Puling cabels for Micophones with connectors','CABLE BULLING',1,'',65,NULL,65,0,2022366,0,0,0),(304,32,'Mic To PC device','CABLE BULLING',1,'',48,NULL,48,0,2022367,0,0,0),(305,44,'schneider cat 6 Roll','',7,'',46.5,41,325.5,0,2022368,0,0,0),(306,44,'schneider cat 6 Roll','',7,'',46.5,41,325.5,0,2022369,0,0,0),(307,32,'CABLING','Outdoor CAT6 Cable Brand webb',438,'',0.25,1,109.5,0,2022369,0,0,0),(308,32,'CABLING','LED PROGRAMMING',1,'',0,1,0,0,2022369,0,0,1),(309,163,'CABLE TERMINATION','Main Controller and 3 subcontroller LAN connection Termination',4,'',0,0.1,0,0,2022369,0,0,0),(310,220,'PROGRAMMING','LED Programming',1,'',0,0,0,0,2022369,0,0,0),(311,108,'INTERCOM SCREEN DSKH6320 WTE1','شاشة الانتركوم الداخلية',1,'',31.5,NULL,31.5,0,2022370,1,0,0),(312,107,'INTERCOM OUTDOOR STATION DS KD8003 IME1','جرس الانتركوم مع الكاميرا',1,'',33,NULL,33,0,2022370,1,0,0),(313,106,'INTERCOM KEYPAD DS KD KP','لوحة الارقام السرية',1,'',23,NULL,23,0,2022370,1,0,0),(314,109,'INTERCOM FRAME 2 MODULES DS KD ACW2','فريم للجرس ولوحة الارقام السرية',1,'',15.5,NULL,15.5,0,2022370,1,0,0),(315,111,'ADAPTOR 12V 5A','باور للققفل والجرس',1,'',4,NULL,4,0,2022370,1,0,0),(316,221,'ADAPTOR 12V 1A','باور لشاشة الانتركوم',1,'',3.5,NULL,3.5,0,2022370,1,0,0),(317,42,'FIXING & Programming','التركيب والبرمجة',1,'',25,NULL,25,0,2022370,1,0,0),(318,44,'schneider cat 6 Roll','',7,'',46.5,41,325.5,0,2022371,0,0,0),(319,32,'CABLING','Outdoor CAT6 Cable Brand webb',438,'',0.25,0.135,109.5,1,2022371,0,0,0),(320,163,'CABLE TERMINATION','Main Controller and 3 subcontroller LAN connection Termination',4,'',0,0,0,3,2022371,0,0,0),(321,220,'PROGRAMMING','LED Programming',1,'',0.25,0.135,0.25,4,2022371,0,0,0),(322,222,'SD MEMORY CARD 32GB','',3,'',3.5,2.3,10.5,2,2022371,0,0,0),(323,44,'schneider cat 6 Roll','',7,'',46.5,41,325.5,0,2022372,0,0,0),(324,32,'CABLING','Outdoor CAT6 Cable Brand webb',438,'',0.25,0.135,109.5,1,2022372,0,0,0),(325,163,'CABLE TERMINATION','Main Controller and 3 subcontroller LAN connection Termination',4,'',0,0,0,3,2022372,0,0,0),(326,220,'PROGRAMMING','LED Programming',1,'',0,0,0,4,2022372,0,0,0),(327,222,'SD MEMORY CARD 32GB','',3,'',3.5,2.3,10.5,2,2022372,0,0,0),(328,190,'HikVision DS-9664NI-M8 NVR 64 chanel','64 chanel, None POE switch , 8 HDD slot',1,'',530,NULL,530,0,2022373,1,0,0),(329,66,'8 TB HDD PURPLE ','',4,'',69,NULL,276,1,2022373,1,0,0),(330,198,'Hikvision DS-2CD1143G2-LIU 4 MP Indoor Dom SMART HYBRID  Network IP camera with Mic','',2,'',23,NULL,46,3,2022373,1,0,0),(331,227,'Hikvison DS-2SE4C425MWG-E PTZ Dual lens TandemVu 4-inch 4 MP 25X Colorful & IR Network Speed Dome','',1,'',145,NULL,145,4,2022373,1,0,0),(332,143,'Hikvision Junction camera Box DS-1280ZJ-XS','BOX',6,'',3.4,NULL,20.4,5,2022373,1,0,0),(333,228,'Hikvision Junction camera Box DS-1260ZJ','',7,'',3.8,NULL,26.6,6,2022373,1,0,0),(334,155,'Camera PVC box','',15,'',1,NULL,15,7,2022373,1,0,0),(335,154,'SCREEN 22 INCH','21 Inch ',1,'',24,NULL,24,8,2022373,1,0,0),(336,79,'TL- SG3452P JETSTREAM 48 PORT GIGA MANAGED SWITCH','JetStream 52-Port Gigabit L2+ Managed Switch with 48-Port PoE+',2,'',185,NULL,370,13,2022373,1,0,0),(337,42,'FIXING & Programming','Entire CCTV Solution, Fixing Cameras, Programming',1,'',550,NULL,550,9,2022373,1,0,0),(338,219,'Hikvision DS-2CD2043G2-IU WDR AcuSense 4 MP IR Fixed outdoor Mini Bullet Network Camera With Mic','',38,'',32,NULL,1216,2,2022373,1,0,0),(339,205,'TL-EAP653 Ceiling Mount','',19,'',61,NULL,1159,11,2022373,1,0,0),(340,156,'TL-EAP650 wall mount','',6,'',64.8,NULL,388.8,12,2022373,1,0,0),(341,149,'TL-OC300 OMADO CLOUD CONTROLLER','',1,'',77,NULL,77,10,2022373,1,0,0),(342,80,'TL- SG2428P  JetStream 28-Port Gigabit Smart Switch With 24-Port PoE+','',1,'',93,NULL,93,14,2022373,1,0,0),(343,42,'FIXING & Programming','Entire WIFI DATA Soulution',1,'',320,NULL,320,15,2022373,1,0,0),(344,169,'Hikvision Door Access control DS-K1T804BMF','',1,'',45,NULL,45,16,2022373,1,0,0),(345,171,'Hikvision DS-K4H258-LZ Bracket for Magnetic Lock','',1,'',6.8,NULL,6.8,17,2022373,1,0,0),(346,172,'Lexo U Bracket for Magnetic Lock','',1,'',4.9,NULL,4.9,18,2022373,1,0,0),(347,174,'Lexo No Touch Exit Button ','',1,'',4.5,NULL,4.5,19,2022373,1,0,0),(348,231,'GrandStream UCM6308A IP BPX','',1,'',428,NULL,428,20,2022373,1,0,0),(349,229,'GrandStream GXP1610','IP PHONES 2 BUTTONS',5,'',22,NULL,110,21,2022373,1,0,0),(350,236,'GrandStream GXP1782','IP PHONES with 8 Buttons',7,'',29.3,NULL,205.1,22,2022373,1,0,0),(351,42,'FIXING & Programming','IP TELEPHONEY SYSTEM CONFIGURATION AND FIXING',1,'',250,NULL,250,23,2022373,1,0,0),(352,239,'.','Transfer all IT Active items from old office to new office with fixing  server Rack , Server side labeling',1,'',120,NULL,120,0,2022374,1,0,0),(353,239,'.','Reset Main door acess device',1,'',10,NULL,10,0,2022374,1,0,0),(354,32,'CABLING','Cabling to Access point quantity 1\nCabling to Reception Table quantity 2\nCabling to Work stations Partition Tables quantity 2\nExtend short Cabling to Work stations Partition Tables quantity 4\nCabling to Boss\'s Sofa office quantity 1\n',1,'',65,NULL,65,0,2022374,1,0,0),(355,239,'.','Coubler for short cables Quantity 4\nRJ45 Modules replacing Quantity 11\nPhase plates Quantity 5\nTrunking \nFixing and termination',1,'',55,NULL,55,0,2022374,1,0,0),(356,170,'Hikvision Magnetic Lock DS-K4H258s','Magnetic Lock For Boss Office',1,'',15.5,NULL,15.5,0,2022374,1,0,0),(357,239,'.','Fixing Boss Office Door Access Device',1,'',10,NULL,10,0,2022374,1,0,0),(358,264,'Lexo Switch No Touch with 2 remotes  swnotch2re','Fixing New exit button supports remotes, and recabling main door door access device',1,'',25,NULL,25,0,2022374,1,0,0),(359,240,'Audio Matrix HUB1616-16 Zone','',1,'',763,NULL,763,0,2022375,1,0,0),(360,241,'Amplifier 4 Channel eHSA 4-150 ','',4,'',580,NULL,2320,0,2022375,1,0,0),(361,242,'Player one - Airplay and Media player','',1,'',250,NULL,250,0,2022375,1,0,0),(362,243,'Usb Player Ecler eSAS BT-usb','',1,'',180,NULL,180,0,2022375,1,0,0),(363,194,'Bose FS2SE Outdoor Speaker','',8,'',67,NULL,536,0,2022375,1,0,0),(364,42,'FIXING & Programming','PA Sound system fixing and programming ',1,'',650,NULL,650,0,2022375,1,0,0),(365,252,'DSPPA DSP3011 3 Inch High Quality Framless Ceiling Speaker 6W','',48,'',7.5,NULL,360,0,2022375,1,0,0),(366,253,'DSPPA DSP107W Pendant Speakers Sound Projector 15W','',6,'',16,NULL,96,0,2022375,1,0,0),(367,267,'Ecler eAMBIT 103 speaker','',2,'',35,NULL,70,0,2022375,1,0,0),(368,266,'DSSPA ROCK SPEAKER 15 Watt','',4,'',32,NULL,128,0,2022375,1,0,0),(369,42,'FIXING & Programming','Switch And AP Fixing and Programming\nCable termination Quantity 24\nCAble pulling For :\n3 Indoor AP\n1 Outdoor AP\n',1,'',220,NULL,220,10,2022376,1,0,0),(370,79,'TL- SG3452P JETSTREAM 48 PORT GIGA MANAGED SWITCH','JetStream 52-Port Gigabit L2+ Managed Switch with 48-Port PoE+',1,'',195,NULL,195,0,2022376,1,0,0),(371,31,'PDU 6 WAY 13A','',1,'',12,NULL,12,5,2022376,1,0,0),(372,210,'Unloaded PATCH PANNEL 24 port','',1,'',14,NULL,14,6,2022376,1,0,0),(373,53,'RJ45 Module keystone cat6','',24,'',2.9,NULL,69.6,7,2022376,1,0,0),(374,257,'Patchcord','Patch Cord cables sizes 10-15 cm',48,'',1.3,NULL,62.4,8,2022376,1,0,0),(375,34,'TL-EAP650 Ceiling mount','ACCESS POINT',3,'',61,NULL,183,2,2022376,1,0,0),(376,156,'TL-EAP650 Outdoor','',1,'',68,NULL,68,3,2022376,1,0,0),(377,262,'TL-EAP655 Wall with poe port','',2,'',58,NULL,116,4,2022376,1,0,0),(378,258,'TL-SM311LS SFP Single Mode','',1,'',12.9,NULL,12.9,1,2022376,1,0,0),(379,261,'TP LINK Archer T3U usb Wifi Dongle','',6,'',7.3,NULL,43.8,9,2022376,1,0,0),(380,268,'Ezviz H8C PRO PTZ Camera 4K Outdoor','4K Camera',6,'',26.2,NULL,157.2,0,2022377,1,0,0),(381,269,'Ezviz H9C PTZ Camera 3K Outdoor','3K Dual Camera',1,'',31,NULL,31,0,2022377,1,0,0),(382,42,'FIXING & Programming','Fixing 7 Cameras ',1,'',28,NULL,28,0,2022377,1,0,0),(383,79,'TL- SG3452P JETSTREAM 48 PORT GIGA MANAGED SWITCH','Main Server Quantity 3\nBOP Quantity 1\nGuard Quantity 1',5,'',195,NULL,975,0,2022378,1,0,0),(384,205,'TL-EAP650 Ceiling Mount','Main Server Quantity 3\nBOP Quantity 1\nSino Gulf Quantity 4\nMess Hall Quantity 1\nSino Machine Shop 1',10,'',61,NULL,610,0,2022378,1,0,0),(385,210,'Unloaded PATCH PANNEL 24 port','Main Server Quantity 2\nBOP Quantity 1\nGuard Quantity 1',4,'',14,NULL,56,0,2022378,1,0,0),(386,53,'RJ45 Module keystone cat6','',96,'',2.9,NULL,278.4,0,2022378,1,0,0),(387,42,'FIXING & Programming','Switches and AP Programming anf fixing',1,'',350,NULL,350,0,2022378,1,0,0),(388,32,'CABLING','Patch Panel Shifiting from 27u Quantity 1\nCables Shifiting from 27u and terminated to 42 cabinet Quantity 24\nCabinet re arrangemnets \nCables Pulling:\n3 To stores AP\n8 To Sino Gulf\n\nBOP Patch panel retermination cables\nGuard Patch panel retermination cables',1,'',550,NULL,550,0,2022378,1,0,0),(389,257,'Patchcord','Patch Cord cables sizes 10-15 cm',192,'',1.3,NULL,249.6,0,2022378,1,0,0),(390,258,'TL-SM311LS SFP Single Mode','Main Server Quantity 3\nBOP Quantity 2\nGuard Quantity 1',6,'',12.9,NULL,77.4,0,2022378,1,0,0),(391,42,'FIXING & Programming','Switch Programming\nFixing Cabinet (Old stock shifiting )\nFixing AP\nCable termination',1,'',40,NULL,40,0,2022379,1,0,0),(392,156,'TL-EAP650 Outdoor','',1,'',68,NULL,68,0,2022379,1,0,0),(393,193,'TL-SG2218P JetStream 18-Port Gigabit Smart Switch with 16-Port PoE+','',1,'',75,NULL,75,0,2022379,1,0,0),(394,261,'TP LINK Archer T3U usb Wifi Dongle','AC1300 (400 Mpbs on 2.4GHz band and 867 Mbps on 5GHz band',6,'',7.3,NULL,43.8,0,2022379,1,0,0),(395,31,'PDU 6 WAY 13A','',1,'',12,NULL,12,0,2022379,1,0,0),(396,262,'TL-EAP655 Wall with poe port','',3,'',58,NULL,174,0,2022380,1,0,0),(397,34,'TL-EAP650 Ceiling mount','ACCESS POINT',2,'',61,NULL,122,0,2022381,1,0,0),(398,42,'FIXING & Programming','Fixing and programing AP\nCable Pulling quantity 2',1,'',68,NULL,68,0,2022381,1,0,0),(399,81,'HIKVISION NVR DS-7732NI-K4','32 CHANEL\nNON POE',1,'',145,NULL,145,0,2022382,1,0,0),(400,75,'4 TB HDD PURPPLUE','2 Hardisk For Main NVR\n',2,'',35,NULL,70,0,2022382,1,0,0),(401,6,'Hikvision DS-2CD1143G0  4 MP Indoor Network  IP DOM Camera ','Indoor Camera 4 mp (no MIC)  Dom shape\n2 For Office\n',2,'',22,NULL,44,0,2022382,1,0,0),(402,223,'Hikvision DS-2CD1043G2-LIU 4 MP Network outdoor mini bullet CAM WITH Mic','High quality imaging with 4 MP resolution\nSupport Human and Vehicle Detection\n\nFront Parking\nCafe outdoor seating',3,'',26.5,NULL,79.5,0,2022382,1,0,0),(403,273,'DS-2CD2T47G2H-LI  4 MP Smart Hybrid Light with ColorVu Fixed Bullet Network Camera  60 MTR','For Back Parking Area',4,'',53,NULL,212,0,2022382,1,0,0),(404,281,'Hikvision iDS-2CD7A46G0/P-IZHS 4MP DeepinView ANPR Moto Varifocal Bullet Camera',' (Automatic Number Plate Recognition) For car Gates entrances',2,'',227,NULL,454,0,2022382,1,0,0),(405,115,'9u Cabinet 600*600 wall Mount','',1,'',49,NULL,49,0,2022382,1,0,0),(406,210,'Unloaded PATCH PANNEL 24 port','',2,'',14,NULL,28,0,2022382,1,0,0),(407,53,'RJ45 Module keystone cat6','',46,'',1.9,NULL,87.4,0,2022382,1,0,0),(408,44,'schneider cat 6 Roll','',3,'',46.7,NULL,140.1,0,2022382,1,0,0),(409,196,'Speaker Cable KABLO  2MKAB10 1.5mm 100 MTR','',1,'',28,NULL,28,0,2022382,1,0,0),(410,40,'TL-OC200 OMADO CLOUD CONTROLLER','Wifi Controller',1,'',35,NULL,35,0,2022382,1,0,0),(411,79,'TL- SG3452P JETSTREAM 48 PORT GIGA MANAGED SWITCH','JetStream 52-Port Gigabit L2+ Managed Switch with 48-Port PoE+',1,'',190,NULL,190,0,2022382,1,0,0),(412,262,'TL-EAP655 Wall with poe port','',1,'',51,NULL,51,0,2022382,1,0,0),(413,205,'TL-EAP653 Ceiling Mount','',1,'',53,NULL,53,0,2022382,1,0,0),(414,239,'.','Metal Camera Boxs and stands ',7,'',28,NULL,196,0,2022382,1,0,0),(415,42,'FIXING & Programming','All Cables Terminations, Fixing and Programming',1,'',240,NULL,240,0,2022382,1,0,0),(416,81,'HIKVISION NVR DS-7732NI-K4','32 CHANEL\nNON POE',1,'',128,NULL,128,0,2022383,1,0,0),(417,75,'4 TB HDD PURPPLUE','2 Hardisk For Main NVR\n',2,'',35,NULL,70,0,2022383,1,0,0),(418,6,'Hikvision DS-2CD1143G0  4 MP Indoor Network  IP DOM Camera ','Indoor Camera 4 mp (no MIC)  Dom shape\n2 For Office\n',2,'',21.5,NULL,43,0,2022383,1,0,0),(419,223,'Hikvision DS-2CD1043G2-LIU 4 MP Network outdoor mini bullet CAM WITH Mic','High quality imaging with 4 MP resolution\nSupport Human and Vehicle Detection\n\nFront Parking\nCafe outdoor seating',2,'',21,NULL,42,0,2022383,1,0,0),(420,273,'DS-2CD2T47G2H-LI  4 MP Smart Hybrid Light with ColorVu Fixed Bullet Network Camera  60 MTR','For Back Parking Area',4,'',49,NULL,196,0,2022383,1,0,0),(421,281,'Hikvision iDS-2CD7A46G0/P-IZHS 4MP DeepinView ANPR Moto Varifocal Bullet Camera',' (Automatic Number Plate Recognition) For car Gates entrances',2,'',184,NULL,368,0,2022383,1,0,0),(422,115,'9u Cabinet 600*600 wall Mount','',1,'',45,NULL,45,0,2022383,1,0,0),(423,210,'Unloaded PATCH PANNEL 24 port','',2,'',14,NULL,28,0,2022383,1,0,0),(424,53,'RJ45 Module keystone cat6','',46,'',1.9,NULL,87.4,0,2022383,1,0,0),(425,44,'schneider cat 6 Roll','',3,'',44.7,NULL,134.1,0,2022383,1,0,0),(426,196,'Speaker Cable WEBB 1.0mm 100 MTR','',1,'',24,NULL,24,0,2022383,1,0,0),(427,40,'TL-OC200 OMADO CLOUD CONTROLLER','Wifi Controller',1,'',35,NULL,35,0,2022383,1,0,0),(428,79,'TL- SG3452P JETSTREAM 48 PORT GIGA MANAGED SWITCH','JetStream 52-Port Gigabit L2+ Managed Switch with 48-Port PoE+',1,'',178,NULL,178,0,2022383,1,0,0),(429,262,'TL-EAP655 Wall with poe port','',1,'',43,NULL,43,0,2022383,1,0,0),(430,205,'TL-EAP653 Ceiling Mount','',1,'',42,NULL,42,0,2022383,1,0,0),(431,239,'.','Metal Camera Boxs and stands ',7,'',28,NULL,196,0,2022383,1,0,0),(432,42,'FIXING & Programming','All Cables Terminations, Fixing and Programming',1,'',240,NULL,240,0,2022383,1,0,0),(433,44,'schneider cat 6 Roll','',4,'',44,40,176,0,2022384,0,0,0),(434,285,'cat 6A Roll','Brand Linxcom UK- 1 Roll\nBrand schneider - 1  Roll',2,'',69,64,138,0,2022384,0,0,0),(435,66,'8 TB HDD PURPLE ','',1,'',65,48,65,0,2022385,0,0,0),(436,40,'TL-OC200 OMADO CLOUD CONTROLLER','',1,'',38,28,38,0,2022385,0,0,0),(437,204,'FIXING','Replacing HDD',1,'',0,0,0,0,2022385,0,0,0),(438,239,'.','Fixing & Programming MOS Network',1,'',996.7,996.7,996.7,0,2022386,0,0,0),(439,239,'.','Installing Nizwa Main Server',1,'',327.375,327.375,327.375,0,2022386,0,0,0),(440,239,'.','Nizwa Data Network - Scope 1',1,'',1810.9,1810.9,1810.9,0,2022387,0,0,0),(441,239,'.','Nizwa Data Network - Scope 1',1,'',327.375,327.375,327.375,0,2022387,0,0,0),(442,239,'.','Nizwa Data Network Scope 1',1,'',958.387,958.387,958.387,0,2022388,0,0,0),(443,239,'.','Enhancement of Network System',1,'',200,200,200,0,2022389,0,0,0),(444,239,'.','NizwaDataNetwork - Access p - Fixing Prg',1,'',125,125,125,0,2022390,0,0,0),(445,286,'Hikvision Monitor 22 inch DS-D5022FN-C','Serial No: 30073488575\nSerial No: 30073488174',2,'',29,24.5,58,0,2022391,0,0,0),(446,239,'.','Site Visit',1,'',0,0,0,0,2022391,0,0,0),(447,219,'Hikvision DS-2CD2043G2-IU WDR AcuSense 4 MP IR Fixed outdoor Mini Bullet Network Camera With Mic','',2,'',32,26,64,0,2022392,0,0,0),(448,141,'Hikvision DS-2CD2T45G0P-I  4 MP Super Wide Angle 180° outdoor Fixed Bullet Network Camera','',1,'',47,39,47,0,2022392,0,0,0),(449,42,'FIXING & Programming','',3,'',5,0,15,0,2022392,0,0,0),(450,239,'.','Request for Fixed Phones to Enhance Inte',1,'',181.25,0,181.25,0,2022393,0,0,0),(451,239,'.','Request for Fixed Phones to Enhance Inte',1,'',181.25,0,181.25,0,2022394,0,0,0),(452,239,'.','Request for Fixed Phones to Enhance Inte',1,'',181.25,0,181.25,0,2022395,0,0,0),(453,239,'.','Exit button with two remotes\nwith fixing',1,'',17.15,12,17.15,0,2022396,0,0,0),(454,239,'.','Request for Fixed Phones to Enhance Inte',1,'',181.25,0,181.25,0,2022397,0,0,0),(455,278,'GrandStream UCM6302V','Telephoney Server',1,'',335,NULL,335,0,2022398,1,0,0),(456,280,'GrandStream GRP2613W IP phone',' 6 SIP accounts \n1 Gigabit ethernet ports\nWifi Supported ',6,'',35,NULL,210,0,2022398,1,0,0),(457,232,'GrandStream WP810 Wifi Phone','',1,'',0,NULL,0,0,2022398,1,0,0),(458,42,'FIXING & Programming','Fixing and Basic Programming',1,'',180,NULL,180,0,2022398,1,0,0),(459,132,'TL-EAP610','Access Point AX1800- Wifi6  اجهزة الوايفاي',2,'',39,26.5,78,0,2022399,0,0,0),(460,40,'TL-OC200 OMADO CLOUD CONTROLLER','كنترولر لاجهزة الشبكة',1,'',35,26,35,2,2022399,0,0,0),(461,64,'TL-SG1024D 24 Giga port Switch','سويتش لنقاط الانترنت سعة 24 منفذ',1,'',39,NULL,39,3,2022399,1,0,1),(462,204,'FIXING','تركيب وبرمجة أجهزة الوايفاي',1,'',40,70,40,4,2022399,0,0,0),(463,133,'Hikvision NVR DS-7608NI-Q2/8p','جهاز تسجيل الكاميرات سعة 8 كاميرات',1,'',65,NULL,65,5,2022399,1,0,1),(464,82,'Hikvision DS-2CD2047G2-LU 4 MP Color Fixed outdoor Mini Bullet Network Camera With Mic','كاميرات خارجية (تصوير ليلي) وضوح 4 ام بي',3,'',35.5,31,106.5,6,2022399,0,0,0),(465,6,'Hikvision DS-2CD1143G0  4 MP Indoor Network  IP DOM Camera ','كاميرات IP داخلية وضوح 4 ام بي بدون صوت',4,'',23.5,NULL,94,8,2022399,1,0,1),(466,143,'DS-1280ZJ-XS Hikvision camera Box','صندوق كاميرا هيفي ديوتي',3,'',3.8,2.8,11.4,8,2022399,0,0,0),(467,75,'4 TB HDD PURPPLUE','هارديسك سعة 4 تيرا',1,'',36,28,36,9,2022399,0,0,0),(468,204,'FIXING','تركيب وبرمجة منظومة الكاميرات مع عدد 7 كايمرات',1,'',40,NULL,40,10,2022399,1,0,0),(469,107,'INTERCOM OUTDOOR STATION DS KD8003 IME1','جرس انتركوم مع الكاميرا',1,'',33,27,33,11,2022399,0,0,0),(470,108,'INTERCOM SCREEN DSKH6320 WTE1','شاشات انتركوم داخليه مع خاصية التواصل الداخلي',3,'',31.5,27,94.5,12,2022399,0,0,0),(471,106,'INTERCOM KEYPAD DS KD KP','لوحة الارقام السرية للانتركوم',1,'',23,19,23,13,2022399,0,0,0),(472,109,'INTERCOM FRAME 2 MODULES DS KD ACW2','فريم للجرس ولوحة الارقام السرية',1,'',15.5,12.4,15.5,14,2022399,0,0,0),(473,42,'FIXING & Programming','تركيب وبرمجة منظومة الانتركوم',1,'',65,NULL,65,15,2022399,1,0,0),(474,110,'YALE LOCK','قفل للباب خارجي- بدون تركيب القفل ',1,'',20.5,NULL,20.5,16,2022399,1,0,1),(475,218,'ADAPTOR 12V 3A','ادابتر كهرباء للقفل الخارجي',1,'',3.5,2.4,3.5,16,2022399,0,0,0),(476,216,'Hikvision Analoge Amplifier 60 Watt','امبليفاير للسماعات بخاصية البلوتوث وال USB ',1,'',42,NULL,42,18,2022399,1,0,1),(477,217,'Hikvision Ceiling Speaker 6 Watt','سماعات اسقف',8,'',7.5,NULL,60,19,2022399,1,0,1),(478,204,'FIXING','',1,'',40,NULL,40,19,2022399,1,0,0),(479,165,'VOLUME CONTROLLER','متحكم بدرجة الصوت للسماعات-اللون فضي او ذهبي',8,'',5.9,4.5,47.2,20,2022399,0,0,0),(480,191,'15u Cabinet 600*600 Wall Mount','كبينة',1,'',59,39,59,21,2022399,0,0,0),(481,31,'PDU 6 WAY 13A','محول كهرباء للكبينة سعة 6 منافذ',1,'',9,5.5,9,22,2022399,0,0,0),(482,210,'Unloaded PATCH PANNEL 24 port','',2,'',12,5,24,23,2022399,0,0,0),(483,53,'RJ45 Module keystone cat6','',39,'',2.4,1.2,93.6,24,2022399,0,0,0),(484,55,'Shelf 470x300','رف للكبينة',1,'',6.2,3,6.2,25,2022399,0,0,0),(485,150,'Patchcord Cat6 50cm','كيبلات للكيبنة طول ما بين 15 سم الى 50 سم',35,'',0.9,0.3,31.5,26,2022399,0,0,0),(486,204,'FIXING','ترمنيشن للكوابل \nتركيب الكبينه',1,'',120,NULL,120,27,2022399,1,0,0),(487,80,'TL- SG2428P  JetStream 28-Port Gigabit Smart Switch With 24-Port PoE+','سويتش بخاصية الكهرباء للوايفاي والانتركوم سعة 24 منفذ',1,'',107,NULL,107,28,2022399,1,0,1),(488,262,'TL-EAP655 Wall with poe port','',2,'',39,29.5,78,1,2022399,0,0,0),(489,288,'Pro Sound ceiling speakers 6w','سماعات السقف',9,'',7.5,4.5,67.5,0,2022399,0,0,1),(490,288,'Hi Power ceiling speakers 6w','سماعات السقف',9,'',7.5,4.2,67.5,18,2022399,0,0,0),(491,290,'HIKVISION NVR DS-7732NXI-K4','جهاز تسجيل كاميرات سعة 32 كاميرا',1,'',109,89,109,5,2022399,0,0,1),(492,79,'TL- SG3452P JETSTREAM 48 PORT GIGA MANAGED SWITCH','JetStream 52-Port Gigabit L2+ Managed Switch with 48-Port PoE+',1,'',168,140,168,3,2022399,0,0,0),(493,291,'Disspa Amplifier MP120UB 120 Watt','',1,'',63,50,63,17,2022399,0,0,0),(494,136,'HIKVISION NVR DS-7616NI-Q2','16 Chanel- None POE',1,'',54,32,54,5,2022399,0,0,0),(495,167,'Hikvision DS-2CD2347G2 LU 2.8 INDOOR 4 MP IP Turret CAMERA COLOR WITH MIC','',4,'',33,31.3,132,7,2022399,0,0,0),(496,132,'TL-EAP610','Access Point AX1800- Wifi6  اجهزة الوايفاي',2,'',39,26.5,78,0,2022400,0,0,0),(497,40,'TL-OC200 OMADO CLOUD CONTROLLER','كنترولر لاجهزة الشبكة',1,'',35,26,35,2,2022400,0,0,0),(498,204,'FIXING','تركيب وبرمجة أجهزة الوايفاي',1,'',40,70,40,4,2022400,0,0,0),(499,82,'Hikvision DS-2CD2047G2-LU 4 MP Color Fixed outdoor Mini Bullet Network Camera With Mic','كاميرات خارجية (تصوير ليلي) وضوح 4 ام بي',3,'',35.5,31,106.5,6,2022400,0,0,0),(500,143,'DS-1280ZJ-XS Hikvision camera Box','صندوق كاميرا هيفي ديوتي',3,'',3.8,2.8,11.4,8,2022400,0,0,0),(501,75,'4 TB HDD PURPPLUE','هارديسك سعة 4 تيرا',1,'',36,28,36,9,2022400,0,0,0),(502,204,'FIXING','تركيب وبرمجة منظومة الكاميرات مع عدد 7 كايمرات',1,'',40,NULL,40,10,2022400,1,0,0),(503,107,'INTERCOM OUTDOOR STATION DS KD8003 IME1','جرس انتركوم مع الكاميرا',1,'',33,27,33,11,2022400,0,0,0),(504,108,'INTERCOM SCREEN DSKH6320 WTE1','شاشات انتركوم داخليه مع خاصية التواصل الداخلي',3,'',31.5,27,94.5,12,2022400,0,0,0),(505,106,'INTERCOM KEYPAD DS KD KP','لوحة الارقام السرية للانتركوم',1,'',23,19,23,13,2022400,0,0,0),(506,109,'INTERCOM FRAME 2 MODULES DS KD ACW2','فريم للجرس ولوحة الارقام السرية',1,'',15.5,12.4,15.5,14,2022400,0,0,0),(507,42,'FIXING & Programming','تركيب وبرمجة منظومة الانتركوم',1,'',65,NULL,65,15,2022400,1,0,0),(508,218,'ADAPTOR 12V 3A','ادابتر كهرباء للقفل الخارجي',1,'',3.5,2.4,3.5,16,2022400,0,0,0),(509,204,'FIXING','',1,'',40,NULL,40,19,2022400,1,0,0),(510,165,'VOLUME CONTROLLER','متحكم بدرجة الصوت للسماعات-اللون فضي او ذهبي',8,'',5.9,4.5,47.2,20,2022400,0,0,0),(511,191,'15u Cabinet 600*600 Wall Mount','كبينة',1,'',59,39,59,21,2022400,0,0,0),(512,31,'PDU 6 WAY 13A','محول كهرباء للكبينة سعة 6 منافذ',1,'',9,5.5,9,22,2022400,0,0,0),(513,210,'Unloaded PATCH PANNEL 24 port','',2,'',12,5,24,23,2022400,0,0,0),(514,53,'RJ45 Module keystone cat6','',39,'',2.4,1.2,93.6,24,2022400,0,0,0),(515,55,'Shelf 470x300','رف للكبينة',1,'',6.2,3,6.2,25,2022400,0,0,0),(516,150,'Patchcord Cat6 50cm','كيبلات للكيبنة طول ما بين 15 سم الى 50 سم',35,'',0.9,0.3,31.5,26,2022400,0,0,0),(517,204,'FIXING','ترمنيشن للكوابل \nتركيب الكبينه',1,'',120,NULL,120,27,2022400,1,0,0),(518,262,'TL-EAP655 Wall with poe port','',2,'',39,29.5,78,1,2022400,0,0,0),(519,288,'Hi Power ceiling speakers 6w','سماعات السقف',9,'',7.5,4.2,67.5,18,2022400,0,0,0),(520,79,'TL- SG3452P JETSTREAM 48 PORT GIGA MANAGED SWITCH','JetStream 52-Port Gigabit L2+ Managed Switch with 48-Port PoE+',1,'',168,140,168,3,2022400,0,0,0),(521,291,'Disspa Amplifier MP120UB 120 Watt','',1,'',63,50,63,17,2022400,0,0,0),(522,136,'HIKVISION NVR DS-7616NI-Q2','16 Chanel- None POE',1,'',54,32,54,5,2022400,0,0,0),(523,167,'Hikvision DS-2CD2347G2 LU 2.8 INDOOR 4 MP IP Turret CAMERA COLOR WITH MIC','',4,'',33,31.3,132,7,2022400,0,0,0),(524,132,'TL-EAP610','Access Point AX1800- Wifi6  اجهزة الوايفاي',2,'',39,NULL,78,0,2022401,1,0,0),(525,40,'TL-OC200 OMADO CLOUD CONTROLLER','كنترولر لاجهزة الشبكة',1,'',35,NULL,35,0,2022401,1,0,0),(526,204,'FIXING','تركيب وبرمجة أجهزة الوايفاي',1,'',40,NULL,40,0,2022401,1,0,0),(527,82,'Hikvision DS-2CD2047G2-LU 4 MP Color Fixed outdoor Mini Bullet Network Camera With Mic','كاميرات خارجية (تصوير ليلي) وضوح 4 ام بي',3,'',35.5,NULL,106.5,0,2022401,1,0,0),(528,143,'DS-1280ZJ-XS Hikvision camera Box','صندوق كاميرا هيفي ديوتي',3,'',3.8,NULL,11.4,0,2022401,1,0,0),(529,75,'4 TB HDD PURPPLUE','هارديسك سعة 4 تيرا',1,'',36,NULL,36,0,2022401,1,0,0),(530,204,'FIXING','تركيب وبرمجة منظومة الكاميرات مع عدد 7 كايمرات',1,'',40,NULL,40,0,2022401,1,0,0),(531,107,'INTERCOM OUTDOOR STATION DS KD8003 IME1','جرس انتركوم مع الكاميرا',1,'',33,NULL,33,0,2022401,1,0,0),(532,108,'INTERCOM SCREEN DSKH6320 WTE1','شاشات انتركوم داخليه مع خاصية التواصل الداخلي',3,'',31.5,NULL,94.5,0,2022401,1,0,0),(533,106,'INTERCOM KEYPAD DS KD KP','لوحة الارقام السرية للانتركوم',1,'',23,NULL,23,0,2022401,1,0,0),(534,109,'INTERCOM FRAME 2 MODULES DS KD ACW2','فريم للجرس ولوحة الارقام السرية',1,'',15.5,NULL,15.5,0,2022401,1,0,0),(535,42,'FIXING & Programming','تركيب وبرمجة منظومة الانتركوم',1,'',65,NULL,65,0,2022401,1,0,0),(536,218,'ADAPTOR 12V 3A','ادابتر كخرباء للقفل الخارجي',1,'',3.5,NULL,3.5,0,2022401,1,0,0),(537,204,'FIXING','',1,'',40,NULL,40,0,2022401,1,0,0),(538,165,'VOLUME CONTROLLER','متحكم بدرجة الصوت للسماعات-اللون فضي او ذهبي',8,'',5.9,NULL,47.2,0,2022401,1,0,0),(539,191,'15u Cabinet 600*600 Wall Mount','كبينة',1,'',59,NULL,59,0,2022401,1,0,0),(540,31,'PDU 6 WAY 13A','محول كهرباء للكبينة سعة 6 منافذ',1,'',9,NULL,9,0,2022401,1,0,0),(541,210,'Unloaded PATCH PANNEL 24 port','',2,'',12,NULL,24,0,2022401,1,0,0),(542,53,'RJ45 Module keystone cat6','',39,'',2.4,NULL,93.6,0,2022401,1,0,0),(543,55,'Shelf 470x300','رف للكبينة',1,'',6.2,NULL,6.2,0,2022401,1,0,0),(544,150,'Patchcord Cat6 50cm','كيبلات للكيبنة طول ما بين 15 سم الى 50 سم',35,'',0.9,NULL,31.5,0,2022401,1,0,0),(545,204,'FIXING','ترمنيشن للكوابل \nتركيب الكبينه',1,'',120,NULL,120,0,2022401,1,0,0),(546,262,'TL-EAP655 Wall with poe port','',2,'',39,NULL,78,0,2022401,1,0,0),(547,288,'Hi Power ceiling speakers 6w','',9,'',7.5,NULL,67.5,0,2022401,1,0,0),(548,291,'Disspa Amplifier MP120UB 120 Watt','امبليفاير سعة 120 وات',1,'',63,NULL,63,0,2022401,1,0,0),(549,79,'TL- SG3452P JETSTREAM 48 PORT GIGA MANAGED SWITCH','سويتش سعة 48 منفذ POE',1,'',165,NULL,165,0,2022401,1,0,0),(550,136,'HIKVISION NVR DS-7616NI-Q2','16 Chanel- None POE',1,'',52,NULL,52,0,2022401,1,0,0),(551,289,'Hikvision DS-2CD1347G2H-LIU Network Turret Hybrid colorVu  camera 4 mp','كاميرات داخلية سعة 4 ام بي ',4,'',27,NULL,108,0,2022401,1,0,0),(552,2,'Hikvision DS-2CD1043G0 Outdoor Network Camera 4 mp','',1,'',21,NULL,21,0,2022402,1,0,0),(553,88,'CAT6 to HDMI ADAPTER WITH MOUSE','',1,'',22,NULL,22,0,2022402,1,0,0),(554,134,'Intercom kit DS-KIS602','DS-KD8003-IME1/Surface x1\nDS-KH6320-WTE1 x1 Screen\n4 port poe switch\n',1,'',92,NULL,92,0,2022402,1,0,0),(555,32,'CABLING','Fixing & Porgramming Intercom\nFixing & Programming Camera\nFixinig Door Exit \n\n4 cat CABLE BULLING to server room\n1 cat CABLE BULLING to door access\n\nProviding Cat6 Cables \nPVC trunks',1,'',80,NULL,80,0,2022402,1,0,0),(556,173,'Lexo Exit Button ','',1,'',3.2,NULL,3.2,0,2022402,1,0,0),(557,48,'HIKVISION NVR DS-7616NI-Q2/16P','جهاز تسجيل سعة 16 كاميرا مع سويتش مدمج سعة 16 منفذ',1,'',72,NULL,72,0,2022403,1,0,0),(558,75,'4 TB HDD PURPPLUE','هارديسك تخزين سعة 4 تيرا',1,'',35,NULL,35,1,2022403,1,0,0),(559,82,'Hikvision DS-2CD2047G2-LU 4 MP Color Fixed outdoor Mini Bullet Network Camera With Mic','كاميرات خارجية وضوح 4 ام بي تصوير ليلي ملون ',3,'',35.5,NULL,106.5,2,2022403,1,0,0),(560,167,'Hikvision DS-2CD2347G2 LU 2.8 INDOOR 4 MP IP Turret CAMERA COLOR WITH MIC','كاميرات وضوح 4 ام بي\nتصوير ليلي\nمع المايك',2,'',34.3,NULL,68.6,3,2022403,1,0,0),(561,134,'Intercom kit DS-KIS602','DS-KD8003-IME1/Surface x1  جرس\nDS-KH6320-WTE1 x1 Screen شاشه\n4 port poe switch سويتش\n16GB TF card x1 ذاكرة داخلية',1,'',77,NULL,77,4,2022403,1,0,0),(562,106,'INTERCOM KEYPAD DS KD KP','لوحة الارقام السرية للانتركوم',1,'',23,NULL,23,5,2022403,1,0,0),(563,109,'INTERCOM FRAME 2 MODULES DS KD ACW2','فريم للجرس ولوحة الارقام السرية',1,'',15.5,NULL,15.5,6,2022403,1,0,0),(564,42,'FIXING & Programming','Fixing 8 camera\nFixing Intercom with lock connection\nNvr Programming\nMobile Connection\n',1,'',85,NULL,85,7,2022403,1,0,0),(565,228,'Hikvision Junction camera Box DS-1260ZJ','بوكسات معدنية خاصة للكاميرات الخارجية',3,'',3.8,NULL,11.4,8,2022403,1,0,0),(566,218,'ADAPTOR 12V 3A','',1,'',5.5,NULL,5.5,9,2022403,1,0,0),(567,32,'CABLING','',1,'',40,NULL,40,10,2022403,1,0,0),(568,265,'EZVIZ H7c Dual Camera 4mp indoor','',3,'',26,NULL,78,11,2022403,1,0,0),(569,239,'.','Electrition',1,'',20,NULL,20,12,2022403,1,0,0),(570,294,'.','Memory Cards Sandisk128 GB (extra Showroom Warranty)',3,'',3.9,NULL,11.7,13,2022403,0,0,0),(571,53,'RJ45 Module keystone cat6','',2,'',2.2,NULL,4.4,16,2022403,0,0,0),(572,294,'.','Fixing Internet Speed and Wiring',1,'',15,NULL,15,17,2022403,0,0,0),(573,294,'.','TP LINK MODEM Router',1,'',25,NULL,25,14,2022403,0,0,0),(574,120,'4 port switch poe','1 GB Speed',1,'',14,NULL,14,15,2022403,0,0,0),(575,219,'Hikvision DS-2CD2043G2-IU WDR AcuSense 4 MP IR Fixed outdoor Mini Bullet Network Camera With Mic','Extra Camera for\nKitchen\nTerrace\nMizrad',3,'',32,NULL,96,0,2022404,1,0,0),(576,194,'Bose FS2SE Outdoor Speaker','',1,'',67,NULL,67,0,2022404,1,0,0),(577,53,'RJ45 Module keystone cat6','',5,'',2.6,NULL,13,0,2022404,1,0,0),(578,208,'RJ45 Module Keystone Cat 6A tool less ','',10,'',3.2,NULL,32,0,2022404,1,0,0),(579,30,'RJ45 phase plate Dual','',7,'',4.2,NULL,29.4,0,2022404,1,0,0),(580,209,'Patchcord Cat 6A 15 CM','',15,'',1,NULL,15,0,2022404,1,0,0),(581,31,'PDU 6 WAY 13A','',1,'',12,NULL,12,0,2022404,1,0,0),(582,294,'.','Extra Cabling',15,'',8,NULL,120,0,2022404,1,0,0),(583,294,'.','19U Cabinet',1,'',45,NULL,45,0,2022404,1,0,0),(584,294,'.','Fiber Convertor to Cat 6\nFrom Gaurd gate to Albait Alkbeer',1,'',32,NULL,32,0,2022404,1,0,0),(585,294,'.','Camera Arms',4,'',4.6,NULL,18.4,0,2022404,1,0,0),(586,79,'TL- SG3452P JETSTREAM 48 PORT GIGA MANAGED SWITCH','Main IT quantity 2\nOHSE quantity 1',3,'',185,NULL,555,0,2022405,1,0,0),(587,80,'TL- SG2428P  JetStream 28-Port Gigabit Smart Switch With 24-Port PoE+','Elcectronic Office quantity 1\nElectric Office quantity 1\nSore 1\nWelding Workshop 1',4,'',93,NULL,372,0,2022405,1,0,0),(588,149,'TL-OC300 OMADO CLOUD CONTROLLER','',1,'',77,NULL,77,0,2022405,1,0,0),(589,259,'TL-SM311LM SFP MultiMode','Main IT - Quantity 3\nStore - Quantity 1\nWelding- Quantity 2',6,'',12.9,NULL,77.4,0,2022405,1,0,0),(590,34,'TL-EAP650 Ceiling mount','Main Building\nJourney Manger 1\nYard Foreman 1\nLaboratory 1\nFF Lobby 2\nConferenace room 1',6,'',49,NULL,294,0,2022405,1,0,0),(591,262,'TL-EAP655 Wall with poe port','Main IT GF (replace wall switch)\nElectric Lab 1\nStore 1\nPCE 1\nGuard 1\nMoaz Office Indoor',6,'',46,NULL,276,0,2022405,1,0,0),(592,257,'Patchcord','Short Cables',96,'',1.2,NULL,115.2,0,2022405,1,0,0),(593,31,'PDU 6 WAY 13A','',1,'',9,NULL,9,0,2022405,1,0,0),(594,210,'Unloaded PATCH PANNEL 24 port','Main IT -Quantity 1\nOHSE- Quantity 1\nWelding - Quantity !',3,'',14,NULL,42,0,2022405,1,0,0),(595,53,'RJ45 Module keystone cat6','Main IT- Quantity 12\nOHSE - Quantity 20\nWELDING- Quantity 24',56,'',2.9,NULL,162.4,0,2022405,1,0,0),(596,32,'CABLING','CABLES Terminations \nMain IT- Quantity 12\nOHSE- Quantity 20\nWelding - Quantity  24',1,'',60,NULL,60,0,2022405,1,0,0),(597,42,'FIXING & Programming','ALL APs, Switches, Controller',1,'',272,NULL,272,0,2022405,1,0,0),(598,156,'TL-EAP650 Outdoor','Moaz Office OUTOOR *2\nWork Shop',3,'',68,NULL,204,0,2022405,1,0,0),(599,44,'schneider cat 6 Roll','',4,'',44,NULL,176,0,2022406,1,0,0),(600,210,'Unloaded PATCH PANNEL 24 port','',1,'',12.3,NULL,12.3,0,2022406,1,0,0),(601,53,'RJ45 Module keystone cat6','',47,'',1.9,NULL,89.3,0,2022406,1,0,0),(602,262,'TL-EAP655 Wall with poe port','',2,'',39,NULL,78,0,2022406,1,0,0),(603,155,'Camera PVC box','',2,'',1,NULL,2,0,2022406,1,0,0),(604,198,'Hikvision DS-2CD1143G2-LIU 4 MP Indoor Dom SMART HYBRID  Network IP camera with Mic','',2,'',24,NULL,48,0,2022406,1,0,0),(605,289,'Hikvision DS-2CD1347G2H-LIU Network Turret Hybrid colorVu  camera 4 mp','',1,'',28.3,NULL,28.3,0,2022406,1,0,0),(606,116,'Single RJ45 Phase Plate','',3,'',1.8,NULL,5.4,0,2022406,1,0,0),(607,42,'FIXING & Programming','Cable Termination Quantity 47\nCamera Fixing Quantity  3\nWifi Fixing Quantity   2\nProgramming',1,'',0,NULL,0,0,2022406,0,0,0),(608,132,'TL-EAP610','Access Point AX1800- Wifi6  اجهزة الوايفاي',8,'',39,NULL,312,0,2022407,1,0,0),(609,40,'TL-OC200 OMADO CLOUD CONTROLLER','كنترولر لاجهزة الشبكة',1,'',35,NULL,35,0,2022407,1,0,0),(610,204,'FIXING','تركيب وبرمجة أجهزة الوايفاي',1,'',40,NULL,40,0,2022407,1,0,0),(611,82,'Hikvision DS-2CD2047G2-LU 4 MP Color Fixed outdoor Mini Bullet Network Camera With Mic',' كاميرات خارجية (تصوير ليلي) وضوح 4 ام بي مع الصوت',3,'',35.5,NULL,106.5,0,2022407,1,0,0),(612,143,'DS-1280ZJ-XS Hikvision camera Box','صندوق كاميرا هيفي ديوتي للكاميرات الخارجيه',3,'',3.8,NULL,11.4,0,2022407,1,0,0),(613,75,'4 TB HDD PURPPLUE','هارديسك سعة 4 تيرا',2,'',36,NULL,72,0,2022407,1,0,0),(614,204,'FIXING','تركيب وبرمجة منظومة الكاميرات مع عدد 12 كايمرات',1,'',60,NULL,60,0,2022407,1,0,0),(615,107,'INTERCOM OUTDOOR STATION DS KD8003 IME1','جرس انتركوم مع الكاميرا',2,'',33,NULL,66,0,2022407,1,0,0),(616,108,'INTERCOM SCREEN DSKH6320 WTE1','شاشات انتركوم داخليه مع خاصية التواصل الداخلي',5,'',31.5,NULL,157.5,0,2022407,1,0,0),(617,106,'INTERCOM KEYPAD DS KD KP','لوحة الارقام السرية للانتركوم',2,'',23,NULL,46,0,2022407,1,0,0),(618,109,'INTERCOM FRAME 2 MODULES DS KD ACW2','فريم للجرس ولوحة الارقام السرية',2,'',15.5,NULL,31,0,2022407,1,0,0),(619,42,'FIXING & Programming','تركيب وبرمجة منظومة الانتركوم',1,'',85,NULL,85,0,2022407,1,0,0),(620,218,'ADAPTOR 12V 3A','ادابتر كخرباء للقفل الخارجي',2,'',3.5,NULL,7,0,2022407,1,0,0),(621,204,'FIXING','',1,'',55,NULL,55,0,2022407,1,0,0),(622,191,'15u Cabinet 600*600 Wall Mount','كبينة',1,'',59,NULL,59,0,2022407,1,0,0),(623,31,'PDU 6 WAY 13A','محول كهرباء للكبينة سعة 6 منافذ',1,'',9,NULL,9,0,2022407,1,0,0),(624,210,'Unloaded PATCH PANNEL 24 port','',3,'',12,NULL,36,0,2022407,1,0,0),(625,53,'RJ45 Module keystone cat6','',70,'',2.4,NULL,168,0,2022407,1,0,0),(626,55,'Shelf 470x300','رف للكبينة',1,'',6.2,NULL,6.2,0,2022407,1,0,0),(627,150,'Patchcord Cat6 50cm','كيبلات للكيبنة طول ما بين 15 سم الى 50 سم',48,'',0.9,NULL,43.2,0,2022407,1,0,0),(628,204,'FIXING','ترمنيشن للكوابل \nتركيب الكبينه',1,'',120,NULL,120,0,2022407,1,0,0),(629,284,'Bose FreeSpace FS2C  Indoor loud Speaker ','',19,'',33,NULL,627,0,2022407,1,0,0),(630,227,'Hikvison DS-2SE4C425MWG-E PTZ Dual lens TandemVu 4-inch 4 MP 25X Colorful & IR Network Speed Dome','',2,'',145,NULL,290,0,2022407,1,0,0),(631,292,'Bose FS 360P Garden Speaker','',3,'',99,NULL,297,0,2022407,1,0,0),(632,290,'HIKVISION NVR DS-7732NXI-K4','جهاز تسجيل كاميرات سعة 32 كاميرا',1,'',109,NULL,109,0,2022407,1,0,0),(633,79,'TL- SG3452P JETSTREAM 48 PORT GIGA MANAGED SWITCH','سويتش ذكي سعة 48 منفذ POE',1,'',185,NULL,185,0,2022407,1,0,0),(634,198,'Hikvision DS-2CD1143G2-LIU 4 MP Indoor Dom SMART HYBRID  Network IP camera with Mic','كاميرات داخلية سعة 4 ام بي مع المايك',8,'',23,NULL,184,0,2022407,1,0,0),(635,289,'Hikvision DS-2CD1347G2H-LIU Network Turret Hybrid colorVu  camera 4 mp','كاميرا داخلية سعة 4 ام بي مع الصوت',1,'',27,NULL,27,0,2022407,1,0,0),(636,293,'CAT 6A Cable Roll 500 MTR brand Excel','',3,'',122.7,NULL,368.1,0,2022407,1,0,0),(637,239,'.','Extra Cat 6A cables Brand Excel ',167,'',0.24,NULL,40.08,0,2022407,1,0,0),(638,294,'Speaker Cable KABLO 2MKAB10 1.5mm  Roll 305 MTR','Speaker cable',1,'',72,NULL,72,0,2022407,1,0,0),(639,295,'Speaker cable','',1,'',62,NULL,62,0,2022407,1,0,0),(640,301,'Ampllifier Pro Sound AT 1360 BT','',1,'',179,NULL,179,0,2022407,1,0,0),(641,294,'.','NEC Power Card',1,'',55,NULL,55,0,2022408,1,0,0),(642,48,'HIKVISION NVR DS-7616NI-Q2/16P','NVR 16 channel with 16 POE port switch with 2 HDD slot',2,'',72,NULL,144,0,2022409,1,0,0),(643,75,'4 TB HDD PURPPLUE','',2,'',33,NULL,66,0,2022409,1,0,0),(644,202,'Hikvision DS-2CD2047G2H-LIU 4 MP  Outdoor Smart Hybrid Light with ColorVu Fixed Mini Bullet Network Camera with Mic','',12,'',30.2,NULL,362.4,0,2022409,1,0,0),(645,228,'Hikvision Junction camera Box DS-1260ZJ','Metal Camera Box',12,'',3.5,NULL,42,0,2022409,1,0,0),(646,151,'SCREEN 19 INCH','',2,'',25,NULL,50,0,2022409,1,0,0),(647,107,'INTERCOM OUTDOOR STATION DS KD8003 IME1','BELL WITH CAMERA',2,'',33,NULL,66,0,2022409,1,0,0),(648,106,'INTERCOM KEYPAD DS KD KP','',2,'',23,NULL,46,0,2022409,1,0,0),(649,109,'INTERCOM FRAME 2 MODULES DS KD ACW2','',2,'',15.5,NULL,31,0,2022409,1,0,0),(650,108,'Hikvision INTERCOM SCREEN DSKH6320 WTE1','',2,'',31.5,NULL,63,0,2022409,1,0,0),(651,111,'ADAPTOR 12V 5A','',2,'',4,NULL,8,0,2022409,1,0,0),(652,40,'TL-OC200 OMADO CLOUD CONTROLLER','',2,'',36,NULL,72,0,2022409,1,0,0),(653,35,'TL-SG1210P POE SWITCH 8 PORTS','',2,'',23,NULL,46,0,2022409,1,0,0),(654,205,'TL-EAP653 Ceiling Mount','Each Villa \nGF  2\nFF  2\nPenthouse 1',10,'',36,NULL,360,0,2022409,1,0,0),(655,131,'4u cabinet 530*350','',2,'',19.3,NULL,38.6,0,2022409,1,0,0),(656,42,'FIXING & Programming','Fixing for two Villa\n12 Outdoor Camera\n10 Access Points\n2 Door Intercom',1,'',105,NULL,105,0,2022409,1,0,0),(657,79,'TL- SG3452P JETSTREAM 48 PORT GIGA MANAGED SWITCH','switch for coffe shop\nSwitch for Guard room (will be Swapped with Albait Alsharqi) ',2,'',179,NULL,358,0,2022410,1,0,0),(658,205,'TL-EAP653 Ceiling Mount','Guard Room',1,'',37,NULL,37,0,2022410,1,0,0),(659,156,'TL-EAP650 Outdoor','Coffe Shop 2\nCanon 1',3,'',48,NULL,144,0,2022410,1,0,0),(660,42,'FIXING & Programming','',1,'',0,NULL,0,0,2022410,1,0,0),(661,149,'TL-OC300 OMADO CLOUD CONTROLLER','',1,'',68.3,NULL,68.3,0,2022410,1,0,0),(662,79,'TL- SG3452P JETSTREAM 48 PORT GIGA MANAGED SWITCH','سويتش للكبينة الطابقة الثالث\nسويتش للكبينة الطابقة الاول',2,'',168,NULL,336,4,2022411,1,0,0),(663,80,'TL- SG2428P  JetStream 28-Port Gigabit Smart Switch With 24-Port PoE+','سويتش للكوفي شوب',1,'',93,NULL,93,5,2022411,1,0,0),(664,205,'TL-EAP653 Ceiling Mount','وايفي للورش',2,'',37,NULL,74,6,2022411,1,0,0),(665,219,'Hikvision DS-2CD2043G2-IU WDR AcuSense 4 MP IR Fixed outdoor Mini Bullet Network Camera With Mic','كاميرا لمزرد',1,'',29.65,NULL,29.65,2,2022411,1,0,0),(666,42,'FIXING & Programming','',1,'',1,NULL,1,8,2022411,1,0,0),(667,75,'4 TB HDD PURPPLUE','',1,'',39,NULL,39,1,2022411,1,0,0),(668,198,'Hikvision DS-2CD1143G2-LIU 4 MP Indoor Dom SMART HYBRID  Network IP camera with Mic','كاميرا داخلية وضوح 4 ام بي',1,'',22.8,NULL,22.8,3,2022411,1,0,0),(669,32,'CABLING','',1,'',25,NULL,25,7,2022411,1,0,0),(670,290,'HIKVISION NVR DS-7732NXI-K4','جهاز تسجيل كاميرات سعة 32 كاميرا',1,'',110,NULL,110,0,2022411,1,0,0),(671,23,'NEC TELEPHONEY SYSTEM PACKAGE','TELEPHONEY SYSTEM Package (USED SYSTEM) Including:\nCPU CARD\nExtension card (308 card)\n1 digital phone (used)\nUnloaded Patch Panel\nInstalltion and programming',1,'',150,NULL,150,0,2022412,1,0,0);

--
-- Table structure for table `TECH_BOULEVARDinvoice_payments`
--

CREATE TABLE `TECH_BOULEVARDinvoice_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  `payment_date` date NOT NULL,
  `payment_method_id` int(11) NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `invoice_id` int(11) NOT NULL,
  `status` enum('draft','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `transaction_id` tinytext COLLATE utf8_unicode_ci,
  `account_transaction_id` int(11) NOT NULL DEFAULT '0',
  `advance_transaction_id` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDinvoice_payments`
--

INSERT INTO `TECH_BOULEVARDinvoice_payments` VALUES (1,250,'2022-06-14',1,'2022-06-14','','','',0,'ADVANCED PAYMENT',2022303,'approved',0,NULL,1,0,1,'2022-06-14 07:34:23'),(2,2425.5,'2022-06-14',4,'2022-06-15','','','',0,'',2022302,'draft',0,NULL,0,0,1,'2022-06-15 10:00:02'),(3,200,'2022-06-20',1,'2022-06-21','','','',0,'',2022303,'approved',0,NULL,3,0,1,'2022-06-21 10:25:57'),(4,0.98,'2022-06-20',1,'2022-06-21','','','',0,'DISCOUNT',2022303,'approved',0,NULL,4,0,1,'2022-06-21 10:45:23'),(5,2445.45,'2022-06-20',1,'2022-06-27','','','',0,'',2022308,'approved',0,NULL,15,0,1,'2022-06-27 19:07:50'),(6,317.4,'2023-06-14',4,'2023-07-05','','','',0,'',2022324,'approved',0,NULL,18,0,1,'2023-07-04 23:23:53'),(7,300,'2023-06-21',4,'2023-07-05','','','',0,'',2022324,'approved',0,NULL,20,0,1,'2023-07-04 23:33:30'),(8,114.45,'2023-06-22',4,'2023-07-05','','','',0,'CASH',2022322,'draft',0,NULL,0,0,1,'2023-07-04 23:59:55'),(9,355.43,'2023-05-08',4,'2023-07-05','','','',0,'',2022317,'approved',0,NULL,22,0,1,'2023-07-05 00:02:03'),(10,179.97,'2023-07-13',4,'2023-10-23','','','',0,'',2022339,'approved',0,NULL,25,0,1,'2023-10-23 08:27:49'),(11,160.13,'2023-08-11',4,'2023-10-23','','','',0,'',2022340,'approved',0,NULL,26,0,1,'2023-10-23 08:39:47'),(12,179.97,'2023-08-29',4,'2023-10-23','','','',0,'',2022341,'approved',0,NULL,28,0,1,'2023-10-23 09:10:50'),(13,307.65,'2023-12-30',4,'2023-12-31','','','',0,'',2022345,'approved',0,NULL,30,0,1,'2023-12-31 04:59:09'),(14,45.15,'2024-01-16',4,'2024-01-29','','','',0,'',2022348,'approved',0,NULL,31,0,1,'2024-01-29 08:38:23'),(15,186.9,'2024-03-21',4,'2024-03-25','','','',0,'',2022349,'approved',0,NULL,32,0,1,'2024-03-25 18:25:26'),(16,18,'2025-07-25',1,'2025-07-28','','','',0,'',2022396,'approved',0,NULL,55,0,1,'2025-07-28 18:49:58'),(17,1622.67,'2024-10-10',4,'2025-07-31','','','',0,'',2022401,'approved',0,NULL,66,0,1,'2025-07-31 18:38:44');

--
-- Table structure for table `TECH_BOULEVARDinvoices`
--

CREATE TABLE `TECH_BOULEVARDinvoices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `bill_date` date NOT NULL,
  `due_date` date NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `labels` text COLLATE utf8_unicode_ci,
  `last_email_sent_date` date DEFAULT NULL,
  `status` enum('draft','not_paid','cancelled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `delivery_status` enum('delivered','not_delivered') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_delivered',
  `approval_status` enum('not_approved','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_approved',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `recurring` tinyint(4) NOT NULL DEFAULT '0',
  `recurring_invoice_id` int(11) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `next_recurring_date` date DEFAULT NULL,
  `no_of_cycles_completed` int(11) NOT NULL DEFAULT '0',
  `due_reminder_date` date DEFAULT NULL,
  `recurring_reminder_date` date DEFAULT NULL,
  `discount_amount` double NOT NULL,
  `discount_amount_type` enum('percentage','fixed_amount') COLLATE utf8_unicode_ci NOT NULL,
  `discount_type` enum('before_tax','after_tax') COLLATE utf8_unicode_ci NOT NULL,
  `cancelled_at` datetime DEFAULT NULL,
  `cancelled_by` int(11) NOT NULL,
  `revised` int(11) NOT NULL,
  `transaction_id` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2022413 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDinvoices`
--

INSERT INTO `TECH_BOULEVARDinvoices` VALUES (2022300,3,0,'2022-06-12','2022-06-12','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(2022301,3,0,'2022-06-12','2022-06-12','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(2022302,3,0,'2022-06-13','2022-06-13','','',NULL,'not_paid','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(2022303,2,1,'2022-06-14','2022-06-14','','',NULL,'not_paid','delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022304,2,1,'2022-06-21','2022-06-20','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,7,'fixed_amount','',NULL,0,0,0,0),(2022305,5,0,'2022-06-26','2022-06-26','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,5,'fixed_amount','',NULL,0,0,0,0),(2022306,5,0,'2022-06-26','2022-06-26','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','',NULL,0,0,0,0),(2022307,5,0,'2022-06-21','2022-06-20','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,7,'fixed_amount','before_tax',NULL,0,0,0,0),(2022308,3,0,'2022-06-13','2022-06-13','','',NULL,'not_paid','delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022309,8,0,'2022-08-31','2022-08-31','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022310,18,0,'2022-10-31','2022-10-31','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022311,19,0,'2022-11-03','2022-11-03','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022312,4,0,'2022-11-03','2022-11-03','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022313,21,0,'2022-11-27','2022-11-27','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022314,9,0,'2023-01-02','2023-01-19','NVR S.N:\nJ96347920\n\nCamera S.N:\nK66196131\nK66196166\nK66196194\nK66196207\nK66195992\nJ83651567\n\nHDD S.N:\nWX22A826ZTTP','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022315,24,0,'2023-02-24','2023-03-03','','',NULL,'draft','delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022316,11,0,'2023-03-08','2023-03-08','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022317,26,0,'2023-05-04','2023-05-04','','',NULL,'not_paid','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022318,3,0,'2023-04-18','2023-05-08','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022319,10,0,'2023-05-28','2023-05-28','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022320,10,0,'2023-05-23','2023-05-28','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022321,10,0,'2023-05-23','2023-05-28','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022322,11,0,'2023-06-09','2023-06-09','','',NULL,'not_paid','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022323,23,0,'2023-02-11','2023-02-11','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022324,29,0,'2023-06-13','2023-07-05','','',NULL,'not_paid','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022325,30,0,'2023-07-05','2023-07-05','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022326,24,0,'2023-07-14','2023-07-23','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022327,31,0,'2023-08-21','2023-08-21','','',NULL,'draft','not_delivered','not_approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(2022328,31,0,'2023-08-10','2023-09-03','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022329,32,0,'2023-08-20','2023-09-03','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022330,12,0,'2023-08-23','2023-09-03','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022331,12,0,'2023-09-21','2023-10-03','','',NULL,'draft','not_delivered','not_approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(2022332,12,0,'2023-09-21','2023-10-01','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022333,34,0,'2023-09-21','2023-10-01','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022334,33,0,'2023-09-21','2023-10-01','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022335,11,0,'2023-10-11','2023-10-11','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022336,11,0,'2023-10-11','2023-10-11','','',NULL,'draft','not_delivered','not_approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(2022337,12,0,'2023-10-15','2023-10-15','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022338,36,0,'2023-07-11','2023-07-11','','',NULL,'draft','not_delivered','not_approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(2022339,28,0,'2023-07-13','2023-07-13','','',NULL,'not_paid','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022340,26,0,'2023-08-08','2023-08-08','','',NULL,'not_paid','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022341,28,0,'2023-08-29','2023-08-29','','',NULL,'not_paid','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022342,37,0,'2023-11-16','2023-11-16','\n1 YEAR warranty DVR, HDD, Camera\n\nNVR S/N: AA2298816\nCAM S/N:\nAE2663420\nAE2663393\nAE2663425\nAE2663428\nAE2663367\nJ12365656\nHDD S/N: WCC7K3KYU412','',NULL,'draft','delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022343,12,0,'2023-12-10','2023-12-10','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022344,12,0,'2023-10-03','2023-10-03','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022345,39,0,'2023-12-28','2023-12-28','','',NULL,'not_paid','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022346,37,0,'2023-12-27','2024-01-03','1 YEAR warranty DVR, HDD, Camera, TV','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022347,37,0,'2024-01-16','2024-01-16','','',NULL,'draft','not_delivered','not_approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(2022348,37,0,'2024-01-16','2024-01-16','','',NULL,'not_paid','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022349,43,0,'2024-03-05','2024-03-05','','',NULL,'not_paid','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022350,46,6,'2024-04-02','2024-04-02','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022351,12,0,'2024-04-15','2024-04-20','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022352,46,6,'2024-04-06','2024-04-21','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022353,48,0,'2024-04-20','2024-04-28','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022354,12,0,'2024-04-30','2024-04-30','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022355,12,0,'2024-03-18','2024-05-01','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022356,12,0,'2024-05-06','2024-05-06','','',NULL,'draft','not_delivered','not_approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022357,12,0,'2024-05-06','2024-05-06','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022358,41,0,'2024-01-08','2024-01-08','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022359,12,0,'2024-06-12','2024-06-12','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022360,35,0,'2024-07-14','2024-07-14','<p>test</p>','',NULL,'draft','not_delivered','not_approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(2022361,21,0,'2024-07-15','2024-07-15','<p>test&nbsp;</p>','',NULL,'draft','not_delivered','not_approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(2022362,21,0,'2024-07-15','2024-07-15','<p>test</p>','',NULL,'draft','not_delivered','not_approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(2022363,51,7,'2024-07-14','2024-07-21','<p style=\"color: rgb(78, 94, 106);\">Advane Payment 2500 OMR</p><p style=\"color: rgb(78, 94, 106);\">After Cables Pulling 1700 OMR</p><p style=\"color: rgb(78, 94, 106);\">After Cables Terminations 1394 OMR</p><p style=\"color: rgb(78, 94, 106);\"><br></p><p style=\"color: rgb(78, 94, 106);\">need 7 days for cables pullin</p>','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022364,21,0,'2024-07-25','2024-07-25','<p>Test</p>','',NULL,'draft','not_delivered','not_approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(2022365,35,0,'2024-07-27','2024-08-03','<p>test</p>','',NULL,'draft','not_delivered','not_approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022366,12,0,'2024-06-06','2024-06-06','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022367,12,0,'2024-06-26','2024-06-26','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022368,51,0,'2024-09-29','2024-10-14','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022369,51,8,'2024-09-29','2024-11-07','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022370,53,0,'2024-10-22','2024-10-31','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022371,51,8,'2024-09-29','2024-11-07','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022372,51,8,'2024-09-29','2024-11-07','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022373,51,7,'2025-01-02','2025-01-16','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022374,64,0,'2025-02-17','2025-02-17','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022375,51,7,'2025-02-01','2025-03-06','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022376,58,0,'2025-03-26','2025-03-26','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022377,53,0,'2025-03-27','2025-03-27','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022378,12,0,'2025-04-12','2025-04-12','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022379,57,0,'2025-04-11','2025-04-11','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022380,59,0,'2025-04-11','2025-04-11','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022381,61,0,'2025-04-11','2025-04-11','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022382,68,0,'2025-05-04','2025-05-04','\nPayment :\nAdvance Payment 60%\nItem Delivery 20%\nAfter Project submission 20%\n\n\n1 Year warranty  on  Active items ( Switch , Access points)\nCivil work is not included in quotation.\n','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022383,68,0,'2025-05-08','2025-05-08','Payment :\nAdvance Payment 60%\nItem Delivery 20%\nAfter Project submission 20%\n\n\n1 Year warranty  on  Active items ( Switch , Access points)\nCivil work is not included in quotation.\n\n','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022384,69,0,'2025-05-21','2025-05-18','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,1,45,0),(2022385,8,0,'2025-04-14','2025-06-04','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,38,0),(2022386,12,0,'2025-03-26','2025-03-26','PO number 5170013113','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'fixed_amount','',NULL,0,1,44,0),(2022387,56,0,'2025-04-12','2025-04-12','PO#  5170013162','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,40,0),(2022388,12,0,'2025-04-11','2025-04-11','PO number 5170013194','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,41,0),(2022389,12,0,'2025-04-11','2025-04-11','PO number 5170013195','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,1,46,0),(2022390,12,0,'2025-04-11','2025-04-11','PO number 5170013570','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,1,47,0),(2022391,24,0,'2025-07-03','2025-07-10','1 year warranty ','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,48,0),(2022392,46,6,'2025-02-12','2025-07-07','1 Year warranty ','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,1,50,0),(2022393,12,0,'2025-07-15','2025-07-28','PO 5170014658','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,51,0),(2022394,56,0,'2025-07-15','2025-07-28','PO:  5170014727','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,52,0),(2022395,56,0,'2025-07-15','2025-07-28','PO:  5170014699','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,53,0),(2022396,68,0,'2025-07-25','2025-08-04','','',NULL,'not_paid','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0.01,'fixed_amount','',NULL,0,1,56,0),(2022397,12,0,'2025-07-15','2025-07-28','PO 5170015023','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,57,0),(2022398,56,0,'2025-07-15','2025-07-28','','',NULL,'draft','delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022399,19,0,'2025-06-04','2025-07-30','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,7,65,0),(2022400,19,0,'2025-05-30','2025-07-30','Villa A\n1 Year warranty  on  Active items ( Switch, AP,Controller, NVR , Camera)','',NULL,'draft','not_delivered','not_approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022401,19,0,'2025-07-01','2025-07-01','Villa A\n1 Year warranty  on  Active items ( Switch , Access points, Controller, Nvr, HDD, Camreas)\n','',NULL,'not_paid','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022402,12,0,'2025-07-25','2025-08-20','1 Year warranty  on  Active items ( Camera, Intercom)\n','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022403,65,0,'2025-02-20','2025-09-09','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,58.4,'fixed_amount','before_tax',NULL,0,0,0,0),(2022404,51,0,'2025-07-01','2025-10-06','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,1,67,0),(2022405,66,0,'2025-12-06','2025-12-09','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022406,68,0,'2025-12-23','2025-12-25','1 Year warranty  on  Active items ( Switch , Access points)\nCivil work is not included in quotation.\n','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022407,19,0,'2025-10-10','2026-01-14','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022408,80,0,'2026-02-03','2026-02-03','\n3 months warranty\n','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022409,30,0,'2026-02-04','2026-02-04','1 Year warranty on Active items ( NVR, CCTV Camera, HDD, Switch , Access points)\n\nFREE 2 NVR HARDWARE UPGRADE \nFREE 2 PDU\n','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022410,51,0,'2026-02-08','2026-02-08','1 Year warranty  on  Active items \nController ans Switches started from 7 Jan 2026\n Access points started from 8 Feb 2026','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2022411,46,0,'2026-02-08','2026-02-08','1 Year warranty  on  Active items \nNVR - started on 8 Feb 2026\nSwitch will start on 30 Feb 2026 ( installtion during Ramdhan 2026\nAccess points - started from 21 Dec 2025\nCamera - Started on 13- Jan 2026','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,1,68,0),(2022412,79,0,'2026-02-25','2026-02-26','3 Month warranty on NEC PBX','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0);

--
-- Table structure for table `TECH_BOULEVARDitem_categories`
--

CREATE TABLE `TECH_BOULEVARDitem_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDitem_categories`
--

INSERT INTO `TECH_BOULEVARDitem_categories` VALUES (1,'IP CAMERA',0),(2,'ANALOGE CAMERA',0),(3,'NVR',0),(4,'DVR',0),(5,'NEC PBX',0),(6,'GRAND STREAM UCM',0),(7,'NEC TELEPHONEY SYSTEM',0),(8,'DESK PHONES',0),(9,'NEC PARTS',0),(10,'CABINETS ITEMS',0),(11,'CABLING',0),(12,'PIPE',0),(13,'SWITCH',0),(14,'AP',0),(15,'Controller',0),(16,'Controller',1),(17,'FIXING',0),(18,'Grandstream Phones',0),(19,'INTERCOM',0),(20,'DOOR ACCESS',1),(21,'Computer Accessories',0),(22,'Door Access',0),(23,'SOUND SPEAKER SYSTEM',0),(24,'OTHER',1),(25,'OTHER',0),(26,'Wifi Camera',0),(27,'SERVERS',0);

--
-- Table structure for table `TECH_BOULEVARDitems`
--

CREATE TABLE `TECH_BOULEVARDitems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cost` double NOT NULL,
  `rate` double NOT NULL,
  `category_id` int(11) NOT NULL,
  `item_type` enum('product','service') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'product',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=306 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDitems`
--

INSERT INTO `TECH_BOULEVARDitems` VALUES (1,'DS-2CD1053G0',NULL,'IP OUTDOOR CAMERA',22,0,1,'product',0),(2,'Hikvision DS-2CD1043G0 Outdoor Network Camera 4 mp','','',15,23,1,'product',0),(3,'DS-2CD1023G0',NULL,'IP OUTDOOR CAMERA',0,0,1,'product',0),(4,'DS-2CD1023G0E',NULL,'IP OUTDOOR CAMERA',0,0,1,'product',0),(5,'DS-2CD1153G0',NULL,'IP INDOOR CAMERA',23,0,1,'product',0),(6,'Hikvision DS-2CD1143G0  4 MP Indoor Network  IP DOM Camera ','','',15,24,1,'product',0),(7,'DS-2CD1123G0',NULL,'IP INDOOR CAMERA',0,0,1,'product',0),(8,'DS-2CD1123G0E',NULL,'IP INDOOR CAMERA',0,0,1,'product',0),(9,'DS-2CD1353G0',NULL,'',0,0,1,'product',1),(10,'DS-2CD1343G0',NULL,'',0,0,1,'product',1),(11,'DS-2CD1323G0',NULL,'',0,0,1,'product',1),(12,'DS-2CD1323G0E',NULL,'',0,0,1,'product',1),(13,'DS-2CD1653G0',NULL,'',0,0,1,'product',1),(14,'DS-2CD1643G0',NULL,'',0,0,1,'product',1),(15,'DS-2CD1623G0',NULL,'',0,0,1,'product',1),(16,'DS-2CD1753G0',NULL,'',0,0,1,'product',1),(17,'DS-2CD1743G0',NULL,'',0,0,1,'product',1),(18,'DS-2CD1723G0',NULL,'',0,0,1,'product',1),(19,'DS-2CD1H53G0',NULL,'',0,0,1,'product',1),(20,'DS-2CD1H43G0',NULL,'',0,0,1,'product',1),(21,'DS-2CD1H23G0',NULL,'',0,0,1,'product',1),(22,'DS-2cd2443G0-IW',NULL,'',0,0,1,'product',1),(23,'NEC TELEPHONEY SYSTEM PACKAGE','TELEPHONEY SYSTEM Package\nSystem with (308 card)\n5 digital phones\nUnloaded Patch Panel\nInstalltion and programming','',180,280,5,'product',0),(24,'ANALOGE PHONE','','',10,13.2,8,'product',0),(25,'308 CARD','','',40,55,9,'product',0),(26,'6u CABINET','','',26,33,10,'product',0),(27,'Unloaded PATCH PANNEL 24 port','','',6.5,11,10,'product',0),(28,'RJ45 Module keystone cat6','','',0.9,1.2,10,'product',0),(29,'RJ45 Module keystone cat6','','',1,1.3,10,'product',0),(30,'RJ45 phase plate Dual','','',1.6,1.9,10,'product',0),(31,'PDU 6 WAY 13A','','',7,9,10,'product',0),(32,'CABLING','CABLE BULLING','',1,30,11,'service',0),(33,'PIPE','','',0.25,20,12,'product',0),(34,'TL-EAP650 Ceiling mount','ACCESS POINT','',40.5,64,14,'product',0),(35,'TL-SG1210P POE SWITCH 8 PORTS','','',25,28,13,'product',0),(36,'HIKVISION CAT6 Roll 300 MTR','','',41,45,11,'product',0),(37,'RJ-45 connectors','','',7,10,11,'product',0),(38,'CRIMPING TOOL','','',3.5,6,11,'product',0),(39,'RJ-45 Cable Teaster','','',3,6,11,'product',0),(40,'TL-OC200 OMADO CLOUD CONTROLLER','','',26,36,15,'product',0),(41,'TL-EAP225','','',30,39,14,'product',0),(42,'FIXING & Programming','','',5,10,17,'service',0),(43,'FIBER PATCH CORD 20 MTR','','',6.6,10,11,'product',0),(44,'schneider cat 6 Roll','','',40,54.5,11,'product',0),(45,'Grandstream HD IP Phone GXP214','','',35,45,18,'product',0),(46,'Hikvision PTZ DS-2DE7A432IW-AEB(T5)','7-inch 4 MP 32X Powered by DarkFighter IR Network Speed Dome\nDetects up to 5 faces simultaneously.\nSupports detecting, capturing, grading, selecting of face in motion, and output the best face picture of the face','',198,235,1,'product',0),(47,'Hikvision NVR DS-7608NI-Q1/8p','NVR 8 channel with 8 POE switch with 1 HDD slot','',43,54,3,'product',0),(48,'HIKVISION NVR DS-7616NI-Q2/16P','NVR 16 channel with 16 POE port switch with 2 HDD slot','',55,72,3,'product',0),(49,'2 TB HDD WD PURPLE','','',19,23,3,'product',0),(50,'Hikvision NVR DS-7608NI-K1/8P','Nvr with Built in poe switch','',48.5,52,3,'product',0),(51,'Hikvision DS-2CD2183G2-I 8 MP INDOOR IP CAMERA WDR','','',36,39.5,1,'product',0),(52,'27u Wheels Cabinet 600 x 600','','',140,169,10,'product',0),(53,'RJ45 Module Keystone Cat6 Press','','',2.1,2.9,10,'product',0),(54,'1u Brush','','',2.4,3.4,10,'product',0),(55,'Shelf 470x300','','',5,6.2,10,'product',0),(56,'Patchcord cat6 a 1mtr Grey','','',1.6,1.9,10,'product',0),(57,'Patchcord cat6 1mtr Grey','','',0.8,1,10,'product',0),(58,'UPS 30 MINUTES','','',33,43,10,'product',0),(59,'NVR DS7732NI-k4','32 chanel','',88,108,3,'product',1),(60,'NEC TELEPHONEY SYSTEM','CPU card\n24 Extensions ports\n9 CO LINES\n1 PRI CARD\n4 slots Chassis\n','',300,440,5,'product',0),(61,'NEC DIGITAL Phone 12 button ','','',17,21.5,8,'product',0),(62,'NEC DIGITAL Phone 24 button ','','',19,24,8,'product',0),(63,'Hikvision DS-3E0526P E/m 24 Giga Port POE Switch','24 Giga Port POE Switch','',88,108,13,'product',0),(64,'TL-SG1024D 24 Giga port Switch','24 Giga port Switch','',26,42,13,'product',0),(65,'Hikvision DS-2CD2083G2 Outdoor AcuSense CAMERA 8mp ','8 MP OUTDOOR WDR CAMERA','',36,39.5,1,'product',0),(66,'8 TB HDD PURPLE ','','',48,69,3,'product',0),(67,'Hikvision IDS-7208HUHI-MI 8 chanel DVR','8 chanel DVR, SUPPORT til 8MP','',48,53,4,'product',0),(68,'Hikvision IDS-7208HUHI-M2 8 Chanel DVR','8 Chanel DVR, SUPPORT Til 8MP, 2HDD slots','',50,55,4,'product',0),(69,'Hikvision DS-2CE76U1T-ITPF ANALOGE indoor ir CAMERA 8MP','','',13.5,16.5,2,'product',0),(70,'Hikvision DS-2CE12UF3T-E ANALOGE OUTDOOR COLOR CAMERA 8MP','','',28,32,2,'product',0),(71,'POWER SUPPLY DB 12V 10A 9 CHANEL','','',6.5,9,4,'product',0),(72,'TL-SG1008D 8 PORTS GIGA SWITCH','','',7.9,12,13,'product',0),(73,'TL-SG1016PE GIGA PORTS','8 Ports POE+\n8 Ports none POE','',43.5,55.5,13,'product',0),(74,'HIKVISION NVR DS-7616NI-K2','NVR 16 CHANEL\nSUPPORT UNTIL 8 MP\nNON POE\n2 HDD SLOTS','',37,42,3,'product',0),(75,'4 TB HDD PURPPLUE','','',26,33,3,'product',0),(76,'HIK VISION DS-3E0518P E/M 16 PORT GIGA SWITCH','16 Port Gigabit Unmanaged POE Switch\n','',65,78,13,'product',0),(77,'HIKVISON DS-3E0316P E/M 16 PORT FAST ERHERNET POE SWITCH ','16 Port Fast Ethernet Unmanaged POE Switch','',52,67,13,'product',0),(78,'HIKVISION NVR DS-7616NI-K2/16P','16-ch 1U 16 PoE 4K NVR\nPOE BUILT IN SWITCH','',73,81,3,'product',0),(79,'TL- SG3452P JETSTREAM 48 PORT GIGA MANAGED SWITCH','JetStream 52-Port Gigabit L2+ Managed Switch with 48-Port PoE+','',139,179,13,'product',0),(80,'TL- SG2428P  JetStream 28-Port Gigabit Smart Switch With 24-Port PoE+','','',65,87,13,'product',0),(81,'HIKVISION NVR DS-7732NI-K4','32 CHANEL\nNON POE','',88,110,3,'product',0),(82,'Hikvision DS-2CD2047G2-LU 4 MP Color Fixed outdoor Mini Bullet Network Camera With Mic','','',31.5,35.5,1,'product',0),(83,'CIVIL WORK','','',30,30,11,'service',0),(84,'TRUNKING','','',10,10,11,'service',0),(85,'SCREEN 42 INCH','','',45,59,3,'product',0),(86,'GrandStream UCM6208','IP PBX Phone System\n8 Lines','',230,280,6,'product',0),(87,'GrandStream UCM6204','IP PBX Phone System\n4 Lines\n','',118,195,6,'product',0),(88,'CAT6 to HDMI ADAPTER WITH MOUSE','','',18,22,3,'product',0),(89,'Grandstream GXP2140 HD IP PHONE','','',36.8,42,18,'product',0),(90,'GrandStream UCM6304','','',325,395,6,'product',0),(91,'GrandStream GXP1625','GrandStream small Business HD IP PHONES 2 lines','',16,18,18,'product',0),(92,'GrandStream GXP2135','GrandStream HD IP PHONES 8 Lines, 2.8\" color LCD','',29.3,37,18,'product',0),(93,'TP-link EAP225- OUTDOOR','','',35,45,14,'product',0),(94,'Jet strem TL-SG2210P 8 Giga POE ports ','Managed Switch 8 POE+  Giga ports','',34.65,45,13,'product',0),(95,'42u Cabinnet 1000x600','with fan and 6way pdu','',199,245,10,'product',0),(96,'2u Shelf 750 heavy duty','','',13,13,10,'product',0),(97,'MOUSE PAD GEL','','',1,1.14,21,'product',0),(98,'USB PRINTER CABLE 5 MTR','','',1,1.2,21,'product',0),(99,'HDMI CABLE','','',2,3,21,'product',0),(100,'DP TO HDMI CABLE 3 MTR','','',3.5,4,21,'product',0),(101,'DP TO VGA ADAPTER','','',3.9,4,21,'product',0),(102,'SANDISK 64GB FLASH DRIVE','','',3.4,3.5,21,'product',0),(103,'2SIDE FLASH DRIE 16GB','','',2.4,2.5,21,'product',0),(104,'Hikvision DS-2CD1343GO-IUF 4 MP Network INDOOR DOM IP CAM WITH MIC','','',25,32,1,'product',0),(105,'Hikvision NVR DS7608Ni-k2','8 Cahnel NVR without POE','',36,41,3,'product',0),(106,'INTERCOM KEYPAD DS KD KP','','',19,23,19,'product',0),(107,'INTERCOM OUTDOOR STATION DS KD8003 IME1','BELL WITH CAMER','',26.5,33,19,'product',0),(108,'Hikvision INTERCOM SCREEN DSKH6320 WTE1','','',27,31.5,19,'product',0),(109,'INTERCOM FRAME 2 MODULES DS KD ACW2','','',13.5,15.5,19,'product',0),(110,'YALE LOCK','','',18,20.5,19,'product',0),(111,'ADAPTOR 12V 5A','','',3,4,19,'product',0),(112,'Hikvision DS-2CE10UF3T-E ANALOGE OUTDOOR COLOR CAMERA 8MP','analog ColorVu 8mp','',26,28,2,'product',0),(113,'Hikvision DS-2CE16U1T-ITPF analoge outdoor camera 8MP','4K Fixed Mini Bullet Camera','',16,18.5,2,'product',0),(114,'Balun Adaptor','Cat6 To BNC Adaptor','',1.5,2,2,'product',0),(115,'9u Cabinet 600*600 wall Mount','','',39,49,10,'product',0),(116,'Single RJ45 Phase Plate','','',1,1.2,10,'product',0),(117,'TL-  SWITCH 48 PORT GIGA port','','',78,98,13,'product',0),(118,'Hikvision DS-2CD1043GO-IUF 4 MP Network OutdoorCAM WITH Mic','','',25,32,1,'product',0),(119,'Hikvision DS-2CD1143G0-IUF Indoor Network Camera 4mp Dom with mic','','',25,32,1,'product',1),(120,'4 port switch poe','','',20,22,13,'product',0),(121,'Hikvision DS-2CE10KF0T-PFS 2.8MM 3k COLORVU ANALOGE OUTDOOR CAMERA WITH MIC Plastic 20 MTR','','',10,15,2,'product',0),(122,'Hikvision DS-2CE76H0T-ITPFS 2.8 5MP INDOOR ANALOGE CAMERA WITH MIC','','',7.5,12,2,'product',0),(123,'Hikvision DS-7208HQHI-M1 DVR 8 channel 1-5mp support','','',23.6,42,4,'product',0),(124,'Hikvision DS-2CE12KF0T-FS 2.8MM 3K COLORVU ANALOGE OUTDOOR CAMERA WITH MIC Metal 40 mtr','','',11.3,15,2,'product',0),(125,'Hikvision DS-2CE70KF0T-PFS ANALOGE INDOOR CAMERA 4MP COLOR','','',11,13,2,'product',0),(126,'Hikvision DS-2CE17H0T-IT3F Outdoor Analog Camera 5mp','High quality imaging with 5 MP, 2560 × 1944 resolution\n2.8 mm, 3.6 mm, 6 mm, 8mm, 12mm fixed focal lens\nUp to 40 m IR distance for bright night imaging\nOne port for four switchable signals (TVI/AHD/CVI/CVBS)\nWater and dust resistant (IP67)','',8.9,13,2,'product',0),(127,'Hikvision DS-2CE16H0T-ITFS 5mp Outdoor mini analog camera 30 MTR  WDR mic','','',8,15,2,'product',0),(128,'Hikvision IDS-7216HUHM-M2/S 16 CAHNNEL DVR SUPPORT 1-8 MP','','',78,79,4,'product',0),(129,'Hikvision IDS-7216HQHI-M2/S 16 CHANNEL DVR SUPPORT 1-4 MP','','',43,63,4,'product',0),(130,'POWER SUPPLY DB 12V 10A 16 CHANEL','','',10,16,4,'product',0),(131,'4u cabinet 530*350','','',10.5,15.5,10,'product',0),(132,'TL-EAP610','Access Point AX1800- Wifi6 ','',26.5,38,14,'product',0),(133,'Hikvision NVR DS-7608NI-Q2/8p','NVR 8 channel with 8 POE switch with 2 HDD slot\nجهاز تسجيل 8 قنوات ','',45,57,3,'product',0),(134,'Intercom kit DS-KIS602','DS-KD8003-IME1/Surface x1\nDS-KH6320-WTE1 x1 Screen\n4 port poe switch\n16GB TF card x1','',54,75,19,'product',0),(135,'HIKVISION NVR DS-7616NI-Q2/16P','16-Ch 1U 16 PoE 4K NVR\nPOE BUILT IN SWITCH','',57,72,3,'product',1),(136,'HIKVISION NVR DS-7616NI-Q2','16 Chanel- None POE','',32,45,3,'product',0),(137,'DS-2CD2047G2-LU 4 MP ColorVu Fixed Mini Bullet Network Camera with mic','4 MP ColorVu Fixed Mini Bullet Network Camera','',31.5,34.5,1,'product',1),(138,'Hikvision NVR DS7608Ni-K1','8 Chanel NVR\nNone POE','',27,32,3,'product',0),(139,'TL-SG1218MPE 16 Giga POE Port EASY SMART Switch  Vlan','16× PoE+ gigabit RJ45 ports, 2× gigabit non-PoE RJ45 ports and 2× combo gigabit SFP slots.','',50,67,13,'product',0),(140,'Hikvision DS-2CD2345G0P-I 180° 4 MP Super Wide Angle Fixed Turret Indoor Network Camera','','',36.4,39.5,1,'product',0),(141,'Hikvision DS-2CD2T45G0P-I  4 MP Super Wide Angle 180° outdoor Fixed Bullet Network Camera','','',42,47,1,'product',0),(142,'Hikvision DS-2CD2955FWD-I 5 MP Fisheye 180° Fixed Indoor Dome Network Camera','','',54,58,1,'product',0),(143,'Hikvision Junction camera Box DS-1280ZJ-XS','BOX','',2.8,3.4,2,'product',0),(144,'27u Wheels Cabinet 800 X 600','Including 4 Fans + 6 way PDU','',165,185,10,'product',0),(145,'TL-EAP110','','',11.6,15,14,'product',0),(146,'TL-EAP115','','',14.5,18,14,'product',0),(147,'TL-EAP245','','',35.5,39,14,'product',0),(148,'27u Wheels Cabinet 600 X 600 Fineen','','',120,145,14,'product',0),(149,'TL-OC300 OMADO CLOUD CONTROLLER','','',69,77,15,'product',0),(150,'Patchcord Cat6 50cm','','',0.55,0.8,10,'product',0),(151,'SCREEN 19 INCH','','',19,25,3,'product',0),(152,'6u CABINET 600*450','','',17,33,10,'product',0),(153,'Camera Stand 50cm','','',3.5,5.5,3,'product',0),(154,'SCREEN 22 INCH','','',20,25,3,'product',0),(155,'Camera PVC box','','',0.65,1,2,'product',0),(156,'TL-EAP650 Outdoor','','',37,48,14,'product',0),(157,'ZKT Biopro MH40','','',82,98,22,'product',0),(158,'PANASONIC KXT-7703 analoge phone','Desk analoge phone','',5.8,9.5,8,'product',0),(159,'GIGASET A270','Cordless phone','',9.5,13.5,8,'product',0),(160,'BOSCH 6W CELLING SPEAKER','','',7.5,9.5,23,'product',0),(161,'SPEAKER CABLE ROLL 100 MTR','','',7.5,12.5,11,'product',0),(162,'CAT6 CABLE','','',0.14,0.185,11,'product',0),(163,'CABLE TERMINATION','','',0.1,10,11,'service',0),(164,'AMPLIFIER 2 ZONE','','',85,135,23,'product',0),(165,'VOLUME CONTROLLER','','',4,6.5,23,'product',0),(166,'INTERNET 1 MONTH DATA SUBSCRIPTION','','',25,25,24,'service',0),(167,'Hikvision DS-2CD2347G2 LU 2.8 INDOOR 4 MP IP Turret CAMERA COLOR WITH MIC','','',31.3,39.5,1,'product',0),(168,'.','','',1,10,25,'service',0),(169,'Hikvision Door Access control DS-K1T804BMF','','',24,38.5,22,'product',0),(170,'Hikvision Magnetic Lock DS-K4H258s','','',9,15.5,22,'product',0),(171,'Hikvision DS-K4H258-LZ Bracket for Magnetic Lock','','',4.4,6.8,22,'product',0),(172,'Lexo U Bracket for Magnetic Lock','','',3,4.9,22,'product',0),(173,'Lexo Exit Button ','','',2.2,3.2,22,'product',0),(174,'Lexo No Touch Exit Button ','','',0.001,0.002,22,'product',0),(175,'TLSG-1005D 5 Port Giga Switch','','',4.2,7.2,13,'product',0),(176,'Hikvision DS-2CD1047G0-L 4 MP Color  Fixed Bullet Network Camera','','',22.3,26.3,1,'product',0),(177,'Hikvision DS-2CD1057G0-L 5 MP Color Fixed Bullet Network Camera','','',33.3,36.3,1,'product',0),(178,'Hikvision DS-2CD2047G2H-LI 4 MP Color Fixed Outdoor Mini Bullet Network IP Camera With Mic','','',34.36,39.5,1,'product',0),(179,'Hikvision NVR DS-7604NI-Q1','4 Chanel NVR non POE','',21,25,3,'product',0),(180,'Hikvision DS-3E0510P POE 8 Porst giga switch','','',22.5,26.5,13,'product',0),(181,'Ezviz H8C PTZ Camera 2k Outdoor','','',16,22,26,'product',0),(182,'Ezviz PTZ Camera 4 Mp Indoor','','',12,15,26,'product',0),(183,'Class Pro EK42FHD ','','',105,175,3,'product',0),(184,'Impex IX32HD Screen','','',28.9,49.8,3,'product',0),(185,'Hikvision DS-2CE10HFT-F28 5MP ANALOG OUTDOOR COLORVU 20MTR','','',15.75,19.75,2,'product',0),(186,'Hikvision DS-2CE12HFT-F 5MP ANALOG OUTDOOR COLORVU','','',17,21,2,'product',0),(187,'Hikvision  Analog Intercom DS-KIS203T','','',26.8,36.8,19,'product',0),(188,'Hikvision  Analog Intercom DS-KIS202T','','',24,34,19,'product',0),(189,'Hikvision  Analog Intercom DS-KIS204T','','',28.5,38.5,19,'product',0),(190,'HikVision DS-9664NI-M8 NVR 64 chanel','64 chanel, None POE switch , 8 HDD slot','',330,530,3,'product',0),(191,'15u Cabinet 600*600 Wall Mount','','',37,59,10,'product',0),(192,'TL-SG1048 48-Port Gigabit  Switch','','',76.5,96,13,'product',0),(193,'TL-SG2218P JetStream 18-Port Gigabit Smart Switch with 16-Port PoE+','','',53,75,13,'product',0),(194,'Bose FS2SE Outdoor Speaker','','',48,70,23,'product',0),(195,'Speaker cable Global GSC1154','','',22,26,23,'product',0),(196,'Speaker Cable KABLO  2MKAB10 1.5mm 100 MTR','','',23,28,23,'product',0),(197,'SONOS Amplifier','','',340,380,23,'product',0),(198,'Hikvision DS-2CD1143G2-LIU 4 MP Indoor Dom SMART HYBRID  Network IP camera with Mic','','',16.5,23,1,'product',0),(199,'Hikvision DS-2CD2141G1 WIFI 4 MP Indoor Dome Network Camera with Build-in Mic','','',21,28,1,'product',0),(200,'Cat 6 Outdoor Cable','','MTR',0.5,0.65,11,'product',0),(201,'Hikvision DS-2CD2143G2-IU 4 MP WDR AcuSense Built-in Mic Fixed Dome Network Camera','','',26.35,31.5,1,'product',0),(202,'Hikvision DS-2CD2047G2H-LIU 4 MP  Outdoor Smart Hybrid Light with ColorVu Fixed Mini Bullet Network Camera with Mic','','',31.5,36.5,1,'product',0),(203,'TP Link Tapo c220 wifi Camera 4mp','','',11.5,15.5,26,'product',0),(204,'FIXING','','',10,10,17,'service',0),(205,'TL-EAP653 Ceiling Mount','','',24,37,14,'product',0),(206,'ZKT XFACEPRO','<p>Door Access support :</p><p>Face recognition \\ Finger print \\ Pass code \\ Cards</p>','',100,185,22,'product',0),(207,'test item ','<p>sdfsdfsd</p>','yy',50,60,2,'product',0),(208,'RJ45 Module Keystone Cat 6A tool less ','','',2.2,3.2,10,'product',0),(209,'Patchcord Cat 6A 15 CM','','',0.6,1,10,'product',0),(210,'Unloaded PATCH PANNEL 24 Port CAT 6A','','',9,14,10,'product',0),(211,'Belden Speaker 2 core  Cable 1.5 MM 305 MTR','','',88,93,11,'product',0),(212,'4G Router','','',16,16,25,'product',0),(213,'42u Cabinnet 800x600','','',280,360,10,'product',0),(214,'ZKT IFACE 990 Plus ','','',108,122.4,22,'product',0),(215,'HIKVISON DS-K1T342mfwx-e1','','',51.5,71.5,22,'product',0),(216,'Hikvision Analoge Amplifier 60 Watt','','',33,42,23,'product',0),(217,'Hikvision Ceiling Speaker 6 Watt','','',3.5,7.5,23,'product',0),(218,'ADAPTOR 12V 3A','','',2,3.5,19,'product',0),(219,'Hikvision DS-2CD2043G2-IU WDR AcuSense 4 MP IR Fixed outdoor Mini Bullet Network Camera With Mic','','',26,32,1,'product',0),(220,'PROGRAMMING','','',0,10,25,'service',0),(221,'ADAPTOR 12V 1A','','',2.5,3.5,19,'product',0),(222,'SD MEMORY CARD 32GB','','',2.3,3.5,25,'product',0),(223,'Hikvision DS-2CD1043G2-LIU 4 MP Network outdoor mini bullet CAM WITH Mic','','',16.85,23,1,'product',0),(224,'Hikvison DS-2CD2T43G2-2l 4 MP AcuSense Fixed Bullet Network Camera WDR 60 MTR','','',29,39,1,'product',0),(225,'Hikvision DS-2DE4415IW-DE PTZ 4 MP 15X Powered by DarkFighter IR Network Speed Dome','','',94,104,1,'product',0),(226,'Hikvision DS-2DE4425IW-DE PTZ 4 MP 25X Powered by DarkFighter IR Network Speed Dome','','',104,114,1,'product',0),(227,'Hikvison DS-2SE4C425MWG-E PTZ Dual lens TandemVu 4-inch 4 MP 25X Colorful & IR Network Speed Dome','','',115,135,1,'product',0),(228,'Hikvision Junction camera Box DS-1260ZJ','','',3.3,3.8,2,'product',0),(229,'GrandStream GXP1610','','',11,22,18,'product',0),(230,'GrandStream UCM6308A','','',235,348,6,'product',0),(231,'GrandStream UCM6308A IP BPX','','',298,428,6,'product',0),(232,'GrandStream WP810 Wifi Phone','','',29,38,18,'product',0),(233,'GrandStream WP820 Wifi Phone','','',52.7,64.2,18,'product',0),(234,'GrandStream WP825 Wifi Phone','','',52.4,62.4,18,'product',0),(235,'GrandStream WP822 Wifi Phone','','',32.3,42.3,18,'product',0),(236,'GrandStream GXP1782','','',19.3,29.3,18,'product',0),(237,'GrandStream UCM6304A','','',151.9,230.9,6,'product',0),(238,'GrandStream GVC3220 Video Conference Cam','','',518.1,613,18,'product',0),(239,'Ceiling Speaker elC52 6 watt - 5.25\"','','',17,23,23,'product',0),(240,'Audio Matrix HUB1616-16 Zone','','',650,763,23,'product',0),(241,'Amplifier 4 Channel eHSA 4-150 ','','',495,580,23,'product',0),(242,'Player one - Airplay and Media player','','',198,250,23,'product',0),(243,'Usb Player Ecler eSAS BT-usb','','',110,180,23,'product',0),(244,'Ceiling Speaker elC3 6 watt - 3\"','','',21,25,23,'product',0),(245,'Ecler Rock Speaker eRK108','','',70,120,23,'product',0),(246,'Ecler Garden speaker IG108','','',136,172,23,'product',0),(247,'DSPPA DSP2601 20W Waterproof Outdoor Wall Mount Speaker with Power Tap','','',18.5,27.3,23,'product',0),(248,'DSPPA DSP255II Outdoor Waterproof Column Speaker','','',19,28.7,23,'product',0),(249,'DSPPA DSP154H 15W Outdoor Waterproof Horn Speaker','','',13.9,19.2,23,'product',0),(250,'DSSPA DSP647 5 Inch Outdoor Waterproof Garden Rock Speaker 15W','','',15.5,24.8,23,'product',0),(251,'DSPPA MP610U 250W 6 Zones Paging Amplifier with USB/ SD/ FM/ Bluetooth','','',0,0,23,'product',0),(252,'DSPPA DSP3011 3 Inch High Quality Framless Ceiling Speaker 6W','','',0,0,23,'product',0),(253,'DSPPA DSP107W Pendant Speakers Sound Projector 15W','','',0,0,23,'product',0),(254,'DSPPA wall AMPLIFIER DM837 High-fidelity Bluetooth Digital Music Amplifier','','',0,0,23,'product',0),(255,'LENOVO ST550 Server','Xeon Silver 4120\n32 GB RAM\n','',882,965,27,'product',0),(256,'Fortinet FG-50G-SFP-BDL-950-DD','','',355,343,27,'product',0),(257,'Patchcord','','',0.8,1.2,10,'product',0),(258,'TL-SM311LS SFP Single Mode','','',6.6,12.9,13,'product',0),(259,'TL-SM311LM SFP MultiMode','','',6.6,12.9,13,'product',0),(260,'USB Wifi Dongle','','',5,7,21,'product',0),(261,'TP LINK Archer T3U usb Wifi Dongle','','',5.7,7.3,21,'product',0),(262,'TL-EAP655 Wall with poe port','','',29.5,39,14,'product',0),(263,'ZKT F18','Access Control Terminal with \nFiger Print, Card and Password Access\n','',50,163,22,'product',0),(264,'Lexo Switch No Touch with 2 remotes  swnotch2re','','',8.5,13.5,22,'product',0),(265,'EZVIZ H7c Dual Camera 4mp indoor','','',16.2,26,26,'product',0),(266,'DSSPA ROCK SPEAKER 15 Watt','','',15.5,32,23,'product',0),(267,'Ecler eAMBIT 103 speaker','','',21,35,23,'product',0),(268,'Ezviz H8C PRO PTZ Camera 4K Outdoor','','',20,26.2,26,'product',0),(269,'Ezviz H9C PTZ Camera 3K Outdoor','','',25.5,31,26,'product',0),(270,'DS-2CD2143G2-LIS2U 4 MP Acusense Smart Hybrid Light Fixed Dome Network Camera','','',26,33,1,'product',0),(271,'DS-2CD2T67G2P-LSU/SL 6 MP Panoramic ColorVu Fixed Bullet Network Camera','','',59,76,1,'product',0),(272,'DS-2CD2643G2-LIZS2U  4 MP Acusense Smart Hybrid Light Motorized Varifocal Bullet Network Camera','','',54,69,1,'product',0),(273,'DS-2CD2T47G2H-LI  4 MP Smart Hybrid Light with ColorVu Fixed Bullet Network Camera  60 MTR','','',44,53,1,'product',0),(274,'PVC CONDUIT OMAN-19MM','','',0.3,0.35,12,'product',0),(275,'Fiber Multi Mode 6 core','','',1,100,11,'product',0),(276,'TP EAP215-Bridge KIT 5GHZ 867 mbps','','',43.1,67.4,14,'product',0),(277,'TP EAP211-Bridge KIT 5GHZ 867 mbps','','',39,62.6,14,'product',0),(278,'GrandStream UCM6302V','Telephoney Server','',108,335,6,'product',0),(279,'GrandStream GRP2624 IP phone','8 lines, 12 SIP accounts\n1GB ports\nWifi supported ','',29,43,18,'product',0),(280,'GrandStream GRP2613W IP phone',' 6 SIP accounts \n1 Gigabit ethernet ports\nWifi Supported ','',22,35,18,'product',0),(281,'Hikvision iDS-2CD7A46G0/P-IZHS 4MP DeepinView ANPR Moto Varifocal Bullet Camera','','',155,227,1,'product',0),(282,'Hikvison DS-2CD2T43G2-4l 4 MP AcuSense Fixed Bullet Network Camera WDR 80 MTR','','',29,41,1,'product',0),(283,'TP EAP215-Bridge KIT 5GHZ 867 mbps','','',43.1,63.7,14,'product',1),(284,'Bose FreeSpace FS2C  Indoor loud Speaker ','','',30,42,23,'product',0),(285,'cat 6A Roll','','',60,69,11,'product',0),(286,'Hikvision Monitor 22 inch DS-D5022FN-C','','',24.5,29,3,'product',0),(287,'Hikvision DS-2CD2F42FWD IWS ptz dome network camera 4 mp','','',20,28,1,'product',0),(288,'Hi Power ceiling speakers 6w','','',4.2,7.5,23,'product',0),(289,'Hikvision DS-2CD1347G2H-LIU Network Turret Hybrid colorVu  camera 4 mp','','',22.3,27,1,'product',0),(290,'HIKVISION NVR DS-7732NXI-K4','جهاز تسجيل كاميرات سعة 32 كاميرا','',89,109,3,'product',0),(291,'Disspa Amplifier MP120UB 120 Watt','','',50,63,23,'product',0),(292,'Bose FS 360P Garden Speaker','','',93,99,23,'product',0),(293,'CAT 6A Cable Roll 500 MTR brand Excel','','',110,125,11,'product',0),(294,'Speaker Cable KABLO 2MKAB10 1.5mm  Roll 305 MTR','Speaker cable','',67,72,23,'product',0),(295,'Speaker cable','','',56,62,23,'product',0),(296,'TP Switch TL-SG1428PE  24 Giga port POE easy smart','','',61,71,13,'product',0),(297,'Hikvision Access Control DS-K1T502DBFWX-C','Access control, Intercom Camera, Card, Fingerprint, PIN','',54,69,22,'product',0),(298,'Hikvision INTERCOM SCREEN DS KH6350 WTE1 7 inch','','',24.43,31.5,19,'product',0),(299,'Hikvision DS KV8413 WME1','','',48,63,19,'product',0),(300,'Hikvision DS-3E1518P-EI/M 16 port Giga poe switch','','',35.5,41,13,'product',0),(301,'Ampllifier Pro Sound AT 1360 BT','','',155,179,23,'product',0),(302,'HIKVISION NVR DS-7616NXI-K2/16P  ','','',79,93.4,3,'product',0),(303,'4 TB HDD TOSHIBA','','',47,54,3,'product',0),(304,'Ezviz wifi indoor camera 3k','','',11,14.5,26,'product',0),(305,'Hikvision DS-D5022F2-1v2S (21.5 inch) HD monitor','شاشىة 21.5 ','',25,28.4,3,'product',0);

--
-- Table structure for table `TECH_BOULEVARDlead_source`
--

CREATE TABLE `TECH_BOULEVARDlead_source` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDlead_source`
--

INSERT INTO `TECH_BOULEVARDlead_source` VALUES (1,'Google',1,0),(2,'Facebook',2,0),(3,'Twitter',3,0),(4,'Youtube',4,0),(5,'Elsewhere',5,0);

--
-- Table structure for table `TECH_BOULEVARDlead_status`
--

CREATE TABLE `TECH_BOULEVARDlead_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDlead_status`
--

INSERT INTO `TECH_BOULEVARDlead_status` VALUES (1,'New','#f1c40f',0,0),(2,'Qualified','#2d9cdb',1,0),(3,'Discussion','#29c2c2',2,0),(4,'Negotiation','#2d9cdb',3,0),(5,'Won','#83c340',4,0),(6,'Lost','#e74c3c',5,0);

--
-- Table structure for table `TECH_BOULEVARDleads`
--

CREATE TABLE `TECH_BOULEVARDleads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `first_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date NOT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDleads`
--


--
-- Table structure for table `TECH_BOULEVARDleave_applications`
--

CREATE TABLE `TECH_BOULEVARDleave_applications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `leave_type_id` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `total_hours` decimal(7,2) NOT NULL,
  `total_days` decimal(5,2) NOT NULL,
  `applicant_id` int(11) NOT NULL,
  `reason` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('pending','approved','rejected','canceled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `checked_at` datetime DEFAULT NULL,
  `checked_by` int(11) NOT NULL DEFAULT '0',
  `paid_unpaid` tinyint(1) DEFAULT '1',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `leave_type_id` (`leave_type_id`),
  KEY `user_id` (`applicant_id`),
  KEY `checked_by` (`checked_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDleave_applications`
--


--
-- Table structure for table `TECH_BOULEVARDleave_types`
--

CREATE TABLE `TECH_BOULEVARDleave_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `max_allowed` int(11) DEFAULT '1',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDleave_types`
--

INSERT INTO `TECH_BOULEVARDleave_types` VALUES (1,'Casual Leave','active','#83c340','',1,0),(2,'Annual Leave','active','#83c340','',1,0),(3,'Emergency leave','active','#29c2c2','',1,0),(4,'Eid Vacation','active','#83c340','',1,0);

--
-- Table structure for table `TECH_BOULEVARDloans`
--

CREATE TABLE `TECH_BOULEVARDloans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `date` date DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDloans`
--


--
-- Table structure for table `TECH_BOULEVARDmessages`
--

CREATE TABLE `TECH_BOULEVARDmessages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Untitled',
  `message` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `from_user_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `status` enum('unread','read') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unread',
  `message_id` int(11) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `files` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted_by_users` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `message_from` (`from_user_id`),
  KEY `message_to` (`to_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDmessages`
--


--
-- Table structure for table `TECH_BOULEVARDmilestones`
--

CREATE TABLE `TECH_BOULEVARDmilestones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL,
  `due_date` date NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDmilestones`
--


--
-- Table structure for table `TECH_BOULEVARDnotes`
--

CREATE TABLE `TECH_BOULEVARDnotes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `client_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci,
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDnotes`
--


--
-- Table structure for table `TECH_BOULEVARDnotification_settings`
--

CREATE TABLE `TECH_BOULEVARDnotification_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event` varchar(250) NOT NULL,
  `category` varchar(50) NOT NULL,
  `enable_email` int(1) NOT NULL DEFAULT '0',
  `enable_web` int(1) NOT NULL DEFAULT '0',
  `notify_to_team` text NOT NULL,
  `notify_to_team_members` text NOT NULL,
  `notify_to_terms` text NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `event` (`event`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TECH_BOULEVARDnotification_settings`
--

INSERT INTO `TECH_BOULEVARDnotification_settings` VALUES (1,'project_created','project',0,1,'1','5','client_primary_contact,client_all_contacts',1,0),(2,'project_deleted','project',0,1,'1','5','project_members,client_primary_contact,client_all_contacts',2,0),(3,'project_task_created','project',0,1,'','5','project_members,task_assignee',3,0),(4,'project_task_updated','project',0,1,'','','task_assignee',4,0),(5,'project_task_assigned','project',0,1,'','','task_assignee',5,0),(7,'project_task_started','project',0,1,'','5','project_members,client_primary_contact,client_all_contacts',7,0),(8,'project_task_finished','project',0,0,'','','',8,0),(9,'project_task_reopened','project',0,0,'','','',9,0),(10,'project_task_deleted','project',0,1,'','','task_assignee',10,0),(11,'project_task_commented','project',0,1,'','','task_assignee',11,0),(12,'project_member_added','project',0,1,'','','project_members',12,0),(13,'project_member_deleted','project',0,1,'','','project_members',13,0),(14,'project_file_added','project',0,1,'','','project_members',14,0),(15,'project_file_deleted','project',0,1,'','','project_members',15,0),(16,'project_file_commented','project',0,1,'','','project_members',16,0),(17,'project_comment_added','project',0,1,'','','project_members',17,0),(18,'project_comment_replied','project',0,1,'','','project_members,comment_creator',18,0),(19,'project_customer_feedback_added','project',0,1,'','','project_members',19,0),(20,'project_customer_feedback_replied','project',0,1,'','','project_members,comment_creator',20,0),(21,'client_signup','client',0,0,'','','',21,0),(22,'invoice_online_payment_received','invoice',0,0,'','','',22,0),(23,'leave_application_submitted','leave',0,0,'','','',23,0),(24,'leave_approved','leave',0,1,'','','leave_applicant',24,0),(25,'leave_assigned','leave',0,1,'','','leave_applicant',25,0),(26,'leave_rejected','leave',0,1,'','','leave_applicant',26,0),(27,'leave_canceled','leave',0,0,'','','',27,0),(28,'ticket_created','ticket',0,1,'','6,7,5,11,12,1','client_all_contacts',28,0),(29,'ticket_commented','ticket',0,1,'','','client_primary_contact,ticket_creator',29,0),(30,'ticket_closed','ticket',0,1,'','','client_primary_contact,ticket_creator',30,0),(31,'ticket_reopened','ticket',0,1,'','','client_primary_contact,ticket_creator',31,0),(32,'estimate_request_received','estimate',0,0,'','','',32,0),(33,'estimate_sent','estimate',0,0,'','','',33,0),(34,'estimate_accepted','estimate',0,0,'','','',34,0),(35,'estimate_rejected','estimate',0,0,'','','',35,0),(36,'new_message_sent','message',0,0,'','','',36,0),(37,'message_reply_sent','message',0,0,'','','',37,0),(38,'invoice_payment_confirmation','invoice',0,0,'','','',22,0),(39,'new_event_added_in_calendar','event',0,0,'','','',39,0),(40,'recurring_invoice_created_vai_cron_job','invoice',0,0,'','','',22,0),(41,'new_announcement_created','announcement',1,1,'','','recipient',41,0),(42,'invoice_due_reminder_before_due_date','invoice',0,0,'','','',22,0),(43,'invoice_overdue_reminder','invoice',0,0,'','','',22,0),(44,'recurring_invoice_creation_reminder','invoice',0,0,'','','',22,0),(45,'project_completed','project',0,0,'','','',2,0),(46,'lead_created','lead',0,0,'','','',21,0),(47,'client_created_from_lead','lead',0,0,'','','',21,0),(48,'project_task_deadline_pre_reminder','project',0,1,'','','task_assignee',20,0),(49,'project_task_reminder_on_the_day_of_deadline','project',0,1,'','','task_assignee',20,0),(50,'project_task_deadline_overdue_reminder','project',0,1,'','','task_assignee',20,0),(51,'recurring_task_created_via_cron_job','project',0,1,'','','project_members,task_assignee',20,0),(52,'calendar_event_modified','event',0,0,'','','',39,0);

--
-- Table structure for table `TECH_BOULEVARDnotifications`
--

CREATE TABLE `TECH_BOULEVARDnotifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `notify_to` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `read_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `event` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL,
  `project_comment_id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `ticket_comment_id` int(11) NOT NULL,
  `project_file_id` int(11) NOT NULL,
  `leave_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `activity_log_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `lead_id` int(11) NOT NULL,
  `invoice_payment_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `estimate_request_id` int(11) NOT NULL,
  `actual_message_id` int(11) NOT NULL,
  `parent_message_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `announcement_id` int(11) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDnotifications`
--

INSERT INTO `TECH_BOULEVARDnotifications` VALUES (1,1,'','2022-06-14 07:31:32','','','project_created',1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(2,1,'','2022-06-14 07:33:11','','','project_created',2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1),(3,1,'','2022-06-21 10:51:29','','','project_deleted',2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(4,1,'','2023-05-28 08:55:53','','','project_created',3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(5,1,'','2023-07-04 23:41:29','','','project_created',4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(6,1,'','2024-03-04 19:56:36','','','project_created',5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(7,1,'','2024-04-02 18:51:14','','','project_created',6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(8,1,'','2024-07-21 07:32:08','','','project_created',7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(9,1,'','2024-10-31 08:06:29','','','project_created',8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

--
-- Table structure for table `TECH_BOULEVARDpayment_methods`
--

CREATE TABLE `TECH_BOULEVARDpayment_methods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'custom',
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `online_payable` tinyint(1) NOT NULL DEFAULT '0',
  `available_on_invoice` tinyint(1) NOT NULL DEFAULT '0',
  `minimum_payment_amount` double NOT NULL DEFAULT '0',
  `settings` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDpayment_methods`
--

INSERT INTO `TECH_BOULEVARDpayment_methods` VALUES (1,'Cash','custom','',0,0,0,'a:0:{}',0),(4,'Bank transfer / Card','custom','',0,0,0,'a:0:{}',0),(5,'Cheque','custom','',0,0,0,'a:0:{}',0);

--
-- Table structure for table `TECH_BOULEVARDpaypal_ipn`
--

CREATE TABLE `TECH_BOULEVARDpaypal_ipn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` tinytext COLLATE utf8_unicode_ci,
  `ipn_hash` longtext COLLATE utf8_unicode_ci NOT NULL,
  `ipn_data` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDpaypal_ipn`
--


--
-- Table structure for table `TECH_BOULEVARDpayroll`
--

CREATE TABLE `TECH_BOULEVARDpayroll` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `month` date NOT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDpayroll`
--


--
-- Table structure for table `TECH_BOULEVARDpayroll_detail`
--

CREATE TABLE `TECH_BOULEVARDpayroll_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payroll_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `salary` float(8,3) NOT NULL,
  `manual_deduction` float(8,3) NOT NULL,
  `manual_deduction_reason` text COLLATE utf8_unicode_ci,
  `manual_bounce` float(8,3) NOT NULL,
  `manual_bonus_reason` text COLLATE utf8_unicode_ci,
  `advance` float(10,3) NOT NULL,
  `loan` float(10,3) NOT NULL,
  `pasi_company` double DEFAULT '0',
  `pasi_employee` double DEFAULT '0',
  `job_s_company` double DEFAULT '0',
  `job_s_employee` double DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDpayroll_detail`
--


--
-- Table structure for table `TECH_BOULEVARDposts`
--

CREATE TABLE `TECH_BOULEVARDposts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `post_id` int(11) NOT NULL,
  `share_with` text COLLATE utf8_unicode_ci,
  `files` longtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDposts`
--


--
-- Table structure for table `TECH_BOULEVARDproject_comments`
--

CREATE TABLE `TECH_BOULEVARDproject_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `comment_id` int(11) NOT NULL DEFAULT '0',
  `task_id` int(11) NOT NULL DEFAULT '0',
  `file_id` int(11) NOT NULL DEFAULT '0',
  `customer_feedback_id` int(11) NOT NULL DEFAULT '0',
  `files` longtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDproject_comments`
--


--
-- Table structure for table `TECH_BOULEVARDproject_files`
--

CREATE TABLE `TECH_BOULEVARDproject_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` text COLLATE utf8_unicode_ci NOT NULL,
  `file_id` text COLLATE utf8_unicode_ci,
  `service_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `file_size` double NOT NULL,
  `created_at` datetime NOT NULL,
  `project_id` int(11) NOT NULL,
  `uploaded_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDproject_files`
--


--
-- Table structure for table `TECH_BOULEVARDproject_members`
--

CREATE TABLE `TECH_BOULEVARDproject_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `is_leader` tinyint(1) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDproject_members`
--

INSERT INTO `TECH_BOULEVARDproject_members` VALUES (1,1,1,1,0),(2,1,2,1,0),(3,1,3,1,0),(4,1,4,1,0),(5,1,5,1,0),(6,1,6,1,0),(7,1,7,1,0),(8,1,8,1,0);

--
-- Table structure for table `TECH_BOULEVARDproject_settings`
--

CREATE TABLE `TECH_BOULEVARDproject_settings` (
  `project_id` int(11) NOT NULL,
  `setting_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `setting_value` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `unique_index` (`project_id`,`setting_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDproject_settings`
--


--
-- Table structure for table `TECH_BOULEVARDproject_time`
--

CREATE TABLE `TECH_BOULEVARDproject_time` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime DEFAULT NULL,
  `status` enum('open','logged','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'logged',
  `note` text COLLATE utf8_unicode_ci,
  `task_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDproject_time`
--


--
-- Table structure for table `TECH_BOULEVARDprojects`
--

CREATE TABLE `TECH_BOULEVARDprojects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `start_date` date DEFAULT NULL,
  `deadline` date DEFAULT NULL,
  `client_id` int(11) NOT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT '0',
  `status` enum('open','completed','hold','canceled','pending','') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
  `labels` text COLLATE utf8_unicode_ci,
  `price` double NOT NULL DEFAULT '0',
  `starred_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `geo_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDprojects`
--

INSERT INTO `TECH_BOULEVARDprojects` VALUES (1,'AZZAN ALAMRI OFFICE ALMAWALEH','','2022-06-15','2022-06-18',2,'2022-06-14',1,'completed','',450,'',0,NULL,0),(2,'ALMUALEH VILLA','PBX PACKAGE\nCABLING\nCABINET TERMINATION','2022-06-15','2022-06-15',2,'2022-06-14',1,'open','',450,'',2022111,NULL,1),(3,'The Beauty Code','','2023-05-23','2023-06-30',10,'2023-05-28',1,'open','',0,'',2022119,NULL,0),(4,'Hilal Albusaidi House','','2023-06-25','2023-07-03',30,'2023-07-04',1,'open','',0,'',0,NULL,0),(5,'Almiran Fort','','2023-12-06',NULL,19,'2024-03-04',1,'open','',0,'',0,NULL,0),(6,'Almirani Fort','','2023-12-05',NULL,46,'2024-04-02',1,'open','',0,'',2022176,NULL,0),(7,'Al Bait Al Kabeer','<p>Muttrah</p>',NULL,NULL,51,'2024-07-21',1,'open','',0,'',2022197,NULL,0),(8,' MUTTRAH FORT','',NULL,NULL,51,'2024-10-31',1,'open','',0,'',0,NULL,0);

--
-- Table structure for table `TECH_BOULEVARDpurchase_order_items`
--

CREATE TABLE `TECH_BOULEVARDpurchase_order_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `purchase_order_id` int(11) NOT NULL,
  `tax_id` int(11) DEFAULT '0',
  `tax_id2` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDpurchase_order_items`
--

INSERT INTO `TECH_BOULEVARDpurchase_order_items` VALUES (1,34,'TL-EAP650 Ceiling mount','ACCESS POINT',5,'',40.5,202.5,0,1,1,0,0),(2,156,'TL-EAP650 wall mount','',2,'',40.5,81,0,1,0,0,1),(3,40,'TL-OC200 OMADO CLOUD CONTROLLER','',1,'',35,35,0,1,0,0,1),(4,93,'TP-link EAP225- OUTDOOR','',1,'',35,35,0,1,1,0,0),(5,40,'TL-OC200 OMADO CLOUD CONTROLLER','',1,'',28,28,0,1,1,0,0),(6,2,'Hikvision DS-2CD1043G0 Outdoor Network Camera 4 mp','',2,'',15,30,0,2,0,0,1),(7,5,'DS-2CD1153G0',NULL,1,'IP INDOOR CAMERA',23,23,0,2,0,0,1);

--
-- Table structure for table `TECH_BOULEVARDpurchase_order_payments`
--

CREATE TABLE `TECH_BOULEVARDpurchase_order_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  `payment_date` date NOT NULL,
  `payment_method_id` int(11) NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `purchase_order_id` int(11) NOT NULL,
  `status` enum('draft','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `transaction_id` int(11) DEFAULT '0',
  `prepayment_transaction_id` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDpurchase_order_payments`
--

INSERT INTO `TECH_BOULEVARDpurchase_order_payments` VALUES (1,278.775,'2023-07-03',4,'2023-07-05','','','',0,'MOBILE BANK TRANSFER',1,'draft',0,0,0,1,'2023-07-04 23:48:26');

--
-- Table structure for table `TECH_BOULEVARDpurchase_orders`
--

CREATE TABLE `TECH_BOULEVARDpurchase_orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_id` int(11) NOT NULL,
  `purchase_order_date` date NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `status` enum('draft','not_paid') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `approval_status` enum('not_approved','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_approved',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDpurchase_orders`
--

INSERT INTO `TECH_BOULEVARDpurchase_orders` VALUES (1,2,'2023-07-05',4,'','','not_paid','approved',0),(2,1,'2024-07-14',5,'','test','draft','not_approved',0);

--
-- Table structure for table `TECH_BOULEVARDpurchase_return_items`
--

CREATE TABLE `TECH_BOULEVARDpurchase_return_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `po_item_id` int(11) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `purchase_return_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDpurchase_return_items`
--


--
-- Table structure for table `TECH_BOULEVARDpurchase_returns`
--

CREATE TABLE `TECH_BOULEVARDpurchase_returns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_order_id` int(11) NOT NULL,
  `shipment_id` int(11) DEFAULT NULL,
  `supplier_id` int(11) NOT NULL DEFAULT '0',
  `payment_method_id` int(11) DEFAULT '0',
  `transaction_id` int(11) DEFAULT '0',
  `date` date NOT NULL,
  `status` enum('draft','approved') COLLATE utf8_unicode_ci DEFAULT 'draft',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDpurchase_returns`
--


--
-- Table structure for table `TECH_BOULEVARDroles`
--

CREATE TABLE `TECH_BOULEVARDroles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `permissions` mediumtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDroles`
--


--
-- Table structure for table `TECH_BOULEVARDsalary_advance`
--

CREATE TABLE `TECH_BOULEVARDsalary_advance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `amount` float NOT NULL DEFAULT '0',
  `date` date DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDsalary_advance`
--


--
-- Table structure for table `TECH_BOULEVARDsale_return_items`
--

CREATE TABLE `TECH_BOULEVARDsale_return_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sale_return_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `invoice_item_id` int(11) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `sort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDsale_return_items`
--

INSERT INTO `TECH_BOULEVARDsale_return_items` VALUES (1,1,34,15,22,0,0),(2,1,35,16,22,0,0),(3,1,36,17,2,0,0),(4,1,37,18,1,0,0),(5,1,39,19,1,0,0),(6,1,38,20,1,0,0),(7,1,40,21,1,0,0);

--
-- Table structure for table `TECH_BOULEVARDsale_returns`
--

CREATE TABLE `TECH_BOULEVARDsale_returns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `payment_method_id` int(11) DEFAULT '0',
  `transaction_id` int(11) DEFAULT '0',
  `date` date NOT NULL,
  `status` enum('draft','approved') COLLATE utf8_unicode_ci DEFAULT 'draft',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDsale_returns`
--

INSERT INTO `TECH_BOULEVARDsale_returns` VALUES (1,2022302,3,1,0,'2022-06-23','draft','',1);

--
-- Table structure for table `TECH_BOULEVARDsettings`
--

CREATE TABLE `TECH_BOULEVARDsettings` (
  `setting_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `setting_value` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'app',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `setting_name` (`setting_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDsettings`
--

INSERT INTO `TECH_BOULEVARDsettings` VALUES ('accepted_file_formats','jpg,jpeg,doc,pdf,csv,pptx,xlsx,docx,png,rar','app',0),('allow_partial_invoice_payment_from_clients','','app',0),('allowed_ip_addresses','','app',0),('app_title','TECH BOULEVARD','app',0),('attendance_password','94269935','app',0),('client_can_add_project_files','1','app',0),('client_can_comment_on_files','1','app',0),('client_can_comment_on_tasks','1','app',0),('client_can_create_projects','1','app',0),('client_can_create_tasks','1','app',0),('client_can_edit_tasks','1','app',0),('client_can_view_activity','1','app',0),('client_can_view_gantt','1','app',0),('client_can_view_milestones','1','app',0),('client_can_view_overview','1','app',0),('client_can_view_project_files','1','app',0),('client_can_view_tasks','1','app',0),('client_default_dashboard','','app',0),('client_message_own_contacts','1','app',0),('client_message_users','5','app',0),('company_address','C.R: 1379454\nPost Box No: 1599, Postal Code: 130\nMuscat, Oman\nVAT#  OM1100220493\nBank Account: \n0040091668001001\nalizz islamic bank','app',0),('company_email','tech.boulevard@hotmail.com','app',0),('company_name','TECH BOULEVARD','app',0),('company_phone','99017326','app',0),('company_vat_number','OM1100220493','app',0),('company_website','Instagram: @tech_boulevard','app',0),('currency_position','right','app',0),('currency_symbol',' /OMR','app',0),('date_format','d-m-Y','app',0),('decimal_separator','.','app',0),('default_bank','900','app',0),('default_currency','OMR','app',0),('default_due_date_after_billing_date','','app',0),('disable_client_login','1','app',0),('disable_client_signup','1','app',0),('email_protocol','','app',0),('email_sent_from_address','info@teamway.om','app',0),('email_sent_from_name','Teamway','app',0),('email_smtp_host','','app',0),('email_smtp_pass','','app',0),('email_smtp_port','','app',0),('email_smtp_security_type','none','app',0),('email_smtp_user','','app',0),('enable_attendance','','app',0),('enable_email_piping','','app',0),('enable_google_calendar_api','','app',0),('enable_push_notification','','app',0),('enable_rich_text_editor','0','app',0),('estimate_color','#054d7f ','app',0),('estimate_logo','a:1:{s:9:\"file_name\";s:36:\"_file629bb5783933b-estimate-logo.png\";}','app',0),('favicon','','app',0),('first_day_of_week','0','app',0),('hidden_client_menus','','app',0),('imap_email','info@teamway.om','app',0),('imap_host','','app',0),('imap_password','00000','app',0),('imap_port','','app',0),('imap_ssl_enabled','1','app',0),('initial_number_of_the_estimate','2022114','app',0),('initial_number_of_the_invoice','2022393','app',0),('invoice_color','#054d7f ','app',0),('invoice_footer','<p><br></p>','app',0),('invoice_logo','a:1:{s:9:\"file_name\";s:35:\"_file629b3a46e5ce8-invoice-logo.png\";}','app',0),('invoice_prefix','TAX INVOICE      ','app',0),('item_purchase_code','53434654','app',0),('language','english','app',0),('module_announcement','1','app',0),('module_attendance','','app',0),('module_chat','1','app',0),('module_estimate','1','app',0),('module_estimate_request','','app',0),('module_event','1','app',0),('module_expense','1','app',0),('module_help','','app',0),('module_invoice','1','app',0),('module_knowledge_base','1','app',0),('module_lead','1','app',0),('module_leave','1','app',0),('module_message','1','app',0),('module_note','1','app',0),('module_project_timesheet','','app',0),('module_ticket','','app',0),('module_timeline','1','app',0),('module_todo','1','app',0),('no_of_decimals','2','app',0),('project_reference_in_tickets','1','app',0),('pusher_app_id','929038','app',0),('pusher_cluster','eu','app',0),('pusher_key','2cbc86a72bfa9a85b0e5','app',0),('pusher_secret','53077cbb420c5e79c8f6','app',0),('rows_per_page','100','app',0),('scrollbar','native','app',0),('send_bcc_to','','app',0),('send_estimate_bcc_to','','app',0),('show_background_image_in_signin_page','yes','app',0),('show_logo_in_signin_page','yes','app',0),('show_recent_ticket_comments_at_the_top','1','app',0),('signin_page_background','','app',0),('site_logo','','app',0),('ticket_prefix','','app',0),('time_format','24_hours','app',0),('timezone','Asia/Muscat','app',0),('user_1_allowed_distance','100000','user',0),('user_1_dashboard','','user',0),('user_1_disable_push_notification','0','user',0),('user_1_hidden_topbar_menus','','user',0),('user_1_location','23.620058326708097,58.24233084570313','user',0),('user_1_notification_sound_volume','4','user',0),('user_1_personal_language','english','user',0),('user_10_dashboard','','user',0),('user_10_personal_language','english','user',0),('user_11_dashboard','','user',0),('user_2_dashboard','','user',0),('user_21_dashboard','','user',0),('user_21_personal_language','english','user',0),('user_23_dashboard','','user',0),('user_24_dashboard','','user',0),('user_24_personal_language','arabic','user',0),('user_25_dashboard','','user',0),('user_25_personal_language','english','user',0),('user_3_dashboard','','user',0),('user_4_dashboard','','user',0),('user_5_allowed_distance','100000000','user',0),('user_5_dashboard','6','user',0),('user_5_disable_push_notification','1','user',0),('user_5_hidden_topbar_menus','','user',0),('user_5_location','23.673522614041882,57.680654820312505','user',0),('user_5_notification_sound_volume','7','user',0),('user_5_personal_language','english','user',0),('user_6_dashboard','','user',0),('user_6_personal_language','english','user',0),('weekend','5,6','app',0);

--
-- Table structure for table `TECH_BOULEVARDshipment_items`
--

CREATE TABLE `TECH_BOULEVARDshipment_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `po_item_id` int(11) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `shipment_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDshipment_items`
--


--
-- Table structure for table `TECH_BOULEVARDshipments`
--

CREATE TABLE `TECH_BOULEVARDshipments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_order_id` int(11) NOT NULL,
  `supplier_id` int(11) NOT NULL DEFAULT '0',
  `date` date NOT NULL,
  `invoice_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `invoice_date` date DEFAULT NULL,
  `delivery_note_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `delivery_note_date` date DEFAULT NULL,
  `status` enum('draft','approved') COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDshipments`
--


--
-- Table structure for table `TECH_BOULEVARDsocial_links`
--

CREATE TABLE `TECH_BOULEVARDsocial_links` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `facebook` text COLLATE utf8_unicode_ci,
  `twitter` text COLLATE utf8_unicode_ci,
  `linkedin` text COLLATE utf8_unicode_ci,
  `googleplus` text COLLATE utf8_unicode_ci,
  `digg` text COLLATE utf8_unicode_ci,
  `youtube` text COLLATE utf8_unicode_ci,
  `pinterest` text COLLATE utf8_unicode_ci,
  `instagram` text COLLATE utf8_unicode_ci,
  `github` text COLLATE utf8_unicode_ci,
  `tumblr` text COLLATE utf8_unicode_ci,
  `vine` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDsocial_links`
--


--
-- Table structure for table `TECH_BOULEVARDstock_adjustments`
--

CREATE TABLE `TECH_BOULEVARDstock_adjustments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDstock_adjustments`
--

INSERT INTO `TECH_BOULEVARDstock_adjustments` VALUES (1,139,1,'',0),(2,168,1007,'',0),(3,168,9000,'',0),(4,207,100,'',0),(5,202,2,'',0),(6,199,21,'<p>test</p>',0),(7,207,-99,'',0),(8,207,99,'',0),(9,44,55,'',0),(10,168,90000,'',0),(11,222,1000,'',0),(12,285,9999,'',0),(13,66,10003,'',0),(14,40,1009,'',0),(15,168,-1,'',0),(16,168,99900000,'',0),(17,168,-99999000,'',0),(18,204,1002,'',0),(19,239,10017,'',0),(20,27,100017,'',0),(21,54,10016,'',0),(22,261,10011,'',0),(23,286,99999,'',0),(24,219,1037,'',0),(25,141,333,'',0),(26,262,1007,'',0),(27,132,1005,'',0),(28,288,20,'',0),(29,108,103,'',0),(30,134,100,'',0),(31,290,20,'',0),(32,79,111,'',0),(33,291,50,'',0),(34,218,50,'',0),(35,165,71,'',0),(36,29,1022,'',0),(37,53,1535,'',0),(38,28,1000,'',0),(39,150,1050,'',0),(40,55,1006,'',0),(41,48,1001,'',0),(42,78,1000,'',0),(43,136,1000,'',0),(44,167,1005,'',0),(45,140,1000,'',0),(46,82,1006,'',0),(47,143,1006,'',0),(48,75,1011,'',0),(49,107,1003,'',0),(50,106,1002,'',0),(51,109,1002,'',0),(52,191,1000,'',0),(53,31,1008,'',0),(54,210,1014,'',0),(55,299,1000,'',0);

--
-- Table structure for table `TECH_BOULEVARDsuppliers`
--

CREATE TABLE `TECH_BOULEVARDsuppliers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `contact_name` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alternative_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vat_number` text COLLATE utf8_unicode_ci,
  `note` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `advance_account_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDsuppliers`
--

INSERT INTO `TECH_BOULEVARDsuppliers` VALUES (1,'ATESCO','','','','','','','2023-07-04','','999999','','','','OM1100037082','',94,0,0),(2,'EYE WITNESS','','','','','','','2023-07-04','','999999','','','','OM1100037031','',95,0,0);

--
-- Table structure for table `TECH_BOULEVARDtask_status`
--

CREATE TABLE `TECH_BOULEVARDtask_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `key_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDtask_status`
--

INSERT INTO `TECH_BOULEVARDtask_status` VALUES (1,'To Do','to_do','#F9A52D',0,0),(2,'In progress','in_progress','#1672B9',1,0),(3,'Done','done','#00B393',2,0),(4,'holding','','#aab7b7',3,0);

--
-- Table structure for table `TECH_BOULEVARDtasks`
--

CREATE TABLE `TECH_BOULEVARDtasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `milestone_id` int(11) NOT NULL DEFAULT '0',
  `assigned_to` int(11) NOT NULL,
  `deadline` date DEFAULT NULL,
  `labels` text COLLATE utf8_unicode_ci,
  `points` tinyint(4) NOT NULL DEFAULT '1',
  `status` enum('to_do','in_progress','done') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'to_do',
  `status_id` int(11) NOT NULL,
  `start_date` date DEFAULT NULL,
  `collaborators` text COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `recurring` tinyint(1) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `recurring_task_id` int(11) NOT NULL DEFAULT '0',
  `no_of_cycles_completed` int(11) NOT NULL DEFAULT '0',
  `created_date` date NOT NULL,
  `next_recurring_date` date DEFAULT NULL,
  `reminder_date` date NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `deleted` tinyint(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDtasks`
--


--
-- Table structure for table `TECH_BOULEVARDtaxes`
--

CREATE TABLE `TECH_BOULEVARDtaxes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `percentage` double NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TECH_BOULEVARDtaxes`
--

INSERT INTO `TECH_BOULEVARDtaxes` VALUES (1,'VAT (5%)',5,0);

--
-- Table structure for table `TECH_BOULEVARDteam`
--

CREATE TABLE `TECH_BOULEVARDteam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `members` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDteam`
--


--
-- Table structure for table `TECH_BOULEVARDteam_member_job_info`
--

CREATE TABLE `TECH_BOULEVARDteam_member_job_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `date_of_hire` date DEFAULT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  `salary` double NOT NULL DEFAULT '0',
  `salary_term` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `working_hours` int(11) DEFAULT NULL,
  `yearly_leaves` int(11) DEFAULT NULL,
  `housing` float DEFAULT '0',
  `transportation` float DEFAULT '0',
  `telephone` float DEFAULT '0',
  `utility` float DEFAULT '0',
  `national` tinyint(4) DEFAULT '0',
  `pasi` tinyint(4) DEFAULT '1',
  `bank_title` text COLLATE utf8_unicode_ci,
  `account_title` text COLLATE utf8_unicode_ci,
  `account_no` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDteam_member_job_info`
--

INSERT INTO `TECH_BOULEVARDteam_member_job_info` VALUES (5,1,'0000-00-00',0,0,NULL,0,0,0,0,0,0,0,1,'bank_muscat','','');

--
-- Table structure for table `TECH_BOULEVARDticket_comments`
--

CREATE TABLE `TECH_BOULEVARDticket_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `files` longtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDticket_comments`
--


--
-- Table structure for table `TECH_BOULEVARDticket_types`
--

CREATE TABLE `TECH_BOULEVARDticket_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDticket_types`
--

INSERT INTO `TECH_BOULEVARDticket_types` VALUES (1,'General Support',0),(2,'One way',0),(3,'Two way',0);

--
-- Table structure for table `TECH_BOULEVARDtickets`
--

CREATE TABLE `TECH_BOULEVARDtickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `ticket_type_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `status` enum('new','client_replied','open','closed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
  `last_activity_at` datetime DEFAULT NULL,
  `assigned_to` int(11) NOT NULL DEFAULT '0',
  `creator_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `creator_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `labels` text COLLATE utf8_unicode_ci,
  `task_id` int(11) NOT NULL,
  `closed_at` datetime NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDtickets`
--


--
-- Table structure for table `TECH_BOULEVARDto_do`
--

CREATE TABLE `TECH_BOULEVARDto_do` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `labels` text COLLATE utf8_unicode_ci,
  `status` enum('to_do','done') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'to_do',
  `start_date` date DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TECH_BOULEVARDto_do`
--


--
-- Table structure for table `TECH_BOULEVARDtransactions`
--

CREATE TABLE `TECH_BOULEVARDtransactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `type` text NOT NULL,
  `is_manual` tinyint(1) NOT NULL DEFAULT '0',
  `reference` text,
  `bank_cash` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TECH_BOULEVARDtransactions`
--

INSERT INTO `TECH_BOULEVARDtransactions` VALUES (1,'2022-06-14','Invoice Payment Received: INVOICE #2022303',0,NULL,0,0),(2,'2022-06-14','Invoice Payment Received: INVOICE #2022302',0,NULL,0,1),(3,'2022-06-20','Invoice Payment Received: INVOICE #2022303',0,NULL,0,0),(4,'2022-06-20','Invoice Payment Received: INVOICE #2022303',0,NULL,0,0),(5,'2022-06-21','Invoice: INVOICE #2022304',0,NULL,0,0),(6,'2022-06-21','Invoice Inventory: INVOICE #2022304',0,NULL,0,0),(7,'2022-06-26','Invoice: INVOICE #2022305',0,NULL,0,0),(8,'2022-06-26','Invoice Inventory: INVOICE #2022305',0,NULL,0,0),(9,'2022-06-26','Invoice: INVOICE #2022306',0,NULL,0,0),(10,'2022-06-26','Invoice Inventory: INVOICE #2022306',0,NULL,0,0),(11,'2022-06-21','Invoice: INVOICE #2022307',0,NULL,0,0),(12,'2022-06-21','Invoice Inventory: INVOICE #2022307',0,NULL,0,0),(13,'2022-06-13','Invoice: INVOICE #2022308',0,NULL,0,0),(14,'2022-06-13','Invoice Inventory: INVOICE #2022308',0,NULL,0,0),(15,'2022-06-20','Invoice Payment Received: INVOICE #2022308',0,NULL,0,0),(16,'2023-02-24','Invoice Inventory: INVOICE #2022315',0,NULL,0,0),(17,'2023-02-24','Invoice Inventory: INVOICE #2022315',0,NULL,0,0),(18,'2023-06-14','Invoice Payment Received: INVOICE #2022324',0,NULL,0,0),(19,'2023-07-21','Invoice Payment Received: INVOICE #2022324',0,NULL,0,1),(20,'2023-06-21','Invoice Payment Received: الفاتورة #2022324',0,NULL,0,0),(21,'2023-07-05','Purchase Order:  أمر شراء #1',0,NULL,0,0),(22,'2023-05-08','Invoice Payment Received: الفاتورة #2022317',0,NULL,0,0),(23,'2023-08-23','Invoice: INVOICE #2022330',0,NULL,0,0),(24,'2023-10-11','Invoice: INVOICE #2022335',0,NULL,0,0),(25,'2023-07-13','Invoice Payment Received: INVOICE #2022339',0,NULL,0,0),(26,'2023-08-11','Invoice Payment Received: INVOICE #2022340',0,NULL,0,0),(27,'2023-08-29','Invoice: INVOICE #2022341',0,NULL,0,0),(28,'2023-08-29','Invoice Payment Received: INVOICE #2022341',0,NULL,0,0),(29,'2023-11-16','Invoice Inventory: INVOICE #2022342',0,NULL,0,0),(30,'2023-12-30','Invoice Payment Received: INVOICE #2022345',0,NULL,0,0),(31,'2024-01-16','Invoice Payment Received: INVOICE #2022348',0,NULL,0,0),(32,'2024-03-21','Invoice Payment Received: INVOICE #2022349',0,NULL,0,0),(33,'2024-09-29','Invoice: INVOICE #2022368',0,NULL,0,0),(34,'2024-09-29','Invoice: INVOICE #2022369',0,NULL,0,0),(35,'2024-09-29','Invoice: INVOICE #2022371',0,NULL,0,0),(36,'2024-09-29','Invoice: INVOICE #2022372',0,NULL,0,0),(37,'2025-05-21','Invoice: INVOICE #2022384',0,NULL,0,1),(38,'2025-04-14','Invoice: INVOICE #2022385',0,NULL,0,0),(39,'2025-03-26','Invoice: INVOICE #2022386',0,NULL,0,1),(40,'2025-04-12','Invoice: INVOICE #2022387',0,NULL,0,0),(41,'2025-04-11','Invoice: INVOICE #2022388',0,NULL,0,0),(42,'2025-04-11','Invoice: INVOICE #2022389',0,NULL,0,1),(43,'2025-04-11','Invoice: INVOICE #2022390',0,NULL,0,1),(44,'2025-03-26','Invoice: INVOICE #2022386',0,NULL,0,0),(45,'2025-05-21','Invoice: INVOICE #2022384',0,NULL,0,0),(46,'2025-04-11','Invoice: INVOICE #2022389',0,NULL,0,0),(47,'2025-04-11','Invoice: INVOICE #2022390',0,NULL,0,0),(48,'2025-07-03','Invoice: INVOICE #2022391',0,NULL,0,0),(49,'2025-02-12','Invoice: INVOICE #2022392',0,NULL,0,1),(50,'2025-02-12','Invoice: INVOICE #2022392',0,NULL,0,0),(51,'2025-07-15','Invoice: TAX INVOICE      2022393',0,NULL,0,0),(52,'2025-07-15','Invoice: TAX INVOICE      2022394',0,NULL,0,0),(53,'2025-07-15','Invoice: TAX INVOICE      2022395',0,NULL,0,0),(54,'2025-07-25','Invoice: TAX INVOICE      2022396',0,NULL,0,1),(55,'2025-07-25','Invoice Payment Received: TAX INVOICE      2022396',0,NULL,0,0),(56,'2025-07-25','Invoice: TAX INVOICE      2022396',0,NULL,0,0),(57,'2025-07-15','Invoice: TAX INVOICE      2022397',0,NULL,0,0),(58,'2025-07-15','Invoice Inventory: TAX INVOICE      2022398',0,NULL,0,0),(59,'2025-06-04','Invoice: TAX INVOICE      2022399',0,NULL,0,1),(60,'2025-06-04','Invoice: TAX INVOICE      2022399',0,NULL,0,1),(61,'2025-06-04','Invoice: TAX INVOICE      2022399',0,NULL,0,1),(62,'2025-06-04','Invoice: TAX INVOICE      2022399',0,NULL,0,1),(63,'2025-06-04','Invoice: TAX INVOICE      2022399',0,NULL,0,1),(64,'2025-06-04','Invoice: TAX INVOICE      2022399',0,NULL,0,1),(65,'2025-06-04','Invoice: TAX INVOICE      2022399',0,NULL,0,0),(66,'2024-10-10','Invoice Payment Received: TAX INVOICE      2022401',0,NULL,0,0),(67,'2025-07-01','Invoice: TAX INVOICE      2022404',0,NULL,0,0),(68,'2026-02-08','Invoice: TAX INVOICE      2022411',0,NULL,0,0);

--
-- Table structure for table `Tarteebaccounts`
--

CREATE TABLE `Tarteebaccounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `acc_name` varchar(255) NOT NULL,
  `acc_code` varchar(255) DEFAULT NULL,
  `acc_parent` int(11) NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT '0',
  `is_inactive` int(11) NOT NULL DEFAULT '0',
  `acc_description` text,
  `module_id` int(11) DEFAULT '0',
  `module` enum('suppliers','team_members','clients','expenses','assets') DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Tarteebaccounts`
--

INSERT INTO `Tarteebaccounts` VALUES (1,'Assets','1',0,1,0,NULL,NULL,NULL,0),(2,'Liabilities','2',0,1,0,NULL,0,NULL,0),(3,'Equity','3',0,1,0,NULL,0,NULL,0),(4,'Expenses','4',0,1,0,NULL,0,NULL,0),(5,'Income','5',0,1,0,NULL,0,NULL,0),(6,'Others','6',0,1,0,NULL,0,NULL,0),(7,'Receviable','1-1',1,1,0,NULL,0,NULL,0),(8,'Bank and Cash','1-2',1,1,0,NULL,0,NULL,0),(9,'Current Assets','1-3',1,1,0,NULL,0,NULL,0),(10,'Non Current Assets','1-4',1,1,0,NULL,0,NULL,0),(11,'Prepayments','1-5',1,1,0,NULL,0,NULL,0),(12,'Fixed Assets','1-6',1,1,0,NULL,0,NULL,0),(13,'Payable','2-1',2,1,0,NULL,0,NULL,0),(14,'Credit Card','2-2',2,1,0,NULL,0,NULL,0),(15,'Current Liabilities','2-3',2,1,0,NULL,0,NULL,0),(18,'Non Current Liabilities','2-4',2,1,0,NULL,0,NULL,0),(19,'Equity','3-1',3,1,0,NULL,0,NULL,0),(20,'Current Year Earnings','3-2',3,1,0,NULL,0,NULL,0),(21,'Expenses','4-1',4,1,0,NULL,0,NULL,0),(22,'Depreciation','4-2',4,1,0,NULL,0,NULL,0),(23,'Cost of Revenue','4-3',4,1,0,NULL,0,NULL,0),(24,'Income','5-1',5,1,0,NULL,0,NULL,0),(25,'Other Income','5-2',5,1,0,NULL,0,NULL,0),(26,'Off Balance Sheet','6-1',6,1,0,NULL,0,NULL,0),(38,'Advance Payments','2-5',2,1,0,NULL,0,NULL,0),(77,'Retained Earnings A/c','3-2-1',20,0,0,'',0,'clients',0);

--
-- Table structure for table `Tarteebactivity_logs`
--

CREATE TABLE `Tarteebactivity_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `action` enum('created','updated','deleted') COLLATE utf8_unicode_ci NOT NULL,
  `log_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `log_type_title` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `log_type_id` int(11) NOT NULL DEFAULT '0',
  `changes` mediumtext COLLATE utf8_unicode_ci,
  `log_for` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `log_for_id` int(11) NOT NULL DEFAULT '0',
  `log_for2` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `log_for_id2` int(11) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebactivity_logs`
--

INSERT INTO `Tarteebactivity_logs` VALUES (1,'2023-03-08 08:42:55',1,'created','clients','',1,NULL,'',0,'',0,0);

--
-- Table structure for table `Tarteebannouncements`
--

CREATE TABLE `Tarteebannouncements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `share_with` mediumtext COLLATE utf8_unicode_ci,
  `created_at` datetime NOT NULL,
  `files` text COLLATE utf8_unicode_ci NOT NULL,
  `read_by` mediumtext COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebannouncements`
--


--
-- Table structure for table `Tarteebattendance`
--

CREATE TABLE `Tarteebattendance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` enum('incomplete','pending','approved','rejected','deleted') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'incomplete',
  `user_id` int(11) NOT NULL,
  `in_time` datetime NOT NULL,
  `out_time` datetime DEFAULT NULL,
  `checked_by` int(11) DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `checked_at` datetime DEFAULT NULL,
  `reject_reason` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `checked_by` (`checked_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebattendance`
--


--
-- Table structure for table `Tarteebchecklist_items`
--

CREATE TABLE `Tarteebchecklist_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `is_checked` int(11) NOT NULL DEFAULT '0',
  `task_id` int(11) NOT NULL DEFAULT '0',
  `sort` int(11) NOT NULL DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebchecklist_items`
--


--
-- Table structure for table `Tarteebci_sessions`
--

CREATE TABLE `Tarteebci_sessions` (
  `id` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `data` blob NOT NULL,
  KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebci_sessions`
--

INSERT INTO `Tarteebci_sessions` VALUES ('77a1c3d3864f4a45c6799ce29a5f39992c9f5e8a','5.37.196.127',1635758922,''),('3a1b4bf2c2672801d68e305e147faf79591ef00f','5.37.196.127',1635758943,''),('151818030d804cd5a1668b31a954b181f05167a0','54.227.157.146',1658393708,_binary '__ci_last_regenerate|i:1658393707;'),('8a6e502ca389123a91ed3f6955c8f0edced05288','54.227.157.146',1658393708,_binary '__ci_last_regenerate|i:1658393708;'),('b9eb5d2032dc17685a6426e6de10e9c144a2a5d0','161.8.109.180',1658398673,_binary '__ci_last_regenerate|i:1658398673;user_id|s:1:\"1\";'),('5b080300a170608f18bfb3749e19ef7044bab639','161.8.109.180',1658400925,_binary '__ci_last_regenerate|i:1658398673;user_id|s:1:\"1\";'),('3d15610a94035640eee978e7a3d0c2efede9825e','3.239.60.219',1658398805,_binary '__ci_last_regenerate|i:1658398805;'),('4f7c2272cbb2382bda0f8052d6213116c655ce27','3.239.60.219',1658398806,_binary '__ci_last_regenerate|i:1658398805;'),('de36e5057783074680b1493c71421c129223979d','161.8.109.180',1658400303,_binary '__ci_last_regenerate|i:1658400300;'),('fc1a68cccd34dbe6be364b5efc50f140da5cb62b','161.8.109.180',1658651300,_binary '__ci_last_regenerate|i:1658651297;'),('b9c3a2e0b00e1b8ca26d51005c4659de4d79464e','161.8.109.180',1658662761,_binary '__ci_last_regenerate|i:1658662761;user_id|s:1:\"1\";'),('0658da06c992b820b314dfcb73078b34c0e6c089','161.8.109.180',1658667414,_binary '__ci_last_regenerate|i:1658667414;user_id|s:1:\"1\";'),('e8c3760be0edbdd0c2b528c78739b2c861da8746','161.8.109.180',1658675148,_binary '__ci_last_regenerate|i:1658675147;user_id|s:1:\"1\";'),('6d606f3d5dd4a5189554e4b47a2b43347d77c7e9','161.8.109.180',1658675531,_binary '__ci_last_regenerate|i:1658675147;user_id|s:1:\"1\";'),('cbd4cc8a9227ee85128b94f6237a83889bf1a03b','161.8.109.180',1658932915,_binary '__ci_last_regenerate|i:1658930309;user_id|s:1:\"1\";'),('4d2b727976ad84e79f184d56ebfb665a39ae7d78','37.40.137.238',1658931429,_binary '__ci_last_regenerate|i:1658931423;'),('d6b68f93e95dea701a748cf9c53b11601185ece8','37.40.137.238',1658952134,_binary '__ci_last_regenerate|i:1658951965;user_id|s:1:\"1\";'),('598d98e9dded8f6f5337bb4b1d30b20e4a7d0455','54.36.117.76',1658952765,_binary '__ci_last_regenerate|i:1658952765;'),('c776230491b5329e1febf51356bec1fc7aaed0ac','54.36.117.76',1658952765,_binary '__ci_last_regenerate|i:1658952765;'),('7f57bc672f1f5219dd2c3a8dc3d36f3eca722a2f','5.37.60.178',1658997729,_binary '__ci_last_regenerate|i:1658997392;user_id|s:1:\"1\";'),('a9fc0d6b0d0d5beb2e1e61c9b30ef6c4d77820ab','5.37.60.178',1658997747,''),('48f93b4f82738aed5573a613018800afd0c74c66','44.192.25.180',1659521632,_binary '__ci_last_regenerate|i:1659521632;'),('0b91f74cbc99f34403d30c6336dedd25a84ce09d','44.192.25.180',1659521632,_binary '__ci_last_regenerate|i:1659521632;'),('69964c3da8d162f80a96d4438698919ed5b69ea7','54.196.135.43',1659947148,_binary '__ci_last_regenerate|i:1659947148;'),('05a0b6285c00f49f85142b18bcab6d7ac6a62eb8','54.196.135.43',1659947149,_binary '__ci_last_regenerate|i:1659947149;'),('288fe33d00b496597eb18d330583651e9e7b765c','35.170.81.189',1659947149,_binary '__ci_last_regenerate|i:1659947149;'),('d000a8dd800ba186903ef76c62fab03bddc7b76c','35.170.81.189',1659947149,_binary '__ci_last_regenerate|i:1659947149;'),('663f2dbaca0af104bbf5558423462a3fa7f6995d','161.8.109.180',1662984541,_binary '__ci_last_regenerate|i:1662983839;user_id|s:1:\"1\";'),('86d2c6fc3e957ceb99e2e1bf433c6e84a3839497','18.209.98.22',1662984144,_binary '__ci_last_regenerate|i:1662984144;'),('2237d1dfa70b2e650329a74637bb9ac531418e5f','18.209.98.22',1662984145,_binary '__ci_last_regenerate|i:1662984144;'),('843844eba90d0b96928f9b0fff7fc1162a8785b9','161.8.109.180',1662984211,_binary '__ci_last_regenerate|i:1662984211;'),('6668819f3c7ede6b3d43bfb0f57552ddd018525b','145.255.96.252',1662986643,_binary '__ci_last_regenerate|i:1662986639;'),('8cfd2169798b18777c4040d791d4b5fb2f748b86','145.255.96.252',1662987900,_binary '__ci_last_regenerate|i:1662986685;user_id|s:1:\"1\";'),('2c8402d56ada49481861299bbc8480952bac3e97','45.80.151.145',1678260072,_binary '__ci_last_regenerate|i:1678260072;user_id|s:1:\"1\";'),('ad4083ce7712806622bc9bbbdfc96d88e1f01556','54.91.149.48',1678259493,_binary '__ci_last_regenerate|i:1678259493;'),('7223224af1755a6e3e57cbb0a8dab10f304e3187','138.197.157.182',1678262859,_binary '__ci_last_regenerate|i:1678262859;'),('49d250572bdc397beb315c619167c6994d084408','45.80.151.145',1678260977,_binary '__ci_last_regenerate|i:1678260072;user_id|s:1:\"1\";'),('2821cd98d34bcd71bfd3514989121e313dcbc928','45.80.151.145',1678260993,''),('2c213260446d79c8db69f3c49d5d0a477a78ac35','138.197.157.182',1678264429,_binary '__ci_last_regenerate|i:1678264429;user_id|s:1:\"1\";'),('825deebf6edea56c6d2f4cc82ae23fbf959ac7d0','161.8.109.180',1678266492,_binary '__ci_last_regenerate|i:1678266492;user_id|s:1:\"1\";'),('9e5525ce3db4f87d040b7c50e1aab4fbef56082a','161.8.109.180',1678263742,_binary '__ci_last_regenerate|i:1678263742;'),('dfe080090ef536df40ab3fa348e1c4a738ee1a71','45.80.151.145',1678267250,_binary '__ci_last_regenerate|i:1678267250;user_id|s:1:\"1\";'),('90be8ea9cc91900ac500ff8462b616baae1aa74e','138.197.157.182',1678278510,_binary '__ci_last_regenerate|i:1678278510;user_id|s:1:\"1\";'),('81248da4c7a9a1b40d6ab5b4703d0f7bb0e168bc','44.195.90.88',1678264718,_binary '__ci_last_regenerate|i:1678264718;'),('4232f6b9d230200f435222d973d9a0b5198d97cf','161.8.109.180',1678273953,_binary '__ci_last_regenerate|i:1678264779;user_id|s:1:\"1\";'),('ffa3b24c236d41a4a0c6db99909e039176a40900','45.80.151.145',1678264836,_binary '__ci_last_regenerate|i:1678264836;user_id|s:1:\"1\";'),('805703599c34a338c10a1c718e3726bcaefdfbc1','138.197.157.182',1678266015,_binary '__ci_last_regenerate|i:1678266015;user_id|s:1:\"1\";'),('bad577dd00df0d89141ecbfceab0ea8030698092','161.8.109.180',1678278761,_binary '__ci_last_regenerate|i:1678278761;user_id|s:1:\"1\";'),('4b16628ec66b53c657f2af9bd6adc160508af927','45.80.151.145',1678276915,_binary '__ci_last_regenerate|i:1678276915;user_id|s:1:\"1\";'),('f6e6d0b73f848ee0b580e5afa4390395e5a754f8','161.8.109.180',1678280033,_binary '__ci_last_regenerate|i:1678276915;user_id|s:1:\"1\";'),('f63f4c9b5a0687357ebc6e2f06f1ce8e3fa3d4cc','161.8.109.180',1678277810,_binary '__ci_last_regenerate|i:1678277810;user_id|s:1:\"1\";'),('1693f8542f41fb57fe0c7446ae9ce0344de4715a','134.122.38.217',1678284575,_binary '__ci_last_regenerate|i:1678278510;user_id|s:1:\"1\";'),('dfa4d5e71ddc44dbde4bb959c600258dcf610fd2','161.8.109.180',1678279851,_binary '__ci_last_regenerate|i:1678278761;user_id|s:1:\"1\";'),('84ace60dd45f6acf2cda82be34b2cd7b23c7e064','45.80.151.145',1678280094,''),('73784b336da7f06bff398a403e0047bdca551f65','161.8.109.180',1678343377,_binary '__ci_last_regenerate|i:1678343197;user_id|s:1:\"1\";'),('c50c0efd15a62e85851043f5a103c8fdde67ac4a','45.80.151.145',1678344750,_binary '__ci_last_regenerate|i:1678344264;user_id|s:1:\"1\";'),('8ec95d6bd9d57bdd5bf0d07bf1b3ccba1620912d','45.80.151.145',1678344765,''),('277466b2cc1ea96b5b2136efcdda7044b15c49b7','45.80.151.145',1678351170,_binary '__ci_last_regenerate|i:1678351170;user_id|s:1:\"1\";'),('c646bfb7b25e68a7703ff6bb458a9d0c7a6b18b4','138.197.157.182',1678346798,''),('060fb9641c076fcc138cb419138ec80d3f175eba','45.80.151.145',1678360076,_binary '__ci_last_regenerate|i:1678351170;user_id|s:1:\"1\";'),('93af6284e7c9b25d58100a2f7c737185fd721b80','161.8.109.180',1678361118,_binary '__ci_last_regenerate|i:1678359157;user_id|s:1:\"1\";'),('b8efdd8c1ddc3ffd609af2341b9b8a74177d4f90','161.8.109.180',1678624946,_binary '__ci_last_regenerate|i:1678624855;user_id|s:1:\"1\";'),('eb9cc3a24574a8db6a16668e6631aee843bca4f5','161.8.109.180',1678624954,''),('1efb67485c9cb3e221c6a303cb3f0b79d3d7459f','161.8.109.180',1678866113,_binary '__ci_last_regenerate|i:1678866113;');

--
-- Table structure for table `Tarteebclient_groups`
--

CREATE TABLE `Tarteebclient_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebclient_groups`
--


--
-- Table structure for table `Tarteebclients`
--

CREATE TABLE `Tarteebclients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date NOT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `starred_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `group_ids` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `is_lead` tinyint(1) NOT NULL DEFAULT '0',
  `lead_status_id` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `lead_source_id` int(11) NOT NULL,
  `last_lead_status` text COLLATE utf8_unicode_ci NOT NULL,
  `client_migration_date` date NOT NULL,
  `vat_number` text COLLATE utf8_unicode_ci,
  `currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `disable_online_payment` tinyint(1) NOT NULL DEFAULT '0',
  `geo_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `advance_account_id` int(11) NOT NULL DEFAULT '0',
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebclients`
--

INSERT INTO `Tarteebclients` VALUES (1,'Ahmed','Oman',NULL,NULL,NULL,NULL,'2023-03-08',NULL,'98989898',NULL,'','',0,0,0,0,0,0,'','0000-00-00',NULL,NULL,0,NULL,0,0,NULL);

--
-- Table structure for table `Tarteebcontacts`
--

CREATE TABLE `Tarteebcontacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alternative_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `job_title` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebcontacts`
--


--
-- Table structure for table `Tarteebcustom_field_values`
--

CREATE TABLE `Tarteebcustom_field_values` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `related_to_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `related_to_id` int(11) NOT NULL,
  `custom_field_id` int(11) NOT NULL,
  `value` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebcustom_field_values`
--


--
-- Table structure for table `Tarteebcustom_fields`
--

CREATE TABLE `Tarteebcustom_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `placeholder` text COLLATE utf8_unicode_ci NOT NULL,
  `example_variable_name` text COLLATE utf8_unicode_ci,
  `options` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `field_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `related_to` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_table` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_invoice` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_estimate` tinyint(1) NOT NULL DEFAULT '0',
  `visible_to_admins_only` tinyint(1) NOT NULL DEFAULT '0',
  `hide_from_clients` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebcustom_fields`
--


--
-- Table structure for table `Tarteebcustom_widgets`
--

CREATE TABLE `Tarteebcustom_widgets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci,
  `content` text COLLATE utf8_unicode_ci,
  `show_title` tinyint(1) NOT NULL DEFAULT '0',
  `show_border` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebcustom_widgets`
--


--
-- Table structure for table `Tarteebdashboards`
--

CREATE TABLE `Tarteebdashboards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci,
  `data` text COLLATE utf8_unicode_ci,
  `color` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebdashboards`
--


--
-- Table structure for table `Tarteebdelivery_note_items`
--

CREATE TABLE `Tarteebdelivery_note_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT '0',
  `invoice_item_id` int(11) DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `delivery_note_id` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebdelivery_note_items`
--


--
-- Table structure for table `Tarteebdelivery_notes`
--

CREATE TABLE `Tarteebdelivery_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `project_id` int(11) NOT NULL DEFAULT '0',
  `delivery_note_date` date NOT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `status` enum('draft','approved','request_approval') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebdelivery_notes`
--


--
-- Table structure for table `Tarteebemail_templates`
--

CREATE TABLE `Tarteebemail_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `email_subject` text COLLATE utf8_unicode_ci NOT NULL,
  `default_message` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `custom_message` mediumtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebemail_templates`
--


--
-- Table structure for table `Tarteebenteries`
--

CREATE TABLE `Tarteebenteries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trans_id` int(11) NOT NULL,
  `account` int(11) NOT NULL,
  `type` enum('dr','cr') NOT NULL,
  `amount` double NOT NULL,
  `narration` text NOT NULL,
  `branch_id` int(11) DEFAULT '0',
  `concerned_person` int(11) DEFAULT '0',
  `unit` text,
  `reference` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Tarteebenteries`
--


--
-- Table structure for table `Tarteebestimate_forms`
--

CREATE TABLE `Tarteebestimate_forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL,
  `assigned_to` int(11) NOT NULL,
  `public` tinyint(1) NOT NULL DEFAULT '0',
  `enable_attachment` tinyint(4) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebestimate_forms`
--


--
-- Table structure for table `Tarteebestimate_items`
--

CREATE TABLE `Tarteebestimate_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `tax_id` int(11) DEFAULT '0',
  `tax_id2` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebestimate_items`
--


--
-- Table structure for table `Tarteebestimate_requests`
--

CREATE TABLE `Tarteebestimate_requests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `estimate_form_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `client_id` int(11) NOT NULL,
  `lead_id` int(11) NOT NULL,
  `assigned_to` int(11) NOT NULL,
  `status` enum('new','processing','hold','canceled','estimated') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebestimate_requests`
--


--
-- Table structure for table `Tarteebestimates`
--

CREATE TABLE `Tarteebestimates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `estimate_request_id` int(11) NOT NULL DEFAULT '0',
  `estimate_date` date NOT NULL,
  `valid_until` date NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `last_email_sent_date` date DEFAULT NULL,
  `status` enum('draft','sent','accepted','declined','approved','request_approval') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `discount_type` enum('before_tax','after_tax') COLLATE utf8_unicode_ci NOT NULL,
  `discount_amount` double NOT NULL,
  `discount_amount_type` enum('percentage','fixed_amount') COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebestimates`
--


--
-- Table structure for table `Tarteebevents`
--

CREATE TABLE `Tarteebevents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `location` mediumtext COLLATE utf8_unicode_ci,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci NOT NULL,
  `share_with` mediumtext COLLATE utf8_unicode_ci,
  `editable_google_event` tinyint(1) NOT NULL DEFAULT '0',
  `google_event_id` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  `color` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `recurring` int(1) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `last_start_date` date DEFAULT NULL,
  `recurring_dates` longtext COLLATE utf8_unicode_ci NOT NULL,
  `confirmed_by` text COLLATE utf8_unicode_ci NOT NULL,
  `rejected_by` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebevents`
--


--
-- Table structure for table `Tarteebexpense_categories`
--

CREATE TABLE `Tarteebexpense_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebexpense_categories`
--


--
-- Table structure for table `Tarteebexpenses`
--

CREATE TABLE `Tarteebexpenses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `expense_date` date NOT NULL,
  `category_id` int(11) NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `amount` double NOT NULL,
  `payment_mode` enum('bank','cash_on_hand','cheque','reimbursement','pt_cash') COLLATE utf8_unicode_ci NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` int(11) DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `client_id` int(11) NOT NULL DEFAULT '0',
  `status` enum('draft','request_approval','approved','rejected') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `transaction_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebexpenses`
--


--
-- Table structure for table `Tarteebgeneral_files`
--

CREATE TABLE `Tarteebgeneral_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` text COLLATE utf8_unicode_ci NOT NULL,
  `file_id` text COLLATE utf8_unicode_ci,
  `service_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `file_size` double NOT NULL,
  `created_at` datetime NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `eroom_id` int(11) NOT NULL DEFAULT '0',
  `uploaded_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebgeneral_files`
--


--
-- Table structure for table `Tarteebhelp_articles`
--

CREATE TABLE `Tarteebhelp_articles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `category_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `files` text COLLATE utf8_unicode_ci NOT NULL,
  `total_views` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebhelp_articles`
--


--
-- Table structure for table `Tarteebhelp_categories`
--

CREATE TABLE `Tarteebhelp_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `type` enum('help','knowledge_base') COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebhelp_categories`
--


--
-- Table structure for table `Tarteebinternal_transactions`
--

CREATE TABLE `Tarteebinternal_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `from_employee` int(11) NOT NULL,
  `to_employee` int(11) NOT NULL,
  `amount` float(10,3) NOT NULL,
  `note` text COLLATE utf8_bin NOT NULL,
  `status` enum('draft','approved') COLLATE utf8_bin NOT NULL DEFAULT 'draft',
  `transaction_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `Tarteebinternal_transactions`
--


--
-- Table structure for table `Tarteebinvoice_items`
--

CREATE TABLE `Tarteebinvoice_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `invoice_id` int(11) NOT NULL,
  `tax_id` int(11) DEFAULT '0',
  `tax_id2` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebinvoice_items`
--


--
-- Table structure for table `Tarteebinvoice_payments`
--

CREATE TABLE `Tarteebinvoice_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  `payment_date` date NOT NULL,
  `payment_method_id` int(11) NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `invoice_id` int(11) NOT NULL,
  `status` enum('draft','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `transaction_id` tinytext COLLATE utf8_unicode_ci,
  `account_transaction_id` int(11) NOT NULL DEFAULT '0',
  `advance_transaction_id` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebinvoice_payments`
--


--
-- Table structure for table `Tarteebinvoices`
--

CREATE TABLE `Tarteebinvoices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `bill_date` date NOT NULL,
  `due_date` date NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `labels` text COLLATE utf8_unicode_ci,
  `last_email_sent_date` date DEFAULT NULL,
  `status` enum('draft','not_paid','cancelled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `delivery_status` enum('delivered','not_delivered') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_delivered',
  `approval_status` enum('not_approved','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_approved',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `recurring` tinyint(4) NOT NULL DEFAULT '0',
  `recurring_invoice_id` int(11) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `next_recurring_date` date DEFAULT NULL,
  `no_of_cycles_completed` int(11) NOT NULL DEFAULT '0',
  `due_reminder_date` date DEFAULT NULL,
  `recurring_reminder_date` date DEFAULT NULL,
  `discount_amount` double NOT NULL,
  `discount_amount_type` enum('percentage','fixed_amount') COLLATE utf8_unicode_ci NOT NULL,
  `discount_type` enum('before_tax','after_tax') COLLATE utf8_unicode_ci NOT NULL,
  `cancelled_at` datetime DEFAULT NULL,
  `cancelled_by` int(11) NOT NULL,
  `revised` int(11) NOT NULL,
  `transaction_id` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebinvoices`
--


--
-- Table structure for table `Tarteebitem_categories`
--

CREATE TABLE `Tarteebitem_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebitem_categories`
--


--
-- Table structure for table `Tarteebitems`
--

CREATE TABLE `Tarteebitems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cost` double NOT NULL,
  `rate` double NOT NULL,
  `category_id` int(11) NOT NULL,
  `item_type` enum('product','service') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'product',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebitems`
--


--
-- Table structure for table `Tarteeblead_source`
--

CREATE TABLE `Tarteeblead_source` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteeblead_source`
--

INSERT INTO `Tarteeblead_source` VALUES (1,'Google',1,0),(2,'Facebook',2,0),(3,'Twitter',3,0),(4,'Youtube',4,0),(5,'Elsewhere',5,0);

--
-- Table structure for table `Tarteeblead_status`
--

CREATE TABLE `Tarteeblead_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteeblead_status`
--

INSERT INTO `Tarteeblead_status` VALUES (1,'New','#f1c40f',0,0),(2,'Qualified','#2d9cdb',1,0),(3,'Discussion','#29c2c2',2,0),(4,'Negotiation','#2d9cdb',3,0),(5,'Won','#83c340',4,0),(6,'Lost','#e74c3c',5,0);

--
-- Table structure for table `Tarteebleads`
--

CREATE TABLE `Tarteebleads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `first_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date NOT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebleads`
--


--
-- Table structure for table `Tarteebleave_applications`
--

CREATE TABLE `Tarteebleave_applications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `leave_type_id` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `total_hours` decimal(7,2) NOT NULL,
  `total_days` decimal(5,2) NOT NULL,
  `applicant_id` int(11) NOT NULL,
  `reason` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('pending','approved','rejected','canceled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `checked_at` datetime DEFAULT NULL,
  `checked_by` int(11) NOT NULL DEFAULT '0',
  `paid_unpaid` tinyint(1) DEFAULT '1',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `leave_type_id` (`leave_type_id`),
  KEY `user_id` (`applicant_id`),
  KEY `checked_by` (`checked_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebleave_applications`
--


--
-- Table structure for table `Tarteebleave_types`
--

CREATE TABLE `Tarteebleave_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `max_allowed` int(11) DEFAULT '1',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebleave_types`
--

INSERT INTO `Tarteebleave_types` VALUES (1,'Casual Leave','active','#83c340','',1,0),(2,'Annual Leave','active','#83c340','',1,0),(3,'Emergency leave','active','#29c2c2','',1,0),(4,'Eid Vacation','active','#83c340','',1,0);

--
-- Table structure for table `Tarteebloans`
--

CREATE TABLE `Tarteebloans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `date` date DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebloans`
--


--
-- Table structure for table `Tarteebmessages`
--

CREATE TABLE `Tarteebmessages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Untitled',
  `message` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `from_user_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `status` enum('unread','read') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unread',
  `message_id` int(11) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `files` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted_by_users` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `message_from` (`from_user_id`),
  KEY `message_to` (`to_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebmessages`
--


--
-- Table structure for table `Tarteebmilestones`
--

CREATE TABLE `Tarteebmilestones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL,
  `due_date` date NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebmilestones`
--


--
-- Table structure for table `Tarteebnotes`
--

CREATE TABLE `Tarteebnotes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `client_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci,
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Tarteebnotes`
--


--
-- Table structure for table `Tarteebnotification_settings`
--

CREATE TABLE `Tarteebnotification_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event` varchar(250) NOT NULL,
  `category` varchar(50) NOT NULL,
  `enable_email` int(1) NOT NULL DEFAULT '0',
  `enable_web` int(1) NOT NULL DEFAULT '0',
  `notify_to_team` text NOT NULL,
  `notify_to_team_members` text NOT NULL,
  `notify_to_terms` text NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `event` (`event`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Tarteebnotification_settings`
--

INSERT INTO `Tarteebnotification_settings` VALUES (1,'project_created','project',0,1,'1','5','client_primary_contact,client_all_contacts',1,0),(2,'project_deleted','project',0,1,'1','5','project_members,client_primary_contact,client_all_contacts',2,0),(3,'project_task_created','project',0,1,'','5','project_members,task_assignee',3,0),(4,'project_task_updated','project',0,1,'','','task_assignee',4,0),(5,'project_task_assigned','project',0,1,'','','task_assignee',5,0),(7,'project_task_started','project',0,1,'','5','project_members,client_primary_contact,client_all_contacts',7,0),(8,'project_task_finished','project',0,0,'','','',8,0),(9,'project_task_reopened','project',0,0,'','','',9,0),(10,'project_task_deleted','project',0,1,'','','task_assignee',10,0),(11,'project_task_commented','project',0,1,'','','task_assignee',11,0),(12,'project_member_added','project',0,1,'','','project_members',12,0),(13,'project_member_deleted','project',0,1,'','','project_members',13,0),(14,'project_file_added','project',0,1,'','','project_members',14,0),(15,'project_file_deleted','project',0,1,'','','project_members',15,0),(16,'project_file_commented','project',0,1,'','','project_members',16,0),(17,'project_comment_added','project',0,1,'','','project_members',17,0),(18,'project_comment_replied','project',0,1,'','','project_members,comment_creator',18,0),(19,'project_customer_feedback_added','project',0,1,'','','project_members',19,0),(20,'project_customer_feedback_replied','project',0,1,'','','project_members,comment_creator',20,0),(21,'client_signup','client',0,0,'','','',21,0),(22,'invoice_online_payment_received','invoice',0,0,'','','',22,0),(23,'leave_application_submitted','leave',0,0,'','','',23,0),(24,'leave_approved','leave',0,1,'','','leave_applicant',24,0),(25,'leave_assigned','leave',0,1,'','','leave_applicant',25,0),(26,'leave_rejected','leave',0,1,'','','leave_applicant',26,0),(27,'leave_canceled','leave',0,0,'','','',27,0),(28,'ticket_created','ticket',0,1,'','6,7,5,11,12,1','client_all_contacts',28,0),(29,'ticket_commented','ticket',0,1,'','','client_primary_contact,ticket_creator',29,0),(30,'ticket_closed','ticket',0,1,'','','client_primary_contact,ticket_creator',30,0),(31,'ticket_reopened','ticket',0,1,'','','client_primary_contact,ticket_creator',31,0),(32,'estimate_request_received','estimate',0,0,'','','',32,0),(33,'estimate_sent','estimate',0,0,'','','',33,0),(34,'estimate_accepted','estimate',0,0,'','','',34,0),(35,'estimate_rejected','estimate',0,0,'','','',35,0),(36,'new_message_sent','message',0,0,'','','',36,0),(37,'message_reply_sent','message',0,0,'','','',37,0),(38,'invoice_payment_confirmation','invoice',0,0,'','','',22,0),(39,'new_event_added_in_calendar','event',0,0,'','','',39,0),(40,'recurring_invoice_created_vai_cron_job','invoice',0,0,'','','',22,0),(41,'new_announcement_created','announcement',1,1,'','','recipient',41,0),(42,'invoice_due_reminder_before_due_date','invoice',0,0,'','','',22,0),(43,'invoice_overdue_reminder','invoice',0,0,'','','',22,0),(44,'recurring_invoice_creation_reminder','invoice',0,0,'','','',22,0),(45,'project_completed','project',0,0,'','','',2,0),(46,'lead_created','lead',0,0,'','','',21,0),(47,'client_created_from_lead','lead',0,0,'','','',21,0),(48,'project_task_deadline_pre_reminder','project',0,1,'','','task_assignee',20,0),(49,'project_task_reminder_on_the_day_of_deadline','project',0,1,'','','task_assignee',20,0),(50,'project_task_deadline_overdue_reminder','project',0,1,'','','task_assignee',20,0),(51,'recurring_task_created_via_cron_job','project',0,1,'','','project_members,task_assignee',20,0),(52,'calendar_event_modified','event',0,0,'','','',39,0);

--
-- Table structure for table `Tarteebnotifications`
--

