public function actionIntervcession()
 {
     $modelbien = new Bien();
     $model = new Reformer();
     $modelss = new Intervenant();
     $n = 0;
     $data = null;
     $selectionn = (array) Yii::$app->request->post('selection');
     $selection = (array) Yii::$app->request->post('selection');
     foreach ($selectionn as $idn) {
         $n++;
     }
     if ($n < 2) {
         foreach ($selection as $id) {
             $modelref = new Reformer();
             $x = 0;
             $modelIntervSearch = new IntervenantSearch();
             $dataProviderinter = $modelIntervSearch->searchinter(Yii::$app->request->queryParams, $id);
             //$dataProviderinter = $modelIntervSearch->searchinter(Yii::$app->request->queryParams);
             $modelinter = $dataProviderinter->getModels();
             foreach ($modelinter as $rowinter) {
                 $modelReformerSearch = new ReformerSearch();
                 $dataProviderRS = $modelReformerSearch->searchRefbool(Yii::$app->request->queryParams, '1');
                 $modelb = $dataProviderRS->getModels();
                 foreach ($modelb as $rowb) {
                     if ($rowb->booleann == '1') {
                         $modelref = $this->findModel($rowb->codebien);
                         $modelref->titre = $rowinter->titre;
                         $modelref->booleann = "2";
                         $modelref->save();
                         $query = Bien::find()->where(['codebien' => $rowb->codebien]);
                         $dataProviderBien = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10]]);
                         $modelsortir = $dataProviderBien->getModels();
                         foreach ($modelsortir as $rowbs) {
                             $modelbien->codebien = $rowbs->codebien;
                             $rowbs->statutbien = "sortirf";
                             $rowbs->save();
                         }
                     }
                 }
             }
         }
     } else {
         \Yii::$app->getSession()->setFlash('info', 'SVP choisir un seul intervenant.');
     }
     $searchModel = new BienSearch();
     $i = 0;
     $dataProvider = $searchModel->searchListeReformeNonSortiePatrimoine(Yii::$app->request->queryParams);
     $models = $dataProvider->getModels();
     foreach ($models as $row) {
         /*---------------------------------  recherche type de reforme et la date de reforme ------------------------*/
         $comptecomp = $this->cherchercomptebien($row->codebien);
         $modelReformerSearch = new ReformerSearch();
         $dataProviderRS = $modelReformerSearch->searchRef(Yii::$app->request->queryParams, $row->codebien);
         $modelb = $dataProviderRS->getModels();
         $typ = null;
         $ann = null;
         foreach ($modelb as $rowb) {
             $typ = $rowb->typereforme;
             $ann = $rowb->datereforme;
             $modelboole = $this->findModel($rowb->codebien);
             if ($modelboole->booleann == '1') {
                 $modelboole->booleann = '0';
                 $modelboole->save();
             }
         }
         /*-----------------------------------------------tableau de resultat------------------------------------------------*/
         if ($typ == "Cession") {
             $data[$i] = ['comptecomptable' => $comptecomp, 'codebien' => $row->codebien, 'designationbien' => $row->designationbien, 'typereforme' => $typ, 'dateRef' => $ann];
             $i++;
         }
     }
     $dataProviderRes = new ArrayDataProvider(['key' => 'codebien', 'allModels' => $data, 'sort' => ['attributes' => ['comptecomptable', 'codebien', 'designationbien', 'typereforme', 'dateRef']]]);
     $dataProvider = $dataProviderRes;
     return $this->render('sortirbienpatrimoine', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model]);
     $searchModel = new IntervenantSearch();
     $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
     return $this->render('test', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]);
 }
 public function actionIntervcession()
 {
     $model = new Bien();
     $modelss = new Intervenant();
     $data = null;
     $selection = (array) Yii::$app->request->post('selection');
     foreach ($selection as $id) {
         $modelref = new Reformer();
         $x = 0;
         $modelss = $this->findModel($id);
         $modelReformerSearch = new ReformerSearch();
         $dataProviderRS = $modelReformerSearch->searchRefbool(Yii::$app->request->queryParams, '1');
         $modelb = $dataProviderRS->getModels();
         foreach ($modelb as $rowb) {
             if ($rowb->booleann == '1') {
                 $modelref->codebien = $rowb->codebien;
                 $modelref->typereforme = '' . $rowb->typereforme;
                 $modelref->datereforme = $rowb->datereforme;
                 $modelref->prixvente = floatval($rowb->prixvente);
                 $modelref->titre = '' . $modelss->titre;
                 $modelref->booleann = "2";
                 $modelref->save();
             }
         }
     }
     $searchModel = new BienSearch();
     $i = 0;
     $dataProvider = $searchModel->searchListeReformeNonSortiePatrimoine(Yii::$app->request->queryParams);
     $models = $dataProvider->getModels();
     foreach ($models as $row) {
         /*---------------------------------  recherche type de reforme et la date de reforme ------------------------*/
         $comptecomp = $this->cherchercomptebien($row->codebien);
         $modelReformerSearch = new ReformerSearch();
         $dataProviderRS = $modelReformerSearch->searchRef(Yii::$app->request->queryParams, $row->codebien);
         $modelb = $dataProviderRS->getModels();
         $typ = null;
         $ann = null;
         foreach ($modelb as $rowb) {
             $typ = $rowb->typereforme;
             $ann = $rowb->datereforme;
         }
         /*-----------------------------------------------tableau de resultat------------------------------------------------*/
         if ($typ == "Cession") {
             $data[$i] = ['comptecomptable' => $comptecomp, 'codebien' => $row->codebien, 'designationbien' => $row->designationbien, 'typereforme' => $typ, 'dateRef' => $ann];
             $i++;
         }
     }
     $dataProviderRes = new ArrayDataProvider(['key' => 'codebien', 'allModels' => $data, 'sort' => ['attributes' => ['comptecomptable', 'codebien', 'designationbien', 'typereforme', 'dateRef']]]);
     $dataProvider = $dataProviderRes;
     return $this->render('sortirbienpatrimoine', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model]);
     $searchModel = new IntervenantSearch();
     $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
     return $this->render('test', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]);
 }