public function searchStructureLied($qualite) { // if ($qualite->pivot->structure_id)/* On vérifie qu'il y a bien une structure liée */ // { return Structure::find($qualite->pivot->structure_id); // } }
public function searchCodtype($params, $code) { $query = Structure::find()->where(['codestructure' => $code, 'typestructure' => ['siege', 'succursale']]); $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(['like', 'codestructure', $this->codestructure])->andFilterWhere(['like', 'codestructure_struct_chef', $this->codestructure_struct_chef])->andFilterWhere(['like', 'typestructure', $this->typestructure])->andFilterWhere(['like', 'adressestruct', $this->adressestruct])->andFilterWhere(['like', 'designation', $this->designation]); return $dataProvider; }
public function find($id) { Structure::find($id); }
public function actionExtraireecartthph() { $i = 0; $cpt = 0; $cptstr = 0; $model = new Inventorier(); $data = null; $searchModel = new InventorierSearch(); $dataProvider = $searchModel->searchInvph(Yii::$app->request->queryParams); $models = $dataProvider->getModels(); if ($model->load(Yii::$app->request->post())) { $querystr = Structure::find(); $dataProviderstr = new ActiveDataProvider(['query' => $querystr]); $modelsstr = $dataProviderstr->getModels(); foreach ($modelsstr as $rowstr) { if (intval($model->codestructure) == $rowstr->codestructure) { $model->designationstructure = $rowstr->designation; } } /***/ $query = Bien::find(); $dataProviderb = new ActiveDataProvider(['query' => $query]); $modelsb = $dataProviderb->getModels(); foreach ($modelsb as $rowb) { $cp = substr('' . $rowb->codebien, 0, 3); if ($cp != "211" && $cp != "212" && $cp != "213") { if ($rowb->statutbien == "areformer" || $rowb->statutbien == "affecte" || $rowb->statutbien == "en reparation" || $rowb->statutbien == "transfere") { if (($modeli = Inventorier::findOne($rowb->codebien)) !== null) { if ($rowb->statutbien == 'affecte') { $modelaff = Affecter::findOne($rowb->codebien); $bur = $modelaff->codebureau; } else { $bur = $this->dernierTransfert($rowb->codebien); } if ($modeli->bureau !== $bur && $modeli->bureau !== null && $bur != null) { $model->codebien = $rowb->codebien; $motif = "transféré de Bureau " . $bur . " au Bureau " . $modeli->bureau; $modelstr = Bureau::findOne($bur); $cdstr = "" . $model->codestructure; $cdstr2 = "" . $modelstr->codestructure; $comp = strcmp($cdstr, $cdstr2); echo "ici " . $comp; if ($comp == 0) { echo "ici "; $data[$i] = ['codebien' => $rowb->codebien, 'designation' => $rowb->designationbien, 'etat' => $rowb->etatbien, 'bureau' => $bur, 'statutbien' => $motif]; $i++; } $motif = null; } /*else { $data[$i] = ['codebien'=>$rowb->codebien, 'designation'=>$rowb->designationbien,'etat'=>$rowb->etatbien,]; $i++; }*/ } else { $bur = null; if ($rowb->statutbien == 'affecte') { $modelaff = Affecter::findOne($rowb->codebien); if (Affecter::findOne($rowb->codebien) !== null) { $bur = $modelaff->codebureau; } } else { if ($rowb->statutbien == "en reparation") { $bur = $this->dernierTransfert($rowb->codebien); if ($bur == null) { $modelaff = Affecter::findOne($rowb->codebien); if (Affecter::findOne($rowb->codebien) !== null) { $bur = $modelaff->codebureau; } } } else { $bur = $this->dernierTransfert($rowb->codebien); } } $modelstr = Bureau::findOne($bur); if (strcmp($model->codestructure, $modelstr->codestructure) == 0) { $modelstr = Bureau::findOne($bur); $cdstr = $model->codestructure; $cdstr2 = $modelstr->codestructure; if ($cdstr == $cdstr2) { $data[$i] = ['codebien' => $rowb->codebien, 'designation' => $rowb->designationbien, 'etat' => $rowb->etatbien, 'bureau' => $bur, 'statutbien']; $i++; $cptstr++; } } } } } } /***/ } else { $query = Bien::find(); $dataProviderb = new ActiveDataProvider(['query' => $query]); $modelsb = $dataProviderb->getModels(); foreach ($modelsb as $rowb) { if ($rowb->statutbien == "areformer" || $rowb->statutbien == "affecte" || $rowb->statutbien == "en reparation" || $rowb->statutbien == "transfere") { if (($modeli = Inventorier::findOne($rowb->codebien)) !== null) { if ($rowb->statutbien == 'affecte') { $modelaff = Affecter::findOne($rowb->codebien); $bur = $modelaff->codebureau; } else { $bur = $this->dernierTransfert($rowb->codebien); } if ($modeli->bureau !== $bur && $modeli->bureau !== null && $bur != null) { $model->codebien = $rowb->codebien; $motif = "transféré de Bureau " . $bur . " au Bureau " . $modeli->bureau; $cp = substr('' . $rowb->codebien, 0, 3); if ($cp != "211" && $cp != "212" && $cp != "213") { $data[$i] = ['codebien' => $rowb->codebien, 'designation' => $rowb->designationbien, 'etat' => $rowb->etatbien, 'bureau' => $bur, 'statutbien' => $motif]; $i++; $motif = null; $cp = null; } } /*else { $data[$i] = ['codebien'=>$rowb->codebien, 'designation'=>$rowb->designationbien,'etat'=>$rowb->etatbien,]; $i++; }*/ } else { $bur = null; if ($rowb->statutbien == 'affecte') { $modelaff = Affecter::findOne($rowb->codebien); if (Affecter::findOne($rowb->codebien) !== null) { $bur = $modelaff->codebureau; } } else { if ($rowb->statutbien == "en reparation") { $bur = $this->dernierTransfert($rowb->codebien); if ($bur == null) { $modelaff = Affecter::findOne($rowb->codebien); if (Affecter::findOne($rowb->codebien) !== null) { $bur = $modelaff->codebureau; } } } else { $bur = $this->dernierTransfert($rowb->codebien); } } $cp = substr('' . $rowb->codebien, 0, 3); if ($cp != "211" && $cp != "212" && $cp != "213") { $data[$i] = ['codebien' => $rowb->codebien, 'designation' => $rowb->designationbien, 'etat' => $rowb->etatbien, 'bureau' => $bur, 'statutbien']; $i++; $cpt++; $cp = null; } } } } } $model->ecarttotal = $cpt; $model->ecartstr = $cptstr; $dataProviderRes = new ArrayDataProvider(['allModels' => $data, 'key' => 'codebien', 'sort' => ['attributes' => ['codebien', 'designation', 'etat', 'bureau', 'statutbien']]]); $dataProvider = $dataProviderRes; return $this->render('extraireEcartThPh', ['dataProvider' => $dataProvider, 'model' => $model]); }
public function actionListstruct($id) { $countStruct = Structure::find()->where(['designation' => $id])->count(); $structures = Structure::find()->where(['designation' => $id])->all(); if ($countStruct > 0) { foreach ($structures as $struc) { echo "<option value='" . $struc->designation . "'>" . $struc->designation . "</option>"; } } else { echo "<option> - </option>"; } }