Kimai_Database_Mysql::save_fixed_rate PHP Method

    public function save_fixed_rate($projectID, $activityID, $rate)
    {
        // validate input
        if ($projectID == null || !is_numeric($projectID)) {
            $projectID = "NULL";
        }
        if ($activityID == null || !is_numeric($activityID)) {
            $activityID = "NULL";
        }
        if (!is_numeric($rate)) {
            return false;
        }
        // build update or insert statement
        if ($this->get_fixed_rate($projectID, $activityID) === false) {
            $query = "INSERT INTO " . $this->kga['server_prefix'] . "fixedRates VALUES({$projectID}, {$activityID}, {$rate})";
        } else {
            $query = "UPDATE " . $this->kga['server_prefix'] . "fixedRates SET rate = {$rate} WHERE " . ($projectID == "NULL" ? "projectID is NULL" : "projectID = {$projectID}") . " AND " . ($activityID == "NULL" ? "activityID is NULL" : "activityID = {$activityID}");
        }
        $result = $this->conn->Query($query);
        if ($result == false) {
            $this->logLastError('save_fixed_rate');
            return false;
        } else {
            return true;
        }
    }