digi-gov.com / 127.0.0.1 / budget / obr

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

SELECT * FROM `obr`

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

Filter rows:

			ID	OBRDate	OBRNum	Mnth	Byear	Payee	Remarks	DepartmentName	DepartmentID	Address	A_ChargesToAppropriation	A_SupportingDocument	B_ExistenceofAvailableAppropriation	A_CertifiedNameID	A_CertifiedName	A_Position	A_Date	B_CertifiedNameID	B_CertifiedName	B_Position	B_Date	Amount	SourceofFund	UID	FundId	poid	ponum	ProjectId	ProjectRegId	PowId	ProjectName	PowNo	reference	CancelledReason	CancelledByID	Status	TS	IsContinuing	isPosted
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 1	1	2021-09-30	00001	September	2021	KELVIN RAY L. ABABA		1081-Office of the City Accountant	4		0	0	0	103	Ababa, Kelvin Ray Lapining	City Accountant	2021-09-30 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-09-30 00:00:00	175544.750000	General Fund	235	1	0		0	0	0	NULL		OBR-21-09-0001	sample	1	Cancelled	2021-09-30 14:19:08	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 2	2	2021-09-30	00002	September	2021	KELVIN RAY L. ABABA		1081-Office of the City Accountant	4		0	0	0	103	Ababa, Kelvin Ray Lapining	City Accountant	2021-09-30 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-09-30 00:00:00	175544.750000	General Fund	1	1	0		0	0	0	NULL		OBR-21-09-0002	sample	1	Cancelled	2021-09-30 14:59:20	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 3	3	2021-09-30	00003	September	2021	ACONCIA C. BUENAFLOR		4411-Vicente Mendiola Center for Health Officer	28		0	0	0	844	Peñalosa, Camille Fransisco	City Health Officer	2021-09-30 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-09-30 00:00:00	200360.000000	General Fund	1	1	0		0	0	0	NULL		OBR-21-09-0003	sample	235	Cancelled	2021-09-30 15:07:34	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 4	4	2021-10-01	8024	October	2021	Rowena Arnoza	reim. live pigeon for 14th charter celebration	1121-Office of the City Information and Community ...	75		0	0	0	202	Alensonorin, Ruth Rowena Bandola	City Information Officer	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	6160.000000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0004		0	Active	2021-10-01 10:01:51	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 5	5	2021-10-01	8025	October	2021	Denvie Ornamental Plants Garden	pymt. ornamental plants/14th charter day celebrati...	1121-Office of the City Information and Community ...	75		0	0	0	202	Alensonorin, Ruth Rowena Bandola	City Information Officer	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	300000.000000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0005		0	Active	2021-10-01 10:04:15	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 6	6	2021-10-01	8026	October	2021	Cathay Hardware Inc.	pymt. jetmatic hand pump for various barangays ...	1011-Office of the City Mayor	1		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	36000.000000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0006		0	Active	2021-10-01 10:12:29	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 7	7	2021-10-01	8027	October	2021	Naga City Water System Inc	water bill/August 1-31 /Infirmary	1011-Office of the City Mayor	1		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	4950.000000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0007		0	Active	2021-10-01 10:14:31	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 8	8	2021-10-01	8028	October	2021	Naga City Water System Inc	Water bill/July 1-31/PNP2	1011-Office of the City Mayor	1		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	15534.400000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0008		0	Active	2021-10-01 10:15:46	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 9	9	2021-10-01	8029	October	2021	Rowena Arnoza	Reim. bottled water 500ml/underwater clean up	1011-Office of the City Mayor	1		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	4950.000000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0009		0	Active	2021-10-01 10:18:26	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 10	10	2021-10-01	8037	October	2021	Virniel Alinsonorin	Reim. Plaque/project launching Zero Open Defecatio...	4411-Vicente Mendiola Center for Health Officer	28		0	0	0	844	Peñalosa, Camille Fransisco	City Health Officer	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	9000.000000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0010		0	Active	2021-10-01 11:30:50	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 11	11	2021-10-01	8036	October	2021	Miramarts Party Needs	food packs/Turn-over and Acceptance ceremony/road...	1011-Office of the City Mayor	1		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	3500.000000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0011		0	Active	2021-10-01 11:32:29	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 12	12	2021-10-01	8035	October	2021	PLDT	Tel/Internet services for September 17-October 16,...	1912-Commission On Election	46		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	2800.000000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0012		0	Active	2021-10-01 11:35:19	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 13	13	2021-10-01	8034	October	2021	PLDT INC	tel/internet services for August 17-September 16, ...	1181-2-Parole and Probation Office	80		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	2830.630000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0013		0	Active	2021-10-01 11:39:29	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 14	14	2021-10-01	8033	October	2021	Napoleon Lacno Jr	reim. traveling expenses/January - April	8711-Office of the City Agriculture	27		0	0	0	145	Granada, Brenda Arco	Senior Agriculturist	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	1820.000000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0014		0	Active	2021-10-01 11:42:16	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 15	15	2021-10-01	8032	October	2021	Miramarts Party Needs	snacks/Orientation senior citizens vaccination/jul...	7611-Office of the City Social Welfare Officer	77		0	0	0	184	Gabato, Maria Brenda Alinsonorin	Social Welfare Officer	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	28800.000000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0015		0	Active	2021-10-01 11:47:29	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 16	16	2021-10-01	8050	October	2021	GD OIL INC	PYMT. FUEL FOR AMBULANCE PTV F3-T060	1011-Office of the City Mayor	1		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	10751.160000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0016		0	Active	2021-10-01 11:54:13	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 17	17	2021-10-01	8049	October	2021	GD OIL INC	PYMT. FUEL FOR AMBULANCE SKN-607	1011-Office of the City Mayor	1		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	3224.000000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0017		0	Active	2021-10-01 11:56:18	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 18	18	2021-10-01	8048	October	2021	GD OIL INC	PYMT. FUEL FOR AMBULANCE SJW-760	1011-Office of the City Mayor	1		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	5890.000000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0018		0	Active	2021-10-01 11:57:25	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 19	19	2021-10-01	8047	October	2021	GD OIL INC	FUEL FOR DUMPTRUCK SKG-453	1011-Office of the City Mayor	1		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	2480.000000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0019		0	Active	2021-10-01 11:58:19	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 20	20	2021-10-01	8046	October	2021	GD OIL INC	FUEL FOR HILUX ABN-2008	1011-Office of the City Mayor	1		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	9960.800000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0020		0	Active	2021-10-01 11:59:17	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 21	21	2021-10-01	8045	October	2021	GD OIL INC	FUEL FOR MAHINDRA EG-3672	1011-Office of the City Mayor	1		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	8707.230000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0021		0	Active	2021-10-01 12:00:05	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 22	22	2021-10-01	8044	October	2021	GD OIL INC	FUEL FOR HILUX A9-T034	1011-Office of the City Mayor	1		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	8707.200000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0022		0	Active	2021-10-01 12:00:50	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 23	23	2021-10-01	8043	October	2021	GD OIL INC	FUEL FOR ISUZU DMAX-D1-R854	1011-Office of the City Mayor	1		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	10131.840000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0023		0	Active	2021-10-01 12:01:49	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 24	24	2021-10-01	8042	October	2021	GD OIL INC	FUEL FOR HILUX AAH-7143	1011-Office of the City Mayor	1		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	3720.000000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0024		0	Active	2021-10-01 12:02:47	0	0
Edit	Copy	Delete DELETE FROM obr WHERE `obr`.`ID` = 25	25	2021-10-01	8041	October	2021	GD OIL INC	FUEL FOR AMBULANCE SJL-867/COLON	1011-Office of the City Mayor	1		0	0	0	1081	Chiong, Kristine Vanessa Tadiwan	City Mayor	2021-10-01 00:00:00	6	Buenavista, Certeria Villarico	City Budget Officer	2021-10-01 00:00:00	1860.000000	General Fund	142	1	0		0	0	0	NULL		OBR-21-10-0025		0	Active	2021-10-01 12:03:47	0	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.