Kimai_Database_Mysql::remove_fixed_rate PHP Method

remove_fixed_rate() public method

Remove fixed rate from database.
Author: sl
public remove_fixed_rate ( $projectID, $activityID ) : boolean
$projectID
$activityID
return boolean
    public function remove_fixed_rate($projectID, $activityID)
    {
        // validate input
        if ($projectID == null || !is_numeric($projectID)) {
            $projectID = "NULL";
        }
        if ($activityID == null || !is_numeric($activityID)) {
            $activityID = "NULL";
        }
        $query = "DELETE FROM " . $this->kga['server_prefix'] . "fixedRates 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('remove_fixed_rate');
            return false;
        } else {
            return true;
        }
    }
Kimai_Database_Mysql