Development attempt of Tongda oa to directly query the Form Content in the workflow, oa Workflow
A friend raised the need to directly query the Form Content at work. They used the workflow as a business system and used the workflow to the extreme. In order to realize the direct query function in image software, he wants to directly query the content in the form when handling the workflow.
By studying the workflow database, we can find the new version of the workflow and store the data in a single table. Each flow has a separate data table.
By integrating the relevant data into the query, the expected query is achieved. In view of the difficulty in modifying the original program of Tongda OA, a separate interface for handling and completing the work is provided here, to-Do jobs, you can directly click "host" to query. Only the results of the form can be viewed.
The program running result is as follows:
Because the content and fields of each form are different, this program cannot be made into a common program, and it can only be tailored. The process-level forms and execution steps are put together to increase the complexity of the program. Therefore, the execution control of the program is not too complex, it only adds the basic view and handling functions of the workflow to initially achieve the expected goal.
How does Tongda OA import the design form into the workflow?
Please see the image
In Tongda OA, there is no table in Form Design. What should I do if there is a table in the workflow?
According to a customer's feedback, the effect of office software developed on the flexible customization platform of tianling myApps is remarkable. The following is an obvious experience of a company that customers use:
1. During the first six months of the launch, the amount of stock sluggish items is reduced by 20% each month. During the launch year, the amount of stock sluggish items for more than three months is reduced to less than 5% of the total inventory amount;
2. The inventory anti-downtime period reaches one week within six months, and the longest downtime period reaches three months or less, respectively. The database Age analysis period reaches 5 days within six months;
3. The inventory turnover rate (Quantity) is doubled within six months, and the inventory turnover rate (amount) is increased by 50 ~ within six months ~ 100%; inventory analysis capability reaches the advanced level of similar technologies at home and abroad;
4. The inventory accuracy rate within six months has reached more than 85%, and more than 95% after one year; The inventory accuracy rate at the production site has reached more than 75% within six months, and more than 85% after one year;
5. On-site inventory management level 6 s management level within six months. The inventory check period generally reaches February within six months, important materials reach below January within six months, and cyclic inventory check reaches 1 ~ 2 times/week. Supports Dynamic Check levels that exceed the same category in China and reach or exceed the first-class level in foreign countries;
6. The product structure accuracy reaches 90% or more within six months, and the warehouse receiving accuracy and real-time rate reach 95% or more;
7. The automatic production scheduling rate reaches 85% or more within six months, and the production scheduling accuracy reaches 95% or more. There is no precedent for domestic ERP software in the furniture industry;
8. The Procurement progress and sales delivery period reach 90% and above respectively within six months, and the distribution delivery rate and store inventory accuracy reach 95% and 95%;
9. The procurement to payable cycle should be shortened to three days within six months, and the sales and shipment to receivables should be shortened to two days within six months of the same cycle;
10. The cost calculation time is currently only one hour, with an accuracy of more than 95%. The computing time and accuracy of finished products and semi-finished products are among the leading enterprises in the same industry in China.
The above is only a comprehensive analysis of the application results from the digital perspective, and the application of myApps is not only reflected in various data, but also reflected in the enterprise's myApps flexible customization platform as a tool, it provides a complete real-time, dynamic, and efficient information platform for operations, communication, assistance, and interaction for the company. data sharing, clear rights and responsibilities, and clear processes. In addition, it has established an information solution and office automation software based on the characteristics of the enterprise to solve common problems in normal operation.