コード例 #1
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Transfererrefinv::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to return any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     $query->andFilterWhere(['codecomptecomptable' => $this->codecomptecomptable, 'codecomptecomptableref' => $this->codecomptecomptableref, 'mnt' => $this->mnt]);
     $query->andFilterWhere(['like', 'dat', $this->dat]);
     return $dataProvider;
 }
コード例 #2
0
 /**
  * Finds the Transfererrefinv model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $codecomptecomptable
  * @param string $dat
  * @return Transfererrefinv the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($codecomptecomptable, $dat)
 {
     if (($model = Transfererrefinv::findOne(['codecomptecomptable' => $codecomptecomptable, 'dat' => $dat])) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }
コード例 #3
0
 public function actionListcompteatrensferer()
 {
     $model = new Bien();
     $data = array();
     $i = 0;
     $searchModel = new BienSearch();
     $now = time();
     $comptecomp = 00;
     $dattr = null;
     if ($model->load(Yii::$app->request->post())) {
         $dattr = $model->datetrensfert;
         if ($dattr <= date('Y')) {
             $selection = (array) Yii::$app->request->post('selection');
             foreach ($selection as $id) {
                 $x = 0;
                 $model = $this->findModel($id);
                 $searchModelsf = new SousFamilleSearch();
                 $dataProvidersf = $searchModelsf->searchSF(Yii::$app->request->queryParams, $model->codesousfamille);
                 $modelssf = $dataProvidersf->getModels();
                 foreach ($modelssf as $rowsF) {
                     $searchModelF = new FamilleSearch();
                     $dataProviderF = $searchModelF->searchFC(Yii::$app->request->queryParams, $rowsF->codefamille);
                     $modelF = $dataProviderF->getModels();
                     foreach ($modelF as $rowF) {
                         $searchModelCc = new ComptecomptableSearch();
                         $dataProviderCc = $searchModelCc->search(Yii::$app->request->queryParams, $rowF->codecomptecomptable);
                         $modelCc = $dataProviderCc->getModels();
                         foreach ($modelCc as $rowCc) {
                             $searchModeltrans = new transfererrefinvSearch();
                             $dataProvidertrans = $searchModeltrans->searchRef(Yii::$app->request->queryParams, $rowCc->codecomptecomptable, $rowCc->comptecomptableref, $dattr);
                             $modeltrans = $dataProvidertrans->getModels();
                             if ($dataProvidertrans->getTotalCount() != 0) {
                                 foreach ($modeltrans as $rowtrans) {
                                     $modeltresfer = new Transfererrefinv();
                                     $modeltresfer->dat = $dattr;
                                     $modeltresfer = Transfererrefinv::findOne(['codecomptecomptable' => $rowtrans->codecomptecomptable, 'dat' => $dattr]);
                                     $resultat = $rowtrans->mnt;
                                     $resultat = intval($resultat) + $model->prixachat;
                                     $modeltresfer->mnt = '' . $resultat;
                                     $modeltresfer->save();
                                     $model->statutbien = 'reformertransf';
                                     if ($dattr != null) {
                                         $model->save();
                                     } else {
                                         if ($x == 0) {
                                             $x = 1;
                                             \Yii::$app->getSession()->setFlash('danger', "SVP saisir l'année de l'exercice.");
                                         }
                                     }
                                 }
                             } else {
                                 $modeltresfer = new Transfererrefinv();
                                 $modeltresfer->dat = $dattr;
                                 $modeltresfer->codecomptecomptable = '' . $rowCc->codecomptecomptable;
                                 $modeltresfer->codecomptecomptableref = '' . $rowCc->comptecomptableref;
                                 $modeltresfer->mnt = '' . $model->prixachat;
                                 $modeltresfer->save();
                                 $model->statutbien = 'reformertransf';
                                 if ($dattr != null) {
                                     $model->save();
                                 } else {
                                     \Yii::$app->getSession()->setFlash('danger', "SVP saisir l'année de l'exercice.");
                                 }
                             }
                         }
                     }
                 }
             }
         } else {
             \Yii::$app->getSession()->setFlash('danger', "L'année de l'exercice doit être égale ou inférieur à l'année actuelle.");
         }
     }
     $searchModelC = new ComptecomptableSearch();
     $dataProviderc = $searchModelC->searchC(Yii::$app->request->queryParams);
     $modelc = Comptecomptable::find()->all();
     foreach ($modelc as $rowc) {
         /*-----------------------------rechercher la famille --------------------------------------------*/
         $modelRes = new Bien();
         $searchModelF = new FamilleSearch();
         $comptecomp = $rowc->codecomptecomptable;
         $dataProviderF = $searchModelF->searchF(Yii::$app->request->queryParams, $comptecomp);
         $modelF = $dataProviderF->getModels();
         foreach ($modelF as $rowF) {
             /*----------------------Rechercher la sous famille ------------------------------------------*/
             $searchModelsf = new SousFamilleSearch();
             $dataProvidersf = $searchModelsf->search(Yii::$app->request->queryParams, $rowF->codefamille);
             //$modelsf = Bien::findOne();
             $modelssf = $dataProvidersf->getModels();
             foreach ($modelssf as $rowsF) {
                 /*--------------------------Rechercher liste des biens------------------------------*/
                 $dataProvider = $searchModel->searchConsultationBienReforme(Yii::$app->request->queryParams, $rowsF->codesousfamille);
                 $models = $dataProvider->getModels();
                 foreach ($models as $row) {
                     //echo "-------sousfamille-".$row->codesousfamille;
                     //echo "-----------".$row->designationbien;
                     if ($row->statutbien == "reformer" || $row->statutbien == "reformertransfamort") {
                         /*---------------------------------  recherche type de reforme et la date de reforme ------------------------*/
                         $modelReformerSearch = new ReformerSearch();
                         $dataProviderRS = $modelReformerSearch->searchRef(Yii::$app->request->queryParams, $row->codebien);
                         $modelb = $dataProviderRS->getModels();
                         $typ = null;
                         $ann = null;
                         foreach ($modelb as $rowb) {
                             // echo "bien reformer ".$rowb->codebien;
                             $typ = $rowb->typereforme;
                             $ann = $rowb->datereforme;
                             /*----------------------------------   tableau de resultat              -----------------------------------*/
                             $data[$i] = ['comptecomptable' => $comptecomp, 'codebien' => $rowb->codebien, 'designationbien' => $row->designationbien, 'prixachat' => $row->prixachat, 'typereforme' => $typ, 'dateRef' => $ann];
                             $i++;
                         }
                     }
                 }
             }
         }
     }
     $dataProviderRes = new ArrayDataProvider(['allModels' => $data, 'key' => 'codebien', 'sort' => ['attributes' => ['comptecomptable', 'codebien', 'designationbien', 'prixachat', 'typereforme', 'dateRef']]]);
     $dataProvider = $dataProviderRes;
     return $this->render('listeBienAtransferer', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model]);
 }