public function searchInvph($params)
{
$query = Inventorier::find()->where(['inventairephysic' => '1']);
$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, 'anneeinv' => $this->anneeinv, 'comptage1' => $this->comptage1, 'comptage2' => $this->comptage2, 'comptage3' => $this->comptage3]);
$query->andFilterWhere(['like', 'obs', $this->obs])->andFilterWhere(['like', 'bureau', $this->bureau])->andFilterWhere(['like', 'inventairephysic', $this->inventairephysic]);
return $dataProvider;
}
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]);
}
