[BLOB]'##"
    ),
    'Sajith Wickramasena',
    1
  );
INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`,
    `CreatedID`
  )
VALUES
  (
    29,
    'sasass',
    'sas',
    'sasa',
    'sasasa@gmail.com',
    '',
    '',
    '',
    '0000-00-00',
    '2023-11-29',
    'sasas',
    '',
    NULL,
    NOFORMAT_WRAP(
      "##X'[BLOB]'##"
    ),
    'Sajith Wickramasena',
    1
  );
INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`,
    `CreatedID`
  )
VALUES
  (
    30,
    'xxssd',
    'dsd',
    '23322',
    'dsdsd@gmail.com',
    '',
    '',
    '',
    '0000-00-00',
    '2023-11-29',
    'dsdsd',
    '',
    NULL,
    NULL,
    'Sajith Wickramasena',
    1
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: contractor_invoice_item_table
# ------------------------------------------------------------

INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (18, 15, 74, 159, '2023-11', 8, 150000.00, 2.00, 3000.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (19, 16, 76, 208, '2023-12', 7, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (20, 16, 77, 159, '2023-12', 7, 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (21, 17, 82, 159, 'Nov 2023', 7, 100000.00, 2.00, 2000.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (22, 18, 80, 159, '2023-12', 7, 140000.00, 2.00, 2800.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (23, 18, 81, 159, '2023-12', 8, 50000.00, 2.00, 1000.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (24, 19, 76, 208, '2023-12', 7, 15000.00, 10.00, 1500.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (25, 19, 77, 159, '2023-12', 7, 25000.00, 3.00, 750.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (26, 19, 86, 208, '2023-12', 7, 50000.00, 10.00, 5000.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (27, 20, 83, 159, '2024-01', 7, 500000.00, 3.00, 15000.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (28, 20, 84, 208, '2024-01', 8, 25000.00, 10.00, 2500.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (29, 20, 87, 198, '2024-01', 7, 20000.00, 3.00, 600.00);
INSERT INTO
  `contractor_invoice_item_table` (
    `id`,
    `contractor_invoice`,
    `coll_id`,
    `client_id`,
    `coll_period`,
    `service_id`,
    `collection_amount`,
    `rate`,
    `commission`
  )
VALUES
  (30, 20, 88, 208, '2024-01', 8, 30000.00, 10.00, 3000.00);

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: contractor_invoice_table
# ------------------------------------------------------------

INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    15,
    'CIN000001',
    '2024-01-01',
    35,
    '2023-11',
    '2024-01-31',
    150000.00,
    3000.00,
    0.00,
    3000.00,
    NULL,
    'PAID',
    'Manual',
    0,
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    16,
    'CIN000002',
    '2024-01-01',
    24,
    '2023-12',
    '2024-01-31',
    0.00,
    0.00,
    0.00,
    0.00,
    NULL,
    'CANCELLED',
    'Manual',
    0,
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    21
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    17,
    'CIN000003',
    '2024-01-02',
    35,
    '2023-11',
    '2024-01-23',
    100000.00,
    2000.00,
    2000.00,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    0,
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    18,
    'CIN000004',
    '2024-01-03',
    35,
    '2023-12',
    '2024-01-31',
    190000.00,
    3800.00,
    3800.00,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    0,
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    19,
    'CIN000005',
    '2024-01-01',
    24,
    '2023-12',
    '2024-01-15',
    90000.00,
    7250.00,
    7250.00,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    'Sajith Wickramasena',
    1,
    '2024-01-06',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `contractor_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `contractor`,
    `coll_period`,
    `due_date`,
    `collection_total`,
    `commission_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    20,
    'CIN000006',
    '2024-01-08',
    24,
    '2024-01',
    '2024-01-22',
    575000.00,
    21100.00,
    21100.00,
    0.00,
    '',
    'UNPAID',
    'Auto',
    1,
    'Sajith Wickramasena',
    1,
    '2024-01-08',
    NULL,
    NULL,
    NULL,
    21
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: contractor_payment_item_table
# ------------------------------------------------------------

INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    20,
    12,
    15,
    '2024-01-01',
    'CIN000001',
    3000.00,
    3000.00,
    3000.00
  );
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (21, 13, 17, '2024-01-02', 'CIN000003', 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (22, 14, 18, '2024-01-03', 'CIN000004', 0.00, 0.00, 0.00);
INSERT INTO
  `contractor_payment_item_table` (
    `id`,
    `payment_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (23, 15, 18, '2024-01-03', 'CIN000004', 0.00, 0.00, 0.00);

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: contractor_payment_table
# ------------------------------------------------------------

INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    12,
    'CRE000001',
    '2024-01-01',
    35,
    'Card Payment',
    '2525',
    3000.00,
    'POSTED',
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    13,
    'CRE000002',
    '2024-01-01',
    35,
    'Cheque',
    '2555',
    0.00,
    'CANCELLED',
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    21
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    14,
    'CRE000003',
    '2024-01-01',
    35,
    'Cheque',
    '25452',
    0.00,
    'CANCELLED',
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    21
  );
INSERT INTO
  `contractor_payment_table` (
    `id`,
    `payment_no`,
    `paid_date`,
    `contractor`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    15,
    'CRE000004',
    '2024-01-01',
    35,
    'Cheque',
    '456321',
    0.00,
    'CANCELLED',
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    21
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: customer_table
# ------------------------------------------------------------

INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    159,
    'CUS000034',
    'SAJITH WICKRAMSENA ',
    '555566776',
    'sajith.wickramasena@gmail.com',
    'Nugegoda',
    ' 544545454545      ',
    '2020-12-24',
    '2023-12-27',
    10.00,
    '1st_15th',
    1,
    'admin',
    21
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    174,
    'CUS000044',
    'ANURA PERERA ',
    'asassasasas',
    'sajithfeat145@gmail.com',
    'No 14\nMal Mawatha\nColombo 05',
    ' 544545454545      ',
    '1899-11-30',
    '2023-12-30',
    15.00,
    NULL,
    1,
    'admin',
    21
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    175,
    'CUS000045',
    'ewew',
    'ewe',
    'eww@gmail.com',
    'wqwq',
    NULL,
    '2020-12-23',
    NULL,
    NULL,
    NULL,
    1,
    'admin',
    22
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    181,
    'CUS000051',
    'Kasun Devappriya',
    '3232',
    'kasun@gmail.com',
    'colombo',
    'bbb',
    '2020-12-24',
    NULL,
    NULL,
    NULL,
    0,
    'admin',
    22
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    182,
    'CUS000052',
    'nnnnnn',
    '21212',
    'sa@gmial.com',
    'wqwq',
    'wqw',
    '2021-01-22',
    NULL,
    NULL,
    NULL,
    0,
    'admin',
    23
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    194,
    'CUS000064',
    'Dr. Gilbert C',
    '7136531616',
    '154818186@gmail.com',
    '203 N COLLEGE #1001',
    'none',
    '2020-12-31',
    '2023-12-29',
    5.00,
    '1st_15th',
    1,
    'admin',
    21
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    195,
    'CUS000065',
    'Ronald Jefferson',
    '7136531616',
    '545489@gmail.com',
    '203 N COLLEGE #1001',
    '',
    '2021-01-01',
    NULL,
    NULL,
    NULL,
    0,
    'admin',
    21
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    198,
    'PRO000066',
    'Provider 01',
    '1254',
    'prov1@gmail.com',
    'Kandy',
    'Prov GR 1',
    '2023-12-05',
    '2023-12-30',
    6.00,
    '15th_1st',
    1,
    'Sajith Wickramasena',
    21
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    199,
    'PRO000067',
    'dsdsd',
    'dsd',
    'dsdsd@gmail.com',
    'dds',
    'sds',
    '2023-12-05',
    '2023-12-05',
    10.00,
    '1st_15th',
    1,
    'Sajith Wickramasena',
    21
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    205,
    'PRO000068',
    'sas',
    '212',
    'sasa@gmail.com',
    'kandy',
    'gr1',
    '2023-12-05',
    '2023-12-13',
    5.00,
    '1st_15th',
    1,
    'Sajith Wickramasena',
    21
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    206,
    'PRO000069',
    'Lamal',
    '12522',
    'lamal@gmail.com',
    'Colombo',
    'GR2',
    '2023-12-05',
    '2023-12-27',
    10.00,
    '1st_15th',
    1,
    'Sajith Wickramasena',
    21
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    207,
    'PRO000070',
    'Kumara',
    '741',
    'kumara@gmail.com',
    'Kandy',
    'GR45',
    '2023-12-05',
    '2023-12-05',
    20.00,
    '1st_15th',
    1,
    'Sajith Wickramasena',
    21
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    208,
    'PRO000071',
    'Amila Perera',
    '1778585885',
    'amila@gmail.com',
    'Kanthale',
    'GR2',
    '2023-12-05',
    '2023-12-20',
    10.00,
    '1st_15th',
    1,
    'Sajith Wickramasena',
    21
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    209,
    'PRO000072',
    'sdsdsd',
    'dsds',
    'dsdsd@gmail.com',
    'sasa',
    'wwq',
    '2024-01-09',
    NULL,
    12.00,
    '1st_15th',
    1,
    'Sajith Wickramasena',
    23
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    212,
    'PRO000073',
    'sass',
    '21212',
    'ddsdsd@gmail.com',
    '',
    'dede',
    '2024-01-29',
    NULL,
    5.00,
    '1st_15th',
    1,
    'Sajith Wickramasena',
    23
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    213,
    'PRO000074',
    'Provider 03',
    '1234',
    'prov3@gmail.com',
    '',
    'G5',
    '2024-02-28',
    NULL,
    15.00,
    '1st_15th',
    1,
    'Sajith Wickramasena',
    23
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `EndDate`,
    `BillingRate`,
    `InvoiceSchedule`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    214,
    'PRO000075',
    'Prov 04',
    '1234',
    'prov4@gmail.com',
    'Colombo',
    'G5',
    '2024-01-01',
    '2024-01-31',
    12.00,
    '15th_1st',
    1,
    'Sajith Wickramasena',
    23
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: file_upload_table
# ------------------------------------------------------------

INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    23,
    'Banuka perera',
    '1623485732097-3.jpg',
    'bbbb',
    '2021-06-12',
    'No',
    'banukap',
    21,
    0
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    25,
    'Banuka perera',
    '1623486020190-Invoice-INV000097.pdf',
    'report',
    '2021-06-12',
    'Yes',
    'banukap',
    22,
    0
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    27,
    'Banuka perera',
    '1623537476575-dashboard.JPG',
    'mnbb',
    '2021-06-13',
    'No',
    'banukap',
    22,
    0
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    28,
    'Banuka perera',
    '1623537539285-2.jpg',
    'mnbb',
    '2021-06-13',
    'Yes',
    'banukap',
    22,
    0
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    29,
    'Nalaka Bandara',
    '1623547209823-1.jpg',
    'bcv',
    '2021-06-13',
    'Yes',
    'nalakab',
    21,
    0
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    30,
    'admin',
    '1623553369709-1.jpg',
    'inv',
    '2021-06-13',
    'Yes',
    'admin',
    23,
    0
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    31,
    'Banuka perera',
    '1623556367668-1.jpg',
    'mmm',
    '2021-06-13',
    'Yes',
    'banukap',
    22,
    0
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    32,
    'admin',
    '1624788871364-9.jpg',
    'new rates',
    '2021-06-27',
    'Yes',
    'admin',
    21,
    0
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    33,
    'banukap',
    '1624792347965-1.jpg',
    'bbbb',
    '2021-06-27',
    'No',
    'banukap',
    21,
    0
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    38,
    'Sajith Wickramasena',
    '1702154540139-1624795408804-3 (1).jpg',
    'dsds',
    '2023-12-10',
    'Yes',
    'Sajith Wickramasena',
    21,
    1
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    39,
    'Anura Kumara',
    '1702213047204-1624788871364-9.jpg',
    'image 3',
    '2023-12-10',
    'No',
    'Anura Kumara',
    21,
    52
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    40,
    'Sajith Wickramasena',
    '1702213247745-provider profile.pdf',
    'pdf provider profile',
    '2023-12-10',
    'No',
    'Sajith Wickramasena',
    21,
    1
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    41,
    'Anura Kumara',
    '1702214013317-Tax information.xlsx',
    'tax',
    '2023-12-10',
    'Yes',
    'Anura Kumara',
    21,
    52
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `ProfileName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `Company`,
    `CreatedID`
  )
VALUES
  (
    42,
    'Sajith Wickramasena',
    '1706459480760-download (1).jpeg',
    'ewewe',
    '2024-01-28',
    'No',
    'Sajith Wickramasena',
    23,
    1
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: invoice_scheduler_table
# ------------------------------------------------------------

INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1,
    '2023-12',
    'Provider',
    3,
    'SUCCESS',
    'Sajith Wickramasena',
    1,
    '2024-01-06',
    21
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2,
    '2023-12',
    'Provider',
    0,
    'SUCCESS',
    'Sajith Wickramasena',
    1,
    '2024-01-06',
    21
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    3,
    '2024-01',
    'Provider',
    2,
    'SUCCESS',
    'Sajith Wickramasena',
    1,
    '2024-01-06',
    21
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    4,
    '2023-12',
    'Contractor',
    1,
    'SUCCESS',
    'Sajith Wickramasena',
    1,
    '2024-01-06',
    21
  );
INSERT INTO
  `invoice_scheduler_table` (
    `id`,
    `coll_period`,
    `source`,
    `qty`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    5,
    '2024-01',
    'Contractor',
    1,
    'SUCCESS',
    'Sajith Wickramasena',
    1,
    '2024-01-08',
    21
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: provider_invoice_item_table
# ------------------------------------------------------------

INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (1, 3, NULL, 7, 0.00, 0.00, 0.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (2, 4, NULL, 7, 125000.00, 10.00, 12500.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (3, 4, NULL, 8, 100000.00, 10.00, 10000.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (4, 5, NULL, 7, 0.00, 0.00, 0.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (5, 6, NULL, 8, 15000.00, 15.00, 2250.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (6, 7, NULL, 7, 40000.00, 10.00, 4000.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (7, 8, NULL, 7, 40000.00, 10.00, 4000.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (8, 9, NULL, 7, 40000.00, 10.00, 4000.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (9, 9, NULL, 7, 65000.00, 10.00, 6500.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (12, 11, NULL, 7, 40000.00, 10.00, 4000.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (13, 11, NULL, 7, 65000.00, 10.00, 6500.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (14, 12, 78, 7, 0.00, 0.00, 0.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (15, 12, 79, 7, 0.00, 0.00, 0.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (16, 13, 77, 7, 25000.00, 10.00, 2500.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (17, 14, 74, 8, 150000.00, 10.00, 15000.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (18, 15, 80, 7, 0.00, 0.00, 0.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (19, 15, 81, 8, 0.00, 0.00, 0.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (20, 16, 83, 7, 500000.00, 10.00, 50000.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (22, 18, 84, 8, 25000.00, 10.00, 2500.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (23, 19, 80, 7, 140000.00, 10.00, 14000.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (24, 19, 81, 8, 50000.00, 10.00, 5000.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (25, 20, 75, 7, 20000.00, 10.00, 2000.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (26, 21, 76, 7, 15000.00, 10.00, 1500.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (27, 21, 86, 7, 50000.00, 10.00, 5000.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (28, 22, 87, 7, 20000.00, 6.00, 1200.00);
INSERT INTO
  `provider_invoice_item_table` (
    `id`,
    `provider_invoice`,
    `coll_id`,
    `item`,
    `collection_amount`,
    `billing_rate`,
    `billing_amount`
  )
VALUES
  (29, 23, 88, 8, 30000.00, 10.00, 3000.00);

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: provider_invoice_table
# ------------------------------------------------------------

INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    3,
    'INV000001',
    '2023-12-23',
    '159',
    '2023-12',
    '2023-12-28',
    0.00,
    0.00,
    0.00,
    0.00,
    NULL,
    'CANCELLED',
    'Manual',
    0,
    0,
    'Sajith Wickramasena',
    1,
    '2023-12-23',
    '',
    0,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    4,
    'INV000002',
    '2023-12-23',
    '159',
    '2023-12',
    '2023-12-29',
    225000.00,
    22500.00,
    -22500.00,
    45000.00,
    NULL,
    'PAID',
    'Manual',
    0,
    0,
    'Sajith Wickramasena',
    1,
    '2023-12-23',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    5,
    'INV000003',
    '2023-12-23',
    '208',
    '2023-12',
    '2023-12-27',
    0.00,
    0.00,
    0.00,
    0.00,
    NULL,
    'CANCELLED',
    'Manual',
    0,
    0,
    'Sajith Wickramasena',
    1,
    '2023-12-23',
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    6,
    'INV000004',
    '2023-12-23',
    '174',
    '2023-12',
    '2023-12-29',
    15000.00,
    2250.00,
    2250.00,
    0.00,
    NULL,
    'CANCELLED',
    'Manual',
    0,
    0,
    'Sajith Wickramasena',
    1,
    '2023-12-23',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    7,
    'INV000005',
    '2023-11-01',
    '159',
    '2023-12',
    '2023-11-15',
    40000.00,
    4000.00,
    -4000.00,
    8000.00,
    NULL,
    'PAID',
    'Manual',
    0,
    0,
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    8,
    'INV000006',
    '2023-11-01',
    '159',
    '2023-12',
    '2023-11-15',
    40000.00,
    4000.00,
    0.00,
    4000.00,
    NULL,
    'PAID',
    'Manual',
    0,
    0,
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    9,
    'INV000007',
    '2023-11-01',
    '159',
    '2023-10',
    '2023-11-15',
    105000.00,
    10500.00,
    0.00,
    10500.00,
    NULL,
    'PAID',
    'Manual',
    0,
    0,
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    11,
    'INV000008',
    '2023-11-01',
    '159',
    '2023-10',
    '2023-11-15',
    105000.00,
    10500.00,
    0.00,
    10500.00,
    NULL,
    'PAID',
    'Manual',
    1,
    0,
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    12,
    'INV000009',
    '2023-11-01',
    '159',
    '2023-10',
    '2023-11-15',
    0.00,
    0.00,
    0.00,
    0.00,
    NULL,
    'CANCELLED',
    'Manual',
    0,
    0,
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    13,
    'INV000010',
    '2024-01-01',
    '159',
    '2023-12',
    '2024-01-15',
    25000.00,
    2500.00,
    0.00,
    2500.00,
    NULL,
    'PAID',
    'Manual',
    0,
    0,
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    14,
    'INV000011',
    '2023-12-01',
    '159',
    '2023-11',
    '2023-12-15',
    150000.00,
    15000.00,
    0.00,
    15000.00,
    NULL,
    'PAID',
    'Manual',
    1,
    0,
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    15,
    'INV000012',
    '2024-01-01',
    '159',
    '2023-12',
    '2024-01-15',
    0.00,
    0.00,
    0.00,
    0.00,
    NULL,
    'CANCELLED',
    'Manual',
    0,
    0,
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    16,
    'INV000013',
    '2024-02-01',
    '159',
    '2024-01',
    '2024-02-15',
    500000.00,
    50000.00,
    50000.00,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    0,
    0,
    'Sajith Wickramasena',
    1,
    '2024-01-02',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    18,
    'INV000014',
    '2024-02-01',
    '208',
    '2024-01',
    '2024-02-15',
    25000.00,
    2500.00,
    2500.00,
    0.00,
    NULL,
    'UNPAID',
    'Manual',
    1,
    0,
    'Sajith Wickramasena',
    1,
    '2024-01-02',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    19,
    'INV000015',
    '2024-01-01',
    '159',
    '2023-12',
    '2024-01-15',
    190000.00,
    19000.00,
    19000.00,
    0.00,
    '',
    'UNPAID',
    'Auto',
    1,
    0,
    'Sajith Wickramasena',
    1,
    '2024-01-06',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    20,
    'INV000016',
    '2024-01-01',
    '206',
    '2023-12',
    '2024-01-15',
    20000.00,
    2000.00,
    2000.00,
    0.00,
    '',
    'UNPAID',
    'Auto',
    1,
    0,
    'Sajith Wickramasena',
    1,
    '2024-01-06',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    21,
    'INV000017',
    '2024-01-01',
    '208',
    '2023-12',
    '2024-01-15',
    65000.00,
    6500.00,
    6500.00,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    0,
    'Sajith Wickramasena',
    1,
    '2024-01-06',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    22,
    'INV000018',
    '2024-02-15',
    '198',
    '2024-01',
    '2024-03-01',
    20000.00,
    1200.00,
    1200.00,
    0.00,
    '',
    'UNPAID',
    'Auto',
    0,
    0,
    'Sajith Wickramasena',
    1,
    '2024-01-06',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_invoice_table` (
    `id`,
    `invoice_no`,
    `invoice_date`,
    `customer`,
    `time_period`,
    `due_date`,
    `collection_total`,
    `billing_total`,
    `due`,
    `amount_paid`,
    `remarks`,
    `status`,
    `type`,
    `is_sent`,
    `is_invoiced`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    23,
    'INV000019',
    '2024-02-23',
    '208',
    '2024-01',
    '2024-02-28',
    30000.00,
    3000.00,
    3000.00,
    0.00,
    '',
    'UNPAID',
    'Auto',
    1,
    1,
    'Sajith Wickramasena',
    1,
    '2024-01-06',
    NULL,
    NULL,
    NULL,
    21
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: provider_receipt_item_table
# ------------------------------------------------------------

INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    5,
    3,
    4,
    '2023-12-23',
    'INV000002',
    22500.00,
    22500.00,
    22500.00
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    6,
    3,
    7,
    '2023-11-01',
    'INV000005',
    4000.00,
    4000.00,
    4000.00
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    7,
    4,
    4,
    '2023-12-23',
    'INV000002',
    22500.00,
    22500.00,
    22500.00
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    8,
    4,
    7,
    '2023-11-01',
    'INV000005',
    4000.00,
    4000.00,
    4000.00
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    9,
    5,
    8,
    '2023-11-01',
    'INV000006',
    4000.00,
    4000.00,
    4000.00
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    10,
    5,
    9,
    '2023-11-01',
    'INV000007',
    10500.00,
    10500.00,
    10500.00
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    11,
    6,
    11,
    '2023-11-01',
    'INV000008',
    10500.00,
    10500.00,
    10500.00
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (12, 7, 13, '2024-01-01', 'INV000010', 0.00, 0.00, 0.00);
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (13, 7, 14, '2023-12-01', 'INV000011', 0.00, 0.00, 0.00);
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (14, 8, 13, '2024-01-01', 'INV000010', 0.00, 0.00, 0.00);
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (15, 8, 14, '2023-12-01', 'INV000011', 0.00, 0.00, 0.00);
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (16, 9, 13, '2024-01-01', 'INV000010', 0.00, 0.00, 0.00);
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (17, 9, 14, '2023-12-01', 'INV000011', 0.00, 0.00, 0.00);
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    18,
    10,
    14,
    '2023-12-01',
    'INV000011',
    15000.00,
    15000.00,
    15000.00
  );
INSERT INTO
  `provider_receipt_item_table` (
    `id`,
    `receipt_id`,
    `invoice_id`,
    `invoice_date`,
    `invoice_no`,
    `grand_total`,
    `due`,
    `amount_paid`
  )
VALUES
  (
    19,
    11,
    13,
    '2024-01-01',
    'INV000010',
    2500.00,
    2500.00,
    2500.00
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: provider_receipt_table
# ------------------------------------------------------------

INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    3,
    'REC000001',
    '2023-12-31',
    159,
    'Cheque',
    '3232',
    26500.00,
    'POSTED',
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    4,
    'REC000002',
    '2023-12-31',
    159,
    'Cheque',
    '3232',
    26500.00,
    'POSTED',
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    5,
    'REC000003',
    '2023-12-31',
    159,
    'Cash',
    '25252',
    14500.00,
    'POSTED',
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    6,
    'REC000004',
    '2023-12-31',
    159,
    'Cheque',
    '2525',
    10500.00,
    'POSTED',
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    7,
    'REC000005',
    '2023-12-31',
    159,
    'Bank Transfer',
    '1234333',
    0.00,
    'CANCELLED',
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    8,
    'REC000006',
    '2023-12-31',
    159,
    'Card Payment',
    '4552',
    0.00,
    'CANCELLED',
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    9,
    'REC000007',
    '2023-12-31',
    159,
    'Cash',
    NULL,
    0.00,
    'CANCELLED',
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    'Sajith Wickramasena',
    1,
    '2023-12-31',
    21
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    10,
    'REC000008',
    '2024-01-01',
    159,
    'Cash',
    NULL,
    15000.00,
    'POSTED',
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    NULL,
    NULL,
    NULL,
    21
  );
INSERT INTO
  `provider_receipt_table` (
    `id`,
    `receipt_no`,
    `paid_date`,
    `prov_id`,
    `payment_method`,
    `payment_ref_no`,
    `paid_total`,
    `status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `cancelled_by`,
    `cancelled_by_id`,
    `cancelled_at`,
    `company`
  )
VALUES
  (
    11,
    'REC000009',
    '2024-01-01',
    159,
    'Cash',
    NULL,
    2500.00,
    'POSTED',
    'Sajith Wickramasena',
    1,
    '2024-01-01',
    NULL,
    NULL,
    NULL,
    21
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: provider_service_table
# ------------------------------------------------------------

INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    4,
    'Insurance Income',
    'Sajith Wickramasena',
    '2023-12-11 00:32:44',
    23
  );
INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    7,
    'Insurance Income',
    'Sajith Wickramasena',
    '2023-12-17 00:17:23',
    21
  );
INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    8,
    'Patient Income',
    'Sajith Wickramasena',
    '2023-12-23 14:57:05',
    21
  );
INSERT INTO
  `provider_service_table` (`id`, `name`, `created_by`, `created_at`, `company`)
VALUES
  (
    9,
    'Patient Income',
    'Sajith Wickramasena',
    '2024-01-29 01:23:45',
    23
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: settings_table
# ------------------------------------------------------------

INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (1, 'POS01', 'CutePDF Writer');
INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (2, 'NP01', 'CutePDF Writer');
INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (3, 'TAX01', '45');
INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (4, 'VAT01', '15');
INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (5, 'COM01', 'ABC COMPANY PVT LTD');
INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (6, 'DateFormat', 'MM/DD/YYYY');

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: shared_document_table
# ------------------------------------------------------------

INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `Company`,
    `SharedById`
  )
VALUES
  (
    17,
    '1624788871364-9.jpg',
    'new rates',
    '2021-06-27',
    'admin',
    'All',
    21,
    NULL
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `Company`,
    `SharedById`
  )
VALUES
  (
    18,
    '1623486020190-Invoice-INV000097.pdf',
    'report',
    '2021-06-27',
    'admin',
    'anurakw',
    21,
    NULL
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `Company`,
    `SharedById`
  )
VALUES
  (
    20,
    '1623537539285-2.jpg',
    'mnbb',
    '2021-06-27',
    'banukap',
    'anurakw',
    22,
    NULL
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `Company`,
    `SharedById`
  )
VALUES
  (
    22,
    '1623556367668-1.jpg',
    'mmm',
    '2021-06-27',
    'banukap',
    'admin',
    22,
    NULL
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `Company`,
    `SharedById`
  )
VALUES
  (
    25,
    '1623553369709-1.jpg',
    'inv',
    '2021-07-07',
    'admin',
    'banukap',
    22,
    NULL
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `Company`,
    `SharedById`
  )
VALUES
  (
    29,
    '1702154540139-1624795408804-3 (1).jpg',
    'dsds',
    '2023-12-10',
    'Sajith Wickramasena',
    'anurak',
    21,
    1
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `Company`,
    `SharedById`
  )
VALUES
  (
    31,
    '1702214013317-Tax information.xlsx',
    'tax',
    '2023-12-10',
    'Anura Kumara',
    'All',
    21,
    52
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: task_table
# ------------------------------------------------------------

INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    9,
    24,
    'Anura Kumara',
    'Special',
    'accounting',
    'manoth end',
    '2021-01-13',
    'In Progress',
    'admin',
    21
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    11,
    0,
    'Sajith Wickramasena',
    'Urgent',
    'sas',
    'saas',
    '2020-12-23',
    'Completed',
    'admin',
    21
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    12,
    0,
    'Sajith Wickramasena',
    'Normal',
    'ewewe',
    'ewewe',
    '2020-12-17',
    'In Progress',
    'admin',
    21
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    13,
    0,
    'Sajith Wickramasena',
    'Special',
    'ewewe',
    'ewew',
    '2020-12-30',
    'Completed',
    'admin',
    22
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    14,
    0,
    'Sajith Wickramasena',
    'Normal',
    'wqwq',
    'wqw',
    '2020-12-31',
    'On Hold',
    'admin',
    22
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    15,
    0,
    'Sajith Wickramasena',
    'Urgent',
    'sas',
    'sas',
    '2021-03-25',
    'Not Started',
    'admin',
    0
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    16,
    0,
    'Anura Kumara',
    'Urgent',
    'vvvv',
    'vvv',
    '2021-05-27',
    'In Progress',
    'anurak',
    0
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    17,
    0,
    'Anura Kamal Wickramasinghe',
    'Urgent',
    'bbb',
    'bbb',
    '2021-05-26',
    'Not Started',
    'admin',
    0
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    18,
    0,
    'Banuka perera',
    'Normal',
    'Collection Money',
    'Collection Money',
    '2021-05-31',
    'Not Started',
    'admin',
    0
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    19,
    0,
    'Fahad Razzaq',
    'Normal',
    'Collections',
    'Collections',
    '2021-05-26',
    'Not Started',
    'admin',
    0
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    20,
    0,
    'Fahad Razzaq',
    'Special',
    'Money colloection',
    'Money colloection',
    '2021-05-31',
    'In Progress',
    'admin',
    0
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `Company`
  )
VALUES
  (
    21,
    23,
    'Sajith Wickramasena',
    'Normal',
    'Collect Money',
    'collect money from Smith',
    '2023-12-20',
    'Completed',
    'Sajith Wickramasena',
    21
  );

