public function actionSendMaterialId()
{
// Zec / Devolve material fico depois de escolher o servico e o Material
$qry = 'SELECT * from materiais
inner join materiais_servicos on
materiais_servicos.ServicoId = '.'"'.$_POST['ServicoId'].'"
and materiais_servicos.MaterialId = materiais.Id
group by Nome;';
$result = Yii::app()->db->createCommand($qry)->queryAll();
$data=CHtml::listData($result,'MaterialId', 'Nome');
foreach($data as $id => $value)
{
echo CHtml::tag('option',array('value' => $id),CHtml::encode($value),true);
}
}
public function actionCreate()
{
$model=new RequisicoesBlocos;
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if(isset($_POST['RequisicoesBlocos']))
{
$model->attributes=$_POST['RequisicoesBlocos'];
$model->Data = date("Y-m-d H:i:s");
$model->MaterialId = $_POST['MaterialId'];
$model->ServicoId = $_POST['ServicoId'];
if($model->save())
$this->redirect(array('index'));
}
$this->render('create',array(
'model'=>$model,
));
}