>>> database tables
CREATE TABLE IF NOT EXISTS `product` (
`id_product` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_supplier` int(10) unsigned DEFAULT NULL,
`id_manufacturer` int(10) unsigned DEFAULT NULL,
`id_tax` int(10) unsigned NOT NULL,
`id_category_default` int(10) unsigned DEFAULT NULL,
`id_color_default` int(10) unsigned DEFAULT NULL,
`on_sale` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ean13` varchar(13) DEFAULT NULL,
`ecotax` decimal(17,2) NOT NULL DEFAULT '0.00',
`quantity` int(10) unsigned NOT NULL DEFAULT '0',
`price` decimal(20,6) NOT NULL DEFAULT '0.000000',
`wholesale_price` decimal(20,6) NOT NULL DEFAULT '0.000000',
`reduction_price` decimal(17,2) DEFAULT NULL,
`reduction_percent` float DEFAULT NULL,
`reduction_from` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
`reduction_to` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
`reference` varchar(32) DEFAULT NULL,
`supplier_reference` varchar(32) DEFAULT NULL,
`location` varchar(64) DEFAULT NULL,
`weight` float NOT NULL DEFAULT '0',
`out_of_stock` int(10) unsigned NOT NULL DEFAULT '2',
`quantity_discount` tinyint(1) DEFAULT '0',
`customizable` tinyint(2) NOT NULL DEFAULT '0',
`uploadable_files` tinyint(4) NOT NULL DEFAULT '0',
`text_fields` tinyint(4) NOT NULL DEFAULT '0',
`active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`indexed` tinyint(1) NOT NULL DEFAULT '0',
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_product`),
KEY `product_supplier` (`id_supplier`),
KEY `product_manufacturer` (`id_manufacturer`),
KEY `id_tax` (`id_tax`),
KEY `id_category_default` (`id_category_default`),
KEY `id_color_default` (`id_color_default`),
KEY `date_add` (`date_add`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `supplier` (
`id_supplier` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_supplier`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
>>> supplier.php
<?php
class Supplier extends AppModel {
var $name = 'Supplier';
var $useTable = 'supplier';
var $primaryKey = 'id_supplier';
var $hasMany = array('Product' => array(
'className' => 'Product',
'foreignKey' => 'id_supplier',
'dependent' => true,)
);
}
?>
>>> product.php
<?php
class Product extends AppModel {
var $name = 'Product';
var $useTable = 'product';
var $primaryKey = 'id_product';
var $belongsTo = array(
'Supplier' => array(
'className' => 'Supplier',
'foreignKey' => 'id_supplier',
'conditions' => '',
'fields' => '',
'order' => ''));
}
?>
>>> products_controller.php (just showing add method)
(...)
function add() {
if (!empty($this->data)) {
$this->Product->create();
if ($this->Product->save($this->data)) {
$this->Session->setFlash(__('The product has
been saved', true));
$this->redirect(array('action' => 'index'));
} else {
$this->Session->setFlash(__('The product could
not be saved.
Please, try again.', true));
}
}
$suppliers = $this->Product->Supplier->find('list');
$this->set(compact('suppliers'));
}
(...)
>>> add.ctp
<div class="products form">
<?php echo $this->Form->create('Product');?>
<fieldset>
<legend><?php __('Add Product'); ?></legend>
<?php
echo $this->Form->input('id_product');
echo $this->Form->input('id_supplier');
(...)
Why it doesn't show Product form with Suppliers as combobox?
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
