| 25 | | |
| 26 | | {{{ |
| 27 | | BEGIN; |
| 28 | | |
| 29 | | SELECT * |
| 30 | | FROM build |
| 31 | | WHERE id = $buildId |
| 32 | | AND user_id = $userId |
| 33 | | LIMIT 1; |
| 34 | | |
| 35 | | SELECT * |
| 36 | | FROM build_component |
| 37 | | WHERE build_id = $buildId |
| 38 | | AND component_id = $componentId |
| 39 | | LIMIT 1; |
| 40 | | |
| 41 | | INSERT INTO build_component (build_id, component_id) |
| 42 | | VALUES ($buildId, $componentId); |
| 43 | | |
| 44 | | SELECT c.price |
| 45 | | FROM build_component bc |
| 46 | | JOIN components c ON c.id = bc.component_id |
| 47 | | WHERE bc.build_id = $buildId; |
| 48 | | |
| 49 | | UPDATE build |
| 50 | | SET total_price = ( |
| 51 | | SELECT COALESCE(ROUND(SUM(c.price), 2), 0) |
| 52 | | FROM build_component bc |
| 53 | | JOIN components c ON c.id = bc.component_id |
| 54 | | WHERE bc.build_id = $buildId |
| 55 | | ) |
| 56 | | WHERE id = $buildId; |
| 57 | | |
| 58 | | COMMIT; |
| 59 | | }}} |
| 60 | | |
| 61 | | [[Image(addedComponent.png, width=800, height=420)]] |
