Batch Edit: Add support for editing simple fields

[sharadsw]

Component of #4929

Batch Edit Workflow

• Create a Query for the data you want to edit
• Click on Batch Edit in the query results
• Update any values
• Validate
• Valid edited cells highlight as Updated Cell if its a simple field
• Click on commit to apply the changes

Features

• Users must be able to batch edit data from a query
• Add Batch Edit as an option in the sidebar
• Allow batch editing simple fields in a table
• Enable rollback for edited fields
• Add permissions for Batch Edit
  • Users without the Batch Edit permission cannot access Batch Edit

Additional context from #4929:

Modifying any field is possible, other than nodenumber, fullname, and highestchildnodenumber. If some fields get updated, only those fields are highlighted

[realVinayak]

Not sure about the direction you'd want to go in, but, just for clarity, if you were to hardcode this to True. Hopefully the rest of the code is self-documenting like that.

specify7/specifyweb/stored_queries/batch_edit.py

Line 1108 in 2d86ba4

omit_relationships = not has_target_permission(

Hardcoding this to True will make relationships readonly. I think there's more value in it (copying values from COA to CO) etc.

it'll always make all relationships readonly be default. I added that feature bc Jim requested a permission to retrict people from arbitarily changing relationships.

[realVinayak]

Modifying any field is possible, other than nodenumber, fullname, and highestchildnodenumber. If some fields get updated, only those fields are highlighted

This list is slightly outdated. Look at

specify7/specifyweb/stored_queries/batch_edit.py

Lines 61 to 72 in 2d86ba4

	READONLY_TABLES = [*CONCRETE_HIERARCHY]
	SHARED_READONLY_FIELDS = [
	"timestampcreated",
	"timestampmodified",
	"version",
	"nodenumber",
	"highestchildnodenumber",
	"rankid",
	"fullname",
	]