public function actionFunctionalities($id = 3)
{
$project = Project::findOne($id);
$monthly = Functionality::find()->where("price > 1 AND project_id = " . $id . " AND monthly_costs = 1")->all();
//All(['project_id' => $id, 'monthly_costs' => 1],['price','>',1]);
$once = Functionality::find()->where("price > 1 AND project_id = " . $id . " AND monthly_costs = 0")->all();
//(['project_id' => $id, 'monthly_costs' => 0],['price','>',1]);
$solidCostsMonthly = new Functionality();
$solidCostsMonthly->name = "Vaste Maandelijkse Kosten";
$solidCostsMonthly->price = 39.95;
array_push($monthly, $solidCostsMonthly);
$solidCostOnce = new Functionality();
$solidCostOnce->name = "Vaste maandelijkse kosten";
$solidCostOnce->price = 250;
array_push($once, $solidCostOnce);
// var_dump($monthly); exit;
$oneOffDataProvider = new ArrayDataProvider(['allModels' => $once]);
$monthlyDataProvider = new ArrayDataProvider(['allModels' => $monthly]);
$this->layout = '@common/mail/layouts/html';
$totalMonthly = 0;
foreach ($monthlyDataProvider->allModels as $model) {
$totalMonthly += $model->price;
}
$totalOnce = 0;
foreach ($oneOffDataProvider->allModels as $model) {
$totalOnce += $model->price;
}
return $this->render('@common/mail/overviewMail-html', ['oneOffDataProvider' => $oneOffDataProvider, 'monthlyDataProvider' => $monthlyDataProvider, 'totalMonthly' => $totalMonthly, 'totalOnce' => $totalOnce]);
}
public function actionUpdate($id = 0)
{
// $out = ['status' => 'err', 'error' => 'Unknown error'];
if (\Yii::$app->user->isGuest) {
throw new NotFoundHttpException();
}
$r = new Request();
if (isset($r->post('Project')['id']) && $r->post('Project')['id']) {
$id = $r->post('Project')['id'];
}
// vd($r->post('Company'));
$userID = \Yii::$app->user->getId();
if ($id) {
$project = Project::findOne(['id' => $id, 'user_id' => $userID]);
} else {
$project = new Project();
// \Yii::$app->session->setFlash('error', 'Company ID is required.');
// $this->redirect(array('view','id'=>$company));
// $this->redirect(array('index'));
// return;
}
// vd($company);
if ($project) {
if ($project->load($r->post())) {
$project->user_id = $userID;
if ($project->validate() && $project->save()) {
//vd([$r->post(),$order->attributes]);
// $out = [
// 'status' => 'ok',
// 'order' => $order->id,
// 'user' => $order->user_id,
// 'sum' => $order->price / 100,
// ];
// $this->redirect(array('view','id'=>$company));
} else {
// vd($company->errors);
\Yii::$app->session->setFlash('error', array_values($project->errors)[0][0]);
// $out['error'] = array_values($order->errors)[0][0];
//vd($order->errors);
}
}
} else {
\Yii::$app->session->setFlash('error', 'Такой проект не существует');
$this->redirect(array('my'));
return;
}
return $this->render('update', ['project' => $project]);
// \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
// return $out;
/*vd(['get' => $r->getQueryParams() ,
'post' => $r->post(),
'order' => $order],1); //*/
}
/**
* Finds the Project model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Project the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Project::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public function actionIndex($project)
{
$project_data = Project::findOne($project);
//vd($order);
return $this->render('index', ['project' => $project_data, 'order' => new Order(['project_id' => $project_data->id]), 'signup' => \Yii::$app->user->isGuest ? new SignupForm() : null]);
}
<?php
use yii\helpers\Html;
use common\models\Project;
/* @var $this yii\web\View */
/* @var $model common\models\Functionality */
$project = Project::findOne(['project_id' => $pid]);
$this->title = Yii::t('functionality', 'Create Functionality');
$this->params['breadcrumbs'][] = ['label' => Yii::t('app', 'Projects'), 'url' => ['/project/index']];
$this->params['breadcrumbs'][] = ['label' => $project->description, 'url' => ['/project/view', 'id' => $project->project_id]];
$this->params['breadcrumbs'][] = $this->title;
?>
<div class="functionality-create">
<h1><?php
echo Html::encode($this->title);
?>
</h1>
<?php
echo $this->render('_form', ['models' => $models]);
?>
</div>
/**
* Displays homepage.
*
* @return mixed
*/
public function actionIndex()
{
$project = Project::findOne(1);
return $this->render('index', ['project' => $project, 'persons' => $project->getOrders()->where('closed_at IS NOT NULL')->select('user_id')->distinct()->count()]);
}
