sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '1'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '1'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '1'
ORDER by parent_id ASC, id ASC
Array
(
[0] => Array
(
[id] => 2
[name] => Chassis
[parent_id] => 1
[module_type] => module
[qty] => 1
[details] => Nearly all t slot profile related areas. Maybe some switch panels or gauges would not be included. All structural items, whether necessary or not for functionality, are included under this module [e.g. floor, front suspension, brake mounts]
[module_total_price] => 0
[price] =>
[pcs] =>
)
[1] => Array
(
[id] => 3
[name] => Brake system
[parent_id] => 1
[module_type] => module
[qty] => 1
[details] => All non-mounting items of the brake system. From calipers to master cylinder to pedal and everything in between
[module_total_price] => 0
[price] =>
[pcs] =>
)
[2] => Array
(
[id] => 4
[name] => Front suspension
[parent_id] => 1
[module_type] => module
[qty] => 1
[details] => Control arms, coil overs, all brackets for mounting, bushings, ball joints, plates
[module_total_price] => 0
[price] =>
[pcs] =>
)
[3] => Array
(
[id] => 5
[name] => Steering system
[parent_id] => 1
[module_type] => module
[qty] => 1
[details] => Steering column out to the steering knuckle, but not the upright itself
[module_total_price] => 0
[price] =>
[pcs] =>
)
[4] => Array
(
[id] => 6
[name] => 12V system
[parent_id] => 1
[module_type] => module
[qty] => 1
[details] => All wiring and end points relying on 12V or 24V systems
[module_total_price] => 0
[price] =>
[pcs] =>
)
[5] => Array
(
[id] => 7
[name] => 72V system
[parent_id] => 1
[module_type] => module
[qty] => 1
[details] => Battery, breaker, wiring. switches, gauges, cases for gauges, cases for batteries
[module_total_price] => 0
[price] =>
[pcs] =>
)
[6] => Array
(
[id] => 8
[name] => Power Train
[parent_id] => 1
[module_type] => module
[qty] => 1
[details] => BLDC hub motor, upright, controller, mounting brackets, cases,
[module_total_price] => 0
[price] =>
[pcs] =>
)
[7] => Array
(
[id] => 9
[name] => Safety
[parent_id] => 1
[module_type] => module
[qty] => 1
[details] => This includes all things mandated for safety by the government, but not necessarily adding safety [e.g. windscreen on autocycle is required for manufacturers, but there is not definition nor is it necessary for the end user to keep it installed]
[module_total_price] => 0
[price] =>
[pcs] =>
)
[8] => Array
(
[id] => 291
[name] => Rear Suspension
[parent_id] => 1
[module_type] => module
[qty] => 1
[details] => Unlike the front suspension, this does include the aluminum bar that fits over the BLDC shaft. Also includes the 4 hole brackets that mount to the chassis
[module_total_price] => 0
[price] =>
[pcs] =>
)
)
- Chassis [id: 2, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '2'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '2'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '2'
ORDER by parent_id ASC, id ASC
- Floor [id: 10, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '10'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '10'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '10'
ORDER by parent_id ASC, id ASC
- Dual Wheel Floor - Single Side [id: 18, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '18'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '18'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '18'
ORDER by parent_id ASC, id ASC
- Control Arm Base Mount Forward Support [id: 19, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '19'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '19'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '19'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 26, module_qty: 180, item_pcs: 6000, price: 183.75]
---Ext Price: 5.5125
---Running Total: 5.5125
- Central Connector Circular [id: 28, module_qty: 4, item_pcs: 1, price: 0.62]
---Ext Price: 2.48
---Running Total: 7.9925
Values into updateModuleTotal(): 19,7.9925
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 19
---leaving updateModuleTotal()---
dad is 0
- Control Arm Base Mount [id: 20, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '20'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '20'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '20'
ORDER by parent_id ASC, id ASC
- Upper Control Arm Mount [id: 21, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '21'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '21'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '21'
ORDER by parent_id ASC, id ASC
- 45 Series Corner Bracket - 4 Holes [id: 46, module_qty: 2, item_pcs: 1, price: 8.3]
---Ext Price: 16.6
---Running Total: 16.6
- M8 x 16mm [id: 48, module_qty: 3, item_pcs: 1, price: 0.076]
---Ext Price: 0.228
---Running Total: 16.828
- Slide in T Nut [id: 49, module_qty: 3, item_pcs: 30, price: 16.14]
---Ext Price: 1.614
---Running Total: 18.442
- 45 x 90 x 90 [id: 134, module_qty: 180, item_pcs: 6000, price: 655.99]
---Ext Price: 19.6797
---Running Total: 38.1217
- Central Connector Circular [id: 136, module_qty: 4, item_pcs: 1, price: 0.62]
---Ext Price: 2.48
---Running Total: 40.6017
Values into updateModuleTotal(): 21,40.6017
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 21
---leaving updateModuleTotal()---
dad is 0
- 45 x 180 Heavy [id: 29, module_qty: 225, item_pcs: 6000, price: 1146.05]
---Ext Price: 42.976875
---Running Total: 42.976875
- Corner Plate 135mm x 135mm angled [id: 31, module_qty: 2, item_pcs: 1, price: 11.73]
---Ext Price: 23.46
---Running Total: 66.436875
- Central Connector Circular [id: 33, module_qty: 2, item_pcs: 1, price: 0.62]
---Ext Price: 1.24
---Running Total: 67.676875
- M8 x 16mm [id: 34, module_qty: 3, item_pcs: 1, price: 0.076]
---Ext Price: 0.228
---Running Total: 67.904875
- Slide in T Nut [id: 35, module_qty: 3, item_pcs: 30, price: 16.14]
---Ext Price: 1.614
---Running Total: 69.518875
Values into updateModuleTotal(): 20,69.518875
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 20
---leaving updateModuleTotal()---
dad is 0
- Control Arm Base Mount Rearward Support [id: 22, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '22'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '22'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '22'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 36, module_qty: 180, item_pcs: 6000, price: 183.75]
---Ext Price: 5.5125
---Running Total: 5.5125
- Central Connector Circular [id: 38, module_qty: 4, item_pcs: 1, price: 0.62]
---Ext Price: 2.48
---Running Total: 7.9925
Values into updateModuleTotal(): 22,7.9925
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 22
---leaving updateModuleTotal()---
dad is 0
- Foot Rest Forward [id: 23, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '23'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '23'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '23'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 39, module_qty: 450, item_pcs: 6000, price: 183.75]
---Ext Price: 13.78125
---Running Total: 13.78125
- Central Connector Circular [id: 41, module_qty: 2, item_pcs: 1, price: 0.62]
---Ext Price: 1.24
---Running Total: 15.02125
Values into updateModuleTotal(): 23,15.02125
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 23
---leaving updateModuleTotal()---
dad is 0
- Foot Rest Rearward [id: 25, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '25'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '25'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '25'
ORDER by parent_id ASC, id ASC
- 45 x 45 Heavy [id: 42, module_qty: 450, item_pcs: 6000, price: 208.95]
---Ext Price: 15.67125
---Running Total: 15.67125
- Central Connector Circular [id: 44, module_qty: 1, item_pcs: 1, price: 0.62]
---Ext Price: 0.62
---Running Total: 16.29125
- Deflector [id: 158, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '158'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '158'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '158'
ORDER by parent_id ASC, id ASC
- 45°Support Connector 45B [id: 164, module_qty: 2, item_pcs: 1, price: 6.11]
---Ext Price: 12.22
---Running Total: 12.22
- T Nut slide in [id: 165, module_qty: 2, item_pcs: 1, price: 0.099]
---Ext Price: 0.198
---Running Total: 12.418
- Angled Sides [id: 166, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '166'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '166'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '166'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 160, module_qty: 180, item_pcs: 6000, price: 183.75]
---Ext Price: 5.5125
---Running Total: 5.5125
- Threaded Insert [id: 162, module_qty: 2, item_pcs: 5, price: 7.19]
---Ext Price: 2.876
---Running Total: 8.3885
- M8 x 16mm [id: 163, module_qty: 2, item_pcs: 1, price: 0.076]
---Ext Price: 0.152
---Running Total: 8.5405
Values into updateModuleTotal(): 166,8.5405
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 166
---leaving updateModuleTotal()---
dad is 0
- M8 x 16mm [id: 167, module_qty: 2, item_pcs: 1, price: 0.076]
---Ext Price: 0.152
---Running Total: 12.57
- Deflector 45 Deg Base [id: 168, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '168'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '168'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '168'
ORDER by parent_id ASC, id ASC
- 45 x 45 x 45 Degree [id: 159, module_qty: 630, item_pcs: 6000, price: 203.96]
---Ext Price: 21.4158
---Running Total: 21.4158
Values into updateModuleTotal(): 168,21.4158
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 168
---leaving updateModuleTotal()---
dad is 0
- Deflector Straights [id: 169, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '169'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '169'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '169'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 170, module_qty: 180, item_pcs: 6000, price: 183.75]
---Ext Price: 5.5125
---Running Total: 5.5125
- Central Connector Circular [id: 172, module_qty: 4, item_pcs: 1, price: 0.62]
---Ext Price: 2.48
---Running Total: 7.9925
Values into updateModuleTotal(): 169,7.9925
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 169
---leaving updateModuleTotal()---
dad is 0
- Deflector 45 Deg Hood [id: 173, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '173'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '173'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '173'
ORDER by parent_id ASC, id ASC
- 45 x 45 x 45 Degree [id: 174, module_qty: 1215, item_pcs: 6000, price: 203.96]
---Ext Price: 41.3019
---Running Total: 41.3019
Values into updateModuleTotal(): 173,41.3019
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 173
---leaving updateModuleTotal()---
dad is 0
- Hood [id: 175, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '175'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '175'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '175'
ORDER by parent_id ASC, id ASC
- Hood Supports [id: 176, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '176'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '176'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '176'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 177, module_qty: 240, item_pcs: 6000, price: 183.75]
---Ext Price: 7.35
---Running Total: 7.35
- Central Connector Circular [id: 179, module_qty: 2, item_pcs: 1, price: 0.62]
---Ext Price: 1.24
---Running Total: 8.59
Values into updateModuleTotal(): 176,8.59
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 176
---leaving updateModuleTotal()---
dad is 0
- Brake System Mounting [id: 180, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '180'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '180'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '180'
ORDER by parent_id ASC, id ASC
- Brake Vertical Support [id: 181, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '181'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '181'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '181'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 182, module_qty: 405, item_pcs: 6000, price: 183.75]
---Ext Price: 12.403125
---Running Total: 12.403125
- Central Connector Circular [id: 184, module_qty: 4, item_pcs: 1, price: 0.62]
---Ext Price: 2.48
---Running Total: 14.883125
Values into updateModuleTotal(): 181,14.883125
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 181
---leaving updateModuleTotal()---
dad is 0
- Brake Pedal Support [id: 185, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '185'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '185'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '185'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 186, module_qty: 405, item_pcs: 6000, price: 183.75]
---Ext Price: 12.403125
---Running Total: 12.403125
- Central Connector Circular [id: 188, module_qty: 4, item_pcs: 1, price: 0.62]
---Ext Price: 2.48
---Running Total: 14.883125
Values into updateModuleTotal(): 185,14.883125
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 185
---leaving updateModuleTotal()---
dad is 0
- Brake Master Cylinder Support [id: 189, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '189'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '189'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '189'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 190, module_qty: 405, item_pcs: 6000, price: 183.75]
---Ext Price: 12.403125
---Running Total: 12.403125
- Central Connector Circular [id: 192, module_qty: 4, item_pcs: 1, price: 0.62]
---Ext Price: 2.48
---Running Total: 14.883125
- Front Hoop [id: 198, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '198'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '198'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '198'
ORDER by parent_id ASC, id ASC
- Front Hoop Cross Bar [id: 194, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '194'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '194'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '194'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 195, module_qty: 1215, item_pcs: 6000, price: 183.75]
---Ext Price: 37.209375
---Running Total: 37.209375
- Central Connector Circular [id: 197, module_qty: 6, item_pcs: 1, price: 0.62]
---Ext Price: 3.72
---Running Total: 40.929375
- Windshield Base 45 Deg [id: 199, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '199'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '199'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '199'
ORDER by parent_id ASC, id ASC
- 45 x 45 x 45 Degree [id: 200, module_qty: 1665, item_pcs: 6000, price: 203.96]
---Ext Price: 56.5989
---Running Total: 56.5989
Values into updateModuleTotal(): 199,56.5989
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 199
---leaving updateModuleTotal()---
dad is 0
- Front Hoop Vert [id: 201, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '201'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '201'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '201'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 202, module_qty: 450, item_pcs: 6000, price: 183.75]
---Ext Price: 13.78125
---Running Total: 13.78125
- Central Connector Circular [id: 204, module_qty: 4, item_pcs: 1, price: 0.62]
---Ext Price: 2.48
---Running Total: 16.26125
- A Pillar [id: 205, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '205'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '205'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '205'
ORDER by parent_id ASC, id ASC
- 45 x 45 Heavy [id: 206, module_qty: 720, item_pcs: 6000, price: 208.95]
---Ext Price: 25.074
---Running Total: 25.074
- Central Connector Circular [id: 208, module_qty: 2, item_pcs: 1, price: 0.62]
---Ext Price: 1.24
---Running Total: 26.314
Values into updateModuleTotal(): 205,26.314
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 205
---leaving updateModuleTotal()---
dad is 0
- Windshield Top 45 Deg [id: 209, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '209'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '209'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '209'
ORDER by parent_id ASC, id ASC
- 45 x 45 x 45 Degree [id: 210, module_qty: 1665, item_pcs: 6000, price: 203.96]
---Ext Price: 56.5989
---Running Total: 56.5989
Values into updateModuleTotal(): 209,56.5989
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 209
---leaving updateModuleTotal()---
dad is 0
- Roof [id: 211, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '211'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '211'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '211'
ORDER by parent_id ASC, id ASC
- Roof Lengths [id: 215, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '215'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '215'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '215'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 212, module_qty: 770, item_pcs: 6000, price: 183.75]
---Ext Price: 23.58125
---Running Total: 23.58125
- Central Connector Circular [id: 214, module_qty: 4, item_pcs: 1, price: 0.62]
---Ext Price: 2.48
---Running Total: 26.06125
Values into updateModuleTotal(): 215,26.06125
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 215
---leaving updateModuleTotal()---
dad is 0
- Roof Cross supports [id: 216, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '216'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '216'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '216'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 217, module_qty: 698, item_pcs: 6000, price: 183.75]
---Ext Price: 21.37625
---Running Total: 21.37625
- Roof 45 Deg Rear Support [id: 220, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '220'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '220'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '220'
ORDER by parent_id ASC, id ASC
- 45 x 45 x 45 Degree [id: 221, module_qty: 1665, item_pcs: 6000, price: 203.96]
---Ext Price: 56.5989
---Running Total: 56.5989
Values into updateModuleTotal(): 220,56.5989
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 220
---leaving updateModuleTotal()---
dad is 0
- Roof Rear Cross Bar [id: 245, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '245'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '245'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '245'
ORDER by parent_id ASC, id ASC
- 45 x 45 Heavy [id: 246, module_qty: 1665, item_pcs: 6000, price: 208.95]
---Ext Price: 57.983625
---Running Total: 57.983625
- Central Connector Circular [id: 248, module_qty: 2, item_pcs: 1, price: 0.62]
---Ext Price: 1.24
---Running Total: 59.223625
Values into updateModuleTotal(): 245,59.223625
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 245
---leaving updateModuleTotal()---
dad is 0
- Rear Pillars [id: 222, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '222'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '222'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '222'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 223, module_qty: 1105, item_pcs: 6000, price: 183.75]
---Ext Price: 33.840625
---Running Total: 33.840625
- Central Connector Circular [id: 225, module_qty: 4, item_pcs: 1, price: 0.62]
---Ext Price: 2.48
---Running Total: 36.320625
Values into updateModuleTotal(): 222,36.320625
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 222
---leaving updateModuleTotal()---
dad is 0
- Swing Arm Upper Shock Mount [id: 226, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '226'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '226'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '226'
ORDER by parent_id ASC, id ASC
- Shroud Base [id: 230, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '230'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '230'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '230'
ORDER by parent_id ASC, id ASC
- 45 x 90 x 90 [id: 227, module_qty: 180, item_pcs: 6000, price: 655.99]
---Ext Price: 19.6797
---Running Total: 19.6797
- Central Connector Circular [id: 229, module_qty: 7, item_pcs: 1, price: 0.62]
---Ext Price: 4.34
---Running Total: 24.0197
Values into updateModuleTotal(): 230,24.0197
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 230
---leaving updateModuleTotal()---
dad is 0
- Shroud 45 Deg [id: 231, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '231'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '231'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '231'
ORDER by parent_id ASC, id ASC
- 45 x 45 x 45 Degree [id: 232, module_qty: 180, item_pcs: 6000, price: 203.96]
---Ext Price: 6.1188
---Running Total: 6.1188
Values into updateModuleTotal(): 231,6.1188
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 231
---leaving updateModuleTotal()---
dad is 0
- Shroud Upper Shock Mount [id: 233, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '233'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '233'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '233'
ORDER by parent_id ASC, id ASC
- 45 x 180 Heavy [id: 234, module_qty: 360, item_pcs: 6000, price: 1146.05]
---Ext Price: 68.763
---Running Total: 68.763
- Central Connector Circular [id: 236, module_qty: 4, item_pcs: 1, price: 0.62]
---Ext Price: 2.48
---Running Total: 71.243
Values into updateModuleTotal(): 233,71.243
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 233
---leaving updateModuleTotal()---
dad is 0
- Rear Shock Mount Vert [id: 237, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '237'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '237'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '237'
ORDER by parent_id ASC, id ASC
- 45 x 180 6S [id: 238, module_qty: 360, item_pcs: 6000, price: 534.66]
---Ext Price: 32.0796
---Running Total: 32.0796
- Central Connector Circular [id: 240, module_qty: 4, item_pcs: 1, price: 0.62]
---Ext Price: 2.48
---Running Total: 34.5596
Values into updateModuleTotal(): 237,34.5596
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 237
---leaving updateModuleTotal()---
dad is 0
- Rear Shock Mount Upper Slope [id: 241, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '241'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '241'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '241'
ORDER by parent_id ASC, id ASC
- 45 x 180 6S [id: 242, module_qty: 277, item_pcs: 6000, price: 534.66]
---Ext Price: 24.68347
---Running Total: 24.68347
- Central Connector Circular [id: 244, module_qty: 4, item_pcs: 1, price: 0.62]
---Ext Price: 2.48
---Running Total: 27.16347
Values into updateModuleTotal(): 241,27.16347
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 241
---leaving updateModuleTotal()---
dad is 0
- Throttle Mount [id: 378, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '378'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '378'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '378'
ORDER by parent_id ASC, id ASC
- 45 x 45 Heavy [id: 379, module_qty: 180, item_pcs: 6000, price: 208.95]
---Ext Price: 6.2685
---Running Total: 6.2685
- Central Connector Circular [id: 381, module_qty: 2, item_pcs: 1, price: 0.62]
---Ext Price: 1.24
---Running Total: 7.5085
- M8 x 16mm [id: 382, module_qty: 3, item_pcs: 1500, price: 230.71]
---Ext Price: 0.46142
---Running Total: 7.96992
- T Nut slide in [id: 383, module_qty: 2, item_pcs: 1, price: 0.099]
---Ext Price: 0.198
---Running Total: 8.16792
- 45 Series Corner Bracket - 2 Holes [id: 384, module_qty: 1, item_pcs: 1, price: 4.42]
---Ext Price: 4.42
---Running Total: 12.58792
- M8 Lock Nut [id: 385, module_qty: 1, item_pcs: 1500, price: 159.42]
---Ext Price: 0.10628
---Running Total: 12.6942
Values into updateModuleTotal(): 378,12.6942
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 378
---leaving updateModuleTotal()---
dad is 0
- Brake system [id: 3, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '3'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '3'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '3'
ORDER by parent_id ASC, id ASC
- Brake caliper [id: 507, module_qty: 3, item_pcs: 2, price: 12.66]
---Ext Price: 18.99
---Running Total: 18.99
- Brake Line, 50cm [id: 508, module_qty: 1, item_pcs: 1, price: 9.99]
---Ext Price: 9.99
---Running Total: 28.98
- Brake Line, 120cm [id: 509, module_qty: 1, item_pcs: 1, price: 8.99]
---Ext Price: 8.99
---Running Total: 37.97
- Brake Master Cylinder [id: 510, module_qty: 1, item_pcs: 1, price: 48.99]
---Ext Price: 48.99
---Running Total: 86.96
- Brake Pedal [id: 511, module_qty: 2, item_pcs: 1, price: 45.27]
---Ext Price: 90.54
---Running Total: 177.5
- Brake Pedal push rod [id: 512, module_qty: 1, item_pcs: 1, price: 19.99]
---Ext Price: 19.99
---Running Total: 197.49
- 45 Series Corner Bracket - 2 Holes [id: 513, module_qty: 2, item_pcs: 1, price: 4.42]
---Ext Price: 8.84
---Running Total: 206.33
- M8 x 16mm [id: 514, module_qty: 2, item_pcs: 1500, price: 230.71]
---Ext Price: 0.30761333333333
---Running Total: 206.63761333333
- T Nut slide in [id: 515, module_qty: 2, item_pcs: 1, price: 0.099]
---Ext Price: 0.198
---Running Total: 206.83561333333
- Brake Line, 230cm [id: 517, module_qty: 1, item_pcs: 1, price: 18.49]
---Ext Price: 18.49
---Running Total: 225.32561333333
- Cable Mounting Block [id: 518, module_qty: 4, item_pcs: 1, price: 0.13]
---Ext Price: 0.52
---Running Total: 225.84561333333
Values into updateModuleTotal(): 3,225.84561333333
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 3
---leaving updateModuleTotal()---
dad is 0
- Front suspension [id: 4, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '4'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '4'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '4'
ORDER by parent_id ASC, id ASC
- Mustang 2 [id: 137, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '137'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '137'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '137'
ORDER by parent_id ASC, id ASC
- Mustang 2 45 Degs [id: 143, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '143'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '143'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '143'
ORDER by parent_id ASC, id ASC
- 45 x 45 x 45 Degree [id: 157, module_qty: 180, item_pcs: 6000, price: 203.96]
---Ext Price: 6.1188
---Running Total: 6.1188
Values into updateModuleTotal(): 143,6.1188
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 143
---leaving updateModuleTotal()---
dad is 0
- Mustang 2 Upper Shock Mount [id: 144, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '144'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '144'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '144'
ORDER by parent_id ASC, id ASC
- Central Connector Circular [id: 140, module_qty: 4, item_pcs: 1, price: 0.62]
---Ext Price: 2.48
---Running Total: 2.48
- 45 x 180 Heavy [id: 142, module_qty: 180, item_pcs: 6000, price: 1146.05]
---Ext Price: 34.3815
---Running Total: 36.8615
Values into updateModuleTotal(): 144,36.8615
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 144
---leaving updateModuleTotal()---
dad is 0
- Mustang 2 Crossbar Forward [id: 147, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '147'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '147'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '147'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 154, module_qty: 630, item_pcs: 6000, price: 183.75]
---Ext Price: 19.29375
---Running Total: 19.29375
- Central Connector Circular [id: 156, module_qty: 7, item_pcs: 1, price: 0.62]
---Ext Price: 4.34
---Running Total: 23.63375
Values into updateModuleTotal(): 147,23.63375
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 147
---leaving updateModuleTotal()---
dad is 0
- Mustang 2 Crossbar Rearward [id: 153, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '153'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '153'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '153'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 148, module_qty: 630, item_pcs: 6000, price: 183.75]
---Ext Price: 19.29375
---Running Total: 19.29375
- Central Connector Circular [id: 150, module_qty: 4, item_pcs: 1, price: 0.62]
---Ext Price: 2.48
---Running Total: 21.77375
Values into updateModuleTotal(): 153,21.77375
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 153
---leaving updateModuleTotal()---
dad is 0
- Double Wishbone Suspension [id: 249, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '249'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '249'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '249'
ORDER by parent_id ASC, id ASC
- Upper Control Arm [id: 250, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '250'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '250'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '250'
ORDER by parent_id ASC, id ASC
- 45 x 90 Heavy [id: 251, module_qty: 270, item_pcs: 6000, price: 183.75]
---Ext Price: 8.26875
---Running Total: 8.26875
- M8 x 25mm [id: 257, module_qty: 6, item_pcs: 100, price: 27.05]
---Ext Price: 1.623
---Running Total: 9.89175
- T Nut slide in [id: 258, module_qty: 6, item_pcs: 1, price: 0.099]
---Ext Price: 0.594
---Running Total: 10.48575
- UCA Swing Arm Bolt [id: 259, module_qty: 1, item_pcs: 6, price: 13.99]
---Ext Price: 2.3316666666667
---Running Total: 12.817416666667
- M10 Lock Nut [id: 260, module_qty: 1, item_pcs: 1500, price: 145.09]
---Ext Price: 0.096726666666667
---Running Total: 12.914143333333
- M10 Swing Arm Bushing [id: 261, module_qty: 2, item_pcs: 10, price: 9.49]
---Ext Price: 1.898
---Running Total: 14.812143333333
- Bolt on Ball Joint [id: 262, module_qty: 1, item_pcs: 2, price: 38.99]
---Ext Price: 19.495
---Running Total: 34.307143333333
Values into updateModuleTotal(): 250,34.307143333333
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 250
---leaving updateModuleTotal()---
dad is 0
- Lower Control Arm Parent [id: 263, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '263'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '263'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '263'
ORDER by parent_id ASC, id ASC
- Lower Control Arm Main [id: 264, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '264'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '264'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '264'
ORDER by parent_id ASC, id ASC
- 45 x 180 Heavy [id: 265, module_qty: 315, item_pcs: 6000, price: 1146.05]
---Ext Price: 60.167625
---Running Total: 60.167625
- M8 x 25mm [id: 269, module_qty: 6, item_pcs: 100, price: 27.05]
---Ext Price: 1.623
---Running Total: 61.790625
- T Nut slide in [id: 270, module_qty: 6, item_pcs: 1, price: 0.099]
---Ext Price: 0.594
---Running Total: 62.384625
- Central Connector Circular [id: 277, module_qty: 2, item_pcs: 1, price: 0.62]
---Ext Price: 1.24
---Running Total: 63.624625
Values into updateModuleTotal(): 264,63.624625
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 264
---leaving updateModuleTotal()---
dad is 0
- Lower Control Arm Adapter [id: 271, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '271'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '271'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '271'
ORDER by parent_id ASC, id ASC
- 45 x 45 Heavy [id: 272, module_qty: 175, item_pcs: 6000, price: 208.95]
---Ext Price: 6.094375
---Running Total: 6.094375
- LCA Swing Arm Bolt [id: 273, module_qty: 1, item_pcs: 1, price: 7.55]
---Ext Price: 7.55
---Running Total: 13.644375
- M10 Lock Nut [id: 274, module_qty: 1, item_pcs: 1500, price: 145.09]
---Ext Price: 0.096726666666667
---Running Total: 13.741101666667
- M10 Swing Arm Bushing [id: 275, module_qty: 2, item_pcs: 10, price: 9.49]
---Ext Price: 1.898
---Running Total: 15.639101666667
Values into updateModuleTotal(): 271,15.639101666667
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 271
---leaving updateModuleTotal()---
dad is 0
- Coil Over Shock [id: 278, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '278'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '278'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '278'
ORDER by parent_id ASC, id ASC
- 45 Series Corner Bracket - 2 Holes [id: 279, module_qty: 1, item_pcs: 1, price: 4.42]
---Ext Price: 4.42
---Running Total: 4.42
- M8 flat head x 14mm [id: 283, module_qty: 2, item_pcs: 100, price: 12.02]
---Ext Price: 0.2404
---Running Total: 4.6604
- M8 x 25mm [id: 284, module_qty: 2, item_pcs: 100, price: 27.05]
---Ext Price: 0.541
---Running Total: 5.2014
- T Nut slide in [id: 285, module_qty: 4, item_pcs: 1, price: 0.099]
---Ext Price: 0.396
---Running Total: 5.5974
- M10 Spacer [id: 286, module_qty: 1, item_pcs: 5, price: 9.99]
---Ext Price: 1.998
---Running Total: 7.5954
- Coil over shock [id: 287, module_qty: 1, item_pcs: 2, price: 86.06]
---Ext Price: 43.03
---Running Total: 50.6254
- M10 x 45mm [id: 288, module_qty: 1, item_pcs: 5, price: 8.2]
---Ext Price: 1.64
---Running Total: 52.2654
- M10 x 55mm [id: 289, module_qty: 1, item_pcs: 6, price: 8.39]
---Ext Price: 1.3983333333333
---Running Total: 53.663733333333
- M10 Lock Nut [id: 290, module_qty: 2, item_pcs: 1500, price: 145.09]
---Ext Price: 0.19345333333333
---Running Total: 53.857186666667
- Corner Plate 135mm x 135mm angled [id: 455, module_qty: 1, item_pcs: 1, price: 11.73]
---Ext Price: 11.73
---Running Total: 65.587186666667
- 45 Series Corner Bracket - 2 Holes [id: 537, module_qty: 2, item_pcs: 1, price: 4.42]
---Ext Price: 8.84
---Running Total: 74.427186666667
Values into updateModuleTotal(): 278,74.427186666667
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 278
---leaving updateModuleTotal()---
dad is 0
- Coil Over Shock Rear Swing Arm [id: 538, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '538'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '538'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '538'
ORDER by parent_id ASC, id ASC
- Steering system [id: 5, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '5'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '5'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '5'
ORDER by parent_id ASC, id ASC
- Steering Rack [id: 308, module_qty: 1, item_pcs: 1, price: 169.95]
---Ext Price: 169.95
---Running Total: 169.95
- 40 Series Corner Bracket - 4 Holes [id: 309, module_qty: 1, item_pcs: 1, price: 7.2]
---Ext Price: 7.2
---Running Total: 177.15
- M8 x 16mm [id: 312, module_qty: 1, item_pcs: 1500, price: 230.71]
---Ext Price: 0.15380666666667
---Running Total: 177.30380666667
- M8 x 50mm [id: 313, module_qty: 2, item_pcs: 100, price: 40.69]
---Ext Price: 0.8138
---Running Total: 178.11760666667
- T Nut slide in [id: 314, module_qty: 3, item_pcs: 1, price: 0.099]
---Ext Price: 0.297
---Running Total: 178.41460666667
- M10 Spacer [id: 315, module_qty: 2, item_pcs: 5, price: 9.99]
---Ext Price: 3.996
---Running Total: 182.41060666667
- U Joint 5/8" 36 spline to 3/4" DD [id: 316, module_qty: 1, item_pcs: 1, price: 19.99]
---Ext Price: 19.99
---Running Total: 202.40060666667
- 3/4" DD rod [id: 317, module_qty: 1, item_pcs: 914.4, price: 41.99]
---Ext Price: 0.0459208223972
---Running Total: 202.44652748906
- Steering column [id: 318, module_qty: 1, item_pcs: 1, price: 152]
---Ext Price: 152
---Running Total: 354.44652748906
- 3/4" to 1" DD U Joint [id: 319, module_qty: 1, item_pcs: 1, price: 16.99]
---Ext Price: 16.99
---Running Total: 371.43652748906
- Main Steering Column Mount, lower [id: 320, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '320'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '320'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '320'
ORDER by parent_id ASC, id ASC
- Steering column bracket [id: 321, module_qty: 1, item_pcs: 2, price: 18.99]
---Ext Price: 9.495
---Running Total: 9.495
- M8 socket head [id: 322, module_qty: 2, item_pcs: 10, price: 7.78]
---Ext Price: 1.556
---Running Total: 11.051
- T Nut slide in [id: 323, module_qty: 2, item_pcs: 1, price: 0.099]
---Ext Price: 0.198
---Running Total: 11.249
Values into updateModuleTotal(): 320,11.249
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 320
---leaving updateModuleTotal()---
dad is 0
- 45 x 45 x 45 Degree [id: 324, module_qty: 180, item_pcs: 6000, price: 203.96]
---Ext Price: 6.1188
---Running Total: 377.55532748906
- 45 Series Corner Bracket - 2 Holes [id: 325, module_qty: 2, item_pcs: 1, price: 4.42]
---Ext Price: 8.84
---Running Total: 386.39532748906
- M8 x 16mm [id: 326, module_qty: 4, item_pcs: 1500, price: 230.71]
---Ext Price: 0.61522666666667
---Running Total: 387.01055415573
- T Nut slide in [id: 327, module_qty: 4, item_pcs: 1, price: 0.099]
---Ext Price: 0.396
---Running Total: 387.40655415573
- Main Steering Column Mount, upper [id: 328, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '328'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '328'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '328'
ORDER by parent_id ASC, id ASC
- Steering column bracket [id: 329, module_qty: 1, item_pcs: 2, price: 18.99]
---Ext Price: 9.495
---Running Total: 9.495
- M8 socket head [id: 330, module_qty: 2, item_pcs: 10, price: 7.78]
---Ext Price: 1.556
---Running Total: 11.051
- T Nut slide in [id: 331, module_qty: 2, item_pcs: 1, price: 0.099]
---Ext Price: 0.198
---Running Total: 11.249
- 45 x 45 x 45 Degree [id: 332, module_qty: 180, item_pcs: 6000, price: 203.96]
---Ext Price: 6.1188
---Running Total: 17.3678
- End Cap 45mm x 45 Degree Radius [id: 335, module_qty: 2, item_pcs: 1, price: 2.48]
---Ext Price: 4.96
---Running Total: 22.3278
- Steering Wheel [id: 336, module_qty: 1, item_pcs: 1, price: 124.99]
---Ext Price: 124.99
---Running Total: 147.3178
- Left Tie Rod: 5" [id: 337, module_qty: 1, item_pcs: 1, price: 12.52]
---Ext Price: 12.52
---Running Total: 159.8378
- Right Tie Rod: 29" [id: 338, module_qty: 1, item_pcs: 1, price: 22.56]
---Ext Price: 22.56
---Running Total: 182.3978
- Left Hand Heim [id: 339, module_qty: 2, item_pcs: 1, price: 7.95]
---Ext Price: 15.9
---Running Total: 198.2978
- Right Hand Heim [id: 340, module_qty: 2, item_pcs: 1, price: 8.87]
---Ext Price: 17.74
---Running Total: 216.0378
- 5/8" Heim Washer [id: 341, module_qty: 8, item_pcs: 50, price: 25.56]
---Ext Price: 4.0896
---Running Total: 220.1274
- Steering Rack 3/8in bolt x 2in [id: 342, module_qty: 2, item_pcs: 50, price: 31.67]
---Ext Price: 1.2668
---Running Total: 221.3942
- Steering Knuckle 3/8in bolt x 4.5in [id: 343, module_qty: 2, item_pcs: 225, price: 134.98]
---Ext Price: 1.1998222222222
---Running Total: 222.59402222222
- 3/8in lock nut [id: 344, module_qty: 4, item_pcs: 100, price: 11.51]
---Ext Price: 0.4604
---Running Total: 223.05442222222
Values into updateModuleTotal(): 328,223.05442222222
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 328
---leaving updateModuleTotal()---
dad is 0
- Steering Knuckle [id: 408, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '408'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '408'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '408'
ORDER by parent_id ASC, id ASC
- M8 flat head x 60mm [id: 351, module_qty: 3, item_pcs: 100, price: 52.4]
---Ext Price: 1.572
---Running Total: 1.572
- T Nut slide in [id: 352, module_qty: 3, item_pcs: 1, price: 0.099]
---Ext Price: 0.297
---Running Total: 1.869
- 45 x 45 x 45 Degree [id: 409, module_qty: 180, item_pcs: 6000, price: 203.96]
---Ext Price: 6.1188
---Running Total: 7.9878
- 45 x 90 Heavy [id: 410, module_qty: 180, item_pcs: 6000, price: 183.75]
---Ext Price: 5.5125
---Running Total: 13.5003
- Central Connector Circular [id: 412, module_qty: 3, item_pcs: 1, price: 0.62]
---Ext Price: 1.86
---Running Total: 15.3603
- M10 Swing Arm Bushing [id: 415, module_qty: 2, item_pcs: 10, price: 9.49]
---Ext Price: 1.898
---Running Total: 17.2583
Values into updateModuleTotal(): 408,17.2583
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 408
---leaving updateModuleTotal()---
dad is 0
- 12V system [id: 6, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '6'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '6'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '6'
ORDER by parent_id ASC, id ASC
- 12V switch bank [id: 436, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '436'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '436'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '436'
ORDER by parent_id ASC, id ASC
- M5 TNut [id: 432, module_qty: 32, item_pcs: 200, price: 6.99]
---Ext Price: 1.1184
---Running Total: 1.1184
- M6 x 10mm [id: 434, module_qty: 4, item_pcs: 50, price: 7.99]
---Ext Price: 0.6392
---Running Total: 1.7576
- M6 TNut [id: 435, module_qty: 4, item_pcs: 50, price: 8.99]
---Ext Price: 0.7192
---Running Total: 2.4768
- 2080 Black [id: 437, module_qty: 480, item_pcs: 2000, price: 40]
---Ext Price: 9.6
---Running Total: 12.0768
- HDPE Sheet 4' x 8' x .25" thick [id: 438, module_qty: 0.125, item_pcs: 2, price: 132.49]
---Ext Price: 8.280625
---Running Total: 20.357425
- M5 TNut [id: 439, module_qty: 32, item_pcs: 200, price: 6.99]
---Ext Price: 1.1184
---Running Total: 21.475825
- M6 x 10mm [id: 441, module_qty: 4, item_pcs: 50, price: 7.99]
---Ext Price: 0.6392
---Running Total: 22.115025
- M6 TNut [id: 442, module_qty: 4, item_pcs: 50, price: 8.99]
---Ext Price: 0.7192
---Running Total: 22.834225
- P9 Gland [id: 446, module_qty: 1, item_pcs: 40, price: 8.99]
---Ext Price: 0.22475
---Running Total: 23.058975
- Volt meter [id: 474, module_qty: 1, item_pcs: 3, price: 7.99]
---Ext Price: 2.6633333333333
---Running Total: 25.722308333333
- M12 push button switch [id: 477, module_qty: 7, item_pcs: 5, price: 12.95]
---Ext Price: 18.13
---Running Total: 43.852308333333
- 2 Port WAGO [id: 479, module_qty: 21, item_pcs: 60, price: 28.95]
---Ext Price: 10.1325
---Running Total: 53.984808333333
- 18/8 wire [id: 480, module_qty: 500, item_pcs: 50000, price: 141.99]
---Ext Price: 1.4199
---Running Total: 55.404708333333
- P9 Gland [id: 506, module_qty: 3, item_pcs: 40, price: 8.99]
---Ext Price: 0.67425
---Running Total: 56.078958333333
Values into updateModuleTotal(): 436,56.078958333333
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 436
---leaving updateModuleTotal()---
dad is 0
- 12V Lithium battery [id: 447, module_qty: 1, item_pcs: 1, price: 46.99]
---Ext Price: 46.99
---Running Total: 46.99
- 14/2 wire [id: 448, module_qty: 1080, item_pcs: 7620, price: 19.99]
---Ext Price: 2.8332283464567
---Running Total: 49.823228346457
- 22 AWG ring terminal [id: 449, module_qty: 2, item_pcs: 60, price: 8.99]
---Ext Price: 0.29966666666667
---Running Total: 50.122895013123
- Anderson Connector - AWG 12 - 10 [id: 450, module_qty: 1, item_pcs: 10, price: 16.99]
---Ext Price: 1.699
---Running Total: 51.821895013123
- 12V LiFeP04 20A charger [id: 451, module_qty: 1, item_pcs: 1, price: 67.49]
---Ext Price: 67.49
---Running Total: 119.31189501312
- Waterproof Container: Large [id: 452, module_qty: 1, item_pcs: 2, price: 10.4]
---Ext Price: 5.2
---Running Total: 124.51189501312
- M8 x 14mm nylon bolt [id: 453, module_qty: 4, item_pcs: 10, price: 6.99]
---Ext Price: 2.796
---Running Total: 127.30789501312
- T Nut slide in [id: 454, module_qty: 4, item_pcs: 1, price: 0.099]
---Ext Price: 0.396
---Running Total: 127.70389501312
- Blinker Module [id: 457, module_qty: 2, item_pcs: 2, price: 5]
---Ext Price: 5
---Running Total: 132.70389501312
- 5 Port WAGO [id: 458, module_qty: 11, item_pcs: 50, price: 30.95]
---Ext Price: 6.809
---Running Total: 139.51289501312
- In line pigtail + fuse [id: 459, module_qty: 10, item_pcs: 24, price: 17.99]
---Ext Price: 7.4958333333333
---Running Total: 147.00872834646
- 18/8 wire [id: 460, module_qty: 2500, item_pcs: 50000, price: 141.99]
---Ext Price: 7.0995
---Running Total: 154.10822834646
- 2 Port WAGO [id: 461, module_qty: 11, item_pcs: 60, price: 28.95]
---Ext Price: 5.3075
---Running Total: 159.41572834646
- Cable Mounting Block [id: 462, module_qty: 5, item_pcs: 1, price: 0.13]
---Ext Price: 0.65
---Running Total: 160.06572834646
- LED Bar [id: 463, module_qty: 2, item_pcs: 1, price: 28.04]
---Ext Price: 56.08
---Running Total: 216.14572834646
- 2 Port WAGO [id: 464, module_qty: 3, item_pcs: 60, price: 28.95]
---Ext Price: 1.4475
---Running Total: 217.59322834646
- Cable Mounting Block [id: 465, module_qty: 3, item_pcs: 1, price: 0.13]
---Ext Price: 0.39
---Running Total: 217.98322834646
- 18/8 wire [id: 466, module_qty: 2000, item_pcs: 50000, price: 141.99]
---Ext Price: 5.6796
---Running Total: 223.66282834646
- 2 Port WAGO [id: 467, module_qty: 48, item_pcs: 60, price: 28.95]
---Ext Price: 23.16
---Running Total: 246.82282834646
- LED Strips [id: 468, module_qty: 24, item_pcs: 4, price: 13.69]
---Ext Price: 82.14
---Running Total: 328.96282834646
- 18/2 wire [id: 469, module_qty: 6000, item_pcs: 304800, price: 299.97]
---Ext Price: 5.9049212598425
---Running Total: 334.8677496063
- 2 Port WAGO [id: 470, module_qty: 5, item_pcs: 60, price: 28.95]
---Ext Price: 2.4125
---Running Total: 337.2802496063
- LP Module [id: 471, module_qty: 1, item_pcs: 1, price: 12.98]
---Ext Price: 12.98
---Running Total: 350.2602496063
- 18/8 wire [id: 472, module_qty: 500, item_pcs: 50000, price: 141.99]
---Ext Price: 1.4199
---Running Total: 351.6801496063
- In line pigtail + fuse [id: 473, module_qty: 1, item_pcs: 24, price: 17.99]
---Ext Price: 0.74958333333333
---Running Total: 352.42973293963
- In line pigtail + fuse [id: 478, module_qty: 1, item_pcs: 24, price: 17.99]
---Ext Price: 0.74958333333333
---Running Total: 353.17931627297
- 18/2 wire [id: 488, module_qty: 2000, item_pcs: 304800, price: 299.97]
---Ext Price: 1.9683070866142
---Running Total: 355.14762335958
- 2 Port WAGO [id: 489, module_qty: 12, item_pcs: 60, price: 28.95]
---Ext Price: 5.79
---Running Total: 360.93762335958
- Horn [id: 494, module_qty: 1, item_pcs: 2, price: 29.99]
---Ext Price: 14.995
---Running Total: 375.93262335958
- 18/2 wire [id: 496, module_qty: 1000, item_pcs: 304800, price: 299.97]
---Ext Price: 0.98415354330709
---Running Total: 376.91677690289
- Odometer and Speedometer [id: 532, module_qty: 1, item_pcs: 1, price: 62.99]
---Ext Price: 62.99
---Running Total: 439.90677690289
Values into updateModuleTotal(): 6,439.90677690289
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 6
---leaving updateModuleTotal()---
dad is 0
- 72V system [id: 7, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '7'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '7'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '7'
ORDER by parent_id ASC, id ASC
- 72V Power Management Board [id: 393, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '393'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '393'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '393'
ORDER by parent_id ASC, id ASC
- 72V DC 150A Breaker [id: 394, module_qty: 3, item_pcs: 1, price: 20.3]
---Ext Price: 60.9
---Running Total: 60.9
- 10kW resistor [id: 395, module_qty: 1, item_pcs: 10, price: 6.99]
---Ext Price: 0.699
---Running Total: 61.599
- 300A ANL Fuse and Holder [id: 397, module_qty: 1, item_pcs: 2, price: 15.99]
---Ext Price: 7.995
---Running Total: 69.594
- 4 post GND distribution block [id: 398, module_qty: 1, item_pcs: 1, price: 17.99]
---Ext Price: 17.99
---Running Total: 87.584
- 4 AWG [id: 399, module_qty: 1, item_pcs: 1500, price: 45.99]
---Ext Price: 0.03066
---Running Total: 0.03066
- 4 AWG Lugs [id: 400, module_qty: 24, item_pcs: 10, price: 9.99]
---Ext Price: 23.976
---Running Total: 24.00666
- 18/8 wire [id: 401, module_qty: 2000, item_pcs: 50000, price: 141.99]
---Ext Price: 5.6796
---Running Total: 29.68626
- LiFeP04 Battery System [id: 402, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '402'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '402'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '402'
ORDER by parent_id ASC, id ASC
- 3.2V 280Ah Prismatic Cell [id: 403, module_qty: 24, item_pcs: 4, price: 239.99]
---Ext Price: 1439.94
---Running Total: 1439.94
- 22 AWG ring terminal [id: 404, module_qty: 24, item_pcs: 60, price: 6.99]
---Ext Price: 2.796
---Running Total: 1442.736
- BMS 24S [id: 405, module_qty: 1, item_pcs: 1, price: 171.03]
---Ext Price: 171.03
---Running Total: 1613.766
- 24S Battery Case [id: 406, module_qty: 1, item_pcs: 1, price: 190.9]
---Ext Price: 190.9
---Running Total: 1804.666
- Anderson Connector - heavy gauge [id: 419, module_qty: 2, item_pcs: 6, price: 17.99]
---Ext Price: 5.9966666666667
---Running Total: 1810.6626666667
- PVC Sheet [id: 426, module_qty: 25, item_pcs: 10, price: 15.4]
---Ext Price: 38.5
---Running Total: 1849.1626666667
- P9 Gland [id: 427, module_qty: 5, item_pcs: 40, price: 8.99]
---Ext Price: 1.12375
---Running Total: 1850.2864166667
- 10in Duct Tape [id: 428, module_qty: 4800, item_pcs: 27432, price: 28.88]
---Ext Price: 5.0533683289589
---Running Total: 1855.3397849956
Values into updateModuleTotal(): 402,1855.3397849956
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 402
---leaving updateModuleTotal()---
dad is 0
- 72V instrument panel [id: 498, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '498'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '498'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '498'
ORDER by parent_id ASC, id ASC
- 2080 Black [id: 499, module_qty: 480, item_pcs: 2000, price: 40]
---Ext Price: 9.6
---Running Total: 9.6
- HDPE Sheet 4' x 8' x .25" thick [id: 500, module_qty: 0.125, item_pcs: 2, price: 132.49]
---Ext Price: 8.280625
---Running Total: 17.880625
- M5 TNut [id: 501, module_qty: 8, item_pcs: 200, price: 6.99]
---Ext Price: 0.2796
---Running Total: 18.160225
- M6 x 10mm [id: 503, module_qty: 8, item_pcs: 50, price: 7.99]
---Ext Price: 1.2784
---Running Total: 19.438625
- M6 TNut [id: 504, module_qty: 4, item_pcs: 50, price: 8.99]
---Ext Price: 0.7192
---Running Total: 20.157825
- Power Train [id: 8, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '8'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '8'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '8'
ORDER by parent_id ASC, id ASC
- Single Axle Power Train [id: 346, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '346'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '346'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '346'
ORDER by parent_id ASC, id ASC
- Direct Wheel Drive [id: 535, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '535'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '535'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '535'
ORDER by parent_id ASC, id ASC
- Upright [id: 345, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '345'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '345'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '345'
ORDER by parent_id ASC, id ASC
- 45 Series Corner Bracket - 4 Holes [id: 347, module_qty: 2, item_pcs: 1, price: 8.3]
---Ext Price: 16.6
---Running Total: 16.6
- 45 Series Corner Bracket - 2 Holes [id: 348, module_qty: 3, item_pcs: 1, price: 4.42]
---Ext Price: 13.26
---Running Total: 29.86
- M8 flat head x 30mm [id: 350, module_qty: 10, item_pcs: 1000, price: 168.62]
---Ext Price: 1.6862
---Running Total: 31.5462
- M8 Lock Nut [id: 353, module_qty: 6, item_pcs: 1500, price: 159.42]
---Ext Price: 0.63768
---Running Total: 32.18388
Values into updateModuleTotal(): 345,32.18388
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 345
---leaving updateModuleTotal()---
dad is 0
- Brake rotor [id: 354, module_qty: 1, item_pcs: 1, price: 23.42]
---Ext Price: 23.42
---Running Total: 23.42
- M8 flat head x 14mm [id: 355, module_qty: 3, item_pcs: 100, price: 12.02]
---Ext Price: 0.3606
---Running Total: 23.7806
- 5kW BLDC Hub Motor - Single Axle [id: 357, module_qty: 1, item_pcs: 1, price: 436.25]
---Ext Price: 436.25
---Running Total: 460.0306
- 1.25in BLDC Shaft Washer [id: 358, module_qty: 1, item_pcs: 5, price: 11.99]
---Ext Price: 2.398
---Running Total: 462.4286
- FarDriver 72450 [id: 359, module_qty: 1, item_pcs: 1, price: 140.5]
---Ext Price: 140.5
---Running Total: 602.9286
- Controller Bluetooth adapter [id: 361, module_qty: 1, item_pcs: 1, price: 19.99]
---Ext Price: 19.99
---Running Total: 622.9186
- Corner Plate 135mm x 135mm angled [id: 362, module_qty: 1, item_pcs: 1, price: 11.73]
---Ext Price: 11.73
---Running Total: 634.6486
- Cable Mounting Block [id: 364, module_qty: 2, item_pcs: 1, price: 0.13]
---Ext Price: 0.26
---Running Total: 634.9086
- 2 Port WAGO [id: 366, module_qty: 5, item_pcs: 60, price: 28.95]
---Ext Price: 2.4125
---Running Total: 637.3211
- 5 Port WAGO [id: 367, module_qty: 8, item_pcs: 50, price: 30.95]
---Ext Price: 4.952
---Running Total: 642.2731
- M8 x 35mm [id: 370, module_qty: 2, item_pcs: 100, price: 30.75]
---Ext Price: 0.615
---Running Total: 642.8881
- T Nut slide in [id: 371, module_qty: 2, item_pcs: 1, price: 0.099]
---Ext Price: 0.198
---Running Total: 643.0861
- Drag DR-33 Rim 17 X7.5 4-100.00/108.00 42 [id: 389, module_qty: 1, item_pcs: 1, price: 117]
---Ext Price: 117
---Running Total: 760.0861
- Goodyear Wrangler Territory RT 235/65r17 [id: 390, module_qty: 1, item_pcs: 1, price: 170.85]
---Ext Price: 170.85
---Running Total: 930.9361
- Valve Stem Cap [id: 392, module_qty: 1, item_pcs: 4, price: 5.99]
---Ext Price: 1.4975
---Running Total: 932.4336
Values into updateModuleTotal(): 535,932.4336
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 535
---leaving updateModuleTotal()---
dad is 0
- Waterproof Container: Large [id: 365, module_qty: 1, item_pcs: 2, price: 10.4]
---Ext Price: 5.2
---Running Total: 5.2
- Throttle [id: 372, module_qty: 1, item_pcs: 1, price: 18.55]
---Ext Price: 18.55
---Running Total: 23.75
- Cable Mounting Block [id: 373, module_qty: 3, item_pcs: 1, price: 0.13]
---Ext Price: 0.39
---Running Total: 24.14
- Switch Bank [id: 374, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '374'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '374'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '374'
ORDER by parent_id ASC, id ASC
- Toggle switch [id: 375, module_qty: 3, item_pcs: 3, price: 9.99]
---Ext Price: 9.99
---Running Total: 9.99
- M12 push button switch [id: 376, module_qty: 3, item_pcs: 5, price: 12.95]
---Ext Price: 7.77
---Running Total: 17.76
- Female slot connector [id: 416, module_qty: 9, item_pcs: 150, price: 8.99]
---Ext Price: 0.5394
---Running Total: 18.2994
- 2080 Black [id: 430, module_qty: 3480, item_pcs: 2000, price: 40]
---Ext Price: 69.6
---Running Total: 87.8994
- HDPE Sheet 4' x 8' x .25" thick [id: 431, module_qty: 0.25, item_pcs: 2, price: 132.49]
---Ext Price: 16.56125
---Running Total: 104.46065
- 2 Port WAGO [id: 481, module_qty: 9, item_pcs: 60, price: 28.95]
---Ext Price: 4.3425
---Running Total: 108.80315
- Volt meter [id: 491, module_qty: 3, item_pcs: 3, price: 7.99]
---Ext Price: 7.99
---Running Total: 116.79315
- In line pigtail + fuse [id: 493, module_qty: 3, item_pcs: 24, price: 17.99]
---Ext Price: 2.24875
---Running Total: 119.0419
Values into updateModuleTotal(): 374,119.0419
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 374
---leaving updateModuleTotal()---
dad is 0
- Waterproof Container: Large [id: 386, module_qty: 1, item_pcs: 2, price: 10.4]
---Ext Price: 5.2
---Running Total: 29.34
- 2 Port WAGO [id: 387, module_qty: 5, item_pcs: 60, price: 28.95]
---Ext Price: 2.4125
---Running Total: 31.7525
- Tire Pressure Monitoring System with internal sensors [id: 391, module_qty: 1, item_pcs: 1, price: 33.91]
---Ext Price: 33.91
---Running Total: 65.6625
Values into updateModuleTotal(): 8,65.6625
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 8
---leaving updateModuleTotal()---
dad is 0
- Safety [id: 9, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '9'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '9'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '9'
ORDER by parent_id ASC, id ASC
- Seat - 551.mm wide [id: 519, module_qty: 2, item_pcs: 2, price: 219.99]
---Ext Price: 219.99
---Running Total: 219.99
- Rear view mirror [id: 524, module_qty: 1, item_pcs: 1, price: 16.98]
---Ext Price: 16.98
---Running Total: 236.97
- M8 x 16mm [id: 525, module_qty: 2, item_pcs: 1500, price: 230.71]
---Ext Price: 0.30761333333333
---Running Total: 237.27761333333
- T Nut slide in [id: 526, module_qty: 2, item_pcs: 1, price: 0.099]
---Ext Price: 0.198
---Running Total: 237.47561333333
- Side view mirrors [id: 527, module_qty: 2, item_pcs: 2, price: 13.99]
---Ext Price: 13.99
---Running Total: 251.46561333333
- Seat Belt [id: 529, module_qty: 2, item_pcs: 2, price: 35.15]
---Ext Price: 35.15
---Running Total: 286.61561333333
- Flip Windshield [id: 534, module_qty: 1, item_pcs: 1, price: 379.99]
---Ext Price: 379.99
---Running Total: 666.60561333333
Values into updateModuleTotal(): 9,666.60561333333
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 9
---leaving updateModuleTotal()---
dad is 0
- Rear Suspension [id: 291, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '291'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '291'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '291'
ORDER by parent_id ASC, id ASC
- Rear Swing Arm Mounting Adapter [id: 292, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '292'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '292'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '292'
ORDER by parent_id ASC, id ASC
- 45 x 45 Heavy [id: 293, module_qty: 161, item_pcs: 6000, price: 208.95]
---Ext Price: 5.606825
---Running Total: 5.606825
- LCA Swing Arm Bolt [id: 294, module_qty: 1, item_pcs: 1, price: 7.55]
---Ext Price: 7.55
---Running Total: 13.156825
- M10 Lock Nut [id: 295, module_qty: 1, item_pcs: 1500, price: 145.09]
---Ext Price: 0.096726666666667
---Running Total: 13.253551666667
- M10 Swing Arm Bushing [id: 296, module_qty: 2, item_pcs: 10, price: 9.49]
---Ext Price: 1.898
---Running Total: 15.151551666667
Values into updateModuleTotal(): 292,15.151551666667
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 292
---leaving updateModuleTotal()---
dad is 0
- Rear Swing Arm Cross Bar [id: 297, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '297'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '297'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '297'
ORDER by parent_id ASC, id ASC
- 45 x 180 Heavy [id: 298, module_qty: 360, item_pcs: 6000, price: 1146.05]
---Ext Price: 68.763
---Running Total: 68.763
- Central Connector Circular [id: 300, module_qty: 2, item_pcs: 1, price: 0.62]
---Ext Price: 1.24
---Running Total: 70.003
- Rear Swing Arm Leg [id: 301, current module total price: 0]
sql:
SELECT
ev_module.id,
ev_module.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_module.notes as price,
ev_module.notes as pcs
FROM
ev_module
WHERE
ev_module.module_type = 'module' AND ev_module.parent_id = '301'
UNION ALL
SELECT
ev_module.id,
ev_item.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_item.price,
ev_item.pcs
FROM
ev_module, ev_item
WHERE
ev_module.pointer_id = ev_item.id AND ev_module.module_type = 'item' AND ev_module.parent_id = '301'
UNION ALL
SELECT
ev_module.id,
ev_fabrication.name,
ev_module.parent_id,
ev_module.module_type,
ev_module.pcs as qty,
ev_module.details,
ev_module.module_total_price,
ev_fabrication.price,
ev_fabrication.vendor_id as pcs
FROM
ev_module, ev_fabrication
WHERE
ev_module.pointer_id = ev_fabrication.id AND ev_module.module_type = 'fabrication' AND ev_module.parent_id = '301'
ORDER by parent_id ASC, id ASC
- 45 x 180 Heavy [id: 302, module_qty: 405, item_pcs: 6000, price: 1146.05]
---Ext Price: 77.358375
---Running Total: 77.358375
- Central Connector Circular [id: 304, module_qty: 2, item_pcs: 1, price: 0.62]
---Ext Price: 1.24
---Running Total: 78.598375
- M8 x 25mm [id: 306, module_qty: 6, item_pcs: 100, price: 27.05]
---Ext Price: 1.623
---Running Total: 80.221375
- 45 Series Corner Bracket - 2 Holes [id: 356, module_qty: 2, item_pcs: 1, price: 4.42]
---Ext Price: 8.84
---Running Total: 89.061375
Values into updateModuleTotal(): 301,89.061375
UPDATE ev_module
SET module_total_price = module_total_price + 0
WHERE id = 301
---leaving updateModuleTotal()---
dad is 0
Module Data