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] => 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] =>
)
[1] => Array
(
[id] => 10
[name] => Floor
[parent_id] => 1
[module_type] => module
[qty] => 1
[details] => All the tslot parts that are critical to making this thing work. Does NOT include dash, front hoop, main hoop, roof, brake or steering supports, swing arms, control arms, seat mounts or switch mounts. Includes everything else, including wheel arches,
[module_total_price] => 0
[price] =>
[pcs] =>
)
[2] => Array
(
[id] => 18
[name] => Dual Wheel Floor - Single Side
[parent_id] => 1
[module_type] => module
[qty] => 2
[details] => Floor of front of tadpole trike or four-wheel vehicle - one side. Left and right sides of this module are mirror images, thus quantity of two for this but not its siblings
[module_total_price] => 0
[price] =>
[pcs] =>
)
[3] => Array
(
[id] => 158
[name] => Deflector
[parent_id] => 1
[module_type] => module
[qty] => 1
[details] => The angled portion of the front of Evie. This portion connects to the floor or Mustang 2 cross bar. This will most likely contain many more sub-modules in a wheel arch front suspension
[module_total_price] => 0
[price] =>
[pcs] =>
)
[4] => Array
(
[id] => 175
[name] => Hood
[parent_id] => 1
[module_type] => module
[qty] => 1
[details] => The flat area forward of the front hoop
[module_total_price] => 0
[price] =>
[pcs] =>
)
[5] => 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] =>
)
)
- 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
- 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
- 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