server.tailade547.ts.net / 127.0.0.1 / ayyub_pos_db / servis

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 :

No bookmarks

Label: Target database: Share this bookmark

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

SELECT * FROM `servis`

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

Filter rows:

Sort by key:

			id	no_nota	cabang_id	pelanggan_id	user_id	teknisi_id	vendor_id	vendor_stage	vendor_tanggal_dikirim	vendor_tanggal_dikerjakan	biaya_approved_by	teknisi_2_id	vendor_nama	vendor_status	vendor_biaya	nama_pelanggan	no_hp_pelanggan	pickup_address	pickup_maps_url	perangkat	sn_perangkat	keluhan	kondisi_fisik	kelengkapan	foto_perangkat	foto_kelengkapan	estimasi_biaya	biaya_jemput	dp	biaya_jasa	biaya_part	biaya_vendor	total_biaya	margin_profit	status	status_pembayaran	jenis_layanan	nota_referensi_garansi	is_locked	tanggal_masuk	tanggal_ambil	keterangan_teknisi	diagnosa	penawaran_syarat Syarat & ketentuan penawaran servis
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 1	1	SRV-260701-4D48	1	132	32	NULL	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	ISTIROHA / RIAN	6285123065105			LAPTOP ACER ONE 14 Z1402-C1RU		Mati total		UNIT, TAS	NULL	NULL	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	BARU	PENDING	REGULER	NULL	0	2026-07-01 13:49:44	NULL			NULL
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 3	3	SRV-260701-6E47	1	70	32	NULL	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	EKA	6281332195590			PRINTER CANON MX328		Tinta tidak keluar		UNIT	NULL	NULL	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	BARU	PENDING	REGULER	NULL	0	2026-07-01 13:51:22	NULL			NULL
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 4	4	SRV-260701-9B5D	1	102	32	NULL	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	ari	6283172216138			LAPTOP ACER ONE		no display / no switch		UNIT	NULL	NULL	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	BARU	PENDING	REGULER	NULL	0	2026-07-01 13:52:07	NULL			NULL
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 5	5	SRV-260701-182D	1	117	32	34	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	JOY	6281273802000			CPU Rakitan		"Tidak nyala Rusak mainboard Penawaran mainboard"		UNIT	NULL	NULL	0.00	0.00	0.00	0.00	520000.00	0.00	520000.00	0.00	PENAWARAN	PENDING	REGULER	NULL	0	2026-07-01 13:52:36	NULL		Case : tidak nyala Analisa : mainboard bermasala...
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 6	6	SRV-260701-9593	1	166	32	NULL	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	Anjani	6288772195615			LAPTOP acer		tidak masuk windows , charger rusak		UNIT, CHARGER	NULL	NULL	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	BARU	PENDING	REGULER	NULL	0	2026-07-01 13:53:52	NULL			NULL
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 7	7	SRV-260701-87B6	1	177	32	33	NULL	TIDAK	NULL	NULL	31	NULL	NULL	TIDAK	0.00	CASH	6280808800880			hardisk		reset		UNIT	NULL	NULL	0.00	0.00	0.00	20000.00	0.00	0.00	20000.00	0.00	DIAMBIL	PENDING	REGULER	NULL	0	2026-07-01 13:56:51	2026-07-01 14:51:50
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 8	8	SRV-260701-8A2C	1	221	32	NULL	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	WILSON	6288706424867			CPU RAKITAN		"tidak masuk windows analisa ram bermasalh"		UNIT	NULL	NULL	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	BARU	PENDING	REGULER	NULL	0	2026-07-01 13:57:33	NULL			NULL
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 9	9	SRV-260701-95C3	1	223	32	34	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	Bsp	628127842573			CPU Rakitan		"Mati total psu bermasalah"		UNIT	NULL	NULL	0.00	0.00	0.00	0.00	320000.00	0.00	320000.00	0.00	PENAWARAN	PENDING	REGULER	NULL	0	2026-07-01 13:58:27	NULL		Mati total Tindakan : Ganti psu (nyala) Keruskan...
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 10	10	SRV-260701-AF5A	1	235	32	NULL	1	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	PT TRI SAPTA JAYA	6281273460497			PRINTER Epson L3210		Hasil print berbayang & banjir		UNIT	NULL	NULL	0.00	0.00	0.00	75000.00	1500000.00	0.00	1575000.00	0.00	PENAWARAN	PENDING	REGULER	NULL	0	2026-07-01 13:59:11	NULL		Case : hasil berbayang & banjir Analisa : sudah d...
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 11	11	SRV-260701-CD73	1	236	32	34	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	DIAN	6285788450596			LAPTOP Fujitsu		Cek lcd		UNIT, CHARGER, TAS	NULL	NULL	0.00	0.00	0.00	200000.00	0.00	0.00	200000.00	0.00	SELESAI	PENDING	REGULER	NULL	0	2026-07-01 13:59:45	NULL	[02/07/2026 11:06 - JUMBO]: Done	Pecah lcd karena jatuh (Lcd beli sendiri) Jasa a...
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 12	12	SRV-260701-FA97	1	237	32	NULL	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	TOMMY	6281274800067			LAPTOP ACER		TIDAK BISA NYALA		UNIT, CHARGER, TAS	NULL	NULL	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	BARU	PENDING	REGULER	NULL	0	2026-07-01 14:00:30	NULL			NULL
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 13	13	SRV-260701-2A94	1	237	32	33	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	TOMMY	6281274800067			LAPTOP Acer aspire v5-471		Tombol spasi tidak bisa diketik & touchpad bermasa...		UNIT, CHARGER, TAS	NULL	NULL	0.00	0.00	0.00	0.00	250000.00	0.00	250000.00	0.00	PENAWARAN_DISETUJUI	PENDING	REGULER	NULL	0	2026-07-01 14:01:09	NULL
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 14	14	SRV-260701-F5F5	1	241	32	33	1	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	TAUFIK	6281994975287			PRINTER Epson L350		Timing belt putus		UNIT	NULL	NULL	0.00	0.00	0.00	0.00	385000.00	0.00	385000.00	0.00	DIAMBIL	PENDING	REGULER	NULL	0	2026-07-01 14:02:59	2026-07-01 14:50:47
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 15	15	SRV-260701-03D5	1	234	32	NULL	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	Irfan hadi	6285609290708			LAPTOP Hp 14		"Cek baterai sudah dilakukan install ulang tetapi...		UNIT	NULL	NULL	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	BARU	PENDING	REGULER	NULL	0	2026-07-01 14:03:46	NULL			NULL
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 16	16	SRV-260701-A168	1	245	32	NULL	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	IDA SANTIKA	6285378170132			LAPTOP ACER		kondisi tes mati, walaupun pake charger		UNIT, CHARGER, TAS	NULL	NULL	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	CANCEL	PENDING	REGULER	NULL	0	2026-07-01 14:04:28	NULL	[02/07/2026 17:23 - AYU PUTRI HANDAYANI] PEMBATAL...		NULL
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 17	17	SRV-260701-6941	1	246	32	34	NULL	TIDAK	NULL	NULL	31	NULL	NULL	TIDAK	0.00	Hafiz	6289654405966			CPU Rakitan		Tidak masuk windows		UNIT	NULL	NULL	0.00	0.00	0.00	75000.00	0.00	0.00	75000.00	0.00	DIAMBIL	LUNAS	REGULER	NULL	0	2026-07-01 14:05:04	2026-07-02 14:37:17		install ulang
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 18	18	SRV-260701-5E3C	1	247	32	33	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	Sintia	6282178522172			LAPTOP Acer aspire one 14		Keyboard bermasalah		UNIT	NULL	NULL	0.00	0.00	0.00	0.00	250000.00	0.00	250000.00	0.00	DIAMBIL	LUNAS	REGULER	NULL	0	2026-07-01 14:05:50	2026-07-02 17:43:01	[02/07/2026 13:25 - FANDI]: Done ganti keyboard
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 19	19	SRV-260701-F7A7	1	156	32	28	NULL	TIDAK	NULL	NULL	31	NULL	NULL	TIDAK	0.00	BADI	6285380931963			LAPTOP LENOVO G40		"LEMOT Install ulang, data udh di backup "		UNIT, CHARGER	NULL	NULL	0.00	0.00	0.00	0.00	100000.00	0.00	100000.00	0.00	DIAMBIL	PENDING	REGULER	NULL	0	2026-07-01 15:33:47	2026-07-01 15:36:15
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 20	20	SRV-260701-94C9	1	50	31	NULL	3	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	PAK ZUL JAKABARING	6281271800777			CCTV		• Penambahan 2 camera untuk dibawah lt.1 • Perbaik...			NULL	NULL	0.00	0.00	1100000.00	0.00	2200000.00	0.00	2200000.00	0.00	PENAWARAN_DISETUJUI	PENDING	REGULER	NULL	0	2026-07-01 15:59:50	NULL	[01/07/2026 20:27 - AYU PUTRI HANDAYANI]: Terima ...
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 21	21	SRV-260702-4147	1	269	34	34	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	Aden	6281367189172			Asus X441X	H5N0CV10P65421G	Word tidak aktif,non aktifkan update dan ngulang t...		Unit dan tas	dev_SRV-260702-4147_6a45d26dd791b.jpg	acc_SRV-260702-4147_6a45d26ea88a2.jpg	0.00	0.00	0.00	35000.00	0.00	0.00	35000.00	0.00	DIAMBIL	LUNAS	REGULER	NULL	0	2026-07-02 09:52:31	2026-07-02 13:47:40	[02/07/2026 09:54 - JUMBO]: Selesai	Aktivasi MS.Office
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 22	22	SRV-260702-40AB	1	270	31	33	NULL	TIDAK	NULL	NULL	31	NULL	NULL	TIDAK	0.00	kemensos	6282269418596			SUPPORT IT		Dokumentasi All AP switch UPS			NULL	NULL	0.00	0.00	0.00	200000.00	0.00	0.00	200000.00	0.00	SELESAI	PENDING	REGULER	NULL	0	2026-07-02 11:03:41	NULL		Dokumentasi All AP switch UPS
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 23	23	SRV-260702-DB99	1	271	32	NULL	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	ALI	628197775773			PRINTER Canon E470		Pasang infus			NULL	NULL	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	BARU	PENDING	REGULER	NULL	0	2026-07-02 13:32:10	NULL			NULL
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 24	24	SRV-260702-C30A	1	216	32	33	NULL	TIDAK	NULL	NULL	NULL	NULL	NULL	TIDAK	0.00	Rendra	6282374242343			LAPTOP Acer aspire es1-432		"Tidak masuk windows(lemot) Penawaran: ssd 128/25...		UNIT, CHARGER	NULL	NULL	0.00	0.00	0.00	0.00	780000.00	0.00	780000.00	0.00	DIAMBIL	PIUTANG	REGULER	NULL	0	2026-07-02 14:07:07	2026-06-26 14:15:38
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 25	25	SRV-260702-F719	1	216	31	NULL	NULL	TIDAK	NULL	NULL	31	NULL	NULL	TIDAK	0.00	Rendra	6282374242343			LAPTOP Acer aspire es1-432		"Tidak masuk windows(lemot) Penawaran: ssd 128/25...		UNIT, CHARGER	NULL	NULL	0.00	0.00	0.00	0.00	380000.00	0.00	380000.00	0.00	DIAMBIL	LUNAS	REGULER	NULL	0	2026-07-02 14:31:10	2026-07-02 14:49:55
Edit	Copy	Delete DELETE FROM servis WHERE `servis`.`id` = 26	26	SRV-260702-86D0	1	270	31	33	8	TIDAK	NULL	NULL	31	NULL	NULL	TIDAK	0.00	kemensos	6282269418596			SUPPORT IT		"- Penarikan 3 kabel access point dari server Seni...			NULL	NULL	0.00	0.00	0.00	0.00	3445000.00	0.00	3445000.00	0.00	SELESAI	PENDING	REGULER	NULL	0	2026-07-02 14:52:32	NULL

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view