DROP TABLE lab_test_units;

CREATE TABLE `lab_test_units` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(500) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `created` int(11) NOT NULL,
  `created_by` int(20) NOT NULL,
  `modified` int(11) DEFAULT NULL,
  `modified_by` int(20) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;

INSERT INTO lab_test_units VALUES
(1,"ng/mL",NULL,1599730604,12,NULL,NULL,0),
(2,"NULL",NULL,1599730604,12,NULL,NULL,0),
(3,"mg/24hr",NULL,1599730604,12,NULL,NULL,0),
(4,"U/ml",NULL,1599730604,12,NULL,NULL,0),
(5,"pg/mL",NULL,1599730604,12,NULL,NULL,0),
(6,"IU/ml",NULL,1599730604,12,NULL,NULL,0),
(7,"pmol/L",NULL,1599730604,12,NULL,NULL,0),
(8,"g/dL",NULL,1599730604,12,NULL,NULL,0),
(9,"mg/g",NULL,1599730604,12,NULL,NULL,0),
(10,"U/L",NULL,1599730604,12,NULL,NULL,0),
(11,"ng/dL",NULL,1599730604,12,NULL,NULL,0),
(12,"mcg/24hr",NULL,1599730604,12,NULL,NULL,0),
(13,"g/L",NULL,1599730604,12,NULL,NULL,0),
(14,"nmol/mL/min",NULL,1599730604,12,NULL,NULL,0),
(15,"COL",NULL,1599730604,12,NULL,NULL,0),
(16,"NTU",NULL,1599730604,12,NULL,NULL,0),
(17,"AU/mL",NULL,1599730604,12,NULL,NULL,0),
(18,"IU/L",NULL,1599730604,12,NULL,NULL,0),
(19,"ISR",NULL,1599730604,12,NULL,NULL,0),
(20,"RU/ml",NULL,1599730604,12,NULL,NULL,0),
(21,"Index",NULL,1599730604,12,NULL,NULL,0),
(22,"%",NULL,1599730604,12,NULL,NULL,0),
(23,"mg/dL",NULL,1599730604,12,NULL,NULL,0),
(24,"mIU/mL",NULL,1599730604,12,NULL,NULL,0),
(25,"Ug/mL",NULL,1599730604,12,NULL,NULL,0),
(26,"k/l",NULL,1599730604,12,NULL,NULL,0),
(27,"Minutes",NULL,1599730604,12,NULL,NULL,0),
(28,"Rh",NULL,1599730604,12,NULL,NULL,0),
(29,"mg/L",NULL,1599730604,12,NULL,NULL,0),
(30,"micgr/gr",NULL,1599730604,12,NULL,NULL,0),
(31,"micgr/24hr",NULL,1599730604,12,NULL,NULL,0),
(32,"cell/mm",NULL,1599730604,12,NULL,NULL,0),
(33,"%of Ref",NULL,1599730604,12,NULL,NULL,0),
(34,"mmol/L",NULL,1599730604,12,NULL,NULL,0),
(35,"ng/L",NULL,1599730604,12,NULL,NULL,0),
(36,"Strip",NULL,1599730604,12,NULL,NULL,0),
(37,"µg/24hr",NULL,1599730604,12,NULL,NULL,0),
(38,"NMOL/L",NULL,1599730604,12,NULL,NULL,0),
(39,"µg/mL",NULL,1599730604,12,NULL,NULL,0),
(40,"µg/dL",NULL,1599730604,12,NULL,NULL,0),
(41,"mlU/ml",NULL,1599730604,12,NULL,NULL,0),
(42,"mm/1hr",NULL,1599730604,12,NULL,NULL,0),
(43,"Attached",NULL,1599730604,12,NULL,NULL,0),
(44,"UI/mL",NULL,1599730604,12,NULL,NULL,0),
(45,"NMOL/24hr",NULL,1599730604,12,NULL,NULL,0),
(46,"IU/g  of Hb",NULL,1599730604,12,NULL,NULL,0),
(47,"mL/min/1.73m2",NULL,1599730604,12,NULL,NULL,0),
(48,"mcmol/L",NULL,1599730604,12,NULL,NULL,0),
(49,"micmol/L",NULL,1599730604,12,NULL,NULL,0),
(50,"µU/mL",NULL,1599730604,12,NULL,NULL,0),
(51,"Second",NULL,1599730604,12,NULL,NULL,0),
(52,"mmol/24hr",NULL,1599730604,12,NULL,NULL,0),
(53,"/ ml",NULL,1599730604,12,NULL,NULL,0),
(54,"micgr/L/24hr",NULL,1599730604,12,NULL,NULL,0),
(55,"uIU/mL",NULL,1599730604,12,NULL,NULL,0),
(56,"D/Value",NULL,1599730604,12,NULL,NULL,0),
(57,"k/mm cubed",NULL,1599730604,12,NULL,NULL,0),
(58,"ML",NULL,1599730604,12,NULL,NULL,0),
(59,"µg/L",NULL,1599730604,12,NULL,NULL,0),
(60,"mEq/L",NULL,1599730604,12,NULL,NULL,0),
(61,"HP",NULL,1600162583,12,NULL,NULL,0),
(62,"10^3/µL",NULL,1601814681,12,NULL,NULL,0),
(63,"mil/CU",NULL,1601816398,12,NULL,NULL,0),
(64,"µm^3",NULL,1601816717,12,NULL,NULL,0),
(65,"pg",NULL,1601816820,12,NULL,NULL,0),
(66,"mOsm/Kg",NULL,1601887842,12,NULL,NULL,0),
(67,"/cumm",NULL,1604162443,628,NULL,NULL,0),
(68,"fL",NULL,1604163122,628,NULL,NULL,0),
(69,"10^3/mL",NULL,1604163242,628,NULL,NULL,0),
(70,"10^6/µl",NULL,1608549259,12,NULL,NULL,0),
(71,"     ",NULL,1608554172,12,NULL,NULL,0),
(72,"U/ML",NULL,1612008784,627,NULL,NULL,0);


DROP TABLE lab_tests;

CREATE TABLE `lab_tests` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) NOT NULL,
  `code` varchar(64) DEFAULT NULL,
  `service_id` bigint(20) DEFAULT NULL,
  `laboratory_id` bigint(20) NOT NULL,
  `sample_type_id` bigint(20) DEFAULT NULL,
  `tube_type_id` bigint(20) NOT NULL,
  `kit_id` bigint(20) NOT NULL,
  `test_type` tinyint(1) DEFAULT 0 COMMENT '0: normal, 1: group, 2: parameter',
  `result_type` tinyint(1) DEFAULT 0 COMMENT '1: numerical, 2: list options, 3: dsecription, 4: report (rich text editor)',
  `unit_id` bigint(20) DEFAULT NULL,
  `group_id` bigint(20) DEFAULT NULL COMMENT 'Group or Category of tests',
  `default_description` text DEFAULT NULL,
  `default_report_description` text DEFAULT NULL,
  `result_validity_days` int(11) DEFAULT NULL,
  `sample_validity_period` int(11) DEFAULT NULL,
  `is_result_hidden` tinyint(1) NOT NULL COMMENT '0:no, 1:yes, Hide Result',
  `is_two_technician_approval` tinyint(1) DEFAULT 0 COMMENT '0:no, 1:yes',
  `is_require_another_sample` tinyint(1) DEFAULT 0 COMMENT '0:no, 1:yes',
  `is_approved_with_technician_approval` tinyint(1) DEFAULT 1 COMMENT '0:no, 1:yes',
  `is_manual_result_prohibted` tinyint(1) DEFAULT 0 COMMENT '0:no, 1:yes, Prevent manual result entry',
  `is_separate_page_needed` tinyint(1) DEFAULT 0 COMMENT '0:no, 1:yes',
  `is_default_result_description_shown` tinyint(1) NOT NULL COMMENT '0: no, 1:yes, Show default description result automatically',
  `is_auto_print_sample_barcode` tinyint(1) DEFAULT 0 COMMENT '0:no, 1:yes',
  `created` int(11) DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `modified` int(11) DEFAULT NULL,
  `modified_by` bigint(20) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=611 DEFAULT CHARSET=utf8;

