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

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

# ------------------------------------------------------------
# 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;

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

CREATE TABLE IF NOT EXISTS `collection_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `Date` varchar(20) DEFAULT NULL,
  `EmpId` varchar(50) DEFAULT NULL,
  `EmpName` varchar(250) DEFAULT NULL,
  `CusId` varchar(50) DEFAULT NULL,
  `CusName` varchar(250) DEFAULT NULL,
  `CollectionAmount` decimal(20, 2) DEFAULT NULL,
  `Rate` varchar(10) DEFAULT NULL,
  `Commission` decimal(20, 2) DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `CreatedBy` varchar(100) DEFAULT NULL,
  `CompanyName` varchar(250) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 70 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# 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,
  `Logo` mediumblob,
  `CreatedBy` varchar(50) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 24 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: customer_receipt_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `customer_receipt_table` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `ReceiptNo` varchar(20) DEFAULT NULL,
  `PaidDate` date DEFAULT NULL,
  `PaymentType` varchar(20) DEFAULT NULL,
  `PaymentRefNo` varchar(100) DEFAULT NULL,
  `CusId` varchar(20) DEFAULT NULL,
  `CusName` varchar(100) DEFAULT NULL,
  `Address` varchar(200) DEFAULT NULL,
  `PaidTotal` decimal(20, 2) DEFAULT NULL,
  `InvoiceDate` date DEFAULT NULL,
  `InvoiceNo` varchar(20) DEFAULT NULL,
  `Period` varchar(20) DEFAULT NULL,
  `BasePayment` decimal(20, 2) DEFAULT NULL,
  `TotalComm` decimal(20, 2) DEFAULT NULL,
  `GrandTotal` decimal(20, 2) DEFAULT NULL,
  `BalToPay` decimal(20, 2) DEFAULT NULL,
  `AmountPaid` decimal(20, 2) DEFAULT NULL,
  `Status` varchar(20) DEFAULT NULL,
  `Payslip` varchar(20) DEFAULT NULL,
  `CreatedBy` varchar(50) DEFAULT NULL,
  `CompanyName` varchar(250) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 200 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# 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,
  `Status` varchar(50) NOT NULL,
  `CreatedBy` varchar(50) NOT NULL,
  `CompanyName` varchar(250) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 198 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: emp_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `emp_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `EmpName` varchar(255) NOT NULL,
  `DOB` date NOT NULL,
  `Gender` varchar(50) NOT NULL,
  `Address` varchar(250) NOT NULL,
  `Phone` varchar(50) NOT NULL,
  `Email` varchar(250) NOT NULL,
  `Status` varchar(50) NOT NULL,
  `CreatedBy` varchar(100) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;

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

