将发票项目转换为帐户表单 [英] Translating invoice items to accounts form

问题描述

大家好，



今天我有点复杂的问题。



现在举个例子我有这张发票：

Hi all,

Today i have a little bit complicated issue .

Now for example i have this invoice :

Item Code  | Qty | Unit Price | Discount | Total
book-1     | 1   |     5      | 2        | 3
book-2     | 2   |     5      | 2        | 8
Accessories| 1   |     2      | 1        | 1

我有以下sql表

*items，其中包含item_Code为PK。

item_code |

book-1

book-2

配件

*帐户，其中包含account_id为PK。< br $> b $ b account_id |

I have the following sql tables
* "items" which contains item_Code as PK.
item_code |
book-1
book-2
Accessories
* "accounts" which contains account_id as PK .
account_id |

books sales account
books discount account
accessories sales account
accessories discount account

*item_account_type包含以下内容：

1- type_id为PK。

2- type_name。

此表填写如下：

* "item_account_type" which contains the following :
1- type_id As PK.
2- type_name.
this table is filled as follows :

type_id  |  type_name
1        |  Sales account
2        |  discount account

*item_account，其中包含以下内容：

1- type_id为FK

2 item_code如FK

3- account_id作为FK

例如，这是上述相同发票的item_account。

type_id | item_code | acount_id

* "item_account" which contain the following :
1- type_id As FK
2- item_code As FK
3- account_id As FK
For examples , this is the item_account for the same above invoice .
type_id | item_code | acount_id

1        | book-1      | books sales account
2        | book-1      | books discount account
1        | book-2      | books sales account
2        | book-2      | books discount account
1        | Accessories | accessories sales account
2        | Accessories | accessories discount account

现在，您可能会注意到书籍1和书籍2具有相同的帐户。



以上发票应通过检查每个项目帐户以及是否为销售或折扣并计算account_id和类型相同的金额来转换为以下形式。这就是我想知道的（如何使它成为这样）：



最终形式应如下：

Now, you may noticed that book-1 and book-2 had the same accounts .

the above invoice should be translated to the following form by checking each item account and if it''s sales or discount and calculating the sums where account_id and type is the same . this is what i want to know ( how to make it like this ) :

the final form should be like this :

Account_id                   | total 
books sales account          | 15 
books discount account       | 4
accessories sales account    | 2
accessories discount account | 1

我的表格构建正确，但我如何达到这一点并将其保存在名为Entry的sql表中。



我希望我的问题很清楚，如果您有任何疑问，请告诉我。



感谢您试图帮助我:)：）

My tables are built correctly , but how do i reach to this point and save it in sql tables called " Entry" ..

I hope that my question is clear and please let me know if you have any questions ..

Thanks for trying to help me :) :)

推荐答案

这将取决于您的申请要求，而不是我们的意见。



你在开始之前就写了一套完整的要求，不是吗？你知道吗，一步一步记录你正在编写代码的确切业务流程？

That would be dictated by your application requirements, not our opinions.

You DID write up a complete set of requirements before you started this, didn''t you? You know, something that documents the exact business processes, step-by-step, that you''re writing code against??

这篇关于将发票项目转换为帐户表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！