/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50505
Source Host           : localhost:3306
Source Database       : linxclaims_softworld

Target Server Type    : MYSQL
Target Server Version : 50505
File Encoding         : 65001

Date: 2024-04-24 15:48:48
*/


-- ----------------------------
-- Table structure for access_level
-- ----------------------------
CREATE TABLE `access_level` (
  `access_id` int(15) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  PRIMARY KEY (`access_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of access_level
-- ----------------------------
INSERT INTO `access_level` VALUES ('1', 'ADMINISTRATOR');
INSERT INTO `access_level` VALUES ('2', 'STAFF');
INSERT INTO `access_level` VALUES ('3', 'APPROVAL');

-- ----------------------------
-- Table structure for approval_report
-- ----------------------------
CREATE TABLE `approval_report` (
  `approval_id` int(15) NOT NULL AUTO_INCREMENT,
  `approval1_id` int(15) NOT NULL,
  `approval2_id` int(15) NOT NULL,
  `approval3_id` int(15) NOT NULL,
  `user_id` int(15) NOT NULL,
  `report_reff` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `approved_amount` varchar(255) NOT NULL,
  PRIMARY KEY (`approval_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of approval_report
-- ----------------------------

-- ----------------------------
-- Table structure for approve_by
-- ----------------------------
CREATE TABLE `approve_by` (
  `approver_id` int(15) NOT NULL AUTO_INCREMENT,
  `user_id` int(15) DEFAULT NULL,
  `approval_1` varchar(15) DEFAULT NULL,
  `approval_2` varchar(15) DEFAULT NULL,
  `approval_3` varchar(15) DEFAULT NULL,
  `approver_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`approver_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of approve_by
-- ----------------------------
INSERT INTO `approve_by` VALUES ('4', '8', '3', '', '', 'EITHER');
INSERT INTO `approve_by` VALUES ('5', '12', '3', '15', '15', 'EITHER');
INSERT INTO `approve_by` VALUES ('7', '3', '3', '2', null, 'EITHER');
INSERT INTO `approve_by` VALUES ('8', '15', '3', '', '', 'EITHER');

-- ----------------------------
-- Table structure for bank_details
-- ----------------------------
CREATE TABLE `bank_details` (
  `bank_id` int(15) NOT NULL AUTO_INCREMENT,
  `bank_name` varchar(255) NOT NULL,
  `account` varchar(255) NOT NULL,
  `bank_pre` varchar(255) NOT NULL,
  PRIMARY KEY (`bank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of bank_details
-- ----------------------------

-- ----------------------------
-- Table structure for category
-- ----------------------------
CREATE TABLE `category` (
  `CategoryId` int(5) NOT NULL AUTO_INCREMENT,
  `UserId` int(5) NOT NULL,
  `CategoryName` varchar(255) NOT NULL,
  `Level` int(5) NOT NULL,
  `codecolor` varchar(255) NOT NULL,
  `account_code` varchar(255) NOT NULL,
  PRIMARY KEY (`CategoryId`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES ('1', '1', 'Travelling and Accommodation', '1', 'primary', '');
INSERT INTO `category` VALUES ('2', '1', 'Business Entertainment', '1', 'pink', '');
INSERT INTO `category` VALUES ('3', '1', 'Insurance', '1', 'info', '');
INSERT INTO `category` VALUES ('4', '1', 'Telephone, Fax and Internet', '1', 'default', '');
INSERT INTO `category` VALUES ('5', '1', 'Medical', '1', 'warning', '');
INSERT INTO `category` VALUES ('6', '1', 'Meal Allowance', '1', 'success', '');
INSERT INTO `category` VALUES ('8', '1', 'Rental', '2', 'inverse', '');
INSERT INTO `category` VALUES ('9', '1', 'Staff Welfare', '1', '', '');
INSERT INTO `category` VALUES ('10', '1', 'Office Sundries', '1', '', '');
INSERT INTO `category` VALUES ('11', '1', 'Motor Vehicle Expenses (Road Tax, Repair & Maintenance, Fuel)', '1', '', '');
INSERT INTO `category` VALUES ('12', '1', 'Parking, Toll and Mileage', '1', '', '');
INSERT INTO `category` VALUES ('13', '1', 'Printing and Stationeries', '1', '', '');
INSERT INTO `category` VALUES ('14', '1', 'Donations & Gifts', '1', '', '');
INSERT INTO `category` VALUES ('15', '1', 'Professional Membership Subscription', '1', '', '');
INSERT INTO `category` VALUES ('16', '1', 'Postage & Courier', '1', '', '');
INSERT INTO `category` VALUES ('17', '0', 'Club Subscription', '0', '', '');
INSERT INTO `category` VALUES ('18', '0', 'ICT Subscription', '0', '', '');
INSERT INTO `category` VALUES ('19', '0', 'Astro Subscription', '0', '', '');
INSERT INTO `category` VALUES ('20', '0', 'Rates and Assessment', '0', '', '');
INSERT INTO `category` VALUES ('21', '0', 'Cleaning and Housekeeping For Office/Staff House', '0', '', '');
INSERT INTO `category` VALUES ('22', '0', 'License Fees', '0', '', '');
INSERT INTO `category` VALUES ('23', '0', 'Seminar and Training Fees', '0', '', '');
INSERT INTO `category` VALUES ('24', '0', 'Utilities', '0', '', '');
INSERT INTO `category` VALUES ('25', '0', 'Advertisement and Promotion', '0', '', '90010');
INSERT INTO `category` VALUES ('26', '0', 'Filing and Searching Fees', '0', '', '');
INSERT INTO `category` VALUES ('27', '0', 'Newspaper and Magazine', '0', '', '');
INSERT INTO `category` VALUES ('28', '0', 'Small Asset', '0', '', '');
INSERT INTO `category` VALUES ('29', '0', 'Others', '0', '', '');
INSERT INTO `category` VALUES ('30', '0', 'Transport', '0', '', '');
INSERT INTO `category` VALUES ('31', '0', 'Office Grocery', '0', '', '');

-- ----------------------------
-- Table structure for categorycount
-- ----------------------------
CREATE TABLE `categorycount` (
  `category_count_id` int(15) NOT NULL AUTO_INCREMENT,
  `CategoryId` int(15) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `userid` int(15) NOT NULL,
  `categoryno` varchar(255) NOT NULL,
  PRIMARY KEY (`category_count_id`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of categorycount
-- ----------------------------
INSERT INTO `categorycount` VALUES ('1', '25', '50', '13', 'CATEGORY-122023-06630');
INSERT INTO `categorycount` VALUES ('2', '25', '50', '3', 'CATEGORY-122023-06631');
INSERT INTO `categorycount` VALUES ('3', '6', '50', '12', 'CATEGORY-122023-06632');
INSERT INTO `categorycount` VALUES ('4', '29', '50', '3', 'CATEGORY-122023-06633');
INSERT INTO `categorycount` VALUES ('5', '6', '50', '12', 'CATEGORY-122023-06634');
INSERT INTO `categorycount` VALUES ('6', '6', '50', '12', 'CATEGORY-122023-06635');
INSERT INTO `categorycount` VALUES ('7', '6', '100', '12', 'CATEGORY-122023-06636');
INSERT INTO `categorycount` VALUES ('8', '6', '150', '12', 'CATEGORY-122023-06637');
INSERT INTO `categorycount` VALUES ('9', '18', '50', '14', 'CATEGORY-122023-06638');
INSERT INTO `categorycount` VALUES ('10', '23', '59', '3', 'CATEGORY-122023-06639');
INSERT INTO `categorycount` VALUES ('11', '6', '68', '3', 'CATEGORY-122023-06640');
INSERT INTO `categorycount` VALUES ('12', '29', '67.10', '3', 'CATEGORY-122023-06641');
INSERT INTO `categorycount` VALUES ('13', '11', '130.05', '3', 'CATEGORY-122023-06642');
INSERT INTO `categorycount` VALUES ('14', '25', '168.80', '3', 'CATEGORY-122023-06643');
INSERT INTO `categorycount` VALUES ('15', '22', '50.00', '3', 'CATEGORY-122023-06644');
INSERT INTO `categorycount` VALUES ('16', '6', '10', '3', 'CATEGORY-122023-06645');
INSERT INTO `categorycount` VALUES ('17', '11', '124.00', '3', 'CATEGORY-122023-06646');
INSERT INTO `categorycount` VALUES ('18', '11', '334.54', '3', 'CATEGORY-122023-06647');
INSERT INTO `categorycount` VALUES ('19', '6', '200', '3', 'CATEGORY-122023-06648');
INSERT INTO `categorycount` VALUES ('20', '4', '38.00', '3', 'CATEGORY-122023-06649');
INSERT INTO `categorycount` VALUES ('21', '13', '67.10', '3', 'CATEGORY-122023-06650');
INSERT INTO `categorycount` VALUES ('22', '11', '130.05', '3', 'CATEGORY-122023-06651');
INSERT INTO `categorycount` VALUES ('23', '29', '168.80', '3', 'CATEGORY-122023-06652');
INSERT INTO `categorycount` VALUES ('24', '22', '50.00', '3', 'CATEGORY-122023-06653');
INSERT INTO `categorycount` VALUES ('25', '11', '334.54', '3', 'CATEGORY-122023-06654');
INSERT INTO `categorycount` VALUES ('26', '4', '38.00', '3', 'CATEGORY-122023-06655');
INSERT INTO `categorycount` VALUES ('27', '6', '200.00', '3', 'CATEGORY-122023-06656');
INSERT INTO `categorycount` VALUES ('28', '10', '172.12', '3', 'CATEGORY-122023-06657');
INSERT INTO `categorycount` VALUES ('29', '10', '233.48', '3', 'CATEGORY-122023-06658');
INSERT INTO `categorycount` VALUES ('30', '11', '93.52', '3', 'CATEGORY-122023-06659');
INSERT INTO `categorycount` VALUES ('31', '29', '463.45', '3', 'CATEGORY-122023-06660');
INSERT INTO `categorycount` VALUES ('32', '16', '13.05', '3', 'CATEGORY-012024-06661');
INSERT INTO `categorycount` VALUES ('33', '11', '211.49', '3', 'CATEGORY-012024-06662');
INSERT INTO `categorycount` VALUES ('34', '29', '101.40', '3', 'CATEGORY-012024-06663');
INSERT INTO `categorycount` VALUES ('35', '29', '198.70', '3', 'CATEGORY-012024-06664');
INSERT INTO `categorycount` VALUES ('36', '29', '47.70', '3', 'CATEGORY-012024-06665');
INSERT INTO `categorycount` VALUES ('37', '25', '293.36', '3', 'CATEGORY-012024-06666');
INSERT INTO `categorycount` VALUES ('38', '4', '73.35', '3', 'CATEGORY-012024-06667');
INSERT INTO `categorycount` VALUES ('39', '10', '1473.00', '3', 'CATEGORY-012024-06668');
INSERT INTO `categorycount` VALUES ('40', '29', '312.47', '3', 'CATEGORY-012024-06669');
INSERT INTO `categorycount` VALUES ('41', '29', '108.85', '3', 'CATEGORY-012024-06670');
INSERT INTO `categorycount` VALUES ('42', '29', '395.56', '3', 'CATEGORY-012024-06671');
INSERT INTO `categorycount` VALUES ('43', '29', '597.20', '3', 'CATEGORY-012024-06672');
INSERT INTO `categorycount` VALUES ('44', '29', '86.84', '3', 'CATEGORY-012024-06673');
INSERT INTO `categorycount` VALUES ('45', '29', '50.00', '3', 'CATEGORY-022024-06674');
INSERT INTO `categorycount` VALUES ('46', '11', '202.42', '3', 'CATEGORY-022024-06675');
INSERT INTO `categorycount` VALUES ('47', '11', '108.09', '3', 'CATEGORY-022024-06676');
INSERT INTO `categorycount` VALUES ('48', '25', '802.70', '3', 'CATEGORY-022024-06677');
INSERT INTO `categorycount` VALUES ('49', '6', '111.20', '3', 'CATEGORY-022024-06678');
INSERT INTO `categorycount` VALUES ('50', '8', '65.00', '3', 'CATEGORY-022024-06679');
INSERT INTO `categorycount` VALUES ('51', '8', '65.00', '3', 'CATEGORY-022024-06680');
INSERT INTO `categorycount` VALUES ('52', '8', '65.00', '3', 'CATEGORY-022024-06681');
INSERT INTO `categorycount` VALUES ('53', '8', '65.00', '3', 'CATEGORY-022024-06682');
INSERT INTO `categorycount` VALUES ('54', '8', '65.00', '3', 'CATEGORY-022024-06683');
INSERT INTO `categorycount` VALUES ('55', '8', '65.00', '3', 'CATEGORY-022024-06684');
INSERT INTO `categorycount` VALUES ('56', '4', '90.00', '3', 'CATEGORY-022024-06685');
INSERT INTO `categorycount` VALUES ('57', '14', '218.00', '3', 'CATEGORY-022024-06686');
INSERT INTO `categorycount` VALUES ('58', '6', '194.55', '3', 'CATEGORY-022024-06687');
INSERT INTO `categorycount` VALUES ('59', '11', '123.99', '3', 'CATEGORY-022024-06688');
INSERT INTO `categorycount` VALUES ('60', '22', '50.00', '3', 'CATEGORY-022024-06689');
INSERT INTO `categorycount` VALUES ('61', '11', '74.20', '3', 'CATEGORY-022024-06690');
INSERT INTO `categorycount` VALUES ('62', '29', '60.00', '3', 'CATEGORY-022024-06691');
INSERT INTO `categorycount` VALUES ('63', '29', '25.65', '3', 'CATEGORY-022024-06692');
INSERT INTO `categorycount` VALUES ('64', '29', '13.80', '3', 'CATEGORY-022024-06693');
INSERT INTO `categorycount` VALUES ('65', '5', '194.50', '3', 'CATEGORY-022024-06694');
INSERT INTO `categorycount` VALUES ('66', '29', '36.20', '3', 'CATEGORY-022024-06695');
INSERT INTO `categorycount` VALUES ('67', '29', '97.75', '3', 'CATEGORY-022024-06696');
INSERT INTO `categorycount` VALUES ('68', '5', '120.00', '3', 'CATEGORY-022024-06697');
INSERT INTO `categorycount` VALUES ('69', '29', '99.00', '3', 'CATEGORY-022024-06698');
INSERT INTO `categorycount` VALUES ('70', '8', '120.00', '3', 'CATEGORY-022024-06699');
INSERT INTO `categorycount` VALUES ('71', '4', '119.00', '3', 'CATEGORY-022024-06700');
INSERT INTO `categorycount` VALUES ('72', '4', '40.00', '3', 'CATEGORY-022024-06701');
INSERT INTO `categorycount` VALUES ('73', '29', '200', '3', 'CATEGORY-022024-06702');
INSERT INTO `categorycount` VALUES ('74', '31', '120', '3', 'CATEGORY-032024-06703');
INSERT INTO `categorycount` VALUES ('75', '5', '596.50', '3', 'CATEGORY-032024-06704');
INSERT INTO `categorycount` VALUES ('76', '29', '89.50', '3', 'CATEGORY-032024-06705');
INSERT INTO `categorycount` VALUES ('77', '29', '34.50', '3', 'CATEGORY-032024-06706');
INSERT INTO `categorycount` VALUES ('78', '31', '29.70', '3', 'CATEGORY-032024-06707');
INSERT INTO `categorycount` VALUES ('79', '31', '68.70', '3', 'CATEGORY-032024-06708');
INSERT INTO `categorycount` VALUES ('80', '29', '67.15', '3', 'CATEGORY-032024-06709');
INSERT INTO `categorycount` VALUES ('81', '29', '67.50', '3', 'CATEGORY-032024-06710');

-- ----------------------------
-- Table structure for claim_report
-- ----------------------------
CREATE TABLE `claim_report` (
  `claim_id` int(11) NOT NULL,
  `claim_type` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`claim_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of claim_report
-- ----------------------------

-- ----------------------------
-- Table structure for company
-- ----------------------------
CREATE TABLE `company` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `companyname` varchar(255) NOT NULL,
  `database_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of company
-- ----------------------------
INSERT INTO `company` VALUES ('26', 'sdfwef', 'lxc_26');

-- ----------------------------
-- Table structure for company_setting
-- ----------------------------
CREATE TABLE `company_setting` (
  `company_id` int(15) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) NOT NULL,
  `registration_no` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `zip_code` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `phone_no` varchar(255) NOT NULL,
  `bill_image` blob NOT NULL,
  `bill_image_type` varchar(255) NOT NULL,
  `bank_detail` varchar(255) NOT NULL,
  `project_code` varchar(255) NOT NULL,
  `Currency` varchar(255) NOT NULL,
  PRIMARY KEY (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of company_setting
-- ----------------------------
INSERT INTO `company_setting` VALUES ('1', 'Softworld Software Sdn Bhd', '1143086-m', 'admin@softworld.com.my', 'First floor, lot 182 section 51, kltd jalan song thian cheok ', 'Kuching ', 'sarawak ', '93100', 'malaysia', '0198899669', '', '../include/upload/companylogo/155539.jpg', 'BANKPREFIX-042017-00003', 'P01', 'MYR');

-- ----------------------------
-- Table structure for currency
-- ----------------------------
CREATE TABLE `currency` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `currency_name` varchar(255) NOT NULL,
  `currency_code` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of currency
-- ----------------------------
INSERT INTO `currency` VALUES ('1', 'United Arab Emirates dirham', 'AED');
INSERT INTO `currency` VALUES ('2', 'Afghani', 'AFN');
INSERT INTO `currency` VALUES ('3', 'Lek', 'ALL');
INSERT INTO `currency` VALUES ('4', 'Armenian Dram', 'AMD');
INSERT INTO `currency` VALUES ('5', 'Netherlands Antillian Guilder', 'ANG');
INSERT INTO `currency` VALUES ('6', 'Kwanza', 'AOA');
INSERT INTO `currency` VALUES ('7', 'Argentine Peso', 'ARS');
INSERT INTO `currency` VALUES ('8', 'Australian Dollar', 'AUD');
INSERT INTO `currency` VALUES ('9', 'Aruban Guilder', 'AWG');
INSERT INTO `currency` VALUES ('10', 'Azerbaijanian Manat', 'AZN');
INSERT INTO `currency` VALUES ('11', 'Convertible Marks', 'BAM');
INSERT INTO `currency` VALUES ('12', 'Barbados Dollar', 'BBD');
INSERT INTO `currency` VALUES ('13', 'Bangladeshi Taka', 'BDT');
INSERT INTO `currency` VALUES ('14', 'Bulgarian Lev', 'BGN');
INSERT INTO `currency` VALUES ('15', 'Bahraini Dinar', 'BHD');
INSERT INTO `currency` VALUES ('16', 'Burundian Franc', 'BIF');
INSERT INTO `currency` VALUES ('17', 'Bermudian Dollar (customarily known as Bermuda Dollar)', 'BMD');
INSERT INTO `currency` VALUES ('18', 'Brunei Dollar', 'BND');
INSERT INTO `currency` VALUES ('19', 'Boliviano', 'BOB');
INSERT INTO `currency` VALUES ('20', 'Bolivian Mvdol (Funds code)', 'BOV');
INSERT INTO `currency` VALUES ('21', 'Brazilian Real', 'BRL');
INSERT INTO `currency` VALUES ('22', 'Bahamian Dollar', 'BSD');
INSERT INTO `currency` VALUES ('23', 'Ngultrum', 'BTN');
INSERT INTO `currency` VALUES ('24', 'Pula', 'BWP');
INSERT INTO `currency` VALUES ('25', 'Belarussian Ruble', 'BYR');
INSERT INTO `currency` VALUES ('26', 'Belize Dollar', 'BZD');
INSERT INTO `currency` VALUES ('27', 'Canadian Dollar', 'CAD');
INSERT INTO `currency` VALUES ('28', 'Franc Congolais', 'CDF');
INSERT INTO `currency` VALUES ('29', 'WIR Euro (complementary currency)', 'CHE');
INSERT INTO `currency` VALUES ('30', 'Swiss Franc', 'CHF');
INSERT INTO `currency` VALUES ('31', 'WIR Franc (complementary currency)', 'CHW');
INSERT INTO `currency` VALUES ('32', 'Unidades de formento (Funds code)', 'CLF');
INSERT INTO `currency` VALUES ('33', 'Chilean Peso', 'CLP');
INSERT INTO `currency` VALUES ('34', 'Yuan Renminbi', 'CNY');
INSERT INTO `currency` VALUES ('35', 'Colombian Peso', 'COP');
INSERT INTO `currency` VALUES ('36', 'Unidad de Valor Real', 'COU');
INSERT INTO `currency` VALUES ('37', 'Costa Rican Colon', 'CRC');
INSERT INTO `currency` VALUES ('38', 'Cuban Peso', 'CUP');
INSERT INTO `currency` VALUES ('39', 'Cape Verde Escudo', 'CVE');
INSERT INTO `currency` VALUES ('40', 'Cyprus Pound', 'CYP');
INSERT INTO `currency` VALUES ('41', 'Czech Koruna', 'CZK');
INSERT INTO `currency` VALUES ('42', 'Djibouti Franc', 'DJF');
INSERT INTO `currency` VALUES ('43', 'Danish Krone', 'DKK');
INSERT INTO `currency` VALUES ('44', 'Dominican Peso', 'DOP');
INSERT INTO `currency` VALUES ('45', 'Algerian Dinar', 'DZD');
INSERT INTO `currency` VALUES ('46', 'Kroon', 'EEK');
INSERT INTO `currency` VALUES ('47', 'Egyptian Pound', 'EGP');
INSERT INTO `currency` VALUES ('48', 'Nakfa', 'ERN');
INSERT INTO `currency` VALUES ('49', 'Ethiopian Birr', 'ETB');
INSERT INTO `currency` VALUES ('50', 'Euro', 'EUR');
INSERT INTO `currency` VALUES ('51', 'Fiji Dollar', 'FJD');
INSERT INTO `currency` VALUES ('52', 'Falkland Islands Pound', 'FKP');
INSERT INTO `currency` VALUES ('53', 'Pound Sterling', 'GBP');
INSERT INTO `currency` VALUES ('54', 'Lari', 'GEL');
INSERT INTO `currency` VALUES ('55', 'Cedi', 'GHS');
INSERT INTO `currency` VALUES ('56', 'Gibraltar pound', 'GIP');
INSERT INTO `currency` VALUES ('57', 'Dalasi', 'GMD');
INSERT INTO `currency` VALUES ('58', 'Guinea Franc', 'GNF');
INSERT INTO `currency` VALUES ('59', 'Quetzal', 'GTQ');
INSERT INTO `currency` VALUES ('60', 'Guyana Dollar', 'GYD');
INSERT INTO `currency` VALUES ('61', 'Hong Kong Dollar', 'HKD');
INSERT INTO `currency` VALUES ('62', 'Lempira', 'HNL');
INSERT INTO `currency` VALUES ('63', 'Croatian Kuna', 'HRK');
INSERT INTO `currency` VALUES ('64', 'Haiti Gourde', 'HTG');
INSERT INTO `currency` VALUES ('65', 'Forint', 'HUF');
INSERT INTO `currency` VALUES ('66', 'Rupiah', 'IDR');
INSERT INTO `currency` VALUES ('67', 'New Israeli Shekel', 'ILS');
INSERT INTO `currency` VALUES ('68', 'Indian Rupee', 'INR');
INSERT INTO `currency` VALUES ('69', 'Iraqi Dinar', 'IQD');
INSERT INTO `currency` VALUES ('70', 'Iranian Rial', 'IRR');
INSERT INTO `currency` VALUES ('71', 'Iceland Krona', 'ISK');
INSERT INTO `currency` VALUES ('72', 'Jamaican Dollar', 'JMD');
INSERT INTO `currency` VALUES ('73', 'Jordanian Dinar', 'JOD');
INSERT INTO `currency` VALUES ('74', 'Japanese yen', 'JPY');
INSERT INTO `currency` VALUES ('75', 'Kenyan Shilling', 'KES');
INSERT INTO `currency` VALUES ('76', 'Som', 'KGS');
INSERT INTO `currency` VALUES ('77', 'Riel', 'KHR');
INSERT INTO `currency` VALUES ('78', 'Comoro Franc', 'KMF');
INSERT INTO `currency` VALUES ('79', 'North Korean Won', 'KPW');
INSERT INTO `currency` VALUES ('80', 'South Korean Won', 'KRW');
INSERT INTO `currency` VALUES ('81', 'Kuwaiti Dinar', 'KWD');
INSERT INTO `currency` VALUES ('82', 'Cayman Islands Dollar', 'KYD');
INSERT INTO `currency` VALUES ('83', 'Tenge', 'KZT');
INSERT INTO `currency` VALUES ('84', 'Kip', 'LAK');
INSERT INTO `currency` VALUES ('85', 'Lebanese Pound', 'LBP');
INSERT INTO `currency` VALUES ('86', 'Sri Lanka Rupee', 'LKR');
INSERT INTO `currency` VALUES ('87', 'Liberian Dollar', 'LRD');
INSERT INTO `currency` VALUES ('88', 'Loti', 'LSL');
INSERT INTO `currency` VALUES ('89', 'Lithuanian Litas', 'LTL');
INSERT INTO `currency` VALUES ('90', 'Latvian Lats', 'LVL');
INSERT INTO `currency` VALUES ('91', 'Libyan Dinar', 'LYD');
INSERT INTO `currency` VALUES ('92', 'Moroccan Dirham', 'MAD');
INSERT INTO `currency` VALUES ('93', 'Moldovan Leu', 'MDL');
INSERT INTO `currency` VALUES ('94', 'Malagasy Ariary', 'MGA');
INSERT INTO `currency` VALUES ('95', 'Denar', 'MKD');
INSERT INTO `currency` VALUES ('96', 'Kyat', 'MMK');
INSERT INTO `currency` VALUES ('97', 'Tugrik', 'MNT');
INSERT INTO `currency` VALUES ('98', 'Pataca', 'MOP');
INSERT INTO `currency` VALUES ('99', 'Ouguiya', 'MRO');
INSERT INTO `currency` VALUES ('100', 'Maltese Lira', 'MTL');
INSERT INTO `currency` VALUES ('101', 'Mauritius Rupee', 'MUR');
INSERT INTO `currency` VALUES ('102', 'Rufiyaa', 'MVR');
INSERT INTO `currency` VALUES ('103', 'Kwacha', 'MWK');
INSERT INTO `currency` VALUES ('104', 'Mexican Peso', 'MXN');
INSERT INTO `currency` VALUES ('105', 'Mexican Unidad de Inversion (UDI) (Funds code)', 'MXV');
INSERT INTO `currency` VALUES ('106', 'Malaysian Ringgit', 'MYR');
INSERT INTO `currency` VALUES ('107', 'Metical', 'MZN');
INSERT INTO `currency` VALUES ('108', 'Namibian Dollar', 'NAD');
INSERT INTO `currency` VALUES ('109', 'Naira', 'NGN');
INSERT INTO `currency` VALUES ('110', 'Cordoba Oro', 'NIO');
INSERT INTO `currency` VALUES ('111', 'Norwegian Krone', 'NOK');
INSERT INTO `currency` VALUES ('112', 'Nepalese Rupee', 'NPR');
INSERT INTO `currency` VALUES ('113', 'New Zealand Dollar', 'NZD');
INSERT INTO `currency` VALUES ('114', 'Rial Omani', 'OMR');
INSERT INTO `currency` VALUES ('115', 'Balboa', 'PAB');
INSERT INTO `currency` VALUES ('116', 'Nuevo Sol', 'PEN');
INSERT INTO `currency` VALUES ('117', 'Kina', 'PGK');
INSERT INTO `currency` VALUES ('118', 'Philippine Peso', 'PHP');
INSERT INTO `currency` VALUES ('119', 'Pakistan Rupee', 'PKR');
INSERT INTO `currency` VALUES ('120', 'Zloty', 'PLN');
INSERT INTO `currency` VALUES ('121', 'Guarani', 'PYG');
INSERT INTO `currency` VALUES ('122', 'Qatari Rial', 'QAR');
INSERT INTO `currency` VALUES ('123', 'Romanian New Leu', 'RON');
INSERT INTO `currency` VALUES ('124', 'Serbian Dinar', 'RSD');
INSERT INTO `currency` VALUES ('125', 'Russian Ruble', 'RUB');
INSERT INTO `currency` VALUES ('126', 'Rwanda Franc', 'RWF');
INSERT INTO `currency` VALUES ('127', 'Saudi Riyal', 'SAR');
INSERT INTO `currency` VALUES ('128', 'Solomon Islands Dollar', 'SBD');
INSERT INTO `currency` VALUES ('129', 'Seychelles Rupee', 'SCR');
INSERT INTO `currency` VALUES ('130', 'Sudanese Pound', 'SDG');
INSERT INTO `currency` VALUES ('131', 'Swedish Krona', 'SEK');
INSERT INTO `currency` VALUES ('132', 'Singapore Dollar', 'SGD');
INSERT INTO `currency` VALUES ('133', 'Saint Helena Pound', 'SHP');
INSERT INTO `currency` VALUES ('134', 'Slovak Koruna', 'SKK');
INSERT INTO `currency` VALUES ('135', 'Leone', 'SLL');
INSERT INTO `currency` VALUES ('136', 'Somali Shilling', 'SOS');
INSERT INTO `currency` VALUES ('137', 'Surinam Dollar', 'SRD');
INSERT INTO `currency` VALUES ('138', 'Dobra', 'STD');
INSERT INTO `currency` VALUES ('139', 'Syrian Pound', 'SYP');
INSERT INTO `currency` VALUES ('140', 'Lilangeni', 'SZL');
INSERT INTO `currency` VALUES ('141', 'Baht', 'THB');
INSERT INTO `currency` VALUES ('142', 'Somoni', 'TJS');
INSERT INTO `currency` VALUES ('143', 'Manat', 'TMM');
INSERT INTO `currency` VALUES ('144', 'Tunisian Dinar', 'TND');
INSERT INTO `currency` VALUES ('145', 'New Turkish Lira', 'TRY');
INSERT INTO `currency` VALUES ('146', 'Trinidad and Tobago Dollar', 'TTD');
INSERT INTO `currency` VALUES ('147', 'New Taiwan Dollar', 'TWD');
INSERT INTO `currency` VALUES ('148', 'Tanzanian Shilling', 'TZS');
INSERT INTO `currency` VALUES ('149', 'Hryvnia', 'UAH');
INSERT INTO `currency` VALUES ('150', 'Uganda Shilling', 'UGX');
INSERT INTO `currency` VALUES ('151', 'US Dollar', 'USD');
INSERT INTO `currency` VALUES ('152', 'Peso Uruguayo', 'UYU');
INSERT INTO `currency` VALUES ('153', 'Uzbekistan Som', 'UZS');
INSERT INTO `currency` VALUES ('154', 'Venezuelan bolívar', 'VEB');
INSERT INTO `currency` VALUES ('155', 'Vietnamese đồng', 'VND');
INSERT INTO `currency` VALUES ('156', 'Vatu', 'VUV');
INSERT INTO `currency` VALUES ('157', 'Samoan Tala', 'WST');
INSERT INTO `currency` VALUES ('158', 'CFA Franc BEAC', 'XAF');
INSERT INTO `currency` VALUES ('159', 'Silver (one Troy ounce)', 'XAG');
INSERT INTO `currency` VALUES ('160', 'Gold (one Troy ounce)', 'XAU');
INSERT INTO `currency` VALUES ('161', 'European Composite Unit (EURCO) (Bonds market unit)', 'XBA');
INSERT INTO `currency` VALUES ('162', 'European Monetary Unit (E.M.U.-6) (Bonds market unit)', 'XBB');
INSERT INTO `currency` VALUES ('163', 'European Unit of Account 9 (E.U.A.-9) (Bonds market unit)', 'XBC');
INSERT INTO `currency` VALUES ('164', 'European Unit of Account 17 (E.U.A.-17) (Bonds market unit)', 'XBD');
INSERT INTO `currency` VALUES ('165', 'East Caribbean Dollar', 'XCD');
INSERT INTO `currency` VALUES ('166', 'Special Drawing Rights', 'XDR');
INSERT INTO `currency` VALUES ('167', 'Gold franc (special settlement currency)', 'XFO');
INSERT INTO `currency` VALUES ('168', 'UIC franc (special settlement currency)', 'XFU');
INSERT INTO `currency` VALUES ('169', 'CFA Franc BCEAO', 'XOF');
INSERT INTO `currency` VALUES ('170', 'Palladium (one Troy ounce)', 'XPD');
INSERT INTO `currency` VALUES ('171', 'CFP franc', 'XPF');
INSERT INTO `currency` VALUES ('172', 'Platinum (one Troy ounce)', 'XPT');
INSERT INTO `currency` VALUES ('173', 'Code reserved for testing purposes', 'XTS');
INSERT INTO `currency` VALUES ('174', 'No currency', 'XXX');
INSERT INTO `currency` VALUES ('175', 'Yemeni Rial', 'YER');
INSERT INTO `currency` VALUES ('176', 'South African Rand', 'ZAR');
INSERT INTO `currency` VALUES ('177', 'Kwacha', 'ZMK');
INSERT INTO `currency` VALUES ('178', 'Zimbabwe Dollar', 'ZWD');

-- ----------------------------
-- Table structure for distance_term
-- ----------------------------
CREATE TABLE `distance_term` (
  `distanceId` int(5) NOT NULL AUTO_INCREMENT,
  `distance_name` varchar(255) NOT NULL,
  `distance_charge` varchar(255) NOT NULL,
  `UserId` int(5) NOT NULL,
  PRIMARY KEY (`distanceId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of distance_term
-- ----------------------------
INSERT INTO `distance_term` VALUES ('1', 'Motocar (KM)', '0.65', '1');
INSERT INTO `distance_term` VALUES ('2', 'Motocycle (KM)', '0.40', '1');

-- ----------------------------
-- Table structure for prefix
-- ----------------------------
CREATE TABLE `prefix` (
  `prefix_id` int(15) NOT NULL AUTO_INCREMENT,
  `prefix` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `running_number` varchar(255) NOT NULL,
  PRIMARY KEY (`prefix_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of prefix
-- ----------------------------
INSERT INTO `prefix` VALUES ('1', 'REPORT', 'Report', 'REPORT', '2213');
INSERT INTO `prefix` VALUES ('2', 'TRAVEL', 'Travel', 'TRAVEL', '745');
INSERT INTO `prefix` VALUES ('3', 'BANKPREFIX', 'BankPrefix', 'BANKPREFIX', '8');
INSERT INTO `prefix` VALUES ('4', 'CATEGORY', 'Category', 'CATEGORY', '6710');

-- ----------------------------
-- Table structure for record
-- ----------------------------
CREATE TABLE `record` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `UserId` int(5) NOT NULL,
  `CategoryId` int(5) NOT NULL,
  `travel_record` varchar(255) DEFAULT NULL,
  `merchant` varchar(255) NOT NULL,
  `remark` varchar(255) NOT NULL,
  `start_date` date DEFAULT NULL,
  `claim_amount` varchar(255) NOT NULL,
  `gst` varchar(255) DEFAULT NULL,
  `total_amount` varchar(255) DEFAULT NULL,
  `claim_report` varchar(255) DEFAULT NULL,
  `bill_image` blob NOT NULL,
  `bill_image_type` varchar(255) NOT NULL,
  `distance` int(5) DEFAULT NULL,
  `docno` varchar(255) NOT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `distance_charge` varchar(255) DEFAULT NULL,
  `hours` varchar(255) DEFAULT NULL,
  `priceperhour` varchar(255) DEFAULT NULL,
  `origin` varchar(255) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `category_no` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of record
-- ----------------------------

-- ----------------------------
-- Table structure for record_traveling
-- ----------------------------
CREATE TABLE `record_traveling` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `UserId` int(5) NOT NULL,
  `CategoryId` int(5) NOT NULL,
  `expense_id` int(15) NOT NULL,
  `merchant` varchar(255) NOT NULL,
  `remark` varchar(255) NOT NULL,
  `start_date` date DEFAULT NULL,
  `claim_amount` varchar(255) NOT NULL,
  `gst` varchar(255) NOT NULL,
  `total_amount` varchar(255) NOT NULL,
  `claim_report` varchar(255) NOT NULL,
  `bill_image` blob NOT NULL,
  `bill_image_type` varchar(255) NOT NULL,
  `distance` int(255) NOT NULL,
  `docno` varchar(255) NOT NULL,
  `tag` varchar(255) NOT NULL,
  `distance_charge` varchar(255) NOT NULL,
  `hours` varchar(255) NOT NULL,
  `priceperhour` varchar(255) NOT NULL,
  `airline` varchar(255) NOT NULL,
  `origin` varchar(255) NOT NULL,
  `destination` varchar(255) NOT NULL,
  `place` varchar(255) NOT NULL,
  `datefrom` date NOT NULL,
  `dateto` date NOT NULL,
  `daily_rate` varchar(255) NOT NULL,
  `num_of_day` varchar(255) NOT NULL,
  `category_no` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of record_traveling
-- ----------------------------

-- ----------------------------
-- Table structure for report
-- ----------------------------
CREATE TABLE `report` (
  `reportid` int(5) NOT NULL AUTO_INCREMENT,
  `reportname` varchar(255) NOT NULL,
  `expense_travel_id` int(15) DEFAULT NULL,
  `report_ref` varchar(255) DEFAULT NULL,
  `travel_record` varchar(255) DEFAULT NULL,
  `UserId` int(5) DEFAULT NULL,
  `CategoryId` int(5) DEFAULT NULL,
  `merchant` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `date_from` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `tax_code` varchar(255) DEFAULT NULL,
  `tax_inclusive` varchar(255) DEFAULT NULL,
  `claim_amount` varchar(255) DEFAULT NULL,
  `gst` varchar(255) DEFAULT NULL,
  `tax_amount` varchar(255) DEFAULT NULL,
  `amt_include_gst` varchar(255) DEFAULT NULL,
  `total_amount` varchar(255) DEFAULT NULL,
  `bill_image` blob DEFAULT NULL,
  `bill_image_type` varchar(255) DEFAULT NULL,
  `place` varchar(225) DEFAULT NULL,
  `airline` varchar(225) DEFAULT NULL,
  `origin` varchar(255) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `distance` int(255) DEFAULT NULL,
  `docno` varchar(255) DEFAULT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `distance_charge` varchar(255) DEFAULT NULL,
  `daily_rate` varchar(225) DEFAULT NULL,
  `num_days` int(15) DEFAULT NULL,
  `email_from` varchar(255) DEFAULT NULL,
  `email_to` varchar(255) DEFAULT NULL,
  `approval_1` int(15) DEFAULT NULL,
  `approval_2` int(15) DEFAULT NULL,
  `approval_3` int(15) DEFAULT NULL,
  `claim_status` varchar(255) DEFAULT NULL,
  `gl_code` varchar(255) DEFAULT NULL,
  `merchant_gst_no` varchar(255) DEFAULT NULL,
  `project_code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`reportid`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of report
-- ----------------------------
INSERT INTO `report` VALUES ('20', 'December Claim 2023', null, 'REPORT-122023-02208', null, '3', '4', 'easy line international sdn bhd', 'upfront payment - 0176036630', '2023-12-21', null, null, null, null, '38.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd39767-CCI21122023_0004.jpg', null, null, null, null, null, '185753', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('21', 'December Claim 2023', null, 'REPORT-122023-02208', null, '3', '6', 'empire sushi & chicken house', 'reimbursement staff meal', '2023-12-21', null, null, null, null, '200.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd9381-CCI21122023_0003.jpg', null, null, null, null, null, '000-382817', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('22', 'December Claim 2023', null, 'REPORT-122023-02208', null, '3', '22', 'upkj', 'renew license upkj', '2023-12-20', null, null, null, null, '50.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd41746-S PAY GLOBAL Online Payment.png', null, null, null, null, null, '20231220905edebcc05a', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('23', 'December Claim 2023', null, 'REPORT-122023-02208', null, '3', '11', 'petronas', 'fuel', '2023-12-16', null, null, null, null, '334.54', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd23193-CCI21122023_0002.jpg', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('24', 'December Claim 2023', null, 'REPORT-122023-02208', null, '3', '29', 'everwin', 'grocery ', '2023-12-03', null, null, null, null, '168.80', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd57812-CCI20122023_0002.jpg', null, null, null, null, null, 'eke2312030041103', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('25', 'December Claim 2023', null, 'REPORT-122023-02208', null, '3', '13', 'Flexxo trading', 'stationeries - office supply', '2023-11-28', null, null, null, null, '67.10', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd35168-CCI20122023.jpg', null, null, null, null, null, 'inv2311/01274', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('26', 'December Claim 2023', null, 'REPORT-122023-02208', null, '3', '11', 'petronas', 'fuel', '2023-11-25', null, null, null, null, '130.05', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd48320-CCI20122023_0001.jpg', null, null, null, null, null, '7efb12', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('27', 'DECEMBER 2023 CLAIM', null, 'REPORT-122023-02209', null, '3', '10', 'Shopee', 'tp-link tk ps11ou usb print', '2023-12-26', null, null, null, null, '172.12', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd79770-WhatsApp Image 2023-12-26 at 18.08.14 (1).jpeg', null, null, null, null, null, '407813895299899', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('28', 'DECEMBER 2023 CLAIM', null, 'REPORT-122023-02209', null, '3', '10', 'shopee', 'a6 thermal printer waybill barcode shipping', '2023-12-26', null, null, null, null, '233.48', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd80053-WhatsApp Image 2023-12-26 at 18.08.14.jpeg', null, null, null, null, null, '407813895099899', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('29', 'DECEMBER 2023 CLAIM', null, 'REPORT-122023-02209', null, '3', '11', 'sia service station', 'fuel', '2023-12-24', null, null, null, null, '93.52', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd67388-CCI27122023.jpg', null, null, null, null, null, '000046670', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('30', 'DECEMBER 2023 CLAIM', null, 'REPORT-122023-02209', null, '3', '29', 'mirrolex solutions ', 'Web page design and development', '2023-12-23', null, null, null, null, '463.45', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd13187-PAID TO SHAHZAIB CONTRACTOR - USD100 - RM483-1.png', null, null, null, null, null, '1g193976ta786134r', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('31', 'JANUARY 2024 CLAIM', null, 'REPORT-012024-02210', null, '3', '4', 'u mobile sdn bhd', 'bil internet january 2024', '2024-01-15', null, null, null, null, '73.35', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd21284-27D82D2F-6F06-43F9-93C7-36565F9A9C87_pages-to-jpg-0001.jpg', null, null, null, null, null, 'inv2024011551510293', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('32', 'JANUARY 2024 CLAIM', null, 'REPORT-012024-02210', null, '3', '29', 'pizza hut restaurants sdn bhd', 'staff audit crowe meal treats', '2024-01-10', null, null, null, null, '47.70', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd81522-CCI10012024_0003.jpg', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('33', 'JANUARY 2024 CLAIM', null, 'REPORT-012024-02210', null, '3', '25', 'shopee', '- sdd kingston\\r\\n- Rfid high label\\r\\n- laser fangefinder\\r\\n- kingston flash driver', '2024-01-10', null, null, null, null, '293.36', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd29941-WhatsApp Image 2024-01-10 at 13.27.53 (1).pdf', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('34', 'JANUARY 2024 CLAIM', null, 'REPORT-012024-02210', null, '3', '29', 'ECO SHOP', 'GROCERY', '2024-01-07', null, null, null, null, '101.40', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd24366-CCI10012024_0001.jpg', null, null, null, null, null, '38440240107145807', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('35', 'JANUARY 2024 CLAIM', null, 'REPORT-012024-02210', null, '3', '29', 'EVERWIN CENTRE SDN BHD', 'GROCERY OFFICE', '2024-01-07', null, null, null, null, '198.70', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd43859-CCI10012024_0002.jpg', null, null, null, null, null, 'EBK/S24008001416', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('36', 'JANUARY 2024 CLAIM', null, 'REPORT-012024-02210', null, '3', '11', 'PETRONAS', 'FUEL', '2024-01-06', null, null, null, null, '211.49', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd86937-CCI10012024.jpg', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('37', 'JANUARY 2024 CLAIM', null, 'REPORT-012024-02210', null, '3', '16', 'pos malaysia berhad', 'agreement yuwang enterprise', '2023-12-27', null, null, null, null, '13.05', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd29722-CCI02012024.jpg', null, null, null, null, null, '458-11421110-3-3324632-2', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('38', 'JANUARY 2024 CLAIMS ', null, 'REPORT-012024-02211', null, '3', '29', 'SHOPEE', 'RACK BOOK', '2024-01-26', null, null, null, null, '312.47', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd64507-312.47.jpeg', null, null, null, null, null, '2610HH', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('39', 'JANUARY 2024 CLAIMS ', null, 'REPORT-012024-02211', null, '3', '29', 'SSUPERDEAL.COM.MY', 'KINGSTON SSD', '2024-01-26', null, null, null, null, '108.85', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd51748-108.85.jpeg', null, null, null, null, null, '23122541WPDUHA', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('40', 'JANUARY 2024 CLAIMS ', null, 'REPORT-012024-02211', null, '3', '29', 'SHOPEE', 'OFFICE CHAIR', '2024-01-26', null, null, null, null, '395.56', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd95378-395.56.jpeg', null, null, null, null, null, '2610HH', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('41', 'JANUARY 2024 CLAIMS ', null, 'REPORT-012024-02211', null, '3', '29', 'SHOPEE ', 'SEATER SOFA', '2024-01-26', null, null, null, null, '597.20', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd54515-597.20.jpeg', null, null, null, null, null, '3730427784737263302', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('42', 'JANUARY 2024 CLAIMS ', null, 'REPORT-012024-02211', null, '3', '29', 'SHOPEE', 'COMPUTER DESK TABLE', '2024-01-26', null, null, null, null, '86.84', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd97565-86.84.jpeg', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('43', 'JANUARY 2024 CLAIMS ', null, 'REPORT-012024-02211', null, '3', '10', 'all it hypermarket sdn bhd', 'SYNOLOGY DS224 + NAS DISKSTATION', '2024-01-25', null, null, null, null, '1473.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd9227-1,473.jpeg', null, null, null, null, null, '240125SA7PBF7F', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('44', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '29', 'nibong tebal enterprise sdn bhd', 'tissue paper roll', '2024-02-16', null, null, null, null, '60.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd30233-', null, null, null, null, null, 'lv165951', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('45', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '11', 'petronas', 'fuel', '2024-02-15', null, null, null, null, '74.20', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd17854-', null, null, null, null, null, '1d4de7', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('46', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '22', 'upkj', 'license upkj renew', '2024-02-09', null, null, null, null, '50.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd61309-UPKJ_page-0001.jpg', null, null, null, null, null, 'ZF202402091225412399', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('47', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '11', 'petronas', 'fuel ', '2024-02-08', null, null, null, null, '123.99', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd52187-CCI09022024_0001.jpg', null, null, null, null, null, 'deb339', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('48', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '6', 'everwin centre snd bhd', 'grocery for staff softworld sdn bhd', '2024-02-06', null, null, null, null, '194.55', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd53383-CCI09022024.jpg', null, null, null, null, null, 'eke2402060032262', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('49', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '14', 'sen heng electric (KL) sdn bhd', 'oven toaster & bread toaster ', '2024-02-05', null, null, null, null, '218.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd56004-35ee7c8e29f2213bda9fadf1e3e3ef72_page-0001.jpg', null, null, null, null, null, 'q51/civ673631', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('50', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '11', 'petronas', 'fuel', '2024-02-02', null, null, null, null, '302.42', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd25290-CCI02022024_0001.jpg', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('51', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '6', 'pizza hut restaurant sdn bhd', 'firewell intern', '2024-02-02', null, null, null, null, '111.20', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd45022-CCI02022024_0004.jpg', null, null, null, null, null, '11011', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('52', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '8', 'coway malaysia', 'WATER PURIFIER rental feb 2024', '2024-02-01', null, null, null, null, '65.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd94558-BR4323591081_merged_page-0006.jpg', null, null, null, null, null, 'br4338843927', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('53', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '4', 'brilliant business referrals sdn bhd', 'international networking week', '2024-01-31', null, null, null, null, '90.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd82627-WhatsApp Image 2024-02-07 at 15.01.56.jpeg', null, null, null, null, null, 'or03034', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('54', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '29', 'bsn', 'deposit active bsn acc softworld software sdn bhd', '2024-01-25', null, null, null, null, '50.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd54537-CCI25012024.jpg', null, null, null, null, null, '013288', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('55', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '25', 'izakaya icom square', 'staff annual dinner', '2024-01-19', null, null, null, null, '802.70', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd64819-CCI02022024_0002.jpg', null, null, null, null, null, '004141034282', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('56', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '11', 'petronas', 'fuel', '2024-01-17', null, null, null, null, '108.08', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd96097-CCI02022024_0002.jpg', null, null, null, null, null, '30797613', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('57', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '8', 'coway malaysia', 'WATER PURIFIER rent jan 24', '2024-01-01', null, null, null, null, '65.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd55451-BR4323591081_merged_page-0005.jpg', null, null, null, null, null, 'br4336436516', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('58', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '8', 'coway malaysia', 'WATER PURIFIER rent dec 23', '2023-12-01', null, null, null, null, '65.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd96615-BR4323591081_merged_page-0004.jpg', null, null, null, null, null, 'br4332704340', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('59', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '8', 'coway malaysia', 'WATER PURIFIER rent nov 23', '2023-11-01', null, null, null, null, '65.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd35335-BR4323591081_merged_page-0003.jpg', null, null, null, null, null, 'br4329988139', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('60', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '8', 'coway malaysia', 'WATER PURIFIER rent oct 23', '2023-10-01', null, null, null, null, '65.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd40798-BR4323591081_merged_page-0002.jpg', null, null, null, null, null, 'br4327277058', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('61', 'FEBRUARY 2024 CLAIM', null, 'REPORT-022024-02212', null, '3', '8', 'coway malaysia', 'water purifier rental sep 2023', '2023-09-01', null, null, null, null, '65.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd54982-BR4323591081_merged_page-0001.jpg', null, null, null, null, null, 'br4323591081', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('62', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '8', 'cuckoo', 'Water Purifier ', '2024-02-26', null, null, null, null, '120.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd16002-', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('63', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '4', 'CELCOM', 'Internet Bill', '2024-02-26', null, null, null, null, '119.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd41644-', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('64', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '4', 'celcom', 'Phone Bill', '2024-02-26', null, null, null, null, '40.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd2669-', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('65', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '5', 'dr zawani animal clinic', 'tabby medical fee', '2024-02-25', null, null, null, null, '596.50', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd61564-', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('66', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '29', 'forda trading sdn bhd', 'food cat', '2024-02-22', null, null, null, null, '89.50', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd40406-', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('67', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '29', 'the animal kingdom', 'food cat', '2024-02-21', null, null, null, null, '34.50', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd97559-', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('68', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '31', 'everwin centre sdn bhd', 'laundry detergant & ETC', '2024-02-20', null, null, null, null, '29.70', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd53301-', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('69', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '31', 'eco shop', 'grocery, spray, tissue & etc', '2024-02-17', null, null, null, null, '68.20', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd12451-', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('70', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '29', 'forda trading', 'food cat', '2024-02-17', null, null, null, null, '67.15', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd99479-', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('71', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '29', 'mr.diy', 'masking tape, screwdriver & Etc', '2024-02-16', null, null, null, null, '67.50', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd43983-', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('72', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '29', 'The animal kingdom sdn bhd', 'HQ01692365', '2024-02-12', null, null, null, null, '97.75', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd65426-', null, null, null, null, null, 'HQ01692365', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('73', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '5', 'animal central veterinary kuching', 'Medical Fee ', '2024-02-11', null, null, null, null, '120.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd37987-', null, null, null, null, null, 'INV44054', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('74', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '29', 'linxpet company', 'Staff Angpao Chinese New Year', '2024-02-09', null, null, null, null, '200', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd68651-', null, null, null, null, null, '', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('75', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '29', 'senheng electric (kl) sdn bhd', 'Table Fan', '2024-02-05', null, null, null, null, '99.00', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd15791-', null, null, null, null, null, 'Q51*Q51/CIV673631', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('76', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '5', 'ANIMAL CENTRAL VETERINARY KUCHING', 'Medical Fee ', '2024-02-01', null, null, null, null, '194.50', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd29054-Animal Central (194.50).jpg', null, null, null, null, null, '42870', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('77', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '29', 'BS SUPERMARKET SDN BDH', 'Masking tape, paint roller & etc ', '2024-01-31', null, null, null, null, '13.80', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd97056-BS supermart (13.80).jpg', null, null, null, null, null, 'S02-2150254', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('78', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '29', 'SK HARDWARE (KUCHING) SDN bHD', 'Fiberglass', '2024-01-28', null, null, null, null, '25.65', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd63659-SK Hardware (25.65).jpg', null, null, null, null, null, 'SKHK11-2137823', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);
INSERT INTO `report` VALUES ('79', 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', null, 'REPORT-032024-02213', null, '3', '29', 'ECO SHOP ', 'Softpack tissue & etc ', '2024-01-28', null, null, null, null, '36.20', null, null, null, null, '', '../include/upload/expenses/Softworld Software Sdn Bhd41901-Eco (36.20).jpg', null, null, null, null, null, '4160240128105736', null, null, null, null, 'raymond@softworld.com.my', null, '3', '2', null, null, null, null, null);

-- ----------------------------
-- Table structure for report_s
-- ----------------------------
CREATE TABLE `report_s` (
  `report_sid` int(5) NOT NULL AUTO_INCREMENT,
  `approval1_id` int(15) DEFAULT NULL,
  `approval2_id` int(15) DEFAULT NULL,
  `approval3_id` int(15) DEFAULT NULL,
  `report_name` varchar(255) DEFAULT NULL,
  `report_ref` varchar(255) DEFAULT NULL,
  `total_claim` varchar(255) DEFAULT NULL,
  `email_from` varchar(255) DEFAULT NULL,
  `email_to` varchar(255) DEFAULT NULL,
  `submit_Date` date DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `export_date` date DEFAULT NULL,
  `approvereject_date` date DEFAULT NULL,
  PRIMARY KEY (`report_sid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of report_s
-- ----------------------------
INSERT INTO `report_s` VALUES ('1', '3', '2', null, 'December Claim 2023', 'REPORT-122023-02208', '988.49', 'raymond@softworld.com.my', null, '2023-12-21', 'APPROVED', null, null);
INSERT INTO `report_s` VALUES ('2', '3', '2', null, 'DECEMBER 2023 CLAIM', 'REPORT-122023-02209', '962.57', 'raymond@softworld.com.my', null, '2023-12-27', 'APPROVED', null, null);
INSERT INTO `report_s` VALUES ('3', '3', '2', null, 'JANUARY 2024 CLAIM', 'REPORT-012024-02210', '939.05', 'raymond@softworld.com.my', null, '2024-01-22', 'APPROVED', null, null);
INSERT INTO `report_s` VALUES ('4', '3', '2', null, 'JANUARY 2024 CLAIMS ', 'REPORT-012024-02211', '2973.92', 'raymond@softworld.com.my', null, '2024-01-26', 'APPROVED', null, null);
INSERT INTO `report_s` VALUES ('5', '3', '2', null, 'FEBRUARY 2024 CLAIM', 'REPORT-022024-02212', '2575.14', 'raymond@softworld.com.my', null, '2024-02-23', 'Pending For Approval', null, null);
INSERT INTO `report_s` VALUES ('6', '3', '2', null, 'FEBRUARY 2024 CLAIM (LINXPET RAYMOND HO)', 'REPORT-032024-02213', '2018.95', 'raymond@softworld.com.my', null, '2024-03-14', 'Pending For Approval', null, null);

-- ----------------------------
-- Table structure for traveling
-- ----------------------------
CREATE TABLE `traveling` (
  `travel_id` int(5) NOT NULL AUTO_INCREMENT,
  `report_ref` varchar(255) NOT NULL,
  `travel_record_id` varchar(255) NOT NULL,
  `travel_title` varchar(255) NOT NULL,
  `travel_mode` varchar(255) NOT NULL,
  `travel_purpose` varchar(255) NOT NULL,
  `from_date` date NOT NULL,
  `to_date` date NOT NULL,
  `time_from` varchar(255) NOT NULL,
  `time_to` varchar(255) NOT NULL,
  `total_claim` varchar(255) NOT NULL,
  PRIMARY KEY (`travel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
