public function actionListereformeenonsortirpatrimoine()
 {
     $i = 0;
     $model = new Reformer();
     $searchModel = new ReformerSearch();
     $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
     $data = array();
     $models = $dataProvider->getModels();
     if ($model->load(Yii::$app->request->post())) {
         $type = null;
         $type = $model->typereforme;
         if ($type == 0) {
             $type = "Cession";
         }
         if ($type == 1) {
             $type = "Don";
         }
         if ($type == 2) {
             $type = "Mise au rebut";
         }
         if ($type == 3) {
             $type = "Perdu";
         }
         foreach ($models as $row) {
             $searchModelB = new BienSearch();
             $ress = explode('/', $row->datereforme);
             $annee = $ress[2];
             if (strlen($model->anneeRef) == 4) {
                 if ($model->anneeRef <= date('Y')) {
                     $manneeRef = substr($model->anneeRef, -2);
                     if ($manneeRef == $annee) {
                         if ($type == $row->typereforme) {
                             $dataProviderB = $searchModelB->searchListeReformee(Yii::$app->request->queryParams, $row->codebien);
                             $modelsB = $dataProviderB->getModels();
                             foreach ($modelsB as $rowB) {
                                 if ($rowB->statutbien != "sortirf") {
                                     $data[$i] = ['codebien' => $row->codebien, 'designation bien' => $rowB->designationbien, 'type reforme' => $row->typereforme, 'date reforme' => $row->datereforme];
                                 }
                                 $i++;
                             }
                         }
                     }
                 } else {
                     \Yii::$app->getSession()->setFlash('info', "SVP insérer une année  inférieur à l'année actuelle.");
                 }
             } else {
                 \Yii::$app->getSession()->setFlash('info', "SVP resaisir l'année de réforme.");
             }
         }
     }
     $dataProviderRes = new ArrayDataProvider(['allModels' => $data, 'sort' => ['attributes' => ['codebien', 'designation bien', 'dateacquisition', 'type reforme', 'date reforme']]]);
     //  $modeltest=$dataProviderRes->getModels();
     $dataProvider = $dataProviderRes;
     return $this->render('listeBienReformerNonSortie', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model]);
 }