
# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: assigned_contractor_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `assigned_contractor_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `ProvId` int(10) DEFAULT NULL,
  `ProviderName` varchar(255) DEFAULT NULL,
  `ConId` int(10) DEFAULT NULL,
  `ContractorName` varchar(250) DEFAULT NULL,
  `PayRate` decimal(20, 2) DEFAULT NULL,
  `StartDate` date DEFAULT NULL,
  `EndDate` date DEFAULT NULL,
  `ReasonToEnded` varchar(200) DEFAULT NULL,
  `Company` int(10) NOT NULL,
  `CreatedBy` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 48 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: assigned_service_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `assigned_service_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `service_id` int(10) NOT NULL,
  `prov_id` int(10) NOT NULL,
  `company` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 12 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: backup_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `backup_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `Filename` varchar(100) DEFAULT NULL,
  `DateCreated` varchar(100) DEFAULT NULL,
  `CreatedBy` varchar(100) DEFAULT NULL,
  `CompanyName` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 14 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: collection_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `collection_table` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `prov_id` varchar(50) DEFAULT NULL,
  `provider` varchar(250) DEFAULT NULL,
  `type` varchar(50) NOT NULL,
  `contractor` int(10) DEFAULT NULL,
  `coll_period` varchar(20) DEFAULT NULL,
  `service` int(10) DEFAULT NULL,
  `coll_amount` decimal(20, 2) DEFAULT NULL,
  `billing_rate` decimal(20, 2) DEFAULT NULL,
  `billing_amount` decimal(20, 2) DEFAULT NULL,
  `rate` varchar(10) DEFAULT NULL,
  `commission` decimal(20, 2) DEFAULT NULL,
  `profit` decimal(20, 2) DEFAULT NULL,
  `prov_status` varchar(50) DEFAULT NULL,
  `con_status` varchar(100) DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `created_by_id` int(10) DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `company` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 116 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: company_details_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `company_details_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `CompanyName` varchar(200) NOT NULL,
  `TaxID` varchar(100) DEFAULT NULL,
  `Phone` varchar(100) DEFAULT NULL,
  `Email` varchar(250) DEFAULT NULL,
  `Web` varchar(250) DEFAULT NULL,
  `OwnerName` varchar(250) DEFAULT NULL,
  `OwnerPhone` varchar(200) DEFAULT NULL,
  `EstablishDate` date DEFAULT NULL,
  `DateCreated` date DEFAULT NULL,
  `Address` varchar(200) DEFAULT NULL,
  `OtherDetails` varchar(250) DEFAULT NULL,
  `DigitalSignature` mediumblob DEFAULT NULL,
  `Logo` mediumblob DEFAULT NULL,
  `CreatedBy` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `CreatedID` int(10) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 31 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: contractor_invoice_item_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `contractor_invoice_item_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contractor_invoice` int(10) NOT NULL,
  `coll_id` int(10) DEFAULT NULL,
  `client_id` int(10) NOT NULL,
  `coll_period` varchar(50) DEFAULT NULL,
  `service_id` int(10) NOT NULL,
  `collection_amount` decimal(20, 2) NOT NULL,
  `rate` decimal(20, 2) NOT NULL,
  `commission` decimal(20, 2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 31 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: contractor_invoice_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `contractor_invoice_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_no` varchar(50) NOT NULL,
  `invoice_date` date NOT NULL,
  `contractor` int(10) NOT NULL,
  `coll_period` varchar(50) NOT NULL,
  `due_date` date NOT NULL,
  `collection_total` decimal(20, 2) NOT NULL,
  `commission_total` decimal(20, 2) NOT NULL,
  `due` decimal(20, 2) NOT NULL,
  `amount_paid` decimal(20, 2) NOT NULL,
  `remarks` varchar(200) DEFAULT NULL,
  `status` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `is_sent` tinyint(1) NOT NULL,
  `created_by` varchar(200) NOT NULL,
  `created_by_id` int(10) NOT NULL,
  `created_at` date NOT NULL,
  `cancelled_by` varchar(200) DEFAULT NULL,
  `cancelled_by_id` int(10) DEFAULT NULL,
  `cancelled_at` date DEFAULT NULL,
  `company` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 21 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: contractor_payment_item_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `contractor_payment_item_table` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `payment_id` int(10) NOT NULL,
  `invoice_id` int(10) NOT NULL,
  `invoice_date` date NOT NULL,
  `invoice_no` varchar(50) NOT NULL,
  `grand_total` decimal(20, 2) NOT NULL,
  `due` decimal(20, 2) NOT NULL,
  `amount_paid` decimal(20, 2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 24 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: contractor_payment_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `contractor_payment_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_no` varchar(50) NOT NULL,
  `paid_date` date NOT NULL,
  `contractor` int(10) NOT NULL,
  `payment_method` varchar(50) NOT NULL,
  `payment_ref_no` varchar(100) DEFAULT NULL,
  `paid_total` decimal(20, 2) NOT NULL,
  `status` varchar(20) NOT NULL,
  `created_by` varchar(100) NOT NULL,
  `created_by_id` int(10) NOT NULL,
  `created_at` date NOT NULL,
  `cancelled_by` varchar(100) DEFAULT NULL,
  `cancelled_by_id` int(10) DEFAULT NULL,
  `cancelled_at` date DEFAULT NULL,
  `company` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 16 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: customer_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `customer_table` (
  `Id` int(10) NOT NULL AUTO_INCREMENT,
  `CusId` varchar(20) NOT NULL,
  `CusName` varchar(50) NOT NULL,
  `Phone` varchar(100) DEFAULT NULL,
  `Email` varchar(100) DEFAULT NULL,
  `Address` varchar(250) DEFAULT NULL,
  `GroupName` varchar(250) DEFAULT NULL,
  `StartDate` date DEFAULT NULL,
  `EndDate` date DEFAULT NULL,
  `BillingRate` decimal(20, 2) DEFAULT NULL,
  `InvoiceSchedule` varchar(20) DEFAULT NULL,
  `Status` tinyint(1) NOT NULL,
  `CreatedBy` varchar(50) NOT NULL,
  `Company` int(10) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 215 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: file_upload_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `file_upload_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `ProfileName` varchar(255) DEFAULT NULL,
  `FileName` varchar(250) DEFAULT NULL,
  `Description` varchar(250) DEFAULT NULL,
  `AttachedDate` date DEFAULT NULL,
  `IsShared` varchar(20) DEFAULT NULL,
  `CreatedBy` varchar(100) DEFAULT NULL,
  `Company` int(10) DEFAULT NULL,
  `CreatedID` int(10) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 43 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: invoice_scheduler_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `invoice_scheduler_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `coll_period` varchar(50) NOT NULL,
  `source` varchar(50) NOT NULL,
  `qty` int(11) NOT NULL,
  `status` varchar(50) NOT NULL,
  `created_by` varchar(50) NOT NULL,
  `created_by_id` int(10) NOT NULL,
  `created_at` date NOT NULL,
  `company` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 6 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: provider_invoice_item_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `provider_invoice_item_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `provider_invoice` int(10) NOT NULL,
  `coll_id` int(10) DEFAULT NULL,
  `item` int(10) NOT NULL,
  `collection_amount` decimal(20, 2) NOT NULL,
  `billing_rate` decimal(20, 2) NOT NULL,
  `billing_amount` decimal(20, 2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 30 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: provider_invoice_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `provider_invoice_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_no` varchar(50) NOT NULL,
  `invoice_date` date NOT NULL,
  `customer` varchar(200) NOT NULL,
  `time_period` varchar(50) NOT NULL,
  `due_date` date NOT NULL,
  `collection_total` decimal(20, 2) NOT NULL,
  `billing_total` decimal(20, 2) NOT NULL,
  `due` decimal(20, 2) NOT NULL,
  `amount_paid` decimal(20, 2) NOT NULL,
  `remarks` varchar(200) DEFAULT NULL,
  `status` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `is_sent` tinyint(1) NOT NULL,
  `is_invoiced` tinyint(1) NOT NULL,
  `created_by` varchar(200) NOT NULL,
  `created_by_id` int(10) NOT NULL,
  `created_at` date NOT NULL,
  `cancelled_by` varchar(200) DEFAULT NULL,
  `cancelled_by_id` int(10) DEFAULT NULL,
  `cancelled_at` date DEFAULT NULL,
  `company` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 24 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: provider_receipt_item_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `provider_receipt_item_table` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `receipt_id` int(10) NOT NULL,
  `invoice_id` int(10) NOT NULL,
  `invoice_date` date NOT NULL,
  `invoice_no` varchar(50) NOT NULL,
  `grand_total` decimal(20, 2) NOT NULL,
  `due` decimal(20, 2) NOT NULL,
  `amount_paid` decimal(20, 2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 20 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: provider_receipt_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `provider_receipt_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `receipt_no` varchar(50) NOT NULL,
  `paid_date` date NOT NULL,
  `prov_id` int(10) NOT NULL,
  `payment_method` varchar(50) NOT NULL,
  `payment_ref_no` varchar(100) DEFAULT NULL,
  `paid_total` decimal(20, 2) NOT NULL,
  `status` varchar(20) NOT NULL,
  `created_by` varchar(100) NOT NULL,
  `created_by_id` int(10) NOT NULL,
  `created_at` date NOT NULL,
  `cancelled_by` varchar(100) DEFAULT NULL,
  `cancelled_by_id` int(10) DEFAULT NULL,
  `cancelled_at` date DEFAULT NULL,
  `company` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 12 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: provider_service_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `provider_service_table` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `created_by` varchar(200) NOT NULL,
  `created_at` datetime NOT NULL,
  `company` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 10 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: settings_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `settings_table` (
  `Id` int(10) NOT NULL AUTO_INCREMENT,
  `RefId` varchar(20) NOT NULL,
  `RefName` varchar(200) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 7 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: shared_document_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `shared_document_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `FileName` varchar(255) DEFAULT NULL,
  `Description` varchar(250) DEFAULT NULL,
  `SharedOn` date DEFAULT NULL,
  `SharedBy` varchar(100) DEFAULT NULL,
  `SharedTo` varchar(100) DEFAULT NULL,
  `Company` int(10) DEFAULT NULL,
  `SharedById` int(10) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 32 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: task_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `task_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `EmpId` int(10) DEFAULT NULL,
  `EmpName` varchar(250) NOT NULL,
  `Type` varchar(100) NOT NULL,
  `Title` varchar(250) NOT NULL,
  `Description` varchar(250) NOT NULL,
  `DueDate` date NOT NULL,
  `Status` varchar(50) NOT NULL,
  `CreatedBy` varchar(50) NOT NULL,
  `Company` int(10) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 22 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: assigned_contractor_table
# ------------------------------------------------------------

INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `Company`,
    `CreatedBy`
  )
VALUES
  (
    21,
    0,
    'Ronald Jefferson',
    0,
    'Banuka perera',
    3.00,
    '2021-05-30',
    '2021-05-31',
    '',
    0,
    'admin'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `Company`,
    `CreatedBy`
  )
VALUES
  (
    22,
    0,
    'Ronald Jefferson',
    0,
    'Fahad Razzaq',
    4.00,
    '2021-06-10',
    NULL,
    '',
    0,
    'admin'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `Company`,
    `CreatedBy`
  )
VALUES
  (
    23,
    0,
    'Asela Gunarathne',
    0,
    'Nalaka Bandara',
    5.00,
    '2021-06-15',
    NULL,
    '',
    0,
    'admin'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `Company`,
    `CreatedBy`
  )
VALUES
  (
    24,
    0,
    'Ronald Jefferson',
    0,
    'Sajith Wickramasena',
    5.00,
    '2021-07-13',
    NULL,
    '',
    0,
    'admin'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `Company`,
    `CreatedBy`
  )
VALUES
  (
    25,
    205,
    'sas',
    23,
    'Sajith Wickramasena',
    10.00,
    '2023-12-27',
    '2023-12-30',
    'Contractors Contract Ended',
    21,
    'Sajith Wickramasena'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `Company`,
    `CreatedBy`
  )
VALUES
  (
    26,
    206,
    'Lamal',
    24,
    'Anura Kumara',
    4.00,
    '2023-12-27',
    NULL,
    '',
    21,
    'Sajith Wickramasena'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `Company`,
    `CreatedBy`
  )
VALUES
  (
    27,
    207,
    'Kumara',
    24,
    'Anura Kumara',
    10.00,
    '2023-12-25',
    NULL,
    '',
    21,
    'Sajith Wickramasena'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `Company`,
    `CreatedBy`
  )
VALUES
  (
    28,
    208,
    'Amila Perera',
    24,
    'Anura Kumara',
    10.00,
    '2023-12-27',
    NULL,
    '',
    21,
    'Sajith Wickramasena'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `Company`,
    `CreatedBy`
  )
VALUES
  (
    29,
    208,
    'Amila Perera',
    23,
    'Sajith Wickramasena',
    5.00,
    '2023-12-26',
    NULL,
    '',
    21,
    'Sajith Wickramasena'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `Company`,
    `CreatedBy`
  )
VALUES
  (
    33,
    198,
    'Provider 01',
    24,
    'Anura Kumara',
    3.00,
    '2024-01-01',
    '2024-01-31',
    NULL,
    21,
    'Sajith Wickramasena'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `Company`,
    `CreatedBy`
  )
VALUES
  (
    34,
    212,
    'sass',
    27,
    'Banuka perera',
    3.00,
    '2024-01-24',
    NULL,
    '',
    23,
    'Sajith Wickramasena'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `Company`,
    `CreatedBy`
  )
VALUES
  (
    35,
    213,
    'Provider 03',
    27,
    'Banuka perera',
    3.00,
    '2024-01-30',
    '2024-02-28',
    'agreement',
    23,
    'Sajith Wickramasena'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `Company`,
    `CreatedBy`
  )
VALUES
  (
    45,
    214,
    'Prov 04',
    27,
    'Banuka perera',
    3.00,
    '0000-00-00',
    '0000-00-00',
    'aggree',
    23,
    'Sajith Wickramasena'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `Company`,
    `CreatedBy`
  )
VALUES
  (
    46,
    159,
    'SAJITH WICKRAMSENA ',
    24,
    'Anura Kumara',
    3.00,
    '0000-00-00',
    '0000-00-00',
    NULL,
    21,
    'Sajith Wickramasena'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `Company`,
    `CreatedBy`
  )
VALUES
  (
    47,
    159,
    'SAJITH WICKRAMSENA ',
    35,
    'Lasitha',
    2.00,
    '0000-00-00',
    '0000-00-00',
    NULL,
    21,
    'Sajith Wickramasena'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: assigned_service_table
# ------------------------------------------------------------

INSERT INTO
  `assigned_service_table` (`id`, `service_id`, `prov_id`, `company`)
VALUES
  (1, 4, 212, 23);
INSERT INTO
  `assigned_service_table` (`id`, `service_id`, `prov_id`, `company`)
VALUES
  (2, 4, 213, 23);
INSERT INTO
  `assigned_service_table` (`id`, `service_id`, `prov_id`, `company`)
VALUES
  (9, 4, 214, 23);
INSERT INTO
  `assigned_service_table` (`id`, `service_id`, `prov_id`, `company`)
VALUES
  (10, 7, 159, 21);
INSERT INTO
  `assigned_service_table` (`id`, `service_id`, `prov_id`, `company`)
VALUES
  (11, 8, 159, 21);

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: backup_table
# ------------------------------------------------------------

INSERT INTO
  `backup_table` (
    `Id`,
    `Filename`,
    `DateCreated`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    10,
    '2021-07-18-backup.sql',
    '07/18/2021 11:31:01 PM',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `backup_table` (
    `Id`,
    `Filename`,
    `DateCreated`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    11,
    '2021-07-19-backup.sql',
    '07/19/2021 10:28:54 PM',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `backup_table` (
    `Id`,
    `Filename`,
    `DateCreated`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    12,
    '2021-07-20-backup.sql',
    '07/20/2021 9:54:59 PM',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `backup_table` (
    `Id`,
    `Filename`,
    `DateCreated`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    13,
    '2021-07-25-backup.sql',
    '07/25/2021 10:14:43 PM',
    'admin',
    'ABC COMPANY PVT LTD'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: collection_table
# ------------------------------------------------------------

INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    74,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    35,
    '2023-11',
    8,
    150000.00,
    10.00,
    15000.00,
    '2.00',
    3000.00,
    12000.00,
    'INVOICED',
    'INVOICED',
    'Sajith Wickramasena',
    1,
    '2023-12-30',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    75,
    '206',
    'Lamal',
    '',
    24,
    '2023-12',
    7,
    20000.00,
    10.00,
    2000.00,
    '4.00',
    800.00,
    1200.00,
    'INVOICED',
    'INVOICED',
    'Sajith Wickramasena',
    1,
    '2023-12-30',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    76,
    '208',
    'Amila Perera',
    '',
    24,
    '2023-12',
    7,
    15000.00,
    10.00,
    1500.00,
    '10.00',
    1500.00,
    0.00,
    'INVOICED',
    'INVOICED',
    'Sajith Wickramasena',
    1,
    '2023-12-30',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    77,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    24,
    '2023-12',
    7,
    25000.00,
    10.00,
    2500.00,
    '3.00',
    750.00,
    1750.00,
    'INVOICED',
    'INVOICED',
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    78,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    35,
    '2023-10',
    7,
    40000.00,
    10.00,
    4000.00,
    '2.00',
    800.00,
    3200.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    79,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    35,
    '2023-10',
    7,
    65000.00,
    10.00,
    6500.00,
    '2.00',
    1300.00,
    5200.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    80,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    35,
    '2023-12',
    7,
    140000.00,
    10.00,
    14000.00,
    '2.00',
    2800.00,
    11200.00,
    'INVOICED',
    'INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    81,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    35,
    '2023-12',
    8,
    50000.00,
    10.00,
    5000.00,
    '2.00',
    1000.00,
    4000.00,
    'INVOICED',
    'INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    82,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    35,
    '2023-11',
    7,
    100000.00,
    10.00,
    10000.00,
    '2.00',
    2000.00,
    8000.00,
    'NOT INVOICED',
    'INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    83,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    24,
    '2024-01',
    7,
    500000.00,
    10.00,
    50000.00,
    '3.00',
    15000.00,
    35000.00,
    'INVOICED',
    'INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-02',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    84,
    '208',
    'Amila Perera',
    '',
    24,
    '2024-01',
    8,
    25000.00,
    10.00,
    2500.00,
    '10.00',
    2500.00,
    0.00,
    'INVOICED',
    'INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-02',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    85,
    NULL,
    NULL,
    '',
    NULL,
    '2024-02',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-06',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    86,
    '208',
    'Amila Perera',
    '',
    24,
    '2023-12',
    7,
    50000.00,
    10.00,
    5000.00,
    '10.00',
    5000.00,
    0.00,
    'INVOICED',
    'INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-06',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    87,
    '198',
    'Provider 01',
    '',
    24,
    '2024-01',
    7,
    20000.00,
    6.00,
    1200.00,
    '3.00',
    600.00,
    600.00,
    'INVOICED',
    'INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-06',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    88,
    '208',
    'Amila Perera',
    '',
    24,
    '2024-01',
    8,
    30000.00,
    10.00,
    3000.00,
    '10.00',
    3000.00,
    0.00,
    'INVOICED',
    'INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-06',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    89,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    24,
    '2024-01',
    7,
    45000.00,
    10.00,
    4500.00,
    '3.00',
    1350.00,
    3150.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-11',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    90,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    24,
    '2024-01',
    7,
    50000.00,
    10.00,
    5000.00,
    '3.00',
    1500.00,
    3500.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-12',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    91,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    24,
    '2023-12',
    8,
    45000.00,
    10.00,
    4500.00,
    '3.00',
    1350.00,
    3150.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-12',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    92,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    24,
    '2024-01',
    7,
    15000.00,
    10.00,
    1500.00,
    '3.00',
    450.00,
    1050.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-12',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    93,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    24,
    '2024-01',
    7,
    5000.00,
    10.00,
    500.00,
    '3.00',
    150.00,
    350.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-12',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    94,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    35,
    '2024-01',
    7,
    10000.00,
    10.00,
    1000.00,
    '2.00',
    200.00,
    800.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-12',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    95,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    35,
    '2024-01',
    7,
    12500.00,
    10.00,
    1250.00,
    '2.00',
    250.00,
    1000.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-12',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    96,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    24,
    '2024-01',
    7,
    5000.00,
    10.00,
    500.00,
    '3.00',
    150.00,
    350.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-12',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    97,
    '159',
    'SAJITH WICKRAMSENA ',
    '',
    24,
    '2024-01',
    7,
    5000.00,
    10.00,
    500.00,
    '3.00',
    150.00,
    350.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-12',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    98,
    '159',
    'SAJITH WICKRAMSENA ',
    'Fixed',
    NULL,
    '2024-01',
    7,
    5000.00,
    0.00,
    5000.00,
    '0',
    0.00,
    5000.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-12',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    99,
    '159',
    'SAJITH WICKRAMSENA ',
    'Fixed',
    NULL,
    '2024-01',
    7,
    125000.00,
    0.00,
    125000.00,
    '0',
    0.00,
    125000.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-12',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    100,
    '159',
    'SAJITH WICKRAMSENA ',
    'Normal',
    24,
    '2024-01',
    7,
    8000.00,
    10.00,
    800.00,
    '3.00',
    240.00,
    560.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-12',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    101,
    '159',
    'SAJITH WICKRAMSENA ',
    'Fixed',
    NULL,
    '2024-01',
    8,
    5000.00,
    0.00,
    5000.00,
    '0',
    0.00,
    5000.00,
    'NOT INVOICED',
    'N/A',
    'Sajith Wickramasena',
    1,
    '2024-01-12',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    102,
    '159',
    'SAJITH WICKRAMSENA ',
    'Normal',
    24,
    '2024-01',
    7,
    4000.00,
    10.00,
    400.00,
    '3.00',
    120.00,
    280.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-12',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    103,
    '159',
    'SAJITH WICKRAMSENA ',
    'Fixed',
    NULL,
    '2024-01',
    7,
    5200.00,
    0.00,
    5200.00,
    '0',
    0.00,
    5200.00,
    'NOT INVOICED',
    NULL,
    'Sajith Wickramasena',
    1,
    '2024-01-12',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    104,
    '159',
    'SAJITH WICKRAMSENA ',
    'Fixed',
    NULL,
    '2024-01',
    7,
    0.00,
    0.00,
    5000.00,
    '0',
    0.00,
    5000.00,
    'NOT INVOICED',
    NULL,
    'Sajith Wickramasena',
    1,
    '2024-01-13',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    105,
    '159',
    'SAJITH WICKRAMSENA ',
    'Normal',
    24,
    '2024-01',
    7,
    50000.00,
    10.00,
    5000.00,
    '3.00',
    1500.00,
    3500.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-13',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    106,
    '159',
    'SAJITH WICKRAMSENA ',
    'Normal',
    NULL,
    '2024-01',
    7,
    5000.00,
    10.00,
    500.00,
    '0',
    0.00,
    0.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-19',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    107,
    '159',
    'SAJITH WICKRAMSENA ',
    'Normal',
    NULL,
    '2024-01',
    7,
    5000.00,
    10.00,
    500.00,
    NULL,
    0.00,
    500.00,
    'NOT INVOICED',
    NULL,
    'Sajith Wickramasena',
    1,
    '2024-01-19',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    108,
    '159',
    'SAJITH WICKRAMSENA ',
    'Normal',
    24,
    '2024-01',
    8,
    150000.00,
    10.00,
    15000.00,
    '3.00',
    4500.00,
    10500.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-01-19',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    109,
    '159',
    'SAJITH WICKRAMSENA ',
    'Normal',
    24,
    '2024-01',
    7,
    5000.00,
    10.00,
    500.00,
    '3.00',
    150.00,
    350.00,
    'NOT INVOICED',
    NULL,
    'Sajith Wickramasena',
    1,
    '2024-01-31',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    110,
    '159',
    'SAJITH WICKRAMSENA ',
    'Normal',
    24,
    '2024-01',
    8,
    5000.00,
    10.00,
    500.00,
    '3.00',
    150.00,
    350.00,
    'NOT INVOICED',
    NULL,
    'Sajith Wickramasena',
    1,
    '2024-01-31',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    111,
    '159',
    'SAJITH WICKRAMSENA ',
    'Normal',
    35,
    '2024-01',
    7,
    12500.00,
    10.00,
    1250.00,
    '2.00',
    250.00,
    1000.00,
    'NOT INVOICED',
    NULL,
    'Sajith Wickramasena',
    1,
    '2024-01-31',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    112,
    '159',
    'SAJITH WICKRAMSENA ',
    'Fixed',
    NULL,
    '2024-01',
    8,
    0.00,
    0.00,
    5000.00,
    '0',
    0.00,
    5000.00,
    'NOT INVOICED',
    NULL,
    'Sajith Wickramasena',
    1,
    '2024-01-31',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    113,
    '159',
    'SAJITH WICKRAMSENA ',
    'Normal',
    24,
    '2024-02',
    7,
    5000.00,
    10.00,
    500.00,
    '3.00',
    150.00,
    350.00,
    'NOT INVOICED',
    NULL,
    'Sajith Wickramasena',
    1,
    '2024-02-24',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    114,
    '159',
    'SAJITH WICKRAMSENA ',
    'Normal',
    24,
    '2024-02',
    8,
    2500.00,
    10.00,
    250.00,
    '3.00',
    75.00,
    175.00,
    'NOT INVOICED',
    NULL,
    'Sajith Wickramasena',
    1,
    '2024-02-24',
    21
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    115,
    '159',
    'SAJITH WICKRAMSENA ',
    'Normal',
    24,
    '2024-02',
    8,
    1000.00,
    10.00,
    100.00,
    '3.00',
    30.00,
    70.00,
    'NOT INVOICED',
    'NOT INVOICED',
    'Sajith Wickramasena',
    1,
    '2024-02-24',
    21
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: company_details_table
# ------------------------------------------------------------

INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`,
    `CreatedID`
  )
VALUES
  (
    21,
    'ABC COMPANY PVT LTD',
    '7677',
    '3232 6565',
    'sajithfeat145@gmail.com',
    'maritimelk.com',
    'ssasa',
    '+94713155665',
    '2021-01-08',
    '2021-01-13',
    'No.234\r\nVictoria Road\r\nColombo',
    'rrrrrr',
    NULL,
    NOFORMAT_WRAP(
      "##X'[BLOB]'##"
    ),
    '',
    0
  );
INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`,
    `CreatedID`
  )
VALUES
  (
    22,
    'RapidGnix',
    '',
    '212',
    NULL,
    NULL,
    'sajith',
    NULL,
    '2021-01-14',
    '2021-01-20',
    NULL,
    NULL,
    NULL,
    NOFORMAT_WRAP(
      "##X'[BLOB]'##"
    ),
    '',
    0
  );
INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`,
    `CreatedID`
  )
VALUES
  (
    23,
    'Novar Flex Pvt Ltd',
    '2333',
    '09477654345',
    'infor@novarflex.com',
    'novarflex.com',
    'Sajith',
    NULL,
    '0000-00-00',
    '0000-00-00',
    NULL,
    NULL,
    NULL,
    NULL,
    '',
    0
  );
INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`,
    `CreatedID`
  )
VALUES
  (
    26,
    'wwww',
    '11122333',
    '3444',
    'ffff@gmail.com',
    'dsdsd.com',
    'ddddd',
    '3222',
    '2023-11-07',
    '2023-11-29',
    'colombo',
    'bank',
    NULL,
    NOFORMAT_WRAP(
      "##X'[BLOB]