CREATE TABLE IF NOT EXISTS `file_upload_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `EmpId` varchar(100) DEFAULT NULL,
  `EmpName` 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,
  `CompanyName` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 36 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: invoice_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `invoice_table` (
  `Id` int(10) NOT NULL AUTO_INCREMENT,
  `InvoiceNo` varchar(20) DEFAULT NULL,
  `InvoiceDate` date DEFAULT NULL,
  `CollectionPeriod` varchar(20) DEFAULT NULL,
  `CusId` varchar(20) DEFAULT NULL,
  `CusName` varchar(150) DEFAULT NULL,
  `Address` varchar(200) DEFAULT NULL,
  `CollectionId` int(11) DEFAULT NULL,
  `CollectionDate` varchar(50) DEFAULT NULL,
  `Provider` varchar(100) DEFAULT NULL,
  `Collections` decimal(20, 2) DEFAULT NULL,
  `Rate` varchar(20) DEFAULT NULL,
  `Commission` decimal(20, 2) DEFAULT NULL,
  `TotalColl` decimal(20, 2) DEFAULT NULL,
  `TotalComm` decimal(20, 2) DEFAULT NULL,
  `BasePayment` decimal(20, 2) DEFAULT NULL,
  `GrandTotal` decimal(20, 2) DEFAULT NULL,
  `BalToPay` decimal(20, 2) DEFAULT NULL,
  `AmountPaid` decimal(20, 2) DEFAULT NULL,
  `ApprovalStatus` varchar(50) DEFAULT NULL,
  `Status` varchar(20) DEFAULT NULL,
  `CreatedBy` varchar(50) DEFAULT NULL,
  `CompanyName` varchar(250) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 485 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# 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;

# ------------------------------------------------------------
# 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,
  `CompanyName` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 26 DEFAULT CHARSET = latin1;

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

CREATE TABLE IF NOT EXISTS `task_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `EmpId` varchar(100) 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,
  `CompanyName` varchar(250) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 21 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: user_access_permission_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `user_access_permission_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(30) NOT NULL,
  `DB` int(2) NOT NULL,
  `CP` int(2) NOT NULL,
  `COM` int(2) NOT NULL,
  `ADD_CONT` int(2) NOT NULL,
  `ASSIGN_CONT` int(2) NOT NULL,
  `CONT_LIST` int(2) NOT NULL,
  `CM` int(2) NOT NULL,
  `COLL` int(2) NOT NULL,
  `INV` int(2) NOT NULL,
  `PMT` int(2) NOT NULL,
  `TASK` int(2) NOT NULL,
  `USER` int(2) NOT NULL,
  `COLL_REPORT` int(2) NOT NULL,
  `INV_REPORT` int(2) NOT NULL,
  `BP_REPORT` int(2) NOT NULL,
  `CLIENT_REPORT` int(2) NOT NULL,
  `EMP_REPORT` int(2) NOT NULL,
  `SETTINGS` int(2) NOT NULL,
  `CreatedBy` varchar(50) NOT NULL,
  `CompanyName` varchar(250) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 38 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: user_login_session_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `user_login_session_table` (
  `Id` int(10) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(50) NOT NULL,
  `LoginDate` date NOT NULL,
  `LoginTime` time NOT NULL,
  `IsLogin` int(2) NOT NULL,
  `Status` varchar(20) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 13 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: user_type_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `user_type_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `UserType` varchar(100) NOT NULL,
  `CreatedBy` varchar(50) NOT NULL,
  `CompanyName` varchar(250) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 32 DEFAULT CHARSET = latin1;

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

INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    15,
    'CUS000044',
    'ANURA PERERA ',
    'EMP000017',
    'Anura Kumara',
    '12%',
    '2021-05-23',
    '2021-05-27',
    '',
    'RapidGnix',
    'admin'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    21,
    'CUS000065',
    'Ronald Jefferson',
    'EMP000019',
    'Banuka perera',
    '3%',
    '2021-05-30',
    '2021-05-31',
    '',
    'ABC COMPANY PVT LTD',
    'admin'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    22,
    'CUS000065',
    'Ronald Jefferson',
    'CON000022',
    'Fahad Razzaq',
    '4',
    '2021-06-10',
    '0000-00-00',
    '',
    'ABC COMPANY PVT LTD',
    'admin'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    23,
    'CUS000066',
    'Asela Gunarathne',
    'CON000026',
    'Nalaka Bandara',
    '5%',
    '2021-06-15',
    NULL,
    '',
    'Novar Flex Pvt Ltd',
    'admin'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    24,
    'CUS000065',
    'Ronald Jefferson',
    'EMP000016',
    'Sajith Wickramasena',
    '5%',
    '2021-07-13',
    NULL,
    '',
    'ABC COMPANY PVT LTD',
    'admin'
  );

