rsnubanyuwangi.rumah-sakit.online / localhost / rsnucare / kartu_stok

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

SELECT * FROM `kartu_stok`

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

Filter rows:

			id	noRefference	tanggal	idUser	idProduk	idStore	currentStok	barangMasuk	barangKeluar	hargaSatuan	jenisTrx penerimaan,mutasi,retur,waste,penjualan	type gudang / store / apotek
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 136740	136740	0	2023-06-06	400	B00015	3	500	NULL	1	990	PENJUALAN	APOTEK
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 136755	136755	0	2023-06-06	400	B00005	3	500	NULL	1	205000	PENJUALAN	APOTEK
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192248	192248	TR-2306074040001	2023-06-07	404	B00382	NULL	3700	NULL	100	822	MUTASI	GUDANG
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192249	192249	TR-2306074040001	2023-06-07	404	B00503	NULL	500	NULL	500	6660	MUTASI	GUDANG
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192250	192250	TR-2306074040001	2023-06-07	404	B01739	NULL	500	NULL	500	4218	MUTASI	GUDANG
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192251	192251	TR-2306074040001	2023-06-07	404	B00382	NULL	4032	100	NULL	822	MUTASI	APOTEK
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192252	192252	TR-2306074040001	2023-06-07	404	B00503	NULL	1052	500	NULL	6660	MUTASI	APOTEK
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192253	192253	TR-2306074040001	2023-06-07	404	B01739	NULL	456	500	NULL	4218	MUTASI	APOTEK
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192356	192356	TR-2306074040002	2023-06-07	404	B00631	NULL	400	NULL	200	87	MUTASI	GUDANG
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192357	192357	TR-2306074040002	2023-06-07	404	B00631	NULL	261	200	NULL	87	MUTASI	APOTEK
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192398	192398	TR-2306074040003	2023-06-07	404	B00942	NULL	500	NULL	490	10823	MUTASI	GUDANG
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192399	192399	TR-2306074040003	2023-06-07	404	B00635	NULL	500	NULL	350	3366	MUTASI	GUDANG
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192400	192400	TR-2306074040003	2023-06-07	404	B01050	NULL	500	NULL	500	19425	MUTASI	GUDANG
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192401	192401	TR-2306074040003	2023-06-07	404	B00154	NULL	500	NULL	30	4440	MUTASI	GUDANG
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192402	192402	TR-2306074040003	2023-06-07	404	B01821	NULL	500	NULL	480	37185	MUTASI	GUDANG
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192403	192403	TR-2306074040003	2023-06-07	404	B01831	NULL	80	NULL	80	1832	MUTASI	GUDANG
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192404	192404	TR-2306074040003	2023-06-07	404	B00942	NULL	503	490	NULL	10823	MUTASI	APOTEK
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192405	192405	TR-2306074040003	2023-06-07	404	B00635	NULL	500	350	NULL	3366	MUTASI	APOTEK
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192406	192406	TR-2306074040003	2023-06-07	404	B01050	NULL	477	500	NULL	19425	MUTASI	APOTEK
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192407	192407	TR-2306074040003	2023-06-07	404	B00154	NULL	434	30	NULL	4440	MUTASI	APOTEK
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192408	192408	TR-2306074040003	2023-06-07	404	B01821	NULL	499	480	NULL	37185	MUTASI	APOTEK
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192409	192409	TR-2306074040003	2023-06-07	404	B01831	NULL	134	80	NULL	1832	MUTASI	APOTEK
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192657	192657	TR-2306074040004	2023-06-07	404	B01324	NULL	520	NULL	520	513	MUTASI	GUDANG
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192658	192658	TR-2306074040004	2023-06-07	404	B01324	NULL	-285	520	NULL	513	MUTASI	APOTEK
Edit	Copy	Delete DELETE FROM kartu_stok WHERE `kartu_stok`.`id` = 192667	192667	FAR2306050214	2023-06-07	400	B02229	NULL	497	1	NULL	71207	RETUR	APOTEK

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view