1 Function Description
1.1 company as an independent unit
1.2 the fleet as a group under the company
1.3 proposal is to be managed as a company, adding to the organization on the platform
2 Operating Instructions
2.1, link database, can refer to: database access information and access operation.
2.2, create a new query and execute the sample SQL statement.
UPDATE jt808_company_info SET Level = '1', CompanyID = '1',ParentCompanyID = '1',AccountID = (SELECT ID from jt808_account where Account = 'RAM User') where Name = 'Fleet Name ';
As a result, the fleet is changed to a company, the parent company ID is associated, and an original sub- user account is bound.
2.3, create a new query and execute the sample SQL statement.
UPDATE jt808_account set CompanyID = (SELECT ID from jt808_company_info where Name = 'Fleet name'),AccountType = '1' WHERE Account = 'Sub- user'
The result is to change the bound sub- user account to the main account and associate it with the company ID.
3 Note:
3.1 AccountType(0 is sub- account, 1 is main account)
3.2 Level(1 = company, 2 = fleet);CompanyID (parent company ID);ParentCompanyID (parent company ID)
3.3 Account (sub- user account to be bound);Name (to be changed to the company's fleet name)
