PHP BaseController::getFirst方法代码示例

 public function compare()
 {
     // get a list of all months:
     $months = array();
     $first = BaseController::getFirst();
     $first->modify('first day of this month midnight');
     $today = new Carbon('now');
     $today->modify('first day of this month midnight');
     $prev = clone $today;
     $prev->sub(new DateInterval('P2D'));
     $prev->modify('first day of this month midnight');
     while ($first <= $today) {
         $index = $first->format('Y-m-d');
         $months[$index] = $first->format('F Y');
         $first->add(new DateInterval('P1M'));
     }
     // account list:
     $accs = Auth::user()->accounts()->get();
     $accounts = array(0 => '(all accounts)');
     foreach ($accs as $acc) {
         $accounts[intval($acc->id)] = Crypt::decrypt($acc->name);
     }
     $account = Setting::getSetting('defaultCheckingAccount');
     return View::make('pages.compare')->with('months', $months)->with('thisMonth', $today)->with('prevMonth', $prev)->with('account', $account)->with('accounts', $accounts);
 }

 public function averagespending(Carbon $date = null)
 {
     $date = is_null($date) ? Session::get('period') : $date;
     $transactions = floatval($this->transactions()->where(DB::Raw('DATE_FORMAT(`date`,"%m-%Y")'), '!=', $date->format('m-Y'))->where('onetime', '=', 0)->where(DB::Raw('DATE_FORMAT(`date`,"%d")'), '<=', intval($date->format('j')))->sum('amount')) * -1;
     $sum = $transactions;
     $oldest = BaseController::getFirst();
     $diff = $oldest->diff($date);
     $months = $diff->m + 12 * $diff->y;
     return $months > 0 ? $sum / $months : $sum;
 }

 /**
  * Tries to predict how much you'll spend
  * on this day of the month.
  * @param DateTime $date
  */
 public function predict(Carbon $date = null)
 {
     $date = is_null($date) ? Session::get('period') : $date;
     /**
      * select alle transacties, op vandaag (dag > 24)
      * en maand is niet deze (month != 6)
      * en flikker ze op een hoop (sum amount).
      * Gedeeld door aantal maanden bezig nu (5) == antwoord.
      */
     $transactions = $this->transactions()->where(DB::Raw('DATE_FORMAT(`date`,"%d")'), '=', $date->format('d'))->where(DB::Raw('DATE_FORMAT(`date`,"%m")'), '!=', $date->format('m'))->where('amount', '<', 0)->get(array('amount'));
     $sum = 0;
     $first = BaseController::getFirst($this->id);
     $diff = $first->diff($date);
     foreach ($transactions as $t) {
         $sum += floatval($t->amount) * -1;
     }
     $months = $diff->y * 12 + $diff->m;
     return $months > 0 ? $sum / $months : $sum;
 }

 public function predictionChart()
 {
     // in order to predict the future, we look at the past.
     //$baseAccount = ?;
     //$startBalance = ?;
     $setting = Auth::user()->settings()->where('name', '=', 'defaultAmount')->first();
     $balance = intval(Crypt::decrypt($setting->value));
     $account = Auth::user()->accounts()->orderBy('id', 'ASC')->first();
     $debug = Input::get('debug') == 'true' ? true : false;
     $this->_debug = $debug;
     $key = $debug ? cacheKey('prediction', Session::get('period'), rand(1, 10000)) : cacheKey('prediction', Session::get('period'));
     // a setting related to corrections:
     $doCorrect = Setting::getSetting('correctPredictionChart') == 'true' ? true : false;
     if (Cache::has($key)) {
         $data = Cache::get($key);
     } else {
         $data = array('cols' => array(array('id' => 'day', 'label' => 'Day of the month', 'type' => 'string', 'p' => array('role' => 'domain')), array('id' => 'actualbalance', 'label' => 'Current balance', 'type' => 'number', 'p' => array('role' => 'data')), array('type' => 'boolean', 'p' => array('role' => 'certainty')), array('id' => 'predictedbalance', 'label' => 'Predicted balance', 'type' => 'number', 'p' => array('role' => 'data')), array('type' => 'number', 'p' => array('role' => 'interval')), array('type' => 'number', 'p' => array('role' => 'interval'))), 'rows' => array());
         // set the data array:
         // some working vars:
         $first = BaseController::getFirst();
         $this->_e('FIRST is ' . $first->format('d M Y'));
         $today = new Carbon('now');
         $this->_e('Today is ' . $today->format('d M Y'));
         $chartdate = new Carbon('now');
         $chartdate->modify('first day of this month');
         $index = 0;
         $this->_e('');
         $diff = $first->diff($today);
         $months = $diff->y * 12 + $diff->m;
         unset($diff);
         $specificAmount = Auth::user()->settings()->where('name', '=', 'monthlyAmount')->where('date', '=', $today->format('Y-m-d'))->first();
         if ($specificAmount) {
             $balance = floatval(Crypt::decrypt($specificAmount->value));
         }
         $this->_e('Opening balance: ' . $balance);
         // loop over each day of the month:
         $this->_e('start month loop');
         for ($i = 1; $i <= intval($today->format('t')); $i++) {
             $this->_e('Now at day #' . $i);
             // this array will be used to collect average amounts:
             $this->_e('Chartdate is: ' . $chartdate->format('Y-m-d'));
             $this->_e('Today is: ' . $today->format('Y-m-d'));
             if ($doCorrect && $chartdate > $today || !$doCorrect) {
                 $average = array();
                 // loop over each month:
                 // get all transaction results for this day of the month:
                 $transactions = Auth::user()->transactions()->where('amount', '<', 0)->where('onetime', '=', 0)->where(DB::Raw('DATE_FORMAT(`date`,"%e")'), '=', $i)->orderBy('amount', 'ASC')->get();
                 // lets see what we have
                 if (count($transactions) > 0) {
                     $min = floatval($transactions[count($transactions) - 1]->amount) * -1;
                     $max = floatval($transactions[0]->amount) * -1;
                     // fill the array for the averages later on:
                     foreach ($transactions as $t) {
                         //$this->_e('Add to avg['.count($average).'] for transactions: ' . (floatval($t->amount) * -1));
                         $average[] = floatval($t->amount) * -1;
                     }
                 } else {
                     $min = 0;
                     $max = 0;
                 }
                 // calc avg:
                 $avg = $months > 0 ? array_sum($average) / $months : array_sum($average);
                 //$this->_e('New avg: ' . $avg);
                 $this->_e('Max: ' . $max . ', min: ' . $min . ', avg: ' . $avg);
                 $data['rows'][$index]['c'][0]['v'] = $chartdate->format('j F');
                 $data['rows'][$index]['c'][1]['v'] = $account->balance($chartdate);
                 // actual balance
                 if ($chartdate > $today) {
                     $data['rows'][$index]['c'][2]['v'] = false;
                 } else {
                     $data['rows'][$index]['c'][2]['v'] = true;
                 }
                 $data['rows'][$index]['c'][3]['v'] = $balance - $avg;
                 // predicted balance
                 $data['rows'][$index]['c'][4]['v'] = $balance - $max;
                 // predicted max expenses.
                 $data['rows'][$index]['c'][5]['v'] = $balance - $min;
                 // predicted max expenses.
                 $balance = $balance - $avg;
             } else {
                 // don't predict.
                 //$balance = $account->balance($chartdate);
                 $this->_e('No prediction today!');
                 $balance = $account->balance($chartdate);
                 $data['rows'][$index]['c'][0]['v'] = $chartdate->format('j F');
                 $data['rows'][$index]['c'][1]['v'] = $balance;
                 // actual balance
                 $data['rows'][$index]['c'][2]['v'] = true;
                 $data['rows'][$index]['c'][3]['v'] = null;
                 $data['rows'][$index]['c'][4]['v'] = null;
                 $data['rows'][$index]['c'][5]['v'] = null;
             }
             $index++;
             $chartdate->addDay();
             $this->_e(' ');
         }
         Cache::put($key, $data, 1440);
     }
     if ($debug) {
         return '<pre>' . print_r($data, true) . '</pre>';
//.........这里部分代码省略.........

"></div>
            </td>
  <?php 
    }
    ?>
      </table>
    </div>
  </div>
<?php 
}
?>


