digi-gov.com / 127.0.0.1 / qpsii_lguprocurement / pow_main_individual

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 - 22 (23 total, Query took 0.0037 seconds.)

SELECT * FROM `pow_main_individual`

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

Filter rows:

			id	pow_numbering	series	reference_no	reference_date	department_id	project_id	activity_id	activity_date	department_name	project_title	project_loc	project_loc_barangay	project_loc_CityProvince	project_desc	rationale	project_start	project_end	mode_proc	mode_proc_id	modeImplementation	pow_type	appropriation	sof_id	sof	issued_obligated	authority	project_duration	savedate	status	happroved	browsed	Earmark	bidamount	frm	userid	userdeptid	TXN	guid	IsBreakEditable	IsABCEditable	DirectCost	OCM	CProfit	Vat	TotalItemCost	withBreakdown	approve_userid
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 1	1		NULL	CPDC2025050114	2025-05-09	1	249	0	NULL	1011 - Office of the Municipal Mayor	Purchase of supplies for LDDRRM Office	Dumanjug, Cebu	Balaygtiki	Dumanjug		NULL	2025-05-09	2025-06-09	NULL	0	Administration	Others	1000	NULL	NULL	NULL	NULL	32	2025-05-09 10:13:28	Approved	0	0	0.000000	0	POW	0	0	NULL	ca4b2cea-aaa7-4e42-a977-2862229a02bf	False	False	0	0	0	0	0	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 2	2		0001	MO-05-0001-2025	2025-05-15	1	0	0	2025-05-15	Office Of The City Mayor	sample	NULL	NULL	NULL		sample	NULL	NULL	NULL	0	NULL	NULL	2333	NULL	NULL	NULL	NULL	NULL	2025-05-15 15:31:47	ACTIVE	1	0	0.000000	NULL	PROPOSAL	1	1	MO-05-0001-2025		False	False	2333	0	0	0	2333	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 3	3		NULL		2025-05-19	1	0	0	NULL	1011 - Office of the Municipal Mayor	sample	Dumanjug, Cebu	CENTRAL POBLACION	City of Naga	sample	NULL	2025-05-15	2025-05-08	Limited Source Bidding	0	Straight Contract	Repairs and Maintenance	48	NULL	NULL	NULL	NULL	-6	2025-05-19 15:15:30	Approved	0	0	0.000000	46	POW	0	0	NULL	fb38a7e4-f990-40db-8b4a-720266f2a79f	True	True	0	0	0	0	0	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 4	4		0002	MO-05-0002-2025	2025-05-20	1	0	0	2025-05-20	Office Of The City Mayor	sample	NULL	NULL	NULL	sample	sample	NULL	NULL	NULL	0	NULL	NULL	6	NULL	NULL	NULL	NULL	NULL	2025-05-20 09:48:04	ACTIVE	1	0	0.000000	NULL	PROPOSAL	1	1	MO-05-0002-2025		False	False	6	0	0	0	6	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 5	5		NULL	CPD-05-0001-2025	2025-05-22	2	12002	0	NULL	1031 - Office of the City Administrator	Heart-to-H.E.A.R.T. Talk	Dumanjug, Cebu	EAST POBLACION	City of Naga	Sample	NULL	2025-05-22	2025-05-31	NULL	0	Straight Contract	RESIDENTIAL	16522.37	NULL	NULL	NULL	NULL	10	2025-05-22 14:33:39	Approved	0	0	0.000000	432	POW	0	0	NULL	2efdb80c-813f-42bd-8a17-4099c5ef815d	True	True	0	0	0	0	0	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 6	6		0001	ADMIN-05-0001-2025	2025-05-22	1	0	0	2025-05-22	Office of the City Administrator	Sample1	NULL	NULL	NULL	Sample1	Sample1	NULL	NULL	NULL	0	NULL	NULL	12075	NULL	NULL	NULL	NULL	NULL	2025-05-22 14:36:02	ACTIVE	1	0	0.000000	NULL	PROPOSAL	1	1	ADMIN-05-0001-2025		False	False	12075	0	0	0	12075	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 7	7		0003	MO-05-0003-2025	2025-05-22	1	0	0	2025-05-22	Office Of The City Mayor	samplep123	NULL	NULL	NULL	sample	samplep123	NULL	NULL	NULL	0	NULL	NULL	12	NULL	NULL	NULL	NULL	NULL	2025-05-22 14:51:32	ACTIVE	1	0	0.000000	NULL	PROPOSAL	1	1	MO-05-0003-2025		False	False	12	0	0	0	12	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 8	8		0004	MO-05-0004-2025	2025-05-28	2	0	0	2025-05-28	Office of the City Administrator	sample	NULL	NULL	NULL	sample	sample	NULL	NULL	NULL	0	NULL	NULL	120	NULL	NULL	NULL	NULL	NULL	2025-05-28 14:31:56	ACTIVE	1	0	0.000000	NULL	PROPOSAL	1	1	MO-05-0004-2025		False	False	0	0	0	0	0	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 9	9		0001	MO-06-0001-2025	2025-06-04	3	0	0	2025-06-04	Office of the City Vice Mayor	sampleproject12	NULL	NULL	NULL	sampleproject12	sampleproject12	NULL	NULL	NULL	0	NULL	NULL	122	NULL	NULL	NULL	NULL	NULL	2025-06-04 10:01:35	Approved	1	0	0.000000	2000000	PROPOSAL	1	1	MO-06-0001-2025		False	False	0	0	0	0	0	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 10	10		NULL	MO-06-0001-2025	2025-06-04	1	12087	0	NULL	1011 - Office Of The City Mayor	sampleproject12	Dumanjug, Cebu	WEST POBLACION	City of Naga	sampleproject12	NULL	2025-06-04	2025-06-05	NULL	0	Administration	WAREHOUSE	2	NULL	NULL	NULL	NULL	2	2025-06-04 11:21:24	Approved	0	0	0.000000	2	POW	0	0	NULL	b079ba64-1cb8-4475-98e9-ad3ffa14e743	True	True	0	0	0	0	0	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 11	11		0001	ACCTNG-06-0001-2025	2025-06-04	4	0	0	2025-06-04	Office of the Municipal Accountant	sampleproject12	NULL	NULL	NULL	sampleproject12	sampleproject12	NULL	NULL	NULL	0	NULL	NULL	122	NULL	NULL	NULL	NULL	NULL	2025-06-04 11:27:43	Approved	1	0	0.000000	NULL	PROPOSAL	1	1	ACCTNG-06-0001-2025		False	False	0	0	0	0	0	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 12	12		0003	MO-06-0003-2025	2025-06-04	1	0	0	2025-06-04	Office Of The City Mayor	project1	NULL	NULL	NULL	project1	project1	NULL	NULL	NULL	0	NULL	NULL	1341360	NULL	NULL	NULL	NULL	NULL	2025-06-04 13:16:41	Approved	1	0	0.000000	NULL	PROPOSAL	1	1	MO-06-0003-2025		False	False	1341360	0	0	0	1341360	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 13	13		0004	MO-06-0004-2025	2025-06-04	1	0	0	NULL	Office Of The City Mayor	project1	NULL	NULL	NULL		project1	NULL	NULL	NULL	0	NULL	NULL	288	NULL	NULL	NULL	NULL	NULL	2025-06-04 13:18:01	Approved	1	0	0.000000	NULL	PROPOSAL	1	1	MO-06-0004-2025		False	False	288	0	0	0	288	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 14	14		0005	MO-06-0005-2025	2025-06-16	1	0	0	2025-06-16	Office of the Municipal Mayor	sampleproj123	NULL	NULL	NULL	sampleproj12	sampleproj123	NULL	NULL	NULL	0	NULL	NULL	123	NULL	NULL	NULL	NULL	NULL	2025-06-16 09:56:25	Approved	1	0	0.000000	NULL	PROPOSAL	1	1	MO-06-0005-2025		False	False	68	0	0	0	68	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 15	15		0006	MO-06-0006-2025	2025-06-16	1	0	0	2025-06-16	Office of the Municipal Mayor	qwertty	NULL	NULL	NULL	qwertty	qwertty	NULL	NULL	NULL	0	NULL	NULL	123	NULL	NULL	NULL	NULL	NULL	2025-06-16 11:11:51	Approved	1	0	0.000000	NULL	PROPOSAL	1	1	MO-06-0006-2025		False	False	9	0	0	0	9	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 16	16		NULL	CPDC2025060118	2025-06-11	1	12092	0	NULL	1011 - Office of the Municipal Mayor	sampleprof	Dumanjug, Cebu	WEST POBLACION	City of Naga	sampleprof	NULL	2025-06-11	2025-06-11	Limited Source Bidding	0	Straight Contract	RESIDENTIAL	123	NULL	NULL	NULL	NULL	1	2025-06-17 14:14:24	Approved	0	0	0.000000	2222	POW	0	0	NULL	c6cc3e68-81b4-4705-a89f-30743202679e	False	True	0	0	0	0	0	Yes	1
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 17	17		0001	2025-06-0010	2025-06-23	1	0	0	NULL	1011 - Office of the Municipal Mayor	sample12333	Dumanjug, Cebu	SOUTH POBLACION	City of Naga	sample12333	NULL	2025-06-04	2025-06-04	NULL	0	Straight Contract	Repairs and Maintenance	123	NULL	NULL	NULL	NULL	1	2025-06-23 16:33:06	ACTIVE	0	0	0.000000	123	POW	0	0	NULL	1d1a0a19-7dab-47d8-8caa-bad02f46ef2e	True	True	0	0	0	0	0	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 18	18		0001	2025-06-0001	2025-06-24	1	0	0	NULL	1011 - Office of the Municipal Mayor	asdasd	Dumanjug, Cebu	WEST POBLACION	City of Naga	adaada	NULL	2025-06-24	2025-06-24	NULL	0	Administration	WAREHOUSE	123	NULL	NULL	NULL	NULL	1	2025-06-24 10:45:41	CANCELLED	0	0	0.000000	123	POW	0	0	NULL	25e617aa-11eb-46d7-addc-a8417088fe98	True	True	0	0	0	0	0	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 19	19		NULL	2025-06-0027	2025-06-24	1	12095	0	NULL	1011 - Office of the Municipal Mayor	newsample	Dumanjug, Cebu	NORTH POBLACION	City of Naga	newsample	NULL	2025-06-24	2025-06-24	Limited Source Bidding	0	Straight Contract	FLORA EDUCATIONAL GARDEN	120	NULL	NULL	NULL	NULL	1	2025-06-24 11:52:16	Approved	0	0	0.000000	120	POW	0	0	NULL	39e9a54c-bdf2-4916-96d9-660d30702e86	False	True	0	0	0	0	0	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 20	20		NULL	2025-06-0028	2025-06-24	1	12096	0	NULL	1011 - Office of the Municipal Mayor	new1sample	Dumanjug, Cebu			new1sample	NULL	2025-06-24	2025-06-24	NULL	0	Straight Contract	FLORA EDUCATIONAL GARDEN	120	NULL	NULL	NULL	NULL	1	2025-06-24 12:47:40	Approved	0	0	0.000000	120	POW	0	0	NULL	0f572db4-3c8c-4f49-9fee-eb9516f22e98	False	True	0	0	0	0	0	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 21	21		NULL	2025-06-0121	2025-06-24	1	12097	0	NULL	1011 - Office of the Municipal Mayor	samplesample	Dumanjug, Cebu	SOUTH POBLACION	City of Naga	samplesample	NULL	2025-06-24	2025-06-24	NULL	0	Administration	WAREHOUSE	120	NULL	NULL	NULL	NULL	1	2025-06-24 13:24:45	ACTIVE	0	0	0.000000	120	POW	0	0	NULL	75c94f9d-1c06-4a19-bc19-cab3a56ab8fc	False	True	0	0	0	0	0	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 22	22		NULL	2025-06-0122	2025-06-30	1	12098	0	NULL	1011 - Office of the Municipal Mayor	newsampleproject112	Dumanjug, Cebu	SOUTH POBLACION	City of Naga	newsampleproject112	NULL	2025-06-11	2025-06-30	NULL	0	Straight Contract	Repairs and Maintenance	12	NULL	NULL	NULL	NULL	20	2025-06-30 16:37:32	ACTIVE	1	0	0.000000	12	POW	1	0	NULL	79a15a87-39a4-4731-b3cf-7f25e5bb9b0a	False	True	0	0	0	0	0	Yes	0
Edit	Copy	Delete DELETE FROM pow_main_individual WHERE `pow_main_individual`.`id` = 23	23		NULL	2025-07-0123	2025-07-28	1	12099	0	NULL	1011 - Office of the Municipal Mayor	samplenewprojectforproc	Dumanjug, Cebu	CENTRAL POBLACION	City of Naga	samplenewprojectforproc	NULL	2025-07-28	2025-07-16	Limited Source Bidding	0	Straight Contract	RESIDENTIAL	123	NULL	NULL	NULL	NULL	-11	2025-07-28 11:02:26	Approved	1	0	0.000000	123	POW	1	0	NULL	1b0af34a-6fee-4e8d-a749-cb885c5a849c	False	True	0	0	0	0	0	Yes	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.