hectorperez.tail676bba.ts.net / 127.0.0.1 / cepheus_db / work_orders

There are no favorite tables.

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

SELECT * FROM `work_orders`

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

Filter rows:

Sort by key:

			id	num Número de orden Cepheus (ej: 90233083)	contrato_fisico Contrato físico del cliente	nombre_actividad RECUPERAREQUIPO / CORTEMORA / SOPFIBRA / etc.	comentario Contiene MACs, números de equipo, etc.	motivo	fecha_apertura	fecha_asignado	fecha_programado	fecha_entrada	fecha_liquidado NULL mientras esté pendiente	fecha_programacion	fecha_subestado	estado PENDIENTE / COMPLETADA / ANULADA	subestado ASIGNADA TECNICO / etc.	razon_anulacion	razon_cierre	comentario_cierre	alerta_asociada	servicio_primario Si / No	usuario_genero Normalmente: Cepheus (Administrador)	usuario_liquido	supervisor_id	tecnico_id	cliente_id	contrato_servicio	departamento_id	created_at Cuándo se insertó en esta BD	updated_at Última vez que se actualizó el registro
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1253	1253	92289369	NULL	TRASLADOEXTHFC	TRASLADO EXTERNO 2PLAY 150MB Lps625 A NUEVA DIRECC...	NULL	2026-03-13 12:06:23	2026-03-16 00:00:00	NULL	NULL	NULL	NULL	2026-03-17 19:15:25	PENDIENTE	ILOCALIZABLE	NULL	NULL	NULL	NULL	Si	Katherine Alejandra Vallejos Aguilera	NULL	6	167	408831	2177815	2	2026-03-31 00:27:13	2026-03-31 00:27:13
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1254	1254	92406731	404760	SOP	Cable modem con intermitencia. No se presenta fall...	Cable modem con intermitencia	2026-03-22 12:13:17	2026-03-26 00:00:00	NULL	NULL	NULL	2026-03-28 00:00:00	2026-03-26 10:26:32	PENDIENTE	CLIENTE REPROGRAMA	NULL	NULL	NULL	NULL	Si	Josue Emmanuel Landaverde Fuentes	NULL	NULL	NULL	472485	1263218	2	2026-03-31 00:27:13	2026-03-31 00:27:13
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1255	1255	92418462	NULL	INSFIBRA	ORDEN DE INSTALACION DE INTERNET FIBER HOME 200MB ...	NULL	2026-03-23 15:57:45	2026-03-23 00:00:00	NULL	NULL	NULL	NULL	2026-03-23 16:09:30	PENDIENTE	ASIGNADA TECNICO	NULL	NULL	NULL	NULL	Si	Cinthia Lisbeth Hernandez Silva	NULL	2	168	522086	2193241	9	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1256	1256	92422671	NULL	SOP	Revisión de cableado interno. CLIENTE SOLICITA QUE...	Revisión de cableado interno	2026-03-24 08:45:17	2026-03-27 00:00:00	NULL	NULL	NULL	NULL	2026-03-27 06:45:26	PENDIENTE	ASIGNADA TECNICO	NULL	NULL	NULL	NULL	Si	Beberly Zelaya Reyes	NULL	1	169	623431	1708952	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1257	1257	92428860	662896	SOP	Problemas de navegación en internet. cliente repor...	Problemas de navegación en internet	2026-03-24 13:26:02	2026-03-27 00:00:00	NULL	NULL	NULL	NULL	2026-03-27 06:45:26	PENDIENTE	ASIGNADA TECNICO	NULL	NULL	NULL	NULL	Si	Beberly Zelaya Reyes	NULL	1	169	1099105	1910397	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1258	1258	92430451	50241	SOP	Problemas de navegación en internet. Cliente prese...	Problemas de navegación en internet	2026-03-24 14:36:29	2026-03-26 00:00:00	NULL	NULL	NULL	2026-03-29 00:00:00	2026-03-26 08:21:42	PENDIENTE	CLIENTE REPROGRAMA	NULL	NULL	NULL	NULL	Si	Pablo Alexander Ortiz Escobar	NULL	NULL	NULL	1124275	2182657	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1259	1259	92444592	593873	TRASLADOEXTHFC	TRASLADO EXTERNO 3PLAY 140MB Lps780 A NUEVA DIRECC...	NULL	2026-03-25 14:15:31	2026-03-26 00:00:00	NULL	NULL	NULL	NULL	2026-03-27 10:54:16	PENDIENTE	EN PROCESO	NULL	NULL	NULL	NULL	Si	Cinthia Lisbeth Hernandez Silva	NULL	2	170	749152	1769226	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1260	1260	92448075	31842	SOPFIBRA	Mala se?al en TV analogo. cliente presenta fallas ...	Mala señal en TV análogo	2026-03-25 16:38:04	2026-03-25 00:00:00	NULL	NULL	NULL	NULL	2026-03-25 17:05:19	PENDIENTE	ASIGNADA CONTRATISTA	NULL	NULL	NULL	NULL	Si	Pablo Alexander Ortiz Escobar	NULL	10	NULL	743189	2127632	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1261	1261	92449538	596587	SOP	Problemas de navegación en internet. Cliente con p...	Problemas de navegación en internet	2026-03-25 18:14:46	2026-03-27 00:00:00	NULL	NULL	NULL	NULL	2026-03-27 06:45:26	PENDIENTE	ASIGNADA TECNICO	NULL	NULL	NULL	NULL	Si	Leonardo Antonio Cubas Sanchez	NULL	1	169	469834	1699814	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1262	1262	92467775	NULL	SOP	Cable modem offline y sin señal de TV digital y an...	Cable modem offline y sin señal de TV digital y an...	2026-03-26 08:17:11	2026-03-27 00:00:00	NULL	NULL	NULL	NULL	2026-03-27 11:02:07	PENDIENTE	ASIGNADA TECNICO	NULL	NULL	NULL	NULL	Si	Luis Alonso Godines Lainez	NULL	10	171	916047	2178864	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1263	1263	92469046	1315925	INSHFC	ORDEN DE INSTALACION DE UN 3PLAY OTT CCVEO 150MB L...	NULL	2026-03-26 08:21:42	2026-03-27 00:00:00	NULL	2026-03-27 10:50:09	NULL	NULL	2026-03-27 07:39:15	PENDIENTE	EN PROCESO	NULL	NULL	NULL	NULL	Si	Katherine Alejandra Vallejos Aguilera	NULL	1	169	1315885	2194163	9	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1264	1264	92477229	1286402	TVADICIONAL	cliente solicita un tv adicional llamar al 5049344...	NULL	2026-03-26 08:51:45	2026-03-27 00:00:00	NULL	NULL	NULL	NULL	2026-03-27 07:02:04	PENDIENTE	ASIGNADA CONTRATISTA	NULL	NULL	NULL	NULL	Si	Luis Alonso Godines Lainez	NULL	10	NULL	1125503	1963678	9	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1265	1265	92479813	44247	SOP	Cable modem offline y sin señal de TV digital y an...	Cable modem offline y sin señal de TV digital y an...	2026-03-26 09:03:07	2026-03-27 00:00:00	NULL	NULL	NULL	NULL	2026-03-27 07:02:04	PENDIENTE	ASIGNADA CONTRATISTA	NULL	NULL	NULL	NULL	Si	Pablo Alexander Ortiz Escobar	NULL	10	NULL	941383	2164439	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1266	1266	92479959	1315828	INSFIBRA	ORDEN DE INSTALACION DE UN 3PLAY FIBER OTT CCVEO 2...	NULL	2026-03-27 00:00:00	2026-03-27 00:00:00	NULL	NULL	NULL	NULL	2026-03-27 08:42:10	PENDIENTE	ASIGNADA TECNICO	NULL	NULL	NULL	NULL	Si	Cepheus (Administrador)	NULL	1	172	1315768	2193922	9	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1267	1267	92480855	41099	SOP	Problemas de navegación en internet. Cliente prese...	Problemas de navegación en internet	2026-03-26 09:48:51	2026-03-26 00:00:00	NULL	NULL	NULL	NULL	2026-03-26 13:07:28	PENDIENTE	ASIGNADA TECNICO	NULL	NULL	NULL	NULL	Si	Pablo Alexander Ortiz Escobar	NULL	10	171	882791	2154547	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1268	1268	92484606	656123	SOP	Problema con equipo remoto o router. cliente solic...	Problema con equipo remoto o router	2026-03-26 13:09:23	2026-03-27 00:00:00	NULL	NULL	NULL	NULL	2026-03-27 06:45:26	PENDIENTE	ASIGNADA TECNICO	NULL	NULL	NULL	NULL	Si	Beberly Zelaya Reyes	NULL	1	169	961646	1924364	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1269	1269	92486053	617686	SOPFIBRA	Revisión de cableado externo. xamion corta el cabl...	Revisión de cableado externo	2026-03-26 14:06:00	2026-03-27 00:00:00	NULL	NULL	NULL	NULL	2026-03-27 06:51:34	PENDIENTE	ASIGNADA TECNICO	NULL	NULL	NULL	NULL	Si	Javier Enrique Tovar Medina	NULL	2	168	1007087	1732023	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1270	1270	92486073	1315862	INSHFC	ORDEN DE INSTALACION DE UN 3PLAY PVR 150MB Lps650 ...	NULL	2026-03-26 14:06:50	2026-03-26 00:00:00	NULL	NULL	NULL	NULL	2026-03-26 14:55:28	PENDIENTE	ASIGNADA TECNICO	NULL	NULL	NULL	NULL	Si	Katherine Alejandra Vallejos Aguilera	NULL	2	170	1315806	2194006	9	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1271	1271	92486260	431349	SOP	Cable modem con intermitencia y mala señal de TV. ...	Cable modem con intermitencia y mala señal de TV	2026-03-26 14:17:49	2026-03-27 00:00:00	NULL	NULL	NULL	NULL	2026-03-27 11:02:03	PENDIENTE	ASIGNADA TECNICO	NULL	NULL	NULL	NULL	Si	Daniel Antonio Cruz Banegas	NULL	10	171	1072344	1161095	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1272	1272	92487033	596225	SOPFIBRA	Sin señal de cable analógico. cliente reporta tv d...	Sin señal de cable analógico	2026-03-26 14:53:27	2026-03-26 00:00:00	NULL	NULL	NULL	NULL	2026-03-27 10:41:47	PENDIENTE	EN PROCESO	NULL	NULL	NULL	NULL	Si	Luis Alonso Godines Lainez	NULL	2	172	937427	1629354	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1273	1273	92487544	1316015	INSHFC	ORDEN DE INSTALACION DE UN 3PLAY PVR 150MB Lps650 ...	NULL	2026-03-26 15:08:50	2026-03-27 00:00:00	NULL	2026-03-27 09:36:01	NULL	NULL	2026-03-27 08:06:35	PENDIENTE	EN PROCESO	NULL	NULL	NULL	NULL	Si	Katherine Alejandra Vallejos Aguilera	NULL	2	168	1315992	2194386	9	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1274	1274	92488141	NULL	SOPFIBRA	Niveles de fibra alterados. SNR (db) 20.4 UP 33.8 ...	Niveles de fibra alterados	2026-03-26 15:32:35	2026-03-27 00:00:00	NULL	NULL	NULL	NULL	2026-03-27 06:53:34	PENDIENTE	ASIGNADA TECNICO	NULL	NULL	NULL	NULL	Si	Elizabeth Noemi Varela Centeno	NULL	2	168	411070	1906034	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1275	1275	92490567	455426	SOP	Problemas de navegación en internet. Cliente repor...	Problemas de navegación en internet	2026-03-26 17:18:32	2026-03-27 00:00:00	NULL	2026-03-27 11:01:53	NULL	NULL	2026-03-27 11:01:02	PENDIENTE	EN PROCESO	NULL	NULL	NULL	NULL	Si	Edwin Geovany Guardado Garcia	NULL	2	170	431031	1412105	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1276	1276	92492219	512202	CMOFFLINE	cliente sin servicio de internet indica que no enc...	NULL	2026-03-26 20:20:11	2026-03-27 00:00:00	NULL	NULL	NULL	NULL	2026-03-27 06:45:26	PENDIENTE	ASIGNADA TECNICO	NULL	NULL	NULL	NULL	Si	Hermes Jovel Aceituno Zavala	NULL	1	169	828395	1569239	2	2026-03-31 00:27:14	2026-03-31 00:27:14
Edit	Copy	Delete DELETE FROM work_orders WHERE `work_orders`.`id` = 1277	1277	92492668	NULL	CMOFFLINE	cliente sin señal de internet, se valida sin falla...	NULL	2026-03-27 07:52:41	2026-03-27 00:00:00	NULL	NULL	NULL	NULL	2026-03-27 10:23:53	PENDIENTE	ASIGNADA TECNICO	NULL	NULL	NULL	NULL	Si	Julio Cesar Rico Herrera	NULL	1	170	412884	2192106	2	2026-03-31 00:27:14	2026-03-31 00:27:14

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view