/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params, $id)
{
$query = Bien::find()->where(['codebien' => $id]);
$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, 'codesousfamille' => $this->codesousfamille, 'numfacture' => $this->numfacture, 'numcmd' => $this->numcmd, 'prixachat' => $this->prixachat, 'tauxamort' => $this->tauxamort, 'dureevie' => $this->dureevie, 'poids' => $this->poids]);
$query->andFilterWhere(['like', 'typebien', $this->typebien])->andFilterWhere(['like', 'designationbien', $this->designationbien])->andFilterWhere(['like', 'dateacquisition', $this->dateacquisition])->andFilterWhere(['like', 'statutbien', $this->statutbien])->andFilterWhere(['like', 'etatbien', $this->etatbien])->andFilterWhere(['like', 'typeamort', $this->typeamort])->andFilterWhere(['like', 'commentaire', $this->commentaire])->andFilterWhere(['like', 'datedebugarantie', $this->datedebugarantie]);
return $dataProvider;
}
public function searchBienReformer($params)
{
$query = Bien::find()->where(['statutbien' => "reformer"]);
// $query->joinWith(['affecter' => function($query) { $query->from(['affecter' => 'bien']); }]);
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10]]);
// enable sorting for the related column
/*$dataProvider->sort->attributes['bureau.designationbureau'] = [
'asc' => ['bureau.designationbureau' => SORT_ASC],
'desc' => ['bureau.designationbureau' => SORT_DESC],
];*/
$this->load($params);
if (!($this->load($params) && $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, 'codesousfamille' => $this->codesousfamille, 'numfacture' => $this->numfacture, 'numcmd' => $this->numcmd, 'prixachat' => $this->prixachat, 'tauxamort' => $this->tauxamort, 'dureevie' => $this->dureevie, 'poids' => $this->poids, 'garantie' => $this->garantie]);
$query->andFilterWhere(['like', 'typebien', $this->typebien])->andFilterWhere(['like', 'designationbien', $this->designationbien])->andFilterWhere(['like', 'dateacquisition', $this->dateacquisition])->andFilterWhere(['like', 'statutbien', $this->statutbien])->andFilterWhere(['like', 'etatbien', $this->etatbien])->andFilterWhere(['like', 'typeamort', $this->typeamort])->andFilterWhere(['like', 'commentaire', $this->commentaire])->andFilterWhere(['like', 'datedebugarantie', $this->datedebugarantie])->andFilterWhere(['like', 'dateenr', $this->dateenr]);
//->andFilterWhere(['LIKE', 'designationbureau', $this->bureau.designationbureau]);
return $dataProvider;
}
/**
* Creates a new Reparer model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new Reparer();
$dat = new Dat();
$bien = new Bien();
if ($model->load(Yii::$app->request->post()) && $dat->load(Yii::$app->request->post())) {
$codebien = $model->codebien;
$bien = Bien::find()->where(['codebien' => $codebien])->one();
if ($bien) {
$bien->statutbien = "en réparation";
$model->dt = $dat->dt;
$model->datefin = null;
//controle de date
$dateSysteme = date('d/m/Y');
//récupérer date systeme
$tabSys = explode('/', $dateSysteme);
//convertir en tableau dont le séparateur est /
$secSys = mktime(0, 0, 0, $tabSys[1], $tabSys[0], $tabSys[2]);
//convertir la date en seconde
$tabSorti = explode('/', $dat->dt);
$secSorti = mktime(0, 0, 0, $tabSorti[1], $tabSorti[0], $tabSorti[2]);
if ($secSys >= $secSorti) {
$dat->save();
$bien->save();
$model->save();
} else {
Yii::$app->getSession()->setFlash('danger', 'La date que vous avez entrée est superieure à celle du système. Veuillez entrer une date valide s il vous plait');
return $this->redirect(['create']);
}
} else {
Yii::$app->getSession()->setFlash('danger', 'Le code que vous avez entré est incorrect !');
return $this->render('create', ['model' => $model, 'dat' => $dat]);
}
return $this->redirect(['view', 'codebien' => $model->codebien, 'num_reg' => $model->num_reg, 'dt' => $model->dt]);
} else {
return $this->render('create', ['model' => $model, 'dat' => $dat]);
}
}
public function actionSortirbienautre()
{
$modelbien = new Bien();
$model = new Reformer();
$ref = new Reformer();
$data = null;
$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->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();
}
}
}
$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;
echo "type=" . $typ;
}
/*-----------------------------------------------tableau de resultat------------------------------------------------*/
if ($typ != "Don" && $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('sortirbienpatrimoineAutre', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model]);
}
public function searchListeReformeNonSortiePatrimoine($params)
{
$query = Bien::find()->where(['statutbien' => ['reformertransfinvamort', 'reformer']]);
//,'reformertransf'
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 20]]);
$this->load($params);
if (!($this->load($params) && $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, 'codesousfamille' => $this->codesousfamille, 'numfacture' => $this->numfacture, 'numcmd' => $this->numcmd, 'prixachat' => $this->prixachat, 'tauxamort' => $this->tauxamort, 'dureevie' => $this->dureevie, 'poids' => $this->poids, 'garantie' => $this->garantie]);
$query->andFilterWhere(['like', 'typebien', $this->typebien])->andFilterWhere(['like', 'designationbien', $this->designationbien])->andFilterWhere(['like', 'dateacquisition', $this->dateacquisition])->andFilterWhere(['like', 'statutbien', $this->statutbien])->andFilterWhere(['like', 'etatbien', $this->etatbien])->andFilterWhere(['like', 'typeamort', $this->typeamort])->andFilterWhere(['like', 'commentaire', $this->commentaire])->andFilterWhere(['like', 'datedebugarantie', $this->datedebugarantie])->andFilterWhere(['like', 'dateenr', $this->dateenr]);
//->andFilterWhere(['LIKE', 'designationbureau', $this->bureau.designationbureau]);
return $dataProvider;
}
public function actionAfficherinvph()
{
$model = new Inventorier();
$data = null;
$searchModel = new InventorierSearch();
$i = 0;
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
$modelinv = $dataProvider->getModels();
foreach ($modelinv as $row) {
$bien = Bien::findOne($row->codebien);
if ($row->comptage1 == '1' && $row->comptage2 == '1') {
$data[$i] = ['codebien' => $row->codebien, 'designation' => $bien->designationbien, 'etat' => $bien->etatbien, 'bureau' => $row->bureau];
$i++;
}
}
$dataProviderRes = new ArrayDataProvider(['allModels' => $data, 'key' => 'codebien', 'sort' => ['attributes' => ['codebien', 'designation', 'bureau']]]);
$dataProvider = $dataProviderRes;
return $this->render('consulterinvph', ['dataProvider' => $dataProvider, 'model' => $model]);
}
public function actionEtatimmobien()
{
$model = new Bien();
$data = array();
$i = 0;
$searchModel = new BienSearch();
$dataProvider = $searchModel->searchConsultationBien(Yii::$app->request->queryParams, '0');
$now = time();
$comptecomp = 00;
$totalActif = 0.0;
$totalDotation = 0.0;
$totalAmort = 0.0;
$totalvalNet = 0.0;
if ($model->load(Yii::$app->request->post())) {
$comptecomp = $model->comptecomptable;
$anneeExercice = $model->anneexercice;
$compte = $comptecomp;
$cpt = substr('' . $compte, 0, 3);
if ($cpt == "211" || $cpt == "212" || $cpt == "213") {
\Yii::$app->getSession()->setFlash('danger', "SVP insérer un compte comptable amortissable.");
return $this->render('etatImmoParBien', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'model' => $model]);
}
}
/*-----------------------------rechercher la famille --------------------------------------------*/
$modelRes = new Bien();
$searchModelF = new FamilleSearch();
$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);
$modelssf = $dataProvidersf->getModels();
foreach ($modelssf as $rowsF) {
/*--------------------------Rechercher liste des biens------------------------------*/
$dataProvider = $searchModel->searchConsultationBien(Yii::$app->request->queryParams, $rowsF->codesousfamille);
$models = $dataProvider->getModels();
foreach ($models as $row) {
$resultat = $this->CalculeAmortissements($row->dateacquisition, $anneeExercice, $row->dureevie, $row->prixachat);
$long = count($resultat) - 1;
/*---------------------------------------- tableau de resultat -----------------------------------*/
$formatter = \Yii::$app->formatter;
$resultat[$long][1] = number_format($resultat[$long][1], 2, ',', ' ');
$resultat[$long][2] = number_format($resultat[$long][2], 2, ',', ' ');
$resultat[$long][3] = number_format($resultat[$long][3], 2, ',', ' ');
$resultat[$long][4] = number_format($resultat[$long][4], 2, ',', ' ');
$data[$i] = ['comptecomptable' => $comptecomp, 'codebien' => $row->codebien, 'designationbien' => $row->designationbien, 'dateacquisition' => $row->dateacquisition, 'actifbrut' => $resultat[$long][1], 'dureevie' => $row->dureevie, 'dotation' => $resultat[$long][2], 'amortpratiquee' => $resultat[$long][3], 'valeurnet' => $resultat[$long][4]];
$i++;
}
}
}
$dataProviderRes = new ArrayDataProvider(['allModels' => $data, 'sort' => ['attributes' => ['comptecomptable', 'codebien', 'designationbien', 'dateacquisition', 'actifbrut', 'dureevie', 'dotation', 'amortpratiquee', 'valeurnet']]]);
$dataProvider = $dataProviderRes;
return $this->render('etatImmoParBien', ['searchModel' => $searchModel, 'dataProvider' => $dataProviderRes, 'model' => $model]);
}