/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Provisiot();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Provisiot'])) {
$model->attributes = $_POST['Provisiot'];
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->id));
}
}
$this->render('create', array('model' => $model));
}
public function provisiotRaportti($all, $thisYear, $thisMonth)
{
foreach ($all as $dataAll) {
$id = $dataAll->id;
// Omat
$u = User::model()->findAll(" myyjaID='" . $id . "' ");
$vahvistamattomat = array();
$maksamattomat = array();
foreach ($u as $data) {
$o = $this->ordersDataForProvision($data->id, $thisYear, $thisMonth);
foreach ($o as $ord) {
$v = date("Y-m-d", strtotime($ord->maksettu_pvm . " +14 day"));
$ord->hinta = $this->hintaLaske($ord, 0.3);
if ($v > date("Y-m-d")) {
$vahvistamattomat[$ord->id] = $ord->hinta;
} else {
$maksamattomat[$ord->id] = $ord->hinta;
}
}
}
// Muut
$u = User::model()->findAll(" paa_myyja='" . $id . "' ");
foreach ($u as $uu) {
if (isset($uu->id)) {
$criteria = new CDbCriteria();
$criteria->order = " id DESC ";
$criteria->condition = " myyjaID='" . $uu->id . "' ";
$u = User::model()->findAll($criteria);
foreach ($u as $data) {
$o = $this->ordersDataForProvision($data->id, $thisYear, $thisMonth);
$vahvistamattomat2 = 0;
foreach ($o as $ord) {
$v = date("Y-m-d", strtotime($ord->maksettu_pvm . " +14 day"));
$ord->hinta = $this->hintaLaske($ord, 0.1);
if ($v > date("Y-m-d")) {
$vahvistamattomat[$ord->id] = $ord->hinta;
} else {
$maksamattomat[$ord->id] = $ord->hinta;
}
}
}
}
}
//echo 'id '.$id.' '.array_sum($vahvistamattomat).'<br>';
$pr = new Provisiot();
$pr->myyja_id = $id;
$pr->vuosi = $thisYear;
$pr->kuukausi = $thisMonth;
if (array_sum($vahvistamattomat) > 0) {
$pr->vahvistamattomat_id = json_encode($vahvistamattomat);
$pr->vahvistamattomat = round(array_sum($vahvistamattomat), 2);
}
if (array_sum($maksamattomat) > 0) {
/*
echo '<pre>'.$id;
print_r($maksamattomat);
echo '</pre>';
*/
$pr->maksettu_id = json_encode($maksamattomat);
$pr->maksetut = round(array_sum($maksamattomat), 2);
} else {
$pr->maksetut = 0;
}
$pr->save();
}
}
