Skip to content

Z_DescribeTable.php should be moved to ./includes/ #729

New issue
New issue
Open
Open
Z_DescribeTable.php should be moved to ./includes/#729
@dalers

Description

@dalers
dalers
opened on Oct 14, 2025

Z_DescribeTable.php is used by Z_ImportPartCodes.php (among other scripts), but it can't be used as a stand-alone script because it needs a table name and does not itself have the ability to select or specify one.

Because it cannot be used stand-alone, Z_DescribeTable.php should be renamed to simply "DescribeTable.php", moved to the ./includes/ directory and all referencing scripts updated accordingly.

First discussed in #281 (comment).

Fwiw, searching the project source for Z_DescribeTable returns:

Found 211 matches of Z_DescribeTable in 46 files.	
Z_ImportGLAccountGroups.php	
		 '<a href="' . $RootPath . '/Z_DescribeTable.php?table=accountsection">' . __('The field names can be found here'). '</a>', 'info');      [position 70:32]	
Z_ImportGLAccountSections.php	
		 '<a href="' . $RootPath . '/Z_DescribeTable.php?table=accountsection">' . __('The field names can be found here'). '</a>', 'info');      [position 74:32]	
Z_ImportPartCodes.php	
			 '<a href="' . $RootPath . '/Z_DescribeTable.php?table=stockmaster">' . __('The field names can be found here'). '</a>', 'info');      [position 80:33]	
api_xml-rpc_definition.php	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=debtorsmaster">' . __('here ') . '</a>'      [position 119:58]	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=custbranch">' . __('here ') . '</a>'      [position 160:58]	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=debtorsmaster">' . __('here ') . '</a>'      [position 199:58]	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=custbranch">' . __('here ') . '</a>'      [position 239:58]	
	. '<a href="../../Z_DescribeTable.php?table=custbranch">' . __('custbranch table. ') . '</a>'      [position 323:20]	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=debtorsmaster">' . __('here ') . '</a>'      [position 393:58]	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=salestypes">' . __('here ') . '</a>'      [position 568:58]	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=debtortrans">' . __('here ') . '</a>'      [position 1324:58]	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=salesorders">' . __('here ') . '</a>'      [position 1399:58]	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=salesorders">' . __('here ') . '</a>'      [position 1471:58]	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=salesorderdetails">' . __('here ') . '</a>'      [position 1508:58]	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=salesorderdetails">' . __('here ') . '</a>'      [position 1546:58]	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=suppliers">' . __('here ') . '</a>'      [position 2662:58]	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=suppliers">' . __('here ') . '</a>'      [position 2701:58]	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=purchdata">' . __('here ') . '</a>'      [position 3001:58]	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=purchdata">' . __('here ') . '</a>'      [position 3040:58]	
	. __('The field names can be found ') . '<a href="../../Z_DescribeTable.php?table=workorders">' . __('here ') . '</a>'      [position 3079:58]	
	. __('The field names can be found ') . '<a href="http://89.117.50.48/zerp1/Z_DescribeTable.php?table=salesorders">' . __('here ') . '</a>'      [position 3569:78]	
CHANGELOG_ARCHIVE.md	
| Z_DescribeTable.php - Change to lower case html and remove                                                                                                                                                                                 ...      [position 2814:3]	
scripts.sql	
INSERT INTO `scripts` VALUES ('AccountGroups.php',10,'Defines the groupings of general ledger accounts'),('AccountSections.php',10,'Defines the sections in the general ledger reports'),('AddCustomerContacts.php',3,'Adds customer contacts...      [position 2:37303]	
demo.sql	
INSERT INTO `scripts` (`script`, `pagesecurity`, `description`) VALUES ('AccountGroups.php',10,'Defines the groupings of general ledger accounts'),('AccountSections.php',10,'Defines the sections in the general ledger reports'),('AddCusto...      [position 1252:37283]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.pot	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: Z_DescribeTable.php:4      [position 41352:4]	
#: Z_DescribeTable.php:11 api/api_xml-rpc.php:2457 api/api_xml-rpc.php:2625      [position 41356:4]	
#: Z_DescribeTable.php:12      [position 41360:4]	
#: Z_DescribeTable.php:13      [position 41364:4]	
#: Z_DescribeTable.php:14 includes/DatabaseTranslations.php:63      [position 41368:4]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: /home/tim/code/webERP/Z_DescribeTable.php:4      [position 48269:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:11      [position 48273:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:12      [position 48279:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:13      [position 48283:26]	
#: /home/tim/code/webERP/Z_DescribeTable.php:14      [position 48287:26]	
messages.po	
#: Z_DescribeTable.php:4      [position 41545:4]	
#: Z_DescribeTable.php:11 api/api_xml-rpc.php:2457 api/api_xml-rpc.php:2625      [position 41549:4]	
#: Z_DescribeTable.php:12      [position 41553:4]	
#: Z_DescribeTable.php:13      [position 41557:4]	
#: Z_DescribeTable.php:14 includes/DatabaseTranslations.php:63      [position 41561:4]	
messages.po	
#: Z_DescribeTable.php:4      [position 41489:4]	
#: Z_DescribeTable.php:11 api/api_xml-rpc.php:2457 api/api_xml-rpc.php:2625      [position 41493:4]	
#: Z_DescribeTable.php:12      [position 41497:4]	
#: Z_DescribeTable.php:13      [position 41501:4]	
#: Z_DescribeTable.php:14 includes/DatabaseTranslations.php:63      [position 41505:4]	
messages.po	
#: Z_DescribeTable.php:4      [position 41688:4]	
#: Z_DescribeTable.php:11 api/api_xml-rpc.php:2457 api/api_xml-rpc.php:2625      [position 41692:4]	
#: Z_DescribeTable.php:12      [position 41696:4]	
#: Z_DescribeTable.php:13      [position 41700:4]	
#: Z_DescribeTable.php:14 includes/DatabaseTranslations.php:63      [position 41704:4]	
demo.sql	
INSERT INTO `scripts` (`script`, `pagesecurity`, `description`) VALUES ('AccountGroups.php',10,'Defines the groupings of general ledger accounts'),('AccountSections.php',10,'Defines the sections in the general ledger reports'),('AddCusto...      [position 1252:37283]	
upgrade3.11.1-4.00.sql	
('Z_DescribeTable.php', 11, ''),      [position 770:3]

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions