public function actionSortirbiendon() { $modelbien = new Bien(); $model = new Reformer(); $ref = new Reformer(); $data = null; if ($model->load(Yii::$app->request->post())) { $selection = (array) Yii::$app->request->post('selection'); foreach ($selection as $id) { $x = 0; $modelss = $this->findModel($id); $modelReformerSearch = new ReformerSearch(); $dataProviderRS = $modelReformerSearch->searchRef(Yii::$app->request->queryParams, $modelss->codebien); $modelb = $dataProviderRS->getModels(); foreach ($modelb as $rowb) { //$modelss->prixvente=$model->prixvente; //$modelss->booleann="1"; if ($model->titre != null) { $modelss->titre = $model->titre; $modelss->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 choisissez une unite.'); } } } } $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 == "Don") { $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('sortirbienpatrimoineDon', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model]); }
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]); }
public function searchListeReforme($params) { $query = Reformer::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(['codebien' => $this->codebien, 'prixvente' => $this->prixvente]); $query->andFilterWhere(['like', 'titre', $this->titre])->andFilterWhere(['like', 'typereforme', $this->typereforme])->andFilterWhere(['like', 'datereforme', $this->datereforme])->andFilterWhere(['like', 'booleann', $this->booleann]); return $dataProvider; }
/** * c bon * Valider liste des bien à reformer * */ public function actionValider() { $model = new Bien(); if ($model->load(Yii::$app->request->post())) { $selection = (array) Yii::$app->request->post('selection'); //typecasting foreach ($selection as $id) { //$model = new Bien(); $modelRef = new Reforme(); $modelReformer = new Reformer(); $typeRef = $model->typereforme; $dateeRef = $model->dateRef; if ($dateeRef != null && $typeRef != null) { $model = $this->findModel($id); $datsep = explode('/', $dateeRef); $ss = explode('20', $datsep[2]); $datsep[2] = $ss[1]; $secdtref = mktime(0, 0, 0, $datsep[1], $datsep[0], $datsep[2]); $daten = explode('/', $model->dateenr); $secdten = mktime(0, 0, 0, $daten[1], $daten[0], $daten[2]); $auj = date('m/d/y'); $datau = explode('/', $auj); $secdtau = mktime(0, 0, 0, $datau[0], $datau[1], $datau[2]); if ($secdtau >= $secdtref && $secdtref >= $secdten) { $ress = explode('/', $dateeRef); $annee = $ress[2]; $modelRef->datereforme = "" . $annee; $modelRef->save(); if ($model->statutbien == 'reformer') { \Yii::$app->getSession()->setFlash('danger', 'Le bien' . $model->codebien . ' à été dejà réformé.'); $date = date('d/m/Y'); $model = new Bien(); $model->dateRef = $date; } else { if ($dateeRef != null && $typeRef != null) { $datsep = explode('/', $dateeRef); $model->statutbien = 'reformer'; $model->save(); $modelReformer->codebien = $model->codebien; $modelReformer->datereforme = "" . $dateeRef; if ($typeRef == 0) { $model->typereforme = "Cession"; } else { if ($typeRef == 1) { $model->typereforme = "Don"; } else { if ($typeRef == 2) { $model->typereforme = "Mise au rebut"; } else { if ($typeRef == 3) { $model->typereforme = "Perdu"; } } } } $modelReformer->typereforme = $model->typereforme; $modelReformer->save(); \Yii::$app->getSession()->setFlash('success', 'validation avec succée'); $date = date('d/m/Y'); $model = new Bien(); $model->dateRef = $date; } else { if ($dateeRef == null) { \Yii::$app->getSession()->setFlash('danger', 'SVP insérer une date valable. '); $date = date('d/m/Y'); $model = new Bien(); $model->dateRef = $date; } else { if ($typeRef == null) { \Yii::$app->getSession()->setFlash('danger', 'SVP choisir le type de réforme. '); $date = date('d/m/Y'); $model = new Bien(); $model->dateRef = $date; } } } } } else { //($secdtau>=$secdtref)&& if ($secdtref < $secdten) { \Yii::$app->getSession()->setFlash('danger', "la date de réforme doit être supérieur à la date de proposition du bien à la réforme."); $date = date('d/m/Y'); $model = new Bien(); $model->dateRef = $date; } else { \Yii::$app->getSession()->setFlash('danger', 'SVP insérer une date valable. '); $date = date('d/m/Y'); $model = new Bien(); $model->dateRef = $date; } } } else { if ($dateeRef == null) { \Yii::$app->getSession()->setFlash('danger', 'SVP insérer une date valable. '); $date = date('d/m/Y'); $model = new Bien(); $model->dateRef = $date; } else { if ($typeRef == null) { \Yii::$app->getSession()->setFlash('danger', 'SVP choisir le type de réforme. '); $date = date('d/m/Y'); } } } } } else { $model = new Bien(); $date = date('d/m/Y'); $model->dateRef = $date; } $model = new Bien(); $date = date('d/m/Y'); $model->dateRef = $date; $searchModel = new BienSearchReforme(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); return $this->render('valider', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model]); }