/**
* Lists all Account models.
* @return mixed
*/
public function actionIndex()
{
$models = Account::hierarcyForUser(Yii::$app->user->getId());
$date = isset($_GET['date']) ? $_GET['date'] : null;
if (isset($_GET['date0'])) {
$date0 = $_GET['date0'] . ' 00:00:00';
$date1 = date('Y-m-d 00:00:00', strtotime($_GET['date0'] . ' +1 day'));
//ddump($date1, $date0);
$t = \app\models\transaction\Transaction::find()->where("date BETWEEN '{$date0}' AND '{$date1}'")->andWhere(['user_id' => 2])->all();
$incs = [];
$outs = [];
foreach ($t as $transaction) {
foreach ($transaction->transactionOutgoings as $out) {
if (!isset($outs[$out->account_id])) {
$outs[$out->account_id] = 0;
}
$outs[$out->account_id] += $out->sum;
}
foreach ($transaction->transactionIncomings as $in) {
if (!isset($incs[$in->account_id])) {
$incs[$in->account_id] = 0;
}
$incs[$in->account_id] += $in->sum;
}
}
dump($outs, $incs);
foreach ($models as $m) {
if (!$m->virtual) {
if (isset($outs[$m->id]) || isset($incs[$m->id])) {
echo "Balance for account {$m->title}:";
echo "<br/> Date: " . $m->getBalance($_GET['date0'])->date;
echo "<br/> Sum: " . $m->getBalance($_GET['date0'])->sum;
echo "<br/> +" . (isset($incs[$m->id]) ? $incs[$m->id] : 0);
echo "<br/> -" . (isset($outs[$m->id]) ? $outs[$m->id] : 0);
echo "<br/>";
$b = new Balance();
$b->account_id = $m->id;
$b->date = date('Y-m-d', strtotime($_GET['date0'] . ' +1 day'));
$b->sum = $m->getBalance($_GET['date0'])->sum - (isset($outs[$m->id]) ? $outs[$m->id] : 0) + (isset($incs[$m->id]) ? $incs[$m->id] : 0);
// $b->save();
echo $b->sum;
echo "<br/><br/>";
}
}
}
ddump(9);
}
// $searchModel = new AccountSearch();
// $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
return $this->render('index', ['models' => $models, 'date' => $date]);
}
/**
* Lists all Transaction models.
* @return mixed
*/
public function actionIndex()
{
// $b = new \app\models\account\Balance();
// $b->account_id = 41;
// $b->date = '2015-12-26';
// $b->sum = 20;
// $b->updateFuture(100);
// ddump(0);
$query = Transaction::find()->where(['user_id' => Yii::$app->user->getId()]);
if (isset($_GET['date'])) {
$dt = $_GET['date'];
$query->andWhere("date BETWEEN '" . $dt . " 00:00:00' AND '" . $dt . " 23:59:59'");
}
$dataProvider = new ActiveDataProvider(['query' => $query->orderBy(['date' => SORT_DESC])]);
return $this->render('index', ['dataProvider' => $dataProvider]);
}