hi guys can you please help me I have an dependent element here and a nested ajax. Well i wanted to load the remaining quantity base on what dosage id was loaded. I think my logic is right but it gives me 500(Internal Server Error).
This is my ajax script:
<script>
$(document).ready(function(){
$.ajax({
type: 'POST',
data: {cons_medname: $('#ShisConsultation_cons_medname').val()},
url: '<?php echo CController::createUrl('onload'); ?>',
success: function(data){
$('#ShisConsultation_cons_dosage').append(data);
$.ajax({
type: 'POST',
data: {cons_dosage: $('#ShisConsultation_cons_dosage').val()},
url: '<?php echo CController::createUrl('quantity'); ?>',
success: function(data){
$('#remaining').text(data);
}
});
}
});
});
</script>
This is my action controller:
public function actionDosage()
{
$criteria = new CDbCriteria;
$criteria->condition = 'dtl_med_id='.$_POST['cons_medname'].' AND dtl_qty!=0';
$data=ShisMedDetails::model()->findAll($criteria);
$data=CHtml::listData($data,'dtl_id','dtl_dosage');
echo CHtml::tag('option',
array('value'=>''),CHtml::encode("Select Dosage"),true);
foreach($data as $value=>$name)
{
echo CHtml::tag('option',
array('value'=>$value),CHtml::encode($name),true);
}
}
public function actionQuantity()
{
$criteria = new CDbCriteria;
$criteria->condition = 'dtl_id='.$_POST['ShisConsultation']['cons_dosage'];
$data=ShisMedDetails::model()->find($criteria);
echo CHtml::tag('label', array(),CHtml::encode($data->dtl_qty),true);
}
in addition if i put a static query in actionQuantity it gives me no error tnx.