Kimai_Database_Mysql::assign_activityToProjects PHP Method

    public function assign_activityToProjects($activityID, $projectIDs)
    {
        if (!$this->conn->TransactionBegin()) {
            $this->logLastError('assign_activityToProjects');
            return false;
        }
        $table = $this->kga['server_prefix'] . "projects_activities";
        $filter['activityID'] = MySQL::SQLValue($activityID, MySQL::SQLVALUE_NUMBER);
        $d_query = MySQL::BuildSQLDelete($table, $filter);
        $d_result = $this->conn->Query($d_query);
        if ($d_result == false) {
            $this->logLastError('assign_activityToProjects');
            $this->conn->TransactionRollback();
            return false;
        }
        foreach ($projectIDs as $projectID) {
            $values['projectID'] = MySQL::SQLValue($projectID, MySQL::SQLVALUE_NUMBER);
            $values['activityID'] = MySQL::SQLValue($activityID, MySQL::SQLVALUE_NUMBER);
            $query = MySQL::BuildSQLInsert($table, $values);
            $result = $this->conn->Query($query);
            if ($result == false) {
                $this->logLastError('assign_activityToProjects');
                $this->conn->TransactionRollback();
                return false;
            }
        }
        if ($this->conn->TransactionEnd() == true) {
            return true;
        } else {
            $this->logLastError('assign_activityToProjects');
            return false;
        }
    }