|
|
|
MySql sql
|
|||
|---|---|---|---|
|
#18+
помогите решить задачу! Очень важно!!!!!!!!!!! Consider the following tables: TABLE `invoice` Fields: id: BIGINT(11) PRIMARY_KEY, AUTO INCREMENT, first_name: VARCHAR(255), last_name : VARCHAR(255), issue_date: DATETIME, product_amount: DECIMAL(7,2), tax_amount : DECIMAL(7,2), total_amount : DECIMAL(7,2), TABLE `invoice_items` Fields: id: BIGINT(11) PRIMARY_KEY, AUTO_INCREMENT, id_invoice: BIGINT(11) , FOREIGN_KEY ON invoice.id item_name: VARCHAR(255), product_cost: DECIMAL(7,2), tax_cost: DECIMAL(7,2), total_cost: DECIMAL(7,2) The invoice table stores invoice information and invoice_items stores the items of the invoice. Invoice.product_amount contains the sum of all product_costs for each item belonging to the invoice. Invoice.tax_amount contains the sum of all tax_costs for each item belonging to the invoice. Invoice.total_amount contains the sum of all total_costs for each item belonging to the invoice. Also keep in mind : Total_cost = Product_cost + Tax_cost Tax_cost = 15% * Product_cost Please write a model which exposes methods for the following: 1. Create a new invoice 2. Add an item in an invoice 3. Remove an item in an invoice 4. Remove an invoice 5. Edit an invoice issue date 6. Edit the product cost of an invoice. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 04.02.2015, 21:44:37 |
|
||
|
MySql sql
|
|||
|---|---|---|---|
|
#18+
Gorblogпомогите решить 12381461 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.02.2015, 06:41:07 |
|
||
|
MySql sql
|
|||
|---|---|---|---|
|
#18+
решил первую часть, no половине второго остановился ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 05.02.2015, 08:55:00 |
|
||
|
|

start [/forum/topic.php?fid=47&msg=38871954&tid=1833607]: |
0ms |
get settings: |
5ms |
get forum list: |
17ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
49ms |
get topic data: |
10ms |
get forum data: |
3ms |
get page messages: |
41ms |
get tp. blocked users: |
1ms |
| others: | 215ms |
| total: | 347ms |

| 0 / 0 |
