payment transaction serial number order number refund amount
order status and refund review (one of the after-sale returns and refunds) are separate
this problem is designed to the database design problem. If you designed it, you might as well think about it: a refund is a business? It needs to be processed manually, so you might as well design a table for processing transactions for review. Or it is OK to set up a separate refund form for review. If recorded in the form of state, although it is OK, but the performance choice, design choice may not be optimal. Keep the field, in fact, you just need to know which order is refunded, and then the reasons for the refund and other related information. Refer to Taobao and other websites.
which fields of payment need to be retained in the module of order refund?
the order number paid by the third party ID, the internal order number, the refund order number paid by the third party, the payment amount, the refund amount.
the status of the order and the approval status of the refund are put in one field, or are they open separately?
if you put it separately, you may not get a refund if you pass the examination and approval.
the question of landlord should be about database design, right?
cannot say whether it is correct or not, and there is no standard answer. This question should be considered entirely on the basis of your own project.
for example,
A payment platform has three data: order number, amount and time to be submitted at the time of payment.
and the reply result of the payment platform includes four data: order number, amount, payment time and payment result.
and we saved all four data, but also related to the user's information (such as user number), as well as product number, quantity, mailing address and so on.
now that the user has asked for a refund and submitted a refund request, then the data related to the refund must be involved.
then submit it to the payment platform for refund. The platform requires three items: order number, amount and refund reason.
then return the order number and the refund result.
so if so, what do you need to save? I can say that all the data is useful to me, or I can say that I just want the key data, but what is the key data? It depends on your project, for example, if you need to track the refund process at a later stage, you should have the corresponding data to keep, so there is really nothing to ask about this question, it all depends on your own project.
as for the order status and refund status, it also depends on your own project, but generally speaking, the order belongs to the sales category, and the refund belongs to the after-sales category. For the convenience of later maintenance, it is recommended to separate
.when the yii framework did the function of increasing the number of articles read today, it was found that the number of readings increased by 2 each visit. later found that whenever I render the template and layout in the controller, the controller i...
Yii::$app- > getSession ()-> setFlash ( success , "saved successfully! ") ; use this method to prompt information to the user, prompt a quick message, please ask how to set the time, let the prompt disappear after how long, if this prompt can not be r...
1. Use the yii Imagine class library to synthesize pictures . Please ask how to bold text and adjust the spacing between text. Has anyone ever used it? thank you ....
Fatal error: Cannot initialize libui: error initializing libui: registering utility window class; code 1410 (0x00000582) in Unknown on line 0 yii2...
for example, where should a Taobao guest s sdk be placed so that it can load automatically?...
mysqlInnoDB....
1) this is the execution result of the Yii1 framework record: 2SQL: 3) this is the statement executed: select indexerid from pre_dimension where status=1 and origin= restaurant and columnid in (100008, 100498, 100494, 100492, 100503, 100506, ...
php...
php...
an uncertified API application first of all, the Controller base class behaviors method is the default, inheriting only yii rest Controller , without adding additional authentication, and then customizing site error class TokenAuth exten...
: ...
how to beautify the parameter routing of yii? Pass parameters. If you want to change it to use pass, please ask how to configure it. The final effect you want is " http: localhost 20180507 net. ....
yii base InvalidArgumentException: The file or directory to be published does not exist: home vagrant yii test vendor bower-asset typeahead.js dist in home vagrant yii test vendor yiisoft yii2 web AssetManager.php:456 Stack trace: -sharp0 home vagra...
C: Application phpStudy php php-7.0.12-nts $ php composer.phar create-project yiisoft yii2-app-advanced advanced 2.0.15 [InvalidArgumentException] Could not find package yiisoft yii2-app-advanced with version 2.0.15. create-project [-s|--stabi...
using the Yii2.0 framework, the server executes the following command directly to suspend the daemon normally. At that time, it often hangs up automatically after running for a few days nohup phpstudy www llq yii queue start & now a script has ...
the problem is this: I created a project on Yayun that was written in the YII framework! Now that is to say, my team clone the project down and install it locally for project development, and now the front end is in the tmp assets directory. There ar...
the previous project (front and rear separation) is that the verification code and data acquisition are normal on the apache server! then switch to nginx server result graphics CAPTCHA cannot be verified! But there is nothing wrong with getting and su...
Project to achieve three-tier distribution; rebate to all superiors (up to three levels) after database design and user registration but I don t have a clue. Please give me a thought. if it is directly registered to reward 20 yuan if it is throug...
Local Yii2 framework, https will be redirected through virtual host access the Yii framework configured on the company s computer, and the access is normal. I uploaded the entire frame directory to the remote GIT repository, and then pulled the code ...
after the user logs in, the user id login ip is encrypted by some algorithms. after encryption, the user token is written to the database and written to the cache (redis) the purpose of writing the cache is that every time the client requests to get t...