# ------------------------------------------------------------
# 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`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    36,
    'May 2021',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-updated',
    20000.00,
    '10',
    2000.00,
    'Invoiced',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    37,
    'May 2021',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-upda',
    12000.00,
    '12',
    1440.00,
    'Invoiced',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    38,
    'May 2021',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-up',
    1200.00,
    '200',
    2400.00,
    'Invoiced',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    39,
    'Apr 2021',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-updated',
    5000.00,
    '23',
    1150.00,
    'Invoiced',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    40,
    'Apr 2021',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-updated',
    50000.00,
    '3',
    1500.00,
    'Invoiced',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    41,
    '2021-05-25',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-updated',
    60000.00,
    '23',
    13800.00,
    'Not Invoiced',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    42,
    'Jun 2021',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-updated',
    45000.00,
    '6',
    2700.00,
    'Not Invoiced',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    43,
    'May 2021',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-updated',
    230006.00,
    '9',
    20700.54,
    'Not Invoiced',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    44,
    'May 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000047',
    'maduranga-updated',
    12000.00,
    '12',
    1440.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    46,
    'May 2021',
    'CON000022',
    'Fahad Razzaq',
    'CUS000065',
    'Ronald Jefferson',
    4000.00,
    '2',
    80.00,
    'Invoiced',
    'Fahad',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    49,
    'May 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    200000.00,
    '3',
    6000.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    50,
    'May 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    40000.00,
    '3',
    1200.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    51,
    'May 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    12000.00,
    '3',
    360.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    52,
    'May 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    90000.00,
    '3',
    2700.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    53,
    'May 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    50000.00,
    '3',
    1500.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    54,
    'Jun 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    400000.00,
    '3',
    12000.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    55,
    'May 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    37500.00,
    '3',
    1125.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    58,
    'Jun 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    235000.00,
    '3%',
    7050.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    59,
    'Jun 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    456000.00,
    '3%',
    13680.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    60,
    'Jun 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    25000.00,
    '3%',
    750.00,
    'Not Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    61,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    120000.00,
    '5%',
    6000.00,
    'Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    62,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    3000.00,
    '5%',
    150.00,
    'Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    63,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    60000.00,
    '5%',
    3000.00,
    'Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    64,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    40000.00,
    '5%',
    2000.00,
    'Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    65,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    320000.00,
    '5%',
    16000.00,
    'Not Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    66,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    50000.00,
    '5%',
    2500.00,
    'Not Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    67,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    40000.00,
    '5%',
    2000.00,
    'Not Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    68,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    10000.00,
    '5%',
    500.00,
    'Not Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    69,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    64000.00,
    '5%',
    3200.00,
    'Not Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );

# ------------------------------------------------------------
# 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`
  )
VALUES
  (
    21,
    'ABC COMPANY PVT LTD',
    '7677',
    '3232 6565',
    'sajithfeat145@gmail.com',
    'maritimelk.com',
    'ssasa',
    '+94713155665',
    '2021-01-01',
    '2021-01-13',
    'No.234\nVictoria Road\nColombo',
    'rrrrrr',
    NULL,
    NOFORMAT_WRAP(
      "##X'[BLOB]'##"
    ),
    'admin'
  );
INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`
  )
VALUES
  (
    22,
    'RapidGnix',
    '',
    '212',
    NULL,
    NULL,
    'sajith',
    NULL,
    '2021-01-14',
    '2021-01-20',
    NULL,
    NULL,
    NULL,
    NULL,
    'admin'
  );
INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`
  )
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,
    'admin'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: customer_receipt_table
# ------------------------------------------------------------

INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    170,
    'CPMT000001',
    '2020-12-26',
    'Cheque',
    NULL,
    'EMP000003',
    'Sajith Wickramasena',
    'Kandy',
    1295.00,
    '2020-12-26',
    'INV000001',
    NULL,
    NULL,
    NULL,
    1295.00,
    1295.00,
    1295.00,
    'Paid',
    NULL,
    'admin',
    ''
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    171,
    'CPMT000002',
    '2020-12-26',
    'Cash',
    NULL,
    'EMP000003',
    'Sajith Wickramasena',
    'Kandy',
    7000.00,
    '2020-12-26',
    'INV000002',
    NULL,
    NULL,
    NULL,
    7000.00,
    7000.00,
    7000.00,
    'Paid',
    NULL,
    'admin',
    ''
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    172,
    'CPMT000003',
    '2020-12-26',
    'Cash',
    NULL,
    'EMP000017',
    'Anura Kumara',
    'ff',
    600.00,
    '2020-12-26',
    'INV000003',
    NULL,
    NULL,
    NULL,
    600.00,
    600.00,
    600.00,
    'Paid',
    NULL,
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    174,
    'CPMT000005',
    '2020-12-27',
    'Cash',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    1000.00,
    '2020-12-27',
    'INV000006',
    NULL,
    NULL,
    NULL,
    2500.00,
    2500.00,
    1000.00,
    'Partly Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    175,
    'CPMT000006',
    '2021-01-03',
    'Cash',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    2250.00,
    '2021-01-03',
    'INV000007',
    NULL,
    NULL,
    NULL,
    2250.00,
    2250.00,
    2250.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    176,
    'CPMT000007',
    '2021-01-11',
    'Cash',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    1600.00,
    '2021-01-11',
    'INV000008',
    NULL,
    NULL,
    NULL,
    1600.00,
    1600.00,
    1600.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    177,
    'CPMT000008',
    '2021-01-11',
    'Cheque',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    4500.00,
    '2020-12-27',
    'INV000006',
    NULL,
    NULL,
    NULL,
    2500.00,
    1500.00,
    1500.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    178,
    'CPMT000008',
    '2021-01-11',
    'Cheque',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    4500.00,
    '2020-12-27',
    'INV000005',
    NULL,
    NULL,
    NULL,
    3000.00,
    3000.00,
    3000.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    179,
    'CPMT000009',
    '2021-01-12',
    'Cash',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    38950.00,
    '2021-01-12',
    'INV000009',
    NULL,
    NULL,
    NULL,
    38950.00,
    38950.00,
    38950.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    180,
    'CPMT000010',
    '2021-01-12',
    'Cash',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    40000.00,
    '2021-01-12',
    'INV000010',
    NULL,
    NULL,
    NULL,
    40000.00,
    40000.00,
    40000.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    181,
    'CPMT000011',
    '2021-03-20',
    'Cheque',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    15000.00,
    '2021-03-20',
    'INV000011',
    NULL,
    NULL,
    NULL,
    15000.00,
    15000.00,
    15000.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    182,
    'CPMT000012',
    '2021-03-20',
    'Cash',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    2600.00,
    '2020-12-26',
    'INV000004',
    NULL,
    NULL,
    NULL,
    2600.00,
    2600.00,
    2600.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    184,
    'CPMT000013',
    '2021-05-30',
    'Cheque',
    NULL,
    'EMP000019',
    'Banuka perera',
    'Kandy Road\nNittambuwa',
    6000.00,
    '2021-05-30',
    'INV000004',
    NULL,
    NULL,
    NULL,
    6000.00,
    6000.00,
    6000.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    192,
    'CPMT000014',
    '2021-06-05',
    'Cash',
    NULL,
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    2700.00,
    '2021-06-05',
    'INV000012',
    NULL,
    NULL,
    NULL,
    2700.00,
    2700.00,
    2700.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    193,
    'CPMT000015',
    '2021-06-26',
    'Cheque',
    '5556',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    33680.00,
    '2021-06-18',
    'INV000024',
    NULL,
    NULL,
    NULL,
    33680.00,
    33680.00,
    33680.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    194,
    'CPMT000016',
    '2021-07-17',
    'Cheque',
    '6667',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    42000.00,
    '2021-06-14',
    'INV000022',
    '2021-06',
    30000.00,
    12000.00,
    42000.00,
    42000.00,
    42000.00,
    'Paid',
    'Yes',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    195,
    'CPMT000017',
    '2021-07-19',
    'Cheque',
    '777',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    4200.00,
    '2021-06-05',
    'INV000012',
    '2021-05',
    0.00,
    4200.00,
    4200.00,
    4200.00,
    4200.00,
    'Paid',
    'No',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    196,
    'CPMT000018',
    '2021-07-19',
    'Cheque',
    '88',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    1125.00,
    '2021-06-11',
    'INV000014',
    '2021-05',
    0.00,
    1125.00,
    1125.00,
    1125.00,
    1125.00,
    'Paid',
    'No',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    199,
    'CPMT000019',
    '2021-07-20',
    'Cash',
    NULL,
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    37050.00,
    '2021-07-20',
    'INV000025',
    '2021-06',
    30000.00,
    7050.00,
    37050.00,
    37050.00,
    37050.00,
    'Paid',
    'No',
    'admin',
    'ABC COMPANY PVT LTD'
  );

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

INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    159,
    'CUS000034',
    'SAJITH WICKRAMSENA ',
    '555566776',
    'sajithfeat145@gmail.com',
    'Nugegoda',
    ' 544545454545      ',
    '2020-12-24',
    'Active',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    174,
    'CUS000044',
    'ANURA PERERA ',
    'asassasasas',
    'sajithfeat145@gmail.com',
    'No 14\nMal Mawatha\nColombo 05',
    ' 544545454545      ',
    '0000-00-00',
    'Deactivated',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    175,
    'CUS000045',
    'ewew',
    'ewe',
    'eww@gmail.com',
    'wqwq',
    NULL,
    '2020-12-23',
    'Active',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    181,
    'CUS000051',
    'Kasun Devappriya',
    '3232',
    'kasun@gmail.com',
    'colombo',
    'bbb',
    '2020-12-24',
    'Active',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    182,
    'CUS000052',
    'nnnnnn',
    '21212',
    'sa@gmial.com',
    'wqwq',
    'wqw',
    '2021-01-22',
    'Active',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    194,
    'CUS000064',
    'Dr. Gilbert C',
    '7136531616',
    '154818186@gmail.com',
    '203 N COLLEGE #1001',
    'none',
    '2020-12-31',
    'Active',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    195,
    'CUS000065',
    'Ronald Jefferson',
    '7136531616',
    '545489@gmail.com',
    '203 N COLLEGE #1001',
    '',
    '2021-01-01',
    'Active',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    196,
    'CUS000066',
    'Asela Gunarathne',
    '4444',
    '',
    'Kandy Road, Colombo 10',
    'bbb',
    '2021-06-16',
    'Active',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    197,
    'PRO000067',
    'mmm',
    '5555',
    '',
    'mmm',
    '',
    '2021-07-21',
    'Active',
    'admin',
    'ABC COMPANY PVT LTD'
  );

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

INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    22,
    'EMP000019',
    'Banuka perera',
    '1623483328033-5.jpg',
    'mmm',
    '2021-06-12',
    'Yes',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    23,
    'EMP000019',
    'Banuka perera',
    '1623485732097-3.jpg',
    'bbbb',
    '2021-06-12',
    'No',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    24,
    'EMP000019',
    'Banuka perera',
    '1623485977474-cus outsatanding.pdf',
    'report',
    '2021-06-12',
    'No',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    25,
    'EMP000019',
    'Banuka perera',
    '1623486020190-Invoice-INV000097.pdf',
    'report',
    '2021-06-12',
    'Yes',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    27,
    'EMP000019',
    'Banuka perera',
    '1623537476575-dashboard.JPG',
    'mnbb',
    '2021-06-13',
    'No',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    28,
    'EMP000019',
    'Banuka perera',
    '1623537539285-2.jpg',
    'mnbb',
    '2021-06-13',
    'Yes',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    29,
    'CON000026',
    'Nalaka Bandara',
    '1623547209823-1.jpg',
    'bcv',
    '2021-06-13',
    'Yes',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    30,
    'admin',
    'admin',
    '1623553369709-1.jpg',
    'inv',
    '2021-06-13',
    'Yes',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    31,
    'EMP000019',
    'Banuka perera',
    '1623556367668-1.jpg',
    'mmm',
    '2021-06-13',
    'Yes',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    32,
    'admin',
    'admin',
    '1624788871364-9.jpg',
    'new rates',
    '2021-06-27',
    'Yes',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    33,
    'banukap',
    'banukap',
    '1624792347965-1.jpg',
    'bbbb',
    '2021-06-27',
    'No',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    34,
    'banukap',
    'banukap',
    '1624792534434-2.jpg',
    'lllll',
    '2021-06-27',
    'No',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    35,
    'EMP000019',
    'Banuka perera',
    '1624795408804-3.jpg',
    'gggg',
    '2021-06-27',
    'Yes',
    'banukap',
    'ABC COMPANY PVT LTD'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: invoice_table
# ------------------------------------------------------------

INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    327,
    'INV000001',
    '2021-05-23',
    '2021-04',
    'EMP000017',
    'Anura Kumara',
    'ff',
    39,
    'Apr 2021',
    'maduranga-updated',
    5000.00,
    '23',
    1150.00,
    55000.00,
    2650.00,
    0.00,
    2650.00,
    2650.00,
    0.00,
    NULL,
    'Unpaid',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    328,
    'INV000001',
    '2021-05-23',
    '2021-04',
    'EMP000017',
    'Anura Kumara',
    'ff',
    40,
    'Apr 2021',
    'maduranga-updated',
    50000.00,
    '3',
    1500.00,
    55000.00,
    2650.00,
    0.00,
    2650.00,
    2650.00,
    0.00,
    NULL,
    'Unpaid',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    329,
    'INV000002',
    '2021-05-24',
    '2021-05',
    'EMP000019',
    'Banuka perera',
    '32323',
    44,
    'May 2021',
    'maduranga-updated',
    12000.00,
    '12',
    1440.00,
    12000.00,
    1440.00,
    30000.00,
    31440.00,
    31440.00,
    0.00,
    NULL,
    'Unpaid',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    330,
    'INV000003',
    '2021-05-26',
    '2021-05',
    'CON000022',
    'Fahad Razzaq',
    '1234',
    46,
    'May 2021',
    'Ronald Jefferson',
    4000.00,
    '2',
    80.00,
    4000.00,
    80.00,
    4.00,
    84.00,
    84.00,
    0.00,
    NULL,
    'Unpaid',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    338,
    'INV000011',
    '2021-05-30',
    '2021-05',
    'EMP000019',
    'Banuka perera',
    'Kandy Road\nNittambuwa',
    49,
    'May 2021',
    'Ronald Jefferson',
    200000.00,
    '3',
    6000.00,
    200000.00,
    6000.00,
    0.00,
    6000.00,
    0.00,
    6000.00,
    'Approved',
    'Paid',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    462,
    'INV000012',
    '2021-06-05',
    '2021-05',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    52,
    'May 2021',
    'Ronald Jefferson',
    90000.00,
    '3',
    2700.00,
    140000.00,
    4200.00,
    0.00,
    4200.00,
    0.00,
    4200.00,
    'Approved',
    'Paid',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    463,
    'INV000012',
    '2021-06-05',
    '2021-05',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    53,
    'May 2021',
    'Ronald Jefferson',
    50000.00,
    '3',
    1500.00,
    140000.00,
    4200.00,
    0.00,
    4200.00,
    0.00,
    4200.00,
    'Approved',
    'Paid',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    464,
    'INV000013',
    '2021-06-05',
    '2021-05',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    55,
    'May 2021',
    'Ronald Jefferson',
    37500.00,
    '3',
    1125.00,
    37500.00,
    1125.00,
    0.00,
    1125.00,
    1125.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    465,
    'INV000014',
    '2021-06-11',
    '2021-05',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    55,
    'May 2021',
    'Ronald Jefferson',
    37500.00,
    '3',
    1125.00,
    37500.00,
    1125.00,
    0.00,
    1125.00,
    0.00,
    1125.00,
    'Approved',
    'Paid',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    466,
    'INV000015',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    61,
    'Jun 2021',
    'Asela Gunarathne',
    120000.00,
    '5%',
    6000.00,
    120000.00,
    6000.00,
    0.00,
    6000.00,
    6000.00,
    0.00,
    'Pending',
    'Unpaid',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    467,
    'INV000016',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    62,
    'Jun 2021',
    'Asela Gunarathne',
    3000.00,
    '5%',
    150.00,
    3000.00,
    150.00,
    0.00,
    150.00,
    150.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    468,
    'INV000016',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    62,
    'Jun 2021',
    'Asela Gunarathne',
    3000.00,
    '5%',
    150.00,
    3000.00,
    150.00,
    0.00,
    150.00,
    150.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    469,
    'INV000016',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    62,
    'Jun 2021',
    'Asela Gunarathne',
    3000.00,
    '5%',
    150.00,
    3000.00,
    150.00,
    0.00,
    150.00,
    150.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    470,
    'INV000016',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    62,
    'Jun 2021',
    'Asela Gunarathne',
    3000.00,
    '5%',
    150.00,
    3000.00,
    150.00,
    0.00,
    150.00,
    150.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    471,
    'INV000017',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    62,
    'Jun 2021',
    'Asela Gunarathne',
    3000.00,
    '5%',
    150.00,
    3000.00,
    150.00,
    0.00,
    150.00,
    150.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    472,
    'INV000018',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    63,
    'Jun 2021',
    'Asela Gunarathne',
    60000.00,
    '5%',
    3000.00,
    60000.00,
    3000.00,
    0.00,
    3000.00,
    3000.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    473,
    'INV000019',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    63,
    'Jun 2021',
    'Asela Gunarathne',
    60000.00,
    '5%',
    3000.00,
    60000.00,
    3000.00,
    0.00,
    3000.00,
    3000.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    474,
    'INV000020',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    64,
    'Jun 2021',
    'Asela Gunarathne',
    40000.00,
    '5%',
    2000.00,
    40000.00,
    2000.00,
    0.00,
    2000.00,
    2000.00,
    0.00,
    'Pending',
    'Unpaid',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    475,
    'INV000021',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    64,
    'Jun 2021',
    'Asela Gunarathne',
    40000.00,
    '5%',
    2000.00,
    40000.00,
    2000.00,
    0.00,
    2000.00,
    2000.00,
    0.00,
    'Pending',
    'Unpaid',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    477,
    'INV000022',
    '2021-06-14',
    '2021-06',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    54,
    'Jun 2021',
    'Ronald Jefferson',
    400000.00,
    '3',
    12000.00,
    400000.00,
    12000.00,
    30000.00,
    42000.00,
    0.00,
    42000.00,
    'Approved',
    'Paid',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    480,
    'INV000024',
    '2021-06-18',
    '2021-06',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    59,
    'Jun 2021',
    'Ronald Jefferson',
    456000.00,
    '3%',
    13680.00,
    456000.00,
    13680.00,
    20000.00,
    33680.00,
    0.00,
    33680.00,
    'Approved',
    'Paid',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    484,
    'INV000025',
    '2021-07-20',
    '2021-06',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    58,
    'Jun 2021',
    'Ronald Jefferson',
    235000.00,
    '3%',
    7050.00,
    235000.00,
    7050.00,
    30000.00,
    37050.00,
    0.00,
    37050.00,
    'Approved',
    'Paid',
    'admin',
    'ABC COMPANY PVT LTD'
  );

