shackfitness.online / 127.0.0.1 / 918carcare / proforma_invoices

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

SELECT * FROM `proforma_invoices`

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

Filter rows:

Sort by key:

			id	job_card_id	customer_id	quotation_id	proforma_number	subtotal	tax	total_amount	advance_amount	remaining_amount	status	notes	created_at	updated_at	branch_id	sales_vat_exempt	discount
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '049abc5f-2c1e-429b-acd9-b366e2f0f1ca'	049abc5f-2c1e-429b-acd9-b366e2f0f1ca	e4747648-589c-43b5-ad6d-a86833906f16	55a2e017-159f-4266-8c2d-057e19e72ae3	0b71d6f7-6bc2-4cd9-8d4b-4d26eef77f53	PF-2026-077	500.00	0.00	500.00	0.00	500.00	converted	Proforma invoice created from job card JC-2026-007...	2026-03-26 17:19:09	2026-04-01 15:03:45	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '04b4a838-7beb-4e7e-b183-41256ffdc216'	04b4a838-7beb-4e7e-b183-41256ffdc216	805ce045-cf5f-4a68-a21e-c7f8bb1b61ca	58264d95-c3df-48b5-ae38-3577f7e9d877	863392c5-f7b0-4e4b-b645-3bc913ab3d34	PF-2026-064	900.00	0.00	900.00	0.00	900.00	converted	Proforma invoice created from job card JC-2026-006...	2026-03-26 17:03:40	2026-04-01 12:28:34	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '04c80cb9-f195-462c-9c71-6fb144d33626'	04c80cb9-f195-462c-9c71-6fb144d33626	150e997f-438c-4087-9868-3d4870bc15c8	608c2553-0edc-4f5b-98e9-b070fc9975d3	39f73686-56a6-4dae-89c9-f8b1d1017073	PF-2026-087	1500.00	75.00	1575.00	0.00	1575.00	converted	Proforma invoice created from job card JC-2026-008...	2026-03-27 09:34:26	2026-04-01 15:05:11	40e34208-0e98-4c0d-be45-deff7dc0babc	0	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '0735bb59-c386-43f9-9245-61d253613430'	0735bb59-c386-43f9-9245-61d253613430	22387b46-9e57-4774-a8c9-51858780dec1	55a2e017-159f-4266-8c2d-057e19e72ae3	59db78d3-4c2d-4f71-810e-9d036dc280dc	PF-2026-020	800.00	0.00	800.00	0.00	800.00	converted	Proforma invoice created from job card JC-2026-002...	2026-03-26 16:39:25	2026-04-01 14:56:41	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '0797f330-a9fd-4798-8360-d879a74e64b1'	0797f330-a9fd-4798-8360-d879a74e64b1	57fb3e4f-d77d-470a-8459-ff2b06e46d54	55a2e017-159f-4266-8c2d-057e19e72ae3	63c8b636-29a3-440a-9ddb-2df4407106ec	PF-2026-030	500.00	0.00	500.00	0.00	500.00	converted	Proforma invoice created from job card JC-2026-003...	2026-03-26 16:45:47	2026-03-30 11:13:11	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '07d0b561-c24c-4008-858c-e043165778f7'	07d0b561-c24c-4008-858c-e043165778f7	6c64969c-9d35-453c-a799-7e5dfdda152b	55a2e017-159f-4266-8c2d-057e19e72ae3	a2d57b23-8983-4286-80bb-6519072081bf	PF-2026-070	250.00	0.00	250.00	0.00	250.00	converted	Proforma invoice created from job card JC-2026-007...	2026-03-26 17:16:26	2026-04-01 15:02:57	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '089280c8-b7b9-4db5-8fed-3ca21464d381'	089280c8-b7b9-4db5-8fed-3ca21464d381	6e2791bf-4ef7-41db-b2ed-ef0055e0338a	e26e4bbe-4582-46d3-867b-23056ae24d02	afbcc5a7-9db1-41c0-98d5-4af226779adb	PF-2026-048	5500.00	0.00	5500.00	0.00	5500.00	converted	Proforma invoice created from job card JC-2026-004...	2026-03-26 16:56:44	2026-03-30 10:31:07	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '0a911fd4-916b-4457-859b-8221928fe435'	0a911fd4-916b-4457-859b-8221928fe435	e2f86559-eb72-47f4-9a20-9b05b013a078	55a2e017-159f-4266-8c2d-057e19e72ae3	924ac998-fc56-4ff9-b8d3-39ebef455820	PF-2026-033	500.00	0.00	500.00	0.00	500.00	converted	Proforma invoice created from job card JC-2026-003...	2026-03-26 16:47:17	2026-03-30 11:25:23	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '0ab47963-fa22-4602-a7b1-f5db3c80bdb3'	0ab47963-fa22-4602-a7b1-f5db3c80bdb3	65d05830-4677-47d2-83e8-a3dc00f4b0b3	55a2e017-159f-4266-8c2d-057e19e72ae3	aedd6c80-e082-4a4d-a6cf-3e7dddd02683	PF-2026-053	500.00	0.00	500.00	0.00	500.00	converted	Proforma invoice created from job card JC-2026-005...	2026-03-26 16:58:46	2026-03-30 11:36:22	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '0e118118-344b-44f9-9b14-45204d4118e4'	0e118118-344b-44f9-9b14-45204d4118e4	f7c7b2a5-7ff4-481d-9aeb-515f395a3641	af1f2d9c-55bd-4810-a2bf-03ed8e635c20	9c0557cd-3d12-46e9-b4d8-8db16141ee8a	PF-2026-062	2500.00	0.00	2500.00	0.00	2500.00	converted	Proforma invoice created from job card JC-2026-006...	2026-03-26 17:02:48	2026-03-30 11:50:22	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '0efe4c3e-5e84-4604-98a3-544667d77c02'	0efe4c3e-5e84-4604-98a3-544667d77c02	4b4146bf-1bd2-4ab4-846d-12ffff11efc9	ed7fb440-5717-4779-98ec-e361e3ed07b5	ea6e426d-6d78-4eae-903c-2f8f24a0cb6e	PF-2026-055	1800.00	0.00	1800.00	0.00	1800.00	converted	Proforma invoice created from job card JC-2026-005...	2026-03-26 16:59:34	2026-03-30 10:34:38	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '1342c217-7fc5-44ca-8ee9-0ebc7776fd4e'	1342c217-7fc5-44ca-8ee9-0ebc7776fd4e	19406319-31ac-4cae-946b-3a759f2852f3	55a2e017-159f-4266-8c2d-057e19e72ae3	24475aa1-c191-4c55-9315-31a8d547ce9b	PF-2026-022	500.00	0.00	500.00	0.00	500.00	converted	Proforma invoice created from job card JC-2026-002...	2026-03-26 16:40:30	2026-03-30 11:34:09	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '158e7116-e4f2-4655-a8f4-60e54dfa4280'	158e7116-e4f2-4655-a8f4-60e54dfa4280	a3126781-2213-47e2-b855-f33969e99f81	25623d2f-5b2d-4df8-ae2b-182d8882351c	0c0ae755-4524-4716-a6fc-afa56e126758	PF-2026-069	500.00	0.00	500.00	0.00	500.00	converted	Proforma invoice created from job card JC-2026-006...	2026-03-26 17:16:04	2026-03-30 11:50:54	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '1713abce-110e-4938-936a-6335c2a28144'	1713abce-110e-4938-936a-6335c2a28144	ba1a3901-30af-4720-809d-3952b65c5ef5	58264d95-c3df-48b5-ae38-3577f7e9d877	e4f588ce-2410-40a0-b0d9-81a621ed23c3	PF-2026-079	800.00	0.00	800.00	0.00	800.00	converted	Proforma invoice created from job card JC-2026-007...	2026-03-26 17:19:52	2026-04-01 12:33:34	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '17dc916e-99e5-4195-a876-60b1234f39cd'	17dc916e-99e5-4195-a876-60b1234f39cd	c3fe150c-6f10-4430-bdc6-46e63969af71	58264d95-c3df-48b5-ae38-3577f7e9d877	49e15668-f24a-4fe3-93e0-3e2f25afbf13	PF-2026-008	1300.00	0.00	1300.00	0.00	1300.00	converted	Proforma invoice created from job card JC-2026-000...	2026-03-26 16:32:02	2026-03-30 10:48:42	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '20b3d02b-08e2-4f2f-986a-931ac4a42793'	20b3d02b-08e2-4f2f-986a-931ac4a42793	29ab1d7e-f11f-4850-870e-33676b00d315	fb88afdd-870a-4afc-bfc5-8dc0f84bd38b	edec6fa6-ef58-443d-8b45-893160b5fe5d	PF-2026-082	5000.00	0.00	5000.00	0.00	5000.00	converted	Proforma invoice created from job card JC-2026-008...	2026-03-26 17:20:58	2026-04-01 15:04:18	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '2a75e15a-4bf7-47cd-821b-89d73b71cd63'	2a75e15a-4bf7-47cd-821b-89d73b71cd63	657c43e2-f1d9-49dd-bb11-94905b8b3832	55a2e017-159f-4266-8c2d-057e19e72ae3	d435e334-27eb-45af-a103-78d589253e87	PF-2026-078	1000.00	0.00	1000.00	0.00	1000.00	converted	Proforma invoice created from job card JC-2026-007...	2026-03-26 17:19:30	2026-04-01 15:04:01	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '2e065704-fca8-4ca3-b7de-49dbe15f486b'	2e065704-fca8-4ca3-b7de-49dbe15f486b	473b9d58-362c-4f7c-ad5d-487470e1b74b	0ccb5ce6-c2f4-4f0a-b992-8ad108e97ec4	5f9951ad-673c-4e14-949a-2e569f8ee06e	PF-2026-025	6500.00	0.00	6500.00	0.00	6500.00	converted	Proforma invoice created from job card JC-2026-002...	2026-03-26 16:42:54	2026-03-30 11:41:45	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '33795920-6478-48ba-a5f4-adeba72aba4a'	33795920-6478-48ba-a5f4-adeba72aba4a	65d3d071-5385-417e-a136-75030c4eec20	754c19ae-1bf7-4212-8b5f-18d70f0880cb	f52a7b42-ee25-47a0-85b4-c50e593f9fcd	PF-2026-051	1400.00	0.00	1400.00	0.00	1400.00	converted	Proforma invoice created from job card JC-2026-005...	2026-03-26 16:57:57	2026-03-30 11:49:42	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '337e023b-deb2-4307-9fcd-180c9155e834'	337e023b-deb2-4307-9fcd-180c9155e834	665cfae8-d99c-46a6-ae77-60483750d34a	b803184b-b172-4c76-b906-ced0bf9f6b94	26e94fa5-e45a-4ad2-bd69-ebec4efe09f9	PF-2026-019	500.00	0.00	500.00	0.00	500.00	converted	Proforma invoice created from job card JC-2026-001...	2026-03-26 16:38:13	2026-03-30 11:41:11	40e34208-0e98-4c0d-be45-deff7dc0babc	1	200.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '35eeaac5-bf55-435e-8072-94aee7facfe4'	35eeaac5-bf55-435e-8072-94aee7facfe4	4594d26f-f290-4202-8e6b-368eebe4626f	55a2e017-159f-4266-8c2d-057e19e72ae3	fdef25fc-ed4a-4559-aff7-77468c50eb42	PF-2026-029	1000.00	0.00	1000.00	0.00	1000.00	converted	Proforma invoice created from job card JC-2026-002...	2026-03-26 16:45:21	2026-04-01 14:58:23	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '3a75da4d-7a87-4520-b2a2-da5f8f04161c'	3a75da4d-7a87-4520-b2a2-da5f8f04161c	277f9541-aa88-4842-94cf-7e2a9149a702	58264d95-c3df-48b5-ae38-3577f7e9d877	2b1b5b29-243b-4e8a-8214-9d20b5a39b0c	PF-2026-028	1400.00	0.00	1400.00	0.00	1400.00	converted	Proforma invoice created from job card JC-2026-002...	2026-03-26 16:44:22	2026-03-30 10:53:04	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '3b32e824-c8c9-4257-b76c-742d6d3f58a6'	3b32e824-c8c9-4257-b76c-742d6d3f58a6	5e43a828-ab08-4d05-bed4-79f95e456fee	58264d95-c3df-48b5-ae38-3577f7e9d877	5ae29584-3db1-472b-8075-39aa17e4d739	PF-2026-074	1850.00	0.00	1850.00	0.00	1850.00	converted	Proforma invoice created from job card JC-2026-007...	2026-03-26 17:17:59	2026-04-01 12:32:38	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '3cb42e00-a4c8-4478-878e-fc7f8a277791'	3cb42e00-a4c8-4478-878e-fc7f8a277791	a7f05b3d-653c-4ef1-a5a7-6079cb5fd7f5	55a2e017-159f-4266-8c2d-057e19e72ae3	f1665a31-941d-4988-b98a-8b65f629f686	PF-2026-038	500.00	0.00	500.00	0.00	500.00	converted	Proforma invoice created from job card JC-2026-003...	2026-03-26 16:49:38	2026-03-30 11:32:29	40e34208-0e98-4c0d-be45-deff7dc0babc	1	0.00
Edit	Copy	Delete DELETE FROM proforma_invoices WHERE `proforma_invoices`.`id` = '4616307e-6a9c-4c7a-bde4-b93c65214386'	4616307e-6a9c-4c7a-bde4-b93c65214386	6c9b9d05-67bf-4a08-bdbe-1e69f5acbb91	882e8316-6237-49fd-8136-4458ec443d60	5ba0a3eb-01e6-4637-a1ce-81d2c62316f9	PF-2026-092	40.00	2.00	42.00	0.00	42.00	converted	Proforma invoice created from job card JC-2026-009...	2026-04-02 10:23:02	2026-04-02 10:53:33	40e34208-0e98-4c0d-be45-deff7dc0babc	0	10.00

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view