function updatePercent() { $goal_data = TrainingLog::getItemsForUserForGoalPercent(User::$current_user->uid, $this->start, $this->end); $percents = array(); $percent = 1; if (isset($this->metadata['dist_tot'])) { $percents['dist'] = $goal_data['dist'] / $this->metadata['dist_tot']['value']; } if (isset($this->metadata['pace_avg'])) { $percents['pace'] = $goal_data['pace'] / $goal_data['count'] / $this->metadata['pace_avg']['value']; } if (isset($this->metadata['time_tot'])) { $percents['time'] = $goal_data['time'] / 60.0 / $this->metadata['time_tot']['value']; } var_dump($percents); foreach ($percents as $item) { if ($item <= 1) { $percent = $percent * $item; } } $this->percent = $percent * 100; $stmt = Database::getDB()->prepare("\r\n\t\t\tUPDATE goals\r\n\t\t\tSET go_percent = ?\r\n\t\t\tWHERE go_id = ?\r\n\t\t"); $stmt->bind_param("di", $this->percent, $this->id); $stmt->execute() or die($stmt->error); $stmt->close(); }
public function summary() { RoutingEngine::setPage("runnDAILY Training Summary", "PV__300"); $this_week = new DateRange(); $this_week->getWeekRange(); $data_this_week = TrainingLog::getItemsForUserForGoalPercent(User::$current_user->uid, $this_week->start, $this_week->end); $last_week = new DateRange(); $last_week->getWeekRange("today", -1); $data_last_week = TrainingLog::getItemsForUserForGoalPercent(User::$current_user->uid, $last_week->start, $last_week->end); $overall = TrainingLog::getSummaryOverall(User::$current_user->uid); //var_dump($data_this_week, $data_last_week, $overall); RoutingEngine::getSmarty()->assign("this_week", $this_week); RoutingEngine::getSmarty()->assign("last_week", $last_week); RoutingEngine::getSmarty()->assign("overall", $overall); RoutingEngine::getSmarty()->assign("data_this_week", $data_this_week); RoutingEngine::getSmarty()->assign("data_last_week", $data_last_week); $output = RoutingEngine::getSmarty()->fetch("training/_summary.tpl"); echo $output; die; }