atelier-pierre-garage.tail8a30dc.ts.net / 127.0.0.1 / garage_db_clean / caisse_mouvements

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

SELECT * FROM `caisse_mouvements`

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

Filter rows:

			id	reference	date_operation	libelle	pu	quantite	unite	total_ttc	piece_path	type	montant	mode_paiement	vehicule_id	ref_cheque	fournisseur_nom	motifs	cree_par	created_at	updated_at	piece_original_name	piece_mime	piece_blob	piece_uploaded_at	temp_checked
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 5	5	EC_2	2025-07-09	Approvisionnement caisse	NULL	NULL		NULL	NULL	CREDIT	2013460.00000000000000000000	especes	28	BNI N° 06571995 du 09/07/2025 : 2 013 460 Ar	RIPERT HUGUES MAURICE MAX		iavisoa	2025-12-16 11:36:08	NULL	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 11	11	SC_1	2025-06-12	Crédit Yas	1000.00000000000000000000	1.00000000000000000000	pièce	1000.00000000000000000000	uploads/factures/1765884471_WhatsApp_Image_2025-12...	DEBIT	1000.00000000000000000000	autre	28	Espèces : 865 000 Ar du 05/05/2025	YAS	Entrée stock payée (SC auto)	iavisoa	2025-12-16 14:27:51	NULL	1765884471_WhatsApp_Image_2025-12-15_at_2.29.22_PM...	image/jpeg	[BLOB - 48.1 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 14	14	SC_10	2025-07-08	Essence	5320.00000000000000000000	6.00000000000000000000	litre	31920.00000000000000000000	uploads/factures/1765888981_WhatsApp_Image_2025-12...	DEBIT	31920.00000000000000000000	autre	15	Espèces : 865 000 Ar du 05/05/2025	JOVENA	Entrée stock payée (SC auto)	iavisoa	2025-12-16 15:43:01	NULL	1765888981_WhatsApp_Image_2025-12-15_at_2.29.22_PM...	image/jpeg	[BLOB - 33.4 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 15	15	EC_1	2025-05-05	Approvisionnement caisse	NULL	1.00000000000000000000		NULL	NULL	CREDIT	865000.00000000000000000000	especes	28	Espèces : 865 000 Ar du 05/05/2025	Mathias HAOURET	Avance	iavisoa	2025-12-16 15:45:11	NULL	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 16	16	SC_14	2025-07-09	Remboursement avance Mathias	865000.00000000000000000000	1.00000000000000000000	pièce	865000.00000000000000000000	uploads/factures/1765889265_Capture_d_____cran_202...	DEBIT	865000.00000000000000000000	autre	28	BNI N° 06571995 du 09/07/2025 : 2 013 460 Ar	Mathias HAROUET	Entrée stock payée (SC auto)	iavisoa	2025-12-16 15:47:45	NULL	1765889265_Capture_d_____cran_2025-12-16_154724.pn...	image/png	[BLOB - 645 B]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 17	17	SC_2	2025-06-12	Liquide de refroidissement	75600.00000000000000000000	1.00000000000000000000	boite	75600.00000000000000000000	uploads/factures/1765889481_WhatsApp_Image_2025-12...	DEBIT	75600.00000000000000000000	autre	4	Espèces : 865 000 Ar du 05/05/2025	JOVENA	Entrée stock payée (SC auto)	iavisoa	2025-12-16 15:51:21	NULL	1765889481_WhatsApp_Image_2025-12-15_at_2.29.20_PM...	image/jpeg	[BLOB - 55.2 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 18	18	SC_15	2025-07-10	Essence	5320.00000000000000000000	1.87969924812030000000	litre	10000.00000000000000000000	uploads/factures/1765890019_WhatsApp_Image_2025-12...	DEBIT	10000.00000000000000000000	autre	14	Espèces : 865 000 Ar du 05/05/2025	SHELL AVARADRANO	Entrée stock payée (SC auto)	iavisoa	2025-12-16 16:00:19	NULL	1765890019_WhatsApp_Image_2025-12-15_at_2.29.21_PM...	image/jpeg	[BLOB - 65.8 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 19	19	SC_6	2025-06-13	Essence	5320.00000000000000000000	1.87969924812030000000	litre	10000.00000000000000000000	uploads/factures/1765890338_WhatsApp_Image_2025-12...	DEBIT	10000.00000000000000000000	autre	14	Espèces : 865 000 Ar du 05/05/2025	SHELL AVARADRANO	Entrée stock payée (SC auto)	iavisoa	2025-12-16 16:05:38	NULL	1765890338_WhatsApp_Image_2025-12-15_at_2.29.20_PM...	image/jpeg	[BLOB - 67.3 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 20	20	SC_11	2025-07-08	Essence	5320.00000000000000000000	1.87969924812030000000	litre	10000.00000000000000000000	uploads/factures/1765890680_WhatsApp_Image_2025-12...	DEBIT	10000.00000000000000000000	autre	14	Espèces : 865 000 Ar du 05/05/2025	SHELL AVARADRANO	Entrée stock payée (SC auto)	iavisoa	2025-12-16 16:11:20	NULL	1765890680_WhatsApp_Image_2025-12-15_at_2.29.21_PM...	image/jpeg	[BLOB - 65.8 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 21	21	SC_12	2025-07-08	Fusible	500.00000000000000000000	4.00000000000000000000	pièce	2000.00000000000000000000	uploads/factures/1765890893_WhatsApp_Image_2025-12...	DEBIT	2000.00000000000000000000	autre	4	Espèces : 865 000 Ar du 05/05/2025	SPEED VULCA AMBOHITRARAHABA	Entrée stock payée (SC auto)	iavisoa	2025-12-16 16:14:53	NULL	1765890893_WhatsApp_Image_2025-12-15_at_2.29.21_PM...	image/jpeg	[BLOB - 103.2 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 22	22	SC_7	2025-06-13	DILUANT 416	11000.00000000000000000000	3.00000000000000000000	pièce	33000.00000000000000000000	uploads/factures/1765891992_WhatsApp_Image_2025-12...	DEBIT	33000.00000000000000000000	autre	17	Espèces : 865 000 Ar du 05/05/2025	QUINCAILLERIE DIAMONDRA	Entrée stock payée (SC auto)	iavisoa	2025-12-16 16:33:12	NULL	1765891992_WhatsApp_Image_2025-12-15_at_2.29.19_PM...	image/jpeg	[BLOB - 103.8 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 23	23	SC_3	2025-06-12	Pompe à eau	290000.00000000000000000000	1.00000000000000000000	pièce	290000.00000000000000000000	uploads/factures/1765942946_WhatsApp_Image_2025-12...	DEBIT	290000.00000000000000000000	autre	4	Espèces : 865 000 Ar du 05/05/2025	Auto Pièces SMI	Entrée stock payée (SC auto)	iavisoa	2025-12-17 06:42:26	NULL	1765942946_WhatsApp_Image_2025-12-15_at_2.29.18_PM...	image/jpeg	[BLOB - 86.2 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 24	24	SC_4	2025-06-12	Bougies NGK BP5ESZ	15000.00000000000000000000	4.00000000000000000000	pièce	60000.00000000000000000000	uploads/factures/1765943176_WhatsApp_Image_2025-12...	DEBIT	60000.00000000000000000000	autre	4	Espèces : 865 000 Ar du 05/05/2025	MOBIL AUTOS	Entrée stock payée (SC auto)	iavisoa	2025-12-17 06:46:16	NULL	1765943176_WhatsApp_Image_2025-12-15_at_2.29.18_PM...	image/jpeg	[BLOB - 48.8 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 25	25	SC_8	2025-06-13	Brosse métallique	12000.00000000000000000000	2.00000000000000000000	pièce	24000.00000000000000000000	uploads/factures/1765945332_WhatsApp_Image_2025-12...	DEBIT	24000.00000000000000000000	autre	17	Espèces : 865 000 Ar du 05/05/2025	QUINCAILLERIE DIAMONDRA	Entrée stock payée (SC auto)	iavisoa	2025-12-17 07:22:12	NULL	1765945332_WhatsApp_Image_2025-12-15_at_2.29.19_PM...	image/jpeg	[BLOB - 103.8 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 26	26	SC_9	2025-06-13	Silent Bloc	3000.00000000000000000000	10.00000000000000000000	pièce	30000.00000000000000000000	uploads/factures/1765945636_WhatsApp_Image_2025-12...	DEBIT	30000.00000000000000000000	autre	1	Espèces : 865 000 Ar du 05/05/2025	NULL	Entrée stock payée (SC auto)	iavisoa	2025-12-17 07:27:17	NULL	1765945636_WhatsApp_Image_2025-12-15_at_2.29.19_PM...	image/jpeg	[BLOB - 99.1 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 27	27	SC_13	2025-07-08	Fusible	500.00000000000000000000	1.00000000000000000000	pièce	500.00000000000000000000	uploads/factures/1765945814_WhatsApp_Image_2025-12...	DEBIT	500.00000000000000000000	autre	4	Espèces : 865 000 Ar du 05/05/2025	PIECE AUTO AMBOHITRARAHABA	Entrée stock payée (SC auto)	iavisoa	2025-12-17 07:30:14	NULL	1765945814_WhatsApp_Image_2025-12-15_at_2.29.20_PM...	image/jpeg	[BLOB - 99.5 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 28	28	SC_5	2025-06-12	Frais Mvola	7050.00000000000000000000	1.00000000000000000000	pièce	7050.00000000000000000000	NULL	DEBIT	7050.00000000000000000000	autre	28	Espèces : 865 000 Ar du 05/05/2025	YAS	Entrée stock payée (SC auto)	iavisoa	2025-12-17 07:34:51	NULL	NULL	NULL	NULL	NULL	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 29	29	SC_16	2025-07-10	Rape Carrossier	280000.00000000000000000000	1.00000000000000000000	pièce	280000.00000000000000000000	uploads/factures/1766037207_Capture_d_____cran_202...	DEBIT	280000.00000000000000000000	autre	17	Espèces : 865 000 Ar du 05/05/2025	NULL	Entrée stock payée (SC auto)	iavisoa	2025-12-18 08:53:27	NULL	1766037207_Capture_d_____cran_2025-12-16_154724.pn...	image/png	[BLOB - 645 B]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 30	30	SC_17	2025-07-10	Essence	5320.00000000000000000000	3.75939849624060000000	litre	20000.00000000000000000000	uploads/factures/1766042304_WhatsApp_Image_2025-12...	DEBIT	20000.00000000000000000000	autre	14	BNI N° 06571995 du 09/07/2025 : 2 013 460 Ar	JOVENA ILAFY	Entrée stock payée (SC auto)	iavisoa	2025-12-18 10:18:24	NULL	1766042304_WhatsApp_Image_2025-12-18_at_10.01.33_A...	image/jpeg	[BLOB - 31.9 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 31	31	SC_18	2025-07-10	Essence	5320.00000000000000000000	10.00000000000000000000	litre	53200.00000000000000000000	uploads/factures/1766042599_WhatsApp_Image_2025-12...	DEBIT	53200.00000000000000000000	autre	18	BNI N° 06571995 du 09/07/2025 : 2 013 460 Ar	JOVENA ILAFY	Entrée stock payée (SC auto)	iavisoa	2025-12-18 10:23:19	NULL	1766042599_WhatsApp_Image_2025-12-18_at_10.01.34_A...	image/jpeg	[BLOB - 41.3 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 32	32	SC_19	2025-07-10	Essence	5320.00000000000000000000	10.00000000000000000000	litre	53200.00000000000000000000	uploads/factures/1766042701_WhatsApp_Image_2025-12...	DEBIT	53200.00000000000000000000	autre	15	BNI N° 06571995 du 09/07/2025 : 2 013 460 Ar	JOVENA ILAFY	Entrée stock payée (SC auto)	iavisoa	2025-12-18 10:25:01	NULL	1766042701_WhatsApp_Image_2025-12-18_at_10.01.34_A...	image/jpeg	[BLOB - 44.5 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 33	33	SC_20	2025-07-10	Cable faisceaux	10000.00000000000000000000	6.00000000000000000000	mètre	60000.00000000000000000000	uploads/factures/1766043215_WhatsApp_Image_2025-12...	DEBIT	60000.00000000000000000000	autre	18	BNI N° 06571995 du 09/07/2025 : 2 013 460 Ar	RASOAZANAKOLONA	Entrée stock payée (SC auto)	iavisoa	2025-12-18 10:33:35	NULL	1766043215_WhatsApp_Image_2025-12-18_at_10.01.33_A...	image/jpeg	[BLOB - 92.7 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 34	34	SC_21	2025-07-10	Emballage	8000.00000000000000000000	2.00000000000000000000	kg	16000.00000000000000000000	uploads/factures/1766043309_WhatsApp_Image_2025-12...	DEBIT	16000.00000000000000000000	autre	28	BNI N° 06571995 du 09/07/2025 : 2 013 460 Ar	TRANOMBAROTRA BALI Pav N°2	Entrée stock payée (SC auto)	iavisoa	2025-12-18 10:35:09	NULL	1766043309_WhatsApp_Image_2025-12-18_at_10.01.32_A...	image/jpeg	[BLOB - 89.7 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 35	35	SC_22	2025-07-10	DILUANT 416	11000.00000000000000000000	6.00000000000000000000	pièce	66000.00000000000000000000	uploads/factures/1766043696_WhatsApp_Image_2025-12...	DEBIT	66000.00000000000000000000	autre	17	BNI N° 06571995 du 09/07/2025 : 2 013 460 Ar	QUINCAILLERIE ASMAD	Entrée stock payée (SC auto)	iavisoa	2025-12-18 10:41:36	NULL	1766043696_WhatsApp_Image_2025-12-18_at_10.01.32_A...	image/jpeg	[BLOB - 118.5 KiB]	2026-02-19 06:51:45	1
Edit	Copy	Delete DELETE FROM caisse_mouvements WHERE `caisse_mouvements`.`id` = 36	36	SC_23	2025-07-10	Black 100 Antigravillon	30000.00000000000000000000	4.00000000000000000000	boite	120000.00000000000000000000	uploads/factures/1766043881_WhatsApp_Image_2025-12...	DEBIT	120000.00000000000000000000	autre	17	BNI N° 06571995 du 09/07/2025 : 2 013 460 Ar	QUINCAILLERIE ASMAD	Entrée stock payée (SC auto)	iavisoa	2025-12-18 10:44:41	NULL	1766043881_WhatsApp_Image_2025-12-18_at_10.01.32_A...	image/jpeg	[BLOB - 118.5 KiB]	2026-02-19 06:51:45	1

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view