<?php 
$now = new DateTime('now');
$first = BaseController::getFirst();
$diff = $first->diff($now);
if ($diff->m > 1) {
    ?>
  <div class="row-fluid">
    <div class="span12">
      <h4>Overspending</h4>
      <div id="ovcat"><em>You're doing fine!</em></div>
    </div>
  </div>
<?php 
}
?>
<script src="/js/home.js"></script>
<?php 
require_once __DIR__ . '/../layouts/bottom.php';

 public function overSpending($id)
 {
     $category = Auth::user()->categories()->find($id);
     if ($category) {
         $key = cacheKey('overspending', $id);
         if (Cache::has($key)) {
             $data = Cache::get($key);
         } else {
             $data = array();
             $data['sum'] = 0;
             $period = Session::get('period');
             // let's collect some intel.
             // first: transactions in this category.
             $trans = $category->transactions()->leftJoin('accounts', 'accounts.id', '=', 'account_id')->leftJoin('budgets', 'budgets.id', '=', 'budget_id')->leftJoin('beneficiaries', 'beneficiaries.id', '=', 'beneficiary_id')->where(DB::Raw('DATE_FORMAT(`transactions`.`date`,"%m-%Y")'), '=', $period->format('m-Y'))->orderBy('transactions.date', 'DESC')->get(array('transactions.id', 'transactions.date', 'account_id', 'accounts.name AS account_name', 'budget_id', 'budgets.name AS budget_name', 'beneficiary_id', 'beneficiaries.name AS beneficiary_name', 'transactions.date', 'description', 'transactions.amount', 'onetime'));
             $data['transactions'] = array();
             foreach ($trans as $t) {
                 $tr = array('id' => $t->id, 'date' => new Carbon($t->date), 'account_id' => $t->account_id, 'account_name' => Crypt::decrypt($t->account_name), 'budget_id' => $t->budget_id, 'budget_name' => is_null($t->budget_name) ? null : Crypt::decrypt($t->budget_name), 'beneficiary_id' => $t->beneficiary_id, 'beneficiary_name' => is_null($t->beneficiary_name) ? null : Crypt::decrypt($t->beneficiary_name), 'description' => Crypt::decrypt($t->description), 'amount' => floatval($t->amount) * -1, 'onetime' => $t->onetime == 1 ? true : false);
                 if (!$tr['onetime']) {
                     $data['sum'] += floatval($t->amount) * -1;
                 }
                 $data['transactions'][] = $tr;
             }
             // TODO REMOVE THIS.
             // van elke vorige maand de average.
             // dat getal moet overeen komen met de average uit de grafiek!
             $first = BaseController::getFirst();
             $first->day = intval($period->format('d'));
             $last = BaseController::getLast();
             $last->day = intval($period->format('d'));
             $data['past'] = array();
             $sum = 0;
             // get spending so far for each month:
             while ($first <= $last) {
                 $spent = $category->spent($first);
                 $arr = array('date' => $first->format('F Y'), 'spent' => $spent, 'start_date' => $first->format('Y-m-') . '01', 'end_date' => $first->format('Y-m-t'));
                 $data['past'][] = $arr;
                 if ($first != $last) {
                     $sum += $arr['spent'];
                 }
                 $first->addMonth();
             }
             $data['average'] = $category->averagespending();
             return View::make('categories.overspending')->with('category', $category)->with('data', $data);
         }
     }
 }

 /**
  * Tries to predict how much you'll spend
  * on this day of the month.
  * @param DateTime $date
  */
 public function predict(Carbon $date = null)
 {
     $date = is_null($date) ? Session::get('period') : $date;
     $name = Crypt::decrypt($this->name);
     $similar = array();
     // find likewise budgets:
     foreach (Auth::user()->budgets()->get() as $b) {
         $b->name = Crypt::decrypt($b->name);
         if ($b->name == $name && $b->id != $this->id) {
             $similar[] = intval($b->id);
         }
     }
     if (count($similar) == 0) {
         return 0;
     }
     $similar[] = $this->id;
     /**
      * select alle transacties, na vandaag (dag > 24)
      * en maand is niet deze (month != 6)
      * en flikker ze op een hoop (sum amount).
      * Gedeeld door aantal maanden bezig nu (5) == antwoord.
      */
     $total = Auth::user()->transactions()->where(DB::Raw('DATE_FORMAT(`date`,"%d")'), '=', $date->format('d'))->whereIn('budget_id', $similar)->where('amount', '<', 0)->sum('amount');
     $oldest = BaseController::getFirst();
     $diff = $oldest->diff($date);
     $months = $diff->m + 12 * $diff->y;
     return $months != 0 ? $total * -1 / $months : $total * -1;
 }