yii2 create history contract from old id

Question

I'm trying to display a contract history following old id. If an employee create new contract so he is can see the last contract in view history contract. I have tried it but only can display one last contract. if the employee have 2 last contract, in view only one appears.

this my contract controller

    public function actionView($id)
{
    $model = $this ->findModel($id);
    $employee = $model->employee;
    $params = [":old" => $employee->old_id];
    $result = Yii::$app->db->createCommand('select * from employee where id=:old or old_id=:old', $params)->queryOne();

    $contractQuery = Contract::find()->where(['id_contract' => $result]);

    $dataProvider = new ActiveDataProvider([
        'query' => $contractQuery ,
        'pagination' => [
            'pageSize' => 20,
        ],
    ]);

    return $this->render('view', [
        'model' => $model,
        'teNumDataProvider' => $teNumDataProvider,
    ]);
}

contract.php models

public function getEmployee()
{
return $this->hasOne(Employee::className(), ['id' => 'id_employee']);
}

view.php

<div class="contract-index">
<h4>History Contract</h4>

<?= GridView::widget([
    'dataProvider' => $dataProvider,
    'columns' => [
        ['class' => 'yii\grid\SerialColumn'],
        'id',
        'id_employee',
        'startdate:date',
        'enddate:date',
        'employee_status',
        'status',

        [
            'class' => 'yii\grid\ActionColumn',
            'visible' => FALSE,
        ],
    ],
]); ?>

ScaisEdge · Accepted Answer · 2017-05-22T10:10:06.283

0

You should get the column name from the $result (eg: $result->contract_id);

$result = Yii::$app->db->createCommand('select * from employee 
                       where id=:old or old_id=:old', $params)->queryOne();

$contractQuery = Contract::find()->where(['id_contract' => $result->contract_id]);

and the action if your build a var named $dataProvider you should use in render the same varname

return $this->render('view', [
    'model' => $model,
    'dataProvider' => $dataProvider,
]);

and last you in this way in your gridview the $dataProvider contain the values you buil wuth the query in action

 <?= GridView::widget([
   'dataProvider' => $dataProvider,
   ...

edited May 22 '17 at 10:10

answered May 22 '17 at 05:42

ScaisEdge

131,976
10
91
107

thanks for your answer. I have try it but nothing to change. Do you have another solution? – Ryan Pasaribu May 22 '17 at 06:44
seems weird that the where condition work is same way with a substantial sintax difference .. are you sure you have no errors? – ScaisEdge May 22 '17 at 06:46
Looking to your code you have wron param in render function .. answer updated with some suggestion .. hope is all clear .. – ScaisEdge May 22 '17 at 10:09
@BinPas well if my answer is right please mark it as accepted ...see how here http://meta.stackexchange.com/questions/5234/how-does-accepting-an-answer-work – ScaisEdge May 23 '17 at 09:41

yii2 create history contract from old id

1 Answers1