Task preview

НомерprojectCategoryVisibilityИзменен
0000096RasKonWishespublic2021-02-28 15:41
Initiatorsv.maksim ResponsibleADGroup  
PriorityordinaryInfluencelargeReproducibilityinapplicable
Condition closedDecisionsolved 
PlatformWin32Operating systemWindowsOS versionXP
Версия продукта8.89 
Целевая версия8.96Решена в версии8.96 
Theme0000096: Downloading of financial data by order
DescriptionIt is necessary to unload the following data on orders:
1.order number
2.customer number
3.amount owed
4.payment amount
5.order change identifier (Indicates whether the order amount has changed since the last upload).

In the program you can introduce a prohibition to change the order after setting the status "cutting" as a parameter for the user "Allow to change the order after setting the status cutting". After setting the cutting status in the order it will be possible to change only the subsequent order statuses.

Do the upload as a request ccalc.exe -d 30 -s 12.03.2012 -h -f d:\download.txt
-d unload for n days from the current date
-s date from which to unload orders (if -d parameter is set -s is ignored)
-h unload only orders in which the change identifier is not equal to 0
-f address to upload file (mandatory parameter, if only one parameter is set, it unloads data for all orders)
TagsThere are no associated tags.
Number of references
Implementation period (days)
Cost
Planned date

Connections

related to 0000188 closedADGroup Export of economic data 
related to 0001970 closedADGroup When uploading financial data on orders via the -export parameter, the database query has been optimized. 

Activity

sv.maksim

2013-03-04 13 :19

author ~0000082

don't forget that when exporting you should check the readability of the file, let's say, dostup.sec, so that the export would be possible only for users who can access this file.

sv.maksim

2013-04-01 11 :42

author ~0000147

You also need to upload dates and statuses of order fulfillment milestones.

ADGroup

2013-04-05 02 :33

administrator ~0000156

Last modified: 2013-04-05 02 :34

Done. Only the startup format is as follows:
ccalc.exe -d:30 -s:12.03.2012 -export:d:\download.txt
Export of steps is done.
Only the file read check function for access verification is not done.

sv.maksim

2013-04-08 20 :02

author ~0000161

GETZKZZINFO|180005|19719|05.04.2013|433|433|314|2882,54|2882,54|0,00|2882,54| - here it would be logical to see the time of creation of this order.
And don't forget to describe the format of all fields.
P.S - well and access control.

ADGroup

2013-04-22 20 :30

administrator ~0000179

Along with the date, I have also added the time upload in version 8.97

ADGroup

2013-04-22 21 :40

administrator ~0000180

Last modified: 2013-04-22 21 :52

Field format.
Order Information.
GETZKZINFO|180005|19719|05.04.2013|433|433|314|2882,54|2882,54|0,00|2882,54|45-23/08|05.04.2013|тест|
180005 - order ID
19719 - order number
05.04.2013 - order date
433 - customer ID
433 - dealer ID
314 - dealer code
2882,54 - total order value
2882,54 - agreed amount
0,00 - order payment
2882,54 - debt
45-23/08 - contract number
05.04.2013 - contract date
test - note to the order

Information about stages of order fulfillment.
GETZKZETAP:
180005 - order ID
1 - stage ID
3 - status
05.04.2013 14:35 - start date
05.04.2013 16:15 - end date
14 - ID of the user who started the stage
5 - ID of the user who finished the stage
100% - percentage of stage completion from the total number (e.g. there are several designs in the order and one and the same stage may be already completed for some designs and not for others).

ADGroup

2013-04-22 21 :41

administrator ~0000181

sv.maksim

2013-11-14 13 :28

author ~0000353

GETZKZINFO|302606|142320|24.10.2013 08:34|1576|1576|1542|1225,06|1225,06|0,00|1225,06||24.10.2013||[количество конструкций]
We need to add [number of constructs] to this string with the last parameter.

ADGroup

2014-07-06 21 :27

administrator ~0000565

The last parameter added is the number of constructs.

Community support for the task
This problem is marked solved.
If you think it is not, please reopen it and explain why.
Supporters: No supporters have yet voted in favor of the task.
Neutrality: No users have yet voted neutral for this task.
Opponents: No opponents have yet voted in favor of this task.

Change history

Date of change User Field Modify
2013-02-26 15:32 sv.maksim New task
2013-03-02 01:58 ADGroup Responsible => ADGroup
2013-03-02 01:58 ADGroup Condition new => assigned
2013-03-02 01:58 ADGroup Targeted version => 8.92
2013-03-04 12:34 ADGroup Targeted version 8.92 => 8.93
2013-03-04 13:19 sv.maksim Comment added: 0000082
2013-03-13 09:53 ADGroup Targeted version 8.93 => 8.94
2013-03-20 14:03 ADGroup Targeted version 8.94 => 8.95
2013-04-01 11:42 sv.maksim Comment added: 0000147
2013-04-04 02:55 ADGroup Targeted version 8.95 => 8.96
2013-04-05 02:33 ADGroup Comment added: 0000156
2013-04-05 02:33 ADGroup Condition assigned => closed
2013-04-05 02:33 ADGroup Decision open => solved
2013-04-05 02:33 ADGroup Resolved in version => 8.96
2013-04-05 02:34 ADGroup Comment modified: 0000156
2013-04-08 20:02 sv.maksim Comment added: 0000161
2013-04-08 20:02 sv.maksim Condition closed => feedback
2013-04-08 20:02 sv.maksim Decision resolved => reopened
2013-04-22 20:30 ADGroup Comment added: 0000179
2013-04-22 21:40 ADGroup Comment added: 0000180
2013-04-22 21:41 ADGroup Comment added: 0000181
2013-04-22 21:41 ADGroup Condition feedback => closed
2013-04-22 21:41 ADGroup Decision reopened => solved
2013-04-22 21:49 ADGroup Link added blocks 0000188
2013-04-22 21:49 ADGroup Link deleted blocks 0000188
2013-04-22 21:50 ADGroup Link added related to 0000188
2013-04-22 21:52 ADGroup Comment modified: 0000180
2013-11-14 13:28 sv.maksim Comment added: 0000353
2013-11-14 13:28 sv.maksim Condition closed => feedback
2013-11-14 13:28 sv.maksim Decision resolved => reopened
2014-07-06 21:27 ADGroup Comment added: 0000565
2014-07-06 21:27 ADGroup Condition feedback => closed
2014-07-06 21:27 ADGroup Decision reopened => solved
2021-02-28 15:41 ADGroup Link added related to 0001970