public function actionAfficherecartcomptage()
 {
     $i = 0;
     $cpt1 = 0;
     $cpt2 = 0;
     $cpttotal = 0;
     $cptstr = 0;
     $data = null;
     $model = new Inventorier();
     $searchModel = new InventorierSearch();
     $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
     $cpttotal = $dataProvider->getTotalCount();
     $models = $dataProvider->getModels();
     /**************************traiter ecart entre les deux comptages **************************************/
     $selection = (array) Yii::$app->request->post('selection');
     //typecasting
     foreach ($selection as $id) {
         $modeltr = $this->findModel($id);
         $modeltr->comptage1 = '1';
         $modeltr->comptage2 = '1';
         $modeltr->save();
     }
     if ($model->load(Yii::$app->request->post())) {
         $querystr = Structure::find();
         $dataProviderstr = new ActiveDataProvider(['query' => $querystr]);
         $modelsstr = $dataProviderstr->getModels();
         foreach ($modelsstr as $rowstr) {
             if (intval($model->codestructure) == $rowstr->codestructure) {
                 $model->designationstructure = $rowstr->designation;
             }
         }
         $searchModelbur = new BureauSearch();
         $dataProviderbur = $searchModelbur->search(Yii::$app->request->queryParams);
         $modelsbur = $dataProviderbur->getModels();
         foreach ($modelsbur as $rowbur) {
             if ($rowbur->codestructure == intval($model->codestructure)) {
                 $searchModelaff = new AffecterSearch();
                 $dataProvideraff = $searchModelaff->searchCodbur(Yii::$app->request->queryParams, $rowbur->codebureau);
                 $modelsaff = $dataProvideraff->getModels();
                 foreach ($modelsaff as $rowaff) {
                     $searchModelbien = new BienSearch();
                     $dataProviderbien = $searchModelbien->searchConsultationBienSelonCodestatut(Yii::$app->request->queryParams, $rowaff->codebien);
                     $modelbien = $dataProviderbien->getModels();
                     foreach ($modelbien as $rowbien) {
                         if ($rowbien->statutbien == "affecte") {
                             $modeltrouv = Inventorier::findOne($rowbien->codebien);
                             if (($modeltrouv = Inventorier::findOne($rowbien->codebien)) !== null) {
                                 $cptstr++;
                                 if ($modeltrouv->comptage1 !== '1' && $modeltrouv->comptage2 == '1' || $modeltrouv->comptage1 == '1' && $modeltrouv->comptage2 !== '1') {
                                     if ($modeltrouv->comptage1 == '1' && $modeltrouv->comptage2 == '1') {
                                     } else {
                                         $data[$i] = ['codebien' => $rowbien->codebien, 'designation' => $rowbien->designationbien, 'bureau' => $rowbur->codebureau, 'etat' => $rowbien->etatbien];
                                         $i++;
                                         $cpt1++;
                                     }
                                 }
                             }
                         } else {
                             if ($rowbien->statutbien == "transfere") {
                                 $bur = $this->dernierTransfert($rowbien->codebien);
                                 $modeltrouv = Inventorier::findOne($rowbien->codebien);
                                 if (($modeltrouv = Inventorier::findOne($rowbien->codebien)) !== null) {
                                     $cptstr++;
                                     if ($modeltrouv->comptage1 == '1' && $modeltrouv->comptage2 !== '1' || $modeltrouv->comptage1 !== '1' && $modeltrouv->comptage2 == '1') {
                                         if ($modeltrouv->comptage1 == '1' && $modeltrouv->comptage2 == '1') {
                                         } else {
                                             $data[$i] = ['codebien' => $rowbien->codebien, 'designation' => $rowbien->designationbien, 'bureau' => $bur, 'etat' => $rowbien->etatbien];
                                             $i++;
                                             $cpt1++;
                                         }
                                     }
                                 }
                             }
                         }
                     }
                 }
             }
         }
         $prc = 0;
         if ($cptstr != 0) {
             $prc = $cpt1 / $cptstr;
             $prc = $prc * 100;
         }
         $prc = number_format($prc, 2, ',', ' ');
         $model->pourcentageecart = $prc . " %";
         $dataProviderRes = new ArrayDataProvider(['allModels' => $data, 'key' => 'codebien', 'sort' => ['attributes' => ['codebien', 'designation', 'bureau', 'etat']]]);
         //  $modeltest=$dataProviderRes->getModels();
         $dataProvider = $dataProviderRes;
     } else {
         foreach ($models as $row) {
             if ($row->comptage1 == '1' && $row->comptage2 != '1') {
                 $rowbien = Bien::findOne($row->codebien);
                 $data[$i] = ['codebien' => $row->codebien, 'designation' => $rowbien->designationbien, 'bureau' => $row->bureau, 'etat' => $rowbien->etatbien];
                 $i++;
                 $cpt1++;
             } else {
                 if ($row->comptage1 != '1' && $row->comptage2 == '1') {
                     $rowbien = Bien::findOne($row->codebien);
                     $data[$i] = ['codebien' => $row->codebien, 'designation' => $rowbien->designationbien, 'bureau' => $row->bureau, 'etat' => $rowbien->etatbien];
                     $i++;
                     $cpt1++;
                 }
             }
         }
         $prc = 0;
         if ($cpttotal != 0) {
             $prc = $cpt1 / $cpttotal;
         }
         $prc = $prc * 100;
         $seuil = 0;
         $modelin = new Exerciceinventaire();
         $searchModelexerc = new ExerciceinventaireSearch();
         $dataProviderexerc = $searchModelexerc->search(Yii::$app->request->queryParams);
         $modelsexerc = $dataProviderexerc->getModels();
         foreach ($modelsexerc as $rowex) {
             if ($rowex->anneeinv == date('Y')) {
                 $seuil = $rowex->seuil_compte;
                 if ($seuil <= $prc) {
                     \Yii::$app->getSession()->setFlash('info', "L'écart entre les deux comptage est arrivé au seil, Vous devez passer au troisième comptage.");
                 }
             }
         }
         $prc = number_format($prc, 2, ',', ' ');
         $prc = $prc . " %";
         $model->pourcentageecart = $prc;
         $dataProviderRes = new ArrayDataProvider(['allModels' => $data, 'key' => 'codebien', 'sort' => ['attributes' => ['codebien', 'designation', 'bureau', 'etat']]]);
         //  $modeltest=$dataProviderRes->getModels();
         $dataProvider = $dataProviderRes;
     }
     return $this->render('extraireEcartComptage', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model]);
 }
 public function actionIndexrefo()
 {
     $searchModel = new BienSearchReforme();
     $dataProvideraff = $searchModel->search(Yii::$app->request->queryParams);
     $i = 0;
     $data = null;
     $desunite = null;
     $desstr = null;
     $models = $dataProvideraff->getModels();
     foreach ($models as $row) {
         $searchModelaff = new AffecterSearch();
         $dataProvideraff = $searchModelaff->searchCod(Yii::$app->request->queryParams, $row->codebien);
         $modelsaff = $dataProvideraff->getModels();
         $y = 0;
         foreach ($modelsaff as $rowaff) {
             $searchModelbur = new BureauSearch();
             $dataProviderbur = $searchModelbur->searchCod(Yii::$app->request->queryParams, $rowaff->codebureau);
             $modelsbur = $dataProviderbur->getModels();
             foreach ($modelsbur as $rowbur) {
                 $trouv = false;
                 $codstr = $rowbur->codestructure;
                 do {
                     $searchModelstr = new StructureSearch();
                     $dataProviderstr = $searchModelstr->searchCod(Yii::$app->request->queryParams, $codstr);
                     $modelsstr = $dataProviderstr->getModels();
                     foreach ($modelsstr as $rowstr) {
                         if ($y == 0) {
                             $desstr = $rowstr->designation;
                             $y++;
                         }
                         $dataProviderstrt = $searchModelstr->searchCodtype(Yii::$app->request->queryParams, $rowstr->codestructure);
                         $modelsstrt = $dataProviderstrt->getModels();
                         if ($dataProviderstrt->getTotalCount() != 0) {
                             foreach ($modelsstrt as $rowstrt) {
                                 $desunite = $rowstrt->designation;
                             }
                             $trouv = true;
                         } else {
                             $codstr = $rowstr->codestructure_struct_chef;
                         }
                     }
                 } while ($trouv == false);
                 $data[$i] = ['codebien' => $row->codebien, 'désignation' => $row->designationbien, 'état' => $row->etatbien, 'date enregistrement' => $row->dateenr, 'structure' => $desstr, 'unité' => $desunite];
                 $i++;
             }
         }
     }
     $dataProviderRes = new ArrayDataProvider(['allModels' => $data, 'key' => 'codebien', 'sort' => ['attributes' => ['codebien', 'désignation', 'état', 'date enregistrement', 'unité', 'structure']]]);
     $dataProvider = $dataProviderRes;
     return $this->render('indexReforme', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]);
 }