# ------------------------------------------------------------
# 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`,
    `CompanyName`
  )
VALUES
  (
    17,
    '1624788871364-9.jpg',
    'new rates',
    '2021-06-27',
    'admin',
    'All',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    18,
    '1623486020190-Invoice-INV000097.pdf',
    'report',
    '2021-06-27',
    'admin',
    'anurakw',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    19,
    '1624795408804-3.jpg',
    'gggg',
    '2021-06-27',
    'banukap',
    'All',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    20,
    '1623537539285-2.jpg',
    'mnbb',
    '2021-06-27',
    'banukap',
    'anurakw',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    21,
    '1623483328033-5.jpg',
    'mmm',
    '2021-06-27',
    'banukap',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    22,
    '1623556367668-1.jpg',
    'mmm',
    '2021-06-27',
    'banukap',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    25,
    '1623553369709-1.jpg',
    'inv',
    '2021-07-07',
    'admin',
    'banukap',
    'ABC COMPANY PVT LTD'
  );

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

INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    7,
    'EMP000016',
    'Sajith Wickramasena',
    'Normal',
    'sasa',
    'sas',
    '2020-12-23',
    'In Progress',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    9,
    'EMP000016',
    'Sajith Wickramasena',
    'Urgent',
    'accountin',
    'manoth end',
    '2021-01-13',
    'Not Started',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    10,
    'EMP000016',
    'Sajith Wickramasena',
    'Urgent',
    'dsdsd',
    'dsd',
    '2020-12-15',
    'On Hold',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    11,
    'EMP000016',
    'Sajith Wickramasena',
    'Urgent',
    'sas',
    'saas',
    '2020-12-23',
    'Completed',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    12,
    'EMP000016',
    'Sajith Wickramasena',
    'Normal',
    'ewewe',
    'ewewe',
    '2020-12-17',
    'In Progress',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    13,
    'EMP000016',
    'Sajith Wickramasena',
    'Special',
    'ewewe',
    'ewew',
    '2020-12-30',
    'Completed',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    14,
    'EMP000016',
    'Sajith Wickramasena',
    'Normal',
    'wqwq',
    'wqw',
    '2020-12-31',
    'On Hold',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    15,
    'EMP000016',
    'Sajith Wickramasena',
    'Urgent',
    'sas',
    'sas',
    '2021-03-25',
    'Not Started',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    16,
    'EMP000017',
    'Anura Kumara',
    'Urgent',
    'vvvv',
    'vvv',
    '2021-05-27',
    'In Progress',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    17,
    'CON000021',
    'Anura Kamal Wickramasinghe',
    'Urgent',
    'bbb',
    'bbb',
    '2021-05-26',
    'Not Started',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    18,
    'EMP000019',
    'Banuka perera',
    'Normal',
    'Collection Money',
    'Collection Money',
    '2021-05-31',
    'Not Started',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    19,
    'CON000022',
    'Fahad Razzaq',
    'Normal',
    'Collections',
    'Collections',
    '2021-05-26',
    'Not Started',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    20,
    'CON000022',
    'Fahad Razzaq',
    'Special',
    'Money colloection',
    'Money colloection',
    '2021-05-31',
    'In Progress',
    'admin',
    'ABC COMPANY PVT LTD'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: user_access_permission_table
