new to cake. tried searching for this topic but couldn't find anything
that addressed my situation.
-----------------------------
tables:
-----------------------------
CREATE TABLE IF NOT EXISTS `t_machine` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255),
`description` text,
`cost` float(7, 2),
`status` TINYINT(1) DEFAULT '1',
`created` TIMESTAMP NULL,
`modified` TIMESTAMP NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
INSERT INTO t_machine('id', 'name') VALUES ('1', 'root');
CREATE TABLE IF NOT EXISTS `t_machine_parts` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`machine_id` INT(11) UNSIGNED,
`parent_id` INT(11) UNSIGNED,
`lft` INT(11) UNSIGNED,
`rght` INT(11) UNSIGNED,
`part_id` INT(11) UNSIGNED,
`created` TIMESTAMP NULL,
`modified` TIMESTAMP NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
INSERT INTO t_machine_parts(id, machine_id, parent_id, lft, rght,
part_id) VALUES
(1, 1, null, 1, 10, null),
(2, 1, 1, 2, 9, 1),
(3, 1, 2, 3, 6, 2),
(4, 1, 3, 4, 5, 4),
(5, 1, 2, 7, 8, 3);
CREATE TABLE IF NOT EXISTS `t_parts` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255),
`description` text,
`cost` float(7, 2),
`boolean` TINYINT(1) DEFAULT '0',
`status` TINYINT(1) DEFAULT '1',
`created` TIMESTAMP NULL,
`modified` TIMESTAMP NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
INSERT INTO t_parts(id, name) VALUES
(1, 'category'),
(2, 'sub_category_1'),
(3, 'sub_category_2'),
(4, 'option of sub_category_1');
--------------------------------
models:
-------------------------------
Machine
- hasMany MachinePart joined by machine_id
MachinePart
- belongsTo Machine joined by machine_id
- belongsTo Part joined by part_id
Part
- hasMany MachinePart joined by part_id
--------------------------------
i'm trying to use the tree behavior to give me a hierarchy view of all
the parts that are used for a given machine. i.e. i pass in a
machine_id to the MachinePartsController.
here is my relavent MachinePartsController code:
$machineParts =
$this->Machine->MachinePart->generatetreelist(array
('machine_id' => $id), null, null, '---');
$this->set('machineParts', $machineParts);
i'm returning an array that looks like this:
Array
(
[1] => 1
[2] => ---2
[3] => ------3
[4] => ---------4
[5] => ------5
)
i'm trying to get something that is able to join on the t_parts table
and will return something like this:
Array
(
[t_machine_part.part_id] => t_part.name
)
e.g.:
Array
(
[null] => null
[1] => ---category
[2] => ------sub_category_1
[4] => ---------option of sub_category_1
[3] => ------sub_category_2
)
any help would be greatly appreciated.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
