digi-gov.com / 127.0.0.1 / qpsii_lguengineering / tbl_resume_order

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

SELECT * FROM `tbl_resume_order`

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

Filter rows:

			id	ref_no	app_date	effective_date	project_id	projectName	projectLoc	resumeNo	suspensionOrderNo	contractor_id	contractor	contract_type	daysUsedtoDate	revisedDueDate	NTPDate	ContractDate	ContractDuration	days_remaining	Subject	Remarks	issue_by	project_in_charge	project_in_chargeID	stat	ts
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 1	1	RO-07-0013-2021	2021-07-26	2021-07-26	1366	Supply of Labor, Materials and Equipment for the P...	Sitio Tapon, Brgy. Tinaan, City of Naga, Cebu	1	1	8986	ISC ENGINEERING SERVICES		22	2021-09-16	2021-05-11	2021-07-25	75	53	This is to formally inform you that your work will...		137	CHRISTIAN DALE CANDIA	208515	Active	2021-07-12 14:22:03
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 2	2	RO-08-0006-2021	2021-08-04	2021-08-04	1439	Supply of Labor, Materials and Equipment for the P...	Brgy, South Pob, City of Naga, Cebu	1	1	10207	NBJ FOODS, INC./NICEY BURGER JUNCTION		0	2021-11-11	2021-08-04	2021-08-04	100	10	sample subject by admin	sample remarks by admin	0	JOHN REINER C. SAROL	78083	CANCELLED	2021-08-04 13:59:59
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 3	3	RO-03-0009-2021	2021-03-01	2021-03-01	1430	Supply of Labor, Materials and Equipment for the C...	East Poblacion, City of Naga Cebu	1	1	4846	TUANSON CONSTRUCTION		10	2021-03-10	2020-12-30	2021-01-18	20	10	The work will be resumed since the revised plan is...		0	France Ian A. Sinajon	1177	Active	2021-10-07 10:00:39
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 4	4	RO-05-0007-2020	2020-05-20	2020-05-21	3416	Supply of Labor, Materials and Equipment for the P...	Cantao-an, City of Naga Cebu	1	1	196	QUIRANTE CONSTRUCTION CORPORATION		52	2021-03-24	2020-02-04	2021-01-28	360	308	This is to formally inform you that your work will...		0	GRACE O. BISMARK	35921	Active	2021-11-17 16:57:48
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 5	5	RO-10-0011-2021	2021-10-11	2021-10-11	649	Supply of Labor, Materials and Equipment for the R...	Barangay Tajaguimit,City of Naga, Cebu	1	1	10156	AT MACROHON CONSTRUCTION COMPANY		93	2021-12-06	2021-11-06	2021-12-06	150	57	You are hereby directed to resume all construction...		0	Rolf Jonquil B. Rivera	137	Active	2021-11-23 08:51:48
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 6	6	RO-07-0012-2021	2021-07-05	2021-07-05	680	Supply of Labor, Materials and Equipment for the P...	Naga SHS, Brgy. West Poblacion City of Naga, Cebu	1	1	10156	AT MACROHON CONSTRUCTION COMPANY		15	2022-10-12	2021-04-19	2022-08-11	480	465	You are hereby directed to resume all constructi...		0	Richard A. Ubas	126	Active	2021-11-23 14:16:56
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 7	7	RO-12-0008-2020	2020-12-21	2020-12-21	1455	Summary of the Approved Budget of Contract for the...	East Poblacion, City of Naga Cebu	1	1	8633	SOLIDCORE CONSTRUCTION		108	2021-05-01	2020-06-19	2021-02-13	240	132	You are hereby directed to resume the activities a...		0	JOJIE ROSE N. SANTILLAN	112953	Active	2021-12-06 09:27:47
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 8	8	RO-02-0001-2022	2020-05-22	2020-05-22	4295	Supply of Labor, Materials and Equipment for the P...	Lanas City of Naga, Cebu	1	1	4846	TUANSON CONSTRUCTION		364	2020-05-31	2019-03-29	2020-04-05	374	10	You are hereby directed to resume all construction...		0	Jocelyn B. Sanchez	643	Active	2022-02-07 11:17:12
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 9	9	RO-03-0002-2020	2020-03-29	2020-06-01	4318	Supply of Labor and Materials for the Proposed Per...	Brgy. Mainit Elementary and Secondary School, City...	1	1	9378	RCV VILLAMOR CONSTRUCTION		61	2020-08-26	2020-05-29	2020-06-26	141	87	You are hereby directed to resume all const...		0	Jocelyn B. Sanchez	643	Active	2022-02-09 13:49:35
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 10	10	RO-05-0003-2020	2020-05-22	2020-05-22	4334	Supply of Labor, Materials and Equipment for the P...	Brgy. Lanas, City of Naga, Cebu	1	1	1331	A.T MACROHON CONSTRUCTION COMPANY		140	2020-06-15	2019-11-08	2020-04-20	165	25	You are hereby directed to resume all construction...		0	Rolf Jonquil B. Rivera	137	Active	2022-02-09 15:43:55
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 11	11	RO-05-0004-2020	2020-05-22	2020-05-22	4326	Supply of Labor and Materials for the Proposed Per...	Bairan, City of Naga Cebu	1	1	1331	A.T MACROHON CONSTRUCTION COMPANY		52	2020-09-06	2020-02-04	2020-07-12	160	108	You are hereby directed to resume all construction...		0	Rolf Jonquil B. Rivera	137	Active	2022-02-10 09:03:23
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 12	12	RO-01-0001-2022	2022-01-06	2022-01-10	4161	Supply of Labor, Materials and Equipment for the P...	East Poblacion, City of Naga Cebu	1	1	10932	E.C. MANUBAG BUILDERS		57	2022-02-26	2021-10-20	2022-02-01	105	48	You are hereby directed to resume all construction...		0	Jocelyn B. Sanchez	643	Active	2022-07-05 15:23:09
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 13	13	RO-06-0002-2022	2022-06-24	2022-06-24	572	Supply of Labor, Materials & Equipment for the Com...	Sitio Ugan, Barangay Lutac,City of Naga Cebu	1	1	10175	LAJ TRUCKING AND BUILDERS INC.		155	2023-03-15	2021-07-19	2022-09-11	420	265	You are hereby directed to resume the activities a...		0	Jojie Rose N. Santillan	143	Active	2022-07-06 15:21:32
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 14	14	RO-01-0003-2022	2022-01-24	2022-01-24	1428	Supply of Labor, Materials and Equipment for the P...	Tangke, City of Naga Cebu	1	1	11320	FDC CONST.		282	2022-03-02	2021-03-10	2022-01-23	320	38	This is to formally inform you that your work will...		0	Jojie Rose N. Santillan	143	Active	2022-07-08 13:56:33
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 15	15	RO-05-0004-2022	2022-05-23	2022-05-03	4562	Supply of Labor, Materials and Equipment for the P...	Lanas, City of Naga Cebu	1	1	10493	MLJ DIAZ BUILDERS INC.		16	2022-10-13	2022-03-08	2022-09-03	180	164	Resume all construction activities of supply of la...		0	Efren Q. Villarin	1350	Active	2022-08-11 09:49:44
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 16	16	RO-08-0025-2022	2022-08-25	2022-08-25	4488	Supply of Labor, Materials & Equipment for the Pro...	South Poblacion, City of Naga Cebu	1	1	10493	MLJ DIAZ BUILDERS INC.	lblPayerType	147	2022-09-17	2022-03-08	2022-08-25	171	24	You are hereby directed to resume the activities a...		0	Jojie Rose N. Santillan	143	Active	2022-08-24 15:48:33
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 17	17	RO-06-0005-2020	2020-06-22	2020-06-22	4661	Supply of Labor, Materials and Equipment for the P...	Lutac National High School, City of Naga Cebu	1	1	196	QUIRANTE CONSTRUCTION CORPORATION		24	2020-11-24	2020-02-04	2020-08-01	180	156	You are hereby directed to resume all construction...		0	JOCELYN B. SANCHEZ	100115	Active	2022-09-02 15:38:15
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 18	18	RO-02-0011-2022	2022-02-28	2022-03-01	4661	Supply of Labor, Materials and Equipment for the P...	Lutac National High School, City of Naga Cebu	2	2	196	QUIRANTE CONSTRUCTION CORPORATION		60	2022-07-08	2020-02-04	2020-12-04	190	130	This is to formally inform you that your w...		0	Grace O. Bismark	642	Active	2022-09-02 15:51:36
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 19	19	RO-05-0012-2022	2022-05-23	2022-05-23	4562	Supply of Labor, Materials and Equipment for the P...	Lanas, City of Naga Cebu	1	2	9637	MLJ DIAZ BUILDERS, INC	lblPayerType	16	2022-11-02	2022-03-08	2022-09-03	180	164	Resume order for all construction activities effec...		0	Efren Q. Villarin	1350	Active	2022-10-24 09:44:30
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 20	20	RO-11-0013-2022	2022-11-28	2022-11-28	4662	Supply of Labor, Materials and Equipment for the P...	Lanas Elementary and Secondary School, Brgy. Lanas...	1	1	11405	GREEN WORLD CONSTRUCTION			2022-12-07	2021-11-19	2022-07-13	240	10	Resume order for the construction activities for t...		0	Efren Q. Villarin	1350	Active	2022-12-02 10:47:06
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 21	21	RO-01-0014-2022	2022-01-13	2022-01-14	1369	Supply of Labor, Materials & Equipment For the Pro...	@ Mendoza St. Extension Brgy. East Poblacion, City...	1	1	10175	LAJ TRUCKING AND BUILDERS INC.		113	2022-03-21	2021-07-19	2022-01-14	180	67	This is to formally inform you that your work will...		0	Grace O. Bismark	642	Active	2022-12-07 17:03:33
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 22	22	RO-06-0016-2022	2022-06-21	2022-06-22	1369	Supply of Labor, Materials & Equipment For the Pro...	@ Mendoza St. Extension Brgy. East Poblacion, City...	2	2	10175	LAJ TRUCKING AND BUILDERS INC.		175	2022-07-28	2022-07-19	2022-04-22	212	37	This is to formally inform you that your work will...		0	Grace O. Bismark	642	Active	2022-12-07 17:49:43
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 23	23	RO-12-0025-2022	2022-12-27	2022-12-28	4661	Supply of Labor, Materials and Equipment for the P...	Lutac National High School, City of Naga Cebu	3	2	196	QUIRANTE CONSTRUCTION CORPORATION		193	2023-01-28	2020-02-04	2022-08-12	225	32	This is to formally inform you that your w...		0	Grace O. Bismark	642	Active	2023-01-03 10:45:23
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 24	24	RO-11-0018-2022	2022-11-11	2022-11-14	3416	Supply of Labor, Materials and Equipment for the P...	Cantao-an, City of Naga Cebu	2	2	9892	QUIRANTE CONSTRUCTION CORP.		234	2023-04-15	2020-02-04	2021-01-28	387	153	This is to formally inform you that your work will...		0	Grace O. Bismark	642	Active	2023-01-17 09:42:28
Edit	Copy	Delete DELETE FROM tbl_resume_order WHERE `tbl_resume_order`.`id` = 25	25	RO-06-0019-2022	2022-06-18	2022-06-18	4372	Supply of Labor, Materials and Tools for the Repla...	East Poblacion, City of Naga Cebu	1	1	12265	E.G. & I CONSTRUCTION CORP		87	2022-06-30	2022-03-08	2022-06-15	100	13		Resume all construc tion activities effective June...	0	Roel B. Ravanes	748	Active	2023-01-18 16:17:57

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.