public function actionTest()
{
$data = array();
$paid_amt = AvsanAvakTable::model()->findAll(array('condition' => 'bill_no_of_avasan="' . $_REQUEST['AvsanAvakTable']['bill_no_of_avasan'] . '"'));
$data = Avsan::model()->findByAttributes(array('avsan_number' => $_REQUEST['AvsanAvakTable']['bill_no_of_avasan']));
$paid_amount = 0;
if ($paid_amt) {
foreach ($paid_amt as $p) {
$paid_amount += $p['amount'];
}
} else {
$paid_amount = 0;
}
if ($data) {
$dead_person = $data->ausan_name;
$sender_name = $data->ausan_sender_name;
$net_amount = $data->avsan_net_amount - $paid_amount;
} else {
$dead_person = '';
$sender_name = '';
$net_amount = '';
}
if ($data['avsan_net_amount'] == $paid_amount) {
$net_amount = 'No Unpaid Amount';
}
echo CJSON::encode(array('dead_person' => $dead_person, 'sender_name' => $sender_name, 'unpaid_amt' => $net_amount, 'paid_amt' => $paid_amount));
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = Avsan::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
