digi-gov.com / 127.0.0.1 / qpsii_waterworks / ww_water_billing

There are no favorite tables.

New
accounting
bac_lgu
budget
cenro
dbfederation
db_meter_readings
documenttracker
el_laravue
general
humanresource
information_schema
lgis
- lgis_app
- lgis_dum_app
lgu_repository
mysql
online_hr
performance
- performance_management
- performance_schema
qpsii
queue
repository
service_request_db

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (10257 total, Query took 0.0114 seconds.)

SELECT * FROM `ww_water_billing`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

			bill_number	main_id	cust_bill_number	application_no	acct_no	customer_id [customer_id] convert to [meter_id]	meter_id	meter_number	meter_reader_id	guarantee_deposit	advance_amount	bill_from	bill_to	billing_date	due_date	prev_consumption	present_consumption	ave_consumption	prev_meter_reading	present_meter_reading	cut_off_cum	cubic_meter_consumed	last_payment_date	basicCharge	total	total_unpaid_amount	adjustment	adj_status	remarks	pay_remarks	b_or_id	b_or_number	b_or_date	b_or_amount	entry_status	JID	coa_id	date_saved	exp_id	explanation	penalty_date	penalty_stat	cancel_remarks	bill_type	sen_cit discounted as billed	adj_type	adj_reading
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 1	1	0	202501000976	6	LIO-0439	6	6	LIO-0439	147	NULL	NULL	2024-12-01	2024-12-31	2025-01-01	2025-01-12	0.00	16.00	0.00	823.00	839.00	0	16.00	1900-01-01	280.00	280.00	280.00	0.00	NONE	UNPAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	3	444	2025-04-21 12:46:19	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 2	2	0	202501000976	68	LIO-0316	60	68	LIO-0316	147	NULL	NULL	2024-12-01	2024-12-31	2025-01-01	2025-01-12	0.00	-1564.00	0.00	1564.00	0.00	0	-1564.00	1900-01-01	NULL	NULL	NULL	0.00	NONE	UNPAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	4	444	2025-04-21 12:44:37	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 4	4	0	202501000976	930	POB-0083	911	930	POB-0083	144	NULL	NULL	2024-12-01	2024-12-31	2025-01-01	2025-01-12	0.00	19.00	0.00	1494.00	1513.00	0	19.00	1900-01-01	340.00	340.00	340.00	0.00	NONE	PAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	6	444	2025-04-11 11:53:37	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 5	5	0	202502000001	1685	TUD-0008	1664	1685	TUD-0008	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	12.00	0.00	203.00	215.00	0	12.00	1900-01-01	200.00	200.00	200.00	0.00	NONE	PAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	7	444	2025-04-07 14:35:31	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 6	6	0	202502000001	1798	TUD-0045	1776	1798	TUD-0045	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	13.00	0.00	573.00	586.00	0	13.00	1900-01-01	220.00	220.00	220.00	0.00	NONE	PAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	8	444	2025-04-07 14:30:17	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 7	7	0	202502000001	1812	TUD-0050	1790	1812	TUD-0050	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	5.00	0.00	430.00	435.00	0	5.00	1900-01-01	160.00	160.00	160.00	0.00	NONE	PAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	9	444	2025-04-07 14:35:10	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 8	8	0	202502000001	1830	TUD-0055	1809	1830	TUD-0055	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	11.00	0.00	455.00	466.00	0	11.00	1900-01-01	180.00	180.00	180.00	0.00	NONE	PAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	10	444	2025-04-07 14:35:24	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 9	9	0	202502000001	1837	TUD-0057	1815	1837	TUD-0057	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	17.00	0.00	1126.00	1143.00	0	17.00	1900-01-01	300.00	300.00	300.00	0.00	NONE	UNPAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	11	444	2025-04-21 12:46:19	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 10	10	0	202502000001	1845	TUD-0060	1823	1845	TUD-0060	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	19.00	0.00	226.00	236.00	0	19.00	1900-01-01	340.00	340.00	340.00	0.00	NONE	PAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	12	444	2025-04-15 14:10:39	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 11	11	0	202502000001	1901	TUD-0065	1878	1901	TUD-0065	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	51.00	0.00	1197.00	1248.00	0	51.00	1900-01-01	1190.00	1190.00	1190.00	0.00	NONE	UNPAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	13	444	2025-04-21 12:46:19	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 12	12	0	202502000001	1912	TUD-0069	1889	1912	TUD-0069	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	19.00	0.00	1751.00	1770.00	0	19.00	1900-01-01	340.00	340.00	340.00	0.00	NONE	UNPAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	14	444	2025-04-21 12:46:19	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 13	13	0	202502000001	1918	TUD-0070	1895	1918	TUD-0070	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	10.00	0.00	339.00	349.00	0	10.00	1900-01-01	160.00	160.00	160.00	0.00	NONE	UNPAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	15	444	2025-04-21 12:46:19	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 14	14	0	202502000001	1922	TUD-0071	1899	1922	TUD-0071	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	9.00	0.00	297.00	306.00	0	9.00	1900-01-01	160.00	160.00	0.00	0.00	NONE	PAID	PAYMENT	148250		2025-03-18	160.00	ENTRY	16	444	2025-03-18 14:42:55	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 15	15	0	202502000001	1932	TUD-0074	1909	1932	TUD-0074	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	-168.00	0.00	106.00	107.00	0	-168.00	1900-01-01	NULL	NULL	NULL	0.00	NONE	UNPAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	17	444	2025-04-21 12:44:38	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 16	16	0	202502000001	1945	TUD-0079	1922	1945	TUD-0079	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	14.00	0.00	379.00	393.00	0	14.00	1900-01-01	240.00	240.00	240.00	0.00	NONE	UNPAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	18	444	2025-04-21 12:46:19	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 17	17	0	202502000001	1949	TUD-0080	1926	1949	TUD-0080	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	5.00	0.00	978.00	983.00	0	5.00	1900-01-01	160.00	160.00	0.00	0.00	NONE	PAID	PAYMENT	150725		2025-03-31	160.00	ENTRY	19	444	2025-03-31 14:39:12	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 18	18	0	202502000001	1952	TUD-0081	1929	1952	TUD-0081	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	53.00	0.00	275.00	295.00	0	53.00	1900-01-01	1250.00	1250.00	1250.00	0.00	NONE	UNPAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	20	444	2025-04-21 12:46:19	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 19	19	0	202502000001	1959	TUD-0083	1936	1959	TUD-0083	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	6.00	0.00	190.00	196.00	0	6.00	1900-01-01	160.00	160.00	160.00	0.00	NONE	UNPAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	21	444	2025-04-21 12:46:19	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 20	20	0	202502000001	1963	TUD-0084	1940	1963	TUD-0084	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	7.00	0.00	1304.00	1311.00	0	7.00	1900-01-01	160.00	160.00	160.00	0.00	NONE	PAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	22	444	2025-04-07 14:35:18	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 21	21	0	202502000001	2007	TUD-0094	1984	2007	TUD-0094	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	4.00	0.00	1165.00	1169.00	0	4.00	1900-01-01	160.00	160.00	0.00	0.00	NONE	PAID	PAYMENT	146200		2025-03-12	160.00	ENTRY	23	444	2025-03-12 16:15:57	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 22	22	0	202502000001	2010	TUD-0095	1986	2010	TUD-0095	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	14.00	0.00	342.00	356.00	0	14.00	1900-01-01	240.00	240.00	240.00	0.00	NONE	UNPAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	24	444	2025-04-21 12:46:20	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 23	23	0	202502000001	2016	TUD-0098	1994	2016	TUD-0098	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	-93.00	0.00	112.00	119.00	0	-93.00	1900-01-01	NULL	NULL	NULL	0.00	NONE	UNPAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	25	444	2025-04-21 12:44:38	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 24	24	0	202502000001	2057	TUD-0107	2034	2057	TUD-0107	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	4.00	0.00	348.00	352.00	0	4.00	1900-01-01	160.00	160.00	0.00	0.00	NONE	PAID	PAYMENT	146473		2025-03-12	160.00	ENTRY	26	444	2025-03-12 18:21:14	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 25	25	0	202502000001	2068	TUD-0111	2044	2068	TUD-0111	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	9.00	0.00	346.00	355.00	0	9.00	1900-01-01	160.00	160.00	160.00	0.00	NONE	UNPAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	27	444	2025-04-21 12:46:20	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0
Edit	Copy	Delete DELETE FROM ww_water_billing WHERE `ww_water_billing`.`bill_number` = 26	26	0	202502000001	2069	TUD-0112	2046	2069	TUD-0112	403	NULL	NULL	2025-01-01	2025-01-31	2025-02-01	2025-02-12	0.00	16.00	0.00	304.00	320.00	0	16.00	1900-01-01	280.00	280.00	280.00	0.00	NONE	PAID	PAYMENT	NULL		1900-01-01	0.00	ENTRY	28	444	2025-04-15 14:12:52	0	Manual Reading	1900-01-01	FALSE	NULL	MANUAL	FALSE	NONE	0

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

Connection for controluser as defined in your configuration failed.