digi-gov.com / 127.0.0.1 / qpsii_waterworks / ww_customer_meter_details

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 (3281 total, Query took 0.0072 seconds.)

SELECT * FROM `ww_customer_meter_details`

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

Filter rows:

			meter_id	applicant_no	acct_no	customer_id	serial_no	meter_number	meter_size	installation_date	inspection_date	installed_by	inspected_by	OR_number	service_status	status	meter_status	meter_remarks	barangay_address	addressID	OR_date	customer_description	brgy_id	or_amount	date_disconnected	time_disconnected	disconnected_by	classification	subName	brand	first_meter_reading	last_meter_reading	remarks	re_connect	date_re_connect	transferred	date_transferred	timestamp
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 1	1	1	NULL	40997	NULL	NULL	NULL	1900-01-01	1900-01-01	0	0		New	New	NULL	NULL	Calaboon	0	1900-01-01	New Customer	5	0.00	1900-01-01	NULL	0	Person	BANZON, ALEJANDRA H.	NULL	0	0	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2024-10-19 02:47:47
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 2	2	2	NULL	41000	3	CAL-0290	NULL	2024-10-18	1900-01-01	159	0		New	New	NULL	NULL	Calaboon	0	1900-01-01	New Customer	5	0.00	1900-01-01	NULL	0	Person	DE LOS SANTOS, MARIFE	yell	1300	1300	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2024-11-13 00:59:35
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 3	3	3	LIO-0438	41059	4	LIO-0438	2	0001-01-01	1900-01-01	0	0		New	New	NULL	NULL	Liong	0	1900-01-01	New Customer	24	0.00	1900-01-01	NULL	0	Person	BELOCURA, ROSARIO	EVER	1807	1807	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2025-01-24 03:47:08
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 4	4	4	1Quirante-12	41067	6	CAL-0291	2	0001-01-01	1900-01-01	0	0		New	New	NULL	NULL	Calaboon	0	1900-01-01	New Customer	5	0.00	1900-01-01	NULL	0	Person	DOMEN, ARCLIE JOY		636	636	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2025-01-24 08:57:40
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 5	5	5	NULL	5	NULL	NULL	2	1900-01-01	1900-01-01	0	0		New	New	NULL	NULL	Liong	0	1900-01-01	New Customer	24	0.00	1900-01-01	NULL	0	Person	CATARAJA, ELENA	NULL	0	0	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2024-10-22 04:02:57
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 6	6	6	LIO-0439	41089	5	LIO-0439	2	0001-01-01	1900-01-01	0	0		New	New	NULL	NULL	Liong	0	1900-01-01	New Customer	24	0.00	1900-01-01	NULL	0	Person	CATARAJA, ELENA	EVER	861	861	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2025-01-24 03:35:48
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 7	7	7	NULL	41094	7	LIO-0442	NULL	2024-10-21	1900-01-01	375	0		New	New	NULL	NULL	Liong	0	1900-01-01	New Customer	24	0.00	1900-01-01	NULL	0	Person	DENIEGA, CATHERINE	EVER	1263	1263	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2024-11-13 00:59:35
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 8	8	8	NULL	41097	10	LIO-0443	NULL	2024-10-21	1900-01-01	375	0		New	New	NULL	NULL	Liong	0	1900-01-01	New Customer	24	0.00	1900-01-01	NULL	0	Person	DENIEGA, GLORIA-M2	EVER	2627	2627	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2024-11-13 00:59:35
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 9	9	9	CAL-0289	2693	1	CAL-0289	2	0001-01-01	1900-01-01	0	0		New	New	NULL	NULL	Calaboon	0	1900-01-01	New Customer	5	0.00	1900-01-01	NULL	0	Person	ALEJANDRA H. BANZON	EVER	306	306	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2025-01-25 02:17:15
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 10	10	10	1Ongotan-1223	10	2846	1Ongotan-1223	2	0001-01-01	1900-01-01	0	0		New	New	NULL	NULL	Calaboon	0	1900-01-01	New Customer	5	0.00	1900-01-01	NULL	0	Person	MALANOG, CATHLYN A.	EVER	853	853	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2025-01-29 06:21:52
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 11	11	11	CAL-0293	11	12	CAL-0293	2	0001-01-01	1900-01-01	0	0		New	New	NULL	NULL	Calaboon	0	1900-01-01	New Customer	5	0.00	1900-01-01	NULL	0	Person	PASIONELA, FRELIN	ever	767	767	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2025-01-29 08:37:58
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 12	12	12	1Ongotan-1221	12	2843	1Ongotan-1221	2	0001-01-01	1900-01-01	0	0		New	New	NULL	NULL	Calaboon	0	1900-01-01	New Customer	5	0.00	1900-01-01	NULL	0	Person	SARDA, JOCELYN P.		1506	1506	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2025-01-29 05:19:57
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 13	13	13	NULL	41111	13	LIO-0444	NULL	2024-10-21	1900-01-01	375	0		New	New	NULL	NULL	Liong	0	1900-01-01	New Customer	24	0.00	1900-01-01	NULL	0	Person	DENIEGA, GLORIA-M3	EVER	1103	1103	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2024-11-13 00:59:35
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 14	14	14	NULL	41114	15	LIO-0445	NULL	2024-10-21	1900-01-01	375	0		New	New	NULL	NULL	Liong	0	1900-01-01	New Customer	24	0.00	1900-01-01	NULL	0	Person	SAYSON, GEMMA	EVER	1374	1374	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2024-11-13 00:59:35
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 15	15	15	NULL	41116	16	LIO-0440	NULL	2024-10-21	1900-01-01	375	0		New	New	NULL	NULL	Liong	0	1900-01-01	New Customer	1	0.00	1900-01-01	NULL	0	Person	DUPAL-AG, FLORDAMAY/RYAN	EVER	0	0	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2024-10-22 07:23:51
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 16	16	16	1Ongotan-12212	16	2840	1Ongotan-12212	2	0001-01-01	1900-01-01	0	0		New	New	NULL	NULL	Calaboon	0	1900-01-01	New Customer	5	0.00	1900-01-01	NULL	0	Person	PATILUNA, FELICIANA	EVER	823	823	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2025-01-29 04:02:48
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 17	17	17	NULL	41120	18	LIO-0446	NULL	2024-10-21	1900-01-01	375	0		New	New	NULL	NULL	Liong	0	1900-01-01	New Customer	24	0.00	1900-01-01	NULL	0	Person	JABALDE, JEFFREY	EVER	1190	1190	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2024-11-13 00:59:35
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 18	18	18	1Ongotan-12333	18	2841	1Ongotan-12333	2	0001-01-01	1900-01-01	0	0		New	New	NULL	NULL	Calaboon	0	1900-01-01	New Customer	5	0.00	1900-01-01	NULL	0	Person	DENOPOL, ELISABETH		1443	1443	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2025-01-29 04:12:40
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 19	19	19	NULL	41126	20	LIO-0441	NULL	2024-10-21	1900-01-01	375	0		New	New	NULL	NULL	Liong	0	1900-01-01	New Customer	24	0.00	1900-01-01	NULL	0	Person	ROJAS, CHONA E.	EVER	0	0	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2024-10-22 07:38:49
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 20	20	20	NULL	41127	21	LIO-0447	NULL	2024-10-21	1900-01-01	375	0		New	New	NULL	NULL	Liong	0	1900-01-01	New Customer	24	0.00	1900-01-01	NULL	0	Person	PEROLINO, AGAPITO	EVER	172	172	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2024-11-13 00:59:35
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 21	21	21	1Ongotan-121	21	2844	1Ongotan-121	2	0001-01-01	1900-01-01	0	0		New	New	NULL	NULL	Calaboon	0	1900-01-01	New Customer	5	0.00	1900-01-01	NULL	0	Person	ENTAC, JOY	EVER	1195	1195	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2025-01-29 05:53:33
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 22	22	22	NULL	41131	23	LIO-0448	NULL	2024-10-21	1900-01-01	375	0		New	New	NULL	NULL	Liong	0	1900-01-01	New Customer	24	0.00	1900-01-01	NULL	0	Person	DENIELA, CLARESSA	EVER	916	916	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2024-11-13 00:59:35
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 23	23	23	1Ongotan-12123	23	24	CAL-0299	2	0001-01-01	1900-01-01	0	0		New	New	NULL	NULL	Calaboon	0	1900-01-01	New Customer	5	0.00	1900-01-01	NULL	0	Person	ALGOSO, JOVENCIO JR.	EVER	0	0	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2025-01-29 07:39:34
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 24	24	24	NULL	41134	25	LIO-0449	NULL	2024-10-21	1900-01-01	375	0		New	New	NULL	NULL	Liong	0	1900-01-01	New Customer	24	0.00	1900-01-01	NULL	0	Person	SECOP, NORBERTO G.	EVER	887	887	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2024-11-13 00:59:35
Edit	Copy	Delete DELETE FROM ww_customer_meter_details WHERE `ww_customer_meter_details`.`meter_id` = 25	25	25	LIO-0450	41135	27	LIO-0450	2	0001-01-01	1900-01-01	0	0		New	New	NULL	NULL	Liong	0	1900-01-01	New Customer	24	0.00	1900-01-01	NULL	0	Person	SINGH, JENNY .	EVER	265	265	NULL	FALSE	1900-01-01	FALSE	1900-01-01	2025-01-24 03:41:34

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.