INSERT INTO lab_tests VALUES
(1,"17-OH Progestron",NULL,1,1,9,2,1,1,2,1,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612271160,12,0),
(2,"17-OH Progestron (30)",NULL,2,1,9,2,1,1,2,1,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612271166,12,0),
(3,"17-OH Progestron (60 mint)",NULL,3,1,9,2,1,1,2,1,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612271171,12,0),
(4,"17-OH Progestron Base",NULL,4,1,9,2,1,1,2,1,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612271182,12,0),
(5,"2ME",NULL,5,1,9,2,1,1,2,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(6,"5-HIAA",NULL,6,1,15,6,1,1,2,3,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(7,"A.Ebv-Igm",NULL,7,1,9,2,1,1,1,4,11,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600323872,12,0),
(8,"A.V-Zost Ab IgG",NULL,8,1,9,2,1,1,1,4,11,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600324103,12,0),
(9,"A.V-Zost Ab IgM",NULL,9,1,9,2,1,1,1,4,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600324267,12,0),
(10,"ACTH",NULL,10,1,9,2,1,1,1,5,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612271200,12,0),
(11,"ACTH (30 min)",NULL,11,1,9,2,1,1,1,5,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600324446,12,0),
(12,"ACTH (60 min)",NULL,12,1,9,2,1,1,1,5,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600324495,12,0),
(13,"ACTH (90 min)",NULL,13,1,9,2,1,1,1,5,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600324536,12,0),
(14,"ACTH (Base)",NULL,14,1,9,2,1,1,1,5,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600324579,12,0),
(15,"Adenosine Deaminase",NULL,15,1,9,2,1,1,2,6,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(16,"ADH level",NULL,16,1,9,2,1,1,2,7,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(17,"AFB (Acid Fast Bacillus)",NULL,17,1,12,15,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(18,"AFP",NULL,18,1,9,2,1,1,1,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600324747,12,0),
(19,"S.Albumin",NULL,873,1,9,2,1,1,1,8,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600324835,12,0),
(20,"Albumin in Urine (24 hour)",NULL,874,1,15,6,1,1,1,9,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600324884,12,0),
(21,"Albumin globulin ratio",NULL,21,1,9,2,1,1,1,8,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600324942,12,0),
(22,"Albumin in Urine",NULL,22,1,15,6,1,1,1,29,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600356494,627,0),
(23,"Albumin(Fluid)",NULL,23,1,9,2,1,1,2,8,7,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601815938,628,0),
(24,"Aldolase",NULL,24,1,9,2,1,1,1,10,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600325160,12,0),
(25,"Aldosterone",NULL,25,1,9,2,1,1,2,11,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(26,"Aldosterone, 24 Hour, Urine",NULL,26,1,15,6,1,1,2,12,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(27,"Alkaline Phosphate",NULL,27,1,9,2,1,1,2,10,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(28,"Alpha 1 Antitrypsin",NULL,29,1,9,2,1,1,1,13,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600325387,12,0),
(29,"Alpha Thallasemia (a-gloubin genemutations); 21 mutations",NULL,30,1,9,2,1,1,2,13,8,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(30,"AMA",NULL,31,1,9,2,1,1,1,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600325559,12,0),
(31,"Anti Mullerian Hormone(AMH)",NULL,877,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(32,"AMH(Anti Mullerian Hormone)",NULL,878,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(33,"Amylase",NULL,34,1,9,2,1,1,1,10,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600325826,12,0),
(34,"ANA",NULL,879,1,9,2,1,1,1,4,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1602065524,12,0),
(35,"ANA-Profile",NULL,36,1,9,2,1,2,2,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(36,"Angiotensin Converting Enzyme",NULL,37,1,9,2,1,1,2,14,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(37,"Anti CCP",NULL,880,1,9,2,1,1,1,4,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1607001079,628,0),
(38,"Anti Cardiolipin IgG",NULL,39,1,9,2,1,1,1,4,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600327743,12,0),
(39,"Anti Cardiolipin IgM",NULL,40,1,9,2,1,1,1,4,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600327816,12,0),
(40,"Anti Centromer ",NULL,881,1,9,2,1,1,1,15,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600327898,12,0),
(41,"Anti Chlamydia IgA",NULL,42,1,9,2,1,1,1,16,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600844629,12,0),
(42,"Anti Chlamydia IgG",NULL,43,1,9,2,1,1,1,16,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600328136,12,0),
(43,"Anti Chlamydia IgM",NULL,44,1,9,2,1,1,1,16,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600844807,12,0),
(44,"Anti Endomysial Ab-IgA",NULL,45,1,9,2,1,1,1,4,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600328290,12,0),
(45,"Anti Endomysial Ab-IgG",NULL,46,1,9,2,1,1,1,4,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600328399,12,0),
(46,"Anti GAD Ab",NULL,47,1,9,2,1,1,1,6,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600332403,12,0),
(47,"Anti Gliadin Ab. IgA",NULL,48,1,9,2,1,1,1,17,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1605180648,628,0),
(48,"Anti Gliadin Ab. IgG",NULL,49,1,9,2,1,1,1,17,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1605181014,628,0),
(49,"Anti HAV total",NULL,882,1,9,2,1,1,1,18,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600516589,12,0),
(50,"Anti HAV IgM",NULL,51,1,9,2,1,1,1,19,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600848475,12,0),
(51,"Anti HBC Ab",NULL,52,1,9,2,1,1,1,15,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600848640,12,0),
(52,"Anti Hbe Ab",NULL,53,1,9,2,1,1,1,15,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600849191,12,0),
(53,"HBS Ab",NULL,883,1,9,2,1,1,1,18,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600849452,12,0),
(54,"HCV Ab",NULL,884,1,9,2,1,1,1,15,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600326849,12,0),
(55,"Anti Histon Ab.",NULL,56,1,9,2,1,1,2,4,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(56,"Anti intrinsic factors Abs",NULL,57,1,9,2,1,1,2,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(57,"Anti Jo.1 Ab",NULL,58,1,9,2,1,1,1,15,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600849676,12,0),
(58,"Anti Liver, Kidney, Microsomal Antibody (LKM1) Test",NULL,59,1,9,2,1,1,1,4,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600851751,12,0),
(59,"Anti MUSC Ab.",NULL,60,1,9,2,1,1,2,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(60,"Anti Parietal cells Abs",NULL,61,1,9,2,1,1,2,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(61,"Anti Phospholipin IgG",NULL,62,1,9,2,1,1,1,4,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600851977,12,0),
(62,"Anti Phospholipin IgM",NULL,63,1,9,2,1,1,1,4,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600852377,12,0),
(63,"Anti PLA2 Receptor Ab",NULL,64,1,9,2,1,1,1,20,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600855097,12,0),
(64,"Anti SCL-70",NULL,65,1,9,2,1,1,1,15,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600855346,12,0),
(65,"Anti Smith Ab",NULL,66,1,9,2,1,1,1,21,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600855466,12,0),
(66,"Anti Smooth Muscle Ab",NULL,67,1,9,2,1,1,1,17,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600855885,12,0),
(67,"Anti Sperm Ab",NULL,68,1,9,2,1,1,1,4,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600856073,12,0),
(68,"Anti SSA/Ro",NULL,69,1,9,2,1,1,1,15,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600856260,12,0),
(69,"Anti SSB/La",NULL,70,1,9,2,1,1,1,15,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600856485,12,0),
(70,"Anti Thrombin III",NULL,71,1,9,2,1,1,1,22,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600856770,12,0),
(71,"Anti Thyroglobulin Ab.",NULL,72,1,9,2,1,1,1,6,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600948401,12,0),
(72,"Anti Thyroid Ab",NULL,73,1,9,2,1,1,1,6,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600948551,12,0),
(73,"Anti Tissue Transglutaminase Ab -IgA",NULL,74,1,9,2,1,1,1,4,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600948622,12,0),
(74,"Anti Tissue Transglutaminase Ab -IgG",NULL,75,1,9,2,1,1,1,4,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600949110,12,0),
(75,"Anti TPO",NULL,76,1,9,2,1,1,1,6,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600950314,12,0),
(76,"Anti Trypsin Level",NULL,77,1,9,2,1,1,1,23,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600950559,12,0),
(77,"Anti TSH Receptor",NULL,78,1,9,2,1,1,1,18,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600950728,12,0),
(78,"Anti-Acetylcholine Receptor Ab",NULL,79,1,9,2,1,1,2,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(79,"Anti-HBC Ab",NULL,80,1,9,2,1,1,2,15,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(80,"Apo lipo protein (A)",NULL,81,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(81,"Apo lipo protein (B)",NULL,82,1,9,2,1,1,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601191489,12,0),
(82,"ASO Titer",NULL,83,1,9,2,1,1,2,6,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(83,"Automated C/S (CSF)",NULL,84,1,2,4,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(84,"Automated C/S (Fluid)",NULL,85,1,5,10,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(85,"Automated C/S (H.V.S)",NULL,86,1,6,9,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(86,"Automated C/S (Seminal)",NULL,87,1,8,12,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(87,"Automated C/S (sputum )",NULL,88,1,12,15,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(88,"Automated C/S (Stool)",NULL,89,1,13,5,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(89,"Automated C/S (Swab)",NULL,90,1,14,9,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(90,"Automated C/S (Urine)",NULL,91,1,15,6,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(91,"Automated C/S (Wound)",NULL,92,1,17,16,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(92,"B hCG Titer",NULL,93,1,9,2,1,1,2,24,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(93,"B2 Glycoprotien IgG",NULL,94,1,9,2,1,1,1,4,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601191689,12,0),
(94,"B2 Glycoprotien IgM",NULL,95,1,9,2,1,1,1,4,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601192016,12,0),
(95,"B2 Microglobulin",NULL,96,1,9,2,1,1,1,29,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1604330183,627,0),
(96,"B2 Microglobulin (Elisa)",NULL,97,1,9,2,1,1,2,25,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(97,"Bence Jones Protein",NULL,98,1,9,2,1,1,2,36,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1608537642,627,0),
(98,"Beta globulin gene",NULL,99,1,9,2,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(99,"Bilirubin, Direct",NULL,100,1,9,2,1,1,2,23,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1609596167,628,0),
(100,"Bilirubin, indirect",NULL,101,1,9,2,1,1,1,23,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601475808,628,0),
(101,"BK virus RT-PCR",NULL,102,1,9,2,1,1,2,6,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(102,"Bleeding Time",NULL,103,1,16,1,1,1,1,27,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601475873,628,0),
(103,"Blood Culture",NULL,104,1,16,1,1,1,3,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600507646,12,0),
(104,"Blood Film For Malaira",NULL,105,1,16,1,1,1,2,2,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(105,"Blood Group",NULL,106,1,16,1,1,1,3,28,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601301196,627,0),
(106,"B.Urea",NULL,885,1,9,2,1,1,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601192509,12,0),
(107,"Bone Marrow",NULL,108,1,2,4,1,1,2,2,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(108,"Brain natriuretic peptide",NULL,109,1,9,2,1,1,2,5,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(109,"BRCA1",NULL,110,1,9,2,1,1,1,2,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601192669,12,0),
(110,"BRCA2",NULL,111,1,9,2,1,1,1,2,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601192772,12,0),
(111,"Brucella IgG",NULL,112,1,9,2,1,1,1,16,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601192892,12,0),
(112,"Brucella IgM",NULL,113,1,9,2,1,1,1,16,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601192969,12,0),
(113,"Brucella Test",NULL,114,1,9,2,1,1,3,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600260387,12,0),
(114,"BUN (blood urea nitrogen)",NULL,115,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(115,"CRP",NULL,851,1,9,2,1,1,1,29,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1609071582,627,0),
(116,"C1 inhibitor",NULL,117,1,9,2,1,1,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601194601,12,0),
(117,"C3",NULL,118,1,9,2,1,1,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601277253,12,0),
(118,"C4",NULL,119,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(119,"CA 125",NULL,120,1,9,2,1,1,2,4,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(120,"CA 15-3",NULL,121,1,9,2,1,1,2,4,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(121,"CA 19.9",NULL,122,1,9,2,1,1,2,4,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(122,"CA 72-4",NULL,123,1,9,2,1,1,2,4,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(123,"Calcitonin",NULL,124,1,9,2,1,1,1,5,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601277413,12,0),
(124,"Calcium ( 24 hr)",NULL,125,1,15,6,1,1,1,3,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601277524,12,0),
(125,"Calcium (Spot Urine)",NULL,126,1,15,6,1,1,2,3,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(126,"Calprotectin  (Fecal)",NULL,127,1,9,2,1,1,2,30,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(127,"CALR Mutation Analysis",NULL,128,1,16,1,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(128,"C-ANCA",NULL,129,1,9,2,1,1,2,4,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601725428,627,0),
(129,"Catecholamine 24 hr urine",NULL,130,1,15,6,1,1,2,31,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(130,"CBC",NULL,131,1,16,1,1,1,3,0,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601452747,627,0),
(131,"CBP",NULL,132,1,16,1,1,2,2,2,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1608544337,12,0),
(132,"CEA",NULL,133,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600877731,628,0),
(133,"Cell Count",NULL,0,1,16,1,1,3,2,32,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(134,"Cell Count(CSF)",NULL,0,1,2,4,1,3,2,32,13,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(135,"Cell Count(Fluid)",NULL,0,1,5,10,1,3,2,32,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(136,"Ceruloplasmin",NULL,137,1,9,2,1,1,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601278016,12,0),
(137,"CH50",NULL,138,1,9,2,1,1,2,33,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(138,"Chlamydia",NULL,139,1,9,2,1,1,2,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(139,"Chloride(Cl-)",NULL,886,1,9,2,1,1,1,34,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601278264,12,0),
(140,"Chromogranin A",NULL,141,1,9,2,1,1,2,35,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(141,"Chromosomal",NULL,142,1,16,1,1,1,2,2,8,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(142,"Chromosomal (karyotype)",NULL,143,1,16,1,1,1,2,2,8,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(143,"chromosomal analysis down\'s syndrome",NULL,144,1,16,1,1,1,2,2,8,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(144,"Citrate (24 Hours)",NULL,145,1,15,6,1,1,2,3,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(145,"Citrate (Spot Urine)",NULL,146,1,15,6,1,1,2,3,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(146,"CK-MB",NULL,147,1,9,2,1,1,1,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601278717,12,0),
(147,"clostridium diffcile toxin A",NULL,148,1,9,2,1,1,2,36,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(148,"clostridium diffcile toxin B",NULL,149,1,9,2,1,1,2,36,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(149,"Clotting Time",NULL,150,1,16,1,1,1,2,27,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(150,"CMV   lgM",NULL,151,1,9,2,1,1,2,15,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(151,"CMV (RT-PCR)",NULL,152,1,9,2,1,1,2,6,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(152,"Copper  In Urine(24-hr  )",NULL,153,1,15,6,1,1,1,37,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601278838,12,0),
(153,"Cortisol ( AM)",NULL,154,1,9,2,1,1,1,38,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601278909,12,0),
(154,"Cortisol ( PM)",NULL,155,1,9,2,1,1,1,38,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601278964,12,0),
(155,"Cortisol (30 min)",NULL,156,1,9,2,1,1,1,38,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601279304,12,0),
(156,"Cortisol (60min)",NULL,157,1,9,2,1,1,1,38,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601279561,12,0),
(157,"Cortisol (90min)",NULL,158,1,9,2,1,1,1,38,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601279749,12,0),
(158,"Cortisol Base",NULL,159,1,9,2,1,1,1,38,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601279814,12,0),
(159,"C-Peptide",NULL,160,1,9,2,1,1,1,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601279966,12,0),
(160,"CPK",NULL,161,1,9,2,1,1,1,10,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601280134,12,0),
(161,"Creatinine in fluid",NULL,162,1,5,10,1,1,2,23,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(162,"Creatinine in Urine(24h)",NULL,163,1,15,6,1,1,1,3,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601280377,12,0),
(163,"Creatnine In Urine",NULL,164,1,15,6,1,1,1,23,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601280492,12,0),
(164,"culture / sensitivity",NULL,165,1,15,6,1,1,3,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600507671,12,0),
(165,"Cyclosporin",NULL,166,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(166,"Cyclosporin C-2 Blood Level",NULL,167,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(167,"Cysteine",NULL,168,1,9,2,1,1,2,34,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(168,"Cysteine  (24 Hours)",NULL,169,1,15,6,1,1,2,29,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(169,"Cytology",NULL,170,1,1,7,1,1,2,2,5,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(170,"D-Dimer",NULL,171,1,7,3,1,1,1,39,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601208630,627,0),
(171,"DHEA",NULL,172,1,9,2,1,1,2,40,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(172,"Differential  Count(CSF)",NULL,173,1,2,4,1,1,2,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(173,"Differential  Count(Fluid)",NULL,174,1,5,10,1,1,2,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(174,"Differential  Count.",NULL,175,1,5,10,1,1,2,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(175,"Direct coombs test",NULL,176,1,16,1,1,1,2,2,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(176,"Direct Microscopic",NULL,177,1,1,14,1,1,2,2,9,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(177,"dsDNA Ab",NULL,178,1,9,2,1,1,2,6,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601725815,627,0),
(178,"Endocervical Swab C/S",NULL,179,1,14,9,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(179,"Eosinophils",NULL,0,1,16,1,1,3,2,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(180,"Epinephrine",NULL,0,1,16,1,1,3,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(181,"Erythropoietin",NULL,0,1,16,1,1,3,2,41,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(182,"ESR",NULL,183,1,16,1,1,1,1,42,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601450893,12,0),
(183,"Estradiol II",NULL,184,1,9,2,1,1,2,5,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(184,"F BLOOD SUGAR",NULL,0,1,9,2,1,3,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1606751546,627,0),
(185,"Factor 10",NULL,0,1,7,3,1,3,1,22,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601281627,12,0),
(186,"Factor 11",NULL,0,1,7,3,1,3,1,22,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601281915,12,0),
(187,"Factor 12",NULL,0,1,7,3,1,3,1,22,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601281967,12,0),
(188,"Factor 13",NULL,0,1,7,3,1,3,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(189,"Factor 2",NULL,0,1,7,3,1,3,1,22,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601282014,12,0),
(190,"Factor 5",NULL,0,1,7,3,1,3,1,22,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601282103,12,0),
(191,"Factor 5 Leiden Mutation.",NULL,0,1,16,1,1,3,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(192,"Factor 7",NULL,0,1,7,3,1,3,1,22,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601282248,12,0),
(193,"Factor 8",NULL,0,1,7,3,1,3,1,22,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601282298,12,0),
(194,"Factor IX",NULL,0,1,7,3,1,3,1,22,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601282342,12,0),
(195,"Fibrinogen",NULL,199,1,7,3,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601451515,12,0),
(196,"FISH (Abortion)",NULL,200,1,9,2,1,1,2,43,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(197,"FIT",NULL,201,1,9,5,1,1,2,36,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1608997355,628,0),
(198,"Folate",NULL,202,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(199,"Folic acid",NULL,203,1,9,2,1,1,1,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601282548,12,0),
(200,"Food Allergic(Euroline)",NULL,204,1,9,2,1,1,2,43,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1603028007,627,0),
(201,"FOODPRINT Test",NULL,205,1,9,2,1,1,2,44,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(202,"Free Androgen Index (FAI)",NULL,206,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(203,"Free Cortisol In Urine(24h)",NULL,207,1,9,2,1,1,1,45,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601293040,12,0),
(204,"Free PSA",NULL,209,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(205,"Free PSA Ratio",NULL,210,1,9,2,1,1,2,22,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(206,"Free Testosteron",NULL,211,1,9,2,1,1,1,5,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601294236,12,0),
(207,"FSH",NULL,212,1,9,2,1,1,2,41,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(208,"FT3",NULL,213,1,9,2,1,1,1,7,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612271004,12,0),
(209,"FT4",NULL,214,1,9,2,1,1,1,7,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612271144,12,0),
(210,"Fungus Direct Smear",NULL,215,1,13,15,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(211,"G6-PDH",NULL,216,1,9,2,1,1,2,46,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(212,"Genetic - Chromosomal Analysis",NULL,218,1,9,2,1,1,2,2,8,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(213,"GeneXpert MTB-RIF",NULL,219,1,9,2,1,1,2,2,8,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(214,"GGT",NULL,220,1,9,2,1,1,1,10,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601294392,12,0),
(215,"Glomeruler Filtration Rate (eGFR)",NULL,221,1,9,2,1,1,1,47,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601534960,12,0),
(216,"Glucose (Ascitic Fluid)",NULL,222,1,9,2,1,1,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601294479,12,0),
(217,"Glucose (CSF)",NULL,223,1,9,2,1,1,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601294526,12,0),
(218,"Glucose (Fluid)",NULL,224,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601815966,628,0),
(219,"Glucose After ( 90 Min)",NULL,225,1,9,2,1,1,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601294581,12,0),
(220,"Glucose After (120 Min)",NULL,0,1,9,2,1,3,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1606751648,627,0),
(221,"Glucose After (30 Min)",NULL,0,1,9,2,1,3,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1606751604,627,0),
(222,"Glucose After( 60 Min)",NULL,0,1,9,2,1,3,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1606751637,627,0),
(223,"Glucose After(180 Min)",NULL,229,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(224,"Glucose in Urine",NULL,230,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(225,"Glucose(24 hour)",NULL,231,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(226,"Gonococcus(GC)",NULL,232,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(227,"Gram Stain ( CSF)",NULL,233,1,2,4,1,1,2,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(228,"Gram staine",NULL,234,1,5,10,1,1,2,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(229,"Growth Hormone ( R)",NULL,235,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(230,"Growth hormone (120 Min )",NULL,236,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(231,"Growth hormone (30 Min )",NULL,237,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(232,"Growth hormone (60 Min )",NULL,238,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(233,"Growth hormone (90 Min )",NULL,239,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(234,"Growth hormone (Base )",NULL,240,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(235,"GSE",NULL,241,1,13,5,1,2,2,2,3,NULL,NULL,0,0,0,0,0,1,0,1,0,1,1599484584,12,1602493259,12,0),
(236,"GUE",NULL,242,1,15,6,1,2,2,2,15,NULL,NULL,0,0,0,0,0,1,0,1,0,1,1599484584,12,1600843181,12,0),
(237,"H.Pylori in stool",NULL,887,1,13,5,1,1,2,36,6,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(238,"Anti H.Pylori Ab-IgA",NULL,888,1,9,2,1,1,2,4,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(239,"Anti H.Pylori Ab-IgG",NULL,889,1,9,2,1,1,2,4,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(240,"Anti H.Pylori Ab-IgM",NULL,890,1,9,2,1,1,1,4,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601296863,12,0),
(241,"H.V. S   C/S",NULL,248,1,14,9,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(242,"Hb Electrophorsis",NULL,249,1,16,1,1,2,2,2,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1602066579,627,0),
(243,"HbA1c",NULL,891,1,16,1,1,1,2,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(244,"HBss Ab titter",NULL,892,1,9,2,1,1,2,6,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(245,"Hbe Ag",NULL,252,1,9,2,1,1,1,6,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601454891,12,0),
(246,"Hbe-Ag",NULL,253,1,9,2,1,1,2,6,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(247,"HBs Ag",NULL,893,1,9,2,1,1,1,15,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600326467,12,0),
(248,"HCV Detection (PCR)",NULL,255,1,9,2,1,1,2,6,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(249,"HDL",NULL,256,1,9,2,1,1,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601452881,12,0),
(250,"Hepatitis B Viral Load (Quantitative)",NULL,257,1,9,2,1,1,2,6,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(251,"Hepatitis C virus genotyping",NULL,258,1,9,2,1,1,2,6,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(252,"Herps simplex .V-I(PCR)",NULL,259,1,9,2,1,1,2,6,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(253,"Herps simplex .V-iI(PCR)",NULL,260,1,9,2,1,1,2,6,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(254,"Herps simplex virus (IgG)",NULL,261,1,9,2,1,1,2,36,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(255,"Herps simplex virus (IgM)",NULL,262,1,9,2,1,1,2,36,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(256,"Hgb",NULL,263,1,9,2,1,1,2,8,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(257,"Hiv (RT-PCT), Viral Load",NULL,264,1,9,2,1,1,2,6,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(258,"HIV Combi",NULL,894,1,9,2,1,1,1,15,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600327004,12,0),
(259,"HLA B27 (pcr)",NULL,0,1,9,2,1,3,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(260,"HLA B51 (pcr)",NULL,0,1,9,2,1,3,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(261,"HLA B52 (pcr)",NULL,0,1,9,2,1,3,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(262,"HLA B57 (pcr)",NULL,0,1,9,2,1,3,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(263,"HLA-B50 (pcr)",NULL,0,1,9,2,1,3,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(264,"homocysteine levels in Serum",NULL,271,1,9,2,1,1,2,48,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(265,"homocysteine levels in Urine",NULL,272,1,15,6,1,1,2,49,13,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(266,"homovanillic acid 24 hour",NULL,273,1,15,6,1,1,2,49,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(267,"HPV Detection (PCR)",NULL,274,1,9,2,1,1,2,2,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(268,"HPV Genotyping (PCR)",NULL,275,1,9,2,1,1,2,2,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(269,"Hydatid cyst IgG",NULL,276,1,9,2,1,1,1,19,11,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601453042,12,0),
(270,"Hydatid cyst IgM",NULL,277,1,9,2,1,1,2,2,11,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(271,"IgA",NULL,278,1,9,2,1,1,2,13,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(272,"Serum IgE",NULL,895,1,9,2,1,1,2,6,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(273,"IGF-1",NULL,280,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1605623193,628,0),
(274,"IgG",NULL,281,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(275,"IgG 4.",NULL,282,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(276,"IgM",NULL,283,1,9,2,1,1,2,13,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(277,"Indirect Coombs test",NULL,284,1,9,2,1,1,2,2,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(278,"inhalative Allergic(Euroline)",NULL,285,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(279,"Inhibin B",NULL,286,1,9,2,1,1,1,5,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601453646,12,0),
(280,"INR",NULL,0,1,7,3,1,3,1,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601453693,12,0),
(281,"Insulin",NULL,288,1,9,2,1,1,2,50,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(282,"Ca++ (Ionized Calcium)",NULL,896,1,9,2,1,1,1,34,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601453742,12,0),
(283,"JAK II Gen(PCR)",NULL,290,1,16,1,1,1,2,2,8,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(284,"Karyotype (Female)",NULL,291,1,16,1,1,1,2,2,8,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(285,"Lactate",NULL,292,1,9,2,1,1,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601454044,12,0),
(286,"Latex",NULL,293,1,9,2,1,1,1,6,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601454327,12,0),
(287,"LDH",NULL,294,1,9,2,1,1,1,10,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1605355314,627,0),
(288,"LDH (Fluid)",NULL,295,1,9,2,1,1,2,10,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601814737,628,0),
(289,"LDL",NULL,296,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(290,"LE Cell",NULL,297,1,15,6,1,1,1,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601454412,12,0),
(291,"Leishmania Ab IgG",NULL,298,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(292,"Leishmania Ab IgM",NULL,299,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(293,"LH",NULL,300,1,9,2,1,1,2,24,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(294,"Lipase",NULL,301,1,9,2,1,1,1,10,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601454462,12,0),
(295,"Lizozomal Screening",NULL,302,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(296,"Lupus Anticoagulant",NULL,303,1,9,2,1,1,1,51,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601454510,12,0),
(297,"Magnesium",NULL,304,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(298,"Malaria Test",NULL,305,1,9,2,1,1,2,36,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(299,"Meningitis Panel PCR(Bacterial & Viral )",NULL,306,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(300,"Metanephrin(24 hour)",NULL,307,1,15,6,1,1,2,5,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(301,"Metanephrine",NULL,308,1,9,2,1,1,2,5,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(302,"Micro Albumin in Urine",NULL,309,1,15,6,1,1,2,29,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(303,"MPN (Panal)",NULL,310,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(304,"MTHFR Mutation Analusis",NULL,311,1,9,2,1,1,2,43,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(305,"Multiple Drug screen",NULL,312,1,9,2,1,2,2,36,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(306,"Mycobacterium tuberculosis (PCR)",NULL,313,1,9,2,1,1,2,2,8,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(307,"Myeloproliferative Neoplasms (MPNs), MLPA.",NULL,314,1,16,1,1,1,2,2,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(308,"Myoglobin",NULL,315,1,9,2,1,1,2,43,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(309,"Neunatal Screen 1",NULL,316,1,9,2,1,2,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(310,"Neuron-specific enolase",NULL,317,1,9,2,1,2,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(311,"Nor Metanephrin (24 hour)",NULL,318,1,9,2,1,1,2,5,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(312,"Norepinephrine",NULL,319,1,9,2,1,1,2,5,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(313,"Oxalate (24 Hours)",NULL,321,1,15,6,1,1,2,52,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(314,"Oxalate (Spot Urine)",NULL,322,1,15,6,1,1,2,52,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(315,"P.C.V",NULL,323,1,16,1,1,1,2,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600861250,627,0),
(316,"P-ANCA",NULL,324,1,9,2,1,1,2,4,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601725554,627,0),
(317,"Pap Smear",NULL,326,1,11,9,1,2,2,2,9,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(318,"Parathyroid hormone",NULL,897,1,9,2,1,1,2,5,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(319,"Parovirus B19 IgG.",NULL,328,1,9,2,1,1,2,2,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(320,"Parovirus B19 IgM.",NULL,329,1,9,2,1,1,2,2,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(321,"Parvovirus B19 PCR",NULL,330,1,16,1,1,1,2,2,8,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(322,"Pathology (Large)",NULL,331,1,1,8,1,1,2,2,9,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(323,"Pathology (Medium)",NULL,332,1,1,8,1,1,2,2,9,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(324,"Pathology (Small)",NULL,333,1,1,8,1,1,2,2,9,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(325,"PCR for BCR/ABL",NULL,334,1,16,1,1,1,2,2,8,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(326,"PCT",NULL,335,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(327,"PCT(Postcoital test)",NULL,336,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(328,"Phosphorus",NULL,337,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(329,"phosphorus (24 hour)",NULL,338,1,9,2,1,1,1,52,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601454994,12,0),
(330,"Platelets",NULL,0,1,16,1,1,3,1,53,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601455067,12,0),
(331,"Pneuminia PCR Panel",NULL,340,1,9,2,1,1,2,2,8,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(332,"Potassium(K+)",NULL,898,1,9,2,1,1,1,34,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601455194,12,0),
(333,"PRA",NULL,346,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(334,"Pregnancy Test",NULL,347,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(335,"Procalcitonin (Serum)",NULL,349,1,9,2,1,1,1,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601904274,628,0),
(336,"Progesteron",NULL,350,1,9,2,1,1,2,1,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612271176,12,0),
(337,"Proinsulin",NULL,351,1,9,2,1,1,2,7,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(338,"Prolactin (PRL)",NULL,352,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(339,"Protein (CSF)",NULL,353,1,5,4,1,1,1,23,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601455274,12,0),
(340,"Protein C , Functional",NULL,354,1,9,2,1,1,1,22,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601457046,12,0),
(341,"Protein Electrophorsis",NULL,355,1,9,2,1,1,2,43,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(342,"Protein In Urine",NULL,356,1,15,6,1,1,2,29,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(343,"Protein S , Total",NULL,357,1,9,2,1,1,1,22,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601457250,12,0),
(344,"Protein(24 hr)",NULL,358,1,15,6,1,1,2,3,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(345,"Protein(Fluid)",NULL,359,1,5,10,1,1,2,8,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601815847,628,0),
(346,"Prothrombin G20210A Mutation",NULL,360,1,16,1,1,1,2,2,8,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(347,"PRP(Plazma )",NULL,361,1,7,11,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(348,"T.PSA",NULL,899,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(349,"PT",NULL,363,1,7,3,1,2,2,51,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600075374,12,0),
(350,"PT (Patient)",NULL,0,1,7,3,1,3,1,51,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601457536,12,0),
(351,"PT(Mixing-after incubation)",NULL,0,1,7,3,1,3,2,51,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(352,"PT(Mixing-Immediate)",NULL,0,1,7,3,1,3,2,51,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(353,"PTH",NULL,367,1,9,2,1,1,1,5,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601457624,12,0),
(354,"PTT",NULL,0,1,7,3,1,3,1,51,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600689067,627,0),
(355,"PTT (Patient)",NULL,0,1,7,3,1,3,2,51,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(356,"PTT(Control)",NULL,0,1,7,3,1,3,1,51,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601457683,12,0),
(357,"PTT(Mix-after incubation)",NULL,0,1,7,3,1,3,1,51,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601457724,12,0),
(358,"PTT(Mix-Immediate)",NULL,0,1,7,3,1,3,1,51,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601457759,12,0),
(359,"Quantiferon Tb Gold test(Qiagen)",NULL,373,1,18,13,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(360,"Glucose",NULL,900,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(361,"Reticulocyte",NULL,375,1,16,1,1,1,2,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(362,"Reticulocyte (newborn)",NULL,376,1,16,1,1,1,1,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601457834,12,0),
(363,"RF Factor",NULL,377,1,9,2,1,1,1,6,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601457872,12,0),
(364,"Rota Virus(instool)",NULL,378,1,13,5,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(365,"Rubella   lgG",NULL,379,1,9,2,1,1,1,6,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601457933,12,0),
(366,"Rubella   lgM",NULL,380,1,9,2,1,1,2,19,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(367,"S. Aldosterone",NULL,381,1,9,2,1,1,2,11,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(368,"S. Ca",NULL,382,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(369,"Cholestrole Total",NULL,901,1,9,2,1,1,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600086837,12,0),
(370,"S. Chromogranin A",NULL,384,1,9,2,1,1,2,35,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(371,"S. Copper",NULL,385,1,9,2,1,1,2,40,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(372,"S.Creatinine",NULL,902,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(373,"S. Gastrin",NULL,389,1,9,2,1,1,2,43,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(374,"S. GLOBULIN",NULL,390,1,9,2,1,1,1,8,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601458102,12,0),
(375,"S. Immuno Fixation",NULL,391,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(376,"S. Iron",NULL,392,1,9,2,1,1,1,40,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601458268,12,0),
(377,"s. Renin",NULL,393,1,9,2,1,1,2,54,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(378,"S. Zinc",NULL,903,1,9,2,1,1,2,40,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(379,"S.F.A (Automated)",NULL,395,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(380,"S.F.A (Manuel)",NULL,396,1,9,2,1,2,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1608031485,627,0),
(381,"AST (GOT)",NULL,904,1,9,2,1,1,2,10,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(382,"ALT (GPT)",NULL,905,1,9,2,1,1,2,10,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(383,"Salmonella IgG",NULL,399,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(384,"Salmonella IgM",NULL,400,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(385,"Scl-70",NULL,401,1,9,2,1,1,1,20,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601458461,12,0),
(386,"Scraping for fungus",NULL,402,1,18,13,1,1,2,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(387,"Serum amyloid A",NULL,403,1,9,2,1,1,2,29,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(388,"Serum Free Light Chains",NULL,404,1,9,2,1,1,2,29,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(389,"SHBG",NULL,405,1,9,2,1,1,2,38,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(390,"Sodium(Na+)",NULL,906,1,9,2,1,1,1,34,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601458628,12,0),
(391,"sp.Gravity.",NULL,407,1,9,2,1,1,2,23,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(392,"S-Renin",NULL,408,1,9,2,1,1,2,54,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(393,"Stone Analysis",NULL,409,1,15,6,1,1,2,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(394,"Stool Elastase",NULL,410,1,4,2,1,1,2,2,13,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(395,"Stool Occult Blood",NULL,411,1,4,2,1,1,2,36,13,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(396,"Syphilis Ab",NULL,412,1,9,2,1,1,2,36,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(397,"Syphilis IgG",NULL,413,1,9,2,1,1,1,21,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601458697,12,0),
(398,"Syphilis IgM",NULL,414,1,9,2,1,1,1,21,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601458782,12,0),
(399,"T P H A",NULL,415,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(400,"T.I.B.C",NULL,416,1,9,2,1,1,1,40,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601458916,12,0),
(401,"T.S.B",NULL,417,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(402,"T.S.P",NULL,418,1,9,2,1,1,2,8,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(403,"T3",NULL,419,1,9,2,1,1,1,38,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612271009,12,0),
(404,"T4",NULL,420,1,9,2,1,1,1,38,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601459284,12,0),
(405,"Tacrolimus Level",NULL,421,1,16,1,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(406,"Testosteron",NULL,422,1,9,2,1,1,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(407,"Thick Blood Film(Malaria)",NULL,423,1,16,1,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(408,"Thin Blood film(Malaria)",NULL,424,1,16,1,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(409,"Thrombophilia Panel",NULL,425,1,7,3,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(410,"Thyroglobulin",NULL,426,1,9,2,1,1,1,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601459330,12,0),
(411,"Toxoplasma IgG",NULL,427,1,9,2,1,1,2,6,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(412,"Toxoplasma IgM",NULL,428,1,9,2,1,1,2,15,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(413,"Toxoplasma(RT-PCR)",NULL,429,1,9,2,1,1,2,6,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(414,"TP in Fluid",NULL,0,1,5,10,1,3,2,8,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(415,"TP(CSF)",NULL,0,1,2,10,1,3,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601459446,12,0),
(416,"Transferrin",NULL,432,1,9,2,1,1,1,13,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601459492,12,0),
(417,"Transferrin Saturation",NULL,433,1,9,2,1,1,1,22,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601459544,12,0),
(418,"Triglycerides(TG)",NULL,434,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(419,"Troponin T",NULL,435,1,9,2,1,1,1,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601459643,12,0),
(420,"TSH",NULL,436,1,9,2,1,1,1,55,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612270963,12,0),
(421,"Tuberculosis IGG",NULL,437,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(422,"Tuberculosis IGM",NULL,438,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(423,"U. Immuno Fixation",NULL,439,1,9,2,1,1,2,8,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(424,"U. Protein Electrophoresis(24 H)",NULL,440,1,9,2,1,1,2,8,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(425,"UACR(Urine albumin creatine ratio)",NULL,441,1,15,6,1,1,2,9,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(426,"UIBC",NULL,442,1,9,2,1,1,1,40,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601460080,12,0),
(427,"UPCR(Urine protein creatinine ratio)",NULL,443,1,9,2,1,1,2,9,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(428,"Urea Breath Test",NULL,444,1,9,2,1,1,1,56,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601886382,12,0),
(429,"Urea in Fluid",NULL,0,1,5,10,1,3,2,23,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(430,"Urea in urine",NULL,0,1,15,6,1,3,1,34,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601886502,12,0),
(431,"Urea in urine(24h)",NULL,0,1,15,6,1,3,2,52,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(432,"Urea nitrogen (BUN)",NULL,0,1,15,6,1,3,2,23,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(433,"Urethral Discharge",NULL,0,1,15,6,1,3,2,2,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(434,"Uric acid",NULL,450,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(435,"Uric acid  in Urine",NULL,0,1,15,6,1,3,1,29,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601886575,12,0),
(436,"Uric acid  in Urine (24hrs)",NULL,0,1,15,6,1,3,1,3,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601886629,12,0),
(437,"Urine 24 hr for epinephrine",NULL,0,1,15,6,1,3,2,2,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(438,"Urine Culture and Sensitivity",NULL,907,1,15,6,1,1,3,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600507602,12,0),
(439,"Urine for Bense Jonce Protien",NULL,0,1,15,6,1,3,2,2,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(440,"Urine for Bense Jonce Protien (24 hr)",NULL,0,1,15,6,1,3,2,2,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(441,"Urine for Gonorrhea",NULL,0,1,15,6,1,3,2,2,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(442,"Urine Immuno Fixation",NULL,458,1,15,6,1,2,2,2,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600066526,12,0),
(443,"Urine Osmolality",NULL,459,1,15,6,1,1,2,66,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1608218657,628,0),
(444,"Urine Phophorus(24 hour)",NULL,0,1,15,6,1,3,1,3,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601886681,12,0),
(445,"Urine Specific Gravity",NULL,0,1,15,6,1,3,1,23,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601886776,12,0),
(446,"V.D.R.L",NULL,462,1,9,2,1,1,2,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(447,"Vitamin B12",NULL,908,1,9,2,1,1,1,5,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612270980,12,0),
(448,"Vitamin D3",NULL,909,1,9,2,1,1,2,1,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612270985,12,0),
(449,"VLDL",NULL,465,1,9,2,1,1,2,23,13,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(450,"VMA in Urine(24Hrs)",NULL,466,1,15,2,1,1,2,12,13,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(451,"Von Wellibrand Factor(VWF)",NULL,467,1,7,3,1,1,2,12,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(452,"WBC (Child)",NULL,0,1,16,1,1,3,2,57,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(453,"WBC (Female)",NULL,0,1,16,1,1,3,2,57,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(454,"WBC (Male)",NULL,0,1,16,1,1,3,2,57,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(455,"Widal Test - IgG",NULL,471,1,9,2,1,1,2,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(456,"Widal Test - IgM",NULL,472,1,9,2,1,1,2,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(457,"Widal Test - IgM",NULL,472,1,9,2,1,1,2,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(458,"CMV IgG",NULL,474,1,9,2,1,1,2,6,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(459,"Bilharzia",NULL,475,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(460,"Urine volume (24 hr)",NULL,476,1,15,6,1,1,2,58,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(461,"Keton In Urine",NULL,477,1,15,6,1,1,2,2,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(462,"Immunohistochemistry",NULL,478,1,9,2,1,1,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(463,"HLA B55 (pcr)",NULL,0,1,9,2,1,3,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(464,"Lipid Profile",NULL,910,1,9,2,1,2,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600067426,12,0),
(465,"LFT",NULL,911,1,9,2,1,2,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600070277,12,0),
(466,"A.Ebv-IgG",NULL,484,1,9,2,1,1,2,4,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(467,"Renal Function Test",NULL,912,1,9,2,1,2,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600329077,627,0),
(468,"Total Calcium",NULL,913,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(469,"S.Electrolytes",NULL,914,1,9,2,1,2,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600071611,12,0),
(470,"TFT (Total)",NULL,486,1,9,2,1,2,2,2,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612271460,12,0),
(471,"Viral Screen",NULL,915,1,9,2,1,2,2,2,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1602062135,12,0),
(472,"Bilirubin Total",NULL,916,1,9,2,1,1,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(473,"Protein Total",NULL,917,1,9,2,1,1,2,8,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(474,"Globulin Serum",NULL,918,1,9,2,1,1,2,8,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(475,"Cardiac Enzymes ",NULL,919,1,9,2,1,2,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600073723,12,0),
(476,"Biopsy Small Size ",NULL,920,1,1,8,1,1,2,2,9,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(477,"Wound Swab",NULL,921,1,14,9,1,1,2,2,9,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(478,"Cross match",NULL,922,1,16,1,1,1,2,2,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(479,"Carbamazepine",NULL,923,1,9,2,1,1,2,25,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(480,"Anti-Valporic Acid",NULL,924,1,9,2,1,1,2,25,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(481,"Hct",NULL,0,1,16,1,1,3,2,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(482,"Widal Test - Titer",NULL,926,1,9,2,1,2,2,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600261281,12,0),
(483,"Salmonella Typhi O",NULL,0,1,9,2,1,3,3,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600260950,12,0),
(484,"Salmonella Typhi H",NULL,0,1,9,2,1,3,3,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600260996,12,0),
(485,"Salmonella Paratyphi AO",NULL,0,1,9,2,1,3,3,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600261039,12,0),
(486,"Salmonella Paratyphi BO",NULL,0,1,9,2,1,3,3,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600261079,12,0),
(487,"Salmonella Paratyphi AH",NULL,0,1,9,2,1,3,3,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600261124,12,0),
(488,"Salmonella Paratyphi BH",NULL,0,1,9,2,1,3,3,2,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600261159,12,0),
(489,"PCV",NULL,0,1,16,1,1,3,2,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(490,"Coagulation test ",NULL,934,1,7,3,1,2,2,2,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600075646,12,0),
(491,"Biopsy large size ",NULL,935,1,1,8,1,1,2,22,9,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(492,"SFA",NULL,936,1,10,12,1,2,2,2,13,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(493,"Ferritin",NULL,198,1,9,2,1,1,1,1,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601897073,627,0),
(494,"Urine Sodium",NULL,937,1,15,6,1,1,2,60,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600075923,12,0),
(495,"Urine Potassium",NULL,938,1,15,6,1,1,2,60,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600076042,12,0),
(496,"Urine Chloride ",NULL,939,1,15,6,1,1,2,60,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600076128,12,0),
(497,"Random Urine Electrolytes",NULL,940,1,15,6,1,2,2,2,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600076721,12,0),
(498,"Anti RNP ",NULL,941,1,9,2,1,1,2,15,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(499,"HB A1",NULL,0,1,16,1,1,3,1,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600064642,12,1602071793,627,0),
(500,"HBF",NULL,0,1,16,1,1,3,1,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600065648,12,NULL,NULL,0),
(501,"HB A2",NULL,249,1,16,1,1,3,1,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600065808,12,NULL,NULL,0),
(502,"Protein In Urine(UIF)",NULL,0,1,15,6,1,3,2,29,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(503,"Cholestrole Total",NULL,0,1,9,2,1,3,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1602072022,627,0),
(504,"Triglycerides(TG)",NULL,0,1,9,2,1,3,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1604734030,627,0),
(505,"HDL",NULL,0,1,9,2,1,3,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1604734116,627,0),
(506,"LDL",NULL,0,1,9,2,1,3,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1604734462,627,0),
(507,"AST (GOT)",NULL,0,1,9,2,1,3,2,10,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(508,"ALT (GPT)",NULL,0,1,9,2,1,3,2,10,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(509,"Alkaline Phosphate",NULL,0,1,9,2,1,3,2,10,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(510,"Bilirubin Total",NULL,0,1,9,2,1,3,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(511,"B.Urea",NULL,0,1,9,2,1,3,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601535013,12,0),
(512,"S.Creatinine",NULL,0,1,9,2,1,3,2,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(513,"Sodium(Na+)",NULL,0,1,9,2,1,3,1,34,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601534498,12,0),
(514,"Potassium(K+)",NULL,0,1,9,2,1,3,1,34,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601534691,12,0),
(515,"Chloride(Cl-)",NULL,0,1,9,2,1,3,1,34,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601534777,12,0),
(516,"Ca++ (Ionized Calcium)",NULL,0,1,9,2,1,3,1,34,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601534862,12,0),
(517,"T3",NULL,0,1,9,2,1,3,1,38,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612271016,12,0),
(518,"T4",NULL,0,1,9,2,1,3,1,38,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1609064155,627,0),
(519,"TSH",NULL,0,1,9,2,1,3,1,55,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612271135,12,0),
(520,"FT3",NULL,0,1,9,2,1,3,2,7,10,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1612271020,12,0),
(521,"FT4",NULL,0,1,9,2,1,3,1,7,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1609064192,627,0),
(522,"HIV Combi",NULL,0,1,9,2,1,3,1,15,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600327045,12,0),
(523,"HBs Ag",NULL,0,1,9,2,1,3,1,15,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600326757,12,0),
(524,"HCV Ab",NULL,0,1,9,2,1,3,1,15,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1600326911,12,0),
(525,"CK-MB",NULL,0,1,9,2,1,3,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(526,"Troponin T",NULL,0,1,9,2,1,3,2,1,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(527,"PTT",NULL,368,1,7,3,1,1,2,51,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1604299905,627,0),
(528,"Calcium (Spot Urine)",NULL,0,1,15,6,1,3,2,3,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,NULL,NULL,0),
(529,"Urine Sodium",NULL,0,1,15,6,1,3,1,60,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601534636,12,0),
(530,"Urine Potassium",NULL,0,1,15,6,1,3,1,60,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601534725,12,0),
(531,"Urine Chloride ",NULL,0,1,15,6,1,3,1,60,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1599484584,12,1601534810,12,0),
(532,"Appearance",NULL,0,1,15,6,1,3,3,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600158620,12,1600163919,12,0),
(533,"Glucose",NULL,0,1,15,6,1,3,2,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600158697,12,NULL,NULL,0),
(534,"Bilirubin",NULL,0,1,15,6,1,3,3,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600159799,12,NULL,NULL,0),
(535,"Reaction, PH",NULL,0,1,15,6,1,3,2,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600159840,12,NULL,NULL,0),
(536,"Urobilinogen",NULL,0,1,15,6,1,3,3,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600159932,12,NULL,NULL,0),
(537,"Nitrite",NULL,0,1,15,6,1,3,3,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600159978,12,NULL,NULL,0),
(538,"W.B.C/Epith",NULL,0,1,15,6,1,3,3,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600160051,12,NULL,NULL,0),
(539,"Ketone",NULL,0,1,15,6,1,3,3,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600160106,12,NULL,NULL,0),
(540,"R.B.C/Hb",NULL,0,1,15,6,1,3,2,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600160154,12,NULL,NULL,0),
(541,"W.B.C",NULL,0,1,15,6,1,3,2,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600160188,12,NULL,NULL,0),
(542,"R.B.C",NULL,0,1,15,6,1,3,2,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600160231,12,NULL,NULL,0),
(543,"Epithelial Cells",NULL,0,1,15,6,1,3,2,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600160262,12,NULL,NULL,0),
(544,"Mucus",NULL,0,1,15,6,1,3,2,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600160285,12,NULL,NULL,0),
(545,"Casts",NULL,0,1,15,6,1,3,2,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600160307,12,NULL,NULL,0),
(546,"Crystals",NULL,0,1,15,6,1,3,2,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600160331,12,NULL,NULL,0),
(547,"Parasites",NULL,0,1,15,6,1,3,2,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600160379,12,NULL,NULL,0),
(548,"Protein",NULL,0,1,15,6,1,3,3,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600161022,12,NULL,NULL,0),
(549,"Color",NULL,0,1,13,5,1,3,2,0,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600162389,12,NULL,NULL,0),
(550,"Blood",NULL,0,1,13,5,1,3,3,0,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600162434,12,NULL,NULL,0),
(551,"Consistency",NULL,0,1,13,5,1,3,2,0,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600162466,12,NULL,NULL,0),
(552,"WBCs",NULL,0,1,13,5,1,3,2,61,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600162660,12,1605353022,627,0),
(553,"RBCs",NULL,0,1,13,5,1,3,2,61,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600162718,12,NULL,NULL,0),
(554,"Ova and Parasites",NULL,0,1,13,5,1,3,2,61,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600162765,12,NULL,NULL,0),
(555,"OccultBlood",NULL,0,1,13,5,1,3,2,61,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600162801,12,NULL,NULL,0),
(556,"Others",NULL,0,1,13,5,1,3,2,0,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600162890,12,NULL,NULL,0),
(557,"Mucus",NULL,241,1,13,5,1,3,1,2,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600163141,12,NULL,NULL,0),
(558,"Color",NULL,241,1,15,6,1,3,3,2,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600163748,12,1606305446,628,0),
(559,"Covid 19 - IgG","CIgG",946,1,9,2,1,1,1,0,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600243266,12,NULL,NULL,0),
(560,"Covid 19 - IgM","CIgM",947,1,9,2,1,1,1,0,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600243388,12,NULL,NULL,0),
(561,"Bacteria",NULL,0,1,15,6,1,3,3,0,15,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600356797,12,1609256557,628,0),
(562,"Sputum Culture / Sensitivity","SCS",948,1,12,15,1,1,3,0,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1600507986,12,NULL,NULL,0),
(563,"PH (Fluid)","PHF",1025,1,5,10,1,1,1,0,7,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601813230,12,NULL,NULL,0),
(564,"WBC","WBC",359,1,16,1,1,3,1,67,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601814726,12,1609855786,628,0),
(565,"LYM%","LYM%",359,1,5,10,1,3,1,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601814799,12,1602333730,628,0),
(566,"MON%","MON%",359,1,5,10,1,3,1,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601815998,12,1604163015,628,0),
(567,"NEU%","NEU%",359,1,5,10,1,3,1,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601816185,12,1604163030,628,0),
(568,"Eosinophils%","Eosinophils%",359,1,5,10,1,3,1,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601816239,12,1604163051,628,0),
(569,"Atypic Lymphocytes%","ATYMPHO",359,1,5,10,1,3,1,13,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601816339,12,NULL,NULL,0),
(570,"RBC","RBC",359,1,16,1,1,3,1,63,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601816409,12,1609855840,628,0),
(571,"HGB","HGB",359,1,16,1,1,3,1,8,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601816518,12,NULL,NULL,0),
(572,"HCT","HCT",0,1,16,1,1,3,1,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601816635,12,NULL,NULL,0),
(573,"MCV","MCV",0,1,16,1,1,3,1,68,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601816756,12,1604163135,628,0),
(574,"MCH","MCH",0,1,16,1,1,3,1,65,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601816831,12,NULL,NULL,0),
(575,"MCHC","MCHC",0,1,16,1,1,3,1,8,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601816884,12,NULL,NULL,0),
(576,"PLT","PLT",0,1,16,1,1,3,1,69,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601816982,12,1604163250,628,0),
(577,"NRBC%","NRBC%",0,1,16,1,1,3,1,22,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601817043,12,NULL,NULL,0),
(578,"Serum Osmolality","serumOsmo",1026,1,9,2,1,1,1,66,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601887891,12,1608222337,628,0),
(579,"Cell Count(CSF)",NULL,135,1,2,4,1,1,1,32,13,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1601995205,12,1601995223,12,0),
(580,"Faty Drops","FD",0,1,13,5,1,3,2,0,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1602491820,12,NULL,NULL,0),
(581,"Undigested Food","UF",0,1,13,5,1,3,2,0,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1602492423,12,NULL,NULL,0),
(582,"Monilia","Mo",0,1,13,5,1,3,2,0,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1602492932,12,NULL,NULL,0),
(584,"Interleukin6","IL6",1033,1,9,2,1,1,1,5,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1603198603,12,NULL,NULL,0),
(585,"H.Pylori in Blood","HPiB",1034,1,9,2,1,1,3,0,14,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1603628803,12,NULL,NULL,0),
(586,"B type Natriuretic Peptide (BNP)","BNP",1035,1,9,2,1,1,1,5,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1603803166,628,1603808882,628,0),
(587,"glucose tolerance test (GTT)","GTT",1070,1,9,2,1,2,1,23,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1606230396,627,1606751696,627,0),
(588,"Swab culture and sensitivity",NULL,1071,1,14,8,1,1,1,0,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1606751276,627,NULL,NULL,0),
(589,"Fluid culture and sensitivity",NULL,1072,1,5,8,1,1,1,0,3,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1606751395,627,NULL,NULL,0),
(590,"Time Of Collection","Time",0,1,10,10,1,3,1,0,7,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1607962670,628,NULL,NULL,0),
(591,"Period Of Abstinence ","POF",0,1,10,10,1,3,2,0,7,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1607962879,628,NULL,NULL,0),
(592,"Color","Color",0,1,10,10,1,3,3,0,7,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1607963041,628,NULL,NULL,0),
(593,"Consistency ","CON",0,1,10,10,1,3,3,0,7,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1607963326,628,NULL,NULL,0),
(594,"Liquefaction Complete","LFC",0,1,10,10,1,3,2,0,7,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1607963490,628,NULL,NULL,0),
(595,"PH ( SFA)","PHSFA",0,1,10,10,1,3,2,0,7,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1607963609,628,NULL,NULL,0),
(596,"Volume ","V",0,1,10,10,1,3,1,53,7,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1607963763,628,1607963891,628,0),
(597,"Sperm Count","SC",0,1,10,10,1,3,2,NULL,7,NULL,NULL,0,0,0,0,0,0,0,0,0,0,1607963946,628,1608987454,628,0),
(598,"WBC","WBC",0,1,10,10,1,3,1,NULL,7,NULL,NULL,0,0,0,0,0,0,0,0,0,0,1607964042,628,1610542593,627,0),
(599,"RBC","RBC",0,1,10,10,1,3,1,NULL,7,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1607964083,628,1608987394,628,0),
(600,"Normal Sperm","NS",0,1,10,10,1,3,2,22,7,NULL,NULL,0,0,0,0,0,0,0,0,0,0,1607964138,628,1608987319,628,0),
(601,"Abnormal Sperm","AS",0,1,10,10,1,3,2,22,7,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1607964211,628,1608987306,628,0),
(602,"Motile","M",0,1,10,10,1,3,2,22,7,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1607964250,628,1608987288,628,0),
(603,"Sluggish","SG",0,1,10,10,1,3,2,22,7,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1607964279,628,1608987274,628,0),
(604,"Non-motile","NM",0,1,10,10,1,3,2,22,7,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1607964328,628,1608987254,628,0),
(605,"Blood Film ",NULL,0,1,3,1,1,3,2,0,1,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1608538204,12,1608540029,12,0),
(606,"PCR",NULL,1108,1,14,0,1,1,1,0,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1608560128,628,NULL,NULL,0),
(607,"eAG","AG",0,1,16,1,1,1,1,0,2,NULL,NULL,0,0,0,0,0,0,0,0,0,0,1609688892,628,NULL,NULL,0),
(608,"HOMA-IR",NULL,1148,1,9,2,1,1,1,22,2,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1610780653,627,1610788090,628,0),
(609,"COVID-19 (IGG) by ELISA",NULL,1152,1,9,2,1,1,1,22,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1611136403,627,1611136933,627,0),
(610,"COVID-19 (IGM) by ELISA",NULL,1153,1,9,2,1,1,1,22,16,NULL,NULL,0,0,0,0,0,1,0,0,0,1,1611136713,627,1611136942,627,0);


DROP TABLE lab_tube_types;

CREATE TABLE `lab_tube_types` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) NOT NULL,
  `code` varchar(64) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `color` varchar(16) DEFAULT NULL,
  `created` int(11) DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `modified` int(11) DEFAULT NULL,
  `modified_by` bigint(20) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

INSERT INTO lab_tube_types VALUES
(1,"EDTA","EDTA",NULL,"#9c20d5",NULL,NULL,NULL,NULL,0),
(2,"Gel Tube","Gel",NULL,"#e4e732",NULL,NULL,NULL,NULL,0),
(3,"Citrate","Citrate",NULL,"#3218fb",NULL,NULL,NULL,NULL,0),
(4,"CSF","CSF",NULL,"#ffffff",NULL,NULL,NULL,NULL,0),
(5,"Stool Cup","SC",NULL,"#600614",NULL,NULL,NULL,NULL,0),
(6,"Urine Cup","UC",NULL,"#f7082c",NULL,NULL,NULL,NULL,0),
(7,"Biopsy Slide","BS",NULL,"#ffffff",NULL,NULL,NULL,NULL,0),
(8,"Cup","C",NULL,"#ffffff",NULL,NULL,NULL,NULL,0),
(9,"Dry Tube","DT",NULL,"#ffffff",NULL,NULL,NULL,NULL,0),
(10,"Fluid Cup","FC",NULL,"#ffffff",NULL,NULL,NULL,NULL,0),
(11,"PRP Tube","PT",NULL,"#ffffff",NULL,NULL,NULL,NULL,0),
(12,"Semen Cup","SeC",NULL,"#ffffff",NULL,NULL,NULL,NULL,0),
(13,"Skin","S",NULL,"#ffffff",NULL,NULL,NULL,NULL,0),
(14,"Slide","SL",NULL,"#ffffff",NULL,NULL,NULL,NULL,0),
(15,"Sputum Cup","SpC",NULL,"#ffffff",NULL,NULL,NULL,NULL,0),
(16,"Wound Cup","Wc",NULL,"#ffffff",NULL,NULL,NULL,NULL,0);


DROP TABLE locations;

CREATE TABLE `locations` (
  `LocationId` bigint(20) NOT NULL AUTO_INCREMENT,
  `Name` varchar(500) DEFAULT NULL,
  `CreateDate` datetime DEFAULT NULL,
  `ModificationDate` datetime DEFAULT NULL,
  `Deleted` tinyint(1) DEFAULT NULL,
  `Notes` longtext DEFAULT NULL,
  `CreatedByUserId` bigint(20) DEFAULT NULL,
  `ModifiedByUserId` bigint(20) DEFAULT NULL,
  `CityId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`LocationId`),
  KEY `FK_Locations_Cities` (`CityId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO locations VALUES
(1,"Erbil","2020-07-18 14:39:25",NULL,0,NULL,12,NULL,NULL);


DROP TABLE logistic_purchase_budget_items;

CREATE TABLE `logistic_purchase_budget_items` (
  `logistic_purchase_budget_item_id` int(11) NOT NULL AUTO_INCREMENT,
  `PurchaseId` int(11) DEFAULT NULL,
  `Code` varchar(45) DEFAULT NULL,
  `Description` varchar(500) DEFAULT NULL,
  `Qty` decimal(18,6) DEFAULT NULL,
  `Price` decimal(18,6) DEFAULT NULL,
  `Unit` varchar(50) DEFAULT NULL,
  `RequestNo` int(11) DEFAULT NULL,
  `ProjectId` int(11) DEFAULT NULL,
  `CurrencyId` bigint(20) DEFAULT NULL,
  `Remark` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`logistic_purchase_budget_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE logistic_purchases;

CREATE TABLE `logistic_purchases` (
  `PurchaseId` int(11) NOT NULL AUTO_INCREMENT,
  `Date` date DEFAULT NULL,
  `DonorId` int(11) DEFAULT NULL,
  `ProjectId` int(11) DEFAULT NULL,
  `DepartmentId` int(11) DEFAULT NULL,
  `Subject` varchar(45) DEFAULT NULL,
  `Total` decimal(18,6) DEFAULT NULL,
  `DeliveryDate` date DEFAULT NULL,
  `DeliverLocationId` int(11) DEFAULT NULL,
  `No` int(11) DEFAULT NULL,
  `SupplierName` varchar(500) DEFAULT NULL,
  `SupplierAddress` varchar(500) DEFAULT NULL,
  `SupplierPhone` varchar(500) DEFAULT NULL,
  `SupplierEmail` varchar(500) DEFAULT NULL,
  `PurchaseType` int(11) DEFAULT NULL,
  `Notes` varchar(500) DEFAULT NULL,
  `Deleted` tinyint(1) DEFAULT NULL,
  `CreateDate` datetime DEFAULT NULL,
  `ModificationDate` datetime DEFAULT NULL,
  `CreatedByUserId` int(11) DEFAULT NULL,
  `ModifiedByUserId` int(11) DEFAULT NULL,
  `Status` int(11) DEFAULT NULL,
  `ReferenceNumber` varchar(500) DEFAULT NULL,
  `ParentPurchaseId` int(11) DEFAULT NULL,
  `Attachment` varchar(500) DEFAULT NULL,
  `Track` longtext DEFAULT NULL,
  `BillTo` varchar(250) DEFAULT NULL,
  `BillAddress` varchar(250) DEFAULT NULL,
  `BillTel` varchar(250) DEFAULT NULL,
  `BillEmail` varchar(250) DEFAULT NULL,
  `ShipTo` varchar(250) DEFAULT NULL,
  `ShipAddress` varchar(250) DEFAULT NULL,
  `ShipTel` varchar(250) DEFAULT NULL,
  `ShipEmail` varchar(250) DEFAULT NULL,
  `ShipContact` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`PurchaseId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE logistic_transportation_items;

CREATE TABLE `logistic_transportation_items` (
  `logistic_transportation_item_id` int(11) NOT NULL AUTO_INCREMENT,
  `emp_number` int(11) DEFAULT NULL,
  `reason_of_visit` varchar(500) DEFAULT NULL,
  `logistic_transportation_id` int(11) DEFAULT NULL,
  `departure_time` time DEFAULT NULL,
  `return_time` time DEFAULT NULL,
  `departure_location` varchar(500) DEFAULT NULL,
  `arrival_location` varchar(500) DEFAULT NULL,
  `CurrencyId` bigint(20) DEFAULT NULL,
  `ProjectId` int(11) DEFAULT NULL,
  PRIMARY KEY (`logistic_transportation_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE logistic_transportations;

CREATE TABLE `logistic_transportations` (
  `logistic_transportation_id` int(11) NOT NULL AUTO_INCREMENT,
  `transportation_date` date DEFAULT NULL,
  `transportation_type` int(11) DEFAULT NULL,
  `driver` varchar(500) DEFAULT NULL,
  `startin_odometer` int(11) DEFAULT NULL,
  `return_odometer` int(11) DEFAULT NULL,
  `vehicle_type` varchar(500) DEFAULT NULL,
  `vehicle_plater_number` varchar(500) DEFAULT NULL,
  `Notes` varchar(500) DEFAULT NULL,
  `Deleted` tinyint(1) DEFAULT NULL,
  `CreateDate` datetime DEFAULT NULL,
  `ModificationDate` datetime DEFAULT NULL,
  `CreatedByUserId` int(11) DEFAULT NULL,
  `ModifiedByUserId` int(11) DEFAULT NULL,
  `RequestedCars` int(11) DEFAULT NULL,
  `ProjectId` int(11) DEFAULT NULL,
  PRIMARY KEY (`logistic_transportation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE menupermessions;

CREATE TABLE `menupermessions` (
  `menupermessionsId` int(11) NOT NULL AUTO_INCREMENT,
  `menuId` int(11) DEFAULT NULL,
  `permessionId` int(11) DEFAULT NULL,
  PRIMARY KEY (`menupermessionsId`),
  KEY `permession_FK_idx` (`permessionId`),
  KEY `menu_FK_idx` (`menuId`)
) ENGINE=InnoDB AUTO_INCREMENT=1892 DEFAULT CHARSET=utf8;

INSERT INTO menupermessions VALUES
(334,121,23),
(335,122,23),
(336,124,23),
(850,57,27),
(851,3,27),
(852,20,27),
(853,30,27),
(854,27,27),
(855,39,27),
(856,110,27),
(857,28,27),
(859,129,22),
(860,125,22),
(861,126,22),
(862,138,22),
(996,137,24),
(997,139,24),
(998,45,24),
(999,52,24),
(1000,121,24),
(1001,122,24),
(1002,135,24),
(1003,107,24),
(1620,68,25),
(1621,86,25),
(1622,91,25),
(1623,58,25),
(1624,66,25),
(1625,43,25),
(1626,52,25),
(1627,50,25),
(1628,53,25),
(1629,46,25),
(1630,78,25),
(1631,48,25),
(1632,61,25),
(1633,49,25),
(1634,71,25),
(1635,72,25),
(1636,70,25),
(1637,47,25),
(1638,76,25),
(1639,45,25),
(1640,94,25),
(1641,56,25),
(1642,54,25),
(1643,64,25),
(1644,60,25),
(1645,69,25),
(1646,65,25),
(1647,62,25),
(1648,59,25),
(1649,98,25),
(1650,40,25),
(1651,41,25),
(1652,42,25),
(1653,93,25),
(1654,120,25),
(1655,87,25),
(1656,88,25),
(1657,132,25),
(1658,83,25),
(1659,23,25),
(1660,136,25),
(1661,144,25),
(1662,142,25),
(1663,90,25),
(1664,143,25),
(1665,145,25),
(1666,107,21),
(1667,109,21),
(1668,128,21),
(1669,108,21),
(1670,131,21),
(1671,133,21),
(1672,147,21),
(1673,135,21),
(1674,146,21),
(1675,24,9),
(1676,40,9),
(1677,45,9),
(1678,57,9),
(1679,77,9),
(1680,83,9),
(1681,86,9),
(1682,107,9),
(1683,110,9),
(1684,111,9),
(1685,112,9),
(1686,119,9),
(1687,10,9),
(1688,11,9),
(1689,13,9),
(1690,14,9),
(1691,16,9),
(1692,17,9),
(1693,32,9),
(1694,33,9),
(1695,41,9),
(1696,42,9),
(1697,43,9),
(1698,93,9),
(1699,46,9),
(1700,51,9),
(1701,61,9),
(1702,70,9),
(1703,71,9),
(1704,72,9),
(1705,73,9),
(1706,75,9),
(1707,47,9),
(1708,48,9),
(1709,49,9),
(1710,50,9),
(1711,54,9),
(1712,56,9),
(1713,58,9),
(1714,59,9),
(1715,98,9),
(1716,52,9),
(1717,53,9),
(1718,2,9),
(1719,3,9),
(1720,7,9),
(1721,12,9),
(1722,15,9),
(1723,19,9),
(1724,20,9),
(1725,21,9),
(1726,27,9),
(1727,28,9),
(1728,29,9),
(1729,30,9),
(1730,34,9),
(1731,35,9),
(1732,37,9),
(1733,38,9),
(1734,39,9),
(1735,44,9),
(1736,79,9),
(1737,84,9),
(1738,64,9),
(1739,66,9),
(1740,68,9),
(1741,69,9),
(1742,60,9),
(1743,62,9),
(1744,65,9),
(1745,76,9),
(1746,78,9),
(1747,1,9),
(1748,6,9),
(1749,18,9),
(1750,25,9),
(1751,26,9),
(1752,36,9),
(1753,81,9),
(1754,82,9),
(1755,22,9),
(1756,23,9),
(1757,80,9),
(1758,87,9),
(1759,88,9),
(1760,90,9),
(1761,91,9),
(1762,92,9),
(1763,94,9),
(1764,96,9),
(1765,97,9),
(1766,99,9),
(1767,100,9),
(1768,101,9),
(1769,102,9),
(1770,105,9),
(1771,106,9),
(1772,104,9),
(1773,108,9),
(1774,109,9),
(1775,120,9),
(1776,121,9),
(1777,122,9),
(1778,124,9),
(1779,125,9),
(1780,126,9),
(1781,128,9),
(1782,129,9),
(1783,130,9),
(1784,131,9),
(1785,132,9),
(1786,133,9),
(1787,134,9),
(1788,135,9),
(1789,136,9),
(1790,137,9),
(1791,138,9),
(1792,139,9),
(1793,145,9),
(1794,144,9),
(1843,71,26),
(1844,24,26),
(1845,72,26),
(1846,68,26),
(1847,73,26),
(1848,128,26),
(1849,146,26),
(1850,108,26),
(1851,135,26),
(1852,122,26),
(1853,125,26),
(1864,24,29),
(1865,72,29),
(1866,73,29),
(1867,71,29),
(1868,133,29),
(1869,124,29),
(1870,122,29),
(1871,72,28),
(1872,94,28),
(1873,126,28),
(1874,125,28),
(1875,122,28),
(1876,133,28),
(1877,128,28),
(1878,73,28),
(1879,71,28),
(1880,24,28),
(1881,137,30),
(1882,72,30),
(1883,68,30),
(1884,24,30),
(1885,77,30),
(1886,1,30),
(1887,73,30),
(1888,133,30),
(1889,128,30),
(1890,122,30),
(1891,130,30);


DROP TABLE menus;

CREATE TABLE `menus` (
  `MenuId` int(11) NOT NULL AUTO_INCREMENT,
  `MenuTitle` varchar(45) DEFAULT NULL,
  `MenuIcon` varchar(25) DEFAULT NULL,
  `MenuKey` varchar(45) DEFAULT NULL,
  `PageName` varchar(45) DEFAULT NULL,
  `Link` varchar(300) DEFAULT '#',
  `Parent` int(11) DEFAULT NULL,
  `Sort` tinyint(3) DEFAULT NULL,
  `isHidden` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`MenuId`),
  KEY `Parent_Mennu_FK_idx` (`Parent`)
) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8 COMMENT='this table will controll the menus displayed in the sidebar';

INSERT INTO menus VALUES
(1,"Items","icon-cube4","items","itemList.php","itemList.php",77,1,0),
(2,"Contacts","icon-user-tie","contacts","contacts.php","contacts.php",57,2,0),
(3,"Accounts","icon-lan2","accounts","accounts.php","accounts.php",57,3,0),
(6,"Inventories","icon-home2","inventories","inventories.php","inventories.php",77,4,0),
(7,"Banks","icon-library2","banks","#","#",57,15,0),
(10,"Bank List","icon-list-ordered","banklist","banks.php","banks.php",7,16,0),
(11,"Bank Accounts","icon-clipboard4","bank-accounts","bankaccounts.php","bankaccounts.php",7,17,0),
(12,"Purchases","icon-list-ordered","purchases","#","#",57,-80,0),
(13,"Bills","icon-list-ordered","bills","purchases.php","purchases.php",12,9,0),
(14,"Bill Payments","icon-clipboard4","bill-payments","purchasePayments.php","purchasePayments.php",12,10,0),
(15,"Sales","icon-cart","sales","#","#",57,5,0),
(16,"Sales List","icon-list-ordered","sales-list","sales.php","sales.php",15,6,0),
(17,"Receive Payments","icon-clipboard4","receive-payments","salePayments.php","salePayments.php",15,7,0),
(18,"Transfer Inventories"," icon-stackoverflow","transfer-inventory","transferInventory.php","transferInventory.php",77,12,0),
(19,"Expense","icon-bus","expense","expense.php","expense.php",57,13,0),
(20,"Manual Journal","icon-book","manual-journal","manualJornal.php","manualJornal.php",57,11,0),
(21,"Safes","icon-safe","safes","safes.php","safes.php",57,14,0),
(22,"Currency Rates"," icon-chart","currency-rates","currencyRates.php","currencyRates.php",83,15,0),
(23,"System Options"," icon-gear","systemoptions","systemOptions.php","systemOptions.php",83,16,0),
(24,"Dashbord"," icon-stats-bars2","dashboard","accountingDashboard.php","accountingDashboard.php",NULL,-128,0),
(25,"Add Item {Hidden Menu}","icon-package","add-item","addItemForm.php","addItemForm.php",77,1,1),
(26,"Edit Item {Hidden Menu}","icon-package","edit-item","editItemForm.php","editItemForm.php",77,1,1),
(27,"Trial Balance {Hidden Menu}"," icon-balance","trial-balance","trialBalance.php","trialBalance.php",57,1,1),
(28,"Reports","icon-graph","reports","Reports.php","Reports.php",57,20,0),
(29,"Profit & loss {Hidden Menu}"," icon-coin-dollar","profit-loss","profit&loss.php","profit&loss.php",57,1,1),
(30,"Balance Sheet {Hidden Menu}","icon-cash","balance-sheet","balanceSheet.php","balanceSheet.php",57,1,1),
(31,"Production"," icon-design","production","#","#",NULL,-80,0),
(32,"Production List","icon-design","production-list","production.php","production.php",31,9,0),
(33,"Sleter List","icon-design","sleter-list","sliter.php","sliter.php",31,10,0),
(34,"Purchase Report {Hidden Menu}"," icon-stats-dots","purchase-report","purchaseReport.php","purchaseReport.php",57,1,1),
(35,"Sales Report {Hidden Menu}"," icon-stats-dots","sale-report","saleReport.php","saleReport.php",57,1,1),
(36,"Starting Inventory","icon-newspaper2","starting-inventory","Startinginventory.php","Startinginventory.php",77,4,0),
(37,"Starting Balance","icon-user-tie","starting-balance","startingBalance.php","startingBalance.php",57,2,1),
(38,"Print Sale {Hidden Menu}","icon-printer","print-sale","printSale.php","printSale.php",57,1,1),
(39,"Extract Account Transactions {Hidden Menu}"," icon-printer","extract-account-transation","extractAccountTrans.php","extractAccountTrans.php",57,1,1),
(40,"Payroll"," icon-wallet","payroll","#","#",NULL,2,0),
(41,"Payroll Fields"," icon-puzzle2","payroll-fields","Fields.php","payroll/Fields.php",40,2,0),
(42,"Payroll Template"," icon-table2","payroll-template","Template.php","payroll/Template.php",40,2,0),
(43,"Generate Salary"," icon-gear","generate-salary","AssignPayroll.php","payroll/AssignPayroll.php",40,2,0),
(44,"Contact Balance","icon-user-tie","contact-balance","contactBalance.php","contactBalance.php",57,2,1),
(45,"Human Resource"," icon-users4","hr","#","#",NULL,5,0),
(46,"HR Setting"," icon-briefcase","hr-admin","#","#",45,5,0),
(47,"HR Users"," icon-users","hr-user","users.php","hr/users.php",46,5,0),
(48,"HR Jobs"," icon-reading","hr-jobs","#","#",46,5,0),
(49,"HR Organization"," icon-city","hr-organization","#","#",46,5,0),
(50,"HR  Nationalities"," icon-earth","nationalities","nationalities.php","hr/nationalities.php",46,5,1),
(51,"HR PIM","icon-typewriter","hr-pim","#","#",45,5,1),
(52,"Employee List"," icon-list","hr-employee-list","emplist.php","hr/emplist.php",45,1,0),
(53,"HR  New Employee"," icon-plus","new-employee","newemp.php","hr/newemp.php",45,5,-1),
(54,"Job Titles"," icon-reading","job-title","jobs.php","hr/jobs.php",48,5,0),
(56,"Job Catagory"," icon-tree7","job-category","jobcatagory.php","hr/jobcatagory.php",48,5,0),
(57,"Accounting","icon-notebook","accounting","#","#",NULL,1,0),
(58,"Employment Status"," icon-notebook","employment-status","employmentstatus.php","hr/employmentstatus.php",48,5,0),
(59,"Orgnazation Info"," icon-city","organization-info","organization.php","hr/organization.php",49,5,0),
(60,"Leave Holiday"," icon-list-numbered","leave-holiday","viewHolidayList.php","hr/viewHolidayList.php",64,5,0),
(61,"Leave Management"," icon-exit3","hr-leave","#","#",45,5,0),
(62,"Leave Types"," icon-list-numbered","leave-types","leaveType.php","hr/leaveType.php",64,5,0),
(63,"Work Weeks"," icon-list-numbered","work-weeks","workWeek.php","hr/workWeek.php",64,5,0),
(64,"Leave Setting"," icon-gear","leave-config","#","#",61,5,0),
(65,"Leave Period"," icon-list-numbered","leave-period","leavePeriod.php","hr/leavePeriod.php",64,5,0),
(66,"Entitlements"," icon-book","entitlements","viewLeaveEntitlements.php","hr/viewLeaveEntitlements.php",64,5,0),
(68,"Assign Leave","icon-exit","assign-leave","assignLeave.php","hr/assignLeave.php",61,5,0),
(69,"Leave Report"," icon-list2","leave-list","viewLeaveList.php","hr/viewLeaveList.php",61,6,0),
(70,"Notifications"," icon-bubble-notification","hr-user-dashboard","HrUserDashboard.php","hr/HrUserDashboard.php",61,2,0),
(71,"My Leave Requests","icon-drawer-out","hr-personal-leave-list","HrUserPersonalLeaveList.php","hr/HrUserPersonalLeaveList.php",61,2,0),
(72,"Ask for Leave","icon-add","hr-request-leave","requestLeave.php","hr/requestLeave.php",61,5,0),
(73,"My Leave Balance"," icon-bubble-notification","hr-employee-dashboard","HrEmpDashboard.php","hr/HrEmpDashboard.php",61,2,0),
(74,"Face Recognizer","icon-eye","face-recognizer","faceRecognizer.php","faceRecognizer.php",NULL,1,0),
(75,"HR Recruitment","icon-users4","hr-recruitment","#","#",45,5,0),
(76,"HR Vacancy","icon-users","hr-vacancy","vacancy.php","hr/vacancy.php",75,5,0),
(77,"Inventory","icon-package","inventory","#","#",NULL,1,0),
(78,"HR Candidates","icon-users","hr-candidate","viewCandidates.php","hr/viewCandidates.php",75,5,0),
(79,"Contact Report {Hidden Menu}"," icon-stats-dots","contact-report","contactReport.php","contactReport.php",57,1,1),
(80,"Reporting Tools"," icon-file-stats","reporting-tools","#","#",83,15,0),
(81,"Report Designer"," icon-file-stats","report-designer","reportDesigner.php","reportDesigner.php",80,15,0),
(82,"Report List"," icon-list","report-list","reportList.php","reportList.php",80,15,0),
(83,"System Setting"," icon-gear","core","#","#",NULL,15,0),
(84,"Trash","icon-trash","trashcan","trashcan.php","trashcan.php",57,100,0),
(86,"Attendance","icon-list-numbered","attendance","#","#",NULL,1,0),
(87,"Shift List"," icon-list-numbered","shift-list","shiftList.php","attendance/shiftList.php",86,7,0),
(88,"Timetable List"," icon-list-numbered","time-sheet-list","timeSheetList.php","attendance/timeSheetList.php",86,6,0),
(89,"Departments","fa fa-sitemap","hr-departments","hrdepartments.php","hr/hrdepartments.php",46,22,0),
(90,"Check IN/Out"," icon-alarm","checkin-out","checkin-out.php","attendance/checkin-out.php",86,0,0),
(91,"Generate Logs"," icon-book","attendance-logs","attendancelogs.php","attendance/attendancelogs.php",86,2,0),
(92,"Manual Checkin/checkout"," icon-hand","manual-attendance","manualattend.php","attendance/manualattend.php",86,23,0),
(93,"Payslip Receipt"," icon-printer4","payslip","payslip.php","payroll/payslip.php",40,23,1),
(94,"Import From Device"," icon-enter6","import-logs","importlogs.php","attendance/importlogs.php",86,1,0),
(95,"Restaurant"," icon-coffee","restaurant","#","#",NULL,1,0),
(96,"Import From Device (Restaurant)"," icon-enter6","restaurant-import-logs","importlogs.php","restaurant/importlogs.php",95,23,0),
(97,"Definitions"," icon-equalizer","restaurant-definitions","definitions.php","restaurant/definitions.php",95,23,0),
(98,"Orgnazation Structure","fa fa-sitemap","organization-structure","definitions.php","hr/definitions.php",49,5,0),
(99,"Meals","fa fa-cutlery","meals","meals.php","restaurant/meals.php",95,24,0),
(100,"Restaurant Programs","fa fa-cutlery","restaurant-programs","restaurant_programs.php","restaurant/restaurant_programs.php",95,25,0),
(101,"Employee Crediting","fa fa-cutlery","employee-crediting","employee_crediting.php","restaurant/employee_crediting.php",95,26,0),
(102,"Restaurant Transactions","fa fa-cutlery","restaurant-transactions","restaurant_transactions.php","restaurant/restaurant_transactions.php",95,27,0),
(103,"Clinic","fa fa-hospital-o","clinic","#","#",NULL,1,0),
(104,"Visit List","icon-list","visit-list-clinic","clinic_visit_list.php","clinic/clinic_visit_list.php",103,1,0),
(105,"Restaurant Reports","icon-graph","restaurant-reports","Reports.php","restaurant/Reports.php",95,28,0),
(106,"Report Restaurant Transactions (Hidden Menu)","icon-graph","restaurant-transaction-reports","report_restaurant_transactions.php","restaurant/report_restaurant_transactions.php",95,29,1),
(107,"Project Management","fa fa-tasks","project","#","#",NULL,10,0),
(108,"Project Definitions"," icon-equalizer","project-definitions","definitions.php","project/definitions.php",107,6,0),
(109,"Projects"," fa fa-tasks","projects","projects.php","project/projects.php",107,1,0),
(110,"Extract Transactions Types {Hidden Menu}","icon-printer","extract-transaction-types","extractTransTypes.php","extractTransTypes.php",NULL,1,1),
(111,"Track Item Report {Hidden Menu}","icon-printer","item-transaction-report","itemtransactionReport.php","itemtransactionReport.php",NULL,1,1),
(112,"Inventory Adjustments"," icon-design","inventory-adjustment","inventroyAdjustments.php","inventroyAdjustments.php",77,5,0),
(119,"Advanced Payments","icon-clipboard4","advanced-payment","advancedPayments.php","advancedPayments.php",2,7,1),
(120,"Responsibilities","fa fa-tasks","hr-job-responsibilities","hr_job_responsibilities.php","hr/hr_job_responsibilities.php",48,0,0),
(121,"Logistics","fa fa-car","logistic","#","#",NULL,5,0),
(122,"Purchase Requests","fa fa-list-alt","purchase-requests","purchases.php?type=1","logistic/purchases.php?type=1",121,1,0),
(124,"Purchase Orders","fa fa-list-alt","purchase-orders","purchases.php?type=2","logistic/purchases.php?type=2",121,2,0),
(125,"Transportation Plan","fa fa-list-alt","transportation-plans","transportations.php?type=1","logistics/transportations.php?type=1",129,3,0),
(126,"Actual Transportation","fa fa-list-alt","transportation-report","transportations.php?type=2","logistics/transportations.php?type=2",129,4,0),
(128,"Payment Vouchers","fa fa-file","payment-vouchers","payment_vouchers.php","project/payment_vouchers.php",107,7,0),
(129,"Transportation","fa fa-car","transportation","#","#",NULL,5,0),
(130,"Work Flow","fa fa-recycle","hr-workflows","hr_job_workflows.php","hr/hr_job_workflows.php",48,4,0),
(131,"Expense Payments (Hidden Menu)","icon-graph","expense-payments","expensePayments.php","expensePayments.php",57,5,1),
(132,"Employee Schedules","icon-list-numbered","employee-shift-list","employeeShiftList.php","attendance/employeeShiftList.php",86,8,0),
(133,"Payment Receipts","fa fa-file","payment-receipts","payment_receipts.php","project/payment_receipts.php",107,8,0),
(134,"Check IN/OUT List","icon-book","inout-log-list","inoutloglist.php","attendance/inoutloglist.php",86,2,0),
(135,"Project Reports","icon-graph","project-reports","project-reports.php","project/Reports.php",107,20,0),
(136,"HR Reports"," icon-graph","hr-reports","HR_Reports.php","hr/HR_Reports.php",45,5,0),
(137,"NGO Assets"," icon-graph","ngo-assets","ngo_assets.php","hr/ngo_assets.php",139,15,0),
(138,"Transportation Reports"," icon-graph","transportation-reports","transportation-reports.php","logistics/Reports.php",129,15,0),
(139,"Administrator","fa fa-shield","administrator","#","#",NULL,30,0),
(140,"Transaction Pending","icon-drawer","transaction-pending","transaction-pending.php","apps/inventory/view/transaction-pending.php",6,7,0),
(141,"Item Revision","icon-drawer","item-revision","item-revision.php","apps/inventory/view/item-revision.php",6,8,0),
(142,"Attendance Settings","icon-cog","attendance-settings","attendance-settings.php","apps/attendance/view/attendance-settings.php",86,9,0),
(143,"Generated Logs","icon-stack","generated-logs","generated-logs.php","apps/attendance/view/generated-logs.php",86,3,0),
(144,"Actual Logs","icon-calendar5","actual-logs","actual-logs.php","apps/attendance/view/actual-logs.php",86,4,0),
(145,"Logs on Map","icon-location4","checkin-out-list-on-map","checkin-out-list-on-map.php","apps/attendance/view/checkin-out-list-on-map.php",86,5,0),
(146,"Project Budget Report","icon-graph","project-budget-line-report","project_budget_line_report.php","apps/project/view/project_budget_line_report.php",107,15,-1),
(147,"Transaction List","icon-graph","project-transaction-list","transaction_list.php","apps/project/view/transaction_list.php",107,16,-1),
(148,"Edit HR Employee","icon-pencil","edit-employee","editemp.php","hr/editemp.php",45,10,-1),
(149,"Profile"," icon-user","profile","profile.php","profile.php",83,16,-1),
(150,"Users and Roles","icon-user-lock","user-roles","user-roles.php","user-roles.php",83,16,-1);


DROP TABLE menus2;

CREATE TABLE `menus2` (
  `MenuId` int(11) NOT NULL,
  `MenuTitle` varchar(45) DEFAULT NULL,
  `MenuIcon` varchar(25) DEFAULT NULL,
  `MenuKey` varchar(45) DEFAULT NULL,
  `PageName` varchar(45) DEFAULT NULL,
  `Link` varchar(300) DEFAULT '#',
  `Parent` int(11) DEFAULT NULL,
  `Sort` tinyint(3) DEFAULT NULL,
  `isHidden` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='this table will controll the menus displayed in the sidebar';

INSERT INTO menus2 VALUES
(1,"Items","icon-cube4","items","itemList.php","itemList.php",77,1,0),
(2,"Contacts","icon-user-tie","contacts","contacts.php","contacts.php",57,2,0),
(3,"Accounts","icon-lan2","accounts","accounts.php","accounts.php",57,3,0),
(6,"Inventories","icon-home2","inventories","inventories.php","inventories.php",77,4,0),
(7,"Banks","icon-library2","banks","#","#",57,15,0),
(10,"Bank List","icon-list-ordered","banklist","banks.php","banks.php",7,16,0),
(11,"Bank Accounts","icon-clipboard4","bank-accounts","bankaccounts.php","bankaccounts.php",7,17,0),
(12,"Purchases","icon-list-ordered","purchases","#","#",57,-80,0),
(13,"Bills","icon-list-ordered","bills","purchases.php","purchases.php",12,9,0),
(14,"Bill Payments","icon-clipboard4","bill-payments","purchasePayments.php","purchasePayments.php",12,10,0),
(15,"Sales","icon-cart","sales","#","#",57,5,0),
(16,"Sales List","icon-list-ordered","sales-list","sales.php","sales.php",15,6,0),
(17,"Receive Payments","icon-clipboard4","receive-payments","salePayments.php","salePayments.php",15,7,0),
(18,"Transfer Inventories"," icon-stackoverflow","transfer-inventory","transferInventory.php","transferInventory.php",77,12,0),
(19,"Expense","icon-bus","expense","expense.php","expense.php",57,13,0),
(20,"Manual Journal","icon-book","manual-journal","manualJornal.php","manualJornal.php",57,11,0),
(21,"Safes","icon-safe","safes","safes.php","safes.php",57,14,0),
(22,"Currency Rates"," icon-chart","currency-rates","currencyRates.php","currencyRates.php",83,15,0),
(23,"System Options"," icon-gear","systemoptions","systemOptions.php","systemOptions.php",83,16,0),
(24,"Dashboard"," icon-stats-bars2","dashboard","accountingDashboard.php","accountingDashboard.php",NULL,-128,0),
(25,"Add Item {Hidden Menu}","icon-package","add-item","addItemForm.php","addItemForm.php",77,1,1),
(26,"Edit Item {Hidden Menu}","icon-package","edit-item","editItemForm.php","editItemForm.php",77,1,1),
(27,"Trial Balance {Hidden Menu}"," icon-balance","trial-balance","trialBalance.php","trialBalance.php",57,1,1),
(28,"Reports","icon-graph","reports","Reports.php","Reports.php",57,20,0),
(29,"Profit & loss {Hidden Menu}"," icon-coin-dollar","profit-loss","profit&loss.php","profit&loss.php",57,1,1),
(30,"Balance Sheet {Hidden Menu}"," icon-cash","balance-sheet","balanceSheet.php","balanceSheet.php",57,1,1),
(31,"Production"," icon-design","production","#","#",NULL,-80,0),
(32,"Production List","icon-design","production-list","production.php","production.php",31,9,0),
(33,"Sleter List","icon-design","sleter-list","sliter.php","sliter.php",31,10,0),
(34,"Purchase Report {Hidden Menu}"," icon-stats-dots","purchase-report","purchaseReport.php","purchaseReport.php",57,1,1),
(35,"Sales Report {Hidden Menu}"," icon-stats-dots","sale-report","saleReport.php","saleReport.php",57,1,1),
(36,"Starting Inventory","icon-newspaper2","starting-inventory","Startinginventory.php","Startinginventory.php",77,4,0),
(37,"Starting Balance","icon-user-tie","starting-balance","startingBalance.php","startingBalance.php",57,2,1),
(38,"Print Sale {Hidden Menu}","icon-printer","print-sale","printSale.php","printSale.php",57,1,1),
(39,"Extract Account Transactions {Hidden Menu}"," icon-printer","extract-account-transation","extractAccountTrans.php","extractAccountTrans.php",57,1,1),
(40,"Payroll"," icon-wallet","payroll","#","#",NULL,2,0),
(41,"Payroll Fields"," icon-puzzle2","payroll-fields","Fields.php","payroll/Fields.php",40,2,0),
(42,"Payroll Template"," icon-table2","payroll-template","Template.php","payroll/Template.php",40,2,0),
(43,"Generate Salary"," icon-gear","generate-salary","AssignPayroll.php","payroll/AssignPayroll.php",40,2,0),
(44,"Contact Balance","icon-user-tie","contact-balance","contactBalance.php","contactBalance.php",57,2,1),
(45,"Human Resource"," icon-users4","hr","#","#",NULL,5,0),
(46,"HR Admin"," icon-briefcase","hr-admin","#","#",45,5,0),
(47,"HR Users"," icon-users","hr-user","users.php","hr/users.php",46,5,0),
(48,"HR Jobs"," icon-reading","hr-jobs","#","#",46,5,0),
(49,"HR Organization"," icon-city","hr-organization","#","#",46,5,0),
(50,"HR  Nationalities"," icon-earth","nationalities","nationalities.php","hr/nationalities.php",46,5,1),
(51,"HR PIM","icon-typewriter","hr-pim","#","#",45,5,0),
(52,"HR  Employee List"," icon-list","hr-employee-list","emplist.php","hr/emplist.php",51,5,0),
(53,"HR  New Employee"," icon-plus","new-employee","newemp.php","hr/newemp.php",51,5,1),
(54,"Position"," icon-reading","job-title","jobs.php","hr/jobs.php",48,5,0),
(56,"Job Title"," icon-tree7","job-category","jobcatagory.php","hr/jobcatagory.php",48,5,0),
(57,"Accounting","icon-notebook","accounting","#","#",NULL,1,0),
(58,"Employment Status"," icon-notebook","employment-status","employmentstatus.php","hr/employmentstatus.php",48,5,0),
(59,"Orgnazation Info"," icon-city","organization-info","organization.php","hr/organization.php",49,5,0),
(60,"Leave Holiday"," icon-list-numbered","leave-holiday","viewHolidayList.php","hr/viewHolidayList.php",64,5,0),
(61,"HR Leave"," icon-exit3","hr-leave","#","#",45,5,0),
(62,"Leave Types"," icon-list-numbered","leave-types","leaveType.php","hr/leaveType.php",64,5,0),
(63,"Work Weeks"," icon-list-numbered","work-weeks","workWeek.php","hr/workWeek.php",64,5,0),
(64,"Leave Configure"," icon-gear","leave-config","#","#",61,5,0),
(65,"Leave Period"," icon-list-numbered","leave-period","leavePeriod.php","hr/leavePeriod.php",64,5,0),
(66,"Entitlements"," icon-book","entitlements","viewLeaveEntitlements.php","hr/viewLeaveEntitlements.php",61,5,0),
(68,"Assign Leave"," icon-exit","assign-leave","assignLeave.php","hr/assignLeave.php",61,5,0),
(69,"Leave List"," icon-list2","leave-list","viewLeaveList.php","hr/viewLeaveList.php",61,5,0),
(70,"HR User Dashboard"," icon-bubble-notification","hr-user-dashboard","HrUserDashboard.php","hr/HrUserDashboard.php",45,3,0),
(71,"HR Personal Leave List"," icon-bubble-notification","hr-personal-leave-list","HrUserPersonalLeaveList.php","hr/HrUserPersonalLeaveList.php",45,2,0),
(72,"HR Request Leave "," icon-bubble-notification","hr-request-leave","requestLeave.php","hr/requestLeave.php",45,1,0),
(73,"HR EMP Dashboard"," icon-bubble-notification","hr-employee-dashboard","HrEmpDashboard.php","hr/HrEmpDashboard.php",45,0,0),
(74,"Face Recognizer","icon-eye","face-recognizer","faceRecognizer.php","faceRecognizer.php",NULL,1,0),
(75,"HR Recruitment","icon-users4","hr-recruitment","#","#",45,5,0),
(76,"HR Vacancy","icon-users","hr-vacancy","vacancy.php","hr/vacancy.php",75,5,0),
(77,"Inventory","icon-package","inventory","#","#",NULL,1,0),
(78,"HR Candidates","icon-users","hr-candidate","viewCandidates.php","hr/viewCandidates.php",75,5,0),
(79,"Contact Report {Hidden Menu}"," icon-stats-dots","contact-report","contactReport.php","contactReport.php",57,1,1),
(80,"Reporting Tools"," icon-file-stats","reporting-tools","#","#",83,15,0),
(81,"Report Designer"," icon-file-stats","report-designer","reportDesigner.php","reportDesigner.php",80,15,0),
(82,"Report List"," icon-list","report-list","reportList.php","reportList.php",80,15,0),
(83,"System Setting"," icon-gear","core","#","#",NULL,15,0),
(84,"Trash","icon-trash","trashcan","trashcan.php","trashcan.php",57,100,0),
(86,"Attendance"," icon-list-numbered","attendance","#","#",NULL,1,0),
(87,"Shift List"," icon-list-numbered","shift-list","shiftList.php","attendance/shiftList.php",86,22,0),
(88,"Timetable List"," icon-list-numbered","time-sheet-list","timeSheetList.php","attendance/timeSheetList.php",86,23,0),
(89,"Departments","fa fa-sitemap","hr-departments","hrdepartments.php","hr/hrdepartments.php",46,22,0),
(90,"Check IN/Out"," icon-alarm","checkin-out","checkin-out.php","attendance/checkin-out.php",86,23,0),
(91,"Attendance Logs"," icon-book","attendance-logs","attendancelogs.php","attendance/attendancelogs.php",86,23,0),
(92,"Manual Checkin/checkout"," icon-hand","manual-attendance","manualattend.php","attendance/manualattend.php",86,23,0),
(93,"Payslip Recipt"," icon-printer4","payslip","payslip.php","payroll/payslip.php",40,23,1),
(94,"Import From Device"," icon-enter6","import-logs","importlogs.php","attendance/importlogs.php",86,23,0),
(95,"Restaurant"," icon-coffee","restaurant","#","#",NULL,1,0),
(96,"Import From Device (Restaurant)"," icon-enter6","restaurant-import-logs","importlogs.php","restaurant/importlogs.php",95,23,0),
(97,"Definitions"," icon-equalizer","restaurant-definitions","definitions.php","restaurant/definitions.php",95,23,0),
(98,"Orgnazation Structure","fa fa-sitemap","organization-structure","definitions.php","hr/definitions.php",49,5,0),
(99,"Meals","fa fa-cutlery","meals","meals.php","restaurant/meals.php",95,24,0),
(100,"Restaurant Programs","fa fa-cutlery","restaurant-programs","restaurant_programs.php","restaurant/restaurant_programs.php",95,25,0),
(101,"Employee Crediting","fa fa-cutlery","employee-crediting","employee_crediting.php","restaurant/employee_crediting.php",95,26,0),
(102,"Restaurant Transactions","fa fa-cutlery","restaurant-transactions","restaurant_transactions.php","restaurant/restaurant_transactions.php",95,27,0),
(103,"Clinic","fa fa-hospital-o","clinic","#","#",NULL,1,0),
(104,"Visit List","icon-list","visit-list-clinic","clinic_visit_list.php","clinic/clinic_visit_list.php",103,1,0),
(105,"Restaurant Reports","icon-graph","restaurant-reports","Reports.php","restaurant/Reports.php",95,28,0),
(106,"Report Restaurant Transactions (Hidden Menu)","icon-graph","restaurant-transaction-reports","report_restaurant_transactions.php","restaurant/report_restaurant_transactions.php",95,29,1),
(107,"Project Management","fa fa-tasks","project","#","#",NULL,10,0),
(108,"Definitions"," icon-equalizer","project-definitions","definitions.php","project/definitions.php",107,6,0),
(109,"Projects"," fa fa-tasks","projects","projects.php","project/projects.php",107,1,0),
(110,"Extract Transactions Types {Hidden Menu}","icon-printer","extract-transaction-types","extractTransTypes.php","extractTransTypes.php",57,1,1),
(111,"Track Item Report {Hidden Menu}","icon-printer","item-transaction-report","itemtransactionReport.php","itemtransactionReport.php",57,1,1),
(112,"Inventory Adjustments"," icon-design","inventory-adjustment","inventroyAdjustments.php","inventroyAdjustments.php",77,5,0),
(119,"Advanced Payments","icon-clipboard4","advanced-payment","advancedPayments.php","advancedPayments.php",2,7,1),
(120,"Responsibilities","fa fa-tasks","hr-job-responsibilities","hr_job_responsibilities.php","hr/hr_job_responsibilities.php",48,0,0),
(121,"Logistics","fa fa-car","logistic","#","#",NULL,5,0),
(122,"Purchase Requests","fa fa-list-alt","purchase-requests","purchases.php?type=1","logistic/purchases.php?type=1",121,1,0),
(124,"Purchase Orders","fa fa-list-alt","purchase-orders","purchases.php?type=2","logistic/purchases.php?type=2",121,2,0),
(125,"Transportation Plan","fa fa-list-alt","transportation-plans","transportations.php?type=1","logistics/transportations.php?type=1",129,3,0),
(126,"Transportation Report","fa fa-list-alt","transportation-report","transportations.php?type=2","logistics/transportations.php?type=2",129,4,0),
(128,"Payment Vouchers","fa fa-file","payment-vouchers","payment_vouchers.php","project/payment_vouchers.php",107,7,0),
(129,"Transportation","fa fa-car","transportation","#","#",NULL,5,0),
(130,"Work Flow","fa fa-recycle","hr-workflows","hr_job_workflows.php","hr/hr_job_workflows.php",48,4,0),
(131,"Expense Payments (Hidden Menu)","icon-graph","expense-payments","expensePayments.php","expensePayments.php",15,5,1),
(132,"Employee Scheduling","icon-list-numbered","employee-shift-list","employeeShiftList.php","attendance/employeeShiftList.php",86,30,0),
(133,"Payment Receipts","fa fa-file","payment-receipts","payment_receipts.php","project/payment_receipts.php",107,8,0),
(134,"Check IN/OUT List","icon-book","inout-log-list","inoutloglist.php","attendance/inoutloglist.php",86,24,0),
(135,"Project Reports","icon-graph","project-reports","project-reports.php","project/Reports.php",107,20,0),
(1,"Items","icon-cube4","items","itemList.php","itemList.php",77,1,0),
(2,"Contacts","icon-user-tie","contacts","contacts.php","contacts.php",57,2,0),
(3,"Accounts","icon-lan2","accounts","accounts.php","accounts.php",57,3,0),
(6,"Inventories","icon-home2","inventories","inventories.php","inventories.php",77,4,0),
(7,"Banks","icon-library2","banks","#","#",57,15,0),
(10,"Bank List","icon-list-ordered","banklist","banks.php","banks.php",7,16,0),
(11,"Bank Accounts","icon-clipboard4","bank-accounts","bankaccounts.php","bankaccounts.php",7,17,0),
(12,"Purchases","icon-list-ordered","purchases","#","#",57,-80,0),
(13,"Bills","icon-list-ordered","bills","purchases.php","purchases.php",12,9,0),
(14,"Bill Payments","icon-clipboard4","bill-payments","purchasePayments.php","purchasePayments.php",12,10,0),
(15,"Sales","icon-cart","sales","#","#",57,5,0),
(16,"Sales List","icon-list-ordered","sales-list","sales.php","sales.php",15,6,0),
(17,"Receive Payments","icon-clipboard4","receive-payments","salePayments.php","salePayments.php",15,7,0),
(18,"Transfer Inventories"," icon-stackoverflow","transfer-inventory","transferInventory.php","transferInventory.php",77,12,0),
(19,"Expense","icon-bus","expense","expense.php","expense.php",57,13,0),
(20,"Manual Journal","icon-book","manual-journal","manualJornal.php","manualJornal.php",57,11,0),
(21,"Safes","icon-safe","safes","safes.php","safes.php",57,14,0),
(22,"Currency Rates"," icon-chart","currency-rates","currencyRates.php","currencyRates.php",83,15,0),
(23,"System Options"," icon-gear","systemoptions","systemOptions.php","systemOptions.php",83,16,0),
(24,"Dashboard"," icon-stats-bars2","dashboard","accountingDashboard.php","accountingDashboard.php",NULL,-128,0),
(25,"Add Item {Hidden Menu}","icon-package","add-item","addItemForm.php","addItemForm.php",77,1,1),
(26,"Edit Item {Hidden Menu}","icon-package","edit-item","editItemForm.php","editItemForm.php",77,1,1),
(27,"Trial Balance {Hidden Menu}"," icon-balance","trial-balance","trialBalance.php","trialBalance.php",57,1,1),
(28,"Reports","icon-graph","reports","Reports.php","Reports.php",57,20,0),
(29,"Profit & loss {Hidden Menu}"," icon-coin-dollar","profit-loss","profit&loss.php","profit&loss.php",57,1,1),
(30,"Balance Sheet {Hidden Menu}"," icon-cash","balance-sheet","balanceSheet.php","balanceSheet.php",57,1,1),
(31,"Production"," icon-design","production","#","#",NULL,-80,0),
(32,"Production List","icon-design","production-list","production.php","production.php",31,9,0),
(33,"Sleter List","icon-design","sleter-list","sliter.php","sliter.php",31,10,0),
(34,"Purchase Report {Hidden Menu}"," icon-stats-dots","purchase-report","purchaseReport.php","purchaseReport.php",57,1,1),
(35,"Sales Report {Hidden Menu}"," icon-stats-dots","sale-report","saleReport.php","saleReport.php",57,1,1),
(36,"Starting Inventory","icon-newspaper2","starting-inventory","Startinginventory.php","Startinginventory.php",77,4,0),
(37,"Starting Balance","icon-user-tie","starting-balance","startingBalance.php","startingBalance.php",57,2,1),
(38,"Print Sale {Hidden Menu}","icon-printer","print-sale","printSale.php","printSale.php",57,1,1),
(39,"Extract Account Transactions {Hidden Menu}"," icon-printer","extract-account-transation","extractAccountTrans.php","extractAccountTrans.php",57,1,1),
(40,"Payroll"," icon-wallet","payroll","#","#",NULL,2,0),
(41,"Payroll Fields"," icon-puzzle2","payroll-fields","Fields.php","payroll/Fields.php",40,2,0),
(42,"Payroll Template"," icon-table2","payroll-template","Template.php","payroll/Template.php",40,2,0),
(43,"Generate Salary"," icon-gear","generate-salary","AssignPayroll.php","payroll/AssignPayroll.php",40,2,0),
(44,"Contact Balance","icon-user-tie","contact-balance","contactBalance.php","contactBalance.php",57,2,1),
(45,"Human Resource"," icon-users4","hr","#","#",NULL,5,0),
(46,"HR Admin"," icon-briefcase","hr-admin","#","#",45,5,0),
(47,"HR Users"," icon-users","hr-user","users.php","hr/users.php",46,5,0),
(48,"HR Jobs"," icon-reading","hr-jobs","#","#",46,5,0),
(49,"HR Organization"," icon-city","hr-organization","#","#",46,5,0),
(50,"HR  Nationalities"," icon-earth","nationalities","nationalities.php","hr/nationalities.php",46,5,1),
(51,"HR PIM","icon-typewriter","hr-pim","#","#",45,5,0),
(52,"HR  Employee List"," icon-list","hr-employee-list","emplist.php","hr/emplist.php",51,5,0),
(53,"HR  New Employee"," icon-plus","new-employee","newemp.php","hr/newemp.php",51,5,1),
(54,"Position"," icon-reading","job-title","jobs.php","hr/jobs.php",48,5,0),
(56,"Job Title"," icon-tree7","job-category","jobcatagory.php","hr/jobcatagory.php",48,5,0),
(57,"Accounting","icon-notebook","accounting","#","#",NULL,1,0),
(58,"Employment Status"," icon-notebook","employment-status","employmentstatus.php","hr/employmentstatus.php",48,5,0),
(59,"Orgnazation Info"," icon-city","organization-info","organization.php","hr/organization.php",49,5,0),
(60,"Leave Holiday"," icon-list-numbered","leave-holiday","viewHolidayList.php","hr/viewHolidayList.php",64,5,0),
(61,"HR Leave"," icon-exit3","hr-leave","#","#",45,5,0),
(62,"Leave Types"," icon-list-numbered","leave-types","leaveType.php","hr/leaveType.php",64,5,0),
(63,"Work Weeks"," icon-list-numbered","work-weeks","workWeek.php","hr/workWeek.php",64,5,0),
(64,"Leave Configure"," icon-gear","leave-config","#","#",61,5,0),
(65,"Leave Period"," icon-list-numbered","leave-period","leavePeriod.php","hr/leavePeriod.php",64,5,0),
(66,"Entitlements"," icon-book","entitlements","viewLeaveEntitlements.php","hr/viewLeaveEntitlements.php",61,5,0),
(68,"Assign Leave"," icon-exit","assign-leave","assignLeave.php","hr/assignLeave.php",61,5,0),
(69,"Leave List"," icon-list2","leave-list","viewLeaveList.php","hr/viewLeaveList.php",61,5,0),
(70,"HR User Dashboard"," icon-bubble-notification","hr-user-dashboard","HrUserDashboard.php","hr/HrUserDashboard.php",45,3,0),
(71,"HR Personal Leave List"," icon-bubble-notification","hr-personal-leave-list","HrUserPersonalLeaveList.php","hr/HrUserPersonalLeaveList.php",45,2,0),
(72,"HR Request Leave "," icon-bubble-notification","hr-request-leave","requestLeave.php","hr/requestLeave.php",45,1,0),
(73,"HR EMP Dashboard"," icon-bubble-notification","hr-employee-dashboard","HrEmpDashboard.php","hr/HrEmpDashboard.php",45,0,0),
(74,"Face Recognizer","icon-eye","face-recognizer","faceRecognizer.php","faceRecognizer.php",NULL,1,0),
(75,"HR Recruitment","icon-users4","hr-recruitment","#","#",45,5,0),
(76,"HR Vacancy","icon-users","hr-vacancy","vacancy.php","hr/vacancy.php",75,5,0),
(77,"Inventory","icon-package","inventory","#","#",NULL,1,0),
(78,"HR Candidates","icon-users","hr-candidate","viewCandidates.php","hr/viewCandidates.php",75,5,0),
(79,"Contact Report {Hidden Menu}"," icon-stats-dots","contact-report","contactReport.php","contactReport.php",57,1,1),
(80,"Reporting Tools"," icon-file-stats","reporting-tools","#","#",83,15,0),
(81,"Report Designer"," icon-file-stats","report-designer","reportDesigner.php","reportDesigner.php",80,15,0),
(82,"Report List"," icon-list","report-list","reportList.php","reportList.php",80,15,0),
(83,"System Setting"," icon-gear","core","#","#",NULL,15,0),
(84,"Trash","icon-trash","trashcan","trashcan.php","trashcan.php",57,100,0),
(86,"Attendance"," icon-list-numbered","attendance","#","#",NULL,1,0),
(87,"Shift List"," icon-list-numbered","shift-list","shiftList.php","attendance/shiftList.php",86,22,0),
(88,"Timetable List"," icon-list-numbered","time-sheet-list","timeSheetList.php","attendance/timeSheetList.php",86,23,0),
(89,"Departments","fa fa-sitemap","hr-departments","hrdepartments.php","hr/hrdepartments.php",46,22,0),
(90,"Check IN/Out"," icon-alarm","checkin-out","checkin-out.php","attendance/checkin-out.php",86,23,0),
(91,"Attendance Logs"," icon-book","attendance-logs","attendancelogs.php","attendance/attendancelogs.php",86,23,0),
(92,"Manual Checkin/checkout"," icon-hand","manual-attendance","manualattend.php","attendance/manualattend.php",86,23,0),
(93,"Payslip Recipt"," icon-printer4","payslip","payslip.php","payroll/payslip.php",40,23,1),
(94,"Import From Device"," icon-enter6","import-logs","importlogs.php","attendance/importlogs.php",86,23,0),
(95,"Restaurant"," icon-coffee","restaurant","#","#",NULL,1,0),
(96,"Import From Device (Restaurant)"," icon-enter6","restaurant-import-logs","importlogs.php","restaurant/importlogs.php",95,23,0),
(97,"Definitions"," icon-equalizer","restaurant-definitions","definitions.php","restaurant/definitions.php",95,23,0),
(98,"Orgnazation Structure","fa fa-sitemap","organization-structure","definitions.php","hr/definitions.php",49,5,0),
(99,"Meals","fa fa-cutlery","meals","meals.php","restaurant/meals.php",95,24,0),
(100,"Restaurant Programs","fa fa-cutlery","restaurant-programs","restaurant_programs.php","restaurant/restaurant_programs.php",95,25,0),
(101,"Employee Crediting","fa fa-cutlery","employee-crediting","employee_crediting.php","restaurant/employee_crediting.php",95,26,0),
(102,"Restaurant Transactions","fa fa-cutlery","restaurant-transactions","restaurant_transactions.php","restaurant/restaurant_transactions.php",95,27,0),
(103,"Clinic","fa fa-hospital-o","clinic","#","#",NULL,1,0),
(104,"Visit List","icon-list","visit-list-clinic","clinic_visit_list.php","clinic/clinic_visit_list.php",103,1,0),
(105,"Restaurant Reports","icon-graph","restaurant-reports","Reports.php","restaurant/Reports.php",95,28,0),
(106,"Report Restaurant Transactions (Hidden Menu)","icon-graph","restaurant-transaction-reports","report_restaurant_transactions.php","restaurant/report_restaurant_transactions.php",95,29,1),
(107,"Project Management","fa fa-tasks","project","#","#",NULL,10,0),
(108,"Definitions"," icon-equalizer","project-definitions","definitions.php","project/definitions.php",107,6,0),
(109,"Projects"," fa fa-tasks","projects","projects.php","project/projects.php",107,1,0),
(110,"Extract Transactions Types {Hidden Menu}","icon-printer","extract-transaction-types","extractTransTypes.php","extractTransTypes.php",57,1,1),
(111,"Track Item Report {Hidden Menu}","icon-printer","item-transaction-report","itemtransactionReport.php","itemtransactionReport.php",57,1,1),
(112,"Inventory Adjustments"," icon-design","inventory-adjustment","inventroyAdjustments.php","inventroyAdjustments.php",77,5,0),
(119,"Advanced Payments","icon-clipboard4","advanced-payment","advancedPayments.php","advancedPayments.php",2,7,1),
(120,"Responsibilities","fa fa-tasks","hr-job-responsibilities","hr_job_responsibilities.php","hr/hr_job_responsibilities.php",48,0,0),
(121,"Logistics","fa fa-car","logistic","#","#",NULL,5,0),
(122,"Purchase Requests","fa fa-list-alt","purchase-requests","purchases.php?type=1","logistic/purchases.php?type=1",121,1,0),
(124,"Purchase Orders","fa fa-list-alt","purchase-orders","purchases.php?type=2","logistic/purchases.php?type=2",121,2,0),
(125,"Transportation Plan","fa fa-list-alt","transportation-plans","transportations.php?type=1","logistics/transportations.php?type=1",129,3,0),
(126,"Transportation Report","fa fa-list-alt","transportation-report","transportations.php?type=2","logistics/transportations.php?type=2",129,4,0),
(128,"Payment Vouchers","fa fa-file","payment-vouchers","payment_vouchers.php","project/payment_vouchers.php",107,7,0),
(129,"Transportation","fa fa-car","transportation","#","#",NULL,5,0),
(130,"Work Flow","fa fa-recycle","hr-workflows","hr_job_workflows.php","hr/hr_job_workflows.php",48,4,0),
(131,"Expense Payments (Hidden Menu)","icon-graph","expense-payments","expensePayments.php","expensePayments.php",15,5,1),
(132,"Employee Scheduling","icon-list-numbered","employee-shift-list","employeeShiftList.php","attendance/employeeShiftList.php",86,30,0),
(133,"Payment Receipts","fa fa-file","payment-receipts","payment_receipts.php","project/payment_receipts.php",107,8,0),
(134,"Check IN/OUT List","icon-book","inout-log-list","inoutloglist.php","attendance/inoutloglist.php",86,24,0),
(135,"Project Reports","icon-graph","project-reports","project-reports.php","project/Reports.php",107,20,0);


DROP TABLE modalreports;

CREATE TABLE `modalreports` (
  `relationId` bigint(20) NOT NULL AUTO_INCREMENT,
  `modalKey` varchar(100) DEFAULT NULL,
  `reportId` bigint(20) DEFAULT NULL,
  `Deleted` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`relationId`),
  KEY `FK_modalreports_reports` (`reportId`),
  CONSTRAINT `FK_modalreports_reports` FOREIGN KEY (`reportId`) REFERENCES `reports` (`reportId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

INSERT INTO modalreports VALUES
(1,"editSale",5,0),
(2,"editSale",6,0);


DROP TABLE nationalities;

CREATE TABLE `nationalities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `code` varchar(32) NOT NULL,
  `created` int(11) DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `modified` int(11) DEFAULT NULL,
  `modified_by` bigint(20) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

INSERT INTO nationalities VALUES
(1,"Iraqi","IRAQI",NULL,NULL,NULL,NULL,0),
(2,"Kurdish","KURD",NULL,NULL,NULL,NULL,0),
(3,"Arab","ARAB",NULL,NULL,NULL,NULL,0),
(4,"Turkish","TURK",NULL,NULL,NULL,NULL,0),
(5,"Iranian","IRAN",NULL,NULL,NULL,NULL,0);


DROP TABLE options;

CREATE TABLE `options` (
  `OptionId` int(11) NOT NULL AUTO_INCREMENT,
  `OptionKey` varchar(45) DEFAULT NULL,
  `OptionValue` varchar(300) DEFAULT NULL,
  `OptionGroup` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`OptionId`),
  UNIQUE KEY `OptionKey_UNIQUE` (`OptionKey`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='this will controll the options of the system';

INSERT INTO options VALUES
(1,"BASE","https://kiton-iraq.com/Gigant/",NULL),
(2,"BASECURRENCYID",2,NULL),
(3,"VIEW_CURRENCY",2,"accounting"),
(5,"INVOICEHEADER","<p style=\'text-align: center;\'>Payslip Header</p>",NULL),
(6,"INVOICEFOOTER","<p style=\'text-align: center;\'>Payslip Footer</p>",NULL),
(7,"SHOWREPORTS","YES",NULL),
(17,"if_no_check_in",1,"attendance"),
(18,"no_check_in_late",30,"attendance"),
(19,"if_no_check_out",1,"attendance"),
(20,"no_check_out_early",30,"attendance"),
(21,"late_arrive_limit",70,"attendance"),
(22,"early_leave_limit",93,"attendance"),
(23,"overtime_limit_before_cin",240,"attendance"),
(24,"overtime_limit_after_cout",420,"attendance"),
(25,"early_before_from_time",5,"attendance"),
(26,"late_after_to_time",5,"attendance"),
(27,"check_in_color","#00f900","attendance"),
(28,"no_check_in_color","#006633","attendance"),
(29,"check_out_color","#ff6666","attendance"),
(30,"no_check_out_color","#990000","attendance"),
(31,"working_day_minutes",480,"attendance"),
(32,"ACCOUNT_PAYABLE_ID",1,"accounting"),
(33,"ACCOUNT_RECEIVABLE_ID",2,"accounting"),
(34,"ACCOUNT_SALE_DISCOUNT_ID",96,"accounting"),
(35,"MAIN_SAFE_ID",10,"accounting"),
(36,"ITEM_INCOME_ACCOUNT_ID",123,"inventory"),
(37,"ITEM_EXPENSE_ACCOUNT_ID",61,"inventory"),
(38,"ITEM_DEPRESSIATION_ACCOUNT_ID",53,"inventory"),
(53,"ORG_LOGO","public/logos/arzheen/arzheen-logo-sm.jpg","core"),
(54,"ORG_LOGO_BLACK","public/logos/arzheen/arzheen-logo-sm-bw.png","core"),
(55,"ORG_NAME","Kiton clothes","core"),
(56,"ORG_NAME_KU","کیتۆن","core"),
(57,"ORG_EMAILS","info@kiton-iraq.com","core"),
(58,"ORG_WEBSITE","www.kiton-iraq.com","core"),
(59,"ORG_ADDRESS","Iraq, Erbil, inside Gulan tower","core"),
(60,"ORG_ADDRESS_KU","عێڕاق، هەولێر، ناو گوڵان تاوەر","core"),
(61,"ORG_PHONE","+964 (0) 750 521 0007","core"),
(62,"ORG_PHONE1","+964 (0) 750 521 0007","core"),
(63,"ORG_PHONE2","+964 (0) 750 521 0007","core"),
(64,"DASHBOARD_TOTAL_SALES",138981.25,NULL),
(65,"DASHBOARD_SALE_ORDERS",23,NULL),
(66,"DASHBOARD_TOTAL_PURCHASES",2396,NULL),
(67,"DASHBOARD_PURCHASE_ORDERS",11,NULL),
(68,"DASHBOARD_TOTAL_COLLECTIONS",32918,NULL),
(69,"DASHBOARD_COLLECTION_ORDERS",5,NULL),
(70,"DASHBOARD_TOTAL_PAYMENTS",NULL,NULL),
(71,"DASHBOARD_PAYMENT_ORDERS",0,NULL),
(72,"DASHBOARD_TOTAL_RETURNS",-51275,NULL),
(73,"DASHBOARD_RETURN_ORDERS",8,NULL),
(74,"DASHBOARD_TOTAL_EXPENSES",NULL,NULL),
(75,"DASHBOARD_EXPENSE_ORDERS",0,NULL),
(76,"DASHBOARD_COGS",87,NULL),
(77,"DASHBOARD_DEBT",106063.25,NULL),
(78,"DASHBOARD_INVENTORY_VALUE",2336,NULL);


DROP TABLE organization;

CREATE TABLE `organization` (
  `orgId` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `taxId` int(11) NOT NULL,
  `registrationNo` varchar(20) NOT NULL,
  `phone` int(11) NOT NULL,
  `fax` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `address1` varchar(50) NOT NULL,
  `address2` varchar(50) NOT NULL,
  `city` varchar(30) NOT NULL,
  `state` varchar(10) NOT NULL,
  `zip` varchar(20) NOT NULL,
  `country` int(11) NOT NULL,
  `note` mediumtext NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`orgId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO organization VALUES
(1,"Arzheen Hospital",0,"2020-07-18
",0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0);


DROP TABLE payroll_fields;

CREATE TABLE `payroll_fields` (
  `Name` varchar(200) DEFAULT NULL,
  `type` varchar(3) DEFAULT 'fix',
  `description` varchar(500) DEFAULT NULL,
  `increase` int(1) DEFAULT 1 COMMENT 'its category\n1=>earnings\n0=>deduction',
  `fieldId` int(11) NOT NULL AUTO_INCREMENT,
  `Deleted` int(1) DEFAULT 0,
  PRIMARY KEY (`fieldId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

INSERT INTO payroll_fields VALUES
("Food Allowance","fix",NULL,1,1,0),
("Retirement","cal",NULL,0,2,0),
("Certificate","fix",NULL,1,3,0);


DROP TABLE payroll_salary_template;

CREATE TABLE `payroll_salary_template` (
  `templateId` int(11) NOT NULL AUTO_INCREMENT,
  `salaryAmount` decimal(8,3) DEFAULT NULL,
  `salaryAmountFrom` varchar(3) DEFAULT 'sys' COMMENT 'sys=> means system\ncus => custome\n',
  `paymentFrequency` int(1) DEFAULT 1 COMMENT '-1=>unseted\n1=>weekly\n2=>Bi weekly\n3=>semi monthly\n4=>monthly\n5=>monthly on first pay of month\n6=>Hourly',
  `paymentFrequencyFrom` varchar(3) DEFAULT 'sys' COMMENT 'sys=> means system\ncus => custome\n',
  `Name` varchar(100) DEFAULT 'Unkonwn Template',
  `description` varchar(400) DEFAULT NULL,
  `Deleted` int(1) DEFAULT 0,
  PRIMARY KEY (`templateId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO payroll_salary_template VALUES
(1,0,"sys",-1,"sys","Accountant",NULL,0);


DROP TABLE payroll_template_field;

CREATE TABLE `payroll_template_field` (
  `templateFieldId` int(11) NOT NULL AUTO_INCREMENT,
  `amount` varchar(200) DEFAULT '0.000',
  `templateId` int(11) DEFAULT NULL,
  `fieldId` int(11) DEFAULT NULL,
  PRIMARY KEY (`templateFieldId`),
  KEY `templateID_idx` (`templateId`),
  KEY `FiledId_idx` (`fieldId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

INSERT INTO payroll_template_field VALUES
(1,1000,1,1),
(2,"S * 0.07",1,2);


DROP TABLE permessions;

CREATE TABLE `permessions` (
  `permessionId` int(11) NOT NULL AUTO_INCREMENT,
  `permessionTitle` varchar(60) DEFAULT NULL,
  `canDelete` mediumtext NOT NULL,
  `canModals` mediumtext NOT NULL,
  PRIMARY KEY (`permessionId`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

INSERT INTO permessions VALUES
(9,"Top Admin","{\"receive-payments\":1,\"bill-payments\":1,\"expense-payments\":1,\"hr-job-responsibilities\":1,\"payment-vouchers\":1,\"attendance-logs\":1,\"employee-shift-list\":1,\"hr-employee-list\":1,\"ngo-assets\":1,\"purchase-requests\":1,\"purchase-orders\":1}","{\"categoryForm\":1,\"viewItem\":1,\"manufactureForm\":1,\"countryForm\":1,\"unitForm\":1,\"unitTypeForm\":1,\"viewField\":1,\"newField\":1,\"newTemplate\":1,\"editTemplate\":1,\"assignPayroll\":1,\"viewSalary\":1,\"newContact\":1,\"cityForm\":1,\"townForm\":1,\"editContact\":1,\"newAccount\":1,\"editAccount\":1,\"newInventory\":1,\"editInventory\":1,\"inventoryItems\":1,\"inventoryExpireItems\":1,\"newBank\":1,\"editBank\":1,\"newSafe\":1,\"editSafe\":1,\"newBankAccount\":1,\"editBankAccount\":1,\"newPurchase\":1,\"editPurchase\":1,\"makePayment\":1,\"editMakePayment\":1,\"newSale\":1,\"editSale\":1,\"recivePayment\":1,\"editRecivePayment\":1,\"newJornalEntry\":1,\"editJornalEntry\":1,\"newInventoryTransfer\":1,\"editInventoryTransfer\":1,\"newExpense\":1,\"editExpense\":1,\"newCurrencyRate\":1,\"editCurrencyRate\":1,\"newPermession\":1,\"editPermession\":1,\"newUser\":1,\"editUser\":1,\"newProduction\":1,\"editProduction\":1,\"newSliter\":1,\"editSliter\":1,\"inventoryAnalysis\":1,\"StartingInventory.php\":1,\"newStartingInventory\":1,\"editStartingInventory\":1,\"newStartingBalance\":1,\"newBalance\":1,\"emergencyContact\":1,\"salaryComponent\":1,\"dependents\":1,\"immigration\":1,\"reportSupervisor\":1,\"reportSubordinates\":1,\"qualificationsWork\":1,\"qualificationsEducation\":1,\"qualificationsSkill\":1,\"qualificationsLanguage\":1,\"qualificationsLicense\":1,\"membership\":1,\"newLeaveType\":1,\"holiday\":1,\"EmployeeEntitlement\":1,\"MultipleEntitlement\":1,\"newVacancy\":1,\"newCandidate\":1,\"generateAttendanceLogs\":1,\"in/outlogs\":1,\"newLocation\":1,\"editLocation\":1,\"newCompany\":1,\"editCompany\":1,\"newDepartment\":1,\"editDepartment\":1,\"newSection\":1,\"editSection\":1,\"newhrdepartment\":1,\"newMeal\":1,\"editMeal\":1,\"newShift\":1,\"newProgram\":1,\"editProgram\":1,\"newCrediting\":1,\"editCrediting\":1,\"newClinicVisit\":1,\"editClinicVisit\":1,\"newProjectDonor\":1,\"editProjectDonor\":1,\"newProject\":1,\"editProject\":1,\"newEmployeeProject\":1,\"editEmployeeProject\":1,\"newInventoryAdjustment\":1,\"editInventoryAdjustment\":1,\"newContactBalance\":1,\"viewContactBalance\":1,\"editAdvancedPayment\":1,\"applyPaymentToSale\":1,\"applyPaymentToPurchase\":1,\"newHrJobResponsibility\":1,\"newProjectPaymentVoucher\":1,\"editProjectPaymentVoucher\":1,\"newLogisticsPurchaseRequest\":1,\"newLogisticsPurchaseOrder\":1,\"newLogisticTransportation\":\"1\",\"editLogisticTransportation\":\"1\",\"newTimeSheet\":\"1\",\"newProjectPaymentReceipt\":\"1\",\"newEmployeeShift\":\"1\",\"editEmployeeShift\":\"1\",\"newEmployeeAsset\":1,\"expensePayment\":1,\"assignleave\":1,\"editLogisticPurchase\":1,\"newRoom\":1,\"newInOutLog\":1,\"editInOutLog\":1,\"newEmployeeContract\":1,\"newNgoAsset\":1,\"trackLogisticRequest\":1,\"terminateEmployee\":1,\"reemploymentEmployee\":1}"),
(21,"Finance Manager","{\"receive-payments\":1,\"bill-payments\":1,\"expense-payments\":1,\"hr-job-responsibilities\":1,\"payment-vouchers\":1,\"attendance-logs\":1,\"employee-shift-list\":1,\"hr-employee-list\":1,\"ngo-assets\":1,\"purchase-requests\":1,\"purchase-orders\":1}","{\"categoryForm\":1,\"viewItem\":1,\"manufactureForm\":1,\"countryForm\":1,\"unitForm\":1,\"unitTypeForm\":1,\"viewField\":1,\"newField\":1,\"newTemplate\":1,\"editTemplate\":1,\"assignPayroll\":1,\"viewSalary\":1,\"newContact\":1,\"cityForm\":1,\"townForm\":1,\"editContact\":1,\"newAccount\":1,\"editAccount\":1,\"newInventory\":1,\"editInventory\":1,\"inventoryItems\":1,\"inventoryExpireItems\":1,\"newBank\":1,\"editBank\":1,\"newSafe\":1,\"editSafe\":1,\"newBankAccount\":1,\"editBankAccount\":1,\"newPurchase\":1,\"editPurchase\":1,\"makePayment\":1,\"editMakePayment\":1,\"newSale\":1,\"editSale\":1,\"recivePayment\":1,\"editRecivePayment\":1,\"newJornalEntry\":1,\"editJornalEntry\":1,\"newInventoryTransfer\":1,\"editInventoryTransfer\":1,\"newExpense\":1,\"editExpense\":1,\"newCurrencyRate\":1,\"editCurrencyRate\":1,\"newPermession\":1,\"editPermession\":1,\"newUser\":1,\"editUser\":1,\"newProduction\":1,\"editProduction\":1,\"newSliter\":1,\"editSliter\":1,\"inventoryAnalysis\":1,\"StartingInventory.php\":1,\"newStartingInventory\":1,\"editStartingInventory\":1,\"newStartingBalance\":1,\"newBalance\":1,\"emergencyContact\":1,\"salaryComponent\":1,\"dependents\":1,\"immigration\":1,\"reportSupervisor\":1,\"reportSubordinates\":1,\"qualificationsWork\":1,\"qualificationsEducation\":1,\"qualificationsSkill\":1,\"qualificationsLanguage\":1,\"qualificationsLicense\":1,\"membership\":1,\"newLeaveType\":1,\"holiday\":1,\"EmployeeEntitlement\":1,\"MultipleEntitlement\":1,\"newVacancy\":1,\"newCandidate\":1,\"generateAttendanceLogs\":1,\"in/outlogs\":1,\"newLocation\":1,\"editLocation\":1,\"newCompany\":1,\"editCompany\":1,\"newDepartment\":1,\"editDepartment\":1,\"newSection\":1,\"editSection\":1,\"newhrdepartment\":1,\"newMeal\":1,\"editMeal\":1,\"newShift\":1,\"newProgram\":1,\"editProgram\":1,\"newCrediting\":1,\"editCrediting\":1,\"newClinicVisit\":1,\"editClinicVisit\":1,\"newProjectDonor\":1,\"editProjectDonor\":1,\"newProject\":1,\"editProject\":1,\"newEmployeeProject\":1,\"editEmployeeProject\":1,\"newInventoryAdjustment\":1,\"editInventoryAdjustment\":1,\"newContactBalance\":1,\"viewContactBalance\":1,\"editAdvancedPayment\":1,\"applyPaymentToSale\":1,\"applyPaymentToPurchase\":1,\"newHrJobResponsibility\":1,\"newProjectPaymentVoucher\":1,\"editProjectPaymentVoucher\":1,\"newLogisticsPurchaseRequest\":1,\"newLogisticsPurchaseOrder\":1,\"newLogisticTransportation\":\"1\",\"editLogisticTransportation\":\"1\",\"newTimeSheet\":\"1\",\"newProjectPaymentReceipt\":\"1\",\"newEmployeeShift\":\"1\",\"editEmployeeShift\":\"1\",\"newEmployeeAsset\":1,\"expensePayment\":1,\"assignleave\":1,\"editLogisticPurchase\":1,\"newRoom\":1,\"newInOutLog\":1,\"editInOutLog\":1,\"newEmployeeContract\":1,\"newNgoAsset\":1,\"trackLogisticRequest\":1,\"terminateEmployee\":1,\"reemploymentEmployee\":1}"),
(22,"Transportation Manager","{\"receive-payments\":1,\"bill-payments\":1,\"expense-payments\":1,\"hr-job-responsibilities\":1,\"payment-vouchers\":1,\"attendance-logs\":1,\"employee-shift-list\":1,\"hr-employee-list\":1,\"ngo-assets\":1,\"purchase-requests\":1,\"purchase-orders\":1}","{\"categoryForm\":1,\"viewItem\":1,\"manufactureForm\":1,\"countryForm\":1,\"unitForm\":1,\"unitTypeForm\":1,\"viewField\":1,\"newField\":1,\"newTemplate\":1,\"editTemplate\":1,\"assignPayroll\":1,\"viewSalary\":1,\"newContact\":1,\"cityForm\":1,\"townForm\":1,\"editContact\":1,\"newAccount\":1,\"editAccount\":1,\"newInventory\":1,\"editInventory\":1,\"inventoryItems\":1,\"inventoryExpireItems\":1,\"newBank\":1,\"editBank\":1,\"newSafe\":1,\"editSafe\":1,\"newBankAccount\":1,\"editBankAccount\":1,\"newPurchase\":1,\"editPurchase\":1,\"makePayment\":1,\"editMakePayment\":1,\"newSale\":1,\"editSale\":1,\"recivePayment\":1,\"editRecivePayment\":1,\"newJornalEntry\":1,\"editJornalEntry\":1,\"newInventoryTransfer\":1,\"editInventoryTransfer\":1,\"newExpense\":1,\"editExpense\":1,\"newCurrencyRate\":1,\"editCurrencyRate\":1,\"newPermession\":1,\"editPermession\":1,\"newUser\":1,\"editUser\":1,\"newProduction\":1,\"editProduction\":1,\"newSliter\":1,\"editSliter\":1,\"inventoryAnalysis\":1,\"StartingInventory.php\":1,\"newStartingInventory\":1,\"editStartingInventory\":1,\"newStartingBalance\":1,\"newBalance\":1,\"emergencyContact\":1,\"salaryComponent\":1,\"dependents\":1,\"immigration\":1,\"reportSupervisor\":1,\"reportSubordinates\":1,\"qualificationsWork\":1,\"qualificationsEducation\":1,\"qualificationsSkill\":1,\"qualificationsLanguage\":1,\"qualificationsLicense\":1,\"membership\":1,\"newLeaveType\":1,\"holiday\":1,\"EmployeeEntitlement\":1,\"MultipleEntitlement\":1,\"newVacancy\":1,\"newCandidate\":1,\"generateAttendanceLogs\":1,\"in/outlogs\":1,\"newLocation\":1,\"editLocation\":1,\"newCompany\":1,\"editCompany\":1,\"newDepartment\":1,\"editDepartment\":1,\"newSection\":1,\"editSection\":1,\"newhrdepartment\":1,\"newMeal\":1,\"editMeal\":1,\"newShift\":1,\"newProgram\":1,\"editProgram\":1,\"newCrediting\":1,\"editCrediting\":1,\"newClinicVisit\":1,\"editClinicVisit\":1,\"newProjectDonor\":1,\"editProjectDonor\":1,\"newProject\":1,\"editProject\":1,\"newEmployeeProject\":1,\"editEmployeeProject\":1,\"newInventoryAdjustment\":1,\"editInventoryAdjustment\":1,\"newContactBalance\":1,\"viewContactBalance\":1,\"editAdvancedPayment\":1,\"applyPaymentToSale\":1,\"applyPaymentToPurchase\":1,\"newHrJobResponsibility\":1,\"newProjectPaymentVoucher\":1,\"editProjectPaymentVoucher\":1,\"newLogisticsPurchaseRequest\":1,\"newLogisticsPurchaseOrder\":1,\"newLogisticTransportation\":\"1\",\"editLogisticTransportation\":\"1\",\"newTimeSheet\":\"1\",\"newProjectPaymentReceipt\":\"1\",\"newEmployeeShift\":\"1\",\"editEmployeeShift\":\"1\",\"newEmployeeAsset\":1,\"expensePayment\":1,\"assignleave\":1,\"editLogisticPurchase\":1,\"newRoom\":1,\"newInOutLog\":1,\"editInOutLog\":1,\"newEmployeeContract\":1,\"newNgoAsset\":1,\"trackLogisticRequest\":1,\"terminateEmployee\":1,\"reemploymentEmployee\":1}"),
(23,"Logistics Manager","{\"receive-payments\":1,\"bill-payments\":1,\"expense-payments\":1,\"hr-job-responsibilities\":1,\"payment-vouchers\":1,\"attendance-logs\":1,\"employee-shift-list\":1,\"hr-employee-list\":1,\"ngo-assets\":1,\"purchase-requests\":1,\"purchase-orders\":1}","{\"categoryForm\":1,\"viewItem\":1,\"manufactureForm\":1,\"countryForm\":1,\"unitForm\":1,\"unitTypeForm\":1,\"viewField\":1,\"newField\":1,\"newTemplate\":1,\"editTemplate\":1,\"assignPayroll\":1,\"viewSalary\":1,\"newContact\":1,\"cityForm\":1,\"townForm\":1,\"editContact\":1,\"newAccount\":1,\"editAccount\":1,\"newInventory\":1,\"editInventory\":1,\"inventoryItems\":1,\"inventoryExpireItems\":1,\"newBank\":1,\"editBank\":1,\"newSafe\":1,\"editSafe\":1,\"newBankAccount\":1,\"editBankAccount\":1,\"newPurchase\":1,\"editPurchase\":1,\"makePayment\":1,\"editMakePayment\":1,\"newSale\":1,\"editSale\":1,\"recivePayment\":1,\"editRecivePayment\":1,\"newJornalEntry\":1,\"editJornalEntry\":1,\"newInventoryTransfer\":1,\"editInventoryTransfer\":1,\"newExpense\":1,\"editExpense\":1,\"newCurrencyRate\":1,\"editCurrencyRate\":1,\"newPermession\":1,\"editPermession\":1,\"newUser\":1,\"editUser\":1,\"newProduction\":1,\"editProduction\":1,\"newSliter\":1,\"editSliter\":1,\"inventoryAnalysis\":1,\"StartingInventory.php\":1,\"newStartingInventory\":1,\"editStartingInventory\":1,\"newStartingBalance\":1,\"newBalance\":1,\"emergencyContact\":1,\"salaryComponent\":1,\"dependents\":1,\"immigration\":1,\"reportSupervisor\":1,\"reportSubordinates\":1,\"qualificationsWork\":1,\"qualificationsEducation\":1,\"qualificationsSkill\":1,\"qualificationsLanguage\":1,\"qualificationsLicense\":1,\"membership\":1,\"newLeaveType\":1,\"holiday\":1,\"EmployeeEntitlement\":1,\"MultipleEntitlement\":1,\"newVacancy\":1,\"newCandidate\":1,\"generateAttendanceLogs\":1,\"in/outlogs\":1,\"newLocation\":1,\"editLocation\":1,\"newCompany\":1,\"editCompany\":1,\"newDepartment\":1,\"editDepartment\":1,\"newSection\":1,\"editSection\":1,\"newhrdepartment\":1,\"newMeal\":1,\"editMeal\":1,\"newShift\":1,\"newProgram\":1,\"editProgram\":1,\"newCrediting\":1,\"editCrediting\":1,\"newClinicVisit\":1,\"editClinicVisit\":1,\"newProjectDonor\":1,\"editProjectDonor\":1,\"newProject\":1,\"editProject\":1,\"newEmployeeProject\":1,\"editEmployeeProject\":1,\"newInventoryAdjustment\":1,\"editInventoryAdjustment\":1,\"newContactBalance\":1,\"viewContactBalance\":1,\"editAdvancedPayment\":1,\"applyPaymentToSale\":1,\"applyPaymentToPurchase\":1,\"newHrJobResponsibility\":1,\"newProjectPaymentVoucher\":1,\"editProjectPaymentVoucher\":1,\"newLogisticsPurchaseRequest\":1,\"newLogisticsPurchaseOrder\":1,\"newLogisticTransportation\":\"1\",\"editLogisticTransportation\":\"1\",\"newTimeSheet\":\"1\",\"newProjectPaymentReceipt\":\"1\",\"newEmployeeShift\":\"1\",\"editEmployeeShift\":\"1\",\"newEmployeeAsset\":1,\"expensePayment\":1,\"assignleave\":1,\"editLogisticPurchase\":1,\"newRoom\":1,\"newInOutLog\":1,\"editInOutLog\":1,\"newEmployeeContract\":1,\"newNgoAsset\":1,\"trackLogisticRequest\":1,\"terminateEmployee\":1,\"reemploymentEmployee\":1}"),
(24,"Admin","{\"receive-payments\":1,\"bill-payments\":1,\"expense-payments\":1,\"hr-job-responsibilities\":1,\"payment-vouchers\":1,\"attendance-logs\":1,\"employee-shift-list\":1,\"hr-employee-list\":1,\"ngo-assets\":1,\"purchase-requests\":1,\"purchase-orders\":1}","{\"categoryForm\":1,\"viewItem\":1,\"manufactureForm\":1,\"countryForm\":1,\"unitForm\":1,\"unitTypeForm\":1,\"viewField\":1,\"newField\":1,\"newTemplate\":1,\"editTemplate\":1,\"assignPayroll\":1,\"viewSalary\":1,\"newContact\":1,\"cityForm\":1,\"townForm\":1,\"editContact\":1,\"newAccount\":1,\"editAccount\":1,\"newInventory\":1,\"editInventory\":1,\"inventoryItems\":1,\"inventoryExpireItems\":1,\"newBank\":1,\"editBank\":1,\"newSafe\":1,\"editSafe\":1,\"newBankAccount\":1,\"editBankAccount\":1,\"newPurchase\":1,\"editPurchase\":1,\"makePayment\":1,\"editMakePayment\":1,\"newSale\":1,\"editSale\":1,\"recivePayment\":1,\"editRecivePayment\":1,\"newJornalEntry\":1,\"editJornalEntry\":1,\"newInventoryTransfer\":1,\"editInventoryTransfer\":1,\"newExpense\":1,\"editExpense\":1,\"newCurrencyRate\":1,\"editCurrencyRate\":1,\"newPermession\":1,\"editPermession\":1,\"newUser\":1,\"editUser\":1,\"newProduction\":1,\"editProduction\":1,\"newSliter\":1,\"editSliter\":1,\"inventoryAnalysis\":1,\"StartingInventory.php\":1,\"newStartingInventory\":1,\"editStartingInventory\":1,\"newStartingBalance\":1,\"newBalance\":1,\"emergencyContact\":1,\"salaryComponent\":1,\"dependents\":1,\"immigration\":1,\"reportSupervisor\":1,\"reportSubordinates\":1,\"qualificationsWork\":1,\"qualificationsEducation\":1,\"qualificationsSkill\":1,\"qualificationsLanguage\":1,\"qualificationsLicense\":1,\"membership\":1,\"newLeaveType\":1,\"holiday\":1,\"EmployeeEntitlement\":1,\"MultipleEntitlement\":1,\"newVacancy\":1,\"newCandidate\":1,\"generateAttendanceLogs\":1,\"in/outlogs\":1,\"newLocation\":1,\"editLocation\":1,\"newCompany\":1,\"editCompany\":1,\"newDepartment\":1,\"editDepartment\":1,\"newSection\":1,\"editSection\":1,\"newhrdepartment\":1,\"newMeal\":1,\"editMeal\":1,\"newShift\":1,\"newProgram\":1,\"editProgram\":1,\"newCrediting\":1,\"editCrediting\":1,\"newClinicVisit\":1,\"editClinicVisit\":1,\"newProjectDonor\":1,\"editProjectDonor\":1,\"newProject\":1,\"editProject\":1,\"newEmployeeProject\":1,\"editEmployeeProject\":1,\"newInventoryAdjustment\":1,\"editInventoryAdjustment\":1,\"newContactBalance\":1,\"viewContactBalance\":1,\"editAdvancedPayment\":1,\"applyPaymentToSale\":1,\"applyPaymentToPurchase\":1,\"newHrJobResponsibility\":1,\"newProjectPaymentVoucher\":1,\"editProjectPaymentVoucher\":1,\"newLogisticsPurchaseRequest\":1,\"newLogisticsPurchaseOrder\":1,\"newLogisticTransportation\":\"1\",\"editLogisticTransportation\":\"1\",\"newTimeSheet\":\"1\",\"newProjectPaymentReceipt\":\"1\",\"newEmployeeShift\":\"1\",\"editEmployeeShift\":\"1\",\"newEmployeeAsset\":1,\"expensePayment\":1,\"assignleave\":1,\"editLogisticPurchase\":1,\"newRoom\":1,\"newInOutLog\":1,\"editInOutLog\":1,\"newEmployeeContract\":1,\"newNgoAsset\":1,\"trackLogisticRequest\":1,\"terminateEmployee\":1,\"reemploymentEmployee\":1}"),
(25,"HR Manager","{\"receive-payments\":1,\"bill-payments\":1,\"expense-payments\":1,\"hr-job-responsibilities\":1,\"payment-vouchers\":1,\"attendance-logs\":1,\"employee-shift-list\":1,\"hr-employee-list\":1,\"ngo-assets\":1,\"purchase-requests\":1,\"purchase-orders\":1,\"job-title\":1}","{\"categoryForm\":1,\"viewItem\":1,\"manufactureForm\":1,\"countryForm\":1,\"unitForm\":1,\"unitTypeForm\":1,\"viewField\":1,\"newField\":1,\"newTemplate\":1,\"editTemplate\":1,\"assignPayroll\":1,\"viewSalary\":1,\"newContact\":1,\"cityForm\":1,\"townForm\":1,\"editContact\":1,\"newAccount\":1,\"editAccount\":1,\"newInventory\":1,\"editInventory\":1,\"inventoryItems\":1,\"inventoryExpireItems\":1,\"newBank\":1,\"editBank\":1,\"newSafe\":1,\"editSafe\":1,\"newBankAccount\":1,\"editBankAccount\":1,\"newPurchase\":1,\"editPurchase\":1,\"makePayment\":1,\"editMakePayment\":1,\"newSale\":1,\"editSale\":1,\"recivePayment\":1,\"editRecivePayment\":1,\"newJornalEntry\":1,\"editJornalEntry\":1,\"newInventoryTransfer\":1,\"editInventoryTransfer\":1,\"newExpense\":1,\"editExpense\":1,\"newCurrencyRate\":1,\"editCurrencyRate\":1,\"newPermession\":1,\"editPermession\":1,\"newUser\":1,\"editUser\":1,\"newProduction\":1,\"editProduction\":1,\"newSliter\":1,\"editSliter\":1,\"inventoryAnalysis\":1,\"StartingInventory.php\":1,\"newStartingInventory\":1,\"editStartingInventory\":1,\"newStartingBalance\":1,\"newBalance\":1,\"emergencyContact\":1,\"salaryComponent\":1,\"dependents\":1,\"immigration\":1,\"reportSupervisor\":1,\"reportSubordinates\":1,\"qualificationsWork\":1,\"qualificationsEducation\":1,\"qualificationsSkill\":1,\"qualificationsLanguage\":1,\"qualificationsLicense\":1,\"membership\":1,\"newLeaveType\":1,\"holiday\":1,\"EmployeeEntitlement\":1,\"MultipleEntitlement\":1,\"newVacancy\":1,\"newCandidate\":1,\"generateAttendanceLogs\":1,\"in/outlogs\":1,\"newLocation\":1,\"editLocation\":1,\"newCompany\":1,\"editCompany\":1,\"newDepartment\":1,\"editDepartment\":1,\"newSection\":1,\"editSection\":1,\"newhrdepartment\":1,\"newMeal\":1,\"editMeal\":1,\"newShift\":1,\"newProgram\":1,\"editProgram\":1,\"newCrediting\":1,\"editCrediting\":1,\"newClinicVisit\":1,\"editClinicVisit\":1,\"newProjectDonor\":1,\"editProjectDonor\":1,\"newProject\":1,\"editProject\":1,\"newEmployeeProject\":1,\"editEmployeeProject\":1,\"newInventoryAdjustment\":1,\"editInventoryAdjustment\":1,\"newContactBalance\":1,\"viewContactBalance\":1,\"editAdvancedPayment\":1,\"applyPaymentToSale\":1,\"applyPaymentToPurchase\":1,\"newHrJobResponsibility\":1,\"newProjectPaymentVoucher\":1,\"editProjectPaymentVoucher\":1,\"newLogisticsPurchaseRequest\":1,\"newLogisticsPurchaseOrder\":1,\"newLogisticTransportation\":\"1\",\"editLogisticTransportation\":\"1\",\"newTimeSheet\":\"1\",\"newProjectPaymentReceipt\":\"1\",\"newEmployeeShift\":\"1\",\"editEmployeeShift\":\"1\",\"newEmployeeAsset\":1,\"expensePayment\":1,\"assignleave\":1,\"editLogisticPurchase\":1,\"newRoom\":1,\"newInOutLog\":1,\"editInOutLog\":1,\"newEmployeeContract\":1,\"newNgoAsset\":1,\"trackLogisticRequest\":1,\"terminateEmployee\":1,\"reemploymentEmployee\":1}"),
(26,"Project Manager","{\"receive-payments\":1,\"bill-payments\":1,\"expense-payments\":1,\"hr-job-responsibilities\":1,\"payment-vouchers\":1,\"attendance-logs\":1,\"employee-shift-list\":1,\"hr-employee-list\":1,\"ngo-assets\":1,\"purchase-requests\":1,\"purchase-orders\":1}","{\"categoryForm\":1,\"viewItem\":1,\"manufactureForm\":1,\"countryForm\":1,\"unitForm\":1,\"unitTypeForm\":1,\"viewField\":1,\"newField\":1,\"newTemplate\":1,\"editTemplate\":1,\"assignPayroll\":1,\"viewSalary\":1,\"newContact\":1,\"cityForm\":1,\"townForm\":1,\"editContact\":1,\"newAccount\":1,\"editAccount\":1,\"newInventory\":1,\"editInventory\":1,\"inventoryItems\":1,\"inventoryExpireItems\":1,\"newBank\":1,\"editBank\":1,\"newSafe\":1,\"editSafe\":1,\"newBankAccount\":1,\"editBankAccount\":1,\"newPurchase\":1,\"editPurchase\":1,\"makePayment\":1,\"editMakePayment\":1,\"newSale\":1,\"editSale\":1,\"recivePayment\":1,\"editRecivePayment\":1,\"newJornalEntry\":1,\"editJornalEntry\":1,\"newInventoryTransfer\":1,\"editInventoryTransfer\":1,\"newExpense\":1,\"editExpense\":1,\"newCurrencyRate\":1,\"editCurrencyRate\":1,\"newPermession\":1,\"editPermession\":1,\"newUser\":1,\"editUser\":1,\"newProduction\":1,\"editProduction\":1,\"newSliter\":1,\"editSliter\":1,\"inventoryAnalysis\":1,\"StartingInventory.php\":1,\"newStartingInventory\":1,\"editStartingInventory\":1,\"newStartingBalance\":1,\"newBalance\":1,\"emergencyContact\":1,\"salaryComponent\":1,\"dependents\":1,\"immigration\":1,\"reportSupervisor\":1,\"reportSubordinates\":1,\"qualificationsWork\":1,\"qualificationsEducation\":1,\"qualificationsSkill\":1,\"qualificationsLanguage\":1,\"qualificationsLicense\":1,\"membership\":1,\"newLeaveType\":1,\"holiday\":1,\"EmployeeEntitlement\":1,\"MultipleEntitlement\":1,\"newVacancy\":1,\"newCandidate\":1,\"generateAttendanceLogs\":1,\"in/outlogs\":1,\"newLocation\":1,\"editLocation\":1,\"newCompany\":1,\"editCompany\":1,\"newDepartment\":1,\"editDepartment\":1,\"newSection\":1,\"editSection\":1,\"newhrdepartment\":1,\"newMeal\":1,\"editMeal\":1,\"newShift\":1,\"newProgram\":1,\"editProgram\":1,\"newCrediting\":1,\"editCrediting\":1,\"newClinicVisit\":1,\"editClinicVisit\":1,\"newProjectDonor\":1,\"editProjectDonor\":1,\"newProject\":1,\"editProject\":1,\"newEmployeeProject\":1,\"editEmployeeProject\":1,\"newInventoryAdjustment\":1,\"editInventoryAdjustment\":1,\"newContactBalance\":1,\"viewContactBalance\":1,\"editAdvancedPayment\":1,\"applyPaymentToSale\":1,\"applyPaymentToPurchase\":1,\"newHrJobResponsibility\":1,\"newProjectPaymentVoucher\":1,\"editProjectPaymentVoucher\":1,\"newLogisticsPurchaseRequest\":1,\"newLogisticsPurchaseOrder\":1,\"newLogisticTransportation\":\"1\",\"editLogisticTransportation\":\"1\",\"newTimeSheet\":\"1\",\"newProjectPaymentReceipt\":\"1\",\"newEmployeeShift\":\"1\",\"editEmployeeShift\":\"1\",\"newEmployeeAsset\":1,\"expensePayment\":1,\"assignleave\":1,\"editLogisticPurchase\":1,\"newRoom\":1,\"newInOutLog\":1,\"editInOutLog\":1,\"newEmployeeContract\":1,\"newNgoAsset\":1,\"trackLogisticRequest\":1,\"terminateEmployee\":1,\"reemploymentEmployee\":1}"),
(27,"Accountant","{\"receive-payments\":1,\"bill-payments\":1,\"expense-payments\":1,\"hr-job-responsibilities\":1,\"payment-vouchers\":1,\"attendance-logs\":1,\"employee-shift-list\":1,\"hr-employee-list\":1,\"ngo-assets\":1,\"purchase-requests\":1,\"purchase-orders\":1}","{\"categoryForm\":1,\"viewItem\":1,\"manufactureForm\":1,\"countryForm\":1,\"unitForm\":1,\"unitTypeForm\":1,\"viewField\":1,\"newField\":1,\"newTemplate\":1,\"editTemplate\":1,\"assignPayroll\":1,\"viewSalary\":1,\"newContact\":1,\"cityForm\":1,\"townForm\":1,\"editContact\":1,\"newAccount\":1,\"editAccount\":1,\"newInventory\":1,\"editInventory\":1,\"inventoryItems\":1,\"inventoryExpireItems\":1,\"newBank\":1,\"editBank\":1,\"newSafe\":1,\"editSafe\":1,\"newBankAccount\":1,\"editBankAccount\":1,\"newPurchase\":1,\"editPurchase\":1,\"makePayment\":1,\"editMakePayment\":1,\"newSale\":1,\"editSale\":1,\"recivePayment\":1,\"editRecivePayment\":1,\"newJornalEntry\":1,\"editJornalEntry\":1,\"newInventoryTransfer\":1,\"editInventoryTransfer\":1,\"newExpense\":1,\"editExpense\":1,\"newCurrencyRate\":1,\"editCurrencyRate\":1,\"newPermession\":1,\"editPermession\":1,\"newUser\":1,\"editUser\":1,\"newProduction\":1,\"editProduction\":1,\"newSliter\":1,\"editSliter\":1,\"inventoryAnalysis\":1,\"StartingInventory.php\":1,\"newStartingInventory\":1,\"editStartingInventory\":1,\"newStartingBalance\":1,\"newBalance\":1,\"emergencyContact\":1,\"salaryComponent\":1,\"dependents\":1,\"immigration\":1,\"reportSupervisor\":1,\"reportSubordinates\":1,\"qualificationsWork\":1,\"qualificationsEducation\":1,\"qualificationsSkill\":1,\"qualificationsLanguage\":1,\"qualificationsLicense\":1,\"membership\":1,\"newLeaveType\":1,\"holiday\":1,\"EmployeeEntitlement\":1,\"MultipleEntitlement\":1,\"newVacancy\":1,\"newCandidate\":1,\"generateAttendanceLogs\":1,\"in/outlogs\":1,\"newLocation\":1,\"editLocation\":1,\"newCompany\":1,\"editCompany\":1,\"newDepartment\":1,\"editDepartment\":1,\"newSection\":1,\"editSection\":1,\"newhrdepartment\":1,\"newMeal\":1,\"editMeal\":1,\"newShift\":1,\"newProgram\":1,\"editProgram\":1,\"newCrediting\":1,\"editCrediting\":1,\"newClinicVisit\":1,\"editClinicVisit\":1,\"newProjectDonor\":1,\"editProjectDonor\":1,\"newProject\":1,\"editProject\":1,\"newEmployeeProject\":1,\"editEmployeeProject\":1,\"newInventoryAdjustment\":1,\"editInventoryAdjustment\":1,\"newContactBalance\":1,\"viewContactBalance\":1,\"editAdvancedPayment\":1,\"applyPaymentToSale\":1,\"applyPaymentToPurchase\":1,\"newHrJobResponsibility\":1,\"newProjectPaymentVoucher\":1,\"editProjectPaymentVoucher\":1,\"newLogisticsPurchaseRequest\":1,\"newLogisticsPurchaseOrder\":1,\"newLogisticTransportation\":\"1\",\"editLogisticTransportation\":\"1\",\"newTimeSheet\":\"1\",\"newProjectPaymentReceipt\":\"1\",\"newEmployeeShift\":\"1\",\"editEmployeeShift\":\"1\",\"newEmployeeAsset\":1,\"expensePayment\":1,\"assignleave\":1,\"editLogisticPurchase\":1,\"newRoom\":1,\"newInOutLog\":1,\"editInOutLog\":1,\"newEmployeeContract\":1,\"newNgoAsset\":1,\"trackLogisticRequest\":1,\"terminateEmployee\":1,\"reemploymentEmployee\":1}"),
(28,"Office Admin",NULL,NULL),
(29,"Logistics Officer",NULL,NULL),
(30,"Administrator",NULL,NULL);


DROP TABLE production;

CREATE TABLE `production` (
  `productionId` int(11) NOT NULL AUTO_INCREMENT,
  `orderNo` varchar(45) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `sdate` date DEFAULT NULL,
  `edate` date DEFAULT NULL,
  `ddate` date DEFAULT NULL,
  `device` varchar(50) DEFAULT NULL,
  `ContactId` int(11) DEFAULT NULL,
  `rawmaterialInventory` int(11) DEFAULT NULL,
  `inproccessInventory` int(11) DEFAULT NULL,
  `productionInventory` int(11) DEFAULT NULL,
  `wasteInventory` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 0,
  `deleted` tinyint(1) DEFAULT 0,
  `expensAccountId` int(11) DEFAULT NULL,
  `transId` bigint(11) DEFAULT NULL,
  `itemtransId` bigint(11) DEFAULT NULL,
  `inputs` mediumtext DEFAULT NULL,
  `outputs` mediumtext DEFAULT NULL,
  `expenses` mediumtext DEFAULT NULL,
  `wastes` mediumtext DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  PRIMARY KEY (`productionId`),
  KEY `index2` (`rawmaterialInventory`),
  KEY `index3` (`inproccessInventory`),
  KEY `index4` (`productionInventory`),
  KEY `index5` (`wasteInventory`),
  KEY `ew_idx` (`transId`),
  KEY `khgfds_idx` (`transId`),
  KEY `lklklkl_idx` (`itemtransId`),
  CONSTRAINT `khgfds` FOREIGN KEY (`transId`) REFERENCES `transactions` (`TransactionId`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `lklklkl` FOREIGN KEY (`itemtransId`) REFERENCES `itemtransactions` (`ItemTransactionId`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE project_donors;

CREATE TABLE `project_donors` (
  `DonorId` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(250) NOT NULL,
  `Address` varchar(512) DEFAULT NULL,
  `Deleted` tinyint(4) NOT NULL DEFAULT 0,
  `CreateDate` datetime NOT NULL,
  `CreatedByUserId` int(11) NOT NULL,
  `ModificationDate` datetime DEFAULT NULL,
  `ModifiedByUserId` int(11) DEFAULT NULL,
  PRIMARY KEY (`DonorId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE project_payment_receipts;

CREATE TABLE `project_payment_receipts` (
  `PaymentReceiptId` int(11) NOT NULL AUTO_INCREMENT,
  `ProjectId` int(11) DEFAULT NULL,
  `ExchangeRate` decimal(16,4) DEFAULT NULL,
  `Total` decimal(16,4) DEFAULT NULL,
  `Notes` varchar(500) DEFAULT NULL,
  `Date` date DEFAULT NULL,
  `Status` int(11) DEFAULT NULL,
  `Deleted` tinyint(1) DEFAULT NULL,
  `CreatedByUserId` int(11) DEFAULT NULL,
  `ModifiedByUserId` int(11) DEFAULT NULL,
  `CreateDate` datetime DEFAULT NULL,
  `ModificationDate` datetime DEFAULT NULL,
  `No` int(11) DEFAULT NULL,
  `TotalInProjectCurrency` decimal(16,4) DEFAULT NULL,
  `CurrencyId` int(11) DEFAULT NULL,
  `Attachment` varchar(2000) DEFAULT NULL,
  PRIMARY KEY (`PaymentReceiptId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE project_payment_voucher_budget_items;

CREATE TABLE `project_payment_voucher_budget_items` (
  `project_payment_voucher_budget_item_id` int(11) NOT NULL AUTO_INCREMENT,
  `Code` varchar(45) DEFAULT NULL,
  `Description` varchar(500) DEFAULT NULL,
  `ProjectId` int(11) DEFAULT NULL,
  `Qty` decimal(18,6) DEFAULT NULL,
  `Price` decimal(18,6) DEFAULT NULL,
  `PaymentVoucherId` int(11) DEFAULT NULL,
  `CurrencyId` bigint(20) DEFAULT NULL,
  `PriceInProjectCurrency` decimal(18,6) DEFAULT NULL,
  `PaymentReceiptId` int(11) DEFAULT NULL,
  `Status` int(11) DEFAULT NULL,
  PRIMARY KEY (`project_payment_voucher_budget_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE project_payment_vouchers;

CREATE TABLE `project_payment_vouchers` (
  `PaymentVoucherId` int(11) NOT NULL AUTO_INCREMENT,
  `ProjectId` int(11) DEFAULT NULL,
  `AccountCode` varchar(45) DEFAULT NULL,
  `AmountExRate` decimal(16,4) DEFAULT NULL,
  `Total` decimal(16,4) DEFAULT NULL,
  `Notes` varchar(500) DEFAULT NULL,
  `Status` int(11) DEFAULT NULL,
  `Date` date DEFAULT NULL,
  `Deleted` tinyint(1) DEFAULT NULL,
  `CreatedByUserId` int(11) DEFAULT NULL,
  `ModifiedByUserId` int(11) DEFAULT NULL,
  `CreateDate` datetime DEFAULT NULL,
  `ModificationDate` datetime DEFAULT NULL,
  `No` int(11) DEFAULT NULL,
  `PurchaseId` int(11) DEFAULT NULL,
  `PaymentMethod` int(11) DEFAULT NULL,
  `Attachment` varchar(2000) DEFAULT NULL,
  PRIMARY KEY (`PaymentVoucherId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE project_project_budget_items;

CREATE TABLE `project_project_budget_items` (
  `ProjectBudgetItemId` int(11) NOT NULL AUTO_INCREMENT,
  `Code` varchar(20) NOT NULL,
  `Name` varchar(250) NOT NULL,
  `Description` text NOT NULL,
  `Deleted` tinyint(1) NOT NULL DEFAULT 0,
  `CreateDate` datetime NOT NULL,
  `CreatedByUserId` int(11) NOT NULL,
  `ModificationDate` datetime DEFAULT NULL,
  `ModifiedByUserId` int(11) DEFAULT NULL,
  `ProjectId` int(11) NOT NULL,
  `DepartmentId` int(11) NOT NULL,
  `Qty` decimal(18,6) DEFAULT NULL,
  `Price` decimal(18,6) DEFAULT NULL,
  `CurrencyId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ProjectBudgetItemId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE project_projects;

CREATE TABLE `project_projects` (
  `ProjectId` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(250) NOT NULL,
  `DonorId` int(11) NOT NULL,
  `LocationId` int(11) NOT NULL,
  `ProjectManager` int(11) NOT NULL,
  `ProjectStartDate` date NOT NULL,
  `ProjectEndDate` date NOT NULL,
  `Deleted` tinyint(4) NOT NULL DEFAULT 0,
  `CreateDate` datetime NOT NULL,
  `CreatedByUserId` int(11) NOT NULL,
  `ModificationDate` datetime DEFAULT NULL,
  `ModifiedByUserId` int(11) DEFAULT NULL,
  `CurrencyId` bigint(20) DEFAULT NULL,
  `ReferencePrefix` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`ProjectId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE reportdef;

CREATE TABLE `reportdef` (
  `reportId` bigint(20) NOT NULL AUTO_INCREMENT,
  `data` varchar(100) DEFAULT NULL,
  `meta` varchar(100) DEFAULT NULL,
  `Deleted` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`reportId`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

INSERT INTO reportdef VALUES
(6,"PRINT_SALE","PRINT_SALE_META",0);


DROP TABLE reports;

CREATE TABLE `reports` (
  `reportId` bigint(20) NOT NULL AUTO_INCREMENT,
  `html` longtext DEFAULT NULL,
  `Deleted` tinyint(1) DEFAULT 0,
  `CreateDate` datetime DEFAULT NULL,
  `parameters` mediumtext DEFAULT NULL,
  `tableStyle` varchar(50) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `reportOP` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`reportId`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

INSERT INTO reports VALUES
(1,"																																								<p>									</p><p style=\"text-align: center; \"><br></p><p><br></p><p><br></p><table class=\"table table-bordered\"><tbody><tr><td><p><br></p><h2 style=\"text-align: center; \">&nbsp;&nbsp;&nbsp;<font face=\"Impact\">&nbsp;[Name]</font></h2><br><p></p></td><td><p><br></p><h2 style=\"text-align: center; \"><font face=\"Impact\">&nbsp;&nbsp;&nbsp;&nbsp;[Reference]</font></h2><br><p></p></td><td><p><br></p><h2 style=\"text-align: center; \">&nbsp;&nbsp;<font face=\"Impact\">&nbsp;&nbsp;[CreationDate]</font></h2><br><p></p></td></tr></tbody></table><p><br></p><ol><li>hello&nbsp;</li><li>world</li></ol><p>[header]</p><p></p><h3 style=\"text-align: center; \">[element] <font face=\"Impact\" color=\"#9c0000\">Item Name</font> [/element]</h3><h3 style=\"text-align: center; line-height: 1.53846;\"><span style=\"color: rgb(0, 0, 0); font-family: Roboto, \" helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;\"=\"\">[element] </span><font color=\"#9c0000\" face=\"Impact\">Quantity</font>[/element]</h3><br>[/header]<br><p></p><p>[repeat]</p><h5 style=\"text-align: center; \">[element][ItemName] [/element]</h5><h4>[element] <font face=\"Verdana\" color=\"#731842\">[Quantity]</font>&nbsp;[/element]</h4><p> [/repeat]</p><p><br></p><p><br></p><hr><p style=\"text-align: center; \"><br></p>																																",0,NULL,"[{\"key\":\"transactionId\",\"element\":\"#TransactionId\"}]","table-striped","Xdrandn","PRINT_SALE"),
(2,"<p><h1>[/element]&nbsp;&nbsp;&nbsp;&nbsp;[Name]</h1>[element]</p><p>[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[Reference]<br>[/element]</p><p>[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[CreationDate]<br>[/element]</p><p><br></p><p>[repeat]</p><p>[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[ItemName]<br>[/element]</p><p>[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[Quantity]<br>[/element]</p><p>[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[Weight]<br>[/element]</p><p>[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[Note]<br>[/element]<br><br>[/repeat]<br>									</p>",0,NULL,"[{\"key\":\"transactionId\",\"element\":\"#TransactionId\"}]","table-hover","Defualt Name","PRINT_SALE"),
(3,"<p><br>&nbsp;&nbsp;&nbsp;&nbsp;[Name]<br><br>									</p>",0,NULL,"[{\"key\":\"transactionId\",\"element\":\"#TransactionId\"}]"," table","Defualt Name","PRINT_SALE"),
(4,"										<p style=\"text-align: center; \"><img src=\"data:image/jpeg;base64,[encoded data, 104404 characters]\" data-filename=\"13336142_1352683821415573_4461924453134779006_n.jpg\" style=\"width: 851px;\"><br></p><h3><br></h3><table class=\"table table-bordered\"><tbody><tr><td><h3 style=\"font-family: Roboto, \" helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" line-height:=\"\" 1.53846;=\"\" color:=\"\" rgb(0,=\"\" 0,=\"\" 0);\"=\"\"><font color=\"#9c0000\" face=\"Impact\">&nbsp; &nbsp; [Name]</font></h3></td><td><p>[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[Reference]<br>[/element]<br></p></td><td><p>[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[CreationDate]<br>[/element]<br></p></td></tr></tbody></table><h3><font color=\"#9c0000\" face=\"Impact\"><br></font></h3><p>[header] </p><p style=\"font-family: Roboto, \" helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" line-height:=\"\" 1.53846;=\"\" color:=\"\" rgb(0,=\"\" 0,=\"\" 0);\"=\"\">[element]<br>&nbsp;&nbsp;Item Name<br>[/element]<br>[element]<br>&nbsp;Quantity<br>[/element]<br>[element]<br>&nbsp;&nbsp;Weight<br>[/element]</p><p>[/header]</p><p>[repeat] </p><p>[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[ItemName]<br>[/element]</p><p>[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[Quantity]<br>[/element]</p><p>[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[Weight]<br>[/element]<br></p><p>[/repeat]</p><br>									<p></p>								",0,NULL,"[{\"key\":\"transactionId\",\"element\":\"#TransactionId\"}]"," table","Defualt Name","PRINT_SALE"),
(5,"					<p>[TransactionId]</p><p>[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[Narration]<br>[/element]</p><p>[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[CreateDate]<br>[/element]</p><p>[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[DocumentReference]<br>[/element]</p><p>[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[TransactionDate]<br>[/element]<br><br></p>				",0,NULL,"[{\"key\":\"transactionId\",\"element\":\"#TransactionId\"}]"," table","YAYY ITS Working","PRINT_SALE"),
(6,"<p style=\"text-align: center; \"><img src=\"data:image/png;base64,[encoded data, 61332 characters]\" data-filename=\"gigant_logo_landscape_low_res.png\" style=\"width: 25%; float: none;\" class=\"\"></p><div style=\"text-align: center;\"><br></div><table class=\"table table-bordered\"><tbody><tr><td><p>Invoice No: [DocumentReference]<br></p></td><td style=\"text-align: right;\"><p>Date:&nbsp; &nbsp; [TransactionDate]<br></p></td></tr><tr><td>Notes:[Narration]</td><td style=\"text-align: right;\"><br></td></tr></tbody></table><div style=\"text-align: center;\"><br></div><div style=\"text-align: center;\">[header] </div><div style=\"text-align: center;\">[element] Item Id [/element]</div><div style=\"text-align: center;\">[element] Quantity[/element]</div><div style=\"text-align: center;\">[element] Total [/element]</div><div style=\"text-align: center;\">[/header]</div><div style=\"text-align: center;\"><br></div><div style=\"text-align: center;\">[repeat]</div><div style=\"text-align: center;\">[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[ItemId]<br>[/element]</div><div style=\"text-align: center;\">[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[Quantity]<br>[/element]</div><div style=\"text-align: center;\">[element]<br>&nbsp;&nbsp;&nbsp;&nbsp;[Total]<br>[/element]<br></div><div style=\"text-align: center;\"> [/repeat]</div><div style=\"text-align: center;\"><br></div><hr><h5 style=\"text-align: center;\"><i><font color=\"#9c9c94\">Extend Your Imagination</font></i></h5><p style=\"text-align: center; \">									</p>",0,NULL,"[{\"key\":\"transactionId\",\"element\":\"#TransactionId\"}]","table-bordered","Parameters Test","PRINT_SALE");


