dev.surenasolutions.in / 127.0.0.1 / rajkamal_crm / crm_leads

There are no favourite tables.

New
information_schema
mysql
payitsea_jnablr
performance_schema
phpmyadmin
rajkamal_crm
sgm_crm
surena
- surena_code_editor
- surena_crm
- edbroad
  - surena_edbroad_1
  - surena_edbroad_old
test

Customise 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.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customise 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

Customise 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 - 18 (19 total, Query took 0.0006 seconds.)

SELECT * FROM `crm_leads`

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

Filter rows:

Sort by key:

			id	lead_type	customer_company	contact_person	phone	whatsapp	address	city	pincode	source	stage	next_followup	customer_role	next_steps	description	next_action	routed_at	auto_routed	auto_route_json	auto_route_conf	handled_by	branch_id	status	created_by	created_at	updated_at	delete_status
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 1	1	Sales Lead	Surena Traders	Raghav	+91 94835 00003	+91 94835 00003	Gandhi Bazaar	Shivamogga	577201	Promotion Call	New	2025-09-12	Owner	Send quotation with offer	Interested in Arecanut Dehusking Machine	SEND_QUOTATION	2025-10-09 06:21:22	1	{"reason": "Customer asked price/quotation", "conf...	0.91	1	1	Active	1	2025-10-09 06:21:22	2025-10-09 06:21:22	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 2	2	Sales Lead	Annapoorna Agro	Anusha	+91 94835 00002	+91 94835 00002	Ameer Mohalla	Bhadravathi	577201	Referral	Warm	2025-09-11	Purchase	Share brochure & price list	Needs product catalogue for bulk order	SEND_BROCHURE	2025-10-09 06:21:22	1	{"reason": "Brochure/catalogue keywords", "confide...	0.86	2	1	Active	1	2025-10-09 06:21:22	2025-10-09 06:21:22	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 3	3	Sales Lead	GreenFields	Ravi	+91 94835 00003	+91 94835 00003	Sagar Main Road	Sagar	577401	Web	Hot	2025-09-13	Manager	Send quotation with offer	Ready to buy; wants discount	SEND_QUOTATION	2025-10-09 06:21:22	1	{"reason": "Price/offer mentioned", "confidence": ...	0.89	3	1	Active	1	2025-10-09 06:21:22	2025-10-09 06:21:22	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 4	4	Sales Lead	RK Hardware	Kiran	+91 94835 00004	+91 94835 00004	Tirthahalli Market	Tirthahalli	577432	Walk-in	Converted	2025-09-13	Owner	—	Order confirmed (last week)	NONE	NULL	0	NULL	NULL	1	1	Converted	1	2025-10-09 06:21:22	2025-10-09 06:21:22	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 5	5	Service Lead	Surena Agro Machines	Raghav	+91 94835 00007	+91 94835 00007	Vinoba Nagar	Shivamogga	577201	Customer Call	Pending	2025-09-14	Owner	Schedule technician visit	Motor not running; requires inspection	SITE_VISIT	2025-10-09 06:21:22	1	{"reason": "Inspection/visit requested", "confiden...	0.84	2	1	Active	1	2025-10-09 06:21:22	2025-10-09 06:21:22	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 6	6	Service Lead	Rajkamal Traders	Manager	+91 94835 00008	+91 94835 00008	BH Road	Shivamogga	577202	WhatsApp	In Progress	2025-09-15	Manager	Installation visit	Installation scheduled for tomorrow	SITE_VISIT	2025-10-09 06:21:22	1	{"reason": "Installation requires visit", "confide...	0.82	3	1	Active	1	2025-10-09 06:21:22	2025-10-09 06:21:22	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 7	7	Service Lead	Shree Engineering Works	Owner	+91 94835 00009	+91 94835 00009	NH-206	Sagar	577401	Walk-in	New	2025-09-16	Owner	Diagnose on site	Warranty claim for sensor unit	SITE_VISIT	2025-10-09 06:21:22	1	{"reason": "Warranty repair likely on-site", "conf...	0.80	4	1	Active	1	2025-10-09 06:21:22	2025-10-09 06:21:22	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 8	8	Service Lead	ArecaDry Pvt Ltd	Manager	+91 94835 00010	+91 94835 00010	Vinayaka Extension	Tirthahalli	577432	Referral	Completed	2025-09-12	Manager	—	Installation completed successfully	NONE	NULL	0	NULL	NULL	3	1	Closed	1	2025-10-09 06:21:22	2025-10-09 06:21:22	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 1001	1001	Sales Lead	Surena Traders	Raghav	+91 94835 00003	+91 94835 00003	Gandhi Bazaar	Shivamogga	577201	Promotion Call	New	2025-09-12	Owner	Send quotation with offer	Interested in Arecanut Dehusking Machine	SEND_QUOTATION	2025-09-12 09:30:00	1	{"reason": "Price/quotation requested", "confidenc...	0.91	1	1	Active	1	2025-10-09 07:32:01	2025-10-09 07:32:01	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 1002	1002	Sales Lead	Annapoorna Agro	Anusha	+91 94835 00002	+91 94835 00002	Ameer Mohalla	Bhadravathi	577201	Referral	Warm	2025-09-11	Purchase	Share brochure & price list	Needs product catalogue for bulk order	NONE	2025-09-11 09:00:00	1	{"reason": "Brochure/catalog keywords", "confidenc...	0.86	2	1	Active	1	2025-10-09 07:32:01	2025-10-10 09:57:13	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 1003	1003	Sales Lead	GreenFields	Ravi	+91 94835 00003	+91 94835 00003	Sagar Main Road	Sagar	577401	Web	Hot	2025-09-13	Manager	Send quotation with offer	Ready to buy; wants discount	SEND_QUOTATION	2025-09-13 09:15:00	1	{"reason": "Offer/price mentioned", "confidence": ...	0.89	3	1	Active	1	2025-10-09 07:32:01	2025-10-09 07:32:01	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 1004	1004	Service Lead	Surena Agro Machines	Raghav	+91 94835 00007	+91 94835 00007	Vinoba Nagar	Shivamogga	577201	Customer Call	New	2025-09-14	Owner	Schedule technician visit	Motor not running; requires inspection	SITE_VISIT	2025-09-14 09:00:00	1	{"reason": "Inspection requested", "confidence": 0...	0.84	2	1	Active	1	2025-10-09 07:32:01	2025-10-09 07:32:01	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 1005	1005	Service Lead	Rajkamal Traders	Manager	+91 94835 00008	+91 94835 00008	BH Road	Shivamogga	577202	WhatsApp	Technician Assigned	2025-09-15	Manager	Installation visit	Installation scheduled for tomorrow	SITE_VISIT	2025-09-15 09:00:00	1	{"reason": "Installation requires visit", "confide...	0.82	3	1	Active	1	2025-10-09 07:32:01	2025-10-09 07:32:01	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 1006	1006	Service Lead	Shree Engineering Works	Owner	+91 94835 00009	+91 94835 00009	NH-206	Sagar	577401	Walk-in	New	2025-09-16	Owner	Diagnose on site	Warranty claim for sensor unit	SITE_VISIT	2025-09-16 09:00:00	1	{"reason": "Warranty diagnosis on-site", "confiden...	0.80	4	1	Active	1	2025-10-09 07:32:01	2025-10-09 07:32:01	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 1007	1007	Sales Lead	fdf	fff	ffff	fdff	fdff	fdff	577204	Promotion Call	New	NULL	Owner		fdff	SEND_QUOTATION	2025-10-09 12:27:04	0	NULL	NULL	0	1	Active	0	2025-10-09 12:27:04	2025-10-09 12:27:04	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 1008	1008	Sales Lead	fdsf	ffff	fdf	fff	ff	fff	577201	Promotion Call	New	NULL	Owner		NULL	NONE	NULL	0	NULL	NULL	0	1	Active	0	2025-10-09 12:28:05	2025-10-10 09:47:40	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 1009	1009	Service Lead	fdfdf	fff	999	ffff	fdfdf	f	572413		New	NULL			fff	NONE	NULL	0	NULL	NULL	0	1	Active	0	2025-10-09 12:58:02	2025-10-09 12:58:02	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 1010	1010	Sales Lead	gfjffjdj	NULL		NULL	NULL	NULL	NULL	Promotion Call	New	NULL	Owner		NULL	NONE	NULL	0	NULL	NULL	0	1	Active	0	2025-10-10 09:59:31	2025-10-13 13:00:11	0
Edit	Copy	Delete DELETE FROM crm_leads WHERE `crm_leads`.`id` = 1011	1011	Sales Lead	Dlfjjfd	NULL	9999955852	2555522555	fdff	Shfkf	558555	Promotion Call	New	2025-11-15	Owner		dffdf	SEND_QUOTATION	2025-10-15 05:03:38	0	NULL	NULL	0	1	Active	0	2025-10-13 13:14:29	2025-10-15 05:03:38	0

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view