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]);
}
