public function actionStatinvest()
{
$stru = new Structure();
//$debut= new Dat; $fin = new Dat;
$MaterielInformatique = null;
$TerrainsDeConstruction = null;
$MaterielAutomobile = null;
$MobilierDeBureau = null;
$total = 0;
$prix = 0;
$MaterielInformatique = 0;
// if (($stru->load(Yii::$app->request->post())) && ($debut->load(Yii::$app->request->post()))
// && ($fin->load(Yii::$app->request->post())) ) {
if ($stru->load(Yii::$app->request->post())) {
$Fami452 = Famille::find()->where(['codecomptecomptable' => "218452"])->all();
foreach ($Fami452 as $f452) {
$codfam = $f452->codefamille;
$SousFam = Sousfamille::find()->where(['codefamille' => $codfam])->all();
foreach ($SousFam as $souFamillle) {
$codSouFam = $souFamillle->codesousfamille;
$biens = Bien::find()->where(['codesousfamille' => $codSouFam])->all();
foreach ($biens as $bien) {
$prix = $bien->prixachat;
$MaterielInformatique = $MaterielInformatique + $prix;
}
}
}
//traiter 2eme compte
$Fami2110 = Famille::find()->where(['codecomptecomptable' => "2110"])->all();
foreach ($Fami2110 as $f2110) {
$codfam = $f2110->codefamille;
$SousFam = Sousfamille::find()->where(['codefamille' => $codfam])->all();
foreach ($SousFam as $souFamillle) {
$codSouFam = $souFamillle->codesousfamille;
$biens = Bien::find()->where(['codesousfamille' => $codSouFam])->all();
foreach ($biens as $bien) {
$prix = $bien->prixachat;
$TerrainsDeConstruction = $TerrainsDeConstruction + $prix;
}
}
}
//traiter 3eme compte
$Fami218440 = Famille::find()->where(['codecomptecomptable' => "218440"])->all();
foreach ($Fami218440 as $f218440) {
$codfam = $f218440->codefamille;
$SousFam = Sousfamille::find()->where(['codefamille' => $codfam])->all();
foreach ($SousFam as $souFamillle) {
$codSouFam = $souFamillle->codesousfamille;
$biens = Bien::find()->where(['codesousfamille' => $codSouFam])->all();
foreach ($biens as $bien) {
$prix = $bien->prixachat;
$MaterielAutomobile = $MaterielAutomobile + $prix;
}
}
}
//traiter 4eme compte
$Fami218450 = Famille::find()->where(['codecomptecomptable' => "218450"])->all();
foreach ($Fami218450 as $f218450) {
$codfam = $f218450->codefamille;
$SousFam = Sousfamille::find()->where(['codefamille' => $codfam])->all();
foreach ($SousFam as $souFamillle) {
$codSouFam = $souFamillle->codesousfamille;
$biens = Bien::find()->where(['codesousfamille' => $codSouFam])->all();
foreach ($biens as $bien) {
$prix = $bien->prixachat;
$MobilierDeBureau = $MobilierDeBureau + $prix;
}
}
}
$total = $MaterielInformatique + $TerrainsDeConstruction + $MaterielAutomobile + $MobilierDeBureau;
}
return $this->render('statInvest', ['stru' => $stru, 'MaterielInformatique' => $MaterielInformatique, 'TerrainsDeConstruction' => $TerrainsDeConstruction, 'MaterielAutomobile' => $MaterielAutomobile, 'MobilierDeBureau' => $MobilierDeBureau, 'total' => $total]);
}
</div>
<div class="col-lg-12">
<div class="col-lg-6">
<label class="col-lg-3 control-label">Sous famille:</label>
<?php
echo $form->field($soufamille, 'designationsousfamille', ['horizontalCssClasses' => ['wrapper' => 'col-sm-3']])->dropDownList(ArrayHelper::map(Sousfamille::find()->asArray()->all(), 'designationsousfamille', 'designationsousfamille'), ['prompt' => '----------Choisir une sous-famille ----------'])->label(false);
?>
</div>
<div class="col-lg-6">
<label class="col-lg-3 control-label">Date commande:</label>
<?php
echo $form->field($cmd, 'datecmd')->widget(DatePicker::className(), ['template' => '{addon}{input}', 'clientOptions' => ['autoclose' => true, 'format' => 'dd/mm/yyyy']])->label(false);
?>
</div>
</div>
