yii2:autofill on multiple condtions

I have models/tables as follows:

table room_category

id room_category

1 Classic

2 Deluxe

table room_charges

id room_category room_name room_charges

1 1 c1 600

2 2 d1 800

table ipd_charges

id doctor room_category charges_cash charges_cashless

1 1 1 200 300

2 1 2 300 400

table patient_detail(patient_admission)

id patient_name tpa_name(if not null, equivalent to charges_cashless)

1 1 Null

2 2 1

table daily_ward_entry

id patient_name room_name(id) doctor_name(id) charges ( from ipd_charges)

1 1 1 1 200

2 2 2 1 400

Now there is a drop-down field in daily_ward_entry table for doctor. When I select the drop-down field the charges field needs to be autofilled.

I achieve this using Jason and ajax with the following code without taking into account the room_category. but the charges vary for room_category.(this is only working after saving the record, I prefer if there is someway to pull the charges before save.)

Here is my code in the controller:

public function actionChargesCash($id){

$model = \app\models\IpdCharges::findOne(['doctor'=>$id]);

return \yii\helpers\Json::encode(['visit_charges'=>$model->charges_cash]);

}

public function actionChargesCashLess($id){

$model= \app\models\IpdCharges::findOne(['doctor'=>$id]);

return \yii\helpers\Json::encode(['visit_charges'=>$model->charges_cashless]);

}

I have also tried this variaton:

public function actionChargesCash($id){

$model = \app\models\IpdCharges::find()

->where(['doctor'=>$id])

->andwhere(['room_category'=>'daily_ward_entry.room_name'])->one();

If I replace the 'daily_ward_entry.room_name' with room_name id like 3 or 6, I am getting the result, which means I am not using the correct syntax for referring the column from current table.

How can I include the condition for room_name in the above code? I need a code snippet to achieve this.

Thanks.

I can provide access to my set up through teamviewer if needed.

JavaScript jQuery / Prototype MySQL PHP

Project ID: #6864807

About the project