/** * Creates a new Transfererrefinv model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { $model = new Transfererrefinv(); if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['view', 'codecomptecomptable' => $model->codecomptecomptable, 'dat' => $model->dat]); } else { return $this->render('create', ['model' => $model]); } }
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]); }