# ------------------------------------------------------------

INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CONT_LIST`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `TASK`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    6,
    'admin  ',
    1,
    0,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CONT_LIST`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `TASK`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    30,
    'ss',
    0,
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'admin',
    ''
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CONT_LIST`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `TASK`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    32,
    'bbbb',
    1,
    0,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    'bbbb',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CONT_LIST`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `TASK`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    33,
    'anurak',
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CONT_LIST`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `TASK`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    34,
    'banukap',
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CONT_LIST`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `TASK`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    35,
    'Fahad',
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CONT_LIST`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `TASK`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    36,
    'nalakab',
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CONT_LIST`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `TASK`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    37,
    'anurakw',
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'admin',
    'ABC COMPANY PVT LTD'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: user_login_session_table
# ------------------------------------------------------------

INSERT INTO
  `user_login_session_table` (
    `Id`,
    `UserName`,
    `LoginDate`,
    `LoginTime`,
    `IsLogin`,
    `Status`
  )
VALUES
  (7, 'admin ', '2020-02-08', '07:56:36', 0, 'Logout');
INSERT INTO
  `user_login_session_table` (
    `Id`,
    `UserName`,
    `LoginDate`,
    `LoginTime`,
    `IsLogin`,
    `Status`
  )
VALUES
  (
    8,
    'wasanthak ',
    '2019-09-06',
    '05:57:00',
    0,
    'Logout'
  );
INSERT INTO
  `user_login_session_table` (
    `Id`,
    `UserName`,
    `LoginDate`,
    `LoginTime`,
    `IsLogin`,
    `Status`
  )
VALUES
  (
    9,
    'buddhikag ',
    '2019-09-07',
    '11:11:00',
    1,
    'Logged'
  );
INSERT INTO
  `user_login_session_table` (
    `Id`,
    `UserName`,
    `LoginDate`,
    `LoginTime`,
    `IsLogin`,
    `Status`
  )
VALUES
  (10, 'malakaH ', '2019-09-27', '11:35:44', 0, 'Logout');
INSERT INTO
  `user_login_session_table` (
    `Id`,
    `UserName`,
    `LoginDate`,
    `LoginTime`,
    `IsLogin`,
    `Status`
  )
VALUES
  (11, 'kamalk ', '2019-09-28', '08:44:59', 0, 'Logout');
INSERT INTO
  `user_login_session_table` (
    `Id`,
    `UserName`,
    `LoginDate`,
    `LoginTime`,
    `IsLogin`,
    `Status`
  )
VALUES
  (12, 'guest ', '2019-10-13', '12:51:20', 0, 'Logout');

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: user_type_table
# ------------------------------------------------------------

INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (14, 'Manager', 'admin', '');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (15, 'Admin', 'admin', '');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (21, 'Cashier', 'admin', '');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (22, 'Designer', 'admin', '');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (24, 'ddd', 'admin', '');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (25, 'bbbb', 'admin', '');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (29, 'Contractor', 'admin', 'RapidGnix');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (30, 'Contractor', 'admin', 'ABC COMPANY PVT LTD');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (31, 'Contractor', 'admin', 'Novar Flex Pvt Ltd');

